APPS.IBE_SHOP_LIST_LINE_PKG dependencies on IBE_UTIL

Line 57: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

53: )
54: IS
55: CURSOR C2 IS SELECT IBE_SH_SHP_LIST_ITEMS_S1.nextval FROM sys.dual;
56: BEGIN
57: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
58: IBE_Util.Debug('start IBE_Shop_List_LINE_PKG.Insert row');
59: END IF;
60: INSERT INTO ibe_shp_list_items_all(
61: shp_list_item_id,

Line 58: IBE_Util.Debug('start IBE_Shop_List_LINE_PKG.Insert row');

54: IS
55: CURSOR C2 IS SELECT IBE_SH_SHP_LIST_ITEMS_S1.nextval FROM sys.dual;
56: BEGIN
57: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
58: IBE_Util.Debug('start IBE_Shop_List_LINE_PKG.Insert row');
59: END IF;
60: INSERT INTO ibe_shp_list_items_all(
61: shp_list_item_id,
62: request_id,

Line 141: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

137: DECODE(p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15),
138: DECODE(p_org_id, FND_API.G_MISS_NUM, MO_GLOBAL.get_current_org_id(), p_org_id))
139: RETURNING shp_list_item_id INTO x_shp_list_item_id;
140:
141: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
142: IBE_Util.Debug('Exit IBE_Shop_List_line_PKG.Insert row');
143: END IF;
144: END Insert_Row;
145:

Line 142: IBE_Util.Debug('Exit IBE_Shop_List_line_PKG.Insert row');

138: DECODE(p_org_id, FND_API.G_MISS_NUM, MO_GLOBAL.get_current_org_id(), p_org_id))
139: RETURNING shp_list_item_id INTO x_shp_list_item_id;
140:
141: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
142: IBE_Util.Debug('Exit IBE_Shop_List_line_PKG.Insert row');
143: END IF;
144: END Insert_Row;
145:
146:

Line 189: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

185: p_org_id IN NUMBER
186: )
187: IS
188: BEGIN
189: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
190: IBE_Util.Debug('Start IBE_Shop_List_line_PKG.update_row');
191: END IF;
192:
193: UPDATE ibe_shp_list_items_all

Line 190: IBE_Util.Debug('Start IBE_Shop_List_line_PKG.update_row');

186: )
187: IS
188: BEGIN
189: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
190: IBE_Util.Debug('Start IBE_Shop_List_line_PKG.update_row');
191: END IF;
192:
193: UPDATE ibe_shp_list_items_all
194: SET request_id = DECODE(p_request_id, FND_API.G_MISS_NUM, request_id, p_request_id),

Line 236: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

232: AND object_version_number = DECODE(p_object_version_number, FND_API.G_MISS_NUM, object_version_number, p_object_version_number);
233: IF (SQL%NOTFOUND) THEN
234: RAISE NO_DATA_FOUND;
235: END IF;
236: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
237: IBE_Util.Debug('Exit IBE_Shop_List_line_PKG.update_row');
238: END IF;
239: END Update_Row;
240:

Line 237: IBE_Util.Debug('Exit IBE_Shop_List_line_PKG.update_row');

233: IF (SQL%NOTFOUND) THEN
234: RAISE NO_DATA_FOUND;
235: END IF;
236: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
237: IBE_Util.Debug('Exit IBE_Shop_List_line_PKG.update_row');
238: END IF;
239: END Update_Row;
240:
241:

Line 248: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

244: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM
245: )
246: IS
247: BEGIN
248: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
249: IBE_Util.Debug('start IBE_Shop_List_line_PKG.delete row');
250: END IF;
251: DELETE
252: FROM ibe_shp_list_items_all

Line 249: IBE_Util.Debug('start IBE_Shop_List_line_PKG.delete row');

245: )
246: IS
247: BEGIN
248: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
249: IBE_Util.Debug('start IBE_Shop_List_line_PKG.delete row');
250: END IF;
251: DELETE
252: FROM ibe_shp_list_items_all
253: WHERE shp_list_item_id = p_shp_list_item_id

Line 259: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

255:
256: IF (SQL%NOTFOUND) THEN
257: RAISE NO_DATA_FOUND;
258: END IF;
259: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
260: IBE_Util.Debug('Exit IBE_Shop_List_line_PKG.delete row');
261: END IF;
262: END Delete_Row;
263:

Line 260: IBE_Util.Debug('Exit IBE_Shop_List_line_PKG.delete row');

256: IF (SQL%NOTFOUND) THEN
257: RAISE NO_DATA_FOUND;
258: END IF;
259: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
260: IBE_Util.Debug('Exit IBE_Shop_List_line_PKG.delete row');
261: END IF;
262: END Delete_Row;
263:
264: END IBE_Shop_List_Line_PKG;