DBA Data[Home] [Help]

APPS.PV_PRGM_PTR_TYPES_PVT dependencies on FND_MESSAGE

Line 100: FND_MESSAGE.set_name('PV', 'PV_API_USER_PROFILE_MISSING');

96:
97: --------------- validate -------------------------
98:
99: IF FND_GLOBAL.User_Id IS NULL THEN
100: FND_MESSAGE.set_name('PV', 'PV_API_USER_PROFILE_MISSING');
101: FND_MSG_PUB.add;
102: RAISE FND_API.G_EXC_ERROR;
103: END IF;
104:

Line 321: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');

317: OPEN c_get_Pgm_Tgt_Ptr_Typ( l_tar_prgm_ptr_types_rec.program_partner_types_id);
318: FETCH c_get_Pgm_Tgt_Ptr_Typ INTO l_ref_prgm_ptr_types_rec ;
319:
320: If ( c_get_Pgm_Tgt_Ptr_Typ%NOTFOUND) THEN
321: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
322: FND_MESSAGE.set_token('MODE','Update');
323: FND_MESSAGE.set_token('ENTITY','Pgm_Tgt_Ptr_Typ');
324: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_prgm_ptr_types_rec.program_partner_types_id));
325: FND_MSG_PUB.add;

Line 322: FND_MESSAGE.set_token('MODE','Update');

318: FETCH c_get_Pgm_Tgt_Ptr_Typ INTO l_ref_prgm_ptr_types_rec ;
319:
320: If ( c_get_Pgm_Tgt_Ptr_Typ%NOTFOUND) THEN
321: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
322: FND_MESSAGE.set_token('MODE','Update');
323: FND_MESSAGE.set_token('ENTITY','Pgm_Tgt_Ptr_Typ');
324: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_prgm_ptr_types_rec.program_partner_types_id));
325: FND_MSG_PUB.add;
326: RAISE FND_API.G_EXC_ERROR;

Line 323: FND_MESSAGE.set_token('ENTITY','Pgm_Tgt_Ptr_Typ');

319:
320: If ( c_get_Pgm_Tgt_Ptr_Typ%NOTFOUND) THEN
321: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
322: FND_MESSAGE.set_token('MODE','Update');
323: FND_MESSAGE.set_token('ENTITY','Pgm_Tgt_Ptr_Typ');
324: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_prgm_ptr_types_rec.program_partner_types_id));
325: FND_MSG_PUB.add;
326: RAISE FND_API.G_EXC_ERROR;
327: END IF;

Line 324: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_prgm_ptr_types_rec.program_partner_types_id));

320: If ( c_get_Pgm_Tgt_Ptr_Typ%NOTFOUND) THEN
321: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
322: FND_MESSAGE.set_token('MODE','Update');
323: FND_MESSAGE.set_token('ENTITY','Pgm_Tgt_Ptr_Typ');
324: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_prgm_ptr_types_rec.program_partner_types_id));
325: FND_MSG_PUB.add;
326: RAISE FND_API.G_EXC_ERROR;
327: END IF;
328:

Line 340: FND_MESSAGE.set_name('PV', 'PV_API_VERSION_MISSING');

336:
337: If (l_tar_prgm_ptr_types_rec.object_version_number is NULL or
338: l_tar_prgm_ptr_types_rec.object_version_number = FND_API.G_MISS_NUM ) THEN
339:
340: FND_MESSAGE.set_name('PV', 'PV_API_VERSION_MISSING');
341: FND_MESSAGE.set_token('COLUMN','OBJECT_VERSION_NUMBER');
342: FND_MSG_PUB.add;
343: RAISE FND_API.G_EXC_ERROR;
344: End if;

Line 341: FND_MESSAGE.set_token('COLUMN','OBJECT_VERSION_NUMBER');

337: If (l_tar_prgm_ptr_types_rec.object_version_number is NULL or
338: l_tar_prgm_ptr_types_rec.object_version_number = FND_API.G_MISS_NUM ) THEN
339:
340: FND_MESSAGE.set_name('PV', 'PV_API_VERSION_MISSING');
341: FND_MESSAGE.set_token('COLUMN','OBJECT_VERSION_NUMBER');
342: FND_MSG_PUB.add;
343: RAISE FND_API.G_EXC_ERROR;
344: End if;
345:

Line 348: FND_MESSAGE.set_name('PV', 'PV_API_RECORD_CHANGED');

344: End if;
345:
346: -- Check Whether record has been changed by someone else
347: If (l_tar_prgm_ptr_types_rec.object_version_number <> l_ref_prgm_ptr_types_rec.object_version_number) Then
348: FND_MESSAGE.set_name('PV', 'PV_API_RECORD_CHANGED');
349: FND_MESSAGE.set_token('VALUE','Pgm_Tgt_Ptr_Typ');
350: FND_MSG_PUB.add;
351: RAISE FND_API.G_EXC_ERROR;
352: End if;

Line 349: FND_MESSAGE.set_token('VALUE','Pgm_Tgt_Ptr_Typ');

345:
346: -- Check Whether record has been changed by someone else
347: If (l_tar_prgm_ptr_types_rec.object_version_number <> l_ref_prgm_ptr_types_rec.object_version_number) Then
348: FND_MESSAGE.set_name('PV', 'PV_API_RECORD_CHANGED');
349: FND_MESSAGE.set_token('VALUE','Pgm_Tgt_Ptr_Typ');
350: FND_MSG_PUB.add;
351: RAISE FND_API.G_EXC_ERROR;
352: End if;
353:

Line 643: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');

639:
640: IF (c_Pgm_Tgt_Ptr_Typ%NOTFOUND) THEN
641: CLOSE c_Pgm_Tgt_Ptr_Typ;
642: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
643: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
644: FND_MSG_PUB.add;
645: END IF;
646: RAISE FND_API.g_exc_error;
647: END IF;

Line 727: FND_MESSAGE.set_name('PV', 'PV_API_DUPLICATE_ENTITY');

723: ,'PROGRAM_PARTNER_TYPES_ID = ''' || p_prgm_ptr_types_rec.PROGRAM_PARTNER_TYPES_ID ||''''
724: );
725:
726: IF l_valid_flag = FND_API.g_false THEN
727: FND_MESSAGE.set_name('PV', 'PV_API_DUPLICATE_ENTITY');
728: FND_MESSAGE.set_token('ID',to_char(p_prgm_ptr_types_rec.PROGRAM_PARTNER_TYPES_ID) );
729: FND_MESSAGE.set_token('ENTITY','Pgm_Tgt_Ptr_Typ');
730: FND_MSG_PUB.add;
731: x_return_status := FND_API.g_ret_sts_error;

Line 728: FND_MESSAGE.set_token('ID',to_char(p_prgm_ptr_types_rec.PROGRAM_PARTNER_TYPES_ID) );

724: );
725:
726: IF l_valid_flag = FND_API.g_false THEN
727: FND_MESSAGE.set_name('PV', 'PV_API_DUPLICATE_ENTITY');
728: FND_MESSAGE.set_token('ID',to_char(p_prgm_ptr_types_rec.PROGRAM_PARTNER_TYPES_ID) );
729: FND_MESSAGE.set_token('ENTITY','Pgm_Tgt_Ptr_Typ');
730: FND_MSG_PUB.add;
731: x_return_status := FND_API.g_ret_sts_error;
732: RETURN;

Line 729: FND_MESSAGE.set_token('ENTITY','Pgm_Tgt_Ptr_Typ');

725:
726: IF l_valid_flag = FND_API.g_false THEN
727: FND_MESSAGE.set_name('PV', 'PV_API_DUPLICATE_ENTITY');
728: FND_MESSAGE.set_token('ID',to_char(p_prgm_ptr_types_rec.PROGRAM_PARTNER_TYPES_ID) );
729: FND_MESSAGE.set_token('ENTITY','Pgm_Tgt_Ptr_Typ');
730: FND_MSG_PUB.add;
731: x_return_status := FND_API.g_ret_sts_error;
732: RETURN;
733: END IF;

Line 747: FND_MESSAGE.set_name('PV', 'PV_API_DUPLICATE_ENTITY');

743: ,'PROGRAM_TYPE_ID = ''' || p_prgm_ptr_types_rec.PROGRAM_TYPE_ID ||''' AND PARTNER_TYPE = ''' || p_prgm_ptr_types_rec.PARTNER_TYPE || ''''
744: );
745:
746: IF l_valid_flag = FND_API.g_false THEN
747: FND_MESSAGE.set_name('PV', 'PV_API_DUPLICATE_ENTITY');
748: FND_MESSAGE.set_token('ID',to_char(p_prgm_ptr_types_rec.PROGRAM_TYPE_ID) );
749: FND_MESSAGE.set_token('ENTITY','Pgm_Tgt_Ptr_Typ');
750: FND_MSG_PUB.add;
751: x_return_status := FND_API.g_ret_sts_error;

Line 748: FND_MESSAGE.set_token('ID',to_char(p_prgm_ptr_types_rec.PROGRAM_TYPE_ID) );

744: );
745:
746: IF l_valid_flag = FND_API.g_false THEN
747: FND_MESSAGE.set_name('PV', 'PV_API_DUPLICATE_ENTITY');
748: FND_MESSAGE.set_token('ID',to_char(p_prgm_ptr_types_rec.PROGRAM_TYPE_ID) );
749: FND_MESSAGE.set_token('ENTITY','Pgm_Tgt_Ptr_Typ');
750: FND_MSG_PUB.add;
751: x_return_status := FND_API.g_ret_sts_error;
752: RETURN;

Line 749: FND_MESSAGE.set_token('ENTITY','Pgm_Tgt_Ptr_Typ');

745:
746: IF l_valid_flag = FND_API.g_false THEN
747: FND_MESSAGE.set_name('PV', 'PV_API_DUPLICATE_ENTITY');
748: FND_MESSAGE.set_token('ID',to_char(p_prgm_ptr_types_rec.PROGRAM_TYPE_ID) );
749: FND_MESSAGE.set_token('ENTITY','Pgm_Tgt_Ptr_Typ');
750: FND_MSG_PUB.add;
751: x_return_status := FND_API.g_ret_sts_error;
752: RETURN;
753: END IF;

Line 776: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

772: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
773:
774: IF p_prgm_ptr_types_rec.program_partner_types_id = FND_API.g_miss_num
775: OR p_prgm_ptr_types_rec.program_partner_types_id IS NULL THEN
776: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
777: FND_MESSAGE.set_token('COLUMN','PROGRAM_PARTNER_TYPES_ID');
778: FND_MSG_PUB.add;
779: x_return_status := FND_API.g_ret_sts_error;
780: RETURN;

Line 777: FND_MESSAGE.set_token('COLUMN','PROGRAM_PARTNER_TYPES_ID');

773:
774: IF p_prgm_ptr_types_rec.program_partner_types_id = FND_API.g_miss_num
775: OR p_prgm_ptr_types_rec.program_partner_types_id IS NULL THEN
776: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
777: FND_MESSAGE.set_token('COLUMN','PROGRAM_PARTNER_TYPES_ID');
778: FND_MSG_PUB.add;
779: x_return_status := FND_API.g_ret_sts_error;
780: RETURN;
781: END IF;

Line 786: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

782:
783:
784: IF p_prgm_ptr_types_rec.PROGRAM_TYPE_ID = FND_API.g_miss_num
785: OR p_prgm_ptr_types_rec.PROGRAM_TYPE_ID IS NULL THEN
786: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
787: FND_MESSAGE.set_token('COLUMN','PROGRAM_TYPE_ID');
788: FND_MSG_PUB.add;
789: x_return_status := FND_API.g_ret_sts_error;
790: RETURN;

Line 787: FND_MESSAGE.set_token('COLUMN','PROGRAM_TYPE_ID');

783:
784: IF p_prgm_ptr_types_rec.PROGRAM_TYPE_ID = FND_API.g_miss_num
785: OR p_prgm_ptr_types_rec.PROGRAM_TYPE_ID IS NULL THEN
786: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
787: FND_MESSAGE.set_token('COLUMN','PROGRAM_TYPE_ID');
788: FND_MSG_PUB.add;
789: x_return_status := FND_API.g_ret_sts_error;
790: RETURN;
791: END IF;

Line 796: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

792:
793:
794: IF p_prgm_ptr_types_rec.partner_type = FND_API.g_miss_char
795: OR p_prgm_ptr_types_rec.partner_type IS NULL THEN
796: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
797: FND_MESSAGE.set_token('COLUMN','PARTNER_TYPE');
798: FND_MSG_PUB.add;
799: x_return_status := FND_API.g_ret_sts_error;
800: RETURN;

Line 797: FND_MESSAGE.set_token('COLUMN','PARTNER_TYPE');

793:
794: IF p_prgm_ptr_types_rec.partner_type = FND_API.g_miss_char
795: OR p_prgm_ptr_types_rec.partner_type IS NULL THEN
796: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
797: FND_MESSAGE.set_token('COLUMN','PARTNER_TYPE');
798: FND_MSG_PUB.add;
799: x_return_status := FND_API.g_ret_sts_error;
800: RETURN;
801: END IF;

Line 806: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

802:
803:
804: IF p_prgm_ptr_types_rec.last_update_date = FND_API.g_miss_date
805: OR p_prgm_ptr_types_rec.last_update_date IS NULL THEN
806: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
807: FND_MESSAGE.set_token('COLUMN','LAST_UPDATE_DATE');
808: FND_MSG_PUB.add;
809: x_return_status := FND_API.g_ret_sts_error;
810: RETURN;

Line 807: FND_MESSAGE.set_token('COLUMN','LAST_UPDATE_DATE');

803:
804: IF p_prgm_ptr_types_rec.last_update_date = FND_API.g_miss_date
805: OR p_prgm_ptr_types_rec.last_update_date IS NULL THEN
806: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
807: FND_MESSAGE.set_token('COLUMN','LAST_UPDATE_DATE');
808: FND_MSG_PUB.add;
809: x_return_status := FND_API.g_ret_sts_error;
810: RETURN;
811: END IF;

Line 816: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

812:
813:
814: IF p_prgm_ptr_types_rec.last_updated_by = FND_API.g_miss_num
815: OR p_prgm_ptr_types_rec.last_updated_by IS NULL THEN
816: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
817: FND_MESSAGE.set_token('COLUMN','LAST_UPDATED_BY');
818: FND_MSG_PUB.add;
819: x_return_status := FND_API.g_ret_sts_error;
820: RETURN;

Line 817: FND_MESSAGE.set_token('COLUMN','LAST_UPDATED_BY');

813:
814: IF p_prgm_ptr_types_rec.last_updated_by = FND_API.g_miss_num
815: OR p_prgm_ptr_types_rec.last_updated_by IS NULL THEN
816: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
817: FND_MESSAGE.set_token('COLUMN','LAST_UPDATED_BY');
818: FND_MSG_PUB.add;
819: x_return_status := FND_API.g_ret_sts_error;
820: RETURN;
821: END IF;

Line 826: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

822:
823:
824: IF p_prgm_ptr_types_rec.creation_date = FND_API.g_miss_date
825: OR p_prgm_ptr_types_rec.creation_date IS NULL THEN
826: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
827: FND_MESSAGE.set_token('COLUMN','CREATION_DATE');
828: FND_MSG_PUB.add;
829: x_return_status := FND_API.g_ret_sts_error;
830: RETURN;

Line 827: FND_MESSAGE.set_token('COLUMN','CREATION_DATE');

823:
824: IF p_prgm_ptr_types_rec.creation_date = FND_API.g_miss_date
825: OR p_prgm_ptr_types_rec.creation_date IS NULL THEN
826: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
827: FND_MESSAGE.set_token('COLUMN','CREATION_DATE');
828: FND_MSG_PUB.add;
829: x_return_status := FND_API.g_ret_sts_error;
830: RETURN;
831: END IF;

Line 837: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

833:
834: IF p_prgm_ptr_types_rec.created_by = FND_API.g_miss_num
835: OR p_prgm_ptr_types_rec.created_by IS NULL THEN
836:
837: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
838: FND_MESSAGE.set_token('COLUMN','CREATED_BY');
839: FND_MSG_PUB.add;
840: x_return_status := FND_API.g_ret_sts_error;
841: RETURN;

Line 838: FND_MESSAGE.set_token('COLUMN','CREATED_BY');

834: IF p_prgm_ptr_types_rec.created_by = FND_API.g_miss_num
835: OR p_prgm_ptr_types_rec.created_by IS NULL THEN
836:
837: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
838: FND_MESSAGE.set_token('COLUMN','CREATED_BY');
839: FND_MSG_PUB.add;
840: x_return_status := FND_API.g_ret_sts_error;
841: RETURN;
842: END IF;

Line 847: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

843:
844:
845: IF p_prgm_ptr_types_rec.last_update_login = FND_API.g_miss_num
846: OR p_prgm_ptr_types_rec.last_update_login IS NULL THEN
847: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
848: FND_MESSAGE.set_token('COLUMN','LAST_UPDATE_LOGIN');
849: FND_MSG_PUB.add;
850: x_return_status := FND_API.g_ret_sts_error;
851: RETURN;

Line 848: FND_MESSAGE.set_token('COLUMN','LAST_UPDATE_LOGIN');

844:
845: IF p_prgm_ptr_types_rec.last_update_login = FND_API.g_miss_num
846: OR p_prgm_ptr_types_rec.last_update_login IS NULL THEN
847: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
848: FND_MESSAGE.set_token('COLUMN','LAST_UPDATE_LOGIN');
849: FND_MSG_PUB.add;
850: x_return_status := FND_API.g_ret_sts_error;
851: RETURN;
852: END IF;

Line 857: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

853:
854:
855: IF p_prgm_ptr_types_rec.object_version_number = FND_API.g_miss_num
856: OR p_prgm_ptr_types_rec.object_version_number IS NULL THEN
857: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
858: FND_MESSAGE.set_token('COLUMN','OBJECT_VERSION_NUMBER');
859: FND_MSG_PUB.add;
860: x_return_status := FND_API.g_ret_sts_error;
861: RETURN;

Line 858: FND_MESSAGE.set_token('COLUMN','OBJECT_VERSION_NUMBER');

854:
855: IF p_prgm_ptr_types_rec.object_version_number = FND_API.g_miss_num
856: OR p_prgm_ptr_types_rec.object_version_number IS NULL THEN
857: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
858: FND_MESSAGE.set_token('COLUMN','OBJECT_VERSION_NUMBER');
859: FND_MSG_PUB.add;
860: x_return_status := FND_API.g_ret_sts_error;
861: RETURN;
862: END IF;

Line 867: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

863: ELSE
864:
865:
866: IF p_prgm_ptr_types_rec.program_partner_types_id IS NULL THEN
867: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
868: FND_MESSAGE.set_token('COLUMN','PROGRAM_PARTNER_TYPES_ID');
869: FND_MSG_PUB.add;
870: x_return_status := FND_API.g_ret_sts_error;
871: RETURN;

Line 868: FND_MESSAGE.set_token('COLUMN','PROGRAM_PARTNER_TYPES_ID');

864:
865:
866: IF p_prgm_ptr_types_rec.program_partner_types_id IS NULL THEN
867: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
868: FND_MESSAGE.set_token('COLUMN','PROGRAM_PARTNER_TYPES_ID');
869: FND_MSG_PUB.add;
870: x_return_status := FND_API.g_ret_sts_error;
871: RETURN;
872: END IF;

Line 876: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

872: END IF;
873:
874:
875: IF p_prgm_ptr_types_rec.object_version_number IS NULL THEN
876: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
877: FND_MESSAGE.set_token('COLUMN','OBJECT_VERSION_NUMBER');
878: FND_MSG_PUB.add;
879: x_return_status := FND_API.g_ret_sts_error;
880: RETURN;

Line 877: FND_MESSAGE.set_token('COLUMN','OBJECT_VERSION_NUMBER');

873:
874:
875: IF p_prgm_ptr_types_rec.object_version_number IS NULL THEN
876: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
877: FND_MESSAGE.set_token('COLUMN','OBJECT_VERSION_NUMBER');
878: FND_MSG_PUB.add;
879: x_return_status := FND_API.g_ret_sts_error;
880: RETURN;
881: END IF;

Line 916: FND_MESSAGE.set_name('PV', 'PV_NOT_A_VALID_PRGM_PTR_TYPE');

912: ) = FND_API.g_false
913: THEN
914: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
915: THEN
916: FND_MESSAGE.set_name('PV', 'PV_NOT_A_VALID_PRGM_PTR_TYPE');
917: FND_MSG_PUB.add;
918: END IF;
919:
920: x_return_status := FND_API.g_ret_sts_error;