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

Line 137: RETURN FND_API.G_RET_STS_SUCCESS;

133: FETCH get_visit_instance INTO l_visit_instance_id;
134: -- Added additional or condition by senthil as the Visit Instance Id can be null.
135: IF get_visit_instance%NOTFOUND OR l_visit_instance_id is NULL THEN
136: CLOSE get_visit_instance;
137: RETURN FND_API.G_RET_STS_SUCCESS;
138: ELSE
139: CLOSE get_visit_instance;
140: IF l_visit_instance_id = p_instance_id THEN
141: RETURN FND_API.G_RET_STS_SUCCESS;

Line 141: RETURN FND_API.G_RET_STS_SUCCESS;

137: RETURN FND_API.G_RET_STS_SUCCESS;
138: ELSE
139: CLOSE get_visit_instance;
140: IF l_visit_instance_id = p_instance_id THEN
141: RETURN FND_API.G_RET_STS_SUCCESS;
142: ELSE
143: OPEN check_instance_in_tree(l_visit_instance_id, p_instance_id);
144: FETCH check_instance_in_tree INTO l_instance_id;
145: IF check_instance_in_tree%FOUND THEN

Line 147: RETURN FND_API.G_RET_STS_SUCCESS;

143: OPEN check_instance_in_tree(l_visit_instance_id, p_instance_id);
144: FETCH check_instance_in_tree INTO l_instance_id;
145: IF check_instance_in_tree%FOUND THEN
146: CLOSE check_instance_in_tree;
147: RETURN FND_API.G_RET_STS_SUCCESS;
148: ELSE
149: CLOSE check_instance_in_tree;
150: RETURN FND_API.G_RET_STS_ERROR;
151: END IF;

Line 150: RETURN FND_API.G_RET_STS_ERROR;

146: CLOSE check_instance_in_tree;
147: RETURN FND_API.G_RET_STS_SUCCESS;
148: ELSE
149: CLOSE check_instance_in_tree;
150: RETURN FND_API.G_RET_STS_ERROR;
151: END IF;
152: END IF;
153: END IF;
154: END;

Line 248: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

244: AND NVL(org.operating_unit,mo_global.get_current_org_id())
245: = mo_global.get_current_org_id()
246: ) ;
247: END IF;
248: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
249: ELSE
250: x_return_status := Fnd_Api.G_RET_STS_ERROR;
251: END IF;
252:

Line 250: x_return_status := Fnd_Api.G_RET_STS_ERROR;

246: ) ;
247: END IF;
248: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
249: ELSE
250: x_return_status := Fnd_Api.G_RET_STS_ERROR;
251: END IF;
252:
253: IF (l_log_procedure >= l_log_current_level) THEN
254: fnd_log.string(l_log_procedure,

Line 263: x_return_status:= Fnd_Api.G_RET_STS_ERROR;

259: END IF;
260:
261: EXCEPTION
262: WHEN NO_DATA_FOUND THEN
263: x_return_status:= Fnd_Api.G_RET_STS_ERROR;
264: x_error_msg_code:= 'AHL_VWP_ITEM_NOT_EXISTS';
265: WHEN TOO_MANY_ROWS THEN
266: x_return_status:= Fnd_Api.G_RET_STS_ERROR;
267: x_error_msg_code:= 'AHL_VWP_ITEM_NOT_EXISTS';

Line 266: x_return_status:= Fnd_Api.G_RET_STS_ERROR;

262: WHEN NO_DATA_FOUND THEN
263: x_return_status:= Fnd_Api.G_RET_STS_ERROR;
264: x_error_msg_code:= 'AHL_VWP_ITEM_NOT_EXISTS';
265: WHEN TOO_MANY_ROWS THEN
266: x_return_status:= Fnd_Api.G_RET_STS_ERROR;
267: x_error_msg_code:= 'AHL_VWP_ITEM_NOT_EXISTS';
268: WHEN OTHERS THEN
269: x_return_status:= Fnd_Api.G_RET_STS_UNEXP_ERROR;
270: RAISE;

Line 269: x_return_status:= Fnd_Api.G_RET_STS_UNEXP_ERROR;

265: WHEN TOO_MANY_ROWS THEN
266: x_return_status:= Fnd_Api.G_RET_STS_ERROR;
267: x_error_msg_code:= 'AHL_VWP_ITEM_NOT_EXISTS';
268: WHEN OTHERS THEN
269: x_return_status:= Fnd_Api.G_RET_STS_UNEXP_ERROR;
270: RAISE;
271: END Check_Item_Name_Or_Id;
272:
273: -- Post 11.5.10 Enhancements

Line 338: x_return_status := Fnd_Api.G_RET_STS_ERROR;

334: OPEN c_proj_template(p_proj_temp_name);
335: FETCH c_proj_template INTO x_project_id;
336: IF c_proj_template%NOTFOUND
337: THEN
338: x_return_status := Fnd_Api.G_RET_STS_ERROR;
339: ELSE
340: IF (l_log_statement >= l_log_current_level) THEN
341: fnd_log.string(l_log_statement,
342: L_DEBUG_KEY,

Line 345: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

341: fnd_log.string(l_log_statement,
342: L_DEBUG_KEY,
343: 'Project Id = ' || x_project_id);
344: END IF;
345: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
346: END IF;
347: CLOSE c_proj_template;
348: END IF;
349:

Line 358: x_return_status:= Fnd_Api.G_RET_STS_UNEXP_ERROR;

354: END IF;
355:
356: EXCEPTION
357: WHEN OTHERS THEN
358: x_return_status:= Fnd_Api.G_RET_STS_UNEXP_ERROR;
359: RAISE;
360: END Check_Project_Template_Or_Id;
361:
362: --------------------------------------------------------------------

Line 407: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

403: WHERE Serial_Number = p_serial_number AND Inventory_Item_Id = p_item_id AND Inv_Master_Organization_Id = p_org_id
404: AND ACTIVE_START_DATE <= sysdate AND (ACTIVE_END_DATE >= sysdate OR ACTIVE_END_DATE IS NULL);
405: END IF;
406:
407: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
408:
409: IF (l_log_procedure >= l_log_current_level) THEN
410: fnd_log.string(l_log_procedure,
411: L_DEBUG_KEY ||'.end',

Line 418: x_return_status:= Fnd_Api.G_RET_STS_ERROR;

414: END IF;
415:
416: EXCEPTION
417: WHEN NO_DATA_FOUND THEN
418: x_return_status:= Fnd_Api.G_RET_STS_ERROR;
419: x_error_msg_code:= 'AHL_VWP_SERIAL_NOT_EXISTS';
420: WHEN TOO_MANY_ROWS THEN
421: x_return_status:= Fnd_Api.G_RET_STS_ERROR;
422: x_error_msg_code:= 'AHL_VWP_SERIAL_NOT_EXISTS';

Line 421: x_return_status:= Fnd_Api.G_RET_STS_ERROR;

417: WHEN NO_DATA_FOUND THEN
418: x_return_status:= Fnd_Api.G_RET_STS_ERROR;
419: x_error_msg_code:= 'AHL_VWP_SERIAL_NOT_EXISTS';
420: WHEN TOO_MANY_ROWS THEN
421: x_return_status:= Fnd_Api.G_RET_STS_ERROR;
422: x_error_msg_code:= 'AHL_VWP_SERIAL_NOT_EXISTS';
423: WHEN OTHERS THEN
424: x_return_status:= Fnd_Api.G_RET_STS_UNEXP_ERROR;
425: RAISE;

Line 424: x_return_status:= Fnd_Api.G_RET_STS_UNEXP_ERROR;

420: WHEN TOO_MANY_ROWS THEN
421: x_return_status:= Fnd_Api.G_RET_STS_ERROR;
422: x_error_msg_code:= 'AHL_VWP_SERIAL_NOT_EXISTS';
423: WHEN OTHERS THEN
424: x_return_status:= Fnd_Api.G_RET_STS_UNEXP_ERROR;
425: RAISE;
426: END Check_Serial_Name_Or_Id;
427:
428: --------------------------------------------------------------------

Line 469: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

465: WHERE organization_id = p_organization_id
466: AND description = p_dept_name;
467: END IF;
468:
469: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
470:
471: IF (l_log_procedure >= l_log_current_level) THEN
472: fnd_log.string(l_log_procedure,
473: L_DEBUG_KEY ||'.end',

Line 480: x_return_status:= Fnd_Api.G_RET_STS_ERROR;

476: END IF;
477:
478: EXCEPTION
479: WHEN NO_DATA_FOUND THEN
480: x_return_status:= Fnd_Api.G_RET_STS_ERROR;
481: x_error_msg_code:= 'AHL_VWP_DEPT_NOT_EXISTS';
482: WHEN TOO_MANY_ROWS THEN
483: x_return_status:= Fnd_Api.G_RET_STS_ERROR;
484: x_error_msg_code:= 'AHL_VWP_DEPT_NOT_EXISTS';

Line 483: x_return_status:= Fnd_Api.G_RET_STS_ERROR;

479: WHEN NO_DATA_FOUND THEN
480: x_return_status:= Fnd_Api.G_RET_STS_ERROR;
481: x_error_msg_code:= 'AHL_VWP_DEPT_NOT_EXISTS';
482: WHEN TOO_MANY_ROWS THEN
483: x_return_status:= Fnd_Api.G_RET_STS_ERROR;
484: x_error_msg_code:= 'AHL_VWP_DEPT_NOT_EXISTS';
485: WHEN OTHERS THEN
486: x_return_status:= Fnd_Api.G_RET_STS_UNEXP_ERROR;
487: RAISE;

Line 486: x_return_status:= Fnd_Api.G_RET_STS_UNEXP_ERROR;

482: WHEN TOO_MANY_ROWS THEN
483: x_return_status:= Fnd_Api.G_RET_STS_ERROR;
484: x_error_msg_code:= 'AHL_VWP_DEPT_NOT_EXISTS';
485: WHEN OTHERS THEN
486: x_return_status:= Fnd_Api.G_RET_STS_UNEXP_ERROR;
487: RAISE;
488: END Check_Dept_Desc_Or_Id;
489:
490: --------------------------------------------------------------------

Line 544: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

540: WHERE hou.organization_id = mp.organization_id
541: AND NVL(operating_unit, mo_global.get_current_org_id()) = mo_global.get_current_org_id())
542: AND MP.EAM_enabled_flag='Y';
543: END IF;
544: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
545: IF (l_log_procedure >= l_log_current_level) THEN
546: fnd_log.string(l_log_procedure,
547: L_DEBUG_KEY ||'.end',
548: 'At the end of PL SQL procedure. Return Status = ' || x_return_status ||

Line 554: x_return_status:= Fnd_Api.G_RET_STS_ERROR;

550: END IF;
551:
552: EXCEPTION
553: WHEN NO_DATA_FOUND THEN
554: x_return_status:= Fnd_Api.G_RET_STS_ERROR;
555: x_error_msg_code:= 'AHL_VWP_ORG_NOT_EXISTS';
556: WHEN TOO_MANY_ROWS THEN
557: x_return_status:= Fnd_Api.G_RET_STS_ERROR;
558: x_error_msg_code:= 'AHL_VWP_ORG_NOT_EXISTS';

Line 557: x_return_status:= Fnd_Api.G_RET_STS_ERROR;

553: WHEN NO_DATA_FOUND THEN
554: x_return_status:= Fnd_Api.G_RET_STS_ERROR;
555: x_error_msg_code:= 'AHL_VWP_ORG_NOT_EXISTS';
556: WHEN TOO_MANY_ROWS THEN
557: x_return_status:= Fnd_Api.G_RET_STS_ERROR;
558: x_error_msg_code:= 'AHL_VWP_ORG_NOT_EXISTS';
559: WHEN OTHERS THEN
560: x_return_status:= Fnd_Api.G_RET_STS_UNEXP_ERROR;
561: RAISE;

Line 560: x_return_status:= Fnd_Api.G_RET_STS_UNEXP_ERROR;

556: WHEN TOO_MANY_ROWS THEN
557: x_return_status:= Fnd_Api.G_RET_STS_ERROR;
558: x_error_msg_code:= 'AHL_VWP_ORG_NOT_EXISTS';
559: WHEN OTHERS THEN
560: x_return_status:= Fnd_Api.G_RET_STS_UNEXP_ERROR;
561: RAISE;
562: END Check_Org_Name_Or_Id;
563:
564: --------------------------------------------------------------------

Line 610: x_return_status:= Fnd_Api.G_RET_STS_ERROR;

606: AND cit.CMRO_FLAG = 'Y'
607: AND Incident_Number = p_service_number;
608: -- yazhou 19Oct2005 ends
609: ELSE
610: x_return_status:= Fnd_Api.G_RET_STS_ERROR;
611: x_error_msg_code:= 'AHL_VWP_SERVICE_REQ_NOT_EXISTS';
612: END IF;
613:
614: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

Line 614: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

610: x_return_status:= Fnd_Api.G_RET_STS_ERROR;
611: x_error_msg_code:= 'AHL_VWP_SERVICE_REQ_NOT_EXISTS';
612: END IF;
613:
614: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
615:
616: IF (l_log_procedure >= l_log_current_level) THEN
617: fnd_log.string(l_log_procedure,
618: L_DEBUG_KEY ||'.end',

Line 625: x_return_status:= Fnd_Api.G_RET_STS_ERROR;

621: END IF;
622:
623: EXCEPTION
624: WHEN NO_DATA_FOUND THEN
625: x_return_status:= Fnd_Api.G_RET_STS_ERROR;
626: x_error_msg_code:= 'AHL_VWP_SERVICE_REQ_NOT_EXISTS';
627: WHEN TOO_MANY_ROWS THEN
628: x_return_status:= Fnd_Api.G_RET_STS_ERROR;
629: x_error_msg_code:= 'AHL_VWP_SERVICE_REQ_NOT_EXISTS';

Line 628: x_return_status:= Fnd_Api.G_RET_STS_ERROR;

624: WHEN NO_DATA_FOUND THEN
625: x_return_status:= Fnd_Api.G_RET_STS_ERROR;
626: x_error_msg_code:= 'AHL_VWP_SERVICE_REQ_NOT_EXISTS';
627: WHEN TOO_MANY_ROWS THEN
628: x_return_status:= Fnd_Api.G_RET_STS_ERROR;
629: x_error_msg_code:= 'AHL_VWP_SERVICE_REQ_NOT_EXISTS';
630: WHEN OTHERS THEN
631: x_return_status:= Fnd_Api.G_RET_STS_UNEXP_ERROR;
632: RAISE;

Line 631: x_return_status:= Fnd_Api.G_RET_STS_UNEXP_ERROR;

627: WHEN TOO_MANY_ROWS THEN
628: x_return_status:= Fnd_Api.G_RET_STS_ERROR;
629: x_error_msg_code:= 'AHL_VWP_SERVICE_REQ_NOT_EXISTS';
630: WHEN OTHERS THEN
631: x_return_status:= Fnd_Api.G_RET_STS_UNEXP_ERROR;
632: RAISE;
633: END Check_SR_Request_Number_Or_Id;
634:
635: --------------------------------------------------------------------

Line 711: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

707: x_bln_flag := 'N';
708: END IF;
709: CLOSE c_sim_visit;
710: */
711: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
712:
713: IF (l_log_procedure >= l_log_current_level) THEN
714: fnd_log.string(l_log_procedure,
715: L_DEBUG_KEY ||'.end',

Line 722: x_return_status := Fnd_Api.G_RET_STS_ERROR;

718: END IF;
719:
720: EXCEPTION
721: WHEN NO_DATA_FOUND THEN
722: x_return_status := Fnd_Api.G_RET_STS_ERROR;
723: x_error_msg_code:= 'AHL_LTP_SIMULATION_PLAN_NOT_EXISTS';
724: WHEN TOO_MANY_ROWS THEN
725: x_return_status := Fnd_Api.G_RET_STS_ERROR;
726: x_error_msg_code:= 'AHL_LTP_SIMULATION_PLAN_NOT_EXISTS';

Line 725: x_return_status := Fnd_Api.G_RET_STS_ERROR;

721: WHEN NO_DATA_FOUND THEN
722: x_return_status := Fnd_Api.G_RET_STS_ERROR;
723: x_error_msg_code:= 'AHL_LTP_SIMULATION_PLAN_NOT_EXISTS';
724: WHEN TOO_MANY_ROWS THEN
725: x_return_status := Fnd_Api.G_RET_STS_ERROR;
726: x_error_msg_code:= 'AHL_LTP_SIMULATION_PLAN_NOT_EXISTS';
727: WHEN OTHERS THEN
728: x_return_status:= Fnd_Api.G_RET_STS_UNEXP_ERROR;
729: RAISE;

Line 728: x_return_status:= Fnd_Api.G_RET_STS_UNEXP_ERROR;

724: WHEN TOO_MANY_ROWS THEN
725: x_return_status := Fnd_Api.G_RET_STS_ERROR;
726: x_error_msg_code:= 'AHL_LTP_SIMULATION_PLAN_NOT_EXISTS';
727: WHEN OTHERS THEN
728: x_return_status:= Fnd_Api.G_RET_STS_UNEXP_ERROR;
729: RAISE;
730: END Check_Visit_is_Simulated;
731:
732: --------------------------------------------------------------------

Line 765: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

761: IF (p_visit_task_id IS NOT NULL) THEN
762: SELECT Visit_Task_Id INTO x_visit_task_id
763: FROM AHL_VISIT_TASKS_B
764: WHERE Visit_Task_Id = p_visit_task_id AND Visit_Id = p_visit_id AND status_code <> 'DELETED';
765: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
766: ELSIF (p_visit_task_number IS NOT NULL) THEN
767: SELECT Visit_Task_Id INTO x_visit_task_id
768: FROM AHL_VISIT_TASKS_B
769: WHERE Visit_Task_Number = p_visit_task_number AND Visit_Id = p_visit_id AND status_code <> 'DELETED';

Line 770: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

766: ELSIF (p_visit_task_number IS NOT NULL) THEN
767: SELECT Visit_Task_Id INTO x_visit_task_id
768: FROM AHL_VISIT_TASKS_B
769: WHERE Visit_Task_Number = p_visit_task_number AND Visit_Id = p_visit_id AND status_code <> 'DELETED';
770: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
771: ELSE
772: x_return_status:= Fnd_Api.G_RET_STS_ERROR;
773: Fnd_Message.set_name ('AHL', 'AHL_VWP_VISIT_TASKS_NOT_EXISTS');
774: Fnd_Msg_Pub.ADD;

Line 772: x_return_status:= Fnd_Api.G_RET_STS_ERROR;

768: FROM AHL_VISIT_TASKS_B
769: WHERE Visit_Task_Number = p_visit_task_number AND Visit_Id = p_visit_id AND status_code <> 'DELETED';
770: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
771: ELSE
772: x_return_status:= Fnd_Api.G_RET_STS_ERROR;
773: Fnd_Message.set_name ('AHL', 'AHL_VWP_VISIT_TASKS_NOT_EXISTS');
774: Fnd_Msg_Pub.ADD;
775: END IF;
776:

Line 777: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

773: Fnd_Message.set_name ('AHL', 'AHL_VWP_VISIT_TASKS_NOT_EXISTS');
774: Fnd_Msg_Pub.ADD;
775: END IF;
776:
777: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
778: IF (l_log_procedure >= l_log_current_level) THEN
779: fnd_log.string(l_log_procedure,
780: L_DEBUG_KEY ||'.end',
781: 'At the end of PL SQL procedure. Return Status = ' || x_return_status ||

Line 786: x_return_status:= Fnd_Api.G_RET_STS_ERROR;

782: 'Visit Task Id = ' || x_visit_task_id);
783: END IF;
784: EXCEPTION
785: WHEN NO_DATA_FOUND THEN
786: x_return_status:= Fnd_Api.G_RET_STS_ERROR;
787: x_error_msg_code:= 'AHL_VWP_VISIT_TASKS_NOT_EXISTS';
788: WHEN TOO_MANY_ROWS THEN
789: x_return_status:= Fnd_Api.G_RET_STS_ERROR;
790: x_error_msg_code:= 'AHL_VWP_VISIT_TASKS_NOT_EXISTS';

Line 789: x_return_status:= Fnd_Api.G_RET_STS_ERROR;

785: WHEN NO_DATA_FOUND THEN
786: x_return_status:= Fnd_Api.G_RET_STS_ERROR;
787: x_error_msg_code:= 'AHL_VWP_VISIT_TASKS_NOT_EXISTS';
788: WHEN TOO_MANY_ROWS THEN
789: x_return_status:= Fnd_Api.G_RET_STS_ERROR;
790: x_error_msg_code:= 'AHL_VWP_VISIT_TASKS_NOT_EXISTS';
791: WHEN OTHERS THEN
792: x_return_status:= Fnd_Api.G_RET_STS_UNEXP_ERROR;
793: RAISE;

Line 792: x_return_status:= Fnd_Api.G_RET_STS_UNEXP_ERROR;

788: WHEN TOO_MANY_ROWS THEN
789: x_return_status:= Fnd_Api.G_RET_STS_ERROR;
790: x_error_msg_code:= 'AHL_VWP_VISIT_TASKS_NOT_EXISTS';
791: WHEN OTHERS THEN
792: x_return_status:= Fnd_Api.G_RET_STS_UNEXP_ERROR;
793: RAISE;
794: END Check_Visit_Task_Number_OR_ID;
795:
796: --------------------------------------------------------------------

Line 846: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

842: AND SYSDATE BETWEEN nvl(start_date_active,sysdate) --sowsubra FP:Bug#5758829
843: AND NVL(end_date_active,SYSDATE);
844: END IF;
845:
846: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
847:
848: IF (l_log_procedure >= l_log_current_level) THEN
849: fnd_log.string(l_log_procedure,
850: L_DEBUG_KEY ||'.end',

Line 857: x_return_status := Fnd_Api.G_RET_STS_ERROR;

853: END IF;
854:
855: EXCEPTION
856: WHEN NO_DATA_FOUND THEN
857: x_return_status := Fnd_Api.G_RET_STS_ERROR;
858: WHEN TOO_MANY_ROWS THEN
859: x_return_status := Fnd_Api.G_RET_STS_ERROR;
860: WHEN OTHERS THEN
861: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 859: x_return_status := Fnd_Api.G_RET_STS_ERROR;

855: EXCEPTION
856: WHEN NO_DATA_FOUND THEN
857: x_return_status := Fnd_Api.G_RET_STS_ERROR;
858: WHEN TOO_MANY_ROWS THEN
859: x_return_status := Fnd_Api.G_RET_STS_ERROR;
860: WHEN OTHERS THEN
861: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
862: RAISE;
863: END Check_Lookup_Name_Or_Id;

Line 861: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

857: x_return_status := Fnd_Api.G_RET_STS_ERROR;
858: WHEN TOO_MANY_ROWS THEN
859: x_return_status := Fnd_Api.G_RET_STS_ERROR;
860: WHEN OTHERS THEN
861: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
862: RAISE;
863: END Check_Lookup_Name_Or_Id;
864:
865:

Line 909: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

905: fnd_log.string(l_log_procedure,
906: L_DEBUG_KEY ||'.begin',
907: 'At the start of PL SQL procedure.');
908: END IF;
909: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
910: -- Always return x_check_project = 'Y' as we no longer need to check for Project Billing
911: -- Superuser Resp. Part of ADS bug fix 4357001.
912: x_check_project := 'Y';
913:

Line 924: x_return_status := Fnd_Api.g_ret_sts_error;

920: fnd_log.string(l_log_procedure,L_DEBUG_KEY, 'Responsiblity_Id from c_fnd_response = ' || l_responsibility_id);
921: END IF;
922:
923: IF c_fnd_response%NOTFOUND THEN
924: x_return_status := Fnd_Api.g_ret_sts_error;
925: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
926: Fnd_Message.set_name ('AHL', 'AHL_VWP_PROJ_NO_SUPERUSER');
927: Fnd_Msg_Pub.ADD;
928: CLOSE c_fnd_response;

Line 942: x_return_status := Fnd_Api.g_ret_sts_error;

938: fnd_log.string(l_log_procedure,L_DEBUG_KEY, 'Responsiblity_Id from c_fnd_user_resp = ' || l_responsibility_id);
939: END IF;
940:
941: IF c_fnd_user_resp%NOTFOUND THEN
942: x_return_status := Fnd_Api.g_ret_sts_error;
943: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
944: Fnd_Message.set_name ('AHL', 'AHL_VWP_PROJ_NO_USER_GROUPS');
945: Fnd_Msg_Pub.ADD;
946: END IF;

Line 950: IF x_return_status =Fnd_Api.G_RET_STS_SUCCESS THEN

946: END IF;
947: END IF;
948: CLOSE c_fnd_user_resp;
949:
950: IF x_return_status =Fnd_Api.G_RET_STS_SUCCESS THEN
951:
952: IF l_responsibility_id = l_responsibility_id THEN
953: x_check_project := 'Y';
954:

Line 971: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN

967: * fix from PA.
968: p_return_status => l_return_status ,
969: p_calling_mode => 'PUBLISH');
970: p_return_status => l_return_status);
971: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
972: RAISE G_EXC_ERROR;
973: END IF;
974:
975: ELSE

Line 977: x_return_status := Fnd_Api.g_ret_sts_error;

973: END IF;
974:
975: ELSE
976: x_check_project := 'N';
977: x_return_status := Fnd_Api.g_ret_sts_error;
978:
979: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
980: Fnd_Message.set_name ('AHL', 'AHL_VWP_PROJ_NO_RESPONSIBILITY');
981: Fnd_Msg_Pub.ADD;

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

1005: fnd_log.string(fnd_log.level_event,
1006: L_DEBUG_KEY,
1007: 'After calling PA_INTERFACE_UTILS_PUB.Set_Global_Info. Return Status = ' || x_return_status);
1008: END IF;
1009: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1010: IF (l_log_statement >= l_log_current_level) THEN
1011: fnd_log.string(l_log_statement,
1012: L_DEBUG_KEY,
1013: 'Errors from PA_INTERFACE_UTILS_PUB.Set_Global_Info. Message count: ' ||

Line 1016: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1012: L_DEBUG_KEY,
1013: 'Errors from PA_INTERFACE_UTILS_PUB.Set_Global_Info. Message count: ' ||
1014: l_msg_count || ', message data: ' || l_msg_data);
1015: END IF;
1016: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1017: RAISE FND_API.G_EXC_ERROR;
1018: ELSE
1019: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1020: END IF;

Line 1017: RAISE FND_API.G_EXC_ERROR;

1013: 'Errors from PA_INTERFACE_UTILS_PUB.Set_Global_Info. Message count: ' ||
1014: l_msg_count || ', message data: ' || l_msg_data);
1015: END IF;
1016: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1017: RAISE FND_API.G_EXC_ERROR;
1018: ELSE
1019: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1020: END IF;
1021: END IF;

Line 1019: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1015: END IF;
1016: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1017: RAISE FND_API.G_EXC_ERROR;
1018: ELSE
1019: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1020: END IF;
1021: END IF;
1022: -- End Changes made by jaramana on July 25, 2005
1023:

Line 1033: x_return_status := Fnd_Api.G_RET_STS_ERROR;

1029: END IF;
1030:
1031: EXCEPTION
1032: WHEN NO_DATA_FOUND THEN
1033: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1034: WHEN TOO_MANY_ROWS THEN
1035: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1036: WHEN OTHERS THEN
1037: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 1035: x_return_status := Fnd_Api.G_RET_STS_ERROR;

1031: EXCEPTION
1032: WHEN NO_DATA_FOUND THEN
1033: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1034: WHEN TOO_MANY_ROWS THEN
1035: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1036: WHEN OTHERS THEN
1037: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1038: RAISE;
1039: END Check_Proj_Responsibility;

Line 1037: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

1033: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1034: WHEN TOO_MANY_ROWS THEN
1035: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1036: WHEN OTHERS THEN
1037: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1038: RAISE;
1039: END Check_Proj_Responsibility;
1040:
1041: --------------------------------------------------------------------

Line 1092: RAISE Fnd_Api.G_EXC_ERROR;

1088: WHERE Instance_Id = x_instance_id;
1089: ELSE
1090: Fnd_Message.SET_NAME('AHL','AHL_VWP_SERIAL_NOT_EXISTS');
1091: Fnd_Msg_Pub.ADD;
1092: RAISE Fnd_Api.G_EXC_ERROR;
1093: END IF;
1094: END IF;
1095:
1096: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

Line 1096: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

1092: RAISE Fnd_Api.G_EXC_ERROR;
1093: END IF;
1094: END IF;
1095:
1096: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1097: IF (l_log_procedure >= l_log_current_level) THEN
1098: fnd_log.string(l_log_procedure,
1099: L_DEBUG_KEY ||'.end',
1100: 'At the end of PL SQL procedure. Return Status = ' || x_return_status ||

Line 1105: x_return_status := Fnd_Api.G_RET_STS_ERROR;

1101: '. Item Id = ' || x_item_id || ' Item Org Id' || x_item_org_id);
1102: END IF;
1103: EXCEPTION
1104: WHEN NO_DATA_FOUND THEN
1105: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1106: WHEN TOO_MANY_ROWS THEN
1107: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1108: WHEN OTHERS THEN
1109: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 1107: x_return_status := Fnd_Api.G_RET_STS_ERROR;

1103: EXCEPTION
1104: WHEN NO_DATA_FOUND THEN
1105: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1106: WHEN TOO_MANY_ROWS THEN
1107: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1108: WHEN OTHERS THEN
1109: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1110: RAISE;
1111: END Get_Serial_Item_by_Unit;

Line 1109: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

1105: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1106: WHEN TOO_MANY_ROWS THEN
1107: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1108: WHEN OTHERS THEN
1109: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1110: RAISE;
1111: END Get_Serial_Item_by_Unit;
1112:
1113: --------------------------------------------------------------------

Line 1197: x_return_status := Fnd_Api.g_ret_sts_error;

1193: l_type := 'PLANNED';
1194: ELSE
1195: l_type := 'UNPLANNED';
1196: IF p_serial_id IS NULL THEN
1197: x_return_status := Fnd_Api.g_ret_sts_error;
1198: IF (l_log_statement >= l_log_current_level) THEN
1199: fnd_log.string(l_log_statement,
1200: L_DEBUG_KEY,
1201: 'Error in Insert_Tasks. Serial Id missing.');

Line 1271: IF l_msg_count > 0 OR l_return_status <> Fnd_Api.g_ret_sts_success THEN

1267: 'Task ID = ' || l_task_id || ', Task Number = ' || l_task_number);
1268: END IF;
1269:
1270: l_msg_count := Fnd_Msg_Pub.count_msg;
1271: IF l_msg_count > 0 OR l_return_status <> Fnd_Api.g_ret_sts_success THEN
1272: x_msg_count := l_msg_count;
1273: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1274: RAISE Fnd_Api.G_EXC_ERROR;
1275: END IF;

Line 1273: x_return_status := Fnd_Api.G_RET_STS_ERROR;

1269:
1270: l_msg_count := Fnd_Msg_Pub.count_msg;
1271: IF l_msg_count > 0 OR l_return_status <> Fnd_Api.g_ret_sts_success THEN
1272: x_msg_count := l_msg_count;
1273: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1274: RAISE Fnd_Api.G_EXC_ERROR;
1275: END IF;
1276:
1277: IF (l_log_statement >= l_log_current_level) THEN

Line 1274: RAISE Fnd_Api.G_EXC_ERROR;

1270: l_msg_count := Fnd_Msg_Pub.count_msg;
1271: IF l_msg_count > 0 OR l_return_status <> Fnd_Api.g_ret_sts_success THEN
1272: x_msg_count := l_msg_count;
1273: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1274: RAISE Fnd_Api.G_EXC_ERROR;
1275: END IF;
1276:
1277: IF (l_log_statement >= l_log_current_level) THEN
1278: fnd_log.string(l_log_statement,

Line 1359: p_init_msg_list => Fnd_Api.G_FALSE,

1355: END IF;
1356:
1357: AHL_VWP_TIMES_PVT.Adjust_Task_Times
1358: (p_api_version => 1.0,
1359: p_init_msg_list => Fnd_Api.G_FALSE,
1360: p_commit => Fnd_Api.G_FALSE,
1361: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,
1362: x_return_status => l_return_status,
1363: x_msg_count => l_msg_count,

Line 1360: p_commit => Fnd_Api.G_FALSE,

1356:
1357: AHL_VWP_TIMES_PVT.Adjust_Task_Times
1358: (p_api_version => 1.0,
1359: p_init_msg_list => Fnd_Api.G_FALSE,
1360: p_commit => Fnd_Api.G_FALSE,
1361: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,
1362: x_return_status => l_return_status,
1363: x_msg_count => l_msg_count,
1364: x_msg_data => l_msg_data,

Line 1361: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,

1357: AHL_VWP_TIMES_PVT.Adjust_Task_Times
1358: (p_api_version => 1.0,
1359: p_init_msg_list => Fnd_Api.G_FALSE,
1360: p_commit => Fnd_Api.G_FALSE,
1361: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,
1362: x_return_status => l_return_status,
1363: x_msg_count => l_msg_count,
1364: x_msg_data => l_msg_data,
1365: p_task_id => l_task_id);

Line 1375: IF l_msg_count > 0 OR l_return_status <> Fnd_Api.g_ret_sts_success THEN

1371: l_return_status);
1372: END IF;
1373:
1374: l_msg_count := Fnd_Msg_Pub.count_msg;
1375: IF l_msg_count > 0 OR l_return_status <> Fnd_Api.g_ret_sts_success THEN
1376: IF (l_log_statement >= l_log_current_level) THEN
1377: fnd_log.string(l_log_statement,
1378: L_DEBUG_KEY,
1379: 'Errors from AHL_VWP_TIMES_PVT.Adjust_Task_Times. Message count: ' ||

Line 1383: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

1379: 'Errors from AHL_VWP_TIMES_PVT.Adjust_Task_Times. Message count: ' ||
1380: l_msg_count || ', message data: ' || l_msg_data);
1381: END IF;
1382: x_msg_count := l_msg_count;
1383: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1384: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
1385: END IF;
1386:
1387: x_return_status := Fnd_Api.g_ret_sts_success;

Line 1384: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

1380: l_msg_count || ', message data: ' || l_msg_data);
1381: END IF;
1382: x_msg_count := l_msg_count;
1383: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1384: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
1385: END IF;
1386:
1387: x_return_status := Fnd_Api.g_ret_sts_success;
1388: IF (l_log_procedure >= l_log_current_level) THEN

Line 1387: x_return_status := Fnd_Api.g_ret_sts_success;

1383: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1384: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
1385: END IF;
1386:
1387: x_return_status := Fnd_Api.g_ret_sts_success;
1388: IF (l_log_procedure >= l_log_current_level) THEN
1389: fnd_log.string(l_log_procedure,
1390: L_DEBUG_KEY || '.end',
1391: 'Return Status = ' || x_return_status || '. Task Id = ' || x_task_id);

Line 1776: IF l_task_rec.attribute_category = Fnd_Api.G_MISS_CHAR THEN

1772:
1773: IF l_tsk_flag = 'Y' THEN
1774: SELECT ahl_task_links_s.nextval INTO l_task_link_id FROM DUAL;
1775:
1776: IF l_task_rec.attribute_category = Fnd_Api.G_MISS_CHAR THEN
1777: l_task_rec.attribute_category := NULL;
1778: END IF;
1779: --
1780: IF l_task_rec.attribute1 = Fnd_Api.G_MISS_CHAR THEN

Line 1780: IF l_task_rec.attribute1 = Fnd_Api.G_MISS_CHAR THEN

1776: IF l_task_rec.attribute_category = Fnd_Api.G_MISS_CHAR THEN
1777: l_task_rec.attribute_category := NULL;
1778: END IF;
1779: --
1780: IF l_task_rec.attribute1 = Fnd_Api.G_MISS_CHAR THEN
1781: l_task_rec.attribute1 := NULL;
1782: END IF;
1783: --
1784: IF l_task_rec.attribute2 = Fnd_Api.G_MISS_CHAR THEN

Line 1784: IF l_task_rec.attribute2 = Fnd_Api.G_MISS_CHAR THEN

1780: IF l_task_rec.attribute1 = Fnd_Api.G_MISS_CHAR THEN
1781: l_task_rec.attribute1 := NULL;
1782: END IF;
1783: --
1784: IF l_task_rec.attribute2 = Fnd_Api.G_MISS_CHAR THEN
1785: l_task_rec.attribute2 := NULL;
1786: END IF;
1787: --
1788: IF l_task_rec.attribute3 = Fnd_Api.G_MISS_CHAR THEN

Line 1788: IF l_task_rec.attribute3 = Fnd_Api.G_MISS_CHAR THEN

1784: IF l_task_rec.attribute2 = Fnd_Api.G_MISS_CHAR THEN
1785: l_task_rec.attribute2 := NULL;
1786: END IF;
1787: --
1788: IF l_task_rec.attribute3 = Fnd_Api.G_MISS_CHAR THEN
1789: l_task_rec.attribute3 := NULL;
1790: END IF;
1791: --
1792: IF l_task_rec.attribute4 = Fnd_Api.G_MISS_CHAR THEN

Line 1792: IF l_task_rec.attribute4 = Fnd_Api.G_MISS_CHAR THEN

1788: IF l_task_rec.attribute3 = Fnd_Api.G_MISS_CHAR THEN
1789: l_task_rec.attribute3 := NULL;
1790: END IF;
1791: --
1792: IF l_task_rec.attribute4 = Fnd_Api.G_MISS_CHAR THEN
1793: l_task_rec.attribute4 := NULL;
1794: END IF;
1795: --
1796: IF l_task_rec.attribute5 = Fnd_Api.G_MISS_CHAR THEN

Line 1796: IF l_task_rec.attribute5 = Fnd_Api.G_MISS_CHAR THEN

1792: IF l_task_rec.attribute4 = Fnd_Api.G_MISS_CHAR THEN
1793: l_task_rec.attribute4 := NULL;
1794: END IF;
1795: --
1796: IF l_task_rec.attribute5 = Fnd_Api.G_MISS_CHAR THEN
1797: l_task_rec.attribute5 := NULL;
1798: END IF;
1799: --
1800: IF l_task_rec.attribute6 = Fnd_Api.G_MISS_CHAR THEN

Line 1800: IF l_task_rec.attribute6 = Fnd_Api.G_MISS_CHAR THEN

1796: IF l_task_rec.attribute5 = Fnd_Api.G_MISS_CHAR THEN
1797: l_task_rec.attribute5 := NULL;
1798: END IF;
1799: --
1800: IF l_task_rec.attribute6 = Fnd_Api.G_MISS_CHAR THEN
1801: l_task_rec.attribute6 := NULL;
1802: END IF;
1803: --
1804: IF l_task_rec.attribute7 = Fnd_Api.G_MISS_CHAR THEN

Line 1804: IF l_task_rec.attribute7 = Fnd_Api.G_MISS_CHAR THEN

1800: IF l_task_rec.attribute6 = Fnd_Api.G_MISS_CHAR THEN
1801: l_task_rec.attribute6 := NULL;
1802: END IF;
1803: --
1804: IF l_task_rec.attribute7 = Fnd_Api.G_MISS_CHAR THEN
1805: l_task_rec.attribute7 := NULL;
1806: END IF;
1807: --
1808: IF l_task_rec.attribute8 = Fnd_Api.G_MISS_CHAR THEN

Line 1808: IF l_task_rec.attribute8 = Fnd_Api.G_MISS_CHAR THEN

1804: IF l_task_rec.attribute7 = Fnd_Api.G_MISS_CHAR THEN
1805: l_task_rec.attribute7 := NULL;
1806: END IF;
1807: --
1808: IF l_task_rec.attribute8 = Fnd_Api.G_MISS_CHAR THEN
1809: l_task_rec.attribute8 := NULL;
1810: END IF;
1811: --
1812: IF l_task_rec.attribute9 = Fnd_Api.G_MISS_CHAR THEN

Line 1812: IF l_task_rec.attribute9 = Fnd_Api.G_MISS_CHAR THEN

1808: IF l_task_rec.attribute8 = Fnd_Api.G_MISS_CHAR THEN
1809: l_task_rec.attribute8 := NULL;
1810: END IF;
1811: --
1812: IF l_task_rec.attribute9 = Fnd_Api.G_MISS_CHAR THEN
1813: l_task_rec.attribute9 := NULL;
1814: END IF;
1815: --
1816: IF l_task_rec.attribute10 = Fnd_Api.G_MISS_CHAR THEN

Line 1816: IF l_task_rec.attribute10 = Fnd_Api.G_MISS_CHAR THEN

1812: IF l_task_rec.attribute9 = Fnd_Api.G_MISS_CHAR THEN
1813: l_task_rec.attribute9 := NULL;
1814: END IF;
1815: --
1816: IF l_task_rec.attribute10 = Fnd_Api.G_MISS_CHAR THEN
1817: l_task_rec.attribute10 := NULL;
1818: END IF;
1819: --
1820: IF l_task_rec.attribute11 = Fnd_Api.G_MISS_CHAR THEN

Line 1820: IF l_task_rec.attribute11 = Fnd_Api.G_MISS_CHAR THEN

1816: IF l_task_rec.attribute10 = Fnd_Api.G_MISS_CHAR THEN
1817: l_task_rec.attribute10 := NULL;
1818: END IF;
1819: --
1820: IF l_task_rec.attribute11 = Fnd_Api.G_MISS_CHAR THEN
1821: l_task_rec.attribute11 := NULL;
1822: END IF;
1823: --
1824: IF l_task_rec.attribute12 = Fnd_Api.G_MISS_CHAR THEN

Line 1824: IF l_task_rec.attribute12 = Fnd_Api.G_MISS_CHAR THEN

1820: IF l_task_rec.attribute11 = Fnd_Api.G_MISS_CHAR THEN
1821: l_task_rec.attribute11 := NULL;
1822: END IF;
1823: --
1824: IF l_task_rec.attribute12 = Fnd_Api.G_MISS_CHAR THEN
1825: l_task_rec.attribute12 := NULL;
1826: END IF;
1827: --
1828: IF l_task_rec.attribute13 = Fnd_Api.G_MISS_CHAR THEN

Line 1828: IF l_task_rec.attribute13 = Fnd_Api.G_MISS_CHAR THEN

1824: IF l_task_rec.attribute12 = Fnd_Api.G_MISS_CHAR THEN
1825: l_task_rec.attribute12 := NULL;
1826: END IF;
1827: --
1828: IF l_task_rec.attribute13 = Fnd_Api.G_MISS_CHAR THEN
1829: l_task_rec.attribute13 := NULL;
1830: END IF;
1831: --
1832: IF l_task_rec.attribute14 = Fnd_Api.G_MISS_CHAR THEN

Line 1832: IF l_task_rec.attribute14 = Fnd_Api.G_MISS_CHAR THEN

1828: IF l_task_rec.attribute13 = Fnd_Api.G_MISS_CHAR THEN
1829: l_task_rec.attribute13 := NULL;
1830: END IF;
1831: --
1832: IF l_task_rec.attribute14 = Fnd_Api.G_MISS_CHAR THEN
1833: l_task_rec.attribute14 := NULL;
1834: END IF;
1835: --
1836: IF l_task_rec.attribute15 = Fnd_Api.G_MISS_CHAR THEN

Line 1836: IF l_task_rec.attribute15 = Fnd_Api.G_MISS_CHAR THEN

1832: IF l_task_rec.attribute14 = Fnd_Api.G_MISS_CHAR THEN
1833: l_task_rec.attribute14 := NULL;
1834: END IF;
1835: --
1836: IF l_task_rec.attribute15 = Fnd_Api.G_MISS_CHAR THEN
1837: l_task_rec.attribute15 := NULL;
1838: END IF;
1839:
1840: IF (l_log_statement >= l_log_current_level) THEN

Line 1883: x_return_status := Fnd_Api.g_ret_sts_success;

1879: EXIT WHEN y = p_MR_Serial_tbl.LAST ;
1880: y := p_MR_Serial_tbl.NEXT(y);
1881: END LOOP;
1882: END IF; -- End of check p_MR_Id_tbl.count > 0
1883: x_return_status := Fnd_Api.g_ret_sts_success;
1884: IF (l_log_procedure >= l_log_current_level) THEN
1885: fnd_log.string(l_log_procedure,
1886: L_DEBUG_KEY ||'.end',
1887: 'At the end of PL SQL procedure. Return Status = ' || x_return_status);

Line 2121: IF l_msg_count > 0 OR l_return_status <> Fnd_Api.g_ret_sts_success THEN

2117: l_org_id := p_org_id;
2118: END IF;
2119:
2120: l_msg_count := FND_MSG_PUB.count_msg;
2121: IF l_msg_count > 0 OR l_return_status <> Fnd_Api.g_ret_sts_success THEN
2122: x_return_status := FND_API.G_RET_STS_ERROR;
2123: RAISE FND_API.G_EXC_ERROR;
2124: END IF;
2125:

Line 2122: x_return_status := FND_API.G_RET_STS_ERROR;

2118: END IF;
2119:
2120: l_msg_count := FND_MSG_PUB.count_msg;
2121: IF l_msg_count > 0 OR l_return_status <> Fnd_Api.g_ret_sts_success THEN
2122: x_return_status := FND_API.G_RET_STS_ERROR;
2123: RAISE FND_API.G_EXC_ERROR;
2124: END IF;
2125:
2126: IF (l_log_statement >= l_log_current_level) THEN

Line 2123: RAISE FND_API.G_EXC_ERROR;

2119:
2120: l_msg_count := FND_MSG_PUB.count_msg;
2121: IF l_msg_count > 0 OR l_return_status <> Fnd_Api.g_ret_sts_success THEN
2122: x_return_status := FND_API.G_RET_STS_ERROR;
2123: RAISE FND_API.G_EXC_ERROR;
2124: END IF;
2125:
2126: IF (l_log_statement >= l_log_current_level) THEN
2127: fnd_log.string(l_log_statement,

Line 2160: IF l_msg_count > 0 OR l_return_status <> Fnd_Api.g_ret_sts_success THEN

2156: '. Return Status = ' || l_return_status);
2157: END IF;
2158:
2159: l_msg_count := FND_MSG_PUB.count_msg;
2160: IF l_msg_count > 0 OR l_return_status <> Fnd_Api.g_ret_sts_success THEN
2161: IF (l_log_statement >= l_log_current_level) THEN
2162: fnd_log.string(l_log_statement,
2163: L_DEBUG_KEY,
2164: 'Errors from INSERT_TASKS. Message count: ' ||

Line 2167: x_return_status := FND_API.G_RET_STS_ERROR;

2163: L_DEBUG_KEY,
2164: 'Errors from INSERT_TASKS. Message count: ' ||
2165: l_msg_count || ', message data: ' || l_msg_data);
2166: END IF;
2167: x_return_status := FND_API.G_RET_STS_ERROR;
2168: RAISE FND_API.G_EXC_ERROR;
2169: END IF;
2170:
2171: p_x_parent_MR_Id := l_task_id; -- To get MR as parent for child summary tasks

Line 2168: RAISE FND_API.G_EXC_ERROR;

2164: 'Errors from INSERT_TASKS. Message count: ' ||
2165: l_msg_count || ', message data: ' || l_msg_data);
2166: END IF;
2167: x_return_status := FND_API.G_RET_STS_ERROR;
2168: RAISE FND_API.G_EXC_ERROR;
2169: END IF;
2170:
2171: p_x_parent_MR_Id := l_task_id; -- To get MR as parent for child summary tasks
2172: l_parent_Task_Id := l_task_id; -- To get MR as parent for child planned/unplanned tasks

Line 2217: RAISE FND_API.G_EXC_ERROR;

2213: IF c_stage%NOTFOUND THEN
2214: Fnd_Message.SET_NAME('AHL','AHL_VWP_STAGE_NO_EXIST');
2215: Fnd_Msg_Pub.ADD;
2216: CLOSE c_stage;
2217: RAISE FND_API.G_EXC_ERROR;
2218: END IF;
2219: CLOSE c_stage;
2220: END IF;
2221: --- End of 11.5.10 Changes by Senthil.

Line 2262: IF l_msg_count > 0 OR l_return_status <> Fnd_Api.g_ret_sts_success THEN

2258: '. Visit ID = ' || l_visit_id);
2259: END IF;
2260:
2261: l_msg_count := FND_MSG_PUB.count_msg;
2262: IF l_msg_count > 0 OR l_return_status <> Fnd_Api.g_ret_sts_success THEN
2263: IF (l_log_statement >= l_log_current_level) THEN
2264: fnd_log.string(l_log_statement,
2265: L_DEBUG_KEY,
2266: 'Errors from INSERT_TASKS. Message count: ' ||

Line 2269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2265: L_DEBUG_KEY,
2266: 'Errors from INSERT_TASKS. Message count: ' ||
2267: l_msg_count || ', message data: ' || l_msg_data);
2268: END IF;
2269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2270: RAISE FND_API.G_EXC_ERROR;
2271: END IF;
2272:
2273: -- To call LTP Process Materials API for APS Integration by Shbhanda 04-Dec-03

Line 2270: RAISE FND_API.G_EXC_ERROR;

2266: 'Errors from INSERT_TASKS. Message count: ' ||
2267: l_msg_count || ', message data: ' || l_msg_data);
2268: END IF;
2269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2270: RAISE FND_API.G_EXC_ERROR;
2271: END IF;
2272:
2273: -- To call LTP Process Materials API for APS Integration by Shbhanda 04-Dec-03
2274: OPEN c_task_det(l_task_id);

Line 2287: p_init_msg_list => FND_API.g_false,

2283: 'PLANNED TASK - Before calling AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials');
2284: END IF;
2285: AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials (
2286: p_api_version => 1.0,
2287: p_init_msg_list => FND_API.g_false,
2288: p_commit => FND_API.g_false,
2289: p_validation_level => FND_API.g_valid_level_full,
2290: p_visit_id => l_Visit_Id,
2291: p_visit_task_id => l_Task_Id,

Line 2288: p_commit => FND_API.g_false,

2284: END IF;
2285: AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials (
2286: p_api_version => 1.0,
2287: p_init_msg_list => FND_API.g_false,
2288: p_commit => FND_API.g_false,
2289: p_validation_level => FND_API.g_valid_level_full,
2290: p_visit_id => l_Visit_Id,
2291: p_visit_task_id => l_Task_Id,
2292: p_org_id => NULL,

Line 2289: p_validation_level => FND_API.g_valid_level_full,

2285: AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials (
2286: p_api_version => 1.0,
2287: p_init_msg_list => FND_API.g_false,
2288: p_commit => FND_API.g_false,
2289: p_validation_level => FND_API.g_valid_level_full,
2290: p_visit_id => l_Visit_Id,
2291: p_visit_task_id => l_Task_Id,
2292: p_org_id => NULL,
2293: p_start_date => NULL,

Line 2305: IF l_msg_count > 0 OR l_return_status <> Fnd_Api.g_ret_sts_success THEN

2301: L_DEBUG_KEY,
2302: 'PLANNED TASK - After calling AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials');
2303: END IF;
2304: l_msg_count := FND_MSG_PUB.count_msg;
2305: IF l_msg_count > 0 OR l_return_status <> Fnd_Api.g_ret_sts_success THEN
2306: X_return_status := FND_API.G_RET_STS_ERROR;
2307: RAISE FND_API.G_EXC_ERROR;
2308: END IF;
2309: END IF; --check for Visit Task Start Date

Line 2306: X_return_status := FND_API.G_RET_STS_ERROR;

2302: 'PLANNED TASK - After calling AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials');
2303: END IF;
2304: l_msg_count := FND_MSG_PUB.count_msg;
2305: IF l_msg_count > 0 OR l_return_status <> Fnd_Api.g_ret_sts_success THEN
2306: X_return_status := FND_API.G_RET_STS_ERROR;
2307: RAISE FND_API.G_EXC_ERROR;
2308: END IF;
2309: END IF; --check for Visit Task Start Date
2310:

Line 2307: RAISE FND_API.G_EXC_ERROR;

2303: END IF;
2304: l_msg_count := FND_MSG_PUB.count_msg;
2305: IF l_msg_count > 0 OR l_return_status <> Fnd_Api.g_ret_sts_success THEN
2306: X_return_status := FND_API.G_RET_STS_ERROR;
2307: RAISE FND_API.G_EXC_ERROR;
2308: END IF;
2309: END IF; --check for Visit Task Start Date
2310:
2311: EXIT WHEN i = MR_Route_Tbl.LAST ;

Line 2316: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

2312: i := MR_Route_Tbl.NEXT(i);
2313: END LOOP;
2314: END IF;
2315:
2316: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
2317: IF (l_log_procedure >= l_log_current_level) THEN
2318: fnd_log.string(l_log_procedure,
2319: L_DEBUG_KEY ||'.end',
2320: 'At the end of PL SQL procedure. Return Status = ' || x_return_status ||

Line 2326: x_return_status := Fnd_Api.G_RET_STS_ERROR;

2322: END IF;
2323:
2324: EXCEPTION
2325: WHEN NO_DATA_FOUND THEN
2326: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2327: WHEN TOO_MANY_ROWS THEN
2328: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2329: WHEN OTHERS THEN
2330: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 2328: x_return_status := Fnd_Api.G_RET_STS_ERROR;

2324: EXCEPTION
2325: WHEN NO_DATA_FOUND THEN
2326: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2327: WHEN TOO_MANY_ROWS THEN
2328: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2329: WHEN OTHERS THEN
2330: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2331: RAISE;
2332: END Create_Tasks_for_MR;

Line 2330: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

2326: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2327: WHEN TOO_MANY_ROWS THEN
2328: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2329: WHEN OTHERS THEN
2330: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2331: RAISE;
2332: END Create_Tasks_for_MR;
2333:
2334:

Line 2370: p_cost_parent_id <> Fnd_Api.G_MISS_NUM ) THEN

2366: 'Visit Task Id = ' || p_visit_task_id || 'Cost Parent Id = ' || p_cost_parent_id);
2367: END IF;
2368: -- Check for cost parent task id not forming loop
2369: IF (p_cost_parent_id IS NOT NULL AND
2370: p_cost_parent_id <> Fnd_Api.G_MISS_NUM ) THEN
2371:
2372: IF p_cost_parent_id = p_visit_task_id THEN
2373: IF (l_log_statement >= l_log_current_level) THEN
2374: fnd_log.string(l_log_statement,

Line 2380: RAISE Fnd_Api.G_EXC_ERROR;

2376: 'p_cost_parent_id = p_visit_task_id');
2377: END IF;
2378: Fnd_Message.SET_NAME('AHL','AHL_VWP_NO_COST_LOOP');
2379: Fnd_Msg_Pub.ADD;
2380: RAISE Fnd_Api.G_EXC_ERROR;
2381: END IF;
2382:
2383: OPEN c_child (p_visit_task_id, p_visit_id);
2384: LOOP

Line 2396: RAISE Fnd_Api.G_EXC_ERROR;

2392: END IF;
2393: Fnd_Message.SET_NAME('AHL','AHL_VWP_NO_COST_LOOP');
2394: Fnd_Msg_Pub.ADD;
2395: CLOSE c_child;
2396: RAISE Fnd_Api.G_EXC_ERROR;
2397: END IF;
2398: EXIT WHEN c_child%NOTFOUND;
2399: END LOOP;
2400: CLOSE c_child;

Line 2446: p_originating_task_id <> Fnd_Api.G_MISS_NUM ) THEN

2442: p_visit_task_id || '. Originating Task Id' || p_originating_task_id);
2443: END IF;
2444: -- Check for originating task id not forming loop
2445: IF (p_originating_task_id IS NOT NULL AND
2446: p_originating_task_id <> Fnd_Api.G_MISS_NUM ) THEN
2447:
2448: IF p_originating_task_id = p_visit_task_id THEN
2449: IF (l_log_statement >= l_log_current_level) THEN
2450: fnd_log.string(l_log_statement,

Line 2456: RAISE Fnd_Api.G_EXC_ERROR;

2452: 'TASK LOOP1');
2453: END IF;
2454: Fnd_Message.SET_NAME('AHL','AHL_VWP_NO_ORIGIN_LOOP');
2455: Fnd_Msg_Pub.ADD;
2456: RAISE Fnd_Api.G_EXC_ERROR;
2457: END IF;
2458:
2459: OPEN c_child (p_visit_task_id, p_visit_id);
2460: LOOP

Line 2473: RAISE Fnd_Api.G_EXC_ERROR;

2469:
2470: Fnd_Message.SET_NAME('AHL','AHL_VWP_NO_ORIGIN_LOOP');
2471: Fnd_Msg_Pub.ADD;
2472: CLOSE c_child;
2473: RAISE Fnd_Api.G_EXC_ERROR;
2474: END IF;
2475:
2476: EXIT WHEN c_child%NOTFOUND;
2477: END LOOP;

Line 2513: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

2509: L_DEBUG_KEY ||'.begin',
2510: 'At the start of PL SQL procedure. Visit Id = ' || p_visit_id ||
2511: 'p_flag' || p_flag);
2512: END IF;
2513: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
2514: IF p_visit_id IS NOT NULL THEN
2515: UPDATE AHL_VISITS_B
2516: SET OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
2517: ANY_TASK_CHG_FLAG = p_flag

Line 2598: x_return_status := FND_API.G_RET_STS_SUCCESS;

2594: 'At the start of PL SQL procedure. Visit Id = ' ||
2595: p_visit_id || 'Price List Name = ' || p_price_list_name);
2596: END IF;
2597: -- Initialize API return status to success
2598: x_return_status := FND_API.G_RET_STS_SUCCESS;
2599:
2600: OPEN visit_info_csr(p_visit_id);
2601: FETCH visit_info_csr INTO l_service_request_id;
2602: IF (visit_info_csr%NOTFOUND) THEN

Line 2610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2606: fnd_log.string(l_log_unexpected,
2607: L_DEBUG_KEY,
2608: 'Visit id not found in AHL_VISITS_B table');
2609: END IF;
2610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2611: ELSIF(l_service_request_id IS NULL)THEN
2612: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INV_VISIT_UPDT_NOS');
2613: FND_MSG_PUB.ADD;
2614: IF (fnd_log.level_error >= l_log_current_level)THEN

Line 2619: x_return_status := FND_API.G_RET_STS_ERROR;

2615: fnd_log.string(fnd_log.level_error,
2616: L_DEBUG_KEY,
2617: 'price list can not be associated because service request id is not associated to visit');
2618: END IF;
2619: x_return_status := FND_API.G_RET_STS_ERROR;
2620: END IF;
2621: CLOSE visit_info_csr;
2622:
2623: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN

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

2619: x_return_status := FND_API.G_RET_STS_ERROR;
2620: END IF;
2621: CLOSE visit_info_csr;
2622:
2623: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
2624: RETURN;
2625: END IF;
2626:
2627: OPEN customer_id_csr(l_service_request_id);

Line 2638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2634: L_DEBUG_KEY,
2635: 'Associated Service Request ' || l_service_request_id ||
2636: ' is invalid as record not found.');
2637: END IF;
2638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2639: ELSIF(l_customer_id IS NULL)THEN
2640: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INV_SRVREQ_NOCUST');
2641: FND_MSG_PUB.ADD;
2642: IF (fnd_log.level_error >= l_log_current_level)THEN

Line 2647: x_return_status := FND_API.G_RET_STS_ERROR;

2643: fnd_log.string(fnd_log.level_error,
2644: L_DEBUG_KEY,
2645: 'Customer id for corresponding service request ' || l_service_request_id || ' is null.');
2646: END IF;
2647: x_return_status := FND_API.G_RET_STS_ERROR;
2648: END IF;
2649: CLOSE customer_id_csr;
2650:
2651: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN

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

2647: x_return_status := FND_API.G_RET_STS_ERROR;
2648: END IF;
2649: CLOSE customer_id_csr;
2650:
2651: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
2652: RETURN;
2653: END IF;
2654:
2655: -- find out the price list id

Line 2667: x_return_status := FND_API.G_RET_STS_ERROR;

2663: fnd_log.string(fnd_log.level_error,
2664: L_DEBUG_KEY,
2665: 'Valid price list not found with price list name ' || p_price_list_name);
2666: END IF;
2667: x_return_status := FND_API.G_RET_STS_ERROR;
2668: END IF;
2669: CLOSE price_list_id_csr;
2670:
2671: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN

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

2667: x_return_status := FND_API.G_RET_STS_ERROR;
2668: END IF;
2669: CLOSE price_list_id_csr;
2670:
2671: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
2672: RETURN;
2673: END IF;
2674: IF (l_log_procedure >= l_log_current_level) THEN
2675: fnd_log.string(l_log_procedure,

Line 2777: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

2773: END IF;
2774: END LOOP;
2775: CLOSE c_parent;
2776: -- RR
2777: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
2778: IF (l_log_procedure >= l_log_current_level) THEN
2779: fnd_log.string(l_log_procedure,
2780: L_DEBUG_KEY ||'.end',
2781: 'At the end of PL SQL procedure. Return Status = ' || x_return_status);

Line 2832: IF x_item_tbl(k).duration is not NULL AND x_item_tbl(k).duration <> FND_API.G_MISS_NUM

2828: IF x_item_tbl(k).item_id=p_item_tbl2(i).item_id
2829: AND x_item_tbl(k).uom_code=p_item_tbl2(i).uom_code
2830: AND x_item_tbl(k).effective_date=p_item_tbl2(i).effective_date
2831: THEN
2832: IF x_item_tbl(k).duration is not NULL AND x_item_tbl(k).duration <> FND_API.G_MISS_NUM
2833: AND p_item_tbl2(i).duration is not NULL AND p_item_tbl2(i).duration <> FND_API.G_MISS_NUM THEN
2834: x_item_tbl(k).duration := nvl(x_item_tbl(k).duration,0)+nvl(p_item_tbl2(i).duration,0);
2835: l_item_present:=true;
2836: ELSIF (x_item_tbl(k).duration is NULL OR x_item_tbl(k).duration = FND_API.G_MISS_NUM )

Line 2833: AND p_item_tbl2(i).duration is not NULL AND p_item_tbl2(i).duration <> FND_API.G_MISS_NUM THEN

2829: AND x_item_tbl(k).uom_code=p_item_tbl2(i).uom_code
2830: AND x_item_tbl(k).effective_date=p_item_tbl2(i).effective_date
2831: THEN
2832: IF x_item_tbl(k).duration is not NULL AND x_item_tbl(k).duration <> FND_API.G_MISS_NUM
2833: AND p_item_tbl2(i).duration is not NULL AND p_item_tbl2(i).duration <> FND_API.G_MISS_NUM THEN
2834: x_item_tbl(k).duration := nvl(x_item_tbl(k).duration,0)+nvl(p_item_tbl2(i).duration,0);
2835: l_item_present:=true;
2836: ELSIF (x_item_tbl(k).duration is NULL OR x_item_tbl(k).duration = FND_API.G_MISS_NUM )
2837: AND (p_item_tbl2(i).duration is NULL OR p_item_tbl2(i).duration = FND_API.G_MISS_NUM) THEN

Line 2836: ELSIF (x_item_tbl(k).duration is NULL OR x_item_tbl(k).duration = FND_API.G_MISS_NUM )

2832: IF x_item_tbl(k).duration is not NULL AND x_item_tbl(k).duration <> FND_API.G_MISS_NUM
2833: AND p_item_tbl2(i).duration is not NULL AND p_item_tbl2(i).duration <> FND_API.G_MISS_NUM THEN
2834: x_item_tbl(k).duration := nvl(x_item_tbl(k).duration,0)+nvl(p_item_tbl2(i).duration,0);
2835: l_item_present:=true;
2836: ELSIF (x_item_tbl(k).duration is NULL OR x_item_tbl(k).duration = FND_API.G_MISS_NUM )
2837: AND (p_item_tbl2(i).duration is NULL OR p_item_tbl2(i).duration = FND_API.G_MISS_NUM) THEN
2838: x_item_tbl(k).quantity := nvl(x_item_tbl(k).quantity,0)+nvl(p_item_tbl2(i).quantity,0);
2839: l_item_present:=true;
2840: END IF;

Line 2837: AND (p_item_tbl2(i).duration is NULL OR p_item_tbl2(i).duration = FND_API.G_MISS_NUM) THEN

2833: AND p_item_tbl2(i).duration is not NULL AND p_item_tbl2(i).duration <> FND_API.G_MISS_NUM THEN
2834: x_item_tbl(k).duration := nvl(x_item_tbl(k).duration,0)+nvl(p_item_tbl2(i).duration,0);
2835: l_item_present:=true;
2836: ELSIF (x_item_tbl(k).duration is NULL OR x_item_tbl(k).duration = FND_API.G_MISS_NUM )
2837: AND (p_item_tbl2(i).duration is NULL OR p_item_tbl2(i).duration = FND_API.G_MISS_NUM) THEN
2838: x_item_tbl(k).quantity := nvl(x_item_tbl(k).quantity,0)+nvl(p_item_tbl2(i).quantity,0);
2839: l_item_present:=true;
2840: END IF;
2841: END IF;

Line 3085: IF P_DEPT_ID IS NOT NULL AND P_DEPT_ID <> FND_API.G_MISS_NUM

3081: fnd_log.string(l_log_procedure,
3082: L_DEBUG_KEY ||'.begin',
3083: 'At the start of PL SQL procedure. Department Id = ' || p_dept_id);
3084: END IF;
3085: IF P_DEPT_ID IS NOT NULL AND P_DEPT_ID <> FND_API.G_MISS_NUM
3086: THEN
3087: OPEN get_dept_csr (p_dept_id);
3088: FETCH get_dept_csr INTO l_dummy;
3089: IF (get_dept_csr%NOTFOUND) THEN

Line 3090: x_return_status:= Fnd_Api.G_RET_STS_ERROR;

3086: THEN
3087: OPEN get_dept_csr (p_dept_id);
3088: FETCH get_dept_csr INTO l_dummy;
3089: IF (get_dept_csr%NOTFOUND) THEN
3090: x_return_status:= Fnd_Api.G_RET_STS_ERROR;
3091: ELSE
3092: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
3093: END IF;
3094: CLOSE get_dept_csr;

Line 3092: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

3088: FETCH get_dept_csr INTO l_dummy;
3089: IF (get_dept_csr%NOTFOUND) THEN
3090: x_return_status:= Fnd_Api.G_RET_STS_ERROR;
3091: ELSE
3092: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
3093: END IF;
3094: CLOSE get_dept_csr;
3095: ELSE
3096: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

Line 3096: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

3092: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
3093: END IF;
3094: CLOSE get_dept_csr;
3095: ELSE
3096: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
3097: END IF;
3098: IF (l_log_procedure >= l_log_current_level) THEN
3099: fnd_log.string(l_log_procedure,
3100: L_DEBUG_KEY ||'.end',