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_SCE_PUB_SUPPLY_COMMIT_PKG dependencies on FND_GLOBAL

Line 568: if fnd_global.conc_request_id > 0 then

564: ;
565: BEGIN
566: print_debug_info('Just entered publish_supply_commits:');
567:
568: if fnd_global.conc_request_id > 0 then
569: select
570: fnd_global.user_id ,
571: fnd_global.user_name --,
572: --fnd_global.resp_name,

Line 570: fnd_global.user_id ,

566: print_debug_info('Just entered publish_supply_commits:');
567:
568: if fnd_global.conc_request_id > 0 then
569: select
570: fnd_global.user_id ,
571: fnd_global.user_name --,
572: --fnd_global.resp_name,
573: --fnd_global.application_name
574: into l_user_id,

Line 571: fnd_global.user_name --,

567:
568: if fnd_global.conc_request_id > 0 then
569: select
570: fnd_global.user_id ,
571: fnd_global.user_name --,
572: --fnd_global.resp_name,
573: --fnd_global.application_name
574: into l_user_id,
575: l_user_name --,

Line 572: --fnd_global.resp_name,

568: if fnd_global.conc_request_id > 0 then
569: select
570: fnd_global.user_id ,
571: fnd_global.user_name --,
572: --fnd_global.resp_name,
573: --fnd_global.application_name
574: into l_user_id,
575: l_user_name --,
576: --l_resp_name,

Line 573: --fnd_global.application_name

569: select
570: fnd_global.user_id ,
571: fnd_global.user_name --,
572: --fnd_global.resp_name,
573: --fnd_global.application_name
574: into l_user_id,
575: l_user_name --,
576: --l_resp_name,
577: --l_application_name

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

651: else
652: l_version := null;
653: end if;
654:
655: l_log_message := get_message('MSC','MSC_X_PUB_SC',l_language_code) || ' ' || fnd_global.local_chr(10) ||
656: get_message('MSC','MSC_X_PUB_PLAN',l_language_code) || ': ' || p_designator || fnd_global.local_chr(10);
657:
658: IF p_org_code IS NOT NULL THEN
659: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_ORG',l_language_code) || ': ' || p_org_code || fnd_global.local_chr(10);

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

652: l_version := null;
653: end if;
654:
655: l_log_message := get_message('MSC','MSC_X_PUB_SC',l_language_code) || ' ' || fnd_global.local_chr(10) ||
656: get_message('MSC','MSC_X_PUB_PLAN',l_language_code) || ': ' || p_designator || fnd_global.local_chr(10);
657:
658: IF p_org_code IS NOT NULL THEN
659: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_ORG',l_language_code) || ': ' || p_org_code || fnd_global.local_chr(10);
660: END IF;

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

655: l_log_message := get_message('MSC','MSC_X_PUB_SC',l_language_code) || ' ' || fnd_global.local_chr(10) ||
656: get_message('MSC','MSC_X_PUB_PLAN',l_language_code) || ': ' || p_designator || fnd_global.local_chr(10);
657:
658: IF p_org_code IS NOT NULL THEN
659: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_ORG',l_language_code) || ': ' || p_org_code || fnd_global.local_chr(10);
660: END IF;
661:
662: IF p_item_id IS NOT NULL THEN
663: SELECT item_name

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

663: SELECT item_name
664: INTO l_item_name
665: FROM msc_items
666: WHERE inventory_item_id = p_item_id;
667: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_ITEM',l_language_code) || ': ' || l_item_name || fnd_global.local_chr(10);
668: END IF;
669:
670: IF p_source_customer_id IS NOT NULL THEN
671: SELECT partner_name

Line 675: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_CUSTOMER',l_language_code) || ': ' || l_cust_name || fnd_global.local_chr(10);

671: SELECT partner_name
672: INTO l_cust_name
673: FROM msc_trading_partners
674: WHERE partner_id = p_source_customer_id;
675: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_CUSTOMER',l_language_code) || ': ' || l_cust_name || fnd_global.local_chr(10);
676: END IF;
677:
678: IF p_source_customer_site_id IS NOT NULL THEN
679: SELECT location

Line 685: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_CUST_SITE',l_language_code) || ': ' || l_cust_site || fnd_global.local_chr(10);

681: FROM msc_trading_partner_sites
682: WHERE partner_id = p_source_customer_id
683: AND partner_site_id = p_source_customer_site_id
684: AND tp_site_code = 'SHIP_TO';
685: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_CUST_SITE',l_language_code) || ': ' || l_cust_site || fnd_global.local_chr(10);
686: END IF;
687:
688: --------------------------------------------------------------------------
689: -- set the standard date as canonical date

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

692: l_horizon_end := fnd_date.canonical_to_date(p_horizon_end);
693:
694:
695: IF p_planner_code IS NOT NULL THEN
696: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_PLANNER',l_language_code) || ': ' || p_planner_code || fnd_global.local_chr(10);
697: END IF;
698:
699: IF p_planning_gp IS NOT NULL THEN
700: 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 700: 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);

696: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_PLANNER',l_language_code) || ': ' || p_planner_code || fnd_global.local_chr(10);
697: END IF;
698:
699: IF p_planning_gp IS NOT NULL THEN
700: 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);
701: END IF;
702:
703: IF p_project_id IS NOT NULL THEN
704: 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 704: 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);

700: 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);
701: END IF;
702:
703: IF p_project_id IS NOT NULL THEN
704: 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);
705: END IF;
706:
707: IF p_task_id IS NOT NULL THEN
708: 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 708: 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);

704: 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);
705: END IF;
706:
707: IF p_task_id IS NOT NULL THEN
708: 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);
709: END IF;
710:
711: IF p_abc_class IS NOT NULL THEN
712: 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 712: 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);

708: 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);
709: END IF;
710:
711: IF p_abc_class IS NOT NULL THEN
712: 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);
713: END IF;
714: log_message(l_log_message);
715:
716: l_log_message := get_message('MSC','MSC_X_PUB_DEL_SC',l_language_code) || fnd_global.local_chr(10);

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

712: 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);
713: END IF;
714: log_message(l_log_message);
715:
716: l_log_message := get_message('MSC','MSC_X_PUB_DEL_SC',l_language_code) || fnd_global.local_chr(10);
717: log_message(l_log_message);
718:
719: delete_old_forecast(
720: p_plan_id,

Line 880: l_log_message := get_message('MSC','MSC_X_PUB_NUM_RECORDS',l_language_code) || ': ' || t_pub.COUNT || '.' || fnd_global.local_chr(10);

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);
880: l_log_message := get_message('MSC','MSC_X_PUB_NUM_RECORDS',l_language_code) || ': ' || t_pub.COUNT || '.' || fnd_global.local_chr(10);
881: log_message(l_log_message);
882:
883: get_optional_info(
884: t_item_id,

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

969: commit;
970:
971:
972: IF l_cursor1 = 0 THEN
973: l_log_message := get_message('MSC','MSC_X_PUB_NUM_RECORDS',l_language_code) || ': ' || 0 || '.' || fnd_global.local_chr(10);
974: log_message(l_log_message);
975: END IF;
976:
977: IF l_version IS NOT NULL THEN

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

989: WHEN OTHERS then
990: l_records_exist := 0;
991: END;
992: IF l_records_exist = 1 then
993: l_log_message := get_message('MSC','MSC_X_PUB_NEW_VERSION_SC',l_language_code) || ' ' || l_version || '.' || fnd_global.local_chr(10);
994: log_message(l_log_message);
995:
996: --update version number in msc_plans
997:

Line 1554: IF fnd_global.conc_request_id > 0 THEN

1550: PROCEDURE LOG_MESSAGE(
1551: p_string IN VARCHAR2
1552: ) IS
1553: BEGIN
1554: IF fnd_global.conc_request_id > 0 THEN
1555: FND_FILE.PUT_LINE(FND_FILE.LOG, p_string);
1556: ELSE
1557: --DBMS_OUTPUT.PUT_LINE( p_string);
1558: null;