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

Line 65: IF FND_API.To_Boolean(l_key_exists) THEN

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

Line 92: IF FND_API.To_Boolean(l_key_exists) THEN

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

Line 100: IF FND_API.To_Boolean(p_commit) THEN

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

Line 115: IF FND_API.To_Boolean(p_called_by_form) THEN

111: 'GR_FOREIGN_KEY_ERROR');
112: FND_MESSAGE.SET_TOKEN('TEXT',
113: l_msg_data,
114: FALSE);
115: IF FND_API.To_Boolean(p_called_by_form) THEN
116: APP_EXCEPTION.Raise_Exception;
117: ELSE
118: x_msg_data := FND_MESSAGE.Get;
119: 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: l_msg_token,
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_NO_RECORD_INSERTED');
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 164: IF FND_API.To_Boolean(p_called_by_form) THEN

160: 'GR_UNEXPECTED_ERROR');
161: FND_MESSAGE.SET_TOKEN('TEXT',
162: l_msg_token,
163: FALSE);
164: IF FND_API.To_Boolean(p_called_by_form) THEN
165: APP_EXCEPTION.Raise_Exception;
166: ELSE
167: x_msg_data := FND_MESSAGE.Get;
168: END IF;

Line 238: IF FND_API.To_Boolean(p_commit) THEN

234: END IF;
235:
236: /* Check the commit flag and if set, then commit the work. */
237:
238: IF FND_API.To_Boolean(p_commit) THEN
239: COMMIT WORK;
240: END IF;
241:
242: EXCEPTION

Line 253: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 268: IF FND_API.To_Boolean(p_called_by_form) THEN

264: 'GR_NO_RECORD_INSERTED');
265: FND_MESSAGE.SET_TOKEN('CODE',
266: l_msg_token,
267: FALSE);
268: IF FND_API.To_Boolean(p_called_by_form) THEN
269: APP_EXCEPTION.Raise_Exception;
270: ELSE
271: x_msg_data := FND_MESSAGE.Get;
272: END IF;

Line 284: IF FND_API.To_Boolean(p_called_by_form) THEN

280: 'GR_UNEXPECTED_ERROR');
281: FND_MESSAGE.SET_TOKEN('TEXT',
282: l_msg_token,
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 357: IF FND_API.To_Boolean(p_commit) THEN

353: RAISE No_Data_Found_Error;
354: END IF;
355: CLOSE c_lock_safety_cat_b;
356:
357: IF FND_API.To_Boolean(p_commit) THEN
358: COMMIT WORK;
359: END IF;
360:
361: EXCEPTION

Line 371: IF FND_API.To_Boolean(p_called_by_form) THEN

367: 'GR_RECORD_NOT_FOUND');
368: FND_MESSAGE.SET_TOKEN('CODE',
369: l_msg_token,
370: FALSE);
371: IF FND_API.To_Boolean(p_called_by_form) THEN
372: APP_EXCEPTION.Raise_Exception;
373: ELSE
374: x_msg_data := FND_MESSAGE.Get;
375: END IF;

Line 383: IF FND_API.To_Boolean(p_called_by_form) THEN

379: x_return_status := 'E';
380: x_oracle_error := APP_EXCEPTION.Get_Code;
381: FND_MESSAGE.SET_NAME('GR',
382: 'GR_ROW_IS_LOCKED');
383: IF FND_API.To_Boolean(p_called_by_form) THEN
384: APP_EXCEPTION.Raise_Exception;
385: ELSE
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_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 470: IF FND_API.TO_Boolean(p_commit) THEN

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

Line 480: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 495: IF FND_API.To_Boolean(p_called_by_form) THEN

491: 'GR_RECORD_NOT_FOUND');
492: FND_MESSAGE.SET_TOKEN('CODE',
493: l_msg_token,
494: FALSE);
495: IF FND_API.To_Boolean(p_called_by_form) THEN
496: APP_EXCEPTION.Raise_Exception;
497: ELSE
498: x_msg_data := FND_MESSAGE.Get;
499: END IF;

Line 511: IF FND_API.To_Boolean(p_called_by_form) THEN

507: 'GR_UNEXPECTED_ERROR');
508: FND_MESSAGE.SET_TOKEN('TEXT',
509: l_msg_data,
510: FALSE);
511: IF FND_API.To_Boolean(p_called_by_form) THEN
512: APP_EXCEPTION.Raise_Exception;
513: ELSE
514: x_msg_data := FND_MESSAGE.Get;
515: END IF;

Line 675: IF FND_API.To_Boolean(p_called_by_form) THEN

671: FALSE);
672: FND_MESSAGE.SET_TOKEN('TABLES',
673: SUBSTR(l_msg_data,1,LENGTH(l_msg_data)-1),
674: FALSE);
675: IF FND_API.To_Boolean(p_called_by_form) THEN
676: APP_EXCEPTION.Raise_Exception;
677: ELSE
678: x_msg_data := FND_MESSAGE.Get;
679: END IF;

Line 690: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 747: IF FND_API.To_Boolean(p_called_by_form) THEN

743: 'GR_UNEXPECTED_ERROR');
744: FND_MESSAGE.SET_TOKEN('TEXT',
745: l_msg_data,
746: FALSE);
747: IF FND_API.To_Boolean(p_called_by_form) THEN
748: APP_EXCEPTION.Raise_Exception;
749: END IF;
750:
751: END Check_Primary_Key;