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

123:
124: BEGIN
125: x_return_status := FND_API.G_RET_STS_SUCCESS;
126: CSM_UTIL_PKG.LOG('Entering CSM_ITEM_INSTANCE_EVENT_PKG.ITEM_INSTANCES_ACC_PROCESSOR ',
127: 'CSM_ITEM_INSTANCE_EVENT_PKG.ITEM_INSTANCES_ACC_PROCESSOR',FND_LOG.LEVEL_PROCEDURE);
128:
129: IF p_instance_id IS NOT NULL AND p_user_id IS NOT NULL THEN
130: CSM_ACC_PKG.Insert_Acc
131: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1

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

171: END IF;
172:
173: p_error_msg := 'SUCCESS';
174: CSM_UTIL_PKG.LOG('Leaving CSM_ITEM_INSTANCE_EVENT_PKG.ITEM_INSTANCES_ACC_PROCESSOR ',
175: 'CSM_ITEM_INSTANCE_EVENT_PKG.ITEM_INSTANCES_ACC_PROCESSOR',FND_LOG.LEVEL_PROCEDURE);
176: EXCEPTION
177: WHEN others THEN
178: x_return_status := FND_API.G_RET_STS_ERROR;
179: p_error_msg := ' FAILED ITEM_INSTANCES_ACC_PROCESSOR INSTANCE_ID: ' || to_char(p_instance_id);

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

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

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

188: IS
189: BEGIN
190: x_return_status := FND_API.G_RET_STS_SUCCESS;
191: CSM_UTIL_PKG.LOG('Entering CSM_ITEM_INSTANCE_EVENT_PKG.II_RELATIONSHIPS_ACC_D ',
192: 'CSM_ITEM_INSTANCE_EVENT_PKG.II_RELATIONSHIPS_ACC_D',FND_LOG.LEVEL_PROCEDURE);
193:
194: CSM_ACC_PKG.Delete_Acc
195: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name2
196: ,P_ACC_TABLE_NAME => g_acc_table_name2

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

200: );
201:
202: p_error_msg := 'SUCCESS';
203: CSM_UTIL_PKG.LOG('Leaving CSM_ITEM_INSTANCE_EVENT_PKG.II_RELATIONSHIPS_ACC_D',
204: 'CSM_ITEM_INSTANCE_EVENT_PKG.II_RELATIONSHIPS_ACC_D', FND_LOG.LEVEL_PROCEDURE);
205:
206: EXCEPTION
207: WHEN others THEN
208: x_return_status := FND_API.G_RET_STS_ERROR;

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

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

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

238:
239: BEGIN
240: x_return_status := FND_API.G_RET_STS_SUCCESS;
241: CSM_UTIL_PKG.LOG('Entering CSM_ITEM_INSTANCE_EVENT_PKG.ITEM_INSTANCES_ACC_D ',
242: 'CSM_ITEM_INSTANCE_EVENT_PKG.ITEM_INSTANCES_ACC_D',FND_LOG.LEVEL_PROCEDURE);
243:
244: OPEN l_check_instance_ref(p_instance_id, p_user_id) ;
245: FETCH l_check_instance_REF INTO l_REF_EXISTS ;
246: IF l_check_instance_REF%NOTFOUND THEN

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

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

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

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

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

479: l_ver_label_lst ver_lab_Tab;
480: l_parent_inst_id_lst instance_idTab;
481: BEGIN
482: CSM_UTIL_PKG.LOG('Entering CSM_ITEM_INSTANCE_EVENT_PKG.REFRESH_INSTANCES_ACC',
483: 'CSM_ITEM_INSTANCE_EVENT_PKG.REFRESH_INSTANCES_ACC',FND_LOG.LEVEL_PROCEDURE);
484:
485: l_current_run_date := SYSDATE;
486: g_pub_item1 := 'CSF_M_ITEM_INSTANCES';
487: g_pub_item2 := 'CSF_M_II_RELATIONSHIPS';

Line 494: CSM_UTIL_PKG.LOG('Processing expired instances','CSM_ITEM_INSTANCE_EVENT_PKG.REFRESH_INSTANCES_ACC',FND_LOG.LEVEL_PROCEDURE);

490: OPEN l_last_run_date_csr;
491: FETCH l_last_run_date_csr INTO l_last_run_date;
492: CLOSE l_last_run_date_csr;
493:
494: CSM_UTIL_PKG.LOG('Processing expired instances','CSM_ITEM_INSTANCE_EVENT_PKG.REFRESH_INSTANCES_ACC',FND_LOG.LEVEL_PROCEDURE);
495:
496: OPEN l_expiredinstances_del_csr;
497: LOOP
498: l_acc_id_lst.DELETE;

Line 520: CSM_UTIL_PKG.LOG('Processing updates to instances','CSM_ITEM_INSTANCE_EVENT_PKG.REFRESH_INSTANCES_ACC',FND_LOG.LEVEL_PROCEDURE);

516: COMMIT;--IB Deletes are commited
517: END LOOP;
518: CLOSE l_expiredinstances_del_csr;
519:
520: CSM_UTIL_PKG.LOG('Processing updates to instances','CSM_ITEM_INSTANCE_EVENT_PKG.REFRESH_INSTANCES_ACC',FND_LOG.LEVEL_PROCEDURE);
521: OPEN l_iteminstances_upd_csr(l_last_run_date);
522: LOOP
523: l_acc_id_lst.DELETE;
524: l_user_id_lst.DELETE;

Line 548: CSM_UTIL_PKG.LOG('Processing instance inserts','CSM_ITEM_INSTANCE_EVENT_PKG.REFRESH_INSTANCES_ACC',FND_LOG.LEVEL_PROCEDURE);

544: l_ver_label_lst.DELETE;
545: l_parent_inst_id_lst.DELETE;
546:
547:
548: CSM_UTIL_PKG.LOG('Processing instance inserts','CSM_ITEM_INSTANCE_EVENT_PKG.REFRESH_INSTANCES_ACC',FND_LOG.LEVEL_PROCEDURE);
549:
550: OPEN l_ins_item_instances_csr;
551: FETCH l_ins_item_instances_csr BULK COLLECT INTO l_acc_id_lst, l_user_id_lst, l_instance_id_lst, l_ver_label_lst, l_parent_inst_id_lst;
552: CLOSE l_ins_item_instances_csr;

Line 581: CSM_UTIL_PKG.LOG('Processing instance relationships DEL1','CSM_ITEM_INSTANCE_EVENT_PKG.REFRESH_INSTANCES_ACC',FND_LOG.LEVEL_PROCEDURE);

577: l_rel_id_lst.DELETE;
578: l_ver_label_lst.DELETE;
579: l_parent_inst_id_lst.DELETE;
580:
581: CSM_UTIL_PKG.LOG('Processing instance relationships DEL1','CSM_ITEM_INSTANCE_EVENT_PKG.REFRESH_INSTANCES_ACC',FND_LOG.LEVEL_PROCEDURE);
582: OPEN l_itemrelationships_del1_csr;
583: FETCH l_itemrelationships_del1_csr BULK COLLECT INTO l_acc_id_lst, l_user_id_lst;
584: CLOSE l_itemrelationships_del1_csr;
585:

Line 610: CSM_UTIL_PKG.LOG('Processing instance relationships DEL2','CSM_ITEM_INSTANCE_EVENT_PKG.REFRESH_INSTANCES_ACC',FND_LOG.LEVEL_PROCEDURE);

606: l_acc_id_lst.DELETE;
607: l_user_id_lst.DELETE;
608: l_instance_id_lst.DELETE;
609:
610: CSM_UTIL_PKG.LOG('Processing instance relationships DEL2','CSM_ITEM_INSTANCE_EVENT_PKG.REFRESH_INSTANCES_ACC',FND_LOG.LEVEL_PROCEDURE);
611: OPEN l_itemrelationships_del2_csr;
612: FETCH l_itemrelationships_del2_csr BULK COLLECT INTO l_acc_id_lst, l_user_id_lst,l_instance_id_lst;
613: CLOSE l_itemrelationships_del2_csr;
614:

Line 660: CSM_UTIL_PKG.LOG('Processing instance relationships UPD','CSM_ITEM_INSTANCE_EVENT_PKG.REFRESH_INSTANCES_ACC',FND_LOG.LEVEL_PROCEDURE);

656: l_instance_id_lst.DELETE;
657: l_parent_inst_id_lst.DELETE;
658:
659:
660: CSM_UTIL_PKG.LOG('Processing instance relationships UPD','CSM_ITEM_INSTANCE_EVENT_PKG.REFRESH_INSTANCES_ACC',FND_LOG.LEVEL_PROCEDURE);
661: OPEN l_itemrelationships_upd_csr(l_last_run_date);
662: FETCH l_itemrelationships_upd_csr BULK COLLECT INTO l_user_id_lst, l_acc_id_lst, l_instance_id_lst, l_parent_inst_id_lst;
663: CLOSE l_itemrelationships_upd_csr;
664:

Line 700: CSM_UTIL_PKG.LOG('Processing instance relationships INS','CSM_ITEM_INSTANCE_EVENT_PKG.REFRESH_INSTANCES_ACC',FND_LOG.LEVEL_PROCEDURE);

696: END IF;
697:
698: COMMIT;--IB Relation Updates are commited
699:
700: CSM_UTIL_PKG.LOG('Processing instance relationships INS','CSM_ITEM_INSTANCE_EVENT_PKG.REFRESH_INSTANCES_ACC',FND_LOG.LEVEL_PROCEDURE);
701:
702: OPEN l_itemrelationships_ins_csr;
703: LOOP
704: l_acc_id_lst.DELETE;

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

763:
764: COMMIT;
765:
766: CSM_UTIL_PKG.LOG('Leaving CSM_ITEM_INSTANCE_EVENT_PKG.REFRESH_INSTANCES_ACC',
767: 'CSM_ITEM_INSTANCE_EVENT_PKG.REFRESH_INSTANCES_ACC',FND_LOG.LEVEL_PROCEDURE);
768:
769: p_status := 'FINE';
770: p_message := 'CSM_ITEM_INSTANCE_EVENT_PKG.REFRESH_INSTANCES_ACC Executed successfully';
771:

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

873: ;
874:
875: BEGIN
876: CSM_UTIL_PKG.LOG('Entering GET_IB_AT_LOCATION for instance_id: ' || p_instance_id ||
877: ' and party_site_id: ' || p_party_site_id,'CSM_ITEM_INSTANCE_EVENT_PKG.GET_IB_AT_LOCATION',FND_LOG.LEVEL_PROCEDURE);
878:
879: IF p_flow_type IS NULL OR p_flow_type <> 'HISTORY' THEN
880: l_max_ib_at_location := NVL(csm_profile_pkg.get_max_ib_at_location(p_user_id),0);
881:

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

951:
952: END IF;
953:
954: CSM_UTIL_PKG.LOG('Leaving GET_IB_AT_LOCATION for instance_id: ' || p_instance_id ||
955: ' and party_site_id: ' || p_party_site_id,'CSM_ITEM_INSTANCE_EVENT_PKG.GET_IB_AT_LOCATION',FND_LOG.LEVEL_PROCEDURE);
956:
957: EXCEPTION
958: WHEN OTHERS THEN
959: l_sqlerrno := to_char(SQLCODE);

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

959: l_sqlerrno := to_char(SQLCODE);
960: l_sqlerrmsg := substr(SQLERRM, 1,2000);
961: l_error_msg := ' Exception in GET_IB_AT_LOCATION for instance_id: ' || p_instance_id || ' and party_site_id:'
962: || to_char(p_party_site_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
963: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_ITEM_INSTANCE_EVENT_PKG.GET_IB_AT_LOCATION',FND_LOG.LEVEL_EXCEPTION);
964: END GET_IB_AT_LOCATION;
965:
966: PROCEDURE SPAWN_COUNTERS_INS (p_instance_id IN NUMBER, p_user_id IN NUMBER)
967: IS

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

986: AND acc.instance_id = cntr_grps.source_object_id) ;
987:
988: BEGIN
989: CSM_UTIL_PKG.LOG('Entering SPAWN_COUNTERS_INS for instance_id: ' || p_instance_id,
990: 'CSM_ITEM_INSTANCE_EVENT_PKG.SPAWN_COUNTERS_INS',FND_LOG.LEVEL_PROCEDURE);
991:
992: FOR r_counter_id_rec in l_counter_id_csr(p_instance_id, p_user_id) LOOP
993: --- get the counter
994: csm_counter_event_pkg.COUNTER_MDIRTY_I(r_counter_id_rec.counter_id, p_user_id, l_error_msg, l_return_status);

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

998:
999: END LOOP;
1000:
1001: CSM_UTIL_PKG.LOG('Leaving SPAWN_COUNTERS_INS for instance_id: ' || p_instance_id,
1002: 'CSM_ITEM_INSTANCE_EVENT_PKG.SPAWN_COUNTERS_INS',FND_LOG.LEVEL_PROCEDURE);
1003: EXCEPTION
1004: WHEN OTHERS THEN
1005: l_sqlerrno := to_char(SQLCODE);
1006: l_sqlerrmsg := substr(SQLERRM, 1,2000);

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

1005: l_sqlerrno := to_char(SQLCODE);
1006: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1007: l_error_msg := l_error_msg || '- Exception in SPAWN_COUNTERS_INS for instance_id: ' || p_instance_id
1008: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
1009: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_ITEM_INSTANCE_EVENT_PKG.SPAWN_COUNTERS_INS',FND_LOG.LEVEL_EXCEPTION);
1010: RAISE;
1011: END SPAWN_COUNTERS_INS;
1012:
1013: 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 1064: ' and party_site_id: ' || p_party_site_id,'CSM_ITEM_INSTANCE_EVENT_PKG.GET_IB_AT_LOCATION',FND_LOG.LEVEL_PROCEDURE);

1060: );
1061:
1062: BEGIN
1063: CSM_UTIL_PKG.LOG('Entering DELETE_IB_AT_LOCATION for instance_id: ' || p_instance_id ||
1064: ' and party_site_id: ' || p_party_site_id,'CSM_ITEM_INSTANCE_EVENT_PKG.GET_IB_AT_LOCATION',FND_LOG.LEVEL_PROCEDURE);
1065:
1066: IF p_flow_type IS NULL OR p_flow_type <> 'HISTORY' THEN
1067: FOR c_ib_items IN c_ib_at_location_csr (
1068: p_user_id, p_party_site_id, p_location_id, p_party_id, p_incident_id )

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

1077: END LOOP;
1078: END IF;
1079:
1080: CSM_UTIL_PKG.LOG('Leaving DELETE_IB_AT_LOCATION for instance_id: ' || p_instance_id ||
1081: ' and party_site_id: ' || p_party_site_id,'CSM_ITEM_INSTANCE_EVENT_PKG.GET_IB_AT_LOCATION',FND_LOG.LEVEL_PROCEDURE);
1082: EXCEPTION
1083: WHEN OTHERS THEN
1084: l_sqlerrno := to_char(SQLCODE);
1085: l_sqlerrmsg := substr(SQLERRM, 1,2000);

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

1084: l_sqlerrno := to_char(SQLCODE);
1085: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1086: l_error_msg := ' Exception in DELETE_IB_AT_LOCATION for instance_id: ' || p_instance_id || ' and party_site_id:'
1087: || to_char(p_party_site_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
1088: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_ITEM_INSTANCE_EVENT_PKG.DELETE_IB_AT_LOCATION',FND_LOG.LEVEL_EXCEPTION);
1089: END DELETE_IB_AT_LOCATION;
1090:
1091: PROCEDURE SPAWN_COUNTERS_DEL (p_instance_id IN NUMBER, p_user_id IN NUMBER)
1092: IS

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

1107: AND cntrs.TYPE = 'REGULAR';
1108:
1109: BEGIN
1110: CSM_UTIL_PKG.LOG('Entering CSM_ITEM_INSTANCE_EVENT_PKG.SPAWN_COUNTERS_DEL ',
1111: 'CSM_ITEM_INSTANCE_EVENT_PKG.SPAWN_COUNTERS_DEL',FND_LOG.LEVEL_PROCEDURE);
1112:
1113: -- get all the counters for the instance
1114: FOR r_counter_id_rec in l_counter_id_csr(p_instance_id, p_user_id) LOOP
1115: --- drop the counter

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

1120:
1121: END LOOP;
1122:
1123: CSM_UTIL_PKG.LOG('Leaving CSM_ITEM_INSTANCE_EVENT_PKG.SPAWN_COUNTERS_DEL ',
1124: 'CSM_ITEM_INSTANCE_EVENT_PKG.SPAWN_COUNTERS_DEL',FND_LOG.LEVEL_PROCEDURE);
1125: EXCEPTION
1126: WHEN OTHERS THEN
1127: l_sqlerrno := to_char(SQLCODE);
1128: l_sqlerrmsg := substr(SQLERRM, 1,2000);

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

1127: l_sqlerrno := to_char(SQLCODE);
1128: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1129: l_error_msg := l_error_msg || '- Exception in SPAWN_COUNTERS_DEL for instance_id: ' || p_instance_id
1130: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
1131: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_ITEM_INSTANCE_EVENT_PKG.SPAWN_COUNTERS_DEL',FND_LOG.LEVEL_EXCEPTION);
1132: RAISE;
1133: END SPAWN_COUNTERS_DEL;
1134:
1135: PROCEDURE DELETE_IB_NOTIN_INV (p_inv_item_id IN NUMBER, p_org_id IN NUMBER, p_user_id IN NUMBER)

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

1160:
1161: BEGIN
1162:
1163: CSM_UTIL_PKG.LOG('Entering CSM_ITEM_INSTANCE_EVENT_PKG.DELETE_IB_NOTIN_INV ',
1164: 'CSM_ITEM_INSTANCE_EVENT_PKG.DELETE_IB_NOTIN_INV',FND_LOG.LEVEL_PROCEDURE);
1165:
1166: -- delete item instances that are not in the user's subinventory
1167: IF l_acc_id_lst.COUNT > 0 THEN
1168: l_acc_id_lst.DELETE;

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

1194: DELETE CSM_ITEM_INSTANCES_ACC WHERE ACCESS_ID = l_acc_id_lst(i);
1195: END IF;
1196:
1197: CSM_UTIL_PKG.LOG('Leaving CSM_ITEM_INSTANCE_EVENT_PKG.DELETE_IB_NOTIN_INV ',
1198: 'CSM_ITEM_INSTANCE_EVENT_PKG.DELETE_IB_NOTIN_INV',FND_LOG.LEVEL_PROCEDURE);
1199:
1200: EXCEPTION
1201: WHEN OTHERS THEN
1202: l_sqlerrno := to_char(SQLCODE);

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

1202: l_sqlerrno := to_char(SQLCODE);
1203: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1204: l_error_msg := l_error_msg || '- Exception in DELETE_IB_NOTIN_INV ' || ':'
1205: || l_sqlerrno || ':' || l_sqlerrmsg;
1206: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_ITEM_INSTANCE_EVENT_PKG.DELETE_IB_NOTIN_INV',FND_LOG.LEVEL_EXCEPTION);
1207: RAISE;
1208:
1209: END DELETE_IB_NOTIN_INV;
1210: