DBA Data[Home] [Help]

APPS.GR_ITEM_SAFETY dependencies on APP_EXCEPTION

Line 153: l_oracle_error := APP_EXCEPTION.Get_Code;

149:
150: EXCEPTION
151:
152: WHEN OTHERS THEN
153: l_oracle_error := APP_EXCEPTION.Get_Code;
154: l_code_block := l_code_block || ' ' || TO_CHAR(l_oracle_error);
155: FND_MESSAGE.SET_NAME('GR',
156: 'GR_UNEXPECTED_ERROR');
157: FND_MESSAGE.SET_TOKEN('TEXT',

Line 160: APP_EXCEPTION.Raise_Exception;

156: 'GR_UNEXPECTED_ERROR');
157: FND_MESSAGE.SET_TOKEN('TEXT',
158: l_code_block,
159: FALSE);
160: APP_EXCEPTION.Raise_Exception;
161:
162: END get_properties;
163:
164: PROCEDURE paste_item_safety

Line 468: l_oracle_error := APP_EXCEPTION.Get_Code;

464:
465: EXCEPTION
466:
467: WHEN Item_Null_Error THEN
468: l_oracle_error := APP_EXCEPTION.Get_Code;
469: l_code_block := l_code_block || ' ' || TO_CHAR(l_oracle_error);
470: FND_MESSAGE.SET_NAME('GR',
471: 'GR_PRINT_ITEM_NULL');
472: APP_EXCEPTION.Raise_Exception;

Line 472: APP_EXCEPTION.Raise_Exception;

468: l_oracle_error := APP_EXCEPTION.Get_Code;
469: l_code_block := l_code_block || ' ' || TO_CHAR(l_oracle_error);
470: FND_MESSAGE.SET_NAME('GR',
471: 'GR_PRINT_ITEM_NULL');
472: APP_EXCEPTION.Raise_Exception;
473:
474: WHEN Invalid_Item_Code THEN
475: l_oracle_error := APP_EXCEPTION.Get_Code;
476: l_code_block := l_code_block || ' ' || TO_CHAR(l_oracle_error);

Line 475: l_oracle_error := APP_EXCEPTION.Get_Code;

471: 'GR_PRINT_ITEM_NULL');
472: APP_EXCEPTION.Raise_Exception;
473:
474: WHEN Invalid_Item_Code THEN
475: l_oracle_error := APP_EXCEPTION.Get_Code;
476: l_code_block := l_code_block || ' ' || TO_CHAR(l_oracle_error);
477: FND_MESSAGE.SET_NAME('GR',
478: 'GR_INVALID_ITEM_CODE');
479: FND_MESSAGE.SET_TOKEN('CODE',

Line 482: APP_EXCEPTION.Raise_Exception;

478: 'GR_INVALID_ITEM_CODE');
479: FND_MESSAGE.SET_TOKEN('CODE',
480: l_copy_item,
481: FALSE);
482: APP_EXCEPTION.Raise_Exception;
483:
484: WHEN Paste_Item_Exists_Error THEN
485: l_oracle_error := APP_EXCEPTION.Get_Code;
486: l_code_block := l_code_block || ' ' || TO_CHAR(l_oracle_error);

Line 485: l_oracle_error := APP_EXCEPTION.Get_Code;

481: FALSE);
482: APP_EXCEPTION.Raise_Exception;
483:
484: WHEN Paste_Item_Exists_Error THEN
485: l_oracle_error := APP_EXCEPTION.Get_Code;
486: l_code_block := l_code_block || ' ' || TO_CHAR(l_oracle_error);
487: FND_MESSAGE.SET_NAME('GR',
488: 'GR_RECORD_EXISTS');
489: FND_MESSAGE.SET_TOKEN('CODE',

Line 492: APP_EXCEPTION.Raise_Exception;

488: 'GR_RECORD_EXISTS');
489: FND_MESSAGE.SET_TOKEN('CODE',
490: l_paste_item,
491: FALSE);
492: APP_EXCEPTION.Raise_Exception;
493:
494: WHEN Insert_Rows_Error THEN
495: l_oracle_error := APP_EXCEPTION.Get_Code;
496: l_code_block := l_code_block || ' ' || TO_CHAR(l_oracle_error);

Line 495: l_oracle_error := APP_EXCEPTION.Get_Code;

491: FALSE);
492: APP_EXCEPTION.Raise_Exception;
493:
494: WHEN Insert_Rows_Error THEN
495: l_oracle_error := APP_EXCEPTION.Get_Code;
496: l_code_block := l_code_block || ' ' || TO_CHAR(l_oracle_error);
497: FND_MESSAGE.SET_NAME('GR',
498: 'GR_NO_RECORD_INSERTED');
499: FND_MESSAGE.SET_TOKEN('CODE',

Line 502: APP_EXCEPTION.Raise_Exception;

498: 'GR_NO_RECORD_INSERTED');
499: FND_MESSAGE.SET_TOKEN('CODE',
500: l_code_block,
501: FALSE);
502: APP_EXCEPTION.Raise_Exception;
503:
504: WHEN Update_Rows_Error THEN
505: l_oracle_error := APP_EXCEPTION.Get_Code;
506: l_code_block := l_code_block || ' ' || TO_CHAR(l_oracle_error);

Line 505: l_oracle_error := APP_EXCEPTION.Get_Code;

501: FALSE);
502: APP_EXCEPTION.Raise_Exception;
503:
504: WHEN Update_Rows_Error THEN
505: l_oracle_error := APP_EXCEPTION.Get_Code;
506: l_code_block := l_code_block || ' ' || TO_CHAR(l_oracle_error);
507: FND_MESSAGE.SET_NAME('GR',
508: 'GR_NO_RECORD_INSERTED');
509: FND_MESSAGE.SET_TOKEN('CODE',

Line 512: APP_EXCEPTION.Raise_Exception;

508: 'GR_NO_RECORD_INSERTED');
509: FND_MESSAGE.SET_TOKEN('CODE',
510: l_code_block,
511: FALSE);
512: APP_EXCEPTION.Raise_Exception;
513:
514: WHEN OTHERS THEN
515: l_oracle_error := APP_EXCEPTION.Get_Code;
516: l_code_block := l_code_block || ' ' || TO_CHAR(l_oracle_error);

Line 515: l_oracle_error := APP_EXCEPTION.Get_Code;

511: FALSE);
512: APP_EXCEPTION.Raise_Exception;
513:
514: WHEN OTHERS THEN
515: l_oracle_error := APP_EXCEPTION.Get_Code;
516: l_code_block := l_code_block || ' ' || TO_CHAR(l_oracle_error);
517: FND_MESSAGE.SET_NAME('GR',
518: 'GR_UNEXPECTED_ERROR');
519: FND_MESSAGE.SET_TOKEN('TEXT',

Line 522: APP_EXCEPTION.Raise_Exception;

518: 'GR_UNEXPECTED_ERROR');
519: FND_MESSAGE.SET_TOKEN('TEXT',
520: l_code_block,
521: FALSE);
522: APP_EXCEPTION.Raise_Exception;
523:
524: END paste_item_safety;
525:
526: PROCEDURE delete_item_safety

Line 1127: l_oracle_error := APP_EXCEPTION.Get_Code;

1123:
1124: EXCEPTION
1125:
1126: WHEN Item_Null_Error THEN
1127: l_oracle_error := APP_EXCEPTION.Get_Code;
1128: l_code_block := l_code_block || ' ' || TO_CHAR(l_oracle_error);
1129: FND_MESSAGE.SET_NAME('GR',
1130: 'GR_UNEXPECTED_ERROR');
1131: FND_MESSAGE.SET_TOKEN('TEXT',

Line 1134: APP_EXCEPTION.Raise_Exception;

1130: 'GR_UNEXPECTED_ERROR');
1131: FND_MESSAGE.SET_TOKEN('TEXT',
1132: l_code_block,
1133: FALSE);
1134: APP_EXCEPTION.Raise_Exception;
1135:
1136: WHEN Invalid_Item_Error THEN
1137: l_oracle_error := APP_EXCEPTION.Get_Code;
1138: l_code_block := l_code_block || ' ' || TO_CHAR(l_oracle_error);

Line 1137: l_oracle_error := APP_EXCEPTION.Get_Code;

1133: FALSE);
1134: APP_EXCEPTION.Raise_Exception;
1135:
1136: WHEN Invalid_Item_Error THEN
1137: l_oracle_error := APP_EXCEPTION.Get_Code;
1138: l_code_block := l_code_block || ' ' || TO_CHAR(l_oracle_error);
1139: FND_MESSAGE.SET_NAME('GR',
1140: 'GR_INVALID_ITEM_CODE');
1141: FND_MESSAGE.SET_TOKEN('CODE',

Line 1144: APP_EXCEPTION.Raise_Exception;

1140: 'GR_INVALID_ITEM_CODE');
1141: FND_MESSAGE.SET_TOKEN('CODE',
1142: p_delete_item,
1143: FALSE);
1144: APP_EXCEPTION.Raise_Exception;
1145:
1146: WHEN Cannot_Lock_Item_Error THEN
1147: l_oracle_error := APP_EXCEPTION.Get_Code;
1148: l_code_block := l_code_block || ' ' || TO_CHAR(l_oracle_error);

Line 1147: l_oracle_error := APP_EXCEPTION.Get_Code;

1143: FALSE);
1144: APP_EXCEPTION.Raise_Exception;
1145:
1146: WHEN Cannot_Lock_Item_Error THEN
1147: l_oracle_error := APP_EXCEPTION.Get_Code;
1148: l_code_block := l_code_block || ' ' || TO_CHAR(l_oracle_error);
1149: FND_MESSAGE.SET_NAME('GR',
1150: 'GR_UNEXPECTED_ERROR');
1151: FND_MESSAGE.SET_TOKEN('TEXT',

Line 1154: APP_EXCEPTION.Raise_Exception;

1150: 'GR_UNEXPECTED_ERROR');
1151: FND_MESSAGE.SET_TOKEN('TEXT',
1152: l_code_block,
1153: FALSE);
1154: APP_EXCEPTION.Raise_Exception;
1155:
1156: WHEN OTHER_API_ERROR THEN
1157: FND_MESSAGE.SET_NAME('GR',
1158: 'GR_UNEXPECTED_ERROR');

Line 1162: APP_EXCEPTION.Raise_Exception;

1158: 'GR_UNEXPECTED_ERROR');
1159: FND_MESSAGE.SET_TOKEN('TEXT',
1160: l_msg_data,
1161: FALSE);
1162: APP_EXCEPTION.Raise_Exception;
1163:
1164: WHEN OTHERS THEN
1165: l_oracle_error := APP_EXCEPTION.Get_Code;
1166: l_code_block := l_code_block || ' ' || TO_CHAR(l_oracle_error);

Line 1165: l_oracle_error := APP_EXCEPTION.Get_Code;

1161: FALSE);
1162: APP_EXCEPTION.Raise_Exception;
1163:
1164: WHEN OTHERS THEN
1165: l_oracle_error := APP_EXCEPTION.Get_Code;
1166: l_code_block := l_code_block || ' ' || TO_CHAR(l_oracle_error);
1167: FND_MESSAGE.SET_NAME('GR',
1168: 'GR_UNEXPECTED_ERROR');
1169: FND_MESSAGE.SET_TOKEN('TEXT',

Line 1172: APP_EXCEPTION.Raise_Exception;

1168: 'GR_UNEXPECTED_ERROR');
1169: FND_MESSAGE.SET_TOKEN('TEXT',
1170: l_code_block,
1171: FALSE);
1172: APP_EXCEPTION.Raise_Exception;
1173:
1174: END delete_item_safety;
1175:
1176: PROCEDURE delete_item_document

Line 1321: l_oracle_error := APP_EXCEPTION.Get_Code;

1317:
1318: EXCEPTION
1319:
1320: WHEN Item_Null_Error THEN
1321: l_oracle_error := APP_EXCEPTION.Get_Code;
1322: l_code_block := l_code_block || ' ' || TO_CHAR(l_oracle_error);
1323: FND_MESSAGE.SET_NAME('GR',
1324: 'GR_UNEXPECTED_ERROR');
1325: FND_MESSAGE.SET_TOKEN('TEXT',

Line 1328: APP_EXCEPTION.Raise_Exception;

1324: 'GR_UNEXPECTED_ERROR');
1325: FND_MESSAGE.SET_TOKEN('TEXT',
1326: l_code_block,
1327: FALSE);
1328: APP_EXCEPTION.Raise_Exception;
1329:
1330: WHEN OTHER_API_ERROR THEN
1331: FND_MESSAGE.SET_NAME('GR',
1332: 'GR_UNEXPECTED_ERROR');

Line 1336: APP_EXCEPTION.Raise_Exception;

1332: 'GR_UNEXPECTED_ERROR');
1333: FND_MESSAGE.SET_TOKEN('TEXT',
1334: l_msg_data,
1335: FALSE);
1336: APP_EXCEPTION.Raise_Exception;
1337:
1338: WHEN OTHERS THEN
1339: l_oracle_error := APP_EXCEPTION.Get_Code;
1340: l_code_block := l_code_block || ' ' || TO_CHAR(l_oracle_error);

Line 1339: l_oracle_error := APP_EXCEPTION.Get_Code;

1335: FALSE);
1336: APP_EXCEPTION.Raise_Exception;
1337:
1338: WHEN OTHERS THEN
1339: l_oracle_error := APP_EXCEPTION.Get_Code;
1340: l_code_block := l_code_block || ' ' || TO_CHAR(l_oracle_error);
1341: FND_MESSAGE.SET_NAME('GR',
1342: 'GR_UNEXPECTED_ERROR');
1343: FND_MESSAGE.SET_TOKEN('TEXT',

Line 1346: APP_EXCEPTION.Raise_Exception;

1342: 'GR_UNEXPECTED_ERROR');
1343: FND_MESSAGE.SET_TOKEN('TEXT',
1344: l_code_block,
1345: FALSE);
1346: APP_EXCEPTION.Raise_Exception;
1347:
1348: END delete_item_document;
1349:
1350: END GR_ITEM_SAFETY;