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

Line 137: IF FND_API.To_Boolean(l_key_exists) THEN

133: 'F',
134: l_rowid,
135: l_key_exists);
136:
137: IF FND_API.To_Boolean(l_key_exists) THEN
138: RAISE Item_Exists_Error;
139: END IF;
140:
141: INSERT INTO gr_emea

Line 236: IF FND_API.To_Boolean(l_key_exists) THEN

232: 'F',
233: l_rowid,
234: l_key_exists);
235:
236: IF FND_API.To_Boolean(l_key_exists) THEN
237: x_rowid := l_rowid;
238: ELSE
239: RAISE Row_Missing_Error;
240: END IF;

Line 244: IF FND_API.To_Boolean(p_commit) THEN

240: END IF;
241:
242: /* Check the commit flag and if set, then commit the work. */
243:
244: IF FND_API.To_Boolean(p_commit) THEN
245: COMMIT WORK;
246: END IF;
247:
248: EXCEPTION

Line 259: IF FND_API.To_Boolean(p_called_by_form) THEN

255: 'GR_FOREIGN_KEY_ERROR');
256: FND_MESSAGE.SET_TOKEN('TEXT',
257: l_msg_data,
258: FALSE);
259: IF FND_API.To_Boolean(p_called_by_form) THEN
260: APP_EXCEPTION.Raise_Exception;
261: ELSE
262: x_msg_data := FND_MESSAGE.Get;
263: END IF;

Line 274: IF FND_API.To_Boolean(p_called_by_form) THEN

270: 'GR_RECORD_EXISTS');
271: FND_MESSAGE.SET_TOKEN('CODE',
272: p_item_code,
273: FALSE);
274: IF FND_API.To_Boolean(p_called_by_form) THEN
275: APP_EXCEPTION.Raise_Exception;
276: ELSE
277: x_msg_data := FND_MESSAGE.Get;
278: END IF;

Line 289: IF FND_API.To_Boolean(p_called_by_form) THEN

285: 'GR_NO_RECORD_INSERTED');
286: FND_MESSAGE.SET_TOKEN('CODE',
287: p_item_code,
288: FALSE);
289: IF FND_API.To_Boolean(p_called_by_form) THEN
290: APP_EXCEPTION.Raise_Exception;
291: ELSE
292: x_msg_data := FND_MESSAGE.Get;
293: END IF;

Line 305: IF FND_API.To_Boolean(p_called_by_form) THEN

301: 'GR_UNEXPECTED_ERROR');
302: FND_MESSAGE.SET_TOKEN('TEXT',
303: l_msg_data,
304: FALSE);
305: IF FND_API.To_Boolean(p_called_by_form) THEN
306: APP_EXCEPTION.Raise_Exception;
307: ELSE
308: x_msg_data := FND_MESSAGE.Get;
309: END IF;

Line 484: IF FND_API.To_Boolean(p_commit) THEN

480: END IF;
481:
482: /* Check the commit flag and if set, then commit the work. */
483:
484: IF FND_API.To_Boolean(p_commit) THEN
485: COMMIT WORK;
486: END IF;
487:
488: EXCEPTION

Line 499: IF FND_API.To_Boolean(p_called_by_form) THEN

495: 'GR_FOREIGN_KEY_ERROR');
496: FND_MESSAGE.SET_TOKEN('TEXT',
497: l_msg_data,
498: FALSE);
499: IF FND_API.To_Boolean(p_called_by_form) THEN
500: APP_EXCEPTION.Raise_Exception;
501: ELSE
502: x_msg_data := FND_MESSAGE.Get;
503: END IF;

Line 514: IF FND_API.To_Boolean(p_called_by_form) THEN

510: 'GR_NO_RECORD_INSERTED');
511: FND_MESSAGE.SET_TOKEN('CODE',
512: p_item_code,
513: FALSE);
514: IF FND_API.To_Boolean(p_called_by_form) THEN
515: APP_EXCEPTION.Raise_Exception;
516: ELSE
517: x_msg_data := FND_MESSAGE.Get;
518: END IF;

Line 530: IF FND_API.To_Boolean(p_called_by_form) THEN

526: 'GR_UNEXPECTED_ERROR');
527: FND_MESSAGE.SET_TOKEN('TEXT',
528: l_msg_data,
529: FALSE);
530: IF FND_API.To_Boolean(p_called_by_form) THEN
531: APP_EXCEPTION.Raise_Exception;
532: ELSE
533: x_msg_data := FND_MESSAGE.Get;
534: END IF;

Line 632: IF FND_API.To_Boolean(p_commit) THEN

628: RAISE No_Data_Found_Error;
629: END IF;
630: CLOSE c_lock_item;
631:
632: IF FND_API.To_Boolean(p_commit) THEN
633: COMMIT WORK;
634: END IF;
635:
636: EXCEPTION

Line 646: IF FND_API.To_Boolean(p_called_by_form) THEN

642: 'GR_RECORD_NOT_FOUND');
643: FND_MESSAGE.SET_TOKEN('CODE',
644: p_item_code,
645: FALSE);
646: IF FND_API.To_Boolean(p_called_by_form) THEN
647: APP_EXCEPTION.Raise_Exception;
648: ELSE
649: x_msg_data := FND_MESSAGE.Get;
650: END IF;

Line 658: IF FND_API.To_Boolean(p_called_by_form) THEN

654: x_return_status := 'E';
655: x_oracle_error := APP_EXCEPTION.Get_Code;
656: FND_MESSAGE.SET_NAME('GR',
657: 'GR_ROW_IS_LOCKED');
658: IF FND_API.To_Boolean(p_called_by_form) THEN
659: APP_EXCEPTION.Raise_Exception;
660: ELSE
661: x_msg_data := FND_MESSAGE.Get;
662: END IF;

Line 674: IF FND_API.To_Boolean(p_called_by_form) THEN

670: 'GR_UNEXPECTED_ERROR');
671: FND_MESSAGE.SET_TOKEN('TEXT',
672: l_msg_data,
673: FALSE);
674: IF FND_API.To_Boolean(p_called_by_form) THEN
675: APP_EXCEPTION.Raise_Exception;
676: ELSE
677: x_msg_data := FND_MESSAGE.Get;
678: END IF;

Line 813: IF FND_API.TO_Boolean(p_commit) THEN

809: WHERE rowid = p_rowid;
810:
811: /* Check the commit flag and if set, then commit the work. */
812:
813: IF FND_API.TO_Boolean(p_commit) THEN
814: COMMIT WORK;
815: END IF;
816:
817: EXCEPTION

Line 823: IF FND_API.To_Boolean(p_called_by_form) THEN

819: WHEN Check_Integrity_Error THEN
820: ROLLBACK TO SAVEPOINT Delete_Row;
821: x_return_status := l_return_status;
822: x_oracle_error := l_oracle_error;
823: IF FND_API.To_Boolean(p_called_by_form) THEN
824: APP_EXCEPTION.Raise_Exception;
825: ELSE
826: x_msg_data := FND_MESSAGE.Get;
827: END IF;

Line 838: IF FND_API.To_Boolean(p_called_by_form) THEN

834: 'GR_RECORD_NOT_FOUND');
835: FND_MESSAGE.SET_TOKEN('CODE',
836: p_item_code,
837: FALSE);
838: IF FND_API.To_Boolean(p_called_by_form) THEN
839: APP_EXCEPTION.Raise_Exception;
840: ELSE
841: x_msg_data := FND_MESSAGE.Get;
842: END IF;

Line 855: IF FND_API.To_Boolean(p_called_by_form) THEN

851: 'GR_UNEXPECTED_ERROR');
852: FND_MESSAGE.SET_TOKEN('TEXT',
853: l_msg_data,
854: FALSE);
855: IF FND_API.To_Boolean(p_called_by_form) THEN
856: APP_EXCEPTION.Raise_Exception;
857: ELSE
858: x_msg_data := FND_MESSAGE.Get;
859: END IF;

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

932: 'F',
933: l_rowid,
934: l_key_exists);
935:
936: IF NOT FND_API.To_Boolean(l_key_exists) THEN
937: x_return_status := 'E';
938: FND_MESSAGE.SET_NAME('GR',
939: 'GR_RECORD_NOT_FOUND');
940: FND_MESSAGE.SET_TOKEN('CODE',

Line 1067: IF FND_API.To_Boolean(p_called_by_form) THEN

1063: 'GR_UNEXPECTED_ERROR');
1064: FND_MESSAGE.SET_TOKEN('TEXT',
1065: l_msg_data,
1066: FALSE);
1067: IF FND_API.To_Boolean(p_called_by_form) THEN
1068: APP_EXCEPTION.Raise_Exception;
1069: ELSE
1070: x_msg_data := FND_MESSAGE.Get;
1071: END IF;

Line 1086: IF FND_API.To_Boolean(p_called_by_form) THEN

1082: 'GR_UNEXPECTED_ERROR');
1083: FND_MESSAGE.SET_TOKEN('TEXT',
1084: l_msg_data,
1085: FALSE);
1086: IF FND_API.To_Boolean(p_called_by_form) THEN
1087: APP_EXCEPTION.Raise_Exception;
1088: ELSE
1089: x_msg_data := FND_MESSAGE.Get;
1090: END IF;

Line 1143: IF FND_API.To_Boolean(p_called_by_form) THEN

1139: 'GR_UNEXPECTED_ERROR');
1140: FND_MESSAGE.SET_TOKEN('TEXT',
1141: l_msg_data,
1142: FALSE);
1143: IF FND_API.To_Boolean(p_called_by_form) THEN
1144: APP_EXCEPTION.Raise_Exception;
1145: END IF;
1146:
1147: END Check_Primary_Key;