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

Line 18: hr_utility.set_location('Entering:'||l_proc, 5);

14: --
15: l_proc varchar2(72) := g_package||'return_api_dml_status';
16: --
17: Begin
18: hr_utility.set_location('Entering:'||l_proc, 5);
19: --
20: Return (nvl(g_api_dml, false));
21: --
22: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 22: hr_utility.set_location(' Leaving:'||l_proc, 10);

18: hr_utility.set_location('Entering:'||l_proc, 5);
19: --
20: Return (nvl(g_api_dml, false));
21: --
22: hr_utility.set_location(' Leaving:'||l_proc, 10);
23: End return_api_dml_status;
24: --
25: -- ----------------------------------------------------------------------------
26: -- |---------------------------< constraint_error >---------------------------|

Line 34: hr_utility.set_location('Entering:'||l_proc, 5);

30: --
31: l_proc varchar2(72) := g_package||'constraint_error';
32: --
33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'PAY_NCR_ADD_OR_SUBTRACT_CHK') Then
37: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
38: hr_utility.set_message_token('PROCEDURE', l_proc);

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

33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'PAY_NCR_ADD_OR_SUBTRACT_CHK') Then
37: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
38: hr_utility.set_message_token('PROCEDURE', l_proc);
39: hr_utility.set_message_token('STEP','5');
40: hr_utility.raise_error;
41: ElsIf (p_constraint_name = 'PAY_NET_CALCULATION_RULES_FK1') Then

Line 38: hr_utility.set_message_token('PROCEDURE', l_proc);

34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'PAY_NCR_ADD_OR_SUBTRACT_CHK') Then
37: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
38: hr_utility.set_message_token('PROCEDURE', l_proc);
39: hr_utility.set_message_token('STEP','5');
40: hr_utility.raise_error;
41: ElsIf (p_constraint_name = 'PAY_NET_CALCULATION_RULES_FK1') Then
42: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 39: hr_utility.set_message_token('STEP','5');

35: --
36: If (p_constraint_name = 'PAY_NCR_ADD_OR_SUBTRACT_CHK') Then
37: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
38: hr_utility.set_message_token('PROCEDURE', l_proc);
39: hr_utility.set_message_token('STEP','5');
40: hr_utility.raise_error;
41: ElsIf (p_constraint_name = 'PAY_NET_CALCULATION_RULES_FK1') Then
42: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
43: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 40: hr_utility.raise_error;

36: If (p_constraint_name = 'PAY_NCR_ADD_OR_SUBTRACT_CHK') Then
37: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
38: hr_utility.set_message_token('PROCEDURE', l_proc);
39: hr_utility.set_message_token('STEP','5');
40: hr_utility.raise_error;
41: ElsIf (p_constraint_name = 'PAY_NET_CALCULATION_RULES_FK1') Then
42: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
43: hr_utility.set_message_token('PROCEDURE', l_proc);
44: hr_utility.set_message_token('STEP','10');

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

38: hr_utility.set_message_token('PROCEDURE', l_proc);
39: hr_utility.set_message_token('STEP','5');
40: hr_utility.raise_error;
41: ElsIf (p_constraint_name = 'PAY_NET_CALCULATION_RULES_FK1') Then
42: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
43: hr_utility.set_message_token('PROCEDURE', l_proc);
44: hr_utility.set_message_token('STEP','10');
45: hr_utility.raise_error;
46: ElsIf (p_constraint_name = 'PAY_NET_CALCULATION_RULES_FK2') Then

Line 43: hr_utility.set_message_token('PROCEDURE', l_proc);

39: hr_utility.set_message_token('STEP','5');
40: hr_utility.raise_error;
41: ElsIf (p_constraint_name = 'PAY_NET_CALCULATION_RULES_FK1') Then
42: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
43: hr_utility.set_message_token('PROCEDURE', l_proc);
44: hr_utility.set_message_token('STEP','10');
45: hr_utility.raise_error;
46: ElsIf (p_constraint_name = 'PAY_NET_CALCULATION_RULES_FK2') Then
47: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

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

40: hr_utility.raise_error;
41: ElsIf (p_constraint_name = 'PAY_NET_CALCULATION_RULES_FK1') Then
42: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
43: hr_utility.set_message_token('PROCEDURE', l_proc);
44: hr_utility.set_message_token('STEP','10');
45: hr_utility.raise_error;
46: ElsIf (p_constraint_name = 'PAY_NET_CALCULATION_RULES_FK2') Then
47: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
48: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 45: hr_utility.raise_error;

41: ElsIf (p_constraint_name = 'PAY_NET_CALCULATION_RULES_FK1') Then
42: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
43: hr_utility.set_message_token('PROCEDURE', l_proc);
44: hr_utility.set_message_token('STEP','10');
45: hr_utility.raise_error;
46: ElsIf (p_constraint_name = 'PAY_NET_CALCULATION_RULES_FK2') Then
47: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
48: hr_utility.set_message_token('PROCEDURE', l_proc);
49: hr_utility.set_message_token('STEP','15');

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

43: hr_utility.set_message_token('PROCEDURE', l_proc);
44: hr_utility.set_message_token('STEP','10');
45: hr_utility.raise_error;
46: ElsIf (p_constraint_name = 'PAY_NET_CALCULATION_RULES_FK2') Then
47: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
48: hr_utility.set_message_token('PROCEDURE', l_proc);
49: hr_utility.set_message_token('STEP','15');
50: hr_utility.raise_error;
51: ElsIf (p_constraint_name = 'PAY_NET_CALCULATION_RULES_PK') Then

Line 48: hr_utility.set_message_token('PROCEDURE', l_proc);

44: hr_utility.set_message_token('STEP','10');
45: hr_utility.raise_error;
46: ElsIf (p_constraint_name = 'PAY_NET_CALCULATION_RULES_FK2') Then
47: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
48: hr_utility.set_message_token('PROCEDURE', l_proc);
49: hr_utility.set_message_token('STEP','15');
50: hr_utility.raise_error;
51: ElsIf (p_constraint_name = 'PAY_NET_CALCULATION_RULES_PK') Then
52: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

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

45: hr_utility.raise_error;
46: ElsIf (p_constraint_name = 'PAY_NET_CALCULATION_RULES_FK2') Then
47: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
48: hr_utility.set_message_token('PROCEDURE', l_proc);
49: hr_utility.set_message_token('STEP','15');
50: hr_utility.raise_error;
51: ElsIf (p_constraint_name = 'PAY_NET_CALCULATION_RULES_PK') Then
52: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
53: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 50: hr_utility.raise_error;

46: ElsIf (p_constraint_name = 'PAY_NET_CALCULATION_RULES_FK2') Then
47: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
48: hr_utility.set_message_token('PROCEDURE', l_proc);
49: hr_utility.set_message_token('STEP','15');
50: hr_utility.raise_error;
51: ElsIf (p_constraint_name = 'PAY_NET_CALCULATION_RULES_PK') Then
52: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
53: hr_utility.set_message_token('PROCEDURE', l_proc);
54: hr_utility.set_message_token('STEP','20');

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

48: hr_utility.set_message_token('PROCEDURE', l_proc);
49: hr_utility.set_message_token('STEP','15');
50: hr_utility.raise_error;
51: ElsIf (p_constraint_name = 'PAY_NET_CALCULATION_RULES_PK') Then
52: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
53: hr_utility.set_message_token('PROCEDURE', l_proc);
54: hr_utility.set_message_token('STEP','20');
55: hr_utility.raise_error;
56: Else

Line 53: hr_utility.set_message_token('PROCEDURE', l_proc);

49: hr_utility.set_message_token('STEP','15');
50: hr_utility.raise_error;
51: ElsIf (p_constraint_name = 'PAY_NET_CALCULATION_RULES_PK') Then
52: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
53: hr_utility.set_message_token('PROCEDURE', l_proc);
54: hr_utility.set_message_token('STEP','20');
55: hr_utility.raise_error;
56: Else
57: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');

Line 54: hr_utility.set_message_token('STEP','20');

50: hr_utility.raise_error;
51: ElsIf (p_constraint_name = 'PAY_NET_CALCULATION_RULES_PK') Then
52: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
53: hr_utility.set_message_token('PROCEDURE', l_proc);
54: hr_utility.set_message_token('STEP','20');
55: hr_utility.raise_error;
56: Else
57: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
58: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 55: hr_utility.raise_error;

51: ElsIf (p_constraint_name = 'PAY_NET_CALCULATION_RULES_PK') Then
52: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
53: hr_utility.set_message_token('PROCEDURE', l_proc);
54: hr_utility.set_message_token('STEP','20');
55: hr_utility.raise_error;
56: Else
57: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
58: hr_utility.set_message_token('PROCEDURE', l_proc);
59: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);

Line 57: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');

53: hr_utility.set_message_token('PROCEDURE', l_proc);
54: hr_utility.set_message_token('STEP','20');
55: hr_utility.raise_error;
56: Else
57: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
58: hr_utility.set_message_token('PROCEDURE', l_proc);
59: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
60: hr_utility.raise_error;
61: End If;

Line 58: hr_utility.set_message_token('PROCEDURE', l_proc);

54: hr_utility.set_message_token('STEP','20');
55: hr_utility.raise_error;
56: Else
57: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
58: hr_utility.set_message_token('PROCEDURE', l_proc);
59: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
60: hr_utility.raise_error;
61: End If;
62: --

Line 59: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);

55: hr_utility.raise_error;
56: Else
57: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
58: hr_utility.set_message_token('PROCEDURE', l_proc);
59: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
60: hr_utility.raise_error;
61: End If;
62: --
63: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 60: hr_utility.raise_error;

56: Else
57: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
58: hr_utility.set_message_token('PROCEDURE', l_proc);
59: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
60: hr_utility.raise_error;
61: End If;
62: --
63: hr_utility.set_location(' Leaving:'||l_proc, 10);
64: End constraint_error;

Line 63: hr_utility.set_location(' Leaving:'||l_proc, 10);

59: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
60: hr_utility.raise_error;
61: End If;
62: --
63: hr_utility.set_location(' Leaving:'||l_proc, 10);
64: End constraint_error;
65: --
66: -- ----------------------------------------------------------------------------
67: -- |-----------------------------< api_updating >-----------------------------|

Line 94: hr_utility.set_location('Entering:'||l_proc, 5);

90: l_proc varchar2(72) := g_package||'api_updating';
91: l_fct_ret boolean;
92: --
93: Begin
94: hr_utility.set_location('Entering:'||l_proc, 5);
95: --
96: If (
97: p_net_calculation_rule_id is null and
98: p_object_version_number is null

Line 110: hr_utility.set_location(l_proc, 10);

106: If (
107: p_net_calculation_rule_id = g_old_rec.net_calculation_rule_id and
108: p_object_version_number = g_old_rec.object_version_number
109: ) Then
110: hr_utility.set_location(l_proc, 10);
111: --
112: -- The g_old_rec is current therefore we must
113: -- set the returning function to true
114: --

Line 127: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');

123: Close C_Sel1;
124: --
125: -- The primary key is invalid therefore we must error
126: --
127: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
128: hr_utility.raise_error;
129: End If;
130: Close C_Sel1;
131: If (p_object_version_number <> g_old_rec.object_version_number) Then

Line 128: hr_utility.raise_error;

124: --
125: -- The primary key is invalid therefore we must error
126: --
127: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
128: hr_utility.raise_error;
129: End If;
130: Close C_Sel1;
131: If (p_object_version_number <> g_old_rec.object_version_number) Then
132: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');

Line 132: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');

128: hr_utility.raise_error;
129: End If;
130: Close C_Sel1;
131: If (p_object_version_number <> g_old_rec.object_version_number) Then
132: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
133: hr_utility.raise_error;
134: End If;
135: hr_utility.set_location(l_proc, 15);
136: l_fct_ret := true;

Line 133: hr_utility.raise_error;

129: End If;
130: Close C_Sel1;
131: If (p_object_version_number <> g_old_rec.object_version_number) Then
132: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
133: hr_utility.raise_error;
134: End If;
135: hr_utility.set_location(l_proc, 15);
136: l_fct_ret := true;
137: End If;

Line 135: hr_utility.set_location(l_proc, 15);

131: If (p_object_version_number <> g_old_rec.object_version_number) Then
132: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
133: hr_utility.raise_error;
134: End If;
135: hr_utility.set_location(l_proc, 15);
136: l_fct_ret := true;
137: End If;
138: End If;
139: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 139: hr_utility.set_location(' Leaving:'||l_proc, 20);

135: hr_utility.set_location(l_proc, 15);
136: l_fct_ret := true;
137: End If;
138: End If;
139: hr_utility.set_location(' Leaving:'||l_proc, 20);
140: Return (l_fct_ret);
141: --
142: End api_updating;
143: --

Line 170: hr_utility.set_location('Entering:'||l_proc, 5);

166: --
167: l_proc varchar2(72) := g_package||'lck';
168: --
169: Begin
170: hr_utility.set_location('Entering:'||l_proc, 5);
171: --
172: hr_api.mandatory_arg_error
173: (p_api_name => l_proc,
174: p_argument => 'object_version_number',

Line 184: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');

180: Close C_Sel1;
181: --
182: -- The primary key is invalid therefore we must error
183: --
184: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
185: hr_utility.raise_error;
186: End If;
187: Close C_Sel1;
188: If (p_object_version_number <> g_old_rec.object_version_number) Then

Line 185: hr_utility.raise_error;

181: --
182: -- The primary key is invalid therefore we must error
183: --
184: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
185: hr_utility.raise_error;
186: End If;
187: Close C_Sel1;
188: If (p_object_version_number <> g_old_rec.object_version_number) Then
189: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');

Line 189: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');

185: hr_utility.raise_error;
186: End If;
187: Close C_Sel1;
188: If (p_object_version_number <> g_old_rec.object_version_number) Then
189: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
190: hr_utility.raise_error;
191: End If;
192: --
193: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 190: hr_utility.raise_error;

186: End If;
187: Close C_Sel1;
188: If (p_object_version_number <> g_old_rec.object_version_number) Then
189: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
190: hr_utility.raise_error;
191: End If;
192: --
193: hr_utility.set_location(' Leaving:'||l_proc, 10);
194: --

Line 193: hr_utility.set_location(' Leaving:'||l_proc, 10);

189: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
190: hr_utility.raise_error;
191: End If;
192: --
193: hr_utility.set_location(' Leaving:'||l_proc, 10);
194: --
195: -- We need to trap the ORA LOCK exception
196: --
197: Exception

Line 203: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');

199: --
200: -- The object is locked therefore we need to supply a meaningful
201: -- error message.
202: --
203: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
204: hr_utility.set_message_token('TABLE_NAME', 'pay_net_calculation_rules');
205: hr_utility.raise_error;
206: End lck;
207: --

Line 204: hr_utility.set_message_token('TABLE_NAME', 'pay_net_calculation_rules');

200: -- The object is locked therefore we need to supply a meaningful
201: -- error message.
202: --
203: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
204: hr_utility.set_message_token('TABLE_NAME', 'pay_net_calculation_rules');
205: hr_utility.raise_error;
206: End lck;
207: --
208: -- ----------------------------------------------------------------------------

Line 205: hr_utility.raise_error;

201: -- error message.
202: --
203: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
204: hr_utility.set_message_token('TABLE_NAME', 'pay_net_calculation_rules');
205: hr_utility.raise_error;
206: End lck;
207: --
208: -- ----------------------------------------------------------------------------
209: -- |-----------------------------< convert_args >-----------------------------|

Line 228: hr_utility.set_location('Entering:'||l_proc, 5);

224: l_proc varchar2(72) := g_package||'convert_args';
225: --
226: Begin
227: --
228: hr_utility.set_location('Entering:'||l_proc, 5);
229: --
230: -- Convert arguments into local l_rec structure.
231: --
232: l_rec.net_calculation_rule_id := p_net_calculation_rule_id;

Line 242: hr_utility.set_location(' Leaving:'||l_proc, 10);

238: l_rec.object_version_number := p_object_version_number;
239: --
240: -- Return the plsql record structure.
241: --
242: hr_utility.set_location(' Leaving:'||l_proc, 10);
243: Return(l_rec);
244: --
245: End convert_args;
246: --