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.CN_QUOTA_PAY_ELEMENTS_PVT dependencies on FND_MSG_PUB

Line 355: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

351: x_loading_status := p_loading_status;
352: -- API body
353:
354: IF p_quota_pay_element_rec.quota_name IS NULL THEN
355: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
356: FND_MESSAGE.Set_Name('CN', 'CN_QUOTA_NAME_NOT_NULL');
357: FND_MSG_PUB.Add;
358: END IF;
359: x_loading_status := 'CN_QUOTA_NAME_NOT_NULL';

Line 357: FND_MSG_PUB.Add;

353:
354: IF p_quota_pay_element_rec.quota_name IS NULL THEN
355: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
356: FND_MESSAGE.Set_Name('CN', 'CN_QUOTA_NAME_NOT_NULL');
357: FND_MSG_PUB.Add;
358: END IF;
359: x_loading_status := 'CN_QUOTA_NAME_NOT_NULL';
360: RAISE FND_API.G_EXC_ERROR ;
361: END IF;

Line 365: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

361: END IF;
362:
363:
364: IF p_quota_pay_element_rec.pay_element_name IS NULL THEN
365: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
366: FND_MESSAGE.Set_Name('CN', 'CN_PAY_ELEMENT_NAME_NOT_NULL');
367: FND_MSG_PUB.Add;
368: END IF;
369: x_loading_status := 'CN_PAY_ELEMENT_NAME_NOT_NULL';

Line 367: FND_MSG_PUB.Add;

363:
364: IF p_quota_pay_element_rec.pay_element_name IS NULL THEN
365: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
366: FND_MESSAGE.Set_Name('CN', 'CN_PAY_ELEMENT_NAME_NOT_NULL');
367: FND_MSG_PUB.Add;
368: END IF;
369: x_loading_status := 'CN_PAY_ELEMENT_NAME_NOT_NULL';
370: RAISE FND_API.G_EXC_ERROR ;
371: END IF;

Line 376: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

372:
373:
374: IF p_quota_pay_element_rec.quota_name IS NOT NULL and
375: p_quota_pay_element_rec.quota_id IS NULL THEN
376: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
377: FND_MESSAGE.Set_Name('CN', 'CN_QUOTA_NOT_EXISTS');
378: FND_MSG_PUB.Add;
379: END IF;
380: x_loading_status := 'CN_QUOTA_NOT_EXISTS';

Line 378: FND_MSG_PUB.Add;

374: IF p_quota_pay_element_rec.quota_name IS NOT NULL and
375: p_quota_pay_element_rec.quota_id IS NULL THEN
376: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
377: FND_MESSAGE.Set_Name('CN', 'CN_QUOTA_NOT_EXISTS');
378: FND_MSG_PUB.Add;
379: END IF;
380: x_loading_status := 'CN_QUOTA_NOT_EXISTS';
381: RAISE FND_API.G_EXC_ERROR ;
382: END IF;

Line 386: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

382: END IF;
383:
384:
385: IF p_quota_pay_element_rec.start_date IS NULL THEN
386: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
387: FND_MESSAGE.Set_Name('CN', 'CN_PAY_ELEMENT_SD_NOT_NULL');
388: FND_MSG_PUB.Add;
389: END IF;
390: x_loading_status := 'CN_PAY_ELEMENT_SD_NOT_NULL';

Line 388: FND_MSG_PUB.Add;

384:
385: IF p_quota_pay_element_rec.start_date IS NULL THEN
386: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
387: FND_MESSAGE.Set_Name('CN', 'CN_PAY_ELEMENT_SD_NOT_NULL');
388: FND_MSG_PUB.Add;
389: END IF;
390: x_loading_status := 'CN_PAY_ELEMENT_SD_NOT_NULL';
391: RAISE FND_API.G_EXC_ERROR ;
392: END IF;

Line 395: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

391: RAISE FND_API.G_EXC_ERROR ;
392: END IF;
393:
394: IF p_quota_pay_element_rec.end_date IS NULL THEN
395: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
396: FND_MESSAGE.Set_Name('CN', 'CN_PAY_ELEMENT_ED_NOT_NULL');
397: FND_MSG_PUB.Add;
398: END IF;
399: x_loading_status := 'CN_PAY_ELEMENT_ED_NOT_NULL';

Line 397: FND_MSG_PUB.Add;

393:
394: IF p_quota_pay_element_rec.end_date IS NULL THEN
395: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
396: FND_MESSAGE.Set_Name('CN', 'CN_PAY_ELEMENT_ED_NOT_NULL');
397: FND_MSG_PUB.Add;
398: END IF;
399: x_loading_status := 'CN_PAY_ELEMENT_ED_NOT_NULL';
400: RAISE FND_API.G_EXC_ERROR ;
401: END IF;

Line 413: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

409: and p_quota_pay_element_rec.pay_end_date) or
410: p_quota_pay_element_rec.pay_end_date <
411: p_quota_pay_element_rec.end_date THEN
412:
413: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
414: FND_MESSAGE.Set_Name('CN', 'CN_PE_DATE_NOT_WITHIN_PAY_PE');
415: FND_MSG_PUB.Add;
416: END IF;
417: x_loading_status := 'CN_PE_DATE_NOT_WITHIN_PAY_PE';

Line 415: FND_MSG_PUB.Add;

411: p_quota_pay_element_rec.end_date THEN
412:
413: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
414: FND_MESSAGE.Set_Name('CN', 'CN_PE_DATE_NOT_WITHIN_PAY_PE');
415: FND_MSG_PUB.Add;
416: END IF;
417: x_loading_status := 'CN_PE_DATE_NOT_WITHIN_PAY_PE';
418: RAISE FND_API.G_EXC_ERROR ;
419: END IF;

Line 426: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

422:
423:
424: IF p_quota_pay_element_rec.pay_element_name IS NOT NULL and
425: p_quota_pay_element_rec.pay_element_type_id IS NULL THEN
426: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
427: FND_MESSAGE.Set_Name('CN', 'CN_PAY_ELEMENT_NOT_EXISTS');
428: FND_MSG_PUB.Add;
429: END IF;
430: x_loading_status := 'CN_PAY_ELEMENT_NOT_EXISTS';

Line 428: FND_MSG_PUB.Add;

424: IF p_quota_pay_element_rec.pay_element_name IS NOT NULL and
425: p_quota_pay_element_rec.pay_element_type_id IS NULL THEN
426: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
427: FND_MESSAGE.Set_Name('CN', 'CN_PAY_ELEMENT_NOT_EXISTS');
428: FND_MSG_PUB.Add;
429: END IF;
430: x_loading_status := 'CN_PAY_ELEMENT_NOT_EXISTS';
431: RAISE FND_API.G_EXC_ERROR ;
432: END IF;

Line 455: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

451: (p_quota_pay_element_rec.quota_pay_element_id IS NULL))
452: );
453: EXCEPTION
454: WHEN NO_DATA_FOUND THEN
455: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
456: FND_MESSAGE.Set_Name('CN', 'CN_QUOTA_PAY_ELEMENT_EXISTS');
457: FND_MSG_PUB.Add;
458: END IF;
459: x_loading_status := 'CN_QUOTA_PAY_ELEMENT_EXISTS';

Line 457: FND_MSG_PUB.Add;

453: EXCEPTION
454: WHEN NO_DATA_FOUND THEN
455: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
456: FND_MESSAGE.Set_Name('CN', 'CN_QUOTA_PAY_ELEMENT_EXISTS');
457: FND_MSG_PUB.Add;
458: END IF;
459: x_loading_status := 'CN_QUOTA_PAY_ELEMENT_EXISTS';
460: RAISE FND_API.G_EXC_ERROR ;
461: END;

Line 519: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

515: AND nvl(status,'A') = nvl(p_quota_pay_element_rec.status,'A')
516: );
517: EXCEPTION
518: WHEN NO_DATA_FOUND THEN
519: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
520: FND_MESSAGE.SET_NAME ('CN' , 'CN_QUOTA_PAY_ELEMENT_OVERLAPS');
521: FND_MSG_PUB.Add;
522: END IF;
523: x_loading_status := 'CN_QUOTA_PAY_ELEMENT_OVERLAPS';

Line 521: FND_MSG_PUB.Add;

517: EXCEPTION
518: WHEN NO_DATA_FOUND THEN
519: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
520: FND_MESSAGE.SET_NAME ('CN' , 'CN_QUOTA_PAY_ELEMENT_OVERLAPS');
521: FND_MSG_PUB.Add;
522: END IF;
523: x_loading_status := 'CN_QUOTA_PAY_ELEMENT_OVERLAPS';
524: RAISE FND_API.G_EXC_ERROR ;
525: END;

Line 544: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

540: p_quota_pay_element_rec.start_date,
541: p_quota_pay_element_rec.end_date,
542: p_quota_pay_element_rec.quota_id,
543: p_quota_pay_element_rec.pay_element_type_id) > 0 THEN
544: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
545: FND_MESSAGE.SET_NAME ('CN' , 'CN_PAY_ELEMENT_ALREADY_USED');
546: FND_MSG_PUB.Add;
547: END IF;
548: x_loading_status := 'CN_PAY_ELEMENT_ALREADY_USED';

Line 546: FND_MSG_PUB.Add;

542: p_quota_pay_element_rec.quota_id,
543: p_quota_pay_element_rec.pay_element_type_id) > 0 THEN
544: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
545: FND_MESSAGE.SET_NAME ('CN' , 'CN_PAY_ELEMENT_ALREADY_USED');
546: FND_MSG_PUB.Add;
547: END IF;
548: x_loading_status := 'CN_PAY_ELEMENT_ALREADY_USED';
549: RAISE FND_API.G_EXC_ERROR ;
550: end if;

Line 554: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

550: end if;
551:
552: if p_quota_pay_element_rec.pay_element_type_id <> l_old_rec.pay_element_type_id THEN
553: if check_input_exists(p_quota_pay_element_rec.quota_pay_element_id) > 0 THEN
554: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
555: FND_MESSAGE.SET_NAME ('CN' , 'CN_ELEMENT_INPUT_EXISTS');
556: FND_MSG_PUB.Add;
557: END IF;
558: x_loading_status := 'CN_ELEMENT_INPUT_EXISTS';

Line 556: FND_MSG_PUB.Add;

552: if p_quota_pay_element_rec.pay_element_type_id <> l_old_rec.pay_element_type_id THEN
553: if check_input_exists(p_quota_pay_element_rec.quota_pay_element_id) > 0 THEN
554: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
555: FND_MESSAGE.SET_NAME ('CN' , 'CN_ELEMENT_INPUT_EXISTS');
556: FND_MSG_PUB.Add;
557: END IF;
558: x_loading_status := 'CN_ELEMENT_INPUT_EXISTS';
559: RAISE FND_API.G_EXC_ERROR ;
560: end if;

Line 580: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

576: x_loading_status := 'UNEXPECTED_ERR';
577: WHEN OTHERS THEN
578: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
579: x_loading_status := 'UNEXPECTED_ERR';
580: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
581: THEN
582: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
583: END IF;
584:

Line 582: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

578: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
579: x_loading_status := 'UNEXPECTED_ERR';
580: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
581: THEN
582: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
583: END IF;
584:
585: END valid_qpe_mapping;
586: --+==========================================================================

Line 629: FND_MSG_PUB.initialize;

625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
626: END IF;
627: -- Initialize message list if p_init_msg_list is set to TRUE.
628: IF FND_API.to_Boolean( p_init_msg_list ) THEN
629: FND_MSG_PUB.initialize;
630: END IF;
631: -- Initialize API return status to success
632: x_return_status := FND_API.G_RET_STS_SUCCESS;
633: x_loading_status := 'CN_INSERTED';

Line 734: FND_MSG_PUB.Count_And_Get

730: IF FND_API.To_Boolean( p_commit ) THEN
731: COMMIT WORK;
732: END IF;
733: -- Standard call to get message count and if count is 1, get message info.
734: FND_MSG_PUB.Count_And_Get
735: (
736: p_count => x_msg_count ,
737: p_data => x_msg_data ,
738: p_encoded => FND_API.G_FALSE

Line 745: FND_MSG_PUB.Count_And_Get

741: EXCEPTION
742: WHEN FND_API.G_EXC_ERROR THEN
743: ROLLBACK TO Create_quota_pay_element;
744: x_return_status := FND_API.G_RET_STS_ERROR ;
745: FND_MSG_PUB.Count_And_Get
746: (
747: p_count => x_msg_count ,
748: p_data => x_msg_data ,
749: p_encoded => FND_API.G_FALSE

Line 756: FND_MSG_PUB.Count_And_Get

752: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
753: ROLLBACK TO Create_quota_pay_element;
754: x_loading_status := 'UNEXPECTED_ERR';
755: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
756: FND_MSG_PUB.Count_And_Get
757: (
758: p_count => x_msg_count ,
759: p_data => x_msg_data ,
760: p_encoded => FND_API.G_FALSE

Line 766: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

762: WHEN OTHERS THEN
763: ROLLBACK TO Create_quota_pay_element;
764: x_loading_status := 'UNEXPECTED_ERR';
765: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
766: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
767: THEN
768: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
769: END IF;
770: FND_MSG_PUB.Count_And_Get

Line 768: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

764: x_loading_status := 'UNEXPECTED_ERR';
765: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
766: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
767: THEN
768: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
769: END IF;
770: FND_MSG_PUB.Count_And_Get
771: (
772: p_count => x_msg_count ,

Line 770: FND_MSG_PUB.Count_And_Get

766: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
767: THEN
768: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
769: END IF;
770: FND_MSG_PUB.Count_And_Get
771: (
772: p_count => x_msg_count ,
773: p_data => x_msg_data ,
774: p_encoded => FND_API.G_FALSE

Line 817: FND_MSG_PUB.initialize;

813: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
814: END IF;
815: -- Initialize message list if p_init_msg_list is set to TRUE.
816: IF FND_API.to_Boolean( p_init_msg_list ) THEN
817: FND_MSG_PUB.initialize;
818: END IF;
819: -- Initialize API return status to success
820: x_return_status := FND_API.G_RET_STS_SUCCESS;
821: x_loading_status := 'CN_UPDATED';

Line 909: FND_MSG_PUB.Count_And_Get

905: IF FND_API.To_Boolean( p_commit ) THEN
906: COMMIT WORK;
907: END IF;
908: -- Standard call to get message count and if count is 1, get message info.
909: FND_MSG_PUB.Count_And_Get
910: (
911: p_count => x_msg_count ,
912: p_data => x_msg_data ,
913: p_encoded => FND_API.G_FALSE

Line 920: FND_MSG_PUB.Count_And_Get

916: EXCEPTION
917: WHEN FND_API.G_EXC_ERROR THEN
918: ROLLBACK TO Update_quota_pay_element;
919: x_return_status := FND_API.G_RET_STS_ERROR ;
920: FND_MSG_PUB.Count_And_Get
921: (
922: p_count => x_msg_count ,
923: p_data => x_msg_data ,
924: p_encoded => FND_API.G_FALSE

Line 930: FND_MSG_PUB.Count_And_Get

926: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
927: ROLLBACK TO Update_quota_pay_element;
928: x_loading_status := 'UNEXPECTED_ERR';
929: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
930: FND_MSG_PUB.Count_And_Get
931: (
932: p_count => x_msg_count ,
933: p_data => x_msg_data ,
934: p_encoded => FND_API.G_FALSE

Line 940: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

936: WHEN OTHERS THEN
937: ROLLBACK TO Update_quota_pay_element;
938: x_loading_status := 'UNEXPECTED_ERR';
939: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
940: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
941: THEN
942: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
943: END IF;
944: FND_MSG_PUB.Count_And_Get

Line 942: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

938: x_loading_status := 'UNEXPECTED_ERR';
939: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
940: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
941: THEN
942: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
943: END IF;
944: FND_MSG_PUB.Count_And_Get
945: (
946: p_count => x_msg_count ,

Line 944: FND_MSG_PUB.Count_And_Get

940: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
941: THEN
942: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
943: END IF;
944: FND_MSG_PUB.Count_And_Get
945: (
946: p_count => x_msg_count ,
947: p_data => x_msg_data ,
948: p_encoded => FND_API.G_FALSE

Line 984: FND_MSG_PUB.initialize;

980: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
981: END IF;
982: -- Initialize message list if p_init_msg_list is set to TRUE.
983: IF FND_API.to_Boolean( p_init_msg_list ) THEN
984: FND_MSG_PUB.initialize;
985: END IF;
986: -- Initialize API return status to success
987: x_return_status := FND_API.G_RET_STS_SUCCESS;
988: x_loading_status := 'CN_DELETED';

Line 993: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

989:
990: IF p_quota_pay_element_id IS NOT NULL THEN
991:
992: if check_delete_update_allowed(p_quota_pay_element_id) > 0 THEN
993: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
994: FND_MESSAGE.SET_NAME ('CN' , 'CN_PAY_ELEMENT_ALREADY_USED');
995: FND_MSG_PUB.Add;
996: END IF;
997: x_loading_status := 'CN_PAY_ELEMENT_ALREADY_USED';

Line 995: FND_MSG_PUB.Add;

991:
992: if check_delete_update_allowed(p_quota_pay_element_id) > 0 THEN
993: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
994: FND_MESSAGE.SET_NAME ('CN' , 'CN_PAY_ELEMENT_ALREADY_USED');
995: FND_MSG_PUB.Add;
996: END IF;
997: x_loading_status := 'CN_PAY_ELEMENT_ALREADY_USED';
998: RAISE FND_API.G_EXC_ERROR ;
999: end if;

Line 1002: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

998: RAISE FND_API.G_EXC_ERROR ;
999: end if;
1000:
1001: if check_input_exists(p_quota_pay_element_id) > 0 THEN
1002: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1003: FND_MESSAGE.SET_NAME ('CN' , 'CN_ELEMENT_INPUT_EXISTS');
1004: FND_MSG_PUB.Add;
1005: END IF;
1006: x_loading_status := 'CN_ELEMENT_INPUT_EXISTS';

Line 1004: FND_MSG_PUB.Add;

1000:
1001: if check_input_exists(p_quota_pay_element_id) > 0 THEN
1002: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1003: FND_MESSAGE.SET_NAME ('CN' , 'CN_ELEMENT_INPUT_EXISTS');
1004: FND_MSG_PUB.Add;
1005: END IF;
1006: x_loading_status := 'CN_ELEMENT_INPUT_EXISTS';
1007: RAISE FND_API.G_EXC_ERROR ;
1008: end if;

Line 1024: FND_MSG_PUB.Count_And_Get

1020: IF FND_API.To_Boolean( p_commit ) THEN
1021: COMMIT WORK;
1022: END IF;
1023: -- Standard call to get message count and if count is 1, get message info.
1024: FND_MSG_PUB.Count_And_Get
1025: (
1026: p_count => x_msg_count ,
1027: p_data => x_msg_data ,
1028: p_encoded => FND_API.G_FALSE

Line 1035: FND_MSG_PUB.Count_And_Get

1031: EXCEPTION
1032: WHEN FND_API.G_EXC_ERROR THEN
1033: ROLLBACK TO Delete_Quota_Pay_element;
1034: x_return_status := FND_API.G_RET_STS_ERROR ;
1035: FND_MSG_PUB.Count_And_Get
1036: (
1037: p_count => x_msg_count ,
1038: p_data => x_msg_data ,
1039: p_encoded => FND_API.G_FALSE

Line 1045: FND_MSG_PUB.Count_And_Get

1041: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1042: ROLLBACK TO Delete_Quota_Pay_Element;
1043: x_loading_status := 'UNEXPECTED_ERR';
1044: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1045: FND_MSG_PUB.Count_And_Get
1046: (
1047: p_count => x_msg_count ,
1048: p_data => x_msg_data ,
1049: p_encoded => FND_API.G_FALSE

Line 1055: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1051: WHEN OTHERS THEN
1052: ROLLBACK TO Delete_Quota_Pay_element;
1053: x_loading_status := 'UNEXPECTED_ERR';
1054: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1055: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1056: THEN
1057: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1058: END IF;
1059: FND_MSG_PUB.Count_And_Get

Line 1057: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

1053: x_loading_status := 'UNEXPECTED_ERR';
1054: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1055: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1056: THEN
1057: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1058: END IF;
1059: FND_MSG_PUB.Count_And_Get
1060: (
1061: p_count => x_msg_count ,

Line 1059: FND_MSG_PUB.Count_And_Get

1055: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1056: THEN
1057: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1058: END IF;
1059: FND_MSG_PUB.Count_And_Get
1060: (
1061: p_count => x_msg_count ,
1062: p_data => x_msg_data ,
1063: p_encoded => FND_API.G_FALSE

Line 1180: FND_MSG_PUB.initialize;

1176: --
1177: -- Initialize message list if p_init_msg_list is set to TRUE.
1178: --
1179: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1180: FND_MSG_PUB.initialize;
1181: END IF;
1182: --
1183: -- Initialize API return status to success
1184: --

Line 1275: FND_MSG_PUB.Count_And_Get

1271: -- Standard check of p_commit.
1272: IF FND_API.To_Boolean( p_commit ) THEN
1273: COMMIT WORK;
1274: END IF;
1275: FND_MSG_PUB.Count_And_Get
1276: (
1277: p_count => x_msg_count ,
1278: p_data => x_msg_data ,
1279: p_encoded => FND_API.G_FALSE

Line 1286: FND_MSG_PUB.Count_And_Get

1282: EXCEPTION
1283: WHEN FND_API.G_EXC_ERROR THEN
1284: ROLLBACK TO Get_quota_pay_element;
1285: x_return_status := FND_API.G_RET_STS_ERROR ;
1286: FND_MSG_PUB.Count_And_Get
1287: (
1288: p_count => x_msg_count ,
1289: p_data => x_msg_data ,
1290: p_encoded => FND_API.G_FALSE

Line 1296: FND_MSG_PUB.Count_And_Get

1292: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1293: ROLLBACK TO Get_quota_pay_element;
1294: x_loading_status := 'UNEXPECTED_ERR';
1295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1296: FND_MSG_PUB.Count_And_Get
1297: (
1298: p_count => x_msg_count ,
1299: p_data => x_msg_data ,
1300: p_encoded => FND_API.G_FALSE

Line 1306: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1302: WHEN OTHERS THEN
1303: ROLLBACK TO Get_quota_pay_element;
1304: x_loading_status := 'UNEXPECTED_ERR';
1305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1306: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1307: THEN
1308: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1309: END IF;
1310: FND_MSG_PUB.Count_And_Get (

Line 1308: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

1304: x_loading_status := 'UNEXPECTED_ERR';
1305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1306: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1307: THEN
1308: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1309: END IF;
1310: FND_MSG_PUB.Count_And_Get (
1311: p_count => x_msg_count ,
1312: p_data => x_msg_data ,

Line 1310: FND_MSG_PUB.Count_And_Get (

1306: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1307: THEN
1308: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1309: END IF;
1310: FND_MSG_PUB.Count_And_Get (
1311: p_count => x_msg_count ,
1312: p_data => x_msg_data ,
1313: p_encoded => FND_API.G_FALSE
1314: );