1068: x_approver_seq=> l_approver_seq,
1069: x_return_status=> l_return_status
1070: );
1071:
1072: IF l_return_status = fnd_api.g_ret_sts_success THEN
1073: wf_engine.setitemattrnumber (
1074: itemtype=> itemtype,
1075: itemkey=> itemkey,
1076: aname => 'AMS_APPROVAL_DETAIL_ID',
1160: resultout := 'COMPLETE:SUCCESS';
1161:
1162: ELSE
1163: fnd_msg_pub.count_and_get (
1164: p_encoded=> fnd_api.g_false,
1165: p_count=> l_msg_count,
1166: p_data=> l_msg_data
1167: );
1168: ams_gen_approval_pvt.handle_err (
1203: END IF;
1204: --
1205:
1206: EXCEPTION
1207: WHEN fnd_api.g_exc_error THEN
1208: wf_core.context (
1209: 'OZF_FundApproval_pvt',
1210: 'Set_ParBudget_Activity_Details',
1211: itemtype,
1216: );
1217: RAISE;
1218: WHEN OTHERS THEN
1219: fnd_msg_pub.count_and_get (
1220: p_encoded=> fnd_api.g_false,
1221: p_count=> l_msg_count,
1222: p_data=> l_msg_data
1223: );
1224: RAISE;
1258: resultout OUT NOCOPY VARCHAR2
1259: ) IS
1260: l_status_code VARCHAR2 (30);
1261: l_api_version CONSTANT NUMBER := 1.0;
1262: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;
1263: l_msg_count NUMBER;
1264: l_msg_data VARCHAR2 (4000);
1265: l_error_msg VARCHAR2 (4000);
1266: l_api_name CONSTANT VARCHAR2 (30) := 'Update_OffrAdj_Status';
1357: );
1358: -- Call Discounts Update API only when effective_date is less than sysdate
1359: OZF_Offer_Backdate_PVT.Update_Offer_Discounts
1360: (
1361: p_init_msg_list => FND_API.G_FALSE
1362: ,p_api_version => l_api_version
1363: ,p_commit => FND_API.G_FALSE
1364: ,x_return_status => l_return_status
1365: ,x_msg_count => l_msg_count
1359: OZF_Offer_Backdate_PVT.Update_Offer_Discounts
1360: (
1361: p_init_msg_list => FND_API.G_FALSE
1362: ,p_api_version => l_api_version
1363: ,p_commit => FND_API.G_FALSE
1364: ,x_return_status => l_return_status
1365: ,x_msg_count => l_msg_count
1366: ,x_msg_data => l_msg_data
1367: ,p_offer_adjustment_id => l_offer_adjustment_id
1366: ,x_msg_data => l_msg_data
1367: ,p_offer_adjustment_id => l_offer_adjustment_id
1368: ) ;
1369: -- END IF;
1370: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1371: RAISE FND_API.G_EXC_ERROR;
1372: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1374: END IF;
1367: ,p_offer_adjustment_id => l_offer_adjustment_id
1368: ) ;
1369: -- END IF;
1370: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1371: RAISE FND_API.G_EXC_ERROR;
1372: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1374: END IF;
1375: -- for active status , call api which activates/ closes adjustment depending on effective date
1368: ) ;
1369: -- END IF;
1370: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1371: RAISE FND_API.G_EXC_ERROR;
1372: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1374: END IF;
1375: -- for active status , call api which activates/ closes adjustment depending on effective date
1376: OZF_Offer_Backdate_PVT.close_adjustment
1369: -- END IF;
1370: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1371: RAISE FND_API.G_EXC_ERROR;
1372: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1374: END IF;
1375: -- for active status , call api which activates/ closes adjustment depending on effective date
1376: OZF_Offer_Backdate_PVT.close_adjustment
1377: (
1379: , x_return_status => l_return_status
1380: , x_msg_count => l_msg_count
1381: , x_msg_data => l_msg_data
1382: );
1383: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1384: RAISE FND_API.G_EXC_ERROR;
1385: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1387: END IF;
1380: , x_msg_count => l_msg_count
1381: , x_msg_data => l_msg_data
1382: );
1383: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1384: RAISE FND_API.G_EXC_ERROR;
1385: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1387: END IF;
1388: else
1381: , x_msg_data => l_msg_data
1382: );
1383: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1384: RAISE FND_API.G_EXC_ERROR;
1385: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1387: END IF;
1388: else
1389: -- for rejected or some other status update the status to next status code
1382: );
1383: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1384: RAISE FND_API.G_EXC_ERROR;
1385: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1387: END IF;
1388: else
1389: -- for rejected or some other status update the status to next status code
1390: UPDATE ozf_offer_adjustments_b
1393: object_version_number = l_object_version_number+1
1394: WHERE offer_adjustment_id = l_offer_adjustment_id;
1395: END IF;
1396: -- Changes done by mthumu
1397: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1398: resultout := 'COMPLETE:SUCCESS';
1399: ELSE
1400: RAISE FND_API.G_EXC_ERROR;
1401: END IF;
1396: -- Changes done by mthumu
1397: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1398: resultout := 'COMPLETE:SUCCESS';
1399: ELSE
1400: RAISE FND_API.G_EXC_ERROR;
1401: END IF;
1402: END IF;
1403:
1404: -- CANCEL mode
1416: RETURN;
1417: END IF;
1418:
1419: fnd_msg_pub.count_and_get (
1420: p_encoded=> fnd_api.g_false,
1421: p_count=> l_msg_count,
1422: p_data=> l_msg_data
1423: );
1424: ozf_utility_pvt.debug_message (
1426: || ': l_return_status'
1427: || l_return_status
1428: );
1429: EXCEPTION
1430: WHEN FND_API.G_EXC_ERROR THEN
1431: FND_MSG_PUB.Count_And_Get (
1432: p_encoded => FND_API.G_FALSE,
1433: p_count => l_msg_count,
1434: p_data => l_msg_data);
1428: );
1429: EXCEPTION
1430: WHEN FND_API.G_EXC_ERROR THEN
1431: FND_MSG_PUB.Count_And_Get (
1432: p_encoded => FND_API.G_FALSE,
1433: p_count => l_msg_count,
1434: p_data => l_msg_data);
1435:
1436: ams_gen_approval_pvt.Handle_Err(
1448: resultout := 'COMPLETE:ERROR';
1449:
1450: WHEN OTHERS THEN
1451: FND_MSG_PUB.Count_And_Get (
1452: p_encoded => FND_API.G_FALSE,
1453: p_count => l_msg_count,
1454: p_data => l_msg_data);
1455:
1456: ams_gen_approval_pvt.Handle_Err(