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

Line 69: IF FND_API.To_Boolean(l_key_exists) THEN

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

Line 102: IF FND_API.To_Boolean(l_key_exists) THEN

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

Line 110: IF FND_API.To_Boolean(p_commit) THEN

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

Line 125: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 140: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 156: IF FND_API.To_Boolean(p_called_by_form) THEN

152: FND_MESSAGE.SET_TOKEN('CODE',
153: p_european_index_number,
154: FALSE);
155: x_msg_data := FND_MESSAGE.Get;
156: IF FND_API.To_Boolean(p_called_by_form) THEN
157: APP_EXCEPTION.Raise_Exception;
158: ELSE
159: x_msg_data := FND_MESSAGE.Get;
160: END IF;

Line 172: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 251: IF FND_API.To_Boolean(p_commit) THEN

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

Line 266: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 281: IF FND_API.To_Boolean(p_called_by_form) THEN

277: 'GR_NO_RECORD_INSERTED');
278: FND_MESSAGE.SET_TOKEN('CODE',
279: p_european_index_number,
280: FALSE);
281: IF FND_API.To_Boolean(p_called_by_form) THEN
282: APP_EXCEPTION.Raise_Exception;
283: ELSE
284: x_msg_data := FND_MESSAGE.Get;
285: END IF;

Line 297: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 370: IF FND_API.To_Boolean(p_commit) THEN

366: IF LockEinRcd.last_update_date <> p_last_update_date THEN
367: RAISE RECORD_CHANGED_ERROR;
368: END IF;
369:
370: IF FND_API.To_Boolean(p_commit) THEN
371: COMMIT WORK;
372: END IF;
373:
374: EXCEPTION

Line 384: IF FND_API.To_Boolean(p_called_by_form) THEN

380: 'GR_RECORD_NOT_FOUND');
381: FND_MESSAGE.SET_TOKEN('CODE',
382: p_european_index_number,
383: FALSE);
384: IF FND_API.To_Boolean(p_called_by_form) THEN
385: APP_EXCEPTION.Raise_Exception;
386: ELSE
387: x_msg_data := FND_MESSAGE.Get;
388: END IF;

Line 394: IF FND_API.To_Boolean(p_called_by_form) THEN

390: ROLLBACK TO SAVEPOINT Lock_Row;
391: X_return_status := 'E';
392: FND_MESSAGE.SET_NAME('FND',
393: 'FORM_RECORD_CHANGED');
394: IF FND_API.To_Boolean(p_called_by_form) THEN
395: APP_EXCEPTION.Raise_Exception;
396: ELSE
397: x_msg_data := FND_MESSAGE.Get;
398: END IF;

Line 403: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN

399: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
400: ROLLBACK TO SAVEPOINT Lock_Row;
401: x_return_status := 'L';
402: x_oracle_error := APP_EXCEPTION.Get_Code;
403: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN
404: FND_MESSAGE.SET_NAME('GR',
405: 'GR_ROW_IS_LOCKED');
406: x_msg_data := FND_MESSAGE.Get;
407: END IF;

Line 418: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 477: IF FND_API.TO_Boolean(p_commit) THEN

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

Line 487: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 502: IF FND_API.To_Boolean(p_called_by_form) THEN

498: 'GR_RECORD_NOT_FOUND');
499: FND_MESSAGE.SET_TOKEN('CODE',
500: p_european_index_number,
501: FALSE);
502: IF FND_API.To_Boolean(p_called_by_form) THEN
503: APP_EXCEPTION.Raise_Exception;
504: ELSE
505: x_msg_data := FND_MESSAGE.Get;
506: END IF;

Line 518: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 637: IF FND_API.To_Boolean(p_called_by_form) THEN

633: FALSE);
634: FND_MESSAGE.SET_TOKEN('TABLES',
635: l_msg_data,
636: FALSE);
637: IF FND_API.To_Boolean(p_called_by_form) THEN
638: APP_EXCEPTION.Raise_Exception;
639: ELSE
640: x_msg_data := FND_MESSAGE.Get;
641: END IF;

Line 652: IF FND_API.To_Boolean(p_called_by_form) THEN

648: 'GR_UNEXPECTED_ERROR');
649: FND_MESSAGE.SET_TOKEN('TEXT',
650: l_msg_data,
651: FALSE);
652: IF FND_API.To_Boolean(p_called_by_form) THEN
653: APP_EXCEPTION.Raise_Exception;
654: ELSE
655: x_msg_data := FND_MESSAGE.Get;
656: END IF;

Line 699: IF FND_API.To_Boolean(p_called_by_form) THEN

695: 'GR_UNEXPECTED_ERROR');
696: FND_MESSAGE.SET_TOKEN('TEXT',
697: l_msg_data,
698: FALSE);
699: IF FND_API.To_Boolean(p_called_by_form) THEN
700: APP_EXCEPTION.Raise_Exception;
701: END IF;
702:
703: END Check_Primary_Key;