APPS.IBE_SHOP_LIST_HEADER_PKG dependencies on IBE_UTIL

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

37: p_attribute15 IN VARCHAR2,
38: p_org_id IN NUMBER)
39: IS
40: BEGIN
41: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
42: IBE_Util.Debug('start IBE_Shop_List_Header_PKG.Insert row');
43: END IF;
44:
45: INSERT INTO ibe_sh_shp_lists_all(

Line 42: IBE_Util.Debug('start IBE_Shop_List_Header_PKG.Insert row');

38: p_org_id IN NUMBER)
39: IS
40: BEGIN
41: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
42: IBE_Util.Debug('start IBE_Shop_List_Header_PKG.Insert row');
43: END IF;
44:
45: INSERT INTO ibe_sh_shp_lists_all(
46: shp_list_id,

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

110: DECODE(p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15),
111: DECODE(p_org_id, FND_API.G_MISS_NUM, MO_GLOBAL.get_current_org_id(), p_org_id)
112: )
113: RETURNING shp_list_id INTO x_shp_list_id;
114: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
115: IBE_Util.Debug('Exit IBE_Shop_List_Header_PKG.Insert row');
116: END IF;
117: END Insert_Row;
118:

Line 115: IBE_Util.Debug('Exit IBE_Shop_List_Header_PKG.Insert row');

111: DECODE(p_org_id, FND_API.G_MISS_NUM, MO_GLOBAL.get_current_org_id(), p_org_id)
112: )
113: RETURNING shp_list_id INTO x_shp_list_id;
114: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
115: IBE_Util.Debug('Exit IBE_Shop_List_Header_PKG.Insert row');
116: END IF;
117: END Insert_Row;
118:
119:

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

151: p_attribute15 IN VARCHAR2,
152: p_org_id IN NUMBER)
153: IS
154: BEGIN
155: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
156: IBE_Util.Debug('start IBE_Shop_List_Header_PKG.Update row');
157: END IF;
158:
159: UPDATE ibe_sh_shp_lists_all

Line 156: IBE_Util.Debug('start IBE_Shop_List_Header_PKG.Update row');

152: p_org_id IN NUMBER)
153: IS
154: BEGIN
155: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
156: IBE_Util.Debug('start IBE_Shop_List_Header_PKG.Update row');
157: END IF;
158:
159: UPDATE ibe_sh_shp_lists_all
160: SET request_id = DECODE(p_request_id, FND_API.G_MISS_NUM, request_id, p_request_id),

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

193:
194: IF (SQL%NOTFOUND) THEN
195: RAISE NO_DATA_FOUND;
196: END IF;
197: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
198: IBE_Util.Debug('exit IBE_Shop_List_Header_PKG.update row');
199: END IF;
200: END Update_Row;
201:

Line 198: IBE_Util.Debug('exit IBE_Shop_List_Header_PKG.update row');

194: IF (SQL%NOTFOUND) THEN
195: RAISE NO_DATA_FOUND;
196: END IF;
197: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
198: IBE_Util.Debug('exit IBE_Shop_List_Header_PKG.update row');
199: END IF;
200: END Update_Row;
201:
202:

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

204: p_shp_list_id IN NUMBER,
205: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM)
206: IS
207: BEGIN
208: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
209: IBE_Util.Debug('start IBE_Shop_List_Header_PKG.delete row');
210: END IF;
211:
212: DELETE

Line 209: IBE_Util.Debug('start IBE_Shop_List_Header_PKG.delete row');

205: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM)
206: IS
207: BEGIN
208: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
209: IBE_Util.Debug('start IBE_Shop_List_Header_PKG.delete row');
210: END IF;
211:
212: DELETE
213: FROM ibe_sh_shp_lists_all

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

216:
217: IF (SQL%NOTFOUND) THEN
218: RAISE NO_DATA_FOUND;
219: END IF;
220: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
221: IBE_Util.Debug('Exit IBE_Shop_List_Header_PKG.delete row');
222: END IF;
223: END Delete_Row;
224:

Line 221: IBE_Util.Debug('Exit IBE_Shop_List_Header_PKG.delete row');

217: IF (SQL%NOTFOUND) THEN
218: RAISE NO_DATA_FOUND;
219: END IF;
220: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
221: IBE_Util.Debug('Exit IBE_Shop_List_Header_PKG.delete row');
222: END IF;
223: END Delete_Row;
224:
225: END IBE_Shop_List_Header_PKG;