DBA Data[Home] [Help]

APPS.GR_PHRASES_TL_PKG dependencies on FND_API

Line 154: IF FND_API.To_Boolean(l_key_exists) THEN

150: 'F',
151: l_rowid,
152: l_key_exists);
153:
154: IF FND_API.To_Boolean(l_key_exists) THEN
155: RAISE Item_Exists_Error;
156: END IF;
157:
158: INSERT INTO gr_phrases_tl

Line 270: IF FND_API.To_Boolean(l_key_exists) THEN

266: 'F',
267: l_rowid,
268: l_key_exists);
269:
270: IF FND_API.To_Boolean(l_key_exists) THEN
271: x_rowid := l_rowid;
272: ELSE
273: RAISE Row_Missing_Error;
274: END IF;

Line 278: IF FND_API.To_Boolean(p_commit) THEN

274: END IF;
275:
276: /* Check the commit flag and if set, then commit the work. */
277:
278: IF FND_API.To_Boolean(p_commit) THEN
279: COMMIT WORK;
280: END IF;
281:
282: EXCEPTION

Line 293: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 309: IF FND_API.To_Boolean(p_called_by_form) THEN

305: 'GR_RECORD_EXISTS');
306: FND_MESSAGE.SET_TOKEN('CODE',
307: l_msg_token,
308: FALSE);
309: IF FND_API.To_Boolean(p_called_by_form) THEN
310: APP_EXCEPTION.Raise_Exception;
311: ELSE
312: x_msg_data := FND_MESSAGE.Get;
313: END IF;

Line 325: IF FND_API.To_Boolean(p_called_by_form) THEN

321: 'GR_NO_RECORD_INSERTED');
322: FND_MESSAGE.SET_TOKEN('CODE',
323: l_msg_token,
324: FALSE);
325: IF FND_API.To_Boolean(p_called_by_form) THEN
326: APP_EXCEPTION.Raise_Exception;
327: ELSE
328: x_msg_data := FND_MESSAGE.Get;
329: END IF;

Line 342: IF FND_API.To_Boolean(p_called_by_form) THEN

338: 'GR_UNEXPECTED_ERROR');
339: FND_MESSAGE.SET_TOKEN('TEXT',
340: l_msg_token,
341: FALSE);
342: IF FND_API.To_Boolean(p_called_by_form) THEN
343: APP_EXCEPTION.Raise_Exception;
344: ELSE
345: x_msg_data := FND_MESSAGE.Get;
346: END IF;

Line 548: IF FND_API.To_Boolean(p_commit) THEN

544: END IF;
545:
546: /* Check the commit flag and if set, then commit the work. */
547:
548: IF FND_API.To_Boolean(p_commit) THEN
549: COMMIT WORK;
550: END IF;
551:
552: EXCEPTION

Line 563: IF FND_API.To_Boolean(p_called_by_form) THEN

559: 'GR_FOREIGN_KEY_ERROR');
560: FND_MESSAGE.SET_TOKEN('TEXT',
561: l_msg_data,
562: FALSE);
563: IF FND_API.To_Boolean(p_called_by_form) THEN
564: APP_EXCEPTION.Raise_Exception;
565: ELSE
566: x_msg_data := FND_MESSAGE.Get;
567: END IF;

Line 578: IF FND_API.To_Boolean(p_called_by_form) THEN

574: 'GR_NO_RECORD_INSERTED');
575: FND_MESSAGE.SET_TOKEN('CODE',
576: l_msg_token,
577: FALSE);
578: IF FND_API.To_Boolean(p_called_by_form) THEN
579: APP_EXCEPTION.Raise_Exception;
580: ELSE
581: x_msg_data := FND_MESSAGE.Get;
582: END IF;

Line 594: IF FND_API.To_Boolean(p_called_by_form) THEN

590: 'GR_UNEXPECTED_ERROR');
591: FND_MESSAGE.SET_TOKEN('TEXT',
592: l_msg_token,
593: FALSE);
594: IF FND_API.To_Boolean(p_called_by_form) THEN
595: APP_EXCEPTION.Raise_Exception;
596: ELSE
597: x_msg_data := FND_MESSAGE.Get;
598: END IF;

Line 967: IF FND_API.To_Boolean(p_commit) THEN

963: END LOOP;
964: END IF;
965: CLOSE c_get_installed_languages;
966:
967: IF FND_API.To_Boolean(p_commit) THEN
968: COMMIT WORK;
969: END IF;
970:
971: EXCEPTION

Line 982: IF FND_API.To_Boolean(p_called_by_form) THEN

978: 'GR_RECORD_NOT_FOUND');
979: FND_MESSAGE.SET_TOKEN('CODE',
980: l_msg_token,
981: FALSE);
982: IF FND_API.To_Boolean(p_called_by_form) THEN
983: APP_EXCEPTION.Raise_Exception;
984: ELSE
985: x_msg_data := FND_MESSAGE.Get;
986: END IF;

Line 998: IF FND_API.To_Boolean(p_called_by_form) THEN

994: 'GR_UNEXPECTED_ERROR');
995: FND_MESSAGE.SET_TOKEN('TEXT',
996: l_msg_token,
997: FALSE);
998: IF FND_API.To_Boolean(p_called_by_form) THEN
999: APP_EXCEPTION.Raise_Exception;
1000: ELSE
1001: x_msg_data := FND_MESSAGE.Get;
1002: END IF;

Line 1114: IF FND_API.To_Boolean(p_commit) THEN

1110: IF LockPhraseRcd.last_update_date <> p_last_update_date THEN
1111: RAISE RECORD_CHANGED_ERROR;
1112: END IF;
1113:
1114: IF FND_API.To_Boolean(p_commit) THEN
1115: COMMIT WORK;
1116: END IF;
1117:
1118: EXCEPTION

Line 1128: IF FND_API.To_Boolean(p_called_by_form) THEN

1124: 'GR_RECORD_NOT_FOUND');
1125: FND_MESSAGE.SET_TOKEN('CODE',
1126: l_msg_token,
1127: FALSE);
1128: IF FND_API.To_Boolean(p_called_by_form) THEN
1129: APP_EXCEPTION.Raise_Exception;
1130: ELSE
1131: x_msg_data := FND_MESSAGE.Get;
1132: END IF;

Line 1139: IF FND_API.To_Boolean(p_called_by_form) THEN

1135: ROLLBACK TO SAVEPOINT Lock_Row;
1136: X_return_status := 'E';
1137: FND_MESSAGE.SET_NAME('FND',
1138: 'FORM_RECORD_CHANGED');
1139: IF FND_API.To_Boolean(p_called_by_form) THEN
1140: APP_EXCEPTION.Raise_Exception;
1141: ELSE
1142: x_msg_data := FND_MESSAGE.Get;
1143: END IF;

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

1144: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
1145: ROLLBACK TO SAVEPOINT Lock_Row;
1146: x_return_status := 'L';
1147: x_oracle_error := APP_EXCEPTION.Get_Code;
1148: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN
1149: FND_MESSAGE.SET_NAME('GR',
1150: 'GR_ROW_IS_LOCKED');
1151: x_msg_data := FND_MESSAGE.Get;
1152: END IF;

Line 1163: IF FND_API.To_Boolean(p_called_by_form) THEN

1159: 'GR_UNEXPECTED_ERROR');
1160: FND_MESSAGE.SET_TOKEN('TEXT',
1161: l_msg_token,
1162: FALSE);
1163: IF FND_API.To_Boolean(p_called_by_form) THEN
1164: APP_EXCEPTION.Raise_Exception;
1165: ELSE
1166: x_msg_data := FND_MESSAGE.Get;
1167: END IF;

Line 1322: IF FND_API.TO_Boolean(p_commit) THEN

1318: WHERE rowid = p_rowid;
1319:
1320: /* Check the commit flag and if set, then commit the work. */
1321:
1322: IF FND_API.TO_Boolean(p_commit) THEN
1323: COMMIT WORK;
1324: END IF;
1325:
1326: EXCEPTION

Line 1332: IF FND_API.To_Boolean(p_called_by_form) THEN

1328: WHEN Check_Integrity_Error THEN
1329: ROLLBACK TO SAVEPOINT Delete_Row;
1330: x_return_status := l_return_status;
1331: x_oracle_error := l_oracle_error;
1332: IF FND_API.To_Boolean(p_called_by_form) THEN
1333: APP_EXCEPTION.Raise_Exception;
1334: ELSE
1335: x_msg_data := FND_MESSAGE.Get;
1336: END IF;

Line 1347: IF FND_API.To_Boolean(p_called_by_form) THEN

1343: 'GR_RECORD_NOT_FOUND');
1344: FND_MESSAGE.SET_TOKEN('CODE',
1345: l_msg_token,
1346: FALSE);
1347: IF FND_API.To_Boolean(p_called_by_form) THEN
1348: APP_EXCEPTION.Raise_Exception;
1349: ELSE
1350: x_msg_data := FND_MESSAGE.Get;
1351: END IF;

Line 1363: IF FND_API.To_Boolean(p_called_by_form) THEN

1359: 'GR_UNEXPECTED_ERROR');
1360: FND_MESSAGE.SET_TOKEN('TEXT',
1361: l_msg_token,
1362: FALSE);
1363: IF FND_API.To_Boolean(p_called_by_form) THEN
1364: APP_EXCEPTION.Raise_Exception;
1365: ELSE
1366: x_msg_data := FND_MESSAGE.Get;
1367: END IF;

Line 1405: IF FND_API.To_Boolean(p_commit) THEN

1401:
1402: DELETE FROM gr_phrases_tl
1403: WHERE phrase_code = p_phrase_code;
1404:
1405: IF FND_API.To_Boolean(p_commit) THEN
1406: COMMIT WORK;
1407: END IF;
1408:
1409: EXCEPTION

Line 1421: IF FND_API.To_Boolean(p_called_by_form) THEN

1417: 'GR_UNEXPECTED_ERROR');
1418: FND_MESSAGE.SET_TOKEN('TEXT',
1419: l_msg_token,
1420: FALSE);
1421: IF FND_API.To_Boolean(p_called_by_form) THEN
1422: APP_EXCEPTION.Raise_Exception;
1423: ELSE
1424: x_msg_data := FND_MESSAGE.Get;
1425: END IF;

Line 1670: IF FND_API.To_Boolean(p_called_by_form) THEN

1666: 'GR_INSTALLED_LANG');
1667: FND_MESSAGE.SET_TOKEN('CODE',
1668: p_language,
1669: FALSE);
1670: IF FND_API.To_Boolean(p_called_by_form) THEN
1671: APP_EXCEPTION.Raise_Exception;
1672: ELSE
1673: x_msg_data := FND_MESSAGE.Get;
1674: END IF;

Line 1686: IF FND_API.To_Boolean(p_called_by_form) THEN

1682: 'GR_UNEXPECTED_ERROR');
1683: FND_MESSAGE.SET_TOKEN('TEXT',
1684: l_msg_data,
1685: FALSE);
1686: IF FND_API.To_Boolean(p_called_by_form) THEN
1687: APP_EXCEPTION.Raise_Exception;
1688: ELSE
1689: x_msg_data := FND_MESSAGE.Get;
1690: END IF;

Line 1746: IF FND_API.To_Boolean(p_called_by_form) THEN

1742: 'GR_UNEXPECTED_ERROR');
1743: FND_MESSAGE.SET_TOKEN('TEXT',
1744: l_msg_data,
1745: FALSE);
1746: IF FND_API.To_Boolean(p_called_by_form) THEN
1747: APP_EXCEPTION.Raise_Exception;
1748: END IF;
1749:
1750: END Check_Primary_Key;