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 1011: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

1007: BEGIN
1008:
1009: g_debug := hr_utility.debug_enabled;
1010: l_procedure := g_package ||'create_xml';
1011: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1012: l_term_date := fnd_date.displayDT_to_date(p_term_date);
1013: IF (g_debug)
1014: THEN
1015: pay_in_utils.trace('**************************************************','********************');

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

1011: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1012: l_term_date := fnd_date.displayDT_to_date(p_term_date);
1013: IF (g_debug)
1014: THEN
1015: pay_in_utils.trace('**************************************************','********************');
1016: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
1017: pay_in_utils.trace('p_employee_number',p_employee_number);
1018: pay_in_utils.trace('l_term_date',l_term_date);
1019: pay_in_utils.trace('p_bus_grp_id',p_bus_grp_id);

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

1012: l_term_date := fnd_date.displayDT_to_date(p_term_date);
1013: IF (g_debug)
1014: THEN
1015: pay_in_utils.trace('**************************************************','********************');
1016: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
1017: pay_in_utils.trace('p_employee_number',p_employee_number);
1018: pay_in_utils.trace('l_term_date',l_term_date);
1019: pay_in_utils.trace('p_bus_grp_id',p_bus_grp_id);
1020: END IF;

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

1013: IF (g_debug)
1014: THEN
1015: pay_in_utils.trace('**************************************************','********************');
1016: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
1017: pay_in_utils.trace('p_employee_number',p_employee_number);
1018: pay_in_utils.trace('l_term_date',l_term_date);
1019: pay_in_utils.trace('p_bus_grp_id',p_bus_grp_id);
1020: END IF;
1021: --

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

1014: THEN
1015: pay_in_utils.trace('**************************************************','********************');
1016: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
1017: pay_in_utils.trace('p_employee_number',p_employee_number);
1018: pay_in_utils.trace('l_term_date',l_term_date);
1019: pay_in_utils.trace('p_bus_grp_id',p_bus_grp_id);
1020: END IF;
1021: --
1022: gXMLTable.DELETE;

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

1015: pay_in_utils.trace('**************************************************','********************');
1016: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
1017: pay_in_utils.trace('p_employee_number',p_employee_number);
1018: pay_in_utils.trace('l_term_date',l_term_date);
1019: pay_in_utils.trace('p_bus_grp_id',p_bus_grp_id);
1020: END IF;
1021: --
1022: gXMLTable.DELETE;
1023: l_count := 1;

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

1072: END IF;
1073:
1074: IF (g_debug)
1075: THEN
1076: pay_in_utils.trace('l_asg_max_run_action_id',l_asg_max_run_action_id);
1077: END IF;
1078:
1079: FOR c_rec in c_employee_details(p_employee_number
1080: ,p_bus_grp_id

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

1735: ,l_net_pay));
1736: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1737:
1738: IF l_net_pay >= 0 THEN
1739: l_tag := getTag('c_net_amount_in_words', initcap(pay_in_utils.number_to_words(l_net_pay)));
1740: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1741: END IF;
1742:
1743: --

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

1812: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1813: --
1814: l_xml_data := p_xml_data;
1815: --
1816: pay_in_utils.trace('**************************************************','********************');
1817: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
1818:
1819: END create_xml;
1820: --

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

1813: --
1814: l_xml_data := p_xml_data;
1815: --
1816: pay_in_utils.trace('**************************************************','********************');
1817: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
1818:
1819: END create_xml;
1820: --
1821: end pay_in_term_rprt_gen_pkg;