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

Line 75: l_return_status := fnd_api.g_ret_sts_success;

71: -- Debug info.
72:
73: fnd_msg_pub.initialize;
74:
75: l_return_status := fnd_api.g_ret_sts_success;
76:
77: l_object_id := wf_engine.getitemattrnumber(
78: itemtype => itemtype
79: ,itemkey => itemkey

Line 203: IF l_return_status = fnd_api.g_ret_sts_success THEN

199: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
200: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details','AfterGetApprovalDetails:'||l_return_status||'-'||l_subject);
201: END IF;
202:
203: IF l_return_status = fnd_api.g_ret_sts_success THEN
204:
205: wf_engine.setitemattrnumber(
206: itemtype => itemtype,
207: itemkey => itemkey,

Line 226: RAISE fnd_api.G_EXC_ERROR;

222: RETURN;
223:
224: ELSE
225:
226: RAISE fnd_api.G_EXC_ERROR;
227:
228: END IF;
229: END IF;
230:

Line 251: WHEN fnd_api.G_EXC_ERROR THEN

247: END IF;
248:
249:
250: EXCEPTION
251: WHEN fnd_api.G_EXC_ERROR THEN
252:
253: FND_MSG_PUB.Count_And_Get (
254: p_encoded => FND_API.G_FALSE,
255: p_count => l_msg_count,

Line 254: p_encoded => FND_API.G_FALSE,

250: EXCEPTION
251: WHEN fnd_api.G_EXC_ERROR THEN
252:
253: FND_MSG_PUB.Count_And_Get (
254: p_encoded => FND_API.G_FALSE,
255: p_count => l_msg_count,
256: p_data => l_msg_data
257: );
258: ahl_generic_aprv_pvt.Handle_Error

Line 391: WHEN FND_API.G_EXC_ERROR THEN

387: RETURN;
388:
389: EXCEPTION
390:
391: WHEN FND_API.G_EXC_ERROR THEN
392: FND_MSG_PUB.Count_And_Get (
393: p_encoded => FND_API.G_FALSE,
394: p_count => l_msg_count,
395: p_data => l_msg_data

Line 393: p_encoded => FND_API.G_FALSE,

389: EXCEPTION
390:
391: WHEN FND_API.G_EXC_ERROR THEN
392: FND_MSG_PUB.Count_And_Get (
393: p_encoded => FND_API.G_FALSE,
394: p_count => l_msg_count,
395: p_data => l_msg_data
396: );
397: ahl_generic_aprv_pvt.Handle_Error

Line 517: WHEN FND_API.G_EXC_ERROR THEN

513: RETURN;
514:
515: EXCEPTION
516:
517: WHEN FND_API.G_EXC_ERROR THEN
518: FND_MSG_PUB.Count_And_Get (
519: p_encoded => FND_API.G_FALSE,
520: p_count => l_msg_count,
521: p_data => l_msg_data

Line 519: p_encoded => FND_API.G_FALSE,

515: EXCEPTION
516:
517: WHEN FND_API.G_EXC_ERROR THEN
518: FND_MSG_PUB.Count_And_Get (
519: p_encoded => FND_API.G_FALSE,
520: p_count => l_msg_count,
521: p_data => l_msg_data
522: );
523: ahl_generic_aprv_pvt.Handle_Error

Line 667: WHEN FND_API.G_EXC_ERROR THEN

663:
664: RETURN;
665:
666: EXCEPTION
667: WHEN FND_API.G_EXC_ERROR THEN
668: FND_MSG_PUB.Count_And_Get (
669: p_encoded => FND_API.G_FALSE,
670: p_count => l_msg_count,
671: p_data => l_msg_data

Line 669: p_encoded => FND_API.G_FALSE,

665:
666: EXCEPTION
667: WHEN FND_API.G_EXC_ERROR THEN
668: FND_MSG_PUB.Count_And_Get (
669: p_encoded => FND_API.G_FALSE,
670: p_count => l_msg_count,
671: p_data => l_msg_data
672: );
673: ahl_generic_aprv_pvt.Handle_Error

Line 814: WHEN FND_API.G_EXC_ERROR THEN

810:
811: RETURN;
812:
813: EXCEPTION
814: WHEN FND_API.G_EXC_ERROR THEN
815: FND_MSG_PUB.Count_And_Get (
816: p_encoded => FND_API.G_FALSE,
817: p_count => l_msg_count,
818: p_data => l_msg_data

Line 816: p_encoded => FND_API.G_FALSE,

812:
813: EXCEPTION
814: WHEN FND_API.G_EXC_ERROR THEN
815: FND_MSG_PUB.Count_And_Get (
816: p_encoded => FND_API.G_FALSE,
817: p_count => l_msg_count,
818: p_data => l_msg_data
819: );
820: ahl_generic_aprv_pvt.Handle_Error

Line 970: WHEN FND_API.G_EXC_ERROR THEN

966:
967: RETURN;
968:
969: EXCEPTION
970: WHEN FND_API.G_EXC_ERROR THEN
971: FND_MSG_PUB.Count_And_Get (
972: p_encoded => FND_API.G_FALSE,
973: p_count => l_msg_count,
974: p_data => l_msg_data

Line 972: p_encoded => FND_API.G_FALSE,

968:
969: EXCEPTION
970: WHEN FND_API.G_EXC_ERROR THEN
971: FND_MSG_PUB.Count_And_Get (
972: p_encoded => FND_API.G_FALSE,
973: p_count => l_msg_count,
974: p_data => l_msg_data
975: );
976: ahl_generic_aprv_pvt.Handle_Error

Line 1126: WHEN FND_API.G_EXC_ERROR THEN

1122:
1123: RETURN;
1124:
1125: EXCEPTION
1126: WHEN FND_API.G_EXC_ERROR THEN
1127: FND_MSG_PUB.Count_And_Get (
1128: p_encoded => FND_API.G_FALSE,
1129: p_count => l_msg_count,
1130: p_data => l_msg_data

Line 1128: p_encoded => FND_API.G_FALSE,

1124:
1125: EXCEPTION
1126: WHEN FND_API.G_EXC_ERROR THEN
1127: FND_MSG_PUB.Count_And_Get (
1128: p_encoded => FND_API.G_FALSE,
1129: p_count => l_msg_count,
1130: p_data => l_msg_data
1131: );
1132: ahl_generic_aprv_pvt.Handle_Error

Line 1279: WHEN FND_API.G_EXC_ERROR THEN

1275:
1276: RETURN;
1277:
1278: EXCEPTION
1279: WHEN FND_API.G_EXC_ERROR THEN
1280: FND_MSG_PUB.Count_And_Get (
1281: p_encoded => FND_API.G_FALSE,
1282: p_count => l_msg_count,
1283: p_data => l_msg_data

Line 1281: p_encoded => FND_API.G_FALSE,

1277:
1278: EXCEPTION
1279: WHEN FND_API.G_EXC_ERROR THEN
1280: FND_MSG_PUB.Count_And_Get (
1281: p_encoded => FND_API.G_FALSE,
1282: p_count => l_msg_count,
1283: p_data => l_msg_data
1284: );
1285: ahl_generic_aprv_pvt.Handle_Error

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

1420:
1421:
1422: /*
1423: p_api_version IN NUMBER,
1424: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1425: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1426: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1427: P_DEFAULT IN VARCHAR2 := FND_API.G_FALSE,
1428: P_MODULE_TYPE IN VARCHAR2,

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

1421:
1422: /*
1423: p_api_version IN NUMBER,
1424: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1425: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1426: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1427: P_DEFAULT IN VARCHAR2 := FND_API.G_FALSE,
1428: P_MODULE_TYPE IN VARCHAR2,
1429: x_return_status OUT NOCOPY VARCHAR2,

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

1422: /*
1423: p_api_version IN NUMBER,
1424: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1425: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1426: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1427: P_DEFAULT IN VARCHAR2 := FND_API.G_FALSE,
1428: P_MODULE_TYPE IN VARCHAR2,
1429: x_return_status OUT NOCOPY VARCHAR2,
1430: x_msg_count OUT NOCOPY NUMBER,

Line 1427: P_DEFAULT IN VARCHAR2 := FND_API.G_FALSE,

1423: p_api_version IN NUMBER,
1424: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1425: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1426: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1427: P_DEFAULT IN VARCHAR2 := FND_API.G_FALSE,
1428: P_MODULE_TYPE IN VARCHAR2,
1429: x_return_status OUT NOCOPY VARCHAR2,
1430: x_msg_count OUT NOCOPY NUMBER,
1431: x_msg_data OUT NOCOPY VARCHAR2,

Line 1461: l_return_status := FND_API.G_RET_STS_ERROR;

1457: if (sql%notfound)
1458: then
1459: FND_MESSAGE.Set_Name('AHL','AHL_APRV_OBJ_CHANGED');
1460: FND_MSG_PUB.Add;
1461: l_return_status := FND_API.G_RET_STS_ERROR;
1462: End if;
1463:
1464: IF l_return_Status=fnd_api.g_ret_sts_success
1465: THEN

Line 1464: IF l_return_Status=fnd_api.g_ret_sts_success

1460: FND_MSG_PUB.Add;
1461: l_return_status := FND_API.G_RET_STS_ERROR;
1462: End if;
1463:
1464: IF l_return_Status=fnd_api.g_ret_sts_success
1465: THEN
1466: COMMIT;
1467: ELSE
1468: ROLLBACK;

Line 1492: WHEN fnd_api.g_exc_error THEN

1488: END IF;
1489:
1490:
1491: EXCEPTION
1492: WHEN fnd_api.g_exc_error THEN
1493: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1494: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1495: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details','Error G_exec UpdateSatus:'||sqlerrm);
1496: END IF;

Line 1498: p_encoded => FND_API.G_FALSE,

1494: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1495: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details','Error G_exec UpdateSatus:'||sqlerrm);
1496: END IF;
1497: FND_MSG_PUB.Count_And_Get (
1498: p_encoded => FND_API.G_FALSE,
1499: p_count => l_msg_count,
1500: p_data => l_msg_data
1501: );
1502: ahl_generic_aprv_pvt.Handle_Error

Line 1641: l_return_status := FND_API.G_RET_STS_ERROR;

1637: then
1638: FND_MESSAGE.Set_Name('AHL','AHL_APRV_OBJ_CHANGED');
1639: FND_MSG_PUB.Add;
1640:
1641: l_return_status := FND_API.G_RET_STS_ERROR;
1642: return;
1643:
1644: end if;
1645:

Line 1668: WHEN fnd_api.g_exc_error THEN

1664: END IF;
1665:
1666:
1667: EXCEPTION
1668: WHEN fnd_api.g_exc_error THEN
1669: FND_MSG_PUB.Count_And_Get (
1670: p_encoded => FND_API.G_FALSE,
1671: p_count => l_msg_count,
1672: p_data => l_msg_data

Line 1670: p_encoded => FND_API.G_FALSE,

1666:
1667: EXCEPTION
1668: WHEN fnd_api.g_exc_error THEN
1669: FND_MSG_PUB.Count_And_Get (
1670: p_encoded => FND_API.G_FALSE,
1671: p_count => l_msg_count,
1672: p_data => l_msg_data
1673: );
1674: ahl_generic_aprv_pvt.Handle_Error