APPS.CSM_CNTR_RELATION_EVENT_PKG dependencies on CSM_UTIL_PKG

Line 46: CSM_UTIL_PKG.LOG('Entering CSM_CNTR_RELATIONSHIPS_EVENT_PKG.COUNTER_RELATION_INS ',

42: AND acc.user_id = l_user_id
43: );
44: BEGIN
45:
46: CSM_UTIL_PKG.LOG('Entering CSM_CNTR_RELATIONSHIPS_EVENT_PKG.COUNTER_RELATION_INS ',
47: 'CSM_CNTR_RELATIONSHIPS_EVENT_PKG.COUNTER_RELATION_INS', FND_LOG.LEVEL_PROCEDURE);
48: --process inserts
49: FOR l_cntr_rel_rec IN csr_cntr_rel_ins(p_counter_id,p_user_id)
50: LOOP

Line 60: CSM_UTIL_PKG.LOG('Inserting counter relationship id ' || TO_CHAR(l_cntr_rel_rec.relationship_id) || ' for user '||TO_CHAR(p_user_id) , 'CSM_CNTR_RELATIONSHIPS_EVENT_PKG.COUNTER_RELATION_INS',FND_LOG.LEVEL_PROCEDURE);

56: ,P_PK1_NAME => g_cst_accnt_pk1_name
57: ,P_PK1_NUM_VALUE => l_cntr_rel_rec.relationship_id
58: ,P_USER_ID => p_user_id
59: );
60: CSM_UTIL_PKG.LOG('Inserting counter relationship id ' || TO_CHAR(l_cntr_rel_rec.relationship_id) || ' for user '||TO_CHAR(p_user_id) , 'CSM_CNTR_RELATIONSHIPS_EVENT_PKG.COUNTER_RELATION_INS',FND_LOG.LEVEL_PROCEDURE);
61:
62: END LOOP;
63: COMMIT;
64: CSM_UTIL_PKG.LOG('Leaving CSM_CNTR_RELATIONSHIPS_EVENT_PKG.COUNTER_RELATION_INS ',

Line 64: CSM_UTIL_PKG.LOG('Leaving CSM_CNTR_RELATIONSHIPS_EVENT_PKG.COUNTER_RELATION_INS ',

60: CSM_UTIL_PKG.LOG('Inserting counter relationship id ' || TO_CHAR(l_cntr_rel_rec.relationship_id) || ' for user '||TO_CHAR(p_user_id) , 'CSM_CNTR_RELATIONSHIPS_EVENT_PKG.COUNTER_RELATION_INS',FND_LOG.LEVEL_PROCEDURE);
61:
62: END LOOP;
63: COMMIT;
64: CSM_UTIL_PKG.LOG('Leaving CSM_CNTR_RELATIONSHIPS_EVENT_PKG.COUNTER_RELATION_INS ',
65: 'CSM_CNTR_RELATIONSHIPS_EVENT_PKG.COUNTER_RELATION_INS',FND_LOG.LEVEL_PROCEDURE);
66: EXCEPTION
67: WHEN others THEN
68: l_sqlerrno := to_char(SQLCODE);

Line 71: CSM_UTIL_PKG.LOG('Exception in CSM_CNTR_RELATIONSHIPS_EVENT_PKG.COUNTER_RELATION_INS: ' || l_sqlerrno || ':' || l_sqlerrmsg,

67: WHEN others THEN
68: l_sqlerrno := to_char(SQLCODE);
69: l_sqlerrmsg := substr(SQLERRM, 1,2000);
70: ROLLBACK;
71: CSM_UTIL_PKG.LOG('Exception in CSM_CNTR_RELATIONSHIPS_EVENT_PKG.COUNTER_RELATION_INS: ' || l_sqlerrno || ':' || l_sqlerrmsg,
72: 'CSM_CNTR_RELATIONSHIPS_EVENT_PKG.COUNTER_RELATION_INS',FND_LOG.LEVEL_EXCEPTION);
73: END COUNTER_RELATION_INS;
74:
75: --Deleting relationships

Line 105: CSM_UTIL_PKG.LOG('Entering CSM_CNTR_RELATIONSHIPS_EVENT_PKG.COUNTER_RELATION_DEL ',

101: AND cacc.user_id = l_user_id
102: );
103: BEGIN
104:
105: CSM_UTIL_PKG.LOG('Entering CSM_CNTR_RELATIONSHIPS_EVENT_PKG.COUNTER_RELATION_DEL ',
106: 'CSM_CNTR_RELATIONSHIPS_EVENT_PKG.COUNTER_RELATION_DEL', FND_LOG.LEVEL_PROCEDURE);
107: --process inserts
108: FOR l_cntr_rel_rec IN csr_cntr_rel_del(p_counter_id,p_user_id)
109: LOOP

Line 118: CSM_UTIL_PKG.LOG('Deleting counter relationship id ' || TO_CHAR(l_cntr_rel_rec.relationship_id) || ' for user '||TO_CHAR(p_user_id) , 'CSM_CNTR_RELATIONSHIPS_EVENT_PKG.COUNTER_RELATION_DEL',FND_LOG.LEVEL_PROCEDURE);

114: ,P_PK1_NAME => g_cst_accnt_pk1_name
115: ,P_PK1_NUM_VALUE => l_cntr_rel_rec.relationship_id
116: ,P_USER_ID => p_user_id
117: );
118: CSM_UTIL_PKG.LOG('Deleting counter relationship id ' || TO_CHAR(l_cntr_rel_rec.relationship_id) || ' for user '||TO_CHAR(p_user_id) , 'CSM_CNTR_RELATIONSHIPS_EVENT_PKG.COUNTER_RELATION_DEL',FND_LOG.LEVEL_PROCEDURE);
119:
120: END LOOP;
121: COMMIT;
122: CSM_UTIL_PKG.LOG('Leaving CSM_CNTR_RELATIONSHIPS_EVENT_PKG.COUNTER_RELATION_DEL ',

Line 122: CSM_UTIL_PKG.LOG('Leaving CSM_CNTR_RELATIONSHIPS_EVENT_PKG.COUNTER_RELATION_DEL ',

118: CSM_UTIL_PKG.LOG('Deleting counter relationship id ' || TO_CHAR(l_cntr_rel_rec.relationship_id) || ' for user '||TO_CHAR(p_user_id) , 'CSM_CNTR_RELATIONSHIPS_EVENT_PKG.COUNTER_RELATION_DEL',FND_LOG.LEVEL_PROCEDURE);
119:
120: END LOOP;
121: COMMIT;
122: CSM_UTIL_PKG.LOG('Leaving CSM_CNTR_RELATIONSHIPS_EVENT_PKG.COUNTER_RELATION_DEL ',
123: 'CSM_CNTR_RELATIONSHIPS_EVENT_PKG.COUNTER_RELATION_DEL',FND_LOG.LEVEL_PROCEDURE);
124: EXCEPTION
125: WHEN others THEN
126: l_sqlerrno := to_char(SQLCODE);

Line 129: CSM_UTIL_PKG.LOG('Exception in CSM_CNTR_RELATIONSHIPS_EVENT_PKG.COUNTER_RELATION_DEL: ' || l_sqlerrno || ':' || l_sqlerrmsg,

125: WHEN others THEN
126: l_sqlerrno := to_char(SQLCODE);
127: l_sqlerrmsg := substr(SQLERRM, 1,2000);
128: ROLLBACK;
129: CSM_UTIL_PKG.LOG('Exception in CSM_CNTR_RELATIONSHIPS_EVENT_PKG.COUNTER_RELATION_DEL: ' || l_sqlerrno || ':' || l_sqlerrmsg,
130: 'CSM_CNTR_RELATIONSHIPS_EVENT_PKG.COUNTER_RELATION_DEL',FND_LOG.LEVEL_EXCEPTION);
131: END COUNTER_RELATION_DEL;
132:
133: END CSM_CNTR_RELATION_EVENT_PKG;