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

Line 46: l_return_status := FND_API.g_ret_sts_success;

42: END IF;
43:
44: fnd_msg_pub.initialize;
45:
46: l_return_status := FND_API.g_ret_sts_success;
47:
48: IF G_DEBUG='Y' THEN
49: AHL_DEBUG_PUB.debug('PCWF -- SET_ACTIVITY_DETAILS -- Begin');
50: END IF;

Line 208: IF l_return_status = FND_API.g_ret_sts_success

204: IF G_DEBUG='Y' THEN
205: AHL_DEBUG_PUB.debug('PCWF -- SET_ACTIVITY_DETAILS -- Completed GET_APPROVAL_DETAILS');
206: END IF;
207:
208: IF l_return_status = FND_API.g_ret_sts_success
209: THEN
210: wf_engine.setitemattrnumber
211: (
212: itemtype => itemtype,

Line 236: RAISE FND_API.G_EXC_ERROR;

232: resultout := 'COMPLETE:SUCCESS';
233: RETURN;
234:
235: ELSE
236: RAISE FND_API.G_EXC_ERROR;
237: END IF;
238: END IF;
239:
240: --

Line 261: WHEN FND_API.G_EXC_ERROR THEN

257: RETURN;
258: END IF;
259:
260: EXCEPTION
261: WHEN FND_API.G_EXC_ERROR THEN
262: FND_MSG_PUB.Count_And_Get
263: (
264: p_encoded => FND_API.G_FALSE,
265: p_count => l_msg_count,

Line 264: p_encoded => FND_API.G_FALSE,

260: EXCEPTION
261: WHEN FND_API.G_EXC_ERROR THEN
262: FND_MSG_PUB.Count_And_Get
263: (
264: p_encoded => FND_API.G_FALSE,
265: p_count => l_msg_count,
266: p_data => l_msg_data
267: );
268: AHL_GENERIC_APRV_PVT.handle_error

Line 396: WHEN FND_API.G_EXC_ERROR THEN

392: COMMIT;
393: RETURN;
394:
395: EXCEPTION
396: WHEN FND_API.G_EXC_ERROR THEN
397: FND_MSG_PUB.Count_And_Get
398: (
399: p_encoded => FND_API.G_FALSE,
400: p_count => l_msg_count,

Line 399: p_encoded => FND_API.G_FALSE,

395: EXCEPTION
396: WHEN FND_API.G_EXC_ERROR THEN
397: FND_MSG_PUB.Count_And_Get
398: (
399: p_encoded => FND_API.G_FALSE,
400: p_count => l_msg_count,
401: p_data => l_msg_data
402: );
403: AHL_GENERIC_APRV_PVT.Handle_Error

Line 525: WHEN FND_API.G_EXC_ERROR THEN

521:
522: RETURN;
523:
524: EXCEPTION
525: WHEN FND_API.G_EXC_ERROR THEN
526: FND_MSG_PUB.Count_And_Get
527: (
528: p_encoded => FND_API.G_FALSE,
529: p_count => l_msg_count,

Line 528: p_encoded => FND_API.G_FALSE,

524: EXCEPTION
525: WHEN FND_API.G_EXC_ERROR THEN
526: FND_MSG_PUB.Count_And_Get
527: (
528: p_encoded => FND_API.G_FALSE,
529: p_count => l_msg_count,
530: p_data => l_msg_data
531: );
532: AHL_GENERIC_APRV_PVT.Handle_Error

Line 644: WHEN FND_API.G_EXC_ERROR THEN

640:
641: RETURN;
642:
643: EXCEPTION
644: WHEN FND_API.G_EXC_ERROR THEN
645: FND_MSG_PUB.Count_And_Get
646: (
647: p_encoded => FND_API.G_FALSE,
648: p_count => l_msg_count,

Line 647: p_encoded => FND_API.G_FALSE,

643: EXCEPTION
644: WHEN FND_API.G_EXC_ERROR THEN
645: FND_MSG_PUB.Count_And_Get
646: (
647: p_encoded => FND_API.G_FALSE,
648: p_count => l_msg_count,
649: p_data => l_msg_data
650: );
651: AHL_GENERIC_APRV_PVT.Handle_Error

Line 774: WHEN FND_API.G_EXC_ERROR THEN

770:
771: RETURN;
772:
773: EXCEPTION
774: WHEN FND_API.G_EXC_ERROR THEN
775: FND_MSG_PUB.Count_And_Get
776: (
777: p_encoded => FND_API.G_FALSE,
778: p_count => l_msg_count,

Line 777: p_encoded => FND_API.G_FALSE,

773: EXCEPTION
774: WHEN FND_API.G_EXC_ERROR THEN
775: FND_MSG_PUB.Count_And_Get
776: (
777: p_encoded => FND_API.G_FALSE,
778: p_count => l_msg_count,
779: p_data => l_msg_data
780: );
781: AHL_GENERIC_APRV_PVT.Handle_Error

Line 913: WHEN FND_API.G_EXC_ERROR THEN

909:
910: RETURN;
911:
912: EXCEPTION
913: WHEN FND_API.G_EXC_ERROR THEN
914: FND_MSG_PUB.Count_And_Get
915: (
916: p_encoded => FND_API.G_FALSE,
917: p_count => l_msg_count,

Line 916: p_encoded => FND_API.G_FALSE,

912: EXCEPTION
913: WHEN FND_API.G_EXC_ERROR THEN
914: FND_MSG_PUB.Count_And_Get
915: (
916: p_encoded => FND_API.G_FALSE,
917: p_count => l_msg_count,
918: p_data => l_msg_data
919: );
920: AHL_GENERIC_APRV_PVT.Handle_Error

Line 1051: WHEN FND_API.G_EXC_ERROR THEN

1047:
1048: RETURN;
1049:
1050: EXCEPTION
1051: WHEN FND_API.G_EXC_ERROR THEN
1052: FND_MSG_PUB.Count_And_Get
1053: (
1054: p_encoded => FND_API.G_FALSE,
1055: p_count => l_msg_count,

Line 1054: p_encoded => FND_API.G_FALSE,

1050: EXCEPTION
1051: WHEN FND_API.G_EXC_ERROR THEN
1052: FND_MSG_PUB.Count_And_Get
1053: (
1054: p_encoded => FND_API.G_FALSE,
1055: p_count => l_msg_count,
1056: p_data => l_msg_data
1057: );
1058: AHL_GENERIC_APRV_PVT.Handle_Error

Line 1185: WHEN FND_API.G_EXC_ERROR THEN

1181:
1182: RETURN;
1183:
1184: EXCEPTION
1185: WHEN FND_API.G_EXC_ERROR THEN
1186: FND_MSG_PUB.Count_And_Get
1187: (
1188: p_encoded => FND_API.G_FALSE,
1189: p_count => l_msg_count,

Line 1188: p_encoded => FND_API.G_FALSE,

1184: EXCEPTION
1185: WHEN FND_API.G_EXC_ERROR THEN
1186: FND_MSG_PUB.Count_And_Get
1187: (
1188: p_encoded => FND_API.G_FALSE,
1189: p_count => l_msg_count,
1190: p_data => l_msg_data
1191: );
1192: AHL_GENERIC_APRV_PVT.Handle_Error

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

1237: l_status_date DATE;
1238: l_msg_count NUMBER;
1239: l_msg_data VARCHAR2(4000);
1240:
1241: l_commit VARCHAR2(1) := FND_API.G_TRUE;
1242: l_pc_header_id NUMBER :=0;
1243: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
1244: l_validate_only VARCHAR2(1) := FND_API.G_TRUE;
1245: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;

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

1239: l_msg_data VARCHAR2(4000);
1240:
1241: l_commit VARCHAR2(1) := FND_API.G_TRUE;
1242: l_pc_header_id NUMBER :=0;
1243: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
1244: l_validate_only VARCHAR2(1) := FND_API.G_TRUE;
1245: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
1246: l_module_type VARCHAR2(1);
1247: l_return_status VARCHAR2(1);

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

1240:
1241: l_commit VARCHAR2(1) := FND_API.G_TRUE;
1242: l_pc_header_id NUMBER :=0;
1243: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
1244: l_validate_only VARCHAR2(1) := FND_API.G_TRUE;
1245: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
1246: l_module_type VARCHAR2(1);
1247: l_return_status VARCHAR2(1);
1248: x_return_status VARCHAR2(2000);

Line 1245: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;

1241: l_commit VARCHAR2(1) := FND_API.G_TRUE;
1242: l_pc_header_id NUMBER :=0;
1243: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
1244: l_validate_only VARCHAR2(1) := FND_API.G_TRUE;
1245: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
1246: l_module_type VARCHAR2(1);
1247: l_return_status VARCHAR2(1);
1248: x_return_status VARCHAR2(2000);
1249: x_msg_count NUMBER;

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

1248: x_return_status VARCHAR2(2000);
1249: x_msg_count NUMBER;
1250: x_msg_data VARCHAR2(2000);
1251: l_pc_header_rec AHL_PC_HEADER_PUB.PC_HEADER_REC;
1252: l_default VARCHAR2(1) := FND_API.G_FALSE;
1253:
1254: CURSOR GET_PC_HEADER_DET(c_pc_header_id number)
1255: IS
1256: SELECT *

Line 1338: l_return_status := FND_API.G_RET_STS_ERROR;

1334: THEN
1335: fnd_message.set_name('AHL', 'AHL_APRV_OBJ_CHANGED');
1336: fnd_msg_pub.add;
1337: l_msg_count := 1;
1338: l_return_status := FND_API.G_RET_STS_ERROR;
1339: ELSE
1340: l_pc_header_rec.PC_HEADER_ID := l_pc_header_det.PC_HEADER_ID;
1341: l_pc_header_rec.NAME := l_pc_header_det.NAME;
1342: l_pc_header_rec.DESCRIPTION := l_pc_header_det.DESCRIPTION;

Line 1373: p_init_msg_list => FND_API.G_FALSE,

1369:
1370: AHL_PC_HEADER_PVT.UPDATE_PC_HEADER
1371: (
1372: p_api_version => 1.0,
1373: p_init_msg_list => FND_API.G_FALSE,
1374: p_commit => FND_API.G_TRUE,
1375: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1376: p_x_pc_header_rec => l_pc_header_rec,
1377: x_return_status => x_return_status,

Line 1374: p_commit => FND_API.G_TRUE,

1370: AHL_PC_HEADER_PVT.UPDATE_PC_HEADER
1371: (
1372: p_api_version => 1.0,
1373: p_init_msg_list => FND_API.G_FALSE,
1374: p_commit => FND_API.G_TRUE,
1375: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1376: p_x_pc_header_rec => l_pc_header_rec,
1377: x_return_status => x_return_status,
1378: x_msg_count => x_msg_count,

Line 1375: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1371: (
1372: p_api_version => 1.0,
1373: p_init_msg_list => FND_API.G_FALSE,
1374: p_commit => FND_API.G_TRUE,
1375: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1376: p_x_pc_header_rec => l_pc_header_rec,
1377: x_return_status => x_return_status,
1378: x_msg_count => x_msg_count,
1379: x_msg_data => x_msg_data

Line 1389: l_return_status := FND_API.G_RET_STS_ERROR;

1385: l_msg_count := x_msg_count;
1386:
1387: IF (l_msg_count > 0)
1388: THEN
1389: l_return_status := FND_API.G_RET_STS_ERROR;
1390: ELSE
1391: l_return_status := FND_API.G_RET_STS_SUCCESS;
1392: END IF;
1393: END IF;

Line 1391: l_return_status := FND_API.G_RET_STS_SUCCESS;

1387: IF (l_msg_count > 0)
1388: THEN
1389: l_return_status := FND_API.G_RET_STS_ERROR;
1390: ELSE
1391: l_return_status := FND_API.G_RET_STS_SUCCESS;
1392: END IF;
1393: END IF;
1394:
1395: resultout := 'COMPLETE:SUCCESS';

Line 1418: WHEN FND_API.g_exc_error THEN

1414: RETURN;
1415: END IF;
1416:
1417: EXCEPTION
1418: WHEN FND_API.g_exc_error THEN
1419: FND_MSG_PUB.Count_And_Get
1420: (
1421: p_encoded => FND_API.G_FALSE,
1422: p_count => l_msg_count,

Line 1421: p_encoded => FND_API.G_FALSE,

1417: EXCEPTION
1418: WHEN FND_API.g_exc_error THEN
1419: FND_MSG_PUB.Count_And_Get
1420: (
1421: p_encoded => FND_API.G_FALSE,
1422: p_count => l_msg_count,
1423: p_data => l_msg_data
1424: );
1425: AHL_GENERIC_APRV_PVT.Handle_Error

Line 1568: WHEN FND_API.g_exc_error THEN

1564: END IF;
1565:
1566:
1567: EXCEPTION
1568: WHEN FND_API.g_exc_error THEN
1569: FND_MSG_PUB.Count_And_Get
1570: (
1571: p_encoded => FND_API.G_FALSE,
1572: p_count => l_msg_count,

Line 1571: p_encoded => FND_API.G_FALSE,

1567: EXCEPTION
1568: WHEN FND_API.g_exc_error THEN
1569: FND_MSG_PUB.Count_And_Get
1570: (
1571: p_encoded => FND_API.G_FALSE,
1572: p_count => l_msg_count,
1573: p_data => l_msg_data
1574: );
1575: AHL_GENERIC_APRV_PVT.Handle_Error