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_IN_TRX_IDENTIFIERS dependencies on PAY_IN_UTILS

Line 41: pay_in_utils.set_location(g_debug,'Entering : '||l_procedure,10);

37: BEGIN
38:
39: g_debug := hr_utility.debug_enabled;
40: l_procedure := g_package || 'get_parameters';
41: pay_in_utils.set_location(g_debug,'Entering : '||l_procedure,10);
42:
43:
44: l_token_value := SUBSTR(p_legislative_parameters||' ',
45: INSTR(p_legislative_parameters||' ',p_token_name||'=')+(LENGTH(p_token_name||'=')),

Line 51: pay_in_utils.trace('p_legislative_parameters ',p_legislative_parameters);

47: INSTR(p_legislative_parameters||' ',p_token_name||'='))
48: - (INSTR(p_legislative_parameters||' ',p_token_name||'=')+LENGTH(p_token_name||'=')));
49:
50: IF g_debug THEN
51: pay_in_utils.trace('p_legislative_parameters ',p_legislative_parameters);
52: pay_in_utils.trace('p_token_name ',p_token_name);
53: pay_in_utils.trace('l_token_value ',l_token_value);
54: END IF;
55:

Line 52: pay_in_utils.trace('p_token_name ',p_token_name);

48: - (INSTR(p_legislative_parameters||' ',p_token_name||'=')+LENGTH(p_token_name||'=')));
49:
50: IF g_debug THEN
51: pay_in_utils.trace('p_legislative_parameters ',p_legislative_parameters);
52: pay_in_utils.trace('p_token_name ',p_token_name);
53: pay_in_utils.trace('l_token_value ',l_token_value);
54: END IF;
55:
56: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);

Line 53: pay_in_utils.trace('l_token_value ',l_token_value);

49:
50: IF g_debug THEN
51: pay_in_utils.trace('p_legislative_parameters ',p_legislative_parameters);
52: pay_in_utils.trace('p_token_name ',p_token_name);
53: pay_in_utils.trace('l_token_value ',l_token_value);
54: END IF;
55:
56: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);
57: RETURN l_token_value ;

Line 56: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);

52: pay_in_utils.trace('p_token_name ',p_token_name);
53: pay_in_utils.trace('l_token_value ',l_token_value);
54: END IF;
55:
56: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);
57: RETURN l_token_value ;
58: EXCEPTION
59: WHEN OTHERS THEN
60: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR',

Line 60: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR',

56: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);
57: RETURN l_token_value ;
58: EXCEPTION
59: WHEN OTHERS THEN
60: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR',
61: 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
62: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
63: RAISE ;
64: END get_parameters;

Line 62: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);

58: EXCEPTION
59: WHEN OTHERS THEN
60: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR',
61: 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
62: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
63: RAISE ;
64: END get_parameters;
65:
66:

Line 188: pay_in_utils.set_location(g_debug,'Entering : '||l_procedure,10);

184: BEGIN
185:
186: g_debug := hr_utility.debug_enabled;
187: l_procedure := g_package || 'batch_transaction_identifiers';
188: pay_in_utils.set_location(g_debug,'Entering : '||l_procedure,10);
189:
190: IF g_debug THEN
191: pay_in_utils.trace('p_effective_date ',p_effective_date);
192: pay_in_utils.trace('p_identifier_name ',p_identifier_name);

Line 191: pay_in_utils.trace('p_effective_date ',p_effective_date);

187: l_procedure := g_package || 'batch_transaction_identifiers';
188: pay_in_utils.set_location(g_debug,'Entering : '||l_procedure,10);
189:
190: IF g_debug THEN
191: pay_in_utils.trace('p_effective_date ',p_effective_date);
192: pay_in_utils.trace('p_identifier_name ',p_identifier_name);
193: pay_in_utils.trace('p_payroll_action_id ',p_payroll_action_id);
194: pay_in_utils.trace('p_payment_type_id ',p_payment_type_id);
195: pay_in_utils.trace('p_org_payment_method_id ',p_org_payment_method_id);

Line 192: pay_in_utils.trace('p_identifier_name ',p_identifier_name);

188: pay_in_utils.set_location(g_debug,'Entering : '||l_procedure,10);
189:
190: IF g_debug THEN
191: pay_in_utils.trace('p_effective_date ',p_effective_date);
192: pay_in_utils.trace('p_identifier_name ',p_identifier_name);
193: pay_in_utils.trace('p_payroll_action_id ',p_payroll_action_id);
194: pay_in_utils.trace('p_payment_type_id ',p_payment_type_id);
195: pay_in_utils.trace('p_org_payment_method_id ',p_org_payment_method_id);
196: pay_in_utils.trace('p_personal_payment_method_id',p_personal_payment_method_id);

Line 193: pay_in_utils.trace('p_payroll_action_id ',p_payroll_action_id);

189:
190: IF g_debug THEN
191: pay_in_utils.trace('p_effective_date ',p_effective_date);
192: pay_in_utils.trace('p_identifier_name ',p_identifier_name);
193: pay_in_utils.trace('p_payroll_action_id ',p_payroll_action_id);
194: pay_in_utils.trace('p_payment_type_id ',p_payment_type_id);
195: pay_in_utils.trace('p_org_payment_method_id ',p_org_payment_method_id);
196: pay_in_utils.trace('p_personal_payment_method_id',p_personal_payment_method_id);
197: pay_in_utils.trace('p_assignment_action_id ',p_assignment_action_id);

Line 194: pay_in_utils.trace('p_payment_type_id ',p_payment_type_id);

190: IF g_debug THEN
191: pay_in_utils.trace('p_effective_date ',p_effective_date);
192: pay_in_utils.trace('p_identifier_name ',p_identifier_name);
193: pay_in_utils.trace('p_payroll_action_id ',p_payroll_action_id);
194: pay_in_utils.trace('p_payment_type_id ',p_payment_type_id);
195: pay_in_utils.trace('p_org_payment_method_id ',p_org_payment_method_id);
196: pay_in_utils.trace('p_personal_payment_method_id',p_personal_payment_method_id);
197: pay_in_utils.trace('p_assignment_action_id ',p_assignment_action_id);
198: pay_in_utils.trace('p_pre_payment_id ',p_pre_payment_id);

Line 195: pay_in_utils.trace('p_org_payment_method_id ',p_org_payment_method_id);

191: pay_in_utils.trace('p_effective_date ',p_effective_date);
192: pay_in_utils.trace('p_identifier_name ',p_identifier_name);
193: pay_in_utils.trace('p_payroll_action_id ',p_payroll_action_id);
194: pay_in_utils.trace('p_payment_type_id ',p_payment_type_id);
195: pay_in_utils.trace('p_org_payment_method_id ',p_org_payment_method_id);
196: pay_in_utils.trace('p_personal_payment_method_id',p_personal_payment_method_id);
197: pay_in_utils.trace('p_assignment_action_id ',p_assignment_action_id);
198: pay_in_utils.trace('p_pre_payment_id ',p_pre_payment_id);
199: pay_in_utils.trace('p_delimiter_string ',p_delimiter_string);

Line 196: pay_in_utils.trace('p_personal_payment_method_id',p_personal_payment_method_id);

192: pay_in_utils.trace('p_identifier_name ',p_identifier_name);
193: pay_in_utils.trace('p_payroll_action_id ',p_payroll_action_id);
194: pay_in_utils.trace('p_payment_type_id ',p_payment_type_id);
195: pay_in_utils.trace('p_org_payment_method_id ',p_org_payment_method_id);
196: pay_in_utils.trace('p_personal_payment_method_id',p_personal_payment_method_id);
197: pay_in_utils.trace('p_assignment_action_id ',p_assignment_action_id);
198: pay_in_utils.trace('p_pre_payment_id ',p_pre_payment_id);
199: pay_in_utils.trace('p_delimiter_string ',p_delimiter_string);
200: END IF;

Line 197: pay_in_utils.trace('p_assignment_action_id ',p_assignment_action_id);

193: pay_in_utils.trace('p_payroll_action_id ',p_payroll_action_id);
194: pay_in_utils.trace('p_payment_type_id ',p_payment_type_id);
195: pay_in_utils.trace('p_org_payment_method_id ',p_org_payment_method_id);
196: pay_in_utils.trace('p_personal_payment_method_id',p_personal_payment_method_id);
197: pay_in_utils.trace('p_assignment_action_id ',p_assignment_action_id);
198: pay_in_utils.trace('p_pre_payment_id ',p_pre_payment_id);
199: pay_in_utils.trace('p_delimiter_string ',p_delimiter_string);
200: END IF;
201:

Line 198: pay_in_utils.trace('p_pre_payment_id ',p_pre_payment_id);

194: pay_in_utils.trace('p_payment_type_id ',p_payment_type_id);
195: pay_in_utils.trace('p_org_payment_method_id ',p_org_payment_method_id);
196: pay_in_utils.trace('p_personal_payment_method_id',p_personal_payment_method_id);
197: pay_in_utils.trace('p_assignment_action_id ',p_assignment_action_id);
198: pay_in_utils.trace('p_pre_payment_id ',p_pre_payment_id);
199: pay_in_utils.trace('p_delimiter_string ',p_delimiter_string);
200: END IF;
201:
202:

Line 199: pay_in_utils.trace('p_delimiter_string ',p_delimiter_string);

195: pay_in_utils.trace('p_org_payment_method_id ',p_org_payment_method_id);
196: pay_in_utils.trace('p_personal_payment_method_id',p_personal_payment_method_id);
197: pay_in_utils.trace('p_assignment_action_id ',p_assignment_action_id);
198: pay_in_utils.trace('p_pre_payment_id ',p_pre_payment_id);
199: pay_in_utils.trace('p_delimiter_string ',p_delimiter_string);
200: END IF;
201:
202:
203: OPEN csr_emp_tran_details(p_payroll_action_id, p_org_payment_method_id, p_assignment_action_id);

Line 218: pay_in_utils.set_location(g_debug,'In : '||l_procedure,20);

214: ,l_request_id
215: ,l_bank_acc_num;
216: CLOSE csr_emp_tran_details ;
217:
218: pay_in_utils.set_location(g_debug,'In : '||l_procedure,20);
219:
220: l_payment_date := get_parameters(l_leg_param,'PAYMENT_DATE_PARAM') ;
221: l_reg_comp := get_parameters(l_leg_param,'REGISTERED_EMPLOYER_PARAM') ;
222:

Line 227: pay_in_utils.set_location(g_debug,'In : '||l_procedure,30);

223: OPEN csr_reg_comp(l_reg_comp);
224: FETCH csr_reg_comp INTO l_reg_comp_name;
225: CLOSE csr_reg_comp;
226:
227: pay_in_utils.set_location(g_debug,'In : '||l_procedure,30);
228:
229: IF g_debug THEN
230: pay_in_utils.trace('l_emp_num ',l_emp_num);
231: pay_in_utils.trace('l_emp_name1 ',l_emp_name1);

Line 230: pay_in_utils.trace('l_emp_num ',l_emp_num);

226:
227: pay_in_utils.set_location(g_debug,'In : '||l_procedure,30);
228:
229: IF g_debug THEN
230: pay_in_utils.trace('l_emp_num ',l_emp_num);
231: pay_in_utils.trace('l_emp_name1 ',l_emp_name1);
232: pay_in_utils.trace('l_emp_name2 ',l_emp_name2);
233: pay_in_utils.trace('l_emp_name3 ',l_emp_name3);
234: pay_in_utils.trace('l_emp_bank ',l_emp_bank);

Line 231: pay_in_utils.trace('l_emp_name1 ',l_emp_name1);

227: pay_in_utils.set_location(g_debug,'In : '||l_procedure,30);
228:
229: IF g_debug THEN
230: pay_in_utils.trace('l_emp_num ',l_emp_num);
231: pay_in_utils.trace('l_emp_name1 ',l_emp_name1);
232: pay_in_utils.trace('l_emp_name2 ',l_emp_name2);
233: pay_in_utils.trace('l_emp_name3 ',l_emp_name3);
234: pay_in_utils.trace('l_emp_bank ',l_emp_bank);
235: pay_in_utils.trace('l_emp_branch ',l_emp_branch);

Line 232: pay_in_utils.trace('l_emp_name2 ',l_emp_name2);

228:
229: IF g_debug THEN
230: pay_in_utils.trace('l_emp_num ',l_emp_num);
231: pay_in_utils.trace('l_emp_name1 ',l_emp_name1);
232: pay_in_utils.trace('l_emp_name2 ',l_emp_name2);
233: pay_in_utils.trace('l_emp_name3 ',l_emp_name3);
234: pay_in_utils.trace('l_emp_bank ',l_emp_bank);
235: pay_in_utils.trace('l_emp_branch ',l_emp_branch);
236: pay_in_utils.trace('l_emp_acc_name ',l_emp_acc_name);

Line 233: pay_in_utils.trace('l_emp_name3 ',l_emp_name3);

229: IF g_debug THEN
230: pay_in_utils.trace('l_emp_num ',l_emp_num);
231: pay_in_utils.trace('l_emp_name1 ',l_emp_name1);
232: pay_in_utils.trace('l_emp_name2 ',l_emp_name2);
233: pay_in_utils.trace('l_emp_name3 ',l_emp_name3);
234: pay_in_utils.trace('l_emp_bank ',l_emp_bank);
235: pay_in_utils.trace('l_emp_branch ',l_emp_branch);
236: pay_in_utils.trace('l_emp_acc_name ',l_emp_acc_name);
237: pay_in_utils.trace('l_emp_acc_num ',l_emp_acc_num);

Line 234: pay_in_utils.trace('l_emp_bank ',l_emp_bank);

230: pay_in_utils.trace('l_emp_num ',l_emp_num);
231: pay_in_utils.trace('l_emp_name1 ',l_emp_name1);
232: pay_in_utils.trace('l_emp_name2 ',l_emp_name2);
233: pay_in_utils.trace('l_emp_name3 ',l_emp_name3);
234: pay_in_utils.trace('l_emp_bank ',l_emp_bank);
235: pay_in_utils.trace('l_emp_branch ',l_emp_branch);
236: pay_in_utils.trace('l_emp_acc_name ',l_emp_acc_name);
237: pay_in_utils.trace('l_emp_acc_num ',l_emp_acc_num);
238: pay_in_utils.trace('l_leg_param ',l_leg_param);

Line 235: pay_in_utils.trace('l_emp_branch ',l_emp_branch);

231: pay_in_utils.trace('l_emp_name1 ',l_emp_name1);
232: pay_in_utils.trace('l_emp_name2 ',l_emp_name2);
233: pay_in_utils.trace('l_emp_name3 ',l_emp_name3);
234: pay_in_utils.trace('l_emp_bank ',l_emp_bank);
235: pay_in_utils.trace('l_emp_branch ',l_emp_branch);
236: pay_in_utils.trace('l_emp_acc_name ',l_emp_acc_name);
237: pay_in_utils.trace('l_emp_acc_num ',l_emp_acc_num);
238: pay_in_utils.trace('l_leg_param ',l_leg_param);
239: pay_in_utils.trace('l_transaction_group',l_transaction_group);

Line 236: pay_in_utils.trace('l_emp_acc_name ',l_emp_acc_name);

232: pay_in_utils.trace('l_emp_name2 ',l_emp_name2);
233: pay_in_utils.trace('l_emp_name3 ',l_emp_name3);
234: pay_in_utils.trace('l_emp_bank ',l_emp_bank);
235: pay_in_utils.trace('l_emp_branch ',l_emp_branch);
236: pay_in_utils.trace('l_emp_acc_name ',l_emp_acc_name);
237: pay_in_utils.trace('l_emp_acc_num ',l_emp_acc_num);
238: pay_in_utils.trace('l_leg_param ',l_leg_param);
239: pay_in_utils.trace('l_transaction_group',l_transaction_group);
240: pay_in_utils.trace('l_request_id ',l_request_id);

Line 237: pay_in_utils.trace('l_emp_acc_num ',l_emp_acc_num);

233: pay_in_utils.trace('l_emp_name3 ',l_emp_name3);
234: pay_in_utils.trace('l_emp_bank ',l_emp_bank);
235: pay_in_utils.trace('l_emp_branch ',l_emp_branch);
236: pay_in_utils.trace('l_emp_acc_name ',l_emp_acc_name);
237: pay_in_utils.trace('l_emp_acc_num ',l_emp_acc_num);
238: pay_in_utils.trace('l_leg_param ',l_leg_param);
239: pay_in_utils.trace('l_transaction_group',l_transaction_group);
240: pay_in_utils.trace('l_request_id ',l_request_id);
241: pay_in_utils.trace('l_bank_acc_num ',l_bank_acc_num);

Line 238: pay_in_utils.trace('l_leg_param ',l_leg_param);

234: pay_in_utils.trace('l_emp_bank ',l_emp_bank);
235: pay_in_utils.trace('l_emp_branch ',l_emp_branch);
236: pay_in_utils.trace('l_emp_acc_name ',l_emp_acc_name);
237: pay_in_utils.trace('l_emp_acc_num ',l_emp_acc_num);
238: pay_in_utils.trace('l_leg_param ',l_leg_param);
239: pay_in_utils.trace('l_transaction_group',l_transaction_group);
240: pay_in_utils.trace('l_request_id ',l_request_id);
241: pay_in_utils.trace('l_bank_acc_num ',l_bank_acc_num);
242: pay_in_utils.trace('l_payment_date ',l_payment_date);

Line 239: pay_in_utils.trace('l_transaction_group',l_transaction_group);

235: pay_in_utils.trace('l_emp_branch ',l_emp_branch);
236: pay_in_utils.trace('l_emp_acc_name ',l_emp_acc_name);
237: pay_in_utils.trace('l_emp_acc_num ',l_emp_acc_num);
238: pay_in_utils.trace('l_leg_param ',l_leg_param);
239: pay_in_utils.trace('l_transaction_group',l_transaction_group);
240: pay_in_utils.trace('l_request_id ',l_request_id);
241: pay_in_utils.trace('l_bank_acc_num ',l_bank_acc_num);
242: pay_in_utils.trace('l_payment_date ',l_payment_date);
243: pay_in_utils.trace('l_reg_comp ',l_reg_comp);

Line 240: pay_in_utils.trace('l_request_id ',l_request_id);

236: pay_in_utils.trace('l_emp_acc_name ',l_emp_acc_name);
237: pay_in_utils.trace('l_emp_acc_num ',l_emp_acc_num);
238: pay_in_utils.trace('l_leg_param ',l_leg_param);
239: pay_in_utils.trace('l_transaction_group',l_transaction_group);
240: pay_in_utils.trace('l_request_id ',l_request_id);
241: pay_in_utils.trace('l_bank_acc_num ',l_bank_acc_num);
242: pay_in_utils.trace('l_payment_date ',l_payment_date);
243: pay_in_utils.trace('l_reg_comp ',l_reg_comp);
244: pay_in_utils.trace('l_reg_comp_name ',l_reg_comp_name);

Line 241: pay_in_utils.trace('l_bank_acc_num ',l_bank_acc_num);

237: pay_in_utils.trace('l_emp_acc_num ',l_emp_acc_num);
238: pay_in_utils.trace('l_leg_param ',l_leg_param);
239: pay_in_utils.trace('l_transaction_group',l_transaction_group);
240: pay_in_utils.trace('l_request_id ',l_request_id);
241: pay_in_utils.trace('l_bank_acc_num ',l_bank_acc_num);
242: pay_in_utils.trace('l_payment_date ',l_payment_date);
243: pay_in_utils.trace('l_reg_comp ',l_reg_comp);
244: pay_in_utils.trace('l_reg_comp_name ',l_reg_comp_name);
245: END IF;

Line 242: pay_in_utils.trace('l_payment_date ',l_payment_date);

238: pay_in_utils.trace('l_leg_param ',l_leg_param);
239: pay_in_utils.trace('l_transaction_group',l_transaction_group);
240: pay_in_utils.trace('l_request_id ',l_request_id);
241: pay_in_utils.trace('l_bank_acc_num ',l_bank_acc_num);
242: pay_in_utils.trace('l_payment_date ',l_payment_date);
243: pay_in_utils.trace('l_reg_comp ',l_reg_comp);
244: pay_in_utils.trace('l_reg_comp_name ',l_reg_comp_name);
245: END IF;
246:

Line 243: pay_in_utils.trace('l_reg_comp ',l_reg_comp);

239: pay_in_utils.trace('l_transaction_group',l_transaction_group);
240: pay_in_utils.trace('l_request_id ',l_request_id);
241: pay_in_utils.trace('l_bank_acc_num ',l_bank_acc_num);
242: pay_in_utils.trace('l_payment_date ',l_payment_date);
243: pay_in_utils.trace('l_reg_comp ',l_reg_comp);
244: pay_in_utils.trace('l_reg_comp_name ',l_reg_comp_name);
245: END IF;
246:
247:

Line 244: pay_in_utils.trace('l_reg_comp_name ',l_reg_comp_name);

240: pay_in_utils.trace('l_request_id ',l_request_id);
241: pay_in_utils.trace('l_bank_acc_num ',l_bank_acc_num);
242: pay_in_utils.trace('l_payment_date ',l_payment_date);
243: pay_in_utils.trace('l_reg_comp ',l_reg_comp);
244: pay_in_utils.trace('l_reg_comp_name ',l_reg_comp_name);
245: END IF;
246:
247:
248:

Line 249: pay_in_utils.set_location(g_debug,'In : '||l_procedure,40);

245: END IF;
246:
247:
248:
249: pay_in_utils.set_location(g_debug,'In : '||l_procedure,40);
250:
251: IF p_identifier_name = 'CONCATENATED_IDENTIFIERS' THEN
252: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,50);
253: RETURN l_reg_comp_name||','||l_bank_acc_num||','||l_payment_date;

Line 252: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,50);

248:
249: pay_in_utils.set_location(g_debug,'In : '||l_procedure,40);
250:
251: IF p_identifier_name = 'CONCATENATED_IDENTIFIERS' THEN
252: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,50);
253: RETURN l_reg_comp_name||','||l_bank_acc_num||','||l_payment_date;
254: ELSIF p_identifier_name = 'PAYEE_BANK_ACCOUNT_NAME' THEN
255: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,60);
256: RETURN l_emp_acc_name ;

Line 255: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,60);

251: IF p_identifier_name = 'CONCATENATED_IDENTIFIERS' THEN
252: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,50);
253: RETURN l_reg_comp_name||','||l_bank_acc_num||','||l_payment_date;
254: ELSIF p_identifier_name = 'PAYEE_BANK_ACCOUNT_NAME' THEN
255: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,60);
256: RETURN l_emp_acc_name ;
257: ELSIF p_identifier_name = 'PAYEE_BANK_ACCOUNT_NUMBER' THEN
258: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,70);
259: RETURN l_emp_acc_num;

Line 258: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,70);

254: ELSIF p_identifier_name = 'PAYEE_BANK_ACCOUNT_NAME' THEN
255: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,60);
256: RETURN l_emp_acc_name ;
257: ELSIF p_identifier_name = 'PAYEE_BANK_ACCOUNT_NUMBER' THEN
258: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,70);
259: RETURN l_emp_acc_num;
260: ELSIF p_identifier_name = 'PAYEE_BANK_BRANCH' THEN
261: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,80);
262: RETURN l_emp_branch;

Line 261: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,80);

257: ELSIF p_identifier_name = 'PAYEE_BANK_ACCOUNT_NUMBER' THEN
258: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,70);
259: RETURN l_emp_acc_num;
260: ELSIF p_identifier_name = 'PAYEE_BANK_BRANCH' THEN
261: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,80);
262: RETURN l_emp_branch;
263: ELSIF p_identifier_name = 'PAYEE_BANK_NAME' THEN
264: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,90);
265: RETURN l_emp_bank;

Line 264: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,90);

260: ELSIF p_identifier_name = 'PAYEE_BANK_BRANCH' THEN
261: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,80);
262: RETURN l_emp_branch;
263: ELSIF p_identifier_name = 'PAYEE_BANK_NAME' THEN
264: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,90);
265: RETURN l_emp_bank;
266: ELSIF p_identifier_name = 'TRANSACTION_DATE' THEN
267: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,100);
268: RETURN TO_CHAR(TO_DATE(l_payment_date),'yyyy/mon/dd');

Line 267: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,100);

263: ELSIF p_identifier_name = 'PAYEE_BANK_NAME' THEN
264: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,90);
265: RETURN l_emp_bank;
266: ELSIF p_identifier_name = 'TRANSACTION_DATE' THEN
267: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,100);
268: RETURN TO_CHAR(TO_DATE(l_payment_date),'yyyy/mon/dd');
269: ELSIF p_identifier_name = 'TRANSACTION_GROUP' THEN
270: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,110);
271: RETURN p_payroll_action_id ;

Line 270: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,110);

266: ELSIF p_identifier_name = 'TRANSACTION_DATE' THEN
267: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,100);
268: RETURN TO_CHAR(TO_DATE(l_payment_date),'yyyy/mon/dd');
269: ELSIF p_identifier_name = 'TRANSACTION_GROUP' THEN
270: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,110);
271: RETURN p_payroll_action_id ;
272: END IF ;
273:
274:

Line 278: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR',

274:
275:
276: EXCEPTION
277: WHEN OTHERS THEN
278: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR',
279: 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
280: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 120);
281: RAISE ;
282: END batch_transaction_identifiers ;

Line 280: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 120);

276: EXCEPTION
277: WHEN OTHERS THEN
278: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR',
279: 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
280: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 120);
281: RAISE ;
282: END batch_transaction_identifiers ;
283:
284: END pay_in_trx_identifiers ;