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

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

15: --
16: l_proc varchar2(72) := g_package||'constraint_error';
17: --
18: Begin
19: hr_utility.set_location('Entering:'||l_proc, 5);
20: --
21: If (p_constraint_name = 'HR_QUEST_ANSWERS_FK1') Then
22: fnd_message.set_name('PER', 'PER_52427_QSA_QU_TMPLT_INVALID');
23: fnd_message.raise_error;

Line 40: hr_utility.set_message('PER', 'HR_7877_API_INVALID_CONSTRAINT');

36: ElsIf (p_constraint_name = 'HR_QUEST_ANS_TYPE_CHK') Then
37: fnd_message.set_name('PER', 'PER_52429_QSA_INVAL_ANS_TYPE');
38: fnd_message.raise_error;
39: Else
40: hr_utility.set_message('PER', 'HR_7877_API_INVALID_CONSTRAINT');
41: hr_utility.set_message_token('PROCEDURE', l_proc);
42: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
43: hr_utility.raise_error;
44: End If;

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

37: fnd_message.set_name('PER', 'PER_52429_QSA_INVAL_ANS_TYPE');
38: fnd_message.raise_error;
39: Else
40: hr_utility.set_message('PER', 'HR_7877_API_INVALID_CONSTRAINT');
41: hr_utility.set_message_token('PROCEDURE', l_proc);
42: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
43: hr_utility.raise_error;
44: End If;
45: --

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

38: fnd_message.raise_error;
39: Else
40: hr_utility.set_message('PER', 'HR_7877_API_INVALID_CONSTRAINT');
41: hr_utility.set_message_token('PROCEDURE', l_proc);
42: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
43: hr_utility.raise_error;
44: End If;
45: --
46: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 43: hr_utility.raise_error;

39: Else
40: hr_utility.set_message('PER', 'HR_7877_API_INVALID_CONSTRAINT');
41: hr_utility.set_message_token('PROCEDURE', l_proc);
42: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
43: hr_utility.raise_error;
44: End If;
45: --
46: hr_utility.set_location(' Leaving:'||l_proc, 10);
47: End constraint_error;

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

42: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
43: hr_utility.raise_error;
44: End If;
45: --
46: hr_utility.set_location(' Leaving:'||l_proc, 10);
47: End constraint_error;
48: --
49: -- ----------------------------------------------------------------------------
50: -- |-----------------------------< api_updating >-----------------------------|

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

70: l_proc varchar2(72) := g_package||'api_updating';
71: l_fct_ret boolean;
72: --
73: Begin
74: hr_utility.set_location('Entering:'||l_proc, 5);
75: --
76: If (
77: p_questionnaire_answer_id is null
78: ) Then

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

84: Else
85: If (
86: p_questionnaire_answer_id = g_old_rec.questionnaire_answer_id
87: ) Then
88: hr_utility.set_location(l_proc, 10);
89: --
90: -- The g_old_rec is current therefore we must
91: -- set the returning function to true
92: --

Line 105: hr_utility.set_message('PER', 'HR_7220_INVALID_PRIMARY_KEY');

101: Close C_Sel1;
102: --
103: -- The primary key is invalid therefore we must error
104: --
105: hr_utility.set_message('PER', 'HR_7220_INVALID_PRIMARY_KEY');
106: hr_utility.raise_error;
107: End If;
108: Close C_Sel1;
109: --

Line 106: hr_utility.raise_error;

102: --
103: -- The primary key is invalid therefore we must error
104: --
105: hr_utility.set_message('PER', 'HR_7220_INVALID_PRIMARY_KEY');
106: hr_utility.raise_error;
107: End If;
108: Close C_Sel1;
109: --
110: hr_utility.set_location(l_proc, 15);

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

106: hr_utility.raise_error;
107: End If;
108: Close C_Sel1;
109: --
110: hr_utility.set_location(l_proc, 15);
111: l_fct_ret := true;
112: End If;
113: End If;
114: hr_utility.set_location(' Leaving:'||l_proc, 20);

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

110: hr_utility.set_location(l_proc, 15);
111: l_fct_ret := true;
112: End If;
113: End If;
114: hr_utility.set_location(' Leaving:'||l_proc, 20);
115: Return (l_fct_ret);
116: --
117: End api_updating;
118: --

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

138: --
139: l_proc varchar2(72) := g_package||'lck';
140: --
141: Begin
142: hr_utility.set_location('Entering:'||l_proc, 5);
143: --
144: -- Add any mandatory argument checking here:
145: -- Example:
146: -- hr_api.mandatory_arg_error

Line 163: hr_utility.set_message('PER', 'HR_7220_INVALID_PRIMARY_KEY');

159: Close C_Sel1;
160: --
161: -- The primary key is invalid therefore we must error
162: --
163: hr_utility.set_message('PER', 'HR_7220_INVALID_PRIMARY_KEY');
164: hr_utility.raise_error;
165: End If;
166: Close C_Sel1;
167: --

Line 164: hr_utility.raise_error;

160: --
161: -- The primary key is invalid therefore we must error
162: --
163: hr_utility.set_message('PER', 'HR_7220_INVALID_PRIMARY_KEY');
164: hr_utility.raise_error;
165: End If;
166: Close C_Sel1;
167: --
168: --

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

165: End If;
166: Close C_Sel1;
167: --
168: --
169: hr_utility.set_location(' Leaving:'||l_proc, 10);
170: --
171: -- We need to trap the ORA LOCK exception
172: --
173: Exception

Line 179: hr_utility.set_message('PER', 'HR_7165_OBJECT_LOCKED');

175: --
176: -- The object is locked therefore we need to supply a meaningful
177: -- error message.
178: --
179: hr_utility.set_message('PER', 'HR_7165_OBJECT_LOCKED');
180: hr_utility.set_message_token('TABLE_NAME', 'hr_quest_answers');
181: hr_utility.raise_error;
182: End lck;
183: --

Line 180: hr_utility.set_message_token('TABLE_NAME', 'hr_quest_answers');

176: -- The object is locked therefore we need to supply a meaningful
177: -- error message.
178: --
179: hr_utility.set_message('PER', 'HR_7165_OBJECT_LOCKED');
180: hr_utility.set_message_token('TABLE_NAME', 'hr_quest_answers');
181: hr_utility.raise_error;
182: End lck;
183: --
184: -- ----------------------------------------------------------------------------

Line 181: hr_utility.raise_error;

177: -- error message.
178: --
179: hr_utility.set_message('PER', 'HR_7165_OBJECT_LOCKED');
180: hr_utility.set_message_token('TABLE_NAME', 'hr_quest_answers');
181: hr_utility.raise_error;
182: End lck;
183: --
184: -- ----------------------------------------------------------------------------
185: -- |-----------------------------< convert_args >-----------------------------|

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

198: l_proc varchar2(72) := g_package||'convert_args';
199: --
200: Begin
201: --
202: hr_utility.set_location('Entering:'||l_proc, 5);
203: --
204: -- Convert arguments into local l_rec structure.
205: --
206: l_rec.questionnaire_answer_id := p_questionnaire_answer_id;

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

210: l_rec.business_group_id := p_business_group_id;
211: --
212: -- Return the plsql record structure.
213: --
214: hr_utility.set_location(' Leaving:'||l_proc, 10);
215: Return(l_rec);
216: --
217: End convert_args;
218: --