APPS.CSL_CSI_ITEM_INSTANCES_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: csliiacb.pls 120.0 2005/05/25 11:05:37 appldev noship $ */
3:
4: /*** Globals ***/
5: g_acc_table_name CONSTANT VARCHAR2(30) := 'CSL_CSI_ITEM_INSTANCES_ACC';
6: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
7: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_CSI_ITEM_INSTANCES');
8: g_table_name CONSTANT VARCHAR2(30) := 'CSI_ITEM_INSTANCES';
9: g_pk1_name CONSTANT VARCHAR2(30) := 'INSTANCE_ID';
10: g_debug_level NUMBER; -- debug level

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

3:
4: /*** Globals ***/
5: g_acc_table_name CONSTANT VARCHAR2(30) := 'CSL_CSI_ITEM_INSTANCES_ACC';
6: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
7: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_CSI_ITEM_INSTANCES');
8: g_table_name CONSTANT VARCHAR2(30) := 'CSI_ITEM_INSTANCES';
9: g_pk1_name CONSTANT VARCHAR2(30) := 'INSTANCE_ID';
10: g_debug_level NUMBER; -- debug level
11: g_resource_id_list dbms_sql.Number_Table; -- list of resource to which an item instance should be replicated

Line 32: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

28: WHERE instance_id = b_instance_id;
29: r_item_instance c_item_instance%ROWTYPE;
30: BEGIN
31: /*** get debug level ***/
32: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
33:
34: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
35: jtm_message_log_pkg.Log_Msg
36: ( p_instance_id

Line 34: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

30: BEGIN
31: /*** get debug level ***/
32: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
33:
34: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
35: jtm_message_log_pkg.Log_Msg
36: ( p_instance_id
37: , g_table_name
38: , 'Entering Replicate_Record'

Line 39: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

35: jtm_message_log_pkg.Log_Msg
36: ( p_instance_id
37: , g_table_name
38: , 'Entering Replicate_Record'
39: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
40: END IF;
41:
42: /*** is resource a mobile user? ***/
43: IF NOT JTM_HOOK_UTIL_PKG.isMobileFSresource( p_resource_id ) THEN

Line 43: IF NOT JTM_HOOK_UTIL_PKG.isMobileFSresource( p_resource_id ) THEN

39: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
40: END IF;
41:
42: /*** is resource a mobile user? ***/
43: IF NOT JTM_HOOK_UTIL_PKG.isMobileFSresource( p_resource_id ) THEN
44: /*** No -> exit ***/
45: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
46: jtm_message_log_pkg.Log_Msg
47: ( p_instance_id

Line 45: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

41:
42: /*** is resource a mobile user? ***/
43: IF NOT JTM_HOOK_UTIL_PKG.isMobileFSresource( p_resource_id ) THEN
44: /*** No -> exit ***/
45: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
46: jtm_message_log_pkg.Log_Msg
47: ( p_instance_id
48: , g_table_name
49: , 'Replicate_Record returned FALSE' || fnd_global.local_chr(10) ||

Line 51: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

47: ( p_instance_id
48: , g_table_name
49: , 'Replicate_Record returned FALSE' || fnd_global.local_chr(10) ||
50: 'Resource_id ' || p_resource_id || ' is not a mobile user.'
51: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
52: END IF;
53:
54: RETURN FALSE;
55: END IF;

Line 62: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

58: OPEN c_item_instance( p_instance_id );
59: FETCH c_item_instance INTO r_item_instance;
60: IF c_item_instance%NOTFOUND THEN
61: /*** could not find item instance record -> exit ***/
62: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
63: jtm_message_log_pkg.Log_Msg
64: ( p_instance_id
65: , g_table_name
66: , 'Replicate_Record error: Could not find instance_id ' || p_instance_id

Line 67: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

63: jtm_message_log_pkg.Log_Msg
64: ( p_instance_id
65: , g_table_name
66: , 'Replicate_Record error: Could not find instance_id ' || p_instance_id
67: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
68: END IF;
69:
70: CLOSE c_item_instance;
71: RETURN FALSE;

Line 75: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

71: RETURN FALSE;
72: END IF;
73: CLOSE c_item_instance;
74:
75: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
76: jtm_message_log_pkg.Log_Msg
77: ( p_instance_id
78: , g_table_name
79: , 'Replicate_Record returned TRUE'

Line 80: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

76: jtm_message_log_pkg.Log_Msg
77: ( p_instance_id
78: , g_table_name
79: , 'Replicate_Record returned TRUE'
80: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
81: END IF;
82:
83: /** Record matched criteria -> return true ***/
84: RETURN TRUE;

Line 144: l_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=

140: from CSL_CSI_ITEM_ATTR_ACC
141: where ATTRIBUTE_VALUE_ID NOT IN (SELECT ATTRIBUTE_VALUE_ID from CSI_IEA_VALUES)
142: */
143:
144: l_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
145: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_CSI_ITEM_ATTR');
146: l_acc_table_name CONSTANT VARCHAR2(30) := 'CSL_CSI_ITEM_ATTR_ACC';
147: l_pk1_name CONSTANT VARCHAR2(30) := 'ATTRIBUTE_VALUE_ID';
148: l_table_name CONSTANT VARCHAR2(30) := 'CSL_CSI_ITEM_ATTR';

Line 145: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_CSI_ITEM_ATTR');

141: where ATTRIBUTE_VALUE_ID NOT IN (SELECT ATTRIBUTE_VALUE_ID from CSI_IEA_VALUES)
142: */
143:
144: l_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
145: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_CSI_ITEM_ATTR');
146: l_acc_table_name CONSTANT VARCHAR2(30) := 'CSL_CSI_ITEM_ATTR_ACC';
147: l_pk1_name CONSTANT VARCHAR2(30) := 'ATTRIBUTE_VALUE_ID';
148: l_table_name CONSTANT VARCHAR2(30) := 'CSL_CSI_ITEM_ATTR';
149:

Line 153: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

149:
150: l_current_run_date date;
151: BEGIN
152:
153: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
154: jtm_message_log_pkg.Log_Msg
155: ( 0
156: , l_table_name
157: , 'Entering Insert_Item_Attr'

Line 158: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

154: jtm_message_log_pkg.Log_Msg
155: ( 0
156: , l_table_name
157: , 'Entering Insert_Item_Attr'
158: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
159: END IF;
160:
161: /*** First retrieve last run date of the conccurent program ***/
162: OPEN c_LastRundate;

Line 172: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

168: --INSERT
169: FOR r_insert_diffs in c_insert_diffs(r_LastRundate.LAST_RUN_DATE)
170: LOOP
171:
172: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
173: jtm_message_log_pkg.Log_Msg
174: ( 0
175: , l_table_name
176: , 'Inserting ACC record for resource_id = ' || r_insert_diffs.resource_id

Line 177: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

173: jtm_message_log_pkg.Log_Msg
174: ( 0
175: , l_table_name
176: , 'Inserting ACC record for resource_id = ' || r_insert_diffs.resource_id
177: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
178: END IF;
179:
180: JTM_HOOK_UTIL_PKG.Insert_Acc
181: ( P_PUBLICATION_ITEM_NAMES => l_publication_item_name

Line 180: JTM_HOOK_UTIL_PKG.Insert_Acc

176: , 'Inserting ACC record for resource_id = ' || r_insert_diffs.resource_id
177: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
178: END IF;
179:
180: JTM_HOOK_UTIL_PKG.Insert_Acc
181: ( P_PUBLICATION_ITEM_NAMES => l_publication_item_name
182: ,P_ACC_TABLE_NAME => l_acc_table_name
183: ,P_RESOURCE_ID => r_insert_diffs.resource_id
184: ,P_PK1_NAME => l_pk1_name

Line 194: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

190: --UPDATE
191: FOR r_updates in c_updates(r_LastRundate.LAST_RUN_DATE)
192: LOOP
193:
194: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
195: jtm_message_log_pkg.Log_Msg
196: ( 0
197: , l_table_name
198: , 'Updating ACC record for resource_id = ' || r_updates.resource_id

Line 199: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

195: jtm_message_log_pkg.Log_Msg
196: ( 0
197: , l_table_name
198: , 'Updating ACC record for resource_id = ' || r_updates.resource_id
199: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
200: END IF;
201:
202: JTM_HOOK_UTIL_PKG.Update_Acc
203: ( P_PUBLICATION_ITEM_NAMES => l_publication_item_name

Line 202: JTM_HOOK_UTIL_PKG.Update_Acc

198: , 'Updating ACC record for resource_id = ' || r_updates.resource_id
199: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
200: END IF;
201:
202: JTM_HOOK_UTIL_PKG.Update_Acc
203: ( P_PUBLICATION_ITEM_NAMES => l_publication_item_name
204: ,P_ACC_TABLE_NAME => l_acc_table_name
205: ,P_RESOURCE_ID => r_updates.resource_id
206: ,P_ACCESS_ID => r_updates.access_id

Line 216: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

212: --DELETE
213: FOR r_end_dates in c_end_dates(r_LastRundate.LAST_RUN_DATE)
214: LOOP
215:
216: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
217: jtm_message_log_pkg.Log_Msg
218: ( 0
219: , l_table_name
220: , 'Updating ACC record for resource_id = ' || r_end_dates.resource_id

Line 221: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

217: jtm_message_log_pkg.Log_Msg
218: ( 0
219: , l_table_name
220: , 'Updating ACC record for resource_id = ' || r_end_dates.resource_id
221: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
222: END IF;
223:
224: JTM_HOOK_UTIL_PKG.Delete_Acc
225: ( P_PUBLICATION_ITEM_NAMES => l_publication_item_name

Line 224: JTM_HOOK_UTIL_PKG.Delete_Acc

220: , 'Updating ACC record for resource_id = ' || r_end_dates.resource_id
221: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
222: END IF;
223:
224: JTM_HOOK_UTIL_PKG.Delete_Acc
225: ( P_PUBLICATION_ITEM_NAMES => l_publication_item_name
226: ,P_ACC_TABLE_NAME => l_acc_table_name
227: ,P_RESOURCE_ID => r_end_dates.resource_id
228: ,P_PK1_NAME => l_pk1_name

Line 243: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

239:
240: COMMIT;
241:
242:
243: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
244: jtm_message_log_pkg.Log_Msg
245: ( 0
246: , l_table_name
247: , 'Leaving Con_item_Attr'

Line 248: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

244: jtm_message_log_pkg.Log_Msg
245: ( 0
246: , l_table_name
247: , 'Leaving Con_item_Attr'
248: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
249: END IF;
250:
251: p_status := 'FINE';
252: p_message := 'CSL_CSI_ITEM_INSTANCES_ACC_PKG.CON_ITEM_ATTR Executed successfully';

Line 263: JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

259: jtm_message_log_pkg.Log_Msg
260: (0,
261: 'CSL_CSI_ITEM_ATTR_ACC',
262: 'Exception occured in CON_ITEM_ATTR ',
263: JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
264:
265: END;
266:
267:

Line 286: l_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=

282: AND civ.instance_id = b_instance_id;
283:
284: r_item_attr c_item_attr%ROWTYPE;
285:
286: l_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
287: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_CSI_ITEM_ATTR');
288: l_acc_table_name CONSTANT VARCHAR2(30) := 'CSL_CSI_ITEM_ATTR_ACC';
289: l_pk1_name CONSTANT VARCHAR2(30) := 'ATTRIBUTE_VALUE_ID';
290: l_table_name CONSTANT VARCHAR2(30) := 'CSL_CSI_ITEM_ATTR';

Line 287: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_CSI_ITEM_ATTR');

283:
284: r_item_attr c_item_attr%ROWTYPE;
285:
286: l_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
287: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_CSI_ITEM_ATTR');
288: l_acc_table_name CONSTANT VARCHAR2(30) := 'CSL_CSI_ITEM_ATTR_ACC';
289: l_pk1_name CONSTANT VARCHAR2(30) := 'ATTRIBUTE_VALUE_ID';
290: l_table_name CONSTANT VARCHAR2(30) := 'CSL_CSI_ITEM_ATTR';
291:

Line 294: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

290: l_table_name CONSTANT VARCHAR2(30) := 'CSL_CSI_ITEM_ATTR';
291:
292: BEGIN
293:
294: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
295: jtm_message_log_pkg.Log_Msg
296: ( p_instance_id
297: , g_table_name
298: , 'Entering Insert_Item_Attr'

Line 299: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

295: jtm_message_log_pkg.Log_Msg
296: ( p_instance_id
297: , g_table_name
298: , 'Entering Insert_Item_Attr'
299: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
300: END IF;
301:
302: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
303: jtm_message_log_pkg.Log_Msg

Line 302: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

298: , 'Entering Insert_Item_Attr'
299: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
300: END IF;
301:
302: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
303: jtm_message_log_pkg.Log_Msg
304: ( p_instance_id
305: , g_table_name
306: , 'Inserting ACC record for resource_id = ' || p_resource_id

Line 307: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

303: jtm_message_log_pkg.Log_Msg
304: ( p_instance_id
305: , g_table_name
306: , 'Inserting ACC record for resource_id = ' || p_resource_id
307: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
308: END IF;
309:
310: FOR r_item_attr in c_item_attr(p_instance_id)
311: LOOP

Line 313: JTM_HOOK_UTIL_PKG.Insert_Acc

309:
310: FOR r_item_attr in c_item_attr(p_instance_id)
311: LOOP
312:
313: JTM_HOOK_UTIL_PKG.Insert_Acc
314: ( P_PUBLICATION_ITEM_NAMES => l_publication_item_name
315: ,P_ACC_TABLE_NAME => l_acc_table_name
316: ,P_RESOURCE_ID => p_resource_id
317: ,P_PK1_NAME => l_pk1_name

Line 324: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

320:
321: END LOOP;
322:
323:
324: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
325: jtm_message_log_pkg.Log_Msg
326: ( p_instance_id
327: , g_table_name
328: , 'Leaving Insert_ACC_Record'

Line 329: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

325: jtm_message_log_pkg.Log_Msg
326: ( p_instance_id
327: , g_table_name
328: , 'Leaving Insert_ACC_Record'
329: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
330: END IF;
331:
332: END;
333:

Line 349: l_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=

345: WHERE instance_id = b_instance_id;
346:
347: r_item_attr c_item_attr%ROWTYPE;
348:
349: l_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
350: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_CSI_ITEM_ATTR');
351: l_acc_table_name CONSTANT VARCHAR2(30) := 'CSL_CSI_ITEM_ATTR_ACC';
352: l_pk1_name CONSTANT VARCHAR2(30) := 'ATTRIBUTE_VALUE_ID';
353: l_table_name CONSTANT VARCHAR2(30) := 'CSL_CSI_ITEM_ATTR';

Line 350: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_CSI_ITEM_ATTR');

346:
347: r_item_attr c_item_attr%ROWTYPE;
348:
349: l_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
350: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_CSI_ITEM_ATTR');
351: l_acc_table_name CONSTANT VARCHAR2(30) := 'CSL_CSI_ITEM_ATTR_ACC';
352: l_pk1_name CONSTANT VARCHAR2(30) := 'ATTRIBUTE_VALUE_ID';
353: l_table_name CONSTANT VARCHAR2(30) := 'CSL_CSI_ITEM_ATTR';
354:

Line 357: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

353: l_table_name CONSTANT VARCHAR2(30) := 'CSL_CSI_ITEM_ATTR';
354:
355: BEGIN
356:
357: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
358: jtm_message_log_pkg.Log_Msg
359: ( p_instance_id
360: , g_table_name
361: , 'Entering Delete_Item_Attr'

Line 362: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

358: jtm_message_log_pkg.Log_Msg
359: ( p_instance_id
360: , g_table_name
361: , 'Entering Delete_Item_Attr'
362: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
363: END IF;
364:
365: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
366: jtm_message_log_pkg.Log_Msg

Line 365: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

361: , 'Entering Delete_Item_Attr'
362: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
363: END IF;
364:
365: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
366: jtm_message_log_pkg.Log_Msg
367: ( p_instance_id
368: , g_table_name
369: , 'Deleting ACC record for resource_id = ' || p_resource_id

Line 370: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

366: jtm_message_log_pkg.Log_Msg
367: ( p_instance_id
368: , g_table_name
369: , 'Deleting ACC record for resource_id = ' || p_resource_id
370: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
371: END IF;
372:
373: FOR r_item_attr in c_item_attr(p_instance_id)
374: LOOP

Line 376: JTM_HOOK_UTIL_PKG.Delete_Acc

372:
373: FOR r_item_attr in c_item_attr(p_instance_id)
374: LOOP
375:
376: JTM_HOOK_UTIL_PKG.Delete_Acc
377: ( P_PUBLICATION_ITEM_NAMES => l_publication_item_name
378: ,P_ACC_TABLE_NAME => l_acc_table_name
379: ,P_RESOURCE_ID => p_resource_id
380: ,P_PK1_NAME => l_pk1_name

Line 386: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

382: );
383:
384: END LOOP;
385:
386: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
387: jtm_message_log_pkg.Log_Msg
388: ( p_instance_id
389: , g_table_name
390: , 'Leaving Delete_Item_Attr'

Line 391: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

387: jtm_message_log_pkg.Log_Msg
388: ( p_instance_id
389: , g_table_name
390: , 'Leaving Delete_Item_Attr'
391: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
392: END IF;
393:
394: END;
395:

Line 415: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

411: r_ii c_ii%ROWTYPE;
412: l_org_id NUMBER;
413: l_return BOOLEAN;
414: BEGIN
415: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
416: jtm_message_log_pkg.Log_Msg
417: ( p_instance_id
418: , g_table_name
419: , 'Entering Insert_ACC_Record'

Line 420: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

416: jtm_message_log_pkg.Log_Msg
417: ( p_instance_id
418: , g_table_name
419: , 'Entering Insert_ACC_Record'
420: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
421: END IF;
422:
423: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
424: jtm_message_log_pkg.Log_Msg

Line 423: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

419: , 'Entering Insert_ACC_Record'
420: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
421: END IF;
422:
423: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
424: jtm_message_log_pkg.Log_Msg
425: ( p_instance_id
426: , g_table_name
427: , 'Inserting ACC record for resource_id = ' || p_resource_id

Line 428: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

424: jtm_message_log_pkg.Log_Msg
425: ( p_instance_id
426: , g_table_name
427: , 'Inserting ACC record for resource_id = ' || p_resource_id
428: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
429: END IF;
430:
431: JTM_HOOK_UTIL_PKG.Insert_Acc
432: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name

Line 431: JTM_HOOK_UTIL_PKG.Insert_Acc

427: , 'Inserting ACC record for resource_id = ' || p_resource_id
428: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
429: END IF;
430:
431: JTM_HOOK_UTIL_PKG.Insert_Acc
432: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name
433: ,P_ACC_TABLE_NAME => g_acc_table_name
434: ,P_RESOURCE_ID => p_resource_id
435: ,P_PK1_NAME => g_pk1_name

Line 442: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

438:
439: -- ER 3168446
440: g_ib_count := g_ib_count + 1;
441:
442: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
443: jtm_message_log_pkg.Log_Msg
444: ( p_instance_id
445: , g_table_name
446: , 'Calling Non-critical dependent hooks'

Line 447: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

443: jtm_message_log_pkg.Log_Msg
444: ( p_instance_id
445: , g_table_name
446: , 'Calling Non-critical dependent hooks'
447: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
448: END IF;
449: -- NOTES/COUNTERS ( do not replicate notes/counters for history instances )
450: IF p_flow_type <> CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_HISTORY THEN
451: l_return := CSL_JTF_NOTES_ACC_PKG.PRE_INSERT_CHILDREN

Line 492: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

488: ( p_instance_id => p_instance_id
489: ,p_resource_id => p_resource_id
490: ,p_flow_type => p_flow_type);
491:
492: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
493: jtm_message_log_pkg.Log_Msg
494: ( p_instance_id
495: , g_table_name
496: , 'Leaving Insert_ACC_Record'

Line 497: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

493: jtm_message_log_pkg.Log_Msg
494: ( p_instance_id
495: , g_table_name
496: , 'Leaving Insert_ACC_Record'
497: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
498: END IF;
499: END Insert_ACC_Record;
500:
501: /*** Private procedure that re-sends given item instance to mobile ***/

Line 509: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

505: ,p_acc_id IN NUMBER
506: )
507: IS
508: BEGIN
509: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
510: jtm_message_log_pkg.Log_Msg
511: ( p_instance_id
512: , g_table_name
513: , 'Entering Update_ACC_Record'

Line 514: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

510: jtm_message_log_pkg.Log_Msg
511: ( p_instance_id
512: , g_table_name
513: , 'Entering Update_ACC_Record'
514: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
515: END IF;
516:
517: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
518: jtm_message_log_pkg.Log_Msg

Line 517: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

513: , 'Entering Update_ACC_Record'
514: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
515: END IF;
516:
517: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
518: jtm_message_log_pkg.Log_Msg
519: ( p_instance_id
520: , g_table_name
521: , 'Updating ACC record for resource_id = ' || p_resource_id

Line 523: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

519: ( p_instance_id
520: , g_table_name
521: , 'Updating ACC record for resource_id = ' || p_resource_id
522: || fnd_global.local_chr(10) || 'access_id = ' || p_acc_id
523: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
524: END IF;
525:
526: JTM_HOOK_UTIL_PKG.Update_Acc
527: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name

Line 526: JTM_HOOK_UTIL_PKG.Update_Acc

522: || fnd_global.local_chr(10) || 'access_id = ' || p_acc_id
523: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
524: END IF;
525:
526: JTM_HOOK_UTIL_PKG.Update_Acc
527: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name
528: ,P_ACC_TABLE_NAME => g_acc_table_name
529: ,P_RESOURCE_ID => p_resource_id
530: ,P_ACCESS_ID => p_acc_id

Line 533: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

529: ,P_RESOURCE_ID => p_resource_id
530: ,P_ACCESS_ID => p_acc_id
531: );
532:
533: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
534: jtm_message_log_pkg.Log_Msg
535: ( p_instance_id
536: , g_table_name
537: , 'Leaving Update_ACC_Record'

Line 538: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

534: jtm_message_log_pkg.Log_Msg
535: ( p_instance_id
536: , g_table_name
537: , 'Leaving Update_ACC_Record'
538: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
539: END IF;
540: END Update_ACC_Record;
541:
542:

Line 562: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

558: r_ii c_ii%ROWTYPE;
559: l_org_id NUMBER;
560: l_return BOOLEAN;
561: BEGIN
562: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
563: jtm_message_log_pkg.Log_Msg
564: ( p_instance_id
565: , g_table_name
566: , 'Entering Delete_ACC_Record'

Line 567: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

563: jtm_message_log_pkg.Log_Msg
564: ( p_instance_id
565: , g_table_name
566: , 'Entering Delete_ACC_Record'
567: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
568: END IF;
569:
570: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
571: jtm_message_log_pkg.Log_Msg

Line 570: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

566: , 'Entering Delete_ACC_Record'
567: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
568: END IF;
569:
570: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
571: jtm_message_log_pkg.Log_Msg
572: ( p_instance_id
573: , g_table_name
574: , 'Deleting ACC record for resource_id = ' || p_resource_id

Line 575: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

571: jtm_message_log_pkg.Log_Msg
572: ( p_instance_id
573: , g_table_name
574: , 'Deleting ACC record for resource_id = ' || p_resource_id
575: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
576: END IF;
577:
578: /*** Delete item instance ACC record ***/
579: JTM_HOOK_UTIL_PKG.Delete_Acc

Line 579: JTM_HOOK_UTIL_PKG.Delete_Acc

575: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
576: END IF;
577:
578: /*** Delete item instance ACC record ***/
579: JTM_HOOK_UTIL_PKG.Delete_Acc
580: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name
581: ,P_ACC_TABLE_NAME => g_acc_table_name
582: ,P_PK1_NAME => g_pk1_name
583: ,P_PK1_NUM_VALUE => p_instance_id

Line 630: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

626: ( p_instance_id => p_instance_id
627: ,p_resource_id => p_resource_id
628: ,p_flow_type => p_flow_type);
629:
630: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
631: jtm_message_log_pkg.Log_Msg
632: ( p_instance_id
633: , g_table_name
634: , 'Leaving Delete_ACC_Record'

Line 635: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

631: jtm_message_log_pkg.Log_Msg
632: ( p_instance_id
633: , g_table_name
634: , 'Leaving Delete_ACC_Record'
635: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
636: END IF;
637: END Delete_ACC_Record;
638:
639:

Line 657: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

653:
654: l_profile_value VARCHAR2(240);
655: BEGIN
656: /*** get debug level ***/
657: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
658:
659: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
660: jtm_message_log_pkg.Log_Msg
661: ( p_instance_id

Line 659: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

655: BEGIN
656: /*** get debug level ***/
657: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
658:
659: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
660: jtm_message_log_pkg.Log_Msg
661: ( p_instance_id
662: , g_table_name
663: , 'Entering Insert_Childs'

Line 664: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

660: jtm_message_log_pkg.Log_Msg
661: ( p_instance_id
662: , g_table_name
663: , 'Entering Insert_Childs'
664: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
665: END IF;
666:
667: l_profile_value := NVL(fnd_profile.value_specific('CSL_REPLICATE_CP_CHILDS'), 'N' );
668: -- IF Replicate Childs profile set to Y THEN

Line 679: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

675: , p_resource_id
676: , CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_NORMAL
677: );
678:
679: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
680: jtm_message_log_pkg.Log_Msg
681: ( p_instance_id
682: , g_table_name
683: , 'Child Instance inserted into ACC - INSTANCE_ID: ' || r_child_instance.subject_id

Line 684: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

680: jtm_message_log_pkg.Log_Msg
681: ( p_instance_id
682: , g_table_name
683: , 'Child Instance inserted into ACC - INSTANCE_ID: ' || r_child_instance.subject_id
684: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
685: END IF;
686: END LOOP; -- Next child IB
687: END IF;
688:

Line 689: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

685: END IF;
686: END LOOP; -- Next child IB
687: END IF;
688:
689: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
690: jtm_message_log_pkg.Log_Msg
691: ( p_instance_id
692: , g_table_name
693: , 'Leaving Insert_Childs'

Line 694: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

690: jtm_message_log_pkg.Log_Msg
691: ( p_instance_id
692: , g_table_name
693: , 'Leaving Insert_Childs'
694: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
695: END IF;
696:
697: END Insert_Childs;
698:

Line 716: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

712:
713: l_profile_value VARCHAR2(240);
714: BEGIN
715: /*** get debug level ***/
716: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
717:
718: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
719: jtm_message_log_pkg.Log_Msg
720: ( p_instance_id

Line 718: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

714: BEGIN
715: /*** get debug level ***/
716: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
717:
718: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
719: jtm_message_log_pkg.Log_Msg
720: ( p_instance_id
721: , g_table_name
722: , 'Entering Insert_Parents'

Line 723: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

719: jtm_message_log_pkg.Log_Msg
720: ( p_instance_id
721: , g_table_name
722: , 'Entering Insert_Parents'
723: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
724: END IF;
725:
726: l_profile_value := NVL(fnd_profile.value_specific('CSL_REPLICATE_CP_PARENTS'), 'N' );
727:

Line 739: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

735: , p_resource_id
736: , CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_NORMAL
737: );
738:
739: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
740: jtm_message_log_pkg.Log_Msg
741: ( p_instance_id
742: , g_table_name
743: , 'Parent Instance inserted into ACC - INSTANCE_ID: ' || r_parent_instance.object_id

Line 744: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

740: jtm_message_log_pkg.Log_Msg
741: ( p_instance_id
742: , g_table_name
743: , 'Parent Instance inserted into ACC - INSTANCE_ID: ' || r_parent_instance.object_id
744: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
745: END IF;
746: END LOOP; -- Next child IB
747: END IF;
748:

Line 749: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

745: END IF;
746: END LOOP; -- Next child IB
747: END IF;
748:
749: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
750: jtm_message_log_pkg.Log_Msg
751: ( p_instance_id
752: , g_table_name
753: , 'Leaving Insert_Parents'

Line 754: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

750: jtm_message_log_pkg.Log_Msg
751: ( p_instance_id
752: , g_table_name
753: , 'Leaving Insert_Parents'
754: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
755: END IF;
756:
757: END Insert_Parents;
758:

Line 871: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

867: l_location_id NUMBER;
868:
869: BEGIN
870: /*** get debug level ***/
871: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
872:
873: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
874: jtm_message_log_pkg.Log_Msg
875: ( p_instance_id

Line 873: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

869: BEGIN
870: /*** get debug level ***/
871: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
872:
873: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
874: jtm_message_log_pkg.Log_Msg
875: ( p_instance_id
876: , g_table_name
877: , 'Entering Pre_Insert_Child procedure'

Line 878: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

874: jtm_message_log_pkg.Log_Msg
875: ( p_instance_id
876: , g_table_name
877: , 'Entering Pre_Insert_Child procedure'
878: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
879: END IF;
880:
881: /* ER 3168446 View IB at Location Fix
882: ** Get the Party of this party Site */

Line 925: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

921:
922: END LOOP;
923: END IF;
924:
925: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
926: jtm_message_log_pkg.Log_Msg
927: ( p_instance_id
928: , g_table_name
929: , 'Leaving Pre_Insert_Child procedure'

Line 930: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

926: jtm_message_log_pkg.Log_Msg
927: ( p_instance_id
928: , g_table_name
929: , 'Leaving Pre_Insert_Child procedure'
930: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
931: END IF;
932:
933: -- ER 3168446
934: g_ib_count := 0;

Line 969: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

965:
966: l_profile_value VARCHAR2(240);
967: BEGIN
968: /*** get debug level ***/
969: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
970:
971: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
972: jtm_message_log_pkg.Log_Msg
973: ( p_instance_id

Line 971: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

967: BEGIN
968: /*** get debug level ***/
969: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
970:
971: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
972: jtm_message_log_pkg.Log_Msg
973: ( p_instance_id
974: , g_table_name
975: , 'Entering Delete_Childs'

Line 976: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

972: jtm_message_log_pkg.Log_Msg
973: ( p_instance_id
974: , g_table_name
975: , 'Entering Delete_Childs'
976: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
977: END IF;
978:
979: l_profile_value := NVL(fnd_profile.value_specific('CSL_REPLICATE_CP_CHILDS'), 'N' );
980: -- IF Replicate childs profile set to Y THEN

Line 991: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

987: , p_resource_id
988: , CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_NORMAL
989: );
990:
991: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
992: jtm_message_log_pkg.Log_Msg
993: ( p_instance_id
994: , g_table_name
995: , 'Child removed from ACC - INSTANCE_ID: ' || r_child_instance.subject_id

Line 996: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

992: jtm_message_log_pkg.Log_Msg
993: ( p_instance_id
994: , g_table_name
995: , 'Child removed from ACC - INSTANCE_ID: ' || r_child_instance.subject_id
996: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
997: END IF;
998: END LOOP; -- Next child IB
999: END IF;
1000:

Line 1001: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

997: END IF;
998: END LOOP; -- Next child IB
999: END IF;
1000:
1001: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1002: jtm_message_log_pkg.Log_Msg
1003: ( p_instance_id
1004: , g_table_name
1005: , 'Leaving Delete_Childs'

Line 1006: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

1002: jtm_message_log_pkg.Log_Msg
1003: ( p_instance_id
1004: , g_table_name
1005: , 'Leaving Delete_Childs'
1006: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
1007: END IF;
1008:
1009: END Delete_Childs;
1010:

Line 1026: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

1022:
1023: l_profile_value VARCHAR2(240);
1024: BEGIN
1025: /*** get debug level ***/
1026: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
1027:
1028: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1029: jtm_message_log_pkg.Log_Msg
1030: ( p_instance_id

Line 1028: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1024: BEGIN
1025: /*** get debug level ***/
1026: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
1027:
1028: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1029: jtm_message_log_pkg.Log_Msg
1030: ( p_instance_id
1031: , g_table_name
1032: , 'Entering Delete_Parents'

Line 1033: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

1029: jtm_message_log_pkg.Log_Msg
1030: ( p_instance_id
1031: , g_table_name
1032: , 'Entering Delete_Parents'
1033: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
1034: END IF;
1035:
1036: l_profile_value := NVL(fnd_profile.value_specific('CSL_REPLICATE_CP_PARENTS'), 'N' );
1037:

Line 1049: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1045: , p_resource_id
1046: , CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_NORMAL
1047: );
1048:
1049: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1050: jtm_message_log_pkg.Log_Msg
1051: ( p_instance_id
1052: , g_table_name
1053: , 'Parent removed from ACC - INSTANCE_ID: ' || r_parent_instance.object_id

Line 1054: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

1050: jtm_message_log_pkg.Log_Msg
1051: ( p_instance_id
1052: , g_table_name
1053: , 'Parent removed from ACC - INSTANCE_ID: ' || r_parent_instance.object_id
1054: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
1055: END IF;
1056: END LOOP; -- Next child IB
1057: END IF;
1058:

Line 1059: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1055: END IF;
1056: END LOOP; -- Next child IB
1057: END IF;
1058:
1059: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1060: jtm_message_log_pkg.Log_Msg
1061: ( p_instance_id
1062: , g_table_name
1063: , 'Leaving Delete_Parents'

Line 1064: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

1060: jtm_message_log_pkg.Log_Msg
1061: ( p_instance_id
1062: , g_table_name
1063: , 'Leaving Delete_Parents'
1064: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
1065: END IF;
1066:
1067: END Delete_Parents;
1068:

Line 1110: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

1106:
1107: l_acc_id NUMBER;
1108: BEGIN
1109: /*** get debug level ***/
1110: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
1111:
1112: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1113: jtm_message_log_pkg.Log_Msg
1114: ( p_instance_id

Line 1112: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1108: BEGIN
1109: /*** get debug level ***/
1110: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
1111:
1112: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1113: jtm_message_log_pkg.Log_Msg
1114: ( p_instance_id
1115: , g_table_name
1116: , 'Entering Post_Delete_Child'

Line 1117: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

1113: jtm_message_log_pkg.Log_Msg
1114: ( p_instance_id
1115: , g_table_name
1116: , 'Entering Post_Delete_Child'
1117: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
1118: END IF;
1119:
1120: /** ER 3168446 - View IB at Location Fix
1121: Delete the Instance associated with this SR and other Instances also

Line 1138: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1134: delete_acc_record ( p_instance_id, p_resource_id, p_flow_type);
1135:
1136: END LOOP;
1137:
1138: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1139: jtm_message_log_pkg.Log_Msg
1140: ( p_instance_id
1141: , g_table_name
1142: , 'Leaving Post_Delete_Child'

Line 1143: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

1139: jtm_message_log_pkg.Log_Msg
1140: ( p_instance_id
1141: , g_table_name
1142: , 'Leaving Post_Delete_Child'
1143: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
1144: END IF;
1145: END Post_Delete_Child;
1146:
1147: /*Procedure that gets called from mtl_onhand_quantity acc package*/

Line 1172: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

1168: l_org_id NUMBER;
1169:
1170: BEGIN
1171: /*** get debug level ***/
1172: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
1173: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1174: jtm_message_log_pkg.Log_Msg
1175: ( p_resource_id
1176: , g_table_name

Line 1173: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1169:
1170: BEGIN
1171: /*** get debug level ***/
1172: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
1173: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1174: jtm_message_log_pkg.Log_Msg
1175: ( p_resource_id
1176: , g_table_name
1177: , 'Entering Pre_Insert_Item'

Line 1178: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

1174: jtm_message_log_pkg.Log_Msg
1175: ( p_resource_id
1176: , g_table_name
1177: , 'Entering Pre_Insert_Item'
1178: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
1179: END IF;
1180:
1181: FOR r_item_instance IN c_item_instance ( p_inventory_item_id, p_organization_id, p_subinventory_code ) LOOP
1182: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

Line 1182: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

1178: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
1179: END IF;
1180:
1181: FOR r_item_instance IN c_item_instance ( p_inventory_item_id, p_organization_id, p_subinventory_code ) LOOP
1182: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1183: jtm_message_log_pkg.Log_Msg
1184: ( r_item_instance.instance_id
1185: , g_table_name
1186: , 'Inserting ACC record for resource_id = ' || p_resource_id

Line 1187: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

1183: jtm_message_log_pkg.Log_Msg
1184: ( r_item_instance.instance_id
1185: , g_table_name
1186: , 'Inserting ACC record for resource_id = ' || p_resource_id
1187: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
1188: END IF;
1189:
1190: JTM_HOOK_UTIL_PKG.Insert_Acc
1191: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name

Line 1190: JTM_HOOK_UTIL_PKG.Insert_Acc

1186: , 'Inserting ACC record for resource_id = ' || p_resource_id
1187: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
1188: END IF;
1189:
1190: JTM_HOOK_UTIL_PKG.Insert_Acc
1191: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name
1192: ,P_ACC_TABLE_NAME => g_acc_table_name
1193: ,P_RESOURCE_ID => p_resource_id
1194: ,P_PK1_NAME => g_pk1_name

Line 1208: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1204: );
1205:
1206: END LOOP;
1207:
1208: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1209: jtm_message_log_pkg.Log_Msg
1210: ( p_resource_id
1211: , g_table_name
1212: , 'Leaving Pre_Insert_Item'

Line 1213: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

1209: jtm_message_log_pkg.Log_Msg
1210: ( p_resource_id
1211: , g_table_name
1212: , 'Leaving Pre_Insert_Item'
1213: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
1214: END IF;
1215: END Pre_Insert_Item;
1216:
1217: /*Procedure that gets called from mtl_onhand_quantity acc package*/

Line 1242: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

1238: l_org_id NUMBER;
1239:
1240: BEGIN
1241: /*** get debug level ***/
1242: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
1243: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1244: jtm_message_log_pkg.Log_Msg
1245: ( p_resource_id
1246: , g_table_name

Line 1243: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1239:
1240: BEGIN
1241: /*** get debug level ***/
1242: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
1243: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1244: jtm_message_log_pkg.Log_Msg
1245: ( p_resource_id
1246: , g_table_name
1247: , 'Entering Post_Delete_Item'

Line 1248: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

1244: jtm_message_log_pkg.Log_Msg
1245: ( p_resource_id
1246: , g_table_name
1247: , 'Entering Post_Delete_Item'
1248: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
1249: END IF;
1250:
1251: FOR r_item_instance IN c_item_instance ( p_inventory_item_id, p_organization_id, p_subinventory_code ) LOOP
1252: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

Line 1252: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

1248: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
1249: END IF;
1250:
1251: FOR r_item_instance IN c_item_instance ( p_inventory_item_id, p_organization_id, p_subinventory_code ) LOOP
1252: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1253: jtm_message_log_pkg.Log_Msg
1254: ( r_item_instance.instance_id
1255: , g_table_name
1256: , 'Deleting ACC record for resource_id = ' || p_resource_id

Line 1257: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

1253: jtm_message_log_pkg.Log_Msg
1254: ( r_item_instance.instance_id
1255: , g_table_name
1256: , 'Deleting ACC record for resource_id = ' || p_resource_id
1257: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
1258: END IF;
1259:
1260: /*** Delete item instance ACC record ***/
1261: JTM_HOOK_UTIL_PKG.Delete_Acc

Line 1261: JTM_HOOK_UTIL_PKG.Delete_Acc

1257: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
1258: END IF;
1259:
1260: /*** Delete item instance ACC record ***/
1261: JTM_HOOK_UTIL_PKG.Delete_Acc
1262: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name
1263: ,P_ACC_TABLE_NAME => g_acc_table_name
1264: ,P_PK1_NAME => g_pk1_name
1265: ,P_PK1_NUM_VALUE => r_item_instance.instance_id

Line 1279: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1275: );
1276:
1277: END LOOP;
1278:
1279: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1280: jtm_message_log_pkg.Log_Msg
1281: ( p_resource_id
1282: , g_table_name
1283: , 'Leaving Post_Delete_Item'

Line 1284: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

1280: jtm_message_log_pkg.Log_Msg
1281: ( p_resource_id
1282: , g_table_name
1283: , 'Leaving Post_Delete_Item'
1284: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
1285: END IF;
1286: END Post_Delete_Item;
1287:
1288:

Line 1329: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

1325:
1326:
1327: BEGIN
1328: /*** get debug level ***/
1329: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
1330:
1331: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1332: jtm_message_log_pkg.Log_Msg
1333: ( p_instance_id

Line 1331: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1327: BEGIN
1328: /*** get debug level ***/
1329: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
1330:
1331: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1332: jtm_message_log_pkg.Log_Msg
1333: ( p_instance_id
1334: , g_table_name
1335: , 'Entering POST_INSERT hook'

Line 1336: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

1332: jtm_message_log_pkg.Log_Msg
1333: ( p_instance_id
1334: , g_table_name
1335: , 'Entering POST_INSERT hook'
1336: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
1337: END IF;
1338: /*Check if this item is a parent or child of an existing instance*/
1339:
1340: /*** Is this a parent ? ***/

Line 1342: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

1338: /*Check if this item is a parent or child of an existing instance*/
1339:
1340: /*** Is this a parent ? ***/
1341: FOR r_is_parent IN c_is_parent( p_instance_id ) LOOP
1342: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1343: jtm_message_log_pkg.Log_Msg
1344: ( p_instance_id
1345: , g_table_name
1346: , 'Instance is parent for resource: '||r_is_parent.resource_id

Line 1347: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

1343: jtm_message_log_pkg.Log_Msg
1344: ( p_instance_id
1345: , g_table_name
1346: , 'Instance is parent for resource: '||r_is_parent.resource_id
1347: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
1348: END IF;
1349: Insert_ACC_Record( p_instance_id => p_instance_id
1350: , p_resource_id => r_is_parent.resource_id
1351: , p_flow_type => CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_NORMAL

Line 1357: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

1353: END LOOP;
1354:
1355: /*Is this a child ?*/
1356: FOR r_is_child IN c_is_child( p_instance_id ) LOOP
1357: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1358: jtm_message_log_pkg.Log_Msg
1359: ( p_instance_id
1360: , g_table_name
1361: , 'Instance is child for resource: '||r_is_child.resource_id

Line 1362: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

1358: jtm_message_log_pkg.Log_Msg
1359: ( p_instance_id
1360: , g_table_name
1361: , 'Instance is child for resource: '||r_is_child.resource_id
1362: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
1363: END IF;
1364:
1365: Insert_ACC_Record( p_instance_id => p_instance_id
1366: , p_resource_id => r_is_child.resource_id

Line 1371: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1367: , p_flow_type => CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_NORMAL
1368: );
1369: END LOOP;
1370:
1371: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1372: jtm_message_log_pkg.Log_Msg
1373: ( p_instance_id
1374: , g_table_name
1375: , 'Leaving POST_INSERT hook'

Line 1376: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

1372: jtm_message_log_pkg.Log_Msg
1373: ( p_instance_id
1374: , g_table_name
1375: , 'Leaving POST_INSERT hook'
1376: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
1377: END IF;
1378:
1379: x_return_status := FND_API.G_RET_STS_SUCCESS;
1380: RETURN;

Line 1384: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

1380: RETURN;
1381:
1382: EXCEPTION WHEN OTHERS THEN
1383: /*** hook failed -> log error ***/
1384: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
1385: jtm_message_log_pkg.Log_Msg
1386: ( p_instance_id
1387: , g_table_name
1388: , 'Caught exception in POST_INSERT hook:' || fnd_global.local_chr(10) || sqlerrm

Line 1389: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

1385: jtm_message_log_pkg.Log_Msg
1386: ( p_instance_id
1387: , g_table_name
1388: , 'Caught exception in POST_INSERT hook:' || fnd_global.local_chr(10) || sqlerrm
1389: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
1390: END IF;
1391: fnd_msg_pub.Add_Exc_Msg('CSL_CSI_ITEM_INSTANCES_ACC_PKG','POST_INSERT_ITEM_INSTANCE',sqlerrm);
1392: -- x_return_status := FND_API.G_RET_STS_ERROR;
1393: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1462: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

1458: inv_itm_id inv_itm_idTab;
1459:
1460: BEGIN
1461: /*** get debug level ***/
1462: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
1463:
1464: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1465: jtm_message_log_pkg.Log_Msg
1466: ( 0

Line 1464: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1460: BEGIN
1461: /*** get debug level ***/
1462: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
1463:
1464: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1465: jtm_message_log_pkg.Log_Msg
1466: ( 0
1467: , g_table_name
1468: , 'Entering CONC_ITEM_INSTANCES hook'

Line 1469: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

1465: jtm_message_log_pkg.Log_Msg
1466: ( 0
1467: , g_table_name
1468: , 'Entering CONC_ITEM_INSTANCES hook'
1469: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
1470: END IF;
1471:
1472: --UPDATE
1473: /*Fetch all changed item instances that are in the acc table*/

Line 1478: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

1474: OPEN c_changed( p_last_run_date );
1475: FETCH c_changed BULK COLLECT INTO l_tab_access_id, l_tab_resource_id;
1476:
1477: IF (l_tab_access_id.COUNT > 0) THEN
1478: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1479: jtm_message_log_pkg.Log_Msg
1480: ( 0
1481: , g_table_name
1482: , 'Update ACC record for all resources, count = ' || l_tab_access_id.COUNT

Line 1483: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

1479: jtm_message_log_pkg.Log_Msg
1480: ( 0
1481: , g_table_name
1482: , 'Update ACC record for all resources, count = ' || l_tab_access_id.COUNT
1483: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
1484: END IF;
1485:
1486: /*** push to oLite using asg_download ***/
1487: l_dummy := asg_download.markdirty(

Line 1527: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

1523: );
1524:
1525: IF (inst_id.COUNT > 0) THEN
1526: FOR i IN inst_id.FIRST..inst_id.LAST LOOP
1527: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1528: jtm_message_log_pkg.Log_Msg
1529: ( inst_id(i)
1530: , g_table_name
1531: , 'Inserting ACC record for resource_id = ' || res_id(i)

Line 1532: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

1528: jtm_message_log_pkg.Log_Msg
1529: ( inst_id(i)
1530: , g_table_name
1531: , 'Inserting ACC record for resource_id = ' || res_id(i)
1532: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
1533: END IF;
1534:
1535: JTM_HOOK_UTIL_PKG.Insert_Acc
1536: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name

Line 1535: JTM_HOOK_UTIL_PKG.Insert_Acc

1531: , 'Inserting ACC record for resource_id = ' || res_id(i)
1532: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
1533: END IF;
1534:
1535: JTM_HOOK_UTIL_PKG.Insert_Acc
1536: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name
1537: ,P_ACC_TABLE_NAME => g_acc_table_name
1538: ,P_RESOURCE_ID => res_id(i)
1539: ,P_PK1_NAME => g_pk1_name

Line 1583: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

1579: );
1580:
1581: IF (inst_id.COUNT > 0) THEN
1582: FOR i IN inst_id.FIRST..inst_id.LAST LOOP
1583: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1584: jtm_message_log_pkg.Log_Msg
1585: ( inst_id(i)
1586: , g_table_name
1587: , 'Deleting ACC record for resource_id = ' || res_id(i)

Line 1588: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

1584: jtm_message_log_pkg.Log_Msg
1585: ( inst_id(i)
1586: , g_table_name
1587: , 'Deleting ACC record for resource_id = ' || res_id(i)
1588: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
1589: END IF;
1590:
1591: -- Delete item instance ACC record
1592: JTM_HOOK_UTIL_PKG.Delete_Acc

Line 1592: JTM_HOOK_UTIL_PKG.Delete_Acc

1588: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
1589: END IF;
1590:
1591: -- Delete item instance ACC record
1592: JTM_HOOK_UTIL_PKG.Delete_Acc
1593: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name
1594: ,P_ACC_TABLE_NAME => g_acc_table_name
1595: ,P_PK1_NAME => g_pk1_name
1596: ,P_PK1_NUM_VALUE => inst_id(i)

Line 1609: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1605: END LOOP;
1606: END IF;
1607:
1608:
1609: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1610: jtm_message_log_pkg.Log_Msg
1611: ( 0
1612: , g_table_name
1613: , 'Leaving CONC_ITEM_INSTANCES hook'

Line 1614: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

1610: jtm_message_log_pkg.Log_Msg
1611: ( 0
1612: , g_table_name
1613: , 'Leaving CONC_ITEM_INSTANCES hook'
1614: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
1615: END IF;
1616:
1617: END CONC_ITEM_INSTANCES;
1618: