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_CL_PRE_PROCESS

Line 90: lv_debug BOOLEAN := msc_cl_pre_process.v_debug;

86: p_batch_id IN NUMBER)
87: IS
88: lv_sql_stmt VARCHAR2(4000);
89: lv_error_text VARCHAR2(250);
90: lv_debug BOOLEAN := msc_cl_pre_process.v_debug;
91:
92: BEGIN
93:
94: v_sql_stmt := 01;

Line 233: lv_debug BOOLEAN := msc_cl_pre_process.v_debug;

229: p_batch_id IN NUMBER)
230: IS
231: lv_sql_stmt VARCHAR2(6000);
232: lv_error_text VARCHAR2(250);
233: lv_debug BOOLEAN := msc_cl_pre_process.v_debug;
234:
235: cursor c1 (p_instance varchar2) is
236: select count(*) from MSD_LEVEL_VALUES
237: where LEVEL_ID = 2

Line 751: lv_debug BOOLEAN := msc_cl_pre_process.v_debug;

747: p_link IN NUMBER)
748: IS
749: lv_sql_stmt VARCHAR2(4000);
750: lv_error_text VARCHAR2(250);
751: lv_debug BOOLEAN := msc_cl_pre_process.v_debug;
752:
753: BEGIN
754:
755:

Line 1006: lv_debug BOOLEAN := msc_cl_pre_process.v_debug;

1002: p_batch_id IN NUMBER)
1003: IS
1004: lv_sql_stmt VARCHAR2(4000);
1005: lv_error_text VARCHAR2(250);
1006: lv_debug BOOLEAN := msc_cl_pre_process.v_debug;
1007: cursor c1 is select count(*) from MSD_HIERARCHY_LEVELS
1008: where LEVEL_ID = 11
1009: AND PARENT_LEVEL_ID = 15 ;
1010:

Line 1157: lv_debug BOOLEAN := msc_cl_pre_process.v_debug;

1153: IS
1154:
1155: lv_sql_stmt VARCHAR2(4000);
1156: lv_error_text VARCHAR2(250);
1157: lv_debug BOOLEAN := msc_cl_pre_process.v_debug;
1158:
1159: cursor c1 (p_instance_code varchar2) is
1160: select local_id from msd_local_id_setup
1161: where char1 = p_instance_code

Line 1390: lv_debug BOOLEAN := msc_cl_pre_process.v_debug;

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;
1393: lv_current_date DATE := msc_cl_pre_process.v_current_date;
1394: lv_return NUMBER := 0;

Line 1391: lv_batch_size NUMBER := msc_cl_pre_process.v_batch_size;

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;
1393: lv_current_date DATE := msc_cl_pre_process.v_current_date;
1394: lv_return NUMBER := 0;
1395: /* lv_master_org_id NUMBER := 0; */

Line 1392: lv_current_user NUMBER := msc_cl_pre_process.v_current_user;

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;
1393: lv_current_date DATE := msc_cl_pre_process.v_current_date;
1394: lv_return NUMBER := 0;
1395: /* lv_master_org_id NUMBER := 0; */
1396: lv_column_names VARCHAR2(5000);

Line 1393: lv_current_date DATE := msc_cl_pre_process.v_current_date;

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;
1393: lv_current_date DATE := msc_cl_pre_process.v_current_date;
1394: lv_return NUMBER := 0;
1395: /* lv_master_org_id NUMBER := 0; */
1396: lv_column_names VARCHAR2(5000);
1397: ex_logging_err EXCEPTION;

Line 1681: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

1677: RAISE ex_logging_err;
1678: END IF;
1679:
1680: --Call to customised validation.
1681: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
1682: (ERRBUF => lv_error_text,
1683: RETCODE => lv_return,
1684: pBatchID => lv_batch_id,
1685: pInstanceCode => p_instance_code,

Line 1824: lv_debug BOOLEAN := msc_cl_pre_process.v_debug;

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;
1827: lv_current_date DATE := msc_cl_pre_process.v_current_date;
1828: lv_return NUMBER := 0;

Line 1825: lv_batch_size NUMBER := msc_cl_pre_process.v_batch_size;

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;
1827: lv_current_date DATE := msc_cl_pre_process.v_current_date;
1828: lv_return NUMBER := 0;
1829: ex_logging_err EXCEPTION;

Line 1826: lv_current_user NUMBER := msc_cl_pre_process.v_current_user;

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;
1827: lv_current_date DATE := msc_cl_pre_process.v_current_date;
1828: lv_return NUMBER := 0;
1829: ex_logging_err EXCEPTION;
1830: lv_column_names VARCHAR2(5000);

Line 1827: lv_current_date DATE := msc_cl_pre_process.v_current_date;

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;
1827: lv_current_date DATE := msc_cl_pre_process.v_current_date;
1828: lv_return NUMBER := 0;
1829: ex_logging_err EXCEPTION;
1830: lv_column_names VARCHAR2(5000);
1831:

Line 2032: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

2028: p_instance_code ;
2029:
2030:
2031: --Call to customised validation.
2032: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
2033: (ERRBUF => lv_error_text,
2034: RETCODE => lv_return,
2035: pBatchID => null,
2036: pInstanceCode => p_instance_code,

Line 2112: lv_debug BOOLEAN := msc_cl_pre_process.v_debug;

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;
2114: lv_current_user NUMBER := msc_cl_pre_process.v_current_user;
2115: lv_current_date DATE := msc_cl_pre_process.v_current_date;
2116: lv_return NUMBER := 0;

Line 2113: lv_batch_size NUMBER := msc_cl_pre_process.v_batch_size;

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;
2114: lv_current_user NUMBER := msc_cl_pre_process.v_current_user;
2115: lv_current_date DATE := msc_cl_pre_process.v_current_date;
2116: lv_return NUMBER := 0;
2117: ex_logging_err EXCEPTION;

Line 2114: lv_current_user NUMBER := msc_cl_pre_process.v_current_user;

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;
2114: lv_current_user NUMBER := msc_cl_pre_process.v_current_user;
2115: lv_current_date DATE := msc_cl_pre_process.v_current_date;
2116: lv_return NUMBER := 0;
2117: ex_logging_err EXCEPTION;
2118: lv_column_names VARCHAR2(5000);

Line 2115: lv_current_date DATE := msc_cl_pre_process.v_current_date;

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;
2114: lv_current_user NUMBER := msc_cl_pre_process.v_current_user;
2115: lv_current_date DATE := msc_cl_pre_process.v_current_date;
2116: lv_return NUMBER := 0;
2117: ex_logging_err EXCEPTION;
2118: lv_column_names VARCHAR2(5000);
2119: /*

Line 2921: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

2917: USING lv_batch_id,
2918: p_instance_code ;
2919:
2920: --Call to customised validation.
2921: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
2922: (ERRBUF => lv_error_text,
2923: RETCODE => lv_return,
2924: pBatchID => null,
2925: pInstanceCode => p_instance_code,

Line 3001: lv_debug BOOLEAN := msc_cl_pre_process.v_debug;

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;
3003: lv_current_user NUMBER := msc_cl_pre_process.v_current_user;
3004: lv_current_date DATE := msc_cl_pre_process.v_current_date;
3005: lv_return NUMBER := 0;

Line 3002: lv_batch_size NUMBER := msc_cl_pre_process.v_batch_size;

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;
3003: lv_current_user NUMBER := msc_cl_pre_process.v_current_user;
3004: lv_current_date DATE := msc_cl_pre_process.v_current_date;
3005: lv_return NUMBER := 0;
3006: ex_logging_err EXCEPTION;

Line 3003: lv_current_user NUMBER := msc_cl_pre_process.v_current_user;

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;
3003: lv_current_user NUMBER := msc_cl_pre_process.v_current_user;
3004: lv_current_date DATE := msc_cl_pre_process.v_current_date;
3005: lv_return NUMBER := 0;
3006: ex_logging_err EXCEPTION;
3007: lv_column_names VARCHAR2(5000);

Line 3004: lv_current_date DATE := msc_cl_pre_process.v_current_date;

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;
3003: lv_current_user NUMBER := msc_cl_pre_process.v_current_user;
3004: lv_current_date DATE := msc_cl_pre_process.v_current_date;
3005: lv_return NUMBER := 0;
3006: ex_logging_err EXCEPTION;
3007: lv_column_names VARCHAR2(5000);
3008: /*

Line 3809: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

3805: p_instance_code ;
3806:
3807:
3808: --Call to customised validation.
3809: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
3810: (ERRBUF => lv_error_text,
3811: RETCODE => lv_return,
3812: pBatchID => lv_batch_id,
3813: pInstanceCode => p_instance_code,

Line 3889: lv_debug BOOLEAN := msc_cl_pre_process.v_debug;

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;
3892: lv_current_date DATE := msc_cl_pre_process.v_current_date;
3893: lv_return NUMBER := 0;

Line 3890: lv_batch_size NUMBER := msc_cl_pre_process.v_batch_size;

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;
3892: lv_current_date DATE := msc_cl_pre_process.v_current_date;
3893: lv_return NUMBER := 0;
3894: ex_logging_err EXCEPTION;

Line 3891: lv_current_user NUMBER := msc_cl_pre_process.v_current_user;

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;
3892: lv_current_date DATE := msc_cl_pre_process.v_current_date;
3893: lv_return NUMBER := 0;
3894: ex_logging_err EXCEPTION;
3895: lv_column_names VARCHAR2(5000);

Line 3892: lv_current_date DATE := msc_cl_pre_process.v_current_date;

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;
3892: lv_current_date DATE := msc_cl_pre_process.v_current_date;
3893: lv_return NUMBER := 0;
3894: ex_logging_err EXCEPTION;
3895: lv_column_names VARCHAR2(5000);
3896:

Line 4591: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

4587:
4588: END IF;
4589:
4590: --Call to customised validation.
4591: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
4592: (ERRBUF => lv_error_text,
4593: RETCODE => lv_return,
4594: pBatchID => lv_batch_id,
4595: pInstanceCode => p_instance_code,

Line 4665: lv_debug BOOLEAN := msc_cl_pre_process.v_debug;

4661: p_calendar_code IN VARCHAR)
4662: IS
4663: lv_sql_stmt VARCHAR2(4000);
4664: lv_error_text VARCHAR2(250);
4665: lv_debug BOOLEAN := msc_cl_pre_process.v_debug;
4666: lv_return NUMBER := 0;
4667: lv_cal_start_date DATE;
4668: lv_cal_end_date DATE;
4669:

Line 4812: lv_debug BOOLEAN := msc_cl_pre_process.v_debug;

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;
4813: lv_batch_size NUMBER := msc_cl_pre_process.v_batch_size;
4814: lv_current_user NUMBER := msc_cl_pre_process.v_current_user;
4815: lv_current_date DATE := msc_cl_pre_process.v_current_date;
4816: lv_return NUMBER := 0;

Line 4813: lv_batch_size NUMBER := msc_cl_pre_process.v_batch_size;

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;
4813: lv_batch_size NUMBER := msc_cl_pre_process.v_batch_size;
4814: lv_current_user NUMBER := msc_cl_pre_process.v_current_user;
4815: lv_current_date DATE := msc_cl_pre_process.v_current_date;
4816: lv_return NUMBER := 0;
4817: lv_calendar_code varchar2(15);

Line 4814: lv_current_user NUMBER := msc_cl_pre_process.v_current_user;

4810: lv_from_date DATE ;
4811: lv_to_date DATE ;
4812: lv_debug BOOLEAN := msc_cl_pre_process.v_debug;
4813: lv_batch_size NUMBER := msc_cl_pre_process.v_batch_size;
4814: lv_current_user NUMBER := msc_cl_pre_process.v_current_user;
4815: lv_current_date DATE := msc_cl_pre_process.v_current_date;
4816: lv_return NUMBER := 0;
4817: lv_calendar_code varchar2(15);
4818: lv_SEQ_NUM NUMBER;

Line 4815: lv_current_date DATE := msc_cl_pre_process.v_current_date;

4811: lv_to_date DATE ;
4812: lv_debug BOOLEAN := msc_cl_pre_process.v_debug;
4813: lv_batch_size NUMBER := msc_cl_pre_process.v_batch_size;
4814: lv_current_user NUMBER := msc_cl_pre_process.v_current_user;
4815: lv_current_date DATE := msc_cl_pre_process.v_current_date;
4816: lv_return NUMBER := 0;
4817: lv_calendar_code varchar2(15);
4818: lv_SEQ_NUM NUMBER;
4819: lv_YEAR VARCHAR2(15);

Line 5041: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

5037: USING lv_batch_id,
5038: p_instance_code;
5039:
5040: --Call to customised validation.
5041: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
5042: (ERRBUF => lv_error_text,
5043: RETCODE => lv_return,
5044: pBatchID => lv_batch_id,
5045: pInstanceCode => p_instance_code,

Line 5246: lv_debug BOOLEAN := msc_cl_pre_process.v_debug;

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;
5247: lv_batch_size NUMBER := msc_cl_pre_process.v_batch_size;
5248: lv_current_user NUMBER := msc_cl_pre_process.v_current_user;
5249: lv_current_date DATE := msc_cl_pre_process.v_current_date;
5250: lv_return NUMBER := 0;

Line 5247: lv_batch_size NUMBER := msc_cl_pre_process.v_batch_size;

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;
5247: lv_batch_size NUMBER := msc_cl_pre_process.v_batch_size;
5248: lv_current_user NUMBER := msc_cl_pre_process.v_current_user;
5249: lv_current_date DATE := msc_cl_pre_process.v_current_date;
5250: lv_return NUMBER := 0;
5251:

Line 5248: lv_current_user NUMBER := msc_cl_pre_process.v_current_user;

5244: lv_from_date DATE ;
5245: lv_to_date DATE ;
5246: lv_debug BOOLEAN := msc_cl_pre_process.v_debug;
5247: lv_batch_size NUMBER := msc_cl_pre_process.v_batch_size;
5248: lv_current_user NUMBER := msc_cl_pre_process.v_current_user;
5249: lv_current_date DATE := msc_cl_pre_process.v_current_date;
5250: lv_return NUMBER := 0;
5251:
5252: lv_calendar_code varchar2(15);

Line 5249: lv_current_date DATE := msc_cl_pre_process.v_current_date;

5245: lv_to_date DATE ;
5246: lv_debug BOOLEAN := msc_cl_pre_process.v_debug;
5247: lv_batch_size NUMBER := msc_cl_pre_process.v_batch_size;
5248: lv_current_user NUMBER := msc_cl_pre_process.v_current_user;
5249: lv_current_date DATE := msc_cl_pre_process.v_current_date;
5250: lv_return NUMBER := 0;
5251:
5252: lv_calendar_code varchar2(15);
5253: lv_SEQ_NUM NUMBER;

Line 5506: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

5502:
5503:
5504:
5505: --Call to customised validation.
5506: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
5507: (ERRBUF => lv_error_text,
5508: RETCODE => lv_return,
5509: pBatchID => lv_batch_id,
5510: pInstanceCode => p_instance_code,

Line 5724: lv_debug BOOLEAN := msc_cl_pre_process.v_debug;

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;
5727: lv_current_date DATE := msc_cl_pre_process.v_current_date;
5728: lv_return NUMBER := 0;

Line 5725: lv_batch_size NUMBER := msc_cl_pre_process.v_batch_size;

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;
5727: lv_current_date DATE := msc_cl_pre_process.v_current_date;
5728: lv_return NUMBER := 0;
5729: ex_logging_err EXCEPTION;

Line 5726: lv_current_user NUMBER := msc_cl_pre_process.v_current_user;

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;
5727: lv_current_date DATE := msc_cl_pre_process.v_current_date;
5728: lv_return NUMBER := 0;
5729: ex_logging_err EXCEPTION;
5730: lv_column_names VARCHAR2(5000);

Line 5727: lv_current_date DATE := msc_cl_pre_process.v_current_date;

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;
5727: lv_current_date DATE := msc_cl_pre_process.v_current_date;
5728: lv_return NUMBER := 0;
5729: ex_logging_err EXCEPTION;
5730: lv_column_names VARCHAR2(5000);
5731:

Line 5804: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

5800: USING lv_batch_id,
5801: p_instance_code;
5802:
5803: --Call to customised validation.
5804: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
5805: (ERRBUF => lv_error_text,
5806: RETCODE => lv_return,
5807: pBatchID => lv_batch_id,
5808: pInstanceCode => p_instance_code,

Line 5883: lv_debug BOOLEAN := msc_cl_pre_process.v_debug;

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;
5885: lv_current_user NUMBER := msc_cl_pre_process.v_current_user;
5886: lv_current_date DATE := msc_cl_pre_process.v_current_date;
5887: lv_return NUMBER := 0;

Line 5884: lv_batch_size NUMBER := msc_cl_pre_process.v_batch_size;

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;
5885: lv_current_user NUMBER := msc_cl_pre_process.v_current_user;
5886: lv_current_date DATE := msc_cl_pre_process.v_current_date;
5887: lv_return NUMBER := 0;
5888: ex_logging_err EXCEPTION;

Line 5885: lv_current_user NUMBER := msc_cl_pre_process.v_current_user;

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;
5885: lv_current_user NUMBER := msc_cl_pre_process.v_current_user;
5886: lv_current_date DATE := msc_cl_pre_process.v_current_date;
5887: lv_return NUMBER := 0;
5888: ex_logging_err EXCEPTION;
5889: lv_column_names VARCHAR2(5000);

Line 5886: lv_current_date DATE := msc_cl_pre_process.v_current_date;

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;
5885: lv_current_user NUMBER := msc_cl_pre_process.v_current_user;
5886: lv_current_date DATE := msc_cl_pre_process.v_current_date;
5887: lv_return NUMBER := 0;
5888: ex_logging_err EXCEPTION;
5889: lv_column_names VARCHAR2(5000);
5890:

Line 6708: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

6704:
6705: END IF;
6706:
6707: --Call to customised validation.
6708: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
6709: (ERRBUF => lv_error_text,
6710: RETCODE => lv_return,
6711: pBatchID => null,
6712: pInstanceCode => p_instance_code,

Line 6721: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

6717: RAISE ex_logging_err;
6718: END IF;
6719:
6720: --Call to customised validation.
6721: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
6722: (ERRBUF => lv_error_text,
6723: RETCODE => lv_return,
6724: pBatchID => lv_batch_id,
6725: pInstanceCode => p_instance_code,

Line 6801: lv_debug BOOLEAN := msc_cl_pre_process.v_debug;

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;
6803: lv_current_user NUMBER := msc_cl_pre_process.v_current_user;
6804: lv_current_date DATE := msc_cl_pre_process.v_current_date;
6805: lv_return NUMBER := 0;

Line 6802: lv_batch_size NUMBER := msc_cl_pre_process.v_batch_size;

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;
6803: lv_current_user NUMBER := msc_cl_pre_process.v_current_user;
6804: lv_current_date DATE := msc_cl_pre_process.v_current_date;
6805: lv_return NUMBER := 0;
6806: ex_logging_err EXCEPTION;

Line 6803: lv_current_user NUMBER := msc_cl_pre_process.v_current_user;

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;
6803: lv_current_user NUMBER := msc_cl_pre_process.v_current_user;
6804: lv_current_date DATE := msc_cl_pre_process.v_current_date;
6805: lv_return NUMBER := 0;
6806: ex_logging_err EXCEPTION;
6807: lv_column_names VARCHAR2(5000);

Line 6804: lv_current_date DATE := msc_cl_pre_process.v_current_date;

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;
6803: lv_current_user NUMBER := msc_cl_pre_process.v_current_user;
6804: lv_current_date DATE := msc_cl_pre_process.v_current_date;
6805: lv_return NUMBER := 0;
6806: ex_logging_err EXCEPTION;
6807: lv_column_names VARCHAR2(5000);
6808:

Line 7461: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

7457:
7458: END IF;
7459:
7460: --Call to customised validation.
7461: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
7462: (ERRBUF => lv_error_text,
7463: RETCODE => lv_return,
7464: pBatchID => null,
7465: pInstanceCode => p_instance_code,

Line 7540: lv_debug BOOLEAN := msc_cl_pre_process.v_debug;

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;
7543: lv_current_date DATE := msc_cl_pre_process.v_current_date;
7544: lv_return NUMBER := 0;

Line 7541: lv_batch_size NUMBER := msc_cl_pre_process.v_batch_size;

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;
7543: lv_current_date DATE := msc_cl_pre_process.v_current_date;
7544: lv_return NUMBER := 0;
7545: ex_logging_err EXCEPTION;

Line 7542: lv_current_user NUMBER := msc_cl_pre_process.v_current_user;

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;
7543: lv_current_date DATE := msc_cl_pre_process.v_current_date;
7544: lv_return NUMBER := 0;
7545: ex_logging_err EXCEPTION;
7546: lv_column_names VARCHAR2(5000);

Line 7543: lv_current_date DATE := msc_cl_pre_process.v_current_date;

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;
7543: lv_current_date DATE := msc_cl_pre_process.v_current_date;
7544: lv_return NUMBER := 0;
7545: ex_logging_err EXCEPTION;
7546: lv_column_names VARCHAR2(5000);
7547:

Line 7666: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

7662:
7663:
7664:
7665: --Call to customised validation.
7666: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
7667: (ERRBUF => lv_error_text,
7668: RETCODE => lv_return,
7669: pBatchID => lv_batch_id,
7670: pInstanceCode => p_instance_code,

Line 7743: lv_current_user NUMBER := msc_cl_pre_process.v_current_user;

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;
7745: lv_debug BOOLEAN := msc_cl_pre_process.v_debug;
7746: ex_logging_err EXCEPTION;
7747: lv_column_names VARCHAR2(5000);

Line 7744: lv_current_date DATE := msc_cl_pre_process.v_current_date;

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;
7745: lv_debug BOOLEAN := msc_cl_pre_process.v_debug;
7746: ex_logging_err EXCEPTION;
7747: lv_column_names VARCHAR2(5000);
7748:

Line 7745: lv_debug BOOLEAN := msc_cl_pre_process.v_debug;

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;
7745: lv_debug BOOLEAN := msc_cl_pre_process.v_debug;
7746: ex_logging_err EXCEPTION;
7747: lv_column_names VARCHAR2(5000);
7748:
7749:

Line 7916: lv_debug BOOLEAN := msc_cl_pre_process.v_debug;

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;
7920: lv_return NUMBER := 0;

Line 7917: lv_current_user NUMBER := msc_cl_pre_process.v_current_user;

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;
7920: lv_return NUMBER := 0;
7921: lv_error_text VARCHAR2(250);

Line 7918: lv_current_date DATE := msc_cl_pre_process.v_current_date;

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;
7920: lv_return NUMBER := 0;
7921: lv_error_text VARCHAR2(250);
7922: lv_instance_code VARCHAR2(3);

Line 7919: lv_batch_size NUMBER := msc_cl_pre_process.v_batch_size;

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;
7920: lv_return NUMBER := 0;
7921: lv_error_text VARCHAR2(250);
7922: lv_instance_code VARCHAR2(3);
7923:

Line 8124: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

8120: */
8121:
8122:
8123: --Call to customised validation.
8124: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
8125: (ERRBUF => lv_error_text,
8126: RETCODE => lv_return,
8127: pBatchID => lv_batch_id,
8128: pInstanceCode => p_instance_code,

Line 8197: lv_debug BOOLEAN := msc_cl_pre_process.v_debug;

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;
8201: lv_return NUMBER := 0;

Line 8198: lv_current_user NUMBER := msc_cl_pre_process.v_current_user;

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;
8201: lv_return NUMBER := 0;
8202: lv_error_text VARCHAR2(250);

Line 8199: lv_current_date DATE := msc_cl_pre_process.v_current_date;

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;
8201: lv_return NUMBER := 0;
8202: lv_error_text VARCHAR2(250);
8203: lv_instance_code VARCHAR2(3);

Line 8200: lv_batch_size NUMBER := msc_cl_pre_process.v_batch_size;

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;
8201: lv_return NUMBER := 0;
8202: lv_error_text VARCHAR2(250);
8203: lv_instance_code VARCHAR2(3);
8204:

Line 8428: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

8424: RAISE ex_logging_err;
8425: END IF;
8426:
8427: --Call to customised validation.
8428: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
8429: (ERRBUF => lv_error_text,
8430: RETCODE => lv_return,
8431: pBatchID => lv_batch_id,
8432: pInstanceCode => p_instance_code,

Line 8756: MSC_CL_PRE_PROCESS.LAUNCH_MONITOR(

8752:
8753:
8754: BEGIN
8755:
8756: MSC_CL_PRE_PROCESS.LAUNCH_MONITOR(
8757: ERRBUF => lv_errbuf,
8758: RETCODE => lv_retcode,
8759: p_instance_id => p_instance_id ,
8760: p_timeout => p_timeout ,