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

Line 66: IF FND_API.To_Boolean(l_key_exists) THEN

62: 'F',
63: l_rowid,
64: l_key_exists);
65:
66: IF FND_API.To_Boolean(l_key_exists) THEN
67: RAISE Item_Exists_Error;
68: END IF;
69:
70: INSERT INTO gr_toxic_routes_b

Line 93: IF FND_API.To_Boolean(l_key_exists) THEN

89: 'F',
90: l_rowid,
91: l_key_exists);
92:
93: IF FND_API.To_Boolean(l_key_exists) THEN
94: x_rowid := l_rowid;
95: ELSE
96: RAISE Row_Missing_Error;
97: END IF;

Line 101: IF FND_API.To_Boolean(p_commit) THEN

97: END IF;
98:
99: /* Check the commit flag and if set, then commit the work. */
100:
101: IF FND_API.To_Boolean(p_commit) THEN
102: COMMIT WORK;
103: END IF;
104:
105: EXCEPTION

Line 116: IF FND_API.To_Boolean(p_called_by_form) THEN

112: 'GR_FOREIGN_KEY_ERROR');
113: FND_MESSAGE.SET_TOKEN('TEXT',
114: l_msg_data,
115: FALSE);
116: IF FND_API.To_Boolean(p_called_by_form) THEN
117: APP_EXCEPTION.Raise_Exception;
118: ELSE
119: x_msg_data := FND_MESSAGE.Get;
120: END IF;

Line 131: IF FND_API.To_Boolean(p_called_by_form) THEN

127: 'GR_RECORD_EXISTS');
128: FND_MESSAGE.SET_TOKEN('CODE',
129: p_toxic_route_code,
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 146: IF FND_API.To_Boolean(p_called_by_form) THEN

142: 'GR_NO_RECORD_INSERTED');
143: FND_MESSAGE.SET_TOKEN('CODE',
144: p_toxic_route_code,
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_UNEXPECTED_ERROR');
159: FND_MESSAGE.SET_TOKEN('TEXT',
160: l_msg_data,
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 235: IF FND_API.To_Boolean(p_commit) THEN

231: END IF;
232:
233: /* Check if do the commit */
234:
235: IF FND_API.To_Boolean(p_commit) THEN
236: COMMIT WORK;
237: END IF;
238:
239: EXCEPTION

Line 250: IF FND_API.To_Boolean(p_called_by_form) THEN

246: 'GR_FOREIGN_KEY_ERROR');
247: FND_MESSAGE.SET_TOKEN('TEXT',
248: l_msg_data,
249: FALSE);
250: IF FND_API.To_Boolean(p_called_by_form) THEN
251: APP_EXCEPTION.Raise_Exception;
252: ELSE
253: x_msg_data := FND_MESSAGE.Get;
254: END IF;

Line 265: IF FND_API.To_Boolean(p_called_by_form) THEN

261: 'GR_NO_RECORD_INSERTED');
262: FND_MESSAGE.SET_TOKEN('CODE',
263: p_toxic_route_code,
264: FALSE);
265: IF FND_API.To_Boolean(p_called_by_form) THEN
266: APP_EXCEPTION.Raise_Exception;
267: ELSE
268: x_msg_data := FND_MESSAGE.Get;
269: END IF;

Line 281: IF FND_API.To_Boolean(p_called_by_form) THEN

277: 'GR_UNEXPECTED_ERROR');
278: FND_MESSAGE.SET_TOKEN('TEXT',
279: l_msg_data,
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 350: IF FND_API.To_Boolean(p_commit) THEN

346: IF LockRouteRcd.last_update_date <> p_last_update_date THEN
347: RAISE RECORD_CHANGED_ERROR;
348: END IF;
349:
350: IF FND_API.To_Boolean(p_commit) THEN
351: COMMIT WORK;
352: END IF;
353:
354: EXCEPTION

Line 364: IF FND_API.To_Boolean(p_called_by_form) THEN

360: 'GR_RECORD_NOT_FOUND');
361: FND_MESSAGE.SET_TOKEN('CODE',
362: p_toxic_route_code,
363: FALSE);
364: IF FND_API.To_Boolean(p_called_by_form) THEN
365: APP_EXCEPTION.Raise_Exception;
366: ELSE
367: x_msg_data := FND_MESSAGE.Get;
368: END IF;

Line 374: IF FND_API.To_Boolean(p_called_by_form) THEN

370: ROLLBACK TO SAVEPOINT Lock_Row;
371: X_return_status := 'E';
372: FND_MESSAGE.SET_NAME('FND',
373: 'FORM_RECORD_CHANGED');
374: IF FND_API.To_Boolean(p_called_by_form) THEN
375: APP_EXCEPTION.Raise_Exception;
376: ELSE
377: x_msg_data := FND_MESSAGE.Get;
378: END IF;

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

379: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
380: ROLLBACK TO SAVEPOINT Lock_Row;
381: x_return_status := 'L';
382: x_oracle_error := APP_EXCEPTION.Get_Code;
383: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN
384: FND_MESSAGE.SET_NAME('GR',
385: 'GR_ROW_IS_LOCKED');
386: x_msg_data := FND_MESSAGE.Get;
387: END IF;

Line 399: IF FND_API.To_Boolean(p_called_by_form) THEN

395: 'GR_UNEXPECTED_ERROR');
396: FND_MESSAGE.SET_TOKEN('TEXT',
397: l_msg_data,
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 463: IF FND_API.TO_Boolean(p_commit) THEN

459: WHERE rowid = p_rowid;
460:
461: /* Check the commit flag and if set, then commit the work. */
462:
463: IF FND_API.TO_Boolean(p_commit) THEN
464: COMMIT WORK;
465: END IF;
466:
467: EXCEPTION

Line 473: IF FND_API.To_Boolean(p_called_by_form) THEN

469: WHEN Check_Integrity_Error THEN
470: ROLLBACK TO SAVEPOINT Delete_Row;
471: x_return_status := l_return_status;
472: x_oracle_error := l_oracle_error;
473: IF FND_API.To_Boolean(p_called_by_form) THEN
474: APP_EXCEPTION.Raise_Exception;
475: ELSE
476: x_msg_data := FND_MESSAGE.Get;
477: END IF;

Line 488: IF FND_API.To_Boolean(p_called_by_form) THEN

484: 'GR_RECORD_NOT_FOUND');
485: FND_MESSAGE.SET_TOKEN('CODE',
486: p_toxic_route_code,
487: FALSE);
488: IF FND_API.To_Boolean(p_called_by_form) THEN
489: APP_EXCEPTION.Raise_Exception;
490: ELSE
491: x_msg_data := FND_MESSAGE.Get;
492: END IF;

Line 505: IF FND_API.To_Boolean(p_called_by_form) THEN

501: 'GR_UNEXPECTED_ERROR');
502: FND_MESSAGE.SET_TOKEN('TEXT',
503: l_msg_data,
504: FALSE);
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 628: IF FND_API.To_Boolean(p_called_by_form) THEN

624: FALSE);
625: FND_MESSAGE.SET_TOKEN('TABLES',
626: l_msg_data,
627: FALSE);
628: IF FND_API.To_Boolean(p_called_by_form) THEN
629: APP_EXCEPTION.Raise_Exception;
630: ELSE
631: x_msg_data := FND_MESSAGE.Get;
632: END IF;

Line 643: IF FND_API.To_Boolean(p_called_by_form) THEN

639: 'GR_UNEXPECTED_ERROR');
640: FND_MESSAGE.SET_TOKEN('TEXT',
641: l_msg_data,
642: FALSE);
643: IF FND_API.To_Boolean(p_called_by_form) THEN
644: APP_EXCEPTION.Raise_Exception;
645: ELSE
646: x_msg_data := FND_MESSAGE.Get;
647: END IF;

Line 689: IF FND_API.To_Boolean(p_called_by_form) THEN

685: 'GR_UNEXPECTED_ERROR');
686: FND_MESSAGE.SET_TOKEN('TEXT',
687: l_msg_data,
688: FALSE);
689: IF FND_API.To_Boolean(p_called_by_form) THEN
690: APP_EXCEPTION.Raise_Exception;
691: END IF;
692:
693: END Check_Primary_Key;