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;
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
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:
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:
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
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;
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; */
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);
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;
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,
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;
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;
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);
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:
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,
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;
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;
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);
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: /*
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,
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;
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;
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);
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: /*
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,
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;
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;
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);
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:
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,
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:
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;
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);
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;
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);
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,
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;
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:
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);
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;
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,
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;
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;
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);
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:
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,
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;
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;
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);
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:
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,
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,
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;
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;
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);
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:
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,
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;
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;
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);
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:
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,
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);
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:
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:
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;
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);
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);
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:
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,
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;
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);
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);
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:
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,
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 ,