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_API

Line 25: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,
26: p_commit IN VARCHAR2 := FND_API.G_FALSE,
27: p_validation_level IN NUMBER := AS_UTILITY_PUB.G_VALID_LEVEL_ITEM,
28: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
29: p_sales_lead_id IN NUMBER,

Line 26: p_commit IN VARCHAR2 := FND_API.G_FALSE,

22:
23: Procedure Get_Score (
24: p_api_version IN NUMBER := 2.0,
25: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
26: p_commit IN VARCHAR2 := FND_API.G_FALSE,
27: p_validation_level IN NUMBER := AS_UTILITY_PUB.G_VALID_LEVEL_ITEM,
28: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
29: p_sales_lead_id IN NUMBER,
30: p_scorecard_id IN NUMBER,

Line 28: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

24: p_api_version IN NUMBER := 2.0,
25: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
26: p_commit IN VARCHAR2 := FND_API.G_FALSE,
27: p_validation_level IN NUMBER := AS_UTILITY_PUB.G_VALID_LEVEL_ITEM,
28: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
29: p_sales_lead_id IN NUMBER,
30: p_scorecard_id IN NUMBER,
31: -- swkhanna Bug 2260459
32: p_marketing_score IN NUMBER,

Line 78: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

74: -- Standard Start of API savepoint
75: SAVEPOINT GET_SCORE_PVT;
76:
77: -- Standard call to check for call compatibility.
78: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
79: p_api_version,
80: l_api_name,
81: G_PKG_NAME)
82: THEN

Line 83: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

79: p_api_version,
80: l_api_name,
81: G_PKG_NAME)
82: THEN
83: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
84: END IF;
85:
86: -- Initialize message list if p_init_msg_list is set to TRUE.
87: IF FND_API.to_Boolean( p_init_msg_list )

Line 87: IF FND_API.to_Boolean( p_init_msg_list )

83: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
84: END IF;
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:

Line 99: x_return_status := FND_API.G_RET_STS_SUCCESS;

95: 'PVT:' || l_api_name || ' start');
96: END IF;
97:
98: -- Initialize API return status to SUCCESS
99: x_return_status := FND_API.G_RET_STS_SUCCESS;
100:
101: --
102: -- API BODY
103: --

Line 116: P_Init_Msg_List => FND_API.G_FALSE,

112: -- 2. If customer applied iStore 11.5.9, and Leads is still 11.5.9,
113: -- The following code will be called.
114: AS_SALES_LEAD_ENGINE_PVT.Lead_Process_After_Create(
115: P_Api_Version_Number => 2.0,
116: P_Init_Msg_List => FND_API.G_FALSE,
117: p_Commit => FND_API.G_FALSE,
118: p_Validation_Level => p_validation_level,
119: P_Check_Access_Flag => p_check_access_flag,
120: p_Admin_Flag => p_admin_flag,

Line 117: p_Commit => FND_API.G_FALSE,

113: -- The following code will be called.
114: AS_SALES_LEAD_ENGINE_PVT.Lead_Process_After_Create(
115: P_Api_Version_Number => 2.0,
116: P_Init_Msg_List => FND_API.G_FALSE,
117: p_Commit => FND_API.G_FALSE,
118: p_Validation_Level => p_validation_level,
119: P_Check_Access_Flag => p_check_access_flag,
120: p_Admin_Flag => p_admin_flag,
121: P_Admin_Group_Id => p_admin_group_id,

Line 129: IF x_return_status = FND_API.G_RET_STS_SUCCESS OR

125: X_Return_Status => x_return_status,
126: X_Msg_Count => x_msg_count,
127: X_Msg_Data => x_msg_data);
128:
129: IF x_return_status = FND_API.G_RET_STS_SUCCESS OR
130: x_return_status = 'W'
131: THEN
132: -- For iStore, if return status is 'A', it's 11.5.9, don't call
133: -- build_lead_sales_team.

Line 142: IF FND_API.to_Boolean( p_commit )

138: -- End of API body
139: --
140:
141: -- Standard check for p_commit
142: IF FND_API.to_Boolean( p_commit )
143: THEN
144: COMMIT WORK;
145: END IF;
146:

Line 158: WHEN FND_API.G_EXC_ERROR THEN

154: ( p_count => x_msg_count,
155: p_data => x_msg_data );
156:
157: EXCEPTION
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

Line 168: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

164: ,X_MSG_COUNT => X_MSG_COUNT
165: ,X_MSG_DATA => X_MSG_DATA
166: ,X_RETURN_STATUS => X_RETURN_STATUS);
167:
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

Line 193: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

189: -- Comment out the original code because Get_Score is not used in 11.5.9.
190: /*
191: Procedure Get_Score (
192: p_api_version IN NUMBER := 2.0,
193: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
194: p_commit IN VARCHAR2 := FND_API.G_FALSE,
195: p_validation_level IN NUMBER := AS_UTILITY_PUB.G_VALID_LEVEL_ITEM,
196: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
197: p_sales_lead_id IN NUMBER,

Line 194: p_commit IN VARCHAR2 := FND_API.G_FALSE,

190: /*
191: Procedure Get_Score (
192: p_api_version IN NUMBER := 2.0,
193: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
194: p_commit IN VARCHAR2 := FND_API.G_FALSE,
195: p_validation_level IN NUMBER := AS_UTILITY_PUB.G_VALID_LEVEL_ITEM,
196: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
197: p_sales_lead_id IN NUMBER,
198: p_scorecard_id IN NUMBER,

Line 196: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

192: p_api_version IN NUMBER := 2.0,
193: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
194: p_commit IN VARCHAR2 := FND_API.G_FALSE,
195: p_validation_level IN NUMBER := AS_UTILITY_PUB.G_VALID_LEVEL_ITEM,
196: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
197: p_sales_lead_id IN NUMBER,
198: p_scorecard_id IN NUMBER,
199: -- swkhanna Bug 2260459
200: p_marketing_score IN NUMBER,

Line 416: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

412: -- Standard Start of API savepoint
413: SAVEPOINT GET_SCORE_PVT;
414:
415: -- Standard call to check for call compatibility.
416: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
417: p_api_version,
418: l_api_name,
419: G_PKG_NAME)
420: THEN

Line 421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

417: p_api_version,
418: l_api_name,
419: G_PKG_NAME)
420: THEN
421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
422: END IF;
423:
424: -- Initialize message list if p_init_msg_list is set to TRUE.
425: IF FND_API.to_Boolean( p_init_msg_list )

Line 425: IF FND_API.to_Boolean( p_init_msg_list )

421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
422: END IF;
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:

Line 438: l_return_status := FND_API.G_RET_STS_SUCCESS;

434: 'PVT:' || l_api_name || 'start');
435: END IF;
436:
437: -- Initialize API return status to SUCCESS
438: l_return_status := FND_API.G_RET_STS_SUCCESS;
439: x_return_status := FND_API.G_RET_STS_SUCCESS;
440:
441: --
442: -- API BODY

Line 439: x_return_status := FND_API.G_RET_STS_SUCCESS;

435: END IF;
436:
437: -- Initialize API return status to SUCCESS
438: l_return_status := FND_API.G_RET_STS_SUCCESS;
439: x_return_status := FND_API.G_RET_STS_SUCCESS;
440:
441: --
442: -- API BODY
443: --

Line 446: IF (p_scorecard_id IS NOT NULL and p_scorecard_id<>FND_API.G_MISS_NUM)

442: -- API BODY
443: --
444:
445: -- ffang 052201, scorecard id should be past in, if not, error out
446: IF (p_scorecard_id IS NOT NULL and p_scorecard_id<>FND_API.G_MISS_NUM)
447: THEN
448: l_scorecard_id := p_scorecard_id;
449:
450: -- validate scorecard_id

Line 486: l_return_status := 'W'; -- FND_API.G_RET_STS_ERROR;

482: p_msg_name => 'AS_NO_DEFAULT_SCORECARD'); --'API_MISSING_ID',
483: --p_token1 => 'COLUMN',
484: --p_token1_value => 'SCORECARD_ID');
485:
486: l_return_status := 'W'; -- FND_API.G_RET_STS_ERROR;
487: x_return_status := 'W'; -- FND_API.G_RET_STS_ERROR;
488:
489: -- l_default_scorecard_id:=fnd_profile.value('AS_DEFAULT_SCORECARD');
490: END IF;

Line 487: x_return_status := 'W'; -- FND_API.G_RET_STS_ERROR;

483: --p_token1 => 'COLUMN',
484: --p_token1_value => 'SCORECARD_ID');
485:
486: l_return_status := 'W'; -- FND_API.G_RET_STS_ERROR;
487: x_return_status := 'W'; -- FND_API.G_RET_STS_ERROR;
488:
489: -- l_default_scorecard_id:=fnd_profile.value('AS_DEFAULT_SCORECARD');
490: END IF;
491:

Line 516: --raise FND_API.G_EXC_ERROR;

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';
520: -- kmahajan 05/01/01 - elsif added to check for the profile

Line 535: --raise FND_API.G_EXC_ERROR;

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';
539: -- end if;

Line 567: p_init_msg_list => FND_API.G_FALSE,

563: 'Call user_hook is true');
564: END IF;
565: AS_SCORECARD_CUHK.Get_Score_Pre(
566: p_api_version_number => 2.0,
567: p_init_msg_list => FND_API.G_FALSE,
568: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
569: p_commit => FND_API.G_FALSE,
570: p_sales_lead_id => p_sales_lead_id,
571: p_scorecard_id => p_scorecard_id,

Line 568: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

564: END IF;
565: AS_SCORECARD_CUHK.Get_Score_Pre(
566: p_api_version_number => 2.0,
567: p_init_msg_list => FND_API.G_FALSE,
568: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
569: p_commit => FND_API.G_FALSE,
570: p_sales_lead_id => p_sales_lead_id,
571: p_scorecard_id => p_scorecard_id,
572: x_score => l_total_score,

Line 569: p_commit => FND_API.G_FALSE,

565: AS_SCORECARD_CUHK.Get_Score_Pre(
566: p_api_version_number => 2.0,
567: p_init_msg_list => FND_API.G_FALSE,
568: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
569: p_commit => FND_API.G_FALSE,
570: p_sales_lead_id => p_sales_lead_id,
571: p_scorecard_id => p_scorecard_id,
572: x_score => l_total_score,
573: x_return_status => l_return_status,

Line 577: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

573: x_return_status => l_return_status,
574: x_msg_count => l_msg_count,
575: x_msg_data => l_msg_data);
576:
577: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
578: x_return_status := l_return_status;
579: RAISE FND_API.G_EXC_ERROR;
580: END IF;
581: END IF;

Line 579: RAISE FND_API.G_EXC_ERROR;

575: x_msg_data => l_msg_data);
576:
577: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
578: x_return_status := l_return_status;
579: RAISE FND_API.G_EXC_ERROR;
580: END IF;
581: END IF;
582:
583: IF (l_call_user_hook AND l_total_score IS NULL) OR

Line 859: raise FND_API.G_EXC_ERROR;

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;
861:
862: --dbms_output.put_line('Running Score is = ' || l_total_score);
863: end Loop;

Line 950: ,p_init_msg_list => fnd_api.g_false

946:
947: -- ffang 050901, pass p_check_access_flag as it was past in
948: AS_SALES_LEADS_PUB.update_sales_lead(
949: p_api_version_number => 2.0
950: ,p_init_msg_list => fnd_api.g_false
951: ,p_commit => fnd_api.g_false
952: ,p_validation_level => l_valid_level_full
953: ,p_check_access_flag => p_check_access_flag -- 'Y'
954: ,p_admin_flag => p_admin_flag

Line 951: ,p_commit => fnd_api.g_false

947: -- ffang 050901, pass p_check_access_flag as it was past in
948: AS_SALES_LEADS_PUB.update_sales_lead(
949: p_api_version_number => 2.0
950: ,p_init_msg_list => fnd_api.g_false
951: ,p_commit => fnd_api.g_false
952: ,p_validation_level => l_valid_level_full
953: ,p_check_access_flag => p_check_access_flag -- 'Y'
954: ,p_admin_flag => p_admin_flag
955: ,p_admin_group_id => p_admin_group_id

Line 981: raise FND_API.G_EXC_ERROR;

977: 'Error=====> ' || l_msg_data);
978: END IF;
979: --AST_API.display_error(l_msg_count);
980: x_return_status := l_return_status;
981: raise FND_API.G_EXC_ERROR;
982: END IF;
983:
984: end if; -- kmahajan 5/5/1 - if-then-else for l_return_status <> 'W'
985:

Line 991: IF FND_API.to_Boolean( p_commit )

987: -- End of API body
988: --
989:
990: -- Standard check for p_commit
991: IF FND_API.to_Boolean( p_commit )
992: THEN
993: COMMIT WORK;
994: END IF;
995:

Line 1007: WHEN FND_API.G_EXC_ERROR THEN

1003: ( p_count => x_msg_count,
1004: p_data => x_msg_data );
1005:
1006: EXCEPTION
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

Line 1017: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1013: ,X_MSG_COUNT => X_MSG_COUNT
1014: ,X_MSG_DATA => X_MSG_DATA
1015: ,X_RETURN_STATUS => X_RETURN_STATUS);
1016:
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