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_APPROVALS_PVT dependencies on AHL_UC_APPROVALS_PVT

Line 1: PACKAGE BODY AHL_UC_APPROVALS_PVT AS

1: PACKAGE BODY AHL_UC_APPROVALS_PVT AS
2: /* $Header: AHLVUAPB.pls 120.2 2008/05/05 08:09:25 sathapli ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_UC_APPROVALS_PVT';
5:

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_UC_APPROVALS_PVT';

1: PACKAGE BODY AHL_UC_APPROVALS_PVT AS
2: /* $Header: AHLVUAPB.pls 120.2 2008/05/05 08:09:25 sathapli ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_UC_APPROVALS_PVT';
5:
6: -- To check if AHL DEBUG is turned ON
7: G_DEBUG VARCHAR2(1):=AHL_DEBUG_PUB.is_log_enabled;
8:

Line 203: AHL_UC_APPROVALS_PVT.COMPLETE_UC_APPROVAL

199: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
200: FND_MSG_PUB.ADD;
201: ELSE
202: -- Call the Complete UC Approval API
203: AHL_UC_APPROVALS_PVT.COMPLETE_UC_APPROVAL
204: (
205: p_api_version =>1.0,
206: p_init_msg_list =>FND_API.G_TRUE,
207: p_commit =>FND_API.G_FALSE,

Line 288: AHL_UC_APPROVALS_PVT.COMPLETE_UC_APPROVAL

284: FND_MSG_PUB.ADD;
285: ELSE
286:
287: --Call the complete UC Approvals API
288: AHL_UC_APPROVALS_PVT.COMPLETE_UC_APPROVAL
289: (
290: p_api_version =>1.0,
291: p_init_msg_list =>FND_API.G_TRUE,
292: p_commit =>FND_API.G_FALSE,

Line 484: AHL_DEBUG_PUB.debug( 'UC: AHL_UC_APPROVALS_PVT.complete_uc_approval--> approval_status=APPROVED');

480:
481: IF( p_approval_status='APPROVED' ) THEN
482:
483: IF G_DEBUG='Y' THEN
484: AHL_DEBUG_PUB.debug( 'UC: AHL_UC_APPROVALS_PVT.complete_uc_approval--> approval_status=APPROVED');
485: END IF;
486:
487: --call the completeness check API
488: AHL_UC_VALIDATION_PUB.check_completeness(

Line 505: AHL_DEBUG_PUB.debug( 'UC: AHL_UC_APPROVALS_PVT.complete_uc_approval-->After Completeness Check API call');

501: AHL_DEBUG_PUB.debug('SQLERRM' || SQLERRM );
502: AHL_DEBUG_PUB.debug('l_return_status' || l_return_status);
503: AHL_DEBUG_PUB.debug('l_msg_count' || l_msg_count);
504: AHL_DEBUG_PUB.debug('l_msg_data' || l_msg_data);
505: AHL_DEBUG_PUB.debug( 'UC: AHL_UC_APPROVALS_PVT.complete_uc_approval-->After Completeness Check API call');
506: END IF;
507:
508: l_msg_count := FND_MSG_PUB.count_msg;
509: IF l_msg_count > 0 THEN

Line 838: AHL_UC_APPROVALS_PVT.COMPLETE_QUARANTINE_APPROVAL(p_api_version =>1.0,

834: FND_MSG_PUB.ADD;
835: -- To be verified if Error is supposed to be raised here or not.
836: ELSE
837: -- Call the Complete UC Approval API
838: AHL_UC_APPROVALS_PVT.COMPLETE_QUARANTINE_APPROVAL(p_api_version =>1.0,
839: p_init_msg_list =>FND_API.G_TRUE,
840: p_commit =>FND_API.G_FALSE,
841: p_validation_level =>NULL,
842: p_approval_status =>'APPROVED',

Line 1103: AHL_UC_APPROVALS_PVT.COMPLETE_QUARANTINE_APPROVAL(p_api_version =>1.0,

1099: FND_MSG_PUB.ADD;
1100: -- To be verified if Error is supposed to be raised here or not.
1101: ELSE
1102: -- Call the Complete UC Approval API
1103: AHL_UC_APPROVALS_PVT.COMPLETE_QUARANTINE_APPROVAL(p_api_version =>1.0,
1104: p_init_msg_list =>FND_API.G_TRUE,
1105: p_commit =>FND_API.G_FALSE,
1106: p_validation_level =>NULL,
1107: p_approval_status =>'APPROVED',

Line 1263: AHL_DEBUG_PUB.debug( 'UC: AHL_UC_APPROVALS_PVT.complete_uc_approval--> check for Valid UC');

1259: -- Initialize API return status to success
1260: x_return_status := FND_API.G_RET_STS_SUCCESS;
1261:
1262: IF G_DEBUG='Y' THEN
1263: AHL_DEBUG_PUB.debug( 'UC: AHL_UC_APPROVALS_PVT.complete_uc_approval--> check for Valid UC');
1264: END IF;
1265:
1266: -- Begin Processing
1267: --1) Validate if uc_header_id is passed.

Line 1277: AHL_DEBUG_PUB.debug( 'UC: AHL_UC_APPROVALS_PVT.complete_uc_approval--> UC is Valid 1 ');

1273: RAISE FND_API.G_EXC_ERROR;
1274: END IF;
1275:
1276: IF G_DEBUG='Y' THEN
1277: AHL_DEBUG_PUB.debug( 'UC: AHL_UC_APPROVALS_PVT.complete_uc_approval--> UC is Valid 1 ');
1278: END IF;
1279:
1280: --2) Validate uc_header_id passed is valid
1281: OPEN get_uc_header_det(p_uc_header_id);

Line 1293: AHL_DEBUG_PUB.debug( 'UC: AHL_UC_APPROVALS_PVT.complete_uc_approval--> UC is Valid 2 ');

1289: END IF;
1290: CLOSE get_uc_header_det;
1291:
1292: IF G_DEBUG='Y' THEN
1293: AHL_DEBUG_PUB.debug( 'UC: AHL_UC_APPROVALS_PVT.complete_uc_approval--> UC is Valid 2 ');
1294: END IF;
1295:
1296:
1297: IF ((l_uc_header_rec.unit_config_status_code = 'QUARANTINE' AND p_approval_status='APPROVED') OR

Line 1303: AHL_DEBUG_PUB.debug( 'UC: AHL_UC_APPROVALS_PVT.complete_uc_approval--> l_status 2 : '||l_status);

1299:
1300: l_status := 'QUARANTINE';
1301:
1302: IF G_DEBUG='Y' THEN
1303: AHL_DEBUG_PUB.debug( 'UC: AHL_UC_APPROVALS_PVT.complete_uc_approval--> l_status 2 : '||l_status);
1304: END IF;
1305:
1306:
1307: ELSIF ((l_uc_header_rec.unit_config_status_code = 'QUARANTINE' AND p_approval_status = 'APPROVAL_REJECTED') OR

Line 1311: AHL_DEBUG_PUB.debug( 'UC: AHL_UC_APPROVALS_PVT.complete_uc_approval--> approval_status=APPROVED');

1307: ELSIF ((l_uc_header_rec.unit_config_status_code = 'QUARANTINE' AND p_approval_status = 'APPROVAL_REJECTED') OR
1308: (l_uc_header_rec.unit_config_status_code = 'DEACTIVATE_QUARANTINE' AND p_approval_status='APPROVED')) THEN
1309:
1310: IF G_DEBUG='Y' THEN
1311: AHL_DEBUG_PUB.debug( 'UC: AHL_UC_APPROVALS_PVT.complete_uc_approval--> approval_status=APPROVED');
1312: END IF;
1313:
1314: --call the completeness check API
1315: AHL_UC_VALIDATION_PUB.check_completeness(

Line 1332: AHL_DEBUG_PUB.debug( 'UC: AHL_UC_APPROVALS_PVT.complete_uc_approval-->After Completeness Check API call');

1328: AHL_DEBUG_PUB.debug('SQLERRM' || SQLERRM );
1329: AHL_DEBUG_PUB.debug('l_return_status' || l_return_status);
1330: AHL_DEBUG_PUB.debug('l_msg_count' || l_msg_count);
1331: AHL_DEBUG_PUB.debug('l_msg_data' || l_msg_data);
1332: AHL_DEBUG_PUB.debug( 'UC: AHL_UC_APPROVALS_PVT.complete_uc_approval-->After Completeness Check API call');
1333: END IF;
1334:
1335: l_msg_count := FND_MSG_PUB.count_msg;
1336: IF l_msg_count > 0 THEN

Line 1349: AHL_DEBUG_PUB.debug( 'UC: AHL_UC_APPROVALS_PVT.complete_uc_approval--> l_status 3 : '||l_status);

1345: l_status := 'INCOMPLETE';
1346: END IF;
1347:
1348: IF G_DEBUG='Y' THEN
1349: AHL_DEBUG_PUB.debug( 'UC: AHL_UC_APPROVALS_PVT.complete_uc_approval--> l_status 3 : '||l_status);
1350: END IF;
1351: END IF;
1352:
1353: --update table and write to history table

Line 1357: AHL_DEBUG_PUB.debug( 'UC: AHL_UC_APPROVALS_PVT.complete_uc_approval--> Before Update');

1353: --update table and write to history table
1354: BEGIN
1355:
1356: IF G_DEBUG='Y' THEN
1357: AHL_DEBUG_PUB.debug( 'UC: AHL_UC_APPROVALS_PVT.complete_uc_approval--> Before Update');
1358: END IF;
1359:
1360: UPDATE ahl_unit_config_headers
1361: SET unit_config_status_code=l_status,

Line 1367: AHL_DEBUG_PUB.debug( 'UC: AHL_UC_APPROVALS_PVT.complete_uc_approval--> After Update');

1363: object_version_number=object_version_number+1
1364: WHERE unit_config_header_id=p_uc_header_id;
1365:
1366: IF G_DEBUG='Y' THEN
1367: AHL_DEBUG_PUB.debug( 'UC: AHL_UC_APPROVALS_PVT.complete_uc_approval--> After Update');
1368: END IF;
1369:
1370: EXCEPTION
1371: WHEN OTHERS THEN

Line 1379: AHL_DEBUG_PUB.debug( 'UC: AHL_UC_APPROVALS_PVT.complete_uc_approval--> Before History');

1375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1376: END;
1377:
1378: IF G_DEBUG='Y' THEN
1379: AHL_DEBUG_PUB.debug( 'UC: AHL_UC_APPROVALS_PVT.complete_uc_approval--> Before History');
1380: END IF;
1381:
1382: AHL_UTIL_UC_PKG.COPY_UC_HEADER_TO_HISTORY(p_uc_header_id, x_return_status);
1383:

Line 1385: AHL_DEBUG_PUB.debug( 'UC: AHL_UC_APPROVALS_PVT.complete_uc_approval--> After History');

1381:
1382: AHL_UTIL_UC_PKG.COPY_UC_HEADER_TO_HISTORY(p_uc_header_id, x_return_status);
1383:
1384: IF G_DEBUG='Y' THEN
1385: AHL_DEBUG_PUB.debug( 'UC: AHL_UC_APPROVALS_PVT.complete_uc_approval--> After History');
1386: END IF;
1387:
1388: l_msg_count := FND_MSG_PUB.count_msg;
1389:

Line 1441: END AHL_UC_APPROVALS_PVT;

1437: END IF;
1438:
1439: END COMPLETE_QUARANTINE_APPROVAL;
1440:
1441: END AHL_UC_APPROVALS_PVT;