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 808: 'create index MSC_ST_ROUTINGS_N1_'||v_instance_code

804: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
805: application_short_name => 'MSC',
806: statement_type => AD_DDL.CREATE_INDEX,
807: statement =>
808: 'create index MSC_ST_ROUTINGS_N1_'||v_instance_code
809: ||' on MSC_ST_ROUTINGS '
810: ||'(sr_instance_code, assembly_name, organization_code, company_name, routing_name, alternate_routing_designator) '
811: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
812: object_name =>'MSC_ST_ROUTINGS_N1_'||v_instance_code);

Line 809: ||' on MSC_ST_ROUTINGS '

805: application_short_name => 'MSC',
806: statement_type => AD_DDL.CREATE_INDEX,
807: statement =>
808: 'create index MSC_ST_ROUTINGS_N1_'||v_instance_code
809: ||' on MSC_ST_ROUTINGS '
810: ||'(sr_instance_code, assembly_name, organization_code, company_name, routing_name, alternate_routing_designator) '
811: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
812: object_name =>'MSC_ST_ROUTINGS_N1_'||v_instance_code);
813:

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

808: 'create index MSC_ST_ROUTINGS_N1_'||v_instance_code
809: ||' on MSC_ST_ROUTINGS '
810: ||'(sr_instance_code, assembly_name, organization_code, company_name, routing_name, alternate_routing_designator) '
811: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
812: object_name =>'MSC_ST_ROUTINGS_N1_'||v_instance_code);
813:
814: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_ROUTINGS_N1_'||v_instance_code);
815:
816: EXCEPTION

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

810: ||'(sr_instance_code, assembly_name, organization_code, company_name, routing_name, alternate_routing_designator) '
811: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
812: object_name =>'MSC_ST_ROUTINGS_N1_'||v_instance_code);
813:
814: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_ROUTINGS_N1_'||v_instance_code);
815:
816: EXCEPTION
817: WHEN OTHERS THEN
818: 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 818: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_ROUTINGS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));

814: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_ROUTINGS_N1_'||v_instance_code);
815:
816: EXCEPTION
817: WHEN OTHERS THEN
818: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_ROUTINGS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
819: END;
820:
821: BEGIN
822: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

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

873: WHEN OTHERS THEN
874: 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));
875: END;
876:
877: msc_analyse_tables_pk.analyse_table( 'MSC_ST_ROUTINGS', v_instance_id, -1);
878: msc_analyse_tables_pk.analyse_table( 'MSC_ST_OPERATION_RESOURCES', v_instance_id, -1);
879: msc_analyse_tables_pk.analyse_table( 'MSC_ST_ROUTING_OPERATIONS', v_instance_id, -1);
880: msc_analyse_tables_pk.analyse_table( 'MSC_ST_OPERATION_NETWORKS', v_instance_id, -1);
881:

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

2080: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2081: application_short_name => 'MSC',
2082: statement_type => AD_DDL.DROP_INDEX,
2083: statement =>
2084: 'drop index MSC_ST_ROUTINGS_N1_'||v_instance_code,
2085: object_name => 'MSC_ST_ROUTINGS_N1_'||v_instance_code);
2086:
2087: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_ROUTINGS_N1_'||v_instance_code);
2088: EXCEPTION

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

2081: application_short_name => 'MSC',
2082: statement_type => AD_DDL.DROP_INDEX,
2083: statement =>
2084: 'drop index MSC_ST_ROUTINGS_N1_'||v_instance_code,
2085: object_name => 'MSC_ST_ROUTINGS_N1_'||v_instance_code);
2086:
2087: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_ROUTINGS_N1_'||v_instance_code);
2088: EXCEPTION
2089: WHEN OTHERS THEN

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

2083: statement =>
2084: 'drop index MSC_ST_ROUTINGS_N1_'||v_instance_code,
2085: object_name => 'MSC_ST_ROUTINGS_N1_'||v_instance_code);
2086:
2087: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_ROUTINGS_N1_'||v_instance_code);
2088: EXCEPTION
2089: WHEN OTHERS THEN
2090: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_ROUTINGS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
2091: END;

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

2086:
2087: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_ROUTINGS_N1_'||v_instance_code);
2088: EXCEPTION
2089: WHEN OTHERS THEN
2090: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_ROUTINGS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
2091: END;
2092:
2093: BEGIN
2094: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

Line 38690: lv_batch_id msc_st_routings.batch_id%TYPE;

38686: lv_error_text VARCHAR2(250);
38687: lv_where_str VARCHAR2(5000);
38688: lv_sql_stmt VARCHAR2(5000);
38689: lv_cursor_stmt VARCHAR2(5000);
38690: lv_batch_id msc_st_routings.batch_id%TYPE;
38691: lv_message_text msc_errors.error_text%TYPE;
38692: ex_logging_err EXCEPTION;
38693:
38694:

Line 38697: FROM msc_st_routings

38693:
38694:
38695: CURSOR c2(p_batch_id NUMBER) IS
38696: SELECT rowid
38697: FROM msc_st_routings
38698: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
38699: AND sr_instance_code = v_instance_code
38700: AND batch_id = p_batch_id;
38701:

Line 38704: FROM msc_st_routings

38700: AND batch_id = p_batch_id;
38701:
38702: CURSOR c3(p_batch_id NUMBER) IS
38703: SELECT rowid
38704: FROM msc_st_routings
38705: WHERE process_flag = G_IN_PROCESS
38706: AND sr_instance_code = v_instance_code
38707: AND batch_id = p_batch_id
38708: AND NVL(routing_sequence_id,NULL_VALUE) = NULL_VALUE

Line 38798: 'UPDATE msc_st_routings msr1'

38794: -- Duplicate UDK validation for XML message
38795:
38796: v_sql_stmt := 01;
38797: lv_sql_stmt :=
38798: 'UPDATE msc_st_routings msr1'
38799: ||' SET process_flag = '||G_ERROR_FLG||','
38800: ||' error_text = '||''''||lv_message_text||''''
38801: ||' WHERE message_id < (SELECT MAX(message_id)'
38802: ||' FROM msc_st_routings msr2'

Line 38802: ||' FROM msc_st_routings msr2'

38798: 'UPDATE msc_st_routings msr1'
38799: ||' SET process_flag = '||G_ERROR_FLG||','
38800: ||' error_text = '||''''||lv_message_text||''''
38801: ||' WHERE message_id < (SELECT MAX(message_id)'
38802: ||' FROM msc_st_routings msr2'
38803: ||' WHERE msr2.sr_instance_code = msr1.sr_instance_code'
38804: ||' AND NVL(msr2.company_name,'||''''||NULL_CHAR||''''||') '
38805: ||' = NVL(msr1.company_name,'||''''||NULL_CHAR||''''||') '
38806: ||' AND msr2.organization_code = msr1.organization_code'

Line 38838: 'UPDATE msc_st_routings msr1 '

38834:
38835: v_sql_stmt := 02;
38836:
38837: lv_sql_stmt :=
38838: 'UPDATE msc_st_routings msr1 '
38839: ||' SET process_flag = '||G_ERROR_FLG||','
38840: ||' error_text = '||''''||lv_message_text||''''
38841: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_routings msr2'
38842: ||' WHERE msr2.sr_instance_code = msr1.sr_instance_code'

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

38837: lv_sql_stmt :=
38838: 'UPDATE msc_st_routings msr1 '
38839: ||' SET process_flag = '||G_ERROR_FLG||','
38840: ||' error_text = '||''''||lv_message_text||''''
38841: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_routings msr2'
38842: ||' WHERE msr2.sr_instance_code = msr1.sr_instance_code'
38843: ||' AND NVL(msr2.company_name,'||''''||NULL_CHAR||''''||') '
38844: ||' = NVL(msr1.company_name,'||''''||NULL_CHAR||''''||') '
38845: ||' AND msr2.organization_code = msr1.organization_code'

Line 38905: ' UPDATE msc_st_routings '

38901: CLOSE c1;
38902:
38903: v_sql_stmt := 04;
38904: lv_sql_stmt :=
38905: ' UPDATE msc_st_routings '
38906: ||' SET batch_id = :lv_batch_id'
38907: ||' WHERE process_flag IN ('||G_IN_PROCESS||','||G_ERROR_FLG||')'
38908: ||' AND sr_instance_code = :v_instance_code'
38909: ||' AND NVL(batch_id,'||NULL_VALUE||') = '||NULL_VALUE

Line 38925: UPDATE msc_st_routings

38921: CLOSE c2;
38922:
38923: v_sql_stmt := 05;
38924: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
38925: UPDATE msc_st_routings
38926: SET st_transaction_id = msc_st_routings_s.NEXTVAL,
38927: refresh_id = v_refresh_id,
38928: last_update_date = v_current_date,
38929: last_updated_by = v_current_user,

Line 38926: SET st_transaction_id = msc_st_routings_s.NEXTVAL,

38922:
38923: v_sql_stmt := 05;
38924: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
38925: UPDATE msc_st_routings
38926: SET st_transaction_id = msc_st_routings_s.NEXTVAL,
38927: refresh_id = v_refresh_id,
38928: last_update_date = v_current_date,
38929: last_updated_by = v_current_user,
38930: creation_date = v_current_date,

Line 38942: p_token_value1 => 'MSC_ST_ROUTINGS');

38938: p_error_code => 'MSC_PP_NO_DELETION',
38939: p_message_text => lv_message_text,
38940: p_error_text => lv_error_text,
38941: p_token1 => 'TABLE_NAME',
38942: p_token_value1 => 'MSC_ST_ROUTINGS');
38943:
38944: IF lv_return <> 0 THEN
38945: RAISE ex_logging_err;
38946: END IF;

Line 38951: ' UPDATE msc_st_routings '

38947:
38948: --Deletion is not allowed on this table.
38949: v_sql_stmt := 06;
38950: lv_sql_stmt :=
38951: ' UPDATE msc_st_routings '
38952: ||' SET process_flag ='||G_ERROR_FLG||','
38953: ||' error_text = '||''''||lv_message_text||''''
38954: ||' WHERE deleted_flag = '||SYS_YES
38955: ||' AND process_flag = '||G_IN_PROCESS

Line 38986: (p_table_name => 'MSC_ST_ROUTINGS',

38982: lv_where_str :=
38983: ' AND NVL(deleted_flag,'||NULL_VALUE||') <>'||SYS_NO;
38984:
38985: lv_return := MSC_ST_UTIL.LOG_ERROR
38986: (p_table_name => 'MSC_ST_ROUTINGS',
38987: p_instance_code => v_instance_code,
38988: p_row => lv_column_names,
38989: p_severity => G_SEV_WARNING,
38990: p_message_text => lv_message_text,

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

39015:
39016: -- derive organization id , call utilty package- msc_st_util's procedure
39017:
39018: lv_return :=
39019: MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID(p_table_name => 'MSC_ST_ROUTINGS',
39020: p_org_partner_name => 'ORGANIZATION_CODE',
39021: p_org_partner_id => 'ORGANIZATION_ID',
39022: p_instance_code => v_instance_code,
39023: p_partner_type => G_ORGANIZATION,

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

39047:
39048: -- Derive assembly item id
39049:
39050: lv_return :=
39051: MSC_ST_UTIL.DERIVE_ITEM_ID(p_table_name => 'MSC_ST_ROUTINGS',
39052: p_item_col_name => 'ASSEMBLY_NAME',
39053: p_item_col_id => 'ASSEMBLY_ITEM_ID',
39054: p_instance_code => v_instance_code,
39055: p_instance_id => v_instance_id,

Line 39074: 'UPDATE msc_st_routings '

39070:
39071: v_sql_stmt := 07;
39072:
39073: lv_sql_stmt :=
39074: 'UPDATE msc_st_routings '
39075: ||' SET routing_name = assembly_name'
39076: ||' WHERE sr_instance_code = :v_instance_code'
39077: ||' AND process_flag ='|| G_IN_PROCESS
39078: ||' AND NVL(routing_name,'||''''||NULL_CHAR||''''||') '

Line 39091: (p_table_name => 'MSC_ST_ROUTINGS',

39087:
39088: -- Derive the ROUTING_SEQUENCE_ID from LOCAL ID table
39089:
39090: lv_return :=msc_st_util.derive_routing_sequence_id
39091: (p_table_name => 'MSC_ST_ROUTINGS',
39092: p_rtg_col_name => 'ROUTING_NAME',
39093: p_rtg_col_id =>'ROUTING_SEQUENCE_ID',
39094: p_instance_code => v_instance_code,
39095: p_batch_id => lv_batch_id,

Line 39124: (p_table_name => 'MSC_ST_ROUTINGS',

39120: lv_where_str :=
39121: ' AND NVL(routing_type,'||NULL_VALUE||') NOT IN (1,2)';
39122:
39123: lv_return := MSC_ST_UTIL.LOG_ERROR
39124: (p_table_name => 'MSC_ST_ROUTINGS',
39125: p_instance_code => v_instance_code,
39126: p_row => lv_column_names,
39127: p_severity => G_SEV_WARNING,
39128: p_message_text => lv_message_text,

Line 39159: (p_table_name => 'MSC_ST_ROUTINGS',

39155: END IF;
39156:
39157: --Derive Project Id.
39158: lv_return:= MSC_ST_UTIL.DERIVE_PROJ_TASK_ID
39159: (p_table_name => 'MSC_ST_ROUTINGS',
39160: p_proj_col_name => 'PROJECT_NUMBER',
39161: p_proj_task_col_id => 'PROJECT_ID',
39162: p_instance_code => v_instance_code,
39163: p_entity_name => 'PROJECT_ID',

Line 39193: (p_table_name => 'MSC_ST_ROUTINGS',

39189: END IF;
39190:
39191: --Derive Task Id.
39192: lv_return:= MSC_ST_UTIL.DERIVE_PROJ_TASK_ID
39193: (p_table_name => 'MSC_ST_ROUTINGS',
39194: p_proj_col_name => 'PROJECT_NUMBER',
39195: p_proj_task_col_id => 'TASK_ID',
39196: p_instance_code => v_instance_code,
39197: p_entity_name => 'TASK_ID',

Line 39214: 'UPDATE msc_st_routings msr'

39210: -- Derive LINE_ID
39211: v_sql_stmt := 08;
39212:
39213: lv_sql_stmt :=
39214: 'UPDATE msc_st_routings msr'
39215: ||' SET line_id = ( SELECT local_id'
39216: ||' FROM msc_local_id_setup mlis'
39217: ||' WHERE mlis.char1 = msr.sr_instance_code'
39218: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 39250: 'UPDATE msc_st_routings msr'

39246: -- Validate the UOM code
39247:
39248: v_sql_stmt := 09;
39249: lv_sql_stmt :=
39250: 'UPDATE msc_st_routings msr'
39251: ||' SET process_flag ='||G_ERROR_FLG||','
39252: ||' error_text = '||''''||lv_message_text||''''
39253: ||' WHERE NOT EXISTS (SELECT 1'
39254: ||' FROM msc_units_of_measure muom'

Line 39297: (p_table_name => 'MSC_ST_ROUTINGS',

39293:
39294: lv_where_str := ' AND ctp_flag NOT IN (1,2)';
39295:
39296: lv_return := MSC_ST_UTIL.LOG_ERROR
39297: (p_table_name => 'MSC_ST_ROUTINGS',
39298: p_instance_code => v_instance_code,
39299: p_row => lv_column_names,
39300: p_severity => G_SEV_WARNING,
39301: p_message_text => lv_message_text,

Line 39334: (p_table_name => 'MSC_ST_ROUTINGS',

39330:
39331: lv_where_str := ' AND cfm_routing_flag NOT IN (1,2,3)';
39332:
39333: lv_return := MSC_ST_UTIL.LOG_ERROR
39334: (p_table_name => 'MSC_ST_ROUTINGS',
39335: p_instance_code => v_instance_code,
39336: p_row => lv_column_names,
39337: p_severity => G_SEV_WARNING,
39338: p_message_text => lv_message_text,

Line 39355: 'UPDATE msc_st_routings '

39351: -- ASSEMBLY NAME in BOM NAME column for all such records
39352:
39353: v_sql_stmt := 10;
39354: lv_sql_stmt :=
39355: 'UPDATE msc_st_routings '
39356: ||' SET bom_name = assembly_name'
39357: ||' WHERE sr_instance_code = :v_instance_code'
39358: ||' AND process_flag = '||G_IN_PROCESS
39359: ||' AND NVL(bom_name,'||''''||NULL_CHAR||''''||') '

Line 39381: p_token_value3 => 'MSC_ST_ROUTINGS' );

39377: ||'ORGANIZATION_CODE,BOM_NAME',
39378: p_token2 => 'MASTER_TABLE',
39379: p_token_value2 => 'MSC_ST_BOMS',
39380: p_token3 => 'CHILD_TABLE' ,
39381: p_token_value3 => 'MSC_ST_ROUTINGS' );
39382:
39383: -- Derive the bill_sequence_id
39384:
39385: lv_return :=

Line 39387: (p_table_name => 'MSC_ST_ROUTINGS',

39383: -- Derive the bill_sequence_id
39384:
39385: lv_return :=
39386: MSC_ST_UTIL.DERIVE_BILL_SEQUENCE_ID
39387: (p_table_name => 'MSC_ST_ROUTINGS',
39388: p_row => lv_column_names,
39389: p_bom_col_name => 'BOM_NAME',
39390: p_bom_col_id => 'BILL_SEQUENCE_ID',
39391: p_instance_code => v_instance_code,

Line 39421: 'UPDATE msc_st_routings'

39417: -- Error out the records whose first_operation_seq_code or last_operation_seq_code is NULL
39418:
39419: v_sql_stmt := 11;
39420: lv_sql_stmt :=
39421: 'UPDATE msc_st_routings'
39422: ||' SET process_flag ='||G_ERROR_FLG||','
39423: ||' error_text = '||''''||lv_message_text||''''
39424: ||' WHERE ( NVL(first_operation_seq_code,'||NULL_VALUE||') ='||NULL_VALUE
39425: ||' OR NVL(last_operation_seq_code,'||NULL_VALUE||') ='||NULL_VALUE ||')'

Line 39440: 'UPDATE msc_st_routings'

39436:
39437: -- For Network routings populate the FIRST_OP_SEQ_NUM and LAST_OP_SEQ_NUM
39438: v_sql_stmt := 13;
39439: lv_sql_stmt :=
39440: 'UPDATE msc_st_routings'
39441: ||' SET first_op_seq_num = to_number(decode(length(rtrim(first_operation_seq_code,''0123456789'')),'
39442: ||' NULL,first_operation_seq_code,''1'')),'
39443: ||' last_op_seq_num = to_number(decode(length(rtrim(last_operation_seq_code,''0123456789'')),'
39444: ||' NULL,last_operation_seq_code,''1''))'

Line 39462: pEntityName => 'MSC_ST_ROUTINGS',

39458: (ERRBUF => lv_error_text,
39459: RETCODE => lv_return,
39460: pBatchID => lv_batch_id,
39461: pInstanceCode => v_instance_code,
39462: pEntityName => 'MSC_ST_ROUTINGS',
39463: pInstanceID => v_instance_id);
39464:
39465: IF NVL(lv_return,0) <> 0 THEN
39466: RAISE ex_logging_err;

Line 39480: UPDATE msc_st_routings

39476: IF c3%ROWCOUNT > 0 THEN
39477:
39478: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
39479:
39480: UPDATE msc_st_routings
39481: SET routing_sequence_id = msc_st_routing_sequence_id_s.NEXTVAL
39482: WHERE rowid = lb_rowid(j);
39483:
39484:

Line 39540: FROM msc_st_routings

39536: v_current_date,
39537: v_current_user,
39538: v_current_date,
39539: v_current_user
39540: FROM msc_st_routings
39541: WHERE rowid = lb_rowid(j);
39542:
39543: END IF;
39544: CLOSE c3;

Line 39571: (p_table_name => 'MSC_ST_ROUTINGS',

39567:
39568:
39569:
39570: lv_return := msc_st_util.derive_routing_sequence_id
39571: (p_table_name => 'MSC_ST_ROUTINGS',
39572: p_rtg_col_name => 'COMMON_ROUTING_NAME',
39573: p_rtg_col_id => 'COMMON_ROUTING_SEQUENCE_ID',
39574: p_instance_code => v_instance_code,
39575: p_batch_id => lv_batch_id,

Line 39586: 'UPDATE msc_st_routings'

39582: end if;
39583:
39584:
39585: lv_sql_stmt :=
39586: 'UPDATE msc_st_routings'
39587: ||' SET process_flag ='||G_ERROR_FLG||','
39588: ||' error_text = '||''''||lv_message_text||''''
39589: ||' WHERE NVL(COMMON_ROUTING_SEQUENCE_ID,'||NULL_VALUE||') ='||NULL_VALUE
39590: ||' AND NVL(routing_name, '||''''||NULL_CHAR||''''||') <> '

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

39602:
39603:
39604: -- Set the process flag as Valid and poulate instance_id
39605: lv_return :=
39606: MSC_ST_UTIL.SET_PROCESS_FLAG(p_table_name => 'MSC_ST_ROUTINGS',
39607: p_instance_id => v_instance_id,
39608: p_instance_code => v_instance_code,
39609: p_process_flag => G_VALID,
39610: p_error_text => lv_error_text,

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

39617:
39618: -- At the end calling the LOG_ERROR for logging all errored out records
39619:
39620: lv_return :=
39621: MSC_ST_UTIL.LOG_ERROR(p_table_name => 'MSC_ST_ROUTINGS',
39622: p_instance_code => v_instance_code,
39623: p_row => lv_column_names,
39624: p_severity => G_SEV_ERROR,
39625: p_message_text => NULL,

Line 39903: p_token_value2 => 'MSC_ST_ROUTINGS',

39899: p_token1 => 'COLUMN_NAMES',
39900: p_token_value1 => 'SR_INSTANCE_CODE,COMPANY_NAME,'
39901: ||'ORGANIZATION_CODE,ROUTING_NAME',
39902: p_token2 => 'MASTER_TABLE',
39903: p_token_value2 => 'MSC_ST_ROUTINGS',
39904: p_token3 => 'CHILD_TABLE' ,
39905: p_token_value3 => 'MSC_ST_ROUTING_OPERATIONS' );
39906:
39907: IF lv_return <> 0 THEN

Line 41701: p_token_value2 => 'MSC_ST_ROUTINGS',

41697: p_token1 => 'COLUMN_NAMES',
41698: p_token_value1 => 'SR_INSTANCE_CODE,COMPANY_NAME,'
41699: ||'ORGANIZATION_CODE,ROUTING_NAME',
41700: p_token2 => 'MASTER_TABLE',
41701: p_token_value2 => 'MSC_ST_ROUTINGS',
41702: p_token3 => 'CHILD_TABLE' ,
41703: p_token_value3 => 'MSC_ST_OPERATION_NETWORKS' );
41704:
41705: IF lv_return <> 0 THEN

Line 42339: ||' FROM msc_st_routings'

42335: ||' last_update_date,'
42336: ||' last_updated_by, '
42337: ||' creation_date,'
42338: ||' created_by '
42339: ||' FROM msc_st_routings'
42340: ||' WHERE sr_instance_id = :v_instance_id';
42341:
42342:
42343:

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

42381: ||' creation_date,'
42382: ||' created_by '
42383: ||' FROM msc_st_boms msb'
42384: ||' WHERE sr_instance_id = :v_instance_id'
42385: ||' AND NOT EXISTS ( SELECT 1 from msc_st_routings msr '
42386: ||' WHERE msr.bill_sequence_id = msb.bill_sequence_id '
42387: ||' AND msr.sr_instance_id = msb.sr_instance_id )';
42388:
42389:

Line 45865: lv_batch_id msc_st_routings.batch_id%TYPE;

45861: lv_error_text VARCHAR2(250);
45862: lv_where_str VARCHAR2(5000);
45863: lv_sql_stmt VARCHAR2(5000);
45864: lv_cursor_stmt VARCHAR2(5000);
45865: lv_batch_id msc_st_routings.batch_id%TYPE;
45866: lv_message_text msc_errors.error_text%TYPE;
45867: ex_logging_err EXCEPTION;
45868:
45869:

Line 46436: p_token_value2 => 'MSC_ST_ROUTINGS',

46432: p_token1 => 'COLUMN_NAMES',
46433: p_token_value1 => 'SR_INSTANCE_CODE,COMPANY_NAME,'
46434: ||'ORGANIZATION_CODE,ROUTING_NAME',
46435: p_token2 => 'MASTER_TABLE',
46436: p_token_value2 => 'MSC_ST_ROUTINGS',
46437: p_token3 => 'CHILD_TABLE' ,
46438: p_token_value3 => 'MSC_ST_JOB_OPERATION_NETWORKS' );
46439:
46440: IF lv_return <> 0 THEN

Line 47232: p_token_value2 => 'MSC_ST_ROUTINGS',

47228: p_token1 => 'COLUMN_NAMES',
47229: p_token_value1 => 'SR_INSTANCE_CODE,COMPANY_NAME,'
47230: ||'ORGANIZATION_CODE,ROUTING_NAME',
47231: p_token2 => 'MASTER_TABLE',
47232: p_token_value2 => 'MSC_ST_ROUTINGS',
47233: p_token3 => 'CHILD_TABLE' ,
47234: p_token_value3 => 'MSC_ST_JOB_OPERATIONS' );
47235:
47236: IF lv_return <> 0 THEN

Line 48096: p_token_value2 => 'MSC_ST_ROUTINGS',

48092: p_token1 => 'COLUMN_NAMES',
48093: p_token_value1 => 'SR_INSTANCE_CODE,COMPANY_NAME,'
48094: ||'ORGANIZATION_CODE,ROUTING_NAME',
48095: p_token2 => 'MASTER_TABLE',
48096: p_token_value2 => 'MSC_ST_ROUTINGS',
48097: p_token3 => 'CHILD_TABLE' ,
48098: p_token_value3 => 'MSC_ST_JOB_REQUIREMENT_OPS' );
48099:
48100: IF lv_return <> 0 THEN

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

50950: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_ROUTING_OPERATIONS');
50951: IF lv_count > 0 Then
50952: prec.bom_flag:= SYS_YES;
50953: End IF;
50954: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_ROUTINGS');
50955: IF lv_count > 0 Then
50956: prec.bom_flag:= SYS_YES;
50957: End IF;
50958: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_OPERATION_NETWORKS');