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

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

110: L_Access_Flag VARCHAR2(1);
111:
112: l_opp_won BOOLEAN := Opp_Won(P_Competitor_Prod_Tbl(1).LEAD_ID);
113: l_loop_count NUMBER := 1;
114: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
115: l_module CONSTANT VARCHAR2(255) := 'as.plsql.cpdpv.Create_competitor_prods';
116:
117:
118: BEGIN

Line 135: FND_MSG_PUB.initialize;

131:
132: -- Initialize message list if p_init_msg_list is set to TRUE.
133: IF FND_API.to_Boolean( p_init_msg_list )
134: THEN
135: FND_MSG_PUB.initialize;
136: END IF;
137:
138:
139: -- Debug Message

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

137:
138:
139: -- Debug Message
140: IF l_debug THEN
141: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
142: 'Private API: ' || l_api_name || ' start');
143: END IF;
144:
145: -- Initialize API return status to SUCCESS

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

174: -- Validate Environment
175: -- ******************************************************************
176: IF FND_GLOBAL.User_Id IS NULL
177: THEN
178: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
179: THEN
180: FND_MESSAGE.Set_Name(' + appShortName +',
181: 'UT_CANNOT_GET_PROFILE_VALUE');
182: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);

Line 183: FND_MSG_PUB.ADD;

179: THEN
180: FND_MESSAGE.Set_Name(' + appShortName +',
181: 'UT_CANNOT_GET_PROFILE_VALUE');
182: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
183: FND_MSG_PUB.ADD;
184: END IF;
185: RAISE FND_API.G_EXC_ERROR;
186: END IF;
187:

Line 231: AS_UTILITY_PVT.Set_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,

227: x_msg_data => x_msg_data,
228: x_update_access_flag => l_access_flag);
229:
230: IF l_access_flag <> 'Y' THEN
231: AS_UTILITY_PVT.Set_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
232: 'API_NO_UPDATE_PRIVILEGE');
233: END IF;
234:
235: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

242: FND_API.G_RET_STS_SUCCESS ;
243:
244: -- Progress Message
245: --
246: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
247: THEN
248: FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
249: FND_MESSAGE.Set_Token ('ROW', 'AS_LEAD_COMP_PRODUCTS', TRUE);
250: FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(l_curr_row), FALSE);

Line 251: FND_MSG_PUB.Add;

247: THEN
248: FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
249: FND_MESSAGE.Set_Token ('ROW', 'AS_LEAD_COMP_PRODUCTS', TRUE);
250: FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(l_curr_row), FALSE);
251: FND_MSG_PUB.Add;
252: END IF;
253:
254: l_competitor_prod_rec := P_Competitor_Prod_Tbl(l_curr_row);
255:

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

267: IF ( p_validation_level >= FND_API.G_VALID_LEVEL_FULL )
268: THEN
269: -- Debug message
270: IF l_debug THEN
271: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
272: 'Private API: Validate_competitor_prod');
273:
274: END IF;
275:

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

289: RAISE FND_API.G_EXC_ERROR;
290: END IF;
291: /*
292: IF check_dup( p_Competitor_Prod_rec => l_Competitor_Prod_rec ) THEN
293: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
294: THEN
295: FND_MESSAGE.Set_Name('AS', 'API_DUP_COMPETITOR_PRODUCTS');
296: FND_MSG_PUB.ADD;
297: END IF;

Line 296: FND_MSG_PUB.ADD;

292: IF check_dup( p_Competitor_Prod_rec => l_Competitor_Prod_rec ) THEN
293: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
294: THEN
295: FND_MESSAGE.Set_Name('AS', 'API_DUP_COMPETITOR_PRODUCTS');
296: FND_MSG_PUB.ADD;
297: END IF;
298: RAISE FND_API.G_EXC_ERROR;
299: END IF;
300: */

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

299: END IF;
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: 'Private API: Calling create table handler');
305:
306: END IF;
307:

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

375:
376:
377: -- Debug Message
378: IF l_debug THEN
379: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
380: 'Private API: ' || l_api_name || ' end');
381: END IF;
382:
383:

Line 385: FND_MSG_PUB.Count_And_Get

381: END IF;
382:
383:
384: -- Standard call to get message count and if count is 1, get message info.
385: FND_MSG_PUB.Count_And_Get
386: ( p_count => x_msg_count,
387: p_data => x_msg_data
388: );
389:

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

408: */
409: EXCEPTION
410:
411: WHEN DUP_VAL_ON_INDEX THEN
412: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
413: THEN
414: FND_MESSAGE.Set_Name('AS', 'API_DUP_COMPETITOR_PRODUCTS');
415: FND_MSG_PUB.ADD;
416: END IF;

Line 415: FND_MSG_PUB.ADD;

411: WHEN DUP_VAL_ON_INDEX THEN
412: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
413: THEN
414: FND_MESSAGE.Set_Name('AS', 'API_DUP_COMPETITOR_PRODUCTS');
415: FND_MSG_PUB.ADD;
416: END IF;
417:
418: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
419: P_MODULE => l_module

Line 422: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

418: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
419: P_MODULE => l_module
420: ,P_API_NAME => L_API_NAME
421: ,P_PKG_NAME => G_PKG_NAME
422: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
423: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
424: ,X_MSG_COUNT => X_MSG_COUNT
425: ,X_MSG_DATA => X_MSG_DATA
426: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 433: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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

Line 444: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

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

496: L_Last_Update_Date DATE;
497: L_Access_Flag VARCHAR2(1);
498:
499: l_opp_won BOOLEAN := Opp_Won(P_Competitor_Prod_Tbl(1).LEAD_ID);
500: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
501: l_module CONSTANT VARCHAR2(255) := 'as.plsql.cpdpv.Update_competitor_prods';
502:
503: BEGIN
504: -- Standard Start of API savepoint

Line 520: FND_MSG_PUB.initialize;

516:
517: -- Initialize message list if p_init_msg_list is set to TRUE.
518: IF FND_API.to_Boolean( p_init_msg_list )
519: THEN
520: FND_MSG_PUB.initialize;
521: END IF;
522:
523:
524: -- Debug Message

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

522:
523:
524: -- Debug Message
525: IF l_debug THEN
526: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
527: 'Private API: ' || l_api_name || ' start');
528: END IF;
529:
530:

Line 604: AS_UTILITY_PVT.Set_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,

600: x_msg_data => x_msg_data,
601: x_update_access_flag => l_access_flag);
602:
603: IF l_access_flag <> 'Y' THEN
604: AS_UTILITY_PVT.Set_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
605: 'API_NO_UPDATE_PRIVILEGE');
606: END IF;
607:
608: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

614: X_competitor_prod_out_tbl(l_curr_row).return_status :=
615: FND_API.G_RET_STS_SUCCESS ;
616: -- Progress Message
617: --
618: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
619: THEN
620: FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
621: FND_MESSAGE.Set_Token ('ROW', 'AS_LEAD_COMP_PRODUCTS', TRUE);
622: FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(l_curr_row), FALSE);

Line 623: FND_MSG_PUB.Add;

619: THEN
620: FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
621: FND_MESSAGE.Set_Token ('ROW', 'AS_LEAD_COMP_PRODUCTS', TRUE);
622: FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(l_curr_row), FALSE);
623: FND_MSG_PUB.Add;
624: END IF;
625:
626: l_competitor_prod_rec := P_Competitor_Prod_Tbl(l_curr_row);
627:

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

626: l_competitor_prod_rec := P_Competitor_Prod_Tbl(l_curr_row);
627:
628: -- Debug Message
629: IF l_debug THEN
630: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
631: 'Private API: - Open Cursor to Select');
632:
633: END IF;
634:

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

636:
637: Fetch C_Get_competitor_prod into l_last_update_date;
638:
639: If ( C_Get_competitor_prod%NOTFOUND) Then
640: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
641: THEN
642: FND_MESSAGE.Set_Name('AS', 'API_MISSING_UPDATE_TARGET');
643: FND_MESSAGE.Set_Token ('INFO', 'competitor_prod', FALSE);
644: FND_MSG_PUB.Add;

Line 644: FND_MSG_PUB.Add;

640: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
641: THEN
642: FND_MESSAGE.Set_Name('AS', 'API_MISSING_UPDATE_TARGET');
643: FND_MESSAGE.Set_Token ('INFO', 'competitor_prod', FALSE);
644: FND_MSG_PUB.Add;
645: END IF;
646: raise FND_API.G_EXC_ERROR;
647: END IF;
648: -- Debug Message

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

646: raise FND_API.G_EXC_ERROR;
647: END IF;
648: -- Debug Message
649: IF l_debug THEN
650: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
651: 'Private API: - Close Cursor');
652: END IF;
653:
654: Close C_Get_competitor_prod;

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

654: Close C_Get_competitor_prod;
655:
656: If (l_Competitor_Prod_rec.last_update_date is NULL or
657: l_Competitor_Prod_rec.last_update_date = FND_API.G_MISS_Date ) Then
658: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
659: THEN
660: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
661: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
662: FND_MSG_PUB.ADD;

Line 662: FND_MSG_PUB.ADD;

658: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
659: THEN
660: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
661: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
662: FND_MSG_PUB.ADD;
663: END IF;
664: raise FND_API.G_EXC_ERROR;
665: End if;
666: -- Check Whether record has been changed by someone else

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

664: raise FND_API.G_EXC_ERROR;
665: End if;
666: -- Check Whether record has been changed by someone else
667: If (l_Competitor_Prod_rec.last_update_date <> l_last_update_date) Then
668: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
669: THEN
670: FND_MESSAGE.Set_Name('AS', 'API_RECORD_CHANGED');
671: FND_MESSAGE.Set_Token('INFO', 'competitor_prod', FALSE);
672: FND_MSG_PUB.ADD;

Line 672: FND_MSG_PUB.ADD;

668: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
669: THEN
670: FND_MESSAGE.Set_Name('AS', 'API_RECORD_CHANGED');
671: FND_MESSAGE.Set_Token('INFO', 'competitor_prod', FALSE);
672: FND_MSG_PUB.ADD;
673: END IF;
674: raise FND_API.G_EXC_ERROR;
675: End if;
676:

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

682: IF ( p_validation_level >= FND_API.G_VALID_LEVEL_FULL )
683: THEN
684: -- Debug message
685: IF l_debug THEN
686: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
687: 'Private API: Validate_competitor_prod');
688: END IF;
689:
690: -- Invoke validation procedures

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

702: RAISE FND_API.G_EXC_ERROR;
703: END IF;
704: /*
705: IF check_dup( p_Competitor_Prod_rec => l_Competitor_Prod_rec ) THEN
706: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
707: THEN
708: FND_MESSAGE.Set_Name('AS', 'API_DUP_COMPETITOR_PRODUCTS');
709: FND_MSG_PUB.ADD;
710: END IF;

Line 709: FND_MSG_PUB.ADD;

705: IF check_dup( p_Competitor_Prod_rec => l_Competitor_Prod_rec ) THEN
706: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
707: THEN
708: FND_MESSAGE.Set_Name('AS', 'API_DUP_COMPETITOR_PRODUCTS');
709: FND_MSG_PUB.ADD;
710: END IF;
711: RAISE FND_API.G_EXC_ERROR;
712: END IF;
713: */

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

712: END IF;
713: */
714: -- Debug Message
715: IF l_debug THEN
716: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
717: 'Private API: Calling update table handler');
718: END IF;
719:
720:

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

774:
775:
776: -- Debug Message
777: IF l_debug THEN
778: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
779: 'Private API: ' || l_api_name || ' end');
780: END IF;
781:
782:

Line 785: FND_MSG_PUB.Count_And_Get

781:
782:
783:
784: -- Standard call to get message count and if count is 1, get message info.
785: FND_MSG_PUB.Count_And_Get
786: ( p_count => x_msg_count,
787: p_data => x_msg_data
788: );
789:

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

809: */
810: EXCEPTION
811:
812: WHEN DUP_VAL_ON_INDEX THEN
813: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
814: THEN
815: FND_MESSAGE.Set_Name('AS', 'API_DUP_COMPETITOR_PRODUCTS');
816: FND_MSG_PUB.ADD;
817: END IF;

Line 816: FND_MSG_PUB.ADD;

812: WHEN DUP_VAL_ON_INDEX THEN
813: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
814: THEN
815: FND_MESSAGE.Set_Name('AS', 'API_DUP_COMPETITOR_PRODUCTS');
816: FND_MSG_PUB.ADD;
817: END IF;
818:
819: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
820: P_MODULE => l_module

Line 823: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

819: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
820: P_MODULE => l_module
821: ,P_API_NAME => L_API_NAME
822: ,P_PKG_NAME => G_PKG_NAME
823: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
824: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
825: ,X_MSG_COUNT => X_MSG_COUNT
826: ,X_MSG_DATA => X_MSG_DATA
827: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 834: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

830: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
831: P_MODULE => l_module
832: ,P_API_NAME => L_API_NAME
833: ,P_PKG_NAME => G_PKG_NAME
834: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
835: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
836: ,X_MSG_COUNT => X_MSG_COUNT
837: ,X_MSG_DATA => X_MSG_DATA
838: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 845: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

841: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
842: P_MODULE => l_module
843: ,P_API_NAME => L_API_NAME
844: ,P_PKG_NAME => G_PKG_NAME
845: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
846: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
847: ,X_MSG_COUNT => X_MSG_COUNT
848: ,X_MSG_DATA => X_MSG_DATA
849: ,X_RETURN_STATUS => X_RETURN_STATUS);

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

891: L_Lead_Competitor_Prod_Id NUMBER;
892: L_Line_Count CONSTANT NUMBER := P_Competitor_Prod_Tbl.count;
893: L_Access_Profile_Rec AS_ACCESS_PUB.ACCESS_PROFILE_REC_TYPE;
894: L_Access_Flag VARCHAR2(1);
895: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
896: l_module CONSTANT VARCHAR2(255) := 'as.plsql.cpdpv.Delete_competitor_prods';
897:
898: BEGIN
899: -- Standard Start of API savepoint

Line 915: FND_MSG_PUB.initialize;

911:
912: -- Initialize message list if p_init_msg_list is set to TRUE.
913: IF FND_API.to_Boolean( p_init_msg_list )
914: THEN
915: FND_MSG_PUB.initialize;
916: END IF;
917:
918:
919: -- Debug Message

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

917:
918:
919: -- Debug Message
920: IF l_debug THEN
921: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
922: 'Private API: ' || l_api_name || ' start');
923: END IF;
924:
925:

Line 996: AS_UTILITY_PVT.Set_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,

992: x_update_access_flag => l_access_flag);
993: END IF;
994:
995: IF l_access_flag <> 'Y' THEN
996: AS_UTILITY_PVT.Set_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
997: 'API_NO_UPDATE_PRIVILEGE');
998: END IF;
999:
1000: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

1006: FND_API.G_RET_STS_SUCCESS ;
1007:
1008: -- Progress Message
1009: --
1010: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1011: THEN
1012: FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
1013: FND_MESSAGE.Set_Token ('ROW', 'AS_LEAD_COMP_PRODUCTS', TRUE);
1014: FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(l_curr_row), FALSE);

Line 1015: FND_MSG_PUB.Add;

1011: THEN
1012: FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
1013: FND_MESSAGE.Set_Token ('ROW', 'AS_LEAD_COMP_PRODUCTS', TRUE);
1014: FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(l_curr_row), FALSE);
1015: FND_MSG_PUB.Add;
1016: END IF;
1017:
1018: l_competitor_prod_rec := P_Competitor_Prod_Tbl(l_curr_row);
1019:

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

1018: l_competitor_prod_rec := P_Competitor_Prod_Tbl(l_curr_row);
1019:
1020: -- Debug Message
1021: IF l_debug THEN
1022: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1023: 'Private API: Calling delete table handler');
1024: END IF;
1025:
1026:

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

1050:
1051:
1052: -- Debug Message
1053: IF l_debug THEN
1054: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1055: 'Private API: ' || l_api_name || ' end');
1056: END IF;
1057:
1058:

Line 1060: FND_MSG_PUB.Count_And_Get

1056: END IF;
1057:
1058:
1059: -- Standard call to get message count and if count is 1, get message info.
1060: FND_MSG_PUB.Count_And_Get
1061: ( p_count => x_msg_count,
1062: p_data => x_msg_data
1063: );
1064:

Line 1090: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1086: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1087: P_MODULE => l_module
1088: ,P_API_NAME => L_API_NAME
1089: ,P_PKG_NAME => G_PKG_NAME
1090: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1091: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1092: ,X_MSG_COUNT => X_MSG_COUNT
1093: ,X_MSG_DATA => X_MSG_DATA
1094: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1101: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1097: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1098: P_MODULE => l_module
1099: ,P_API_NAME => L_API_NAME
1100: ,P_PKG_NAME => G_PKG_NAME
1101: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1102: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1103: ,X_MSG_COUNT => X_MSG_COUNT
1104: ,X_MSG_DATA => X_MSG_DATA
1105: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1135: FND_MSG_PUB.initialize;

1131:
1132: -- Initialize message list if p_init_msg_list is set to TRUE.
1133: IF FND_API.to_Boolean( p_init_msg_list )
1134: THEN
1135: FND_MSG_PUB.initialize;
1136: END IF;
1137:
1138:
1139: -- Initialize API return status to SUCCESS

Line 1159: FND_MSG_PUB.Count_And_Get

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

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

1180: FROM as_lookups
1181: WHERE lookup_type = c_lookup_type
1182: and lookup_code = c_Lookup_Code;
1183: l_val VARCHAR2(1);
1184: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
1185: l_module CONSTANT VARCHAR2(255) := 'as.plsql.cpdpv.Validate_WIN_LOSS_STATUS';
1186:
1187: BEGIN
1188:

Line 1192: FND_MSG_PUB.initialize;

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

Line 1208: -- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,

1204: p_WIN_LOSS_STATUS);
1205: FETCH C_WIN_LOSS_STATUS_Exists into l_val;
1206:
1207: IF C_WIN_LOSS_STATUS_Exists%NOTFOUND THEN
1208: -- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,
1209: -- 'Private API: WIN_LOSS_STATUS is invalid');
1210:
1211: AS_UTILITY_PVT.Set_Message(
1212: p_module => l_module,

Line 1213: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1209: -- 'Private API: WIN_LOSS_STATUS is invalid');
1210:
1211: AS_UTILITY_PVT.Set_Message(
1212: p_module => l_module,
1213: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1214: p_msg_name => 'API_INVALID_WIN_LOSS_STATUS',
1215: p_token1 => 'VALUE',
1216: p_token1_value => p_WIN_LOSS_STATUS );
1217:

Line 1225: FND_MSG_PUB.Count_And_Get

1221: CLOSE C_WIN_LOSS_STATUS_Exists;
1222: END IF;
1223:
1224: -- Standard call to get message count and if count is 1, get message info.
1225: FND_MSG_PUB.Count_And_Get
1226: ( p_count => x_msg_count,
1227: p_data => x_msg_data
1228: );
1229:

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

1246: from ams_competitor_products_b
1247: where competitor_product_id = c_COMPETITOR_PRODUCT_ID;
1248: */
1249: l_val VARCHAR2(1);
1250: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
1251: l_module CONSTANT VARCHAR2(255) := 'as.plsql.cpdpv.Validate_COMPETITOR_PRODUCT_ID';
1252:
1253: BEGIN
1254: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1257: FND_MSG_PUB.initialize;

1253: BEGIN
1254: -- Initialize message list if p_init_msg_list is set to TRUE.
1255: IF FND_API.to_Boolean( p_init_msg_list )
1256: THEN
1257: FND_MSG_PUB.initialize;
1258: END IF;
1259:
1260:
1261: -- Initialize API return status to SUCCESS

Line 1269: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1265: (p_COMPETITOR_PRODUCT_ID = FND_API.G_MISS_NUM)
1266: THEN
1267: AS_UTILITY_PVT.Set_Message(
1268: p_module => l_module,
1269: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1270: p_msg_name => 'API_MISSING_COMPETITOR_PRODUCT_ID');
1271:
1272: x_return_status := FND_API.G_RET_STS_ERROR;
1273: ELSE

Line 1280: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,

1276: OPEN c_competitor_product_exists(p_COMPETITOR_PRODUCT_ID);
1277: FETCH c_competitor_product_exists into l_val;
1278: IF c_competitor_product_exists%NOTFOUND THEN
1279: IF l_debug THEN
1280: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,
1281: 'Private API: COMPETITOR_PRODUCT_ID is invalid');
1282: END IF;
1283:
1284: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1291: FND_MSG_PUB.Count_And_Get

1287: */
1288: END IF;
1289:
1290: -- Standard call to get message count and if count is 1, get message info.
1291: FND_MSG_PUB.Count_And_Get
1292: ( p_count => x_msg_count,
1293: p_data => x_msg_data
1294: );
1295:

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

1313:
1314:
1315:
1316: l_val VARCHAR2(1);
1317: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
1318: l_module CONSTANT VARCHAR2(255) := 'as.plsql.cpdpv.Validate_LEAD_LINE_ID';
1319:
1320: BEGIN
1321:

Line 1325: FND_MSG_PUB.initialize;

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

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

1332:
1333: IF (p_LEAD_LINE_ID is NULL) or (p_LEAD_LINE_ID = FND_API.G_MISS_NUM)
1334: THEN
1335: IF l_debug THEN
1336: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1337: 'Private API 38: Violate NOT NULL constraint(LEAD_LINE_ID)');
1338: END IF;
1339:
1340: x_return_status := FND_API.G_RET_STS_ERROR;

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

1343: FETCH C_Lead_Line_Id_Exists into l_val;
1344: IF C_Lead_Line_Id_Exists%NOTFOUND
1345: THEN
1346: IF l_debug THEN
1347: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1348: 'Private API 39: LEAD_LINE_ID is not valid');
1349: END IF;
1350: x_return_status := FND_API.G_RET_STS_ERROR;
1351: END IF;

Line 1356: FND_MSG_PUB.Count_And_Get

1352: CLOSE C_Lead_Line_Id_Exists;
1353: END IF;
1354:
1355: -- Standard call to get message count and if count is 1, get message info.
1356: FND_MSG_PUB.Count_And_Get
1357: ( p_count => x_msg_count,
1358: p_data => x_msg_data
1359: );
1360:

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

1377: FROM as_leads
1378: WHERE lead_id = c_Lead_Id;
1379:
1380: l_val VARCHAR2(1);
1381: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
1382: l_module CONSTANT VARCHAR2(255) := 'as.plsql.cpdpv.Validate_LEAD_ID';
1383:
1384: BEGIN
1385:

Line 1389: FND_MSG_PUB.initialize;

1385:
1386: -- Initialize message list if p_init_msg_list is set to TRUE.
1387: IF FND_API.to_Boolean( p_init_msg_list )
1388: THEN
1389: FND_MSG_PUB.initialize;
1390: END IF;
1391:
1392:
1393: -- Initialize API return status to SUCCESS

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

1396:
1397: IF (p_LEAD_ID is NULL) or (p_LEAD_ID = FND_API.G_MISS_NUM)
1398: THEN
1399: IF l_debug THEN
1400: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1401: 'Private API 36: Violate NOT NULL constraint(LEAD_ID)');
1402: END IF;
1403:
1404: x_return_status := FND_API.G_RET_STS_ERROR;

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

1407: FETCH C_Lead_Id_Exists into l_val;
1408: IF C_Lead_Id_Exists%NOTFOUND
1409: THEN
1410: IF l_debug THEN
1411: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1412: 'Private API 37: LEAD_ID is not valid');
1413: END IF;
1414:
1415: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1421: FND_MSG_PUB.Count_And_Get

1417: CLOSE C_Lead_Id_Exists;
1418: END IF;
1419:
1420: -- Standard call to get message count and if count is 1, get message info.
1421: FND_MSG_PUB.Count_And_Get
1422: ( p_count => x_msg_count,
1423: p_data => x_msg_data
1424: );
1425:

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

1440: FROM as_lead_comp_products
1441: WHERE lead_competitor_prod_id = c_Lead_Competitor_Prod_Id;
1442:
1443: l_val VARCHAR2(1);
1444: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
1445: l_module CONSTANT VARCHAR2(255) := 'as.plsql.cpdpv.Validate_L_COMPETITOR_PROD_ID';
1446:
1447: BEGIN
1448: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1451: FND_MSG_PUB.initialize;

1447: BEGIN
1448: -- Initialize message list if p_init_msg_list is set to TRUE.
1449: IF FND_API.to_Boolean( p_init_msg_list )
1450: THEN
1451: FND_MSG_PUB.initialize;
1452: END IF;
1453:
1454: -- Initialize API return status to SUCCESS
1455: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1466: -- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,

1462: OPEN C_Lead_CProd_Id_Exists (p_Lead_Competitor_Prod_Id);
1463: FETCH C_Lead_CProd_Id_Exists into l_val;
1464:
1465: IF C_Lead_CProd_Id_Exists%FOUND THEN
1466: -- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,
1467: -- 'Private API: LEAD_COMPETITOR_PROD_ID exist');
1468:
1469: AS_UTILITY_PVT.Set_Message(
1470: p_module => l_module,

Line 1471: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1467: -- 'Private API: LEAD_COMPETITOR_PROD_ID exist');
1468:
1469: AS_UTILITY_PVT.Set_Message(
1470: p_module => l_module,
1471: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1472: p_msg_name => 'API_DUPLICATE_LEAD_CPROD_ID',
1473: p_token1 => 'VALUE',
1474: p_token1_value => p_LEAD_COMPETITOR_PROD_ID );
1475:

Line 1488: -- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,

1484: THEN
1485: -- validate NOT NULL column
1486: IF (p_LEAD_COMPETITOR_PROD_ID is NULL) or (p_LEAD_COMPETITOR_PROD_ID = FND_API.G_MISS_NUM)
1487: THEN
1488: -- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,
1489: -- 'Private API: Violate NOT NULL constraint(LEAD_COMPETITOR_PROD_ID)');
1490:
1491: AS_UTILITY_PVT.Set_Message(
1492: p_module => l_module,

Line 1493: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1489: -- 'Private API: Violate NOT NULL constraint(LEAD_COMPETITOR_PROD_ID)');
1490:
1491: AS_UTILITY_PVT.Set_Message(
1492: p_module => l_module,
1493: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1494: p_msg_name => 'API_MISSING_LEAD_CPROD_ID');
1495:
1496: x_return_status := FND_API.G_RET_STS_ERROR;
1497: ELSE

Line 1503: -- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,

1499: FETCH C_Lead_CProd_Id_Exists into l_val;
1500:
1501: IF C_Lead_CProd_Id_Exists%NOTFOUND
1502: THEN
1503: -- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,
1504: -- 'Private API: LEAD_COMPETITOR_PROD_ID is not valid');
1505:
1506: AS_UTILITY_PVT.Set_Message(
1507: p_module => l_module,

Line 1508: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

1504: -- 'Private API: LEAD_COMPETITOR_PROD_ID is not valid');
1505:
1506: AS_UTILITY_PVT.Set_Message(
1507: p_module => l_module,
1508: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1509: p_msg_name => 'API_INVALID_LEAD_CPROD_ID',
1510: p_token1 => 'VALUE',
1511: p_token1_value => p_LEAD_COMPETITOR_PROD_ID );
1512:

Line 1521: FND_MSG_PUB.Count_And_Get

1517: END IF;
1518: END IF;
1519:
1520: -- Standard call to get message count and if count is 1, get message info.
1521: FND_MSG_PUB.Count_And_Get
1522: ( p_count => x_msg_count,
1523: p_data => x_msg_data
1524: );
1525:

Line 1550: FND_MSG_PUB.initialize;

1546:
1547: -- Initialize message list if p_init_msg_list is set to TRUE.
1548: IF FND_API.to_Boolean( p_init_msg_list )
1549: THEN
1550: FND_MSG_PUB.initialize;
1551: END IF;
1552:
1553:
1554: -- Initialize API return status to SUCCESS

Line 1565: FND_MSG_PUB.Count_And_Get

1561:
1562: -- Debug Message
1563:
1564: -- Standard call to get message count and if count is 1, get message info.
1565: FND_MSG_PUB.Count_And_Get
1566: ( p_count => x_msg_count,
1567: p_data => x_msg_data
1568: );
1569:

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

1579: X_Msg_Data OUT NOCOPY VARCHAR2
1580: )
1581: IS
1582: l_api_name CONSTANT VARCHAR2(30) := 'Validate_competitor_prod';
1583: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
1584: l_module CONSTANT VARCHAR2(255) := 'as.plsql.cpdpv.Validate_competitor_prod';
1585:
1586: BEGIN
1587:

Line 1590: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');

1586: BEGIN
1587:
1588: -- Debug Message
1589: IF l_debug THEN
1590: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
1591: END IF;
1592:
1593:
1594:

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

1597:
1598: IF (p_validation_level >= AS_UTILITY_PUB.G_VALID_LEVEL_ITEM) THEN
1599:
1600: IF l_debug THEN
1601: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1602: 'Private API validate: REQUEST_ID');
1603: END IF;
1604:
1605: Validate_REQUEST_ID(

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

1610: x_msg_count => x_msg_count,
1611: x_msg_data => x_msg_data);
1612:
1613: IF l_debug THEN
1614: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1615: 'Private API validate: WIN_LOSS_STATUS ');
1616: END IF;
1617:
1618: Validate_WIN_LOSS_STATUS(

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

1632: x_msg_count => x_msg_count,
1633: x_msg_data => x_msg_data);
1634:
1635: IF l_debug THEN
1636: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1637: 'Private API validate: LEAD_LINE_ID');
1638: END IF;
1639:
1640: Validate_LEAD_LINE_ID(

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

1645: x_msg_count => x_msg_count,
1646: x_msg_data => x_msg_data);
1647:
1648: IF l_debug THEN
1649: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1650: 'Private API validate: LEAD_ID');
1651: END IF;
1652:
1653: Validate_LEAD_ID(

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

1658: x_msg_count => x_msg_count,
1659: x_msg_data => x_msg_data);
1660:
1661: IF l_debug THEN
1662: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1663: 'Private API validate: L_COMPETITOR_PROD_ID');
1664: END IF;
1665:
1666:

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

1678: -- Hint: Inter-field level validation can be added here
1679: -- invoke record level validation procedures
1680:
1681: IF l_debug THEN
1682: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1683: 'Private API validate: Competitor_Prod_Rec');
1684: END IF;
1685:
1686:

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

1709:
1710:
1711: -- Debug Message
1712: IF l_debug THEN
1713: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1714: 'Private API: Validation end');
1715: END IF;
1716:
1717: