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 APP_EXCEPTION

Line 271: APP_EXCEPTION.Raise_Exception;

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;
275:

Line 279: x_oracle_error := APP_EXCEPTION.Get_Code;

275:
276: WHEN Label_Exists_Error THEN
277: ROLLBACK TO SAVEPOINT Insert_Row;
278: x_return_status := 'E';
279: x_oracle_error := APP_EXCEPTION.Get_Code;
280: FND_MESSAGE.SET_NAME('GR',
281: 'GR_RECORD_EXISTS');
282: FND_MESSAGE.SET_TOKEN('CODE',
283: p_document_code,

Line 286: APP_EXCEPTION.Raise_Exception;

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;
290:

Line 294: x_oracle_error := APP_EXCEPTION.Get_Code;

290:
291: WHEN Row_Missing_Error THEN
292: ROLLBACK TO SAVEPOINT Insert_Row;
293: x_return_status := 'E';
294: x_oracle_error := APP_EXCEPTION.Get_Code;
295: FND_MESSAGE.SET_NAME('GR',
296: 'GR_NO_RECORD_INSERTED');
297: FND_MESSAGE.SET_TOKEN('CODE',
298: p_document_code,

Line 301: APP_EXCEPTION.Raise_Exception;

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;
305:

Line 309: x_oracle_error := APP_EXCEPTION.Get_Code;

305:
306: WHEN OTHERS THEN
307: ROLLBACK TO SAVEPOINT Insert_Row;
308: x_return_status := 'U';
309: x_oracle_error := APP_EXCEPTION.Get_Code;
310: l_msg_data := APP_EXCEPTION.Get_Text;
311: FND_MESSAGE.SET_NAME('GR',
312: 'GR_UNEXPECTED_ERROR');
313: FND_MESSAGE.SET_TOKEN('TEXT',

Line 310: l_msg_data := APP_EXCEPTION.Get_Text;

306: WHEN OTHERS THEN
307: ROLLBACK TO SAVEPOINT Insert_Row;
308: x_return_status := 'U';
309: x_oracle_error := APP_EXCEPTION.Get_Code;
310: l_msg_data := APP_EXCEPTION.Get_Text;
311: FND_MESSAGE.SET_NAME('GR',
312: 'GR_UNEXPECTED_ERROR');
313: FND_MESSAGE.SET_TOKEN('TEXT',
314: l_msg_data,

Line 317: APP_EXCEPTION.Raise_Exception;

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;
321:

Line 515: APP_EXCEPTION.Raise_Exception;

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;
519:

Line 523: x_oracle_error := APP_EXCEPTION.Get_Code;

519:
520: WHEN Row_Missing_Error THEN
521: ROLLBACK TO SAVEPOINT Update_Row;
522: x_return_status := 'E';
523: x_oracle_error := APP_EXCEPTION.Get_Code;
524: FND_MESSAGE.SET_NAME('GR',
525: 'GR_NO_RECORD_INSERTED');
526: FND_MESSAGE.SET_TOKEN('CODE',
527: p_document_code,

Line 530: APP_EXCEPTION.Raise_Exception;

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;
534:

Line 538: x_oracle_error := APP_EXCEPTION.Get_Code;

534:
535: WHEN OTHERS THEN
536: ROLLBACK TO SAVEPOINT Update_Row;
537: x_return_status := 'U';
538: x_oracle_error := APP_EXCEPTION.Get_Code;
539: l_msg_data := APP_EXCEPTION.Get_Text;
540: FND_MESSAGE.SET_NAME('GR',
541: 'GR_UNEXPECTED_ERROR');
542: FND_MESSAGE.SET_TOKEN('TEXT',

Line 539: l_msg_data := APP_EXCEPTION.Get_Text;

535: WHEN OTHERS THEN
536: ROLLBACK TO SAVEPOINT Update_Row;
537: x_return_status := 'U';
538: x_oracle_error := APP_EXCEPTION.Get_Code;
539: l_msg_data := APP_EXCEPTION.Get_Text;
540: FND_MESSAGE.SET_NAME('GR',
541: 'GR_UNEXPECTED_ERROR');
542: FND_MESSAGE.SET_TOKEN('TEXT',
543: l_msg_data,

Line 546: APP_EXCEPTION.Raise_Exception;

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;
550:

Line 664: APP_EXCEPTION.Raise_Exception;

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;
668:

Line 672: x_oracle_error := APP_EXCEPTION.Get_Code;

668:
669: WHEN Row_Already_Locked_Error THEN
670: ROLLBACK TO SAVEPOINT Lock_Row;
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;

Line 676: APP_EXCEPTION.Raise_Exception;

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;
680:

Line 684: x_oracle_error := APP_EXCEPTION.Get_Code;

680:
681: WHEN OTHERS THEN
682: ROLLBACK TO SAVEPOINT Lock_Row;
683: x_return_status := 'U';
684: x_oracle_error := APP_EXCEPTION.Get_Code;
685: l_msg_data := APP_EXCEPTION.Get_Text;
686: FND_MESSAGE.SET_NAME('GR',
687: 'GR_UNEXPECTED_ERROR');
688: FND_MESSAGE.SET_TOKEN('TEXT',

Line 685: l_msg_data := APP_EXCEPTION.Get_Text;

681: WHEN OTHERS THEN
682: ROLLBACK TO SAVEPOINT Lock_Row;
683: x_return_status := 'U';
684: x_oracle_error := APP_EXCEPTION.Get_Code;
685: l_msg_data := APP_EXCEPTION.Get_Text;
686: FND_MESSAGE.SET_NAME('GR',
687: 'GR_UNEXPECTED_ERROR');
688: FND_MESSAGE.SET_TOKEN('TEXT',
689: l_msg_data,

Line 692: APP_EXCEPTION.Raise_Exception;

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;
696:

Line 843: APP_EXCEPTION.Raise_Exception;

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;
847:

Line 851: x_oracle_error := APP_EXCEPTION.Get_Code;

847:
848: WHEN Row_Missing_Error THEN
849: ROLLBACK TO SAVEPOINT Delete_Row;
850: x_return_status := 'E';
851: x_oracle_error := APP_EXCEPTION.Get_Code;
852: FND_MESSAGE.SET_NAME('GR',
853: 'GR_RECORD_NOT_FOUND');
854: FND_MESSAGE.SET_TOKEN('CODE',
855: p_document_code,

Line 858: APP_EXCEPTION.Raise_Exception;

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;
862:

Line 866: x_oracle_error := APP_EXCEPTION.Get_Code;

862:
863: WHEN OTHERS THEN
864: ROLLBACK TO SAVEPOINT Delete_Row;
865: x_return_status := 'U';
866: x_oracle_error := APP_EXCEPTION.Get_Code;
867: l_msg_data := APP_EXCEPTION.Get_Text;
868: l_msg_data := APP_EXCEPTION.Get_Text;
869: FND_MESSAGE.SET_NAME('GR',
870: 'GR_UNEXPECTED_ERROR');

Line 867: l_msg_data := APP_EXCEPTION.Get_Text;

863: WHEN OTHERS THEN
864: ROLLBACK TO SAVEPOINT Delete_Row;
865: x_return_status := 'U';
866: x_oracle_error := APP_EXCEPTION.Get_Code;
867: l_msg_data := APP_EXCEPTION.Get_Text;
868: l_msg_data := APP_EXCEPTION.Get_Text;
869: FND_MESSAGE.SET_NAME('GR',
870: 'GR_UNEXPECTED_ERROR');
871: FND_MESSAGE.SET_TOKEN('TEXT',

Line 868: l_msg_data := APP_EXCEPTION.Get_Text;

864: ROLLBACK TO SAVEPOINT Delete_Row;
865: x_return_status := 'U';
866: x_oracle_error := APP_EXCEPTION.Get_Code;
867: l_msg_data := APP_EXCEPTION.Get_Text;
868: l_msg_data := APP_EXCEPTION.Get_Text;
869: FND_MESSAGE.SET_NAME('GR',
870: 'GR_UNEXPECTED_ERROR');
871: FND_MESSAGE.SET_TOKEN('TEXT',
872: l_msg_data,

Line 875: APP_EXCEPTION.Raise_Exception;

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;
879:

Line 976: x_oracle_error := APP_EXCEPTION.Get_Code;

972: EXCEPTION
973:
974: WHEN Null_Delete_Option_Error THEN
975: x_return_status := 'E';
976: x_oracle_error := APP_EXCEPTION.Get_Code;
977: FND_MESSAGE.SET_NAME('GR',
978: 'GR_NULL_VALUE');
979: FND_MESSAGE.SET_TOKEN('CODE',
980: l_msg_token,

Line 983: APP_EXCEPTION.Raise_Exception;

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;
987:

Line 991: x_oracle_error := APP_EXCEPTION.Get_Code;

987:
988: WHEN OTHERS THEN
989: ROLLBACK TO SAVEPOINT Delete_Rows;
990: x_return_status := 'U';
991: x_oracle_error := APP_EXCEPTION.Get_Code;
992: l_msg_data := APP_EXCEPTION.Get_Text;
993: FND_MESSAGE.SET_NAME('GR',
994: 'GR_UNEXPECTED_ERROR');
995: FND_MESSAGE.SET_TOKEN('TEXT',

Line 992: l_msg_data := APP_EXCEPTION.Get_Text;

988: WHEN OTHERS THEN
989: ROLLBACK TO SAVEPOINT Delete_Rows;
990: x_return_status := 'U';
991: x_oracle_error := APP_EXCEPTION.Get_Code;
992: l_msg_data := APP_EXCEPTION.Get_Text;
993: FND_MESSAGE.SET_NAME('GR',
994: 'GR_UNEXPECTED_ERROR');
995: FND_MESSAGE.SET_TOKEN('TEXT',
996: l_msg_token,

Line 999: APP_EXCEPTION.Raise_Exception;

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;
1003:

Line 1139: x_oracle_error := APP_EXCEPTION.Get_Code;

1135:
1136: WHEN OTHERS THEN
1137: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
1138: x_return_status := 'U';
1139: x_oracle_error := APP_EXCEPTION.Get_Code;
1140: l_msg_data := APP_EXCEPTION.Get_Text;
1141: FND_MESSAGE.SET_NAME('GR',
1142: 'GR_UNEXPECTED_ERROR');
1143: FND_MESSAGE.SET_TOKEN('TEXT',

Line 1140: l_msg_data := APP_EXCEPTION.Get_Text;

1136: WHEN OTHERS THEN
1137: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
1138: x_return_status := 'U';
1139: x_oracle_error := APP_EXCEPTION.Get_Code;
1140: l_msg_data := APP_EXCEPTION.Get_Text;
1141: FND_MESSAGE.SET_NAME('GR',
1142: 'GR_UNEXPECTED_ERROR');
1143: FND_MESSAGE.SET_TOKEN('TEXT',
1144: l_msg_data,

Line 1231: x_oracle_error := APP_EXCEPTION.Get_Code;

1227:
1228: WHEN OTHERS THEN
1229: ROLLBACK TO SAVEPOINT Check_Integrity;
1230: x_return_status := 'U';
1231: x_oracle_error := APP_EXCEPTION.Get_Code;
1232: l_msg_data := APP_EXCEPTION.Get_Text;
1233: FND_MESSAGE.SET_NAME('GR',
1234: 'GR_UNEXPECTED_ERROR');
1235: FND_MESSAGE.SET_TOKEN('TEXT',

Line 1232: l_msg_data := APP_EXCEPTION.Get_Text;

1228: WHEN OTHERS THEN
1229: ROLLBACK TO SAVEPOINT Check_Integrity;
1230: x_return_status := 'U';
1231: x_oracle_error := APP_EXCEPTION.Get_Code;
1232: l_msg_data := APP_EXCEPTION.Get_Text;
1233: FND_MESSAGE.SET_NAME('GR',
1234: 'GR_UNEXPECTED_ERROR');
1235: FND_MESSAGE.SET_TOKEN('TEXT',
1236: l_msg_data,

Line 1239: APP_EXCEPTION.Raise_Exception;

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;
1243:

Line 1300: l_msg_data := APP_EXCEPTION.Get_Text;

1296:
1297: EXCEPTION
1298:
1299: WHEN Others THEN
1300: l_msg_data := APP_EXCEPTION.Get_Text;
1301: FND_MESSAGE.SET_NAME('GR',
1302: 'GR_UNEXPECTED_ERROR');
1303: FND_MESSAGE.SET_TOKEN('TEXT',
1304: l_msg_data,

Line 1307: APP_EXCEPTION.Raise_Exception;

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;
1311: