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

Line 98: ( ((p_encumbrance_on = FND_API.G_TRUE) AND (p_cc_headers_rec.cc_encmbrnc_status = 'C')) OR

94: of PO */
95:
96: IF (p_cc_headers_rec.cc_apprvl_status = 'AP') AND
97: (p_cc_headers_rec.cc_ctrl_status = 'O') AND
98: ( ((p_encumbrance_on = FND_API.G_TRUE) AND (p_cc_headers_rec.cc_encmbrnc_status = 'C')) OR
99: ((p_encumbrance_on = FND_API.G_FALSE) AND (p_cc_headers_rec.cc_encmbrnc_status = 'N'))
100: ) THEN
101:
102: l_po_headers_rec.authorization_status := 'APPROVED';

Line 99: ((p_encumbrance_on = FND_API.G_FALSE) AND (p_cc_headers_rec.cc_encmbrnc_status = 'N'))

95:
96: IF (p_cc_headers_rec.cc_apprvl_status = 'AP') AND
97: (p_cc_headers_rec.cc_ctrl_status = 'O') AND
98: ( ((p_encumbrance_on = FND_API.G_TRUE) AND (p_cc_headers_rec.cc_encmbrnc_status = 'C')) OR
99: ((p_encumbrance_on = FND_API.G_FALSE) AND (p_cc_headers_rec.cc_encmbrnc_status = 'N'))
100: ) THEN
101:
102: l_po_headers_rec.authorization_status := 'APPROVED';
103: l_po_headers_rec.approved_flag := 'Y';

Line 475: IF (p_encumbrance_on = FND_API.G_TRUE) THEN

471: l_po_line_locs_rec.quantity_cancelled := 0;
472: l_po_line_locs_rec.price_override := 1;
473: END IF;
474:
475: IF (p_encumbrance_on = FND_API.G_TRUE) THEN
476: l_po_line_locs_rec.encumbered_flag := 'Y';
477: ELSE
478: l_po_line_locs_rec.encumbered_flag := 'N';
479: END IF;

Line 624: IF (p_encumbrance_on = FND_API.G_TRUE) THEN

620: -- Added for PRC.FP.J, 3173178
621: -- PO Standalone patch 3205071 is a pre-req for this change
622: l_po_dist_rec.distribution_type := 'STANDARD';
623:
624: IF (p_encumbrance_on = FND_API.G_TRUE) THEN
625: l_po_dist_rec.encumbered_flag := p_po_line_locs_rec.encumbered_flag;
626: l_po_dist_rec.gl_encumbered_date := p_cc_pmt_fcst_rec.cc_det_pf_encmbrnc_date;
627: l_po_dist_rec.encumbered_amount := p_cc_pmt_fcst_rec.cc_det_pf_encmbrnc_amt;
628: /* Removed the hard coded reference to period type of CC Month to fix bug 1427486*/

Line 767: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

763:
764: PROCEDURE Update_PO_Approved_Flag
765: (
766: p_api_version IN NUMBER,
767: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
768: p_commit IN VARCHAR2 := FND_API.G_FALSE,
769: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
770: x_return_status OUT NOCOPY VARCHAR2,
771: x_msg_count OUT NOCOPY NUMBER,

Line 768: p_commit IN VARCHAR2 := FND_API.G_FALSE,

764: PROCEDURE Update_PO_Approved_Flag
765: (
766: p_api_version IN NUMBER,
767: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
768: p_commit IN VARCHAR2 := FND_API.G_FALSE,
769: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
770: x_return_status OUT NOCOPY VARCHAR2,
771: x_msg_count OUT NOCOPY NUMBER,
772: x_msg_data OUT NOCOPY VARCHAR2,

Line 769: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

765: (
766: p_api_version IN NUMBER,
767: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
768: p_commit IN VARCHAR2 := FND_API.G_FALSE,
769: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
770: x_return_status OUT NOCOPY VARCHAR2,
771: x_msg_count OUT NOCOPY NUMBER,
772: x_msg_data OUT NOCOPY VARCHAR2,
773: p_cc_header_id IN NUMBER

Line 836: l_encumbrance_on := FND_API.G_TRUE;

832: -- Bug 3605536 GSCC Warnings fixed
833:
834: l_po_found := FALSE;
835: l_new_account_line := FALSE;
836: l_encumbrance_on := FND_API.G_TRUE;
837: l_curr_year_pf_lines := 0;
838:
839: SAVEPOINT Update_PO_Approved_Flag;
840:

Line 841: IF FND_API.to_Boolean(p_init_msg_list)

837: l_curr_year_pf_lines := 0;
838:
839: SAVEPOINT Update_PO_Approved_Flag;
840:
841: IF FND_API.to_Boolean(p_init_msg_list)
842: THEN
843: FND_MSG_PUB.initialize;
844: END IF;
845:

Line 846: IF NOT FND_API.Compatible_API_Call(l_api_version,

842: THEN
843: FND_MSG_PUB.initialize;
844: END IF;
845:
846: IF NOT FND_API.Compatible_API_Call(l_api_version,
847: p_api_version,
848: l_api_name,
849: G_PKG_NAME)
850: THEN

Line 851: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

847: p_api_version,
848: l_api_name,
849: G_PKG_NAME)
850: THEN
851: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
852: END IF;
853:
854:
855: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 855: x_return_status := FND_API.G_RET_STS_SUCCESS;

851: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
852: END IF;
853:
854:
855: x_return_status := FND_API.G_RET_STS_SUCCESS;
856: l_return_status := FND_API.G_RET_STS_SUCCESS;
857: l_msg_data := NULL;
858: l_msg_count := 0;
859:

Line 856: l_return_status := FND_API.G_RET_STS_SUCCESS;

852: END IF;
853:
854:
855: x_return_status := FND_API.G_RET_STS_SUCCESS;
856: l_return_status := FND_API.G_RET_STS_SUCCESS;
857: l_msg_data := NULL;
858: l_msg_count := 0;
859:
860: /* Check whether Contract Commitment exists or not */

Line 955: FND_API.G_FALSE,

951:
952: IGC_CC_BUDGETARY_CTRL_PKG.Check_Budgetary_Ctrl_On
953: (
954: 1.0,
955: FND_API.G_FALSE,
956: FND_API.G_VALID_LEVEL_FULL,
957: l_return_status,
958: l_msg_count,
959: l_msg_data ,

Line 956: FND_API.G_VALID_LEVEL_FULL,

952: IGC_CC_BUDGETARY_CTRL_PKG.Check_Budgetary_Ctrl_On
953: (
954: 1.0,
955: FND_API.G_FALSE,
956: FND_API.G_VALID_LEVEL_FULL,
957: l_return_status,
958: l_msg_count,
959: l_msg_data ,
960: l_cc_headers_rec.org_id,

Line 966: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

962: l_cc_headers_rec.cc_state,
963: l_encumbrance_on
964: );
965:
966: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
967: THEN
968: RAISE e_internal_error;
969: END IF;
970:

Line 983: ((l_encumbrance_on = FND_API.G_TRUE) AND (l_cc_headers_rec.cc_encmbrnc_status = 'C')) OR

979:
980: IF (l_cc_headers_rec.cc_apprvl_status = 'AP') AND
981: (l_cc_headers_rec.cc_state = 'CM') AND
982: (
983: ((l_encumbrance_on = FND_API.G_TRUE) AND (l_cc_headers_rec.cc_encmbrnc_status = 'C')) OR
984: ((l_encumbrance_on = FND_API.G_FALSE) AND (l_cc_headers_rec.cc_encmbrnc_status = 'N'))
985: )
986: THEN
987: IF (l_cc_headers_rec.cc_ctrl_status = 'O')

Line 984: ((l_encumbrance_on = FND_API.G_FALSE) AND (l_cc_headers_rec.cc_encmbrnc_status = 'N'))

980: IF (l_cc_headers_rec.cc_apprvl_status = 'AP') AND
981: (l_cc_headers_rec.cc_state = 'CM') AND
982: (
983: ((l_encumbrance_on = FND_API.G_TRUE) AND (l_cc_headers_rec.cc_encmbrnc_status = 'C')) OR
984: ((l_encumbrance_on = FND_API.G_FALSE) AND (l_cc_headers_rec.cc_encmbrnc_status = 'N'))
985: )
986: THEN
987: IF (l_cc_headers_rec.cc_ctrl_status = 'O')
988: THEN

Line 1019: FND_API.G_FALSE,

1015: l_po_headers_rec.approved_date := NULL;
1016: END IF;
1017:
1018: IGC_CC_PO_HEADERS_ALL_PVT.Update_Row(1.0,
1019: FND_API.G_FALSE,
1020: FND_API.G_FALSE,
1021: FND_API.G_VALID_LEVEL_NONE,
1022: l_return_status,
1023: l_msg_count,

Line 1020: FND_API.G_FALSE,

1016: END IF;
1017:
1018: IGC_CC_PO_HEADERS_ALL_PVT.Update_Row(1.0,
1019: FND_API.G_FALSE,
1020: FND_API.G_FALSE,
1021: FND_API.G_VALID_LEVEL_NONE,
1022: l_return_status,
1023: l_msg_count,
1024: l_msg_data,

Line 1021: FND_API.G_VALID_LEVEL_NONE,

1017:
1018: IGC_CC_PO_HEADERS_ALL_PVT.Update_Row(1.0,
1019: FND_API.G_FALSE,
1020: FND_API.G_FALSE,
1021: FND_API.G_VALID_LEVEL_NONE,
1022: l_return_status,
1023: l_msg_count,
1024: l_msg_data,
1025: l_po_headers_rec);

Line 1027: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

1023: l_msg_count,
1024: l_msg_data,
1025: l_po_headers_rec);
1026:
1027: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1028: THEN
1029: RAISE e_internal_error;
1030: END IF;
1031:

Line 1084: FND_API.G_FALSE,

1080: l_po_line_locs_rec.outsourced_assembly := 2;
1081: END IF;
1082:
1083: IGC_CC_PO_LINE_LOCS_ALL_PVT.Update_Row(1.0,
1084: FND_API.G_FALSE,
1085: FND_API.G_FALSE,
1086: FND_API.G_VALID_LEVEL_NONE,
1087: l_return_status,
1088: l_msg_count,

Line 1085: FND_API.G_FALSE,

1081: END IF;
1082:
1083: IGC_CC_PO_LINE_LOCS_ALL_PVT.Update_Row(1.0,
1084: FND_API.G_FALSE,
1085: FND_API.G_FALSE,
1086: FND_API.G_VALID_LEVEL_NONE,
1087: l_return_status,
1088: l_msg_count,
1089: l_msg_data,

Line 1086: FND_API.G_VALID_LEVEL_NONE,

1082:
1083: IGC_CC_PO_LINE_LOCS_ALL_PVT.Update_Row(1.0,
1084: FND_API.G_FALSE,
1085: FND_API.G_FALSE,
1086: FND_API.G_VALID_LEVEL_NONE,
1087: l_return_status,
1088: l_msg_count,
1089: l_msg_data,
1090: l_po_line_locs_rec);

Line 1092: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

1088: l_msg_count,
1089: l_msg_data,
1090: l_po_line_locs_rec);
1091:
1092: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1093: THEN
1094: RAISE e_internal_error;
1095: END IF;
1096:

Line 1107: IF FND_API.To_Boolean(p_commit)

1103: CLOSE c_account_lines;
1104:
1105: END IF; /* PO Exisists */
1106:
1107: IF FND_API.To_Boolean(p_commit)
1108: THEN
1109: COMMIT WORK;
1110: END IF;
1111:

Line 1121: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

1117: x_return_status := l_return_status;
1118: x_msg_count := l_msg_count;
1119: x_msg_data := l_msg_data;
1120:
1121: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1122: THEN
1123: ROLLBACK TO Update_PO_Approved_Flag;
1124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1125:

Line 1124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1120:
1121: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1122: THEN
1123: ROLLBACK TO Update_PO_Approved_Flag;
1124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1125:
1126: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1127: p_data => x_msg_data );
1128:

Line 1132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1128:
1129: WHEN E_CC_NOT_FOUND OR E_CC_STATE OR E_CC_TYPE OR E_PO_NOT_FOUND OR E_LINE_LOCATIONS OR E_UNABLE_TO_OPEN_PO
1130: THEN
1131: ROLLBACK TO Update_PO_Approved_Flag;
1132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1133:
1134: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1135: p_data => x_msg_data );
1136:

Line 1140: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1136:
1137: WHEN OTHERS
1138: THEN
1139: ROLLBACK TO Update_PO_Approved_Flag;
1140: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1141:
1142: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1143: THEN
1144: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

Line 1159: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1155:
1156: PROCEDURE Convert_CC_To_PO
1157: (
1158: p_api_version IN NUMBER,
1159: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1160: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1161: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1162: x_return_status OUT NOCOPY VARCHAR2,
1163: x_msg_count OUT NOCOPY NUMBER,

Line 1160: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1156: PROCEDURE Convert_CC_To_PO
1157: (
1158: p_api_version IN NUMBER,
1159: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1160: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1161: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1162: x_return_status OUT NOCOPY VARCHAR2,
1163: x_msg_count OUT NOCOPY NUMBER,
1164: x_msg_data OUT NOCOPY VARCHAR2,

Line 1161: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1157: (
1158: p_api_version IN NUMBER,
1159: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1160: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1161: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1162: x_return_status OUT NOCOPY VARCHAR2,
1163: x_msg_count OUT NOCOPY NUMBER,
1164: x_msg_data OUT NOCOPY VARCHAR2,
1165: p_cc_header_id IN NUMBER

Line 1244: l_encumbrance_on := FND_API.G_FALSE;

1240:
1241: --Bug 3605536 GSCC Warnings fixed
1242: l_encumbered_period_name := 'MAY-01';
1243: l_curr_year_pf_lines := 0;
1244: l_encumbrance_on := FND_API.G_FALSE;
1245: l_new_account_line := FALSE;
1246: l_new_payment_forecast_line := FALSE;
1247: l_po_found := FALSE;
1248:

Line 1251: IF FND_API.to_Boolean(p_init_msg_list)

1247: l_po_found := FALSE;
1248:
1249: SAVEPOINT Convert_CC_To_PO;
1250:
1251: IF FND_API.to_Boolean(p_init_msg_list)
1252: THEN
1253: FND_MSG_PUB.initialize;
1254: END IF;
1255:

Line 1256: IF NOT FND_API.Compatible_API_Call(l_api_version,

1252: THEN
1253: FND_MSG_PUB.initialize;
1254: END IF;
1255:
1256: IF NOT FND_API.Compatible_API_Call(l_api_version,
1257: p_api_version,
1258: l_api_name,
1259: G_PKG_NAME)
1260: THEN

Line 1261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1257: p_api_version,
1258: l_api_name,
1259: G_PKG_NAME)
1260: THEN
1261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1262: END IF;
1263:
1264: x_return_status := FND_API.G_RET_STS_SUCCESS;
1265: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1264: x_return_status := FND_API.G_RET_STS_SUCCESS;

1260: THEN
1261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1262: END IF;
1263:
1264: x_return_status := FND_API.G_RET_STS_SUCCESS;
1265: l_return_status := FND_API.G_RET_STS_SUCCESS;
1266: l_msg_data := NULL;
1267: l_msg_count := 0;
1268:

Line 1265: l_return_status := FND_API.G_RET_STS_SUCCESS;

1261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1262: END IF;
1263:
1264: x_return_status := FND_API.G_RET_STS_SUCCESS;
1265: l_return_status := FND_API.G_RET_STS_SUCCESS;
1266: l_msg_data := NULL;
1267: l_msg_count := 0;
1268:
1269:

Line 1310: FND_API.G_FALSE,

1306:
1307: IGC_CC_BUDGETARY_CTRL_PKG.Check_Budgetary_Ctrl_On
1308: (
1309: 1.0,
1310: FND_API.G_FALSE,
1311: FND_API.G_VALID_LEVEL_FULL,
1312: l_return_status,
1313: l_msg_count,
1314: l_msg_data ,

Line 1311: FND_API.G_VALID_LEVEL_FULL,

1307: IGC_CC_BUDGETARY_CTRL_PKG.Check_Budgetary_Ctrl_On
1308: (
1309: 1.0,
1310: FND_API.G_FALSE,
1311: FND_API.G_VALID_LEVEL_FULL,
1312: l_return_status,
1313: l_msg_count,
1314: l_msg_data ,
1315: l_cc_headers_rec.org_id,

Line 1321: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

1317: l_cc_headers_rec.cc_state,
1318: l_encumbrance_on
1319: );
1320:
1321: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1322: THEN
1323: RAISE e_internal_error;
1324: END IF;
1325:

Line 1333: IF (l_encumbrance_on = FND_API.G_TRUE)

1329: THEN
1330: IF (l_cc_headers_rec.cc_apprvl_status = 'AP')
1331: THEN
1332: /* Check whether budetary control has been turned on */
1333: IF (l_encumbrance_on = FND_API.G_TRUE)
1334: THEN
1335: /* fix for bug 1567120 */
1336: IF (l_cc_headers_rec.cc_type = 'S') OR (l_cc_headers_rec.cc_type = 'R')
1337: THEN

Line 1421: FND_API.G_FALSE,

1417: IF (l_po_found)
1418: THEN
1419: Initialize_Header_Row('U',l_encumbrance_on, l_cc_headers_rec, l_po_headers_rec);
1420: IGC_CC_PO_HEADERS_ALL_PVT.Update_Row(1.0,
1421: FND_API.G_FALSE,
1422: FND_API.G_FALSE,
1423: FND_API.G_VALID_LEVEL_NONE,
1424: l_return_status,
1425: l_msg_count,

Line 1422: FND_API.G_FALSE,

1418: THEN
1419: Initialize_Header_Row('U',l_encumbrance_on, l_cc_headers_rec, l_po_headers_rec);
1420: IGC_CC_PO_HEADERS_ALL_PVT.Update_Row(1.0,
1421: FND_API.G_FALSE,
1422: FND_API.G_FALSE,
1423: FND_API.G_VALID_LEVEL_NONE,
1424: l_return_status,
1425: l_msg_count,
1426: l_msg_data,

Line 1423: FND_API.G_VALID_LEVEL_NONE,

1419: Initialize_Header_Row('U',l_encumbrance_on, l_cc_headers_rec, l_po_headers_rec);
1420: IGC_CC_PO_HEADERS_ALL_PVT.Update_Row(1.0,
1421: FND_API.G_FALSE,
1422: FND_API.G_FALSE,
1423: FND_API.G_VALID_LEVEL_NONE,
1424: l_return_status,
1425: l_msg_count,
1426: l_msg_data,
1427: l_po_headers_rec);

Line 1429: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

1425: l_msg_count,
1426: l_msg_data,
1427: l_po_headers_rec);
1428:
1429: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1430: THEN
1431: RAISE e_internal_error;
1432: END IF;
1433:

Line 1473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1469: AND pll.po_line_id = l_po_lines_rec.po_line_id;
1470: EXCEPTION
1471: WHEN NO_DATA_FOUND
1472: THEN
1473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1474: END;
1475: END IF;
1476:
1477: BEGIN

Line 1506: FND_API.G_FALSE,

1502: l_start_date,
1503: l_end_date);
1504:
1505: IGC_CC_PO_LINES_ALL_PVT.Insert_Row(1.0,
1506: FND_API.G_FALSE,
1507: FND_API.G_FALSE,
1508: FND_API.G_VALID_LEVEL_NONE,
1509: l_return_status,
1510: l_msg_count,

Line 1507: FND_API.G_FALSE,

1503: l_end_date);
1504:
1505: IGC_CC_PO_LINES_ALL_PVT.Insert_Row(1.0,
1506: FND_API.G_FALSE,
1507: FND_API.G_FALSE,
1508: FND_API.G_VALID_LEVEL_NONE,
1509: l_return_status,
1510: l_msg_count,
1511: l_msg_data,

Line 1508: FND_API.G_VALID_LEVEL_NONE,

1504:
1505: IGC_CC_PO_LINES_ALL_PVT.Insert_Row(1.0,
1506: FND_API.G_FALSE,
1507: FND_API.G_FALSE,
1508: FND_API.G_VALID_LEVEL_NONE,
1509: l_return_status,
1510: l_msg_count,
1511: l_msg_data,
1512: l_po_lines_rec);

Line 1514: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

1510: l_msg_count,
1511: l_msg_data,
1512: l_po_lines_rec);
1513:
1514: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1515: THEN
1516: RAISE e_internal_error;
1517: END IF;
1518:

Line 1526: FND_API.G_FALSE,

1522: l_po_lines_rec,
1523: l_po_line_locs_rec);
1524:
1525: IGC_CC_PO_LINE_LOCS_ALL_PVT.Insert_Row(1.0,
1526: FND_API.G_FALSE,
1527: FND_API.G_FALSE,
1528: FND_API.G_VALID_LEVEL_NONE,
1529: l_return_status,
1530: l_msg_count,

Line 1527: FND_API.G_FALSE,

1523: l_po_line_locs_rec);
1524:
1525: IGC_CC_PO_LINE_LOCS_ALL_PVT.Insert_Row(1.0,
1526: FND_API.G_FALSE,
1527: FND_API.G_FALSE,
1528: FND_API.G_VALID_LEVEL_NONE,
1529: l_return_status,
1530: l_msg_count,
1531: l_msg_data,

Line 1528: FND_API.G_VALID_LEVEL_NONE,

1524:
1525: IGC_CC_PO_LINE_LOCS_ALL_PVT.Insert_Row(1.0,
1526: FND_API.G_FALSE,
1527: FND_API.G_FALSE,
1528: FND_API.G_VALID_LEVEL_NONE,
1529: l_return_status,
1530: l_msg_count,
1531: l_msg_data,
1532: l_po_line_locs_rec);

Line 1534: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

1530: l_msg_count,
1531: l_msg_data,
1532: l_po_line_locs_rec);
1533:
1534: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1535: THEN
1536: RAISE e_internal_error;
1537: END IF;
1538:

Line 1563: FND_API.G_FALSE,

1559: l_po_line_locs_rec,
1560: l_po_dist_rec);
1561:
1562: IGC_CC_PO_DIST_ALL_PVT.Insert_Row(1.0,
1563: FND_API.G_FALSE,
1564: FND_API.G_FALSE,
1565: FND_API.G_VALID_LEVEL_NONE,
1566: l_return_status,
1567: l_msg_count,

Line 1564: FND_API.G_FALSE,

1560: l_po_dist_rec);
1561:
1562: IGC_CC_PO_DIST_ALL_PVT.Insert_Row(1.0,
1563: FND_API.G_FALSE,
1564: FND_API.G_FALSE,
1565: FND_API.G_VALID_LEVEL_NONE,
1566: l_return_status,
1567: l_msg_count,
1568: l_msg_data,

Line 1565: FND_API.G_VALID_LEVEL_NONE,

1561:
1562: IGC_CC_PO_DIST_ALL_PVT.Insert_Row(1.0,
1563: FND_API.G_FALSE,
1564: FND_API.G_FALSE,
1565: FND_API.G_VALID_LEVEL_NONE,
1566: l_return_status,
1567: l_msg_count,
1568: l_msg_data,
1569: l_po_dist_rec);

Line 1571: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

1567: l_msg_count,
1568: l_msg_data,
1569: l_po_dist_rec);
1570:
1571: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1572: THEN
1573: RAISE e_internal_error;
1574: END IF;
1575: END IF;

Line 1596: FND_API.G_FALSE,

1592: l_start_date,
1593: l_end_date);
1594:
1595: IGC_CC_PO_LINES_ALL_PVT.Update_Row(1.0,
1596: FND_API.G_FALSE,
1597: FND_API.G_FALSE,
1598: FND_API.G_VALID_LEVEL_NONE,
1599: l_return_status,
1600: l_msg_count,

Line 1597: FND_API.G_FALSE,

1593: l_end_date);
1594:
1595: IGC_CC_PO_LINES_ALL_PVT.Update_Row(1.0,
1596: FND_API.G_FALSE,
1597: FND_API.G_FALSE,
1598: FND_API.G_VALID_LEVEL_NONE,
1599: l_return_status,
1600: l_msg_count,
1601: l_msg_data,

Line 1598: FND_API.G_VALID_LEVEL_NONE,

1594:
1595: IGC_CC_PO_LINES_ALL_PVT.Update_Row(1.0,
1596: FND_API.G_FALSE,
1597: FND_API.G_FALSE,
1598: FND_API.G_VALID_LEVEL_NONE,
1599: l_return_status,
1600: l_msg_count,
1601: l_msg_data,
1602: l_po_lines_rec);

Line 1603: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

1599: l_return_status,
1600: l_msg_count,
1601: l_msg_data,
1602: l_po_lines_rec);
1603: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1604: THEN
1605: RAISE e_internal_error;
1606: END IF;
1607:

Line 1615: FND_API.G_FALSE,

1611: l_po_lines_rec,
1612: l_po_line_locs_rec);
1613:
1614: IGC_CC_PO_LINE_LOCS_ALL_PVT.Update_Row(1.0,
1615: FND_API.G_FALSE,
1616: FND_API.G_FALSE,
1617: FND_API.G_VALID_LEVEL_NONE,
1618: l_return_status,
1619: l_msg_count,

Line 1616: FND_API.G_FALSE,

1612: l_po_line_locs_rec);
1613:
1614: IGC_CC_PO_LINE_LOCS_ALL_PVT.Update_Row(1.0,
1615: FND_API.G_FALSE,
1616: FND_API.G_FALSE,
1617: FND_API.G_VALID_LEVEL_NONE,
1618: l_return_status,
1619: l_msg_count,
1620: l_msg_data,

Line 1617: FND_API.G_VALID_LEVEL_NONE,

1613:
1614: IGC_CC_PO_LINE_LOCS_ALL_PVT.Update_Row(1.0,
1615: FND_API.G_FALSE,
1616: FND_API.G_FALSE,
1617: FND_API.G_VALID_LEVEL_NONE,
1618: l_return_status,
1619: l_msg_count,
1620: l_msg_data,
1621: l_po_line_locs_rec);

Line 1623: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

1619: l_msg_count,
1620: l_msg_data,
1621: l_po_line_locs_rec);
1622:
1623: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1624: THEN
1625: RAISE e_internal_error;
1626: END IF;
1627:

Line 1676: FND_API.G_FALSE,

1672: l_po_line_locs_rec,
1673: l_po_dist_rec);
1674:
1675: IGC_CC_PO_DIST_ALL_PVT.Insert_Row(1.0,
1676: FND_API.G_FALSE,
1677: FND_API.G_FALSE,
1678: FND_API.G_VALID_LEVEL_NONE,
1679: l_return_status,
1680: l_msg_count,

Line 1677: FND_API.G_FALSE,

1673: l_po_dist_rec);
1674:
1675: IGC_CC_PO_DIST_ALL_PVT.Insert_Row(1.0,
1676: FND_API.G_FALSE,
1677: FND_API.G_FALSE,
1678: FND_API.G_VALID_LEVEL_NONE,
1679: l_return_status,
1680: l_msg_count,
1681: l_msg_data,

Line 1678: FND_API.G_VALID_LEVEL_NONE,

1674:
1675: IGC_CC_PO_DIST_ALL_PVT.Insert_Row(1.0,
1676: FND_API.G_FALSE,
1677: FND_API.G_FALSE,
1678: FND_API.G_VALID_LEVEL_NONE,
1679: l_return_status,
1680: l_msg_count,
1681: l_msg_data,
1682: l_po_dist_rec);

Line 1685: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

1681: l_msg_data,
1682: l_po_dist_rec);
1683:
1684:
1685: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1686: THEN
1687: RAISE e_internal_error;
1688: END IF;
1689: END IF;

Line 1706: FND_API.G_FALSE,

1702: l_po_line_locs_rec,
1703: l_po_dist_rec);
1704:
1705: IGC_CC_PO_DIST_ALL_PVT.Update_Row(1.0,
1706: FND_API.G_FALSE,
1707: FND_API.G_FALSE,
1708: FND_API.G_VALID_LEVEL_NONE,
1709: l_return_status,
1710: l_msg_count,

Line 1707: FND_API.G_FALSE,

1703: l_po_dist_rec);
1704:
1705: IGC_CC_PO_DIST_ALL_PVT.Update_Row(1.0,
1706: FND_API.G_FALSE,
1707: FND_API.G_FALSE,
1708: FND_API.G_VALID_LEVEL_NONE,
1709: l_return_status,
1710: l_msg_count,
1711: l_msg_data,

Line 1708: FND_API.G_VALID_LEVEL_NONE,

1704:
1705: IGC_CC_PO_DIST_ALL_PVT.Update_Row(1.0,
1706: FND_API.G_FALSE,
1707: FND_API.G_FALSE,
1708: FND_API.G_VALID_LEVEL_NONE,
1709: l_return_status,
1710: l_msg_count,
1711: l_msg_data,
1712: l_po_dist_rec);

Line 1714: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

1710: l_msg_count,
1711: l_msg_data,
1712: l_po_dist_rec);
1713:
1714: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1715: THEN
1716: RAISE e_internal_error;
1717: END IF;
1718:

Line 1739: FND_API.G_FALSE,

1735:
1736: Initialize_Header_Row('I',l_encumbrance_on, l_cc_headers_rec, l_po_headers_rec);
1737:
1738: IGC_CC_PO_HEADERS_ALL_PVT.Insert_Row(1.0,
1739: FND_API.G_FALSE,
1740: FND_API.G_FALSE,
1741: FND_API.G_VALID_LEVEL_NONE,
1742: l_return_status,
1743: l_msg_count,

Line 1740: FND_API.G_FALSE,

1736: Initialize_Header_Row('I',l_encumbrance_on, l_cc_headers_rec, l_po_headers_rec);
1737:
1738: IGC_CC_PO_HEADERS_ALL_PVT.Insert_Row(1.0,
1739: FND_API.G_FALSE,
1740: FND_API.G_FALSE,
1741: FND_API.G_VALID_LEVEL_NONE,
1742: l_return_status,
1743: l_msg_count,
1744: l_msg_data,

Line 1741: FND_API.G_VALID_LEVEL_NONE,

1737:
1738: IGC_CC_PO_HEADERS_ALL_PVT.Insert_Row(1.0,
1739: FND_API.G_FALSE,
1740: FND_API.G_FALSE,
1741: FND_API.G_VALID_LEVEL_NONE,
1742: l_return_status,
1743: l_msg_count,
1744: l_msg_data,
1745: l_po_headers_rec);

Line 1747: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

1743: l_msg_count,
1744: l_msg_data,
1745: l_po_headers_rec);
1746:
1747: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1748: THEN
1749: RAISE e_internal_error;
1750: END IF;
1751:

Line 1790: FND_API.G_FALSE,

1786: l_po_lines_rec,
1787: l_start_date,
1788: l_end_date);
1789: IGC_CC_PO_LINES_ALL_PVT.Insert_Row(1.0,
1790: FND_API.G_FALSE,
1791: FND_API.G_FALSE,
1792: FND_API.G_VALID_LEVEL_NONE,
1793: l_return_status,
1794: l_msg_count,

Line 1791: FND_API.G_FALSE,

1787: l_start_date,
1788: l_end_date);
1789: IGC_CC_PO_LINES_ALL_PVT.Insert_Row(1.0,
1790: FND_API.G_FALSE,
1791: FND_API.G_FALSE,
1792: FND_API.G_VALID_LEVEL_NONE,
1793: l_return_status,
1794: l_msg_count,
1795: l_msg_data,

Line 1792: FND_API.G_VALID_LEVEL_NONE,

1788: l_end_date);
1789: IGC_CC_PO_LINES_ALL_PVT.Insert_Row(1.0,
1790: FND_API.G_FALSE,
1791: FND_API.G_FALSE,
1792: FND_API.G_VALID_LEVEL_NONE,
1793: l_return_status,
1794: l_msg_count,
1795: l_msg_data,
1796: l_po_lines_rec);

Line 1798: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

1794: l_msg_count,
1795: l_msg_data,
1796: l_po_lines_rec);
1797:
1798: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1799: THEN
1800: RAISE e_internal_error;
1801: END IF;
1802:

Line 1812: FND_API.G_FALSE,

1808: l_po_lines_rec,
1809: l_po_line_locs_rec);
1810:
1811: IGC_CC_PO_LINE_LOCS_ALL_PVT.Insert_Row(1.0,
1812: FND_API.G_FALSE,
1813: FND_API.G_FALSE,
1814: FND_API.G_VALID_LEVEL_NONE,
1815: l_return_status,
1816: l_msg_count,

Line 1813: FND_API.G_FALSE,

1809: l_po_line_locs_rec);
1810:
1811: IGC_CC_PO_LINE_LOCS_ALL_PVT.Insert_Row(1.0,
1812: FND_API.G_FALSE,
1813: FND_API.G_FALSE,
1814: FND_API.G_VALID_LEVEL_NONE,
1815: l_return_status,
1816: l_msg_count,
1817: l_msg_data,

Line 1814: FND_API.G_VALID_LEVEL_NONE,

1810:
1811: IGC_CC_PO_LINE_LOCS_ALL_PVT.Insert_Row(1.0,
1812: FND_API.G_FALSE,
1813: FND_API.G_FALSE,
1814: FND_API.G_VALID_LEVEL_NONE,
1815: l_return_status,
1816: l_msg_count,
1817: l_msg_data,
1818: l_po_line_locs_rec);

Line 1820: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

1816: l_msg_count,
1817: l_msg_data,
1818: l_po_line_locs_rec);
1819:
1820: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1821: THEN
1822: RAISE e_internal_error;
1823: END IF;
1824:

Line 1852: FND_API.G_FALSE,

1848: l_po_line_locs_rec,
1849: l_po_dist_rec);
1850:
1851: IGC_CC_PO_DIST_ALL_PVT.Insert_Row(1.0,
1852: FND_API.G_FALSE,
1853: FND_API.G_FALSE,
1854: FND_API.G_VALID_LEVEL_NONE,
1855: l_return_status,
1856: l_msg_count,

Line 1853: FND_API.G_FALSE,

1849: l_po_dist_rec);
1850:
1851: IGC_CC_PO_DIST_ALL_PVT.Insert_Row(1.0,
1852: FND_API.G_FALSE,
1853: FND_API.G_FALSE,
1854: FND_API.G_VALID_LEVEL_NONE,
1855: l_return_status,
1856: l_msg_count,
1857: l_msg_data,

Line 1854: FND_API.G_VALID_LEVEL_NONE,

1850:
1851: IGC_CC_PO_DIST_ALL_PVT.Insert_Row(1.0,
1852: FND_API.G_FALSE,
1853: FND_API.G_FALSE,
1854: FND_API.G_VALID_LEVEL_NONE,
1855: l_return_status,
1856: l_msg_count,
1857: l_msg_data,
1858: l_po_dist_rec);

Line 1859: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

1855: l_return_status,
1856: l_msg_count,
1857: l_msg_data,
1858: l_po_dist_rec);
1859: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1860: THEN
1861: RAISE e_internal_error;
1862: END IF;
1863: END IF;

Line 1877: IF FND_API.To_Boolean(p_commit)

1873:
1874: END IF; /* PO do not exist */
1875:
1876:
1877: IF FND_API.To_Boolean(p_commit)
1878: THEN
1879: COMMIT WORK;
1880: END IF;
1881:

Line 1892: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

1888: x_msg_count := l_msg_count;
1889: x_msg_data := l_msg_data;
1890:
1891:
1892: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1893: THEN
1894: ROLLBACK TO Convert_CC_To_PO;
1895: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1896:

Line 1895: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1891:
1892: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1893: THEN
1894: ROLLBACK TO Convert_CC_To_PO;
1895: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1896:
1897: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1898: p_data => x_msg_data );
1899:

Line 1904: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1900: WHEN E_CC_NOT_FOUND OR E_CC_STATE OR E_CC_TYPE OR E_CC_NOT_ENCUMBERED OR E_LINE_LOCATIONS
1901: OR E_CC_NOT_APPROVED
1902: THEN
1903: ROLLBACK TO Convert_CC_To_PO;
1904: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1905: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1906: p_data => x_msg_data );
1907:
1908: WHEN OTHERS

Line 1911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1907:
1908: WHEN OTHERS
1909: THEN
1910: ROLLBACK TO Convert_CC_To_PO;
1911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1912:
1913: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1914: THEN
1915: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

Line 1931: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1927: +==========================================================================*/
1928: PROCEDURE Lock_PO_Row
1929: (
1930: p_api_version IN NUMBER,
1931: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1932: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1933: x_return_status OUT NOCOPY VARCHAR2,
1934: x_msg_count OUT NOCOPY NUMBER,
1935: x_msg_data OUT NOCOPY VARCHAR2,

Line 1932: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1928: PROCEDURE Lock_PO_Row
1929: (
1930: p_api_version IN NUMBER,
1931: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1932: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1933: x_return_status OUT NOCOPY VARCHAR2,
1934: x_msg_count OUT NOCOPY NUMBER,
1935: x_msg_data OUT NOCOPY VARCHAR2,
1936: p_cc_header_id IN NUMBER,

Line 1967: IF NOT FND_API.Compatible_API_Call ( l_api_version,

1963: BEGIN
1964:
1965: SAVEPOINT Lock_Row_Pvt ;
1966:
1967: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1968: p_api_version,
1969: l_api_name,
1970: G_PKG_NAME )
1971: THEN

Line 1972: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1968: p_api_version,
1969: l_api_name,
1970: G_PKG_NAME )
1971: THEN
1972: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1973: END IF;
1974:
1975:
1976: IF FND_API.to_Boolean ( p_init_msg_list )

Line 1976: IF FND_API.to_Boolean ( p_init_msg_list )

1972: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1973: END IF;
1974:
1975:
1976: IF FND_API.to_Boolean ( p_init_msg_list )
1977: THEN
1978: FND_MSG_PUB.initialize ;
1979: END IF;
1980:

Line 1981: x_return_status := FND_API.G_RET_STS_SUCCESS ;

1977: THEN
1978: FND_MSG_PUB.initialize ;
1979: END IF;
1980:
1981: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1982:
1983: x_row_locked := FND_API.G_TRUE ;
1984:
1985: /* Check whether Contract Commitment exists or not */

Line 1983: x_row_locked := FND_API.G_TRUE ;

1979: END IF;
1980:
1981: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1982:
1983: x_row_locked := FND_API.G_TRUE ;
1984:
1985: /* Check whether Contract Commitment exists or not */
1986:
1987: BEGIN

Line 2022: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2018: EXCEPTION
2019: WHEN E_CC_NOT_FOUND OR E_PO_NOT_FOUND
2020: THEN
2021: ROLLBACK TO Lock_Row_Pvt ;
2022: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2023: x_row_locked := FND_API.G_FALSE;
2024:
2025: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2026: p_data => x_msg_data );

Line 2023: x_row_locked := FND_API.G_FALSE;

2019: WHEN E_CC_NOT_FOUND OR E_PO_NOT_FOUND
2020: THEN
2021: ROLLBACK TO Lock_Row_Pvt ;
2022: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2023: x_row_locked := FND_API.G_FALSE;
2024:
2025: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2026: p_data => x_msg_data );
2027:

Line 2033: x_row_locked := FND_API.G_FALSE;

2029: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION
2030: THEN
2031:
2032: ROLLBACK TO Lock_Row_Pvt ;
2033: x_row_locked := FND_API.G_FALSE;
2034: x_return_status := FND_API.G_RET_STS_ERROR;
2035: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2036: p_data => x_msg_data );
2037:

Line 2034: x_return_status := FND_API.G_RET_STS_ERROR;

2030: THEN
2031:
2032: ROLLBACK TO Lock_Row_Pvt ;
2033: x_row_locked := FND_API.G_FALSE;
2034: x_return_status := FND_API.G_RET_STS_ERROR;
2035: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2036: p_data => x_msg_data );
2037:
2038: WHEN FND_API.G_EXC_ERROR

Line 2038: WHEN FND_API.G_EXC_ERROR

2034: x_return_status := FND_API.G_RET_STS_ERROR;
2035: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2036: p_data => x_msg_data );
2037:
2038: WHEN FND_API.G_EXC_ERROR
2039: THEN
2040:
2041: ROLLBACK TO Lock_Row_Pvt ;
2042: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2042: x_return_status := FND_API.G_RET_STS_ERROR;

2038: WHEN FND_API.G_EXC_ERROR
2039: THEN
2040:
2041: ROLLBACK TO Lock_Row_Pvt ;
2042: x_return_status := FND_API.G_RET_STS_ERROR;
2043: x_row_locked := FND_API.G_FALSE;
2044: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2045: p_data => x_msg_data );
2046:

Line 2043: x_row_locked := FND_API.G_FALSE;

2039: THEN
2040:
2041: ROLLBACK TO Lock_Row_Pvt ;
2042: x_return_status := FND_API.G_RET_STS_ERROR;
2043: x_row_locked := FND_API.G_FALSE;
2044: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2045: p_data => x_msg_data );
2046:
2047: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 2047: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

2043: x_row_locked := FND_API.G_FALSE;
2044: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2045: p_data => x_msg_data );
2046:
2047: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
2048: THEN
2049: ROLLBACK TO Lock_Row_Pvt ;
2050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2051: x_row_locked := FND_API.G_FALSE;

Line 2050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2046:
2047: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
2048: THEN
2049: ROLLBACK TO Lock_Row_Pvt ;
2050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2051: x_row_locked := FND_API.G_FALSE;
2052: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2053: p_data => x_msg_data );
2054:

Line 2051: x_row_locked := FND_API.G_FALSE;

2047: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
2048: THEN
2049: ROLLBACK TO Lock_Row_Pvt ;
2050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2051: x_row_locked := FND_API.G_FALSE;
2052: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2053: p_data => x_msg_data );
2054:
2055: WHEN OTHERS

Line 2059: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2055: WHEN OTHERS
2056: THEN
2057:
2058: ROLLBACK TO Lock_Row_Pvt ;
2059: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2060: x_row_locked := FND_API.G_FALSE;
2061:
2062: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2063: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

Line 2060: x_row_locked := FND_API.G_FALSE;

2056: THEN
2057:
2058: ROLLBACK TO Lock_Row_Pvt ;
2059: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2060: x_row_locked := FND_API.G_FALSE;
2061:
2062: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2063: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
2064: l_api_name);