APPS.PAY_CA_PAYREG_EXTRACT_PKG dependencies on HR_UTILITY

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

185:
186: lv_format varchar2(1000);
187:
188: BEGIN
189: hr_utility.set_location(gv_package_name || '.formated_data_string', 10);
190: if p_output_file_type = 'CSV' then
191: hr_utility.set_location(gv_package_name || '.formated_data_string', 20);
192: lv_format := gc_csv_data_delimiter || p_input_string ||
193: gc_csv_data_delimiter || gc_csv_delimiter;

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

187:
188: BEGIN
189: hr_utility.set_location(gv_package_name || '.formated_data_string', 10);
190: if p_output_file_type = 'CSV' then
191: hr_utility.set_location(gv_package_name || '.formated_data_string', 20);
192: lv_format := gc_csv_data_delimiter || p_input_string ||
193: gc_csv_data_delimiter || gc_csv_delimiter;
194: elsif p_output_file_type = 'HTML' then
195: if ltrim(rtrim(p_input_string)) is null then

Line 196: hr_utility.set_location(gv_package_name ||

192: lv_format := gc_csv_data_delimiter || p_input_string ||
193: gc_csv_data_delimiter || gc_csv_delimiter;
194: elsif p_output_file_type = 'HTML' then
195: if ltrim(rtrim(p_input_string)) is null then
196: hr_utility.set_location(gv_package_name ||
197: '.formated_data_string', 30);
198:
199: lv_format := gv_html_start_data || ' ' || gv_html_end_data;
200: else

Line 202: hr_utility.set_location(gv_package_name ||

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

Line 212: hr_utility.set_location(gv_package_name ||

208: lv_format := gv_html_start_data || ' ' || p_input_string
209: || '' || gv_html_end_data;
210: end if;
211: else
212: hr_utility.set_location(gv_package_name ||
213: '.formated_data_string',50);
214:
215: lv_format := gv_html_start_data || p_input_string ||
216: gv_html_end_data;

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

218: end if;
219: end if;
220: end if;
221:
222: hr_utility.set_location(gv_package_name || '.formated_data_string', 60);
223: return lv_format;
224:
225: END formated_data_string;
226:

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

279:
280: lv_format varchar2(1000);
281:
282: BEGIN
283: hr_utility.set_location(gv_package_name || '.formated_header_string', 10);
284: if p_output_file_type = 'CSV' then
285: hr_utility.set_location(gv_package_name|| '.formated_header_string', 20);
286:
287: lv_format := p_input_string;

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

281:
282: BEGIN
283: hr_utility.set_location(gv_package_name || '.formated_header_string', 10);
284: if p_output_file_type = 'CSV' then
285: hr_utility.set_location(gv_package_name|| '.formated_header_string', 20);
286:
287: lv_format := p_input_string;
288: elsif p_output_file_type = 'HTML' then
289: hr_utility.set_location(gv_package_name|| '.formated_header_string', 30);

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

285: hr_utility.set_location(gv_package_name|| '.formated_header_string', 20);
286:
287: lv_format := p_input_string;
288: elsif p_output_file_type = 'HTML' then
289: hr_utility.set_location(gv_package_name|| '.formated_header_string', 30);
290: lv_format := '

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

290: lv_format := '

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

324: lv_leg_code varchar2(3);
325:
326: BEGIN
327:
328: hr_utility.set_location(gv_package_name || '.formated_static_header', 10);
329:
330: begin
331: select legislation_code into lv_leg_code
332: from per_business_groups

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

411: 'PMT_NUM')
412: ,p_bold => 'Y'
413: ,p_output_file_type => p_output_file_type);
414:
415: hr_utility.set_location(gv_package_name || '.formated_static_header', 20);
416:
417: lv_format2 :=
418: formated_data_string (p_input_string =>
419: hr_general.decode_fnd_comm_lookup

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

469: /*******************************************************************
470: ** Print the User Defined data for each Employee Assignment at the
471: ** end of the report
472: *******************************************************************/
473: hr_utility.set_location(gv_package_name || '.formated_static_header', 30);
474:
475:
476: /*******************************************************************
477: ** Only do this if there is some configuration data present

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

493:
494:
495: p_static_label1 := lv_format1;
496: p_static_label2 := lv_format2;
497: hr_utility.trace('Static Label1 = ' || lv_format1);
498: hr_utility.trace('Static Label2 = ' || lv_format2);
499: hr_utility.set_location(gv_package_name || '.formated_static_header', 40);
500:
501: END;

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

494:
495: p_static_label1 := lv_format1;
496: p_static_label2 := lv_format2;
497: hr_utility.trace('Static Label1 = ' || lv_format1);
498: hr_utility.trace('Static Label2 = ' || lv_format2);
499: hr_utility.set_location(gv_package_name || '.formated_static_header', 40);
500:
501: END;
502:

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

495: p_static_label1 := lv_format1;
496: p_static_label2 := lv_format2;
497: hr_utility.trace('Static Label1 = ' || lv_format1);
498: hr_utility.trace('Static Label2 = ' || lv_format2);
499: hr_utility.set_location(gv_package_name || '.formated_static_header', 40);
500:
501: END;
502:
503:

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

545: sv_amount varchar2(200);
546:
547: BEGIN
548:
549: hr_utility.set_location(gv_package_name || '.formated_static_data_tp', 10);
550: lv_format1 :=
551: formated_data_string (p_input_string => p_payment_type
552: ,p_output_file_type => p_output_file_type) ||
553:

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

573:
574: formated_data_string (p_input_string => p_payment_number
575: ,p_output_file_type => p_output_file_type);
576:
577: hr_utility.set_location(gv_package_name || '.formated_static_data_tp', 20);
578:
579: if p_output_file_type = 'HTML' then
580: sv_amount := ''||p_payment_amount||gv_html_end_data;
581: elsif p_output_file_type = 'CSV' then

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

607: /*******************************************************************
608: ** Print the User Defined data for each Employee Assignment at the
609: ** end of the report
610: *******************************************************************/
611: hr_utility.set_location(gv_package_name || '.formated_static_data_tp', 30);
612: hr_utility.trace('Before Loop ');
613:
614: hr_utility.trace('Static Data1 = ' || lv_format1);
615: hr_utility.trace('Static Data2 = ' || lv_format2);

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

608: ** Print the User Defined data for each Employee Assignment at the
609: ** end of the report
610: *******************************************************************/
611: hr_utility.set_location(gv_package_name || '.formated_static_data_tp', 30);
612: hr_utility.trace('Before Loop ');
613:
614: hr_utility.trace('Static Data1 = ' || lv_format1);
615: hr_utility.trace('Static Data2 = ' || lv_format2);
616:

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

610: *******************************************************************/
611: hr_utility.set_location(gv_package_name || '.formated_static_data_tp', 30);
612: hr_utility.trace('Before Loop ');
613:
614: hr_utility.trace('Static Data1 = ' || lv_format1);
615: hr_utility.trace('Static Data2 = ' || lv_format2);
616:
617: /*******************************************************************
618: ** Only do this if there is some configuration data present

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

611: hr_utility.set_location(gv_package_name || '.formated_static_data_tp', 30);
612: hr_utility.trace('Before Loop ');
613:
614: hr_utility.trace('Static Data1 = ' || lv_format1);
615: hr_utility.trace('Static Data2 = ' || lv_format2);
616:
617: /*******************************************************************
618: ** Only do this if there is some configuration data present
619: *******************************************************************/

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

634:
635:
636: p_static_data1 := lv_format1;
637: p_static_data2 := lv_format2;
638: hr_utility.trace('After Loop ');
639: hr_utility.trace('Static Data1 = ' || lv_format1);
640: hr_utility.trace('Static Data2 = ' || lv_format2);
641: hr_utility.set_location(gv_package_name || '.formated_static_data_tp', 40);
642:

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

635:
636: p_static_data1 := lv_format1;
637: p_static_data2 := lv_format2;
638: hr_utility.trace('After Loop ');
639: hr_utility.trace('Static Data1 = ' || lv_format1);
640: hr_utility.trace('Static Data2 = ' || lv_format2);
641: hr_utility.set_location(gv_package_name || '.formated_static_data_tp', 40);
642:
643: END;

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

636: p_static_data1 := lv_format1;
637: p_static_data2 := lv_format2;
638: hr_utility.trace('After Loop ');
639: hr_utility.trace('Static Data1 = ' || lv_format1);
640: hr_utility.trace('Static Data2 = ' || lv_format2);
641: hr_utility.set_location(gv_package_name || '.formated_static_data_tp', 40);
642:
643: END;
644:

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

637: p_static_data2 := lv_format2;
638: hr_utility.trace('After Loop ');
639: hr_utility.trace('Static Data1 = ' || lv_format1);
640: hr_utility.trace('Static Data2 = ' || lv_format2);
641: hr_utility.set_location(gv_package_name || '.formated_static_data_tp', 40);
642:
643: END;
644:
645:

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

1017:
1018: ln_defined_balance_id pay_org_payment_methods_f.defined_balance_id%TYPE; /* BUG: 5383895 added */
1019:
1020: BEGIN
1021: hr_utility.set_location(gv_package_name || '.payment_extract', 10);
1022: /* hr_utility.trace_on(null, 'ORACLE'); */
1023:
1024: hr_utility.trace('Payment Type ID = ' ||
1025: nvl(to_char(p_payment_type_id), 'NULL'));

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

1018: ln_defined_balance_id pay_org_payment_methods_f.defined_balance_id%TYPE; /* BUG: 5383895 added */
1019:
1020: BEGIN
1021: hr_utility.set_location(gv_package_name || '.payment_extract', 10);
1022: /* hr_utility.trace_on(null, 'ORACLE'); */
1023:
1024: hr_utility.trace('Payment Type ID = ' ||
1025: nvl(to_char(p_payment_type_id), 'NULL'));
1026: hr_utility.trace('Payment Method ID = ' ||

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

1020: BEGIN
1021: hr_utility.set_location(gv_package_name || '.payment_extract', 10);
1022: /* hr_utility.trace_on(null, 'ORACLE'); */
1023:
1024: hr_utility.trace('Payment Type ID = ' ||
1025: nvl(to_char(p_payment_type_id), 'NULL'));
1026: hr_utility.trace('Payment Method ID = ' ||
1027: nvl(to_char(p_payment_method_id), 'NULL'));
1028: hr_utility.trace('Consolidation Set ID = ' ||

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

1022: /* hr_utility.trace_on(null, 'ORACLE'); */
1023:
1024: hr_utility.trace('Payment Type ID = ' ||
1025: nvl(to_char(p_payment_type_id), 'NULL'));
1026: hr_utility.trace('Payment Method ID = ' ||
1027: nvl(to_char(p_payment_method_id), 'NULL'));
1028: hr_utility.trace('Consolidation Set ID = ' ||
1029: nvl(to_char(p_consolidation_set_id), 'NULL'));
1030: hr_utility.trace('Payroll ID = ' ||

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

1024: hr_utility.trace('Payment Type ID = ' ||
1025: nvl(to_char(p_payment_type_id), 'NULL'));
1026: hr_utility.trace('Payment Method ID = ' ||
1027: nvl(to_char(p_payment_method_id), 'NULL'));
1028: hr_utility.trace('Consolidation Set ID = ' ||
1029: nvl(to_char(p_consolidation_set_id), 'NULL'));
1030: hr_utility.trace('Payroll ID = ' ||
1031: nvl(to_char(p_payroll_id), 'NULL'));
1032: hr_utility.trace('Tax Unit ID = ' ||

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

1026: hr_utility.trace('Payment Method ID = ' ||
1027: nvl(to_char(p_payment_method_id), 'NULL'));
1028: hr_utility.trace('Consolidation Set ID = ' ||
1029: nvl(to_char(p_consolidation_set_id), 'NULL'));
1030: hr_utility.trace('Payroll ID = ' ||
1031: nvl(to_char(p_payroll_id), 'NULL'));
1032: hr_utility.trace('Tax Unit ID = ' ||
1033: nvl(to_char(p_tax_unit_id), 'NULL'));
1034: hr_utility.trace('Business Group Id = ' ||

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

1028: hr_utility.trace('Consolidation Set ID = ' ||
1029: nvl(to_char(p_consolidation_set_id), 'NULL'));
1030: hr_utility.trace('Payroll ID = ' ||
1031: nvl(to_char(p_payroll_id), 'NULL'));
1032: hr_utility.trace('Tax Unit ID = ' ||
1033: nvl(to_char(p_tax_unit_id), 'NULL'));
1034: hr_utility.trace('Business Group Id = ' ||
1035: nvl(to_char(p_business_group_id), 'NULL'));
1036: hr_utility.trace('Start Date = ' ||

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

1030: hr_utility.trace('Payroll ID = ' ||
1031: nvl(to_char(p_payroll_id), 'NULL'));
1032: hr_utility.trace('Tax Unit ID = ' ||
1033: nvl(to_char(p_tax_unit_id), 'NULL'));
1034: hr_utility.trace('Business Group Id = ' ||
1035: nvl(to_char(p_business_group_id), 'NULL'));
1036: hr_utility.trace('Start Date = ' ||
1037: nvl(p_start_date, 'NULL'));
1038: hr_utility.trace('End Date = ' ||

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

1032: hr_utility.trace('Tax Unit ID = ' ||
1033: nvl(to_char(p_tax_unit_id), 'NULL'));
1034: hr_utility.trace('Business Group Id = ' ||
1035: nvl(to_char(p_business_group_id), 'NULL'));
1036: hr_utility.trace('Start Date = ' ||
1037: nvl(p_start_date, 'NULL'));
1038: hr_utility.trace('End Date = ' ||
1039: nvl(p_end_date, 'NULL'));
1040:

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

1034: hr_utility.trace('Business Group Id = ' ||
1035: nvl(to_char(p_business_group_id), 'NULL'));
1036: hr_utility.trace('Start Date = ' ||
1037: nvl(p_start_date, 'NULL'));
1038: hr_utility.trace('End Date = ' ||
1039: nvl(p_end_date, 'NULL'));
1040:
1041: gv_business_group_id := p_business_group_id;
1042:

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

1045: ,lv_header_label2);
1046:
1047: lv_header_label := lv_header_label1;
1048:
1049: hr_utility.set_location(gv_package_name || '.payment_extract', 70);
1050: /****************************************************************
1051: ** Concatenating the second Header Label which includes the User
1052: ** Defined data set so that it is printed at the end of the
1053: ** report.

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

1052: ** Defined data set so that it is printed at the end of the
1053: ** report.
1054: ****************************************************************/
1055: lv_header_label := lv_header_label || lv_header_label2;
1056: hr_utility.set_location(gv_package_name || '.payment_extract', 80);
1057: hr_utility.trace('Static and Payment Label = ' || lv_header_label);
1058:
1059:
1060: fnd_file.put_line(fnd_file.output, formated_header_string(

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

1053: ** report.
1054: ****************************************************************/
1055: lv_header_label := lv_header_label || lv_header_label2;
1056: hr_utility.set_location(gv_package_name || '.payment_extract', 80);
1057: hr_utility.trace('Static and Payment Label = ' || lv_header_label);
1058:
1059:
1060: fnd_file.put_line(fnd_file.output, formated_header_string(
1061: hr_general.decode_fnd_comm_lookup

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

1063: 'TITLE')
1064: ,p_output_file_type
1065: ));
1066:
1067: hr_utility.set_location(gv_package_name || '.payment_extract', 90);
1068:
1069: /****************************************************************
1070: ** Print the Header Information. If the format is HTML then open
1071: ** the body and table before printing the header info, otherwise

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

1081: if p_output_file_type ='HTML' then
1082: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1083: end if;
1084:
1085: hr_utility.set_location(gv_package_name || '.payment_extract', 100);
1086: /*****************************************************
1087: ** Start of the Data Section of the Report
1088: *****************************************************/
1089: hr_utility.trace('Before open of c_assignments cursor');

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

1085: hr_utility.set_location(gv_package_name || '.payment_extract', 100);
1086: /*****************************************************
1087: ** Start of the Data Section of the Report
1088: *****************************************************/
1089: hr_utility.trace('Before open of c_assignments cursor');
1090: open c_assignments( fnd_date.canonical_to_date(p_start_date)
1091: ,fnd_date.canonical_to_date(p_end_date)
1092: ,p_payroll_id
1093: ,p_consolidation_set_id

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

1118: ,ln_defined_balance_id; /* BUG: 5383895 added */
1119:
1120:
1121: if c_assignments%notfound then
1122: hr_utility.set_location(gv_package_name || '.payment_extract', 105);
1123: exit;
1124: end if;
1125:
1126: hr_utility.trace('Before open of c_payment_period cursor');

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

1122: hr_utility.set_location(gv_package_name || '.payment_extract', 105);
1123: exit;
1124: end if;
1125:
1126: hr_utility.trace('Before open of c_payment_period cursor');
1127: open c_payment_period ( fnd_date.canonical_to_date(p_start_date)
1128: ,fnd_date.canonical_to_date(p_end_date)
1129: ,p_business_group_id
1130: ,ln_locked_action_id

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

1145: *** also we will not consider that payment amount for total payment ***
1146: ***********************************************************************/
1147:
1148: if c_payment_period%notfound then
1149: hr_utility.set_location(gv_package_name || '.payment_extract',108);
1150: exit;
1151: else
1152: if ln_pmt_amount > 0 then
1153: lb_print_row := TRUE;

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

1185: lv_acct_number := NULL;
1186: else
1187: begin
1188:
1189: hr_utility.trace('Before open of c_personal_paymeth_info cursor');
1190: open c_personal_paymeth_info(ln_persnl_pmt_method_id,
1191: ld_effective_date); /* BUG: 5383895 ld_date_earned changed to ld_effective_date */
1192:
1193: fetch c_personal_paymeth_info into lv_bank_number,

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

1193: fetch c_personal_paymeth_info into lv_bank_number,
1194: lv_transit_code,
1195: lv_acct_number;
1196:
1197: hr_utility.trace('Bank Number = '||lv_bank_number);
1198: hr_utility.trace('Transit code = '||lv_transit_code);
1199: hr_utility.trace('Acct Number = '||lv_acct_number);
1200:
1201: if c_personal_paymeth_info%NOTFOUND then

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

1194: lv_transit_code,
1195: lv_acct_number;
1196:
1197: hr_utility.trace('Bank Number = '||lv_bank_number);
1198: hr_utility.trace('Transit code = '||lv_transit_code);
1199: hr_utility.trace('Acct Number = '||lv_acct_number);
1200:
1201: if c_personal_paymeth_info%NOTFOUND then
1202: hr_utility.trace('Org_Paymeth found and Personal Paymeth not found ');

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

1195: lv_acct_number;
1196:
1197: hr_utility.trace('Bank Number = '||lv_bank_number);
1198: hr_utility.trace('Transit code = '||lv_transit_code);
1199: hr_utility.trace('Acct Number = '||lv_acct_number);
1200:
1201: if c_personal_paymeth_info%NOTFOUND then
1202: hr_utility.trace('Org_Paymeth found and Personal Paymeth not found ');
1203:

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

1198: hr_utility.trace('Transit code = '||lv_transit_code);
1199: hr_utility.trace('Acct Number = '||lv_acct_number);
1200:
1201: if c_personal_paymeth_info%NOTFOUND then
1202: hr_utility.trace('Org_Paymeth found and Personal Paymeth not found ');
1203:
1204: lv_bank_number := NULL;
1205: lv_transit_code := NULL;
1206: lv_acct_number := NULL;

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

1207: end if;
1208: close c_personal_paymeth_info;
1209:
1210: exception when others then
1211: hr_utility.trace('Exception in Persl Paymeth Cursor ');
1212: lv_bank_number := NULL;
1213: lv_transit_code := NULL;
1214: lv_acct_number := NULL;
1215: close c_personal_paymeth_info;

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

1216:
1217: end;
1218: end if; /* Validation for personal payment method ends here */
1219:
1220: hr_utility.trace('Before open of c_payroll_paydate cursor');
1221: open c_payroll_paydate(ln_locked_action_id
1222: ,p_business_group_id);
1223:
1224: fetch c_payroll_paydate into ld_pay_date, lv_period_name;

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

1224: fetch c_payroll_paydate into ld_pay_date, lv_period_name;
1225: if c_payroll_paydate%NOTFOUND then
1226: ld_pay_date := null;
1227: lv_period_name := null;
1228: hr_utility.trace('c_payroll_paydate not found ');
1229: hr_utility.trace('Assignment Action ID = '||ln_assignment_action_id);
1230: end if;
1231: close c_payroll_paydate;
1232:

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

1225: if c_payroll_paydate%NOTFOUND then
1226: ld_pay_date := null;
1227: lv_period_name := null;
1228: hr_utility.trace('c_payroll_paydate not found ');
1229: hr_utility.trace('Assignment Action ID = '||ln_assignment_action_id);
1230: end if;
1231: close c_payroll_paydate;
1232:
1233: /* Third Party Payment Check start1

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

1232:
1233: /* Third Party Payment Check start1
1234: Added this curosr to fix bug#2745577
1235:
1236: hr_utility.trace('Before open of c_tp_pmt_check cursor');
1237: open c_tp_pmt_check(ln_org_pmt_method_id);
1238: fetch c_tp_pmt_check into lv_tp_payment_flag;
1239:
1240: if c_tp_pmt_check%NOTFOUND then

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

1238: fetch c_tp_pmt_check into lv_tp_payment_flag;
1239:
1240: if c_tp_pmt_check%NOTFOUND then
1241: lv_tp_payment_flag := null;
1242: hr_utility.trace('c_tp_pmt_check not found ');
1243: hr_utility.trace('Assignment Action ID = '||ln_assignment_action_id);
1244: hr_utility.trace('Org Pmt Method id = '||ln_org_pmt_method_id);
1245: end if;
1246: close c_tp_pmt_check;

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

1239:
1240: if c_tp_pmt_check%NOTFOUND then
1241: lv_tp_payment_flag := null;
1242: hr_utility.trace('c_tp_pmt_check not found ');
1243: hr_utility.trace('Assignment Action ID = '||ln_assignment_action_id);
1244: hr_utility.trace('Org Pmt Method id = '||ln_org_pmt_method_id);
1245: end if;
1246: close c_tp_pmt_check;
1247:

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

1240: if c_tp_pmt_check%NOTFOUND then
1241: lv_tp_payment_flag := null;
1242: hr_utility.trace('c_tp_pmt_check not found ');
1243: hr_utility.trace('Assignment Action ID = '||ln_assignment_action_id);
1244: hr_utility.trace('Org Pmt Method id = '||ln_org_pmt_method_id);
1245: end if;
1246: close c_tp_pmt_check;
1247:
1248: If lv_tp_payment_flag = 'Y' then Commented BUG: 5383895 */

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

1247:
1248: If lv_tp_payment_flag = 'Y' then Commented BUG: 5383895 */
1249:
1250:
1251: hr_utility.trace('Before check ln_defined_balance_id is NULL ');
1252:
1253: If ln_defined_balance_id is NULL then /* 5383895 added in place of the c_tp_pmt_check cursor */
1254:
1255: hr_utility.trace('Third Party Payment Method found ');

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

1251: hr_utility.trace('Before check ln_defined_balance_id is NULL ');
1252:
1253: If ln_defined_balance_id is NULL then /* 5383895 added in place of the c_tp_pmt_check cursor */
1254:
1255: hr_utility.trace('Third Party Payment Method found ');
1256: open c_case_number(ln_assignment_id,ld_effective_date,
1257: ln_persnl_pmt_method_id,ln_pmt_amount); /* BUG: 5383895 ld_date_earned changed to ld_effective_date */
1258: fetch c_case_number into lv_case_number;
1259:

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

1258: fetch c_case_number into lv_case_number;
1259:
1260: if c_case_number%NOTFOUND then
1261: lv_case_number := null;
1262: hr_utility.trace('c_case_number not found ');
1263: hr_utility.trace('Assignment ID = '||ln_assignment_id);
1264: end if;
1265: close c_case_number;
1266:

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

1259:
1260: if c_case_number%NOTFOUND then
1261: lv_case_number := null;
1262: hr_utility.trace('c_case_number not found ');
1263: hr_utility.trace('Assignment ID = '||ln_assignment_id);
1264: end if;
1265: close c_case_number;
1266:
1267: open c_tp_payee_info(ln_persnl_pmt_method_id,ld_effective_date ); /* BUG: 5383895 ld_date_earned changed to ld_effective_date */

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

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

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

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

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

1281: fetch c_payee_org_name into lv_payee_name;
1282:
1283: if c_payee_org_name%NOTFOUND then
1284: lv_payee_name := null;
1285: hr_utility.trace('c_payee_org_name not found ');
1286: hr_utility.trace('Assignment Action ID = '||
1287: ln_assignment_action_id);
1288: end if;
1289: close c_payee_org_name;

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

1282:
1283: if c_payee_org_name%NOTFOUND then
1284: lv_payee_name := null;
1285: hr_utility.trace('c_payee_org_name not found ');
1286: hr_utility.trace('Assignment Action ID = '||
1287: ln_assignment_action_id);
1288: end if;
1289: close c_payee_org_name;
1290:

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

1295: fetch c_payee_full_name into lv_payee_name;
1296:
1297: if c_payee_full_name%NOTFOUND then
1298: lv_payee_name := null;
1299: hr_utility.trace('c_payee_full_name not found ');
1300: hr_utility.trace('Assignment Action ID = '||
1301: ln_assignment_action_id);
1302: end if;
1303: close c_payee_full_name;

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

1296:
1297: if c_payee_full_name%NOTFOUND then
1298: lv_payee_name := null;
1299: hr_utility.trace('c_payee_full_name not found ');
1300: hr_utility.trace('Assignment Action ID = '||
1301: ln_assignment_action_id);
1302: end if;
1303: close c_payee_full_name;
1304:

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

1315: cheque is also printed in payment report when reissued*/
1316: /* end loop;
1317: close c_payment_period; */
1318:
1319: hr_utility.set_location(gv_package_name || '.payment_extract', 110);
1320: hr_utility.trace('Assignment ID = ' || ln_assignment_id);
1321: hr_utility.trace('Assignment Action ID = ' || ln_assignment_action_id);
1322:
1323: hr_utility.set_location(gv_package_name || '.payment_extract', 120);

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

1316: /* end loop;
1317: close c_payment_period; */
1318:
1319: hr_utility.set_location(gv_package_name || '.payment_extract', 110);
1320: hr_utility.trace('Assignment ID = ' || ln_assignment_id);
1321: hr_utility.trace('Assignment Action ID = ' || ln_assignment_action_id);
1322:
1323: hr_utility.set_location(gv_package_name || '.payment_extract', 120);
1324: /********************************************************************

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

1317: close c_payment_period; */
1318:
1319: hr_utility.set_location(gv_package_name || '.payment_extract', 110);
1320: hr_utility.trace('Assignment ID = ' || ln_assignment_id);
1321: hr_utility.trace('Assignment Action ID = ' || ln_assignment_action_id);
1322:
1323: hr_utility.set_location(gv_package_name || '.payment_extract', 120);
1324: /********************************************************************
1325: ** Populate the user defined PL/SQL table to print the additional

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

1319: hr_utility.set_location(gv_package_name || '.payment_extract', 110);
1320: hr_utility.trace('Assignment ID = ' || ln_assignment_id);
1321: hr_utility.trace('Assignment Action ID = ' || ln_assignment_action_id);
1322:
1323: hr_utility.set_location(gv_package_name || '.payment_extract', 120);
1324: /********************************************************************
1325: ** Populate the user defined PL/SQL table to print the additional
1326: ** columns in the report.
1327: ********************************************************************/

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

1332: ,p_effective_date=> ld_effective_date
1333: );
1334: */
1335:
1336: hr_utility.set_location(gv_package_name || '.payment_extract', 125);
1337:
1338: formated_static_data(
1339: lv_emp_full_name
1340: ,lv_assignment_number

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

1356: ,lv_data_row1
1357: ,lv_data_row2);
1358:
1359: lv_data_row := lv_data_row1;
1360: hr_utility.set_location(gv_package_name || '.payment_extract', 130);
1361: hr_utility.trace('Effective Date = ' || to_char(ld_effective_date,
1362: 'dd-mon-yyyy'));
1363:
1364: hr_utility.trace('Assignment Action ID = ' || ln_assignment_action_id);

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

1357: ,lv_data_row2);
1358:
1359: lv_data_row := lv_data_row1;
1360: hr_utility.set_location(gv_package_name || '.payment_extract', 130);
1361: hr_utility.trace('Effective Date = ' || to_char(ld_effective_date,
1362: 'dd-mon-yyyy'));
1363:
1364: hr_utility.trace('Assignment Action ID = ' || ln_assignment_action_id);
1365:

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

1360: hr_utility.set_location(gv_package_name || '.payment_extract', 130);
1361: hr_utility.trace('Effective Date = ' || to_char(ld_effective_date,
1362: 'dd-mon-yyyy'));
1363:
1364: hr_utility.trace('Assignment Action ID = ' || ln_assignment_action_id);
1365:
1366: hr_utility.trace('Actual Data lv_data_row1 = ' || lv_data_row1);
1367: hr_utility.trace('Actual Data lv_data_row2 = ' || lv_data_row2);
1368:

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

1362: 'dd-mon-yyyy'));
1363:
1364: hr_utility.trace('Assignment Action ID = ' || ln_assignment_action_id);
1365:
1366: hr_utility.trace('Actual Data lv_data_row1 = ' || lv_data_row1);
1367: hr_utility.trace('Actual Data lv_data_row2 = ' || lv_data_row2);
1368:
1369: /****************************************************************
1370: ** Concatnating the second Header Label which includes the User

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

1363:
1364: hr_utility.trace('Assignment Action ID = ' || ln_assignment_action_id);
1365:
1366: hr_utility.trace('Actual Data lv_data_row1 = ' || lv_data_row1);
1367: hr_utility.trace('Actual Data lv_data_row2 = ' || lv_data_row2);
1368:
1369: /****************************************************************
1370: ** Concatnating the second Header Label which includes the User
1371: ** Defined data set so that it is printed at the end of the

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

1455: *****************************************************/
1456: if p_output_file_type ='HTML' then
1457: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1458: end if;
1459: hr_utility.trace('Concurrent Request ID = ' || FND_GLOBAL.CONC_REQUEST_ID);
1460:
1461:
1462: /**********************************************************
1463: ** Not Required as the output file type is HTML by default

Line 1475: /* hr_utility.trace_off; */

1471: end if;
1472: **********************************************************/
1473:
1474: gv_leg_code := NULL;
1475: /* hr_utility.trace_off; */
1476:
1477: END payment_extract;
1478:
1479: end pay_ca_payreg_extract_pkg;