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 982: if fnd_global.conc_request_id > 0 then

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

Line 988: fnd_global.user_id,

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

Line 989: fnd_global.user_name --,

985: p_errbuf := null ;
986:
987: select
988: fnd_global.user_id,
989: fnd_global.user_name --,
990: --fnd_global.resp_name,
991: --fnd_global.application_name
992: into l_user_id,
993: l_user_name --,

Line 990: --fnd_global.resp_name,

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

Line 991: --fnd_global.application_name

987: select
988: fnd_global.user_id,
989: fnd_global.user_name --,
990: --fnd_global.resp_name,
991: --fnd_global.application_name
992: into l_user_id,
993: l_user_name --,
994: --l_resp_name,
995: --l_application_name

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

1085: log_message('l_horizon_end: '||l_horizon_end);
1086:
1087:
1088:
1089: l_log_message := get_message('MSC','MSC_PUB_SS',l_language_code) || ' ' || fnd_global.local_chr(10) ||
1090: get_message('MSC','MSC_X_PUB_PLAN',l_language_code) || ': ' || p_designator || fnd_global.local_chr(10);
1091:
1092:
1093: if (l_horizon_start > l_horizon_end) THEN

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

1086:
1087:
1088:
1089: l_log_message := get_message('MSC','MSC_PUB_SS',l_language_code) || ' ' || fnd_global.local_chr(10) ||
1090: get_message('MSC','MSC_X_PUB_PLAN',l_language_code) || ': ' || p_designator || fnd_global.local_chr(10);
1091:
1092:
1093: if (l_horizon_start > l_horizon_end) THEN
1094: 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 1094: 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);

1090: get_message('MSC','MSC_X_PUB_PLAN',l_language_code) || ': ' || p_designator || fnd_global.local_chr(10);
1091:
1092:
1093: if (l_horizon_start > l_horizon_end) THEN
1094: 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);
1095: 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);
1096: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_DATE_MISMATCH',l_language_code) || ' ' || fnd_global.local_chr(10);
1097: log_message(l_log_message);
1098: RETURN;

Line 1095: 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);

1091:
1092:
1093: if (l_horizon_start > l_horizon_end) THEN
1094: 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);
1095: 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);
1096: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_DATE_MISMATCH',l_language_code) || ' ' || fnd_global.local_chr(10);
1097: log_message(l_log_message);
1098: RETURN;
1099:

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

1092:
1093: if (l_horizon_start > l_horizon_end) THEN
1094: 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);
1095: 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);
1096: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_DATE_MISMATCH',l_language_code) || ' ' || fnd_global.local_chr(10);
1097: log_message(l_log_message);
1098: RETURN;
1099:
1100: END IF;

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

1099:
1100: END IF;
1101:
1102: IF p_org_code IS NOT NULL THEN
1103: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_ORG',l_language_code) || ': ' || p_org_code || fnd_global.local_chr(10);
1104: END IF;
1105:
1106:
1107: IF p_item_id IS NOT NULL THEN

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

1108: SELECT item_name
1109: INTO l_item_name
1110: FROM msc_items
1111: WHERE inventory_item_id = p_item_id;
1112: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_ITEM',l_language_code) || ': ' || l_item_name || fnd_global.local_chr(10);
1113: END IF;
1114:
1115: IF p_supplier_id IS NOT NULL THEN
1116: SELECT partner_name

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

1116: SELECT partner_name
1117: INTO l_supp_name
1118: FROM msc_trading_partners
1119: WHERE partner_id = p_supplier_id;
1120: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_SUPPLIER',l_language_code) || ': ' || l_supp_name || fnd_global.local_chr(10);
1121: END IF;
1122:
1123: IF p_supplier_site_id IS NOT NULL THEN
1124: SELECT tp_site_code

Line 1129: 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);

1125: INTO l_supp_site
1126: FROM msc_trading_partner_sites
1127: WHERE partner_id = p_supplier_id
1128: AND partner_site_id = p_supplier_site_id;
1129: 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);
1130:
1131: END IF;
1132:
1133: IF p_planner_code IS NOT NULL THEN

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

1130:
1131: END IF;
1132:
1133: IF p_planner_code IS NOT NULL THEN
1134: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_PLANNER',l_language_code) || ': ' || p_planner_code || fnd_global.local_chr(10);
1135: END IF;
1136:
1137: IF p_planning_gp IS NOT NULL THEN
1138: 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 1138: 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);

1134: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_PLANNER',l_language_code) || ': ' || p_planner_code || fnd_global.local_chr(10);
1135: END IF;
1136:
1137: IF p_planning_gp IS NOT NULL THEN
1138: 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);
1139: END IF;
1140:
1141: IF p_project_id IS NOT NULL THEN
1142: 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 1142: 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);

1138: 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);
1139: END IF;
1140:
1141: IF p_project_id IS NOT NULL THEN
1142: 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);
1143: END IF;
1144:
1145: IF p_task_id IS NOT NULL THEN
1146: 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 1146: 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);

1142: 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);
1143: END IF;
1144:
1145: IF p_task_id IS NOT NULL THEN
1146: 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);
1147: END IF;
1148:
1149: IF p_abc_class IS NOT NULL THEN
1150: 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 1150: 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);

1146: 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);
1147: END IF;
1148:
1149: IF p_abc_class IS NOT NULL THEN
1150: 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);
1151: END IF;
1152: log_message(l_log_message);
1153:
1154:

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

1445: END IF;
1446: commit;
1447:
1448: IF l_cursor1 = 0 THEN
1449: --l_log_message := get_message('MSC','MSC_X_PUB_NUM_RECORDS',l_language_code) || ': ' || 0 || '.' || fnd_global.local_chr(10);
1450: --log_message(l_log_message);
1451: null;
1452: END IF;
1453:

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

1465: WHEN OTHERS then
1466: l_records_exist := 0;
1467: END;
1468: IF l_records_exist = 1 then
1469: l_log_message := get_message('MSC','MSC_X_PUB_NEW_VERSION',l_language_code) || ' ' || l_version || '.' || fnd_global.local_chr(10);
1470: log_message(l_log_message);
1471: END IF;
1472: END IF;
1473:

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

1985:
1986: --dbms_output.put_line('Type ' || p_type || ' and count ' || t_pub_id.COUNT);
1987: IF (t_pub_id is not null and t_pub_id.COUNT >0 and p_type = SAFETY_STOCK ) THEN
1988: --l_log_message := get_message('MSC','MSC_X_PUB_NUM_RECORDS',p_language_code) ||
1989: --': ' || t_pub_id.COUNT || '.' || fnd_global.local_chr(10);
1990: --log_message(l_log_message);
1991: -----------------------------------------------------
1992:
1993: FOR j in 1..t_pub_id.COUNT LOOP

Line 3389: IF fnd_global.conc_request_id > 0 THEN

3385: PROCEDURE LOG_MESSAGE(
3386: p_string IN VARCHAR2
3387: ) IS
3388: BEGIN
3389: IF fnd_global.conc_request_id > 0 THEN
3390: FND_FILE.PUT_LINE(FND_FILE.LOG, p_string);
3391: NULL;
3392: ELSE
3393: --dbms_OUTPUT.PUT_LINE( p_string);