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 1516: 'create index MSC_ST_SAFETY_STOCKS_N1_'||v_instance_code

1512: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1513: application_short_name => 'MSC',
1514: statement_type => AD_DDL.CREATE_INDEX,
1515: statement =>
1516: 'create index MSC_ST_SAFETY_STOCKS_N1_'||v_instance_code
1517: ||' on MSC_ST_SAFETY_STOCKS '
1518: ||'(sr_instance_code,organization_code,item_name,period_start_date,company_name) '
1519: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1520: object_name =>'MSC_ST_SAFETY_STOCKS_N1_'||v_instance_code);

Line 1517: ||' on MSC_ST_SAFETY_STOCKS '

1513: application_short_name => 'MSC',
1514: statement_type => AD_DDL.CREATE_INDEX,
1515: statement =>
1516: 'create index MSC_ST_SAFETY_STOCKS_N1_'||v_instance_code
1517: ||' on MSC_ST_SAFETY_STOCKS '
1518: ||'(sr_instance_code,organization_code,item_name,period_start_date,company_name) '
1519: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1520: object_name =>'MSC_ST_SAFETY_STOCKS_N1_'||v_instance_code);
1521:

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

1516: 'create index MSC_ST_SAFETY_STOCKS_N1_'||v_instance_code
1517: ||' on MSC_ST_SAFETY_STOCKS '
1518: ||'(sr_instance_code,organization_code,item_name,period_start_date,company_name) '
1519: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1520: object_name =>'MSC_ST_SAFETY_STOCKS_N1_'||v_instance_code);
1521:
1522: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_SAFETY_STOCKS_N1_'||v_instance_code);
1523:
1524: EXCEPTION

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

1518: ||'(sr_instance_code,organization_code,item_name,period_start_date,company_name) '
1519: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1520: object_name =>'MSC_ST_SAFETY_STOCKS_N1_'||v_instance_code);
1521:
1522: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_SAFETY_STOCKS_N1_'||v_instance_code);
1523:
1524: EXCEPTION
1525: WHEN OTHERS THEN
1526: 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 1526: 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));

1522: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_SAFETY_STOCKS_N1_'||v_instance_code);
1523:
1524: EXCEPTION
1525: WHEN OTHERS THEN
1526: 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));
1527: END;
1528: END IF;
1529:
1530: IF v_item_substitute_enabled = SYS_YES THEN

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

1539: ||' on MSC_ST_ITEM_SUBSTITUTES '
1540: ||' (sr_instance_code,item_name,substitute_item_name,customer_name,'
1541: ||' customer_site_code,substitution_set,company_name) '
1542: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1543: object_name =>'MSC_ST_SAFETY_STOCKS_N1_'||v_instance_code);
1544:
1545: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_ITEM_SUBSTITUTES_N1_'||v_instance_code);
1546:
1547: EXCEPTION

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

1548: WHEN OTHERS THEN
1549: 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));
1550: END;
1551:
1552: msc_analyse_tables_pk.analyse_table( 'MSC_ST_SAFETY_STOCKS', v_instance_id, -1);
1553: msc_analyse_tables_pk.analyse_table( 'MSC_ST_ITEM_SUBSTITUTES', v_instance_id, -1);
1554:
1555: END IF;
1556:

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

2623: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2624: application_short_name => 'MSC',
2625: statement_type => AD_DDL.DROP_INDEX,
2626: statement =>
2627: 'drop index MSC_ST_SAFETY_STOCKS_N1_'||v_instance_code,
2628: object_name => 'MSC_ST_SAFETY_STOCKS_N1_'||v_instance_code);
2629:
2630:
2631: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_SAFETY_STOCKS_N1_'||v_instance_code);

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

2624: application_short_name => 'MSC',
2625: statement_type => AD_DDL.DROP_INDEX,
2626: statement =>
2627: 'drop index MSC_ST_SAFETY_STOCKS_N1_'||v_instance_code,
2628: object_name => 'MSC_ST_SAFETY_STOCKS_N1_'||v_instance_code);
2629:
2630:
2631: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_SAFETY_STOCKS_N1_'||v_instance_code);
2632:

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

2627: 'drop index MSC_ST_SAFETY_STOCKS_N1_'||v_instance_code,
2628: object_name => 'MSC_ST_SAFETY_STOCKS_N1_'||v_instance_code);
2629:
2630:
2631: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_SAFETY_STOCKS_N1_'||v_instance_code);
2632:
2633: EXCEPTION
2634: WHEN OTHERS THEN
2635: 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 2635: 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));

2631: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_SAFETY_STOCKS_N1_'||v_instance_code);
2632:
2633: EXCEPTION
2634: WHEN OTHERS THEN
2635: 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));
2636: END;
2637:
2638: END IF;
2639:

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

26580:
26581: END LOAD_SUPP_CAPACITY;
26582:
26583: /*==========================================================================+
26584: | DESCRIPTION : This procedure validates the data in MSC_ST_SAFETY_STOCKS |
26585: | table and derives the id's from the local id's table. |
26586: +==========================================================================*/
26587: PROCEDURE LOAD_SAFETY_STOCKS IS
26588: TYPE RowidTab IS TABLE OF ROWID INDEX BY BINARY_INTEGER;

Line 26595: lv_batch_id msc_st_safety_stocks.batch_id%TYPE;

26591: lv_error_text VARCHAR2(250);
26592: lv_where_str VARCHAR2(5000);
26593: lv_sql_stmt VARCHAR2(5000);
26594: lv_column_names VARCHAR2(5000); --stores concatenated column names
26595: lv_batch_id msc_st_safety_stocks.batch_id%TYPE;
26596: lv_message_text msc_errors.error_text%TYPE;
26597:
26598: ex_logging_err EXCEPTION;
26599:

Line 26602: FROM msc_st_safety_stocks

26598: ex_logging_err EXCEPTION;
26599:
26600: CURSOR c1(p_batch_id NUMBER) IS
26601: SELECT rowid
26602: FROM msc_st_safety_stocks
26603: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
26604: AND batch_id = p_batch_id
26605: AND sr_instance_code = v_instance_code;
26606:

Line 26622: ' UPDATE msc_st_safety_stocks mss1'

26618:
26619: --Duplicate records check for the records whose source is XML
26620: v_sql_stmt := 01;
26621: lv_sql_stmt :=
26622: ' UPDATE msc_st_safety_stocks mss1'
26623: ||' SET process_flag = '||G_ERROR_FLG||','
26624: ||' error_text = '||''''||lv_message_text||''''
26625: ||' WHERE message_id < (SELECT MAX(message_id)'
26626: ||' FROM msc_st_safety_stocks mss2'

Line 26626: ||' FROM msc_st_safety_stocks mss2'

26622: ' UPDATE msc_st_safety_stocks mss1'
26623: ||' SET process_flag = '||G_ERROR_FLG||','
26624: ||' error_text = '||''''||lv_message_text||''''
26625: ||' WHERE message_id < (SELECT MAX(message_id)'
26626: ||' FROM msc_st_safety_stocks mss2'
26627: ||' WHERE mss2.sr_instance_code = mss1.sr_instance_code'
26628: ||' AND mss2.organization_code = mss1.organization_code'
26629: ||' AND mss2.item_name = mss1.item_name'
26630: ||' AND mss2.period_start_date = mss1.period_start_date'

Line 26660: ' UPDATE msc_st_safety_stocks mss1'

26656: --Different SQL is used because in XML we can identify the latest records
26657: --whereas in batch load we cannot.
26658: v_sql_stmt := 02;
26659: lv_sql_stmt :=
26660: ' UPDATE msc_st_safety_stocks mss1'
26661: ||' SET process_flag = '||G_ERROR_FLG||','
26662: ||' error_text = '||''''||lv_message_text||''''
26663: ||' WHERE EXISTS( SELECT 1 '
26664: ||' FROM msc_st_safety_stocks mss2'

Line 26664: ||' FROM msc_st_safety_stocks mss2'

26660: ' UPDATE msc_st_safety_stocks mss1'
26661: ||' SET process_flag = '||G_ERROR_FLG||','
26662: ||' error_text = '||''''||lv_message_text||''''
26663: ||' WHERE EXISTS( SELECT 1 '
26664: ||' FROM msc_st_safety_stocks mss2'
26665: ||' WHERE mss2.sr_instance_code = mss1.sr_instance_code'
26666: ||' AND mss2.organization_code = mss1.organization_code'
26667: ||' AND mss2.item_name = mss1.item_name'
26668: ||' AND mss2.period_start_date = mss1.period_start_date'

Line 26703: ' UPDATE msc_st_safety_stocks '

26699: FROM dual;
26700:
26701: v_sql_stmt := 04;
26702: lv_sql_stmt :=
26703: ' UPDATE msc_st_safety_stocks '
26704: ||' SET batch_id = :lv_batch_id'
26705: ||' WHERE process_flag IN ('||G_IN_PROCESS||','||G_ERROR_FLG||')'
26706: ||' AND sr_instance_code = :v_instance_code'
26707: ||' AND NVL(batch_id,'||NULL_VALUE||') = '||NULL_VALUE

Line 26725: UPDATE msc_st_safety_stocks

26721: CLOSE c1;
26722:
26723: v_sql_stmt := 05;
26724: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
26725: UPDATE msc_st_safety_stocks
26726: SET st_transaction_id = msc_st_safety_stocks_s.NEXTVAL,
26727: refresh_id = v_refresh_id,
26728: last_update_date = v_current_date,
26729: last_updated_by = v_current_user,

Line 26726: SET st_transaction_id = msc_st_safety_stocks_s.NEXTVAL,

26722:
26723: v_sql_stmt := 05;
26724: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
26725: UPDATE msc_st_safety_stocks
26726: SET st_transaction_id = msc_st_safety_stocks_s.NEXTVAL,
26727: refresh_id = v_refresh_id,
26728: last_update_date = v_current_date,
26729: last_updated_by = v_current_user,
26730: creation_date = v_current_date,

Line 26740: p_token_value1 => 'MSC_ST_SAFETY_STOCKS');

26736: p_error_code => 'MSC_PP_NO_DELETION',
26737: p_message_text => lv_message_text,
26738: p_error_text => lv_error_text,
26739: p_token1 => 'TABLE_NAME',
26740: p_token_value1 => 'MSC_ST_SAFETY_STOCKS');
26741:
26742: IF lv_return <> 0 THEN
26743: RAISE ex_logging_err;
26744: END IF;

Line 26749: ' UPDATE msc_st_safety_stocks '

26745:
26746: --Deletion is not allowed for this entity.
26747: v_sql_stmt := 06;
26748: lv_sql_stmt :=
26749: ' UPDATE msc_st_safety_stocks '
26750: ||' SET process_flag = '||G_ERROR_FLG||','
26751: ||' error_text = '||''''||lv_message_text||''''
26752: ||' WHERE deleted_flag = '||SYS_YES
26753: ||' AND process_flag = '||G_IN_PROCESS

Line 26778: ' UPDATE msc_st_safety_stocks '

26774: END IF;
26775:
26776: v_sql_stmt := 07;
26777: lv_sql_stmt :=
26778: ' UPDATE msc_st_safety_stocks '
26779: ||' SET process_flag = '||G_ERROR_FLG||','
26780: ||' error_text = '||''''||lv_message_text||''''
26781: ||' WHERE (safety_stock_quantity IS NULL '
26782: ||' OR period_start_date IS NULL) '

Line 26807: (p_table_name => 'MSC_ST_SAFETY_STOCKS',

26803: END IF;
26804:
26805: --Derive Organization_id
26806: lv_return := MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID
26807: (p_table_name => 'MSC_ST_SAFETY_STOCKS',
26808: p_org_partner_name => 'ORGANIZATION_CODE',
26809: p_org_partner_id => 'ORGANIZATION_ID',
26810: p_instance_code => v_instance_code,
26811: p_partner_type => G_ORGANIZATION,

Line 26837: (p_table_name => 'MSC_ST_SAFETY_STOCKS',

26833: END IF;
26834:
26835: --Derive Inventory_item_id
26836: lv_return := MSC_ST_UTIL.DERIVE_ITEM_ID
26837: (p_table_name => 'MSC_ST_SAFETY_STOCKS',
26838: p_item_col_name => 'ITEM_NAME',
26839: p_item_col_id => 'INVENTORY_ITEM_ID',
26840: p_instance_id => v_instance_id,
26841: p_instance_code => v_instance_code,

Line 26867: 'UPDATE msc_st_safety_stocks mss'

26863:
26864: v_sql_stmt := 08;
26865: lv_sql_stmt :=
26866:
26867: 'UPDATE msc_st_safety_stocks mss'
26868: ||' SET process_flag = '||G_ERROR_FLG||','
26869: ||' error_text = '||''''||lv_message_text||''''
26870: ||' WHERE EXISTS (SELECT 1'
26871: ||' FROM msc_st_system_items msi'

Line 26917: (p_table_name => 'MSC_ST_SAFETY_STOCKS',

26913: END IF;
26914:
26915: --Derive Project Id.
26916: lv_return := MSC_ST_UTIL.DERIVE_PROJ_TASK_ID
26917: (p_table_name => 'MSC_ST_SAFETY_STOCKS',
26918: p_proj_col_name => 'PROJECT_NUMBER',
26919: p_proj_task_col_id => 'PROJECT_ID',
26920: p_instance_code => v_instance_code,
26921: p_entity_name => 'PROJECT_ID',

Line 26950: (p_table_name => 'MSC_ST_SAFETY_STOCKS',

26946: END IF;
26947:
26948: --Derive Task Id.
26949: lv_return := MSC_ST_UTIL.DERIVE_PROJ_TASK_ID
26950: (p_table_name => 'MSC_ST_SAFETY_STOCKS',
26951: p_proj_col_name => 'PROJECT_NUMBER',
26952: p_proj_task_col_id => 'TASK_ID',
26953: p_instance_code => v_instance_code,
26954: p_entity_name => 'TASK_ID',

Line 26973: pEntityName => 'MSC_ST_SAFETY_STOCKS',

26969: (ERRBUF => lv_error_text,
26970: RETCODE => lv_return,
26971: pBatchID => lv_batch_id,
26972: pInstanceCode => v_instance_code,
26973: pEntityName => 'MSC_ST_SAFETY_STOCKS',
26974: pInstanceID => v_instance_id);
26975:
26976: IF NVL(lv_return,0) <> 0 THEN
26977: RAISE ex_logging_err;

Line 26981: (p_table_name => 'MSC_ST_SAFETY_STOCKS',

26977: RAISE ex_logging_err;
26978: END IF;
26979:
26980: lv_return := MSC_ST_UTIL.SET_PROCESS_FLAG
26981: (p_table_name => 'MSC_ST_SAFETY_STOCKS',
26982: p_instance_id => v_instance_id,
26983: p_instance_code => v_instance_code,
26984: p_process_flag => G_VALID,
26985: p_error_text => lv_error_text,

Line 26994: (p_table_name => 'MSC_ST_SAFETY_STOCKS',

26990: RAISE ex_logging_err;
26991: END IF;
26992:
26993: lv_return := MSC_ST_UTIL.LOG_ERROR
26994: (p_table_name => 'MSC_ST_SAFETY_STOCKS',
26995: p_instance_code => v_instance_code,
26996: p_row => lv_column_names,
26997: p_severity => G_SEV_ERROR,
26998: p_message_text => NULL,

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

55967: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_ITEM_CUSTOMERS');
55968: END IF;
55969:
55970: IF v_safety_stk_enabled = SYS_YES THEN
55971: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_SAFETY_STOCKS');
55972: IF lv_count > 0 Then
55973: prec.saf_stock_flag:= SYS_YES;
55974: End IF;
55975: END IF;