DBA Data[Home] [Help]

APPS.GR_EXPOSURE_TYPES_TL_PKG dependencies on FND_API

Line 71: IF FND_API.To_Boolean(l_key_exists) THEN

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

Line 105: IF FND_API.To_Boolean(l_key_exists) THEN

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

Line 113: IF FND_API.To_Boolean(p_commit) THEN

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

Line 128: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 144: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 160: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 177: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 260: IF FND_API.To_Boolean(p_commit) THEN

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

Line 275: IF FND_API.To_Boolean(p_called_by_form) THEN

271: 'GR_FOREIGN_KEY_ERROR');
272: FND_MESSAGE.SET_TOKEN('TEXT',
273: l_msg_data,
274: FALSE);
275: IF FND_API.To_Boolean(p_called_by_form) THEN
276: APP_EXCEPTION.Raise_Exception;
277: ELSE
278: x_msg_data := FND_MESSAGE.Get;
279: END IF;

Line 290: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 306: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 472: IF FND_API.To_Boolean(p_commit) THEN

468: END LOOP;
469: END IF;
470: CLOSE c_get_installed_languages;
471:
472: IF FND_API.To_Boolean(p_commit) THEN
473: COMMIT WORK;
474: END IF;
475:
476: EXCEPTION

Line 487: IF FND_API.To_Boolean(p_called_by_form) THEN

483: 'GR_RECORD_NOT_FOUND');
484: FND_MESSAGE.SET_TOKEN('CODE',
485: l_msg_token,
486: FALSE);
487: IF FND_API.To_Boolean(p_called_by_form) THEN
488: APP_EXCEPTION.Raise_Exception;
489: ELSE
490: x_msg_data := FND_MESSAGE.Get;
491: END IF;

Line 503: IF FND_API.To_Boolean(p_called_by_form) THEN

499: 'GR_UNEXPECTED_ERROR');
500: FND_MESSAGE.SET_TOKEN('TEXT',
501: l_msg_token,
502: FALSE);
503: IF FND_API.To_Boolean(p_called_by_form) THEN
504: APP_EXCEPTION.Raise_Exception;
505: ELSE
506: x_msg_data := FND_MESSAGE.Get;
507: END IF;

Line 577: IF FND_API.To_Boolean(p_commit) THEN

573: IF LockTypeRcd.last_update_date <> p_last_update_date THEN
574: RAISE RECORD_CHANGED_ERROR;
575: END IF;
576:
577: IF FND_API.To_Boolean(p_commit) THEN
578: COMMIT WORK;
579: END IF;
580:
581: EXCEPTION

Line 591: IF FND_API.To_Boolean(p_called_by_form) THEN

587: 'GR_RECORD_NOT_FOUND');
588: FND_MESSAGE.SET_TOKEN('CODE',
589: l_msg_token,
590: FALSE);
591: IF FND_API.To_Boolean(p_called_by_form) THEN
592: APP_EXCEPTION.Raise_Exception;
593: ELSE
594: x_msg_data := FND_MESSAGE.Get;
595: END IF;

Line 602: IF FND_API.To_Boolean(p_called_by_form) THEN

598: ROLLBACK TO SAVEPOINT Lock_Row;
599: X_return_status := 'E';
600: FND_MESSAGE.SET_NAME('FND',
601: 'FORM_RECORD_CHANGED');
602: IF FND_API.To_Boolean(p_called_by_form) THEN
603: APP_EXCEPTION.Raise_Exception;
604: ELSE
605: x_msg_data := FND_MESSAGE.Get;
606: END IF;

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

607: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
608: ROLLBACK TO SAVEPOINT Lock_Row;
609: x_return_status := 'L';
610: x_oracle_error := APP_EXCEPTION.Get_Code;
611: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN
612: FND_MESSAGE.SET_NAME('GR',
613: 'GR_ROW_IS_LOCKED');
614: x_msg_data := FND_MESSAGE.Get;
615: END IF;

Line 627: IF FND_API.To_Boolean(p_called_by_form) THEN

623: 'GR_UNEXPECTED_ERROR');
624: FND_MESSAGE.SET_TOKEN('TEXT',
625: l_msg_token,
626: FALSE);
627: IF FND_API.To_Boolean(p_called_by_form) THEN
628: APP_EXCEPTION.Raise_Exception;
629: ELSE
630: x_msg_data := FND_MESSAGE.Get;
631: END IF;

Line 704: IF FND_API.TO_Boolean(p_commit) THEN

700: WHERE rowid = p_rowid;
701:
702: /* Check the commit flag and if set, then commit the work. */
703:
704: IF FND_API.TO_Boolean(p_commit) THEN
705: COMMIT WORK;
706: END IF;
707:
708: EXCEPTION

Line 715: IF FND_API.To_Boolean(p_called_by_form) THEN

711: ROLLBACK TO SAVEPOINT Delete_Row;
712: x_return_status := l_return_status;
713: x_oracle_error := l_oracle_error;
714: x_msg_data := l_msg_data;
715: IF FND_API.To_Boolean(p_called_by_form) THEN
716: APP_EXCEPTION.Raise_Exception;
717: END IF;
718:
719: WHEN Row_Missing_Error THEN

Line 728: IF FND_API.To_Boolean(p_called_by_form) THEN

724: 'GR_RECORD_NOT_FOUND');
725: FND_MESSAGE.SET_TOKEN('CODE',
726: l_msg_token,
727: FALSE);
728: IF FND_API.To_Boolean(p_called_by_form) THEN
729: APP_EXCEPTION.Raise_Exception;
730: ELSE
731: x_msg_data := FND_MESSAGE.Get;
732: END IF;

Line 744: IF FND_API.To_Boolean(p_called_by_form) THEN

740: 'GR_UNEXPECTED_ERROR');
741: FND_MESSAGE.SET_TOKEN('TEXT',
742: l_msg_token,
743: FALSE);
744: IF FND_API.To_Boolean(p_called_by_form) THEN
745: APP_EXCEPTION.Raise_Exception;
746: ELSE
747: x_msg_data := FND_MESSAGE.Get;
748: END IF;

Line 786: IF FND_API.To_Boolean(p_commit) THEN

782:
783: DELETE FROM gr_exposure_types_tl
784: WHERE exposure_type_code = p_exposure_type_code;
785:
786: IF FND_API.To_Boolean(p_commit) THEN
787: COMMIT WORK;
788: END IF;
789:
790: EXCEPTION

Line 802: IF FND_API.To_Boolean(p_called_by_form) THEN

798: 'GR_UNEXPECTED_ERROR');
799: FND_MESSAGE.SET_TOKEN('TEXT',
800: l_msg_token,
801: FALSE);
802: IF FND_API.To_Boolean(p_called_by_form) THEN
803: APP_EXCEPTION.Raise_Exception;
804: ELSE
805: x_msg_data := FND_MESSAGE.Get;
806: END IF;

Line 967: IF FND_API.To_Boolean(p_called_by_form) THEN

963: 'GR_INSTALLED_LANG');
964: FND_MESSAGE.SET_TOKEN('CODE',
965: p_language,
966: FALSE);
967: IF FND_API.To_Boolean(p_called_by_form) THEN
968: APP_EXCEPTION.Raise_Exception;
969: ELSE
970: x_msg_data := FND_MESSAGE.Get;
971: END IF;

Line 983: IF FND_API.To_Boolean(p_called_by_form) THEN

979: 'GR_UNEXPECTED_ERROR');
980: FND_MESSAGE.SET_TOKEN('TEXT',
981: l_msg_data,
982: FALSE);
983: IF FND_API.To_Boolean(p_called_by_form) THEN
984: APP_EXCEPTION.Raise_Exception;
985: ELSE
986: x_msg_data := FND_MESSAGE.Get;
987: END IF;

Line 1042: IF FND_API.To_Boolean(p_called_by_form) THEN

1038: 'GR_UNEXPECTED_ERROR');
1039: FND_MESSAGE.SET_TOKEN('TEXT',
1040: l_msg_data,
1041: FALSE);
1042: IF FND_API.To_Boolean(p_called_by_form) THEN
1043: APP_EXCEPTION.Raise_Exception;
1044: END IF;
1045:
1046: END Check_Primary_Key;