APPS.PAY_IN_24QC_ER_RETURNS dependencies on PAY_IN_UTILS

Line 44: pay_in_utils.set_location(g_debug, 'Entering: ' || l_proc, 10);

40: BEGIN
41:
42: l_proc := g_package||'get_file_seq_no';
43: g_debug := hr_utility.debug_enabled;
44: pay_in_utils.set_location(g_debug, 'Entering: ' || l_proc, 10);
45:
46: IF g_debug THEN
47: pay_in_utils.trace('**************************************************','********************');
48: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);

Line 47: pay_in_utils.trace('**************************************************','********************');

43: g_debug := hr_utility.debug_enabled;
44: pay_in_utils.set_location(g_debug, 'Entering: ' || l_proc, 10);
45:
46: IF g_debug THEN
47: pay_in_utils.trace('**************************************************','********************');
48: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
49: pay_in_utils.trace('p_assess_year',p_assess_year);
50: pay_in_utils.trace('p_quarter',p_quarter);
51: pay_in_utils.trace('**************************************************','********************');

Line 48: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);

44: pay_in_utils.set_location(g_debug, 'Entering: ' || l_proc, 10);
45:
46: IF g_debug THEN
47: pay_in_utils.trace('**************************************************','********************');
48: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
49: pay_in_utils.trace('p_assess_year',p_assess_year);
50: pay_in_utils.trace('p_quarter',p_quarter);
51: pay_in_utils.trace('**************************************************','********************');
52: END IF;

Line 49: pay_in_utils.trace('p_assess_year',p_assess_year);

45:
46: IF g_debug THEN
47: pay_in_utils.trace('**************************************************','********************');
48: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
49: pay_in_utils.trace('p_assess_year',p_assess_year);
50: pay_in_utils.trace('p_quarter',p_quarter);
51: pay_in_utils.trace('**************************************************','********************');
52: END IF;
53:

Line 50: pay_in_utils.trace('p_quarter',p_quarter);

46: IF g_debug THEN
47: pay_in_utils.trace('**************************************************','********************');
48: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
49: pay_in_utils.trace('p_assess_year',p_assess_year);
50: pay_in_utils.trace('p_quarter',p_quarter);
51: pay_in_utils.trace('**************************************************','********************');
52: END IF;
53:
54: OPEN csr_file_seq_no(p_gre_org_id,p_assess_year,p_quarter);

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

47: pay_in_utils.trace('**************************************************','********************');
48: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
49: pay_in_utils.trace('p_assess_year',p_assess_year);
50: pay_in_utils.trace('p_quarter',p_quarter);
51: pay_in_utils.trace('**************************************************','********************');
52: END IF;
53:
54: OPEN csr_file_seq_no(p_gre_org_id,p_assess_year,p_quarter);
55: FETCH csr_file_seq_no INTO l_file_seq_no;

Line 59: pay_in_utils.trace('**************************************************','********************');

55: FETCH csr_file_seq_no INTO l_file_seq_no;
56: CLOSE csr_file_seq_no;
57:
58: IF g_debug THEN
59: pay_in_utils.trace('**************************************************','********************');
60: pay_in_utils.trace('l_file_seq_no',l_file_seq_no);
61: pay_in_utils.trace('**************************************************','********************');
62: END IF;
63:

Line 60: pay_in_utils.trace('l_file_seq_no',l_file_seq_no);

56: CLOSE csr_file_seq_no;
57:
58: IF g_debug THEN
59: pay_in_utils.trace('**************************************************','********************');
60: pay_in_utils.trace('l_file_seq_no',l_file_seq_no);
61: pay_in_utils.trace('**************************************************','********************');
62: END IF;
63:
64: pay_in_utils.set_location(g_debug, 'Leaving: ' || l_proc, 10);

Line 61: pay_in_utils.trace('**************************************************','********************');

57:
58: IF g_debug THEN
59: pay_in_utils.trace('**************************************************','********************');
60: pay_in_utils.trace('l_file_seq_no',l_file_seq_no);
61: pay_in_utils.trace('**************************************************','********************');
62: END IF;
63:
64: pay_in_utils.set_location(g_debug, 'Leaving: ' || l_proc, 10);
65:

Line 64: pay_in_utils.set_location(g_debug, 'Leaving: ' || l_proc, 10);

60: pay_in_utils.trace('l_file_seq_no',l_file_seq_no);
61: pay_in_utils.trace('**************************************************','********************');
62: END IF;
63:
64: pay_in_utils.set_location(g_debug, 'Leaving: ' || l_proc, 10);
65:
66: RETURN l_file_seq_no;
67:
68: EXCEPTION

Line 70: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_proc, 'SQLERRMC:'||sqlerrm);

66: RETURN l_file_seq_no;
67:
68: EXCEPTION
69: WHEN OTHERS THEN
70: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_proc, 'SQLERRMC:'||sqlerrm);
71: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 50);
72: pay_in_utils.trace(l_message,l_proc);
73:
74: END get_file_seq_no;

Line 71: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 50);

67:
68: EXCEPTION
69: WHEN OTHERS THEN
70: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_proc, 'SQLERRMC:'||sqlerrm);
71: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 50);
72: pay_in_utils.trace(l_message,l_proc);
73:
74: END get_file_seq_no;
75:

Line 72: pay_in_utils.trace(l_message,l_proc);

68: EXCEPTION
69: WHEN OTHERS THEN
70: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_proc, 'SQLERRMC:'||sqlerrm);
71: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 50);
72: pay_in_utils.trace(l_message,l_proc);
73:
74: END get_file_seq_no;
75:
76:

Line 116: pay_in_utils.set_location(g_debug, 'Entering: ' || l_proc, 10);

112: BEGIN
113:
114: l_proc := g_package||'challan_rec_count_24qc';
115: g_debug := hr_utility.debug_enabled;
116: pay_in_utils.set_location(g_debug, 'Entering: ' || l_proc, 10);
117: IF g_debug THEN
118: pay_in_utils.trace('**************************************************','********************');
119: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
120: pay_in_utils.trace('p_assess_period',p_assess_period);

Line 118: pay_in_utils.trace('**************************************************','********************');

114: l_proc := g_package||'challan_rec_count_24qc';
115: g_debug := hr_utility.debug_enabled;
116: pay_in_utils.set_location(g_debug, 'Entering: ' || l_proc, 10);
117: IF g_debug THEN
118: pay_in_utils.trace('**************************************************','********************');
119: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
120: pay_in_utils.trace('p_assess_period',p_assess_period);
121: pay_in_utils.trace('p_max_action_id',p_max_action_id);
122: pay_in_utils.trace('p_correction_type',p_correction_type);

Line 119: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);

115: g_debug := hr_utility.debug_enabled;
116: pay_in_utils.set_location(g_debug, 'Entering: ' || l_proc, 10);
117: IF g_debug THEN
118: pay_in_utils.trace('**************************************************','********************');
119: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
120: pay_in_utils.trace('p_assess_period',p_assess_period);
121: pay_in_utils.trace('p_max_action_id',p_max_action_id);
122: pay_in_utils.trace('p_correction_type',p_correction_type);
123: pay_in_utils.trace('**************************************************','********************');

Line 120: pay_in_utils.trace('p_assess_period',p_assess_period);

116: pay_in_utils.set_location(g_debug, 'Entering: ' || l_proc, 10);
117: IF g_debug THEN
118: pay_in_utils.trace('**************************************************','********************');
119: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
120: pay_in_utils.trace('p_assess_period',p_assess_period);
121: pay_in_utils.trace('p_max_action_id',p_max_action_id);
122: pay_in_utils.trace('p_correction_type',p_correction_type);
123: pay_in_utils.trace('**************************************************','********************');
124: END IF;

Line 121: pay_in_utils.trace('p_max_action_id',p_max_action_id);

117: IF g_debug THEN
118: pay_in_utils.trace('**************************************************','********************');
119: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
120: pay_in_utils.trace('p_assess_period',p_assess_period);
121: pay_in_utils.trace('p_max_action_id',p_max_action_id);
122: pay_in_utils.trace('p_correction_type',p_correction_type);
123: pay_in_utils.trace('**************************************************','********************');
124: END IF;
125:

Line 122: pay_in_utils.trace('p_correction_type',p_correction_type);

118: pay_in_utils.trace('**************************************************','********************');
119: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
120: pay_in_utils.trace('p_assess_period',p_assess_period);
121: pay_in_utils.trace('p_max_action_id',p_max_action_id);
122: pay_in_utils.trace('p_correction_type',p_correction_type);
123: pay_in_utils.trace('**************************************************','********************');
124: END IF;
125:
126: OPEN c_count;

Line 123: pay_in_utils.trace('**************************************************','********************');

119: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
120: pay_in_utils.trace('p_assess_period',p_assess_period);
121: pay_in_utils.trace('p_max_action_id',p_max_action_id);
122: pay_in_utils.trace('p_correction_type',p_correction_type);
123: pay_in_utils.trace('**************************************************','********************');
124: END IF;
125:
126: OPEN c_count;
127: FETCH c_count INTO l_count;

Line 135: pay_in_utils.trace('**************************************************','********************');

131: END IF;
132: CLOSE c_count;
133:
134: IF g_debug THEN
135: pay_in_utils.trace('**************************************************','********************');
136: pay_in_utils.trace('l_count',l_count);
137: pay_in_utils.trace('**************************************************','********************');
138: END IF;
139:

Line 136: pay_in_utils.trace('l_count',l_count);

132: CLOSE c_count;
133:
134: IF g_debug THEN
135: pay_in_utils.trace('**************************************************','********************');
136: pay_in_utils.trace('l_count',l_count);
137: pay_in_utils.trace('**************************************************','********************');
138: END IF;
139:
140: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 30);

Line 137: pay_in_utils.trace('**************************************************','********************');

133:
134: IF g_debug THEN
135: pay_in_utils.trace('**************************************************','********************');
136: pay_in_utils.trace('l_count',l_count);
137: pay_in_utils.trace('**************************************************','********************');
138: END IF;
139:
140: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 30);
141:

Line 140: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 30);

136: pay_in_utils.trace('l_count',l_count);
137: pay_in_utils.trace('**************************************************','********************');
138: END IF;
139:
140: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 30);
141:
142: RETURN TO_CHAR(l_count);
143:
144: EXCEPTION

Line 146: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_proc, 'SQLERRMC:'||sqlerrm);

142: RETURN TO_CHAR(l_count);
143:
144: EXCEPTION
145: WHEN OTHERS THEN
146: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_proc, 'SQLERRMC:'||sqlerrm);
147: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 50);
148: pay_in_utils.trace(l_message,l_proc);
149:
150: END challan_rec_count_24qc;

Line 147: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 50);

143:
144: EXCEPTION
145: WHEN OTHERS THEN
146: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_proc, 'SQLERRMC:'||sqlerrm);
147: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 50);
148: pay_in_utils.trace(l_message,l_proc);
149:
150: END challan_rec_count_24qc;
151:

Line 148: pay_in_utils.trace(l_message,l_proc);

144: EXCEPTION
145: WHEN OTHERS THEN
146: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_proc, 'SQLERRMC:'||sqlerrm);
147: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 50);
148: pay_in_utils.trace(l_message,l_proc);
149:
150: END challan_rec_count_24qc;
151:
152: --------------------------------------------------------------------------

Line 208: pay_in_utils.set_location(g_debug, 'Entering: ' || l_proc, 10);

204: BEGIN
205:
206: l_proc := g_package||'get_rrr_no';
207: g_debug := hr_utility.debug_enabled;
208: pay_in_utils.set_location(g_debug, 'Entering: ' || l_proc, 10);
209:
210: IF g_debug THEN
211: pay_in_utils.trace('**************************************************','********************');
212: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);

Line 211: pay_in_utils.trace('**************************************************','********************');

207: g_debug := hr_utility.debug_enabled;
208: pay_in_utils.set_location(g_debug, 'Entering: ' || l_proc, 10);
209:
210: IF g_debug THEN
211: pay_in_utils.trace('**************************************************','********************');
212: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
213: pay_in_utils.trace('p_assess_year',p_assess_year);
214: pay_in_utils.trace('p_quarter',p_quarter);
215: pay_in_utils.trace('**************************************************','********************');

Line 212: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);

208: pay_in_utils.set_location(g_debug, 'Entering: ' || l_proc, 10);
209:
210: IF g_debug THEN
211: pay_in_utils.trace('**************************************************','********************');
212: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
213: pay_in_utils.trace('p_assess_year',p_assess_year);
214: pay_in_utils.trace('p_quarter',p_quarter);
215: pay_in_utils.trace('**************************************************','********************');
216: END IF;

Line 213: pay_in_utils.trace('p_assess_year',p_assess_year);

209:
210: IF g_debug THEN
211: pay_in_utils.trace('**************************************************','********************');
212: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
213: pay_in_utils.trace('p_assess_year',p_assess_year);
214: pay_in_utils.trace('p_quarter',p_quarter);
215: pay_in_utils.trace('**************************************************','********************');
216: END IF;
217:

Line 214: pay_in_utils.trace('p_quarter',p_quarter);

210: IF g_debug THEN
211: pay_in_utils.trace('**************************************************','********************');
212: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
213: pay_in_utils.trace('p_assess_year',p_assess_year);
214: pay_in_utils.trace('p_quarter',p_quarter);
215: pay_in_utils.trace('**************************************************','********************');
216: END IF;
217:
218: IF p_receipt = 'Original' THEN

Line 215: pay_in_utils.trace('**************************************************','********************');

211: pay_in_utils.trace('**************************************************','********************');
212: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
213: pay_in_utils.trace('p_assess_year',p_assess_year);
214: pay_in_utils.trace('p_quarter',p_quarter);
215: pay_in_utils.trace('**************************************************','********************');
216: END IF;
217:
218: IF p_receipt = 'Original' THEN
219: OPEN csr_orig_rrr_no(p_gre_org_id,p_assess_year,p_quarter);

Line 230: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 30);

226: FETCH csr_prev_rrr_no INTO l_rrr_no, l_dummy;
227: CLOSE csr_prev_rrr_no;
228: END IF;
229:
230: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 30);
231:
232: IF g_debug THEN
233: pay_in_utils.trace('**************************************************','********************');
234: pay_in_utils.trace('l_rrr_no',l_rrr_no);

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

229:
230: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 30);
231:
232: IF g_debug THEN
233: pay_in_utils.trace('**************************************************','********************');
234: pay_in_utils.trace('l_rrr_no',l_rrr_no);
235: pay_in_utils.trace('**************************************************','********************');
236: END IF;
237: RETURN NVL(l_rrr_no,'Not Found');

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

230: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 30);
231:
232: IF g_debug THEN
233: pay_in_utils.trace('**************************************************','********************');
234: pay_in_utils.trace('l_rrr_no',l_rrr_no);
235: pay_in_utils.trace('**************************************************','********************');
236: END IF;
237: RETURN NVL(l_rrr_no,'Not Found');
238:

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

231:
232: IF g_debug THEN
233: pay_in_utils.trace('**************************************************','********************');
234: pay_in_utils.trace('l_rrr_no',l_rrr_no);
235: pay_in_utils.trace('**************************************************','********************');
236: END IF;
237: RETURN NVL(l_rrr_no,'Not Found');
238:
239: EXCEPTION

Line 241: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_proc, 'SQLERRMC:'||sqlerrm);

237: RETURN NVL(l_rrr_no,'Not Found');
238:
239: EXCEPTION
240: WHEN OTHERS THEN
241: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_proc, 'SQLERRMC:'||sqlerrm);
242: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 50);
243: pay_in_utils.trace(l_message,l_proc);
244:
245: END get_rrr_no;

Line 242: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 50);

238:
239: EXCEPTION
240: WHEN OTHERS THEN
241: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_proc, 'SQLERRMC:'||sqlerrm);
242: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 50);
243: pay_in_utils.trace(l_message,l_proc);
244:
245: END get_rrr_no;
246:

Line 243: pay_in_utils.trace(l_message,l_proc);

239: EXCEPTION
240: WHEN OTHERS THEN
241: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_proc, 'SQLERRMC:'||sqlerrm);
242: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 50);
243: pay_in_utils.trace(l_message,l_proc);
244:
245: END get_rrr_no;
246:
247: --------------------------------------------------------------------------

Line 302: pay_in_utils.set_location(g_debug, 'Entering: ' || l_proc, 10);

298: BEGIN
299:
300: l_proc := g_package||'gross_tot_tds_challan_24q';
301: g_debug := hr_utility.debug_enabled;
302: pay_in_utils.set_location(g_debug, 'Entering: ' || l_proc, 10);
303:
304: IF g_debug THEN
305: pay_in_utils.trace('**************************************************','********************');
306: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);

Line 305: pay_in_utils.trace('**************************************************','********************');

301: g_debug := hr_utility.debug_enabled;
302: pay_in_utils.set_location(g_debug, 'Entering: ' || l_proc, 10);
303:
304: IF g_debug THEN
305: pay_in_utils.trace('**************************************************','********************');
306: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
307: pay_in_utils.trace('p_assess_period',p_assess_period);
308: pay_in_utils.trace('p_max_action_id',p_max_action_id);
309: pay_in_utils.trace('p_correction_type',p_correction_type);

Line 306: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);

302: pay_in_utils.set_location(g_debug, 'Entering: ' || l_proc, 10);
303:
304: IF g_debug THEN
305: pay_in_utils.trace('**************************************************','********************');
306: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
307: pay_in_utils.trace('p_assess_period',p_assess_period);
308: pay_in_utils.trace('p_max_action_id',p_max_action_id);
309: pay_in_utils.trace('p_correction_type',p_correction_type);
310: pay_in_utils.trace('**************************************************','********************');

Line 307: pay_in_utils.trace('p_assess_period',p_assess_period);

303:
304: IF g_debug THEN
305: pay_in_utils.trace('**************************************************','********************');
306: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
307: pay_in_utils.trace('p_assess_period',p_assess_period);
308: pay_in_utils.trace('p_max_action_id',p_max_action_id);
309: pay_in_utils.trace('p_correction_type',p_correction_type);
310: pay_in_utils.trace('**************************************************','********************');
311: END IF;

Line 308: pay_in_utils.trace('p_max_action_id',p_max_action_id);

304: IF g_debug THEN
305: pay_in_utils.trace('**************************************************','********************');
306: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
307: pay_in_utils.trace('p_assess_period',p_assess_period);
308: pay_in_utils.trace('p_max_action_id',p_max_action_id);
309: pay_in_utils.trace('p_correction_type',p_correction_type);
310: pay_in_utils.trace('**************************************************','********************');
311: END IF;
312:

Line 309: pay_in_utils.trace('p_correction_type',p_correction_type);

305: pay_in_utils.trace('**************************************************','********************');
306: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
307: pay_in_utils.trace('p_assess_period',p_assess_period);
308: pay_in_utils.trace('p_max_action_id',p_max_action_id);
309: pay_in_utils.trace('p_correction_type',p_correction_type);
310: pay_in_utils.trace('**************************************************','********************');
311: END IF;
312:
313: OPEN c_challan_tax_tot;

Line 310: pay_in_utils.trace('**************************************************','********************');

306: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
307: pay_in_utils.trace('p_assess_period',p_assess_period);
308: pay_in_utils.trace('p_max_action_id',p_max_action_id);
309: pay_in_utils.trace('p_correction_type',p_correction_type);
310: pay_in_utils.trace('**************************************************','********************');
311: END IF;
312:
313: OPEN c_challan_tax_tot;
314: FETCH c_challan_tax_tot INTO l_tds, l_sur, l_ec, l_intr, l_oth;

Line 320: pay_in_utils.trace('**************************************************','********************');

316:
317: l_total := TO_CHAR(NVL(ROUND((l_tds + l_sur + l_ec + l_intr + l_oth), 0), 0))||'.00';
318:
319: IF g_debug THEN
320: pay_in_utils.trace('**************************************************','********************');
321: pay_in_utils.trace('l_total',l_total);
322: pay_in_utils.trace('**************************************************','********************');
323: END IF;
324:

Line 321: pay_in_utils.trace('l_total',l_total);

317: l_total := TO_CHAR(NVL(ROUND((l_tds + l_sur + l_ec + l_intr + l_oth), 0), 0))||'.00';
318:
319: IF g_debug THEN
320: pay_in_utils.trace('**************************************************','********************');
321: pay_in_utils.trace('l_total',l_total);
322: pay_in_utils.trace('**************************************************','********************');
323: END IF;
324:
325: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 30);

Line 322: pay_in_utils.trace('**************************************************','********************');

318:
319: IF g_debug THEN
320: pay_in_utils.trace('**************************************************','********************');
321: pay_in_utils.trace('l_total',l_total);
322: pay_in_utils.trace('**************************************************','********************');
323: END IF;
324:
325: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 30);
326:

Line 325: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 30);

321: pay_in_utils.trace('l_total',l_total);
322: pay_in_utils.trace('**************************************************','********************');
323: END IF;
324:
325: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 30);
326:
327: RETURN SUBSTR(l_total,1,15);
328:
329: EXCEPTION

Line 331: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_proc, 'SQLERRMC:'||sqlerrm);

327: RETURN SUBSTR(l_total,1,15);
328:
329: EXCEPTION
330: WHEN OTHERS THEN
331: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_proc, 'SQLERRMC:'||sqlerrm);
332: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 50);
333: pay_in_utils.trace(l_message,l_proc);
334:
335: END gross_tot_tds_challan_24q;

Line 332: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 50);

328:
329: EXCEPTION
330: WHEN OTHERS THEN
331: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_proc, 'SQLERRMC:'||sqlerrm);
332: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 50);
333: pay_in_utils.trace(l_message,l_proc);
334:
335: END gross_tot_tds_challan_24q;
336:

Line 333: pay_in_utils.trace(l_message,l_proc);

329: EXCEPTION
330: WHEN OTHERS THEN
331: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_proc, 'SQLERRMC:'||sqlerrm);
332: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 50);
333: pay_in_utils.trace(l_message,l_proc);
334:
335: END gross_tot_tds_challan_24q;
336:
337:

Line 373: pay_in_utils.set_location(g_debug, 'Entering: ' || l_proc, 10);

369: BEGIN
370:
371: l_proc := g_package||'get_prev_nil_challan_ind';
372: g_debug := hr_utility.debug_enabled;
373: pay_in_utils.set_location(g_debug, 'Entering: ' || l_proc, 10);
374:
375: IF g_debug THEN
376: pay_in_utils.trace('**************************************************','********************');
377: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);

Line 376: pay_in_utils.trace('**************************************************','********************');

372: g_debug := hr_utility.debug_enabled;
373: pay_in_utils.set_location(g_debug, 'Entering: ' || l_proc, 10);
374:
375: IF g_debug THEN
376: pay_in_utils.trace('**************************************************','********************');
377: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
378: pay_in_utils.trace('p_assess_period',p_assess_period);
379: pay_in_utils.trace('p_max_action_id',p_max_action_id);
380: pay_in_utils.trace('**************************************************','********************');

Line 377: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);

373: pay_in_utils.set_location(g_debug, 'Entering: ' || l_proc, 10);
374:
375: IF g_debug THEN
376: pay_in_utils.trace('**************************************************','********************');
377: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
378: pay_in_utils.trace('p_assess_period',p_assess_period);
379: pay_in_utils.trace('p_max_action_id',p_max_action_id);
380: pay_in_utils.trace('**************************************************','********************');
381: END IF;

Line 378: pay_in_utils.trace('p_assess_period',p_assess_period);

374:
375: IF g_debug THEN
376: pay_in_utils.trace('**************************************************','********************');
377: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
378: pay_in_utils.trace('p_assess_period',p_assess_period);
379: pay_in_utils.trace('p_max_action_id',p_max_action_id);
380: pay_in_utils.trace('**************************************************','********************');
381: END IF;
382:

Line 379: pay_in_utils.trace('p_max_action_id',p_max_action_id);

375: IF g_debug THEN
376: pay_in_utils.trace('**************************************************','********************');
377: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
378: pay_in_utils.trace('p_assess_period',p_assess_period);
379: pay_in_utils.trace('p_max_action_id',p_max_action_id);
380: pay_in_utils.trace('**************************************************','********************');
381: END IF;
382:
383: OPEN c_nil_challan;

Line 380: pay_in_utils.trace('**************************************************','********************');

376: pay_in_utils.trace('**************************************************','********************');
377: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
378: pay_in_utils.trace('p_assess_period',p_assess_period);
379: pay_in_utils.trace('p_max_action_id',p_max_action_id);
380: pay_in_utils.trace('**************************************************','********************');
381: END IF;
382:
383: OPEN c_nil_challan;
384: FETCH c_nil_challan INTO l_nil_challan_ind;

Line 388: pay_in_utils.trace('**************************************************','********************');

384: FETCH c_nil_challan INTO l_nil_challan_ind;
385: CLOSE c_nil_challan;
386:
387: IF g_debug THEN
388: pay_in_utils.trace('**************************************************','********************');
389: pay_in_utils.trace('l_nil_challan_ind',l_nil_challan_ind);
390: pay_in_utils.trace('**************************************************','********************');
391: END IF;
392:

Line 389: pay_in_utils.trace('l_nil_challan_ind',l_nil_challan_ind);

385: CLOSE c_nil_challan;
386:
387: IF g_debug THEN
388: pay_in_utils.trace('**************************************************','********************');
389: pay_in_utils.trace('l_nil_challan_ind',l_nil_challan_ind);
390: pay_in_utils.trace('**************************************************','********************');
391: END IF;
392:
393: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 30);

Line 390: pay_in_utils.trace('**************************************************','********************');

386:
387: IF g_debug THEN
388: pay_in_utils.trace('**************************************************','********************');
389: pay_in_utils.trace('l_nil_challan_ind',l_nil_challan_ind);
390: pay_in_utils.trace('**************************************************','********************');
391: END IF;
392:
393: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 30);
394:

Line 393: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 30);

389: pay_in_utils.trace('l_nil_challan_ind',l_nil_challan_ind);
390: pay_in_utils.trace('**************************************************','********************');
391: END IF;
392:
393: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 30);
394:
395: RETURN l_nil_challan_ind;
396:
397: EXCEPTION

Line 399: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_proc, 'SQLERRMC:'||sqlerrm);

395: RETURN l_nil_challan_ind;
396:
397: EXCEPTION
398: WHEN OTHERS THEN
399: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_proc, 'SQLERRMC:'||sqlerrm);
400: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 50);
401: pay_in_utils.trace(l_message,l_proc);
402:
403: END get_prev_nil_challan_ind;

Line 400: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 50);

396:
397: EXCEPTION
398: WHEN OTHERS THEN
399: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_proc, 'SQLERRMC:'||sqlerrm);
400: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 50);
401: pay_in_utils.trace(l_message,l_proc);
402:
403: END get_prev_nil_challan_ind;
404:

Line 401: pay_in_utils.trace(l_message,l_proc);

397: EXCEPTION
398: WHEN OTHERS THEN
399: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_proc, 'SQLERRMC:'||sqlerrm);
400: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 50);
401: pay_in_utils.trace(l_message,l_proc);
402:
403: END get_prev_nil_challan_ind;
404:
405: --------------------------------------------------------------------------

Line 443: pay_in_utils.set_location(g_debug, 'Entering: ' || l_proc, 10);

439: BEGIN
440:
441: l_proc := g_package||'deductee_rec_count_24q';
442: g_debug := hr_utility.debug_enabled;
443: pay_in_utils.set_location(g_debug, 'Entering: ' || l_proc, 10);
444:
445: IF g_debug THEN
446: pay_in_utils.trace('**************************************************','********************');
447: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);

Line 446: pay_in_utils.trace('**************************************************','********************');

442: g_debug := hr_utility.debug_enabled;
443: pay_in_utils.set_location(g_debug, 'Entering: ' || l_proc, 10);
444:
445: IF g_debug THEN
446: pay_in_utils.trace('**************************************************','********************');
447: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
448: pay_in_utils.trace('p_max_action_id',p_max_action_id);
449: pay_in_utils.trace('p_challan',p_challan);
450: pay_in_utils.trace('**************************************************','********************');

Line 447: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);

443: pay_in_utils.set_location(g_debug, 'Entering: ' || l_proc, 10);
444:
445: IF g_debug THEN
446: pay_in_utils.trace('**************************************************','********************');
447: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
448: pay_in_utils.trace('p_max_action_id',p_max_action_id);
449: pay_in_utils.trace('p_challan',p_challan);
450: pay_in_utils.trace('**************************************************','********************');
451: END IF;

Line 448: pay_in_utils.trace('p_max_action_id',p_max_action_id);

444:
445: IF g_debug THEN
446: pay_in_utils.trace('**************************************************','********************');
447: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
448: pay_in_utils.trace('p_max_action_id',p_max_action_id);
449: pay_in_utils.trace('p_challan',p_challan);
450: pay_in_utils.trace('**************************************************','********************');
451: END IF;
452:

Line 449: pay_in_utils.trace('p_challan',p_challan);

445: IF g_debug THEN
446: pay_in_utils.trace('**************************************************','********************');
447: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
448: pay_in_utils.trace('p_max_action_id',p_max_action_id);
449: pay_in_utils.trace('p_challan',p_challan);
450: pay_in_utils.trace('**************************************************','********************');
451: END IF;
452:
453: OPEN c_count;

Line 450: pay_in_utils.trace('**************************************************','********************');

446: pay_in_utils.trace('**************************************************','********************');
447: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
448: pay_in_utils.trace('p_max_action_id',p_max_action_id);
449: pay_in_utils.trace('p_challan',p_challan);
450: pay_in_utils.trace('**************************************************','********************');
451: END IF;
452:
453: OPEN c_count;
454: FETCH c_count INTO l_count;

Line 462: pay_in_utils.trace('**************************************************','********************');

458: END IF;
459: CLOSE c_count;
460:
461: IF g_debug THEN
462: pay_in_utils.trace('**************************************************','********************');
463: pay_in_utils.trace('l_count',l_count);
464: pay_in_utils.trace('**************************************************','********************');
465: END IF;
466:

Line 463: pay_in_utils.trace('l_count',l_count);

459: CLOSE c_count;
460:
461: IF g_debug THEN
462: pay_in_utils.trace('**************************************************','********************');
463: pay_in_utils.trace('l_count',l_count);
464: pay_in_utils.trace('**************************************************','********************');
465: END IF;
466:
467: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 30);

Line 464: pay_in_utils.trace('**************************************************','********************');

460:
461: IF g_debug THEN
462: pay_in_utils.trace('**************************************************','********************');
463: pay_in_utils.trace('l_count',l_count);
464: pay_in_utils.trace('**************************************************','********************');
465: END IF;
466:
467: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 30);
468:

Line 467: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 30);

463: pay_in_utils.trace('l_count',l_count);
464: pay_in_utils.trace('**************************************************','********************');
465: END IF;
466:
467: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 30);
468:
469: RETURN TO_CHAR(l_count);
470:
471: EXCEPTION

Line 473: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_proc, 'SQLERRMC:'||sqlerrm);

469: RETURN TO_CHAR(l_count);
470:
471: EXCEPTION
472: WHEN OTHERS THEN
473: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_proc, 'SQLERRMC:'||sqlerrm);
474: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 50);
475: pay_in_utils.trace(l_message,l_proc);
476:
477: END deductee_rec_count_24q;

Line 474: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 50);

470:
471: EXCEPTION
472: WHEN OTHERS THEN
473: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_proc, 'SQLERRMC:'||sqlerrm);
474: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 50);
475: pay_in_utils.trace(l_message,l_proc);
476:
477: END deductee_rec_count_24q;
478:

Line 475: pay_in_utils.trace(l_message,l_proc);

471: EXCEPTION
472: WHEN OTHERS THEN
473: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_proc, 'SQLERRMC:'||sqlerrm);
474: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 50);
475: pay_in_utils.trace(l_message,l_proc);
476:
477: END deductee_rec_count_24q;
478:
479: --------------------------------------------------------------------------

Line 549: pay_in_utils.set_location(g_debug, 'Entering: ' || l_proc, 10);

545: BEGIN
546:
547: l_proc := g_package||'get_24qc_tax_values';
548: g_debug := hr_utility.debug_enabled;
549: pay_in_utils.set_location(g_debug, 'Entering: ' || l_proc, 10);
550:
551: IF g_debug THEN
552: pay_in_utils.trace('**************************************************','********************');
553: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);

Line 552: pay_in_utils.trace('**************************************************','********************');

548: g_debug := hr_utility.debug_enabled;
549: pay_in_utils.set_location(g_debug, 'Entering: ' || l_proc, 10);
550:
551: IF g_debug THEN
552: pay_in_utils.trace('**************************************************','********************');
553: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
554: pay_in_utils.trace('p_max_action_id',p_max_action_id);
555: pay_in_utils.trace('p_challan',p_challan_number);
556: pay_in_utils.trace('**************************************************','********************');

Line 553: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);

549: pay_in_utils.set_location(g_debug, 'Entering: ' || l_proc, 10);
550:
551: IF g_debug THEN
552: pay_in_utils.trace('**************************************************','********************');
553: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
554: pay_in_utils.trace('p_max_action_id',p_max_action_id);
555: pay_in_utils.trace('p_challan',p_challan_number);
556: pay_in_utils.trace('**************************************************','********************');
557: END IF;

Line 554: pay_in_utils.trace('p_max_action_id',p_max_action_id);

550:
551: IF g_debug THEN
552: pay_in_utils.trace('**************************************************','********************');
553: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
554: pay_in_utils.trace('p_max_action_id',p_max_action_id);
555: pay_in_utils.trace('p_challan',p_challan_number);
556: pay_in_utils.trace('**************************************************','********************');
557: END IF;
558:

Line 555: pay_in_utils.trace('p_challan',p_challan_number);

551: IF g_debug THEN
552: pay_in_utils.trace('**************************************************','********************');
553: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
554: pay_in_utils.trace('p_max_action_id',p_max_action_id);
555: pay_in_utils.trace('p_challan',p_challan_number);
556: pay_in_utils.trace('**************************************************','********************');
557: END IF;
558:
559: l_value29 := 0;

Line 556: pay_in_utils.trace('**************************************************','********************');

552: pay_in_utils.trace('**************************************************','********************');
553: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
554: pay_in_utils.trace('p_max_action_id',p_max_action_id);
555: pay_in_utils.trace('p_challan',p_challan_number);
556: pay_in_utils.trace('**************************************************','********************');
557: END IF;
558:
559: l_value29 := 0;
560: l_value30 := 0;

Line 580: pay_in_utils.trace('**************************************************','********************');

576:
577: l_total_tax_values := l_value29||'^'||l_value30||'^'||l_value31||'^'||l_value32||'^'||l_value33||'^';
578:
579: IF g_debug THEN
580: pay_in_utils.trace('**************************************************','********************');
581: pay_in_utils.trace('l_total_tax_values',l_total_tax_values);
582: pay_in_utils.trace('**************************************************','********************');
583: END IF;
584:

Line 581: pay_in_utils.trace('l_total_tax_values',l_total_tax_values);

577: l_total_tax_values := l_value29||'^'||l_value30||'^'||l_value31||'^'||l_value32||'^'||l_value33||'^';
578:
579: IF g_debug THEN
580: pay_in_utils.trace('**************************************************','********************');
581: pay_in_utils.trace('l_total_tax_values',l_total_tax_values);
582: pay_in_utils.trace('**************************************************','********************');
583: END IF;
584:
585: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 30);

Line 582: pay_in_utils.trace('**************************************************','********************');

578:
579: IF g_debug THEN
580: pay_in_utils.trace('**************************************************','********************');
581: pay_in_utils.trace('l_total_tax_values',l_total_tax_values);
582: pay_in_utils.trace('**************************************************','********************');
583: END IF;
584:
585: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 30);
586:

Line 585: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 30);

581: pay_in_utils.trace('l_total_tax_values',l_total_tax_values);
582: pay_in_utils.trace('**************************************************','********************');
583: END IF;
584:
585: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 30);
586:
587: RETURN l_total_tax_values;
588:
589: EXCEPTION

Line 591: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_proc, 'SQLERRMC:'||sqlerrm);

587: RETURN l_total_tax_values;
588:
589: EXCEPTION
590: WHEN OTHERS THEN
591: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_proc, 'SQLERRMC:'||sqlerrm);
592: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 50);
593: pay_in_utils.trace(l_message,l_proc);
594:
595: END get_24qc_tax_values;

Line 592: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 50);

588:
589: EXCEPTION
590: WHEN OTHERS THEN
591: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_proc, 'SQLERRMC:'||sqlerrm);
592: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 50);
593: pay_in_utils.trace(l_message,l_proc);
594:
595: END get_24qc_tax_values;
596:

Line 593: pay_in_utils.trace(l_message,l_proc);

589: EXCEPTION
590: WHEN OTHERS THEN
591: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_proc, 'SQLERRMC:'||sqlerrm);
592: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 50);
593: pay_in_utils.trace(l_message,l_proc);
594:
595: END get_24qc_tax_values;
596:
597: --------------------------------------------------------------------------

Line 629: pay_in_utils.set_location(g_debug, 'Entering: ' || l_proc, 10);

625: BEGIN
626:
627: l_proc := g_package||'get_archive_pay_action';
628: g_debug := hr_utility.debug_enabled;
629: pay_in_utils.set_location(g_debug, 'Entering: ' || l_proc, 10);
630:
631: IF g_debug THEN
632: pay_in_utils.trace('**************************************************','********************');
633: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);

Line 632: pay_in_utils.trace('**************************************************','********************');

628: g_debug := hr_utility.debug_enabled;
629: pay_in_utils.set_location(g_debug, 'Entering: ' || l_proc, 10);
630:
631: IF g_debug THEN
632: pay_in_utils.trace('**************************************************','********************');
633: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
634: pay_in_utils.trace('p_period',p_period);
635: pay_in_utils.trace('**************************************************','********************');
636: END IF;

Line 633: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);

629: pay_in_utils.set_location(g_debug, 'Entering: ' || l_proc, 10);
630:
631: IF g_debug THEN
632: pay_in_utils.trace('**************************************************','********************');
633: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
634: pay_in_utils.trace('p_period',p_period);
635: pay_in_utils.trace('**************************************************','********************');
636: END IF;
637:

Line 634: pay_in_utils.trace('p_period',p_period);

630:
631: IF g_debug THEN
632: pay_in_utils.trace('**************************************************','********************');
633: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
634: pay_in_utils.trace('p_period',p_period);
635: pay_in_utils.trace('**************************************************','********************');
636: END IF;
637:
638: OPEN csr_arch_action_id;

Line 635: pay_in_utils.trace('**************************************************','********************');

631: IF g_debug THEN
632: pay_in_utils.trace('**************************************************','********************');
633: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
634: pay_in_utils.trace('p_period',p_period);
635: pay_in_utils.trace('**************************************************','********************');
636: END IF;
637:
638: OPEN csr_arch_action_id;
639: FETCH csr_arch_action_id INTO l_arch_action_id;

Line 647: pay_in_utils.trace('**************************************************','********************');

643: END IF;
644: CLOSE csr_arch_action_id;
645:
646: IF g_debug THEN
647: pay_in_utils.trace('**************************************************','********************');
648: pay_in_utils.trace('l_arch_action_id',l_arch_action_id);
649: pay_in_utils.trace('**************************************************','********************');
650: END IF;
651:

Line 648: pay_in_utils.trace('l_arch_action_id',l_arch_action_id);

644: CLOSE csr_arch_action_id;
645:
646: IF g_debug THEN
647: pay_in_utils.trace('**************************************************','********************');
648: pay_in_utils.trace('l_arch_action_id',l_arch_action_id);
649: pay_in_utils.trace('**************************************************','********************');
650: END IF;
651:
652: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 30);

Line 649: pay_in_utils.trace('**************************************************','********************');

645:
646: IF g_debug THEN
647: pay_in_utils.trace('**************************************************','********************');
648: pay_in_utils.trace('l_arch_action_id',l_arch_action_id);
649: pay_in_utils.trace('**************************************************','********************');
650: END IF;
651:
652: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 30);
653:

Line 652: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 30);

648: pay_in_utils.trace('l_arch_action_id',l_arch_action_id);
649: pay_in_utils.trace('**************************************************','********************');
650: END IF;
651:
652: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 30);
653:
654: RETURN l_arch_action_id;
655:
656: EXCEPTION

Line 658: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_proc, 'SQLERRMC:'||sqlerrm);

654: RETURN l_arch_action_id;
655:
656: EXCEPTION
657: WHEN OTHERS THEN
658: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_proc, 'SQLERRMC:'||sqlerrm);
659: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 50);
660: pay_in_utils.trace(l_message,l_proc);
661:
662: END get_archive_pay_action;

Line 659: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 50);

655:
656: EXCEPTION
657: WHEN OTHERS THEN
658: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_proc, 'SQLERRMC:'||sqlerrm);
659: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 50);
660: pay_in_utils.trace(l_message,l_proc);
661:
662: END get_archive_pay_action;
663:

Line 660: pay_in_utils.trace(l_message,l_proc);

656: EXCEPTION
657: WHEN OTHERS THEN
658: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_proc, 'SQLERRMC:'||sqlerrm);
659: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 50);
660: pay_in_utils.trace(l_message,l_proc);
661:
662: END get_archive_pay_action;
663:
664:

Line 685: pay_in_utils.set_location(g_debug, 'Entering: ' || l_proc, 10);

681: BEGIN
682:
683: l_proc := g_package||'remove_curr_format';
684: g_debug := hr_utility.debug_enabled;
685: pay_in_utils.set_location(g_debug, 'Entering: ' || l_proc, 10);
686:
687: IF g_debug THEN
688: pay_in_utils.trace('**************************************************','********************');
689: pay_in_utils.trace('p_value',p_value);

Line 688: pay_in_utils.trace('**************************************************','********************');

684: g_debug := hr_utility.debug_enabled;
685: pay_in_utils.set_location(g_debug, 'Entering: ' || l_proc, 10);
686:
687: IF g_debug THEN
688: pay_in_utils.trace('**************************************************','********************');
689: pay_in_utils.trace('p_value',p_value);
690: pay_in_utils.trace('**************************************************','********************');
691: END IF;
692:

Line 689: pay_in_utils.trace('p_value',p_value);

685: pay_in_utils.set_location(g_debug, 'Entering: ' || l_proc, 10);
686:
687: IF g_debug THEN
688: pay_in_utils.trace('**************************************************','********************');
689: pay_in_utils.trace('p_value',p_value);
690: pay_in_utils.trace('**************************************************','********************');
691: END IF;
692:
693: l_return_value := REPLACE(REPLACE(NVL(p_value,'0'), ',', ''), '+', '');

Line 690: pay_in_utils.trace('**************************************************','********************');

686:
687: IF g_debug THEN
688: pay_in_utils.trace('**************************************************','********************');
689: pay_in_utils.trace('p_value',p_value);
690: pay_in_utils.trace('**************************************************','********************');
691: END IF;
692:
693: l_return_value := REPLACE(REPLACE(NVL(p_value,'0'), ',', ''), '+', '');
694:

Line 696: pay_in_utils.trace('**************************************************','********************');

692:
693: l_return_value := REPLACE(REPLACE(NVL(p_value,'0'), ',', ''), '+', '');
694:
695: IF g_debug THEN
696: pay_in_utils.trace('**************************************************','********************');
697: pay_in_utils.trace('l_return_value',l_return_value);
698: pay_in_utils.trace('**************************************************','********************');
699: END IF;
700:

Line 697: pay_in_utils.trace('l_return_value',l_return_value);

693: l_return_value := REPLACE(REPLACE(NVL(p_value,'0'), ',', ''), '+', '');
694:
695: IF g_debug THEN
696: pay_in_utils.trace('**************************************************','********************');
697: pay_in_utils.trace('l_return_value',l_return_value);
698: pay_in_utils.trace('**************************************************','********************');
699: END IF;
700:
701: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 30);

Line 698: pay_in_utils.trace('**************************************************','********************');

694:
695: IF g_debug THEN
696: pay_in_utils.trace('**************************************************','********************');
697: pay_in_utils.trace('l_return_value',l_return_value);
698: pay_in_utils.trace('**************************************************','********************');
699: END IF;
700:
701: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 30);
702:

Line 701: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 30);

697: pay_in_utils.trace('l_return_value',l_return_value);
698: pay_in_utils.trace('**************************************************','********************');
699: END IF;
700:
701: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 30);
702:
703: RETURN l_return_value;
704:
705: EXCEPTION

Line 707: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_proc, 'SQLERRMC:'||sqlerrm);

703: RETURN l_return_value;
704:
705: EXCEPTION
706: WHEN OTHERS THEN
707: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_proc, 'SQLERRMC:'||sqlerrm);
708: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 50);
709: pay_in_utils.trace(l_message,l_proc);
710:
711: END remove_curr_format;

Line 708: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 50);

704:
705: EXCEPTION
706: WHEN OTHERS THEN
707: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_proc, 'SQLERRMC:'||sqlerrm);
708: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 50);
709: pay_in_utils.trace(l_message,l_proc);
710:
711: END remove_curr_format;
712:

Line 709: pay_in_utils.trace(l_message,l_proc);

705: EXCEPTION
706: WHEN OTHERS THEN
707: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_proc, 'SQLERRMC:'||sqlerrm);
708: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 50);
709: pay_in_utils.trace(l_message,l_proc);
710:
711: END remove_curr_format;
712:
713:

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

767:
768: BEGIN
769: g_debug := hr_utility.debug_enabled;
770: l_procedure := g_package ||'total_gross_tot_income';
771: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
772:
773: IF g_debug THEN
774: pay_in_utils.trace('**************************************************','********************');
775: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);

Line 774: pay_in_utils.trace('**************************************************','********************');

770: l_procedure := g_package ||'total_gross_tot_income';
771: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
772:
773: IF g_debug THEN
774: pay_in_utils.trace('**************************************************','********************');
775: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
776: pay_in_utils.trace('p_assess_period',p_assess_period);
777: pay_in_utils.trace('p_correction_type',p_correction_type);
778: pay_in_utils.trace('p_max_action_id',p_max_action_id);

Line 775: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);

771: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
772:
773: IF g_debug THEN
774: pay_in_utils.trace('**************************************************','********************');
775: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
776: pay_in_utils.trace('p_assess_period',p_assess_period);
777: pay_in_utils.trace('p_correction_type',p_correction_type);
778: pay_in_utils.trace('p_max_action_id',p_max_action_id);
779: pay_in_utils.trace('**************************************************','********************');

Line 776: pay_in_utils.trace('p_assess_period',p_assess_period);

772:
773: IF g_debug THEN
774: pay_in_utils.trace('**************************************************','********************');
775: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
776: pay_in_utils.trace('p_assess_period',p_assess_period);
777: pay_in_utils.trace('p_correction_type',p_correction_type);
778: pay_in_utils.trace('p_max_action_id',p_max_action_id);
779: pay_in_utils.trace('**************************************************','********************');
780: END IF;

Line 777: pay_in_utils.trace('p_correction_type',p_correction_type);

773: IF g_debug THEN
774: pay_in_utils.trace('**************************************************','********************');
775: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
776: pay_in_utils.trace('p_assess_period',p_assess_period);
777: pay_in_utils.trace('p_correction_type',p_correction_type);
778: pay_in_utils.trace('p_max_action_id',p_max_action_id);
779: pay_in_utils.trace('**************************************************','********************');
780: END IF;
781:

Line 778: pay_in_utils.trace('p_max_action_id',p_max_action_id);

774: pay_in_utils.trace('**************************************************','********************');
775: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
776: pay_in_utils.trace('p_assess_period',p_assess_period);
777: pay_in_utils.trace('p_correction_type',p_correction_type);
778: pay_in_utils.trace('p_max_action_id',p_max_action_id);
779: pay_in_utils.trace('**************************************************','********************');
780: END IF;
781:
782: IF (p_correction_type <> 'C4') THEN

Line 779: pay_in_utils.trace('**************************************************','********************');

775: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
776: pay_in_utils.trace('p_assess_period',p_assess_period);
777: pay_in_utils.trace('p_correction_type',p_correction_type);
778: pay_in_utils.trace('p_max_action_id',p_max_action_id);
779: pay_in_utils.trace('**************************************************','********************');
780: END IF;
781:
782: IF (p_correction_type <> 'C4') THEN
783: IF g_debug THEN

Line 784: pay_in_utils.trace('**************************************************','********************');

780: END IF;
781:
782: IF (p_correction_type <> 'C4') THEN
783: IF g_debug THEN
784: pay_in_utils.trace('**************************************************','********************');
785: pay_in_utils.trace('l_total_gross','^');
786: pay_in_utils.trace('**************************************************','********************');
787: END IF;
788: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);

Line 785: pay_in_utils.trace('l_total_gross','^');

781:
782: IF (p_correction_type <> 'C4') THEN
783: IF g_debug THEN
784: pay_in_utils.trace('**************************************************','********************');
785: pay_in_utils.trace('l_total_gross','^');
786: pay_in_utils.trace('**************************************************','********************');
787: END IF;
788: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
789: RETURN '^';

Line 786: pay_in_utils.trace('**************************************************','********************');

782: IF (p_correction_type <> 'C4') THEN
783: IF g_debug THEN
784: pay_in_utils.trace('**************************************************','********************');
785: pay_in_utils.trace('l_total_gross','^');
786: pay_in_utils.trace('**************************************************','********************');
787: END IF;
788: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
789: RETURN '^';
790: ELSE

Line 788: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);

784: pay_in_utils.trace('**************************************************','********************');
785: pay_in_utils.trace('l_total_gross','^');
786: pay_in_utils.trace('**************************************************','********************');
787: END IF;
788: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
789: RETURN '^';
790: ELSE
791:
792: FOR i IN csr_get_max_cont_id

Line 809: pay_in_utils.trace('**************************************************','********************');

805: l_total_value :=pay_in_24q_er_returns.get_format_value(l_total_gross);
806: END IF;
807:
808: IF g_debug THEN
809: pay_in_utils.trace('**************************************************','********************');
810: pay_in_utils.trace('l_total_value',SUBSTR(l_total_value,1,15)||'^');
811: pay_in_utils.trace('**************************************************','********************');
812: END IF;
813:

Line 810: pay_in_utils.trace('l_total_value',SUBSTR(l_total_value,1,15)||'^');

806: END IF;
807:
808: IF g_debug THEN
809: pay_in_utils.trace('**************************************************','********************');
810: pay_in_utils.trace('l_total_value',SUBSTR(l_total_value,1,15)||'^');
811: pay_in_utils.trace('**************************************************','********************');
812: END IF;
813:
814: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);

Line 811: pay_in_utils.trace('**************************************************','********************');

807:
808: IF g_debug THEN
809: pay_in_utils.trace('**************************************************','********************');
810: pay_in_utils.trace('l_total_value',SUBSTR(l_total_value,1,15)||'^');
811: pay_in_utils.trace('**************************************************','********************');
812: END IF;
813:
814: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
815:

Line 814: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);

810: pay_in_utils.trace('l_total_value',SUBSTR(l_total_value,1,15)||'^');
811: pay_in_utils.trace('**************************************************','********************');
812: END IF;
813:
814: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
815:
816: RETURN SUBSTR(l_total_value,1,15)||'^';
817:
818: END total_gross_tot_income;

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

869:
870: BEGIN
871: g_debug := hr_utility.debug_enabled;
872: l_procedure := g_package ||'salary_rec_count';
873: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
874:
875: IF g_debug THEN
876: pay_in_utils.trace('**************************************************','********************');
877: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);

Line 876: pay_in_utils.trace('**************************************************','********************');

872: l_procedure := g_package ||'salary_rec_count';
873: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
874:
875: IF g_debug THEN
876: pay_in_utils.trace('**************************************************','********************');
877: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
878: pay_in_utils.trace('p_assess_period',p_assess_period);
879: pay_in_utils.trace('p_correction_type',p_correction_type);
880: pay_in_utils.trace('p_max_action_id',p_max_action_id);

Line 877: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);

873: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
874:
875: IF g_debug THEN
876: pay_in_utils.trace('**************************************************','********************');
877: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
878: pay_in_utils.trace('p_assess_period',p_assess_period);
879: pay_in_utils.trace('p_correction_type',p_correction_type);
880: pay_in_utils.trace('p_max_action_id',p_max_action_id);
881: pay_in_utils.trace('**************************************************','********************');

Line 878: pay_in_utils.trace('p_assess_period',p_assess_period);

874:
875: IF g_debug THEN
876: pay_in_utils.trace('**************************************************','********************');
877: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
878: pay_in_utils.trace('p_assess_period',p_assess_period);
879: pay_in_utils.trace('p_correction_type',p_correction_type);
880: pay_in_utils.trace('p_max_action_id',p_max_action_id);
881: pay_in_utils.trace('**************************************************','********************');
882: END IF;

Line 879: pay_in_utils.trace('p_correction_type',p_correction_type);

875: IF g_debug THEN
876: pay_in_utils.trace('**************************************************','********************');
877: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
878: pay_in_utils.trace('p_assess_period',p_assess_period);
879: pay_in_utils.trace('p_correction_type',p_correction_type);
880: pay_in_utils.trace('p_max_action_id',p_max_action_id);
881: pay_in_utils.trace('**************************************************','********************');
882: END IF;
883:

Line 880: pay_in_utils.trace('p_max_action_id',p_max_action_id);

876: pay_in_utils.trace('**************************************************','********************');
877: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
878: pay_in_utils.trace('p_assess_period',p_assess_period);
879: pay_in_utils.trace('p_correction_type',p_correction_type);
880: pay_in_utils.trace('p_max_action_id',p_max_action_id);
881: pay_in_utils.trace('**************************************************','********************');
882: END IF;
883:
884: IF(p_correction_type NOT IN ('C4','C5'))THEN

Line 881: pay_in_utils.trace('**************************************************','********************');

877: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
878: pay_in_utils.trace('p_assess_period',p_assess_period);
879: pay_in_utils.trace('p_correction_type',p_correction_type);
880: pay_in_utils.trace('p_max_action_id',p_max_action_id);
881: pay_in_utils.trace('**************************************************','********************');
882: END IF;
883:
884: IF(p_correction_type NOT IN ('C4','C5'))THEN
885: IF g_debug THEN

Line 886: pay_in_utils.trace('**************************************************','********************');

882: END IF;
883:
884: IF(p_correction_type NOT IN ('C4','C5'))THEN
885: IF g_debug THEN
886: pay_in_utils.trace('**************************************************','********************');
887: pay_in_utils.trace('l_count','^');
888: pay_in_utils.trace('**************************************************','********************');
889: END IF;
890: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);

Line 887: pay_in_utils.trace('l_count','^');

883:
884: IF(p_correction_type NOT IN ('C4','C5'))THEN
885: IF g_debug THEN
886: pay_in_utils.trace('**************************************************','********************');
887: pay_in_utils.trace('l_count','^');
888: pay_in_utils.trace('**************************************************','********************');
889: END IF;
890: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
891: RETURN '^';

Line 888: pay_in_utils.trace('**************************************************','********************');

884: IF(p_correction_type NOT IN ('C4','C5'))THEN
885: IF g_debug THEN
886: pay_in_utils.trace('**************************************************','********************');
887: pay_in_utils.trace('l_count','^');
888: pay_in_utils.trace('**************************************************','********************');
889: END IF;
890: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
891: RETURN '^';
892: ELSE

Line 890: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);

886: pay_in_utils.trace('**************************************************','********************');
887: pay_in_utils.trace('l_count','^');
888: pay_in_utils.trace('**************************************************','********************');
889: END IF;
890: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
891: RETURN '^';
892: ELSE
893: OPEN c_count;
894: FETCH c_count INTO l_count;

Line 898: pay_in_utils.trace('**************************************************','********************');

894: FETCH c_count INTO l_count;
895: IF c_count%NOTFOUND THEN
896: CLOSE c_count;
897: IF g_debug THEN
898: pay_in_utils.trace('**************************************************','********************');
899: pay_in_utils.trace('l_count','0^');
900: pay_in_utils.trace('**************************************************','********************');
901: END IF;
902: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);

Line 899: pay_in_utils.trace('l_count','0^');

895: IF c_count%NOTFOUND THEN
896: CLOSE c_count;
897: IF g_debug THEN
898: pay_in_utils.trace('**************************************************','********************');
899: pay_in_utils.trace('l_count','0^');
900: pay_in_utils.trace('**************************************************','********************');
901: END IF;
902: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
903: RETURN '0^';

Line 900: pay_in_utils.trace('**************************************************','********************');

896: CLOSE c_count;
897: IF g_debug THEN
898: pay_in_utils.trace('**************************************************','********************');
899: pay_in_utils.trace('l_count','0^');
900: pay_in_utils.trace('**************************************************','********************');
901: END IF;
902: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
903: RETURN '0^';
904: END IF;

Line 902: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);

898: pay_in_utils.trace('**************************************************','********************');
899: pay_in_utils.trace('l_count','0^');
900: pay_in_utils.trace('**************************************************','********************');
901: END IF;
902: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
903: RETURN '0^';
904: END IF;
905: CLOSE c_count;
906:

Line 909: pay_in_utils.trace('**************************************************','********************');

905: CLOSE c_count;
906:
907:
908: IF g_debug THEN
909: pay_in_utils.trace('**************************************************','********************');
910: pay_in_utils.trace('l_count',TO_CHAR(l_count)||'^');
911: pay_in_utils.trace('**************************************************','********************');
912: END IF;
913:

Line 910: pay_in_utils.trace('l_count',TO_CHAR(l_count)||'^');

906:
907:
908: IF g_debug THEN
909: pay_in_utils.trace('**************************************************','********************');
910: pay_in_utils.trace('l_count',TO_CHAR(l_count)||'^');
911: pay_in_utils.trace('**************************************************','********************');
912: END IF;
913:
914: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);

Line 911: pay_in_utils.trace('**************************************************','********************');

907:
908: IF g_debug THEN
909: pay_in_utils.trace('**************************************************','********************');
910: pay_in_utils.trace('l_count',TO_CHAR(l_count)||'^');
911: pay_in_utils.trace('**************************************************','********************');
912: END IF;
913:
914: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
915:

Line 914: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);

910: pay_in_utils.trace('l_count',TO_CHAR(l_count)||'^');
911: pay_in_utils.trace('**************************************************','********************');
912: END IF;
913:
914: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
915:
916: RETURN TO_CHAR(l_count)||'^';
917: END IF;
918:

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

948:
949: BEGIN
950: g_debug := hr_utility.debug_enabled;
951: l_procedure := g_package ||'chapter_VIA_rec_count';
952: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
953:
954: IF g_debug THEN
955: pay_in_utils.trace('**************************************************','********************');
956: pay_in_utils.trace('p_action_context_id',p_action_context_id);

Line 955: pay_in_utils.trace('**************************************************','********************');

951: l_procedure := g_package ||'chapter_VIA_rec_count';
952: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
953:
954: IF g_debug THEN
955: pay_in_utils.trace('**************************************************','********************');
956: pay_in_utils.trace('p_action_context_id',p_action_context_id);
957: pay_in_utils.trace('p_source_id',p_source_id);
958: pay_in_utils.trace('**************************************************','********************');
959: END IF;

Line 956: pay_in_utils.trace('p_action_context_id',p_action_context_id);

952: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
953:
954: IF g_debug THEN
955: pay_in_utils.trace('**************************************************','********************');
956: pay_in_utils.trace('p_action_context_id',p_action_context_id);
957: pay_in_utils.trace('p_source_id',p_source_id);
958: pay_in_utils.trace('**************************************************','********************');
959: END IF;
960:

Line 957: pay_in_utils.trace('p_source_id',p_source_id);

953:
954: IF g_debug THEN
955: pay_in_utils.trace('**************************************************','********************');
956: pay_in_utils.trace('p_action_context_id',p_action_context_id);
957: pay_in_utils.trace('p_source_id',p_source_id);
958: pay_in_utils.trace('**************************************************','********************');
959: END IF;
960:
961: OPEN c_count;

Line 958: pay_in_utils.trace('**************************************************','********************');

954: IF g_debug THEN
955: pay_in_utils.trace('**************************************************','********************');
956: pay_in_utils.trace('p_action_context_id',p_action_context_id);
957: pay_in_utils.trace('p_source_id',p_source_id);
958: pay_in_utils.trace('**************************************************','********************');
959: END IF;
960:
961: OPEN c_count;
962: FETCH c_count INTO l_count;

Line 966: pay_in_utils.trace('**************************************************','********************');

962: FETCH c_count INTO l_count;
963: IF c_count%NOTFOUND THEN
964: CLOSE c_count;
965: IF g_debug THEN
966: pay_in_utils.trace('**************************************************','********************');
967: pay_in_utils.trace('l_count','0');
968: pay_in_utils.trace('**************************************************','********************');
969: END IF;
970: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);

Line 967: pay_in_utils.trace('l_count','0');

963: IF c_count%NOTFOUND THEN
964: CLOSE c_count;
965: IF g_debug THEN
966: pay_in_utils.trace('**************************************************','********************');
967: pay_in_utils.trace('l_count','0');
968: pay_in_utils.trace('**************************************************','********************');
969: END IF;
970: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
971: RETURN '0';

Line 968: pay_in_utils.trace('**************************************************','********************');

964: CLOSE c_count;
965: IF g_debug THEN
966: pay_in_utils.trace('**************************************************','********************');
967: pay_in_utils.trace('l_count','0');
968: pay_in_utils.trace('**************************************************','********************');
969: END IF;
970: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
971: RETURN '0';
972: END IF;

Line 970: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);

966: pay_in_utils.trace('**************************************************','********************');
967: pay_in_utils.trace('l_count','0');
968: pay_in_utils.trace('**************************************************','********************');
969: END IF;
970: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
971: RETURN '0';
972: END IF;
973: CLOSE c_count;
974:

Line 977: pay_in_utils.trace('**************************************************','********************');

973: CLOSE c_count;
974:
975:
976: IF g_debug THEN
977: pay_in_utils.trace('**************************************************','********************');
978: pay_in_utils.trace('l_count',TO_CHAR(l_count));
979: pay_in_utils.trace('**************************************************','********************');
980: END IF;
981:

Line 978: pay_in_utils.trace('l_count',TO_CHAR(l_count));

974:
975:
976: IF g_debug THEN
977: pay_in_utils.trace('**************************************************','********************');
978: pay_in_utils.trace('l_count',TO_CHAR(l_count));
979: pay_in_utils.trace('**************************************************','********************');
980: END IF;
981:
982: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);

Line 979: pay_in_utils.trace('**************************************************','********************');

975:
976: IF g_debug THEN
977: pay_in_utils.trace('**************************************************','********************');
978: pay_in_utils.trace('l_count',TO_CHAR(l_count));
979: pay_in_utils.trace('**************************************************','********************');
980: END IF;
981:
982: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
983:

Line 982: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);

978: pay_in_utils.trace('l_count',TO_CHAR(l_count));
979: pay_in_utils.trace('**************************************************','********************');
980: END IF;
981:
982: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
983:
984: RETURN TO_CHAR(l_count);
985:
986: END chapter_VIA_rec_count;