APPS.MSC_SCE_PUB_SUPPLY_COMMIT_PKG dependencies on FND_PROFILE

Line 751: IF (nvl(FND_PROFILE.VALUE('MSC_PUBLISH_SUPPLY_COMMIT'),'N') = 'N') THEN

747:
748: -- bug#6345381
749: -- dejoshi
750:
751: IF (nvl(FND_PROFILE.VALUE('MSC_PUBLISH_SUPPLY_COMMIT'),'N') = 'N') THEN
752: OPEN supply_commits_c1 (
753: p_plan_id
754: ,p_org_id
755: ,p_sr_instance_id

Line 875: print_debug_info('Used Supply_commits_cursor2 as the value of the profile is ' || FND_PROFILE.VALUE('MSC_PUBLISH_SUPPLY_COMMIT'));

871: ,t_src_cust_site_id
872: ,t_src_org_id
873: ,t_src_instance_id;
874: CLOSE supply_commits_c2;
875: print_debug_info('Used Supply_commits_cursor2 as the value of the profile is ' || FND_PROFILE.VALUE('MSC_PUBLISH_SUPPLY_COMMIT'));
876: END IF;
877: -- End of bug#6345381 changes
878: IF t_pub IS NOT NULL AND t_pub.COUNT > 0 THEN
879: print_debug_info('Records fetched by cursor := ' || t_pub.COUNT);

Line 1033: IF ( ( FND_PROFILE.VALUE('MSC_X_AUTO_SCEM_MODE') = 2

1029:
1030:
1031:
1032: -- launch SCEM engine
1033: IF ( ( FND_PROFILE.VALUE('MSC_X_AUTO_SCEM_MODE') = 2
1034: OR FND_PROFILE.VALUE('MSC_X_AUTO_SCEM_MODE') = 3
1035: ) -- PUBLISH or ALL
1036: AND ( FND_PROFILE.VALUE('MSC_X_CONFIGURATION') = 2
1037: OR FND_PROFILE.VALUE('MSC_X_CONFIGURATION') = 3

Line 1034: OR FND_PROFILE.VALUE('MSC_X_AUTO_SCEM_MODE') = 3

1030:
1031:
1032: -- launch SCEM engine
1033: IF ( ( FND_PROFILE.VALUE('MSC_X_AUTO_SCEM_MODE') = 2
1034: OR FND_PROFILE.VALUE('MSC_X_AUTO_SCEM_MODE') = 3
1035: ) -- PUBLISH or ALL
1036: AND ( FND_PROFILE.VALUE('MSC_X_CONFIGURATION') = 2
1037: OR FND_PROFILE.VALUE('MSC_X_CONFIGURATION') = 3
1038: ) -- APS+CP or CP

Line 1036: AND ( FND_PROFILE.VALUE('MSC_X_CONFIGURATION') = 2

1032: -- launch SCEM engine
1033: IF ( ( FND_PROFILE.VALUE('MSC_X_AUTO_SCEM_MODE') = 2
1034: OR FND_PROFILE.VALUE('MSC_X_AUTO_SCEM_MODE') = 3
1035: ) -- PUBLISH or ALL
1036: AND ( FND_PROFILE.VALUE('MSC_X_CONFIGURATION') = 2
1037: OR FND_PROFILE.VALUE('MSC_X_CONFIGURATION') = 3
1038: ) -- APS+CP or CP
1039: ) THEN
1040: BEGIN

Line 1037: OR FND_PROFILE.VALUE('MSC_X_CONFIGURATION') = 3

1033: IF ( ( FND_PROFILE.VALUE('MSC_X_AUTO_SCEM_MODE') = 2
1034: OR FND_PROFILE.VALUE('MSC_X_AUTO_SCEM_MODE') = 3
1035: ) -- PUBLISH or ALL
1036: AND ( FND_PROFILE.VALUE('MSC_X_CONFIGURATION') = 2
1037: OR FND_PROFILE.VALUE('MSC_X_CONFIGURATION') = 3
1038: ) -- APS+CP or CP
1039: ) THEN
1040: BEGIN
1041: MSC_SCE_LOADS_PKG.LOG_MESSAGE('Launching SCEM engine');

Line 1591: g_msc_cp_debug VARCHAR2(10) := NVL(FND_PROFILE.VALUE('MSC_CP_DEBUG'), '0');

1587: PROCEDURE print_debug_info(
1588: p_debug_info IN VARCHAR2
1589: )IS
1590:
1591: g_msc_cp_debug VARCHAR2(10) := NVL(FND_PROFILE.VALUE('MSC_CP_DEBUG'), '0');
1592:
1593: BEGIN
1594: IF ( g_msc_cp_debug= '1' OR g_msc_cp_debug = '2') THEN
1595: FND_FILE.PUT_LINE(FND_FILE.LOG, p_debug_info);