DBA Data[Home] [Help]

APPS.GR_MULTILINGUAL_NAME_TL_PKG dependencies on FND_API

Line 137: IF FND_API.To_Boolean(l_key_exists) THEN

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

Line 236: IF FND_API.To_Boolean(l_key_exists) THEN

232: 'F',
233: l_rowid,
234: l_key_exists);
235:
236: IF FND_API.To_Boolean(l_key_exists) THEN
237: x_rowid := l_rowid;
238: ELSE
239: RAISE Row_Missing_Error;
240: END IF;

Line 244: IF FND_API.To_Boolean(p_commit) THEN

240: END IF;
241:
242: /* Check the commit flag and if set, then commit the work. */
243:
244: IF FND_API.To_Boolean(p_commit) THEN
245: COMMIT WORK;
246: END IF;
247:
248: EXCEPTION

Line 259: IF FND_API.To_Boolean(p_called_by_form) THEN

255: 'GR_FOREIGN_KEY_ERROR');
256: FND_MESSAGE.SET_TOKEN('TEXT',
257: l_msg_data,
258: FALSE);
259: IF FND_API.To_Boolean(p_called_by_form) THEN
260: APP_EXCEPTION.Raise_Exception;
261: ELSE
262: x_msg_data := FND_MESSAGE.Get;
263: END IF;

Line 275: IF FND_API.To_Boolean(p_called_by_form) THEN

271: 'GR_RECORD_EXISTS');
272: FND_MESSAGE.SET_TOKEN('CODE',
273: l_msg_token,
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 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 308: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 487: IF FND_API.To_Boolean(p_commit) THEN

483: END IF;
484:
485: /* Check the commit flag and if set, then commit the work. */
486:
487: IF FND_API.To_Boolean(p_commit) THEN
488: COMMIT WORK;
489: END IF;
490:
491: EXCEPTION

Line 502: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 517: IF FND_API.To_Boolean(p_called_by_form) THEN

513: 'GR_NO_RECORD_INSERTED');
514: FND_MESSAGE.SET_TOKEN('CODE',
515: l_msg_token,
516: FALSE);
517: IF FND_API.To_Boolean(p_called_by_form) THEN
518: APP_EXCEPTION.Raise_Exception;
519: ELSE
520: x_msg_data := FND_MESSAGE.Get;
521: END IF;

Line 533: IF FND_API.To_Boolean(p_called_by_form) THEN

529: 'GR_UNEXPECTED_ERROR');
530: FND_MESSAGE.SET_TOKEN('TEXT',
531: l_msg_token,
532: FALSE);
533: IF FND_API.To_Boolean(p_called_by_form) THEN
534: APP_EXCEPTION.Raise_Exception;
535: ELSE
536: x_msg_data := FND_MESSAGE.Get;
537: END IF;

Line 870: IF FND_API.To_Boolean(p_commit) THEN

866: END LOOP;
867: END IF;
868: CLOSE c_get_installed_languages;
869:
870: IF FND_API.To_Boolean(p_commit) THEN
871: COMMIT WORK;
872: END IF;
873:
874: EXCEPTION

Line 885: IF FND_API.To_Boolean(p_called_by_form) THEN

881: 'GR_RECORD_NOT_FOUND');
882: FND_MESSAGE.SET_TOKEN('CODE',
883: l_msg_token,
884: FALSE);
885: IF FND_API.To_Boolean(p_called_by_form) THEN
886: APP_EXCEPTION.Raise_Exception;
887: ELSE
888: x_msg_data := FND_MESSAGE.Get;
889: END IF;

Line 900: IF FND_API.To_Boolean(p_called_by_form) THEN

896: 'GR_UNEXPECTED_ERROR');
897: FND_MESSAGE.SET_TOKEN('TEXT',
898: l_msg_token,
899: FALSE);
900: IF FND_API.To_Boolean(p_called_by_form) THEN
901: APP_EXCEPTION.Raise_Exception;
902: ELSE
903: x_msg_data := FND_MESSAGE.Get;
904: END IF;

Line 1004: IF FND_API.To_Boolean(p_commit) THEN

1000: RAISE No_Data_Found_Error;
1001: END IF;
1002: CLOSE c_lock_mlname_tl;
1003:
1004: IF FND_API.To_Boolean(p_commit) THEN
1005: COMMIT WORK;
1006: END IF;
1007:
1008: EXCEPTION

Line 1018: IF FND_API.To_Boolean(p_called_by_form) THEN

1014: 'GR_RECORD_NOT_FOUND');
1015: FND_MESSAGE.SET_TOKEN('CODE',
1016: l_msg_token,
1017: FALSE);
1018: IF FND_API.To_Boolean(p_called_by_form) THEN
1019: APP_EXCEPTION.Raise_Exception;
1020: ELSE
1021: x_msg_data := FND_MESSAGE.Get;
1022: END IF;

Line 1030: IF FND_API.To_Boolean(p_called_by_form) THEN

1026: x_return_status := 'E';
1027: x_oracle_error := APP_EXCEPTION.Get_Code;
1028: FND_MESSAGE.SET_NAME('GR',
1029: 'GR_ROW_IS_LOCKED');
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 1046: IF FND_API.To_Boolean(p_called_by_form) THEN

1042: 'GR_UNEXPECTED_ERROR');
1043: FND_MESSAGE.SET_TOKEN('TEXT',
1044: l_msg_token,
1045: FALSE);
1046: IF FND_API.To_Boolean(p_called_by_form) THEN
1047: APP_EXCEPTION.Raise_Exception;
1048: ELSE
1049: x_msg_data := FND_MESSAGE.Get;
1050: END IF;

Line 1187: IF FND_API.TO_Boolean(p_commit) THEN

1183: WHERE rowid = p_rowid;
1184:
1185: /* Check the commit flag and if set, then commit the work. */
1186:
1187: IF FND_API.TO_Boolean(p_commit) THEN
1188: COMMIT WORK;
1189: END IF;
1190:
1191: EXCEPTION

Line 1197: IF FND_API.To_Boolean(p_called_by_form) THEN

1193: WHEN Check_Integrity_Error THEN
1194: ROLLBACK TO SAVEPOINT Delete_Row;
1195: x_return_status := l_return_status;
1196: x_oracle_error := l_oracle_error;
1197: IF FND_API.To_Boolean(p_called_by_form) THEN
1198: APP_EXCEPTION.Raise_Exception;
1199: ELSE
1200: x_msg_data := FND_MESSAGE.Get;
1201: END IF;

Line 1212: IF FND_API.To_Boolean(p_called_by_form) THEN

1208: 'GR_RECORD_NOT_FOUND');
1209: FND_MESSAGE.SET_TOKEN('CODE',
1210: l_msg_token,
1211: FALSE);
1212: IF FND_API.To_Boolean(p_called_by_form) THEN
1213: APP_EXCEPTION.Raise_Exception;
1214: ELSE
1215: x_msg_data := FND_MESSAGE.Get;
1216: END IF;

Line 1229: IF FND_API.To_Boolean(p_called_by_form) THEN

1225: 'GR_UNEXPECTED_ERROR');
1226: FND_MESSAGE.SET_TOKEN('TEXT',
1227: l_msg_token,
1228: FALSE);
1229: IF FND_API.To_Boolean(p_called_by_form) THEN
1230: APP_EXCEPTION.Raise_Exception;
1231: ELSE
1232: x_msg_data := FND_MESSAGE.Get;
1233: END IF;

Line 1314: IF FND_API.To_Boolean(p_commit) THEN

1310: AND label_code = p_label_code;
1311: END IF;
1312: END IF;
1313:
1314: IF FND_API.To_Boolean(p_commit) THEN
1315: COMMIT WORK;
1316: END IF;
1317:
1318: EXCEPTION

Line 1328: IF FND_API.To_Boolean(p_called_by_form) THEN

1324: 'GR_NULL_VALUE');
1325: FND_MESSAGE.SET_TOKEN('CODE',
1326: l_msg_token,
1327: FALSE);
1328: IF FND_API.To_Boolean(p_called_by_form) THEN
1329: APP_EXCEPTION.Raise_Exception;
1330: ELSE
1331: x_msg_data := FND_MESSAGE.Get;
1332: END IF;

Line 1344: IF FND_API.To_Boolean(p_called_by_form) THEN

1340: 'GR_UNEXPECTED_ERROR');
1341: FND_MESSAGE.SET_TOKEN('TEXT',
1342: l_msg_token,
1343: FALSE);
1344: IF FND_API.To_Boolean(p_called_by_form) THEN
1345: APP_EXCEPTION.Raise_Exception;
1346: ELSE
1347: x_msg_data := FND_MESSAGE.Get;
1348: END IF;

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

1435: (p_item_code,
1436: 'F',
1437: l_rowid,
1438: l_key_exists);
1439: IF NOT FND_API.To_Boolean(l_key_exists) THEN
1440: x_return_status := 'E';
1441: FND_MESSAGE.SET_NAME('GR',
1442: 'GR_RECORD_NOT_FOUND');
1443: FND_MESSAGE.SET_TOKEN('CODE',

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

1452: (p_label_code,
1453: 'F',
1454: l_rowid,
1455: l_key_exists);
1456: IF NOT FND_API.To_Boolean(l_key_exists) THEN
1457: x_return_status := 'E';
1458: FND_MESSAGE.SET_NAME('GR',
1459: 'GR_RECORD_NOT_FOUND');
1460: FND_MESSAGE.SET_TOKEN('CODE',

Line 1613: IF FND_API.To_Boolean(p_called_by_form) THEN

1609: 'GR_INSTALLED_LANG');
1610: FND_MESSAGE.SET_TOKEN('CODE',
1611: p_language,
1612: FALSE);
1613: IF FND_API.To_Boolean(p_called_by_form) THEN
1614: APP_EXCEPTION.Raise_Exception;
1615: ELSE
1616: x_msg_data := FND_MESSAGE.Get;
1617: END IF;

Line 1629: IF FND_API.To_Boolean(p_called_by_form) THEN

1625: 'GR_UNEXPECTED_ERROR');
1626: FND_MESSAGE.SET_TOKEN('TEXT',
1627: l_msg_data,
1628: FALSE);
1629: IF FND_API.To_Boolean(p_called_by_form) THEN
1630: APP_EXCEPTION.Raise_Exception;
1631: ELSE
1632: x_msg_data := FND_MESSAGE.Get;
1633: END IF;

Line 1692: IF FND_API.To_Boolean(p_called_by_form) THEN

1688: 'GR_UNEXPECTED_ERROR');
1689: FND_MESSAGE.SET_TOKEN('TEXT',
1690: l_msg_data,
1691: FALSE);
1692: IF FND_API.To_Boolean(p_called_by_form) THEN
1693: APP_EXCEPTION.Raise_Exception;
1694: END IF;
1695:
1696: END Check_Primary_Key;