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

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

32: l_message VARCHAR2(250);
33: BEGIN
34: g_debug := hr_utility.debug_enabled;
35: l_procedure := g_package ||'multiColumnar';
36: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
37: IF (g_debug)
38: THEN
39: pay_in_utils.trace('**************************************************','********************');
40: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);

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

35: l_procedure := g_package ||'multiColumnar';
36: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
37: IF (g_debug)
38: THEN
39: pay_in_utils.trace('**************************************************','********************');
40: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
41: pay_in_utils.trace('p_type',p_type);
42: pay_in_utils.trace('p_count',p_count);
43: END IF;

Line 40: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);

36: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
37: IF (g_debug)
38: THEN
39: pay_in_utils.trace('**************************************************','********************');
40: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
41: pay_in_utils.trace('p_type',p_type);
42: pay_in_utils.trace('p_count',p_count);
43: END IF;
44:

Line 41: pay_in_utils.trace('p_type',p_type);

37: IF (g_debug)
38: THEN
39: pay_in_utils.trace('**************************************************','********************');
40: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
41: pay_in_utils.trace('p_type',p_type);
42: pay_in_utils.trace('p_count',p_count);
43: END IF;
44:
45: --

Line 42: pay_in_utils.trace('p_count',p_count);

38: THEN
39: pay_in_utils.trace('**************************************************','********************');
40: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
41: pay_in_utils.trace('p_type',p_type);
42: pay_in_utils.trace('p_count',p_count);
43: END IF;
44:
45: --
46: l_tag := '<'||p_type||'>';

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

59: END LOOP;
60: --
61: l_tag := '';
62: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
63: pay_in_utils.trace('**************************************************','********************');
64: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
65: --
66: END multiColumnar;
67:

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

60: --
61: l_tag := '';
62: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
63: pay_in_utils.trace('**************************************************','********************');
64: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
65: --
66: END multiColumnar;
67:
68: --------------------------------------------------------------------------

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

92: l_message VARCHAR2(250);
93: BEGIN
94: g_debug := hr_utility.debug_enabled;
95: l_procedure := g_package ||'twoColumnar';
96: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
97: IF (g_debug)
98: THEN
99: pay_in_utils.trace('**************************************************','********************');
100: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);

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

95: l_procedure := g_package ||'twoColumnar';
96: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
97: IF (g_debug)
98: THEN
99: pay_in_utils.trace('**************************************************','********************');
100: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
101: pay_in_utils.trace('p_type',p_type);
102: pay_in_utils.trace('p_count',p_count);
103: END IF;

Line 100: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);

96: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
97: IF (g_debug)
98: THEN
99: pay_in_utils.trace('**************************************************','********************');
100: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
101: pay_in_utils.trace('p_type',p_type);
102: pay_in_utils.trace('p_count',p_count);
103: END IF;
104: --

Line 101: pay_in_utils.trace('p_type',p_type);

97: IF (g_debug)
98: THEN
99: pay_in_utils.trace('**************************************************','********************');
100: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
101: pay_in_utils.trace('p_type',p_type);
102: pay_in_utils.trace('p_count',p_count);
103: END IF;
104: --
105: FOR i in 1..p_count

Line 102: pay_in_utils.trace('p_count',p_count);

98: THEN
99: pay_in_utils.trace('**************************************************','********************');
100: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
101: pay_in_utils.trace('p_type',p_type);
102: pay_in_utils.trace('p_count',p_count);
103: END IF;
104: --
105: FOR i in 1..p_count
106: LOOP

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

125: --
126: END IF;
127: --
128: END LOOP;
129: pay_in_utils.trace('**************************************************','********************');
130: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
131: --
132: end twoColumnar;
133:

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

126: END IF;
127: --
128: END LOOP;
129: pay_in_utils.trace('**************************************************','********************');
130: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
131: --
132: end twoColumnar;
133:
134: --------------------------------------------------------------------------

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

160: BEGIN
161: --
162: g_debug := hr_utility.debug_enabled;
163: l_procedure := g_package ||'getTag';
164: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
165:
166: l_tag_value:=nvl(pay_in_utils.encode_html_string(p_tag_value),' ');
167: --Return Tag
168: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);

Line 166: l_tag_value:=nvl(pay_in_utils.encode_html_string(p_tag_value),' ');

162: g_debug := hr_utility.debug_enabled;
163: l_procedure := g_package ||'getTag';
164: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
165:
166: l_tag_value:=nvl(pay_in_utils.encode_html_string(p_tag_value),' ');
167: --Return Tag
168: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
169: return '<'||p_tag_name||'>'||l_tag_value||'';
170: --

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

164: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
165:
166: l_tag_value:=nvl(pay_in_utils.encode_html_string(p_tag_value),' ');
167: --Return Tag
168: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
169: return '<'||p_tag_name||'>'||l_tag_value||'';
170: --
171: END getTag;
172:

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

206: --
207: BEGIN
208: --
209: l_procedure := g_package || 'get_template';
210: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
211:
212: IF g_debug THEN
213: pay_in_utils.trace('**************************************************','********************');
214: pay_in_utils.trace('p_business_group_id',p_business_group_id);

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

209: l_procedure := g_package || 'get_template';
210: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
211:
212: IF g_debug THEN
213: pay_in_utils.trace('**************************************************','********************');
214: pay_in_utils.trace('p_business_group_id',p_business_group_id);
215: pay_in_utils.trace('**************************************************','********************');
216: END IF;
217:

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

210: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
211:
212: IF g_debug THEN
213: pay_in_utils.trace('**************************************************','********************');
214: pay_in_utils.trace('p_business_group_id',p_business_group_id);
215: pay_in_utils.trace('**************************************************','********************');
216: END IF;
217:
218:

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

211:
212: IF g_debug THEN
213: pay_in_utils.trace('**************************************************','********************');
214: pay_in_utils.trace('p_business_group_id',p_business_group_id);
215: pay_in_utils.trace('**************************************************','********************');
216: END IF;
217:
218:
219:

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

228: p_template := 'PER_IN_TERM_TEMPLATE';
229: --
230: ELSE
231: --
232: pay_in_utils.trace('l_template ',l_template);
233: pay_in_utils.set_location(g_debug,l_procedure,20);
234:
235: p_template := l_template;
236: --

Line 233: pay_in_utils.set_location(g_debug,l_procedure,20);

229: --
230: ELSE
231: --
232: pay_in_utils.trace('l_template ',l_template);
233: pay_in_utils.set_location(g_debug,l_procedure,20);
234:
235: p_template := l_template;
236: --
237: END IF;

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

236: --
237: END IF;
238: --
239: IF g_debug THEN
240: pay_in_utils.trace('**************************************************','********************');
241: pay_in_utils.trace('p_template',p_template);
242: pay_in_utils.trace('**************************************************','********************');
243: END IF;
244:

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

237: END IF;
238: --
239: IF g_debug THEN
240: pay_in_utils.trace('**************************************************','********************');
241: pay_in_utils.trace('p_template',p_template);
242: pay_in_utils.trace('**************************************************','********************');
243: END IF;
244:
245: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);

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

238: --
239: IF g_debug THEN
240: pay_in_utils.trace('**************************************************','********************');
241: pay_in_utils.trace('p_template',p_template);
242: pay_in_utils.trace('**************************************************','********************');
243: END IF;
244:
245: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);
246:

Line 245: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);

241: pay_in_utils.trace('p_template',p_template);
242: pay_in_utils.trace('**************************************************','********************');
243: END IF;
244:
245: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);
246:
247: EXCEPTION
248: WHEN OTHERS THEN
249: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);

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

245: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);
246:
247: EXCEPTION
248: WHEN OTHERS THEN
249: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
250: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,50);
251: pay_in_utils.trace(l_message,l_procedure);
252:
253: IF csr_final_settlement_info%ISOPEN THEN

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

246:
247: EXCEPTION
248: WHEN OTHERS THEN
249: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
250: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,50);
251: pay_in_utils.trace(l_message,l_procedure);
252:
253: IF csr_final_settlement_info%ISOPEN THEN
254: CLOSE csr_final_settlement_info;

Line 251: pay_in_utils.trace(l_message,l_procedure);

247: EXCEPTION
248: WHEN OTHERS THEN
249: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
250: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,50);
251: pay_in_utils.trace(l_message,l_procedure);
252:
253: IF csr_final_settlement_info%ISOPEN THEN
254: CLOSE csr_final_settlement_info;
255: END IF;

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

1104: BEGIN
1105:
1106: g_debug := hr_utility.debug_enabled;
1107: l_procedure := g_package ||'create_xml';
1108: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1109: l_term_date := fnd_date.displayDT_to_date(p_term_date);
1110: IF (g_debug)
1111: THEN
1112: pay_in_utils.trace('**************************************************','********************');

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

1108: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1109: l_term_date := fnd_date.displayDT_to_date(p_term_date);
1110: IF (g_debug)
1111: THEN
1112: pay_in_utils.trace('**************************************************','********************');
1113: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
1114: pay_in_utils.trace('p_employee_number',p_employee_number);
1115: pay_in_utils.trace('l_term_date',l_term_date);
1116: pay_in_utils.trace('p_bus_grp_id',p_bus_grp_id);

Line 1113: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);

1109: l_term_date := fnd_date.displayDT_to_date(p_term_date);
1110: IF (g_debug)
1111: THEN
1112: pay_in_utils.trace('**************************************************','********************');
1113: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
1114: pay_in_utils.trace('p_employee_number',p_employee_number);
1115: pay_in_utils.trace('l_term_date',l_term_date);
1116: pay_in_utils.trace('p_bus_grp_id',p_bus_grp_id);
1117: END IF;

Line 1114: pay_in_utils.trace('p_employee_number',p_employee_number);

1110: IF (g_debug)
1111: THEN
1112: pay_in_utils.trace('**************************************************','********************');
1113: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
1114: pay_in_utils.trace('p_employee_number',p_employee_number);
1115: pay_in_utils.trace('l_term_date',l_term_date);
1116: pay_in_utils.trace('p_bus_grp_id',p_bus_grp_id);
1117: END IF;
1118: --

Line 1115: pay_in_utils.trace('l_term_date',l_term_date);

1111: THEN
1112: pay_in_utils.trace('**************************************************','********************');
1113: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
1114: pay_in_utils.trace('p_employee_number',p_employee_number);
1115: pay_in_utils.trace('l_term_date',l_term_date);
1116: pay_in_utils.trace('p_bus_grp_id',p_bus_grp_id);
1117: END IF;
1118: --
1119: gXMLTable.DELETE;

Line 1116: pay_in_utils.trace('p_bus_grp_id',p_bus_grp_id);

1112: pay_in_utils.trace('**************************************************','********************');
1113: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
1114: pay_in_utils.trace('p_employee_number',p_employee_number);
1115: pay_in_utils.trace('l_term_date',l_term_date);
1116: pay_in_utils.trace('p_bus_grp_id',p_bus_grp_id);
1117: END IF;
1118: --
1119: gXMLTable.DELETE;
1120: l_count := 1;

Line 1173: pay_in_utils.trace('l_asg_max_run_action_id',l_asg_max_run_action_id);

1169: END IF;
1170:
1171: IF (g_debug)
1172: THEN
1173: pay_in_utils.trace('l_asg_max_run_action_id',l_asg_max_run_action_id);
1174: END IF;
1175:
1176: FOR c_rec in c_employee_details(p_employee_number
1177: ,p_bus_grp_id

Line 1868: l_tag := getTag('c_net_amount_in_words', initcap(pay_in_utils.number_to_words(l_net_pay)));

1864: ,l_net_pay));
1865: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1866:
1867: IF l_net_pay >= 0 THEN
1868: l_tag := getTag('c_net_amount_in_words', initcap(pay_in_utils.number_to_words(l_net_pay)));
1869: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1870: END IF;
1871:
1872: --

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

1941: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1942: --
1943: l_xml_data := p_xml_data;
1944: --
1945: pay_in_utils.trace('**************************************************','********************');
1946: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
1947:
1948: END create_xml;
1949: --

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

1942: --
1943: l_xml_data := p_xml_data;
1944: --
1945: pay_in_utils.trace('**************************************************','********************');
1946: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
1947:
1948: END create_xml;
1949: --
1950: end pay_in_term_rprt_gen_pkg;