DBA Data[Home] [Help]

APPS.QP_ITEMGROUP_UPG_UTIL_PVT dependencies on QP_UTIL

Line 72: QP_UTIL.Log_Error(

68: EXCEPTION
69: WHEN OTHERS THEN
70: err_msg := substr(sqlerrm, 1, 240);
71: rollback;
72: QP_UTIL.Log_Error(
73: p_id1 => 'Structure Id '||to_char(l_new_structure_id),
74: p_error_type => 'ITEM_GROUP',
75: p_error_desc => err_msg,
76: p_error_module => 'Upgrade_Item_Groups');

Line 143: QP_UTIL.Log_Error(

139: EXCEPTION
140: WHEN OTHERS THEN
141: err_msg := substr(sqlerrm, 1, 240);
142: rollback;
143: QP_UTIL.Log_Error(
144: p_id1 => 'Structure Id '||to_char(l_new_structure_id),
145: p_error_type => 'ITEM_GROUP',
146: p_error_desc => err_msg,
147: p_error_module => 'Upgrade_Item_Groups');

Line 154: l_organization_id := QP_UTIL.Get_Item_Validation_Org;

150:
151: END IF; --structure doesn't exist, upgrade not run before
152:
153: --Get the organization_id
154: l_organization_id := QP_UTIL.Get_Item_Validation_Org;
155:
156: --Get the User_id
157: l_user_id := FND_GLOBAL.USER_ID;
158:

Line 228: QP_UTIL.Log_Error(

224: EXCEPTION
225: WHEN OTHERS THEN
226: err_msg := substr(sqlerrm, 1, 240);
227: rollback;
228: QP_UTIL.Log_Error(
229: p_id1 => 'Category Id '||to_char(l_new_category_id),
230: p_id2 => 'Structure Id '||to_char(l_new_structure_id),
231: p_error_type => 'ITEM_GROUP',
232: p_error_desc => err_msg,

Line 317: QP_UTIL.Log_Error(

313: EXCEPTION
314: WHEN OTHERS THEN
315: err_msg := substr(sqlerrm, 1, 240);
316: rollback;
317: QP_UTIL.Log_Error(
318: p_id1 => 'Category Set Id '||to_char(l_new_category_set_id),
319: p_id2 => 'Structure Id '||to_char(l_new_structure_id),
320: p_error_type => 'ITEM_GROUP',
321: p_error_desc => err_msg,

Line 363: QP_UTIL.Log_Error(

359: EXCEPTION
360: WHEN DUP_VAL_ON_INDEX OR NO_DATA_FOUND OR VALUE_ERROR THEN
361: err_msg := substr(sqlerrm, 1, 240);
362: rollback;
363: QP_UTIL.Log_Error(
364: p_id1 => 'Group Id '||to_char(l_oe_item_group_lines_rec.group_id),
365: p_id2 => 'Inventory Item Id '||to_char(l_oe_item_group_lines_rec.inventory_item_id),
366: p_error_type => 'ITEM_GROUP',
367: p_error_desc => err_msg,

Line 373: QP_UTIL.Log_Error(

369:
370: WHEN OTHERS THEN
371: err_msg := substr(sqlerrm, 1, 240);
372: rollback;
373: QP_UTIL.Log_Error(
374: p_id1 => 'Category Set Id '||to_char(l_new_category_set_id),
375: p_id2 => 'Category Id '||to_char(l_new_category_id),
376: p_error_type => 'ITEM_GROUP',
377: p_error_desc => err_msg,

Line 396: QP_UTIL.Log_Error(

392: err_msg := substr(sqlerrm, 1, 240);
393: IF err_msg IS NULL THEN
394: err_msg := substr(FND_FLEX_KEY_API.message, 1, 240);
395: END IF;
396: QP_UTIL.Log_Error(
397: p_id1 => 'Category Set Id '||to_char(l_new_category_set_id),
398: p_id2 => 'Category Id '||to_char(l_new_category_id),
399: p_error_type => 'ITEM_GROUP',
400: p_error_desc => err_msg,