APPS.PAY_CA_PAYREG_EXTRACT_PKG dependencies on HR_UTILITY

Line 179: hr_utility.set_location(gv_package_name || '.formated_data_string', 10);

175:
176: lv_format varchar2(1000);
177:
178: BEGIN
179: hr_utility.set_location(gv_package_name || '.formated_data_string', 10);
180: if p_output_file_type = 'CSV' then
181: hr_utility.set_location(gv_package_name || '.formated_data_string', 20);
182: lv_format := gc_csv_data_delimiter || p_input_string ||
183: gc_csv_data_delimiter || gc_csv_delimiter;

Line 181: hr_utility.set_location(gv_package_name || '.formated_data_string', 20);

177:
178: BEGIN
179: hr_utility.set_location(gv_package_name || '.formated_data_string', 10);
180: if p_output_file_type = 'CSV' then
181: hr_utility.set_location(gv_package_name || '.formated_data_string', 20);
182: lv_format := gc_csv_data_delimiter || p_input_string ||
183: gc_csv_data_delimiter || gc_csv_delimiter;
184: elsif p_output_file_type = 'HTML' then
185: if ltrim(rtrim(p_input_string)) is null then

Line 186: hr_utility.set_location(gv_package_name ||

182: lv_format := gc_csv_data_delimiter || p_input_string ||
183: gc_csv_data_delimiter || gc_csv_delimiter;
184: elsif p_output_file_type = 'HTML' then
185: if ltrim(rtrim(p_input_string)) is null then
186: hr_utility.set_location(gv_package_name ||
187: '.formated_data_string', 30);
188:
189: lv_format := gv_html_start_data || ' ' || gv_html_end_data;
190: else

Line 192: hr_utility.set_location(gv_package_name ||

188:
189: lv_format := gv_html_start_data || ' ' || gv_html_end_data;
190: else
191: if p_bold = 'Y' then
192: hr_utility.set_location(gv_package_name ||
193: '.formated_data_string',40);
194: if p_input_string = gv_tot_amt_lbl then
195: lv_format := ''||
196: ' ' || p_input_string|| '' || gv_html_end_data;

Line 202: hr_utility.set_location(gv_package_name ||

198: lv_format := gv_html_start_data || ' ' || p_input_string
199: || '' || gv_html_end_data;
200: end if;
201: else
202: hr_utility.set_location(gv_package_name ||
203: '.formated_data_string',50);
204:
205: lv_format := gv_html_start_data || p_input_string ||
206: gv_html_end_data;

Line 212: hr_utility.set_location(gv_package_name || '.formated_data_string', 60);

208: end if;
209: end if;
210: end if;
211:
212: hr_utility.set_location(gv_package_name || '.formated_data_string', 60);
213: return lv_format;
214:
215: END formated_data_string;
216:

Line 273: hr_utility.set_location(gv_package_name || '.formated_header_string', 10);

269:
270: lv_format varchar2(1000);
271:
272: BEGIN
273: hr_utility.set_location(gv_package_name || '.formated_header_string', 10);
274: if p_output_file_type = 'CSV' then
275: hr_utility.set_location(gv_package_name|| '.formated_header_string', 20);
276:
277: lv_format := p_input_string;

Line 275: hr_utility.set_location(gv_package_name|| '.formated_header_string', 20);

271:
272: BEGIN
273: hr_utility.set_location(gv_package_name || '.formated_header_string', 10);
274: if p_output_file_type = 'CSV' then
275: hr_utility.set_location(gv_package_name|| '.formated_header_string', 20);
276:
277: lv_format := p_input_string;
278: elsif p_output_file_type = 'HTML' then
279: hr_utility.set_location(gv_package_name|| '.formated_header_string', 30);

Line 279: hr_utility.set_location(gv_package_name|| '.formated_header_string', 30);

275: hr_utility.set_location(gv_package_name|| '.formated_header_string', 20);
276:
277: lv_format := p_input_string;
278: elsif p_output_file_type = 'HTML' then
279: hr_utility.set_location(gv_package_name|| '.formated_header_string', 30);
280: lv_format := '

Line 284: hr_utility.set_location(gv_package_name || '.formated_header_string', 40);

280: lv_format := '

Line 318: hr_utility.set_location(gv_package_name || '.formated_static_header', 10);

314: lv_leg_code varchar2(3);
315:
316: BEGIN
317:
318: hr_utility.set_location(gv_package_name || '.formated_static_header', 10);
319:
320: begin
321: select legislation_code into lv_leg_code
322: from per_business_groups

Line 405: hr_utility.set_location(gv_package_name || '.formated_static_header', 20);

401: 'PMT_NUM')
402: ,p_bold => 'Y'
403: ,p_output_file_type => p_output_file_type);
404:
405: hr_utility.set_location(gv_package_name || '.formated_static_header', 20);
406:
407: lv_format2 :=
408: formated_data_string (p_input_string =>
409: hr_general.decode_fnd_comm_lookup

Line 463: hr_utility.set_location(gv_package_name || '.formated_static_header', 30);

459: /*******************************************************************
460: ** Print the User Defined data for each Employee Assignment at the
461: ** end of the report
462: *******************************************************************/
463: hr_utility.set_location(gv_package_name || '.formated_static_header', 30);
464:
465:
466: /*******************************************************************
467: ** Only do this if there is some configuration data present

Line 487: hr_utility.trace('Static Label1 = ' || lv_format1);

483:
484:
485: p_static_label1 := lv_format1;
486: p_static_label2 := lv_format2;
487: hr_utility.trace('Static Label1 = ' || lv_format1);
488: hr_utility.trace('Static Label2 = ' || lv_format2);
489: hr_utility.set_location(gv_package_name || '.formated_static_header', 40);
490:
491: END;

Line 488: hr_utility.trace('Static Label2 = ' || lv_format2);

484:
485: p_static_label1 := lv_format1;
486: p_static_label2 := lv_format2;
487: hr_utility.trace('Static Label1 = ' || lv_format1);
488: hr_utility.trace('Static Label2 = ' || lv_format2);
489: hr_utility.set_location(gv_package_name || '.formated_static_header', 40);
490:
491: END;
492:

Line 489: hr_utility.set_location(gv_package_name || '.formated_static_header', 40);

485: p_static_label1 := lv_format1;
486: p_static_label2 := lv_format2;
487: hr_utility.trace('Static Label1 = ' || lv_format1);
488: hr_utility.trace('Static Label2 = ' || lv_format2);
489: hr_utility.set_location(gv_package_name || '.formated_static_header', 40);
490:
491: END;
492:
493:

Line 539: hr_utility.set_location(gv_package_name || '.formated_static_data_tp', 10);

535: sv_amount varchar2(200);
536:
537: BEGIN
538:
539: hr_utility.set_location(gv_package_name || '.formated_static_data_tp', 10);
540: lv_format1 :=
541: formated_data_string (p_input_string => p_payment_type
542: ,p_output_file_type => p_output_file_type) ||
543:

Line 567: hr_utility.set_location(gv_package_name || '.formated_static_data_tp', 20);

563:
564: formated_data_string (p_input_string => p_payment_number
565: ,p_output_file_type => p_output_file_type);
566:
567: hr_utility.set_location(gv_package_name || '.formated_static_data_tp', 20);
568:
569: if p_output_file_type = 'HTML' then
570: sv_amount := ''||p_payment_amount||gv_html_end_data;
571: elsif p_output_file_type = 'CSV' then

Line 601: hr_utility.set_location(gv_package_name || '.formated_static_data_tp', 30);

597: /*******************************************************************
598: ** Print the User Defined data for each Employee Assignment at the
599: ** end of the report
600: *******************************************************************/
601: hr_utility.set_location(gv_package_name || '.formated_static_data_tp', 30);
602: hr_utility.trace('Before Loop ');
603:
604: hr_utility.trace('Static Data1 = ' || lv_format1);
605: hr_utility.trace('Static Data2 = ' || lv_format2);

Line 602: hr_utility.trace('Before Loop ');

598: ** Print the User Defined data for each Employee Assignment at the
599: ** end of the report
600: *******************************************************************/
601: hr_utility.set_location(gv_package_name || '.formated_static_data_tp', 30);
602: hr_utility.trace('Before Loop ');
603:
604: hr_utility.trace('Static Data1 = ' || lv_format1);
605: hr_utility.trace('Static Data2 = ' || lv_format2);
606:

Line 604: hr_utility.trace('Static Data1 = ' || lv_format1);

600: *******************************************************************/
601: hr_utility.set_location(gv_package_name || '.formated_static_data_tp', 30);
602: hr_utility.trace('Before Loop ');
603:
604: hr_utility.trace('Static Data1 = ' || lv_format1);
605: hr_utility.trace('Static Data2 = ' || lv_format2);
606:
607: /*******************************************************************
608: ** Only do this if there is some configuration data present

Line 605: hr_utility.trace('Static Data2 = ' || lv_format2);

601: hr_utility.set_location(gv_package_name || '.formated_static_data_tp', 30);
602: hr_utility.trace('Before Loop ');
603:
604: hr_utility.trace('Static Data1 = ' || lv_format1);
605: hr_utility.trace('Static Data2 = ' || lv_format2);
606:
607: /*******************************************************************
608: ** Only do this if there is some configuration data present
609: *******************************************************************/

Line 628: hr_utility.trace('After Loop ');

624:
625:
626: p_static_data1 := lv_format1;
627: p_static_data2 := lv_format2;
628: hr_utility.trace('After Loop ');
629: hr_utility.trace('Static Data1 = ' || lv_format1);
630: hr_utility.trace('Static Data2 = ' || lv_format2);
631: hr_utility.set_location(gv_package_name || '.formated_static_data_tp', 40);
632:

Line 629: hr_utility.trace('Static Data1 = ' || lv_format1);

625:
626: p_static_data1 := lv_format1;
627: p_static_data2 := lv_format2;
628: hr_utility.trace('After Loop ');
629: hr_utility.trace('Static Data1 = ' || lv_format1);
630: hr_utility.trace('Static Data2 = ' || lv_format2);
631: hr_utility.set_location(gv_package_name || '.formated_static_data_tp', 40);
632:
633: END;

Line 630: hr_utility.trace('Static Data2 = ' || lv_format2);

626: p_static_data1 := lv_format1;
627: p_static_data2 := lv_format2;
628: hr_utility.trace('After Loop ');
629: hr_utility.trace('Static Data1 = ' || lv_format1);
630: hr_utility.trace('Static Data2 = ' || lv_format2);
631: hr_utility.set_location(gv_package_name || '.formated_static_data_tp', 40);
632:
633: END;
634:

Line 631: hr_utility.set_location(gv_package_name || '.formated_static_data_tp', 40);

627: p_static_data2 := lv_format2;
628: hr_utility.trace('After Loop ');
629: hr_utility.trace('Static Data1 = ' || lv_format1);
630: hr_utility.trace('Static Data2 = ' || lv_format2);
631: hr_utility.set_location(gv_package_name || '.formated_static_data_tp', 40);
632:
633: END;
634:
635:

Line 1003: hr_utility.set_location(gv_package_name || '.payment_extract', 10);

999:
1000: ln_defined_balance_id pay_org_payment_methods_f.defined_balance_id%TYPE; /* BUG: 5383895 added */
1001:
1002: BEGIN
1003: hr_utility.set_location(gv_package_name || '.payment_extract', 10);
1004: /* hr_utility.trace_on(null, 'ORACLE'); */
1005:
1006: hr_utility.trace('Payment Type ID = ' ||
1007: nvl(to_char(p_payment_type_id), 'NULL'));

Line 1004: /* hr_utility.trace_on(null, 'ORACLE'); */

1000: ln_defined_balance_id pay_org_payment_methods_f.defined_balance_id%TYPE; /* BUG: 5383895 added */
1001:
1002: BEGIN
1003: hr_utility.set_location(gv_package_name || '.payment_extract', 10);
1004: /* hr_utility.trace_on(null, 'ORACLE'); */
1005:
1006: hr_utility.trace('Payment Type ID = ' ||
1007: nvl(to_char(p_payment_type_id), 'NULL'));
1008: hr_utility.trace('Payment Method ID = ' ||

Line 1006: hr_utility.trace('Payment Type ID = ' ||

1002: BEGIN
1003: hr_utility.set_location(gv_package_name || '.payment_extract', 10);
1004: /* hr_utility.trace_on(null, 'ORACLE'); */
1005:
1006: hr_utility.trace('Payment Type ID = ' ||
1007: nvl(to_char(p_payment_type_id), 'NULL'));
1008: hr_utility.trace('Payment Method ID = ' ||
1009: nvl(to_char(p_payment_method_id), 'NULL'));
1010: hr_utility.trace('Consolidation Set ID = ' ||

Line 1008: hr_utility.trace('Payment Method ID = ' ||

1004: /* hr_utility.trace_on(null, 'ORACLE'); */
1005:
1006: hr_utility.trace('Payment Type ID = ' ||
1007: nvl(to_char(p_payment_type_id), 'NULL'));
1008: hr_utility.trace('Payment Method ID = ' ||
1009: nvl(to_char(p_payment_method_id), 'NULL'));
1010: hr_utility.trace('Consolidation Set ID = ' ||
1011: nvl(to_char(p_consolidation_set_id), 'NULL'));
1012: hr_utility.trace('Payroll ID = ' ||

Line 1010: hr_utility.trace('Consolidation Set ID = ' ||

1006: hr_utility.trace('Payment Type ID = ' ||
1007: nvl(to_char(p_payment_type_id), 'NULL'));
1008: hr_utility.trace('Payment Method ID = ' ||
1009: nvl(to_char(p_payment_method_id), 'NULL'));
1010: hr_utility.trace('Consolidation Set ID = ' ||
1011: nvl(to_char(p_consolidation_set_id), 'NULL'));
1012: hr_utility.trace('Payroll ID = ' ||
1013: nvl(to_char(p_payroll_id), 'NULL'));
1014: hr_utility.trace('Tax Unit ID = ' ||

Line 1012: hr_utility.trace('Payroll ID = ' ||

1008: hr_utility.trace('Payment Method ID = ' ||
1009: nvl(to_char(p_payment_method_id), 'NULL'));
1010: hr_utility.trace('Consolidation Set ID = ' ||
1011: nvl(to_char(p_consolidation_set_id), 'NULL'));
1012: hr_utility.trace('Payroll ID = ' ||
1013: nvl(to_char(p_payroll_id), 'NULL'));
1014: hr_utility.trace('Tax Unit ID = ' ||
1015: nvl(to_char(p_tax_unit_id), 'NULL'));
1016: hr_utility.trace('Business Group Id = ' ||

Line 1014: hr_utility.trace('Tax Unit ID = ' ||

1010: hr_utility.trace('Consolidation Set ID = ' ||
1011: nvl(to_char(p_consolidation_set_id), 'NULL'));
1012: hr_utility.trace('Payroll ID = ' ||
1013: nvl(to_char(p_payroll_id), 'NULL'));
1014: hr_utility.trace('Tax Unit ID = ' ||
1015: nvl(to_char(p_tax_unit_id), 'NULL'));
1016: hr_utility.trace('Business Group Id = ' ||
1017: nvl(to_char(p_business_group_id), 'NULL'));
1018: hr_utility.trace('Start Date = ' ||

Line 1016: hr_utility.trace('Business Group Id = ' ||

1012: hr_utility.trace('Payroll ID = ' ||
1013: nvl(to_char(p_payroll_id), 'NULL'));
1014: hr_utility.trace('Tax Unit ID = ' ||
1015: nvl(to_char(p_tax_unit_id), 'NULL'));
1016: hr_utility.trace('Business Group Id = ' ||
1017: nvl(to_char(p_business_group_id), 'NULL'));
1018: hr_utility.trace('Start Date = ' ||
1019: nvl(p_start_date, 'NULL'));
1020: hr_utility.trace('End Date = ' ||

Line 1018: hr_utility.trace('Start Date = ' ||

1014: hr_utility.trace('Tax Unit ID = ' ||
1015: nvl(to_char(p_tax_unit_id), 'NULL'));
1016: hr_utility.trace('Business Group Id = ' ||
1017: nvl(to_char(p_business_group_id), 'NULL'));
1018: hr_utility.trace('Start Date = ' ||
1019: nvl(p_start_date, 'NULL'));
1020: hr_utility.trace('End Date = ' ||
1021: nvl(p_end_date, 'NULL'));
1022:

Line 1020: hr_utility.trace('End Date = ' ||

1016: hr_utility.trace('Business Group Id = ' ||
1017: nvl(to_char(p_business_group_id), 'NULL'));
1018: hr_utility.trace('Start Date = ' ||
1019: nvl(p_start_date, 'NULL'));
1020: hr_utility.trace('End Date = ' ||
1021: nvl(p_end_date, 'NULL'));
1022:
1023: gv_business_group_id := p_business_group_id;
1024:

Line 1031: hr_utility.set_location(gv_package_name || '.payment_extract', 70);

1027: ,lv_header_label2);
1028:
1029: lv_header_label := lv_header_label1;
1030:
1031: hr_utility.set_location(gv_package_name || '.payment_extract', 70);
1032: /****************************************************************
1033: ** Concatenating the second Header Label which includes the User
1034: ** Defined data set so that it is printed at the end of the
1035: ** report.

Line 1038: hr_utility.set_location(gv_package_name || '.payment_extract', 80);

1034: ** Defined data set so that it is printed at the end of the
1035: ** report.
1036: ****************************************************************/
1037: lv_header_label := lv_header_label || lv_header_label2;
1038: hr_utility.set_location(gv_package_name || '.payment_extract', 80);
1039: hr_utility.trace('Static and Payment Label = ' || lv_header_label);
1040:
1041:
1042: fnd_file.put_line(fnd_file.output, formated_header_string(

Line 1039: hr_utility.trace('Static and Payment Label = ' || lv_header_label);

1035: ** report.
1036: ****************************************************************/
1037: lv_header_label := lv_header_label || lv_header_label2;
1038: hr_utility.set_location(gv_package_name || '.payment_extract', 80);
1039: hr_utility.trace('Static and Payment Label = ' || lv_header_label);
1040:
1041:
1042: fnd_file.put_line(fnd_file.output, formated_header_string(
1043: hr_general.decode_fnd_comm_lookup

Line 1049: hr_utility.set_location(gv_package_name || '.payment_extract', 90);

1045: 'TITLE')
1046: ,p_output_file_type
1047: ));
1048:
1049: hr_utility.set_location(gv_package_name || '.payment_extract', 90);
1050:
1051: /****************************************************************
1052: ** Print the Header Information. If the format is HTML then open
1053: ** the body and table before printing the header info, otherwise

Line 1067: hr_utility.set_location(gv_package_name || '.payment_extract', 100);

1063: if p_output_file_type ='HTML' then
1064: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1065: end if;
1066:
1067: hr_utility.set_location(gv_package_name || '.payment_extract', 100);
1068: /*****************************************************
1069: ** Start of the Data Section of the Report
1070: *****************************************************/
1071: hr_utility.trace('Before open of c_assignments cursor');

Line 1071: hr_utility.trace('Before open of c_assignments cursor');

1067: hr_utility.set_location(gv_package_name || '.payment_extract', 100);
1068: /*****************************************************
1069: ** Start of the Data Section of the Report
1070: *****************************************************/
1071: hr_utility.trace('Before open of c_assignments cursor');
1072: open c_assignments( fnd_date.canonical_to_date(p_start_date)
1073: ,fnd_date.canonical_to_date(p_end_date)
1074: ,p_payroll_id
1075: ,p_consolidation_set_id

Line 1104: hr_utility.set_location(gv_package_name || '.payment_extract', 105);

1100: ,ln_defined_balance_id; /* BUG: 5383895 added */
1101:
1102:
1103: if c_assignments%notfound then
1104: hr_utility.set_location(gv_package_name || '.payment_extract', 105);
1105: exit;
1106: end if;
1107:
1108: hr_utility.trace('Before open of c_payment_period cursor');

Line 1108: hr_utility.trace('Before open of c_payment_period cursor');

1104: hr_utility.set_location(gv_package_name || '.payment_extract', 105);
1105: exit;
1106: end if;
1107:
1108: hr_utility.trace('Before open of c_payment_period cursor');
1109: open c_payment_period ( fnd_date.canonical_to_date(p_start_date)
1110: ,fnd_date.canonical_to_date(p_end_date)
1111: ,p_business_group_id
1112: ,ln_locked_action_id

Line 1131: hr_utility.set_location(gv_package_name || '.payment_extract',108);

1127: *** also we will not consider that payment amount for total payment ***
1128: ***********************************************************************/
1129:
1130: if c_payment_period%notfound then
1131: hr_utility.set_location(gv_package_name || '.payment_extract',108);
1132: exit;
1133: else
1134: if ln_pmt_amount > 0 then
1135: lb_print_row := TRUE;

Line 1162: hr_utility.trace('Before open of c_personal_paymeth_info cursor');

1158: lv_acct_number := NULL;
1159: else
1160: begin
1161:
1162: hr_utility.trace('Before open of c_personal_paymeth_info cursor');
1163: open c_personal_paymeth_info(ln_persnl_pmt_method_id,
1164: ld_effective_date); /* BUG: 5383895 ld_date_earned changed to ld_effective_date */
1165:
1166: fetch c_personal_paymeth_info into lv_bank_number,

Line 1170: hr_utility.trace('Bank Number = '||lv_bank_number);

1166: fetch c_personal_paymeth_info into lv_bank_number,
1167: lv_transit_code,
1168: lv_acct_number;
1169:
1170: hr_utility.trace('Bank Number = '||lv_bank_number);
1171: hr_utility.trace('Transit code = '||lv_transit_code);
1172: hr_utility.trace('Acct Number = '||lv_acct_number);
1173:
1174: if c_personal_paymeth_info%NOTFOUND then

Line 1171: hr_utility.trace('Transit code = '||lv_transit_code);

1167: lv_transit_code,
1168: lv_acct_number;
1169:
1170: hr_utility.trace('Bank Number = '||lv_bank_number);
1171: hr_utility.trace('Transit code = '||lv_transit_code);
1172: hr_utility.trace('Acct Number = '||lv_acct_number);
1173:
1174: if c_personal_paymeth_info%NOTFOUND then
1175: hr_utility.trace('Org_Paymeth found and Personal Paymeth not found ');

Line 1172: hr_utility.trace('Acct Number = '||lv_acct_number);

1168: lv_acct_number;
1169:
1170: hr_utility.trace('Bank Number = '||lv_bank_number);
1171: hr_utility.trace('Transit code = '||lv_transit_code);
1172: hr_utility.trace('Acct Number = '||lv_acct_number);
1173:
1174: if c_personal_paymeth_info%NOTFOUND then
1175: hr_utility.trace('Org_Paymeth found and Personal Paymeth not found ');
1176:

Line 1175: hr_utility.trace('Org_Paymeth found and Personal Paymeth not found ');

1171: hr_utility.trace('Transit code = '||lv_transit_code);
1172: hr_utility.trace('Acct Number = '||lv_acct_number);
1173:
1174: if c_personal_paymeth_info%NOTFOUND then
1175: hr_utility.trace('Org_Paymeth found and Personal Paymeth not found ');
1176:
1177: lv_bank_number := NULL;
1178: lv_transit_code := NULL;
1179: lv_acct_number := NULL;

Line 1184: hr_utility.trace('Exception in Persl Paymeth Cursor ');

1180: end if;
1181: close c_personal_paymeth_info;
1182:
1183: exception when others then
1184: hr_utility.trace('Exception in Persl Paymeth Cursor ');
1185: lv_bank_number := NULL;
1186: lv_transit_code := NULL;
1187: lv_acct_number := NULL;
1188: close c_personal_paymeth_info;

Line 1193: hr_utility.trace('Before open of c_payroll_paydate cursor');

1189:
1190: end;
1191: end if; /* Validation for personal payment method ends here */
1192:
1193: hr_utility.trace('Before open of c_payroll_paydate cursor');
1194: open c_payroll_paydate(ln_locked_action_id
1195: ,p_business_group_id);
1196:
1197: fetch c_payroll_paydate into ld_pay_date, lv_period_name;

Line 1201: hr_utility.trace('c_payroll_paydate not found ');

1197: fetch c_payroll_paydate into ld_pay_date, lv_period_name;
1198: if c_payroll_paydate%NOTFOUND then
1199: ld_pay_date := null;
1200: lv_period_name := null;
1201: hr_utility.trace('c_payroll_paydate not found ');
1202: hr_utility.trace('Assignment Action ID = '||ln_assignment_action_id);
1203: end if;
1204: close c_payroll_paydate;
1205:

Line 1202: hr_utility.trace('Assignment Action ID = '||ln_assignment_action_id);

1198: if c_payroll_paydate%NOTFOUND then
1199: ld_pay_date := null;
1200: lv_period_name := null;
1201: hr_utility.trace('c_payroll_paydate not found ');
1202: hr_utility.trace('Assignment Action ID = '||ln_assignment_action_id);
1203: end if;
1204: close c_payroll_paydate;
1205:
1206: /* Third Party Payment Check start1

Line 1209: hr_utility.trace('Before open of c_tp_pmt_check cursor');

1205:
1206: /* Third Party Payment Check start1
1207: Added this curosr to fix bug#2745577
1208:
1209: hr_utility.trace('Before open of c_tp_pmt_check cursor');
1210: open c_tp_pmt_check(ln_org_pmt_method_id);
1211: fetch c_tp_pmt_check into lv_tp_payment_flag;
1212:
1213: if c_tp_pmt_check%NOTFOUND then

Line 1215: hr_utility.trace('c_tp_pmt_check not found ');

1211: fetch c_tp_pmt_check into lv_tp_payment_flag;
1212:
1213: if c_tp_pmt_check%NOTFOUND then
1214: lv_tp_payment_flag := null;
1215: hr_utility.trace('c_tp_pmt_check not found ');
1216: hr_utility.trace('Assignment Action ID = '||ln_assignment_action_id);
1217: hr_utility.trace('Org Pmt Method id = '||ln_org_pmt_method_id);
1218: end if;
1219: close c_tp_pmt_check;

Line 1216: hr_utility.trace('Assignment Action ID = '||ln_assignment_action_id);

1212:
1213: if c_tp_pmt_check%NOTFOUND then
1214: lv_tp_payment_flag := null;
1215: hr_utility.trace('c_tp_pmt_check not found ');
1216: hr_utility.trace('Assignment Action ID = '||ln_assignment_action_id);
1217: hr_utility.trace('Org Pmt Method id = '||ln_org_pmt_method_id);
1218: end if;
1219: close c_tp_pmt_check;
1220:

Line 1217: hr_utility.trace('Org Pmt Method id = '||ln_org_pmt_method_id);

1213: if c_tp_pmt_check%NOTFOUND then
1214: lv_tp_payment_flag := null;
1215: hr_utility.trace('c_tp_pmt_check not found ');
1216: hr_utility.trace('Assignment Action ID = '||ln_assignment_action_id);
1217: hr_utility.trace('Org Pmt Method id = '||ln_org_pmt_method_id);
1218: end if;
1219: close c_tp_pmt_check;
1220:
1221: If lv_tp_payment_flag = 'Y' then Commented BUG: 5383895 */

Line 1224: hr_utility.trace('Before check ln_defined_balance_id is NULL ');

1220:
1221: If lv_tp_payment_flag = 'Y' then Commented BUG: 5383895 */
1222:
1223:
1224: hr_utility.trace('Before check ln_defined_balance_id is NULL ');
1225:
1226: If ln_defined_balance_id is NULL then /* 5383895 added in place of the c_tp_pmt_check cursor */
1227:
1228: hr_utility.trace('Third Party Payment Method found ');

Line 1228: hr_utility.trace('Third Party Payment Method found ');

1224: hr_utility.trace('Before check ln_defined_balance_id is NULL ');
1225:
1226: If ln_defined_balance_id is NULL then /* 5383895 added in place of the c_tp_pmt_check cursor */
1227:
1228: hr_utility.trace('Third Party Payment Method found ');
1229: open c_case_number(ln_assignment_id,ld_effective_date,
1230: ln_persnl_pmt_method_id,ln_pmt_amount); /* BUG: 5383895 ld_date_earned changed to ld_effective_date */
1231: fetch c_case_number into lv_case_number;
1232:

Line 1235: hr_utility.trace('c_case_number not found ');

1231: fetch c_case_number into lv_case_number;
1232:
1233: if c_case_number%NOTFOUND then
1234: lv_case_number := null;
1235: hr_utility.trace('c_case_number not found ');
1236: hr_utility.trace('Assignment ID = '||ln_assignment_id);
1237: end if;
1238: close c_case_number;
1239:

Line 1236: hr_utility.trace('Assignment ID = '||ln_assignment_id);

1232:
1233: if c_case_number%NOTFOUND then
1234: lv_case_number := null;
1235: hr_utility.trace('c_case_number not found ');
1236: hr_utility.trace('Assignment ID = '||ln_assignment_id);
1237: end if;
1238: close c_case_number;
1239:
1240: open c_tp_payee_info(ln_persnl_pmt_method_id,ld_effective_date ); /* BUG: 5383895 ld_date_earned changed to ld_effective_date */

Line 1246: hr_utility.trace('c_tp_payee_info not found ');

1242:
1243: if c_tp_payee_info%NOTFOUND then
1244: lv_payee_type := null;
1245: ln_payee_id := null;
1246: hr_utility.trace('c_tp_payee_info not found ');
1247: hr_utility.trace('Assignment Action ID = '||
1248: ln_assignment_action_id);
1249: end if;
1250: close c_tp_payee_info;

Line 1247: hr_utility.trace('Assignment Action ID = '||

1243: if c_tp_payee_info%NOTFOUND then
1244: lv_payee_type := null;
1245: ln_payee_id := null;
1246: hr_utility.trace('c_tp_payee_info not found ');
1247: hr_utility.trace('Assignment Action ID = '||
1248: ln_assignment_action_id);
1249: end if;
1250: close c_tp_payee_info;
1251:

Line 1258: hr_utility.trace('c_payee_org_name not found ');

1254: fetch c_payee_org_name into lv_payee_name;
1255:
1256: if c_payee_org_name%NOTFOUND then
1257: lv_payee_name := null;
1258: hr_utility.trace('c_payee_org_name not found ');
1259: hr_utility.trace('Assignment Action ID = '||
1260: ln_assignment_action_id);
1261: end if;
1262: close c_payee_org_name;

Line 1259: hr_utility.trace('Assignment Action ID = '||

1255:
1256: if c_payee_org_name%NOTFOUND then
1257: lv_payee_name := null;
1258: hr_utility.trace('c_payee_org_name not found ');
1259: hr_utility.trace('Assignment Action ID = '||
1260: ln_assignment_action_id);
1261: end if;
1262: close c_payee_org_name;
1263:

Line 1272: hr_utility.trace('c_payee_full_name not found ');

1268: fetch c_payee_full_name into lv_payee_name;
1269:
1270: if c_payee_full_name%NOTFOUND then
1271: lv_payee_name := null;
1272: hr_utility.trace('c_payee_full_name not found ');
1273: hr_utility.trace('Assignment Action ID = '||
1274: ln_assignment_action_id);
1275: end if;
1276: close c_payee_full_name;

Line 1273: hr_utility.trace('Assignment Action ID = '||

1269:
1270: if c_payee_full_name%NOTFOUND then
1271: lv_payee_name := null;
1272: hr_utility.trace('c_payee_full_name not found ');
1273: hr_utility.trace('Assignment Action ID = '||
1274: ln_assignment_action_id);
1275: end if;
1276: close c_payee_full_name;
1277:

Line 1290: hr_utility.set_location(gv_package_name || '.payment_extract', 110);

1286:
1287: end loop;
1288: close c_payment_period;
1289:
1290: hr_utility.set_location(gv_package_name || '.payment_extract', 110);
1291: hr_utility.trace('Assignment ID = ' || ln_assignment_id);
1292: hr_utility.trace('Assignment Action ID = ' || ln_assignment_action_id);
1293:
1294: hr_utility.set_location(gv_package_name || '.payment_extract', 120);

Line 1291: hr_utility.trace('Assignment ID = ' || ln_assignment_id);

1287: end loop;
1288: close c_payment_period;
1289:
1290: hr_utility.set_location(gv_package_name || '.payment_extract', 110);
1291: hr_utility.trace('Assignment ID = ' || ln_assignment_id);
1292: hr_utility.trace('Assignment Action ID = ' || ln_assignment_action_id);
1293:
1294: hr_utility.set_location(gv_package_name || '.payment_extract', 120);
1295: /********************************************************************

Line 1292: hr_utility.trace('Assignment Action ID = ' || ln_assignment_action_id);

1288: close c_payment_period;
1289:
1290: hr_utility.set_location(gv_package_name || '.payment_extract', 110);
1291: hr_utility.trace('Assignment ID = ' || ln_assignment_id);
1292: hr_utility.trace('Assignment Action ID = ' || ln_assignment_action_id);
1293:
1294: hr_utility.set_location(gv_package_name || '.payment_extract', 120);
1295: /********************************************************************
1296: ** Populate the user defined PL/SQL table to print the additional

Line 1294: hr_utility.set_location(gv_package_name || '.payment_extract', 120);

1290: hr_utility.set_location(gv_package_name || '.payment_extract', 110);
1291: hr_utility.trace('Assignment ID = ' || ln_assignment_id);
1292: hr_utility.trace('Assignment Action ID = ' || ln_assignment_action_id);
1293:
1294: hr_utility.set_location(gv_package_name || '.payment_extract', 120);
1295: /********************************************************************
1296: ** Populate the user defined PL/SQL table to print the additional
1297: ** columns in the report.
1298: ********************************************************************/

Line 1307: hr_utility.set_location(gv_package_name || '.payment_extract', 125);

1303: ,p_effective_date=> ld_effective_date
1304: );
1305: */
1306:
1307: hr_utility.set_location(gv_package_name || '.payment_extract', 125);
1308:
1309: formated_static_data(
1310: lv_emp_full_name
1311: ,lv_assignment_number

Line 1331: hr_utility.set_location(gv_package_name || '.payment_extract', 130);

1327: ,lv_data_row1
1328: ,lv_data_row2);
1329:
1330: lv_data_row := lv_data_row1;
1331: hr_utility.set_location(gv_package_name || '.payment_extract', 130);
1332: hr_utility.trace('Effective Date = ' || to_char(ld_effective_date,
1333: 'dd-mon-yyyy'));
1334:
1335: hr_utility.trace('Assignment Action ID = ' || ln_assignment_action_id);

Line 1332: hr_utility.trace('Effective Date = ' || to_char(ld_effective_date,

1328: ,lv_data_row2);
1329:
1330: lv_data_row := lv_data_row1;
1331: hr_utility.set_location(gv_package_name || '.payment_extract', 130);
1332: hr_utility.trace('Effective Date = ' || to_char(ld_effective_date,
1333: 'dd-mon-yyyy'));
1334:
1335: hr_utility.trace('Assignment Action ID = ' || ln_assignment_action_id);
1336:

Line 1335: hr_utility.trace('Assignment Action ID = ' || ln_assignment_action_id);

1331: hr_utility.set_location(gv_package_name || '.payment_extract', 130);
1332: hr_utility.trace('Effective Date = ' || to_char(ld_effective_date,
1333: 'dd-mon-yyyy'));
1334:
1335: hr_utility.trace('Assignment Action ID = ' || ln_assignment_action_id);
1336:
1337: hr_utility.trace('Actual Data lv_data_row1 = ' || lv_data_row1);
1338: hr_utility.trace('Actual Data lv_data_row2 = ' || lv_data_row2);
1339:

Line 1337: hr_utility.trace('Actual Data lv_data_row1 = ' || lv_data_row1);

1333: 'dd-mon-yyyy'));
1334:
1335: hr_utility.trace('Assignment Action ID = ' || ln_assignment_action_id);
1336:
1337: hr_utility.trace('Actual Data lv_data_row1 = ' || lv_data_row1);
1338: hr_utility.trace('Actual Data lv_data_row2 = ' || lv_data_row2);
1339:
1340: /****************************************************************
1341: ** Concatnating the second Header Label which includes the User

Line 1338: hr_utility.trace('Actual Data lv_data_row2 = ' || lv_data_row2);

1334:
1335: hr_utility.trace('Assignment Action ID = ' || ln_assignment_action_id);
1336:
1337: hr_utility.trace('Actual Data lv_data_row1 = ' || lv_data_row1);
1338: hr_utility.trace('Actual Data lv_data_row2 = ' || lv_data_row2);
1339:
1340: /****************************************************************
1341: ** Concatnating the second Header Label which includes the User
1342: ** Defined data set so that it is printed at the end of the

Line 1426: hr_utility.trace('Concurrent Request ID = ' || FND_GLOBAL.CONC_REQUEST_ID);

1422: *****************************************************/
1423: if p_output_file_type ='HTML' then
1424: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1425: end if;
1426: hr_utility.trace('Concurrent Request ID = ' || FND_GLOBAL.CONC_REQUEST_ID);
1427:
1428:
1429: /**********************************************************
1430: ** Not Required as the output file type is HTML by default

Line 1442: /* hr_utility.trace_off; */

1438: end if;
1439: **********************************************************/
1440:
1441: gv_leg_code := NULL;
1442: /* hr_utility.trace_off; */
1443:
1444: END payment_extract;
1445:
1446: end pay_ca_payreg_extract_pkg;