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 MSC_ERRORS

Line 1388: lv_message_text msc_errors.error_text%TYPE;

1384: lb_level_value LevelValueTab;
1385: lb_sr_level_pk SrLevelPk;
1386: lv_sql_stmt VARCHAR2(4000);
1387: lv_batch_id msd_st_level_values.batch_id%TYPE;
1388: lv_message_text msc_errors.error_text%TYPE;
1389: lv_error_text VARCHAR2(250);
1390: lv_debug BOOLEAN := msc_cl_pre_process.v_debug;
1391: lv_batch_size NUMBER := msc_cl_pre_process.v_batch_size;
1392: lv_current_user NUMBER := msc_cl_pre_process.v_current_user;

Line 1764: -- Inserting all the errored out records into MSC_ERRORS

1760: IF lv_return <> 0 THEN
1761: RAISE ex_logging_err;
1762: END IF;
1763:
1764: -- Inserting all the errored out records into MSC_ERRORS
1765:
1766: lv_return := MSC_ST_UTIL.LOG_ERROR
1767: (p_table_name => 'MSD_ST_LEVEL_VALUES',
1768: p_instance_code => p_instance_code,

Line 1822: lv_message_text msc_errors.error_text%TYPE;

1818: TYPE RowidTab IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
1819: lb_rowid RowidTab;
1820: lv_sql_stmt VARCHAR2(4000);
1821: lv_batch_id msd_st_level_associations.batch_id%TYPE;
1822: lv_message_text msc_errors.error_text%TYPE;
1823: lv_error_text VARCHAR2(250);
1824: lv_debug BOOLEAN := msc_cl_pre_process.v_debug;
1825: lv_batch_size NUMBER := msc_cl_pre_process.v_batch_size;
1826: lv_current_user NUMBER := msc_cl_pre_process.v_current_user;

Line 2058: -- Inserting all the errored out records into MSC_ERRORS:

2054: IF lv_return <> 0 THEN
2055: RAISE ex_logging_err;
2056: END IF;
2057:
2058: -- Inserting all the errored out records into MSC_ERRORS:
2059:
2060: lv_return := MSC_ST_UTIL.LOG_ERROR
2061: (p_table_name => 'MSD_ST_LEVEL_ASSOCIATIONS',
2062: p_instance_code => p_instance_code,

Line 2109: lv_message_text msc_errors.error_text%TYPE;

2105: lb_rowid RowidTab;
2106: /* lb_rowid1 RowidTab; Bug3749959 */
2107: lv_sql_stmt VARCHAR2(4000);
2108: lv_batch_id msd_st_booking_data.batch_id%TYPE;
2109: lv_message_text msc_errors.error_text%TYPE;
2110: lv_my_company msc_companies.company_name%TYPE := GET_MY_COMPANY;
2111: lv_error_text VARCHAR2(250);
2112: lv_debug BOOLEAN := msc_cl_pre_process.v_debug;
2113: lv_batch_size NUMBER := msc_cl_pre_process.v_batch_size;

Line 2947: -- Inserting all the errored out records into MSC_ERRORS:

2943: IF lv_return <> 0 THEN
2944: RAISE ex_logging_err;
2945: END IF;
2946:
2947: -- Inserting all the errored out records into MSC_ERRORS:
2948:
2949: lv_return := MSC_ST_UTIL.LOG_ERROR
2950: (p_table_name => 'MSD_ST_BOOKING_DATA',
2951: p_instance_code => p_instance_code,

Line 2998: lv_message_text msc_errors.error_text%TYPE;

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;
3002: lv_batch_size NUMBER := msc_cl_pre_process.v_batch_size;

Line 3835: -- Inserting all the errored out records into MSC_ERRORS:

3831: IF lv_return <> 0 THEN
3832: RAISE ex_logging_err;
3833: END IF;
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,

Line 3887: lv_message_text msc_errors.error_text%TYPE;

3883: /* lb_rowid1 RowidTab; Bug3749959 */
3884: lv_sql_stmt VARCHAR2(4000);
3885: lv_batch_id msd_st_mfg_forecast.batch_id%TYPE;
3886: lv_my_company msc_companies.company_name%TYPE := GET_MY_COMPANY;
3887: lv_message_text msc_errors.error_text%TYPE;
3888: lv_error_text VARCHAR2(250);
3889: lv_debug BOOLEAN := msc_cl_pre_process.v_debug;
3890: lv_batch_size NUMBER := msc_cl_pre_process.v_batch_size;
3891: lv_current_user NUMBER := msc_cl_pre_process.v_current_user;

Line 4618: -- Inserting all the errored out records into MSC_ERRORS:

4614: RAISE ex_logging_err;
4615: END IF;
4616:
4617:
4618: -- Inserting all the errored out records into MSC_ERRORS:
4619:
4620: lv_return := MSC_ST_UTIL.LOG_ERROR
4621: (p_table_name => 'MSD_ST_MFG_FORECAST',
4622: p_instance_code => p_instance_code,

Line 4808: lv_message_text msc_errors.error_text%TYPE;

4804:
4805: lb_rowid RowidTab;
4806: lv_sql_stmt VARCHAR2(4000);
4807: lv_batch_id msd_st_time.batch_id%TYPE;
4808: lv_message_text msc_errors.error_text%TYPE;
4809: lv_error_text VARCHAR2(250);
4810: lv_from_date DATE ;
4811: lv_to_date DATE ;
4812: lv_debug BOOLEAN := msc_cl_pre_process.v_debug;

Line 5066: -- Inserting all the errored out records into MSC_ERRORS:

5062: IF lv_return <> 0 THEN
5063: RAISE ex_logging_err;
5064: END IF;
5065:
5066: -- Inserting all the errored out records into MSC_ERRORS:
5067:
5068: lv_return := MSC_ST_UTIL.LOG_ERROR
5069: (p_table_name => 'MSD_ST_TIME',
5070: p_instance_code => p_instance_code,

Line 5242: lv_message_text msc_errors.error_text%TYPE;

5238:
5239: lb_rowid RowidTab;
5240: lv_sql_stmt VARCHAR2(4000);
5241: lv_batch_id msd_st_time.batch_id%TYPE;
5242: lv_message_text msc_errors.error_text%TYPE;
5243: lv_error_text VARCHAR2(250);
5244: lv_from_date DATE ;
5245: lv_to_date DATE ;
5246: lv_debug BOOLEAN := msc_cl_pre_process.v_debug;

Line 5536: -- Inserting all the errored out records into MSC_ERRORS:

5532: END IF;
5533:
5534:
5535:
5536: -- Inserting all the errored out records into MSC_ERRORS:
5537:
5538: lv_return := MSC_ST_UTIL.LOG_ERROR
5539: (p_table_name => 'MSD_ST_TIME',
5540: p_instance_code => p_instance_code,

Line 5722: lv_message_text msc_errors.error_text%TYPE;

5718: TYPE RowidTab IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
5719: lb_rowid RowidTab;
5720: lv_sql_stmt VARCHAR2(4000);
5721: lv_batch_id msd_st_currency_conversions.batch_id%TYPE;
5722: lv_message_text msc_errors.error_text%TYPE;
5723: lv_error_text VARCHAR2(250);
5724: lv_debug BOOLEAN := msc_cl_pre_process.v_debug;
5725: lv_batch_size NUMBER := msc_cl_pre_process.v_batch_size;
5726: lv_current_user NUMBER := msc_cl_pre_process.v_current_user;

Line 5830: -- Inserting all the errored out records into MSC_ERRORS:

5826: IF lv_return <> 0 THEN
5827: RAISE ex_logging_err;
5828: END IF;
5829:
5830: -- Inserting all the errored out records into MSC_ERRORS:
5831:
5832: lv_return := MSC_ST_UTIL.LOG_ERROR
5833: (p_table_name => 'MSD_ST_CURRENCY_CONVERSIONS',
5834: p_instance_code => p_instance_code,

Line 5880: lv_message_text msc_errors.error_text%TYPE;

5876: TYPE RowidTab IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
5877: lb_rowid RowidTab;
5878: lv_sql_stmt VARCHAR2(4000);
5879: lv_batch_id msd_st_cs_data.batch_id%TYPE;
5880: lv_message_text msc_errors.error_text%TYPE;
5881: lv_my_company msc_companies.company_name%TYPE := GET_MY_COMPANY;
5882: lv_error_text VARCHAR2(250);
5883: lv_debug BOOLEAN := msc_cl_pre_process.v_debug;
5884: lv_batch_size NUMBER := msc_cl_pre_process.v_batch_size;

Line 6747: -- Inserting all the errored out records into MSC_ERRORS:

6743: IF lv_return <> 0 THEN
6744: RAISE ex_logging_err;
6745: END IF;
6746:
6747: -- Inserting all the errored out records into MSC_ERRORS:
6748:
6749: lv_return := MSC_ST_UTIL.LOG_ERROR
6750: (p_table_name => 'MSD_ST_CS_DATA',
6751: p_instance_code => p_instance_code,

Line 6798: lv_message_text msc_errors.error_text%TYPE;

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;
6802: lv_batch_size NUMBER := msc_cl_pre_process.v_batch_size;

Line 7487: -- Inserting all the errored out records into MSC_ERRORS:

7483: IF lv_return <> 0 THEN
7484: RAISE ex_logging_err;
7485: END IF;
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,

Line 7538: lv_message_text msc_errors.error_text%TYPE;

7534: TYPE RowidTab IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
7535: lb_rowid RowidTab;
7536: lv_sql_stmt VARCHAR2(4000);
7537: lv_batch_id msd_st_uom_conversions.batch_id%TYPE;
7538: lv_message_text msc_errors.error_text%TYPE;
7539: lv_error_text VARCHAR2(250);
7540: lv_debug BOOLEAN := msc_cl_pre_process.v_debug;
7541: lv_batch_size NUMBER := msc_cl_pre_process.v_batch_size;
7542: lv_current_user NUMBER := msc_cl_pre_process.v_current_user;

Line 7692: -- Inserting all the errored out records into MSC_ERRORS:

7688: IF lv_return <> 0 THEN
7689: RAISE ex_logging_err;
7690: END IF;
7691:
7692: -- Inserting all the errored out records into MSC_ERRORS:
7693:
7694: lv_return := MSC_ST_UTIL.LOG_ERROR
7695: (p_table_name => 'MSD_ST_UOM_CONVERSIONS',
7696: p_instance_code => p_instance_code,

Line 7740: lv_message_text msc_errors.error_text%TYPE;

7736: IS
7737: TYPE RowidTab IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
7738: lb_rowid RowidTab;
7739: lv_sql_stmt VARCHAR2(4000);
7740: lv_message_text msc_errors.error_text%TYPE;
7741: lv_error_text VARCHAR2(250);
7742: lv_return NUMBER := 0;
7743: lv_current_user NUMBER := msc_cl_pre_process.v_current_user;
7744: lv_current_date DATE := msc_cl_pre_process.v_current_date;

Line 7868: -- Inserting all the errored out records into MSC_ERRORS:

7864: msc_st_util.log_message(SQLERRM);
7865: END ;
7866: END LOOP;
7867:
7868: -- Inserting all the errored out records into MSC_ERRORS:
7869:
7870: lv_return := MSC_ST_UTIL.LOG_ERROR
7871: (p_table_name => 'MSD_ST_SETUP_PARAMETERS',
7872: p_instance_code => p_instance_code,

Line 7915: lv_message_text msc_errors.error_text%TYPE;

7911:
7912: lb_rowid RowidTab;
7913: lv_sql_stmt VARCHAR2(4000);
7914: lv_batch_id msd_st_item_relationships.batch_id%TYPE;
7915: lv_message_text msc_errors.error_text%TYPE;
7916: lv_debug BOOLEAN := msc_cl_pre_process.v_debug;
7917: lv_current_user NUMBER := msc_cl_pre_process.v_current_user;
7918: lv_current_date DATE := msc_cl_pre_process.v_current_date;
7919: lv_batch_size NUMBER := msc_cl_pre_process.v_batch_size;

Line 8150: -- Inserting all the errored out records into MSC_ERRORS:

8146: IF lv_return <> 0 THEN
8147: RAISE ex_logging_err;
8148: END IF;
8149:
8150: -- Inserting all the errored out records into MSC_ERRORS:
8151:
8152: lv_return := MSC_ST_UTIL.LOG_ERROR
8153: (p_table_name => 'MSD_ST_ITEM_RELATIONSHIPS',
8154: p_instance_code => p_instance_code,

Line 8196: lv_message_text msc_errors.error_text%TYPE;

8192:
8193: lb_rowid RowidTab;
8194: lv_sql_stmt VARCHAR2(4000);
8195: lv_batch_id msd_st_level_org_asscns.batch_id%TYPE;
8196: lv_message_text msc_errors.error_text%TYPE;
8197: lv_debug BOOLEAN := msc_cl_pre_process.v_debug;
8198: lv_current_user NUMBER := msc_cl_pre_process.v_current_user;
8199: lv_current_date DATE := msc_cl_pre_process.v_current_date;
8200: lv_batch_size NUMBER := msc_cl_pre_process.v_batch_size;

Line 8454: -- Inserting all the errored out records into MSC_ERRORS:

8450: IF lv_return <> 0 THEN
8451: RAISE ex_logging_err;
8452: END IF;
8453:
8454: -- Inserting all the errored out records into MSC_ERRORS:
8455:
8456: lv_return := MSC_ST_UTIL.LOG_ERROR
8457: (p_table_name => 'MSD_ST_LEVEL_ORG_ASSCNS',
8458: p_instance_code => p_instance_code,