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

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

Line 607: fnd_global.user_id,

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

Line 608: fnd_global.user_name --,

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

Line 609: --fnd_global.resp_name,

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

Line 610: --fnd_global.application_name

606: select
607: fnd_global.user_id,
608: fnd_global.user_name --,
609: --fnd_global.resp_name,
610: --fnd_global.application_name
611: into l_user_id,
612: l_user_name --,
613: --l_resp_name,
614: --l_application_name

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

688: else
689: l_version := null;
690: end if;
691:
692: l_log_message := get_message('MSC','MSC_X_PUB_OF',l_language_code) || ' ' || fnd_global.local_chr(10) ||
693: get_message('MSC','MSC_X_PUB_PLAN',l_language_code) || ': ' || p_designator || fnd_global.local_chr(10);
694:
695: IF p_org_code IS NOT NULL THEN
696: 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 693: get_message('MSC','MSC_X_PUB_PLAN',l_language_code) || ': ' || p_designator || fnd_global.local_chr(10);

689: l_version := null;
690: end if;
691:
692: l_log_message := get_message('MSC','MSC_X_PUB_OF',l_language_code) || ' ' || fnd_global.local_chr(10) ||
693: get_message('MSC','MSC_X_PUB_PLAN',l_language_code) || ': ' || p_designator || fnd_global.local_chr(10);
694:
695: IF p_org_code IS NOT NULL THEN
696: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_ORG',l_language_code) || ': ' || p_org_code || fnd_global.local_chr(10);
697: END IF;

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

692: l_log_message := get_message('MSC','MSC_X_PUB_OF',l_language_code) || ' ' || fnd_global.local_chr(10) ||
693: get_message('MSC','MSC_X_PUB_PLAN',l_language_code) || ': ' || p_designator || fnd_global.local_chr(10);
694:
695: IF p_org_code IS NOT NULL THEN
696: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_ORG',l_language_code) || ': ' || p_org_code || fnd_global.local_chr(10);
697: END IF;
698:
699: IF p_item_id IS NOT NULL THEN
700: SELECT item_name

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

700: SELECT item_name
701: INTO l_item_name
702: FROM msc_items
703: WHERE inventory_item_id = p_item_id;
704: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_ITEM',l_language_code) || ': ' || l_item_name || fnd_global.local_chr(10);
705: END IF;
706:
707: IF p_supplier_id IS NOT NULL THEN
708: SELECT partner_name

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

708: SELECT partner_name
709: INTO l_supp_name
710: FROM msc_trading_partners
711: WHERE partner_id = p_supplier_id;
712: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_SUPPLIER',l_language_code) || ': ' || l_supp_name || fnd_global.local_chr(10);
713: END IF;
714:
715: IF p_supplier_site_id IS NOT NULL THEN
716: SELECT tp_site_code

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

717: INTO l_supp_site
718: FROM msc_trading_partner_sites
719: WHERE partner_id = p_supplier_id
720: AND partner_site_id = p_supplier_site_id;
721: 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);
722: END IF;
723:
724: IF p_planner_code IS NOT NULL THEN
725: 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 725: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_PLANNER',l_language_code) || ': ' || p_planner_code || fnd_global.local_chr(10);

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

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

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

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

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

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

741: 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);
742: END IF;
743: log_message(l_log_message);
744:
745: l_log_message := get_message('MSC','MSC_X_PUB_DELETE_OF',l_language_code) || fnd_global.local_chr(10);
746: log_message(l_log_message);
747:
748: -- Option 1 -> YES , 2-> NO , bug#68938833
749: log_message('Publish Defective Outbound Shipment : ' || p_publish_dos);

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

1390: commit;
1391:
1392:
1393: IF l_cursor1 = 0 THEN
1394: l_log_message := get_message('MSC','MSC_X_PUB_NUM_RECORDS',l_language_code) || ': ' || 0 || '.' || fnd_global.local_chr(10);
1395: log_message(l_log_message);
1396: END IF;
1397:
1398: IF l_version IS NOT NULL THEN

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

1409: WHEN OTHERS then
1410: l_records_exist := 0;
1411: END;
1412: IF l_records_exist = 1 then
1413: l_log_message := get_message('MSC','MSC_X_PUB_NEW_VERSION',l_language_code) || ' ' || l_version || '.' || fnd_global.local_chr(10);
1414: log_message(l_log_message);
1415:
1416: --update version number in msc_plans
1417:

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

1831: if t_pub_id is not null and t_pub_id.COUNT > 0 then
1832: log_message('Records fetched := ' || t_pub_id.COUNT);
1833: FND_FILE.PUT_LINE(FND_FILE.LOG,'Records fetched := ' || t_pub_id.COUNT);
1834: if t_pub_id is not null and t_pub_id.COUNT > 0 THEN
1835: l_log_message := get_message('MSC','MSC_X_PUB_NUM_RECORDS',p_language_code) || ': ' || t_pub_id.COUNT || '.' || fnd_global.local_chr(10);
1836: log_message(l_log_message);
1837: log_message('Records to be inserted : ' || t_pub_id.COUNT);
1838:
1839: ------------------------------------------------------------------------------------------