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.GMIVQTY dependencies on FND_API

Line 549: RAISE FND_API.G_EXC_ERROR;

545: THEN
546: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_USER_NAME');
547: FND_MESSAGE.SET_TOKEN('USER_NAME', l_user_name);
548: FND_MSG_PUB.Add;
549: RAISE FND_API.G_EXC_ERROR;
550: END IF;
551:
552: IF NOT GMA_VALID_GRP.Validate_co_code(p_qty_rec.co_code)
553: THEN

Line 557: RAISE FND_API.G_EXC_ERROR;

553: THEN
554: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_CO_CODE');
555: FND_MESSAGE.SET_TOKEN('CO_CODE',p_qty_rec.co_code);
556: FND_MSG_PUB.Add;
557: RAISE FND_API.G_EXC_ERROR;
558: END IF;
559:
560: IF NOT GMA_VALID_GRP.Validate_orgn_code(l_qty_rec.orgn_code)
561: THEN

Line 565: RAISE FND_API.G_EXC_ERROR;

561: THEN
562: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_ORGN_CODE');
563: FND_MESSAGE.SET_TOKEN('ORGN_CODE',p_qty_rec.orgn_code);
564: FND_MSG_PUB.Add;
565: RAISE FND_API.G_EXC_ERROR;
566: END IF;
567:
568: IF l_trans_type BETWEEN 1 AND 10
569: THEN

Line 575: RAISE FND_API.G_EXC_ERROR;

571: ELSE
572: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_TRANS_TYPE');
573: FND_MESSAGE.SET_TOKEN('TRANS_TYPE',l_trans_type);
574: FND_MSG_PUB.Add;
575: RAISE FND_API.G_EXC_ERROR;
576: END IF;
577:
578: /* Check that transaction type is applicable to item. If */
579: /* it's not, complain, otherwise set up a few defaults. */

Line 587: RAISE FND_API.G_EXC_ERROR;

583: FND_MESSAGE.SET_NAME('GMI','IC_API_INV_TRANS_TYPE_FOR_ITEM');
584: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
585: FND_MESSAGE.SET_TOKEN('TRANS_TYPE', l_trans_type);
586: FND_MSG_PUB.Add;
587: RAISE FND_API.G_EXC_ERROR;
588: ELSE
589: /* For STSI and GRDI default the uoms. For other types */
590: /* accept what we're given unless they're null, in which */
591: /* case default them. */

Line 675: RAISE FND_API.G_EXC_ERROR;

671: THEN
672: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_ITEM_NO');
673: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
674: FND_MSG_PUB.Add;
675: RAISE FND_API.G_EXC_ERROR;
676: END IF;
677:
678:
679: /* If the item is lot controlled, all transaction types need */

Line 698: RAISE FND_API.G_EXC_ERROR;

694: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
695: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
696: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
697: FND_MSG_PUB.Add;
698: RAISE FND_API.G_EXC_ERROR;
699: END IF;
700: ELSE
701: l_qty_rec.lot_no := GMIGUTL.IC$DEFAULT_LOT;
702: l_qty_rec.sublot_no := NULL;

Line 729: RAISE FND_API.G_EXC_ERROR;

725: ELSE
726: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_ORGN_CODE');
727: FND_MESSAGE.SET_TOKEN('ORGN_CODE',l_qty_rec.orgn_code);
728: FND_MSG_PUB.Add;
729: RAISE FND_API.G_EXC_ERROR;
730: END IF;
731: ELSE
732: IF co_orgn_whse_valid (l_qty_rec, l_from_loct_ctl, l_to_loct_ctl)
733: THEN

Line 739: RAISE FND_API.G_EXC_ERROR;

735: ELSE
736: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_ORGN_CODE');
737: FND_MESSAGE.SET_TOKEN('ORGN_CODE',l_qty_rec.orgn_code);
738: FND_MSG_PUB.Add;
739: RAISE FND_API.G_EXC_ERROR;
740: END IF;
741: END IF;
742:
743:

Line 797: RAISE FND_API.G_EXC_ERROR;

793: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_qty_rec.item_no);
794: FND_MESSAGE.SET_TOKEN('WHSE_CODE', l_qty_rec.from_whse_code);
795: FND_MESSAGE.SET_TOKEN('LOCATION',l_qty_rec.from_location);
796: FND_MSG_PUB.Add;
797: RAISE FND_API.G_EXC_ERROR;
798: -- BEGIN BUG#2340824 Ravishanker B.
799: ELSE
800: IF whse_locations_valid (l_qty_rec) = FALSE THEN
801: RAISE FND_API.G_EXC_ERROR;

Line 801: RAISE FND_API.G_EXC_ERROR;

797: RAISE FND_API.G_EXC_ERROR;
798: -- BEGIN BUG#2340824 Ravishanker B.
799: ELSE
800: IF whse_locations_valid (l_qty_rec) = FALSE THEN
801: RAISE FND_API.G_EXC_ERROR;
802: END IF;
803: -- END BUG#2340824
804: END IF;
805: ELSE

Line 833: RAISE FND_API.G_EXC_ERROR;

829: FND_MESSAGE.SET_NAME('GMI','IC_API_UNPOSTED_JNL_QC_GRADE');
830: FND_MESSAGE.SET_TOKEN('QC_GRADE',l_qty_rec.qc_grade);
831: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
832: FND_MSG_PUB.Add;
833: RAISE FND_API.G_EXC_ERROR;
834: END IF;
835: ELSE
836: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_QC_GRADE');
837: FND_MESSAGE.SET_TOKEN('QC_GRADE',l_qty_rec.qc_grade);

Line 840: RAISE FND_API.G_EXC_ERROR;

836: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_QC_GRADE');
837: FND_MESSAGE.SET_TOKEN('QC_GRADE',l_qty_rec.qc_grade);
838: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
839: FND_MSG_PUB.Add;
840: RAISE FND_API.G_EXC_ERROR;
841: END IF;
842: ELSE
843: FND_MESSAGE.SET_NAME('GMI','IC_API_SAME_QC_GRADE');
844: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);

Line 848: RAISE FND_API.G_EXC_ERROR;

844: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
845: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
846: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
847: FND_MSG_PUB.Add;
848: RAISE FND_API.G_EXC_ERROR;
849: END IF;
850: ELSE
851: l_qty_rec.qc_grade :=p_ic_lots_mst_row.qc_grade;
852: END IF;

Line 876: RAISE FND_API.G_EXC_ERROR;

872: FND_MESSAGE.SET_NAME('GMI','IC_API_CANNOT_POST_CLOSED');
873: FND_MESSAGE.SET_TOKEN('ITEM_NO' , l_qty_rec.item_no);
874: FND_MESSAGE.SET_TOKEN('TRANS_DATE', l_qty_rec.trans_date);
875: FND_MSG_PUB.Add;
876: RAISE FND_API.G_EXC_ERROR;
877: -- Bug 2665243 Sastry removed to_char
878: ELSIF l_qty_rec.trans_date > SYSDATE
879: THEN
880: FND_MESSAGE.SET_NAME('GMI','IC_API_CANNOT_POST_FUTURE');

Line 884: RAISE FND_API.G_EXC_ERROR;

880: FND_MESSAGE.SET_NAME('GMI','IC_API_CANNOT_POST_FUTURE');
881: FND_MESSAGE.SET_TOKEN('ITEM_NO' , l_qty_rec.item_no);
882: FND_MESSAGE.SET_TOKEN('TRANS_DATE', l_qty_rec.trans_date);
883: FND_MSG_PUB.Add;
884: RAISE FND_API.G_EXC_ERROR;
885: END IF;
886: END IF;
887: /* END BUG#1492002 */
888: /* Validate Reason Code. All transaction types need a reason */

Line 909: RAISE FND_API.G_EXC_ERROR;

905: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
906: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
907: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
908: FND_MSG_PUB.Add;
909: RAISE FND_API.G_EXC_ERROR;
910: ELSIF l_sy_reas_cds_row.reason_type = 2 AND
911: l_qty_rec.trans_qty > 0
912: THEN
913: FND_MESSAGE.SET_NAME('GMI','IC_API_INC_NOT_ALLOWED');

Line 918: RAISE FND_API.G_EXC_ERROR;

914: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
915: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
916: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
917: FND_MSG_PUB.Add;
918: RAISE FND_API.G_EXC_ERROR;
919: END IF;
920: END IF;
921: ELSE
922: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_REASON_CODE');

Line 925: RAISE FND_API.G_EXC_ERROR;

921: ELSE
922: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_REASON_CODE');
923: FND_MESSAGE.SET_TOKEN('REASON_CODE',l_qty_rec.reason_code);
924: FND_MSG_PUB.Add;
925: RAISE FND_API.G_EXC_ERROR;
926: END IF;
927:
928:
929: /* 'Quantity' transactions must not have a zero quantity */

Line 939: RAISE FND_API.G_EXC_ERROR;

935: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
936: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
937: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
938: FND_MSG_PUB.Add;
939: RAISE FND_API.G_EXC_ERROR;
940: ELSE
941: IF l_qty_rec.trans_qty =0
942: THEN
943: FND_MESSAGE.SET_NAME('GMI','IC_API_ZERO_QTY');

Line 948: RAISE FND_API.G_EXC_ERROR;

944: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
945: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
946: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
947: FND_MSG_PUB.Add;
948: RAISE FND_API.G_EXC_ERROR;
949: END IF;
950: END IF;
951:
952:

Line 1029: RAISE FND_API.G_EXC_ERROR;

1025: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
1026: FND_MESSAGE.SET_TOKEN('WHSE_CODE',l_qty_rec.from_whse_code);
1027: FND_MESSAGE.SET_TOKEN('LOCATION',l_qty_rec.from_location);
1028: FND_MSG_PUB.Add;
1029: RAISE FND_API.G_EXC_ERROR;
1030: ELSE
1031: l_qty_rec.lot_status := p_ic_item_mst_row.lot_status;
1032: l_qty_rec.qc_grade := p_ic_item_mst_row.qc_grade;
1033: END IF;

Line 1060: RAISE FND_API.G_EXC_ERROR;

1056: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
1057: FND_MESSAGE.SET_TOKEN('WHSE_CODE',l_qty_rec.from_whse_code);
1058: FND_MESSAGE.SET_TOKEN('LOCATION',l_qty_rec.from_location);
1059: FND_MSG_PUB.Add;
1060: RAISE FND_API.G_EXC_ERROR;
1061: ELSE*/
1062: /*==================================================
1063: 27/Dec/2001 J.DiIorio Bug#2117575 - 11.5.1I
1064: ================================================*/

Line 1093: RAISE FND_API.G_EXC_ERROR;

1089: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1090: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
1091: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
1092: FND_MSG_PUB.Add;
1093: RAISE FND_API.G_EXC_ERROR;
1094: END IF;
1095: ELSIF GMIGUTL.IC$MOVEDIFFSTAT = 1 THEN
1096: IF (l_ic_loct_inv_row_to.loct_onhand IS NULL) THEN
1097: l_qty_rec.lot_status := l_ic_loct_inv_row_FROM.lot_status;

Line 1111: RAISE FND_API.G_EXC_ERROR;

1107: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1108: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
1109: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
1110: FND_MSG_PUB.Add;
1111: RAISE FND_API.G_EXC_ERROR;
1112: END IF;
1113: END IF;
1114: -- END IF; BUG#3127824 James Bernard
1115: -- END BUG#2354190/2354168

Line 1127: RAISE FND_API.G_EXC_ERROR;

1123: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
1124: FND_MESSAGE.SET_TOKEN('WHSE_CODE',l_qty_rec.from_whse_code);
1125: FND_MESSAGE.SET_TOKEN('LOCATION',l_qty_rec.from_location);
1126: FND_MSG_PUB.Add;
1127: RAISE FND_API.G_EXC_ERROR;
1128: ELSIF l_qty_rec.lot_status = l_ic_loct_inv_row_from.lot_status
1129: THEN
1130: FND_MESSAGE.SET_NAME('GMI','IC_API_SAME_LOT_STATUS');
1131: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);

Line 1135: RAISE FND_API.G_EXC_ERROR;

1131: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1132: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
1133: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
1134: FND_MSG_PUB.Add;
1135: RAISE FND_API.G_EXC_ERROR;
1136: ELSIF l_qty_rec.lot_status = p_ic_item_mst_row.lot_status
1137: THEN
1138: NULL;
1139: ELSE

Line 1148: RAISE FND_API.G_EXC_ERROR;

1144: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_STATUS');
1145: FND_MESSAGE.SET_TOKEN('LOT_STATUS',l_qty_rec.lot_status);
1146: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1147: FND_MSG_PUB.Add;
1148: RAISE FND_API.G_EXC_ERROR;
1149: END IF;
1150: END If;
1151: /* Check for unposted journals with different lot status */
1152: IF Check_unposted_jnl_lot_status

Line 1164: RAISE FND_API.G_EXC_ERROR;

1160: FND_MESSAGE.SET_NAME('GMI','IC_API_UNPOSTED_JNL_LOT_STATUS');
1161: FND_MESSAGE.SET_TOKEN('LOT_STATUS',l_qty_rec.lot_status);
1162: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1163: FND_MSG_PUB.Add;
1164: RAISE FND_API.G_EXC_ERROR;
1165: END IF;
1166: ELSE
1167: /* For grade changes there should be a non-zero balance */
1168: IF NVL(l_onhand,0) = 0

Line 1175: RAISE FND_API.G_EXC_ERROR;

1171: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1172: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
1173: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
1174: FND_MSG_PUB.Add;
1175: RAISE FND_API.G_EXC_ERROR;
1176: END IF;
1177: END IF;
1178:
1179:

Line 1190: RAISE FND_API.G_EXC_ERROR;

1186: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_UOM');
1187: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1188: FND_MESSAGE.SET_TOKEN('UOM',l_qty_rec.item_um);
1189: FND_MSG_PUB.Add;
1190: RAISE FND_API.G_EXC_ERROR;
1191: END IF;
1192: END IF;
1193:
1194:

Line 1226: RAISE FND_API.G_EXC_ERROR;

1222: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1223: FND_MESSAGE.SET_TOKEN('FROM_UOM',l_qty_rec.item_um);
1224: FND_MESSAGE.SET_TOKEN('TO_UOM',p_ic_item_mst_row.item_um);
1225: FND_MSG_PUB.Add;
1226: RAISE FND_API.G_EXC_ERROR;
1227: ELSE
1228: l_qty_rec.item_um :=p_ic_item_mst_row.item_um;
1229: /* Reverse quantity sign if reversed above */
1230: IF l_neg_qty = 1

Line 1321: RAISE FND_API.G_EXC_ERROR;

1317: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1318: FND_MESSAGE.SET_TOKEN('FROM_UOM',p_ic_item_mst_row.item_um);
1319: FND_MESSAGE.SET_TOKEN('TO_UOM',p_ic_item_mst_row.item_um2);
1320: FND_MSG_PUB.Add;
1321: RAISE FND_API.G_EXC_ERROR;
1322: END IF;
1323: /* Reverse quantity sign if reversed above */
1324: IF l_neg_qty = 1
1325: THEN

Line 1366: RAISE FND_API.G_EXC_ERROR;

1362: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1363: FND_MESSAGE.SET_TOKEN('FROM_UOM',l_qty_rec.item_um2);
1364: FND_MESSAGE.SET_TOKEN('TO_UOM',p_ic_item_mst_row.item_um2);
1365: FND_MSG_PUB.Add;
1366: RAISE FND_API.G_EXC_ERROR;
1367: ELSE
1368: l_qty_rec.item_um2 :=p_ic_item_mst_row.item_um2;
1369: /* Reverse quantity sign if reversed above */
1370: IF l_neg_qty = 1

Line 1400: RAISE FND_API.G_EXC_ERROR;

1396: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
1397: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
1398: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
1399: FND_MSG_PUB.Add;
1400: RAISE FND_API.G_EXC_ERROR;
1401: END IF;
1402: END IF;
1403: END IF;
1404: ELSE

Line 1454: RAISE FND_API.G_EXC_ERROR;

1450: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
1451: FND_MESSAGE.SET_TOKEN('WHSE_CODE',l_qty_rec.from_whse_code);
1452: FND_MESSAGE.SET_TOKEN('LOCATION',l_qty_rec.from_location);
1453: FND_MSG_PUB.Add;
1454: RAISE FND_API.G_EXC_ERROR;
1455: END IF;
1456: END IF;
1457:
1458: /* Check move quantity if item is lot-indivisble */

Line 1470: RAISE FND_API.G_EXC_ERROR;

1466: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
1467: FND_MESSAGE.SET_TOKEN('WHSE_CODE',l_qty_rec.from_whse_code);
1468: FND_MESSAGE.SET_TOKEN('LOCATION',l_qty_rec.from_location);
1469: FND_MSG_PUB.Add;
1470: RAISE FND_API.G_EXC_ERROR;
1471: END IF;
1472: IF (l_qty_rec.txn_type IN ('GRD','STS','TRN')) THEN
1473: x_ic_adjs_jnl_row1.acctg_unit_id := NULL;
1474: x_ic_adjs_jnl_row1.acct_id := NULL;

Line 1496: RAISE FND_API.G_EXC_ERROR;

1492: OR (l_qty_rec.acct_no IS NULL)
1493: ) THEN
1494: FND_MESSAGE.SET_NAME('GMI','GMI_API_CHARGE_ACCT');
1495: FND_MSG_PUB.Add;
1496: RAISE FND_API.G_EXC_ERROR;
1497: ELSE
1498: /* *********************************************************
1499: Jalaj Srivastava
1500: charge accounts are tied to the company of the warehouse

Line 1521: RAISE FND_API.G_EXC_ERROR;

1517: );
1518: IF (x_ic_adjs_jnl_row1.acctg_unit_id = -1) THEN
1519: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,substrb(l_errmsg,1,240));
1520: FND_MSG_PUB.Add;
1521: RAISE FND_API.G_EXC_ERROR;
1522: END IF;
1523: END IF;
1524: END IF; --IF (l_qty_rec.txn_type IN ('CRE','ADJ')) THEN
1525:

Line 1674: x_return_status := FND_API.G_RET_STS_SUCCESS;

1670: END IF;
1671: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count
1672: , p_data => x_msg_data
1673: );
1674: x_return_status := FND_API.G_RET_STS_SUCCESS;
1675:
1676: EXCEPTION
1677: WHEN FND_API.G_EXC_ERROR THEN
1678: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1677: WHEN FND_API.G_EXC_ERROR THEN

1673: );
1674: x_return_status := FND_API.G_RET_STS_SUCCESS;
1675:
1676: EXCEPTION
1677: WHEN FND_API.G_EXC_ERROR THEN
1678: x_return_status := FND_API.G_RET_STS_ERROR;
1679: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count
1680: , p_data => x_msg_data
1681: );

Line 1678: x_return_status := FND_API.G_RET_STS_ERROR;

1674: x_return_status := FND_API.G_RET_STS_SUCCESS;
1675:
1676: EXCEPTION
1677: WHEN FND_API.G_EXC_ERROR THEN
1678: x_return_status := FND_API.G_RET_STS_ERROR;
1679: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count
1680: , p_data => x_msg_data
1681: );
1682:

Line 1683: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1679: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count
1680: , p_data => x_msg_data
1681: );
1682:
1683: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1684: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1685: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count
1686: , p_data => x_msg_data
1687: );

Line 1684: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1680: , p_data => x_msg_data
1681: );
1682:
1683: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1684: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1685: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count
1686: , p_data => x_msg_data
1687: );
1688: WHEN OTHERS THEN

Line 1689: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1685: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count
1686: , p_data => x_msg_data
1687: );
1688: WHEN OTHERS THEN
1689: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1690: /* IF FND_MSG_PUB.check_msg_level */
1691: /* (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) */
1692: /* THEN */
1693: