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

Line 47: l_return_status := fnd_api.g_ret_sts_success;

43: -- Debug info.
44:
45: fnd_msg_pub.initialize;
46:
47: l_return_status := fnd_api.g_ret_sts_success;
48:
49: l_object_id := wf_engine.getitemattrnumber(
50: itemtype => itemtype
51: ,itemkey => itemkey

Line 157: IF l_return_status = fnd_api.g_ret_sts_success THEN

153: IF G_DEBUG='Y' THEN
154: AHL_DEBUG_PUB.debug( 'AfterGetApprovalDetails:'||l_return_status||'-'||l_subject,'+DebugWfRoute+');
155: END IF;
156:
157: IF l_return_status = fnd_api.g_ret_sts_success THEN
158:
159: wf_engine.setitemattrnumber(
160: itemtype => itemtype,
161: itemkey => itemkey,

Line 180: RAISE fnd_api.G_EXC_ERROR;

176: RETURN;
177:
178: ELSE
179:
180: RAISE fnd_api.G_EXC_ERROR;
181:
182: END IF;
183: END IF;
184:

Line 205: WHEN fnd_api.G_EXC_ERROR THEN

201: END IF;
202: --
203:
204: EXCEPTION
205: WHEN fnd_api.G_EXC_ERROR THEN
206:
207: FND_MSG_PUB.Count_And_Get (
208: p_encoded => FND_API.G_FALSE,
209: p_count => l_msg_count,

Line 208: p_encoded => FND_API.G_FALSE,

204: EXCEPTION
205: WHEN fnd_api.G_EXC_ERROR THEN
206:
207: FND_MSG_PUB.Count_And_Get (
208: p_encoded => FND_API.G_FALSE,
209: p_count => l_msg_count,
210: p_data => l_msg_data
211: );
212: ahl_generic_aprv_pvt.Handle_Error

Line 331: WHEN FND_API.G_EXC_ERROR THEN

327: document := document || l_body;
328: RETURN;
329:
330: EXCEPTION
331: WHEN FND_API.G_EXC_ERROR THEN
332: FND_MSG_PUB.Count_And_Get (
333: p_encoded => FND_API.G_FALSE,
334: p_count => l_msg_count,
335: p_data => l_msg_data

Line 333: p_encoded => FND_API.G_FALSE,

329:
330: EXCEPTION
331: WHEN FND_API.G_EXC_ERROR THEN
332: FND_MSG_PUB.Count_And_Get (
333: p_encoded => FND_API.G_FALSE,
334: p_count => l_msg_count,
335: p_data => l_msg_data
336: );
337: ahl_generic_aprv_pvt.Handle_Error

Line 444: WHEN FND_API.G_EXC_ERROR THEN

440:
441: RETURN;
442:
443: EXCEPTION
444: WHEN FND_API.G_EXC_ERROR THEN
445: FND_MSG_PUB.Count_And_Get (
446: p_encoded => FND_API.G_FALSE,
447: p_count => l_msg_count,
448: p_data => l_msg_data

Line 446: p_encoded => FND_API.G_FALSE,

442:
443: EXCEPTION
444: WHEN FND_API.G_EXC_ERROR THEN
445: FND_MSG_PUB.Count_And_Get (
446: p_encoded => FND_API.G_FALSE,
447: p_count => l_msg_count,
448: p_data => l_msg_data
449: );
450: ahl_generic_aprv_pvt.Handle_Error

Line 559: WHEN FND_API.G_EXC_ERROR THEN

555:
556: RETURN;
557:
558: EXCEPTION
559: WHEN FND_API.G_EXC_ERROR THEN
560: FND_MSG_PUB.Count_And_Get (
561: p_encoded => FND_API.G_FALSE,
562: p_count => l_msg_count,
563: p_data => l_msg_data

Line 561: p_encoded => FND_API.G_FALSE,

557:
558: EXCEPTION
559: WHEN FND_API.G_EXC_ERROR THEN
560: FND_MSG_PUB.Count_And_Get (
561: p_encoded => FND_API.G_FALSE,
562: p_count => l_msg_count,
563: p_data => l_msg_data
564: );
565: ahl_generic_aprv_pvt.Handle_Error

Line 675: WHEN FND_API.G_EXC_ERROR THEN

671:
672: RETURN;
673:
674: EXCEPTION
675: WHEN FND_API.G_EXC_ERROR THEN
676: FND_MSG_PUB.Count_And_Get (
677: p_encoded => FND_API.G_FALSE,
678: p_count => l_msg_count,
679: p_data => l_msg_data

Line 677: p_encoded => FND_API.G_FALSE,

673:
674: EXCEPTION
675: WHEN FND_API.G_EXC_ERROR THEN
676: FND_MSG_PUB.Count_And_Get (
677: p_encoded => FND_API.G_FALSE,
678: p_count => l_msg_count,
679: p_data => l_msg_data
680: );
681: ahl_generic_aprv_pvt.Handle_Error

Line 798: WHEN FND_API.G_EXC_ERROR THEN

794:
795: RETURN;
796:
797: EXCEPTION
798: WHEN FND_API.G_EXC_ERROR THEN
799: FND_MSG_PUB.Count_And_Get (
800: p_encoded => FND_API.G_FALSE,
801: p_count => l_msg_count,
802: p_data => l_msg_data

Line 800: p_encoded => FND_API.G_FALSE,

796:
797: EXCEPTION
798: WHEN FND_API.G_EXC_ERROR THEN
799: FND_MSG_PUB.Count_And_Get (
800: p_encoded => FND_API.G_FALSE,
801: p_count => l_msg_count,
802: p_data => l_msg_data
803: );
804: ahl_generic_aprv_pvt.Handle_Error

Line 924: WHEN FND_API.G_EXC_ERROR THEN

920:
921: RETURN;
922:
923: EXCEPTION
924: WHEN FND_API.G_EXC_ERROR THEN
925: FND_MSG_PUB.Count_And_Get (
926: p_encoded => FND_API.G_FALSE,
927: p_count => l_msg_count,
928: p_data => l_msg_data

Line 926: p_encoded => FND_API.G_FALSE,

922:
923: EXCEPTION
924: WHEN FND_API.G_EXC_ERROR THEN
925: FND_MSG_PUB.Count_And_Get (
926: p_encoded => FND_API.G_FALSE,
927: p_count => l_msg_count,
928: p_data => l_msg_data
929: );
930: ahl_generic_aprv_pvt.Handle_Error

Line 1045: WHEN FND_API.G_EXC_ERROR THEN

1041:
1042: RETURN;
1043:
1044: EXCEPTION
1045: WHEN FND_API.G_EXC_ERROR THEN
1046: FND_MSG_PUB.Count_And_Get (
1047: p_encoded => FND_API.G_FALSE,
1048: p_count => l_msg_count,
1049: p_data => l_msg_data

Line 1047: p_encoded => FND_API.G_FALSE,

1043:
1044: EXCEPTION
1045: WHEN FND_API.G_EXC_ERROR THEN
1046: FND_MSG_PUB.Count_And_Get (
1047: p_encoded => FND_API.G_FALSE,
1048: p_count => l_msg_count,
1049: p_data => l_msg_data
1050: );
1051: ahl_generic_aprv_pvt.Handle_Error

Line 1091: l_commit VARCHAR2(1):=FND_API.G_TRUE;

1087: l_msg_data VARCHAR2(4000);
1088: -- Variables for executing Complete_route_Revision
1089: l_api_name CONSTANT VARCHAR2(30) := 'Update_Status';
1090:
1091: l_commit VARCHAR2(1):=FND_API.G_TRUE;
1092: l_route_id number:=0;
1093: l_comp_route_id NUMBER:=0;
1094: l_api_version NUMBER:=1.0;
1095: l_init_msg_list VARCHAR2(1):= FND_API.G_TRUE;

Line 1095: l_init_msg_list VARCHAR2(1):= FND_API.G_TRUE;

1091: l_commit VARCHAR2(1):=FND_API.G_TRUE;
1092: l_route_id number:=0;
1093: l_comp_route_id NUMBER:=0;
1094: l_api_version NUMBER:=1.0;
1095: l_init_msg_list VARCHAR2(1):= FND_API.G_TRUE;
1096: l_validate_only VARCHAR2(1):= FND_API.G_TRUE;
1097: l_validation_level NUMBER:= FND_API.G_VALID_LEVEL_FULL;
1098: l_module_type VARCHAR2(1);
1099: x_return_status VARCHAR2(2000);

Line 1096: l_validate_only VARCHAR2(1):= FND_API.G_TRUE;

1092: l_route_id number:=0;
1093: l_comp_route_id NUMBER:=0;
1094: l_api_version NUMBER:=1.0;
1095: l_init_msg_list VARCHAR2(1):= FND_API.G_TRUE;
1096: l_validate_only VARCHAR2(1):= FND_API.G_TRUE;
1097: l_validation_level NUMBER:= FND_API.G_VALID_LEVEL_FULL;
1098: l_module_type VARCHAR2(1);
1099: x_return_status VARCHAR2(2000);
1100: l_return_status VARCHAR2(1);

Line 1097: l_validation_level NUMBER:= FND_API.G_VALID_LEVEL_FULL;

1093: l_comp_route_id NUMBER:=0;
1094: l_api_version NUMBER:=1.0;
1095: l_init_msg_list VARCHAR2(1):= FND_API.G_TRUE;
1096: l_validate_only VARCHAR2(1):= FND_API.G_TRUE;
1097: l_validation_level NUMBER:= FND_API.G_VALID_LEVEL_FULL;
1098: l_module_type VARCHAR2(1);
1099: x_return_status VARCHAR2(2000);
1100: l_return_status VARCHAR2(1);
1101: x_msg_count NUMBER;

Line 1103: l_default VARCHAR2(1):= FND_API.G_FALSE;

1099: x_return_status VARCHAR2(2000);
1100: l_return_status VARCHAR2(1);
1101: x_msg_count NUMBER;
1102: x_msg_data VARCHAR2(2000);
1103: l_default VARCHAR2(1):= FND_API.G_FALSE;
1104: l_status VARCHAR2(30);
1105: l_approver_note VARCHAR2(2000);
1106:
1107: cursor GetRouteDet(c_route_id number)

Line 1199: l_return_status := FND_API.G_RET_STS_ERROR;

1195: if (sql%notfound)
1196: then
1197: FND_MESSAGE.Set_Name('AHL','AHL_APRV_OBJ_CHANGED');
1198: FND_MSG_PUB.Add;
1199: l_return_status := FND_API.G_RET_STS_ERROR;
1200: End if;
1201:
1202: IF l_return_Status=fnd_api.g_ret_sts_success
1203: THEN

Line 1202: IF l_return_Status=fnd_api.g_ret_sts_success

1198: FND_MSG_PUB.Add;
1199: l_return_status := FND_API.G_RET_STS_ERROR;
1200: End if;
1201:
1202: IF l_return_Status=fnd_api.g_ret_sts_success
1203: THEN
1204: COMMIT;
1205: ELSE
1206: ROLLBACK;

Line 1230: WHEN fnd_api.g_exc_error THEN

1226: END IF;
1227:
1228:
1229: EXCEPTION
1230: WHEN fnd_api.g_exc_error THEN
1231: IF G_DEBUG='Y' THEN
1232: AHL_DEBUG_PUB.debug( 'Error G_exec UpdateSatus:'||sqlerrm,'+DebugWfRoute+');
1233: END IF;
1234: FND_MSG_PUB.Count_And_Get (

Line 1235: p_encoded => FND_API.G_FALSE,

1231: IF G_DEBUG='Y' THEN
1232: AHL_DEBUG_PUB.debug( 'Error G_exec UpdateSatus:'||sqlerrm,'+DebugWfRoute+');
1233: END IF;
1234: FND_MSG_PUB.Count_And_Get (
1235: p_encoded => FND_API.G_FALSE,
1236: p_count => l_msg_count,
1237: p_data => l_msg_data
1238: );
1239: ahl_generic_aprv_pvt.Handle_Error

Line 1346: l_return_status := FND_API.G_RET_STS_ERROR;

1342: then
1343: FND_MESSAGE.Set_Name('AHL','AHL_APRV_OBJ_CHANGED');
1344: FND_MSG_PUB.Add;
1345:
1346: l_return_status := FND_API.G_RET_STS_ERROR;
1347: return;
1348:
1349: end if;
1350:

Line 1373: WHEN fnd_api.g_exc_error THEN

1369: END IF;
1370:
1371:
1372: EXCEPTION
1373: WHEN fnd_api.g_exc_error THEN
1374: FND_MSG_PUB.Count_And_Get (
1375: p_encoded => FND_API.G_FALSE,
1376: p_count => l_msg_count,
1377: p_data => l_msg_data

Line 1375: p_encoded => FND_API.G_FALSE,

1371:
1372: EXCEPTION
1373: WHEN fnd_api.g_exc_error THEN
1374: FND_MSG_PUB.Count_And_Get (
1375: p_encoded => FND_API.G_FALSE,
1376: p_count => l_msg_count,
1377: p_data => l_msg_data
1378: );
1379: ahl_generic_aprv_pvt.Handle_Error