eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GR_INGRED_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_ingredient_concentrations

Line 108: IF FND_API.To_Boolean(l_key_exists) THEN

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

Line 116: IF FND_API.To_Boolean(p_commit) THEN

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

Line 131: IF FND_API.To_Boolean(p_called_by_form) THEN

127: 'GR_FOREIGN_KEY_ERROR');
128: FND_MESSAGE.SET_TOKEN('TEXT',
129: l_msg_data,
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: 'GR_RECORD_EXISTS');
144: FND_MESSAGE.SET_TOKEN('CODE',
145: l_msg_token,
146: FALSE);
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_NO_RECORD_INSERTED');
160: FND_MESSAGE.SET_TOKEN('CODE',
161: l_msg_token,
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 180: IF FND_API.To_Boolean(p_called_by_form) THEN

176: 'GR_UNEXPECTED_ERROR');
177: FND_MESSAGE.SET_TOKEN('TEXT',
178: l_msg_token,
179: FALSE);
180: IF FND_API.To_Boolean(p_called_by_form) THEN
181: APP_EXCEPTION.Raise_Exception;
182: ELSE
183: x_msg_data := FND_MESSAGE.Get;
184: 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 495: IF FND_API.TO_Boolean(p_commit) THEN

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

Line 505: IF FND_API.To_Boolean(p_called_by_form) THEN

501: WHEN Check_Integrity_Error THEN
502: ROLLBACK TO SAVEPOINT Delete_Row;
503: x_return_status := l_return_status;
504: x_oracle_error := l_oracle_error;
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 520: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 537: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 581: IF FND_API.To_Boolean(p_commit) THEN

577: DELETE FROM gr_ingredient_concentrations
578: WHERE organization_id = p_organization_id
579: AND product_item_id = p_product_item_id;
580:
581: IF FND_API.To_Boolean(p_commit) THEN
582: COMMIT WORK;
583: END IF;
584:
585: EXCEPTION

Line 597: IF FND_API.To_Boolean(p_called_by_form) THEN

593: 'GR_UNEXPECTED_ERROR');
594: FND_MESSAGE.SET_TOKEN('TEXT',
595: l_msg_token,
596: FALSE);
597: IF FND_API.To_Boolean(p_called_by_form) THEN
598: APP_EXCEPTION.Raise_Exception;
599: ELSE
600: x_msg_data := FND_MESSAGE.Get;
601: 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 768: IF FND_API.To_Boolean(p_called_by_form) THEN

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