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 736: 'create index MSC_ST_BOMS_N1_'||v_instance_code

732: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
733: application_short_name => 'MSC',
734: statement_type => AD_DDL.CREATE_INDEX,
735: statement =>
736: 'create index MSC_ST_BOMS_N1_'||v_instance_code
737: ||' on MSC_ST_BOMS '
738: ||'(sr_instance_code, assembly_name, organization_code, company_name, bom_name, alternate_bom_designator) '
739: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
740: object_name =>'MSC_ST_BOMS_N1_'||v_instance_code);

Line 737: ||' on MSC_ST_BOMS '

733: application_short_name => 'MSC',
734: statement_type => AD_DDL.CREATE_INDEX,
735: statement =>
736: 'create index MSC_ST_BOMS_N1_'||v_instance_code
737: ||' on MSC_ST_BOMS '
738: ||'(sr_instance_code, assembly_name, organization_code, company_name, bom_name, alternate_bom_designator) '
739: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
740: object_name =>'MSC_ST_BOMS_N1_'||v_instance_code);
741: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_BOMS_N1_'||v_instance_code);

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

736: 'create index MSC_ST_BOMS_N1_'||v_instance_code
737: ||' on MSC_ST_BOMS '
738: ||'(sr_instance_code, assembly_name, organization_code, company_name, bom_name, alternate_bom_designator) '
739: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
740: object_name =>'MSC_ST_BOMS_N1_'||v_instance_code);
741: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_BOMS_N1_'||v_instance_code);
742:
743: EXCEPTION
744: WHEN OTHERS THEN

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

737: ||' on MSC_ST_BOMS '
738: ||'(sr_instance_code, assembly_name, organization_code, company_name, bom_name, alternate_bom_designator) '
739: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
740: object_name =>'MSC_ST_BOMS_N1_'||v_instance_code);
741: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_BOMS_N1_'||v_instance_code);
742:
743: EXCEPTION
744: WHEN OTHERS THEN
745: 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 745: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_BOMS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));

741: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_BOMS_N1_'||v_instance_code);
742:
743: EXCEPTION
744: WHEN OTHERS THEN
745: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_BOMS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
746: END;
747:
748: BEGIN
749: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

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

797: WHEN OTHERS THEN
798: 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));
799: END;
800:
801: msc_analyse_tables_pk.analyse_table( 'MSC_ST_BOMS', v_instance_id, -1);
802: msc_analyse_tables_pk.analyse_table( 'MSC_ST_BOM_COMPONENTS', v_instance_id, -1);
803: msc_analyse_tables_pk.analyse_table( 'MSC_ST_COMPONENT_SUBSTITUTES', v_instance_id, -1);
804: msc_analyse_tables_pk.analyse_table( 'MSC_ST_CO_PRODUCTS', v_instance_id, -1);
805:

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

2026: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2027: application_short_name => 'MSC',
2028: statement_type => AD_DDL.DROP_INDEX,
2029: statement =>
2030: 'drop index MSC_ST_BOMS_N1_'||v_instance_code,
2031: object_name => 'MSC_ST_BOMS_N1_'||v_instance_code);
2032:
2033: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_BOMS_N1_'||v_instance_code);
2034: EXCEPTION

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

2027: application_short_name => 'MSC',
2028: statement_type => AD_DDL.DROP_INDEX,
2029: statement =>
2030: 'drop index MSC_ST_BOMS_N1_'||v_instance_code,
2031: object_name => 'MSC_ST_BOMS_N1_'||v_instance_code);
2032:
2033: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_BOMS_N1_'||v_instance_code);
2034: EXCEPTION
2035: WHEN OTHERS THEN

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

2029: statement =>
2030: 'drop index MSC_ST_BOMS_N1_'||v_instance_code,
2031: object_name => 'MSC_ST_BOMS_N1_'||v_instance_code);
2032:
2033: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_BOMS_N1_'||v_instance_code);
2034: EXCEPTION
2035: WHEN OTHERS THEN
2036: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_BOMS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
2037: END;

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

2032:
2033: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_BOMS_N1_'||v_instance_code);
2034: EXCEPTION
2035: WHEN OTHERS THEN
2036: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_BOMS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
2037: END;
2038:
2039: BEGIN
2040: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

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

40021:
40022: /*==========================================================================+
40023: | DESCRIPTION : This function performs insertion of co products records |
40024: | into msc_st_bom_componenets plus updates the records in |
40025: | msc_st_boms. Its called from LOAD_BOM after pre processing |
40026: | CO PRODUCTS. Included for OSFM Integration |
40027: +==========================================================================*/
40028:
40029: PROCEDURE LOAD_CO_PRODUCT_BOMS IS

Line 40080: || ' from msc_st_boms msb '

40076:
40077:
40078: -- selecting all the valid boms for the selected Co Product from staging table + ODS--
40079: v_query_str2 := ' select msb.bill_sequence_id,msb.rowid,0 '
40080: || ' from msc_st_boms msb '
40081: || ' where msb.assembly_item_id = :lv_assembly_item_id '
40082: || ' AND msb.process_flag = '|| G_VALID
40083: || ' and sr_instance_code = :v_instance_code '
40084: || ' UNION '

Line 40093: || ' from msc_st_boms msb1'

40089: || ' and lid.SR_INVENTORY_ITEM_ID = :lv_assembly_item_id '
40090: || ' and lid.SR_INSTANCE_ID = :v_instance_id '
40091: || ' and mb.bill_sequence_id not in '
40092: || ' ( select msb1.bill_sequence_id '
40093: || ' from msc_st_boms msb1'
40094: || ' where msb1.assembly_item_id = :lv_assembly_item_id '
40095: || ' AND msb1.process_flag = '|| G_VALID
40096: || ' and sr_instance_code = :v_instance_code )';
40097:

Line 40237: update msc_st_boms

40233:
40234: IF lv_ODS_flag = 0 THEN -- if the BOM record is in the staging table
40235:
40236: v_sql_stmt := 06;
40237: update msc_st_boms
40238: set assembly_quantity = (l_split_cur1/100)
40239: where rowid = l_rowid_cur2 ;
40240:
40241: ELSE -- if the BOM record is in the ODS

Line 40244: insert into MSC_ST_BOMS

40240:
40241: ELSE -- if the BOM record is in the ODS
40242:
40243: v_sql_stmt := 07;
40244: insert into MSC_ST_BOMS
40245: ( BILL_SEQUENCE_ID,
40246: ORGANIZATION_ID,
40247: ASSEMBLY_ITEM_ID,
40248: ASSEMBLY_TYPE,

Line 40273: -- and MSC_ST_BOMS stores SR_INVENTORY_ITEM_ID in ASSEMBLY_ITEM_ID

40269: 2,
40270: v_refresh_id,
40271: v_instance_id
40272: -- note the join on MSC_ITEM_ID_LID because MSC_BOMS stores ASSEMBLY_ITEM_ID
40273: -- and MSC_ST_BOMS stores SR_INVENTORY_ITEM_ID in ASSEMBLY_ITEM_ID
40274: FROM MSC_BOMS msb ,MSC_ITEM_ID_LID lid
40275: WHERE msb. BILL_SEQUENCE_ID = l_bill_sequence_id_cur2
40276: And lid.SR_INSTANCE_ID = msb.SR_INSTANCE_ID
40277: AND lid.INVENTORY_ITEM_ID = msb.ASSEMBLY_ITEM_ID ;

Line 40416: lv_batch_id msc_st_boms.batch_id%TYPE;

40412: lv_error_text VARCHAR2(250);
40413: lv_where_str VARCHAR2(5000);
40414: lv_sql_stmt VARCHAR2(5000);
40415: lv_cursor_stmt VARCHAR2(5000);
40416: lv_batch_id msc_st_boms.batch_id%TYPE;
40417: lv_message_text msc_errors.error_text%TYPE;
40418:
40419: ex_logging_err EXCEPTION;
40420:

Line 40423: FROM msc_st_boms

40419: ex_logging_err EXCEPTION;
40420:
40421: CURSOR c2(p_batch_id NUMBER) IS
40422: SELECT rowid
40423: FROM msc_st_boms
40424: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
40425: AND sr_instance_code = v_instance_code
40426: AND batch_id = p_batch_id;
40427:

Line 40430: FROM msc_st_boms

40426: AND batch_id = p_batch_id;
40427:
40428: CURSOR c3(p_batch_id NUMBER) IS
40429: SELECT rowid
40430: FROM msc_st_boms
40431: WHERE process_flag = G_IN_PROCESS
40432: AND sr_instance_code = v_instance_code
40433: AND batch_id = p_batch_id
40434: AND NVL(bill_sequence_id,NULL_VALUE) = NULL_VALUE

Line 40497: -- Validation fo table msc_st_boms

40493:
40494:
40495: BEGIN
40496:
40497: -- Validation fo table msc_st_boms
40498:
40499: -- Before we start processing the record by group id( batch size ) we are going
40500: -- to check whether that there
40501: -- is any duplicates for user defined unique keys (UDKs,)

Line 40517: 'UPDATE msc_st_boms msb1'

40513: END IF;
40514:
40515: v_sql_stmt := 01;
40516: lv_sql_stmt :=
40517: 'UPDATE msc_st_boms msb1'
40518: ||' SET process_flag = '||G_ERROR_FLG||','
40519: ||' error_text = '||''''||lv_message_text||''''
40520: ||' WHERE message_id < (SELECT MAX(message_id)'
40521: ||' FROM msc_st_boms msb2'

Line 40521: ||' FROM msc_st_boms msb2'

40517: 'UPDATE msc_st_boms msb1'
40518: ||' SET process_flag = '||G_ERROR_FLG||','
40519: ||' error_text = '||''''||lv_message_text||''''
40520: ||' WHERE message_id < (SELECT MAX(message_id)'
40521: ||' FROM msc_st_boms msb2'
40522: ||' WHERE msb2.sr_instance_code = msb1.sr_instance_code'
40523: ||' AND msb2.organization_code = msb1.organization_code'
40524: ||' AND NVL(msb2.bom_name,'||''''||NULL_CHAR||''''||') '
40525: ||' = NVL(msb1.bom_name, '||''''||NULL_CHAR||''''||') '

Line 40556: 'UPDATE msc_st_boms msb1'

40552: END IF;
40553: v_sql_stmt := 02;
40554:
40555: lv_sql_stmt :=
40556: 'UPDATE msc_st_boms msb1'
40557: ||' SET process_flag = '||G_ERROR_FLG||','
40558: ||' error_text = '||''''||lv_message_text||''''
40559: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_boms msb2'
40560: ||' WHERE msb2.sr_instance_code = msb1.sr_instance_code'

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

40555: lv_sql_stmt :=
40556: 'UPDATE msc_st_boms msb1'
40557: ||' SET process_flag = '||G_ERROR_FLG||','
40558: ||' error_text = '||''''||lv_message_text||''''
40559: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_boms msb2'
40560: ||' WHERE msb2.sr_instance_code = msb1.sr_instance_code'
40561: ||' AND msb2.organization_code = msb1.organization_code'
40562: ||' AND NVL(msb2.bom_name,'||''''||NULL_CHAR||''''||') '
40563: ||' = NVL(msb1.bom_name, '||''''||NULL_CHAR||''''||') '

Line 40609: ' UPDATE msc_st_boms '

40605: CLOSE c1;
40606:
40607: v_sql_stmt := 04;
40608: lv_sql_stmt :=
40609: ' UPDATE msc_st_boms '
40610: ||' SET batch_id = :lv_batch_id'
40611: ||' WHERE process_flag IN ('||G_IN_PROCESS||','||G_ERROR_FLG||')'
40612: ||' AND sr_instance_code = :v_instance_code'
40613: ||' AND NVL(batch_id,'||NULL_VALUE||') = '||NULL_VALUE

Line 40629: UPDATE msc_st_boms

40625: CLOSE c2;
40626:
40627: v_sql_stmt := 05;
40628: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
40629: UPDATE msc_st_boms
40630: SET st_transaction_id = msc_st_boms_s.NEXTVAL,
40631: refresh_id = v_refresh_id,
40632: last_update_date = v_current_date,
40633: last_updated_by = v_current_user,

Line 40630: SET st_transaction_id = msc_st_boms_s.NEXTVAL,

40626:
40627: v_sql_stmt := 05;
40628: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
40629: UPDATE msc_st_boms
40630: SET st_transaction_id = msc_st_boms_s.NEXTVAL,
40631: refresh_id = v_refresh_id,
40632: last_update_date = v_current_date,
40633: last_updated_by = v_current_user,
40634: creation_date = v_current_date,

Line 40647: p_token_value1 => 'MSC_ST_BOMS');

40643: p_error_code => 'MSC_PP_NO_DELETION',
40644: p_message_text => lv_message_text,
40645: p_error_text => lv_error_text,
40646: p_token1 => 'TABLE_NAME',
40647: p_token_value1 => 'MSC_ST_BOMS');
40648:
40649: IF lv_return <> 0 THEN
40650: RAISE ex_logging_err;
40651: END IF;

Line 40656: ' UPDATE msc_st_boms '

40652:
40653: --Deletion is not allowed on this table.
40654: v_sql_stmt := 06;
40655: lv_sql_stmt :=
40656: ' UPDATE msc_st_boms '
40657: ||' SET process_flag = '||G_ERROR_FLG||','
40658: ||' error_text = '||''''||lv_message_text||''''
40659: ||' WHERE deleted_flag = '||SYS_YES
40660: ||' AND process_flag = '||G_IN_PROCESS

Line 40692: (p_table_name => 'MSC_ST_BOMS',

40688:
40689: lv_where_str := ' AND NVL(deleted_flag,'||NULL_VALUE||') <>'||SYS_NO;
40690:
40691: lv_return := MSC_ST_UTIL.LOG_ERROR
40692: (p_table_name => 'MSC_ST_BOMS',
40693: p_instance_code => v_instance_code,
40694: p_row => lv_column_names,
40695: p_severity => G_SEV_WARNING,
40696: p_message_text => lv_message_text,

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

40722:
40723: -- Populate organization id
40724:
40725: lv_return :=
40726: MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID(p_table_name => 'MSC_ST_BOMS',
40727: p_org_partner_name => 'ORGANIZATION_CODE',
40728: p_org_partner_id => 'ORGANIZATION_ID',
40729: p_instance_code => v_instance_code,
40730: p_partner_type => G_ORGANIZATION,

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

40753: END IF;
40754:
40755: -- Poplulate assembly item id
40756: lv_return :=
40757: MSC_ST_UTIL.DERIVE_ITEM_ID(p_table_name =>'MSC_ST_BOMS',
40758: p_item_col_name => 'ASSEMBLY_NAME',
40759: p_item_col_id =>'ASSEMBLY_ITEM_ID',
40760: p_instance_code => v_instance_code,
40761: p_instance_id => v_instance_id,

Line 40781: 'UPDATE msc_st_boms msb'

40777: v_sql_stmt := 07;
40778:
40779: lv_sql_stmt :=
40780:
40781: 'UPDATE msc_st_boms msb'
40782: ||' SET msb.bom_name = msb.assembly_name'
40783: ||' WHERE sr_instance_code = :v_instance_code'
40784: ||' AND msb.process_flag ='||G_IN_PROCESS
40785: ||' AND NVL(msb.bom_name,'||''''||NULL_CHAR||''''||') '

Line 40799: (p_table_name => 'MSC_ST_BOMS',

40795: -- Derive the BILL_SEQUENCE_ID for the BOM from LOCAL ID table
40796:
40797: lv_return :=
40798: MSC_ST_UTIL.DERIVE_BILL_SEQUENCE_ID
40799: (p_table_name => 'MSC_ST_BOMS',
40800: p_bom_col_name => 'BOM_NAME',
40801: p_bom_col_id => 'BILL_SEQUENCE_ID',
40802: p_instance_code => v_instance_code,
40803: p_batch_id => lv_batch_id,

Line 40833: (p_table_name => 'MSC_ST_BOMS',

40829: lv_where_str :=
40830: ' AND NVL(assembly_quantity,'||NULL_VALUE||') ='|| NULL_VALUE;
40831:
40832: lv_return := MSC_ST_UTIL.LOG_ERROR
40833: (p_table_name => 'MSC_ST_BOMS',
40834: p_instance_code => v_instance_code,
40835: p_row => lv_column_names,
40836: p_severity => G_SEV_WARNING,
40837: p_message_text => lv_message_text,

Line 40869: ' UPDATE msc_st_boms msb'

40865: -- For validation, use ODS table MSC_UNITS_OF_MEASURE table
40866: v_sql_stmt := 08;
40867:
40868: lv_sql_stmt :=
40869: ' UPDATE msc_st_boms msb'
40870: ||' SET process_flag = '||G_ERROR_FLG||','
40871: ||' error_text = '||''''||lv_message_text||''''
40872: ||' WHERE NOT EXISTS (SELECT 1'
40873: ||' FROM msc_units_of_measure muom'

Line 40917: (p_table_name => 'MSC_ST_BOMS',

40913: lv_where_str :=
40914: ' AND NVL(assembly_type,'||NULL_VALUE||') NOT IN (1,2)';
40915:
40916: lv_return := MSC_ST_UTIL.LOG_ERROR
40917: (p_table_name => 'MSC_ST_BOMS',
40918: p_instance_code => v_instance_code,
40919: p_row => lv_column_names,
40920: p_severity => G_SEV_WARNING,
40921: p_message_text => lv_message_text,

Line 40955: (p_table_name => 'MSC_ST_BOMS',

40951:
40952: lv_where_str := ' AND bom_scaling_type NOT IN (0,1,2)';
40953:
40954: lv_return := MSC_ST_UTIL.LOG_ERROR
40955: (p_table_name => 'MSC_ST_BOMS',
40956: p_instance_code => v_instance_code,
40957: p_row => lv_column_names,
40958: p_severity => G_SEV_WARNING,
40959: p_message_text => lv_message_text,

Line 40978: pEntityName => 'MSC_ST_BOMS',

40974: (ERRBUF => lv_error_text,
40975: RETCODE => lv_return,
40976: pBatchID => lv_batch_id,
40977: pInstanceCode => v_instance_code,
40978: pEntityName => 'MSC_ST_BOMS',
40979: pInstanceID => v_instance_id);
40980:
40981: IF NVL(lv_return,0) <> 0 THEN
40982: RAISE ex_logging_err;

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

40982: RAISE ex_logging_err;
40983: END IF;
40984:
40985: -- Now generate bill_sequence_id for New BOM and populate the same in
40986: -- LID table and MSC_ST_BOMS , Sequence to be used MSC_ST_BILL_SEQUENCE_ID_S
40987:
40988: v_sql_stmt := 09;
40989:
40990: OPEN c3(lv_batch_id);

Line 40997: UPDATE msc_st_boms

40993: IF c3%ROWCOUNT > 0 THEN
40994:
40995: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
40996:
40997: UPDATE msc_st_boms
40998: SET bill_sequence_id = msc_st_bill_sequence_id_s.NEXTVAL
40999: WHERE rowid = lb_rowid(j);
41000:
41001: v_sql_stmt := 10;

Line 41045: FROM msc_st_boms

41041: v_current_date,
41042: v_current_user,
41043: v_current_date,
41044: v_current_user
41045: FROM msc_st_boms
41046: WHERE rowid = lb_rowid(j);
41047:
41048: END IF;
41049: CLOSE c3;

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

41049: CLOSE c3;
41050:
41051: -- Set the process flag as Valid and poulate instance_id
41052: lv_return :=
41053: MSC_ST_UTIL.SET_PROCESS_FLAG(p_table_name => 'MSC_ST_BOMS',
41054: p_instance_id => v_instance_id,
41055: p_instance_code => v_instance_code,
41056: p_process_flag => G_VALID,
41057: p_error_text => lv_error_text,

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

41064:
41065: -- At the end calling the LOG_ERROR for logging all errored out records
41066:
41067: lv_return :=
41068: MSC_ST_UTIL.LOG_ERROR(p_table_name =>'MSC_ST_BOMS',
41069: p_instance_code =>v_instance_code,
41070: p_row =>lv_column_names,
41071: p_severity =>G_SEV_ERROR,
41072: p_message_text =>NULL,

Line 41415: p_token_value2 => 'MSC_ST_BOMS',

41411: p_token_value1 => 'BOM_NAME,INSTANCE_CODE,'
41412: ||' COMPANY_NAME,'
41413: ||'ALETERNATE_BOM_DESIGNATOR',
41414: p_token2 => 'MASTER_TABLE',
41415: p_token_value2 => 'MSC_ST_BOMS',
41416: p_token3 => 'CHILD_TABLE',
41417: p_token_value3 => 'MSC_ST_BOM_COMPONENTS');
41418:
41419: IF lv_return <> 0 THEN

Line 41454: p_token_value2 => 'MSC_ST_BOMS',

41450: p_token_value1 => 'BOM_NAME,INSTANCE_CODE,'
41451: ||' COMPANY_NAME,'
41452: ||'ALETERNATE_BOM_DESIGNATOR',
41453: p_token2 => 'MASTER_TABLE',
41454: p_token_value2 => 'MSC_ST_BOMS',
41455: p_token3 => 'CHILD_TABLE',
41456: p_token_value3 => 'MSC_ST_BOM_COMPONENTS');
41457:
41458: IF lv_return <> 0 THEN

Line 41682: p_token_value2 => 'MSC_ST_BOMS'

41678: p_error_text => lv_error_text,
41679: p_token1 => 'COLUMN_NAMES',
41680: p_token_value1 => 'ASSEMBLY_NAME',
41681: p_token2 => 'MASTER_TABLE',
41682: p_token_value2 => 'MSC_ST_BOMS'
41683: );
41684:
41685: IF lv_return <> 0 THEN
41686: RAISE ex_logging_err;

Line 42580: p_token_value2 => 'MSC_ST_BOMS',

42576: p_token_value1 => 'BOM_NAME,SR_INSTANCE_CODE,'
42577: ||' COMPANY_NAME,'
42578: ||' ALETERNATE_BOM_DESIGNATOR',
42579: p_token2 => 'MASTER_TABLE',
42580: p_token_value2 => 'MSC_ST_BOMS',
42581: p_token3 => 'CHILD_TABLE',
42582: p_token_value3 => 'MSC_ST_COMPONENT_SUBSTITUTES');
42583:
42584: IF lv_return <> 0 THEN

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

43424: RAISe ex_logging_err;
43425: END IF;
43426:
43427: COMMIT;
43428: -- Now Updating the tables MSC_ST_BOMS and MSC_ST_BOM_COMPONENTS.
43429:
43430: LOAD_CO_PRODUCT_BOMS;
43431:
43432:

Line 44163: p_token_value2 => 'MSC_ST_BOMS',

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

Line 47260: ||' FROM msc_st_boms msb'

47256: ||' last_update_date,'
47257: ||' last_updated_by, '
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 )';

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

55836: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_BOM_COMPONENTS');
55837: IF lv_count > 0 Then
55838: prec.bom_flag:= SYS_YES;
55839: End IF;
55840: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_BOMS');
55841: IF lv_count > 0 Then
55842: prec.bom_flag:= SYS_YES;
55843: End IF;
55844: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_CO_PRODUCTS');