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

Line 73: IF FND_API.To_Boolean(l_key_exists) THEN

69: 'F',
70: l_rowid,
71: l_key_exists);
72:
73: IF FND_API.To_Boolean(l_key_exists) THEN
74: RAISE Item_Exists_Error;
75: END IF;
76:
77: INSERT INTO gr_safety_combinations

Line 114: IF FND_API.To_Boolean(l_key_exists) THEN

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

Line 122: IF FND_API.To_Boolean(p_commit) THEN

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

Line 137: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 152: IF FND_API.To_Boolean(p_called_by_form) THEN

148: 'GR_RECORD_EXISTS');
149: FND_MESSAGE.SET_TOKEN('CODE',
150: p_safety_phrase_code,
151: FALSE);
152: IF FND_API.To_Boolean(p_called_by_form) THEN
153: APP_EXCEPTION.Raise_Exception;
154: ELSE
155: x_msg_data := FND_MESSAGE.Get;
156: 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: p_safety_phrase_code,
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 183: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 267: IF FND_API.To_Boolean(p_commit) THEN

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

Line 282: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 297: IF FND_API.To_Boolean(p_called_by_form) THEN

293: 'GR_NO_RECORD_INSERTED');
294: FND_MESSAGE.SET_TOKEN('CODE',
295: p_safety_phrase_code,
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 313: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 384: IF FND_API.To_Boolean(p_commit) THEN

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

Line 398: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 410: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 426: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 501: IF FND_API.TO_Boolean(p_commit) THEN

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

Line 511: IF FND_API.To_Boolean(p_called_by_form) THEN

507: WHEN Check_Integrity_Error THEN
508: ROLLBACK TO SAVEPOINT Delete_Row;
509: x_return_status := l_return_status;
510: x_oracle_error := l_oracle_error;
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 526: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 543: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 585: IF FND_API.To_Boolean(p_commit) THEN

581:
582: DELETE FROM gr_safety_combinations
583: WHERE safety_phrase_code = p_safety_phrase_code;
584:
585: IF FND_API.To_Boolean(p_commit) THEN
586: COMMIT WORK;
587: END IF;
588:
589: EXCEPTION

Line 601: IF FND_API.To_Boolean(p_called_by_form) THEN

597: 'GR_UNEXPECTED_ERROR');
598: FND_MESSAGE.SET_TOKEN('TEXT',
599: l_msg_token,
600: FALSE);
601: IF FND_API.To_Boolean(p_called_by_form) THEN
602: APP_EXCEPTION.Raise_Exception;
603: ELSE
604: x_msg_data := FND_MESSAGE.Get;
605: END IF;

Line 655: IF NOT FND_API.To_Boolean(l_key_exists) THEN

651: 'F',
652: l_rowid,
653: l_key_exists);
654:
655: IF NOT FND_API.To_Boolean(l_key_exists) THEN
656: FND_MESSAGE.SET_NAME('GR',
657: 'GR_RECORD_NOT_FOUND');
658: FND_MESSAGE.SET_TOKEN('CODE',
659: l_safety_phrase,

Line 674: IF NOT FND_API.To_Boolean(l_key_exists) THEN

670: 'F',
671: l_rowid,
672: l_key_exists);
673:
674: IF NOT FND_API.To_Boolean(l_key_exists) THEN
675: FND_MESSAGE.SET_NAME('GR',
676: 'GR_RECORD_NOT_FOUND');
677: FND_MESSAGE.SET_TOKEN('CODE',
678: l_safety_phrase,

Line 760: IF FND_API.To_Boolean(p_called_by_form) THEN

756: 'GR_UNEXPECTED_ERROR');
757: FND_MESSAGE.SET_TOKEN('TEXT',
758: l_msg_data,
759: FALSE);
760: IF FND_API.To_Boolean(p_called_by_form) THEN
761: APP_EXCEPTION.Raise_Exception;
762: ELSE
763: x_msg_data := FND_MESSAGE.Get;
764: END IF;

Line 815: IF FND_API.To_Boolean(p_called_by_form) THEN

811: 'GR_UNEXPECTED_ERROR');
812: FND_MESSAGE.SET_TOKEN('TEXT',
813: l_msg_data,
814: FALSE);
815: IF FND_API.To_Boolean(p_called_by_form) THEN
816: APP_EXCEPTION.Raise_Exception;
817: END IF;
818:
819: END Check_Primary_Key;