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_SHIPMENT_DATA

Line 2997: lv_batch_id msd_st_shipment_data.batch_id%TYPE;

2993: TYPE RowidTab IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
2994: lb_rowid RowidTab;
2995: /* lb_rowid1 RowidTab; Bug3749959 */
2996: lv_sql_stmt VARCHAR2(4000);
2997: lv_batch_id msd_st_shipment_data.batch_id%TYPE;
2998: lv_message_text msc_errors.error_text%TYPE;
2999: lv_my_company msc_companies.company_name%TYPE := GET_MY_COMPANY;
3000: lv_error_text VARCHAR2(250);
3001: lv_debug BOOLEAN := msc_cl_pre_process.v_debug;

Line 3025: FROM msd_st_shipment_data

3021: WHERE instance_id=p_instance_id;
3022:
3023: CURSOR c1(p_batch_id NUMBER)IS
3024: SELECT rowid
3025: FROM msd_st_shipment_data
3026: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
3027: AND sr_instance_code = p_instance_code
3028: AND batch_id = p_batch_id;
3029: /*

Line 3032: FROM msd_st_shipment_data

3028: AND batch_id = p_batch_id;
3029: /*
3030: CURSOR c2(p_batch_id NUMBER)IS
3031: SELECT rowid
3032: FROM msd_st_shipment_data
3033: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
3034: AND nvl(DEMAND_CLASS_LVL_VAL,'-1') = '-1'
3035: AND sr_instance_code = p_instance_code
3036: AND batch_id = p_batch_id;

Line 3083: UPDATE msd_st_shipment_data

3079: CLOSE c1;
3080:
3081: v_sql_stmt := 04;
3082: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
3083: UPDATE msd_st_shipment_data
3084: SET st_transaction_id = msd_st_shipment_data_s.NEXTVAL,
3085: last_update_date = lv_current_date,
3086: last_updated_by = lv_current_user,
3087: creation_date = lv_current_date,

Line 3084: SET st_transaction_id = msd_st_shipment_data_s.NEXTVAL,

3080:
3081: v_sql_stmt := 04;
3082: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
3083: UPDATE msd_st_shipment_data
3084: SET st_transaction_id = msd_st_shipment_data_s.NEXTVAL,
3085: last_update_date = lv_current_date,
3086: last_updated_by = lv_current_user,
3087: creation_date = lv_current_date,
3088: created_by = lv_current_user

Line 3102: UPDATE msd_st_shipment_data

3098: lv_all_dcs_desc := msd_sr_util.get_all_dcs_desc; --Calling fuction - msd_sr_util.get_all_dcs_desc, to fetch the level value 'All Demand Classes'
3099:
3100: v_sql_stmt := 05;
3101: FORALL j IN lb_rowid1.FIRST..lb_rowid1.LAST
3102: UPDATE msd_st_shipment_data
3103: SET DEMAND_CLASS_LVL_VAL = lv_other_desc --Using the value fetched from function - msd_sr_util.get_null_desc
3104: WHERE rowid = lb_rowid1(j);
3105:
3106:

Line 3292: p_token_value3 => 'MSD_ST_SHIPMENT_DATA');

3288: ||' CUSTOMER AND SHIP_TO_LOC',
3289: p_token2 => 'MASTER_TABLE',
3290: p_token_value2 => 'MSC_TRADING_PARTNER_SITES',
3291: p_token3 => 'CHILD_TABLE',
3292: p_token_value3 => 'MSD_ST_SHIPMENT_DATA');
3293:
3294: IF lv_return <> 0 THEN
3295: RAISE ex_logging_err;
3296: END IF;

Line 3300: UPDATE msd_st_shipment_data msd

3296: END IF;
3297:
3298: -- Validate customer-ship to location combination
3299: v_sql_stmt := 15;
3300: UPDATE msd_st_shipment_data msd
3301: SET process_flag = G_ERROR_FLG,
3302: error_text = lv_message_text
3303: WHERE NOT EXISTS(SELECT 1
3304: FROM msc_local_id_setup mls

Line 3334: (p_table_name => 'MSD_ST_SHIPMENT_DATA',

3330:
3331: -- Derive sr_item_pk from msd_st_level_values and msd_level_values
3332:
3333: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
3334: (p_table_name => 'MSD_ST_SHIPMENT_DATA',
3335: p_column_name => 'ITEM',
3336: p_pk_col_name => 'SR_ITEM_PK',
3337: p_level_id => 1,
3338: p_instance_code => p_instance_code,

Line 3354: 'UPDATE MSD_ST_SHIPMENT_DATA '

3350:
3351: v_sql_stmt := 07;
3352:
3353: lv_sql_Stmt:=
3354: 'UPDATE MSD_ST_SHIPMENT_DATA '
3355: ||' SET ORIGINAL_ITEM =ITEM '
3356: ||' WHERE ORIGINAL_ITEM IS NULL '
3357: ||' AND process_flag ='|| G_IN_PROCESS
3358: ||' AND batch_id = :lv_batch_id'

Line 3386: (p_table_name => 'MSD_ST_SHIPMENT_DATA',

3382:
3383: -- Derive sr_original_item_pk from msd_st_level_values and msd_level_values
3384:
3385: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
3386: (p_table_name => 'MSD_ST_SHIPMENT_DATA',
3387: p_column_name => 'ORIGINAL_ITEM',
3388: p_pk_col_name => 'SR_ORIGINAL_ITEM_PK',
3389: p_level_id => 1,
3390: p_instance_code => p_instance_code,

Line 3417: (p_table_name => 'MSD_ST_SHIPMENT_DATA',

3413:
3414: -- Derive sr_inv_org_pk from msd_st_level_values and msd_level_values
3415:
3416: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
3417: (p_table_name => 'MSD_ST_SHIPMENT_DATA',
3418: p_column_name => 'INV_ORG',
3419: p_pk_col_name => 'SR_INV_ORG_PK',
3420: p_level_id => 7,
3421: p_instance_code => p_instance_code,

Line 3446: p_token_value3 => 'MSD_ST_SHIPMENT_DATA');

3442: ||' AND ITEM.MRP_PLANNING_CODE',
3443: p_token2 => 'MASTER_TABLE',
3444: p_token_value2 => 'MSC_SYSTEM_ITEMS',
3445: p_token3 => 'CHILD_TABLE',
3446: p_token_value3 => 'MSD_ST_SHIPMENT_DATA');
3447:
3448: IF lv_return <> 0 THEN
3449: RAISE ex_logging_err;
3450: END IF;

Line 3455: UPDATE msd_st_shipment_data msd

3451:
3452: -- Validate item-org combination
3453: v_sql_stmt := 15;
3454:
3455: UPDATE msd_st_shipment_data msd
3456: SET process_flag = G_ERROR_FLG,
3457: error_text = lv_message_text
3458: WHERE NOT EXISTS(SELECT 1
3459: FROM msc_st_system_items msi

Line 3497: (p_table_name => 'MSD_ST_SHIPMENT_DATA',

3493:
3494: -- Derive sr_customer_pk from msd_st_level_values and msd_level_values
3495:
3496: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
3497: (p_table_name => 'MSD_ST_SHIPMENT_DATA',
3498: p_column_name => 'CUSTOMER',
3499: p_pk_col_name => 'SR_CUSTOMER_PK',
3500: p_level_id => 15,
3501: p_instance_code => p_instance_code,

Line 3527: (p_table_name => 'MSD_ST_SHIPMENT_DATA',

3523:
3524: -- Derive sr_ship_to_loc_pk from msd_st_level_values and msd_level_values
3525:
3526: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
3527: (p_table_name => 'MSD_ST_SHIPMENT_DATA',
3528: p_column_name => 'SHIP_TO_LOC',
3529: p_pk_col_name => 'SR_SHIP_TO_LOC_PK',
3530: p_level_id => 11,
3531: p_instance_code => p_instance_code,

Line 3556: p_token_value3 => 'MSD_ST_SHIPMENT_DATA');

3552: ||' CUSTOMER AND SHIP_TO_LOC',
3553: p_token2 => 'MASTER_TABLE',
3554: p_token_value2 => 'MSD_LEVEL_ASSOCIATIONS',
3555: p_token3 => 'CHILD_TABLE',
3556: p_token_value3 => 'MSD_ST_SHIPMENT_DATA');
3557:
3558: IF lv_return <> 0 THEN
3559: RAISE ex_logging_err;
3560: END IF;

Line 3563: UPDATE msd_st_shipment_data msd

3559: RAISE ex_logging_err;
3560: END IF;
3561:
3562: -- Validate customer-ship to location combination for ERP data
3563: UPDATE msd_st_shipment_data msd
3564: SET process_flag = G_ERROR_FLG,
3565: error_text = lv_message_text
3566: WHERE NOT EXISTS(SELECT 1
3567: FROM msd_st_level_associations msla

Line 3603: (p_table_name => 'MSD_ST_SHIPMENT_DATA',

3599:
3600: -- Derive sr_sales_channel_pk from msd_st_level_values and msd_level_values
3601:
3602: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
3603: (p_table_name => 'MSD_ST_SHIPMENT_DATA',
3604: p_column_name => 'SALES_CHANNEL',
3605: p_pk_col_name => 'SR_SALES_CHANNEL_PK',
3606: p_level_id => 27,
3607: p_instance_code => p_instance_code,

Line 3633: (p_table_name => 'MSD_ST_SHIPMENT_DATA',

3629: END IF;
3630: -- Derive sr_sales_rep_pk from msd_st_level_values and msd_level_values
3631:
3632: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
3633: (p_table_name => 'MSD_ST_SHIPMENT_DATA',
3634: p_column_name => 'SALES_REP',
3635: p_pk_col_name => 'SR_SALES_REP_PK',
3636: p_level_id => 18,
3637: p_instance_code => p_instance_code,

Line 3664: (p_table_name => 'MSD_ST_SHIPMENT_DATA',

3660: END IF;
3661: -- Derive sr_sales_rep_pk from msd_st_level_values and msd_level_values
3662:
3663: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
3664: (p_table_name => 'MSD_ST_SHIPMENT_DATA',
3665: p_column_name => 'DEMAND_CLASS_LVL_VAL',
3666: p_pk_col_name => 'SR_DEMAND_CLASS_PK',
3667: p_level_id => 34,
3668: p_instance_code => p_instance_code,

Line 3695: (p_table_name => 'MSD_ST_SHIPMENT_DATA',

3691: END IF;
3692: -- Derive sr_sales_rep_pk from msd_st_level_values and msd_level_values
3693:
3694: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
3695: (p_table_name => 'MSD_ST_SHIPMENT_DATA',
3696: p_column_name => 'PARENT_ITEM',
3697: p_pk_col_name => 'SR_PARENT_ITEM_PK',
3698: p_level_id => 1,
3699: p_instance_code => p_instance_code,

Line 3730: (p_table_name => 'MSD_ST_SHIPMENT_DATA',

3726:
3727: -- Derive SR_USER_DEFINED1_LVL_PK
3728:
3729: lv_return := MSC_ST_UTIL.DERIVE_LEVEL_PK
3730: (p_table_name => 'MSD_ST_SHIPMENT_DATA',
3731: p_level_val_col => 'USER_DEFINED1',
3732: p_level_name_col => 'USER_DEFINED_LEVEL1',
3733: p_level_pk_col => 'SR_USER_DEFINED1_PK',
3734: p_instance_code => p_instance_code,

Line 3761: (p_table_name => 'MSD_ST_SHIPMENT_DATA',

3757:
3758: -- Derive SR_USER_DEFINED2_LVL_PK
3759:
3760: lv_return := MSC_ST_UTIL.DERIVE_LEVEL_PK
3761: (p_table_name => 'MSD_ST_SHIPMENT_DATA',
3762: p_level_val_col => 'USER_DEFINED2',
3763: p_level_name_col => 'USER_DEFINED_LEVEL2',
3764: p_level_pk_col => 'SR_USER_DEFINED2_PK',
3765: p_instance_code => p_instance_code,

Line 3791: 'UPDATE msd_st_shipment_data '

3787: --shipped_date cannot be null.
3788: v_sql_stmt := 07;
3789:
3790: lv_sql_Stmt:=
3791: 'UPDATE msd_st_shipment_data '
3792: ||' SET process_flag ='||G_ERROR_FLG||','
3793: ||' error_text = '||''''||lv_message_text||''''
3794: ||' WHERE NVL(shipped_date,(sysdate-36500)) = (sysdate-36500)'
3795: ||' AND process_flag ='|| G_IN_PROCESS

Line 3814: pEntityName => 'MSD_ST_SHIPMENT_DATA',

3810: (ERRBUF => lv_error_text,
3811: RETCODE => lv_return,
3812: pBatchID => lv_batch_id,
3813: pInstanceCode => p_instance_code,
3814: pEntityName => 'MSD_ST_SHIPMENT_DATA',
3815: pInstanceID => p_instance_id);
3816:
3817: IF NVL(lv_return,0) <> 0 THEN
3818: RAISE ex_logging_err;

Line 3823: (p_table_name => 'MSD_ST_SHIPMENT_DATA',

3819: END IF;
3820:
3821: -- Set the process flag as Valid and populate instance_id
3822: lv_return := MSC_ST_UTIL.SET_PROCESS_FLAG
3823: (p_table_name => 'MSD_ST_SHIPMENT_DATA',
3824: p_instance_id => p_instance_id,
3825: p_instance_code => p_instance_code,
3826: p_process_flag => G_VALID,
3827: p_error_text => lv_error_text,

Line 3838: (p_table_name => 'MSD_ST_SHIPMENT_DATA',

3834:
3835: -- Inserting all the errored out records into MSC_ERRORS:
3836:
3837: lv_return := MSC_ST_UTIL.LOG_ERROR
3838: (p_table_name => 'MSD_ST_SHIPMENT_DATA',
3839: p_instance_code => p_instance_code,
3840: p_row => lv_column_names,
3841: p_severity => G_SEV_ERROR,
3842: p_error_text => lv_error_text,