eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_DSS_GROUPS_PUB dependencies on FND_MESSAGE

Line 192: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');

188:
189: --validation for mandatory column dss_group_code
190: if (p_dss_group.dss_group_code is null or
191: p_dss_group.dss_group_code = fnd_api.g_miss_char) then
192: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
193: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'dss_group_code' );
194: FND_MSG_PUB.ADD;
195: RAISE FND_API.G_EXC_ERROR;
196: end if;

Line 193: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'dss_group_code' );

189: --validation for mandatory column dss_group_code
190: if (p_dss_group.dss_group_code is null or
191: p_dss_group.dss_group_code = fnd_api.g_miss_char) then
192: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
193: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'dss_group_code' );
194: FND_MSG_PUB.ADD;
195: RAISE FND_API.G_EXC_ERROR;
196: end if;
197:

Line 201: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');

197:
198: --validation for mandatory column dss_group_name
199: if (p_dss_group.dss_group_name is null or
200: p_dss_group.dss_group_name = fnd_api.g_miss_char) then
201: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
202: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'dss_group_name' );
203: FND_MSG_PUB.ADD;
204: RAISE FND_API.G_EXC_ERROR;
205: end if;

Line 202: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'dss_group_name' );

198: --validation for mandatory column dss_group_name
199: if (p_dss_group.dss_group_name is null or
200: p_dss_group.dss_group_name = fnd_api.g_miss_char) then
201: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
202: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'dss_group_name' );
203: FND_MSG_PUB.ADD;
204: RAISE FND_API.G_EXC_ERROR;
205: end if;
206:

Line 213: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_CODE_EXISTS_ALREADY');

209: -- VALIDATION
210: -- PASSED IN GROUP CODE SHOULD BE UNIQUE
211: IF HZ_DSS_VALIDATE_PKG.exist_in_dss_groups_b (p_dss_group.dss_group_code) = 'Y'
212: THEN
213: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_CODE_EXISTS_ALREADY');
214: FND_MSG_PUB.ADD;
215: RAISE FND_API.G_EXC_ERROR;
216: END IF;
217:

Line 226: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_ORD_BEF_GR_CODE_INVALID');

222: p_dss_group.order_before_group_code <> FND_API.G_MISS_CHAR
223: THEN
224: IF HZ_DSS_VALIDATE_PKG.exist_in_dss_groups_b (p_dss_group.order_before_group_code) = 'N'
225: THEN
226: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_ORD_BEF_GR_CODE_INVALID');
227: FND_MSG_PUB.ADD;
228: RAISE FND_API.G_EXC_ERROR;
229: END IF;
230: END IF;

Line 236: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_NAME_EXISTS_ALREADY');

232:
233: -- PASSED IN GROUP NAME SHOULD BE UNIQUE IN AN MLS LANGUAGE
234: IF HZ_DSS_VALIDATE_PKG.exist_in_dss_groups_vl (p_dss_group.dss_group_name) = 'Y'
235: THEN
236: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_NAME_EXISTS_ALREADY');
237: FND_MSG_PUB.ADD;
238: RAISE FND_API.G_EXC_ERROR;
239: END IF;
240:

Line 247: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_STATUS_VAL_INVALID');

243:
244: IF p_dss_group.status is not null then
245: IF HZ_DSS_VALIDATE_PKG.exist_in_ar_lookups(
246: p_dss_group.status, 'REGISTRY_STATUS')= 'N' THEN
247: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_STATUS_VAL_INVALID');
248: FND_MSG_PUB.ADD;
249: RAISE FND_API.G_EXC_ERROR;
250: END IF;
251: END IF;

Line 257: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_BES_FLAG_INVALID');

253: -- BES ENABLE FLAG SHOULD BE Y OR N
254: IF UPPER( NVL(p_dss_group.bes_enable_flag,'N') ) IN ('Y','N') THEN
255: NULL;
256: ELSE
257: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_BES_FLAG_INVALID');
258: FND_MSG_PUB.ADD;
259: RAISE FND_API.G_EXC_ERROR;
260: END IF;
261:

Line 321: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_OTHERS_EXCEP');

317:
318: WHEN OTHERS THEN
319: ROLLBACK TO create_group ;
320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
321: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_OTHERS_EXCEP');
322: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
323: FND_MSG_PUB.ADD;
324: FND_MSG_PUB.Count_And_Get(
325: p_encoded => FND_API.G_FALSE,

Line 322: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

318: WHEN OTHERS THEN
319: ROLLBACK TO create_group ;
320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
321: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_OTHERS_EXCEP');
322: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
323: FND_MSG_PUB.ADD;
324: FND_MSG_PUB.Count_And_Get(
325: p_encoded => FND_API.G_FALSE,
326: p_count => x_msg_count,

Line 386: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NONUPDATEABLE_TO_NULL');

382: --Non updateable to null
383: IF ( p_dss_group.dss_group_code IS NULL OR
384: p_dss_group.dss_group_code= FND_API.G_MISS_CHAR )
385: THEN
386: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NONUPDATEABLE_TO_NULL');
387: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'dss_group_code' );
388: FND_MSG_PUB.ADD;
389: RAISE FND_API.G_EXC_ERROR;
390: END IF;

Line 387: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'dss_group_code' );

383: IF ( p_dss_group.dss_group_code IS NULL OR
384: p_dss_group.dss_group_code= FND_API.G_MISS_CHAR )
385: THEN
386: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NONUPDATEABLE_TO_NULL');
387: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'dss_group_code' );
388: FND_MSG_PUB.ADD;
389: RAISE FND_API.G_EXC_ERROR;
390: END IF;
391:

Line 394: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NONUPDATEABLE_TO_NULL');

390: END IF;
391:
392: --Non updateable to null
393: IF p_dss_group.dss_group_name = FND_API.G_MISS_CHAR THEN
394: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NONUPDATEABLE_TO_NULL');
395: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'dss_group_name' );
396: FND_MSG_PUB.ADD;
397: RAISE FND_API.G_EXC_ERROR;
398: END IF;

Line 395: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'dss_group_name' );

391:
392: --Non updateable to null
393: IF p_dss_group.dss_group_name = FND_API.G_MISS_CHAR THEN
394: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NONUPDATEABLE_TO_NULL');
395: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'dss_group_name' );
396: FND_MSG_PUB.ADD;
397: RAISE FND_API.G_EXC_ERROR;
398: END IF;
399:

Line 401: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NONUPDATEABLE_TO_NULL');

397: RAISE FND_API.G_EXC_ERROR;
398: END IF;
399:
400: IF p_dss_group.bes_enable_flag = FND_API.G_MISS_CHAR THEN
401: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NONUPDATEABLE_TO_NULL');
402: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'bes_enable_flag' );
403: FND_MSG_PUB.ADD;
404: RAISE FND_API.G_EXC_ERROR;
405: END IF;

Line 402: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'bes_enable_flag' );

398: END IF;
399:
400: IF p_dss_group.bes_enable_flag = FND_API.G_MISS_CHAR THEN
401: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NONUPDATEABLE_TO_NULL');
402: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'bes_enable_flag' );
403: FND_MSG_PUB.ADD;
404: RAISE FND_API.G_EXC_ERROR;
405: END IF;
406:

Line 416: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_CODE_INVALID');

412: WHERE dss_group_code = p_dss_group.dss_group_code
413: FOR UPDATE NOWAIT;
414: EXCEPTION
415: WHEN NO_DATA_FOUND THEN
416: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_CODE_INVALID');
417: FND_MSG_PUB.ADD;
418: RAISE FND_API.G_EXC_ERROR;
419: END;
420:

Line 425: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');

421: IF NOT ((x_object_version_number IS NULL AND
422: l_object_version_number IS NULL) OR
423: (x_object_version_number = l_object_version_number))
424: THEN
425: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
426: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_DSS_GROUPS');
427: FND_MSG_PUB.ADD;
428: RAISE FND_API.G_EXC_ERROR;
429: END IF;

Line 426: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_DSS_GROUPS');

422: l_object_version_number IS NULL) OR
423: (x_object_version_number = l_object_version_number))
424: THEN
425: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
426: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_DSS_GROUPS');
427: FND_MSG_PUB.ADD;
428: RAISE FND_API.G_EXC_ERROR;
429: END IF;
430:

Line 438: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_CODE_INVALID');

434: -- PASSED IN GROUP CODE SHOULD BE VALID
435: -- already validated when getting object_version_number.
436: /*
437: IF HZ_DSS_VALIDATE_PKG.exist_in_dss_groups_b (p_dss_group.dss_group_code) = 'N' THEN
438: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_CODE_INVALID');
439: FND_MSG_PUB.ADD;
440: RAISE FND_API.G_EXC_ERROR;
441: END IF;
442: */

Line 453: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_ORD_BEF_GR_CODE_INVALID');

449: THEN
450: IF HZ_DSS_VALIDATE_PKG.exist_in_dss_groups_b (
451: p_dss_group.order_before_group_code) = 'N'
452: THEN
453: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_ORD_BEF_GR_CODE_INVALID');
454: FND_MSG_PUB.ADD;
455: RAISE FND_API.G_EXC_ERROR;
456: END IF;
457: END IF;

Line 464: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_NAME_EXISTS_ALREADY');

460: IF p_dss_group.dss_group_name IS NOT NULL THEN
461: IF HZ_DSS_VALIDATE_PKG.exist_in_dss_groups_vl (
462: p_dss_group.dss_group_name, p_dss_group.dss_group_code) = 'Y'
463: THEN
464: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_NAME_EXISTS_ALREADY');
465: FND_MSG_PUB.ADD;
466: RAISE FND_API.G_EXC_ERROR;
467: END IF;
468: END IF;

Line 477: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_STATUS_VAL_INVALID');

473: IF HZ_DSS_VALIDATE_PKG.exist_in_ar_lookups(
474: p_dss_group.status,
475: 'REGISTRY_STATUS')= 'N'
476: THEN
477: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_STATUS_VAL_INVALID');
478: FND_MSG_PUB.ADD;
479: RAISE FND_API.G_EXC_ERROR;
480: END IF;
481: END IF;

Line 488: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_BES_FLAG_INVALID');

484: IF p_dss_group.bes_enable_flag IS NOT NULL THEN
485: IF p_dss_group.bes_enable_flag <> 'Y' AND
486: p_dss_group.bes_enable_flag <> 'N'
487: THEN
488: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_BES_FLAG_INVALID');
489: FND_MSG_PUB.ADD;
490: RAISE FND_API.G_EXC_ERROR;
491: END IF;
492: END IF;

Line 599: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_OTHERS_EXCEP');

595: WHEN OTHERS THEN
596: ROLLBACK TO update_group ;
597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
598:
599: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_OTHERS_EXCEP');
600: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
601: FND_MSG_PUB.ADD;
602: FND_MSG_PUB.Count_And_Get(
603: p_encoded => FND_API.G_FALSE,

Line 600: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

596: ROLLBACK TO update_group ;
597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
598:
599: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_OTHERS_EXCEP');
600: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
601: FND_MSG_PUB.ADD;
602: FND_MSG_PUB.Count_And_Get(
603: p_encoded => FND_API.G_FALSE,
604: p_count => x_msg_count,

Line 658: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');

654:
655: --mandatory fields
656: IF (p_dss_secured_module.dss_group_code is null OR
657: p_dss_secured_module.dss_group_code = FND_API.G_MISS_CHAR) THEN
658: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
659: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'dss_group_code' );
660: FND_MSG_PUB.ADD;
661: RAISE FND_API.G_EXC_ERROR;
662: END IF;

Line 659: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'dss_group_code' );

655: --mandatory fields
656: IF (p_dss_secured_module.dss_group_code is null OR
657: p_dss_secured_module.dss_group_code = FND_API.G_MISS_CHAR) THEN
658: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
659: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'dss_group_code' );
660: FND_MSG_PUB.ADD;
661: RAISE FND_API.G_EXC_ERROR;
662: END IF;
663:

Line 666: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');

662: END IF;
663:
664: IF (p_dss_secured_module.created_by_module is null OR
665: p_dss_secured_module.created_by_module = FND_API.G_MISS_CHAR) THEN
666: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
667: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'created_by_module' );
668: FND_MSG_PUB.ADD;
669: RAISE FND_API.G_EXC_ERROR;
670: END IF;

Line 667: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'created_by_module' );

663:
664: IF (p_dss_secured_module.created_by_module is null OR
665: p_dss_secured_module.created_by_module = FND_API.G_MISS_CHAR) THEN
666: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
667: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'created_by_module' );
668: FND_MSG_PUB.ADD;
669: RAISE FND_API.G_EXC_ERROR;
670: END IF;
671:

Line 677: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_CODE_INVALID');

673: -- DSG validation
674: IF HZ_DSS_VALIDATE_PKG.exist_in_dss_groups_b (
675: p_dss_secured_module.dss_group_code) = 'N'
676: THEN
677: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_CODE_INVALID');
678: FND_MSG_PUB.ADD;
679: RAISE FND_API.G_EXC_ERROR;
680: END IF;
681:

Line 686: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_STATUS_VAL_INVALID');

682: -- status validation
683: IF p_dss_secured_module.status is not null then
684: IF HZ_DSS_VALIDATE_PKG.exist_in_ar_lookups(
685: p_dss_secured_module.status, 'REGISTRY_STATUS')= 'N' THEN
686: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_STATUS_VAL_INVALID');
687: FND_MSG_PUB.ADD;
688: RAISE FND_API.G_EXC_ERROR;
689: END IF;
690: END IF;

Line 696: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_CREATED_MODULE_INVALID');

692: ---created_by_module validation
693: IF HZ_DSS_VALIDATE_PKG.exist_in_ar_lookups_gl(
694: p_dss_secured_module.created_by_module, 'HZ_CREATED_BY_MODULES') ='N'
695: THEN
696: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_CREATED_MODULE_INVALID');
697: FND_MSG_PUB.ADD;
698: RAISE FND_API.G_EXC_ERROR;
699: END IF;
700:

Line 712: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_DUP_CRITERIA_MODULE');

708: and owner_table_id1 = 'HZ_CREATED_BY_MODULES'
709: and owner_table_id2 = p_dss_secured_module.created_by_module;
710:
711: if l_dup_count >= 1 then
712: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_DUP_CRITERIA_MODULE');
713: FND_MESSAGE.SET_TOKEN('MODULE', p_dss_secured_module.created_by_module);
714: FND_MSG_PUB.ADD;
715: RAISE FND_API.G_EXC_ERROR;
716: END IF;

Line 713: FND_MESSAGE.SET_TOKEN('MODULE', p_dss_secured_module.created_by_module);

709: and owner_table_id2 = p_dss_secured_module.created_by_module;
710:
711: if l_dup_count >= 1 then
712: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_DUP_CRITERIA_MODULE');
713: FND_MESSAGE.SET_TOKEN('MODULE', p_dss_secured_module.created_by_module);
714: FND_MSG_PUB.ADD;
715: RAISE FND_API.G_EXC_ERROR;
716: END IF;
717:

Line 757: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_OTHERS_EXCEP');

753:
754: WHEN OTHERS THEN
755: ROLLBACK TO create_secured_module ;
756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
757: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_OTHERS_EXCEP');
758: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
759: FND_MSG_PUB.ADD;
760: FND_MSG_PUB.Count_And_Get(
761: p_encoded => FND_API.G_FALSE,

Line 758: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

754: WHEN OTHERS THEN
755: ROLLBACK TO create_secured_module ;
756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
757: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_OTHERS_EXCEP');
758: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
759: FND_MSG_PUB.ADD;
760: FND_MSG_PUB.Count_And_Get(
761: p_encoded => FND_API.G_FALSE,
762: p_count => x_msg_count,

Line 822: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_ITEM_ID_INVALID');

818: WHERE secured_item_id = p_dss_secured_module.secured_item_id
819: FOR UPDATE NOWAIT;
820: EXCEPTION
821: WHEN NO_DATA_FOUND THEN
822: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_ITEM_ID_INVALID');
823: FND_MSG_PUB.ADD;
824: RAISE FND_API.G_EXC_ERROR;
825: END;
826:

Line 831: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');

827:
828: IF NOT ((x_object_version_number is null and l_object_version_number is null)
829: OR (x_object_version_number = l_object_version_number))
830: THEN
831: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
832: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_DSS_CRITERIA');
833: FND_MSG_PUB.ADD;
834: RAISE FND_API.G_EXC_ERROR;
835: END IF;

Line 832: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_DSS_CRITERIA');

828: IF NOT ((x_object_version_number is null and l_object_version_number is null)
829: OR (x_object_version_number = l_object_version_number))
830: THEN
831: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
832: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_DSS_CRITERIA');
833: FND_MSG_PUB.ADD;
834: RAISE FND_API.G_EXC_ERROR;
835: END IF;
836:

Line 844: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DSS_CRITERIA_IMMUTABLE' );

840: IF ( p_dss_secured_module.dss_group_code <> FND_API.G_MISS_CHAR OR
841: l_dss_group_code IS NOT NULL )
842: AND ( l_dss_group_code IS NULL OR
843: p_dss_secured_module.dss_group_code <> l_dss_group_code ) THEN
844: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DSS_CRITERIA_IMMUTABLE' );
845: FND_MSG_PUB.ADD;
846: RAISE FND_API.G_EXC_ERROR;
847: END IF;
848:

Line 854: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DSS_CRITERIA_IMMUTABLE' );

850: IF ( p_dss_secured_module.created_by_module <> FND_API.G_MISS_CHAR OR
851: l_created_by_module IS NOT NULL )
852: AND ( l_created_by_module IS NULL OR
853: p_dss_secured_module.created_by_module <> l_created_by_module ) THEN
854: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DSS_CRITERIA_IMMUTABLE' );
855: FND_MSG_PUB.ADD;
856: RAISE FND_API.G_EXC_ERROR;
857: END IF;
858:

Line 863: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_STATUS_VAL_INVALID');

859: -- status validation
860: IF p_dss_secured_module.status is not null then
861: IF HZ_DSS_VALIDATE_PKG.exist_in_ar_lookups(
862: p_dss_secured_module.status, 'REGISTRY_STATUS')= 'N' THEN
863: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_STATUS_VAL_INVALID');
864: FND_MSG_PUB.ADD;
865: RAISE FND_API.G_EXC_ERROR;
866: END IF;
867: END IF;

Line 875: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_CREATED_MODULE_INVALID');

871: IF p_dss_secured_module.created_by_module is not null then
872: IF HZ_DSS_VALIDATE_PKG.exist_in_ar_lookups(
873: p_dss_secured_module.created_by_module, 'HZ_CREATED_BY_MODULES') ='N'
874: THEN
875: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_CREATED_MODULE_INVALID');
876: FND_MSG_PUB.ADD;
877: RAISE FND_API.G_EXC_ERROR;
878: END IF;
879: END IF;

Line 919: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_OTHERS_EXCEP');

915:
916: WHEN OTHERS THEN
917: ROLLBACK TO update_secured_module ;
918: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
919: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_OTHERS_EXCEP');
920: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
921: FND_MSG_PUB.ADD;
922: FND_MSG_PUB.Count_And_Get(
923: p_encoded => FND_API.G_FALSE,

Line 920: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

916: WHEN OTHERS THEN
917: ROLLBACK TO update_secured_module ;
918: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
919: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_OTHERS_EXCEP');
920: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
921: FND_MSG_PUB.ADD;
922: FND_MSG_PUB.Count_And_Get(
923: p_encoded => FND_API.G_FALSE,
924: p_count => x_msg_count,

Line 1002: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');

998:
999: --mandatory dss_group
1000: IF (p_dss_secured_criterion.dss_group_code is null OR
1001: p_dss_secured_criterion.dss_group_code = FND_API.G_MISS_CHAR) THEN
1002: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
1003: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'dss_group_code' );
1004: FND_MSG_PUB.ADD;
1005: RAISE FND_API.G_EXC_ERROR;
1006: END IF;

Line 1003: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'dss_group_code' );

999: --mandatory dss_group
1000: IF (p_dss_secured_criterion.dss_group_code is null OR
1001: p_dss_secured_criterion.dss_group_code = FND_API.G_MISS_CHAR) THEN
1002: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
1003: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'dss_group_code' );
1004: FND_MSG_PUB.ADD;
1005: RAISE FND_API.G_EXC_ERROR;
1006: END IF;
1007:

Line 1013: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_CODE_INVALID');

1009: -- PASSED IN GROUP CODE SHOULD BE VALID
1010: IF HZ_DSS_VALIDATE_PKG.exist_in_dss_groups_b (
1011: p_dss_secured_criterion.dss_group_code) = 'N'
1012: THEN
1013: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_CODE_INVALID');
1014: FND_MSG_PUB.ADD;
1015: RAISE FND_API.G_EXC_ERROR;
1016: END IF;
1017:

Line 1022: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_STATUS_VAL_INVALID');

1018: -- STATUS VALIDATION
1019: IF p_dss_secured_criterion.status is not null then
1020: IF HZ_DSS_VALIDATE_PKG.exist_in_ar_lookups(
1021: p_dss_secured_criterion.status, 'REGISTRY_STATUS')= 'N' THEN
1022: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_STATUS_VAL_INVALID');
1023: FND_MSG_PUB.ADD;
1024: RAISE FND_API.G_EXC_ERROR;
1025: END IF;
1026: END IF;

Line 1069: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_OTHERS_EXCEP');

1065:
1066: WHEN OTHERS THEN
1067: ROLLBACK TO create_secured_criterion ;
1068: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1069: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_OTHERS_EXCEP');
1070: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1071: FND_MSG_PUB.ADD;
1072: FND_MSG_PUB.Count_And_Get(
1073: p_encoded => FND_API.G_FALSE,

Line 1070: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

1066: WHEN OTHERS THEN
1067: ROLLBACK TO create_secured_criterion ;
1068: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1069: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_OTHERS_EXCEP');
1070: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1071: FND_MSG_PUB.ADD;
1072: FND_MSG_PUB.Count_And_Get(
1073: p_encoded => FND_API.G_FALSE,
1074: p_count => x_msg_count,

Line 1134: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_ITEM_ID_INVALID');

1130: WHERE secured_item_id = p_dss_secured_criterion.secured_item_id
1131: FOR UPDATE NOWAIT;
1132: EXCEPTION
1133: WHEN NO_DATA_FOUND THEN
1134: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_ITEM_ID_INVALID');
1135: FND_MSG_PUB.ADD;
1136: RAISE FND_API.G_EXC_ERROR;
1137: END;
1138:

Line 1143: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');

1139:
1140: IF NOT ((x_object_version_number is null and l_object_version_number is null)
1141: OR (x_object_version_number = l_object_version_number))
1142: THEN
1143: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1144: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_DSS_CRITERIA');
1145: FND_MSG_PUB.ADD;
1146: RAISE FND_API.G_EXC_ERROR;
1147: END IF;

Line 1144: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_DSS_CRITERIA');

1140: IF NOT ((x_object_version_number is null and l_object_version_number is null)
1141: OR (x_object_version_number = l_object_version_number))
1142: THEN
1143: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1144: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_DSS_CRITERIA');
1145: FND_MSG_PUB.ADD;
1146: RAISE FND_API.G_EXC_ERROR;
1147: END IF;
1148:

Line 1182: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_STATUS_VAL_INVALID');

1178: IF p_dss_secured_criterion.status is not null then
1179: IF HZ_DSS_VALIDATE_PKG.exist_in_ar_lookups(
1180: p_dss_secured_criterion.status, 'REGISTRY_STATUS')= 'N'
1181: THEN
1182: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_STATUS_VAL_INVALID');
1183: FND_MSG_PUB.ADD;
1184: RAISE FND_API.G_EXC_ERROR;
1185: END IF;
1186: END IF;

Line 1229: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_OTHERS_EXCEP');

1225:
1226: WHEN OTHERS THEN
1227: ROLLBACK TO update_secured_criterion ;
1228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1229: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_OTHERS_EXCEP');
1230: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1231: FND_MSG_PUB.ADD;
1232: FND_MSG_PUB.Count_And_Get(
1233: p_encoded => FND_API.G_FALSE,

Line 1230: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

1226: WHEN OTHERS THEN
1227: ROLLBACK TO update_secured_criterion ;
1228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1229: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_OTHERS_EXCEP');
1230: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1231: FND_MSG_PUB.ADD;
1232: FND_MSG_PUB.Count_And_Get(
1233: p_encoded => FND_API.G_FALSE,
1234: p_count => x_msg_count,

Line 1291: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');

1287:
1288: --mandatory fields
1289: IF (p_dss_secured_class.dss_group_code is null OR
1290: p_dss_secured_class.dss_group_code = FND_API.G_MISS_CHAR) THEN
1291: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
1292: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'dss_group_code' );
1293: FND_MSG_PUB.ADD;
1294: RAISE FND_API.G_EXC_ERROR;
1295: END IF;

Line 1292: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'dss_group_code' );

1288: --mandatory fields
1289: IF (p_dss_secured_class.dss_group_code is null OR
1290: p_dss_secured_class.dss_group_code = FND_API.G_MISS_CHAR) THEN
1291: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
1292: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'dss_group_code' );
1293: FND_MSG_PUB.ADD;
1294: RAISE FND_API.G_EXC_ERROR;
1295: END IF;
1296:

Line 1299: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');

1295: END IF;
1296:
1297: IF (p_dss_secured_class.class_category is null OR
1298: p_dss_secured_class.class_category = FND_API.G_MISS_CHAR) THEN
1299: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
1300: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'class_category' );
1301: FND_MSG_PUB.ADD;
1302: RAISE FND_API.G_EXC_ERROR;
1303: END IF;

Line 1300: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'class_category' );

1296:
1297: IF (p_dss_secured_class.class_category is null OR
1298: p_dss_secured_class.class_category = FND_API.G_MISS_CHAR) THEN
1299: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
1300: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'class_category' );
1301: FND_MSG_PUB.ADD;
1302: RAISE FND_API.G_EXC_ERROR;
1303: END IF;
1304:

Line 1307: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');

1303: END IF;
1304:
1305: IF (p_dss_secured_class.class_code is null OR
1306: p_dss_secured_class.class_code = FND_API.G_MISS_CHAR) THEN
1307: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
1308: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'class_code' );
1309: FND_MSG_PUB.ADD;
1310: RAISE FND_API.G_EXC_ERROR;
1311: END IF;

Line 1308: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'class_code' );

1304:
1305: IF (p_dss_secured_class.class_code is null OR
1306: p_dss_secured_class.class_code = FND_API.G_MISS_CHAR) THEN
1307: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
1308: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'class_code' );
1309: FND_MSG_PUB.ADD;
1310: RAISE FND_API.G_EXC_ERROR;
1311: END IF;
1312:

Line 1318: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_CODE_INVALID');

1314:
1315: -- PASSED IN GROUP CODE SHOULD BE VALID
1316: IF HZ_DSS_VALIDATE_PKG.exist_in_dss_groups_b (p_dss_secured_class.dss_group_code) = 'N'
1317: THEN
1318: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_CODE_INVALID');
1319: FND_MSG_PUB.ADD;
1320: RAISE FND_API.G_EXC_ERROR;
1321: END IF;
1322:

Line 1326: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_CL_CATEGORY_INVALID');

1322:
1323: -- PASSED IN CLASS CATEGORY SHOULD BE VALID
1324: IF HZ_DSS_VALIDATE_PKG.exist_in_hz_class_categories (p_dss_secured_class.class_category) = 'N'
1325: THEN
1326: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_CL_CATEGORY_INVALID');
1327: FND_MSG_PUB.ADD;
1328: RAISE FND_API.G_EXC_ERROR;
1329: END IF;
1330:

Line 1334: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_CL_CODE_INVALID');

1330:
1331: -- PASSED IN CLASS CODE SHOULD BE VALID
1332: IF HZ_DSS_VALIDATE_PKG.exist_in_fnd_lookups(p_dss_secured_class.class_code,p_dss_secured_class.class_category ) = 'N'
1333: THEN
1334: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_CL_CODE_INVALID');
1335: FND_MSG_PUB.ADD;
1336: RAISE FND_API.G_EXC_ERROR;
1337: END IF;
1338:

Line 1344: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_STATUS_VAL_INVALID');

1340: -- STATUS VALIDATION
1341: IF p_dss_secured_class.status is not null then
1342: IF HZ_DSS_VALIDATE_PKG.exist_in_ar_lookups(p_dss_secured_class.status,
1343: 'REGISTRY_STATUS')= 'N' THEN
1344: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_STATUS_VAL_INVALID');
1345: FND_MSG_PUB.ADD;
1346: RAISE FND_API.G_EXC_ERROR;
1347: END IF;
1348: END IF;

Line 1361: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_DUP_CRITERIA_CLASS');

1357: and owner_table_id1 = p_dss_secured_class.class_category
1358: and owner_table_id2 = p_dss_secured_class.class_code;
1359:
1360: if l_dup_count >= 1 then
1361: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_DUP_CRITERIA_CLASS');
1362: FND_MESSAGE.SET_TOKEN('CATEGORY', p_dss_secured_class.class_category);
1363: FND_MESSAGE.SET_TOKEN('CLASS', p_dss_secured_class.class_code);
1364: FND_MSG_PUB.ADD;
1365: RAISE FND_API.G_EXC_ERROR;

Line 1362: FND_MESSAGE.SET_TOKEN('CATEGORY', p_dss_secured_class.class_category);

1358: and owner_table_id2 = p_dss_secured_class.class_code;
1359:
1360: if l_dup_count >= 1 then
1361: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_DUP_CRITERIA_CLASS');
1362: FND_MESSAGE.SET_TOKEN('CATEGORY', p_dss_secured_class.class_category);
1363: FND_MESSAGE.SET_TOKEN('CLASS', p_dss_secured_class.class_code);
1364: FND_MSG_PUB.ADD;
1365: RAISE FND_API.G_EXC_ERROR;
1366: END IF;

Line 1363: FND_MESSAGE.SET_TOKEN('CLASS', p_dss_secured_class.class_code);

1359:
1360: if l_dup_count >= 1 then
1361: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_DUP_CRITERIA_CLASS');
1362: FND_MESSAGE.SET_TOKEN('CATEGORY', p_dss_secured_class.class_category);
1363: FND_MESSAGE.SET_TOKEN('CLASS', p_dss_secured_class.class_code);
1364: FND_MSG_PUB.ADD;
1365: RAISE FND_API.G_EXC_ERROR;
1366: END IF;
1367:

Line 1407: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_OTHERS_EXCEP');

1403:
1404: WHEN OTHERS THEN
1405: ROLLBACK TO create_secured_classification ;
1406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1407: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_OTHERS_EXCEP');
1408: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1409: FND_MSG_PUB.ADD;
1410: FND_MSG_PUB.Count_And_Get(
1411: p_encoded => FND_API.G_FALSE,

Line 1408: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

1404: WHEN OTHERS THEN
1405: ROLLBACK TO create_secured_classification ;
1406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1407: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_OTHERS_EXCEP');
1408: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1409: FND_MSG_PUB.ADD;
1410: FND_MSG_PUB.Count_And_Get(
1411: p_encoded => FND_API.G_FALSE,
1412: p_count => x_msg_count,

Line 1479: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_ITEM_ID_INVALID');

1475: WHERE secured_item_id = p_dss_secured_class.secured_item_id
1476: FOR UPDATE NOWAIT;
1477: EXCEPTION
1478: WHEN NO_DATA_FOUND THEN
1479: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_ITEM_ID_INVALID');
1480: FND_MSG_PUB.ADD;
1481: RAISE FND_API.G_EXC_ERROR;
1482: END;
1483:

Line 1487: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');

1483:
1484: IF NOT ((x_object_version_number is null and l_object_version_number is null)
1485: OR (x_object_version_number = l_object_version_number))
1486: THEN
1487: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1488: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_DSS_CRITERIA');
1489: FND_MSG_PUB.ADD;
1490: RAISE FND_API.G_EXC_ERROR;
1491: END IF;

Line 1488: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_DSS_CRITERIA');

1484: IF NOT ((x_object_version_number is null and l_object_version_number is null)
1485: OR (x_object_version_number = l_object_version_number))
1486: THEN
1487: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1488: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_DSS_CRITERIA');
1489: FND_MSG_PUB.ADD;
1490: RAISE FND_API.G_EXC_ERROR;
1491: END IF;
1492:

Line 1501: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DSS_CRITERIA_IMMUTABLE' );

1497: IF ( p_dss_secured_class.dss_group_code <> FND_API.G_MISS_CHAR OR
1498: l_dss_group_code IS NOT NULL )
1499: AND ( l_dss_group_code IS NULL OR
1500: p_dss_secured_class.dss_group_code <> l_dss_group_code ) THEN
1501: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DSS_CRITERIA_IMMUTABLE' );
1502: FND_MSG_PUB.ADD;
1503: RAISE FND_API.G_EXC_ERROR;
1504: END IF;
1505:

Line 1511: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DSS_CRITERIA_IMMUTABLE' );

1507: IF ( p_dss_secured_class.class_category <> FND_API.G_MISS_CHAR OR
1508: l_class_category IS NOT NULL )
1509: AND ( l_class_category IS NULL OR
1510: p_dss_secured_class.class_category <> l_class_category ) THEN
1511: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DSS_CRITERIA_IMMUTABLE' );
1512: FND_MSG_PUB.ADD;
1513: RAISE FND_API.G_EXC_ERROR;
1514: END IF;
1515:

Line 1520: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DSS_CRITERIA_IMMUTABLE' );

1516: IF ( p_dss_secured_class.class_code <> FND_API.G_MISS_CHAR OR
1517: l_class_code IS NOT NULL )
1518: AND ( l_class_code IS NULL OR
1519: p_dss_secured_class.class_code <> l_class_code ) THEN
1520: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DSS_CRITERIA_IMMUTABLE' );
1521: FND_MSG_PUB.ADD;
1522: RAISE FND_API.G_EXC_ERROR;
1523: END IF;
1524:

Line 1530: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_STATUS_VAL_INVALID');

1526: -- STATUS VALIDATION
1527: IF p_dss_secured_class.status is not null then
1528: IF HZ_DSS_VALIDATE_PKG.exist_in_ar_lookups(p_dss_secured_class.status,
1529: 'REGISTRY_STATUS')= 'N' THEN
1530: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_STATUS_VAL_INVALID');
1531: FND_MSG_PUB.ADD;
1532: RAISE FND_API.G_EXC_ERROR;
1533: END IF;
1534: END IF;

Line 1573: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_OTHERS_EXCEP');

1569:
1570: WHEN OTHERS THEN
1571: ROLLBACK TO update_secured_classification ;
1572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1573: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_OTHERS_EXCEP');
1574: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1575: FND_MSG_PUB.ADD;
1576: FND_MSG_PUB.Count_And_Get(
1577: p_encoded => FND_API.G_FALSE,

Line 1574: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

1570: WHEN OTHERS THEN
1571: ROLLBACK TO update_secured_classification ;
1572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1573: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_OTHERS_EXCEP');
1574: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1575: FND_MSG_PUB.ADD;
1576: FND_MSG_PUB.Count_And_Get(
1577: p_encoded => FND_API.G_FALSE,
1578: p_count => x_msg_count,

Line 1637: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');

1633:
1634: -- VALIDATION of mandatory fields
1635: IF (p_dss_secured_rel_type.dss_group_code is null OR
1636: p_dss_secured_rel_type.dss_group_code = FND_API.G_MISS_CHAR) THEN
1637: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
1638: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'dss_group_code' );
1639: FND_MSG_PUB.ADD;
1640: RAISE FND_API.G_EXC_ERROR;
1641: END IF;

Line 1638: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'dss_group_code' );

1634: -- VALIDATION of mandatory fields
1635: IF (p_dss_secured_rel_type.dss_group_code is null OR
1636: p_dss_secured_rel_type.dss_group_code = FND_API.G_MISS_CHAR) THEN
1637: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
1638: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'dss_group_code' );
1639: FND_MSG_PUB.ADD;
1640: RAISE FND_API.G_EXC_ERROR;
1641: END IF;
1642:

Line 1645: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');

1641: END IF;
1642:
1643: IF (p_dss_secured_rel_type.relationship_type_id is null OR
1644: p_dss_secured_rel_type.relationship_type_id = FND_API.G_MISS_NUM) THEN
1645: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
1646: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'relationship_type_id' );
1647: FND_MSG_PUB.ADD;
1648: RAISE FND_API.G_EXC_ERROR;
1649: END IF;

Line 1646: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'relationship_type_id' );

1642:
1643: IF (p_dss_secured_rel_type.relationship_type_id is null OR
1644: p_dss_secured_rel_type.relationship_type_id = FND_API.G_MISS_NUM) THEN
1645: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
1646: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'relationship_type_id' );
1647: FND_MSG_PUB.ADD;
1648: RAISE FND_API.G_EXC_ERROR;
1649: END IF;
1650:

Line 1656: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_CODE_INVALID');

1652:
1653: -- PASSED IN GROUP CODE SHOULD BE VALID
1654: IF HZ_DSS_VALIDATE_PKG.exist_in_dss_groups_b (p_dss_secured_rel_type.dss_group_code) = 'N'
1655: THEN
1656: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_CODE_INVALID');
1657: FND_MSG_PUB.ADD;
1658: RAISE FND_API.G_EXC_ERROR;
1659: END IF;
1660:

Line 1664: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_REL_TYPE_ID_INVALID');

1660:
1661: -- PASSED IN RELATIONSHIP_TYPE_ID SHOULD BE VALID
1662: IF HZ_DSS_VALIDATE_PKG.exist_in_hz_relationship_types (p_dss_secured_rel_type.relationship_type_id) = 'N'
1663: THEN
1664: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_REL_TYPE_ID_INVALID');
1665: FND_MSG_PUB.ADD;
1666: RAISE FND_API.G_EXC_ERROR;
1667: END IF;
1668:

Line 1674: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_STATUS_VAL_INVALID');

1670: -- STATUS VALIDATION
1671: IF p_dss_secured_rel_type.status is not null then
1672: IF HZ_DSS_VALIDATE_PKG.exist_in_ar_lookups(p_dss_secured_rel_type.status,
1673: 'REGISTRY_STATUS')= 'N' THEN
1674: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_STATUS_VAL_INVALID');
1675: FND_MSG_PUB.ADD;
1676: RAISE FND_API.G_EXC_ERROR;
1677: END IF;
1678: END IF;

Line 1695: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_DUP_CRITERIA_REL');

1691: select relationship_type into l_rel_type
1692: from HZ_RELATIONSHIP_TYPES
1693: where relationship_type_id = p_dss_secured_rel_type.relationship_type_id;
1694:
1695: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_DUP_CRITERIA_REL');
1696: FND_MESSAGE.SET_TOKEN('RELROLE', l_rel_type);
1697: FND_MSG_PUB.ADD;
1698: RAISE FND_API.G_EXC_ERROR;
1699: END IF;

Line 1696: FND_MESSAGE.SET_TOKEN('RELROLE', l_rel_type);

1692: from HZ_RELATIONSHIP_TYPES
1693: where relationship_type_id = p_dss_secured_rel_type.relationship_type_id;
1694:
1695: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_DUP_CRITERIA_REL');
1696: FND_MESSAGE.SET_TOKEN('RELROLE', l_rel_type);
1697: FND_MSG_PUB.ADD;
1698: RAISE FND_API.G_EXC_ERROR;
1699: END IF;
1700:

Line 1739: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_OTHERS_EXCEP');

1735:
1736: WHEN OTHERS THEN
1737: ROLLBACK TO create_secured_rel_type ;
1738: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1739: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_OTHERS_EXCEP');
1740: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1741: FND_MSG_PUB.ADD;
1742: FND_MSG_PUB.Count_And_Get(
1743: p_encoded => FND_API.G_FALSE,

Line 1740: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

1736: WHEN OTHERS THEN
1737: ROLLBACK TO create_secured_rel_type ;
1738: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1739: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_OTHERS_EXCEP');
1740: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1741: FND_MSG_PUB.ADD;
1742: FND_MSG_PUB.Count_And_Get(
1743: p_encoded => FND_API.G_FALSE,
1744: p_count => x_msg_count,

Line 1807: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_ITEM_ID_INVALID');

1803: WHERE secured_item_id = p_dss_secured_rel_type.secured_item_id
1804: FOR UPDATE NOWAIT;
1805: EXCEPTION
1806: WHEN NO_DATA_FOUND THEN
1807: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_ITEM_ID_INVALID');
1808: FND_MSG_PUB.ADD;
1809: RAISE FND_API.G_EXC_ERROR;
1810: END;
1811:

Line 1815: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');

1811:
1812: IF NOT ((x_object_version_number is null and l_object_version_number is null)
1813: OR (x_object_version_number = l_object_version_number))
1814: THEN
1815: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1816: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_DSS_CRITERIA');
1817: FND_MSG_PUB.ADD;
1818: RAISE FND_API.G_EXC_ERROR;
1819: END IF;

Line 1816: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_DSS_CRITERIA');

1812: IF NOT ((x_object_version_number is null and l_object_version_number is null)
1813: OR (x_object_version_number = l_object_version_number))
1814: THEN
1815: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1816: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_DSS_CRITERIA');
1817: FND_MSG_PUB.ADD;
1818: RAISE FND_API.G_EXC_ERROR;
1819: END IF;
1820:

Line 1828: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DSS_CRITERIA_IMMUTABLE' );

1824: IF ( p_dss_secured_rel_type.dss_group_code <> FND_API.G_MISS_CHAR OR
1825: l_dss_group_code IS NOT NULL )
1826: AND ( l_dss_group_code IS NULL OR
1827: p_dss_secured_rel_type.dss_group_code <> l_dss_group_code ) THEN
1828: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DSS_CRITERIA_IMMUTABLE' );
1829: FND_MSG_PUB.ADD;
1830: RAISE FND_API.G_EXC_ERROR;
1831: END IF;
1832:

Line 1839: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DSS_CRITERIA_IMMUTABLE' );

1835: l_relationship_type_id IS NOT NULL )
1836: AND ( l_relationship_type_id IS NULL OR
1837: p_dss_secured_rel_type.relationship_type_id <> l_relationship_type_id )
1838: THEN
1839: FND_MESSAGE.SET_NAME( 'AR', 'HZ_DSS_CRITERIA_IMMUTABLE' );
1840: FND_MSG_PUB.ADD;
1841: RAISE FND_API.G_EXC_ERROR;
1842: END IF;
1843:

Line 1850: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_STATUS_VAL_INVALID');

1846:
1847: IF p_dss_secured_rel_type.status is not null then
1848: IF HZ_DSS_VALIDATE_PKG.exist_in_ar_lookups(p_dss_secured_rel_type.status,
1849: 'REGISTRY_STATUS')= 'N' THEN
1850: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_STATUS_VAL_INVALID');
1851: FND_MSG_PUB.ADD;
1852: RAISE FND_API.G_EXC_ERROR;
1853: END IF;
1854: END IF;

Line 1893: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_OTHERS_EXCEP');

1889:
1890: WHEN OTHERS THEN
1891: ROLLBACK TO update_secured_rel_type ;
1892: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1893: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_OTHERS_EXCEP');
1894: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1895: FND_MSG_PUB.ADD;
1896: FND_MSG_PUB.Count_And_Get(
1897: p_encoded => FND_API.G_FALSE,

Line 1894: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

1890: WHEN OTHERS THEN
1891: ROLLBACK TO update_secured_rel_type ;
1892: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1893: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_OTHERS_EXCEP');
1894: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1895: FND_MSG_PUB.ADD;
1896: FND_MSG_PUB.Count_And_Get(
1897: p_encoded => FND_API.G_FALSE,
1898: p_count => x_msg_count,

Line 1953: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_CODE_INVALID');

1949: -- VALIDATION
1950: -- PASSED IN GROUP CODE SHOULD BE VALID
1951: IF HZ_DSS_VALIDATE_PKG.exist_in_dss_groups_b (p_dss_assignment.dss_group_code) = 'N'
1952: THEN
1953: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_CODE_INVALID');
1954: FND_MSG_PUB.ADD;
1955: RAISE FND_API.G_EXC_ERROR;
1956: END IF;
1957:

Line 1961: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_OWN_TABLE_NAME_INVALID');

1957:
1958: -- OWNER TABLE NAME VALIDATION
1959: IF HZ_DSS_VALIDATE_PKG.exist_in_dss_entities(p_dss_assignment.owner_table_name) = 'N'
1960: THEN
1961: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_OWN_TABLE_NAME_INVALID');
1962: FND_MSG_PUB.ADD;
1963: RAISE FND_API.G_EXC_ERROR;
1964: END IF;
1965:

Line 1970: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_STATUS_VAL_INVALID');

1966: -- STATUS VALIDATION
1967:
1968: IF HZ_DSS_VALIDATE_PKG.exist_in_ar_lookups(p_dss_assignment.status, 'REGISTRY_STATUS')= 'N'
1969: THEN
1970: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_STATUS_VAL_INVALID');
1971: FND_MSG_PUB.ADD;
1972: RAISE FND_API.G_EXC_ERROR;
1973: END IF;
1974:

Line 2019: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_OTHERS_EXCEP');

2015:
2016: WHEN OTHERS THEN
2017: ROLLBACK TO create_assignment ;
2018: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2019: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_OTHERS_EXCEP');
2020: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2021: FND_MSG_PUB.ADD;
2022: FND_MSG_PUB.Count_And_Get(
2023: p_encoded => FND_API.G_FALSE,

Line 2020: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

2016: WHEN OTHERS THEN
2017: ROLLBACK TO create_assignment ;
2018: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2019: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_OTHERS_EXCEP');
2020: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2021: FND_MSG_PUB.ADD;
2022: FND_MSG_PUB.Count_And_Get(
2023: p_encoded => FND_API.G_FALSE,
2024: p_count => x_msg_count,

Line 2073: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_ASS_ID_INVALID');

2069: -- VALIDATION
2070: -- PASSED IN ASSIGNMENT ID SHOULD BE VALID
2071: IF HZ_DSS_VALIDATE_PKG.exist_in_dss_assignments(p_assignment_id) = 'N'
2072: THEN
2073: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_ASS_ID_INVALID');
2074: FND_MSG_PUB.ADD;
2075: RAISE FND_API.G_EXC_ERROR;
2076: END IF;
2077:

Line 2110: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_OTHERS_EXCEP');

2106:
2107: WHEN OTHERS THEN
2108: ROLLBACK TO delete_assignment ;
2109: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2110: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_OTHERS_EXCEP');
2111: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2112: FND_MSG_PUB.ADD;
2113: FND_MSG_PUB.Count_And_Get(
2114: p_encoded => FND_API.G_FALSE,

Line 2111: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

2107: WHEN OTHERS THEN
2108: ROLLBACK TO delete_assignment ;
2109: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2110: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_OTHERS_EXCEP');
2111: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2112: FND_MSG_PUB.ADD;
2113: FND_MSG_PUB.Count_And_Get(
2114: p_encoded => FND_API.G_FALSE,
2115: p_count => x_msg_count,

Line 2174: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');

2170:
2171: --validation of mandatory fields
2172: IF (p_dss_secured_entity.dss_group_code is null OR
2173: p_dss_secured_entity.dss_group_code = FND_API.G_MISS_CHAR) THEN
2174: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
2175: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'dss_group_code' );
2176: FND_MSG_PUB.ADD;
2177: RAISE FND_API.G_EXC_ERROR;
2178: END IF;

Line 2175: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'dss_group_code' );

2171: --validation of mandatory fields
2172: IF (p_dss_secured_entity.dss_group_code is null OR
2173: p_dss_secured_entity.dss_group_code = FND_API.G_MISS_CHAR) THEN
2174: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
2175: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'dss_group_code' );
2176: FND_MSG_PUB.ADD;
2177: RAISE FND_API.G_EXC_ERROR;
2178: END IF;
2179:

Line 2182: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');

2178: END IF;
2179:
2180: IF (p_dss_secured_entity.entity_id is null OR
2181: p_dss_secured_entity.entity_id = FND_API.G_MISS_NUM) THEN
2182: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
2183: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'entity_id' );
2184: FND_MSG_PUB.ADD;
2185: RAISE FND_API.G_EXC_ERROR;
2186: END IF;

Line 2183: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'entity_id' );

2179:
2180: IF (p_dss_secured_entity.entity_id is null OR
2181: p_dss_secured_entity.entity_id = FND_API.G_MISS_NUM) THEN
2182: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
2183: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'entity_id' );
2184: FND_MSG_PUB.ADD;
2185: RAISE FND_API.G_EXC_ERROR;
2186: END IF;
2187:

Line 2193: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_CODE_INVALID');

2189: -- VALIDATION
2190: -- PASSED IN GROUP CODE SHOULD BE VALID
2191: IF HZ_DSS_VALIDATE_PKG.exist_in_dss_groups_b (p_dss_secured_entity.dss_group_code) = 'N'
2192: THEN
2193: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_CODE_INVALID');
2194: FND_MSG_PUB.ADD;
2195: RAISE FND_API.G_EXC_ERROR;
2196: END IF;
2197:

Line 2201: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_ENT_ID_INVALID');

2197:
2198: -- ENTITY ID VALIDATION
2199: IF HZ_DSS_VALIDATE_PKG.exist_in_dss_entities(p_dss_secured_entity.entity_id ) = 'N'
2200: THEN
2201: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_ENT_ID_INVALID');
2202: FND_MSG_PUB.ADD;
2203: RAISE FND_API.G_EXC_ERROR;
2204: END IF;
2205:

Line 2210: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_STATUS_VAL_INVALID');

2206: -- STATUS VALIDATION
2207: IF p_dss_secured_entity.status is not null then
2208: IF HZ_DSS_VALIDATE_PKG.exist_in_ar_lookups(p_dss_secured_entity.status,
2209: 'REGISTRY_STATUS')= 'N' THEN
2210: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_STATUS_VAL_INVALID');
2211: FND_MSG_PUB.ADD;
2212: RAISE FND_API.G_EXC_ERROR;
2213: END IF;
2214: END IF;

Line 2346: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_OTHERS_EXCEP');

2342:
2343: WHEN OTHERS THEN
2344: ROLLBACK TO create_secured_entity ;
2345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2346: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_OTHERS_EXCEP');
2347: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2348: FND_MSG_PUB.ADD;
2349: FND_MSG_PUB.Count_And_Get(
2350: p_encoded => FND_API.G_FALSE,

Line 2347: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

2343: WHEN OTHERS THEN
2344: ROLLBACK TO create_secured_entity ;
2345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2346: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_OTHERS_EXCEP');
2347: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2348: FND_MSG_PUB.ADD;
2349: FND_MSG_PUB.Count_And_Get(
2350: p_encoded => FND_API.G_FALSE,
2351: p_count => x_msg_count,

Line 2413: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_SEC_ENT_NOT_FOUND');

2409: AND entity_id = p_dss_secured_entity.entity_id
2410: FOR UPDATE NOWAIT;
2411: EXCEPTION
2412: WHEN NO_DATA_FOUND THEN
2413: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_SEC_ENT_NOT_FOUND');
2414: FND_MSG_PUB.ADD;
2415: RAISE FND_API.G_EXC_ERROR;
2416: END;
2417:

Line 2422: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');

2418: IF NOT ((x_object_version_number IS NULL AND
2419: l_object_version_number IS NULL) OR
2420: (x_object_version_number = l_object_version_number))
2421: THEN
2422: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
2423: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_DSS_SECURED_ENTITIES');
2424: FND_MSG_PUB.ADD;
2425: RAISE FND_API.G_EXC_ERROR;
2426: END IF;

Line 2423: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_DSS_SECURED_ENTITIES');

2419: l_object_version_number IS NULL) OR
2420: (x_object_version_number = l_object_version_number))
2421: THEN
2422: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
2423: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_DSS_SECURED_ENTITIES');
2424: FND_MSG_PUB.ADD;
2425: RAISE FND_API.G_EXC_ERROR;
2426: END IF;
2427:

Line 2439: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_STATUS_VAL_INVALID');

2435: IF HZ_DSS_VALIDATE_PKG.exist_in_ar_lookups (
2436: p_dss_secured_entity.status,
2437: 'REGISTRY_STATUS')= 'N'
2438: THEN
2439: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_STATUS_VAL_INVALID');
2440: FND_MSG_PUB.ADD;
2441: RAISE FND_API.G_EXC_ERROR;
2442: END IF;
2443: END IF;

Line 2511: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_OTHERS_EXCEP');

2507: WHEN OTHERS THEN
2508: ROLLBACK TO update_secured_entity ;
2509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2510:
2511: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_OTHERS_EXCEP');
2512: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2513: FND_MSG_PUB.ADD;
2514: FND_MSG_PUB.Count_And_Get(
2515: p_encoded => FND_API.G_FALSE,

Line 2512: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

2508: ROLLBACK TO update_secured_entity ;
2509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2510:
2511: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_OTHERS_EXCEP');
2512: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2513: FND_MSG_PUB.ADD;
2514: FND_MSG_PUB.Count_And_Get(
2515: p_encoded => FND_API.G_FALSE,
2516: p_count => x_msg_count,