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 AS_GAR

Line 31: AS_GAR.G_DEBUG_FLAG := 'Y';

27: G_LEAD_ID := p_lead_id;
28: SAVEPOINT RTTAP_WRAPPER_PVT;
29:
30: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
31: AS_GAR.G_DEBUG_FLAG := 'Y';
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:

Line 33: -- IF p_trace_mode = 'Y' THEN AS_GAR.SETTRACE; END IF;

29:
30: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
31: AS_GAR.G_DEBUG_FLAG := 'Y';
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,

Line 34: AS_GAR.LOG(G_ENTITY || G_PKG_NAME || AS_GAR.G_START);

30: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
31: AS_GAR.G_DEBUG_FLAG := 'Y';
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,

Line 87: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CW || AS_GAR.G_START);

83: AND LDS.lead_id = ACC.lead_id
84: AND ACC.request_id IS NULL );
85:
86: ELSE
87: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CW || AS_GAR.G_START);
88: l_trans_rec.trans_object_id1 := jtf_terr_number_list(G_LEAD_ID);
89: l_trans_rec.trans_object_id2 := jtf_terr_number_list(null);
90: l_trans_rec.trans_object_id3 := jtf_terr_number_list(null);
91: l_trans_rec.trans_object_id4 := jtf_terr_number_list(null);

Line 110: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CW || AS_GAR.G_END);

106: x_return_status => l_return_status,
107: x_msg_count => l_msg_count,
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,

Line 111: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CW || AS_GAR.G_RETURN_STATUS || l_return_status);

107: x_msg_count => l_msg_count,
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

Line 118: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CW, l_msg_data, 'ERROR');

114: ( p_count => l_msg_count,
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

Line 124: AS_GAR.LOG(G_ENTITY || 'Trans Object ID : ' || l_WinningTerrMember_tbl.trans_object_id(i) ||

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
124: AS_GAR.LOG(G_ENTITY || 'Trans Object ID : ' || l_WinningTerrMember_tbl.trans_object_id(i) ||
125: 'Trans Detail Object ID : ' || l_WinningTerrMember_tbl.trans_detail_object_id(i) ||
126: 'Terr ID : ' || l_WinningTerrMember_tbl.terr_id(i) || ' Terr Name : ' || l_WinningTerrMember_tbl.terr_name(i) ||
127: ' Resource ID : ' || l_WinningTerrMember_tbl.resource_id(i) ||
128: ' Resource TYPE : ' || l_WinningTerrMember_tbl.resource_type(i));

Line 131: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CEX_GROUPS || AS_GAR.G_START);

127: ' Resource ID : ' || l_WinningTerrMember_tbl.resource_id(i) ||
128: ' Resource TYPE : ' || l_WinningTerrMember_tbl.resource_type(i));
129: END LOOP;
130: -- Explode GROUPS if any inside winners
131: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CEX_GROUPS || AS_GAR.G_START);
132: AS_RTTAP_OPPTY.EXPLODE_GROUPS_OPPTYS(
133: x_errbuf => l_errbuf,
134: x_retcode => l_retcode,
135: p_WinningTerrMember_tbl => l_WinningTerrMember_tbl,

Line 138: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CEX_GROUPS || AS_GAR.G_END);

134: x_retcode => l_retcode,
135: p_WinningTerrMember_tbl => l_WinningTerrMember_tbl,
136: x_return_status => l_return_status);
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);

Line 139: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CEX_GROUPS || AS_GAR.G_RETURN_STATUS || l_return_status);

135: p_WinningTerrMember_tbl => l_WinningTerrMember_tbl,
136: x_return_status => l_return_status);
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;

Line 142: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CEX_GROUPS, l_errbuf, l_retcode);

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:
146: -- Explode TEAMS if any inside winners

Line 147: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CEX_TEAMS || AS_GAR.G_START);

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);
148: AS_RTTAP_OPPTY.EXPLODE_TEAMS_OPPTYS(
149: x_errbuf => l_errbuf,
150: x_retcode => l_retcode,
151: p_WinningTerrMember_tbl => l_WinningTerrMember_tbl,

Line 154: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CEX_TEAMS || AS_GAR.G_END);

150: x_retcode => l_retcode,
151: p_WinningTerrMember_tbl => l_WinningTerrMember_tbl,
152: x_return_status => l_return_status);
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);

Line 155: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CEX_TEAMS || AS_GAR.G_RETURN_STATUS || l_return_status);

151: p_WinningTerrMember_tbl => l_WinningTerrMember_tbl,
152: x_return_status => l_return_status);
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;

Line 158: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CEX_TEAMS, l_errbuf, l_retcode);

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:
162: -- Set team leader for Opptys

Line 163: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_STLEAD || AS_GAR.G_START);

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);
164: AS_RTTAP_OPPTY.SET_TEAM_LEAD_OPPTYS(
165: x_errbuf => l_errbuf,
166: x_retcode => l_retcode,
167: p_WinningTerrMember_tbl => l_WinningTerrMember_tbl,

Line 170: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_STLEAD || AS_GAR.G_END);

166: x_retcode => l_retcode,
167: p_WinningTerrMember_tbl => l_WinningTerrMember_tbl,
168: x_return_status => l_return_status);
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);

Line 171: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_STLEAD || AS_GAR.G_RETURN_STATUS || l_return_status);

167: p_WinningTerrMember_tbl => l_WinningTerrMember_tbl,
168: x_return_status => l_return_status);
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;

Line 174: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_STLEAD, l_errbuf, l_retcode);

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:
178: -- Insert into Oppty Accesses from Winners

Line 179: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSACC || AS_GAR.G_START);

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);
180: AS_RTTAP_OPPTY.INSERT_ACCESSES_OPPTYS(
181: x_errbuf => l_errbuf,
182: x_retcode => l_retcode,
183: p_WinningTerrMember_tbl => l_WinningTerrMember_tbl,

Line 186: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSACC || AS_GAR.G_END);

182: x_retcode => l_retcode,
183: p_WinningTerrMember_tbl => l_WinningTerrMember_tbl,
184: x_return_status => l_return_status);
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);

Line 187: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSACC || AS_GAR.G_RETURN_STATUS || l_return_status);

183: p_WinningTerrMember_tbl => l_WinningTerrMember_tbl,
184: x_return_status => l_return_status);
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;

Line 190: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSACC, l_errbuf, l_retcode);

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:
194: -- Insert into territory Accesses

Line 195: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSTERRACC || AS_GAR.G_START);

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);
196: AS_RTTAP_OPPTY.INSERT_TERR_ACCESSES_OPPTYS(
197: x_errbuf => l_errbuf,
198: x_retcode => l_retcode,
199: p_WinningTerrMember_tbl => l_WinningTerrMember_tbl,

Line 202: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSTERRACC || AS_GAR.G_END);

198: x_retcode => l_retcode,
199: p_WinningTerrMember_tbl => l_WinningTerrMember_tbl,
200: x_return_status => l_return_status);
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);

Line 203: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSTERRACC || AS_GAR.G_RETURN_STATUS || l_return_status);

199: p_WinningTerrMember_tbl => l_WinningTerrMember_tbl,
200: x_return_status => l_return_status);
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;

Line 206: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSTERRACC, l_errbuf, l_retcode);

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;
210: -- Remove (soft delete) records in access table that are not qualified

Line 211: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CC || AS_GAR.G_START);

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);
212: AS_RTTAP_OPPTY.PERFORM_OPPTY_CLEANUP(
213: x_errbuf => l_errbuf,
214: x_retcode => l_retcode,
215: p_WinningTerrMember_tbl => l_WinningTerrMember_tbl,

Line 218: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CC || AS_GAR.G_END);

214: x_retcode => l_retcode,
215: p_WinningTerrMember_tbl => l_WinningTerrMember_tbl,
216: x_return_status => l_return_status);
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);

Line 219: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CC || AS_GAR.G_RETURN_STATUS || l_return_status);

215: p_WinningTerrMember_tbl => l_WinningTerrMember_tbl,
216: x_return_status => l_return_status);
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;

Line 222: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CC, l_errbuf, l_retcode);

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:
226: -- Opportunity Owner assignment

Line 227: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CO || AS_GAR.G_START);

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);
228: /* ----------------------------------------------------------------------+
229: | G_TAP_FLAG is set to avoid calling the leads buid trigger .
230: +------------------------------------------------------------------------*/
231: AS_GAR.G_TAP_FLAG := 'Y';

Line 231: AS_GAR.G_TAP_FLAG := 'Y';

227: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CO || AS_GAR.G_START);
228: /* ----------------------------------------------------------------------+
229: | G_TAP_FLAG is set to avoid calling the leads buid trigger .
230: +------------------------------------------------------------------------*/
231: AS_GAR.G_TAP_FLAG := 'Y';
232: AS_RTTAP_OPPTY.ASSIGN_OPPTY_OWNER(
233: x_errbuf => l_errbuf,
234: x_retcode => l_retcode,
235: p_WinningTerrMember_tbl => l_WinningTerrMember_tbl,

Line 237: AS_GAR.G_TAP_FLAG := 'N';

233: x_errbuf => l_errbuf,
234: x_retcode => l_retcode,
235: p_WinningTerrMember_tbl => l_WinningTerrMember_tbl,
236: x_return_status => l_return_status);
237: AS_GAR.G_TAP_FLAG := 'N';
238: /* ----------------------------------------------------------------------+
239: | G_TAP_FLAG is reset.
240: +------------------------------------------------------------------------*/
241: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CO || AS_GAR.G_END);

Line 241: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CO || AS_GAR.G_END);

237: AS_GAR.G_TAP_FLAG := 'N';
238: /* ----------------------------------------------------------------------+
239: | G_TAP_FLAG is reset.
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);

Line 242: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CO || AS_GAR.G_RETURN_STATUS || l_return_status);

238: /* ----------------------------------------------------------------------+
239: | G_TAP_FLAG is reset.
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;

Line 245: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CO, l_errbuf, l_retcode);

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:
249: -- Opportunity Raising Business Event

Line 250: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || 'Raising BE' || AS_GAR.G_START);

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);
251:
252: AS_RTTAP_OPPTY.RAISE_BUSINESS_EVENT(
253: x_errbuf => l_errbuf,
254: x_retcode => l_retcode,

Line 258: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || 'Raising BE' , l_errbuf, l_retcode);

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);
262: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CO || AS_GAR.G_RETURN_STATUS || l_return_status);

Line 261: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CO || AS_GAR.G_END);

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:
264: END IF;
265:

Line 262: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CO || AS_GAR.G_RETURN_STATUS || l_return_status);

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:
264: END IF;
265:
266: -- Reset AS_ACCESSES_ALL.open_flag added for bug 5592395

Line 375: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_TEAMS || AS_GAR.G_START);

371: l_person_id num_list;
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

Line 383: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_TEAMS || AS_GAR.G_INS_WINNERS || AS_GAR.G_START);

379: /** Note
380: Hard coding RS_EMPLOYEE INSTEAD OF resource_category IN following SQL
381: because JTA returns RS_EMPLOYEE AND NOT EMPLOYEE
382: **/
383: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_TEAMS || AS_GAR.G_INS_WINNERS || AS_GAR.G_START);
384: IF p_WinningTerrMember_tbl.resource_id.COUNT > 0 THEN
385: FOR l_index IN p_WinningTerrMember_tbl.resource_id.FIRST..p_WinningTerrMember_tbl.resource_id.LAST LOOP
386: IF p_WinningTerrMember_tbl.resource_type(l_index) = 'RS_TEAM' THEN
387:

Line 502: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_GROUPS || AS_GAR.G_INS_WINNERS || AS_GAR.G_N_ROWS_PROCESSED || SQL%ROWCOUNT

498: AND jtm.group_id = g.group_id
499: GROUP BY m.resource_id, m.person_id, jtm.team_id, res.CATEGORY) J
500:
501: WHERE j.team_id = p_WinningTerrMember_tbl.resource_id(l_index);
502: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_GROUPS || AS_GAR.G_INS_WINNERS || AS_GAR.G_N_ROWS_PROCESSED || SQL%ROWCOUNT
503: ||'FOR TEAM ' ||p_WinningTerrMember_tbl.resource_id(l_index));
504:
505:
506: IF l_resource_id.COUNT > 0 THEN

Line 533: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_TEAMS || AS_GAR.G_INS_WINNERS || AS_GAR.G_END);

529: END LOOP;
530: END IF;
531: END IF;
532: END LOOP;
533: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_TEAMS || AS_GAR.G_INS_WINNERS || AS_GAR.G_END);
534: END IF; /* if p_WinningTerrMember_tbl.resource_id.COUNT > 0 */
535: EXCEPTION
536: WHEN others THEN
537: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_TEAMS, SQLERRM, TO_CHAR(SQLCODE));

Line 537: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_TEAMS, SQLERRM, TO_CHAR(SQLCODE));

533: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_TEAMS || AS_GAR.G_INS_WINNERS || AS_GAR.G_END);
534: END IF; /* if p_WinningTerrMember_tbl.resource_id.COUNT > 0 */
535: EXCEPTION
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;

Line 569: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_GROUPS || AS_GAR.G_START);

565: l_group_id num_list;
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

Line 577: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_GROUPS || AS_GAR.G_INS_WINNERS || AS_GAR.G_START);

573: /** Note
574: Hard coding RS_EMPLOYEE INSTEAD OF resource_category IN following SQL
575: because JTA returns RS_EMPLOYEE AND NOT EMPLOYEE
576: **/
577: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_GROUPS || AS_GAR.G_INS_WINNERS || AS_GAR.G_START);
578: IF p_WinningTerrMember_tbl.resource_id.COUNT > 0 THEN
579: FOR l_index IN p_WinningTerrMember_tbl.resource_id.FIRST..p_WinningTerrMember_tbl.resource_id.LAST LOOP
580: IF p_WinningTerrMember_tbl.resource_type(l_index) = 'RS_GROUP' THEN
581: SELECT resource_id, group_id,person_id

Line 610: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_GROUPS || AS_GAR.G_INS_WINNERS || AS_GAR.G_N_ROWS_PROCESSED || SQL%ROWCOUNT

606: AND res.category IN ('EMPLOYEE')--,'PARTY','PARTNER')
607: GROUP BY m.group_member_id, m.resource_id, m.person_id,
608: m.group_id, res.CATEGORY) j
609: WHERE j.group_id = p_WinningTerrMember_tbl.resource_id(l_index);
610: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_GROUPS || AS_GAR.G_INS_WINNERS || AS_GAR.G_N_ROWS_PROCESSED || SQL%ROWCOUNT
611: ||'FOR GROUP ' ||p_WinningTerrMember_tbl.resource_id(l_index));
612: IF l_resource_id.COUNT > 0 THEN
613: FOR i IN l_resource_id.FIRST .. l_resource_id.LAST LOOP
614: /* No need to Check to see if it is already part of

Line 639: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_GROUPS || AS_GAR.G_INS_WINNERS || AS_GAR.G_END);

635: END LOOP;
636: END IF;
637: END IF;
638: END LOOP;
639: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_GROUPS || AS_GAR.G_INS_WINNERS || AS_GAR.G_END);
640: -- COMMIT;
641: END IF; /* if p_WinningTerrMember_tbl.resource_id.COUNT > 0 */
642: EXCEPTION
643: WHEN OTHERS THEN

Line 644: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_GROUPS, SQLERRM, TO_CHAR(SQLCODE));

640: -- COMMIT;
641: END IF; /* if p_WinningTerrMember_tbl.resource_id.COUNT > 0 */
642: EXCEPTION
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;

Line 656: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_STLEAD || AS_GAR.G_START);

652: x_retcode OUT NOCOPY VARCHAR2,
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));

Line 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));

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
662: UPDATE AS_ACCESSES_ALL_ALL ACC
663: SET object_version_number = nvl(object_version_number,0) + 1,
664: ACC.last_update_date = SYSDATE,

Line 675: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_STLEAD || AS_GAR.G_END);

671: AND NVL(ACC.team_leader_flag,'N') <> NVL(p_WinningTerrMember_tbl.full_access_flag(l_index),'N');
672: END IF;
673: END LOOP;
674: END IF;
675: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_STLEAD || AS_GAR.G_END);
676: EXCEPTION
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;

Line 678: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_STLEAD, SQLERRM, TO_CHAR(SQLCODE));

674: END IF;
675: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_STLEAD || AS_GAR.G_END);
676: EXCEPTION
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;

Line 691: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSACC || AS_GAR.G_START);

687: x_retcode OUT NOCOPY VARCHAR2,
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

Line 696: AS_GAR.LOG(G_ENTITY || G_LEAD_ID || '::' || 'BEFORE INSERT INTO AS_ACCESSED_ALL RESOURCE/GROUP::' || p_WinningTerrMember_tbl.resource_id(l_index)

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)
697: || '/' || p_WinningTerrMember_tbl.group_id(l_index));
698: INSERT INTO AS_ACCESSES_ALL
699: (access_id ,
700: last_update_date ,

Line 749: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSACC || AS_GAR.G_END);

745: AND ACC.sales_group_id = p_WinningTerrMember_tbl.group_id(l_index) );
746: END IF;
747: END LOOP;
748: END IF;
749: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSACC || AS_GAR.G_END);
750: EXCEPTION
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;

Line 752: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSACC, SQLERRM, TO_CHAR(SQLCODE));

748: END IF;
749: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSACC || AS_GAR.G_END);
750: EXCEPTION
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;

Line 764: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC || AS_GAR.G_START);

760: x_retcode OUT NOCOPY VARCHAR2,
761: p_WinningTerrMember_tbl IN OUT NOCOPY JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type,
762: x_return_status OUT NOCOPY VARCHAR2) IS
763: BEGIN
764: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC || AS_GAR.G_START);
765: /*------------------------------------------------------------------------------+
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..

Line 808: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC || AS_GAR.G_END);

804: AND TERRITORY_ID = p_WinningTerrMember_tbl.terr_id(l_index)) ;
805: END IF;
806: END LOOP;
807: END IF;
808: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC || AS_GAR.G_END);
809: EXCEPTION
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;

Line 811: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC, SQLERRM, TO_CHAR(SQLCODE));

807: END IF;
808: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC || AS_GAR.G_END);
809: EXCEPTION
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;

Line 825: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_START);

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'
829: AND SALESFORCE_ID||SALES_GROUP_ID NOT IN (

Line 841: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_N_ROWS_PROCESSED || SQL%ROWCOUNT);

837: WHERE salesforce_id = ACC.salesforce_id
838: AND salesgroup_id = ACC.sales_group_id
839: AND lead_id = G_LEAD_ID) ;
840:
841: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_N_ROWS_PROCESSED || SQL%ROWCOUNT);
842: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_END);
843: EXCEPTION
844: WHEN OTHERS THEN
845: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC, SQLERRM, TO_CHAR(SQLCODE));

Line 842: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_END);

838: AND salesgroup_id = ACC.sales_group_id
839: AND lead_id = G_LEAD_ID) ;
840:
841: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_N_ROWS_PROCESSED || SQL%ROWCOUNT);
842: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_END);
843: EXCEPTION
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;

Line 845: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC, SQLERRM, TO_CHAR(SQLCODE));

841: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_N_ROWS_PROCESSED || SQL%ROWCOUNT);
842: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_END);
843: EXCEPTION
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;

Line 877: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || AS_GAR.G_START) ;

873: v_srep_id NUMBER;
874: v_grp_id NUMBER;
875:
876: BEGIN
877: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || AS_GAR.G_START) ;
878: /* ----------------------------------------------------------------------+
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

Line 934: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || AS_GAR.G_END);

930: WHERE SCD.lead_id = G_LEAD_ID ;
931: END IF;
932: END IF;
933: CLOSE is_owner_set;
934: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || AS_GAR.G_END);
935: EXCEPTION
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;

Line 937: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO, SQLERRM, TO_CHAR(SQLCODE));

933: CLOSE is_owner_set;
934: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || AS_GAR.G_END);
935: EXCEPTION
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;

Line 953: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || 'Raising BE' || AS_GAR.G_START) ;

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();
957:

Line 967: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || 'Before Calling BE Procedure ' || AS_GAR.G_START);

963: l_param.SetName( 'LEAD_ID' );
964: l_param.SetValue( G_LEAD_ID );
965: l_list(l_list.last) := l_param;
966:
967: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || 'Before Calling BE Procedure ' || AS_GAR.G_START);
968:
969: SELECT l_event_name || AS_BUSINESS_EVENT_S.nextval
970: INTO x_event_key
971: FROM DUAL;

Line 977: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || 'After Calling BE Procedure ' || AS_GAR.G_END) ;

973: AS_BUSINESS_EVENT_PVT.raise_event(
974: p_event_name => l_event_name,
975: p_event_key => x_event_key,
976: p_parameters => l_list );
977: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || 'After Calling BE Procedure ' || AS_GAR.G_END) ;
978: EXCEPTION
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;

Line 980: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || 'RAISING BE' , SQLERRM, TO_CHAR(SQLCODE));

976: p_parameters => l_list );
977: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || 'After Calling BE Procedure ' || AS_GAR.G_END) ;
978: EXCEPTION
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: