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 1175: l_return_status := FND_API.G_RET_STS_SUCCESS;

1171: SAVEPOINT AHL_DEF_UPDATE_STATUS;
1172:
1173: MO_GLOBAL.INIT('AHL');
1174:
1175: l_return_status := FND_API.G_RET_STS_SUCCESS;
1176:
1177: IF (funcmode = 'RUN') THEN
1178:
1179: l_approval_status := wf_engine.getitemattrtext(

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

1267: 'return status after process_approval_rejected API call : ' || l_return_status
1268: );
1269: END IF;
1270:
1271: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
1272: RAISE FND_API.G_EXC_ERROR;
1273: ELSE
1274: COMMIT WORK;
1275: END IF;

Line 1272: RAISE FND_API.G_EXC_ERROR;

1268: );
1269: END IF;
1270:
1271: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
1272: RAISE FND_API.G_EXC_ERROR;
1273: ELSE
1274: COMMIT WORK;
1275: END IF;
1276: resultout := 'COMPLETE:';

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

1288: END IF;
1289:
1290:
1291: EXCEPTION
1292: WHEN fnd_api.G_EXC_ERROR OR FND_API.G_EXC_UNEXPECTED_ERROR THEN
1293: ROLLBACK TO AHL_DEF_UPDATE_STATUS;
1294: FND_MSG_PUB.Count_And_Get (
1295: p_encoded => FND_API.G_FALSE,
1296: p_count => l_msg_count,

Line 1295: p_encoded => FND_API.G_FALSE,

1291: EXCEPTION
1292: WHEN fnd_api.G_EXC_ERROR OR FND_API.G_EXC_UNEXPECTED_ERROR THEN
1293: ROLLBACK TO AHL_DEF_UPDATE_STATUS;
1294: FND_MSG_PUB.Count_And_Get (
1295: p_encoded => FND_API.G_FALSE,
1296: p_count => l_msg_count,
1297: p_data => l_msg_data
1298: );
1299: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

Line 1395: l_return_status := FND_API.G_RET_STS_SUCCESS;

1391: 'At the start of PLSQL procedure'
1392: );
1393: END IF;
1394: SAVEPOINT AHL_DEF_REVT_STATUS;
1395: l_return_status := FND_API.G_RET_STS_SUCCESS;
1396:
1397: IF (funcmode = 'RUN') THEN
1398: l_orig_status := wf_engine.getitemattrText(
1399: itemtype => itemtype,

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

1452: 'return status after process_approval_rejected API call : ' || l_return_status
1453: );
1454: END IF;
1455:
1456: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
1457: RAISE FND_API.G_EXC_ERROR;
1458: ELSE
1459: COMMIT WORK;
1460: END IF;

Line 1457: RAISE FND_API.G_EXC_ERROR;

1453: );
1454: END IF;
1455:
1456: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
1457: RAISE FND_API.G_EXC_ERROR;
1458: ELSE
1459: COMMIT WORK;
1460: END IF;
1461: resultout := 'COMPLETE:';

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

1471: 'At the end of PLSQL procedure'
1472: );
1473: END IF;
1474: EXCEPTION
1475: WHEN fnd_api.G_EXC_ERROR OR FND_API.G_EXC_UNEXPECTED_ERROR THEN
1476: ROLLBACK TO AHL_DEF_REVT_STATUS;
1477: FND_MSG_PUB.Count_And_Get (
1478: p_encoded => FND_API.G_FALSE,
1479: p_count => l_msg_count,

Line 1478: p_encoded => FND_API.G_FALSE,

1474: EXCEPTION
1475: WHEN fnd_api.G_EXC_ERROR OR FND_API.G_EXC_UNEXPECTED_ERROR THEN
1476: ROLLBACK TO AHL_DEF_REVT_STATUS;
1477: FND_MSG_PUB.Count_And_Get (
1478: p_encoded => FND_API.G_FALSE,
1479: p_count => l_msg_count,
1480: p_data => l_msg_data
1481: );
1482: ahl_generic_aprv_pvt.Handle_Error