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

Line 1072: IF l_return_status = fnd_api.g_ret_sts_success THEN

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',

Line 1164: p_encoded=> fnd_api.g_false,

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 (

Line 1207: WHEN fnd_api.g_exc_error THEN

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,

Line 1220: p_encoded=> fnd_api.g_false,

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;

Line 1262: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;

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';

Line 1361: p_init_msg_list => FND_API.G_FALSE

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

Line 1363: ,p_commit => FND_API.G_FALSE

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

Line 1370: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

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;

Line 1371: RAISE FND_API.G_EXC_ERROR;

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

Line 1372: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 1373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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: (

Line 1383: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

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;

Line 1384: RAISE FND_API.G_EXC_ERROR;

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

Line 1385: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 1386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1397: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

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;

Line 1400: RAISE FND_API.G_EXC_ERROR;

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

Line 1420: p_encoded=> fnd_api.g_false,

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 (

Line 1430: WHEN FND_API.G_EXC_ERROR THEN

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);

Line 1432: p_encoded => FND_API.G_FALSE,

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(

Line 1452: p_encoded => FND_API.G_FALSE,

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(