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

Line 321: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_ERROR)

317: FETCH C_Int_Type_Exists INTO l_variable;
318:
319: IF (C_Int_Type_Exists%NOTFOUND)
320: THEN
321: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_ERROR)
322: THEN
323: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
324: FND_MESSAGE.Set_Token('COLUMN', 'INTEREST_TYPE', FALSE);
325: FND_MESSAGE.Set_Token('VALUE', p_interest_type_id, FALSE);

Line 326: FND_MSG_PUB.Add;

322: THEN
323: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
324: FND_MESSAGE.Set_Token('COLUMN', 'INTEREST_TYPE', FALSE);
325: FND_MESSAGE.Set_Token('VALUE', p_interest_type_id, FALSE);
326: FND_MSG_PUB.Add;
327: END IF;
328:
329: l_return_status := FND_API.G_RET_STS_ERROR;
330: END IF;

Line 343: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_Msg_Lvl_Error)

339: FETCH C_Prim_Int_Code_Exists INTO l_variable;
340:
341: IF (C_Prim_Int_Code_Exists%NOTFOUND)
342: THEN
343: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_Msg_Lvl_Error)
344: THEN
345: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
346: FND_MESSAGE.Set_Token('COLUMN', 'PRIMARY_INTEREST_CODE', FALSE);
347: FND_MESSAGE.Set_Token('VALUE', p_primary_interest_code_id, FALSE);

Line 348: FND_MSG_PUB.Add;

344: THEN
345: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
346: FND_MESSAGE.Set_Token('COLUMN', 'PRIMARY_INTEREST_CODE', FALSE);
347: FND_MESSAGE.Set_Token('VALUE', p_primary_interest_code_id, FALSE);
348: FND_MSG_PUB.Add;
349: END IF;
350:
351: l_return_status := FND_API.G_RET_STS_ERROR;
352: END IF;

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

362: p_interest_type_id);
363: FETCH C_Sec_Int_Code_Exists INTO l_variable;
364: IF (C_Sec_Int_Code_Exists%NOTFOUND)
365: THEN
366: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
367: THEN
368: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
369: FND_MESSAGE.Set_Token('COLUMN', 'SECONDARY_INTEREST_CODE', FALSE);
370: FND_MESSAGE.Set_Token('VALUE', p_secondary_interest_code_id, FALSE);

Line 371: FND_MSG_PUB.ADD;

367: THEN
368: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
369: FND_MESSAGE.Set_Token('COLUMN', 'SECONDARY_INTEREST_CODE', FALSE);
370: FND_MESSAGE.Set_Token('VALUE', p_secondary_interest_code_id, FALSE);
371: FND_MSG_PUB.ADD;
372: END IF;
373:
374: l_return_status := FND_API.G_RET_STS_ERROR;
375: END IF;

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

417:
418: l_val VARCHAR2(1);
419: l_return_status VARCHAR2(1);
420: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Old_Line_rec';
421: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
422:
423:
424: l_module CONSTANT VARCHAR2(255) := 'as.plsql.ldlpv.Validate_Old_Line_rec';
425: BEGIN

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

424: l_module CONSTANT VARCHAR2(255) := 'as.plsql.ldlpv.Validate_Old_Line_rec';
425: BEGIN
426: -- Debug Message
427: IF l_debug THEN
428: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
429: 'Private API: ' || l_api_name || ' start');
430:
431: END IF;
432:

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

466: FETCH C_Category_Item_Exists into l_val;
467: IF C_Category_Item_Exists%NOTFOUND
468: THEN
469: IF l_debug THEN
470: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
471: 'Private API: Inventory item doesnot match category');
472: END IF;
473:
474: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

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

470: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
471: 'Private API: Inventory item doesnot match category');
472: END IF;
473:
474: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
475: THEN
476: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ITEM_CATEGORY');
477: FND_MSG_PUB.ADD;
478: END IF;

Line 477: FND_MSG_PUB.ADD;

473:
474: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
475: THEN
476: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ITEM_CATEGORY');
477: FND_MSG_PUB.ADD;
478: END IF;
479: p_return_status := FND_API.G_RET_STS_ERROR;
480: END IF;
481: CLOSE C_Category_Item_Exists;

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

492: ( p_organization_id is NULL or
493: p_organization_id = FND_API.G_MISS_NUM )
494: THEN
495: IF l_debug THEN
496: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
497: 'Private API: ORGANIZATION_ID is missing');
498:
499: END IF;
500:

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

497: 'Private API: ORGANIZATION_ID is missing');
498:
499: END IF;
500:
501: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
502: THEN
503: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
504: FND_MESSAGE.Set_Token('COLUMN', 'ORGANIZATION_ID', FALSE);
505: FND_MSG_PUB.ADD;

Line 505: FND_MSG_PUB.ADD;

501: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
502: THEN
503: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
504: FND_MESSAGE.Set_Token('COLUMN', 'ORGANIZATION_ID', FALSE);
505: FND_MSG_PUB.ADD;
506: END IF;
507:
508: p_return_status := FND_API.G_RET_STS_ERROR;
509: ELSIF p_inventory_item_id is NOT NULL and

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

514: FETCH C_Inventory_Item_Exists into l_val;
515: IF C_Inventory_Item_Exists%NOTFOUND
516: THEN
517: IF l_debug THEN
518: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
519: 'Private API: INVENTORY_ITEM_ID is invalid');
520: END IF;
521:
522: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

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

518: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
519: 'Private API: INVENTORY_ITEM_ID is invalid');
520: END IF;
521:
522: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
523: THEN
524: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
525: FND_MESSAGE.Set_Token('COLUMN', 'INVENTORY_ITEM_ID', FALSE);
526: FND_MESSAGE.Set_Token('VALUE', p_inventory_item_id, FALSE);

Line 527: FND_MSG_PUB.ADD;

523: THEN
524: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
525: FND_MESSAGE.Set_Token('COLUMN', 'INVENTORY_ITEM_ID', FALSE);
526: FND_MESSAGE.Set_Token('VALUE', p_inventory_item_id, FALSE);
527: FND_MSG_PUB.ADD;
528: END IF;
529:
530: p_return_status := FND_API.G_RET_STS_ERROR;
531: END IF;

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

533: END IF;
534:
535: -- Debug Message
536: IF l_debug THEN
537: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
538: 'Private API: ' || l_api_name || ' end');
539:
540: END IF;
541:

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

575: where interest_code_id = c_sec_interest_code_id
576: and interest_type_id = c_interest_type_id
577: and parent_interest_code_id = c_pri_interest_code_id;
578:
579: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
580: l_category_id NUMBER;
581: l_category_set_id NUMBER;
582: l_return_status VARCHAR2(1);
583: l_module CONSTANT VARCHAR2(255) := 'as.plsql.ldlpv.Derive_PRODUCT_CATEGORY';

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

607: p_Line_Rec.Product_Cat_Set_Id := l_category_set_id;
608: ELSE
609: CLOSE C_GET_CATEGORY_FROM_ITEM;
610: IF l_debug THEN
611: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
612: 'Private API: Unable to derive product category from item');
613: END IF;
614: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
615: THEN

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

610: IF l_debug THEN
611: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
612: 'Private API: Unable to derive product category from item');
613: END IF;
614: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
615: THEN
616: FND_MESSAGE.Set_Name('AS', 'API_DERIVE_PC_ERROR');
617: FND_MSG_PUB.ADD;
618: END IF;

Line 617: FND_MSG_PUB.ADD;

613: END IF;
614: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
615: THEN
616: FND_MESSAGE.Set_Name('AS', 'API_DERIVE_PC_ERROR');
617: FND_MSG_PUB.ADD;
618: END IF;
619: l_return_status := FND_API.G_RET_STS_ERROR;
620: END IF;
621: ELSIF (p_Line_Rec.secondary_interest_code_id is not null

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

628: p_Line_Rec.Product_Cat_Set_Id := l_category_set_id;
629: ELSE
630: CLOSE C_GET_CATEGORY_FROM_SIC;
631: IF l_debug THEN
632: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
633: 'Private API: Unable to derive product category from secondary interest code');
634: END IF;
635: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
636: THEN

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

631: IF l_debug THEN
632: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
633: 'Private API: Unable to derive product category from secondary interest code');
634: END IF;
635: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
636: THEN
637: FND_MESSAGE.Set_Name('AS', 'API_DERIVE_PC_ERROR');
638: FND_MSG_PUB.ADD;
639: END IF;

Line 638: FND_MSG_PUB.ADD;

634: END IF;
635: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
636: THEN
637: FND_MESSAGE.Set_Name('AS', 'API_DERIVE_PC_ERROR');
638: FND_MSG_PUB.ADD;
639: END IF;
640: l_return_status := FND_API.G_RET_STS_ERROR;
641: END IF;
642: ELSIF (p_Line_Rec.primary_interest_code_id is not null

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

649: p_Line_Rec.Product_Cat_Set_Id := l_category_set_id;
650: ELSE
651: CLOSE C_GET_CATEGORY_FROM_PIC;
652: IF l_debug THEN
653: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
654: 'Private API: Unable to derive product category from primary interest code');
655: END IF;
656: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
657: THEN

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

652: IF l_debug THEN
653: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
654: 'Private API: Unable to derive product category from primary interest code');
655: END IF;
656: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
657: THEN
658: FND_MESSAGE.Set_Name('AS', 'API_DERIVE_PC_ERROR');
659: FND_MSG_PUB.ADD;
660: END IF;

Line 659: FND_MSG_PUB.ADD;

655: END IF;
656: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
657: THEN
658: FND_MESSAGE.Set_Name('AS', 'API_DERIVE_PC_ERROR');
659: FND_MSG_PUB.ADD;
660: END IF;
661: l_return_status := FND_API.G_RET_STS_ERROR;
662: END IF;
663: ELSIF (p_Line_Rec.interest_type_id is not null

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

670: p_Line_Rec.Product_Cat_Set_Id := l_category_set_id;
671: ELSE
672: CLOSE C_GET_CATEGORY_FROM_IT;
673: IF l_debug THEN
674: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
675: 'Private API: Unable to derive product category from interest type');
676: END IF;
677: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
678: THEN

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

673: IF l_debug THEN
674: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
675: 'Private API: Unable to derive product category from interest type');
676: END IF;
677: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
678: THEN
679: FND_MESSAGE.Set_Name('AS', 'API_DERIVE_PC_ERROR');
680: FND_MSG_PUB.ADD;
681: END IF;

Line 680: FND_MSG_PUB.ADD;

676: END IF;
677: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
678: THEN
679: FND_MESSAGE.Set_Name('AS', 'API_DERIVE_PC_ERROR');
680: FND_MSG_PUB.ADD;
681: END IF;
682: l_return_status := FND_API.G_RET_STS_ERROR;
683: END IF;
684: END IF;

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

791:
792: l_valid_group VARCHAR2(1) := 'N';
793:
794: org_id NUMBER;
795: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
796:
797: l_module CONSTANT VARCHAR2(255) := 'as.plsql.ldlpv.Create_opp_lines';
798: BEGIN
799: -- Standard Start of API savepoint

Line 815: FND_MSG_PUB.initialize;

811:
812: -- Initialize message list if p_init_msg_list is set to TRUE.
813: IF FND_API.to_Boolean( p_init_msg_list )
814: THEN
815: FND_MSG_PUB.initialize;
816: END IF;
817:
818:
819: -- Debug Message

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

817:
818:
819: -- Debug Message
820: IF l_debug THEN
821: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
822: 'Private API: ' || l_api_name || ' start');
823: END IF;
824:
825:

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

855: -- Validate Environment
856: -- ******************************************************************
857: IF FND_GLOBAL.User_Id IS NULL
858: THEN
859: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
860: THEN
861: FND_MESSAGE.Set_Name(' + appShortName +',
862: 'UT_CANNOT_GET_PROFILE_VALUE');
863: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);

Line 864: FND_MSG_PUB.ADD;

860: THEN
861: FND_MESSAGE.Set_Name(' + appShortName +',
862: 'UT_CANNOT_GET_PROFILE_VALUE');
863: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
864: FND_MSG_PUB.ADD;
865: END IF;
866: RAISE FND_API.G_EXC_ERROR;
867: END IF;
868:

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

876: ,x_msg_data => x_msg_data
877: ,x_sales_member_rec => l_identity_sales_member_rec);
878:
879: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
880: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
881: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
882: 'Private API: Get_CurrentUser fail');
883: END IF;
884: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

877: ,x_sales_member_rec => l_identity_sales_member_rec);
878:
879: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
880: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
881: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
882: 'Private API: Get_CurrentUser fail');
883: END IF;
884: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
885: END IF;

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

886:
887: -- fix for the bug 2776714. Give a meaningful error message when defualt
888: --forecast credit type is null
889: IF l_forecast_credit_type_id IS NULL THEN
890: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
891: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
892: 'The profile AS_FORECAST_CREDIT_TYPE_ID is null');
893: END IF;
894:

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

887: -- fix for the bug 2776714. Give a meaningful error message when defualt
888: --forecast credit type is null
889: IF l_forecast_credit_type_id IS NULL THEN
890: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
891: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
892: 'The profile AS_FORECAST_CREDIT_TYPE_ID is null');
893: END IF;
894:
895: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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

891: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
892: 'The profile AS_FORECAST_CREDIT_TYPE_ID is null');
893: END IF;
894:
895: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
896: FND_MESSAGE.Set_Name('AS', 'AS_CREDIT_TYPE_MISSING');
897: FND_MSG_PUB.ADD;
898: END IF;
899:

Line 897: FND_MSG_PUB.ADD;

893: END IF;
894:
895: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
896: FND_MESSAGE.Set_Name('AS', 'AS_CREDIT_TYPE_MISSING');
897: FND_MSG_PUB.ADD;
898: END IF;
899:
900: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
901: RAISE FND_API.G_EXC_ERROR;

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

926: ,x_msg_data => x_msg_data
927: ,x_update_access_flag => l_update_access_flag );
928:
929: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
930: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
931: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
932: 'Private API: has_updateOpportunityAccess fail');
933: END IF;
934: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

927: ,x_update_access_flag => l_update_access_flag );
928:
929: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
930: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
931: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
932: 'Private API: has_updateOpportunityAccess fail');
933: END IF;
934: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
935: END IF;

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

934: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
935: END IF;
936:
937: IF (l_update_access_flag <> 'Y') THEN
938: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
939: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');
940: FND_MESSAGE.Set_Token('INFO', 'CUSTOMER_ID,OPPORTUNITY_ID,SALESFORCE_ID', FALSE);
941: FND_MSG_PUB.ADD;
942: END IF;

Line 941: FND_MSG_PUB.ADD;

937: IF (l_update_access_flag <> 'Y') THEN
938: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
939: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');
940: FND_MESSAGE.Set_Token('INFO', 'CUSTOMER_ID,OPPORTUNITY_ID,SALESFORCE_ID', FALSE);
941: FND_MSG_PUB.ADD;
942: END IF;
943: RAISE FND_API.G_EXC_ERROR;
944: ELSE
945: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

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

941: FND_MSG_PUB.ADD;
942: END IF;
943: RAISE FND_API.G_EXC_ERROR;
944: ELSE
945: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
946: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
947: 'Private API: has_updateOpportunityAccess succeed');
948: END IF;
949: END IF;

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

942: END IF;
943: RAISE FND_API.G_EXC_ERROR;
944: ELSE
945: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
946: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
947: 'Private API: has_updateOpportunityAccess succeed');
948: END IF;
949: END IF;
950: END IF;

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

957: IF l_freeze_flag = 'Y'
958: THEN
959: l_allow_flag := NVL(FND_PROFILE.VALUE('AS_ALLOW_UPDATE_FROZEN_OPP'),'Y');
960: IF l_allow_flag <> 'Y' THEN
961: AS_UTILITY_PVT.Set_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
962: 'API_OPP_FROZEN');
963: RAISE FND_API.G_EXC_ERROR;
964: END IF;
965: END IF;

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

969: X_line_out_tbl(l_curr_row).return_status := FND_API.G_RET_STS_SUCCESS;
970:
971: -- Progress Message
972: --
973: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
974: THEN
975: --FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
976: --FND_MESSAGE.Set_Token ('ROW', 'AS_LEAD_LINE', TRUE);
977: --FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(l_curr_row), FALSE);

Line 978: --FND_MSG_PUB.Add;

974: THEN
975: --FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
976: --FND_MESSAGE.Set_Token ('ROW', 'AS_LEAD_LINE', TRUE);
977: --FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(l_curr_row), FALSE);
978: --FND_MSG_PUB.Add;
979: IF l_debug THEN
980: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
981: 'Processing AS_LEAD_LINE row number '||l_curr_row );
982: END IF;

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

976: --FND_MESSAGE.Set_Token ('ROW', 'AS_LEAD_LINE', TRUE);
977: --FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(l_curr_row), FALSE);
978: --FND_MSG_PUB.Add;
979: IF l_debug THEN
980: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
981: 'Processing AS_LEAD_LINE row number '||l_curr_row );
982: END IF;
983:
984: END IF;

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

986: l_line_rec := P_Line_Tbl(l_curr_row);
987:
988: -- Debug message
989: IF l_debug THEN
990: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
991: 'Private API: Validate_opp_line');
992: END IF;
993:
994: -- Default organization from profile ASO_PRODUCT_ORGANIZATION_ID if

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

1074: Derive_PRODUCT_CATEGORY(p_Line_Rec => l_Line_Rec, p_Return_Status => x_return_status);
1075: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1076: -- Debug message
1077: IF l_debug THEN
1078: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1079: 'Private API: Derive_PRODUCT_CATEGORY fail');
1080: END IF;
1081: RAISE FND_API.G_EXC_ERROR;
1082: END IF;

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

1095:
1096: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
1097: -- Debug message
1098: IF l_debug THEN
1099: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1100: 'Private API: Validate_opp_line fail');
1101: END IF;
1102:
1103: RAISE FND_API.G_EXC_ERROR;

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

1105:
1106:
1107: -- Debug Message
1108: IF l_debug THEN
1109: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1110: 'Private API: Calling create table handler');
1111: END IF;
1112:
1113: l_LEAD_LINE_ID := l_Line_rec.LEAD_LINE_ID;

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

1175: RAISE FND_API.G_EXC_ERROR;
1176: END IF;
1177:
1178: IF l_debug THEN
1179: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1180: 'Private API1: Created line_id: '||l_LEAD_LINE_ID );
1181: END IF;
1182:
1183:

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

1203: l_sales_credit_rec.salesforce_id := l_identity_sales_member_rec.salesforce_id;
1204: l_sales_credit_rec.person_id := l_identity_sales_member_rec.employee_person_id;
1205:
1206: IF l_debug THEN
1207: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1208: 'employee_person_id' ||l_identity_sales_member_rec.employee_person_id );
1209: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1210: 'partner_customer_id' ||l_identity_sales_member_rec.partner_customer_id );
1211: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

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

1205:
1206: IF l_debug THEN
1207: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1208: 'employee_person_id' ||l_identity_sales_member_rec.employee_person_id );
1209: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1210: 'partner_customer_id' ||l_identity_sales_member_rec.partner_customer_id );
1211: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1212: 'partner_contact_id' ||l_identity_sales_member_rec.partner_contact_id );
1213: END IF;

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

1207: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1208: 'employee_person_id' ||l_identity_sales_member_rec.employee_person_id );
1209: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1210: 'partner_customer_id' ||l_identity_sales_member_rec.partner_customer_id );
1211: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1212: 'partner_contact_id' ||l_identity_sales_member_rec.partner_contact_id );
1213: END IF;
1214:
1215: l_sales_credit_rec.salesgroup_id := p_salesgroup_id;

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

1236: x_msg_data => x_msg_data);
1237:
1238: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1239: IF l_debug THEN
1240: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1241: 'Private API2: Create_Opp_line: validate_sc_rec fail' );
1242: END IF;
1243:
1244: raise FND_API.G_EXC_ERROR;

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

1265: -- Check return status from the above procedure call
1266: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1267: THEN
1268: IF l_debug THEN
1269: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1270: 'Private API3: Create_Opp_line: Create_Sales_credit fail' );
1271: END IF;
1272: raise FND_API.G_EXC_ERROR;
1273: END IF;

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

1307: -- Check return status from the above procedure call
1308: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1309: THEN
1310: IF l_debug THEN
1311: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1312: 'Private API3: Create_Opp_line: Create_Sales_credit fail' );
1313: END IF;
1314: raise FND_API.G_EXC_ERROR;
1315: END IF;

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

1315: END IF;
1316:
1317: ELSE
1318: IF l_debug THEN
1319: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1320: 'Private API: l_isd_sales_group_id is invalid ' );
1321: END IF;
1322: END IF;
1323: END IF;

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

1336: x_return_status => x_return_status);
1337:
1338: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1339: IF l_debug THEN
1340: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1341: 'Private API: Create_Opp_line: Backupdate_header fail' );
1342: END IF;
1343: raise FND_API.G_EXC_ERROR;
1344: END IF;

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

1346: -- Assign/Reassign the territory resources for the opportunity
1347:
1348: -- Debug Message
1349: IF l_debug THEN
1350: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1351: 'Calling Opportunity Real Time API');
1352: END IF;
1353:
1354: AS_RTTAP_OPPTY.RTTAP_WRAPPER(

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

1362: );
1363:
1364: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
1365: IF l_debug THEN
1366: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1367: 'Opportunity Real Time API fail');
1368: END IF;
1369: RAISE FND_API.G_EXC_ERROR;
1370: END IF;

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

1381:
1382:
1383: -- Debug Message
1384: IF l_debug THEN
1385: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1386: 'Private API: ' || l_api_name || ' end');
1387: END IF;
1388:
1389:

Line 1391: FND_MSG_PUB.Count_And_Get

1387: END IF;
1388:
1389:
1390: -- Standard call to get message count and if count is 1, get message info.
1391: FND_MSG_PUB.Count_And_Get
1392: ( p_count => x_msg_count,
1393: p_data => x_msg_data
1394: );
1395:

Line 1422: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1418: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1419: P_MODULE => l_module
1420: ,P_API_NAME => L_API_NAME
1421: ,P_PKG_NAME => G_PKG_NAME
1422: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1423: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1424: ,X_MSG_COUNT => X_MSG_COUNT
1425: ,X_MSG_DATA => X_MSG_DATA
1426: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1433: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1429: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1430: P_MODULE => l_module
1431: ,P_API_NAME => L_API_NAME
1432: ,P_PKG_NAME => G_PKG_NAME
1433: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1434: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1435: ,X_MSG_COUNT => X_MSG_COUNT
1436: ,X_MSG_DATA => X_MSG_DATA
1437: ,X_RETURN_STATUS => X_RETURN_STATUS);

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

1504: l_line_amount_old NUMBER;
1505: l_freeze_flag VARCHAR2(1) := 'N'; -- solin, for bug 1554330
1506: l_allow_flag VARCHAR2(1); -- solin, for bug 1554330
1507: l_decision_date DATE;
1508: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
1509:
1510: l_module CONSTANT VARCHAR2(255) := 'as.plsql.ldlpv.Update_opp_lines';
1511: BEGIN
1512: -- Standard Start of API savepoint

Line 1528: FND_MSG_PUB.initialize;

1524:
1525: -- Initialize message list if p_init_msg_list is set to TRUE.
1526: IF FND_API.to_Boolean( p_init_msg_list )
1527: THEN
1528: FND_MSG_PUB.initialize;
1529: END IF;
1530:
1531:
1532: -- Debug Message

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

1530:
1531:
1532: -- Debug Message
1533: IF l_debug THEN
1534: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1535: 'Private API: ' || l_api_name || ' start');
1536: END IF;
1537:
1538:

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

1574: ,x_msg_data => x_msg_data
1575: ,x_sales_member_rec => l_identity_sales_member_rec);
1576:
1577: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1578: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1579: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1580: 'Private API: Get_CurrentUser fail');
1581: END IF;
1582: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1575: ,x_sales_member_rec => l_identity_sales_member_rec);
1576:
1577: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1578: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1579: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1580: 'Private API: Get_CurrentUser fail');
1581: END IF;
1582: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1583: END IF;

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

1605: ,x_msg_data => x_msg_data
1606: ,x_update_access_flag => l_update_access_flag );
1607:
1608: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1609: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1610: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1611: 'has_updateOpportunityAccess fail');
1612: END IF;
1613: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1606: ,x_update_access_flag => l_update_access_flag );
1607:
1608: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1609: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1610: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1611: 'has_updateOpportunityAccess fail');
1612: END IF;
1613: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1614: END IF;

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

1613: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1614: END IF;
1615:
1616: IF (l_update_access_flag <> 'Y') THEN
1617: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1618: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');
1619: FND_MESSAGE.Set_Token('INFO', 'CUSTOMER_ID,OPPORTUNITY_ID,SALESFORCE_ID', FALSE);
1620: FND_MSG_PUB.ADD;
1621: END IF;

Line 1620: FND_MSG_PUB.ADD;

1616: IF (l_update_access_flag <> 'Y') THEN
1617: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1618: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');
1619: FND_MESSAGE.Set_Token('INFO', 'CUSTOMER_ID,OPPORTUNITY_ID,SALESFORCE_ID', FALSE);
1620: FND_MSG_PUB.ADD;
1621: END IF;
1622: RAISE FND_API.G_EXC_ERROR;
1623: END IF;
1624: END IF;

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

1631: IF l_freeze_flag = 'Y'
1632: THEN
1633: l_allow_flag := NVL(FND_PROFILE.VALUE('AS_ALLOW_UPDATE_FROZEN_OPP'),'Y');
1634: IF l_allow_flag <> 'Y' THEN
1635: AS_UTILITY_PVT.Set_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
1636: 'API_OPP_FROZEN');
1637: RAISE FND_API.G_EXC_ERROR;
1638: END IF;
1639: END IF;

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

1643: X_Line_out_tbl(l_curr_row).return_status := FND_API.G_RET_STS_SUCCESS;
1644:
1645: -- Progress Message
1646: --
1647: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1648: THEN
1649: --FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
1650: --FND_MESSAGE.Set_Token ('ROW', 'AS_LEAD_LINE', TRUE);
1651: --FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(l_curr_row), FALSE);

Line 1652: --FND_MSG_PUB.Add;

1648: THEN
1649: --FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
1650: --FND_MESSAGE.Set_Token ('ROW', 'AS_LEAD_LINE', TRUE);
1651: --FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(l_curr_row), FALSE);
1652: --FND_MSG_PUB.Add;
1653: IF l_debug THEN
1654: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1655: 'Processing AS_LEAD_LINE row number '||l_curr_row );
1656: END IF;

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

1650: --FND_MESSAGE.Set_Token ('ROW', 'AS_LEAD_LINE', TRUE);
1651: --FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(l_curr_row), FALSE);
1652: --FND_MSG_PUB.Add;
1653: IF l_debug THEN
1654: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1655: 'Processing AS_LEAD_LINE row number '||l_curr_row );
1656: END IF;
1657:
1658: END IF;

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

1661:
1662:
1663: -- Debug Message
1664: IF l_debug THEN
1665: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1666: 'Private API: - Open Cursor to Select');
1667: END IF;
1668:
1669: Open C_Get_opp_line( l_Line_rec.LEAD_LINE_ID);

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

1670:
1671: Fetch C_Get_opp_line into l_last_update_date, l_line_amount_old;
1672:
1673: If ( C_Get_opp_line%NOTFOUND) Then
1674: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1675: THEN
1676: FND_MESSAGE.Set_Name('AS', 'API_MISSING_UPDATE_TARGET');
1677: FND_MESSAGE.Set_Token ('INFO', 'opp_line', FALSE);
1678: FND_MSG_PUB.Add;

Line 1678: FND_MSG_PUB.Add;

1674: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1675: THEN
1676: FND_MESSAGE.Set_Name('AS', 'API_MISSING_UPDATE_TARGET');
1677: FND_MESSAGE.Set_Token ('INFO', 'opp_line', FALSE);
1678: FND_MSG_PUB.Add;
1679: END IF;
1680: raise FND_API.G_EXC_ERROR;
1681: END IF;
1682: -- Debug Message

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

1680: raise FND_API.G_EXC_ERROR;
1681: END IF;
1682: -- Debug Message
1683: IF l_debug THEN
1684: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1685: 'Private API: - Close Cursor');
1686: END IF;
1687:
1688: Close C_Get_opp_line;

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

1688: Close C_Get_opp_line;
1689:
1690: If (l_Line_rec.last_update_date is NULL or
1691: l_Line_rec.last_update_date = FND_API.G_MISS_Date ) Then
1692: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1693: THEN
1694: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
1695: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
1696: FND_MSG_PUB.ADD;

Line 1696: FND_MSG_PUB.ADD;

1692: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1693: THEN
1694: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
1695: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
1696: FND_MSG_PUB.ADD;
1697: END IF;
1698: raise FND_API.G_EXC_ERROR;
1699: End if;
1700: -- Check Whether record has been changed by someone else

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

1699: End if;
1700: -- Check Whether record has been changed by someone else
1701: If (l_Line_rec.last_update_date <> l_last_update_date)
1702: Then
1703: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1704: THEN
1705: FND_MESSAGE.Set_Name('AS', 'API_RECORD_CHANGED');
1706: FND_MESSAGE.Set_Token('INFO', 'opp_line', FALSE);
1707: FND_MSG_PUB.ADD;

Line 1707: FND_MSG_PUB.ADD;

1703: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1704: THEN
1705: FND_MESSAGE.Set_Name('AS', 'API_RECORD_CHANGED');
1706: FND_MESSAGE.Set_Token('INFO', 'opp_line', FALSE);
1707: FND_MSG_PUB.ADD;
1708: END IF;
1709: raise FND_API.G_EXC_ERROR;
1710: End if;
1711:

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

1710: End if;
1711:
1712: -- Debug message
1713: IF l_debug THEN
1714: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1715: 'Private API: Validate_competitor');
1716: END IF;
1717:
1718: -- Invoke validation procedures

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

1727:
1728: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
1729: -- Debug message
1730: IF l_debug THEN
1731: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1732: 'Private API: Validate_opp_line fail');
1733: END IF;
1734: RAISE FND_API.G_EXC_ERROR;
1735: END IF;

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

1766:
1767:
1768: -- Debug Message
1769: IF l_debug THEN
1770: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1771: 'Private API: Calling update table handler');
1772: END IF;
1773:
1774: -- Invoke table handler(AS_LEAD_LINES_PKG.Update_Row)

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

1863: -- Assign/Reassign the territory resources for the opportunity
1864:
1865: -- Debug Message
1866: IF l_debug THEN
1867: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1868: 'Calling Opportunity Real Time API');
1869: END IF;
1870:
1871: AS_RTTAP_OPPTY.RTTAP_WRAPPER(

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

1879: );
1880:
1881: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
1882: IF l_debug THEN
1883: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1884: 'Opportunity Real Time API fail');
1885: END IF;
1886:
1887: RAISE FND_API.G_EXC_ERROR;

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

1899:
1900:
1901: -- Debug Message
1902: IF l_debug THEN
1903: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1904: 'Private API: ' || l_api_name || ' end');
1905: END IF;
1906:
1907:

Line 1909: FND_MSG_PUB.Count_And_Get

1905: END IF;
1906:
1907:
1908: -- Standard call to get message count and if count is 1, get message info.
1909: FND_MSG_PUB.Count_And_Get
1910: ( p_count => x_msg_count,
1911: p_data => x_msg_data
1912: );
1913:

Line 1940: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1936: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1937: P_MODULE => l_module
1938: ,P_API_NAME => L_API_NAME
1939: ,P_PKG_NAME => G_PKG_NAME
1940: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1941: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1942: ,X_MSG_COUNT => X_MSG_COUNT
1943: ,X_MSG_DATA => X_MSG_DATA
1944: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1951: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1947: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1948: P_MODULE => l_module
1949: ,P_API_NAME => L_API_NAME
1950: ,P_PKG_NAME => G_PKG_NAME
1951: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1952: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1953: ,X_MSG_COUNT => X_MSG_COUNT
1954: ,X_MSG_DATA => X_MSG_DATA
1955: ,X_RETURN_STATUS => X_RETURN_STATUS);

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

2026:
2027: l_freeze_flag VARCHAR2(1) := 'N'; -- solin, for bug 1554330
2028: l_allow_flag VARCHAR2(1); -- solin, for bug 1554330
2029:
2030: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
2031:
2032: l_module CONSTANT VARCHAR2(255) := 'as.plsql.ldlpv.Delete_opp_lines';
2033: BEGIN
2034: -- Standard Start of API savepoint

Line 2050: FND_MSG_PUB.initialize;

2046:
2047: -- Initialize message list if p_init_msg_list is set to TRUE.
2048: IF FND_API.to_Boolean( p_init_msg_list )
2049: THEN
2050: FND_MSG_PUB.initialize;
2051: END IF;
2052:
2053:
2054: -- Debug Message

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

2052:
2053:
2054: -- Debug Message
2055: IF l_debug THEN
2056: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2057: 'Private API: ' || l_api_name || ' start');
2058: END IF;
2059:
2060:

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

2096: ,x_msg_data => x_msg_data
2097: ,x_sales_member_rec => l_identity_sales_member_rec);
2098:
2099: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2100: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2101: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2102: 'Private API: Get_CurrentUser fail');
2103: END IF;
2104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

2097: ,x_sales_member_rec => l_identity_sales_member_rec);
2098:
2099: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2100: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2101: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2102: 'Private API: Get_CurrentUser fail');
2103: END IF;
2104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2105: END IF;

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

2126: ,x_msg_data => x_msg_data
2127: ,x_update_access_flag => l_update_access_flag );
2128:
2129: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2130: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2131: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2132: 'has_updateOpportunityAccess fail');
2133: END IF;
2134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

2127: ,x_update_access_flag => l_update_access_flag );
2128:
2129: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2130: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2131: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2132: 'has_updateOpportunityAccess fail');
2133: END IF;
2134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2135: END IF;

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

2134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2135: END IF;
2136:
2137: IF (l_update_access_flag <> 'Y') THEN
2138: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2139: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');
2140: FND_MESSAGE.Set_Token('INFO', 'CUSTOMER_ID,OPPORTUNITY_ID,SALESFORCE_ID', FALSE);
2141: FND_MSG_PUB.ADD;
2142: END IF;

Line 2141: FND_MSG_PUB.ADD;

2137: IF (l_update_access_flag <> 'Y') THEN
2138: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2139: FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');
2140: FND_MESSAGE.Set_Token('INFO', 'CUSTOMER_ID,OPPORTUNITY_ID,SALESFORCE_ID', FALSE);
2141: FND_MSG_PUB.ADD;
2142: END IF;
2143: RAISE FND_API.G_EXC_ERROR;
2144: END IF;
2145: END IF;

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

2152: IF l_freeze_flag = 'Y'
2153: THEN
2154: l_allow_flag := NVL(FND_PROFILE.VALUE('AS_ALLOW_UPDATE_FROZEN_OPP'),'Y');
2155: IF l_allow_flag <> 'Y' THEN
2156: AS_UTILITY_PVT.Set_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
2157: 'API_OPP_FROZEN');
2158: RAISE FND_API.G_EXC_ERROR;
2159: END IF;
2160: END IF;

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

2165: X_line_out_tbl(l_curr_row).return_status := FND_API.G_RET_STS_SUCCESS;
2166:
2167: -- Progress Message
2168: --
2169: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2170: THEN
2171: --FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
2172: --FND_MESSAGE.Set_Token ('ROW', 'AS_LEAD_LINE', TRUE);
2173: --FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(l_curr_row), FALSE);

Line 2174: --FND_MSG_PUB.Add;

2170: THEN
2171: --FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
2172: --FND_MESSAGE.Set_Token ('ROW', 'AS_LEAD_LINE', TRUE);
2173: --FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(l_curr_row), FALSE);
2174: --FND_MSG_PUB.Add;
2175: IF l_debug THEN
2176: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2177: 'Processing AS_LEAD_LINE row number '||l_curr_row );
2178: END IF;

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

2172: --FND_MESSAGE.Set_Token ('ROW', 'AS_LEAD_LINE', TRUE);
2173: --FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(l_curr_row), FALSE);
2174: --FND_MSG_PUB.Add;
2175: IF l_debug THEN
2176: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2177: 'Processing AS_LEAD_LINE row number '||l_curr_row );
2178: END IF;
2179:
2180: END IF;

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

2182: l_line_rec := P_Line_Tbl(l_curr_row);
2183:
2184: -- Debug Message
2185: IF l_debug THEN
2186: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2187: 'Private API: Calling delete table handler');
2188: END IF;
2189:
2190: -- Invoke table handler(AS_LEAD_LINES_PKG.Delete_Row)

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

2229: -- Assign/Reassign the territory resources for the opportunity
2230:
2231: -- Debug Message
2232: IF l_debug THEN
2233: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2234: 'Calling Opportunity Real Time API');
2235: END IF;
2236:
2237: AS_RTTAP_OPPTY.RTTAP_WRAPPER(

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

2245: );
2246:
2247: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
2248: IF l_debug THEN
2249: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2250: 'Opportunity Real Time API fail');
2251: END IF;
2252: RAISE FND_API.G_EXC_ERROR;
2253: END IF;

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

2264:
2265:
2266: -- Debug Message
2267: IF l_debug THEN
2268: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2269: 'Private API: ' || l_api_name || ' end');
2270: END IF;
2271:
2272:

Line 2274: FND_MSG_PUB.Count_And_Get

2270: END IF;
2271:
2272:
2273: -- Standard call to get message count and if count is 1, get message info.
2274: FND_MSG_PUB.Count_And_Get
2275: ( p_count => x_msg_count,
2276: p_data => x_msg_data
2277: );
2278:

Line 2304: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

2300: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2301: P_MODULE => l_module
2302: ,P_API_NAME => L_API_NAME
2303: ,P_PKG_NAME => G_PKG_NAME
2304: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2305: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
2306: ,X_MSG_COUNT => X_MSG_COUNT
2307: ,X_MSG_DATA => X_MSG_DATA
2308: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 2315: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

2311: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2312: P_MODULE => l_module
2313: ,P_API_NAME => L_API_NAME
2314: ,P_PKG_NAME => G_PKG_NAME
2315: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2316: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
2317: ,X_MSG_COUNT => X_MSG_COUNT
2318: ,X_MSG_DATA => X_MSG_DATA
2319: ,X_RETURN_STATUS => X_RETURN_STATUS);

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

2348: FROM as_lead_lines
2349: WHERE lead_line_id = c_Lead_Line_Id;
2350:
2351: l_val VARCHAR2(1);
2352: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
2353:
2354: l_module CONSTANT VARCHAR2(255) := 'as.plsql.ldlpv.Validate_LEAD_LINE_ID';
2355: BEGIN
2356:

Line 2360: FND_MSG_PUB.initialize;

2356:
2357: -- Initialize message list if p_init_msg_list is set to TRUE.
2358: IF FND_API.to_Boolean( p_init_msg_list )
2359: THEN
2360: FND_MSG_PUB.initialize;
2361: END IF;
2362:
2363:
2364: -- Initialize API return status to SUCCESS

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

2373: OPEN C_Lead_Line_Id_Exists (p_Lead_Line_Id);
2374: FETCH C_Lead_Line_Id_Exists into l_val;
2375: IF C_Lead_Line_Id_Exists%FOUND THEN
2376: IF l_debug THEN
2377: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
2378: 'Private API: LEAD_LINE_ID exist');
2379: END IF;
2380: x_return_status := FND_API.G_RET_STS_ERROR;
2381: END IF;

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

2388: -- validate NOT NULL column
2389: IF (p_LEAD_LINE_ID is NULL) or (p_LEAD_LINE_ID = FND_API.G_MISS_NUM)
2390: THEN
2391: IF l_debug THEN
2392: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
2393: 'Private API: Violate NOT NULL constraint(LEAD_LINE_ID)');
2394: END IF;
2395: x_return_status := FND_API.G_RET_STS_ERROR;
2396: ELSE

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

2398: FETCH C_Lead_Line_Id_Exists into l_val;
2399: IF C_Lead_Line_Id_Exists%NOTFOUND
2400: THEN
2401: IF l_debug THEN
2402: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
2403: 'Private API: LEAD_LINE_ID is not valid');
2404: END IF;
2405: x_return_status := FND_API.G_RET_STS_ERROR;
2406: END IF;

Line 2413: FND_MSG_PUB.Count_And_Get

2409:
2410: END IF;
2411:
2412: -- Standard call to get message count and if count is 1, get message info.
2413: FND_MSG_PUB.Count_And_Get
2414: ( p_count => x_msg_count,
2415: p_data => x_msg_data
2416: );
2417:

Line 2436: FND_MSG_PUB.initialize;

2432:
2433: -- Initialize message list if p_init_msg_list is set to TRUE.
2434: IF FND_API.to_Boolean( p_init_msg_list )
2435: THEN
2436: FND_MSG_PUB.initialize;
2437: END IF;
2438:
2439:
2440: -- Initialize API return status to SUCCESS

Line 2460: FND_MSG_PUB.Count_And_Get

2456: NULL;
2457: END IF;
2458:
2459: -- Standard call to get message count and if count is 1, get message info.
2460: FND_MSG_PUB.Count_And_Get
2461: ( p_count => x_msg_count,
2462: p_data => x_msg_data
2463: );
2464:

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

2481: FROM as_leads
2482: WHERE lead_id = c_Lead_Id;
2483:
2484: l_val VARCHAR2(1);
2485: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
2486:
2487: l_module CONSTANT VARCHAR2(255) := 'as.plsql.ldlpv.Validate_LEAD_ID';
2488: BEGIN
2489:

Line 2493: FND_MSG_PUB.initialize;

2489:
2490: -- Initialize message list if p_init_msg_list is set to TRUE.
2491: IF FND_API.to_Boolean( p_init_msg_list )
2492: THEN
2493: FND_MSG_PUB.initialize;
2494: END IF;
2495:
2496:
2497: -- Initialize API return status to SUCCESS

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

2500:
2501: IF (p_LEAD_ID is NULL) or (p_LEAD_ID = FND_API.G_MISS_NUM)
2502: THEN
2503: IF l_debug THEN
2504: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
2505: 'Private API: Violate NOT NULL constraint(LEAD_ID)');
2506: END IF;
2507: x_return_status := FND_API.G_RET_STS_ERROR;
2508: ELSE

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

2510: FETCH C_Lead_Id_Exists into l_val;
2511: IF C_Lead_Id_Exists%NOTFOUND
2512: THEN
2513: IF l_debug THEN
2514: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
2515: 'Private API: LEAD_ID is not valid');
2516: END IF;
2517: x_return_status := FND_API.G_RET_STS_ERROR;
2518: END IF;

Line 2523: FND_MSG_PUB.Count_And_Get

2519: CLOSE C_Lead_Id_Exists;
2520: END IF;
2521:
2522: -- Standard call to get message count and if count is 1, get message info.
2523: FND_MSG_PUB.Count_And_Get
2524: ( p_count => x_msg_count,
2525: p_data => x_msg_data
2526: );
2527:

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

2544: FROM as_interest_types_all
2545: WHERE interest_type_id = c_interest_type_id;
2546:
2547: l_val VARCHAR2(1);
2548: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
2549:
2550: BEGIN
2551:
2552: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2555: FND_MSG_PUB.initialize;

2551:
2552: -- Initialize message list if p_init_msg_list is set to TRUE.
2553: IF FND_API.to_Boolean( p_init_msg_list )
2554: THEN
2555: FND_MSG_PUB.initialize;
2556: END IF;
2557:
2558:
2559: -- Initialize API return status to SUCCESS

Line 2569: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,

2565: OPEN C_INTEREST_TYPE_ID_Exists (p_INTEREST_TYPE_ID);
2566: FETCH C_INTEREST_TYPE_ID_Exists into l_val;
2567: IF C_INTEREST_TYPE_ID_Exists%NOTFOUND THEN
2568: IF l_debug THEN
2569: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,
2570: 'Private API: INTEREST_TYPE_ID is invalid');
2571: END IF;
2572: x_return_status := FND_API.G_RET_STS_ERROR;
2573: END IF;

Line 2578: FND_MSG_PUB.Count_And_Get

2574: CLOSE C_INTEREST_TYPE_ID_Exists;
2575: END IF;
2576:
2577: -- Standard call to get message count and if count is 1, get message info.
2578: FND_MSG_PUB.Count_And_Get
2579: ( p_count => x_msg_count,
2580: p_data => x_msg_data
2581: );
2582:

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

2599: FROM as_interest_codes_v
2600: WHERE interest_code_id = c_primary_interest_code_id;
2601:
2602: l_val VARCHAR2(1);
2603: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
2604:
2605: BEGIN
2606:
2607: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2610: FND_MSG_PUB.initialize;

2606:
2607: -- Initialize message list if p_init_msg_list is set to TRUE.
2608: IF FND_API.to_Boolean( p_init_msg_list )
2609: THEN
2610: FND_MSG_PUB.initialize;
2611: END IF;
2612:
2613:
2614: -- Initialize API return status to SUCCESS

Line 2624: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,

2620: OPEN C_P_INTEREST_CODE_ID_Exists (p_PRIMARY_INTEREST_CODE_ID);
2621: FETCH C_P_INTEREST_CODE_ID_Exists into l_val;
2622: IF C_P_INTEREST_CODE_ID_Exists%NOTFOUND THEN
2623: IF l_debug THEN
2624: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,
2625: 'Private API: PRIMARY_INTEREST_CODE_ID is invalid');
2626: END IF;
2627: x_return_status := FND_API.G_RET_STS_ERROR;
2628: END IF;

Line 2633: FND_MSG_PUB.Count_And_Get

2629: CLOSE C_P_INTEREST_CODE_ID_Exists;
2630: END IF;
2631:
2632: -- Standard call to get message count and if count is 1, get message info.
2633: FND_MSG_PUB.Count_And_Get
2634: ( p_count => x_msg_count,
2635: p_data => x_msg_data
2636: );
2637:

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

2654: FROM as_interest_codes_v
2655: WHERE interest_code_id = C_S_INTEREST_code_id;
2656:
2657: l_val VARCHAR2(1);
2658: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
2659:
2660: BEGIN
2661:
2662: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2665: FND_MSG_PUB.initialize;

2661:
2662: -- Initialize message list if p_init_msg_list is set to TRUE.
2663: IF FND_API.to_Boolean( p_init_msg_list )
2664: THEN
2665: FND_MSG_PUB.initialize;
2666: END IF;
2667:
2668:
2669: -- Initialize API return status to SUCCESS

Line 2680: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,

2676: FETCH C_S_INTEREST_CODE_ID_Exists into l_val;
2677: IF C_S_INTEREST_CODE_ID_Exists%NOTFOUND THEN
2678:
2679: IF l_debug THEN
2680: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,
2681: 'Private API: SECONDARY_INTEREST_CODE_ID is invalid');
2682: END IF;
2683:
2684: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2690: FND_MSG_PUB.Count_And_Get

2686: CLOSE C_S_INTEREST_CODE_ID_Exists;
2687: END IF;
2688:
2689: -- Standard call to get message count and if count is 1, get message info.
2690: FND_MSG_PUB.Count_And_Get
2691: ( p_count => x_msg_count,
2692: p_data => x_msg_data
2693: );
2694:

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

2712: FROM AS_LEAD_LINES_ALL
2713: WHERE LEAD_LINE_ID = l_lead_line_id;
2714:
2715: l_val VARCHAR2(1);
2716: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
2717: l_old_product_category_id NUMBER;
2718: l_old_product_cat_set_id NUMBER;
2719: l_return_status VARCHAR2(1);
2720: l_prod_cat_fields_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 2728: FND_MSG_PUB.initialize;

2724:
2725: -- Initialize message list if p_init_msg_list is set to TRUE.
2726: IF FND_API.to_Boolean( p_init_msg_list )
2727: THEN
2728: FND_MSG_PUB.initialize;
2729: END IF;
2730:
2731:
2732: -- Initialize API return status to SUCCESS

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

2732: -- Initialize API return status to SUCCESS
2733: l_return_status := FND_API.G_RET_STS_SUCCESS;
2734:
2735: IF l_debug THEN
2736: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
2737: 'Private API: Validating product category '|| P_CATEGORY_SET_ID ||'+'||P_CATEGORY_ID);
2738: END IF;
2739:
2740:

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

2742: or (P_CATEGORY_ID = FND_API.G_MISS_NUM))
2743: THEN
2744: l_return_status := FND_API.G_RET_STS_ERROR;
2745:
2746: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2747: THEN
2748: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
2749: FND_MESSAGE.Set_Token('COLUMN', 'PRODUCT_CATEGORY_ID', FALSE);
2750: FND_MSG_PUB.ADD;

Line 2750: FND_MSG_PUB.ADD;

2746: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2747: THEN
2748: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
2749: FND_MESSAGE.Set_Token('COLUMN', 'PRODUCT_CATEGORY_ID', FALSE);
2750: FND_MSG_PUB.ADD;
2751: END IF;
2752: ELSIF ((P_CATEGORY_SET_ID is NULL)
2753: or (P_CATEGORY_SET_ID = FND_API.G_MISS_NUM))
2754: THEN

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

2753: or (P_CATEGORY_SET_ID = FND_API.G_MISS_NUM))
2754: THEN
2755: l_return_status := FND_API.G_RET_STS_ERROR;
2756:
2757: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2758: THEN
2759: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
2760: FND_MESSAGE.Set_Token('COLUMN', 'PRODUCT_CAT_SET_ID', FALSE);
2761: FND_MSG_PUB.ADD;

Line 2761: FND_MSG_PUB.ADD;

2757: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2758: THEN
2759: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
2760: FND_MESSAGE.Set_Token('COLUMN', 'PRODUCT_CAT_SET_ID', FALSE);
2761: FND_MSG_PUB.ADD;
2762: END IF;
2763: ELSE
2764: -- Insure that all ids are valid
2765: --

Line 2793: FND_MSG_PUB.Count_And_Get

2789: END IF;
2790: END IF;
2791:
2792: -- Standard call to get message count and if count is 1, get message info.
2793: FND_MSG_PUB.Count_And_Get
2794: ( p_count => x_msg_count,
2795: p_data => x_msg_data
2796: );
2797:

Line 2844: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_ERROR)

2840: FETCH C_Prod_Cat_Exists_And_Valid INTO l_variable;
2841:
2842: IF (C_Prod_Cat_Exists_And_Valid%NOTFOUND)
2843: THEN
2844: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_ERROR)
2845: THEN
2846: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
2847: FND_MESSAGE.Set_Token('COLUMN', 'PRODUCT_CATEGORY', FALSE);
2848: FND_MESSAGE.Set_Token('VALUE', p_product_category_id, FALSE);

Line 2849: FND_MSG_PUB.Add;

2845: THEN
2846: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
2847: FND_MESSAGE.Set_Token('COLUMN', 'PRODUCT_CATEGORY', FALSE);
2848: FND_MESSAGE.Set_Token('VALUE', p_product_category_id, FALSE);
2849: FND_MSG_PUB.Add;
2850: END IF;
2851:
2852: l_return_status := FND_API.G_RET_STS_ERROR;
2853: END IF;

Line 2861: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_ERROR)

2857: FETCH C_Prod_Cat_Exists INTO l_variable;
2858:
2859: IF (C_Prod_Cat_Exists%NOTFOUND)
2860: THEN
2861: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_ERROR)
2862: THEN
2863: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
2864: FND_MESSAGE.Set_Token('COLUMN', 'PRODUCT_CATEGORY', FALSE);
2865: FND_MESSAGE.Set_Token('VALUE', p_product_category_id, FALSE);

Line 2866: FND_MSG_PUB.Add;

2862: THEN
2863: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
2864: FND_MESSAGE.Set_Token('COLUMN', 'PRODUCT_CATEGORY', FALSE);
2865: FND_MESSAGE.Set_Token('VALUE', p_product_category_id, FALSE);
2866: FND_MSG_PUB.Add;
2867: END IF;
2868:
2869: l_return_status := FND_API.G_RET_STS_ERROR;
2870: END IF;

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

2891: FROM mtl_system_items
2892: WHERE inventory_item_id = c_inventory_item_id;
2893:
2894: l_val VARCHAR2(1);
2895: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
2896:
2897: l_module CONSTANT VARCHAR2(255) := 'as.plsql.ldlpv.Validate_INVENTORY_ITEM_ID';
2898: BEGIN
2899:

Line 2903: FND_MSG_PUB.initialize;

2899:
2900: -- Initialize message list if p_init_msg_list is set to TRUE.
2901: IF FND_API.to_Boolean( p_init_msg_list )
2902: THEN
2903: FND_MSG_PUB.initialize;
2904: END IF;
2905:
2906:
2907: -- Initialize API return status to SUCCESS

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

2914: FETCH C_INVENTORY_ITEM_ID_Exists into l_val;
2915: IF C_INVENTORY_ITEM_ID_Exists%NOTFOUND THEN
2916:
2917: IF l_debug THEN
2918: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
2919: 'Private API: INVENTORY_ITEM_ID is invalid');
2920: END IF;
2921: x_return_status := FND_API.G_RET_STS_ERROR;
2922: END IF;

Line 2927: FND_MSG_PUB.Count_And_Get

2923: CLOSE C_INVENTORY_ITEM_ID_Exists;
2924: END IF;
2925:
2926: -- Standard call to get message count and if count is 1, get message info.
2927: FND_MSG_PUB.Count_And_Get
2928: ( p_count => x_msg_count,
2929: p_data => x_msg_data
2930: );
2931:

Line 2950: FND_MSG_PUB.initialize;

2946:
2947: -- Initialize message list if p_init_msg_list is set to TRUE.
2948: IF FND_API.to_Boolean( p_init_msg_list )
2949: THEN
2950: FND_MSG_PUB.initialize;
2951: END IF;
2952:
2953:
2954: -- Initialize API return status to SUCCESS

Line 2974: FND_MSG_PUB.Count_And_Get

2970: NULL;
2971: END IF;
2972:
2973: -- Standard call to get message count and if count is 1, get message info.
2974: FND_MSG_PUB.Count_And_Get
2975: ( p_count => x_msg_count,
2976: p_data => x_msg_data
2977: );
2978:

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

2995: FROM mtl_units_of_measure
2996: WHERE uom_code = c_uom_code;
2997:
2998: l_val VARCHAR2(1);
2999: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
3000:
3001: l_module CONSTANT VARCHAR2(255) := 'as.plsql.ldlpv.Validate_UOM_CODE';
3002: BEGIN
3003:

Line 3007: FND_MSG_PUB.initialize;

3003:
3004: -- Initialize message list if p_init_msg_list is set to TRUE.
3005: IF FND_API.to_Boolean( p_init_msg_list )
3006: THEN
3007: FND_MSG_PUB.initialize;
3008: END IF;
3009:
3010: -- Initialize API return status to SUCCESS
3011: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

3016: OPEN C_UOM_CODE_Exists (p_UOM_CODE);
3017: FETCH C_UOM_CODE_Exists into l_val;
3018: IF C_UOM_CODE_Exists%NOTFOUND THEN
3019: IF l_debug THEN
3020: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
3021: 'Private API: UOM_CODE is invalid');
3022: END IF;
3023:
3024: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3030: FND_MSG_PUB.Count_And_Get

3026: CLOSE C_UOM_CODE_Exists;
3027: END IF;
3028:
3029: -- Standard call to get message count and if count is 1, get message info.
3030: FND_MSG_PUB.Count_And_Get
3031: ( p_count => x_msg_count,
3032: p_data => x_msg_data
3033: );
3034:

Line 3053: FND_MSG_PUB.initialize;

3049:
3050: -- Initialize message list if p_init_msg_list is set to TRUE.
3051: IF FND_API.to_Boolean( p_init_msg_list )
3052: THEN
3053: FND_MSG_PUB.initialize;
3054: END IF;
3055:
3056:
3057: -- Initialize API return status to SUCCESS

Line 3077: FND_MSG_PUB.Count_And_Get

3073: NULL;
3074: END IF;
3075:
3076: -- Standard call to get message count and if count is 1, get message info.
3077: FND_MSG_PUB.Count_And_Get
3078: ( p_count => x_msg_count,
3079: p_data => x_msg_data
3080: );
3081:

Line 3100: FND_MSG_PUB.initialize;

3096:
3097: -- Initialize message list if p_init_msg_list is set to TRUE.
3098: IF FND_API.to_Boolean( p_init_msg_list )
3099: THEN
3100: FND_MSG_PUB.initialize;
3101: END IF;
3102:
3103:
3104: -- Initialize API return status to SUCCESS

Line 3124: FND_MSG_PUB.Count_And_Get

3120: NULL;
3121: END IF;
3122:
3123: -- Standard call to get message count and if count is 1, get message info.
3124: FND_MSG_PUB.Count_And_Get
3125: ( p_count => x_msg_count,
3126: p_data => x_msg_data
3127: );
3128:

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

3139: X_Msg_Data OUT NOCOPY VARCHAR2
3140: )
3141: IS
3142:
3143: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
3144:
3145: l_module CONSTANT VARCHAR2(255) := 'as.plsql.ldlpv.Validate_QUOTED_LINE_FLAG';
3146: BEGIN
3147:

Line 3151: FND_MSG_PUB.initialize;

3147:
3148: -- Initialize message list if p_init_msg_list is set to TRUE.
3149: IF FND_API.to_Boolean( p_init_msg_list )
3150: THEN
3151: FND_MSG_PUB.initialize;
3152: END IF;
3153:
3154:
3155: -- Initialize API return status to SUCCESS

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

3161: IF (UPPER(p_QUOTED_LINE_FLAG) <> 'Y') and
3162: (UPPER(p_QUOTED_LINE_FLAG) <> 'N')
3163: THEN
3164: IF l_debug THEN
3165: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
3166: 'Private API: QUOTED_LINE_FLAG is invalid');
3167: END IF;
3168:
3169: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3174: FND_MSG_PUB.Count_And_Get

3170: END IF;
3171: END IF;
3172:
3173: -- Standard call to get message count and if count is 1, get message info.
3174: FND_MSG_PUB.Count_And_Get
3175: ( p_count => x_msg_count,
3176: p_data => x_msg_data
3177: );
3178:

Line 3197: FND_MSG_PUB.initialize;

3193:
3194: -- Initialize message list if p_init_msg_list is set to TRUE.
3195: IF FND_API.to_Boolean( p_init_msg_list )
3196: THEN
3197: FND_MSG_PUB.initialize;
3198: END IF;
3199:
3200:
3201: -- Initialize API return status to SUCCESS

Line 3221: FND_MSG_PUB.Count_And_Get

3217: NULL;
3218: END IF;
3219:
3220: -- Standard call to get message count and if count is 1, get message info.
3221: FND_MSG_PUB.Count_And_Get
3222: ( p_count => x_msg_count,
3223: p_data => x_msg_data
3224: );
3225:

Line 3244: FND_MSG_PUB.initialize;

3240:
3241: -- Initialize message list if p_init_msg_list is set to TRUE.
3242: IF FND_API.to_Boolean( p_init_msg_list )
3243: THEN
3244: FND_MSG_PUB.initialize;
3245: END IF;
3246:
3247:
3248: -- Initialize API return status to SUCCESS

Line 3268: FND_MSG_PUB.Count_And_Get

3264: NULL;
3265: END IF;
3266:
3267: -- Standard call to get message count and if count is 1, get message info.
3268: FND_MSG_PUB.Count_And_Get
3269: ( p_count => x_msg_count,
3270: p_data => x_msg_data
3271: );
3272:

Line 3291: FND_MSG_PUB.initialize;

3287:
3288: -- Initialize message list if p_init_msg_list is set to TRUE.
3289: IF FND_API.to_Boolean( p_init_msg_list )
3290: THEN
3291: FND_MSG_PUB.initialize;
3292: END IF;
3293:
3294:
3295: -- Initialize API return status to SUCCESS

Line 3315: FND_MSG_PUB.Count_And_Get

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

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

3336: FROM as_lead_lines
3337: WHERE lead_line_id = c_o_opportunity_line_id;
3338:
3339: l_val VARCHAR2(1);
3340: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
3341:
3342: l_module CONSTANT VARCHAR2(255) := 'as.plsql.ldlpv.Validate_O_OPPORTUNITY_LINE_ID';
3343: BEGIN
3344:

Line 3348: FND_MSG_PUB.initialize;

3344:
3345: -- Initialize message list if p_init_msg_list is set to TRUE.
3346: IF FND_API.to_Boolean( p_init_msg_list )
3347: THEN
3348: FND_MSG_PUB.initialize;
3349: END IF;
3350:
3351:
3352: -- Initialize API return status to SUCCESS

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

3358: OPEN C_O_OPPORTUNITY_LINE_ID_Exists (p_O_OPPORTUNITY_LINE_ID);
3359: FETCH C_O_OPPORTUNITY_LINE_ID_Exists into l_val;
3360: IF C_O_OPPORTUNITY_LINE_ID_Exists%NOTFOUND THEN
3361: IF l_debug THEN
3362: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
3363: 'Private API: O_OPPORTUNITY_LINE_ID is invalid');
3364: END IF;
3365: x_return_status := FND_API.G_RET_STS_ERROR;
3366: END IF;

Line 3371: FND_MSG_PUB.Count_And_Get

3367: CLOSE C_O_OPPORTUNITY_LINE_ID_Exists;
3368: END IF;
3369:
3370: -- Standard call to get message count and if count is 1, get message info.
3371: FND_MSG_PUB.Count_And_Get
3372: ( p_count => x_msg_count,
3373: p_data => x_msg_data
3374: );
3375:

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

3404: -- Condition changed to include One Off Events.
3405: AND source_type <> 'OFFR';
3406:
3407: l_val VARCHAR2(1);
3408: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
3409:
3410: l_module CONSTANT VARCHAR2(255) := 'as.plsql.ldlpv.Validate_SOURCE_PROMOTION_ID';
3411: BEGIN
3412:

Line 3416: FND_MSG_PUB.initialize;

3412:
3413: -- Initialize message list if p_init_msg_list is set to TRUE.
3414: IF FND_API.to_Boolean( p_init_msg_list )
3415: THEN
3416: FND_MSG_PUB.initialize;
3417: END IF;
3418:
3419:
3420: -- Initialize API return status to SUCCESS

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

3426: -- SOURCE_PROMOTION_ID should exist in ams_source_codes
3427: OPEN C_SOURCE_PROMOTION_ID_Exists (p_SOURCE_PROMOTION_ID);
3428: FETCH C_SOURCE_PROMOTION_ID_Exists into l_val;
3429: IF C_SOURCE_PROMOTION_ID_Exists%NOTFOUND THEN
3430: --AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,
3431: -- 'Private API: SOURCE_PROMOTION_ID is invalid');
3432:
3433: AS_UTILITY_PVT.Set_Message(
3434: p_module => l_module,

Line 3435: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

3431: -- 'Private API: SOURCE_PROMOTION_ID is invalid');
3432:
3433: AS_UTILITY_PVT.Set_Message(
3434: p_module => l_module,
3435: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
3436: p_msg_name => 'API_INVALID_SOURCE_PROM_ID',
3437: p_token1 => 'VALUE',
3438: p_token1_value => p_SOURCE_PROMOTION_ID );
3439:

Line 3446: FND_MSG_PUB.Count_And_Get

3442: CLOSE C_SOURCE_PROMOTION_ID_Exists;
3443: END IF;
3444:
3445: -- Standard call to get message count and if count is 1, get message info.
3446: FND_MSG_PUB.Count_And_Get
3447: ( p_count => x_msg_count,
3448: p_data => x_msg_data
3449: );
3450:

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

3479: AND a.source_code_id = c_OFFER_ID;
3480:
3481:
3482: l_val VARCHAR2(1);
3483: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
3484:
3485: l_module CONSTANT VARCHAR2(255) := 'as.plsql.ldlpv.Validate_OFFER_ID';
3486: BEGIN
3487:

Line 3491: FND_MSG_PUB.initialize;

3487:
3488: -- Initialize message list if p_init_msg_list is set to TRUE.
3489: IF FND_API.to_Boolean( p_init_msg_list )
3490: THEN
3491: FND_MSG_PUB.initialize;
3492: END IF;
3493:
3494:
3495: -- Initialize API return status to SUCCESS

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

3502: OPEN C_OFFER_ID_Exists (p_OFFER_ID);
3503: FETCH C_OFFER_ID_Exists into l_val;
3504: IF C_OFFER_ID_Exists%NOTFOUND THEN
3505: IF l_debug THEN
3506: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
3507: 'Private API: OFFER_ID is invalid');
3508: END IF;
3509: x_return_status := FND_API.G_RET_STS_ERROR;
3510: END IF;

Line 3515: FND_MSG_PUB.Count_And_Get

3511: CLOSE C_OFFER_ID_Exists;
3512: END IF;
3513:
3514: -- Standard call to get message count and if count is 1, get message info.
3515: FND_MSG_PUB.Count_And_Get
3516: ( p_count => x_msg_count,
3517: p_data => x_msg_data
3518: );
3519:

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

3566:
3567: l_val VARCHAR2(1);
3568: l_return_status VARCHAR2(1);
3569: l_api_name CONSTANT VARCHAR2(30) := 'Validate_line_rec';
3570: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
3571:
3572:
3573: l_module CONSTANT VARCHAR2(255) := 'as.plsql.ldlpv.Validate_Line_rec';
3574: BEGIN

Line 3579: FND_MSG_PUB.initialize;

3575:
3576: -- Initialize message list if p_init_msg_list is set to TRUE.
3577: IF FND_API.to_Boolean( p_init_msg_list )
3578: THEN
3579: FND_MSG_PUB.initialize;
3580: END IF;
3581:
3582: -- Debug Message
3583: IF l_debug THEN

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

3580: END IF;
3581:
3582: -- Debug Message
3583: IF l_debug THEN
3584: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3585: 'Private API: ' || l_api_name || ' start');
3586:
3587: END IF;
3588:

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

3596: ( p_line_rec.organization_id is NULL or
3597: p_line_rec.organization_id = FND_API.G_MISS_NUM )
3598: THEN
3599: IF l_debug THEN
3600: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
3601: 'Private API: ORGANIZATION_ID is missing');
3602:
3603: END IF;
3604:

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

3601: 'Private API: ORGANIZATION_ID is missing');
3602:
3603: END IF;
3604:
3605: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3606: THEN
3607: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
3608: FND_MESSAGE.Set_Token('COLUMN', 'ORGANIZATION_ID', FALSE);
3609: FND_MSG_PUB.ADD;

Line 3609: FND_MSG_PUB.ADD;

3605: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3606: THEN
3607: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
3608: FND_MESSAGE.Set_Token('COLUMN', 'ORGANIZATION_ID', FALSE);
3609: FND_MSG_PUB.ADD;
3610: END IF;
3611:
3612: x_return_status := FND_API.G_RET_STS_ERROR;
3613: ELSIF p_line_rec.inventory_item_id is NOT NULL and

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

3619: FETCH C_Inventory_Item_Exists into l_val;
3620: IF C_Inventory_Item_Exists%NOTFOUND
3621: THEN
3622: IF l_debug THEN
3623: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
3624: 'Private API: INVENTORY_ITEM_ID is invalid');
3625: END IF;
3626:
3627: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

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

3623: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
3624: 'Private API: INVENTORY_ITEM_ID is invalid');
3625: END IF;
3626:
3627: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3628: THEN
3629: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
3630: FND_MESSAGE.Set_Token('COLUMN', 'INVENTORY_ITEM_ID', FALSE);
3631: FND_MESSAGE.Set_Token('VALUE', p_line_rec.inventory_item_id, FALSE);

Line 3632: FND_MSG_PUB.ADD;

3628: THEN
3629: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ID');
3630: FND_MESSAGE.Set_Token('COLUMN', 'INVENTORY_ITEM_ID', FALSE);
3631: FND_MESSAGE.Set_Token('VALUE', p_line_rec.inventory_item_id, FALSE);
3632: FND_MSG_PUB.ADD;
3633: END IF;
3634:
3635: x_return_status := FND_API.G_RET_STS_ERROR;
3636: END IF;

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

3647: FETCH C_Category_Item_Exists into l_val;
3648: IF C_Category_Item_Exists%NOTFOUND
3649: THEN
3650: IF l_debug THEN
3651: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
3652: 'Private API: Inventory item doesnot match category');
3653: END IF;
3654:
3655: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

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

3651: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
3652: 'Private API: Inventory item doesnot match category');
3653: END IF;
3654:
3655: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3656: THEN
3657: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ITEM_CATEGORY');
3658: FND_MSG_PUB.ADD;
3659: END IF;

Line 3658: FND_MSG_PUB.ADD;

3654:
3655: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3656: THEN
3657: FND_MESSAGE.Set_Name('AS', 'API_INVALID_ITEM_CATEGORY');
3658: FND_MSG_PUB.ADD;
3659: END IF;
3660: x_return_status := FND_API.G_RET_STS_ERROR;
3661: END IF;
3662: CLOSE C_Category_Item_Exists;

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

3664: END IF;
3665:
3666: -- Debug Message
3667: IF l_debug THEN
3668: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3669: 'Private API: ' || l_api_name || ' end');
3670:
3671: END IF;
3672:

Line 3674: FND_MSG_PUB.Count_And_Get

3670:
3671: END IF;
3672:
3673: -- Standard call to get message count and if count is 1, get message info.
3674: FND_MSG_PUB.Count_And_Get
3675: ( p_count => x_msg_count,
3676: p_data => x_msg_data
3677: );
3678:

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

3690: )
3691: IS
3692: l_api_name CONSTANT VARCHAR2(30) := 'Validate_opp_line';
3693: x_item_property_rec AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE;
3694: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
3695:
3696: l_module CONSTANT VARCHAR2(255) := 'as.plsql.ldlpv.Validate_opp_line';
3697: BEGIN
3698:

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

3697: BEGIN
3698:
3699: -- Debug Message
3700: IF l_debug THEN
3701: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3702: 'Private API: ' || l_api_name || ' start');
3703: END IF;
3704:
3705:

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

3714: ( p_line_rec.organization_id is NULL or
3715: p_line_rec.organization_id = FND_API.G_MISS_NUM )
3716: THEN
3717: IF l_debug THEN
3718: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
3719: 'Private API: ORGANIZATION_ID is missing');
3720:
3721: END IF;
3722:

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

3719: 'Private API: ORGANIZATION_ID is missing');
3720:
3721: END IF;
3722:
3723: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3724: THEN
3725: FND_MESSAGE.Set_Name('AS', 'AS_INV_ORG_NULL');
3726: FND_MSG_PUB.ADD;
3727: END IF;

Line 3726: FND_MSG_PUB.ADD;

3722:
3723: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3724: THEN
3725: FND_MESSAGE.Set_Name('AS', 'AS_INV_ORG_NULL');
3726: FND_MSG_PUB.ADD;
3727: END IF;
3728:
3729: x_return_status := FND_API.G_RET_STS_ERROR;
3730: raise FND_API.G_EXC_ERROR;

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

3734: -- Hint: We provide validation procedure for every column. Developer
3735: -- should delete unnecessary validation procedures.
3736:
3737: IF l_debug THEN
3738: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3739: 'Private API: Validate Items start');
3740: END IF;
3741:
3742: Validate_LEAD_LINE_ID(

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

3750: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3751: raise FND_API.G_EXC_ERROR;
3752: END IF;
3753: IF l_debug THEN
3754: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3755: 'Private API: Validated LEAD_LINE_ID');
3756: END IF;
3757:
3758: Validate_LEAD_ID(

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

3766: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3767: raise FND_API.G_EXC_ERROR;
3768: END IF;
3769: IF l_debug THEN
3770: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3771: 'Private API: Validated LEAD_ID');
3772: END IF;
3773:
3774:

Line 3788: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3784: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3785: raise FND_API.G_EXC_ERROR;
3786: END IF;
3787: IF l_debug THEN
3788: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3789: 'Private API: Validated INTEREST_TYPE_ID');
3790: END IF;
3791: */
3792:

Line 3806: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3802: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3803: raise FND_API.G_EXC_ERROR;
3804: END IF;
3805: IF l_debug THEN
3806: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3807: 'Private API: Validated P_INTEREST_CODE_ID');
3808: END IF;
3809: */
3810:

Line 3825: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3821: raise FND_API.G_EXC_ERROR;
3822: END IF;
3823:
3824: IF l_debug THEN
3825: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3826: 'Private API: Validated S_INTEREST_CODE_ID');
3827: END IF;
3828: */
3829: Validate_PRODUCT_CATEGORY(

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

3840: raise FND_API.G_EXC_ERROR;
3841: END IF;
3842:
3843: IF l_debug THEN
3844: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3845: 'Private API: Validated PRODUCT_CATEGORY_ID');
3846: END IF;
3847:
3848:

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

3884: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3885: raise FND_API.G_EXC_ERROR;
3886: END IF;
3887: IF l_debug THEN
3888: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3889: 'Private API: Validated UOM_CODE');
3890: END IF;
3891:
3892:

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

3929: raise FND_API.G_EXC_ERROR;
3930: END IF;
3931:
3932: IF l_debug THEN
3933: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3934: 'Private API: Validated QUOTED_LINE_FLAG');
3935: END IF;
3936:
3937:

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

3985: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3986: raise FND_API.G_EXC_ERROR;
3987: END IF;
3988: IF l_debug THEN
3989: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3990: 'Private API: Validated SOURCE_PROMOTION_ID');
3991: END IF;
3992:
3993:

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

4004: raise FND_API.G_EXC_ERROR;
4005: END IF;
4006:
4007: IF l_debug THEN
4008: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4009: 'Private API: Validated OFFER_ID');
4010: END IF;
4011:
4012:

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

4011:
4012:
4013:
4014: IF l_debug THEN
4015: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4016: 'Private API: Validate Items end');
4017: END IF;
4018:
4019: END IF;

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

4048:
4049:
4050: -- Debug Message
4051: IF l_debug THEN
4052: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4053: 'Private API: ' || l_api_name || ' end');
4054: END IF;
4055:
4056: END Validate_opp_line;