eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_PUBLISH_SAFETY_STOCK_PKG dependencies on FND_GLOBAL

Line 979: if fnd_global.conc_request_id > 0 then

975: i_bkt_index := numberList();
976: i_bkt_type := numberList();
977:
978:
979: if fnd_global.conc_request_id > 0 then
980:
981: p_retcode := 0 ; -- Bug 4560452
982: p_errbuf := null ;
983:

Line 985: fnd_global.user_id,

981: p_retcode := 0 ; -- Bug 4560452
982: p_errbuf := null ;
983:
984: select
985: fnd_global.user_id,
986: fnd_global.user_name --,
987: --fnd_global.resp_name,
988: --fnd_global.application_name
989: into l_user_id,

Line 986: fnd_global.user_name --,

982: p_errbuf := null ;
983:
984: select
985: fnd_global.user_id,
986: fnd_global.user_name --,
987: --fnd_global.resp_name,
988: --fnd_global.application_name
989: into l_user_id,
990: l_user_name --,

Line 987: --fnd_global.resp_name,

983:
984: select
985: fnd_global.user_id,
986: fnd_global.user_name --,
987: --fnd_global.resp_name,
988: --fnd_global.application_name
989: into l_user_id,
990: l_user_name --,
991: --l_resp_name,

Line 988: --fnd_global.application_name

984: select
985: fnd_global.user_id,
986: fnd_global.user_name --,
987: --fnd_global.resp_name,
988: --fnd_global.application_name
989: into l_user_id,
990: l_user_name --,
991: --l_resp_name,
992: --l_application_name

Line 1073: l_log_message := get_message('MSC','MSC_PUB_SS',l_language_code) || ' ' || fnd_global.local_chr(10) ||

1069: log_message('l_horizon_end: '||l_horizon_end);
1070:
1071:
1072:
1073: l_log_message := get_message('MSC','MSC_PUB_SS',l_language_code) || ' ' || fnd_global.local_chr(10) ||
1074: get_message('MSC','MSC_X_PUB_PLAN',l_language_code) || ': ' || p_designator || fnd_global.local_chr(10);
1075:
1076:
1077: if (l_horizon_start > l_horizon_end) THEN

Line 1074: get_message('MSC','MSC_X_PUB_PLAN',l_language_code) || ': ' || p_designator || fnd_global.local_chr(10);

1070:
1071:
1072:
1073: l_log_message := get_message('MSC','MSC_PUB_SS',l_language_code) || ' ' || fnd_global.local_chr(10) ||
1074: get_message('MSC','MSC_X_PUB_PLAN',l_language_code) || ': ' || p_designator || fnd_global.local_chr(10);
1075:
1076:
1077: if (l_horizon_start > l_horizon_end) THEN
1078: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_START_DATE',l_language_code) || ' ' || l_horizon_start || fnd_global.local_chr(10);

Line 1078: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_START_DATE',l_language_code) || ' ' || l_horizon_start || fnd_global.local_chr(10);

1074: get_message('MSC','MSC_X_PUB_PLAN',l_language_code) || ': ' || p_designator || fnd_global.local_chr(10);
1075:
1076:
1077: if (l_horizon_start > l_horizon_end) THEN
1078: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_START_DATE',l_language_code) || ' ' || l_horizon_start || fnd_global.local_chr(10);
1079: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_END_DATE',l_language_code) || ' ' || l_horizon_end || fnd_global.local_chr(10);
1080: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_DATE_MISMATCH',l_language_code) || ' ' || fnd_global.local_chr(10);
1081: log_message(l_log_message);
1082: RETURN;

Line 1079: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_END_DATE',l_language_code) || ' ' || l_horizon_end || fnd_global.local_chr(10);

1075:
1076:
1077: if (l_horizon_start > l_horizon_end) THEN
1078: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_START_DATE',l_language_code) || ' ' || l_horizon_start || fnd_global.local_chr(10);
1079: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_END_DATE',l_language_code) || ' ' || l_horizon_end || fnd_global.local_chr(10);
1080: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_DATE_MISMATCH',l_language_code) || ' ' || fnd_global.local_chr(10);
1081: log_message(l_log_message);
1082: RETURN;
1083:

Line 1080: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_DATE_MISMATCH',l_language_code) || ' ' || fnd_global.local_chr(10);

1076:
1077: if (l_horizon_start > l_horizon_end) THEN
1078: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_START_DATE',l_language_code) || ' ' || l_horizon_start || fnd_global.local_chr(10);
1079: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_END_DATE',l_language_code) || ' ' || l_horizon_end || fnd_global.local_chr(10);
1080: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_DATE_MISMATCH',l_language_code) || ' ' || fnd_global.local_chr(10);
1081: log_message(l_log_message);
1082: RETURN;
1083:
1084: END IF;

Line 1087: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_ORG',l_language_code) || ': ' || p_org_code || fnd_global.local_chr(10);

1083:
1084: END IF;
1085:
1086: IF p_org_code IS NOT NULL THEN
1087: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_ORG',l_language_code) || ': ' || p_org_code || fnd_global.local_chr(10);
1088: END IF;
1089:
1090:
1091: IF p_item_id IS NOT NULL THEN

Line 1096: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_ITEM',l_language_code) || ': ' || l_item_name || fnd_global.local_chr(10);

1092: SELECT item_name
1093: INTO l_item_name
1094: FROM msc_items
1095: WHERE inventory_item_id = p_item_id;
1096: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_ITEM',l_language_code) || ': ' || l_item_name || fnd_global.local_chr(10);
1097: END IF;
1098:
1099: IF p_supplier_id IS NOT NULL THEN
1100: SELECT partner_name

Line 1104: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_SUPPLIER',l_language_code) || ': ' || l_supp_name || fnd_global.local_chr(10);

1100: SELECT partner_name
1101: INTO l_supp_name
1102: FROM msc_trading_partners
1103: WHERE partner_id = p_supplier_id;
1104: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_SUPPLIER',l_language_code) || ': ' || l_supp_name || fnd_global.local_chr(10);
1105: END IF;
1106:
1107: IF p_supplier_site_id IS NOT NULL THEN
1108: SELECT tp_site_code

Line 1113: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_SUPP_SITE',l_language_code) || ': ' || l_supp_site || fnd_global.local_chr(10);

1109: INTO l_supp_site
1110: FROM msc_trading_partner_sites
1111: WHERE partner_id = p_supplier_id
1112: AND partner_site_id = p_supplier_site_id;
1113: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_SUPP_SITE',l_language_code) || ': ' || l_supp_site || fnd_global.local_chr(10);
1114:
1115: END IF;
1116:
1117: IF p_planner_code IS NOT NULL THEN

Line 1118: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_PLANNER',l_language_code) || ': ' || p_planner_code || fnd_global.local_chr(10);

1114:
1115: END IF;
1116:
1117: IF p_planner_code IS NOT NULL THEN
1118: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_PLANNER',l_language_code) || ': ' || p_planner_code || fnd_global.local_chr(10);
1119: END IF;
1120:
1121: IF p_planning_gp IS NOT NULL THEN
1122: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_PLAN_GP',l_language_code) || ': ' || p_planning_gp || fnd_global.local_chr(10);

Line 1122: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_PLAN_GP',l_language_code) || ': ' || p_planning_gp || fnd_global.local_chr(10);

1118: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_PLANNER',l_language_code) || ': ' || p_planner_code || fnd_global.local_chr(10);
1119: END IF;
1120:
1121: IF p_planning_gp IS NOT NULL THEN
1122: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_PLAN_GP',l_language_code) || ': ' || p_planning_gp || fnd_global.local_chr(10);
1123: END IF;
1124:
1125: IF p_project_id IS NOT NULL THEN
1126: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_PROJ_NUM',l_language_code) || ': ' || p_project_id || fnd_global.local_chr(10);

Line 1126: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_PROJ_NUM',l_language_code) || ': ' || p_project_id || fnd_global.local_chr(10);

1122: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_PLAN_GP',l_language_code) || ': ' || p_planning_gp || fnd_global.local_chr(10);
1123: END IF;
1124:
1125: IF p_project_id IS NOT NULL THEN
1126: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_PROJ_NUM',l_language_code) || ': ' || p_project_id || fnd_global.local_chr(10);
1127: END IF;
1128:
1129: IF p_task_id IS NOT NULL THEN
1130: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_TASK_NUM',l_language_code) || ': ' || p_task_id || fnd_global.local_chr(10);

Line 1130: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_TASK_NUM',l_language_code) || ': ' || p_task_id || fnd_global.local_chr(10);

1126: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_PROJ_NUM',l_language_code) || ': ' || p_project_id || fnd_global.local_chr(10);
1127: END IF;
1128:
1129: IF p_task_id IS NOT NULL THEN
1130: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_TASK_NUM',l_language_code) || ': ' || p_task_id || fnd_global.local_chr(10);
1131: END IF;
1132:
1133: IF p_abc_class IS NOT NULL THEN
1134: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_ABC_CLASS',l_language_code) || ': ' || p_abc_class || fnd_global.local_chr(10);

Line 1134: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_ABC_CLASS',l_language_code) || ': ' || p_abc_class || fnd_global.local_chr(10);

1130: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_TASK_NUM',l_language_code) || ': ' || p_task_id || fnd_global.local_chr(10);
1131: END IF;
1132:
1133: IF p_abc_class IS NOT NULL THEN
1134: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_ABC_CLASS',l_language_code) || ': ' || p_abc_class || fnd_global.local_chr(10);
1135: END IF;
1136: log_message(l_log_message);
1137:
1138:

Line 1433: --l_log_message := get_message('MSC','MSC_X_PUB_NUM_RECORDS',l_language_code) || ': ' || 0 || '.' || fnd_global.local_chr(10);

1429: END IF;
1430: commit;
1431:
1432: IF l_cursor1 = 0 THEN
1433: --l_log_message := get_message('MSC','MSC_X_PUB_NUM_RECORDS',l_language_code) || ': ' || 0 || '.' || fnd_global.local_chr(10);
1434: --log_message(l_log_message);
1435: null;
1436: END IF;
1437:

Line 1453: l_log_message := get_message('MSC','MSC_X_PUB_NEW_VERSION',l_language_code) || ' ' || l_version || '.' || fnd_global.local_chr(10);

1449: WHEN OTHERS then
1450: l_records_exist := 0;
1451: END;
1452: IF l_records_exist = 1 then
1453: l_log_message := get_message('MSC','MSC_X_PUB_NEW_VERSION',l_language_code) || ' ' || l_version || '.' || fnd_global.local_chr(10);
1454: log_message(l_log_message);
1455: END IF;
1456: END IF;
1457:

Line 1973: --': ' || t_pub_id.COUNT || '.' || fnd_global.local_chr(10);

1969:
1970: --dbms_output.put_line('Type ' || p_type || ' and count ' || t_pub_id.COUNT);
1971: IF (t_pub_id is not null and t_pub_id.COUNT >0 and p_type = SAFETY_STOCK ) THEN
1972: --l_log_message := get_message('MSC','MSC_X_PUB_NUM_RECORDS',p_language_code) ||
1973: --': ' || t_pub_id.COUNT || '.' || fnd_global.local_chr(10);
1974: --log_message(l_log_message);
1975: -----------------------------------------------------
1976:
1977: FOR j in 1..t_pub_id.COUNT LOOP

Line 3373: IF fnd_global.conc_request_id > 0 THEN

3369: PROCEDURE LOG_MESSAGE(
3370: p_string IN VARCHAR2
3371: ) IS
3372: BEGIN
3373: IF fnd_global.conc_request_id > 0 THEN
3374: FND_FILE.PUT_LINE(FND_FILE.LOG, p_string);
3375: NULL;
3376: ELSE
3377: --dbms_OUTPUT.PUT_LINE( p_string);