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 1245: l_commit VARCHAR2(1) := FND_API.G_TRUE;

1241: -- AJPRASAN:: Bug #9596384 - Using the following two variables to retrieve the BUE running option given by the user.
1242: l_bue_msg VARCHAR2(50);
1243: l_bue_flag VARCHAR2(1);
1244:
1245: l_commit VARCHAR2(1) := FND_API.G_TRUE;
1246: l_pc_header_id NUMBER :=0;
1247: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
1248: l_validate_only VARCHAR2(1) := FND_API.G_TRUE;
1249: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;

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

1243: l_bue_flag VARCHAR2(1);
1244:
1245: l_commit VARCHAR2(1) := FND_API.G_TRUE;
1246: l_pc_header_id NUMBER :=0;
1247: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
1248: l_validate_only VARCHAR2(1) := FND_API.G_TRUE;
1249: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
1250: l_module_type VARCHAR2(1);
1251: l_return_status VARCHAR2(1);

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

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

Line 1249: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;

1245: l_commit VARCHAR2(1) := FND_API.G_TRUE;
1246: l_pc_header_id NUMBER :=0;
1247: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
1248: l_validate_only VARCHAR2(1) := FND_API.G_TRUE;
1249: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
1250: l_module_type VARCHAR2(1);
1251: l_return_status VARCHAR2(1);
1252: x_return_status VARCHAR2(2000);
1253: x_msg_count NUMBER;

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

1253: x_msg_count NUMBER;
1254: x_msg_data VARCHAR2(2000);
1255: x_warning_msg_data AHL_PC_HEADER_PUB.Warn_Tbl_Type;
1256: l_pc_header_rec AHL_PC_HEADER_PUB.PC_HEADER_REC;
1257: l_default VARCHAR2(1) := FND_API.G_FALSE;
1258:
1259: CURSOR GET_PC_HEADER_DET(c_pc_header_id number)
1260: IS
1261: SELECT *

Line 1360: l_return_status := FND_API.G_RET_STS_ERROR;

1356: THEN
1357: fnd_message.set_name('AHL', 'AHL_APRV_OBJ_CHANGED');
1358: fnd_msg_pub.add;
1359: l_msg_count := 1;
1360: l_return_status := FND_API.G_RET_STS_ERROR;
1361: ELSE
1362: l_pc_header_rec.PC_HEADER_ID := l_pc_header_det.PC_HEADER_ID;
1363: l_pc_header_rec.NAME := l_pc_header_det.NAME;
1364: l_pc_header_rec.DESCRIPTION := l_pc_header_det.DESCRIPTION;

Line 1397: p_init_msg_list => FND_API.G_FALSE,

1393:
1394: AHL_PC_HEADER_PVT.UPDATE_PC_HEADER
1395: (
1396: p_api_version => 1.0,
1397: p_init_msg_list => FND_API.G_FALSE,
1398: p_commit => FND_API.G_TRUE,
1399: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1400: p_x_pc_header_rec => l_pc_header_rec,
1401: x_return_status => x_return_status,

Line 1398: p_commit => FND_API.G_TRUE,

1394: AHL_PC_HEADER_PVT.UPDATE_PC_HEADER
1395: (
1396: p_api_version => 1.0,
1397: p_init_msg_list => FND_API.G_FALSE,
1398: p_commit => FND_API.G_TRUE,
1399: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1400: p_x_pc_header_rec => l_pc_header_rec,
1401: x_return_status => x_return_status,
1402: x_msg_count => x_msg_count,

Line 1399: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1395: (
1396: p_api_version => 1.0,
1397: p_init_msg_list => FND_API.G_FALSE,
1398: p_commit => FND_API.G_TRUE,
1399: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1400: p_x_pc_header_rec => l_pc_header_rec,
1401: x_return_status => x_return_status,
1402: x_msg_count => x_msg_count,
1403: x_msg_data => x_msg_data,

Line 1414: l_return_status := FND_API.G_RET_STS_ERROR;

1410: l_msg_count := x_msg_count;
1411:
1412: IF (l_msg_count > 0)
1413: THEN
1414: l_return_status := FND_API.G_RET_STS_ERROR;
1415: ELSE
1416: l_return_status := FND_API.G_RET_STS_SUCCESS;
1417: END IF;
1418: END IF;

Line 1416: l_return_status := FND_API.G_RET_STS_SUCCESS;

1412: IF (l_msg_count > 0)
1413: THEN
1414: l_return_status := FND_API.G_RET_STS_ERROR;
1415: ELSE
1416: l_return_status := FND_API.G_RET_STS_SUCCESS;
1417: END IF;
1418: END IF;
1419:
1420: resultout := 'COMPLETE:SUCCESS';

Line 1443: WHEN FND_API.g_exc_error THEN

1439: RETURN;
1440: END IF;
1441:
1442: EXCEPTION
1443: WHEN FND_API.g_exc_error THEN
1444: FND_MSG_PUB.Count_And_Get
1445: (
1446: p_encoded => FND_API.G_FALSE,
1447: p_count => l_msg_count,

Line 1446: p_encoded => FND_API.G_FALSE,

1442: EXCEPTION
1443: WHEN FND_API.g_exc_error THEN
1444: FND_MSG_PUB.Count_And_Get
1445: (
1446: p_encoded => FND_API.G_FALSE,
1447: p_count => l_msg_count,
1448: p_data => l_msg_data
1449: );
1450: AHL_GENERIC_APRV_PVT.Handle_Error

Line 1593: WHEN FND_API.g_exc_error THEN

1589: END IF;
1590:
1591:
1592: EXCEPTION
1593: WHEN FND_API.g_exc_error THEN
1594: FND_MSG_PUB.Count_And_Get
1595: (
1596: p_encoded => FND_API.G_FALSE,
1597: p_count => l_msg_count,

Line 1596: p_encoded => FND_API.G_FALSE,

1592: EXCEPTION
1593: WHEN FND_API.g_exc_error THEN
1594: FND_MSG_PUB.Count_And_Get
1595: (
1596: p_encoded => FND_API.G_FALSE,
1597: p_count => l_msg_count,
1598: p_data => l_msg_data
1599: );
1600: AHL_GENERIC_APRV_PVT.Handle_Error