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

Line 55: l_return_status := FND_API.g_ret_sts_success;

51:
52: --Initiliaze message list
53: fnd_msg_pub.initialize;
54:
55: l_return_status := FND_API.g_ret_sts_success;
56:
57: l_object_id := wf_engine.getitemattrnumber( itemtype => itemtype
58: ,itemkey => itemkey
59: ,aname => 'OBJECT_ID');

Line 84: RAISE FND_API.G_EXC_ERROR;

80: FETCH get_uc_header_det into l_uc_header_rec;
81: IF get_uc_header_det%NOTFOUND THEN
82: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
83: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
84: RAISE FND_API.G_EXC_ERROR;
85: END IF;
86: CLOSE get_uc_header_det;
87:
88: --

Line 239: IF l_return_status = FND_API.g_ret_sts_success THEN

235: AHL_DEBUG_PUB.debug('UC-ACL: SET_ACTIVITY_DETAILS -- l_approver_seq='||l_approver_seq);
236: AHL_DEBUG_PUB.debug('UC-ACL: SET_ACTIVITY_DETAILS -- l_return_status='||l_return_status);
237: END IF;
238:
239: IF l_return_status = FND_API.g_ret_sts_success THEN
240:
241: wf_engine.setitemattrnumber
242: (
243: itemtype => itemtype,

Line 269: RAISE FND_API.G_EXC_ERROR;

265: resultout := 'COMPLETE:SUCCESS';
266: RETURN;
267:
268: ELSE
269: RAISE FND_API.G_EXC_ERROR;
270: END IF;
271: END IF; -- RUN MODE
272:
273: --

Line 296: WHEN FND_API.G_EXC_ERROR THEN

292: RETURN;
293: END IF;
294:
295: EXCEPTION
296: WHEN FND_API.G_EXC_ERROR THEN
297: FND_MSG_PUB.Count_And_Get
298: (
299: p_encoded => FND_API.G_FALSE,
300: p_count => l_msg_count,

Line 299: p_encoded => FND_API.G_FALSE,

295: EXCEPTION
296: WHEN FND_API.G_EXC_ERROR THEN
297: FND_MSG_PUB.Count_And_Get
298: (
299: p_encoded => FND_API.G_FALSE,
300: p_count => l_msg_count,
301: p_data => l_msg_data
302: );
303: AHL_GENERIC_APRV_PVT.handle_error

Line 412: RAISE FND_API.G_EXC_ERROR;

408:
409: IF get_uc_header_det%NOTFOUND THEN
410: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
411: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
412: RAISE FND_API.G_EXC_ERROR;
413: ELSE
414: fnd_message.set_name('AHL', 'AHL_UC_NTF_FWD_FYI_FWD');
415: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
416: fnd_message.set_token('NAME',l_uc_header_rec.name, false);

Line 434: WHEN FND_API.G_EXC_ERROR THEN

430: COMMIT;
431: RETURN;
432:
433: EXCEPTION
434: WHEN FND_API.G_EXC_ERROR THEN
435: FND_MSG_PUB.Count_And_Get
436: (
437: p_encoded => FND_API.G_FALSE,
438: p_count => l_msg_count,

Line 437: p_encoded => FND_API.G_FALSE,

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

Line 547: RAISE FND_API.G_EXC_ERROR;

543: IF get_uc_header_det%NOTFOUND
544: THEN
545: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
546: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
547: RAISE FND_API.G_EXC_ERROR;
548: ELSE
549: fnd_message.set_name('AHL', 'AHL_UC_NTF_FWD_FYI_APPRVD');
550: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
551: fnd_message.set_token('NAME',l_uc_header_rec.name, false);

Line 568: WHEN FND_API.G_EXC_ERROR THEN

564:
565: RETURN;
566:
567: EXCEPTION
568: WHEN FND_API.G_EXC_ERROR THEN
569: FND_MSG_PUB.Count_And_Get
570: (
571: p_encoded => FND_API.G_FALSE,
572: p_count => l_msg_count,

Line 571: p_encoded => FND_API.G_FALSE,

567: EXCEPTION
568: WHEN FND_API.G_EXC_ERROR THEN
569: FND_MSG_PUB.Count_And_Get
570: (
571: p_encoded => FND_API.G_FALSE,
572: p_count => l_msg_count,
573: p_data => l_msg_data
574: );
575: AHL_GENERIC_APRV_PVT.Handle_Error

Line 678: RAISE FND_API.G_EXC_ERROR;

674:
675: IF get_uc_header_det%NOTFOUND THEN
676: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
677: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
678: RAISE FND_API.G_EXC_ERROR;
679: ELSE
680: fnd_message.set_name('AHL', 'AHL_UC_NTF_FWD_FYI_FINAL');
681: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
682: fnd_message.set_token('NAME',l_uc_header_rec.name, false);

Line 698: WHEN FND_API.G_EXC_ERROR THEN

694:
695: RETURN;
696:
697: EXCEPTION
698: WHEN FND_API.G_EXC_ERROR THEN
699: FND_MSG_PUB.Count_And_Get
700: (
701: p_encoded => FND_API.G_FALSE,
702: p_count => l_msg_count,

Line 701: p_encoded => FND_API.G_FALSE,

697: EXCEPTION
698: WHEN FND_API.G_EXC_ERROR THEN
699: FND_MSG_PUB.Count_And_Get
700: (
701: p_encoded => FND_API.G_FALSE,
702: p_count => l_msg_count,
703: p_data => l_msg_data
704: );
705: AHL_GENERIC_APRV_PVT.Handle_Error

Line 809: RAISE FND_API.G_EXC_ERROR;

805:
806: IF get_uc_header_det%NOTFOUND THEN
807: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
808: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
809: RAISE FND_API.G_EXC_ERROR;
810: ELSE
811: fnd_message.set_name('AHL', 'AHL_UC_NTF_FWD_FYI_RJCT');
812: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
813: fnd_message.set_token('NAME',l_uc_header_rec.name, false);

Line 830: WHEN FND_API.G_EXC_ERROR THEN

826:
827: RETURN;
828:
829: EXCEPTION
830: WHEN FND_API.G_EXC_ERROR THEN
831: FND_MSG_PUB.Count_And_Get
832: (
833: p_encoded => FND_API.G_FALSE,
834: p_count => l_msg_count,

Line 833: p_encoded => FND_API.G_FALSE,

829: EXCEPTION
830: WHEN FND_API.G_EXC_ERROR THEN
831: FND_MSG_PUB.Count_And_Get
832: (
833: p_encoded => FND_API.G_FALSE,
834: p_count => l_msg_count,
835: p_data => l_msg_data
836: );
837: AHL_GENERIC_APRV_PVT.Handle_Error

Line 950: RAISE FND_API.G_EXC_ERROR;

946:
947: IF get_uc_header_det%NOTFOUND THEN
948: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
949: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
950: RAISE FND_API.G_EXC_ERROR;
951: ELSE
952: fnd_message.set_name('AHL', 'AHL_UC_NTF_APPROVAL');
953: fnd_message.set_token('REQUESTER',l_requester, false);
954: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);

Line 972: WHEN FND_API.G_EXC_ERROR THEN

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

Line 975: p_encoded => FND_API.G_FALSE,

971: EXCEPTION
972: WHEN FND_API.G_EXC_ERROR THEN
973: FND_MSG_PUB.Count_And_Get
974: (
975: p_encoded => FND_API.G_FALSE,
976: p_count => l_msg_count,
977: p_data => l_msg_data
978: );
979: AHL_GENERIC_APRV_PVT.Handle_Error

Line 1092: RAISE FND_API.G_EXC_ERROR;

1088:
1089: IF get_uc_header_det%NOTFOUND THEN
1090: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
1091: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
1092: RAISE FND_API.G_EXC_ERROR;
1093: ELSE
1094: fnd_message.set_name('AHL', 'AHL_UC_NTF_REMIND');
1095: fnd_message.set_token('REQUESTER',l_requester, false);
1096: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);

Line 1114: WHEN FND_API.G_EXC_ERROR THEN

1110:
1111: RETURN;
1112:
1113: EXCEPTION
1114: WHEN FND_API.G_EXC_ERROR THEN
1115: FND_MSG_PUB.Count_And_Get
1116: (
1117: p_encoded => FND_API.G_FALSE,
1118: p_count => l_msg_count,

Line 1117: p_encoded => FND_API.G_FALSE,

1113: EXCEPTION
1114: WHEN FND_API.G_EXC_ERROR THEN
1115: FND_MSG_PUB.Count_And_Get
1116: (
1117: p_encoded => FND_API.G_FALSE,
1118: p_count => l_msg_count,
1119: p_data => l_msg_data
1120: );
1121: AHL_GENERIC_APRV_PVT.Handle_Error

Line 1222: RAISE FND_API.G_EXC_ERROR;

1218:
1219: IF get_uc_header_det%NOTFOUND THEN
1220: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
1221: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
1222: RAISE FND_API.G_EXC_ERROR;
1223: ELSE
1224: fnd_message.set_name('AHL', 'AHL_UC_NTF_ERROR_ACT');
1225: fnd_message.set_token('UC_HEADER_ID',l_uc_header_rec.unit_config_header_id ,false);
1226: fnd_message.set_token('NAME',l_uc_header_rec.name, false);

Line 1243: WHEN FND_API.G_EXC_ERROR THEN

1239:
1240: RETURN;
1241:
1242: EXCEPTION
1243: WHEN FND_API.G_EXC_ERROR THEN
1244: FND_MSG_PUB.Count_And_Get
1245: (
1246: p_encoded => FND_API.G_FALSE,
1247: p_count => l_msg_count,

Line 1246: p_encoded => FND_API.G_FALSE,

1242: EXCEPTION
1243: WHEN FND_API.G_EXC_ERROR THEN
1244: FND_MSG_PUB.Count_And_Get
1245: (
1246: p_encoded => FND_API.G_FALSE,
1247: p_count => l_msg_count,
1248: p_data => l_msg_data
1249: );
1250: AHL_GENERIC_APRV_PVT.Handle_Error

Line 1372: RAISE FND_API.G_EXC_ERROR;

1368:
1369: IF get_uc_header_det%NOTFOUND THEN
1370: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
1371: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
1372: RAISE FND_API.G_EXC_ERROR;
1373: END IF;
1374: CLOSE get_uc_header_det;
1375:
1376:

Line 1385: RAISE FND_API.G_EXC_ERROR;

1381: fnd_message.set_name('AHL', 'AHL_COM_RECORD_CHANGED');
1382: IF G_DEBUG='Y' THEN
1383: AHL_DEBUG_PUB.debug('UC-ACL: UPDATE_STATUS check_uc_ovn --> fnd_message='||fnd_message.get );
1384: END IF;
1385: RAISE FND_API.G_EXC_ERROR;
1386: END IF;
1387: CLOSE check_uc_ovn;
1388:
1389: AHL_GENERIC_APRV_PVT.Handle_Error

Line 1409: p_init_msg_list => FND_API.G_TRUE,

1405:
1406: --CALL AHL_UC_APPROVALS_PVT.complete_quarantine_approval
1407: AHL_UC_APPROVALS_PVT.complete_quarantine_approval(
1408: p_api_version => 1.0,
1409: p_init_msg_list => FND_API.G_TRUE,
1410: p_commit => FND_API.G_TRUE,
1411: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1412: p_uc_header_id => l_object_id,
1413: p_object_version_number => l_object_version_number,

Line 1410: p_commit => FND_API.G_TRUE,

1406: --CALL AHL_UC_APPROVALS_PVT.complete_quarantine_approval
1407: AHL_UC_APPROVALS_PVT.complete_quarantine_approval(
1408: p_api_version => 1.0,
1409: p_init_msg_list => FND_API.G_TRUE,
1410: p_commit => FND_API.G_TRUE,
1411: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1412: p_uc_header_id => l_object_id,
1413: p_object_version_number => l_object_version_number,
1414: p_approval_status => l_approval_status,

Line 1411: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1407: AHL_UC_APPROVALS_PVT.complete_quarantine_approval(
1408: p_api_version => 1.0,
1409: p_init_msg_list => FND_API.G_TRUE,
1410: p_commit => FND_API.G_TRUE,
1411: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1412: p_uc_header_id => l_object_id,
1413: p_object_version_number => l_object_version_number,
1414: p_approval_status => l_approval_status,
1415: x_return_status => l_return_status,

Line 1454: WHEN FND_API.g_exc_error THEN

1450: RETURN;
1451: END IF;
1452:
1453: EXCEPTION
1454: WHEN FND_API.g_exc_error THEN
1455: FND_MSG_PUB.Count_And_Get
1456: (
1457: p_encoded => FND_API.G_FALSE,
1458: p_count => l_msg_count,

Line 1457: p_encoded => FND_API.G_FALSE,

1453: EXCEPTION
1454: WHEN FND_API.g_exc_error THEN
1455: FND_MSG_PUB.Count_And_Get
1456: (
1457: p_encoded => FND_API.G_FALSE,
1458: p_count => l_msg_count,
1459: p_data => l_msg_data
1460: );
1461: AHL_GENERIC_APRV_PVT.Handle_Error

Line 1589: RAISE FND_API.G_EXC_ERROR;

1585:
1586: IF get_uc_header_det%NOTFOUND THEN
1587: fnd_message.set_name('AHL', 'AHL_UC_HEADER_ID_INVALID');
1588: fnd_message.set_token('UC_HEADER_ID', l_object_id, false);
1589: RAISE FND_API.G_EXC_ERROR;
1590: END IF;
1591: CLOSE get_uc_header_det;
1592:
1593:

Line 1599: RAISE FND_API.G_EXC_ERROR;

1595: FETCH check_uc_ovn into l_check_uc_ovn;
1596:
1597: IF check_uc_ovn%NOTFOUND THEN
1598: fnd_message.set_name('AHL', 'AHL_COM_RECORD_CHANGED');
1599: RAISE FND_API.G_EXC_ERROR;
1600: END IF;
1601:
1602: UPDATE ahl_unit_config_headers
1603: SET active_uc_status_code = l_next_status,

Line 1641: WHEN FND_API.g_exc_error THEN

1637:
1638:
1639:
1640: EXCEPTION
1641: WHEN FND_API.g_exc_error THEN
1642: FND_MSG_PUB.Count_And_Get
1643: (
1644: p_encoded => FND_API.G_FALSE,
1645: p_count => l_msg_count,

Line 1644: p_encoded => FND_API.G_FALSE,

1640: EXCEPTION
1641: WHEN FND_API.g_exc_error THEN
1642: FND_MSG_PUB.Count_And_Get
1643: (
1644: p_encoded => FND_API.G_FALSE,
1645: p_count => l_msg_count,
1646: p_data => l_msg_data
1647: );
1648: AHL_GENERIC_APRV_PVT.Handle_Error