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.

[Home] [Help]

APPS.MSC_CL_ROUTING_ODS_LOAD dependencies on MSC_ROUTINGS

Line 522: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTINGS', MSC_CL_COLLECTION.v_instance_id, -1);

518:
519: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
520: -- We want to delete all ROUTING related data and get new stuff.
521:
522: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTINGS', MSC_CL_COLLECTION.v_instance_id, -1);
523:
524: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
525: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTINGS', MSC_CL_COLLECTION.v_instance_id, -1);
526: ELSE

Line 525: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTINGS', MSC_CL_COLLECTION.v_instance_id, -1);

521:
522: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTINGS', MSC_CL_COLLECTION.v_instance_id, -1);
523:
524: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
525: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTINGS', MSC_CL_COLLECTION.v_instance_id, -1);
526: ELSE
527: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
528: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTINGS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
529: END IF;

Line 528: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTINGS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);

524: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
525: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTINGS', MSC_CL_COLLECTION.v_instance_id, -1);
526: ELSE
527: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
528: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTINGS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
529: END IF;
530:
531: BEGIN
532: lv_sql_ins:=

Line 533: 'INSERT INTO MSC_ROUTINGS'

529: END IF;
530:
531: BEGIN
532: lv_sql_ins:=
533: 'INSERT INTO MSC_ROUTINGS'
534: ||' (PLAN_ID,'
535: ||' ROUTING_SEQUENCE_ID,'
536: ||' ROUTING_TYPE,'
537: ||' ROUTING_COMMENT,'

Line 603: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ROUTINGS');

599:
600: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
601: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
602: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ROUTING');
603: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ROUTINGS');
604: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
605:
606: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
607: RAISE;

Line 613: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ROUTINGS');

609: ELSE
610: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
611: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
612: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ROUTING');
613: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ROUTINGS');
614: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
615:
616: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
617:

Line 636: DELETE MSC_ROUTINGS

632: FOR c_rec IN c4_d LOOP
633:
634: -- set SR_INSTANCE_ID to negative to indicate a SOFT delete
635:
636: DELETE MSC_ROUTINGS
637: WHERE PLAN_ID= -1
638: AND ROUTING_SEQUENCE_ID= c_rec.ROUTING_SEQUENCE_ID
639: AND SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID;
640:

Line 654: UPDATE MSC_ROUTINGS

650: BEGIN
651:
652: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
653:
654: UPDATE MSC_ROUTINGS
655: SET
656: ROUTING_TYPE= c_rec.ROUTING_TYPE,
657: ROUTING_COMMENT= c_rec.ROUTING_COMMENT,
658: ALTERNATE_ROUTING_DESIGNATOR= c_rec.ALTERNATE_ROUTING_DESIGNATOR,

Line 682: INSERT INTO MSC_ROUTINGS

678: END IF;
679:
680: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) OR SQL%NOTFOUND THEN
681:
682: INSERT INTO MSC_ROUTINGS
683: ( PLAN_ID,
684: ROUTING_SEQUENCE_ID,
685: ROUTING_TYPE,
686: ROUTING_COMMENT,

Line 751: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ROUTINGS');

747:
748: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
749: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
750: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ROUTING');
751: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ROUTINGS');
752: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
753:
754: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
755: RAISE;

Line 763: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ROUTINGS');

759:
760: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
761: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
762: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ROUTING');
763: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ROUTINGS');
764: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
765:
766: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
767: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSEMBLY_ITEM_NAME');