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_ACCESS_PUB dependencies on FND_MSG_PUB

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

27: fetch get_person_id_csr into x_person_id;
28:
29: if (get_person_id_csr%NOTFOUND)
30: then
31: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
32: THEN
33: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
34: FND_MESSAGE.Set_Token('COLUMN', 'SALESFORCE_ID', FALSE);
35: fnd_message.set_token('VALUE', p_salesforce_id, FALSE);

Line 36: FND_MSG_PUB.ADD;

32: THEN
33: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
34: FND_MESSAGE.Set_Token('COLUMN', 'SALESFORCE_ID', FALSE);
35: fnd_message.set_token('VALUE', p_salesforce_id, FALSE);
36: FND_MSG_PUB.ADD;
37: END IF;
38: raise FND_API.G_EXC_ERROR;
39: end if;
40: close get_person_id_csr;

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

124: p_api_version_number,
125: l_api_name,
126: G_PKG_NAME)
127: THEN
128: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
129: THEN
130: FND_MESSAGE.Set_Name('AS', 'API_UNEXP_ERROR_IN_PROCESSING');
131: FND_MESSAGE.Set_Token('ROW', 'AS_ACCESS', TRUE);
132: FND_MSG_PUB.ADD;

Line 132: FND_MSG_PUB.ADD;

128: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
129: THEN
130: FND_MESSAGE.Set_Name('AS', 'API_UNEXP_ERROR_IN_PROCESSING');
131: FND_MESSAGE.Set_Token('ROW', 'AS_ACCESS', TRUE);
132: FND_MSG_PUB.ADD;
133: END IF;
134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
135: END IF;
136:

Line 140: FND_MSG_PUB.initialize;

136:
137: -- Initialize message list if p_init_msg_list is set to TRUE.
138: IF FND_API.to_Boolean( p_init_msg_list )
139: THEN
140: FND_MSG_PUB.initialize;
141: END IF;
142:
143: -- Initialize API return status to success
144: --

Line 187: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

183: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
184: P_MODULE => l_module
185: ,P_API_NAME => L_API_NAME
186: ,P_PKG_NAME => G_PKG_NAME
187: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
188: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
189: ,X_MSG_COUNT => X_MSG_COUNT
190: ,X_MSG_DATA => X_MSG_DATA
191: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 198: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

194: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
195: P_MODULE => l_module
196: ,P_API_NAME => L_API_NAME
197: ,P_PKG_NAME => G_PKG_NAME
198: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
199: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
200: ,X_MSG_COUNT => X_MSG_COUNT
201: ,X_MSG_DATA => X_MSG_DATA
202: ,X_RETURN_STATUS => X_RETURN_STATUS);

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

249: p_api_version_number,
250: l_api_name,
251: G_PKG_NAME)
252: THEN
253: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
254: THEN
255: FND_MESSAGE.Set_Name('AS', 'API_UNEXP_ERROR_IN_PROCESSING');
256: FND_MESSAGE.Set_Token('ROW', 'AS_ACCESS', TRUE);
257: FND_MSG_PUB.ADD;

Line 257: FND_MSG_PUB.ADD;

253: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
254: THEN
255: FND_MESSAGE.Set_Name('AS', 'API_UNEXP_ERROR_IN_PROCESSING');
256: FND_MESSAGE.Set_Token('ROW', 'AS_ACCESS', TRUE);
257: FND_MSG_PUB.ADD;
258: END IF;
259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
260: END IF;
261:

Line 265: FND_MSG_PUB.initialize;

261:
262: -- Initialize message list if p_init_msg_list is set to TRUE.
263: IF FND_API.to_Boolean( p_init_msg_list )
264: THEN
265: FND_MSG_PUB.initialize;
266: END IF;
267:
268: -- Initialize API return status to success
269: --

Line 306: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

302: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
303: P_MODULE => l_module
304: ,P_API_NAME => L_API_NAME
305: ,P_PKG_NAME => G_PKG_NAME
306: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
307: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
308: ,X_MSG_COUNT => X_MSG_COUNT
309: ,X_MSG_DATA => X_MSG_DATA
310: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 317: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

313: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
314: P_MODULE => l_module
315: ,P_API_NAME => L_API_NAME
316: ,P_PKG_NAME => G_PKG_NAME
317: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
318: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
319: ,X_MSG_COUNT => X_MSG_COUNT
320: ,X_MSG_DATA => X_MSG_DATA
321: ,X_RETURN_STATUS => X_RETURN_STATUS);

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

388: ) is
389: l_api_name CONSTANT VARCHAR2(30) := 'Delete_SalesTeam';
390: l_api_version_number CONSTANT NUMBER := 2.0;
391: l_pvt_sales_team_rec AS_ACCESS_PVT.Sales_Team_Rec_Type;
392: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
393: l_module CONSTANT VARCHAR2(255) := 'as.plsql.acpub.Delete_SalesTeam';
394:
395: begin
396: SAVEPOINT DELETE_SALESTEAM_PUB;

Line 409: FND_MSG_PUB.initialize;

405:
406: -- Initialize message list if p_init_msg_list is set to TRUE.
407: IF FND_API.to_Boolean( p_init_msg_list )
408: THEN
409: FND_MSG_PUB.initialize;
410: END IF;
411:
412: -- Debug Message
413: IF l_debug THEN

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

410: END IF;
411:
412: -- Debug Message
413: IF l_debug THEN
414: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
415: 'Public API: ' || l_api_name || 'start');
416:
417: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
418: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

413: IF l_debug THEN
414: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
415: 'Public API: ' || l_api_name || 'start');
416:
417: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
418: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
419: END IF;
420:
421: -- Initialize API return status to SUCCESS

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

425: -- API body
426: --
427:
428: IF l_debug THEN
429: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
430: 'Public API: Calling AS_ACCESS_PVT.delete_salesTeam');
431: END IF;
432: Convert_Pub_Sales_Team_To_Pvt(p_sales_team_rec, l_pvt_sales_team_rec);
433:

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

467:
468:
469: -- Debug Message
470: IF l_debug THEN
471: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
472: 'Public API: ' || l_api_name || 'end');
473:
474: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
475: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

470: IF l_debug THEN
471: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
472: 'Public API: ' || l_api_name || 'end');
473:
474: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
475: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
476: END IF;
477:
478:

Line 479: FND_MSG_PUB.Count_And_Get

475: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
476: END IF;
477:
478:
479: FND_MSG_PUB.Count_And_Get
480: ( p_count => x_msg_count,
481: p_data => x_msg_data
482: );
483:

Line 490: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

486: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
487: P_MODULE => l_module
488: ,P_API_NAME => L_API_NAME
489: ,P_PKG_NAME => G_PKG_NAME
490: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
491: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
492: ,X_MSG_COUNT => X_MSG_COUNT
493: ,X_MSG_DATA => X_MSG_DATA
494: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 501: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

497: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
498: P_MODULE => l_module
499: ,P_API_NAME => L_API_NAME
500: ,P_PKG_NAME => G_PKG_NAME
501: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
502: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
503: ,X_MSG_COUNT => X_MSG_COUNT
504: ,X_MSG_DATA => X_MSG_DATA
505: ,X_RETURN_STATUS => X_RETURN_STATUS);

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

526: x_msg_count OUT NOCOPY NUMBER,
527: x_msg_data OUT NOCOPY VARCHAR2
528: ) is
529:
530: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
531: l_module CONSTANT VARCHAR2(255) := 'as.plsql.acpub.validate_accessProfiles';
532:
533: begin
534: IF l_debug THEN

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

531: l_module CONSTANT VARCHAR2(255) := 'as.plsql.acpub.validate_accessProfiles';
532:
533: begin
534: IF l_debug THEN
535: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
536: 'Val Access Profile start');
537: END IF;
538: x_return_status := FND_API.G_RET_STS_SUCCESS;
539:

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

541: and (p_access_profile_rec.lead_access_profile_value in ('F', 'P')
542: or p_access_profile_rec.opp_access_profile_value in ('F', 'P'))
543: then
544: x_return_status := FND_API.G_RET_STS_ERROR;
545: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
546: THEN
547: FND_MESSAGE.Set_Name('AS', 'API_INVALID_COMINATION');
548: FND_MSG_PUB.ADD;
549: END IF;

Line 548: FND_MSG_PUB.ADD;

544: x_return_status := FND_API.G_RET_STS_ERROR;
545: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
546: THEN
547: FND_MESSAGE.Set_Name('AS', 'API_INVALID_COMINATION');
548: FND_MSG_PUB.ADD;
549: END IF;
550: end if;
551:
552: IF l_debug THEN

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

549: END IF;
550: end if;
551:
552: IF l_debug THEN
553: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
554: 'Val Access Profile end');
555: END IF;
556:
557: FND_MSG_PUB.Count_And_Get

Line 557: FND_MSG_PUB.Count_And_Get

553: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
554: 'Val Access Profile end');
555: END IF;
556:
557: FND_MSG_PUB.Count_And_Get
558: ( p_count => x_msg_count,
559: p_data => x_msg_data );
560:
561: end;

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

580: ,x_view_access_flag OUT NOCOPY VARCHAR2
581: ) is
582: l_api_name CONSTANT VARCHAR2(30) := 'has_viewCustomerAccess';
583: l_api_version_number CONSTANT NUMBER := 2.0;
584: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
585: l_module CONSTANT VARCHAR2(255) := 'as.plsql.acpub.has_viewCustomerAccess';
586:
587: begin
588: -- Standard call to check for call compatibility.

Line 600: FND_MSG_PUB.initialize;

596:
597: -- Initialize message list if p_init_msg_list is set to TRUE.
598: IF FND_API.to_Boolean( p_init_msg_list )
599: THEN
600: FND_MSG_PUB.initialize;
601: END IF;
602:
603: -- Debug Message
604: IF l_debug THEN

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

601: END IF;
602:
603: -- Debug Message
604: IF l_debug THEN
605: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
606: 'Public API: ' || l_api_name || 'start');
607:
608: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
609: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

604: IF l_debug THEN
605: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
606: 'Public API: ' || l_api_name || 'start');
607:
608: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
609: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
610: END IF;
611:
612: -- Initialize API return status to SUCCESS

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

612: -- Initialize API return status to SUCCESS
613: x_return_status := FND_API.G_RET_STS_SUCCESS;
614:
615: IF l_debug THEN
616: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
617: 'Public API: Calling as_access_pvt.has_viewCustomerAccess');
618: END IF;
619:
620:

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

647: --
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: 'Public API: ' || l_api_name || 'end');
653:
654: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
655: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

650: IF l_debug THEN
651: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
652: 'Public API: ' || l_api_name || 'end');
653:
654: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
655: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
656: END IF;
657:
658:

Line 659: FND_MSG_PUB.Count_And_Get

655: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
656: END IF;
657:
658:
659: FND_MSG_PUB.Count_And_Get
660: ( p_count => x_msg_count,
661: p_data => x_msg_data
662: );
663:

Line 670: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

666: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
667: P_MODULE => l_module
668: ,P_API_NAME => L_API_NAME
669: ,P_PKG_NAME => G_PKG_NAME
670: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
671: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
672: , P_ROLLBACK_FLAG => 'N'
673: ,X_MSG_COUNT => X_MSG_COUNT
674: ,X_MSG_DATA => X_MSG_DATA

Line 682: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

678: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
679: P_MODULE => l_module
680: ,P_API_NAME => L_API_NAME
681: ,P_PKG_NAME => G_PKG_NAME
682: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
683: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
684: , P_ROLLBACK_FLAG => 'N'
685: ,X_MSG_COUNT => X_MSG_COUNT
686: ,X_MSG_DATA => X_MSG_DATA

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

721: ,x_update_access_flag OUT NOCOPY VARCHAR2
722: )is
723: l_api_name CONSTANT VARCHAR2(30) := 'has_updateCustomerAccess';
724: l_api_version_number CONSTANT NUMBER := 2.0;
725: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
726: l_module CONSTANT VARCHAR2(255) := 'as.plsql.acpub.has_updateCustomerAccess';
727:
728: begin
729: -- Standard call to check for call compatibility.

Line 741: FND_MSG_PUB.initialize;

737:
738: -- Initialize message list if p_init_msg_list is set to TRUE.
739: IF FND_API.to_Boolean( p_init_msg_list )
740: THEN
741: FND_MSG_PUB.initialize;
742: END IF;
743:
744: -- Debug Message
745: IF l_debug THEN

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

742: END IF;
743:
744: -- Debug Message
745: IF l_debug THEN
746: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
747: 'Public API: ' || l_api_name || 'start');
748:
749: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
750: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

745: IF l_debug THEN
746: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
747: 'Public API: ' || l_api_name || 'start');
748:
749: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
750: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
751: END IF;
752:
753: -- Initialize API return status to SUCCESS

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

754: x_return_status := FND_API.G_RET_STS_SUCCESS;
755:
756:
757: IF l_debug THEN
758: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
759: 'Public API: Calling as_access_pvt.has_updateCustomerAccess');
760: END IF;
761:
762:

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

789: --
790:
791: -- Debug Message
792: IF l_debug THEN
793: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
794: 'Public API: ' || l_api_name || 'end');
795:
796: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
797: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

792: IF l_debug THEN
793: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
794: 'Public API: ' || l_api_name || 'end');
795:
796: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
797: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
798: END IF;
799:
800:

Line 801: FND_MSG_PUB.Count_And_Get

797: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
798: END IF;
799:
800:
801: FND_MSG_PUB.Count_And_Get
802: ( p_count => x_msg_count,
803: p_data => x_msg_data
804: );
805:

Line 812: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

808: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
809: P_MODULE => l_module
810: ,P_API_NAME => L_API_NAME
811: ,P_PKG_NAME => G_PKG_NAME
812: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
813: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
814: , P_ROLLBACK_FLAG => 'N'
815: ,X_MSG_COUNT => X_MSG_COUNT
816: ,X_MSG_DATA => X_MSG_DATA

Line 824: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

820: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
821: P_MODULE => l_module
822: ,P_API_NAME => L_API_NAME
823: ,P_PKG_NAME => G_PKG_NAME
824: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
825: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
826: , P_ROLLBACK_FLAG => 'N'
827: ,X_MSG_COUNT => X_MSG_COUNT
828: ,X_MSG_DATA => X_MSG_DATA

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

863: ,x_update_access_flag OUT NOCOPY VARCHAR2
864: ) is
865: l_api_name CONSTANT VARCHAR2(30) := 'has_updateLeadAccess';
866: l_api_version_number CONSTANT NUMBER := 2.0;
867: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
868: l_module CONSTANT VARCHAR2(255) := 'as.plsql.acpub.has_updateLeadAccess';
869:
870: begin
871: -- Standard call to check for call compatibility.

Line 883: FND_MSG_PUB.initialize;

879:
880: -- Initialize message list if p_init_msg_list is set to TRUE.
881: IF FND_API.to_Boolean( p_init_msg_list )
882: THEN
883: FND_MSG_PUB.initialize;
884: END IF;
885:
886: -- Debug Message
887: IF l_debug THEN

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

884: END IF;
885:
886: -- Debug Message
887: IF l_debug THEN
888: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
889: 'Public API: ' || l_api_name || 'start');
890:
891: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
892: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

887: IF l_debug THEN
888: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
889: 'Public API: ' || l_api_name || 'start');
890:
891: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
892: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
893: END IF;
894:
895: -- Initialize API return status to SUCCESS

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

896: x_return_status := FND_API.G_RET_STS_SUCCESS;
897:
898:
899: IF l_debug THEN
900: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
901: 'Public API: Calling as_access_pvt.has_updateLeadAccess');
902: END IF;
903:
904:

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

931: --
932:
933: -- Debug Message
934: IF l_debug THEN
935: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
936: 'Public API: ' || l_api_name || 'end');
937:
938: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
939: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

934: IF l_debug THEN
935: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
936: 'Public API: ' || l_api_name || 'end');
937:
938: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
939: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
940: END IF;
941:
942: FND_MSG_PUB.Count_And_Get

Line 942: FND_MSG_PUB.Count_And_Get

938: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
939: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
940: END IF;
941:
942: FND_MSG_PUB.Count_And_Get
943: ( p_count => x_msg_count,
944: p_data => x_msg_data
945: );
946:

Line 953: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

949: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
950: P_MODULE => l_module
951: ,P_API_NAME => L_API_NAME
952: ,P_PKG_NAME => G_PKG_NAME
953: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
954: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
955: , P_ROLLBACK_FLAG => 'N'
956: ,X_MSG_COUNT => X_MSG_COUNT
957: ,X_MSG_DATA => X_MSG_DATA

Line 965: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

961: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
962: P_MODULE => l_module
963: ,P_API_NAME => L_API_NAME
964: ,P_PKG_NAME => G_PKG_NAME
965: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
966: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
967: , P_ROLLBACK_FLAG => 'N'
968: ,X_MSG_COUNT => X_MSG_COUNT
969: ,X_MSG_DATA => X_MSG_DATA

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

1004: ,x_update_access_flag OUT NOCOPY VARCHAR2
1005: ) is
1006: l_api_name CONSTANT VARCHAR2(30) := 'has_updateOpportunityAccess';
1007: l_api_version_number CONSTANT NUMBER := 2.0;
1008: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
1009: l_module CONSTANT VARCHAR2(255) := 'as.plsql.acpub.has_updateOpportunityAccess';
1010:
1011: begin
1012:

Line 1025: FND_MSG_PUB.initialize;

1021:
1022: -- Initialize message list if p_init_msg_list is set to TRUE.
1023: IF FND_API.to_Boolean( p_init_msg_list )
1024: THEN
1025: FND_MSG_PUB.initialize;
1026: END IF;
1027:
1028: -- Debug Message
1029: IF l_debug THEN

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

1026: END IF;
1027:
1028: -- Debug Message
1029: IF l_debug THEN
1030: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1031: 'Public API: ' || l_api_name || 'start');
1032:
1033: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1034: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

1029: IF l_debug THEN
1030: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1031: 'Public API: ' || l_api_name || 'start');
1032:
1033: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1034: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1035: END IF;
1036:
1037: -- Initialize API return status to SUCCESS

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

1038: x_return_status := FND_API.G_RET_STS_SUCCESS;
1039:
1040:
1041: IF l_debug THEN
1042: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1043: 'Public API: Calling as_access_pvt.has_updateOpportunityAccess');
1044: END IF;
1045:
1046:

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

1073: --
1074:
1075: -- Debug Message
1076: IF l_debug THEN
1077: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1078: 'Public API: ' || l_api_name || 'end');
1079:
1080: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
1081: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

1076: IF l_debug THEN
1077: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1078: 'Public API: ' || l_api_name || 'end');
1079:
1080: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
1081: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1082: END IF;
1083:
1084:

Line 1085: FND_MSG_PUB.Count_And_Get

1081: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1082: END IF;
1083:
1084:
1085: FND_MSG_PUB.Count_And_Get
1086: ( p_count => x_msg_count,
1087: p_data => x_msg_data
1088: );
1089:

Line 1096: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1092: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1093: P_MODULE => l_module
1094: ,P_API_NAME => L_API_NAME
1095: ,P_PKG_NAME => G_PKG_NAME
1096: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1097: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1098: , P_ROLLBACK_FLAG => 'N'
1099: ,X_MSG_COUNT => X_MSG_COUNT
1100: ,X_MSG_DATA => X_MSG_DATA

Line 1108: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1104: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1105: P_MODULE => l_module
1106: ,P_API_NAME => L_API_NAME
1107: ,P_PKG_NAME => G_PKG_NAME
1108: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1109: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1110: , P_ROLLBACK_FLAG => 'N'
1111: ,X_MSG_COUNT => X_MSG_COUNT
1112: ,X_MSG_DATA => X_MSG_DATA

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

1240: ) is
1241: l_api_name CONSTANT VARCHAR2(30) := 'has_updatePersonAccess';
1242: l_api_version_number CONSTANT NUMBER := 2.0;
1243: l_valid_flag varchar2(1);
1244: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
1245: l_module CONSTANT VARCHAR2(255) := 'as.plsql.acpub.has_updatePersonAccess';
1246:
1247: begin
1248:

Line 1261: FND_MSG_PUB.initialize;

1257:
1258: -- Initialize message list if p_init_msg_list is set to TRUE.
1259: IF FND_API.to_Boolean( p_init_msg_list )
1260: THEN
1261: FND_MSG_PUB.initialize;
1262: END IF;
1263:
1264: -- Debug Message
1265: IF l_debug THEN

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

1262: END IF;
1263:
1264: -- Debug Message
1265: IF l_debug THEN
1266: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1267: 'Public API: ' || l_api_name || 'start');
1268:
1269: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1270: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

1265: IF l_debug THEN
1266: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1267: 'Public API: ' || l_api_name || 'start');
1268:
1269: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1270: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1271: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1272: 'p_security_id: ' || p_security_id);
1273: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

1267: 'Public API: ' || l_api_name || 'start');
1268:
1269: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1270: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1271: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1272: 'p_security_id: ' || p_security_id);
1273: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1274: 'p_security_type: ' || p_security_type);
1275: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

1269: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1270: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1271: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1272: 'p_security_id: ' || p_security_id);
1273: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1274: 'p_security_type: ' || p_security_type);
1275: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1276: 'p_person_party_id: ' || p_person_party_id);
1277: END IF;

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

1271: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1272: 'p_security_id: ' || p_security_id);
1273: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1274: 'p_security_type: ' || p_security_type);
1275: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1276: 'p_person_party_id: ' || p_person_party_id);
1277: END IF;
1278:
1279: -- Initialize API return status to SUCCESS

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

1283: ,p_security_type => p_security_type
1284: ,p_person_party_id => p_person_party_id
1285: ,x_valid_flag => l_valid_flag);
1286: IF l_debug THEN
1287: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1288: 'valid id flag: ' || l_valid_flag);
1289: END IF;
1290: if l_valid_flag = 'N'
1291: then

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

1395: --
1396:
1397: -- Debug Message
1398: IF l_debug THEN
1399: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1400: 'Public API: ' || l_api_name || 'end');
1401:
1402: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
1403: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

1398: IF l_debug THEN
1399: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1400: 'Public API: ' || l_api_name || 'end');
1401:
1402: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
1403: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1404: END IF;
1405:
1406:

Line 1407: FND_MSG_PUB.Count_And_Get

1403: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1404: END IF;
1405:
1406:
1407: FND_MSG_PUB.Count_And_Get
1408: ( p_count => x_msg_count,
1409: p_data => x_msg_data
1410: );
1411:

Line 1418: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1414: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1415: P_MODULE => l_module
1416: ,P_API_NAME => L_API_NAME
1417: ,P_PKG_NAME => G_PKG_NAME
1418: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1419: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1420: , P_ROLLBACK_FLAG => 'N'
1421: ,X_MSG_COUNT => X_MSG_COUNT
1422: ,X_MSG_DATA => X_MSG_DATA

Line 1430: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1426: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1427: P_MODULE => l_module
1428: ,P_API_NAME => L_API_NAME
1429: ,P_PKG_NAME => G_PKG_NAME
1430: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1431: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1432: , P_ROLLBACK_FLAG => 'N'
1433: ,X_MSG_COUNT => X_MSG_COUNT
1434: ,X_MSG_DATA => X_MSG_DATA

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

1471: ) is
1472: l_api_name CONSTANT VARCHAR2(30) := 'has_viewPersonAccess';
1473: l_api_version_number CONSTANT NUMBER := 2.0;
1474: l_valid_flag varchar2(1);
1475: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
1476: l_module CONSTANT VARCHAR2(255) := 'as.plsql.acpub.has_viewPersonAccess';
1477:
1478: begin
1479:

Line 1492: FND_MSG_PUB.initialize;

1488:
1489: -- Initialize message list if p_init_msg_list is set to TRUE.
1490: IF FND_API.to_Boolean( p_init_msg_list )
1491: THEN
1492: FND_MSG_PUB.initialize;
1493: END IF;
1494:
1495: -- Debug Message
1496: IF l_debug THEN

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

1493: END IF;
1494:
1495: -- Debug Message
1496: IF l_debug THEN
1497: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1498: 'Public API: ' || l_api_name || 'start');
1499:
1500: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1501: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

1496: IF l_debug THEN
1497: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1498: 'Public API: ' || l_api_name || 'start');
1499:
1500: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1501: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1502: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1503: 'p_security_id: ' || p_security_id);
1504: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

1498: 'Public API: ' || l_api_name || 'start');
1499:
1500: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1501: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1502: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1503: 'p_security_id: ' || p_security_id);
1504: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1505: 'p_security_type: ' || p_security_type);
1506: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

1500: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1501: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1502: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1503: 'p_security_id: ' || p_security_id);
1504: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1505: 'p_security_type: ' || p_security_type);
1506: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1507: 'p_person_party_id: ' || p_person_party_id);
1508: END IF;

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

1502: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1503: 'p_security_id: ' || p_security_id);
1504: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1505: 'p_security_type: ' || p_security_type);
1506: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1507: 'p_person_party_id: ' || p_person_party_id);
1508: END IF;
1509:
1510: -- Initialize API return status to SUCCESS

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

1514: ,p_security_type => p_security_type
1515: ,p_person_party_id => p_person_party_id
1516: ,x_valid_flag => l_valid_flag);
1517: IF l_debug THEN
1518: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1519: 'valid id flag: ' || l_valid_flag);
1520: END IF;
1521:
1522: if l_valid_flag = 'N'

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

1627: --
1628:
1629: -- Debug Message
1630: IF l_debug THEN
1631: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1632: 'Public API: ' || l_api_name || 'end');
1633:
1634: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
1635: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

1630: IF l_debug THEN
1631: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1632: 'Public API: ' || l_api_name || 'end');
1633:
1634: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
1635: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1636: END IF;
1637:
1638:

Line 1639: FND_MSG_PUB.Count_And_Get

1635: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1636: END IF;
1637:
1638:
1639: FND_MSG_PUB.Count_And_Get
1640: ( p_count => x_msg_count,
1641: p_data => x_msg_data
1642: );
1643:

Line 1650: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1646: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1647: P_MODULE => l_module
1648: ,P_API_NAME => L_API_NAME
1649: ,P_PKG_NAME => G_PKG_NAME
1650: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1651: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1652: , P_ROLLBACK_FLAG => 'N'
1653: ,X_MSG_COUNT => X_MSG_COUNT
1654: ,X_MSG_DATA => X_MSG_DATA

Line 1662: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1658: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1659: P_MODULE => l_module
1660: ,P_API_NAME => L_API_NAME
1661: ,P_PKG_NAME => G_PKG_NAME
1662: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1663: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1664: , P_ROLLBACK_FLAG => 'N'
1665: ,X_MSG_COUNT => X_MSG_COUNT
1666: ,X_MSG_DATA => X_MSG_DATA

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

1701: ,x_view_access_flag OUT NOCOPY VARCHAR2
1702: ) is
1703: l_api_name CONSTANT VARCHAR2(30) := 'has_viewLeadAccess';
1704: l_api_version_number CONSTANT NUMBER := 2.0;
1705: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
1706: l_module CONSTANT VARCHAR2(255) := 'as.plsql.acpub.has_viewLeadAccess';
1707:
1708: begin
1709: -- Standard call to check for call compatibility.

Line 1721: FND_MSG_PUB.initialize;

1717:
1718: -- Initialize message list if p_init_msg_list is set to TRUE.
1719: IF FND_API.to_Boolean( p_init_msg_list )
1720: THEN
1721: FND_MSG_PUB.initialize;
1722: END IF;
1723:
1724: -- Debug Message
1725: IF l_debug THEN

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

1722: END IF;
1723:
1724: -- Debug Message
1725: IF l_debug THEN
1726: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1727: 'Public API: ' || l_api_name || 'start');
1728:
1729: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1730: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

1725: IF l_debug THEN
1726: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1727: 'Public API: ' || l_api_name || 'start');
1728:
1729: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1730: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1731: END IF;
1732:
1733: -- Initialize API return status to SUCCESS

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

1734: x_return_status := FND_API.G_RET_STS_SUCCESS;
1735:
1736:
1737: IF l_debug THEN
1738: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1739: 'Public API: Calling as_access_pvt.has_viewLeadAccess');
1740: END IF;
1741:
1742:

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

1769: --
1770:
1771: -- Debug Message
1772: IF l_debug THEN
1773: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1774: 'Public API: ' || l_api_name || 'end');
1775:
1776: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
1777: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

1772: IF l_debug THEN
1773: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1774: 'Public API: ' || l_api_name || 'end');
1775:
1776: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
1777: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1778: END IF;
1779:
1780:

Line 1781: FND_MSG_PUB.Count_And_Get

1777: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1778: END IF;
1779:
1780:
1781: FND_MSG_PUB.Count_And_Get
1782: ( p_count => x_msg_count,
1783: p_data => x_msg_data
1784: );
1785:

Line 1792: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1788: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1789: P_MODULE => l_module
1790: ,P_API_NAME => L_API_NAME
1791: ,P_PKG_NAME => G_PKG_NAME
1792: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1793: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1794: , P_ROLLBACK_FLAG => 'N'
1795: ,X_MSG_COUNT => X_MSG_COUNT
1796: ,X_MSG_DATA => X_MSG_DATA

Line 1804: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1800: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1801: P_MODULE => l_module
1802: ,P_API_NAME => L_API_NAME
1803: ,P_PKG_NAME => G_PKG_NAME
1804: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1805: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1806: , P_ROLLBACK_FLAG => 'N'
1807: ,X_MSG_COUNT => X_MSG_COUNT
1808: ,X_MSG_DATA => X_MSG_DATA

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

1843: ,x_view_access_flag OUT NOCOPY VARCHAR2
1844: ) is
1845: l_api_name CONSTANT VARCHAR2(30) := 'has_viewOpportunityAccess';
1846: l_api_version_number CONSTANT NUMBER := 2.0;
1847: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
1848: l_module CONSTANT VARCHAR2(255) := 'as.plsql.acpub.has_viewOpportunityAccess';
1849:
1850: begin
1851:

Line 1864: FND_MSG_PUB.initialize;

1860:
1861: -- Initialize message list if p_init_msg_list is set to TRUE.
1862: IF FND_API.to_Boolean( p_init_msg_list )
1863: THEN
1864: FND_MSG_PUB.initialize;
1865: END IF;
1866:
1867: -- Debug Message
1868: IF l_debug THEN

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

1865: END IF;
1866:
1867: -- Debug Message
1868: IF l_debug THEN
1869: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1870: 'Public API: ' || l_api_name || 'start');
1871:
1872: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1873: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

1868: IF l_debug THEN
1869: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1870: 'Public API: ' || l_api_name || 'start');
1871:
1872: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1873: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1874: END IF;
1875:
1876: -- Initialize API return status to SUCCESS

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

1877: x_return_status := FND_API.G_RET_STS_SUCCESS;
1878:
1879:
1880: IF l_debug THEN
1881: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1882: 'Public API: Calling as_access_pvt.has_viewOpportunityAccess');
1883: END IF;
1884:
1885:

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

1912: --
1913:
1914: -- Debug Message
1915: IF l_debug THEN
1916: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1917: 'Public API: ' || l_api_name || 'end');
1918:
1919: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
1920: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

1915: IF l_debug THEN
1916: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1917: 'Public API: ' || l_api_name || 'end');
1918:
1919: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
1920: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1921: END IF;
1922:
1923:

Line 1924: FND_MSG_PUB.Count_And_Get

1920: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1921: END IF;
1922:
1923:
1924: FND_MSG_PUB.Count_And_Get
1925: ( p_count => x_msg_count,
1926: p_data => x_msg_data
1927: );
1928:

Line 1935: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1931: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1932: P_MODULE => l_module
1933: ,P_API_NAME => L_API_NAME
1934: ,P_PKG_NAME => G_PKG_NAME
1935: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1936: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1937: , P_ROLLBACK_FLAG => 'N'
1938: ,X_MSG_COUNT => X_MSG_COUNT
1939: ,X_MSG_DATA => X_MSG_DATA

Line 1947: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1943: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1944: P_MODULE => l_module
1945: ,P_API_NAME => L_API_NAME
1946: ,P_PKG_NAME => G_PKG_NAME
1947: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1948: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1949: , P_ROLLBACK_FLAG => 'N'
1950: ,X_MSG_COUNT => X_MSG_COUNT
1951: ,X_MSG_DATA => X_MSG_DATA

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

1993: l_api_name CONSTANT VARCHAR2(30) := 'has_organizationAccess';
1994: l_api_version_number CONSTANT NUMBER := 2.0;
1995: l_view_access_flag varchar2(1);
1996: l_update_access_flag varchar2(1);
1997: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
1998: l_module CONSTANT VARCHAR2(255) := 'as.plsql.acpub.has_organizationAccess';
1999:
2000: begin
2001: -- Standard call to check for call compatibility.

Line 2013: FND_MSG_PUB.initialize;

2009:
2010: -- Initialize message list if p_init_msg_list is set to TRUE.
2011: IF FND_API.to_Boolean( p_init_msg_list )
2012: THEN
2013: FND_MSG_PUB.initialize;
2014: END IF;
2015:
2016: -- Debug Message
2017: IF l_debug THEN

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

2014: END IF;
2015:
2016: -- Debug Message
2017: IF l_debug THEN
2018: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2019: 'Public API: ' || l_api_name || 'start');
2020:
2021: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2022: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

2017: IF l_debug THEN
2018: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2019: 'Public API: ' || l_api_name || 'start');
2020:
2021: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2022: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2023: END IF;
2024:
2025: -- Initialize API return status to SUCCESS

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

2025: -- Initialize API return status to SUCCESS
2026: x_return_status := FND_API.G_RET_STS_SUCCESS;
2027:
2028: IF l_debug THEN
2029: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2030: 'Public API: Calling as_access_pvt.has_viewCustomerAccess');
2031: END IF;
2032:
2033: x_access_privilege := 'N';

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

2091: --
2092:
2093: -- Debug Message
2094: IF l_debug THEN
2095: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2096: 'Public API: ' || l_api_name || 'end');
2097:
2098: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
2099: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

2094: IF l_debug THEN
2095: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2096: 'Public API: ' || l_api_name || 'end');
2097:
2098: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
2099: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2100: END IF;
2101:
2102:

Line 2103: FND_MSG_PUB.Count_And_Get

2099: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2100: END IF;
2101:
2102:
2103: FND_MSG_PUB.Count_And_Get
2104: ( p_count => x_msg_count,
2105: p_data => x_msg_data
2106: );
2107:

Line 2114: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

2110: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2111: P_MODULE => l_module
2112: ,P_API_NAME => L_API_NAME
2113: ,P_PKG_NAME => G_PKG_NAME
2114: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2115: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2116: , P_ROLLBACK_FLAG => 'N'
2117: ,X_MSG_COUNT => X_MSG_COUNT
2118: ,X_MSG_DATA => X_MSG_DATA

Line 2126: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

2122: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2123: P_MODULE => l_module
2124: ,P_API_NAME => L_API_NAME
2125: ,P_PKG_NAME => G_PKG_NAME
2126: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2127: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2128: , P_ROLLBACK_FLAG => 'N'
2129: ,X_MSG_COUNT => X_MSG_COUNT
2130: ,X_MSG_DATA => X_MSG_DATA

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

2167: l_api_name CONSTANT VARCHAR2(30) := 'has_opportunityAccess';
2168: l_api_version_number CONSTANT NUMBER := 2.0;
2169: l_view_access_flag varchar2(1);
2170: l_update_access_flag varchar2(1);
2171: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
2172: l_module CONSTANT VARCHAR2(255) := 'as.plsql.acpub.has_opportunityAccess';
2173:
2174: begin
2175: -- Standard call to check for call compatibility.

Line 2187: FND_MSG_PUB.initialize;

2183:
2184: -- Initialize message list if p_init_msg_list is set to TRUE.
2185: IF FND_API.to_Boolean( p_init_msg_list )
2186: THEN
2187: FND_MSG_PUB.initialize;
2188: END IF;
2189:
2190: -- Debug Message
2191: IF l_debug THEN

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

2188: END IF;
2189:
2190: -- Debug Message
2191: IF l_debug THEN
2192: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2193: 'Public API: ' || l_api_name || 'start');
2194:
2195: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2196: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

2191: IF l_debug THEN
2192: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2193: 'Public API: ' || l_api_name || 'start');
2194:
2195: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2196: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2197: END IF;
2198:
2199: -- Initialize API return status to SUCCESS

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

2199: -- Initialize API return status to SUCCESS
2200: x_return_status := FND_API.G_RET_STS_SUCCESS;
2201:
2202: IF l_debug THEN
2203: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2204: 'Public API: Calling as_access_pvt.has_viewCustomerAccess');
2205: END IF;
2206:
2207: x_access_privilege := 'N';

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

2265: --
2266:
2267: -- Debug Message
2268: IF l_debug THEN
2269: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2270: 'Public API: ' || l_api_name || 'end');
2271:
2272: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
2273: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

2268: IF l_debug THEN
2269: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2270: 'Public API: ' || l_api_name || 'end');
2271:
2272: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
2273: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2274: END IF;
2275:
2276:

Line 2277: FND_MSG_PUB.Count_And_Get

2273: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2274: END IF;
2275:
2276:
2277: FND_MSG_PUB.Count_And_Get
2278: ( p_count => x_msg_count,
2279: p_data => x_msg_data
2280: );
2281:

Line 2288: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

2284: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2285: P_MODULE => l_module
2286: ,P_API_NAME => L_API_NAME
2287: ,P_PKG_NAME => G_PKG_NAME
2288: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2289: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2290: , P_ROLLBACK_FLAG => 'N'
2291: ,X_MSG_COUNT => X_MSG_COUNT
2292: ,X_MSG_DATA => X_MSG_DATA

Line 2300: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

2296: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2297: P_MODULE => l_module
2298: ,P_API_NAME => L_API_NAME
2299: ,P_PKG_NAME => G_PKG_NAME
2300: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2301: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2302: , P_ROLLBACK_FLAG => 'N'
2303: ,X_MSG_COUNT => X_MSG_COUNT
2304: ,X_MSG_DATA => X_MSG_DATA

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

2341: l_api_name CONSTANT VARCHAR2(30) := 'has_leadAccess';
2342: l_api_version_number CONSTANT NUMBER := 2.0;
2343: l_view_access_flag varchar2(1);
2344: l_update_access_flag varchar2(1);
2345: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
2346: l_module CONSTANT VARCHAR2(255) := 'as.plsql.acpub.has_leadAccess';
2347:
2348: begin
2349: -- Standard call to check for call compatibility.

Line 2361: FND_MSG_PUB.initialize;

2357:
2358: -- Initialize message list if p_init_msg_list is set to TRUE.
2359: IF FND_API.to_Boolean( p_init_msg_list )
2360: THEN
2361: FND_MSG_PUB.initialize;
2362: END IF;
2363:
2364: -- Debug Message
2365: IF l_debug THEN

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

2362: END IF;
2363:
2364: -- Debug Message
2365: IF l_debug THEN
2366: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2367: 'Public API: ' || l_api_name || 'start');
2368:
2369: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2370: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

2365: IF l_debug THEN
2366: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2367: 'Public API: ' || l_api_name || 'start');
2368:
2369: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2370: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2371: END IF;
2372:
2373: -- Initialize API return status to SUCCESS

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

2373: -- Initialize API return status to SUCCESS
2374: x_return_status := FND_API.G_RET_STS_SUCCESS;
2375:
2376: IF l_debug THEN
2377: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2378: 'Public API: Calling as_access_pvt.has_viewCustomerAccess');
2379: END IF;
2380:
2381: x_access_privilege := 'N';

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

2439: --
2440:
2441: -- Debug Message
2442: IF l_debug THEN
2443: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2444: 'Public API: ' || l_api_name || 'end');
2445:
2446: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
2447: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

2442: IF l_debug THEN
2443: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2444: 'Public API: ' || l_api_name || 'end');
2445:
2446: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
2447: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2448: END IF;
2449:
2450:

Line 2451: FND_MSG_PUB.Count_And_Get

2447: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2448: END IF;
2449:
2450:
2451: FND_MSG_PUB.Count_And_Get
2452: ( p_count => x_msg_count,
2453: p_data => x_msg_data
2454: );
2455:

Line 2462: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

2458: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2459: P_MODULE => l_module
2460: ,P_API_NAME => L_API_NAME
2461: ,P_PKG_NAME => G_PKG_NAME
2462: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2463: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2464: , P_ROLLBACK_FLAG => 'N'
2465: ,X_MSG_COUNT => X_MSG_COUNT
2466: ,X_MSG_DATA => X_MSG_DATA

Line 2474: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

2470: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2471: P_MODULE => l_module
2472: ,P_API_NAME => L_API_NAME
2473: ,P_PKG_NAME => G_PKG_NAME
2474: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2475: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2476: , P_ROLLBACK_FLAG => 'N'
2477: ,X_MSG_COUNT => X_MSG_COUNT
2478: ,X_MSG_DATA => X_MSG_DATA

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

2517: l_api_name CONSTANT VARCHAR2(30) := 'has_personAccess';
2518: l_api_version_number CONSTANT NUMBER := 2.0;
2519: l_view_access_flag varchar2(1);
2520: l_update_access_flag varchar2(1);
2521: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
2522: l_module CONSTANT VARCHAR2(255) := 'as.plsql.acpub.has_personAccess';
2523:
2524: begin
2525: -- Standard call to check for call compatibility.

Line 2537: FND_MSG_PUB.initialize;

2533:
2534: -- Initialize message list if p_init_msg_list is set to TRUE.
2535: IF FND_API.to_Boolean( p_init_msg_list )
2536: THEN
2537: FND_MSG_PUB.initialize;
2538: END IF;
2539:
2540: -- Debug Message
2541: IF l_debug THEN

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

2538: END IF;
2539:
2540: -- Debug Message
2541: IF l_debug THEN
2542: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2543: 'Public API: ' || l_api_name || 'start');
2544:
2545: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2546: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

2541: IF l_debug THEN
2542: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2543: 'Public API: ' || l_api_name || 'start');
2544:
2545: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2546: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2547: END IF;
2548:
2549: -- Initialize API return status to SUCCESS

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

2614: --
2615:
2616: -- Debug Message
2617: IF l_debug THEN
2618: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2619: 'Public API: ' || l_api_name || 'end');
2620:
2621: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
2622: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

2617: IF l_debug THEN
2618: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2619: 'Public API: ' || l_api_name || 'end');
2620:
2621: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
2622: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2623: END IF;
2624:
2625:

Line 2626: FND_MSG_PUB.Count_And_Get

2622: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2623: END IF;
2624:
2625:
2626: FND_MSG_PUB.Count_And_Get
2627: ( p_count => x_msg_count,
2628: p_data => x_msg_data
2629: );
2630:

Line 2637: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

2633: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2634: P_MODULE => l_module
2635: ,P_API_NAME => L_API_NAME
2636: ,P_PKG_NAME => G_PKG_NAME
2637: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2638: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2639: , P_ROLLBACK_FLAG => 'N'
2640: ,X_MSG_COUNT => X_MSG_COUNT
2641: ,X_MSG_DATA => X_MSG_DATA

Line 2649: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

2645: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2646: P_MODULE => l_module
2647: ,P_API_NAME => L_API_NAME
2648: ,P_PKG_NAME => G_PKG_NAME
2649: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2650: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2651: , P_ROLLBACK_FLAG => 'N'
2652: ,X_MSG_COUNT => X_MSG_COUNT
2653: ,X_MSG_DATA => X_MSG_DATA