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';
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
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';
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;
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
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
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
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;
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;