DBA Data[Home] [Help]

APPS.GR_ITEM_EXPOSURE_PKG dependencies on FND_API

Line 147: IF FND_API.To_Boolean(l_key_exists) THEN

143: 'F',
144: l_rowid,
145: l_key_exists);
146:
147: IF FND_API.To_Boolean(l_key_exists) THEN
148: RAISE Item_Exists_Error;
149: END IF;
150:
151: INSERT INTO gr_item_exposure

Line 253: IF FND_API.To_Boolean(l_key_exists) THEN

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

Line 261: IF FND_API.To_Boolean(p_commit) THEN

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

Line 276: IF FND_API.To_Boolean(p_called_by_form) THEN

272: 'GR_FOREIGN_KEY_ERROR');
273: FND_MESSAGE.SET_TOKEN('TEXT',
274: l_msg_data,
275: FALSE);
276: IF FND_API.To_Boolean(p_called_by_form) THEN
277: APP_EXCEPTION.Raise_Exception;
278: ELSE
279: x_msg_data := FND_MESSAGE.Get;
280: END IF;

Line 291: IF FND_API.To_Boolean(p_called_by_form) THEN

287: 'GR_RECORD_EXISTS');
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 306: IF FND_API.To_Boolean(p_called_by_form) THEN

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

318: 'GR_UNEXPECTED_ERROR');
319: FND_MESSAGE.SET_TOKEN('TEXT',
320: l_msg_token,
321: FALSE);
322: IF FND_API.To_Boolean(p_called_by_form) THEN
323: APP_EXCEPTION.Raise_Exception;
324: ELSE
325: x_msg_data := FND_MESSAGE.Get;
326: END IF;

Line 512: IF FND_API.To_Boolean(p_commit) THEN

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

Line 527: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 542: IF FND_API.To_Boolean(p_called_by_form) THEN

538: 'GR_NO_RECORD_INSERTED');
539: FND_MESSAGE.SET_TOKEN('CODE',
540: l_msg_token,
541: FALSE);
542: IF FND_API.To_Boolean(p_called_by_form) THEN
543: APP_EXCEPTION.Raise_Exception;
544: ELSE
545: x_msg_data := FND_MESSAGE.Get;
546: END IF;

Line 558: IF FND_API.To_Boolean(p_called_by_form) THEN

554: 'GR_UNEXPECTED_ERROR');
555: FND_MESSAGE.SET_TOKEN('TEXT',
556: l_msg_token,
557: FALSE);
558: IF FND_API.To_Boolean(p_called_by_form) THEN
559: APP_EXCEPTION.Raise_Exception;
560: ELSE
561: x_msg_data := FND_MESSAGE.Get;
562: 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_item_exposure;
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: l_msg_token,
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 692: IF FND_API.To_Boolean(p_called_by_form) THEN

688: x_return_status := 'E';
689: x_oracle_error := APP_EXCEPTION.Get_Code;
690: FND_MESSAGE.SET_NAME('GR',
691: 'GR_ROW_IS_LOCKED');
692: IF FND_API.To_Boolean(p_called_by_form) THEN
693: APP_EXCEPTION.Raise_Exception;
694: ELSE
695: x_msg_data := FND_MESSAGE.Get;
696: END IF;

Line 708: IF FND_API.To_Boolean(p_called_by_form) THEN

704: 'GR_UNEXPECTED_ERROR');
705: FND_MESSAGE.SET_TOKEN('TEXT',
706: l_msg_token,
707: FALSE);
708: IF FND_API.To_Boolean(p_called_by_form) THEN
709: APP_EXCEPTION.Raise_Exception;
710: ELSE
711: x_msg_data := FND_MESSAGE.Get;
712: 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: l_msg_token,
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 897: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 1011: IF FND_API.To_Boolean(p_commit) THEN

1007: AND exposure_type_code = p_exposure_type_code;
1008: END IF;
1009: END IF;
1010:
1011: IF FND_API.To_Boolean(p_commit) THEN
1012: COMMIT WORK;
1013: END IF;
1014:
1015: EXCEPTION

Line 1025: IF FND_API.To_Boolean(p_called_by_form) THEN

1021: 'GR_NULL_VALUE');
1022: FND_MESSAGE.SET_TOKEN('CODE',
1023: l_msg_token,
1024: FALSE);
1025: IF FND_API.To_Boolean(p_called_by_form) THEN
1026: APP_EXCEPTION.Raise_Exception;
1027: ELSE
1028: x_msg_data := FND_MESSAGE.Get;
1029: END IF;

Line 1041: IF FND_API.To_Boolean(p_called_by_form) THEN

1037: 'GR_UNEXPECTED_ERROR');
1038: FND_MESSAGE.SET_TOKEN('TEXT',
1039: l_msg_token,
1040: FALSE);
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 1127: IF NOT FND_API.To_Boolean(l_key_exists) THEN

1123: 'F',
1124: l_rowid,
1125: l_key_exists);
1126:
1127: IF NOT FND_API.To_Boolean(l_key_exists) THEN
1128: l_return_status := 'E';
1129: l_msg_token := l_msg_token || ' ' || p_item_code;
1130: END IF;
1131:

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

1136: 'F',
1137: l_rowid,
1138: l_key_exists);
1139:
1140: IF NOT FND_API.To_Boolean(l_key_exists) THEN
1141: l_return_status := 'E';
1142: l_msg_token := l_msg_token || ' ' || p_label_code;
1143: END IF;
1144:

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

1149: 'F',
1150: l_rowid,
1151: l_key_exists);
1152:
1153: IF NOT FND_API.To_Boolean(l_key_exists) THEN
1154: l_return_status := 'E';
1155: l_msg_token := l_msg_token || ' ' || p_exposure_authority_code;
1156: END IF;
1157:

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

1162: 'F',
1163: l_rowid,
1164: l_key_exists);
1165:
1166: IF NOT FND_API.To_Boolean(l_key_exists) THEN
1167: l_return_status := 'E';
1168: l_msg_token := l_msg_token || ' ' || p_exposure_type_code;
1169: END IF;
1170:

Line 1286: IF FND_API.To_Boolean(p_called_by_form) THEN

1282: 'GR_UNEXPECTED_ERROR');
1283: FND_MESSAGE.SET_TOKEN('TEXT',
1284: l_msg_data,
1285: FALSE);
1286: IF FND_API.To_Boolean(p_called_by_form) THEN
1287: APP_EXCEPTION.Raise_Exception;
1288: ELSE
1289: x_msg_data := FND_MESSAGE.Get;
1290: END IF;

Line 1354: IF FND_API.To_Boolean(p_called_by_form) THEN

1350: 'GR_UNEXPECTED_ERROR');
1351: FND_MESSAGE.SET_TOKEN('TEXT',
1352: l_msg_data,
1353: FALSE);
1354: IF FND_API.To_Boolean(p_called_by_form) THEN
1355: APP_EXCEPTION.Raise_Exception;
1356: END IF;
1357:
1358: END Check_Primary_Key;