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_SAFETY_STOCKS

Line 1508: 'create index MSC_ST_SAFETY_STOCKS_N1_'||v_instance_code

1504: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1505: application_short_name => 'MSC',
1506: statement_type => AD_DDL.CREATE_INDEX,
1507: statement =>
1508: 'create index MSC_ST_SAFETY_STOCKS_N1_'||v_instance_code
1509: ||' on MSC_ST_SAFETY_STOCKS '
1510: ||'(sr_instance_code,organization_code,item_name,period_start_date,company_name) '
1511: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1512: object_name =>'MSC_ST_SAFETY_STOCKS_N1_'||v_instance_code);

Line 1509: ||' on MSC_ST_SAFETY_STOCKS '

1505: application_short_name => 'MSC',
1506: statement_type => AD_DDL.CREATE_INDEX,
1507: statement =>
1508: 'create index MSC_ST_SAFETY_STOCKS_N1_'||v_instance_code
1509: ||' on MSC_ST_SAFETY_STOCKS '
1510: ||'(sr_instance_code,organization_code,item_name,period_start_date,company_name) '
1511: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1512: object_name =>'MSC_ST_SAFETY_STOCKS_N1_'||v_instance_code);
1513:

Line 1512: object_name =>'MSC_ST_SAFETY_STOCKS_N1_'||v_instance_code);

1508: 'create index MSC_ST_SAFETY_STOCKS_N1_'||v_instance_code
1509: ||' on MSC_ST_SAFETY_STOCKS '
1510: ||'(sr_instance_code,organization_code,item_name,period_start_date,company_name) '
1511: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1512: object_name =>'MSC_ST_SAFETY_STOCKS_N1_'||v_instance_code);
1513:
1514: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_SAFETY_STOCKS_N1_'||v_instance_code);
1515:
1516: EXCEPTION

Line 1514: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_SAFETY_STOCKS_N1_'||v_instance_code);

1510: ||'(sr_instance_code,organization_code,item_name,period_start_date,company_name) '
1511: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1512: object_name =>'MSC_ST_SAFETY_STOCKS_N1_'||v_instance_code);
1513:
1514: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_SAFETY_STOCKS_N1_'||v_instance_code);
1515:
1516: EXCEPTION
1517: WHEN OTHERS THEN
1518: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_SAFETY_STOCKS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));

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

1514: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_SAFETY_STOCKS_N1_'||v_instance_code);
1515:
1516: EXCEPTION
1517: WHEN OTHERS THEN
1518: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_SAFETY_STOCKS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
1519: END;
1520: END IF;
1521:
1522: IF v_item_substitute_enabled = SYS_YES THEN

Line 1535: object_name =>'MSC_ST_SAFETY_STOCKS_N1_'||v_instance_code);

1531: ||' on MSC_ST_ITEM_SUBSTITUTES '
1532: ||' (sr_instance_code,item_name,substitute_item_name,customer_name,'
1533: ||' customer_site_code,substitution_set,company_name) '
1534: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1535: object_name =>'MSC_ST_SAFETY_STOCKS_N1_'||v_instance_code);
1536:
1537: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_ITEM_SUBSTITUTES_N1_'||v_instance_code);
1538:
1539: EXCEPTION

Line 1544: msc_analyse_tables_pk.analyse_table( 'MSC_ST_SAFETY_STOCKS', v_instance_id, -1);

1540: WHEN OTHERS THEN
1541: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_ITEM_SUBSTITUTES_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
1542: END;
1543:
1544: msc_analyse_tables_pk.analyse_table( 'MSC_ST_SAFETY_STOCKS', v_instance_id, -1);
1545: msc_analyse_tables_pk.analyse_table( 'MSC_ST_ITEM_SUBSTITUTES', v_instance_id, -1);
1546:
1547: END IF;
1548:

Line 2619: 'drop index MSC_ST_SAFETY_STOCKS_N1_'||v_instance_code,

2615: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2616: application_short_name => 'MSC',
2617: statement_type => AD_DDL.DROP_INDEX,
2618: statement =>
2619: 'drop index MSC_ST_SAFETY_STOCKS_N1_'||v_instance_code,
2620: object_name => 'MSC_ST_SAFETY_STOCKS_N1_'||v_instance_code);
2621:
2622:
2623: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_SAFETY_STOCKS_N1_'||v_instance_code);

Line 2620: object_name => 'MSC_ST_SAFETY_STOCKS_N1_'||v_instance_code);

2616: application_short_name => 'MSC',
2617: statement_type => AD_DDL.DROP_INDEX,
2618: statement =>
2619: 'drop index MSC_ST_SAFETY_STOCKS_N1_'||v_instance_code,
2620: object_name => 'MSC_ST_SAFETY_STOCKS_N1_'||v_instance_code);
2621:
2622:
2623: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_SAFETY_STOCKS_N1_'||v_instance_code);
2624:

Line 2623: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_SAFETY_STOCKS_N1_'||v_instance_code);

2619: 'drop index MSC_ST_SAFETY_STOCKS_N1_'||v_instance_code,
2620: object_name => 'MSC_ST_SAFETY_STOCKS_N1_'||v_instance_code);
2621:
2622:
2623: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_SAFETY_STOCKS_N1_'||v_instance_code);
2624:
2625: EXCEPTION
2626: WHEN OTHERS THEN
2627: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_SAFETY_STOCKS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));

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

2623: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_SAFETY_STOCKS_N1_'||v_instance_code);
2624:
2625: EXCEPTION
2626: WHEN OTHERS THEN
2627: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_SAFETY_STOCKS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
2628: END;
2629:
2630: END IF;
2631:

Line 23095: | DESCRIPTION : This procedure validates the data in MSC_ST_SAFETY_STOCKS |

23091:
23092: END LOAD_SUPP_CAPACITY;
23093:
23094: /*==========================================================================+
23095: | DESCRIPTION : This procedure validates the data in MSC_ST_SAFETY_STOCKS |
23096: | table and derives the id's from the local id's table. |
23097: +==========================================================================*/
23098: PROCEDURE LOAD_SAFETY_STOCKS IS
23099: TYPE RowidTab IS TABLE OF ROWID INDEX BY BINARY_INTEGER;

Line 23106: lv_batch_id msc_st_safety_stocks.batch_id%TYPE;

23102: lv_error_text VARCHAR2(250);
23103: lv_where_str VARCHAR2(5000);
23104: lv_sql_stmt VARCHAR2(5000);
23105: lv_column_names VARCHAR2(5000); --stores concatenated column names
23106: lv_batch_id msc_st_safety_stocks.batch_id%TYPE;
23107: lv_message_text msc_errors.error_text%TYPE;
23108:
23109: ex_logging_err EXCEPTION;
23110:

Line 23113: FROM msc_st_safety_stocks

23109: ex_logging_err EXCEPTION;
23110:
23111: CURSOR c1(p_batch_id NUMBER) IS
23112: SELECT rowid
23113: FROM msc_st_safety_stocks
23114: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
23115: AND batch_id = p_batch_id
23116: AND sr_instance_code = v_instance_code;
23117:

Line 23133: ' UPDATE msc_st_safety_stocks mss1'

23129:
23130: --Duplicate records check for the records whose source is XML
23131: v_sql_stmt := 01;
23132: lv_sql_stmt :=
23133: ' UPDATE msc_st_safety_stocks mss1'
23134: ||' SET process_flag = '||G_ERROR_FLG||','
23135: ||' error_text = '||''''||lv_message_text||''''
23136: ||' WHERE message_id < (SELECT MAX(message_id)'
23137: ||' FROM msc_st_safety_stocks mss2'

Line 23137: ||' FROM msc_st_safety_stocks mss2'

23133: ' UPDATE msc_st_safety_stocks mss1'
23134: ||' SET process_flag = '||G_ERROR_FLG||','
23135: ||' error_text = '||''''||lv_message_text||''''
23136: ||' WHERE message_id < (SELECT MAX(message_id)'
23137: ||' FROM msc_st_safety_stocks mss2'
23138: ||' WHERE mss2.sr_instance_code = mss1.sr_instance_code'
23139: ||' AND mss2.organization_code = mss1.organization_code'
23140: ||' AND mss2.item_name = mss1.item_name'
23141: ||' AND mss2.period_start_date = mss1.period_start_date'

Line 23171: ' UPDATE msc_st_safety_stocks mss1'

23167: --Different SQL is used because in XML we can identify the latest records
23168: --whereas in batch load we cannot.
23169: v_sql_stmt := 02;
23170: lv_sql_stmt :=
23171: ' UPDATE msc_st_safety_stocks mss1'
23172: ||' SET process_flag = '||G_ERROR_FLG||','
23173: ||' error_text = '||''''||lv_message_text||''''
23174: ||' WHERE EXISTS( SELECT 1 '
23175: ||' FROM msc_st_safety_stocks mss2'

Line 23175: ||' FROM msc_st_safety_stocks mss2'

23171: ' UPDATE msc_st_safety_stocks mss1'
23172: ||' SET process_flag = '||G_ERROR_FLG||','
23173: ||' error_text = '||''''||lv_message_text||''''
23174: ||' WHERE EXISTS( SELECT 1 '
23175: ||' FROM msc_st_safety_stocks mss2'
23176: ||' WHERE mss2.sr_instance_code = mss1.sr_instance_code'
23177: ||' AND mss2.organization_code = mss1.organization_code'
23178: ||' AND mss2.item_name = mss1.item_name'
23179: ||' AND mss2.period_start_date = mss1.period_start_date'

Line 23214: ' UPDATE msc_st_safety_stocks '

23210: FROM dual;
23211:
23212: v_sql_stmt := 04;
23213: lv_sql_stmt :=
23214: ' UPDATE msc_st_safety_stocks '
23215: ||' SET batch_id = :lv_batch_id'
23216: ||' WHERE process_flag IN ('||G_IN_PROCESS||','||G_ERROR_FLG||')'
23217: ||' AND sr_instance_code = :v_instance_code'
23218: ||' AND NVL(batch_id,'||NULL_VALUE||') = '||NULL_VALUE

Line 23236: UPDATE msc_st_safety_stocks

23232: CLOSE c1;
23233:
23234: v_sql_stmt := 05;
23235: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
23236: UPDATE msc_st_safety_stocks
23237: SET st_transaction_id = msc_st_safety_stocks_s.NEXTVAL,
23238: refresh_id = v_refresh_id,
23239: last_update_date = v_current_date,
23240: last_updated_by = v_current_user,

Line 23237: SET st_transaction_id = msc_st_safety_stocks_s.NEXTVAL,

23233:
23234: v_sql_stmt := 05;
23235: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
23236: UPDATE msc_st_safety_stocks
23237: SET st_transaction_id = msc_st_safety_stocks_s.NEXTVAL,
23238: refresh_id = v_refresh_id,
23239: last_update_date = v_current_date,
23240: last_updated_by = v_current_user,
23241: creation_date = v_current_date,

Line 23251: p_token_value1 => 'MSC_ST_SAFETY_STOCKS');

23247: p_error_code => 'MSC_PP_NO_DELETION',
23248: p_message_text => lv_message_text,
23249: p_error_text => lv_error_text,
23250: p_token1 => 'TABLE_NAME',
23251: p_token_value1 => 'MSC_ST_SAFETY_STOCKS');
23252:
23253: IF lv_return <> 0 THEN
23254: RAISE ex_logging_err;
23255: END IF;

Line 23260: ' UPDATE msc_st_safety_stocks '

23256:
23257: --Deletion is not allowed for this entity.
23258: v_sql_stmt := 06;
23259: lv_sql_stmt :=
23260: ' UPDATE msc_st_safety_stocks '
23261: ||' SET process_flag = '||G_ERROR_FLG||','
23262: ||' error_text = '||''''||lv_message_text||''''
23263: ||' WHERE deleted_flag = '||SYS_YES
23264: ||' AND process_flag = '||G_IN_PROCESS

Line 23289: ' UPDATE msc_st_safety_stocks '

23285: END IF;
23286:
23287: v_sql_stmt := 07;
23288: lv_sql_stmt :=
23289: ' UPDATE msc_st_safety_stocks '
23290: ||' SET process_flag = '||G_ERROR_FLG||','
23291: ||' error_text = '||''''||lv_message_text||''''
23292: ||' WHERE (safety_stock_quantity IS NULL '
23293: ||' OR period_start_date IS NULL) '

Line 23318: (p_table_name => 'MSC_ST_SAFETY_STOCKS',

23314: END IF;
23315:
23316: --Derive Organization_id
23317: lv_return := MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID
23318: (p_table_name => 'MSC_ST_SAFETY_STOCKS',
23319: p_org_partner_name => 'ORGANIZATION_CODE',
23320: p_org_partner_id => 'ORGANIZATION_ID',
23321: p_instance_code => v_instance_code,
23322: p_partner_type => G_ORGANIZATION,

Line 23348: (p_table_name => 'MSC_ST_SAFETY_STOCKS',

23344: END IF;
23345:
23346: --Derive Inventory_item_id
23347: lv_return := MSC_ST_UTIL.DERIVE_ITEM_ID
23348: (p_table_name => 'MSC_ST_SAFETY_STOCKS',
23349: p_item_col_name => 'ITEM_NAME',
23350: p_item_col_id => 'INVENTORY_ITEM_ID',
23351: p_instance_id => v_instance_id,
23352: p_instance_code => v_instance_code,

Line 23378: 'UPDATE msc_st_safety_stocks mss'

23374:
23375: v_sql_stmt := 08;
23376: lv_sql_stmt :=
23377:
23378: 'UPDATE msc_st_safety_stocks mss'
23379: ||' SET process_flag = '||G_ERROR_FLG||','
23380: ||' error_text = '||''''||lv_message_text||''''
23381: ||' WHERE EXISTS (SELECT 1'
23382: ||' FROM msc_st_system_items msi'

Line 23428: (p_table_name => 'MSC_ST_SAFETY_STOCKS',

23424: END IF;
23425:
23426: --Derive Project Id.
23427: lv_return := MSC_ST_UTIL.DERIVE_PROJ_TASK_ID
23428: (p_table_name => 'MSC_ST_SAFETY_STOCKS',
23429: p_proj_col_name => 'PROJECT_NUMBER',
23430: p_proj_task_col_id => 'PROJECT_ID',
23431: p_instance_code => v_instance_code,
23432: p_entity_name => 'PROJECT_ID',

Line 23461: (p_table_name => 'MSC_ST_SAFETY_STOCKS',

23457: END IF;
23458:
23459: --Derive Task Id.
23460: lv_return := MSC_ST_UTIL.DERIVE_PROJ_TASK_ID
23461: (p_table_name => 'MSC_ST_SAFETY_STOCKS',
23462: p_proj_col_name => 'PROJECT_NUMBER',
23463: p_proj_task_col_id => 'TASK_ID',
23464: p_instance_code => v_instance_code,
23465: p_entity_name => 'TASK_ID',

Line 23484: pEntityName => 'MSC_ST_SAFETY_STOCKS',

23480: (ERRBUF => lv_error_text,
23481: RETCODE => lv_return,
23482: pBatchID => lv_batch_id,
23483: pInstanceCode => v_instance_code,
23484: pEntityName => 'MSC_ST_SAFETY_STOCKS',
23485: pInstanceID => v_instance_id);
23486:
23487: IF NVL(lv_return,0) <> 0 THEN
23488: RAISE ex_logging_err;

Line 23492: (p_table_name => 'MSC_ST_SAFETY_STOCKS',

23488: RAISE ex_logging_err;
23489: END IF;
23490:
23491: lv_return := MSC_ST_UTIL.SET_PROCESS_FLAG
23492: (p_table_name => 'MSC_ST_SAFETY_STOCKS',
23493: p_instance_id => v_instance_id,
23494: p_instance_code => v_instance_code,
23495: p_process_flag => G_VALID,
23496: p_error_text => lv_error_text,

Line 23505: (p_table_name => 'MSC_ST_SAFETY_STOCKS',

23501: RAISE ex_logging_err;
23502: END IF;
23503:
23504: lv_return := MSC_ST_UTIL.LOG_ERROR
23505: (p_table_name => 'MSC_ST_SAFETY_STOCKS',
23506: p_instance_code => v_instance_code,
23507: p_row => lv_column_names,
23508: p_severity => G_SEV_ERROR,
23509: p_message_text => NULL,

Line 51049: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_SAFETY_STOCKS');

51045: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_ITEM_CUSTOMERS');
51046: END IF;
51047:
51048: IF v_safety_stk_enabled = SYS_YES THEN
51049: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_SAFETY_STOCKS');
51050: IF lv_count > 0 Then
51051: prec.saf_stock_flag:= SYS_YES;
51052: End IF;
51053: END IF;