DBA Data[Home] [Help]

APPS.MSC_BAL_UTILS dependencies on FND_PROFILE

Line 3: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('MSC_ATP_DEBUG'), 'N');

1: PACKAGE BODY MSC_BAL_UTILS AS
2: /* $Header: MSCUBALB.pls 120.8 2007/12/14 07:31:47 sbnaik ship $ */
3: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('MSC_ATP_DEBUG'), 'N');
4:
5: PROCEDURE extend( p_nodes IN OUT NoCopy mrp_bal_utils.mrp_oe_rec , extend_amount NUMBER );
6: PROCEDURE trim( p_nodes IN OUT NoCopy mrp_bal_utils.mrp_oe_rec , trim_amount NUMBER );
7:

Line 577: if (NVL(fnd_profile.value('MRP_ATP_CALC_SD'), 'N')) = 'Y' then

573: l_sql_stmt2;
574:
575: end if;
576:
577: if (NVL(fnd_profile.value('MRP_ATP_CALC_SD'), 'N')) = 'Y' then
578: l_profile_value := 1;
579: end if;
580:
581:

Line 1146: --dbms_application_info.set_client_info(fnd_profile.value('ORG_ID'));

1142: return; -- sth wrong with atp engine
1143: ELSE -- atp is successful , proceed to om call
1144: -- need to reset client_info before
1145: --calling OM api to avoid bug 3145033
1146: --dbms_application_info.set_client_info(fnd_profile.value('ORG_ID'));
1147: fnd_global.apps_initialize(p_user_id,
1148: p_resp_id,
1149: p_appl_id);
1150: mo_global.init('ONT'); -- MOAC changes

Line 1289: if ( (p_tcf) OR (NVL(fnd_profile.value('MRP_ATP_PERSIST'), 'N')) = 'Y' ) then

1285: -- not used.
1286: -- so we will cal populate_mrp_atp_temp_tables all the time.
1287: -- this will insure that the data inserted by atp is rollbacked
1288: -- but temp table data stays for further usage, such as reports and etc...
1289: if ( (p_tcf) OR (NVL(fnd_profile.value('MRP_ATP_PERSIST'), 'N')) = 'Y' ) then
1290: IF PG_DEBUG in ('Y', 'C') THEN
1291: msc_sch_wb.atp_debug('MSC_BAL_UTILS.schedule_orders '||
1292: ' calling populate_mrp_atp_temp_tables ' ||
1293: ' tcf is used ');

Line 1330: if ( (p_tcf) OR (NVL(fnd_profile.value('MRP_ATP_PERSIST'), 'N')) = 'Y' )then

1326: msc_sch_wb.calc_exceptions(p_session_id,
1327: x_return_status,
1328: x_msg_data,
1329: x_msg_count);
1330: if ( (p_tcf) OR (NVL(fnd_profile.value('MRP_ATP_PERSIST'), 'N')) = 'Y' )then
1331: commit;
1332: end if;
1333:
1334: IF PG_DEBUG in ('Y', 'C') THEN

Line 1357: --dbms_application_info.set_client_info(fnd_profile.value('ORG_ID'));

1353: fetch check_oe into l_column_exist;
1354: close check_oe;
1355:
1356: if l_column_exist =1 then
1357: --dbms_application_info.set_client_info(fnd_profile.value('ORG_ID'));
1358: mo_global.init('ONT');
1359: execute immediate sql_stmt using p_session_id;
1360: end if;
1361:

Line 1517: fnd_profile.put('OE_DEBUG_LOG_DIRECTORY',l_dir);

1513: end if;
1514:
1515: msc_sch_wb.atp_debug( 'call_oe_api:OM debugging dir is ' || l_dir);
1516:
1517: fnd_profile.put('OE_DEBUG_LOG_DIRECTORY',l_dir);
1518: oe_debug_pub.debug_on;
1519: oe_debug_pub.initialize;
1520: oe_debug_pub.setdebuglevel(5);
1521: msc_sch_wb.atp_debug( 'call_oe_api:OM debugging done setdebuglevel');