APPS.AHL_VWP_PLAN_TASKS_PVT dependencies on FND_LOG

Line 308: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

304: c_visit_rec c_visit%ROWTYPE;
305:
306: BEGIN
307:
308: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
309: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.begin','At the start of PL SQL procedure ');
310: END IF;
311:
312: --------------------Value OR ID conversion---------------------------

Line 309: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.begin','At the start of PL SQL procedure ');

305:
306: BEGIN
307:
308: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
309: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.begin','At the start of PL SQL procedure ');
310: END IF;
311:
312: --------------------Value OR ID conversion---------------------------
313: --Start API Body

Line 358: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

354: --p_x_task_Rec.department_id := c_visit_rec.department_id;
355: p_x_task_Rec.department_id := NULL;
356: END IF;
357:
358: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
359: fnd_log.string(fnd_log.level_statement,L_DEBUG,' Dept ID= ' || p_x_task_Rec.department_id);
360: END IF;
361: ELSE -- Else of if visit org not exists
362: IF (p_x_task_Rec.dept_name IS NOT NULL AND p_x_task_Rec.dept_name <> Fnd_Api.G_MISS_CHAR ) THEN

Line 359: fnd_log.string(fnd_log.level_statement,L_DEBUG,' Dept ID= ' || p_x_task_Rec.department_id);

355: p_x_task_Rec.department_id := NULL;
356: END IF;
357:
358: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
359: fnd_log.string(fnd_log.level_statement,L_DEBUG,' Dept ID= ' || p_x_task_Rec.department_id);
360: END IF;
361: ELSE -- Else of if visit org not exists
362: IF (p_x_task_Rec.dept_name IS NOT NULL AND p_x_task_Rec.dept_name <> Fnd_Api.G_MISS_CHAR ) THEN
363: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 363: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

359: fnd_log.string(fnd_log.level_statement,L_DEBUG,' Dept ID= ' || p_x_task_Rec.department_id);
360: END IF;
361: ELSE -- Else of if visit org not exists
362: IF (p_x_task_Rec.dept_name IS NOT NULL AND p_x_task_Rec.dept_name <> Fnd_Api.G_MISS_CHAR ) THEN
363: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
364: fnd_log.string(fnd_log.level_statement,L_DEBUG,' NO ORGANIZATION FOR VISIT');
365: END IF;
366: Fnd_Message.SET_NAME('AHL','AHL_VWP_VISIT_NO_ORG_EXISTS');
367: Fnd_Msg_Pub.ADD;

Line 364: fnd_log.string(fnd_log.level_statement,L_DEBUG,' NO ORGANIZATION FOR VISIT');

360: END IF;
361: ELSE -- Else of if visit org not exists
362: IF (p_x_task_Rec.dept_name IS NOT NULL AND p_x_task_Rec.dept_name <> Fnd_Api.G_MISS_CHAR ) THEN
363: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
364: fnd_log.string(fnd_log.level_statement,L_DEBUG,' NO ORGANIZATION FOR VISIT');
365: END IF;
366: Fnd_Message.SET_NAME('AHL','AHL_VWP_VISIT_NO_ORG_EXISTS');
367: Fnd_Msg_Pub.ADD;
368: RAISE Fnd_Api.G_EXC_ERROR;

Line 387: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

383: Fnd_Msg_Pub.ADD;
384: RAISE Fnd_Api.g_exc_error;
385: END IF;
386:
387: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
388: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Service ID= ' || p_x_task_Rec.service_request_id);
389: END IF;
390: ELSE
391: p_x_task_Rec.service_request_id := NULL;

Line 388: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Service ID= ' || p_x_task_Rec.service_request_id);

384: RAISE Fnd_Api.g_exc_error;
385: END IF;
386:
387: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
388: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.', l_full_name ||': Service ID= ' || p_x_task_Rec.service_request_id);
389: END IF;
390: ELSE
391: p_x_task_Rec.service_request_id := NULL;
392: p_x_task_Rec.service_request_number := NULL;

Line 396: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

392: p_x_task_Rec.service_request_number := NULL;
393: END IF;
394: */
395:
396: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
397: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.end','At the end of PL SQL procedure ');
398: END IF;
399:
400: END Asso_Inst_Dept_to_Tasks;

Line 397: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.end','At the end of PL SQL procedure ');

393: END IF;
394: */
395:
396: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
397: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.end','At the end of PL SQL procedure ');
398: END IF;
399:
400: END Asso_Inst_Dept_to_Tasks;
401:

Line 612: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

608: --------------------- initialize -----------------------
609: SAVEPOINT Create_Planned_Task;
610:
611: -- Debug info.
612: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
613: fnd_log.string(fnd_log.level_procedure, L_DEBUG||'.begin','At the start of PLSQL procedure');
614: END IF;
615:
616: IF Fnd_Api.to_boolean (p_init_msg_list) THEN

Line 613: fnd_log.string(fnd_log.level_procedure, L_DEBUG||'.begin','At the start of PLSQL procedure');

609: SAVEPOINT Create_Planned_Task;
610:
611: -- Debug info.
612: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
613: fnd_log.string(fnd_log.level_procedure, L_DEBUG||'.begin','At the start of PLSQL procedure');
614: END IF;
615:
616: IF Fnd_Api.to_boolean (p_init_msg_list) THEN
617: Fnd_Msg_Pub.initialize;

Line 648: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

644: l_department_id := NULL;
645: END IF;
646:
647: -- Cursor to retrieve visit info
648: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
649: fnd_log.string(fnd_log.level_statement, L_DEBUG,'Visit Id: Unit Effe Id ' || l_visit_id || '-' || l_unit_effectivity_id);
650: fnd_log.string(fnd_log.level_statement, L_DEBUG ,'Service Req Id: Department Id:' || l_service_req_id || '-' || l_department_id);
651: END IF;
652:

Line 649: fnd_log.string(fnd_log.level_statement, L_DEBUG,'Visit Id: Unit Effe Id ' || l_visit_id || '-' || l_unit_effectivity_id);

645: END IF;
646:
647: -- Cursor to retrieve visit info
648: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
649: fnd_log.string(fnd_log.level_statement, L_DEBUG,'Visit Id: Unit Effe Id ' || l_visit_id || '-' || l_unit_effectivity_id);
650: fnd_log.string(fnd_log.level_statement, L_DEBUG ,'Service Req Id: Department Id:' || l_service_req_id || '-' || l_department_id);
651: END IF;
652:
653: IF l_unit_effectivity_id IS NOT NULL THEN

Line 650: fnd_log.string(fnd_log.level_statement, L_DEBUG ,'Service Req Id: Department Id:' || l_service_req_id || '-' || l_department_id);

646:
647: -- Cursor to retrieve visit info
648: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
649: fnd_log.string(fnd_log.level_statement, L_DEBUG,'Visit Id: Unit Effe Id ' || l_visit_id || '-' || l_unit_effectivity_id);
650: fnd_log.string(fnd_log.level_statement, L_DEBUG ,'Service Req Id: Department Id:' || l_service_req_id || '-' || l_department_id);
651: END IF;
652:
653: IF l_unit_effectivity_id IS NOT NULL THEN
654: OPEN c_unit (l_unit_effectivity_id);

Line 671: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

667: Fnd_Msg_Pub.ADD;
668: ELSE -- UE not planned in any other Visit
669: CLOSE c_unit;
670:
671: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
672: fnd_log.string(fnd_log.level_statement, L_DEBUG,'Unit effectivity' || l_unit_effectivity_id);
673: END IF;
674:
675: -- Get the Object_type code to check whether it is SR or MR.

Line 672: fnd_log.string(fnd_log.level_statement, L_DEBUG,'Unit effectivity' || l_unit_effectivity_id);

668: ELSE -- UE not planned in any other Visit
669: CLOSE c_unit;
670:
671: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
672: fnd_log.string(fnd_log.level_statement, L_DEBUG,'Unit effectivity' || l_unit_effectivity_id);
673: END IF;
674:
675: -- Get the Object_type code to check whether it is SR or MR.
676: OPEN c_unit_object_type (l_unit_effectivity_id);

Line 680: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

676: OPEN c_unit_object_type (l_unit_effectivity_id);
677: FETCH c_unit_object_type INTO l_object_type;
678: CLOSE c_unit_object_type;
679:
680: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
681: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Before l_object_type check' );
682: END IF;
683:
684: IF l_object_type = 'MR' THEN

Line 681: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Before l_object_type check' );

677: FETCH c_unit_object_type INTO l_object_type;
678: CLOSE c_unit_object_type;
679:
680: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
681: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Before l_object_type check' );
682: END IF;
683:
684: IF l_object_type = 'MR' THEN
685: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 685: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

681: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Before l_object_type check' );
682: END IF;
683:
684: IF l_object_type = 'MR' THEN
685: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
686: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Before calling create_mr_tasks');
687: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'ue id =>' || l_unit_effectivity_id);
688: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'parent ue id =>' || 'null');
689: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'visit id =>' || l_visit_id);

Line 686: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Before calling create_mr_tasks');

682: END IF;
683:
684: IF l_object_type = 'MR' THEN
685: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
686: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Before calling create_mr_tasks');
687: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'ue id =>' || l_unit_effectivity_id);
688: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'parent ue id =>' || 'null');
689: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'visit id =>' || l_visit_id);
690: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'department id =>' || l_department_id);

Line 687: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'ue id =>' || l_unit_effectivity_id);

683:
684: IF l_object_type = 'MR' THEN
685: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
686: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Before calling create_mr_tasks');
687: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'ue id =>' || l_unit_effectivity_id);
688: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'parent ue id =>' || 'null');
689: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'visit id =>' || l_visit_id);
690: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'department id =>' || l_department_id);
691: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'service_request id =>' || l_service_req_id);

Line 688: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'parent ue id =>' || 'null');

684: IF l_object_type = 'MR' THEN
685: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
686: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Before calling create_mr_tasks');
687: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'ue id =>' || l_unit_effectivity_id);
688: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'parent ue id =>' || 'null');
689: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'visit id =>' || l_visit_id);
690: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'department id =>' || l_department_id);
691: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'service_request id =>' || l_service_req_id);
692: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'quantity =>' || p_x_task_Rec.quantity);

Line 689: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'visit id =>' || l_visit_id);

685: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
686: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Before calling create_mr_tasks');
687: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'ue id =>' || l_unit_effectivity_id);
688: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'parent ue id =>' || 'null');
689: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'visit id =>' || l_visit_id);
690: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'department id =>' || l_department_id);
691: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'service_request id =>' || l_service_req_id);
692: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'quantity =>' || p_x_task_Rec.quantity);
693: END IF;

Line 690: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'department id =>' || l_department_id);

686: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Before calling create_mr_tasks');
687: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'ue id =>' || l_unit_effectivity_id);
688: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'parent ue id =>' || 'null');
689: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'visit id =>' || l_visit_id);
690: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'department id =>' || l_department_id);
691: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'service_request id =>' || l_service_req_id);
692: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'quantity =>' || p_x_task_Rec.quantity);
693: END IF;
694:

Line 691: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'service_request id =>' || l_service_req_id);

687: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'ue id =>' || l_unit_effectivity_id);
688: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'parent ue id =>' || 'null');
689: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'visit id =>' || l_visit_id);
690: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'department id =>' || l_department_id);
691: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'service_request id =>' || l_service_req_id);
692: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'quantity =>' || p_x_task_Rec.quantity);
693: END IF;
694:
695: create_mr_tasks(p_ue_id => l_unit_effectivity_id,

Line 692: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'quantity =>' || p_x_task_Rec.quantity);

688: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'parent ue id =>' || 'null');
689: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'visit id =>' || l_visit_id);
690: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'department id =>' || l_department_id);
691: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'service_request id =>' || l_service_req_id);
692: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'quantity =>' || p_x_task_Rec.quantity);
693: END IF;
694:
695: create_mr_tasks(p_ue_id => l_unit_effectivity_id,
696: p_parent_ue_id => null,

Line 707: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

703: );
704:
705: -- if object type is SR
706: ELSIF l_object_type = 'SR' THEN
707: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
708: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'l_object_type = SR');
709: END IF;
710: -- Get the details of the UE
711: OPEN c_item_info (l_unit_effectivity_id);

Line 708: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'l_object_type = SR');

704:
705: -- if object type is SR
706: ELSIF l_object_type = 'SR' THEN
707: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
708: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'l_object_type = SR');
709: END IF;
710: -- Get the details of the UE
711: OPEN c_item_info (l_unit_effectivity_id);
712: FETCH c_item_info INTO l_serial_id,l_service_req_id,l_org_id,l_item_id;

Line 715: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

711: OPEN c_item_info (l_unit_effectivity_id);
712: FETCH c_item_info INTO l_serial_id,l_service_req_id,l_org_id,l_item_id;
713: CLOSE c_item_info;
714:
715: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
716: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Before calling AHL_VWP_RULES_PVT.Insert_Tasks');
717: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'ue_id =>' || l_unit_effectivity_id);
718: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'parent ue id =>' || 'null');
719: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'visit id =>' || l_visit_id);

Line 716: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Before calling AHL_VWP_RULES_PVT.Insert_Tasks');

712: FETCH c_item_info INTO l_serial_id,l_service_req_id,l_org_id,l_item_id;
713: CLOSE c_item_info;
714:
715: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
716: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Before calling AHL_VWP_RULES_PVT.Insert_Tasks');
717: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'ue_id =>' || l_unit_effectivity_id);
718: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'parent ue id =>' || 'null');
719: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'visit id =>' || l_visit_id);
720: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'department id =>' || l_department_id);

Line 717: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'ue_id =>' || l_unit_effectivity_id);

713: CLOSE c_item_info;
714:
715: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
716: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Before calling AHL_VWP_RULES_PVT.Insert_Tasks');
717: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'ue_id =>' || l_unit_effectivity_id);
718: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'parent ue id =>' || 'null');
719: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'visit id =>' || l_visit_id);
720: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'department id =>' || l_department_id);
721: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'service request id =>' || l_service_req_id);

Line 718: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'parent ue id =>' || 'null');

714:
715: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
716: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Before calling AHL_VWP_RULES_PVT.Insert_Tasks');
717: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'ue_id =>' || l_unit_effectivity_id);
718: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'parent ue id =>' || 'null');
719: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'visit id =>' || l_visit_id);
720: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'department id =>' || l_department_id);
721: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'service request id =>' || l_service_req_id);
722: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'quantity =>' || p_x_task_Rec.quantity);

Line 719: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'visit id =>' || l_visit_id);

715: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
716: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Before calling AHL_VWP_RULES_PVT.Insert_Tasks');
717: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'ue_id =>' || l_unit_effectivity_id);
718: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'parent ue id =>' || 'null');
719: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'visit id =>' || l_visit_id);
720: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'department id =>' || l_department_id);
721: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'service request id =>' || l_service_req_id);
722: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'quantity =>' || p_x_task_Rec.quantity);
723: END IF;

Line 720: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'department id =>' || l_department_id);

716: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Before calling AHL_VWP_RULES_PVT.Insert_Tasks');
717: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'ue_id =>' || l_unit_effectivity_id);
718: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'parent ue id =>' || 'null');
719: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'visit id =>' || l_visit_id);
720: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'department id =>' || l_department_id);
721: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'service request id =>' || l_service_req_id);
722: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'quantity =>' || p_x_task_Rec.quantity);
723: END IF;
724:

Line 721: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'service request id =>' || l_service_req_id);

717: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'ue_id =>' || l_unit_effectivity_id);
718: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'parent ue id =>' || 'null');
719: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'visit id =>' || l_visit_id);
720: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'department id =>' || l_department_id);
721: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'service request id =>' || l_service_req_id);
722: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'quantity =>' || p_x_task_Rec.quantity);
723: END IF;
724:
725: OPEN c_task_for_ue(l_visit_id, l_unit_effectivity_id);

Line 722: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'quantity =>' || p_x_task_Rec.quantity);

718: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'parent ue id =>' || 'null');
719: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'visit id =>' || l_visit_id);
720: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'department id =>' || l_department_id);
721: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'service request id =>' || l_service_req_id);
722: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'quantity =>' || p_x_task_Rec.quantity);
723: END IF;
724:
725: OPEN c_task_for_ue(l_visit_id, l_unit_effectivity_id);
726: FETCH c_task_for_ue INTO l_parent_task_id;

Line 751: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

747: x_msg_count => l_msg_count,
748: x_msg_data => l_msg_data
749: );
750:
751: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
752: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'After AHL_VWP_RULES_PVT.Insert_Tasks for Planned Task');
753: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'l_return_status' || l_return_status);
754: END IF;
755:

Line 752: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'After AHL_VWP_RULES_PVT.Insert_Tasks for Planned Task');

748: x_msg_data => l_msg_data
749: );
750:
751: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
752: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'After AHL_VWP_RULES_PVT.Insert_Tasks for Planned Task');
753: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'l_return_status' || l_return_status);
754: END IF;
755:
756: IF NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN

Line 753: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'l_return_status' || l_return_status);

749: );
750:
751: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
752: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'After AHL_VWP_RULES_PVT.Insert_Tasks for Planned Task');
753: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'l_return_status' || l_return_status);
754: END IF;
755:
756: IF NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
757: CLOSE c_task_for_ue; -- NR-MR Changes - sowsubra

Line 768: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

764: -- Check if any valid child UE exist
765: OPEN c_check_child_ue(l_unit_effectivity_id);
766: FETCH c_check_child_ue INTO l_dummy;
767: IF c_check_child_ue%FOUND THEN
768: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
769: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Before calling create_mr_tasks');
770: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'c_check_child_ue%FOUND is TRUE');
771: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'ue id =>' || l_unit_effectivity_id);
772: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'parent ue id =>' || l_parent_task_id);

Line 769: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Before calling create_mr_tasks');

765: OPEN c_check_child_ue(l_unit_effectivity_id);
766: FETCH c_check_child_ue INTO l_dummy;
767: IF c_check_child_ue%FOUND THEN
768: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
769: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Before calling create_mr_tasks');
770: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'c_check_child_ue%FOUND is TRUE');
771: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'ue id =>' || l_unit_effectivity_id);
772: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'parent ue id =>' || l_parent_task_id);
773: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'visit id =>' || l_visit_id);

Line 770: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'c_check_child_ue%FOUND is TRUE');

766: FETCH c_check_child_ue INTO l_dummy;
767: IF c_check_child_ue%FOUND THEN
768: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
769: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Before calling create_mr_tasks');
770: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'c_check_child_ue%FOUND is TRUE');
771: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'ue id =>' || l_unit_effectivity_id);
772: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'parent ue id =>' || l_parent_task_id);
773: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'visit id =>' || l_visit_id);
774: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'department id =>' || l_department_id);

Line 771: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'ue id =>' || l_unit_effectivity_id);

767: IF c_check_child_ue%FOUND THEN
768: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
769: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Before calling create_mr_tasks');
770: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'c_check_child_ue%FOUND is TRUE');
771: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'ue id =>' || l_unit_effectivity_id);
772: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'parent ue id =>' || l_parent_task_id);
773: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'visit id =>' || l_visit_id);
774: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'department id =>' || l_department_id);
775: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'service request id =>' || l_service_req_id);

Line 772: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'parent ue id =>' || l_parent_task_id);

768: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
769: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Before calling create_mr_tasks');
770: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'c_check_child_ue%FOUND is TRUE');
771: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'ue id =>' || l_unit_effectivity_id);
772: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'parent ue id =>' || l_parent_task_id);
773: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'visit id =>' || l_visit_id);
774: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'department id =>' || l_department_id);
775: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'service request id =>' || l_service_req_id);
776: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'quantity =>' || p_x_task_Rec.quantity);

Line 773: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'visit id =>' || l_visit_id);

769: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Before calling create_mr_tasks');
770: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'c_check_child_ue%FOUND is TRUE');
771: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'ue id =>' || l_unit_effectivity_id);
772: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'parent ue id =>' || l_parent_task_id);
773: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'visit id =>' || l_visit_id);
774: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'department id =>' || l_department_id);
775: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'service request id =>' || l_service_req_id);
776: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'quantity =>' || p_x_task_Rec.quantity);
777: END IF;

Line 774: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'department id =>' || l_department_id);

770: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'c_check_child_ue%FOUND is TRUE');
771: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'ue id =>' || l_unit_effectivity_id);
772: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'parent ue id =>' || l_parent_task_id);
773: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'visit id =>' || l_visit_id);
774: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'department id =>' || l_department_id);
775: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'service request id =>' || l_service_req_id);
776: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'quantity =>' || p_x_task_Rec.quantity);
777: END IF;
778: -- The New API which would recursively create tasks for all the MRs which are the children of the SR

Line 775: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'service request id =>' || l_service_req_id);

771: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'ue id =>' || l_unit_effectivity_id);
772: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'parent ue id =>' || l_parent_task_id);
773: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'visit id =>' || l_visit_id);
774: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'department id =>' || l_department_id);
775: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'service request id =>' || l_service_req_id);
776: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'quantity =>' || p_x_task_Rec.quantity);
777: END IF;
778: -- The New API which would recursively create tasks for all the MRs which are the children of the SR
779: -- the Task id returned by Insert_Tasks is passed as the parent id here

Line 776: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'quantity =>' || p_x_task_Rec.quantity);

772: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'parent ue id =>' || l_parent_task_id);
773: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'visit id =>' || l_visit_id);
774: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'department id =>' || l_department_id);
775: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'service request id =>' || l_service_req_id);
776: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'quantity =>' || p_x_task_Rec.quantity);
777: END IF;
778: -- The New API which would recursively create tasks for all the MRs which are the children of the SR
779: -- the Task id returned by Insert_Tasks is passed as the parent id here
780: create_mr_tasks(p_ue_id => l_unit_effectivity_id,

Line 802: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

798: Fnd_Msg_Pub.ADD;
799: RAISE Fnd_Api.G_EXC_ERROR;
800: END IF; ***/
801:
802: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
803: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Inside No Child UEs ELSE BLOCK');
804: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Before calling AHL_VWP_RULES_PVT.Insert_Tasks for Planned Task');
805: END IF;
806:

Line 803: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Inside No Child UEs ELSE BLOCK');

799: RAISE Fnd_Api.G_EXC_ERROR;
800: END IF; ***/
801:
802: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
803: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Inside No Child UEs ELSE BLOCK');
804: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Before calling AHL_VWP_RULES_PVT.Insert_Tasks for Planned Task');
805: END IF;
806:
807: -- Create a Planned Task

Line 804: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Before calling AHL_VWP_RULES_PVT.Insert_Tasks for Planned Task');

800: END IF; ***/
801:
802: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
803: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Inside No Child UEs ELSE BLOCK');
804: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Before calling AHL_VWP_RULES_PVT.Insert_Tasks for Planned Task');
805: END IF;
806:
807: -- Create a Planned Task
808: AHL_VWP_RULES_PVT.Insert_Tasks

Line 829: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

825: x_msg_count => l_msg_count,
826: x_msg_data => l_msg_data
827: );
828:
829: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
830: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'After AHL_VWP_RULES_PVT.Insert_Tasks for Planned Task - l_return_status : '|| l_return_status);
831: END IF;
832:
833: IF NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN

Line 830: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'After AHL_VWP_RULES_PVT.Insert_Tasks for Planned Task - l_return_status : '|| l_return_status);

826: x_msg_data => l_msg_data
827: );
828:
829: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
830: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'After AHL_VWP_RULES_PVT.Insert_Tasks for Planned Task - l_return_status : '|| l_return_status);
831: END IF;
832:
833: IF NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
834: RAISE Fnd_Api.G_EXC_ERROR;

Line 887: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

883: IF x_msg_count > 0 THEN
884: RAISE FND_API.G_EXC_ERROR;
885: END IF;
886:
887: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
888: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Before CS_ServiceRequest_PUB.Update_Status ');
889: END IF;
890: -- anraj changed the api
891: CS_ServiceRequest_PUB.Update_Status

Line 888: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Before CS_ServiceRequest_PUB.Update_Status ');

884: RAISE FND_API.G_EXC_ERROR;
885: END IF;
886:
887: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
888: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Before CS_ServiceRequest_PUB.Update_Status ');
889: END IF;
890: -- anraj changed the api
891: CS_ServiceRequest_PUB.Update_Status
892: (

Line 919: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

915: p_status => NULL,
916: x_interaction_id => l_interaction_id
917: );
918:
919: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
920: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'After CS_ServiceRequest_PUB.Update_Status - Return Status - '||x_return_status );
921: END IF;
922:
923: IF NVL(x_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN

Line 920: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'After CS_ServiceRequest_PUB.Update_Status - Return Status - '||x_return_status );

916: x_interaction_id => l_interaction_id
917: );
918:
919: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
920: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'After CS_ServiceRequest_PUB.Update_Status - Return Status - '||x_return_status );
921: END IF;
922:
923: IF NVL(x_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
924: RAISE Fnd_Api.G_EXC_ERROR;

Line 934: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

930: OPEN c_task_id_for_ue(l_visit_id, l_unit_effectivity_id);
931: FETCH c_task_id_for_ue INTO p_x_task_Rec.visit_task_id;
932: CLOSE c_task_id_for_ue;
933:
934: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
935: fnd_log.string(fnd_log.level_statement, L_DEBUG, 'p_x_task_Rec.visit_task_id = ' || p_x_task_Rec.visit_task_id);
936: END IF;
937: /* End changes by rnahata for Bug 6939329 */
938: END IF; -- c_unit%FOUND

Line 935: fnd_log.string(fnd_log.level_statement, L_DEBUG, 'p_x_task_Rec.visit_task_id = ' || p_x_task_Rec.visit_task_id);

931: FETCH c_task_id_for_ue INTO p_x_task_Rec.visit_task_id;
932: CLOSE c_task_id_for_ue;
933:
934: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
935: fnd_log.string(fnd_log.level_statement, L_DEBUG, 'p_x_task_Rec.visit_task_id = ' || p_x_task_Rec.visit_task_id);
936: END IF;
937: /* End changes by rnahata for Bug 6939329 */
938: END IF; -- c_unit%FOUND
939: ELSE -- l_unit_effectivity_id

Line 982: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

978: IF Fnd_Api.To_Boolean ( p_commit ) THEN
979: COMMIT WORK;
980: END IF;
981:
982: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
983: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.end','At the end of PLSQL procedure');
984: END IF;
985:
986: EXCEPTION

Line 983: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.end','At the end of PLSQL procedure');

979: COMMIT WORK;
980: END IF;
981:
982: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
983: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.end','At the end of PLSQL procedure');
984: END IF;
985:
986: EXCEPTION
987: WHEN Fnd_Api.g_exc_error THEN

Line 1111: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

1107: L_DEBUG CONSTANT VARCHAR2(90) := 'ahl.plsql.'||L_FULL_NAME;
1108: MR_Serial_Tbl AHL_VWP_RULES_PVT.MR_Serial_Tbl_Type;
1109:
1110: BEGIN
1111: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1112: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.begin', 'At the start of the procedure..');
1113: fnd_log.string(fnd_log.level_procedure,L_DEBUG, 'p_ue_id' || p_ue_id);
1114: END IF;
1115:

Line 1112: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.begin', 'At the start of the procedure..');

1108: MR_Serial_Tbl AHL_VWP_RULES_PVT.MR_Serial_Tbl_Type;
1109:
1110: BEGIN
1111: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1112: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.begin', 'At the start of the procedure..');
1113: fnd_log.string(fnd_log.level_procedure,L_DEBUG, 'p_ue_id' || p_ue_id);
1114: END IF;
1115:
1116: l_unit_eff_id := p_ue_id;

Line 1113: fnd_log.string(fnd_log.level_procedure,L_DEBUG, 'p_ue_id' || p_ue_id);

1109:
1110: BEGIN
1111: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1112: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.begin', 'At the start of the procedure..');
1113: fnd_log.string(fnd_log.level_procedure,L_DEBUG, 'p_ue_id' || p_ue_id);
1114: END IF;
1115:
1116: l_unit_eff_id := p_ue_id;
1117: l_service_request_id := p_service_request_id;

Line 1133: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1129: OPEN c_info (l_mr_header_id, l_unit_eff_id);
1130: FETCH c_info INTO l_serial_id;
1131: CLOSE c_info;
1132:
1133: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1134: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'l_mr_header_id =>' || l_mr_header_id);
1135: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'l_unit_eff_id =>' ||l_unit_eff_id);
1136: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'l_serial_id =>' || l_serial_id);
1137: END IF;

Line 1134: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'l_mr_header_id =>' || l_mr_header_id);

1130: FETCH c_info INTO l_serial_id;
1131: CLOSE c_info;
1132:
1133: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1134: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'l_mr_header_id =>' || l_mr_header_id);
1135: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'l_unit_eff_id =>' ||l_unit_eff_id);
1136: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'l_serial_id =>' || l_serial_id);
1137: END IF;
1138:

Line 1135: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'l_unit_eff_id =>' ||l_unit_eff_id);

1131: CLOSE c_info;
1132:
1133: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1134: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'l_mr_header_id =>' || l_mr_header_id);
1135: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'l_unit_eff_id =>' ||l_unit_eff_id);
1136: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'l_serial_id =>' || l_serial_id);
1137: END IF;
1138:
1139: -- NR-MR Changes - sowsubra

Line 1136: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'l_serial_id =>' || l_serial_id);

1132:
1133: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1134: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'l_mr_header_id =>' || l_mr_header_id);
1135: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'l_unit_eff_id =>' ||l_unit_eff_id);
1136: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'l_serial_id =>' || l_serial_id);
1137: END IF;
1138:
1139: -- NR-MR Changes - sowsubra
1140: -- Done to allow creation of a task for an instance that has already been removed.

Line 1149: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1145: RAISE Fnd_Api.G_EXC_ERROR;
1146: END IF;
1147: ***/
1148:
1149: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1150: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Calling ahl_vwp_rules_pvt.create_tasks_for_mr');
1151: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_visit_id =>' || p_visit_id);
1152: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_serial_id =>' || l_serial_id);
1153: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_mr_id =>' || l_mr_header_id);

Line 1150: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Calling ahl_vwp_rules_pvt.create_tasks_for_mr');

1146: END IF;
1147: ***/
1148:
1149: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1150: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Calling ahl_vwp_rules_pvt.create_tasks_for_mr');
1151: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_visit_id =>' || p_visit_id);
1152: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_serial_id =>' || l_serial_id);
1153: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_mr_id =>' || l_mr_header_id);
1154: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_department_id =>' || l_department_id);

Line 1151: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_visit_id =>' || p_visit_id);

1147: ***/
1148:
1149: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1150: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Calling ahl_vwp_rules_pvt.create_tasks_for_mr');
1151: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_visit_id =>' || p_visit_id);
1152: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_serial_id =>' || l_serial_id);
1153: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_mr_id =>' || l_mr_header_id);
1154: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_department_id =>' || l_department_id);
1155: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_service_req_id =>' || l_service_request_id);

Line 1152: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_serial_id =>' || l_serial_id);

1148:
1149: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1150: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Calling ahl_vwp_rules_pvt.create_tasks_for_mr');
1151: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_visit_id =>' || p_visit_id);
1152: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_serial_id =>' || l_serial_id);
1153: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_mr_id =>' || l_mr_header_id);
1154: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_department_id =>' || l_department_id);
1155: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_service_req_id =>' || l_service_request_id);
1156: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_x_parent_MR_Id =>' || l_parent_MR_Id);

Line 1153: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_mr_id =>' || l_mr_header_id);

1149: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1150: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Calling ahl_vwp_rules_pvt.create_tasks_for_mr');
1151: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_visit_id =>' || p_visit_id);
1152: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_serial_id =>' || l_serial_id);
1153: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_mr_id =>' || l_mr_header_id);
1154: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_department_id =>' || l_department_id);
1155: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_service_req_id =>' || l_service_request_id);
1156: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_x_parent_MR_Id =>' || l_parent_MR_Id);
1157: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_service_req_id =>' || l_service_request_id);

Line 1154: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_department_id =>' || l_department_id);

1150: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Calling ahl_vwp_rules_pvt.create_tasks_for_mr');
1151: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_visit_id =>' || p_visit_id);
1152: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_serial_id =>' || l_serial_id);
1153: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_mr_id =>' || l_mr_header_id);
1154: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_department_id =>' || l_department_id);
1155: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_service_req_id =>' || l_service_request_id);
1156: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_x_parent_MR_Id =>' || l_parent_MR_Id);
1157: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_service_req_id =>' || l_service_request_id);
1158: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_quantity =>' || p_quantity);

Line 1155: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_service_req_id =>' || l_service_request_id);

1151: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_visit_id =>' || p_visit_id);
1152: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_serial_id =>' || l_serial_id);
1153: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_mr_id =>' || l_mr_header_id);
1154: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_department_id =>' || l_department_id);
1155: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_service_req_id =>' || l_service_request_id);
1156: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_x_parent_MR_Id =>' || l_parent_MR_Id);
1157: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_service_req_id =>' || l_service_request_id);
1158: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_quantity =>' || p_quantity);
1159: END IF;

Line 1156: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_x_parent_MR_Id =>' || l_parent_MR_Id);

1152: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_serial_id =>' || l_serial_id);
1153: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_mr_id =>' || l_mr_header_id);
1154: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_department_id =>' || l_department_id);
1155: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_service_req_id =>' || l_service_request_id);
1156: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_x_parent_MR_Id =>' || l_parent_MR_Id);
1157: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_service_req_id =>' || l_service_request_id);
1158: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_quantity =>' || p_quantity);
1159: END IF;
1160:

Line 1157: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_service_req_id =>' || l_service_request_id);

1153: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_mr_id =>' || l_mr_header_id);
1154: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_department_id =>' || l_department_id);
1155: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_service_req_id =>' || l_service_request_id);
1156: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_x_parent_MR_Id =>' || l_parent_MR_Id);
1157: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_service_req_id =>' || l_service_request_id);
1158: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_quantity =>' || p_quantity);
1159: END IF;
1160:
1161: ahl_vwp_rules_pvt.create_tasks_for_mr(p_visit_id => p_visit_id,

Line 1158: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_quantity =>' || p_quantity);

1154: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_department_id =>' || l_department_id);
1155: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_service_req_id =>' || l_service_request_id);
1156: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_x_parent_MR_Id =>' || l_parent_MR_Id);
1157: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_service_req_id =>' || l_service_request_id);
1158: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_quantity =>' || p_quantity);
1159: END IF;
1160:
1161: ahl_vwp_rules_pvt.create_tasks_for_mr(p_visit_id => p_visit_id,
1162: p_unit_id => l_unit_eff_id,

Line 1175: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1171: p_x_parent_MR_Id => l_parent_MR_Id,
1172: x_return_status => l_return_status
1173: );
1174:
1175: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1176: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'After ahl_vwp_rules_pvt.create_tasks_for_mr');
1177: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_x_parent_MR_Id = ' || l_parent_MR_Id );
1178: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'x_return_status is ' || l_return_status );
1179: END IF;

Line 1176: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'After ahl_vwp_rules_pvt.create_tasks_for_mr');

1172: x_return_status => l_return_status
1173: );
1174:
1175: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1176: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'After ahl_vwp_rules_pvt.create_tasks_for_mr');
1177: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_x_parent_MR_Id = ' || l_parent_MR_Id );
1178: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'x_return_status is ' || l_return_status );
1179: END IF;
1180:

Line 1177: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_x_parent_MR_Id = ' || l_parent_MR_Id );

1173: );
1174:
1175: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1176: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'After ahl_vwp_rules_pvt.create_tasks_for_mr');
1177: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_x_parent_MR_Id = ' || l_parent_MR_Id );
1178: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'x_return_status is ' || l_return_status );
1179: END IF;
1180:
1181: IF NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN

Line 1178: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'x_return_status is ' || l_return_status );

1174:
1175: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1176: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'After ahl_vwp_rules_pvt.create_tasks_for_mr');
1177: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'p_x_parent_MR_Id = ' || l_parent_MR_Id );
1178: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'x_return_status is ' || l_return_status );
1179: END IF;
1180:
1181: IF NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
1182: RAISE Fnd_Api.G_EXC_ERROR;

Line 1187: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1183: END IF;
1184:
1185: MR_Serial_Tbl(0).MR_ID := l_mr_header_id ;
1186: MR_Serial_Tbl(0).Serial_ID := l_serial_id;
1187: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1188: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Calling AHL_VWP_RULES_PVT.Tech_Dependency');
1189: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'MR_Serial_Tbl(0).MR_ID -->'|| MR_Serial_Tbl(0).MR_ID);
1190: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'MR_Serial_Tbl(0).Serial_ID'|| MR_Serial_Tbl(0).Serial_ID);
1191: END IF;

Line 1188: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Calling AHL_VWP_RULES_PVT.Tech_Dependency');

1184:
1185: MR_Serial_Tbl(0).MR_ID := l_mr_header_id ;
1186: MR_Serial_Tbl(0).Serial_ID := l_serial_id;
1187: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1188: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Calling AHL_VWP_RULES_PVT.Tech_Dependency');
1189: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'MR_Serial_Tbl(0).MR_ID -->'|| MR_Serial_Tbl(0).MR_ID);
1190: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'MR_Serial_Tbl(0).Serial_ID'|| MR_Serial_Tbl(0).Serial_ID);
1191: END IF;
1192:

Line 1189: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'MR_Serial_Tbl(0).MR_ID -->'|| MR_Serial_Tbl(0).MR_ID);

1185: MR_Serial_Tbl(0).MR_ID := l_mr_header_id ;
1186: MR_Serial_Tbl(0).Serial_ID := l_serial_id;
1187: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1188: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Calling AHL_VWP_RULES_PVT.Tech_Dependency');
1189: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'MR_Serial_Tbl(0).MR_ID -->'|| MR_Serial_Tbl(0).MR_ID);
1190: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'MR_Serial_Tbl(0).Serial_ID'|| MR_Serial_Tbl(0).Serial_ID);
1191: END IF;
1192:
1193: AHL_VWP_RULES_PVT.Tech_Dependency

Line 1190: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'MR_Serial_Tbl(0).Serial_ID'|| MR_Serial_Tbl(0).Serial_ID);

1186: MR_Serial_Tbl(0).Serial_ID := l_serial_id;
1187: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1188: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Calling AHL_VWP_RULES_PVT.Tech_Dependency');
1189: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'MR_Serial_Tbl(0).MR_ID -->'|| MR_Serial_Tbl(0).MR_ID);
1190: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'MR_Serial_Tbl(0).Serial_ID'|| MR_Serial_Tbl(0).Serial_ID);
1191: END IF;
1192:
1193: AHL_VWP_RULES_PVT.Tech_Dependency
1194: (p_visit_id => p_visit_id,

Line 1200: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1196: p_MR_Serial_Tbl => MR_Serial_Tbl,
1197: x_return_status => l_return_status
1198: );
1199:
1200: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1201: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'After AHL_VWP_RULES_PVT.Tech_Dependency - l_return_status : '||l_return_status);
1202: END IF;
1203:
1204: IF NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN

Line 1201: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'After AHL_VWP_RULES_PVT.Tech_Dependency - l_return_status : '||l_return_status);

1197: x_return_status => l_return_status
1198: );
1199:
1200: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1201: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'After AHL_VWP_RULES_PVT.Tech_Dependency - l_return_status : '||l_return_status);
1202: END IF;
1203:
1204: IF NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
1205: RAISE Fnd_Api.G_EXC_ERROR;

Line 1241: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1237: END IF;
1238: -- End changes by rnahata for Issue 105
1239:
1240: -- Call create_mr_tasks recursively for the next level of UEs
1241: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1242: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Before calling create_mr_tasks');
1243: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'ue id =>' || c_relation_rec.related_ue_id);
1244: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'parent ue id =>' || l_parent_MR_Id);
1245: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'visit id =>' || p_visit_id);

Line 1242: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Before calling create_mr_tasks');

1238: -- End changes by rnahata for Issue 105
1239:
1240: -- Call create_mr_tasks recursively for the next level of UEs
1241: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1242: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Before calling create_mr_tasks');
1243: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'ue id =>' || c_relation_rec.related_ue_id);
1244: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'parent ue id =>' || l_parent_MR_Id);
1245: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'visit id =>' || p_visit_id);
1246: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'department id =>' || l_department_id);

Line 1243: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'ue id =>' || c_relation_rec.related_ue_id);

1239:
1240: -- Call create_mr_tasks recursively for the next level of UEs
1241: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1242: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Before calling create_mr_tasks');
1243: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'ue id =>' || c_relation_rec.related_ue_id);
1244: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'parent ue id =>' || l_parent_MR_Id);
1245: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'visit id =>' || p_visit_id);
1246: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'department id =>' || l_department_id);
1247: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'service request id =>' || l_service_request_id);

Line 1244: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'parent ue id =>' || l_parent_MR_Id);

1240: -- Call create_mr_tasks recursively for the next level of UEs
1241: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1242: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Before calling create_mr_tasks');
1243: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'ue id =>' || c_relation_rec.related_ue_id);
1244: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'parent ue id =>' || l_parent_MR_Id);
1245: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'visit id =>' || p_visit_id);
1246: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'department id =>' || l_department_id);
1247: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'service request id =>' || l_service_request_id);
1248: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'quantity =>' || l_instance_qty);

Line 1245: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'visit id =>' || p_visit_id);

1241: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1242: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Before calling create_mr_tasks');
1243: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'ue id =>' || c_relation_rec.related_ue_id);
1244: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'parent ue id =>' || l_parent_MR_Id);
1245: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'visit id =>' || p_visit_id);
1246: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'department id =>' || l_department_id);
1247: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'service request id =>' || l_service_request_id);
1248: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'quantity =>' || l_instance_qty);
1249: END IF;

Line 1246: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'department id =>' || l_department_id);

1242: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Before calling create_mr_tasks');
1243: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'ue id =>' || c_relation_rec.related_ue_id);
1244: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'parent ue id =>' || l_parent_MR_Id);
1245: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'visit id =>' || p_visit_id);
1246: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'department id =>' || l_department_id);
1247: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'service request id =>' || l_service_request_id);
1248: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'quantity =>' || l_instance_qty);
1249: END IF;
1250:

Line 1247: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'service request id =>' || l_service_request_id);

1243: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'ue id =>' || c_relation_rec.related_ue_id);
1244: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'parent ue id =>' || l_parent_MR_Id);
1245: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'visit id =>' || p_visit_id);
1246: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'department id =>' || l_department_id);
1247: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'service request id =>' || l_service_request_id);
1248: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'quantity =>' || l_instance_qty);
1249: END IF;
1250:
1251: create_mr_tasks(p_ue_id => c_relation_rec.related_ue_id,

Line 1248: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'quantity =>' || l_instance_qty);

1244: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'parent ue id =>' || l_parent_MR_Id);
1245: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'visit id =>' || p_visit_id);
1246: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'department id =>' || l_department_id);
1247: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'service request id =>' || l_service_request_id);
1248: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'quantity =>' || l_instance_qty);
1249: END IF;
1250:
1251: create_mr_tasks(p_ue_id => c_relation_rec.related_ue_id,
1252: p_parent_ue_id => l_parent_MR_Id,

Line 1319: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

1315: --------------------- initialize -----------------------
1316: SAVEPOINT Update_Planned_Task;
1317:
1318: -- Debug info.
1319: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1320: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.begin','At the start of PLSQL procedure');
1321: END IF;
1322:
1323: IF Fnd_Api.to_boolean (p_init_msg_list) THEN

Line 1320: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.begin','At the start of PLSQL procedure');

1316: SAVEPOINT Update_Planned_Task;
1317:
1318: -- Debug info.
1319: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1320: fnd_log.string(fnd_log.level_procedure,L_DEBUG||'.begin','At the start of PLSQL procedure');
1321: END IF;
1322:
1323: IF Fnd_Api.to_boolean (p_init_msg_list) THEN
1324: Fnd_Msg_Pub.initialize;

Line 1350: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1346: OPEN c_Task(l_Task_rec.visit_task_id);
1347: FETCH c_Task INTO c_Task_rec;
1348: CLOSE c_Task;
1349:
1350: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1351: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Visit Id/Task Id = ' || l_task_rec.visit_id || '-' || l_task_rec.visit_task_id);
1352: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Inventory Id /org/name =' || l_task_rec.inventory_item_id || '-' || l_task_rec.item_organization_id || '-' || l_task_rec.item_name);
1353: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Cost Id -- Number=' || l_task_rec.cost_parent_id || '**' || l_task_rec.cost_parent_number );
1354: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Originating Id/Number=' || l_task_rec.originating_task_id || '**' || l_task_rec.orginating_task_number);

Line 1351: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Visit Id/Task Id = ' || l_task_rec.visit_id || '-' || l_task_rec.visit_task_id);

1347: FETCH c_Task INTO c_Task_rec;
1348: CLOSE c_Task;
1349:
1350: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1351: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Visit Id/Task Id = ' || l_task_rec.visit_id || '-' || l_task_rec.visit_task_id);
1352: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Inventory Id /org/name =' || l_task_rec.inventory_item_id || '-' || l_task_rec.item_organization_id || '-' || l_task_rec.item_name);
1353: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Cost Id -- Number=' || l_task_rec.cost_parent_id || '**' || l_task_rec.cost_parent_number );
1354: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Originating Id/Number=' || l_task_rec.originating_task_id || '**' || l_task_rec.orginating_task_number);
1355: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Object version number = ' || l_task_rec.object_version_number);

Line 1352: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Inventory Id /org/name =' || l_task_rec.inventory_item_id || '-' || l_task_rec.item_organization_id || '-' || l_task_rec.item_name);

1348: CLOSE c_Task;
1349:
1350: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1351: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Visit Id/Task Id = ' || l_task_rec.visit_id || '-' || l_task_rec.visit_task_id);
1352: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Inventory Id /org/name =' || l_task_rec.inventory_item_id || '-' || l_task_rec.item_organization_id || '-' || l_task_rec.item_name);
1353: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Cost Id -- Number=' || l_task_rec.cost_parent_id || '**' || l_task_rec.cost_parent_number );
1354: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Originating Id/Number=' || l_task_rec.originating_task_id || '**' || l_task_rec.orginating_task_number);
1355: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Object version number = ' || l_task_rec.object_version_number);
1356: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Duration from record = ' || l_task_rec.duration);

Line 1353: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Cost Id -- Number=' || l_task_rec.cost_parent_id || '**' || l_task_rec.cost_parent_number );

1349:
1350: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1351: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Visit Id/Task Id = ' || l_task_rec.visit_id || '-' || l_task_rec.visit_task_id);
1352: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Inventory Id /org/name =' || l_task_rec.inventory_item_id || '-' || l_task_rec.item_organization_id || '-' || l_task_rec.item_name);
1353: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Cost Id -- Number=' || l_task_rec.cost_parent_id || '**' || l_task_rec.cost_parent_number );
1354: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Originating Id/Number=' || l_task_rec.originating_task_id || '**' || l_task_rec.orginating_task_number);
1355: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Object version number = ' || l_task_rec.object_version_number);
1356: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Duration from record = ' || l_task_rec.duration);
1357: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Visit start from hour/duration=' || '-' || l_task_rec.start_from_hour || '-' || l_task_rec.duration);

Line 1354: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Originating Id/Number=' || l_task_rec.originating_task_id || '**' || l_task_rec.orginating_task_number);

1350: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1351: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Visit Id/Task Id = ' || l_task_rec.visit_id || '-' || l_task_rec.visit_task_id);
1352: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Inventory Id /org/name =' || l_task_rec.inventory_item_id || '-' || l_task_rec.item_organization_id || '-' || l_task_rec.item_name);
1353: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Cost Id -- Number=' || l_task_rec.cost_parent_id || '**' || l_task_rec.cost_parent_number );
1354: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Originating Id/Number=' || l_task_rec.originating_task_id || '**' || l_task_rec.orginating_task_number);
1355: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Object version number = ' || l_task_rec.object_version_number);
1356: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Duration from record = ' || l_task_rec.duration);
1357: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Visit start from hour/duration=' || '-' || l_task_rec.start_from_hour || '-' || l_task_rec.duration);
1358: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Task Type code/value=' || l_task_rec.task_type_code || '-' || l_task_rec.task_type_value );

Line 1355: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Object version number = ' || l_task_rec.object_version_number);

1351: fnd_log.string(fnd_log.level_statement,L_DEBUG, 'Visit Id/Task Id = ' || l_task_rec.visit_id || '-' || l_task_rec.visit_task_id);
1352: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Inventory Id /org/name =' || l_task_rec.inventory_item_id || '-' || l_task_rec.item_organization_id || '-' || l_task_rec.item_name);
1353: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Cost Id -- Number=' || l_task_rec.cost_parent_id || '**' || l_task_rec.cost_parent_number );
1354: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Originating Id/Number=' || l_task_rec.originating_task_id || '**' || l_task_rec.orginating_task_number);
1355: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Object version number = ' || l_task_rec.object_version_number);
1356: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Duration from record = ' || l_task_rec.duration);
1357: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Visit start from hour/duration=' || '-' || l_task_rec.start_from_hour || '-' || l_task_rec.duration);
1358: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Task Type code/value=' || l_task_rec.task_type_code || '-' || l_task_rec.task_type_value );
1359: fnd_log.string(fnd_log.level_statement,L_DEBUG,'department_id = ' || l_task_rec.department_id );

Line 1356: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Duration from record = ' || l_task_rec.duration);

1352: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Inventory Id /org/name =' || l_task_rec.inventory_item_id || '-' || l_task_rec.item_organization_id || '-' || l_task_rec.item_name);
1353: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Cost Id -- Number=' || l_task_rec.cost_parent_id || '**' || l_task_rec.cost_parent_number );
1354: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Originating Id/Number=' || l_task_rec.originating_task_id || '**' || l_task_rec.orginating_task_number);
1355: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Object version number = ' || l_task_rec.object_version_number);
1356: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Duration from record = ' || l_task_rec.duration);
1357: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Visit start from hour/duration=' || '-' || l_task_rec.start_from_hour || '-' || l_task_rec.duration);
1358: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Task Type code/value=' || l_task_rec.task_type_code || '-' || l_task_rec.task_type_value );
1359: fnd_log.string(fnd_log.level_statement,L_DEBUG,'department_id = ' || l_task_rec.department_id );
1360: END IF;

Line 1357: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Visit start from hour/duration=' || '-' || l_task_rec.start_from_hour || '-' || l_task_rec.duration);

1353: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Cost Id -- Number=' || l_task_rec.cost_parent_id || '**' || l_task_rec.cost_parent_number );
1354: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Originating Id/Number=' || l_task_rec.originating_task_id || '**' || l_task_rec.orginating_task_number);
1355: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Object version number = ' || l_task_rec.object_version_number);
1356: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Duration from record = ' || l_task_rec.duration);
1357: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Visit start from hour/duration=' || '-' || l_task_rec.start_from_hour || '-' || l_task_rec.duration);
1358: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Task Type code/value=' || l_task_rec.task_type_code || '-' || l_task_rec.task_type_value );
1359: fnd_log.string(fnd_log.level_statement,L_DEBUG,'department_id = ' || l_task_rec.department_id );
1360: END IF;
1361:

Line 1358: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Task Type code/value=' || l_task_rec.task_type_code || '-' || l_task_rec.task_type_value );

1354: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Originating Id/Number=' || l_task_rec.originating_task_id || '**' || l_task_rec.orginating_task_number);
1355: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Object version number = ' || l_task_rec.object_version_number);
1356: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Duration from record = ' || l_task_rec.duration);
1357: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Visit start from hour/duration=' || '-' || l_task_rec.start_from_hour || '-' || l_task_rec.duration);
1358: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Task Type code/value=' || l_task_rec.task_type_code || '-' || l_task_rec.task_type_value );
1359: fnd_log.string(fnd_log.level_statement,L_DEBUG,'department_id = ' || l_task_rec.department_id );
1360: END IF;
1361:
1362: ----------- Start defining and validate all LOVs on Create Visit's Task UI Screen---

Line 1359: fnd_log.string(fnd_log.level_statement,L_DEBUG,'department_id = ' || l_task_rec.department_id );

1355: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Object version number = ' || l_task_rec.object_version_number);
1356: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Duration from record = ' || l_task_rec.duration);
1357: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Visit start from hour/duration=' || '-' || l_task_rec.start_from_hour || '-' || l_task_rec.duration);
1358: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Task Type code/value=' || l_task_rec.task_type_code || '-' || l_task_rec.task_type_value );
1359: fnd_log.string(fnd_log.level_statement,L_DEBUG,'department_id = ' || l_task_rec.department_id );
1360: END IF;
1361:
1362: ----------- Start defining and validate all LOVs on Create Visit's Task UI Screen---
1363: --

Line 1387: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1383: --Assign the returned value
1384: l_task_rec.department_id := l_department_id;
1385: END IF;
1386:
1387: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1388: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Dept ID= ' || l_Task_rec.department_id );
1389: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Cost parent= ' || l_Task_rec.cost_parent_number);
1390: END IF;
1391:

Line 1388: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Dept ID= ' || l_Task_rec.department_id );

1384: l_task_rec.department_id := l_department_id;
1385: END IF;
1386:
1387: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1388: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Dept ID= ' || l_Task_rec.department_id );
1389: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Cost parent= ' || l_Task_rec.cost_parent_number);
1390: END IF;
1391:
1392: --

Line 1389: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Cost parent= ' || l_Task_rec.cost_parent_number);

1385: END IF;
1386:
1387: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1388: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Dept ID= ' || l_Task_rec.department_id );
1389: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Cost parent= ' || l_Task_rec.cost_parent_number);
1390: END IF;
1391:
1392: --
1393: -- For COST PARENT TASK

Line 1417: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1413: --Assign the returned value
1414: l_Task_rec.cost_parent_id := l_cost_parent_id;
1415: END IF;
1416:
1417: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1418: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Cost parent ID = ' || l_Task_rec.cost_parent_id);
1419: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Validation: Start -- For COST PARENT ');
1420: END IF;
1421:

Line 1418: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Cost parent ID = ' || l_Task_rec.cost_parent_id);

1414: l_Task_rec.cost_parent_id := l_cost_parent_id;
1415: END IF;
1416:
1417: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1418: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Cost parent ID = ' || l_Task_rec.cost_parent_id);
1419: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Validation: Start -- For COST PARENT ');
1420: END IF;
1421:
1422: -- To Check for cost parent task id not forming loop

Line 1419: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Validation: Start -- For COST PARENT ');

1415: END IF;
1416:
1417: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1418: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Cost parent ID = ' || l_Task_rec.cost_parent_id);
1419: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Validation: Start -- For COST PARENT ');
1420: END IF;
1421:
1422: -- To Check for cost parent task id not forming loop
1423: IF (l_Task_rec.cost_parent_id IS NOT NULL AND

Line 1434: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1430: );
1431:
1432: END IF;
1433:
1434: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1435: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Validation: End -- For COST PARENT ');
1436: END IF;
1437:
1438: ----------- End defining and validate all LOVs on Create Visit's Task UI Screen---

Line 1435: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Validation: End -- For COST PARENT ');

1431:
1432: END IF;
1433:
1434: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1435: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Validation: End -- For COST PARENT ');
1436: END IF;
1437:
1438: ----------- End defining and validate all LOVs on Create Visit's Task UI Screen---
1439:

Line 1442: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1438: ----------- End defining and validate all LOVs on Create Visit's Task UI Screen---
1439:
1440: ----------------------- validate ----------------------
1441:
1442: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1443: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Validate');
1444: END IF;
1445:
1446: -- For all optional fields check if its g_miss_num/g_miss_char/g_miss_date

Line 1443: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Validate');

1439:
1440: ----------------------- validate ----------------------
1441:
1442: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1443: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Validate');
1444: END IF;
1445:
1446: -- For all optional fields check if its g_miss_num/g_miss_char/g_miss_date
1447: -- then Null else the value call Default_Missing_Attribs procedure

Line 1499: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1495: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
1496: END IF;
1497:
1498: -------------------------- update --------------------
1499: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1500: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Update');
1501: END IF;
1502:
1503: --Modified by mpothuku to fix LTP forum issue #208 on 04/19/05

Line 1500: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Update');

1496: END IF;
1497:
1498: -------------------------- update --------------------
1499: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1500: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Update');
1501: END IF;
1502:
1503: --Modified by mpothuku to fix LTP forum issue #208 on 04/19/05
1504: IF( nvl(p_module_type,'XXX') <> 'LTP') THEN

Line 1565: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1561: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID );
1562:
1563: -- Added cxcheng POST11510--------------
1564: --Now adjust the times derivation for task
1565: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1566: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_VWP_TIMES_PVT.Adjust_Task_Times');
1567: END IF;
1568:
1569: AHL_VWP_TIMES_PVT.Adjust_Task_Times(p_api_version => 1.0,

Line 1566: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_VWP_TIMES_PVT.Adjust_Task_Times');

1562:
1563: -- Added cxcheng POST11510--------------
1564: --Now adjust the times derivation for task
1565: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1566: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_VWP_TIMES_PVT.Adjust_Task_Times');
1567: END IF;
1568:
1569: AHL_VWP_TIMES_PVT.Adjust_Task_Times(p_api_version => 1.0,
1570: p_init_msg_list => Fnd_Api.G_FALSE,

Line 1578: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1574: x_msg_count => l_msg_count,
1575: x_msg_data => l_msg_data,
1576: p_task_id => l_task_rec.visit_task_id);
1577:
1578: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1579: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling AHL_VWP_TIMES_PVT.Adjust_Task_Times - l_return_status : '||l_return_status);
1580: END IF;
1581:
1582: --Standard check to count messages

Line 1579: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling AHL_VWP_TIMES_PVT.Adjust_Task_Times - l_return_status : '||l_return_status);

1575: x_msg_data => l_msg_data,
1576: p_task_id => l_task_rec.visit_task_id);
1577:
1578: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1579: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling AHL_VWP_TIMES_PVT.Adjust_Task_Times - l_return_status : '||l_return_status);
1580: END IF;
1581:
1582: --Standard check to count messages
1583: l_msg_count := Fnd_Msg_Pub.count_msg;

Line 1605: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1601: FETCH c_Task INTO c_upd_Task_rec;
1602: CLOSE c_Task;
1603:
1604: IF c_upd_Task_rec.start_date_time IS NOT NULL THEN
1605: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1606: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials');
1607: END IF;
1608:
1609: AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials (

Line 1606: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials');

1602: CLOSE c_Task;
1603:
1604: IF c_upd_Task_rec.start_date_time IS NOT NULL THEN
1605: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1606: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials');
1607: END IF;
1608:
1609: AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials (
1610: p_api_version => 1.0,

Line 1624: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1620: x_return_status => l_return_status,
1621: x_msg_count => l_msg_count,
1622: x_msg_data => l_msg_data );
1623:
1624: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1625: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials - l_return_status : '||l_return_status);
1626: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Planned Order Flag : ' || l_planned_order_flag);
1627: END IF;
1628:

Line 1625: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials - l_return_status : '||l_return_status);

1621: x_msg_count => l_msg_count,
1622: x_msg_data => l_msg_data );
1623:
1624: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1625: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials - l_return_status : '||l_return_status);
1626: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Planned Order Flag : ' || l_planned_order_flag);
1627: END IF;
1628:
1629: IF l_return_status <> 'S' THEN

Line 1626: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Planned Order Flag : ' || l_planned_order_flag);

1622: x_msg_data => l_msg_data );
1623:
1624: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1625: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials - l_return_status : '||l_return_status);
1626: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Planned Order Flag : ' || l_planned_order_flag);
1627: END IF;
1628:
1629: IF l_return_status <> 'S' THEN
1630: RAISE Fnd_Api.G_EXC_ERROR;

Line 1656: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

1652: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
1653: COMMIT;
1654: END IF;
1655:
1656: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1657: fnd_log.string(fnd_log.level_procedure,L_DEBUG ||'.end','At the end of PLSQL procedure');
1658: END IF;
1659:
1660: EXCEPTION

Line 1657: fnd_log.string(fnd_log.level_procedure,L_DEBUG ||'.end','At the end of PLSQL procedure');

1653: COMMIT;
1654: END IF;
1655:
1656: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1657: fnd_log.string(fnd_log.level_procedure,L_DEBUG ||'.end','At the end of PLSQL procedure');
1658: END IF;
1659:
1660: EXCEPTION
1661: WHEN Fnd_Api.g_exc_error THEN

Line 1728: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

1724: BEGIN
1725: --------------------- initialize -----------------------
1726: SAVEPOINT Delete_Planned_Task;
1727: -- Check if API is called in debug mode. If yes, enable debug.
1728: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1729: fnd_log.string(fnd_log.level_procedure,l_debug||'.begin','At the start of PLSQL procedure');
1730: END IF;
1731:
1732: IF Fnd_Api.to_boolean (p_init_msg_list) THEN

Line 1729: fnd_log.string(fnd_log.level_procedure,l_debug||'.begin','At the start of PLSQL procedure');

1725: --------------------- initialize -----------------------
1726: SAVEPOINT Delete_Planned_Task;
1727: -- Check if API is called in debug mode. If yes, enable debug.
1728: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1729: fnd_log.string(fnd_log.level_procedure,l_debug||'.begin','At the start of PLSQL procedure');
1730: END IF;
1731:
1732: IF Fnd_Api.to_boolean (p_init_msg_list) THEN
1733: Fnd_Msg_Pub.initialize;

Line 1750: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1746: RAISE Fnd_Api.g_exc_unexpected_error;
1747: END IF;
1748:
1749: ------------------------Start of API Body------------------------------------
1750: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1751: fnd_log.string(fnd_log.level_statement,l_debug,'Task Id' || p_visit_task_ID);
1752: END IF;
1753:
1754: -- To check if the input taskid exists in task entity.

Line 1751: fnd_log.string(fnd_log.level_statement,l_debug,'Task Id' || p_visit_task_ID);

1747: END IF;
1748:
1749: ------------------------Start of API Body------------------------------------
1750: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1751: fnd_log.string(fnd_log.level_statement,l_debug,'Task Id' || p_visit_task_ID);
1752: END IF;
1753:
1754: -- To check if the input taskid exists in task entity.
1755: OPEN c_Task(p_Visit_Task_ID);

Line 1763: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1759: CLOSE c_Task;
1760: Fnd_Message.set_name('AHL', 'AHL_VWP_TASK_ID_INVALID');
1761: FND_MESSAGE.SET_TOKEN('TASK_ID',p_visit_task_id,false);
1762: Fnd_Msg_Pub.ADD;
1763: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1764: fnd_log.string(fnd_log.level_statement,l_debug,'Invalid Task Id' || p_visit_task_ID);
1765: END IF;
1766: RAISE Fnd_Api.g_exc_error;
1767: ELSE

Line 1764: fnd_log.string(fnd_log.level_statement,l_debug,'Invalid Task Id' || p_visit_task_ID);

1760: Fnd_Message.set_name('AHL', 'AHL_VWP_TASK_ID_INVALID');
1761: FND_MESSAGE.SET_TOKEN('TASK_ID',p_visit_task_id,false);
1762: Fnd_Msg_Pub.ADD;
1763: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1764: fnd_log.string(fnd_log.level_statement,l_debug,'Invalid Task Id' || p_visit_task_ID);
1765: END IF;
1766: RAISE Fnd_Api.g_exc_error;
1767: ELSE
1768: CLOSE c_Task;

Line 1773: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1769: -- To find the visit related information
1770: l_origin_id:= c_task_rec.originating_task_id;
1771:
1772: If l_origin_id is Not Null then
1773: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1774: fnd_log.string(fnd_log.level_statement,l_debug,'Before calling AHL_VWP_TASKS_PVT.Delete_Summary_Task');
1775: END IF;
1776:
1777: AHL_VWP_TASKS_PVT.Delete_Summary_Task(

Line 1774: fnd_log.string(fnd_log.level_statement,l_debug,'Before calling AHL_VWP_TASKS_PVT.Delete_Summary_Task');

1770: l_origin_id:= c_task_rec.originating_task_id;
1771:
1772: If l_origin_id is Not Null then
1773: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1774: fnd_log.string(fnd_log.level_statement,l_debug,'Before calling AHL_VWP_TASKS_PVT.Delete_Summary_Task');
1775: END IF;
1776:
1777: AHL_VWP_TASKS_PVT.Delete_Summary_Task(
1778: p_api_version => p_api_version,

Line 1788: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1784: x_return_status => x_return_status,
1785: x_msg_count => x_msg_count,
1786: x_msg_data => x_msg_data);
1787:
1788: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1789: fnd_log.string(fnd_log.level_statement,l_debug,'After calling AHL_VWP_TASKS_PVT.Delete_Summary_Task : x_return_status - '||x_return_status);
1790: END IF;
1791:
1792: IF x_return_status <> Fnd_Api.g_ret_sts_success THEN

Line 1789: fnd_log.string(fnd_log.level_statement,l_debug,'After calling AHL_VWP_TASKS_PVT.Delete_Summary_Task : x_return_status - '||x_return_status);

1785: x_msg_count => x_msg_count,
1786: x_msg_data => x_msg_data);
1787:
1788: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1789: fnd_log.string(fnd_log.level_statement,l_debug,'After calling AHL_VWP_TASKS_PVT.Delete_Summary_Task : x_return_status - '||x_return_status);
1790: END IF;
1791:
1792: IF x_return_status <> Fnd_Api.g_ret_sts_success THEN
1793: RAISE Fnd_Api.G_EXC_ERROR;

Line 1812: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

1808: p_count => x_msg_count,
1809: p_data => x_msg_data
1810: );
1811:
1812: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1813: fnd_log.string(fnd_log.level_procedure,l_debug ||'.end','At the end of PLSQL procedure');
1814: END IF;
1815: EXCEPTION
1816: WHEN Fnd_Api.g_exc_error THEN

Line 1813: fnd_log.string(fnd_log.level_procedure,l_debug ||'.end','At the end of PLSQL procedure');

1809: p_data => x_msg_data
1810: );
1811:
1812: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1813: fnd_log.string(fnd_log.level_procedure,l_debug ||'.end','At the end of PLSQL procedure');
1814: END IF;
1815: EXCEPTION
1816: WHEN Fnd_Api.g_exc_error THEN
1817: ROLLBACK TO Delete_Planned_Task;

Line 1872: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

1868: --
1869: -- Validate required items.
1870: x_return_status := FND_API.G_RET_STS_SUCCESS;
1871:
1872: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1873: fnd_log.string(fnd_log.level_procedure,l_debug||'.begin', 'At the start of the procedure..');
1874: fnd_log.string(fnd_log.level_procedure,l_debug, 'Before Check_Visit_Task_Req_Items');
1875: END IF;
1876:

Line 1873: fnd_log.string(fnd_log.level_procedure,l_debug||'.begin', 'At the start of the procedure..');

1869: -- Validate required items.
1870: x_return_status := FND_API.G_RET_STS_SUCCESS;
1871:
1872: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1873: fnd_log.string(fnd_log.level_procedure,l_debug||'.begin', 'At the start of the procedure..');
1874: fnd_log.string(fnd_log.level_procedure,l_debug, 'Before Check_Visit_Task_Req_Items');
1875: END IF;
1876:
1877: Check_Visit_Task_Req_Items (

Line 1874: fnd_log.string(fnd_log.level_procedure,l_debug, 'Before Check_Visit_Task_Req_Items');

1870: x_return_status := FND_API.G_RET_STS_SUCCESS;
1871:
1872: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1873: fnd_log.string(fnd_log.level_procedure,l_debug||'.begin', 'At the start of the procedure..');
1874: fnd_log.string(fnd_log.level_procedure,l_debug, 'Before Check_Visit_Task_Req_Items');
1875: END IF;
1876:
1877: Check_Visit_Task_Req_Items (
1878: p_task_rec => p_task_rec,

Line 1885: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1881: IF x_return_status <> Fnd_Api.g_ret_sts_success THEN
1882: RETURN;
1883: END IF;
1884:
1885: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1886: fnd_log.string(fnd_log.level_statement,l_debug,'After Check_Visit_Task_Req_Items');
1887: END IF;
1888:
1889: -- Validate uniqueness.

Line 1886: fnd_log.string(fnd_log.level_statement,l_debug,'After Check_Visit_Task_Req_Items');

1882: RETURN;
1883: END IF;
1884:
1885: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1886: fnd_log.string(fnd_log.level_statement,l_debug,'After Check_Visit_Task_Req_Items');
1887: END IF;
1888:
1889: -- Validate uniqueness.
1890: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 1890: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1886: fnd_log.string(fnd_log.level_statement,l_debug,'After Check_Visit_Task_Req_Items');
1887: END IF;
1888:
1889: -- Validate uniqueness.
1890: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1891: fnd_log.string(fnd_log.level_statement,l_debug,'Before Check_Visit_Task_UK_Items');
1892: END IF;
1893:
1894: Check_Visit_Task_UK_Items (

Line 1891: fnd_log.string(fnd_log.level_statement,l_debug,'Before Check_Visit_Task_UK_Items');

1887: END IF;
1888:
1889: -- Validate uniqueness.
1890: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1891: fnd_log.string(fnd_log.level_statement,l_debug,'Before Check_Visit_Task_UK_Items');
1892: END IF;
1893:
1894: Check_Visit_Task_UK_Items (
1895: p_task_rec => p_task_rec,

Line 1903: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

1899: IF x_return_status <> Fnd_Api.g_ret_sts_success THEN
1900: RETURN;
1901: END IF;
1902:
1903: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1904: fnd_log.string(fnd_log.level_procedure,l_debug,'After Check_Visit_Task_UK_Items..');
1905: fnd_log.string(fnd_log.level_procedure,l_debug||'.end','At the end of the procedure');
1906: END IF;
1907: END Check_Task_Items;

Line 1904: fnd_log.string(fnd_log.level_procedure,l_debug,'After Check_Visit_Task_UK_Items..');

1900: RETURN;
1901: END IF;
1902:
1903: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1904: fnd_log.string(fnd_log.level_procedure,l_debug,'After Check_Visit_Task_UK_Items..');
1905: fnd_log.string(fnd_log.level_procedure,l_debug||'.end','At the end of the procedure');
1906: END IF;
1907: END Check_Task_Items;
1908:

Line 1905: fnd_log.string(fnd_log.level_procedure,l_debug||'.end','At the end of the procedure');

1901: END IF;
1902:
1903: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1904: fnd_log.string(fnd_log.level_procedure,l_debug,'After Check_Visit_Task_UK_Items..');
1905: fnd_log.string(fnd_log.level_procedure,l_debug||'.end','At the end of the procedure');
1906: END IF;
1907: END Check_Task_Items;
1908:
1909: ---------------------------------------------------------------------

Line 1967: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

1963: BEGIN
1964:
1965: x_return_status := FND_API.G_RET_STS_SUCCESS;
1966:
1967: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1968: fnd_log.string(fnd_log.level_procedure,l_debug,'At the Start of Check_Visit_Task_Req_Items ');
1969: END IF;
1970:
1971: -- TASK NAME ==== NAME

Line 1968: fnd_log.string(fnd_log.level_procedure,l_debug,'At the Start of Check_Visit_Task_Req_Items ');

1964:
1965: x_return_status := FND_API.G_RET_STS_SUCCESS;
1966:
1967: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1968: fnd_log.string(fnd_log.level_procedure,l_debug,'At the Start of Check_Visit_Task_Req_Items ');
1969: END IF;
1970:
1971: -- TASK NAME ==== NAME
1972: IF (p_task_rec.VISIT_TASK_NAME IS NULL OR p_Task_rec.VISIT_TASK_NAME = Fnd_Api.G_MISS_CHAR) THEN

Line 1979: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1975: x_return_status := Fnd_Api.g_ret_sts_error;
1976: RETURN;
1977: END IF;
1978:
1979: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1980: fnd_log.string(fnd_log.level_statement,l_debug,'Inside Validation Start from Hour = ' || p_task_rec.START_FROM_HOUR);
1981: END IF;
1982:
1983: IF (p_task_rec.START_FROM_HOUR IS NOT NULL and p_Task_rec.START_FROM_HOUR <> Fnd_Api.G_MISS_NUM) THEN

Line 1980: fnd_log.string(fnd_log.level_statement,l_debug,'Inside Validation Start from Hour = ' || p_task_rec.START_FROM_HOUR);

1976: RETURN;
1977: END IF;
1978:
1979: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1980: fnd_log.string(fnd_log.level_statement,l_debug,'Inside Validation Start from Hour = ' || p_task_rec.START_FROM_HOUR);
1981: END IF;
1982:
1983: IF (p_task_rec.START_FROM_HOUR IS NOT NULL and p_Task_rec.START_FROM_HOUR <> Fnd_Api.G_MISS_NUM) THEN
1984: IF p_task_rec.START_FROM_HOUR < 0 OR FLOOR(p_task_rec.START_FROM_HOUR) <> p_task_rec.START_FROM_HOUR THEN

Line 2014: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

2010: l_debug CONSTANT VARCHAR2(90) := 'ahl.plsql.'||L_FULL_NAME;
2011:
2012: BEGIN
2013: x_return_status := Fnd_Api.g_ret_sts_success;
2014: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2015: fnd_log.string(fnd_log.level_procedure,l_debug,'At the Start of Check_Visit_Task_UK_Items ');
2016: END IF;
2017: --
2018: -- For Task, when ID is passed in, we need to

Line 2015: fnd_log.string(fnd_log.level_procedure,l_debug,'At the Start of Check_Visit_Task_UK_Items ');

2011:
2012: BEGIN
2013: x_return_status := Fnd_Api.g_ret_sts_success;
2014: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2015: fnd_log.string(fnd_log.level_procedure,l_debug,'At the Start of Check_Visit_Task_UK_Items ');
2016: END IF;
2017: --
2018: -- For Task, when ID is passed in, we need to
2019: -- check if this ID is unique.

Line 2021: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2017: --
2018: -- For Task, when ID is passed in, we need to
2019: -- check if this ID is unique.
2020: IF p_validation_mode = Jtf_Plsql_Api.g_create AND p_task_rec.Visit_Task_ID IS NOT NULL THEN
2021: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2022: fnd_log.string(fnd_log.level_statement,'ahl.plsql.',': = Check_Visit_Task_UK_Items Uniqueness Of ID');
2023: END IF;
2024: -- FOR CREATION
2025: IF Ahl_Utility_Pvt.check_uniqueness(

Line 2022: fnd_log.string(fnd_log.level_statement,'ahl.plsql.',': = Check_Visit_Task_UK_Items Uniqueness Of ID');

2018: -- For Task, when ID is passed in, we need to
2019: -- check if this ID is unique.
2020: IF p_validation_mode = Jtf_Plsql_Api.g_create AND p_task_rec.Visit_Task_ID IS NOT NULL THEN
2021: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2022: fnd_log.string(fnd_log.level_statement,'ahl.plsql.',': = Check_Visit_Task_UK_Items Uniqueness Of ID');
2023: END IF;
2024: -- FOR CREATION
2025: IF Ahl_Utility_Pvt.check_uniqueness(
2026: 'Ahl_Visit_Tasks_vl',