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.MSC_CL_PRE_PROCESS dependencies on MSC_CL_PRE_PROCESS

Line 1: PACKAGE BODY MSC_CL_PRE_PROCESS AS -- body

1: PACKAGE BODY MSC_CL_PRE_PROCESS AS -- body
2: /* $Header: MSCCLPPB.pls 120.67.12020000.3 2012/11/27 05:47:31 neelredd ship $ */
3:
4: -- ========= Global Parameters ===========
5:

Line 287: LOG_MESSAGE('MSC_CL_PRE_PROCESS.SEND_ERROR ('||lv_pointer||'): '||SQLERRM);

283: END LOOP;
284:
285: EXCEPTION
286: when others then
287: LOG_MESSAGE('MSC_CL_PRE_PROCESS.SEND_ERROR ('||lv_pointer||'): '||SQLERRM);
288: END;
289: */
290:
291: -- WRITE_ERROR_SUMM_LOG ===========

Line 467: lv_error_text := substr('MSC_CL_PRE_PROCESS.LAUNCH_DP_PULL'||SQLERRM,1,240);

463:
464: EXCEPTION
465:
466: WHEN OTHERS THEN
467: lv_error_text := substr('MSC_CL_PRE_PROCESS.LAUNCH_DP_PULL'||SQLERRM,1,240);
468: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
469: RETCODE := G_WARNING;
470: ERRBUF := lv_error_text;
471:

Line 505: lv_error_text := substr('MSC_CL_PRE_PROCESS.LAUNCH_DELETE_DUPLICATES'||SQLERRM,1,240);

501:
502: EXCEPTION
503:
504: WHEN OTHERS THEN
505: lv_error_text := substr('MSC_CL_PRE_PROCESS.LAUNCH_DELETE_DUPLICATES'||SQLERRM,1,240);
506: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
507: RETCODE := G_WARNING;
508: ERRBUF := lv_error_text;
509:

Line 3392: lv_error_text := substr('MSC_CL_PRE_PROCESS.MODEL_ORG_SUPPLIER_CUSTOMER'||'('

3388: commit;
3389:
3390: EXCEPTION
3391: WHEN OTHERS THEN
3392: lv_error_text := substr('MSC_CL_PRE_PROCESS.MODEL_ORG_SUPPLIER_CUSTOMER'||'('
3393: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
3394: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
3395: ROLLBACK;
3396:

Line 3625: p_error_text := substr('MSC_CL_PRE_PROCESS.PROPAGATE_CAL_ERROR'

3621:
3622: RETURN(lv_status);
3623: EXCEPTION
3624: WHEN OTHERS THEN
3625: p_error_text := substr('MSC_CL_PRE_PROCESS.PROPAGATE_CAL_ERROR'
3626: ||'('||v_sql_stmt||')'|| SQLERRM, 1, 240);
3627: return(SQLCODE);
3628:
3629: END PROPAGATE_CAL_ERROR;

Line 3797: p_error_text := substr('MSC_CL_PRE_PROCESS.DERIVE_SHIFT_DETAILS'

3793: v_instance_code;
3794: RETURN(0);
3795: EXCEPTION
3796: WHEN OTHERS THEN
3797: p_error_text := substr('MSC_CL_PRE_PROCESS.DERIVE_SHIFT_DETAILS'
3798: ||'('||v_sql_stmt||')'|| SQLERRM, 1, 240);
3799: return(SQLCODE);
3800:
3801: END derive_shift_details;

Line 4263: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

4259: RAISE ex_critical_err;
4260: END IF;
4261:
4262: --Call to customised validation.
4263: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
4264: (ERRBUF => lv_error_text,
4265: RETCODE => lv_return,
4266: pBatchID => null,
4267: pInstanceCode => v_instance_code,

Line 4407: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

4403: END IF;
4404: END IF;
4405:
4406: --Call to customised validation.
4407: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
4408: (ERRBUF => lv_error_text,
4409: RETCODE => lv_return,
4410: pBatchID => null,
4411: pInstanceCode => v_instance_code,

Line 4649: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

4645: RAISE ex_critical_err;
4646: END;
4647:
4648: --Call to customised validation.
4649: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
4650: (ERRBUF => lv_error_text,
4651: RETCODE => lv_return,
4652: pBatchID => null,
4653: pInstanceCode => v_instance_code,

Line 4886: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

4882: END IF;
4883: END IF;
4884:
4885: --Call to customised validation.
4886: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
4887: (ERRBUF => lv_error_text,
4888: RETCODE => lv_return,
4889: pBatchID => null,
4890: pInstanceCode => v_instance_code,

Line 5142: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

5138: END IF;
5139: END IF;
5140:
5141: --Call to customised validation.
5142: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
5143: (ERRBUF => lv_error_text,
5144: RETCODE => lv_return,
5145: pBatchID => null,
5146: pInstanceCode => v_instance_code,

Line 5674: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_CALENDAR'||'('

5670: END IF;
5671:
5672: EXCEPTION
5673: WHEN too_many_rows THEN
5674: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_CALENDAR'||'('
5675: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
5676: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
5677: ROLLBACK;
5678:

Line 5700: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_CALENDAR'||'('

5696: COMMIT;
5697: END IF;
5698:
5699: WHEN OTHERS THEN
5700: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_CALENDAR'||'('
5701: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
5702: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
5703:
5704: ROLLBACK;

Line 5710: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_CALENDAR'||'('

5706:
5707: END LOOP;
5708: EXCEPTION
5709: WHEN OTHERS THEN
5710: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_CALENDAR'||'('
5711: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
5712: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
5713:
5714: ROLLBACK;

Line 6074: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

6070: v_instance_code;
6071:
6072:
6073: --Call to customised validation.
6074: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
6075: (ERRBUF => lv_error_text,
6076: RETCODE => lv_return,
6077: pBatchID => lv_batch_id,
6078: pInstanceCode => v_instance_code,

Line 6175: ||' MSC_CL_PRE_PROCESS.v_flag := '||SYS_YES||';'

6171: ||' p_instance_code => :v_instance_code, '
6172: ||' p_instance_id => :v_instance_id,'
6173: ||' p_batch_id => :lv_batch_id);'
6174: ||' IF ( retcode = '||G_WARNING||') THEN'
6175: ||' MSC_CL_PRE_PROCESS.v_flag := '||SYS_YES||';'
6176: ||' END IF;'
6177: ||' END ;';
6178:
6179:

Line 6202: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_DEMAND_CLASS '||'('

6198:
6199: ROLLBACK;
6200:
6201: WHEN OTHERS THEN
6202: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_DEMAND_CLASS '||'('
6203: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
6204: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
6205:
6206: ROLLBACK;

Line 7486: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

7482: RAISE ex_logging_err;
7483: END IF;
7484:
7485: --Call to customised validation.
7486: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
7487: (ERRBUF => lv_error_text,
7488: RETCODE => lv_return,
7489: pBatchID => lv_batch_id,
7490: pInstanceCode => v_instance_code,

Line 8229: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

8225:
8226: END IF ; -- v_install_msc
8227:
8228: --Call to customised validation.
8229: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
8230: (ERRBUF => lv_error_text,
8231: RETCODE => lv_return,
8232: pBatchID => lv_batch_id,
8233: pInstanceCode => v_instance_code,

Line 8841: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

8837: RAISE ex_logging_err;
8838: END IF;
8839:
8840: --Call to customised validation.
8841: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
8842: (ERRBUF => lv_error_text,
8843: RETCODE => lv_return,
8844: pBatchID => lv_batch_id,
8845: pInstanceCode => v_instance_code,

Line 9354: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

9350:
9351:
9352:
9353: --Call to customised validation.
9354: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
9355: (ERRBUF => lv_error_text,
9356: RETCODE => lv_return,
9357: pBatchID => lv_batch_id,
9358: pInstanceCode => v_instance_code,

Line 9852: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

9848: RAISE ex_logging_err;
9849: END IF;
9850:
9851: --Call to customised validation.
9852: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
9853: (ERRBUF => lv_error_text,
9854: RETCODE => lv_return,
9855: pBatchID => lv_batch_id,
9856: pInstanceCode => v_instance_code,

Line 10326: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

10322: END IF;
10323:
10324: --Call to customised validation.
10325:
10326: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
10327: (ERRBUF => lv_error_text,
10328: RETCODE => lv_return,
10329: pBatchID => lv_batch_id,
10330: pInstanceCode => v_instance_code,

Line 11029: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

11025: lv_batch_id;
11026:
11027: --Call to customised validation.
11028:
11029: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
11030: (ERRBUF => lv_error_text,
11031: RETCODE => lv_return,
11032: pBatchID => lv_batch_id,
11033: pInstanceCode => v_instance_code,

Line 11211: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_TRADING_PARTNERS '||'('

11207: MODEL_ORG_SUPPLIER_CUSTOMER;
11208:
11209: EXCEPTION
11210: WHEN too_many_rows THEN
11211: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_TRADING_PARTNERS '||'('
11212: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
11213: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
11214:
11215: ROLLBACK;

Line 11223: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_TRADING_PARTNERS '||'('

11219:
11220: ROLLBACK;
11221:
11222: WHEN OTHERS THEN
11223: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_TRADING_PARTNERS '||'('
11224: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
11225: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
11226:
11227: ROLLBACK;

Line 12005: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

12001: RAISE ex_logging_err;
12002: END IF;
12003:
12004: --Call to customised validation.
12005: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
12006: (ERRBUF => lv_error_text,
12007: RETCODE => lv_return,
12008: pBatchID => lv_batch_id,
12009: pInstanceCode => v_instance_code,

Line 12049: lv_error_text := substr('MSC_CL_PRE_PROCESS.MSC_ST_CALENDAR_ASSIGNMENTS'||'('

12045:
12046: EXCEPTION
12047:
12048: WHEN too_many_rows THEN
12049: lv_error_text := substr('MSC_CL_PRE_PROCESS.MSC_ST_CALENDAR_ASSIGNMENTS'||'('
12050: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
12051: ROLLBACK ;
12052:
12053: WHEN ex_logging_err THEN

Line 12058: lv_error_text := substr('MSC_CL_PRE_PROCESS.MSC_ST_CALENDAR_ASSIGNMENTS '||'('

12054: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
12055: ROLLBACK;
12056:
12057: WHEN OTHERS THEN
12058: lv_error_text := substr('MSC_CL_PRE_PROCESS.MSC_ST_CALENDAR_ASSIGNMENTS '||'('
12059: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
12060: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
12061: ROLLBACK;
12062:

Line 12320: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

12316: EXECUTE IMMEDIATE lv_sql_stmt
12317: USING v_instance_code;
12318:
12319: --Call to customised validation.
12320: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
12321: (ERRBUF => lv_error_text,
12322: RETCODE => lv_return,
12323: pBatchID => NULL,
12324: pInstanceCode => v_instance_code,

Line 12370: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_SALES_CHANNEL '||'('

12366: -- G_WARNING_FLAG := 1;
12367: ROLLBACK;
12368:
12369: WHEN OTHERS THEN
12370: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_SALES_CHANNEL '||'('
12371: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
12372: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_error_text);
12373: -- G_WARNING_FLAG := 1;
12374: ROLLBACK;

Line 12386: lv_debug BOOLEAN := msc_cl_pre_process.v_debug;

12382: lb_rowid RowidTab;
12383: lv_sql_stmt VARCHAR2(4000);
12384: lv_message_text msc_errors.error_text%TYPE;
12385: lv_error_text VARCHAR2(250);
12386: lv_debug BOOLEAN := msc_cl_pre_process.v_debug;
12387: lv_current_user NUMBER := msc_cl_pre_process.v_current_user;
12388: lv_current_date DATE := msc_cl_pre_process.v_current_date;
12389: lv_return NUMBER := 0;
12390: lv_instance_code VARCHAR2(3);

Line 12387: lv_current_user NUMBER := msc_cl_pre_process.v_current_user;

12383: lv_sql_stmt VARCHAR2(4000);
12384: lv_message_text msc_errors.error_text%TYPE;
12385: lv_error_text VARCHAR2(250);
12386: lv_debug BOOLEAN := msc_cl_pre_process.v_debug;
12387: lv_current_user NUMBER := msc_cl_pre_process.v_current_user;
12388: lv_current_date DATE := msc_cl_pre_process.v_current_date;
12389: lv_return NUMBER := 0;
12390: lv_instance_code VARCHAR2(3);
12391:

Line 12388: lv_current_date DATE := msc_cl_pre_process.v_current_date;

12384: lv_message_text msc_errors.error_text%TYPE;
12385: lv_error_text VARCHAR2(250);
12386: lv_debug BOOLEAN := msc_cl_pre_process.v_debug;
12387: lv_current_user NUMBER := msc_cl_pre_process.v_current_user;
12388: lv_current_date DATE := msc_cl_pre_process.v_current_date;
12389: lv_return NUMBER := 0;
12390: lv_instance_code VARCHAR2(3);
12391:
12392: ex_logging_err EXCEPTION;

Line 12525: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

12521: EXECUTE IMMEDIATE lv_sql_stmt
12522: USING v_instance_code;
12523:
12524: --Call to customised validation.
12525: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
12526: (ERRBUF => lv_error_text,
12527: RETCODE => lv_return,
12528: pBatchID => NULL,
12529: pInstanceCode => v_instance_code,

Line 12573: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_FISCAL_CALENDAR '||'('

12569:
12570: WHEN OTHERS THEN
12571: ROLLBACK;
12572:
12573: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_FISCAL_CALENDAR '||'('
12574: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
12575: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_error_text);
12576: -- G_WARNING_FLAG := 1;
12577: ROLLBACK;

Line 12950: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

12946: EXECUTE IMMEDIATE lv_sql_stmt USING v_instance_code,lv_batch_id;
12947:
12948:
12949: --Call to customised validation.
12950: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
12951: (ERRBUF => lv_error_text,
12952: RETCODE => lv_return,
12953: pBatchID => NULL,
12954: pInstanceCode => v_instance_code,

Line 12998: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_VISITS '||'('

12994: -- G_WARNING_FLAG := 1;
12995: ROLLBACK;
12996:
12997: WHEN OTHERS THEN
12998: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_VISITS '||'('
12999: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
13000: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_error_text);
13001: -- G_WARNING_FLAG := 1;
13002: ROLLBACK;

Line 13294: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

13290: USING lv_batch_id,v_instance_code;
13291:
13292:
13293: --Call to customised validation.
13294: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
13295: (ERRBUF => lv_error_text,
13296: RETCODE => lv_return,
13297: pBatchID => NULL,
13298: pInstanceCode => v_instance_code,

Line 13342: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_MILESTONES '||'('

13338: -- G_WARNING_FLAG := 1;
13339: ROLLBACK;
13340:
13341: WHEN OTHERS THEN
13342: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_MILESTONES '||'('
13343: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
13344: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_error_text);
13345: -- G_WARNING_FLAG := 1;
13346: ROLLBACK;

Line 13531: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

13527: RAISE ex_logging_err;
13528: end if;
13529:
13530: --Call to customised validation.
13531: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
13532: (ERRBUF => lv_error_text,
13533: RETCODE => lv_return,
13534: pBatchID => NULL,
13535: pInstanceCode => v_instance_code,

Line 13579: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_WBS '||'('

13575: -- G_WARNING_FLAG := 1;
13576: ROLLBACK;
13577:
13578: WHEN OTHERS THEN
13579: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_WBS '||'('
13580: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
13581: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_error_text);
13582: -- G_WARNING_FLAG := 1;
13583: ROLLBACK;

Line 14145: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

14141:
14142:
14143:
14144: --Call to customised validation.
14145: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
14146: (ERRBUF => lv_error_text,
14147: RETCODE => lv_return,
14148: pBatchID => NULL,
14149: pInstanceCode => v_instance_code,

Line 14193: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_WOATTRIBUTES '||'('

14189: -- G_WARNING_FLAG := 1;
14190: ROLLBACK;
14191:
14192: WHEN OTHERS THEN
14193: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_WOATTRIBUTES '||'('
14194: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
14195: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_error_text);
14196: -- G_WARNING_FLAG := 1;
14197: ROLLBACK;

Line 14706: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

14702: RAISE ex_logging_err;
14703: end if;
14704:
14705: --Call to customised validation.
14706: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
14707: (ERRBUF => lv_error_text,
14708: RETCODE => lv_return,
14709: pBatchID => NULL,
14710: pInstanceCode => v_instance_code,

Line 14754: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_WO_TASK_HIERARCHY '||'('

14750: -- G_WARNING_FLAG := 1;
14751: ROLLBACK;
14752:
14753: WHEN OTHERS THEN
14754: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_WO_TASK_HIERARCHY '||'('
14755: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
14756: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_error_text);
14757: -- G_WARNING_FLAG := 1;
14758: ROLLBACK;

Line 15371: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

15367: EXECUTE IMMEDIATE lv_sql_stmt
15368: USING v_instance_id,lv_batch_id,v_instance_code;
15369:
15370: --Call to customised validation.
15371: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
15372: (ERRBUF => lv_error_text,
15373: RETCODE => lv_return,
15374: pBatchID => NULL,
15375: pInstanceCode => v_instance_code,

Line 15419: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_WO_OPERATION_REL '||'('

15415: -- G_WARNING_FLAG := 1;
15416: ROLLBACK;
15417:
15418: WHEN OTHERS THEN
15419: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_WO_OPERATION_REL '||'('
15420: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
15421: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_error_text);
15422: -- G_WARNING_FLAG := 1;
15423: ROLLBACK;

Line 15849: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

15845: USING lv_batch_id,
15846: v_instance_code;
15847:
15848: --Call to customised validation.
15849: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
15850: (ERRBUF => lv_error_text,
15851: RETCODE => lv_return,
15852: pBatchID => lv_batch_id,
15853: pInstanceCode => v_instance_code,

Line 15960: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_PLANNERS'||

15956: end if;
15957:
15958: EXCEPTION
15959: WHEN OTHERS THEN
15960: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_PLANNERS'||
15961: 'Error in Inserting or Updating into MSC_PLANNERS'|| SQLERRM, 1, 240);
15962: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
15963: ROLLBACK;
15964: END;

Line 15996: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_PLANNERS'||'('

15992: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
15993: ROLLBACK;
15994:
15995: WHEN OTHERS THEN
15996: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_PLANNERS'||'('
15997: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
15998: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
15999: ROLLBACK;
16000:

Line 16885: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

16881: end if;
16882:
16883:
16884: --Call to customised validation.
16885: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
16886: (ERRBUF => lv_error_text,
16887: RETCODE => lv_return,
16888: pBatchID => lv_batch_id,
16889: pInstanceCode => v_instance_code,

Line 16942: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_SHIP_METHODS'||'('

16938: END LOOP;
16939:
16940: EXCEPTION
16941: WHEN too_many_rows THEN
16942: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_SHIP_METHODS'||'('
16943: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
16944: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
16945: ROLLBACK;
16946:

Line 16952: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_SHIP_METHODS'||'('

16948: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
16949: ROLLBACK;
16950:
16951: WHEN OTHERS THEN
16952: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_SHIP_METHODS'||'('
16953: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
16954: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
16955: ROLLBACK;
16956:

Line 17479: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

17475: v_instance_id;
17476:
17477:
17478: --Call to customised validation.
17479: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
17480: (ERRBUF => lv_error_text,
17481: RETCODE => lv_return,
17482: pBatchID => lv_batch_id,
17483: pInstanceCode => v_instance_code,

Line 18122: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

18118: v_instance_code;
18119:
18120:
18121: --Call to customised validation.
18122: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
18123: (ERRBUF => lv_error_text,
18124: RETCODE => lv_return,
18125: pBatchID => lv_batch_id,
18126: pInstanceCode => v_instance_code,

Line 18618: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

18614: v_instance_code,
18615: v_instance_id;
18616:
18617: --Call to customised validation.
18618: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
18619: (ERRBUF => lv_error_text,
18620: RETCODE => lv_return,
18621: pBatchID => lv_batch_id,
18622: pInstanceCode => v_instance_code,

Line 19103: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

19099: v_instance_id,
19100: v_instance_id;
19101:
19102: --Call to customised validation.
19103: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
19104: (ERRBUF => lv_error_text,
19105: RETCODE => lv_return,
19106: pBatchID => lv_batch_id,
19107: pInstanceCode => v_instance_code,

Line 19188: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_REGIONS'||'('

19184: END LOOP;
19185:
19186: EXCEPTION
19187: WHEN too_many_rows THEN
19188: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_REGIONS'||'('
19189: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
19190: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
19191: ROLLBACK;
19192:

Line 19198: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_REGIONS'||'('

19194: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
19195: ROLLBACK;
19196:
19197: WHEN OTHERS THEN
19198: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_REGIONS'||'('
19199: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
19200: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
19201: ROLLBACK;
19202:

Line 19555: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

19551: USING lv_batch_id,
19552: v_instance_code;
19553:
19554: --Call to customised validation.
19555: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
19556: (ERRBUF => lv_error_text,
19557: RETCODE => lv_return,
19558: pBatchID => lv_batch_id,
19559: pInstanceCode => v_instance_code,

Line 19643: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_CATEGORY_SET'||'('

19639: END LOOP;
19640:
19641: EXCEPTION
19642: WHEN too_many_rows THEN
19643: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_CATEGORY_SET'||'('
19644: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
19645: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
19646: ROLLBACK;
19647:

Line 19653: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_CATEGORY_SET'||'('

19649: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
19650: ROLLBACK;
19651:
19652: WHEN OTHERS THEN
19653: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_CATEGORY_SET'||'('
19654: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
19655: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
19656: ROLLBACK;
19657:

Line 20013: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

20009: RAISE ex_logging_err;
20010: END IF;
20011:
20012: --Call to customised validation.
20013: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
20014: (ERRBUF => lv_error_text,
20015: RETCODE => lv_return,
20016: pBatchID => lv_batch_id,
20017: pInstanceCode => v_instance_code,

Line 20060: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_UOM'||'('

20056: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
20057: ROLLBACK;
20058:
20059: WHEN OTHERS THEN
20060: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_UOM'||'('
20061: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
20062: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
20063: ROLLBACK;
20064:

Line 20706: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

20702: lv_batch_id;
20703:
20704:
20705: --Call to customised validation.
20706: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
20707: (ERRBUF => lv_error_text,
20708: RETCODE => lv_return,
20709: pBatchID => lv_batch_id,
20710: pInstanceCode => v_instance_code,

Line 21249: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

21245: USING lv_batch_id,
21246: v_instance_code;
21247:
21248: --Call to customised validation.
21249: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
21250: (ERRBUF => lv_error_text,
21251: RETCODE => lv_return,
21252: pBatchID => lv_batch_id,
21253: pInstanceCode => v_instance_code,

Line 21297: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_UOM_CLASS_CONV'||'('

21293: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
21294: ROLLBACK;
21295:
21296: WHEN OTHERS THEN
21297: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_UOM_CLASS_CONV'||'('
21298: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
21299: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
21300: ROLLBACK;
21301:

Line 21836: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

21832: RAISE ex_logging_err;
21833: END IF;
21834:
21835: --Call to customised validation.
21836: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
21837: (ERRBUF => lv_error_text,
21838: RETCODE => lv_return,
21839: pBatchID => lv_batch_id,
21840: pInstanceCode => v_instance_code,

Line 22025: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_DESIGNATOR'||'('

22021: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
22022: ROLLBACK;
22023:
22024: WHEN OTHERS THEN
22025: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_DESIGNATOR'||'('
22026: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
22027: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
22028: ROLLBACK;
22029:

Line 22225: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_ITEM'||'(' ||v_sql_stmt||')'|| SQLERRM, 1, 240);

22221: OPEN c_lock(p_batch_id) ;
22222: EXIT;
22223: EXCEPTION
22224: WHEN busy THEN
22225: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_ITEM'||'(' ||v_sql_stmt||')'|| SQLERRM, 1, 240);
22226: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
22227: dbms_lock.sleep(5);
22228: WHEN OTHERS THEN
22229: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_ITEM'||'(' ||v_sql_stmt||')'|| SQLERRM, 1, 240);

Line 22229: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_ITEM'||'(' ||v_sql_stmt||')'|| SQLERRM, 1, 240);

22225: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_ITEM'||'(' ||v_sql_stmt||')'|| SQLERRM, 1, 240);
22226: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
22227: dbms_lock.sleep(5);
22228: WHEN OTHERS THEN
22229: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_ITEM'||'(' ||v_sql_stmt||')'|| SQLERRM, 1, 240);
22230: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
22231:
22232: v_sql_stmt := 02;
22233: lv_sql_stmt :=

Line 22258: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_ITEM'||'(' ||v_sql_stmt||')'|| SQLERRM, 1, 240);

22254: OPEN c_lock_abc(p_batch_id) ;
22255: EXIT;
22256: EXCEPTION
22257: WHEN busy THEN
22258: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_ITEM'||'(' ||v_sql_stmt||')'|| SQLERRM, 1, 240);
22259: msc_st_util.log_message(lv_error_text);
22260: dbms_lock.sleep(5);
22261: WHEN OTHERS THEN
22262: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_ITEM'||'(' ||v_sql_stmt||')'|| SQLERRM, 1, 240);

Line 22262: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_ITEM'||'(' ||v_sql_stmt||')'|| SQLERRM, 1, 240);

22258: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_ITEM'||'(' ||v_sql_stmt||')'|| SQLERRM, 1, 240);
22259: msc_st_util.log_message(lv_error_text);
22260: dbms_lock.sleep(5);
22261: WHEN OTHERS THEN
22262: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_ITEM'||'(' ||v_sql_stmt||')'|| SQLERRM, 1, 240);
22263: msc_st_util.log_message(lv_error_text);
22264:
22265: v_sql_stmt := 03;
22266: lv_sql_stmt :=

Line 22820: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

22816: END IF ; --v_install_msc
22817:
22818: --Call to customised validation.
22819:
22820: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
22821: (ERRBUF => lv_error_text,
22822: RETCODE => lv_return,
22823: pBatchID => lv_batch_id,
22824: pInstanceCode => v_instance_code,

Line 24227: ||' MSC_CL_PRE_PROCESS.v_flag := '||SYS_YES||';'

24223: ||' RETCODE => retcode ,'
24224: ||' p_instance_id => :v_instance_id,'
24225: ||' p_batch_id => :lv_batch_id);'
24226: ||' IF ( retcode = '||G_WARNING||') THEN'
24227: ||' MSC_CL_PRE_PROCESS.v_flag := '||SYS_YES||';'
24228: ||' END IF;'
24229: ||' END ;';
24230:
24231: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

Line 24241: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_ITEMS'||'('

24237:
24238:
24239: EXCEPTION
24240: WHEN too_many_rows THEN
24241: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_ITEMS'||'('
24242: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
24243: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
24244: ROLLBACK;
24245: IF c_lock%ISOPEN THEN

Line 24255: lv_error_text :=substr('MSC_CL_PRE_PROCESS.LOAD_ITEMS'||'('

24251: IF c_lock%ISOPEN THEN
24252: CLOSE c_lock;
24253: END IF;
24254: WHEN OTHERS THEN
24255: lv_error_text :=substr('MSC_CL_PRE_PROCESS.LOAD_ITEMS'||'('
24256: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
24257: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
24258: ROLLBACK;
24259: IF c_lock%ISOPEN THEN

Line 24809: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

24805: v_instance_code;
24806:
24807:
24808: --Call to customised validation.
24809: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
24810: (ERRBUF => lv_error_text,
24811: RETCODE => lv_return,
24812: pBatchID => lv_batch_id,
24813: pInstanceCode => v_instance_code,

Line 24919: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_ITEM_SUBSTITUTES'||'('

24915:
24916: EXCEPTION
24917:
24918: WHEN too_many_rows THEN
24919: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_ITEM_SUBSTITUTES'||'('
24920: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
24921: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
24922: ROLLBACK;
24923:

Line 24929: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_ITEM_SUBSTITUTES'||'('

24925: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
24926: ROLLBACK;
24927:
24928: WHEN OTHERS THEN
24929: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_ITEM_SUBSTITUTES'||'('
24930: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
24931: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
24932: ROLLBACK;
24933:

Line 25525: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

25521:
25522:
25523:
25524: --Call to customised validation.
25525: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
25526: (ERRBUF => lv_error_text,
25527: RETCODE => lv_return,
25528: pBatchID => lv_batch_id,
25529: pInstanceCode => v_instance_code,

Line 26051: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

26047: v_instance_code;
26048:
26049:
26050: --Call to customised validation.
26051: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
26052: (ERRBUF => lv_error_text,
26053: RETCODE => lv_return,
26054: pBatchID => lv_batch_id,
26055: pInstanceCode => v_instance_code,

Line 26530: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

26526: USING lv_batch_id,
26527: v_instance_code;
26528:
26529: --Call to customised validation.
26530: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
26531: (ERRBUF => lv_error_text,
26532: RETCODE => lv_return,
26533: pBatchID => lv_batch_id,
26534: pInstanceCode => v_instance_code,

Line 26576: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_SUPP_CAPACITY'||'('

26572: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
26573: ROLLBACK;
26574:
26575: WHEN OTHERS THEN
26576: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_SUPP_CAPACITY'||'('
26577: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
26578: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
26579: ROLLBACK;
26580:

Line 26968: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

26964: RAISE ex_logging_err;
26965: END IF;
26966:
26967: --Call to customised validation.
26968: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
26969: (ERRBUF => lv_error_text,
26970: RETCODE => lv_return,
26971: pBatchID => lv_batch_id,
26972: pInstanceCode => v_instance_code,

Line 27012: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_SAFETY_STOCKS'||'('

27008: END LOOP;
27009:
27010: EXCEPTION
27011: WHEN too_many_rows THEN
27012: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_SAFETY_STOCKS'||'('
27013: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
27014: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
27015: ROLLBACK;
27016:

Line 27022: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_SAFETY_STOCKS'||'('

27018: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
27019: ROLLBACK;
27020:
27021: WHEN OTHERS THEN
27022: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_SAFETY_STOCKS'||'('
27023: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
27024: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
27025: ROLLBACK;
27026:

Line 27441: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

27437: USING v_instance_code,
27438: lv_batch_id;
27439:
27440: --Call to customised validation.
27441: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
27442: (ERRBUF => lv_error_text,
27443: RETCODE => lv_return,
27444: pBatchID => lv_batch_id,
27445: pInstanceCode => v_instance_code,

Line 27584: ||' MSC_CL_PRE_PROCESS.v_flag := '||SYS_YES||';'

27580: ||' p_instance_id => :v_instance_id,'
27581: ||' p_batch_id => :lv_batch_id ,'
27582: ||' p_link => :p_item_rollup);'
27583: ||' IF ( retcode = '||G_WARNING||') THEN'
27584: ||' MSC_CL_PRE_PROCESS.v_flag := '||SYS_YES||';'
27585: ||' END IF;'
27586: ||' END ;';
27587:
27588: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

Line 27602: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_CATEGORY'||'('

27598: END LOOP;
27599:
27600: EXCEPTION
27601: WHEN too_many_rows THEN
27602: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_CATEGORY'||'('
27603: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
27604: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
27605: ROLLBACK;
27606:

Line 27612: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_CATEGORY'||'('

27608: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
27609: ROLLBACK;
27610:
27611: WHEN OTHERS THEN
27612: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_CATEGORY'||'('
27613: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
27614: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
27615: ROLLBACK;
27616:

Line 27897: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_SOURCING_RULE'||'('

27893: IF lv_return <> 0 THEN
27894: RAISE ex_logging_err;
27895: END IF;
27896: WHEN OTHERS THEN
27897: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_SOURCING_RULE'||'('
27898: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
27899: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
27900:
27901: END ;

Line 27903: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_CATEGORY'||'('

27899: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
27900:
27901: END ;
27902: WHEN OTHERS THEN
27903: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_CATEGORY'||'('
27904: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
27905: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
27906:
27907: END;

Line 28807: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

28803: EXECUTE IMMEDIATE lv_sql_stmt USING v_instance_code,lv_batch_id;
28804:
28805: --Call to customised validation.
28806:
28807: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
28808: (ERRBUF => lv_error_text,
28809: RETCODE => lv_return,
28810: pBatchID => lv_batch_id,
28811: pInstanceCode => v_instance_code,

Line 29609: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_SOURCING_RULES'||'('

29605:
29606:
29607: EXCEPTION
29608: WHEN too_many_rows THEN
29609: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_SOURCING_RULES'||'('
29610: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
29611: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
29612: ROLLBACK ;
29613:

Line 29619: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_SOURCING_RULE'||'('

29615: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
29616: ROLLBACK;
29617:
29618: WHEN OTHERS THEN
29619: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_SOURCING_RULE'||'('
29620: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
29621: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
29622: ROLLBACK;
29623:

Line 30082: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

30078:
30079: EXECUTE IMMEDIATE lv_sql_stmt USING v_instance_code,lv_batch_id;
30080:
30081: --Call to customised validation.
30082: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
30083: (ERRBUF => lv_error_text,
30084: RETCODE => lv_return,
30085: pBatchID => lv_batch_id,
30086: pInstanceCode => v_instance_code,

Line 30435: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_PROJ_TASK'||'('

30431: END LOOP;
30432:
30433: EXCEPTION
30434: WHEN too_many_rows THEN
30435: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_PROJ_TASK'||'('
30436: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
30437: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
30438: ROLLBACK ;
30439:

Line 30445: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_PROJ_TASK'||'('

30441: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
30442: ROLLBACK;
30443:
30444: WHEN OTHERS THEN
30445: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_PROJ_TASK'||'('
30446: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
30447: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
30448: ROLLBACK;
30449:

Line 30840: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

30836: RAISE ex_logging_err;
30837: END IF;
30838:
30839: --Call to customised validation.
30840: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
30841: (ERRBUF => lv_error_text,
30842: RETCODE => lv_return,
30843: pBatchID => lv_batch_id,
30844: pInstanceCode => v_instance_code,

Line 31663: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

31659: EXECUTE IMMEDIATE lv_sql_stmt USING v_instance_code,lv_batch_id;
31660:
31661: --Call to customised validation.
31662:
31663: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
31664: (ERRBUF => lv_error_text,
31665: RETCODE => lv_return,
31666: pBatchID => lv_batch_id,
31667: pInstanceCode => v_instance_code,

Line 32453: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

32449:
32450:
32451: --Call to customised validation.
32452:
32453: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
32454: (ERRBUF => lv_error_text,
32455: RETCODE => lv_return,
32456: pBatchID => lv_batch_id,
32457: pInstanceCode => v_instance_code,

Line 33043: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

33039:
33040:
33041: --Call to customised validation.
33042:
33043: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
33044: (ERRBUF => lv_error_text,
33045: RETCODE => lv_return,
33046: pBatchID => lv_batch_id,
33047: pInstanceCode => v_instance_code,

Line 33123: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_DEPT_RES'||'('

33119:
33120:
33121: EXCEPTION
33122: WHEN too_many_rows THEN
33123: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_DEPT_RES'||'('
33124: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
33125: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
33126: ROLLBACK ;
33127:

Line 33133: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_DEPT_RES'||'('

33129: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
33130: ROLLBACK;
33131:
33132: WHEN OTHERS THEN
33133: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_DEPT_RES'||'('
33134: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
33135: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
33136: ROLLBACK;
33137:

Line 33470: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_RESOURCE_SETUPS'||'('

33466: COMMIT;
33467: END LOOP;
33468: EXCEPTION
33469: WHEN too_many_rows THEN
33470: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_RESOURCE_SETUPS'||'('
33471: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
33472: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
33473: ROLLBACK ;
33474:

Line 33480: lv_error_text :=substr('MSC_CL_PRE_PROCESS.LOAD_RESOURCE_SETUPS'||'('

33476: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
33477: ROLLBACK;
33478:
33479: WHEN OTHERS THEN
33480: lv_error_text :=substr('MSC_CL_PRE_PROCESS.LOAD_RESOURCE_SETUPS'||'('
33481: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
33482: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
33483: ROLLBACK;
33484:

Line 33894: substr('MSC_CL_PRE_PROCESS.LOAD_SETUP_TRANSITIONS'||'('

33890: END LOOP;
33891: EXCEPTION
33892: WHEN too_many_rows THEN
33893: lv_error_text :=
33894: substr('MSC_CL_PRE_PROCESS.LOAD_SETUP_TRANSITIONS'||'('
33895: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
33896: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
33897: ROLLBACK ;
33898:

Line 33904: lv_error_text :=substr('MSC_CL_PRE_PROCESS.LOAD_SETUP_TRANSITIONS'||'('

33900: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
33901: ROLLBACK;
33902:
33903: WHEN OTHERS THEN
33904: lv_error_text :=substr('MSC_CL_PRE_PROCESS.LOAD_SETUP_TRANSITIONS'||'('
33905: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
33906: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
33907: ROLLBACK;
33908:

Line 34057: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_SUPPLY'||'(' ||v_sql_stmt||')'|| SQLERRM, 1, 240);

34053: OPEN c_lock(p_batch_id) ;
34054: EXIT;
34055: EXCEPTION
34056: WHEN busy THEN
34057: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_SUPPLY'||'(' ||v_sql_stmt||')'|| SQLERRM, 1, 240);
34058: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
34059: dbms_lock.sleep(5);
34060: WHEN OTHERS THEN
34061: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_SUPPLY'||'(' ||v_sql_stmt||')'|| SQLERRM, 1, 240);

Line 34061: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_SUPPLY'||'(' ||v_sql_stmt||')'|| SQLERRM, 1, 240);

34057: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_SUPPLY'||'(' ||v_sql_stmt||')'|| SQLERRM, 1, 240);
34058: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
34059: dbms_lock.sleep(5);
34060: WHEN OTHERS THEN
34061: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_SUPPLY'||'(' ||v_sql_stmt||')'|| SQLERRM, 1, 240);
34062: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
34063: v_sql_stmt := 2.0;
34064: lv_sql_stmt :=
34065: 'UPDATE msc_st_supplies '

Line 35297: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

35293: USING p_batch_id,
35294: v_instance_code;
35295:
35296: --Call to customised validation.
35297: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
35298: (ERRBUF => lv_error_text,
35299: RETCODE => lv_return,
35300: pBatchID => p_batch_id,
35301: pInstanceCode => v_instance_code,

Line 35715: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_SUPPLY'||'('

35711: COMMIT;
35712:
35713: EXCEPTION
35714: WHEN too_many_rows THEN
35715: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_SUPPLY'||'('
35716: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
35717: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
35718: ROLLBACK;
35719: IF c_lock%ISOPEN THEN

Line 35731: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_SUPPLY'||'('

35727: CLOSE c_lock;
35728: END IF;
35729:
35730: WHEN OTHERS THEN
35731: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_SUPPLY'||'('
35732: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
35733: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
35734: ROLLBACK;
35735: IF c_lock%ISOPEN THEN

Line 35911: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_SALES_ORDER'||'('||v_sql_stmt||')'||'p_batch_id :'||p_batch_id|| SQLERRM, 1, 240);

35907: OPEN c_lock(p_batch_id) ;
35908: EXIT;
35909: EXCEPTION
35910: WHEN busy THEN
35911: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_SALES_ORDER'||'('||v_sql_stmt||')'||'p_batch_id :'||p_batch_id|| SQLERRM, 1, 240);
35912: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
35913: dbms_lock.sleep(5);
35914: WHEN OTHERS THEN
35915: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_SALES_ORDER'||'('||v_sql_stmt||')'||'p_batch_id :'||p_batch_id|| SQLERRM, 1, 240);

Line 35915: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_SALES_ORDER'||'('||v_sql_stmt||')'||'p_batch_id :'||p_batch_id|| SQLERRM, 1, 240);

35911: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_SALES_ORDER'||'('||v_sql_stmt||')'||'p_batch_id :'||p_batch_id|| SQLERRM, 1, 240);
35912: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
35913: dbms_lock.sleep(5);
35914: WHEN OTHERS THEN
35915: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_SALES_ORDER'||'('||v_sql_stmt||')'||'p_batch_id :'||p_batch_id|| SQLERRM, 1, 240);
35916: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
35917:
35918: v_sql_stmt := 1.1;
35919: lv_sql_stmt :=

Line 37051: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

37047: RAISE ex_logging_err;
37048: END IF;
37049:
37050: --Call to customised validation.
37051: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
37052: (ERRBUF => lv_error_text,
37053: RETCODE => lv_return,
37054: pBatchID => p_batch_id,
37055: pInstanceCode => v_instance_code,

Line 37433: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_SALES_ORDER'||'('

37429: COMMIT;
37430:
37431: EXCEPTION
37432: WHEN too_many_rows THEN
37433: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_SALES_ORDER'||'('
37434: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
37435: ROLLBACK ;
37436: IF c_lock%ISOPEN THEN
37437: CLOSE c_lock;

Line 37449: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_SALES_ORDER'||'('

37445: CLOSE c_lock;
37446: END IF;
37447:
37448: WHEN OTHERS THEN
37449: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_SALES_ORDER'||'('
37450: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
37451: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
37452:
37453: ROLLBACK;

Line 38480: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

38476:
38477:
38478:
38479: --Call to customised validation.
38480: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
38481: (ERRBUF => lv_error_text,
38482: RETCODE => lv_return,
38483: pBatchID => lv_batch_id,
38484: pInstanceCode => v_instance_code,

Line 38531: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_RESRVATIONS'||'('

38527:
38528: EXCEPTION
38529:
38530: WHEN too_many_rows THEN
38531: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_RESRVATIONS'||'('
38532: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
38533: ROLLBACK ;
38534:
38535: WHEN ex_logging_err THEN

Line 38541: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_RESERVATIONS '||'('

38537:
38538: ROLLBACK;
38539:
38540: WHEN OTHERS THEN
38541: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_RESERVATIONS '||'('
38542: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
38543: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
38544:
38545: ROLLBACK;

Line 39592: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

39588: RAISE ex_logging_err;
39589: END IF;
39590:
39591: --Call to customised validation.
39592: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
39593: (ERRBUF => lv_error_text,
39594: RETCODE => lv_return,
39595: pBatchID => p_batch_id,
39596: pInstanceCode => v_instance_code,

Line 39785: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_MDS_FORECAST'||'('

39781:
39782: EXCEPTION
39783:
39784: WHEN too_many_rows THEN
39785: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_MDS_FORECAST'||'('
39786: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
39787: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
39788:
39789: ROLLBACK ;

Line 39797: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_MDS_FORECAST'||'('

39793:
39794: ROLLBACK;
39795:
39796: WHEN OTHERS THEN
39797: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_MDS_FORECAST'||'('
39798: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
39799: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
39800:
39801: ROLLBACK;

Line 39973: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

39969:
39970:
39971: --Call to customised validation.
39972:
39973: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
39974: (ERRBUF => lv_error_text,
39975: RETCODE => lv_return,
39976: pBatchID => lv_batch_id,
39977: pInstanceCode => v_instance_code,

Line 40004: lv_error_text :=substr('MSC_CL_PRE_PROCESS.LOAD_COMPANY_USERS'||'('

40000: END LOOP;
40001:
40002: EXCEPTION
40003: WHEN too_many_rows THEN
40004: lv_error_text :=substr('MSC_CL_PRE_PROCESS.LOAD_COMPANY_USERS'||'('
40005: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
40006: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
40007:
40008: ROLLBACK ;

Line 40011: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'MSC_CL_PRE_PROCESS.LOAD_COMPANY_USERS: '||lv_error_text);

40007:
40008: ROLLBACK ;
40009:
40010: WHEN ex_logging_err THEN
40011: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'MSC_CL_PRE_PROCESS.LOAD_COMPANY_USERS: '||lv_error_text);
40012: ROLLBACK;
40013:
40014: WHEN OTHERS THEN
40015: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_COMPANY_USERS'||'('

Line 40015: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_COMPANY_USERS'||'('

40011: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'MSC_CL_PRE_PROCESS.LOAD_COMPANY_USERS: '||lv_error_text);
40012: ROLLBACK;
40013:
40014: WHEN OTHERS THEN
40015: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_COMPANY_USERS'||'('
40016: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
40017: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
40018: ROLLBACK;
40019:

Line 40390: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_CO_PRODUCT_BOMS'||'('

40386:
40387: EXCEPTION
40388:
40389: WHEN OTHERS THEN
40390: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_CO_PRODUCT_BOMS'||'('
40391: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
40392: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
40393: ROLLBACK;
40394:

Line 40973: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

40969: END IF;
40970:
40971: --Call to customised validation.
40972:
40973: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
40974: (ERRBUF => lv_error_text,
40975: RETCODE => lv_return,
40976: pBatchID => lv_batch_id,
40977: pInstanceCode => v_instance_code,

Line 42047: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

42043: end if;
42044:
42045: --Call to customised validation.
42046:
42047: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
42048: (ERRBUF => lv_error_text,
42049: RETCODE => lv_return,
42050: pBatchID => lv_batch_id,
42051: pInstanceCode => v_instance_code,

Line 42803: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

42799: END IF;
42800:
42801: --Call to customised validation.
42802:
42803: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
42804: (ERRBUF => lv_error_text,
42805: RETCODE => lv_return,
42806: pBatchID => lv_batch_id,
42807: pInstanceCode => v_instance_code,

Line 43206: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

43202: -- Call to customised validation.
43203: -- Note this is called prior to next validation, so that records getting
43204: -- errored out in the customised validation later otherwise donot violate this.
43205:
43206: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
43207: (ERRBUF => lv_error_text,
43208: RETCODE => lv_return,
43209: pBatchID => lv_batch_id,
43210: pInstanceCode => v_instance_code,

Line 43435: lv_error_text :=substr('MSC_CL_PRE_PROCESS.LOAD_BOM'||'('

43431:
43432:
43433: EXCEPTION
43434: WHEN too_many_rows THEN
43435: lv_error_text :=substr('MSC_CL_PRE_PROCESS.LOAD_BOM'||'('
43436: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
43437: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
43438: ROLLBACK ;
43439:

Line 43445: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_BOM'||'('

43441: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
43442: ROLLBACK;
43443:
43444: WHEN OTHERS THEN
43445: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_BOM'||'('
43446: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
43447: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
43448: ROLLBACK;
43449:

Line 44241: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

44237: EXECUTE IMMEDIATE lv_sql_stmt USING v_instance_code,lv_batch_id;
44238:
44239: --Call to customised validation.
44240:
44241: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
44242: (ERRBUF => lv_error_text,
44243: RETCODE => lv_return,
44244: pBatchID => lv_batch_id,
44245: pInstanceCode => v_instance_code,

Line 45084: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

45080: END IF;
45081:
45082: --Call to customised validation.
45083:
45084: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
45085: (ERRBUF => lv_error_text,
45086: RETCODE => lv_return,
45087: pBatchID => lv_batch_id,
45088: pInstanceCode => v_instance_code,

Line 46083: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

46079: END IF;
46080:
46081: --Call to customised validation.
46082:
46083: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
46084: (ERRBUF => lv_error_text,
46085: RETCODE => lv_return,
46086: pBatchID => lv_batch_id,
46087: pInstanceCode => v_instance_code,

Line 47009: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

47005:
47006:
47007: --Call to customised validation.
47008:
47009: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
47010: (ERRBUF => lv_error_text,
47011: RETCODE => lv_return,
47012: pBatchID => lv_batch_id,
47013: pInstanceCode => v_instance_code,

Line 47152: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_ROUTING'||'('

47148:
47149:
47150: EXCEPTION
47151: WHEN too_many_rows THEN
47152: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_ROUTING'||'('
47153: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
47154: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
47155: ROLLBACK ;
47156:

Line 47162: lv_error_text :=substr('MSC_CL_PRE_PROCESS.LOAD_ROUTING'||'('

47158: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
47159: ROLLBACK;
47160:
47161: WHEN OTHERS THEN
47162: lv_error_text :=substr('MSC_CL_PRE_PROCESS.LOAD_ROUTING'||'('
47163: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
47164: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
47165: ROLLBACK;
47166:

Line 47277: lv_error_text :=substr('MSC_CL_PRE_PROCESS.LOAD_PROCESS_EFFECTIVITY'||'('

47273:
47274: EXCEPTION
47275: WHEN OTHERS THEN
47276: ROLLBACK;
47277: lv_error_text :=substr('MSC_CL_PRE_PROCESS.LOAD_PROCESS_EFFECTIVITY'||'('
47278: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
47279: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
47280:
47281: END LOAD_PROCESS_EFFECTIVITY ;

Line 48086: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

48082: v_instance_code;
48083:
48084:
48085: --Call to customised validation.
48086: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
48087: (ERRBUF => lv_error_text,
48088: RETCODE => lv_return,
48089: pBatchID => lv_batch_id,
48090: pInstanceCode => v_instance_code,

Line 48361: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_WO_SUPPLY'||'('

48357: COMMIT;
48358: END LOOP;
48359: EXCEPTION
48360: WHEN too_many_rows THEN
48361: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_WO_SUPPLY'||'('
48362: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
48363: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
48364: ROLLBACK;
48365:

Line 48371: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_WO_SUPPLY'||'('

48367: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
48368: ROLLBACK;
48369:
48370: WHEN OTHERS THEN
48371: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_WO_SUPPLY'||'('
48372: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
48373: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
48374: ROLLBACK;
48375:

Line 49359: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

49355: AND batch_id = lv_batch_id;
49356:
49357: --Call to customised validation.
49358:
49359: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
49360: (ERRBUF => lv_error_text,
49361: RETCODE => lv_return,
49362: pBatchID => lv_batch_id,
49363: pInstanceCode => v_instance_code,

Line 49617: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_RES_DEMAND'||'('

49613:
49614: EXCEPTION
49615:
49616: WHEN too_many_rows THEN
49617: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_RES_DEMAND'||'('
49618: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
49619: ROLLBACK ;
49620:
49621: WHEN ex_logging_err THEN

Line 49626: lv_error_text :=substr('MSC_CL_PRE_PROCESS.LOAD_RES_DEMAND'||'('

49622: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
49623: ROLLBACK;
49624:
49625: WHEN OTHERS THEN
49626: lv_error_text :=substr('MSC_CL_PRE_PROCESS.LOAD_RES_DEMAND'||'('
49627: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
49628: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
49629: ROLLBACK;
49630:

Line 50559: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

50555: RAISE ex_logging_err;
50556: END IF;
50557:
50558: --Call to customised validation.
50559: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
50560: (ERRBUF => lv_error_text,
50561: RETCODE => lv_return,
50562: pBatchID => lv_batch_id,
50563: pInstanceCode => v_instance_code,

Line 50711: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_WIP_DEMAND'||'('

50707: END LOOP ;
50708:
50709: EXCEPTION
50710: WHEN too_many_rows THEN
50711: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_WIP_DEMAND'||'('
50712: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
50713: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
50714: ROLLBACK ;
50715:

Line 50721: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_WIP_DEMAND'||'('

50717: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
50718: ROLLBACK;
50719:
50720: WHEN OTHERS THEN
50721: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_WIP_DEMAND'||'('
50722: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
50723: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
50724: ROLLBACK;
50725:

Line 51586: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

51582: END IF;
51583:
51584: --Call to customised validation.
51585:
51586: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
51587: (ERRBUF => lv_error_text,
51588: RETCODE => lv_return,
51589: pBatchID => lv_batch_id,
51590: pInstanceCode => v_instance_code,

Line 52302: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

52298: EXECUTE IMMEDIATE lv_sql_stmt USING v_instance_code,lv_batch_id;
52299:
52300: --Call to customised validation.
52301:
52302: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
52303: (ERRBUF => lv_error_text,
52304: RETCODE => lv_return,
52305: pBatchID => lv_batch_id,
52306: pInstanceCode => v_instance_code,

Line 53148: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

53144:
53145:
53146:
53147: --Call to customised validation.
53148: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
53149: (ERRBUF => lv_error_text,
53150: RETCODE => lv_return,
53151: pBatchID => lv_batch_id,
53152: pInstanceCode => v_instance_code,

Line 53986: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

53982:
53983:
53984: --Call to customised validation.
53985:
53986: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
53987: (ERRBUF => lv_error_text,
53988: RETCODE => lv_return,
53989: pBatchID => lv_batch_id,
53990: pInstanceCode => v_instance_code,

Line 54035: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_JOB_DETAILS'||'('

54031:
54032: EXCEPTION
54033:
54034: WHEN too_many_rows THEN
54035: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_JOB_DETAILS'||'('
54036: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
54037: ROLLBACK ;
54038:
54039: WHEN ex_logging_err THEN

Line 54044: lv_error_text :=substr('MSC_CL_PRE_PROCESS.LOAD_JOB_DETAILS'||'('

54040: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
54041: ROLLBACK;
54042:
54043: WHEN OTHERS THEN
54044: lv_error_text :=substr('MSC_CL_PRE_PROCESS.LOAD_JOB_DETAILS'||'('
54045: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
54046: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
54047: ROLLBACK;
54048:

Line 54206: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_BIS_PERIODS'||'('

54202: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'msc_st_bis_periods : Rows updated - '||SQL%ROWCOUNT);
54203: --end of changes for bug 8613033
54204: EXCEPTION
54205: WHEN OTHERS THEN
54206: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_BIS_PERIODS'||'('
54207: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
54208: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
54209: ROLLBACK;
54210:

Line 55440: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION

55436:
55437:
55438: -- Call the HOOK to enable the customised validations if there is any.
55439: -- Call to customised validation.
55440: MSC_CL_PRE_PROCESS_HOOK.ENTITY_VALIDATION
55441: (ERRBUF => lv_error_text,
55442: RETCODE => lv_return,
55443: pBatchID => lv_batch_id,
55444: pInstanceCode => v_instance_code,

Line 55492: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_DESIGNATOR'||'('

55488: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
55489: ROLLBACK;
55490:
55491: WHEN OTHERS THEN
55492: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_DESIGNATOR'||'('
55493: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
55494: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
55495: ROLLBACK;
55496:

Line 55651: lv_error_text := substr('MSC_CL_PRE_PROCESS.SET_IN_PROCESS- '||p_table_name||': ('||v_sql_stmt||')'|| SQLERRM, 1, 240);

55647: ROLLBACK;
55648: RETURN 0;
55649:
55650: WHEN OTHERS THEN
55651: lv_error_text := substr('MSC_CL_PRE_PROCESS.SET_IN_PROCESS- '||p_table_name||': ('||v_sql_stmt||')'|| SQLERRM, 1, 240);
55652: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
55653: ROLLBACK;
55654: RETURN 0;
55655: END SET_IN_PROCESS ;

Line 56206: lv_error_text := substr('MSC_CL_PRE_PROCESS.SNAPSHOT_TABLES - '|| SQLERRM, 1, 240);

56202: RETURN (TRUE);
56203:
56204: EXCEPTION
56205: WHEN OTHERS THEN
56206: lv_error_text := substr('MSC_CL_PRE_PROCESS.SNAPSHOT_TABLES - '|| SQLERRM, 1, 240);
56207: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
56208: return(FALSE);
56209:
56210: END SNAPSHOT_TABLES ;

Line 56923: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,substr('MSC_CL_PRE_PROCESS.LOAD_ITEM_ABC_CLASSES'||SQLERRM,1,240));

56919: END IF; --v_install_msc
56920:
56921: EXCEPTION
56922: WHEN OTHERS THEN
56923: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,substr('MSC_CL_PRE_PROCESS.LOAD_ITEM_ABC_CLASSES'||SQLERRM,1,240));
56924:
56925: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error_Stack...');
56926: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, DBMS_UTILITY.FORMAT_ERROR_STACK );
56927: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error_Backtrace...' );

Line 56952: ||' MSC_CL_PRE_PROCESS.v_flag := '||SYS_YES||';'

56948: ||' p_instance_code => :v_instance_code,'
56949: ||' p_instance_id => :v_instance_id,'
56950: ||' p_batch_id => :lv_batch_id);'
56951: ||' IF ( retcode = '||G_WARNING||') THEN'
56952: ||' MSC_CL_PRE_PROCESS.v_flag := '||SYS_YES||';'
56953: ||' END IF;'
56954: ||' END ;';
56955:
56956:

Line 56966: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,substr('MSC_CL_PRE_PROCESS.LOAD_LEVEL_VALUE'||SQLERRM,1,240));

56962: END IF ;
56963:
56964: EXCEPTION
56965: WHEN OTHERS THEN
56966: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,substr('MSC_CL_PRE_PROCESS.LOAD_LEVEL_VALUE'||SQLERRM,1,240));
56967:
56968: END ;
56969:
56970: PROCEDURE LOAD_LEVEL_ASSOCIATION(p_batch_id NUMBER)

Line 56985: ||' MSC_CL_PRE_PROCESS.v_flag := '||SYS_YES||';'

56981: ||' p_instance_code => :v_instance_code,'
56982: ||' p_instance_id => :v_instance_id,'
56983: ||' p_batch_id => :lv_batch_id);'
56984: ||' IF ( retcode = '||G_WARNING||') THEN'
56985: ||' MSC_CL_PRE_PROCESS.v_flag := '||SYS_YES||';'
56986: ||' END IF;'
56987: ||' END ;';
56988:
56989:

Line 56999: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,substr('MSC_CL_PRE_PROCESS.LOAD_LEVEL_ASSOCIATION'||SQLERRM,1,240));

56995: END IF ;
56996:
56997: EXCEPTION
56998: WHEN OTHERS THEN
56999: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,substr('MSC_CL_PRE_PROCESS.LOAD_LEVEL_ASSOCIATION'||SQLERRM,1,240));
57000:
57001: END ;
57002:
57003: PROCEDURE LOAD_BOOKING_DATA (p_batch_id NUMBER )

Line 57018: ||' MSC_CL_PRE_PROCESS.v_flag := '||SYS_YES||';'

57014: ||' p_instance_code => :v_instance_code,'
57015: ||' p_instance_id => :v_instance_id,'
57016: ||' p_batch_id => :lv_batch_id);'
57017: ||' IF ( retcode = '||G_WARNING||') THEN'
57018: ||' MSC_CL_PRE_PROCESS.v_flag := '||SYS_YES||';'
57019: ||' END IF;'
57020: ||' END ;';
57021:
57022:

Line 57032: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,substr('MSC_CL_PRE_PROCESS.LOAD_BOOKING_DATA'||SQLERRM,1,240));

57028: END IF ;
57029:
57030: EXCEPTION
57031: WHEN OTHERS THEN
57032: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,substr('MSC_CL_PRE_PROCESS.LOAD_BOOKING_DATA'||SQLERRM,1,240));
57033:
57034: END ;
57035:
57036: PROCEDURE LOAD_SHIPMENT_DATA (p_batch_id NUMBER )

Line 57051: ||' MSC_CL_PRE_PROCESS.v_flag := '||SYS_YES||';'

57047: ||' p_instance_code => :v_instance_code,'
57048: ||' p_instance_id => :v_instance_id,'
57049: ||' p_batch_id => :lv_batch_id);'
57050: ||' IF ( retcode = '||G_WARNING||') THEN'
57051: ||' MSC_CL_PRE_PROCESS.v_flag := '||SYS_YES||';'
57052: ||' END IF;'
57053: ||' END ;';
57054:
57055:

Line 57065: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,substr('MSC_CL_PRE_PROCESS.LOAD_SHIPMENT_DATA'||SQLERRM,1,240));

57061: END IF ;
57062:
57063: EXCEPTION
57064: WHEN OTHERS THEN
57065: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,substr('MSC_CL_PRE_PROCESS.LOAD_SHIPMENT_DATA'||SQLERRM,1,240));
57066:
57067: END ;
57068:
57069: PROCEDURE LOAD_MFG_FORECAST (p_batch_id NUMBER )

Line 57084: ||' MSC_CL_PRE_PROCESS.v_flag := '||SYS_YES||';'

57080: ||' p_instance_code => :v_instance_code,'
57081: ||' p_instance_id => :v_instance_id,'
57082: ||' p_batch_id => :lv_batch_id);'
57083: ||' IF ( retcode = '||G_WARNING||') THEN'
57084: ||' MSC_CL_PRE_PROCESS.v_flag := '||SYS_YES||';'
57085: ||' END IF;'
57086: ||' END ;';
57087:
57088:

Line 57098: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,substr('MSC_CL_PRE_PROCESS.LOAD_MFG_FORECAST'||SQLERRM,1,240));

57094: END IF ;
57095:
57096: EXCEPTION
57097: WHEN OTHERS THEN
57098: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,substr('MSC_CL_PRE_PROCESS.LOAD_MFG_FORECAST'||SQLERRM,1,240));
57099:
57100: END ;
57101:
57102: PROCEDURE LOAD_PRICE_LIST (p_batch_id NUMBER )

Line 57117: ||' MSC_CL_PRE_PROCESS.v_flag := '||SYS_YES||';'

57113: ||' p_instance_code => :v_instance_code,'
57114: ||' p_instance_id => :v_instance_id,'
57115: ||' p_batch_id => :lv_batch_id);'
57116: ||' IF ( retcode = '||G_WARNING||') THEN'
57117: ||' MSC_CL_PRE_PROCESS.v_flag := '||SYS_YES||';'
57118: ||' END IF;'
57119: ||' END ;';
57120:
57121:

Line 57131: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,substr('MSC_CL_PRE_PROCESS.LOAD_PRICE_LIST'||SQLERRM,1,240));

57127: END IF ;
57128:
57129: EXCEPTION
57130: WHEN OTHERS THEN
57131: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,substr('MSC_CL_PRE_PROCESS.LOAD_PRICE_LIST'||SQLERRM,1,240));
57132:
57133: END ;
57134: /*
57135: PROCEDURE LOAD_ITEM_LIST_PRICE(p_batch_id NUMBER )

Line 57161: msc_st_util.log_message(substr('MSC_CL_PRE_PROCESS.LOAD_ITEM_LIST_PRICE'||SQLERRM,1,240));

57157: END IF ;
57158:
57159: EXCEPTION
57160: WHEN OTHERS THEN
57161: msc_st_util.log_message(substr('MSC_CL_PRE_PROCESS.LOAD_ITEM_LIST_PRICE'||SQLERRM,1,240));
57162:
57163: END ;
57164: */
57165:

Line 57181: ||' MSC_CL_PRE_PROCESS.v_flag := '||SYS_YES||';'

57177: ||' p_instance_code => :v_instance_code,'
57178: ||' p_instance_id => :v_instance_id,'
57179: ||' p_batch_id => :lv_batch_id);'
57180: ||' IF ( retcode = '||G_WARNING||') THEN'
57181: ||' MSC_CL_PRE_PROCESS.v_flag := '||SYS_YES||';'
57182: ||' END IF;'
57183: ||' END ;';
57184:
57185:

Line 57195: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,substr('MSC_CL_PRE_PROCESS.LOAD_CS_DATA'||SQLERRM,1,240));

57191: END IF ;
57192:
57193: EXCEPTION
57194: WHEN OTHERS THEN
57195: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,substr('MSC_CL_PRE_PROCESS.LOAD_CS_DATA'||SQLERRM,1,240));
57196:
57197: END ;
57198:
57199: PROCEDURE LOAD_CURR_CONV (p_batch_id NUMBER )

Line 57214: ||' MSC_CL_PRE_PROCESS.v_flag := '||SYS_YES||';'

57210: ||' p_instance_code => :v_instance_code,'
57211: ||' p_instance_id => :v_instance_id,'
57212: ||' p_batch_id => :lv_batch_id);'
57213: ||' IF ( retcode = '||G_WARNING||') THEN'
57214: ||' MSC_CL_PRE_PROCESS.v_flag := '||SYS_YES||';'
57215: ||' END IF;'
57216: ||' END ;';
57217:
57218:

Line 57229: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,substr('MSC_CL_PRE_PROCESS.LOAD_CURR_CONV'||SQLERRM,1,240));

57225: END IF ;
57226:
57227: EXCEPTION
57228: WHEN OTHERS THEN
57229: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,substr('MSC_CL_PRE_PROCESS.LOAD_CURR_CONV'||SQLERRM,1,240));
57230:
57231: END ;
57232:
57233: PROCEDURE LOAD_UOM_CONV (p_batch_id NUMBER )

Line 57248: ||' MSC_CL_PRE_PROCESS.v_flag := '||SYS_YES||';'

57244: ||' p_instance_code => :v_instance_code,'
57245: ||' p_instance_id => :v_instance_id,'
57246: ||' p_batch_id => :lv_batch_id);'
57247: ||' IF ( retcode = '||G_WARNING||') THEN'
57248: ||' MSC_CL_PRE_PROCESS.v_flag := '||SYS_YES||';'
57249: ||' END IF;'
57250: ||' END ;';
57251:
57252:

Line 57263: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,substr('MSC_CL_PRE_PROCESS.LOAD_UOM_CONV'||SQLERRM,1,240));

57259: END IF ;
57260:
57261: EXCEPTION
57262: WHEN OTHERS THEN
57263: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,substr('MSC_CL_PRE_PROCESS.LOAD_UOM_CONV'||SQLERRM,1,240));
57264:
57265: END ;
57266:
57267: PROCEDURE LOAD_FISCAL_TIME

Line 57281: ||' MSC_CL_PRE_PROCESS.v_flag := '||SYS_YES||';'

57277: ||' RETCODE => retcode ,'
57278: ||' p_instance_code => :v_instance_code,'
57279: ||' p_instance_id => :v_instance_id );'
57280: ||' IF ( retcode = '||G_WARNING||') THEN'
57281: ||' MSC_CL_PRE_PROCESS.v_flag := '||SYS_YES||';'
57282: ||' END IF;'
57283: ||' END ;';
57284:
57285:

Line 57295: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,substr('MSC_CL_PRE_PROCESS.LOAD_FISCAL_TIME'||SQLERRM,1,240));

57291: END IF ;
57292:
57293: EXCEPTION
57294: WHEN OTHERS THEN
57295: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,substr('MSC_CL_PRE_PROCESS.LOAD_FISCAL_TIME'||SQLERRM,1,240));
57296:
57297: END ;
57298:
57299:

Line 57314: ||' MSC_CL_PRE_PROCESS.v_flag := '||SYS_YES||';'

57310: ||' RETCODE => retcode ,'
57311: ||' p_instance_code => :v_instance_code,'
57312: ||' p_instance_id => :v_instance_id );'
57313: ||' IF ( retcode = '||G_WARNING||') THEN'
57314: ||' MSC_CL_PRE_PROCESS.v_flag := '||SYS_YES||';'
57315: ||' END IF;'
57316: ||' END ;';
57317:
57318:

Line 57328: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,substr('MSC_CL_PRE_PROCESS.LOAD_COMPOSITE_TIME'||SQLERRM,1,240));

57324: END IF ;
57325:
57326: EXCEPTION
57327: WHEN OTHERS THEN
57328: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,substr('MSC_CL_PRE_PROCESS.LOAD_COMPOSITE_TIME'||SQLERRM,1,240));
57329:
57330: END ;
57331:
57332:

Line 57347: ||' MSC_CL_PRE_PROCESS.v_flag := '||SYS_YES||';'

57343: ||' RETCODE => retcode ,'
57344: ||' p_instance_code => :v_instance_code,'
57345: ||' p_instance_id => :v_instance_id );'
57346: ||' IF ( retcode = '||G_WARNING||') THEN'
57347: ||' MSC_CL_PRE_PROCESS.v_flag := '||SYS_YES||';'
57348: ||' END IF;'
57349: ||' END ;';
57350:
57351:

Line 57361: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,substr('MSC_CL_PRE_PROCESS.LOAD_SETUP_PARAMETER'||SQLERRM,1,240));

57357: END IF ;
57358:
57359: EXCEPTION
57360: WHEN OTHERS THEN
57361: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,substr('MSC_CL_PRE_PROCESS.LOAD_SETUP_PARAMETER'||SQLERRM,1,240));
57362:
57363: END ;
57364:
57365: PROCEDURE LOAD_MFG_TIME

Line 57406: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,substr('MSC_CL_PRE_PROCESS.LOAD_MFG_TIME'||SQLERRM,1,240));

57402: END IF ; -- v_install_msd
57403:
57404: EXCEPTION
57405: WHEN OTHERS THEN
57406: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,substr('MSC_CL_PRE_PROCESS.LOAD_MFG_TIME'||SQLERRM,1,240));
57407:
57408: END ;
57409:
57410: -- Load Profiles

Line 57611: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,substr('MSC_CL_PRE_PROCESS.LOAD_PROFILES'||SQLERRM,1,240));

57607: COMMIT;
57608:
57609: EXCEPTION
57610: WHEN OTHERS THEN
57611: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,substr('MSC_CL_PRE_PROCESS.LOAD_PROFILES'||SQLERRM,1,240));
57612:
57613: END LOAD_PROFILES;
57614:
57615:

Line 59770: END MSC_CL_PRE_PROCESS;

59766: COMMIT;
59767:
59768: END LAUNCH_MONITOR;
59769:
59770: END MSC_CL_PRE_PROCESS;