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

Line 41: x_return_status := FND_API.G_RET_STS_SUCCESS;

37: l_Meta_Attribute_Tbl LovMetaAttribute_Tbl_Type;
38:
39: BEGIN
40:
41: x_return_status := FND_API.G_RET_STS_SUCCESS;
42:
43: -- Create Attributes Table
44: -- Visit ID
45: l_Meta_Attribute_Rec.AttributeName := 'VisitId';

Line 166: x_return_status := FND_API.G_RET_STS_SUCCESS;

162: l_unit ahl_unit_config_headers.name%type;
163:
164: BEGIN
165:
166: x_return_status := FND_API.G_RET_STS_SUCCESS;
167:
168: -- SELECT CLAUSE AND BASIC WHERE CONDITIONS
169: l_sql_string := 'SELECT * FROM ( SELECT DISTINCT Rownum RN, vst.visit_id,';
170: l_sql_string := l_sql_string || ' vst.visit_number,fndvt.meaning visit_type_mean, ';

Line 376: x_return_status := FND_API.G_RET_STS_SUCCESS;

372: l_Meta_Attribute_Tbl LovMetaAttribute_Tbl_Type;
373:
374: BEGIN
375:
376: x_return_status := FND_API.G_RET_STS_SUCCESS;
377:
378: -- Create Attributes Table
379: -- Unit Config Header ID
380: l_Meta_Attribute_Rec.AttributeName := 'UnitConfigHeaderId';

Line 471: x_return_status := FND_API.G_RET_STS_SUCCESS;

467: l_item MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%type;
468:
469: BEGIN
470:
471: x_return_status := FND_API.G_RET_STS_SUCCESS;
472:
473: -- SELECT CLAUSE AND BASIC WHERE CONDITIONS
474: l_sql_string := 'SELECT * FROM ( SELECT DISTINCT Rownum RN, U.UNIT_CONFIG_HEADER_ID UC_HEADER_ID,';
475: l_sql_string := l_sql_string || ' U.NAME UC_NAME,C.INSTANCE_NUMBER , ';

Line 627: x_return_status := FND_API.G_RET_STS_SUCCESS;

623: l_Meta_Attribute_Tbl LovMetaAttribute_Tbl_Type;
624:
625: BEGIN
626:
627: x_return_status := FND_API.G_RET_STS_SUCCESS;
628:
629: -- Create Attributes Table
630: l_Meta_Attribute_Rec.AttributeName := 'EmployeeNumber';
631: l_Meta_Attribute_Rec.Prompt := 'Employee Number';

Line 739: x_return_status := FND_API.G_RET_STS_SUCCESS;

735: l_emp_id NUMBER;
736:
737: BEGIN
738:
739: x_return_status := FND_API.G_RET_STS_SUCCESS;
740:
741: -- SELECT CLAUSE AND BASIC WHERE CONDITIONS
742: l_sql_string := 'SELECT ROWNUM, A.* FROM ( SELECT DISTINCT PF.EMPLOYEE_NUM EMPLOYEE_NUMBER,';
743: l_sql_string := l_sql_string || ' PF.FULL_NAME EMP_NAME, BRE.EFFECTIVE_START_DATE , ';

Line 919: x_return_status := FND_API.G_RET_STS_SUCCESS;

915: l_Meta_Attribute_Tbl LovMetaAttribute_Tbl_Type;
916:
917: BEGIN
918:
919: x_return_status := FND_API.G_RET_STS_SUCCESS;
920:
921: -- Create Attributes Table
922: l_Meta_Attribute_Rec.AttributeName := 'EmpName';
923: l_Meta_Attribute_Rec.Prompt := 'Name';

Line 1028: x_return_status := FND_API.G_RET_STS_SUCCESS;

1024:
1025:
1026: BEGIN
1027:
1028: x_return_status := FND_API.G_RET_STS_SUCCESS;
1029:
1030: -- SELECT CLAUSE AND BASIC WHERE CONDITIONS
1031: l_sql_string := 'SELECT rownum, A.* FROM ( SELECT DISTINCT bdri.resource_id ,pf.employee_num,pf.full_name, bdri.department_id,pf.employee_id ';
1032: l_sql_string := l_sql_string || ' FROM mtl_employees_current_view pf, bom_resource_employees bre, bom_dept_res_instances bdri ';

Line 1180: x_return_status := FND_API.G_RET_STS_SUCCESS;

1176: l_Meta_Attribute_Tbl LovMetaAttribute_Tbl_Type;
1177:
1178: BEGIN
1179:
1180: x_return_status := FND_API.G_RET_STS_SUCCESS;
1181:
1182: -- Create Attributes Table
1183: l_Meta_Attribute_Rec.AttributeName := 'Code';
1184: l_Meta_Attribute_Rec.Prompt := 'Code';

Line 1249: x_return_status := FND_API.G_RET_STS_SUCCESS;

1245: l_rownum NUMBER;
1246:
1247: BEGIN
1248:
1249: x_return_status := FND_API.G_RET_STS_SUCCESS;
1250:
1251: -- SELECT CLAUSE AND BASIC WHERE CONDITIONS
1252: l_sql_string := 'SELECT rownum , meaning,STATUS_CODE FROM ( select DISTINCT FND.MEANING meaning, SOR.NEXT_STATUS_CODE STATUS_CODE ';
1253: l_sql_string := l_sql_string || ' FROM AHL_STATUS_ORDER_RULES SOR, FND_LOOKUP_VALUES_VL FND ';

Line 1360: x_return_status := FND_API.G_RET_STS_SUCCESS;

1356: l_Meta_Attribute_Tbl LovMetaAttribute_Tbl_Type;
1357:
1358: BEGIN
1359:
1360: x_return_status := FND_API.G_RET_STS_SUCCESS;
1361:
1362: -- Create Attributes Table
1363: l_Meta_Attribute_Rec.AttributeName := 'Code';
1364: l_Meta_Attribute_Rec.Prompt := 'Code';

Line 1429: x_return_status := FND_API.G_RET_STS_SUCCESS;

1425: l_rownum NUMBER;
1426:
1427: BEGIN
1428:
1429: x_return_status := FND_API.G_RET_STS_SUCCESS;
1430:
1431: -- SELECT CLAUSE AND BASIC WHERE CONDITIONS
1432: l_sql_string := 'SELECT rownum , meaning,lookup_code FROM ( select meaning , lookup_code from ';
1433: l_sql_string := l_sql_string || ' FND_LOOKUP_VALUES_VL FND where lookup_type=''AHL_PRD_WO_HOLD_REASON'' ';

Line 1537: x_return_status := FND_API.G_RET_STS_SUCCESS;

1533: l_Meta_Attribute_Tbl LovMetaAttribute_Tbl_Type;
1534:
1535: BEGIN
1536:
1537: x_return_status := FND_API.G_RET_STS_SUCCESS;
1538:
1539: -- Create Attributes Table
1540: l_Meta_Attribute_Rec.AttributeName := 'WorkorderOperationId';
1541: l_Meta_Attribute_Rec.Prompt := null;

Line 1656: x_return_status := FND_API.G_RET_STS_SUCCESS;

1652: l_dept_id NUMBER;
1653:
1654: BEGIN
1655:
1656: x_return_status := FND_API.G_RET_STS_SUCCESS;
1657:
1658: -- SELECT CLAUSE AND BASIC WHERE CONDITIONS
1659: l_sql_string := 'SELECT * FROM ( SELECT Rownum RN, WORKORDER_OPERATION_ID, ';
1660: l_sql_string := l_sql_string || ' ORGANIZATION_ID, OPERATION_SEQUENCE_NUM, ';

Line 1835: x_return_status := FND_API.G_RET_STS_SUCCESS;

1831: l_Meta_Attribute_Tbl LovMetaAttribute_Tbl_Type;
1832:
1833: BEGIN
1834:
1835: x_return_status := FND_API.G_RET_STS_SUCCESS;
1836:
1837: -- Create Attributes Table
1838: l_Meta_Attribute_Rec.AttributeName := 'ResCodeLovResCode';
1839: l_Meta_Attribute_Rec.Prompt := 'Resource';

Line 1944: x_return_status := FND_API.G_RET_STS_SUCCESS;

1940: l_dept_id NUMBER;
1941:
1942: BEGIN
1943:
1944: x_return_status := FND_API.G_RET_STS_SUCCESS;
1945:
1946: -- SELECT CLAUSE AND BASIC WHERE CONDITIONS
1947: l_sql_string := 'SELECT * FROM ( SELECT Rownum RN, ';
1948: l_sql_string := l_sql_string || ' BR.RESOURCE_ID ,BR.RESOURCE_CODE, BR.description , ';

Line 2115: x_return_status := FND_API.G_RET_STS_SUCCESS;

2111: l_Meta_Attribute_Tbl LovMetaAttribute_Tbl_Type;
2112:
2113: BEGIN
2114:
2115: x_return_status := FND_API.G_RET_STS_SUCCESS;
2116:
2117: -- Create Attributes Table
2118: l_Meta_Attribute_Rec.AttributeName := 'ATACode';
2119: l_Meta_Attribute_Rec.Prompt := 'ATA Code';

Line 2214: x_return_status := FND_API.G_RET_STS_SUCCESS;

2210: l_position ahl_mc_relationships_v.position_ref_meaning%type;
2211:
2212: BEGIN
2213:
2214: x_return_status := FND_API.G_RET_STS_SUCCESS;
2215:
2216: -- SELECT CLAUSE AND BASIC WHERE CONDITIONS
2217: l_sql_string := 'SELECT rownum, A.* FROM ( SELECT DISTINCT ATA_meaning, ATA_Desc, position_ref_meaning, position_key,uc.name ';
2218: l_sql_string := l_sql_string || ' from ahl_mc_relationships_v mc, ahl_unit_config_headers uc ';

Line 2349: x_return_status := FND_API.G_RET_STS_SUCCESS;

2345: l_Meta_Attribute_Tbl LovMetaAttribute_Tbl_Type;
2346:
2347: BEGIN
2348:
2349: x_return_status := FND_API.G_RET_STS_SUCCESS;
2350:
2351: ----
2352: l_Meta_Attribute_Rec.AttributeName := 'Position';
2353: l_Meta_Attribute_Rec.Prompt := 'Position';

Line 2447: x_return_status := FND_API.G_RET_STS_SUCCESS;

2443: l_position ahl_mc_relationships_v.position_ref_meaning%type;
2444:
2445: BEGIN
2446:
2447: x_return_status := FND_API.G_RET_STS_SUCCESS;
2448:
2449: -- SELECT CLAUSE AND BASIC WHERE CONDITIONS
2450: l_sql_string := 'SELECT * FROM ( SELECT DISTINCT Rownum RN, ATA_meaning, position_ref_desc, position_ref_meaning, position_key,uc.name ';
2451: l_sql_string := l_sql_string || ' from ahl_mc_relationships_v mc, ahl_unit_config_headers uc ';

Line 2577: x_return_status := FND_API.G_RET_STS_SUCCESS;

2573: l_Meta_Attribute_Tbl LovMetaAttribute_Tbl_Type;
2574:
2575: BEGIN
2576:
2577: x_return_status := FND_API.G_RET_STS_SUCCESS;
2578:
2579: -- Create Attributes Table
2580: l_Meta_Attribute_Rec.AttributeName := 'SerNumLovSerNum';
2581: l_Meta_Attribute_Rec.Prompt := 'Serial Number';

Line 2666: x_return_status := FND_API.G_RET_STS_SUCCESS;

2662: l_res_id NUMBER;
2663:
2664: BEGIN
2665:
2666: x_return_status := FND_API.G_RET_STS_SUCCESS;
2667:
2668: -- SELECT CLAUSE AND BASIC WHERE CONDITIONS
2669: l_sql_string := 'SELECT * FROM ( SELECT DISTINCT Rownum RN, bdri.SERIAL_NUMBER,';
2670: l_sql_string := l_sql_string || ' bdri.instance_id, bdri.department_id, bdri.resource_id ';

Line 2807: x_return_status := FND_API.G_RET_STS_SUCCESS;

2803: l_Meta_Attribute_Tbl LovMetaAttribute_Tbl_Type;
2804:
2805: BEGIN
2806:
2807: x_return_status := FND_API.G_RET_STS_SUCCESS;
2808:
2809: -- Create Attributes Table
2810: l_Meta_Attribute_Rec.AttributeName := 'SerNumLovSerNum';
2811: l_Meta_Attribute_Rec.Prompt := 'Serial Number';

Line 2896: x_return_status := FND_API.G_RET_STS_SUCCESS;

2892: l_res_id NUMBER;
2893:
2894: BEGIN
2895:
2896: x_return_status := FND_API.G_RET_STS_SUCCESS;
2897:
2898: -- SELECT CLAUSE AND BASIC WHERE CONDITIONS
2899: l_sql_string := 'SELECT * FROM ( SELECT DISTINCT Rownum RN, bdri.SERIAL_NUMBER,';
2900: l_sql_string := l_sql_string || ' bdri.instance_id, bdri.department_id, bdri.resource_id ';

Line 3037: x_return_status := FND_API.G_RET_STS_SUCCESS;

3033: l_Meta_Attribute_Tbl LovMetaAttribute_Tbl_Type;
3034:
3035: BEGIN
3036:
3037: x_return_status := FND_API.G_RET_STS_SUCCESS;
3038:
3039: -- Create Attributes Table
3040: l_Meta_Attribute_Rec.AttributeName := 'ItemNum';
3041: l_Meta_Attribute_Rec.Prompt := 'Item';

Line 3135: x_return_status := FND_API.G_RET_STS_SUCCESS;

3131: l_res_id NUMBER;
3132:
3133: BEGIN
3134:
3135: x_return_status := FND_API.G_RET_STS_SUCCESS;
3136:
3137: -- SELECT CLAUSE AND BASIC WHERE CONDITIONS
3138: l_sql_string := 'SELECT * FROM ( SELECT DISTINCT Rownum RN, bdri.SERIAL_NUMBER,';
3139: l_sql_string := l_sql_string || ' bdri.instance_id, bdri.department_id, bdri.resource_id ';

Line 3276: x_return_status := FND_API.G_RET_STS_SUCCESS;

3272: l_Meta_Attribute_Tbl LovMetaAttribute_Tbl_Type;
3273:
3274: BEGIN
3275:
3276: x_return_status := FND_API.G_RET_STS_SUCCESS;
3277:
3278: -- Create Attributes Table
3279: l_Meta_Attribute_Rec.AttributeName := 'Condition';
3280: l_Meta_Attribute_Rec.Prompt := 'Condition';

Line 3355: x_return_status := FND_API.G_RET_STS_SUCCESS;

3351: l_status_desc mtl_material_statuses.description%type;
3352:
3353: BEGIN
3354:
3355: x_return_status := FND_API.G_RET_STS_SUCCESS;
3356:
3357: -- SELECT CLAUSE AND BASIC WHERE CONDITIONS
3358: l_sql_string := 'SELECT * FROM ( SELECT Rownum RN, status_id,';
3359: l_sql_string := l_sql_string || ' status_code, description ';

Line 3483: x_return_status := FND_API.G_RET_STS_SUCCESS;

3479: l_Meta_Attribute_Tbl LovMetaAttribute_Tbl_Type;
3480:
3481: BEGIN
3482:
3483: x_return_status := FND_API.G_RET_STS_SUCCESS;
3484:
3485: -- Create Attributes Table
3486: l_Meta_Attribute_Rec.AttributeName := 'RemovalLovReason';
3487: l_Meta_Attribute_Rec.Prompt := 'Removal Reason';

Line 3562: x_return_status := FND_API.G_RET_STS_SUCCESS;

3558: l_reason_desc mtl_transaction_reasons.description%type;
3559:
3560: BEGIN
3561:
3562: x_return_status := FND_API.G_RET_STS_SUCCESS;
3563:
3564: -- SELECT CLAUSE AND BASIC WHERE CONDITIONS
3565: l_sql_string := 'SELECT * FROM ( SELECT Rownum RN, reason_name,';
3566: l_sql_string := l_sql_string || ' reason_id, description ';

Line 3690: x_return_status := FND_API.G_RET_STS_SUCCESS;

3686: l_Meta_Attribute_Tbl LovMetaAttribute_Tbl_Type;
3687:
3688: BEGIN
3689:
3690: x_return_status := FND_API.G_RET_STS_SUCCESS;
3691:
3692: -- Create Attributes Table
3693: l_Meta_Attribute_Rec.AttributeName := 'RemovalLovCode';
3694: l_Meta_Attribute_Rec.Prompt := 'Removal Code';

Line 3759: x_return_status := FND_API.G_RET_STS_SUCCESS;

3755: l_mean FND_LOOKUP_VALUES_VL.meaning%type;
3756:
3757: BEGIN
3758:
3759: x_return_status := FND_API.G_RET_STS_SUCCESS;
3760:
3761: -- SELECT CLAUSE AND BASIC WHERE CONDITIONS
3762: l_sql_string := 'SELECT * FROM ( SELECT Rownum RN, meaning,';
3763: l_sql_string := l_sql_string || ' lookup_code ';

Line 3874: x_return_status := FND_API.G_RET_STS_SUCCESS;

3870: l_Meta_Attribute_Tbl LovMetaAttribute_Tbl_Type;
3871:
3872: BEGIN
3873:
3874: x_return_status := FND_API.G_RET_STS_SUCCESS;
3875:
3876: -- Create Attributes Table
3877: l_Meta_Attribute_Rec.AttributeName := 'ResolutionLovCode';
3878: l_Meta_Attribute_Rec.Prompt := 'Resolution Code';

Line 3943: x_return_status := FND_API.G_RET_STS_SUCCESS;

3939: l_mean FND_LOOKUP_VALUES_VL.meaning%type;
3940:
3941: BEGIN
3942:
3943: x_return_status := FND_API.G_RET_STS_SUCCESS;
3944:
3945: -- SELECT CLAUSE AND BASIC WHERE CONDITIONS
3946: l_sql_string := 'SELECT * FROM ( SELECT Rownum RN, meaning,';
3947: l_sql_string := l_sql_string || ' lookup_code ';

Line 4058: x_return_status := FND_API.G_RET_STS_SUCCESS;

4054: l_Meta_Attribute_Tbl LovMetaAttribute_Tbl_Type;
4055:
4056: BEGIN
4057:
4058: x_return_status := FND_API.G_RET_STS_SUCCESS;
4059:
4060: -- Create Attributes Table
4061: l_Meta_Attribute_Rec.AttributeName := 'ProblemLovCode';
4062: l_Meta_Attribute_Rec.Prompt := 'Problem Code';

Line 4127: x_return_status := FND_API.G_RET_STS_SUCCESS;

4123: l_mean FND_LOOKUP_VALUES_VL.meaning%type;
4124:
4125: BEGIN
4126:
4127: x_return_status := FND_API.G_RET_STS_SUCCESS;
4128:
4129: -- SELECT CLAUSE AND BASIC WHERE CONDITIONS
4130: l_sql_string := 'SELECT * FROM ( SELECT Rownum RN, description,';
4131: l_sql_string := l_sql_string || ' lookup_code ';

Line 4247: x_return_status := FND_API.G_RET_STS_SUCCESS;

4243: l_Meta_Attribute_Tbl LovMetaAttribute_Tbl_Type;
4244:
4245: BEGIN
4246:
4247: x_return_status := FND_API.G_RET_STS_SUCCESS;
4248:
4249: -- Create Attributes Table
4250: l_Meta_Attribute_Rec.AttributeName := 'SeverityLovName';
4251: l_Meta_Attribute_Rec.Prompt := 'Severity';

Line 4326: x_return_status := FND_API.G_RET_STS_SUCCESS;

4322: l_desc cs_incident_severities_vl.description%type;
4323:
4324: BEGIN
4325:
4326: x_return_status := FND_API.G_RET_STS_SUCCESS;
4327:
4328: -- SELECT CLAUSE AND BASIC WHERE CONDITIONS
4329: l_sql_string := 'SELECT * FROM ( SELECT Rownum RN, name,';
4330: l_sql_string := l_sql_string || ' incident_severity_id, description ';

Line 4456: x_return_status := FND_API.G_RET_STS_SUCCESS;

4452: l_Meta_Attribute_Tbl LovMetaAttribute_Tbl_Type;
4453:
4454: BEGIN
4455:
4456: x_return_status := FND_API.G_RET_STS_SUCCESS;
4457:
4458: -- Create Attributes Table
4459: l_Meta_Attribute_Rec.AttributeName := 'InstanceNum';
4460: l_Meta_Attribute_Rec.Prompt := 'Instance Number';

Line 4545: x_return_status := FND_API.G_RET_STS_SUCCESS;

4541: l_item mtl_system_items_kfv.concatenated_segments%type;
4542:
4543: BEGIN
4544:
4545: x_return_status := FND_API.G_RET_STS_SUCCESS;
4546:
4547: -- SELECT CLAUSE AND BASIC WHERE CONDITIONS
4548: l_sql_string := 'SELECT * FROM ( SELECT Rownum RN, csi1.instance_number, csi1.lot_number,';
4549: l_sql_string := l_sql_string || ' csi1.serial_number, ahl1.concatenated_segments ';

Line 4678: x_return_status := FND_API.G_RET_STS_SUCCESS;

4674: l_Meta_Attribute_Tbl LovMetaAttribute_Tbl_Type;
4675:
4676: BEGIN
4677:
4678: x_return_status := FND_API.G_RET_STS_SUCCESS;
4679:
4680: -- Create Attributes Table
4681: l_Meta_Attribute_Rec.AttributeName := 'ItemNum';
4682: l_Meta_Attribute_Rec.Prompt := 'Item';

Line 4780: x_return_status := FND_API.G_RET_STS_SUCCESS;

4776: l_wo_id_input BOOLEAN;
4777:
4778: BEGIN
4779:
4780: x_return_status := FND_API.G_RET_STS_SUCCESS;
4781: l_wo_id_input := FALSE;
4782:
4783: -- SELECT CLAUSE AND BASIC WHERE CONDITIONS when wo_id is not null
4784: l_sql_string1 := 'SELECT * FROM ( SELECT Rownum RN, mtl.concatenated_segments , mtl.description , mtl.primary_unit_of_measure, WO.workorder_id, mtl.inventory_item_id ';

Line 4926: x_return_status := FND_API.G_RET_STS_SUCCESS;

4922: x_msg_data OUT NOCOPY VARCHAR2)
4923: IS
4924: BEGIN
4925:
4926: x_return_status := FND_API.G_RET_STS_SUCCESS;
4927:
4928: CASE upper(p_lov_input_rec.lovID)
4929:
4930: WHEN 'AHL_PRD_VISITNUM_LOV' THEN

Line 5120: RAISE FND_API.G_EXC_ERROR;

5116: ELSE
5117: --throw exception;
5118: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_LOV_NOT_FOUND');
5119: FND_MSG_PUB.ADD;
5120: RAISE FND_API.G_EXC_ERROR;
5121: END CASE;
5122:
5123: END getLOVMetaData;
5124:

Line 5144: x_return_status := FND_API.G_RET_STS_SUCCESS;

5140: x_msg_data OUT NOCOPY VARCHAR2)
5141: IS
5142: BEGIN
5143:
5144: x_return_status := FND_API.G_RET_STS_SUCCESS;
5145:
5146: CASE upper(p_lov_input_rec.lovID)
5147:
5148: WHEN 'AHL_PRD_VISITNUM_LOV' THEN

Line 5337: RAISE FND_API.G_EXC_ERROR;

5333: ELSE
5334: --throw exception;
5335: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_LOV_NOT_FOUND');
5336: FND_MSG_PUB.ADD;
5337: RAISE FND_API.G_EXC_ERROR;
5338:
5339: END CASE;
5340:
5341: END getLOVResults;

Line 5356: p_init_msg_list IN VARCHAR2 :=Fnd_Api.g_false,

5352: ---------------------------------------------------------------------
5353:
5354: PROCEDURE Call_LOV_Services (
5355: p_api_version IN NUMBER :=1.0,
5356: p_init_msg_list IN VARCHAR2 :=Fnd_Api.g_false,
5357: p_commit IN VARCHAR2 :=Fnd_Api.g_false,
5358: p_validation_level IN NUMBER :=Fnd_Api.g_valid_level_full,
5359: p_module_type IN VARCHAR2 :=null,
5360: p_userid IN VARCHAR2 := NULL,

Line 5357: p_commit IN VARCHAR2 :=Fnd_Api.g_false,

5353:
5354: PROCEDURE Call_LOV_Services (
5355: p_api_version IN NUMBER :=1.0,
5356: p_init_msg_list IN VARCHAR2 :=Fnd_Api.g_false,
5357: p_commit IN VARCHAR2 :=Fnd_Api.g_false,
5358: p_validation_level IN NUMBER :=Fnd_Api.g_valid_level_full,
5359: p_module_type IN VARCHAR2 :=null,
5360: p_userid IN VARCHAR2 := NULL,
5361: p_lov_input_rec IN LOV_Input_Rec_Type,

Line 5358: p_validation_level IN NUMBER :=Fnd_Api.g_valid_level_full,

5354: PROCEDURE Call_LOV_Services (
5355: p_api_version IN NUMBER :=1.0,
5356: p_init_msg_list IN VARCHAR2 :=Fnd_Api.g_false,
5357: p_commit IN VARCHAR2 :=Fnd_Api.g_false,
5358: p_validation_level IN NUMBER :=Fnd_Api.g_valid_level_full,
5359: p_module_type IN VARCHAR2 :=null,
5360: p_userid IN VARCHAR2 := NULL,
5361: p_lov_input_rec IN LOV_Input_Rec_Type,
5362: x_lov_result_output_rec OUT NOCOPY LovOutput_Rec_Type,

Line 5375: IF(x_return_status <> Fnd_Api.G_RET_STS_SUCCESS)THEN

5371:
5372:
5373: IF(p_module_type = 'BPEL') THEN
5374: x_return_status := AHL_PRD_WO_PUB.init_user_and_role(p_userid);
5375: IF(x_return_status <> Fnd_Api.G_RET_STS_SUCCESS)THEN
5376: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5377: END IF;
5378: END IF;
5379:

Line 5376: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5372:
5373: IF(p_module_type = 'BPEL') THEN
5374: x_return_status := AHL_PRD_WO_PUB.init_user_and_role(p_userid);
5375: IF(x_return_status <> Fnd_Api.G_RET_STS_SUCCESS)THEN
5376: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5377: END IF;
5378: END IF;
5379:
5380: -- Standard call to check for call compatibility

Line 5381: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version,l_api_name, G_PKG_NAME ) THEN

5377: END IF;
5378: END IF;
5379:
5380: -- Standard call to check for call compatibility
5381: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version,l_api_name, G_PKG_NAME ) THEN
5382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5383: END IF;
5384:
5385: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 5382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5378: END IF;
5379:
5380: -- Standard call to check for call compatibility
5381: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version,l_api_name, G_PKG_NAME ) THEN
5382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5383: END IF;
5384:
5385: IF FND_API.To_Boolean(p_init_msg_list) THEN
5386: FND_MSG_PUB.Initialize;

Line 5385: IF FND_API.To_Boolean(p_init_msg_list) THEN

5381: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version,l_api_name, G_PKG_NAME ) THEN
5382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5383: END IF;
5384:
5385: IF FND_API.To_Boolean(p_init_msg_list) THEN
5386: FND_MSG_PUB.Initialize;
5387: END IF;
5388:
5389: -- Initialize output variables

Line 5393: x_return_status := FND_API.G_RET_STS_SUCCESS;

5389: -- Initialize output variables
5390: x_lov_meta_output_rec.LovMetaAttributeTbl(0).AttributeName := null;
5391: x_lov_result_output_rec.LovResultTbl(0)(0).AttributeName := null;
5392:
5393: x_return_status := FND_API.G_RET_STS_SUCCESS;
5394:
5395: IF p_lov_input_rec.getMetaData is not null and
5396: upper(p_lov_input_rec.getMetaData) = 'T' THEN
5397:

Line 5419: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN

5415: END IF;
5416: IF(x_lov_result_output_rec.NumberOfRows IS NULL OR x_lov_result_output_rec.NumberOfRows < 1)THEN
5417: x_lov_result_output_rec.LovResultTbl(0)(0).AttributeName := NULL;
5418: END IF;
5419: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
5420: RAISE FND_API.G_EXC_ERROR;
5421: END IF;
5422: EXCEPTION
5423: WHEN FND_API.G_EXC_ERROR THEN

Line 5420: RAISE FND_API.G_EXC_ERROR;

5416: IF(x_lov_result_output_rec.NumberOfRows IS NULL OR x_lov_result_output_rec.NumberOfRows < 1)THEN
5417: x_lov_result_output_rec.LovResultTbl(0)(0).AttributeName := NULL;
5418: END IF;
5419: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
5420: RAISE FND_API.G_EXC_ERROR;
5421: END IF;
5422: EXCEPTION
5423: WHEN FND_API.G_EXC_ERROR THEN
5424: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5423: WHEN FND_API.G_EXC_ERROR THEN

5419: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
5420: RAISE FND_API.G_EXC_ERROR;
5421: END IF;
5422: EXCEPTION
5423: WHEN FND_API.G_EXC_ERROR THEN
5424: x_return_status := FND_API.G_RET_STS_ERROR;
5425: x_msg_count := FND_MSG_PUB.count_msg;
5426: x_msg_data := AHL_PRD_WO_PUB.GET_MSG_DATA(x_msg_count);
5427: /*FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 5424: x_return_status := FND_API.G_RET_STS_ERROR;

5420: RAISE FND_API.G_EXC_ERROR;
5421: END IF;
5422: EXCEPTION
5423: WHEN FND_API.G_EXC_ERROR THEN
5424: x_return_status := FND_API.G_RET_STS_ERROR;
5425: x_msg_count := FND_MSG_PUB.count_msg;
5426: x_msg_data := AHL_PRD_WO_PUB.GET_MSG_DATA(x_msg_count);
5427: /*FND_MSG_PUB.count_and_get( p_count => x_msg_count,
5428: p_data => x_msg_data,

Line 5429: p_encoded => fnd_api.g_false);*/

5425: x_msg_count := FND_MSG_PUB.count_msg;
5426: x_msg_data := AHL_PRD_WO_PUB.GET_MSG_DATA(x_msg_count);
5427: /*FND_MSG_PUB.count_and_get( p_count => x_msg_count,
5428: p_data => x_msg_data,
5429: p_encoded => fnd_api.g_false);*/
5430:
5431:
5432:
5433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 5433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5429: p_encoded => fnd_api.g_false);*/
5430:
5431:
5432:
5433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5435: x_msg_count := FND_MSG_PUB.count_msg;
5436: x_msg_data := AHL_PRD_WO_PUB.GET_MSG_DATA(x_msg_count);
5437: /*FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 5434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5430:
5431:
5432:
5433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5435: x_msg_count := FND_MSG_PUB.count_msg;
5436: x_msg_data := AHL_PRD_WO_PUB.GET_MSG_DATA(x_msg_count);
5437: /*FND_MSG_PUB.count_and_get( p_count => x_msg_count,
5438: p_data => x_msg_data,

Line 5439: p_encoded => fnd_api.g_false);*/

5435: x_msg_count := FND_MSG_PUB.count_msg;
5436: x_msg_data := AHL_PRD_WO_PUB.GET_MSG_DATA(x_msg_count);
5437: /*FND_MSG_PUB.count_and_get( p_count => x_msg_count,
5438: p_data => x_msg_data,
5439: p_encoded => fnd_api.g_false);*/
5440:
5441:
5442: WHEN OTHERS THEN
5443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5439: p_encoded => fnd_api.g_false);*/
5440:
5441:
5442: WHEN OTHERS THEN
5443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5444: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5445: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
5446: p_procedure_name => l_api_name,
5447: p_error_text => SUBSTR(SQLERRM,1,500));

Line 5453: p_encoded => fnd_api.g_false);*/

5449: x_msg_count := FND_MSG_PUB.count_msg;
5450: x_msg_data := AHL_PRD_WO_PUB.GET_MSG_DATA(x_msg_count);
5451: /*FND_MSG_PUB.count_and_get( p_count => x_msg_count,
5452: p_data => x_msg_data,
5453: p_encoded => fnd_api.g_false);*/
5454: END Call_LOV_Services;
5455:
5456: END AHL_PRD_LOV_SERVICE_PVT;