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

574: BEGIN
575: p_retcode := G_SUCCESS;
576: print_debug_info('Just entered publish_supply_commits:');
577:
578: if fnd_global.conc_request_id > 0 then
579: select
580: fnd_global.user_id ,
581: fnd_global.user_name --,
582: --fnd_global.resp_name,

Line 580: fnd_global.user_id ,

576: print_debug_info('Just entered publish_supply_commits:');
577:
578: if fnd_global.conc_request_id > 0 then
579: select
580: fnd_global.user_id ,
581: fnd_global.user_name --,
582: --fnd_global.resp_name,
583: --fnd_global.application_name
584: into l_user_id,

Line 581: fnd_global.user_name --,

577:
578: if fnd_global.conc_request_id > 0 then
579: select
580: fnd_global.user_id ,
581: fnd_global.user_name --,
582: --fnd_global.resp_name,
583: --fnd_global.application_name
584: into l_user_id,
585: l_user_name --,

Line 582: --fnd_global.resp_name,

578: if fnd_global.conc_request_id > 0 then
579: select
580: fnd_global.user_id ,
581: fnd_global.user_name --,
582: --fnd_global.resp_name,
583: --fnd_global.application_name
584: into l_user_id,
585: l_user_name --,
586: --l_resp_name,

Line 583: --fnd_global.application_name

579: select
580: fnd_global.user_id ,
581: fnd_global.user_name --,
582: --fnd_global.resp_name,
583: --fnd_global.application_name
584: into l_user_id,
585: l_user_name --,
586: --l_resp_name,
587: --l_application_name

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

678: else
679: l_version := null;
680: end if;
681:
682: l_log_message := get_message('MSC','MSC_X_PUB_SC',l_language_code) || ' ' || fnd_global.local_chr(10) ||
683: get_message('MSC','MSC_X_PUB_PLAN',l_language_code) || ': ' || p_designator || fnd_global.local_chr(10);
684:
685: IF p_org_code IS NOT NULL THEN
686: 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 683: get_message('MSC','MSC_X_PUB_PLAN',l_language_code) || ': ' || p_designator || fnd_global.local_chr(10);

679: l_version := null;
680: end if;
681:
682: l_log_message := get_message('MSC','MSC_X_PUB_SC',l_language_code) || ' ' || fnd_global.local_chr(10) ||
683: get_message('MSC','MSC_X_PUB_PLAN',l_language_code) || ': ' || p_designator || fnd_global.local_chr(10);
684:
685: IF p_org_code IS NOT NULL THEN
686: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_ORG',l_language_code) || ': ' || p_org_code || fnd_global.local_chr(10);
687: END IF;

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

682: l_log_message := get_message('MSC','MSC_X_PUB_SC',l_language_code) || ' ' || fnd_global.local_chr(10) ||
683: get_message('MSC','MSC_X_PUB_PLAN',l_language_code) || ': ' || p_designator || fnd_global.local_chr(10);
684:
685: IF p_org_code IS NOT NULL THEN
686: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_ORG',l_language_code) || ': ' || p_org_code || fnd_global.local_chr(10);
687: END IF;
688:
689: IF p_item_id IS NOT NULL THEN
690: SELECT item_name

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

690: SELECT item_name
691: INTO l_item_name
692: FROM msc_items
693: WHERE inventory_item_id = p_item_id;
694: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_ITEM',l_language_code) || ': ' || l_item_name || fnd_global.local_chr(10);
695: END IF;
696:
697: IF p_source_customer_id IS NOT NULL THEN
698: SELECT partner_name

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

698: SELECT partner_name
699: INTO l_cust_name
700: FROM msc_trading_partners
701: WHERE partner_id = p_source_customer_id;
702: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_CUSTOMER',l_language_code) || ': ' || l_cust_name || fnd_global.local_chr(10);
703: END IF;
704:
705: IF p_source_customer_site_id IS NOT NULL THEN
706: SELECT location

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

708: FROM msc_trading_partner_sites
709: WHERE partner_id = p_source_customer_id
710: AND partner_site_id = p_source_customer_site_id
711: AND tp_site_code = 'SHIP_TO';
712: 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);
713: END IF;
714:
715: --------------------------------------------------------------------------
716: -- set the standard date as canonical date

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

719: l_horizon_end := fnd_date.canonical_to_date(p_horizon_end);
720:
721:
722: IF p_planner_code IS NOT NULL THEN
723: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_PLANNER',l_language_code) || ': ' || p_planner_code || fnd_global.local_chr(10);
724: END IF;
725:
726: IF p_planning_gp IS NOT NULL THEN
727: 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 727: 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);

723: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_PLANNER',l_language_code) || ': ' || p_planner_code || fnd_global.local_chr(10);
724: END IF;
725:
726: IF p_planning_gp IS NOT NULL THEN
727: 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);
728: END IF;
729:
730: IF p_project_id IS NOT NULL THEN
731: 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 731: 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);

727: 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);
728: END IF;
729:
730: IF p_project_id IS NOT NULL THEN
731: 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);
732: END IF;
733:
734: IF p_task_id IS NOT NULL THEN
735: 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 735: 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);

731: 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);
732: END IF;
733:
734: IF p_task_id IS NOT NULL THEN
735: 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);
736: END IF;
737:
738: IF p_abc_class IS NOT NULL THEN
739: 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 739: 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);

735: 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);
736: END IF;
737:
738: IF p_abc_class IS NOT NULL THEN
739: 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);
740: END IF;
741: log_message(l_log_message);
742:
743: l_log_message := get_message('MSC','MSC_X_PUB_DEL_SC',l_language_code) || fnd_global.local_chr(10);

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

739: 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);
740: END IF;
741: log_message(l_log_message);
742:
743: l_log_message := get_message('MSC','MSC_X_PUB_DEL_SC',l_language_code) || fnd_global.local_chr(10);
744: log_message(l_log_message);
745:
746: delete_old_forecast(
747: p_plan_id,

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

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);
907: l_log_message := get_message('MSC','MSC_X_PUB_NUM_RECORDS',l_language_code) || ': ' || t_pub.COUNT || '.' || fnd_global.local_chr(10);
908: log_message(l_log_message);
909:
910: get_optional_info(
911: t_item_id,

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

996: commit;
997:
998:
999: IF l_cursor1 = 0 THEN
1000: l_log_message := get_message('MSC','MSC_X_PUB_NUM_RECORDS',l_language_code) || ': ' || 0 || '.' || fnd_global.local_chr(10);
1001: log_message(l_log_message);
1002: END IF;
1003:
1004: IF l_version IS NOT NULL THEN

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

1016: WHEN OTHERS then
1017: l_records_exist := 0;
1018: END;
1019: IF l_records_exist = 1 then
1020: l_log_message := get_message('MSC','MSC_X_PUB_NEW_VERSION_SC',l_language_code) || ' ' || l_version || '.' || fnd_global.local_chr(10);
1021: log_message(l_log_message);
1022:
1023: --update version number in msc_plans
1024:

Line 1591: IF fnd_global.conc_request_id > 0 THEN

1587: PROCEDURE LOG_MESSAGE(
1588: p_string IN VARCHAR2
1589: ) IS
1590: BEGIN
1591: IF fnd_global.conc_request_id > 0 THEN
1592: FND_FILE.PUT_LINE(FND_FILE.LOG, p_string);
1593: ELSE
1594: --DBMS_OUTPUT.PUT_LINE( p_string);
1595: null;