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

Line 70: IF FND_API.To_Boolean(l_key_exists) THEN

66: 'F',
67: l_rowid,
68: l_key_exists);
69:
70: IF FND_API.To_Boolean(l_key_exists) THEN
71: RAISE Item_Exists_Error;
72: END IF;
73:
74: INSERT INTO gr_item_groups_b

Line 101: IF FND_API.To_Boolean(l_key_exists) THEN

97: 'F',
98: l_rowid,
99: l_key_exists);
100:
101: IF FND_API.To_Boolean(l_key_exists) THEN
102: x_rowid := l_rowid;
103: ELSE
104: RAISE Row_Missing_Error;
105: END IF;

Line 109: IF FND_API.To_Boolean(p_commit) THEN

105: END IF;
106:
107: /* Check the commit flag and if set, then commit the work. */
108:
109: IF FND_API.To_Boolean(p_commit) THEN
110: COMMIT WORK;
111: END IF;
112:
113: EXCEPTION

Line 125: IF FND_API.To_Boolean(p_called_by_form) THEN

121: FND_MESSAGE.SET_TOKEN('TEXT',
122: l_msg_data,
123: FALSE);
124: x_msg_data := FND_MESSAGE.Get;
125: IF FND_API.To_Boolean(p_called_by_form) THEN
126: APP_EXCEPTION.Raise_Exception;
127: END IF;
128:
129: WHEN Item_Exists_Error THEN

Line 138: IF FND_API.To_Boolean(p_called_by_form) THEN

134: 'GR_RECORD_EXISTS');
135: FND_MESSAGE.SET_TOKEN('CODE',
136: p_item_group_code,
137: FALSE);
138: IF FND_API.To_Boolean(p_called_by_form) THEN
139: APP_EXCEPTION.Raise_Exception;
140: ELSE
141: x_msg_data := FND_MESSAGE.Get;
142: END IF;

Line 153: IF FND_API.To_Boolean(p_called_by_form) THEN

149: 'GR_NO_RECORD_INSERTED');
150: FND_MESSAGE.SET_TOKEN('CODE',
151: p_item_group_code,
152: FALSE);
153: IF FND_API.To_Boolean(p_called_by_form) THEN
154: APP_EXCEPTION.Raise_Exception;
155: ELSE
156: x_msg_data := FND_MESSAGE.Get;
157: END IF;

Line 169: IF FND_API.To_Boolean(p_called_by_form) THEN

165: 'GR_UNEXPECTED_ERROR');
166: FND_MESSAGE.SET_TOKEN('TEXT',
167: l_msg_data,
168: FALSE);
169: IF FND_API.To_Boolean(p_called_by_form) THEN
170: APP_EXCEPTION.Raise_Exception;
171: ELSE
172: x_msg_data := FND_MESSAGE.Get;
173: END IF;

Line 248: IF FND_API.To_Boolean(p_commit) THEN

244: END IF;
245:
246: /* Check if do the commit */
247:
248: IF FND_API.To_Boolean(p_commit) THEN
249: COMMIT WORK;
250: END IF;
251:
252: EXCEPTION

Line 263: IF FND_API.To_Boolean(p_called_by_form) THEN

259: 'GR_FOREIGN_KEY_ERROR');
260: FND_MESSAGE.SET_TOKEN('TEXT',
261: l_msg_data,
262: FALSE);
263: IF FND_API.To_Boolean(p_called_by_form) THEN
264: APP_EXCEPTION.Raise_Exception;
265: ELSE
266: x_msg_data := FND_MESSAGE.Get;
267: END IF;

Line 278: IF FND_API.To_Boolean(p_called_by_form) THEN

274: 'GR_NO_RECORD_INSERTED');
275: FND_MESSAGE.SET_TOKEN('CODE',
276: p_item_group_code,
277: FALSE);
278: IF FND_API.To_Boolean(p_called_by_form) THEN
279: APP_EXCEPTION.Raise_Exception;
280: ELSE
281: x_msg_data := FND_MESSAGE.Get;
282: END IF;

Line 294: IF FND_API.To_Boolean(p_called_by_form) THEN

290: 'GR_UNEXPECTED_ERROR');
291: FND_MESSAGE.SET_TOKEN('TEXT',
292: l_msg_data,
293: FALSE);
294: IF FND_API.To_Boolean(p_called_by_form) THEN
295: APP_EXCEPTION.Raise_Exception;
296: ELSE
297: x_msg_data := FND_MESSAGE.Get;
298: END IF;

Line 363: IF FND_API.To_Boolean(p_commit) THEN

359: RAISE No_Data_Found_Error;
360: END IF;
361: CLOSE c_lock_item_groups;
362:
363: IF FND_API.To_Boolean(p_commit) THEN
364: COMMIT WORK;
365: END IF;
366:
367: EXCEPTION

Line 377: IF FND_API.To_Boolean(p_called_by_form) THEN

373: 'GR_RECORD_NOT_FOUND');
374: FND_MESSAGE.SET_TOKEN('CODE',
375: p_item_group_code,
376: FALSE);
377: IF FND_API.To_Boolean(p_called_by_form) THEN
378: APP_EXCEPTION.Raise_Exception;
379: ELSE
380: x_msg_data := FND_MESSAGE.Get;
381: END IF;

Line 389: IF FND_API.To_Boolean(p_called_by_form) THEN

385: x_return_status := 'E';
386: x_oracle_error := APP_EXCEPTION.Get_Code;
387: FND_MESSAGE.SET_NAME('GR',
388: 'GR_ROW_IS_LOCKED');
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 405: IF FND_API.To_Boolean(p_called_by_form) THEN

401: 'GR_UNEXPECTED_ERROR');
402: FND_MESSAGE.SET_TOKEN('TEXT',
403: l_msg_data,
404: FALSE);
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 473: IF FND_API.TO_Boolean(p_commit) THEN

469: WHERE rowid = p_rowid;
470:
471: /* Check the commit flag and if set, then commit the work. */
472:
473: IF FND_API.TO_Boolean(p_commit) THEN
474: COMMIT WORK;
475: END IF;
476:
477: EXCEPTION

Line 483: IF FND_API.To_Boolean(p_called_by_form) THEN

479: WHEN Check_Integrity_Error THEN
480: ROLLBACK TO SAVEPOINT Delete_Row;
481: x_return_status := l_return_status;
482: x_oracle_error := l_oracle_error;
483: IF FND_API.To_Boolean(p_called_by_form) THEN
484: APP_EXCEPTION.Raise_Exception;
485: ELSE
486: x_msg_data := FND_MESSAGE.Get;
487: END IF;

Line 498: IF FND_API.To_Boolean(p_called_by_form) THEN

494: 'GR_RECORD_NOT_FOUND');
495: FND_MESSAGE.SET_TOKEN('CODE',
496: p_item_group_code,
497: FALSE);
498: IF FND_API.To_Boolean(p_called_by_form) THEN
499: APP_EXCEPTION.Raise_Exception;
500: ELSE
501: x_msg_data := FND_MESSAGE.Get;
502: END IF;

Line 515: IF FND_API.To_Boolean(p_called_by_form) THEN

511: 'GR_UNEXPECTED_ERROR');
512: FND_MESSAGE.SET_TOKEN('TEXT',
513: l_msg_data,
514: FALSE);
515: IF FND_API.To_Boolean(p_called_by_form) THEN
516: APP_EXCEPTION.Raise_Exception;
517: ELSE
518: x_msg_data := FND_MESSAGE.Get;
519: END IF;

Line 633: IF FND_API.To_Boolean(p_called_by_form) THEN

629: FALSE);
630: FND_MESSAGE.SET_TOKEN('TABLES',
631: l_msg_data,
632: FALSE);
633: IF FND_API.To_Boolean(p_called_by_form) THEN
634: APP_EXCEPTION.Raise_Exception;
635: ELSE
636: x_msg_data := FND_MESSAGE.Get;
637: END IF;

Line 648: IF FND_API.To_Boolean(p_called_by_form) THEN

644: 'GR_UNEXPECTED_ERROR');
645: FND_MESSAGE.SET_TOKEN('TEXT',
646: l_msg_data,
647: FALSE);
648: IF FND_API.To_Boolean(p_called_by_form) THEN
649: APP_EXCEPTION.Raise_Exception;
650: ELSE
651: x_msg_data := FND_MESSAGE.Get;
652: END IF;

Line 695: IF FND_API.To_Boolean(p_called_by_form) THEN

691: 'GR_UNEXPECTED_ERROR');
692: FND_MESSAGE.SET_TOKEN('TEXT',
693: l_msg_data,
694: FALSE);
695: IF FND_API.To_Boolean(p_called_by_form) THEN
696: APP_EXCEPTION.Raise_Exception;
697: END IF;
698:
699: END Check_Primary_Key;