DBA Data[Home] [Help]

APPS.GMI_AUTO_ALLOC_BATCH_PKG dependencies on FND_MSG_PUB

Line 159: FND_MSG_PUB.initialize;

155: /* Check p_init_msg_list
156: =========================================*/
157: IF FND_API.to_boolean(p_init_msg_list)
158: THEN
159: FND_MSG_PUB.initialize;
160: END IF;
161:
162: GMI_RESERVATION_UTIL.PrintLn (' After initialize IN Auto_allocation_batch');
163:

Line 168: FND_MSG_PUB.Add;

164: IF( NVL(p_batch_id,0) = 0 ) THEN
165: GMI_RESERVATION_UTIL.PrintLn('Batch id is missing');
166: FND_MESSAGE.Set_Name('GMI','Missing');
167: FND_MESSAGE.Set_Token('MISSING', 'Batch_Id');
168: FND_MSG_PUB.Add;
169: RAISE FND_API.G_EXC_ERROR;
170: END IF;
171:
172: OPEN get_batch_rec_cur;

Line 180: FND_MSG_PUB.Add;

176: CLOSE get_batch_rec_cur;
177: GMI_RESERVATION_UTIL.PrintLn('No record in the batch table for batch id: '|| p_batch_id );
178: FND_MESSAGE.Set_Name('GMI','Missing');
179: FND_MESSAGE.Set_Token('Missing','Batch_id');
180: FND_MSG_PUB.Add;
181: RAISE FND_API.G_EXC_ERROR;
182: END IF;
183:
184: CLOSE get_batch_rec_cur;

Line 381: FND_MSG_PUB.Add;

377: THEN
378: GMI_reservation_Util.PrintLn('Return_status from Auto_Alloc_Wdd_Line : '||l_return_status);
379: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS( 'WARNING', '');
380: FND_MESSAGE.Set_Name('GMI','GMI_AUTO_ALLOC_WDD_LINE_ERROR');
381: FND_MSG_PUB.Add;
382: RAISE FND_API.G_EXC_ERROR;
383: END IF;
384: x_return_status := l_return_status;
385:

Line 423: FND_MSG_PUB.Add;

419: THEN
420: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS( 'WARNING', '');
421: GMI_reservation_Util.PrintLn('Return_status from call_pick_confirm : '||x_return_status);
422: FND_MESSAGE.Set_Name('GMI','GMI_PICK_CONFIRM_ERROR');
423: FND_MSG_PUB.Add;
424: RAISE FND_API.G_EXC_ERROR;
425: END IF;
426:
427: ELSE

Line 449: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

445: x_return_status := FND_API.G_RET_STS_ERROR;
446: errbuf := SUBSTRB(SQLERRM, 1, 150);
447: retcode := x_return_status;
448:
449: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
450: , l_api_name
451: );
452: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
453: , p_count => x_msg_count

Line 452: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE

448:
449: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
450: , l_api_name
451: );
452: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
453: , p_count => x_msg_count
454: , p_data => x_msg_data
455: );
456:

Line 467: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

463: errbuf := SUBSTRB(SQLERRM, 1, 150);
464: retcode := x_return_status;
465:
466:
467: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
468: , l_api_name
469: );
470: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
471: , p_count => x_msg_count

Line 470: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE

466:
467: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
468: , l_api_name
469: );
470: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
471: , p_count => x_msg_count
472: , p_data => x_msg_data
473: );
474: WHEN OTHERS THEN

Line 479: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

475: --ROLLBACK TO SAVEPOINT Auto_Allocate_Batch_SP;
476: GMI_RESERVATION_UTIL.PrintLn('sqlcode : ' ||to_char(sqlcode));
477: GMI_RESERVATION_UTIL.PrintLn('sqlerr : '|| SUBSTRB(SQLERRM, 1, 150));
478:
479: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
480: , l_api_name
481: );
482:
483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 488: FND_MSG_PUB.count_and_get

484: errbuf := SUBSTRB(SQLERRM, 1, 150);
485: retcode := x_return_status;
486:
487: /* Get message count and data */
488: FND_MSG_PUB.count_and_get
489: ( p_count => x_msg_count
490: , p_data => x_msg_data
491: );
492:

Line 671: FND_MSG_PUB.initialize;

667: /* Check p_init_msg_list
668: =========================================*/
669: IF FND_API.to_boolean(p_init_msg_list)
670: THEN
671: FND_MSG_PUB.initialize;
672: END IF;
673:
674: GMI_RESERVATION_UTIL.PrintLn('In Procedure Auto_Alloc_WDD_Line After Initialize');
675:

Line 973: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

969: x_return_status := FND_API.G_RET_STS_ERROR;
970:
971: GMI_RESERVATION_UTIL.PrintLn('In Exception FND_API.G_EXC_ERROR In Procedure Auto_Alloc_Wdd_Line ');
972:
973: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
974: , l_api_name
975: );
976: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
977: , p_count => x_msg_count

Line 976: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE

972:
973: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
974: , l_api_name
975: );
976: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
977: , p_count => x_msg_count
978: , p_data => x_msg_data
979: );
980:

Line 987: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

983:
984: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
985: GMI_RESERVATION_UTIL.PrintLn('In Exception FND_API.G_EXC_UNEXPECTED_ERROR In Procedure Auto_Alloc_Wdd_Line ');
986:
987: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
988: , l_api_name
989: );
990: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
991: , p_count => x_msg_count

Line 990: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE

986:
987: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
988: , l_api_name
989: );
990: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
991: , p_count => x_msg_count
992: , p_data => x_msg_data
993: );
994: WHEN OTHERS THEN

Line 997: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

993: );
994: WHEN OTHERS THEN
995: ROLLBACK TO SAVEPOINT Auto_Alloc_Wdd_Line_SP;
996: GMI_RESERVATION_UTIL.PrintLn('In Exception OTHERS In Procedure Auto_Alloc_Wdd_Line ');
997: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
998: , l_api_name
999: );
1000:
1001: /* Get message count and data */

Line 1002: FND_MSG_PUB.count_and_get

998: , l_api_name
999: );
1000:
1001: /* Get message count and data */
1002: FND_MSG_PUB.count_and_get
1003: ( p_count => x_msg_count
1004: , p_data => x_msg_data
1005: );
1006:

Line 1087: FND_MSG_PUB.Initialize;

1083: x_return_status := FND_API.G_RET_STS_SUCCESS;
1084:
1085: IF (p_init_msg_list = 1)
1086: THEN
1087: FND_MSG_PUB.Initialize;
1088: END IF;
1089:
1090: GMI_RESERVATION_UTIL.PrintLn('In Call_Pick_Confirm after initialize');
1091: /* check what is the move order type. If it's a non pick wave mo,

Line 1209: FND_MSG_PUB.Add;

1205: GMI_Reservation_Util.PrintLn('return error');
1206: FND_MESSAGE.Set_Name('GMI','PICK_CONFIRM_ERROR');
1207: FND_MESSAGE.Set_Token('WHERE', 'AFTER_CALL_PICK_CONFIRM');
1208: FND_MESSAGE.Set_Token('WHAT', 'UnexpectedError');
1209: FND_MSG_PUB.Add;
1210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1211: END IF;
1212:
1213: IF ( ll_mo_line_tbl.count = 0 )

Line 1219: FND_MSG_PUB.Add;

1215: GMI_Reservation_Util.PrintLn('return error');
1216: FND_MESSAGE.Set_Name('GMI','PICK_CONFIRM_ERROR');
1217: FND_MESSAGE.Set_Token('WHERE', 'MO_LINE_COUNT_0');
1218: FND_MESSAGE.Set_Token('WHAT', 'UnexpectedError');
1219: FND_MSG_PUB.Add;
1220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1221: END IF;
1222:
1223: END IF;

Line 1249: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

1245: WHEN FND_API.G_EXC_ERROR THEN
1246: /* ROLLBACK TO SAVEPOINT GMI_Before_Pick_Confirm; */
1247:
1248: x_return_status := FND_API.G_RET_STS_ERROR;
1249: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
1250:
1251: WHEN G_RET_STS_WARNING THEN
1252:
1253: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 1266: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1262: ELSE
1263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1264: END IF;
1265:
1266: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1267: THEN
1268: FND_MSG_PUB.Add_Exc_Msg
1269: ( G_PKG_NAME
1270: , 'Call_Pick_Confirm');

Line 1268: FND_MSG_PUB.Add_Exc_Msg

1264: END IF;
1265:
1266: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1267: THEN
1268: FND_MSG_PUB.Add_Exc_Msg
1269: ( G_PKG_NAME
1270: , 'Call_Pick_Confirm');
1271: END IF;
1272: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

Line 1272: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

1268: FND_MSG_PUB.Add_Exc_Msg
1269: ( G_PKG_NAME
1270: , 'Call_Pick_Confirm');
1271: END IF;
1272: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
1273:
1274: END Call_Pick_Confirm;
1275:
1276: PROCEDURE get_allocation_record

Line 1374: FND_MSG_PUB.Add;

1370: GMI_reservation_Util.PrintLn('Customer info not found');
1371: GMI_reservation_Util.PrintLn('in Util v: cust_no=NOTFOUND');
1372: FND_MESSAGE.Set_Name('GMI','GMI_CUST_INFO');
1373: FND_MESSAGE.Set_Token('SO_LINE_ID', x_allocation_rec.line_id);
1374: FND_MSG_PUB.Add;
1375: RAISE FND_API.G_EXC_ERROR;
1376: ELSE
1377: GMI_reservation_Util.PrintLn(' in Util v: cust_id='||x_allocation_rec.of_cust_id||',
1378: doc_line='||x_allocation_rec.doc_line);

Line 1393: FND_MSG_PUB.Add;

1389:
1390: IF ( x_allocation_rec.doc_id IS NULL ) THEN
1391: FND_MESSAGE.SET_NAME('GMI','INV_COULD_NOT_GET_MSO_HEADER');
1392: FND_MESSAGE.Set_Token('OE_HEADER_ID', l_header_id);
1393: FND_MSG_PUB.Add;
1394: RAISE FND_API.G_EXC_ERROR;
1395: END IF;
1396:
1397: OPEN get_allocated_qty (p_wdd_line.source_line_id, p_wdd_line.delivery_detail_id);

Line 1453: FND_MSG_PUB.Add;

1449: CLOSE Cur_get_process_org;
1450: GMI_reservation_Util.PrintLn(' in end of Get_Allocation__Record ERROR:No rows found for cur_get_process_org.');
1451: FND_MESSAGE.Set_Name('GMI','GMI_GET_PROCESS_ORG');
1452: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_wdd_line.organization_id);
1453: FND_MSG_PUB.Add;
1454: RAISE FND_API.G_EXC_ERROR;
1455: ELSE
1456: CLOSE Cur_get_process_org;
1457: END IF;

Line 1485: FND_MSG_PUB.Add;

1481: ERROR:Returned by Get_OPM_item_from_Apps.');
1482: FND_MESSAGE.Set_Name('GMI','GMI_OPM_ITEM');
1483: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_wdd_line.organization_id);
1484: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_wdd_line.inventory_item_id);
1485: FND_MSG_PUB.Add;
1486: RAISE FND_API.G_EXC_ERROR;
1487: ELSE
1488: x_allocation_rec.item_no := x_ic_item_mst_rec.item_no;
1489: END IF;

Line 1519: FND_MSG_PUB.count_and_get

1515: GMI_Reservation_Util.PrintLn('Exiting Util Get_Allocation_Record: Error');
1516: x_return_status := FND_API.G_RET_STS_ERROR;
1517:
1518: /* Get message count and data */
1519: FND_MSG_PUB.count_and_get
1520: ( p_count => x_msg_count
1521: , p_data => x_msg_data
1522: );
1523:

Line 1528: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

1524: WHEN OTHERS THEN
1525: GMI_Reservation_Util.PrintLn('Exiting Util Get_Allocation_Record: ErrorOther');
1526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1527:
1528: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
1529: , l_api_name
1530: );
1531:
1532: /* Get message count and data */

Line 1533: FND_MSG_PUB.count_and_get

1529: , l_api_name
1530: );
1531:
1532: /* Get message count and data */
1533: FND_MSG_PUB.count_and_get
1534: ( p_count => x_msg_count
1535: , p_data => x_msg_data
1536: );
1537:

Line 1659: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1655: WSH_UTIL_CORE.Println(' Line Insert Error => ' || l_err_no || l_err_msg);
1656: gmi_reservation_util.Println(' Line Insert Error => ' || l_err_no ||
1657: l_err_msg );
1658:
1659: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1660: THEN
1661: FND_MSG_PUB.Add_Exc_Msg
1662: ( G_PKG_NAME
1663: , 'Insert_Row'

Line 1661: FND_MSG_PUB.Add_Exc_Msg

1657: l_err_msg );
1658:
1659: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1660: THEN
1661: FND_MSG_PUB.Add_Exc_Msg
1662: ( G_PKG_NAME
1663: , 'Insert_Row'
1664: );
1665: END IF;