APPS.AS_OPP_CONTACT_PVT dependencies on FND_MSG_PUB

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

40: l_LEAD_CONTACT_ID NUMBER;
41: l_line_count CONSTANT NUMBER := P_CONTACT_Tbl.count;
42: l_update_access_flag VARCHAR2(1);
43: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;
44: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
45: l_module CONSTANT VARCHAR2(255) := 'as.plsql.lcnpv.Create_opp_contacts';
46:
47: Cursor C_Get_Primary_Contact ( c_LEAD_ID NUMBER ) IS
48: SELECT lead_contact_id

Line 71: FND_MSG_PUB.initialize;

67:
68: -- Initialize message list if p_init_msg_list is set to TRUE.
69: IF FND_API.to_Boolean( p_init_msg_list )
70: THEN
71: FND_MSG_PUB.initialize;
72: END IF;
73:
74:
75: -- Debug Message

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

73:
74:
75: -- Debug Message
76: IF l_debug THEN
77: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
78: 'Private API: ' || l_api_name || ' start');
79: END IF;
80:
81: -- Initialize API return status to SUCCESS

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

110: -- Validate Environment
111: -- ******************************************************************
112: IF FND_GLOBAL.User_Id IS NULL
113: THEN
114: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
115: THEN
116: FND_MESSAGE.Set_Name(' + appShortName +',
117: 'UT_CANNOT_GET_PROFILE_VALUE');
118: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);

Line 119: FND_MSG_PUB.ADD;

115: THEN
116: FND_MESSAGE.Set_Name(' + appShortName +',
117: 'UT_CANNOT_GET_PROFILE_VALUE');
118: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
119: FND_MSG_PUB.ADD;
120: END IF;
121: RAISE FND_API.G_EXC_ERROR;
122: END IF;
123:

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

132: ,x_msg_data => x_msg_data
133: ,x_sales_member_rec => l_identity_sales_member_rec);
134:
135: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
136: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
137: IF l_debug THEN
138: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
139: 'Private API: Get_CurrentUser fail');
140: END IF;

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

134:
135: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
136: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
137: IF l_debug THEN
138: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
139: 'Private API: Get_CurrentUser fail');
140: END IF;
141: END IF;
142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

165: ,x_msg_data => x_msg_data
166: ,x_update_access_flag => l_update_access_flag );
167:
168: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
169: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
170: IF l_debug THEN
171: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
172: 'has_updateOpportunityAccess fail');
173: END IF;

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

167:
168: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
169: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
170: IF l_debug THEN
171: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
172: 'has_updateOpportunityAccess fail');
173: END IF;
174: END IF;
175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
176: END IF;
177:
178: IF (l_update_access_flag <> 'Y') THEN
179: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
180: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');
181: FND_MESSAGE.Set_Token('INFO', 'CUSTOMER_ID,OPPORTUNITY_ID,SALESFORCE_ID', FALSE);
182: FND_MSG_PUB.ADD;
183: END IF;

Line 182: FND_MSG_PUB.ADD;

178: IF (l_update_access_flag <> 'Y') THEN
179: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
180: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');
181: FND_MESSAGE.Set_Token('INFO', 'CUSTOMER_ID,OPPORTUNITY_ID,SALESFORCE_ID', FALSE);
182: FND_MSG_PUB.ADD;
183: END IF;
184: RAISE FND_API.G_EXC_ERROR;
185: END IF;
186: END IF;

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

189: X_Contact_out_tbl(l_curr_row).return_status:=FND_API.G_RET_STS_SUCCESS;
190:
191: -- Progress Message
192: --
193: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
194: THEN
195: FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
196: FND_MESSAGE.Set_Token ('ROW', 'AS_LEAD_CONTACT', TRUE);
197: FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(l_curr_row), FALSE);

Line 198: FND_MSG_PUB.Add;

194: THEN
195: FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
196: FND_MESSAGE.Set_Token ('ROW', 'AS_LEAD_CONTACT', TRUE);
197: FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(l_curr_row), FALSE);
198: FND_MSG_PUB.Add;
199: END IF;
200:
201: l_Contact_rec := P_Contact_Tbl(l_curr_row);
202:

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

209: END IF;
210:
211: -- Debug message
212: IF l_debug THEN
213: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
214: 'Private API: Validate_opp_contact');
215: END IF;
216:
217: -- Invoke validation procedures

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

227:
228: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
229: -- Debug message
230: IF l_debug THEN
231: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
232: 'Private API: Validate_opp_Contact fail');
233: END IF;
234: RAISE FND_API.G_EXC_ERROR;
235: END IF;

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

236:
237:
238: -- Debug Message
239: IF l_debug THEN
240: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
241: 'Private API: Calling create table handler');
242: END IF;
243: -- the following condition and updation added for Bug#4641320
244: IF l_Contact_rec.PRIMARY_CONTACT_FLAG = 'Y'

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

303: RAISE FND_API.G_EXC_ERROR;
304: END IF;
305:
306: IF l_debug THEN
307: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
308: 'Private API: Created lead_contact_id = ' || l_LEAD_CONTACT_ID);
309: END IF;
310:
311: END LOOP;

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

321:
322:
323: -- Debug Message
324: IF l_debug THEN
325: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
326: 'Private API: ' || l_api_name || ' end');
327:
328: END IF;
329: -- Standard call to get message count and if count is 1, get message info.

Line 330: FND_MSG_PUB.Count_And_Get

326: 'Private API: ' || l_api_name || ' end');
327:
328: END IF;
329: -- Standard call to get message count and if count is 1, get message info.
330: FND_MSG_PUB.Count_And_Get
331: ( p_count => x_msg_count,
332: p_data => x_msg_data
333: );
334:

Line 361: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

357: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
358: P_MODULE => l_module
359: ,P_API_NAME => L_API_NAME
360: ,P_PKG_NAME => G_PKG_NAME
361: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
362: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
363: ,X_MSG_COUNT => X_MSG_COUNT
364: ,X_MSG_DATA => X_MSG_DATA
365: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 372: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

368: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
369: P_MODULE => l_module
370: ,P_API_NAME => L_API_NAME
371: ,P_PKG_NAME => G_PKG_NAME
372: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
373: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
374: ,X_MSG_COUNT => X_MSG_COUNT
375: ,X_MSG_DATA => X_MSG_DATA
376: ,X_RETURN_STATUS => X_RETURN_STATUS);

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

424: l_line_count CONSTANT NUMBER := P_Contact_Tbl.count;
425: l_last_update_date DATE;
426: l_update_access_flag VARCHAR2(1);
427: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;
428: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
429: l_module CONSTANT VARCHAR2(255) := 'as.plsql.lcnpv.Update_opp_contacts';
430:
431: BEGIN
432: -- Standard Start of API savepoint

Line 448: FND_MSG_PUB.initialize;

444:
445: -- Initialize message list if p_init_msg_list is set to TRUE.
446: IF FND_API.to_Boolean( p_init_msg_list )
447: THEN
448: FND_MSG_PUB.initialize;
449: END IF;
450:
451:
452: -- Debug Message

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

450:
451:
452: -- Debug Message
453: IF l_debug THEN
454: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
455: 'Private API: ' || l_api_name || ' start');
456: END IF;
457:
458:

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

494: ,x_msg_data => x_msg_data
495: ,x_sales_member_rec => l_identity_sales_member_rec);
496:
497: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
498: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
499: IF l_debug THEN
500: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
501: 'Private API: Get_CurrentUser fail');
502: END IF;

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

496:
497: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
498: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
499: IF l_debug THEN
500: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
501: 'Private API: Get_CurrentUser fail');
502: END IF;
503: END IF;
504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

527: ,x_msg_data => x_msg_data
528: ,x_update_access_flag => l_update_access_flag );
529:
530: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
531: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
532: IF l_debug THEN
533: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
534: 'has_updateOpportunityAccess fail');
535: END IF;

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

529:
530: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
531: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
532: IF l_debug THEN
533: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
534: 'has_updateOpportunityAccess fail');
535: END IF;
536: END IF;
537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
538: END IF;
539:
540: IF (l_update_access_flag <> 'Y') THEN
541: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
542: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');
543: FND_MESSAGE.Set_Token('INFO', 'CUSTOMER_ID,OPPORTUNITY_ID,SALESFORCE_ID', FALSE);
544: FND_MSG_PUB.ADD;
545: END IF;

Line 544: FND_MSG_PUB.ADD;

540: IF (l_update_access_flag <> 'Y') THEN
541: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
542: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');
543: FND_MESSAGE.Set_Token('INFO', 'CUSTOMER_ID,OPPORTUNITY_ID,SALESFORCE_ID', FALSE);
544: FND_MSG_PUB.ADD;
545: END IF;
546: RAISE FND_API.G_EXC_ERROR;
547: END IF;
548: END IF;

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

552: X_Contact_out_tbl(l_curr_row).return_status:=FND_API.G_RET_STS_SUCCESS;
553:
554: -- Progress Message
555: --
556: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
557: THEN
558: FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
559: FND_MESSAGE.Set_Token ('ROW', 'AS_LEAD_CONTACT', TRUE);
560: FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(l_curr_row), FALSE);

Line 561: FND_MSG_PUB.Add;

557: THEN
558: FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
559: FND_MESSAGE.Set_Token ('ROW', 'AS_LEAD_CONTACT', TRUE);
560: FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(l_curr_row), FALSE);
561: FND_MSG_PUB.Add;
562: END IF;
563:
564: l_Contact_rec := P_Contact_Tbl(l_curr_row);
565:

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

572: END IF;
573:
574: -- Debug Message
575: IF l_debug THEN
576: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
577: 'Private API: - Open Cursor to Select');
578:
579: END IF;
580:

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

582:
583: Fetch C_Get_opp_contact into l_last_update_date;
584:
585: If ( C_Get_opp_contact%NOTFOUND) Then
586: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
587: THEN
588: FND_MESSAGE.Set_Name('AS', 'API_MISSING_UPDATE_TARGET');
589: FND_MESSAGE.Set_Token ('INFO', 'opp_contact', FALSE);
590: FND_MSG_PUB.Add;

Line 590: FND_MSG_PUB.Add;

586: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
587: THEN
588: FND_MESSAGE.Set_Name('AS', 'API_MISSING_UPDATE_TARGET');
589: FND_MESSAGE.Set_Token ('INFO', 'opp_contact', FALSE);
590: FND_MSG_PUB.Add;
591: END IF;
592: raise FND_API.G_EXC_ERROR;
593: END IF;
594:

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

593: END IF;
594:
595: -- Debug Message
596: IF l_debug THEN
597: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
598: 'Private API: - Close Cursor');
599: END IF;
600:
601: Close C_Get_opp_contact;

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

601: Close C_Get_opp_contact;
602:
603: If (l_Contact_rec.last_update_date is NULL or
604: l_Contact_rec.last_update_date = FND_API.G_MISS_Date ) Then
605: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
606: THEN
607: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
608: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
609: FND_MSG_PUB.ADD;

Line 609: FND_MSG_PUB.ADD;

605: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
606: THEN
607: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
608: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
609: FND_MSG_PUB.ADD;
610: END IF;
611: raise FND_API.G_EXC_ERROR;
612: End if;
613: -- Check Whether record has been changed by someone else

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

611: raise FND_API.G_EXC_ERROR;
612: End if;
613: -- Check Whether record has been changed by someone else
614: If (l_Contact_rec.last_update_date <> l_last_update_date) Then
615: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
616: THEN
617: FND_MESSAGE.Set_Name('AS', 'API_RECORD_CHANGED');
618: FND_MESSAGE.Set_Token('INFO', 'opp_contact', FALSE);
619: FND_MSG_PUB.ADD;

Line 619: FND_MSG_PUB.ADD;

615: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
616: THEN
617: FND_MESSAGE.Set_Name('AS', 'API_RECORD_CHANGED');
618: FND_MESSAGE.Set_Token('INFO', 'opp_contact', FALSE);
619: FND_MSG_PUB.ADD;
620: END IF;
621: raise FND_API.G_EXC_ERROR;
622: End if;
623:

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

622: End if;
623:
624: -- Debug message
625: IF l_debug THEN
626: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
627: 'Private API: Validate_opp_contact');
628:
629: END IF;
630: -- Invoke validation procedures

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

639:
640: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
641: -- Debug message
642: IF l_debug THEN
643: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
644: 'Private API: Validate_opp_Contact fail');
645: END IF;
646: RAISE FND_API.G_EXC_ERROR;
647: END IF;

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

647: END IF;
648:
649: -- Debug Message
650: IF l_debug THEN
651: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
652: 'Private API: Calling update table handler');
653:
654: END IF;
655: -- Invoke table handler(AS_LEAD_CONTACTS_PKG.Update_Row)

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

700: RAISE FND_API.G_EXC_ERROR;
701: END IF;
702:
703: IF l_debug THEN
704: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
705: 'Private API: Updated lead_contact_id = ' ||l_Contact_rec.LEAD_CONTACT_ID );
706: END IF;
707: END LOOP;
708:

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

718:
719:
720: -- Debug Message
721: IF l_debug THEN
722: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
723: 'Private API: ' || l_api_name || ' end');
724: END IF;
725:
726:

Line 728: FND_MSG_PUB.Count_And_Get

724: END IF;
725:
726:
727: -- Standard call to get message count and if count is 1, get message info.
728: FND_MSG_PUB.Count_And_Get
729: ( p_count => x_msg_count,
730: p_data => x_msg_data
731: );
732:

Line 759: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

755: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
756: P_MODULE => l_module
757: ,P_API_NAME => L_API_NAME
758: ,P_PKG_NAME => G_PKG_NAME
759: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
760: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
761: ,X_MSG_COUNT => X_MSG_COUNT
762: ,X_MSG_DATA => X_MSG_DATA
763: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 770: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

766: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
767: P_MODULE => l_module
768: ,P_API_NAME => L_API_NAME
769: ,P_PKG_NAME => G_PKG_NAME
770: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
771: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
772: ,X_MSG_COUNT => X_MSG_COUNT
773: ,X_MSG_DATA => X_MSG_DATA
774: ,X_RETURN_STATUS => X_RETURN_STATUS);

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

811: l_Contact_Rec AS_OPPORTUNITY_PUB.Contact_Rec_Type;
812: l_line_count CONSTANT NUMBER := P_Contact_Tbl.count;
813: l_update_access_flag VARCHAR2(1);
814: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;
815: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
816: l_module CONSTANT VARCHAR2(255) := 'as.plsql.lcnpv.Delete_opp_contacts';
817: BEGIN
818: -- Standard Start of API savepoint
819: SAVEPOINT DELETE_OPP_CONTACTS_PVT;

Line 834: FND_MSG_PUB.initialize;

830:
831: -- Initialize message list if p_init_msg_list is set to TRUE.
832: IF FND_API.to_Boolean( p_init_msg_list )
833: THEN
834: FND_MSG_PUB.initialize;
835: END IF;
836:
837:
838: -- Debug Message

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

836:
837:
838: -- Debug Message
839: IF l_debug THEN
840: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
841: 'Private API: ' || l_api_name || ' start');
842: END IF;
843:
844:

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

880: ,x_msg_data => x_msg_data
881: ,x_sales_member_rec => l_identity_sales_member_rec);
882:
883: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
884: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
885: IF l_debug THEN
886: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
887: 'Private API: Get_CurrentUser fail');
888: END IF;

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

882:
883: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
884: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
885: IF l_debug THEN
886: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
887: 'Private API: Get_CurrentUser fail');
888: END IF;
889: END IF;
890: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

913: ,x_msg_data => x_msg_data
914: ,x_update_access_flag => l_update_access_flag );
915:
916: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
917: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
918: IF l_debug THEN
919: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
920: 'has_updateOpportunityAccess fail');
921: END IF;

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

915:
916: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
917: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
918: IF l_debug THEN
919: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
920: 'has_updateOpportunityAccess fail');
921: END IF;
922: END IF;
923: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

923: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
924: END IF;
925:
926: IF (l_update_access_flag <> 'Y') THEN
927: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
928: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');
929: FND_MESSAGE.Set_Token('INFO', 'CUSTOMER_ID,OPPORTUNITY_ID,SALESFORCE_ID', FALSE);
930: FND_MSG_PUB.ADD;
931: END IF;

Line 930: FND_MSG_PUB.ADD;

926: IF (l_update_access_flag <> 'Y') THEN
927: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
928: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');
929: FND_MESSAGE.Set_Token('INFO', 'CUSTOMER_ID,OPPORTUNITY_ID,SALESFORCE_ID', FALSE);
930: FND_MSG_PUB.ADD;
931: END IF;
932: RAISE FND_API.G_EXC_ERROR;
933: END IF;
934: END IF;

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

938: X_Contact_out_tbl(l_curr_row).return_status:=FND_API.G_RET_STS_SUCCESS;
939:
940: -- Progress Message
941: --
942: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
943: THEN
944: FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
945: FND_MESSAGE.Set_Token ('ROW', 'AS_LEAD_CONTACT', TRUE);
946: FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(l_curr_row), FALSE);

Line 947: FND_MSG_PUB.Add;

943: THEN
944: FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
945: FND_MESSAGE.Set_Token ('ROW', 'AS_LEAD_CONTACT', TRUE);
946: FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(l_curr_row), FALSE);
947: FND_MSG_PUB.Add;
948: END IF;
949:
950: l_Contact_rec := P_Contact_Tbl(l_curr_row);
951:

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

951:
952:
953: -- Debug Message
954: IF l_debug THEN
955: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
956: 'Private API: Calling delete table handler');
957:
958: END IF;
959: -- Invoke table handler(AS_LEAD_CONTACTS_PKG.Delete_Row)

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

982:
983:
984: -- Debug Message
985: IF l_debug THEN
986: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
987: 'Private API: ' || l_api_name || ' end');
988: END IF;
989:
990: -- Standard call to get message count and if count is 1, get message info.

Line 991: FND_MSG_PUB.Count_And_Get

987: 'Private API: ' || l_api_name || ' end');
988: END IF;
989:
990: -- Standard call to get message count and if count is 1, get message info.
991: FND_MSG_PUB.Count_And_Get
992: ( p_count => x_msg_count,
993: p_data => x_msg_data
994: );
995:

Line 1022: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1018: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1019: P_MODULE => l_module
1020: ,P_API_NAME => L_API_NAME
1021: ,P_PKG_NAME => G_PKG_NAME
1022: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1023: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1024: ,X_MSG_COUNT => X_MSG_COUNT
1025: ,X_MSG_DATA => X_MSG_DATA
1026: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1033: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1029: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1030: P_MODULE => l_module
1031: ,P_API_NAME => L_API_NAME
1032: ,P_PKG_NAME => G_PKG_NAME
1033: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1034: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1035: ,X_MSG_COUNT => X_MSG_COUNT
1036: ,X_MSG_DATA => X_MSG_DATA
1037: ,X_RETURN_STATUS => X_RETURN_STATUS);

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

1068: FROM as_lead_contacts
1069: WHERE lead_contact_id = c_Lead_Contact_Id;
1070:
1071: l_val VARCHAR2(1);
1072: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
1073: l_module CONSTANT VARCHAR2(255) := 'as.plsql.lcnpv.Validate_LEAD_CONTACT_ID';
1074:
1075: BEGIN
1076:

Line 1080: FND_MSG_PUB.initialize;

1076:
1077: -- Initialize message list if p_init_msg_list is set to TRUE.
1078: IF FND_API.to_Boolean( p_init_msg_list )
1079: THEN
1080: FND_MSG_PUB.initialize;
1081: END IF;
1082:
1083:
1084: -- Initialize API return status to SUCCESS

Line 1097: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,

1093: OPEN C_Lead_Contact_Id_Exists (p_Lead_Contact_Id);
1094: FETCH C_Lead_Contact_Id_Exists into l_val;
1095: IF C_Lead_Contact_Id_Exists%FOUND THEN
1096: IF l_debug THEN
1097: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1098: 'Private API: LEAD_CONTACT_ID exist');
1099: END IF;
1100:
1101: AS_UTILITY_PVT.Set_Message(

Line 1103: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1099: END IF;
1100:
1101: AS_UTILITY_PVT.Set_Message(
1102: p_module => l_module,
1103: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1104: p_msg_name => 'AS_INVALID_ID',
1105: p_token1 => 'FIELD_ID',
1106: p_token1_value => 'LEAD_CONTACT_ID');
1107:

Line 1120: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,

1116: -- validate NOT NULL column
1117: IF (p_LEAD_CONTACT_ID is NULL) or (p_LEAD_CONTACT_ID = FND_API.G_MISS_NUM)
1118: THEN
1119: IF l_debug THEN
1120: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1121: 'Private API: Violate NOT NULL constraint(LEAD_CONTACT_ID)');
1122: END IF;
1123:
1124: AS_UTILITY_PVT.Set_Message(

Line 1126: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1122: END IF;
1123:
1124: AS_UTILITY_PVT.Set_Message(
1125: p_module => l_module,
1126: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1127: p_msg_name => 'AS_INVALID_ID',
1128: p_token1 => 'FIELD_ID',
1129: p_token1_value => 'LEAD_CONTACT_ID');
1130:

Line 1138: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,

1134: FETCH C_Lead_Contact_Id_Exists into l_val;
1135: IF C_Lead_Contact_Id_Exists%NOTFOUND
1136: THEN
1137: IF l_debug THEN
1138: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1139: 'Private API: LEAD_CONTACT_ID is not valid');
1140: END IF;
1141:
1142: AS_UTILITY_PVT.Set_Message(

Line 1144: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1140: END IF;
1141:
1142: AS_UTILITY_PVT.Set_Message(
1143: p_module => l_module,
1144: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1145: p_msg_name => 'AS_INVALID_ID',
1146: p_token1 => 'FIELD_ID',
1147: p_token1_value => 'LEAD_CONTACT_ID');
1148:

Line 1157: FND_MSG_PUB.Count_And_Get

1153:
1154: END IF;
1155:
1156: -- Standard call to get message count and if count is 1, get message info.
1157: FND_MSG_PUB.Count_And_Get
1158: ( p_count => x_msg_count,
1159: p_data => x_msg_data
1160: );
1161:

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

1178: WHERE lead_id = c_Lead_Id
1179: AND nvl(DELETED_FLAG, 'N') <> 'Y';
1180:
1181: l_val VARCHAR2(1);
1182: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
1183: l_module CONSTANT VARCHAR2(255) := 'as.plsql.lcnpv.Validate_LEAD_ID';
1184: BEGIN
1185:
1186: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1189: FND_MSG_PUB.initialize;

1185:
1186: -- Initialize message list if p_init_msg_list is set to TRUE.
1187: IF FND_API.to_Boolean( p_init_msg_list )
1188: THEN
1189: FND_MSG_PUB.initialize;
1190: END IF;
1191:
1192:
1193: -- Initialize API return status to SUCCESS

Line 1200: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,

1196:
1197: IF (p_LEAD_ID is NULL) or (p_LEAD_ID = FND_API.G_MISS_NUM)
1198: THEN
1199: IF l_debug THEN
1200: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1201: 'Private API: Violate NOT NULL constraint(LEAD_ID)');
1202: END IF;
1203:
1204: AS_UTILITY_PVT.Set_Message(

Line 1206: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1202: END IF;
1203:
1204: AS_UTILITY_PVT.Set_Message(
1205: p_module => l_module,
1206: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1207: p_msg_name => 'AS_INVALID_ID',
1208: p_token1 => 'FIELD_ID',
1209: p_token1_value => 'LEAD_ID');
1210:

Line 1218: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,

1214: FETCH C_Lead_Id_Exists into l_val;
1215: IF C_Lead_Id_Exists%NOTFOUND
1216: THEN
1217: IF l_debug THEN
1218: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1219: 'Private API: LEAD_ID is not valid');
1220: END IF;
1221:
1222: AS_UTILITY_PVT.Set_Message(

Line 1224: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1220: END IF;
1221:
1222: AS_UTILITY_PVT.Set_Message(
1223: p_module => l_module,
1224: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1225: p_msg_name => 'AS_INVALID_ID',
1226: p_token1 => 'FIELD_ID',
1227: p_token1_value => 'LEAD_ID');
1228:

Line 1235: FND_MSG_PUB.Count_And_Get

1231: CLOSE C_Lead_Id_Exists;
1232: END IF;
1233:
1234: -- Standard call to get message count and if count is 1, get message info.
1235: FND_MSG_PUB.Count_And_Get
1236: ( p_count => x_msg_count,
1237: p_data => x_msg_data
1238: );
1239:

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

1258: WHERE contact_id = c_contact_id
1259: AND customer_id = P_CUSTOMER_ID;
1260:
1261: l_val VARCHAR2(1);
1262: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
1263: l_module CONSTANT VARCHAR2(255) := 'as.plsql.lcnpv.Validate_CONTACT_ID';
1264: BEGIN
1265:
1266: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1269: FND_MSG_PUB.initialize;

1265:
1266: -- Initialize message list if p_init_msg_list is set to TRUE.
1267: IF FND_API.to_Boolean( p_init_msg_list )
1268: THEN
1269: FND_MSG_PUB.initialize;
1270: END IF;
1271:
1272:
1273: -- Initialize API return status to SUCCESS

Line 1283: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,

1279: OPEN C_CONTACT_ID_Exists (p_CONTACT_ID);
1280: FETCH C_CONTACT_ID_Exists into l_val;
1281: IF C_CONTACT_ID_Exists%NOTFOUND THEN
1282: IF l_debug THEN
1283: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1284: 'Private API: CONTACT_ID is invalid');
1285: END IF;
1286:
1287: AS_UTILITY_PVT.Set_Message(

Line 1289: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1285: END IF;
1286:
1287: AS_UTILITY_PVT.Set_Message(
1288: p_module => l_module,
1289: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1290: p_msg_name => 'AS_INVALID_ID',
1291: p_token1 => 'FIELD_ID',
1292: p_token1_value => 'CONTACT_ID');
1293:

Line 1300: FND_MSG_PUB.Count_And_Get

1296: CLOSE C_CONTACT_ID_Exists;
1297: END IF;
1298:
1299: -- Standard call to get message count and if count is 1, get message info.
1300: FND_MSG_PUB.Count_And_Get
1301: ( p_count => x_msg_count,
1302: p_data => x_msg_data
1303: );
1304:

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

1314: X_Msg_Count OUT NOCOPY NUMBER,
1315: X_Msg_Data OUT NOCOPY VARCHAR2
1316: )
1317: IS
1318: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
1319: l_module CONSTANT VARCHAR2(255) := 'as.plsql.lcnpv.Validate_ENABLED_FLAG';
1320: BEGIN
1321:
1322: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1325: FND_MSG_PUB.initialize;

1321:
1322: -- Initialize message list if p_init_msg_list is set to TRUE.
1323: IF FND_API.to_Boolean( p_init_msg_list )
1324: THEN
1325: FND_MSG_PUB.initialize;
1326: END IF;
1327:
1328:
1329: -- Initialize API return status to SUCCESS

Line 1338: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,

1334: p_ENABLED_FLAG = FND_API.G_MISS_CHAR )
1335: THEN
1336: --The following code commented by SUBABU for Bug#3537692(ASN)
1337: /*IF l_debug THEN
1338: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,
1339: 'Private API: Violate NOT NULL constraint(ENABLED_FLAG)');
1340: END IF;
1341: x_return_status := FND_API.G_RET_STS_ERROR;*/
1342: NULL;

Line 1348: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,

1344: IF (UPPER(p_ENABLED_FLAG) <> 'Y') and
1345: (UPPER(p_ENABLED_FLAG) <> 'N')
1346: THEN
1347: IF l_debug THEN
1348: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1349: 'Private API: ENABLED_FLAG is invalid');
1350:
1351: END IF;
1352:

Line 1355: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1351: END IF;
1352:
1353: AS_UTILITY_PVT.Set_Message(
1354: p_module => l_module,
1355: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1356: p_msg_name => 'AS_INVALID_ID',
1357: p_token1 => 'FIELD_ID',
1358: p_token1_value => 'ENABLED_FLAG');
1359:

Line 1365: FND_MSG_PUB.Count_And_Get

1361: END IF;
1362: END IF;
1363:
1364: -- Standard call to get message count and if count is 1, get message info.
1365: FND_MSG_PUB.Count_And_Get
1366: ( p_count => x_msg_count,
1367: p_data => x_msg_data
1368: );
1369:

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

1379: X_Msg_Count OUT NOCOPY NUMBER,
1380: X_Msg_Data OUT NOCOPY VARCHAR2
1381: )
1382: IS
1383: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
1384: CURSOR C_Customer_Id_Exists (c_Customer_Id NUMBER) IS
1385: SELECT 'X'
1386: FROM AS_PARTY_CUSTOMERS_V
1387: WHERE customer_id = c_Customer_Id;

Line 1397: FND_MSG_PUB.initialize;

1393:
1394: -- Initialize message list if p_init_msg_list is set to TRUE.
1395: IF FND_API.to_Boolean( p_init_msg_list )
1396: THEN
1397: FND_MSG_PUB.initialize;
1398: END IF;
1399:
1400:
1401: -- Initialize API return status to SUCCESS

Line 1408: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,

1404:
1405: IF (p_CUSTOMER_ID is NULL) or (p_CUSTOMER_ID = FND_API.G_MISS_NUM)
1406: THEN
1407: IF l_debug THEN
1408: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1409: 'Private API: Violate NOT NULL constraint(CUSTOMER_ID)');
1410: END IF;
1411:
1412: AS_UTILITY_PVT.Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 1412: AS_UTILITY_PVT.Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1408: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1409: 'Private API: Violate NOT NULL constraint(CUSTOMER_ID)');
1410: END IF;
1411:
1412: AS_UTILITY_PVT.Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1413: p_module => l_module,
1414: p_msg_name => 'AS_INVALID_ID',
1415: p_token1 => 'FIELD_ID',
1416: p_token1_value => 'CUSTOMER_ID');

Line 1425: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,

1421: FETCH C_Customer_Id_Exists into l_val;
1422: IF C_Customer_Id_Exists%NOTFOUND
1423: THEN
1424: IF l_debug THEN
1425: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1426: 'Private API: CUSTOMER_ID is not valid');
1427: END IF;
1428:
1429: AS_UTILITY_PVT.Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 1429: AS_UTILITY_PVT.Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1425: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1426: 'Private API: CUSTOMER_ID is not valid');
1427: END IF;
1428:
1429: AS_UTILITY_PVT.Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1430: p_module => l_module,
1431: p_msg_name => 'AS_INVALID_ID',
1432: p_token1 => 'FIELD_ID',
1433: p_token1_value => 'CUSTOMER_ID');

Line 1441: FND_MSG_PUB.Count_And_Get

1437: CLOSE C_Customer_Id_Exists;
1438: END IF;
1439:
1440: -- Standard call to get message count and if count is 1, get message info.
1441: FND_MSG_PUB.Count_And_Get
1442: ( p_count => x_msg_count,
1443: p_data => x_msg_data
1444: );
1445:

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

1464: WHERE address_id = c_address_id
1465: AND customer_id = P_CUSTOMER_ID;
1466:
1467: l_val VARCHAR2(1);
1468: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
1469: l_module CONSTANT VARCHAR2(255) := 'as.plsql.lcnpv.Validate_ADDRESS_ID';
1470: BEGIN
1471:
1472: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1475: FND_MSG_PUB.initialize;

1471:
1472: -- Initialize message list if p_init_msg_list is set to TRUE.
1473: IF FND_API.to_Boolean( p_init_msg_list )
1474: THEN
1475: FND_MSG_PUB.initialize;
1476: END IF;
1477:
1478:
1479: -- Initialize API return status to SUCCESS

Line 1489: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,

1485: OPEN C_ADDRESS_ID_Exists (p_ADDRESS_ID);
1486: FETCH C_ADDRESS_ID_Exists into l_val;
1487: IF C_ADDRESS_ID_Exists%NOTFOUND THEN
1488: IF l_debug THEN
1489: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1490: 'Private API: ADDRESS_ID is invalid');
1491: END IF;
1492:
1493: AS_UTILITY_PVT.Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 1493: AS_UTILITY_PVT.Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1489: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1490: 'Private API: ADDRESS_ID is invalid');
1491: END IF;
1492:
1493: AS_UTILITY_PVT.Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1494: p_module => l_module,
1495: p_msg_name => 'AS_INVALID_ID',
1496: p_token1 => 'FIELD_ID',
1497: p_token1_value => 'ADDRESS_ID');

Line 1505: FND_MSG_PUB.Count_And_Get

1501: CLOSE C_ADDRESS_ID_Exists;
1502: END IF;
1503:
1504: -- Standard call to get message count and if count is 1, get message info.
1505: FND_MSG_PUB.Count_And_Get
1506: ( p_count => x_msg_count,
1507: p_data => x_msg_data
1508: );
1509:

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

1528: and lookup_code = c_RANK
1529: and enabled_flag = 'Y';
1530:
1531: l_val VARCHAR2(1);
1532: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
1533: l_module CONSTANT VARCHAR2(255) := 'as.plsql.lcnpv.Validate_RANK';
1534: BEGIN
1535:
1536: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1539: FND_MSG_PUB.initialize;

1535:
1536: -- Initialize message list if p_init_msg_list is set to TRUE.
1537: IF FND_API.to_Boolean( p_init_msg_list )
1538: THEN
1539: FND_MSG_PUB.initialize;
1540: END IF;
1541:
1542:
1543: -- Initialize API return status to SUCCESS

Line 1554: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,

1550: OPEN C_RANK_Exists ( p_RANK);
1551: FETCH C_RANK_Exists into l_val;
1552: IF C_RANK_Exists%NOTFOUND THEN
1553: IF l_debug THEN
1554: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1555: 'Private API: RANK is invalid');
1556: END IF;
1557:
1558: AS_UTILITY_PVT.Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 1558: AS_UTILITY_PVT.Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1554: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1555: 'Private API: RANK is invalid');
1556: END IF;
1557:
1558: AS_UTILITY_PVT.Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1559: p_module => l_module,
1560: p_msg_name => 'AS_INVALID_ID',
1561: p_token1 => 'FIELD_ID',
1562: p_token1_value => 'RANK');

Line 1570: FND_MSG_PUB.Count_And_Get

1566: CLOSE C_RANK_Exists;
1567: END IF;
1568:
1569: -- Standard call to get message count and if count is 1, get message info.
1570: FND_MSG_PUB.Count_And_Get
1571: ( p_count => x_msg_count,
1572: p_data => x_msg_data
1573: );
1574:

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

1595: AND owner_table_name = 'HZ_PARTIES'
1596: AND owner_table_id = P_CONTACT_PARTY_ID;
1597:
1598: l_val VARCHAR2(1);
1599: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
1600: l_module CONSTANT VARCHAR2(255) := 'as.plsql.lcnpv.Validate_PHONE_ID';
1601: BEGIN
1602:
1603: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1606: FND_MSG_PUB.initialize;

1602:
1603: -- Initialize message list if p_init_msg_list is set to TRUE.
1604: IF FND_API.to_Boolean( p_init_msg_list )
1605: THEN
1606: FND_MSG_PUB.initialize;
1607: END IF;
1608:
1609:
1610: -- Initialize API return status to SUCCESS

Line 1620: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,

1616: OPEN C_PHONE_ID_Exists (p_PHONE_ID);
1617: FETCH C_PHONE_ID_Exists into l_val;
1618: IF C_PHONE_ID_Exists%NOTFOUND THEN
1619: IF l_debug THEN
1620: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1621: 'Private API: PHONE_ID is invalid');
1622: END IF;
1623:
1624: AS_UTILITY_PVT.Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 1624: AS_UTILITY_PVT.Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1620: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1621: 'Private API: PHONE_ID is invalid');
1622: END IF;
1623:
1624: AS_UTILITY_PVT.Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1625: p_module => l_module,
1626: p_msg_name => 'AS_INVALID_ID',
1627: p_token1 => 'FIELD_ID',
1628: p_token1_value => 'PHONE_ID');

Line 1636: FND_MSG_PUB.Count_And_Get

1632: CLOSE C_PHONE_ID_Exists;
1633: END IF;
1634:
1635: -- Standard call to get message count and if count is 1, get message info.
1636: FND_MSG_PUB.Count_And_Get
1637: ( p_count => x_msg_count,
1638: p_data => x_msg_data
1639: );
1640:

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

1650: X_Msg_Count OUT NOCOPY NUMBER,
1651: X_Msg_Data OUT NOCOPY VARCHAR2
1652: )
1653: IS
1654: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
1655: l_module CONSTANT VARCHAR2(255) := 'as.plsql.lcnpv.Validate_PRIMARY_CONTACT_FLAG';
1656: BEGIN
1657: -- Initialize message list if p_init_msg_list is set to TRUE.
1658: IF FND_API.to_Boolean( p_init_msg_list )

Line 1660: FND_MSG_PUB.initialize;

1656: BEGIN
1657: -- Initialize message list if p_init_msg_list is set to TRUE.
1658: IF FND_API.to_Boolean( p_init_msg_list )
1659: THEN
1660: FND_MSG_PUB.initialize;
1661: END IF;
1662:
1663:
1664: -- Initialize API return status to SUCCESS

Line 1673: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,

1669: p_PRIMARY_CONTACT_FLAG = FND_API.G_MISS_CHAR )
1670: THEN
1671: NULL;
1672: /* Not required item
1673: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,
1674: 'Private API: Violate NOT NULL constraint(PRIMARY_CONTACT_FLAG)');
1675: x_return_status := FND_API.G_RET_STS_ERROR;
1676: */
1677: ELSE

Line 1682: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,

1678: IF (UPPER(p_PRIMARY_CONTACT_FLAG) <> 'Y') and
1679: (UPPER(p_PRIMARY_CONTACT_FLAG) <> 'N')
1680: THEN
1681: IF l_debug THEN
1682: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1683: 'Private API: PRIMARY_CONTACT_FLAG is invalid');
1684:
1685: END IF;
1686:

Line 1687: AS_UTILITY_PVT.Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1683: 'Private API: PRIMARY_CONTACT_FLAG is invalid');
1684:
1685: END IF;
1686:
1687: AS_UTILITY_PVT.Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1688: p_module => l_module,
1689: p_msg_name => 'AS_INVALID_ID',
1690: p_token1 => 'FIELD_ID',
1691: p_token1_value => 'PRIMARY_CONTACT_FLAG');

Line 1698: FND_MSG_PUB.Count_And_Get

1694: END IF;
1695: END IF;
1696:
1697: -- Standard call to get message count and if count is 1, get message info.
1698: FND_MSG_PUB.Count_And_Get
1699: ( p_count => x_msg_count,
1700: p_data => x_msg_data
1701: );
1702:

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

1735:
1736:
1737: l_dup NUMBER;
1738: l_val VARCHAR2(1);
1739: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
1740: l_module CONSTANT VARCHAR2(255) := 'as.plsql.lcnpv.Validate_CONTACT_PARTY_ID';
1741: BEGIN
1742:
1743: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1746: FND_MSG_PUB.initialize;

1742:
1743: -- Initialize message list if p_init_msg_list is set to TRUE.
1744: IF FND_API.to_Boolean( p_init_msg_list )
1745: THEN
1746: FND_MSG_PUB.initialize;
1747: END IF;
1748:
1749:
1750: -- Initialize API return status to SUCCESS

Line 1756: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,

1752:
1753: IF (p_CONTACT_PARTY_ID is NULL) OR (p_CONTACT_PARTY_ID = FND_API.G_MISS_NUM)
1754: THEN
1755: IF l_debug THEN
1756: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1757: 'Private API: Violate NOT NULL CONTACT_PARTY_ID');
1758: END IF;
1759:
1760: AS_UTILITY_PVT.Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 1760: AS_UTILITY_PVT.Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1756: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1757: 'Private API: Violate NOT NULL CONTACT_PARTY_ID');
1758: END IF;
1759:
1760: AS_UTILITY_PVT.Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1761: p_module => l_module,
1762: p_msg_name => 'AS_INVALID_ID',
1763: p_token1 => 'FIELD_ID',
1764: p_token1_value => 'CONTACT_PARTY_ID');

Line 1776: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,

1772: FETCH C_CONTACT_PARTY_ID_Exists into l_val;
1773: IF C_CONTACT_PARTY_ID_Exists%NOTFOUND
1774: THEN
1775: IF l_debug THEN
1776: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1777: 'Private API: CONTACT_PARTY_ID is not valid');
1778: END IF;
1779:
1780: AS_UTILITY_PVT.Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 1780: AS_UTILITY_PVT.Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1776: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1777: 'Private API: CONTACT_PARTY_ID is not valid');
1778: END IF;
1779:
1780: AS_UTILITY_PVT.Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1781: p_module => l_module,
1782: p_msg_name => 'AS_INVALID_ID',
1783: p_token1 => 'FIELD_ID',
1784: p_token1_value => 'CONTACT_PARTY_ID');

Line 1795: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,

1791: OPEN C_contact_party_id_dup(p_lead_id, p_contact_party_id);
1792: FETCH C_contact_party_id_dup into l_dup;
1793: IF C_contact_party_id_dup%FOUND and P_Validation_mode = AS_UTILITY_PVT.G_CREATE THEN
1794: IF l_debug THEN
1795: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1796: 'Private API: CONTACT_PARTY_ID is Duplicate');
1797: END IF;
1798:
1799: AS_UTILITY_PVT.Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 1799: AS_UTILITY_PVT.Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1795: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1796: 'Private API: CONTACT_PARTY_ID is Duplicate');
1797: END IF;
1798:
1799: AS_UTILITY_PVT.Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1800: p_module => l_module,
1801: p_msg_name => 'API_POSSIBLE_DUP_CONTACT',
1802: p_token1 => 'CONTACT_ID',
1803: p_token1_value => p_CONTACT_PARTY_ID,

Line 1815: FND_MSG_PUB.Count_And_Get

1811:
1812: END IF;
1813:
1814: -- Standard call to get message count and if count is 1, get message info.
1815: FND_MSG_PUB.Count_And_Get
1816: ( p_count => x_msg_count,
1817: p_data => x_msg_data
1818: );
1819:

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

1833: X_Msg_Count OUT NOCOPY NUMBER,
1834: X_Msg_Data OUT NOCOPY VARCHAR2
1835: )
1836: IS
1837: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
1838: l_module CONSTANT VARCHAR2(255) := 'as.plsql.lcnpv.Validate_Contact_rec';
1839: BEGIN
1840:
1841: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1844: FND_MSG_PUB.initialize;

1840:
1841: -- Initialize message list if p_init_msg_list is set to TRUE.
1842: IF FND_API.to_Boolean( p_init_msg_list )
1843: THEN
1844: FND_MSG_PUB.initialize;
1845: END IF;
1846:
1847:
1848: -- Initialize API return status to SUCCESS

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

1854: -- x_return_status := FND_API.G_RET_STS_ERROR;
1855:
1856: -- Debug Message
1857: IF l_debug THEN
1858: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1859: 'Private API: Validated Record');
1860: END IF;
1861: -- Standard call to get message count and if count is 1, get message info.
1862: FND_MSG_PUB.Count_And_Get

Line 1862: FND_MSG_PUB.Count_And_Get

1858: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1859: 'Private API: Validated Record');
1860: END IF;
1861: -- Standard call to get message count and if count is 1, get message info.
1862: FND_MSG_PUB.Count_And_Get
1863: ( p_count => x_msg_count,
1864: p_data => x_msg_data
1865: );
1866:

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

1877: )
1878: IS
1879: l_api_name CONSTANT VARCHAR2(30) := 'Validate_opp_contact';
1880: X_Item_Property_Rec AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE;
1881: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
1882: l_module CONSTANT VARCHAR2(255) := 'as.plsql.lcnpv.Validate_opp_contact';
1883: BEGIN
1884:
1885: -- Debug Message

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

1883: BEGIN
1884:
1885: -- Debug Message
1886: IF l_debug THEN
1887: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1888: 'Private API: ' || l_api_name || ' start');
1889: END IF;
1890:
1891: -- Initialize API return status to SUCCESS

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

1894: IF (p_validation_level >= AS_UTILITY_PUB.G_VALID_LEVEL_ITEM) THEN
1895: -- Hint: We provide validation procedure for every column. Developer
1896: -- should delete unnecessary validation procedures.
1897: IF l_debug THEN
1898: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1899: 'Private API: Validate items start');
1900:
1901: END IF;
1902:

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

1911: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1912: raise FND_API.G_EXC_ERROR;
1913: END IF;
1914: IF l_debug THEN
1915: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1916: 'Private API: Validated LEAD_CONTACT_ID ');
1917:
1918: END IF;
1919:

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

1928: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1929: raise FND_API.G_EXC_ERROR;
1930: END IF;
1931: IF l_debug THEN
1932: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1933: 'Private API: Validated LEAD_ID ');
1934:
1935: END IF;
1936:

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

1945: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1946: raise FND_API.G_EXC_ERROR;
1947: END IF;
1948: IF l_debug THEN
1949: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1950: 'Private API: Validated CUSTOMER_ID ');
1951: END IF;
1952:
1953:

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

1963: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1964: raise FND_API.G_EXC_ERROR;
1965: END IF;
1966: IF l_debug THEN
1967: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1968: 'Private API: Validated ADDRESS_ID ');
1969: END IF;
1970:
1971: Validate_CONTACT_PARTY_ID(

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

1981: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1982: raise FND_API.G_EXC_ERROR;
1983: END IF;
1984: IF l_debug THEN
1985: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1986: 'Private API: Validated CONTACT_PARTY_ID');
1987:
1988: END IF;
1989:

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

1999: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2000: raise FND_API.G_EXC_ERROR;
2001: END IF;
2002: IF l_debug THEN
2003: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2004: 'Private API: Validated CONTACT_ID ');
2005:
2006: END IF;
2007:

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

2018: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2019: raise FND_API.G_EXC_ERROR;
2020: END IF;
2021: IF l_debug THEN
2022: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2023: 'Private API: Validated PHONE_ID ');
2024:
2025: END IF;
2026:

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

2035: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2036: raise FND_API.G_EXC_ERROR;
2037: END IF;
2038: IF l_debug THEN
2039: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2040: 'Private API: Validated RANK ');
2041:
2042: END IF;
2043:

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

2052: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2053: raise FND_API.G_EXC_ERROR;
2054: END IF;
2055: IF l_debug THEN
2056: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2057: 'Private API: Validated ENABLED_FLAG ');
2058:
2059: END IF;
2060:

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

2069: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2070: raise FND_API.G_EXC_ERROR;
2071: END IF;
2072: IF l_debug THEN
2073: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2074: 'Private API: Validated PRIMARY_CONTACT_FLAG ');
2075:
2076: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2077: 'Private API: Validate items end');

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

2072: IF l_debug THEN
2073: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2074: 'Private API: Validated PRIMARY_CONTACT_FLAG ');
2075:
2076: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2077: 'Private API: Validate items end');
2078: END IF;
2079:
2080: END IF;

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

2107:
2108:
2109: -- Debug Message
2110: IF l_debug THEN
2111: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2112: 'Private API: ' || l_api_name || ' end');
2113: END IF;
2114: END Validate_opp_contact;
2115: