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

Line 98: fnd_msg_pub.initialize;

94:
95: -- initialize message list if p_init_msg_list is set to true.
96: if fnd_api.to_boolean( p_init_msg_list )
97: then
98: fnd_msg_pub.initialize;
99: end if;
100:
101: -- Debug Message
102: if fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)

Line 102: if fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)

98: fnd_msg_pub.initialize;
99: end if;
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;

Line 105: fnd_msg_pub.add;

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
109: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 162: if fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)

158: commit work;
159: end if;
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;

Line 165: fnd_msg_pub.add;

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:
169: -- Standard call to get message count and if count is 1, get message info.

Line 170: fnd_msg_pub.count_and_get( p_count => p_msg_count

166: end if;
167:
168:
169: -- Standard call to get message count and if count is 1, get message info.
170: fnd_msg_pub.count_and_get( p_count => p_msg_count
171: ,p_data => p_msg_data );
172:
173: exception
174:

Line 181: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

177: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
178: P_MODULE => l_module
179: ,P_API_NAME => L_API_NAME
180: ,P_PKG_NAME => G_PKG_NAME
181: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
182: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
183: ,X_MSG_COUNT => P_MSG_COUNT
184: ,X_MSG_DATA => P_MSG_DATA
185: ,X_RETURN_STATUS => P_RETURN_STATUS);

Line 193: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

189: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
190: P_MODULE => l_module
191: ,P_API_NAME => L_API_NAME
192: ,P_PKG_NAME => G_PKG_NAME
193: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
194: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
195: ,X_MSG_COUNT => P_MSG_COUNT
196: ,X_MSG_DATA => P_MSG_DATA
197: ,X_RETURN_STATUS => P_RETURN_STATUS);

Line 305: FND_MSG_PUB.initialize;

301:
302: -- Initialize message list if p_init_msg_list is set to TRUE.
303: IF FND_API.to_Boolean( p_init_msg_list )
304: THEN
305: FND_MSG_PUB.initialize;
306: END IF;
307:
308: -- Debug Message
309: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

Line 309: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

305: FND_MSG_PUB.initialize;
306: END IF;
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;

Line 312: FND_MSG_PUB.Add;

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
316: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 389: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) and

385: );
386:
387: x_interest_id := p_interest_rec.interest_id;
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);

Line 394: FND_MSG_PUB.Add;

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;
398: l_lead_id := p_interest_rec.lead_id;

Line 413: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

409: COMMIT WORK;
410: END IF;
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;

Line 416: FND_MSG_PUB.Add;

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.
420: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

Line 420: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

416: FND_MSG_PUB.Add;
417: END IF;
418:
419: -- Standard call to get message count and if count is 1, get message info.
420: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
421: p_data => x_msg_data
422: );
423:
424: EXCEPTION

Line 431: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

427: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
428: P_MODULE => l_module
429: ,P_API_NAME => L_API_NAME
430: ,P_PKG_NAME => G_PKG_NAME
431: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
432: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
433: ,X_MSG_COUNT => X_MSG_COUNT
434: ,X_MSG_DATA => X_MSG_DATA
435: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 442: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

438: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
439: P_MODULE => l_module
440: ,P_API_NAME => L_API_NAME
441: ,P_PKG_NAME => G_PKG_NAME
442: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
443: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
444: ,X_MSG_COUNT => X_MSG_COUNT
445: ,X_MSG_DATA => X_MSG_DATA
446: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 507: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

503:
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:

Line 509: FND_MSG_PUB.Add;

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
513: --

Line 522: /* IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN

518: BEGIN
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;

Line 526: FND_MSG_PUB.Add;

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:
530: -- For each value - id pair, if id exists use it, otherwise convert values to ids

Line 572: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

568:
569: IF (p_interest_tbl(l_curr_row).status is not NULL
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;

Line 576: FND_MSG_PUB.Add;

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:
580: ELSIF (p_interest_tbl(l_curr_row).status is not NULL

Line 592: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

588: p_pvt_interest_tbl(l_curr_row).status_code := l_val;
589:
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);

Line 597: FND_MSG_PUB.Add;

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;
601: ELSE

Line 652: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

648:
649: END LOOP;
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;

Line 655: FND_MSG_PUB.Add;

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:
659: IF l_any_errors

Line 661: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

657:
658:
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;

Line 665: FND_MSG_PUB.Add;

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:
669: END Convert_Values_To_Ids;

Line 745: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

741:
742: IF (p_interest_type is not NULL and
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;

Line 749: FND_MSG_PUB.Add;

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:
753: ELSIF (p_interest_type is not NULL and

Line 760: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

756: OPEN C_Get_Int_Type ( p_interest_type );
757: FETCH C_Get_Int_Type INTO l_interest_type_id;
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);

Line 765: FND_MSG_PUB.Add;

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
769: -- is dependent upon interest_type existing

Line 781: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

777: CLOSE C_Get_Int_Type;
778: ELSE
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;

Line 785: FND_MSG_PUB.Add;

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
789: -- is dependent upon interest_type existing

Line 806: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

802:
803: IF (p_primary_interest_code is not NULL and
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;

Line 810: FND_MSG_PUB.Add;

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:
814: ELSIF (p_primary_interest_code is not NULL and

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

816: THEN
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;

Line 824: FND_MSG_PUB.Add;

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;
828:

Line 847: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)

843:
844: IF (p_secondary_interest_code is not NULL and
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;

Line 851: FND_MSG_PUB.Add;

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:
855: ELSIF (p_secondary_interest_code is not NULL and

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

857: THEN
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;

Line 865: FND_MSG_PUB.Add;

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:
869: ELSE

Line 892: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

888: ,l_Interest_Type_Id);
889: fetch interest_code_desc into p_out_description;
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)

Line 898: FND_MSG_PUB.ADD;

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;
901: RAISE FND_API.G_EXC_ERROR;
902:

Line 913: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

909: ,l_Interest_Type_Id);
910: fetch interest_code_desc into p_out_description;
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)

Line 919: FND_MSG_PUB.ADD;

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:
922: close interest_code_desc;
923: RAISE FND_API.G_EXC_ERROR;

Line 934: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

930: open interest_type_desc(l_Interest_Type_Id);
931: fetch interest_type_desc into p_out_description;
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);

Line 939: FND_MSG_PUB.ADD;

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;
943: ELSE

Line 974: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

970: ) is
971: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Interest';
972: l_api_version_number CONSTANT NUMBER := 2.0;
973: l_interest_rec AS_INTEREST_PVT.Interest_Rec_Type;
974: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
975: l_module CONSTANT VARCHAR2(255) := 'as.plsql.intpb.Delete_Interest';
976: begin
977: SAVEPOINT DELETE_INTEREST_PUB;
978: -- Standard call to check for call compatibility.

Line 990: FND_MSG_PUB.initialize;

986:
987: -- Initialize message list if p_init_msg_list is set to TRUE.
988: IF FND_API.to_Boolean( p_init_msg_list )
989: THEN
990: FND_MSG_PUB.initialize;
991: END IF;
992:
993: -- Debug Message
994: IF l_debug THEN

Line 995: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

991: END IF;
992:
993: -- Debug Message
994: IF l_debug THEN
995: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
996: 'Public API: ' || l_api_name || 'start');
997:
998: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
999: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

Line 998: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

994: IF l_debug THEN
995: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
996: 'Public API: ' || l_api_name || 'start');
997:
998: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
999: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1000: END IF;
1001:
1002: -- Initialize API return status to SUCCESS

Line 1009: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1005: --
1006: -- API body
1007: --
1008: IF l_debug THEN
1009: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1010: 'Public API: Calling AS_ACCESS_PVT.delete_interest');
1011: END IF;
1012:
1013: l_interest_rec.interest_id := p_interest_rec.interest_id;

Line 1054: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1050:
1051:
1052: -- Debug Message
1053: IF l_debug THEN
1054: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1055: 'Public API: ' || l_api_name || 'end');
1056:
1057: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
1058: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

Line 1057: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'

1053: IF l_debug THEN
1054: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1055: 'Public API: ' || l_api_name || 'end');
1056:
1057: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
1058: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1059: END IF;
1060:
1061:

Line 1062: FND_MSG_PUB.Count_And_Get

1058: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1059: END IF;
1060:
1061:
1062: FND_MSG_PUB.Count_And_Get
1063: ( p_count => x_msg_count,
1064: p_data => x_msg_data
1065: );
1066:

Line 1073: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1069: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1070: P_MODULE => l_module
1071: ,P_API_NAME => L_API_NAME
1072: ,P_PKG_NAME => G_PKG_NAME
1073: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1074: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1075: ,X_MSG_COUNT => X_MSG_COUNT
1076: ,X_MSG_DATA => X_MSG_DATA
1077: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1084: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1080: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1081: P_MODULE => l_module
1082: ,P_API_NAME => L_API_NAME
1083: ,P_PKG_NAME => G_PKG_NAME
1084: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1085: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1086: ,X_MSG_COUNT => X_MSG_COUNT
1087: ,X_MSG_DATA => X_MSG_DATA
1088: ,X_RETURN_STATUS => X_RETURN_STATUS);