APPS.OE_SCHEDULE_UTIL dependencies on OE_MSG_PUB

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

185:
186: EXCEPTION
187:
188: WHEN OTHERS THEN
189: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
190: THEN
191: OE_MSG_PUB.Add_Exc_Msg
192: ( G_PKG_NAME
193: , 'oe_schedule_util.validate_ship_method'

Line 191: OE_MSG_PUB.Add_Exc_Msg

187:
188: WHEN OTHERS THEN
189: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
190: THEN
191: OE_MSG_PUB.Add_Exc_Msg
192: ( G_PKG_NAME
193: , 'oe_schedule_util.validate_ship_method'
194: );
195: END IF;

Line 241: Oe_Msg_Pub.Add;

237: IF l_debug_level > 0 THEN
238: oe_debug_pub.add( 'LAD VIOLATED ' , 1 ) ;
239: END IF;
240: Fnd_Message.set_name('ONT','ONT_SCH_LAD_VIOLATE');
241: Oe_Msg_Pub.Add;
242: END IF;
243: /* -- 3349770 this will be only validated when user enters manually.
244: ELSIF l_lad_flag = 'H' THEN
245: IF ((l_order_date_type_code = 'SHIP'

Line 255: Oe_Msg_Pub.Add;

251: IF l_debug_level > 0 THEN
252: oe_debug_pub.add( 'SCHEDULE DATE EXCEEDS LAD ' , 1 ) ;
253: END IF;
254: Fnd_Message.set_name('ONT','ONT_SCH_LAD_SCH_FAILED');
255: Oe_Msg_Pub.Add;
256: RAISE FND_API.G_EXC_ERROR;
257: END IF;
258: */
259: END IF;

Line 895: OE_MSG_PUB.Add;

891: EXCEPTION
892: WHEN OTHERS THEN
893: x_return_status := FND_API.G_RET_STS_ERROR;
894: fnd_message.set_name('ONT', 'OE_INVALID_ITEM_WHSE');
895: OE_MSG_PUB.Add;
896: END;
897:
898: IF l_revision_code = 2
899: OR l_lot_code = 2

Line 903: OE_MSG_PUB.Add;

899: OR l_lot_code = 2
900: THEN
901: -- 2 == YES
902: FND_MESSAGE.SET_NAME('ONT', 'OE_SUBINV_NOT_ALLOWED');
903: OE_MSG_PUB.Add;
904: IF p_line_rec.Schedule_action_code = OESCH_ACT_RESERVE THEN
905: x_return_status := FND_API.G_RET_STS_ERROR;
906: RAISE FND_API.G_EXC_ERROR;
907: ELSE

Line 995: -- oe_msg_pub.transfer_msg_stack;

991:
992: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
993: -- 4091185
994: -- Messages are being handled in exceptions block
995: -- oe_msg_pub.transfer_msg_stack;
996: -- l_msg_count:=OE_MSG_PUB.COUNT_MSG;
997: -- for I in 1..l_msg_count loop
998: -- l_msg_data := OE_MSG_PUB.Get(I,'F');
999: -- IF l_debug_level > 0 THEN

Line 996: -- l_msg_count:=OE_MSG_PUB.COUNT_MSG;

992: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
993: -- 4091185
994: -- Messages are being handled in exceptions block
995: -- oe_msg_pub.transfer_msg_stack;
996: -- l_msg_count:=OE_MSG_PUB.COUNT_MSG;
997: -- for I in 1..l_msg_count loop
998: -- l_msg_data := OE_MSG_PUB.Get(I,'F');
999: -- IF l_debug_level > 0 THEN
1000: -- oe_debug_pub.add( L_MSG_DATA , 1 ) ;

Line 998: -- l_msg_data := OE_MSG_PUB.Get(I,'F');

994: -- Messages are being handled in exceptions block
995: -- oe_msg_pub.transfer_msg_stack;
996: -- l_msg_count:=OE_MSG_PUB.COUNT_MSG;
997: -- for I in 1..l_msg_count loop
998: -- l_msg_data := OE_MSG_PUB.Get(I,'F');
999: -- IF l_debug_level > 0 THEN
1000: -- oe_debug_pub.add( L_MSG_DATA , 1 ) ;
1001: -- END IF;
1002: -- end loop;

Line 1006: oe_msg_pub.transfer_msg_stack(p_type => 'WARNING');

1002: -- end loop;
1003: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1004: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1005: -- 4091185
1006: oe_msg_pub.transfer_msg_stack(p_type => 'WARNING');
1007: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
1008: for I in 1..l_msg_count loop
1009: l_msg_data := OE_MSG_PUB.Get(I,'F');
1010: IF l_debug_level > 0 THEN

Line 1007: l_msg_count:=OE_MSG_PUB.COUNT_MSG;

1003: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1004: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1005: -- 4091185
1006: oe_msg_pub.transfer_msg_stack(p_type => 'WARNING');
1007: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
1008: for I in 1..l_msg_count loop
1009: l_msg_data := OE_MSG_PUB.Get(I,'F');
1010: IF l_debug_level > 0 THEN
1011: oe_debug_pub.add( L_MSG_DATA , 1 ) ;

Line 1009: l_msg_data := OE_MSG_PUB.Get(I,'F');

1005: -- 4091185
1006: oe_msg_pub.transfer_msg_stack(p_type => 'WARNING');
1007: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
1008: for I in 1..l_msg_count loop
1009: l_msg_data := OE_MSG_PUB.Get(I,'F');
1010: IF l_debug_level > 0 THEN
1011: oe_debug_pub.add( L_MSG_DATA , 1 ) ;
1012: END IF;
1013: end loop;

Line 1038: oe_msg_pub.transfer_msg_stack;

1034:
1035: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1036: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1037:
1038: oe_msg_pub.transfer_msg_stack;
1039: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
1040: for I in 1..l_msg_count loop
1041: l_msg_data := OE_MSG_PUB.Get(I,'F');
1042: -- 4091185

Line 1039: l_msg_count:=OE_MSG_PUB.COUNT_MSG;

1035: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1036: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1037:
1038: oe_msg_pub.transfer_msg_stack;
1039: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
1040: for I in 1..l_msg_count loop
1041: l_msg_data := OE_MSG_PUB.Get(I,'F');
1042: -- 4091185
1043: -- oe_msg_pub.transfer_msg_stack has already added messages.

Line 1041: l_msg_data := OE_MSG_PUB.Get(I,'F');

1037:
1038: oe_msg_pub.transfer_msg_stack;
1039: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
1040: for I in 1..l_msg_count loop
1041: l_msg_data := OE_MSG_PUB.Get(I,'F');
1042: -- 4091185
1043: -- oe_msg_pub.transfer_msg_stack has already added messages.
1044: -- oe_msg_pub.add_text(l_msg_data);
1045: IF l_debug_level > 0 THEN

Line 1043: -- oe_msg_pub.transfer_msg_stack has already added messages.

1039: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
1040: for I in 1..l_msg_count loop
1041: l_msg_data := OE_MSG_PUB.Get(I,'F');
1042: -- 4091185
1043: -- oe_msg_pub.transfer_msg_stack has already added messages.
1044: -- oe_msg_pub.add_text(l_msg_data);
1045: IF l_debug_level > 0 THEN
1046: oe_debug_pub.add( 'INV : ' || L_MSG_DATA , 2 ) ;
1047: END IF;

Line 1044: -- oe_msg_pub.add_text(l_msg_data);

1040: for I in 1..l_msg_count loop
1041: l_msg_data := OE_MSG_PUB.Get(I,'F');
1042: -- 4091185
1043: -- oe_msg_pub.transfer_msg_stack has already added messages.
1044: -- oe_msg_pub.add_text(l_msg_data);
1045: IF l_debug_level > 0 THEN
1046: oe_debug_pub.add( 'INV : ' || L_MSG_DATA , 2 ) ;
1047: END IF;
1048: end loop;

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

1049:
1050: WHEN OTHERS THEN
1051: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1052:
1053: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1054: THEN
1055: OE_MSG_PUB.Add_Exc_Msg
1056: ( G_PKG_NAME
1057: , 'Reserve_line'

Line 1055: OE_MSG_PUB.Add_Exc_Msg

1051: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1052:
1053: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1054: THEN
1055: OE_MSG_PUB.Add_Exc_Msg
1056: ( G_PKG_NAME
1057: , 'Reserve_line'
1058: );
1059: END IF;

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

1147:
1148: WHEN OTHERS THEN
1149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1150:
1151: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1152: THEN
1153: OE_MSG_PUB.Add_Exc_Msg
1154: ( G_PKG_NAME
1155: , 'Unreserve_line'

Line 1153: OE_MSG_PUB.Add_Exc_Msg

1149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1150:
1151: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1152: THEN
1153: OE_MSG_PUB.Add_Exc_Msg
1154: ( G_PKG_NAME
1155: , 'Unreserve_line'
1156: );
1157: END IF;

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

1357: WHEN OTHERS THEN
1358:
1359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1360:
1361: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1362: THEN
1363: OE_MSG_PUB.Add_Exc_Msg
1364: ( G_PKG_NAME,
1365: 'Log_Delete_Set_Request');

Line 1363: OE_MSG_PUB.Add_Exc_Msg

1359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1360:
1361: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1362: THEN
1363: OE_MSG_PUB.Add_Exc_Msg
1364: ( G_PKG_NAME,
1365: 'Log_Delete_Set_Request');
1366: END IF;
1367: END Log_Delete_Set_Request;

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

2046: WHEN OTHERS THEN
2047:
2048: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2049:
2050: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2051: THEN
2052: OE_MSG_PUB.Add_Exc_Msg
2053: ( G_PKG_NAME,
2054: 'Log_Set_Request');

Line 2052: OE_MSG_PUB.Add_Exc_Msg

2048: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2049:
2050: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2051: THEN
2052: OE_MSG_PUB.Add_Exc_Msg
2053: ( G_PKG_NAME,
2054: 'Log_Set_Request');
2055: END IF;
2056: END Log_Set_Request;

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

2154: EXCEPTION
2155:
2156: WHEN OTHERS THEN
2157:
2158: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2159: THEN
2160: OE_MSG_PUB.Add_Exc_Msg
2161: ( G_PKG_NAME,
2162: 'Schedule_Attribute_Changed');

Line 2160: OE_MSG_PUB.Add_Exc_Msg

2156: WHEN OTHERS THEN
2157:
2158: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2159: THEN
2160: OE_MSG_PUB.Add_Exc_Msg
2161: ( G_PKG_NAME,
2162: 'Schedule_Attribute_Changed');
2163: END IF;
2164: END Schedule_Attribute_Changed;

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

2399: WHEN OTHERS THEN
2400:
2401: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2402:
2403: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2404: THEN
2405:
2406: OE_MSG_PUB.Add_Exc_Msg
2407: (G_PKG_NAME,

Line 2406: OE_MSG_PUB.Add_Exc_Msg

2402:
2403: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2404: THEN
2405:
2406: OE_MSG_PUB.Add_Exc_Msg
2407: (G_PKG_NAME,
2408: 'Inactive_Demand_Scheduling');
2409: END IF;
2410:

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

2496: EXCEPTION
2497:
2498: WHEN OTHERS THEN
2499:
2500: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2501: THEN
2502: OE_MSG_PUB.Add_Exc_Msg
2503: ( G_PKG_NAME,
2504: 'Initialize_mrp_record');

Line 2502: OE_MSG_PUB.Add_Exc_Msg

2498: WHEN OTHERS THEN
2499:
2500: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2501: THEN
2502: OE_MSG_PUB.Add_Exc_Msg
2503: ( G_PKG_NAME,
2504: 'Initialize_mrp_record');
2505: END IF;
2506: END Initialize_mrp_record;

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

3500:
3501: Raise FND_API.G_EXC_ERROR;
3502: WHEN OTHERS THEN
3503:
3504: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3505: THEN
3506: OE_MSG_PUB.Add_Exc_Msg
3507: ( G_PKG_NAME,
3508: 'Load_MRP_request');

Line 3506: OE_MSG_PUB.Add_Exc_Msg

3502: WHEN OTHERS THEN
3503:
3504: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3505: THEN
3506: OE_MSG_PUB.Add_Exc_Msg
3507: ( G_PKG_NAME,
3508: 'Load_MRP_request');
3509: END IF;
3510:

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

3572: Raise FND_API.G_EXC_ERROR;
3573:
3574: WHEN OTHERS THEN
3575:
3576: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3577: THEN
3578: OE_MSG_PUB.Add_Exc_Msg
3579: ( G_PKG_NAME,
3580: 'Log_Set_Request');

Line 3578: OE_MSG_PUB.Add_Exc_Msg

3574: WHEN OTHERS THEN
3575:
3576: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3577: THEN
3578: OE_MSG_PUB.Add_Exc_Msg
3579: ( G_PKG_NAME,
3580: 'Log_Set_Request');
3581: END IF;
3582:

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

3791: Raise FND_API.G_EXC_ERROR;
3792:
3793: WHEN OTHERS THEN
3794:
3795: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3796: THEN
3797: OE_MSG_PUB.Add_Exc_Msg
3798: ( G_PKG_NAME,
3799: 'Load_MRP_request_from_tbl');

Line 3797: OE_MSG_PUB.Add_Exc_Msg

3793: WHEN OTHERS THEN
3794:
3795: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3796: THEN
3797: OE_MSG_PUB.Add_Exc_Msg
3798: ( G_PKG_NAME,
3799: 'Load_MRP_request_from_tbl');
3800: END IF;
3801: END Load_MRP_request_from_tbl;

Line 3867: OE_MSG_PUB.Add;

3863: oe_debug_pub.add( 'MRP HAS RETURNED ANY DATA' , 1 ) ;
3864: END IF;
3865:
3866: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ATP_ERROR');
3867: OE_MSG_PUB.Add;
3868: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3869:
3870: END IF;
3871: -- 4504197

Line 4019: OE_MSG_PUB.Add;

4015: END IF;
4016: IF p_atp_rec.error_code(J) = 80 THEN
4017:
4018: FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_SOURCE');
4019: OE_MSG_PUB.Add;
4020:
4021: ELSE
4022:
4023: IF l_debug_level > 0 THEN

Line 4030: OE_MSG_PUB.set_msg_context(

4026: IF l_debug_level > 0 THEN
4027: oe_debug_pub.add( P_ATP_REC.ERROR_CODE ( J ) , 1 ) ;
4028: END IF;
4029:
4030: OE_MSG_PUB.set_msg_context(
4031: p_entity_code => 'LINE'
4032: ,p_entity_id => p_x_line_rec.line_id
4033: ,p_header_id => p_x_line_rec.header_id
4034: ,p_line_id => p_x_line_rec.line_id

Line 4095: OE_MSG_PUB.Add;

4091: ELSE
4092: FND_MESSAGE.SET_NAME('ONT','OE_SCH_OE_ORDER_FAILED');
4093: FND_MESSAGE.SET_TOKEN('EXPLANATION',l_explanation);
4094: END IF;
4095: OE_MSG_PUB.Add;
4096: END IF;
4097: END IF; -- 80
4098:
4099: IF l_debug_level > 0 THEN

Line 4154: OE_MSG_PUB.add_text(l_explanation);

4150: oe_debug_pub.add( 'EXPLANATION IS : ' || L_EXPLANATION , 1 ) ;
4151: END IF;
4152:
4153: /* IF p_atp_rec.error_code(J) = 150 THEN -- to fix bug 1880166.
4154: OE_MSG_PUB.add_text(l_explanation);
4155: END IF;
4156: */ -- 2393433.
4157: EXCEPTION
4158: WHEN OTHERS THEN

Line 4294: OE_MSG_PUB.set_msg_context(

4290: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND
4291: l_sch_action <> OESCH_ACT_ATP_CHECK
4292: THEN
4293: -- code fix for 3502139
4294: OE_MSG_PUB.set_msg_context(
4295: p_entity_code => 'LINE'
4296: ,p_entity_id => p_x_line_rec.line_id
4297: ,p_header_id => p_x_line_rec.header_id
4298: ,p_line_id => p_x_line_rec.line_id

Line 4344: OE_MSG_PUB.Add;

4340:
4341: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ITEM_CHANGE');
4342: FND_MESSAGE.SET_TOKEN('OLDITEM',p_x_line_rec.ordered_item);
4343: FND_MESSAGE.SET_TOKEN('NEWITEM', p_atp_rec.inventory_item_name(J));
4344: OE_MSG_PUB.Add;
4345:
4346: -- Added below call for ER 6110708
4347: IF nvl(p_x_line_rec.booked_flag, 'N') = 'Y' THEN
4348: VALIDATE_ITEM_SUBSTITUTION

Line 4519: OE_MSG_PUB.Add;

4515: oe_debug_pub.add( 'SCH: Schedule Arr Date' ||
4516: p_x_line_rec.schedule_arrival_date , 2 ) ;
4517: END IF;
4518: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ATP_ERROR');
4519: OE_MSG_PUB.Add;
4520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4521: END IF;
4522:
4523: ELSIF l_sch_action = OESCH_ACT_REDEMAND OR

Line 4558: OE_MSG_PUB.Add;

4554:
4555: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ITEM_CHANGE');
4556: FND_MESSAGE.SET_TOKEN('OLDITEM',p_x_line_rec.ordered_item);
4557: FND_MESSAGE.SET_TOKEN('NEWITEM', p_atp_rec.inventory_item_name(J));
4558: OE_MSG_PUB.Add;
4559:
4560: -- Added below call for ER 6110708
4561: IF nvl(p_x_line_rec.booked_flag, 'N') = 'Y' THEN
4562: VALIDATE_ITEM_SUBSTITUTION

Line 4760: OE_MSG_PUB.Add;

4756: IF l_debug_level > 0 THEN
4757: oe_debug_pub.add( 'RSCH: MRP HAS NOT RETURNING VALID DATE' , 2 ) ;
4758: END IF;
4759: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ATP_ERROR');
4760: OE_MSG_PUB.Add;
4761: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4762: END IF;
4763:
4764: ELSIF l_sch_action = OESCH_ACT_UNDEMAND

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

4912: EXCEPTION
4913: WHEN FND_API.G_EXC_ERROR THEN
4914: x_return_status := FND_API.G_RET_STS_ERROR;
4915: WHEN OTHERS THEN
4916: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4917: THEN
4918: OE_MSG_PUB.Add_Exc_Msg
4919: ( G_PKG_NAME
4920: , 'Load_Results_from_rec'

Line 4918: OE_MSG_PUB.Add_Exc_Msg

4914: x_return_status := FND_API.G_RET_STS_ERROR;
4915: WHEN OTHERS THEN
4916: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4917: THEN
4918: OE_MSG_PUB.Add_Exc_Msg
4919: ( G_PKG_NAME
4920: , 'Load_Results_from_rec'
4921: );
4922: END IF;

Line 5168: OE_MSG_PUB.Add;

5164: END IF;
5165:
5166: l_old_set_id := l_new_set_id;
5167: FND_MESSAGE.SET_NAME('ONT','OE_SCH_GROUP_MEMBER_FAILED');
5168: OE_MSG_PUB.Add;
5169:
5170:
5171: END IF;
5172: IF p_partial THEN

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

5324: WHEN FND_API.G_EXC_ERROR THEN
5325:
5326: x_return_status := FND_API.G_RET_STS_ERROR;
5327: WHEN OTHERS THEN
5328: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5329: THEN
5330: OE_MSG_PUB.Add_Exc_Msg
5331: ( G_PKG_NAME
5332: , 'Load_Results_from_tbl'

Line 5330: OE_MSG_PUB.Add_Exc_Msg

5326: x_return_status := FND_API.G_RET_STS_ERROR;
5327: WHEN OTHERS THEN
5328: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5329: THEN
5330: OE_MSG_PUB.Add_Exc_Msg
5331: ( G_PKG_NAME
5332: , 'Load_Results_from_tbl'
5333: );
5334: END IF;

Line 5392: OE_MSG_PUB.set_msg_context(

5388: from oe_order_lines
5389: where line_id = p_line_id;
5390: END IF;
5391:
5392: OE_MSG_PUB.set_msg_context(
5393: p_entity_code => 'LINE'
5394: ,p_entity_id => p_line_id
5395: ,p_header_id => l_header_id
5396: ,p_line_id => p_line_id

Line 5409: OE_MSG_PUB.Add;

5405:
5406: IF p_atp_rec.error_code(J) = 80 THEN
5407:
5408: FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_SOURCE');
5409: OE_MSG_PUB.Add;
5410: l_explanation := null;
5411:
5412: ELSIF p_atp_rec.error_code(J) <> 0 THEN
5413:

Line 5425: OE_MSG_PUB.Add;

5421: oe_debug_pub.add( 'ADDING MESSAGE TO THE STACK' , 1 ) ;
5422: END IF;
5423: FND_MESSAGE.SET_NAME('ONT','OE_SCH_OE_ORDER_FAILED');
5424: FND_MESSAGE.SET_TOKEN('EXPLANATION',l_explanation);
5425: OE_MSG_PUB.Add;
5426:
5427: ELSE
5428:
5429: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ATP_ERROR');

Line 5430: OE_MSG_PUB.Add;

5426:
5427: ELSE
5428:
5429: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ATP_ERROR');
5430: OE_MSG_PUB.Add;
5431: END IF;
5432:
5433:
5434: ELSE

Line 5452: OE_MSG_PUB.Add;

5448: END IF;
5449:
5450: l_old_set_id := l_new_set_id;
5451: FND_MESSAGE.SET_NAME('ONT','OE_SCH_GROUP_MEMBER_FAILED');
5452: OE_MSG_PUB.Add;
5453:
5454: ELSIF p_atp_rec.error_code(J) <> 0
5455: AND p_atp_rec.error_code(J) <> 19 THEN
5456:

Line 5462: OE_MSG_PUB.set_msg_context(

5458: oe_debug_pub.add( 'SCHEDULING FAILED WITH ERROR CODE:'||P_ATP_REC.ERROR_CODE ( J ) , 1 ) ;
5459: END IF;
5460:
5461:
5462: OE_MSG_PUB.set_msg_context(
5463: p_entity_code => 'LINE'
5464: ,p_entity_id => p_line_tbl(I).line_id
5465: ,p_header_id => p_line_tbl(I).header_id
5466: ,p_line_id => p_line_tbl(I).line_id

Line 5479: OE_MSG_PUB.Add;

5475:
5476: IF p_atp_rec.error_code(J) = 80 THEN
5477:
5478: FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_SOURCE');
5479: OE_MSG_PUB.Add;
5480: l_explanation := null;
5481:
5482: ELSE
5483: select meaning

Line 5494: OE_MSG_PUB.Add;

5490: oe_debug_pub.add( 'ADDING MESSAGE TO THE STACK' , 1 ) ;
5491: END IF;
5492: FND_MESSAGE.SET_NAME('ONT','OE_SCH_OE_ORDER_FAILED');
5493: FND_MESSAGE.SET_TOKEN('EXPLANATION',l_explanation);
5494: OE_MSG_PUB.Add;
5495:
5496:
5497: END IF;
5498: END IF;

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

5665: WHEN OTHERS THEN
5666:
5667: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5668:
5669: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5670: THEN
5671: OE_MSG_PUB.Add_Exc_Msg
5672: ( G_PKG_NAME,
5673: 'Call_MRP_ATP');

Line 5671: OE_MSG_PUB.Add_Exc_Msg

5667: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5668:
5669: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5670: THEN
5671: OE_MSG_PUB.Add_Exc_Msg
5672: ( G_PKG_NAME,
5673: 'Call_MRP_ATP');
5674: END IF;
5675: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5714: EXCEPTION
5715:
5716: WHEN OTHERS THEN
5717:
5718: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5719: THEN
5720: OE_MSG_PUB.Add_Exc_Msg
5721: ( G_PKG_NAME,
5722: 'Cascade Override Atp');

Line 5720: OE_MSG_PUB.Add_Exc_Msg

5716: WHEN OTHERS THEN
5717:
5718: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5719: THEN
5720: OE_MSG_PUB.Add_Exc_Msg
5721: ( G_PKG_NAME,
5722: 'Cascade Override Atp');
5723: END IF;
5724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5861: oe_msg_pub.transfer_msg_stack;

5857: , x_msg_data => l_msg_data
5858: );
5859:
5860: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5861: oe_msg_pub.transfer_msg_stack;
5862: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
5863: for I in 1..l_msg_count loop
5864: l_msg_data := OE_MSG_PUB.Get(I,'F');
5865: IF l_debug_level > 0 THEN

Line 5862: l_msg_count:=OE_MSG_PUB.COUNT_MSG;

5858: );
5859:
5860: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5861: oe_msg_pub.transfer_msg_stack;
5862: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
5863: for I in 1..l_msg_count loop
5864: l_msg_data := OE_MSG_PUB.Get(I,'F');
5865: IF l_debug_level > 0 THEN
5866: oe_debug_pub.add( L_MSG_DATA , 1 ) ;

Line 5864: l_msg_data := OE_MSG_PUB.Get(I,'F');

5860: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5861: oe_msg_pub.transfer_msg_stack;
5862: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
5863: for I in 1..l_msg_count loop
5864: l_msg_data := OE_MSG_PUB.Get(I,'F');
5865: IF l_debug_level > 0 THEN
5866: oe_debug_pub.add( L_MSG_DATA , 1 ) ;
5867: END IF;
5868: end loop;

Line 5871: oe_msg_pub.transfer_msg_stack;

5867: END IF;
5868: end loop;
5869: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5870: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5871: oe_msg_pub.transfer_msg_stack;
5872: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
5873: for I in 1..l_msg_count loop
5874: l_msg_data := OE_MSG_PUB.Get(I,'F');
5875: IF l_debug_level > 0 THEN

Line 5872: l_msg_count:=OE_MSG_PUB.COUNT_MSG;

5868: end loop;
5869: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5870: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5871: oe_msg_pub.transfer_msg_stack;
5872: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
5873: for I in 1..l_msg_count loop
5874: l_msg_data := OE_MSG_PUB.Get(I,'F');
5875: IF l_debug_level > 0 THEN
5876: oe_debug_pub.add( L_MSG_DATA , 1 ) ;

Line 5874: l_msg_data := OE_MSG_PUB.Get(I,'F');

5870: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5871: oe_msg_pub.transfer_msg_stack;
5872: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
5873: for I in 1..l_msg_count loop
5874: l_msg_data := OE_MSG_PUB.Get(I,'F');
5875: IF l_debug_level > 0 THEN
5876: oe_debug_pub.add( L_MSG_DATA , 1 ) ;
5877: END IF;
5878: end loop;

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

5935: EXCEPTION
5936:
5937: WHEN OTHERS THEN
5938:
5939: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5940: THEN
5941: OE_MSG_PUB.Add_Exc_Msg
5942: ( G_PKG_NAME,
5943: 'Query_Qty_Tree');

Line 5941: OE_MSG_PUB.Add_Exc_Msg

5937: WHEN OTHERS THEN
5938:
5939: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5940: THEN
5941: OE_MSG_PUB.Add_Exc_Msg
5942: ( G_PKG_NAME,
5943: 'Query_Qty_Tree');
5944: END IF;
5945: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

6142: WHEN OTHERS THEN
6143:
6144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6145:
6146: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6147: THEN
6148: OE_MSG_PUB.Add_Exc_Msg
6149: ( G_PKG_NAME,
6150: 'Action_ATP');

Line 6148: OE_MSG_PUB.Add_Exc_Msg

6144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6145:
6146: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6147: THEN
6148: OE_MSG_PUB.Add_Exc_Msg
6149: ( G_PKG_NAME,
6150: 'Action_ATP');
6151: END IF;
6152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6373: OE_MSG_PUB.ADD;

6369:
6370: IF l_qty2_to_reserve = -99999 THEN
6371: -- conversion failed
6372: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR'); -- INVCONV
6373: OE_MSG_PUB.ADD;
6374: IF l_debug_level > 0 THEN
6375: oe_debug_pub.add( 'ERROR on UOM conversion to Secondary UOM which is '||p_x_line_rec.ordered_quantity_uom2 , 1 ) ;
6376: END IF;
6377: RAISE FND_API.G_EXC_ERROR;

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

6448: WHEN OTHERS THEN
6449:
6450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6451:
6452: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6453: THEN
6454: OE_MSG_PUB.Add_Exc_Msg
6455: ( G_PKG_NAME,
6456: 'Action_Schedule');

Line 6454: OE_MSG_PUB.Add_Exc_Msg

6450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6451:
6452: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6453: THEN
6454: OE_MSG_PUB.Add_Exc_Msg
6455: ( G_PKG_NAME,
6456: 'Action_Schedule');
6457: END IF;
6458:

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

6612: WHEN OTHERS THEN
6613:
6614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6615:
6616: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6617: THEN
6618: OE_MSG_PUB.Add_Exc_Msg
6619: ( G_PKG_NAME,
6620: 'Action_UnSchedule');

Line 6618: OE_MSG_PUB.Add_Exc_Msg

6614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6615:
6616: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6617: THEN
6618: OE_MSG_PUB.Add_Exc_Msg
6619: ( G_PKG_NAME,
6620: 'Action_UnSchedule');
6621: END IF;
6622:

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

6738: WHEN OTHERS THEN
6739:
6740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6741:
6742: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6743: THEN
6744: OE_MSG_PUB.Add_Exc_Msg
6745: ( G_PKG_NAME,
6746: 'Action_Undemand');

Line 6744: OE_MSG_PUB.Add_Exc_Msg

6740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6741:
6742: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6743: THEN
6744: OE_MSG_PUB.Add_Exc_Msg
6745: ( G_PKG_NAME,
6746: 'Action_Undemand');
6747: END IF;
6748:

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

6957: WHEN OTHERS THEN
6958:
6959: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6960:
6961: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6962: THEN
6963: OE_MSG_PUB.Add_Exc_Msg
6964: ( G_PKG_NAME,
6965: 'Action_Reserve');

Line 6963: OE_MSG_PUB.Add_Exc_Msg

6959: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6960:
6961: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6962: THEN
6963: OE_MSG_PUB.Add_Exc_Msg
6964: ( G_PKG_NAME,
6965: 'Action_Reserve');
6966: END IF;
6967: END Action_Reserve;

Line 7252: oe_msg_pub.add_text(p_message_text => l_buffer);

7248: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
7249: IF l_msg_data is not null THEN
7250: fnd_message.set_encoded(l_msg_data);
7251: l_buffer := fnd_message.get;
7252: oe_msg_pub.add_text(p_message_text => l_buffer);
7253: IF l_debug_level > 0 THEN
7254: oe_debug_pub.add( 'ERROR : '|| L_BUFFER , 1 ) ;
7255: END IF;
7256: END IF;

Line 7536: OE_MSG_PUB.ADD;

7532:
7533: IF l_qty2_to_reserve = -99999 THEN
7534: -- conversion failed
7535: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR'); -- INVCONV
7536: OE_MSG_PUB.ADD;
7537: IF l_debug_level > 0 THEN
7538: oe_debug_pub.add( 'ERROR on UOM conversion to Secondary UOM which is '||p_x_line_rec.ordered_quantity_uom2 , 1 ) ;
7539: END IF;
7540: RAISE FND_API.G_EXC_ERROR;

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

7627: WHEN OTHERS THEN
7628:
7629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7630:
7631: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7632: THEN
7633: OE_MSG_PUB.Add_Exc_Msg
7634: ( G_PKG_NAME,
7635: 'Action_Reschedule');

Line 7633: OE_MSG_PUB.Add_Exc_Msg

7629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7630:
7631: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7632: THEN
7633: OE_MSG_PUB.Add_Exc_Msg
7634: ( G_PKG_NAME,
7635: 'Action_Reschedule');
7636: END IF;
7637: END Action_Reschedule;

Line 7906: OE_MSG_PUB.Add;

7902: END IF;
7903:
7904: IF p_x_line_rec.ship_from_org_id is NULL THEN
7905: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ATO_WHSE_REQD');
7906: OE_MSG_PUB.Add;
7907: RAISE FND_API.G_EXC_ERROR;
7908: END IF;
7909:
7910: IF p_x_line_rec.schedule_ship_date is NULL THEN

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

8665: oe_debug_pub.add( 'OTHERS IN SCHEDULE_LINE'|| SQLERRM , 1 ) ;
8666: END IF;
8667: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8668:
8669: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8670: THEN
8671: OE_MSG_PUB.Add_Exc_Msg
8672: ( G_PKG_NAME
8673: ,'Schedule_line');

Line 8671: OE_MSG_PUB.Add_Exc_Msg

8667: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8668:
8669: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8670: THEN
8671: OE_MSG_PUB.Add_Exc_Msg
8672: ( G_PKG_NAME
8673: ,'Schedule_line');
8674: END IF;
8675:

Line 8859: OE_MSG_PUB.Add;

8855: IF l_debug_level > 0 THEN
8856: oe_debug_pub.add( 'INVALID SCH ACTION ' , 1 ) ;
8857: END IF;
8858: FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_ACTION_DONE_NO_EXP');
8859: OE_MSG_PUB.Add;
8860: RETURN FALSE;
8861: END IF;
8862:
8863: IF l_debug_level > 0 THEN

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

9300:
9301: WHEN OTHERS THEN
9302: x_line_action := Null;
9303:
9304: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9305: THEN
9306: OE_MSG_PUB.Add_Exc_Msg
9307: ( G_PKG_NAME
9308: , 'Need_Scheduling'

Line 9306: OE_MSG_PUB.Add_Exc_Msg

9302: x_line_action := Null;
9303:
9304: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9305: THEN
9306: OE_MSG_PUB.Add_Exc_Msg
9307: ( G_PKG_NAME
9308: , 'Need_Scheduling'
9309: );
9310: END IF;

Line 9370: OE_MSG_PUB.Add;

9366: (p_line_rec.ordered_quantity is null OR
9367: p_line_rec.ordered_quantity = FND_API.G_MISS_NUM)) THEN
9368:
9369: FND_MESSAGE.SET_NAME('ONT','OE_SCH_MISSING_QUANTITY');
9370: OE_MSG_PUB.Add;
9371: IF l_debug_level > 0 THEN
9372: oe_debug_pub.add( 'E1' , 1 ) ;
9373: END IF;
9374: x_return_status := FND_API.G_RET_STS_ERROR;

Line 9391: OE_MSG_PUB.Add;

9387: IF p_sch_action is not null
9388: AND p_caller = SCH_INTERNAL THEN
9389:
9390: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ZERO_QTY');
9391: OE_MSG_PUB.Add;
9392:
9393: IF l_debug_level > 0 THEN
9394: oe_debug_pub.add( 'E2' , 1 ) ;
9395: END IF;

Line 9416: OE_MSG_PUB.Add;

9412: -- The line is cancelled. Cannot perform scheduling
9413: -- on it.
9414:
9415: FND_MESSAGE.SET_NAME('ONT','OE_SCH_LINE_FULLY_CANCELLED');
9416: OE_MSG_PUB.Add;
9417:
9418: IF l_debug_level > 0 THEN
9419: oe_debug_pub.add( 'E3' , 1 ) ;
9420: END IF;

Line 9440: OE_MSG_PUB.Add;

9436: -- The line is cancelled. Cannot perform scheduling
9437: -- on it.
9438:
9439: FND_MESSAGE.SET_NAME('ONT','OE_SCH_LINE_SHIPPED');
9440: OE_MSG_PUB.Add;
9441:
9442: IF l_debug_level > 0 THEN
9443: oe_debug_pub.add( 'E4' , 1 ) ;
9444: END IF;

Line 9462: OE_MSG_PUB.Add;

9458: -- The line is Fulfilled. Cannot perform scheduling
9459: -- on it.
9460:
9461: FND_MESSAGE.SET_NAME('ONT','OE_SCH_LINE_FULFILLED');
9462: OE_MSG_PUB.Add;
9463:
9464: IF l_debug_level > 0 THEN
9465: oe_debug_pub.add( 'E4.1' , 1 ) ;
9466: END IF;

Line 9487: OE_MSG_PUB.Add;

9483: AND OE_GLOBALS.Equal(p_old_line_rec.order_quantity_uom, p_line_rec.order_quantity_uom) --Bug 6335352
9484: THEN
9485:
9486: FND_MESSAGE.SET_NAME('ONT','OE_SCH_RES_MORE_ORD_QTY');
9487: OE_MSG_PUB.Add;
9488:
9489: IF l_debug_level > 0 THEN
9490: oe_debug_pub.add( 'E5' , 1 ) ;
9491: END IF;

Line 9502: OE_MSG_PUB.Add;

9498: p_sch_action = OESCH_ACT_UNRESERVE) AND
9499: (p_line_rec.reserved_quantity is not null) THEN
9500:
9501: FND_MESSAGE.SET_NAME('ONT','OE_SCH_RES_QTY_CHG_NOT_ALLOWED');
9502: OE_MSG_PUB.Add;
9503: x_return_status := FND_API.G_RET_STS_ERROR;
9504: IF l_debug_level > 0 THEN
9505: oe_debug_pub.add( 'E6' , 1 ) ;
9506: END IF;

Line 9518: OE_MSG_PUB.Add;

9514: IF (p_line_rec.ordered_quantity2 < p_line_rec.reserved_quantity2)
9515: THEN
9516:
9517: FND_MESSAGE.SET_NAME('ONT','OE_SCH_RES_MORE_ORD_QTY');
9518: OE_MSG_PUB.Add;
9519:
9520: IF l_debug_level > 0 THEN
9521: oe_debug_pub.add( 'E5a' , 1 ) ;
9522: END IF;

Line 9533: OE_MSG_PUB.Add;

9529: p_sch_action = OESCH_ACT_UNRESERVE) AND
9530: (p_line_rec.reserved_quantity2 is not null) THEN
9531:
9532: FND_MESSAGE.SET_NAME('ONT','OE_SCH_RES_QTY_CHG_NOT_ALLOWED');
9533: OE_MSG_PUB.Add;
9534: x_return_status := FND_API.G_RET_STS_ERROR;
9535: IF l_debug_level > 0 THEN
9536: oe_debug_pub.add( 'E6A' , 1 ) ;
9537: END IF;

Line 9559: OE_MSG_PUB.Add;

9555: IF (p_line_rec.ordered_quantity < p_line_rec.reserved_quantity)
9556: THEN
9557:
9558: FND_MESSAGE.SET_NAME('ONT','OE_SCH_RES_MORE_ORD_QTY');
9559: OE_MSG_PUB.Add;
9560:
9561: x_return_status := FND_API.G_RET_STS_ERROR;
9562: IF l_debug_level > 0 THEN
9563: oe_debug_pub.add( 'E7' , 1 ) ;

Line 9580: OE_MSG_PUB.Add;

9576: IF (p_line_rec.ordered_quantity2 < p_line_rec.reserved_quantity2)
9577: THEN
9578:
9579: FND_MESSAGE.SET_NAME('ONT','OE_SCH_RES_MORE_ORD_QTY');
9580: OE_MSG_PUB.Add;
9581:
9582: x_return_status := FND_API.G_RET_STS_ERROR;
9583: IF l_debug_level > 0 THEN
9584: oe_debug_pub.add( 'E7A' , 1 ) ;

Line 9599: OE_MSG_PUB.Add;

9595: IF (p_line_rec.order_quantity_uom is null OR
9596: p_line_rec.order_quantity_uom = FND_API.G_MISS_CHAR) THEN
9597:
9598: FND_MESSAGE.SET_NAME('ONT','OE_SCH_MISSING_UOM');
9599: OE_MSG_PUB.Add;
9600:
9601: x_return_status := FND_API.G_RET_STS_ERROR;
9602: IF l_debug_level > 0 THEN
9603: oe_debug_pub.add( 'E8' , 1 ) ;

Line 9618: OE_MSG_PUB.Add;

9614: IF (p_line_rec.inventory_item_id is null OR
9615: p_line_rec.inventory_item_id = FND_API.G_MISS_NUM) THEN
9616:
9617: FND_MESSAGE.SET_NAME('ONT','OE_SCH_MISSING_ITEM');
9618: OE_MSG_PUB.Add;
9619:
9620: IF l_debug_level > 0 THEN
9621: oe_debug_pub.add( 'E9' , 1 ) ;
9622: END IF;

Line 9637: OE_MSG_PUB.Add;

9633: IF (p_line_rec.request_date is null OR
9634: p_line_rec.request_date = FND_API.G_MISS_DATE) THEN
9635:
9636: FND_MESSAGE.SET_NAME('ONT','OE_SCH_MISSING_REQUEST_DATE');
9637: OE_MSG_PUB.Add;
9638: IF l_debug_level > 0 THEN
9639: oe_debug_pub.add( 'E10' , 1 ) ;
9640: END IF;
9641: x_return_status := FND_API.G_RET_STS_ERROR;

Line 9653: OE_MSG_PUB.Add;

9649: END IF;
9650: IF (p_line_rec.ship_from_org_id is null OR
9651: p_line_rec.ship_from_org_id = FND_API.G_MISS_NUM) THEN
9652: FND_MESSAGE.SET_NAME('ONT','ONT_SCH_BYPASS_MISS_WSH');
9653: OE_MSG_PUB.Add;
9654:
9655: IF l_debug_level > 0 THEN
9656: oe_debug_pub.add( 'ERROR BYPASS' , 1 ) ;
9657: END IF;

Line 9675: OE_MSG_PUB.Add;

9671: p_sch_action = OESCH_ACT_UNSCHEDULE)
9672: THEN
9673:
9674: FND_MESSAGE.SET_NAME('ONT','OE_SCH_CANNOT_UNSCH_SET');
9675: OE_MSG_PUB.Add;
9676: IF l_debug_level > 0 THEN
9677: oe_debug_pub.add( 'E11' , 1 ) ;
9678: END IF;
9679: x_return_status := FND_API.G_RET_STS_ERROR;

Line 9740: OE_MSG_PUB.Add;

9736: END IF;
9737:
9738: IF (l_result = FND_API.G_TRUE) THEN
9739: FND_MESSAGE.SET_NAME('ONT','OE_SCH_LINE_ON_HOLD');
9740: OE_MSG_PUB.Add;
9741: x_return_status := FND_API.G_RET_STS_ERROR;
9742: END IF;
9743:
9744: END IF;

Line 9779: OE_MSG_PUB.Add;

9775: p_line_rec.ship_from_org_id = FND_API.G_MISS_NUM) THEN
9776: FND_MESSAGE.SET_NAME('ONT','OE_SCH_INACTIVE_MISS_WSH');
9777: FND_MESSAGE.SET_TOKEN('LTYPE',
9778: nvl(sch_cached_line_type,'0'));
9779: OE_MSG_PUB.Add;
9780:
9781: IF l_debug_level > 0 THEN
9782: oe_debug_pub.add( 'E11.1' , 1 ) ;
9783: END IF;

Line 9798: OE_MSG_PUB.Add;

9794:
9795: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_INACTIVE_STD_ONLY');
9796: FND_MESSAGE.SET_TOKEN('LTYPE',
9797: nvl(sch_cached_line_type,'0'));
9798: OE_MSG_PUB.Add;
9799:
9800: IF l_debug_level > 0 THEN
9801: oe_debug_pub.add( 'E11.2' , 1 ) ;
9802: END IF;

Line 9819: OE_MSG_PUB.Add;

9815:
9816: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_INACTIVE_STD_ONLY');
9817: FND_MESSAGE.SET_TOKEN('LTYPE',
9818: nvl(sch_cached_line_type,'0'));
9819: OE_MSG_PUB.Add;
9820:
9821: IF l_debug_level > 0 THEN
9822: oe_debug_pub.add( 'E11.3' , 1 ) ;
9823: END IF;

Line 9847: OE_MSG_PUB.Add;

9843: FND_MESSAGE.SET_TOKEN('ACTION',
9844: nvl(p_sch_action,OESCH_ACT_SCHEDULE));
9845: FND_MESSAGE.SET_TOKEN('ORDER_TYPE',
9846: nvl(sch_cached_line_type,sch_cached_order_type));
9847: OE_MSG_PUB.Add;
9848: IF l_debug_level > 0 THEN
9849: oe_debug_pub.add( 'E12' , 1 ) ;
9850: END IF;
9851: x_return_status := FND_API.G_RET_STS_ERROR;

Line 9869: OE_MSG_PUB.Add;

9865: FND_MESSAGE.SET_TOKEN('ACTION',
9866: nvl(p_sch_action,OESCH_ACT_RESERVE));
9867: FND_MESSAGE.SET_TOKEN('ORDER_TYPE',
9868: nvl(sch_cached_line_type,sch_cached_order_type));
9869: OE_MSG_PUB.Add;
9870: IF l_debug_level > 0 THEN
9871: oe_debug_pub.add( 'E13' , 1 ) ;
9872: END IF;
9873: x_return_status := FND_API.G_RET_STS_ERROR;

Line 9888: OE_MSG_PUB.Add;

9884: FND_MESSAGE.SET_TOKEN('ACTION',
9885: (nvl(p_sch_action, OESCH_ACT_ATP_CHECK)));
9886: FND_MESSAGE.SET_TOKEN('ORDER_TYPE',
9887: nvl(sch_cached_line_type,sch_cached_order_type));
9888: OE_MSG_PUB.Add;
9889: IF l_debug_level > 0 THEN
9890: oe_debug_pub.add( 'E13.1' , 1 ) ;
9891: END IF;
9892: X_return_status := FND_API.G_RET_STS_ERROR;

Line 9914: OE_MSG_PUB.Add;

9910: -- interfaced to wsh. Give a message here tell the user we are
9911: -- not unreserving. Added code here to fix bug 2038201.
9912:
9913: FND_MESSAGE.SET_NAME('ONT','OE_SCH_UNRSV_NOT_ALLOWED');
9914: OE_MSG_PUB.Add;
9915: IF l_debug_level > 0 THEN
9916: oe_debug_pub.add( 'E14' , 1 ) ;
9917: END IF;
9918: x_return_status := FND_API.G_RET_STS_ERROR;

Line 9943: OE_MSG_PUB.Add;

9939: p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_SCHEDULE
9940: THEN
9941:
9942: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ATO_WHSE_REQD');
9943: OE_MSG_PUB.Add;
9944: IF l_debug_level > 0 THEN
9945: oe_debug_pub.add( 'E15' , 1 ) ;
9946: END IF;
9947: x_return_status := FND_API.G_RET_STS_ERROR;

Line 9957: OE_MSG_PUB.Add;

9953: AND p_line_rec.schedule_status_code is null
9954: THEN
9955:
9956: FND_MESSAGE.SET_NAME('ONT','OE_SCH_RES_NO_CONFIG');
9957: OE_MSG_PUB.Add;
9958: IF l_debug_level > 0 THEN
9959: oe_debug_pub.add( 'E16' , 1 ) ;
9960: END IF;
9961: -- code fix for 3300528

Line 9976: OE_MSG_PUB.Add;

9972: AND p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG
9973: AND p_line_rec.booked_flag <> 'Y'
9974: THEN
9975: FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_ACTION_DONE_NO_EXP');
9976: OE_MSG_PUB.Add;
9977: IF l_debug_level > 0 THEN
9978: oe_debug_pub.add( 'E16.0' , 1 );
9979: END IF;
9980: x_return_status := FND_API.G_RET_STS_ERROR;

Line 9990: OE_MSG_PUB.Add;

9986: OR p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_UNRESERVE)
9987: AND p_line_rec.schedule_status_code IS NULL
9988: THEN
9989: FND_MESSAGE.SET_NAME('ONT','ONT_SCH_NOT_RESERVABLE');
9990: OE_MSG_PUB.Add;
9991: IF l_debug_level > 0 THEN
9992: oe_debug_pub.add( 'E16.1' , 1 ) ;
9993: END IF;
9994: -- code fix for 3300528

Line 10058: OE_MSG_PUB.Add;

10054: END IF;
10055: FND_MESSAGE.SET_TOKEN('ORG',l_org_code);
10056: -- Bug 2367743 End
10057:
10058: OE_MSG_PUB.Add;
10059: x_return_status := FND_API.G_RET_STS_ERROR;
10060:
10061: WHEN OTHERS THEN
10062: Null;

Line 10079: OE_MSG_PUB.Add;

10075:
10076: -- Added code here to fix bug 2038201.
10077: oe_debug_pub.add('E18',1);
10078: FND_MESSAGE.SET_NAME('ONT','OE_SCH_UNRSV_NOT_ALLOWED');
10079: OE_MSG_PUB.Add;
10080: x_return_status := FND_API.G_RET_STS_ERROR;
10081:
10082: END IF;
10083: */

Line 10110: OE_MSG_PUB.Add;

10106: IF l_debug_level > 0 THEN
10107: oe_debug_pub.add( 'E19' , 1 ) ;
10108: END IF;
10109: FND_MESSAGE.SET_NAME('ONT','OE_SCH_UNSCH_CONFIG_EXISTS');
10110: OE_MSG_PUB.Add;
10111: x_return_status := FND_API.G_RET_STS_ERROR;
10112:
10113: EXCEPTION
10114: WHEN NO_DATA_FOUND THEN

Line 10121: OE_MSG_PUB.Add;

10117: IF l_debug_level > 0 THEN
10118: oe_debug_pub.add( 'E19 TOO MANY ROWS' , 1 ) ;
10119: END IF;
10120: FND_MESSAGE.SET_NAME('ONT','OE_SCH_UNSCH_CONFIG_EXISTS');
10121: OE_MSG_PUB.Add;
10122: x_return_status := FND_API.G_RET_STS_ERROR;
10123:
10124: END;
10125:

Line 10145: OE_MSG_PUB.Add;

10141:
10142: IF nvl(l_order_date_type_code,'SHIP') = 'ARRIVAL' THEN
10143:
10144: FND_MESSAGE.SET_NAME('ONT','OE_SCH_INV_SHP_DATE');
10145: OE_MSG_PUB.Add;
10146:
10147: OE_DEBUG_PUB.Add('E20 Order date Type - Arrival');
10148: x_return_status := FND_API.G_RET_STS_ERROR;
10149:

Line 10169: OE_MSG_PUB.Add;

10165:
10166: IF nvl(l_order_date_type_code,'SHIP') = 'SHIP' THEN
10167:
10168: FND_MESSAGE.SET_NAME('ONT','OE_SCH_INV_ARR_DATE');
10169: OE_MSG_PUB.Add;
10170:
10171: OE_DEBUG_PUB.Add('E21 Order date Type - Ship');
10172:
10173: x_return_status := FND_API.G_RET_STS_ERROR;

Line 10197: OE_MSG_PUB.Add;

10193:
10194: -- only authorized users have authority to update the
10195: -- Overide ATP Field
10196: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_OVER_ATP_NO_AUTH');
10197: OE_MSG_PUB.Add;
10198: IF l_debug_level > 0 THEN
10199: oe_debug_pub.add( 'E22 INVALID AUTOTIZE' ) ;
10200: END IF;
10201: IF l_debug_level > 0 THEN

Line 10221: OE_MSG_PUB.Add;

10217:
10218: -- only authorized users have authority to update scheduling attributes
10219: -- on an overridden line
10220: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_OVER_ATP_NO_AUTH_MOD');
10221: OE_MSG_PUB.Add;
10222: IF l_debug_level > 0 THEN
10223: oe_debug_pub.add( 'E23 USER DOES NOT HAVE AUTHORITY TO UPDATE SCHEDULE ATTRIBUTES' , 1 ) ;
10224: END IF;
10225: X_return_status := FND_API.G_RET_STS_ERROR;

Line 10234: OE_MSG_PUB.Add;

10230: (p_sch_action = OESCH_ACT_UNDEMAND OR
10231: P_sch_action = OESCH_ACT_UNSCHEDULE) THEN
10232: -- Only Authorized users have authority to unschedule an overriddenline
10233: FND_MESSAGE.SET_NAME('ONT','OE_SCH_OVER_ATP_NO_AUTH_UNCHK');
10234: OE_MSG_PUB.Add;
10235: IF l_debug_level > 0 THEN
10236: oe_debug_pub.add( 'E24 GENERAL USER CANNOT UNSCHEDULE AN OVERRIDDEN LINE' , 1 ) ;
10237: END IF;
10238: X_return_status := FND_API.G_RET_STS_ERROR;

Line 10260: OE_MSG_PUB.Add;

10256: NULL;
10257: END;
10258: IF l_found = 'Y' THEN
10259: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_OVER_ATP_NO_AUTH_MOD');
10260: OE_MSG_PUB.Add;
10261: X_return_status := FND_API.G_RET_STS_ERROR;
10262: END IF;
10263: END IF;
10264: -- End 2746497

Line 10290: OE_MSG_PUB.Add;

10286:
10287: -- only authorized users have authority to update scheduling
10288: -- attributes in a set with an overridden line
10289: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_OVER_ATP_NO_AUTH_SET');
10290: OE_MSG_PUB.Add;
10291: IF l_debug_level > 0 THEN
10292: oe_debug_pub.add( 'E25 USER DOES NOT HAVE AUTHORITY TO UPDATE SCHEDULE ATTRIBUTES ON A SET WITH AN OVERRIDDEN LINE' , 1 ) ;
10293: END IF;
10294: X_return_status := FND_API.G_RET_STS_ERROR;

Line 10332: OE_MSG_PUB.Add;

10328: -- Authorized users cannot add an overridden line if the schedule
10329: -- ship date soes not match the set
10330:
10331: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_OVER_ATP_NO_AUTH_SET');
10332: OE_MSG_PUB.Add;
10333: IF l_debug_level > 0 THEN
10334: oe_debug_pub.add( 'E26 UNABLE TO ADD THE LINE TO THE SET' , 1 ) ;
10335: END IF;
10336: x_return_status := FND_API.G_RET_STS_ERROR;

Line 10379: OE_MSG_PUB.Add;

10375: IF l_overridden = 'Y' THEN
10376: --3517527 set_status check commented
10377: -- IF l_set_rec.set_status <> 'T' THEN
10378: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_OVER_ATP_NO_AUTH_SET');
10379: OE_MSG_PUB.Add;
10380: -- END IF;
10381: IF l_debug_level > 0 THEN
10382: oe_debug_pub.add( 'E27 UNABLE TO ADD THE line TO THE SET' , 1 ) ;
10383: END IF;

Line 10401: OE_MSG_PUB.Add;

10397: (p_top_model_line_id => p_line_rec.top_model_line_id,
10398: p_set_type => l_set_rec.set_type) THEN
10399:
10400: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_OVER_ATP_NO_AUTH_SET');
10401: OE_MSG_PUB.Add;
10402: IF l_debug_level > 0 THEN
10403: oe_debug_pub.add( 'E28 UNABLE TO ADD THE Model TO THE SET' , 1 ) ;
10404: END IF;
10405: x_return_status := FND_API.G_RET_STS_ERROR;

Line 10438: OE_MSG_PUB.Add;

10434: IF l_debug_level > 0 THEN
10435: oe_debug_pub.add ('E29 Request date exceeds Latest Acceptable Date',1);
10436: END IF;
10437: FND_MESSAGE.SET_NAME('ONT','ONT_SCH_REQUEST_EXCEED_LAD');
10438: OE_MSG_PUB.Add;
10439: x_return_status := FND_API.G_RET_STS_ERROR;
10440: ELSIF ((l_order_date_type_code = 'SHIP'
10441: AND trunc(NVL(p_line_rec.schedule_ship_date,p_line_rec.request_date))
10442: > trunc(NVL(p_line_rec.latest_acceptable_date,p_line_rec.request_date)))

Line 10450: OE_MSG_PUB.Add;

10446: IF l_debug_level > 0 THEN
10447: oe_debug_pub.add('E30 Schedule date exceeds Latest Acceptable Date',1);
10448: END IF;
10449: FND_MESSAGE.SET_NAME('ONT','ONT_SCH_LAD_SCH_FAILED');
10450: OE_MSG_PUB.Add;
10451: x_return_status := FND_API.G_RET_STS_ERROR;
10452: END IF;
10453: -- 3894212
10454: IF ((p_line_rec.ship_set_id IS NOT NULL AND

Line 10476: OE_MSG_PUB.Add;

10472: IF l_debug_level > 0 THEN
10473: oe_debug_pub.add('E30.1 Schedule date exceeds Latest Acceptable Date',1);
10474: END IF;
10475: FND_MESSAGE.SET_NAME('ONT','ONT_SCH_LAD_SCH_FAILED');
10476: OE_MSG_PUB.Add;
10477: x_return_status := FND_API.G_RET_STS_ERROR;
10478: END IF;
10479: END IF;
10480: --

Line 10522: OE_MSG_PUB.Add;

10518: IF l_debug_level > 0 THEN
10519: oe_debug_pub.add('E31 Reservation(s) cannot be created. The line has been pick confirmed/staged',1);
10520: END IF;
10521: FND_MESSAGE.SET_NAME('ONT','ONT_SCH_RSV_FAILURE_STAGED');
10522: OE_MSG_PUB.Add;
10523: x_return_status := FND_API.G_RET_STS_ERROR;
10524: END IF;
10525: END IF;
10526:

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

10537: WHEN OTHERS THEN
10538:
10539: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10540:
10541: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
10542: THEN
10543: OE_MSG_PUB.Add_Exc_Msg
10544: ( G_PKG_NAME,
10545: 'Validate_Line');

Line 10543: OE_MSG_PUB.Add_Exc_Msg

10539: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10540:
10541: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
10542: THEN
10543: OE_MSG_PUB.Add_Exc_Msg
10544: ( G_PKG_NAME,
10545: 'Validate_Line');
10546: END IF;
10547: END Validate_Line;

Line 10763: OE_MSG_PUB.Add;

10759: END IF;
10760:
10761: ELSE
10762: FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_ACTION_DONE_NO_EXP');
10763: OE_MSG_PUB.Add;
10764: l_update_flag := FND_API.G_FALSE;
10765: END IF;
10766:
10767:

Line 10787: OE_MSG_PUB.Add;

10783: END IF;
10784:
10785: ELSE
10786: FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_ACTION_DONE_NO_EXP');
10787: OE_MSG_PUB.Add;
10788: l_update_flag := FND_API.G_FALSE;
10789: END IF;
10790:
10791: ELSIF p_sch_action = OESCH_ACT_UNSCHEDULE THEN

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

10912:
10913: WHEN OTHERS THEN
10914: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10915:
10916: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
10917: THEN
10918: OE_MSG_PUB.Add_Exc_Msg
10919: ( G_PKG_NAME
10920: , 'Process_request'

Line 10918: OE_MSG_PUB.Add_Exc_Msg

10914: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10915:
10916: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
10917: THEN
10918: OE_MSG_PUB.Add_Exc_Msg
10919: ( G_PKG_NAME
10920: , 'Process_request'
10921: );
10922: END IF;

Line 11312: oe_msg_pub.transfer_msg_stack;

11308: oe_debug_pub.add( 'RETURN STATUS ' || L_RETURN_STATUS , 1 ) ;
11309: END IF;
11310:
11311: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
11312: oe_msg_pub.transfer_msg_stack;
11313: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
11314: FOR I in 1..l_msg_count LOOP
11315: l_msg_data := OE_MSG_PUB.Get(I,'F');
11316: IF l_debug_level > 0 THEN

Line 11313: l_msg_count:=OE_MSG_PUB.COUNT_MSG;

11309: END IF;
11310:
11311: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
11312: oe_msg_pub.transfer_msg_stack;
11313: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
11314: FOR I in 1..l_msg_count LOOP
11315: l_msg_data := OE_MSG_PUB.Get(I,'F');
11316: IF l_debug_level > 0 THEN
11317: oe_debug_pub.add( L_MSG_DATA , 1 ) ;

Line 11315: l_msg_data := OE_MSG_PUB.Get(I,'F');

11311: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
11312: oe_msg_pub.transfer_msg_stack;
11313: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
11314: FOR I in 1..l_msg_count LOOP
11315: l_msg_data := OE_MSG_PUB.Get(I,'F');
11316: IF l_debug_level > 0 THEN
11317: oe_debug_pub.add( L_MSG_DATA , 1 ) ;
11318: END IF;
11319: END LOOP;

Line 11323: oe_msg_pub.transfer_msg_stack;

11319: END LOOP;
11320:
11321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11322: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
11323: oe_msg_pub.transfer_msg_stack;
11324: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
11325: FOR I in 1..l_msg_count LOOP
11326: l_msg_data := OE_MSG_PUB.Get(I,'F');
11327: IF l_debug_level > 0 THEN

Line 11324: l_msg_count:=OE_MSG_PUB.COUNT_MSG;

11320:
11321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11322: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
11323: oe_msg_pub.transfer_msg_stack;
11324: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
11325: FOR I in 1..l_msg_count LOOP
11326: l_msg_data := OE_MSG_PUB.Get(I,'F');
11327: IF l_debug_level > 0 THEN
11328: oe_debug_pub.add( L_MSG_DATA , 1 ) ;

Line 11326: l_msg_data := OE_MSG_PUB.Get(I,'F');

11322: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
11323: oe_msg_pub.transfer_msg_stack;
11324: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
11325: FOR I in 1..l_msg_count LOOP
11326: l_msg_data := OE_MSG_PUB.Get(I,'F');
11327: IF l_debug_level > 0 THEN
11328: oe_debug_pub.add( L_MSG_DATA , 1 ) ;
11329: END IF;
11330: END LOOP;

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

11338: EXCEPTION
11339:
11340: WHEN OTHERS THEN
11341:
11342: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
11343: THEN
11344: OE_MSG_PUB.Add_Exc_Msg
11345: ( G_PKG_NAME
11346: , 'Insert_Into_Mtl_Sales_Orders'

Line 11344: OE_MSG_PUB.Add_Exc_Msg

11340: WHEN OTHERS THEN
11341:
11342: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
11343: THEN
11344: OE_MSG_PUB.Add_Exc_Msg
11345: ( G_PKG_NAME
11346: , 'Insert_Into_Mtl_Sales_Orders'
11347: );
11348: END IF;

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

11456: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
11457: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
11458: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11459:
11460: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
11461: THEN
11462: OE_MSG_PUB.Add_Exc_Msg
11463: ( G_PKG_NAME
11464: , 'Call_Process_Order'

Line 11462: OE_MSG_PUB.Add_Exc_Msg

11458: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11459:
11460: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
11461: THEN
11462: OE_MSG_PUB.Add_Exc_Msg
11463: ( G_PKG_NAME
11464: , 'Call_Process_Order'
11465: );
11466: END IF;

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

11725: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
11726: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11727: ROLLBACK TO SAVEPOINT Process_Group_of_lines;
11728:
11729: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
11730: THEN
11731: OE_MSG_PUB.Add_Exc_Msg
11732: ( G_PKG_NAME
11733: , 'Call_Process_Order'

Line 11731: OE_MSG_PUB.Add_Exc_Msg

11727: ROLLBACK TO SAVEPOINT Process_Group_of_lines;
11728:
11729: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
11730: THEN
11731: OE_MSG_PUB.Add_Exc_Msg
11732: ( G_PKG_NAME
11733: , 'Call_Process_Order'
11734: );
11735: END IF;

Line 12001: OE_MSG_PUB.set_msg_context

11997: IF l_debug_level > 0 THEN
11998: oe_debug_pub.add( 'BEFORE CALLING LOG_SCHEDULING REQUESTS' , 1 ) ;
11999: END IF;
12000:
12001: OE_MSG_PUB.set_msg_context
12002: (p_entity_code => 'LINE'
12003: ,p_entity_id => p_x_line_rec.line_id
12004: ,p_header_id => p_x_line_rec.header_id
12005: ,p_line_id => p_x_line_rec.line_id

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

12271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12272: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
12273: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
12274:
12275: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
12276: THEN
12277: OE_MSG_PUB.Add_Exc_Msg
12278: ( G_PKG_NAME
12279: , 'Process_Line'

Line 12277: OE_MSG_PUB.Add_Exc_Msg

12273: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
12274:
12275: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
12276: THEN
12277: OE_MSG_PUB.Add_Exc_Msg
12278: ( G_PKG_NAME
12279: , 'Process_Line'
12280: );
12281: END IF;

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

12389: WHEN OTHERS THEN
12390:
12391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12392:
12393: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
12394: THEN
12395: OE_MSG_PUB.Add_Exc_Msg
12396: ( G_PKG_NAME
12397: , 'ATP_Check'

Line 12395: OE_MSG_PUB.Add_Exc_Msg

12391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12392:
12393: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
12394: THEN
12395: OE_MSG_PUB.Add_Exc_Msg
12396: ( G_PKG_NAME
12397: , 'ATP_Check'
12398: );
12399: END IF;

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

12616: WHEN OTHERS THEN
12617:
12618: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12619:
12620: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
12621: THEN
12622: OE_MSG_PUB.Add_Exc_Msg
12623: ( G_PKG_NAME
12624: , 'MULTI_ATP_Check'

Line 12622: OE_MSG_PUB.Add_Exc_Msg

12618: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12619:
12620: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
12621: THEN
12622: OE_MSG_PUB.Add_Exc_Msg
12623: ( G_PKG_NAME
12624: , 'MULTI_ATP_Check'
12625: );
12626: END IF;

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

12817: EXCEPTION
12818:
12819: WHEN OTHERS THEN
12820:
12821: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
12822: THEN
12823: OE_MSG_PUB.Add_Exc_Msg
12824: ( G_PKG_NAME
12825: , 'Delete_row'

Line 12823: OE_MSG_PUB.Add_Exc_Msg

12819: WHEN OTHERS THEN
12820:
12821: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
12822: THEN
12823: OE_MSG_PUB.Add_Exc_Msg
12824: ( G_PKG_NAME
12825: , 'Delete_row'
12826: );
12827: END IF;

Line 12906: oe_msg_pub.transfer_msg_stack;

12902: oe_debug_pub.add( L_MSG_DATA , 1 ) ;
12903: END IF;
12904:
12905: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
12906: oe_msg_pub.transfer_msg_stack;
12907: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
12908: for I in 1..l_msg_count loop
12909: l_msg_data := OE_MSG_PUB.Get(I,'F');
12910: IF l_debug_level > 0 THEN

Line 12907: l_msg_count:=OE_MSG_PUB.COUNT_MSG;

12903: END IF;
12904:
12905: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
12906: oe_msg_pub.transfer_msg_stack;
12907: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
12908: for I in 1..l_msg_count loop
12909: l_msg_data := OE_MSG_PUB.Get(I,'F');
12910: IF l_debug_level > 0 THEN
12911: oe_debug_pub.add( L_MSG_DATA , 1 ) ;

Line 12909: l_msg_data := OE_MSG_PUB.Get(I,'F');

12905: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
12906: oe_msg_pub.transfer_msg_stack;
12907: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
12908: for I in 1..l_msg_count loop
12909: l_msg_data := OE_MSG_PUB.Get(I,'F');
12910: IF l_debug_level > 0 THEN
12911: oe_debug_pub.add( L_MSG_DATA , 1 ) ;
12912: END IF;
12913: end loop;

Line 12916: oe_msg_pub.transfer_msg_stack;

12912: END IF;
12913: end loop;
12914: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12915: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
12916: oe_msg_pub.transfer_msg_stack;
12917: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
12918: for I in 1..l_msg_count loop
12919: l_msg_data := OE_MSG_PUB.Get(I,'F');
12920: IF l_debug_level > 0 THEN

Line 12917: l_msg_count:=OE_MSG_PUB.COUNT_MSG;

12913: end loop;
12914: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12915: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
12916: oe_msg_pub.transfer_msg_stack;
12917: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
12918: for I in 1..l_msg_count loop
12919: l_msg_data := OE_MSG_PUB.Get(I,'F');
12920: IF l_debug_level > 0 THEN
12921: oe_debug_pub.add( L_MSG_DATA , 1 ) ;

Line 12919: l_msg_data := OE_MSG_PUB.Get(I,'F');

12915: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
12916: oe_msg_pub.transfer_msg_stack;
12917: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
12918: for I in 1..l_msg_count loop
12919: l_msg_data := OE_MSG_PUB.Get(I,'F');
12920: IF l_debug_level > 0 THEN
12921: oe_debug_pub.add( L_MSG_DATA , 1 ) ;
12922: END IF;
12923: end loop;

Line 12939: oe_msg_pub.transfer_msg_stack;

12935:
12936: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
12937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12938:
12939: oe_msg_pub.transfer_msg_stack;
12940: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
12941: for I in 1..l_msg_count loop
12942: l_msg_data := OE_MSG_PUB.Get(I,'F');
12943: oe_msg_pub.add_text(l_msg_data);

Line 12940: l_msg_count:=OE_MSG_PUB.COUNT_MSG;

12936: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
12937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12938:
12939: oe_msg_pub.transfer_msg_stack;
12940: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
12941: for I in 1..l_msg_count loop
12942: l_msg_data := OE_MSG_PUB.Get(I,'F');
12943: oe_msg_pub.add_text(l_msg_data);
12944: IF l_debug_level > 0 THEN

Line 12942: l_msg_data := OE_MSG_PUB.Get(I,'F');

12938:
12939: oe_msg_pub.transfer_msg_stack;
12940: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
12941: for I in 1..l_msg_count loop
12942: l_msg_data := OE_MSG_PUB.Get(I,'F');
12943: oe_msg_pub.add_text(l_msg_data);
12944: IF l_debug_level > 0 THEN
12945: oe_debug_pub.add( 'INV : ' || L_MSG_DATA , 2 ) ;
12946: END IF;

Line 12943: oe_msg_pub.add_text(l_msg_data);

12939: oe_msg_pub.transfer_msg_stack;
12940: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
12941: for I in 1..l_msg_count loop
12942: l_msg_data := OE_MSG_PUB.Get(I,'F');
12943: oe_msg_pub.add_text(l_msg_data);
12944: IF l_debug_level > 0 THEN
12945: oe_debug_pub.add( 'INV : ' || L_MSG_DATA , 2 ) ;
12946: END IF;
12947: end loop;

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

12948:
12949: WHEN OTHERS THEN
12950: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12951:
12952: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
12953: THEN
12954: OE_MSG_PUB.Add_Exc_Msg
12955: ( G_PKG_NAME
12956: , 'Transfer_reservation'

Line 12954: OE_MSG_PUB.Add_Exc_Msg

12950: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12951:
12952: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
12953: THEN
12954: OE_MSG_PUB.Add_Exc_Msg
12955: ( G_PKG_NAME
12956: , 'Transfer_reservation'
12957: );
12958: END IF;

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

13261: END IF;
13262: EXCEPTION
13263: WHEN OTHERS THEN
13264:
13265: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
13266: THEN
13267: OE_MSG_PUB.Add_Exc_Msg
13268: ( G_PKG_NAME
13269: , 'PROCESS_SPLIT'

Line 13267: OE_MSG_PUB.Add_Exc_Msg

13263: WHEN OTHERS THEN
13264:
13265: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
13266: THEN
13267: OE_MSG_PUB.Add_Exc_Msg
13268: ( G_PKG_NAME
13269: , 'PROCESS_SPLIT'
13270: );
13271: END IF;

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

13845: EXCEPTION
13846: WHEN OTHERS THEN
13847: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13848:
13849: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
13850: THEN
13851: OE_MSG_PUB.Add_Exc_Msg
13852: ( G_PKG_NAME
13853: , 'Split_Scheduling'

Line 13851: OE_MSG_PUB.Add_Exc_Msg

13847: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13848:
13849: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
13850: THEN
13851: OE_MSG_PUB.Add_Exc_Msg
13852: ( G_PKG_NAME
13853: , 'Split_Scheduling'
13854: );
13855: END IF;

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

13935: EXCEPTION
13936: WHEN OTHERS THEN
13937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13938:
13939: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
13940: THEN
13941: OE_MSG_PUB.Add_Exc_Msg
13942: ( G_PKG_NAME
13943: , 'Schedule_Split_Lines'

Line 13941: OE_MSG_PUB.Add_Exc_Msg

13937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13938:
13939: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
13940: THEN
13941: OE_MSG_PUB.Add_Exc_Msg
13942: ( G_PKG_NAME
13943: , 'Schedule_Split_Lines'
13944: );
13945: END IF;

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

14147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
14148:
14149: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
14150: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
14151: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
14152: THEN
14153: OE_MSG_PUB.Add_Exc_Msg
14154: ( G_PKG_NAME
14155: , 'Schedule_line'

Line 14153: OE_MSG_PUB.Add_Exc_Msg

14149: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
14150: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
14151: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
14152: THEN
14153: OE_MSG_PUB.Add_Exc_Msg
14154: ( G_PKG_NAME
14155: , 'Schedule_line'
14156: );
14157: END IF;

Line 14224: OE_MSG_PUB.Add;

14220: IF l_debug_level > 0 THEN
14221: oe_debug_pub.add( ' THE RESERVATION PROCESS HAS FAILED ' , 1 ) ;
14222: END IF;
14223: FND_MESSAGE.SET_NAME('ONT','OE_SCH_RSV_FAILURE');
14224: OE_MSG_PUB.Add;
14225: END IF;
14226:
14227: -- Error Handling Start
14228: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 14232: OE_MSG_PUB.Transfer_Msg_Stack;

14228: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
14229: IF l_debug_level > 0 THEN
14230: oe_debug_pub.add( 'INSIDE UNEXPECTED ERROR' , 1 ) ;
14231: END IF;
14232: OE_MSG_PUB.Transfer_Msg_Stack;
14233: l_msg_count := OE_MSG_PUB.COUNT_MSG;
14234:
14235: FOR I IN 1..l_msg_count LOOP
14236: l_msg_data := OE_MSG_PUB.Get(I,'F');

Line 14233: l_msg_count := OE_MSG_PUB.COUNT_MSG;

14229: IF l_debug_level > 0 THEN
14230: oe_debug_pub.add( 'INSIDE UNEXPECTED ERROR' , 1 ) ;
14231: END IF;
14232: OE_MSG_PUB.Transfer_Msg_Stack;
14233: l_msg_count := OE_MSG_PUB.COUNT_MSG;
14234:
14235: FOR I IN 1..l_msg_count LOOP
14236: l_msg_data := OE_MSG_PUB.Get(I,'F');
14237:

Line 14236: l_msg_data := OE_MSG_PUB.Get(I,'F');

14232: OE_MSG_PUB.Transfer_Msg_Stack;
14233: l_msg_count := OE_MSG_PUB.COUNT_MSG;
14234:
14235: FOR I IN 1..l_msg_count LOOP
14236: l_msg_data := OE_MSG_PUB.Get(I,'F');
14237:
14238: IF l_debug_level > 0 THEN
14239: oe_debug_pub.add( L_MSG_DATA , 1 ) ;
14240: END IF;

Line 14248: OE_MSG_PUB.Transfer_Msg_Stack;

14244: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
14245: IF l_debug_level > 0 THEN
14246: oe_debug_pub.add( ' INSIDE EXPECTED ERROR' , 1 ) ;
14247: END IF;
14248: OE_MSG_PUB.Transfer_Msg_Stack;
14249: l_msg_count := OE_MSG_PUB.COUNT_MSG;
14250:
14251: FOR I IN 1..l_msg_count LOOP
14252: l_msg_data := OE_MSG_PUB.Get(I,'F');

Line 14249: l_msg_count := OE_MSG_PUB.COUNT_MSG;

14245: IF l_debug_level > 0 THEN
14246: oe_debug_pub.add( ' INSIDE EXPECTED ERROR' , 1 ) ;
14247: END IF;
14248: OE_MSG_PUB.Transfer_Msg_Stack;
14249: l_msg_count := OE_MSG_PUB.COUNT_MSG;
14250:
14251: FOR I IN 1..l_msg_count LOOP
14252: l_msg_data := OE_MSG_PUB.Get(I,'F');
14253: IF l_debug_level > 0 THEN

Line 14252: l_msg_data := OE_MSG_PUB.Get(I,'F');

14248: OE_MSG_PUB.Transfer_Msg_Stack;
14249: l_msg_count := OE_MSG_PUB.COUNT_MSG;
14250:
14251: FOR I IN 1..l_msg_count LOOP
14252: l_msg_data := OE_MSG_PUB.Get(I,'F');
14253: IF l_debug_level > 0 THEN
14254: oe_debug_pub.add( L_MSG_DATA , 1 ) ;
14255: END IF;
14256: END LOOP;

Line 14269: oe_msg_pub.count_and_get

14265: END IF;
14266:
14267: -- Get message count and data
14268:
14269: oe_msg_pub.count_and_get
14270: ( p_count => x_msg_count
14271: , p_data => x_msg_data
14272: );
14273:

Line 14287: oe_msg_pub.count_and_get

14283: x_return_status := FND_API.G_RET_STS_ERROR;
14284:
14285: -- Get message count and data
14286:
14287: oe_msg_pub.count_and_get
14288: ( p_count => x_msg_count
14289: , p_data => x_msg_data);
14290:
14291: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 14293: IF OE_MSG_PUB.Check_Msg_Level

14289: , p_data => x_msg_data);
14290:
14291: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
14292: -- OESCH_PERFORMED_RESERVATION := 'N';
14293: IF OE_MSG_PUB.Check_Msg_Level
14294: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
14295: THEN
14296: OE_MSG_PUB.Add_Exc_Msg
14297: (G_PKG_NAME , 'Post_Forms_Commit');

Line 14294: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

14290:
14291: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
14292: -- OESCH_PERFORMED_RESERVATION := 'N';
14293: IF OE_MSG_PUB.Check_Msg_Level
14294: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
14295: THEN
14296: OE_MSG_PUB.Add_Exc_Msg
14297: (G_PKG_NAME , 'Post_Forms_Commit');
14298: END IF;

Line 14296: OE_MSG_PUB.Add_Exc_Msg

14292: -- OESCH_PERFORMED_RESERVATION := 'N';
14293: IF OE_MSG_PUB.Check_Msg_Level
14294: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
14295: THEN
14296: OE_MSG_PUB.Add_Exc_Msg
14297: (G_PKG_NAME , 'Post_Forms_Commit');
14298: END IF;
14299:
14300: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 14304: oe_msg_pub.count_and_get

14300: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
14301:
14302: -- Get message count and data
14303:
14304: oe_msg_pub.count_and_get
14305: ( p_count => x_msg_count
14306: , p_data => x_msg_data);
14307:
14308:

Line 14653: oe_msg_pub.transfer_msg_stack;

14649:
14650: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
14651: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
14652: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
14653: oe_msg_pub.transfer_msg_stack;
14654: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
14655: FOR I in 1..l_msg_count LOOP
14656: l_msg_data := OE_MSG_PUB.Get(I,'F');
14657: IF l_debug_level > 0 THEN

Line 14654: l_msg_count:=OE_MSG_PUB.COUNT_MSG;

14650: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
14651: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
14652: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
14653: oe_msg_pub.transfer_msg_stack;
14654: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
14655: FOR I in 1..l_msg_count LOOP
14656: l_msg_data := OE_MSG_PUB.Get(I,'F');
14657: IF l_debug_level > 0 THEN
14658: oe_debug_pub.add( L_MSG_DATA , 1 ) ;

Line 14656: l_msg_data := OE_MSG_PUB.Get(I,'F');

14652: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
14653: oe_msg_pub.transfer_msg_stack;
14654: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
14655: FOR I in 1..l_msg_count LOOP
14656: l_msg_data := OE_MSG_PUB.Get(I,'F');
14657: IF l_debug_level > 0 THEN
14658: oe_debug_pub.add( L_MSG_DATA , 1 ) ;
14659: END IF;
14660: END LOOP;

Line 14741: oe_msg_pub.transfer_msg_stack;

14737:
14738: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
14739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
14740: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
14741: oe_msg_pub.transfer_msg_stack;
14742: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
14743: for I in 1..l_msg_count loop
14744: l_msg_data := OE_MSG_PUB.Get(I,'F');
14745: IF l_debug_level > 0 THEN

Line 14742: l_msg_count:=OE_MSG_PUB.COUNT_MSG;

14738: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
14739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
14740: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
14741: oe_msg_pub.transfer_msg_stack;
14742: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
14743: for I in 1..l_msg_count loop
14744: l_msg_data := OE_MSG_PUB.Get(I,'F');
14745: IF l_debug_level > 0 THEN
14746: oe_debug_pub.add( L_MSG_DATA , 1 ) ;

Line 14744: l_msg_data := OE_MSG_PUB.Get(I,'F');

14740: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
14741: oe_msg_pub.transfer_msg_stack;
14742: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
14743: for I in 1..l_msg_count loop
14744: l_msg_data := OE_MSG_PUB.Get(I,'F');
14745: IF l_debug_level > 0 THEN
14746: oe_debug_pub.add( L_MSG_DATA , 1 ) ;
14747: END IF;
14748: end loop;

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

14769:
14770: WHEN OTHERS THEN
14771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
14772:
14773: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
14774: THEN
14775: OE_MSG_PUB.Add_Exc_Msg
14776: ( G_PKG_NAME
14777: , 'Do_Unreserve'

Line 14775: OE_MSG_PUB.Add_Exc_Msg

14771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
14772:
14773: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
14774: THEN
14775: OE_MSG_PUB.Add_Exc_Msg
14776: ( G_PKG_NAME
14777: , 'Do_Unreserve'
14778: );
14779: END IF;

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

15626:
15627: EXCEPTION
15628: WHEN OTHERS THEN
15629:
15630: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
15631: THEN
15632: OE_MSG_PUB.Add_Exc_Msg
15633: ( G_PKG_NAME
15634: , 'Global_ATP'

Line 15632: OE_MSG_PUB.Add_Exc_Msg

15628: WHEN OTHERS THEN
15629:
15630: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
15631: THEN
15632: OE_MSG_PUB.Add_Exc_Msg
15633: ( G_PKG_NAME
15634: , 'Global_ATP'
15635: );
15636: END IF;

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

15726:
15727: EXCEPTION
15728: WHEN OTHERS THEN
15729:
15730: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
15731: THEN
15732: OE_MSG_PUB.Add_Exc_Msg
15733: ( G_PKG_NAME
15734: , 'Cascade_Ship_set_attr'

Line 15732: OE_MSG_PUB.Add_Exc_Msg

15728: WHEN OTHERS THEN
15729:
15730: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
15731: THEN
15732: OE_MSG_PUB.Add_Exc_Msg
15733: ( G_PKG_NAME
15734: , 'Cascade_Ship_set_attr'
15735: );
15736: END IF;

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

15840:
15841: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
15842:
15843: /*
15844: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
15845: THEN
15846: OE_MSG_PUB.Add_Exc_Msg
15847: ( G_PKG_NAME,
15848: 'MRP_ROLLBACK');

Line 15846: OE_MSG_PUB.Add_Exc_Msg

15842:
15843: /*
15844: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
15845: THEN
15846: OE_MSG_PUB.Add_Exc_Msg
15847: ( G_PKG_NAME,
15848: 'MRP_ROLLBACK');
15849: END IF;
15850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

15883:
15884: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
15885:
15886: /*
15887: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
15888: THEN
15889: OE_MSG_PUB.Add_Exc_Msg
15890: ( G_PKG_NAME,
15891: 'Call_MRP_ROLLBACK');

Line 15889: OE_MSG_PUB.Add_Exc_Msg

15885:
15886: /*
15887: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
15888: THEN
15889: OE_MSG_PUB.Add_Exc_Msg
15890: ( G_PKG_NAME,
15891: 'Call_MRP_ROLLBACK');
15892: END IF;
15893: */

Line 16043: Oe_Msg_Pub.Add;

16039:
16040: IF l_shippable_flag <> p_old_shippable_flag THEN
16041: oe_debug_pub.add( 'Item substitution cannot happen between shippable and non-shippable items' , 5 ) ;
16042: Fnd_Message.set_name('ONT','OE_SCH_LOOP_SHP_NONSHP');
16043: Oe_Msg_Pub.Add;
16044: OE_SCHEDULE_UTIL.OESCH_ITEM_IS_SUBSTITUTED := 'N';
16045: RAISE FND_API.G_EXC_ERROR;
16046: END IF;
16047: END;