DBA Data[Home] [Help]

APPS.ENG_IMPL_ITEM_CHANGES_PKG dependencies on FND_MSG_PUB

Line 433: FND_MSG_PUB.Add;

429: THEN
430:
431: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
432: FND_MESSAGE.Set_Token('OBJECT_NAME', 'GetChangeId:'|| 'no change Id');
433: FND_MSG_PUB.Add;
434: RAISE FND_API.G_EXC_ERROR;
435:
436: END IF ;
437:

Line 1152: FND_MSG_PUB.initialize;

1148:
1149:
1150: -- Initialize message list if p_init_msg_list is set to TRUE.
1151: IF FND_API.to_Boolean( l_init_msg_list ) THEN
1152: FND_MSG_PUB.initialize;
1153: END IF;
1154:
1155: -- Open Debug Session by a give param or profile option.
1156: Open_Debug_Session(p_debug, p_output_dir, p_debug_filename) ;

Line 1226: FND_MSG_PUB.Add;

1222: x_msg_count := l_msg_count;
1223: x_msg_data := l_msg_data;
1224: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
1225: FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_IMPL_ITEM_CHANGES_PKG.impl_rev_item_user_attr_chgs');
1226: FND_MSG_PUB.Add;
1227:
1228: RAISE FND_API.G_EXC_ERROR;
1229:
1230: END IF;

Line 1286: FND_MSG_PUB.Add;

1282: x_msg_count := l_msg_count;
1283: x_msg_data := l_msg_data;
1284: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
1285: FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_IMPL_ITEM_CHANGES_PKG.impl_rev_item_gdsn_attr_chgs');
1286: FND_MSG_PUB.Add;
1287:
1288: RAISE FND_API.G_EXC_ERROR;
1289:
1290: END IF;

Line 1320: FND_MSG_PUB.Add;

1316: x_msg_data := l_msg_data;
1317:
1318: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
1319: FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_IMPL_ITEM_CHANGES_PKG.impl_rev_item_aml_changes');
1320: FND_MSG_PUB.Add;
1321:
1322: RAISE FND_API.G_EXC_ERROR;
1323:
1324: END IF;

Line 1341: FND_MSG_PUB.Count_And_Get

1337: COMMIT WORK;
1338: END IF;
1339:
1340: -- Standard call to get message count and if count is 1, get message info.
1341: FND_MSG_PUB.Count_And_Get
1342: ( p_count => x_msg_count ,
1343: p_data => x_msg_data
1344: );
1345:

Line 1347: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

1343: p_data => x_msg_data
1344: );
1345:
1346:
1347: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1348:
1349: Write_Debug('Dumping Message number : '|| I );
1350: Write_Debug('DATA = '||replace(substr(FND_MSG_PUB.Get(I), 1, 200), chr(0), ' '));
1351:

Line 1350: Write_Debug('DATA = '||replace(substr(FND_MSG_PUB.Get(I), 1, 200), chr(0), ' '));

1346:
1347: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1348:
1349: Write_Debug('Dumping Message number : '|| I );
1350: Write_Debug('DATA = '||replace(substr(FND_MSG_PUB.Get(I), 1, 200), chr(0), ' '));
1351:
1352: END LOOP;
1353:
1354:

Line 1376: FND_MSG_PUB.Count_And_Get

1372: Write_Debug('ROLLBACK Impl Item Changes to IMPL_ITEM_CHANGES. . ');
1373: ROLLBACK TO IMPL_ITEM_CHANGES;
1374: END IF;
1375:
1376: FND_MSG_PUB.Count_And_Get
1377: ( p_count => x_msg_count ,
1378: p_data => x_msg_data
1379: );
1380:

Line 1384: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

1380:
1381:
1382:
1383:
1384: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1385:
1386: Write_Debug('Dumping Message number : '|| I );
1387: Write_Debug('DATA = '||replace(substr(FND_MSG_PUB.Get(I), 1, 200), chr(0), ' '));
1388:

Line 1387: Write_Debug('DATA = '||replace(substr(FND_MSG_PUB.Get(I), 1, 200), chr(0), ' '));

1383:
1384: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1385:
1386: Write_Debug('Dumping Message number : '|| I );
1387: Write_Debug('DATA = '||replace(substr(FND_MSG_PUB.Get(I), 1, 200), chr(0), ' '));
1388:
1389: END LOOP;
1390:
1391:

Line 1407: FND_MSG_PUB.Count_And_Get

1403: Write_Debug('ROLLBACK Impl Item Changes to IMPL_ITEM_CHANGES. . ');
1404: ROLLBACK TO IMPL_ITEM_CHANGES;
1405: END IF;
1406:
1407: FND_MSG_PUB.Count_And_Get
1408: ( p_count => x_msg_count ,
1409: p_data => x_msg_data
1410: );
1411:

Line 1413: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

1409: p_data => x_msg_data
1410: );
1411:
1412:
1413: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1414:
1415: Write_Debug('Dumping Message number : '|| I );
1416: Write_Debug('DATA = '||replace(substr(FND_MSG_PUB.Get(I), 1, 200), chr(0), ' '));
1417:

Line 1416: Write_Debug('DATA = '||replace(substr(FND_MSG_PUB.Get(I), 1, 200), chr(0), ' '));

1412:
1413: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1414:
1415: Write_Debug('Dumping Message number : '|| I );
1416: Write_Debug('DATA = '||replace(substr(FND_MSG_PUB.Get(I), 1, 200), chr(0), ' '));
1417:
1418: END LOOP;
1419:
1420: -----------------------------------------------------

Line 1438: FND_MSG_PUB.Add;

1434: Write_Debug('When Others Exception ' || Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240));
1435:
1436: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
1437: FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_IMPL_ITEM_CHANGES_PKG.impl_item_changes for ChangeId: '||l_change_id || '- ChangeLineId: '||l_change_line_id);
1438: FND_MSG_PUB.Add;
1439:
1440:
1441: IF FND_MSG_PUB.Check_Msg_Level
1442: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1441: IF FND_MSG_PUB.Check_Msg_Level

1437: FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_IMPL_ITEM_CHANGES_PKG.impl_item_changes for ChangeId: '||l_change_id || '- ChangeLineId: '||l_change_line_id);
1438: FND_MSG_PUB.Add;
1439:
1440:
1441: IF FND_MSG_PUB.Check_Msg_Level
1442: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1443: THEN
1444: FND_MSG_PUB.Add_Exc_Msg
1445: ( G_PKG_NAME ,

Line 1442: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1438: FND_MSG_PUB.Add;
1439:
1440:
1441: IF FND_MSG_PUB.Check_Msg_Level
1442: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1443: THEN
1444: FND_MSG_PUB.Add_Exc_Msg
1445: ( G_PKG_NAME ,
1446: l_api_name

Line 1444: FND_MSG_PUB.Add_Exc_Msg

1440:
1441: IF FND_MSG_PUB.Check_Msg_Level
1442: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1443: THEN
1444: FND_MSG_PUB.Add_Exc_Msg
1445: ( G_PKG_NAME ,
1446: l_api_name
1447: );
1448: END IF;

Line 1450: FND_MSG_PUB.Count_And_Get

1446: l_api_name
1447: );
1448: END IF;
1449:
1450: FND_MSG_PUB.Count_And_Get
1451: ( p_count => x_msg_count ,
1452: p_data => x_msg_data
1453: );
1454:

Line 1456: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

1452: p_data => x_msg_data
1453: );
1454:
1455:
1456: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1457:
1458: Write_Debug('Dumping Message number : '|| I );
1459: Write_Debug('DATA = '||replace(substr(FND_MSG_PUB.Get(I), 1, 200), chr(0), ' '));
1460:

Line 1459: Write_Debug('DATA = '||replace(substr(FND_MSG_PUB.Get(I), 1, 200), chr(0), ' '));

1455:
1456: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1457:
1458: Write_Debug('Dumping Message number : '|| I );
1459: Write_Debug('DATA = '||replace(substr(FND_MSG_PUB.Get(I), 1, 200), chr(0), ' '));
1460:
1461: END LOOP;
1462:
1463:

Line 1636: FND_MSG_PUB.initialize;

1632:
1633:
1634: -- Initialize message list if p_init_msg_list is set to TRUE.
1635: IF FND_API.to_Boolean( l_init_msg_list ) THEN
1636: FND_MSG_PUB.initialize;
1637: END IF;
1638:
1639: -- Open Debug Session by a give param or profile option.
1640: Open_Debug_Session(p_debug, p_output_dir, p_debug_filename) ;

Line 2138: FND_MSG_PUB.Add;

2134:
2135: -- We don't support this in R12
2136: FND_MESSAGE.Set_Name('ENG','ENG_IMPL_INVALID_ACD_TYPE');
2137: FND_MESSAGE.Set_Token('ACD_TYPE', l_current_acd_type);
2138: FND_MSG_PUB.Add;
2139: RAISE FND_API.G_EXC_ERROR;
2140:
2141: END IF;
2142:

Line 2392: FND_MSG_PUB.Add_Exc_Msg

2388: RAISE FND_API.G_EXC_ERROR;
2389:
2390: WHEN OTHERS THEN
2391:
2392: FND_MSG_PUB.Add_Exc_Msg
2393: ( p_pkg_name => 'EGO_ITEM_PUB' ,
2394: p_procedure_name => 'Process_Item',
2395: p_error_text => Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240)
2396: );

Line 2401: FND_MSG_PUB.Add;

2397:
2398:
2399: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
2400: FND_MESSAGE.Set_Token('OBJECT_NAME', 'EGO_ITEM_PUB.Process_Item');
2401: FND_MSG_PUB.Add;
2402:
2403: Write_Debug('When Others Exception while calling EGO_ITEM_PUB.Process_Item' || Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240));
2404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2405:

Line 2418: FND_MSG_PUB.Add_Exc_Msg

2414: l_msg_index := l_message_list.FIRST ;
2415:
2416: WHILE l_msg_index IS NOT NULL
2417: LOOP
2418: FND_MSG_PUB.Add_Exc_Msg
2419: ( p_pkg_name => null ,
2420: p_procedure_name => null ,
2421: p_error_text => l_message_list(l_msg_index).message_text
2422: );

Line 2428: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

2424: l_msg_index := l_message_list.NEXT(l_msg_index);
2425:
2426: END LOOP;
2427:
2428: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
2429:
2430: -- FND_MSG_PUB.dump_Msg(I);
2431: Write_Debug('Dumping Message number : '|| I );
2432: Write_Debug('DATA = '||replace(substr(FND_MSG_PUB.Get(I), 1, 200), chr(0), ' '));

Line 2430: -- FND_MSG_PUB.dump_Msg(I);

2426: END LOOP;
2427:
2428: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
2429:
2430: -- FND_MSG_PUB.dump_Msg(I);
2431: Write_Debug('Dumping Message number : '|| I );
2432: Write_Debug('DATA = '||replace(substr(FND_MSG_PUB.Get(I), 1, 200), chr(0), ' '));
2433:
2434: END LOOP;

Line 2432: Write_Debug('DATA = '||replace(substr(FND_MSG_PUB.Get(I), 1, 200), chr(0), ' '));

2428: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
2429:
2430: -- FND_MSG_PUB.dump_Msg(I);
2431: Write_Debug('Dumping Message number : '|| I );
2432: Write_Debug('DATA = '||replace(substr(FND_MSG_PUB.Get(I), 1, 200), chr(0), ' '));
2433:
2434: END LOOP;
2435:
2436:

Line 2448: FND_MSG_PUB.Add;

2444: Write_Debug('Output - Return Stattus: ' || substr(l_msg_data,1,200));
2445:
2446: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
2447: FND_MESSAGE.Set_Token('OBJECT_NAME', 'EGO_ITEM_PUB.Process_Item');
2448: FND_MSG_PUB.Add;
2449:
2450: RAISE FND_API.G_EXC_ERROR ;
2451:
2452: END IF;

Line 2496: FND_MSG_PUB.Count_And_Get

2492: COMMIT WORK;
2493: END IF;
2494:
2495: -- Standard call to get message count and if count is 1, get message info.
2496: FND_MSG_PUB.Count_And_Get
2497: ( p_count => x_msg_count ,
2498: p_data => x_msg_data
2499: );
2500:

Line 2526: FND_MSG_PUB.Add;

2522: END IF;
2523:
2524: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
2525: FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_IMPL_ITEM_CHANGES_PKG.impl_rev_item_attr_changes for ChangeId: '||l_change_id || '- ChangeLineId: '||l_change_line_id);
2526: FND_MSG_PUB.Add;
2527:
2528:
2529: FND_MSG_PUB.Count_And_Get
2530: ( p_count => x_msg_count ,

Line 2529: FND_MSG_PUB.Count_And_Get

2525: FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_IMPL_ITEM_CHANGES_PKG.impl_rev_item_attr_changes for ChangeId: '||l_change_id || '- ChangeLineId: '||l_change_line_id);
2526: FND_MSG_PUB.Add;
2527:
2528:
2529: FND_MSG_PUB.Count_And_Get
2530: ( p_count => x_msg_count ,
2531: p_data => x_msg_data
2532: );
2533:

Line 2557: FND_MSG_PUB.Add;

2553:
2554:
2555: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
2556: FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_IMPL_ITEM_CHANGES_PKG.impl_rev_item_attr_changes for ChangeId: '||l_change_id || '- ChangeLineId: '||l_change_line_id);
2557: FND_MSG_PUB.Add;
2558:
2559: FND_MSG_PUB.Count_And_Get
2560: ( p_count => x_msg_count ,
2561: p_data => x_msg_data

Line 2559: FND_MSG_PUB.Count_And_Get

2555: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
2556: FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_IMPL_ITEM_CHANGES_PKG.impl_rev_item_attr_changes for ChangeId: '||l_change_id || '- ChangeLineId: '||l_change_line_id);
2557: FND_MSG_PUB.Add;
2558:
2559: FND_MSG_PUB.Count_And_Get
2560: ( p_count => x_msg_count ,
2561: p_data => x_msg_data
2562: );
2563:

Line 2592: FND_MSG_PUB.Add;

2588:
2589:
2590: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
2591: FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_IMPL_ITEM_CHANGES_PKG.impl_rev_item_attr_changes for ChangeId: '||l_change_id || '- ChangeLineId: '||l_change_line_id);
2592: FND_MSG_PUB.Add;
2593:
2594:
2595: IF FND_MSG_PUB.Check_Msg_Level
2596: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 2595: IF FND_MSG_PUB.Check_Msg_Level

2591: FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_IMPL_ITEM_CHANGES_PKG.impl_rev_item_attr_changes for ChangeId: '||l_change_id || '- ChangeLineId: '||l_change_line_id);
2592: FND_MSG_PUB.Add;
2593:
2594:
2595: IF FND_MSG_PUB.Check_Msg_Level
2596: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2597: THEN
2598: FND_MSG_PUB.Add_Exc_Msg
2599: ( G_PKG_NAME ,

Line 2596: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2592: FND_MSG_PUB.Add;
2593:
2594:
2595: IF FND_MSG_PUB.Check_Msg_Level
2596: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2597: THEN
2598: FND_MSG_PUB.Add_Exc_Msg
2599: ( G_PKG_NAME ,
2600: l_api_name

Line 2598: FND_MSG_PUB.Add_Exc_Msg

2594:
2595: IF FND_MSG_PUB.Check_Msg_Level
2596: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2597: THEN
2598: FND_MSG_PUB.Add_Exc_Msg
2599: ( G_PKG_NAME ,
2600: l_api_name
2601: );
2602: END IF;

Line 2604: FND_MSG_PUB.Count_And_Get

2600: l_api_name
2601: );
2602: END IF;
2603:
2604: FND_MSG_PUB.Count_And_Get
2605: ( p_count => x_msg_count ,
2606: p_data => x_msg_data
2607: );
2608:

Line 2686: FND_MSG_PUB.initialize;

2682: END IF;
2683:
2684: -- Initialize message list if p_init_msg_list is set to TRUE.
2685: IF FND_API.to_Boolean( l_init_msg_list ) THEN
2686: FND_MSG_PUB.initialize;
2687: END IF;
2688:
2689: -- Open Debug Session by a give param or profile option.
2690: Open_Debug_Session(p_debug, p_output_dir, p_debug_filename) ;

Line 2766: Write_Debug(' msg no '||i ||': '|| fnd_msg_pub.Get(p_msg_index => i,p_encoded => 'F'));

2762:
2763: Write_Debug('After calling EGO_ITEM_AML_PUB.Implement_AML_Changes for Return Status: ' || l_return_status);
2764: IF l_msg_count > 1 THEN
2765: for i in 1..l_msg_count loop
2766: Write_Debug(' msg no '||i ||': '|| fnd_msg_pub.Get(p_msg_index => i,p_encoded => 'F'));
2767: end loop;
2768: else
2769: Write_Debug('Implement_AML_Changes Error message : ' || l_msg_data);
2770: END IF;

Line 2776: FND_MSG_PUB.Add_Exc_Msg

2772:
2773: EXCEPTION
2774: WHEN OTHERS THEN
2775:
2776: FND_MSG_PUB.Add_Exc_Msg
2777: ( p_pkg_name => 'EGO_ITEM_AML_PUB' ,
2778: p_procedure_name => 'Implement_AML_Changes',
2779: p_error_text => Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240)
2780: );

Line 2785: FND_MSG_PUB.Add;

2781:
2782:
2783: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
2784: FND_MESSAGE.Set_Token('OBJECT_NAME', 'EGO_ITEM_AML_PUB.Implement_AML_Changes');
2785: FND_MSG_PUB.Add;
2786:
2787: Write_Debug('When Others Exception while calling EGO_ITEM_AML_PUB.Implement_AML_Changes:' || Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240));
2788: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2789: END ;

Line 2805: FND_MSG_PUB.Add;

2801:
2802:
2803: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
2804: FND_MESSAGE.Set_Token('OBJECT_NAME', 'EGO_ITEM_AML_PUB.Implement_AML_Changes');
2805: FND_MSG_PUB.Add;
2806:
2807: RAISE FND_API.G_EXC_ERROR;
2808: END IF;
2809:

Line 2822: FND_MSG_PUB.Count_And_Get

2818: COMMIT WORK;
2819: END IF;
2820:
2821: -- Standard call to get message count and if count is 1, get message info.
2822: FND_MSG_PUB.Count_And_Get
2823: ( p_count => x_msg_count ,
2824: p_data => x_msg_data
2825: );
2826:

Line 2852: FND_MSG_PUB.Add;

2848: END IF;
2849:
2850: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
2851: FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_IMPL_ITEM_CHANGES_PKG.impl_rev_item_aml_changes for ChangeId: '||l_change_id || '- ChangeLineId: '||l_change_line_id);
2852: FND_MSG_PUB.Add;
2853:
2854:
2855: FND_MSG_PUB.Count_And_Get
2856: ( p_count => x_msg_count ,

Line 2855: FND_MSG_PUB.Count_And_Get

2851: FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_IMPL_ITEM_CHANGES_PKG.impl_rev_item_aml_changes for ChangeId: '||l_change_id || '- ChangeLineId: '||l_change_line_id);
2852: FND_MSG_PUB.Add;
2853:
2854:
2855: FND_MSG_PUB.Count_And_Get
2856: ( p_count => x_msg_count ,
2857: p_data => x_msg_data
2858: );
2859:

Line 2883: FND_MSG_PUB.Add;

2879:
2880:
2881: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
2882: FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_IMPL_ITEM_CHANGES_PKG.impl_rev_item_aml_changes for ChangeId: '||l_change_id || '- ChangeLineId: '||l_change_line_id);
2883: FND_MSG_PUB.Add;
2884:
2885: FND_MSG_PUB.Count_And_Get
2886: ( p_count => x_msg_count ,
2887: p_data => x_msg_data

Line 2885: FND_MSG_PUB.Count_And_Get

2881: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
2882: FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_IMPL_ITEM_CHANGES_PKG.impl_rev_item_aml_changes for ChangeId: '||l_change_id || '- ChangeLineId: '||l_change_line_id);
2883: FND_MSG_PUB.Add;
2884:
2885: FND_MSG_PUB.Count_And_Get
2886: ( p_count => x_msg_count ,
2887: p_data => x_msg_data
2888: );
2889:

Line 2915: FND_MSG_PUB.Add;

2911: Write_Debug('When Others Exception ' || Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240));
2912:
2913: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
2914: FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_IMPL_ITEM_CHANGES_PKG.impl_rev_item_aml_changes for ChangeId: '||l_change_id || '- ChangeLineId: '||l_change_line_id);
2915: FND_MSG_PUB.Add;
2916:
2917:
2918: IF FND_MSG_PUB.Check_Msg_Level
2919: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 2918: IF FND_MSG_PUB.Check_Msg_Level

2914: FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_IMPL_ITEM_CHANGES_PKG.impl_rev_item_aml_changes for ChangeId: '||l_change_id || '- ChangeLineId: '||l_change_line_id);
2915: FND_MSG_PUB.Add;
2916:
2917:
2918: IF FND_MSG_PUB.Check_Msg_Level
2919: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2920: THEN
2921: FND_MSG_PUB.Add_Exc_Msg
2922: ( G_PKG_NAME ,

Line 2919: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2915: FND_MSG_PUB.Add;
2916:
2917:
2918: IF FND_MSG_PUB.Check_Msg_Level
2919: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2920: THEN
2921: FND_MSG_PUB.Add_Exc_Msg
2922: ( G_PKG_NAME ,
2923: l_api_name

Line 2921: FND_MSG_PUB.Add_Exc_Msg

2917:
2918: IF FND_MSG_PUB.Check_Msg_Level
2919: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2920: THEN
2921: FND_MSG_PUB.Add_Exc_Msg
2922: ( G_PKG_NAME ,
2923: l_api_name
2924: );
2925: END IF;

Line 2927: FND_MSG_PUB.Count_And_Get

2923: l_api_name
2924: );
2925: END IF;
2926:
2927: FND_MSG_PUB.Count_And_Get
2928: ( p_count => x_msg_count ,
2929: p_data => x_msg_data
2930: );
2931:

Line 3098: FND_MSG_PUB.initialize;

3094: END IF;
3095:
3096: -- Initialize message list if p_init_msg_list is set to TRUE.
3097: IF FND_API.to_Boolean( l_init_msg_list ) THEN
3098: FND_MSG_PUB.initialize;
3099: END IF;
3100:
3101: -- Open Debug Session by a give param or profile option.
3102: Open_Debug_Session(p_debug, p_output_dir, p_debug_filename) ;

Line 3631: FND_MSG_PUB.Add;

3627:
3628: -- We don't support this in R12
3629: FND_MESSAGE.Set_Name('ENG','ENG_IMPL_INVALID_ACD_TYPE');
3630: FND_MESSAGE.Set_Token('ACD_TYPE', l_current_acd_type);
3631: FND_MSG_PUB.Add;
3632: RAISE FND_API.G_EXC_ERROR;
3633:
3634:
3635: END IF;

Line 4094: FND_MSG_PUB.Add;

4090:
4091: -- We don't support this in R12
4092: FND_MESSAGE.Set_Name('ENG','ENG_IMPL_INVALID_ACD_TYPE');
4093: FND_MESSAGE.Set_Token('ACD_TYPE', l_current_acd_type);
4094: FND_MSG_PUB.Add;
4095: RAISE FND_API.G_EXC_ERROR;
4096:
4097: END IF;
4098:

Line 4275: FND_MSG_PUB.Add_Exc_Msg

4271:
4272: EXCEPTION
4273: WHEN OTHERS THEN
4274:
4275: FND_MSG_PUB.Add_Exc_Msg
4276: ( p_pkg_name => 'EGO_GTIN_ATTRS_PVT' ,
4277: p_procedure_name => 'Process_UCCnet_Attrs_For_Item',
4278: p_error_text => Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240)
4279: );

Line 4283: FND_MSG_PUB.Add;

4279: );
4280:
4281: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
4282: FND_MESSAGE.Set_Token('OBJECT_NAME', 'EGO_GTIN_ATTRS_PVT.Process_UCCnet_Attrs_For_Item');
4283: FND_MSG_PUB.Add;
4284:
4285: Write_Debug('When Others Exception while calling EGO_GTIN_ATTRS_PVT.Process_UCCnet_Attrs_For_Item' || Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240));
4286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4287:

Line 4302: Write_Debug('Error msg - '||cnt ||': '|| FND_MSG_PUB.Get(p_msg_index => cnt, p_encoded => 'F'));

4298: Write_Debug('Output - Return Stattus: ' || l_return_status);
4299: Write_Debug('Output - Return Stattus: ' || to_char(l_msg_count));
4300: -- Write_Debug('Output - Return Stattus: ' || substr(l_msg_data,1,200));
4301: FOR cnt IN 1..l_msg_count LOOP
4302: Write_Debug('Error msg - '||cnt ||': '|| FND_MSG_PUB.Get(p_msg_index => cnt, p_encoded => 'F'));
4303: END LOOP;
4304:
4305:
4306:

Line 4312: FND_MSG_PUB.Add;

4308: x_msg_count := l_msg_count;
4309: x_msg_data := l_msg_data;
4310: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
4311: FND_MESSAGE.Set_Token('OBJECT_NAME', 'EGO_GTIN_ATTRS_PVT.Process_UCCnet_Attrs_For_Item');
4312: FND_MSG_PUB.Add;
4313:
4314: RAISE FND_API.G_EXC_ERROR ;
4315:
4316: END IF;

Line 4373: FND_MSG_PUB.Count_And_Get

4369: COMMIT WORK;
4370: END IF;
4371:
4372: -- Standard call to get message count and if count is 1, get message info.
4373: FND_MSG_PUB.Count_And_Get
4374: ( p_count => x_msg_count ,
4375: p_data => x_msg_data
4376: );
4377:

Line 4403: FND_MSG_PUB.Add;

4399: END IF;
4400:
4401: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
4402: FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_IMPL_ITEM_CHANGES_PKG.impl_rev_item_gdsn_attr_chgs for ChangeId: '||l_change_id || '- ChangeLineId: '||l_change_line_id);
4403: FND_MSG_PUB.Add;
4404:
4405:
4406: FND_MSG_PUB.Count_And_Get
4407: ( p_count => x_msg_count ,

Line 4406: FND_MSG_PUB.Count_And_Get

4402: FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_IMPL_ITEM_CHANGES_PKG.impl_rev_item_gdsn_attr_chgs for ChangeId: '||l_change_id || '- ChangeLineId: '||l_change_line_id);
4403: FND_MSG_PUB.Add;
4404:
4405:
4406: FND_MSG_PUB.Count_And_Get
4407: ( p_count => x_msg_count ,
4408: p_data => x_msg_data
4409: );
4410:

Line 4434: FND_MSG_PUB.Add;

4430:
4431:
4432: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
4433: FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_IMPL_ITEM_CHANGES_PKG.impl_rev_item_gdsn_attr_chgs for ChangeId: '||l_change_id || '- ChangeLineId: '||l_change_line_id);
4434: FND_MSG_PUB.Add;
4435:
4436: FND_MSG_PUB.Count_And_Get
4437: ( p_count => x_msg_count ,
4438: p_data => x_msg_data

Line 4436: FND_MSG_PUB.Count_And_Get

4432: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
4433: FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_IMPL_ITEM_CHANGES_PKG.impl_rev_item_gdsn_attr_chgs for ChangeId: '||l_change_id || '- ChangeLineId: '||l_change_line_id);
4434: FND_MSG_PUB.Add;
4435:
4436: FND_MSG_PUB.Count_And_Get
4437: ( p_count => x_msg_count ,
4438: p_data => x_msg_data
4439: );
4440:

Line 4467: FND_MSG_PUB.Add;

4463: Write_Debug('When Others Exception ' || Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240));
4464:
4465: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
4466: FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_IMPL_ITEM_CHANGES_PKG.impl_rev_item_gdsn_attr_chgs for ChangeId: '||l_change_id || '- ChangeLineId: '||l_change_line_id);
4467: FND_MSG_PUB.Add;
4468:
4469:
4470: IF FND_MSG_PUB.Check_Msg_Level
4471: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 4470: IF FND_MSG_PUB.Check_Msg_Level

4466: FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_IMPL_ITEM_CHANGES_PKG.impl_rev_item_gdsn_attr_chgs for ChangeId: '||l_change_id || '- ChangeLineId: '||l_change_line_id);
4467: FND_MSG_PUB.Add;
4468:
4469:
4470: IF FND_MSG_PUB.Check_Msg_Level
4471: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4472: THEN
4473: FND_MSG_PUB.Add_Exc_Msg
4474: ( G_PKG_NAME ,

Line 4471: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4467: FND_MSG_PUB.Add;
4468:
4469:
4470: IF FND_MSG_PUB.Check_Msg_Level
4471: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4472: THEN
4473: FND_MSG_PUB.Add_Exc_Msg
4474: ( G_PKG_NAME ,
4475: l_api_name

Line 4473: FND_MSG_PUB.Add_Exc_Msg

4469:
4470: IF FND_MSG_PUB.Check_Msg_Level
4471: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4472: THEN
4473: FND_MSG_PUB.Add_Exc_Msg
4474: ( G_PKG_NAME ,
4475: l_api_name
4476: );
4477: END IF;

Line 4479: FND_MSG_PUB.Count_And_Get

4475: l_api_name
4476: );
4477: END IF;
4478:
4479: FND_MSG_PUB.Count_And_Get
4480: ( p_count => x_msg_count ,
4481: p_data => x_msg_data
4482: );
4483:

Line 4581: -- Initialize FND_MSG_PUB and ERROR_HANDLER if necessary

4577: -- Standard start of API savepoint
4578: SAVEPOINT Implement_Change_Line_PUB;
4579: END IF;
4580:
4581: -- Initialize FND_MSG_PUB and ERROR_HANDLER if necessary
4582: IF (FND_API.To_Boolean(p_init_msg_list)) THEN
4583: FND_MSG_PUB.Initialize;
4584: ERROR_HANDLER.Initialize;
4585: END IF;

Line 4583: FND_MSG_PUB.Initialize;

4579: END IF;
4580:
4581: -- Initialize FND_MSG_PUB and ERROR_HANDLER if necessary
4582: IF (FND_API.To_Boolean(p_init_msg_list)) THEN
4583: FND_MSG_PUB.Initialize;
4584: ERROR_HANDLER.Initialize;
4585: END IF;
4586:
4587: -- Check for call compatibility

Line 5878: FND_MSG_PUB.initialize;

5874: END IF;
5875:
5876: -- Initialize message list if p_init_msg_list is set to TRUE.
5877: IF FND_API.to_Boolean( l_init_msg_list ) THEN
5878: FND_MSG_PUB.initialize;
5879: END IF;
5880:
5881: -- Open Debug Session by a give param or profile option.
5882: Open_Debug_Session(p_debug, p_output_dir, p_debug_filename) ;

Line 6003: FND_MSG_PUB.Add_Exc_Msg

5999:
6000: EXCEPTION
6001: WHEN OTHERS THEN
6002:
6003: FND_MSG_PUB.Add_Exc_Msg
6004: ( p_pkg_name => 'EGO_USER_ATTRS_DATA_PVT' ,
6005: p_procedure_name => 'Implement_Change_Line',
6006: p_error_text => Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240)
6007: );

Line 6012: FND_MSG_PUB.Add;

6008:
6009:
6010: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
6011: FND_MESSAGE.Set_Token('OBJECT_NAME', 'EGO_USER_ATTRS_DATA_PVT.Implement_Change_Line');
6012: FND_MSG_PUB.Add;
6013:
6014: Write_Debug('When Others Exception while calling EGO_USER_ATTRS_DATA_PVT.Implement_Change_Line:' || Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240));
6015: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6016: END ;

Line 6032: FND_MSG_PUB.Add;

6028: x_msg_count := l_msg_count;
6029: x_msg_data := l_msg_data;
6030: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
6031: FND_MESSAGE.Set_Token('OBJECT_NAME', 'EGO_USER_ATTRS_DATA_PVT.Implement_Change_Line');
6032: FND_MSG_PUB.Add;
6033:
6034: RAISE FND_API.G_EXC_ERROR ;
6035: END IF;
6036:

Line 6047: FND_MSG_PUB.Count_And_Get

6043: COMMIT WORK;
6044: END IF;
6045:
6046: -- Standard call to get message count and if count is 1, get message info.
6047: FND_MSG_PUB.Count_And_Get
6048: ( p_count => x_msg_count ,
6049: p_data => x_msg_data
6050: );
6051:

Line 6076: FND_MSG_PUB.Add;

6072: END IF;
6073:
6074: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
6075: FND_MESSAGE.Set_Token('OBJECT_NAME', 'impl_rev_item_attr_changes'|| 'error code '||l_errorcode);
6076: FND_MSG_PUB.Add;
6077:
6078:
6079: FND_MSG_PUB.Count_And_Get
6080: ( p_count => x_msg_count ,

Line 6079: FND_MSG_PUB.Count_And_Get

6075: FND_MESSAGE.Set_Token('OBJECT_NAME', 'impl_rev_item_attr_changes'|| 'error code '||l_errorcode);
6076: FND_MSG_PUB.Add;
6077:
6078:
6079: FND_MSG_PUB.Count_And_Get
6080: ( p_count => x_msg_count ,
6081: p_data => x_msg_data
6082: );
6083:

Line 6107: FND_MSG_PUB.Add;

6103:
6104:
6105: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
6106: FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_IMPL_ITEM_CHANGES_PKG.impl_rev_item_attr_changes for ChangeId: '||l_change_id || '- ChangeLineId: '||l_change_line_id);
6107: FND_MSG_PUB.Add;
6108:
6109:
6110: FND_MSG_PUB.Count_And_Get
6111: ( p_count => x_msg_count ,

Line 6110: FND_MSG_PUB.Count_And_Get

6106: FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_IMPL_ITEM_CHANGES_PKG.impl_rev_item_attr_changes for ChangeId: '||l_change_id || '- ChangeLineId: '||l_change_line_id);
6107: FND_MSG_PUB.Add;
6108:
6109:
6110: FND_MSG_PUB.Count_And_Get
6111: ( p_count => x_msg_count ,
6112: p_data => x_msg_data
6113: );
6114:

Line 6141: FND_MSG_PUB.Add;

6137: Write_Debug('When Others Exception ' || Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240));
6138:
6139: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
6140: FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_IMPL_ITEM_CHANGES_PKG.impl_rev_item_attr_changes for ChangeId: '||l_change_id || '- ChangeLineId: '||l_change_line_id);
6141: FND_MSG_PUB.Add;
6142:
6143:
6144: IF FND_MSG_PUB.Check_Msg_Level
6145: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 6144: IF FND_MSG_PUB.Check_Msg_Level

6140: FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_IMPL_ITEM_CHANGES_PKG.impl_rev_item_attr_changes for ChangeId: '||l_change_id || '- ChangeLineId: '||l_change_line_id);
6141: FND_MSG_PUB.Add;
6142:
6143:
6144: IF FND_MSG_PUB.Check_Msg_Level
6145: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6146: THEN
6147: FND_MSG_PUB.Add_Exc_Msg
6148: ( G_PKG_NAME ,

Line 6145: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

6141: FND_MSG_PUB.Add;
6142:
6143:
6144: IF FND_MSG_PUB.Check_Msg_Level
6145: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6146: THEN
6147: FND_MSG_PUB.Add_Exc_Msg
6148: ( G_PKG_NAME ,
6149: l_api_name

Line 6147: FND_MSG_PUB.Add_Exc_Msg

6143:
6144: IF FND_MSG_PUB.Check_Msg_Level
6145: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6146: THEN
6147: FND_MSG_PUB.Add_Exc_Msg
6148: ( G_PKG_NAME ,
6149: l_api_name
6150: );
6151: END IF;

Line 6153: FND_MSG_PUB.Count_And_Get

6149: l_api_name
6150: );
6151: END IF;
6152:
6153: FND_MSG_PUB.Count_And_Get
6154: ( p_count => x_msg_count ,
6155: p_data => x_msg_data
6156: );
6157: