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_PRD_DF_APPR_PVT dependencies on FND_API

Line 69: l_return_status := FND_API.G_RET_STS_SUCCESS;

65: END IF;
66:
67: fnd_msg_pub.initialize;
68:
69: l_return_status := FND_API.G_RET_STS_SUCCESS;
70:
71: l_object_id := wf_engine.getitemattrnumber(
72: itemtype => itemtype
73: ,itemkey => itemkey

Line 106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

102: 'Unit effectivity record not found for unit deferral id : ' || l_object_id
103: );
104: END IF;
105: CLOSE unit_effectivity_id_csr;
106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
107: ELSE
108: AHL_PRD_DF_PVT.get_deferral_details (
109: p_init_msg_list => FND_API.G_FALSE,
110: p_unit_effectivity_id => l_unit_effectivity_id,

Line 109: p_init_msg_list => FND_API.G_FALSE,

105: CLOSE unit_effectivity_id_csr;
106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
107: ELSE
108: AHL_PRD_DF_PVT.get_deferral_details (
109: p_init_msg_list => FND_API.G_FALSE,
110: p_unit_effectivity_id => l_unit_effectivity_id,
111: x_df_header_info_rec => l_df_header_info_rec,
112: x_df_schedules_tbl => l_df_schedules_tbl,
113: x_return_status => l_return_status,

Line 116: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

112: x_df_schedules_tbl => l_df_schedules_tbl,
113: x_return_status => l_return_status,
114: x_msg_count => l_msg_count,
115: x_msg_data => l_msg_data);
116: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
117: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_INV_DF');
118: FND_MESSAGE.SET_TOKEN('DEFERRAL_ID',l_object_id);
119: FND_MSG_PUB.ADD;
120: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)THEN

Line 128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

124: 'ahl.plsql.AHL_PRD_DF_APPR_PVT.Set_Activity_Details',
125: 'Deferral record details not found for unit deferral id : ' || l_object_id
126: );
127: END IF;
128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
129: ELSE
130: IF(l_df_header_info_rec.deferral_type = AHL_PRD_DF_PVT.G_DEFERRAL_TYPE_MR)THEN
131: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_MR_SUBJECT');
132: FND_MESSAGE.SET_TOKEN('MR_TITLE',l_df_header_info_rec.mr_title,false);

Line 171: RAISE FND_API.G_EXC_ERROR;

167: 'ahl.plsql.AHL_PRD_DF_APPR_PVT.Set_Activity_Details',
168: 'Could not set activity details for deferral workflow of unit deferral id : ' || l_object_id
169: );
170: END IF;
171: RAISE FND_API.G_EXC_ERROR;
172: END IF;
173:
174: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
175: fnd_log.string

Line 278: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

274: x_approver_seq => l_approver_seq,
275: x_return_status => l_return_status
276: );
277:
278: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
279:
280: wf_engine.setitemattrnumber(
281: itemtype => itemtype,
282: itemkey => itemkey,

Line 303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

299: 'ahl.plsql.AHL_PRD_DF_APPR_PVT.Set_Activity_Details',
300: 'Could not set activity details for deferral workflow of unit deferral id : ' || l_object_id
301: );
302: END IF;
303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
304: END IF;
305: ELSIF (funcmode IN ('CANCEL','TIMEOUT'))THEN
306: resultout := 'COMPLETE:';
307: END IF;

Line 319: WHEN fnd_api.G_EXC_ERROR OR FND_API.G_EXC_UNEXPECTED_ERROR THEN

315: );
316: END IF;
317:
318: EXCEPTION
319: WHEN fnd_api.G_EXC_ERROR OR FND_API.G_EXC_UNEXPECTED_ERROR THEN
320: FND_MSG_PUB.Count_And_Get(
321: p_encoded => FND_API.G_FALSE,
322: p_count => l_msg_count,
323: p_data => l_msg_data

Line 321: p_encoded => FND_API.G_FALSE,

317:
318: EXCEPTION
319: WHEN fnd_api.G_EXC_ERROR OR FND_API.G_EXC_UNEXPECTED_ERROR THEN
320: FND_MSG_PUB.Count_And_Get(
321: p_encoded => FND_API.G_FALSE,
322: p_count => l_msg_count,
323: p_data => l_msg_data
324: );
325: ahl_generic_aprv_pvt.Handle_Error

Line 436: WHEN fnd_api.G_EXC_ERROR OR FND_API.G_EXC_UNEXPECTED_ERROR THEN

432: );
433: END IF;
434:
435: EXCEPTION
436: WHEN fnd_api.G_EXC_ERROR OR FND_API.G_EXC_UNEXPECTED_ERROR THEN
437: FND_MSG_PUB.Count_And_Get (
438: p_encoded => FND_API.G_FALSE,
439: p_count => l_msg_count,
440: p_data => l_msg_data

Line 438: p_encoded => FND_API.G_FALSE,

434:
435: EXCEPTION
436: WHEN fnd_api.G_EXC_ERROR OR FND_API.G_EXC_UNEXPECTED_ERROR THEN
437: FND_MSG_PUB.Count_And_Get (
438: p_encoded => FND_API.G_FALSE,
439: p_count => l_msg_count,
440: p_data => l_msg_data
441: );
442: ahl_generic_aprv_pvt.Handle_Error

Line 549: WHEN fnd_api.G_EXC_ERROR OR FND_API.G_EXC_UNEXPECTED_ERROR THEN

545: );
546: END IF;
547:
548: EXCEPTION
549: WHEN fnd_api.G_EXC_ERROR OR FND_API.G_EXC_UNEXPECTED_ERROR THEN
550: FND_MSG_PUB.Count_And_Get (
551: p_encoded => FND_API.G_FALSE,
552: p_count => l_msg_count,
553: p_data => l_msg_data

Line 551: p_encoded => FND_API.G_FALSE,

547:
548: EXCEPTION
549: WHEN fnd_api.G_EXC_ERROR OR FND_API.G_EXC_UNEXPECTED_ERROR THEN
550: FND_MSG_PUB.Count_And_Get (
551: p_encoded => FND_API.G_FALSE,
552: p_count => l_msg_count,
553: p_data => l_msg_data
554: );
555: ahl_generic_aprv_pvt.Handle_Error

Line 655: WHEN fnd_api.G_EXC_ERROR OR FND_API.G_EXC_UNEXPECTED_ERROR THEN

651: );
652: END IF;
653:
654: EXCEPTION
655: WHEN fnd_api.G_EXC_ERROR OR FND_API.G_EXC_UNEXPECTED_ERROR THEN
656: FND_MSG_PUB.Count_And_Get (
657: p_encoded => FND_API.G_FALSE,
658: p_count => l_msg_count,
659: p_data => l_msg_data

Line 657: p_encoded => FND_API.G_FALSE,

653:
654: EXCEPTION
655: WHEN fnd_api.G_EXC_ERROR OR FND_API.G_EXC_UNEXPECTED_ERROR THEN
656: FND_MSG_PUB.Count_And_Get (
657: p_encoded => FND_API.G_FALSE,
658: p_count => l_msg_count,
659: p_data => l_msg_data
660: );
661: ahl_generic_aprv_pvt.Handle_Error

Line 769: WHEN fnd_api.G_EXC_ERROR OR FND_API.G_EXC_UNEXPECTED_ERROR THEN

765: );
766: END IF;
767:
768: EXCEPTION
769: WHEN fnd_api.G_EXC_ERROR OR FND_API.G_EXC_UNEXPECTED_ERROR THEN
770: FND_MSG_PUB.Count_And_Get (
771: p_encoded => FND_API.G_FALSE,
772: p_count => l_msg_count,
773: p_data => l_msg_data

Line 771: p_encoded => FND_API.G_FALSE,

767:
768: EXCEPTION
769: WHEN fnd_api.G_EXC_ERROR OR FND_API.G_EXC_UNEXPECTED_ERROR THEN
770: FND_MSG_PUB.Count_And_Get (
771: p_encoded => FND_API.G_FALSE,
772: p_count => l_msg_count,
773: p_data => l_msg_data
774: );
775: ahl_generic_aprv_pvt.Handle_Error

Line 884: WHEN fnd_api.G_EXC_ERROR OR FND_API.G_EXC_UNEXPECTED_ERROR THEN

880: );
881: END IF;
882:
883: EXCEPTION
884: WHEN fnd_api.G_EXC_ERROR OR FND_API.G_EXC_UNEXPECTED_ERROR THEN
885: FND_MSG_PUB.Count_And_Get (
886: p_encoded => FND_API.G_FALSE,
887: p_count => l_msg_count,
888: p_data => l_msg_data

Line 886: p_encoded => FND_API.G_FALSE,

882:
883: EXCEPTION
884: WHEN fnd_api.G_EXC_ERROR OR FND_API.G_EXC_UNEXPECTED_ERROR THEN
885: FND_MSG_PUB.Count_And_Get (
886: p_encoded => FND_API.G_FALSE,
887: p_count => l_msg_count,
888: p_data => l_msg_data
889: );
890: ahl_generic_aprv_pvt.Handle_Error

Line 1001: WHEN fnd_api.G_EXC_ERROR OR FND_API.G_EXC_UNEXPECTED_ERROR THEN

997: );
998: END IF;
999:
1000: EXCEPTION
1001: WHEN fnd_api.G_EXC_ERROR OR FND_API.G_EXC_UNEXPECTED_ERROR THEN
1002: FND_MSG_PUB.Count_And_Get (
1003: p_encoded => FND_API.G_FALSE,
1004: p_count => l_msg_count,
1005: p_data => l_msg_data

Line 1003: p_encoded => FND_API.G_FALSE,

999:
1000: EXCEPTION
1001: WHEN fnd_api.G_EXC_ERROR OR FND_API.G_EXC_UNEXPECTED_ERROR THEN
1002: FND_MSG_PUB.Count_And_Get (
1003: p_encoded => FND_API.G_FALSE,
1004: p_count => l_msg_count,
1005: p_data => l_msg_data
1006: );
1007: ahl_generic_aprv_pvt.Handle_Error

Line 1123: WHEN fnd_api.G_EXC_ERROR OR FND_API.G_EXC_UNEXPECTED_ERROR THEN

1119: );
1120: END IF;
1121:
1122: EXCEPTION
1123: WHEN fnd_api.G_EXC_ERROR OR FND_API.G_EXC_UNEXPECTED_ERROR THEN
1124: FND_MSG_PUB.Count_And_Get (
1125: p_encoded => FND_API.G_FALSE,
1126: p_count => l_msg_count,
1127: p_data => l_msg_data

Line 1125: p_encoded => FND_API.G_FALSE,

1121:
1122: EXCEPTION
1123: WHEN fnd_api.G_EXC_ERROR OR FND_API.G_EXC_UNEXPECTED_ERROR THEN
1124: FND_MSG_PUB.Count_And_Get (
1125: p_encoded => FND_API.G_FALSE,
1126: p_count => l_msg_count,
1127: p_data => l_msg_data
1128: );
1129: ahl_generic_aprv_pvt.Handle_Error

Line 1184: l_return_status := FND_API.G_RET_STS_SUCCESS;

1180: SAVEPOINT AHL_DEF_UPDATE_STATUS;
1181:
1182: MO_GLOBAL.INIT('AHL');
1183:
1184: l_return_status := FND_API.G_RET_STS_SUCCESS;
1185:
1186: IF (funcmode = 'RUN') THEN
1187:
1188: l_approval_status := wf_engine.getitemattrtext(

Line 1260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1256: FND_MESSAGE.SET_NAME('AHL', 'AHL_PRD_DF_APPR_INV_DF');
1257: FND_MESSAGE.SET_TOKEN('DEFERRAL_ID',l_object_id);
1258: FND_MSG_PUB.ADD;
1259: CLOSE unit_effectivity_id_csr;
1260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1261: ELSE
1262: AHL_PRD_DF_PVT.get_deferral_details (
1263: p_init_msg_list => FND_API.G_FALSE,
1264: p_unit_effectivity_id => l_unit_effectivity_id,

Line 1263: p_init_msg_list => FND_API.G_FALSE,

1259: CLOSE unit_effectivity_id_csr;
1260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1261: ELSE
1262: AHL_PRD_DF_PVT.get_deferral_details (
1263: p_init_msg_list => FND_API.G_FALSE,
1264: p_unit_effectivity_id => l_unit_effectivity_id,
1265: x_df_header_info_rec => l_df_header_info_rec,
1266: x_df_schedules_tbl => l_df_schedules_tbl,
1267: x_return_status => l_return_status,

Line 1270: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1266: x_df_schedules_tbl => l_df_schedules_tbl,
1267: x_return_status => l_return_status,
1268: x_msg_count => l_msg_count,
1269: x_msg_data => l_msg_data);
1270: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1271: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_INV_DF');
1272: FND_MESSAGE.SET_TOKEN('DEFERRAL_ID',l_object_id);
1273: FND_MSG_PUB.ADD;
1274: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1274: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1270: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1271: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_PRD_DF_APPR_INV_DF');
1272: FND_MESSAGE.SET_TOKEN('DEFERRAL_ID',l_object_id);
1273: FND_MSG_PUB.ADD;
1274: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1275: ELSE
1276: IF(l_df_header_info_rec.deferral_type = AHL_PRD_DF_PVT.G_DEFERRAL_TYPE_MR AND
1277: l_df_header_info_rec.MR_APPL_EXPIRED = FND_API.G_TRUE)THEN
1278:

Line 1277: l_df_header_info_rec.MR_APPL_EXPIRED = FND_API.G_TRUE)THEN

1273: FND_MSG_PUB.ADD;
1274: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1275: ELSE
1276: IF(l_df_header_info_rec.deferral_type = AHL_PRD_DF_PVT.G_DEFERRAL_TYPE_MR AND
1277: l_df_header_info_rec.MR_APPL_EXPIRED = FND_API.G_TRUE)THEN
1278:
1279: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DF_MR_EXPIRED');
1280: l_msg_data := FND_MESSAGE.get;
1281: UPDATE AHL_UNIT_DEFERRALS_TL

Line 1343: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS)THEN

1339: 'return status after process_approval_rejected API call : ' || l_return_status
1340: );
1341: END IF;
1342:
1343: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
1344: RAISE FND_API.G_EXC_ERROR;
1345: ELSE
1346: COMMIT WORK;
1347: END IF;

Line 1344: RAISE FND_API.G_EXC_ERROR;

1340: );
1341: END IF;
1342:
1343: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
1344: RAISE FND_API.G_EXC_ERROR;
1345: ELSE
1346: COMMIT WORK;
1347: END IF;
1348: resultout := 'COMPLETE:';

Line 1364: WHEN fnd_api.G_EXC_ERROR OR FND_API.G_EXC_UNEXPECTED_ERROR THEN

1360: END IF;
1361:
1362:
1363: EXCEPTION
1364: WHEN fnd_api.G_EXC_ERROR OR FND_API.G_EXC_UNEXPECTED_ERROR THEN
1365: ROLLBACK TO AHL_DEF_UPDATE_STATUS;
1366: FND_MSG_PUB.Count_And_Get (
1367: p_encoded => FND_API.G_FALSE,
1368: p_count => l_msg_count,

Line 1367: p_encoded => FND_API.G_FALSE,

1363: EXCEPTION
1364: WHEN fnd_api.G_EXC_ERROR OR FND_API.G_EXC_UNEXPECTED_ERROR THEN
1365: ROLLBACK TO AHL_DEF_UPDATE_STATUS;
1366: FND_MSG_PUB.Count_And_Get (
1367: p_encoded => FND_API.G_FALSE,
1368: p_count => l_msg_count,
1369: p_data => l_msg_data
1370: );
1371: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

Line 1467: l_return_status := FND_API.G_RET_STS_SUCCESS;

1463: 'At the start of PLSQL procedure'
1464: );
1465: END IF;
1466: SAVEPOINT AHL_DEF_REVT_STATUS;
1467: l_return_status := FND_API.G_RET_STS_SUCCESS;
1468:
1469: IF (funcmode = 'RUN') THEN
1470: l_orig_status := wf_engine.getitemattrText(
1471: itemtype => itemtype,

Line 1528: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS)THEN

1524: 'return status after process_approval_rejected API call : ' || l_return_status
1525: );
1526: END IF;
1527:
1528: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
1529: RAISE FND_API.G_EXC_ERROR;
1530: ELSE
1531: COMMIT WORK;
1532: END IF;

Line 1529: RAISE FND_API.G_EXC_ERROR;

1525: );
1526: END IF;
1527:
1528: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
1529: RAISE FND_API.G_EXC_ERROR;
1530: ELSE
1531: COMMIT WORK;
1532: END IF;
1533: resultout := 'COMPLETE:';

Line 1547: WHEN fnd_api.G_EXC_ERROR OR FND_API.G_EXC_UNEXPECTED_ERROR THEN

1543: 'At the end of PLSQL procedure'
1544: );
1545: END IF;
1546: EXCEPTION
1547: WHEN fnd_api.G_EXC_ERROR OR FND_API.G_EXC_UNEXPECTED_ERROR THEN
1548: ROLLBACK TO AHL_DEF_REVT_STATUS;
1549: FND_MSG_PUB.Count_And_Get (
1550: p_encoded => FND_API.G_FALSE,
1551: p_count => l_msg_count,

Line 1550: p_encoded => FND_API.G_FALSE,

1546: EXCEPTION
1547: WHEN fnd_api.G_EXC_ERROR OR FND_API.G_EXC_UNEXPECTED_ERROR THEN
1548: ROLLBACK TO AHL_DEF_REVT_STATUS;
1549: FND_MSG_PUB.Count_And_Get (
1550: p_encoded => FND_API.G_FALSE,
1551: p_count => l_msg_count,
1552: p_data => l_msg_data
1553: );
1554: ahl_generic_aprv_pvt.Handle_Error