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

Line 602: if fnd_global.conc_request_id > 0 then

598:
599:
600: BEGIN
601:
602: if fnd_global.conc_request_id > 0 then
603: select
604: fnd_global.user_id,
605: fnd_global.user_name --,
606: --fnd_global.resp_name,

Line 604: fnd_global.user_id,

600: BEGIN
601:
602: if fnd_global.conc_request_id > 0 then
603: select
604: fnd_global.user_id,
605: fnd_global.user_name --,
606: --fnd_global.resp_name,
607: --fnd_global.application_name
608: into l_user_id,

Line 605: fnd_global.user_name --,

601:
602: if fnd_global.conc_request_id > 0 then
603: select
604: fnd_global.user_id,
605: fnd_global.user_name --,
606: --fnd_global.resp_name,
607: --fnd_global.application_name
608: into l_user_id,
609: l_user_name --,

Line 606: --fnd_global.resp_name,

602: if fnd_global.conc_request_id > 0 then
603: select
604: fnd_global.user_id,
605: fnd_global.user_name --,
606: --fnd_global.resp_name,
607: --fnd_global.application_name
608: into l_user_id,
609: l_user_name --,
610: --l_resp_name,

Line 607: --fnd_global.application_name

603: select
604: fnd_global.user_id,
605: fnd_global.user_name --,
606: --fnd_global.resp_name,
607: --fnd_global.application_name
608: into l_user_id,
609: l_user_name --,
610: --l_resp_name,
611: --l_application_name

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

671: else
672: l_version := null;
673: end if;
674:
675: l_log_message := get_message('MSC','MSC_X_PUB_OF',l_language_code) || ' ' || fnd_global.local_chr(10) ||
676: get_message('MSC','MSC_X_PUB_PLAN',l_language_code) || ': ' || p_designator || fnd_global.local_chr(10);
677:
678: IF p_org_code IS NOT NULL THEN
679: 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 676: get_message('MSC','MSC_X_PUB_PLAN',l_language_code) || ': ' || p_designator || fnd_global.local_chr(10);

672: l_version := null;
673: end if;
674:
675: l_log_message := get_message('MSC','MSC_X_PUB_OF',l_language_code) || ' ' || fnd_global.local_chr(10) ||
676: get_message('MSC','MSC_X_PUB_PLAN',l_language_code) || ': ' || p_designator || fnd_global.local_chr(10);
677:
678: IF p_org_code IS NOT NULL THEN
679: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_ORG',l_language_code) || ': ' || p_org_code || fnd_global.local_chr(10);
680: END IF;

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

675: l_log_message := get_message('MSC','MSC_X_PUB_OF',l_language_code) || ' ' || fnd_global.local_chr(10) ||
676: get_message('MSC','MSC_X_PUB_PLAN',l_language_code) || ': ' || p_designator || fnd_global.local_chr(10);
677:
678: IF p_org_code IS NOT NULL THEN
679: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_ORG',l_language_code) || ': ' || p_org_code || fnd_global.local_chr(10);
680: END IF;
681:
682: IF p_item_id IS NOT NULL THEN
683: SELECT item_name

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

683: SELECT item_name
684: INTO l_item_name
685: FROM msc_items
686: WHERE inventory_item_id = p_item_id;
687: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_ITEM',l_language_code) || ': ' || l_item_name || fnd_global.local_chr(10);
688: END IF;
689:
690: IF p_supplier_id IS NOT NULL THEN
691: SELECT partner_name

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

691: SELECT partner_name
692: INTO l_supp_name
693: FROM msc_trading_partners
694: WHERE partner_id = p_supplier_id;
695: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_SUPPLIER',l_language_code) || ': ' || l_supp_name || fnd_global.local_chr(10);
696: END IF;
697:
698: IF p_supplier_site_id IS NOT NULL THEN
699: SELECT tp_site_code

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

700: INTO l_supp_site
701: FROM msc_trading_partner_sites
702: WHERE partner_id = p_supplier_id
703: AND partner_site_id = p_supplier_site_id;
704: 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);
705: END IF;
706:
707: IF p_planner_code IS NOT NULL THEN
708: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_PLANNER',l_language_code) || ': ' || p_planner_code || fnd_global.local_chr(10);

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

704: 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);
705: END IF;
706:
707: IF p_planner_code IS NOT NULL THEN
708: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_PLANNER',l_language_code) || ': ' || p_planner_code || fnd_global.local_chr(10);
709: END IF;
710:
711: IF p_planning_gp IS NOT NULL THEN
712: 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 712: 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);

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

712: 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);
713: END IF;
714:
715: IF p_project_id IS NOT NULL THEN
716: 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);
717: END IF;
718:
719: IF p_task_id IS NOT NULL THEN
720: 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 720: 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);

716: 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);
717: END IF;
718:
719: IF p_task_id IS NOT NULL THEN
720: 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);
721: END IF;
722:
723: IF p_abc_class IS NOT NULL THEN
724: 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 724: 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);

720: 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);
721: END IF;
722:
723: IF p_abc_class IS NOT NULL THEN
724: 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);
725: END IF;
726: log_message(l_log_message);
727:
728: l_log_message := get_message('MSC','MSC_X_PUB_DELETE_OF',l_language_code) || fnd_global.local_chr(10);

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

724: 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);
725: END IF;
726: log_message(l_log_message);
727:
728: l_log_message := get_message('MSC','MSC_X_PUB_DELETE_OF',l_language_code) || fnd_global.local_chr(10);
729: log_message(l_log_message);
730:
731: -- Option 1 -> YES , 2-> NO , bug#68938833
732: log_message('Publish Defective Outbound Shipment : ' || p_publish_dos);

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

1373: commit;
1374:
1375:
1376: IF l_cursor1 = 0 THEN
1377: l_log_message := get_message('MSC','MSC_X_PUB_NUM_RECORDS',l_language_code) || ': ' || 0 || '.' || fnd_global.local_chr(10);
1378: log_message(l_log_message);
1379: END IF;
1380:
1381: IF l_version IS NOT NULL THEN

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

1392: WHEN OTHERS then
1393: l_records_exist := 0;
1394: END;
1395: IF l_records_exist = 1 then
1396: l_log_message := get_message('MSC','MSC_X_PUB_NEW_VERSION',l_language_code) || ' ' || l_version || '.' || fnd_global.local_chr(10);
1397: log_message(l_log_message);
1398:
1399: --update version number in msc_plans
1400:

Line 1818: l_log_message := get_message('MSC','MSC_X_PUB_NUM_RECORDS',p_language_code) || ': ' || t_pub_id.COUNT || '.' || fnd_global.local_chr(10);

1814: if t_pub_id is not null and t_pub_id.COUNT > 0 then
1815: log_message('Records fetched := ' || t_pub_id.COUNT);
1816: FND_FILE.PUT_LINE(FND_FILE.LOG,'Records fetched := ' || t_pub_id.COUNT);
1817: if t_pub_id is not null and t_pub_id.COUNT > 0 THEN
1818: l_log_message := get_message('MSC','MSC_X_PUB_NUM_RECORDS',p_language_code) || ': ' || t_pub_id.COUNT || '.' || fnd_global.local_chr(10);
1819: log_message(l_log_message);
1820: log_message('Records to be inserted : ' || t_pub_id.COUNT);
1821:
1822: ------------------------------------------------------------------------------------------