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 FND_LOG

Line 42: 'CSM_ITEM_INSTANCE_EVENT_PKG.ITEM_INSTANCE_MDIRTY_U_ECHUSER',FND_LOG.LEVEL_PROCEDURE);

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
46: CSM_ACC_PKG.Update_Acc

Line 56: 'CSM_ITEM_INSTANCE_EVENT_PKG.ITEM_INSTANCE_MDIRTY_U_ECHUSER',FND_LOG.LEVEL_PROCEDURE);

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
60: x_return_status := FND_API.G_RET_STS_ERROR;

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 74: 'CSM_ITEM_INSTANCE_EVENT_PKG.II_RELATIONSHIPS_ACC_I',FND_LOG.LEVEL_PROCEDURE);

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
78: ,P_ACC_TABLE_NAME => g_acc_table_name2

Line 87: 'CSM_ITEM_INSTANCE_EVENT_PKG.II_RELATIONSHIPS_ACC_I', FND_LOG.LEVEL_PROCEDURE);

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
91: x_return_status := FND_API.G_RET_STS_ERROR;

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 126: 'CSM_ITEM_INSTANCE_EVENT_PKG.ITEM_INSTANCES_ACC_PROCESSOR',FND_LOG.LEVEL_PROCEDURE);

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
130: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1

Line 174: 'CSM_ITEM_INSTANCE_EVENT_PKG.ITEM_INSTANCES_ACC_PROCESSOR',FND_LOG.LEVEL_PROCEDURE);

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;
178: p_error_msg := ' FAILED ITEM_INSTANCES_ACC_PROCESSOR INSTANCE_ID: ' || to_char(p_instance_id);

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 191: 'CSM_ITEM_INSTANCE_EVENT_PKG.II_RELATIONSHIPS_ACC_D',FND_LOG.LEVEL_PROCEDURE);

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
195: ,P_ACC_TABLE_NAME => g_acc_table_name2

Line 203: 'CSM_ITEM_INSTANCE_EVENT_PKG.II_RELATIONSHIPS_ACC_D', FND_LOG.LEVEL_PROCEDURE);

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
207: x_return_status := FND_API.G_RET_STS_ERROR;

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 241: 'CSM_ITEM_INSTANCE_EVENT_PKG.ITEM_INSTANCES_ACC_D',FND_LOG.LEVEL_PROCEDURE);

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 ;
245: IF l_check_instance_REF%NOTFOUND THEN

Line 274: 'CSM_ITEM_INSTANCE_EVENT_PKG.ITEM_INSTANCES_ACC_D',FND_LOG.LEVEL_PROCEDURE);

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
278: x_return_status := FND_API.G_RET_STS_ERROR;

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 481: 'CSM_ITEM_INSTANCE_EVENT_PKG.REFRESH_INSTANCES_ACC',FND_LOG.LEVEL_PROCEDURE);

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';
485: g_pub_item2 := 'CSF_M_II_RELATIONSHIPS';

Line 824: 'CSM_ITEM_INSTANCE_EVENT_PKG.REFRESH_INSTANCES_ACC',FND_LOG.LEVEL_PROCEDURE);

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';
828:

Line 932: ' and party_site_id: ' || p_party_site_id,'CSM_ITEM_INSTANCE_EVENT_PKG.GET_IB_AT_LOCATION',FND_LOG.LEVEL_PROCEDURE);

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);
936:

Line 994: ' and party_site_id: ' || p_party_site_id,'CSM_ITEM_INSTANCE_EVENT_PKG.GET_IB_AT_LOCATION',FND_LOG.LEVEL_PROCEDURE);

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
998: l_sqlerrno := to_char(SQLCODE);

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 1031: 'CSM_ITEM_INSTANCE_EVENT_PKG.SPAWN_COUNTERS_INS',FND_LOG.LEVEL_PROCEDURE);

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
1035: csm_counter_event_pkg.COUNTER_MDIRTY_I(r_counter_id_rec.counter_id, p_user_id, l_error_msg, l_return_status);

Line 1043: 'CSM_ITEM_INSTANCE_EVENT_PKG.SPAWN_COUNTERS_INS',FND_LOG.LEVEL_PROCEDURE);

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);
1047: l_sqlerrmsg := substr(SQLERRM, 1,2000);

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 1105: ' and party_site_id: ' || p_party_site_id,'CSM_ITEM_INSTANCE_EVENT_PKG.GET_IB_AT_LOCATION',FND_LOG.LEVEL_PROCEDURE);

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 (
1109: p_user_id, p_party_site_id, p_location_id, p_party_id, p_incident_id )

Line 1122: ' and party_site_id: ' || p_party_site_id,'CSM_ITEM_INSTANCE_EVENT_PKG.GET_IB_AT_LOCATION',FND_LOG.LEVEL_PROCEDURE);

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);
1126: l_sqlerrmsg := substr(SQLERRM, 1,2000);

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 1158: 'CSM_ITEM_INSTANCE_EVENT_PKG.SPAWN_COUNTERS_DEL',FND_LOG.LEVEL_PROCEDURE);

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
1162: --- drop the counter

Line 1171: 'CSM_ITEM_INSTANCE_EVENT_PKG.SPAWN_COUNTERS_DEL',FND_LOG.LEVEL_PROCEDURE);

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);
1175: l_sqlerrmsg := substr(SQLERRM, 1,2000);

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 1211: 'CSM_ITEM_INSTANCE_EVENT_PKG.DELETE_IB_NOTIN_INV',FND_LOG.LEVEL_PROCEDURE);

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
1215: l_acc_id_lst.DELETE;

Line 1245: 'CSM_ITEM_INSTANCE_EVENT_PKG.DELETE_IB_NOTIN_INV',FND_LOG.LEVEL_PROCEDURE);

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
1249: l_sqlerrno := to_char(SQLCODE);

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: