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.MRP_AP_REL_PLAN_PUB dependencies on MSC_UTIL

Line 154: IF MRP_CL_FUNCTION.validateUser(l_user_id,MSC_UTIL.TASK_RELEASE,lv_log_msg) THEN

150: WHEN NO_DATA_FOUND THEN
151: raise_application_error (-20001, 'NO_USER_DEFINED');
152: END;
153:
154: IF MRP_CL_FUNCTION.validateUser(l_user_id,MSC_UTIL.TASK_RELEASE,lv_log_msg) THEN
155: MRP_CL_FUNCTION.MSC_Initialize(MSC_UTIL.TASK_RELEASE,
156: l_user_id,
157: -1, --l_resp_id,
158: -1 --l_application_id

Line 155: MRP_CL_FUNCTION.MSC_Initialize(MSC_UTIL.TASK_RELEASE,

151: raise_application_error (-20001, 'NO_USER_DEFINED');
152: END;
153:
154: IF MRP_CL_FUNCTION.validateUser(l_user_id,MSC_UTIL.TASK_RELEASE,lv_log_msg) THEN
155: MRP_CL_FUNCTION.MSC_Initialize(MSC_UTIL.TASK_RELEASE,
156: l_user_id,
157: -1, --l_resp_id,
158: -1 --l_application_id
159: );

Line 161: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_log_msg);

157: -1, --l_resp_id,
158: -1 --l_application_id
159: );
160: ELSE
161: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_log_msg);
162: raise_application_error (-20001, lv_log_msg);
163: END IF;
164:
165: END IF;

Line 2471: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '1 dblink is '|| lv_dblink);

2467:
2468: -- Submit 'EAM req for CMRO ' Request --
2469: BEGIN
2470:
2471: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '1 dblink is '|| lv_dblink);
2472: lv_sqlstmt := 'SELECT 1 '
2473: ||' FROM MSC_WIP_JOB_SCHEDULE_INTERFACE'||lv_dblink
2474: ||' WHERE SR_INSTANCE_ID= :lv_instance_id'
2475: ||' AND GROUP_ID = (:G_WIP_GROUP_ID *-1)'

Line 2479: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' lv_sqlstmt is '|| lv_sqlstmt);

2475: ||' AND GROUP_ID = (:G_WIP_GROUP_ID *-1)'
2476: ||' AND LOAD_TYPE in (3,258)'
2477: ||' AND ROWNUM = 1 ';
2478:
2479: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' lv_sqlstmt is '|| lv_sqlstmt);
2480:
2481: EXECUTE IMMEDIATE lv_sqlstmt into lv_dummy USING lv_instance_id,G_WIP_GROUP_ID;
2482:
2483:

Line 2486: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'dblink is '|| lv_dblink);

2482:
2483:
2484: -- set to trigger mode to bypass the 'SAVEPOINT' and 'ROLLBACK' command.
2485: lv_result := FND_REQUEST.SET_MODE(TRUE);
2486: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'dblink is '|| lv_dblink);
2487: o_request_id := FND_REQUEST.SUBMIT_REQUEST(
2488: 'MSC', -- application
2489: 'MRPPSRELB', -- program
2490: NULL, -- description

Line 2540: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '1 dblink is '|| lv_dblink);

2536: o_request_id_cmro := NULL;
2537:
2538: BEGIN
2539:
2540: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '1 dblink is '|| lv_dblink);
2541: lv_sqlstmt := 'SELECT 1 '
2542: ||' FROM MSC_WIP_JOB_SCHEDULE_INTERFACE'||lv_dblink
2543: ||' WHERE SR_INSTANCE_ID= :lv_instance_id'
2544: ||' AND GROUP_ID = (:G_WIP_GROUP_ID *-1)'

Line 2548: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' lv_sqlstmt is '|| lv_sqlstmt);

2544: ||' AND GROUP_ID = (:G_WIP_GROUP_ID *-1)'
2545: ||' AND MAINTENANCE_OBJECT_SOURCE =1'
2546: ||' AND ROWNUM = 1 ';
2547:
2548: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' lv_sqlstmt is '|| lv_sqlstmt);
2549:
2550: EXECUTE IMMEDIATE lv_sqlstmt into lv_dummy USING lv_instance_id,G_WIP_GROUP_ID;
2551: -- set to trigger mode to bypass the 'SAVEPOINT' and 'ROLLBACK' command.
2552: lv_result := FND_REQUEST.SET_MODE(TRUE);

Line 2554: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'dblink is '|| lv_dblink);

2550: EXECUTE IMMEDIATE lv_sqlstmt into lv_dummy USING lv_instance_id,G_WIP_GROUP_ID;
2551: -- set to trigger mode to bypass the 'SAVEPOINT' and 'ROLLBACK' command.
2552: lv_result := FND_REQUEST.SET_MODE(TRUE);
2553:
2554: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'dblink is '|| lv_dblink);
2555:
2556: o_request_id_eam := FND_REQUEST.SUBMIT_REQUEST(
2557: 'MSC', -- application
2558: 'MRPEAMRELB', -- program

Line 2574: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '1 dblink is '|| lv_dblink);

2570: --handle CMRO jobs now
2571:
2572: BEGIN
2573:
2574: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '1 dblink is '|| lv_dblink);
2575: lv_sqlstmt := 'SELECT 1 '
2576: ||' FROM MSC_WIP_JOB_SCHEDULE_INTERFACE'||lv_dblink
2577: ||' WHERE SR_INSTANCE_ID= :lv_instance_id'
2578: ||' AND GROUP_ID = (:G_WIP_GROUP_ID *-1)'

Line 2583: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' lv_sqlstmt is '|| lv_sqlstmt);

2579: ||' AND MAINTENANCE_OBJECT_SOURCE =2'
2580: ---maintenance_object_source will be 2 for CMRO jobs
2581: ||' AND ROWNUM = 1 ';
2582:
2583: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' lv_sqlstmt is '|| lv_sqlstmt);
2584:
2585: EXECUTE IMMEDIATE lv_sqlstmt into lv_dummy USING
2586: lv_instance_id,G_WIP_GROUP_ID;
2587: -- set to trigger mode to bypass the 'SAVEPOINT' and 'ROLLBACK' command.

Line 2590: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'dblink is '|| lv_dblink);

2586: lv_instance_id,G_WIP_GROUP_ID;
2587: -- set to trigger mode to bypass the 'SAVEPOINT' and 'ROLLBACK' command.
2588: lv_result := FND_REQUEST.SET_MODE(TRUE);
2589:
2590: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'dblink is '|| lv_dblink);
2591:
2592: o_request_id_cmro := FND_REQUEST.SUBMIT_REQUEST(
2593: 'MSC', -- application
2594: 'MRPCMRELB', -- new exe name

Line 2647: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '1 dblink is '|| lv_dblink);

2643: o_request_id := NULL;
2644:
2645: BEGIN
2646:
2647: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '1 dblink is '|| lv_dblink);
2648: lv_sqlstmt := 'SELECT 1 '
2649: ||' FROM MSC_WIP_JOB_SCHEDULE_INTERFACE'||lv_dblink
2650: ||' WHERE SR_INSTANCE_ID= :lv_instance_id'
2651: ||' AND GROUP_ID = (:G_WIP_GROUP_ID *-1)'

Line 2655: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' lv_sqlstmt is '|| lv_sqlstmt);

2651: ||' AND GROUP_ID = (:G_WIP_GROUP_ID *-1)'
2652: ||' AND MAINTENANCE_OBJECT_SOURCE =1'
2653: ||' AND ROWNUM = 1 ';
2654:
2655: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' lv_sqlstmt is '|| lv_sqlstmt);
2656:
2657: EXECUTE IMMEDIATE lv_sqlstmt into lv_dummy USING lv_instance_id,G_WIP_GROUP_ID;
2658: -- set to trigger mode to bypass the 'SAVEPOINT' and 'ROLLBACK' command.
2659: lv_result := FND_REQUEST.SET_MODE(TRUE);

Line 2661: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'dblink is '|| lv_dblink);

2657: EXECUTE IMMEDIATE lv_sqlstmt into lv_dummy USING lv_instance_id,G_WIP_GROUP_ID;
2658: -- set to trigger mode to bypass the 'SAVEPOINT' and 'ROLLBACK' command.
2659: lv_result := FND_REQUEST.SET_MODE(TRUE);
2660:
2661: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'dblink is '|| lv_dblink);
2662:
2663: o_request_id := FND_REQUEST.SUBMIT_REQUEST(
2664: 'MSC', -- application
2665: 'MRPPSRELB', -- program

Line 2717: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '1 dblink is '|| lv_dblink);

2713: o_request_id := NULL;
2714:
2715: BEGIN
2716:
2717: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '1 dblink is '|| lv_dblink);
2718: lv_sqlstmt := 'SELECT 1 '
2719: ||' FROM MSC_WIP_JOB_SCHEDULE_INTERFACE'||lv_dblink
2720: ||' WHERE SR_INSTANCE_ID= :lv_instance_id'
2721: ||' AND GROUP_ID = (:G_WIP_GROUP_ID *-1)'

Line 2726: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' lv_sqlstmt is '|| lv_sqlstmt);

2722: ||' AND LOAD_TYPE=258'
2723: ||' AND MAINTENANCE_OBJECT_SOURCE =2'
2724: ||' AND ROWNUM = 1 ';
2725:
2726: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' lv_sqlstmt is '|| lv_sqlstmt);
2727:
2728: EXECUTE IMMEDIATE lv_sqlstmt into lv_dummy USING lv_instance_id,G_WIP_GROUP_ID;
2729: -- set to trigger mode to bypass the 'SAVEPOINT' and 'ROLLBACK' command.
2730: lv_result := FND_REQUEST.SET_MODE(TRUE);

Line 2732: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'dblink is '|| lv_dblink);

2728: EXECUTE IMMEDIATE lv_sqlstmt into lv_dummy USING lv_instance_id,G_WIP_GROUP_ID;
2729: -- set to trigger mode to bypass the 'SAVEPOINT' and 'ROLLBACK' command.
2730: lv_result := FND_REQUEST.SET_MODE(TRUE);
2731:
2732: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'dblink is '|| lv_dblink);
2733:
2734: o_request_id := FND_REQUEST.SUBMIT_REQUEST(
2735: 'MSC', -- application
2736: 'MRPPSRELB', -- program

Line 4538: MSC_UTIL.LOG_MSG( 'LD_EAM_RESCHEDULE_JOBS: 000 ');

4534: lv_dummy INTEGER;
4535:
4536: BEGIN
4537:
4538: MSC_UTIL.LOG_MSG( 'LD_EAM_RESCHEDULE_JOBS: 000 ');
4539:
4540: select DECODE( A2M_DBLINK,
4541: NULL, ' ',
4542: '@'||A2M_DBLINK),

Line 4552: MSC_UTIL.LOG_MSG( 'LD_EAM_RESCHEDULE_JOBS: 111 lv_dblink/lv_instance_id '

4548: and instance_code = v_instance_code
4549: and nvl(a2m_dblink,NULL_DBLINK) = nvl(v_dblink,NULL_DBLINK)
4550: and ALLOW_RELEASE_FLAG=1;
4551:
4552: MSC_UTIL.LOG_MSG( 'LD_EAM_RESCHEDULE_JOBS: 111 lv_dblink/lv_instance_id '
4553: || lv_dblink
4554: || '/' || lv_instance_id
4555: );
4556:

Line 4630: MSC_UTIL.LOG_MSG( 'rows inserted into EAM_WORK_ORDER_IMPORT = '

4626: ;
4627:
4628: EXECUTE IMMEDIATE lv_sqlstmt USING lv_instance_id,G_WIP_GROUP_ID;
4629:
4630: MSC_UTIL.LOG_MSG( 'rows inserted into EAM_WORK_ORDER_IMPORT = '
4631: || SQL%ROWCOUNT);
4632:
4633: -- operations
4634:

Line 4635: MSC_UTIL.LOG_MSG('operations');

4631: || SQL%ROWCOUNT);
4632:
4633: -- operations
4634:
4635: MSC_UTIL.LOG_MSG('operations');
4636: lv_sqlstmt:=
4637: 'INSERT INTO EAM_OPERATION_IMPORT'
4638: ||' ( LAST_UPDATE_DATE,'
4639: ||' LAST_UPDATED_BY,'

Line 4680: MSC_UTIL.LOG_MSG('lv_dblink/lv_instance_id/G_WIP_GROUP_ID = '

4676: ||' AND eam_flag = 1 ' -- SYS_YES
4677: ||' AND load_type = 3 '
4678: ;
4679:
4680: MSC_UTIL.LOG_MSG('lv_dblink/lv_instance_id/G_WIP_GROUP_ID = '
4681: || lv_dblink
4682: || '/' || lv_instance_id
4683: || '/' || G_WIP_GROUP_ID
4684: );

Line 4688: MSC_UTIL.LOG_MSG( 'rows inserted into EAM_OPERATION_IMPORT = '

4684: );
4685:
4686: EXECUTE IMMEDIATE lv_sqlstmt USING lv_instance_id,G_WIP_GROUP_ID;
4687:
4688: MSC_UTIL.LOG_MSG( 'rows inserted into EAM_OPERATION_IMPORT = '
4689: || SQL%ROWCOUNT);
4690:
4691: -- operation resource
4692:

Line 4743: MSC_UTIL.LOG_MSG( 'rows inserted into EAM_RESOURCE_IMPORT = '

4739: ;
4740:
4741: EXECUTE IMMEDIATE lv_sqlstmt USING lv_instance_id,G_WIP_GROUP_ID;
4742:
4743: MSC_UTIL.LOG_MSG( 'rows inserted into EAM_RESOURCE_IMPORT = '
4744: || SQL%ROWCOUNT);
4745:
4746: -- operation components
4747:

Line 4792: MSC_UTIL.LOG_MSG( 'rows inserted into EAM_MATERIAL_IMPORT = '

4788: ;
4789:
4790: EXECUTE IMMEDIATE lv_sqlstmt USING lv_instance_id,G_WIP_GROUP_ID;
4791:
4792: MSC_UTIL.LOG_MSG( 'rows inserted into EAM_MATERIAL_IMPORT = '
4793: || SQL%ROWCOUNT);
4794:
4795: -- reschedule resource instance
4796:

Line 4845: MSC_UTIL.LOG_MSG( 'rows inserted into EAM_RESOURCE_INSTANCE_IMPORT = '

4841: ;
4842:
4843: EXECUTE IMMEDIATE lv_sqlstmt USING lv_instance_id,G_WIP_GROUP_ID;
4844:
4845: MSC_UTIL.LOG_MSG( 'rows inserted into EAM_RESOURCE_INSTANCE_IMPORT = '
4846: || SQL%ROWCOUNT);
4847:
4848: -- reschedule resource/instance usage
4849:

Line 4902: MSC_UTIL.LOG_MSG( 'rows inserted into EAM_RESOURCE_USAGE_IMPORT = '

4898: --||' AND ORGANIZATION_TYPE = 1 ';
4899:
4900: EXECUTE IMMEDIATE lv_sqlstmt USING lv_instance_id,G_WIP_GROUP_ID;
4901:
4902: MSC_UTIL.LOG_MSG( 'rows inserted into EAM_RESOURCE_USAGE_IMPORT = '
4903: || SQL%ROWCOUNT);
4904:
4905: o_request_id := NULL;
4906:

Line 4939: MSC_UTIL.LOG_MSG( 'EAM RESCHEDULE Request submitted = ' || o_request_id);

4935: WHEN NO_DATA_FOUND THEN NULL;
4936: WHEN OTHERS THEN RAISE;
4937: END;
4938:
4939: MSC_UTIL.LOG_MSG( 'EAM RESCHEDULE Request submitted = ' || o_request_id);
4940:
4941: END LD_EAM_RESCHEDULE_JOBS;
4942: */
4943: