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

Line 142: IF FND_API.To_Boolean(l_key_exists) THEN

138: 'F',
139: l_rowid,
140: l_key_exists);
141:
142: IF FND_API.To_Boolean(l_key_exists) THEN
143: RAISE Label_Exists_Error;
144: END IF;
145:
146: INSERT INTO gr_dispatch_histories

Line 247: IF FND_API.To_Boolean(l_key_exists) THEN

243: 'F',
244: l_rowid,
245: l_key_exists);
246:
247: IF FND_API.To_Boolean(l_key_exists) THEN
248: x_rowid := l_rowid;
249: ELSE
250: RAISE Row_Missing_Error;
251: END IF;

Line 255: IF FND_API.To_Boolean(p_commit) THEN

251: END IF;
252:
253: /* Check the commit flag and if set, then commit the work. */
254:
255: IF FND_API.To_Boolean(p_commit) THEN
256: COMMIT WORK;
257: END IF;
258:
259: EXCEPTION

Line 270: IF FND_API.To_Boolean(p_called_by_form) THEN

266: 'GR_FOREIGN_KEY_ERROR');
267: FND_MESSAGE.SET_TOKEN('TEXT',
268: l_msg_data,
269: FALSE);
270: IF FND_API.To_Boolean(p_called_by_form) THEN
271: APP_EXCEPTION.Raise_Exception;
272: ELSE
273: x_msg_data := FND_MESSAGE.Get;
274: END IF;

Line 285: IF FND_API.To_Boolean(p_called_by_form) THEN

281: 'GR_RECORD_EXISTS');
282: FND_MESSAGE.SET_TOKEN('CODE',
283: p_document_code,
284: FALSE);
285: IF FND_API.To_Boolean(p_called_by_form) THEN
286: APP_EXCEPTION.Raise_Exception;
287: ELSE
288: x_msg_data := FND_MESSAGE.Get;
289: END IF;

Line 300: IF FND_API.To_Boolean(p_called_by_form) THEN

296: 'GR_NO_RECORD_INSERTED');
297: FND_MESSAGE.SET_TOKEN('CODE',
298: p_document_code,
299: FALSE);
300: IF FND_API.To_Boolean(p_called_by_form) THEN
301: APP_EXCEPTION.Raise_Exception;
302: ELSE
303: x_msg_data := FND_MESSAGE.Get;
304: END IF;

Line 316: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 499: IF FND_API.To_Boolean(p_commit) THEN

495: END IF;
496:
497: /* Check the commit flag and if set, then commit the work. */
498:
499: IF FND_API.To_Boolean(p_commit) THEN
500: COMMIT WORK;
501: END IF;
502:
503: EXCEPTION

Line 514: IF FND_API.To_Boolean(p_called_by_form) THEN

510: 'GR_FOREIGN_KEY_ERROR');
511: FND_MESSAGE.SET_TOKEN('TEXT',
512: l_msg_data,
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 529: IF FND_API.To_Boolean(p_called_by_form) THEN

525: 'GR_NO_RECORD_INSERTED');
526: FND_MESSAGE.SET_TOKEN('CODE',
527: p_document_code,
528: FALSE);
529: IF FND_API.To_Boolean(p_called_by_form) THEN
530: APP_EXCEPTION.Raise_Exception;
531: ELSE
532: x_msg_data := FND_MESSAGE.Get;
533: END IF;

Line 545: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 649: IF FND_API.To_Boolean(p_commit) THEN

645: RAISE No_Data_Found_Error;
646: END IF;
647: CLOSE c_lock_dispatch;
648:
649: IF FND_API.To_Boolean(p_commit) THEN
650: COMMIT WORK;
651: END IF;
652:
653: EXCEPTION

Line 663: IF FND_API.To_Boolean(p_called_by_form) THEN

659: 'GR_RECORD_NOT_FOUND');
660: FND_MESSAGE.SET_TOKEN('CODE',
661: p_document_code,
662: FALSE);
663: IF FND_API.To_Boolean(p_called_by_form) THEN
664: APP_EXCEPTION.Raise_Exception;
665: ELSE
666: x_msg_data := FND_MESSAGE.Get;
667: END IF;

Line 675: IF FND_API.To_Boolean(p_called_by_form) THEN

671: x_return_status := 'E';
672: x_oracle_error := APP_EXCEPTION.Get_Code;
673: FND_MESSAGE.SET_NAME('GR',
674: 'GR_ROW_IS_LOCKED');
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 691: IF FND_API.To_Boolean(p_called_by_form) THEN

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

Line 832: IF FND_API.TO_Boolean(p_commit) THEN

828: WHERE rowid = p_rowid;
829:
830: /* Check the commit flag and if set, then commit the work. */
831:
832: IF FND_API.TO_Boolean(p_commit) THEN
833: COMMIT WORK;
834: END IF;
835:
836: EXCEPTION

Line 842: IF FND_API.To_Boolean(p_called_by_form) THEN

838: WHEN Check_Integrity_Error THEN
839: ROLLBACK TO SAVEPOINT Delete_Row;
840: x_return_status := l_return_status;
841: x_oracle_error := l_oracle_error;
842: IF FND_API.To_Boolean(p_called_by_form) THEN
843: APP_EXCEPTION.Raise_Exception;
844: ELSE
845: x_msg_data := FND_MESSAGE.Get;
846: END IF;

Line 857: IF FND_API.To_Boolean(p_called_by_form) THEN

853: 'GR_RECORD_NOT_FOUND');
854: FND_MESSAGE.SET_TOKEN('CODE',
855: p_document_code,
856: FALSE);
857: IF FND_API.To_Boolean(p_called_by_form) THEN
858: APP_EXCEPTION.Raise_Exception;
859: ELSE
860: x_msg_data := FND_MESSAGE.Get;
861: END IF;

Line 874: IF FND_API.To_Boolean(p_called_by_form) THEN

870: 'GR_UNEXPECTED_ERROR');
871: FND_MESSAGE.SET_TOKEN('TEXT',
872: l_msg_data,
873: FALSE);
874: IF FND_API.To_Boolean(p_called_by_form) THEN
875: APP_EXCEPTION.Raise_Exception;
876: ELSE
877: x_msg_data := FND_MESSAGE.Get;
878: END IF;

Line 968: IF FND_API.To_Boolean(p_commit) THEN

964: AND document_code = p_document_code;
965: END IF;
966: END IF;
967:
968: IF FND_API.To_Boolean(p_commit) THEN
969: COMMIT WORK;
970: END IF;
971:
972: EXCEPTION

Line 982: IF FND_API.To_Boolean(p_called_by_form) THEN

978: 'GR_NULL_VALUE');
979: FND_MESSAGE.SET_TOKEN('CODE',
980: l_msg_token,
981: FALSE);
982: IF FND_API.To_Boolean(p_called_by_form) THEN
983: APP_EXCEPTION.Raise_Exception;
984: ELSE
985: x_msg_data := FND_MESSAGE.Get;
986: END IF;

Line 998: IF FND_API.To_Boolean(p_called_by_form) THEN

994: 'GR_UNEXPECTED_ERROR');
995: FND_MESSAGE.SET_TOKEN('TEXT',
996: l_msg_token,
997: FALSE);
998: IF FND_API.To_Boolean(p_called_by_form) THEN
999: APP_EXCEPTION.Raise_Exception;
1000: ELSE
1001: x_msg_data := FND_MESSAGE.Get;
1002: END IF;

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

1078: 'F',
1079: l_rowid,
1080: l_key_exists);
1081:
1082: IF NOT FND_API.To_Boolean(l_key_exists) THEN
1083: x_return_status := 'E';
1084: FND_MESSAGE.SET_NAME('GR',
1085: 'GR_RECORD_NOT_FOUND');
1086: FND_MESSAGE.SET_TOKEN('CODE',

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

1097: 'F',
1098: l_rowid,
1099: l_key_exists);
1100:
1101: IF NOT FND_API.To_Boolean(l_key_exists) THEN
1102: x_return_status := 'E';
1103: FND_MESSAGE.SET_NAME('GR',
1104: 'GR_RECORD_NOT_FOUND');
1105: FND_MESSAGE.SET_TOKEN('CODE',

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

1116: 'F',
1117: l_rowid,
1118: l_key_exists);
1119:
1120: IF NOT FND_API.To_Boolean(l_key_exists) THEN
1121: x_return_status := 'E';
1122: FND_MESSAGE.SET_NAME('GR',
1123: 'GR_RECORD_NOT_FOUND');
1124: FND_MESSAGE.SET_TOKEN('CODE',

Line 1238: IF FND_API.To_Boolean(p_called_by_form) THEN

1234: 'GR_UNEXPECTED_ERROR');
1235: FND_MESSAGE.SET_TOKEN('TEXT',
1236: l_msg_data,
1237: FALSE);
1238: IF FND_API.To_Boolean(p_called_by_form) THEN
1239: APP_EXCEPTION.Raise_Exception;
1240: ELSE
1241: x_msg_data := FND_MESSAGE.Get;
1242: END IF;

Line 1306: IF FND_API.To_Boolean(p_called_by_form) THEN

1302: 'GR_UNEXPECTED_ERROR');
1303: FND_MESSAGE.SET_TOKEN('TEXT',
1304: l_msg_data,
1305: FALSE);
1306: IF FND_API.To_Boolean(p_called_by_form) THEN
1307: APP_EXCEPTION.Raise_Exception;
1308: END IF;
1309:
1310: END Check_Primary_Key;