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_US_INS_ORG_INFO_PKG dependencies on HR_UTILITY

Line 38: hr_utility.trace('Entered insert_org_information');

34: l_dummy varchar2(1);
35: --
36: begin
37: --
38: hr_utility.trace('Entered insert_org_information');
39: --
40: hr_utility.set_location('pay_us_ins_org_info_pkg.insert_org_information',1);
41: if p_organization_id IS NULL
42: OR p_org_information_context IS NULL

Line 40: hr_utility.set_location('pay_us_ins_org_info_pkg.insert_org_information',1);

36: begin
37: --
38: hr_utility.trace('Entered insert_org_information');
39: --
40: hr_utility.set_location('pay_us_ins_org_info_pkg.insert_org_information',1);
41: if p_organization_id IS NULL
42: OR p_org_information_context IS NULL
43: OR p_org_information1 IS NULL
44: then

Line 45: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

41: if p_organization_id IS NULL
42: OR p_org_information_context IS NULL
43: OR p_org_information1 IS NULL
44: then
45: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
46: hr_utility.set_message_token('PROCEDURE','insert_org_information');
47: hr_utility.set_message_token('STEP','1');
48: hr_utility.raise_error;
49: end if;

Line 46: hr_utility.set_message_token('PROCEDURE','insert_org_information');

42: OR p_org_information_context IS NULL
43: OR p_org_information1 IS NULL
44: then
45: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
46: hr_utility.set_message_token('PROCEDURE','insert_org_information');
47: hr_utility.set_message_token('STEP','1');
48: hr_utility.raise_error;
49: end if;
50: --

Line 47: hr_utility.set_message_token('STEP','1');

43: OR p_org_information1 IS NULL
44: then
45: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
46: hr_utility.set_message_token('PROCEDURE','insert_org_information');
47: hr_utility.set_message_token('STEP','1');
48: hr_utility.raise_error;
49: end if;
50: --
51: hr_utility.set_location('pay_us_ins_org_info_pkg.insert_org_information',5);

Line 48: hr_utility.raise_error;

44: then
45: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
46: hr_utility.set_message_token('PROCEDURE','insert_org_information');
47: hr_utility.set_message_token('STEP','1');
48: hr_utility.raise_error;
49: end if;
50: --
51: hr_utility.set_location('pay_us_ins_org_info_pkg.insert_org_information',5);
52: SELECT organization_id

Line 51: hr_utility.set_location('pay_us_ins_org_info_pkg.insert_org_information',5);

47: hr_utility.set_message_token('STEP','1');
48: hr_utility.raise_error;
49: end if;
50: --
51: hr_utility.set_location('pay_us_ins_org_info_pkg.insert_org_information',5);
52: SELECT organization_id
53: INTO l_organization_id
54: FROM hr_all_organization_units
55: WHERE organization_id = p_organization_id;

Line 57: hr_utility.set_location('pay_us_ins_org_info_pkg.insert_org_information',8);

53: INTO l_organization_id
54: FROM hr_all_organization_units
55: WHERE organization_id = p_organization_id;
56: --
57: hr_utility.set_location('pay_us_ins_org_info_pkg.insert_org_information',8);
58: if p_org_information_context = 'CLASS' then
59: SELECT lookup_code
60: INTO l_org_information1
61: FROM hr_lookups

Line 67: hr_utility.trace('Entered Else');

63: AND lookup_code = p_org_information1;
64: --
65: l_org_information_type := p_org_information_context;
66: else
67: hr_utility.trace('Entered Else');
68: l_org_information1 := p_org_information1;
69: begin
70: --
71: --

Line 72: hr_utility.trace('p_org_information1 '||p_org_information1);

68: l_org_information1 := p_org_information1;
69: begin
70: --
71: --
72: hr_utility.trace('p_org_information1 '||p_org_information1);
73: hr_utility.trace('p_org_information_context '||p_org_information_context);
74: hr_utility.trace('l_organization_id '||to_char(l_organization_id));
75: --
76: --

Line 73: hr_utility.trace('p_org_information_context '||p_org_information_context);

69: begin
70: --
71: --
72: hr_utility.trace('p_org_information1 '||p_org_information1);
73: hr_utility.trace('p_org_information_context '||p_org_information_context);
74: hr_utility.trace('l_organization_id '||to_char(l_organization_id));
75: --
76: --
77: hr_utility.set_location('pay_us_ins_org_info_pkg.insert_org_information',10);

Line 74: hr_utility.trace('l_organization_id '||to_char(l_organization_id));

70: --
71: --
72: hr_utility.trace('p_org_information1 '||p_org_information1);
73: hr_utility.trace('p_org_information_context '||p_org_information_context);
74: hr_utility.trace('l_organization_id '||to_char(l_organization_id));
75: --
76: --
77: hr_utility.set_location('pay_us_ins_org_info_pkg.insert_org_information',10);
78: SELECT 'x' INTO l_dummy from dual;

Line 77: hr_utility.set_location('pay_us_ins_org_info_pkg.insert_org_information',10);

73: hr_utility.trace('p_org_information_context '||p_org_information_context);
74: hr_utility.trace('l_organization_id '||to_char(l_organization_id));
75: --
76: --
77: hr_utility.set_location('pay_us_ins_org_info_pkg.insert_org_information',10);
78: SELECT 'x' INTO l_dummy from dual;
79: -- SELECT oit.org_information_type
80: -- INTO l_org_information_type
81: -- FROM hr_organization_information hoi

Line 90: hr_utility.trace('l_org_information_type '||l_org_information_type);

86: -- AND tbc.org_classification = hoi.org_information1
87: -- AND hoi.org_information_context = 'CLASS'
88: -- AND hoi.organization_id = l_organization_id;
89: --
90: hr_utility.trace('l_org_information_type '||l_org_information_type);
91: exception when NO_DATA_FOUND then
92: hr_utility.trace('In No Data Found');
93: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
94: hr_utility.set_message_token('PROCEDURE','insert_org_information');

Line 92: hr_utility.trace('In No Data Found');

88: -- AND hoi.organization_id = l_organization_id;
89: --
90: hr_utility.trace('l_org_information_type '||l_org_information_type);
91: exception when NO_DATA_FOUND then
92: hr_utility.trace('In No Data Found');
93: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
94: hr_utility.set_message_token('PROCEDURE','insert_org_information');
95: hr_utility.set_message_token('STEP','10');
96: hr_utility.raise_error;

Line 93: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

89: --
90: hr_utility.trace('l_org_information_type '||l_org_information_type);
91: exception when NO_DATA_FOUND then
92: hr_utility.trace('In No Data Found');
93: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
94: hr_utility.set_message_token('PROCEDURE','insert_org_information');
95: hr_utility.set_message_token('STEP','10');
96: hr_utility.raise_error;
97: end;

Line 94: hr_utility.set_message_token('PROCEDURE','insert_org_information');

90: hr_utility.trace('l_org_information_type '||l_org_information_type);
91: exception when NO_DATA_FOUND then
92: hr_utility.trace('In No Data Found');
93: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
94: hr_utility.set_message_token('PROCEDURE','insert_org_information');
95: hr_utility.set_message_token('STEP','10');
96: hr_utility.raise_error;
97: end;
98: --

Line 95: hr_utility.set_message_token('STEP','10');

91: exception when NO_DATA_FOUND then
92: hr_utility.trace('In No Data Found');
93: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
94: hr_utility.set_message_token('PROCEDURE','insert_org_information');
95: hr_utility.set_message_token('STEP','10');
96: hr_utility.raise_error;
97: end;
98: --
99: end if;

Line 96: hr_utility.raise_error;

92: hr_utility.trace('In No Data Found');
93: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
94: hr_utility.set_message_token('PROCEDURE','insert_org_information');
95: hr_utility.set_message_token('STEP','10');
96: hr_utility.raise_error;
97: end;
98: --
99: end if;
100: --

Line 102: hr_utility.set_location('pay_us_ins_org_info_pkg.insert_org_information',15);

98: --
99: end if;
100: --
101: begin
102: hr_utility.set_location('pay_us_ins_org_info_pkg.insert_org_information',15);
103: SELECT 'Y'
104: INTO l_check
105: FROM hr_organization_information
106: WHERE organization_id = l_organization_id

Line 111: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

107: AND org_information_context = l_org_information_type
108: AND org_information1 = l_org_information1;
109: --
110: if l_check = 'Y' then
111: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
112: hr_utility.set_message_token('PROCEDURE','insert_org_information');
113: hr_utility.set_message_token('STEP','15');
114: hr_utility.raise_error;
115: end if;

Line 112: hr_utility.set_message_token('PROCEDURE','insert_org_information');

108: AND org_information1 = l_org_information1;
109: --
110: if l_check = 'Y' then
111: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
112: hr_utility.set_message_token('PROCEDURE','insert_org_information');
113: hr_utility.set_message_token('STEP','15');
114: hr_utility.raise_error;
115: end if;
116: --

Line 113: hr_utility.set_message_token('STEP','15');

109: --
110: if l_check = 'Y' then
111: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
112: hr_utility.set_message_token('PROCEDURE','insert_org_information');
113: hr_utility.set_message_token('STEP','15');
114: hr_utility.raise_error;
115: end if;
116: --
117: exception when NO_DATA_FOUND then null;

Line 114: hr_utility.raise_error;

110: if l_check = 'Y' then
111: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
112: hr_utility.set_message_token('PROCEDURE','insert_org_information');
113: hr_utility.set_message_token('STEP','15');
114: hr_utility.raise_error;
115: end if;
116: --
117: exception when NO_DATA_FOUND then null;
118: end;

Line 120: hr_utility.set_location('pay_us_ins_org_info_pkg.insert_org_information',20);

116: --
117: exception when NO_DATA_FOUND then null;
118: end;
119: --
120: hr_utility.set_location('pay_us_ins_org_info_pkg.insert_org_information',20);
121: SELECT hr_organization_information_s.nextval
122: INTO l_org_information_id
123: FROM sys.dual;
124: --

Line 125: -- hr_utility.trace('l_org_information_id is ' || to_char(l_org_information_id));

121: SELECT hr_organization_information_s.nextval
122: INTO l_org_information_id
123: FROM sys.dual;
124: --
125: -- hr_utility.trace('l_org_information_id is ' || to_char(l_org_information_id));
126: -- hr_utility.trace('p_organization_id is ' || to_char(p_organization_id));
127: hr_utility.trace('l_organization_id is ' || to_char(l_organization_id));
128: hr_utility.trace('l_org_information1 is ' || l_org_information1);
129: hr_utility.trace('l_org_information_type is ' || l_org_information_type);

Line 126: -- hr_utility.trace('p_organization_id is ' || to_char(p_organization_id));

122: INTO l_org_information_id
123: FROM sys.dual;
124: --
125: -- hr_utility.trace('l_org_information_id is ' || to_char(l_org_information_id));
126: -- hr_utility.trace('p_organization_id is ' || to_char(p_organization_id));
127: hr_utility.trace('l_organization_id is ' || to_char(l_organization_id));
128: hr_utility.trace('l_org_information1 is ' || l_org_information1);
129: hr_utility.trace('l_org_information_type is ' || l_org_information_type);
130: hr_utility.trace('l_check is ' || l_check);

Line 127: hr_utility.trace('l_organization_id is ' || to_char(l_organization_id));

123: FROM sys.dual;
124: --
125: -- hr_utility.trace('l_org_information_id is ' || to_char(l_org_information_id));
126: -- hr_utility.trace('p_organization_id is ' || to_char(p_organization_id));
127: hr_utility.trace('l_organization_id is ' || to_char(l_organization_id));
128: hr_utility.trace('l_org_information1 is ' || l_org_information1);
129: hr_utility.trace('l_org_information_type is ' || l_org_information_type);
130: hr_utility.trace('l_check is ' || l_check);
131: hr_utility.set_location('pay_us_ins_org_info_pkg.insert_org_information',25);

Line 128: hr_utility.trace('l_org_information1 is ' || l_org_information1);

124: --
125: -- hr_utility.trace('l_org_information_id is ' || to_char(l_org_information_id));
126: -- hr_utility.trace('p_organization_id is ' || to_char(p_organization_id));
127: hr_utility.trace('l_organization_id is ' || to_char(l_organization_id));
128: hr_utility.trace('l_org_information1 is ' || l_org_information1);
129: hr_utility.trace('l_org_information_type is ' || l_org_information_type);
130: hr_utility.trace('l_check is ' || l_check);
131: hr_utility.set_location('pay_us_ins_org_info_pkg.insert_org_information',25);
132: INSERT INTO HR_ORGANIZATION_INFORMATION

Line 129: hr_utility.trace('l_org_information_type is ' || l_org_information_type);

125: -- hr_utility.trace('l_org_information_id is ' || to_char(l_org_information_id));
126: -- hr_utility.trace('p_organization_id is ' || to_char(p_organization_id));
127: hr_utility.trace('l_organization_id is ' || to_char(l_organization_id));
128: hr_utility.trace('l_org_information1 is ' || l_org_information1);
129: hr_utility.trace('l_org_information_type is ' || l_org_information_type);
130: hr_utility.trace('l_check is ' || l_check);
131: hr_utility.set_location('pay_us_ins_org_info_pkg.insert_org_information',25);
132: INSERT INTO HR_ORGANIZATION_INFORMATION
133: (org_information_id

Line 130: hr_utility.trace('l_check is ' || l_check);

126: -- hr_utility.trace('p_organization_id is ' || to_char(p_organization_id));
127: hr_utility.trace('l_organization_id is ' || to_char(l_organization_id));
128: hr_utility.trace('l_org_information1 is ' || l_org_information1);
129: hr_utility.trace('l_org_information_type is ' || l_org_information_type);
130: hr_utility.trace('l_check is ' || l_check);
131: hr_utility.set_location('pay_us_ins_org_info_pkg.insert_org_information',25);
132: INSERT INTO HR_ORGANIZATION_INFORMATION
133: (org_information_id
134: ,organization_id

Line 131: hr_utility.set_location('pay_us_ins_org_info_pkg.insert_org_information',25);

127: hr_utility.trace('l_organization_id is ' || to_char(l_organization_id));
128: hr_utility.trace('l_org_information1 is ' || l_org_information1);
129: hr_utility.trace('l_org_information_type is ' || l_org_information_type);
130: hr_utility.trace('l_check is ' || l_check);
131: hr_utility.set_location('pay_us_ins_org_info_pkg.insert_org_information',25);
132: INSERT INTO HR_ORGANIZATION_INFORMATION
133: (org_information_id
134: ,organization_id
135: ,attribute_category

Line 194: hr_utility.set_location('pay_us_ins_org_info_pkg.insert_org_information',30);

190: ,hou.creation_date
191: FROM hr_organization_units hou
192: WHERE hou.organization_id = p_organization_id;
193: --
194: hr_utility.set_location('pay_us_ins_org_info_pkg.insert_org_information',30);
195: hr_utility.trace('before return');
196: return l_org_information_id;
197: hr_utility.trace('after return');
198: --

Line 195: hr_utility.trace('before return');

191: FROM hr_organization_units hou
192: WHERE hou.organization_id = p_organization_id;
193: --
194: hr_utility.set_location('pay_us_ins_org_info_pkg.insert_org_information',30);
195: hr_utility.trace('before return');
196: return l_org_information_id;
197: hr_utility.trace('after return');
198: --
199: --

Line 197: hr_utility.trace('after return');

193: --
194: hr_utility.set_location('pay_us_ins_org_info_pkg.insert_org_information',30);
195: hr_utility.trace('before return');
196: return l_org_information_id;
197: hr_utility.trace('after return');
198: --
199: --
200: end insert_org_information;
201: --