DBA Data[Home] [Help]

APPS.IGR_I_PKG_ITEM_CRM_PKG dependencies on APP_EXCEPTION

Line 57: app_exception.raise_exception;

53: END IF;
54: ELSE
55: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
56: igs_ge_msg_stack.add;
57: app_exception.raise_exception;
58: END IF;
59: -- The following code would ensure the profiles IGS: AMS Categeory, IGS: AMS Category Sub Type
60: -- are IGS: JTF Resource are set before the user tries to insert a new record.
61: IF(fnd_profile.value('IGR_AMS_DEFAULT_CAT') IS NULL OR fnd_profile.value('IGR_AMS_DEFAULT_SUBCAT') IS NULL

Line 65: app_exception.raise_exception;

61: IF(fnd_profile.value('IGR_AMS_DEFAULT_CAT') IS NULL OR fnd_profile.value('IGR_AMS_DEFAULT_SUBCAT') IS NULL
62: OR fnd_profile.value('IGR_JTF_DEFAULT_RESOURCE') IS NULL)THEN
63: fnd_message.set_name('IGS','IGR_NO_DEF_PROF');
64: igs_ge_msg_stack.add;
65: app_exception.raise_exception;
66: END IF;
67: --Test for Uniqueness on Information Type and Package Item associated to the
68: --Information Type.
69: OPEN c; FETCH c INTO l_var;

Line 74: app_Exception.Raise_Exception;

70: IF(c%FOUND)THEN
71: CLOSE c;
72: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
73: igs_ge_msg_stack.add;
74: app_Exception.Raise_Exception;
75: ELSE
76: CLOSE c;
77: END IF;
78: -- This is being hard coded according to Marketing Implementation Guide.

Line 239: app_exception.raise_exception;

235: END IF;
236: ELSE
237: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
238: igs_ge_msg_stack.add;
239: app_exception.raise_exception;
240: END IF;
241: ams_deliverable_pvt.init_deliv_rec(l_deliv_rec);
242: OPEN c_get_obj_num; FETCH c_get_obj_num INTO l_object_version_number; CLOSE c_get_obj_num;
243: l_deliv_rec.deliverable_id := x_package_item_id;