DBA Data[Home] [Help]

APPS.GR_GENERIC_ML_NAME_TL_PKG dependencies on FND_API

Line 139: IF FND_API.To_Boolean(l_key_exists) THEN

135: 'F',
136: l_rowid,
137: l_key_exists);
138:
139: IF FND_API.To_Boolean(l_key_exists) THEN
140: RAISE Item_Exists_Error;
141: END IF;
142:
143: INSERT INTO gr_generic_ml_name_tl

Line 240: IF FND_API.To_Boolean(l_key_exists) THEN

236: 'F',
237: l_rowid,
238: l_key_exists);
239:
240: IF FND_API.To_Boolean(l_key_exists) THEN
241: x_rowid := l_rowid;
242: ELSE
243: RAISE Row_Missing_Error;
244: END IF;

Line 248: IF FND_API.To_Boolean(p_commit) THEN

244: END IF;
245:
246: /* Check the commit flag and if set, then commit the work. */
247:
248: IF FND_API.To_Boolean(p_commit) THEN
249: COMMIT WORK;
250: END IF;
251:
252: EXCEPTION

Line 263: IF FND_API.To_Boolean(p_called_by_form) THEN

259: 'GR_FOREIGN_KEY_ERROR');
260: FND_MESSAGE.SET_TOKEN('TEXT',
261: l_msg_data,
262: FALSE);
263: IF FND_API.To_Boolean(p_called_by_form) THEN
264: APP_EXCEPTION.Raise_Exception;
265: ELSE
266: x_msg_data := FND_MESSAGE.Get;
267: END IF;

Line 279: IF FND_API.To_Boolean(p_called_by_form) THEN

275: 'GR_RECORD_EXISTS');
276: FND_MESSAGE.SET_TOKEN('CODE',
277: l_msg_token,
278: FALSE);
279: IF FND_API.To_Boolean(p_called_by_form) THEN
280: APP_EXCEPTION.Raise_Exception;
281: ELSE
282: x_msg_data := FND_MESSAGE.Get;
283: END IF;

Line 295: IF FND_API.To_Boolean(p_called_by_form) THEN

291: 'GR_NO_RECORD_INSERTED');
292: FND_MESSAGE.SET_TOKEN('CODE',
293: l_msg_token,
294: FALSE);
295: IF FND_API.To_Boolean(p_called_by_form) THEN
296: APP_EXCEPTION.Raise_Exception;
297: ELSE
298: x_msg_data := FND_MESSAGE.Get;
299: END IF;

Line 312: IF FND_API.To_Boolean(p_called_by_form) THEN

308: 'GR_UNEXPECTED_ERROR');
309: FND_MESSAGE.SET_TOKEN('TEXT',
310: l_msg_token,
311: FALSE);
312: IF FND_API.To_Boolean(p_called_by_form) THEN
313: APP_EXCEPTION.Raise_Exception;
314: ELSE
315: x_msg_data := FND_MESSAGE.Get;
316: END IF;

Line 494: IF FND_API.To_Boolean(p_commit) THEN

490: END IF;
491:
492: /* Check the commit flag and if set, then commit the work. */
493:
494: IF FND_API.To_Boolean(p_commit) THEN
495: COMMIT WORK;
496: END IF;
497:
498: EXCEPTION

Line 509: IF FND_API.To_Boolean(p_called_by_form) THEN

505: 'GR_FOREIGN_KEY_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 524: IF FND_API.To_Boolean(p_called_by_form) THEN

520: 'GR_NO_RECORD_INSERTED');
521: FND_MESSAGE.SET_TOKEN('CODE',
522: l_msg_token,
523: FALSE);
524: IF FND_API.To_Boolean(p_called_by_form) THEN
525: APP_EXCEPTION.Raise_Exception;
526: ELSE
527: x_msg_data := FND_MESSAGE.Get;
528: END IF;

Line 540: IF FND_API.To_Boolean(p_called_by_form) THEN

536: 'GR_UNEXPECTED_ERROR');
537: FND_MESSAGE.SET_TOKEN('TEXT',
538: l_msg_token,
539: FALSE);
540: IF FND_API.To_Boolean(p_called_by_form) THEN
541: APP_EXCEPTION.Raise_Exception;
542: ELSE
543: x_msg_data := FND_MESSAGE.Get;
544: END IF;

Line 878: IF FND_API.To_Boolean(p_commit) THEN

874: END LOOP;
875: END IF;
876: CLOSE c_get_installed_languages;
877:
878: IF FND_API.To_Boolean(p_commit) THEN
879: COMMIT WORK;
880: END IF;
881:
882: EXCEPTION

Line 893: IF FND_API.To_Boolean(p_called_by_form) THEN

889: 'GR_RECORD_NOT_FOUND');
890: FND_MESSAGE.SET_TOKEN('CODE',
891: l_msg_token,
892: FALSE);
893: IF FND_API.To_Boolean(p_called_by_form) THEN
894: APP_EXCEPTION.Raise_Exception;
895: ELSE
896: x_msg_data := FND_MESSAGE.Get;
897: END IF;

Line 908: IF FND_API.To_Boolean(p_called_by_form) THEN

904: 'GR_UNEXPECTED_ERROR');
905: FND_MESSAGE.SET_TOKEN('TEXT',
906: l_msg_token,
907: FALSE);
908: IF FND_API.To_Boolean(p_called_by_form) THEN
909: APP_EXCEPTION.Raise_Exception;
910: ELSE
911: x_msg_data := FND_MESSAGE.Get;
912: END IF;

Line 1016: IF FND_API.To_Boolean(p_commit) THEN

1012: IF LockGenericRcd.last_update_date <> p_last_update_date THEN
1013: RAISE RECORD_CHANGED_ERROR;
1014: END IF;
1015:
1016: IF FND_API.To_Boolean(p_commit) THEN
1017: COMMIT WORK;
1018: END IF;
1019:
1020: EXCEPTION

Line 1030: IF FND_API.To_Boolean(p_called_by_form) THEN

1026: 'GR_RECORD_NOT_FOUND');
1027: FND_MESSAGE.SET_TOKEN('CODE',
1028: l_msg_token,
1029: FALSE);
1030: IF FND_API.To_Boolean(p_called_by_form) THEN
1031: APP_EXCEPTION.Raise_Exception;
1032: ELSE
1033: x_msg_data := FND_MESSAGE.Get;
1034: END IF;

Line 1041: IF FND_API.To_Boolean(p_called_by_form) THEN

1037: ROLLBACK TO SAVEPOINT Lock_Row;
1038: X_return_status := 'E';
1039: FND_MESSAGE.SET_NAME('FND',
1040: 'FORM_RECORD_CHANGED');
1041: IF FND_API.To_Boolean(p_called_by_form) THEN
1042: APP_EXCEPTION.Raise_Exception;
1043: ELSE
1044: x_msg_data := FND_MESSAGE.Get;
1045: END IF;

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

1046: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
1047: ROLLBACK TO SAVEPOINT Lock_Row;
1048: x_return_status := 'L';
1049: x_oracle_error := APP_EXCEPTION.Get_Code;
1050: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN
1051: FND_MESSAGE.SET_NAME('GR',
1052: 'GR_ROW_IS_LOCKED');
1053: x_msg_data := FND_MESSAGE.Get;
1054: END IF;

Line 1067: IF FND_API.To_Boolean(p_called_by_form) THEN

1063: 'GR_UNEXPECTED_ERROR');
1064: FND_MESSAGE.SET_TOKEN('TEXT',
1065: l_msg_token,
1066: FALSE);
1067: IF FND_API.To_Boolean(p_called_by_form) THEN
1068: APP_EXCEPTION.Raise_Exception;
1069: ELSE
1070: x_msg_data := FND_MESSAGE.Get;
1071: END IF;

Line 1210: IF FND_API.TO_Boolean(p_commit) THEN

1206: WHERE rowid = p_rowid;
1207:
1208: /* Check the commit flag and if set, then commit the work. */
1209:
1210: IF FND_API.TO_Boolean(p_commit) THEN
1211: COMMIT WORK;
1212: END IF;
1213:
1214: EXCEPTION

Line 1220: IF FND_API.To_Boolean(p_called_by_form) THEN

1216: WHEN Check_Integrity_Error THEN
1217: ROLLBACK TO SAVEPOINT Delete_Row;
1218: x_return_status := l_return_status;
1219: x_oracle_error := l_oracle_error;
1220: IF FND_API.To_Boolean(p_called_by_form) THEN
1221: APP_EXCEPTION.Raise_Exception;
1222: ELSE
1223: x_msg_data := FND_MESSAGE.Get;
1224: END IF;

Line 1235: IF FND_API.To_Boolean(p_called_by_form) THEN

1231: 'GR_RECORD_NOT_FOUND');
1232: FND_MESSAGE.SET_TOKEN('CODE',
1233: l_msg_token,
1234: FALSE);
1235: IF FND_API.To_Boolean(p_called_by_form) THEN
1236: APP_EXCEPTION.Raise_Exception;
1237: ELSE
1238: x_msg_data := FND_MESSAGE.Get;
1239: END IF;

Line 1252: IF FND_API.To_Boolean(p_called_by_form) THEN

1248: 'GR_UNEXPECTED_ERROR');
1249: FND_MESSAGE.SET_TOKEN('TEXT',
1250: l_msg_token,
1251: FALSE);
1252: IF FND_API.To_Boolean(p_called_by_form) THEN
1253: APP_EXCEPTION.Raise_Exception;
1254: ELSE
1255: x_msg_data := FND_MESSAGE.Get;
1256: END IF;

Line 1337: IF FND_API.To_Boolean(p_commit) THEN

1333: AND item_no = p_item_no;
1334: END IF;
1335: END IF;
1336:
1337: IF FND_API.To_Boolean(p_commit) THEN
1338: COMMIT WORK;
1339: END IF;
1340:
1341: EXCEPTION

Line 1351: IF FND_API.To_Boolean(p_called_by_form) THEN

1347: 'GR_NULL_VALUE');
1348: FND_MESSAGE.SET_TOKEN('CODE',
1349: l_msg_token,
1350: FALSE);
1351: IF FND_API.To_Boolean(p_called_by_form) THEN
1352: APP_EXCEPTION.Raise_Exception;
1353: ELSE
1354: x_msg_data := FND_MESSAGE.Get;
1355: END IF;

Line 1367: IF FND_API.To_Boolean(p_called_by_form) THEN

1363: 'GR_UNEXPECTED_ERROR');
1364: FND_MESSAGE.SET_TOKEN('TEXT',
1365: l_msg_token,
1366: FALSE);
1367: IF FND_API.To_Boolean(p_called_by_form) THEN
1368: APP_EXCEPTION.Raise_Exception;
1369: ELSE
1370: x_msg_data := FND_MESSAGE.Get;
1371: END IF;

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

1467: (p_item_code,
1468: 'F',
1469: l_rowid,
1470: l_key_exists);
1471: IF NOT FND_API.To_Boolean(l_key_exists) THEN
1472: x_return_status := 'E';
1473: FND_MESSAGE.SET_NAME('GR',
1474: 'GR_RECORD_NOT_FOUND');
1475: FND_MESSAGE.SET_TOKEN('CODE',

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

1498: (p_label_code,
1499: 'F',
1500: l_rowid,
1501: l_key_exists);
1502: IF NOT FND_API.To_Boolean(l_key_exists) THEN
1503: x_return_status := 'E';
1504: FND_MESSAGE.SET_NAME('GR',
1505: 'GR_RECORD_NOT_FOUND');
1506: FND_MESSAGE.SET_TOKEN('CODE',

Line 1660: IF FND_API.To_Boolean(p_called_by_form) THEN

1656: 'GR_INSTALLED_LANG');
1657: FND_MESSAGE.SET_TOKEN('CODE',
1658: p_language,
1659: FALSE);
1660: IF FND_API.To_Boolean(p_called_by_form) THEN
1661: APP_EXCEPTION.Raise_Exception;
1662: ELSE
1663: x_msg_data := FND_MESSAGE.Get;
1664: END IF;

Line 1676: IF FND_API.To_Boolean(p_called_by_form) THEN

1672: 'GR_UNEXPECTED_ERROR');
1673: FND_MESSAGE.SET_TOKEN('TEXT',
1674: l_msg_data,
1675: FALSE);
1676: IF FND_API.To_Boolean(p_called_by_form) THEN
1677: APP_EXCEPTION.Raise_Exception;
1678: ELSE
1679: x_msg_data := FND_MESSAGE.Get;
1680: END IF;

Line 1739: IF FND_API.To_Boolean(p_called_by_form) THEN

1735: 'GR_UNEXPECTED_ERROR');
1736: FND_MESSAGE.SET_TOKEN('TEXT',
1737: l_msg_data,
1738: FALSE);
1739: IF FND_API.To_Boolean(p_called_by_form) THEN
1740: APP_EXCEPTION.Raise_Exception;
1741: END IF;
1742:
1743: END Check_Primary_Key;