eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_HOLDS_PUB dependencies on OE_MSG_PUB

Line 48: OE_MSG_PUB.ADD;

44: EXCEPTION
45: WHEN no_data_found then
46: --x_return_status := FND_API.G_RET_STS_ERROR;
47: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_SITE_USE_ID');
48: OE_MSG_PUB.ADD;
49: fnd_message.set_token('SITE_USE_ID',
50: to_char(p_hold_entity_id));
51: IF l_debug_level > 0 THEN
52: oe_debug_pub.add( 'HOLD_SITE_CODE:INVALID SITE USE ID' , 1 ) ;

Line 167: OE_MSG_PUB.Count_And_Get

163: x_return_status := FND_API.G_RET_STS_ERROR ;
164: IF l_debug_level > 0 THEN
165: oe_debug_pub.add( 'EXPECTED ERROR IN UPDATE_HOLD_COMMENTS ; ' ) ;
166: END IF;
167: OE_MSG_PUB.Count_And_Get
168: ( p_count => x_msg_count,
169: p_data => x_msg_data
170: );
171:

Line 177: OE_MSG_PUB.Count_And_Get

173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
174: IF l_debug_level > 0 THEN
175: oe_debug_pub.add( 'EXPECTED ERROR IN UPDATE_HOLD_COMMENTS ; ' ) ;
176: END IF;
177: OE_MSG_PUB.Count_And_Get
178: ( p_count => x_msg_count,
179: p_data => x_msg_data
180: );
181:

Line 187: IF OE_MSG_PUB.Check_Msg_Level

183: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
184: IF l_debug_level > 0 THEN
185: oe_debug_pub.add( 'EXPECTED ERROR IN UPDATE_HOLD_COMMENTS ; ' ) ;
186: END IF;
187: IF OE_MSG_PUB.Check_Msg_Level
188: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
189: THEN
190: OE_MSG_PUB.Add_Exc_Msg
191: (G_PKG_NAME,

Line 188: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

184: IF l_debug_level > 0 THEN
185: oe_debug_pub.add( 'EXPECTED ERROR IN UPDATE_HOLD_COMMENTS ; ' ) ;
186: END IF;
187: IF OE_MSG_PUB.Check_Msg_Level
188: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
189: THEN
190: OE_MSG_PUB.Add_Exc_Msg
191: (G_PKG_NAME,
192: l_api_name

Line 190: OE_MSG_PUB.Add_Exc_Msg

186: END IF;
187: IF OE_MSG_PUB.Check_Msg_Level
188: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
189: THEN
190: OE_MSG_PUB.Add_Exc_Msg
191: (G_PKG_NAME,
192: l_api_name
193: );
194: END IF;

Line 195: OE_MSG_PUB.Count_And_Get

191: (G_PKG_NAME,
192: l_api_name
193: );
194: END IF;
195: OE_MSG_PUB.Count_And_Get
196: ( p_count => x_msg_count,
197: p_data => x_msg_data);
198:
199:

Line 302: OE_MSG_PUB.Count_And_Get

298: end loop;
299:
300: l_return_status := FND_API.G_RET_STS_SUCCESS;
301: -- Get message count and data
302: OE_MSG_PUB.Count_And_Get
303: ( p_count => l_msg_count
304: , p_data => l_msg_data
305: );
306:

Line 311: OE_MSG_PUB.Count_And_Get

307: EXCEPTION /* Procedure exception handler */
308:
309: WHEN FND_API.G_EXC_ERROR THEN
310: l_return_status := FND_API.G_RET_STS_ERROR ;
311: OE_MSG_PUB.Count_And_Get
312: ( p_count => l_msg_count,
313: p_data => l_msg_data
314: );
315:

Line 318: OE_MSG_PUB.Count_And_Get

314: );
315:
316: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
317: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
318: OE_MSG_PUB.Count_And_Get
319: ( p_count => l_msg_count,
320: p_data => l_msg_data
321: );
322:

Line 325: IF OE_MSG_PUB.Check_Msg_Level

321: );
322:
323: WHEN OTHERS THEN
324: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
325: IF OE_MSG_PUB.Check_Msg_Level
326: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
327: THEN
328: OE_MSG_PUB.Add_Exc_Msg
329: (G_PKG_NAME,

Line 326: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

322:
323: WHEN OTHERS THEN
324: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
325: IF OE_MSG_PUB.Check_Msg_Level
326: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
327: THEN
328: OE_MSG_PUB.Add_Exc_Msg
329: (G_PKG_NAME,
330: l_api_name

Line 328: OE_MSG_PUB.Add_Exc_Msg

324: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
325: IF OE_MSG_PUB.Check_Msg_Level
326: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
327: THEN
328: OE_MSG_PUB.Add_Exc_Msg
329: (G_PKG_NAME,
330: l_api_name
331: );
332: END IF;

Line 333: OE_MSG_PUB.Count_And_Get

329: (G_PKG_NAME,
330: l_api_name
331: );
332: END IF;
333: OE_MSG_PUB.Count_And_Get
334: ( p_count => l_msg_count,
335: p_data => l_msg_data);
336:
337: END release_expired_holds;

Line 521: OE_MSG_PUB.ADD;

517:
518: EXCEPTION
519: WHEN FND_API.G_EXC_ERROR THEN
520: FND_MESSAGE.SET_NAME('ONT', 'OE_ENTITY_NOT_ON_ORDER_OR_LINE');
521: OE_MSG_PUB.ADD;
522: IF l_debug_level > 0 THEN
523: oe_debug_pub.add( 'EXPECTED ERROR IN VALIDATEORDER' ) ;
524: END IF;
525: x_return_status := FND_API.G_RET_STS_ERROR;

Line 832: OE_MSG_PUB.ADD;

828: for j in 1..p_order_tbl.COUNT loop
829: if p_order_tbl(j).header_id is NULL AND
830: p_order_tbl(j).line_id is NULL THEN
831: FND_MESSAGE.SET_NAME('ONT', 'OE_ENTER_HEADER_OR_LINE_ID');
832: OE_MSG_PUB.ADD;
833: RAISE FND_API.G_EXC_ERROR;
834: ELSIF p_order_tbl(j).header_id is NULL THEN
835: SELECT header_id
836: INTO l_header_id

Line 997: OE_MSG_PUB.ADD;

993: oe_debug_pub.add( 'INVALID HOLD SOURCE ID' ) ;
994: END IF;
995: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_HOLD_SOURCE_ID');
996: FND_MESSAGE.SET_TOKEN('HOLD_SOURCE_ID' , p_hold_source_id);
997: OE_MSG_PUB.ADD;
998: RAISE FND_API.G_EXC_ERROR;
999: END;
1000:
1001: -- END IF;

Line 1010: OE_MSG_PUB.ADD;

1006: ELSE
1007: -- Check for Missing Values
1008: IF p_hold_source_rec.hold_id IS NULL THEN
1009: FND_MESSAGE.SET_NAME('ONT', 'OE_MISSING_HOLD_ID');
1010: OE_MSG_PUB.ADD;
1011: RAISE FND_API.G_EXC_ERROR;
1012: END IF;
1013:
1014: IF p_hold_source_rec.hold_entity_code IS NULL THEN

Line 1016: OE_MSG_PUB.ADD;

1012: END IF;
1013:
1014: IF p_hold_source_rec.hold_entity_code IS NULL THEN
1015: FND_MESSAGE.SET_NAME('ONT', 'OE_MISSING_ENTITY_CODE');
1016: OE_MSG_PUB.ADD;
1017: RAISE FND_API.G_EXC_ERROR;
1018: END IF;
1019:
1020: IF p_hold_source_rec.hold_entity_id IS NULL THEN

Line 1022: OE_MSG_PUB.ADD;

1018: END IF;
1019:
1020: IF p_hold_source_rec.hold_entity_id IS NULL THEN
1021: FND_MESSAGE.SET_NAME('ONT', 'OE_MISSING_ENTITY_ID');
1022: OE_MSG_PUB.ADD;
1023: RAISE FND_API.G_EXC_ERROR;
1024: END IF;
1025: -- NOTE: No need to check for HOLD_ENTITY_CODE2 and HOLD_ENTITY_ID2
1026: -- cos, its optional.

Line 1046: OE_MSG_PUB.ADD;

1042: /*
1043: IF p_hold_source_rec.hold_entity_code = 'O' THEN
1044: IF p_line_id IS NULL AND p_header_id IS NULL THEN
1045: FND_MESSAGE.SET_NAME('ONT', 'OE_ENTER_HEADER_OR_LINE_ID');
1046: OE_MSG_PUB.ADD;
1047: RAISE FND_API.G_EXC_ERROR;
1048: ELSIF p_header_id IS NULL THEN
1049: SELECT header_id
1050: INTO l_header_id

Line 1073: OE_MSG_PUB.ADD;

1069: AND ROWNUM = 1;
1070:
1071: IF (sql%found) THEN
1072: FND_MESSAGE.SET_NAME('ONT', 'OE_DUPLICATE_HOLD');
1073: OE_MSG_PUB.ADD;
1074: OE_Debug_PUB.Add('Duplicate Hold');
1075: RAISE FND_API.G_EXC_ERROR;
1076: END IF;
1077: EXCEPTION

Line 1765: OE_MSG_PUB.ADD;

1761: -- Check for Missing Input Parameters
1762: IF p_header_id IS NULL AND p_line_id IS NULL THEN
1763:
1764: FND_MESSAGE.SET_NAME('ONT', 'OE_ENTER_HEADER_OR_LINE_ID');
1765: OE_MSG_PUB.ADD;
1766: RAISE FND_API.G_EXC_ERROR;
1767:
1768: END IF;
1769:

Line 2265: OE_MSG_PUB.ADD;

2261: oe_debug_pub.add( 'ENTER HOLD_ENTITY_CODE OR HOLD_ENTITY_ID' ) ;
2262: END IF;
2263: /* TO_DO: Seed a more meaningfull message */
2264: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ENTITY_CONBINATION');
2265: OE_MSG_PUB.ADD;
2266: RAISE FND_API.G_EXC_ERROR;
2267:
2268: END IF;
2269:

Line 2459: OE_MSG_PUB.ADD;

2455:
2456: EXCEPTION
2457: WHEN NO_DATA_FOUND THEN
2458: FND_MESSAGE.SET_NAME('ONT', 'OE_MISSING_HOLD_SOURCE');
2459: OE_MSG_PUB.ADD;
2460: RAISE FND_API.G_EXC_ERROR;
2461: WHEN OTHERS THEN
2462: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2463: END;

Line 2470: OE_MSG_PUB.ADD;

2466: OPEN order_hold;
2467: FETCH order_hold INTO l_order_hold_id;
2468: IF order_hold%notfound THEN
2469: FND_MESSAGE.SET_NAME('ONT', 'OE_MISSING_HOLD');
2470: OE_MSG_PUB.ADD;
2471: RAISE FND_API.G_EXC_ERROR;
2472: END IF;
2473: CLOSE order_hold;
2474:

Line 2487: OE_MSG_PUB.ADD;

2483: END IF;
2484: -- Check for Missing Values
2485: IF p_hold_id IS NULL THEN
2486: FND_MESSAGE.SET_NAME('ONT', 'OE_MISSING_HOLD_ID');
2487: OE_MSG_PUB.ADD;
2488: RAISE FND_API.G_EXC_ERROR;
2489: END IF;
2490:
2491: IF p_entity_code IS NULL THEN

Line 2493: OE_MSG_PUB.ADD;

2489: END IF;
2490:
2491: IF p_entity_code IS NULL THEN
2492: FND_MESSAGE.SET_NAME('ONT', 'OE_MISSING_ENTITY_CODE');
2493: OE_MSG_PUB.ADD;
2494: RAISE FND_API.G_EXC_ERROR;
2495: ELSE
2496: l_entity_code := p_entity_code;
2497: END IF;

Line 2501: OE_MSG_PUB.ADD;

2497: END IF;
2498:
2499: IF p_entity_id IS NULL THEN
2500: FND_MESSAGE.SET_NAME('ONT', 'OE_MISSING_ENTITY_ID');
2501: OE_MSG_PUB.ADD;
2502: RAISE FND_API.G_EXC_ERROR;
2503: END IF;
2504:
2505: /*

Line 2508: OE_MSG_PUB.ADD;

2504:
2505: /*
2506: IF p_line_id IS NULL AND p_header_id IS NULL THEN
2507: FND_MESSAGE.SET_NAME('ONT', 'OE_MISSING_HEADER_AND_LINE_ID');
2508: OE_MSG_PUB.ADD;
2509: RAISE FND_API.G_EXC_ERROR;
2510: END IF;
2511: */
2512:

Line 2519: OE_MSG_PUB.ADD;

2515: OPEN hold_source;
2516: FETCH hold_source INTO l_hold_source_id, l_order_hold_id;
2517: IF hold_source%notfound THEN
2518: FND_MESSAGE.SET_NAME('ONT', 'OE_MISSING_HOLD');
2519: OE_MSG_PUB.ADD;
2520: RAISE FND_API.G_EXC_ERROR;
2521: END IF;
2522: CLOSE hold_source;
2523: */

Line 2677: OE_MSG_PUB.ADD;

2673: IF (p_header_id = FND_API.G_MISS_NUM AND
2674: p_line_id = FND_API.G_MISS_NUM) THEN
2675:
2676: FND_MESSAGE.SET_NAME('ONT', 'OE_ENTER_HEADER_OR_LINE_ID');
2677: OE_MSG_PUB.ADD;
2678: RAISE FND_API.G_EXC_ERROR;
2679:
2680: END IF;
2681:

Line 3187: --OE_MSG_PUB.ADD;

3183: oe_debug_pub.add( 'HOLD REMOVED' ) ;
3184: END IF;
3185: END IF; --ER#7479609
3186: --fnd_message.set_name('ONT','OE_HOLD_REMOVED');
3187: --OE_MSG_PUB.ADD;
3188: END LOOP;
3189: CLOSE prev_hold;
3190:
3191: -- prev_hold_entity2

Line 3253: --OE_MSG_PUB.ADD;

3249: oe_debug_pub.add( 'HOLD REMOVED FOR SECOND ENTITY' ) ;
3250: END IF;
3251: END IF; --ER#7479609
3252: --fnd_message.set_name('ONT','OE_HOLD_REMOVED');
3253: --OE_MSG_PUB.ADD;
3254: END LOOP;
3255: CLOSE prev_hold_entity2;
3256:
3257: end if; -- p_hold_entity_code in ('C','S','B','W')

Line 3614: OE_MSG_PUB.ADD;

3610:
3611: IF p_entity_code = OE_Globals.G_ENTITY_HEADER THEN
3612: fnd_message.set_name('ONT','OE_HLD_APPLIED');
3613: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
3614: OE_MSG_PUB.ADD;
3615: --ER#7479609 ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN
3616: ELSIF (p_entity_code = OE_Globals.G_ENTITY_LINE OR
3617: p_entity_code = OE_GLOBALS.G_ENTITY_LINE_PAYMENT) THEN
3618: fnd_message.set_name('ONT','OE_HLD_APPLIED_LINE');

Line 3627: OE_MSG_PUB.ADD;

3623: -- FROM OE_ORDER_LINES
3624: -- WHERE LINE_ID = p_entity_id;
3625: --FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_number);
3626: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_number);
3627: OE_MSG_PUB.ADD;
3628: END IF;
3629: END IF; -- if create_order_hold was successful
3630: END IF; -- l_create_order_hold_flag = 'Y'
3631: END LOOP;

Line 3883: OE_MSG_PUB.ADD;

3879:
3880: IF p_entity_code = OE_Globals.G_ENTITY_HEADER THEN
3881: fnd_message.set_name('ONT','OE_HLD_APPLIED');
3882: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
3883: OE_MSG_PUB.ADD;
3884: --ER#7479609 ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN
3885: ELSIF (p_entity_code = OE_Globals.G_ENTITY_LINE OR
3886: p_entity_code = OE_GLOBALS.G_ENTITY_LINE_PAYMENT) THEN --ER#7479609
3887: fnd_message.set_name('ONT','OE_HLD_APPLIED_LINE');

Line 3896: OE_MSG_PUB.ADD;

3892: -- FROM OE_ORDER_LINES
3893: -- WHERE LINE_ID = p_entity_id;
3894: --FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_number);
3895: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_number);
3896: OE_MSG_PUB.ADD;
3897: END IF;
3898: END IF; -- if apply hold was successful
3899: END IF; -- l_create_order_hold_flag = 'Y'
3900: END LOOP;

Line 3937: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3933: CLOSE curr_hold_source;
3934: END IF;
3935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3936:
3937: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3938: THEN
3939: OE_MSG_PUB.Add_Exc_Msg
3940: ( G_PKG_NAME
3941: , 'evaluate_holds'

Line 3939: OE_MSG_PUB.Add_Exc_Msg

3935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3936:
3937: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3938: THEN
3939: OE_MSG_PUB.Add_Exc_Msg
3940: ( G_PKG_NAME
3941: , 'evaluate_holds'
3942: );
3943: END IF;

Line 4106: OE_MSG_PUB.ADD;

4102:
4103:
4104: fnd_message.set_name('ONT','OE_HLD_APPLIED');
4105: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
4106: OE_MSG_PUB.ADD;
4107: END IF; -- if create_order_hold was successful
4108: END LOOP;
4109: CLOSE curr_hold_source;
4110: END IF; /* IF m_hold_entity_id IS NOT NULL THEN */

Line 4136: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4132: CLOSE curr_hold_source;
4133: END IF;
4134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4135:
4136: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4137: THEN
4138: OE_MSG_PUB.Add_Exc_Msg
4139: ( G_PKG_NAME
4140: , 'eval_post_write_header'

Line 4138: OE_MSG_PUB.Add_Exc_Msg

4134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4135:
4136: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4137: THEN
4138: OE_MSG_PUB.Add_Exc_Msg
4139: ( G_PKG_NAME
4140: , 'eval_post_write_header'
4141: );
4142: END IF;

Line 4785: OE_MSG_PUB.ADD;

4781:
4782: IF p_entity_code = OE_Globals.G_ENTITY_HEADER THEN
4783: fnd_message.set_name('ONT','OE_HLD_APPLIED');
4784: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
4785: OE_MSG_PUB.ADD;
4786: ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN
4787: fnd_message.set_name('ONT','OE_HLD_APPLIED_LINE');
4788: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
4789: --ER#7479609 FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_number);

Line 4791: OE_MSG_PUB.ADD;

4787: fnd_message.set_name('ONT','OE_HLD_APPLIED_LINE');
4788: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
4789: --ER#7479609 FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_number);
4790: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_rec.line_number); --ER#7479609
4791: OE_MSG_PUB.ADD;
4792: END IF;
4793:
4794: END IF; -- if create_order_hold was successful
4795: END IF; -- l_create_order_hold_flag = 'Y'

Line 4913: OE_MSG_PUB.ADD;

4909:
4910: IF p_entity_code = OE_Globals.G_ENTITY_HEADER THEN
4911: fnd_message.set_name('ONT','OE_HLD_APPLIED');
4912: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
4913: OE_MSG_PUB.ADD;
4914: ELSIF p_entity_code = OE_Globals.G_ENTITY_LINE THEN
4915: fnd_message.set_name('ONT','OE_HLD_APPLIED_LINE');
4916: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',l_attribute);
4917: -- Get the line number from the line record

Line 4924: OE_MSG_PUB.ADD;

4920: -- FROM OE_ORDER_LINES
4921: -- WHERE LINE_ID = p_entity_id;
4922: --FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_number);
4923: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_number);
4924: OE_MSG_PUB.ADD;
4925: END IF;
4926: END IF; -- if apply hold was successful
4927: END IF; -- l_create_order_hold_flag = 'Y'
4928: END LOOP;

Line 4957: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4953: CLOSE curr_hold_source;
4954: END IF;
4955: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4956:
4957: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4958: THEN
4959: OE_MSG_PUB.Add_Exc_Msg
4960: ( G_PKG_NAME
4961: , 'evaluate_holds_post_write'

Line 4959: OE_MSG_PUB.Add_Exc_Msg

4955: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4956:
4957: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4958: THEN
4959: OE_MSG_PUB.Add_Exc_Msg
4960: ( G_PKG_NAME
4961: , 'evaluate_holds_post_write'
4962: );
4963: END IF;

Line 5173: OE_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

5169: IF l_debug_level > 0 THEN
5170: oe_debug_pub.add( 'API EXECUTION ERROR IN OE_HOLDS_PUB.Process_Holds_Customer' , 1 ) ;
5171: END IF;
5172: IF x_msg_count is not null then
5173: OE_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
5174: p_data => x_msg_data);
5175: end if;
5176: RAISE FND_API.G_EXC_ERROR;
5177:

Line 5183: OE_MSG_PUB.Count_And_Get

5179: IF l_debug_level > 0 THEN
5180: oe_debug_pub.add( 'API UNEXPECTED ERROR IN OE_HOLDS_PUB.Process_Holds_Customer' , 1 ) ;
5181: END IF;
5182: IF x_msg_count is not null then
5183: OE_MSG_PUB.Count_And_Get
5184: ( p_count => x_msg_count
5185: , p_data => x_msg_data
5186: );
5187: END IF;

Line 5246: OE_MSG_PUB.ADD;

5242: EXCEPTION
5243: WHEN no_data_found then
5244: --x_return_status := FND_API.G_RET_STS_ERROR;
5245: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_SITE_USE_ID');
5246: OE_MSG_PUB.ADD;
5247: fnd_message.set_token('SITE_USE_ID', to_char(p_hold_entity_id));
5248:
5249: RAISE FND_API.G_EXC_ERROR;
5250: END;

Line 5313: OE_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

5309: oe_debug_pub.add( 'API EXECUTION ERROR IN OE_HOLDS_PUB.PROCESS_HOLDS' , 1 ) ;
5310: END IF;
5311:
5312: IF x_msg_count is not null then
5313: OE_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
5314: p_data => x_msg_data);
5315: end if;
5316:
5317: RAISE FND_API.G_EXC_ERROR;

Line 5391: OE_MSG_PUB.ADD;

5387:
5388: IF p_action IS NULL OR p_action NOT IN ('APPLY','RELEASE') THEN
5389: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ACTION'); -- message taken from oe_holds
5390: fnd_message.set_token('ACTION',p_action);
5391: OE_MSG_PUB.ADD;
5392: RAISE FND_API.G_EXC_ERROR;
5393: END IF;
5394:
5395: IF p_hold_entity_code IS NULL OR p_hold_entity_code NOT IN ('S','C') THEN

Line 5397: OE_MSG_PUB.ADD;

5393: END IF;
5394:
5395: IF p_hold_entity_code IS NULL OR p_hold_entity_code NOT IN ('S','C') THEN
5396: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_HOLD_ENTITY_CODE'); -- message need to be seeded or use any existing one
5397: OE_MSG_PUB.ADD;
5398: RAISE FND_API.G_EXC_ERROR;
5399: END IF;
5400: -- hold the original org id being used by programs when calling process_holds.
5401: -- set the org org context to this original org when leaving process_holds.

Line 5441: OE_MSG_PUB.ADD;

5437:
5438: IF l_valid_acct <> 'Y' THEN
5439: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_CUST_ACCOUNT'); -- get the correct message new or existing??
5440: -- fnd_message.set_token('',p_action);
5441: OE_MSG_PUB.ADD;
5442: RAISE FND_API.G_EXC_ERROR;
5443: END IF;
5444:
5445: -- call process_holds_customer

Line 5494: OE_MSG_PUB.Count_And_Get ( p_count => l_msg_count,

5490: x_return_status := l_return_status;
5491: x_msg_count := l_msg_count;
5492: x_msg_data := l_msg_data;
5493: IF l_msg_count is not null then
5494: OE_MSG_PUB.Count_And_Get ( p_count => l_msg_count,
5495: p_data => l_msg_data);
5496: end if;
5497:
5498: IF l_debug_level > 0 THEN