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 258: l_mrp_aset_id := to_number(FND_PROFILE.VALUE('MRP_DEFAULT_ASSIGNMENT_SET'));

254:
255: l_stmt_num := 18;
256: IF (p_item = 1) THEN
257: l_stmt_num := 20;
258: l_mrp_aset_id := to_number(FND_PROFILE.VALUE('MRP_DEFAULT_ASSIGNMENT_SET'));
259: WriteToLog('MRP Assignment Set Id::'||l_mrp_aset_id, 2);
260:
261: l_stmt_num := 22;
262: populate_all_models(

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

316: WriteToLog('Sourcing deleted::'||sql%rowcount, 2);
317:
318: ELSIF (p_item = 2) THEN
319: l_stmt_num := 30;
320: l_mrp_aset_id := to_number(FND_PROFILE.VALUE('MRP_DEFAULT_ASSIGNMENT_SET'));
321: WriteToLog('MRP Assignment Set Id::'||l_mrp_aset_id, 2);
322:
323: l_stmt_num := 34;
324: populate_cat_models(

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

385: WriteToLog('Sourcing deleted::'||sql%rowcount, 2);
386:
387: ELSE
388: l_stmt_num := 40;
389: l_mrp_aset_id := to_number(FND_PROFILE.VALUE('MRP_DEFAULT_ASSIGNMENT_SET'));
390: WriteToLog('MRP Assignment Set Id::'||l_mrp_aset_id, 2);
391:
392: l_stmt_num := 45;
393:

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

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');
781: WriteToLog('l_match is: '|| l_match, 1);
782:
783: l_stmt_num := 20;
784: IF ((l_match = 2) AND (p_open_lines = 'N')) THEN

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

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);
1620:
1621: l_stmt_num := 20;
1622: IF ((l_match = 2) AND (p_open_lines = 'N')) THEN

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

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);
2441: l_stmt_num := 20;
2442:
2443: IF ((l_match = 2) AND (p_open_lines = 'N')) THEN