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.PQH_CTL_SHD dependencies on HR_UTILITY

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

16: --
17: l_proc varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: hr_utility.set_location('Entering:'||l_proc, 5);
21: --
22: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
23: hr_utility.set_message_token('PROCEDURE', l_proc);
24: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);

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

18: --
19: Begin
20: hr_utility.set_location('Entering:'||l_proc, 5);
21: --
22: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
23: hr_utility.set_message_token('PROCEDURE', l_proc);
24: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
25: hr_utility.raise_error;
26: --

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

19: Begin
20: hr_utility.set_location('Entering:'||l_proc, 5);
21: --
22: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
23: hr_utility.set_message_token('PROCEDURE', l_proc);
24: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
25: hr_utility.raise_error;
26: --
27: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

20: hr_utility.set_location('Entering:'||l_proc, 5);
21: --
22: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
23: hr_utility.set_message_token('PROCEDURE', l_proc);
24: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
25: hr_utility.raise_error;
26: --
27: hr_utility.set_location(' Leaving:'||l_proc, 10);
28: End constraint_error;

Line 25: hr_utility.raise_error;

21: --
22: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
23: hr_utility.set_message_token('PROCEDURE', l_proc);
24: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
25: hr_utility.raise_error;
26: --
27: hr_utility.set_location(' Leaving:'||l_proc, 10);
28: End constraint_error;
29: --

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

23: hr_utility.set_message_token('PROCEDURE', l_proc);
24: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
25: hr_utility.raise_error;
26: --
27: hr_utility.set_location(' Leaving:'||l_proc, 10);
28: End constraint_error;
29: --
30: -- ----------------------------------------------------------------------------
31: -- |-----------------------------< api_updating >-----------------------------|

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

52: l_proc varchar2(72) := g_package||'api_updating';
53: l_fct_ret boolean;
54: --
55: Begin
56: hr_utility.set_location('Entering:'||l_proc, 5);
57: --
58: If (
59: p_transaction_category_id is null or
60: p_language is null

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

68: If (
69: p_transaction_category_id = g_old_rec.transaction_category_id and
70: p_language = g_old_rec.language
71: ) Then
72: hr_utility.set_location(l_proc, 10);
73: --
74: -- The g_old_rec is current therefore we must
75: -- set the returning function to true
76: --

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

85: Close C_Sel1;
86: --
87: -- The primary key is invalid therefore we must error
88: --
89: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
90: hr_utility.raise_error;
91: End If;
92: Close C_Sel1;
93: --

Line 90: hr_utility.raise_error;

86: --
87: -- The primary key is invalid therefore we must error
88: --
89: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
90: hr_utility.raise_error;
91: End If;
92: Close C_Sel1;
93: --
94: hr_utility.set_location(l_proc, 15);

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

90: hr_utility.raise_error;
91: End If;
92: Close C_Sel1;
93: --
94: hr_utility.set_location(l_proc, 15);
95: l_fct_ret := true;
96: End If;
97: End If;
98: hr_utility.set_location(' Leaving:'||l_proc, 20);

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

94: hr_utility.set_location(l_proc, 15);
95: l_fct_ret := true;
96: End If;
97: End If;
98: hr_utility.set_location(' Leaving:'||l_proc, 20);
99: Return (l_fct_ret);
100: --
101: End api_updating;
102: --

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

123: --
124: l_proc varchar2(72) := g_package||'lck';
125: --
126: Begin
127: hr_utility.set_location('Entering:'||l_proc, 5);
128: --
129: -- Add any mandatory argument checking here:
130: -- Example:
131: -- hr_api.mandatory_arg_error

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

139: Close C_Sel1;
140: --
141: -- The primary key is invalid therefore we must error
142: --
143: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
144: hr_utility.raise_error;
145: End If;
146: Close C_Sel1;
147: --

Line 144: hr_utility.raise_error;

140: --
141: -- The primary key is invalid therefore we must error
142: --
143: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
144: hr_utility.raise_error;
145: End If;
146: Close C_Sel1;
147: --
148: --

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

145: End If;
146: Close C_Sel1;
147: --
148: --
149: hr_utility.set_location(' Leaving:'||l_proc, 10);
150: --
151: -- We need to trap the ORA LOCK exception
152: --
153: Exception

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

155: --
156: -- The object is locked therefore we need to supply a meaningful
157: -- error message.
158: --
159: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
160: hr_utility.set_message_token('TABLE_NAME', 'pqh_transaction_categories_tl');
161: hr_utility.raise_error;
162: End lck;
163: --

Line 160: hr_utility.set_message_token('TABLE_NAME', 'pqh_transaction_categories_tl');

156: -- The object is locked therefore we need to supply a meaningful
157: -- error message.
158: --
159: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
160: hr_utility.set_message_token('TABLE_NAME', 'pqh_transaction_categories_tl');
161: hr_utility.raise_error;
162: End lck;
163: --
164: -- ----------------------------------------------------------------------------

Line 161: hr_utility.raise_error;

157: -- error message.
158: --
159: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
160: hr_utility.set_message_token('TABLE_NAME', 'pqh_transaction_categories_tl');
161: hr_utility.raise_error;
162: End lck;
163: --
164: -- ----------------------------------------------------------------------------
165: -- |-----------------------------< convert_args >-----------------------------|

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

177: l_proc varchar2(72) := g_package||'convert_args';
178: --
179: Begin
180: --
181: hr_utility.set_location('Entering:'||l_proc, 5);
182: --
183: -- Convert arguments into local l_rec structure.
184: --
185: l_rec.transaction_category_id := p_transaction_category_id;

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

188: l_rec.source_lang := p_source_lang;
189: --
190: -- Return the plsql record structure.
191: --
192: hr_utility.set_location(' Leaving:'||l_proc, 10);
193: Return(l_rec);
194: --
195: End convert_args;
196: --