DBA Data[Home] [Help]

APPS.GR_FIELD_NAME_MASKS_B_PKG dependencies on FND_API

Line 100: IF FND_API.To_Boolean(l_key_exists) THEN

96: 'F',
97: l_rowid,
98: l_key_exists);
99:
100: IF FND_API.To_Boolean(l_key_exists) THEN
101: RAISE Label_Exists_Error;
102: END IF;
103:
104: INSERT INTO gr_item_field_name_masks_b

Line 133: IF FND_API.To_Boolean(l_key_exists) THEN

129: 'F',
130: l_rowid,
131: l_key_exists);
132:
133: IF FND_API.To_Boolean(l_key_exists) THEN
134: x_rowid := l_rowid;
135: ELSE
136: RAISE Row_Missing_Error;
137: END IF;

Line 141: IF FND_API.To_Boolean(p_commit) THEN

137: END IF;
138:
139: /* Check the commit flag and if set, then commit the work. */
140:
141: IF FND_API.To_Boolean(p_commit) THEN
142: COMMIT WORK;
143: END IF;
144:
145: EXCEPTION

Line 156: IF FND_API.To_Boolean(p_called_by_form) THEN

152: 'GR_FOREIGN_KEY_ERROR');
153: FND_MESSAGE.SET_TOKEN('TEXT',
154: l_msg_data,
155: FALSE);
156: IF FND_API.To_Boolean(p_called_by_form) THEN
157: APP_EXCEPTION.Raise_Exception;
158: ELSE
159: x_msg_data := FND_MESSAGE.Get;
160: END IF;

Line 171: IF FND_API.To_Boolean(p_called_by_form) THEN

167: 'GR_RECORD_EXISTS');
168: FND_MESSAGE.SET_TOKEN('CODE',
169: p_item_code,
170: FALSE);
171: IF FND_API.To_Boolean(p_called_by_form) THEN
172: APP_EXCEPTION.Raise_Exception;
173: ELSE
174: x_msg_data := FND_MESSAGE.Get;
175: END IF;

Line 186: IF FND_API.To_Boolean(p_called_by_form) THEN

182: 'GR_NO_RECORD_INSERTED');
183: FND_MESSAGE.SET_TOKEN('CODE',
184: p_item_code,
185: FALSE);
186: IF FND_API.To_Boolean(p_called_by_form) THEN
187: APP_EXCEPTION.Raise_Exception;
188: ELSE
189: x_msg_data := FND_MESSAGE.Get;
190: END IF;

Line 202: IF FND_API.To_Boolean(p_called_by_form) THEN

198: 'GR_UNEXPECTED_ERROR');
199: FND_MESSAGE.SET_TOKEN('TEXT',
200: l_msg_data,
201: FALSE);
202: IF FND_API.To_Boolean(p_called_by_form) THEN
203: APP_EXCEPTION.Raise_Exception;
204: ELSE
205: x_msg_data := FND_MESSAGE.Get;
206: END IF;

Line 307: IF FND_API.To_Boolean(p_commit) THEN

303: END IF;
304:
305: /* Check the commit flag and if set, then commit the work. */
306:
307: IF FND_API.To_Boolean(p_commit) THEN
308: COMMIT WORK;
309: END IF;
310:
311: EXCEPTION

Line 322: IF FND_API.To_Boolean(p_called_by_form) THEN

318: 'GR_FOREIGN_KEY_ERROR');
319: FND_MESSAGE.SET_TOKEN('TEXT',
320: l_msg_data,
321: FALSE);
322: IF FND_API.To_Boolean(p_called_by_form) THEN
323: APP_EXCEPTION.Raise_Exception;
324: ELSE
325: x_msg_data := FND_MESSAGE.Get;
326: END IF;

Line 337: IF FND_API.To_Boolean(p_called_by_form) THEN

333: 'GR_NO_RECORD_INSERTED');
334: FND_MESSAGE.SET_TOKEN('CODE',
335: p_item_code,
336: FALSE);
337: IF FND_API.To_Boolean(p_called_by_form) THEN
338: APP_EXCEPTION.Raise_Exception;
339: ELSE
340: x_msg_data := FND_MESSAGE.Get;
341: END IF;

Line 353: IF FND_API.To_Boolean(p_called_by_form) THEN

349: 'GR_UNEXPECTED_ERROR');
350: FND_MESSAGE.SET_TOKEN('TEXT',
351: l_msg_data,
352: FALSE);
353: IF FND_API.To_Boolean(p_called_by_form) THEN
354: APP_EXCEPTION.Raise_Exception;
355: ELSE
356: x_msg_data := FND_MESSAGE.Get;
357: END IF;

Line 450: IF FND_API.To_Boolean(p_commit) THEN

446: RAISE No_Data_Found_Error;
447: END IF;
448: CLOSE c_lock_item;
449:
450: IF FND_API.To_Boolean(p_commit) THEN
451: COMMIT WORK;
452: END IF;
453:
454: EXCEPTION

Line 464: IF FND_API.To_Boolean(p_called_by_form) THEN

460: 'GR_RECORD_NOT_FOUND');
461: FND_MESSAGE.SET_TOKEN('CODE',
462: p_item_code,
463: FALSE);
464: IF FND_API.To_Boolean(p_called_by_form) THEN
465: APP_EXCEPTION.Raise_Exception;
466: ELSE
467: x_msg_data := FND_MESSAGE.Get;
468: END IF;

Line 476: IF FND_API.To_Boolean(p_called_by_form) THEN

472: x_return_status := 'E';
473: x_oracle_error := APP_EXCEPTION.Get_Code;
474: FND_MESSAGE.SET_NAME('GR',
475: 'GR_ROW_IS_LOCKED');
476: IF FND_API.To_Boolean(p_called_by_form) THEN
477: APP_EXCEPTION.Raise_Exception;
478: ELSE
479: x_msg_data := FND_MESSAGE.Get;
480: END IF;

Line 492: IF FND_API.To_Boolean(p_called_by_form) THEN

488: 'GR_UNEXPECTED_ERROR');
489: FND_MESSAGE.SET_TOKEN('TEXT',
490: l_msg_data,
491: FALSE);
492: IF FND_API.To_Boolean(p_called_by_form) THEN
493: APP_EXCEPTION.Raise_Exception;
494: ELSE
495: x_msg_data := FND_MESSAGE.Get;
496: END IF;

Line 592: IF FND_API.TO_Boolean(p_commit) THEN

588: WHERE rowid = p_rowid;
589:
590: /* Check the commit flag and if set, then commit the work. */
591:
592: IF FND_API.TO_Boolean(p_commit) THEN
593: COMMIT WORK;
594: END IF;
595:
596: EXCEPTION

Line 607: IF FND_API.To_Boolean(p_called_by_form) THEN

603: 'GR_RECORD_NOT_FOUND');
604: FND_MESSAGE.SET_TOKEN('CODE',
605: p_item_code,
606: FALSE);
607: IF FND_API.To_Boolean(p_called_by_form) THEN
608: APP_EXCEPTION.Raise_Exception;
609: ELSE
610: x_msg_data := FND_MESSAGE.Get;
611: END IF;

Line 623: IF FND_API.To_Boolean(p_called_by_form) THEN

619: 'GR_UNEXPECTED_ERROR');
620: FND_MESSAGE.SET_TOKEN('TEXT',
621: l_msg_data,
622: FALSE);
623: IF FND_API.To_Boolean(p_called_by_form) THEN
624: APP_EXCEPTION.Raise_Exception;
625: ELSE
626: x_msg_data := FND_MESSAGE.Get;
627: END IF;

Line 826: IF FND_API.To_Boolean(p_called_by_form) THEN

822: 'GR_UNEXPECTED_ERROR');
823: FND_MESSAGE.SET_TOKEN('TEXT',
824: l_msg_data,
825: FALSE);
826: IF FND_API.To_Boolean(p_called_by_form) THEN
827: APP_EXCEPTION.Raise_Exception;
828: END IF;
829:
830: END Check_Primary_Key;

Line 913: IF FND_API.To_Boolean(p_called_by_form) THEN

909: 'GR_UNEXPECTED_ERROR');
910: FND_MESSAGE.SET_TOKEN('TEXT',
911: l_msg_data,
912: FALSE);
913: IF FND_API.To_Boolean(p_called_by_form) THEN
914: APP_EXCEPTION.Raise_Exception;
915: ELSE
916: x_msg_data := FND_MESSAGE.Get;
917: END IF;