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_PRD_NONROUTINE_PVT dependencies on FND_PROFILE

Line 1299: WHERE party_id = fnd_profile.value('AHL_PRD_SR_CUSTOMER_NAME');

1295:
1296: CURSOR default_customer_type IS
1297: SELECT party_type
1298: FROM hz_parties
1299: WHERE party_id = fnd_profile.value('AHL_PRD_SR_CUSTOMER_NAME');
1300:
1301: -- Changes made by by VSUNDARA For SR Integration
1302: CURSOR default_party_id(p_item_instance_number IN NUMBER) IS
1303: SELECT OWNER_PARTY_ID

Line 1373: IF ( nvl(fnd_profile.value('AHL_SR_RESL_CODE_COMP'), 'N') = 'Y') THEN

1369: -- Bug # 6447467 -- start
1370: -- Check if resolution_meaning is not null. If resolution_meaning
1371: -- is null then return error message.
1372:
1373: IF ( nvl(fnd_profile.value('AHL_SR_RESL_CODE_COMP'), 'N') = 'Y') THEN
1374:
1375: IF ( p_x_sr_task_rec.resolution_meaning IS NULL OR
1376: p_x_sr_task_rec.resolution_meaning = FND_API.G_MISS_CHAR) THEN
1377:

Line 1416: IF (fnd_profile.value('AHL_PRD_SR_TYPE') is not null) THEN

1412: -- return an error message
1413:
1414: IF ((p_x_sr_task_rec.type_id is null or p_x_sr_task_rec.type_id = FND_API.G_MISS_NUM)and
1415: (p_x_sr_task_rec.type_name is null or p_x_sr_task_rec.type_name = FND_API.G_MISS_CHAR)) THEN
1416: IF (fnd_profile.value('AHL_PRD_SR_TYPE') is not null) THEN
1417: p_x_sr_task_rec.type_id := fnd_profile.value('AHL_PRD_SR_TYPE');
1418: p_x_sr_task_rec.type_name := fnd_profile.value('AHL_PRD_SR_TYPE');
1419: ELSE
1420: Fnd_Message.SET_NAME('AHL','AHL_PRD_SR_TYPE_REQ');

Line 1417: p_x_sr_task_rec.type_id := fnd_profile.value('AHL_PRD_SR_TYPE');

1413:
1414: IF ((p_x_sr_task_rec.type_id is null or p_x_sr_task_rec.type_id = FND_API.G_MISS_NUM)and
1415: (p_x_sr_task_rec.type_name is null or p_x_sr_task_rec.type_name = FND_API.G_MISS_CHAR)) THEN
1416: IF (fnd_profile.value('AHL_PRD_SR_TYPE') is not null) THEN
1417: p_x_sr_task_rec.type_id := fnd_profile.value('AHL_PRD_SR_TYPE');
1418: p_x_sr_task_rec.type_name := fnd_profile.value('AHL_PRD_SR_TYPE');
1419: ELSE
1420: Fnd_Message.SET_NAME('AHL','AHL_PRD_SR_TYPE_REQ');
1421: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);

Line 1418: p_x_sr_task_rec.type_name := fnd_profile.value('AHL_PRD_SR_TYPE');

1414: IF ((p_x_sr_task_rec.type_id is null or p_x_sr_task_rec.type_id = FND_API.G_MISS_NUM)and
1415: (p_x_sr_task_rec.type_name is null or p_x_sr_task_rec.type_name = FND_API.G_MISS_CHAR)) THEN
1416: IF (fnd_profile.value('AHL_PRD_SR_TYPE') is not null) THEN
1417: p_x_sr_task_rec.type_id := fnd_profile.value('AHL_PRD_SR_TYPE');
1418: p_x_sr_task_rec.type_name := fnd_profile.value('AHL_PRD_SR_TYPE');
1419: ELSE
1420: Fnd_Message.SET_NAME('AHL','AHL_PRD_SR_TYPE_REQ');
1421: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1422: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);

Line 1435: IF (fnd_profile.value('AHL_PRD_SR_STATUS') is not null) THEN

1431: -- If profile value is null then default it to OPEN.
1432: IF ((p_x_sr_task_rec.status_id is null or p_x_sr_task_rec.status_id = FND_API.G_MISS_NUM)and
1433: (p_x_sr_task_rec.status_name is null or p_x_sr_task_rec.status_name = FND_API.G_MISS_CHAR)) THEN
1434:
1435: IF (fnd_profile.value('AHL_PRD_SR_STATUS') is not null) THEN
1436: p_x_sr_task_rec.status_id := fnd_profile.value('AHL_PRD_SR_STATUS');
1437: ELSE
1438: -- Removing cursor cs_sr_status as status_code is obsoleted as per the update from SR Team
1439: -- and we should use incident_status_id directly. - Balaji.

Line 1436: p_x_sr_task_rec.status_id := fnd_profile.value('AHL_PRD_SR_STATUS');

1432: IF ((p_x_sr_task_rec.status_id is null or p_x_sr_task_rec.status_id = FND_API.G_MISS_NUM)and
1433: (p_x_sr_task_rec.status_name is null or p_x_sr_task_rec.status_name = FND_API.G_MISS_CHAR)) THEN
1434:
1435: IF (fnd_profile.value('AHL_PRD_SR_STATUS') is not null) THEN
1436: p_x_sr_task_rec.status_id := fnd_profile.value('AHL_PRD_SR_STATUS');
1437: ELSE
1438: -- Removing cursor cs_sr_status as status_code is obsoleted as per the update from SR Team
1439: -- and we should use incident_status_id directly. - Balaji.
1440: /*

Line 1465: IF (fnd_profile.value('AHL_PRD_SR_SEVERITY') is not null) THEN

1461: -- If profile value is null then return an error message.
1462: IF ((p_x_sr_task_rec.severity_id is null or p_x_sr_task_rec.severity_id = FND_API.G_MISS_NUM)and
1463: (p_x_sr_task_rec.severity_name is null or p_x_sr_task_rec.severity_name = FND_API.G_MISS_CHAR)) THEN
1464:
1465: IF (fnd_profile.value('AHL_PRD_SR_SEVERITY') is not null) THEN
1466: p_x_sr_task_rec.severity_id := fnd_profile.value('AHL_PRD_SR_SEVERITY');
1467:
1468: -- Validate the severity value
1469: OPEN cs_sr_severity_validate(p_x_sr_task_rec.severity_id);

Line 1466: p_x_sr_task_rec.severity_id := fnd_profile.value('AHL_PRD_SR_SEVERITY');

1462: IF ((p_x_sr_task_rec.severity_id is null or p_x_sr_task_rec.severity_id = FND_API.G_MISS_NUM)and
1463: (p_x_sr_task_rec.severity_name is null or p_x_sr_task_rec.severity_name = FND_API.G_MISS_CHAR)) THEN
1464:
1465: IF (fnd_profile.value('AHL_PRD_SR_SEVERITY') is not null) THEN
1466: p_x_sr_task_rec.severity_id := fnd_profile.value('AHL_PRD_SR_SEVERITY');
1467:
1468: -- Validate the severity value
1469: OPEN cs_sr_severity_validate(p_x_sr_task_rec.severity_id);
1470:

Line 1517: IF ( fnd_profile.value('AHL_PRD_TASK_EST_DURATION') is not null) THEN

1513: -- If duration is null then derive it from profile.
1514: -- If profile value is null then default it to 1.
1515: IF (p_x_sr_task_rec.duration is null or p_x_sr_task_rec.duration = FND_API.G_MISS_NUM) THEN
1516:
1517: IF ( fnd_profile.value('AHL_PRD_TASK_EST_DURATION') is not null) THEN
1518: p_x_sr_task_rec.duration := fnd_profile.value('AHL_PRD_TASK_EST_DURATION');
1519: ELSE
1520: p_x_sr_task_rec.duration := 1;
1521: END IF;

Line 1518: p_x_sr_task_rec.duration := fnd_profile.value('AHL_PRD_TASK_EST_DURATION');

1514: -- If profile value is null then default it to 1.
1515: IF (p_x_sr_task_rec.duration is null or p_x_sr_task_rec.duration = FND_API.G_MISS_NUM) THEN
1516:
1517: IF ( fnd_profile.value('AHL_PRD_TASK_EST_DURATION') is not null) THEN
1518: p_x_sr_task_rec.duration := fnd_profile.value('AHL_PRD_TASK_EST_DURATION');
1519: ELSE
1520: p_x_sr_task_rec.duration := 1;
1521: END IF;
1522: END IF;

Line 1588: IF ( fnd_profile.value('AHL_PRD_SR_CUSTOMER_NAME') is not null ) THEN

1584: -- Derive the Customer info from Profile and
1585: -- Contact info from fnd_user.user_id
1586: IF ((p_x_sr_task_rec.customer_id IS NULL or p_x_sr_task_rec.customer_id = FND_API.G_MISS_NUM ) and
1587: (p_x_sr_task_rec.contact_id IS NULL or p_x_sr_task_rec.contact_id = FND_API.G_MISS_NUM)) THEN
1588: IF ( fnd_profile.value('AHL_PRD_SR_CUSTOMER_NAME') is not null ) THEN
1589:
1590: OPEN default_customer_type;
1591: FETCH default_customer_type INTO p_x_sr_task_rec.customer_type;
1592:

Line 1600: p_x_sr_task_rec.customer_id := fnd_profile.value('AHL_PRD_SR_CUSTOMER_NAME');

1596: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1597: Fnd_Msg_Pub.ADD;
1598: x_return_status := FND_API.G_RET_STS_ERROR;
1599: ELSE
1600: p_x_sr_task_rec.customer_id := fnd_profile.value('AHL_PRD_SR_CUSTOMER_NAME');
1601: END IF;
1602:
1603: CLOSE default_customer_type;
1604:

Line 1750: IF ( nvl(fnd_profile.value('AHL_SR_RESL_CODE_COMP'), 'N') = 'Y') THEN

1746: -- Bug # 6447467 -- start
1747: -- Check if resolution_meaning is not null. If resolution_meaning
1748: -- is null then return error message.
1749:
1750: IF ( nvl(fnd_profile.value('AHL_SR_RESL_CODE_COMP'), 'N') = 'Y') THEN
1751:
1752: IF ( p_x_sr_task_rec.resolution_meaning IS NULL OR
1753: p_x_sr_task_rec.resolution_meaning = FND_API.G_MISS_CHAR) THEN
1754:

Line 1919: AND incident_type_id=fnd_profile.value('AHL_PRD_SR_TYPE')

1915: where INCIDENT_SUBTYPE = 'INC'
1916: AND CMRO_FLAG = 'Y'
1917: -- Check added by balaji for bug # 4146503.
1918: -- always has to pick up the SR type id from AHL default SR Type profile.
1919: AND incident_type_id=fnd_profile.value('AHL_PRD_SR_TYPE')
1920: AND trunc(sysdate) between trunc(nvl(start_date_active,sysdate))
1921: AND trunc(nvl(end_date_active,sysdate));
1922: -- END Changes
1923: BEGIN