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_PRE_PROCESS dependencies on MSC_ST_ROUTINGS

Line 816: 'create index MSC_ST_ROUTINGS_N1_'||v_instance_code

812: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
813: application_short_name => 'MSC',
814: statement_type => AD_DDL.CREATE_INDEX,
815: statement =>
816: 'create index MSC_ST_ROUTINGS_N1_'||v_instance_code
817: ||' on MSC_ST_ROUTINGS '
818: ||'(sr_instance_code, assembly_name, organization_code, company_name, routing_name, alternate_routing_designator) '
819: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
820: object_name =>'MSC_ST_ROUTINGS_N1_'||v_instance_code);

Line 817: ||' on MSC_ST_ROUTINGS '

813: application_short_name => 'MSC',
814: statement_type => AD_DDL.CREATE_INDEX,
815: statement =>
816: 'create index MSC_ST_ROUTINGS_N1_'||v_instance_code
817: ||' on MSC_ST_ROUTINGS '
818: ||'(sr_instance_code, assembly_name, organization_code, company_name, routing_name, alternate_routing_designator) '
819: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
820: object_name =>'MSC_ST_ROUTINGS_N1_'||v_instance_code);
821:

Line 820: object_name =>'MSC_ST_ROUTINGS_N1_'||v_instance_code);

816: 'create index MSC_ST_ROUTINGS_N1_'||v_instance_code
817: ||' on MSC_ST_ROUTINGS '
818: ||'(sr_instance_code, assembly_name, organization_code, company_name, routing_name, alternate_routing_designator) '
819: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
820: object_name =>'MSC_ST_ROUTINGS_N1_'||v_instance_code);
821:
822: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_ROUTINGS_N1_'||v_instance_code);
823:
824: EXCEPTION

Line 822: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_ROUTINGS_N1_'||v_instance_code);

818: ||'(sr_instance_code, assembly_name, organization_code, company_name, routing_name, alternate_routing_designator) '
819: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
820: object_name =>'MSC_ST_ROUTINGS_N1_'||v_instance_code);
821:
822: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_ROUTINGS_N1_'||v_instance_code);
823:
824: EXCEPTION
825: WHEN OTHERS THEN
826: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_ROUTINGS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));

Line 826: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_ROUTINGS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));

822: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_ROUTINGS_N1_'||v_instance_code);
823:
824: EXCEPTION
825: WHEN OTHERS THEN
826: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_ROUTINGS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
827: END;
828:
829: BEGIN
830: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

Line 885: msc_analyse_tables_pk.analyse_table( 'MSC_ST_ROUTINGS', v_instance_id, -1);

881: WHEN OTHERS THEN
882: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_OPER_NTWK_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
883: END;
884:
885: msc_analyse_tables_pk.analyse_table( 'MSC_ST_ROUTINGS', v_instance_id, -1);
886: msc_analyse_tables_pk.analyse_table( 'MSC_ST_OPERATION_RESOURCES', v_instance_id, -1);
887: msc_analyse_tables_pk.analyse_table( 'MSC_ST_ROUTING_OPERATIONS', v_instance_id, -1);
888: msc_analyse_tables_pk.analyse_table( 'MSC_ST_OPERATION_NETWORKS', v_instance_id, -1);
889:

Line 2092: 'drop index MSC_ST_ROUTINGS_N1_'||v_instance_code,

2088: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2089: application_short_name => 'MSC',
2090: statement_type => AD_DDL.DROP_INDEX,
2091: statement =>
2092: 'drop index MSC_ST_ROUTINGS_N1_'||v_instance_code,
2093: object_name => 'MSC_ST_ROUTINGS_N1_'||v_instance_code);
2094:
2095: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_ROUTINGS_N1_'||v_instance_code);
2096: EXCEPTION

Line 2093: object_name => 'MSC_ST_ROUTINGS_N1_'||v_instance_code);

2089: application_short_name => 'MSC',
2090: statement_type => AD_DDL.DROP_INDEX,
2091: statement =>
2092: 'drop index MSC_ST_ROUTINGS_N1_'||v_instance_code,
2093: object_name => 'MSC_ST_ROUTINGS_N1_'||v_instance_code);
2094:
2095: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_ROUTINGS_N1_'||v_instance_code);
2096: EXCEPTION
2097: WHEN OTHERS THEN

Line 2095: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_ROUTINGS_N1_'||v_instance_code);

2091: statement =>
2092: 'drop index MSC_ST_ROUTINGS_N1_'||v_instance_code,
2093: object_name => 'MSC_ST_ROUTINGS_N1_'||v_instance_code);
2094:
2095: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_ROUTINGS_N1_'||v_instance_code);
2096: EXCEPTION
2097: WHEN OTHERS THEN
2098: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_ROUTINGS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
2099: END;

Line 2098: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_ROUTINGS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));

2094:
2095: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_ROUTINGS_N1_'||v_instance_code);
2096: EXCEPTION
2097: WHEN OTHERS THEN
2098: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_ROUTINGS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
2099: END;
2100:
2101: BEGIN
2102: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

Line 43474: lv_batch_id msc_st_routings.batch_id%TYPE;

43470: lv_error_text VARCHAR2(250);
43471: lv_where_str VARCHAR2(5000);
43472: lv_sql_stmt VARCHAR2(5000);
43473: lv_cursor_stmt VARCHAR2(5000);
43474: lv_batch_id msc_st_routings.batch_id%TYPE;
43475: lv_message_text msc_errors.error_text%TYPE;
43476: ex_logging_err EXCEPTION;
43477:
43478:

Line 43481: FROM msc_st_routings

43477:
43478:
43479: CURSOR c2(p_batch_id NUMBER) IS
43480: SELECT rowid
43481: FROM msc_st_routings
43482: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
43483: AND sr_instance_code = v_instance_code
43484: AND batch_id = p_batch_id;
43485:

Line 43488: FROM msc_st_routings

43484: AND batch_id = p_batch_id;
43485:
43486: CURSOR c3(p_batch_id NUMBER) IS
43487: SELECT rowid
43488: FROM msc_st_routings
43489: WHERE process_flag = G_IN_PROCESS
43490: AND sr_instance_code = v_instance_code
43491: AND batch_id = p_batch_id
43492: AND NVL(routing_sequence_id,NULL_VALUE) = NULL_VALUE

Line 43582: 'UPDATE msc_st_routings msr1'

43578: -- Duplicate UDK validation for XML message
43579:
43580: v_sql_stmt := 01;
43581: lv_sql_stmt :=
43582: 'UPDATE msc_st_routings msr1'
43583: ||' SET process_flag = '||G_ERROR_FLG||','
43584: ||' error_text = '||''''||lv_message_text||''''
43585: ||' WHERE message_id < (SELECT MAX(message_id)'
43586: ||' FROM msc_st_routings msr2'

Line 43586: ||' FROM msc_st_routings msr2'

43582: 'UPDATE msc_st_routings msr1'
43583: ||' SET process_flag = '||G_ERROR_FLG||','
43584: ||' error_text = '||''''||lv_message_text||''''
43585: ||' WHERE message_id < (SELECT MAX(message_id)'
43586: ||' FROM msc_st_routings msr2'
43587: ||' WHERE msr2.sr_instance_code = msr1.sr_instance_code'
43588: ||' AND NVL(msr2.company_name,'||''''||NULL_CHAR||''''||') '
43589: ||' = NVL(msr1.company_name,'||''''||NULL_CHAR||''''||') '
43590: ||' AND msr2.organization_code = msr1.organization_code'

Line 43622: 'UPDATE msc_st_routings msr1 '

43618:
43619: v_sql_stmt := 02;
43620:
43621: lv_sql_stmt :=
43622: 'UPDATE msc_st_routings msr1 '
43623: ||' SET process_flag = '||G_ERROR_FLG||','
43624: ||' error_text = '||''''||lv_message_text||''''
43625: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_routings msr2'
43626: ||' WHERE msr2.sr_instance_code = msr1.sr_instance_code'

Line 43625: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_routings msr2'

43621: lv_sql_stmt :=
43622: 'UPDATE msc_st_routings msr1 '
43623: ||' SET process_flag = '||G_ERROR_FLG||','
43624: ||' error_text = '||''''||lv_message_text||''''
43625: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_routings msr2'
43626: ||' WHERE msr2.sr_instance_code = msr1.sr_instance_code'
43627: ||' AND NVL(msr2.company_name,'||''''||NULL_CHAR||''''||') '
43628: ||' = NVL(msr1.company_name,'||''''||NULL_CHAR||''''||') '
43629: ||' AND msr2.organization_code = msr1.organization_code'

Line 43689: ' UPDATE msc_st_routings '

43685: CLOSE c1;
43686:
43687: v_sql_stmt := 04;
43688: lv_sql_stmt :=
43689: ' UPDATE msc_st_routings '
43690: ||' SET batch_id = :lv_batch_id'
43691: ||' WHERE process_flag IN ('||G_IN_PROCESS||','||G_ERROR_FLG||')'
43692: ||' AND sr_instance_code = :v_instance_code'
43693: ||' AND NVL(batch_id,'||NULL_VALUE||') = '||NULL_VALUE

Line 43709: UPDATE msc_st_routings

43705: CLOSE c2;
43706:
43707: v_sql_stmt := 05;
43708: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
43709: UPDATE msc_st_routings
43710: SET st_transaction_id = msc_st_routings_s.NEXTVAL,
43711: refresh_id = v_refresh_id,
43712: last_update_date = v_current_date,
43713: last_updated_by = v_current_user,

Line 43710: SET st_transaction_id = msc_st_routings_s.NEXTVAL,

43706:
43707: v_sql_stmt := 05;
43708: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
43709: UPDATE msc_st_routings
43710: SET st_transaction_id = msc_st_routings_s.NEXTVAL,
43711: refresh_id = v_refresh_id,
43712: last_update_date = v_current_date,
43713: last_updated_by = v_current_user,
43714: creation_date = v_current_date,

Line 43726: p_token_value1 => 'MSC_ST_ROUTINGS');

43722: p_error_code => 'MSC_PP_NO_DELETION',
43723: p_message_text => lv_message_text,
43724: p_error_text => lv_error_text,
43725: p_token1 => 'TABLE_NAME',
43726: p_token_value1 => 'MSC_ST_ROUTINGS');
43727:
43728: IF lv_return <> 0 THEN
43729: RAISE ex_logging_err;
43730: END IF;

Line 43735: ' UPDATE msc_st_routings '

43731:
43732: --Deletion is not allowed on this table.
43733: v_sql_stmt := 06;
43734: lv_sql_stmt :=
43735: ' UPDATE msc_st_routings '
43736: ||' SET process_flag ='||G_ERROR_FLG||','
43737: ||' error_text = '||''''||lv_message_text||''''
43738: ||' WHERE deleted_flag = '||SYS_YES
43739: ||' AND process_flag = '||G_IN_PROCESS

Line 43770: (p_table_name => 'MSC_ST_ROUTINGS',

43766: lv_where_str :=
43767: ' AND NVL(deleted_flag,'||NULL_VALUE||') <>'||SYS_NO;
43768:
43769: lv_return := MSC_ST_UTIL.LOG_ERROR
43770: (p_table_name => 'MSC_ST_ROUTINGS',
43771: p_instance_code => v_instance_code,
43772: p_row => lv_column_names,
43773: p_severity => G_SEV_WARNING,
43774: p_message_text => lv_message_text,

Line 43803: MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID(p_table_name => 'MSC_ST_ROUTINGS',

43799:
43800: -- derive organization id , call utilty package- msc_st_util's procedure
43801:
43802: lv_return :=
43803: MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID(p_table_name => 'MSC_ST_ROUTINGS',
43804: p_org_partner_name => 'ORGANIZATION_CODE',
43805: p_org_partner_id => 'ORGANIZATION_ID',
43806: p_instance_code => v_instance_code,
43807: p_partner_type => G_ORGANIZATION,

Line 43835: MSC_ST_UTIL.DERIVE_ITEM_ID(p_table_name => 'MSC_ST_ROUTINGS',

43831:
43832: -- Derive assembly item id
43833:
43834: lv_return :=
43835: MSC_ST_UTIL.DERIVE_ITEM_ID(p_table_name => 'MSC_ST_ROUTINGS',
43836: p_item_col_name => 'ASSEMBLY_NAME',
43837: p_item_col_id => 'ASSEMBLY_ITEM_ID',
43838: p_instance_code => v_instance_code,
43839: p_instance_id => v_instance_id,

Line 43858: 'UPDATE msc_st_routings '

43854:
43855: v_sql_stmt := 07;
43856:
43857: lv_sql_stmt :=
43858: 'UPDATE msc_st_routings '
43859: ||' SET routing_name = assembly_name'
43860: ||' WHERE sr_instance_code = :v_instance_code'
43861: ||' AND process_flag ='|| G_IN_PROCESS
43862: ||' AND NVL(routing_name,'||''''||NULL_CHAR||''''||') '

Line 43875: (p_table_name => 'MSC_ST_ROUTINGS',

43871:
43872: -- Derive the ROUTING_SEQUENCE_ID from LOCAL ID table
43873:
43874: lv_return :=msc_st_util.derive_routing_sequence_id
43875: (p_table_name => 'MSC_ST_ROUTINGS',
43876: p_rtg_col_name => 'ROUTING_NAME',
43877: p_rtg_col_id =>'ROUTING_SEQUENCE_ID',
43878: p_instance_code => v_instance_code,
43879: p_batch_id => lv_batch_id,

Line 43908: (p_table_name => 'MSC_ST_ROUTINGS',

43904: lv_where_str :=
43905: ' AND NVL(routing_type,'||NULL_VALUE||') NOT IN (1,2)';
43906:
43907: lv_return := MSC_ST_UTIL.LOG_ERROR
43908: (p_table_name => 'MSC_ST_ROUTINGS',
43909: p_instance_code => v_instance_code,
43910: p_row => lv_column_names,
43911: p_severity => G_SEV_WARNING,
43912: p_message_text => lv_message_text,

Line 43943: (p_table_name => 'MSC_ST_ROUTINGS',

43939: END IF;
43940:
43941: --Derive Project Id.
43942: lv_return:= MSC_ST_UTIL.DERIVE_PROJ_TASK_ID
43943: (p_table_name => 'MSC_ST_ROUTINGS',
43944: p_proj_col_name => 'PROJECT_NUMBER',
43945: p_proj_task_col_id => 'PROJECT_ID',
43946: p_instance_code => v_instance_code,
43947: p_entity_name => 'PROJECT_ID',

Line 43977: (p_table_name => 'MSC_ST_ROUTINGS',

43973: END IF;
43974:
43975: --Derive Task Id.
43976: lv_return:= MSC_ST_UTIL.DERIVE_PROJ_TASK_ID
43977: (p_table_name => 'MSC_ST_ROUTINGS',
43978: p_proj_col_name => 'PROJECT_NUMBER',
43979: p_proj_task_col_id => 'TASK_ID',
43980: p_instance_code => v_instance_code,
43981: p_entity_name => 'TASK_ID',

Line 43998: 'UPDATE msc_st_routings msr'

43994: -- Derive LINE_ID
43995: v_sql_stmt := 08;
43996:
43997: lv_sql_stmt :=
43998: 'UPDATE msc_st_routings msr'
43999: ||' SET line_id = ( SELECT local_id'
44000: ||' FROM msc_local_id_setup mlis'
44001: ||' WHERE mlis.char1 = msr.sr_instance_code'
44002: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 44034: 'UPDATE msc_st_routings msr'

44030: -- Validate the UOM code
44031:
44032: v_sql_stmt := 09;
44033: lv_sql_stmt :=
44034: 'UPDATE msc_st_routings msr'
44035: ||' SET process_flag ='||G_ERROR_FLG||','
44036: ||' error_text = '||''''||lv_message_text||''''
44037: ||' WHERE NOT EXISTS (SELECT 1'
44038: ||' FROM msc_units_of_measure muom'

Line 44081: (p_table_name => 'MSC_ST_ROUTINGS',

44077:
44078: lv_where_str := ' AND ctp_flag NOT IN (1,2)';
44079:
44080: lv_return := MSC_ST_UTIL.LOG_ERROR
44081: (p_table_name => 'MSC_ST_ROUTINGS',
44082: p_instance_code => v_instance_code,
44083: p_row => lv_column_names,
44084: p_severity => G_SEV_WARNING,
44085: p_message_text => lv_message_text,

Line 44118: (p_table_name => 'MSC_ST_ROUTINGS',

44114:
44115: lv_where_str := ' AND cfm_routing_flag NOT IN (1,2,3)';
44116:
44117: lv_return := MSC_ST_UTIL.LOG_ERROR
44118: (p_table_name => 'MSC_ST_ROUTINGS',
44119: p_instance_code => v_instance_code,
44120: p_row => lv_column_names,
44121: p_severity => G_SEV_WARNING,
44122: p_message_text => lv_message_text,

Line 44139: 'UPDATE msc_st_routings '

44135: -- ASSEMBLY NAME in BOM NAME column for all such records
44136:
44137: v_sql_stmt := 10;
44138: lv_sql_stmt :=
44139: 'UPDATE msc_st_routings '
44140: ||' SET bom_name = assembly_name'
44141: ||' WHERE sr_instance_code = :v_instance_code'
44142: ||' AND process_flag = '||G_IN_PROCESS
44143: ||' AND NVL(bom_name,'||''''||NULL_CHAR||''''||') '

Line 44165: p_token_value3 => 'MSC_ST_ROUTINGS' );

44161: ||'ORGANIZATION_CODE,BOM_NAME',
44162: p_token2 => 'MASTER_TABLE',
44163: p_token_value2 => 'MSC_ST_BOMS',
44164: p_token3 => 'CHILD_TABLE' ,
44165: p_token_value3 => 'MSC_ST_ROUTINGS' );
44166:
44167: -- Derive the bill_sequence_id
44168:
44169: lv_return :=

Line 44171: (p_table_name => 'MSC_ST_ROUTINGS',

44167: -- Derive the bill_sequence_id
44168:
44169: lv_return :=
44170: MSC_ST_UTIL.DERIVE_BILL_SEQUENCE_ID
44171: (p_table_name => 'MSC_ST_ROUTINGS',
44172: p_row => lv_column_names,
44173: p_bom_col_name => 'BOM_NAME',
44174: p_bom_col_id => 'BILL_SEQUENCE_ID',
44175: p_instance_code => v_instance_code,

Line 44205: 'UPDATE msc_st_routings'

44201: -- Error out the records whose first_operation_seq_code or last_operation_seq_code is NULL
44202:
44203: v_sql_stmt := 11;
44204: lv_sql_stmt :=
44205: 'UPDATE msc_st_routings'
44206: ||' SET process_flag ='||G_ERROR_FLG||','
44207: ||' error_text = '||''''||lv_message_text||''''
44208: ||' WHERE ( NVL(first_operation_seq_code,'||NULL_VALUE||') ='||NULL_VALUE
44209: ||' OR NVL(last_operation_seq_code,'||NULL_VALUE||') ='||NULL_VALUE ||')'

Line 44224: 'UPDATE msc_st_routings'

44220:
44221: -- For Network routings populate the FIRST_OP_SEQ_NUM and LAST_OP_SEQ_NUM
44222: v_sql_stmt := 13;
44223: lv_sql_stmt :=
44224: 'UPDATE msc_st_routings'
44225: ||' SET first_op_seq_num = to_number(decode(length(rtrim(first_operation_seq_code,''0123456789'')),'
44226: ||' NULL,first_operation_seq_code,''1'')),'
44227: ||' last_op_seq_num = to_number(decode(length(rtrim(last_operation_seq_code,''0123456789'')),'
44228: ||' NULL,last_operation_seq_code,''1''))'

Line 44246: pEntityName => 'MSC_ST_ROUTINGS',

44242: (ERRBUF => lv_error_text,
44243: RETCODE => lv_return,
44244: pBatchID => lv_batch_id,
44245: pInstanceCode => v_instance_code,
44246: pEntityName => 'MSC_ST_ROUTINGS',
44247: pInstanceID => v_instance_id);
44248:
44249: IF NVL(lv_return,0) <> 0 THEN
44250: RAISE ex_logging_err;

Line 44264: UPDATE msc_st_routings

44260: IF c3%ROWCOUNT > 0 THEN
44261:
44262: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
44263:
44264: UPDATE msc_st_routings
44265: SET routing_sequence_id = msc_st_routing_sequence_id_s.NEXTVAL
44266: WHERE rowid = lb_rowid(j);
44267:
44268:

Line 44324: FROM msc_st_routings

44320: v_current_date,
44321: v_current_user,
44322: v_current_date,
44323: v_current_user
44324: FROM msc_st_routings
44325: WHERE rowid = lb_rowid(j);
44326:
44327: END IF;
44328: CLOSE c3;

Line 44355: (p_table_name => 'MSC_ST_ROUTINGS',

44351:
44352:
44353:
44354: lv_return := msc_st_util.derive_routing_sequence_id
44355: (p_table_name => 'MSC_ST_ROUTINGS',
44356: p_rtg_col_name => 'COMMON_ROUTING_NAME',
44357: p_rtg_col_id => 'COMMON_ROUTING_SEQUENCE_ID',
44358: p_instance_code => v_instance_code,
44359: p_batch_id => lv_batch_id,

Line 44370: 'UPDATE msc_st_routings'

44366: end if;
44367:
44368:
44369: lv_sql_stmt :=
44370: 'UPDATE msc_st_routings'
44371: ||' SET process_flag ='||G_ERROR_FLG||','
44372: ||' error_text = '||''''||lv_message_text||''''
44373: ||' WHERE NVL(COMMON_ROUTING_SEQUENCE_ID,'||NULL_VALUE||') ='||NULL_VALUE
44374: ||' AND NVL(routing_name, '||''''||NULL_CHAR||''''||') <> '

Line 44390: MSC_ST_UTIL.SET_PROCESS_FLAG(p_table_name => 'MSC_ST_ROUTINGS',

44386:
44387:
44388: -- Set the process flag as Valid and poulate instance_id
44389: lv_return :=
44390: MSC_ST_UTIL.SET_PROCESS_FLAG(p_table_name => 'MSC_ST_ROUTINGS',
44391: p_instance_id => v_instance_id,
44392: p_instance_code => v_instance_code,
44393: p_process_flag => G_VALID,
44394: p_error_text => lv_error_text,

Line 44405: MSC_ST_UTIL.LOG_ERROR(p_table_name => 'MSC_ST_ROUTINGS',

44401:
44402: -- At the end calling the LOG_ERROR for logging all errored out records
44403:
44404: lv_return :=
44405: MSC_ST_UTIL.LOG_ERROR(p_table_name => 'MSC_ST_ROUTINGS',
44406: p_instance_code => v_instance_code,
44407: p_row => lv_column_names,
44408: p_severity => G_SEV_ERROR,
44409: p_message_text => NULL,

Line 44687: p_token_value2 => 'MSC_ST_ROUTINGS',

44683: p_token1 => 'COLUMN_NAMES',
44684: p_token_value1 => 'SR_INSTANCE_CODE,COMPANY_NAME,'
44685: ||'ORGANIZATION_CODE,ROUTING_NAME',
44686: p_token2 => 'MASTER_TABLE',
44687: p_token_value2 => 'MSC_ST_ROUTINGS',
44688: p_token3 => 'CHILD_TABLE' ,
44689: p_token_value3 => 'MSC_ST_ROUTING_OPERATIONS' );
44690:
44691: IF lv_return <> 0 THEN

Line 46577: p_token_value2 => 'MSC_ST_ROUTINGS',

46573: p_token1 => 'COLUMN_NAMES',
46574: p_token_value1 => 'SR_INSTANCE_CODE,COMPANY_NAME,'
46575: ||'ORGANIZATION_CODE,ROUTING_NAME',
46576: p_token2 => 'MASTER_TABLE',
46577: p_token_value2 => 'MSC_ST_ROUTINGS',
46578: p_token3 => 'CHILD_TABLE' ,
46579: p_token_value3 => 'MSC_ST_OPERATION_NETWORKS' );
46580:
46581: IF lv_return <> 0 THEN

Line 47216: ||' FROM msc_st_routings'

47212: ||' last_update_date,'
47213: ||' last_updated_by, '
47214: ||' creation_date,'
47215: ||' created_by '
47216: ||' FROM msc_st_routings'
47217: ||' WHERE sr_instance_id = :v_instance_id';
47218:
47219:
47220:

Line 47262: ||' AND NOT EXISTS ( SELECT 1 from msc_st_routings msr '

47258: ||' creation_date,'
47259: ||' created_by '
47260: ||' FROM msc_st_boms msb'
47261: ||' WHERE sr_instance_id = :v_instance_id'
47262: ||' AND NOT EXISTS ( SELECT 1 from msc_st_routings msr '
47263: ||' WHERE msr.bill_sequence_id = msb.bill_sequence_id '
47264: ||' AND msr.sr_instance_id = msb.sr_instance_id )';
47265:
47266:

Line 50749: lv_batch_id msc_st_routings.batch_id%TYPE;

50745: lv_error_text VARCHAR2(250);
50746: lv_where_str VARCHAR2(5000);
50747: lv_sql_stmt VARCHAR2(5000);
50748: lv_cursor_stmt VARCHAR2(5000);
50749: lv_batch_id msc_st_routings.batch_id%TYPE;
50750: lv_message_text msc_errors.error_text%TYPE;
50751: ex_logging_err EXCEPTION;
50752:
50753:

Line 51320: p_token_value2 => 'MSC_ST_ROUTINGS',

51316: p_token1 => 'COLUMN_NAMES',
51317: p_token_value1 => 'SR_INSTANCE_CODE,COMPANY_NAME,'
51318: ||'ORGANIZATION_CODE,ROUTING_NAME',
51319: p_token2 => 'MASTER_TABLE',
51320: p_token_value2 => 'MSC_ST_ROUTINGS',
51321: p_token3 => 'CHILD_TABLE' ,
51322: p_token_value3 => 'MSC_ST_JOB_OPERATION_NETWORKS' );
51323:
51324: IF lv_return <> 0 THEN

Line 52116: p_token_value2 => 'MSC_ST_ROUTINGS',

52112: p_token1 => 'COLUMN_NAMES',
52113: p_token_value1 => 'SR_INSTANCE_CODE,COMPANY_NAME,'
52114: ||'ORGANIZATION_CODE,ROUTING_NAME',
52115: p_token2 => 'MASTER_TABLE',
52116: p_token_value2 => 'MSC_ST_ROUTINGS',
52117: p_token3 => 'CHILD_TABLE' ,
52118: p_token_value3 => 'MSC_ST_JOB_OPERATIONS' );
52119:
52120: IF lv_return <> 0 THEN

Line 52980: p_token_value2 => 'MSC_ST_ROUTINGS',

52976: p_token1 => 'COLUMN_NAMES',
52977: p_token_value1 => 'SR_INSTANCE_CODE,COMPANY_NAME,'
52978: ||'ORGANIZATION_CODE,ROUTING_NAME',
52979: p_token2 => 'MASTER_TABLE',
52980: p_token_value2 => 'MSC_ST_ROUTINGS',
52981: p_token3 => 'CHILD_TABLE' ,
52982: p_token_value3 => 'MSC_ST_JOB_REQUIREMENT_OPS' );
52983:
52984: IF lv_return <> 0 THEN

Line 55868: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_ROUTINGS');

55864: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_ROUTING_OPERATIONS');
55865: IF lv_count > 0 Then
55866: prec.bom_flag:= SYS_YES;
55867: End IF;
55868: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_ROUTINGS');
55869: IF lv_count > 0 Then
55870: prec.bom_flag:= SYS_YES;
55871: End IF;
55872: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_OPERATION_NETWORKS');