DBA Data[Home] [Help]

APPS.GR_DOCUMENT_PRINT_PKG dependencies on APP_EXCEPTION

Line 280: APP_EXCEPTION.Raise_Exception;

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

Line 288: x_oracle_error := APP_EXCEPTION.Get_Code;

284:
285: WHEN Label_Exists_Error THEN
286: ROLLBACK TO SAVEPOINT Insert_Row;
287: x_return_status := 'E';
288: x_oracle_error := APP_EXCEPTION.Get_Code;
289: FND_MESSAGE.SET_NAME('GR',
290: 'GR_RECORD_EXISTS');
291: FND_MESSAGE.SET_TOKEN('CODE',
292: p_document_code || ' ' || p_item_code,

Line 295: APP_EXCEPTION.Raise_Exception;

291: FND_MESSAGE.SET_TOKEN('CODE',
292: p_document_code || ' ' || p_item_code,
293: FALSE);
294: IF FND_API.To_Boolean(p_called_by_form) THEN
295: APP_EXCEPTION.Raise_Exception;
296: ELSE
297: x_msg_data := FND_MESSAGE.Get;
298: END IF;
299:

Line 303: x_oracle_error := APP_EXCEPTION.Get_Code;

299:
300: WHEN Row_Missing_Error THEN
301: ROLLBACK TO SAVEPOINT Insert_Row;
302: x_return_status := 'E';
303: x_oracle_error := APP_EXCEPTION.Get_Code;
304: FND_MESSAGE.SET_NAME('GR',
305: 'GR_NO_RECORD_INSERTED');
306: FND_MESSAGE.SET_TOKEN('CODE',
307: p_document_code || ' ' || p_item_code,

Line 310: APP_EXCEPTION.Raise_Exception;

306: FND_MESSAGE.SET_TOKEN('CODE',
307: p_document_code || ' ' || p_item_code,
308: FALSE);
309: IF FND_API.To_Boolean(p_called_by_form) THEN
310: APP_EXCEPTION.Raise_Exception;
311: ELSE
312: x_msg_data := FND_MESSAGE.Get;
313: END IF;
314:

Line 326: APP_EXCEPTION.Raise_Exception;

322: FND_MESSAGE.SET_TOKEN('TEXT',
323: l_msg_data,
324: FALSE);
325: IF FND_API.To_Boolean(p_called_by_form) THEN
326: APP_EXCEPTION.Raise_Exception;
327: ELSE
328: x_msg_data := FND_MESSAGE.Get;
329: END IF;
330:

Line 530: APP_EXCEPTION.Raise_Exception;

526: FND_MESSAGE.SET_TOKEN('TEXT',
527: l_msg_data,
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 Row_Missing_Error THEN
536: ROLLBACK TO SAVEPOINT Update_Row;
537: x_return_status := 'E';
538: x_oracle_error := APP_EXCEPTION.Get_Code;
539: FND_MESSAGE.SET_NAME('GR',
540: 'GR_NO_RECORD_INSERTED');
541: FND_MESSAGE.SET_TOKEN('CODE',
542: p_document_code || ' ' || p_item_code,

Line 545: APP_EXCEPTION.Raise_Exception;

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

Line 561: APP_EXCEPTION.Raise_Exception;

557: FND_MESSAGE.SET_TOKEN('TEXT',
558: l_msg_data,
559: FALSE);
560: IF FND_API.To_Boolean(p_called_by_form) THEN
561: APP_EXCEPTION.Raise_Exception;
562: ELSE
563: x_msg_data := FND_MESSAGE.Get;
564: END IF;
565:

Line 681: APP_EXCEPTION.Raise_Exception;

677: FND_MESSAGE.SET_TOKEN('CODE',
678: p_document_code || ' ' || p_item_code,
679: FALSE);
680: IF FND_API.To_Boolean(p_called_by_form) THEN
681: APP_EXCEPTION.Raise_Exception;
682: ELSE
683: x_msg_data := FND_MESSAGE.Get;
684: END IF;
685:

Line 689: -- x_oracle_error := APP_EXCEPTION.Get_Code;

685:
686: WHEN Row_Already_Locked_Error THEN
687: ROLLBACK TO SAVEPOINT Lock_Row;
688: x_return_status := 'E';
689: -- x_oracle_error := APP_EXCEPTION.Get_Code;
690: x_oracle_error := SQLCODE;
691: -- Bug #2180453 (JKB)
692: FND_MESSAGE.SET_NAME('GR',
693: 'GR_ROW_IS_LOCKED');

Line 695: APP_EXCEPTION.Raise_Exception;

691: -- Bug #2180453 (JKB)
692: FND_MESSAGE.SET_NAME('GR',
693: 'GR_ROW_IS_LOCKED');
694: IF FND_API.To_Boolean(p_called_by_form) THEN
695: APP_EXCEPTION.Raise_Exception;
696: ELSE
697: x_msg_data := FND_MESSAGE.Get;
698: END IF;
699:

Line 711: APP_EXCEPTION.Raise_Exception;

707: FND_MESSAGE.SET_TOKEN('TEXT',
708: l_msg_data,
709: FALSE);
710: IF FND_API.To_Boolean(p_called_by_form) THEN
711: APP_EXCEPTION.Raise_Exception;
712: ELSE
713: x_msg_data := FND_MESSAGE.Get;
714: END IF;
715:

Line 866: APP_EXCEPTION.Raise_Exception;

862: ROLLBACK TO SAVEPOINT Delete_Row;
863: x_return_status := l_return_status;
864: x_oracle_error := l_oracle_error;
865: IF FND_API.To_Boolean(p_called_by_form) THEN
866: APP_EXCEPTION.Raise_Exception;
867: ELSE
868: x_msg_data := FND_MESSAGE.Get;
869: END IF;
870:

Line 874: x_oracle_error := APP_EXCEPTION.Get_Code;

870:
871: WHEN Row_Missing_Error THEN
872: ROLLBACK TO SAVEPOINT Delete_Row;
873: x_return_status := 'E';
874: x_oracle_error := APP_EXCEPTION.Get_Code;
875: FND_MESSAGE.SET_NAME('GR',
876: 'GR_RECORD_NOT_FOUND');
877: FND_MESSAGE.SET_TOKEN('CODE',
878: p_document_code || ' ' || p_item_code,

Line 881: APP_EXCEPTION.Raise_Exception;

877: FND_MESSAGE.SET_TOKEN('CODE',
878: p_document_code || ' ' || p_item_code,
879: FALSE);
880: IF FND_API.To_Boolean(p_called_by_form) THEN
881: APP_EXCEPTION.Raise_Exception;
882: ELSE
883: x_msg_data := FND_MESSAGE.Get;
884: END IF;
885:

Line 897: APP_EXCEPTION.Raise_Exception;

893: FND_MESSAGE.SET_TOKEN('TEXT',
894: l_msg_data,
895: FALSE);
896: IF FND_API.To_Boolean(p_called_by_form) THEN
897: APP_EXCEPTION.Raise_Exception;
898: ELSE
899: x_msg_data := FND_MESSAGE.Get;
900: END IF;
901:

Line 1010: x_oracle_error := APP_EXCEPTION.Get_Code;

1006: EXCEPTION
1007:
1008: WHEN Null_Delete_Option_Error THEN
1009: x_return_status := 'E';
1010: x_oracle_error := APP_EXCEPTION.Get_Code;
1011: FND_MESSAGE.SET_NAME('GR',
1012: 'GR_NULL_VALUE');
1013: FND_MESSAGE.SET_TOKEN('CODE',
1014: l_msg_token,

Line 1017: APP_EXCEPTION.Raise_Exception;

1013: FND_MESSAGE.SET_TOKEN('CODE',
1014: l_msg_token,
1015: FALSE);
1016: IF FND_API.To_Boolean(p_called_by_form) THEN
1017: APP_EXCEPTION.Raise_Exception;
1018: ELSE
1019: x_msg_data := FND_MESSAGE.Get;
1020: END IF;
1021:

Line 1033: APP_EXCEPTION.Raise_Exception;

1029: FND_MESSAGE.SET_TOKEN('TEXT',
1030: l_msg_token,
1031: FALSE);
1032: IF FND_API.To_Boolean(p_called_by_form) THEN
1033: APP_EXCEPTION.Raise_Exception;
1034: ELSE
1035: x_msg_data := FND_MESSAGE.Get;
1036: END IF;
1037:

Line 1185: x_oracle_error := APP_EXCEPTION.Get_Code;

1181: OPEN c_get_language;
1182: FETCH c_get_language INTO LangRecord;
1183: IF c_get_language%NOTFOUND THEN
1184: x_return_status := 'E';
1185: x_oracle_error := APP_EXCEPTION.Get_Code;
1186: FND_MESSAGE.SET_NAME('GR',
1187: 'GR_RECORD_NOT_FOUND');
1188: FND_MESSAGE.SET_TOKEN('CODE',
1189: p_language,

Line 1202: x_oracle_error := APP_EXCEPTION.Get_Code;

1198: OPEN c_get_disclosure;
1199: FETCH c_get_disclosure INTO DisclosureRecord;
1200: IF c_get_disclosure%NOTFOUND THEN
1201: x_return_status := 'E';
1202: x_oracle_error := APP_EXCEPTION.Get_Code;
1203: FND_MESSAGE.SET_NAME('GR',
1204: 'GR_RECORD_NOT_FOUND');
1205: FND_MESSAGE.SET_TOKEN('CODE',
1206: l_disclosure_code,

Line 1219: x_oracle_error := APP_EXCEPTION.Get_Code;

1215: OPEN c_get_disclosure;
1216: FETCH c_get_disclosure INTO DisclosureRecord;
1217: IF c_get_disclosure%NOTFOUND THEN
1218: x_return_status := 'E';
1219: x_oracle_error := APP_EXCEPTION.Get_Code;
1220: FND_MESSAGE.SET_NAME('GR',
1221: 'GR_RECORD_NOT_FOUND');
1222: FND_MESSAGE.SET_TOKEN('CODE',
1223: l_disclosure_code,

Line 1369: APP_EXCEPTION.Raise_Exception;

1365: FND_MESSAGE.SET_TOKEN('CODE',
1366: p_language,
1367: FALSE);
1368: IF FND_API.To_Boolean(p_called_by_form) THEN
1369: APP_EXCEPTION.Raise_Exception;
1370: ELSE
1371: x_msg_data := FND_MESSAGE.Get;
1372: END IF;
1373:

Line 1385: APP_EXCEPTION.Raise_Exception;

1381: FND_MESSAGE.SET_TOKEN('TEXT',
1382: l_msg_data,
1383: FALSE);
1384: IF FND_API.To_Boolean(p_called_by_form) THEN
1385: APP_EXCEPTION.Raise_Exception;
1386: ELSE
1387: x_msg_data := FND_MESSAGE.Get;
1388: END IF;
1389:

Line 1441: APP_EXCEPTION.Raise_Exception;

1437: FND_MESSAGE.SET_TOKEN('TEXT',
1438: l_msg_data,
1439: FALSE);
1440: IF FND_API.To_Boolean(p_called_by_form) THEN
1441: APP_EXCEPTION.Raise_Exception;
1442: END IF;
1443:
1444: END Check_Primary_Key;
1445: