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

APPS.CTO_UPDATE_CONFIGS_PK dependencies on FND_API

Line 293: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

289: l_return_status,
290: l_msg_count,
291: l_msg_data);
292:
293: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
294: WriteToLog('ERROR: Populate_all_models returned unexpected error');
295: raise FND_API.G_EXC_UNEXPECTED_ERROR;
296: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
297: WriteToLog('ERROR: Populate_all_models returned expected error');

Line 295: raise FND_API.G_EXC_UNEXPECTED_ERROR;

291: l_msg_data);
292:
293: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
294: WriteToLog('ERROR: Populate_all_models returned unexpected error');
295: raise FND_API.G_EXC_UNEXPECTED_ERROR;
296: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
297: WriteToLog('ERROR: Populate_all_models returned expected error');
298: raise FND_API.G_EXC_ERROR;
299: ELSE

Line 296: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

292:
293: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
294: WriteToLog('ERROR: Populate_all_models returned unexpected error');
295: raise FND_API.G_EXC_UNEXPECTED_ERROR;
296: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
297: WriteToLog('ERROR: Populate_all_models returned expected error');
298: raise FND_API.G_EXC_ERROR;
299: ELSE
300: WriteToLog('Populate_all_models returned success', 3);

Line 298: raise FND_API.G_EXC_ERROR;

294: WriteToLog('ERROR: Populate_all_models returned unexpected error');
295: raise FND_API.G_EXC_UNEXPECTED_ERROR;
296: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
297: WriteToLog('ERROR: Populate_all_models returned expected error');
298: raise FND_API.G_EXC_ERROR;
299: ELSE
300: WriteToLog('Populate_all_models returned success', 3);
301: END IF;
302:

Line 364: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

360: l_return_status,
361: l_msg_count,
362: l_msg_data);
363:
364: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
365: WriteToLog('ERROR: Populate_cat_models returned unexpected error');
366: raise FND_API.G_EXC_UNEXPECTED_ERROR;
367: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
368: WriteToLog('ERROR: Populate_cat_models returned expected error');

Line 366: raise FND_API.G_EXC_UNEXPECTED_ERROR;

362: l_msg_data);
363:
364: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
365: WriteToLog('ERROR: Populate_cat_models returned unexpected error');
366: raise FND_API.G_EXC_UNEXPECTED_ERROR;
367: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
368: WriteToLog('ERROR: Populate_cat_models returned expected error');
369: raise FND_API.G_EXC_ERROR;
370: ELSE

Line 367: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

363:
364: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
365: WriteToLog('ERROR: Populate_cat_models returned unexpected error');
366: raise FND_API.G_EXC_UNEXPECTED_ERROR;
367: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
368: WriteToLog('ERROR: Populate_cat_models returned expected error');
369: raise FND_API.G_EXC_ERROR;
370: ELSE
371: WriteToLog('Populate_cat_models returned success', 3);

Line 369: raise FND_API.G_EXC_ERROR;

365: WriteToLog('ERROR: Populate_cat_models returned unexpected error');
366: raise FND_API.G_EXC_UNEXPECTED_ERROR;
367: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
368: WriteToLog('ERROR: Populate_cat_models returned expected error');
369: raise FND_API.G_EXC_ERROR;
370: ELSE
371: WriteToLog('Populate_cat_models returned success', 3);
372: END IF;
373:

Line 443: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

439: l_return_status,
440: l_msg_count,
441: l_msg_data);
442:
443: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
444: WriteToLog('ERROR: Populate_configs returned unexpected error');
445: raise FND_API.G_EXC_UNEXPECTED_ERROR;
446: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
447: WriteToLog('ERROR: Populate_configs returned expected error');

Line 445: raise FND_API.G_EXC_UNEXPECTED_ERROR;

441: l_msg_data);
442:
443: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
444: WriteToLog('ERROR: Populate_configs returned unexpected error');
445: raise FND_API.G_EXC_UNEXPECTED_ERROR;
446: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
447: WriteToLog('ERROR: Populate_configs returned expected error');
448: raise FND_API.G_EXC_ERROR;
449: ELSE

Line 446: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

442:
443: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
444: WriteToLog('ERROR: Populate_configs returned unexpected error');
445: raise FND_API.G_EXC_UNEXPECTED_ERROR;
446: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
447: WriteToLog('ERROR: Populate_configs returned expected error');
448: raise FND_API.G_EXC_ERROR;
449: ELSE
450: WriteToLog('Populate_configs returned success', 3);

Line 448: raise FND_API.G_EXC_ERROR;

444: WriteToLog('ERROR: Populate_configs returned unexpected error');
445: raise FND_API.G_EXC_UNEXPECTED_ERROR;
446: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
447: WriteToLog('ERROR: Populate_configs returned expected error');
448: raise FND_API.G_EXC_ERROR;
449: ELSE
450: WriteToLog('Populate_configs returned success', 3);
451: END IF;
452:

Line 579: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

575: --perfoming above validation by calling following API
576: l_stmt_num := 50;
577: Check_invalid_configurations(l_return_status);
578:
579: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
580: WriteToLog('Check_invalid_configurations returned unexpected error', 1);
581: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
582: ELSE
583: WriteToLog('Check_invalid_configurations returned success', 3);

Line 581: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

577: Check_invalid_configurations(l_return_status);
578:
579: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
580: WriteToLog('Check_invalid_configurations returned unexpected error', 1);
581: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
582: ELSE
583: WriteToLog('Check_invalid_configurations returned success', 3);
584: END IF;
585:

Line 607: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

603:
604: --Bugfix 13362916: Passing the new parameter
605: Write_Config_Status(l_return_status,l_return_code);
606:
607: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
608: WriteToLog('Write_Config_Status returned unexpected error', 1);
609: ELSE
610: WriteToLog('Write_Config_Status returned success', 3);
611: END IF;

Line 690: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

686: , xReturnStatus => l_return_status
687: , xMsgCount => l_msg_count
688: , xMsgData => l_msg_data);
689:
690: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
691: WriteToLog('ERROR: Update_items_and_sourcing returned unexpected error');
692: raise FND_API.G_EXC_UNEXPECTED_ERROR;
693: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
694: WriteToLog('ERROR: Update_items_and_sourcing returned expected error');

Line 692: raise FND_API.G_EXC_UNEXPECTED_ERROR;

688: , xMsgData => l_msg_data);
689:
690: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
691: WriteToLog('ERROR: Update_items_and_sourcing returned unexpected error');
692: raise FND_API.G_EXC_UNEXPECTED_ERROR;
693: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
694: WriteToLog('ERROR: Update_items_and_sourcing returned expected error');
695: --raise FND_API.G_EXC_ERROR;
696: ELSE

Line 693: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

689:
690: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
691: WriteToLog('ERROR: Update_items_and_sourcing returned unexpected error');
692: raise FND_API.G_EXC_UNEXPECTED_ERROR;
693: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
694: WriteToLog('ERROR: Update_items_and_sourcing returned expected error');
695: --raise FND_API.G_EXC_ERROR;
696: ELSE
697: WriteToLog('Update_items_and_sourcing returned success', 3);

Line 695: --raise FND_API.G_EXC_ERROR;

691: WriteToLog('ERROR: Update_items_and_sourcing returned unexpected error');
692: raise FND_API.G_EXC_UNEXPECTED_ERROR;
693: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
694: WriteToLog('ERROR: Update_items_and_sourcing returned expected error');
695: --raise FND_API.G_EXC_ERROR;
696: ELSE
697: WriteToLog('Update_items_and_sourcing returned success', 3);
698: END IF;
699:

Line 728: if l_return_status <> fnd_api.G_RET_STS_SUCCESS then

724: WriteToLog('update_configs: About to generate bom batch ID', 5);
725:
726: cto_msutil_pub.set_bom_batch_id(x_return_status => l_return_status);
727:
728: if l_return_status <> fnd_api.G_RET_STS_SUCCESS then
729: WriteToLog('update_configs: ' || 'Failed in set_bom_batch_id with unexp error.', 1);
730: raise FND_API.G_EXC_UNEXPECTED_ERROR;
731: end if;
732:

Line 730: raise FND_API.G_EXC_UNEXPECTED_ERROR;

726: cto_msutil_pub.set_bom_batch_id(x_return_status => l_return_status);
727:
728: if l_return_status <> fnd_api.G_RET_STS_SUCCESS then
729: WriteToLog('update_configs: ' || 'Failed in set_bom_batch_id with unexp error.', 1);
730: raise FND_API.G_EXC_UNEXPECTED_ERROR;
731: end if;
732:
733: l_stmt_num := 80;
734:

Line 782: raise FND_API.G_EXC_UNEXPECTED_ERROR;

778: WriteToLog('l_request_id:: '||to_char(l_request_id));
779:
780: IF (l_request_id = 0) THEN
781: WriteToLog('ERROR: Error launching child request for BOM creation.', 1);
782: raise FND_API.G_EXC_UNEXPECTED_ERROR;
783: END IF;
784:
785: <>
786: null;

Line 817: RAISE FND_API.G_EXC_ERROR;

813:
814: EXCEPTION
815: WHEN no_data_found THEN
816: WriteToLog('ERROR: CTO seeded assignment set not found', 1);
817: RAISE FND_API.G_EXC_ERROR;
818: END;
819: WriteToLog('New Msg: CTO Seeded Assignment Set Id::'||l_cto_aset_id, 2);
820: --
821: -- Delete rows from CTO assignment set

Line 846: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

842: --
843: --Bugfix 13362916: Adding the new parameter
844: Write_Config_Status(l_return_status,l_return_code);
845:
846: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
847: WriteToLog('Write_Config_Status returned unexpected error', 1);
848: ELSE
849: WriteToLog('Write_Config_Status returned success', 3);
850: END IF;

Line 869: WHEN FND_API.G_EXC_ERROR THEN

865: end if;
866:
867: EXCEPTION
868:
869: WHEN FND_API.G_EXC_ERROR THEN
870: WriteToLog('ERROR: Exp error in CTO_Update_Configs_Pk.Update_Configs:: '|| l_stmt_num ||'::'||sqlerrm);
871: WriteToLog('+++++++++++++++++++++++++++++++++++++++++++++++++++');
872: WriteToLog('Update Existing Configurations completed with ERROR.', 1);
873: WriteToLog('Please contact the system administrator.', 1);

Line 878: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

874: WriteToLog('+++++++++++++++++++++++++++++++++++++++++++++++++++');
875: errbuf := 'Program completed with error';
876: retcode := 2; --exits with error
877:
878: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
879: WriteToLog('ERROR: Unexp error in CTO_Update_Configs_Pk.Update_Configs:: '|| l_stmt_num ||'::'||sqlerrm, 1);
880: WriteToLog('+++++++++++++++++++++++++++++++++++++++++++++++++++');
881: WriteToLog('Update Existing Configurations completed with ERROR');
882: WriteToLog('+++++++++++++++++++++++++++++++++++++++++++++++++++');

Line 963: x_return_status := FND_API.G_RET_STS_SUCCESS;

959:
960: l_count number;
961:
962: BEGIN
963: x_return_status := FND_API.G_RET_STS_SUCCESS;
964: WriteToLog('Entering populate_all_models', 1);
965:
966: l_stmt_num := 10;
967: l_match := fnd_profile.value('BOM:MATCH_CONFIG');

Line 1351: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1347: v_bac.config_id
1348: , l_return_status
1349: , l_msg_count
1350: , l_msg_data);
1351: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1352: WriteToLog('ERROR: Populate_bcolu_from_bac returned unexp error');
1353: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1354: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1355: WriteToLog('ERROR: Populate_bcolu_from_bac returned expected error');

Line 1353: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1349: , l_msg_count
1350: , l_msg_data);
1351: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1352: WriteToLog('ERROR: Populate_bcolu_from_bac returned unexp error');
1353: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1354: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1355: WriteToLog('ERROR: Populate_bcolu_from_bac returned expected error');
1356: raise FND_API.G_EXC_ERROR;
1357: END IF;

Line 1354: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1350: , l_msg_data);
1351: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1352: WriteToLog('ERROR: Populate_bcolu_from_bac returned unexp error');
1353: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1354: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1355: WriteToLog('ERROR: Populate_bcolu_from_bac returned expected error');
1356: raise FND_API.G_EXC_ERROR;
1357: END IF;
1358: END; -- sub block

Line 1356: raise FND_API.G_EXC_ERROR;

1352: WriteToLog('ERROR: Populate_bcolu_from_bac returned unexp error');
1353: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1354: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1355: WriteToLog('ERROR: Populate_bcolu_from_bac returned expected error');
1356: raise FND_API.G_EXC_ERROR;
1357: END IF;
1358: END; -- sub block
1359: END LOOP;
1360:

Line 1706: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1702: v_bac_top.config_id
1703: , l_return_status
1704: , l_msg_count
1705: , l_msg_data);
1706: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1707: WriteToLog('ERROR: Populate_bcolu_from_bac returned unexp error');
1708: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1709: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1710: WriteToLog('ERROR: Populate_bcolu_from_bac returned expected error');

Line 1708: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1704: , l_msg_count
1705: , l_msg_data);
1706: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1707: WriteToLog('ERROR: Populate_bcolu_from_bac returned unexp error');
1708: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1709: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1710: WriteToLog('ERROR: Populate_bcolu_from_bac returned expected error');
1711: raise FND_API.G_EXC_ERROR;
1712: END IF;

Line 1709: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1705: , l_msg_data);
1706: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1707: WriteToLog('ERROR: Populate_bcolu_from_bac returned unexp error');
1708: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1709: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1710: WriteToLog('ERROR: Populate_bcolu_from_bac returned expected error');
1711: raise FND_API.G_EXC_ERROR;
1712: END IF;
1713: END; -- sub-block

Line 1711: raise FND_API.G_EXC_ERROR;

1707: WriteToLog('ERROR: Populate_bcolu_from_bac returned unexp error');
1708: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1709: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1710: WriteToLog('ERROR: Populate_bcolu_from_bac returned expected error');
1711: raise FND_API.G_EXC_ERROR;
1712: END IF;
1713: END; -- sub-block
1714: END LOOP;
1715:

Line 1723: WHEN FND_API.G_EXC_ERROR THEN

1719:
1720: WriteToLog('Done populate_all_models.', 1);
1721:
1722: EXCEPTION
1723: WHEN FND_API.G_EXC_ERROR THEN
1724: WriteToLog('ERROR: Expected error in Populate_All_Models::'||to_char(l_stmt_num)||'::'||sqlerrm);
1725: x_return_status := FND_API.G_RET_STS_ERROR;
1726: CTO_MSG_PUB.Count_And_Get
1727: (p_msg_count => x_msg_count

Line 1725: x_return_status := FND_API.G_RET_STS_ERROR;

1721:
1722: EXCEPTION
1723: WHEN FND_API.G_EXC_ERROR THEN
1724: WriteToLog('ERROR: Expected error in Populate_All_Models::'||to_char(l_stmt_num)||'::'||sqlerrm);
1725: x_return_status := FND_API.G_RET_STS_ERROR;
1726: CTO_MSG_PUB.Count_And_Get
1727: (p_msg_count => x_msg_count
1728: ,p_msg_data => x_msg_data
1729: );

Line 1731: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1727: (p_msg_count => x_msg_count
1728: ,p_msg_data => x_msg_data
1729: );
1730:
1731: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1732: WriteToLog('ERROR: Unexpected error in Populate_All_Models::'||to_char(l_stmt_num)||'::'||sqlerrm);
1733: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1734: CTO_MSG_PUB.Count_And_Get
1735: (p_msg_count => x_msg_count

Line 1733: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1729: );
1730:
1731: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1732: WriteToLog('ERROR: Unexpected error in Populate_All_Models::'||to_char(l_stmt_num)||'::'||sqlerrm);
1733: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1734: CTO_MSG_PUB.Count_And_Get
1735: (p_msg_count => x_msg_count
1736: ,p_msg_data => x_msg_data
1737: );

Line 1741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1737: );
1738:
1739: WHEN OTHERS THEN
1740: WriteToLog('ERROR: Others error in Populate_All_Models::'||to_char(l_stmt_num)||'::'||sqlerrm);
1741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1742: CTO_MSG_PUB.Count_And_Get
1743: (p_msg_count => x_msg_count
1744: ,p_msg_data => x_msg_data
1745: );

Line 1832: x_return_status := FND_API.G_RET_STS_SUCCESS;

1828: l_stmt_num number := 0;
1829:
1830: BEGIN
1831: WriteToLog ('Entering populate_cat_models', 1);
1832: x_return_status := FND_API.G_RET_STS_SUCCESS;
1833: l_stmt_num := 10;
1834:
1835: l_match := fnd_profile.value('BOM:MATCH_CONFIG');
1836: WriteToLog ('l_match is: ' || to_char(l_match), 1);

Line 2212: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2208: v_bac.config_id
2209: , l_return_status
2210: , l_msg_count
2211: , l_msg_data);
2212: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2213: WriteToLog('ERROR: Populate_bcolu_from_bac returned unexp error');
2214: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2215: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2216: WriteToLog('ERROR: Populate_bcolu_from_bac returned expected error');

Line 2214: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2210: , l_msg_count
2211: , l_msg_data);
2212: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2213: WriteToLog('ERROR: Populate_bcolu_from_bac returned unexp error');
2214: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2215: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2216: WriteToLog('ERROR: Populate_bcolu_from_bac returned expected error');
2217: raise FND_API.G_EXC_ERROR;
2218: END IF;

Line 2215: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2211: , l_msg_data);
2212: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2213: WriteToLog('ERROR: Populate_bcolu_from_bac returned unexp error');
2214: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2215: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2216: WriteToLog('ERROR: Populate_bcolu_from_bac returned expected error');
2217: raise FND_API.G_EXC_ERROR;
2218: END IF;
2219: END; -- sub block

Line 2217: raise FND_API.G_EXC_ERROR;

2213: WriteToLog('ERROR: Populate_bcolu_from_bac returned unexp error');
2214: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2215: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2216: WriteToLog('ERROR: Populate_bcolu_from_bac returned expected error');
2217: raise FND_API.G_EXC_ERROR;
2218: END IF;
2219: END; -- sub block
2220: END LOOP;
2221:

Line 2597: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2593: v_bac_top.config_id
2594: , l_return_status
2595: , l_msg_count
2596: , l_msg_data);
2597: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2598: WriteToLog('ERROR: Populate_bcolu_from_bac returned unexp error');
2599: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2600: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2601: WriteToLog('ERROR: Populate_bcolu_from_bac returned expected error');

Line 2599: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2595: , l_msg_count
2596: , l_msg_data);
2597: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2598: WriteToLog('ERROR: Populate_bcolu_from_bac returned unexp error');
2599: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2600: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2601: WriteToLog('ERROR: Populate_bcolu_from_bac returned expected error');
2602: raise FND_API.G_EXC_ERROR;
2603: END IF;

Line 2600: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2596: , l_msg_data);
2597: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2598: WriteToLog('ERROR: Populate_bcolu_from_bac returned unexp error');
2599: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2600: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2601: WriteToLog('ERROR: Populate_bcolu_from_bac returned expected error');
2602: raise FND_API.G_EXC_ERROR;
2603: END IF;
2604: END; -- sub-block

Line 2602: raise FND_API.G_EXC_ERROR;

2598: WriteToLog('ERROR: Populate_bcolu_from_bac returned unexp error');
2599: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2600: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2601: WriteToLog('ERROR: Populate_bcolu_from_bac returned expected error');
2602: raise FND_API.G_EXC_ERROR;
2603: END IF;
2604: END; -- sub-block
2605: END LOOP;
2606:

Line 2614: WHEN FND_API.G_EXC_ERROR THEN

2610:
2611: WriteToLog('Done populate_cat_models.', 1);
2612:
2613: EXCEPTION
2614: WHEN FND_API.G_EXC_ERROR THEN
2615: WriteToLog('ERROR: Expected error in Populate_Cat_Models::'||to_char(l_stmt_num)||'::'||sqlerrm);
2616: x_return_status := FND_API.G_RET_STS_ERROR;
2617: CTO_MSG_PUB.Count_And_Get
2618: (p_msg_count => x_msg_count

Line 2616: x_return_status := FND_API.G_RET_STS_ERROR;

2612:
2613: EXCEPTION
2614: WHEN FND_API.G_EXC_ERROR THEN
2615: WriteToLog('ERROR: Expected error in Populate_Cat_Models::'||to_char(l_stmt_num)||'::'||sqlerrm);
2616: x_return_status := FND_API.G_RET_STS_ERROR;
2617: CTO_MSG_PUB.Count_And_Get
2618: (p_msg_count => x_msg_count
2619: ,p_msg_data => x_msg_data
2620: );

Line 2622: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2618: (p_msg_count => x_msg_count
2619: ,p_msg_data => x_msg_data
2620: );
2621:
2622: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2623: WriteToLog('ERROR: Unexpected error in Populate_Cat_Models::'||to_char(l_stmt_num)||'::'||sqlerrm);
2624: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2625: CTO_MSG_PUB.Count_And_Get
2626: (p_msg_count => x_msg_count

Line 2624: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2620: );
2621:
2622: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2623: WriteToLog('ERROR: Unexpected error in Populate_Cat_Models::'||to_char(l_stmt_num)||'::'||sqlerrm);
2624: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2625: CTO_MSG_PUB.Count_And_Get
2626: (p_msg_count => x_msg_count
2627: ,p_msg_data => x_msg_data
2628: );

Line 2632: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2628: );
2629:
2630: WHEN OTHERS THEN
2631: WriteToLog('ERROR: Others error in Populate_Cat_Models::'||to_char(l_stmt_num)||'::'||sqlerrm);
2632: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2633: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2634: FND_MSG_PUB.Add_Exc_Msg
2635: (G_PKG_NAME
2636: ,'Populate_Cat_Models');

Line 2665: x_return_status := FND_API.G_RET_STS_SUCCESS;

2661:
2662: BEGIN
2663: WriteToLog ('Entering populate_config', 1);
2664: WriteToLog ('p_config_id is: ' || to_char(p_config_id), 1);
2665: x_return_status := FND_API.G_RET_STS_SUCCESS;
2666: l_stmt_num := 10;
2667:
2668: l_match := fnd_profile.value('BOM:MATCH_CONFIG');
2669: WriteToLog ('l_match is: ' || to_char(l_match), 1);

Line 3050: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3046: p_config_id
3047: , l_return_status
3048: , l_msg_count
3049: , l_msg_data);
3050: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3051: WriteToLog('ERROR: Populate_bcolu_from_bac returned unexp error');
3052: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3053: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3054: WriteToLog('ERROR: Populate_bcolu_from_bac returned expected error');

Line 3052: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3048: , l_msg_count
3049: , l_msg_data);
3050: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3051: WriteToLog('ERROR: Populate_bcolu_from_bac returned unexp error');
3052: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3053: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3054: WriteToLog('ERROR: Populate_bcolu_from_bac returned expected error');
3055: raise FND_API.G_EXC_ERROR;
3056: END IF;

Line 3053: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3049: , l_msg_data);
3050: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3051: WriteToLog('ERROR: Populate_bcolu_from_bac returned unexp error');
3052: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3053: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3054: WriteToLog('ERROR: Populate_bcolu_from_bac returned expected error');
3055: raise FND_API.G_EXC_ERROR;
3056: END IF;
3057: END; -- sub block

Line 3055: raise FND_API.G_EXC_ERROR;

3051: WriteToLog('ERROR: Populate_bcolu_from_bac returned unexp error');
3052: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3053: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3054: WriteToLog('ERROR: Populate_bcolu_from_bac returned expected error');
3055: raise FND_API.G_EXC_ERROR;
3056: END IF;
3057: END; -- sub block
3058: END IF; /* l_attribute = 3 */
3059: END IF; /* l_match = 1 */

Line 3066: WHEN FND_API.G_EXC_ERROR THEN

3062:
3063: WriteToLog('Done populate_config');
3064:
3065: EXCEPTION
3066: WHEN FND_API.G_EXC_ERROR THEN
3067: WriteToLog('ERROR: Expected error in Populate_Config::'||to_char(l_stmt_num)||'::'||sqlerrm);
3068: x_return_status := FND_API.G_RET_STS_ERROR;
3069: CTO_MSG_PUB.Count_And_Get
3070: (p_msg_count => x_msg_count

Line 3068: x_return_status := FND_API.G_RET_STS_ERROR;

3064:
3065: EXCEPTION
3066: WHEN FND_API.G_EXC_ERROR THEN
3067: WriteToLog('ERROR: Expected error in Populate_Config::'||to_char(l_stmt_num)||'::'||sqlerrm);
3068: x_return_status := FND_API.G_RET_STS_ERROR;
3069: CTO_MSG_PUB.Count_And_Get
3070: (p_msg_count => x_msg_count
3071: ,p_msg_data => x_msg_data
3072: );

Line 3074: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3070: (p_msg_count => x_msg_count
3071: ,p_msg_data => x_msg_data
3072: );
3073:
3074: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3075: WriteToLog('ERROR: Unexpected error in Populate_Config::'||to_char(l_stmt_num)||'::'||sqlerrm);
3076: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3077: CTO_MSG_PUB.Count_And_Get
3078: (p_msg_count => x_msg_count

Line 3076: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3072: );
3073:
3074: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3075: WriteToLog('ERROR: Unexpected error in Populate_Config::'||to_char(l_stmt_num)||'::'||sqlerrm);
3076: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3077: CTO_MSG_PUB.Count_And_Get
3078: (p_msg_count => x_msg_count
3079: ,p_msg_data => x_msg_data
3080: );

Line 3084: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3080: );
3081:
3082: WHEN OTHERS THEN
3083: WriteToLog('ERROR: Others error in Populate_Config::'||to_char(l_stmt_num)||'::'||sqlerrm);
3084: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3085: CTO_MSG_PUB.Count_And_Get
3086: (p_msg_count => x_msg_count
3087: ,p_msg_data => x_msg_data
3088: );

Line 3145: x_return_status := FND_API.G_RET_STS_SUCCESS;

3141: l_skip_config number := 0; --Bugfix 13362916
3142: l_exists varchar2(1); --Bugfix 13362916
3143: BEGIN
3144:
3145: x_return_status := FND_API.G_RET_STS_SUCCESS;
3146: l_stmt_num := 10;
3147:
3148: -- bug 13362916
3149: WriteToLog('=================Inside populate_bcolu_from_bac:p_config_id::' || p_config_id || '=================');

Line 3235: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3231: l_return_status,
3232: l_msg_count,
3233: l_msg_data);
3234:
3235: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3236: WriteToLog('ERROR: Populate_child_config returned unexp error.');
3237: --
3238: -- bug 13362916
3239: --

Line 3240: -- raise FND_API.G_EXC_UNEXPECTED_ERROR;

3236: WriteToLog('ERROR: Populate_child_config returned unexp error.');
3237: --
3238: -- bug 13362916
3239: --
3240: -- raise FND_API.G_EXC_UNEXPECTED_ERROR;
3241: l_skip_config := 1;
3242: exit;
3243: END IF;
3244:

Line 3267: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3263: -- populate link_to_line_id
3264: l_stmt_num := 70;
3265: populate_link_to_line_id(t_bcol,
3266: l_return_status);
3267: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3268: WriteToLog('ERROR: Populate_link_to_line_id returned unexp error');
3269: --Bugfix 13362916
3270: --raise FND_API.G_EXC_UNEXPECTED_ERROR;
3271: l_skip_config := 1;

Line 3270: --raise FND_API.G_EXC_UNEXPECTED_ERROR;

3266: l_return_status);
3267: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3268: WriteToLog('ERROR: Populate_link_to_line_id returned unexp error');
3269: --Bugfix 13362916
3270: --raise FND_API.G_EXC_UNEXPECTED_ERROR;
3271: l_skip_config := 1;
3272: END IF;
3273:
3274: -- convert t_bcol to sparse array

Line 3279: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3275: l_stmt_num := 80;
3276: IF l_skip_config = 0 then --Bugfix 13362916
3277: contiguous_to_sparse_bcol(t_bcol,
3278: l_return_status);
3279: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3280: WriteToLog('ERROR: Contiguous_to_sparse_bcol returned unexp error');
3281: --Bugfix 13362916
3282: --raise FND_API.G_EXC_UNEXPECTED_ERROR;
3283: l_skip_config := 1;

Line 3282: --raise FND_API.G_EXC_UNEXPECTED_ERROR;

3278: l_return_status);
3279: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3280: WriteToLog('ERROR: Contiguous_to_sparse_bcol returned unexp error');
3281: --Bugfix 13362916
3282: --raise FND_API.G_EXC_UNEXPECTED_ERROR;
3283: l_skip_config := 1;
3284: END IF;
3285: END IF;
3286:

Line 3292: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3288: l_stmt_num := 90;
3289: IF l_skip_config = 0 then --Bugfix 13362916
3290: populate_plan_level(t_bcol,
3291: l_return_status);
3292: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3293: WriteToLog('ERROR: Populate_plan_level returned unexp error');
3294: --Bugfix 13362916
3295: --raise FND_API.G_EXC_UNEXPECTED_ERROR;
3296: l_skip_config := 1;

Line 3295: --raise FND_API.G_EXC_UNEXPECTED_ERROR;

3291: l_return_status);
3292: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3293: WriteToLog('ERROR: Populate_plan_level returned unexp error');
3294: --Bugfix 13362916
3295: --raise FND_API.G_EXC_UNEXPECTED_ERROR;
3296: l_skip_config := 1;
3297: END IF;
3298: END IF;
3299:

Line 3305: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3301: l_stmt_num := 100;
3302: IF l_skip_config = 0 then --Bugfix 13362916
3303: populate_wip_supply_type(t_bcol,
3304: l_return_status);
3305: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3306: WriteToLog('ERROR: Populate_wip_supply_type returned unexp error');
3307: --Bugfix 13362916
3308: --raise FND_API.G_EXC_UNEXPECTED_ERROR;
3309: l_skip_config := 1;

Line 3308: --raise FND_API.G_EXC_UNEXPECTED_ERROR;

3304: l_return_status);
3305: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3306: WriteToLog('ERROR: Populate_wip_supply_type returned unexp error');
3307: --Bugfix 13362916
3308: --raise FND_API.G_EXC_UNEXPECTED_ERROR;
3309: l_skip_config := 1;
3310: -- bug 5859772: If a 'N' (for no data found exception in populate_wip_supply_type ) is returned,
3311: -- it means the bill has changed since the config was created.
3312: -- We will not process the config in that case and simply return.

Line 3325: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3321: IF l_skip_config = 0 then --Bugfix 13362916
3322: populate_parent_ato(t_bcol,
3323: l_top_model_line_id,
3324: l_return_status);
3325: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3326: WriteToLog('ERROR: Populate_parent_ato returned unexp error');
3327: --Bugfix 13362916
3328: --raise FND_API.G_EXC_UNEXPECTED_ERROR;
3329: l_skip_config := 1;

Line 3328: --raise FND_API.G_EXC_UNEXPECTED_ERROR;

3324: l_return_status);
3325: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3326: WriteToLog('ERROR: Populate_parent_ato returned unexp error');
3327: --Bugfix 13362916
3328: --raise FND_API.G_EXC_UNEXPECTED_ERROR;
3329: l_skip_config := 1;
3330: END IF;
3331: END IF;
3332:

Line 3518: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3514: end if;
3515: WriteToLog('=================End populate_bcolu_from_bac:p_config_id::' || p_config_id || '=================');
3516:
3517: EXCEPTION
3518: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3519: WriteToLog('ERROR: Unexpected error in Populate_Bcolu_From_Bac::'||to_char(l_stmt_num)||'::'||sqlerrm);
3520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3521: CTO_MSG_PUB.Count_And_Get
3522: (p_msg_count => x_msg_count

Line 3520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3516:
3517: EXCEPTION
3518: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3519: WriteToLog('ERROR: Unexpected error in Populate_Bcolu_From_Bac::'||to_char(l_stmt_num)||'::'||sqlerrm);
3520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3521: CTO_MSG_PUB.Count_And_Get
3522: (p_msg_count => x_msg_count
3523: ,p_msg_data => x_msg_data
3524: );

Line 3528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3524: );
3525:
3526: WHEN OTHERS THEN
3527: WriteToLog('ERROR: Others error in Populate_Bcolu_From_Bac::'||to_char(l_stmt_num)||'::'||sqlerrm);
3528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3529: CTO_MSG_PUB.Count_And_Get
3530: (p_msg_count => x_msg_count
3531: ,p_msg_data => x_msg_data
3532: );

Line 3598: x_return_status := FND_API.G_RET_STS_SUCCESS;

3594: WriteToLog('p_parent_index=>'||p_parent_index);
3595: WriteToLog('p_child_config_id=>'||p_child_config_id);
3596:
3597: l_stmt_num := 10;
3598: x_return_status := FND_API.G_RET_STS_SUCCESS;
3599: l_parent_index := p_parent_index;
3600:
3601: WriteToLog('t_bcol(l_parent_index).header_id=>'||t_bcol(l_parent_index).header_id);
3602:

Line 3631: raise FND_API.G_EXC_ERROR;

3627:
3628: WriteToLog('++++++++++++++++++++++++++++++++++++++++', 1);
3629: WriteToLog('Item attribute Configured Item, BOM creation not setup correctly for child model '||l_child_model_name||' . Please correct this and run the program again.', 1);
3630: WriteToLog('++++++++++++++++++++++++++++++++++++++++', 1);
3631: raise FND_API.G_EXC_ERROR;
3632: ELSE
3633: -- populate config_id column for this line
3634: l_stmt_num := 40;
3635: t_bcol(l_parent_index).config_item_id := t_bcol(l_parent_index).header_id;

Line 3699: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3695: l_return_status,
3696: l_msg_count,
3697: l_msg_data);
3698:
3699: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3700: WriteToLog('ERROR: Populate_child_config returned unexp error');
3701: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3702: END IF;
3703: END IF;

Line 3701: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3697: l_msg_data);
3698:
3699: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3700: WriteToLog('ERROR: Populate_child_config returned unexp error');
3701: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3702: END IF;
3703: END IF;
3704: END LOOP;
3705:

Line 3707: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3703: END IF;
3704: END LOOP;
3705:
3706: EXCEPTION
3707: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3708: WriteToLog('ERROR: Unexpected error in Populate_Child_Config::'||to_char(l_stmt_num)||'::'||sqlerrm);
3709: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3710: CTO_MSG_PUB.Count_And_Get
3711: (p_msg_count => x_msg_count

Line 3709: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3705:
3706: EXCEPTION
3707: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3708: WriteToLog('ERROR: Unexpected error in Populate_Child_Config::'||to_char(l_stmt_num)||'::'||sqlerrm);
3709: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3710: CTO_MSG_PUB.Count_And_Get
3711: (p_msg_count => x_msg_count
3712: ,p_msg_data => x_msg_data
3713: );

Line 3717: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3713: );
3714:
3715: WHEN OTHERS THEN
3716: WriteToLog('ERROR: Others error in Populate_Child_Config::'||to_char(l_stmt_num)||'::'||sqlerrm);
3717: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3718: CTO_MSG_PUB.Count_And_Get
3719: (p_msg_count => x_msg_count
3720: ,p_msg_data => x_msg_data
3721: );

Line 3762: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3758:
3759: EXCEPTION
3760: WHEN OTHERS THEN
3761: WriteToLog('ERROR: Others error in Populate_Link_To_Line_Id::'||to_char(l_stmt_num)||'::'||sqlerrm);
3762: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3763:
3764: END populate_link_to_line_id;
3765:
3766:

Line 3811: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3807:
3808: EXCEPTION
3809: WHEN OTHERS THEN
3810: WriteToLog('ERROR: Others error in Populate_Plan_Level::'||to_char(l_stmt_num)||'::'||sqlerrm);
3811: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3812:
3813: END populate_plan_level;
3814:
3815:

Line 3873: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3869:
3870: EXCEPTION
3871: WHEN OTHERS THEN
3872: WriteToLog('ERROR: Others error in Populate_Wip_Supply_Type::'||to_char(l_stmt_num)||'::'||sqlerrm);
3873: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3874:
3875: END populate_wip_supply_type;
3876:
3877:

Line 3936: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3932:
3933: EXCEPTION
3934: WHEN OTHERS THEN
3935: WriteToLog('ERROR: Others error in Populate_Parent_Ato::'||to_char(l_stmt_num)||'::'||sqlerrm);
3936: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3937:
3938: END populate_parent_ato;
3939:
3940:

Line 3966: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3962:
3963: EXCEPTION
3964: WHEN OTHERS THEN
3965: WriteToLog('ERROR: Others error in Contiguous_To_Sparse_Bcol::'||to_char(l_stmt_num)||'::'||sqlerrm);
3966: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3967:
3968: END contiguous_to_sparse_bcol;
3969:
3970:

Line 4065: x_return_status := FND_API.G_RET_STS_SUCCESS;

4061:
4062: BEGIN
4063:
4064: l_stmt_num := 10;
4065: x_return_status := FND_API.G_RET_STS_SUCCESS;
4066: x_return_code := 0; -- bug 13362916
4067:
4068: WriteToLog('+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++', 1);
4069: WriteToLog('+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++', 1);

Line 4116: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4112:
4113: EXCEPTION
4114: WHEN OTHERS THEN
4115: WriteToLog('Others error in Write_Config_Status::'||l_stmt_num||'::'||sqlerrm);
4116: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4117:
4118: END Write_Config_Status;
4119:
4120:

Line 4176: x_return_status := FND_API.G_RET_STS_SUCCESS;

4172:
4173:
4174: BEGIN
4175: l_stmt_num := 10;
4176: x_return_status := FND_API.G_RET_STS_SUCCESS;
4177:
4178:
4179: l_stmt_num := 20;
4180: FOR c_config in c_invalid_configuration

Line 4275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4271: WriteToLog('+++++++++++++++++++++++++++++++++++++++++++++++++++');
4272: WriteToLog('Update Existing Configurations completed with ERROR');
4273: WriteToLog('+++++++++++++++++++++++++++++++++++++++++++++++++++');
4274: WriteToLog(' error in Check_invalid_configurations::'||sqlerrm, 1);
4275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4276:
4277:
4278:
4279: END Check_invalid_configurations;