DBA Data[Home] [Help]

APPS.GR_EXPOSURE_AUTHS_TL_PKG dependencies on FND_API

Line 73: IF FND_API.To_Boolean(l_key_exists) THEN

69: 'F',
70: l_rowid,
71: l_key_exists);
72:
73: IF FND_API.To_Boolean(l_key_exists) THEN
74: RAISE Item_Exists_Error;
75: END IF;
76:
77: INSERT INTO gr_exposure_auths_tl

Line 107: IF FND_API.To_Boolean(l_key_exists) THEN

103: 'F',
104: l_rowid,
105: l_key_exists);
106:
107: IF FND_API.To_Boolean(l_key_exists) THEN
108: x_rowid := l_rowid;
109: ELSE
110: RAISE Row_Missing_Error;
111: END IF;

Line 115: IF FND_API.To_Boolean(p_commit) THEN

111: END IF;
112:
113: /* Check the commit flag and if set, then commit the work. */
114:
115: IF FND_API.To_Boolean(p_commit) THEN
116: COMMIT WORK;
117: END IF;
118:
119: EXCEPTION

Line 130: IF FND_API.To_Boolean(p_called_by_form) THEN

126: 'GR_FOREIGN_KEY_ERROR');
127: FND_MESSAGE.SET_TOKEN('TEXT',
128: l_msg_data,
129: FALSE);
130: IF FND_API.To_Boolean(p_called_by_form) THEN
131: APP_EXCEPTION.Raise_Exception;
132: ELSE
133: x_msg_data := FND_MESSAGE.Get;
134: END IF;

Line 146: IF FND_API.To_Boolean(p_called_by_form) THEN

142: 'GR_RECORD_EXISTS');
143: FND_MESSAGE.SET_TOKEN('CODE',
144: l_msg_token,
145: FALSE);
146: IF FND_API.To_Boolean(p_called_by_form) THEN
147: APP_EXCEPTION.Raise_Exception;
148: ELSE
149: x_msg_data := FND_MESSAGE.Get;
150: END IF;

Line 162: IF FND_API.To_Boolean(p_called_by_form) THEN

158: 'GR_NO_RECORD_INSERTED');
159: FND_MESSAGE.SET_TOKEN('CODE',
160: l_msg_token,
161: FALSE);
162: IF FND_API.To_Boolean(p_called_by_form) THEN
163: APP_EXCEPTION.Raise_Exception;
164: ELSE
165: x_msg_data := FND_MESSAGE.Get;
166: END IF;

Line 179: IF FND_API.To_Boolean(p_called_by_form) THEN

175: 'GR_UNEXPECTED_ERROR');
176: FND_MESSAGE.SET_TOKEN('TEXT',
177: l_msg_token,
178: FALSE);
179: IF FND_API.To_Boolean(p_called_by_form) THEN
180: APP_EXCEPTION.Raise_Exception;
181: ELSE
182: x_msg_data := FND_MESSAGE.Get;
183: END IF;

Line 261: IF FND_API.To_Boolean(p_commit) THEN

257: END IF;
258:
259: /* Check the commit flag and if set, then commit the work. */
260:
261: IF FND_API.To_Boolean(p_commit) THEN
262: COMMIT WORK;
263: END IF;
264:
265: EXCEPTION

Line 276: IF FND_API.To_Boolean(p_called_by_form) THEN

272: 'GR_FOREIGN_KEY_ERROR');
273: FND_MESSAGE.SET_TOKEN('TEXT',
274: l_msg_data,
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 291: IF FND_API.To_Boolean(p_called_by_form) THEN

287: 'GR_NO_RECORD_INSERTED');
288: FND_MESSAGE.SET_TOKEN('CODE',
289: l_msg_token,
290: FALSE);
291: IF FND_API.To_Boolean(p_called_by_form) THEN
292: APP_EXCEPTION.Raise_Exception;
293: ELSE
294: x_msg_data := FND_MESSAGE.Get;
295: END IF;

Line 307: IF FND_API.To_Boolean(p_called_by_form) THEN

303: 'GR_UNEXPECTED_ERROR');
304: FND_MESSAGE.SET_TOKEN('TEXT',
305: l_msg_token,
306: FALSE);
307: IF FND_API.To_Boolean(p_called_by_form) THEN
308: APP_EXCEPTION.Raise_Exception;
309: ELSE
310: x_msg_data := FND_MESSAGE.Get;
311: END IF;

Line 477: IF FND_API.To_Boolean(p_commit) THEN

473: END LOOP;
474: END IF;
475: CLOSE c_get_installed_languages;
476:
477: IF FND_API.To_Boolean(p_commit) THEN
478: COMMIT WORK;
479: END IF;
480:
481: EXCEPTION

Line 492: IF FND_API.To_Boolean(p_called_by_form) THEN

488: 'GR_RECORD_NOT_FOUND');
489: FND_MESSAGE.SET_TOKEN('CODE',
490: l_msg_token,
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 508: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 582: IF FND_API.To_Boolean(p_commit) THEN

578: IF LockAuthRcd.last_update_date <> p_last_update_date THEN
579: RAISE RECORD_CHANGED_ERROR;
580: END IF;
581:
582: IF FND_API.To_Boolean(p_commit) THEN
583: COMMIT WORK;
584: END IF;
585:
586: EXCEPTION

Line 596: IF FND_API.To_Boolean(p_called_by_form) THEN

592: 'GR_RECORD_NOT_FOUND');
593: FND_MESSAGE.SET_TOKEN('CODE',
594: l_msg_token,
595: FALSE);
596: IF FND_API.To_Boolean(p_called_by_form) THEN
597: APP_EXCEPTION.Raise_Exception;
598: ELSE
599: x_msg_data := FND_MESSAGE.Get;
600: END IF;

Line 607: IF FND_API.To_Boolean(p_called_by_form) THEN

603: ROLLBACK TO SAVEPOINT Lock_Row;
604: X_return_status := 'E';
605: FND_MESSAGE.SET_NAME('FND',
606: 'FORM_RECORD_CHANGED');
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 616: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN

612: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
613: ROLLBACK TO SAVEPOINT Lock_Row;
614: x_return_status := 'L';
615: x_oracle_error := APP_EXCEPTION.Get_Code;
616: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN
617: FND_MESSAGE.SET_NAME('GR',
618: 'GR_ROW_IS_LOCKED');
619: x_msg_data := FND_MESSAGE.Get;
620: END IF;

Line 632: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 709: IF FND_API.TO_Boolean(p_commit) THEN

705: WHERE rowid = p_rowid;
706:
707: /* Check the commit flag and if set, then commit the work. */
708:
709: IF FND_API.TO_Boolean(p_commit) THEN
710: COMMIT WORK;
711: END IF;
712:
713: EXCEPTION

Line 719: IF FND_API.To_Boolean(p_called_by_form) THEN

715: WHEN Check_Integrity_Error THEN
716: ROLLBACK TO SAVEPOINT Delete_Row;
717: x_return_status := l_return_status;
718: x_oracle_error := l_oracle_error;
719: IF FND_API.To_Boolean(p_called_by_form) THEN
720: APP_EXCEPTION.Raise_Exception;
721: ELSE
722: x_msg_data := FND_MESSAGE.Get;
723: END IF;

Line 735: IF FND_API.To_Boolean(p_called_by_form) THEN

731: FND_MESSAGE.SET_TOKEN('CODE',
732: l_msg_token,
733: FALSE);
734: x_msg_data := FND_MESSAGE.Get;
735: IF FND_API.To_Boolean(p_called_by_form) THEN
736: APP_EXCEPTION.Raise_Exception;
737: ELSE
738: x_msg_data := FND_MESSAGE.Get;
739: END IF;

Line 751: IF FND_API.To_Boolean(p_called_by_form) THEN

747: 'GR_UNEXPECTED_ERROR');
748: FND_MESSAGE.SET_TOKEN('TEXT',
749: l_msg_token,
750: FALSE);
751: IF FND_API.To_Boolean(p_called_by_form) THEN
752: APP_EXCEPTION.Raise_Exception;
753: ELSE
754: x_msg_data := FND_MESSAGE.Get;
755: END IF;

Line 793: IF FND_API.To_Boolean(p_commit) THEN

789:
790: DELETE FROM gr_exposure_auths_tl
791: WHERE exposure_authority_code = p_exposure_authority_code;
792:
793: IF FND_API.To_Boolean(p_commit) THEN
794: COMMIT WORK;
795: END IF;
796:
797: EXCEPTION

Line 809: IF FND_API.To_Boolean(p_called_by_form) THEN

805: 'GR_UNEXPECTED_ERROR');
806: FND_MESSAGE.SET_TOKEN('TEXT',
807: l_msg_token,
808: FALSE);
809: IF FND_API.To_Boolean(p_called_by_form) THEN
810: APP_EXCEPTION.Raise_Exception;
811: ELSE
812: x_msg_data := FND_MESSAGE.Get;
813: END IF;

Line 976: IF FND_API.To_Boolean(p_called_by_form) THEN

972: 'GR_INSTALLED_LANG');
973: FND_MESSAGE.SET_TOKEN('CODE',
974: p_language,
975: FALSE);
976: IF FND_API.To_Boolean(p_called_by_form) THEN
977: APP_EXCEPTION.Raise_Exception;
978: ELSE
979: x_msg_data := FND_MESSAGE.Get;
980: END IF;

Line 992: IF FND_API.To_Boolean(p_called_by_form) THEN

988: 'GR_UNEXPECTED_ERROR');
989: FND_MESSAGE.SET_TOKEN('TEXT',
990: l_msg_data,
991: FALSE);
992: IF FND_API.To_Boolean(p_called_by_form) THEN
993: APP_EXCEPTION.Raise_Exception;
994: ELSE
995: x_msg_data := FND_MESSAGE.Get;
996: END IF;

Line 1052: IF FND_API.To_Boolean(p_called_by_form) THEN

1048: 'GR_UNEXPECTED_ERROR');
1049: FND_MESSAGE.SET_TOKEN('TEXT',
1050: l_msg_data,
1051: FALSE);
1052: IF FND_API.To_Boolean(p_called_by_form) THEN
1053: APP_EXCEPTION.Raise_Exception;
1054: END IF;
1055:
1056: END Check_Primary_Key;