APPS.INV_COPY_ORGANIZATION_REPORT dependencies on FND_MSG_PUB

Line 189: FND_MSG_PUB.ADD_EXC_MSG

185: G_DEBUG := 'Y';
186: END IF;
187:
188: IF G_DEBUG = 'Y' THEN
189: FND_MSG_PUB.ADD_EXC_MSG
190: ( G_PKG_NAME
191: , l_api_name
192: , '> Generate_Report_Data => '||
193: 'Input Paramters' ||

Line 237: FND_MSG_PUB.initialize;

233: -- Initialize message list if p_init_msg_list is set to TRUE.
234: -----------------------------------------------------------------------------
235: IF FND_API.to_Boolean( p_init_msg_list )
236: THEN
237: FND_MSG_PUB.initialize;
238: END IF;
239:
240: ---------------------------------------------------------------------------
241: -- The initialize procedure has been obsoleted as it is not required

Line 248: -- FND_MSG_PUB.ADD_EXC_MSG

244: -- Since modified attributes are not longer supported, this procedure
245: -- need not be called.
246: ---------------------------------------------------------------------------
247: --IF G_DEBUG = 'Y' THEN
248: -- FND_MSG_PUB.ADD_EXC_MSG
249: -- ( G_PKG_NAME
250: -- , l_api_name
251: -- , '> initialize() for populating entity/attribute lists'
252: -- );

Line 264: FND_MSG_PUB.ADD_EXC_MSG

260: --initialize;
261: -----------------------------------------------------------------------------
262:
263: IF G_DEBUG = 'Y' THEN
264: FND_MSG_PUB.ADD_EXC_MSG
265: ( G_PKG_NAME
266: , l_api_name
267: , '> Validating location - writing messages to Report tab'
268: );

Line 280: FND_MSG_PUB.ADD_EXC_MSG

276: ---------------------------------------------------------------------------
277: Validate_Locs;
278:
279: IF G_DEBUG = 'Y' THEN
280: FND_MSG_PUB.ADD_EXC_MSG
281: ( G_PKG_NAME
282: , l_api_name
283: , '> Validating organization, writing messages to Report tab'
284: );

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

306: EXCEPTION
307: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
308: ROLLBACK TO Generate_Report_Data_PVT;
309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
310: FND_MSG_PUB.Count_And_Get( p_count=>x_msg_count, p_data=>x_msg_data);
311:
312: WHEN OTHERS THEN
313: ROLLBACK TO Generate_Report_Data_PVT;
314: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

311:
312: WHEN OTHERS THEN
313: ROLLBACK TO Generate_Report_Data_PVT;
314: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
315: FND_MSG_PUB.Count_And_Get( p_count=>x_msg_count, p_data=>x_msg_data);
316:
317: END Generate_Report_Data;
318:
319: --=============================================================================

Line 347: -- FND_MSG_PUB.ADD_EXC_MSG

343: --
344: --BEGIN
345: --
346: -- IF G_DEBUG = 'Y' THEN
347: -- FND_MSG_PUB.ADD_EXC_MSG
348: -- ( G_PKG_NAME
349: -- , l_api_name
350: -- , '> initialize'
351: -- );

Line 379: -- FND_MSG_PUB.ADD_EXC_MSG

375: -- END LOOP;
376: -- CLOSE l_user_values;
377: --
378: -- IF G_DEBUG = 'Y' THEN
379: -- FND_MSG_PUB.ADD_EXC_MSG
380: -- ( G_PKG_NAME
381: -- , l_api_name
382: -- , '< initialize'
383: --

Line 392: -- FND_MSG_PUB.Add;

388: -- FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
389: -- FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
390: -- FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
391: -- FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
392: -- FND_MSG_PUB.Add;
393: -- RAISE;
394: --
395: --END initialize;
396: --

Line 420: FND_MSG_PUB.ADD_EXC_MSG

416:
417: BEGIN
418:
419: IF G_DEBUG = 'Y' THEN
420: FND_MSG_PUB.ADD_EXC_MSG
421: ( G_PKG_NAME
422: , l_api_name
423: , '> Validate_Orgs '
424: );

Line 450: FND_MSG_PUB.ADD_EXC_MSG

446: , p_put_orgs => true
447: );
448:
449: IF G_DEBUG = 'Y' THEN
450: FND_MSG_PUB.ADD_EXC_MSG
451: ( G_PKG_NAME
452: , l_api_name
453: , '< Validate_Orgs '
454: );

Line 463: FND_MSG_PUB.Add;

459: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
460: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
461: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
462: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
463: FND_MSG_PUB.Add;
464: RAISE;
465:
466: END Validate_Orgs;
467:

Line 496: FND_MSG_PUB.ADD_EXC_MSG

492: --shpandey, added for R12 bug#4111958
493: l_model_loc_exists BOOLEAN := TRUE;
494: BEGIN
495: IF G_DEBUG = 'Y' THEN
496: FND_MSG_PUB.ADD_EXC_MSG
497: ( G_PKG_NAME
498: , l_api_name
499: , '> Validate_Locs'
500: );

Line 506: FND_MSG_PUB.ADD_EXC_MSG

502:
503: l_status := g_location_status;
504:
505: IF G_DEBUG = 'Y' THEN
506: FND_MSG_PUB.ADD_EXC_MSG
507: ( G_PKG_NAME
508: , l_api_name
509: , '- Retrieving Location Code, Business Group Name'
510: );

Line 557: FND_MSG_PUB.ADD_EXC_MSG

553: END IF;
554: -- END OF IF bug 4111958
555:
556: IF G_DEBUG = 'Y' THEN
557: FND_MSG_PUB.ADD_EXC_MSG
558: ( G_PKG_NAME
559: , l_api_name
560: , '- Retrieving Location creation date, copy org req. timestamp.'
561: );

Line 609: FND_MSG_PUB.ADD_EXC_MSG

605: , p_put_orgs => false
606: );
607:
608: IF G_DEBUG = 'Y' THEN
609: FND_MSG_PUB.ADD_EXC_MSG
610: ( G_PKG_NAME
611: , l_api_name
612: , '< Validate_Locs'
613: );

Line 622: FND_MSG_PUB.Add;

618: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
619: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
620: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
621: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
622: FND_MSG_PUB.Add;
623: RAISE;
624:
625: WHEN OTHERS THEN
626: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');

Line 630: FND_MSG_PUB.Add;

626: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
627: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
628: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
629: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
630: FND_MSG_PUB.Add;
631: RAISE;
632:
633: END Validate_Locs;
634:

Line 705: FND_MSG_PUB.Add;

701: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
702: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
703: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
704: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
705: FND_MSG_PUB.Add;
706: RAISE;
707:
708: END Init_Vars;
709:

Line 756: FND_MSG_PUB.ADD_EXC_MSG

752:
753: BEGIN
754:
755: IF G_DEBUG = 'Y' THEN
756: FND_MSG_PUB.ADD_EXC_MSG
757: ( G_PKG_NAME
758: , l_api_name
759: , '> Validate_Entities'
760: );

Line 1025: FND_MSG_PUB.ADD_EXC_MSG

1021: Put_Report_Data;
1022: END IF;
1023:
1024: IF G_DEBUG = 'Y' THEN
1025: FND_MSG_PUB.ADD_EXC_MSG
1026: ( G_PKG_NAME
1027: , l_api_name
1028: , '< Validate_Entities'
1029: );

Line 1044: FND_MSG_PUB.Add;

1040: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
1041: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
1042: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
1043: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
1044: FND_MSG_PUB.Add;
1045: RAISE;
1046:
1047: END Validate_Entities;
1048:

Line 1094: FND_MSG_PUB.ADD_EXC_MSG

1090: WHERE pos.ORGANIZATION_ID_CHILD = p_org_id;
1091:
1092: BEGIN
1093: IF G_DEBUG = 'Y' THEN
1094: FND_MSG_PUB.ADD_EXC_MSG
1095: ( G_PKG_NAME
1096: , l_api_name
1097: , '> Get_Err_Hierarchy'
1098: );

Line 1134: FND_MSG_PUB.Add;

1130: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
1131: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
1132: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
1133: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
1134: FND_MSG_PUB.Add;
1135: RAISE;
1136:
1137: END Get_Err_Hierarchy;
1138: --=============================================================================

Line 1178: FND_MSG_PUB.ADD_EXC_MSG

1174: WHERE msi.ORGANIZATION_ID = p_org_id;
1175:
1176: BEGIN
1177: IF G_DEBUG = 'Y' THEN
1178: FND_MSG_PUB.ADD_EXC_MSG
1179: ( G_PKG_NAME
1180: , l_api_name
1181: , '> Get_Err_Subinv_Names'
1182: );

Line 1218: FND_MSG_PUB.Add;

1214: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
1215: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
1216: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
1217: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
1218: FND_MSG_PUB.Add;
1219: RAISE;
1220:
1221: END Get_Err_Subinv_Names;
1222:

Line 1268: FND_MSG_PUB.ADD_EXC_MSG

1264: and resources in the report */
1265:
1266: BEGIN
1267: IF G_DEBUG = 'Y' THEN
1268: FND_MSG_PUB.ADD_EXC_MSG
1269: ( G_PKG_NAME
1270: , l_api_name
1271: , '> Get_Err_Bom_Resources'
1272: );

Line 1306: FND_MSG_PUB.Add;

1302: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
1303: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
1304: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
1305: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
1306: FND_MSG_PUB.Add;
1307: RAISE;
1308:
1309: END Get_Err_Bom_Resources;
1310: --=============================================================================

Line 1351: FND_MSG_PUB.ADD_EXC_MSG

1347:
1348: BEGIN
1349:
1350: IF G_DEBUG = 'Y' THEN
1351: FND_MSG_PUB.ADD_EXC_MSG
1352: ( G_PKG_NAME
1353: , l_api_name
1354: , '> Get_Err_Bom_Departments'
1355: );

Line 1390: FND_MSG_PUB.Add;

1386: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
1387: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
1388: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
1389: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
1390: FND_MSG_PUB.Add;
1391: RAISE;
1392:
1393: END Get_Err_Bom_Departments;
1394:

Line 1437: FND_MSG_PUB.ADD_EXC_MSG

1433:
1434: BEGIN
1435:
1436: IF G_DEBUG = 'Y' THEN
1437: FND_MSG_PUB.ADD_EXC_MSG
1438: ( G_PKG_NAME
1439: , l_api_name
1440: , 'IN INVCORPB: '||l_api_name
1441: );

Line 1476: FND_MSG_PUB.Add;

1472: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
1473: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
1474: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
1475: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
1476: FND_MSG_PUB.Add;
1477: RAISE;
1478:
1479: END Get_Err_Bom_Dept_Classes;
1480:

Line 1523: FND_MSG_PUB.ADD_EXC_MSG

1519:
1520: BEGIN
1521:
1522: IF G_DEBUG = 'Y' THEN
1523: FND_MSG_PUB.ADD_EXC_MSG
1524: ( G_PKG_NAME
1525: , l_api_name
1526: , 'IN INVCORPB: '||l_api_name
1527: );

Line 1563: FND_MSG_PUB.Add;

1559: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
1560: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
1561: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
1562: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
1563: FND_MSG_PUB.Add;
1564: RAISE;
1565:
1566: END Get_Err_Bom_Alt_Desig;
1567: --=============================================================================

Line 1637: FND_MSG_PUB.ADD_EXC_MSG

1633:
1634: BEGIN
1635:
1636: IF G_DEBUG = 'Y' THEN
1637: FND_MSG_PUB.ADD_EXC_MSG
1638: ( G_PKG_NAME
1639: , l_api_name
1640: , 'IN INVCORPB: '||l_api_name
1641: );

Line 1699: FND_MSG_PUB.Add;

1695: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
1696: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
1697: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
1698: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
1699: FND_MSG_PUB.Add;
1700: RAISE;
1701:
1702: END Get_Err_Ship_Net;
1703: --=============================================================================

Line 1919: FND_MSG_PUB.ADD_EXC_MSG

1915:
1916: BEGIN
1917:
1918: IF G_DEBUG = 'Y' THEN
1919: FND_MSG_PUB.ADD_EXC_MSG
1920: ( G_PKG_NAME
1921: , l_api_name
1922: , 'IN INVCORPB: '||l_api_name
1923: );

Line 2085: FND_MSG_PUB.Add;

2081: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
2082: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
2083: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
2084: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
2085: FND_MSG_PUB.Add;
2086: RAISE;
2087:
2088: END Get_Err_Bom_Bom;
2089:

Line 2164: FND_MSG_PUB.ADD_EXC_MSG

2160:
2161: BEGIN
2162:
2163: IF G_DEBUG = 'Y' THEN
2164: FND_MSG_PUB.ADD_EXC_MSG
2165: ( G_PKG_NAME
2166: , l_api_name
2167: , 'IN INVCORPB: '||l_api_name
2168: );

Line 2214: FND_MSG_PUB.Add;

2210: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
2211: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
2212: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
2213: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
2214: FND_MSG_PUB.Add;
2215: RAISE;
2216:
2217: END Get_Err_Org_Information;
2218:

Line 2265: FND_MSG_PUB.ADD_EXC_MSG

2261:
2262: BEGIN
2263:
2264: IF G_DEBUG = 'Y' THEN
2265: FND_MSG_PUB.ADD_EXC_MSG
2266: ( G_PKG_NAME
2267: , l_api_name
2268: , 'IN INVCORPB: '||l_api_name
2269: );

Line 2307: FND_MSG_PUB.Add;

2303: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
2304: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
2305: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
2306: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
2307: FND_MSG_PUB.Add;
2308: RAISE;
2309:
2310: END Get_Err_Mtl_Items;
2311:

Line 2358: FND_MSG_PUB.ADD_EXC_MSG

2354:
2355: BEGIN
2356:
2357: IF G_DEBUG = 'Y' THEN
2358: FND_MSG_PUB.ADD_EXC_MSG
2359: ( G_PKG_NAME
2360: , l_api_name
2361: , 'IN INVCORPB: '||l_api_name
2362: );

Line 2400: FND_MSG_PUB.Add;

2396: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
2397: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
2398: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
2399: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
2400: FND_MSG_PUB.Add;
2401: RAISE;
2402:
2403: END Get_Err_Mtl_Item_Cat;
2404:

Line 2453: FND_MSG_PUB.ADD_EXC_MSG

2449:
2450: BEGIN
2451:
2452: IF G_DEBUG = 'Y' THEN
2453: FND_MSG_PUB.ADD_EXC_MSG
2454: ( G_PKG_NAME
2455: , l_api_name
2456: , 'IN INVCORPB: '||l_api_name
2457: );

Line 2496: FND_MSG_PUB.Add;

2492: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
2493: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
2494: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
2495: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
2496: FND_MSG_PUB.Add;
2497: RAISE;
2498:
2499: END Get_Err_Mtl_Item_Rev;
2500:

Line 2547: FND_MSG_PUB.ADD_EXC_MSG

2543:
2544: BEGIN
2545:
2546: IF G_DEBUG = 'Y' THEN
2547: FND_MSG_PUB.ADD_EXC_MSG
2548: ( G_PKG_NAME
2549: , l_api_name
2550: , 'IN INVCORPB: '||l_api_name
2551: );

Line 2589: FND_MSG_PUB.Add;

2585: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
2586: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
2587: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
2588: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
2589: FND_MSG_PUB.Add;
2590: RAISE;
2591:
2592: END Get_Err_Mtl_Items_Subinv;
2593: --=============================================================================

Line 2641: FND_MSG_PUB.ADD_EXC_MSG

2637:
2638: BEGIN
2639:
2640: IF G_DEBUG = 'Y' THEN
2641: FND_MSG_PUB.ADD_EXC_MSG
2642: ( G_PKG_NAME
2643: , l_api_name
2644: , 'IN INVCORPB: '||l_api_name
2645: );

Line 2683: FND_MSG_PUB.Add;

2679: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
2680: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
2681: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
2682: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
2683: FND_MSG_PUB.Add;
2684: RAISE;
2685:
2686: END Get_Err_Mtl_Item_Locations;
2687: --=============================================================================

Line 2861: FND_MSG_PUB.ADD_EXC_MSG

2857: -------------------------------------------------------------------
2858: BEGIN
2859:
2860: IF G_DEBUG = 'Y' THEN
2861: FND_MSG_PUB.ADD_EXC_MSG
2862: ( G_PKG_NAME
2863: , l_api_name
2864: , 'IN INVCORPB: '||l_api_name
2865: );

Line 2978: FND_MSG_PUB.Add;

2974: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
2975: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
2976: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
2977: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
2978: FND_MSG_PUB.Add;
2979: RAISE;
2980:
2981: END Get_Err_StdOperations;
2982:

Line 3312: FND_MSG_PUB.ADD_EXC_MSG

3308:
3309: BEGIN
3310:
3311: IF G_DEBUG = 'Y' THEN
3312: FND_MSG_PUB.ADD_EXC_MSG
3313: ( G_PKG_NAME
3314: , l_api_name
3315: , 'IN INVCORPB: '||l_api_name
3316: );

Line 3505: FND_MSG_PUB.Add;

3501: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
3502: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
3503: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
3504: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
3505: FND_MSG_PUB.Add;
3506: RAISE;
3507:
3508: END Get_Err_Routings;
3509:

Line 3585: FND_MSG_PUB.ADD_EXC_MSG

3581:
3582: BEGIN
3583:
3584: IF G_DEBUG = 'Y' THEN
3585: FND_MSG_PUB.ADD_EXC_MSG
3586: ( G_PKG_NAME
3587: , l_api_name
3588: , 'IN INVCORPB: '||l_api_name
3589: );

Line 3627: FND_MSG_PUB.Add;

3623: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
3624: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
3625: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
3626: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
3627: FND_MSG_PUB.Add;
3628: RAISE;
3629:
3630: END Get_Err_Bom_Dept_Res;
3631:

Line 3682: FND_MSG_PUB.ADD_EXC_MSG

3678:
3679: BEGIN
3680:
3681: IF G_DEBUG = 'Y' THEN
3682: FND_MSG_PUB.ADD_EXC_MSG
3683: ( G_PKG_NAME
3684: , l_api_name
3685: , 'IN INVCORPB: '||l_api_name
3686: );

Line 3724: FND_MSG_PUB.Add;

3720: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
3721: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
3722: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
3723: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
3724: FND_MSG_PUB.Add;
3725: RAISE;
3726:
3727: END Get_Err_Cst_Res_Costs;
3728: --=============================================================================

Line 3784: FND_MSG_PUB.ADD_EXC_MSG

3780:
3781: BEGIN
3782:
3783: IF G_DEBUG = 'Y' THEN
3784: FND_MSG_PUB.ADD_EXC_MSG
3785: ( G_PKG_NAME
3786: , l_api_name
3787: , '> Get_Err_Cst_Res_Ovhds'
3788: );

Line 3821: FND_MSG_PUB.ADD_EXC_MSG

3817: l_entity_names.EXTEND;
3818: l_entity_names(l_entity_arr_idx):=l_model_org_count;
3819:
3820: IF G_DEBUG = 'Y' THEN
3821: FND_MSG_PUB.ADD_EXC_MSG
3822: ( G_PKG_NAME
3823: , l_api_name
3824: , '< Get_Err_Cst_Res_Ovhds'
3825: );

Line 3836: FND_MSG_PUB.Add;

3832: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
3833: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
3834: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
3835: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
3836: FND_MSG_PUB.Add;
3837: RAISE;
3838:
3839: END Get_Err_Cst_Res_Ovhds;
3840:

Line 3924: FND_MSG_PUB.ADD_EXC_MSG

3920: -- ||'/'
3921: -- ||g_modify_cnt
3922: --------------------------------------------------------------------
3923: -- );
3924: FND_MSG_PUB.ADD_EXC_MSG
3925: ( G_PKG_NAME
3926: , l_api_name
3927: , '- Copied Records(Exp/Actual) :'||g_exp_copy_cnt
3928: ||'/'

Line 4038: FND_MSG_PUB.ADD_EXC_MSG

4034: END IF;
4035: END IF;
4036:
4037: IF G_DEBUG = 'Y' THEN
4038: FND_MSG_PUB.ADD_EXC_MSG
4039: ( G_PKG_NAME
4040: , l_api_name
4041: , '< Put_Report_Data'
4042: );

Line 4051: FND_MSG_PUB.Add;

4047: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
4048: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
4049: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
4050: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
4051: FND_MSG_PUB.Add;
4052: RAISE;
4053:
4054: END Put_Report_Data;
4055:

Line 4090: FND_MSG_PUB.ADD_EXC_MSG

4086: l_api_name VARCHAR2(100):=' Insert_Row ';
4087: BEGIN
4088:
4089: IF G_DEBUG = 'Y' THEN
4090: FND_MSG_PUB.ADD_EXC_MSG
4091: ( G_PKG_NAME
4092: , l_api_name
4093: , '> Insert_Row '
4094: );

Line 4138: FND_MSG_PUB.ADD_EXC_MSG

4134: , p_entity_inconsistency
4135: );
4136:
4137: IF G_DEBUG = 'Y' THEN
4138: FND_MSG_PUB.ADD_EXC_MSG
4139: ( G_PKG_NAME
4140: , l_api_name
4141: , '< Insert_Row '
4142: );

Line 4151: FND_MSG_PUB.Add;

4147: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
4148: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
4149: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
4150: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
4151: FND_MSG_PUB.Add;
4152: RAISE;
4153:
4154: END Insert_Row;
4155: --=============================================================================

Line 4181: -- FND_MSG_PUB.ADD_EXC_MSG

4177: -- END IF;
4178: -- END LOOP;
4179: --
4180: -- IF G_DEBUG = 'Y' THEN
4181: -- FND_MSG_PUB.ADD_EXC_MSG
4182: -- ( G_PKG_NAME
4183: -- , l_api_name
4184: -- , '< Is_Entity_Modified '
4185: -- );

Line 4215: FND_MSG_PUB.Add;

4211: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
4212: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
4213: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
4214: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
4215: FND_MSG_PUB.Add;
4216: RAISE;
4217:
4218: END Get_Organization_Id;
4219: --=============================================================================

Line 4243: FND_MSG_PUB.ADD_EXC_MSG

4239: l_api_name VARCHAR2(100):=' Get_Fnd_Message ';
4240: BEGIN
4241:
4242: IF G_DEBUG = 'Y' THEN
4243: FND_MSG_PUB.ADD_EXC_MSG
4244: ( G_PKG_NAME
4245: , l_api_name
4246: , '> Get_Fnd_Message '
4247: );

Line 4264: FND_MSG_PUB.ADD_EXC_MSG

4260: INTO l_message
4261: FROM dual;
4262:
4263: IF G_DEBUG = 'Y' THEN
4264: FND_MSG_PUB.ADD_EXC_MSG
4265: ( G_PKG_NAME
4266: , l_api_name
4267: , '< Get_Fnd_Message '
4268: );

Line 4292: FND_MSG_PUB.ADD_EXC_MSG

4288: l_api_name VARCHAR2(100):=' Purge_Copy_Org_Report ';
4289:
4290: BEGIN
4291: IF G_DEBUG = 'Y' THEN
4292: FND_MSG_PUB.ADD_EXC_MSG
4293: ( G_PKG_NAME
4294: , l_api_name
4295: , '> Purge Report Data'
4296: );

Line 4307: FND_MSG_PUB.ADD_EXC_MSG

4303: DELETE mtl_copy_org_report
4304: WHERE group_code = g_group_code;
4305:
4306: IF G_DEBUG = 'Y' THEN
4307: FND_MSG_PUB.ADD_EXC_MSG
4308: ( G_PKG_NAME
4309: , l_api_name
4310: , '< Purge Report Data'
4311: );

Line 4322: FND_MSG_PUB.Add;

4318: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
4319: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
4320: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
4321: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
4322: FND_MSG_PUB.Add;
4323: RAISE;
4324:
4325: END Purge_Copy_Org_Report;
4326:

Line 4347: FND_MSG_PUB.ADD_EXC_MSG

4343:
4344: BEGIN
4345:
4346: IF G_DEBUG = 'Y' THEN
4347: FND_MSG_PUB.ADD_EXC_MSG
4348: ( G_PKG_NAME
4349: , l_api_name
4350: , '> Receiving_Subinv_Exist '
4351: );

Line 4362: FND_MSG_PUB.ADD_EXC_MSG

4358: AND SUBINVENTORY_TYPE = 2
4359: AND ROWNUM = 1;
4360:
4361: IF G_DEBUG = 'Y' THEN
4362: FND_MSG_PUB.ADD_EXC_MSG
4363: ( G_PKG_NAME
4364: , l_api_name
4365: , '< Receiving_Subinv_Exist '
4366: );

Line 4384: FND_MSG_PUB.Add;

4380: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
4381: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
4382: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
4383: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
4384: FND_MSG_PUB.Add;
4385: RAISE;
4386:
4387: END Receiving_Subinv_Exist;
4388: --=============================================================================

Line 4467: FND_MSG_PUB.ADD_EXC_MSG

4463:
4464: BEGIN
4465:
4466: IF G_DEBUG = 'Y' THEN
4467: FND_MSG_PUB.ADD_EXC_MSG
4468: ( G_PKG_NAME
4469: , l_api_name
4470: , 'IN INVCORPB: '||l_api_name
4471: );

Line 4509: FND_MSG_PUB.Add;

4505: FND_MESSAGE.SET_NAME(application=>'FND',name=>'FND_AS_UNEXPECTED_ERROR');
4506: FND_MESSAGE.SET_TOKEN('error_text', SQLERRM(sqlcode));
4507: FND_MESSAGE.SET_TOKEN('pkg_name' , G_PKG_NAME);
4508: FND_MESSAGE.SET_TOKEN('procedure_name' , l_api_name );
4509: FND_MSG_PUB.Add;
4510: RAISE;
4511:
4512: END Get_Err_Wip_Acc_Classes;
4513: