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 1071: IF l_return_status = fnd_api.g_ret_sts_success THEN

1067: x_approver_seq=> l_approver_seq,
1068: x_return_status=> l_return_status
1069: );
1070:
1071: IF l_return_status = fnd_api.g_ret_sts_success THEN
1072: wf_engine.setitemattrnumber (
1073: itemtype=> itemtype,
1074: itemkey=> itemkey,
1075: aname => 'AMS_APPROVAL_DETAIL_ID',

Line 1163: p_encoded=> fnd_api.g_false,

1159: resultout := 'COMPLETE:SUCCESS';
1160:
1161: ELSE
1162: fnd_msg_pub.count_and_get (
1163: p_encoded=> fnd_api.g_false,
1164: p_count=> l_msg_count,
1165: p_data=> l_msg_data
1166: );
1167: ams_gen_approval_pvt.handle_err (

Line 1206: WHEN fnd_api.g_exc_error THEN

1202: END IF;
1203: --
1204:
1205: EXCEPTION
1206: WHEN fnd_api.g_exc_error THEN
1207: wf_core.context (
1208: 'OZF_FundApproval_pvt',
1209: 'Set_ParBudget_Activity_Details',
1210: itemtype,

Line 1219: p_encoded=> fnd_api.g_false,

1215: );
1216: RAISE;
1217: WHEN OTHERS THEN
1218: fnd_msg_pub.count_and_get (
1219: p_encoded=> fnd_api.g_false,
1220: p_count=> l_msg_count,
1221: p_data=> l_msg_data
1222: );
1223: RAISE;

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

1257: resultout OUT NOCOPY VARCHAR2
1258: ) IS
1259: l_status_code VARCHAR2 (30);
1260: l_api_version CONSTANT NUMBER := 1.0;
1261: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;
1262: l_msg_count NUMBER;
1263: l_msg_data VARCHAR2 (4000);
1264: l_error_msg VARCHAR2 (4000);
1265: l_api_name CONSTANT VARCHAR2 (30) := 'Update_OffrAdj_Status';

Line 1360: p_init_msg_list => FND_API.G_FALSE

1356: );
1357: -- Call Discounts Update API only when effective_date is less than sysdate
1358: OZF_Offer_Backdate_PVT.Update_Offer_Discounts
1359: (
1360: p_init_msg_list => FND_API.G_FALSE
1361: ,p_api_version => l_api_version
1362: ,p_commit => FND_API.G_FALSE
1363: ,x_return_status => l_return_status
1364: ,x_msg_count => l_msg_count

Line 1362: ,p_commit => FND_API.G_FALSE

1358: OZF_Offer_Backdate_PVT.Update_Offer_Discounts
1359: (
1360: p_init_msg_list => FND_API.G_FALSE
1361: ,p_api_version => l_api_version
1362: ,p_commit => FND_API.G_FALSE
1363: ,x_return_status => l_return_status
1364: ,x_msg_count => l_msg_count
1365: ,x_msg_data => l_msg_data
1366: ,p_offer_adjustment_id => l_offer_adjustment_id

Line 1369: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1365: ,x_msg_data => l_msg_data
1366: ,p_offer_adjustment_id => l_offer_adjustment_id
1367: ) ;
1368: -- END IF;
1369: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1370: RAISE FND_API.G_EXC_ERROR;
1371: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1373: END IF;

Line 1370: RAISE FND_API.G_EXC_ERROR;

1366: ,p_offer_adjustment_id => l_offer_adjustment_id
1367: ) ;
1368: -- END IF;
1369: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1370: RAISE FND_API.G_EXC_ERROR;
1371: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1373: END IF;
1374: -- for active status , call api which activates/ closes adjustment depending on effective date

Line 1371: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1367: ) ;
1368: -- END IF;
1369: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1370: RAISE FND_API.G_EXC_ERROR;
1371: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1373: END IF;
1374: -- for active status , call api which activates/ closes adjustment depending on effective date
1375: OZF_Offer_Backdate_PVT.close_adjustment

Line 1372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1368: -- END IF;
1369: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1370: RAISE FND_API.G_EXC_ERROR;
1371: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1373: END IF;
1374: -- for active status , call api which activates/ closes adjustment depending on effective date
1375: OZF_Offer_Backdate_PVT.close_adjustment
1376: (

Line 1382: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1378: , x_return_status => l_return_status
1379: , x_msg_count => l_msg_count
1380: , x_msg_data => l_msg_data
1381: );
1382: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1383: RAISE FND_API.G_EXC_ERROR;
1384: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1385: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1386: END IF;

Line 1383: RAISE FND_API.G_EXC_ERROR;

1379: , x_msg_count => l_msg_count
1380: , x_msg_data => l_msg_data
1381: );
1382: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1383: RAISE FND_API.G_EXC_ERROR;
1384: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1385: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1386: END IF;
1387: else

Line 1384: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1380: , x_msg_data => l_msg_data
1381: );
1382: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1383: RAISE FND_API.G_EXC_ERROR;
1384: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1385: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1386: END IF;
1387: else
1388: -- for rejected or some other status update the status to next status code

Line 1385: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1381: );
1382: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1383: RAISE FND_API.G_EXC_ERROR;
1384: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1385: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1386: END IF;
1387: else
1388: -- for rejected or some other status update the status to next status code
1389: UPDATE ozf_offer_adjustments_b

Line 1396: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1392: object_version_number = l_object_version_number+1
1393: WHERE offer_adjustment_id = l_offer_adjustment_id;
1394: END IF;
1395: -- Changes done by mthumu
1396: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1397: resultout := 'COMPLETE:SUCCESS';
1398: ELSE
1399: RAISE FND_API.G_EXC_ERROR;
1400: END IF;

Line 1399: RAISE FND_API.G_EXC_ERROR;

1395: -- Changes done by mthumu
1396: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1397: resultout := 'COMPLETE:SUCCESS';
1398: ELSE
1399: RAISE FND_API.G_EXC_ERROR;
1400: END IF;
1401: END IF;
1402:
1403: -- CANCEL mode

Line 1419: p_encoded=> fnd_api.g_false,

1415: RETURN;
1416: END IF;
1417:
1418: fnd_msg_pub.count_and_get (
1419: p_encoded=> fnd_api.g_false,
1420: p_count=> l_msg_count,
1421: p_data=> l_msg_data
1422: );
1423: ozf_utility_pvt.debug_message (

Line 1429: WHEN FND_API.G_EXC_ERROR THEN

1425: || ': l_return_status'
1426: || l_return_status
1427: );
1428: EXCEPTION
1429: WHEN FND_API.G_EXC_ERROR THEN
1430: FND_MSG_PUB.Count_And_Get (
1431: p_encoded => FND_API.G_FALSE,
1432: p_count => l_msg_count,
1433: p_data => l_msg_data);

Line 1431: p_encoded => FND_API.G_FALSE,

1427: );
1428: EXCEPTION
1429: WHEN FND_API.G_EXC_ERROR THEN
1430: FND_MSG_PUB.Count_And_Get (
1431: p_encoded => FND_API.G_FALSE,
1432: p_count => l_msg_count,
1433: p_data => l_msg_data);
1434:
1435: ams_gen_approval_pvt.Handle_Err(

Line 1451: p_encoded => FND_API.G_FALSE,

1447: resultout := 'COMPLETE:ERROR';
1448:
1449: WHEN OTHERS THEN
1450: FND_MSG_PUB.Count_And_Get (
1451: p_encoded => FND_API.G_FALSE,
1452: p_count => l_msg_count,
1453: p_data => l_msg_data);
1454:
1455: ams_gen_approval_pvt.Handle_Err(