DBA Data[Home] [Help]

APPS.GR_ITEM_RIGHT_TO_KNOW_PKG dependencies on FND_API

Line 94: IF FND_API.To_Boolean(l_key_exists) THEN

90: 'F',
91: l_rowid,
92: l_key_exists);
93:
94: IF FND_API.To_Boolean(l_key_exists) THEN
95: RAISE Label_Exists_Error;
96: END IF;
97:
98: INSERT INTO gr_item_right_to_know

Line 150: IF FND_API.To_Boolean(l_key_exists) THEN

146: 'F',
147: l_rowid,
148: l_key_exists);
149:
150: IF FND_API.To_Boolean(l_key_exists) THEN
151: x_rowid := l_rowid;
152: ELSE
153: RAISE Row_Missing_Error;
154: END IF;

Line 158: IF FND_API.To_Boolean(p_commit) THEN

154: END IF;
155:
156: /* Check the commit flag and if set, then commit the work. */
157:
158: IF FND_API.To_Boolean(p_commit) THEN
159: COMMIT WORK;
160: END IF;
161:
162: EXCEPTION

Line 173: IF FND_API.To_Boolean(p_called_by_form) THEN

169: 'GR_FOREIGN_KEY_ERROR');
170: FND_MESSAGE.SET_TOKEN('TEXT',
171: l_msg_data,
172: FALSE);
173: IF FND_API.To_Boolean(p_called_by_form) THEN
174: APP_EXCEPTION.Raise_Exception;
175: ELSE
176: x_msg_data := FND_MESSAGE.Get;
177: END IF;

Line 188: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 203: IF FND_API.To_Boolean(p_called_by_form) THEN

199: 'GR_NO_RECORD_INSERTED');
200: FND_MESSAGE.SET_TOKEN('CODE',
201: p_item_code,
202: FALSE);
203: IF FND_API.To_Boolean(p_called_by_form) THEN
204: APP_EXCEPTION.Raise_Exception;
205: ELSE
206: x_msg_data := FND_MESSAGE.Get;
207: END IF;

Line 219: IF FND_API.To_Boolean(p_called_by_form) THEN

215: 'GR_UNEXPECTED_ERROR');
216: FND_MESSAGE.SET_TOKEN('TEXT',
217: l_msg_data,
218: FALSE);
219: IF FND_API.To_Boolean(p_called_by_form) THEN
220: APP_EXCEPTION.Raise_Exception;
221: ELSE
222: x_msg_data := FND_MESSAGE.Get;
223: END IF;

Line 330: IF FND_API.To_Boolean(p_commit) THEN

326: END IF;
327:
328: /* Check the commit flag and if set, then commit the work. */
329:
330: IF FND_API.To_Boolean(p_commit) THEN
331: COMMIT WORK;
332: END IF;
333:
334: EXCEPTION

Line 345: IF FND_API.To_Boolean(p_called_by_form) THEN

341: 'GR_FOREIGN_KEY_ERROR');
342: FND_MESSAGE.SET_TOKEN('TEXT',
343: l_msg_data,
344: FALSE);
345: IF FND_API.To_Boolean(p_called_by_form) THEN
346: APP_EXCEPTION.Raise_Exception;
347: ELSE
348: x_msg_data := FND_MESSAGE.Get;
349: END IF;

Line 360: IF FND_API.To_Boolean(p_called_by_form) THEN

356: 'GR_NO_RECORD_INSERTED');
357: FND_MESSAGE.SET_TOKEN('CODE',
358: p_item_code,
359: FALSE);
360: IF FND_API.To_Boolean(p_called_by_form) THEN
361: APP_EXCEPTION.Raise_Exception;
362: ELSE
363: x_msg_data := FND_MESSAGE.Get;
364: END IF;

Line 376: IF FND_API.To_Boolean(p_called_by_form) THEN

372: 'GR_UNEXPECTED_ERROR');
373: FND_MESSAGE.SET_TOKEN('TEXT',
374: l_msg_data,
375: FALSE);
376: IF FND_API.To_Boolean(p_called_by_form) THEN
377: APP_EXCEPTION.Raise_Exception;
378: ELSE
379: x_msg_data := FND_MESSAGE.Get;
380: END IF;

Line 456: IF FND_API.To_Boolean(p_commit) THEN

452: RAISE No_Data_Found_Error;
453: END IF;
454: CLOSE c_lock_item;
455:
456: IF FND_API.To_Boolean(p_commit) THEN
457: COMMIT WORK;
458: END IF;
459:
460: EXCEPTION

Line 470: IF FND_API.To_Boolean(p_called_by_form) THEN

466: 'GR_RECORD_NOT_FOUND');
467: FND_MESSAGE.SET_TOKEN('CODE',
468: p_item_code,
469: FALSE);
470: IF FND_API.To_Boolean(p_called_by_form) THEN
471: APP_EXCEPTION.Raise_Exception;
472: ELSE
473: x_msg_data := FND_MESSAGE.Get;
474: END IF;

Line 482: IF FND_API.To_Boolean(p_called_by_form) THEN

478: x_return_status := 'E';
479: x_oracle_error := APP_EXCEPTION.Get_Code;
480: FND_MESSAGE.SET_NAME('GR',
481: 'GR_ROW_IS_LOCKED');
482: IF FND_API.To_Boolean(p_called_by_form) THEN
483: APP_EXCEPTION.Raise_Exception;
484: ELSE
485: x_msg_data := FND_MESSAGE.Get;
486: END IF;

Line 498: IF FND_API.To_Boolean(p_called_by_form) THEN

494: 'GR_UNEXPECTED_ERROR');
495: FND_MESSAGE.SET_TOKEN('TEXT',
496: l_msg_data,
497: FALSE);
498: IF FND_API.To_Boolean(p_called_by_form) THEN
499: APP_EXCEPTION.Raise_Exception;
500: ELSE
501: x_msg_data := FND_MESSAGE.Get;
502: END IF;

Line 591: IF FND_API.TO_Boolean(p_commit) THEN

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

Line 601: IF FND_API.To_Boolean(p_called_by_form) THEN

597: WHEN Check_Integrity_Error THEN
598: ROLLBACK TO SAVEPOINT Delete_Row;
599: x_return_status := l_return_status;
600: x_oracle_error := l_oracle_error;
601: IF FND_API.To_Boolean(p_called_by_form) THEN
602: APP_EXCEPTION.Raise_Exception;
603: ELSE
604: x_msg_data := FND_MESSAGE.Get;
605: END IF;

Line 616: IF FND_API.To_Boolean(p_called_by_form) THEN

612: 'GR_RECORD_NOT_FOUND');
613: FND_MESSAGE.SET_TOKEN('CODE',
614: p_item_code,
615: FALSE);
616: IF FND_API.To_Boolean(p_called_by_form) THEN
617: APP_EXCEPTION.Raise_Exception;
618: ELSE
619: x_msg_data := FND_MESSAGE.Get;
620: END IF;

Line 633: IF FND_API.To_Boolean(p_called_by_form) THEN

629: 'GR_UNEXPECTED_ERROR');
630: FND_MESSAGE.SET_TOKEN('TEXT',
631: l_msg_data,
632: FALSE);
633: IF FND_API.To_Boolean(p_called_by_form) THEN
634: APP_EXCEPTION.Raise_Exception;
635: ELSE
636: x_msg_data := FND_MESSAGE.Get;
637: END IF;

Line 675: IF FND_API.To_Boolean(p_commit) THEN

671:
672: DELETE FROM gr_item_right_to_know
673: WHERE item_code = p_item_code;
674:
675: IF FND_API.To_Boolean(p_commit) THEN
676: COMMIT WORK;
677: END IF;
678:
679: EXCEPTION

Line 691: IF FND_API.To_Boolean(p_called_by_form) THEN

687: 'GR_UNEXPECTED_ERROR');
688: FND_MESSAGE.SET_TOKEN('TEXT',
689: l_msg_token,
690: FALSE);
691: IF FND_API.To_Boolean(p_called_by_form) THEN
692: APP_EXCEPTION.Raise_Exception;
693: ELSE
694: x_msg_data := FND_MESSAGE.Get;
695: END IF;

Line 761: IF NOT FND_API.To_Boolean(l_key_exists) THEN

757: 'F',
758: l_rowid,
759: l_key_exists);
760:
761: IF NOT FND_API.To_Boolean(l_key_exists) THEN
762: x_return_status := 'E';
763: FND_MESSAGE.SET_NAME('GR',
764: 'GR_RECORD_NOT_FOUND');
765: FND_MESSAGE.SET_TOKEN('CODE',

Line 874: IF FND_API.To_Boolean(p_called_by_form) THEN

870: 'GR_UNEXPECTED_ERROR');
871: FND_MESSAGE.SET_TOKEN('TEXT',
872: l_msg_data,
873: FALSE);
874: IF FND_API.To_Boolean(p_called_by_form) THEN
875: APP_EXCEPTION.Raise_Exception;
876: ELSE
877: x_msg_data := FND_MESSAGE.Get;
878: END IF;

Line 936: IF FND_API.To_Boolean(p_called_by_form) THEN

932: 'GR_UNEXPECTED_ERROR');
933: FND_MESSAGE.SET_TOKEN('TEXT',
934: l_msg_data,
935: FALSE);
936: IF FND_API.To_Boolean(p_called_by_form) THEN
937: APP_EXCEPTION.Raise_Exception;
938: END IF;
939:
940: END Check_Primary_Key;