DBA Data[Home] [Help]

APPS.CSL_HZ_PARTIES_ACC_PKG dependencies on JTM_MESSAGE_LOG_PKG

Line 26: jtm_message_log_pkg.Log_Msg

22: r_party c_party%ROWTYPE;
23: BEGIN
24: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
25: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
26: jtm_message_log_pkg.Log_Msg
27: ( p_party_id
28: , g_table_name
29: , 'Entering Replicate_Record'
30: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 38: jtm_message_log_pkg.Log_Msg

34: FETCH c_party INTO r_party;
35: IF c_party%FOUND THEN
36: CLOSE c_party;
37: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
38: jtm_message_log_pkg.Log_Msg
39: ( p_party_id
40: , g_table_name
41: , 'Replicate_record returned TRUE'
42: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 48: jtm_message_log_pkg.Log_Msg

44: RETURN TRUE;
45: END IF;
46: CLOSE c_party;
47: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
48: jtm_message_log_pkg.Log_Msg
49: ( p_party_id
50: , g_table_name
51: , 'Replicate_record returned FALSE'||fnd_global.local_chr(10)||
52: 'Could not find party with party_id: '||p_party_id

Line 67: jtm_message_log_pkg.Log_Msg

63: , p_resource_id IN NUMBER )
64: IS
65: BEGIN
66: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
67: jtm_message_log_pkg.Log_Msg
68: ( p_party_id
69: , g_table_name
70: , 'Entering Insert_Acc_Record'
71: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 75: jtm_message_log_pkg.Log_Msg

71: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
72: END IF;
73:
74: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
75: jtm_message_log_pkg.Log_Msg
76: ( p_party_id
77: , g_table_name
78: , 'Inserting ACC record for resource_id = '||p_resource_id
79: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 91: jtm_message_log_pkg.Log_Msg

87: , P_RESOURCE_ID => p_resource_id
88: );
89:
90: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
91: jtm_message_log_pkg.Log_Msg
92: ( p_party_id
93: , g_table_name
94: , 'Leaving Insert_Acc_Record'
95: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 109: jtm_message_log_pkg.Log_Msg

105: , p_resource_id IN NUMBER )
106: IS
107: BEGIN
108: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
109: jtm_message_log_pkg.Log_Msg
110: ( p_party_id
111: , g_table_name
112: , 'Entering Update_Acc_Record'
113: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 117: jtm_message_log_pkg.Log_Msg

113: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
114: END IF;
115:
116: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
117: jtm_message_log_pkg.Log_Msg
118: ( p_party_id
119: , g_table_name
120: , 'Updating ACC record for resource_id = ' || p_resource_id || fnd_global.local_chr(10)
121: || 'access_id = ' ||p_access_id

Line 133: jtm_message_log_pkg.Log_Msg

129: , P_ACCESS_ID => p_access_id
130: );
131:
132: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
133: jtm_message_log_pkg.Log_Msg
134: ( p_party_id
135: , g_table_name
136: , 'Leaving Update_Acc_Record'
137: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 149: jtm_message_log_pkg.Log_Msg

145: , p_resource_id IN NUMBER )
146: IS
147: BEGIN
148: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
149: jtm_message_log_pkg.Log_Msg
150: ( p_party_id
151: , g_table_name
152: , 'Entering Delete_Acc_Record'
153: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 157: jtm_message_log_pkg.Log_Msg

153: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
154: END IF;
155:
156: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
157: jtm_message_log_pkg.Log_Msg
158: ( p_party_id
159: , g_table_name
160: , 'Deleting party '|| p_party_id ||' for resource_id = ' || p_resource_id
161: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 173: jtm_message_log_pkg.Log_Msg

169: ,P_RESOURCE_ID => p_resource_id
170: );
171:
172: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
173: jtm_message_log_pkg.Log_Msg
174: ( p_party_id
175: , g_table_name
176: , 'Leaving Delete_Acc_Record'
177: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 193: jtm_message_log_pkg.Log_Msg

189: BEGIN
190: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
191:
192: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
193: jtm_message_log_pkg.Log_Msg
194: ( p_party_id
195: , g_table_name
196: , 'Entering Insert_Party'
197: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 206: jtm_message_log_pkg.Log_Msg

202:
203: INSERT_ACC_RECORD( p_party_id, p_resource_id );
204:
205: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
206: jtm_message_log_pkg.Log_Msg
207: ( p_party_id
208: , g_table_name
209: , 'Get the notes for this party'
210: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 222: jtm_message_log_pkg.Log_Msg

218: END IF;--p_flow_type
219: END IF;
220:
221: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
222: jtm_message_log_pkg.Log_Msg
223: ( p_party_id
224: , g_table_name
225: , 'Leaving Insert_Party'
226: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 241: jtm_message_log_pkg.Log_Msg

237: l_tab_access_id dbms_sql.Number_Table;
238: BEGIN
239: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
240: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
241: jtm_message_log_pkg.Log_Msg
242: ( p_party_id
243: , g_table_name
244: , 'Entering Update_Party'
245: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 266: jtm_message_log_pkg.Log_Msg

262: END LOOP;
263: END IF;
264:
265: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
266: jtm_message_log_pkg.Log_Msg
267: ( p_party_id
268: , g_table_name
269: , 'Leaving Update_Party'
270: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 284: jtm_message_log_pkg.Log_Msg

280: IS
281: BEGIN
282: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
283: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
284: jtm_message_log_pkg.Log_Msg
285: ( p_party_id
286: , g_table_name
287: , 'Entering Delete_Party'
288: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 294: jtm_message_log_pkg.Log_Msg

290:
291: DELETE_ACC_RECORD( p_party_id, p_resource_id );
292:
293: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
294: jtm_message_log_pkg.Log_Msg
295: ( p_party_id
296: , g_table_name
297: , 'Delete the notes for this party'
298: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 309: jtm_message_log_pkg.Log_Msg

305: , P_RESOURCE_ID => p_resource_id );
306: END IF;
307:
308: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
309: jtm_message_log_pkg.Log_Msg
310: ( p_party_id
311: , g_table_name
312: , 'Leaving Delete_Party'
313: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 329: jtm_message_log_pkg.Log_Msg

325: l_return BOOLEAN;
326: BEGIN
327: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
328: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
329: jtm_message_log_pkg.Log_Msg
330: ( p_old_party_id
331: , g_table_name
332: , 'Entering Change_Party'
333: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 337: jtm_message_log_pkg.Log_Msg

333: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
334: END IF;
335:
336: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
337: jtm_message_log_pkg.Log_Msg
338: ( p_old_party_id
339: , g_table_name
340: , 'Change party from '||p_old_party_id||' to '||p_new_party_id
341: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 349: jtm_message_log_pkg.Log_Msg

345: /*Party is changed so delete the old one ( basicly we lower the counter )*/
346: DELETE_ACC_RECORD( p_old_party_id, p_resource_id );
347:
348: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
349: jtm_message_log_pkg.Log_Msg
350: ( p_old_party_id
351: , g_table_name
352: , 'Delete the notes for the old party'
353: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 365: jtm_message_log_pkg.Log_Msg

361: IF l_return = TRUE THEN
362: /*Insert the new party*/
363: INSERT_ACC_RECORD( p_new_party_id, p_resource_id );
364: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
365: jtm_message_log_pkg.Log_Msg
366: ( p_new_party_id
367: , g_table_name
368: , 'Insert the notes for the new party'
369: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 379: jtm_message_log_pkg.Log_Msg

375: , P_RESOURCE_ID => p_resource_id );
376: END IF;
377:
378: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
379: jtm_message_log_pkg.Log_Msg
380: ( p_old_party_id
381: , g_table_name
382: , 'Leaving Change_Party'
383: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 429: jtm_message_log_pkg.Log_Msg

425: /*TODO get the party id from the hook api*/
426: l_party_id := 0;
427:
428: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
429: jtm_message_log_pkg.Log_Msg
430: ( l_party_id
431: , g_table_name
432: , 'Entering POST_UPDATE_PARTY'
433: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 437: jtm_message_log_pkg.Log_Msg

433: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
434: END IF;
435:
436: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
437: jtm_message_log_pkg.Log_Msg
438: ( l_party_id
439: , g_table_name
440: , 'Check if a resource has this party'
441: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 466: jtm_message_log_pkg.Log_Msg

462: END IF;
463: END IF;
464:
465: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
466: jtm_message_log_pkg.Log_Msg
467: ( l_party_id
468: , g_table_name
469: , 'Leaving POST_UPDATE_PARTY'
470: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 510: jtm_message_log_pkg.Log_Msg

506: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
507:
508:
509: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
510: jtm_message_log_pkg.Log_Msg
511: ( l_party_id
512: , g_table_name
513: , 'Entering UPDATE_PARTY_WFSUB'
514: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 526: jtm_message_log_pkg.Log_Msg

522:
523: fnd_global.apps_initialize (l_user_id, l_resp_id, l_resp_appl_id, l_security_group_id);
524:
525: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
526: jtm_message_log_pkg.Log_Msg
527: ( l_party_id
528: , g_table_name
529: , 'Get parameter for hz parameter P_ORGANIZATION_REC.PARTY_REC.PARTY_ID'
530: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 540: jtm_message_log_pkg.Log_Msg

536: p_parameter_name => 'P_ORGANIZATION_REC.PARTY_REC.PARTY_ID');
537: */
538:
539: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
540: jtm_message_log_pkg.Log_Msg
541: ( l_party_id
542: , g_table_name
543: , 'Retrieved parameter for hz parameter P_ORGANIZATION_REC.PARTY_REC.PARTY_ID ' || l_party_id
544: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 553: jtm_message_log_pkg.Log_Msg

549: UPDATE_PARTY(l_party_id);
550: -- END IF;
551:
552: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
553: jtm_message_log_pkg.Log_Msg
554: ( l_party_id
555: , g_table_name
556: , 'Leaving UPDATE_PARTY_WFSUB'
557: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);