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_RELEASE_EAM_WO dependencies on MSC_UTIL

Line 48: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,

44: var_proc := 'RELEASE_EAM_WO' ;
45: g_dblink := P_DBLINK;
46: g_group_id := P_GROUP_ID;
47:
48: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
49: '------------------- MSC Release EAM Work Order Log Start ------------------ ');
50:
51: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
52: 'RELEASE_EAM_WO Called with Params ' || ' DBLINK : '

Line 51: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,

47:
48: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
49: '------------------- MSC Release EAM Work Order Log Start ------------------ ');
50:
51: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
52: 'RELEASE_EAM_WO Called with Params ' || ' DBLINK : '
53: || P_DBLINK ||' GROUP_ID: '||p_group_id );
54:
55: lv_cur_stmt := ' SELECT DISTINCT SOURCE_LINE_ID ,ORGANIZATION_ID '

Line 65: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,

61: OPEN WO_CUR for lv_cur_stmt;
62:
63: FETCH WO_CUR BULK COLLECT INTO WO_CUR_TBL ;
64: lv_wo_count := WO_CUR%ROWCOUNT;
65: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
66: 'SQL rowcount of WO_CUR is '||lv_wo_count);
67: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
68: 'Number of records fetched into WO_CUR_TBL is '||WO_CUR_TBL.Count);
69:

Line 67: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,

63: FETCH WO_CUR BULK COLLECT INTO WO_CUR_TBL ;
64: lv_wo_count := WO_CUR%ROWCOUNT;
65: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
66: 'SQL rowcount of WO_CUR is '||lv_wo_count);
67: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
68: 'Number of records fetched into WO_CUR_TBL is '||WO_CUR_TBL.Count);
69:
70: -- if count is > 0 Print report header and group_id
71: IF (lv_wo_count > 0) THEN

Line 82: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,

78: END IF;
79:
80: FOR y IN 1..WO_CUR_TBL.Count LOOP
81:
82: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
83: ' Processing Job/Org : ' || WO_CUR_TBL(Y).SOURCE_LINE_ID ||'/'||
84: WO_CUR_TBL(Y).ORGANIZATION_ID );
85:
86: -- Print report header and group_id

Line 90: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,

86: -- Print report header and group_id
87: PROCESS_Single_WO(WO_CUR_TBL(Y).SOURCE_LINE_ID,
88: WO_CUR_TBL(Y).ORGANIZATION_ID);
89:
90: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
91: 'After PROCESS_Single_WO and before Commit');
92: COMMIT;
93: END LOOP ;
94: CLOSE WO_CUR;

Line 112: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1, lv_sql_stmt );

108: ||' where sr_instance_id ='|| P_SR_INSTANCE_ID
109: ||' and nvl(group_id,-1) = nvl('||g_group_id||',-1)'
110: ||' and maintenance_object_source =1 '
111: ||' and load_type =257';
112: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1, lv_sql_stmt );
113:
114: EXECUTE IMMEDIATE lv_sql_stmt;
115:
116: END IF;

Line 118: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,

114: EXECUTE IMMEDIATE lv_sql_stmt;
115:
116: END IF;
117:
118: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
119: '------------------ MSC Release EAM Work Order Log End ------------------- ');
120: RETURN;
121:
122: EXCEPTION

Line 126: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,

122: EXCEPTION
123: WHEN OTHERS THEN
124: -- var_buf := var_proc||' 1: '||sqlerrm;
125: --fnd_file.put_line(FND_FILE.LOG, var_buf);
126: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
127: 'Exception in RELEASE_EAM_WO');
128: ROLLBACK;
129: RETCODE := 1;
130: ERRBUF := var_buf;

Line 242: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1, 'Work Order Details : ' );

238: GET_WO_DETAIL (V_SOURCE_LINE_ID , V_ORGANIZATION_ID , L_EAM_WO_TBL,L_START_QUANTITY) ;
239:
240: l_job_start_date := L_EAM_WO_TBL(1).SCHEDULED_START_DATE;
241:
242: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1, 'Work Order Details : ' );
243:
244:
245: IF( L_EAM_WO_TBL.Count > 0 ) THEN
246: lv_hdr_strg := ' '||'SOURCE_CODE'||

Line 281: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,

277: ' '||'----------------'||
278: ' '||'--------';
279:
280:
281: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
282: lv_hdr_strg);
283: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
284: lv_brd_stmt);
285: FOR X IN 1..L_EAM_WO_TBL.Count LOOP

Line 283: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,

279:
280:
281: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
282: lv_hdr_strg);
283: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
284: lv_brd_stmt);
285: FOR X IN 1..L_EAM_WO_TBL.Count LOOP
286: lv_dbg_stmt := ' '||RPAD(Nvl(to_char(L_EAM_WO_TBL(x).SOURCE_CODE),' '),17)||
287: RPAD(NVL(to_char(L_EAM_WO_TBL(x).SOURCE_LINE_ID),' '),17)||

Line 303: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,

299: RPAD(NVL(to_char(L_EAM_WO_TBL(x).MAINTENANCE_OBJECT_TYPE),' '),26)||
300: RPAD(NVL(to_char(L_EAM_WO_TBL(x).TRANSACTION_TYPE),' '),18)||
301: RPAD(NVL(to_char(L_EAM_WO_TBL(x).BATCH_ID),' '),22);
302:
303: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
304: lv_dbg_stmt);
305: END LOOP ;
306: END IF ;
307:

Line 325: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,

321: fnd_file.get_names(g_log_file_name,g_out_file_name);
322: g_log_file_set := TRUE;
323:
324: END IF;
325: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
326: 'EAM debug output dir is: '||g_output_dir);
327: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
328: 'EAM log file name is : '||g_log_file_name);
329:

Line 327: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,

323:
324: END IF;
325: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
326: 'EAM debug output dir is: '||g_output_dir);
327: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
328: 'EAM log file name is : '||g_log_file_name);
329:
330: savepoint EAMCALL;
331:

Line 333: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,

329:
330: savepoint EAMCALL;
331:
332: lv_start_quantity := L_START_QUANTITY;
333: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
334: 'EAM api would be called '||lv_start_quantity ||' times');
335:
336: FOR x in 1..lv_start_quantity LOOP
337:

Line 338: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Inside looop : '||x);

334: 'EAM api would be called '||lv_start_quantity ||' times');
335:
336: FOR x in 1..lv_start_quantity LOOP
337:
338: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Inside looop : '||x);
339: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
340: 'Calling API '||
341: 'EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO ');
342: FND_MSG_PUB.initialize;

Line 339: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,

335:
336: FOR x in 1..lv_start_quantity LOOP
337:
338: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Inside looop : '||x);
339: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
340: 'Calling API '||
341: 'EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO ');
342: FND_MSG_PUB.initialize;
343:

Line 396: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,

392: , p_debug_file_mode => 'a'
393: );
394: -- log api return details
395:
396: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
397: 'status returned by EAM API is '||l_x_return_status);
398: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
399: 'value of l_x_msg_count is'||l_x_msg_count);
400:

Line 398: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,

394: -- log api return details
395:
396: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
397: 'status returned by EAM API is '||l_x_return_status);
398: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
399: 'value of l_x_msg_count is'||l_x_msg_count);
400:
401: FOR i IN 1..l_x_msg_count LOOP
402: FND_MSG_PUB.get (

Line 407: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,

403: p_msg_index => i,
404: p_encoded => FND_API.G_FALSE,
405: p_data => x_msg_data,
406: p_msg_index_out => l_msg_index_out );
407: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
408: SubStr('x_msg_data = '||x_msg_data,1,255));
409: END LOOP;
410:
411:

Line 414: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,

410:
411:
412: IF(l_x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
413:
414: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
415: 'EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO '||
416: ' returns SUCCESS');
417: -- fnd_file.put_line(FND_FILE.OUTPUT, var_buf);
418: var_buf := 'Group ID : '||g_group_id;

Line 431: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,

427: RPAD(NVL(to_char(L_X_EAM_WO_TBL(1).SCHEDULED_COMPLETION_DATE,'DD-MON-YYYY hh24:mi:ss'),' '),29)
428: );
429:
430: ELSE
431: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
432: 'EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO '||
433: 'FAILED');
434: g_retcode := MSC_UTIL.G_WARNING;
435: END IF;

Line 434: g_retcode := MSC_UTIL.G_WARNING;

430: ELSE
431: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
432: 'EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO '||
433: 'FAILED');
434: g_retcode := MSC_UTIL.G_WARNING;
435: END IF;
436:
437: IF((l_x_return_status <> FND_API.G_RET_STS_SUCCESS))
438: THEN

Line 452: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,

448: RETURN;
449:
450: EXCEPTION
451: WHEN OTHERS THEN
452: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
453: ' Error in procedure process_single_wo: '||sqlerrm);
454: g_retcode := MSC_UTIL.G_WARNING;
455: RETURN;
456:

Line 454: g_retcode := MSC_UTIL.G_WARNING;

450: EXCEPTION
451: WHEN OTHERS THEN
452: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
453: ' Error in procedure process_single_wo: '||sqlerrm);
454: g_retcode := MSC_UTIL.G_WARNING;
455: RETURN;
456:
457:
458: END PROCESS_Single_WO ;

Line 526: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEV, L_JOB_STMT );

522:
523:
524: OPEN JOBS_CUR for L_JOB_STMT using V_ORGANIZATION_ID,G_GROUP_ID,V_SOURCE_LINE_ID ;
525:
526: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEV, L_JOB_STMT );
527:
528: FETCH JOBS_CUR BULK COLLECT INTO JOBS_CUR_TBL ;
529: lv_std_job_count := JOBS_CUR%ROWCOUNT;
530: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,

Line 530: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,

526: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEV, L_JOB_STMT );
527:
528: FETCH JOBS_CUR BULK COLLECT INTO JOBS_CUR_TBL ;
529: lv_std_job_count := JOBS_CUR%ROWCOUNT;
530: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
531: 'SQL rowcount of JOBS_CUR is '||lv_std_job_count);
532: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
533: 'Number of records fetched into JOBS_CUR_TBL is '||JOBS_CUR_TBL.Count);
534:

Line 532: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,

528: FETCH JOBS_CUR BULK COLLECT INTO JOBS_CUR_TBL ;
529: lv_std_job_count := JOBS_CUR%ROWCOUNT;
530: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
531: 'SQL rowcount of JOBS_CUR is '||lv_std_job_count);
532: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
533: 'Number of records fetched into JOBS_CUR_TBL is '||JOBS_CUR_TBL.Count);
534:
535: FOR y IN 1..JOBS_CUR_TBL.Count LOOP
536:

Line 584: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,

580:
581: EXCEPTION WHEN OTHERS THEN
582: -- var_buf := var_proc||' 3: '||sqlerrm;
583: -- fnd_file.put_line(FND_FILE.LOG, var_buf);
584: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
585: 'Exception in procedure GET_WO_DETAIL');
586: RETURN;
587:
588: END GET_WO_DETAIL ;