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

Line 84: l_x_return_status := FND_API.G_RET_STS_SUCCESS;

80: 'Visit Task ID: '|| p_visit_task_id);
81: END IF;
82:
83: --Initialize API return status to success
84: l_x_return_status := FND_API.G_RET_STS_SUCCESS;
85:
86: -- Get the items from Resource Requirements of the route
87:
88: Check_Item_for_Rt_Res_Req

Line 98: IF (l_x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

94: x_item_tbl =>l_res_item_tbl ,
95: x_return_status =>l_x_return_status
96: );
97:
98: IF (l_x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
99: RAISE Fnd_Api.G_EXC_ERROR;
100: END IF;
101:
102: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 99: RAISE Fnd_Api.G_EXC_ERROR;

95: x_return_status =>l_x_return_status
96: );
97:
98: IF (l_x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
99: RAISE Fnd_Api.G_EXC_ERROR;
100: END IF;
101:
102: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
103: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 122: IF (l_x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

118: x_item_tbl =>l_mat_item_tbl ,
119: x_return_status =>l_x_return_status
120: );
121:
122: IF (l_x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
123: RAISE Fnd_Api.G_EXC_ERROR;
124: END IF;
125:
126: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 123: RAISE Fnd_Api.G_EXC_ERROR;

119: x_return_status =>l_x_return_status
120: );
121:
122: IF (l_x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
123: RAISE Fnd_Api.G_EXC_ERROR;
124: END IF;
125:
126: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
127: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 168: IF (l_x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

164: );
165:
166: END IF;
167:
168: IF (l_x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
169: RAISE Fnd_Api.G_EXC_ERROR;
170: END IF;
171:
172: -- Assign return status and Item without Price table

Line 169: RAISE Fnd_Api.G_EXC_ERROR;

165:
166: END IF;
167:
168: IF (l_x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
169: RAISE Fnd_Api.G_EXC_ERROR;
170: END IF;
171:
172: -- Assign return status and Item without Price table
173: x_return_status:=l_x_return_status;

Line 226: l_x_return_status := FND_API.G_RET_STS_SUCCESS;

222: 'Visit Task ID: '|| p_visit_task_id);
223: END IF;
224:
225: --Initialize API return status to success
226: l_x_return_status := FND_API.G_RET_STS_SUCCESS;
227:
228: -- Get the items from Resource Requirements of the route
229:
230: Check_Item_for_Prod_Res_Req

Line 351: l_x_return_status := FND_API.G_RET_STS_SUCCESS;

347: 'Visit Task ID: '|| p_visit_task_id);
348: END IF;
349:
350: --Initialize API return status to success
351: l_x_return_status := FND_API.G_RET_STS_SUCCESS;
352:
353: -- Get the items from Resource Transactions of the WIP job of this task
354:
355: Check_Item_for_Resource_Trans

Line 494: l_x_return_status := FND_API.G_RET_STS_SUCCESS;

490: 'At the start of the procedure');
491: END IF;
492:
493: --Initialize API return status to success
494: l_x_return_status := FND_API.G_RET_STS_SUCCESS;
495:
496: -- If duration passed in is null then default to 1
497: IF p_duration is not NULL AND p_duration <> FND_API.G_MISS_NUM THEN
498: l_duration := p_duration;

Line 497: IF p_duration is not NULL AND p_duration <> FND_API.G_MISS_NUM THEN

493: --Initialize API return status to success
494: l_x_return_status := FND_API.G_RET_STS_SUCCESS;
495:
496: -- If duration passed in is null then default to 1
497: IF p_duration is not NULL AND p_duration <> FND_API.G_MISS_NUM THEN
498: l_duration := p_duration;
499: END IF;
500:
501: -- Passing Information to the Pricing Engine

Line 629: IF (l_x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

625: 'Return Status text: '||l_x_return_status_text );
626: END IF;
627:
628:
629: IF (l_x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
630: FND_MESSAGE.Set_Name('AHL','AHL_VWP_PRICE_API_ERROR');
631: FND_MESSAGE.Set_Token('ERROR', l_x_return_status_text);
632: FND_MSG_PUB.Add;
633: RAISE FND_API.G_EXC_ERROR;

Line 633: RAISE FND_API.G_EXC_ERROR;

629: IF (l_x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
630: FND_MESSAGE.Set_Name('AHL','AHL_VWP_PRICE_API_ERROR');
631: FND_MESSAGE.Set_Token('ERROR', l_x_return_status_text);
632: FND_MSG_PUB.Add;
633: RAISE FND_API.G_EXC_ERROR;
634: END IF;
635:
636:
637: -- Unit Price returned

Line 678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

674: 'Return Status is: '|| x_return_status);
675: END IF;
676:
677: EXCEPTION
678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
679: ROLLBACK TO Get_Item_Price;
680: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
681:
682: WHEN FND_API.G_EXC_ERROR THEN

Line 680: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

676:
677: EXCEPTION
678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
679: ROLLBACK TO Get_Item_Price;
680: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
681:
682: WHEN FND_API.G_EXC_ERROR THEN
683: ROLLBACK TO Get_Item_Price;
684: X_return_status := FND_API.G_RET_STS_ERROR;

Line 682: WHEN FND_API.G_EXC_ERROR THEN

678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
679: ROLLBACK TO Get_Item_Price;
680: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
681:
682: WHEN FND_API.G_EXC_ERROR THEN
683: ROLLBACK TO Get_Item_Price;
684: X_return_status := FND_API.G_RET_STS_ERROR;
685:
686: WHEN OTHERS THEN

Line 684: X_return_status := FND_API.G_RET_STS_ERROR;

680: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
681:
682: WHEN FND_API.G_EXC_ERROR THEN
683: ROLLBACK TO Get_Item_Price;
684: X_return_status := FND_API.G_RET_STS_ERROR;
685:
686: WHEN OTHERS THEN
687: ROLLBACK TO Get_Item_Price;
688: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 688: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

684: X_return_status := FND_API.G_RET_STS_ERROR;
685:
686: WHEN OTHERS THEN
687: ROLLBACK TO Get_Item_Price;
688: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
689:
690: END Get_Item_Price;
691:
692: --------------------------------------------------------------------

Line 729: l_x_return_status := FND_API.G_RET_STS_SUCCESS;

725: 'Number of Items to check: '|| p_item_tbl.count);
726: END IF;
727:
728: --Initialize API return status to success
729: l_x_return_status := FND_API.G_RET_STS_SUCCESS;
730:
731: -- For each item in p_item_tbl, check for price
732: -- If price is not set up in price list
733: -- Add this item to output item table

Line 868: l_x_return_status := FND_API.G_RET_STS_SUCCESS;

864:
865: END IF;
866:
867: --Initialize API return status to success
868: l_x_return_status := FND_API.G_RET_STS_SUCCESS;
869:
870: -- Get all material requirements for the job
871:
872: Open get_prod_materials_csr(p_visit_task_id);

Line 975: l_x_return_status := FND_API.G_RET_STS_SUCCESS;

971:
972: END IF;
973:
974: --Initialize API return status to success
975: l_x_return_status := FND_API.G_RET_STS_SUCCESS;
976:
977: -- Get all material requirements for the job
978:
979: Open get_prod_res_req_csr(p_visit_task_id);

Line 997: RAISE Fnd_Api.G_EXC_ERROR;

993: Fnd_Message.SET_NAME('AHL','AHL_VWP_WRONG_ITEM_UOM');
994: Fnd_Message.SET_TOKEN('INV_ITEM',l_prod_res_req_rec.item_name);
995: Fnd_Msg_Pub.ADD;
996: CLOSE get_prod_res_req_csr;
997: RAISE Fnd_Api.G_EXC_ERROR;
998:
999: END IF;
1000:
1001: l_x_item_tbl(I).item_id :=l_prod_res_req_rec.BILLABLE_ITEM_ID;

Line 1131: l_x_return_status := FND_API.G_RET_STS_SUCCESS;

1127: 'Route ID: '|| p_route_id);
1128: END IF;
1129:
1130: --Initialize API return status to success
1131: l_x_return_status := FND_API.G_RET_STS_SUCCESS;
1132:
1133: -- Check to see if material requirements are defined at route level
1134:
1135: Open get_rt_materials_csr(p_route_id,p_visit_task_id);

Line 1382: l_x_return_status := FND_API.G_RET_STS_SUCCESS;

1378: 'Organization ID: '|| p_organization_id);
1379: END IF;
1380:
1381: --Initialize API return status to success
1382: l_x_return_status := FND_API.G_RET_STS_SUCCESS;
1383:
1384: -- Check to see if resource requirements are defined at route level
1385:
1386: Open check_rt_resources_csr(p_route_id);

Line 1418: RAISE Fnd_Api.G_EXC_ERROR;

1414: Fnd_Message.SET_TOKEN('INV_ITEM',l_oper_resource_req_rec.item_name);
1415: Fnd_Msg_Pub.ADD;
1416: CLOSE get_oper_resources_csr;
1417: CLOSE check_rt_resources_csr;
1418: RAISE Fnd_Api.G_EXC_ERROR;
1419:
1420: END IF;
1421:
1422: l_x_item_tbl(I).item_id :=l_oper_resource_req_rec.BILLABLE_ITEM_ID;

Line 1464: RAISE Fnd_Api.G_EXC_ERROR;

1460: Fnd_Message.SET_TOKEN('INV_ITEM',l_rt_resource_rec.item_name);
1461: Fnd_Msg_Pub.ADD;
1462: CLOSE get_rt_resources_csr;
1463: CLOSE check_rt_resources_csr;
1464: RAISE Fnd_Api.G_EXC_ERROR;
1465:
1466: END IF;
1467:
1468: l_x_item_tbl(I).item_id :=l_rt_resource_rec.BILLABLE_ITEM_ID;

Line 1571: l_x_return_status := FND_API.G_RET_STS_SUCCESS;

1567:
1568: END IF;
1569:
1570: --Initialize API return status to success
1571: l_x_return_status := FND_API.G_RET_STS_SUCCESS;
1572:
1573: -- Get all material requirements for the job
1574:
1575: Open get_resource_trans_csr(p_visit_task_id);

Line 1700: l_x_return_status := FND_API.G_RET_STS_SUCCESS;

1696:
1697: END IF;
1698:
1699: --Initialize API return status to success
1700: l_x_return_status := FND_API.G_RET_STS_SUCCESS;
1701:
1702: -- Get all material requirements for the job
1703:
1704: Open get_materials_trans_csr(p_visit_task_id);

Line 1773: l_x_return_status := FND_API.G_RET_STS_SUCCESS;

1769: 'Number of Items to calculate: '|| p_item_tbl.count);
1770: END IF;
1771:
1772: --Initialize API return status to success
1773: l_x_return_status := FND_API.G_RET_STS_SUCCESS;
1774:
1775: -- For each item in p_item_tbl, check for price
1776:
1777: I := p_item_tbl.FIRST;