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

Line 82: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'SQL rowcount of WO_CUR is '||lv_wo_count);

78: USING g_group_id;
79:
80: FETCH REL_WO_CUR BULK COLLECT INTO REL_WO_CUR_TBL ;
81: lv_wo_count := REL_WO_CUR%ROWCOUNT;
82: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'SQL rowcount of WO_CUR is '||lv_wo_count);
83:
84: IF (lv_wo_count > 0) THEN
85: log_output(' Group ID: '||g_group_id);
86: log_output('================== ==================== ==================== =========== ');

Line 97: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,

93: If not ,we will do a insertion of new record */
94:
95:
96: FOR y IN 1..REL_WO_CUR_TBL.Count LOOP
97: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,
98: ' Processing Job/Org : ' || REL_WO_CUR_TBL(y).WIP_ENTITY_ID ||'/'||
99: REL_WO_CUR_TBL(y).ORGANIZATION_ID );
100:
101: UPDATE AHL_REQ_SUPPLY_SCHEDULE

Line 114: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,

110:
111:
112: IF(SQL%NOTFOUND) THEN
113:
114: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,
115: 'Insert a new record into AHL_REQ_SUPPLY_SCHEDULE');
116:
117:
118: INSERT INTO AHL_REQ_SUPPLY_SCHEDULE(

Line 148: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Item_id : '||REL_WO_CUR_TBL(y).PRIMARY_ITEM_ID);

144: -1,
145: SYSDATE,
146: -1);
147:
148: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Item_id : '||REL_WO_CUR_TBL(y).PRIMARY_ITEM_ID);
149: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Org_id : '||REL_WO_CUR_TBL(y).organization_id);
150: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Requested date : '||REL_WO_CUR_TBL(y).first_unit_start_date);
151: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Quantity : '||REL_WO_CUR_TBL(y).start_quantity);
152:

Line 149: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Org_id : '||REL_WO_CUR_TBL(y).organization_id);

145: SYSDATE,
146: -1);
147:
148: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Item_id : '||REL_WO_CUR_TBL(y).PRIMARY_ITEM_ID);
149: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Org_id : '||REL_WO_CUR_TBL(y).organization_id);
150: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Requested date : '||REL_WO_CUR_TBL(y).first_unit_start_date);
151: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Quantity : '||REL_WO_CUR_TBL(y).start_quantity);
152:
153: log_output(' '||rpad(REL_WO_CUR_TBL(y).PRIMARY_ITEM_ID, 9)||' '||

Line 150: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Requested date : '||REL_WO_CUR_TBL(y).first_unit_start_date);

146: -1);
147:
148: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Item_id : '||REL_WO_CUR_TBL(y).PRIMARY_ITEM_ID);
149: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Org_id : '||REL_WO_CUR_TBL(y).organization_id);
150: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Requested date : '||REL_WO_CUR_TBL(y).first_unit_start_date);
151: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Quantity : '||REL_WO_CUR_TBL(y).start_quantity);
152:
153: log_output(' '||rpad(REL_WO_CUR_TBL(y).PRIMARY_ITEM_ID, 9)||' '||
154: rpad(REL_WO_CUR_TBL(y).organization_id, 22) || ' '||

Line 151: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Quantity : '||REL_WO_CUR_TBL(y).start_quantity);

147:
148: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Item_id : '||REL_WO_CUR_TBL(y).PRIMARY_ITEM_ID);
149: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Org_id : '||REL_WO_CUR_TBL(y).organization_id);
150: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Requested date : '||REL_WO_CUR_TBL(y).first_unit_start_date);
151: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Quantity : '||REL_WO_CUR_TBL(y).start_quantity);
152:
153: log_output(' '||rpad(REL_WO_CUR_TBL(y).PRIMARY_ITEM_ID, 9)||' '||
154: rpad(REL_WO_CUR_TBL(y).organization_id, 22) || ' '||
155: to_char(REL_WO_CUR_TBL(y).first_unit_start_date, 'DD-MON-YYYY hh24:mi:ss') || ' '||

Line 161: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,

157: ' Success ');
158: log_output ('Inserted new record into AHL_REQ_SUPPLY_SCHEDULE');
159:
160: ELSE
161: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,
162: 'Updating existing record in AHL_REQ_SUPPLY_SCHEDULE');
163: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Item_id : '||REL_WO_CUR_TBL(y).PRIMARY_ITEM_ID);
164: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Org_id : '||REL_WO_CUR_TBL(y).organization_id);
165: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Requested date : '||REL_WO_CUR_TBL(y).first_unit_start_date);

Line 163: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Item_id : '||REL_WO_CUR_TBL(y).PRIMARY_ITEM_ID);

159:
160: ELSE
161: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,
162: 'Updating existing record in AHL_REQ_SUPPLY_SCHEDULE');
163: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Item_id : '||REL_WO_CUR_TBL(y).PRIMARY_ITEM_ID);
164: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Org_id : '||REL_WO_CUR_TBL(y).organization_id);
165: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Requested date : '||REL_WO_CUR_TBL(y).first_unit_start_date);
166: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Quantity : '||REL_WO_CUR_TBL(y).start_quantity);
167:

Line 164: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Org_id : '||REL_WO_CUR_TBL(y).organization_id);

160: ELSE
161: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,
162: 'Updating existing record in AHL_REQ_SUPPLY_SCHEDULE');
163: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Item_id : '||REL_WO_CUR_TBL(y).PRIMARY_ITEM_ID);
164: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Org_id : '||REL_WO_CUR_TBL(y).organization_id);
165: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Requested date : '||REL_WO_CUR_TBL(y).first_unit_start_date);
166: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Quantity : '||REL_WO_CUR_TBL(y).start_quantity);
167:
168:

Line 165: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Requested date : '||REL_WO_CUR_TBL(y).first_unit_start_date);

161: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,
162: 'Updating existing record in AHL_REQ_SUPPLY_SCHEDULE');
163: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Item_id : '||REL_WO_CUR_TBL(y).PRIMARY_ITEM_ID);
164: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Org_id : '||REL_WO_CUR_TBL(y).organization_id);
165: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Requested date : '||REL_WO_CUR_TBL(y).first_unit_start_date);
166: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Quantity : '||REL_WO_CUR_TBL(y).start_quantity);
167:
168:
169: log_output(' '||rpad(REL_WO_CUR_TBL(y).PRIMARY_ITEM_ID, 9)||' '||

Line 166: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Quantity : '||REL_WO_CUR_TBL(y).start_quantity);

162: 'Updating existing record in AHL_REQ_SUPPLY_SCHEDULE');
163: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Item_id : '||REL_WO_CUR_TBL(y).PRIMARY_ITEM_ID);
164: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Org_id : '||REL_WO_CUR_TBL(y).organization_id);
165: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Requested date : '||REL_WO_CUR_TBL(y).first_unit_start_date);
166: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Quantity : '||REL_WO_CUR_TBL(y).start_quantity);
167:
168:
169: log_output(' '||rpad(REL_WO_CUR_TBL(y).PRIMARY_ITEM_ID, 9)||' '||
170: rpad(REL_WO_CUR_TBL(y).organization_id, 22) || ' '||

Line 218: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,

214: g_dblink := P_DBLINK;
215: g_group_id := P_GROUP_ID;
216: g_sr_instance_id := P_SR_INSTANCE_ID;
217:
218: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
219: '------------------- PS Release Log Start ------------------ ');
220:
221: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
222: 'Updating msc_wip_job_schedule_interface to divide wip_entity_id /2');

Line 221: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,

217:
218: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
219: '------------------- PS Release Log Start ------------------ ');
220:
221: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
222: 'Updating msc_wip_job_schedule_interface to divide wip_entity_id /2');
223: lv_update_stmt := 'UPDATE MSC_WIP_JOB_SCHEDULE_INTERFACE'||g_dblink||
224: ' SET WIP_ENTITY_ID = WIP_ENTITY_ID/2'||
225: ' WHERE GROUP_ID = '|| P_GROUP_ID

Line 230: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,

226: ||' AND MAINTENANCE_OBJECT_SOURCE IN (1,2)'
227: ||' AND GROUP_ID < 0 '
228: ||' AND sr_instance_id ='|| P_SR_INSTANCE_ID;
229:
230: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
231: 'lv_update_stmt is '||lv_update_stmt);
232: EXECUTE IMMEDIATE lv_update_stmt;
233:
234: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,

Line 234: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,

230: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
231: 'lv_update_stmt is '||lv_update_stmt);
232: EXECUTE IMMEDIATE lv_update_stmt;
233:
234: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
235: 'Updating msc_wip_job_dtls_interface to divide wip_entity_id /2'||
236: 'department_id/2 and resource_id_new/2');
237:
238: lv_update_stmt := 'UPDATE MSC_WIP_JOB_DTLS_INTERFACE'||g_dblink||

Line 249: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,

245: ||' AND sr_instance_id ='|| P_SR_INSTANCE_ID;
246:
247: /*bug 12674323 -- added resource_instance_id in the above update stmt*/
248:
249: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
250: 'lv_update_stmt is '||lv_update_stmt);
251: EXECUTE IMMEDIATE lv_update_stmt;
252: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
253: 'RESCHEDULE_CMRO_WO Called with Params ' || ' DBLINK : '

Line 252: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,

248:
249: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
250: 'lv_update_stmt is '||lv_update_stmt);
251: EXECUTE IMMEDIATE lv_update_stmt;
252: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
253: 'RESCHEDULE_CMRO_WO Called with Params ' || ' DBLINK : '
254: || P_DBLINK ||' GROUP_ID: '||p_group_id );
255:
256: lv_cur_stmt := ' SELECT DISTINCT WIP_ENTITY_ID ,ORGANIZATION_ID '

Line 266: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'SQL rowcount of WO_CUR is '||lv_wo_count);

262:
263: OPEN WO_CUR for lv_cur_stmt;
264: FETCH WO_CUR BULK COLLECT INTO WO_CUR_TBL ;
265: lv_wo_count := WO_CUR%ROWCOUNT;
266: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'SQL rowcount of WO_CUR is '||lv_wo_count);
267: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Number of records fetched into WO_CUR_TBL is '||WO_CUR_TBL.Count);
268: -- if count is > 0 Print report header and group_id
269: IF (lv_wo_count > 0) THEN
270: log_output(' Group ID: '||g_group_id);

Line 267: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Number of records fetched into WO_CUR_TBL is '||WO_CUR_TBL.Count);

263: OPEN WO_CUR for lv_cur_stmt;
264: FETCH WO_CUR BULK COLLECT INTO WO_CUR_TBL ;
265: lv_wo_count := WO_CUR%ROWCOUNT;
266: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'SQL rowcount of WO_CUR is '||lv_wo_count);
267: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Number of records fetched into WO_CUR_TBL is '||WO_CUR_TBL.Count);
268: -- if count is > 0 Print report header and group_id
269: IF (lv_wo_count > 0) THEN
270: log_output(' Group ID: '||g_group_id);
271: log_output('================== ==================== ==================== =========== ');

Line 278: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,

274: END IF;
275:
276: FOR y IN 1..WO_CUR_TBL.Count LOOP
277:
278: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
279: ' Processing Job/Org : ' || WO_CUR_TBL(Y).WIP_ENTITY_ID ||'/'||
280: WO_CUR_TBL(Y).ORGANIZATION_ID );
281: -- Print report header and group_id
282: PROCESS_Single_WO(WO_CUR_TBL(Y).WIP_ENTITY_ID,

Line 284: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'After PROCESS_Single_WO and before Commit');

280: WO_CUR_TBL(Y).ORGANIZATION_ID );
281: -- Print report header and group_id
282: PROCESS_Single_WO(WO_CUR_TBL(Y).WIP_ENTITY_ID,
283: WO_CUR_TBL(Y).ORGANIZATION_ID);
284: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'After PROCESS_Single_WO and before Commit');
285: COMMIT;
286: END LOOP ;
287: CLOSE WO_CUR;
288:

Line 299: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'SQL rowcount of WO_CUR_EAM is '||lv_wo_count1);

295:
296: OPEN WO_CUR_EAM for lv_cur_stmt_eam;
297: FETCH WO_CUR_EAM BULK COLLECT INTO WO_CUR_EAM_TBL ;
298: lv_wo_count1 := WO_CUR_EAM%ROWCOUNT;
299: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'SQL rowcount of WO_CUR_EAM is '||lv_wo_count1);
300: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Number of records fetched into WO_CUR_EAM_TBL is '||WO_CUR_EAM_TBL.Count);
301: -- if count is > 0 Print report header and group_id
302: IF (lv_wo_count1 > 0) THEN
303: log_output(' Group ID: '||g_group_id);

Line 300: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Number of records fetched into WO_CUR_EAM_TBL is '||WO_CUR_EAM_TBL.Count);

296: OPEN WO_CUR_EAM for lv_cur_stmt_eam;
297: FETCH WO_CUR_EAM BULK COLLECT INTO WO_CUR_EAM_TBL ;
298: lv_wo_count1 := WO_CUR_EAM%ROWCOUNT;
299: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'SQL rowcount of WO_CUR_EAM is '||lv_wo_count1);
300: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Number of records fetched into WO_CUR_EAM_TBL is '||WO_CUR_EAM_TBL.Count);
301: -- if count is > 0 Print report header and group_id
302: IF (lv_wo_count1 > 0) THEN
303: log_output(' Group ID: '||g_group_id);
304: log_output('================== ==================== ==================== =========== ');

Line 311: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,

307: END IF;
308:
309: FOR y IN 1..WO_CUR_EAM_TBL.Count LOOP
310:
311: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
312: ' Processing Job/Org : ' || WO_CUR_EAM_TBL(Y).WIP_ENTITY_ID ||'/'||
313: WO_CUR_EAM_TBL(Y).ORGANIZATION_ID );
314: -- Print report header and group_id
315: PROCESS_Single_WO_EAM(WO_CUR_EAM_TBL(Y).WIP_ENTITY_ID,

Line 317: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'After PROCESS_Single_WO_EAM and before Commit');

313: WO_CUR_EAM_TBL(Y).ORGANIZATION_ID );
314: -- Print report header and group_id
315: PROCESS_Single_WO_EAM(WO_CUR_EAM_TBL(Y).WIP_ENTITY_ID,
316: WO_CUR_EAM_TBL(Y).ORGANIZATION_ID);
317: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'After PROCESS_Single_WO_EAM and before Commit');
318: COMMIT;
319: END LOOP ;
320: CLOSE WO_CUR_EAM;
321:

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

332: ||' where sr_instance_id ='|| P_SR_INSTANCE_ID
333: ||' and nvl(group_id,-1) = nvl('||g_group_id||',-1)'
334: ||' and maintenance_object_source in (1,2)'
335: ||' and group_id <0 ';
336: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1, lv_sql_stmt );
337:
338: EXECUTE IMMEDIATE lv_sql_stmt;
339: --using
340: -- g_dblink,

Line 344: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'After delete on msc_wip_job_schedule_interface' );

340: -- g_dblink,
341: -- P_SR_INSTANCE_ID,
342: -- g_group_id;
343:
344: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'After delete on msc_wip_job_schedule_interface' );
345: lv_sql_stmt := 'DELETE msc_wip_job_dtls_interface'||g_dblink
346: ||' where sr_instance_id =' || P_SR_INSTANCE_ID
347: ||' and nvl(group_id,-1) = nvl('||g_group_id||',-1)'
348: ||' and group_id < 0';

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

345: lv_sql_stmt := 'DELETE msc_wip_job_dtls_interface'||g_dblink
346: ||' where sr_instance_id =' || P_SR_INSTANCE_ID
347: ||' and nvl(group_id,-1) = nvl('||g_group_id||',-1)'
348: ||' and group_id < 0';
349: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1, lv_sql_stmt );
350:
351: EXECUTE IMMEDIATE lv_sql_stmt;
352: --using
353: -- g_dblink,

Line 359: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,

355: -- g_group_id;
356:
357: END IF;
358:
359: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
360: '------------------ PS Release Log End ------------------- ');
361: RETURN;
362:
363: EXCEPTION

Line 367: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Exception in Reschedule_CMRO_WO');

363: EXCEPTION
364: WHEN OTHERS THEN
365: -- var_buf := var_proc||' 1: '||sqlerrm;
366: --fnd_file.put_line(FND_FILE.LOG, var_buf);
367: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Exception in Reschedule_CMRO_WO');
368: ROLLBACK;
369: RETCODE := 1;
370: ERRBUF := var_buf;
371: RETURN;

Line 500: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,' ' );

496: GET_MAT_DETAIL(V_WIP_ENTITY_ID , V_ORGANIZATION_ID ,L_EAM_MAT_TBL ) ;
497: GET_SUB_MAT_DETAIL(V_WIP_ENTITY_ID , V_ORGANIZATION_ID ,L_EAM_MAT_TBL ) ;
498: GET_RES_USAGE_DETAIL(V_WIP_ENTITY_ID ,V_ORGANIZATION_ID,L_EAM_RES_USAGE_TBL);
499:
500: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,' ' );
501: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Work Order Details : ' );
502:
503:
504: IF( L_EAM_WO_TBL.Count > 0 ) THEN

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

497: GET_SUB_MAT_DETAIL(V_WIP_ENTITY_ID , V_ORGANIZATION_ID ,L_EAM_MAT_TBL ) ;
498: GET_RES_USAGE_DETAIL(V_WIP_ENTITY_ID ,V_ORGANIZATION_ID,L_EAM_RES_USAGE_TBL);
499:
500: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,' ' );
501: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Work Order Details : ' );
502:
503:
504: IF( L_EAM_WO_TBL.Count > 0 ) THEN
505: lv_hdr_strg := ' '||'SOURCE_CODE'||

Line 526: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_hdr_strg);

522: ' '||'-----------------------'||
523: ' '||'-----------------------'||
524: ' '||'-----------------------'||
525: ' '||'-----------------------';
526: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_hdr_strg);
527: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_brd_stmt);
528: FOR X IN 1..L_EAM_WO_TBL.Count LOOP
529: lv_dbg_stmt := ' '||RPAD(Nvl(to_char(L_EAM_WO_TBL(x).SOURCE_CODE),' '),17)||
530: RPAD(NVL(to_char(L_EAM_WO_TBL(x).SOURCE_LINE_ID),' '),17)||

Line 527: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_brd_stmt);

523: ' '||'-----------------------'||
524: ' '||'-----------------------'||
525: ' '||'-----------------------';
526: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_hdr_strg);
527: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_brd_stmt);
528: FOR X IN 1..L_EAM_WO_TBL.Count LOOP
529: lv_dbg_stmt := ' '||RPAD(Nvl(to_char(L_EAM_WO_TBL(x).SOURCE_CODE),' '),17)||
530: RPAD(NVL(to_char(L_EAM_WO_TBL(x).SOURCE_LINE_ID),' '),17)||
531: RPAD(NVL(to_char(L_EAM_WO_TBL(x).ORGANIZATION_ID),' '),12)||

Line 539: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt);

535: RPAD(NVL(to_char(L_EAM_WO_TBL(x).SCHEDULED_START_DATE,'DD-MON-YYYY hh24:mi:ss'),' '),27)||
536: RPAD(NVL(to_char(L_EAM_WO_TBL(x).SCHEDULED_COMPLETION_DATE,'DD-MON-YYYY hh24:mi:ss'),' '),27)||
537: RPAD(NVL(to_char(L_EAM_WO_TBL(x).BOM_REVISION_DATE,'DD-MON-YYYY hh24:mi:ss'),' '),27)||
538: RPAD(NVL(to_char(L_EAM_WO_TBL(x).ROUTING_REVISION_DATE,'DD-MON-YYYY hh24:mi:ss'),' '),22);
539: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt);
540: END LOOP ;
541: END IF ;
542:
543: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,' ' );

Line 543: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,' ' );

539: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt);
540: END LOOP ;
541: END IF ;
542:
543: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,' ' );
544: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Operation Details : ' );
545:
546: IF( L_EAM_OP_TBL.Count > 0 ) THEN
547: lv_hdr_strg := ' '||'WIP_ENTITY_ID'||

Line 544: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Operation Details : ' );

540: END LOOP ;
541: END IF ;
542:
543: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,' ' );
544: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Operation Details : ' );
545:
546: IF( L_EAM_OP_TBL.Count > 0 ) THEN
547: lv_hdr_strg := ' '||'WIP_ENTITY_ID'||
548: ' '|| 'ORG_ID'||

Line 563: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_hdr_strg);

559: ||' '||'-----------------------'
560: ||' '||'--------------------------'
561: ||' '||'-----------------------------'
562: ||' '||'--------' ;
563: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_hdr_strg);
564: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_brd_stmt);
565:
566: FOR X IN 1..L_EAM_OP_TBL.Count LOOP
567: lv_dbg_stmt := ' '||rpad(NVL(to_char(L_EAM_OP_TBL(x).WIP_ENTITY_ID),' '),19)||

Line 564: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_brd_stmt);

560: ||' '||'--------------------------'
561: ||' '||'-----------------------------'
562: ||' '||'--------' ;
563: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_hdr_strg);
564: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_brd_stmt);
565:
566: FOR X IN 1..L_EAM_OP_TBL.Count LOOP
567: lv_dbg_stmt := ' '||rpad(NVL(to_char(L_EAM_OP_TBL(x).WIP_ENTITY_ID),' '),19)||
568: rpad(NVL(to_char(L_EAM_OP_TBL(x).ORGANIZATION_ID),' '),12)||

Line 577: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt);

573: rpad(NVL(to_char(L_EAM_OP_TBL(x).DESCRIPTION),' '),30)||
574: rpad(NVL(to_char(L_EAM_OP_TBL(x).LONG_DESCRIPTION),' '),35)||
575: rpad(NVL(to_char(L_EAM_OP_TBL(x).TRANSACTION_TYPE),' '),9) ;
576:
577: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt);
578:
579: END LOOP ;
580: ELSE
581: lv_dbg_stmt := ' '||'No operations found on this job' ;

Line 582: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt);

578:
579: END LOOP ;
580: ELSE
581: lv_dbg_stmt := ' '||'No operations found on this job' ;
582: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt);
583: END IF ;
584:
585: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,' ' );
586: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Resource Details : ' );

Line 585: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,' ' );

581: lv_dbg_stmt := ' '||'No operations found on this job' ;
582: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt);
583: END IF ;
584:
585: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,' ' );
586: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Resource Details : ' );
587:
588: IF( L_EAM_RES_TBL.Count > 0 ) THEN
589: lv_hdr_strg := 'HEADER_ID'

Line 586: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Resource Details : ' );

582: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt);
583: END IF ;
584:
585: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,' ' );
586: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Resource Details : ' );
587:
588: IF( L_EAM_RES_TBL.Count > 0 ) THEN
589: lv_hdr_strg := 'HEADER_ID'
590: ||' '||'BATCH_ID'

Line 625: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_hdr_strg);

621: ||' '||'-------'
622: ||' '||'---------'
623: ||' '||'---------'
624: ;
625: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_hdr_strg);
626: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_brd_stmt);
627:
628: FOR X IN 1..L_EAM_RES_TBL.Count LOOP
629:

Line 626: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_brd_stmt);

622: ||' '||'---------'
623: ||' '||'---------'
624: ;
625: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_hdr_strg);
626: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_brd_stmt);
627:
628: FOR X IN 1..L_EAM_RES_TBL.Count LOOP
629:
630: lv_dbg_stmt := RPAD(NVL(to_char(L_EAM_RES_TBL(X).HEADER_ID),' '),14)

Line 649: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt );

645: ||RPAD(NVL(to_char(L_EAM_RES_TBL(X).TRANSACTION_TYPE),' '),14)
646: ||RPAD(NVL(to_char(L_EAM_RES_TBL(X).FIRM_FLAG),' '),9) ;
647:
648:
649: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt );
650: END LOOP ;
651: ELSE
652: lv_dbg_stmt := ' '||'No Resources found on this job' ;
653: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt);

Line 653: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt);

649: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt );
650: END LOOP ;
651: ELSE
652: lv_dbg_stmt := ' '||'No Resources found on this job' ;
653: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt);
654:
655: END IF ;
656:
657: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,' ' );

Line 657: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,' ' );

653: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt);
654:
655: END IF ;
656:
657: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,' ' );
658: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Resource Instance Details : ' );
659:
660: IF( L_EAM_RES_INST_TBL.Count > 0 ) THEN
661: lv_hdr_strg := ' '||'HEADER_ID'

Line 658: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Resource Instance Details : ' );

654:
655: END IF ;
656:
657: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,' ' );
658: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Resource Instance Details : ' );
659:
660: IF( L_EAM_RES_INST_TBL.Count > 0 ) THEN
661: lv_hdr_strg := ' '||'HEADER_ID'
662: ||' '||'BATCH_ID'

Line 684: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_hdr_strg);

680: ||' '||'-------------'
681: ||' '||'-----------------------'
682: ||' '||'-----------------------'
683: ||' '||'--------' ;
684: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_hdr_strg);
685: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_brd_stmt);
686: FOR X IN 1..L_EAM_RES_INST_TBL.Count LOOP
687:
688: lv_dbg_stmt := rpad(NVL(to_char(L_EAM_RES_INST_TBL(X).HEADER_ID),' '),14)

Line 685: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_brd_stmt);

681: ||' '||'-----------------------'
682: ||' '||'-----------------------'
683: ||' '||'--------' ;
684: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_hdr_strg);
685: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_brd_stmt);
686: FOR X IN 1..L_EAM_RES_INST_TBL.Count LOOP
687:
688: lv_dbg_stmt := rpad(NVL(to_char(L_EAM_RES_INST_TBL(X).HEADER_ID),' '),14)
689: ||rpad(NVL(to_char(L_EAM_RES_INST_TBL(x).BATCH_ID),' '),13)

Line 700: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt );

696: ||rpad(NVL(to_char(L_EAM_RES_INST_TBL(x).SERIAL_NUMBER),' '),18)
697: ||rpad(NVL(to_char(L_EAM_RES_INST_TBL(x).START_DATE,'DD-MON-YYYY hh24:mi:ss'),' '),27)
698: ||rpad(NVL(to_char(L_EAM_RES_INST_TBL(x).COMPLETION_DATE,'DD-MON-YYYY hh24:mi:ss'),' '),27)
699: ||rpad(NVL(to_char(L_EAM_RES_INST_TBL(x).TRANSACTION_TYPE),' '),13) ;
700: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt );
701: END LOOP ;
702: ELSE
703: lv_dbg_stmt := ' '||'No Resource instances found on this job' ;
704: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt);

Line 704: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt);

700: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt );
701: END LOOP ;
702: ELSE
703: lv_dbg_stmt := ' '||'No Resource instances found on this job' ;
704: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt);
705:
706: END IF ;
707: /*
708: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,' ' );

Line 708: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,' ' );

704: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt);
705:
706: END IF ;
707: /*
708: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,' ' );
709: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Substitute Material Req Details : ' );
710:
711:
712: IF( L_EAM_MAT_TBL.Count > 0 ) THEN

Line 709: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Substitute Material Req Details : ' );

705:
706: END IF ;
707: /*
708: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,' ' );
709: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Substitute Material Req Details : ' );
710:
711:
712: IF( L_EAM_MAT_TBL.Count > 0 ) THEN
713: lv_hdr_strg := 'HEADER_ID'

Line 736: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_hdr_strg);

732: ||' '||'------------'
733: ||' '||'------------------'
734: ||' '||'------------'
735: ||' '||'--------' ;
736: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_hdr_strg);
737: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_brd_stmt);
738:
739:
740:

Line 737: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_brd_stmt);

733: ||' '||'------------------'
734: ||' '||'------------'
735: ||' '||'--------' ;
736: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_hdr_strg);
737: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_brd_stmt);
738:
739:
740:
741: FOR X IN 1..L_EAM_MAT_TBL.Count LOOP

Line 754: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt);

750: ||RPAD(NVL(to_char(L_EAM_MAT_TBL(x).DATE_REQUIRED,'DD-MON-YYYY hh24:mi:ss'),' '),28)
751: ||rpad(NVL(to_char(L_EAM_MAT_TBL(x).REQUIRED_QUANTITY),' '),17)
752: ||rpad(NVL(to_char(L_EAM_MAT_TBL(x).TRANSACTION_TYPE),' '),13) ;
753:
754: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt);
755: END LOOP ;
756:
757: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'After Printing Substitute Material Req Details : ' );
758: ELSE

Line 757: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'After Printing Substitute Material Req Details : ' );

753:
754: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt);
755: END LOOP ;
756:
757: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'After Printing Substitute Material Req Details : ' );
758: ELSE
759: lv_dbg_stmt := ' '||'No Substitute Material Req found on this job' ;
760: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt);
761:

Line 760: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt);

756:
757: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'After Printing Substitute Material Req Details : ' );
758: ELSE
759: lv_dbg_stmt := ' '||'No Substitute Material Req found on this job' ;
760: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt);
761:
762: END IF ;
763: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,' ' );
764: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Material Req Details : ' );

Line 763: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,' ' );

759: lv_dbg_stmt := ' '||'No Substitute Material Req found on this job' ;
760: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt);
761:
762: END IF ;
763: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,' ' );
764: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Material Req Details : ' );
765:
766:
767: IF( L_EAM_MAT_TBL.Count > 0 ) THEN

Line 764: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Material Req Details : ' );

760: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt);
761:
762: END IF ;
763: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,' ' );
764: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Material Req Details : ' );
765:
766:
767: IF( L_EAM_MAT_TBL.Count > 0 ) THEN
768: lv_hdr_strg := 'HEADER_ID'

Line 791: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_hdr_strg);

787: ||' '||'------------'
788: ||' '||'------------------'
789: ||' '||'------------'
790: ||' '||'--------' ;
791: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_hdr_strg);
792: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_brd_stmt);
793:
794:
795:

Line 792: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_brd_stmt);

788: ||' '||'------------------'
789: ||' '||'------------'
790: ||' '||'--------' ;
791: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_hdr_strg);
792: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_brd_stmt);
793:
794:
795:
796: FOR X IN 1..L_EAM_MAT_TBL.Count LOOP

Line 809: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt);

805: ||RPAD(NVL(to_char(L_EAM_MAT_TBL(x).DATE_REQUIRED,'DD-MON-YYYY hh24:mi:ss'),' '),28)
806: ||rpad(NVL(to_char(L_EAM_MAT_TBL(x).REQUIRED_QUANTITY),' '),17)
807: ||rpad(NVL(to_char(L_EAM_MAT_TBL(x).TRANSACTION_TYPE),' '),13) ;
808:
809: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt);
810: -- MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Printing Material Req Details : ' );
811: END LOOP ;
812:
813: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'After Printing Material Req Details : ' );

Line 810: -- MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Printing Material Req Details : ' );

806: ||rpad(NVL(to_char(L_EAM_MAT_TBL(x).REQUIRED_QUANTITY),' '),17)
807: ||rpad(NVL(to_char(L_EAM_MAT_TBL(x).TRANSACTION_TYPE),' '),13) ;
808:
809: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt);
810: -- MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Printing Material Req Details : ' );
811: END LOOP ;
812:
813: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'After Printing Material Req Details : ' );
814: ELSE

Line 813: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'After Printing Material Req Details : ' );

809: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt);
810: -- MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Printing Material Req Details : ' );
811: END LOOP ;
812:
813: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'After Printing Material Req Details : ' );
814: ELSE
815: lv_dbg_stmt := ' '||'No Material Req found on this job' ;
816: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt);
817:

Line 816: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt);

812:
813: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'After Printing Material Req Details : ' );
814: ELSE
815: lv_dbg_stmt := ' '||'No Material Req found on this job' ;
816: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt);
817:
818: END IF ;
819:
820: */

Line 821: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Resource usage Details : ' );

817:
818: END IF ;
819:
820: */
821: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Resource usage Details : ' );
822: IF( L_EAM_RES_USAGE_TBL.Count > 0 ) THEN
823: lv_hdr_strg := ' '||'HEADER_ID'
824: ||' '||'BATCH_ID'
825: ||' '||'WIP_ENTITY_ID'

Line 851: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_hdr_strg);

847: ||' '||'-------------'
848: ||' '||'----------'
849: ||' '||'--------' ;
850:
851: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_hdr_strg);
852: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_brd_stmt);
853:
854: FOR X IN 1..L_EAM_RES_USAGE_TBL.Count LOOP
855: lv_dbg_stmt := ' '|| rpad(L_EAM_RES_USAGE_TBL(X).HEADER_ID,9)

Line 852: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_brd_stmt);

848: ||' '||'----------'
849: ||' '||'--------' ;
850:
851: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_hdr_strg);
852: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_brd_stmt);
853:
854: FOR X IN 1..L_EAM_RES_USAGE_TBL.Count LOOP
855: lv_dbg_stmt := ' '|| rpad(L_EAM_RES_USAGE_TBL(X).HEADER_ID,9)
856: ||' '|| rpad(L_EAM_RES_USAGE_TBL(x).BATCH_ID,8)

Line 868: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt );

864: ||' '|| rpad(L_EAM_RES_USAGE_TBL(x).SERIAL_NUMBER,13)
865: ||' '|| rpad(L_EAM_RES_USAGE_TBL(x).INSTANCE_ID,11)
866: ||' '|| rpad(L_EAM_RES_USAGE_TBL(x).TRANSACTION_TYPE,8) ;
867:
868: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt );
869:
870: END LOOP ;
871: ELSE
872: lv_dbg_stmt := ' '||'No Resource Usage found on this job' ;

Line 873: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt);

869:
870: END LOOP ;
871: ELSE
872: lv_dbg_stmt := ' '||'No Resource Usage found on this job' ;
873: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt);
874:
875: END IF ;
876: -- PROPER INITIALIZATION OF APPS HERE
877: -- fnd_global.apps_initialize (l_user_id,l_responsibility_id,

Line 892: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,

888: fnd_file.get_names(g_log_file_name,g_out_file_name);
889: g_log_file_set := TRUE;
890:
891: END IF;
892: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
893: 'EAM debug output dir is: '||g_output_dir);
894: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
895: 'EAM log file name is : '||g_log_file_name);
896:

Line 894: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,

890:
891: END IF;
892: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
893: 'EAM debug output dir is: '||g_output_dir);
894: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
895: 'EAM log file name is : '||g_log_file_name);
896:
897: savepoint EAMCALL;
898:

Line 899: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,

895: 'EAM log file name is : '||g_log_file_name);
896:
897: savepoint EAMCALL;
898:
899: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
900: 'Calling API '||
901: 'EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO ');
902: FND_MSG_PUB.initialize;
903: EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO (

Line 959: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'status returned by EAM API is '||l_x_return_status);

955: -- to call an CMRO API to update the table: AHL_Schedule_materials
956: -- CMRO team will provicde a new API for this
957: --Add code for cMRO API here
958:
959: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'status returned by EAM API is '||l_x_return_status);
960: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'value of l_x_msg_count is'||l_x_msg_count);
961:
962: FOR i IN 1..l_x_msg_count LOOP
963: FND_MSG_PUB.get (

Line 960: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'value of l_x_msg_count is'||l_x_msg_count);

956: -- CMRO team will provicde a new API for this
957: --Add code for cMRO API here
958:
959: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'status returned by EAM API is '||l_x_return_status);
960: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'value of l_x_msg_count is'||l_x_msg_count);
961:
962: FOR i IN 1..l_x_msg_count LOOP
963: FND_MSG_PUB.get (
964: p_msg_index => i,

Line 968: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,

964: p_msg_index => i,
965: p_encoded => FND_API.G_FALSE,
966: p_data => x_msg_data,
967: p_msg_index_out => l_msg_index_out );
968: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
969: SubStr('x_msg_data = '||x_msg_data,1,255));
970: END LOOP;
971:
972:

Line 976: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,

972:
973: IF(l_x_return_status = FND_API.G_RET_STS_SUCCESS)
974: THEN
975:
976: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
977: 'EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO '||
978: ' returns SUCCESS');
979: -- fnd_file.put_line(FND_FILE.OUTPUT, var_buf);
980: var_buf := 'Group ID : '||g_group_id;

Line 982: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,

978: ' returns SUCCESS');
979: -- fnd_file.put_line(FND_FILE.OUTPUT, var_buf);
980: var_buf := 'Group ID : '||g_group_id;
981:
982: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
983: 'Calling API '||
984: ' AHL_MATERIALS_GRP.UPDATE_WO_MATERIALS'||
985: 'with wip_entity_id ='||V_WIP_ENTITY_ID);
986:

Line 1034: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,

1030: p_alt_item_tbl => l_alt_item_tbl);
1031:
1032: IF(l_x_return_status_ahl2 = FND_API.G_RET_STS_SUCCESS)
1033: THEN
1034: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
1035: ' AHL_MATERIALS_GRP.UPDATE_WO_MATERIALS'||
1036: ' returns SUCCESS ');
1037: FOR i IN 1..l_x_msg_count_ahl2 LOOP
1038: FND_MSG_PUB.get (

Line 1043: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,

1039: p_msg_index => i,
1040: p_encoded => FND_API.G_FALSE,
1041: p_data => l_x_msg_data_ahl2,
1042: p_msg_index_out => l_msg_index_out );
1043: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
1044: SubStr('x_msg_data2 = '||l_x_msg_data_ahl2,1,255));
1045: END LOOP;
1046: ELSE
1047: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,

Line 1047: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,

1043: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
1044: SubStr('x_msg_data2 = '||l_x_msg_data_ahl2,1,255));
1045: END LOOP;
1046: ELSE
1047: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
1048: 'AHL_MATERIALS_GRP.UPDATE_WO_MATERIALS '||
1049: 'FAILED');
1050: FOR i IN 1..l_x_msg_count_ahl2 LOOP
1051: FND_MSG_PUB.get (

Line 1056: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,

1052: p_msg_index => i,
1053: p_encoded => FND_API.G_FALSE,
1054: p_data => l_x_msg_data_ahl2,
1055: p_msg_index_out => l_msg_index_out );
1056: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
1057: SubStr('x_msg_data2 = '||l_x_msg_data_ahl2,1,255));
1058: END LOOP;
1059:
1060: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,

Line 1060: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,

1056: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
1057: SubStr('x_msg_data2 = '||l_x_msg_data_ahl2,1,255));
1058: END LOOP;
1059:
1060: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
1061: 'l_x_msg_count_ahl2 = '||l_x_msg_count_ahl2);
1062: g_retcode := MSC_UTIL.G_WARNING;
1063: END IF;
1064: /*

Line 1062: g_retcode := MSC_UTIL.G_WARNING;

1058: END LOOP;
1059:
1060: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
1061: 'l_x_msg_count_ahl2 = '||l_x_msg_count_ahl2);
1062: g_retcode := MSC_UTIL.G_WARNING;
1063: END IF;
1064: /*
1065: ELSE
1066:

Line 1067: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,

1063: END IF;
1064: /*
1065: ELSE
1066:
1067: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
1068: ' AHL_LTP_MATERIALS_GRP.Update_mtl_resv_dates'||
1069: ' did not return success ');
1070: FOR i IN 1..l_x_msg_count_ahl LOOP
1071: FND_MSG_PUB.get (

Line 1076: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,

1072: p_msg_index => i,
1073: p_encoded => FND_API.G_FALSE,
1074: p_data => l_x_msg_data_ahl,
1075: p_msg_index_out => l_msg_index_out );
1076: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
1077: SubStr('x_msg_data = '||l_x_msg_data_ahl,1,255));
1078: END LOOP;
1079:
1080: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,

Line 1080: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,

1076: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
1077: SubStr('x_msg_data = '||l_x_msg_data_ahl,1,255));
1078: END LOOP;
1079:
1080: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
1081: 'l_x_msg_count_ahl = '||l_x_msg_count_ahl);
1082: g_retcode := MSC_UTIL.G_WARNING;
1083: END IF;
1084: */ ELSE

Line 1082: g_retcode := MSC_UTIL.G_WARNING;

1078: END LOOP;
1079:
1080: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
1081: 'l_x_msg_count_ahl = '||l_x_msg_count_ahl);
1082: g_retcode := MSC_UTIL.G_WARNING;
1083: END IF;
1084: */ ELSE
1085: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
1086: 'EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO '||

Line 1085: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,

1081: 'l_x_msg_count_ahl = '||l_x_msg_count_ahl);
1082: g_retcode := MSC_UTIL.G_WARNING;
1083: END IF;
1084: */ ELSE
1085: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
1086: 'EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO '||
1087: 'FAILED');
1088: g_retcode := MSC_UTIL.G_WARNING;
1089: END IF;

Line 1088: g_retcode := MSC_UTIL.G_WARNING;

1084: */ ELSE
1085: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
1086: 'EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO '||
1087: 'FAILED');
1088: g_retcode := MSC_UTIL.G_WARNING;
1089: END IF;
1090:
1091: IF((l_x_return_status <> FND_API.G_RET_STS_SUCCESS) OR (l_x_return_status_ahl <> FND_API.G_RET_STS_SUCCESS))
1092: THEN

Line 1104: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,

1100: RETURN;
1101:
1102: EXCEPTION
1103: WHEN OTHERS THEN
1104: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
1105: ' Error in procedure process_single_wo: '||sqlerrm);
1106: g_retcode := MSC_UTIL.G_WARNING;
1107: RETURN;
1108:

Line 1106: g_retcode := MSC_UTIL.G_WARNING;

1102: EXCEPTION
1103: WHEN OTHERS THEN
1104: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
1105: ' Error in procedure process_single_wo: '||sqlerrm);
1106: g_retcode := MSC_UTIL.G_WARNING;
1107: RETURN;
1108:
1109:
1110: END PROCESS_Single_WO ;

Line 1229: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,' ' );

1225: GET_RES_DETAIL(V_WIP_ENTITY_ID, V_ORGANIZATION_ID,L_EAM_RES_TBL ) ;
1226: GET_MAT_DETAIL(V_WIP_ENTITY_ID , V_ORGANIZATION_ID ,L_EAM_MAT_TBL ) ;
1227: GET_RES_USAGE_DETAIL(V_WIP_ENTITY_ID ,V_ORGANIZATION_ID,L_EAM_RES_USAGE_TBL);
1228:
1229: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,' ' );
1230: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'EAM Work Order Details : ' );
1231:
1232:
1233: IF( L_EAM_WO_TBL.Count > 0 ) THEN

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

1226: GET_MAT_DETAIL(V_WIP_ENTITY_ID , V_ORGANIZATION_ID ,L_EAM_MAT_TBL ) ;
1227: GET_RES_USAGE_DETAIL(V_WIP_ENTITY_ID ,V_ORGANIZATION_ID,L_EAM_RES_USAGE_TBL);
1228:
1229: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,' ' );
1230: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'EAM Work Order Details : ' );
1231:
1232:
1233: IF( L_EAM_WO_TBL.Count > 0 ) THEN
1234: lv_hdr_strg := ' '||'SOURCE_CODE'||

Line 1255: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_hdr_strg);

1251: ' '||'-----------------------'||
1252: ' '||'-----------------------'||
1253: ' '||'-----------------------'||
1254: ' '||'-----------------------';
1255: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_hdr_strg);
1256: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_brd_stmt);
1257: FOR X IN 1..L_EAM_WO_TBL.Count LOOP
1258: lv_dbg_stmt := ' '||RPAD(Nvl(to_char(L_EAM_WO_TBL(x).SOURCE_CODE),' '),17)||
1259: RPAD(NVL(to_char(L_EAM_WO_TBL(x).SOURCE_LINE_ID),' '),17)||

Line 1256: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_brd_stmt);

1252: ' '||'-----------------------'||
1253: ' '||'-----------------------'||
1254: ' '||'-----------------------';
1255: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_hdr_strg);
1256: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_brd_stmt);
1257: FOR X IN 1..L_EAM_WO_TBL.Count LOOP
1258: lv_dbg_stmt := ' '||RPAD(Nvl(to_char(L_EAM_WO_TBL(x).SOURCE_CODE),' '),17)||
1259: RPAD(NVL(to_char(L_EAM_WO_TBL(x).SOURCE_LINE_ID),' '),17)||
1260: RPAD(NVL(to_char(L_EAM_WO_TBL(x).ORGANIZATION_ID),' '),12)||

Line 1268: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt);

1264: RPAD(NVL(to_char(L_EAM_WO_TBL(x).SCHEDULED_START_DATE,'DD-MON-YYYY hh24:mi:ss'),' '),27)||
1265: RPAD(NVL(to_char(L_EAM_WO_TBL(x).SCHEDULED_COMPLETION_DATE,'DD-MON-YYYY hh24:mi:ss'),' '),27)||
1266: RPAD(NVL(to_char(L_EAM_WO_TBL(x).BOM_REVISION_DATE,'DD-MON-YYYY hh24:mi:ss'),' '),27)||
1267: RPAD(NVL(to_char(L_EAM_WO_TBL(x).ROUTING_REVISION_DATE,'DD-MON-YYYY hh24:mi:ss'),' '),22);
1268: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt);
1269: END LOOP ;
1270: END IF ;
1271:
1272: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,' ' );

Line 1272: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,' ' );

1268: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt);
1269: END LOOP ;
1270: END IF ;
1271:
1272: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,' ' );
1273: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Operation Details : ' );
1274:
1275: IF( L_EAM_OP_TBL.Count > 0 ) THEN
1276: lv_hdr_strg := ' '||'WIP_ENTITY_ID'||

Line 1273: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Operation Details : ' );

1269: END LOOP ;
1270: END IF ;
1271:
1272: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,' ' );
1273: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Operation Details : ' );
1274:
1275: IF( L_EAM_OP_TBL.Count > 0 ) THEN
1276: lv_hdr_strg := ' '||'WIP_ENTITY_ID'||
1277: ' '|| 'ORG_ID'||

Line 1287: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_hdr_strg);

1283:
1284: lv_brd_stmt := ' '||'-------------'||' '||'------'||' '
1285: ||'----------'||' '||'-------'||' '||'-----------------------'
1286: ||' '||'-----------------------'||' '||'--------' ;
1287: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_hdr_strg);
1288: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_brd_stmt);
1289:
1290: FOR X IN 1..L_EAM_OP_TBL.Count LOOP
1291: lv_dbg_stmt := ' '||rpad(NVL(to_char(L_EAM_OP_TBL(x).WIP_ENTITY_ID),' '),19)||

Line 1288: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_brd_stmt);

1284: lv_brd_stmt := ' '||'-------------'||' '||'------'||' '
1285: ||'----------'||' '||'-------'||' '||'-----------------------'
1286: ||' '||'-----------------------'||' '||'--------' ;
1287: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_hdr_strg);
1288: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_brd_stmt);
1289:
1290: FOR X IN 1..L_EAM_OP_TBL.Count LOOP
1291: lv_dbg_stmt := ' '||rpad(NVL(to_char(L_EAM_OP_TBL(x).WIP_ENTITY_ID),' '),19)||
1292: rpad(NVL(to_char(L_EAM_OP_TBL(x).ORGANIZATION_ID),' '),12)||

Line 1299: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt);

1295: rpad(NVL(to_char(L_EAM_OP_TBL(x).START_DATE,'DD-MON-YYYY hh24:mi:ss'),' '),27)||
1296: rpad(NVL(to_char(L_EAM_OP_TBL(x).COMPLETION_DATE,'DD-MON-YYYY hh24:mi:ss'),' '),27)||
1297: rpad(NVL(to_char(L_EAM_OP_TBL(x).TRANSACTION_TYPE),' '),9) ;
1298:
1299: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt);
1300:
1301: END LOOP ;
1302: ELSE
1303: lv_dbg_stmt := ' '||'No operations found on this job' ;

Line 1304: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt);

1300:
1301: END LOOP ;
1302: ELSE
1303: lv_dbg_stmt := ' '||'No operations found on this job' ;
1304: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt);
1305: END IF ;
1306:
1307: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,' ' );
1308: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Resource Details : ' );

Line 1307: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,' ' );

1303: lv_dbg_stmt := ' '||'No operations found on this job' ;
1304: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt);
1305: END IF ;
1306:
1307: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,' ' );
1308: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Resource Details : ' );
1309:
1310: IF( L_EAM_RES_TBL.Count > 0 ) THEN
1311: lv_hdr_strg := 'HEADER_ID'

Line 1308: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Resource Details : ' );

1304: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt);
1305: END IF ;
1306:
1307: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,' ' );
1308: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Resource Details : ' );
1309:
1310: IF( L_EAM_RES_TBL.Count > 0 ) THEN
1311: lv_hdr_strg := 'HEADER_ID'
1312: ||' '||'BATCH_ID'

Line 1347: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_hdr_strg);

1343: ||' '||'-------'
1344: ||' '||'---------'
1345: ||' '||'---------'
1346: ;
1347: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_hdr_strg);
1348: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_brd_stmt);
1349:
1350: FOR X IN 1..L_EAM_RES_TBL.Count LOOP
1351:

Line 1348: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_brd_stmt);

1344: ||' '||'---------'
1345: ||' '||'---------'
1346: ;
1347: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_hdr_strg);
1348: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_brd_stmt);
1349:
1350: FOR X IN 1..L_EAM_RES_TBL.Count LOOP
1351:
1352: lv_dbg_stmt := RPAD(NVL(to_char(L_EAM_RES_TBL(X).HEADER_ID),' '),14)

Line 1371: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt );

1367: ||RPAD(NVL(to_char(L_EAM_RES_TBL(X).TRANSACTION_TYPE),' '),14)
1368: ||RPAD(NVL(to_char(L_EAM_RES_TBL(X).FIRM_FLAG),' '),9) ;
1369:
1370:
1371: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt );
1372: END LOOP ;
1373: ELSE
1374: lv_dbg_stmt := ' '||'No Resources found on this job' ;
1375: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt);

Line 1375: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt);

1371: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt );
1372: END LOOP ;
1373: ELSE
1374: lv_dbg_stmt := ' '||'No Resources found on this job' ;
1375: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt);
1376:
1377: END IF ;
1378:
1379: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,' ' );

Line 1379: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,' ' );

1375: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt);
1376:
1377: END IF ;
1378:
1379: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,' ' );
1380: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Resource Instance Details : ' );
1381:
1382: IF( L_EAM_RES_INST_TBL.Count > 0 ) THEN
1383: lv_hdr_strg := ' '||'HEADER_ID'

Line 1380: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Resource Instance Details : ' );

1376:
1377: END IF ;
1378:
1379: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,' ' );
1380: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Resource Instance Details : ' );
1381:
1382: IF( L_EAM_RES_INST_TBL.Count > 0 ) THEN
1383: lv_hdr_strg := ' '||'HEADER_ID'
1384: ||' '||'BATCH_ID'

Line 1406: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_hdr_strg);

1402: ||' '||'-------------'
1403: ||' '||'-----------------------'
1404: ||' '||'-----------------------'
1405: ||' '||'--------' ;
1406: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_hdr_strg);
1407: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_brd_stmt);
1408: FOR X IN 1..L_EAM_RES_INST_TBL.Count LOOP
1409:
1410: lv_dbg_stmt := rpad(NVL(to_char(L_EAM_RES_INST_TBL(X).HEADER_ID),' '),14)

Line 1407: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_brd_stmt);

1403: ||' '||'-----------------------'
1404: ||' '||'-----------------------'
1405: ||' '||'--------' ;
1406: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_hdr_strg);
1407: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_brd_stmt);
1408: FOR X IN 1..L_EAM_RES_INST_TBL.Count LOOP
1409:
1410: lv_dbg_stmt := rpad(NVL(to_char(L_EAM_RES_INST_TBL(X).HEADER_ID),' '),14)
1411: ||rpad(NVL(to_char(L_EAM_RES_INST_TBL(x).BATCH_ID),' '),13)

Line 1422: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt );

1418: ||rpad(NVL(to_char(L_EAM_RES_INST_TBL(x).SERIAL_NUMBER),' '),18)
1419: ||rpad(NVL(to_char(L_EAM_RES_INST_TBL(x).START_DATE,'DD-MON-YYYY hh24:mi:ss'),' '),27)
1420: ||rpad(NVL(to_char(L_EAM_RES_INST_TBL(x).COMPLETION_DATE,'DD-MON-YYYY hh24:mi:ss'),' '),27)
1421: ||rpad(NVL(to_char(L_EAM_RES_INST_TBL(x).TRANSACTION_TYPE),' '),13) ;
1422: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt );
1423: END LOOP ;
1424: ELSE
1425: lv_dbg_stmt := ' '||'No Resource instances found on this job' ;
1426: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt);

Line 1426: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt);

1422: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt );
1423: END LOOP ;
1424: ELSE
1425: lv_dbg_stmt := ' '||'No Resource instances found on this job' ;
1426: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt);
1427:
1428: END IF ;
1429:
1430:

Line 1431: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,' ' );

1427:
1428: END IF ;
1429:
1430:
1431: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,' ' );
1432: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Material Req Details : ' );
1433:
1434:
1435: IF( L_EAM_MAT_TBL.Count > 0 ) THEN

Line 1432: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Material Req Details : ' );

1428: END IF ;
1429:
1430:
1431: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,' ' );
1432: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Material Req Details : ' );
1433:
1434:
1435: IF( L_EAM_MAT_TBL.Count > 0 ) THEN
1436: lv_hdr_strg := 'HEADER_ID'

Line 1459: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_hdr_strg);

1455: ||' '||'------------'
1456: ||' '||'------------------'
1457: ||' '||'------------'
1458: ||' '||'--------' ;
1459: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_hdr_strg);
1460: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_brd_stmt);
1461:
1462:
1463:

Line 1460: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_brd_stmt);

1456: ||' '||'------------------'
1457: ||' '||'------------'
1458: ||' '||'--------' ;
1459: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_hdr_strg);
1460: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_brd_stmt);
1461:
1462:
1463:
1464: FOR X IN 1..L_EAM_MAT_TBL.Count LOOP

Line 1477: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt);

1473: ||RPAD(NVL(to_char(L_EAM_MAT_TBL(x).DATE_REQUIRED,'DD-MON-YYYY hh24:mi:ss'),' '),28)
1474: ||rpad(NVL(to_char(L_EAM_MAT_TBL(x).REQUIRED_QUANTITY),' '),17)
1475: ||rpad(NVL(to_char(L_EAM_MAT_TBL(x).TRANSACTION_TYPE),' '),13) ;
1476:
1477: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt);
1478: -- MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Printing Material Req Details : ' );
1479: END LOOP ;
1480:
1481: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'After Printing Material Req Details : ' );

Line 1478: -- MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Printing Material Req Details : ' );

1474: ||rpad(NVL(to_char(L_EAM_MAT_TBL(x).REQUIRED_QUANTITY),' '),17)
1475: ||rpad(NVL(to_char(L_EAM_MAT_TBL(x).TRANSACTION_TYPE),' '),13) ;
1476:
1477: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt);
1478: -- MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Printing Material Req Details : ' );
1479: END LOOP ;
1480:
1481: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'After Printing Material Req Details : ' );
1482: ELSE

Line 1481: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'After Printing Material Req Details : ' );

1477: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt);
1478: -- MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Printing Material Req Details : ' );
1479: END LOOP ;
1480:
1481: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'After Printing Material Req Details : ' );
1482: ELSE
1483: lv_dbg_stmt := ' '||'No Material Req found on this job' ;
1484: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt);
1485:

Line 1484: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt);

1480:
1481: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'After Printing Material Req Details : ' );
1482: ELSE
1483: lv_dbg_stmt := ' '||'No Material Req found on this job' ;
1484: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt);
1485:
1486: END IF ;
1487:
1488: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Resource usage Details : ' );

Line 1488: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Resource usage Details : ' );

1484: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt);
1485:
1486: END IF ;
1487:
1488: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Resource usage Details : ' );
1489: IF( L_EAM_RES_USAGE_TBL.Count > 0 ) THEN
1490: lv_hdr_strg := ' '||'HEADER_ID'
1491: ||' '||'BATCH_ID'
1492: ||' '||'WIP_ENTITY_ID'

Line 1518: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_hdr_strg);

1514: ||' '||'-------------'
1515: ||' '||'----------'
1516: ||' '||'--------' ;
1517:
1518: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_hdr_strg);
1519: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_brd_stmt);
1520:
1521: FOR X IN 1..L_EAM_RES_USAGE_TBL.Count LOOP
1522: lv_dbg_stmt := ' '|| rpad(L_EAM_RES_USAGE_TBL(X).HEADER_ID,9)

Line 1519: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_brd_stmt);

1515: ||' '||'----------'
1516: ||' '||'--------' ;
1517:
1518: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_hdr_strg);
1519: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_brd_stmt);
1520:
1521: FOR X IN 1..L_EAM_RES_USAGE_TBL.Count LOOP
1522: lv_dbg_stmt := ' '|| rpad(L_EAM_RES_USAGE_TBL(X).HEADER_ID,9)
1523: ||' '|| rpad(L_EAM_RES_USAGE_TBL(x).BATCH_ID,8)

Line 1535: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt );

1531: ||' '|| rpad(L_EAM_RES_USAGE_TBL(x).SERIAL_NUMBER,13)
1532: ||' '|| rpad(L_EAM_RES_USAGE_TBL(x).INSTANCE_ID,11)
1533: ||' '|| rpad(L_EAM_RES_USAGE_TBL(x).TRANSACTION_TYPE,8) ;
1534:
1535: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt );
1536:
1537: END LOOP ;
1538: ELSE
1539: lv_dbg_stmt := ' '||'No Resource Usage found on this job' ;

Line 1540: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt);

1536:
1537: END LOOP ;
1538: ELSE
1539: lv_dbg_stmt := ' '||'No Resource Usage found on this job' ;
1540: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_dbg_stmt);
1541:
1542: END IF ;
1543: -- PROPER INITIALIZATION OF APPS HERE
1544: -- fnd_global.apps_initialize (l_user_id,l_responsibility_id,

Line 1559: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,

1555: fnd_file.get_names(g_log_file_name,g_out_file_name);
1556: g_log_file_set := TRUE;
1557:
1558: END IF;
1559: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
1560: 'EAM debug output dir is: '||g_output_dir);
1561: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
1562: 'EAM log file name is : '||g_log_file_name);
1563:

Line 1561: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,

1557:
1558: END IF;
1559: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
1560: 'EAM debug output dir is: '||g_output_dir);
1561: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
1562: 'EAM log file name is : '||g_log_file_name);
1563:
1564: savepoint EAMCALL;
1565:

Line 1566: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,

1562: 'EAM log file name is : '||g_log_file_name);
1563:
1564: savepoint EAMCALL;
1565:
1566: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
1567: 'Calling API '||
1568: 'EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO ');
1569: FND_MSG_PUB.initialize;
1570: EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO (

Line 1626: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'status returned by EAM API is '||l_x_return_status);

1622: -- to call an CMRO API to update the table: AHL_Schedule_materials
1623: -- CMRO team will provicde a new API for this
1624: --Add code for cMRO API here
1625:
1626: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'status returned by EAM API is '||l_x_return_status);
1627: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'value of l_x_msg_count is'||l_x_msg_count);
1628:
1629: FOR i IN 1..l_x_msg_count LOOP
1630: FND_MSG_PUB.get (

Line 1627: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'value of l_x_msg_count is'||l_x_msg_count);

1623: -- CMRO team will provicde a new API for this
1624: --Add code for cMRO API here
1625:
1626: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'status returned by EAM API is '||l_x_return_status);
1627: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'value of l_x_msg_count is'||l_x_msg_count);
1628:
1629: FOR i IN 1..l_x_msg_count LOOP
1630: FND_MSG_PUB.get (
1631: p_msg_index => i,

Line 1635: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,

1631: p_msg_index => i,
1632: p_encoded => FND_API.G_FALSE,
1633: p_data => x_msg_data,
1634: p_msg_index_out => l_msg_index_out );
1635: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
1636: SubStr('x_msg_data = '||x_msg_data,1,255));
1637: END LOOP;
1638:
1639:

Line 1643: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,

1639:
1640: IF(l_x_return_status = FND_API.G_RET_STS_SUCCESS)
1641: THEN
1642:
1643: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
1644: 'EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO returns SUCCESS');
1645: -- fnd_file.put_line(FND_FILE.OUTPUT, var_buf);
1646: var_buf := 'Group ID : '||g_group_id;
1647:

Line 1655: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,

1651: ' Success ');
1652:
1653:
1654: ELSE
1655: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
1656: 'EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO FAILED');
1657: g_retcode := MSC_UTIL.G_WARNING;
1658: END IF;
1659:

Line 1657: g_retcode := MSC_UTIL.G_WARNING;

1653:
1654: ELSE
1655: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
1656: 'EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO FAILED');
1657: g_retcode := MSC_UTIL.G_WARNING;
1658: END IF;
1659:
1660: IF((l_x_return_status <> FND_API.G_RET_STS_SUCCESS) )
1661: THEN

Line 1673: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,

1669: RETURN;
1670:
1671: EXCEPTION
1672: WHEN OTHERS THEN
1673: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
1674: ' Error in procedure process_single_wo_eam: '||sqlerrm);
1675: g_retcode := MSC_UTIL.G_WARNING;
1676: RETURN;
1677:

Line 1675: g_retcode := MSC_UTIL.G_WARNING;

1671: EXCEPTION
1672: WHEN OTHERS THEN
1673: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
1674: ' Error in procedure process_single_wo_eam: '||sqlerrm);
1675: g_retcode := MSC_UTIL.G_WARNING;
1676: RETURN;
1677:
1678:
1679: END PROCESS_Single_WO_EAM ;

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

1741: L_EAM_WO_TBL.delete(L_EAM_WO_TBL.FIRST,L_EAM_WO_TBL.last);
1742: END IF;
1743:
1744:
1745: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEV, L_JOB_STMT );
1746:
1747: OPEN JOBS_CUR for L_JOB_STMT using
1748: V_WIP_ENTITY_ID,V_ORGANIZATION_ID,G_GROUP_ID ;
1749: FETCH JOBS_CUR BULK COLLECT INTO JOBS_CUR_TBL ;

Line 1751: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'SQL rowcount of JOBS_CUR is '||lv_std_job_count);

1747: OPEN JOBS_CUR for L_JOB_STMT using
1748: V_WIP_ENTITY_ID,V_ORGANIZATION_ID,G_GROUP_ID ;
1749: FETCH JOBS_CUR BULK COLLECT INTO JOBS_CUR_TBL ;
1750: lv_std_job_count := JOBS_CUR%ROWCOUNT;
1751: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'SQL rowcount of JOBS_CUR is '||lv_std_job_count);
1752: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Number of records fetched into JOBS_CUR_TBL is '||JOBS_CUR_TBL.Count);
1753:
1754: FOR y IN 1..JOBS_CUR_TBL.Count LOOP
1755:

Line 1752: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Number of records fetched into JOBS_CUR_TBL is '||JOBS_CUR_TBL.Count);

1748: V_WIP_ENTITY_ID,V_ORGANIZATION_ID,G_GROUP_ID ;
1749: FETCH JOBS_CUR BULK COLLECT INTO JOBS_CUR_TBL ;
1750: lv_std_job_count := JOBS_CUR%ROWCOUNT;
1751: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'SQL rowcount of JOBS_CUR is '||lv_std_job_count);
1752: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Number of records fetched into JOBS_CUR_TBL is '||JOBS_CUR_TBL.Count);
1753:
1754: FOR y IN 1..JOBS_CUR_TBL.Count LOOP
1755:
1756: L_EAM_WO_TBL(y).SOURCE_CODE := JOBS_CUR_TBL(y).SOURCE_CODE ;

Line 1808: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Exception in procedure GET_WO_DETAIL');

1804:
1805: EXCEPTION WHEN OTHERS THEN
1806: -- var_buf := var_proc||' 3: '||sqlerrm;
1807: -- fnd_file.put_line(FND_FILE.LOG, var_buf);
1808: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Exception in procedure GET_WO_DETAIL');
1809: RETURN;
1810:
1811: END GET_WO_DETAIL ;
1812:

Line 1854: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEV, lv_stmt );

1850:
1851: IF(L_EAM_OP_TBL.Count >0) THEN
1852: L_EAM_OP_TBL.delete(L_EAM_OP_TBL.FIRST,L_EAM_OP_TBL.last);
1853: END IF;
1854: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEV, lv_stmt );
1855:
1856: OPEN OP_CUR for lv_stmt using V_WIP_ENTITY_ID,V_ORGANIZATION_ID,G_GROUP_ID;
1857: FETCH OP_CUR BULK COLLECT INTO OP_CUR_TBL ;
1858: lv_op_count := OP_CUR%ROWCOUNT;

Line 1859: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'SQL rowcount of OP_CUR is '||lv_op_count);

1855:
1856: OPEN OP_CUR for lv_stmt using V_WIP_ENTITY_ID,V_ORGANIZATION_ID,G_GROUP_ID;
1857: FETCH OP_CUR BULK COLLECT INTO OP_CUR_TBL ;
1858: lv_op_count := OP_CUR%ROWCOUNT;
1859: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'SQL rowcount of OP_CUR is '||lv_op_count);
1860: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Number of records fetched into OP_CUR_TBL is '||OP_CUR_TBL.Count);
1861: FOR y IN 1..OP_CUR_TBL.Count LOOP
1862: -- What is the index field in these two columns
1863: -- assign l_op_index to that col and increment it in loop

Line 1860: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Number of records fetched into OP_CUR_TBL is '||OP_CUR_TBL.Count);

1856: OPEN OP_CUR for lv_stmt using V_WIP_ENTITY_ID,V_ORGANIZATION_ID,G_GROUP_ID;
1857: FETCH OP_CUR BULK COLLECT INTO OP_CUR_TBL ;
1858: lv_op_count := OP_CUR%ROWCOUNT;
1859: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'SQL rowcount of OP_CUR is '||lv_op_count);
1860: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Number of records fetched into OP_CUR_TBL is '||OP_CUR_TBL.Count);
1861: FOR y IN 1..OP_CUR_TBL.Count LOOP
1862: -- What is the index field in these two columns
1863: -- assign l_op_index to that col and increment it in loop
1864:

Line 1932: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Exception in procedure GET_OP_DETAIL');

1928: RETURN ;
1929: EXCEPTION WHEN OTHERS THEN
1930: -- var_buf := var_proc||' 4: '||sqlerrm;
1931: -- fnd_file.put_line(FND_FILE.LOG, var_buf);
1932: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Exception in procedure GET_OP_DETAIL');
1933: RETURN;
1934:
1935: END GET_OP_DETAIL ;
1936:

Line 1983: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEV, lv_stmt2 );

1979: ||' AND WJDI.LOAD_TYPE = 1 ' ;
1980: IF(L_EAM_RES_TBL.Count >0) THEN
1981: L_EAM_RES_TBL.delete(L_EAM_RES_TBL.FIRST,L_EAM_RES_TBL.last);
1982: END IF;
1983: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEV, lv_stmt2 );
1984:
1985: OPEN RES_CUR for lv_stmt2 using V_WIP_ENTITY_ID,V_ORGANIZATION_ID,G_GROUP_ID;
1986: FETCH RES_CUR BULK COLLECT INTO RES_CUR_TBL ;
1987: lv_res_count := RES_CUR%ROWCOUNT;

Line 1988: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'SQL rowcount of RES_CUR is '||lv_res_count);

1984:
1985: OPEN RES_CUR for lv_stmt2 using V_WIP_ENTITY_ID,V_ORGANIZATION_ID,G_GROUP_ID;
1986: FETCH RES_CUR BULK COLLECT INTO RES_CUR_TBL ;
1987: lv_res_count := RES_CUR%ROWCOUNT;
1988: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'SQL rowcount of RES_CUR is '||lv_res_count);
1989: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Number of records fetched into RES_CUR_TBL is '||RES_CUR_TBL.Count);
1990: FOR y IN 1..RES_CUR_TBL.Count LOOP
1991: -- Is header_id the indexing column for this ??
1992: -- L_EAM_RES_TBL(y).HEADER_ID := RES_CUR_TBL(y).PARENT_HEADER_ID ;

Line 1989: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Number of records fetched into RES_CUR_TBL is '||RES_CUR_TBL.Count);

1985: OPEN RES_CUR for lv_stmt2 using V_WIP_ENTITY_ID,V_ORGANIZATION_ID,G_GROUP_ID;
1986: FETCH RES_CUR BULK COLLECT INTO RES_CUR_TBL ;
1987: lv_res_count := RES_CUR%ROWCOUNT;
1988: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'SQL rowcount of RES_CUR is '||lv_res_count);
1989: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Number of records fetched into RES_CUR_TBL is '||RES_CUR_TBL.Count);
1990: FOR y IN 1..RES_CUR_TBL.Count LOOP
1991: -- Is header_id the indexing column for this ??
1992: -- L_EAM_RES_TBL(y).HEADER_ID := RES_CUR_TBL(y).PARENT_HEADER_ID ;
1993:

Line 2021: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Exception in procedure GET_RES_DETAIL');

2017: CLOSE RES_CUR ;
2018: RETURN ;
2019: EXCEPTION
2020: WHEN OTHERS THEN
2021: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Exception in procedure GET_RES_DETAIL');
2022: RETURN;
2023:
2024: END GET_RES_DETAIL;
2025:

Line 2064: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEV, lv_stmt2 );

2060:
2061: IF(L_EAM_MAT_TBL.Count >0) THEN
2062: L_EAM_MAT_TBL.delete(L_EAM_MAT_TBL.FIRST,L_EAM_MAT_TBL.last);
2063: END IF;
2064: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEV, lv_stmt2 );
2065:
2066: OPEN MAT_CUR for lv_stmt2 USING V_WIP_ENTITY_ID,V_ORGANIZATION_ID,G_GROUP_ID;
2067: FETCH MAT_CUR BULK COLLECT INTO MAT_CUR_TBL ;
2068: lv_mat_count := MAT_CUR%ROWCOUNT;

Line 2069: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'SQL rowcount of MAT_CUR is '||lv_mat_count);

2065:
2066: OPEN MAT_CUR for lv_stmt2 USING V_WIP_ENTITY_ID,V_ORGANIZATION_ID,G_GROUP_ID;
2067: FETCH MAT_CUR BULK COLLECT INTO MAT_CUR_TBL ;
2068: lv_mat_count := MAT_CUR%ROWCOUNT;
2069: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'SQL rowcount of MAT_CUR is '||lv_mat_count);
2070: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Number of records fetched into MAT_CUR_TBL is '||MAT_CUR_TBL.Count);
2071: FOR y IN 1..MAT_CUR_TBL.Count LOOP
2072: -- Is header_id the indexing column for this ??
2073: -- L_EAM_MAT_TBL(y).HEADER_ID := MAT_CUR_TBL(y).PARENT_HEADER_ID ;

Line 2070: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Number of records fetched into MAT_CUR_TBL is '||MAT_CUR_TBL.Count);

2066: OPEN MAT_CUR for lv_stmt2 USING V_WIP_ENTITY_ID,V_ORGANIZATION_ID,G_GROUP_ID;
2067: FETCH MAT_CUR BULK COLLECT INTO MAT_CUR_TBL ;
2068: lv_mat_count := MAT_CUR%ROWCOUNT;
2069: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'SQL rowcount of MAT_CUR is '||lv_mat_count);
2070: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Number of records fetched into MAT_CUR_TBL is '||MAT_CUR_TBL.Count);
2071: FOR y IN 1..MAT_CUR_TBL.Count LOOP
2072: -- Is header_id the indexing column for this ??
2073: -- L_EAM_MAT_TBL(y).HEADER_ID := MAT_CUR_TBL(y).PARENT_HEADER_ID ;
2074: L_EAM_MAT_TBL(y).HEADER_ID := 0 ;

Line 2100: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Exception in procedure GET_MAT_DETAIL');

2096: EXCEPTION
2097: WHEN OTHERS THEN
2098: -- var_buf := var_proc||' 6: '||sqlerrm;
2099: -- fnd_file.put_line(FND_FILE.LOG, var_buf);
2100: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Exception in procedure GET_MAT_DETAIL');
2101: RETURN;
2102:
2103: END GET_MAT_DETAIL;
2104:

Line 2154: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEV, lv_stmt2 );

2150: */
2151:
2152:
2153:
2154: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEV, lv_stmt2 );
2155:
2156: OPEN MAT_CUR for lv_stmt2 USING V_WIP_ENTITY_ID,V_ORGANIZATION_ID,G_GROUP_ID;
2157: FETCH MAT_CUR BULK COLLECT INTO TEMP_MAT_SUB_CUR_TBL;
2158: /*FETCH MAT_CUR INTO rec_sub.parent_header_id,

Line 2172: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'SQL rowcount of MAT_SUB_CUR is '||lv_mat_count);

2168: rec_sub.required_quantity ;*/
2169:
2170: lv_mat_count := MAT_CUR%ROWCOUNT;
2171:
2172: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'SQL rowcount of MAT_SUB_CUR is '||lv_mat_count);
2173:
2174: FOR y in 1..TEMP_MAT_SUB_CUR_TBL.COUNT LOOP
2175: MAT_SUB_CUR_TBL(x).PARENT_HEADER_ID := TEMP_MAT_SUB_CUR_TBL(y).PARENT_HEADER_ID;
2176: MAT_SUB_CUR_TBL(x).BATCH_ID := TEMP_MAT_SUB_CUR_TBL(y).BATCH_ID;

Line 2204: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Number of records fetched into MAT_SUB_CUR_TBL is '||MAT_SUB_CUR_TBL.Count);

2200: x := x+1;
2201: END LOOP;
2202:
2203:
2204: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Number of records fetched into MAT_SUB_CUR_TBL is '||MAT_SUB_CUR_TBL.Count);
2205:
2206: x := L_EAM_MAT_TBL.count;
2207: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Current count of L_EAM_MAT_TBL is: '||x);
2208:

Line 2207: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Current count of L_EAM_MAT_TBL is: '||x);

2203:
2204: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Number of records fetched into MAT_SUB_CUR_TBL is '||MAT_SUB_CUR_TBL.Count);
2205:
2206: x := L_EAM_MAT_TBL.count;
2207: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Current count of L_EAM_MAT_TBL is: '||x);
2208:
2209: x := x + 1;
2210:
2211:

Line 2242: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Exception in procedure GET_SUB_MAT_DETAIL'||sqlerrm);

2238: EXCEPTION
2239: WHEN OTHERS THEN
2240: -- var_buf := var_proc||' 6: '||sqlerrm;
2241: -- fnd_file.put_line(FND_FILE.LOG, var_buf);
2242: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Exception in procedure GET_SUB_MAT_DETAIL'||sqlerrm);
2243: g_retcode := MSC_UTIL.G_WARNING;
2244: RETURN;
2245:
2246: END GET_SUB_MAT_DETAIL;

Line 2243: g_retcode := MSC_UTIL.G_WARNING;

2239: WHEN OTHERS THEN
2240: -- var_buf := var_proc||' 6: '||sqlerrm;
2241: -- fnd_file.put_line(FND_FILE.LOG, var_buf);
2242: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Exception in procedure GET_SUB_MAT_DETAIL'||sqlerrm);
2243: g_retcode := MSC_UTIL.G_WARNING;
2244: RETURN;
2245:
2246: END GET_SUB_MAT_DETAIL;
2247:

Line 2290: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEV, lv_stmt2 );

2286: ||' AND WJDI.OPERATION_SEQ_NUM = WORI.OPERATION_SEQ_NUM'
2287: ||' AND WJDI.RESOURCE_SEQ_NUM = WORI.RESOURCE_SEQ_NUM';
2288:
2289:
2290: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEV, lv_stmt2 );
2291:
2292: OPEN RES_INST_CUR for lv_stmt2 using V_WIP_ENTITY_ID,V_ORGANIZATION_ID,G_GROUP_ID;
2293: FETCH RES_INST_CUR BULK COLLECT INTO RES_INST_CUR_TBL ;
2294: lv_res_inst_count := RES_INST_CUR%ROWCOUNT;

Line 2295: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'SQL rowcount of RES_INST_CUR is '||lv_res_inst_count);

2291:
2292: OPEN RES_INST_CUR for lv_stmt2 using V_WIP_ENTITY_ID,V_ORGANIZATION_ID,G_GROUP_ID;
2293: FETCH RES_INST_CUR BULK COLLECT INTO RES_INST_CUR_TBL ;
2294: lv_res_inst_count := RES_INST_CUR%ROWCOUNT;
2295: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'SQL rowcount of RES_INST_CUR is '||lv_res_inst_count);
2296: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Number of records fetched into RES_INST_CUR_TBL is '||RES_INST_CUR_TBL.Count);
2297: FOR y in 1..RES_INST_CUR_TBL.Count LOOP
2298:
2299: -- L_EAM_RES_INST_TBL(y).HEADER_ID := RES_INST_CUR_TBL(y).PARENT_HEADER_ID;

Line 2296: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Number of records fetched into RES_INST_CUR_TBL is '||RES_INST_CUR_TBL.Count);

2292: OPEN RES_INST_CUR for lv_stmt2 using V_WIP_ENTITY_ID,V_ORGANIZATION_ID,G_GROUP_ID;
2293: FETCH RES_INST_CUR BULK COLLECT INTO RES_INST_CUR_TBL ;
2294: lv_res_inst_count := RES_INST_CUR%ROWCOUNT;
2295: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'SQL rowcount of RES_INST_CUR is '||lv_res_inst_count);
2296: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Number of records fetched into RES_INST_CUR_TBL is '||RES_INST_CUR_TBL.Count);
2297: FOR y in 1..RES_INST_CUR_TBL.Count LOOP
2298:
2299: -- L_EAM_RES_INST_TBL(y).HEADER_ID := RES_INST_CUR_TBL(y).PARENT_HEADER_ID;
2300: L_EAM_RES_INST_TBL(y).HEADER_ID := 0;

Line 2318: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Exception in procedure GET_RES_INST_DETAIL');

2314: END LOOP;
2315: CLOSE RES_INST_CUR;
2316: RETURN ;
2317: EXCEPTION WHEN OTHERS THEN
2318: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Exception in procedure GET_RES_INST_DETAIL');
2319: RETURN;
2320:
2321: END GET_RES_INST_DETAIL;
2322:

Line 2351: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEV, lv_stmt2 );

2347: ||' AND WJDI.ORGANIZATION_ID = :V_ORGANIZATION_ID '
2348: ||' AND WJDI.GROUP_ID = :G_GROUP_ID'
2349: ||' AND WJDI.LOAD_TYPE = 4';
2350:
2351: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEV, lv_stmt2 );
2352: OPEN RES_USAGE_CUR for lv_stmt2 using V_WIP_ENTITY_ID,V_ORGANIZATION_ID,G_GROUP_ID;
2353: FETCH RES_USAGE_CUR BULK COLLECT INTO RES_USAGE_CUR_TBL;
2354:
2355: FOR y in 1..RES_USAGE_CUR_TBL.Count LOOP

Line 2376: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Exception in procedure GET_RES_USAGE_DETAIL');

2372:
2373: END LOOP;
2374: RETURN ;
2375: EXCEPTION WHEN OTHERS THEN
2376: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Exception in procedure GET_RES_USAGE_DETAIL');
2377: RETURN;
2378:
2379: END GET_RES_USAGE_DETAIL;
2380:

Line 2390: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1, 'In POPULATE_MISSING_DETAILS' );

2386:
2387: BEGIN
2388:
2389: var_proc := 'POPULATE_MISSING_DETAILS' ;
2390: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1, 'In POPULATE_MISSING_DETAILS' );
2391:
2392: lv_stmt2 := 'INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE'||g_dblink||'('
2393: ||' GROUP_ID '
2394: ||' ,OPERATION_SEQ_NUM '

Line 2449: -- MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1, lv_stmt2 );

2445: ||' and mwjdi.wip_entity_id = :V_WIP_ENTITY_ID'
2446: ||' and mwjdi.organization_id = :V_ORGANIZATION_ID'
2447: ||' and mwjdi.load_type = 3)';
2448:
2449: -- MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1, lv_stmt2 );
2450:
2451: EXECUTE IMMEDIATE lv_stmt2 using
2452: g_group_id
2453: ,P_JOB_START_DATE

Line 2463: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,

2459: ,g_group_id
2460: ,V_WIP_ENTITY_ID
2461: ,V_ORGANIZATION_ID;
2462:
2463: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
2464: 'Number of missing records fetched'||
2465: ' from WIP_OPERATIONS is '||SQL%RowCount);
2466: --missing resources load_type = 1
2467:

Line 2524: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1, lv_stmt2 );

2520: ||' where mwjdi.group_id = :g_group_id '
2521: ||' and mwjdi.wip_entity_id = :V_WIP_ENTITY_ID'
2522: ||' and mwjdi.organization_id = :V_ORGANIZATION_ID'
2523: ||' and mwjdi.load_type = 1)';
2524: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1, lv_stmt2 );
2525:
2526: EXECUTE IMMEDIATE lv_stmt2 using
2527: g_group_id
2528: ,P_JOB_START_DATE

Line 2536: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,

2532: ,g_group_id
2533: ,V_WIP_ENTITY_ID
2534: ,V_ORGANIZATION_ID;
2535:
2536: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
2537: 'Number of missing records fetched'||
2538: ' from WIP_OPERATION_RESOURCES is '||SQL%RowCount);
2539: --missing requirement_operations, load_type = 2
2540: lv_stmt2 := 'INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE'||g_dblink||'('

Line 2588: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1, lv_stmt2 );

2584: ||' and mwjdi.wip_entity_id = :V_WIP_ENTITY_ID'
2585: ||' and mwjdi.organization_id = :V_ORGANIZATION_ID'
2586: ||' and mwjdi.load_type = 2)';
2587:
2588: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1, lv_stmt2 );
2589:
2590: EXECUTE IMMEDIATE lv_stmt2 using
2591: g_group_id
2592: ,P_JOB_START_DATE

Line 2599: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,

2595: ,g_group_id
2596: ,V_WIP_ENTITY_ID
2597: ,V_ORGANIZATION_ID;
2598:
2599: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
2600: 'Number of missing records fetched'||
2601: ' from WIP_REQUIREMENT_OPERATIONS is '||SQL%RowCount);
2602: RETURN ;
2603: EXCEPTION WHEN OTHERS THEN

Line 2604: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Exception in procedure POPULATE_MISSING_DETAILS');

2600: 'Number of missing records fetched'||
2601: ' from WIP_REQUIREMENT_OPERATIONS is '||SQL%RowCount);
2602: RETURN ;
2603: EXCEPTION WHEN OTHERS THEN
2604: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Exception in procedure POPULATE_MISSING_DETAILS');
2605: RETURN;
2606:
2607:
2608: