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_JOB_OPERATIONS

Line 1598: 'create index MSC_ST_JOB_OPERATIONS_N1_'||v_instance_code

1594: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1595: application_short_name => 'MSC',
1596: statement_type => AD_DDL.CREATE_INDEX,
1597: statement =>
1598: 'create index MSC_ST_JOB_OPERATIONS_N1_'||v_instance_code
1599: ||' on MSC_ST_JOB_OPERATIONS '
1600: ||'(SR_INSTANCE_CODE, ORGANIZATION_CODE, WIP_ENTITY_NAME, OPERATION_SEQ_CODE ) '
1601: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1602: object_name =>'MSC_ST_JOB_OPERATIONS_N1_'||v_instance_code);

Line 1599: ||' on MSC_ST_JOB_OPERATIONS '

1595: application_short_name => 'MSC',
1596: statement_type => AD_DDL.CREATE_INDEX,
1597: statement =>
1598: 'create index MSC_ST_JOB_OPERATIONS_N1_'||v_instance_code
1599: ||' on MSC_ST_JOB_OPERATIONS '
1600: ||'(SR_INSTANCE_CODE, ORGANIZATION_CODE, WIP_ENTITY_NAME, OPERATION_SEQ_CODE ) '
1601: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1602: object_name =>'MSC_ST_JOB_OPERATIONS_N1_'||v_instance_code);
1603: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_JOB_OPERATIONS_N1_'||v_instance_code);

Line 1602: object_name =>'MSC_ST_JOB_OPERATIONS_N1_'||v_instance_code);

1598: 'create index MSC_ST_JOB_OPERATIONS_N1_'||v_instance_code
1599: ||' on MSC_ST_JOB_OPERATIONS '
1600: ||'(SR_INSTANCE_CODE, ORGANIZATION_CODE, WIP_ENTITY_NAME, OPERATION_SEQ_CODE ) '
1601: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1602: object_name =>'MSC_ST_JOB_OPERATIONS_N1_'||v_instance_code);
1603: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_JOB_OPERATIONS_N1_'||v_instance_code);
1604:
1605: EXCEPTION
1606: WHEN OTHERS THEN

Line 1603: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_JOB_OPERATIONS_N1_'||v_instance_code);

1599: ||' on MSC_ST_JOB_OPERATIONS '
1600: ||'(SR_INSTANCE_CODE, ORGANIZATION_CODE, WIP_ENTITY_NAME, OPERATION_SEQ_CODE ) '
1601: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1602: object_name =>'MSC_ST_JOB_OPERATIONS_N1_'||v_instance_code);
1603: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_JOB_OPERATIONS_N1_'||v_instance_code);
1604:
1605: EXCEPTION
1606: WHEN OTHERS THEN
1607: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_JOB_OPERATIONS_N1_'||v_instance_code ||'. Error:'||substr(SQLERRM,1,240));

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

1603: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_JOB_OPERATIONS_N1_'||v_instance_code);
1604:
1605: EXCEPTION
1606: WHEN OTHERS THEN
1607: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_JOB_OPERATIONS_N1_'||v_instance_code ||'. Error:'||substr(SQLERRM,1,240));
1608: END;
1609:
1610: BEGIN
1611: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

Line 2711: 'drop index MSC_ST_JOB_OPERATIONS_N1_'||v_instance_code,

2707: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2708: application_short_name => 'MSC',
2709: statement_type => AD_DDL.DROP_INDEX,
2710: statement =>
2711: 'drop index MSC_ST_JOB_OPERATIONS_N1_'||v_instance_code,
2712: object_name => 'MSC_ST_JOB_OPERATIONS_N1_'||v_instance_code);
2713:
2714: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_JOB_OPERATIONS_N1_'||v_instance_code);
2715:

Line 2712: object_name => 'MSC_ST_JOB_OPERATIONS_N1_'||v_instance_code);

2708: application_short_name => 'MSC',
2709: statement_type => AD_DDL.DROP_INDEX,
2710: statement =>
2711: 'drop index MSC_ST_JOB_OPERATIONS_N1_'||v_instance_code,
2712: object_name => 'MSC_ST_JOB_OPERATIONS_N1_'||v_instance_code);
2713:
2714: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_JOB_OPERATIONS_N1_'||v_instance_code);
2715:
2716: EXCEPTION

Line 2714: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_JOB_OPERATIONS_N1_'||v_instance_code);

2710: statement =>
2711: 'drop index MSC_ST_JOB_OPERATIONS_N1_'||v_instance_code,
2712: object_name => 'MSC_ST_JOB_OPERATIONS_N1_'||v_instance_code);
2713:
2714: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_JOB_OPERATIONS_N1_'||v_instance_code);
2715:
2716: EXCEPTION
2717: WHEN OTHERS THEN
2718: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_JOB_OPERATIONS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));

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

2714: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_JOB_OPERATIONS_N1_'||v_instance_code);
2715:
2716: EXCEPTION
2717: WHEN OTHERS THEN
2718: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_JOB_OPERATIONS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
2719: END;
2720:
2721: BEGIN
2722: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

Line 45879: FROM msc_st_job_operations

45875: AND batch_id = p_batch_id;
45876:
45877: CURSOR c3(p_batch_id NUMBER) IS
45878: SELECT rowid
45879: FROM msc_st_job_operations
45880: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
45881: AND sr_instance_code = v_instance_code
45882: AND batch_id = p_batch_id;
45883:

Line 46829: -- Validation for MSC_ST_JOB_OPERATIONS

46825: IF lv_return < 0 THEN
46826: Raise ex_logging_err;
46827: END IF;
46828:
46829: -- Validation for MSC_ST_JOB_OPERATIONS
46830:
46831: --Duplicate records check for the records whose source is XML
46832:
46833: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

Line 46846: 'UPDATE msc_st_job_operations msro1 '

46842:
46843: v_sql_stmt := 18;
46844:
46845: lv_sql_stmt :=
46846: 'UPDATE msc_st_job_operations msro1 '
46847: ||' SET process_flag = '||G_ERROR_FLG||','
46848: ||' error_text = '||''''||lv_message_text||''''
46849: ||' WHERE message_id < ( SELECT max(message_id) '
46850: ||' FROM msc_st_job_operations msro2'

Line 46850: ||' FROM msc_st_job_operations msro2'

46846: 'UPDATE msc_st_job_operations msro1 '
46847: ||' SET process_flag = '||G_ERROR_FLG||','
46848: ||' error_text = '||''''||lv_message_text||''''
46849: ||' WHERE message_id < ( SELECT max(message_id) '
46850: ||' FROM msc_st_job_operations msro2'
46851: ||' WHERE msro2.sr_instance_code = msro1.sr_instance_code'
46852: ||' AND msro2.organization_code = msro1.organization_code'
46853: ||' AND msro2.wip_entity_name = msro1.wip_entity_name'
46854: ||' AND NVL(msro2.operation_seq_code,'||''''||NULL_CHAR||''''||') '

Line 46885: 'UPDATE msc_st_job_operations msro1'

46881: END IF;
46882:
46883: v_sql_stmt := 19;
46884: lv_sql_stmt :=
46885: 'UPDATE msc_st_job_operations msro1'
46886: ||' SET process_flag = '||G_ERROR_FLG||','
46887: ||' error_text = '||''''||lv_message_text||''''
46888: ||' WHERE EXISTS ( SELECT 1 '
46889: ||' FROM msc_st_job_operations msro2'

Line 46889: ||' FROM msc_st_job_operations msro2'

46885: 'UPDATE msc_st_job_operations msro1'
46886: ||' SET process_flag = '||G_ERROR_FLG||','
46887: ||' error_text = '||''''||lv_message_text||''''
46888: ||' WHERE EXISTS ( SELECT 1 '
46889: ||' FROM msc_st_job_operations msro2'
46890: ||' WHERE msro2.sr_instance_code = msro1.sr_instance_code'
46891: ||' AND msro2.organization_code = msro1.organization_code'
46892: ||' AND msro2.wip_entity_name = msro1.wip_entity_name'
46893: ||' AND NVL(msro2.company_name,'||''''||NULL_CHAR||''''||') '

Line 46952: ' UPDATE msc_st_job_operations '

46948: CLOSE c1;
46949:
46950: v_sql_stmt := 21;
46951: lv_sql_stmt :=
46952: ' UPDATE msc_st_job_operations '
46953: ||' SET batch_id = :lv_batch_id'
46954: ||' WHERE process_flag IN ('||G_IN_PROCESS||','||G_ERROR_FLG||')'
46955: ||' AND sr_instance_code = :v_instance_code'
46956: ||' AND NVL(batch_id,'||NULL_VALUE||') = '||NULL_VALUE

Line 46972: UPDATE msc_st_job_operations

46968: CLOSE c3;
46969:
46970: v_sql_stmt := 22;
46971: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
46972: UPDATE msc_st_job_operations
46973: SET st_transaction_id = msc_st_job_operations_s.NEXTVAL,
46974: refresh_id = v_refresh_id,
46975: last_update_date = v_current_date,
46976: last_updated_by = v_current_user,

Line 46973: SET st_transaction_id = msc_st_job_operations_s.NEXTVAL,

46969:
46970: v_sql_stmt := 22;
46971: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
46972: UPDATE msc_st_job_operations
46973: SET st_transaction_id = msc_st_job_operations_s.NEXTVAL,
46974: refresh_id = v_refresh_id,
46975: last_update_date = v_current_date,
46976: last_updated_by = v_current_user,
46977: creation_date = v_current_date,

Line 46989: p_token_value1 => 'MSC_ST_JOB_OPERATIONS');

46985: p_error_code => 'MSC_PP_NO_DELETION',
46986: p_message_text => lv_message_text,
46987: p_error_text => lv_error_text,
46988: p_token1 => 'TABLE_NAME',
46989: p_token_value1 => 'MSC_ST_JOB_OPERATIONS');
46990:
46991: IF lv_return <> 0 THEN
46992: RAISE ex_logging_err;
46993: END IF;

Line 46998: ' UPDATE msc_st_job_operations '

46994:
46995: --Deletion is not allowed on this table.
46996: v_sql_stmt := 06;
46997: lv_sql_stmt :=
46998: ' UPDATE msc_st_job_operations '
46999: ||' SET process_flag ='||G_ERROR_FLG||','
47000: ||' error_text = '||''''||lv_message_text||''''
47001: ||' WHERE deleted_flag = '||SYS_YES
47002: ||' AND process_flag = '||G_IN_PROCESS

Line 47033: (p_table_name => 'MSC_ST_JOB_OPERATIONS',

47029: lv_where_str :=
47030: ' AND NVL(deleted_flag,'||NULL_VALUE||') <>'||SYS_NO;
47031:
47032: lv_return := MSC_ST_UTIL.LOG_ERROR
47033: (p_table_name => 'MSC_ST_JOB_OPERATIONS',
47034: p_instance_code => v_instance_code,
47035: p_row => lv_column_names,
47036: p_severity => G_SEV_WARNING,
47037: p_message_text => lv_message_text,

Line 47065: MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID(p_table_name => 'MSC_ST_JOB_OPERATIONS',

47061: END IF;
47062:
47063: -- derive organization id ,
47064: lv_return :=
47065: MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID(p_table_name => 'MSC_ST_JOB_OPERATIONS',
47066: p_org_partner_name =>'ORGANIZATION_CODE',
47067: p_org_partner_id =>'ORGANIZATION_ID',
47068: p_instance_code => v_instance_code,
47069: p_partner_type => G_ORGANIZATION,

Line 47096: 'UPDATE msc_st_job_operations'

47092: END IF;
47093:
47094: v_sql_stmt := 6;
47095: lv_sql_stmt :=
47096: 'UPDATE msc_st_job_operations'
47097: ||' SET error_text = '||''''||lv_message_text||''''||','
47098: ||' process_flag = '||G_ERROR_FLG
47099: ||' WHERE NVL(wip_entity_name,'||''''||NULL_CHAR||''''||') '
47100: ||' = '||''''||NULL_CHAR||''''

Line 47116: 'UPDATE msc_st_job_operations mss'

47112:
47113: --Deriving wip_entity_id
47114: v_sql_stmt := 10;
47115: lv_sql_stmt :=
47116: 'UPDATE msc_st_job_operations mss'
47117: ||' SET wip_entity_id = (SELECT local_id'
47118: ||' FROM msc_local_id_supply mls'
47119: ||' WHERE mls.char4 = mss.wip_entity_name'
47120: ||' AND mls.char3 = mss.organization_code'

Line 47160: 'UPDATE msc_st_job_operations msrr'

47156: -- Error out the records if WIP_ENTITY_ID NULL
47157:
47158: v_sql_stmt := 11;
47159: lv_sql_stmt:=
47160: 'UPDATE msc_st_job_operations msrr'
47161: ||' SET process_flag ='||G_ERROR_FLG||','
47162: ||' error_text = '||''''||lv_message_text||''''
47163: ||' WHERE NVL(wip_entity_id,'||NULL_VALUE||') = '||NULL_VALUE
47164: ||' AND sr_instance_code = :v_instance_code'

Line 47190: 'UPDATE msc_st_job_operations'

47186: -- Error out the records where RECOMMENDED is not 'Y' or 'N'
47187:
47188: v_sql_stmt := 7;
47189: lv_sql_stmt :=
47190: 'UPDATE msc_st_job_operations'
47191: ||' SET process_flag ='||G_ERROR_FLG||','
47192: ||' error_text = '||''''||lv_message_text||''''
47193: ||' WHERE recommended NOT IN (''Y'', ''N'')'
47194: ||' AND sr_instance_code = :v_instance_code'

Line 47207: 'UPDATE msc_st_job_operations '

47203: -- Now we will check whether Routing Name is NULL , if it is NULL we will populate the
47204: -- ASSEMBLY NAME in ROUTING_NAME column for all such records
47205:
47206: lv_sql_stmt :=
47207: 'UPDATE msc_st_job_operations '
47208: ||' SET routing_name = assembly_name'
47209: ||' WHERE sr_instance_code = :v_instance_code'
47210: ||' AND process_flag = '||G_IN_PROCESS
47211: ||' AND NVL(routing_name,'||''''||NULL_CHAR||''''||') '

Line 47234: p_token_value3 => 'MSC_ST_JOB_OPERATIONS' );

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
47237: RAISE ex_logging_err;
47238: END IF;

Line 47244: (p_table_name => 'MSC_ST_JOB_OPERATIONS',

47240: -- Derive the ROUTING_SEQUENCE_ID from LOCAL ID table
47241:
47242: lv_return :=
47243: MSC_ST_UTIL.DERIVE_ROUTING_SEQUENCE_ID
47244: (p_table_name => 'MSC_ST_JOB_OPERATIONS',
47245: p_rtg_col_name => 'ROUTING_NAME',
47246: p_rtg_col_id => 'ROUTING_SEQUENCE_ID',
47247: p_instance_code => v_instance_code,
47248: p_severity => G_SEV_ERROR,

Line 47281: (p_table_name => 'MSC_ST_JOB_OPERATIONS',

47277: lv_where_str :=
47278: ' AND NVL(effectivity_date,SYSDATE-36500 ) = SYSDATE-36500 ' ;
47279:
47280: lv_return := MSC_ST_UTIL.LOG_ERROR
47281: (p_table_name => 'MSC_ST_JOB_OPERATIONS',
47282: p_instance_code => v_instance_code,
47283: p_row => lv_column_names,
47284: p_severity => G_SEV_WARNING,
47285: p_message_text => lv_message_text,

Line 47301: 'UPDATE msc_st_job_operations mson'

47297: -- Derive operation_seq_num, operation_sequence_id
47298:
47299: v_sql_stmt := 18;
47300: lv_sql_Stmt :=
47301: 'UPDATE msc_st_job_operations mson'
47302: ||' SET (operation_sequence_id, operation_seq_num) = (SELECT local_id, number1'
47303: ||' FROM msc_local_id_setup mlis'
47304: ||' WHERE mlis.char1 = mson.sr_instance_code'
47305: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 47344: 'UPDATE msc_st_job_operations'

47340: -- Error out the records whose operation_sequence_id, operation_seq_num is NULL
47341:
47342: v_sql_stmt := 19;
47343: lv_sql_stmt :=
47344: 'UPDATE msc_st_job_operations'
47345: ||' SET process_flag ='||G_ERROR_FLG||','
47346: ||' error_text = '||''''||lv_message_text||''''
47347: ||' WHERE (NVL(operation_sequence_id,'||NULL_VALUE||') ='||NULL_VALUE
47348: ||' OR NVL(operation_seq_num,'||NULL_VALUE||') ='||NULL_VALUE||')'

Line 47361: 'UPDATE msc_st_job_operations msro'

47357:
47358: -- Derive department id
47359: v_sql_stmt := 27;
47360: lv_sql_stmt :=
47361: 'UPDATE msc_st_job_operations msro'
47362: ||' SET department_id= (SELECT local_id'
47363: ||' FROM msc_local_id_setup mlis'
47364: ||' WHERE mlis.char1 = msro.sr_instance_code'
47365: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 47392: p_token_value3 => 'MSC_ST_JOB_OPERATIONS' );

47388: ||'ORGANIZATION_CODE,DEPARTMENT_CODE',
47389: p_token2 => 'MASTER_TABLE',
47390: p_token_value2 => 'MSC_ST_DEPARTMENT_RESOURCES',
47391: p_token3 => 'CHILD_TABLE' ,
47392: p_token_value3 => 'MSC_ST_JOB_OPERATIONS' );
47393:
47394: IF lv_return <> 0 THEN
47395: RAISE ex_logging_err;
47396: END IF;

Line 47402: 'UPDATE msc_st_job_operations '

47398: -- Log an error if unable to derive department id
47399:
47400: v_sql_stmt := 28;
47401: lv_sql_stmt :=
47402: 'UPDATE msc_st_job_operations '
47403: ||' SET process_flag ='||G_ERROR_FLG||','
47404: ||' error_text = '||''''||lv_message_text||''''
47405: ||' WHERE NVL(department_id,'||NULL_VALUE||') ='||NULL_VALUE
47406: ||' AND sr_instance_code = :v_instance_code'

Line 47423: pEntityName => 'MSC_ST_JOB_OPERATIONS',

47419: (ERRBUF => lv_error_text,
47420: RETCODE => lv_return,
47421: pBatchID => lv_batch_id,
47422: pInstanceCode => v_instance_code,
47423: pEntityName => 'MSC_ST_JOB_OPERATIONS',
47424: pInstanceID => v_instance_id);
47425:
47426: IF NVL(lv_return,0) <> 0 THEN
47427: RAISE ex_logging_err;

Line 47432: MSC_ST_UTIL.SET_PROCESS_FLAG(p_table_name => 'MSC_ST_JOB_OPERATIONS',

47428: END IF;
47429:
47430: -- Set the process flag as Valid and derive sr_instance_id
47431: lv_return :=
47432: MSC_ST_UTIL.SET_PROCESS_FLAG(p_table_name => 'MSC_ST_JOB_OPERATIONS',
47433: p_instance_id => v_instance_id,
47434: p_instance_code => v_instance_code,
47435: p_process_flag => G_VALID,
47436: p_error_text => lv_error_text,

Line 47448: MSC_ST_UTIL.LOG_ERROR(p_table_name => 'MSC_ST_JOB_OPERATIONS',

47444:
47445: -- At the end calling the LOG_ERROR for logging all errored out records
47446:
47447: lv_return :=
47448: MSC_ST_UTIL.LOG_ERROR(p_table_name => 'MSC_ST_JOB_OPERATIONS',
47449: p_instance_code => v_instance_code,
47450: p_row => lv_column_names,
47451: p_severity => G_SEV_ERROR,
47452: p_message_text => NULL,

Line 50864: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_JOB_OPERATIONS');

50860: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_JOB_OPERATION_NETWORKS');
50861: IF lv_count > 0 Then
50862: prec.wip_flag:= SYS_YES;
50863: End IF;
50864: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_JOB_OPERATIONS');
50865: IF lv_count > 0 Then
50866: prec.wip_flag:= SYS_YES;
50867: End IF;
50868: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_JOB_REQUIREMENT_OPS');