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.CSL_WF_NOTIFICATION_AT_ACC_PKG dependencies on JTM_HOOK_UTIL_PKG

Line 6: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=

2: /* $Header: cslwaacb.pls 115.16 2002/11/08 13:59:56 asiegers ship $ */
3:
4:
5: /*** Globals for notification attributes ***/
6: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
7: JTM_HOOK_UTIL_PKG.t_publication_item_list('WF_NOTIFICATION_ATTR');
8: g_publication_item_name2 CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
9: JTM_HOOK_UTIL_PKG.t_publication_item_list('WF_NOTIFICATIONS');
10:

Line 7: JTM_HOOK_UTIL_PKG.t_publication_item_list('WF_NOTIFICATION_ATTR');

3:
4:
5: /*** Globals for notification attributes ***/
6: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
7: JTM_HOOK_UTIL_PKG.t_publication_item_list('WF_NOTIFICATION_ATTR');
8: g_publication_item_name2 CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
9: JTM_HOOK_UTIL_PKG.t_publication_item_list('WF_NOTIFICATIONS');
10:
11: g_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_WF_NOTIFICATION_AT_ACC';

Line 8: g_publication_item_name2 CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=

4:
5: /*** Globals for notification attributes ***/
6: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
7: JTM_HOOK_UTIL_PKG.t_publication_item_list('WF_NOTIFICATION_ATTR');
8: g_publication_item_name2 CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
9: JTM_HOOK_UTIL_PKG.t_publication_item_list('WF_NOTIFICATIONS');
10:
11: g_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_WF_NOTIFICATION_AT_ACC';
12: g_acc_table_name2 CONSTANT VARCHAR2(30) := 'JTM_WF_NOTIFICATIONS_ACC';

Line 9: JTM_HOOK_UTIL_PKG.t_publication_item_list('WF_NOTIFICATIONS');

5: /*** Globals for notification attributes ***/
6: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
7: JTM_HOOK_UTIL_PKG.t_publication_item_list('WF_NOTIFICATION_ATTR');
8: g_publication_item_name2 CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
9: JTM_HOOK_UTIL_PKG.t_publication_item_list('WF_NOTIFICATIONS');
10:
11: g_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_WF_NOTIFICATION_AT_ACC';
12: g_acc_table_name2 CONSTANT VARCHAR2(30) := 'JTM_WF_NOTIFICATIONS_ACC';
13: g_table_name CONSTANT VARCHAR2(30) := 'WF_NOTIFICATION_ATTRIBUTES';

Line 97: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

93:
94: BEGIN
95:
96: /*** Execute necessary cursors before the notification attribute is checked and init vars. ***/
97: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
98: l_sender_user := True;
99: l_recipient_user := True;
100:
101: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

Line 101: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

97: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
98: l_sender_user := True;
99: l_recipient_user := True;
100:
101: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
102: jtm_message_log_pkg.Log_Msg
103: ( p_notification_id
104: , g_table_name
105: , 'Entering Procedure INSERT_NOTIFICATION_ATTRIBUTE'

Line 106: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

102: jtm_message_log_pkg.Log_Msg
103: ( p_notification_id
104: , g_table_name
105: , 'Entering Procedure INSERT_NOTIFICATION_ATTRIBUTE'
106: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
107: END IF;
108:
109: /*** First check if sender and recipient are fnd users. ***/
110: /*** Then check if sender and recipient are mobile resources. ***/

Line 117: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

113: OPEN c_get_sender ( p_notification_id );
114: FETCH c_get_sender INTO r_get_sender;
115:
116: IF c_get_sender%NOTFOUND THEN
117: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
118: jtm_message_log_pkg.Log_Msg
119: ( p_notification_id
120: , g_table_name
121: , 'Notification is not an open CS_MSGS/FYI_MESSAGE or sender user can not be found'

Line 122: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

118: jtm_message_log_pkg.Log_Msg
119: ( p_notification_id
120: , g_table_name
121: , 'Notification is not an open CS_MSGS/FYI_MESSAGE or sender user can not be found'
122: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
123: END IF;
124: l_sender_user := False;
125: END IF;
126: CLOSE c_get_sender;

Line 133: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

129: OPEN c_get_recipient ( p_notification_id );
130: FETCH c_get_recipient INTO r_get_recipient;
131:
132: IF c_get_recipient%NOTFOUND THEN
133: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
134: jtm_message_log_pkg.Log_Msg
135: ( p_notification_id
136: , g_table_name2
137: , 'Notification is not an open CS_MSGS/FYI_MESSAGE or recipient user can not be found'

Line 138: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

134: jtm_message_log_pkg.Log_Msg
135: ( p_notification_id
136: , g_table_name2
137: , 'Notification is not an open CS_MSGS/FYI_MESSAGE or recipient user can not be found'
138: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
139: END IF;
140: l_recipient_user := False;
141: END IF;
142: CLOSE c_get_recipient;

Line 150: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

146: OPEN c_get_user_resource (r_get_sender.user_id);
147: FETCH c_get_user_resource INTO r_get_sender_resource;
148:
149: IF c_get_user_resource%NOTFOUND THEN
150: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
151: jtm_message_log_pkg.Log_Msg
152: ( p_notification_id
153: , g_table_name
154: , 'Sender of notification is not a resource.'

Line 155: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

151: jtm_message_log_pkg.Log_Msg
152: ( p_notification_id
153: , g_table_name
154: , 'Sender of notification is not a resource.'
155: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
156: END IF;
157: /*** If sender is not a resource then it is also not a mobile resource ***/
158: l_sender_mobile_resource := False;
159: ELSE

Line 161: l_sender_mobile_resource := JTM_HOOK_UTIL_PKG.isMobileFSresource(r_get_sender_resource.resource_id);

157: /*** If sender is not a resource then it is also not a mobile resource ***/
158: l_sender_mobile_resource := False;
159: ELSE
160: /*** Check if sender is a mobile resource ***/
161: l_sender_mobile_resource := JTM_HOOK_UTIL_PKG.isMobileFSresource(r_get_sender_resource.resource_id);
162: END IF;
163: CLOSE c_get_user_resource;
164: ELSE
165: /*** If sender is not a user then it cannot be a resource and also not a mobile resource ***/

Line 175: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

171: OPEN c_get_user_resource (r_get_recipient.user_id);
172: FETCH c_get_user_resource INTO r_get_recipient_resource;
173:
174: IF c_get_user_resource%NOTFOUND THEN
175: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
176: jtm_message_log_pkg.Log_Msg
177: ( p_notification_id
178: , g_table_name
179: , 'Recipient of notification is not a resource.'

Line 180: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

176: jtm_message_log_pkg.Log_Msg
177: ( p_notification_id
178: , g_table_name
179: , 'Recipient of notification is not a resource.'
180: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
181: END IF;
182: /*** If recipient is not a resource then it is also not a mobile resource ***/
183: l_recipient_mobile_resource := False;
184: ELSE

Line 186: l_recipient_mobile_resource := JTM_HOOK_UTIL_PKG.isMobileFSresource(r_get_recipient_resource.resource_id);

182: /*** If recipient is not a resource then it is also not a mobile resource ***/
183: l_recipient_mobile_resource := False;
184: ELSE
185: /*** Check if recipient is a mobile resource ***/
186: l_recipient_mobile_resource := JTM_HOOK_UTIL_PKG.isMobileFSresource(r_get_recipient_resource.resource_id);
187: END IF;
188: CLOSE c_get_user_resource;
189: ELSE
190: /*** If recipient is not a user then it cannot be a resource and also not a mobile resource ***/

Line 213: JTM_HOOK_UTIL_PKG.Delete_Acc

209: /*** Specific code for Attribute Name = 'DELETE_FLAG' ***/
210: IF p_name = 'DELETE_FLAG' THEN
211: IF l_recipient_mobile_resource THEN
212: /*** Delete notification id for recipient from Notification ACC table. ***/
213: JTM_HOOK_UTIL_PKG.Delete_Acc
214: ( p_publication_item_names => g_publication_item_name2
215: , p_acc_table_name => g_acc_table_name2
216: , p_pk1_name => g_pk1_name
217: , p_pk1_num_value => p_notification_id

Line 221: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

217: , p_pk1_num_value => p_notification_id
218: , p_resource_id => r_get_recipient_resource.resource_id
219: );
220:
221: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
222: jtm_message_log_pkg.Log_Msg
223: ( p_notification_id
224: , g_table_name2
225: , 'Deleted recipient notification id from Notification Attribute ACC table.'

Line 226: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

222: jtm_message_log_pkg.Log_Msg
223: ( p_notification_id
224: , g_table_name2
225: , 'Deleted recipient notification id from Notification Attribute ACC table.'
226: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
227: END IF;
228:
229: /* Delete all attributes of notification id of recipient from Notification Attribute ACC table. */
230: /* Retrieve all attributes, loop through them and call JTM_HOOK_UTIL_PKG.Delete_Acc for all attributes.*/

Line 230: /* Retrieve all attributes, loop through them and call JTM_HOOK_UTIL_PKG.Delete_Acc for all attributes.*/

226: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
227: END IF;
228:
229: /* Delete all attributes of notification id of recipient from Notification Attribute ACC table. */
230: /* Retrieve all attributes, loop through them and call JTM_HOOK_UTIL_PKG.Delete_Acc for all attributes.*/
231: OPEN c_recipient_attr(p_notification_id, r_get_recipient_resource.resource_id);
232: FETCH c_recipient_attr INTO r_recipient_attr;
233: IF c_recipient_attr%NOTFOUND THEN
234: /*** could not find any notification attribute records to be deleted ***/

Line 235: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

231: OPEN c_recipient_attr(p_notification_id, r_get_recipient_resource.resource_id);
232: FETCH c_recipient_attr INTO r_recipient_attr;
233: IF c_recipient_attr%NOTFOUND THEN
234: /*** could not find any notification attribute records to be deleted ***/
235: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
236: jtm_message_log_pkg.Log_Msg
237: ( p_notification_id
238: , g_table_name
239: , 'Did not find any Notification Attribute records to be deleted for recipient.'

Line 240: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

236: jtm_message_log_pkg.Log_Msg
237: ( p_notification_id
238: , g_table_name
239: , 'Did not find any Notification Attribute records to be deleted for recipient.'
240: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
241: END IF;
242: CLOSE c_recipient_attr;
243: ELSE
244: /*** Loop over all available records and delete them from the Notification Attribute ACC table ***/

Line 246: /* Call delete function of JTM_HOOK_UTIL_PKG to delete records from the ACC table */

242: CLOSE c_recipient_attr;
243: ELSE
244: /*** Loop over all available records and delete them from the Notification Attribute ACC table ***/
245: WHILE c_recipient_attr%FOUND LOOP
246: /*** Call delete function of JTM_HOOK_UTIL_PKG to delete records from the ACC table ***/
247: JTM_HOOK_UTIL_PKG.Delete_Acc
248: ( p_publication_item_names => g_publication_item_name
249: , p_acc_table_name => g_acc_table_name
250: , p_pk1_name => g_pk1_name

Line 247: JTM_HOOK_UTIL_PKG.Delete_Acc

243: ELSE
244: /*** Loop over all available records and delete them from the Notification Attribute ACC table ***/
245: WHILE c_recipient_attr%FOUND LOOP
246: /*** Call delete function of JTM_HOOK_UTIL_PKG to delete records from the ACC table ***/
247: JTM_HOOK_UTIL_PKG.Delete_Acc
248: ( p_publication_item_names => g_publication_item_name
249: , p_acc_table_name => g_acc_table_name
250: , p_pk1_name => g_pk1_name
251: , p_pk1_num_value => p_notification_id

Line 261: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

257: FETCH c_recipient_attr INTO r_recipient_attr;
258: END LOOP;
259: CLOSE c_recipient_attr;
260:
261: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
262: jtm_message_log_pkg.Log_Msg
263: ( p_notification_id
264: , g_table_name
265: , 'Deleted all records for recipient from Notification Attribute ACC table.'

Line 266: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

262: jtm_message_log_pkg.Log_Msg
263: ( p_notification_id
264: , g_table_name
265: , 'Deleted all records for recipient from Notification Attribute ACC table.'
266: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
267: END IF;
268: END IF;
269: ELSE
270: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

Line 270: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

266: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
267: END IF;
268: END IF;
269: ELSE
270: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
271: jtm_message_log_pkg.Log_Msg
272: ( p_notification_id
273: , g_table_name
274: , 'Recipient of notification is not a Mobile Resource: No deletion of notification from ACC table.'

Line 275: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

271: jtm_message_log_pkg.Log_Msg
272: ( p_notification_id
273: , g_table_name
274: , 'Recipient of notification is not a Mobile Resource: No deletion of notification from ACC table.'
275: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
276: END IF;
277: END IF;
278: END IF;
279:

Line 291: JTM_HOOK_UTIL_PKG.Insert_Acc

287: OR ( p_name = 'SUBJECT'))
288: AND l_sender_mobile_resource) THEN
289:
290: /*** Do an insert into ACC table for sender of notification attribute ***/
291: JTM_HOOK_UTIL_PKG.Insert_Acc
292: ( p_publication_item_names => g_publication_item_name
293: , p_acc_table_name => g_acc_table_name
294: , p_pk1_name => g_pk1_name
295: , p_pk1_num_value => p_notification_id

Line 301: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

297: , p_pk2_char_value => p_name
298: , p_resource_id => r_get_sender_resource.resource_id
299: );
300:
301: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
302: jtm_message_log_pkg.Log_Msg
303: ( p_notification_id
304: , g_table_name
305: , 'Inserted attributes for sender notification ' || p_notification_id|| ' + ' || p_name

Line 306: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

302: jtm_message_log_pkg.Log_Msg
303: ( p_notification_id
304: , g_table_name
305: , 'Inserted attributes for sender notification ' || p_notification_id|| ' + ' || p_name
306: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
307: END IF;
308: END IF;
309:
310:

Line 321: JTM_HOOK_UTIL_PKG.Insert_Acc

317: OR (p_name = 'PRIORITY'))
318: AND l_recipient_mobile_resource) THEN
319:
320: /*** Insert recipient notification id and name into Notification Attribute ACC table. ***/
321: JTM_HOOK_UTIL_PKG.Insert_Acc
322: ( p_publication_item_names => g_publication_item_name
323: , p_acc_table_name => g_acc_table_name
324: , p_pk1_name => g_pk1_name
325: , p_pk1_num_value => p_notification_id

Line 331: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

327: , p_pk2_char_value => p_name
328: , p_resource_id => r_get_recipient_resource.resource_id
329: );
330:
331: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
332: jtm_message_log_pkg.Log_Msg
333: ( p_notification_id
334: , g_table_name
335: , 'Inserted recipient notification id and name into Notification Attribute ACC table.'

Line 336: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

332: jtm_message_log_pkg.Log_Msg
333: ( p_notification_id
334: , g_table_name
335: , 'Inserted recipient notification id and name into Notification Attribute ACC table.'
336: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
337: END IF;
338: END IF;
339:
340: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

Line 340: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

336: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
337: END IF;
338: END IF;
339:
340: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
341: jtm_message_log_pkg.LOG_MSG
342: ( p_notification_id
343: , g_table_name
344: , 'Leaving Procedure INSERT_NOTIFICATION_ATTRIBUTE'

Line 345: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

341: jtm_message_log_pkg.LOG_MSG
342: ( p_notification_id
343: , g_table_name
344: , 'Leaving Procedure INSERT_NOTIFICATION_ATTRIBUTE'
345: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
346: END IF;
347: END INSERT_NOTIFICATION_ATTRIBUTE;
348:
349: /******/

Line 416: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

412: l_return_value VARCHAR2(2000) := FND_API.G_RET_STS_SUCCESS;
413:
414: BEGIN
415:
416: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
417:
418: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
419: jtm_message_log_pkg.Log_Msg
420: ( v_object_id => p_resource_id

Line 418: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

414: BEGIN
415:
416: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
417:
418: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
419: jtm_message_log_pkg.Log_Msg
420: ( v_object_id => p_resource_id
421: , v_object_name => g_table_name
422: , v_message => 'Entering Insert_All_ACC_Records procedure for user: ' || p_resource_id

Line 423: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

419: jtm_message_log_pkg.Log_Msg
420: ( v_object_id => p_resource_id
421: , v_object_name => g_table_name
422: , v_message => 'Entering Insert_All_ACC_Records procedure for user: ' || p_resource_id
423: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
424: END IF;
425: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
426:
427: jtm_message_log_pkg.Log_Msg

Line 425: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

421: , v_object_name => g_table_name
422: , v_message => 'Entering Insert_All_ACC_Records procedure for user: ' || p_resource_id
423: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
424: END IF;
425: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
426:
427: jtm_message_log_pkg.Log_Msg
428: ( v_object_id => p_resource_id
429: , v_object_name => g_table_name

Line 432: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

428: ( v_object_id => p_resource_id
429: , v_object_name => g_table_name
430: , v_message => 'Insert all Notification acc and Notification Attributes ACC records for user: '||
431: p_resource_id
432: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
433: END IF;
434:
435: IF JTM_HOOK_UTIL_PKG.isMobileFSresource( p_resource_id ) THEN
436: /*** First insert the send records of a mobile user ***/

Line 435: IF JTM_HOOK_UTIL_PKG.isMobileFSresource( p_resource_id ) THEN

431: p_resource_id
432: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
433: END IF;
434:
435: IF JTM_HOOK_UTIL_PKG.isMobileFSresource( p_resource_id ) THEN
436: /*** First insert the send records of a mobile user ***/
437: OPEN c_notification_sender ( p_resource_id );
438: FETCH c_notification_sender INTO r_notification_sender;
439: IF c_notification_sender%NOTFOUND THEN

Line 440: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

436: /*** First insert the send records of a mobile user ***/
437: OPEN c_notification_sender ( p_resource_id );
438: FETCH c_notification_sender INTO r_notification_sender;
439: IF c_notification_sender%NOTFOUND THEN
440: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
441: jtm_message_log_pkg.Log_Msg
442: ( v_object_id => p_resource_id
443: , v_object_name => g_table_name
444: , v_message => 'Insert all Notification ACC: no send-records found for user: ' || p_resource_id

Line 445: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

441: jtm_message_log_pkg.Log_Msg
442: ( v_object_id => p_resource_id
443: , v_object_name => g_table_name
444: , v_message => 'Insert all Notification ACC: no send-records found for user: ' || p_resource_id
445: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
446: END IF;
447: ELSE
448: WHILE c_notification_sender%FOUND LOOP
449: CSL_WF_NOTIFICATIONS_ACC_PKG.Insert_Notification(r_notification_sender.notification_id);

Line 453: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

449: CSL_WF_NOTIFICATIONS_ACC_PKG.Insert_Notification(r_notification_sender.notification_id);
450: OPEN c_get_attribute_name ( r_notification_sender.notification_id );
451: FETCH c_get_attribute_name INTO r_get_attribute_name;
452: IF c_get_attribute_name%NOTFOUND THEN
453: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
454: jtm_message_log_pkg.Log_Msg
455: ( v_object_id => p_resource_id
456: , v_object_name => g_table_name
457: , v_message => 'No Attributes records found for notification: ' ||

Line 459: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

455: ( v_object_id => p_resource_id
456: , v_object_name => g_table_name
457: , v_message => 'No Attributes records found for notification: ' ||
458: r_notification_sender.notification_id
459: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
460: END IF;
461: ELSE
462: WHILE c_get_attribute_name%FOUND LOOP
463: Insert_Notification_Attribute(r_notification_sender.notification_id,r_get_attribute_name.name);

Line 477: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

473: /*** Second insert all received records ***/
474: OPEN c_notification_receive ( p_resource_id );
475: FETCH c_notification_receive INTO r_notification_receive;
476: IF c_notification_receive%NOTFOUND THEN
477: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
478: jtm_message_log_pkg.Log_Msg
479: ( v_object_id => p_resource_id
480: , v_object_name => g_table_name
481: , v_message => 'No received records found for user : ' || p_resource_id

Line 482: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

478: jtm_message_log_pkg.Log_Msg
479: ( v_object_id => p_resource_id
480: , v_object_name => g_table_name
481: , v_message => 'No received records found for user : ' || p_resource_id
482: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
483: END IF;
484: ELSE
485: WHILE c_notification_receive%FOUND LOOP
486: CSL_WF_NOTIFICATIONS_ACC_PKG.Insert_Notification(r_notification_receive.notification_id);

Line 490: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

486: CSL_WF_NOTIFICATIONS_ACC_PKG.Insert_Notification(r_notification_receive.notification_id);
487: OPEN c_get_attribute_name ( r_notification_receive.notification_id );
488: FETCH c_get_attribute_name INTO r_get_attribute_name;
489: IF c_get_attribute_name%NOTFOUND THEN
490: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
491: jtm_message_log_pkg.Log_Msg
492: ( v_object_id => p_resource_id
493: , v_object_name => g_table_name
494: , v_message => 'No received Notification Attributes records found for notification: '||

Line 496: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

492: ( v_object_id => p_resource_id
493: , v_object_name => g_table_name
494: , v_message => 'No received Notification Attributes records found for notification: '||
495: r_notification_receive.notification_id
496: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
497: END IF;
498: ELSE
499: WHILE c_get_attribute_name%FOUND LOOP
500: Insert_Notification_Attribute(r_notification_receive.notification_id,r_get_attribute_name.name);

Line 512: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

508: END IF;
509: l_return_value := FND_API.G_RET_STS_SUCCESS;
510: END IF;
511:
512: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
513: jtm_message_log_pkg.Log_Msg
514: ( v_object_id => p_resource_id
515: , v_object_name => g_table_name
516: , v_message => 'Leaving Insert_All_ACC_Records procedure for user: ' || p_resource_id

Line 517: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

513: jtm_message_log_pkg.Log_Msg
514: ( v_object_id => p_resource_id
515: , v_object_name => g_table_name
516: , v_message => 'Leaving Insert_All_ACC_Records procedure for user: ' || p_resource_id
517: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
518: END IF;
519:
520: x_return_status := l_return_value;
521: EXCEPTION WHEN OTHERS THEN

Line 576: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

572: l_return_value VARCHAR2(2000) := FND_API.G_RET_STS_SUCCESS;
573:
574: BEGIN
575: /*Get the debug level*/
576: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
577:
578: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
579: jtm_message_log_pkg.Log_Msg
580: ( v_object_id => p_resource_id

Line 578: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

574: BEGIN
575: /*Get the debug level*/
576: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
577:
578: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
579: jtm_message_log_pkg.Log_Msg
580: ( v_object_id => p_resource_id
581: , v_object_name => g_table_name
582: , v_message => 'Entering Delete_All_ACC_Records procedure for user: ' || p_resource_id

Line 583: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

579: jtm_message_log_pkg.Log_Msg
580: ( v_object_id => p_resource_id
581: , v_object_name => g_table_name
582: , v_message => 'Entering Delete_All_ACC_Records procedure for user: ' || p_resource_id
583: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
584: END IF;
585:
586: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
587: jtm_message_log_pkg.Log_Msg

Line 586: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

582: , v_message => 'Entering Delete_All_ACC_Records procedure for user: ' || p_resource_id
583: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
584: END IF;
585:
586: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
587: jtm_message_log_pkg.Log_Msg
588: ( v_object_id => p_resource_id
589: , v_object_name => g_table_name
590: , v_message => 'Delete all Notification acc and Notification Attributes ACC records for user: '||

Line 592: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

588: ( v_object_id => p_resource_id
589: , v_object_name => g_table_name
590: , v_message => 'Delete all Notification acc and Notification Attributes ACC records for user: '||
591: p_resource_id
592: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
593: END IF;
594:
595: IF JTM_HOOK_UTIL_PKG.isMobileFSresource( p_resource_id ) THEN
596: /*** First delete the send records of a mobile user ***/

Line 595: IF JTM_HOOK_UTIL_PKG.isMobileFSresource( p_resource_id ) THEN

591: p_resource_id
592: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
593: END IF;
594:
595: IF JTM_HOOK_UTIL_PKG.isMobileFSresource( p_resource_id ) THEN
596: /*** First delete the send records of a mobile user ***/
597: OPEN c_notification_sender ( p_resource_id );
598: FETCH c_notification_sender INTO r_notification_sender;
599: IF c_notification_sender%NOTFOUND THEN

Line 600: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

596: /*** First delete the send records of a mobile user ***/
597: OPEN c_notification_sender ( p_resource_id );
598: FETCH c_notification_sender INTO r_notification_sender;
599: IF c_notification_sender%NOTFOUND THEN
600: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
601: jtm_message_log_pkg.Log_Msg
602: ( v_object_id => p_resource_id
603: , v_object_name => g_table_name
604: , v_message => 'No sent record found for user: ' || p_resource_id

Line 605: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

601: jtm_message_log_pkg.Log_Msg
602: ( v_object_id => p_resource_id
603: , v_object_name => g_table_name
604: , v_message => 'No sent record found for user: ' || p_resource_id
605: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
606: END IF;
607: ELSE
608: WHILE c_notification_sender%FOUND LOOP
609: JTM_HOOK_UTIL_PKG.Delete_Acc

Line 609: JTM_HOOK_UTIL_PKG.Delete_Acc

605: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
606: END IF;
607: ELSE
608: WHILE c_notification_sender%FOUND LOOP
609: JTM_HOOK_UTIL_PKG.Delete_Acc
610: ( p_publication_item_names => g_publication_item_name
611: ,p_acc_table_name => g_acc_table_name2
612: ,p_pk1_name => g_pk1_name
613: ,p_pk1_num_value => r_notification_sender.notification_id

Line 622: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

618:
619: OPEN c_get_attribute_name ( r_notification_sender.notification_id );
620: FETCH c_get_attribute_name INTO r_get_attribute_name;
621: IF c_get_attribute_name%NOTFOUND THEN
622: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
623: jtm_message_log_pkg.Log_Msg
624: ( v_object_id => p_resource_id
625: , v_object_name => g_table_name
626: , v_message => 'No notification attributes found for notification: ' ||

Line 628: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

624: ( v_object_id => p_resource_id
625: , v_object_name => g_table_name
626: , v_message => 'No notification attributes found for notification: ' ||
627: r_notification_sender.notification_id
628: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
629: END IF;
630: ELSE
631: WHILE c_get_attribute_name%FOUND LOOP
632: JTM_HOOK_UTIL_PKG.Delete_Acc

Line 632: JTM_HOOK_UTIL_PKG.Delete_Acc

628: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
629: END IF;
630: ELSE
631: WHILE c_get_attribute_name%FOUND LOOP
632: JTM_HOOK_UTIL_PKG.Delete_Acc
633: ( p_publication_item_names => g_publication_item_name
634: , p_acc_table_name => g_acc_table_name
635: , p_pk1_name => g_pk1_name
636: , p_pk1_num_value => r_notification_sender.notification_id

Line 654: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

650: /*** Second Delete all received records ***/
651: OPEN c_notification_receive ( p_resource_id );
652: FETCH c_notification_receive INTO r_notification_receive;
653: IF c_notification_receive%NOTFOUND THEN
654: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
655: jtm_message_log_pkg.Log_Msg
656: ( v_object_id => p_resource_id
657: , v_object_name => g_table_name
658: , v_message => 'No received records found for user: ' || p_resource_id

Line 659: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

655: jtm_message_log_pkg.Log_Msg
656: ( v_object_id => p_resource_id
657: , v_object_name => g_table_name
658: , v_message => 'No received records found for user: ' || p_resource_id
659: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
660: END IF;
661: ELSE
662: WHILE c_notification_receive%FOUND LOOP
663: JTM_HOOK_UTIL_PKG.Delete_Acc

Line 663: JTM_HOOK_UTIL_PKG.Delete_Acc

659: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
660: END IF;
661: ELSE
662: WHILE c_notification_receive%FOUND LOOP
663: JTM_HOOK_UTIL_PKG.Delete_Acc
664: ( p_publication_item_names => g_publication_item_name
665: , p_acc_table_name => g_acc_table_name2
666: , p_pk1_name => g_pk1_name
667: , p_pk1_num_value => r_notification_receive.notification_id

Line 676: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

672:
673: OPEN c_get_attribute_name ( r_notification_receive.notification_id );
674: FETCH c_get_attribute_name INTO r_get_attribute_name;
675: IF c_get_attribute_name%NOTFOUND THEN
676: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
677: jtm_message_log_pkg.Log_Msg
678: ( v_object_id => p_resource_id
679: , v_object_name => g_table_name
680: , v_message => 'No attributes found for notification ' ||

Line 682: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

678: ( v_object_id => p_resource_id
679: , v_object_name => g_table_name
680: , v_message => 'No attributes found for notification ' ||
681: r_notification_receive.notification_id
682: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
683: END IF;
684: ELSE
685: WHILE c_get_attribute_name%FOUND LOOP
686: JTM_HOOK_UTIL_PKG.Delete_Acc

Line 686: JTM_HOOK_UTIL_PKG.Delete_Acc

682: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
683: END IF;
684: ELSE
685: WHILE c_get_attribute_name%FOUND LOOP
686: JTM_HOOK_UTIL_PKG.Delete_Acc
687: ( p_publication_item_names => g_publication_item_name
688: , p_acc_table_name => g_acc_table_name
689: , p_pk1_name => g_pk1_name
690: , p_pk1_num_value => r_notification_receive.notification_id

Line 706: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

702: l_return_value := FND_API.G_RET_STS_SUCCESS;
703: END IF;
704: END IF;
705:
706: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
707: jtm_message_log_pkg.Log_Msg
708: ( v_object_id => p_resource_id
709: , v_object_name => g_table_name
710: , v_message => 'Leaving Delete_All_ACC_Records procedure for user: ' || p_resource_id

Line 711: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

707: jtm_message_log_pkg.Log_Msg
708: ( v_object_id => p_resource_id
709: , v_object_name => g_table_name
710: , v_message => 'Leaving Delete_All_ACC_Records procedure for user: ' || p_resource_id
711: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
712: END IF;
713:
714: x_return_status := l_return_value;
715: EXCEPTION WHEN OTHERS THEN

Line 721: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

717: jtm_message_log_pkg.Log_Msg
718: ( v_object_id => p_resource_id
719: , v_object_name => g_table_name
720: , v_message => 'Error occurred in Delete_All_ACC_Records'||sqlerrm
721: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
722: fnd_msg_pub.Add_Exc_Msg('CSL_WF_NOTIFICATION_AT_ACC_PKG','Delete_All_ACC_Records',sqlerrm);
723: -- x_return_status := FND_API.G_RET_STS_ERROR;
724: x_return_status := FND_API.G_RET_STS_SUCCESS;
725: