eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_CL_WIP_ODS_LOAD dependencies on MSC_UTIL

Line 6: -- v_warning_flag NUMBER:= MSC_UTIL.SYS_NO; --2 be changed

2: /* $Header: MSCLWIPB.pls 120.1 2007/04/17 10:07:26 vpalla noship $ */
3:
4: -- v_sub_str VARCHAR2(4000):=NULL;
5: -- c_count NUMBER:= 0;
6: -- v_warning_flag NUMBER:= MSC_UTIL.SYS_NO; --2 be changed
7:
8: -- G_COLLECT_SRP_DATA VARCHAR2(1) := NVL(FND_PROFILE.VALUE('MSC_SRP_ENABLED'),'N');
9: -- To collect SRP Data when this profile is set to Yes neds to be deleted
10: -- v_is_cont_refresh BOOLEAN; -- 2 be changed

Line 72: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN

68: lv_retcode NUMBER;
69:
70: BEGIN
71:
72: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
73: lv_tbl:= 'JOB_OP_RES_INSTANCES_'||MSC_CL_COLLECTION.v_instance_code;
74: lv_supplies_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
75: ELSE
76: lv_tbl:= 'MSC_JOB_OP_RES_INSTANCES';

Line 100: ||' AND resi.DELETED_FLAG= '||MSC_UTIL.SYS_YES

96: ||' AND ms.PLAN_ID= -1'
97: ||' AND ms.SR_INSTANCE_ID= resi.SR_INSTANCE_ID'
98: ||' AND ms.DISPOSITION_ID= resi.WIP_ENTITY_ID'
99: ||' AND ms.ORDER_TYPE IN ( 3, 7)'
100: ||' AND resi.DELETED_FLAG= '||MSC_UTIL.SYS_YES
101: ||' AND t1.sr_inventory_item_id (+) = resi.equipment_item_id '
102: ||' AND t1.SR_INSTANCE_ID (+) = resi.SR_INSTANCE_ID ';
103:
104:

Line 168: ||' AND resi.DELETED_FLAG= '||MSC_UTIL.SYS_NO

164: ||' AND ms.PLAN_ID= -1'
165: ||' AND ms.SR_INSTANCE_ID= resi.SR_INSTANCE_ID'
166: ||' AND ms.DISPOSITION_ID= resi.WIP_ENTITY_ID'
167: ||' AND ms.ORDER_TYPE IN ( 3, 7)'
168: ||' AND resi.DELETED_FLAG= '||MSC_UTIL.SYS_NO
169: ||' AND t1.sr_inventory_item_id (+) = resi.equipment_item_id '
170: ||' AND t1.SR_INSTANCE_ID (+) = resi.SR_INSTANCE_ID ';
171:
172: -- ========= Prepare SQL Statement for INSERT ==========

Line 211: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_sql_stmt);

207: ||' :v_current_user,'
208: ||' :v_current_date,'
209: ||' :v_current_user)';
210: --log_debug(lv_cursor_stmt);
211: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_sql_stmt);
212: OPEN cgen FOR lv_cursor_stmt;
213: IF (cgen%ISOPEN) THEN
214:
215: LOOP

Line 292: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

288: WHEN OTHERS THEN
289:
290: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
291:
292: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
293: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
294: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_RES_INSTANCE');
295: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OP_RES_INSTANCES');
296: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 296: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

292: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
293: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
294: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_RES_INSTANCE');
295: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OP_RES_INSTANCES');
296: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
297:
298: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
299: RAISE;
300:

Line 298: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

294: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_RES_INSTANCE');
295: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OP_RES_INSTANCES');
296: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
297:
298: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
299: RAISE;
300:
301: ELSE
302:

Line 303: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

299: RAISE;
300:
301: ELSE
302:
303: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
304:
305: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
306: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
307: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_RES_INSTANCE');

Line 305: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

301: ELSE
302:
303: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
304:
305: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
306: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
307: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_RES_INSTANCE');
308: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OP_RES_INSTANCES');
309: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 309: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

305: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
306: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
307: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_RES_INSTANCE');
308: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OP_RES_INSTANCES');
309: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
310:
311: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
312: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
313: FND_MESSAGE.SET_TOKEN('VALUE',

Line 316: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

312: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
313: FND_MESSAGE.SET_TOKEN('VALUE',
314: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
315: MSC_CL_COLLECTION.v_instance_id));
316: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
317:
318: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
319: END IF;
320:

Line 318: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

314: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
315: MSC_CL_COLLECTION.v_instance_id));
316: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
317:
318: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
319: END IF;
320:
321: END;
322: END LOOP;

Line 324: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Total MSC_JOB_OP_RES_INSTANCES = '|| to_char(total_count));

320:
321: END;
322: END LOOP;
323:
324: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Total MSC_JOB_OP_RES_INSTANCES = '|| to_char(total_count));
325: END IF; /* cgen%ISOPEN */
326:
327: CLOSE cgen;
328:

Line 333: IF ((MSC_CL_COLLECTION.v_coll_prec.org_group_flag <> MSC_UTIL.G_ALL_ORGANIZATIONS ) AND (MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES)) THEN

329: COMMIT;
330:
331: BEGIN
332:
333: IF ((MSC_CL_COLLECTION.v_coll_prec.org_group_flag <> MSC_UTIL.G_ALL_ORGANIZATIONS ) AND (MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES)) THEN
334:
335: lv_tbl:= 'JOB_OP_RES_INSTANCES_'||MSC_CL_COLLECTION.v_instance_code;
336:
337: lv_sql_stmt:=

Line 342: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;

338: 'INSERT INTO '||lv_tbl
339: ||' SELECT * from MSC_JOB_OP_RES_INSTANCES'
340: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
341: ||' AND plan_id = -1 '
342: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;
343:
344: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The sql statement is '||lv_sql_stmt);
345: EXECUTE IMMEDIATE lv_sql_stmt;
346:

Line 344: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The sql statement is '||lv_sql_stmt);

340: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
341: ||' AND plan_id = -1 '
342: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;
343:
344: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The sql statement is '||lv_sql_stmt);
345: EXECUTE IMMEDIATE lv_sql_stmt;
346:
347: COMMIT;
348:

Line 354: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

350:
351: EXCEPTION
352: WHEN OTHERS THEN
353:
354: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
355: RAISE;
356: END;
357:
358: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN

Line 358: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN

354: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
355: RAISE;
356: END;
357:
358: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
359: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
360: lv_retcode,
361: 'MSC_JOB_OP_RES_INSTANCES',
362: MSC_CL_COLLECTION.v_instance_code,

Line 363: MSC_UTIL.G_WARNING

359: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
360: lv_retcode,
361: 'MSC_JOB_OP_RES_INSTANCES',
362: MSC_CL_COLLECTION.v_instance_code,
363: MSC_UTIL.G_WARNING
364: );
365:
366: IF lv_retcode = MSC_UTIL.G_ERROR THEN
367: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);

Line 366: IF lv_retcode = MSC_UTIL.G_ERROR THEN

362: MSC_CL_COLLECTION.v_instance_code,
363: MSC_UTIL.G_WARNING
364: );
365:
366: IF lv_retcode = MSC_UTIL.G_ERROR THEN
367: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
368: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
369: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
370: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

Line 367: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);

363: MSC_UTIL.G_WARNING
364: );
365:
366: IF lv_retcode = MSC_UTIL.G_ERROR THEN
367: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
368: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
369: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
370: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
371: END IF;

Line 369: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN

365:
366: IF lv_retcode = MSC_UTIL.G_ERROR THEN
367: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
368: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
369: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
370: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
371: END IF;
372:
373: END IF;

Line 370: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

366: IF lv_retcode = MSC_UTIL.G_ERROR THEN
367: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
368: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
369: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
370: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
371: END IF;
372:
373: END IF;
374:

Line 380: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>');

376: WHEN OTHERS THEN
377: IF cgen%ISOPEN THEN
378: CLOSE cgen;
379: END IF;
380: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>');
381: IF lv_cursor_stmt IS NOT NULL THEN
382: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_cursor_stmt);
383: END IF;
384: IF lv_sql_stmt IS NOT NULL THEN

Line 382: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_cursor_stmt);

378: CLOSE cgen;
379: END IF;
380: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>');
381: IF lv_cursor_stmt IS NOT NULL THEN
382: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_cursor_stmt);
383: END IF;
384: IF lv_sql_stmt IS NOT NULL THEN
385: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_sql_stmt);
386: END IF;

Line 385: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_sql_stmt);

381: IF lv_cursor_stmt IS NOT NULL THEN
382: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_cursor_stmt);
383: END IF;
384: IF lv_sql_stmt IS NOT NULL THEN
385: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_sql_stmt);
386: END IF;
387: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
388: RAISE;
389: END LOAD_JOB_OP_RES_INSTANCE;

Line 387: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

383: END IF;
384: IF lv_sql_stmt IS NOT NULL THEN
385: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_sql_stmt);
386: END IF;
387: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
388: RAISE;
389: END LOAD_JOB_OP_RES_INSTANCE;
390:
391: --================================================================

Line 432: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN

428: lv_retcode NUMBER;
429:
430: BEGIN
431:
432: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
433: lv_tbl:= 'JOB_OPERATIONS_'||MSC_CL_COLLECTION.v_instance_code;
434: lv_supplies_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
435: ELSE
436: lv_tbl:= 'MSC_JOB_OPERATIONS';

Line 454: ||' AND opr.DELETED_FLAG= '||MSC_UTIL.SYS_YES;

450: ||' AND ms.PLAN_ID= -1'
451: ||' AND ms.SR_INSTANCE_ID= opr.SR_INSTANCE_ID'
452: ||' AND ms.DISPOSITION_ID= opr.WIP_ENTITY_ID'
453: ||' AND ms.ORDER_TYPE IN ( 3, 7)'
454: ||' AND opr.DELETED_FLAG= '||MSC_UTIL.SYS_YES;
455:
456: OPEN cgen FOR lv_cursor_stmt;
457:
458: IF (cgen%ISOPEN) THEN

Line 515: ||' AND opr.DELETED_FLAG= '||MSC_UTIL.SYS_NO;

511: ||' AND ms.PLAN_ID= -1'
512: ||' AND ms.SR_INSTANCE_ID= opr.SR_INSTANCE_ID'
513: ||' AND ms.DISPOSITION_ID= opr.WIP_ENTITY_ID'
514: ||' AND ms.ORDER_TYPE IN ( 3, 7)'
515: ||' AND opr.DELETED_FLAG= '||MSC_UTIL.SYS_NO;
516:
517:
518: -- ========= Prepare SQL Statement for INSERT ==========
519: lv_sql_stmt:=

Line 677: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

673: WHEN OTHERS THEN
674:
675: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
676:
677: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
678: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
679: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP');
680: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OPERATIONS');
681: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 681: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

677: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
678: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
679: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP');
680: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OPERATIONS');
681: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
682:
683: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
684: RAISE;
685:

Line 683: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

679: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP');
680: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OPERATIONS');
681: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
682:
683: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
684: RAISE;
685:
686: ELSE
687:

Line 688: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

684: RAISE;
685:
686: ELSE
687:
688: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
689:
690: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
691: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
692: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP');

Line 690: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

686: ELSE
687:
688: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
689:
690: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
691: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
692: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP');
693: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OPERATIONS');
694: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 694: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

690: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
691: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
692: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP');
693: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OPERATIONS');
694: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
695:
696: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
697: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
698: FND_MESSAGE.SET_TOKEN('VALUE',

Line 701: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

697: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
698: FND_MESSAGE.SET_TOKEN('VALUE',
699: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
700: MSC_CL_COLLECTION.v_instance_id));
701: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
702:
703: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
704: END IF;
705:

Line 703: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

699: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
700: MSC_CL_COLLECTION.v_instance_id));
701: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
702:
703: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
704: END IF;
705:
706: END;
707:

Line 710: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Total MSC_JOB_OPERATIONS = '|| total_count);

706: END;
707:
708: END LOOP;
709:
710: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Total MSC_JOB_OPERATIONS = '|| total_count);
711: END IF;
712:
713: CLOSE cgen;
714:

Line 719: IF ((MSC_CL_COLLECTION.v_coll_prec.org_group_flag <> MSC_UTIL.G_ALL_ORGANIZATIONS ) AND (MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES)) THEN

715: COMMIT;
716:
717: BEGIN
718:
719: IF ((MSC_CL_COLLECTION.v_coll_prec.org_group_flag <> MSC_UTIL.G_ALL_ORGANIZATIONS ) AND (MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES)) THEN
720:
721: lv_tbl:= 'JOB_OPERATIONS_'||MSC_CL_COLLECTION.v_instance_code;
722:
723: lv_sql_stmt:=

Line 728: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;

724: 'INSERT INTO '||lv_tbl
725: ||' SELECT * from MSC_JOB_OPERATIONS'
726: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
727: ||' AND plan_id = -1 '
728: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;
729:
730: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The sql statement is '||lv_sql_stmt);
731: EXECUTE IMMEDIATE lv_sql_stmt;
732:

Line 730: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The sql statement is '||lv_sql_stmt);

726: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
727: ||' AND plan_id = -1 '
728: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;
729:
730: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The sql statement is '||lv_sql_stmt);
731: EXECUTE IMMEDIATE lv_sql_stmt;
732:
733: COMMIT;
734:

Line 740: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

736:
737: EXCEPTION
738: WHEN OTHERS THEN
739:
740: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
741: RAISE;
742: END;
743:
744: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN

Line 744: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN

740: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
741: RAISE;
742: END;
743:
744: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
745: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
746: lv_retcode,
747: 'MSC_JOB_OPERATIONS',
748: MSC_CL_COLLECTION.v_instance_code,

Line 749: MSC_UTIL.G_WARNING

745: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
746: lv_retcode,
747: 'MSC_JOB_OPERATIONS',
748: MSC_CL_COLLECTION.v_instance_code,
749: MSC_UTIL.G_WARNING
750: );
751:
752: IF lv_retcode = MSC_UTIL.G_ERROR THEN
753: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);

Line 752: IF lv_retcode = MSC_UTIL.G_ERROR THEN

748: MSC_CL_COLLECTION.v_instance_code,
749: MSC_UTIL.G_WARNING
750: );
751:
752: IF lv_retcode = MSC_UTIL.G_ERROR THEN
753: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
754: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
755: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
756: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

Line 753: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);

749: MSC_UTIL.G_WARNING
750: );
751:
752: IF lv_retcode = MSC_UTIL.G_ERROR THEN
753: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
754: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
755: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
756: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
757: END IF;

Line 755: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN

751:
752: IF lv_retcode = MSC_UTIL.G_ERROR THEN
753: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
754: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
755: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
756: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
757: END IF;
758:
759: END IF;

Line 756: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

752: IF lv_retcode = MSC_UTIL.G_ERROR THEN
753: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
754: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
755: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
756: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
757: END IF;
758:
759: END IF;
760:

Line 765: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>');

761: EXCEPTION
762: WHEN OTHERS THEN
763: IF cgen%ISOPEN THEN CLOSE cgen; END IF;
764:
765: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>');
766: IF lv_cursor_stmt IS NOT NULL THEN
767: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_cursor_stmt);
768: END IF;
769: IF lv_sql_stmt IS NOT NULL THEN

Line 767: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_cursor_stmt);

763: IF cgen%ISOPEN THEN CLOSE cgen; END IF;
764:
765: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>');
766: IF lv_cursor_stmt IS NOT NULL THEN
767: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_cursor_stmt);
768: END IF;
769: IF lv_sql_stmt IS NOT NULL THEN
770: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_sql_stmt);
771: END IF;

Line 770: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_sql_stmt);

766: IF lv_cursor_stmt IS NOT NULL THEN
767: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_cursor_stmt);
768: END IF;
769: IF lv_sql_stmt IS NOT NULL THEN
770: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_sql_stmt);
771: END IF;
772: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
773: RAISE;
774: END LOAD_JOB_OP;

Line 772: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

768: END IF;
769: IF lv_sql_stmt IS NOT NULL THEN
770: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_sql_stmt);
771: END IF;
772: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
773: RAISE;
774: END LOAD_JOB_OP;
775:
776: --===============================================================

Line 822: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN

818: lv_retcode NUMBER;
819:
820: BEGIN
821:
822: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
823: lv_tbl:= 'JOB_OP_RESOURCES_'||MSC_CL_COLLECTION.v_instance_code;
824: lv_supplies_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
825: ELSE
826: lv_tbl:= 'MSC_JOB_OP_RESOURCES';

Line 845: ||' AND res.DELETED_FLAG= '||MSC_UTIL.SYS_YES;

841: ||' AND ms.PLAN_ID= -1'
842: ||' AND ms.SR_INSTANCE_ID= res.SR_INSTANCE_ID'
843: ||' AND ms.DISPOSITION_ID= res.WIP_ENTITY_ID'
844: ||' AND ms.ORDER_TYPE IN ( 3, 7)'
845: ||' AND res.DELETED_FLAG= '||MSC_UTIL.SYS_YES;
846:
847: OPEN cgen FOR lv_cursor_stmt;
848:
849: IF (cgen%ISOPEN) THEN

Line 915: ||' AND res.DELETED_FLAG= '||MSC_UTIL.SYS_NO;

911: ||' AND ms.PLAN_ID= -1'
912: ||' AND ms.SR_INSTANCE_ID= res.SR_INSTANCE_ID'
913: ||' AND ms.DISPOSITION_ID= res.WIP_ENTITY_ID'
914: ||' AND ms.ORDER_TYPE IN ( 3, 7)'
915: ||' AND res.DELETED_FLAG= '||MSC_UTIL.SYS_NO;
916:
917:
918: -- ========= Prepare SQL Statement for INSERT ==========
919: lv_sql_stmt:=

Line 1114: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

1110: WHEN OTHERS THEN
1111:
1112: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1113:
1114: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1115: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1116: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_RES');
1117: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OP_RESOURCES');
1118: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 1118: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

1114: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1115: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1116: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_RES');
1117: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OP_RESOURCES');
1118: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1119:
1120: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1121: RAISE;
1122:

Line 1120: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

1116: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_RES');
1117: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OP_RESOURCES');
1118: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1119:
1120: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1121: RAISE;
1122:
1123: ELSE
1124:

Line 1125: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

1121: RAISE;
1122:
1123: ELSE
1124:
1125: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1126:
1127: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1128: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1129: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_RES');

Line 1127: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

1123: ELSE
1124:
1125: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1126:
1127: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1128: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1129: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_RES');
1130: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OP_RESOURCES');
1131: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 1131: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

1127: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1128: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1129: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_RES');
1130: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OP_RESOURCES');
1131: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1132:
1133: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1134: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1135: FND_MESSAGE.SET_TOKEN('VALUE',

Line 1138: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

1134: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1135: FND_MESSAGE.SET_TOKEN('VALUE',
1136: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
1137: MSC_CL_COLLECTION.v_instance_id));
1138: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1139:
1140: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1141: END IF;
1142:

Line 1140: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

1136: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
1137: MSC_CL_COLLECTION.v_instance_id));
1138: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1139:
1140: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1141: END IF;
1142:
1143: END;
1144: END LOOP;

Line 1146: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Total MSC_JOB_OP_RESOURCES = '|| total_count);

1142:
1143: END;
1144: END LOOP;
1145:
1146: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Total MSC_JOB_OP_RESOURCES = '|| total_count);
1147: END IF;
1148:
1149: CLOSE cgen;
1150:

Line 1155: IF ((MSC_CL_COLLECTION.v_coll_prec.org_group_flag <> MSC_UTIL.G_ALL_ORGANIZATIONS ) AND (MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES)) THEN

1151: COMMIT;
1152:
1153: BEGIN
1154:
1155: IF ((MSC_CL_COLLECTION.v_coll_prec.org_group_flag <> MSC_UTIL.G_ALL_ORGANIZATIONS ) AND (MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES)) THEN
1156:
1157: lv_tbl:= 'JOB_OP_RESOURCES_'||MSC_CL_COLLECTION.v_instance_code;
1158:
1159: lv_sql_stmt:=

Line 1164: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;

1160: 'INSERT INTO '||lv_tbl
1161: ||' SELECT * from MSC_JOB_OP_RESOURCES'
1162: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
1163: ||' AND plan_id = -1 '
1164: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;
1165:
1166: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The sql statement is '||lv_sql_stmt);
1167: EXECUTE IMMEDIATE lv_sql_stmt;
1168:

Line 1166: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The sql statement is '||lv_sql_stmt);

1162: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
1163: ||' AND plan_id = -1 '
1164: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;
1165:
1166: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The sql statement is '||lv_sql_stmt);
1167: EXECUTE IMMEDIATE lv_sql_stmt;
1168:
1169: COMMIT;
1170:

Line 1176: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

1172:
1173: EXCEPTION
1174: WHEN OTHERS THEN
1175:
1176: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1177: RAISE;
1178: END;
1179:
1180: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN

Line 1180: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN

1176: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1177: RAISE;
1178: END;
1179:
1180: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
1181: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
1182: lv_retcode,
1183: 'MSC_JOB_OP_RESOURCES',
1184: MSC_CL_COLLECTION.v_instance_code,

Line 1185: MSC_UTIL.G_WARNING

1181: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
1182: lv_retcode,
1183: 'MSC_JOB_OP_RESOURCES',
1184: MSC_CL_COLLECTION.v_instance_code,
1185: MSC_UTIL.G_WARNING
1186: );
1187:
1188: IF lv_retcode = MSC_UTIL.G_ERROR THEN
1189: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);

Line 1188: IF lv_retcode = MSC_UTIL.G_ERROR THEN

1184: MSC_CL_COLLECTION.v_instance_code,
1185: MSC_UTIL.G_WARNING
1186: );
1187:
1188: IF lv_retcode = MSC_UTIL.G_ERROR THEN
1189: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
1190: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
1191: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
1192: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

Line 1189: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);

1185: MSC_UTIL.G_WARNING
1186: );
1187:
1188: IF lv_retcode = MSC_UTIL.G_ERROR THEN
1189: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
1190: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
1191: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
1192: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1193: END IF;

Line 1191: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN

1187:
1188: IF lv_retcode = MSC_UTIL.G_ERROR THEN
1189: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
1190: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
1191: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
1192: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1193: END IF;
1194:
1195: END IF;

Line 1192: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

1188: IF lv_retcode = MSC_UTIL.G_ERROR THEN
1189: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
1190: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
1191: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
1192: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1193: END IF;
1194:
1195: END IF;
1196:

Line 1201: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>');

1197: EXCEPTION
1198: WHEN OTHERS THEN
1199: IF cgen%ISOPEN THEN CLOSE cgen; END IF;
1200:
1201: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>');
1202: IF lv_cursor_stmt IS NOT NULL THEN
1203: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_cursor_stmt);
1204: END IF;
1205: IF lv_sql_stmt IS NOT NULL THEN

Line 1203: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_cursor_stmt);

1199: IF cgen%ISOPEN THEN CLOSE cgen; END IF;
1200:
1201: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>');
1202: IF lv_cursor_stmt IS NOT NULL THEN
1203: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_cursor_stmt);
1204: END IF;
1205: IF lv_sql_stmt IS NOT NULL THEN
1206: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_sql_stmt);
1207: END IF;

Line 1206: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_sql_stmt);

1202: IF lv_cursor_stmt IS NOT NULL THEN
1203: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_cursor_stmt);
1204: END IF;
1205: IF lv_sql_stmt IS NOT NULL THEN
1206: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_sql_stmt);
1207: END IF;
1208: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1209: RAISE;
1210: END LOAD_JOB_OP_RES;

Line 1208: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

1204: END IF;
1205: IF lv_sql_stmt IS NOT NULL THEN
1206: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_sql_stmt);
1207: END IF;
1208: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1209: RAISE;
1210: END LOAD_JOB_OP_RES;
1211:
1212: --=========================================================================

Line 1260: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN

1256: lv_retcode NUMBER;
1257:
1258: BEGIN
1259:
1260: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
1261: lv_tbl:= 'JOB_REQUIREMENT_OPS_'||MSC_CL_COLLECTION.v_instance_code;
1262: lv_supplies_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
1263: ELSE
1264: lv_tbl:= 'MSC_JOB_REQUIREMENT_OPS';

Line 1289: ||' AND req.DELETED_FLAG= '||MSC_UTIL.SYS_YES

1285: ||' AND ms.PLAN_ID= -1'
1286: ||' AND ms.SR_INSTANCE_ID= req.SR_INSTANCE_ID'
1287: ||' AND ms.DISPOSITION_ID= req.WIP_ENTITY_ID'
1288: ||' AND ms.ORDER_TYPE IN ( 3, 7)'
1289: ||' AND req.DELETED_FLAG= '||MSC_UTIL.SYS_YES
1290: ||' AND cmp_itm.SR_INVENTORY_ITEM_ID = req.COMPONENT_ITEM_ID'
1291: ||' AND pri_cmp.SR_INVENTORY_ITEM_ID = req.PRIMARY_COMPONENT_ID'
1292: ||' AND src_ptm.SR_INVENTORY_ITEM_ID(+) = req.SOURCE_PHANTOM_ID'
1293: ||' AND cmp_itm.SR_INSTANCE_ID = req.SR_INSTANCE_ID'

Line 1372: ||' AND req.DELETED_FLAG= '||MSC_UTIL.SYS_NO

1368: ||' AND ms.PLAN_ID= -1'
1369: ||' AND ms.SR_INSTANCE_ID= req.SR_INSTANCE_ID'
1370: ||' AND ms.DISPOSITION_ID= req.WIP_ENTITY_ID'
1371: ||' AND ms.ORDER_TYPE IN ( 3, 7)'
1372: ||' AND req.DELETED_FLAG= '||MSC_UTIL.SYS_NO
1373: ||' AND cmp_itm.SR_INVENTORY_ITEM_ID = req.COMPONENT_ITEM_ID'
1374: ||' AND pri_cmp.SR_INVENTORY_ITEM_ID = req.PRIMARY_COMPONENT_ID'
1375: ||' AND src_ptm.SR_INVENTORY_ITEM_ID(+) = req.SOURCE_PHANTOM_ID'
1376: ||' AND cmp_itm.SR_INSTANCE_ID = req.SR_INSTANCE_ID'

Line 1562: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

1558: WHEN OTHERS THEN
1559:
1560: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1561:
1562: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1563: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1564: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_REQ_OP');
1565: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_REQUIREMENT_OPS');
1566: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 1566: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

1562: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1563: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1564: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_REQ_OP');
1565: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_REQUIREMENT_OPS');
1566: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1567:
1568: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1569: RAISE;
1570:

Line 1568: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

1564: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_REQ_OP');
1565: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_REQUIREMENT_OPS');
1566: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1567:
1568: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1569: RAISE;
1570:
1571: ELSE
1572:

Line 1573: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

1569: RAISE;
1570:
1571: ELSE
1572:
1573: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1574:
1575: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1576: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1577: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_REQ_OP');

Line 1575: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

1571: ELSE
1572:
1573: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1574:
1575: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1576: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1577: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_REQ_OP');
1578: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_REQUIREMENT_OPS');
1579: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 1579: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

1575: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1576: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1577: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_REQ_OP');
1578: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_REQUIREMENT_OPS');
1579: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1580:
1581: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1582: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1583: FND_MESSAGE.SET_TOKEN('VALUE',

Line 1586: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

1582: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
1583: FND_MESSAGE.SET_TOKEN('VALUE',
1584: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
1585: MSC_CL_COLLECTION.v_instance_id));
1586: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1587:
1588: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1589: END IF;
1590:

Line 1588: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

1584: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
1585: MSC_CL_COLLECTION.v_instance_id));
1586: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1587:
1588: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1589: END IF;
1590:
1591: END;
1592:

Line 1604: IF ((MSC_CL_COLLECTION.v_coll_prec.org_group_flag <> MSC_UTIL.G_ALL_ORGANIZATIONS ) AND (MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES)) THEN

1600: COMMIT;
1601:
1602: BEGIN
1603:
1604: IF ((MSC_CL_COLLECTION.v_coll_prec.org_group_flag <> MSC_UTIL.G_ALL_ORGANIZATIONS ) AND (MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES)) THEN
1605:
1606: lv_tbl:= 'JOB_REQUIREMENT_OPS_'||MSC_CL_COLLECTION.v_instance_code;
1607:
1608: lv_sql_stmt:=

Line 1613: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;

1609: 'INSERT INTO '||lv_tbl
1610: ||' SELECT * from MSC_JOB_REQUIREMENT_OPS'
1611: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
1612: ||' AND plan_id = -1 '
1613: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;
1614:
1615: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The sql statement is '||lv_sql_stmt);
1616: EXECUTE IMMEDIATE lv_sql_stmt;
1617:

Line 1615: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The sql statement is '||lv_sql_stmt);

1611: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
1612: ||' AND plan_id = -1 '
1613: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;
1614:
1615: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The sql statement is '||lv_sql_stmt);
1616: EXECUTE IMMEDIATE lv_sql_stmt;
1617:
1618: COMMIT;
1619:

Line 1625: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

1621:
1622: EXCEPTION
1623: WHEN OTHERS THEN
1624:
1625: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1626: RAISE;
1627: END;
1628:
1629: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN

Line 1629: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN

1625: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1626: RAISE;
1627: END;
1628:
1629: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
1630: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
1631: lv_retcode,
1632: 'MSC_JOB_REQUIREMENT_OPS',
1633: MSC_CL_COLLECTION.v_instance_code,

Line 1634: MSC_UTIL.G_WARNING

1630: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
1631: lv_retcode,
1632: 'MSC_JOB_REQUIREMENT_OPS',
1633: MSC_CL_COLLECTION.v_instance_code,
1634: MSC_UTIL.G_WARNING
1635: );
1636:
1637: IF lv_retcode = MSC_UTIL.G_ERROR THEN
1638: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);

Line 1637: IF lv_retcode = MSC_UTIL.G_ERROR THEN

1633: MSC_CL_COLLECTION.v_instance_code,
1634: MSC_UTIL.G_WARNING
1635: );
1636:
1637: IF lv_retcode = MSC_UTIL.G_ERROR THEN
1638: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
1639: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
1640: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
1641: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

Line 1638: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);

1634: MSC_UTIL.G_WARNING
1635: );
1636:
1637: IF lv_retcode = MSC_UTIL.G_ERROR THEN
1638: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
1639: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
1640: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
1641: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1642: END IF;

Line 1640: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN

1636:
1637: IF lv_retcode = MSC_UTIL.G_ERROR THEN
1638: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
1639: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
1640: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
1641: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1642: END IF;
1643:
1644: END IF;

Line 1641: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

1637: IF lv_retcode = MSC_UTIL.G_ERROR THEN
1638: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
1639: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
1640: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
1641: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
1642: END IF;
1643:
1644: END IF;
1645:

Line 1650: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>');

1646: EXCEPTION
1647: WHEN OTHERS THEN
1648: IF cgen%ISOPEN THEN CLOSE cgen; END IF;
1649:
1650: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>');
1651: IF lv_cursor_stmt IS NOT NULL THEN
1652: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_cursor_stmt);
1653: END IF;
1654: IF lv_sql_stmt IS NOT NULL THEN

Line 1652: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_cursor_stmt);

1648: IF cgen%ISOPEN THEN CLOSE cgen; END IF;
1649:
1650: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>');
1651: IF lv_cursor_stmt IS NOT NULL THEN
1652: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_cursor_stmt);
1653: END IF;
1654: IF lv_sql_stmt IS NOT NULL THEN
1655: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_sql_stmt);
1656: END IF;

Line 1655: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_sql_stmt);

1651: IF lv_cursor_stmt IS NOT NULL THEN
1652: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_cursor_stmt);
1653: END IF;
1654: IF lv_sql_stmt IS NOT NULL THEN
1655: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_sql_stmt);
1656: END IF;
1657: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1658: RAISE;
1659: END LOAD_JOB_REQ_OP;

Line 1657: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

1653: END IF;
1654: IF lv_sql_stmt IS NOT NULL THEN
1655: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_sql_stmt);
1656: END IF;
1657: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1658: RAISE;
1659: END LOAD_JOB_REQ_OP;
1660: --=================================================================
1661:

Line 1703: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN

1699: lv_retcode NUMBER;
1700:
1701: BEGIN
1702:
1703: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
1704: lv_tbl:= 'JOB_OPERATION_NETWORKS_'||MSC_CL_COLLECTION.v_instance_code;
1705: lv_supplies_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
1706: ELSE
1707: lv_tbl:= 'MSC_JOB_OPERATION_NETWORKS';

Line 1727: ||' AND nwk.DELETED_FLAG= '||MSC_UTIL.SYS_YES

1723: ||' AND ms.PLAN_ID= -1'
1724: ||' AND ms.SR_INSTANCE_ID= nwk.SR_INSTANCE_ID'
1725: ||' AND ms.DISPOSITION_ID= nwk.WIP_ENTITY_ID'
1726: ||' AND ms.ORDER_TYPE IN ( 3, 7, 70)' /* ds change change: 70 eam supply */
1727: ||' AND nwk.DELETED_FLAG= '||MSC_UTIL.SYS_YES
1728: ||' AND nvl(nwk.DEPENDENCY_TYPE,4) <> 3 '; /* ds change change */
1729:
1730: /* for eam parent child dependencies */
1731: lv_eam_pc_stmt:=

Line 1748: ||' AND nwk.DELETED_FLAG= '||MSC_UTIL.SYS_YES;

1744: ||' AND ms_to.PLAN_ID= -1'
1745: ||' AND ms_to.SR_INSTANCE_ID= nwk.SR_INSTANCE_ID'
1746: ||' AND ms_to.DISPOSITION_ID= nwk.TO_WIP_ENTITY_ID'
1747: ||' AND ms_to.ORDER_TYPE = 70 '
1748: ||' AND nwk.DELETED_FLAG= '||MSC_UTIL.SYS_YES;
1749: --||' AND nwk.DEPENDENCY_TYPE = 3 ;
1750:
1751: OPEN cgen FOR lv_cursor_stmt;
1752:

Line 1853: ||' AND nwk.DELETED_FLAG= '||MSC_UTIL.SYS_NO

1849: ||' AND ms2.PLAN_ID (+) = -1' /* ds change change */
1850: ||' AND ms2.SR_INSTANCE_ID (+)= nwk.SR_INSTANCE_ID'
1851: ||' AND ms2.DISPOSITION_ID(+)= nwk.TOP_WIP_ENTITY_ID'
1852: ||' AND ms2.ORDER_TYPE(+) = 70'
1853: ||' AND nwk.DELETED_FLAG= '||MSC_UTIL.SYS_NO
1854: ||' AND nwk.FROM_ITEM_ID = t1.SR_INVENTORY_ITEM_ID(+)' /* ds change change */
1855: ||' AND nwk.sr_instance_id = t1.sr_instance_id(+) '; /* ds change change */
1856:
1857:

Line 2015: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

2011: WHEN OTHERS THEN
2012:
2013: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
2014:
2015: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2016: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2017: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_NWK');
2018: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OPERATION_NETWORKS');
2019: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 2019: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

2015: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2016: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2017: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_NWK');
2018: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OPERATION_NETWORKS');
2019: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2020:
2021: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2022: RAISE;
2023:

Line 2021: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

2017: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_NWK');
2018: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OPERATION_NETWORKS');
2019: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2020:
2021: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2022: RAISE;
2023:
2024: ELSE
2025:

Line 2026: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

2022: RAISE;
2023:
2024: ELSE
2025:
2026: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2027:
2028: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2029: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2030: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_NWK');

Line 2028: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

2024: ELSE
2025:
2026: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2027:
2028: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2029: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2030: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_NWK');
2031: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OPERATION_NETWORKS');
2032: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 2032: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

2028: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2029: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2030: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_NWK');
2031: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OPERATION_NETWORKS');
2032: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2033:
2034: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2035: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2036: FND_MESSAGE.SET_TOKEN('VALUE',

Line 2039: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

2035: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2036: FND_MESSAGE.SET_TOKEN('VALUE',
2037: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
2038: MSC_CL_COLLECTION.v_instance_id));
2039: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2040:
2041: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2042: END IF;
2043:

Line 2041: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

2037: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
2038: MSC_CL_COLLECTION.v_instance_id));
2039: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2040:
2041: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2042: END IF;
2043:
2044: END;
2045:

Line 2047: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Total MSC_JOB_OPERATION_NETWORKS = '|| total_count);

2043:
2044: END;
2045:
2046: END LOOP;
2047: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Total MSC_JOB_OPERATION_NETWORKS = '|| total_count);
2048: END IF;
2049:
2050: CLOSE cgen;
2051:

Line 2055: IF ((MSC_CL_COLLECTION.v_coll_prec.org_group_flag <> MSC_UTIL.G_ALL_ORGANIZATIONS ) AND (MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES)) THEN

2051:
2052: COMMIT;
2053:
2054: BEGIN
2055: IF ((MSC_CL_COLLECTION.v_coll_prec.org_group_flag <> MSC_UTIL.G_ALL_ORGANIZATIONS ) AND (MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES)) THEN
2056:
2057: lv_tbl:= 'JOB_OPERATION_NETWORKS_'||MSC_CL_COLLECTION.v_instance_code;
2058:
2059: lv_sql_stmt:=

Line 2064: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;

2060: 'INSERT INTO '||lv_tbl
2061: ||' SELECT * from MSC_JOB_OPERATION_NETWORKS'
2062: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
2063: ||' AND plan_id = -1 '
2064: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;
2065:
2066: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The sql statement is '||lv_sql_stmt);
2067: EXECUTE IMMEDIATE lv_sql_stmt;
2068:

Line 2066: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The sql statement is '||lv_sql_stmt);

2062: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
2063: ||' AND plan_id = -1 '
2064: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;
2065:
2066: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The sql statement is '||lv_sql_stmt);
2067: EXECUTE IMMEDIATE lv_sql_stmt;
2068:
2069: COMMIT;
2070:

Line 2076: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

2072:
2073: EXCEPTION
2074: WHEN OTHERS THEN
2075:
2076: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2077: RAISE;
2078: END;
2079:
2080: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN

Line 2080: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN

2076: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2077: RAISE;
2078: END;
2079:
2080: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
2081: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
2082: lv_retcode,
2083: 'MSC_JOB_OPERATION_NETWORKS',
2084: MSC_CL_COLLECTION.v_instance_code,

Line 2085: MSC_UTIL.G_WARNING

2081: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
2082: lv_retcode,
2083: 'MSC_JOB_OPERATION_NETWORKS',
2084: MSC_CL_COLLECTION.v_instance_code,
2085: MSC_UTIL.G_WARNING
2086: );
2087:
2088: IF lv_retcode = MSC_UTIL.G_ERROR THEN
2089: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);

Line 2088: IF lv_retcode = MSC_UTIL.G_ERROR THEN

2084: MSC_CL_COLLECTION.v_instance_code,
2085: MSC_UTIL.G_WARNING
2086: );
2087:
2088: IF lv_retcode = MSC_UTIL.G_ERROR THEN
2089: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
2090: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
2091: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
2092: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

Line 2089: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);

2085: MSC_UTIL.G_WARNING
2086: );
2087:
2088: IF lv_retcode = MSC_UTIL.G_ERROR THEN
2089: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
2090: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
2091: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
2092: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2093: END IF;

Line 2091: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN

2087:
2088: IF lv_retcode = MSC_UTIL.G_ERROR THEN
2089: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
2090: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
2091: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
2092: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2093: END IF;
2094:
2095: END IF;

Line 2092: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

2088: IF lv_retcode = MSC_UTIL.G_ERROR THEN
2089: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
2090: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
2091: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
2092: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2093: END IF;
2094:
2095: END IF;
2096:

Line 2101: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>');

2097: EXCEPTION
2098: WHEN OTHERS THEN
2099: IF cgen%ISOPEN THEN CLOSE cgen; END IF;
2100:
2101: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>');
2102: IF lv_cursor_stmt IS NOT NULL THEN
2103: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_cursor_stmt);
2104: END IF;
2105: IF lv_sql_stmt IS NOT NULL THEN

Line 2103: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_cursor_stmt);

2099: IF cgen%ISOPEN THEN CLOSE cgen; END IF;
2100:
2101: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>');
2102: IF lv_cursor_stmt IS NOT NULL THEN
2103: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_cursor_stmt);
2104: END IF;
2105: IF lv_sql_stmt IS NOT NULL THEN
2106: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_sql_stmt);
2107: END IF;

Line 2106: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_sql_stmt);

2102: IF lv_cursor_stmt IS NOT NULL THEN
2103: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_cursor_stmt);
2104: END IF;
2105: IF lv_sql_stmt IS NOT NULL THEN
2106: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_sql_stmt);
2107: END IF;
2108: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2109: RAISE;
2110: END LOAD_JOB_OP_NWK;

Line 2108: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

2104: END IF;
2105: IF lv_sql_stmt IS NOT NULL THEN
2106: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_sql_stmt);
2107: END IF;
2108: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2109: RAISE;
2110: END LOAD_JOB_OP_NWK;
2111:
2112: --=========================================================================

Line 2135: AND msrir.DELETED_FLAG= MSC_UTIL.SYS_YES;

2131: msrir.SERIAL_NUMBER,
2132: msrir.RES_INSTANCE_ID
2133: FROM MSC_ST_RESOURCE_INSTANCE_REQS msrir
2134: WHERE msrir.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
2135: AND msrir.DELETED_FLAG= MSC_UTIL.SYS_YES;
2136:
2137: lv_DEPARTMENT_ID NUMBER;
2138: lv_RESOURCE_ID NUMBER;
2139: lv_ORGANIZATION_ID NUMBER;

Line 2171: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN

2167: END IF;
2168:
2169: c_count:= 0;
2170: total_count := 0;
2171: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
2172: lv_tbl:= 'RESOURCE_INSTANCE_REQS_'||MSC_CL_COLLECTION.v_instance_code;
2173: lv_supplies_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
2174: ELSE
2175: lv_tbl:= 'MSC_RESOURCE_INSTANCE_REQS';

Line 2207: ||' AND msrir.DELETED_FLAG= '||MSC_UTIL.SYS_NO

2203: ||' AND ms.PLAN_ID= -1'
2204: ||' AND ms.SR_INSTANCE_ID= msrir.SR_INSTANCE_ID'
2205: ||' AND ms.DISPOSITION_ID= msrir.WIP_ENTITY_ID'
2206: ||' AND ms.ORDER_TYPE IN ( 3, 7,70)'
2207: ||' AND msrir.DELETED_FLAG= '||MSC_UTIL.SYS_NO
2208: ||' AND t1.sr_inventory_item_id (+) = msrir.equipment_item_id '
2209: ||' AND t1.SR_INSTANCE_ID (+) = msrir.SR_INSTANCE_ID ';
2210:
2211:

Line 2263: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) AND MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN

2259: ||' :v_current_user,'
2260: ||' :v_current_date,'
2261: ||' :v_current_user)';
2262:
2263: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) AND MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
2264: BEGIN
2265: lv_sql_ins:=
2266: 'insert into '||lv_tbl
2267: ||' ( PLAN_ID,'

Line 2322: ||' AND msrir.DELETED_FLAG= '||MSC_UTIL.SYS_NO

2318: ||' AND ms.PLAN_ID= -1 '
2319: ||' AND ms.SR_INSTANCE_ID= msrir.SR_INSTANCE_ID '
2320: ||' AND ms.DISPOSITION_ID= msrir.WIP_ENTITY_ID '
2321: ||' AND ms.ORDER_TYPE IN ( 3, 7,70) '
2322: ||' AND msrir.DELETED_FLAG= '||MSC_UTIL.SYS_NO
2323: ||' AND t1.sr_inventory_item_id (+) = msrir.equipment_item_id '
2324: ||' AND t1.SR_INSTANCE_ID (+) = msrir.SR_INSTANCE_ID ';
2325:
2326: EXECUTE IMMEDIATE lv_sql_ins

Line 2330: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'res instance req loaded');

2326: EXECUTE IMMEDIATE lv_sql_ins
2327: USING MSC_CL_COLLECTION.v_last_collection_id,MSC_CL_COLLECTION.v_current_date,MSC_CL_COLLECTION.v_current_user,MSC_CL_COLLECTION.v_current_date,MSC_CL_COLLECTION.v_current_user;
2328:
2329: COMMIT;
2330: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'res instance req loaded');
2331:
2332: EXCEPTION
2333: WHEN OTHERS THEN
2334: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN

Line 2336: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

2332: EXCEPTION
2333: WHEN OTHERS THEN
2334: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN
2335:
2336: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2337: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2338: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_REQ');
2339: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_INSTANCE_REQS');
2340: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 2340: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

2336: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2337: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2338: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_REQ');
2339: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_INSTANCE_REQS');
2340: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2341:
2342: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2343: RAISE;
2344:

Line 2342: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

2338: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_REQ');
2339: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_INSTANCE_REQS');
2340: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2341:
2342: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2343: RAISE;
2344:
2345: ELSE
2346: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

Line 2346: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

2342: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2343: RAISE;
2344:
2345: ELSE
2346: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2347: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2348: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_REQ');
2349: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_INSTANCE_REQS');
2350: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 2350: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

2346: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2347: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2348: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_REQ');
2349: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_INSTANCE_REQS');
2350: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2351:
2352: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2353:
2354: --If Direct path load results in warning then the processing has to be

Line 2352: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

2348: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_REQ');
2349: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_INSTANCE_REQS');
2350: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2351:
2352: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2353:
2354: --If Direct path load results in warning then the processing has to be
2355: --switched back to row by row processing. This will help to identify the
2356: --erroneous record and will also help in processing the rest of the records.

Line 2357: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'bulk insert failed - res instance req');

2353:
2354: --If Direct path load results in warning then the processing has to be
2355: --switched back to row by row processing. This will help to identify the
2356: --erroneous record and will also help in processing the rest of the records.
2357: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'bulk insert failed - res instance req');
2358: lb_refresh_failed := TRUE;
2359: END IF;
2360: END;
2361:

Line 2478: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

2474: WHEN OTHERS THEN
2475:
2476: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
2477:
2478: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2479: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2480: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_REQ');
2481: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_INSTANCE_REQS');
2482: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 2482: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

2478: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2479: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2480: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_REQ');
2481: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_INSTANCE_REQS');
2482: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2483:
2484: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2485: RAISE;
2486:

Line 2484: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

2480: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_REQ');
2481: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_INSTANCE_REQS');
2482: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2483:
2484: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2485: RAISE;
2486:
2487: ELSE
2488:

Line 2489: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

2485: RAISE;
2486:
2487: ELSE
2488:
2489: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2490:
2491: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2492: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2493: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_REQ');

Line 2491: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

2487: ELSE
2488:
2489: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2490:
2491: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2492: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2493: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_REQ');
2494: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_INSTANCE_REQS');
2495: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 2495: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

2491: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2492: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2493: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_REQ');
2494: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_INSTANCE_REQS');
2495: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2496:
2497: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2498:
2499: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

Line 2503: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

2499: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
2500: FND_MESSAGE.SET_TOKEN('VALUE',
2501: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
2502: MSC_CL_COLLECTION.v_instance_id));
2503: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2504:
2505: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2506: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
2507: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_DEPARTMENT_ID));

Line 2508: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

2504:
2505: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2506: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
2507: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_DEPARTMENT_ID));
2508: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2509:
2510: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2511: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
2512: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_RESOURCE_ID));

Line 2513: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

2509:
2510: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2511: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
2512: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_RESOURCE_ID));
2513: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2514:
2515: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2516: FND_MESSAGE.SET_TOKEN('COLUMN', 'RES_INSTANCE_ID');
2517: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_RES_INSTANCE_ID));

Line 2518: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

2514:
2515: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2516: FND_MESSAGE.SET_TOKEN('COLUMN', 'RES_INSTANCE_ID');
2517: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_RES_INSTANCE_ID));
2518: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2519:
2520: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2521: END IF;
2522:

Line 2520: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

2516: FND_MESSAGE.SET_TOKEN('COLUMN', 'RES_INSTANCE_ID');
2517: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_RES_INSTANCE_ID));
2518: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2519:
2520: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2521: END IF;
2522:
2523: END;
2524:

Line 2535: IF ((MSC_CL_COLLECTION.v_coll_prec.org_group_flag <> MSC_UTIL.G_ALL_ORGANIZATIONS ) AND (MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES)) THEN

2531: END IF;
2532:
2533: BEGIN
2534:
2535: IF ((MSC_CL_COLLECTION.v_coll_prec.org_group_flag <> MSC_UTIL.G_ALL_ORGANIZATIONS ) AND (MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES)) THEN
2536:
2537: lv_tbl:= 'RESOURCE_INSTANCE_REQS_'||MSC_CL_COLLECTION.v_instance_code;
2538: lv_sql_stmt:=
2539: 'INSERT INTO '||lv_tbl

Line 2543: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;

2539: 'INSERT INTO '||lv_tbl
2540: ||' SELECT * from MSC_RESOURCE_INSTANCE_REQS'
2541: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
2542: ||' AND plan_id = -1 '
2543: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;
2544:
2545:
2546: EXECUTE IMMEDIATE lv_sql_stmt;
2547:

Line 2555: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

2551:
2552: EXCEPTION
2553: WHEN OTHERS THEN
2554:
2555: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2556: RAISE;
2557: END;
2558:
2559: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN

Line 2559: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN

2555: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2556: RAISE;
2557: END;
2558:
2559: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
2560: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
2561: lv_retcode,
2562: 'MSC_RESOURCE_INSTANCE_REQS',
2563: MSC_CL_COLLECTION.v_instance_code,

Line 2564: MSC_UTIL.G_WARNING

2560: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
2561: lv_retcode,
2562: 'MSC_RESOURCE_INSTANCE_REQS',
2563: MSC_CL_COLLECTION.v_instance_code,
2564: MSC_UTIL.G_WARNING
2565: );
2566:
2567: IF lv_retcode = MSC_UTIL.G_ERROR THEN
2568: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);

Line 2567: IF lv_retcode = MSC_UTIL.G_ERROR THEN

2563: MSC_CL_COLLECTION.v_instance_code,
2564: MSC_UTIL.G_WARNING
2565: );
2566:
2567: IF lv_retcode = MSC_UTIL.G_ERROR THEN
2568: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
2569: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
2570: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
2571: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

Line 2568: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);

2564: MSC_UTIL.G_WARNING
2565: );
2566:
2567: IF lv_retcode = MSC_UTIL.G_ERROR THEN
2568: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
2569: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
2570: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
2571: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2572: END IF;

Line 2570: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN

2566:
2567: IF lv_retcode = MSC_UTIL.G_ERROR THEN
2568: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
2569: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
2570: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
2571: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2572: END IF;
2573:
2574: END IF;

Line 2571: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

2567: IF lv_retcode = MSC_UTIL.G_ERROR THEN
2568: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
2569: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
2570: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
2571: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
2572: END IF;
2573:
2574: END IF;
2575:

Line 2580: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>');

2576: EXCEPTION
2577: WHEN OTHERS THEN
2578: IF res_inst_req%ISOPEN THEN CLOSE res_inst_req; END IF;
2579:
2580: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>');
2581: IF lv_cursor_stmt IS NOT NULL THEN
2582: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_cursor_stmt);
2583: END IF;
2584: IF lv_sql_stmt IS NOT NULL THEN

Line 2582: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_cursor_stmt);

2578: IF res_inst_req%ISOPEN THEN CLOSE res_inst_req; END IF;
2579:
2580: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>');
2581: IF lv_cursor_stmt IS NOT NULL THEN
2582: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_cursor_stmt);
2583: END IF;
2584: IF lv_sql_stmt IS NOT NULL THEN
2585: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_sql_stmt);
2586: END IF;

Line 2585: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_sql_stmt);

2581: IF lv_cursor_stmt IS NOT NULL THEN
2582: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_cursor_stmt);
2583: END IF;
2584: IF lv_sql_stmt IS NOT NULL THEN
2585: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_sql_stmt);
2586: END IF;
2587: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2588: RAISE;
2589: END LOAD_RES_INST_REQ;

Line 2587: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

2583: END IF;
2584: IF lv_sql_stmt IS NOT NULL THEN
2585: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_sql_stmt);
2586: END IF;
2587: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2588: RAISE;
2589: END LOAD_RES_INST_REQ;
2590:
2591: --===================================================================

Line 2616: AND msd.DELETED_FLAG= MSC_UTIL.SYS_YES

2612: FROM MSC_ITEM_ID_LID t1,
2613: MSC_ST_DEMANDS msd
2614: WHERE msd.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
2615: AND msd.ORIGINATION_TYPE IN (2,3,4,25,50) /* ds change change 50 eam demand */
2616: AND msd.DELETED_FLAG= MSC_UTIL.SYS_YES
2617: AND t1.SR_INVENTORY_ITEM_ID(+)= msd.inventory_item_id
2618: AND t1.sr_instance_id(+)= MSC_CL_COLLECTION.v_instance_id;
2619:
2620: lv_DISPOSITION_ID NUMBER;

Line 2713: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN

2709:
2710: c_count:=0;
2711:
2712: -- ========= Prepare the Cursor Statement ==========
2713: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
2714: lv_tbl:= 'DEMANDS_'||MSC_CL_COLLECTION.v_instance_code;
2715: lv_supplies_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
2716: ELSE
2717: lv_tbl:= 'MSC_DEMANDS';

Line 2732: IF (MSC_UTIL.G_COLLECT_SRP_DATA = 'Y') Then

2728: /* 2201791 - select substr(order_number,1,62) since order_number is
2729: defined as varchar(62) in msc_demands table */
2730:
2731:
2732: IF (MSC_UTIL.G_COLLECT_SRP_DATA = 'Y') Then
2733: v_srp_profile_vlaue := 1;
2734:
2735: ELSE
2736: v_srp_profile_vlaue := 0;

Line 2786: ||' AND msd.DELETED_FLAG= '||MSC_UTIL.SYS_NO

2782: || lv_supplies_tbl||' ms,'
2783: ||' MSC_ST_DEMANDS msd'
2784: ||' WHERE msd.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
2785: ||' AND msd.ORIGINATION_TYPE IN (2,3,4,25,50)' /* 50 eam demand: ds change change*/
2786: ||' AND msd.DELETED_FLAG= '||MSC_UTIL.SYS_NO
2787: ||' AND t1.SR_INVENTORY_ITEM_ID= msd.inventory_item_id'
2788: ||' AND t1.sr_instance_id= msd.SR_INSTANCE_ID'
2789: ||' AND t2.SR_INVENTORY_ITEM_ID= msd.using_assembly_item_id'
2790: ||' AND t2.sr_instance_id= msd.SR_INSTANCE_ID'

Line 2865: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>');

2861:
2862: EXCEPTION
2863: WHEN OTHERS THEN
2864:
2865: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>');
2866: IF lv_sql_stmt IS NOT NULL THEN
2867: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'|| lv_sql_stmt);
2868: END IF;
2869: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

Line 2867: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'|| lv_sql_stmt);

2863: WHEN OTHERS THEN
2864:
2865: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>');
2866: IF lv_sql_stmt IS NOT NULL THEN
2867: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'|| lv_sql_stmt);
2868: END IF;
2869: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2870:
2871: ROLLBACK WORK TO SAVEPOINT Load_wip_SP;

Line 2869: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

2865: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>');
2866: IF lv_sql_stmt IS NOT NULL THEN
2867: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'|| lv_sql_stmt);
2868: END IF;
2869: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2870:
2871: ROLLBACK WORK TO SAVEPOINT Load_wip_SP;
2872: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Switching to Row-By-Row processing.');
2873:

Line 2872: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Switching to Row-By-Row processing.');

2868: END IF;
2869: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2870:
2871: ROLLBACK WORK TO SAVEPOINT Load_wip_SP;
2872: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Switching to Row-By-Row processing.');
2873:
2874: END;
2875: END IF;
2876:

Line 2997: ||' AND msd.DELETED_FLAG= '||MSC_UTIL.SYS_NO

2993: || lv_supplies_tbl||' ms,'
2994: ||' MSC_ST_DEMANDS msd'
2995: ||' WHERE msd.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
2996: ||' AND msd.ORIGINATION_TYPE IN (2,3,4,25,50)' /* 50 eam demand: ds change change*/
2997: ||' AND msd.DELETED_FLAG= '||MSC_UTIL.SYS_NO
2998: ||' AND t1.SR_INVENTORY_ITEM_ID= msd.inventory_item_id'
2999: ||' AND t1.sr_instance_id= msd.SR_INSTANCE_ID'
3000: ||' AND t2.SR_INVENTORY_ITEM_ID= msd.using_assembly_item_id'
3001: ||' AND t2.sr_instance_id= msd.SR_INSTANCE_ID'

Line 3141: ( lv_DELETED_FLAG<> MSC_UTIL.SYS_YES AND SQL%NOTFOUND) OR

3137:
3138: END IF; -- refresh mode
3139:
3140: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) OR
3141: ( lv_DELETED_FLAG<> MSC_UTIL.SYS_YES AND SQL%NOTFOUND) OR
3142: ( lv_ORIGINATION_TYPE= 25) THEN
3143:
3144: EXECUTE IMMEDIATE lv_sql_stmt
3145: USING

Line 3189: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

3185: WHEN OTHERS THEN
3186:
3187: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
3188:
3189: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3190: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3191: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
3192: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
3193: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 3193: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

3189: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3190: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3191: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
3192: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
3193: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3194:
3195: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3196: RAISE;
3197:

Line 3195: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

3191: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
3192: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
3193: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3194:
3195: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3196: RAISE;
3197:
3198: ELSE
3199: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

Line 3199: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

3195: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3196: RAISE;
3197:
3198: ELSE
3199: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3200:
3201: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3202: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3203: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');

Line 3201: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

3197:
3198: ELSE
3199: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3200:
3201: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3202: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3203: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
3204: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
3205: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 3205: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

3201: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3202: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3203: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
3204: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_DEMANDS');
3205: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3206:
3207: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3208: FND_MESSAGE.SET_TOKEN('COLUMN', 'WIP_ENTITY_ID');
3209: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_WIP_ENTITY_ID));

Line 3210: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

3206:
3207: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3208: FND_MESSAGE.SET_TOKEN('COLUMN', 'WIP_ENTITY_ID');
3209: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_WIP_ENTITY_ID));
3210: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3211:
3212: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3213: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
3214: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( lv_INVENTORY_ITEM_ID));

Line 3215: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

3211:
3212: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3213: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');
3214: FND_MESSAGE.SET_TOKEN('VALUE', MSC_CL_ITEM_ODS_LOAD.ITEM_NAME( lv_INVENTORY_ITEM_ID));
3215: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3216:
3217: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3218: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3219: FND_MESSAGE.SET_TOKEN('VALUE',

Line 3222: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

3218: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3219: FND_MESSAGE.SET_TOKEN('VALUE',
3220: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
3221: MSC_CL_COLLECTION.v_instance_id));
3222: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3223:
3224: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3225: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_TYPE');
3226: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_DEMAND_TYPE));

Line 3227: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

3223:
3224: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3225: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEMAND_TYPE');
3226: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_DEMAND_TYPE));
3227: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3228:
3229: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3230: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORIGINATION_TYPE');
3231: FND_MESSAGE.SET_TOKEN('VALUE',

Line 3234: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

3230: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORIGINATION_TYPE');
3231: FND_MESSAGE.SET_TOKEN('VALUE',
3232: MSC_GET_NAME.LOOKUP_MEANING('MRP_DEMAND_ORIGINATION',
3233: lv_ORIGINATION_TYPE));
3234: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3235:
3236: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3237: END IF;
3238:

Line 3236: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

3232: MSC_GET_NAME.LOOKUP_MEANING('MRP_DEMAND_ORIGINATION',
3233: lv_ORIGINATION_TYPE));
3234: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3235:
3236: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3237: END IF;
3238:
3239: END;
3240:

Line 3258: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>');

3254: EXCEPTION
3255: WHEN OTHERS THEN
3256: IF c2%ISOPEN THEN CLOSE c2; END IF;
3257:
3258: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>');
3259: IF lv_cursor_stmt IS NOT NULL THEN
3260: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_cursor_stmt);
3261: END IF;
3262: IF lv_sql_stmt IS NOT NULL THEN

Line 3260: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_cursor_stmt);

3256: IF c2%ISOPEN THEN CLOSE c2; END IF;
3257:
3258: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>');
3259: IF lv_cursor_stmt IS NOT NULL THEN
3260: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_cursor_stmt);
3261: END IF;
3262: IF lv_sql_stmt IS NOT NULL THEN
3263: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_sql_stmt);
3264: END IF;

Line 3263: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_sql_stmt);

3259: IF lv_cursor_stmt IS NOT NULL THEN
3260: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_cursor_stmt);
3261: END IF;
3262: IF lv_sql_stmt IS NOT NULL THEN
3263: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_sql_stmt);
3264: END IF;
3265: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3266: RAISE;
3267: END LOAD_WIP_DEMAND;

Line 3265: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

3261: END IF;
3262: IF lv_sql_stmt IS NOT NULL THEN
3263: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_sql_stmt);
3264: END IF;
3265: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3266: RAISE;
3267: END LOAD_WIP_DEMAND;
3268:
3269: --============================================================================

Line 3291: AND msrr.DELETED_FLAG= MSC_UTIL.SYS_YES;

3287: msrr.ORIG_RESOURCE_SEQ_NUM,
3288: msrr.SR_INSTANCE_ID
3289: FROM MSC_ST_RESOURCE_REQUIREMENTS msrr
3290: WHERE msrr.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
3291: AND msrr.DELETED_FLAG= MSC_UTIL.SYS_YES;
3292:
3293: lv_DEPARTMENT_ID NUMBER;
3294: lv_RESOURCE_ID NUMBER;
3295: lv_ASSEMBLY_ITEM_ID NUMBER;

Line 3361: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN

3357:
3358: c_count:= 0;
3359:
3360: -- ========= Prepare the Cursor Statement ==========
3361: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
3362: lv_tbl:= 'RESOURCE_REQUIREMENTS_'||MSC_CL_COLLECTION.v_instance_code;
3363: lv_supplies_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
3364: ELSE
3365: lv_tbl:= 'MSC_RESOURCE_REQUIREMENTS';

Line 3436: ||' AND msrr.DELETED_FLAG= '||MSC_UTIL.SYS_NO

3432: ||' AND ms.PLAN_ID= -1'
3433: ||' AND ms.SR_INSTANCE_ID= msrr.SR_INSTANCE_ID'
3434: ||' AND ms.DISPOSITION_ID= msrr.WIP_ENTITY_ID'
3435: ||' AND ms.ORDER_TYPE IN ( 3, 7,70)' /* 70 esm suply:ds change change */
3436: ||' AND msrr.DELETED_FLAG= '||MSC_UTIL.SYS_NO
3437: ||' AND miil.SR_INVENTORY_ITEM_ID= msrr.INVENTORY_ITEM_ID'
3438: ||' AND miil.SR_INSTANCE_ID= msrr.SR_INSTANCE_ID';
3439:
3440: -- ========= Prepare SQL Statement for INSERT ==========

Line 3557: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) AND MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN

3553: ||' :v_current_user,'
3554: ||' :v_current_date,'
3555: ||' :v_current_user)';
3556:
3557: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) AND MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
3558: BEGIN
3559: lv_sql_ins:=
3560: 'insert into '||lv_tbl
3561: ||' ( PLAN_ID,'

Line 3682: ||' AND msrr.DELETED_FLAG= '||MSC_UTIL.SYS_NO

3678: ||' AND ms.PLAN_ID= -1'
3679: ||' AND ms.SR_INSTANCE_ID= msrr.SR_INSTANCE_ID'
3680: ||' AND ms.DISPOSITION_ID= msrr.WIP_ENTITY_ID'
3681: ||' AND ms.ORDER_TYPE IN ( 3, 7,70)' /* 70 esm suply:ds change change */
3682: ||' AND msrr.DELETED_FLAG= '||MSC_UTIL.SYS_NO
3683: ||' AND miil.SR_INVENTORY_ITEM_ID= msrr.INVENTORY_ITEM_ID'
3684: ||' AND miil.SR_INSTANCE_ID= msrr.SR_INSTANCE_ID';
3685:
3686: EXECUTE IMMEDIATE lv_sql_ins

Line 3690: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'res req loaded');

3686: EXECUTE IMMEDIATE lv_sql_ins
3687: USING MSC_CL_COLLECTION.v_last_collection_id,MSC_CL_COLLECTION.v_current_date,MSC_CL_COLLECTION.v_current_user,MSC_CL_COLLECTION.v_current_date,MSC_CL_COLLECTION.v_current_user;
3688:
3689: COMMIT;
3690: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'res req loaded');
3691:
3692: EXCEPTION
3693: WHEN OTHERS THEN
3694: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN

Line 3696: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

3692: EXCEPTION
3693: WHEN OTHERS THEN
3694: IF SQLCODE IN (-01653,-01650,-01562,-01683) THEN
3695:
3696: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3697: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3698: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_REQ');
3699: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_REQUIREMENTS');
3700: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 3700: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

3696: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3697: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3698: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_REQ');
3699: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_REQUIREMENTS');
3700: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3701:
3702: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3703: RAISE;
3704:

Line 3702: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

3698: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_REQ');
3699: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_REQUIREMENTS');
3700: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3701:
3702: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3703: RAISE;
3704:
3705: ELSE
3706: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

Line 3706: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

3702: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3703: RAISE;
3704:
3705: ELSE
3706: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3707: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3708: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_REQ');
3709: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_REQUIREMENTS');
3710: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 3710: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

3706: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3707: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3708: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_REQ');
3709: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_REQUIREMENTS');
3710: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3711:
3712: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3713:
3714: --If Direct path load results in warning then the processing has to be

Line 3712: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

3708: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_REQ');
3709: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_REQUIREMENTS');
3710: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3711:
3712: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3713:
3714: --If Direct path load results in warning then the processing has to be
3715: --switched back to row by row processing. This will help to identify the
3716: --erroneous record and will also help in processing the rest of the records.

Line 3717: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'bulk insert failed - res req');

3713:
3714: --If Direct path load results in warning then the processing has to be
3715: --switched back to row by row processing. This will help to identify the
3716: --erroneous record and will also help in processing the rest of the records.
3717: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'bulk insert failed - res req');
3718: lb_refresh_failed := TRUE;
3719: END IF;
3720: END;
3721:

Line 3942: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

3938: WHEN OTHERS THEN
3939:
3940: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
3941:
3942: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3943: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3944: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
3945: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_REQUIREMENTS');
3946: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 3946: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

3942: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3943: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3944: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
3945: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_REQUIREMENTS');
3946: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3947:
3948: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3949: RAISE;
3950:

Line 3948: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

3944: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
3945: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_REQUIREMENTS');
3946: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3947:
3948: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3949: RAISE;
3950:
3951: ELSE
3952:

Line 3953: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

3949: RAISE;
3950:
3951: ELSE
3952:
3953: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3954:
3955: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3956: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3957: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');

Line 3955: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');

3951: ELSE
3952:
3953: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
3954:
3955: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3956: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3957: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
3958: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_REQUIREMENTS');
3959: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

Line 3959: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

3955: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3956: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3957: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLY');
3958: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RESOURCE_REQUIREMENTS');
3959: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3960:
3961: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3962: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3963: FND_MESSAGE.SET_TOKEN('VALUE',

Line 3966: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

3962: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');
3963: FND_MESSAGE.SET_TOKEN('VALUE',
3964: MSC_GET_NAME.ORG_CODE( lv_ORGANIZATION_ID,
3965: MSC_CL_COLLECTION.v_instance_id));
3966: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3967:
3968: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3969: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
3970: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_DEPARTMENT_ID));

Line 3971: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

3967:
3968: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3969: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');
3970: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_DEPARTMENT_ID));
3971: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3972:
3973: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3974: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
3975: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_RESOURCE_ID));

Line 3976: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);

3972:
3973: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3974: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
3975: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_RESOURCE_ID));
3976: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3977:
3978: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3979: END IF;
3980:

Line 3978: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

3974: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');
3975: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(lv_RESOURCE_ID));
3976: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3977:
3978: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3979: END IF;
3980:
3981: END;
3982:

Line 3993: IF ((MSC_CL_COLLECTION.v_coll_prec.org_group_flag <> MSC_UTIL.G_ALL_ORGANIZATIONS ) AND (MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES)) THEN

3989: END IF;
3990:
3991: BEGIN
3992:
3993: IF ((MSC_CL_COLLECTION.v_coll_prec.org_group_flag <> MSC_UTIL.G_ALL_ORGANIZATIONS ) AND (MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES)) THEN
3994:
3995: lv_tbl:= 'RESOURCE_REQUIREMENTS_'||MSC_CL_COLLECTION.v_instance_code;
3996:
3997: lv_sql_stmt:=

Line 4002: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;

3998: 'INSERT INTO '||lv_tbl
3999: ||' SELECT * from MSC_RESOURCE_REQUIREMENTS'
4000: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
4001: ||' AND plan_id = -1 '
4002: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;
4003:
4004: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The sql statement is '||lv_sql_stmt);
4005: EXECUTE IMMEDIATE lv_sql_stmt;
4006:

Line 4004: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The sql statement is '||lv_sql_stmt);

4000: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
4001: ||' AND plan_id = -1 '
4002: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;
4003:
4004: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The sql statement is '||lv_sql_stmt);
4005: EXECUTE IMMEDIATE lv_sql_stmt;
4006:
4007: COMMIT;
4008:

Line 4014: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

4010:
4011: EXCEPTION
4012: WHEN OTHERS THEN
4013:
4014: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4015: RAISE;
4016: END;
4017:
4018: MSC_CL_BOM_ODS_LOAD.LOAD_RESOURCE_CHARGES; /* ds change */

Line 4020: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN

4016: END;
4017:
4018: MSC_CL_BOM_ODS_LOAD.LOAD_RESOURCE_CHARGES; /* ds change */
4019:
4020: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
4021: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
4022: lv_retcode,
4023: 'MSC_RESOURCE_REQUIREMENTS',
4024: MSC_CL_COLLECTION.v_instance_code,

Line 4025: MSC_UTIL.G_WARNING

4021: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
4022: lv_retcode,
4023: 'MSC_RESOURCE_REQUIREMENTS',
4024: MSC_CL_COLLECTION.v_instance_code,
4025: MSC_UTIL.G_WARNING
4026: );
4027:
4028: IF lv_retcode = MSC_UTIL.G_ERROR THEN
4029: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);

Line 4028: IF lv_retcode = MSC_UTIL.G_ERROR THEN

4024: MSC_CL_COLLECTION.v_instance_code,
4025: MSC_UTIL.G_WARNING
4026: );
4027:
4028: IF lv_retcode = MSC_UTIL.G_ERROR THEN
4029: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
4030: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
4031: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
4032: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

Line 4029: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);

4025: MSC_UTIL.G_WARNING
4026: );
4027:
4028: IF lv_retcode = MSC_UTIL.G_ERROR THEN
4029: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
4030: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
4031: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
4032: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
4033: END IF;

Line 4031: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN

4027:
4028: IF lv_retcode = MSC_UTIL.G_ERROR THEN
4029: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
4030: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
4031: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
4032: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
4033: END IF;
4034:
4035: END IF;

Line 4032: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;

4028: IF lv_retcode = MSC_UTIL.G_ERROR THEN
4029: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, lv_errbuf);
4030: RAISE MSC_CL_COLLECTION.ALTER_TEMP_TABLE_ERROR;
4031: ELSIF lv_retcode = MSC_UTIL.G_WARNING THEN
4032: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
4033: END IF;
4034:
4035: END IF;
4036:

Line 4041: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>');

4037: EXCEPTION
4038: WHEN OTHERS THEN
4039: IF c4%ISOPEN THEN CLOSE c4; END IF;
4040:
4041: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>');
4042: IF lv_cursor_stmt IS NOT NULL THEN
4043: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_cursor_stmt);
4044: END IF;
4045: IF lv_sql_stmt IS NOT NULL THEN

Line 4043: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_cursor_stmt);

4039: IF c4%ISOPEN THEN CLOSE c4; END IF;
4040:
4041: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>');
4042: IF lv_cursor_stmt IS NOT NULL THEN
4043: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_cursor_stmt);
4044: END IF;
4045: IF lv_sql_stmt IS NOT NULL THEN
4046: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_sql_stmt);
4047: END IF;

Line 4046: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_sql_stmt);

4042: IF lv_cursor_stmt IS NOT NULL THEN
4043: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_cursor_stmt);
4044: END IF;
4045: IF lv_sql_stmt IS NOT NULL THEN
4046: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_sql_stmt);
4047: END IF;
4048: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4049: RAISE;
4050: END LOAD_RES_REQ;

Line 4048: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

4044: END IF;
4045: IF lv_sql_stmt IS NOT NULL THEN
4046: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||lv_sql_stmt);
4047: END IF;
4048: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4049: RAISE;
4050: END LOAD_RES_REQ;
4051:
4052: --=============================================================================