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 1436: WHERE party_id = fnd_profile.value('AHL_PRD_SR_CUSTOMER_NAME');

1432:
1433: CURSOR default_customer_type IS
1434: SELECT party_type
1435: FROM hz_parties
1436: WHERE party_id = fnd_profile.value('AHL_PRD_SR_CUSTOMER_NAME');
1437:
1438: -- Changes made by by VSUNDARA For SR Integration
1439: CURSOR default_party_id(p_item_instance_number IN NUMBER) IS
1440: SELECT OWNER_PARTY_ID

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

1517: -- Bug # 6447467 -- start
1518: -- Check if resolution_meaning is not null. If resolution_meaning
1519: -- is null then return error message.
1520:
1521: IF ( nvl(fnd_profile.value('AHL_SR_RESL_CODE_COMP'), 'N') = 'Y') THEN
1522:
1523: IF ( p_x_sr_task_rec.resolution_meaning IS NULL OR
1524: p_x_sr_task_rec.resolution_meaning = FND_API.G_MISS_CHAR) THEN
1525:

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

1559: -- return an error message
1560:
1561: IF ((p_x_sr_task_rec.type_id is null or p_x_sr_task_rec.type_id = FND_API.G_MISS_NUM)and
1562: (p_x_sr_task_rec.type_name is null or p_x_sr_task_rec.type_name = FND_API.G_MISS_CHAR)) THEN
1563: IF (fnd_profile.value('AHL_PRD_SR_TYPE') is not null) THEN
1564: p_x_sr_task_rec.type_id := fnd_profile.value('AHL_PRD_SR_TYPE');
1565: p_x_sr_task_rec.type_name := fnd_profile.value('AHL_PRD_SR_TYPE');
1566: ELSE
1567: Fnd_Message.SET_NAME('AHL','AHL_PRD_SR_TYPE_REQ');

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

1560:
1561: IF ((p_x_sr_task_rec.type_id is null or p_x_sr_task_rec.type_id = FND_API.G_MISS_NUM)and
1562: (p_x_sr_task_rec.type_name is null or p_x_sr_task_rec.type_name = FND_API.G_MISS_CHAR)) THEN
1563: IF (fnd_profile.value('AHL_PRD_SR_TYPE') is not null) THEN
1564: p_x_sr_task_rec.type_id := fnd_profile.value('AHL_PRD_SR_TYPE');
1565: p_x_sr_task_rec.type_name := fnd_profile.value('AHL_PRD_SR_TYPE');
1566: ELSE
1567: Fnd_Message.SET_NAME('AHL','AHL_PRD_SR_TYPE_REQ');
1568: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);

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

1561: IF ((p_x_sr_task_rec.type_id is null or p_x_sr_task_rec.type_id = FND_API.G_MISS_NUM)and
1562: (p_x_sr_task_rec.type_name is null or p_x_sr_task_rec.type_name = FND_API.G_MISS_CHAR)) THEN
1563: IF (fnd_profile.value('AHL_PRD_SR_TYPE') is not null) THEN
1564: p_x_sr_task_rec.type_id := fnd_profile.value('AHL_PRD_SR_TYPE');
1565: p_x_sr_task_rec.type_name := fnd_profile.value('AHL_PRD_SR_TYPE');
1566: ELSE
1567: Fnd_Message.SET_NAME('AHL','AHL_PRD_SR_TYPE_REQ');
1568: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1569: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);

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

1578: -- If profile value is null then default it to OPEN.
1579: IF ((p_x_sr_task_rec.status_id is null or p_x_sr_task_rec.status_id = FND_API.G_MISS_NUM)and
1580: (p_x_sr_task_rec.status_name is null or p_x_sr_task_rec.status_name = FND_API.G_MISS_CHAR)) THEN
1581:
1582: IF (fnd_profile.value('AHL_PRD_SR_STATUS') is not null) THEN
1583: p_x_sr_task_rec.status_id := fnd_profile.value('AHL_PRD_SR_STATUS');
1584: ELSE
1585: -- Removing cursor cs_sr_status as status_code is obsoleted as per the update from SR Team
1586: -- and we should use incident_status_id directly. - Balaji.

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

1579: IF ((p_x_sr_task_rec.status_id is null or p_x_sr_task_rec.status_id = FND_API.G_MISS_NUM)and
1580: (p_x_sr_task_rec.status_name is null or p_x_sr_task_rec.status_name = FND_API.G_MISS_CHAR)) THEN
1581:
1582: IF (fnd_profile.value('AHL_PRD_SR_STATUS') is not null) THEN
1583: p_x_sr_task_rec.status_id := fnd_profile.value('AHL_PRD_SR_STATUS');
1584: ELSE
1585: -- Removing cursor cs_sr_status as status_code is obsoleted as per the update from SR Team
1586: -- and we should use incident_status_id directly. - Balaji.
1587: /*

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

1614: -- If profile value is null then return an error message.
1615: IF ((p_x_sr_task_rec.severity_id is null or p_x_sr_task_rec.severity_id = FND_API.G_MISS_NUM)and
1616: (p_x_sr_task_rec.severity_name is null or p_x_sr_task_rec.severity_name = FND_API.G_MISS_CHAR)) THEN
1617:
1618: IF (fnd_profile.value('AHL_PRD_SR_SEVERITY') is not null) THEN
1619: p_x_sr_task_rec.severity_id := fnd_profile.value('AHL_PRD_SR_SEVERITY');
1620:
1621: -- Validate the severity value
1622: OPEN cs_sr_severity_validate(p_x_sr_task_rec.severity_id);

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

1615: IF ((p_x_sr_task_rec.severity_id is null or p_x_sr_task_rec.severity_id = FND_API.G_MISS_NUM)and
1616: (p_x_sr_task_rec.severity_name is null or p_x_sr_task_rec.severity_name = FND_API.G_MISS_CHAR)) THEN
1617:
1618: IF (fnd_profile.value('AHL_PRD_SR_SEVERITY') is not null) THEN
1619: p_x_sr_task_rec.severity_id := fnd_profile.value('AHL_PRD_SR_SEVERITY');
1620:
1621: -- Validate the severity value
1622: OPEN cs_sr_severity_validate(p_x_sr_task_rec.severity_id);
1623:

Line 1679: /*IF ( fnd_profile.value('AHL_PRD_TASK_EST_DURATION') is not null) THEN

1675: -- If profile value is null then default it to 1.
1676: --apattark changed for ER 9368251 to pass 0 if the duration is null
1677: IF (p_x_sr_task_rec.duration is null or p_x_sr_task_rec.duration = FND_API.G_MISS_NUM) THEN
1678: p_x_sr_task_rec.duration := 0;
1679: /*IF ( fnd_profile.value('AHL_PRD_TASK_EST_DURATION') is not null) THEN
1680: p_x_sr_task_rec.duration := fnd_profile.value('AHL_PRD_TASK_EST_DURATION');
1681: ELSE
1682: p_x_sr_task_rec.duration := 1;
1683: END IF;

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

1676: --apattark changed for ER 9368251 to pass 0 if the duration is null
1677: IF (p_x_sr_task_rec.duration is null or p_x_sr_task_rec.duration = FND_API.G_MISS_NUM) THEN
1678: p_x_sr_task_rec.duration := 0;
1679: /*IF ( fnd_profile.value('AHL_PRD_TASK_EST_DURATION') is not null) THEN
1680: p_x_sr_task_rec.duration := fnd_profile.value('AHL_PRD_TASK_EST_DURATION');
1681: ELSE
1682: p_x_sr_task_rec.duration := 1;
1683: END IF;
1684: */

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

1747: -- Derive the Customer info from Profile and
1748: -- Contact info from fnd_user.user_id
1749: IF ((p_x_sr_task_rec.customer_id IS NULL or p_x_sr_task_rec.customer_id = FND_API.G_MISS_NUM ) and
1750: (p_x_sr_task_rec.contact_id IS NULL or p_x_sr_task_rec.contact_id = FND_API.G_MISS_NUM)) THEN
1751: IF ( fnd_profile.value('AHL_PRD_SR_CUSTOMER_NAME') is not null ) THEN
1752:
1753: OPEN default_customer_type;
1754: FETCH default_customer_type INTO p_x_sr_task_rec.customer_type;
1755:

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

1759: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1760: Fnd_Msg_Pub.ADD;
1761: x_return_status := FND_API.G_RET_STS_ERROR;
1762: ELSE
1763: p_x_sr_task_rec.customer_id := fnd_profile.value('AHL_PRD_SR_CUSTOMER_NAME');
1764: END IF;
1765:
1766: CLOSE default_customer_type;
1767:

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

1932: -- Bug # 6447467 -- start
1933: -- Check if resolution_meaning is not null. If resolution_meaning
1934: -- is null then return error message.
1935:
1936: IF ( nvl(fnd_profile.value('AHL_SR_RESL_CODE_COMP'), 'N') = 'Y') THEN
1937:
1938: IF ( p_x_sr_task_rec.resolution_meaning IS NULL OR
1939: p_x_sr_task_rec.resolution_meaning = FND_API.G_MISS_CHAR) THEN
1940:

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

2101: where INCIDENT_SUBTYPE = 'INC'
2102: AND CMRO_FLAG = 'Y'
2103: -- Check added by balaji for bug # 4146503.
2104: -- always has to pick up the SR type id from AHL default SR Type profile.
2105: AND incident_type_id=fnd_profile.value('AHL_PRD_SR_TYPE')
2106: AND trunc(sysdate) between trunc(nvl(start_date_active,sysdate))
2107: AND trunc(nvl(end_date_active,sysdate));
2108: -- END Changes
2109: