DBA Data[Home] [Help]

APPS.GR_ITEM_CONCENTRATIONS_PKG dependencies on FND_API

Line 73: IF FND_API.To_Boolean(l_key_exists) THEN

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

Line 107: IF FND_API.To_Boolean(l_key_exists) THEN

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

Line 115: IF FND_API.To_Boolean(p_commit) THEN

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

Line 130: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 146: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 162: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 179: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 262: IF FND_API.To_Boolean(p_commit) THEN

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

Line 277: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 292: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 308: IF FND_API.To_Boolean(p_called_by_form) THEN

304: 'GR_UNEXPECTED_ERROR');
305: FND_MESSAGE.SET_TOKEN('TEXT',
306: l_msg_token,
307: FALSE);
308: IF FND_API.To_Boolean(p_called_by_form) THEN
309: APP_EXCEPTION.Raise_Exception;
310: ELSE
311: x_msg_data := FND_MESSAGE.Get;
312: END IF;

Line 379: IF FND_API.To_Boolean(p_commit) THEN

375: RAISE No_Data_Found_Error;
376: END IF;
377: CLOSE c_lock_concs_tl;
378:
379: IF FND_API.To_Boolean(p_commit) THEN
380: COMMIT WORK;
381: END IF;
382:
383: EXCEPTION

Line 393: IF FND_API.To_Boolean(p_called_by_form) THEN

389: 'GR_RECORD_NOT_FOUND');
390: FND_MESSAGE.SET_TOKEN('CODE',
391: l_msg_token,
392: FALSE);
393: IF FND_API.To_Boolean(p_called_by_form) THEN
394: APP_EXCEPTION.Raise_Exception;
395: ELSE
396: x_msg_data := FND_MESSAGE.Get;
397: END IF;

Line 405: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 421: IF FND_API.To_Boolean(p_called_by_form) THEN

417: 'GR_UNEXPECTED_ERROR');
418: FND_MESSAGE.SET_TOKEN('TEXT',
419: l_msg_token,
420: FALSE);
421: IF FND_API.To_Boolean(p_called_by_form) THEN
422: APP_EXCEPTION.Raise_Exception;
423: ELSE
424: x_msg_data := FND_MESSAGE.Get;
425: END IF;

Line 496: IF FND_API.TO_Boolean(p_commit) THEN

492: WHERE rowid = p_rowid;
493:
494: /* Check the commit flag and if set, then commit the work. */
495:
496: IF FND_API.TO_Boolean(p_commit) THEN
497: COMMIT WORK;
498: END IF;
499:
500: EXCEPTION

Line 506: IF FND_API.To_Boolean(p_called_by_form) THEN

502: WHEN Check_Integrity_Error THEN
503: ROLLBACK TO SAVEPOINT Delete_Row;
504: x_return_status := l_return_status;
505: x_oracle_error := l_oracle_error;
506: IF FND_API.To_Boolean(p_called_by_form) THEN
507: APP_EXCEPTION.Raise_Exception;
508: ELSE
509: x_msg_data := FND_MESSAGE.Get;
510: END IF;

Line 521: IF FND_API.To_Boolean(p_called_by_form) THEN

517: 'GR_RECORD_NOT_FOUND');
518: FND_MESSAGE.SET_TOKEN('CODE',
519: l_msg_token,
520: FALSE);
521: IF FND_API.To_Boolean(p_called_by_form) THEN
522: APP_EXCEPTION.Raise_Exception;
523: ELSE
524: x_msg_data := FND_MESSAGE.Get;
525: END IF;

Line 538: IF FND_API.To_Boolean(p_called_by_form) THEN

534: 'GR_UNEXPECTED_ERROR');
535: FND_MESSAGE.SET_TOKEN('TEXT',
536: l_msg_token,
537: FALSE);
538: IF FND_API.To_Boolean(p_called_by_form) THEN
539: APP_EXCEPTION.Raise_Exception;
540: ELSE
541: x_msg_data := FND_MESSAGE.Get;
542: END IF;

Line 580: IF FND_API.To_Boolean(p_commit) THEN

576:
577: DELETE FROM gr_item_concentrations
578: WHERE item_code = p_item_code;
579:
580: IF FND_API.To_Boolean(p_commit) THEN
581: COMMIT WORK;
582: END IF;
583:
584: EXCEPTION

Line 596: IF FND_API.To_Boolean(p_called_by_form) THEN

592: 'GR_UNEXPECTED_ERROR');
593: FND_MESSAGE.SET_TOKEN('TEXT',
594: l_msg_token,
595: FALSE);
596: IF FND_API.To_Boolean(p_called_by_form) THEN
597: APP_EXCEPTION.Raise_Exception;
598: ELSE
599: x_msg_data := FND_MESSAGE.Get;
600: END IF;

Line 707: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 767: IF FND_API.To_Boolean(p_called_by_form) THEN

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