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_RTTAP_OPPTY dependencies on FND_API

Line 9: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

5: G_LEAD_ID NUMBER;
6: G_PKG_NAME CONSTANT VARCHAR2(15) := 'AS_RTTAP_OPPTY';
7: PROCEDURE RTTAP_WRAPPER(
8: P_Api_Version_Number IN NUMBER,
9: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
10: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
11: p_LEAD_ID IN NUMBER,
12: X_Return_Status OUT NOCOPY VARCHAR2,
13: X_Msg_Count OUT NOCOPY NUMBER,

Line 10: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

6: G_PKG_NAME CONSTANT VARCHAR2(15) := 'AS_RTTAP_OPPTY';
7: PROCEDURE RTTAP_WRAPPER(
8: P_Api_Version_Number IN NUMBER,
9: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
10: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
11: p_LEAD_ID IN NUMBER,
12: X_Return_Status OUT NOCOPY VARCHAR2,
13: X_Msg_Count OUT NOCOPY NUMBER,
14: X_Msg_Data OUT NOCOPY VARCHAR2

Line 36: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

32: END IF;
33: -- IF p_trace_mode = 'Y' THEN AS_GAR.SETTRACE; END IF;
34: AS_GAR.LOG(G_ENTITY || G_PKG_NAME || AS_GAR.G_START);
35:
36: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
37: p_api_version_number,
38: l_api_name,
39: G_PKG_NAME)
40: THEN

Line 41: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

37: p_api_version_number,
38: l_api_name,
39: G_PKG_NAME)
40: THEN
41: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
42: END IF;
43:
44: -- Initialize message list if p_init_msg_list is set to TRUE.
45: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 45: IF FND_API.to_Boolean( p_init_msg_list ) THEN

41: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
42: END IF;
43:
44: -- Initialize message list if p_init_msg_list is set to TRUE.
45: IF FND_API.to_Boolean( p_init_msg_list ) THEN
46: FND_MSG_PUB.initialize;
47: END IF;
48: -- Initialize API return status to SUCCESS
49: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 49: x_return_status := FND_API.G_RET_STS_SUCCESS;

45: IF FND_API.to_Boolean( p_init_msg_list ) THEN
46: FND_MSG_PUB.initialize;
47: END IF;
48: -- Initialize API return status to SUCCESS
49: x_return_status := FND_API.G_RET_STS_SUCCESS;
50:
51: IF NVL(FND_PROFILE.Value('AS_ENABLE_OPP_ONLINE_TAP'), 'N') <> 'Y' THEN
52: /*------------------------------------------------------+
53: | If REALTIME TAP profile is turned on there is NO need

Line 96: p_init_msg_list => FND_API.G_FALSE,

92: l_trans_rec.trans_object_id5 := jtf_terr_number_list(null);
93: l_trans_rec.txn_date := jtf_terr_date_list(null);
94: JTY_ASSIGN_REALTIME_PUB.get_winners(
95: p_api_version_number => 1.0,
96: p_init_msg_list => FND_API.G_FALSE,
97: p_source_id => -1001,
98: p_trans_id => -1004,
99: p_mode => 'REAL TIME:RESOURCE',
100: p_param_passing_mechanism => 'PBR',

Line 112: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

108: x_msg_data => l_msg_data,
109: x_winners_rec => l_WinningTerrMember_tbl);
110: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CW || AS_GAR.G_END);
111: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CW || AS_GAR.G_RETURN_STATUS || l_return_status);
112: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
113: FND_MSG_PUB.Count_And_Get
114: ( p_count => l_msg_count,
115: p_data => l_msg_data
116: );

Line 119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

115: p_data => l_msg_data
116: );
117: AS_UTILITY_PVT.Get_Messages(l_msg_count, l_msg_data);
118: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CW, l_msg_data, 'ERROR');
119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
120: END IF;
121:
122: IF (l_WinningTerrMember_tbl.resource_id.count > 0) THEN
123: FOR i IN l_WinningTerrMember_tbl.terr_id.FIRST .. l_WinningTerrMember_tbl.terr_id.LAST LOOP

Line 141: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

137:
138: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CEX_GROUPS || AS_GAR.G_END);
139: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CEX_GROUPS || AS_GAR.G_RETURN_STATUS || l_return_status);
140:
141: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
142: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CEX_GROUPS, l_errbuf, l_retcode);
143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
144: End If;
145:

Line 143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

139: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CEX_GROUPS || AS_GAR.G_RETURN_STATUS || l_return_status);
140:
141: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
142: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CEX_GROUPS, l_errbuf, l_retcode);
143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
144: End If;
145:
146: -- Explode TEAMS if any inside winners
147: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CEX_TEAMS || AS_GAR.G_START);

Line 157: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

153:
154: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CEX_TEAMS || AS_GAR.G_END);
155: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CEX_TEAMS || AS_GAR.G_RETURN_STATUS || l_return_status);
156:
157: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
158: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CEX_TEAMS, l_errbuf, l_retcode);
159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
160: End If;
161:

Line 159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

155: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CEX_TEAMS || AS_GAR.G_RETURN_STATUS || l_return_status);
156:
157: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
158: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CEX_TEAMS, l_errbuf, l_retcode);
159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
160: End If;
161:
162: -- Set team leader for Opptys
163: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_STLEAD || AS_GAR.G_START);

Line 173: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

169:
170: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_STLEAD || AS_GAR.G_END);
171: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_STLEAD || AS_GAR.G_RETURN_STATUS || l_return_status);
172:
173: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
174: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_STLEAD, l_errbuf, l_retcode);
175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
176: End If;
177:

Line 175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

171: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_STLEAD || AS_GAR.G_RETURN_STATUS || l_return_status);
172:
173: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
174: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_STLEAD, l_errbuf, l_retcode);
175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
176: End If;
177:
178: -- Insert into Oppty Accesses from Winners
179: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSACC || AS_GAR.G_START);

Line 189: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

185:
186: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSACC || AS_GAR.G_END);
187: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSACC || AS_GAR.G_RETURN_STATUS || l_return_status);
188:
189: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
190: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSACC, l_errbuf, l_retcode);
191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
192: End If;
193:

Line 191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

187: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSACC || AS_GAR.G_RETURN_STATUS || l_return_status);
188:
189: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
190: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSACC, l_errbuf, l_retcode);
191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
192: End If;
193:
194: -- Insert into territory Accesses
195: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSTERRACC || AS_GAR.G_START);

Line 205: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

201:
202: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSTERRACC || AS_GAR.G_END);
203: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSTERRACC || AS_GAR.G_RETURN_STATUS || l_return_status);
204:
205: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
206: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSTERRACC, l_errbuf, l_retcode);
207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
208: End If;
209: END IF;

Line 207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

203: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSTERRACC || AS_GAR.G_RETURN_STATUS || l_return_status);
204:
205: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
206: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSTERRACC, l_errbuf, l_retcode);
207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
208: End If;
209: END IF;
210: -- Remove (soft delete) records in access table that are not qualified
211: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CC || AS_GAR.G_START);

Line 221: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

217:
218: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CC || AS_GAR.G_END);
219: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CC || AS_GAR.G_RETURN_STATUS || l_return_status);
220:
221: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
222: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CC, l_errbuf, l_retcode);
223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
224: End If;
225:

Line 223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

219: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CC || AS_GAR.G_RETURN_STATUS || l_return_status);
220:
221: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
222: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CC, l_errbuf, l_retcode);
223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
224: End If;
225:
226: -- Opportunity Owner assignment
227: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CO || AS_GAR.G_START);

Line 244: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

240: +------------------------------------------------------------------------*/
241: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CO || AS_GAR.G_END);
242: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CO || AS_GAR.G_RETURN_STATUS || l_return_status);
243:
244: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
245: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CO, l_errbuf, l_retcode);
246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
247: End If;
248:

Line 246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

242: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CO || AS_GAR.G_RETURN_STATUS || l_return_status);
243:
244: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
245: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CO, l_errbuf, l_retcode);
246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
247: End If;
248:
249: -- Opportunity Raising Business Event
250: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || 'Raising BE' || AS_GAR.G_START);

Line 257: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

253: x_errbuf => l_errbuf,
254: x_retcode => l_retcode,
255: x_return_status => l_return_status);
256:
257: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
258: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || 'Raising BE' , l_errbuf, l_retcode);
259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
260: End If;
261: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CO || AS_GAR.G_END);

Line 259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

255: x_return_status => l_return_status);
256:
257: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
258: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || 'Raising BE' , l_errbuf, l_retcode);
259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
260: End If;
261: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CO || AS_GAR.G_END);
262: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CO || AS_GAR.G_RETURN_STATUS || l_return_status);
263:

Line 294: IF FND_API.to_Boolean( p_commit ) THEN

290: AND acc.OPEN_FLAG IS NOT NULL;
291:
292:
293: -- Standard check for p_commit
294: IF FND_API.to_Boolean( p_commit ) THEN
295: COMMIT WORK;
296: END IF;
297: EXCEPTION
298: WHEN FND_API.G_EXC_ERROR THEN

Line 298: WHEN FND_API.G_EXC_ERROR THEN

294: IF FND_API.to_Boolean( p_commit ) THEN
295: COMMIT WORK;
296: END IF;
297: EXCEPTION
298: WHEN FND_API.G_EXC_ERROR THEN
299: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
300: P_MODULE => 'as.plsql.tap.realtime'
301: ,P_API_NAME => l_api_name
302: ,P_PKG_NAME => G_PKG_NAME

Line 308: X_Return_Status := FND_API.G_RET_STS_ERROR;

304: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
305: ,X_MSG_COUNT => l_msg_count
306: ,X_MSG_DATA => l_msg_data
307: ,X_RETURN_STATUS => l_return_status);
308: X_Return_Status := FND_API.G_RET_STS_ERROR;
309: X_Msg_Count := 1;
310: X_Msg_Data := 'ERROR IN OPPTY REALTIME TAP ASSIGNMENT';
311:
312: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 312: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

308: X_Return_Status := FND_API.G_RET_STS_ERROR;
309: X_Msg_Count := 1;
310: X_Msg_Data := 'ERROR IN OPPTY REALTIME TAP ASSIGNMENT';
311:
312: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
313: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
314: P_MODULE => 'as.plsql.tap.realtime'
315: ,P_API_NAME => l_api_name
316: ,P_PKG_NAME => G_PKG_NAME

Line 322: X_Return_Status := FND_API.G_RET_STS_ERROR;

318: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
319: ,X_MSG_COUNT => l_msg_count
320: ,X_MSG_DATA => l_msg_data
321: ,X_RETURN_STATUS => l_return_status);
322: X_Return_Status := FND_API.G_RET_STS_ERROR;
323: X_Msg_Count := 1;
324: X_Msg_Data := 'ERROR IN OPPTY REALTIME TAP ASSIGNMENT';
325:
326: WHEN OTHERS THEN

Line 338: X_Return_Status := FND_API.G_RET_STS_ERROR;

334: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
335: ,X_MSG_COUNT => l_msg_count
336: ,X_MSG_DATA => l_msg_data
337: ,X_RETURN_STATUS => l_return_status);
338: X_Return_Status := FND_API.G_RET_STS_ERROR;
339: X_Msg_Count := 1;
340: X_Msg_Data := 'ERROR IN OPPTY REALTIME TAP ASSIGNMENT';
341: END RTTAP_WRAPPER;
342:

Line 376: x_return_status := FND_API.G_RET_STS_SUCCESS;

372:
373:
374: BEGIN
375: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_TEAMS || AS_GAR.G_START);
376: x_return_status := FND_API.G_RET_STS_SUCCESS;
377: -- l_resource_type := 'RS_TEAM';
378: /* Get resources within a resource team */
379: /** Note
380: Hard coding RS_EMPLOYEE INSTEAD OF resource_category IN following SQL

Line 540: x_return_status := FND_API.G_RET_STS_ERROR;

536: WHEN others THEN
537: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_TEAMS, SQLERRM, TO_CHAR(SQLCODE));
538: x_errbuf := SQLERRM;
539: x_retcode := SQLCODE;
540: x_return_status := FND_API.G_RET_STS_ERROR;
541: END EXPLODE_TEAMS_OPPTYS;
542: /************************** End Explode Teams Opptys ******************/
543:
544: /************************** Start Explode Groups Opptys ******************/

Line 570: x_return_status := FND_API.G_RET_STS_SUCCESS;

566: l_person_id num_list;
567:
568: BEGIN
569: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_GROUPS || AS_GAR.G_START);
570: x_return_status := FND_API.G_RET_STS_SUCCESS;
571: -- l_resource_type := 'RS_TEAM';
572: /* Get resources within a resource team */
573: /** Note
574: Hard coding RS_EMPLOYEE INSTEAD OF resource_category IN following SQL

Line 647: x_return_status := FND_API.G_RET_STS_ERROR;

643: WHEN OTHERS THEN
644: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_GROUPS, SQLERRM, TO_CHAR(SQLCODE));
645: x_errbuf := SQLERRM;
646: x_retcode := SQLCODE;
647: x_return_status := FND_API.G_RET_STS_ERROR;
648: END EXPLODE_GROUPS_OPPTYS;
649:
650: PROCEDURE SET_TEAM_LEAD_OPPTYS(
651: x_errbuf OUT NOCOPY VARCHAR2,

Line 657: x_return_status := FND_API.G_RET_STS_SUCCESS;

653: p_WinningTerrMember_tbl IN OUT NOCOPY JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type,
654: x_return_status OUT NOCOPY VARCHAR2) IS
655: BEGIN
656: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_STLEAD || AS_GAR.G_START);
657: x_return_status := FND_API.G_RET_STS_SUCCESS;
658: IF p_WinningTerrMember_tbl.resource_id.COUNT > 0 THEN
659: FOR l_index IN p_WinningTerrMember_tbl.resource_id.FIRST..p_WinningTerrMember_tbl.resource_id.LAST LOOP
660: AS_GAR.LOG(G_ENTITY || G_LEAD_ID || '::' || 'RESOURCE/GROUP::' || p_WinningTerrMember_tbl.resource_id(l_index) || '/' || p_WinningTerrMember_tbl.group_id(l_index));
661: IF p_WinningTerrMember_tbl.resource_type(l_index) = 'RS_EMPLOYEE' THEN

Line 681: x_return_status := FND_API.G_RET_STS_ERROR;

677: WHEN OTHERS THEN
678: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_STLEAD, SQLERRM, TO_CHAR(SQLCODE));
679: x_errbuf := SQLERRM;
680: x_retcode := SQLCODE;
681: x_return_status := FND_API.G_RET_STS_ERROR;
682: END SET_TEAM_LEAD_OPPTYS;
683:
684:
685: PROCEDURE INSERT_ACCESSES_OPPTYS(

Line 692: x_return_status := FND_API.G_RET_STS_SUCCESS;

688: p_WinningTerrMember_tbl IN OUT NOCOPY JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type,
689: x_return_status OUT NOCOPY VARCHAR2) IS
690: BEGIN
691: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSACC || AS_GAR.G_START);
692: x_return_status := FND_API.G_RET_STS_SUCCESS;
693: IF p_WinningTerrMember_tbl.resource_id.COUNT > 0 THEN
694: FOR l_index IN p_WinningTerrMember_tbl.resource_id.FIRST..p_WinningTerrMember_tbl.resource_id.LAST LOOP
695: IF p_WinningTerrMember_tbl.resource_type(l_index) = 'RS_EMPLOYEE' AND p_WinningTerrMember_tbl.group_id(l_index) IS NOT NULL THEN
696: AS_GAR.LOG(G_ENTITY || G_LEAD_ID || '::' || 'BEFORE INSERT INTO AS_ACCESSED_ALL RESOURCE/GROUP::' || p_WinningTerrMember_tbl.resource_id(l_index)

Line 755: x_return_status := FND_API.G_RET_STS_ERROR;

751: WHEN OTHERS THEN
752: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSACC, SQLERRM, TO_CHAR(SQLCODE));
753: x_errbuf := SQLERRM;
754: x_retcode := SQLCODE;
755: x_return_status := FND_API.G_RET_STS_ERROR;
756: END INSERT_ACCESSES_OPPTYS;
757:
758: PROCEDURE INSERT_TERR_ACCESSES_OPPTYS(
759: x_errbuf OUT NOCOPY VARCHAR2,

Line 770: x_return_status := FND_API.G_RET_STS_SUCCESS;

766: | we are deleting all rows for the entity from as_territory_accesses prior to
767: | inserting into it because the logic for removing only certain terr_id/access_id
768: | combinations is very complex and could be slow..
769: +-------------------------------------------------------------------------------*/
770: x_return_status := FND_API.G_RET_STS_SUCCESS;
771: DELETE FROM AS_TERRITORY_ACCESSES TACC
772: WHERE TACC.access_id IN
773: (SELECT ACC.access_id
774: FROM AS_ACCESSES_ALL ACC

Line 814: x_return_status := FND_API.G_RET_STS_ERROR;

810: WHEN OTHERS THEN
811: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC, SQLERRM, TO_CHAR(SQLCODE));
812: x_errbuf := SQLERRM;
813: x_retcode := SQLCODE;
814: x_return_status := FND_API.G_RET_STS_ERROR;
815: END INSERT_TERR_ACCESSES_OPPTYS;
816:
817: PROCEDURE PERFORM_OPPTY_CLEANUP(
818: x_errbuf OUT NOCOPY VARCHAR2,

Line 824: x_return_status := FND_API.G_RET_STS_SUCCESS;

820: p_WinningTerrMember_tbl IN OUT NOCOPY JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type,
821: x_return_status OUT NOCOPY VARCHAR2) IS
822:
823: BEGIN
824: x_return_status := FND_API.G_RET_STS_SUCCESS;
825: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_START);
826: DELETE FROM AS_ACCESSES_ALL ACC
827: WHERE lead_id = G_LEAD_ID
828: AND NVL(freeze_flag, 'N') <> 'Y'

Line 848: x_return_status := FND_API.G_RET_STS_ERROR;

844: WHEN OTHERS THEN
845: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC, SQLERRM, TO_CHAR(SQLCODE));
846: x_errbuf := SQLERRM;
847: x_retcode := SQLCODE;
848: x_return_status := FND_API.G_RET_STS_ERROR;
849: END PERFORM_OPPTY_CLEANUP;
850:
851: ----------------------
852: PROCEDURE ASSIGN_OPPTY_OWNER(

Line 883: x_return_status := FND_API.G_RET_STS_SUCCESS;

879: | Select MAX(access_id) from as_accesses for this lead where the created_by_tap
880: | flag is set and owner flag is not set..Is there anything else that we need to do ?
881: | Then update accesses,leads,and scd
882: +------------------------------------------------------------------------*/
883: x_return_status := FND_API.G_RET_STS_SUCCESS;
884: OPEN is_owner_set;
885: FETCH is_owner_set INTO v_own_set;
886: IF is_owner_set%NOTFOUND THEN
887: OPEN oppty_owner_rt;

Line 940: x_return_status := FND_API.G_RET_STS_ERROR;

936: WHEN OTHERS THEN
937: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO, SQLERRM, TO_CHAR(SQLCODE));
938: x_errbuf := SQLERRM;
939: x_retcode := SQLCODE;
940: x_return_status := FND_API.G_RET_STS_ERROR;
941: END ASSIGN_OPPTY_OWNER;
942:
943: PROCEDURE RAISE_BUSINESS_EVENT(
944: x_errbuf OUT NOCOPY VARCHAR2,

Line 952: X_return_status := FND_API.G_RET_STS_SUCCESS;

948: l_param WF_PARAMETER_T;
949: x_event_key varchar2(1000);
950: l_event_name VARCHAR2(240) := 'oracle.apps.as.opportunity.tap.realtime.post';
951: BEGIN
952: X_return_status := FND_API.G_RET_STS_SUCCESS;
953: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || 'Raising BE' || AS_GAR.G_START) ;
954:
955: -- initialization of object variables
956: l_list := WF_PARAMETER_LIST_T();

Line 983: x_return_status := FND_API.G_RET_STS_ERROR;

979: WHEN OTHERS THEN
980: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || 'RAISING BE' , SQLERRM, TO_CHAR(SQLCODE));
981: x_errbuf := SQLERRM;
982: x_retcode := SQLCODE;
983: x_return_status := FND_API.G_RET_STS_ERROR;
984:
985: END RAISE_BUSINESS_EVENT;
986: END AS_RTTAP_OPPTY;