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.CSM_ITEM_INSTANCE_EVENT_PKG dependencies on CSM_UTIL_PKG

Line 41: CSM_UTIL_PKG.LOG('Entering CSM_ITEM_INSTANCE_EVENT_PKG.ITEM_INSTANCE_MDIRTY_U_ECHUSER ',

37: WHERE instance_id = p_instance_id;
38:
39: BEGIN
40: x_return_status := FND_API.G_RET_STS_SUCCESS;
41: CSM_UTIL_PKG.LOG('Entering CSM_ITEM_INSTANCE_EVENT_PKG.ITEM_INSTANCE_MDIRTY_U_ECHUSER ',
42: 'CSM_ITEM_INSTANCE_EVENT_PKG.ITEM_INSTANCE_MDIRTY_U_ECHUSER',FND_LOG.LEVEL_PROCEDURE);
43:
44: -- get users who have access to this instance_ID
45: FOR r_instance_users_rec in l_instance_users_csr(p_instance_id) LOOP

Line 55: CSM_UTIL_PKG.LOG('Leaving CSM_ITEM_INSTANCE_EVENT_PKG.ITEM_INSTANCE_MDIRTY_U_ECHUSER ',

51: );
52: END LOOP;
53:
54: p_error_msg := 'SUCCESS';
55: CSM_UTIL_PKG.LOG('Leaving CSM_ITEM_INSTANCE_EVENT_PKG.ITEM_INSTANCE_MDIRTY_U_ECHUSER ',
56: 'CSM_ITEM_INSTANCE_EVENT_PKG.ITEM_INSTANCE_MDIRTY_U_ECHUSER',FND_LOG.LEVEL_PROCEDURE);
57:
58: EXCEPTION
59: WHEN others THEN

Line 62: CSM_UTIL_PKG.LOG(p_error_msg,'CSM_ITEM_INSTANCE_EVENT_PKG.ITEM_INSTANCE_MDIRTY_U_ECHUSER',FND_LOG.LEVEL_EXCEPTION);

58: EXCEPTION
59: WHEN others THEN
60: x_return_status := FND_API.G_RET_STS_ERROR;
61: p_error_msg := 'FAILED ITEM_INSTANCE_MDIRTY_U_ECHUSER InstanceId:' || p_instance_id;
62: CSM_UTIL_PKG.LOG(p_error_msg,'CSM_ITEM_INSTANCE_EVENT_PKG.ITEM_INSTANCE_MDIRTY_U_ECHUSER',FND_LOG.LEVEL_EXCEPTION);
63: RAISE;
64: END ITEM_INSTANCE_MDIRTY_U_ECHUSER;
65:
66: PROCEDURE II_RELATIONSHIPS_ACC_I(p_relationship_id IN NUMBER,

Line 73: CSM_UTIL_PKG.LOG('Entering CSM_ITEM_INSTANCE_EVENT_PKG.II_RELATIONSHIPS_ACC_I ',

69: x_return_status IN OUT NOCOPY VARCHAR2)
70: IS
71: BEGIN
72: x_return_status := FND_API.G_RET_STS_SUCCESS;
73: CSM_UTIL_PKG.LOG('Entering CSM_ITEM_INSTANCE_EVENT_PKG.II_RELATIONSHIPS_ACC_I ',
74: 'CSM_ITEM_INSTANCE_EVENT_PKG.II_RELATIONSHIPS_ACC_I',FND_LOG.LEVEL_PROCEDURE);
75:
76: CSM_ACC_PKG.Insert_Acc
77: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name2

Line 86: CSM_UTIL_PKG.LOG('Leaving CSM_ITEM_INSTANCE_EVENT_PKG.II_RELATIONSHIPS_ACC_I ',

82: ,P_USER_ID => p_user_id
83: );
84:
85: p_error_msg := 'SUCCESS';
86: CSM_UTIL_PKG.LOG('Leaving CSM_ITEM_INSTANCE_EVENT_PKG.II_RELATIONSHIPS_ACC_I ',
87: 'CSM_ITEM_INSTANCE_EVENT_PKG.II_RELATIONSHIPS_ACC_I', FND_LOG.LEVEL_PROCEDURE);
88:
89: EXCEPTION
90: WHEN others THEN

Line 93: CSM_UTIL_PKG.LOG(p_error_msg, 'CSM_ITEM_INSTANCE_EVENT_PKG.II_RELATIONSHIPS_ACC_I',FND_LOG.LEVEL_EXCEPTION);

89: EXCEPTION
90: WHEN others THEN
91: x_return_status := FND_API.G_RET_STS_ERROR;
92: p_error_msg := ' FAILED II_RELATIONSHIPS_ACC_I RELATIONSHIP_ID: ' || to_char(p_relationship_id);
93: CSM_UTIL_PKG.LOG(p_error_msg, 'CSM_ITEM_INSTANCE_EVENT_PKG.II_RELATIONSHIPS_ACC_I',FND_LOG.LEVEL_EXCEPTION);
94: RAISE;
95: END II_RELATIONSHIPS_ACC_I;
96:
97: PROCEDURE ITEM_INSTANCES_ACC_PROCESSOR(p_instance_id IN NUMBER,

Line 125: CSM_UTIL_PKG.LOG('Entering CSM_ITEM_INSTANCE_EVENT_PKG.ITEM_INSTANCES_ACC_PROCESSOR ',

121: AND CIR.SUBJECT_ID = c_instance_id;
122:
123: BEGIN
124: x_return_status := FND_API.G_RET_STS_SUCCESS;
125: CSM_UTIL_PKG.LOG('Entering CSM_ITEM_INSTANCE_EVENT_PKG.ITEM_INSTANCES_ACC_PROCESSOR ',
126: 'CSM_ITEM_INSTANCE_EVENT_PKG.ITEM_INSTANCES_ACC_PROCESSOR',FND_LOG.LEVEL_PROCEDURE);
127:
128: IF p_instance_id IS NOT NULL AND p_user_id IS NOT NULL THEN
129: CSM_ACC_PKG.Insert_Acc

Line 173: CSM_UTIL_PKG.LOG('Leaving CSM_ITEM_INSTANCE_EVENT_PKG.ITEM_INSTANCES_ACC_PROCESSOR ',

169: END IF;
170: END IF;
171:
172: p_error_msg := 'SUCCESS';
173: CSM_UTIL_PKG.LOG('Leaving CSM_ITEM_INSTANCE_EVENT_PKG.ITEM_INSTANCES_ACC_PROCESSOR ',
174: 'CSM_ITEM_INSTANCE_EVENT_PKG.ITEM_INSTANCES_ACC_PROCESSOR',FND_LOG.LEVEL_PROCEDURE);
175: EXCEPTION
176: WHEN others THEN
177: x_return_status := FND_API.G_RET_STS_ERROR;

Line 179: CSM_UTIL_PKG.LOG(p_error_msg, 'CSM_ITEM_INSTANCE_EVENT_PKG.ITEM_INSTANCES_ACC_PROCESSOR',FND_LOG.LEVEL_EXCEPTION);

175: EXCEPTION
176: WHEN others THEN
177: x_return_status := FND_API.G_RET_STS_ERROR;
178: p_error_msg := ' FAILED ITEM_INSTANCES_ACC_PROCESSOR INSTANCE_ID: ' || to_char(p_instance_id);
179: CSM_UTIL_PKG.LOG(p_error_msg, 'CSM_ITEM_INSTANCE_EVENT_PKG.ITEM_INSTANCES_ACC_PROCESSOR',FND_LOG.LEVEL_EXCEPTION);
180: RAISE;
181: END ITEM_INSTANCES_ACC_PROCESSOR;
182:
183: PROCEDURE II_RELATIONSHIPS_ACC_D(p_relationship_id IN NUMBER,

Line 190: CSM_UTIL_PKG.LOG('Entering CSM_ITEM_INSTANCE_EVENT_PKG.II_RELATIONSHIPS_ACC_D ',

186: x_return_status IN OUT NOCOPY VARCHAR2)
187: IS
188: BEGIN
189: x_return_status := FND_API.G_RET_STS_SUCCESS;
190: CSM_UTIL_PKG.LOG('Entering CSM_ITEM_INSTANCE_EVENT_PKG.II_RELATIONSHIPS_ACC_D ',
191: 'CSM_ITEM_INSTANCE_EVENT_PKG.II_RELATIONSHIPS_ACC_D',FND_LOG.LEVEL_PROCEDURE);
192:
193: CSM_ACC_PKG.Delete_Acc
194: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name2

Line 202: CSM_UTIL_PKG.LOG('Leaving CSM_ITEM_INSTANCE_EVENT_PKG.II_RELATIONSHIPS_ACC_D',

198: ,P_USER_ID => p_user_id
199: );
200:
201: p_error_msg := 'SUCCESS';
202: CSM_UTIL_PKG.LOG('Leaving CSM_ITEM_INSTANCE_EVENT_PKG.II_RELATIONSHIPS_ACC_D',
203: 'CSM_ITEM_INSTANCE_EVENT_PKG.II_RELATIONSHIPS_ACC_D', FND_LOG.LEVEL_PROCEDURE);
204:
205: EXCEPTION
206: WHEN others THEN

Line 209: CSM_UTIL_PKG.LOG(p_error_msg, 'CSM_ITEM_INSTANCE_EVENT_PKG.II_RELATIONSHIPS_ACC_D',FND_LOG.LEVEL_EXCEPTION);

205: EXCEPTION
206: WHEN others THEN
207: x_return_status := FND_API.G_RET_STS_ERROR;
208: p_error_msg := ' FAILED II_RELATIONSHIPS_ACC_D RELATIONSHIP_ID: ' || to_char(p_relationship_id);
209: CSM_UTIL_PKG.LOG(p_error_msg, 'CSM_ITEM_INSTANCE_EVENT_PKG.II_RELATIONSHIPS_ACC_D',FND_LOG.LEVEL_EXCEPTION);
210: RAISE;
211: END II_RELATIONSHIPS_ACC_D;
212:
213: PROCEDURE ITEM_INSTANCES_ACC_D(p_instance_id IN NUMBER,

Line 240: CSM_UTIL_PKG.LOG('Entering CSM_ITEM_INSTANCE_EVENT_PKG.ITEM_INSTANCES_ACC_D ',

236: l_lst_vld_org_id NUMBER;
237:
238: BEGIN
239: x_return_status := FND_API.G_RET_STS_SUCCESS;
240: CSM_UTIL_PKG.LOG('Entering CSM_ITEM_INSTANCE_EVENT_PKG.ITEM_INSTANCES_ACC_D ',
241: 'CSM_ITEM_INSTANCE_EVENT_PKG.ITEM_INSTANCES_ACC_D',FND_LOG.LEVEL_PROCEDURE);
242:
243: OPEN l_check_instance_ref(p_instance_id, p_user_id) ;
244: FETCH l_check_instance_REF INTO l_REF_EXISTS ;

Line 273: CSM_UTIL_PKG.LOG('Leaving CSM_ITEM_INSTANCE_EVENT_PKG.ITEM_INSTANCES_ACC_D ',

269: x_return_status);
270:
271: END IF ;
272:
273: CSM_UTIL_PKG.LOG('Leaving CSM_ITEM_INSTANCE_EVENT_PKG.ITEM_INSTANCES_ACC_D ',
274: 'CSM_ITEM_INSTANCE_EVENT_PKG.ITEM_INSTANCES_ACC_D',FND_LOG.LEVEL_PROCEDURE);
275:
276: EXCEPTION
277: WHEN others THEN

Line 280: CSM_UTIL_PKG.LOG(p_error_msg,'CSM_ITEM_INSTANCE_EVENT_PKG.ITEM_INSTANCES_ACC_D',FND_LOG.LEVEL_EXCEPTION);

276: EXCEPTION
277: WHEN others THEN
278: x_return_status := FND_API.G_RET_STS_ERROR;
279: p_error_msg := ' FAILED ITEM_INSTANCES_ACC_D INSTANCE_ID: ' || to_char(p_instance_id);
280: CSM_UTIL_PKG.LOG(p_error_msg,'CSM_ITEM_INSTANCE_EVENT_PKG.ITEM_INSTANCES_ACC_D',FND_LOG.LEVEL_EXCEPTION);
281: RAISE;
282: END ITEM_INSTANCES_ACC_D;
283:
284: PROCEDURE REFRESH_INSTANCES_ACC (p_status OUT NOCOPY VARCHAR2, p_message OUT NOCOPY VARCHAR2)

Line 480: CSM_UTIL_PKG.LOG('Entering CSM_ITEM_INSTANCE_EVENT_PKG.REFRESH_INSTANCES_ACC',

476: l_dummy BOOLEAN;
477: l_ver_label_lst ver_lab_Tab;
478: l_parent_inst_id_lst instance_idTab;
479: BEGIN
480: CSM_UTIL_PKG.LOG('Entering CSM_ITEM_INSTANCE_EVENT_PKG.REFRESH_INSTANCES_ACC',
481: 'CSM_ITEM_INSTANCE_EVENT_PKG.REFRESH_INSTANCES_ACC',FND_LOG.LEVEL_PROCEDURE);
482:
483: l_current_run_date := SYSDATE;
484: g_pub_item1 := 'CSF_M_ITEM_INSTANCES';

Line 823: CSM_UTIL_PKG.LOG('Leaving CSM_ITEM_INSTANCE_EVENT_PKG.REFRESH_INSTANCES_ACC',

819: AND procedure_name = 'REFRESH_INSTANCES_ACC';
820:
821: COMMIT;
822:
823: CSM_UTIL_PKG.LOG('Leaving CSM_ITEM_INSTANCE_EVENT_PKG.REFRESH_INSTANCES_ACC',
824: 'CSM_ITEM_INSTANCE_EVENT_PKG.REFRESH_INSTANCES_ACC',FND_LOG.LEVEL_PROCEDURE);
825:
826: p_status := 'FINE';
827: p_message := 'CSM_ITEM_INSTANCE_EVENT_PKG.REFRESH_INSTANCES_ACC Executed successfully';

Line 836: csm_util_pkg.log('CSM_ITEM_INSTANCE_EVENT_PKG.REFRESH_INSTANCES_ACC ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);

832: l_sqlerrmsg := substr(SQLERRM, 1,2000);
833: p_status := 'ERROR';
834: p_message := 'Error in CSM_ITEM_INSTANCE_EVENT_PKG.REFRESH_INSTANCES_ACC: ' || l_sqlerrno || ':' || l_sqlerrmsg;
835: ROLLBACK;
836: csm_util_pkg.log('CSM_ITEM_INSTANCE_EVENT_PKG.REFRESH_INSTANCES_ACC ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);
837: END REFRESH_INSTANCES_ACC;
838:
839: PROCEDURE GET_IB_AT_LOCATION(p_instance_id IN NUMBER, p_party_site_id IN NUMBER, p_party_id IN NUMBER,
840: p_location_id IN NUMBER, p_user_id IN NUMBER, p_flow_type IN VARCHAR2)

Line 931: CSM_UTIL_PKG.LOG('Entering GET_IB_AT_LOCATION for instance_id: ' || p_instance_id ||

927: AND si.contract_item_type_code IS NULL
928: ;
929:
930: BEGIN
931: CSM_UTIL_PKG.LOG('Entering GET_IB_AT_LOCATION for instance_id: ' || p_instance_id ||
932: ' and party_site_id: ' || p_party_site_id,'CSM_ITEM_INSTANCE_EVENT_PKG.GET_IB_AT_LOCATION',FND_LOG.LEVEL_PROCEDURE);
933:
934: IF p_flow_type IS NULL OR p_flow_type <> 'HISTORY' THEN
935: l_max_ib_at_location := NVL(csm_profile_pkg.get_max_ib_at_location(p_user_id),0);

Line 993: CSM_UTIL_PKG.LOG('Leaving GET_IB_AT_LOCATION for instance_id: ' || p_instance_id ||

989: END IF;
990:
991: END IF;
992:
993: CSM_UTIL_PKG.LOG('Leaving GET_IB_AT_LOCATION for instance_id: ' || p_instance_id ||
994: ' and party_site_id: ' || p_party_site_id,'CSM_ITEM_INSTANCE_EVENT_PKG.GET_IB_AT_LOCATION',FND_LOG.LEVEL_PROCEDURE);
995:
996: EXCEPTION
997: WHEN OTHERS THEN

Line 1002: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_ITEM_INSTANCE_EVENT_PKG.GET_IB_AT_LOCATION',FND_LOG.LEVEL_EXCEPTION);

998: l_sqlerrno := to_char(SQLCODE);
999: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1000: l_error_msg := ' Exception in GET_IB_AT_LOCATION for instance_id: ' || p_instance_id || ' and party_site_id:'
1001: || to_char(p_party_site_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
1002: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_ITEM_INSTANCE_EVENT_PKG.GET_IB_AT_LOCATION',FND_LOG.LEVEL_EXCEPTION);
1003: END GET_IB_AT_LOCATION;
1004:
1005: PROCEDURE SPAWN_COUNTERS_INS (p_instance_id IN NUMBER, p_user_id IN NUMBER)
1006: IS

Line 1030: CSM_UTIL_PKG.LOG('Entering SPAWN_COUNTERS_INS for instance_id: ' || p_instance_id,

1026: WHERE acc.user_id = p_user_id
1027: AND acc.instance_id = cas.source_object_id) ;
1028:
1029: BEGIN
1030: CSM_UTIL_PKG.LOG('Entering SPAWN_COUNTERS_INS for instance_id: ' || p_instance_id,
1031: 'CSM_ITEM_INSTANCE_EVENT_PKG.SPAWN_COUNTERS_INS',FND_LOG.LEVEL_PROCEDURE);
1032:
1033: FOR r_counter_id_rec in l_counter_id_csr(p_instance_id, p_user_id) LOOP
1034: --- get the counter

Line 1042: CSM_UTIL_PKG.LOG('Leaving SPAWN_COUNTERS_INS for instance_id: ' || p_instance_id,

1038: csm_counter_event_pkg.COUNTER_VALS_MAKE_DIRTY_I_GRP(r_counter_id_rec.counter_id, p_instance_id, p_user_id, l_error_msg, l_return_status);
1039:
1040: END LOOP;
1041:
1042: CSM_UTIL_PKG.LOG('Leaving SPAWN_COUNTERS_INS for instance_id: ' || p_instance_id,
1043: 'CSM_ITEM_INSTANCE_EVENT_PKG.SPAWN_COUNTERS_INS',FND_LOG.LEVEL_PROCEDURE);
1044: EXCEPTION
1045: WHEN OTHERS THEN
1046: l_sqlerrno := to_char(SQLCODE);

Line 1050: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_ITEM_INSTANCE_EVENT_PKG.SPAWN_COUNTERS_INS',FND_LOG.LEVEL_EXCEPTION);

1046: l_sqlerrno := to_char(SQLCODE);
1047: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1048: l_error_msg := l_error_msg || '- Exception in SPAWN_COUNTERS_INS for instance_id: ' || p_instance_id
1049: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
1050: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_ITEM_INSTANCE_EVENT_PKG.SPAWN_COUNTERS_INS',FND_LOG.LEVEL_EXCEPTION);
1051: RAISE;
1052: END SPAWN_COUNTERS_INS;
1053:
1054: PROCEDURE DELETE_IB_AT_LOCATION(p_incident_id IN NUMBER, p_instance_id IN NUMBER, p_party_site_id IN NUMBER, p_party_id IN NUMBER,

Line 1104: CSM_UTIL_PKG.LOG('Entering DELETE_IB_AT_LOCATION for instance_id: ' || p_instance_id ||

1100: AND NVL ( CII.ACTIVE_END_DATE , SYSDATE)
1101: );
1102:
1103: BEGIN
1104: CSM_UTIL_PKG.LOG('Entering DELETE_IB_AT_LOCATION for instance_id: ' || p_instance_id ||
1105: ' and party_site_id: ' || p_party_site_id,'CSM_ITEM_INSTANCE_EVENT_PKG.GET_IB_AT_LOCATION',FND_LOG.LEVEL_PROCEDURE);
1106:
1107: IF p_flow_type IS NULL OR p_flow_type <> 'HISTORY' THEN
1108: FOR c_ib_items IN c_ib_at_location_csr (

Line 1121: CSM_UTIL_PKG.LOG('Leaving DELETE_IB_AT_LOCATION for instance_id: ' || p_instance_id ||

1117: );
1118: END LOOP;
1119: END IF;
1120:
1121: CSM_UTIL_PKG.LOG('Leaving DELETE_IB_AT_LOCATION for instance_id: ' || p_instance_id ||
1122: ' and party_site_id: ' || p_party_site_id,'CSM_ITEM_INSTANCE_EVENT_PKG.GET_IB_AT_LOCATION',FND_LOG.LEVEL_PROCEDURE);
1123: EXCEPTION
1124: WHEN OTHERS THEN
1125: l_sqlerrno := to_char(SQLCODE);

Line 1129: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_ITEM_INSTANCE_EVENT_PKG.DELETE_IB_AT_LOCATION',FND_LOG.LEVEL_EXCEPTION);

1125: l_sqlerrno := to_char(SQLCODE);
1126: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1127: l_error_msg := ' Exception in DELETE_IB_AT_LOCATION for instance_id: ' || p_instance_id || ' and party_site_id:'
1128: || to_char(p_party_site_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
1129: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_ITEM_INSTANCE_EVENT_PKG.DELETE_IB_AT_LOCATION',FND_LOG.LEVEL_EXCEPTION);
1130: END DELETE_IB_AT_LOCATION;
1131:
1132: PROCEDURE SPAWN_COUNTERS_DEL (p_instance_id IN NUMBER, p_user_id IN NUMBER)
1133: IS

Line 1157: CSM_UTIL_PKG.LOG('Entering CSM_ITEM_INSTANCE_EVENT_PKG.SPAWN_COUNTERS_DEL ',

1153: WHERE acc.user_id = p_user_id
1154: AND acc.counter_id = cntrs.counter_id);
1155:
1156: BEGIN
1157: CSM_UTIL_PKG.LOG('Entering CSM_ITEM_INSTANCE_EVENT_PKG.SPAWN_COUNTERS_DEL ',
1158: 'CSM_ITEM_INSTANCE_EVENT_PKG.SPAWN_COUNTERS_DEL',FND_LOG.LEVEL_PROCEDURE);
1159:
1160: -- get all the counters for the instance
1161: FOR r_counter_id_rec in l_counter_id_csr(p_instance_id, p_user_id) LOOP

Line 1170: CSM_UTIL_PKG.LOG('Leaving CSM_ITEM_INSTANCE_EVENT_PKG.SPAWN_COUNTERS_DEL ',

1166: csm_counter_event_pkg.COUNTER_VALS_MAKE_DIRTY_D_GRP(r_counter_id_rec.counter_id, p_instance_id, p_user_id, l_error_msg, l_return_status);
1167:
1168: END LOOP;
1169:
1170: CSM_UTIL_PKG.LOG('Leaving CSM_ITEM_INSTANCE_EVENT_PKG.SPAWN_COUNTERS_DEL ',
1171: 'CSM_ITEM_INSTANCE_EVENT_PKG.SPAWN_COUNTERS_DEL',FND_LOG.LEVEL_PROCEDURE);
1172: EXCEPTION
1173: WHEN OTHERS THEN
1174: l_sqlerrno := to_char(SQLCODE);

Line 1178: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_ITEM_INSTANCE_EVENT_PKG.SPAWN_COUNTERS_DEL',FND_LOG.LEVEL_EXCEPTION);

1174: l_sqlerrno := to_char(SQLCODE);
1175: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1176: l_error_msg := l_error_msg || '- Exception in SPAWN_COUNTERS_DEL for instance_id: ' || p_instance_id
1177: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
1178: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_ITEM_INSTANCE_EVENT_PKG.SPAWN_COUNTERS_DEL',FND_LOG.LEVEL_EXCEPTION);
1179: RAISE;
1180: END SPAWN_COUNTERS_DEL;
1181:
1182: PROCEDURE DELETE_IB_NOTIN_INV (p_inv_item_id IN NUMBER, p_org_id IN NUMBER, p_user_id IN NUMBER)

Line 1210: CSM_UTIL_PKG.LOG('Entering CSM_ITEM_INSTANCE_EVENT_PKG.DELETE_IB_NOTIN_INV ',

1206: AND acc.user_id = p_user_id;
1207:
1208: BEGIN
1209:
1210: CSM_UTIL_PKG.LOG('Entering CSM_ITEM_INSTANCE_EVENT_PKG.DELETE_IB_NOTIN_INV ',
1211: 'CSM_ITEM_INSTANCE_EVENT_PKG.DELETE_IB_NOTIN_INV',FND_LOG.LEVEL_PROCEDURE);
1212:
1213: -- delete item instances that are not in the user's subinventory
1214: IF l_acc_id_lst.COUNT > 0 THEN

Line 1244: CSM_UTIL_PKG.LOG('Leaving CSM_ITEM_INSTANCE_EVENT_PKG.DELETE_IB_NOTIN_INV ',

1240: FORALL i IN l_acc_id_lst.FIRST..l_acc_id_lst.LAST
1241: DELETE CSM_ITEM_INSTANCES_ACC WHERE ACCESS_ID = l_acc_id_lst(i);
1242: END IF;
1243:
1244: CSM_UTIL_PKG.LOG('Leaving CSM_ITEM_INSTANCE_EVENT_PKG.DELETE_IB_NOTIN_INV ',
1245: 'CSM_ITEM_INSTANCE_EVENT_PKG.DELETE_IB_NOTIN_INV',FND_LOG.LEVEL_PROCEDURE);
1246:
1247: EXCEPTION
1248: WHEN OTHERS THEN

Line 1253: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_ITEM_INSTANCE_EVENT_PKG.DELETE_IB_NOTIN_INV',FND_LOG.LEVEL_EXCEPTION);

1249: l_sqlerrno := to_char(SQLCODE);
1250: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1251: l_error_msg := l_error_msg || '- Exception in DELETE_IB_NOTIN_INV ' || ':'
1252: || l_sqlerrno || ':' || l_sqlerrmsg;
1253: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_ITEM_INSTANCE_EVENT_PKG.DELETE_IB_NOTIN_INV',FND_LOG.LEVEL_EXCEPTION);
1254: RAISE;
1255:
1256: END DELETE_IB_NOTIN_INV;
1257: