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.

[Home] [Help]

APPS.MSC_CL_PRE_PROCESS dependencies on MSC_ERRORS

Line 190: from msc_errors err,

186: err.error_text,
187: err.severity,
188: err.table_name,
189: err.rrow
190: from msc_errors err,
191: ecx_doclogs ed
192: where err.message_id = ed.internal_control_number
193: and err.instance_code = v_instance_code
194: and nvl(err.message_sent,SYS_NO) <> SYS_YES;

Line 279: update msc_errors set message_sent = SYS_YES

275: -- Start the Workflow process
276: wf_xmlnotify.startprocess(lv_msgid);
277:
278: lv_pointer:= 9;
279: update msc_errors set message_sent = SYS_YES
280: where error_id = c.error_id;
281:
282: END IF;
283: END LOOP;

Line 295: FROM msc_errors

291: -- WRITE_ERROR_SUMM_LOG ===========
292: PROCEDURE WRITE_ERROR_SUMM_LOG (p_parent_req_id number DEFAULT -1 ) IS
293: CURSOR c_error IS
294: SELECT table_name, error_text, count(*) occur
295: FROM msc_errors
296: WHERE instance_code = v_instance_code
297: AND error_id between (v_error_no_begin + 1) and v_error_no_end
298: AND severity = 1
299: GROUP BY table_name, error_text;

Line 303: FROM msc_errors

299: GROUP BY table_name, error_text;
300:
301: CURSOR c_error_by_req(p_request_id number) IS
302: SELECT table_name, error_text, count(*) occur
303: FROM msc_errors
304: WHERE instance_code = v_instance_code
305: AND request_id = p_request_id
306: AND severity = 1
307: GROUP BY table_name, error_text;

Line 311: FROM msc_errors

307: GROUP BY table_name, error_text;
308:
309: CURSOR c_warning IS
310: SELECT table_name, error_text, count(*) occur
311: FROM msc_errors
312: WHERE instance_code = v_instance_code
313: AND error_id between (v_error_no_begin +1) and v_error_no_end
314: AND severity = 2
315: GROUP BY table_name, error_text;

Line 319: FROM msc_errors

315: GROUP BY table_name, error_text;
316:
317: CURSOR c_warning_by_req(p_request_id number) IS
318: SELECT table_name, error_text, count(*) occur
319: FROM msc_errors
320: WHERE instance_code = v_instance_code
321: AND request_id = p_request_id
322: AND severity = 2
323: GROUP BY table_name, error_text;

Line 2922: -------------- Get current ERROR_ID from MSC_ERRORS ---

2918:
2919: MSC_ST_UTIL.v_instance_type := v_instance_type;
2920: MSC_ST_UTIL.v_instance_id := v_instance_id;
2921:
2922: -------------- Get current ERROR_ID from MSC_ERRORS ---
2923: -- SELECT max(ERROR_ID) INTO v_error_no_begin FROM MSC_ERRORS;
2924:
2925: ---------------- Set Flags -----------------------------
2926: -- set the flags as to whether discrete and/or process

Line 2923: -- SELECT max(ERROR_ID) INTO v_error_no_begin FROM MSC_ERRORS;

2919: MSC_ST_UTIL.v_instance_type := v_instance_type;
2920: MSC_ST_UTIL.v_instance_id := v_instance_id;
2921:
2922: -------------- Get current ERROR_ID from MSC_ERRORS ---
2923: -- SELECT max(ERROR_ID) INTO v_error_no_begin FROM MSC_ERRORS;
2924:
2925: ---------------- Set Flags -----------------------------
2926: -- set the flags as to whether discrete and/or process
2927: -- manufacturing are being used in the same instance

Line 3212: lv_message_text msc_errors.error_text%TYPE;

3208:
3209: PROCEDURE MODEL_ORG_SUPPLIER_CUSTOMER IS
3210: lv_error_text VARCHAR2(250);
3211: lv_return NUMBER;
3212: lv_message_text msc_errors.error_text%TYPE;
3213: ex_logging_err EXCEPTION;
3214:
3215: BEGIN
3216:

Line 3337: INSERT INTO msc_errors

3333: RAISE ex_logging_err;
3334: END IF;
3335:
3336:
3337: INSERT INTO msc_errors
3338: ( error_id,
3339: transaction_id,
3340: message_id,
3341: instance_code,

Line 3359: msc_errors_s.NEXTVAL,

3355: program_id,
3356: program_update_date,
3357: error_text)
3358: SELECT
3359: msc_errors_s.NEXTVAL,
3360: st_transaction_id,
3361: message_id,
3362: sr_instance_code,
3363: 'MSC_ST_TRADING_PARTNERS',

Line 3826: lv_message_text msc_errors.error_text%TYPE;

3822: lv_transaction_id msc_st_calendars.st_transaction_id%TYPE;
3823: lv_calendar_start_date msc_st_calendars.calendar_start_date%TYPE;
3824: lv_calendar_end_date msc_st_calendars.calendar_end_date%TYPE;
3825: lv_seq_num msc_st_workday_patterns.seq_num%TYPE := 0;
3826: lv_message_text msc_errors.error_text%TYPE;
3827: lv_shift_num msc_st_calendar_shifts.shift_num%TYPE;
3828:
3829: ex_logging_err EXCEPTION;
3830: ex_critical_err EXCEPTION;

Line 5730: lv_message_text msc_errors.error_text%TYPE;

5726: lv_error_text VARCHAR2(250);
5727: lv_where_str VARCHAR2(5000);
5728: lv_sql_stmt VARCHAR2(5000);
5729: lv_column_names VARCHAR2(5000); --stores concatenated column names
5730: lv_message_text msc_errors.error_text%TYPE;
5731:
5732: ex_logging_err EXCEPTION;
5733:
5734: CURSOR c1(p_batch_id NUMBER) IS

Line 6224: lv_message_text msc_errors.error_text%TYPE;

6220: lv_error_text VARCHAR2(250);
6221: lv_where_str VARCHAR2(5000);
6222: lv_sql_stmt VARCHAR2(5000);
6223: lv_column_names VARCHAR2(5000); --stores concatenated column names
6224: lv_message_text msc_errors.error_text%TYPE;
6225: lv_my_company msc_companies.company_name%TYPE;
6226: lv_user_id NUMBER;
6227:
6228: TYPE CharTblTyp IS TABLE OF VARCHAR2(240);

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

10392: IF lv_return <> 0 THEN
10393: RAISE ex_logging_err;
10394: END IF;
10395:
10396: -- Inserting all the errored out records into MSC_ERRORS
10397:
10398: lv_return := MSC_ST_util.LOG_ERROR
10399: (p_table_name => 'MSC_ST_GROUPS',
10400: p_instance_code => v_instance_code,

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

11052: IF lv_return <> 0 THEN
11053: RAISE ex_logging_err;
11054: END IF;
11055:
11056: -- Inserting all the errored out records into MSC_ERRORS
11057:
11058: lv_return := MSC_ST_util.LOG_ERROR
11059: (p_table_name => 'MSC_ST_GROUP_COMPANIES',
11060: p_instance_code => v_instance_code,

Line 11246: lv_message_text msc_errors.error_text%TYPE;

11242: lv_where_str VARCHAR2(5000);
11243: lv_sql_stmt VARCHAR2(5000);
11244: lv_column_names VARCHAR2(5000);
11245: lv_batch_id msc_st_calendar_assignments.batch_id%TYPE;
11246: lv_message_text msc_errors.error_text%TYPE;
11247:
11248: ex_logging_err EXCEPTION;
11249:
11250: CURSOR c1(p_batch_id NUMBER) IS

Line 12075: lv_message_text msc_errors.error_text%TYPE;

12071: lv_error_text VARCHAR2(250);
12072: lv_where_str VARCHAR2(5000);
12073: lv_sql_stmt VARCHAR2(5000);
12074: lv_column_names VARCHAR2(5000); --stores concatenated column names
12075: lv_message_text msc_errors.error_text%TYPE;
12076:
12077: ex_logging_err EXCEPTION;
12078:
12079: CURSOR c1 IS

Line 12384: lv_message_text msc_errors.error_text%TYPE;

12380: TYPE RowidTab IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
12381:
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;

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

12545: IF lv_return <> 0 THEN
12546: RAISE ex_logging_err;
12547: END IF;
12548:
12549: -- Inserting all the errored out records into MSC_ERRORS:
12550:
12551: lv_return := MSC_ST_UTIL.LOG_ERROR
12552: (p_table_name => 'MSC_ST_CALENDAR_MONTHS',
12553: p_instance_code => v_instance_code,

Line 12591: lv_message_text msc_errors.error_text%TYPE;

12587: lv_where_str VARCHAR2(5000);
12588: lv_sql_stmt VARCHAR2(5000);
12589: lv_column_names VARCHAR2(5000); --stores concatenated column names
12590: lv_batch_id msc_st_visits.batch_id%TYPE;
12591: lv_message_text msc_errors.error_text%TYPE;
12592:
12593: ex_logging_err EXCEPTION;
12594:
12595: CURSOR c1(p_batch_id NUMBER) IS

Line 13016: lv_message_text msc_errors.error_text%TYPE;

13012: lv_where_str VARCHAR2(5000);
13013: lv_sql_stmt VARCHAR2(5000);
13014: lv_column_names VARCHAR2(5000); --stores concatenated column names
13015: lv_batch_id msc_st_wo_milestones.batch_id%TYPE;
13016: lv_message_text msc_errors.error_text%TYPE;
13017:
13018: ex_logging_err EXCEPTION;
13019:
13020: CURSOR c1(p_batch_id NUMBER) IS

Line 13358: lv_message_text msc_errors.error_text%TYPE;

13354: lv_error_text VARCHAR2(250);
13355: lv_where_str VARCHAR2(5000);
13356: lv_sql_stmt VARCHAR2(5000);
13357: lv_column_names VARCHAR2(5000); --stores concatenated column names
13358: lv_message_text msc_errors.error_text%TYPE;
13359:
13360: ex_logging_err EXCEPTION;
13361:
13362: CURSOR c1 IS

Line 13596: lv_message_text msc_errors.error_text%TYPE;

13592: lv_where_str VARCHAR2(5000);
13593: lv_sql_stmt VARCHAR2(5000);
13594: lv_column_names VARCHAR2(5000); --stores concatenated column names
13595: lv_batch_id msc_st_wo_attributes.batch_id%TYPE;
13596: lv_message_text msc_errors.error_text%TYPE;
13597:
13598: ex_logging_err EXCEPTION;
13599:
13600: CURSOR c1(p_batch_id NUMBER) IS

Line 14210: lv_message_text msc_errors.error_text%TYPE;

14206: lv_where_str VARCHAR2(5000);
14207: lv_sql_stmt VARCHAR2(5000);
14208: lv_column_names VARCHAR2(5000); --stores concatenated column names
14209: lv_batch_id msc_st_wo_task_hierarchy.batch_id%TYPE;
14210: lv_message_text msc_errors.error_text%TYPE;
14211:
14212: ex_logging_err EXCEPTION;
14213:
14214: CURSOR c1(p_batch_id NUMBER) IS

Line 14771: lv_message_text msc_errors.error_text%TYPE;

14767: lv_where_str VARCHAR2(5000);
14768: lv_sql_stmt VARCHAR2(5000);
14769: lv_column_names VARCHAR2(5000); --stores concatenated column names
14770: lv_batch_id msc_st_wo_operation_rel.batch_id%TYPE;
14771: lv_message_text msc_errors.error_text%TYPE;
14772:
14773: ex_logging_err EXCEPTION;
14774:
14775: CURSOR c1(p_batch_id NUMBER) IS

Line 15440: lv_message_text msc_errors.error_text%TYPE;

15436: lv_where_str VARCHAR2(5000);
15437: lv_sql_stmt VARCHAR2(5000);
15438: lv_column_names VARCHAR2(5000);
15439: lv_batch_id msc_st_planners.batch_id%TYPE;
15440: lv_message_text msc_errors.error_text%TYPE;
15441:
15442: ex_logging_err EXCEPTION;
15443:
15444: CURSOR c1(p_batch_id NUMBER) IS

Line 16018: lv_message_text msc_errors.error_text%TYPE;

16014: lv_error_text VARCHAR2(250);
16015: lv_where_str VARCHAR2(5000);
16016: lv_sql_stmt VARCHAR2(5000);
16017: lv_column_names VARCHAR2(5000); --stores concatenated column names
16018: lv_message_text msc_errors.error_text%TYPE;
16019:
16020: ex_logging_err EXCEPTION;
16021:
16022: CURSOR c1(p_batch_id NUMBER) IS

Line 16976: lv_message_text msc_errors.error_text%TYPE;

16972: lv_where_str VARCHAR2(5000);
16973: lv_sql_stmt VARCHAR2(5000);
16974: lv_column_names VARCHAR2(5000); --stores concatenated column names
16975: lv_batch_id msc_st_regions.batch_id%TYPE;
16976: lv_message_text msc_errors.error_text%TYPE;
16977: lv_cursor_stmt VARCHAR2(5000);
16978:
16979: ex_logging_err EXCEPTION;
16980:

Line 19220: lv_message_text msc_errors.error_text%TYPE;

19216: lv_where_str VARCHAR2(5000);
19217: lv_sql_stmt VARCHAR2(5000);
19218: lv_column_names VARCHAR2(5000); --stores concatenated column names
19219: lv_batch_id msc_st_category_sets.batch_id%TYPE;
19220: lv_message_text msc_errors.error_text%TYPE;
19221: ex_logging_err EXCEPTION;
19222:
19223: CURSOR c1(p_batch_id NUMBER) IS
19224: SELECT rowid

Line 19673: lv_message_text msc_errors.error_text%TYPE;

19669: lv_where_str VARCHAR2(5000);
19670: lv_sql_stmt VARCHAR2(5000);
19671: lv_column_names VARCHAR2(5000);
19672: lv_batch_id msc_st_units_of_measure.batch_id%TYPE;
19673: lv_message_text msc_errors.error_text%TYPE;
19674:
19675: ex_logging_err EXCEPTION;
19676:
19677: CURSOR c1(p_batch_id NUMBER) IS

Line 20087: lv_message_text msc_errors.error_text%TYPE;

20083: lv_where_str VARCHAR2(5000);
20084: lv_sql_stmt VARCHAR2(5000);
20085: lv_column_names VARCHAR2(5000);
20086: lv_batch_id msc_st_uom_class_conversions.batch_id%TYPE;
20087: lv_message_text msc_errors.error_text%TYPE;
20088:
20089: ex_logging_err EXCEPTION;
20090:
20091: CURSOR c_udk1 is

Line 21324: lv_message_text msc_errors.error_text%TYPE;

21320: lv_sql_stmt VARCHAR2(5000);
21321: lv_return NUMBER;
21322:
21323: lv_batch_id msc_st_designators.batch_id%TYPE;
21324: lv_message_text msc_errors.error_text%TYPE;
21325: ex_logging_err EXCEPTION;
21326:
21327: CURSOR c1(lv_batch_id NUMBER) IS
21328: SELECT rowid

Line 22048: lv_message_text msc_errors.error_text%TYPE;

22044: lv_error_text VARCHAR2(250);
22045: lv_where_str VARCHAR2(5000);
22046: lv_sql_stmt VARCHAR2(5000);
22047: lv_batch_id msc_st_system_items.batch_id%TYPE;
22048: lv_message_text msc_errors.error_text%TYPE;
22049:
22050: ex_logging_err EXCEPTION;
22051: busy EXCEPTION;
22052: PRAGMA EXCEPTION_INIT(busy, -54);

Line 24279: lv_message_text msc_errors.error_text%TYPE;

24275: lv_where_str VARCHAR2(5000);
24276: lv_sql_stmt VARCHAR2(5000);
24277: lv_column_names VARCHAR2(5000); --stores concatenated column names
24278: lv_batch_id msc_st_item_substitutes.batch_id%TYPE;
24279: lv_message_text msc_errors.error_text%TYPE;
24280:
24281: ex_logging_err EXCEPTION;
24282:
24283: CURSOR c1(p_batch_id NUMBER) IS

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

24832: IF lv_return <> 0 THEN
24833: RAISE ex_logging_err;
24834: END IF;
24835:
24836: -- Inserting all the errored out records into MSC_ERRORS
24837:
24838: lv_return := MSC_ST_UTIL.LOG_ERROR
24839: (p_table_name => 'MSC_ST_ITEM_SUBSTITUTES',
24840: p_instance_code => v_instance_code,

Line 24951: lv_message_text msc_errors.error_text%TYPE;

24947: lv_where_str VARCHAR2(5000);
24948: lv_sql_stmt VARCHAR2(5000);
24949: lv_return NUMBER;
24950: lv_batch_id msc_st_item_suppliers.batch_id%TYPE;
24951: lv_message_text msc_errors.error_text%TYPE;
24952:
24953: ex_logging_err EXCEPTION;
24954:
24955:

Line 26596: lv_message_text msc_errors.error_text%TYPE;

26592: lv_where_str VARCHAR2(5000);
26593: lv_sql_stmt VARCHAR2(5000);
26594: lv_column_names VARCHAR2(5000); --stores concatenated column names
26595: lv_batch_id msc_st_safety_stocks.batch_id%TYPE;
26596: lv_message_text msc_errors.error_text%TYPE;
26597:
26598: ex_logging_err EXCEPTION;
26599:
26600: CURSOR c1(p_batch_id NUMBER) IS

Line 27042: lv_message_text msc_errors.error_text%TYPE;

27038: lv_where_str VARCHAR2(5000);
27039: lv_sql_stmt VARCHAR2(5000);
27040: lv_column_names VARCHAR2(5000); --stores concatenated column names
27041: lv_batch_id msc_st_item_categories.batch_id%TYPE;
27042: lv_message_text msc_errors.error_text%TYPE;
27043:
27044: ex_logging_err EXCEPTION;
27045:
27046:

Line 27644: lv_message_text msc_errors.error_text%TYPE;

27640: lv_default_assignment_set msc_st_item_sourcing.sourcing_rule_name%TYPE
27641: := 'ASET' ;
27642: lv_default_category_set msc_st_category_sets.category_set_name%TYPE := NULL_CHAR ;
27643: lv_batch_id msc_st_item_sourcing.batch_id%TYPE;
27644: lv_message_text msc_errors.error_text%TYPE;
27645:
27646: ex_logging_err EXCEPTION;
27647:
27648:

Line 29646: lv_message_text msc_errors.error_text%TYPE;

29642: lv_where_str VARCHAR2(5000);
29643: lv_sql_stmt VARCHAR2(5000);
29644: lv_cursor_stmt VARCHAR2(5000);
29645: lv_batch_id msc_st_project_tasks.batch_id%TYPE;
29646: lv_message_text msc_errors.error_text%TYPE;
29647:
29648: ex_logging_err EXCEPTION;
29649:
29650: CURSOR c2(p_batch_id NUMBER) IS

Line 30473: lv_message_text msc_errors.error_text%TYPE;

30469: lv_cursor_stmt VARCHAR2(5000);
30470:
30471: lv_simulation_set msc_st_resource_changes.simulation_set%type;
30472: lv_batch_id msc_st_department_resources.batch_id%TYPE;
30473: lv_message_text msc_errors.error_text%TYPE;
30474:
30475:
30476: ex_logging_err EXCEPTION;
30477:

Line 33158: lv_message_text msc_errors.error_text%TYPE;

33154: lv_error_text VARCHAR2(250);
33155: lv_cursor_stmt VARCHAR2(5000);
33156: lv_batch_id msc_st_resource_setups.batch_id%TYPE;
33157: lv_sql_stmt VARCHAR2(5000);
33158: lv_message_text msc_errors.error_text%TYPE;
33159: lv_column_names VARCHAR2(5000); --stores concatenated column names
33160: CURSOR c2(p_batch_id NUMBER) IS
33161: SELECT rowid
33162: FROM msc_st_resource_setups

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

33446: IF lv_return <> 0 THEN
33447: RAISE ex_logging_err;
33448: END IF;
33449:
33450: -- Inserting all the errored out records into MSC_ERRORS
33451:
33452: lv_return := MSC_ST_UTIL.LOG_ERROR
33453: (p_table_name => 'MSC_ST_RESOURCE_SETUPS',
33454: p_instance_code => v_instance_code,

Line 33493: lv_message_text msc_errors.error_text%TYPE;

33489: TYPE RowidTab IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
33490: TYPE CurTyp IS REF CURSOR;
33491: c1 CurTyp;
33492: lv_return NUMBER;
33493: lv_message_text msc_errors.error_text%TYPE;
33494: lv_error_text VARCHAR2(250);
33495: lv_sql_stmt VARCHAR2(5000);
33496: lv_cursor_stmt VARCHAR2(5000);
33497: lv_batch_id msc_st_setup_transitions.batch_id%TYPE;

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

33869: IF lv_return <> 0 THEN
33870: RAISE ex_logging_err;
33871: END IF;
33872:
33873: -- Inserting all the errored out records into MSC_ERRORS
33874:
33875: lv_return := MSC_ST_UTIL.LOG_ERROR
33876: (p_table_name => 'MSC_ST_SETUP_TRANSITIONS',
33877: p_instance_code => v_instance_code,

Line 33940: lv_message_text msc_errors.error_text%TYPE;

33936: lv_error_text VARCHAR2(250);
33937: lv_where_str VARCHAR2(5000);
33938: lv_sql_stmt VARCHAR2(5000);
33939: lv_column_names VARCHAR2(5000); --stores concatenated column names
33940: lv_message_text msc_errors.error_text%TYPE;
33941: ex_logging_err EXCEPTION;
33942: busy EXCEPTION;
33943: PRAGMA EXCEPTION_INIT(busy, -54);
33944:

Line 35756: lv_message_text msc_errors.error_text%TYPE;

35752: lv_error_text VARCHAR2(250);
35753: lv_where_str VARCHAR2(5000);
35754: lv_sql_stmt VARCHAR2(5000);
35755: lv_cursor_stmt VARCHAR2(5000);
35756: lv_message_text msc_errors.error_text%TYPE;
35757: lv_batch_id NUMBER;
35758:
35759: lv_retain_src_header_line_id NUMBER; -- 12620427
35760: lv_apps_ver NUMBER;

Line 37473: lv_message_text msc_errors.error_text%TYPE;

37469: lv_error_text VARCHAR2(250);
37470: lv_where_str VARCHAR2(5000);
37471: lv_sql_stmt VARCHAR2(5000);
37472: lv_column_names VARCHAR2(5000); --stores concatenated column names
37473: lv_message_text msc_errors.error_text%TYPE;
37474:
37475: ex_logging_err EXCEPTION;
37476:
37477: CURSOR c1(p_batch_id NUMBER) IS

Line 38569: lv_message_text msc_errors.error_text%TYPE;

38565: lv_error_text VARCHAR2(250);
38566: lv_where_str VARCHAR2(5000);
38567: lv_sql_stmt VARCHAR2(5000);
38568: lv_cursor_stmt VARCHAR2(5000);
38569: lv_message_text msc_errors.error_text%TYPE;
38570:
38571: ex_logging_err EXCEPTION;
38572:
38573: CURSOR c1(p_batch_id NUMBER) IS

Line 39816: lv_message_text msc_errors.error_text%TYPE;

39812: lv_return NUMBER;
39813: lv_error_text VARCHAR2(250);
39814: lv_sql_stmt VARCHAR2(5000);
39815: lv_batch_id msc_st_company_users.batch_id%TYPE;
39816: lv_message_text msc_errors.error_text%TYPE;
39817:
39818: TYPE RowidTab IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
39819: lb_rowid RowidTab;
39820:

Line 40417: lv_message_text msc_errors.error_text%TYPE;

40413: lv_where_str VARCHAR2(5000);
40414: lv_sql_stmt VARCHAR2(5000);
40415: lv_cursor_stmt VARCHAR2(5000);
40416: lv_batch_id msc_st_boms.batch_id%TYPE;
40417: lv_message_text msc_errors.error_text%TYPE;
40418:
40419: ex_logging_err EXCEPTION;
40420:
40421: CURSOR c2(p_batch_id NUMBER) IS

Line 43475: lv_message_text msc_errors.error_text%TYPE;

43471: lv_where_str VARCHAR2(5000);
43472: lv_sql_stmt VARCHAR2(5000);
43473: lv_cursor_stmt VARCHAR2(5000);
43474: lv_batch_id msc_st_routings.batch_id%TYPE;
43475: lv_message_text msc_errors.error_text%TYPE;
43476: ex_logging_err EXCEPTION;
43477:
43478:
43479: CURSOR c2(p_batch_id NUMBER) IS

Line 47303: lv_message_text msc_errors.error_text%TYPE;

47299: lv_error_text VARCHAR2(250);
47300: lv_where_str VARCHAR2(5000);
47301: lv_sql_stmt VARCHAR2(5000);
47302: lv_column_names VARCHAR2(5000); --stores concatenated column names
47303: lv_message_text msc_errors.error_text%TYPE;
47304: lv_batch_id msc_st_supplies.batch_id%TYPE;
47305: ex_logging_err EXCEPTION;
47306:
47307: CURSOR c1(p_batch_id NUMBER) IS

Line 48394: lv_message_text msc_errors.error_text%TYPE;

48390: lv_where_str VARCHAR2(5000);
48391: lv_sql_stmt VARCHAR2(5000);
48392: lv_cursor_stmt VARCHAR2(5000);
48393: lv_batch_id msc_st_resource_requirements.batch_id%TYPE;
48394: lv_message_text msc_errors.error_text%TYPE;
48395:
48396: ex_logging_err EXCEPTION;
48397:
48398: CURSOR c2(p_batch_id NUMBER) IS

Line 49660: lv_message_text msc_errors.error_text%TYPE;

49656: lv_where_str VARCHAR2(5000);
49657: lv_sql_stmt VARCHAR2(5000);
49658: lv_cursor_stmt VARCHAR2(5000);
49659: lv_batch_id msc_st_demands.batch_id%TYPE;
49660: lv_message_text msc_errors.error_text%TYPE;
49661:
49662: ex_logging_err EXCEPTION;
49663:
49664: CURSOR c1(p_batch_id NUMBER) IS

Line 50750: lv_message_text msc_errors.error_text%TYPE;

50746: lv_where_str VARCHAR2(5000);
50747: lv_sql_stmt VARCHAR2(5000);
50748: lv_cursor_stmt VARCHAR2(5000);
50749: lv_batch_id msc_st_routings.batch_id%TYPE;
50750: lv_message_text msc_errors.error_text%TYPE;
50751: ex_logging_err EXCEPTION;
50752:
50753:
50754: CURSOR c2(p_batch_id NUMBER) IS

Line 54220: lv_message_text msc_errors.error_text%TYPE;

54216: IS
54217: lv_return NUMBER;
54218: lv_error_text VARCHAR2(250);
54219: lv_sql_stmt VARCHAR2(5000);
54220: lv_message_text msc_errors.error_text%TYPE;
54221: ex_logging_err EXCEPTION;
54222: BEGIN
54223: -- items
54224: -- Validation for table msc_st_system_items

Line 54883: lv_message_text msc_errors.error_text%TYPE;

54879: lv_error_text VARCHAR2(250);
54880: lv_where_str VARCHAR2(5000);
54881: lv_sql_stmt VARCHAR2(5000);
54882: lv_batch_id msc_st_system_items.batch_id%TYPE;
54883: lv_message_text msc_errors.error_text%TYPE;
54884:
54885: ex_logging_err EXCEPTION;
54886: busy EXCEPTION;
54887: PRAGMA EXCEPTION_INIT(busy, -54);

Line 55513: lv_message_text msc_errors.error_text%TYPE;

55509: IS
55510: lv_sql_stmt VARCHAR2(1000);
55511: lv_error_text VARCHAR2(1000);
55512: ln_count NUMBER := 0;
55513: lv_message_text msc_errors.error_text%TYPE;
55514: lv_return NUMBER;
55515: lv_column_names VARCHAR2(100);
55516: ex_logging_err EXCEPTION;
55517:

Line 58450: -------------- Get current ERROR_ID from MSC_ERRORS ---

58446: --=========== call the main tasks here===================
58447:
58448: IF v_req_data IN (G_NEW_REQUEST,G_CAL_REQ_DATA) THEN
58449:
58450: -------------- Get current ERROR_ID from MSC_ERRORS ---
58451: IF (nvl(v_parent_request_id,-1) < 1) THEN
58452: SELECT max(ERROR_ID) INTO v_error_no_begin FROM MSC_ERRORS;
58453: END IF;
58454:

Line 58452: SELECT max(ERROR_ID) INTO v_error_no_begin FROM MSC_ERRORS;

58448: IF v_req_data IN (G_NEW_REQUEST,G_CAL_REQ_DATA) THEN
58449:
58450: -------------- Get current ERROR_ID from MSC_ERRORS ---
58451: IF (nvl(v_parent_request_id,-1) < 1) THEN
58452: SELECT max(ERROR_ID) INTO v_error_no_begin FROM MSC_ERRORS;
58453: END IF;
58454:
58455:
58456: -- initiaize global variables

Line 59601: -- get current ERROR_ID from MSC_ERRORS

59597: -- send error/ warning emails for the errors/ warnings encountered
59598: -- during pre processing
59599: -- SEND_ERROR ;
59600:
59601: -- get current ERROR_ID from MSC_ERRORS
59602: IF (nvl(v_parent_request_id,-1) < 1) THEN
59603: select max(ERROR_ID) into v_error_no_end from MSC_ERRORS;
59604: END IF;
59605:

Line 59603: select max(ERROR_ID) into v_error_no_end from MSC_ERRORS;

59599: -- SEND_ERROR ;
59600:
59601: -- get current ERROR_ID from MSC_ERRORS
59602: IF (nvl(v_parent_request_id,-1) < 1) THEN
59603: select max(ERROR_ID) into v_error_no_end from MSC_ERRORS;
59604: END IF;
59605:
59606: -- write summary of errors and warning encountered into log
59607: WRITE_ERROR_SUMM_LOG(nvl(v_parent_request_id,-1));