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_CONC_DETAILS_PKG dependencies on FND_API

Line 78: IF FND_API.To_Boolean(l_key_exists) THEN

74: 'F',
75: l_rowid,
76: l_key_exists);
77:
78: IF FND_API.To_Boolean(l_key_exists) THEN
79: RAISE Item_Exists_Error;
80: END IF;
81:
82: INSERT INTO gr_ingredient_conc_details

Line 112: IF FND_API.To_Boolean(l_key_exists) THEN

108: 'F',
109: l_rowid,
110: l_key_exists);
111:
112: IF FND_API.To_Boolean(l_key_exists) THEN
113: x_rowid := l_rowid;
114: ELSE
115: RAISE Row_Missing_Error;
116: END IF;

Line 120: IF FND_API.To_Boolean(p_commit) THEN

116: END IF;
117:
118: /* Check the commit flag and if set, then commit the work. */
119:
120: IF FND_API.To_Boolean(p_commit) THEN
121: COMMIT WORK;
122: END IF;
123:
124: EXCEPTION

Line 135: IF FND_API.To_Boolean(p_called_by_form) THEN

131: 'GR_FOREIGN_KEY_ERROR');
132: FND_MESSAGE.SET_TOKEN('TEXT',
133: l_msg_data,
134: FALSE);
135: IF FND_API.To_Boolean(p_called_by_form) THEN
136: APP_EXCEPTION.Raise_Exception;
137: ELSE
138: x_msg_data := FND_MESSAGE.Get;
139: END IF;

Line 151: IF FND_API.To_Boolean(p_called_by_form) THEN

147: 'GR_RECORD_EXISTS');
148: FND_MESSAGE.SET_TOKEN('CODE',
149: l_msg_token,
150: FALSE);
151: IF FND_API.To_Boolean(p_called_by_form) THEN
152: APP_EXCEPTION.Raise_Exception;
153: ELSE
154: x_msg_data := FND_MESSAGE.Get;
155: END IF;

Line 167: IF FND_API.To_Boolean(p_called_by_form) THEN

163: 'GR_NO_RECORD_INSERTED');
164: FND_MESSAGE.SET_TOKEN('CODE',
165: l_msg_token,
166: FALSE);
167: IF FND_API.To_Boolean(p_called_by_form) THEN
168: APP_EXCEPTION.Raise_Exception;
169: ELSE
170: x_msg_data := FND_MESSAGE.Get;
171: END IF;

Line 184: IF FND_API.To_Boolean(p_called_by_form) THEN

180: 'GR_UNEXPECTED_ERROR');
181: FND_MESSAGE.SET_TOKEN('TEXT',
182: l_msg_token,
183: FALSE);
184: IF FND_API.To_Boolean(p_called_by_form) THEN
185: APP_EXCEPTION.Raise_Exception;
186: ELSE
187: x_msg_data := FND_MESSAGE.Get;
188: END IF;

Line 269: IF FND_API.To_Boolean(p_commit) THEN

265: END IF;
266:
267: /* Check the commit flag and if set, then commit the work. */
268:
269: IF FND_API.To_Boolean(p_commit) THEN
270: COMMIT WORK;
271: END IF;
272:
273: EXCEPTION

Line 284: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 299: IF FND_API.To_Boolean(p_called_by_form) THEN

295: 'GR_NO_RECORD_INSERTED');
296: FND_MESSAGE.SET_TOKEN('CODE',
297: l_msg_token,
298: FALSE);
299: IF FND_API.To_Boolean(p_called_by_form) THEN
300: APP_EXCEPTION.Raise_Exception;
301: ELSE
302: x_msg_data := FND_MESSAGE.Get;
303: END IF;

Line 315: IF FND_API.To_Boolean(p_called_by_form) THEN

311: 'GR_UNEXPECTED_ERROR');
312: FND_MESSAGE.SET_TOKEN('TEXT',
313: l_msg_token,
314: FALSE);
315: IF FND_API.To_Boolean(p_called_by_form) THEN
316: APP_EXCEPTION.Raise_Exception;
317: ELSE
318: x_msg_data := FND_MESSAGE.Get;
319: END IF;

Line 385: IF FND_API.To_Boolean(p_commit) THEN

381: RAISE No_Data_Found_Error;
382: END IF;
383: CLOSE c_lock_concs_tl;
384:
385: IF FND_API.To_Boolean(p_commit) THEN
386: COMMIT WORK;
387: END IF;
388:
389: EXCEPTION

Line 399: IF FND_API.To_Boolean(p_called_by_form) THEN

395: 'GR_RECORD_NOT_FOUND');
396: FND_MESSAGE.SET_TOKEN('CODE',
397: l_msg_token,
398: FALSE);
399: IF FND_API.To_Boolean(p_called_by_form) THEN
400: APP_EXCEPTION.Raise_Exception;
401: ELSE
402: x_msg_data := FND_MESSAGE.Get;
403: END IF;

Line 411: IF FND_API.To_Boolean(p_called_by_form) THEN

407: x_return_status := 'E';
408: x_oracle_error := APP_EXCEPTION.Get_Code;
409: FND_MESSAGE.SET_NAME('GR',
410: 'GR_ROW_IS_LOCKED');
411: IF FND_API.To_Boolean(p_called_by_form) THEN
412: APP_EXCEPTION.Raise_Exception;
413: ELSE
414: x_msg_data := FND_MESSAGE.Get;
415: END IF;

Line 427: IF FND_API.To_Boolean(p_called_by_form) THEN

423: 'GR_UNEXPECTED_ERROR');
424: FND_MESSAGE.SET_TOKEN('TEXT',
425: l_msg_token,
426: FALSE);
427: IF FND_API.To_Boolean(p_called_by_form) THEN
428: APP_EXCEPTION.Raise_Exception;
429: ELSE
430: x_msg_data := FND_MESSAGE.Get;
431: END IF;

Line 503: IF FND_API.TO_Boolean(p_commit) THEN

499: WHERE rowid = p_rowid;
500:
501: /* Check the commit flag and if set, then commit the work. */
502:
503: IF FND_API.TO_Boolean(p_commit) THEN
504: COMMIT WORK;
505: END IF;
506:
507: EXCEPTION

Line 513: IF FND_API.To_Boolean(p_called_by_form) THEN

509: WHEN Check_Integrity_Error THEN
510: ROLLBACK TO SAVEPOINT Delete_Row;
511: x_return_status := l_return_status;
512: x_oracle_error := l_oracle_error;
513: IF FND_API.To_Boolean(p_called_by_form) THEN
514: APP_EXCEPTION.Raise_Exception;
515: ELSE
516: x_msg_data := FND_MESSAGE.Get;
517: END IF;

Line 528: IF FND_API.To_Boolean(p_called_by_form) THEN

524: 'GR_RECORD_NOT_FOUND');
525: FND_MESSAGE.SET_TOKEN('CODE',
526: l_msg_token,
527: FALSE);
528: IF FND_API.To_Boolean(p_called_by_form) THEN
529: APP_EXCEPTION.Raise_Exception;
530: ELSE
531: x_msg_data := FND_MESSAGE.Get;
532: END IF;

Line 545: IF FND_API.To_Boolean(p_called_by_form) THEN

541: 'GR_UNEXPECTED_ERROR');
542: FND_MESSAGE.SET_TOKEN('TEXT',
543: l_msg_token,
544: FALSE);
545: IF FND_API.To_Boolean(p_called_by_form) THEN
546: APP_EXCEPTION.Raise_Exception;
547: ELSE
548: x_msg_data := FND_MESSAGE.Get;
549: END IF;

Line 589: IF FND_API.To_Boolean(p_commit) THEN

585: DELETE FROM gr_ingredient_conc_details
586: WHERE organization_id = p_organization_id
587: AND inventory_item_id = p_inventory_item_id;
588:
589: IF FND_API.To_Boolean(p_commit) THEN
590: COMMIT WORK;
591: END IF;
592:
593: EXCEPTION

Line 605: IF FND_API.To_Boolean(p_called_by_form) THEN

601: 'GR_UNEXPECTED_ERROR');
602: FND_MESSAGE.SET_TOKEN('TEXT',
603: l_msg_token,
604: FALSE);
605: IF FND_API.To_Boolean(p_called_by_form) THEN
606: APP_EXCEPTION.Raise_Exception;
607: ELSE
608: x_msg_data := FND_MESSAGE.Get;
609: END IF;

Line 722: IF FND_API.To_Boolean(p_called_by_form) THEN

718: 'GR_UNEXPECTED_ERROR');
719: FND_MESSAGE.SET_TOKEN('TEXT',
720: l_msg_data,
721: FALSE);
722: IF FND_API.To_Boolean(p_called_by_form) THEN
723: APP_EXCEPTION.Raise_Exception;
724: ELSE
725: x_msg_data := FND_MESSAGE.Get;
726: END IF;

Line 787: IF FND_API.To_Boolean(p_called_by_form) THEN

783: 'GR_UNEXPECTED_ERROR');
784: FND_MESSAGE.SET_TOKEN('TEXT',
785: l_msg_data,
786: FALSE);
787: IF FND_API.To_Boolean(p_called_by_form) THEN
788: APP_EXCEPTION.Raise_Exception;
789: END IF;
790:
791: END Check_Primary_Key;