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_BOMS

Line 728: 'create index MSC_ST_BOMS_N1_'||v_instance_code

724: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
725: application_short_name => 'MSC',
726: statement_type => AD_DDL.CREATE_INDEX,
727: statement =>
728: 'create index MSC_ST_BOMS_N1_'||v_instance_code
729: ||' on MSC_ST_BOMS '
730: ||'(sr_instance_code, assembly_name, organization_code, company_name, bom_name, alternate_bom_designator) '
731: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
732: object_name =>'MSC_ST_BOMS_N1_'||v_instance_code);

Line 729: ||' on MSC_ST_BOMS '

725: application_short_name => 'MSC',
726: statement_type => AD_DDL.CREATE_INDEX,
727: statement =>
728: 'create index MSC_ST_BOMS_N1_'||v_instance_code
729: ||' on MSC_ST_BOMS '
730: ||'(sr_instance_code, assembly_name, organization_code, company_name, bom_name, alternate_bom_designator) '
731: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
732: object_name =>'MSC_ST_BOMS_N1_'||v_instance_code);
733: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_BOMS_N1_'||v_instance_code);

Line 732: object_name =>'MSC_ST_BOMS_N1_'||v_instance_code);

728: 'create index MSC_ST_BOMS_N1_'||v_instance_code
729: ||' on MSC_ST_BOMS '
730: ||'(sr_instance_code, assembly_name, organization_code, company_name, bom_name, alternate_bom_designator) '
731: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
732: object_name =>'MSC_ST_BOMS_N1_'||v_instance_code);
733: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_BOMS_N1_'||v_instance_code);
734:
735: EXCEPTION
736: WHEN OTHERS THEN

Line 733: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_BOMS_N1_'||v_instance_code);

729: ||' on MSC_ST_BOMS '
730: ||'(sr_instance_code, assembly_name, organization_code, company_name, bom_name, alternate_bom_designator) '
731: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
732: object_name =>'MSC_ST_BOMS_N1_'||v_instance_code);
733: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_BOMS_N1_'||v_instance_code);
734:
735: EXCEPTION
736: WHEN OTHERS THEN
737: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_BOMS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));

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

733: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_BOMS_N1_'||v_instance_code);
734:
735: EXCEPTION
736: WHEN OTHERS THEN
737: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_BOMS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
738: END;
739:
740: BEGIN
741: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

Line 793: msc_analyse_tables_pk.analyse_table( 'MSC_ST_BOMS', v_instance_id, -1);

789: WHEN OTHERS THEN
790: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_CO_PRODUCTS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
791: END;
792:
793: msc_analyse_tables_pk.analyse_table( 'MSC_ST_BOMS', v_instance_id, -1);
794: msc_analyse_tables_pk.analyse_table( 'MSC_ST_BOM_COMPONENTS', v_instance_id, -1);
795: msc_analyse_tables_pk.analyse_table( 'MSC_ST_COMPONENT_SUBSTITUTES', v_instance_id, -1);
796: msc_analyse_tables_pk.analyse_table( 'MSC_ST_CO_PRODUCTS', v_instance_id, -1);
797:

Line 2022: 'drop index MSC_ST_BOMS_N1_'||v_instance_code,

2018: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2019: application_short_name => 'MSC',
2020: statement_type => AD_DDL.DROP_INDEX,
2021: statement =>
2022: 'drop index MSC_ST_BOMS_N1_'||v_instance_code,
2023: object_name => 'MSC_ST_BOMS_N1_'||v_instance_code);
2024:
2025: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_BOMS_N1_'||v_instance_code);
2026: EXCEPTION

Line 2023: object_name => 'MSC_ST_BOMS_N1_'||v_instance_code);

2019: application_short_name => 'MSC',
2020: statement_type => AD_DDL.DROP_INDEX,
2021: statement =>
2022: 'drop index MSC_ST_BOMS_N1_'||v_instance_code,
2023: object_name => 'MSC_ST_BOMS_N1_'||v_instance_code);
2024:
2025: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_BOMS_N1_'||v_instance_code);
2026: EXCEPTION
2027: WHEN OTHERS THEN

Line 2025: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_BOMS_N1_'||v_instance_code);

2021: statement =>
2022: 'drop index MSC_ST_BOMS_N1_'||v_instance_code,
2023: object_name => 'MSC_ST_BOMS_N1_'||v_instance_code);
2024:
2025: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_BOMS_N1_'||v_instance_code);
2026: EXCEPTION
2027: WHEN OTHERS THEN
2028: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_BOMS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
2029: END;

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

2024:
2025: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_BOMS_N1_'||v_instance_code);
2026: EXCEPTION
2027: WHEN OTHERS THEN
2028: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_BOMS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
2029: END;
2030:
2031: BEGIN
2032: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

Line 35241: | msc_st_boms. Its called from LOAD_BOM after pre processing |

35237:
35238: /*==========================================================================+
35239: | DESCRIPTION : This function performs insertion of co products records |
35240: | into msc_st_bom_componenets plus updates the records in |
35241: | msc_st_boms. Its called from LOAD_BOM after pre processing |
35242: | CO PRODUCTS. Included for OSFM Integration |
35243: +==========================================================================*/
35244:
35245: PROCEDURE LOAD_CO_PRODUCT_BOMS IS

Line 35296: || ' from msc_st_boms msb '

35292:
35293:
35294: -- selecting all the valid boms for the selected Co Product from staging table + ODS--
35295: v_query_str2 := ' select msb.bill_sequence_id,msb.rowid,0 '
35296: || ' from msc_st_boms msb '
35297: || ' where msb.assembly_item_id = :lv_assembly_item_id '
35298: || ' AND msb.process_flag = '|| G_VALID
35299: || ' and sr_instance_code = :v_instance_code '
35300: || ' UNION '

Line 35309: || ' from msc_st_boms msb1'

35305: || ' and lid.SR_INVENTORY_ITEM_ID = :lv_assembly_item_id '
35306: || ' and lid.SR_INSTANCE_ID = :v_instance_id '
35307: || ' and mb.bill_sequence_id not in '
35308: || ' ( select msb1.bill_sequence_id '
35309: || ' from msc_st_boms msb1'
35310: || ' where msb1.assembly_item_id = :lv_assembly_item_id '
35311: || ' AND msb1.process_flag = '|| G_VALID
35312: || ' and sr_instance_code = :v_instance_code )';
35313:

Line 35453: update msc_st_boms

35449:
35450: IF lv_ODS_flag = 0 THEN -- if the BOM record is in the staging table
35451:
35452: v_sql_stmt := 06;
35453: update msc_st_boms
35454: set assembly_quantity = (l_split_cur1/100)
35455: where rowid = l_rowid_cur2 ;
35456:
35457: ELSE -- if the BOM record is in the ODS

Line 35460: insert into MSC_ST_BOMS

35456:
35457: ELSE -- if the BOM record is in the ODS
35458:
35459: v_sql_stmt := 07;
35460: insert into MSC_ST_BOMS
35461: ( BILL_SEQUENCE_ID,
35462: ORGANIZATION_ID,
35463: ASSEMBLY_ITEM_ID,
35464: ASSEMBLY_TYPE,

Line 35489: -- and MSC_ST_BOMS stores SR_INVENTORY_ITEM_ID in ASSEMBLY_ITEM_ID

35485: 2,
35486: v_refresh_id,
35487: v_instance_id
35488: -- note the join on MSC_ITEM_ID_LID because MSC_BOMS stores ASSEMBLY_ITEM_ID
35489: -- and MSC_ST_BOMS stores SR_INVENTORY_ITEM_ID in ASSEMBLY_ITEM_ID
35490: FROM MSC_BOMS msb ,MSC_ITEM_ID_LID lid
35491: WHERE msb. BILL_SEQUENCE_ID = l_bill_sequence_id_cur2
35492: And lid.SR_INSTANCE_ID = msb.SR_INSTANCE_ID
35493: AND lid.INVENTORY_ITEM_ID = msb.ASSEMBLY_ITEM_ID ;

Line 35632: lv_batch_id msc_st_boms.batch_id%TYPE;

35628: lv_error_text VARCHAR2(250);
35629: lv_where_str VARCHAR2(5000);
35630: lv_sql_stmt VARCHAR2(5000);
35631: lv_cursor_stmt VARCHAR2(5000);
35632: lv_batch_id msc_st_boms.batch_id%TYPE;
35633: lv_message_text msc_errors.error_text%TYPE;
35634:
35635: ex_logging_err EXCEPTION;
35636:

Line 35639: FROM msc_st_boms

35635: ex_logging_err EXCEPTION;
35636:
35637: CURSOR c2(p_batch_id NUMBER) IS
35638: SELECT rowid
35639: FROM msc_st_boms
35640: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
35641: AND sr_instance_code = v_instance_code
35642: AND batch_id = p_batch_id;
35643:

Line 35646: FROM msc_st_boms

35642: AND batch_id = p_batch_id;
35643:
35644: CURSOR c3(p_batch_id NUMBER) IS
35645: SELECT rowid
35646: FROM msc_st_boms
35647: WHERE process_flag = G_IN_PROCESS
35648: AND sr_instance_code = v_instance_code
35649: AND batch_id = p_batch_id
35650: AND NVL(bill_sequence_id,NULL_VALUE) = NULL_VALUE

Line 35713: -- Validation fo table msc_st_boms

35709:
35710:
35711: BEGIN
35712:
35713: -- Validation fo table msc_st_boms
35714:
35715: -- Before we start processing the record by group id( batch size ) we are going
35716: -- to check whether that there
35717: -- is any duplicates for user defined unique keys (UDKs,)

Line 35733: 'UPDATE msc_st_boms msb1'

35729: END IF;
35730:
35731: v_sql_stmt := 01;
35732: lv_sql_stmt :=
35733: 'UPDATE msc_st_boms msb1'
35734: ||' SET process_flag = '||G_ERROR_FLG||','
35735: ||' error_text = '||''''||lv_message_text||''''
35736: ||' WHERE message_id < (SELECT MAX(message_id)'
35737: ||' FROM msc_st_boms msb2'

Line 35737: ||' FROM msc_st_boms msb2'

35733: 'UPDATE msc_st_boms msb1'
35734: ||' SET process_flag = '||G_ERROR_FLG||','
35735: ||' error_text = '||''''||lv_message_text||''''
35736: ||' WHERE message_id < (SELECT MAX(message_id)'
35737: ||' FROM msc_st_boms msb2'
35738: ||' WHERE msb2.sr_instance_code = msb1.sr_instance_code'
35739: ||' AND msb2.organization_code = msb1.organization_code'
35740: ||' AND NVL(msb2.bom_name,'||''''||NULL_CHAR||''''||') '
35741: ||' = NVL(msb1.bom_name, '||''''||NULL_CHAR||''''||') '

Line 35772: 'UPDATE msc_st_boms msb1'

35768: END IF;
35769: v_sql_stmt := 02;
35770:
35771: lv_sql_stmt :=
35772: 'UPDATE msc_st_boms msb1'
35773: ||' SET process_flag = '||G_ERROR_FLG||','
35774: ||' error_text = '||''''||lv_message_text||''''
35775: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_boms msb2'
35776: ||' WHERE msb2.sr_instance_code = msb1.sr_instance_code'

Line 35775: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_boms msb2'

35771: lv_sql_stmt :=
35772: 'UPDATE msc_st_boms msb1'
35773: ||' SET process_flag = '||G_ERROR_FLG||','
35774: ||' error_text = '||''''||lv_message_text||''''
35775: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_boms msb2'
35776: ||' WHERE msb2.sr_instance_code = msb1.sr_instance_code'
35777: ||' AND msb2.organization_code = msb1.organization_code'
35778: ||' AND NVL(msb2.bom_name,'||''''||NULL_CHAR||''''||') '
35779: ||' = NVL(msb1.bom_name, '||''''||NULL_CHAR||''''||') '

Line 35825: ' UPDATE msc_st_boms '

35821: CLOSE c1;
35822:
35823: v_sql_stmt := 04;
35824: lv_sql_stmt :=
35825: ' UPDATE msc_st_boms '
35826: ||' SET batch_id = :lv_batch_id'
35827: ||' WHERE process_flag IN ('||G_IN_PROCESS||','||G_ERROR_FLG||')'
35828: ||' AND sr_instance_code = :v_instance_code'
35829: ||' AND NVL(batch_id,'||NULL_VALUE||') = '||NULL_VALUE

Line 35845: UPDATE msc_st_boms

35841: CLOSE c2;
35842:
35843: v_sql_stmt := 05;
35844: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
35845: UPDATE msc_st_boms
35846: SET st_transaction_id = msc_st_boms_s.NEXTVAL,
35847: refresh_id = v_refresh_id,
35848: last_update_date = v_current_date,
35849: last_updated_by = v_current_user,

Line 35846: SET st_transaction_id = msc_st_boms_s.NEXTVAL,

35842:
35843: v_sql_stmt := 05;
35844: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
35845: UPDATE msc_st_boms
35846: SET st_transaction_id = msc_st_boms_s.NEXTVAL,
35847: refresh_id = v_refresh_id,
35848: last_update_date = v_current_date,
35849: last_updated_by = v_current_user,
35850: creation_date = v_current_date,

Line 35863: p_token_value1 => 'MSC_ST_BOMS');

35859: p_error_code => 'MSC_PP_NO_DELETION',
35860: p_message_text => lv_message_text,
35861: p_error_text => lv_error_text,
35862: p_token1 => 'TABLE_NAME',
35863: p_token_value1 => 'MSC_ST_BOMS');
35864:
35865: IF lv_return <> 0 THEN
35866: RAISE ex_logging_err;
35867: END IF;

Line 35872: ' UPDATE msc_st_boms '

35868:
35869: --Deletion is not allowed on this table.
35870: v_sql_stmt := 06;
35871: lv_sql_stmt :=
35872: ' UPDATE msc_st_boms '
35873: ||' SET process_flag = '||G_ERROR_FLG||','
35874: ||' error_text = '||''''||lv_message_text||''''
35875: ||' WHERE deleted_flag = '||SYS_YES
35876: ||' AND process_flag = '||G_IN_PROCESS

Line 35908: (p_table_name => 'MSC_ST_BOMS',

35904:
35905: lv_where_str := ' AND NVL(deleted_flag,'||NULL_VALUE||') <>'||SYS_NO;
35906:
35907: lv_return := MSC_ST_UTIL.LOG_ERROR
35908: (p_table_name => 'MSC_ST_BOMS',
35909: p_instance_code => v_instance_code,
35910: p_row => lv_column_names,
35911: p_severity => G_SEV_WARNING,
35912: p_message_text => lv_message_text,

Line 35942: MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID(p_table_name => 'MSC_ST_BOMS',

35938:
35939: -- Populate organization id
35940:
35941: lv_return :=
35942: MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID(p_table_name => 'MSC_ST_BOMS',
35943: p_org_partner_name => 'ORGANIZATION_CODE',
35944: p_org_partner_id => 'ORGANIZATION_ID',
35945: p_instance_code => v_instance_code,
35946: p_partner_type => G_ORGANIZATION,

Line 35973: MSC_ST_UTIL.DERIVE_ITEM_ID(p_table_name =>'MSC_ST_BOMS',

35969: END IF;
35970:
35971: -- Poplulate assembly item id
35972: lv_return :=
35973: MSC_ST_UTIL.DERIVE_ITEM_ID(p_table_name =>'MSC_ST_BOMS',
35974: p_item_col_name => 'ASSEMBLY_NAME',
35975: p_item_col_id =>'ASSEMBLY_ITEM_ID',
35976: p_instance_code => v_instance_code,
35977: p_instance_id => v_instance_id,

Line 35997: 'UPDATE msc_st_boms msb'

35993: v_sql_stmt := 07;
35994:
35995: lv_sql_stmt :=
35996:
35997: 'UPDATE msc_st_boms msb'
35998: ||' SET msb.bom_name = msb.assembly_name'
35999: ||' WHERE sr_instance_code = :v_instance_code'
36000: ||' AND msb.process_flag ='||G_IN_PROCESS
36001: ||' AND NVL(msb.bom_name,'||''''||NULL_CHAR||''''||') '

Line 36015: (p_table_name => 'MSC_ST_BOMS',

36011: -- Derive the BILL_SEQUENCE_ID for the BOM from LOCAL ID table
36012:
36013: lv_return :=
36014: MSC_ST_UTIL.DERIVE_BILL_SEQUENCE_ID
36015: (p_table_name => 'MSC_ST_BOMS',
36016: p_bom_col_name => 'BOM_NAME',
36017: p_bom_col_id => 'BILL_SEQUENCE_ID',
36018: p_instance_code => v_instance_code,
36019: p_batch_id => lv_batch_id,

Line 36049: (p_table_name => 'MSC_ST_BOMS',

36045: lv_where_str :=
36046: ' AND NVL(assembly_quantity,'||NULL_VALUE||') ='|| NULL_VALUE;
36047:
36048: lv_return := MSC_ST_UTIL.LOG_ERROR
36049: (p_table_name => 'MSC_ST_BOMS',
36050: p_instance_code => v_instance_code,
36051: p_row => lv_column_names,
36052: p_severity => G_SEV_WARNING,
36053: p_message_text => lv_message_text,

Line 36085: ' UPDATE msc_st_boms msb'

36081: -- For validation, use ODS table MSC_UNITS_OF_MEASURE table
36082: v_sql_stmt := 08;
36083:
36084: lv_sql_stmt :=
36085: ' UPDATE msc_st_boms msb'
36086: ||' SET process_flag = '||G_ERROR_FLG||','
36087: ||' error_text = '||''''||lv_message_text||''''
36088: ||' WHERE NOT EXISTS (SELECT 1'
36089: ||' FROM msc_units_of_measure muom'

Line 36133: (p_table_name => 'MSC_ST_BOMS',

36129: lv_where_str :=
36130: ' AND NVL(assembly_type,'||NULL_VALUE||') NOT IN (1,2)';
36131:
36132: lv_return := MSC_ST_UTIL.LOG_ERROR
36133: (p_table_name => 'MSC_ST_BOMS',
36134: p_instance_code => v_instance_code,
36135: p_row => lv_column_names,
36136: p_severity => G_SEV_WARNING,
36137: p_message_text => lv_message_text,

Line 36171: (p_table_name => 'MSC_ST_BOMS',

36167:
36168: lv_where_str := ' AND bom_scaling_type NOT IN (0,1,2)';
36169:
36170: lv_return := MSC_ST_UTIL.LOG_ERROR
36171: (p_table_name => 'MSC_ST_BOMS',
36172: p_instance_code => v_instance_code,
36173: p_row => lv_column_names,
36174: p_severity => G_SEV_WARNING,
36175: p_message_text => lv_message_text,

Line 36194: pEntityName => 'MSC_ST_BOMS',

36190: (ERRBUF => lv_error_text,
36191: RETCODE => lv_return,
36192: pBatchID => lv_batch_id,
36193: pInstanceCode => v_instance_code,
36194: pEntityName => 'MSC_ST_BOMS',
36195: pInstanceID => v_instance_id);
36196:
36197: IF NVL(lv_return,0) <> 0 THEN
36198: RAISE ex_logging_err;

Line 36202: -- LID table and MSC_ST_BOMS , Sequence to be used MSC_ST_BILL_SEQUENCE_ID_S

36198: RAISE ex_logging_err;
36199: END IF;
36200:
36201: -- Now generate bill_sequence_id for New BOM and populate the same in
36202: -- LID table and MSC_ST_BOMS , Sequence to be used MSC_ST_BILL_SEQUENCE_ID_S
36203:
36204: v_sql_stmt := 09;
36205:
36206: OPEN c3(lv_batch_id);

Line 36213: UPDATE msc_st_boms

36209: IF c3%ROWCOUNT > 0 THEN
36210:
36211: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
36212:
36213: UPDATE msc_st_boms
36214: SET bill_sequence_id = msc_st_bill_sequence_id_s.NEXTVAL
36215: WHERE rowid = lb_rowid(j);
36216:
36217: v_sql_stmt := 10;

Line 36261: FROM msc_st_boms

36257: v_current_date,
36258: v_current_user,
36259: v_current_date,
36260: v_current_user
36261: FROM msc_st_boms
36262: WHERE rowid = lb_rowid(j);
36263:
36264: END IF;
36265: CLOSE c3;

Line 36269: MSC_ST_UTIL.SET_PROCESS_FLAG(p_table_name => 'MSC_ST_BOMS',

36265: CLOSE c3;
36266:
36267: -- Set the process flag as Valid and poulate instance_id
36268: lv_return :=
36269: MSC_ST_UTIL.SET_PROCESS_FLAG(p_table_name => 'MSC_ST_BOMS',
36270: p_instance_id => v_instance_id,
36271: p_instance_code => v_instance_code,
36272: p_process_flag => G_VALID,
36273: p_error_text => lv_error_text,

Line 36284: MSC_ST_UTIL.LOG_ERROR(p_table_name =>'MSC_ST_BOMS',

36280:
36281: -- At the end calling the LOG_ERROR for logging all errored out records
36282:
36283: lv_return :=
36284: MSC_ST_UTIL.LOG_ERROR(p_table_name =>'MSC_ST_BOMS',
36285: p_instance_code =>v_instance_code,
36286: p_row =>lv_column_names,
36287: p_severity =>G_SEV_ERROR,
36288: p_message_text =>NULL,

Line 36631: p_token_value2 => 'MSC_ST_BOMS',

36627: p_token_value1 => 'BOM_NAME,INSTANCE_CODE,'
36628: ||' COMPANY_NAME,'
36629: ||'ALETERNATE_BOM_DESIGNATOR',
36630: p_token2 => 'MASTER_TABLE',
36631: p_token_value2 => 'MSC_ST_BOMS',
36632: p_token3 => 'CHILD_TABLE',
36633: p_token_value3 => 'MSC_ST_BOM_COMPONENTS');
36634:
36635: IF lv_return <> 0 THEN

Line 36670: p_token_value2 => 'MSC_ST_BOMS',

36666: p_token_value1 => 'BOM_NAME,INSTANCE_CODE,'
36667: ||' COMPANY_NAME,'
36668: ||'ALETERNATE_BOM_DESIGNATOR',
36669: p_token2 => 'MASTER_TABLE',
36670: p_token_value2 => 'MSC_ST_BOMS',
36671: p_token3 => 'CHILD_TABLE',
36672: p_token_value3 => 'MSC_ST_BOM_COMPONENTS');
36673:
36674: IF lv_return <> 0 THEN

Line 36898: p_token_value2 => 'MSC_ST_BOMS'

36894: p_error_text => lv_error_text,
36895: p_token1 => 'COLUMN_NAMES',
36896: p_token_value1 => 'ASSEMBLY_NAME',
36897: p_token2 => 'MASTER_TABLE',
36898: p_token_value2 => 'MSC_ST_BOMS'
36899: );
36900:
36901: IF lv_return <> 0 THEN
36902: RAISE ex_logging_err;

Line 37796: p_token_value2 => 'MSC_ST_BOMS',

37792: p_token_value1 => 'BOM_NAME,SR_INSTANCE_CODE,'
37793: ||' COMPANY_NAME,'
37794: ||' ALETERNATE_BOM_DESIGNATOR',
37795: p_token2 => 'MASTER_TABLE',
37796: p_token_value2 => 'MSC_ST_BOMS',
37797: p_token3 => 'CHILD_TABLE',
37798: p_token_value3 => 'MSC_ST_COMPONENT_SUBSTITUTES');
37799:
37800: IF lv_return <> 0 THEN

Line 38644: -- Now Updating the tables MSC_ST_BOMS and MSC_ST_BOM_COMPONENTS.

38640: RAISe ex_logging_err;
38641: END IF;
38642:
38643: COMMIT;
38644: -- Now Updating the tables MSC_ST_BOMS and MSC_ST_BOM_COMPONENTS.
38645:
38646: LOAD_CO_PRODUCT_BOMS;
38647:
38648:

Line 39379: p_token_value2 => 'MSC_ST_BOMS',

39375: p_token1 => 'COLUMN_NAMES',
39376: p_token_value1 => 'SR_INSTANCE_CODE,COMPANY_NAME,'
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

Line 42383: ||' FROM msc_st_boms msb'

42379: ||' last_update_date,'
42380: ||' last_updated_by, '
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 )';

Line 50926: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_BOMS');

50922: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_BOM_COMPONENTS');
50923: IF lv_count > 0 Then
50924: prec.bom_flag:= SYS_YES;
50925: End IF;
50926: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_BOMS');
50927: IF lv_count > 0 Then
50928: prec.bom_flag:= SYS_YES;
50929: End IF;
50930: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_CO_PRODUCTS');