DBA Data[Home] [Help]

APPS.AME_UTILITY_PKG dependencies on AME_UTIL2

Line 205: if(p_object in ( ame_util2.attributeObject, ame_util2.itemClassObject) ) then

201:
202: --Check for valid bind variable for the module
203: if(p_object is not null) then
204: begin
205: if(p_object in ( ame_util2.attributeObject, ame_util2.itemClassObject) ) then
206: l_allowed_bind_vars(1) := 'transactionId';
207: elsif (p_object = ame_util2.actionTypeObject) then
208: l_allowed_bind_vars(1) := 'parameterOne';
209: l_allowed_bind_vars(2) := 'parameterTwo';

Line 207: elsif (p_object = ame_util2.actionTypeObject) then

203: if(p_object is not null) then
204: begin
205: if(p_object in ( ame_util2.attributeObject, ame_util2.itemClassObject) ) then
206: l_allowed_bind_vars(1) := 'transactionId';
207: elsif (p_object = ame_util2.actionTypeObject) then
208: l_allowed_bind_vars(1) := 'parameterOne';
209: l_allowed_bind_vars(2) := 'parameterTwo';
210: elsif (p_object = ame_util2.approverGroupObject or
211: p_object = ame_util2.specialObject) then

Line 210: elsif (p_object = ame_util2.approverGroupObject or

206: l_allowed_bind_vars(1) := 'transactionId';
207: elsif (p_object = ame_util2.actionTypeObject) then
208: l_allowed_bind_vars(1) := 'parameterOne';
209: l_allowed_bind_vars(2) := 'parameterTwo';
210: elsif (p_object = ame_util2.approverGroupObject or
211: p_object = ame_util2.specialObject) then
212: l_allowed_bind_vars(1) := 'transactionId';
213: l_allowed_bind_vars(2) := 'itemId';
214: l_allowed_bind_vars(3) := 'itemClass';

Line 211: p_object = ame_util2.specialObject) then

207: elsif (p_object = ame_util2.actionTypeObject) then
208: l_allowed_bind_vars(1) := 'parameterOne';
209: l_allowed_bind_vars(2) := 'parameterTwo';
210: elsif (p_object = ame_util2.approverGroupObject or
211: p_object = ame_util2.specialObject) then
212: l_allowed_bind_vars(1) := 'transactionId';
213: l_allowed_bind_vars(2) := 'itemId';
214: l_allowed_bind_vars(3) := 'itemClass';
215: end if;

Line 221: if (p_object = ame_util2.attributeObject) then

217: ,allowedBindVars => l_allowed_bind_vars
218: );
219: exception
220: when others then
221: if (p_object = ame_util2.attributeObject) then
222: fnd_message.set_name('PER', 'AME_400794_INV_ATR_BIND_VAR');
223: elsif p_object = ame_util2.specialObject then
224: fnd_message.set_name('PER', 'AME_400799_INV_VATR_BIND_VAR');
225: elsif p_object = ame_util2.itemClassObject then

Line 223: elsif p_object = ame_util2.specialObject then

219: exception
220: when others then
221: if (p_object = ame_util2.attributeObject) then
222: fnd_message.set_name('PER', 'AME_400794_INV_ATR_BIND_VAR');
223: elsif p_object = ame_util2.specialObject then
224: fnd_message.set_name('PER', 'AME_400799_INV_VATR_BIND_VAR');
225: elsif p_object = ame_util2.itemClassObject then
226: fnd_message.set_name('PER', 'AME_400795_INV_ITU_BIND_VAR');
227: elsif p_object = ame_util2.actionTypeObject then

Line 225: elsif p_object = ame_util2.itemClassObject then

221: if (p_object = ame_util2.attributeObject) then
222: fnd_message.set_name('PER', 'AME_400794_INV_ATR_BIND_VAR');
223: elsif p_object = ame_util2.specialObject then
224: fnd_message.set_name('PER', 'AME_400799_INV_VATR_BIND_VAR');
225: elsif p_object = ame_util2.itemClassObject then
226: fnd_message.set_name('PER', 'AME_400795_INV_ITU_BIND_VAR');
227: elsif p_object = ame_util2.actionTypeObject then
228: fnd_message.set_name('PER', 'AME_400796_INV_ATY_BIND_VAR');
229: elsif p_object = ame_util2.approverGroupObject then

Line 227: elsif p_object = ame_util2.actionTypeObject then

223: elsif p_object = ame_util2.specialObject then
224: fnd_message.set_name('PER', 'AME_400799_INV_VATR_BIND_VAR');
225: elsif p_object = ame_util2.itemClassObject then
226: fnd_message.set_name('PER', 'AME_400795_INV_ITU_BIND_VAR');
227: elsif p_object = ame_util2.actionTypeObject then
228: fnd_message.set_name('PER', 'AME_400796_INV_ATY_BIND_VAR');
229: elsif p_object = ame_util2.approverGroupObject then
230: fnd_message.set_name('PER', 'AME_400797_INV_APG_BIND_VAR');
231: end if;

Line 229: elsif p_object = ame_util2.approverGroupObject then

225: elsif p_object = ame_util2.itemClassObject then
226: fnd_message.set_name('PER', 'AME_400795_INV_ITU_BIND_VAR');
227: elsif p_object = ame_util2.actionTypeObject then
228: fnd_message.set_name('PER', 'AME_400796_INV_ATY_BIND_VAR');
229: elsif p_object = ame_util2.approverGroupObject then
230: fnd_message.set_name('PER', 'AME_400797_INV_APG_BIND_VAR');
231: end if;
232: return fnd_message.get;
233: end;