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_PARTY_CONTACTS_ACC_PKG dependencies on JTM_MESSAGE_LOG_PKG

Line 20: jtm_message_log_pkg.Log_Msg

16: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_HZ_CONTACT_POINTS');
17:
18: BEGIN
19: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
20: jtm_message_log_pkg.Log_Msg
21: ( p_contact_point_id
22: , l_table_name
23: , 'Entering INSERT_CONTACT_POINT'
24: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 28: jtm_message_log_pkg.Log_Msg

24: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
25: END IF;
26:
27: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
28: jtm_message_log_pkg.Log_Msg
29: ( p_contact_point_id
30: , l_table_name
31: , 'Inserting ACC record for resource_id = '||p_resource_id
32: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 44: jtm_message_log_pkg.Log_Msg

40: , P_RESOURCE_ID => p_resource_id
41: );
42:
43: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
44: jtm_message_log_pkg.Log_Msg
45: ( p_contact_point_id
46: , l_table_name
47: , 'Leaving INSERT_CONTACT_POINT'
48: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 65: jtm_message_log_pkg.Log_Msg

61: l_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
62: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_HZ_CONTACT_POINTS');
63: BEGIN
64: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
65: jtm_message_log_pkg.Log_Msg
66: ( p_contact_point_id
67: , l_table_name
68: , 'Entering DELETE_CONTACT_POINT'
69: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 81: jtm_message_log_pkg.Log_Msg

77: , P_RESOURCE_ID => p_resource_id
78: );
79:
80: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
81: jtm_message_log_pkg.Log_Msg
82: ( p_contact_point_id
83: , l_table_name
84: , 'Leaving DELETE_CONTACT_POINT'
85: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 115: jtm_message_log_pkg.Log_Msg

111: r_relationship c_relationship%ROWTYPE;
112:
113: BEGIN
114: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
115: jtm_message_log_pkg.Log_Msg
116: ( p_party_id
117: , l_table_name
118: , 'Entering INSERT_HZ_RELATIONSHIP'
119: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 126: jtm_message_log_pkg.Log_Msg

122: OPEN c_relationship( p_party_id );
123: FETCH c_relationship INTO r_relationship;
124: IF c_relationship%FOUND THEN
125: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
126: jtm_message_log_pkg.Log_Msg
127: ( r_relationship.relationship_id
128: , l_table_name
129: , 'Inserting ACC record for resource_id = '||p_resource_id
130: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 145: jtm_message_log_pkg.Log_Msg

141: );
142:
143: /*Call the party of this relation*/
144: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
145: jtm_message_log_pkg.Log_Msg
146: ( r_relationship.SUBJECT_ID
147: , l_table_name
148: , 'Calling the party for this relationship'
149: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 154: jtm_message_log_pkg.Log_Msg

150: END IF;
151: CSL_HZ_PARTIES_ACC_PKG.INSERT_PARTY( r_relationship.SUBJECT_ID, p_resource_id );
152: ELSE
153: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
154: jtm_message_log_pkg.Log_Msg
155: ( p_party_id
156: , l_table_name
157: , 'Could not find Relationship record'
158: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 163: jtm_message_log_pkg.Log_Msg

159: END IF;
160: END IF;
161:
162: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
163: jtm_message_log_pkg.Log_Msg
164: ( p_party_id
165: , l_table_name
166: , 'Leaving INSERT_HZ_RELATIONSHIP'
167: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 195: jtm_message_log_pkg.Log_Msg

191: r_relationship c_relationship%ROWTYPE;
192:
193: BEGIN
194: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
195: jtm_message_log_pkg.Log_Msg
196: ( p_party_id
197: , l_table_name
198: , 'Entering DELETE_HZ_RELATIONSHIP'
199: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 222: jtm_message_log_pkg.Log_Msg

218: END IF;
219: CLOSE c_relationship;
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: , l_table_name
225: , 'Leaving DELETE_HZ_RELATIONSHIP'
226: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 272: jtm_message_log_pkg.Log_Msg

268: /*** get debug level ***/
269: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
270:
271: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
272: jtm_message_log_pkg.Log_Msg
273: ( p_incident_id
274: , l_table_name
275: , 'Entering INSERT_CS_HZ_SR_CONTACTS'
276: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 285: jtm_message_log_pkg.Log_Msg

281: IF p_flow_type = CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_NORMAL OR (
282: p_flow_type = CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_HISTORY AND
283: r_contact.PRIMARY_FLAG = 'Y' ) THEN
284: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
285: jtm_message_log_pkg.Log_Msg
286: ( r_contact.SR_CONTACT_POINT_ID
287: , l_table_name
288: , 'Inserting ACC record for resource_id = '||p_resource_id
289: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 303: jtm_message_log_pkg.Log_Msg

299:
300:
301: /*Insert the contact point record*/
302: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
303: jtm_message_log_pkg.Log_Msg
304: ( r_contact.SR_CONTACT_POINT_ID
305: , l_table_name
306: , 'Calling Insert_Contact_point for contact'||r_contact.CONTACT_POINT_ID
307: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 318: jtm_message_log_pkg.Log_Msg

314: /*Get the matching record ( party / party relation / employee or organization */
315: IF r_contact.CONTACT_TYPE = 'PERSON' THEN
316: -- Call procedure for hz_parties
317: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
318: jtm_message_log_pkg.Log_Msg
319: ( r_contact.SR_CONTACT_POINT_ID
320: , l_table_name
321: , 'Contact is of type ''PERSON'''||fnd_global.local_chr(10)||
322: 'Calling the CSL_HZ_PARTIES_ACC_PKG.INSERT_PARTY'

Line 331: jtm_message_log_pkg.Log_Msg

327:
328: IF r_contact.CONTACT_TYPE = 'PARTY_RELATIONSHIP' THEN
329: -- Call procedure for hz_party_relation_ships
330: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
331: jtm_message_log_pkg.Log_Msg
332: ( r_contact.SR_CONTACT_POINT_ID
333: , l_table_name
334: , 'Contact is of type ''PARTY_RELATIONSHIP'''||fnd_global.local_chr(10)||
335: 'Calling INSERT_HZ_RELATIONSHIP'

Line 344: jtm_message_log_pkg.Log_Msg

340:
341: IF r_contact.CONTACT_TYPE = 'EMPLOYEE' THEN
342: -- Call procedure for per_all_people_f
343: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
344: jtm_message_log_pkg.Log_Msg
345: ( r_contact.SR_CONTACT_POINT_ID
346: , l_table_name
347: , 'Contact is of type ''EMPLOYEE'''||fnd_global.local_chr(10)||
348: 'Calling INSERT_PER_ALL_PEOPLE_F'

Line 357: jtm_message_log_pkg.Log_Msg

353:
354: IF r_contact.CONTACT_TYPE = 'ORGANIZATION' THEN
355: -- Call procedure for ...
356: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
357: jtm_message_log_pkg.Log_Msg
358: ( r_contact.SR_CONTACT_POINT_ID
359: , l_table_name
360: , 'Contact is of type ''ORGANIZATION'''||fnd_global.local_chr(10)||
361: 'Call to be implemented'

Line 372: jtm_message_log_pkg.Log_Msg

368:
369: /*Delete all contacts in the acc table for this incident that are no longer valid*/
370: FOR r_obsolete IN c_obsolete_contacts( b_incident_id => p_incident_id, b_resource_id => p_resource_id ) LOOP
371: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
372: jtm_message_log_pkg.Log_Msg
373: ( r_obsolete.SR_CONTACT_POINT_ID
374: , l_table_name
375: , 'Deleting contact record '||r_obsolete.SR_CONTACT_POINT_ID||fnd_global.local_chr(10)||
376: 'for resource '||p_resource_id

Line 392: jtm_message_log_pkg.Log_Msg

388: END LOOP;
389:
390: /*Done, all packages are called*/
391: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
392: jtm_message_log_pkg.Log_Msg
393: ( p_incident_id
394: , l_table_name
395: , 'Leaving INSERT_CS_HZ_SR_CONTACTS'
396: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 427: jtm_message_log_pkg.Log_Msg

423: );
424:
425: BEGIN
426: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
427: jtm_message_log_pkg.Log_Msg
428: ( p_incident_id
429: , l_table_name
430: , 'Entering DELETE_CS_HZ_SR_CONTACTS'
431: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 470: jtm_message_log_pkg.Log_Msg

466: END IF; --p_flow_id
467: END LOOP;
468:
469: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
470: jtm_message_log_pkg.Log_Msg
471: ( p_incident_id
472: , l_table_name
473: , 'Leaving DELETE_CS_HZ_SR_CONTACTS'
474: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 500: jtm_message_log_pkg.Log_Msg

496: JTM_HOOK_UTIL_PKG.t_publication_item_list('PER_ALL_PEOPLE_F');
497:
498: BEGIN
499: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
500: jtm_message_log_pkg.Log_Msg
501: ( p_person_id
502: , l_table_name
503: , 'Entering INSERT_PER_ALL_PEOPLE_F'
504: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 509: jtm_message_log_pkg.Log_Msg

505: END IF;
506:
507: FOR r_per_all_people IN c_per_all_people(b_person_id => p_person_id) LOOP
508: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
509: jtm_message_log_pkg.Log_Msg
510: ( p_person_id
511: , l_table_name
512: , 'Inserting ACC record for resource_id = '||p_resource_id
513: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 530: jtm_message_log_pkg.Log_Msg

526: );
527: END LOOP;
528:
529: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
530: jtm_message_log_pkg.Log_Msg
531: ( p_person_id
532: , l_table_name
533: , 'Leaving INSERT_PER_ALL_PEOPLE_F'
534: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 558: jtm_message_log_pkg.Log_Msg

554: JTM_HOOK_UTIL_PKG.t_publication_item_list('PER_ALL_PEOPLE_F');
555:
556: BEGIN
557: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
558: jtm_message_log_pkg.Log_Msg
559: ( p_person_id
560: , l_table_name
561: , 'Entering DELETE_PER_ALL_PEOPLE_F'
562: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 567: jtm_message_log_pkg.Log_Msg

563: END IF;
564:
565: FOR r_per_all_people IN c_per_all_people(b_person_id => p_person_id) LOOP
566: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
567: jtm_message_log_pkg.Log_Msg
568: ( p_person_id
569: , l_table_name
570: , 'Deleting ACC record for resource_id = '||p_resource_id
571: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 588: jtm_message_log_pkg.Log_Msg

584: );
585: END LOOP;
586:
587: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
588: jtm_message_log_pkg.Log_Msg
589: ( p_person_id
590: , l_table_name
591: , 'Leaving DELETE_PER_ALL_PEOPLE_F'
592: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 621: jtm_message_log_pkg.Log_Msg

617: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
618:
619:
620: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
621: jtm_message_log_pkg.Log_Msg
622: ( l_contact_point_id
623: , l_table_name
624: , 'Entering UPDATE_CONTACT_POINT_WFSUB'
625: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 637: jtm_message_log_pkg.Log_Msg

633:
634: fnd_global.apps_initialize (l_user_id, l_resp_id, l_resp_appl_id, l_security_group_id);
635:
636: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
637: jtm_message_log_pkg.Log_Msg
638: ( l_contact_point_id
639: , l_table_name
640: , 'Get parameter for hz parameter P_CONTACT_POINT_REC.CONTACT_POINT_ID'
641: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 650: jtm_message_log_pkg.Log_Msg

646: p_parameter_name => 'P_CONTACT_POINT_REC.CONTACT_POINT_ID');
647: */
648:
649: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
650: jtm_message_log_pkg.Log_Msg
651: ( l_contact_point_id
652: , l_table_name
653: , 'Retrieved parameter for hz parameter P_CONTACT_POINT_REC.CONTACT_POINT_ID ' || l_contact_point_id
654: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 679: jtm_message_log_pkg.Log_Msg

675: END LOOP;
676: END IF;
677:
678: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
679: jtm_message_log_pkg.Log_Msg
680: ( l_contact_point_id
681: , l_table_name
682: , 'Leaving UPDATE_CONTACT_POINT_WFSUB'
683: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);