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 1606: 'create index MSC_ST_JOB_OPERATIONS_N1_'||v_instance_code

1602: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1603: application_short_name => 'MSC',
1604: statement_type => AD_DDL.CREATE_INDEX,
1605: statement =>
1606: 'create index MSC_ST_JOB_OPERATIONS_N1_'||v_instance_code
1607: ||' on MSC_ST_JOB_OPERATIONS '
1608: ||'(SR_INSTANCE_CODE, ORGANIZATION_CODE, WIP_ENTITY_NAME, OPERATION_SEQ_CODE ) '
1609: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1610: object_name =>'MSC_ST_JOB_OPERATIONS_N1_'||v_instance_code);

Line 1607: ||' on MSC_ST_JOB_OPERATIONS '

1603: application_short_name => 'MSC',
1604: statement_type => AD_DDL.CREATE_INDEX,
1605: statement =>
1606: 'create index MSC_ST_JOB_OPERATIONS_N1_'||v_instance_code
1607: ||' on MSC_ST_JOB_OPERATIONS '
1608: ||'(SR_INSTANCE_CODE, ORGANIZATION_CODE, WIP_ENTITY_NAME, OPERATION_SEQ_CODE ) '
1609: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1610: object_name =>'MSC_ST_JOB_OPERATIONS_N1_'||v_instance_code);
1611: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_JOB_OPERATIONS_N1_'||v_instance_code);

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

1606: 'create index MSC_ST_JOB_OPERATIONS_N1_'||v_instance_code
1607: ||' on MSC_ST_JOB_OPERATIONS '
1608: ||'(SR_INSTANCE_CODE, ORGANIZATION_CODE, WIP_ENTITY_NAME, OPERATION_SEQ_CODE ) '
1609: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1610: object_name =>'MSC_ST_JOB_OPERATIONS_N1_'||v_instance_code);
1611: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_JOB_OPERATIONS_N1_'||v_instance_code);
1612:
1613: EXCEPTION
1614: WHEN OTHERS THEN

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

1607: ||' on MSC_ST_JOB_OPERATIONS '
1608: ||'(SR_INSTANCE_CODE, ORGANIZATION_CODE, WIP_ENTITY_NAME, OPERATION_SEQ_CODE ) '
1609: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1610: object_name =>'MSC_ST_JOB_OPERATIONS_N1_'||v_instance_code);
1611: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_JOB_OPERATIONS_N1_'||v_instance_code);
1612:
1613: EXCEPTION
1614: WHEN OTHERS THEN
1615: 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 1615: 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));

1611: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_JOB_OPERATIONS_N1_'||v_instance_code);
1612:
1613: EXCEPTION
1614: WHEN OTHERS THEN
1615: 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));
1616: END;
1617:
1618: BEGIN
1619: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

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

2715: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2716: application_short_name => 'MSC',
2717: statement_type => AD_DDL.DROP_INDEX,
2718: statement =>
2719: 'drop index MSC_ST_JOB_OPERATIONS_N1_'||v_instance_code,
2720: object_name => 'MSC_ST_JOB_OPERATIONS_N1_'||v_instance_code);
2721:
2722: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_JOB_OPERATIONS_N1_'||v_instance_code);
2723:

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

2716: application_short_name => 'MSC',
2717: statement_type => AD_DDL.DROP_INDEX,
2718: statement =>
2719: 'drop index MSC_ST_JOB_OPERATIONS_N1_'||v_instance_code,
2720: object_name => 'MSC_ST_JOB_OPERATIONS_N1_'||v_instance_code);
2721:
2722: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_JOB_OPERATIONS_N1_'||v_instance_code);
2723:
2724: EXCEPTION

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

2718: statement =>
2719: 'drop index MSC_ST_JOB_OPERATIONS_N1_'||v_instance_code,
2720: object_name => 'MSC_ST_JOB_OPERATIONS_N1_'||v_instance_code);
2721:
2722: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_JOB_OPERATIONS_N1_'||v_instance_code);
2723:
2724: EXCEPTION
2725: WHEN OTHERS THEN
2726: 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 2726: 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));

2722: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_JOB_OPERATIONS_N1_'||v_instance_code);
2723:
2724: EXCEPTION
2725: WHEN OTHERS THEN
2726: 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));
2727: END;
2728:
2729: BEGIN
2730: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

Line 50763: FROM msc_st_job_operations

50759: AND batch_id = p_batch_id;
50760:
50761: CURSOR c3(p_batch_id NUMBER) IS
50762: SELECT rowid
50763: FROM msc_st_job_operations
50764: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
50765: AND sr_instance_code = v_instance_code
50766: AND batch_id = p_batch_id;
50767:

Line 51713: -- Validation for MSC_ST_JOB_OPERATIONS

51709: IF lv_return < 0 THEN
51710: Raise ex_logging_err;
51711: END IF;
51712:
51713: -- Validation for MSC_ST_JOB_OPERATIONS
51714:
51715: --Duplicate records check for the records whose source is XML
51716:
51717: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

Line 51730: 'UPDATE msc_st_job_operations msro1 '

51726:
51727: v_sql_stmt := 18;
51728:
51729: lv_sql_stmt :=
51730: 'UPDATE msc_st_job_operations msro1 '
51731: ||' SET process_flag = '||G_ERROR_FLG||','
51732: ||' error_text = '||''''||lv_message_text||''''
51733: ||' WHERE message_id < ( SELECT max(message_id) '
51734: ||' FROM msc_st_job_operations msro2'

Line 51734: ||' FROM msc_st_job_operations msro2'

51730: 'UPDATE msc_st_job_operations msro1 '
51731: ||' SET process_flag = '||G_ERROR_FLG||','
51732: ||' error_text = '||''''||lv_message_text||''''
51733: ||' WHERE message_id < ( SELECT max(message_id) '
51734: ||' FROM msc_st_job_operations msro2'
51735: ||' WHERE msro2.sr_instance_code = msro1.sr_instance_code'
51736: ||' AND msro2.organization_code = msro1.organization_code'
51737: ||' AND msro2.wip_entity_name = msro1.wip_entity_name'
51738: ||' AND NVL(msro2.operation_seq_code,'||''''||NULL_CHAR||''''||') '

Line 51769: 'UPDATE msc_st_job_operations msro1'

51765: END IF;
51766:
51767: v_sql_stmt := 19;
51768: lv_sql_stmt :=
51769: 'UPDATE msc_st_job_operations msro1'
51770: ||' SET process_flag = '||G_ERROR_FLG||','
51771: ||' error_text = '||''''||lv_message_text||''''
51772: ||' WHERE EXISTS ( SELECT 1 '
51773: ||' FROM msc_st_job_operations msro2'

Line 51773: ||' FROM msc_st_job_operations msro2'

51769: 'UPDATE msc_st_job_operations msro1'
51770: ||' SET process_flag = '||G_ERROR_FLG||','
51771: ||' error_text = '||''''||lv_message_text||''''
51772: ||' WHERE EXISTS ( SELECT 1 '
51773: ||' FROM msc_st_job_operations msro2'
51774: ||' WHERE msro2.sr_instance_code = msro1.sr_instance_code'
51775: ||' AND msro2.organization_code = msro1.organization_code'
51776: ||' AND msro2.wip_entity_name = msro1.wip_entity_name'
51777: ||' AND NVL(msro2.company_name,'||''''||NULL_CHAR||''''||') '

Line 51836: ' UPDATE msc_st_job_operations '

51832: CLOSE c1;
51833:
51834: v_sql_stmt := 21;
51835: lv_sql_stmt :=
51836: ' UPDATE msc_st_job_operations '
51837: ||' SET batch_id = :lv_batch_id'
51838: ||' WHERE process_flag IN ('||G_IN_PROCESS||','||G_ERROR_FLG||')'
51839: ||' AND sr_instance_code = :v_instance_code'
51840: ||' AND NVL(batch_id,'||NULL_VALUE||') = '||NULL_VALUE

Line 51856: UPDATE msc_st_job_operations

51852: CLOSE c3;
51853:
51854: v_sql_stmt := 22;
51855: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
51856: UPDATE msc_st_job_operations
51857: SET st_transaction_id = msc_st_job_operations_s.NEXTVAL,
51858: refresh_id = v_refresh_id,
51859: last_update_date = v_current_date,
51860: last_updated_by = v_current_user,

Line 51857: SET st_transaction_id = msc_st_job_operations_s.NEXTVAL,

51853:
51854: v_sql_stmt := 22;
51855: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
51856: UPDATE msc_st_job_operations
51857: SET st_transaction_id = msc_st_job_operations_s.NEXTVAL,
51858: refresh_id = v_refresh_id,
51859: last_update_date = v_current_date,
51860: last_updated_by = v_current_user,
51861: creation_date = v_current_date,

Line 51873: p_token_value1 => 'MSC_ST_JOB_OPERATIONS');

51869: p_error_code => 'MSC_PP_NO_DELETION',
51870: p_message_text => lv_message_text,
51871: p_error_text => lv_error_text,
51872: p_token1 => 'TABLE_NAME',
51873: p_token_value1 => 'MSC_ST_JOB_OPERATIONS');
51874:
51875: IF lv_return <> 0 THEN
51876: RAISE ex_logging_err;
51877: END IF;

Line 51882: ' UPDATE msc_st_job_operations '

51878:
51879: --Deletion is not allowed on this table.
51880: v_sql_stmt := 06;
51881: lv_sql_stmt :=
51882: ' UPDATE msc_st_job_operations '
51883: ||' SET process_flag ='||G_ERROR_FLG||','
51884: ||' error_text = '||''''||lv_message_text||''''
51885: ||' WHERE deleted_flag = '||SYS_YES
51886: ||' AND process_flag = '||G_IN_PROCESS

Line 51917: (p_table_name => 'MSC_ST_JOB_OPERATIONS',

51913: lv_where_str :=
51914: ' AND NVL(deleted_flag,'||NULL_VALUE||') <>'||SYS_NO;
51915:
51916: lv_return := MSC_ST_UTIL.LOG_ERROR
51917: (p_table_name => 'MSC_ST_JOB_OPERATIONS',
51918: p_instance_code => v_instance_code,
51919: p_row => lv_column_names,
51920: p_severity => G_SEV_WARNING,
51921: p_message_text => lv_message_text,

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

51945: END IF;
51946:
51947: -- derive organization id ,
51948: lv_return :=
51949: MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID(p_table_name => 'MSC_ST_JOB_OPERATIONS',
51950: p_org_partner_name =>'ORGANIZATION_CODE',
51951: p_org_partner_id =>'ORGANIZATION_ID',
51952: p_instance_code => v_instance_code,
51953: p_partner_type => G_ORGANIZATION,

Line 51980: 'UPDATE msc_st_job_operations'

51976: END IF;
51977:
51978: v_sql_stmt := 6;
51979: lv_sql_stmt :=
51980: 'UPDATE msc_st_job_operations'
51981: ||' SET error_text = '||''''||lv_message_text||''''||','
51982: ||' process_flag = '||G_ERROR_FLG
51983: ||' WHERE NVL(wip_entity_name,'||''''||NULL_CHAR||''''||') '
51984: ||' = '||''''||NULL_CHAR||''''

Line 52000: 'UPDATE msc_st_job_operations mss'

51996:
51997: --Deriving wip_entity_id
51998: v_sql_stmt := 10;
51999: lv_sql_stmt :=
52000: 'UPDATE msc_st_job_operations mss'
52001: ||' SET wip_entity_id = (SELECT local_id'
52002: ||' FROM msc_local_id_supply mls'
52003: ||' WHERE mls.char4 = mss.wip_entity_name'
52004: ||' AND mls.char3 = mss.organization_code'

Line 52044: 'UPDATE msc_st_job_operations msrr'

52040: -- Error out the records if WIP_ENTITY_ID NULL
52041:
52042: v_sql_stmt := 11;
52043: lv_sql_stmt:=
52044: 'UPDATE msc_st_job_operations msrr'
52045: ||' SET process_flag ='||G_ERROR_FLG||','
52046: ||' error_text = '||''''||lv_message_text||''''
52047: ||' WHERE NVL(wip_entity_id,'||NULL_VALUE||') = '||NULL_VALUE
52048: ||' AND sr_instance_code = :v_instance_code'

Line 52074: 'UPDATE msc_st_job_operations'

52070: -- Error out the records where RECOMMENDED is not 'Y' or 'N'
52071:
52072: v_sql_stmt := 7;
52073: lv_sql_stmt :=
52074: 'UPDATE msc_st_job_operations'
52075: ||' SET process_flag ='||G_ERROR_FLG||','
52076: ||' error_text = '||''''||lv_message_text||''''
52077: ||' WHERE recommended NOT IN (''Y'', ''N'')'
52078: ||' AND sr_instance_code = :v_instance_code'

Line 52091: 'UPDATE msc_st_job_operations '

52087: -- Now we will check whether Routing Name is NULL , if it is NULL we will populate the
52088: -- ASSEMBLY NAME in ROUTING_NAME column for all such records
52089:
52090: lv_sql_stmt :=
52091: 'UPDATE msc_st_job_operations '
52092: ||' SET routing_name = assembly_name'
52093: ||' WHERE sr_instance_code = :v_instance_code'
52094: ||' AND process_flag = '||G_IN_PROCESS
52095: ||' AND NVL(routing_name,'||''''||NULL_CHAR||''''||') '

Line 52118: p_token_value3 => 'MSC_ST_JOB_OPERATIONS' );

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
52121: RAISE ex_logging_err;
52122: END IF;

Line 52128: (p_table_name => 'MSC_ST_JOB_OPERATIONS',

52124: -- Derive the ROUTING_SEQUENCE_ID from LOCAL ID table
52125:
52126: lv_return :=
52127: MSC_ST_UTIL.DERIVE_ROUTING_SEQUENCE_ID
52128: (p_table_name => 'MSC_ST_JOB_OPERATIONS',
52129: p_rtg_col_name => 'ROUTING_NAME',
52130: p_rtg_col_id => 'ROUTING_SEQUENCE_ID',
52131: p_instance_code => v_instance_code,
52132: p_severity => G_SEV_ERROR,

Line 52165: (p_table_name => 'MSC_ST_JOB_OPERATIONS',

52161: lv_where_str :=
52162: ' AND NVL(effectivity_date,SYSDATE-36500 ) = SYSDATE-36500 ' ;
52163:
52164: lv_return := MSC_ST_UTIL.LOG_ERROR
52165: (p_table_name => 'MSC_ST_JOB_OPERATIONS',
52166: p_instance_code => v_instance_code,
52167: p_row => lv_column_names,
52168: p_severity => G_SEV_WARNING,
52169: p_message_text => lv_message_text,

Line 52185: 'UPDATE msc_st_job_operations mson'

52181: -- Derive operation_seq_num, operation_sequence_id
52182:
52183: v_sql_stmt := 18;
52184: lv_sql_Stmt :=
52185: 'UPDATE msc_st_job_operations mson'
52186: ||' SET (operation_sequence_id, operation_seq_num) = (SELECT local_id, number1'
52187: ||' FROM msc_local_id_setup mlis'
52188: ||' WHERE mlis.char1 = mson.sr_instance_code'
52189: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 52228: 'UPDATE msc_st_job_operations'

52224: -- Error out the records whose operation_sequence_id, operation_seq_num is NULL
52225:
52226: v_sql_stmt := 19;
52227: lv_sql_stmt :=
52228: 'UPDATE msc_st_job_operations'
52229: ||' SET process_flag ='||G_ERROR_FLG||','
52230: ||' error_text = '||''''||lv_message_text||''''
52231: ||' WHERE (NVL(operation_sequence_id,'||NULL_VALUE||') ='||NULL_VALUE
52232: ||' OR NVL(operation_seq_num,'||NULL_VALUE||') ='||NULL_VALUE||')'

Line 52245: 'UPDATE msc_st_job_operations msro'

52241:
52242: -- Derive department id
52243: v_sql_stmt := 27;
52244: lv_sql_stmt :=
52245: 'UPDATE msc_st_job_operations msro'
52246: ||' SET department_id= (SELECT local_id'
52247: ||' FROM msc_local_id_setup mlis'
52248: ||' WHERE mlis.char1 = msro.sr_instance_code'
52249: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 52276: p_token_value3 => 'MSC_ST_JOB_OPERATIONS' );

52272: ||'ORGANIZATION_CODE,DEPARTMENT_CODE',
52273: p_token2 => 'MASTER_TABLE',
52274: p_token_value2 => 'MSC_ST_DEPARTMENT_RESOURCES',
52275: p_token3 => 'CHILD_TABLE' ,
52276: p_token_value3 => 'MSC_ST_JOB_OPERATIONS' );
52277:
52278: IF lv_return <> 0 THEN
52279: RAISE ex_logging_err;
52280: END IF;

Line 52286: 'UPDATE msc_st_job_operations '

52282: -- Log an error if unable to derive department id
52283:
52284: v_sql_stmt := 28;
52285: lv_sql_stmt :=
52286: 'UPDATE msc_st_job_operations '
52287: ||' SET process_flag ='||G_ERROR_FLG||','
52288: ||' error_text = '||''''||lv_message_text||''''
52289: ||' WHERE NVL(department_id,'||NULL_VALUE||') ='||NULL_VALUE
52290: ||' AND sr_instance_code = :v_instance_code'

Line 52307: pEntityName => 'MSC_ST_JOB_OPERATIONS',

52303: (ERRBUF => lv_error_text,
52304: RETCODE => lv_return,
52305: pBatchID => lv_batch_id,
52306: pInstanceCode => v_instance_code,
52307: pEntityName => 'MSC_ST_JOB_OPERATIONS',
52308: pInstanceID => v_instance_id);
52309:
52310: IF NVL(lv_return,0) <> 0 THEN
52311: RAISE ex_logging_err;

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

52312: END IF;
52313:
52314: -- Set the process flag as Valid and derive sr_instance_id
52315: lv_return :=
52316: MSC_ST_UTIL.SET_PROCESS_FLAG(p_table_name => 'MSC_ST_JOB_OPERATIONS',
52317: p_instance_id => v_instance_id,
52318: p_instance_code => v_instance_code,
52319: p_process_flag => G_VALID,
52320: p_error_text => lv_error_text,

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

52328:
52329: -- At the end calling the LOG_ERROR for logging all errored out records
52330:
52331: lv_return :=
52332: MSC_ST_UTIL.LOG_ERROR(p_table_name => 'MSC_ST_JOB_OPERATIONS',
52333: p_instance_code => v_instance_code,
52334: p_row => lv_column_names,
52335: p_severity => G_SEV_ERROR,
52336: p_message_text => NULL,

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

55774: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_JOB_OPERATION_NETWORKS');
55775: IF lv_count > 0 Then
55776: prec.wip_flag:= SYS_YES;
55777: End IF;
55778: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_JOB_OPERATIONS');
55779: IF lv_count > 0 Then
55780: prec.wip_flag:= SYS_YES;
55781: End IF;
55782: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_JOB_REQUIREMENT_OPS');