APPS.CTO_UPDATE_CONFIGS_PK dependencies on FND_PROFILE

Line 75: PG_DEBUG Number := NVL(FND_PROFILE.value('ONT_DEBUG_LEVEL'), 0);

71: |
72: +-----------------------------------------------------------------------------*/
73:
74: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CTO_UPDATE_CONFIGS_PK';
75: PG_DEBUG Number := NVL(FND_PROFILE.value('ONT_DEBUG_LEVEL'), 0);
76:
77: --forward declaration
78: PROCEDURE Check_invalid_configurations(
79: x_return_status out NOCOPY varchar2);

Line 282: l_mrp_aset_id := to_number(FND_PROFILE.VALUE('MRP_DEFAULT_ASSIGNMENT_SET'));

278:
279: l_stmt_num := 18;
280: IF (p_item = 1) THEN
281: l_stmt_num := 20;
282: l_mrp_aset_id := to_number(FND_PROFILE.VALUE('MRP_DEFAULT_ASSIGNMENT_SET'));
283: WriteToLog('MRP Assignment Set Id::'||l_mrp_aset_id, 2);
284:
285: l_stmt_num := 22;
286: populate_all_models(

Line 350: l_mrp_aset_id := to_number(FND_PROFILE.VALUE('MRP_DEFAULT_ASSIGNMENT_SET'));

346: WriteToLog('New Msg: Sourcing deleted::'||sql%rowcount, 2);
347:
348: ELSIF (p_item = 2) THEN
349: l_stmt_num := 30;
350: l_mrp_aset_id := to_number(FND_PROFILE.VALUE('MRP_DEFAULT_ASSIGNMENT_SET'));
351: WriteToLog('MRP Assignment Set Id::'||l_mrp_aset_id, 2);
352:
353: l_stmt_num := 34;
354: populate_cat_models(

Line 430: l_mrp_aset_id := to_number(FND_PROFILE.VALUE('MRP_DEFAULT_ASSIGNMENT_SET'));

426: WriteToLog('New Msg: Sourcing deleted::'||sql%rowcount, 2);
427:
428: ELSE
429: l_stmt_num := 40;
430: l_mrp_aset_id := to_number(FND_PROFILE.VALUE('MRP_DEFAULT_ASSIGNMENT_SET'));
431: WriteToLog('MRP Assignment Set Id::'||l_mrp_aset_id, 2);
432:
433: l_stmt_num := 45;
434:

Line 967: l_match := fnd_profile.value('BOM:MATCH_CONFIG');

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');
968: WriteToLog('l_match is: '|| l_match, 1);
969:
970: l_stmt_num := 20;
971: IF ((l_match = 2) AND (p_open_lines = 'N')) THEN

Line 1835: l_match := fnd_profile.value('BOM:MATCH_CONFIG');

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);
1837:
1838: l_stmt_num := 20;
1839: IF ((l_match = 2) AND (p_open_lines = 'N')) THEN

Line 2668: l_match := fnd_profile.value('BOM:MATCH_CONFIG');

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);
2670: l_stmt_num := 20;
2671:
2672: IF ((l_match = 2) AND (p_open_lines = 'N')) THEN