APPS.GR_DOCUMENT_CODES_PKG dependencies on FND_API

Line 212: IF FND_API.To_Boolean(l_key_exists) THEN

208: 'F',
209: l_rowid,
210: l_key_exists);
211:
212: IF FND_API.To_Boolean(l_key_exists) THEN
213: RAISE Label_Exists_Error;
214: END IF;
215:
216: INSERT INTO gr_document_codes

Line 387: IF FND_API.To_Boolean(l_key_exists) THEN

383: 'F',
384: l_rowid,
385: l_key_exists);
386:
387: IF FND_API.To_Boolean(l_key_exists) THEN
388: x_rowid := l_rowid;
389: ELSE
390: RAISE Row_Missing_Error;
391: END IF;

Line 395: IF FND_API.To_Boolean(p_commit) THEN

391: END IF;
392:
393: /* Check the commit flag and if set, then commit the work. */
394:
395: IF FND_API.To_Boolean(p_commit) THEN
396: COMMIT WORK;
397: END IF;
398:
399: EXCEPTION

Line 410: IF FND_API.To_Boolean(p_called_by_form) THEN

406: 'GR_FOREIGN_KEY_ERROR');
407: FND_MESSAGE.SET_TOKEN('TEXT',
408: l_msg_data,
409: FALSE);
410: IF FND_API.To_Boolean(p_called_by_form) THEN
411: APP_EXCEPTION.Raise_Exception;
412: ELSE
413: x_msg_data := FND_MESSAGE.Get;
414: END IF;

Line 425: IF FND_API.To_Boolean(p_called_by_form) THEN

421: 'GR_RECORD_EXISTS');
422: FND_MESSAGE.SET_TOKEN('CODE',
423: p_document_code,
424: FALSE);
425: IF FND_API.To_Boolean(p_called_by_form) THEN
426: APP_EXCEPTION.Raise_Exception;
427: ELSE
428: x_msg_data := FND_MESSAGE.Get;
429: END IF;

Line 440: IF FND_API.To_Boolean(p_called_by_form) THEN

436: 'GR_NO_RECORD_INSERTED');
437: FND_MESSAGE.SET_TOKEN('CODE',
438: p_document_code,
439: FALSE);
440: IF FND_API.To_Boolean(p_called_by_form) THEN
441: APP_EXCEPTION.Raise_Exception;
442: ELSE
443: x_msg_data := FND_MESSAGE.Get;
444: END IF;

Line 456: IF FND_API.To_Boolean(p_called_by_form) THEN

452: 'GR_UNEXPECTED_ERROR');
453: FND_MESSAGE.SET_TOKEN('TEXT',
454: l_msg_data,
455: FALSE);
456: IF FND_API.To_Boolean(p_called_by_form) THEN
457: APP_EXCEPTION.Raise_Exception;
458: ELSE
459: x_msg_data := FND_MESSAGE.Get;
460: END IF;

Line 750: IF FND_API.To_Boolean(p_commit) THEN

746: END IF;
747:
748: /* Check the commit flag and if set, then commit the work. */
749:
750: IF FND_API.To_Boolean(p_commit) THEN
751: COMMIT WORK;
752: END IF;
753:
754: EXCEPTION

Line 765: IF FND_API.To_Boolean(p_called_by_form) THEN

761: 'GR_FOREIGN_KEY_ERROR');
762: FND_MESSAGE.SET_TOKEN('TEXT',
763: l_msg_data,
764: FALSE);
765: IF FND_API.To_Boolean(p_called_by_form) THEN
766: APP_EXCEPTION.Raise_Exception;
767: ELSE
768: x_msg_data := FND_MESSAGE.Get;
769: END IF;

Line 780: IF FND_API.To_Boolean(p_called_by_form) THEN

776: 'GR_NO_RECORD_INSERTED');
777: FND_MESSAGE.SET_TOKEN('CODE',
778: p_document_code,
779: FALSE);
780: IF FND_API.To_Boolean(p_called_by_form) THEN
781: APP_EXCEPTION.Raise_Exception;
782: ELSE
783: x_msg_data := FND_MESSAGE.Get;
784: END IF;

Line 796: IF FND_API.To_Boolean(p_called_by_form) THEN

792: 'GR_UNEXPECTED_ERROR');
793: FND_MESSAGE.SET_TOKEN('TEXT',
794: l_msg_data,
795: FALSE);
796: IF FND_API.To_Boolean(p_called_by_form) THEN
797: APP_EXCEPTION.Raise_Exception;
798: ELSE
799: x_msg_data := FND_MESSAGE.Get;
800: END IF;

Line 937: IF FND_API.To_Boolean(p_commit) THEN

933: RAISE No_Data_Found_Error;
934: END IF;
935: CLOSE c_lock_document;
936:
937: IF FND_API.To_Boolean(p_commit) THEN
938: COMMIT WORK;
939: END IF;
940:
941: EXCEPTION

Line 951: IF FND_API.To_Boolean(p_called_by_form) THEN

947: 'GR_RECORD_NOT_FOUND');
948: FND_MESSAGE.SET_TOKEN('CODE',
949: p_document_code,
950: FALSE);
951: IF FND_API.To_Boolean(p_called_by_form) THEN
952: APP_EXCEPTION.Raise_Exception;
953: ELSE
954: x_msg_data := FND_MESSAGE.Get;
955: END IF;

Line 963: IF FND_API.To_Boolean(p_called_by_form) THEN

959: x_return_status := 'E';
960: x_oracle_error := APP_EXCEPTION.Get_Code;
961: FND_MESSAGE.SET_NAME('GR',
962: 'GR_ROW_IS_LOCKED');
963: IF FND_API.To_Boolean(p_called_by_form) THEN
964: APP_EXCEPTION.Raise_Exception;
965: ELSE
966: x_msg_data := FND_MESSAGE.Get;
967: END IF;

Line 979: IF FND_API.To_Boolean(p_called_by_form) THEN

975: 'GR_UNEXPECTED_ERROR');
976: FND_MESSAGE.SET_TOKEN('TEXT',
977: l_msg_data,
978: FALSE);
979: IF FND_API.To_Boolean(p_called_by_form) THEN
980: APP_EXCEPTION.Raise_Exception;
981: ELSE
982: x_msg_data := FND_MESSAGE.Get;
983: END IF;

Line 1194: IF FND_API.TO_Boolean(p_commit) THEN

1190: WHERE rowid = p_rowid;
1191:
1192: /* Check the commit flag and if set, then commit the work. */
1193:
1194: IF FND_API.TO_Boolean(p_commit) THEN
1195: COMMIT WORK;
1196: END IF;
1197:
1198: EXCEPTION

Line 1204: IF FND_API.To_Boolean(p_called_by_form) THEN

1200: WHEN Check_Integrity_Error THEN
1201: ROLLBACK TO SAVEPOINT Delete_Row;
1202: x_return_status := l_return_status;
1203: x_oracle_error := l_oracle_error;
1204: IF FND_API.To_Boolean(p_called_by_form) THEN
1205: APP_EXCEPTION.Raise_Exception;
1206: ELSE
1207: x_msg_data := FND_MESSAGE.Get;
1208: END IF;

Line 1219: IF FND_API.To_Boolean(p_called_by_form) THEN

1215: 'GR_RECORD_NOT_FOUND');
1216: FND_MESSAGE.SET_TOKEN('CODE',
1217: p_document_code,
1218: FALSE);
1219: IF FND_API.To_Boolean(p_called_by_form) THEN
1220: APP_EXCEPTION.Raise_Exception;
1221: ELSE
1222: x_msg_data := FND_MESSAGE.Get;
1223: END IF;

Line 1235: IF FND_API.To_Boolean(p_called_by_form) THEN

1231: 'GR_UNEXPECTED_ERROR');
1232: FND_MESSAGE.SET_TOKEN('TEXT',
1233: l_msg_data,
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 1703: IF FND_API.To_Boolean(p_called_by_form) THEN

1699: 'GR_UNEXPECTED_ERROR');
1700: FND_MESSAGE.SET_TOKEN('TEXT',
1701: l_msg_data,
1702: FALSE);
1703: IF FND_API.To_Boolean(p_called_by_form) THEN
1704: APP_EXCEPTION.Raise_Exception;
1705: ELSE
1706: x_msg_data := FND_MESSAGE.Get;
1707: END IF;

Line 1759: IF FND_API.To_Boolean(p_called_by_form) THEN

1755: 'GR_UNEXPECTED_ERROR');
1756: FND_MESSAGE.SET_TOKEN('TEXT',
1757: l_msg_data,
1758: FALSE);
1759: IF FND_API.To_Boolean(p_called_by_form) THEN
1760: APP_EXCEPTION.Raise_Exception;
1761: END IF;
1762:
1763: END Check_Primary_Key;