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

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

42: l_api_version_number CONSTANT NUMBER := 2.0;
43: l_header_rec HEADER_REC_TYPE := p_header_rec;
44: l_lead_id NUMBER;
45: l_warning_msg VARCHAR2(2000) := '';
46: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
47: l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Create_Opp_Header';
48:
49: BEGIN
50: -- Standard Start of API savepoint

Line 66: FND_MSG_PUB.initialize;

62:
63: -- Initialize message list if p_init_msg_list is set to TRUE.
64: IF FND_API.to_Boolean( p_init_msg_list )
65: THEN
66: FND_MSG_PUB.initialize;
67: END IF;
68:
69:
70: -- Debug Message

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

69:
70: -- Debug Message
71: IF l_debug THEN
72: IF l_debug THEN
73: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
74: 'Public API: ' || l_api_name || ' start');
75:
76: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
77: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

72: IF l_debug THEN
73: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
74: 'Public API: ' || l_api_name || ' start');
75:
76: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
77: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
78: END IF;
79: END IF;
80:

Line 92: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

88: /*****
89:
90: -- Debug Message
91: IF l_debug THEN
92: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
93: 'AS: Public API: Convert_Header_Values_To_Ids');
94:
95: END IF;
96:

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

160:
161: -- Debug Message
162: IF x_return_status <> FND_API.G_RET_STS_SUCCESS then
163: IF l_debug THEN
164: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
165: 'Create_opp_header_Post fail');
166: END IF;
167:
168: END IF;

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

188:
189:
190: -- Debug Message
191: IF l_debug THEN
192: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
193: 'Public API: ' || l_api_name || ' end');
194:
195: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
196: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

191: IF l_debug THEN
192: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
193: 'Public API: ' || l_api_name || ' end');
194:
195: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
196: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
197: END IF;
198:
199:

Line 203: FND_MSG_PUB.Count_And_Get

199:
200:
201: -- Standard call to get message count and if count is 1, get message info.
202:
203: FND_MSG_PUB.Count_And_Get
204: ( p_count => x_msg_count,
205: p_data => x_msg_data
206: );
207:

Line 218: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

214: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
215: P_MODULE => l_module
216: ,P_API_NAME => L_API_NAME
217: ,P_PKG_NAME => G_PKG_NAME
218: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
219: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
220: ,X_MSG_COUNT => X_MSG_COUNT
221: ,X_MSG_DATA => X_MSG_DATA
222: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 229: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

225: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
226: P_MODULE => l_module
227: ,P_API_NAME => L_API_NAME
228: ,P_PKG_NAME => G_PKG_NAME
229: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
230: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
231: ,X_MSG_COUNT => X_MSG_COUNT
232: ,X_MSG_DATA => X_MSG_DATA
233: ,X_RETURN_STATUS => X_RETURN_STATUS);

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

274: l_api_version_number CONSTANT NUMBER := 2.0;
275: --l_pvt_Header_rec AS_OPP_HEADER_PVT.Header_Rec_Type;
276: l_header_rec HEADER_REC_TYPE := p_header_rec;
277: l_warning_msg VARCHAR2(2000) := '';
278: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
279: l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Update_Opp_header';
280: BEGIN
281: -- Standard Start of API savepoint
282: SAVEPOINT UPDATE_OPP_HEADER_PUB;

Line 297: FND_MSG_PUB.initialize;

293:
294: -- Initialize message list if p_init_msg_list is set to TRUE.
295: IF FND_API.to_Boolean( p_init_msg_list )
296: THEN
297: FND_MSG_PUB.initialize;
298: END IF;
299:
300:
301: -- Debug Message

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

299:
300:
301: -- Debug Message
302: IF l_debug THEN
303: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
304: 'Public API: ' || l_api_name || ' start');
305:
306: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
307: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

302: IF l_debug THEN
303: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
304: 'Public API: ' || l_api_name || ' start');
305:
306: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
307: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
308: END IF;
309:
310:

Line 321: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

317:
318: /*****
319: -- Debug Message
320: IF l_debug THEN
321: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
322: 'AS: Public API: Convert_Header_Values_To_Ids');
323: END IF;
324:
325: -- Convert the values to ids

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

351:
352: -- Debug Message
353: IF x_return_status <> FND_API.G_RET_STS_SUCCESS then
354: IF l_debug THEN
355: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
356: 'Update_opp_header_Pre fail');
357: END IF;
358:
359: END IF;

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

416:
417: -- Debug Message
418: IF x_return_status <> FND_API.G_RET_STS_SUCCESS then
419: IF l_debug THEN
420: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
421: 'Update_opp_header_Post fail');
422: END IF;
423: END IF;
424:

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

443:
444:
445: -- Debug Message
446: IF l_debug THEN
447: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
448: 'Public API: ' || l_api_name || ' end');
449:
450: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
451: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

446: IF l_debug THEN
447: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
448: 'Public API: ' || l_api_name || ' end');
449:
450: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
451: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
452: END IF;
453: -- Standard call to get message count and if count is 1, get message info.
454: FND_MSG_PUB.Count_And_Get

Line 454: FND_MSG_PUB.Count_And_Get

450: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
451: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
452: END IF;
453: -- Standard call to get message count and if count is 1, get message info.
454: FND_MSG_PUB.Count_And_Get
455: ( p_count => x_msg_count,
456: p_data => x_msg_data
457: );
458:

Line 469: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

465: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
466: P_MODULE => l_module
467: ,P_API_NAME => L_API_NAME
468: ,P_PKG_NAME => G_PKG_NAME
469: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
470: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
471: ,X_MSG_COUNT => X_MSG_COUNT
472: ,X_MSG_DATA => X_MSG_DATA
473: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 480: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

476: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
477: P_MODULE => l_module
478: ,P_API_NAME => L_API_NAME
479: ,P_PKG_NAME => G_PKG_NAME
480: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
481: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
482: ,X_MSG_COUNT => X_MSG_COUNT
483: ,X_MSG_DATA => X_MSG_DATA
484: ,X_RETURN_STATUS => X_RETURN_STATUS);

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

523: IS
524: l_api_name CONSTANT VARCHAR2(30) := 'Delete_opp_Header';
525: l_api_version_number CONSTANT NUMBER := 2.0;
526: l_header_rec Header_Rec_Type := p_header_rec;
527: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
528: l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Delete_Opp_Header';
529: BEGIN
530: -- Standard Start of API savepoint
531: SAVEPOINT DELETE_OPP_HEADER_PUB;

Line 546: FND_MSG_PUB.initialize;

542:
543: -- Initialize message list if p_init_msg_list is set to TRUE.
544: IF FND_API.to_Boolean( p_init_msg_list )
545: THEN
546: FND_MSG_PUB.initialize;
547: END IF;
548:
549:
550: -- Debug Message

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

548:
549:
550: -- Debug Message
551: IF l_debug THEN
552: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
553: 'Public API: ' || l_api_name || ' start');
554:
555: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
556: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

551: IF l_debug THEN
552: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
553: 'Public API: ' || l_api_name || ' start');
554:
555: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
556: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
557: END IF;
558: -- Initialize API return status to SUCCESS
559: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 568: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

564:
565: /*****
566:
567: IF l_debug THEN
568: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
569: 'AS: Public API: Convert_Header_Values_To_Ids');
570:
571: END IF;
572:

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

613:
614:
615: -- Debug Message
616: IF l_debug THEN
617: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
618: 'Public API: ' || l_api_name || ' end');
619:
620: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
621: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

616: IF l_debug THEN
617: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
618: 'Public API: ' || l_api_name || ' end');
619:
620: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
621: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
622: END IF;
623:
624:

Line 626: FND_MSG_PUB.Count_And_Get

622: END IF;
623:
624:
625: -- Standard call to get message count and if count is 1, get message info.
626: FND_MSG_PUB.Count_And_Get
627: ( p_count => x_msg_count,
628: p_data => x_msg_data
629: );
630:

Line 637: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

633: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
634: P_MODULE => l_module
635: ,P_API_NAME => L_API_NAME
636: ,P_PKG_NAME => G_PKG_NAME
637: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
638: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
639: ,X_MSG_COUNT => X_MSG_COUNT
640: ,X_MSG_DATA => X_MSG_DATA
641: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 648: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

644: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
645: P_MODULE => l_module
646: ,P_API_NAME => L_API_NAME
647: ,P_PKG_NAME => G_PKG_NAME
648: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
649: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
650: ,X_MSG_COUNT => X_MSG_COUNT
651: ,X_MSG_DATA => X_MSG_DATA
652: ,X_RETURN_STATUS => X_RETURN_STATUS);

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

698: --l_pvt_Line_rec AS_OPP_LINE_PVT.Line_Rec_Type;
699:
700: l_line_tbl Line_Tbl_Type := p_line_tbl;
701: l_header_rec Header_Rec_Type := p_header_rec;
702: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
703: l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Create_Opp_Lines';
704:
705: BEGIN
706: -- Standard Start of API savepoint

Line 722: FND_MSG_PUB.initialize;

718:
719: -- Initialize message list if p_init_msg_list is set to TRUE.
720: IF FND_API.to_Boolean( p_init_msg_list )
721: THEN
722: FND_MSG_PUB.initialize;
723: END IF;
724:
725:
726: -- Debug Message

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

724:
725:
726: -- Debug Message
727: IF l_debug THEN
728: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
729: 'Public API: ' || l_api_name || ' start');
730:
731: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
732: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

727: IF l_debug THEN
728: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
729: 'Public API: ' || l_api_name || ' start');
730:
731: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
732: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
733: END IF;
734:
735: -- Initialize API return status to SUCCESS

Line 746: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

742: /*****
743:
744: -- Debug Message
745: IF l_debug THEN
746: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
747: 'AS: Public API: Convert_Line_Values_To_Ids');
748: END IF;
749:
750: -- Convert the values to ids

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

795:
796:
797: -- Debug Message
798: IF l_debug THEN
799: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
800: 'Public API: ' || l_api_name || ' end');
801:
802: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
803: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

798: IF l_debug THEN
799: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
800: 'Public API: ' || l_api_name || ' end');
801:
802: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
803: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
804:
805: END IF;
806:

Line 808: FND_MSG_PUB.Count_And_Get

804:
805: END IF;
806:
807: -- Standard call to get message count and if count is 1, get message info.
808: FND_MSG_PUB.Count_And_Get
809: ( p_count => x_msg_count,
810: p_data => x_msg_data
811: );
812:

Line 819: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

815: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
816: P_MODULE => l_module
817: ,P_API_NAME => L_API_NAME
818: ,P_PKG_NAME => G_PKG_NAME
819: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
820: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
821: ,X_MSG_COUNT => X_MSG_COUNT
822: ,X_MSG_DATA => X_MSG_DATA
823: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 830: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

826: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
827: P_MODULE => l_module
828: ,P_API_NAME => L_API_NAME
829: ,P_PKG_NAME => G_PKG_NAME
830: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
831: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
832: ,X_MSG_COUNT => X_MSG_COUNT
833: ,X_MSG_DATA => X_MSG_DATA
834: ,X_RETURN_STATUS => X_RETURN_STATUS);

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

877: l_api_name CONSTANT VARCHAR2(30) := 'Update_opp_lines';
878: l_api_version_number CONSTANT NUMBER := 2.0;
879: l_line_tbl Line_Tbl_Type := p_line_tbl;
880: l_header_rec Header_Rec_Type := p_header_rec;
881: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
882: l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Update_Opp_Lines';
883: BEGIN
884: -- Standard Start of API savepoint
885: SAVEPOINT UPDATE_OPP_LINES_PUB;

Line 900: FND_MSG_PUB.initialize;

896:
897: -- Initialize message list if p_init_msg_list is set to TRUE.
898: IF FND_API.to_Boolean( p_init_msg_list )
899: THEN
900: FND_MSG_PUB.initialize;
901: END IF;
902:
903:
904: -- Debug Message

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

902:
903:
904: -- Debug Message
905: IF l_debug THEN
906: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
907: 'Public API: ' || l_api_name || ' start');
908:
909: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
910: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

905: IF l_debug THEN
906: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
907: 'Public API: ' || l_api_name || ' start');
908:
909: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
910: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
911:
912: END IF;
913:

Line 925: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

921: /*****
922:
923: -- Debug Message
924: IF l_debug THEN
925: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
926: 'AS: Public API: Convert_Line_Values_To_Ids');
927:
928: END IF;
929:

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

972:
973:
974: -- Debug Message
975: IF l_debug THEN
976: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
977: 'Public API: ' || l_api_name || ' end');
978:
979: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
980: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

975: IF l_debug THEN
976: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
977: 'Public API: ' || l_api_name || ' end');
978:
979: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
980: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
981:
982: END IF;
983:

Line 985: FND_MSG_PUB.Count_And_Get

981:
982: END IF;
983:
984: -- Standard call to get message count and if count is 1, get message info.
985: FND_MSG_PUB.Count_And_Get
986: ( p_count => x_msg_count,
987: p_data => x_msg_data
988: );
989:

Line 996: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

992: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
993: P_MODULE => l_module
994: ,P_API_NAME => L_API_NAME
995: ,P_PKG_NAME => G_PKG_NAME
996: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
997: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
998: ,X_MSG_COUNT => X_MSG_COUNT
999: ,X_MSG_DATA => X_MSG_DATA
1000: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1007: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1003: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1004: P_MODULE => l_module
1005: ,P_API_NAME => L_API_NAME
1006: ,P_PKG_NAME => G_PKG_NAME
1007: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1008: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1009: ,X_MSG_COUNT => X_MSG_COUNT
1010: ,X_MSG_DATA => X_MSG_DATA
1011: ,X_RETURN_STATUS => X_RETURN_STATUS);

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

1053: l_api_name CONSTANT VARCHAR2(30) := 'Delete_opp_lines';
1054: l_api_version_number CONSTANT NUMBER := 2.0;
1055: l_line_tbl Line_Tbl_Type := p_line_tbl;
1056: l_header_rec Header_Rec_Type := p_header_rec;
1057: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
1058: l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Delete_Opp_Lines';
1059: BEGIN
1060: -- Standard Start of API savepoint
1061: SAVEPOINT DELETE_OPP_LINES_PUB;

Line 1076: FND_MSG_PUB.initialize;

1072:
1073: -- Initialize message list if p_init_msg_list is set to TRUE.
1074: IF FND_API.to_Boolean( p_init_msg_list )
1075: THEN
1076: FND_MSG_PUB.initialize;
1077: END IF;
1078:
1079:
1080: -- Debug Message

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

1078:
1079:
1080: -- Debug Message
1081: IF l_debug THEN
1082: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1083: 'Public API: ' || l_api_name || ' start');
1084:
1085: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1086: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

1081: IF l_debug THEN
1082: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1083: 'Public API: ' || l_api_name || ' start');
1084:
1085: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1086: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1087:
1088: END IF;
1089:

Line 1101: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1097: /*****
1098:
1099: -- Debug Message
1100: IF l_debug THEN
1101: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1102: 'AS: Public API: Convert_Line_Values_To_Ids');
1103: END IF;
1104:
1105: -- Convert the values to ids

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

1147:
1148:
1149: -- Debug Message
1150: IF l_debug THEN
1151: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1152: 'Public API: ' || l_api_name || ' end');
1153:
1154: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1155: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

1150: IF l_debug THEN
1151: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1152: 'Public API: ' || l_api_name || ' end');
1153:
1154: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1155: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1156:
1157: END IF;
1158:

Line 1160: FND_MSG_PUB.Count_And_Get

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

Line 1171: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1167: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1168: P_MODULE => l_module
1169: ,P_API_NAME => L_API_NAME
1170: ,P_PKG_NAME => G_PKG_NAME
1171: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1172: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1173: ,X_MSG_COUNT => X_MSG_COUNT
1174: ,X_MSG_DATA => X_MSG_DATA
1175: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1182: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1178: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1179: P_MODULE => l_module
1180: ,P_API_NAME => L_API_NAME
1181: ,P_PKG_NAME => G_PKG_NAME
1182: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1183: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1184: ,X_MSG_COUNT => X_MSG_COUNT
1185: ,X_MSG_DATA => X_MSG_DATA
1186: ,X_RETURN_STATUS => X_RETURN_STATUS);

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

1219: IS
1220: l_api_name CONSTANT VARCHAR2(30) := 'Create_sales_credits';
1221: l_api_version_number CONSTANT NUMBER := 2.0;
1222: l_sales_credit_tbl Sales_Credit_Tbl_type := p_sales_credit_tbl;
1223: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
1224: l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Create_Sales_Credits';
1225: BEGIN
1226: -- Standard Start of API savepoint
1227: SAVEPOINT CREATE_SALES_CREDITS_PUB;

Line 1242: FND_MSG_PUB.initialize;

1238:
1239: -- Initialize message list if p_init_msg_list is set to TRUE.
1240: IF FND_API.to_Boolean( p_init_msg_list )
1241: THEN
1242: FND_MSG_PUB.initialize;
1243: END IF;
1244:
1245:
1246: -- Debug Message

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

1244:
1245:
1246: -- Debug Message
1247: IF l_debug THEN
1248: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1249: 'Public API: ' || l_api_name || ' start');
1250:
1251: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1252: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

1247: IF l_debug THEN
1248: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1249: 'Public API: ' || l_api_name || ' start');
1250:
1251: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1252: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1253:
1254: END IF;
1255:

Line 1267: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1263: /*****
1264:
1265: -- Debug Message
1266: IF l_debug THEN
1267: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1268: 'AS: Public API: Convert_SALES_CREDIT_Values_To_Ids');
1269:
1270: END IF;
1271:

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

1316:
1317:
1318: -- Debug Message
1319: IF l_debug THEN
1320: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1321: 'Public API: ' || l_api_name || ' end');
1322:
1323: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1324: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

1319: IF l_debug THEN
1320: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1321: 'Public API: ' || l_api_name || ' end');
1322:
1323: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1324: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1325: END IF;
1326:
1327: -- Standard call to get message count and if count is 1, get message info.

Line 1328: FND_MSG_PUB.Count_And_Get

1324: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1325: END IF;
1326:
1327: -- Standard call to get message count and if count is 1, get message info.
1328: FND_MSG_PUB.Count_And_Get
1329: ( p_count => x_msg_count,
1330: p_data => x_msg_data
1331: );
1332:

Line 1339: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1335: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1336: P_MODULE => l_module
1337: ,P_API_NAME => L_API_NAME
1338: ,P_PKG_NAME => G_PKG_NAME
1339: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1340: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1341: ,X_MSG_COUNT => X_MSG_COUNT
1342: ,X_MSG_DATA => X_MSG_DATA
1343: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1350: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1346: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1347: P_MODULE => l_module
1348: ,P_API_NAME => L_API_NAME
1349: ,P_PKG_NAME => G_PKG_NAME
1350: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1351: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1352: ,X_MSG_COUNT => X_MSG_COUNT
1353: ,X_MSG_DATA => X_MSG_DATA
1354: ,X_RETURN_STATUS => X_RETURN_STATUS);

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

1387: IS
1388: l_api_name CONSTANT VARCHAR2(30) := 'Update_sales_credits';
1389: l_api_version_number CONSTANT NUMBER := 2.0;
1390: l_sales_credit_tbl Sales_Credit_Tbl_type := p_sales_credit_tbl;
1391: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
1392: l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Update_Sales_Credits';
1393: BEGIN
1394: -- Standard Start of API savepoint
1395: SAVEPOINT UPDATE_SALES_CREDITS_PUB;

Line 1410: FND_MSG_PUB.initialize;

1406:
1407: -- Initialize message list if p_init_msg_list is set to TRUE.
1408: IF FND_API.to_Boolean( p_init_msg_list )
1409: THEN
1410: FND_MSG_PUB.initialize;
1411: END IF;
1412:
1413:
1414: -- Debug Message

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

1412:
1413:
1414: -- Debug Message
1415: IF l_debug THEN
1416: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1417: 'Public API: ' || l_api_name || ' start');
1418:
1419: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1420: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

1415: IF l_debug THEN
1416: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1417: 'Public API: ' || l_api_name || ' start');
1418:
1419: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1420: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1421:
1422: END IF;
1423:

Line 1434: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1430:
1431: /*****
1432: -- Debug Message
1433: IF l_debug THEN
1434: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1435: 'AS: Public API: Convert_SALES_CREDIT_Values_To_Ids');
1436:
1437: END IF;
1438:

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

1480:
1481:
1482: -- Debug Message
1483: IF l_debug THEN
1484: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1485: 'Public API: ' || l_api_name || ' end');
1486:
1487: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1488: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

1483: IF l_debug THEN
1484: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1485: 'Public API: ' || l_api_name || ' end');
1486:
1487: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1488: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1489:
1490: END IF;
1491:

Line 1493: FND_MSG_PUB.Count_And_Get

1489:
1490: END IF;
1491:
1492: -- Standard call to get message count and if count is 1, get message info.
1493: FND_MSG_PUB.Count_And_Get
1494: ( p_count => x_msg_count,
1495: p_data => x_msg_data
1496: );
1497:

Line 1504: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1500: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1501: P_MODULE => l_module
1502: ,P_API_NAME => L_API_NAME
1503: ,P_PKG_NAME => G_PKG_NAME
1504: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1505: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1506: ,X_MSG_COUNT => X_MSG_COUNT
1507: ,X_MSG_DATA => X_MSG_DATA
1508: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1515: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1511: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1512: P_MODULE => l_module
1513: ,P_API_NAME => L_API_NAME
1514: ,P_PKG_NAME => G_PKG_NAME
1515: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1516: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1517: ,X_MSG_COUNT => X_MSG_COUNT
1518: ,X_MSG_DATA => X_MSG_DATA
1519: ,X_RETURN_STATUS => X_RETURN_STATUS);

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

1553: IS
1554: l_api_name CONSTANT VARCHAR2(30) := 'Modify_Sales_Credits';
1555: l_api_version_number CONSTANT NUMBER := 2.0;
1556: l_sales_credit_tbl Sales_Credit_Tbl_type := p_sales_credit_tbl;
1557: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
1558: l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Modify_Sales_Credits';
1559: BEGIN
1560: -- Standard Start of API savepoint
1561: SAVEPOINT MODIFY_SALES_CREDITS_PUB;

Line 1576: FND_MSG_PUB.initialize;

1572:
1573: -- Initialize message list if p_init_msg_list is set to TRUE.
1574: IF FND_API.to_Boolean( p_init_msg_list )
1575: THEN
1576: FND_MSG_PUB.initialize;
1577: END IF;
1578:
1579:
1580: -- Debug Message

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

1578:
1579:
1580: -- Debug Message
1581: IF l_debug THEN
1582: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1583: 'Public API: ' || l_api_name || ' start');
1584:
1585: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1586: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

1581: IF l_debug THEN
1582: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1583: 'Public API: ' || l_api_name || ' start');
1584:
1585: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1586: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1587:
1588: END IF;
1589:

Line 1600: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1596:
1597: /*****
1598: -- Debug Message
1599: IF l_debug THEN
1600: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1601: 'AS: Public API: Convert_SALES_CREDIT_Values_To_Ids');
1602: END IF;
1603:
1604:

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

1646:
1647:
1648: -- Debug Message
1649: IF l_debug THEN
1650: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1651: 'Public API: ' || l_api_name || ' end');
1652:
1653: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1654: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

1649: IF l_debug THEN
1650: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1651: 'Public API: ' || l_api_name || ' end');
1652:
1653: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1654: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1655: END IF;
1656: -- Standard call to get message count and if count is 1, get message info.
1657: FND_MSG_PUB.Count_And_Get

Line 1657: FND_MSG_PUB.Count_And_Get

1653: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1654: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1655: END IF;
1656: -- Standard call to get message count and if count is 1, get message info.
1657: FND_MSG_PUB.Count_And_Get
1658: ( p_count => x_msg_count,
1659: p_data => x_msg_data
1660: );
1661:

Line 1668: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1664: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1665: P_MODULE => l_module
1666: ,P_API_NAME => L_API_NAME
1667: ,P_PKG_NAME => G_PKG_NAME
1668: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1669: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1670: ,X_MSG_COUNT => X_MSG_COUNT
1671: ,X_MSG_DATA => X_MSG_DATA
1672: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1679: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1675: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1676: P_MODULE => l_module
1677: ,P_API_NAME => L_API_NAME
1678: ,P_PKG_NAME => G_PKG_NAME
1679: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1680: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1681: ,X_MSG_COUNT => X_MSG_COUNT
1682: ,X_MSG_DATA => X_MSG_DATA
1683: ,X_RETURN_STATUS => X_RETURN_STATUS);

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

1716: IS
1717: l_api_name CONSTANT VARCHAR2(30) := 'Delete_sales_credits';
1718: l_api_version_number CONSTANT NUMBER := 2.0;
1719: l_sales_credit_tbl Sales_Credit_Tbl_type := p_sales_credit_tbl;
1720: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
1721: l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Delete_Sales_Credits';
1722: BEGIN
1723: -- Standard Start of API savepoint
1724: SAVEPOINT DELETE_SALES_CREDITS_PUB;

Line 1739: FND_MSG_PUB.initialize;

1735:
1736: -- Initialize message list if p_init_msg_list is set to TRUE.
1737: IF FND_API.to_Boolean( p_init_msg_list )
1738: THEN
1739: FND_MSG_PUB.initialize;
1740: END IF;
1741:
1742:
1743: -- Debug Message

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

1741:
1742:
1743: -- Debug Message
1744: IF l_debug THEN
1745: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1746: 'Public API: ' || l_api_name || ' start');
1747:
1748: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1749: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

1744: IF l_debug THEN
1745: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1746: 'Public API: ' || l_api_name || ' start');
1747:
1748: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1749: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1750:
1751: END IF;
1752:

Line 1764: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1760: /*****
1761:
1762: -- Debug Message
1763: IF l_debug THEN
1764: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1765: 'AS: Public API: Convert_SALES_CREDIT_Values_To_Ids');
1766: END IF;
1767:
1768: -- Convert the values to ids

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

1808:
1809:
1810: -- Debug Message
1811: IF l_debug THEN
1812: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1813: 'Public API: ' || l_api_name || ' end');
1814:
1815: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1816: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

1811: IF l_debug THEN
1812: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1813: 'Public API: ' || l_api_name || ' end');
1814:
1815: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1816: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1817:
1818: END IF;
1819:

Line 1821: FND_MSG_PUB.Count_And_Get

1817:
1818: END IF;
1819:
1820: -- Standard call to get message count and if count is 1, get message info.
1821: FND_MSG_PUB.Count_And_Get
1822: ( p_count => x_msg_count,
1823: p_data => x_msg_data
1824: );
1825:

Line 1832: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1828: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1829: P_MODULE => l_module
1830: ,P_API_NAME => L_API_NAME
1831: ,P_PKG_NAME => G_PKG_NAME
1832: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1833: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1834: ,X_MSG_COUNT => X_MSG_COUNT
1835: ,X_MSG_DATA => X_MSG_DATA
1836: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1843: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1839: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1840: P_MODULE => l_module
1841: ,P_API_NAME => L_API_NAME
1842: ,P_PKG_NAME => G_PKG_NAME
1843: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1844: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1845: ,X_MSG_COUNT => X_MSG_COUNT
1846: ,X_MSG_DATA => X_MSG_DATA
1847: ,X_RETURN_STATUS => X_RETURN_STATUS);

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

1880: IS
1881: l_api_name CONSTANT VARCHAR2(30) := 'Update_orders';
1882: l_api_version_number CONSTANT NUMBER := 2.0;
1883: l_order_tbl Order_Tbl_Type := p_lead_order_tbl;
1884: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
1885: l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Update_Orders';
1886: BEGIN
1887: -- Standard Start of API savepoint
1888: SAVEPOINT UPDATE_ORDERS_PUB;

Line 1903: FND_MSG_PUB.initialize;

1899:
1900: -- Initialize message list if p_init_msg_list is set to TRUE.
1901: IF FND_API.to_Boolean( p_init_msg_list )
1902: THEN
1903: FND_MSG_PUB.initialize;
1904: END IF;
1905:
1906:
1907: -- Debug Message

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

1905:
1906:
1907: -- Debug Message
1908: IF l_debug THEN
1909: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1910: 'Public API: ' || l_api_name || ' start');
1911:
1912: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1913: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

1908: IF l_debug THEN
1909: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1910: 'Public API: ' || l_api_name || ' start');
1911:
1912: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1913: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1914: END IF;
1915:
1916: -- Initialize API return status to SUCCESS

Line 1927: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1923: /*****
1924:
1925: -- Debug Message
1926: IF l_debug THEN
1927: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1928: 'AS: Public API: Convert_Order_Values_To_Ids');
1929: END IF;
1930:
1931:

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

1976:
1977:
1978: -- Debug Message
1979: IF l_debug THEN
1980: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1981: 'Public API: ' || l_api_name || ' end');
1982:
1983: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1984: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

1979: IF l_debug THEN
1980: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1981: 'Public API: ' || l_api_name || ' end');
1982:
1983: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1984: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1985:
1986: END IF;
1987:

Line 1989: FND_MSG_PUB.Count_And_Get

1985:
1986: END IF;
1987:
1988: -- Standard call to get message count and if count is 1, get message info.
1989: FND_MSG_PUB.Count_And_Get
1990: ( p_count => x_msg_count,
1991: p_data => x_msg_data
1992: );
1993:

Line 2000: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1996: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1997: P_MODULE => l_module
1998: ,P_API_NAME => L_API_NAME
1999: ,P_PKG_NAME => G_PKG_NAME
2000: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2001: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2002: ,X_MSG_COUNT => X_MSG_COUNT
2003: ,X_MSG_DATA => X_MSG_DATA
2004: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2011: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

2007: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2008: P_MODULE => l_module
2009: ,P_API_NAME => L_API_NAME
2010: ,P_PKG_NAME => G_PKG_NAME
2011: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2012: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2013: ,X_MSG_COUNT => X_MSG_COUNT
2014: ,X_MSG_DATA => X_MSG_DATA
2015: ,X_RETURN_STATUS => X_RETURN_STATUS);

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

2048: IS
2049: l_api_name CONSTANT VARCHAR2(30) := 'Delete_orders';
2050: l_api_version_number CONSTANT NUMBER := 2.0;
2051: l_order_tbl Order_Tbl_Type := p_lead_order_tbl;
2052: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
2053: l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Delete_Orders';
2054: BEGIN
2055: -- Standard Start of API savepoint
2056: SAVEPOINT DELETE_ORDERS_PUB;

Line 2071: FND_MSG_PUB.initialize;

2067:
2068: -- Initialize message list if p_init_msg_list is set to TRUE.
2069: IF FND_API.to_Boolean( p_init_msg_list )
2070: THEN
2071: FND_MSG_PUB.initialize;
2072: END IF;
2073:
2074:
2075: -- Debug Message

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

2073:
2074:
2075: -- Debug Message
2076: IF l_debug THEN
2077: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2078: 'Public API: ' || l_api_name || ' start');
2079:
2080: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2081: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

2076: IF l_debug THEN
2077: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2078: 'Public API: ' || l_api_name || ' start');
2079:
2080: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2081: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2082: END IF;
2083:
2084: -- Initialize API return status to SUCCESS

Line 2095: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2091: /*****
2092:
2093: -- Debug Message
2094: IF l_debug THEN
2095: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2096: 'AS: Public API: Convert_Order_Values_To_Ids');
2097: END IF;
2098:
2099: -- Convert the values to ids

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

2140:
2141:
2142: -- Debug Message
2143: IF l_debug THEN
2144: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2145: 'Public API: ' || l_api_name || ' end');
2146:
2147: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2148: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

2143: IF l_debug THEN
2144: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2145: 'Public API: ' || l_api_name || ' end');
2146:
2147: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2148: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2149: END IF;
2150:
2151:

Line 2153: FND_MSG_PUB.Count_And_Get

2149: END IF;
2150:
2151:
2152: -- Standard call to get message count and if count is 1, get message info.
2153: FND_MSG_PUB.Count_And_Get
2154: ( p_count => x_msg_count,
2155: p_data => x_msg_data
2156: );
2157:

Line 2164: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

2160: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2161: P_MODULE => l_module
2162: ,P_API_NAME => L_API_NAME
2163: ,P_PKG_NAME => G_PKG_NAME
2164: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2165: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2166: ,X_MSG_COUNT => X_MSG_COUNT
2167: ,X_MSG_DATA => X_MSG_DATA
2168: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2175: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

2171: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2172: P_MODULE => l_module
2173: ,P_API_NAME => L_API_NAME
2174: ,P_PKG_NAME => G_PKG_NAME
2175: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2176: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2177: ,X_MSG_COUNT => X_MSG_COUNT
2178: ,X_MSG_DATA => X_MSG_DATA
2179: ,X_RETURN_STATUS => X_RETURN_STATUS);

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

2212: IS
2213: l_api_name CONSTANT VARCHAR2(30) := 'Create_competitors';
2214: l_api_version_number CONSTANT NUMBER := 2.0;
2215: l_competitor_tbl Competitor_Tbl_Type := p_competitor_tbl;
2216: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
2217: l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Create_Competitors';
2218:
2219: BEGIN
2220: -- Standard Start of API savepoint

Line 2236: FND_MSG_PUB.initialize;

2232:
2233: -- Initialize message list if p_init_msg_list is set to TRUE.
2234: IF FND_API.to_Boolean( p_init_msg_list )
2235: THEN
2236: FND_MSG_PUB.initialize;
2237: END IF;
2238:
2239:
2240: -- Debug Message

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

2238:
2239:
2240: -- Debug Message
2241: IF l_debug THEN
2242: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2243: 'Public API: ' || l_api_name || ' start');
2244:
2245: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2246: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

2241: IF l_debug THEN
2242: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2243: 'Public API: ' || l_api_name || ' start');
2244:
2245: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2246: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2247:
2248: END IF;
2249: -- Initialize API return status to SUCCESS

Line 2260: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2256: /*****
2257:
2258: -- Debug Message
2259: IF l_debug THEN
2260: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2261: 'AS: Public API: Convert_Competitor_Values_To_Ids');
2262: END IF;
2263:
2264: -- Convert the values to ids

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

2307:
2308:
2309: -- Debug Message
2310: IF l_debug THEN
2311: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2312: 'Public API: ' || l_api_name || ' end');
2313:
2314: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2315: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

2310: IF l_debug THEN
2311: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2312: 'Public API: ' || l_api_name || ' end');
2313:
2314: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2315: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2316:
2317: END IF;
2318:

Line 2320: FND_MSG_PUB.Count_And_Get

2316:
2317: END IF;
2318:
2319: -- Standard call to get message count and if count is 1, get message info.
2320: FND_MSG_PUB.Count_And_Get
2321: ( p_count => x_msg_count,
2322: p_data => x_msg_data
2323: );
2324:

Line 2331: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

2327: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2328: P_MODULE => l_module
2329: ,P_API_NAME => L_API_NAME
2330: ,P_PKG_NAME => G_PKG_NAME
2331: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2332: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2333: ,X_MSG_COUNT => X_MSG_COUNT
2334: ,X_MSG_DATA => X_MSG_DATA
2335: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2342: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

2338: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2339: P_MODULE => l_module
2340: ,P_API_NAME => L_API_NAME
2341: ,P_PKG_NAME => G_PKG_NAME
2342: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2343: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2344: ,X_MSG_COUNT => X_MSG_COUNT
2345: ,X_MSG_DATA => X_MSG_DATA
2346: ,X_RETURN_STATUS => X_RETURN_STATUS);

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

2379: IS
2380: l_api_name CONSTANT VARCHAR2(30) := 'Update_competitors';
2381: l_api_version_number CONSTANT NUMBER := 2.0;
2382: l_competitor_tbl Competitor_Tbl_Type := p_competitor_tbl;
2383: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
2384: l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Update_Competitors';
2385: BEGIN
2386: -- Standard Start of API savepoint
2387: SAVEPOINT UPDATE_COMPETITORS_PUB;

Line 2402: FND_MSG_PUB.initialize;

2398:
2399: -- Initialize message list if p_init_msg_list is set to TRUE.
2400: IF FND_API.to_Boolean( p_init_msg_list )
2401: THEN
2402: FND_MSG_PUB.initialize;
2403: END IF;
2404:
2405:
2406: -- Debug Message

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

2404:
2405:
2406: -- Debug Message
2407: IF l_debug THEN
2408: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2409: 'Public API: ' || l_api_name || ' start');
2410:
2411: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2412: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

2407: IF l_debug THEN
2408: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2409: 'Public API: ' || l_api_name || ' start');
2410:
2411: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2412: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2413:
2414: END IF;
2415:

Line 2426: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2422:
2423: /*****
2424: -- Debug Message
2425: IF l_debug THEN
2426: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2427: 'AS: Public API: Convert_Competitor_Values_To_Ids');
2428:
2429:
2430: END IF;

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

2473:
2474:
2475: -- Debug Message
2476: IF l_debug THEN
2477: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2478: 'Public API: ' || l_api_name || ' end');
2479:
2480: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2481: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

2476: IF l_debug THEN
2477: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2478: 'Public API: ' || l_api_name || ' end');
2479:
2480: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2481: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2482:
2483: END IF;
2484: -- Standard call to get message count and if count is 1, get message info.

Line 2485: FND_MSG_PUB.Count_And_Get

2481: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2482:
2483: END IF;
2484: -- Standard call to get message count and if count is 1, get message info.
2485: FND_MSG_PUB.Count_And_Get
2486: ( p_count => x_msg_count,
2487: p_data => x_msg_data
2488: );
2489:

Line 2496: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

2492: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2493: P_MODULE => l_module
2494: ,P_API_NAME => L_API_NAME
2495: ,P_PKG_NAME => G_PKG_NAME
2496: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2497: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2498: ,X_MSG_COUNT => X_MSG_COUNT
2499: ,X_MSG_DATA => X_MSG_DATA
2500: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2507: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

2503: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2504: P_MODULE => l_module
2505: ,P_API_NAME => L_API_NAME
2506: ,P_PKG_NAME => G_PKG_NAME
2507: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2508: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2509: ,X_MSG_COUNT => X_MSG_COUNT
2510: ,X_MSG_DATA => X_MSG_DATA
2511: ,X_RETURN_STATUS => X_RETURN_STATUS);

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

2544: IS
2545: l_api_name CONSTANT VARCHAR2(30) := 'Delete_competitors';
2546: l_api_version_number CONSTANT NUMBER := 2.0;
2547: l_competitor_tbl Competitor_Tbl_Type := p_competitor_tbl;
2548: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
2549: l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Delete_Competitors';
2550: BEGIN
2551: -- Standard Start of API savepoint
2552: SAVEPOINT DELETE_COMPETITORS_PUB;

Line 2567: FND_MSG_PUB.initialize;

2563:
2564: -- Initialize message list if p_init_msg_list is set to TRUE.
2565: IF FND_API.to_Boolean( p_init_msg_list )
2566: THEN
2567: FND_MSG_PUB.initialize;
2568: END IF;
2569:
2570:
2571: -- Debug Message

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

2569:
2570:
2571: -- Debug Message
2572: IF l_debug THEN
2573: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2574: 'Public API: ' || l_api_name || ' start');
2575:
2576: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2577: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

2572: IF l_debug THEN
2573: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2574: 'Public API: ' || l_api_name || ' start');
2575:
2576: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2577: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2578:
2579: END IF;
2580:

Line 2591: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2587:
2588: /*****
2589: -- Debug Message
2590: IF l_debug THEN
2591: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2592: 'AS: Public API: Convert_Competitor_Values_To_Ids');
2593:
2594: END IF;
2595:

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

2637:
2638:
2639: -- Debug Message
2640: IF l_debug THEN
2641: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2642: 'Public API: ' || l_api_name || ' end');
2643:
2644: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2645: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

2640: IF l_debug THEN
2641: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2642: 'Public API: ' || l_api_name || ' end');
2643:
2644: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2645: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2646: END IF;
2647:
2648: -- Standard call to get message count and if count is 1, get message info.

Line 2649: FND_MSG_PUB.Count_And_Get

2645: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2646: END IF;
2647:
2648: -- Standard call to get message count and if count is 1, get message info.
2649: FND_MSG_PUB.Count_And_Get
2650: ( p_count => x_msg_count,
2651: p_data => x_msg_data
2652: );
2653:

Line 2660: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

2656: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2657: P_MODULE => l_module
2658: ,P_API_NAME => L_API_NAME
2659: ,P_PKG_NAME => G_PKG_NAME
2660: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2661: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2662: ,X_MSG_COUNT => X_MSG_COUNT
2663: ,X_MSG_DATA => X_MSG_DATA
2664: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2671: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

2667: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2668: P_MODULE => l_module
2669: ,P_API_NAME => L_API_NAME
2670: ,P_PKG_NAME => G_PKG_NAME
2671: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2672: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2673: ,X_MSG_COUNT => X_MSG_COUNT
2674: ,X_MSG_DATA => X_MSG_DATA
2675: ,X_RETURN_STATUS => X_RETURN_STATUS);

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

2708: IS
2709: l_api_name CONSTANT VARCHAR2(30) := 'Create_competitor_prods';
2710: l_api_version_number CONSTANT NUMBER := 2.0;
2711: l_competitor_prod_tbl Competitor_Prod_Tbl_Type := p_competitor_prod_tbl;
2712: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
2713: l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Create_Competitor_Prods';
2714:
2715: BEGIN
2716: -- Standard Start of API savepoint

Line 2732: FND_MSG_PUB.initialize;

2728:
2729: -- Initialize message list if p_init_msg_list is set to TRUE.
2730: IF FND_API.to_Boolean( p_init_msg_list )
2731: THEN
2732: FND_MSG_PUB.initialize;
2733: END IF;
2734:
2735:
2736: -- Debug Message

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

2734:
2735:
2736: -- Debug Message
2737: IF l_debug THEN
2738: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2739: 'Public API: ' || l_api_name || ' start');
2740:
2741: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2742: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

2737: IF l_debug THEN
2738: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2739: 'Public API: ' || l_api_name || ' start');
2740:
2741: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2742: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2743:
2744: END IF;
2745:

Line 2757: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2753: /*****
2754:
2755: -- Debug Message
2756: IF l_debug THEN
2757: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2758: 'AS: Public API: Convert_Competitor_Prod_Values_To_Ids');
2759: END IF;
2760:
2761: -- Convert the values to ids

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

2804:
2805:
2806: -- Debug Message
2807: IF l_debug THEN
2808: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2809: 'Public API: ' || l_api_name || ' end');
2810:
2811: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2812: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

2807: IF l_debug THEN
2808: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2809: 'Public API: ' || l_api_name || ' end');
2810:
2811: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2812: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2813: END IF;
2814:
2815:

Line 2817: FND_MSG_PUB.Count_And_Get

2813: END IF;
2814:
2815:
2816: -- Standard call to get message count and if count is 1, get message info.
2817: FND_MSG_PUB.Count_And_Get
2818: ( p_count => x_msg_count,
2819: p_data => x_msg_data
2820: );
2821:

Line 2828: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

2824: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2825: P_MODULE => l_module
2826: ,P_API_NAME => L_API_NAME
2827: ,P_PKG_NAME => G_PKG_NAME
2828: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2829: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2830: ,X_MSG_COUNT => X_MSG_COUNT
2831: ,X_MSG_DATA => X_MSG_DATA
2832: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2839: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

2835: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2836: P_MODULE => l_module
2837: ,P_API_NAME => L_API_NAME
2838: ,P_PKG_NAME => G_PKG_NAME
2839: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2840: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2841: ,X_MSG_COUNT => X_MSG_COUNT
2842: ,X_MSG_DATA => X_MSG_DATA
2843: ,X_RETURN_STATUS => X_RETURN_STATUS);

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

2876: IS
2877: l_api_name CONSTANT VARCHAR2(30) := 'Update_competitor_prods';
2878: l_api_version_number CONSTANT NUMBER := 2.0;
2879: l_competitor_prod_tbl Competitor_Prod_Tbl_Type := p_competitor_prod_tbl;
2880: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
2881: l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Update_Competitor_Prods';
2882: BEGIN
2883: -- Standard Start of API savepoint
2884: SAVEPOINT UPDATE_COMPETITOR_PRODS_PUB;

Line 2899: FND_MSG_PUB.initialize;

2895:
2896: -- Initialize message list if p_init_msg_list is set to TRUE.
2897: IF FND_API.to_Boolean( p_init_msg_list )
2898: THEN
2899: FND_MSG_PUB.initialize;
2900: END IF;
2901:
2902:
2903: -- Debug Message

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

2901:
2902:
2903: -- Debug Message
2904: IF l_debug THEN
2905: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2906: 'Public API: ' || l_api_name || ' start');
2907:
2908: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2909: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

2904: IF l_debug THEN
2905: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2906: 'Public API: ' || l_api_name || ' start');
2907:
2908: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2909: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2910:
2911: END IF;
2912:

Line 2923: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2919:
2920: /*****
2921: -- Debug Message
2922: IF l_debug THEN
2923: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2924: 'AS: Public API: Convert_Competitor_Prod_Values_To_Ids');
2925: END IF;
2926:
2927:

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

2969:
2970:
2971: -- Debug Message
2972: IF l_debug THEN
2973: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2974: 'Public API: ' || l_api_name || ' end');
2975:
2976: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2977: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

2972: IF l_debug THEN
2973: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2974: 'Public API: ' || l_api_name || ' end');
2975:
2976: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2977: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2978: END IF;
2979:
2980: -- Standard call to get message count and if count is 1, get message info.

Line 2981: FND_MSG_PUB.Count_And_Get

2977: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2978: END IF;
2979:
2980: -- Standard call to get message count and if count is 1, get message info.
2981: FND_MSG_PUB.Count_And_Get
2982: ( p_count => x_msg_count,
2983: p_data => x_msg_data
2984: );
2985:

Line 2992: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

2988: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2989: P_MODULE => l_module
2990: ,P_API_NAME => L_API_NAME
2991: ,P_PKG_NAME => G_PKG_NAME
2992: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2993: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
2994: ,X_MSG_COUNT => X_MSG_COUNT
2995: ,X_MSG_DATA => X_MSG_DATA
2996: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 3003: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

2999: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3000: P_MODULE => l_module
3001: ,P_API_NAME => L_API_NAME
3002: ,P_PKG_NAME => G_PKG_NAME
3003: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3004: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3005: ,X_MSG_COUNT => X_MSG_COUNT
3006: ,X_MSG_DATA => X_MSG_DATA
3007: ,X_RETURN_STATUS => X_RETURN_STATUS);

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

3040: IS
3041: l_api_name CONSTANT VARCHAR2(30) := 'Delete_competitor_prods';
3042: l_api_version_number CONSTANT NUMBER := 2.0;
3043: l_competitor_prod_tbl Competitor_Prod_Tbl_Type := p_competitor_prod_tbl;
3044: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
3045: l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Delete_Competitor_Prods';
3046: BEGIN
3047: -- Standard Start of API savepoint
3048: SAVEPOINT DELETE_COMPETITOR_PRODS_PUB;

Line 3063: FND_MSG_PUB.initialize;

3059:
3060: -- Initialize message list if p_init_msg_list is set to TRUE.
3061: IF FND_API.to_Boolean( p_init_msg_list )
3062: THEN
3063: FND_MSG_PUB.initialize;
3064: END IF;
3065:
3066:
3067: -- Debug Message

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

3065:
3066:
3067: -- Debug Message
3068: IF l_debug THEN
3069: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3070: 'Public API: ' || l_api_name || ' start');
3071:
3072: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3073: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

3068: IF l_debug THEN
3069: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3070: 'Public API: ' || l_api_name || ' start');
3071:
3072: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3073: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
3074: END IF;
3075:
3076:

Line 3087: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3083:
3084: /*****
3085: -- Debug Message
3086: IF l_debug THEN
3087: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3088: 'AS: Public API: Convert_Competitor_Prod_Values_To_Ids');
3089: END IF;
3090:
3091:

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

3133:
3134:
3135: -- Debug Message
3136: IF l_debug THEN
3137: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3138: 'Public API: ' || l_api_name || ' end');
3139:
3140: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3141: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

3136: IF l_debug THEN
3137: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3138: 'Public API: ' || l_api_name || ' end');
3139:
3140: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3141: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
3142: END IF;
3143:
3144:

Line 3146: FND_MSG_PUB.Count_And_Get

3142: END IF;
3143:
3144:
3145: -- Standard call to get message count and if count is 1, get message info.
3146: FND_MSG_PUB.Count_And_Get
3147: ( p_count => x_msg_count,
3148: p_data => x_msg_data
3149: );
3150:

Line 3157: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

3153: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3154: P_MODULE => l_module
3155: ,P_API_NAME => L_API_NAME
3156: ,P_PKG_NAME => G_PKG_NAME
3157: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3158: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3159: ,X_MSG_COUNT => X_MSG_COUNT
3160: ,X_MSG_DATA => X_MSG_DATA
3161: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 3168: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

3164: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3165: P_MODULE => l_module
3166: ,P_API_NAME => L_API_NAME
3167: ,P_PKG_NAME => G_PKG_NAME
3168: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3169: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3170: ,X_MSG_COUNT => X_MSG_COUNT
3171: ,X_MSG_DATA => X_MSG_DATA
3172: ,X_RETURN_STATUS => X_RETURN_STATUS);

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

3205: IS
3206: l_api_name CONSTANT VARCHAR2(30) := 'Create_decision_factors';
3207: l_api_version_number CONSTANT NUMBER := 2.0;
3208: l_decision_factor_tbl Decision_Factor_Tbl_Type := p_decision_factor_tbl;
3209: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
3210: l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Create_Decision_Factors';
3211: BEGIN
3212: -- Standard Start of API savepoint
3213: SAVEPOINT CREATE_DECISION_FACTORS_PUB;

Line 3228: FND_MSG_PUB.initialize;

3224:
3225: -- Initialize message list if p_init_msg_list is set to TRUE.
3226: IF FND_API.to_Boolean( p_init_msg_list )
3227: THEN
3228: FND_MSG_PUB.initialize;
3229: END IF;
3230:
3231:
3232: -- Debug Message

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

3230:
3231:
3232: -- Debug Message
3233: IF l_debug THEN
3234: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3235: 'Public API: ' || l_api_name || ' start');
3236:
3237: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3238: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

3233: IF l_debug THEN
3234: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3235: 'Public API: ' || l_api_name || ' start');
3236:
3237: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3238: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
3239: END IF;
3240:
3241:

Line 3253: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3249: /*****
3250:
3251: -- Debug Message
3252: IF l_debug THEN
3253: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3254: 'AS: Public API: Convert_Decision_Factor_Values_To_Ids');
3255: END IF;
3256:
3257: -- Convert the values to ids

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

3300:
3301:
3302: -- Debug Message
3303: IF l_debug THEN
3304: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3305: 'Public API: ' || l_api_name || ' end');
3306:
3307: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3308: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

3303: IF l_debug THEN
3304: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3305: 'Public API: ' || l_api_name || ' end');
3306:
3307: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3308: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
3309: END IF;
3310:
3311:

Line 3313: FND_MSG_PUB.Count_And_Get

3309: END IF;
3310:
3311:
3312: -- Standard call to get message count and if count is 1, get message info.
3313: FND_MSG_PUB.Count_And_Get
3314: ( p_count => x_msg_count,
3315: p_data => x_msg_data
3316: );
3317:

Line 3324: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

3320: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3321: P_MODULE => l_module
3322: ,P_API_NAME => L_API_NAME
3323: ,P_PKG_NAME => G_PKG_NAME
3324: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3325: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3326: ,X_MSG_COUNT => X_MSG_COUNT
3327: ,X_MSG_DATA => X_MSG_DATA
3328: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 3335: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

3331: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3332: P_MODULE => l_module
3333: ,P_API_NAME => L_API_NAME
3334: ,P_PKG_NAME => G_PKG_NAME
3335: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3336: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3337: ,X_MSG_COUNT => X_MSG_COUNT
3338: ,X_MSG_DATA => X_MSG_DATA
3339: ,X_RETURN_STATUS => X_RETURN_STATUS);

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

3372: IS
3373: l_api_name CONSTANT VARCHAR2(30) := 'Update_decision_factors';
3374: l_api_version_number CONSTANT NUMBER := 2.0;
3375: l_decision_factor_tbl Decision_Factor_Tbl_Type := p_decision_factor_tbl;
3376: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
3377: l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Update_Decision_Factors';
3378: BEGIN
3379: -- Standard Start of API savepoint
3380: SAVEPOINT UPDATE_DECISION_FACTORS_PUB;

Line 3395: FND_MSG_PUB.initialize;

3391:
3392: -- Initialize message list if p_init_msg_list is set to TRUE.
3393: IF FND_API.to_Boolean( p_init_msg_list )
3394: THEN
3395: FND_MSG_PUB.initialize;
3396: END IF;
3397:
3398:
3399: -- Debug Message

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

3397:
3398:
3399: -- Debug Message
3400: IF l_debug THEN
3401: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3402: 'Public API: ' || l_api_name || ' start');
3403:
3404: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3405: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

3400: IF l_debug THEN
3401: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3402: 'Public API: ' || l_api_name || ' start');
3403:
3404: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3405: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
3406: END IF;
3407:
3408: -- Initialize API return status to SUCCESS

Line 3418: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3414:
3415: /*****
3416: -- Debug Message
3417: IF l_debug THEN
3418: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3419: 'AS: Public API: Convert_Decision_Factor_Values_To_Ids');
3420: END IF;
3421:
3422:

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

3464:
3465:
3466: -- Debug Message
3467: IF l_debug THEN
3468: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3469: 'Public API: ' || l_api_name || ' end');
3470:
3471: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3472: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

3467: IF l_debug THEN
3468: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3469: 'Public API: ' || l_api_name || ' end');
3470:
3471: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3472: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
3473: END IF;
3474:
3475:

Line 3477: FND_MSG_PUB.Count_And_Get

3473: END IF;
3474:
3475:
3476: -- Standard call to get message count and if count is 1, get message info.
3477: FND_MSG_PUB.Count_And_Get
3478: ( p_count => x_msg_count,
3479: p_data => x_msg_data
3480: );
3481:

Line 3488: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

3484: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3485: P_MODULE => l_module
3486: ,P_API_NAME => L_API_NAME
3487: ,P_PKG_NAME => G_PKG_NAME
3488: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3489: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3490: ,X_MSG_COUNT => X_MSG_COUNT
3491: ,X_MSG_DATA => X_MSG_DATA
3492: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 3499: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

3495: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3496: P_MODULE => l_module
3497: ,P_API_NAME => L_API_NAME
3498: ,P_PKG_NAME => G_PKG_NAME
3499: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3500: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3501: ,X_MSG_COUNT => X_MSG_COUNT
3502: ,X_MSG_DATA => X_MSG_DATA
3503: ,X_RETURN_STATUS => X_RETURN_STATUS);

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

3536: IS
3537: l_api_name CONSTANT VARCHAR2(30) := 'Delete_decision_factors';
3538: l_api_version_number CONSTANT NUMBER := 2.0;
3539: l_decision_factor_tbl Decision_Factor_Tbl_Type := p_decision_factor_tbl;
3540: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
3541: l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Delete_Decision_Factors';
3542: BEGIN
3543: -- Standard Start of API savepoint
3544: SAVEPOINT DELETE_DECISION_FACTORS_PUB;

Line 3559: FND_MSG_PUB.initialize;

3555:
3556: -- Initialize message list if p_init_msg_list is set to TRUE.
3557: IF FND_API.to_Boolean( p_init_msg_list )
3558: THEN
3559: FND_MSG_PUB.initialize;
3560: END IF;
3561:
3562:
3563: -- Debug Message

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

3561:
3562:
3563: -- Debug Message
3564: IF l_debug THEN
3565: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3566: 'Public API: ' || l_api_name || ' start');
3567:
3568: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3569: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

3564: IF l_debug THEN
3565: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3566: 'Public API: ' || l_api_name || ' start');
3567:
3568: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3569: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
3570: END IF;
3571:
3572:

Line 3583: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3579:
3580: /*****
3581: -- Debug Message
3582: IF l_debug THEN
3583: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3584: 'AS: Public API: Convert_Decision_Factor_Values_To_Ids');
3585: END IF;
3586:
3587:

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

3629:
3630:
3631: -- Debug Message
3632: IF l_debug THEN
3633: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3634: 'Public API: ' || l_api_name || ' end');
3635:
3636: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3637: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

3632: IF l_debug THEN
3633: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3634: 'Public API: ' || l_api_name || ' end');
3635:
3636: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3637: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
3638: END IF;
3639:
3640:

Line 3642: FND_MSG_PUB.Count_And_Get

3638: END IF;
3639:
3640:
3641: -- Standard call to get message count and if count is 1, get message info.
3642: FND_MSG_PUB.Count_And_Get
3643: ( p_count => x_msg_count,
3644: p_data => x_msg_data
3645: );
3646:

Line 3653: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

3649: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3650: P_MODULE => l_module
3651: ,P_API_NAME => L_API_NAME
3652: ,P_PKG_NAME => G_PKG_NAME
3653: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3654: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3655: ,X_MSG_COUNT => X_MSG_COUNT
3656: ,X_MSG_DATA => X_MSG_DATA
3657: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 3664: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

3660: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3661: P_MODULE => l_module
3662: ,P_API_NAME => L_API_NAME
3663: ,P_PKG_NAME => G_PKG_NAME
3664: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3665: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3666: ,X_MSG_COUNT => X_MSG_COUNT
3667: ,X_MSG_DATA => X_MSG_DATA
3668: ,X_RETURN_STATUS => X_RETURN_STATUS);

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

3703: l_api_name CONSTANT VARCHAR2(30) := 'Create_contacts';
3704: l_api_version_number CONSTANT NUMBER := 2.0;
3705:
3706: l_contact_tbl Contact_Tbl_type := p_contact_tbl;
3707: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
3708: l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Create_Contacts';
3709: BEGIN
3710: -- Standard Start of API savepoint
3711: SAVEPOINT CREATE_CONTACTS_PUB;

Line 3726: FND_MSG_PUB.initialize;

3722:
3723: -- Initialize message list if p_init_msg_list is set to TRUE.
3724: IF FND_API.to_Boolean( p_init_msg_list )
3725: THEN
3726: FND_MSG_PUB.initialize;
3727: END IF;
3728:
3729:
3730: -- Debug Message

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

3728:
3729:
3730: -- Debug Message
3731: IF l_debug THEN
3732: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3733: 'Public API: ' || l_api_name || ' start');
3734:
3735: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3736: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

3731: IF l_debug THEN
3732: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3733: 'Public API: ' || l_api_name || ' start');
3734:
3735: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3736: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
3737: END IF;
3738:
3739:

Line 3750: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3746:
3747: /*****
3748: -- Debug Message
3749: IF l_debug THEN
3750: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3751: 'AS: Public API: Convert_Contact_Values_To_Ids');
3752: END IF;
3753:
3754: -- Convert the values to ids

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

3797:
3798:
3799: -- Debug Message
3800: IF l_debug THEN
3801: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3802: 'Public API: ' || l_api_name || ' end');
3803:
3804: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3805: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

3800: IF l_debug THEN
3801: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3802: 'Public API: ' || l_api_name || ' end');
3803:
3804: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3805: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
3806:
3807: END IF;
3808:

Line 3810: FND_MSG_PUB.Count_And_Get

3806:
3807: END IF;
3808:
3809: -- Standard call to get message count and if count is 1, get message info.
3810: FND_MSG_PUB.Count_And_Get
3811: ( p_count => x_msg_count,
3812: p_data => x_msg_data
3813: );
3814:

Line 3821: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

3817: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3818: P_MODULE => l_module
3819: ,P_API_NAME => L_API_NAME
3820: ,P_PKG_NAME => G_PKG_NAME
3821: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3822: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3823: ,X_MSG_COUNT => X_MSG_COUNT
3824: ,X_MSG_DATA => X_MSG_DATA
3825: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 3832: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

3828: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3829: P_MODULE => l_module
3830: ,P_API_NAME => L_API_NAME
3831: ,P_PKG_NAME => G_PKG_NAME
3832: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3833: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3834: ,X_MSG_COUNT => X_MSG_COUNT
3835: ,X_MSG_DATA => X_MSG_DATA
3836: ,X_RETURN_STATUS => X_RETURN_STATUS);

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

3869: IS
3870: l_api_name CONSTANT VARCHAR2(30) := 'Update_contacts';
3871: l_api_version_number CONSTANT NUMBER := 2.0;
3872: l_contact_tbl Contact_Tbl_Type := p_contact_tbl;
3873: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
3874: l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Update_Contacts';
3875: BEGIN
3876: -- Standard Start of API savepoint
3877: SAVEPOINT UPDATE_CONTACTS_PUB;

Line 3892: FND_MSG_PUB.initialize;

3888:
3889: -- Initialize message list if p_init_msg_list is set to TRUE.
3890: IF FND_API.to_Boolean( p_init_msg_list )
3891: THEN
3892: FND_MSG_PUB.initialize;
3893: END IF;
3894:
3895:
3896: -- Debug Message

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

3894:
3895:
3896: -- Debug Message
3897: IF l_debug THEN
3898: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3899: 'Public API: ' || l_api_name || ' start');
3900:
3901: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3902: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

3897: IF l_debug THEN
3898: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3899: 'Public API: ' || l_api_name || ' start');
3900:
3901: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3902: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
3903:
3904: END IF;
3905:

Line 3916: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3912:
3913: /*****
3914: -- Debug Message
3915: IF l_debug THEN
3916: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3917: 'AS: Public API: Convert_Contact_Values_To_Ids');
3918: END IF;
3919:
3920:

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

3962:
3963:
3964: -- Debug Message
3965: IF l_debug THEN
3966: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3967: 'Public API: ' || l_api_name || ' end');
3968:
3969: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3970: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

3965: IF l_debug THEN
3966: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3967: 'Public API: ' || l_api_name || ' end');
3968:
3969: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3970: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
3971: END IF;
3972:
3973:

Line 3975: FND_MSG_PUB.Count_And_Get

3971: END IF;
3972:
3973:
3974: -- Standard call to get message count and if count is 1, get message info.
3975: FND_MSG_PUB.Count_And_Get
3976: ( p_count => x_msg_count,
3977: p_data => x_msg_data
3978: );
3979:

Line 3986: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

3982: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3983: P_MODULE => l_module
3984: ,P_API_NAME => L_API_NAME
3985: ,P_PKG_NAME => G_PKG_NAME
3986: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3987: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3988: ,X_MSG_COUNT => X_MSG_COUNT
3989: ,X_MSG_DATA => X_MSG_DATA
3990: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 3997: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

3993: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3994: P_MODULE => l_module
3995: ,P_API_NAME => L_API_NAME
3996: ,P_PKG_NAME => G_PKG_NAME
3997: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3998: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
3999: ,X_MSG_COUNT => X_MSG_COUNT
4000: ,X_MSG_DATA => X_MSG_DATA
4001: ,X_RETURN_STATUS => X_RETURN_STATUS);

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

4034: IS
4035: l_api_name CONSTANT VARCHAR2(30) := 'Delete_contacts';
4036: l_api_version_number CONSTANT NUMBER := 2.0;
4037: l_contact_tbl Contact_Tbl_Type := p_contact_tbl;
4038: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
4039: l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Delete_Contacts';
4040:
4041: BEGIN
4042: -- Standard Start of API savepoint

Line 4058: FND_MSG_PUB.initialize;

4054:
4055: -- Initialize message list if p_init_msg_list is set to TRUE.
4056: IF FND_API.to_Boolean( p_init_msg_list )
4057: THEN
4058: FND_MSG_PUB.initialize;
4059: END IF;
4060:
4061:
4062: -- Debug Message

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

4060:
4061:
4062: -- Debug Message
4063: IF l_debug THEN
4064: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4065: 'Public API: ' || l_api_name || ' start');
4066:
4067: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4068: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

4063: IF l_debug THEN
4064: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4065: 'Public API: ' || l_api_name || ' start');
4066:
4067: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4068: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
4069: END IF;
4070:
4071:

Line 4082: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

4078:
4079: /*****
4080: -- Debug Message
4081: IF l_debug THEN
4082: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4083: 'AS: Public API: Convert_Contact_Values_To_Ids');
4084: END IF;
4085:
4086:

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

4128:
4129:
4130: -- Debug Message
4131: IF l_debug THEN
4132: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4133: 'Public API: ' || l_api_name || ' end');
4134:
4135: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4136: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

4131: IF l_debug THEN
4132: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4133: 'Public API: ' || l_api_name || ' end');
4134:
4135: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4136: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
4137: END IF;
4138:
4139:

Line 4141: FND_MSG_PUB.Count_And_Get

4137: END IF;
4138:
4139:
4140: -- Standard call to get message count and if count is 1, get message info.
4141: FND_MSG_PUB.Count_And_Get
4142: ( p_count => x_msg_count,
4143: p_data => x_msg_data
4144: );
4145:

Line 4152: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

4148: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4149: P_MODULE => l_module
4150: ,P_API_NAME => L_API_NAME
4151: ,P_PKG_NAME => G_PKG_NAME
4152: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4153: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
4154: ,X_MSG_COUNT => X_MSG_COUNT
4155: ,X_MSG_DATA => X_MSG_DATA
4156: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 4163: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

4159: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4160: P_MODULE => l_module
4161: ,P_API_NAME => L_API_NAME
4162: ,P_PKG_NAME => G_PKG_NAME
4163: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4164: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
4165: ,X_MSG_COUNT => X_MSG_COUNT
4166: ,X_MSG_DATA => X_MSG_DATA
4167: ,X_RETURN_STATUS => X_RETURN_STATUS);

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

4200: IS
4201: l_api_name CONSTANT VARCHAR2(30) := 'Create_obstacles';
4202: l_api_version_number CONSTANT NUMBER := 2.0;
4203: l_obstacle_tbl Obstacle_Tbl_Type := p_obstacle_tbl;
4204: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
4205: l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Create_Obstacles';
4206: BEGIN
4207: -- Standard Start of API savepoint
4208: SAVEPOINT CREATE_OBSTACLES_PUB;

Line 4223: FND_MSG_PUB.initialize;

4219:
4220: -- Initialize message list if p_init_msg_list is set to TRUE.
4221: IF FND_API.to_Boolean( p_init_msg_list )
4222: THEN
4223: FND_MSG_PUB.initialize;
4224: END IF;
4225:
4226:
4227: -- Debug Message

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

4225:
4226:
4227: -- Debug Message
4228: IF l_debug THEN
4229: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4230: 'Public API: ' || l_api_name || ' start');
4231:
4232: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4233: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

4228: IF l_debug THEN
4229: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4230: 'Public API: ' || l_api_name || ' start');
4231:
4232: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4233: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
4234: END IF;
4235:
4236:

Line 4248: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

4244: /*****
4245:
4246: -- Debug Message
4247: IF l_debug THEN
4248: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4249: 'AS: Public API: Convert_Obstacle_Values_To_Ids');
4250:
4251: END IF;
4252:

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

4296:
4297:
4298: -- Debug Message
4299: IF l_debug THEN
4300: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4301: 'Public API: ' || l_api_name || ' end');
4302:
4303: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4304: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

4299: IF l_debug THEN
4300: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4301: 'Public API: ' || l_api_name || ' end');
4302:
4303: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4304: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
4305:
4306: END IF;
4307:

Line 4309: FND_MSG_PUB.Count_And_Get

4305:
4306: END IF;
4307:
4308: -- Standard call to get message count and if count is 1, get message info.
4309: FND_MSG_PUB.Count_And_Get
4310: ( p_count => x_msg_count,
4311: p_data => x_msg_data
4312: );
4313:

Line 4320: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

4316: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4317: P_MODULE => l_module
4318: ,P_API_NAME => L_API_NAME
4319: ,P_PKG_NAME => G_PKG_NAME
4320: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4321: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
4322: ,X_MSG_COUNT => X_MSG_COUNT
4323: ,X_MSG_DATA => X_MSG_DATA
4324: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 4331: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

4327: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4328: P_MODULE => l_module
4329: ,P_API_NAME => L_API_NAME
4330: ,P_PKG_NAME => G_PKG_NAME
4331: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4332: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
4333: ,X_MSG_COUNT => X_MSG_COUNT
4334: ,X_MSG_DATA => X_MSG_DATA
4335: ,X_RETURN_STATUS => X_RETURN_STATUS);

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

4369: IS
4370: l_api_name CONSTANT VARCHAR2(30) := 'Update_obstacles';
4371: l_api_version_number CONSTANT NUMBER := 2.0;
4372: l_obstacle_tbl Obstacle_Tbl_Type := p_obstacle_tbl;
4373: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
4374: l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Update_Obstacles';
4375: BEGIN
4376: -- Standard Start of API savepoint
4377: SAVEPOINT UPDATE_OBSTACLES_PUB;

Line 4392: FND_MSG_PUB.initialize;

4388:
4389: -- Initialize message list if p_init_msg_list is set to TRUE.
4390: IF FND_API.to_Boolean( p_init_msg_list )
4391: THEN
4392: FND_MSG_PUB.initialize;
4393: END IF;
4394:
4395:
4396: -- Debug Message

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

4394:
4395:
4396: -- Debug Message
4397: IF l_debug THEN
4398: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4399: 'Public API: ' || l_api_name || ' start');
4400:
4401: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4402: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

4397: IF l_debug THEN
4398: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4399: 'Public API: ' || l_api_name || ' start');
4400:
4401: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4402: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
4403:
4404: END IF;
4405:

Line 4416: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

4412:
4413: /*****
4414: -- Debug Message
4415: IF l_debug THEN
4416: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4417: 'AS: Public API: Convert_Obstacle_Values_To_Ids');
4418: END IF;
4419:
4420: -- Convert the values to ids

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

4462:
4463:
4464: -- Debug Message
4465: IF l_debug THEN
4466: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4467: 'Public API: ' || l_api_name || ' end');
4468:
4469: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4470: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

4465: IF l_debug THEN
4466: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4467: 'Public API: ' || l_api_name || ' end');
4468:
4469: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4470: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
4471: END IF;
4472:
4473:

Line 4475: FND_MSG_PUB.Count_And_Get

4471: END IF;
4472:
4473:
4474: -- Standard call to get message count and if count is 1, get message info.
4475: FND_MSG_PUB.Count_And_Get
4476: ( p_count => x_msg_count,
4477: p_data => x_msg_data
4478: );
4479:

Line 4486: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

4482: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4483: P_MODULE => l_module
4484: ,P_API_NAME => L_API_NAME
4485: ,P_PKG_NAME => G_PKG_NAME
4486: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4487: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
4488: ,X_MSG_COUNT => X_MSG_COUNT
4489: ,X_MSG_DATA => X_MSG_DATA
4490: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 4497: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

4493: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4494: P_MODULE => l_module
4495: ,P_API_NAME => L_API_NAME
4496: ,P_PKG_NAME => G_PKG_NAME
4497: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4498: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
4499: ,X_MSG_COUNT => X_MSG_COUNT
4500: ,X_MSG_DATA => X_MSG_DATA
4501: ,X_RETURN_STATUS => X_RETURN_STATUS);

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

4534: IS
4535: l_api_name CONSTANT VARCHAR2(30) := 'Delete_obstacles';
4536: l_api_version_number CONSTANT NUMBER := 2.0;
4537: l_obstacle_tbl Obstacle_Tbl_Type := p_obstacle_tbl;
4538: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
4539: l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Delete_Obstacles';
4540: BEGIN
4541: -- Standard Start of API savepoint
4542: SAVEPOINT DELETE_OBSTACLES_PUB;

Line 4557: FND_MSG_PUB.initialize;

4553:
4554: -- Initialize message list if p_init_msg_list is set to TRUE.
4555: IF FND_API.to_Boolean( p_init_msg_list )
4556: THEN
4557: FND_MSG_PUB.initialize;
4558: END IF;
4559:
4560:
4561: -- Debug Message

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

4559:
4560:
4561: -- Debug Message
4562: IF l_debug THEN
4563: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4564: 'Public API: ' || l_api_name || ' start');
4565:
4566: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4567: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

4562: IF l_debug THEN
4563: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4564: 'Public API: ' || l_api_name || ' start');
4565:
4566: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4567: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
4568:
4569: END IF;
4570:

Line 4582: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

4578: /*****
4579:
4580: -- Debug Message
4581: IF l_debug THEN
4582: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4583: 'AS: Public API: Convert_Obstacle_Values_To_Ids');
4584:
4585: END IF;
4586:

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

4628:
4629:
4630: -- Debug Message
4631: IF l_debug THEN
4632: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4633: 'Public API: ' || l_api_name || ' end');
4634:
4635: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4636: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

4631: IF l_debug THEN
4632: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4633: 'Public API: ' || l_api_name || ' end');
4634:
4635: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4636: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
4637: END IF;
4638:
4639:

Line 4641: FND_MSG_PUB.Count_And_Get

4637: END IF;
4638:
4639:
4640: -- Standard call to get message count and if count is 1, get message info.
4641: FND_MSG_PUB.Count_And_Get
4642: ( p_count => x_msg_count,
4643: p_data => x_msg_data
4644: );
4645:

Line 4652: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

4648: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4649: P_MODULE => l_module
4650: ,P_API_NAME => L_API_NAME
4651: ,P_PKG_NAME => G_PKG_NAME
4652: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4653: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
4654: ,X_MSG_COUNT => X_MSG_COUNT
4655: ,X_MSG_DATA => X_MSG_DATA
4656: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 4663: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

4659: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4660: P_MODULE => l_module
4661: ,P_API_NAME => L_API_NAME
4662: ,P_PKG_NAME => G_PKG_NAME
4663: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4664: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
4665: ,X_MSG_COUNT => X_MSG_COUNT
4666: ,X_MSG_DATA => X_MSG_DATA
4667: ,X_RETURN_STATUS => X_RETURN_STATUS);

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

4727: l_api_version_number CONSTANT NUMBER := 2.0;
4728: l_sales_team_rec AS_ACCESS_PUB.Sales_Team_Rec_Type;
4729: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;
4730: l_line_count CONSTANT NUMBER := p_sales_team_tbl.count;
4731: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
4732: l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Delete_SalesTeams';
4733: BEGIN
4734: -- Standard Start of API savepoint
4735: SAVEPOINT DELETE_SALESTEAMS_PUB;

Line 4750: FND_MSG_PUB.initialize;

4746:
4747: -- Initialize message list if p_init_msg_list is set to TRUE.
4748: IF FND_API.to_Boolean( p_init_msg_list )
4749: THEN
4750: FND_MSG_PUB.initialize;
4751: END IF;
4752:
4753:
4754: -- Debug Message

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

4752:
4753:
4754: -- Debug Message
4755: IF l_debug THEN
4756: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4757: 'Public API: ' || l_api_name || ' start');
4758:
4759: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4760: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

4755: IF l_debug THEN
4756: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4757: 'Public API: ' || l_api_name || ' start');
4758:
4759: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4760: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
4761:
4762: END IF;
4763:

Line 4798: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'sales group id: '||l_sales_group_id );

4794: l_lead_id := l_sales_team_rec.lead_id;
4795: l_sales_group_id := l_sales_team_rec.sales_group_id;
4796: END IF;
4797: IF l_debug THEN
4798: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'sales group id: '||l_sales_group_id );
4799: END IF;
4800:
4801:
4802: OPEN C_SalesCredit_Exist (l_salesforce_id,l_lead_id, l_sales_group_id);

Line 4830: --IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

4826: OPEN C_GetPersonName(l_sales_team_rec.person_id);
4827: FETCH C_GetPersonName INTO l_person_name;
4828: CLOSE C_GetPersonName;
4829:
4830: --IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
4831: --THEN
4832: -- FND_MESSAGE.Set_Name('AS', 'AS_DELETE_SALESTEAM_NOTALLOWED');
4833: -- FND_MESSAGE.Set_Token ('salesrep', l_person_name, FALSE);
4834: -- FND_MSG_PUB.Add;

Line 4834: -- FND_MSG_PUB.Add;

4830: --IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
4831: --THEN
4832: -- FND_MESSAGE.Set_Name('AS', 'AS_DELETE_SALESTEAM_NOTALLOWED');
4833: -- FND_MESSAGE.Set_Token ('salesrep', l_person_name, FALSE);
4834: -- FND_MSG_PUB.Add;
4835: -- END IF;
4836:
4837: AS_UTILITY_PVT.Set_Message(l_module,
4838: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 4838: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

4834: -- FND_MSG_PUB.Add;
4835: -- END IF;
4836:
4837: AS_UTILITY_PVT.Set_Message(l_module,
4838: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
4839: p_msg_name => 'AS_DELETE_SALESTEAM_NOTALLOWED',
4840: p_token1 => 'SALESREP',
4841: p_token1_value => l_person_name );
4842:

Line 4846: FND_MSG_PUB.Count_And_Get(

4842:
4843:
4844: x_return_status := FND_API.G_RET_STS_ERROR;
4845:
4846: FND_MSG_PUB.Count_And_Get(
4847: p_count => x_msg_count,
4848: p_data => x_msg_data
4849: );
4850:

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

4877:
4878:
4879: -- Debug Message
4880: IF l_debug THEN
4881: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4882: 'Public API: ' || l_api_name || ' end');
4883:
4884: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4885: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

4880: IF l_debug THEN
4881: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4882: 'Public API: ' || l_api_name || ' end');
4883:
4884: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4885: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
4886:
4887: END IF;
4888:

Line 4890: FND_MSG_PUB.Count_And_Get

4886:
4887: END IF;
4888:
4889: -- Standard call to get message count and if count is 1, get message info.
4890: FND_MSG_PUB.Count_And_Get
4891: ( p_count => x_msg_count,
4892: p_data => x_msg_data
4893: );
4894:

Line 4902: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

4898: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4899: P_MODULE => l_module
4900: ,P_API_NAME => L_API_NAME
4901: ,P_PKG_NAME => G_PKG_NAME
4902: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4903: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
4904: ,X_MSG_COUNT => X_MSG_COUNT
4905: ,X_MSG_DATA => X_MSG_DATA
4906: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 4913: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

4909: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
4910: P_MODULE => l_module
4911: ,P_API_NAME => L_API_NAME
4912: ,P_PKG_NAME => G_PKG_NAME
4913: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4914: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
4915: ,X_MSG_COUNT => X_MSG_COUNT
4916: ,X_MSG_DATA => X_MSG_DATA
4917: ,X_RETURN_STATUS => X_RETURN_STATUS);

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

4969: )
4970: IS
4971: l_api_name CONSTANT VARCHAR2(30) := 'Copy_Opportunity';
4972: l_api_version_number CONSTANT NUMBER := 2.0;
4973: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
4974: l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Copy_Opportunity';
4975:
4976: BEGIN
4977: -- Standard Start of API savepoint

Line 4993: FND_MSG_PUB.initialize;

4989:
4990: -- Initialize message list if p_init_msg_list is set to TRUE.
4991: IF FND_API.to_Boolean( p_init_msg_list )
4992: THEN
4993: FND_MSG_PUB.initialize;
4994: END IF;
4995:
4996:
4997: -- Debug Message

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

4996:
4997: -- Debug Message
4998:
4999: IF l_debug THEN
5000: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5001: 'Public API: ' || l_api_name || ' start');
5002:
5003: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5004: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

4999: IF l_debug THEN
5000: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5001: 'Public API: ' || l_api_name || ' start');
5002:
5003: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5004: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
5005:
5006: END IF;
5007:

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

5060:
5061:
5062: -- Debug Message
5063: IF l_debug THEN
5064: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5065: 'Public API: ' || l_api_name || ' end');
5066:
5067: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5068: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

5063: IF l_debug THEN
5064: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5065: 'Public API: ' || l_api_name || ' end');
5066:
5067: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5068: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
5069: END IF;
5070:
5071: -- Standard call to get message count and if count is 1, get message info.

Line 5072: FND_MSG_PUB.Count_And_Get

5068: 'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
5069: END IF;
5070:
5071: -- Standard call to get message count and if count is 1, get message info.
5072: FND_MSG_PUB.Count_And_Get
5073: ( p_count => x_msg_count,
5074: p_data => x_msg_data
5075: );
5076:

Line 5083: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

5079: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
5080: P_MODULE => l_module
5081: ,P_API_NAME => L_API_NAME
5082: ,P_PKG_NAME => G_PKG_NAME
5083: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
5084: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
5085: ,X_MSG_COUNT => X_MSG_COUNT
5086: ,X_MSG_DATA => X_MSG_DATA
5087: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 5094: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

5090: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
5091: P_MODULE => l_module
5092: ,P_API_NAME => L_API_NAME
5093: ,P_PKG_NAME => G_PKG_NAME
5094: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
5095: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
5096: ,X_MSG_COUNT => X_MSG_COUNT
5097: ,X_MSG_DATA => X_MSG_DATA
5098: ,X_RETURN_STATUS => X_RETURN_STATUS);