DBA Data[Home] [Help]

APPS.AHL_ITEMCOMP_APPROVAL_PVT dependencies on FND_API

Line 83: l_return_status := fnd_api.g_ret_sts_success;

79: -- Debug info.
80:
81: fnd_msg_pub.initialize;
82:
83: l_return_status := fnd_api.g_ret_sts_success;
84:
85: l_object_id := wf_engine.getitemattrnumber(
86: itemtype => itemtype
87: ,itemkey => itemkey

Line 238: IF l_return_status = fnd_api.g_ret_sts_success THEN

234: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
235: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details','AfterGetApprovalDetails:'||l_return_status||'-'||l_subject);
236: END IF;
237:
238: IF l_return_status = fnd_api.g_ret_sts_success THEN
239:
240: wf_engine.setitemattrnumber(
241: itemtype => itemtype,
242: itemkey => itemkey,

Line 261: RAISE fnd_api.G_EXC_ERROR;

257: RETURN;
258:
259: ELSE
260:
261: RAISE fnd_api.G_EXC_ERROR;
262:
263: END IF;
264: END IF;
265:

Line 286: WHEN fnd_api.G_EXC_ERROR THEN

282: END IF;
283:
284:
285: EXCEPTION
286: WHEN fnd_api.G_EXC_ERROR THEN
287:
288: FND_MSG_PUB.Count_And_Get (
289: p_encoded => FND_API.G_FALSE,
290: p_count => l_msg_count,

Line 289: p_encoded => FND_API.G_FALSE,

285: EXCEPTION
286: WHEN fnd_api.G_EXC_ERROR THEN
287:
288: FND_MSG_PUB.Count_And_Get (
289: p_encoded => FND_API.G_FALSE,
290: p_count => l_msg_count,
291: p_data => l_msg_data
292: );
293: ahl_generic_aprv_pvt.Handle_Error

Line 426: WHEN FND_API.G_EXC_ERROR THEN

422: RETURN;
423:
424: EXCEPTION
425:
426: WHEN FND_API.G_EXC_ERROR THEN
427: FND_MSG_PUB.Count_And_Get (
428: p_encoded => FND_API.G_FALSE,
429: p_count => l_msg_count,
430: p_data => l_msg_data

Line 428: p_encoded => FND_API.G_FALSE,

424: EXCEPTION
425:
426: WHEN FND_API.G_EXC_ERROR THEN
427: FND_MSG_PUB.Count_And_Get (
428: p_encoded => FND_API.G_FALSE,
429: p_count => l_msg_count,
430: p_data => l_msg_data
431: );
432: ahl_generic_aprv_pvt.Handle_Error

Line 554: WHEN FND_API.G_EXC_ERROR THEN

550: RETURN;
551:
552: EXCEPTION
553:
554: WHEN FND_API.G_EXC_ERROR THEN
555: FND_MSG_PUB.Count_And_Get (
556: p_encoded => FND_API.G_FALSE,
557: p_count => l_msg_count,
558: p_data => l_msg_data

Line 556: p_encoded => FND_API.G_FALSE,

552: EXCEPTION
553:
554: WHEN FND_API.G_EXC_ERROR THEN
555: FND_MSG_PUB.Count_And_Get (
556: p_encoded => FND_API.G_FALSE,
557: p_count => l_msg_count,
558: p_data => l_msg_data
559: );
560: ahl_generic_aprv_pvt.Handle_Error

Line 706: WHEN FND_API.G_EXC_ERROR THEN

702:
703: RETURN;
704:
705: EXCEPTION
706: WHEN FND_API.G_EXC_ERROR THEN
707: FND_MSG_PUB.Count_And_Get (
708: p_encoded => FND_API.G_FALSE,
709: p_count => l_msg_count,
710: p_data => l_msg_data

Line 708: p_encoded => FND_API.G_FALSE,

704:
705: EXCEPTION
706: WHEN FND_API.G_EXC_ERROR THEN
707: FND_MSG_PUB.Count_And_Get (
708: p_encoded => FND_API.G_FALSE,
709: p_count => l_msg_count,
710: p_data => l_msg_data
711: );
712: ahl_generic_aprv_pvt.Handle_Error

Line 854: WHEN FND_API.G_EXC_ERROR THEN

850:
851: RETURN;
852:
853: EXCEPTION
854: WHEN FND_API.G_EXC_ERROR THEN
855: FND_MSG_PUB.Count_And_Get (
856: p_encoded => FND_API.G_FALSE,
857: p_count => l_msg_count,
858: p_data => l_msg_data

Line 856: p_encoded => FND_API.G_FALSE,

852:
853: EXCEPTION
854: WHEN FND_API.G_EXC_ERROR THEN
855: FND_MSG_PUB.Count_And_Get (
856: p_encoded => FND_API.G_FALSE,
857: p_count => l_msg_count,
858: p_data => l_msg_data
859: );
860: ahl_generic_aprv_pvt.Handle_Error

Line 1010: WHEN FND_API.G_EXC_ERROR THEN

1006:
1007: RETURN;
1008:
1009: EXCEPTION
1010: WHEN FND_API.G_EXC_ERROR THEN
1011: FND_MSG_PUB.Count_And_Get (
1012: p_encoded => FND_API.G_FALSE,
1013: p_count => l_msg_count,
1014: p_data => l_msg_data

Line 1012: p_encoded => FND_API.G_FALSE,

1008:
1009: EXCEPTION
1010: WHEN FND_API.G_EXC_ERROR THEN
1011: FND_MSG_PUB.Count_And_Get (
1012: p_encoded => FND_API.G_FALSE,
1013: p_count => l_msg_count,
1014: p_data => l_msg_data
1015: );
1016: ahl_generic_aprv_pvt.Handle_Error

Line 1166: WHEN FND_API.G_EXC_ERROR THEN

1162:
1163: RETURN;
1164:
1165: EXCEPTION
1166: WHEN FND_API.G_EXC_ERROR THEN
1167: FND_MSG_PUB.Count_And_Get (
1168: p_encoded => FND_API.G_FALSE,
1169: p_count => l_msg_count,
1170: p_data => l_msg_data

Line 1168: p_encoded => FND_API.G_FALSE,

1164:
1165: EXCEPTION
1166: WHEN FND_API.G_EXC_ERROR THEN
1167: FND_MSG_PUB.Count_And_Get (
1168: p_encoded => FND_API.G_FALSE,
1169: p_count => l_msg_count,
1170: p_data => l_msg_data
1171: );
1172: ahl_generic_aprv_pvt.Handle_Error

Line 1315: WHEN FND_API.G_EXC_ERROR THEN

1311:
1312: RETURN;
1313:
1314: EXCEPTION
1315: WHEN FND_API.G_EXC_ERROR THEN
1316: FND_MSG_PUB.Count_And_Get (
1317: p_encoded => FND_API.G_FALSE,
1318: p_count => l_msg_count,
1319: p_data => l_msg_data

Line 1317: p_encoded => FND_API.G_FALSE,

1313:
1314: EXCEPTION
1315: WHEN FND_API.G_EXC_ERROR THEN
1316: FND_MSG_PUB.Count_And_Get (
1317: p_encoded => FND_API.G_FALSE,
1318: p_count => l_msg_count,
1319: p_data => l_msg_data
1320: );
1321: ahl_generic_aprv_pvt.Handle_Error

Line 1484: l_return_status := FND_API.G_RET_STS_ERROR;

1480: if (sql%notfound)
1481: then
1482: FND_MESSAGE.Set_Name('AHL','AHL_APRV_OBJ_CHANGED');
1483: FND_MSG_PUB.Add;
1484: l_return_status := FND_API.G_RET_STS_ERROR;
1485: End if;
1486:
1487: IF l_return_Status=fnd_api.g_ret_sts_success
1488: THEN

Line 1487: IF l_return_Status=fnd_api.g_ret_sts_success

1483: FND_MSG_PUB.Add;
1484: l_return_status := FND_API.G_RET_STS_ERROR;
1485: End if;
1486:
1487: IF l_return_Status=fnd_api.g_ret_sts_success
1488: THEN
1489: COMMIT;
1490: ELSE
1491: ROLLBACK;

Line 1515: WHEN fnd_api.g_exc_error THEN

1511: END IF;
1512:
1513:
1514: EXCEPTION
1515: WHEN fnd_api.g_exc_error THEN
1516: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1517: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1518: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details','Error G_exec UpdateSatus:'||sqlerrm);
1519: END IF;

Line 1521: p_encoded => FND_API.G_FALSE,

1517: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1518: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details','Error G_exec UpdateSatus:'||sqlerrm);
1519: END IF;
1520: FND_MSG_PUB.Count_And_Get (
1521: p_encoded => FND_API.G_FALSE,
1522: p_count => l_msg_count,
1523: p_data => l_msg_data
1524: );
1525: ahl_generic_aprv_pvt.Handle_Error

Line 1655: l_return_status := FND_API.G_RET_STS_ERROR;

1651: then
1652: FND_MESSAGE.Set_Name('AHL','AHL_APRV_OBJ_CHANGED');
1653: FND_MSG_PUB.Add;
1654:
1655: l_return_status := FND_API.G_RET_STS_ERROR;
1656: return;
1657:
1658: end if;
1659:

Line 1682: WHEN fnd_api.g_exc_error THEN

1678: END IF;
1679:
1680:
1681: EXCEPTION
1682: WHEN fnd_api.g_exc_error THEN
1683: FND_MSG_PUB.Count_And_Get (
1684: p_encoded => FND_API.G_FALSE,
1685: p_count => l_msg_count,
1686: p_data => l_msg_data

Line 1684: p_encoded => FND_API.G_FALSE,

1680:
1681: EXCEPTION
1682: WHEN fnd_api.g_exc_error THEN
1683: FND_MSG_PUB.Count_And_Get (
1684: p_encoded => FND_API.G_FALSE,
1685: p_count => l_msg_count,
1686: p_data => l_msg_data
1687: );
1688: ahl_generic_aprv_pvt.Handle_Error