DBA Data[Home] [Help]

APPS.AS_INTEREST_PUB dependencies on FND_MESSAGE

Line 104: fnd_message.set_name('as', 'Public Create Interest: Start');

100:
101: -- Debug Message
102: if fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
103: then
104: fnd_message.set_name('as', 'Public Create Interest: Start');
105: fnd_msg_pub.add;
106: end if;
107:
108: -- Initialize API return status to success

Line 164: fnd_message.set_name('AS', 'Public Create Interest: End');

160:
161: -- Debug Message
162: if fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
163: then
164: fnd_message.set_name('AS', 'Public Create Interest: End');
165: fnd_msg_pub.add;
166: end if;
167:
168:

Line 311: FND_MESSAGE.Set_Name('AS', 'Pub Interest API: Start');

307:
308: -- Debug Message
309: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
310: THEN
311: FND_MESSAGE.Set_Name('AS', 'Pub Interest API: Start');
312: FND_MSG_PUB.Add;
313: END IF;
314:
315: -- Initialize API return status to success

Line 392: FND_MESSAGE.Set_Name('AS', 'API_SUCCESS');

388: -- Success Message
389: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) and
390: x_return_status = FND_API.G_RET_STS_SUCCESS
391: THEN
392: FND_MESSAGE.Set_Name('AS', 'API_SUCCESS');
393: FND_MESSAGE.Set_Token('ROW', 'AS_INTEREST', TRUE);
394: FND_MSG_PUB.Add;
395: END IF;
396:

Line 393: FND_MESSAGE.Set_Token('ROW', 'AS_INTEREST', TRUE);

389: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) and
390: x_return_status = FND_API.G_RET_STS_SUCCESS
391: THEN
392: FND_MESSAGE.Set_Name('AS', 'API_SUCCESS');
393: FND_MESSAGE.Set_Token('ROW', 'AS_INTEREST', TRUE);
394: FND_MSG_PUB.Add;
395: END IF;
396:
397: l_address_id := p_interest_rec.address_id;

Line 415: FND_MESSAGE.Set_Name('AS', 'Pub Interest API: End');

411:
412: -- Debug Message
413: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
414: THEN
415: FND_MESSAGE.Set_Name('AS', 'Pub Interest API: End');
416: FND_MSG_PUB.Add;
417: END IF;
418:
419: -- Standard call to get message count and if count is 1, get message info.

Line 508: FND_MESSAGE.Set_Name('AS', 'Int ValuesToIds: Start');

504: BEGIN
505:
506: -- Debug Message
507: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
508: FND_MESSAGE.Set_Name('AS', 'Int ValuesToIds: Start');
509: FND_MSG_PUB.Add;
510: END IF;
511:
512: -- Loop through the interest table and convert values to ids

Line 523: FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');

519:
520: -- Progress Message
521: --
522: /* IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
523: FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
524: FND_MESSAGE.Set_Token ('ROW', 'AS_INTEREST', TRUE);
525: FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(l_curr_row), FALSE);
526: FND_MSG_PUB.Add;
527: END IF;

Line 524: FND_MESSAGE.Set_Token ('ROW', 'AS_INTEREST', TRUE);

520: -- Progress Message
521: --
522: /* IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
523: FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
524: FND_MESSAGE.Set_Token ('ROW', 'AS_INTEREST', TRUE);
525: FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(l_curr_row), FALSE);
526: FND_MSG_PUB.Add;
527: END IF;
528: */

Line 525: FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(l_curr_row), FALSE);

521: --
522: /* IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
523: FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
524: FND_MESSAGE.Set_Token ('ROW', 'AS_INTEREST', TRUE);
525: FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(l_curr_row), FALSE);
526: FND_MSG_PUB.Add;
527: END IF;
528: */
529:

Line 574: FND_MESSAGE.Set_Name ('AS', 'API_ATTRIBUTE_IGNORED');

570: and p_interest_tbl(l_curr_row).status <> FND_API.G_MISS_CHAR)
571: THEN
572: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
573: THEN
574: FND_MESSAGE.Set_Name ('AS', 'API_ATTRIBUTE_IGNORED');
575: FND_MESSAGE.Set_Token ('COLUMN', 'STATUS', FALSE);
576: FND_MSG_PUB.Add;
577: END IF;
578: END IF;

Line 575: FND_MESSAGE.Set_Token ('COLUMN', 'STATUS', FALSE);

571: THEN
572: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
573: THEN
574: FND_MESSAGE.Set_Name ('AS', 'API_ATTRIBUTE_IGNORED');
575: FND_MESSAGE.Set_Token ('COLUMN', 'STATUS', FALSE);
576: FND_MSG_PUB.Add;
577: END IF;
578: END IF;
579:

Line 594: FND_MESSAGE.Set_Name ('AS', 'API_ATTRIBUTE_CONVERSION_ERROR');

590: IF (l_val IS NULL)
591: THEN
592: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
593: THEN
594: FND_MESSAGE.Set_Name ('AS', 'API_ATTRIBUTE_CONVERSION_ERROR');
595: FND_MESSAGE.Set_Token ('COLUMN', 'STAUTS', FALSE);
596: FND_MESSAGE.Set_Token('VALUE', p_interest_tbl(l_curr_row).status, FALSE);
597: FND_MSG_PUB.Add;
598: END IF;

Line 595: FND_MESSAGE.Set_Token ('COLUMN', 'STAUTS', FALSE);

591: THEN
592: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
593: THEN
594: FND_MESSAGE.Set_Name ('AS', 'API_ATTRIBUTE_CONVERSION_ERROR');
595: FND_MESSAGE.Set_Token ('COLUMN', 'STAUTS', FALSE);
596: FND_MESSAGE.Set_Token('VALUE', p_interest_tbl(l_curr_row).status, FALSE);
597: FND_MSG_PUB.Add;
598: END IF;
599: l_any_row_errors := TRUE;

Line 596: FND_MESSAGE.Set_Token('VALUE', p_interest_tbl(l_curr_row).status, FALSE);

592: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
593: THEN
594: FND_MESSAGE.Set_Name ('AS', 'API_ATTRIBUTE_CONVERSION_ERROR');
595: FND_MESSAGE.Set_Token ('COLUMN', 'STAUTS', FALSE);
596: FND_MESSAGE.Set_Token('VALUE', p_interest_tbl(l_curr_row).status, FALSE);
597: FND_MSG_PUB.Add;
598: END IF;
599: l_any_row_errors := TRUE;
600: END IF;

Line 654: FND_MESSAGE.Set_Name('AS', 'Int ValuesToIds: End');

650:
651: -- Debug Message
652: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
653: THEN
654: FND_MESSAGE.Set_Name('AS', 'Int ValuesToIds: End');
655: FND_MSG_PUB.Add;
656: END IF;
657:
658:

Line 663: FND_MESSAGE.Set_Name('AS', 'API_ERRORS_IN_VALUES_TO_IDS');

659: IF l_any_errors
660: THEN
661: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
662: THEN
663: FND_MESSAGE.Set_Name('AS', 'API_ERRORS_IN_VALUES_TO_IDS');
664: FND_MESSAGE.Set_Token('ROW', 'AS_INTEREST', TRUE);
665: FND_MSG_PUB.Add;
666: END IF;
667: END IF;

Line 664: FND_MESSAGE.Set_Token('ROW', 'AS_INTEREST', TRUE);

660: THEN
661: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
662: THEN
663: FND_MESSAGE.Set_Name('AS', 'API_ERRORS_IN_VALUES_TO_IDS');
664: FND_MESSAGE.Set_Token('ROW', 'AS_INTEREST', TRUE);
665: FND_MSG_PUB.Add;
666: END IF;
667: END IF;
668:

Line 747: FND_MESSAGE.Set_Name ('AS', 'API_ATTRIBUTE_IGNORED');

743: p_interest_type <> FND_API.G_MISS_CHAR)
744: THEN
745: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
746: THEN
747: FND_MESSAGE.Set_Name ('AS', 'API_ATTRIBUTE_IGNORED');
748: FND_MESSAGE.Set_Token ('COLUMN', 'INTEREST_TYPE', FALSE);
749: FND_MSG_PUB.Add;
750: END IF;
751: END IF;

Line 748: FND_MESSAGE.Set_Token ('COLUMN', 'INTEREST_TYPE', FALSE);

744: THEN
745: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
746: THEN
747: FND_MESSAGE.Set_Name ('AS', 'API_ATTRIBUTE_IGNORED');
748: FND_MESSAGE.Set_Token ('COLUMN', 'INTEREST_TYPE', FALSE);
749: FND_MSG_PUB.Add;
750: END IF;
751: END IF;
752:

Line 762: FND_MESSAGE.Set_Name ('AS', 'API_ATTRIBUTE_CONVERSION_ERROR');

758:
759: IF (C_Get_Int_Type%NOTFOUND) THEN
760: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
761: THEN
762: FND_MESSAGE.Set_Name ('AS', 'API_ATTRIBUTE_CONVERSION_ERROR');
763: FND_MESSAGE.Set_Token ('COLUMN', 'INTEREST_TYPE', FALSE);
764: FND_MESSAGE.Set_Token('VALUE', p_interest_type, FALSE);
765: FND_MSG_PUB.Add;
766: END IF;

Line 763: FND_MESSAGE.Set_Token ('COLUMN', 'INTEREST_TYPE', FALSE);

759: IF (C_Get_Int_Type%NOTFOUND) THEN
760: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
761: THEN
762: FND_MESSAGE.Set_Name ('AS', 'API_ATTRIBUTE_CONVERSION_ERROR');
763: FND_MESSAGE.Set_Token ('COLUMN', 'INTEREST_TYPE', FALSE);
764: FND_MESSAGE.Set_Token('VALUE', p_interest_type, FALSE);
765: FND_MSG_PUB.Add;
766: END IF;
767:

Line 764: FND_MESSAGE.Set_Token('VALUE', p_interest_type, FALSE);

760: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
761: THEN
762: FND_MESSAGE.Set_Name ('AS', 'API_ATTRIBUTE_CONVERSION_ERROR');
763: FND_MESSAGE.Set_Token ('COLUMN', 'INTEREST_TYPE', FALSE);
764: FND_MESSAGE.Set_Token('VALUE', p_interest_type, FALSE);
765: FND_MSG_PUB.Add;
766: END IF;
767:
768: -- This will raise an exception immediately, since all other processing

Line 783: FND_MESSAGE.Set_Name ('AS','API_MISSING_ID');

779: -- If no interest type (value or id) exists, then this row is invalid
780: --
781: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
782: THEN
783: FND_MESSAGE.Set_Name ('AS','API_MISSING_ID');
784: FND_MESSAGE.Set_Token ('COLUMN', 'INTEREST_TYPE', FALSE);
785: FND_MSG_PUB.Add;
786: END IF;
787:

Line 784: FND_MESSAGE.Set_Token ('COLUMN', 'INTEREST_TYPE', FALSE);

780: --
781: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
782: THEN
783: FND_MESSAGE.Set_Name ('AS','API_MISSING_ID');
784: FND_MESSAGE.Set_Token ('COLUMN', 'INTEREST_TYPE', FALSE);
785: FND_MSG_PUB.Add;
786: END IF;
787:
788: -- This will raise an exception immediately, since all other processing

Line 808: FND_MESSAGE.Set_Name ('AS','API_ATTRIBUTE_IGNORED');

804: p_primary_interest_code <> FND_API.G_MISS_CHAR)
805: THEN
806: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
807: THEN
808: FND_MESSAGE.Set_Name ('AS','API_ATTRIBUTE_IGNORED');
809: FND_MESSAGE.Set_Token ('COLUMN', 'PRIMARY_INTEREST_CODE', FALSE);
810: FND_MSG_PUB.Add;
811: END IF;
812: END IF;

Line 809: FND_MESSAGE.Set_Token ('COLUMN', 'PRIMARY_INTEREST_CODE', FALSE);

805: THEN
806: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
807: THEN
808: FND_MESSAGE.Set_Name ('AS','API_ATTRIBUTE_IGNORED');
809: FND_MESSAGE.Set_Token ('COLUMN', 'PRIMARY_INTEREST_CODE', FALSE);
810: FND_MSG_PUB.Add;
811: END IF;
812: END IF;
813:

Line 821: FND_MESSAGE.Set_Name ('AS', 'API_ATTRIBUTE_CONVERSION_ERROR');

817: OPEN C_Get_Int_Code ( p_primary_interest_code, l_interest_type_id );
818: FETCH C_Get_Int_Code INTO l_interest_code_id;
819: IF (C_Get_Int_Code%NOTFOUND) THEN
820: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
821: FND_MESSAGE.Set_Name ('AS', 'API_ATTRIBUTE_CONVERSION_ERROR');
822: FND_MESSAGE.Set_Token ('COLUMN', 'PRIMARY_INTEREST_CODE', FALSE);
823: FND_MESSAGE.Set_Token('VALUE', p_primary_interest_code, FALSE);
824: FND_MSG_PUB.Add;
825: END IF;

Line 822: FND_MESSAGE.Set_Token ('COLUMN', 'PRIMARY_INTEREST_CODE', FALSE);

818: FETCH C_Get_Int_Code INTO l_interest_code_id;
819: IF (C_Get_Int_Code%NOTFOUND) THEN
820: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
821: FND_MESSAGE.Set_Name ('AS', 'API_ATTRIBUTE_CONVERSION_ERROR');
822: FND_MESSAGE.Set_Token ('COLUMN', 'PRIMARY_INTEREST_CODE', FALSE);
823: FND_MESSAGE.Set_Token('VALUE', p_primary_interest_code, FALSE);
824: FND_MSG_PUB.Add;
825: END IF;
826:

Line 823: FND_MESSAGE.Set_Token('VALUE', p_primary_interest_code, FALSE);

819: IF (C_Get_Int_Code%NOTFOUND) THEN
820: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
821: FND_MESSAGE.Set_Name ('AS', 'API_ATTRIBUTE_CONVERSION_ERROR');
822: FND_MESSAGE.Set_Token ('COLUMN', 'PRIMARY_INTEREST_CODE', FALSE);
823: FND_MESSAGE.Set_Token('VALUE', p_primary_interest_code, FALSE);
824: FND_MSG_PUB.Add;
825: END IF;
826:
827: p_return_status := FND_API.G_RET_STS_ERROR;

Line 849: FND_MESSAGE.Set_Name ('AS', 'API_ATTRIBUTE_IGNORED');

845: p_secondary_interest_code <> FND_API.G_MISS_CHAR)
846: THEN
847: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
848: THEN
849: FND_MESSAGE.Set_Name ('AS', 'API_ATTRIBUTE_IGNORED');
850: FND_MESSAGE.Set_Token ('COLUMN', 'SECONDARY_INTEREST_CODE', FALSE);
851: FND_MSG_PUB.Add;
852: END IF;
853: END IF;

Line 850: FND_MESSAGE.Set_Token ('COLUMN', 'SECONDARY_INTEREST_CODE', FALSE);

846: THEN
847: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
848: THEN
849: FND_MESSAGE.Set_Name ('AS', 'API_ATTRIBUTE_IGNORED');
850: FND_MESSAGE.Set_Token ('COLUMN', 'SECONDARY_INTEREST_CODE', FALSE);
851: FND_MSG_PUB.Add;
852: END IF;
853: END IF;
854:

Line 862: FND_MESSAGE.Set_Name ('AS', 'API_ATTRIBUTE_CONVERSION_ERROR');

858: OPEN C_Get_Int_Code ( p_secondary_interest_code, l_interest_type_id );
859: FETCH C_Get_Int_Code INTO l_secondary_interest_code_id;
860: IF(C_Get_Int_Code%NOTFOUND) THEN
861: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
862: FND_MESSAGE.Set_Name ('AS', 'API_ATTRIBUTE_CONVERSION_ERROR');
863: FND_MESSAGE.Set_Token ('COLUMN', 'SECONDARY_INTEREST_CODE', FALSE);
864: FND_MESSAGE.Set_Token('VALUE', p_secondary_interest_code, FALSE);
865: FND_MSG_PUB.Add;
866: END IF;

Line 863: FND_MESSAGE.Set_Token ('COLUMN', 'SECONDARY_INTEREST_CODE', FALSE);

859: FETCH C_Get_Int_Code INTO l_secondary_interest_code_id;
860: IF(C_Get_Int_Code%NOTFOUND) THEN
861: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
862: FND_MESSAGE.Set_Name ('AS', 'API_ATTRIBUTE_CONVERSION_ERROR');
863: FND_MESSAGE.Set_Token ('COLUMN', 'SECONDARY_INTEREST_CODE', FALSE);
864: FND_MESSAGE.Set_Token('VALUE', p_secondary_interest_code, FALSE);
865: FND_MSG_PUB.Add;
866: END IF;
867: p_return_status := FND_API.G_RET_STS_ERROR;

Line 864: FND_MESSAGE.Set_Token('VALUE', p_secondary_interest_code, FALSE);

860: IF(C_Get_Int_Code%NOTFOUND) THEN
861: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
862: FND_MESSAGE.Set_Name ('AS', 'API_ATTRIBUTE_CONVERSION_ERROR');
863: FND_MESSAGE.Set_Token ('COLUMN', 'SECONDARY_INTEREST_CODE', FALSE);
864: FND_MESSAGE.Set_Token('VALUE', p_secondary_interest_code, FALSE);
865: FND_MSG_PUB.Add;
866: END IF;
867: p_return_status := FND_API.G_RET_STS_ERROR;
868:

Line 894: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');

890:
891: IF interest_code_desc%NOTFOUND THEN
892: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
893: THEN
894: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
895: FND_MESSAGE.Set_Token('COLUMN', 'SECONDARY_INTEREST_CODE_ID,INTEREST_TYPE_ID', FALSE);
896: FND_MESSAGE.Set_Token('VALUE', to_char(l_Secondary_Interest_Code_Id)
897: || ',' || to_char(l_Interest_Type_Id), FALSE);
898: FND_MSG_PUB.ADD;

Line 895: FND_MESSAGE.Set_Token('COLUMN', 'SECONDARY_INTEREST_CODE_ID,INTEREST_TYPE_ID', FALSE);

891: IF interest_code_desc%NOTFOUND THEN
892: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
893: THEN
894: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
895: FND_MESSAGE.Set_Token('COLUMN', 'SECONDARY_INTEREST_CODE_ID,INTEREST_TYPE_ID', FALSE);
896: FND_MESSAGE.Set_Token('VALUE', to_char(l_Secondary_Interest_Code_Id)
897: || ',' || to_char(l_Interest_Type_Id), FALSE);
898: FND_MSG_PUB.ADD;
899: END IF;

Line 896: FND_MESSAGE.Set_Token('VALUE', to_char(l_Secondary_Interest_Code_Id)

892: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
893: THEN
894: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
895: FND_MESSAGE.Set_Token('COLUMN', 'SECONDARY_INTEREST_CODE_ID,INTEREST_TYPE_ID', FALSE);
896: FND_MESSAGE.Set_Token('VALUE', to_char(l_Secondary_Interest_Code_Id)
897: || ',' || to_char(l_Interest_Type_Id), FALSE);
898: FND_MSG_PUB.ADD;
899: END IF;
900: close interest_code_desc;

Line 915: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');

911:
912: IF interest_code_desc%NOTFOUND THEN
913: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
914: THEN
915: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
916: FND_MESSAGE.Set_Token('COLUMN', 'PRIMARY_INTEREST_CODE_ID,INTEREST_TYPE_ID', FALSE);
917: FND_MESSAGE.Set_Token('VALUE', to_char(l_Interest_Code_Id)
918: || ',' || to_char(l_Interest_Type_Id), FALSE);
919: FND_MSG_PUB.ADD;

Line 916: FND_MESSAGE.Set_Token('COLUMN', 'PRIMARY_INTEREST_CODE_ID,INTEREST_TYPE_ID', FALSE);

912: IF interest_code_desc%NOTFOUND THEN
913: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
914: THEN
915: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
916: FND_MESSAGE.Set_Token('COLUMN', 'PRIMARY_INTEREST_CODE_ID,INTEREST_TYPE_ID', FALSE);
917: FND_MESSAGE.Set_Token('VALUE', to_char(l_Interest_Code_Id)
918: || ',' || to_char(l_Interest_Type_Id), FALSE);
919: FND_MSG_PUB.ADD;
920: END IF;

Line 917: FND_MESSAGE.Set_Token('VALUE', to_char(l_Interest_Code_Id)

913: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
914: THEN
915: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
916: FND_MESSAGE.Set_Token('COLUMN', 'PRIMARY_INTEREST_CODE_ID,INTEREST_TYPE_ID', FALSE);
917: FND_MESSAGE.Set_Token('VALUE', to_char(l_Interest_Code_Id)
918: || ',' || to_char(l_Interest_Type_Id), FALSE);
919: FND_MSG_PUB.ADD;
920: END IF;
921:

Line 936: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');

932:
933: IF interest_type_desc%NOTFOUND THEN
934: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
935: THEN
936: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
937: FND_MESSAGE.Set_Token('COLUMN', 'INTEREST_TYPE_ID', FALSE);
938: FND_MESSAGE.Set_Token('VALUE', l_Interest_Type_Id, FALSE);
939: FND_MSG_PUB.ADD;
940: END IF;

Line 937: FND_MESSAGE.Set_Token('COLUMN', 'INTEREST_TYPE_ID', FALSE);

933: IF interest_type_desc%NOTFOUND THEN
934: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
935: THEN
936: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
937: FND_MESSAGE.Set_Token('COLUMN', 'INTEREST_TYPE_ID', FALSE);
938: FND_MESSAGE.Set_Token('VALUE', l_Interest_Type_Id, FALSE);
939: FND_MSG_PUB.ADD;
940: END IF;
941: close interest_type_desc;

Line 938: FND_MESSAGE.Set_Token('VALUE', l_Interest_Type_Id, FALSE);

934: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
935: THEN
936: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
937: FND_MESSAGE.Set_Token('COLUMN', 'INTEREST_TYPE_ID', FALSE);
938: FND_MESSAGE.Set_Token('VALUE', l_Interest_Type_Id, FALSE);
939: FND_MSG_PUB.ADD;
940: END IF;
941: close interest_type_desc;
942: RAISE FND_API.G_EXC_ERROR;