DBA Data[Home] [Help]

APPS.GR_DOCUMENT_PRINT_PKG dependencies on FND_API

Line 144: IF FND_API.To_Boolean(l_key_exists) THEN

140: 'F',
141: l_rowid,
142: l_key_exists);
143:
144: IF FND_API.To_Boolean(l_key_exists) THEN
145: RAISE Label_Exists_Error;
146: END IF;
147:
148: FND_FILE.PUT(FND_FILE.LOG,' Record does not exist:' || TO_CHAR(p_document_text_id));

Line 256: IF FND_API.To_Boolean(l_key_exists) THEN

252: 'F',
253: l_rowid,
254: l_key_exists);
255:
256: IF FND_API.To_Boolean(l_key_exists) THEN
257: x_rowid := l_rowid;
258: ELSE
259: RAISE Row_Missing_Error;
260: END IF;

Line 264: IF FND_API.To_Boolean(p_commit) THEN

260: END IF;
261:
262: /* Check the commit flag and if set, then commit the work. */
263:
264: IF FND_API.To_Boolean(p_commit) THEN
265: COMMIT WORK;
266: END IF;
267:
268: EXCEPTION

Line 279: IF FND_API.To_Boolean(p_called_by_form) THEN

275: 'GR_FOREIGN_KEY_ERROR');
276: FND_MESSAGE.SET_TOKEN('TEXT',
277: l_msg_data,
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 294: IF FND_API.To_Boolean(p_called_by_form) THEN

290: 'GR_RECORD_EXISTS');
291: FND_MESSAGE.SET_TOKEN('CODE',
292: p_document_code || ' ' || p_item_code,
293: FALSE);
294: IF FND_API.To_Boolean(p_called_by_form) THEN
295: APP_EXCEPTION.Raise_Exception;
296: ELSE
297: x_msg_data := FND_MESSAGE.Get;
298: END IF;

Line 309: IF FND_API.To_Boolean(p_called_by_form) THEN

305: 'GR_NO_RECORD_INSERTED');
306: FND_MESSAGE.SET_TOKEN('CODE',
307: p_document_code || ' ' || p_item_code,
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_UNEXPECTED_ERROR');
322: FND_MESSAGE.SET_TOKEN('TEXT',
323: l_msg_data,
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 514: IF FND_API.To_Boolean(p_commit) THEN

510: END IF;
511:
512: /* Check the commit flag and if set, then commit the work. */
513:
514: IF FND_API.To_Boolean(p_commit) THEN
515: COMMIT WORK;
516: END IF;
517:
518: EXCEPTION

Line 529: IF FND_API.To_Boolean(p_called_by_form) THEN

525: 'GR_FOREIGN_KEY_ERROR');
526: FND_MESSAGE.SET_TOKEN('TEXT',
527: l_msg_data,
528: FALSE);
529: IF FND_API.To_Boolean(p_called_by_form) THEN
530: APP_EXCEPTION.Raise_Exception;
531: ELSE
532: x_msg_data := FND_MESSAGE.Get;
533: END IF;

Line 544: IF FND_API.To_Boolean(p_called_by_form) THEN

540: 'GR_NO_RECORD_INSERTED');
541: FND_MESSAGE.SET_TOKEN('CODE',
542: p_document_code || ' ' || p_item_code,
543: FALSE);
544: IF FND_API.To_Boolean(p_called_by_form) THEN
545: APP_EXCEPTION.Raise_Exception;
546: ELSE
547: x_msg_data := FND_MESSAGE.Get;
548: END IF;

Line 560: IF FND_API.To_Boolean(p_called_by_form) THEN

556: 'GR_UNEXPECTED_ERROR');
557: FND_MESSAGE.SET_TOKEN('TEXT',
558: l_msg_data,
559: FALSE);
560: IF FND_API.To_Boolean(p_called_by_form) THEN
561: APP_EXCEPTION.Raise_Exception;
562: ELSE
563: x_msg_data := FND_MESSAGE.Get;
564: END IF;

Line 666: IF FND_API.To_Boolean(p_commit) THEN

662: RAISE No_Data_Found_Error;
663: END IF;
664: CLOSE c_lock_document_print;
665:
666: IF FND_API.To_Boolean(p_commit) THEN
667: COMMIT WORK;
668: END IF;
669:
670: EXCEPTION

Line 680: IF FND_API.To_Boolean(p_called_by_form) THEN

676: 'GR_RECORD_NOT_FOUND');
677: FND_MESSAGE.SET_TOKEN('CODE',
678: p_document_code || ' ' || p_item_code,
679: FALSE);
680: IF FND_API.To_Boolean(p_called_by_form) THEN
681: APP_EXCEPTION.Raise_Exception;
682: ELSE
683: x_msg_data := FND_MESSAGE.Get;
684: END IF;

Line 694: IF FND_API.To_Boolean(p_called_by_form) THEN

690: x_oracle_error := SQLCODE;
691: -- Bug #2180453 (JKB)
692: FND_MESSAGE.SET_NAME('GR',
693: 'GR_ROW_IS_LOCKED');
694: IF FND_API.To_Boolean(p_called_by_form) THEN
695: APP_EXCEPTION.Raise_Exception;
696: ELSE
697: x_msg_data := FND_MESSAGE.Get;
698: END IF;

Line 710: IF FND_API.To_Boolean(p_called_by_form) THEN

706: 'GR_UNEXPECTED_ERROR');
707: FND_MESSAGE.SET_TOKEN('TEXT',
708: l_msg_data,
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 855: IF FND_API.TO_Boolean(p_commit) THEN

851: WHERE rowid = p_rowid;
852:
853: /* Check the commit flag and if set, then commit the work. */
854:
855: IF FND_API.TO_Boolean(p_commit) THEN
856: COMMIT WORK;
857: END IF;
858:
859: EXCEPTION

Line 865: IF FND_API.To_Boolean(p_called_by_form) THEN

861: WHEN Check_Integrity_Error THEN
862: ROLLBACK TO SAVEPOINT Delete_Row;
863: x_return_status := l_return_status;
864: x_oracle_error := l_oracle_error;
865: IF FND_API.To_Boolean(p_called_by_form) THEN
866: APP_EXCEPTION.Raise_Exception;
867: ELSE
868: x_msg_data := FND_MESSAGE.Get;
869: END IF;

Line 880: IF FND_API.To_Boolean(p_called_by_form) THEN

876: 'GR_RECORD_NOT_FOUND');
877: FND_MESSAGE.SET_TOKEN('CODE',
878: p_document_code || ' ' || p_item_code,
879: FALSE);
880: IF FND_API.To_Boolean(p_called_by_form) THEN
881: APP_EXCEPTION.Raise_Exception;
882: ELSE
883: x_msg_data := FND_MESSAGE.Get;
884: END IF;

Line 896: IF FND_API.To_Boolean(p_called_by_form) THEN

892: 'GR_UNEXPECTED_ERROR');
893: FND_MESSAGE.SET_TOKEN('TEXT',
894: l_msg_data,
895: FALSE);
896: IF FND_API.To_Boolean(p_called_by_form) THEN
897: APP_EXCEPTION.Raise_Exception;
898: ELSE
899: x_msg_data := FND_MESSAGE.Get;
900: END IF;

Line 1002: IF FND_API.To_Boolean(p_commit) THEN

998: AND item_code = p_item_code;
999: END IF;
1000: END IF;
1001:
1002: IF FND_API.To_Boolean(p_commit) THEN
1003: COMMIT WORK;
1004: END IF;
1005:
1006: EXCEPTION

Line 1016: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 1032: IF FND_API.To_Boolean(p_called_by_form) THEN

1028: 'GR_UNEXPECTED_ERROR');
1029: FND_MESSAGE.SET_TOKEN('TEXT',
1030: l_msg_token,
1031: FALSE);
1032: IF FND_API.To_Boolean(p_called_by_form) THEN
1033: APP_EXCEPTION.Raise_Exception;
1034: ELSE
1035: x_msg_data := FND_MESSAGE.Get;
1036: END IF;

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

1143: l_key_exists);
1144: /*
1145: ** If not on item master, then check inventory master
1146: */
1147: IF NOT FND_API.To_Boolean(l_key_exists) THEN
1148: OPEN c_get_item;
1149: FETCH c_get_item INTO LocalItemRecord;
1150: IF c_get_item%NOTFOUND THEN
1151: x_return_status := 'E';

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

1165: (p_document_code,
1166: 'F',
1167: l_rowid,
1168: l_key_exists);
1169: IF NOT FND_API.To_Boolean(l_key_exists) THEN
1170: x_return_status := 'E';
1171: FND_MESSAGE.SET_NAME('GR',
1172: 'GR_RECORD_NOT_FOUND');
1173: FND_MESSAGE.SET_TOKEN('CODE',

Line 1368: IF FND_API.To_Boolean(p_called_by_form) THEN

1364: 'GR_INSTALLED_LANG');
1365: FND_MESSAGE.SET_TOKEN('CODE',
1366: p_language,
1367: FALSE);
1368: IF FND_API.To_Boolean(p_called_by_form) THEN
1369: APP_EXCEPTION.Raise_Exception;
1370: ELSE
1371: x_msg_data := FND_MESSAGE.Get;
1372: END IF;

Line 1384: IF FND_API.To_Boolean(p_called_by_form) THEN

1380: 'GR_UNEXPECTED_ERROR');
1381: FND_MESSAGE.SET_TOKEN('TEXT',
1382: l_msg_data,
1383: FALSE);
1384: IF FND_API.To_Boolean(p_called_by_form) THEN
1385: APP_EXCEPTION.Raise_Exception;
1386: ELSE
1387: x_msg_data := FND_MESSAGE.Get;
1388: END IF;

Line 1440: IF FND_API.To_Boolean(p_called_by_form) THEN

1436: 'GR_UNEXPECTED_ERROR');
1437: FND_MESSAGE.SET_TOKEN('TEXT',
1438: l_msg_data,
1439: FALSE);
1440: IF FND_API.To_Boolean(p_called_by_form) THEN
1441: APP_EXCEPTION.Raise_Exception;
1442: END IF;
1443:
1444: END Check_Primary_Key;