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

Line 18: AS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

14: -- 3. get active scoreCard rules
15: -- 4. score the lead
16: -- 5. get rank based from score
17: -- 6. update the sales lead with the new score
18: AS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
19: AS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
20: AS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
21: AS_DEBUG_ERROR_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR);
22:

Line 19: AS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

15: -- 4. score the lead
16: -- 5. get rank based from score
17: -- 6. update the sales lead with the new score
18: AS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
19: AS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
20: AS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
21: AS_DEBUG_ERROR_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR);
22:
23: Procedure Get_Score (

Line 20: AS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

16: -- 5. get rank based from score
17: -- 6. update the sales lead with the new score
18: AS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
19: AS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
20: AS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
21: AS_DEBUG_ERROR_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR);
22:
23: Procedure Get_Score (
24: p_api_version IN NUMBER := 2.0,

Line 21: AS_DEBUG_ERROR_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR);

17: -- 6. update the sales lead with the new score
18: AS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
19: AS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
20: AS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
21: AS_DEBUG_ERROR_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR);
22:
23: Procedure Get_Score (
24: p_api_version IN NUMBER := 2.0,
25: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

Line 89: FND_MSG_PUB.initialize;

85:
86: -- Initialize message list if p_init_msg_list is set to TRUE.
87: IF FND_API.to_Boolean( p_init_msg_list )
88: THEN
89: FND_MSG_PUB.initialize;
90: END IF;
91:
92: -- Debug Message
93: IF (AS_DEBUG_LOW_ON) THEN

Line 94: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

90: END IF;
91:
92: -- Debug Message
93: IF (AS_DEBUG_LOW_ON) THEN
94: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
95: 'PVT:' || l_api_name || ' start');
96: END IF;
97:
98: -- Initialize API return status to SUCCESS

Line 149: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

145: END IF;
146:
147: -- Debug Message
148: IF (AS_DEBUG_LOW_ON) THEN
149: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
150: 'PVT: ' || l_api_name || ' end');
151: END IF;
152:
153: FND_MSG_PUB.Count_And_Get

Line 153: FND_MSG_PUB.Count_And_Get

149: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
150: 'PVT: ' || l_api_name || ' end');
151: END IF;
152:
153: FND_MSG_PUB.Count_And_Get
154: ( p_count => x_msg_count,
155: p_data => x_msg_data );
156:
157: EXCEPTION

Line 162: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

158: WHEN FND_API.G_EXC_ERROR THEN
159: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
160: P_API_NAME => L_API_NAME
161: ,P_PKG_NAME => G_PKG_NAME
162: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
163: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
164: ,X_MSG_COUNT => X_MSG_COUNT
165: ,X_MSG_DATA => X_MSG_DATA
166: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 172: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

168: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
169: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
170: P_API_NAME => L_API_NAME
171: ,P_PKG_NAME => G_PKG_NAME
172: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
173: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
174: ,X_MSG_COUNT => X_MSG_COUNT
175: ,X_MSG_DATA => X_MSG_DATA
176: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 427: FND_MSG_PUB.initialize;

423:
424: -- Initialize message list if p_init_msg_list is set to TRUE.
425: IF FND_API.to_Boolean( p_init_msg_list )
426: THEN
427: FND_MSG_PUB.initialize;
428: END IF;
429:
430: -- Debug Message
431: IF (AS_DEBUG_LOW_ON) THEN

Line 433: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

429:
430: -- Debug Message
431: IF (AS_DEBUG_LOW_ON) THEN
432:
433: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
434: 'PVT:' || l_api_name || 'start');
435: END IF;
436:
437: -- Initialize API return status to SUCCESS

Line 458: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

454: IF (AS_DEBUG_LOW_ON) THEN
455:
456:
457:
458: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
459: 'l_val: '||l_val);
460:
461: END IF;
462: IF c_default_scorecard%NOTFOUND THEN

Line 467: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

463: -- ffang 082801, use a more meaning message
464: -- note: It is assumed that if no valid scorecard id passed in, then
465: -- the profile for default scorecard is not set.
466: AS_UTILITY_PVT.Set_Message(
467: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
468: p_msg_name => 'AS_NO_DEFAULT_SCORECARD'); --'AS_INVALID_SCD_ID',
469: --p_token1 => 'SCD_ID',
470: --p_token1_value => l_scorecard_id);
471:

Line 481: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

477: -- ffang 082801, use a more meaning message
478: -- note: It is assumed that if no valid scorecard id passed in, then
479: -- the profile for default scorecard is not set.
480: AS_UTILITY_PVT.Set_Message(
481: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
482: p_msg_name => 'AS_NO_DEFAULT_SCORECARD'); --'API_MISSING_ID',
483: --p_token1 => 'COLUMN',
484: --p_token1_value => 'SCORECARD_ID');
485:

Line 496: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

492: IF (AS_DEBUG_LOW_ON) THEN
493:
494:
495:
496: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
497: 'scorecard_id : ' || l_scorecard_id);
498:
499: END IF;
500: -- end ffang 052201

Line 515: -- FND_MSG_PUB.Add;

511: -- Then
512: --dbms_output.put_line('No active or too many active scorecards enabled');
513: -- Close C_Validate_ScoreCards;
514: -- FND_MESSAGE.Set_Name('AS', 'AS_NO_SCD_ENABLED');
515: -- FND_MSG_PUB.Add;
516: --raise FND_API.G_EXC_ERROR;
517: -- kmahajan 5/5/1
518: -- want to return a Warning without any further processing
519: l_return_status := 'W';

Line 534: -- FND_MSG_PUB.Add;

530: -- end if;
531: -- if l_default_scorecard_id is null then
532: -- Close C_Validate_ScoreCards;
533: -- FND_MESSAGE.Set_Name('AS', 'MULTIPLE_SCD_ENABLED');
534: -- FND_MSG_PUB.Add;
535: --raise FND_API.G_EXC_ERROR;
536: -- kmahajan 5/5/1
537: -- want to return a Warning without any further processing
538: -- l_return_status := 'W';

Line 562: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

558: IF l_call_user_hook
559: THEN
560: IF (AS_DEBUG_LOW_ON) THEN
561:
562: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
563: 'Call user_hook is true');
564: END IF;
565: AS_SCORECARD_CUHK.Get_Score_Pre(
566: p_api_version_number => 2.0,

Line 592: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

588: IF (AS_DEBUG_LOW_ON) THEN
589:
590:
591:
592: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
593: 'Getting lead info');
594:
595: END IF;
596: -- get the information for this lead needed to calculate the score

Line 608: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

604: IF (AS_DEBUG_LOW_ON) THEN
605:
606:
607:
608: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
609: 'Contact Count = ' || l_contacts_count);
610:
611: END IF;
612: if l_contacts_count = 1 then

Line 673: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

669: IF (AS_DEBUG_LOW_ON) THEN
670:
671:
672:
673: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
674: 'LAST_UPDATE_DATE ' || l_LAST_UPDATE_DATE);
675:
676: END IF;
677: IF (AS_DEBUG_LOW_ON) THEN

Line 679: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

675:
676: END IF;
677: IF (AS_DEBUG_LOW_ON) THEN
678:
679: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
680: 'CONTACT_ROLE_CODE = ' || l_CONTACT_ROLE_CODE);
681: END IF;
682: IF (AS_DEBUG_LOW_ON) THEN
683:

Line 684: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

680: 'CONTACT_ROLE_CODE = ' || l_CONTACT_ROLE_CODE);
681: END IF;
682: IF (AS_DEBUG_LOW_ON) THEN
683:
684: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
685: 'CUSTOMER_NAME = ' || l_CUSTOMER_NAME);
686: END IF;
687: IF (AS_DEBUG_LOW_ON) THEN
688:

Line 689: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

685: 'CUSTOMER_NAME = ' || l_CUSTOMER_NAME);
686: END IF;
687: IF (AS_DEBUG_LOW_ON) THEN
688:
689: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
690: 'CHANNEL_CODE = ' || l_CHANNEL_CODE);
691: END IF;
692: IF (AS_DEBUG_LOW_ON) THEN
693:

Line 694: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

690: 'CHANNEL_CODE = ' || l_CHANNEL_CODE);
691: END IF;
692: IF (AS_DEBUG_LOW_ON) THEN
693:
694: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
695: 'BUDGET_AMOUNT = ' || l_BUDGET_AMOUNT);
696: END IF;
697: IF (AS_DEBUG_LOW_ON) THEN
698:

Line 699: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

695: 'BUDGET_AMOUNT = ' || l_BUDGET_AMOUNT);
696: END IF;
697: IF (AS_DEBUG_LOW_ON) THEN
698:
699: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
700: 'CURRENCY_CODE = ' || l_CURRENCY_CODE);
701: END IF;
702: IF (AS_DEBUG_LOW_ON) THEN
703:

Line 704: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

700: 'CURRENCY_CODE = ' || l_CURRENCY_CODE);
701: END IF;
702: IF (AS_DEBUG_LOW_ON) THEN
703:
704: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
705: 'DECISION_TIMEFRAME_CODE = ' || l_DECISION_TIMEFRAME_CODE);
706: END IF;
707: IF (AS_DEBUG_LOW_ON) THEN
708:

Line 709: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

705: 'DECISION_TIMEFRAME_CODE = ' || l_DECISION_TIMEFRAME_CODE);
706: END IF;
707: IF (AS_DEBUG_LOW_ON) THEN
708:
709: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
710: 'BUDGET_STATUS_CODE = ' || l_BUDGET_STATUS_CODE);
711: END IF;
712: IF (AS_DEBUG_LOW_ON) THEN
713:

Line 714: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

710: 'BUDGET_STATUS_CODE = ' || l_BUDGET_STATUS_CODE);
711: END IF;
712: IF (AS_DEBUG_LOW_ON) THEN
713:
714: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
715: 'SOURCE_PROMOTION_NAME = ' || l_SOURCE_PROMOTION_NAME);
716: END IF;
717: IF (AS_DEBUG_LOW_ON) THEN
718:

Line 719: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

715: 'SOURCE_PROMOTION_NAME = ' || l_SOURCE_PROMOTION_NAME);
716: END IF;
717: IF (AS_DEBUG_LOW_ON) THEN
718:
719: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
720: 'Previous Rank ID => ' || l_PREVIOUS_RANK_ID);
721: END IF;
722: IF (AS_DEBUG_LOW_ON) THEN
723:

Line 724: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

720: 'Previous Rank ID => ' || l_PREVIOUS_RANK_ID);
721: END IF;
722: IF (AS_DEBUG_LOW_ON) THEN
723:
724: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
725: 'Getting rules');
726: END IF;
727: -- get all the rules with their score(s) and values
728: open C_ScoreCard_Rules(l_scoreCard_id);

Line 751: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

747: IF (AS_DEBUG_LOW_ON) THEN
748:
749:
750:
751: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
752: 'v_rules(i).card_rule_id: '||v_rules(i).card_rule_id);
753:
754: END IF;
755:

Line 782: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

778: IF (AS_DEBUG_LOW_ON) THEN
779:
780:
781:
782: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
783: 'score pass ' || i || ' rule = ' || l_rule);
784:
785: END IF;
786: IF (AS_DEBUG_LOW_ON) THEN

Line 788: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

784:
785: END IF;
786: IF (AS_DEBUG_LOW_ON) THEN
787:
788: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
789: 'high rule char value = ' || v_rules(i).high_value_char);
790: END IF;
791: IF (AS_DEBUG_LOW_ON) THEN
792:

Line 793: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

789: 'high rule char value = ' || v_rules(i).high_value_char);
790: END IF;
791: IF (AS_DEBUG_LOW_ON) THEN
792:
793: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
794: 'low rule char value = ' || v_rules(i).low_value_char);
795: END IF;
796:
797: -- customer_name

Line 853: FND_MSG_PUB.Add;

849:
850: -- we have an invalid rule
851: else
852: FND_MESSAGE.Set_Name('AS', 'AS_INVALID_RULE');
853: FND_MSG_PUB.Add;
854: IF (AS_DEBUG_LOW_ON) THEN
855:
856: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
857: 'invalid rule');

Line 856: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

852: FND_MESSAGE.Set_Name('AS', 'AS_INVALID_RULE');
853: FND_MSG_PUB.Add;
854: IF (AS_DEBUG_LOW_ON) THEN
855:
856: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
857: 'invalid rule');
858: END IF;
859: raise FND_API.G_EXC_ERROR;
860: end if;

Line 870: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

866: Close C_ScoreCard_Rules;
867: END IF; -- Compute total score
868: IF (AS_DEBUG_LOW_ON) THEN
869:
870: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
871: 'Total Score = ' || l_total_score);
872: END IF;
873: x_score := l_total_score;
874: l_total_score := to_number(l_total_score) + to_number(nvl(l_marketing_score,0));

Line 880: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Total Score = ' || l_sales_lead_rec.total_score);

876: IF (AS_DEBUG_LOW_ON) THEN
877:
878:
879:
880: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Total Score = ' || l_sales_lead_rec.total_score);
881:
882: END IF;
883: x_score := l_total_score;
884:

Line 892: FND_MSG_PUB.Add;

888: open C_rank(l_total_score);
889: fetch c_rank into l_rank_id;
890: if l_rank_id is null then
891: FND_MESSAGE.Set_Name('AS', 'AS_INVALID_RANK');
892: FND_MSG_PUB.Add;
893: else
894: x_rank_id := l_rank_id;
895: end if;
896: Close C_Rank;

Line 900: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

896: Close C_Rank;
897: end if;
898: IF (AS_DEBUG_LOW_ON) THEN
899:
900: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
901: 'Previous Rank_id = ' || l_previous_rank_id);
902: END IF;
903: IF (AS_DEBUG_LOW_ON) THEN
904:

Line 905: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

901: 'Previous Rank_id = ' || l_previous_rank_id);
902: END IF;
903: IF (AS_DEBUG_LOW_ON) THEN
904:
905: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
906: 'Rank_id = ' || l_rank_id);
907: END IF;
908:
909: -- get the sales lead information to pass into update API

Line 967: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

963: IF (AS_DEBUG_LOW_ON) THEN
964:
965:
966:
967: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
968: 'update_lead status = ' || l_return_status);
969:
970: END IF;
971: end if;

Line 976: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

972:
973: IF l_return_status <> 'S' THEN
974: IF (AS_DEBUG_LOW_ON) THEN
975:
976: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
977: 'Error=====> ' || l_msg_data);
978: END IF;
979: --AST_API.display_error(l_msg_count);
980: x_return_status := l_return_status;

Line 999: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

995:
996: -- Debug Message
997: IF (AS_DEBUG_LOW_ON) THEN
998:
999: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1000: 'PVT: ' || l_api_name || ' end');
1001: END IF;
1002: FND_MSG_PUB.Count_And_Get
1003: ( p_count => x_msg_count,

Line 1002: FND_MSG_PUB.Count_And_Get

998:
999: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1000: 'PVT: ' || l_api_name || ' end');
1001: END IF;
1002: FND_MSG_PUB.Count_And_Get
1003: ( p_count => x_msg_count,
1004: p_data => x_msg_data );
1005:
1006: EXCEPTION

Line 1011: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1007: WHEN FND_API.G_EXC_ERROR THEN
1008: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1009: P_API_NAME => L_API_NAME
1010: ,P_PKG_NAME => G_PKG_NAME
1011: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1012: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1013: ,X_MSG_COUNT => X_MSG_COUNT
1014: ,X_MSG_DATA => X_MSG_DATA
1015: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1021: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1017: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1018: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1019: P_API_NAME => L_API_NAME
1020: ,P_PKG_NAME => G_PKG_NAME
1021: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1022: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1023: ,X_MSG_COUNT => X_MSG_COUNT
1024: ,X_MSG_DATA => X_MSG_DATA
1025: ,X_RETURN_STATUS => X_RETURN_STATUS);