DBA Data[Home] [Help]

APPS.GR_ITEM_GENERAL_PKG dependencies on FND_API

Line 153: IF FND_API.To_Boolean(l_key_exists) THEN

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

Line 268: IF FND_API.To_Boolean(l_key_exists) THEN

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

Line 276: IF FND_API.To_Boolean(p_commit) THEN

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

Line 291: IF FND_API.To_Boolean(p_called_by_form) THEN

287: 'GR_FOREIGN_KEY_ERROR');
288: FND_MESSAGE.SET_TOKEN('TEXT',
289: l_msg_data,
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 306: IF FND_API.To_Boolean(p_called_by_form) THEN

302: 'GR_RECORD_EXISTS');
303: FND_MESSAGE.SET_TOKEN('CODE',
304: p_item_code,
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 321: IF FND_API.To_Boolean(p_called_by_form) THEN

317: 'GR_NO_RECORD_INSERTED');
318: FND_MESSAGE.SET_TOKEN('CODE',
319: p_item_code,
320: FALSE);
321: IF FND_API.To_Boolean(p_called_by_form) THEN
322: APP_EXCEPTION.Raise_Exception;
323: ELSE
324: x_msg_data := FND_MESSAGE.Get;
325: END IF;

Line 337: IF FND_API.To_Boolean(p_called_by_form) THEN

333: 'GR_UNEXPECTED_ERROR');
334: FND_MESSAGE.SET_TOKEN('TEXT',
335: l_msg_data,
336: FALSE);
337: IF FND_API.To_Boolean(p_called_by_form) THEN
338: APP_EXCEPTION.Raise_Exception;
339: ELSE
340: x_msg_data := FND_MESSAGE.Get;
341: END IF;

Line 540: IF FND_API.To_Boolean(p_commit) THEN

536: END IF;
537:
538: /* Check the commit flag and if set, then commit the work. */
539:
540: IF FND_API.To_Boolean(p_commit) THEN
541: COMMIT WORK;
542: END IF;
543:
544: EXCEPTION

Line 555: IF FND_API.To_Boolean(p_called_by_form) THEN

551: 'GR_FOREIGN_KEY_ERROR');
552: FND_MESSAGE.SET_TOKEN('TEXT',
553: l_msg_data,
554: FALSE);
555: IF FND_API.To_Boolean(p_called_by_form) THEN
556: APP_EXCEPTION.Raise_Exception;
557: ELSE
558: x_msg_data := FND_MESSAGE.Get;
559: END IF;

Line 570: IF FND_API.To_Boolean(p_called_by_form) THEN

566: 'GR_NO_RECORD_INSERTED');
567: FND_MESSAGE.SET_TOKEN('CODE',
568: p_item_code,
569: FALSE);
570: IF FND_API.To_Boolean(p_called_by_form) THEN
571: APP_EXCEPTION.Raise_Exception;
572: ELSE
573: x_msg_data := FND_MESSAGE.Get;
574: END IF;

Line 586: IF FND_API.To_Boolean(p_called_by_form) THEN

582: 'GR_UNEXPECTED_ERROR');
583: FND_MESSAGE.SET_TOKEN('TEXT',
584: l_msg_data,
585: FALSE);
586: IF FND_API.To_Boolean(p_called_by_form) THEN
587: APP_EXCEPTION.Raise_Exception;
588: ELSE
589: x_msg_data := FND_MESSAGE.Get;
590: END IF;

Line 696: IF FND_API.To_Boolean(p_commit) THEN

692: RAISE No_Data_Found_Error;
693: END IF;
694: CLOSE c_lock_item;
695:
696: IF FND_API.To_Boolean(p_commit) THEN
697: COMMIT WORK;
698: END IF;
699:
700: EXCEPTION

Line 710: IF FND_API.To_Boolean(p_called_by_form) THEN

706: 'GR_RECORD_NOT_FOUND');
707: FND_MESSAGE.SET_TOKEN('CODE',
708: p_item_code,
709: FALSE);
710: IF FND_API.To_Boolean(p_called_by_form) THEN
711: APP_EXCEPTION.Raise_Exception;
712: ELSE
713: x_msg_data := FND_MESSAGE.Get;
714: END IF;

Line 722: IF FND_API.To_Boolean(p_called_by_form) THEN

718: x_return_status := 'E';
719: x_oracle_error := APP_EXCEPTION.Get_Code;
720: FND_MESSAGE.SET_NAME('GR',
721: 'GR_ROW_IS_LOCKED');
722: IF FND_API.To_Boolean(p_called_by_form) THEN
723: APP_EXCEPTION.Raise_Exception;
724: ELSE
725: x_msg_data := FND_MESSAGE.Get;
726: END IF;

Line 738: IF FND_API.To_Boolean(p_called_by_form) THEN

734: 'GR_UNEXPECTED_ERROR');
735: FND_MESSAGE.SET_TOKEN('TEXT',
736: l_msg_data,
737: FALSE);
738: IF FND_API.To_Boolean(p_called_by_form) THEN
739: APP_EXCEPTION.Raise_Exception;
740: ELSE
741: x_msg_data := FND_MESSAGE.Get;
742: END IF;

Line 893: IF FND_API.TO_Boolean(p_commit) THEN

889: WHERE rowid = p_rowid;
890:
891: /* Check the commit flag and if set, then commit the work. */
892:
893: IF FND_API.TO_Boolean(p_commit) THEN
894: COMMIT WORK;
895: END IF;
896:
897: EXCEPTION

Line 903: IF FND_API.To_Boolean(p_called_by_form) THEN

899: WHEN Check_Integrity_Error THEN
900: ROLLBACK TO SAVEPOINT Delete_Row;
901: x_return_status := l_return_status;
902: x_oracle_error := l_oracle_error;
903: IF FND_API.To_Boolean(p_called_by_form) THEN
904: APP_EXCEPTION.Raise_Exception;
905: ELSE
906: x_msg_data := FND_MESSAGE.Get;
907: END IF;

Line 918: IF FND_API.To_Boolean(p_called_by_form) THEN

914: 'GR_RECORD_NOT_FOUND');
915: FND_MESSAGE.SET_TOKEN('CODE',
916: p_item_code,
917: FALSE);
918: IF FND_API.To_Boolean(p_called_by_form) THEN
919: APP_EXCEPTION.Raise_Exception;
920: ELSE
921: x_msg_data := FND_MESSAGE.Get;
922: END IF;

Line 935: IF FND_API.To_Boolean(p_called_by_form) THEN

931: 'GR_UNEXPECTED_ERROR');
932: FND_MESSAGE.SET_TOKEN('TEXT',
933: l_msg_data,
934: FALSE);
935: IF FND_API.To_Boolean(p_called_by_form) THEN
936: APP_EXCEPTION.Raise_Exception;
937: ELSE
938: x_msg_data := FND_MESSAGE.Get;
939: END IF;

Line 1578: IF FND_API.To_Boolean(p_called_by_form) THEN

1574: FALSE);
1575: FND_MESSAGE.SET_TOKEN('TABLES',
1576: SUBSTR(l_msg_data,1,LENGTH(l_msg_data)-1),
1577: FALSE);
1578: IF FND_API.To_Boolean(p_called_by_form) THEN
1579: APP_EXCEPTION.Raise_Exception;
1580: ELSE
1581: x_msg_data := FND_MESSAGE.Get;
1582: END IF;

Line 1593: IF FND_API.To_Boolean(p_called_by_form) THEN

1589: 'GR_UNEXPECTED_ERROR');
1590: FND_MESSAGE.SET_TOKEN('TEXT',
1591: l_msg_data,
1592: FALSE);
1593: IF FND_API.To_Boolean(p_called_by_form) THEN
1594: APP_EXCEPTION.Raise_Exception;
1595: ELSE
1596: x_msg_data := FND_MESSAGE.Get;
1597: END IF;

Line 1650: IF FND_API.To_Boolean(p_called_by_form) THEN

1646: 'GR_UNEXPECTED_ERROR');
1647: FND_MESSAGE.SET_TOKEN('TEXT',
1648: l_msg_data,
1649: FALSE);
1650: IF FND_API.To_Boolean(p_called_by_form) THEN
1651: APP_EXCEPTION.Raise_Exception;
1652: END IF;
1653:
1654: END Check_Primary_Key;