DBA Data[Home] [Help]

APPS.GR_ITEM_CONC_DETAILS_PKG dependencies on FND_API

Line 75: IF FND_API.To_Boolean(l_key_exists) THEN

71: 'F',
72: l_rowid,
73: l_key_exists);
74:
75: IF FND_API.To_Boolean(l_key_exists) THEN
76: RAISE Item_Exists_Error;
77: END IF;
78:
79: INSERT INTO gr_item_conc_details

Line 106: IF FND_API.To_Boolean(l_key_exists) THEN

102: 'F',
103: l_rowid,
104: l_key_exists);
105:
106: IF FND_API.To_Boolean(l_key_exists) THEN
107: x_rowid := l_rowid;
108: ELSE
109: RAISE Row_Missing_Error;
110: END IF;

Line 114: IF FND_API.To_Boolean(p_commit) THEN

110: END IF;
111:
112: /* Check the commit flag and if set, then commit the work. */
113:
114: IF FND_API.To_Boolean(p_commit) THEN
115: COMMIT WORK;
116: END IF;
117:
118: EXCEPTION

Line 129: IF FND_API.To_Boolean(p_called_by_form) THEN

125: 'GR_FOREIGN_KEY_ERROR');
126: FND_MESSAGE.SET_TOKEN('TEXT',
127: l_msg_data,
128: FALSE);
129: IF FND_API.To_Boolean(p_called_by_form) THEN
130: APP_EXCEPTION.Raise_Exception;
131: ELSE
132: x_msg_data := FND_MESSAGE.Get;
133: END IF;

Line 145: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 161: IF FND_API.To_Boolean(p_called_by_form) THEN

157: 'GR_NO_RECORD_INSERTED');
158: FND_MESSAGE.SET_TOKEN('CODE',
159: l_msg_token,
160: FALSE);
161: IF FND_API.To_Boolean(p_called_by_form) THEN
162: APP_EXCEPTION.Raise_Exception;
163: ELSE
164: x_msg_data := FND_MESSAGE.Get;
165: END IF;

Line 178: IF FND_API.To_Boolean(p_called_by_form) THEN

174: 'GR_UNEXPECTED_ERROR');
175: FND_MESSAGE.SET_TOKEN('TEXT',
176: l_msg_token,
177: FALSE);
178: IF FND_API.To_Boolean(p_called_by_form) THEN
179: APP_EXCEPTION.Raise_Exception;
180: ELSE
181: x_msg_data := FND_MESSAGE.Get;
182: END IF;

Line 260: IF FND_API.To_Boolean(p_commit) THEN

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

Line 275: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 290: IF FND_API.To_Boolean(p_called_by_form) THEN

286: 'GR_NO_RECORD_INSERTED');
287: FND_MESSAGE.SET_TOKEN('CODE',
288: l_msg_token,
289: FALSE);
290: IF FND_API.To_Boolean(p_called_by_form) THEN
291: APP_EXCEPTION.Raise_Exception;
292: ELSE
293: x_msg_data := FND_MESSAGE.Get;
294: END IF;

Line 306: IF FND_API.To_Boolean(p_called_by_form) THEN

302: 'GR_UNEXPECTED_ERROR');
303: FND_MESSAGE.SET_TOKEN('TEXT',
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 375: IF FND_API.To_Boolean(p_commit) THEN

371: RAISE No_Data_Found_Error;
372: END IF;
373: CLOSE c_lock_concs_tl;
374:
375: IF FND_API.To_Boolean(p_commit) THEN
376: COMMIT WORK;
377: END IF;
378:
379: EXCEPTION

Line 389: IF FND_API.To_Boolean(p_called_by_form) THEN

385: 'GR_RECORD_NOT_FOUND');
386: FND_MESSAGE.SET_TOKEN('CODE',
387: l_msg_token,
388: FALSE);
389: IF FND_API.To_Boolean(p_called_by_form) THEN
390: APP_EXCEPTION.Raise_Exception;
391: ELSE
392: x_msg_data := FND_MESSAGE.Get;
393: END IF;

Line 401: IF FND_API.To_Boolean(p_called_by_form) THEN

397: x_return_status := 'E';
398: x_oracle_error := APP_EXCEPTION.Get_Code;
399: FND_MESSAGE.SET_NAME('GR',
400: 'GR_ROW_IS_LOCKED');
401: IF FND_API.To_Boolean(p_called_by_form) THEN
402: APP_EXCEPTION.Raise_Exception;
403: ELSE
404: x_msg_data := FND_MESSAGE.Get;
405: END IF;

Line 417: IF FND_API.To_Boolean(p_called_by_form) THEN

413: 'GR_UNEXPECTED_ERROR');
414: FND_MESSAGE.SET_TOKEN('TEXT',
415: l_msg_token,
416: FALSE);
417: IF FND_API.To_Boolean(p_called_by_form) THEN
418: APP_EXCEPTION.Raise_Exception;
419: ELSE
420: x_msg_data := FND_MESSAGE.Get;
421: END IF;

Line 491: IF FND_API.TO_Boolean(p_commit) THEN

487: WHERE rowid = p_rowid;
488:
489: /* Check the commit flag and if set, then commit the work. */
490:
491: IF FND_API.TO_Boolean(p_commit) THEN
492: COMMIT WORK;
493: END IF;
494:
495: EXCEPTION

Line 501: IF FND_API.To_Boolean(p_called_by_form) THEN

497: WHEN Check_Integrity_Error THEN
498: ROLLBACK TO SAVEPOINT Delete_Row;
499: x_return_status := l_return_status;
500: x_oracle_error := l_oracle_error;
501: IF FND_API.To_Boolean(p_called_by_form) THEN
502: APP_EXCEPTION.Raise_Exception;
503: ELSE
504: x_msg_data := FND_MESSAGE.Get;
505: END IF;

Line 516: IF FND_API.To_Boolean(p_called_by_form) THEN

512: 'GR_RECORD_NOT_FOUND');
513: FND_MESSAGE.SET_TOKEN('CODE',
514: l_msg_token,
515: FALSE);
516: IF FND_API.To_Boolean(p_called_by_form) THEN
517: APP_EXCEPTION.Raise_Exception;
518: ELSE
519: x_msg_data := FND_MESSAGE.Get;
520: END IF;

Line 533: IF FND_API.To_Boolean(p_called_by_form) THEN

529: 'GR_UNEXPECTED_ERROR');
530: FND_MESSAGE.SET_TOKEN('TEXT',
531: l_msg_token,
532: FALSE);
533: IF FND_API.To_Boolean(p_called_by_form) THEN
534: APP_EXCEPTION.Raise_Exception;
535: ELSE
536: x_msg_data := FND_MESSAGE.Get;
537: END IF;

Line 575: IF FND_API.To_Boolean(p_commit) THEN

571:
572: DELETE FROM gr_item_conc_details
573: WHERE item_code = p_item_code;
574:
575: IF FND_API.To_Boolean(p_commit) THEN
576: COMMIT WORK;
577: END IF;
578:
579: EXCEPTION

Line 591: IF FND_API.To_Boolean(p_called_by_form) THEN

587: 'GR_UNEXPECTED_ERROR');
588: FND_MESSAGE.SET_TOKEN('TEXT',
589: l_msg_token,
590: FALSE);
591: IF FND_API.To_Boolean(p_called_by_form) THEN
592: APP_EXCEPTION.Raise_Exception;
593: ELSE
594: x_msg_data := FND_MESSAGE.Get;
595: END IF;

Line 706: IF FND_API.To_Boolean(p_called_by_form) THEN

702: 'GR_UNEXPECTED_ERROR');
703: FND_MESSAGE.SET_TOKEN('TEXT',
704: l_msg_data,
705: FALSE);
706: IF FND_API.To_Boolean(p_called_by_form) THEN
707: APP_EXCEPTION.Raise_Exception;
708: ELSE
709: x_msg_data := FND_MESSAGE.Get;
710: END IF;

Line 769: IF FND_API.To_Boolean(p_called_by_form) THEN

765: 'GR_UNEXPECTED_ERROR');
766: FND_MESSAGE.SET_TOKEN('TEXT',
767: l_msg_data,
768: FALSE);
769: IF FND_API.To_Boolean(p_called_by_form) THEN
770: APP_EXCEPTION.Raise_Exception;
771: END IF;
772:
773: END Check_Primary_Key;