DBA Data[Home] [Help]

APPS.AHL_PRD_NONROUTINE_PVT dependencies on FND_MESSAGE

Line 462: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_DEFAULT_STATUS_ERROR');

458: /*
459: OPEN cs_sr_status;
460: FETCH cs_sr_status INTO l_sr_status_id;
461: IF ( cs_sr_status%NOTFOUND) THEN
462: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_DEFAULT_STATUS_ERROR');
463: Fnd_Msg_Pub.ADD;
464: x_return_status := FND_API.G_RET_STS_ERROR;
465: END IF;
466: */

Line 688: Fnd_Message.SET_NAME('AHL','AHL_PRD_CUST_NAME_MISMATCH');

684: = p_x_sr_task_rec.customer_id;
685:
686: IF (l_customer_name <> nvl(p_x_sr_task_rec.customer_name,l_customer_name) and
687: (p_x_sr_task_rec.customer_name <> FND_API.G_MISS_CHAR) ) THEN
688: Fnd_Message.SET_NAME('AHL','AHL_PRD_CUST_NAME_MISMATCH');
689: Fnd_Message.SET_TOKEN('CUST_NAME',p_x_sr_task_rec.customer_name);
690: Fnd_Message.SET_TOKEN('CUST_ID',p_x_sr_task_rec.customer_id);
691: Fnd_Msg_Pub.ADD;
692: x_return_status := FND_API.G_RET_STS_ERROR;

Line 689: Fnd_Message.SET_TOKEN('CUST_NAME',p_x_sr_task_rec.customer_name);

685:
686: IF (l_customer_name <> nvl(p_x_sr_task_rec.customer_name,l_customer_name) and
687: (p_x_sr_task_rec.customer_name <> FND_API.G_MISS_CHAR) ) THEN
688: Fnd_Message.SET_NAME('AHL','AHL_PRD_CUST_NAME_MISMATCH');
689: Fnd_Message.SET_TOKEN('CUST_NAME',p_x_sr_task_rec.customer_name);
690: Fnd_Message.SET_TOKEN('CUST_ID',p_x_sr_task_rec.customer_id);
691: Fnd_Msg_Pub.ADD;
692: x_return_status := FND_API.G_RET_STS_ERROR;
693: END IF;

Line 690: Fnd_Message.SET_TOKEN('CUST_ID',p_x_sr_task_rec.customer_id);

686: IF (l_customer_name <> nvl(p_x_sr_task_rec.customer_name,l_customer_name) and
687: (p_x_sr_task_rec.customer_name <> FND_API.G_MISS_CHAR) ) THEN
688: Fnd_Message.SET_NAME('AHL','AHL_PRD_CUST_NAME_MISMATCH');
689: Fnd_Message.SET_TOKEN('CUST_NAME',p_x_sr_task_rec.customer_name);
690: Fnd_Message.SET_TOKEN('CUST_ID',p_x_sr_task_rec.customer_id);
691: Fnd_Msg_Pub.ADD;
692: x_return_status := FND_API.G_RET_STS_ERROR;
693: END IF;
694:

Line 697: Fnd_Message.SET_NAME('AHL','AHL_PRD_CUST_ID_INVALID');

693: END IF;
694:
695: EXCEPTION
696: WHEN NO_DATA_FOUND THEN
697: Fnd_Message.SET_NAME('AHL','AHL_PRD_CUST_ID_INVALID');
698: Fnd_Message.SET_TOKEN('CUST_ID',p_x_sr_task_rec.customer_id);
699: Fnd_Msg_Pub.ADD;
700: x_return_status := FND_API.G_RET_STS_ERROR;
701: WHEN TOO_MANY_ROWS THEN

Line 698: Fnd_Message.SET_TOKEN('CUST_ID',p_x_sr_task_rec.customer_id);

694:
695: EXCEPTION
696: WHEN NO_DATA_FOUND THEN
697: Fnd_Message.SET_NAME('AHL','AHL_PRD_CUST_ID_INVALID');
698: Fnd_Message.SET_TOKEN('CUST_ID',p_x_sr_task_rec.customer_id);
699: Fnd_Msg_Pub.ADD;
700: x_return_status := FND_API.G_RET_STS_ERROR;
701: WHEN TOO_MANY_ROWS THEN
702: Fnd_Message.SET_NAME('AHL','AHL_PRD_CUST_ID_NOT_UNIQUE');

Line 702: Fnd_Message.SET_NAME('AHL','AHL_PRD_CUST_ID_NOT_UNIQUE');

698: Fnd_Message.SET_TOKEN('CUST_ID',p_x_sr_task_rec.customer_id);
699: Fnd_Msg_Pub.ADD;
700: x_return_status := FND_API.G_RET_STS_ERROR;
701: WHEN TOO_MANY_ROWS THEN
702: Fnd_Message.SET_NAME('AHL','AHL_PRD_CUST_ID_NOT_UNIQUE');
703: Fnd_Message.SET_TOKEN('CUST_ID',p_x_sr_task_rec.customer_id);
704: Fnd_Msg_Pub.ADD;
705: x_return_status := FND_API.G_RET_STS_ERROR;
706: END;

Line 703: Fnd_Message.SET_TOKEN('CUST_ID',p_x_sr_task_rec.customer_id);

699: Fnd_Msg_Pub.ADD;
700: x_return_status := FND_API.G_RET_STS_ERROR;
701: WHEN TOO_MANY_ROWS THEN
702: Fnd_Message.SET_NAME('AHL','AHL_PRD_CUST_ID_NOT_UNIQUE');
703: Fnd_Message.SET_TOKEN('CUST_ID',p_x_sr_task_rec.customer_id);
704: Fnd_Msg_Pub.ADD;
705: x_return_status := FND_API.G_RET_STS_ERROR;
706: END;
707:

Line 724: Fnd_Message.SET_NAME('AHL','AHL_PRD_CUST_NAME_INVALID');

720: p_x_sr_task_rec.customer_id := l_customer_id;
721:
722: EXCEPTION
723: WHEN NO_DATA_FOUND THEN
724: Fnd_Message.SET_NAME('AHL','AHL_PRD_CUST_NAME_INVALID');
725: Fnd_Message.SET_TOKEN('CUST_NAME',p_x_sr_task_rec.customer_name);
726: Fnd_Msg_Pub.ADD;
727: x_return_status := FND_API.G_RET_STS_ERROR;
728: WHEN TOO_MANY_ROWS THEN

Line 725: Fnd_Message.SET_TOKEN('CUST_NAME',p_x_sr_task_rec.customer_name);

721:
722: EXCEPTION
723: WHEN NO_DATA_FOUND THEN
724: Fnd_Message.SET_NAME('AHL','AHL_PRD_CUST_NAME_INVALID');
725: Fnd_Message.SET_TOKEN('CUST_NAME',p_x_sr_task_rec.customer_name);
726: Fnd_Msg_Pub.ADD;
727: x_return_status := FND_API.G_RET_STS_ERROR;
728: WHEN TOO_MANY_ROWS THEN
729: Fnd_Message.SET_NAME('AHL','AHL_PRD_CUST_NAME_NOT_UNIQUE');

Line 729: Fnd_Message.SET_NAME('AHL','AHL_PRD_CUST_NAME_NOT_UNIQUE');

725: Fnd_Message.SET_TOKEN('CUST_NAME',p_x_sr_task_rec.customer_name);
726: Fnd_Msg_Pub.ADD;
727: x_return_status := FND_API.G_RET_STS_ERROR;
728: WHEN TOO_MANY_ROWS THEN
729: Fnd_Message.SET_NAME('AHL','AHL_PRD_CUST_NAME_NOT_UNIQUE');
730: Fnd_Message.SET_TOKEN('CUST_NAME',p_x_sr_task_rec.customer_name);
731: Fnd_Msg_Pub.ADD;
732: x_return_status := FND_API.G_RET_STS_ERROR;
733: END;

Line 730: Fnd_Message.SET_TOKEN('CUST_NAME',p_x_sr_task_rec.customer_name);

726: Fnd_Msg_Pub.ADD;
727: x_return_status := FND_API.G_RET_STS_ERROR;
728: WHEN TOO_MANY_ROWS THEN
729: Fnd_Message.SET_NAME('AHL','AHL_PRD_CUST_NAME_NOT_UNIQUE');
730: Fnd_Message.SET_TOKEN('CUST_NAME',p_x_sr_task_rec.customer_name);
731: Fnd_Msg_Pub.ADD;
732: x_return_status := FND_API.G_RET_STS_ERROR;
733: END;
734: -- NR MR ER - start

Line 771: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_MISMATCH');

767:
768:
769: IF(l_contact_name <> nvl(p_x_sr_task_rec.contact_name,l_contact_name) and
770: (p_x_sr_task_rec.contact_name <> FND_API.G_MISS_CHAR) )THEN
771: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_MISMATCH');
772: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);
773: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);
774: Fnd_Msg_Pub.ADD;
775: x_return_status := FND_API.G_RET_STS_ERROR;

Line 772: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);

768:
769: IF(l_contact_name <> nvl(p_x_sr_task_rec.contact_name,l_contact_name) and
770: (p_x_sr_task_rec.contact_name <> FND_API.G_MISS_CHAR) )THEN
771: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_MISMATCH');
772: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);
773: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);
774: Fnd_Msg_Pub.ADD;
775: x_return_status := FND_API.G_RET_STS_ERROR;
776: END IF;

Line 773: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);

769: IF(l_contact_name <> nvl(p_x_sr_task_rec.contact_name,l_contact_name) and
770: (p_x_sr_task_rec.contact_name <> FND_API.G_MISS_CHAR) )THEN
771: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_MISMATCH');
772: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);
773: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);
774: Fnd_Msg_Pub.ADD;
775: x_return_status := FND_API.G_RET_STS_ERROR;
776: END IF;
777:

Line 780: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_ID_INVALID');

776: END IF;
777:
778: EXCEPTION
779: WHEN NO_DATA_FOUND THEN
780: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_ID_INVALID');
781: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);
782: Fnd_Msg_Pub.ADD;
783: x_return_status := FND_API.G_RET_STS_ERROR;
784: WHEN TOO_MANY_ROWS THEN

Line 781: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);

777:
778: EXCEPTION
779: WHEN NO_DATA_FOUND THEN
780: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_ID_INVALID');
781: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);
782: Fnd_Msg_Pub.ADD;
783: x_return_status := FND_API.G_RET_STS_ERROR;
784: WHEN TOO_MANY_ROWS THEN
785: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_ID_NOT_UNIQUE');

Line 785: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_ID_NOT_UNIQUE');

781: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);
782: Fnd_Msg_Pub.ADD;
783: x_return_status := FND_API.G_RET_STS_ERROR;
784: WHEN TOO_MANY_ROWS THEN
785: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_ID_NOT_UNIQUE');
786: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);
787: Fnd_Msg_Pub.ADD;
788: x_return_status := FND_API.G_RET_STS_ERROR;
789: END;

Line 786: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);

782: Fnd_Msg_Pub.ADD;
783: x_return_status := FND_API.G_RET_STS_ERROR;
784: WHEN TOO_MANY_ROWS THEN
785: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_ID_NOT_UNIQUE');
786: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);
787: Fnd_Msg_Pub.ADD;
788: x_return_status := FND_API.G_RET_STS_ERROR;
789: END;
790:

Line 809: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_INVALID');

805:
806:
807: EXCEPTION
808: WHEN NO_DATA_FOUND THEN
809: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_INVALID');
810: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);
811: Fnd_Msg_Pub.ADD;
812: x_return_status := FND_API.G_RET_STS_ERROR;
813: WHEN TOO_MANY_ROWS THEN

Line 810: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);

806:
807: EXCEPTION
808: WHEN NO_DATA_FOUND THEN
809: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_INVALID');
810: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);
811: Fnd_Msg_Pub.ADD;
812: x_return_status := FND_API.G_RET_STS_ERROR;
813: WHEN TOO_MANY_ROWS THEN
814: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_NOT_UNIQUE');

Line 814: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_NOT_UNIQUE');

810: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);
811: Fnd_Msg_Pub.ADD;
812: x_return_status := FND_API.G_RET_STS_ERROR;
813: WHEN TOO_MANY_ROWS THEN
814: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_NOT_UNIQUE');
815: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);
816: Fnd_Msg_Pub.ADD;
817: x_return_status := FND_API.G_RET_STS_ERROR;
818: END;

Line 815: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);

811: Fnd_Msg_Pub.ADD;
812: x_return_status := FND_API.G_RET_STS_ERROR;
813: WHEN TOO_MANY_ROWS THEN
814: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_NOT_UNIQUE');
815: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);
816: Fnd_Msg_Pub.ADD;
817: x_return_status := FND_API.G_RET_STS_ERROR;
818: END;
819: -- NR MR ER -- start

Line 858: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_MISMATCH');

854:
855:
856: IF(l_contact_name <> nvl(p_x_sr_task_rec.contact_name,l_contact_name) and
857: (p_x_sr_task_rec.contact_name <> FND_API.G_MISS_CHAR) ) THEN
858: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_MISMATCH');
859: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);
860: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);
861: Fnd_Msg_Pub.ADD;
862: x_return_status := FND_API.G_RET_STS_ERROR;

Line 859: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);

855:
856: IF(l_contact_name <> nvl(p_x_sr_task_rec.contact_name,l_contact_name) and
857: (p_x_sr_task_rec.contact_name <> FND_API.G_MISS_CHAR) ) THEN
858: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_MISMATCH');
859: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);
860: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);
861: Fnd_Msg_Pub.ADD;
862: x_return_status := FND_API.G_RET_STS_ERROR;
863: END IF;

Line 860: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);

856: IF(l_contact_name <> nvl(p_x_sr_task_rec.contact_name,l_contact_name) and
857: (p_x_sr_task_rec.contact_name <> FND_API.G_MISS_CHAR) ) THEN
858: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_MISMATCH');
859: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);
860: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);
861: Fnd_Msg_Pub.ADD;
862: x_return_status := FND_API.G_RET_STS_ERROR;
863: END IF;
864:

Line 867: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_ID_INVALID');

863: END IF;
864:
865: EXCEPTION
866: WHEN NO_DATA_FOUND THEN
867: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_ID_INVALID');
868: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);
869: Fnd_Msg_Pub.ADD;
870: x_return_status := FND_API.G_RET_STS_ERROR;
871: WHEN TOO_MANY_ROWS THEN

Line 868: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);

864:
865: EXCEPTION
866: WHEN NO_DATA_FOUND THEN
867: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_ID_INVALID');
868: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);
869: Fnd_Msg_Pub.ADD;
870: x_return_status := FND_API.G_RET_STS_ERROR;
871: WHEN TOO_MANY_ROWS THEN
872: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_ID_NOT_UNIQUE');

Line 872: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_ID_NOT_UNIQUE');

868: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);
869: Fnd_Msg_Pub.ADD;
870: x_return_status := FND_API.G_RET_STS_ERROR;
871: WHEN TOO_MANY_ROWS THEN
872: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_ID_NOT_UNIQUE');
873: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);
874: Fnd_Msg_Pub.ADD;
875: x_return_status := FND_API.G_RET_STS_ERROR;
876: END;

Line 873: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);

869: Fnd_Msg_Pub.ADD;
870: x_return_status := FND_API.G_RET_STS_ERROR;
871: WHEN TOO_MANY_ROWS THEN
872: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_ID_NOT_UNIQUE');
873: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);
874: Fnd_Msg_Pub.ADD;
875: x_return_status := FND_API.G_RET_STS_ERROR;
876: END;
877:

Line 897: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_INVALID');

893: p_x_sr_task_rec.contact_id := l_contact_id;
894:
895: EXCEPTION
896: WHEN NO_DATA_FOUND THEN
897: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_INVALID');
898: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);
899: Fnd_Msg_Pub.ADD;
900: x_return_status := FND_API.G_RET_STS_ERROR;
901: WHEN TOO_MANY_ROWS THEN

Line 898: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);

894:
895: EXCEPTION
896: WHEN NO_DATA_FOUND THEN
897: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_INVALID');
898: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);
899: Fnd_Msg_Pub.ADD;
900: x_return_status := FND_API.G_RET_STS_ERROR;
901: WHEN TOO_MANY_ROWS THEN
902: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_NOT_UNIQUE');

Line 902: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_NOT_UNIQUE');

898: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);
899: Fnd_Msg_Pub.ADD;
900: x_return_status := FND_API.G_RET_STS_ERROR;
901: WHEN TOO_MANY_ROWS THEN
902: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_NOT_UNIQUE');
903: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);
904: Fnd_Msg_Pub.ADD;
905: x_return_status := FND_API.G_RET_STS_ERROR;
906: END;

Line 903: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);

899: Fnd_Msg_Pub.ADD;
900: x_return_status := FND_API.G_RET_STS_ERROR;
901: WHEN TOO_MANY_ROWS THEN
902: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_NOT_UNIQUE');
903: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);
904: Fnd_Msg_Pub.ADD;
905: x_return_status := FND_API.G_RET_STS_ERROR;
906: END;
907: -- NR MR ER -- start

Line 960: Fnd_Message.SET_NAME('AHL','AHL_PRD_PROBLEM_CODE_INVALID');

956: -- SR API doesnt throw any error if the problem code is invalid neither
957: -- it updates invalid value. Hence throwing error explicitly
958: -- Part of NR MR ER.
959: IF p_x_sr_task_rec.problem_code IS NULL THEN
960: Fnd_Message.SET_NAME('AHL','AHL_PRD_PROBLEM_CODE_INVALID');
961: Fnd_Message.SET_TOKEN('CODE',p_x_sr_task_rec.problem_meaning);
962: Fnd_Msg_Pub.ADD;
963: x_return_status := FND_API.G_RET_STS_ERROR;
964: END IF;

Line 961: Fnd_Message.SET_TOKEN('CODE',p_x_sr_task_rec.problem_meaning);

957: -- it updates invalid value. Hence throwing error explicitly
958: -- Part of NR MR ER.
959: IF p_x_sr_task_rec.problem_code IS NULL THEN
960: Fnd_Message.SET_NAME('AHL','AHL_PRD_PROBLEM_CODE_INVALID');
961: Fnd_Message.SET_TOKEN('CODE',p_x_sr_task_rec.problem_meaning);
962: Fnd_Msg_Pub.ADD;
963: x_return_status := FND_API.G_RET_STS_ERROR;
964: END IF;
965: -- NR MR ER - end

Line 986: Fnd_Message.SET_NAME('AHL','AHL_PRD_RESL_CODE_INV');

982: -- SR API doesnt throw any error if the resolution code is invalid neither
983: -- it updates invalid value. Hence throwing error explicitly
984: -- Part of NR MR ER
985: IF p_x_sr_task_rec.resolution_code IS NULL THEN
986: Fnd_Message.SET_NAME('AHL','AHL_PRD_RESL_CODE_INV');
987: Fnd_Message.SET_TOKEN('CODE',p_x_sr_task_rec.resolution_meaning);
988: Fnd_Msg_Pub.ADD;
989: x_return_status := FND_API.G_RET_STS_ERROR;
990: END IF;

Line 987: Fnd_Message.SET_TOKEN('CODE',p_x_sr_task_rec.resolution_meaning);

983: -- it updates invalid value. Hence throwing error explicitly
984: -- Part of NR MR ER
985: IF p_x_sr_task_rec.resolution_code IS NULL THEN
986: Fnd_Message.SET_NAME('AHL','AHL_PRD_RESL_CODE_INV');
987: Fnd_Message.SET_TOKEN('CODE',p_x_sr_task_rec.resolution_meaning);
988: Fnd_Msg_Pub.ADD;
989: x_return_status := FND_API.G_RET_STS_ERROR;
990: END IF;
991: -- NR MR ER -- end

Line 1023: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_MISMATCH');

1019: = p_x_sr_task_rec.contact_id;
1020:
1021: IF(l_contact_name <> nvl(p_x_sr_task_rec.contact_name,l_contact_name) and
1022: (p_x_sr_task_rec.contact_name <> FND_API.G_MISS_CHAR) )THEN
1023: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_MISMATCH');
1024: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);
1025: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);
1026: Fnd_Msg_Pub.ADD;
1027: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1024: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);

1020:
1021: IF(l_contact_name <> nvl(p_x_sr_task_rec.contact_name,l_contact_name) and
1022: (p_x_sr_task_rec.contact_name <> FND_API.G_MISS_CHAR) )THEN
1023: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_MISMATCH');
1024: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);
1025: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);
1026: Fnd_Msg_Pub.ADD;
1027: x_return_status := FND_API.G_RET_STS_ERROR;
1028: END IF;

Line 1025: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);

1021: IF(l_contact_name <> nvl(p_x_sr_task_rec.contact_name,l_contact_name) and
1022: (p_x_sr_task_rec.contact_name <> FND_API.G_MISS_CHAR) )THEN
1023: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_MISMATCH');
1024: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);
1025: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);
1026: Fnd_Msg_Pub.ADD;
1027: x_return_status := FND_API.G_RET_STS_ERROR;
1028: END IF;
1029:

Line 1033: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_ID_INVALID');

1029:
1030:
1031: EXCEPTION
1032: WHEN NO_DATA_FOUND THEN
1033: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_ID_INVALID');
1034: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);
1035: Fnd_Msg_Pub.ADD;
1036: x_return_status := FND_API.G_RET_STS_ERROR;
1037: WHEN TOO_MANY_ROWS THEN

Line 1034: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);

1030:
1031: EXCEPTION
1032: WHEN NO_DATA_FOUND THEN
1033: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_ID_INVALID');
1034: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);
1035: Fnd_Msg_Pub.ADD;
1036: x_return_status := FND_API.G_RET_STS_ERROR;
1037: WHEN TOO_MANY_ROWS THEN
1038: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_ID_NOT_UNIQUE');

Line 1038: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_ID_NOT_UNIQUE');

1034: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);
1035: Fnd_Msg_Pub.ADD;
1036: x_return_status := FND_API.G_RET_STS_ERROR;
1037: WHEN TOO_MANY_ROWS THEN
1038: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_ID_NOT_UNIQUE');
1039: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);
1040: Fnd_Msg_Pub.ADD;
1041: x_return_status := FND_API.G_RET_STS_ERROR;
1042: END;

Line 1039: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);

1035: Fnd_Msg_Pub.ADD;
1036: x_return_status := FND_API.G_RET_STS_ERROR;
1037: WHEN TOO_MANY_ROWS THEN
1038: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_ID_NOT_UNIQUE');
1039: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);
1040: Fnd_Msg_Pub.ADD;
1041: x_return_status := FND_API.G_RET_STS_ERROR;
1042: END;
1043:

Line 1061: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_INVALID');

1057: p_x_sr_task_rec.contact_id := l_contact_id;
1058:
1059: EXCEPTION
1060: WHEN NO_DATA_FOUND THEN
1061: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_INVALID');
1062: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);
1063: Fnd_Msg_Pub.ADD;
1064: x_return_status := FND_API.G_RET_STS_ERROR;
1065: WHEN TOO_MANY_ROWS THEN

Line 1062: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);

1058:
1059: EXCEPTION
1060: WHEN NO_DATA_FOUND THEN
1061: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_INVALID');
1062: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);
1063: Fnd_Msg_Pub.ADD;
1064: x_return_status := FND_API.G_RET_STS_ERROR;
1065: WHEN TOO_MANY_ROWS THEN
1066: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_NOT_UNIQUE');

Line 1066: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_NOT_UNIQUE');

1062: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);
1063: Fnd_Msg_Pub.ADD;
1064: x_return_status := FND_API.G_RET_STS_ERROR;
1065: WHEN TOO_MANY_ROWS THEN
1066: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_NOT_UNIQUE');
1067: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);
1068: Fnd_Msg_Pub.ADD;
1069: x_return_status := FND_API.G_RET_STS_ERROR;
1070: END;

Line 1067: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);

1063: Fnd_Msg_Pub.ADD;
1064: x_return_status := FND_API.G_RET_STS_ERROR;
1065: WHEN TOO_MANY_ROWS THEN
1066: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_NOT_UNIQUE');
1067: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);
1068: Fnd_Msg_Pub.ADD;
1069: x_return_status := FND_API.G_RET_STS_ERROR;
1070: END;
1071: -- NR MR ER -- start

Line 1110: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_MISMATCH');

1106: and trunc(nvl(effective_end_date,sysdate));
1107:
1108: IF(l_contact_name <> nvl(p_x_sr_task_rec.contact_name,l_contact_name) and
1109: (p_x_sr_task_rec.contact_name <> FND_API.G_MISS_CHAR) )THEN
1110: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_MISMATCH');
1111: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);
1112: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);
1113: Fnd_Msg_Pub.ADD;
1114: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1111: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);

1107:
1108: IF(l_contact_name <> nvl(p_x_sr_task_rec.contact_name,l_contact_name) and
1109: (p_x_sr_task_rec.contact_name <> FND_API.G_MISS_CHAR) )THEN
1110: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_MISMATCH');
1111: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);
1112: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);
1113: Fnd_Msg_Pub.ADD;
1114: x_return_status := FND_API.G_RET_STS_ERROR;
1115: END IF;

Line 1112: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);

1108: IF(l_contact_name <> nvl(p_x_sr_task_rec.contact_name,l_contact_name) and
1109: (p_x_sr_task_rec.contact_name <> FND_API.G_MISS_CHAR) )THEN
1110: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_MISMATCH');
1111: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);
1112: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);
1113: Fnd_Msg_Pub.ADD;
1114: x_return_status := FND_API.G_RET_STS_ERROR;
1115: END IF;
1116:

Line 1119: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_ID_INVALID');

1115: END IF;
1116:
1117: EXCEPTION
1118: WHEN NO_DATA_FOUND THEN
1119: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_ID_INVALID');
1120: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);
1121: Fnd_Msg_Pub.ADD;
1122: x_return_status := FND_API.G_RET_STS_ERROR;
1123: WHEN TOO_MANY_ROWS THEN

Line 1120: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);

1116:
1117: EXCEPTION
1118: WHEN NO_DATA_FOUND THEN
1119: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_ID_INVALID');
1120: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);
1121: Fnd_Msg_Pub.ADD;
1122: x_return_status := FND_API.G_RET_STS_ERROR;
1123: WHEN TOO_MANY_ROWS THEN
1124: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_ID_NOT_UNIQUE');

Line 1124: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_ID_NOT_UNIQUE');

1120: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);
1121: Fnd_Msg_Pub.ADD;
1122: x_return_status := FND_API.G_RET_STS_ERROR;
1123: WHEN TOO_MANY_ROWS THEN
1124: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_ID_NOT_UNIQUE');
1125: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);
1126: Fnd_Msg_Pub.ADD;
1127: x_return_status := FND_API.G_RET_STS_ERROR;
1128: END;

Line 1125: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);

1121: Fnd_Msg_Pub.ADD;
1122: x_return_status := FND_API.G_RET_STS_ERROR;
1123: WHEN TOO_MANY_ROWS THEN
1124: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_ID_NOT_UNIQUE');
1125: Fnd_Message.SET_TOKEN('CONT_ID',p_x_sr_task_rec.contact_id);
1126: Fnd_Msg_Pub.ADD;
1127: x_return_status := FND_API.G_RET_STS_ERROR;
1128: END;
1129:

Line 1149: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_INVALID');

1145: p_x_sr_task_rec.contact_id := l_contact_id;
1146:
1147: EXCEPTION
1148: WHEN NO_DATA_FOUND THEN
1149: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_INVALID');
1150: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);
1151: Fnd_Msg_Pub.ADD;
1152: x_return_status := FND_API.G_RET_STS_ERROR;
1153: WHEN TOO_MANY_ROWS THEN

Line 1150: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);

1146:
1147: EXCEPTION
1148: WHEN NO_DATA_FOUND THEN
1149: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_INVALID');
1150: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);
1151: Fnd_Msg_Pub.ADD;
1152: x_return_status := FND_API.G_RET_STS_ERROR;
1153: WHEN TOO_MANY_ROWS THEN
1154: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_NOT_UNIQUE');

Line 1154: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_NOT_UNIQUE');

1150: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);
1151: Fnd_Msg_Pub.ADD;
1152: x_return_status := FND_API.G_RET_STS_ERROR;
1153: WHEN TOO_MANY_ROWS THEN
1154: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_NOT_UNIQUE');
1155: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);
1156: Fnd_Msg_Pub.ADD;
1157: x_return_status := FND_API.G_RET_STS_ERROR;
1158: END;

Line 1155: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);

1151: Fnd_Msg_Pub.ADD;
1152: x_return_status := FND_API.G_RET_STS_ERROR;
1153: WHEN TOO_MANY_ROWS THEN
1154: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_NAME_NOT_UNIQUE');
1155: Fnd_Message.SET_TOKEN('CONT_NAME',p_x_sr_task_rec.contact_name);
1156: Fnd_Msg_Pub.ADD;
1157: x_return_status := FND_API.G_RET_STS_ERROR;
1158: END;
1159: -- NR MR ER -- start

Line 1189: Fnd_Message.SET_NAME('AHL','AHL_PRD_PROBLEM_CODE_INVALID');

1185: -- SR API doesnt throw any error if the problem code is invalid neither
1186: -- it updates invalid value. Hence throwing error explicitly
1187: -- Part of NR MR ER.
1188: IF p_x_sr_task_rec.problem_code IS NULL THEN
1189: Fnd_Message.SET_NAME('AHL','AHL_PRD_PROBLEM_CODE_INVALID');
1190: Fnd_Message.SET_TOKEN('CODE',p_x_sr_task_rec.problem_meaning);
1191: Fnd_Msg_Pub.ADD;
1192: x_return_status := FND_API.G_RET_STS_ERROR;
1193: END IF;

Line 1190: Fnd_Message.SET_TOKEN('CODE',p_x_sr_task_rec.problem_meaning);

1186: -- it updates invalid value. Hence throwing error explicitly
1187: -- Part of NR MR ER.
1188: IF p_x_sr_task_rec.problem_code IS NULL THEN
1189: Fnd_Message.SET_NAME('AHL','AHL_PRD_PROBLEM_CODE_INVALID');
1190: Fnd_Message.SET_TOKEN('CODE',p_x_sr_task_rec.problem_meaning);
1191: Fnd_Msg_Pub.ADD;
1192: x_return_status := FND_API.G_RET_STS_ERROR;
1193: END IF;
1194: -- NR MR ER -- end

Line 1214: Fnd_Message.SET_NAME('AHL','AHL_PRD_RESL_CODE_INV');

1210: -- SR API doesnt throw any error if the resolution code is invalid neither
1211: -- it updates invalid value. Hence throwing error explicitly
1212: -- Part of NR MR ER
1213: IF p_x_sr_task_rec.resolution_code IS NULL THEN
1214: Fnd_Message.SET_NAME('AHL','AHL_PRD_RESL_CODE_INV');
1215: Fnd_Message.SET_TOKEN('CODE',p_x_sr_task_rec.resolution_meaning);
1216: Fnd_Msg_Pub.ADD;
1217: x_return_status := FND_API.G_RET_STS_ERROR;
1218: END IF;

Line 1215: Fnd_Message.SET_TOKEN('CODE',p_x_sr_task_rec.resolution_meaning);

1211: -- it updates invalid value. Hence throwing error explicitly
1212: -- Part of NR MR ER
1213: IF p_x_sr_task_rec.resolution_code IS NULL THEN
1214: Fnd_Message.SET_NAME('AHL','AHL_PRD_RESL_CODE_INV');
1215: Fnd_Message.SET_TOKEN('CODE',p_x_sr_task_rec.resolution_meaning);
1216: Fnd_Msg_Pub.ADD;
1217: x_return_status := FND_API.G_RET_STS_ERROR;
1218: END IF;
1219: -- NR MR ER -- end

Line 1352: Fnd_Message.SET_NAME('AHL','AHL_PRD_INSTANCE_VALUE_REQ');

1348: -- Check if instance id is not null. If instance id
1349: -- is null then return error message.
1350: IF (p_x_sr_task_rec.instance_id is null or p_x_sr_task_rec.instance_id = FND_API.G_MISS_NUM) THEN
1351:
1352: Fnd_Message.SET_NAME('AHL','AHL_PRD_INSTANCE_VALUE_REQ');
1353: Fnd_Msg_Pub.ADD;
1354: RAISE FND_API.G_EXC_ERROR;
1355:
1356: END IF;

Line 1362: Fnd_Message.SET_NAME('AHL','AHL_PRD_TASK_ORG_WOID_REQ');

1358: -- If originating work order id is null then
1359: -- return an error message.
1360: IF (p_x_sr_task_rec.originating_wo_id is null or p_x_sr_task_rec.originating_wo_id = FND_API.G_MISS_NUM) THEN
1361:
1362: Fnd_Message.SET_NAME('AHL','AHL_PRD_TASK_ORG_WOID_REQ');
1363: Fnd_Msg_Pub.ADD;
1364: RAISE FND_API.G_EXC_ERROR;
1365:
1366: END IF;

Line 1378: Fnd_Message.SET_NAME('AHL','AHL_PRD_RESL_CODE_REQ');

1374:
1375: IF ( p_x_sr_task_rec.resolution_meaning IS NULL OR
1376: p_x_sr_task_rec.resolution_meaning = FND_API.G_MISS_CHAR) THEN
1377:
1378: Fnd_Message.SET_NAME('AHL','AHL_PRD_RESL_CODE_REQ');
1379: Fnd_Msg_Pub.ADD;
1380: RAISE FND_API.G_EXC_ERROR;
1381:
1382: END IF;

Line 1401: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_CRT_SR_UNTLCKD');

1397: p_ue_id => NULL,
1398: p_visit_id => NULL,
1399: p_item_instance_id => NULL);
1400: IF l_return_status = FND_API.G_TRUE THEN
1401: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_CRT_SR_UNTLCKD');
1402: FND_MESSAGE.Set_Token('WO_NAME', l_wo_name);
1403: FND_MSG_PUB.ADD;
1404: RAISE FND_API.G_EXC_ERROR;
1405: END IF;

Line 1402: FND_MESSAGE.Set_Token('WO_NAME', l_wo_name);

1398: p_visit_id => NULL,
1399: p_item_instance_id => NULL);
1400: IF l_return_status = FND_API.G_TRUE THEN
1401: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_CRT_SR_UNTLCKD');
1402: FND_MESSAGE.Set_Token('WO_NAME', l_wo_name);
1403: FND_MSG_PUB.ADD;
1404: RAISE FND_API.G_EXC_ERROR;
1405: END IF;
1406: -- rroy

Line 1420: Fnd_Message.SET_NAME('AHL','AHL_PRD_SR_TYPE_REQ');

1416: IF (fnd_profile.value('AHL_PRD_SR_TYPE') is not null) THEN
1417: p_x_sr_task_rec.type_id := fnd_profile.value('AHL_PRD_SR_TYPE');
1418: p_x_sr_task_rec.type_name := fnd_profile.value('AHL_PRD_SR_TYPE');
1419: ELSE
1420: Fnd_Message.SET_NAME('AHL','AHL_PRD_SR_TYPE_REQ');
1421: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1422: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1423: Fnd_Msg_Pub.ADD;
1424: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1421: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);

1417: p_x_sr_task_rec.type_id := fnd_profile.value('AHL_PRD_SR_TYPE');
1418: p_x_sr_task_rec.type_name := fnd_profile.value('AHL_PRD_SR_TYPE');
1419: ELSE
1420: Fnd_Message.SET_NAME('AHL','AHL_PRD_SR_TYPE_REQ');
1421: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1422: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1423: Fnd_Msg_Pub.ADD;
1424: x_return_status := FND_API.G_RET_STS_ERROR;
1425: END IF;

Line 1422: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);

1418: p_x_sr_task_rec.type_name := fnd_profile.value('AHL_PRD_SR_TYPE');
1419: ELSE
1420: Fnd_Message.SET_NAME('AHL','AHL_PRD_SR_TYPE_REQ');
1421: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1422: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1423: Fnd_Msg_Pub.ADD;
1424: x_return_status := FND_API.G_RET_STS_ERROR;
1425: END IF;
1426:

Line 1443: Fnd_Message.SET_NAME('AHL','AHL_PRD_SR_STATUS_DEFAULT_ERR');

1439: -- and we should use incident_status_id directly. - Balaji.
1440: /*
1441: OPEN cs_sr_status;
1442: IF( cs_sr_status%NOTFOUND) THEN
1443: Fnd_Message.SET_NAME('AHL','AHL_PRD_SR_STATUS_DEFAULT_ERR');
1444: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1445: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1446: Fnd_Msg_Pub.ADD;
1447: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1444: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);

1440: /*
1441: OPEN cs_sr_status;
1442: IF( cs_sr_status%NOTFOUND) THEN
1443: Fnd_Message.SET_NAME('AHL','AHL_PRD_SR_STATUS_DEFAULT_ERR');
1444: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1445: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1446: Fnd_Msg_Pub.ADD;
1447: x_return_status := FND_API.G_RET_STS_ERROR;
1448: ELSE

Line 1445: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);

1441: OPEN cs_sr_status;
1442: IF( cs_sr_status%NOTFOUND) THEN
1443: Fnd_Message.SET_NAME('AHL','AHL_PRD_SR_STATUS_DEFAULT_ERR');
1444: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1445: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1446: Fnd_Msg_Pub.ADD;
1447: x_return_status := FND_API.G_RET_STS_ERROR;
1448: ELSE
1449: FETCH cs_sr_status INTO p_x_sr_task_rec.status_id;

Line 1472: Fnd_Message.SET_NAME('AHL','AHL_PRD_SR_SEVERITY_INVALID');

1468: -- Validate the severity value
1469: OPEN cs_sr_severity_validate(p_x_sr_task_rec.severity_id);
1470:
1471: IF ( cs_sr_severity_validate%NOTFOUND) THEN
1472: Fnd_Message.SET_NAME('AHL','AHL_PRD_SR_SEVERITY_INVALID');
1473: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1474: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1475: Fnd_Msg_Pub.ADD;
1476: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1473: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);

1469: OPEN cs_sr_severity_validate(p_x_sr_task_rec.severity_id);
1470:
1471: IF ( cs_sr_severity_validate%NOTFOUND) THEN
1472: Fnd_Message.SET_NAME('AHL','AHL_PRD_SR_SEVERITY_INVALID');
1473: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1474: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1475: Fnd_Msg_Pub.ADD;
1476: x_return_status := FND_API.G_RET_STS_ERROR;
1477: END IF;

Line 1474: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);

1470:
1471: IF ( cs_sr_severity_validate%NOTFOUND) THEN
1472: Fnd_Message.SET_NAME('AHL','AHL_PRD_SR_SEVERITY_INVALID');
1473: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1474: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1475: Fnd_Msg_Pub.ADD;
1476: x_return_status := FND_API.G_RET_STS_ERROR;
1477: END IF;
1478:

Line 1481: Fnd_Message.SET_NAME('AHL','AHL_PRD_SR_SEVERITY_REQ');

1477: END IF;
1478:
1479: CLOSE cs_sr_severity_validate;
1480: ELSE
1481: Fnd_Message.SET_NAME('AHL','AHL_PRD_SR_SEVERITY_REQ');
1482: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1483: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1484: Fnd_Msg_Pub.ADD;
1485: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1482: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);

1478:
1479: CLOSE cs_sr_severity_validate;
1480: ELSE
1481: Fnd_Message.SET_NAME('AHL','AHL_PRD_SR_SEVERITY_REQ');
1482: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1483: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1484: Fnd_Msg_Pub.ADD;
1485: x_return_status := FND_API.G_RET_STS_ERROR;
1486: END IF;

Line 1483: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);

1479: CLOSE cs_sr_severity_validate;
1480: ELSE
1481: Fnd_Message.SET_NAME('AHL','AHL_PRD_SR_SEVERITY_REQ');
1482: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1483: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1484: Fnd_Msg_Pub.ADD;
1485: x_return_status := FND_API.G_RET_STS_ERROR;
1486: END IF;
1487:

Line 1504: Fnd_Message.SET_NAME('AHL','AHL_PRD_SUMMARY_REQ');

1500: -- If summary is null then return an
1501: -- error message.
1502: IF (p_x_sr_task_rec.summary is null or p_x_sr_task_rec.summary = FND_API.G_MISS_CHAR) THEN
1503:
1504: Fnd_Message.SET_NAME('AHL','AHL_PRD_SUMMARY_REQ');
1505: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1506: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1507: Fnd_Msg_Pub.ADD;
1508: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1505: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);

1501: -- error message.
1502: IF (p_x_sr_task_rec.summary is null or p_x_sr_task_rec.summary = FND_API.G_MISS_CHAR) THEN
1503:
1504: Fnd_Message.SET_NAME('AHL','AHL_PRD_SUMMARY_REQ');
1505: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1506: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1507: Fnd_Msg_Pub.ADD;
1508: x_return_status := FND_API.G_RET_STS_ERROR;
1509:

Line 1506: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);

1502: IF (p_x_sr_task_rec.summary is null or p_x_sr_task_rec.summary = FND_API.G_MISS_CHAR) THEN
1503:
1504: Fnd_Message.SET_NAME('AHL','AHL_PRD_SUMMARY_REQ');
1505: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1506: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1507: Fnd_Msg_Pub.ADD;
1508: x_return_status := FND_API.G_RET_STS_ERROR;
1509:
1510: END IF;

Line 1535: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_DEFAULT_CUST_ERROR');

1531: p_x_sr_task_rec.customer_name
1532: from hz_parties
1533: where party_id = p_x_sr_task_rec.customer_id;
1534: IF ( default_party_id%NOTFOUND) THEN
1535: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_DEFAULT_CUST_ERROR');
1536: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1537: Fnd_Message.SET_TOKEN('INSTANCE_NUM',null);
1538: Fnd_Msg_Pub.ADD;
1539: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1536: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);

1532: from hz_parties
1533: where party_id = p_x_sr_task_rec.customer_id;
1534: IF ( default_party_id%NOTFOUND) THEN
1535: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_DEFAULT_CUST_ERROR');
1536: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1537: Fnd_Message.SET_TOKEN('INSTANCE_NUM',null);
1538: Fnd_Msg_Pub.ADD;
1539: x_return_status := FND_API.G_RET_STS_ERROR;
1540: END IF;

Line 1537: Fnd_Message.SET_TOKEN('INSTANCE_NUM',null);

1533: where party_id = p_x_sr_task_rec.customer_id;
1534: IF ( default_party_id%NOTFOUND) THEN
1535: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_DEFAULT_CUST_ERROR');
1536: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1537: Fnd_Message.SET_TOKEN('INSTANCE_NUM',null);
1538: Fnd_Msg_Pub.ADD;
1539: x_return_status := FND_API.G_RET_STS_ERROR;
1540: END IF;
1541: OPEN owner_customer_type(p_x_sr_task_rec.customer_id);

Line 1544: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_DEFAULT_CUST_ERROR'); -- Customer Type is Invalid

1540: END IF;
1541: OPEN owner_customer_type(p_x_sr_task_rec.customer_id);
1542: FETCH owner_customer_type INTO p_x_sr_task_rec.customer_type;
1543: IF ( owner_customer_type%NOTFOUND) THEN
1544: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_DEFAULT_CUST_ERROR'); -- Customer Type is Invalid
1545: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1546: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1547: Fnd_Msg_Pub.ADD;
1548: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1545: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);

1541: OPEN owner_customer_type(p_x_sr_task_rec.customer_id);
1542: FETCH owner_customer_type INTO p_x_sr_task_rec.customer_type;
1543: IF ( owner_customer_type%NOTFOUND) THEN
1544: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_DEFAULT_CUST_ERROR'); -- Customer Type is Invalid
1545: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1546: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1547: Fnd_Msg_Pub.ADD;
1548: x_return_status := FND_API.G_RET_STS_ERROR;
1549: END IF;

Line 1546: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);

1542: FETCH owner_customer_type INTO p_x_sr_task_rec.customer_type;
1543: IF ( owner_customer_type%NOTFOUND) THEN
1544: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_DEFAULT_CUST_ERROR'); -- Customer Type is Invalid
1545: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1546: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1547: Fnd_Msg_Pub.ADD;
1548: x_return_status := FND_API.G_RET_STS_ERROR;
1549: END IF;
1550:

Line 1556: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_DEFAULT_CONT_ERROR');

1552: -- Defalut contact is Same
1553: OPEN default_contact;
1554: FETCH default_contact INTO p_x_sr_task_rec.contact_id;
1555: IF ( default_contact%NOTFOUND ) THEN
1556: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_DEFAULT_CONT_ERROR');
1557: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1558: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1559: Fnd_Msg_Pub.ADD;
1560: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1557: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);

1553: OPEN default_contact;
1554: FETCH default_contact INTO p_x_sr_task_rec.contact_id;
1555: IF ( default_contact%NOTFOUND ) THEN
1556: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_DEFAULT_CONT_ERROR');
1557: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1558: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1559: Fnd_Msg_Pub.ADD;
1560: x_return_status := FND_API.G_RET_STS_ERROR;
1561: ELSE

Line 1558: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);

1554: FETCH default_contact INTO p_x_sr_task_rec.contact_id;
1555: IF ( default_contact%NOTFOUND ) THEN
1556: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_DEFAULT_CONT_ERROR');
1557: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1558: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1559: Fnd_Msg_Pub.ADD;
1560: x_return_status := FND_API.G_RET_STS_ERROR;
1561: ELSE
1562: p_x_sr_task_rec.contact_type := 'EMPLOYEE';

Line 1573: Fnd_Message.SET_NAME('AHL','AHL_PRD_INVALID_OWNER'); -- New Error Message Should be added

1569: OPEN default_party_id(p_x_sr_task_rec.instance_id);
1570: FETCH default_party_id INTO l_owner_id ;
1571: IF( l_owner_id <> nvl(p_x_sr_task_rec.customer_id,l_owner_id) and
1572: (p_x_sr_task_rec.contact_name <> FND_API.G_MISS_CHAR) )THEN
1573: Fnd_Message.SET_NAME('AHL','AHL_PRD_INVALID_OWNER'); -- New Error Message Should be added
1574: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1575: Fnd_Msg_Pub.ADD;
1576: x_return_status := FND_API.G_RET_STS_ERROR;
1577: END IF;

Line 1574: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);

1570: FETCH default_party_id INTO l_owner_id ;
1571: IF( l_owner_id <> nvl(p_x_sr_task_rec.customer_id,l_owner_id) and
1572: (p_x_sr_task_rec.contact_name <> FND_API.G_MISS_CHAR) )THEN
1573: Fnd_Message.SET_NAME('AHL','AHL_PRD_INVALID_OWNER'); -- New Error Message Should be added
1574: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1575: Fnd_Msg_Pub.ADD;
1576: x_return_status := FND_API.G_RET_STS_ERROR;
1577: END IF;
1578:

Line 1594: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_DEFAULT_CUST_ERROR');

1590: OPEN default_customer_type;
1591: FETCH default_customer_type INTO p_x_sr_task_rec.customer_type;
1592:
1593: IF ( default_customer_type%NOTFOUND) THEN
1594: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_DEFAULT_CUST_ERROR');
1595: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1596: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1597: Fnd_Msg_Pub.ADD;
1598: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1595: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);

1591: FETCH default_customer_type INTO p_x_sr_task_rec.customer_type;
1592:
1593: IF ( default_customer_type%NOTFOUND) THEN
1594: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_DEFAULT_CUST_ERROR');
1595: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1596: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1597: Fnd_Msg_Pub.ADD;
1598: x_return_status := FND_API.G_RET_STS_ERROR;
1599: ELSE

Line 1596: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);

1592:
1593: IF ( default_customer_type%NOTFOUND) THEN
1594: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_DEFAULT_CUST_ERROR');
1595: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1596: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1597: Fnd_Msg_Pub.ADD;
1598: x_return_status := FND_API.G_RET_STS_ERROR;
1599: ELSE
1600: p_x_sr_task_rec.customer_id := fnd_profile.value('AHL_PRD_SR_CUSTOMER_NAME');

Line 1608: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_DEFAULT_CONT_ERROR');

1604:
1605: OPEN default_contact;
1606: FETCH default_contact INTO p_x_sr_task_rec.contact_id;
1607: IF ( default_contact%NOTFOUND ) THEN
1608: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_DEFAULT_CONT_ERROR');
1609: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1610: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1611: Fnd_Msg_Pub.ADD;
1612: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1609: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);

1605: OPEN default_contact;
1606: FETCH default_contact INTO p_x_sr_task_rec.contact_id;
1607: IF ( default_contact%NOTFOUND ) THEN
1608: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_DEFAULT_CONT_ERROR');
1609: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1610: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1611: Fnd_Msg_Pub.ADD;
1612: x_return_status := FND_API.G_RET_STS_ERROR;
1613: ELSE

Line 1610: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);

1606: FETCH default_contact INTO p_x_sr_task_rec.contact_id;
1607: IF ( default_contact%NOTFOUND ) THEN
1608: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_DEFAULT_CONT_ERROR');
1609: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1610: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1611: Fnd_Msg_Pub.ADD;
1612: x_return_status := FND_API.G_RET_STS_ERROR;
1613: ELSE
1614: p_x_sr_task_rec.contact_type := 'EMPLOYEE';

Line 1621: Fnd_Message.SET_NAME('AHL','AHL_PRD_CUST_PROFILE_REQ');

1617: CLOSE default_contact;
1618:
1619: ELSE
1620:
1621: Fnd_Message.SET_NAME('AHL','AHL_PRD_CUST_PROFILE_REQ');
1622: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1623: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1624: Fnd_Msg_Pub.ADD;
1625: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1622: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);

1618:
1619: ELSE
1620:
1621: Fnd_Message.SET_NAME('AHL','AHL_PRD_CUST_PROFILE_REQ');
1622: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1623: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1624: Fnd_Msg_Pub.ADD;
1625: x_return_status := FND_API.G_RET_STS_ERROR;
1626:

Line 1623: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);

1619: ELSE
1620:
1621: Fnd_Message.SET_NAME('AHL','AHL_PRD_CUST_PROFILE_REQ');
1622: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1623: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1624: Fnd_Msg_Pub.ADD;
1625: x_return_status := FND_API.G_RET_STS_ERROR;
1626:
1627: END IF;

Line 1637: Fnd_Message.SET_NAME('AHL','AHL_PRD_CUST_TYPE_REQ');

1633: -- null then return an error message.
1634: IF (p_x_sr_task_rec.customer_id is not null and
1635: (p_x_sr_task_rec.customer_type is null or p_x_sr_task_rec.customer_type = FND_API.G_MISS_CHAR)) THEN
1636:
1637: Fnd_Message.SET_NAME('AHL','AHL_PRD_CUST_TYPE_REQ');
1638: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1639: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1640: Fnd_Msg_Pub.ADD;
1641: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1638: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);

1634: IF (p_x_sr_task_rec.customer_id is not null and
1635: (p_x_sr_task_rec.customer_type is null or p_x_sr_task_rec.customer_type = FND_API.G_MISS_CHAR)) THEN
1636:
1637: Fnd_Message.SET_NAME('AHL','AHL_PRD_CUST_TYPE_REQ');
1638: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1639: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1640: Fnd_Msg_Pub.ADD;
1641: x_return_status := FND_API.G_RET_STS_ERROR;
1642:

Line 1639: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);

1635: (p_x_sr_task_rec.customer_type is null or p_x_sr_task_rec.customer_type = FND_API.G_MISS_CHAR)) THEN
1636:
1637: Fnd_Message.SET_NAME('AHL','AHL_PRD_CUST_TYPE_REQ');
1638: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1639: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1640: Fnd_Msg_Pub.ADD;
1641: x_return_status := FND_API.G_RET_STS_ERROR;
1642:
1643: END IF;

Line 1651: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_TYPE_REQ');

1647: -- null then return an error message.
1648: IF (p_x_sr_task_rec.contact_id is not null and
1649: (p_x_sr_task_rec.contact_type is null or p_x_sr_task_rec.contact_type = FND_API.G_MISS_CHAR)) THEN
1650:
1651: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_TYPE_REQ');
1652: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1653: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1654: Fnd_Msg_Pub.ADD;
1655: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1652: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);

1648: IF (p_x_sr_task_rec.contact_id is not null and
1649: (p_x_sr_task_rec.contact_type is null or p_x_sr_task_rec.contact_type = FND_API.G_MISS_CHAR)) THEN
1650:
1651: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_TYPE_REQ');
1652: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1653: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1654: Fnd_Msg_Pub.ADD;
1655: x_return_status := FND_API.G_RET_STS_ERROR;
1656:

Line 1653: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);

1649: (p_x_sr_task_rec.contact_type is null or p_x_sr_task_rec.contact_type = FND_API.G_MISS_CHAR)) THEN
1650:
1651: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_TYPE_REQ');
1652: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1653: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1654: Fnd_Msg_Pub.ADD;
1655: x_return_status := FND_API.G_RET_STS_ERROR;
1656:
1657: END IF;

Line 1665: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONTACT_REQ');

1661: -- is null then return an error message.
1662: IF (p_x_sr_task_rec.customer_id is not null and
1663: (p_x_sr_task_rec.contact_id is null or p_x_sr_task_rec.contact_id = FND_API.G_MISS_NUM)) THEN
1664:
1665: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONTACT_REQ');
1666: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1667: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1668: Fnd_Msg_Pub.ADD;
1669: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1666: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);

1662: IF (p_x_sr_task_rec.customer_id is not null and
1663: (p_x_sr_task_rec.contact_id is null or p_x_sr_task_rec.contact_id = FND_API.G_MISS_NUM)) THEN
1664:
1665: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONTACT_REQ');
1666: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1667: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1668: Fnd_Msg_Pub.ADD;
1669: x_return_status := FND_API.G_RET_STS_ERROR;
1670:

Line 1667: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);

1663: (p_x_sr_task_rec.contact_id is null or p_x_sr_task_rec.contact_id = FND_API.G_MISS_NUM)) THEN
1664:
1665: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONTACT_REQ');
1666: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1667: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1668: Fnd_Msg_Pub.ADD;
1669: x_return_status := FND_API.G_RET_STS_ERROR;
1670:
1671: -- If Contact is not null but Customer is null then

Line 1676: Fnd_Message.SET_NAME('AHL','AHL_PRD_CUSTOMER_REQ');

1672: -- return an error message.
1673: ELSIF((p_x_sr_task_rec.customer_id is null or p_x_sr_task_rec.customer_id = FND_API.G_MISS_NUM) and
1674: p_x_sr_task_rec.contact_id is not null ) THEN
1675:
1676: Fnd_Message.SET_NAME('AHL','AHL_PRD_CUSTOMER_REQ');
1677: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1678: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1679: Fnd_Msg_Pub.ADD;
1680: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1677: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);

1673: ELSIF((p_x_sr_task_rec.customer_id is null or p_x_sr_task_rec.customer_id = FND_API.G_MISS_NUM) and
1674: p_x_sr_task_rec.contact_id is not null ) THEN
1675:
1676: Fnd_Message.SET_NAME('AHL','AHL_PRD_CUSTOMER_REQ');
1677: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1678: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1679: Fnd_Msg_Pub.ADD;
1680: x_return_status := FND_API.G_RET_STS_ERROR;
1681:

Line 1678: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);

1674: p_x_sr_task_rec.contact_id is not null ) THEN
1675:
1676: Fnd_Message.SET_NAME('AHL','AHL_PRD_CUSTOMER_REQ');
1677: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1678: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1679: Fnd_Msg_Pub.ADD;
1680: x_return_status := FND_API.G_RET_STS_ERROR;
1681:
1682: END IF;

Line 1689: Fnd_Message.SET_NAME('AHL','AHL_PRD_VISIT_VALUE_REQ');

1685: -- If visit id is null then return an error
1686: -- message.
1687: IF (p_x_sr_task_rec.visit_id is null or p_x_sr_task_rec.visit_id = FND_API.G_MISS_NUM) THEN
1688:
1689: Fnd_Message.SET_NAME('AHL','AHL_PRD_VISIT_VALUE_REQ');
1690: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1691: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1692: Fnd_Msg_Pub.ADD;
1693: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1690: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);

1686: -- message.
1687: IF (p_x_sr_task_rec.visit_id is null or p_x_sr_task_rec.visit_id = FND_API.G_MISS_NUM) THEN
1688:
1689: Fnd_Message.SET_NAME('AHL','AHL_PRD_VISIT_VALUE_REQ');
1690: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1691: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1692: Fnd_Msg_Pub.ADD;
1693: x_return_status := FND_API.G_RET_STS_ERROR;
1694:

Line 1691: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);

1687: IF (p_x_sr_task_rec.visit_id is null or p_x_sr_task_rec.visit_id = FND_API.G_MISS_NUM) THEN
1688:
1689: Fnd_Message.SET_NAME('AHL','AHL_PRD_VISIT_VALUE_REQ');
1690: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1691: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1692: Fnd_Msg_Pub.ADD;
1693: x_return_status := FND_API.G_RET_STS_ERROR;
1694:
1695: END IF;

Line 1698: Fnd_Message.SET_NAME('AHL','AHL_POSITIVE_TSK_QTY');

1694:
1695: END IF;
1696: --amsriniv. Issue 105. Begin ER 6014567
1697: IF (p_x_sr_task_rec.instance_quantity IS NOT NULL AND p_x_sr_task_rec.instance_quantity <= 0) THEN
1698: Fnd_Message.SET_NAME('AHL','AHL_POSITIVE_TSK_QTY');
1699: Fnd_Msg_Pub.ADD;
1700: x_return_status := FND_API.G_RET_STS_ERROR;
1701: END IF;
1702:

Line 1707: Fnd_Message.SET_NAME('AHL','AHL_NO_CREATE_WO_NONSER');

1703: IF (upper(p_x_sr_task_rec.WO_Create_flag) = 'N') THEN
1704: OPEN check_inst_nonserial(p_x_sr_task_rec.Instance_id, p_x_sr_task_rec.originating_wo_id);
1705: FETCH check_inst_nonserial INTO l_dummy;
1706: IF (check_inst_nonserial%FOUND) THEN
1707: Fnd_Message.SET_NAME('AHL','AHL_NO_CREATE_WO_NONSER');
1708: Fnd_Message.SET_TOKEN('FIELD',l_instance_num);
1709: Fnd_Msg_Pub.ADD;
1710: x_return_status := FND_API.G_RET_STS_ERROR;
1711: END IF;

Line 1708: Fnd_Message.SET_TOKEN('FIELD',l_instance_num);

1704: OPEN check_inst_nonserial(p_x_sr_task_rec.Instance_id, p_x_sr_task_rec.originating_wo_id);
1705: FETCH check_inst_nonserial INTO l_dummy;
1706: IF (check_inst_nonserial%FOUND) THEN
1707: Fnd_Message.SET_NAME('AHL','AHL_NO_CREATE_WO_NONSER');
1708: Fnd_Message.SET_TOKEN('FIELD',l_instance_num);
1709: Fnd_Msg_Pub.ADD;
1710: x_return_status := FND_API.G_RET_STS_ERROR;
1711: END IF;
1712: CLOSE check_inst_nonserial;

Line 1720: Fnd_Message.SET_NAME('AHL','AHL_INST_NOT_ISSUED');

1716: IF (upper(p_x_sr_task_rec.WO_Create_flag) = 'Y' and upper(p_x_sr_task_rec.WO_Release_flag) = 'Y') THEN
1717: OPEN validate_quantity(p_x_sr_task_rec.Instance_id , p_x_sr_task_rec.originating_wo_id);
1718: FETCH validate_quantity INTO l_quantity;
1719: IF (validate_quantity%NOTFOUND) THEN
1720: Fnd_Message.SET_NAME('AHL','AHL_INST_NOT_ISSUED');
1721: Fnd_Message.SET_TOKEN('INS_NUM',l_instance_num);
1722: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1723: Fnd_Msg_Pub.ADD;
1724: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1721: Fnd_Message.SET_TOKEN('INS_NUM',l_instance_num);

1717: OPEN validate_quantity(p_x_sr_task_rec.Instance_id , p_x_sr_task_rec.originating_wo_id);
1718: FETCH validate_quantity INTO l_quantity;
1719: IF (validate_quantity%NOTFOUND) THEN
1720: Fnd_Message.SET_NAME('AHL','AHL_INST_NOT_ISSUED');
1721: Fnd_Message.SET_TOKEN('INS_NUM',l_instance_num);
1722: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1723: Fnd_Msg_Pub.ADD;
1724: x_return_status := FND_API.G_RET_STS_ERROR;
1725: ELSIF (l_quantity < p_x_sr_task_rec.instance_quantity) THEN

Line 1722: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);

1718: FETCH validate_quantity INTO l_quantity;
1719: IF (validate_quantity%NOTFOUND) THEN
1720: Fnd_Message.SET_NAME('AHL','AHL_INST_NOT_ISSUED');
1721: Fnd_Message.SET_TOKEN('INS_NUM',l_instance_num);
1722: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1723: Fnd_Msg_Pub.ADD;
1724: x_return_status := FND_API.G_RET_STS_ERROR;
1725: ELSIF (l_quantity < p_x_sr_task_rec.instance_quantity) THEN
1726: Fnd_Message.SET_NAME('AHL','AHL_INST_NOT_AVAIL');

Line 1726: Fnd_Message.SET_NAME('AHL','AHL_INST_NOT_AVAIL');

1722: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1723: Fnd_Msg_Pub.ADD;
1724: x_return_status := FND_API.G_RET_STS_ERROR;
1725: ELSIF (l_quantity < p_x_sr_task_rec.instance_quantity) THEN
1726: Fnd_Message.SET_NAME('AHL','AHL_INST_NOT_AVAIL');
1727: Fnd_Message.SET_TOKEN('INS_NAME',l_instance_num);
1728: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1729: Fnd_Message.SET_TOKEN('QUANT_USER',TO_CHAR(p_x_sr_task_rec.instance_quantity));
1730: Fnd_Message.SET_TOKEN('QUANT_AVAIL',TO_CHAR(l_quantity));

Line 1727: Fnd_Message.SET_TOKEN('INS_NAME',l_instance_num);

1723: Fnd_Msg_Pub.ADD;
1724: x_return_status := FND_API.G_RET_STS_ERROR;
1725: ELSIF (l_quantity < p_x_sr_task_rec.instance_quantity) THEN
1726: Fnd_Message.SET_NAME('AHL','AHL_INST_NOT_AVAIL');
1727: Fnd_Message.SET_TOKEN('INS_NAME',l_instance_num);
1728: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1729: Fnd_Message.SET_TOKEN('QUANT_USER',TO_CHAR(p_x_sr_task_rec.instance_quantity));
1730: Fnd_Message.SET_TOKEN('QUANT_AVAIL',TO_CHAR(l_quantity));
1731: Fnd_Msg_Pub.ADD;

Line 1728: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);

1724: x_return_status := FND_API.G_RET_STS_ERROR;
1725: ELSIF (l_quantity < p_x_sr_task_rec.instance_quantity) THEN
1726: Fnd_Message.SET_NAME('AHL','AHL_INST_NOT_AVAIL');
1727: Fnd_Message.SET_TOKEN('INS_NAME',l_instance_num);
1728: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1729: Fnd_Message.SET_TOKEN('QUANT_USER',TO_CHAR(p_x_sr_task_rec.instance_quantity));
1730: Fnd_Message.SET_TOKEN('QUANT_AVAIL',TO_CHAR(l_quantity));
1731: Fnd_Msg_Pub.ADD;
1732: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1729: Fnd_Message.SET_TOKEN('QUANT_USER',TO_CHAR(p_x_sr_task_rec.instance_quantity));

1725: ELSIF (l_quantity < p_x_sr_task_rec.instance_quantity) THEN
1726: Fnd_Message.SET_NAME('AHL','AHL_INST_NOT_AVAIL');
1727: Fnd_Message.SET_TOKEN('INS_NAME',l_instance_num);
1728: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1729: Fnd_Message.SET_TOKEN('QUANT_USER',TO_CHAR(p_x_sr_task_rec.instance_quantity));
1730: Fnd_Message.SET_TOKEN('QUANT_AVAIL',TO_CHAR(l_quantity));
1731: Fnd_Msg_Pub.ADD;
1732: x_return_status := FND_API.G_RET_STS_ERROR;
1733: END IF;

Line 1730: Fnd_Message.SET_TOKEN('QUANT_AVAIL',TO_CHAR(l_quantity));

1726: Fnd_Message.SET_NAME('AHL','AHL_INST_NOT_AVAIL');
1727: Fnd_Message.SET_TOKEN('INS_NAME',l_instance_num);
1728: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1729: Fnd_Message.SET_TOKEN('QUANT_USER',TO_CHAR(p_x_sr_task_rec.instance_quantity));
1730: Fnd_Message.SET_TOKEN('QUANT_AVAIL',TO_CHAR(l_quantity));
1731: Fnd_Msg_Pub.ADD;
1732: x_return_status := FND_API.G_RET_STS_ERROR;
1733: END IF;
1734: ELSE

Line 1735: Fnd_Message.SET_NAME('AHL','AHL_NR_WO_NOT_RELEASED');

1731: Fnd_Msg_Pub.ADD;
1732: x_return_status := FND_API.G_RET_STS_ERROR;
1733: END IF;
1734: ELSE
1735: Fnd_Message.SET_NAME('AHL','AHL_NR_WO_NOT_RELEASED');
1736: Fnd_Msg_Pub.ADD;
1737: x_return_status := FND_API.G_RET_STS_ERROR;
1738: END IF;
1739: END IF;

Line 1755: Fnd_Message.SET_NAME('AHL','AHL_PRD_RESL_CODE_REQ');

1751:
1752: IF ( p_x_sr_task_rec.resolution_meaning IS NULL OR
1753: p_x_sr_task_rec.resolution_meaning = FND_API.G_MISS_CHAR) THEN
1754:
1755: Fnd_Message.SET_NAME('AHL','AHL_PRD_RESL_CODE_REQ');
1756: Fnd_Msg_Pub.ADD;
1757: RAISE FND_API.G_EXC_ERROR;
1758:
1759: END IF;

Line 1777: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_UPD_SR_UNTLCKD');

1773: p_ue_id => NULL,
1774: p_visit_id => NULL,
1775: p_item_instance_id => NULL);
1776: IF l_return_status = FND_API.G_TRUE THEN
1777: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_UPD_SR_UNTLCKD');
1778: FND_MESSAGE.Set_Token('WO_NAME', l_wo_name);
1779: FND_MSG_PUB.ADD;
1780: RAISE FND_API.G_EXC_ERROR;
1781: END IF;

Line 1778: FND_MESSAGE.Set_Token('WO_NAME', l_wo_name);

1774: p_visit_id => NULL,
1775: p_item_instance_id => NULL);
1776: IF l_return_status = FND_API.G_TRUE THEN
1777: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_UPD_SR_UNTLCKD');
1778: FND_MESSAGE.Set_Token('WO_NAME', l_wo_name);
1779: FND_MSG_PUB.ADD;
1780: RAISE FND_API.G_EXC_ERROR;
1781: END IF;
1782: -- rroy

Line 1791: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONTACT_REQ');

1787: -- If contact id is null then return an
1788: -- error message.
1789: IF (p_x_sr_task_rec.contact_id is null or p_x_sr_task_rec.contact_id = FND_API.G_MISS_NUM) THEN
1790:
1791: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONTACT_REQ');
1792: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1793: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1794: Fnd_Msg_Pub.ADD;
1795: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1792: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);

1788: -- error message.
1789: IF (p_x_sr_task_rec.contact_id is null or p_x_sr_task_rec.contact_id = FND_API.G_MISS_NUM) THEN
1790:
1791: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONTACT_REQ');
1792: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1793: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1794: Fnd_Msg_Pub.ADD;
1795: x_return_status := FND_API.G_RET_STS_ERROR;
1796:

Line 1793: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);

1789: IF (p_x_sr_task_rec.contact_id is null or p_x_sr_task_rec.contact_id = FND_API.G_MISS_NUM) THEN
1790:
1791: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONTACT_REQ');
1792: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1793: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1794: Fnd_Msg_Pub.ADD;
1795: x_return_status := FND_API.G_RET_STS_ERROR;
1796:
1797: END IF;

Line 1805: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_TYPE_REQ');

1801: -- message.
1802: IF (p_x_sr_task_rec.contact_id is not null and
1803: (p_x_sr_task_rec.contact_type is null or p_x_sr_task_rec.contact_type = FND_API.G_MISS_CHAR)) THEN
1804:
1805: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_TYPE_REQ');
1806: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1807: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1808: Fnd_Msg_Pub.ADD;
1809: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1806: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);

1802: IF (p_x_sr_task_rec.contact_id is not null and
1803: (p_x_sr_task_rec.contact_type is null or p_x_sr_task_rec.contact_type = FND_API.G_MISS_CHAR)) THEN
1804:
1805: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_TYPE_REQ');
1806: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1807: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1808: Fnd_Msg_Pub.ADD;
1809: x_return_status := FND_API.G_RET_STS_ERROR;
1810:

Line 1807: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);

1803: (p_x_sr_task_rec.contact_type is null or p_x_sr_task_rec.contact_type = FND_API.G_MISS_CHAR)) THEN
1804:
1805: Fnd_Message.SET_NAME('AHL','AHL_PRD_CONT_TYPE_REQ');
1806: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1807: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1808: Fnd_Msg_Pub.ADD;
1809: x_return_status := FND_API.G_RET_STS_ERROR;
1810:
1811: END IF;

Line 1819: Fnd_Message.SET_NAME('AHL','AHL_PRD_SR_STATUS_REQ');

1815: -- error message.
1816: IF ((p_x_sr_task_rec.status_id is null or p_x_sr_task_rec.status_id = FND_API.G_MISS_NUM)and
1817: (p_x_sr_task_rec.status_name is null or p_x_sr_task_rec.status_name = FND_API.G_MISS_CHAR)) THEN
1818:
1819: Fnd_Message.SET_NAME('AHL','AHL_PRD_SR_STATUS_REQ');
1820: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1821: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1822: Fnd_Msg_Pub.ADD;
1823: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1820: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);

1816: IF ((p_x_sr_task_rec.status_id is null or p_x_sr_task_rec.status_id = FND_API.G_MISS_NUM)and
1817: (p_x_sr_task_rec.status_name is null or p_x_sr_task_rec.status_name = FND_API.G_MISS_CHAR)) THEN
1818:
1819: Fnd_Message.SET_NAME('AHL','AHL_PRD_SR_STATUS_REQ');
1820: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1821: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1822: Fnd_Msg_Pub.ADD;
1823: x_return_status := FND_API.G_RET_STS_ERROR;
1824:

Line 1821: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);

1817: (p_x_sr_task_rec.status_name is null or p_x_sr_task_rec.status_name = FND_API.G_MISS_CHAR)) THEN
1818:
1819: Fnd_Message.SET_NAME('AHL','AHL_PRD_SR_STATUS_REQ');
1820: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1821: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1822: Fnd_Msg_Pub.ADD;
1823: x_return_status := FND_API.G_RET_STS_ERROR;
1824:
1825: END IF;

Line 1834: Fnd_Message.SET_NAME('AHL','AHL_PRD_SR_OBJ_VER_ID_REQ');

1830: -- return an error message.
1831: IF (p_x_sr_task_rec.incident_object_version_number is null or
1832: p_x_sr_task_rec.incident_object_version_number = FND_API.G_MISS_NUM) THEN
1833:
1834: Fnd_Message.SET_NAME('AHL','AHL_PRD_SR_OBJ_VER_ID_REQ');
1835: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1836: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1837: Fnd_Msg_Pub.ADD;
1838: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1835: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);

1831: IF (p_x_sr_task_rec.incident_object_version_number is null or
1832: p_x_sr_task_rec.incident_object_version_number = FND_API.G_MISS_NUM) THEN
1833:
1834: Fnd_Message.SET_NAME('AHL','AHL_PRD_SR_OBJ_VER_ID_REQ');
1835: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1836: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1837: Fnd_Msg_Pub.ADD;
1838: x_return_status := FND_API.G_RET_STS_ERROR;
1839:

Line 1836: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);

1832: p_x_sr_task_rec.incident_object_version_number = FND_API.G_MISS_NUM) THEN
1833:
1834: Fnd_Message.SET_NAME('AHL','AHL_PRD_SR_OBJ_VER_ID_REQ');
1835: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1836: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1837: Fnd_Msg_Pub.ADD;
1838: x_return_status := FND_API.G_RET_STS_ERROR;
1839:
1840: END IF;

Line 1849: Fnd_Message.SET_NAME('AHL','AHL_PRD_INCIDENT_VALUE_REQ');

1845: p_x_sr_task_rec.incident_number = FND_API.G_MISS_CHAR) and
1846: (p_x_sr_task_rec.incident_id is null or
1847: p_x_sr_task_rec.incident_id = FND_API.G_MISS_NUM)THEN
1848:
1849: Fnd_Message.SET_NAME('AHL','AHL_PRD_INCIDENT_VALUE_REQ');
1850: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1851: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1852: Fnd_Msg_Pub.ADD;
1853: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1850: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);

1846: (p_x_sr_task_rec.incident_id is null or
1847: p_x_sr_task_rec.incident_id = FND_API.G_MISS_NUM)THEN
1848:
1849: Fnd_Message.SET_NAME('AHL','AHL_PRD_INCIDENT_VALUE_REQ');
1850: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1851: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1852: Fnd_Msg_Pub.ADD;
1853: x_return_status := FND_API.G_RET_STS_ERROR;
1854: END IF;

Line 1851: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);

1847: p_x_sr_task_rec.incident_id = FND_API.G_MISS_NUM)THEN
1848:
1849: Fnd_Message.SET_NAME('AHL','AHL_PRD_INCIDENT_VALUE_REQ');
1850: Fnd_Message.SET_TOKEN('WO_NAME',l_wo_name);
1851: Fnd_Message.SET_TOKEN('INSTANCE_NUM',l_instance_num);
1852: Fnd_Msg_Pub.ADD;
1853: x_return_status := FND_API.G_RET_STS_ERROR;
1854: END IF;
1855:

Line 1954: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_DEFAULT_ORG_ERROR');

1950: l_service_request_rec.customer_product_id := p_x_sr_task_rec.instance_id;
1951: open default_item_org_id(p_x_sr_task_rec.Originating_wo_id);
1952: Fetch default_item_org_id INTO l_service_request_rec.inventory_item_id,l_service_request_rec.inventory_org_id;
1953: IF (default_item_org_id%NOTFOUND ) THEN
1954: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_DEFAULT_ORG_ERROR');
1955: Fnd_Msg_Pub.ADD;
1956: x_return_status := FND_API.G_RET_STS_ERROR;
1957: END IF;
1958:

Line 1963: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_DEFAULT_INCIDENT_ERROR');

1959: open default_incident_type_id;
1960: Fetch default_incident_type_id INTO l_service_request_rec.type_id,l_service_request_rec.type_name;
1961:
1962: IF ( default_incident_type_id%NOTFOUND) THEN
1963: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_DEFAULT_INCIDENT_ERROR');
1964: Fnd_Msg_Pub.ADD;
1965: x_return_status := FND_API.G_RET_STS_ERROR;
1966: END IF;
1967: CLOSE default_item_org_id;

Line 2072: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_ORIGINWO_UPD_FAILED');

2068:
2069: EXCEPTION
2070:
2071: WHEN OTHERS THEN
2072: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_ORIGINWO_UPD_FAILED');
2073: Fnd_Msg_Pub.ADD;
2074: x_return_status := FND_API.G_RET_STS_ERROR;
2075:
2076: END;

Line 2269: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_INVALID_SR');

2265: FETCH c_get_ue_id into l_unit_effectivity_id ;
2266: IF c_get_ue_id%NotFound
2267: THEN
2268: x_return_status := FND_API.G_RET_STS_ERROR;
2269: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_INVALID_SR');
2270: FND_MESSAGE.SET_TOKEN('WO_ID',p_x_task_tbl(i).originating_wo_id);
2271: FND_MSG_PUB.ADD;
2272: RAISE FND_API.G_EXC_ERROR;
2273: END IF;

Line 2270: FND_MESSAGE.SET_TOKEN('WO_ID',p_x_task_tbl(i).originating_wo_id);

2266: IF c_get_ue_id%NotFound
2267: THEN
2268: x_return_status := FND_API.G_RET_STS_ERROR;
2269: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_INVALID_SR');
2270: FND_MESSAGE.SET_TOKEN('WO_ID',p_x_task_tbl(i).originating_wo_id);
2271: FND_MSG_PUB.ADD;
2272: RAISE FND_API.G_EXC_ERROR;
2273: END IF;
2274: CLOSE c_get_ue_id;

Line 2576: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_TASK_ID_NOT_UNIQUE');

2572: Fetch GetOrgTaskDet into l_org_task_id;
2573:
2574: If GetOrgTaskDet%Found and GetOrgTaskDet%rowcount >1
2575: Then
2576: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_TASK_ID_NOT_UNIQUE');
2577: FND_MESSAGE.SET_TOKEN('WO_ID',p_x_task_tbl(i).originating_wo_id);
2578: Fnd_Msg_Pub.ADD;
2579: RAISE FND_API.G_EXC_ERROR;
2580: ElsIf GetOrgTaskDet%NotFound

Line 2577: FND_MESSAGE.SET_TOKEN('WO_ID',p_x_task_tbl(i).originating_wo_id);

2573:
2574: If GetOrgTaskDet%Found and GetOrgTaskDet%rowcount >1
2575: Then
2576: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_TASK_ID_NOT_UNIQUE');
2577: FND_MESSAGE.SET_TOKEN('WO_ID',p_x_task_tbl(i).originating_wo_id);
2578: Fnd_Msg_Pub.ADD;
2579: RAISE FND_API.G_EXC_ERROR;
2580: ElsIf GetOrgTaskDet%NotFound
2581: Then

Line 2582: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_INVALID_WO_ID');

2578: Fnd_Msg_Pub.ADD;
2579: RAISE FND_API.G_EXC_ERROR;
2580: ElsIf GetOrgTaskDet%NotFound
2581: Then
2582: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_INVALID_WO_ID');
2583: FND_MESSAGE.SET_TOKEN('WO_ID',p_x_task_tbl(i).originating_wo_id);
2584: Fnd_Msg_Pub.ADD;
2585: RAISE FND_API.G_EXC_ERROR;
2586: End if;

Line 2583: FND_MESSAGE.SET_TOKEN('WO_ID',p_x_task_tbl(i).originating_wo_id);

2579: RAISE FND_API.G_EXC_ERROR;
2580: ElsIf GetOrgTaskDet%NotFound
2581: Then
2582: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_INVALID_WO_ID');
2583: FND_MESSAGE.SET_TOKEN('WO_ID',p_x_task_tbl(i).originating_wo_id);
2584: Fnd_Msg_Pub.ADD;
2585: RAISE FND_API.G_EXC_ERROR;
2586: End if;
2587: Close GetOrgTaskDet;

Line 2621: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_INVALID_SR'); -- New Message needed to be added

2617: Open getUnitEffectivity(p_x_task_tbl(i).incident_id);
2618: Fetch getUnitEffectivity into l_unit_effectivity_id ;
2619: IF getUnitEffectivity%NotFound
2620: Then
2621: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_INVALID_SR'); -- New Message needed to be added
2622: FND_MESSAGE.SET_TOKEN('WO_ID',p_x_task_tbl(i).originating_wo_id);
2623: Fnd_Msg_Pub.ADD;
2624: RAISE FND_API.G_EXC_ERROR;
2625: End if;

Line 2622: FND_MESSAGE.SET_TOKEN('WO_ID',p_x_task_tbl(i).originating_wo_id);

2618: Fetch getUnitEffectivity into l_unit_effectivity_id ;
2619: IF getUnitEffectivity%NotFound
2620: Then
2621: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_INVALID_SR'); -- New Message needed to be added
2622: FND_MESSAGE.SET_TOKEN('WO_ID',p_x_task_tbl(i).originating_wo_id);
2623: Fnd_Msg_Pub.ADD;
2624: RAISE FND_API.G_EXC_ERROR;
2625: End if;
2626: Close getUnitEffectivity;

Line 2932: fnd_message.set_name('AHL','AHL_PRD_SR_NOTE');

2928: -- No exceptions were handled in previous code.
2929: -- Changed the big lengthy Begin------End; code for each sql to Cursor.
2930: -- Too many (Invalid) exception handling got reduced.
2931:
2932: fnd_message.set_name('AHL','AHL_PRD_SR_NOTE');
2933: fnd_message.set_token('PART_NUMBER',l_part_number);
2934: fnd_message.set_token('SERIAL_NUMBER',l_serial_number);
2935: x_note := fnd_message.get;
2936:

Line 2933: fnd_message.set_token('PART_NUMBER',l_part_number);

2929: -- Changed the big lengthy Begin------End; code for each sql to Cursor.
2930: -- Too many (Invalid) exception handling got reduced.
2931:
2932: fnd_message.set_name('AHL','AHL_PRD_SR_NOTE');
2933: fnd_message.set_token('PART_NUMBER',l_part_number);
2934: fnd_message.set_token('SERIAL_NUMBER',l_serial_number);
2935: x_note := fnd_message.get;
2936:
2937: fnd_message.set_name('AHL','AHL_PRD_SR_NOTE_DETAIL');

Line 2934: fnd_message.set_token('SERIAL_NUMBER',l_serial_number);

2930: -- Too many (Invalid) exception handling got reduced.
2931:
2932: fnd_message.set_name('AHL','AHL_PRD_SR_NOTE');
2933: fnd_message.set_token('PART_NUMBER',l_part_number);
2934: fnd_message.set_token('SERIAL_NUMBER',l_serial_number);
2935: x_note := fnd_message.get;
2936:
2937: fnd_message.set_name('AHL','AHL_PRD_SR_NOTE_DETAIL');
2938: fnd_message.set_token('WO_NAME',l_wo_name);

Line 2935: x_note := fnd_message.get;

2931:
2932: fnd_message.set_name('AHL','AHL_PRD_SR_NOTE');
2933: fnd_message.set_token('PART_NUMBER',l_part_number);
2934: fnd_message.set_token('SERIAL_NUMBER',l_serial_number);
2935: x_note := fnd_message.get;
2936:
2937: fnd_message.set_name('AHL','AHL_PRD_SR_NOTE_DETAIL');
2938: fnd_message.set_token('WO_NAME',l_wo_name);
2939: fnd_message.set_token('INSTANCE_NUMBER',l_instance_number);

Line 2937: fnd_message.set_name('AHL','AHL_PRD_SR_NOTE_DETAIL');

2933: fnd_message.set_token('PART_NUMBER',l_part_number);
2934: fnd_message.set_token('SERIAL_NUMBER',l_serial_number);
2935: x_note := fnd_message.get;
2936:
2937: fnd_message.set_name('AHL','AHL_PRD_SR_NOTE_DETAIL');
2938: fnd_message.set_token('WO_NAME',l_wo_name);
2939: fnd_message.set_token('INSTANCE_NUMBER',l_instance_number);
2940: x_note_detail := fnd_message.get;
2941:

Line 2938: fnd_message.set_token('WO_NAME',l_wo_name);

2934: fnd_message.set_token('SERIAL_NUMBER',l_serial_number);
2935: x_note := fnd_message.get;
2936:
2937: fnd_message.set_name('AHL','AHL_PRD_SR_NOTE_DETAIL');
2938: fnd_message.set_token('WO_NAME',l_wo_name);
2939: fnd_message.set_token('INSTANCE_NUMBER',l_instance_number);
2940: x_note_detail := fnd_message.get;
2941:
2942: END get_note_value;

Line 2939: fnd_message.set_token('INSTANCE_NUMBER',l_instance_number);

2935: x_note := fnd_message.get;
2936:
2937: fnd_message.set_name('AHL','AHL_PRD_SR_NOTE_DETAIL');
2938: fnd_message.set_token('WO_NAME',l_wo_name);
2939: fnd_message.set_token('INSTANCE_NUMBER',l_instance_number);
2940: x_note_detail := fnd_message.get;
2941:
2942: END get_note_value;
2943:

Line 2940: x_note_detail := fnd_message.get;

2936:
2937: fnd_message.set_name('AHL','AHL_PRD_SR_NOTE_DETAIL');
2938: fnd_message.set_token('WO_NAME',l_wo_name);
2939: fnd_message.set_token('INSTANCE_NUMBER',l_instance_number);
2940: x_note_detail := fnd_message.get;
2941:
2942: END get_note_value;
2943:
2944: -----------------------------------