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_MESSAGE_LOG_PKG

Line 31: jtm_message_log_pkg.Log_Msg

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'
35: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 39: jtm_message_log_pkg.Log_Msg

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'
43: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 88: jtm_message_log_pkg.Log_Msg

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'
92: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 113: jtm_message_log_pkg.Log_Msg

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 ||
117: ' inserted record(s) to resource: '||p_resource_id

Line 143: jtm_message_log_pkg.Log_Msg

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'
147: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 153: jtm_message_log_pkg.Log_Msg

149: END IF;
150:
151: EXCEPTION
152: WHEN OTHERS THEN
153: jtm_message_log_pkg.Log_Msg
154: ( p_organization_id
155: , g_table_name
156: , 'INSERT_ACC_REC_MARKDIRTY_EXP'||fnd_global.local_chr(10)||
157: 'Error: '||sqlerrm

Line 189: jtm_message_log_pkg.Log_Msg

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
192: , 'Entering Insert_ACC_Record'
193: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 199: jtm_message_log_pkg.Log_Msg

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
202: , 'Inserting ACC record for resource_id = ' || p_resource_id
203: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 243: jtm_message_log_pkg.Log_Msg

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
246: , 'Leaving Insert_ACC_Record'
247: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 275: jtm_message_log_pkg.Log_Msg

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
278: , 'Entering Delete_ACC_Record'
279: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 285: jtm_message_log_pkg.Log_Msg

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
288: , 'Deleting ACC record for resource_id = ' || p_resource_id
289: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 331: jtm_message_log_pkg.Log_Msg

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
334: , 'Leaving Delete_ACC_Record'
335: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 355: jtm_message_log_pkg.Log_Msg

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
358: , 'Entering Pre_Insert_Child'
359: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 376: jtm_message_log_pkg.Log_Msg

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
379: , 'Leaving Pre_Insert_Child'
380: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 403: jtm_message_log_pkg.Log_Msg

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
406: , 'Entering Post_Delete_Child'
407: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 432: jtm_message_log_pkg.Log_Msg

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
435: , 'Leaving Post_Delete_Child'
436: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 512: jtm_message_log_pkg.Log_Msg

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'
516: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 539: jtm_message_log_pkg.Log_Msg

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'
543: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 548: jtm_message_log_pkg.Log_Msg

544: );
545: END IF;
546: EXCEPTION
547: WHEN OTHERS THEN
548: jtm_message_log_pkg.Log_Msg
549: ( p_resource_id
550: , g_table_name
551: , 'DELETE_ALL_ACC_RECORDS'||fnd_global.local_chr(10)||
552: 'Error: '||sqlerrm

Line 599: jtm_message_log_pkg.Log_Msg

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'
603: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 613: jtm_message_log_pkg.Log_Msg

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'
617: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR

Line 728: jtm_message_log_pkg.Log_Msg

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'
732: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 741: jtm_message_log_pkg.Log_Msg

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)||
745: 'Error: '||sqlerrm

Line 891: jtm_message_log_pkg.Log_Msg

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'
895: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 902: jtm_message_log_pkg.Log_Msg

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
906: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 980: jtm_message_log_pkg.Log_Msg

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
984: || ' inserted record(s) to resource: '||p_resource_id

Line 1031: jtm_message_log_pkg.Log_Msg

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
1035: || ' inserted record(s) to resource: '||p_resource_id

Line 1082: jtm_message_log_pkg.Log_Msg

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
1086: || ' inserted record(s) to resource: '||p_resource_id

Line 1133: jtm_message_log_pkg.Log_Msg

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
1137: || ' inserted record(s) to resource: '||p_resource_id

Line 1173: jtm_message_log_pkg.Log_Msg

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'
1177: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 1182: jtm_message_log_pkg.Log_Msg

1178: );
1179: END IF;
1180: EXCEPTION
1181: WHEN OTHERS THEN
1182: jtm_message_log_pkg.Log_Msg
1183: ( p_organization_id
1184: , g_table_name
1185: , 'INSERT_ACC_REC_MARKDIRTY'||fnd_global.local_chr(10)||
1186: 'Error: '||sqlerrm

Line 1240: jtm_message_log_pkg.Log_Msg

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'
1244: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 1259: jtm_message_log_pkg.Log_Msg

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'
1263: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 1296: jtm_message_log_pkg.Log_Msg

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)'
1300: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 1352: jtm_message_log_pkg.Log_Msg

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'
1356: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 1365: jtm_message_log_pkg.Log_Msg

1361: IF c_changed%ISOPEN THEN
1362: CLOSE c_changed;
1363: END IF;
1364:
1365: jtm_message_log_pkg.Log_Msg
1366: ( 0
1367: , g_table_name
1368: , 'UPDATE_ACC_REC_MARKDIRTY'||fnd_global.local_chr(10)||
1369: 'Error: '||sqlerrm

Line 1418: jtm_message_log_pkg.Log_Msg

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'
1422: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 1447: jtm_message_log_pkg.Log_Msg

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)||
1451: 'Inserting all system item records without calling markdirty.'

Line 1502: jtm_message_log_pkg.Log_Msg

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.'
1506: || fnd_global.local_chr(10)||

Line 1522: jtm_message_log_pkg.Log_Msg

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'
1526: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 1538: jtm_message_log_pkg.Log_Msg

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'
1542: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 1554: jtm_message_log_pkg.Log_Msg

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'
1558: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 1572: jtm_message_log_pkg.Log_Msg

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)||
1576: 'organization_id = ' || l_profile_org_id||fnd_global.local_chr(10)||

Line 1595: jtm_message_log_pkg.Log_Msg

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'
1599: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 1606: jtm_message_log_pkg.Log_Msg

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)||
1610: 'Error: '||sqlerrm

Line 1664: jtm_message_log_pkg.Log_Msg

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'
1668: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 1681: jtm_message_log_pkg.Log_Msg

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'
1685: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 1695: jtm_message_log_pkg.Log_Msg

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
1699: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 1717: jtm_message_log_pkg.Log_Msg

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
1721: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 1734: jtm_message_log_pkg.Log_Msg

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'
1738: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 1745: jtm_message_log_pkg.Log_Msg

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)||
1749: 'Error: '||sqlerrm