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.1 2011/06/16 07:35:37 saradhak ship $ */
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 1417: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1413: WHERE resource_id = b_resource_id;
1414: r_org c_org%ROWTYPE;
1415: BEGIN
1416:
1417: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1418: jtm_message_log_pkg.Log_Msg
1419: ( 0
1420: , g_table_name
1421: , 'Entering CONCURRENT_PROCESS_USER'

Line 1422: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

1418: jtm_message_log_pkg.Log_Msg
1419: ( 0
1420: , g_table_name
1421: , 'Entering CONCURRENT_PROCESS_USER'
1422: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
1423: );
1424: END IF;
1425:
1426: /*Get inventory org and category profiles */

Line 1446: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

1442: Note that this normally should never happen since resource org
1443: record should have been inserted during user creation (even
1444: when the profile doesn't have a value yet)
1445: */
1446: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1447: jtm_message_log_pkg.Log_Msg
1448: ( 0
1449: , g_table_name
1450: , 'Resource profile record not found in csl_resource_inventory_org.' || fnd_global.local_chr(10)||

Line 1452: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

1448: ( 0
1449: , g_table_name
1450: , 'Resource profile record not found in csl_resource_inventory_org.' || fnd_global.local_chr(10)||
1451: 'Inserting all system item records without calling markdirty.'
1452: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
1453: );
1454: END IF;
1455:
1456: INSERT_ALL_ACC_RECORDS( p_resource_id => p_resource_id

Line 1501: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

1497: /*
1498: organization or category profile changed ->
1499: delete all old system items and insert new items with markdirty
1500: */
1501: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1502: jtm_message_log_pkg.Log_Msg
1503: ( 0
1504: , g_table_name
1505: , 'Inventory organization or category profiles changed.'

Line 1515: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

1511: || ', new category_set_id = ' || l_profile_category_set_id
1512: || fnd_global.local_chr(10)||
1513: 'original category_id = ' || r_org.category_id
1514: || ', new category_id = ' || l_profile_category_id
1515: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
1516: );
1517: END IF;
1518:
1519: --Bug 3841633

Line 1521: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

1517: END IF;
1518:
1519: --Bug 3841633
1520: IF (r_org.organization_id IS NOT NULL) THEN
1521: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1522: jtm_message_log_pkg.Log_Msg
1523: ( p_resource_id
1524: , g_table_name
1525: , 'Deleting records for old profile settings'

Line 1526: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

1522: jtm_message_log_pkg.Log_Msg
1523: ( p_resource_id
1524: , g_table_name
1525: , 'Deleting records for old profile settings'
1526: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
1527: END IF;
1528:
1529: DELETE_ALL_ACC_REC_MARKDIRTY( p_resource_id => p_resource_id
1530: , p_organization_id => r_org.organization_id

Line 1537: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

1533: , p_profile_org_id => l_profile_org_id
1534: );
1535: END IF;
1536:
1537: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1538: jtm_message_log_pkg.Log_Msg
1539: ( p_resource_id
1540: , g_table_name
1541: , 'Inserting records for new profile settings'

Line 1542: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

1538: jtm_message_log_pkg.Log_Msg
1539: ( p_resource_id
1540: , g_table_name
1541: , 'Inserting records for new profile settings'
1542: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
1543: END IF;
1544:
1545: INSERT_ACC_REC_MARKDIRTY( p_organization_id => l_profile_org_id
1546: , p_category_set_id => l_profile_category_set_id

Line 1553: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

1549: , p_last_run_date => NULL
1550: , p_changed => 'Y'
1551: , p_old_org_id => r_org.organization_id );
1552:
1553: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1554: jtm_message_log_pkg.Log_Msg
1555: ( p_resource_id
1556: , g_table_name
1557: , 'Updating resource profile table with new profile settings'

Line 1558: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

1554: jtm_message_log_pkg.Log_Msg
1555: ( p_resource_id
1556: , g_table_name
1557: , 'Updating resource profile table with new profile settings'
1558: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
1559: END IF;
1560:
1561: UPDATE_RESOURCE_PROFILE_REC( p_resource_id => p_resource_id
1562: , p_organization_id => l_profile_org_id

Line 1571: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

1567: organization and category profiles remained the same
1568: -> push any inserted items to resource (updates are pushed
1569: in main concurrent procedure in non-resource-specific call)
1570: */
1571: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1572: jtm_message_log_pkg.Log_Msg
1573: ( p_resource_id
1574: , g_table_name
1575: , 'Pushing inserted records for'||fnd_global.local_chr(10)||

Line 1579: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

1575: , 'Pushing inserted records for'||fnd_global.local_chr(10)||
1576: 'organization_id = ' || l_profile_org_id||fnd_global.local_chr(10)||
1577: 'category_set_id = ' || l_profile_category_set_id||fnd_global.local_chr(10)||
1578: 'category_id = ' || l_profile_category_id
1579: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
1580: END IF;
1581:
1582: INSERT_ACC_REC_MARKDIRTY( p_organization_id => l_profile_org_id
1583: , p_category_set_id => l_profile_category_set_id

Line 1594: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1590:
1591: END IF; -- c_org%NOTFOUND
1592: CLOSE c_org;
1593:
1594: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1595: jtm_message_log_pkg.Log_Msg
1596: ( 0
1597: , g_table_name
1598: , 'Leaving CONCURRENT_PROCESS_USER'

Line 1599: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

1595: jtm_message_log_pkg.Log_Msg
1596: ( 0
1597: , g_table_name
1598: , 'Leaving CONCURRENT_PROCESS_USER'
1599: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
1600: );
1601: END IF;
1602:
1603: EXCEPTION

Line 1605: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

1601: END IF;
1602:
1603: EXCEPTION
1604: WHEN OTHERS THEN
1605: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
1606: jtm_message_log_pkg.Log_Msg
1607: ( 0
1608: , g_table_name
1609: , 'Caught exception in CONCURRENT_PROCESS_USER'||fnd_global.local_chr(10)||

Line 1611: , JTM_HOOK_UTIL_PKG.g_debug_level_error);

1607: ( 0
1608: , g_table_name
1609: , 'Caught exception in CONCURRENT_PROCESS_USER'||fnd_global.local_chr(10)||
1610: 'Error: '||sqlerrm
1611: , JTM_HOOK_UTIL_PKG.g_debug_level_error);
1612: END IF;
1613: ROLLBACK;
1614: RAISE;
1615: END CONCURRENT_PROCESS_USER;

Line 1662: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

1658:
1659: l_current_run_date DATE;
1660: BEGIN
1661: /*** get debug level ***/
1662: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
1663: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1664: jtm_message_log_pkg.Log_Msg
1665: ( 0
1666: , g_table_name

Line 1663: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1659: l_current_run_date DATE;
1660: BEGIN
1661: /*** get debug level ***/
1662: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
1663: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1664: jtm_message_log_pkg.Log_Msg
1665: ( 0
1666: , g_table_name
1667: , 'Entering CON_REQUEST_MTL_SYSTEM_ITEMS'

Line 1668: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

1664: jtm_message_log_pkg.Log_Msg
1665: ( 0
1666: , g_table_name
1667: , 'Entering CON_REQUEST_MTL_SYSTEM_ITEMS'
1668: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
1669: );
1670: END IF;
1671:
1672: /*** First retrieve last run date of the conccurent program ***/

Line 1680: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

1676:
1677: l_current_run_date := SYSDATE;
1678:
1679: /*** Push updated system item records to resources ***/
1680: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1681: jtm_message_log_pkg.Log_Msg
1682: ( 0
1683: , g_table_name
1684: , 'Pushing updated records'

Line 1685: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

1681: jtm_message_log_pkg.Log_Msg
1682: ( 0
1683: , g_table_name
1684: , 'Pushing updated records'
1685: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
1686: );
1687: END IF;
1688: UPDATE_ACC_REC_MARKDIRTY( p_last_run_date => r_LastRundate.last_run_date );
1689: COMMIT;

Line 1694: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

1690:
1691: /*** Get the mobile laptop resources and loop over all of them ***/
1692: FOR r_mobile_resp IN c_mobile_resp LOOP
1693:
1694: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1695: jtm_message_log_pkg.Log_Msg
1696: ( 0
1697: , g_table_name
1698: , 'Processing resource_id = ' || r_mobile_resp.resource_id

Line 1699: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

1695: jtm_message_log_pkg.Log_Msg
1696: ( 0
1697: , g_table_name
1698: , 'Processing resource_id = ' || r_mobile_resp.resource_id
1699: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
1700: );
1701: END IF;
1702:
1703: CONCURRENT_PROCESS_USER( p_resource_id => r_mobile_resp.resource_id

Line 1716: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

1712: -- COMMIT;
1713:
1714: END LOOP;
1715:
1716: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1717: jtm_message_log_pkg.Log_Msg
1718: ( 0
1719: , g_table_name
1720: , 'Updating LAST_RUN_DATE from '||r_LastRundate.LAST_RUN_DATE||' to '||l_current_run_date

Line 1721: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

1717: jtm_message_log_pkg.Log_Msg
1718: ( 0
1719: , g_table_name
1720: , 'Updating LAST_RUN_DATE from '||r_LastRundate.LAST_RUN_DATE||' to '||l_current_run_date
1721: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
1722: );
1723: END IF;
1724:
1725: /*Update the last run date*/

Line 1733: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1729: AND procedure_name = 'CON_REQUEST_MTL_SYSTEM_ITEMS';
1730:
1731: COMMIT;
1732:
1733: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1734: jtm_message_log_pkg.Log_Msg
1735: ( 0
1736: , g_table_name
1737: , 'Leaving CON_REQUEST_MTL_SYSTEM_ITEMS'

Line 1738: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

1734: jtm_message_log_pkg.Log_Msg
1735: ( 0
1736: , g_table_name
1737: , 'Leaving CON_REQUEST_MTL_SYSTEM_ITEMS'
1738: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
1739: );
1740: END IF;
1741:
1742: EXCEPTION

Line 1744: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

1740: END IF;
1741:
1742: EXCEPTION
1743: WHEN OTHERS THEN
1744: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
1745: jtm_message_log_pkg.Log_Msg
1746: ( 0
1747: , g_table_name
1748: , 'CON_REQUEST_MTL_SYSTEM_ITEMS'||fnd_global.local_chr(10)||

Line 1750: , JTM_HOOK_UTIL_PKG.g_debug_level_error);

1746: ( 0
1747: , g_table_name
1748: , 'CON_REQUEST_MTL_SYSTEM_ITEMS'||fnd_global.local_chr(10)||
1749: 'Error: '||sqlerrm
1750: , JTM_HOOK_UTIL_PKG.g_debug_level_error);
1751: END IF;
1752: ROLLBACK;
1753: END CON_REQUEST_MTL_SYSTEM_ITEMS;
1754: