APPS.MSC_SCE_PUB_SUPPLY_COMMIT_PKG dependencies on FND_PROFILE

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

774:
775: -- bug#6345381
776: -- dejoshi
777:
778: IF (nvl(FND_PROFILE.VALUE('MSC_PUBLISH_SUPPLY_COMMIT'),'N') = 'N') THEN
779: OPEN supply_commits_c1 (
780: p_plan_id
781: ,p_org_id
782: ,p_sr_instance_id

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

898: ,t_src_cust_site_id
899: ,t_src_org_id
900: ,t_src_instance_id;
901: CLOSE supply_commits_c2;
902: print_debug_info('Used Supply_commits_cursor2 as the value of the profile is ' || FND_PROFILE.VALUE('MSC_PUBLISH_SUPPLY_COMMIT'));
903: END IF;
904: -- End of bug#6345381 changes
905: IF t_pub IS NOT NULL AND t_pub.COUNT > 0 THEN
906: print_debug_info('Records fetched by cursor := ' || t_pub.COUNT);

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

1056:
1057:
1058:
1059: -- launch SCEM engine
1060: IF ( ( FND_PROFILE.VALUE('MSC_X_AUTO_SCEM_MODE') = 2
1061: OR FND_PROFILE.VALUE('MSC_X_AUTO_SCEM_MODE') = 3
1062: ) -- PUBLISH or ALL
1063: AND ( FND_PROFILE.VALUE('MSC_X_CONFIGURATION') = 2
1064: OR FND_PROFILE.VALUE('MSC_X_CONFIGURATION') = 3

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

1057:
1058:
1059: -- launch SCEM engine
1060: IF ( ( FND_PROFILE.VALUE('MSC_X_AUTO_SCEM_MODE') = 2
1061: OR FND_PROFILE.VALUE('MSC_X_AUTO_SCEM_MODE') = 3
1062: ) -- PUBLISH or ALL
1063: AND ( FND_PROFILE.VALUE('MSC_X_CONFIGURATION') = 2
1064: OR FND_PROFILE.VALUE('MSC_X_CONFIGURATION') = 3
1065: ) -- APS+CP or CP

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

1059: -- launch SCEM engine
1060: IF ( ( FND_PROFILE.VALUE('MSC_X_AUTO_SCEM_MODE') = 2
1061: OR FND_PROFILE.VALUE('MSC_X_AUTO_SCEM_MODE') = 3
1062: ) -- PUBLISH or ALL
1063: AND ( FND_PROFILE.VALUE('MSC_X_CONFIGURATION') = 2
1064: OR FND_PROFILE.VALUE('MSC_X_CONFIGURATION') = 3
1065: ) -- APS+CP or CP
1066: ) THEN
1067: BEGIN

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

1060: IF ( ( FND_PROFILE.VALUE('MSC_X_AUTO_SCEM_MODE') = 2
1061: OR FND_PROFILE.VALUE('MSC_X_AUTO_SCEM_MODE') = 3
1062: ) -- PUBLISH or ALL
1063: AND ( FND_PROFILE.VALUE('MSC_X_CONFIGURATION') = 2
1064: OR FND_PROFILE.VALUE('MSC_X_CONFIGURATION') = 3
1065: ) -- APS+CP or CP
1066: ) THEN
1067: BEGIN
1068: MSC_SCE_LOADS_PKG.LOG_MESSAGE('Launching SCEM engine');

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

1624: PROCEDURE print_debug_info(
1625: p_debug_info IN VARCHAR2
1626: )IS
1627:
1628: g_msc_cp_debug VARCHAR2(10) := NVL(FND_PROFILE.VALUE('MSC_CP_DEBUG'), '0');
1629:
1630: BEGIN
1631: IF ( g_msc_cp_debug= '1' OR g_msc_cp_debug = '2') THEN
1632: FND_FILE.PUT_LINE(FND_FILE.LOG, p_debug_info);