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 269: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

265: l_return_status,
266: l_msg_count,
267: l_msg_data);
268:
269: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
270: WriteToLog('ERROR: Populate_all_models returned unexpected error');
271: raise FND_API.G_EXC_UNEXPECTED_ERROR;
272: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
273: WriteToLog('ERROR: Populate_all_models returned expected error');

Line 271: raise FND_API.G_EXC_UNEXPECTED_ERROR;

267: l_msg_data);
268:
269: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
270: WriteToLog('ERROR: Populate_all_models returned unexpected error');
271: raise FND_API.G_EXC_UNEXPECTED_ERROR;
272: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
273: WriteToLog('ERROR: Populate_all_models returned expected error');
274: raise FND_API.G_EXC_ERROR;
275: ELSE

Line 272: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

268:
269: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
270: WriteToLog('ERROR: Populate_all_models returned unexpected error');
271: raise FND_API.G_EXC_UNEXPECTED_ERROR;
272: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
273: WriteToLog('ERROR: Populate_all_models returned expected error');
274: raise FND_API.G_EXC_ERROR;
275: ELSE
276: WriteToLog('Populate_all_models returned success', 3);

Line 274: raise FND_API.G_EXC_ERROR;

270: WriteToLog('ERROR: Populate_all_models returned unexpected error');
271: raise FND_API.G_EXC_UNEXPECTED_ERROR;
272: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
273: WriteToLog('ERROR: Populate_all_models returned expected error');
274: raise FND_API.G_EXC_ERROR;
275: ELSE
276: WriteToLog('Populate_all_models returned success', 3);
277: END IF;
278:

Line 332: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

328: l_return_status,
329: l_msg_count,
330: l_msg_data);
331:
332: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
333: WriteToLog('ERROR: Populate_cat_models returned unexpected error');
334: raise FND_API.G_EXC_UNEXPECTED_ERROR;
335: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
336: WriteToLog('ERROR: Populate_cat_models returned expected error');

Line 334: raise FND_API.G_EXC_UNEXPECTED_ERROR;

330: l_msg_data);
331:
332: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
333: WriteToLog('ERROR: Populate_cat_models returned unexpected error');
334: raise FND_API.G_EXC_UNEXPECTED_ERROR;
335: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
336: WriteToLog('ERROR: Populate_cat_models returned expected error');
337: raise FND_API.G_EXC_ERROR;
338: ELSE

Line 335: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

331:
332: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
333: WriteToLog('ERROR: Populate_cat_models returned unexpected error');
334: raise FND_API.G_EXC_UNEXPECTED_ERROR;
335: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
336: WriteToLog('ERROR: Populate_cat_models returned expected error');
337: raise FND_API.G_EXC_ERROR;
338: ELSE
339: WriteToLog('Populate_cat_models returned success', 3);

Line 337: raise FND_API.G_EXC_ERROR;

333: WriteToLog('ERROR: Populate_cat_models returned unexpected error');
334: raise FND_API.G_EXC_UNEXPECTED_ERROR;
335: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
336: WriteToLog('ERROR: Populate_cat_models returned expected error');
337: raise FND_API.G_EXC_ERROR;
338: ELSE
339: WriteToLog('Populate_cat_models returned success', 3);
340: END IF;
341:

Line 402: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

398: l_return_status,
399: l_msg_count,
400: l_msg_data);
401:
402: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
403: WriteToLog('ERROR: Populate_configs returned unexpected error');
404: raise FND_API.G_EXC_UNEXPECTED_ERROR;
405: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
406: WriteToLog('ERROR: Populate_configs returned expected error');

Line 404: raise FND_API.G_EXC_UNEXPECTED_ERROR;

400: l_msg_data);
401:
402: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
403: WriteToLog('ERROR: Populate_configs returned unexpected error');
404: raise FND_API.G_EXC_UNEXPECTED_ERROR;
405: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
406: WriteToLog('ERROR: Populate_configs returned expected error');
407: raise FND_API.G_EXC_ERROR;
408: ELSE

Line 405: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

401:
402: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
403: WriteToLog('ERROR: Populate_configs returned unexpected error');
404: raise FND_API.G_EXC_UNEXPECTED_ERROR;
405: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
406: WriteToLog('ERROR: Populate_configs returned expected error');
407: raise FND_API.G_EXC_ERROR;
408: ELSE
409: WriteToLog('Populate_configs returned success', 3);

Line 407: raise FND_API.G_EXC_ERROR;

403: WriteToLog('ERROR: Populate_configs returned unexpected error');
404: raise FND_API.G_EXC_UNEXPECTED_ERROR;
405: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
406: WriteToLog('ERROR: Populate_configs returned expected error');
407: raise FND_API.G_EXC_ERROR;
408: ELSE
409: WriteToLog('Populate_configs returned success', 3);
410: END IF;
411:

Line 471: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

467: --perfoming above validation by calling following API
468: l_stmt_num := 50;
469: Check_invalid_configurations(l_return_status);
470:
471: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
472: WriteToLog('Check_invalid_configurations returned unexpected error', 1);
473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
474: ELSE
475: WriteToLog('Check_invalid_configurations returned success', 3);

Line 473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

469: Check_invalid_configurations(l_return_status);
470:
471: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
472: WriteToLog('Check_invalid_configurations returned unexpected error', 1);
473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
474: ELSE
475: WriteToLog('Check_invalid_configurations returned success', 3);
476: END IF;
477:

Line 498: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

494: --
495:
496: Write_Config_Status(l_return_status);
497:
498: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
499: WriteToLog('Write_Config_Status returned unexpected error', 1);
500: ELSE
501: WriteToLog('Write_Config_Status returned success', 3);
502: END IF;

Line 548: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

544: , xReturnStatus => l_return_status
545: , xMsgCount => l_msg_count
546: , xMsgData => l_msg_data);
547:
548: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
549: WriteToLog('ERROR: Update_items_and_sourcing returned unexpected error');
550: raise FND_API.G_EXC_UNEXPECTED_ERROR;
551: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
552: WriteToLog('ERROR: Update_items_and_sourcing returned expected error');

Line 550: raise FND_API.G_EXC_UNEXPECTED_ERROR;

546: , xMsgData => l_msg_data);
547:
548: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
549: WriteToLog('ERROR: Update_items_and_sourcing returned unexpected error');
550: raise FND_API.G_EXC_UNEXPECTED_ERROR;
551: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
552: WriteToLog('ERROR: Update_items_and_sourcing returned expected error');
553: --raise FND_API.G_EXC_ERROR;
554: ELSE

Line 551: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

547:
548: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
549: WriteToLog('ERROR: Update_items_and_sourcing returned unexpected error');
550: raise FND_API.G_EXC_UNEXPECTED_ERROR;
551: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
552: WriteToLog('ERROR: Update_items_and_sourcing returned expected error');
553: --raise FND_API.G_EXC_ERROR;
554: ELSE
555: WriteToLog('Update_items_and_sourcing returned success', 3);

Line 553: --raise FND_API.G_EXC_ERROR;

549: WriteToLog('ERROR: Update_items_and_sourcing returned unexpected error');
550: raise FND_API.G_EXC_UNEXPECTED_ERROR;
551: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
552: WriteToLog('ERROR: Update_items_and_sourcing returned expected error');
553: --raise FND_API.G_EXC_ERROR;
554: ELSE
555: WriteToLog('Update_items_and_sourcing returned success', 3);
556: END IF;
557:

Line 586: if l_return_status <> fnd_api.G_RET_STS_SUCCESS then

582: WriteToLog('update_configs: About to generate bom batch ID', 5);
583:
584: cto_msutil_pub.set_bom_batch_id(x_return_status => l_return_status);
585:
586: if l_return_status <> fnd_api.G_RET_STS_SUCCESS then
587: WriteToLog('update_configs: ' || 'Failed in set_bom_batch_id with unexp error.', 1);
588: raise FND_API.G_EXC_UNEXPECTED_ERROR;
589: end if;
590:

Line 588: raise FND_API.G_EXC_UNEXPECTED_ERROR;

584: cto_msutil_pub.set_bom_batch_id(x_return_status => l_return_status);
585:
586: if l_return_status <> fnd_api.G_RET_STS_SUCCESS then
587: WriteToLog('update_configs: ' || 'Failed in set_bom_batch_id with unexp error.', 1);
588: raise FND_API.G_EXC_UNEXPECTED_ERROR;
589: end if;
590:
591: l_stmt_num := 80;
592: l_seq := 0;

Line 633: raise FND_API.G_EXC_UNEXPECTED_ERROR;

629: WriteToLog('l_request_id:: '||to_char(l_request_id));
630:
631: IF (l_request_id = 0) THEN
632: WriteToLog('ERROR: Error launching child request for BOM creation.', 1);
633: raise FND_API.G_EXC_UNEXPECTED_ERROR;
634: END IF;
635:
636: END LOOP;
637:

Line 669: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

665: -- Write status of all config items processed to log file
666: --
667: Write_Config_Status(l_return_status);
668:
669: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
670: WriteToLog('Write_Config_Status returned unexpected error', 1);
671: ELSE
672: WriteToLog('Write_Config_Status returned success', 3);
673: END IF;

Line 682: WHEN FND_API.G_EXC_ERROR THEN

678: errbuf := 'Program completed successfully.';
679:
680: EXCEPTION
681:
682: WHEN FND_API.G_EXC_ERROR THEN
683: WriteToLog('ERROR: Exp error in CTO_Update_Configs_Pk.Update_Configs:: '|| l_stmt_num ||'::'||sqlerrm);
684: WriteToLog('+++++++++++++++++++++++++++++++++++++++++++++++++++');
685: WriteToLog('Update Existing Configurations completed with ERROR.', 1);
686: WriteToLog('Please contact the system administrator.', 1);

Line 691: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

687: WriteToLog('+++++++++++++++++++++++++++++++++++++++++++++++++++');
688: errbuf := 'Program completed with error';
689: retcode := 2; --exits with error
690:
691: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
692: WriteToLog('ERROR: Unexp error in CTO_Update_Configs_Pk.Update_Configs:: '|| l_stmt_num ||'::'||sqlerrm, 1);
693: WriteToLog('+++++++++++++++++++++++++++++++++++++++++++++++++++');
694: WriteToLog('Update Existing Configurations completed with ERROR');
695: WriteToLog('+++++++++++++++++++++++++++++++++++++++++++++++++++');

Line 776: x_return_status := FND_API.G_RET_STS_SUCCESS;

772:
773: l_count number;
774:
775: BEGIN
776: x_return_status := FND_API.G_RET_STS_SUCCESS;
777: WriteToLog('Entering populate_all_models', 1);
778:
779: l_stmt_num := 10;
780: l_match := fnd_profile.value('BOM:MATCH_CONFIG');

Line 1142: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1138: v_bac.config_id
1139: , l_return_status
1140: , l_msg_count
1141: , l_msg_data);
1142: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1143: WriteToLog('ERROR: Populate_bcolu_from_bac returned unexp error');
1144: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1145: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1146: WriteToLog('ERROR: Populate_bcolu_from_bac returned expected error');

Line 1144: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1140: , l_msg_count
1141: , l_msg_data);
1142: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1143: WriteToLog('ERROR: Populate_bcolu_from_bac returned unexp error');
1144: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1145: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1146: WriteToLog('ERROR: Populate_bcolu_from_bac returned expected error');
1147: raise FND_API.G_EXC_ERROR;
1148: END IF;

Line 1145: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1141: , l_msg_data);
1142: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1143: WriteToLog('ERROR: Populate_bcolu_from_bac returned unexp error');
1144: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1145: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1146: WriteToLog('ERROR: Populate_bcolu_from_bac returned expected error');
1147: raise FND_API.G_EXC_ERROR;
1148: END IF;
1149: END; -- sub block

Line 1147: raise FND_API.G_EXC_ERROR;

1143: WriteToLog('ERROR: Populate_bcolu_from_bac returned unexp error');
1144: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1145: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1146: WriteToLog('ERROR: Populate_bcolu_from_bac returned expected error');
1147: raise FND_API.G_EXC_ERROR;
1148: END IF;
1149: END; -- sub block
1150: END LOOP;
1151:

Line 1493: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1489: v_bac_top.config_id
1490: , l_return_status
1491: , l_msg_count
1492: , l_msg_data);
1493: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1494: WriteToLog('ERROR: Populate_bcolu_from_bac returned unexp error');
1495: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1496: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1497: WriteToLog('ERROR: Populate_bcolu_from_bac returned expected error');

Line 1495: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1491: , l_msg_count
1492: , l_msg_data);
1493: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1494: WriteToLog('ERROR: Populate_bcolu_from_bac returned unexp error');
1495: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1496: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1497: WriteToLog('ERROR: Populate_bcolu_from_bac returned expected error');
1498: raise FND_API.G_EXC_ERROR;
1499: END IF;

Line 1496: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1492: , l_msg_data);
1493: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1494: WriteToLog('ERROR: Populate_bcolu_from_bac returned unexp error');
1495: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1496: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1497: WriteToLog('ERROR: Populate_bcolu_from_bac returned expected error');
1498: raise FND_API.G_EXC_ERROR;
1499: END IF;
1500: END; -- sub-block

Line 1498: raise FND_API.G_EXC_ERROR;

1494: WriteToLog('ERROR: Populate_bcolu_from_bac returned unexp error');
1495: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1496: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1497: WriteToLog('ERROR: Populate_bcolu_from_bac returned expected error');
1498: raise FND_API.G_EXC_ERROR;
1499: END IF;
1500: END; -- sub-block
1501: END LOOP;
1502:

Line 1510: WHEN FND_API.G_EXC_ERROR THEN

1506:
1507: WriteToLog('Done populate_all_models.', 1);
1508:
1509: EXCEPTION
1510: WHEN FND_API.G_EXC_ERROR THEN
1511: WriteToLog('ERROR: Expected error in Populate_All_Models::'||to_char(l_stmt_num)||'::'||sqlerrm);
1512: x_return_status := FND_API.G_RET_STS_ERROR;
1513: CTO_MSG_PUB.Count_And_Get
1514: (p_msg_count => x_msg_count

Line 1512: x_return_status := FND_API.G_RET_STS_ERROR;

1508:
1509: EXCEPTION
1510: WHEN FND_API.G_EXC_ERROR THEN
1511: WriteToLog('ERROR: Expected error in Populate_All_Models::'||to_char(l_stmt_num)||'::'||sqlerrm);
1512: x_return_status := FND_API.G_RET_STS_ERROR;
1513: CTO_MSG_PUB.Count_And_Get
1514: (p_msg_count => x_msg_count
1515: ,p_msg_data => x_msg_data
1516: );

Line 1518: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1514: (p_msg_count => x_msg_count
1515: ,p_msg_data => x_msg_data
1516: );
1517:
1518: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1519: WriteToLog('ERROR: Unexpected error in Populate_All_Models::'||to_char(l_stmt_num)||'::'||sqlerrm);
1520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1521: CTO_MSG_PUB.Count_And_Get
1522: (p_msg_count => x_msg_count

Line 1520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1516: );
1517:
1518: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1519: WriteToLog('ERROR: Unexpected error in Populate_All_Models::'||to_char(l_stmt_num)||'::'||sqlerrm);
1520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1521: CTO_MSG_PUB.Count_And_Get
1522: (p_msg_count => x_msg_count
1523: ,p_msg_data => x_msg_data
1524: );

Line 1528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1524: );
1525:
1526: WHEN OTHERS THEN
1527: WriteToLog('ERROR: Others error in Populate_All_Models::'||to_char(l_stmt_num)||'::'||sqlerrm);
1528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1529: CTO_MSG_PUB.Count_And_Get
1530: (p_msg_count => x_msg_count
1531: ,p_msg_data => x_msg_data
1532: );

Line 1615: x_return_status := FND_API.G_RET_STS_SUCCESS;

1611: l_stmt_num number := 0;
1612:
1613: BEGIN
1614: WriteToLog ('Entering populate_cat_models', 1);
1615: x_return_status := FND_API.G_RET_STS_SUCCESS;
1616: l_stmt_num := 10;
1617:
1618: l_match := fnd_profile.value('BOM:MATCH_CONFIG');
1619: WriteToLog ('l_match is: ' || to_char(l_match), 1);

Line 1991: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1987: v_bac.config_id
1988: , l_return_status
1989: , l_msg_count
1990: , l_msg_data);
1991: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1992: WriteToLog('ERROR: Populate_bcolu_from_bac returned unexp error');
1993: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1994: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1995: WriteToLog('ERROR: Populate_bcolu_from_bac returned expected error');

Line 1993: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1989: , l_msg_count
1990: , l_msg_data);
1991: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1992: WriteToLog('ERROR: Populate_bcolu_from_bac returned unexp error');
1993: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1994: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1995: WriteToLog('ERROR: Populate_bcolu_from_bac returned expected error');
1996: raise FND_API.G_EXC_ERROR;
1997: END IF;

Line 1994: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1990: , l_msg_data);
1991: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1992: WriteToLog('ERROR: Populate_bcolu_from_bac returned unexp error');
1993: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1994: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1995: WriteToLog('ERROR: Populate_bcolu_from_bac returned expected error');
1996: raise FND_API.G_EXC_ERROR;
1997: END IF;
1998: END; -- sub block

Line 1996: raise FND_API.G_EXC_ERROR;

1992: WriteToLog('ERROR: Populate_bcolu_from_bac returned unexp error');
1993: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1994: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1995: WriteToLog('ERROR: Populate_bcolu_from_bac returned expected error');
1996: raise FND_API.G_EXC_ERROR;
1997: END IF;
1998: END; -- sub block
1999: END LOOP;
2000:

Line 2368: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2364: v_bac_top.config_id
2365: , l_return_status
2366: , l_msg_count
2367: , l_msg_data);
2368: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2369: WriteToLog('ERROR: Populate_bcolu_from_bac returned unexp error');
2370: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2371: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2372: WriteToLog('ERROR: Populate_bcolu_from_bac returned expected error');

Line 2370: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2366: , l_msg_count
2367: , l_msg_data);
2368: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2369: WriteToLog('ERROR: Populate_bcolu_from_bac returned unexp error');
2370: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2371: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2372: WriteToLog('ERROR: Populate_bcolu_from_bac returned expected error');
2373: raise FND_API.G_EXC_ERROR;
2374: END IF;

Line 2371: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2367: , l_msg_data);
2368: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2369: WriteToLog('ERROR: Populate_bcolu_from_bac returned unexp error');
2370: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2371: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2372: WriteToLog('ERROR: Populate_bcolu_from_bac returned expected error');
2373: raise FND_API.G_EXC_ERROR;
2374: END IF;
2375: END; -- sub-block

Line 2373: raise FND_API.G_EXC_ERROR;

2369: WriteToLog('ERROR: Populate_bcolu_from_bac returned unexp error');
2370: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2371: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2372: WriteToLog('ERROR: Populate_bcolu_from_bac returned expected error');
2373: raise FND_API.G_EXC_ERROR;
2374: END IF;
2375: END; -- sub-block
2376: END LOOP;
2377:

Line 2385: WHEN FND_API.G_EXC_ERROR THEN

2381:
2382: WriteToLog('Done populate_cat_models.', 1);
2383:
2384: EXCEPTION
2385: WHEN FND_API.G_EXC_ERROR THEN
2386: WriteToLog('ERROR: Expected error in Populate_Cat_Models::'||to_char(l_stmt_num)||'::'||sqlerrm);
2387: x_return_status := FND_API.G_RET_STS_ERROR;
2388: CTO_MSG_PUB.Count_And_Get
2389: (p_msg_count => x_msg_count

Line 2387: x_return_status := FND_API.G_RET_STS_ERROR;

2383:
2384: EXCEPTION
2385: WHEN FND_API.G_EXC_ERROR THEN
2386: WriteToLog('ERROR: Expected error in Populate_Cat_Models::'||to_char(l_stmt_num)||'::'||sqlerrm);
2387: x_return_status := FND_API.G_RET_STS_ERROR;
2388: CTO_MSG_PUB.Count_And_Get
2389: (p_msg_count => x_msg_count
2390: ,p_msg_data => x_msg_data
2391: );

Line 2393: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2389: (p_msg_count => x_msg_count
2390: ,p_msg_data => x_msg_data
2391: );
2392:
2393: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2394: WriteToLog('ERROR: Unexpected error in Populate_Cat_Models::'||to_char(l_stmt_num)||'::'||sqlerrm);
2395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2396: CTO_MSG_PUB.Count_And_Get
2397: (p_msg_count => x_msg_count

Line 2395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2391: );
2392:
2393: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2394: WriteToLog('ERROR: Unexpected error in Populate_Cat_Models::'||to_char(l_stmt_num)||'::'||sqlerrm);
2395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2396: CTO_MSG_PUB.Count_And_Get
2397: (p_msg_count => x_msg_count
2398: ,p_msg_data => x_msg_data
2399: );

Line 2403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2399: );
2400:
2401: WHEN OTHERS THEN
2402: WriteToLog('ERROR: Others error in Populate_Cat_Models::'||to_char(l_stmt_num)||'::'||sqlerrm);
2403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2404: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2405: FND_MSG_PUB.Add_Exc_Msg
2406: (G_PKG_NAME
2407: ,'Populate_Cat_Models');

Line 2436: x_return_status := FND_API.G_RET_STS_SUCCESS;

2432:
2433: BEGIN
2434: WriteToLog ('Entering populate_config', 1);
2435: WriteToLog ('p_config_id is: ' || to_char(p_config_id), 1);
2436: x_return_status := FND_API.G_RET_STS_SUCCESS;
2437: l_stmt_num := 10;
2438:
2439: l_match := fnd_profile.value('BOM:MATCH_CONFIG');
2440: WriteToLog ('l_match is: ' || to_char(l_match), 1);

Line 2818: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2814: p_config_id
2815: , l_return_status
2816: , l_msg_count
2817: , l_msg_data);
2818: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2819: WriteToLog('ERROR: Populate_bcolu_from_bac returned unexp error');
2820: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2821: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2822: WriteToLog('ERROR: Populate_bcolu_from_bac returned expected error');

Line 2820: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2816: , l_msg_count
2817: , l_msg_data);
2818: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2819: WriteToLog('ERROR: Populate_bcolu_from_bac returned unexp error');
2820: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2821: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2822: WriteToLog('ERROR: Populate_bcolu_from_bac returned expected error');
2823: raise FND_API.G_EXC_ERROR;
2824: END IF;

Line 2821: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2817: , l_msg_data);
2818: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2819: WriteToLog('ERROR: Populate_bcolu_from_bac returned unexp error');
2820: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2821: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2822: WriteToLog('ERROR: Populate_bcolu_from_bac returned expected error');
2823: raise FND_API.G_EXC_ERROR;
2824: END IF;
2825: END; -- sub block

Line 2823: raise FND_API.G_EXC_ERROR;

2819: WriteToLog('ERROR: Populate_bcolu_from_bac returned unexp error');
2820: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2821: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2822: WriteToLog('ERROR: Populate_bcolu_from_bac returned expected error');
2823: raise FND_API.G_EXC_ERROR;
2824: END IF;
2825: END; -- sub block
2826: END IF; /* l_attribute = 3 */
2827: END IF; /* l_match = 1 */

Line 2834: WHEN FND_API.G_EXC_ERROR THEN

2830:
2831: WriteToLog('Done populate_config');
2832:
2833: EXCEPTION
2834: WHEN FND_API.G_EXC_ERROR THEN
2835: WriteToLog('ERROR: Expected error in Populate_Config::'||to_char(l_stmt_num)||'::'||sqlerrm);
2836: x_return_status := FND_API.G_RET_STS_ERROR;
2837: CTO_MSG_PUB.Count_And_Get
2838: (p_msg_count => x_msg_count

Line 2836: x_return_status := FND_API.G_RET_STS_ERROR;

2832:
2833: EXCEPTION
2834: WHEN FND_API.G_EXC_ERROR THEN
2835: WriteToLog('ERROR: Expected error in Populate_Config::'||to_char(l_stmt_num)||'::'||sqlerrm);
2836: x_return_status := FND_API.G_RET_STS_ERROR;
2837: CTO_MSG_PUB.Count_And_Get
2838: (p_msg_count => x_msg_count
2839: ,p_msg_data => x_msg_data
2840: );

Line 2842: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2838: (p_msg_count => x_msg_count
2839: ,p_msg_data => x_msg_data
2840: );
2841:
2842: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2843: WriteToLog('ERROR: Unexpected error in Populate_Config::'||to_char(l_stmt_num)||'::'||sqlerrm);
2844: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2845: CTO_MSG_PUB.Count_And_Get
2846: (p_msg_count => x_msg_count

Line 2844: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2840: );
2841:
2842: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2843: WriteToLog('ERROR: Unexpected error in Populate_Config::'||to_char(l_stmt_num)||'::'||sqlerrm);
2844: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2845: CTO_MSG_PUB.Count_And_Get
2846: (p_msg_count => x_msg_count
2847: ,p_msg_data => x_msg_data
2848: );

Line 2852: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2848: );
2849:
2850: WHEN OTHERS THEN
2851: WriteToLog('ERROR: Others error in Populate_Config::'||to_char(l_stmt_num)||'::'||sqlerrm);
2852: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2853: CTO_MSG_PUB.Count_And_Get
2854: (p_msg_count => x_msg_count
2855: ,p_msg_data => x_msg_data
2856: );

Line 2911: x_return_status := FND_API.G_RET_STS_SUCCESS;

2907: l_stmt_num number;
2908:
2909: BEGIN
2910:
2911: x_return_status := FND_API.G_RET_STS_SUCCESS;
2912: l_stmt_num := 10;
2913:
2914: BEGIN
2915: select base_model_id

Line 2992: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2988: l_return_status,
2989: l_msg_count,
2990: l_msg_data);
2991:
2992: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2993: WriteToLog('ERROR: Populate_child_config returned unexp error');
2994: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2995: END IF;
2996:

Line 2994: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2990: l_msg_data);
2991:
2992: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2993: WriteToLog('ERROR: Populate_child_config returned unexp error');
2994: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2995: END IF;
2996:
2997: END IF;
2998: END LOOP;

Line 3017: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3013: -- populate link_to_line_id
3014: l_stmt_num := 70;
3015: populate_link_to_line_id(t_bcol,
3016: l_return_status);
3017: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3018: WriteToLog('ERROR: Populate_link_to_line_id returned unexp error');
3019: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3020: END IF;
3021:

Line 3019: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3015: populate_link_to_line_id(t_bcol,
3016: l_return_status);
3017: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3018: WriteToLog('ERROR: Populate_link_to_line_id returned unexp error');
3019: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3020: END IF;
3021:
3022: -- convert t_bcol to sparse array
3023: l_stmt_num := 80;

Line 3026: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3022: -- convert t_bcol to sparse array
3023: l_stmt_num := 80;
3024: contiguous_to_sparse_bcol(t_bcol,
3025: l_return_status);
3026: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3027: WriteToLog('ERROR: Contiguous_to_sparse_bcol returned unexp error');
3028: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3029: END IF;
3030:

Line 3028: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3024: contiguous_to_sparse_bcol(t_bcol,
3025: l_return_status);
3026: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3027: WriteToLog('ERROR: Contiguous_to_sparse_bcol returned unexp error');
3028: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3029: END IF;
3030:
3031: -- populate plan_level
3032: l_stmt_num := 90;

Line 3035: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3031: -- populate plan_level
3032: l_stmt_num := 90;
3033: populate_plan_level(t_bcol,
3034: l_return_status);
3035: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3036: WriteToLog('ERROR: Populate_plan_level returned unexp error');
3037: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3038: END IF;
3039:

Line 3037: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3033: populate_plan_level(t_bcol,
3034: l_return_status);
3035: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3036: WriteToLog('ERROR: Populate_plan_level returned unexp error');
3037: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3038: END IF;
3039:
3040: -- populate wip_supply_type
3041: l_stmt_num := 100;

Line 3044: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3040: -- populate wip_supply_type
3041: l_stmt_num := 100;
3042: populate_wip_supply_type(t_bcol,
3043: l_return_status);
3044: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3045: WriteToLog('ERROR: Populate_wip_supply_type returned unexp error');
3046: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3047: -- bug 5859772: If a 'N' (for no data found exception in populate_wip_supply_type ) is returned,
3048: -- it means the bill has changed since the config was created.

Line 3046: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3042: populate_wip_supply_type(t_bcol,
3043: l_return_status);
3044: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3045: WriteToLog('ERROR: Populate_wip_supply_type returned unexp error');
3046: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3047: -- bug 5859772: If a 'N' (for no data found exception in populate_wip_supply_type ) is returned,
3048: -- it means the bill has changed since the config was created.
3049: -- We will not process the config in that case and simply return.
3050: ELSIF l_return_status = 'N' then

Line 3060: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3056: l_stmt_num := 110;
3057: populate_parent_ato(t_bcol,
3058: l_top_model_line_id,
3059: l_return_status);
3060: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3061: WriteToLog('ERROR: Populate_parent_ato returned unexp error');
3062: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3063: END IF;
3064:

Line 3062: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3058: l_top_model_line_id,
3059: l_return_status);
3060: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3061: WriteToLog('ERROR: Populate_parent_ato returned unexp error');
3062: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3063: END IF;
3064:
3065: -- insert into bcol
3066: l_stmt_num := 120;

Line 3151: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3147: i:= t_bcol.next(i);
3148: END LOOP;
3149:
3150: EXCEPTION
3151: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3152: WriteToLog('ERROR: Unexpected error in Populate_Bcolu_From_Bac::'||to_char(l_stmt_num)||'::'||sqlerrm);
3153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3154: CTO_MSG_PUB.Count_And_Get
3155: (p_msg_count => x_msg_count

Line 3153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3149:
3150: EXCEPTION
3151: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3152: WriteToLog('ERROR: Unexpected error in Populate_Bcolu_From_Bac::'||to_char(l_stmt_num)||'::'||sqlerrm);
3153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3154: CTO_MSG_PUB.Count_And_Get
3155: (p_msg_count => x_msg_count
3156: ,p_msg_data => x_msg_data
3157: );

Line 3161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3157: );
3158:
3159: WHEN OTHERS THEN
3160: WriteToLog('ERROR: Others error in Populate_Bcolu_From_Bac::'||to_char(l_stmt_num)||'::'||sqlerrm);
3161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3162: CTO_MSG_PUB.Count_And_Get
3163: (p_msg_count => x_msg_count
3164: ,p_msg_data => x_msg_data
3165: );

Line 3230: x_return_status := FND_API.G_RET_STS_SUCCESS;

3226: WriteToLog('p_parent_index=>'||p_parent_index);
3227: WriteToLog('p_child_config_id=>'||p_child_config_id);
3228:
3229: l_stmt_num := 10;
3230: x_return_status := FND_API.G_RET_STS_SUCCESS;
3231: l_parent_index := p_parent_index;
3232:
3233: WriteToLog('t_bcol(l_parent_index).header_id=>'||t_bcol(l_parent_index).header_id);
3234:

Line 3263: raise FND_API.G_EXC_ERROR;

3259:
3260: WriteToLog('++++++++++++++++++++++++++++++++++++++++', 1);
3261: 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);
3262: WriteToLog('++++++++++++++++++++++++++++++++++++++++', 1);
3263: raise FND_API.G_EXC_ERROR;
3264: ELSE
3265: -- populate config_id column for this line
3266: l_stmt_num := 40;
3267: t_bcol(l_parent_index).config_item_id := t_bcol(l_parent_index).header_id;

Line 3330: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3326: l_return_status,
3327: l_msg_count,
3328: l_msg_data);
3329:
3330: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3331: WriteToLog('ERROR: Populate_child_config returned unexp error');
3332: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3333: END IF;
3334: END IF;

Line 3332: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3328: l_msg_data);
3329:
3330: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3331: WriteToLog('ERROR: Populate_child_config returned unexp error');
3332: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3333: END IF;
3334: END IF;
3335: END LOOP;
3336:

Line 3338: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3334: END IF;
3335: END LOOP;
3336:
3337: EXCEPTION
3338: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3339: WriteToLog('ERROR: Unexpected error in Populate_Child_Config::'||to_char(l_stmt_num)||'::'||sqlerrm);
3340: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3341: CTO_MSG_PUB.Count_And_Get
3342: (p_msg_count => x_msg_count

Line 3340: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3336:
3337: EXCEPTION
3338: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3339: WriteToLog('ERROR: Unexpected error in Populate_Child_Config::'||to_char(l_stmt_num)||'::'||sqlerrm);
3340: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3341: CTO_MSG_PUB.Count_And_Get
3342: (p_msg_count => x_msg_count
3343: ,p_msg_data => x_msg_data
3344: );

Line 3348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3344: );
3345:
3346: WHEN OTHERS THEN
3347: WriteToLog('ERROR: Others error in Populate_Child_Config::'||to_char(l_stmt_num)||'::'||sqlerrm);
3348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3349: CTO_MSG_PUB.Count_And_Get
3350: (p_msg_count => x_msg_count
3351: ,p_msg_data => x_msg_data
3352: );

Line 3393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3389:
3390: EXCEPTION
3391: WHEN OTHERS THEN
3392: WriteToLog('ERROR: Others error in Populate_Link_To_Line_Id::'||to_char(l_stmt_num)||'::'||sqlerrm);
3393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3394:
3395: END populate_link_to_line_id;
3396:
3397:

Line 3442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3438:
3439: EXCEPTION
3440: WHEN OTHERS THEN
3441: WriteToLog('ERROR: Others error in Populate_Plan_Level::'||to_char(l_stmt_num)||'::'||sqlerrm);
3442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3443:
3444: END populate_plan_level;
3445:
3446:

Line 3504: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3500:
3501: EXCEPTION
3502: WHEN OTHERS THEN
3503: WriteToLog('ERROR: Others error in Populate_Wip_Supply_Type::'||to_char(l_stmt_num)||'::'||sqlerrm);
3504: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3505:
3506: END populate_wip_supply_type;
3507:
3508:

Line 3567: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3563:
3564: EXCEPTION
3565: WHEN OTHERS THEN
3566: WriteToLog('ERROR: Others error in Populate_Parent_Ato::'||to_char(l_stmt_num)||'::'||sqlerrm);
3567: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3568:
3569: END populate_parent_ato;
3570:
3571:

Line 3597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3593:
3594: EXCEPTION
3595: WHEN OTHERS THEN
3596: WriteToLog('ERROR: Others error in Contiguous_To_Sparse_Bcol::'||to_char(l_stmt_num)||'::'||sqlerrm);
3597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3598:
3599: END contiguous_to_sparse_bcol;
3600:
3601:

Line 3694: x_return_status := FND_API.G_RET_STS_SUCCESS;

3690:
3691: BEGIN
3692:
3693: l_stmt_num := 10;
3694: x_return_status := FND_API.G_RET_STS_SUCCESS;
3695:
3696: WriteToLog('+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++', 1);
3697: WriteToLog('+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++', 1);
3698: WriteToLog('+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++', 1);

Line 3738: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3734:
3735: EXCEPTION
3736: WHEN OTHERS THEN
3737: WriteToLog('Others error in Write_Config_Status::'||l_stmt_num||'::'||sqlerrm, 1);
3738: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3739:
3740: END Write_Config_Status;
3741:
3742:

Line 3796: x_return_status := FND_API.G_RET_STS_SUCCESS;

3792:
3793:
3794: BEGIN
3795: l_stmt_num := 10;
3796: x_return_status := FND_API.G_RET_STS_SUCCESS;
3797:
3798:
3799: l_stmt_num := 20;
3800: FOR c_config in c_invalid_configuration

Line 3895: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3891: WriteToLog('+++++++++++++++++++++++++++++++++++++++++++++++++++');
3892: WriteToLog('Update Existing Configurations completed with ERROR');
3893: WriteToLog('+++++++++++++++++++++++++++++++++++++++++++++++++++');
3894: WriteToLog(' error in Check_invalid_configurations::'||sqlerrm, 1);
3895: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3896:
3897:
3898:
3899: END Check_invalid_configurations;