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.MSD_CL_PRE_PROCESS dependencies on MSD_ST_PRICE_LIST

Line 6797: lv_batch_id msd_st_price_list.batch_id%TYPE;

6793: IS
6794: TYPE RowidTab IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
6795: lb_rowid RowidTab;
6796: lv_sql_stmt VARCHAR2(4000);
6797: lv_batch_id msd_st_price_list.batch_id%TYPE;
6798: lv_message_text msc_errors.error_text%TYPE;
6799: lv_my_company msc_companies.company_name%TYPE := GET_MY_COMPANY;
6800: lv_error_text VARCHAR2(250);
6801: lv_debug BOOLEAN := msc_cl_pre_process.v_debug;

Line 6811: FROM msd_st_price_list

6807: lv_column_names VARCHAR2(5000);
6808:
6809: CURSOR c1(p_batch_id NUMBER)IS
6810: SELECT rowid
6811: FROM msd_st_price_list
6812: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
6813: AND sr_instance_code = p_instance_code
6814: AND batch_id = p_batch_id;
6815:

Line 6855: UPDATE msd_st_price_list

6851: CLOSE c1;
6852:
6853: v_sql_stmt := 04;
6854: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
6855: UPDATE msd_st_price_list
6856: SET st_transaction_id = msd_st_price_list_s.NEXTVAL,
6857: last_update_date = lv_current_date,
6858: last_updated_by = lv_current_user,
6859: creation_date = lv_current_date,

Line 6856: SET st_transaction_id = msd_st_price_list_s.NEXTVAL,

6852:
6853: v_sql_stmt := 04;
6854: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
6855: UPDATE msd_st_price_list
6856: SET st_transaction_id = msd_st_price_list_s.NEXTVAL,
6857: last_update_date = lv_current_date,
6858: last_updated_by = lv_current_user,
6859: creation_date = lv_current_date,
6860: created_by = lv_current_user

Line 6882: (p_table_name => 'MSD_ST_PRICE_LIST',

6878: -- Derive the org_level_id , error out if invalid level name
6879:
6880:
6881: lv_return := MSC_ST_UTIL.DERIVE_LEVEL_ID
6882: (p_table_name => 'MSD_ST_PRICE_LIST',
6883: p_level_name_col => 'ORGANIZATION_LVL',
6884: p_level_id_col => 'ORGANIZATION_LVL_ID',
6885: p_severity => G_SEV_ERROR, -- Against Bug#2413920
6886: p_message_text => lv_message_text,

Line 6912: (p_table_name => 'MSD_ST_PRICE_LIST',

6908:
6909: -- Derive SR_ORGANIZATION_LVL_PK
6910:
6911: lv_return := MSC_ST_UTIL.DERIVE_LEVEL_PK
6912: (p_table_name => 'MSD_ST_PRICE_LIST',
6913: p_level_val_col => 'SR_ORGANIZATION_LVL_VAL',
6914: p_level_name_col => 'ORGANIZATION_LVL',
6915: p_level_pk_col => 'SR_ORGANIZATION_LVL_PK',
6916: p_instance_code => p_instance_code,

Line 6946: (p_table_name => 'MSD_ST_PRICE_LIST',

6942: -- Derive the PRODUCT_LVL_ID, error out if invalid level name
6943:
6944:
6945: lv_return := MSC_ST_UTIL.DERIVE_LEVEL_ID
6946: (p_table_name => 'MSD_ST_PRICE_LIST',
6947: p_level_name_col => 'PRODUCT_LVL',
6948: p_level_id_col => 'PRODUCT_LVL_ID',
6949: p_severity => G_SEV_ERROR, -- Against Bug#2413920
6950: p_message_text => lv_message_text,

Line 6976: (p_table_name => 'MSD_ST_PRICE_LIST',

6972:
6973: -- Derive SR_PRODUCT_LVL_PK
6974:
6975: lv_return := MSC_ST_UTIL.DERIVE_LEVEL_PK
6976: (p_table_name => 'MSD_ST_PRICE_LIST',
6977: p_level_val_col => 'SR_PRODUCT_LVL_VAL',
6978: p_level_name_col => 'PRODUCT_LVL',
6979: p_level_pk_col => 'SR_PRODUCT_LVL_PK',
6980: p_instance_code => p_instance_code,

Line 7010: (p_table_name => 'MSD_ST_PRICE_LIST',

7006: -- Derive the SALESCHANNEL_LVL_ID, error out if invalid level name
7007:
7008:
7009: lv_return := MSC_ST_UTIL.DERIVE_LEVEL_ID
7010: (p_table_name => 'MSD_ST_PRICE_LIST',
7011: p_level_name_col => 'SALESCHANNEL_LVL',
7012: p_level_id_col => 'SALESCHANNEL_LVL_ID',
7013: p_severity => G_SEV_ERROR, -- Against Bug#2413920
7014: p_message_text => lv_message_text,

Line 7040: (p_table_name => 'MSD_ST_PRICE_LIST',

7036:
7037: -- Derive SR_SALESCHANNEL_LVL_PK
7038:
7039: lv_return := MSC_ST_UTIL.DERIVE_LEVEL_PK
7040: (p_table_name => 'MSD_ST_PRICE_LIST',
7041: p_level_val_col => 'SR_SALESCHANNEL_LVL_VAL',
7042: p_level_name_col => 'SALESCHANNEL_LVL',
7043: p_level_pk_col => 'SR_SALESCHANNEL_LVL_PK',
7044: p_instance_code => p_instance_code,

Line 7073: (p_table_name => 'MSD_ST_PRICE_LIST',

7069: -- Derive the SALESREP_LVL_ID, error out if invalid level name
7070:
7071:
7072: lv_return := MSC_ST_UTIL.DERIVE_LEVEL_ID
7073: (p_table_name => 'MSD_ST_PRICE_LIST',
7074: p_level_name_col => 'SALES_REP_LVL',
7075: p_level_id_col => 'SALES_REP_LVL_ID',
7076: p_severity => G_SEV_ERROR, -- Against Bug#2413920
7077: p_message_text => lv_message_text,

Line 7103: (p_table_name => 'MSD_ST_PRICE_LIST',

7099:
7100: -- Derive SR_SALESREP_LVL_PK
7101:
7102: lv_return := MSC_ST_UTIL.DERIVE_LEVEL_PK
7103: (p_table_name => 'MSD_ST_PRICE_LIST',
7104: p_level_val_col => 'SR_SALES_REP_LVL_VAL',
7105: p_level_name_col => 'SALES_REP_LVL',
7106: p_level_pk_col => 'SR_SALES_REP_LVL_PK',
7107: p_instance_code => p_instance_code,

Line 7135: (p_table_name => 'MSD_ST_PRICE_LIST',

7131:
7132: -- Derive the GEOGRAPHY_LVL_ID, error out if invalid level name
7133:
7134: lv_return := MSC_ST_UTIL.DERIVE_LEVEL_ID
7135: (p_table_name => 'MSD_ST_PRICE_LIST',
7136: p_level_name_col => 'GEOGRAPHY_LVL',
7137: p_level_id_col => 'GEOGRAPHY_LVL_ID',
7138: p_severity => G_SEV_ERROR, -- Against Bug#2413920
7139: p_message_text => lv_message_text,

Line 7165: (p_table_name => 'MSD_ST_PRICE_LIST',

7161:
7162: -- Derive SR_GEOGRAPHY_LVL_PK
7163:
7164: lv_return := MSC_ST_UTIL.DERIVE_LEVEL_PK
7165: (p_table_name => 'MSD_ST_PRICE_LIST',
7166: p_level_val_col => 'SR_GEOGRAPHY_LVL_VAL',
7167: p_level_name_col => 'GEOGRAPHY_LVL',
7168: p_level_pk_col => 'SR_GEOGRAPHY_LVL_PK',
7169: p_instance_code => p_instance_code,

Line 7197: (p_table_name => 'MSD_ST_PRICE_LIST',

7193:
7194: -- Derive the USER_DEFINED1_LVL_ID, error out if invalid level name
7195:
7196: lv_return := MSC_ST_UTIL.DERIVE_LEVEL_ID
7197: (p_table_name => 'MSD_ST_PRICE_LIST',
7198: p_level_name_col => 'USER_DEFINED1_LVL',
7199: p_level_id_col => 'USER_DEFINED1_LVL_ID',
7200: p_severity => G_SEV3_ERROR ,
7201: p_message_text => lv_message_text,

Line 7228: (p_table_name => 'MSD_ST_PRICE_LIST',

7224:
7225: -- Derive SR_USER_DEFINED1_LVL_PK
7226:
7227: lv_return := MSC_ST_UTIL.DERIVE_LEVEL_PK
7228: (p_table_name => 'MSD_ST_PRICE_LIST',
7229: p_level_val_col => 'SR_USER_DEFINED1_LVL_VAL',
7230: p_level_name_col => 'USER_DEFINED1_LVL',
7231: p_level_pk_col => 'SR_USER_DEFINED1_LVL_PK',
7232: p_instance_code => p_instance_code,

Line 7259: (p_table_name => 'MSD_ST_PRICE_LIST',

7255:
7256: -- Derive the USER_DEFINED2_LVL_ID, error out if invalid level name
7257:
7258: lv_return := MSC_ST_UTIL.DERIVE_LEVEL_ID
7259: (p_table_name => 'MSD_ST_PRICE_LIST',
7260: p_level_name_col => 'USER_DEFINED2_LVL',
7261: p_level_id_col => 'USER_DEFINED2_LVL_ID',
7262: p_severity => G_SEV3_ERROR ,
7263: p_message_text => lv_message_text,

Line 7290: (p_table_name => 'MSD_ST_PRICE_LIST',

7286:
7287: -- Derive SR_USER_DEFINED2_LVL_PK
7288:
7289: lv_return := MSC_ST_UTIL.DERIVE_LEVEL_PK
7290: (p_table_name => 'MSD_ST_PRICE_LIST',
7291: p_level_val_col => 'SR_USER_DEFINED2_LVL_VAL',
7292: p_level_name_col => 'USER_DEFINED2_LVL',
7293: p_level_pk_col => 'SR_USER_DEFINED2_LVL_PK',
7294: p_instance_code => p_instance_code,

Line 7322: (p_table_name => 'MSD_ST_PRICE_LIST',

7318:
7319: -- Derive the DEMAND_CLASS_LVL_ID, error out if invalid level name
7320:
7321: lv_return := MSC_ST_UTIL.DERIVE_LEVEL_ID
7322: (p_table_name => 'MSD_ST_PRICE_LIST',
7323: p_level_name_col => 'DEMAND_CLASS_LVL',
7324: p_level_id_col => 'DEMAND_CLASS_LVL_ID',
7325: p_severity => G_SEV3_ERROR, -- Against Bug#2413920
7326: p_message_text => lv_message_text,

Line 7352: (p_table_name => 'MSD_ST_PRICE_LIST',

7348:
7349: -- Derive SR_DEMAND_CLASS_LVL_PK
7350:
7351: lv_return := MSC_ST_UTIL.DERIVE_LEVEL_PK
7352: (p_table_name => 'MSD_ST_PRICE_LIST',
7353: p_level_val_col => 'SR_DEMAND_CLASS_LVL_VAL',
7354: p_level_name_col => 'DEMAND_CLASS_LVL',
7355: p_level_pk_col => 'SR_DEMAND_CLASS_LVL_PK',
7356: p_instance_code => p_instance_code,

Line 7384: UPDATE msd_st_price_list mspl

7380: END IF;
7381:
7382:
7383:
7384: UPDATE msd_st_price_list mspl
7385: SET process_flag = G_ERROR_FLG,
7386: error_text = lv_message_text
7387: WHERE NOT EXISTS(SELECT 1
7388: FROM msc_st_units_of_measure msum

Line 7423: p_token_value3 => 'MSD_ST_PRICE_LIST');

7419: ||' AND ITEM.MRP_PLANNING_CODE',
7420: p_token2 => 'MASTER_TABLE',
7421: p_token_value2 => 'MSC_SYSTEM_ITEMS',
7422: p_token3 => 'CHILD_TABLE',
7423: p_token_value3 => 'MSD_ST_PRICE_LIST');
7424:
7425: IF lv_return <> 0 THEN
7426: RAISE ex_logging_err;
7427: END IF;

Line 7432: UPDATE msd_st_price_list mpl

7428:
7429: -- Validate item-org combination
7430: v_sql_stmt := 15;
7431:
7432: UPDATE msd_st_price_list mpl
7433: SET process_flag = G_ERROR_FLG,
7434: error_text = lv_message_text
7435: WHERE NOT EXISTS(SELECT 1
7436: FROM msc_st_system_items msi

Line 7466: pEntityName => 'MSD_ST_PRICE_LIST',

7462: (ERRBUF => lv_error_text,
7463: RETCODE => lv_return,
7464: pBatchID => null,
7465: pInstanceCode => p_instance_code,
7466: pEntityName => 'MSD_ST_PRICE_LIST',
7467: pInstanceID => p_instance_id);
7468:
7469: IF lv_return <> 0 THEN
7470: RAISE ex_logging_err;

Line 7475: (p_table_name => 'MSD_ST_PRICE_LIST',

7471: END IF;
7472:
7473: -- Set the process flag as Valid and populate instance_id
7474: lv_return := MSC_ST_UTIL.SET_PROCESS_FLAG
7475: (p_table_name => 'MSD_ST_PRICE_LIST',
7476: p_instance_id => p_instance_id,
7477: p_instance_code => p_instance_code,
7478: p_process_flag => G_VALID,
7479: p_error_text => lv_error_text,

Line 7490: (p_table_name => 'MSD_ST_PRICE_LIST',

7486:
7487: -- Inserting all the errored out records into MSC_ERRORS:
7488:
7489: lv_return := MSC_ST_UTIL.LOG_ERROR
7490: (p_table_name => 'MSD_ST_PRICE_LIST',
7491: p_instance_code => p_instance_code,
7492: p_row => lv_column_names,
7493: p_severity => G_SEV_ERROR,
7494: p_error_text => lv_error_text,