871: lv_conc_prog_name(19) := 'Costing Process';
872: lv_conc_prog_name(20) := 'Costing Summary Report';
873: lv_conc_prog_name(21) := 'Costing Detail Report';
874:
875: -- wf_core.clear;
876:
877: -- make sure the process terminated by aborting it first
878: -- begin
879: -- wf_engine.abortprocess(ItemType, ItemKey);
1343:
1344: -- BEE Transfer
1345: If p_batch_id is not null then
1346: lv_is_batch := 'Y';
1347: lv_prc_list := lv_prc_list||lv_conc_prog_name(1)||wf_core.newline;
1348: lv_prc_list_html := lv_prc_list_html||'
'||lv_conc_prog_name(1)||'
';
1354:
1355: If ((p_retro_assignment_set_name is not null) and
1356: (p_event_group is not null )) then
1357: lv_is_retro_ntfy := 'Y';
1358: lv_prc_list := lv_prc_list||lv_conc_prog_name(2)||wf_core.newline;
1359: lv_prc_list_html := lv_prc_list_html||'
'||lv_conc_prog_name(2)||'
';
1365:
1366: If ((p_exception_report_name is not null) OR
1367: (p_exception_group_name is not null)) then
1368: lv_is_payroll_exception_report := 'Y';
1369: lv_prc_list := lv_prc_list||lv_conc_prog_name(1)||wf_core.newline;
1370: lv_prc_list_html := lv_prc_list_html||'
'||lv_conc_prog_name(1)||'
';
1375: -- NACHA
1376:
1377: If p_nacha_payment_method is not null then
1378: lv_is_nacha := 'Y';
1379: lv_prc_list := lv_prc_list||lv_conc_prog_name(1)||wf_core.newline;
1380: lv_prc_list_html := lv_prc_list_html||'
'||lv_conc_prog_name(1)||'
';
1385: -- Check
1386: If (p_check_writer_payment_method is not null ) and
1387: (p_start_check_number is not null ) then
1388: lv_is_check := 'Y';
1389: lv_prc_list := lv_prc_list||lv_conc_prog_name(1)||wf_core.newline;
1390: lv_prc_list_html := lv_prc_list_html||'
'||lv_conc_prog_name(1)||'
';
1395: -- Third Party Check
1396:
1397: If p_payment_method_3rd_party is not null then
1398: lv_is_third_party_check := 'Y';
1399: lv_prc_list := lv_prc_list||lv_conc_prog_name(1)||wf_core.newline;
1400: lv_prc_list_html := lv_prc_list_html||'
'||lv_conc_prog_name(1)||'
';
1405: -- Deposit Advice
1406:
1407: If p_da_report_category is not null then
1408: lv_is_deposit_advice := 'Y';
1409: lv_prc_list := lv_prc_list||lv_conc_prog_name(1)||wf_core.newline;
1410: lv_prc_list_html := lv_prc_list_html||'
'||lv_conc_prog_name(1)||'
';
1418: (p_element_classification is not null) or
1419: (p_element is not null))
1420: then
1421: lv_is_ele_reg := 'Y';
1422: lv_prc_list := lv_prc_list||lv_conc_prog_name(16)||wf_core.newline;
1423: lv_prc_list_html := lv_prc_list_html||'
'||lv_conc_prog_name(16)||'
';
1437:
1438: -- Costing Summary and Detail Report
1439: if ((p_consolidation_set_id is not null)) then
1440: lv_is_costing_detail := 'Y';
1441: lv_prc_list := lv_prc_list||lv_conc_prog_name(21)||wf_core.newline;
1442: lv_prc_list_html := lv_prc_list_html||'
'||lv_conc_prog_name(21)||'
';1442: lv_prc_list_html := lv_prc_list_html||'
'||lv_conc_prog_name(21)||'
';'||lv_conc_prog_name(20)||'
';
1453: lv_is_costing_detail := 'N';
1454: end if;
1455: l_message_subject1 := 'List of Processes and Reports which will be submitted.';
1456: if lv_isResponseRequired = 'Y' then
1457: l_message_text1 := 'Review the List of Processes and Reports which will be submitted based on the input parameters, please click on the '||''''||'Continue'||''''||' button to start processing.'||wf_core.newline||lv_prc_list;
1458:
1459: l_message_html_text1 := 'Review the List of Processes and Reports which will be submitted based on the input parameters, please click on the '||''''||'Continue'||''''||' to start processing.';
1460: else
1461: l_message_text1 := 'Review the List of Processes and Reports which will be submitted based on the input parameters.'||wf_core.newline||lv_prc_list;
1457: l_message_text1 := 'Review the List of Processes and Reports which will be submitted based on the input parameters, please click on the '||''''||'Continue'||''''||' button to start processing.'||wf_core.newline||lv_prc_list;
1458:
1459: l_message_html_text1 := 'Review the List of Processes and Reports which will be submitted based on the input parameters, please click on the '||''''||'Continue'||''''||' to start processing.';
1460: else
1461: l_message_text1 := 'Review the List of Processes and Reports which will be submitted based on the input parameters.'||wf_core.newline||lv_prc_list;
1462:
1463: l_message_html_text1 := 'Review the List of Processes and Reports which will be submitted based on the input parameters.';
1464: end if;
1465:
2284:
2285:
2286: exception
2287: when others then
2288: WF_CORE.Context('PAY_WF_PKG', 'StartProcess',ItemType, RequestorUsername, ProcessOwner, Workflowprocess);
2289:
2290: error;
2291: RAISE;
2292:
2594: lv_conc_prog_name(19) := 'Costing Process';
2595: lv_conc_prog_name(20) := 'Costing Summary Report';
2596: lv_conc_prog_name(21) := 'Costing Detail Report';
2597:
2598: -- wf_core.clear;
2599:
2600: -- make sure the process terminated by aborting it first
2601: -- begin
2602: -- wf_engine.abortprocess(ItemType, ItemKey);
3073:
3074: -- BEE Transfer
3075: If p_batch_id is not null then
3076: lv_is_batch := 'Y';
3077: lv_prc_list := lv_prc_list||lv_conc_prog_name(1)||wf_core.newline;
3078: lv_prc_list_html := lv_prc_list_html||'
'||lv_conc_prog_name(1)||'
';
3084:
3085: /* If ((p_retro_assignment_set_name is not null) and
3086: (p_event_group is not null )) then
3087: lv_is_retro_ntfy := 'Y';
3088: lv_prc_list := lv_prc_list||lv_conc_prog_name(2)||wf_core.newline;
3089: lv_prc_list_html := lv_prc_list_html||'
'||lv_conc_prog_name(2)||'
';
3093: -- Retro Notification Report (enhanced) PDF
3094: -- bug 12704242
3095: if (p_retro_template_name is not null) then
3096: lv_is_retro_ntfy := 'Y';
3097: lv_prc_list := lv_prc_list||lv_conc_prog_name(2)||wf_core.newline;
3098: lv_prc_list_html := lv_prc_list_html||'
'||lv_conc_prog_name(2)||'
';
3104:
3105: If ((p_exception_report_name is not null) OR
3106: (p_exception_group_name is not null)) then
3107: lv_is_payroll_exception_report := 'Y';
3108: lv_prc_list := lv_prc_list||lv_conc_prog_name(1)||wf_core.newline;
3109: lv_prc_list_html := lv_prc_list_html||'
'||lv_conc_prog_name(1)||'
';
3114: -- NACHA
3115:
3116: If p_nacha_payment_method is not null then
3117: lv_is_nacha := 'Y';
3118: lv_prc_list := lv_prc_list||lv_conc_prog_name(1)||wf_core.newline;
3119: lv_prc_list_html := lv_prc_list_html||'
'||lv_conc_prog_name(1)||'
';
3124: -- Check
3125: If (p_check_writer_payment_method is not null ) and
3126: (p_start_check_number is not null ) then
3127: lv_is_check := 'Y';
3128: lv_prc_list := lv_prc_list||lv_conc_prog_name(1)||wf_core.newline;
3129: lv_prc_list_html := lv_prc_list_html||'
'||lv_conc_prog_name(1)||'
';
3134: -- Third Party Check
3135:
3136: If p_payment_method_3rd_party is not null then
3137: lv_is_third_party_check := 'Y';
3138: lv_prc_list := lv_prc_list||lv_conc_prog_name(1)||wf_core.newline;
3139: lv_prc_list_html := lv_prc_list_html||'
'||lv_conc_prog_name(1)||'
';
3144: -- Deposit Advice
3145:
3146: If p_da_report_category is not null then
3147: lv_is_deposit_advice := 'Y';
3148: lv_prc_list := lv_prc_list||lv_conc_prog_name(1)||wf_core.newline;
3149: lv_prc_list_html := lv_prc_list_html||'
'||lv_conc_prog_name(1)||'
';
3157: (p_element_classification is not null) or
3158: (p_element is not null))
3159: then
3160: lv_is_ele_reg := 'Y';
3161: lv_prc_list := lv_prc_list||lv_conc_prog_name(16)||wf_core.newline;
3162: lv_prc_list_html := lv_prc_list_html||'
'||lv_conc_prog_name(16)||'
';
3176:
3177: -- Costing Summary and Detail Report
3178: if ((p_consolidation_set_id is not null)) then
3179: lv_is_costing_detail := 'Y';
3180: lv_prc_list := lv_prc_list||lv_conc_prog_name(21)||wf_core.newline;
3181: lv_prc_list_html := lv_prc_list_html||'
'||lv_conc_prog_name(21)||'
';3181: lv_prc_list_html := lv_prc_list_html||'
'||lv_conc_prog_name(21)||'
';'||lv_conc_prog_name(20)||'
';
3192: lv_is_costing_detail := 'N';
3193: end if;
3194: l_message_subject1 := 'List of Processes and Reports which will be submitted.';
3195: if lv_isResponseRequired = 'Y' then
3196: l_message_text1 := 'Review the List of Processes and Reports which will be submitted based on the input parameters, please click on the '||''''||'Continue'||''''||' button to start processing.'||wf_core.newline||lv_prc_list;
3197:
3198: l_message_html_text1 := 'Review the List of Processes and Reports which will be submitted based on the input parameters, please click on the '||''''||'Continue'||''''||' to start processing.';
3199: else
3200: l_message_text1 := 'Review the List of Processes and Reports which will be submitted based on the input parameters.'||wf_core.newline||lv_prc_list;
3196: l_message_text1 := 'Review the List of Processes and Reports which will be submitted based on the input parameters, please click on the '||''''||'Continue'||''''||' button to start processing.'||wf_core.newline||lv_prc_list;
3197:
3198: l_message_html_text1 := 'Review the List of Processes and Reports which will be submitted based on the input parameters, please click on the '||''''||'Continue'||''''||' to start processing.';
3199: else
3200: l_message_text1 := 'Review the List of Processes and Reports which will be submitted based on the input parameters.'||wf_core.newline||lv_prc_list;
3201:
3202: l_message_html_text1 := 'Review the List of Processes and Reports which will be submitted based on the input parameters.';
3203: end if;
3204:
4047:
4048:
4049: exception
4050: when others then
4051: WF_CORE.Context('PAY_WF_PKG', 'StartProcess',ItemType, RequestorUsername, ProcessOwner, Workflowprocess);
4052:
4053: error;
4054: RAISE;
4055:
4144: begin
4145: /*
4146: dbms_output.put_line('Run time error in test script');
4147: dbms_output.put_line('Sqlerror: '||sqlerrm);
4148: dbms_output.put_line('Errname: '||wf_core.error_name);
4149: dbms_output.put_line('Errmsg: '||substr(wf_core.error_message, 1, 200));
4150: dbms_output.put_line('Stack1: '||substr(wf_core.error_stack, 1, 200));
4151: dbms_output.put_line('Stack2: '||substr(wf_core.error_stack, 200, 200));
4152: dbms_output.put_line('Stack3: '||substr(wf_core.error_stack, 400, 200));
4145: /*
4146: dbms_output.put_line('Run time error in test script');
4147: dbms_output.put_line('Sqlerror: '||sqlerrm);
4148: dbms_output.put_line('Errname: '||wf_core.error_name);
4149: dbms_output.put_line('Errmsg: '||substr(wf_core.error_message, 1, 200));
4150: dbms_output.put_line('Stack1: '||substr(wf_core.error_stack, 1, 200));
4151: dbms_output.put_line('Stack2: '||substr(wf_core.error_stack, 200, 200));
4152: dbms_output.put_line('Stack3: '||substr(wf_core.error_stack, 400, 200));
4153: dbms_output.put_line('Stack4: '||substr(wf_core.error_stack, 600, 200));
4146: dbms_output.put_line('Run time error in test script');
4147: dbms_output.put_line('Sqlerror: '||sqlerrm);
4148: dbms_output.put_line('Errname: '||wf_core.error_name);
4149: dbms_output.put_line('Errmsg: '||substr(wf_core.error_message, 1, 200));
4150: dbms_output.put_line('Stack1: '||substr(wf_core.error_stack, 1, 200));
4151: dbms_output.put_line('Stack2: '||substr(wf_core.error_stack, 200, 200));
4152: dbms_output.put_line('Stack3: '||substr(wf_core.error_stack, 400, 200));
4153: dbms_output.put_line('Stack4: '||substr(wf_core.error_stack, 600, 200));
4154: dbms_output.put_line('Stack5: '||substr(wf_core.error_stack, 800, 200));
4147: dbms_output.put_line('Sqlerror: '||sqlerrm);
4148: dbms_output.put_line('Errname: '||wf_core.error_name);
4149: dbms_output.put_line('Errmsg: '||substr(wf_core.error_message, 1, 200));
4150: dbms_output.put_line('Stack1: '||substr(wf_core.error_stack, 1, 200));
4151: dbms_output.put_line('Stack2: '||substr(wf_core.error_stack, 200, 200));
4152: dbms_output.put_line('Stack3: '||substr(wf_core.error_stack, 400, 200));
4153: dbms_output.put_line('Stack4: '||substr(wf_core.error_stack, 600, 200));
4154: dbms_output.put_line('Stack5: '||substr(wf_core.error_stack, 800, 200));
4155: dbms_output.put_line('Stack6: '||substr(wf_core.error_stack, 1000, 200));
4148: dbms_output.put_line('Errname: '||wf_core.error_name);
4149: dbms_output.put_line('Errmsg: '||substr(wf_core.error_message, 1, 200));
4150: dbms_output.put_line('Stack1: '||substr(wf_core.error_stack, 1, 200));
4151: dbms_output.put_line('Stack2: '||substr(wf_core.error_stack, 200, 200));
4152: dbms_output.put_line('Stack3: '||substr(wf_core.error_stack, 400, 200));
4153: dbms_output.put_line('Stack4: '||substr(wf_core.error_stack, 600, 200));
4154: dbms_output.put_line('Stack5: '||substr(wf_core.error_stack, 800, 200));
4155: dbms_output.put_line('Stack6: '||substr(wf_core.error_stack, 1000, 200));
4156: dbms_output.put_line('Stack7: '||substr(wf_core.error_stack, 1200, 200));
4149: dbms_output.put_line('Errmsg: '||substr(wf_core.error_message, 1, 200));
4150: dbms_output.put_line('Stack1: '||substr(wf_core.error_stack, 1, 200));
4151: dbms_output.put_line('Stack2: '||substr(wf_core.error_stack, 200, 200));
4152: dbms_output.put_line('Stack3: '||substr(wf_core.error_stack, 400, 200));
4153: dbms_output.put_line('Stack4: '||substr(wf_core.error_stack, 600, 200));
4154: dbms_output.put_line('Stack5: '||substr(wf_core.error_stack, 800, 200));
4155: dbms_output.put_line('Stack6: '||substr(wf_core.error_stack, 1000, 200));
4156: dbms_output.put_line('Stack7: '||substr(wf_core.error_stack, 1200, 200));
4157: dbms_output.put_line('Stack8: '||substr(wf_core.error_stack, 1400, 200));
4150: dbms_output.put_line('Stack1: '||substr(wf_core.error_stack, 1, 200));
4151: dbms_output.put_line('Stack2: '||substr(wf_core.error_stack, 200, 200));
4152: dbms_output.put_line('Stack3: '||substr(wf_core.error_stack, 400, 200));
4153: dbms_output.put_line('Stack4: '||substr(wf_core.error_stack, 600, 200));
4154: dbms_output.put_line('Stack5: '||substr(wf_core.error_stack, 800, 200));
4155: dbms_output.put_line('Stack6: '||substr(wf_core.error_stack, 1000, 200));
4156: dbms_output.put_line('Stack7: '||substr(wf_core.error_stack, 1200, 200));
4157: dbms_output.put_line('Stack8: '||substr(wf_core.error_stack, 1400, 200));
4158: dbms_output.put_line('Stack9: '||substr(wf_core.error_stack, 1600, 200));
4151: dbms_output.put_line('Stack2: '||substr(wf_core.error_stack, 200, 200));
4152: dbms_output.put_line('Stack3: '||substr(wf_core.error_stack, 400, 200));
4153: dbms_output.put_line('Stack4: '||substr(wf_core.error_stack, 600, 200));
4154: dbms_output.put_line('Stack5: '||substr(wf_core.error_stack, 800, 200));
4155: dbms_output.put_line('Stack6: '||substr(wf_core.error_stack, 1000, 200));
4156: dbms_output.put_line('Stack7: '||substr(wf_core.error_stack, 1200, 200));
4157: dbms_output.put_line('Stack8: '||substr(wf_core.error_stack, 1400, 200));
4158: dbms_output.put_line('Stack9: '||substr(wf_core.error_stack, 1600, 200));
4159: dbms_output.put_line('Stack10: '||substr(wf_core.error_stack, 1800, 200));
4152: dbms_output.put_line('Stack3: '||substr(wf_core.error_stack, 400, 200));
4153: dbms_output.put_line('Stack4: '||substr(wf_core.error_stack, 600, 200));
4154: dbms_output.put_line('Stack5: '||substr(wf_core.error_stack, 800, 200));
4155: dbms_output.put_line('Stack6: '||substr(wf_core.error_stack, 1000, 200));
4156: dbms_output.put_line('Stack7: '||substr(wf_core.error_stack, 1200, 200));
4157: dbms_output.put_line('Stack8: '||substr(wf_core.error_stack, 1400, 200));
4158: dbms_output.put_line('Stack9: '||substr(wf_core.error_stack, 1600, 200));
4159: dbms_output.put_line('Stack10: '||substr(wf_core.error_stack, 1800, 200));
4160: */
4153: dbms_output.put_line('Stack4: '||substr(wf_core.error_stack, 600, 200));
4154: dbms_output.put_line('Stack5: '||substr(wf_core.error_stack, 800, 200));
4155: dbms_output.put_line('Stack6: '||substr(wf_core.error_stack, 1000, 200));
4156: dbms_output.put_line('Stack7: '||substr(wf_core.error_stack, 1200, 200));
4157: dbms_output.put_line('Stack8: '||substr(wf_core.error_stack, 1400, 200));
4158: dbms_output.put_line('Stack9: '||substr(wf_core.error_stack, 1600, 200));
4159: dbms_output.put_line('Stack10: '||substr(wf_core.error_stack, 1800, 200));
4160: */
4161:
4154: dbms_output.put_line('Stack5: '||substr(wf_core.error_stack, 800, 200));
4155: dbms_output.put_line('Stack6: '||substr(wf_core.error_stack, 1000, 200));
4156: dbms_output.put_line('Stack7: '||substr(wf_core.error_stack, 1200, 200));
4157: dbms_output.put_line('Stack8: '||substr(wf_core.error_stack, 1400, 200));
4158: dbms_output.put_line('Stack9: '||substr(wf_core.error_stack, 1600, 200));
4159: dbms_output.put_line('Stack10: '||substr(wf_core.error_stack, 1800, 200));
4160: */
4161:
4162: hr_utility.trace('Run time error in test script');
4155: dbms_output.put_line('Stack6: '||substr(wf_core.error_stack, 1000, 200));
4156: dbms_output.put_line('Stack7: '||substr(wf_core.error_stack, 1200, 200));
4157: dbms_output.put_line('Stack8: '||substr(wf_core.error_stack, 1400, 200));
4158: dbms_output.put_line('Stack9: '||substr(wf_core.error_stack, 1600, 200));
4159: dbms_output.put_line('Stack10: '||substr(wf_core.error_stack, 1800, 200));
4160: */
4161:
4162: hr_utility.trace('Run time error in test script');
4163: hr_utility.trace('Sqlerror: '||sqlerrm);
4160: */
4161:
4162: hr_utility.trace('Run time error in test script');
4163: hr_utility.trace('Sqlerror: '||sqlerrm);
4164: hr_utility.trace('Errname: '||wf_core.error_name);
4165: hr_utility.trace('Errmsg: '||substr(wf_core.error_message, 1, 200));
4166: hr_utility.trace('Stack1: '||substr(wf_core.error_stack, 1, 200));
4167: hr_utility.trace('Stack2: '||substr(wf_core.error_stack, 200, 200));
4168: hr_utility.trace('Stack3: '||substr(wf_core.error_stack, 400, 200));
4161:
4162: hr_utility.trace('Run time error in test script');
4163: hr_utility.trace('Sqlerror: '||sqlerrm);
4164: hr_utility.trace('Errname: '||wf_core.error_name);
4165: hr_utility.trace('Errmsg: '||substr(wf_core.error_message, 1, 200));
4166: hr_utility.trace('Stack1: '||substr(wf_core.error_stack, 1, 200));
4167: hr_utility.trace('Stack2: '||substr(wf_core.error_stack, 200, 200));
4168: hr_utility.trace('Stack3: '||substr(wf_core.error_stack, 400, 200));
4169: hr_utility.trace('Stack4: '||substr(wf_core.error_stack, 600, 200));
4162: hr_utility.trace('Run time error in test script');
4163: hr_utility.trace('Sqlerror: '||sqlerrm);
4164: hr_utility.trace('Errname: '||wf_core.error_name);
4165: hr_utility.trace('Errmsg: '||substr(wf_core.error_message, 1, 200));
4166: hr_utility.trace('Stack1: '||substr(wf_core.error_stack, 1, 200));
4167: hr_utility.trace('Stack2: '||substr(wf_core.error_stack, 200, 200));
4168: hr_utility.trace('Stack3: '||substr(wf_core.error_stack, 400, 200));
4169: hr_utility.trace('Stack4: '||substr(wf_core.error_stack, 600, 200));
4170: hr_utility.trace('Stack5: '||substr(wf_core.error_stack, 800, 200));
4163: hr_utility.trace('Sqlerror: '||sqlerrm);
4164: hr_utility.trace('Errname: '||wf_core.error_name);
4165: hr_utility.trace('Errmsg: '||substr(wf_core.error_message, 1, 200));
4166: hr_utility.trace('Stack1: '||substr(wf_core.error_stack, 1, 200));
4167: hr_utility.trace('Stack2: '||substr(wf_core.error_stack, 200, 200));
4168: hr_utility.trace('Stack3: '||substr(wf_core.error_stack, 400, 200));
4169: hr_utility.trace('Stack4: '||substr(wf_core.error_stack, 600, 200));
4170: hr_utility.trace('Stack5: '||substr(wf_core.error_stack, 800, 200));
4171: hr_utility.trace('Stack6: '||substr(wf_core.error_stack, 1000, 200));
4164: hr_utility.trace('Errname: '||wf_core.error_name);
4165: hr_utility.trace('Errmsg: '||substr(wf_core.error_message, 1, 200));
4166: hr_utility.trace('Stack1: '||substr(wf_core.error_stack, 1, 200));
4167: hr_utility.trace('Stack2: '||substr(wf_core.error_stack, 200, 200));
4168: hr_utility.trace('Stack3: '||substr(wf_core.error_stack, 400, 200));
4169: hr_utility.trace('Stack4: '||substr(wf_core.error_stack, 600, 200));
4170: hr_utility.trace('Stack5: '||substr(wf_core.error_stack, 800, 200));
4171: hr_utility.trace('Stack6: '||substr(wf_core.error_stack, 1000, 200));
4172: hr_utility.trace('Stack7: '||substr(wf_core.error_stack, 1200, 200));
4165: hr_utility.trace('Errmsg: '||substr(wf_core.error_message, 1, 200));
4166: hr_utility.trace('Stack1: '||substr(wf_core.error_stack, 1, 200));
4167: hr_utility.trace('Stack2: '||substr(wf_core.error_stack, 200, 200));
4168: hr_utility.trace('Stack3: '||substr(wf_core.error_stack, 400, 200));
4169: hr_utility.trace('Stack4: '||substr(wf_core.error_stack, 600, 200));
4170: hr_utility.trace('Stack5: '||substr(wf_core.error_stack, 800, 200));
4171: hr_utility.trace('Stack6: '||substr(wf_core.error_stack, 1000, 200));
4172: hr_utility.trace('Stack7: '||substr(wf_core.error_stack, 1200, 200));
4173: hr_utility.trace('Stack8: '||substr(wf_core.error_stack, 1400, 200));
4166: hr_utility.trace('Stack1: '||substr(wf_core.error_stack, 1, 200));
4167: hr_utility.trace('Stack2: '||substr(wf_core.error_stack, 200, 200));
4168: hr_utility.trace('Stack3: '||substr(wf_core.error_stack, 400, 200));
4169: hr_utility.trace('Stack4: '||substr(wf_core.error_stack, 600, 200));
4170: hr_utility.trace('Stack5: '||substr(wf_core.error_stack, 800, 200));
4171: hr_utility.trace('Stack6: '||substr(wf_core.error_stack, 1000, 200));
4172: hr_utility.trace('Stack7: '||substr(wf_core.error_stack, 1200, 200));
4173: hr_utility.trace('Stack8: '||substr(wf_core.error_stack, 1400, 200));
4174: hr_utility.trace('Stack9: '||substr(wf_core.error_stack, 1600, 200));
4167: hr_utility.trace('Stack2: '||substr(wf_core.error_stack, 200, 200));
4168: hr_utility.trace('Stack3: '||substr(wf_core.error_stack, 400, 200));
4169: hr_utility.trace('Stack4: '||substr(wf_core.error_stack, 600, 200));
4170: hr_utility.trace('Stack5: '||substr(wf_core.error_stack, 800, 200));
4171: hr_utility.trace('Stack6: '||substr(wf_core.error_stack, 1000, 200));
4172: hr_utility.trace('Stack7: '||substr(wf_core.error_stack, 1200, 200));
4173: hr_utility.trace('Stack8: '||substr(wf_core.error_stack, 1400, 200));
4174: hr_utility.trace('Stack9: '||substr(wf_core.error_stack, 1600, 200));
4175: hr_utility.trace('Stack10: '||substr(wf_core.error_stack, 1800, 200));
4168: hr_utility.trace('Stack3: '||substr(wf_core.error_stack, 400, 200));
4169: hr_utility.trace('Stack4: '||substr(wf_core.error_stack, 600, 200));
4170: hr_utility.trace('Stack5: '||substr(wf_core.error_stack, 800, 200));
4171: hr_utility.trace('Stack6: '||substr(wf_core.error_stack, 1000, 200));
4172: hr_utility.trace('Stack7: '||substr(wf_core.error_stack, 1200, 200));
4173: hr_utility.trace('Stack8: '||substr(wf_core.error_stack, 1400, 200));
4174: hr_utility.trace('Stack9: '||substr(wf_core.error_stack, 1600, 200));
4175: hr_utility.trace('Stack10: '||substr(wf_core.error_stack, 1800, 200));
4176:
4169: hr_utility.trace('Stack4: '||substr(wf_core.error_stack, 600, 200));
4170: hr_utility.trace('Stack5: '||substr(wf_core.error_stack, 800, 200));
4171: hr_utility.trace('Stack6: '||substr(wf_core.error_stack, 1000, 200));
4172: hr_utility.trace('Stack7: '||substr(wf_core.error_stack, 1200, 200));
4173: hr_utility.trace('Stack8: '||substr(wf_core.error_stack, 1400, 200));
4174: hr_utility.trace('Stack9: '||substr(wf_core.error_stack, 1600, 200));
4175: hr_utility.trace('Stack10: '||substr(wf_core.error_stack, 1800, 200));
4176:
4177: end error;
4170: hr_utility.trace('Stack5: '||substr(wf_core.error_stack, 800, 200));
4171: hr_utility.trace('Stack6: '||substr(wf_core.error_stack, 1000, 200));
4172: hr_utility.trace('Stack7: '||substr(wf_core.error_stack, 1200, 200));
4173: hr_utility.trace('Stack8: '||substr(wf_core.error_stack, 1400, 200));
4174: hr_utility.trace('Stack9: '||substr(wf_core.error_stack, 1600, 200));
4175: hr_utility.trace('Stack10: '||substr(wf_core.error_stack, 1800, 200));
4176:
4177: end error;
4178:
4171: hr_utility.trace('Stack6: '||substr(wf_core.error_stack, 1000, 200));
4172: hr_utility.trace('Stack7: '||substr(wf_core.error_stack, 1200, 200));
4173: hr_utility.trace('Stack8: '||substr(wf_core.error_stack, 1400, 200));
4174: hr_utility.trace('Stack9: '||substr(wf_core.error_stack, 1600, 200));
4175: hr_utility.trace('Stack10: '||substr(wf_core.error_stack, 1800, 200));
4176:
4177: end error;
4178:
4179: