DBA Data[Home] [Help]

APPS.GR_EXPOSURE_AUTHS_B_PKG dependencies on FND_API

Line 66: IF FND_API.To_Boolean(l_key_exists) THEN

62: 'F',
63: l_rowid,
64: l_key_exists);
65:
66: IF FND_API.To_Boolean(l_key_exists) THEN
67: RAISE Item_Exists_Error;
68: END IF;
69:
70: INSERT INTO gr_exposure_auths_b

Line 93: IF FND_API.To_Boolean(l_key_exists) THEN

89: 'F',
90: l_rowid,
91: l_key_exists);
92:
93: IF FND_API.To_Boolean(l_key_exists) THEN
94: x_rowid := l_rowid;
95: ELSE
96: RAISE Row_Missing_Error;
97: END IF;

Line 101: IF FND_API.To_Boolean(p_commit) THEN

97: END IF;
98:
99: /* Check the commit flag and if set, then commit the work. */
100:
101: IF FND_API.To_Boolean(p_commit) THEN
102: COMMIT WORK;
103: END IF;
104:
105: EXCEPTION

Line 116: IF FND_API.To_Boolean(p_called_by_form) THEN

112: 'GR_FOREIGN_KEY_ERROR');
113: FND_MESSAGE.SET_TOKEN('TEXT',
114: l_msg_data,
115: FALSE);
116: IF FND_API.To_Boolean(p_called_by_form) THEN
117: APP_EXCEPTION.Raise_Exception;
118: ELSE
119: x_msg_data := FND_MESSAGE.Get;
120: END IF;

Line 131: IF FND_API.To_Boolean(p_called_by_form) THEN

127: 'GR_RECORD_EXISTS');
128: FND_MESSAGE.SET_TOKEN('CODE',
129: p_exposure_authority_code,
130: FALSE);
131: IF FND_API.To_Boolean(p_called_by_form) THEN
132: APP_EXCEPTION.Raise_Exception;
133: ELSE
134: x_msg_data := FND_MESSAGE.Get;
135: END IF;

Line 147: IF FND_API.To_Boolean(p_called_by_form) THEN

143: FND_MESSAGE.SET_TOKEN('CODE',
144: p_exposure_authority_code,
145: FALSE);
146: x_msg_data := FND_MESSAGE.Get;
147: IF FND_API.To_Boolean(p_called_by_form) THEN
148: APP_EXCEPTION.Raise_Exception;
149: ELSE
150: x_msg_data := FND_MESSAGE.Get;
151: END IF;

Line 163: IF FND_API.To_Boolean(p_called_by_form) THEN

159: 'GR_UNEXPECTED_ERROR');
160: FND_MESSAGE.SET_TOKEN('TEXT',
161: l_msg_data,
162: FALSE);
163: IF FND_API.To_Boolean(p_called_by_form) THEN
164: APP_EXCEPTION.Raise_Exception;
165: ELSE
166: x_msg_data := FND_MESSAGE.Get;
167: END IF;

Line 236: IF FND_API.To_Boolean(p_commit) THEN

232: END IF;
233:
234: /* Check if do the commit */
235:
236: IF FND_API.To_Boolean(p_commit) THEN
237: COMMIT WORK;
238: END IF;
239:
240: EXCEPTION

Line 251: IF FND_API.To_Boolean(p_called_by_form) THEN

247: 'GR_FOREIGN_KEY_ERROR');
248: FND_MESSAGE.SET_TOKEN('TEXT',
249: l_msg_data,
250: FALSE);
251: IF FND_API.To_Boolean(p_called_by_form) THEN
252: APP_EXCEPTION.Raise_Exception;
253: ELSE
254: x_msg_data := FND_MESSAGE.Get;
255: END IF;

Line 266: IF FND_API.To_Boolean(p_called_by_form) THEN

262: 'GR_NO_RECORD_INSERTED');
263: FND_MESSAGE.SET_TOKEN('CODE',
264: p_exposure_authority_code,
265: FALSE);
266: IF FND_API.To_Boolean(p_called_by_form) THEN
267: APP_EXCEPTION.Raise_Exception;
268: ELSE
269: x_msg_data := FND_MESSAGE.Get;
270: END IF;

Line 282: IF FND_API.To_Boolean(p_called_by_form) THEN

278: 'GR_UNEXPECTED_ERROR');
279: FND_MESSAGE.SET_TOKEN('TEXT',
280: l_msg_data,
281: FALSE);
282: IF FND_API.To_Boolean(p_called_by_form) THEN
283: APP_EXCEPTION.Raise_Exception;
284: ELSE
285: x_msg_data := FND_MESSAGE.Get;
286: END IF;

Line 352: IF FND_API.To_Boolean(p_commit) THEN

348: IF LockExposureRcd.last_update_date <> p_last_update_date THEN
349: RAISE RECORD_CHANGED_ERROR;
350: END IF;
351:
352: IF FND_API.To_Boolean(p_commit) THEN
353: COMMIT WORK;
354: END IF;
355:
356: EXCEPTION

Line 366: IF FND_API.To_Boolean(p_called_by_form) THEN

362: 'GR_RECORD_NOT_FOUND');
363: FND_MESSAGE.SET_TOKEN('CODE',
364: p_exposure_authority_code,
365: FALSE);
366: IF FND_API.To_Boolean(p_called_by_form) THEN
367: APP_EXCEPTION.Raise_Exception;
368: ELSE
369: x_msg_data := FND_MESSAGE.Get;
370: END IF;

Line 376: IF FND_API.To_Boolean(p_called_by_form) THEN

372: ROLLBACK TO SAVEPOINT Lock_Row;
373: X_return_status := 'E';
374: FND_MESSAGE.SET_NAME('FND',
375: 'FORM_RECORD_CHANGED');
376: IF FND_API.To_Boolean(p_called_by_form) THEN
377: APP_EXCEPTION.Raise_Exception;
378: ELSE
379: x_msg_data := FND_MESSAGE.Get;
380: END IF;

Line 385: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN

381: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
382: ROLLBACK TO SAVEPOINT Lock_Row;
383: x_return_status := 'L';
384: x_oracle_error := APP_EXCEPTION.Get_Code;
385: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN
386: FND_MESSAGE.SET_NAME('GR',
387: 'GR_ROW_IS_LOCKED');
388: x_msg_data := FND_MESSAGE.Get;
389: END IF;

Line 400: IF FND_API.To_Boolean(p_called_by_form) THEN

396: 'GR_UNEXPECTED_ERROR');
397: FND_MESSAGE.SET_TOKEN('TEXT',
398: l_msg_data,
399: FALSE);
400: IF FND_API.To_Boolean(p_called_by_form) THEN
401: APP_EXCEPTION.Raise_Exception;
402: ELSE
403: x_msg_data := FND_MESSAGE.Get;
404: END IF;

Line 464: IF FND_API.TO_Boolean(p_commit) THEN

460: WHERE rowid = p_rowid;
461:
462: /* Check the commit flag and if set, then commit the work. */
463:
464: IF FND_API.TO_Boolean(p_commit) THEN
465: COMMIT WORK;
466: END IF;
467:
468: EXCEPTION

Line 474: IF FND_API.To_Boolean(p_called_by_form) THEN

470: WHEN Check_Integrity_Error THEN
471: ROLLBACK TO SAVEPOINT Delete_Row;
472: x_return_status := l_return_status;
473: x_oracle_error := l_oracle_error;
474: IF FND_API.To_Boolean(p_called_by_form) THEN
475: APP_EXCEPTION.Raise_Exception;
476: ELSE
477: x_msg_data := FND_MESSAGE.Get;
478: END IF;

Line 489: IF FND_API.To_Boolean(p_called_by_form) THEN

485: 'GR_RECORD_NOT_FOUND');
486: FND_MESSAGE.SET_TOKEN('CODE',
487: p_exposure_authority_code,
488: FALSE);
489: IF FND_API.To_Boolean(p_called_by_form) THEN
490: APP_EXCEPTION.Raise_Exception;
491: ELSE
492: x_msg_data := FND_MESSAGE.Get;
493: END IF;

Line 505: IF FND_API.To_Boolean(p_called_by_form) THEN

501: 'GR_UNEXPECTED_ERROR');
502: FND_MESSAGE.SET_TOKEN('TEXT',
503: l_msg_data,
504: FALSE);
505: IF FND_API.To_Boolean(p_called_by_form) THEN
506: APP_EXCEPTION.Raise_Exception;
507: ELSE
508: x_msg_data := FND_MESSAGE.Get;
509: END IF;

Line 624: IF FND_API.To_Boolean(p_called_by_form) THEN

620: FALSE);
621: FND_MESSAGE.SET_TOKEN('TABLES',
622: l_msg_data,
623: FALSE);
624: IF FND_API.To_Boolean(p_called_by_form) THEN
625: APP_EXCEPTION.Raise_Exception;
626: ELSE
627: x_msg_data := FND_MESSAGE.Get;
628: END IF;

Line 639: IF FND_API.To_Boolean(p_called_by_form) THEN

635: 'GR_UNEXPECTED_ERROR');
636: FND_MESSAGE.SET_TOKEN('TEXT',
637: l_msg_data,
638: FALSE);
639: IF FND_API.To_Boolean(p_called_by_form) THEN
640: APP_EXCEPTION.Raise_Exception;
641: ELSE
642: x_msg_data := FND_MESSAGE.Get;
643: END IF;

Line 686: IF FND_API.To_Boolean(p_called_by_form) THEN

682: 'GR_UNEXPECTED_ERROR');
683: FND_MESSAGE.SET_TOKEN('TEXT',
684: l_msg_data,
685: FALSE);
686: IF FND_API.To_Boolean(p_called_by_form) THEN
687: APP_EXCEPTION.Raise_Exception;
688: END IF;
689:
690: END Check_Primary_Key;