eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_CA_RULES dependencies on HR_UTILITY

Line 192: hr_utility.set_message(801,'PAY_74161_MISSING_GRE');

188: if lv_gre_type = 'T4/RL1' then
189: p_tax_unit_id := ln_t4_rl1_gre;
190: else
191: p_tax_unit_id := null;
192: hr_utility.set_message(801,'PAY_74161_MISSING_GRE');
193: pay_core_utils.push_message(801,'PAY_74161_MISSING_GRE','P');
194: hr_utility.raise_error;
195: end if;
196:

Line 194: hr_utility.raise_error;

190: else
191: p_tax_unit_id := null;
192: hr_utility.set_message(801,'PAY_74161_MISSING_GRE');
193: pay_core_utils.push_message(801,'PAY_74161_MISSING_GRE','P');
194: hr_utility.raise_error;
195: end if;
196:
197: elsif lv_run_type_gre = 'T4A/RL1' then
198:

Line 207: hr_utility.set_message(801,'PAY_74161_MISSING_GRE');

203: if lv_gre_type = 'T4A/RL1' then
204: p_tax_unit_id := ln_t4a_rl1_gre;
205: else
206: p_tax_unit_id := null;
207: hr_utility.set_message(801,'PAY_74161_MISSING_GRE');
208: pay_core_utils.push_message(801,'PAY_74161_MISSING_GRE','P');
209: hr_utility.raise_error;
210: end if;
211:

Line 209: hr_utility.raise_error;

205: else
206: p_tax_unit_id := null;
207: hr_utility.set_message(801,'PAY_74161_MISSING_GRE');
208: pay_core_utils.push_message(801,'PAY_74161_MISSING_GRE','P');
209: hr_utility.raise_error;
210: end if;
211:
212: elsif lv_run_type_gre = 'T4A/RL2' then
213:

Line 219: hr_utility.trace('in lv_gre_type = T4A/RL2');

215: fetch cur_check_gre_type into lv_gre_type;
216: close cur_check_gre_type;
217:
218: if lv_gre_type = 'T4A/RL2' then
219: hr_utility.trace('in lv_gre_type = T4A/RL2');
220: p_tax_unit_id := ln_t4a_rl2_gre;
221: else
222: p_tax_unit_id := null;
223: hr_utility.set_message(801,'PAY_74161_MISSING_GRE');

Line 223: hr_utility.set_message(801,'PAY_74161_MISSING_GRE');

219: hr_utility.trace('in lv_gre_type = T4A/RL2');
220: p_tax_unit_id := ln_t4a_rl2_gre;
221: else
222: p_tax_unit_id := null;
223: hr_utility.set_message(801,'PAY_74161_MISSING_GRE');
224: pay_core_utils.push_message(801,'PAY_74161_MISSING_GRE','P');
225: hr_utility.raise_error;
226: end if;
227:

Line 225: hr_utility.raise_error;

221: else
222: p_tax_unit_id := null;
223: hr_utility.set_message(801,'PAY_74161_MISSING_GRE');
224: pay_core_utils.push_message(801,'PAY_74161_MISSING_GRE','P');
225: hr_utility.raise_error;
226: end if;
227:
228: else
229:

Line 307: hr_utility.trace('Add Custom XML starts here .... ');

303:
304:
305: BEGIN
306:
307: hr_utility.trace('Add Custom XML starts here .... ');
308:
309: l_payroll_action_id
310: := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
311: l_override_cpa_code

Line 316: hr_utility.trace('l_payroll_action_id = ' ||

312: := pay_magtape_generic.get_parameter_value('OVERRIDE_CPA_CODE');
313: l_dd_type
314: := pay_magtape_generic.get_parameter_value('MAGTAPE_REPORT_ID');
315:
316: hr_utility.trace('l_payroll_action_id = ' ||
317: to_char(l_payroll_action_id));
318: hr_utility.trace('l_override_cpa_code = ' || l_override_cpa_code);
319:
320: OPEN cur_ppa(l_payroll_action_id);

Line 318: hr_utility.trace('l_override_cpa_code = ' || l_override_cpa_code);

314: := pay_magtape_generic.get_parameter_value('MAGTAPE_REPORT_ID');
315:
316: hr_utility.trace('l_payroll_action_id = ' ||
317: to_char(l_payroll_action_id));
318: hr_utility.trace('l_override_cpa_code = ' || l_override_cpa_code);
319:
320: OPEN cur_ppa(l_payroll_action_id);
321: FETCH cur_ppa
322: INTO l_payment_date,

Line 326: hr_utility.trace('l_payment_date = ' || to_char(l_payment_date));

322: INTO l_payment_date,
323: l_direct_deposit_date;
324: CLOSE cur_ppa;
325:
326: hr_utility.trace('l_payment_date = ' || to_char(l_payment_date));
327: hr_utility.trace('l_direct_deposit_date = ' ||
328: to_char(l_direct_deposit_date));
329: SELECT
330: decode(l_dd_type, 'NOVA_SCOT',to_char(l_direct_deposit_date,'YYDDD'),

Line 327: hr_utility.trace('l_direct_deposit_date = ' ||

323: l_direct_deposit_date;
324: CLOSE cur_ppa;
325:
326: hr_utility.trace('l_payment_date = ' || to_char(l_payment_date));
327: hr_utility.trace('l_direct_deposit_date = ' ||
328: to_char(l_direct_deposit_date));
329: SELECT
330: decode(l_dd_type, 'NOVA_SCOT',to_char(l_direct_deposit_date,'YYDDD'),
331: 'TD', to_char(l_direct_deposit_date,'DDMMYY'),

Line 354: hr_utility.trace('Add Custom XML ends here .......');

350: ''|| l_dd_date || '' ||
351: '' || l_override_cpa_code || '';
352:
353: pay_core_files.write_to_magtape_lob(l_text);
354: hr_utility.trace('Add Custom XML ends here .......');
355:
356: END add_custom_xml;
357:
358: ---- Procedures / Functions Added for CA PDF Payslip enhancement. (Bug 9445414)

Line 580: hr_utility.trace('Add Custom XML starts here .... ');

576: /* Changes for Chequewriter (XML) Third party Chequewriter (XML) and Deposit Advice (XML) Enhancements ends here*/
577:
578: BEGIN
579:
580: hr_utility.trace('Add Custom XML starts here .... ');
581: hr_utility.trace('DETAILS-------'||P_ASSIGNMENT_ACTION_ID||'---'||P_ACTION_INFORMATION_CATEGORY||'---'||P_DOCUMENT_TYPE);
582:
583: l_payroll_action_id
584: := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');

Line 581: hr_utility.trace('DETAILS-------'||P_ASSIGNMENT_ACTION_ID||'---'||P_ACTION_INFORMATION_CATEGORY||'---'||P_DOCUMENT_TYPE);

577:
578: BEGIN
579:
580: hr_utility.trace('Add Custom XML starts here .... ');
581: hr_utility.trace('DETAILS-------'||P_ASSIGNMENT_ACTION_ID||'---'||P_ACTION_INFORMATION_CATEGORY||'---'||P_DOCUMENT_TYPE);
582:
583: l_payroll_action_id
584: := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
585: l_override_cpa_code

Line 729: hr_utility.trace('sbachu employee details.......');

725: AND p_action_information_category IS NOT NULL THEN
726:
727:
728: IF p_action_information_category = 'EMPLOYEE DETAILS' THEN
729: hr_utility.trace('sbachu employee details.......');
730: OPEN get_check_depoad_details(P_ASSIGNMENT_ACTION_ID,
731: pay_archive_chequewriter.g_chq_asg_action_id);
732: FETCH get_check_depoad_details INTO ln_check_value,
733: lv_category,

Line 743: hr_utility.trace('sbachu employee details2.......');

739: lv_bank_branch,
740: lv_check_number;
741: CLOSE get_check_depoad_details;
742: IF lv_category = 'CH' THEN
743: hr_utility.trace('sbachu employee details2.......');
744: pay_payroll_xml_extract_pkg.load_xml_data('D','CHECK_NUMBER',lv_check_number);
745: lv_amount_in_word := CF_word_amountFormula(ln_check_value);
746: pay_payroll_xml_extract_pkg.load_xml_data('D','AMOUNT_IN_WORDS',lv_amount_in_word);
747: pay_payroll_xml_extract_pkg.load_xml_data('D','CHECK_AMOUNT',ln_check_value);

Line 783: hr_utility.trace('sbachu AC SUMMARY YTD.......');

779: END IF;
780: END IF;
781:
782: IF p_action_information_category = 'AC SUMMARY YTD' THEN
783: hr_utility.trace('sbachu AC SUMMARY YTD.......');
784: OPEN get_net_pay_ytd(p_assignment_action_id);
785: FETCH get_net_pay_ytd INTO ln_net_pay_ytd;
786: pay_payroll_xml_extract_pkg.load_xml_data('D','NET_PAY_YTD',ln_net_pay_ytd );
787: CLOSE get_net_pay_ytd;

Line 792: hr_utility.trace('sbachu AC SUMMARY current.......');

788:
789: END IF;
790:
791: IF p_action_information_category = 'AC SUMMARY CURRENT' THEN
792: hr_utility.trace('sbachu AC SUMMARY current.......');
793: OPEN get_net_pay(p_assignment_action_id);
794: FETCH get_net_pay into ln_amount;
795: CLOSE get_net_pay;
796:

Line 822: hr_utility.trace('Null Action Information Category');

818:
819: IF P_DOCUMENT_TYPE like '%THIRD%PARTY%CHEQUE%WRITER' AND
820: (P_ACTION_INFORMATION_CATEGORY IS NULL)
821: THEN
822: hr_utility.trace('Null Action Information Category');
823: END IF;
824:
825: IF p_document_type <> 'PAYSLIP' and p_document_type <> 'ARCHIVE_CHEQUE_WRITER' and P_DOCUMENT_TYPE not like '%THIRD%PARTY%CHEQUE%WRITER' THEN
826:

Line 828: hr_utility.trace('l_payroll_action_id = ' ||

824:
825: IF p_document_type <> 'PAYSLIP' and p_document_type <> 'ARCHIVE_CHEQUE_WRITER' and P_DOCUMENT_TYPE not like '%THIRD%PARTY%CHEQUE%WRITER' THEN
826:
827:
828: hr_utility.trace('l_payroll_action_id = ' ||
829: to_char(l_payroll_action_id));
830: hr_utility.trace('l_override_cpa_code = ' || l_override_cpa_code);
831:
832: OPEN cur_ppa(l_payroll_action_id);

Line 830: hr_utility.trace('l_override_cpa_code = ' || l_override_cpa_code);

826:
827:
828: hr_utility.trace('l_payroll_action_id = ' ||
829: to_char(l_payroll_action_id));
830: hr_utility.trace('l_override_cpa_code = ' || l_override_cpa_code);
831:
832: OPEN cur_ppa(l_payroll_action_id);
833: FETCH cur_ppa
834: INTO l_payment_date,

Line 838: hr_utility.trace('l_payment_date = ' || to_char(l_payment_date));

834: INTO l_payment_date,
835: l_direct_deposit_date;
836: CLOSE cur_ppa;
837:
838: hr_utility.trace('l_payment_date = ' || to_char(l_payment_date));
839: hr_utility.trace('l_direct_deposit_date = ' ||
840: to_char(l_direct_deposit_date));
841: SELECT
842: decode(l_dd_type, 'NOVA_SCOT',to_char(l_direct_deposit_date,'YYDDD'),

Line 839: hr_utility.trace('l_direct_deposit_date = ' ||

835: l_direct_deposit_date;
836: CLOSE cur_ppa;
837:
838: hr_utility.trace('l_payment_date = ' || to_char(l_payment_date));
839: hr_utility.trace('l_direct_deposit_date = ' ||
840: to_char(l_direct_deposit_date));
841: SELECT
842: decode(l_dd_type, 'NOVA_SCOT',to_char(l_direct_deposit_date,'YYDDD'),
843: 'TD', to_char(l_direct_deposit_date,'DDMMYY'),

Line 868: hr_utility.trace('Add Custom XML ends here .......');

864:
865: pay_core_files.write_to_magtape_lob(l_text);
866:
867: END IF;
868: hr_utility.trace('Add Custom XML ends here .......');
869: /* Changes for Chequewriter (XML) Third party Chequewriter (XML) and Deposit Advice (XML) Enhancements ends here*/
870:
871: END add_custom_xml;
872:

Line 1068: hr_utility.trace('Getting ID_FLEX_NUM for CA legislation ');

1064: c_ws_tab_name := 'COMPANY WORK SCHEDULES';
1065:
1066: /* get ID FLEX NUM */
1067: --IF pay_us_rules.g_id_flex_num IS NULL THEN
1068: hr_utility.trace('Getting ID_FLEX_NUM for CA legislation ');
1069: OPEN get_id_flex_num;
1070: FETCH get_id_flex_num INTO l_id_flex_num;
1071: -- pay_us_rules.g_id_flex_num := l_id_flex_num;
1072: CLOSE get_id_flex_num;

Line 1075: -- hr_utility.trace('pay_us_rules.g_id_flex_num '||pay_us_rules.g_id_flex_num);

1071: -- pay_us_rules.g_id_flex_num := l_id_flex_num;
1072: CLOSE get_id_flex_num;
1073: --END IF;
1074:
1075: -- hr_utility.trace('pay_us_rules.g_id_flex_num '||pay_us_rules.g_id_flex_num);
1076: hr_utility.trace('l_id_flex_num '||l_id_flex_num);
1077: hr_utility.trace('assignment_action_id=' || assignment_action_id);
1078: hr_utility.trace('assignment_id=' || assignment_id);
1079: hr_utility.trace('business_group_id=' || p_bg_id);

Line 1076: hr_utility.trace('l_id_flex_num '||l_id_flex_num);

1072: CLOSE get_id_flex_num;
1073: --END IF;
1074:
1075: -- hr_utility.trace('pay_us_rules.g_id_flex_num '||pay_us_rules.g_id_flex_num);
1076: hr_utility.trace('l_id_flex_num '||l_id_flex_num);
1077: hr_utility.trace('assignment_action_id=' || assignment_action_id);
1078: hr_utility.trace('assignment_id=' || assignment_id);
1079: hr_utility.trace('business_group_id=' || p_bg_id);
1080: hr_utility.trace('p_range_start=' || p_range_start);

Line 1077: hr_utility.trace('assignment_action_id=' || assignment_action_id);

1073: --END IF;
1074:
1075: -- hr_utility.trace('pay_us_rules.g_id_flex_num '||pay_us_rules.g_id_flex_num);
1076: hr_utility.trace('l_id_flex_num '||l_id_flex_num);
1077: hr_utility.trace('assignment_action_id=' || assignment_action_id);
1078: hr_utility.trace('assignment_id=' || assignment_id);
1079: hr_utility.trace('business_group_id=' || p_bg_id);
1080: hr_utility.trace('p_range_start=' || p_range_start);
1081: hr_utility.trace('p_range_end=' || p_range_end);

Line 1078: hr_utility.trace('assignment_id=' || assignment_id);

1074:
1075: -- hr_utility.trace('pay_us_rules.g_id_flex_num '||pay_us_rules.g_id_flex_num);
1076: hr_utility.trace('l_id_flex_num '||l_id_flex_num);
1077: hr_utility.trace('assignment_action_id=' || assignment_action_id);
1078: hr_utility.trace('assignment_id=' || assignment_id);
1079: hr_utility.trace('business_group_id=' || p_bg_id);
1080: hr_utility.trace('p_range_start=' || p_range_start);
1081: hr_utility.trace('p_range_end=' || p_range_end);
1082: hr_utility.trace('element_entry_id=' || element_entry_id);

Line 1079: hr_utility.trace('business_group_id=' || p_bg_id);

1075: -- hr_utility.trace('pay_us_rules.g_id_flex_num '||pay_us_rules.g_id_flex_num);
1076: hr_utility.trace('l_id_flex_num '||l_id_flex_num);
1077: hr_utility.trace('assignment_action_id=' || assignment_action_id);
1078: hr_utility.trace('assignment_id=' || assignment_id);
1079: hr_utility.trace('business_group_id=' || p_bg_id);
1080: hr_utility.trace('p_range_start=' || p_range_start);
1081: hr_utility.trace('p_range_end=' || p_range_end);
1082: hr_utility.trace('element_entry_id=' || element_entry_id);
1083: hr_utility.trace('date_earned ' || date_earned);

Line 1080: hr_utility.trace('p_range_start=' || p_range_start);

1076: hr_utility.trace('l_id_flex_num '||l_id_flex_num);
1077: hr_utility.trace('assignment_action_id=' || assignment_action_id);
1078: hr_utility.trace('assignment_id=' || assignment_id);
1079: hr_utility.trace('business_group_id=' || p_bg_id);
1080: hr_utility.trace('p_range_start=' || p_range_start);
1081: hr_utility.trace('p_range_end=' || p_range_end);
1082: hr_utility.trace('element_entry_id=' || element_entry_id);
1083: hr_utility.trace('date_earned ' || date_earned);
1084:

Line 1081: hr_utility.trace('p_range_end=' || p_range_end);

1077: hr_utility.trace('assignment_action_id=' || assignment_action_id);
1078: hr_utility.trace('assignment_id=' || assignment_id);
1079: hr_utility.trace('business_group_id=' || p_bg_id);
1080: hr_utility.trace('p_range_start=' || p_range_start);
1081: hr_utility.trace('p_range_end=' || p_range_end);
1082: hr_utility.trace('element_entry_id=' || element_entry_id);
1083: hr_utility.trace('date_earned ' || date_earned);
1084:
1085: /* get work schedule_name */

Line 1082: hr_utility.trace('element_entry_id=' || element_entry_id);

1078: hr_utility.trace('assignment_id=' || assignment_id);
1079: hr_utility.trace('business_group_id=' || p_bg_id);
1080: hr_utility.trace('p_range_start=' || p_range_start);
1081: hr_utility.trace('p_range_end=' || p_range_end);
1082: hr_utility.trace('element_entry_id=' || element_entry_id);
1083: hr_utility.trace('date_earned ' || date_earned);
1084:
1085: /* get work schedule_name */
1086: --IF pay_us_rules.g_id_flex_num IS NOT NULL THEN

Line 1083: hr_utility.trace('date_earned ' || date_earned);

1079: hr_utility.trace('business_group_id=' || p_bg_id);
1080: hr_utility.trace('p_range_start=' || p_range_start);
1081: hr_utility.trace('p_range_end=' || p_range_end);
1082: hr_utility.trace('element_entry_id=' || element_entry_id);
1083: hr_utility.trace('date_earned ' || date_earned);
1084:
1085: /* get work schedule_name */
1086: --IF pay_us_rules.g_id_flex_num IS NOT NULL THEN
1087: IF l_id_flex_num IS NOT NULL THEN

Line 1088: hr_utility.trace('getting work schedule name ');

1084:
1085: /* get work schedule_name */
1086: --IF pay_us_rules.g_id_flex_num IS NOT NULL THEN
1087: IF l_id_flex_num IS NOT NULL THEN
1088: hr_utility.trace('getting work schedule name ');
1089: OPEN get_ws_name (l_id_flex_num,--pay_ca_rules.g_id_flex_num,
1090: date_earned,
1091: assignment_id);
1092: FETCH get_ws_name INTO p_ws_name;

Line 1097: hr_utility.trace('Work Schedule not found ');

1093: CLOSE get_ws_name;
1094: END IF;
1095:
1096: IF p_ws_name IS NULL THEN
1097: hr_utility.trace('Work Schedule not found ');
1098: return 0;
1099: END IF;
1100:
1101: hr_utility.trace('Work Schedule '||p_ws_name);

Line 1101: hr_utility.trace('Work Schedule '||p_ws_name);

1097: hr_utility.trace('Work Schedule not found ');
1098: return 0;
1099: END IF;
1100:
1101: hr_utility.trace('Work Schedule '||p_ws_name);
1102:
1103: --changed to select the work schedule defined
1104: --at the business group level instead of
1105: --hardcoding the default work schedule

Line 1134: -- hr_utility.set_message(801,'PAY_xxxx_INVALID_DATE_RANGE');

1130: -- Check for valid range
1131: IF v_range_start > v_range_end THEN
1132: --
1133: RETURN v_total_hours;
1134: -- hr_utility.set_message(801,'PAY_xxxx_INVALID_DATE_RANGE');
1135: -- hr_utility.raise_error;
1136: --
1137: END IF;
1138:

Line 1135: -- hr_utility.raise_error;

1131: IF v_range_start > v_range_end THEN
1132: --
1133: RETURN v_total_hours;
1134: -- hr_utility.set_message(801,'PAY_xxxx_INVALID_DATE_RANGE');
1135: -- hr_utility.raise_error;
1136: --
1137: END IF;
1138:
1139: -- Get_Table_Value requires row in FND_SESSIONS. We must insert this

Line 1244: hr_utility.trace('Starting pay_ca_rules.get_file_creation_number !!!!');

1240: l_dd_format VARCHAR2(30);
1241:
1242: BEGIN
1243:
1244: hr_utility.trace('Starting pay_ca_rules.get_file_creation_number !!!!');
1245:
1246: OPEN cur_paid;
1247: FETCH cur_paid
1248: INTO l_legislative_parameter,

Line 1260: hr_utility.trace('payroll_action_id = ' || to_char(pactid));

1256: l_legislative_parameter);
1257: l_dd_format := pay_core_utils.get_parameter('MAGTAPE_REPORT_ID',
1258: l_legislative_parameter);
1259:
1260: hr_utility.trace('payroll_action_id = ' || to_char(pactid));
1261: hr_utility.trace('l_org_pm_id = ' || to_char(l_org_pm_id));
1262: hr_utility.trace('l_bg_id = ' || to_char(l_bg_id));
1263: hr_utility.trace('l_legislative_parameter = ' || l_legislative_parameter);
1264: hr_utility.trace('l_override_file_no = ' || l_override_file_no);

Line 1261: hr_utility.trace('l_org_pm_id = ' || to_char(l_org_pm_id));

1257: l_dd_format := pay_core_utils.get_parameter('MAGTAPE_REPORT_ID',
1258: l_legislative_parameter);
1259:
1260: hr_utility.trace('payroll_action_id = ' || to_char(pactid));
1261: hr_utility.trace('l_org_pm_id = ' || to_char(l_org_pm_id));
1262: hr_utility.trace('l_bg_id = ' || to_char(l_bg_id));
1263: hr_utility.trace('l_legislative_parameter = ' || l_legislative_parameter);
1264: hr_utility.trace('l_override_file_no = ' || l_override_file_no);
1265: hr_utility.trace('l_dd_format = ' || l_dd_format);

Line 1262: hr_utility.trace('l_bg_id = ' || to_char(l_bg_id));

1258: l_legislative_parameter);
1259:
1260: hr_utility.trace('payroll_action_id = ' || to_char(pactid));
1261: hr_utility.trace('l_org_pm_id = ' || to_char(l_org_pm_id));
1262: hr_utility.trace('l_bg_id = ' || to_char(l_bg_id));
1263: hr_utility.trace('l_legislative_parameter = ' || l_legislative_parameter);
1264: hr_utility.trace('l_override_file_no = ' || l_override_file_no);
1265: hr_utility.trace('l_dd_format = ' || l_dd_format);
1266:

Line 1263: hr_utility.trace('l_legislative_parameter = ' || l_legislative_parameter);

1259:
1260: hr_utility.trace('payroll_action_id = ' || to_char(pactid));
1261: hr_utility.trace('l_org_pm_id = ' || to_char(l_org_pm_id));
1262: hr_utility.trace('l_bg_id = ' || to_char(l_bg_id));
1263: hr_utility.trace('l_legislative_parameter = ' || l_legislative_parameter);
1264: hr_utility.trace('l_override_file_no = ' || l_override_file_no);
1265: hr_utility.trace('l_dd_format = ' || l_dd_format);
1266:
1267: IF l_override_file_no IS NOT NULL THEN

Line 1264: hr_utility.trace('l_override_file_no = ' || l_override_file_no);

1260: hr_utility.trace('payroll_action_id = ' || to_char(pactid));
1261: hr_utility.trace('l_org_pm_id = ' || to_char(l_org_pm_id));
1262: hr_utility.trace('l_bg_id = ' || to_char(l_bg_id));
1263: hr_utility.trace('l_legislative_parameter = ' || l_legislative_parameter);
1264: hr_utility.trace('l_override_file_no = ' || l_override_file_no);
1265: hr_utility.trace('l_dd_format = ' || l_dd_format);
1266:
1267: IF l_override_file_no IS NOT NULL THEN
1268: file_no := l_override_file_no;

Line 1265: hr_utility.trace('l_dd_format = ' || l_dd_format);

1261: hr_utility.trace('l_org_pm_id = ' || to_char(l_org_pm_id));
1262: hr_utility.trace('l_bg_id = ' || to_char(l_bg_id));
1263: hr_utility.trace('l_legislative_parameter = ' || l_legislative_parameter);
1264: hr_utility.trace('l_override_file_no = ' || l_override_file_no);
1265: hr_utility.trace('l_dd_format = ' || l_dd_format);
1266:
1267: IF l_override_file_no IS NOT NULL THEN
1268: file_no := l_override_file_no;
1269: ELSE

Line 1278: hr_utility.trace('file_no = ' || file_no);

1274: pactid ,
1275: l_bg_id) ;
1276: END IF;
1277:
1278: hr_utility.trace('file_no = ' || file_no);
1279: hr_utility.trace('Ending pay_ca_rules.get_file_creation_number !!!!');
1280:
1281: END get_file_creation_no;
1282: /* Changes for Deposit Advice (XML) Enhancements starts here*/

Line 1279: hr_utility.trace('Ending pay_ca_rules.get_file_creation_number !!!!');

1275: l_bg_id) ;
1276: END IF;
1277:
1278: hr_utility.trace('file_no = ' || file_no);
1279: hr_utility.trace('Ending pay_ca_rules.get_file_creation_number !!!!');
1280:
1281: END get_file_creation_no;
1282: /* Changes for Deposit Advice (XML) Enhancements starts here*/
1283:

Line 1290: hr_utility.trace('Entering pay_ca_rules.payslip_range_cursor');

1286:
1287: lv_sqlstr VARCHAR2(32000);
1288:
1289: BEGIN
1290: hr_utility.trace('Entering pay_ca_rules.payslip_range_cursor');
1291: lv_sqlstr := NULL;
1292: pycadar_pkg.range_cursor (pactid => p_pactid, sqlstr => lv_sqlstr);
1293: hr_utility.trace('Returning lv_sqlstr := ' || lv_sqlstr);
1294:

Line 1293: hr_utility.trace('Returning lv_sqlstr := ' || lv_sqlstr);

1289: BEGIN
1290: hr_utility.trace('Entering pay_ca_rules.payslip_range_cursor');
1291: lv_sqlstr := NULL;
1292: pycadar_pkg.range_cursor (pactid => p_pactid, sqlstr => lv_sqlstr);
1293: hr_utility.trace('Returning lv_sqlstr := ' || lv_sqlstr);
1294:
1295: p_sqlstr := lv_sqlstr;
1296:
1297: END payslip_range_cursor;