DBA Data[Home] [Help]

APPS.GR_PHRASES_B_PKG dependencies on FND_API

Line 130: IF FND_API.To_Boolean(l_key_exists) THEN

126: 'F',
127: l_rowid,
128: l_key_exists);
129:
130: IF FND_API.To_Boolean(l_key_exists) THEN
131: RAISE Label_Exists_Error;
132: END IF;
133:
134: INSERT INTO gr_phrases_b

Line 223: IF FND_API.To_Boolean(l_key_exists) THEN

219: 'F',
220: l_rowid,
221: l_key_exists);
222:
223: IF FND_API.To_Boolean(l_key_exists) THEN
224: x_rowid := l_rowid;
225: ELSE
226: RAISE Row_Missing_Error;
227: END IF;

Line 231: IF FND_API.To_Boolean(p_commit) THEN

227: END IF;
228:
229: /* Check the commit flag and if set, then commit the work. */
230:
231: IF FND_API.To_Boolean(p_commit) THEN
232: COMMIT WORK;
233: END IF;
234:
235: EXCEPTION

Line 246: IF FND_API.To_Boolean(p_called_by_form) THEN

242: 'GR_FOREIGN_KEY_ERROR');
243: FND_MESSAGE.SET_TOKEN('TEXT',
244: l_msg_data,
245: FALSE);
246: IF FND_API.To_Boolean(p_called_by_form) THEN
247: APP_EXCEPTION.Raise_Exception;
248: ELSE
249: x_msg_data := FND_MESSAGE.Get;
250: END IF;

Line 261: IF FND_API.To_Boolean(p_called_by_form) THEN

257: 'GR_RECORD_EXISTS');
258: FND_MESSAGE.SET_TOKEN('CODE',
259: p_phrase_code,
260: FALSE);
261: IF FND_API.To_Boolean(p_called_by_form) THEN
262: APP_EXCEPTION.Raise_Exception;
263: ELSE
264: x_msg_data := FND_MESSAGE.Get;
265: END IF;

Line 276: IF FND_API.To_Boolean(p_called_by_form) THEN

272: 'GR_NO_RECORD_INSERTED');
273: FND_MESSAGE.SET_TOKEN('CODE',
274: p_phrase_code,
275: FALSE);
276: IF FND_API.To_Boolean(p_called_by_form) THEN
277: APP_EXCEPTION.Raise_Exception;
278: ELSE
279: x_msg_data := FND_MESSAGE.Get;
280: END IF;

Line 292: IF FND_API.To_Boolean(p_called_by_form) THEN

288: 'GR_UNEXPECTED_ERROR');
289: FND_MESSAGE.SET_TOKEN('TEXT',
290: l_msg_data,
291: FALSE);
292: IF FND_API.To_Boolean(p_called_by_form) THEN
293: APP_EXCEPTION.Raise_Exception;
294: ELSE
295: x_msg_data := FND_MESSAGE.Get;
296: END IF;

Line 463: IF FND_API.To_Boolean(p_commit) THEN

459: END IF;
460:
461: /* Check the commit flag and if set, then commit the work. */
462:
463: IF FND_API.To_Boolean(p_commit) THEN
464: COMMIT WORK;
465: END IF;
466:
467: EXCEPTION

Line 478: IF FND_API.To_Boolean(p_called_by_form) THEN

474: 'GR_FOREIGN_KEY_ERROR');
475: FND_MESSAGE.SET_TOKEN('TEXT',
476: l_msg_data,
477: FALSE);
478: IF FND_API.To_Boolean(p_called_by_form) THEN
479: APP_EXCEPTION.Raise_Exception;
480: ELSE
481: x_msg_data := FND_MESSAGE.Get;
482: END IF;

Line 493: IF FND_API.To_Boolean(p_called_by_form) THEN

489: 'GR_NO_RECORD_INSERTED');
490: FND_MESSAGE.SET_TOKEN('CODE',
491: p_phrase_code,
492: FALSE);
493: IF FND_API.To_Boolean(p_called_by_form) THEN
494: APP_EXCEPTION.Raise_Exception;
495: ELSE
496: x_msg_data := FND_MESSAGE.Get;
497: END IF;

Line 509: IF FND_API.To_Boolean(p_called_by_form) THEN

505: 'GR_UNEXPECTED_ERROR');
506: FND_MESSAGE.SET_TOKEN('TEXT',
507: l_msg_data,
508: FALSE);
509: IF FND_API.To_Boolean(p_called_by_form) THEN
510: APP_EXCEPTION.Raise_Exception;
511: ELSE
512: x_msg_data := FND_MESSAGE.Get;
513: END IF;

Line 612: IF FND_API.To_Boolean(p_commit) THEN

608: IF LockPhraseRcd.last_update_date <> p_last_update_date THEN
609: RAISE RECORD_CHANGED_ERROR;
610: END IF;
611:
612: IF FND_API.To_Boolean(p_commit) THEN
613: COMMIT WORK;
614: END IF;
615:
616: EXCEPTION

Line 626: IF FND_API.To_Boolean(p_called_by_form) THEN

622: 'GR_RECORD_NOT_FOUND');
623: FND_MESSAGE.SET_TOKEN('CODE',
624: p_phrase_code,
625: FALSE);
626: IF FND_API.To_Boolean(p_called_by_form) THEN
627: APP_EXCEPTION.Raise_Exception;
628: ELSE
629: x_msg_data := FND_MESSAGE.Get;
630: END IF;

Line 636: IF FND_API.To_Boolean(p_called_by_form) THEN

632: ROLLBACK TO SAVEPOINT Lock_Row;
633: X_return_status := 'E';
634: FND_MESSAGE.SET_NAME('FND',
635: 'FORM_RECORD_CHANGED');
636: IF FND_API.To_Boolean(p_called_by_form) THEN
637: APP_EXCEPTION.Raise_Exception;
638: ELSE
639: x_msg_data := FND_MESSAGE.Get;
640: END IF;

Line 645: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN

641: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
642: ROLLBACK TO SAVEPOINT Lock_Row;
643: x_return_status := 'L';
644: x_oracle_error := APP_EXCEPTION.Get_Code;
645: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN
646: FND_MESSAGE.SET_NAME('GR',
647: 'GR_ROW_IS_LOCKED');
648: x_msg_data := FND_MESSAGE.Get;
649: END IF;

Line 660: IF FND_API.To_Boolean(p_called_by_form) THEN

656: 'GR_UNEXPECTED_ERROR');
657: FND_MESSAGE.SET_TOKEN('TEXT',
658: l_msg_data,
659: FALSE);
660: IF FND_API.To_Boolean(p_called_by_form) THEN
661: APP_EXCEPTION.Raise_Exception;
662: ELSE
663: x_msg_data := FND_MESSAGE.Get;
664: END IF;

Line 793: IF FND_API.TO_Boolean(p_commit) THEN

789: WHERE rowid = p_rowid;
790:
791: /* Check the commit flag and if set, then commit the work. */
792:
793: IF FND_API.TO_Boolean(p_commit) THEN
794: COMMIT WORK;
795: END IF;
796:
797: EXCEPTION

Line 803: IF FND_API.To_Boolean(p_called_by_form) THEN

799: WHEN Check_Integrity_Error THEN
800: ROLLBACK TO SAVEPOINT Delete_Row;
801: x_return_status := l_return_status;
802: x_oracle_error := l_oracle_error;
803: IF FND_API.To_Boolean(p_called_by_form) THEN
804: APP_EXCEPTION.Raise_Exception;
805: ELSE
806: x_msg_data := FND_MESSAGE.Get;
807: END IF;

Line 818: IF FND_API.To_Boolean(p_called_by_form) THEN

814: 'GR_RECORD_NOT_FOUND');
815: FND_MESSAGE.SET_TOKEN('CODE',
816: p_phrase_code,
817: FALSE);
818: IF FND_API.To_Boolean(p_called_by_form) THEN
819: APP_EXCEPTION.Raise_Exception;
820: ELSE
821: x_msg_data := FND_MESSAGE.Get;
822: END IF;

Line 835: IF FND_API.To_Boolean(p_called_by_form) THEN

831: 'GR_UNEXPECTED_ERROR');
832: FND_MESSAGE.SET_TOKEN('TEXT',
833: l_msg_data,
834: FALSE);
835: IF FND_API.To_Boolean(p_called_by_form) THEN
836: APP_EXCEPTION.Raise_Exception;
837: ELSE
838: x_msg_data := FND_MESSAGE.Get;
839: END IF;

Line 1205: IF FND_API.To_Boolean(p_called_by_form) THEN

1201: 'GR_UNEXPECTED_ERROR');
1202: FND_MESSAGE.SET_TOKEN('TEXT',
1203: l_msg_data,
1204: FALSE);
1205: IF FND_API.To_Boolean(p_called_by_form) THEN
1206: APP_EXCEPTION.Raise_Exception;
1207: ELSE
1208: x_msg_data := FND_MESSAGE.Get;
1209: END IF;

Line 1261: IF FND_API.To_Boolean(p_called_by_form) THEN

1257: 'GR_UNEXPECTED_ERROR');
1258: FND_MESSAGE.SET_TOKEN('TEXT',
1259: l_msg_data,
1260: FALSE);
1261: IF FND_API.To_Boolean(p_called_by_form) THEN
1262: APP_EXCEPTION.Raise_Exception;
1263: END IF;
1264:
1265: END Check_Primary_Key;