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 1416: jtm_message_log_pkg.Log_Msg

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

Line 1505: jtm_message_log_pkg.Log_Msg

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

Line 1560: jtm_message_log_pkg.Log_Msg

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

Line 1570: jtm_message_log_pkg.Log_Msg

1566: END IF;
1567:
1568: EXCEPTION
1569: WHEN OTHERS THEN
1570: jtm_message_log_pkg.Log_Msg
1571: ( p_organization_id
1572: , g_table_name
1573: , 'DELETE_ALL_ACC_REC_MARKDIRTY'||fnd_global.local_chr(10)||
1574: 'Error: '||sqlerrm

Line 1602: jtm_message_log_pkg.Log_Msg

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

Line 1631: jtm_message_log_pkg.Log_Msg

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

Line 1686: jtm_message_log_pkg.Log_Msg

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

Line 1706: jtm_message_log_pkg.Log_Msg

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

Line 1722: jtm_message_log_pkg.Log_Msg

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

Line 1738: jtm_message_log_pkg.Log_Msg

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

Line 1756: jtm_message_log_pkg.Log_Msg

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

Line 1779: jtm_message_log_pkg.Log_Msg

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

Line 1790: jtm_message_log_pkg.Log_Msg

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

Line 1848: jtm_message_log_pkg.Log_Msg

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

Line 1865: jtm_message_log_pkg.Log_Msg

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

Line 1879: jtm_message_log_pkg.Log_Msg

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

Line 1901: jtm_message_log_pkg.Log_Msg

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

Line 1918: jtm_message_log_pkg.Log_Msg

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

Line 1929: jtm_message_log_pkg.Log_Msg

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