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

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

65: AND NVL(notified_name,'X') = NVL(p_notified_name,'X')
66: AND NVL(status,'X') <> 'SENT';
67: --
68: Begin
69: hr_utility.set_location('Entering:'||l_proc, 5);
70: p_rec.object_version_number := 1; -- Initialise the object version
71: --
72:
73: --

Line 85: hr_utility.set_location(' fyi_notified_id: '||p_rec.fyi_notified_id, 6);

81: FETCH csr_cnt_combo INTO l_count;
82:
83: CLOSE csr_cnt_combo;
84: --
85: hr_utility.set_location(' fyi_notified_id: '||p_rec.fyi_notified_id, 6);
86: hr_utility.set_location(' transaction_category_id: '||p_rec.transaction_category_id, 7);
87: hr_utility.set_location(' transaction_id: '||p_rec.transaction_id, 8);
88: hr_utility.set_location(' notification_event_cd: '||p_rec.notification_event_cd, 9);
89: hr_utility.set_location(' notified_type_cd: '||p_rec.notified_type_cd, 10);

Line 86: hr_utility.set_location(' transaction_category_id: '||p_rec.transaction_category_id, 7);

82:
83: CLOSE csr_cnt_combo;
84: --
85: hr_utility.set_location(' fyi_notified_id: '||p_rec.fyi_notified_id, 6);
86: hr_utility.set_location(' transaction_category_id: '||p_rec.transaction_category_id, 7);
87: hr_utility.set_location(' transaction_id: '||p_rec.transaction_id, 8);
88: hr_utility.set_location(' notification_event_cd: '||p_rec.notification_event_cd, 9);
89: hr_utility.set_location(' notified_type_cd: '||p_rec.notified_type_cd, 10);
90: hr_utility.set_location(' notified_name: '||p_rec.notified_name, 11);

Line 87: hr_utility.set_location(' transaction_id: '||p_rec.transaction_id, 8);

83: CLOSE csr_cnt_combo;
84: --
85: hr_utility.set_location(' fyi_notified_id: '||p_rec.fyi_notified_id, 6);
86: hr_utility.set_location(' transaction_category_id: '||p_rec.transaction_category_id, 7);
87: hr_utility.set_location(' transaction_id: '||p_rec.transaction_id, 8);
88: hr_utility.set_location(' notification_event_cd: '||p_rec.notification_event_cd, 9);
89: hr_utility.set_location(' notified_type_cd: '||p_rec.notified_type_cd, 10);
90: hr_utility.set_location(' notified_name: '||p_rec.notified_name, 11);
91: hr_utility.set_location(' notification_date: '||p_rec.notification_date, 12);

Line 88: hr_utility.set_location(' notification_event_cd: '||p_rec.notification_event_cd, 9);

84: --
85: hr_utility.set_location(' fyi_notified_id: '||p_rec.fyi_notified_id, 6);
86: hr_utility.set_location(' transaction_category_id: '||p_rec.transaction_category_id, 7);
87: hr_utility.set_location(' transaction_id: '||p_rec.transaction_id, 8);
88: hr_utility.set_location(' notification_event_cd: '||p_rec.notification_event_cd, 9);
89: hr_utility.set_location(' notified_type_cd: '||p_rec.notified_type_cd, 10);
90: hr_utility.set_location(' notified_name: '||p_rec.notified_name, 11);
91: hr_utility.set_location(' notification_date: '||p_rec.notification_date, 12);
92: hr_utility.set_location(' status: '||p_rec.status, 13);

Line 89: hr_utility.set_location(' notified_type_cd: '||p_rec.notified_type_cd, 10);

85: hr_utility.set_location(' fyi_notified_id: '||p_rec.fyi_notified_id, 6);
86: hr_utility.set_location(' transaction_category_id: '||p_rec.transaction_category_id, 7);
87: hr_utility.set_location(' transaction_id: '||p_rec.transaction_id, 8);
88: hr_utility.set_location(' notification_event_cd: '||p_rec.notification_event_cd, 9);
89: hr_utility.set_location(' notified_type_cd: '||p_rec.notified_type_cd, 10);
90: hr_utility.set_location(' notified_name: '||p_rec.notified_name, 11);
91: hr_utility.set_location(' notification_date: '||p_rec.notification_date, 12);
92: hr_utility.set_location(' status: '||p_rec.status, 13);
93: hr_utility.set_location(' object_version_number: '||p_rec.object_version_number, 14);

Line 90: hr_utility.set_location(' notified_name: '||p_rec.notified_name, 11);

86: hr_utility.set_location(' transaction_category_id: '||p_rec.transaction_category_id, 7);
87: hr_utility.set_location(' transaction_id: '||p_rec.transaction_id, 8);
88: hr_utility.set_location(' notification_event_cd: '||p_rec.notification_event_cd, 9);
89: hr_utility.set_location(' notified_type_cd: '||p_rec.notified_type_cd, 10);
90: hr_utility.set_location(' notified_name: '||p_rec.notified_name, 11);
91: hr_utility.set_location(' notification_date: '||p_rec.notification_date, 12);
92: hr_utility.set_location(' status: '||p_rec.status, 13);
93: hr_utility.set_location(' object_version_number: '||p_rec.object_version_number, 14);
94: hr_utility.set_location(' COUNT COMBO: '||l_count, 15);

Line 91: hr_utility.set_location(' notification_date: '||p_rec.notification_date, 12);

87: hr_utility.set_location(' transaction_id: '||p_rec.transaction_id, 8);
88: hr_utility.set_location(' notification_event_cd: '||p_rec.notification_event_cd, 9);
89: hr_utility.set_location(' notified_type_cd: '||p_rec.notified_type_cd, 10);
90: hr_utility.set_location(' notified_name: '||p_rec.notified_name, 11);
91: hr_utility.set_location(' notification_date: '||p_rec.notification_date, 12);
92: hr_utility.set_location(' status: '||p_rec.status, 13);
93: hr_utility.set_location(' object_version_number: '||p_rec.object_version_number, 14);
94: hr_utility.set_location(' COUNT COMBO: '||l_count, 15);
95: --

Line 92: hr_utility.set_location(' status: '||p_rec.status, 13);

88: hr_utility.set_location(' notification_event_cd: '||p_rec.notification_event_cd, 9);
89: hr_utility.set_location(' notified_type_cd: '||p_rec.notified_type_cd, 10);
90: hr_utility.set_location(' notified_name: '||p_rec.notified_name, 11);
91: hr_utility.set_location(' notification_date: '||p_rec.notification_date, 12);
92: hr_utility.set_location(' status: '||p_rec.status, 13);
93: hr_utility.set_location(' object_version_number: '||p_rec.object_version_number, 14);
94: hr_utility.set_location(' COUNT COMBO: '||l_count, 15);
95: --
96: --

Line 93: hr_utility.set_location(' object_version_number: '||p_rec.object_version_number, 14);

89: hr_utility.set_location(' notified_type_cd: '||p_rec.notified_type_cd, 10);
90: hr_utility.set_location(' notified_name: '||p_rec.notified_name, 11);
91: hr_utility.set_location(' notification_date: '||p_rec.notification_date, 12);
92: hr_utility.set_location(' status: '||p_rec.status, 13);
93: hr_utility.set_location(' object_version_number: '||p_rec.object_version_number, 14);
94: hr_utility.set_location(' COUNT COMBO: '||l_count, 15);
95: --
96: --
97: -- Insert the row into: pqh_fyi_notify ONLY if the row does not exists i.e l_count = 0

Line 94: hr_utility.set_location(' COUNT COMBO: '||l_count, 15);

90: hr_utility.set_location(' notified_name: '||p_rec.notified_name, 11);
91: hr_utility.set_location(' notification_date: '||p_rec.notification_date, 12);
92: hr_utility.set_location(' status: '||p_rec.status, 13);
93: hr_utility.set_location(' object_version_number: '||p_rec.object_version_number, 14);
94: hr_utility.set_location(' COUNT COMBO: '||l_count, 15);
95: --
96: --
97: -- Insert the row into: pqh_fyi_notify ONLY if the row does not exists i.e l_count = 0
98: --

Line 102: hr_utility.set_location('Inserting INTO pqh_fyi_notify ....',16);

98: --
99:
100: if NVL(l_count,0) = 0 THEN
101: --
102: hr_utility.set_location('Inserting INTO pqh_fyi_notify ....',16);
103:
104: insert into pqh_fyi_notify
105: ( fyi_notified_id,
106: transaction_category_id,

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

126:
127: --
128: end if;
129: --
130: hr_utility.set_location(' Leaving:'||l_proc, 20);
131: Exception
132: When hr_api.check_integrity_violated Then
133: -- A check constraint has been violated
134: pqh_fyn_shd.constraint_error

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

188: --
189: Cursor C_Sel1 is select pqh_fyi_notify_s.nextval from sys.dual;
190: --
191: Begin
192: hr_utility.set_location('Entering:'||l_proc, 5);
193: --
194: --
195: -- Select the next sequence number
196: --

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

197: Open C_Sel1;
198: Fetch C_Sel1 Into p_rec.fyi_notified_id;
199: Close C_Sel1;
200: --
201: hr_utility.set_location(' Leaving:'||l_proc, 10);
202: End pre_insert;
203: --
204: -- ----------------------------------------------------------------------------
205: -- |-----------------------------< post_insert >------------------------------|

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

238: --
239: l_proc varchar2(72) := g_package||'post_insert';
240: --
241: Begin
242: hr_utility.set_location('Entering:'||l_proc, 5);
243: --
244: --
245: -- Start of API User Hook for post_insert.
246: --

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

272: --
273: -- End of API User Hook for post_insert.
274: --
275: --
276: hr_utility.set_location(' Leaving:'||l_proc, 10);
277: End post_insert;
278: --
279: -- ----------------------------------------------------------------------------
280: -- |---------------------------------< ins >----------------------------------|

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

287: --
288: l_proc varchar2(72) := g_package||'ins';
289: --
290: Begin
291: hr_utility.set_location('Entering:'||l_proc, 5);
292: --
293: -- Call the supporting insert validate operations
294: --
295: pqh_fyn_bus.insert_validate(p_rec

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

329: l_rec pqh_fyn_shd.g_rec_type;
330: l_proc varchar2(72) := g_package||'ins';
331: --
332: Begin
333: hr_utility.set_location('Entering:'||l_proc, 5);
334: --
335: -- Call conversion function to turn arguments into the
336: -- p_rec structure.
337: --

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

360: --
361: p_fyi_notified_id := l_rec.fyi_notified_id;
362: p_object_version_number := l_rec.object_version_number;
363: --
364: hr_utility.set_location(' Leaving:'||l_proc, 10);
365: End ins;
366: --
367: end pqh_fyn_ins;