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_MTL_SYSTEM_ITEMS_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: cslsiacb.pls 120.0 2005/05/24 18:40:25 appldev noship $ */
3:
4: /*** Globals ***/
5: g_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_MTL_SYSTEM_ITEMS_ACC';
6: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
7: JTM_HOOK_UTIL_PKG.t_publication_item_list('MTL_SYSTEM_ITEMS_VL');
8:
9: --Bug 3746689
10: g_explab_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=

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

3:
4: /*** Globals ***/
5: g_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_MTL_SYSTEM_ITEMS_ACC';
6: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
7: JTM_HOOK_UTIL_PKG.t_publication_item_list('MTL_SYSTEM_ITEMS_VL');
8:
9: --Bug 3746689
10: g_explab_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
11: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_MTL_EXPENSE_LABOR_ITEM');

Line 10: g_explab_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=

6: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
7: JTM_HOOK_UTIL_PKG.t_publication_item_list('MTL_SYSTEM_ITEMS_VL');
8:
9: --Bug 3746689
10: g_explab_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
11: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_MTL_EXPENSE_LABOR_ITEM');
12:
13: g_table_name CONSTANT VARCHAR2(30) := 'MTL_SYSTEM_ITEMS_B';
14: g_pk1_name CONSTANT VARCHAR2(30) := 'INVENTORY_ITEM_ID';

Line 11: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_MTL_EXPENSE_LABOR_ITEM');

7: JTM_HOOK_UTIL_PKG.t_publication_item_list('MTL_SYSTEM_ITEMS_VL');
8:
9: --Bug 3746689
10: g_explab_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
11: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_MTL_EXPENSE_LABOR_ITEM');
12:
13: g_table_name CONSTANT VARCHAR2(30) := 'MTL_SYSTEM_ITEMS_B';
14: g_pk1_name CONSTANT VARCHAR2(30) := 'INVENTORY_ITEM_ID';
15: g_pk2_name CONSTANT VARCHAR2(30) := 'ORGANIZATION_ID';

Line 28: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

24: IS
25:
26: BEGIN
27: /*** get debug level ***/
28: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
29:
30: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
31: jtm_message_log_pkg.Log_Msg
32: ( p_organization_id

Line 30: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

26: BEGIN
27: /*** get debug level ***/
28: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
29:
30: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
31: jtm_message_log_pkg.Log_Msg
32: ( p_organization_id
33: , g_table_name
34: , 'Entering Replicate_Record'

Line 35: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

31: jtm_message_log_pkg.Log_Msg
32: ( p_organization_id
33: , g_table_name
34: , 'Entering Replicate_Record'
35: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
36: END IF;
37:
38: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
39: jtm_message_log_pkg.Log_Msg

Line 38: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

34: , 'Entering Replicate_Record'
35: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
36: END IF;
37:
38: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
39: jtm_message_log_pkg.Log_Msg
40: ( p_organization_id
41: , g_table_name
42: , 'Replicate_Record returned TRUE'

Line 43: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

39: jtm_message_log_pkg.Log_Msg
40: ( p_organization_id
41: , g_table_name
42: , 'Replicate_Record returned TRUE'
43: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
44: END IF;
45:
46: /** Record matched criteria -> return true ***/
47: RETURN TRUE;

Line 87: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

83: and msi.material_billable_flag = cbtc.billing_type (+)
84: AND cbtc.billing_category IN ('E','L'));
85: END IF;
86:
87: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
88: jtm_message_log_pkg.Log_Msg
89: ( p_organization_id
90: , g_table_name
91: , 'Entering INSERT_ACC_REC_MARKDIRTY_EXP'

Line 92: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

88: jtm_message_log_pkg.Log_Msg
89: ( p_organization_id
90: , g_table_name
91: , 'Entering INSERT_ACC_REC_MARKDIRTY_EXP'
92: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
93: );
94: END IF;
95:
96: /*Block insert every item from given org not yet in acc table*/

Line 112: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

108: AND organization_id = p_organization_id;
109:
110: IF l_tab_access_id.COUNT > 0 THEN
111: /*** 1 or more acc rows retrieved -> push to resource ***/
112: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
113: jtm_message_log_pkg.Log_Msg
114: ( p_organization_id
115: , g_table_name
116: , 'Pushing ' || l_tab_access_id.COUNT ||

Line 118: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

114: ( p_organization_id
115: , g_table_name
116: , 'Pushing ' || l_tab_access_id.COUNT ||
117: ' inserted record(s) to resource: '||p_resource_id
118: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
119: );
120: END IF;
121:
122: FORALL i IN l_tab_access_id.FIRST..l_tab_access_id.LAST

Line 142: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

138: END IF;
139:
140: END IF; -- End of Insert of Expense and Labor items
141:
142: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
143: jtm_message_log_pkg.Log_Msg
144: ( p_organization_id
145: , g_table_name
146: , 'Leaving INSERT_ACC_REC_MARKDIRTY_EXP'

Line 147: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

143: jtm_message_log_pkg.Log_Msg
144: ( p_organization_id
145: , g_table_name
146: , 'Leaving INSERT_ACC_REC_MARKDIRTY_EXP'
147: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
148: );
149: END IF;
150:
151: EXCEPTION

Line 158: , JTM_HOOK_UTIL_PKG.g_debug_level_error);

154: ( p_organization_id
155: , g_table_name
156: , 'INSERT_ACC_REC_MARKDIRTY_EXP'||fnd_global.local_chr(10)||
157: 'Error: '||sqlerrm
158: , JTM_HOOK_UTIL_PKG.g_debug_level_error);
159: RAISE;
160: END INSERT_ACC_REC_MARKDIRTY_EXP;
161:
162:

Line 187: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

183: --Bug 3746689
184: l_billCat CS_BILLING_TYPE_CATEGORIES.BILLING_CATEGORY%TYPE;
185:
186: BEGIN
187: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
188: THEN
189: jtm_message_log_pkg.Log_Msg
190: ( p_organization_id
191: , g_table_name

Line 193: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

189: jtm_message_log_pkg.Log_Msg
190: ( p_organization_id
191: , g_table_name
192: , 'Entering Insert_ACC_Record'
193: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
194: );
195: END IF;
196:
197: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 197: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

193: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
194: );
195: END IF;
196:
197: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
198: THEN
199: jtm_message_log_pkg.Log_Msg
200: ( p_organization_id
201: , g_table_name

Line 203: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

199: jtm_message_log_pkg.Log_Msg
200: ( p_organization_id
201: , g_table_name
202: , 'Inserting ACC record for resource_id = ' || p_resource_id
203: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
204: END IF;
205:
206: --Added by UTEKUMAL on 16-Feb-2004 to segregate the Item by Billing Category
207: --Bug 3908277 - Static Query converted into Cursor.

Line 214: JTM_HOOK_UTIL_PKG.Insert_Acc

210: CLOSE c_billCat;
211:
212: /*** Insert item ACC record ***/
213: IF l_billCat = 'E' OR l_billCat = 'L' THEN
214: JTM_HOOK_UTIL_PKG.Insert_Acc
215: ( P_PUBLICATION_ITEM_NAMES => g_explab_publication_item_name
216: , P_ACC_TABLE_NAME => g_acc_table_name
217: , P_RESOURCE_ID => p_resource_id
218: , P_PK1_NAME => g_pk1_name

Line 224: JTM_HOOK_UTIL_PKG.Insert_Acc

220: , P_PK2_NAME => g_pk2_name
221: , P_PK2_NUM_VALUE => p_organization_id
222: );
223: ELSE
224: JTM_HOOK_UTIL_PKG.Insert_Acc
225: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name
226: , P_ACC_TABLE_NAME => g_acc_table_name
227: , P_RESOURCE_ID => p_resource_id
228: , P_PK1_NAME => g_pk1_name

Line 241: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

237: , p_organization_id => p_organization_id
238: , p_resource_id => p_resource_id
239: );
240:
241: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
242: THEN
243: jtm_message_log_pkg.Log_Msg
244: ( p_organization_id
245: , g_table_name

Line 247: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

243: jtm_message_log_pkg.Log_Msg
244: ( p_organization_id
245: , g_table_name
246: , 'Leaving Insert_ACC_Record'
247: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
248: );
249: END IF;
250: END Insert_ACC_Record;
251:

Line 273: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

269: --Bug 3746689
270: l_billCat CS_BILLING_TYPE_CATEGORIES.BILLING_CATEGORY%TYPE;
271:
272: BEGIN
273: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
274: THEN
275: jtm_message_log_pkg.Log_Msg
276: ( p_organization_id
277: , g_table_name

Line 279: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

275: jtm_message_log_pkg.Log_Msg
276: ( p_organization_id
277: , g_table_name
278: , 'Entering Delete_ACC_Record'
279: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
280: );
281: END IF;
282:
283: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 283: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

279: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
280: );
281: END IF;
282:
283: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
284: THEN
285: jtm_message_log_pkg.Log_Msg
286: ( p_organization_id
287: , g_table_name

Line 289: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

285: jtm_message_log_pkg.Log_Msg
286: ( p_organization_id
287: , g_table_name
288: , 'Deleting ACC record for resource_id = ' || p_resource_id
289: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
290: );
291: END IF;
292:
293: --Added by UTEKUMAL on 16-Feb-2004 to segregate the Item by Billing Category

Line 301: JTM_HOOK_UTIL_PKG.Delete_Acc

297: CLOSE c_billCat;
298:
299: /*** Delete item ACC record ***/
300: IF l_billCat = 'E' OR l_billCat = 'L' THEN
301: JTM_HOOK_UTIL_PKG.Delete_Acc
302: ( P_PUBLICATION_ITEM_NAMES => g_explab_publication_item_name
303: , P_ACC_TABLE_NAME => g_acc_table_name
304: , P_RESOURCE_ID => p_resource_id
305: , P_PK1_NAME => g_pk1_name

Line 311: JTM_HOOK_UTIL_PKG.Delete_Acc

307: , P_PK2_NAME => g_pk2_name
308: , P_PK2_NUM_VALUE => p_organization_id
309: );
310: ELSE
311: JTM_HOOK_UTIL_PKG.Delete_Acc
312: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name
313: , P_ACC_TABLE_NAME => g_acc_table_name
314: , P_RESOURCE_ID => p_resource_id
315: , P_PK1_NAME => g_pk1_name

Line 329: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

325: , p_organization_id => p_organization_id
326: , p_resource_id => p_resource_id
327: );
328:
329: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
330: THEN
331: jtm_message_log_pkg.Log_Msg
332: ( p_organization_id
333: , g_table_name

Line 335: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

331: jtm_message_log_pkg.Log_Msg
332: ( p_organization_id
333: , g_table_name
334: , 'Leaving Delete_ACC_Record'
335: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
336: );
337: END IF;
338: END Delete_ACC_Record;
339:

Line 351: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

347: )
348: IS
349: BEGIN
350: /*** get debug level ***/
351: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
352:
353: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
354: THEN
355: jtm_message_log_pkg.Log_Msg

Line 353: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

349: BEGIN
350: /*** get debug level ***/
351: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
352:
353: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
354: THEN
355: jtm_message_log_pkg.Log_Msg
356: ( p_organization_id
357: , g_table_name

Line 359: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

355: jtm_message_log_pkg.Log_Msg
356: ( p_organization_id
357: , g_table_name
358: , 'Entering Pre_Insert_Child'
359: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
360: );
361: END IF;
362:
363: /*** no -> does record match criteria? ***/

Line 374: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

370: , p_resource_id
371: );
372: END IF;
373:
374: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
375: THEN
376: jtm_message_log_pkg.Log_Msg
377: ( p_organization_id
378: , g_table_name

Line 380: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

376: jtm_message_log_pkg.Log_Msg
377: ( p_organization_id
378: , g_table_name
379: , 'Leaving Pre_Insert_Child'
380: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
381: );
382: END IF;
383:
384: END Pre_Insert_Child;

Line 399: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

395: IS
396: l_acc_id NUMBER;
397: BEGIN
398: /*** get debug level ***/
399: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
400:
401: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
402: THEN
403: jtm_message_log_pkg.Log_Msg

Line 401: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

397: BEGIN
398: /*** get debug level ***/
399: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
400:
401: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
402: THEN
403: jtm_message_log_pkg.Log_Msg
404: ( p_organization_id
405: , g_table_name

Line 407: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

403: jtm_message_log_pkg.Log_Msg
404: ( p_organization_id
405: , g_table_name
406: , 'Entering Post_Delete_Child'
407: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
408: );
409: END IF;
410:
411: l_acc_id := JTM_HOOK_UTIL_PKG.Get_Acc_Id

Line 411: l_acc_id := JTM_HOOK_UTIL_PKG.Get_Acc_Id

407: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
408: );
409: END IF;
410:
411: l_acc_id := JTM_HOOK_UTIL_PKG.Get_Acc_Id
412: ( P_ACC_TABLE_NAME => g_acc_table_name
413: , P_RESOURCE_ID => p_resource_id
414: , P_PK1_NAME => g_pk1_name
415: , P_PK1_NUM_VALUE => p_inventory_item_id

Line 430: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

426: , p_resource_id
427: );
428: END IF;
429:
430: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
431: THEN
432: jtm_message_log_pkg.Log_Msg
433: ( p_organization_id
434: , g_table_name

Line 436: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

432: jtm_message_log_pkg.Log_Msg
433: ( p_organization_id
434: , g_table_name
435: , 'Leaving Post_Delete_Child'
436: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
437: );
438: END IF;
439:
440: END Post_Delete_Child;

Line 510: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

506: , x_return_status OUT NOCOPY VARCHAR2 )
507: IS
508: BEGIN
509: /*** get debug level ***/
510: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
511: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
512: jtm_message_log_pkg.Log_Msg
513: ( p_resource_id
514: , g_table_name

Line 511: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

507: IS
508: BEGIN
509: /*** get debug level ***/
510: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
511: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
512: jtm_message_log_pkg.Log_Msg
513: ( p_resource_id
514: , g_table_name
515: , 'Entering DELETE_ALL_ACC_RECORDS'

Line 516: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

512: jtm_message_log_pkg.Log_Msg
513: ( p_resource_id
514: , g_table_name
515: , 'Entering DELETE_ALL_ACC_RECORDS'
516: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
517: );
518: END IF;
519:
520: /*Do the actual delete*/

Line 538: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

534: COMMIT;
535:
536: x_return_status := FND_API.G_RET_STS_SUCCESS;
537:
538: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
539: jtm_message_log_pkg.Log_Msg
540: ( p_resource_id
541: , g_table_name
542: , 'Leaving DELETE_ALL_ACC_RECORDS'

Line 543: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

539: jtm_message_log_pkg.Log_Msg
540: ( p_resource_id
541: , g_table_name
542: , 'Leaving DELETE_ALL_ACC_RECORDS'
543: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
544: );
545: END IF;
546: EXCEPTION
547: WHEN OTHERS THEN

Line 553: , JTM_HOOK_UTIL_PKG.g_debug_level_error);

549: ( p_resource_id
550: , g_table_name
551: , 'DELETE_ALL_ACC_RECORDS'||fnd_global.local_chr(10)||
552: 'Error: '||sqlerrm
553: , JTM_HOOK_UTIL_PKG.g_debug_level_error);
554: x_return_status := FND_API.G_RET_STS_ERROR;
555: /*Reduce rollback segments*/
556: ROLLBACK;
557: RAISE;

Line 597: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

593: l_stmt1 VARCHAR2(4000);
594:
595: BEGIN
596: /*** get debug level ***/
597: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
598: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
599: jtm_message_log_pkg.Log_Msg
600: ( p_resource_id
601: , g_table_name

Line 598: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

594:
595: BEGIN
596: /*** get debug level ***/
597: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
598: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
599: jtm_message_log_pkg.Log_Msg
600: ( p_resource_id
601: , g_table_name
602: , 'Entering INSERT_ALL_ACC_RECORDS'

Line 603: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

599: jtm_message_log_pkg.Log_Msg
600: ( p_resource_id
601: , g_table_name
602: , 'Entering INSERT_ALL_ACC_RECORDS'
603: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
604: );
605: END IF;
606:
607: /*** get user_id and mobile responsibility_id ***/

Line 612: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

608: OPEN c_mobile_resp( p_resource_id );
609: FETCH c_mobile_resp INTO r_mobile_resp;
610: IF c_mobile_resp%NOTFOUND THEN
611: /*** no active mobile responsibility found -> log error ***/
612: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
613: jtm_message_log_pkg.Log_Msg
614: ( p_resource_id
615: , g_table_name
616: , 'Resource_id = ' || p_resource_id || ' does not have any active mobile responsibilities'

Line 617: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR

613: jtm_message_log_pkg.Log_Msg
614: ( p_resource_id
615: , g_table_name
616: , 'Resource_id = ' || p_resource_id || ' does not have any active mobile responsibilities'
617: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR
618: );
619: END IF;
620: x_return_status := FND_API.G_RET_STS_ERROR;
621: ELSE

Line 727: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

723: COMMIT;
724: END IF;
725: CLOSE c_mobile_resp;
726:
727: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
728: jtm_message_log_pkg.Log_Msg
729: ( p_resource_id
730: , g_table_name
731: , 'Leaving INSERT_ALL_ACC_RECORDS'

Line 732: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

728: jtm_message_log_pkg.Log_Msg
729: ( p_resource_id
730: , g_table_name
731: , 'Leaving INSERT_ALL_ACC_RECORDS'
732: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
733: );
734: END IF;
735:
736: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 740: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

736: x_return_status := FND_API.G_RET_STS_SUCCESS;
737: EXCEPTION
738: WHEN OTHERS THEN
739: ROLLBACK;
740: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
741: jtm_message_log_pkg.Log_Msg
742: ( p_resource_id
743: , g_table_name
744: , 'INSERT_ALL_ACC_RECORDS'||fnd_global.local_chr(10)||

Line 746: , JTM_HOOK_UTIL_PKG.g_debug_level_error);

742: ( p_resource_id
743: , g_table_name
744: , 'INSERT_ALL_ACC_RECORDS'||fnd_global.local_chr(10)||
745: 'Error: '||sqlerrm
746: , JTM_HOOK_UTIL_PKG.g_debug_level_error);
747: END IF;
748: x_return_status := FND_API.G_RET_STS_ERROR;
749: RAISE;
750: END INSERT_ALL_ACC_RECORDS;

Line 890: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

886:
887: el_ctr := 1;
888: m_ctr := 1;
889:
890: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
891: jtm_message_log_pkg.Log_Msg
892: ( p_organization_id
893: , g_table_name
894: , 'Entering INSERT_ACC_REC_MARKDIRTY'

Line 895: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

891: jtm_message_log_pkg.Log_Msg
892: ( p_organization_id
893: , g_table_name
894: , 'Entering INSERT_ACC_REC_MARKDIRTY'
895: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
896: );
897: END IF;
898:
899: IF p_changed = 'Y' THEN

Line 901: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

897: END IF;
898:
899: IF p_changed = 'Y' THEN
900: /*Raise counter for items from given org already in acc table ( e.g. system item of SR )*/
901: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
902: jtm_message_log_pkg.Log_Msg
903: ( p_organization_id
904: , g_table_name
905: , 'Updating '||g_acc_table_name

Line 906: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

902: jtm_message_log_pkg.Log_Msg
903: ( p_organization_id
904: , g_table_name
905: , 'Updating '||g_acc_table_name
906: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
907: END IF;
908:
909: --Bug 3724165
910: --Bug 3929942 - Use Bind variables

Line 979: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

975:
976: IF l_tab_access_id.COUNT > 0 THEN
977:
978: /*** 1 or more acc rows retrieved -> push to resource ***/
979: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
980: jtm_message_log_pkg.Log_Msg
981: ( p_organization_id
982: , g_table_name
983: , 'Pushing ' || l_tab_access_id.COUNT

Line 985: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

981: ( p_organization_id
982: , g_table_name
983: , 'Pushing ' || l_tab_access_id.COUNT
984: || ' inserted record(s) to resource: '||p_resource_id
985: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
986: );
987: END IF;
988:
989: FORALL i IN l_tab_access_id.FIRST..l_tab_access_id.LAST

Line 1030: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

1026:
1027: IF l_tab_access_id.COUNT > 0 THEN
1028:
1029: /*** 1 or more acc rows retrieved -> push to resource ***/
1030: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1031: jtm_message_log_pkg.Log_Msg
1032: ( p_organization_id
1033: , g_table_name
1034: , 'Pushing ' || l_tab_access_id.COUNT

Line 1036: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

1032: ( p_organization_id
1033: , g_table_name
1034: , 'Pushing ' || l_tab_access_id.COUNT
1035: || ' inserted record(s) to resource: '||p_resource_id
1036: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
1037: );
1038: END IF;
1039:
1040: FORALL i IN l_tab_access_id.FIRST..l_tab_access_id.LAST

Line 1081: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

1077:
1078: IF l_tab_access_id.COUNT > 0 THEN
1079:
1080: /*** 1 or more acc rows retrieved -> push to resource ***/
1081: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1082: jtm_message_log_pkg.Log_Msg
1083: ( p_organization_id
1084: , g_table_name
1085: , 'Pushing ' || l_tab_access_id.COUNT

Line 1087: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

1083: ( p_organization_id
1084: , g_table_name
1085: , 'Pushing ' || l_tab_access_id.COUNT
1086: || ' inserted record(s) to resource: '||p_resource_id
1087: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
1088: );
1089: END IF;
1090:
1091: FORALL i IN l_tab_access_id.FIRST..l_tab_access_id.LAST

Line 1132: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

1128:
1129: IF l_tab_access_id.COUNT > 0 THEN
1130:
1131: /*** 1 or more acc rows retrieved -> push to resource ***/
1132: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1133: jtm_message_log_pkg.Log_Msg
1134: ( p_organization_id
1135: , g_table_name
1136: , 'Pushing ' || l_tab_access_id.COUNT

Line 1138: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

1134: ( p_organization_id
1135: , g_table_name
1136: , 'Pushing ' || l_tab_access_id.COUNT
1137: || ' inserted record(s) to resource: '||p_resource_id
1138: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
1139: );
1140: END IF;
1141:
1142: FORALL i IN l_tab_access_id.FIRST..l_tab_access_id.LAST

Line 1172: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1168:
1169: INSERT_ACC_REC_MARKDIRTY_EXP(p_organization_id, p_resource_id, p_old_org_id);
1170:
1171:
1172: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1173: jtm_message_log_pkg.Log_Msg
1174: ( p_organization_id
1175: , g_table_name
1176: , 'Leaving INSERT_ACC_REC_MARKDIRTY'

Line 1177: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

1173: jtm_message_log_pkg.Log_Msg
1174: ( p_organization_id
1175: , g_table_name
1176: , 'Leaving INSERT_ACC_REC_MARKDIRTY'
1177: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
1178: );
1179: END IF;
1180: EXCEPTION
1181: WHEN OTHERS THEN

Line 1187: , JTM_HOOK_UTIL_PKG.g_debug_level_error);

1183: ( p_organization_id
1184: , g_table_name
1185: , 'INSERT_ACC_REC_MARKDIRTY'||fnd_global.local_chr(10)||
1186: 'Error: '||sqlerrm
1187: , JTM_HOOK_UTIL_PKG.g_debug_level_error);
1188: RAISE;
1189: END INSERT_ACC_REC_MARKDIRTY;
1190:
1191: /*

Line 1239: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1235: --Bug 3746689
1236: el_ctr := 1;
1237: m_ctr := 1;
1238:
1239: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1240: jtm_message_log_pkg.Log_Msg
1241: ( 0
1242: , g_table_name
1243: , 'Entering UPDATE_ACC_REC_MARKDIRTY'

Line 1244: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

1240: jtm_message_log_pkg.Log_Msg
1241: ( 0
1242: , g_table_name
1243: , 'Entering UPDATE_ACC_REC_MARKDIRTY'
1244: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
1245: );
1246: END IF;
1247:
1248: --Bug 3929942

Line 1258: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1254: SELECT MAX(LAST_UPDATE_DATE) into l_max_last_update_date_tl
1255: FROM MTL_SYSTEM_ITEMS_TL;
1256: IF(l_max_last_update_date_tl < p_last_run_date) THEN
1257: -- No updates
1258: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1259: jtm_message_log_pkg.Log_Msg
1260: ( 0
1261: , g_table_name
1262: , 'Leaving UPDATE_ACC_REC_MARKDIRTY'

Line 1263: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

1259: jtm_message_log_pkg.Log_Msg
1260: ( 0
1261: , g_table_name
1262: , 'Leaving UPDATE_ACC_REC_MARKDIRTY'
1263: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
1264: );
1265: END IF;
1266: RETURN;
1267: END IF;

Line 1295: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

1291:
1292: /*Call oracle lite*/
1293: IF l_tab_access_id.COUNT > 0 THEN
1294: /*** 1 or more acc rows retrieved -> push to resource ***/
1295: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1296: jtm_message_log_pkg.Log_Msg
1297: ( 0
1298: , g_table_name
1299: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'

Line 1300: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

1296: jtm_message_log_pkg.Log_Msg
1297: ( 0
1298: , g_table_name
1299: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'
1300: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
1301: );
1302: END IF;
1303:
1304: --Bug 3746689

Line 1351: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1347: END IF; -- end of tab_access_id count
1348: END LOOP;
1349: CLOSE c_changed;
1350:
1351: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1352: jtm_message_log_pkg.Log_Msg
1353: ( 0
1354: , g_table_name
1355: , 'Leaving UPDATE_ACC_REC_MARKDIRTY'

Line 1356: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

1352: jtm_message_log_pkg.Log_Msg
1353: ( 0
1354: , g_table_name
1355: , 'Leaving UPDATE_ACC_REC_MARKDIRTY'
1356: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
1357: );
1358: END IF;
1359: EXCEPTION
1360: WHEN OTHERS THEN

Line 1370: , JTM_HOOK_UTIL_PKG.g_debug_level_error);

1366: ( 0
1367: , g_table_name
1368: , 'UPDATE_ACC_REC_MARKDIRTY'||fnd_global.local_chr(10)||
1369: 'Error: '||sqlerrm
1370: , JTM_HOOK_UTIL_PKG.g_debug_level_error);
1371: RAISE;
1372: END UPDATE_ACC_REC_MARKDIRTY;
1373:
1374: /*

Line 1415: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1411:
1412: el_ctr := 1;
1413: m_ctr := 1;
1414:
1415: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1416: jtm_message_log_pkg.Log_Msg
1417: ( p_organization_id
1418: , g_table_name
1419: , 'Entering DELETE_ALL_ACC_REC_MARKDIRTY'

Line 1420: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

1416: jtm_message_log_pkg.Log_Msg
1417: ( p_organization_id
1418: , g_table_name
1419: , 'Entering DELETE_ALL_ACC_REC_MARKDIRTY'
1420: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
1421: );
1422: END IF;
1423:
1424: /* Delete all records for org/category */

Line 1504: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

1500: AND COUNTER = 0;
1501:
1502: IF l_tab_access_id.COUNT > 0 THEN
1503: /*** 1 or more acc rows retrieved -> push to resource ***/
1504: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1505: jtm_message_log_pkg.Log_Msg
1506: ( p_organization_id
1507: , g_table_name
1508: , 'Deleting ' || l_tab_access_id.COUNT || ' record(s) for resource: '||p_resource_id

Line 1509: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

1505: jtm_message_log_pkg.Log_Msg
1506: ( p_organization_id
1507: , g_table_name
1508: , 'Deleting ' || l_tab_access_id.COUNT || ' record(s) for resource: '||p_resource_id
1509: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
1510: );
1511: END IF;
1512:
1513: --Bug 3746689

Line 1559: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1555: DELETE JTM_MTL_SYSTEM_ITEMS_ACC
1556: WHERE ACCESS_ID = l_tab_access_id(i);
1557: END IF;
1558:
1559: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1560: jtm_message_log_pkg.Log_Msg
1561: ( p_organization_id
1562: , g_table_name
1563: , 'Leaving DELETE_ALL_ACC_REC_MARKDIRTY'

Line 1564: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

1560: jtm_message_log_pkg.Log_Msg
1561: ( p_organization_id
1562: , g_table_name
1563: , 'Leaving DELETE_ALL_ACC_REC_MARKDIRTY'
1564: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
1565: );
1566: END IF;
1567:
1568: EXCEPTION

Line 1575: , JTM_HOOK_UTIL_PKG.g_debug_level_error);

1571: ( p_organization_id
1572: , g_table_name
1573: , 'DELETE_ALL_ACC_REC_MARKDIRTY'||fnd_global.local_chr(10)||
1574: 'Error: '||sqlerrm
1575: , JTM_HOOK_UTIL_PKG.g_debug_level_error);
1576: RAISE;
1577: END DELETE_ALL_ACC_REC_MARKDIRTY;
1578:
1579: /*Private procedure that processes system item changes for a given resource */

Line 1601: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1597: WHERE resource_id = b_resource_id;
1598: r_org c_org%ROWTYPE;
1599: BEGIN
1600:
1601: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1602: jtm_message_log_pkg.Log_Msg
1603: ( 0
1604: , g_table_name
1605: , 'Entering CONCURRENT_PROCESS_USER'

Line 1606: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

1602: jtm_message_log_pkg.Log_Msg
1603: ( 0
1604: , g_table_name
1605: , 'Entering CONCURRENT_PROCESS_USER'
1606: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
1607: );
1608: END IF;
1609:
1610: /*Get inventory org and category profiles */

Line 1630: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

1626: Note that this normally should never happen since resource org
1627: record should have been inserted during user creation (even
1628: when the profile doesn't have a value yet)
1629: */
1630: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1631: jtm_message_log_pkg.Log_Msg
1632: ( 0
1633: , g_table_name
1634: , 'Resource profile record not found in csl_resource_inventory_org.' || fnd_global.local_chr(10)||

Line 1636: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

1632: ( 0
1633: , g_table_name
1634: , 'Resource profile record not found in csl_resource_inventory_org.' || fnd_global.local_chr(10)||
1635: 'Inserting all system item records without calling markdirty.'
1636: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
1637: );
1638: END IF;
1639:
1640: INSERT_ALL_ACC_RECORDS( p_resource_id => p_resource_id

Line 1685: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

1681: /*
1682: organization or category profile changed ->
1683: delete all old system items and insert new items with markdirty
1684: */
1685: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1686: jtm_message_log_pkg.Log_Msg
1687: ( 0
1688: , g_table_name
1689: , 'Inventory organization or category profiles changed.'

Line 1699: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

1695: || ', new category_set_id = ' || l_profile_category_set_id
1696: || fnd_global.local_chr(10)||
1697: 'original category_id = ' || r_org.category_id
1698: || ', new category_id = ' || l_profile_category_id
1699: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
1700: );
1701: END IF;
1702:
1703: --Bug 3841633

Line 1705: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

1701: END IF;
1702:
1703: --Bug 3841633
1704: IF (r_org.organization_id IS NOT NULL) THEN
1705: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1706: jtm_message_log_pkg.Log_Msg
1707: ( p_resource_id
1708: , g_table_name
1709: , 'Deleting records for old profile settings'

Line 1710: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

1706: jtm_message_log_pkg.Log_Msg
1707: ( p_resource_id
1708: , g_table_name
1709: , 'Deleting records for old profile settings'
1710: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
1711: END IF;
1712:
1713: DELETE_ALL_ACC_REC_MARKDIRTY( p_resource_id => p_resource_id
1714: , p_organization_id => r_org.organization_id

Line 1721: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

1717: , p_profile_org_id => l_profile_org_id
1718: );
1719: END IF;
1720:
1721: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1722: jtm_message_log_pkg.Log_Msg
1723: ( p_resource_id
1724: , g_table_name
1725: , 'Inserting records for new profile settings'

Line 1726: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

1722: jtm_message_log_pkg.Log_Msg
1723: ( p_resource_id
1724: , g_table_name
1725: , 'Inserting records for new profile settings'
1726: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
1727: END IF;
1728:
1729: INSERT_ACC_REC_MARKDIRTY( p_organization_id => l_profile_org_id
1730: , p_category_set_id => l_profile_category_set_id

Line 1737: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

1733: , p_last_run_date => NULL
1734: , p_changed => 'Y'
1735: , p_old_org_id => r_org.organization_id );
1736:
1737: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1738: jtm_message_log_pkg.Log_Msg
1739: ( p_resource_id
1740: , g_table_name
1741: , 'Updating resource profile table with new profile settings'

Line 1742: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

1738: jtm_message_log_pkg.Log_Msg
1739: ( p_resource_id
1740: , g_table_name
1741: , 'Updating resource profile table with new profile settings'
1742: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
1743: END IF;
1744:
1745: UPDATE_RESOURCE_PROFILE_REC( p_resource_id => p_resource_id
1746: , p_organization_id => l_profile_org_id

Line 1755: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

1751: organization and category profiles remained the same
1752: -> push any inserted items to resource (updates are pushed
1753: in main concurrent procedure in non-resource-specific call)
1754: */
1755: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1756: jtm_message_log_pkg.Log_Msg
1757: ( p_resource_id
1758: , g_table_name
1759: , 'Pushing inserted records for'||fnd_global.local_chr(10)||

Line 1763: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

1759: , 'Pushing inserted records for'||fnd_global.local_chr(10)||
1760: 'organization_id = ' || l_profile_org_id||fnd_global.local_chr(10)||
1761: 'category_set_id = ' || l_profile_category_set_id||fnd_global.local_chr(10)||
1762: 'category_id = ' || l_profile_category_id
1763: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
1764: END IF;
1765:
1766: INSERT_ACC_REC_MARKDIRTY( p_organization_id => l_profile_org_id
1767: , p_category_set_id => l_profile_category_set_id

Line 1778: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1774:
1775: END IF; -- c_org%NOTFOUND
1776: CLOSE c_org;
1777:
1778: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1779: jtm_message_log_pkg.Log_Msg
1780: ( 0
1781: , g_table_name
1782: , 'Leaving CONCURRENT_PROCESS_USER'

Line 1783: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

1779: jtm_message_log_pkg.Log_Msg
1780: ( 0
1781: , g_table_name
1782: , 'Leaving CONCURRENT_PROCESS_USER'
1783: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
1784: );
1785: END IF;
1786:
1787: EXCEPTION

Line 1789: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

1785: END IF;
1786:
1787: EXCEPTION
1788: WHEN OTHERS THEN
1789: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
1790: jtm_message_log_pkg.Log_Msg
1791: ( 0
1792: , g_table_name
1793: , 'Caught exception in CONCURRENT_PROCESS_USER'||fnd_global.local_chr(10)||

Line 1795: , JTM_HOOK_UTIL_PKG.g_debug_level_error);

1791: ( 0
1792: , g_table_name
1793: , 'Caught exception in CONCURRENT_PROCESS_USER'||fnd_global.local_chr(10)||
1794: 'Error: '||sqlerrm
1795: , JTM_HOOK_UTIL_PKG.g_debug_level_error);
1796: END IF;
1797: ROLLBACK;
1798: RAISE;
1799: END CONCURRENT_PROCESS_USER;

Line 1846: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

1842:
1843: l_current_run_date DATE;
1844: BEGIN
1845: /*** get debug level ***/
1846: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
1847: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1848: jtm_message_log_pkg.Log_Msg
1849: ( 0
1850: , g_table_name

Line 1847: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1843: l_current_run_date DATE;
1844: BEGIN
1845: /*** get debug level ***/
1846: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
1847: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1848: jtm_message_log_pkg.Log_Msg
1849: ( 0
1850: , g_table_name
1851: , 'Entering CON_REQUEST_MTL_SYSTEM_ITEMS'

Line 1852: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

1848: jtm_message_log_pkg.Log_Msg
1849: ( 0
1850: , g_table_name
1851: , 'Entering CON_REQUEST_MTL_SYSTEM_ITEMS'
1852: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
1853: );
1854: END IF;
1855:
1856: /*** First retrieve last run date of the conccurent program ***/

Line 1864: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

1860:
1861: l_current_run_date := SYSDATE;
1862:
1863: /*** Push updated system item records to resources ***/
1864: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1865: jtm_message_log_pkg.Log_Msg
1866: ( 0
1867: , g_table_name
1868: , 'Pushing updated records'

Line 1869: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

1865: jtm_message_log_pkg.Log_Msg
1866: ( 0
1867: , g_table_name
1868: , 'Pushing updated records'
1869: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
1870: );
1871: END IF;
1872: UPDATE_ACC_REC_MARKDIRTY( p_last_run_date => r_LastRundate.last_run_date );
1873: COMMIT;

Line 1878: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

1874:
1875: /*** Get the mobile laptop resources and loop over all of them ***/
1876: FOR r_mobile_resp IN c_mobile_resp LOOP
1877:
1878: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1879: jtm_message_log_pkg.Log_Msg
1880: ( 0
1881: , g_table_name
1882: , 'Processing resource_id = ' || r_mobile_resp.resource_id

Line 1883: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

1879: jtm_message_log_pkg.Log_Msg
1880: ( 0
1881: , g_table_name
1882: , 'Processing resource_id = ' || r_mobile_resp.resource_id
1883: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
1884: );
1885: END IF;
1886:
1887: CONCURRENT_PROCESS_USER( p_resource_id => r_mobile_resp.resource_id

Line 1900: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

1896: -- COMMIT;
1897:
1898: END LOOP;
1899:
1900: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1901: jtm_message_log_pkg.Log_Msg
1902: ( 0
1903: , g_table_name
1904: , 'Updating LAST_RUN_DATE from '||r_LastRundate.LAST_RUN_DATE||' to '||l_current_run_date

Line 1905: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

1901: jtm_message_log_pkg.Log_Msg
1902: ( 0
1903: , g_table_name
1904: , 'Updating LAST_RUN_DATE from '||r_LastRundate.LAST_RUN_DATE||' to '||l_current_run_date
1905: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
1906: );
1907: END IF;
1908:
1909: /*Update the last run date*/

Line 1917: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1913: AND procedure_name = 'CON_REQUEST_MTL_SYSTEM_ITEMS';
1914:
1915: COMMIT;
1916:
1917: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1918: jtm_message_log_pkg.Log_Msg
1919: ( 0
1920: , g_table_name
1921: , 'Leaving CON_REQUEST_MTL_SYSTEM_ITEMS'

Line 1922: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

1918: jtm_message_log_pkg.Log_Msg
1919: ( 0
1920: , g_table_name
1921: , 'Leaving CON_REQUEST_MTL_SYSTEM_ITEMS'
1922: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
1923: );
1924: END IF;
1925:
1926: EXCEPTION

Line 1928: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

1924: END IF;
1925:
1926: EXCEPTION
1927: WHEN OTHERS THEN
1928: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
1929: jtm_message_log_pkg.Log_Msg
1930: ( 0
1931: , g_table_name
1932: , 'CON_REQUEST_MTL_SYSTEM_ITEMS'||fnd_global.local_chr(10)||

Line 1934: , JTM_HOOK_UTIL_PKG.g_debug_level_error);

1930: ( 0
1931: , g_table_name
1932: , 'CON_REQUEST_MTL_SYSTEM_ITEMS'||fnd_global.local_chr(10)||
1933: 'Error: '||sqlerrm
1934: , JTM_HOOK_UTIL_PKG.g_debug_level_error);
1935: END IF;
1936: ROLLBACK;
1937: END CON_REQUEST_MTL_SYSTEM_ITEMS;
1938: