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

Line 29: p_init_msg_list => FND_API.G_FALSE,

25: END IF;
26:
27: AS_BUSINESS_EVENT_PUB.Before_Cust_STeam_Update(
28: p_api_version_number => 2.0,
29: p_init_msg_list => FND_API.G_FALSE,
30: p_commit => FND_API.G_FALSE,
31: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
32: p_cust_id => P_party_id,
33: x_return_status => l_return_status,

Line 30: p_commit => FND_API.G_FALSE,

26:
27: AS_BUSINESS_EVENT_PUB.Before_Cust_STeam_Update(
28: p_api_version_number => 2.0,
29: p_init_msg_list => FND_API.G_FALSE,
30: p_commit => FND_API.G_FALSE,
31: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
32: p_cust_id => P_party_id,
33: x_return_status => l_return_status,
34: x_msg_count => l_msg_count,

Line 31: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

27: AS_BUSINESS_EVENT_PUB.Before_Cust_STeam_Update(
28: p_api_version_number => 2.0,
29: p_init_msg_list => FND_API.G_FALSE,
30: p_commit => FND_API.G_FALSE,
31: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
32: p_cust_id => P_party_id,
33: x_return_status => l_return_status,
34: x_msg_count => l_msg_count,
35: x_msg_data => l_msg_data,

Line 37: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

33: x_return_status => l_return_status,
34: x_msg_count => l_msg_count,
35: x_msg_data => l_msg_data,
36: x_event_key => l_event_key);
37: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
38: AS_GAR.LOG('BE FOR ACCOUNT REALTIME TAP BEFORE UPDATE FAILED');
39: l_event_key := NULL;
40: END IF;
41:

Line 48: p_init_msg_list => FND_API.G_FALSE,

44: IF l_event_key IS NOT NULL
45: THEN
46: AS_BUSINESS_EVENT_PUB.Upd_Cust_STeam_post_event(
47: p_api_version_number => 2.0,
48: p_init_msg_list => FND_API.G_FALSE,
49: p_commit => FND_API.G_FALSE,
50: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
51: p_cust_id => p_party_id,
52: p_event_key => l_event_key,

Line 49: p_commit => FND_API.G_FALSE,

45: THEN
46: AS_BUSINESS_EVENT_PUB.Upd_Cust_STeam_post_event(
47: p_api_version_number => 2.0,
48: p_init_msg_list => FND_API.G_FALSE,
49: p_commit => FND_API.G_FALSE,
50: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
51: p_cust_id => p_party_id,
52: p_event_key => l_event_key,
53: x_return_status => l_return_status,

Line 50: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

46: AS_BUSINESS_EVENT_PUB.Upd_Cust_STeam_post_event(
47: p_api_version_number => 2.0,
48: p_init_msg_list => FND_API.G_FALSE,
49: p_commit => FND_API.G_FALSE,
50: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
51: p_cust_id => p_party_id,
52: p_event_key => l_event_key,
53: x_return_status => l_return_status,
54: x_msg_count => l_msg_count,

Line 57: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

53: x_return_status => l_return_status,
54: x_msg_count => l_msg_count,
55: x_msg_data => l_msg_data);
56: END IF;
57: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
58: AS_GAR.LOG('BE FOR ACCOUNT REALTIME TAP AFTER UPDATE FAILED');
59: END IF;
60:
61: END PROCESS_RTTAP_ACCOUNT;

Line 67: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

63: FUNCTION CREATE_ORGANIZATION_POST ( p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t ) RETURN VARCHAR2 IS
64: p_return_status VARCHAR2(1);
65: BEGIN
66: PROCESS_RTTAP_ACCOUNT(p_event.GetValueForParameter('PARTY_ID'),p_return_status);
67: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
68: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
69: END IF;
70: RETURN 'SUCCESS';
71: EXCEPTION

Line 68: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

64: p_return_status VARCHAR2(1);
65: BEGIN
66: PROCESS_RTTAP_ACCOUNT(p_event.GetValueForParameter('PARTY_ID'),p_return_status);
67: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
68: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
69: END IF;
70: RETURN 'SUCCESS';
71: EXCEPTION
72: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 72: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

68: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
69: END IF;
70: RETURN 'SUCCESS';
71: EXCEPTION
72: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
73: WF_CORE.CONTEXT('AS_RTTAP_ACCOUNT', 'CREATE_ORGANIZATION_POST', p_event.getEventName(), p_subscription_guid);
74: WF_EVENT.setErrorInfo(p_event, 'ERROR');
75: RETURN 'ERROR';
76: WHEN OTHERS THEN

Line 86: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

82: FUNCTION UPDATE_ORGANIZATION_POST ( p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t ) RETURN VARCHAR2 IS
83: p_return_status VARCHAR2(1);
84: BEGIN
85: PROCESS_RTTAP_ACCOUNT(p_event.GetValueForParameter('PARTY_ID'),p_return_status);
86: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
87: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
88: END IF;
89: RETURN 'SUCCESS';
90: EXCEPTION

Line 87: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

83: p_return_status VARCHAR2(1);
84: BEGIN
85: PROCESS_RTTAP_ACCOUNT(p_event.GetValueForParameter('PARTY_ID'),p_return_status);
86: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
87: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
88: END IF;
89: RETURN 'SUCCESS';
90: EXCEPTION
91: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 91: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

87: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
88: END IF;
89: RETURN 'SUCCESS';
90: EXCEPTION
91: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
92: WF_CORE.CONTEXT('AS_RTTAP_ACCOUNT', 'UPDATE_ORGANIZATION_POST', p_event.getEventName(), p_subscription_guid);
93: WF_EVENT.setErrorInfo(p_event, 'ERROR');
94: RETURN 'ERROR';
95: WHEN OTHERS THEN

Line 105: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

101: FUNCTION CREATE_PERSON_POST ( p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t ) RETURN VARCHAR2 IS
102: p_return_status VARCHAR2(1);
103: BEGIN
104: PROCESS_RTTAP_ACCOUNT(p_event.GetValueForParameter('PARTY_ID'),p_return_status);
105: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
107: END IF;
108: RETURN 'SUCCESS';
109: EXCEPTION

Line 106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

102: p_return_status VARCHAR2(1);
103: BEGIN
104: PROCESS_RTTAP_ACCOUNT(p_event.GetValueForParameter('PARTY_ID'),p_return_status);
105: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
107: END IF;
108: RETURN 'SUCCESS';
109: EXCEPTION
110: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 110: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
107: END IF;
108: RETURN 'SUCCESS';
109: EXCEPTION
110: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
111: WF_CORE.CONTEXT('AS_RTTAP_ACCOUNT', 'CREATE_PERSON_POST', p_event.getEventName(), p_subscription_guid);
112: WF_EVENT.setErrorInfo(p_event, 'ERROR');
113: RETURN 'ERROR';
114: WHEN OTHERS THEN

Line 125: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

121: FUNCTION UPDATE_PERSON_POST ( p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t ) RETURN VARCHAR2 IS
122: p_return_status VARCHAR2(1);
123: BEGIN
124: PROCESS_RTTAP_ACCOUNT(p_event.GetValueForParameter('PARTY_ID'),p_return_status);
125: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
127: END IF;
128: RETURN 'SUCCESS';
129: EXCEPTION

Line 126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

122: p_return_status VARCHAR2(1);
123: BEGIN
124: PROCESS_RTTAP_ACCOUNT(p_event.GetValueForParameter('PARTY_ID'),p_return_status);
125: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
127: END IF;
128: RETURN 'SUCCESS';
129: EXCEPTION
130: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 130: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
127: END IF;
128: RETURN 'SUCCESS';
129: EXCEPTION
130: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
131: WF_CORE.CONTEXT('AS_RTTAP_ACCOUNT', 'UPDATE_PERSON_POST', p_event.getEventName(), p_subscription_guid);
132: WF_EVENT.setErrorInfo(p_event, 'ERROR');
133: RETURN 'ERROR';
134: WHEN OTHERS THEN

Line 153: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

149: OPEN c1;
150: FETCH c1 INTO l_party_id;
151: CLOSE c1;
152: PROCESS_RTTAP_ACCOUNT(l_party_id,p_return_status);
153: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
155: END IF;
156: RETURN 'SUCCESS';
157: EXCEPTION

Line 154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

150: FETCH c1 INTO l_party_id;
151: CLOSE c1;
152: PROCESS_RTTAP_ACCOUNT(l_party_id,p_return_status);
153: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
155: END IF;
156: RETURN 'SUCCESS';
157: EXCEPTION
158: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 158: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
155: END IF;
156: RETURN 'SUCCESS';
157: EXCEPTION
158: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
159: WF_CORE.CONTEXT('AS_RTTAP_ACCOUNT', 'CREATE_PARTY_SITE_POST', p_event.getEventName(), p_subscription_guid);
160: WF_EVENT.setErrorInfo(p_event, 'ERROR');
161: RETURN 'ERROR';
162: WHEN OTHERS THEN

Line 181: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

177: OPEN c1;
178: FETCH c1 INTO l_party_id;
179: CLOSE c1;
180: PROCESS_RTTAP_ACCOUNT(l_party_id,p_return_status);
181: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
183: END IF;
184: RETURN 'SUCCESS';
185: EXCEPTION

Line 182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

178: FETCH c1 INTO l_party_id;
179: CLOSE c1;
180: PROCESS_RTTAP_ACCOUNT(l_party_id,p_return_status);
181: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
183: END IF;
184: RETURN 'SUCCESS';
185: EXCEPTION
186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
183: END IF;
184: RETURN 'SUCCESS';
185: EXCEPTION
186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
187: WF_CORE.CONTEXT('AS_RTTAP_ACCOUNT', 'UPDATE_PARTY_SITE_POST', p_event.getEventName(), p_subscription_guid);
188: WF_EVENT.setErrorInfo(p_event, 'ERROR');
189: RETURN 'ERROR';
190: WHEN OTHERS THEN

Line 232: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

228: PROCESS_RTTAP_ACCOUNT(l_party_id,p_return_status);
229: ELSIF l_owner_table_name = 'HZ_PARTIES' THEN
230: PROCESS_RTTAP_ACCOUNT(l_owner_table_id,p_return_status);
231: END IF;
232: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
234: END IF;
235: RETURN 'SUCCESS';
236: EXCEPTION

Line 233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

229: ELSIF l_owner_table_name = 'HZ_PARTIES' THEN
230: PROCESS_RTTAP_ACCOUNT(l_owner_table_id,p_return_status);
231: END IF;
232: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
234: END IF;
235: RETURN 'SUCCESS';
236: EXCEPTION
237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
234: END IF;
235: RETURN 'SUCCESS';
236: EXCEPTION
237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
238: WF_CORE.CONTEXT('AS_RTTAP_ACCOUNT', 'CREATE_CONTACT_POINT_POST', p_event.getEventName(), p_subscription_guid);
239: WF_EVENT.setErrorInfo(p_event, 'ERROR');
240: RETURN 'ERROR';
241: WHEN OTHERS THEN

Line 282: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

278: PROCESS_RTTAP_ACCOUNT(l_party_id,p_return_status);
279: ELSIF l_owner_table_name = 'HZ_PARTIES' THEN
280: PROCESS_RTTAP_ACCOUNT(l_owner_table_id,p_return_status);
281: END IF;
282: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
284: END IF;
285: RETURN 'SUCCESS';
286: EXCEPTION

Line 283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

279: ELSIF l_owner_table_name = 'HZ_PARTIES' THEN
280: PROCESS_RTTAP_ACCOUNT(l_owner_table_id,p_return_status);
281: END IF;
282: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
284: END IF;
285: RETURN 'SUCCESS';
286: EXCEPTION
287: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 287: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
284: END IF;
285: RETURN 'SUCCESS';
286: EXCEPTION
287: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
288: WF_CORE.CONTEXT('AS_RTTAP_ACCOUNT', 'UPDATE_CONTACT_POINT_POST', p_event.getEventName(), p_subscription_guid);
289: WF_EVENT.setErrorInfo(p_event, 'ERROR');
290: RETURN 'ERROR';
291: WHEN OTHERS THEN

Line 308: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

304: p_return_status VARCHAR2(1);
305: BEGIN
306: FOR cur_party IN C2 LOOP
307: PROCESS_RTTAP_ACCOUNT(cur_party.party_id,p_return_status);
308: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
310: END IF;
311: END LOOP;
312: RETURN 'SUCCESS';

Line 309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

305: BEGIN
306: FOR cur_party IN C2 LOOP
307: PROCESS_RTTAP_ACCOUNT(cur_party.party_id,p_return_status);
308: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
310: END IF;
311: END LOOP;
312: RETURN 'SUCCESS';
313: EXCEPTION

Line 314: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

310: END IF;
311: END LOOP;
312: RETURN 'SUCCESS';
313: EXCEPTION
314: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
315: WF_CORE.CONTEXT('AS_RTTAP_ACCOUNT', 'UPDATE_LOCATION_POST', p_event.getEventName(), p_subscription_guid);
316: WF_EVENT.setErrorInfo(p_event, 'ERROR');
317: RETURN 'ERROR';
318: WHEN OTHERS THEN

Line 344: IF FND_API.to_Boolean( FND_API.G_FALSE ) THEN

340:
341: G_PARTY_ID := p_party_id;
342:
343: -- Initialize message list if p_init_msg_list is set to TRUE.
344: IF FND_API.to_Boolean( FND_API.G_FALSE ) THEN
345: FND_MSG_PUB.initialize;
346: END IF;
347:
348: -- Initialize API return status to SUCCESS

Line 349: x_return_status := FND_API.G_RET_STS_SUCCESS;

345: FND_MSG_PUB.initialize;
346: END IF;
347:
348: -- Initialize API return status to SUCCESS
349: x_return_status := FND_API.G_RET_STS_SUCCESS;
350:
351: IF NVL(FND_PROFILE.Value('AS_ENABLE_CUST_ONLINE_TAP'), 'N') <> 'Y' THEN
352: /*------------------------------------------------------+
353: | If REALTIME TAP profile is turned on there is NO need

Line 395: p_init_msg_list => FND_API.G_FALSE,

391: l_trans_rec.trans_object_id5 := jtf_terr_number_list(null);
392: l_trans_rec.txn_date := jtf_terr_date_list(null);
393: JTY_ASSIGN_REALTIME_PUB.get_winners(
394: p_api_version_number => 1.0,
395: p_init_msg_list => FND_API.G_FALSE,
396: p_source_id => -1001,
397: p_trans_id => -1002,
398: p_mode => 'REAL TIME:RESOURCE',
399: p_param_passing_mechanism => 'PBR',

Line 411: If l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

407: x_msg_data => l_msg_data,
408: x_winners_rec => l_WinningTerrMember_tbl);
409: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CW || AS_GAR.G_END);
410: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CW || AS_GAR.G_RETURN_STATUS || l_return_status);
411: If l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
412: FND_MSG_PUB.Count_And_Get
413: ( p_count => l_msg_count,
414: p_data => l_msg_data
415: );

Line 418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

414: p_data => l_msg_data
415: );
416: AS_UTILITY_PVT.Get_Messages(l_msg_count, l_msg_data);
417: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CW, l_msg_data, 'ERROR');
418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
419: End If;
420: If (l_WinningTerrMember_tbl.resource_id.count > 0) THEN
421: FOR i IN l_WinningTerrMember_tbl.terr_id.FIRST .. l_WinningTerrMember_tbl.terr_id.LAST LOOP
422: AS_GAR.LOG(G_ENTITY || 'Trans Object ID : ' || l_WinningTerrMember_tbl.trans_object_id(i) ||

Line 439: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

435:
436: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CEX_GROUPS || AS_GAR.G_END);
437: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CEX_GROUPS || AS_GAR.G_RETURN_STATUS || l_return_status);
438:
439: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
440: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CEX_GROUPS, l_errbuf, l_retcode);
441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
442: End If;
443:

Line 441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

437: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CEX_GROUPS || AS_GAR.G_RETURN_STATUS || l_return_status);
438:
439: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
440: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CEX_GROUPS, l_errbuf, l_retcode);
441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
442: End If;
443:
444: -- Explode TEAMS if any inside winners
445: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CEX_TEAMS || AS_GAR.G_START);

Line 455: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

451:
452: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CEX_TEAMS || AS_GAR.G_END);
453: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CEX_TEAMS || AS_GAR.G_RETURN_STATUS || l_return_status);
454:
455: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
456: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CEX_TEAMS, l_errbuf, l_retcode);
457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
458: End If;
459:

Line 457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

453: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CEX_TEAMS || AS_GAR.G_RETURN_STATUS || l_return_status);
454:
455: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
456: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CEX_TEAMS, l_errbuf, l_retcode);
457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
458: End If;
459:
460: -- Set team leader for ACCOUNTs
461: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_STLEAD || AS_GAR.G_START);

Line 471: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

467:
468: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_STLEAD || AS_GAR.G_END);
469: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_STLEAD || AS_GAR.G_RETURN_STATUS || l_return_status);
470:
471: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
472: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_STLEAD, l_errbuf, l_retcode);
473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
474: End If;
475:

Line 473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

469: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_STLEAD || AS_GAR.G_RETURN_STATUS || l_return_status);
470:
471: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
472: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_STLEAD, l_errbuf, l_retcode);
473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
474: End If;
475:
476: -- Insert into ACCOUNT Accesses from Winners
477: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSACC || AS_GAR.G_START);

Line 487: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

483:
484: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSACC || AS_GAR.G_END);
485: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSACC || AS_GAR.G_RETURN_STATUS || l_return_status);
486:
487: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
488: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSACC, l_errbuf, l_retcode);
489: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
490: End If;
491:

Line 489: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

485: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSACC || AS_GAR.G_RETURN_STATUS || l_return_status);
486:
487: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
488: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSACC, l_errbuf, l_retcode);
489: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
490: End If;
491:
492: -- Insert into territory Accesses
493: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSTERRACC || AS_GAR.G_START);

Line 503: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

499:
500: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSTERRACC || AS_GAR.G_END);
501: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSTERRACC || AS_GAR.G_RETURN_STATUS || l_return_status);
502:
503: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
504: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSTERRACC, l_errbuf, l_retcode);
505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
506: End If;
507: End If;

Line 505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

501: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSTERRACC || AS_GAR.G_RETURN_STATUS || l_return_status);
502:
503: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
504: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSTERRACC, l_errbuf, l_retcode);
505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
506: End If;
507: End If;
508:
509: -- Remove (soft delete) records in access table that are not qualified

Line 520: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

516:
517: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CC || AS_GAR.G_END);
518: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CC || AS_GAR.G_RETURN_STATUS || l_return_status);
519:
520: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
521: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CC, l_errbuf, l_retcode);
522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
523: End If;
524:

Line 522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

518: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CC || AS_GAR.G_RETURN_STATUS || l_return_status);
519:
520: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
521: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CC, l_errbuf, l_retcode);
522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
523: End If;
524:
525: END IF;
526:

Line 530: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

526:
527: COMMIT;
528:
529: EXCEPTION
530: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
531: x_return_status := FND_API.G_RET_STS_ERROR;
532: WHEN OTHERS THEN
533: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_TEAMS, SQLERRM, TO_CHAR(SQLCODE));
534: x_return_status := FND_API.G_RET_STS_ERROR;

Line 531: x_return_status := FND_API.G_RET_STS_ERROR;

527: COMMIT;
528:
529: EXCEPTION
530: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
531: x_return_status := FND_API.G_RET_STS_ERROR;
532: WHEN OTHERS THEN
533: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_TEAMS, SQLERRM, TO_CHAR(SQLCODE));
534: x_return_status := FND_API.G_RET_STS_ERROR;
535: END RTTAP_WRAPPER;

Line 534: x_return_status := FND_API.G_RET_STS_ERROR;

530: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
531: x_return_status := FND_API.G_RET_STS_ERROR;
532: WHEN OTHERS THEN
533: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_TEAMS, SQLERRM, TO_CHAR(SQLCODE));
534: x_return_status := FND_API.G_RET_STS_ERROR;
535: END RTTAP_WRAPPER;
536:
537:
538: /************************** Start Explode Teams ACCOUNTs ******************/

Line 573: x_return_status := FND_API.G_RET_STS_SUCCESS;

569:
570:
571: BEGIN
572: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_TEAMS || AS_GAR.G_START);
573: x_return_status := FND_API.G_RET_STS_SUCCESS;
574: /* Get resources within a resource team */
575: /** Note
576: Hard coding RS_EMPLOYEE INSTEAD OF resource_category IN following SQL
577: because JTA returns RS_EMPLOYEE AND NOT EMPLOYEE

Line 739: x_return_status := FND_API.G_RET_STS_ERROR;

735: WHEN others THEN
736: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_TEAMS, SQLERRM, TO_CHAR(SQLCODE));
737: x_errbuf := SQLERRM;
738: x_retcode := SQLCODE;
739: x_return_status := FND_API.G_RET_STS_ERROR;
740: END EXPLODE_TEAMS_ACCOUNTS;
741: /************************** End Explode Teams ACCOUNTs ******************/
742:
743: /************************** Start Explode Groups ACCOUNTs ******************/

Line 770: x_return_status := FND_API.G_RET_STS_SUCCESS;

766: l_resource_type vchar_list;
767:
768: BEGIN
769: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_TEAMS || AS_GAR.G_START);
770: x_return_status := FND_API.G_RET_STS_SUCCESS;
771: /* Get resources within a resource group */
772: /** Note
773: Hard coding RS_EMPLOYEE INSTEAD OF resource_category IN following SQL
774: because JTA returns RS_EMPLOYEE AND NOT EMPLOYEE

Line 851: x_return_status := FND_API.G_RET_STS_ERROR;

847: WHEN OTHERS THEN
848: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_GROUPS, SQLERRM, TO_CHAR(SQLCODE));
849: x_errbuf := SQLERRM;
850: x_retcode := SQLCODE;
851: x_return_status := FND_API.G_RET_STS_ERROR;
852: END EXPLODE_GROUPS_ACCOUNTS;
853:
854: PROCEDURE SET_TEAM_LEAD_ACCOUNTS(
855: x_errbuf OUT NOCOPY VARCHAR2,

Line 863: x_return_status := FND_API.G_RET_STS_SUCCESS;

859:
860: src_id NUMBER:= 0;
861: BEGIN
862: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_STLEAD || AS_GAR.G_START);
863: x_return_status := FND_API.G_RET_STS_SUCCESS;
864: IF p_WinningTerrMember_tbl.resource_id.COUNT > 0 THEN
865: FOR l_index IN p_WinningTerrMember_tbl.resource_id.FIRST..p_WinningTerrMember_tbl.resource_id.LAST LOOP
866: IF p_WinningTerrMember_tbl.resource_type(l_index) IN('RS_EMPLOYEE','RS_PARTY','RS_PARTNER')THEN
867: SELECT NVL(source_id,0) INTO src_id FROM JTF_RS_RESOURCE_EXTNS RES WHERE resource_id = p_WinningTerrMember_tbl.resource_id(l_index);

Line 893: x_return_status := FND_API.G_RET_STS_ERROR;

889: WHEN OTHERS THEN
890: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_STLEAD, SQLERRM, TO_CHAR(SQLCODE));
891: x_errbuf := SQLERRM;
892: x_retcode := SQLCODE;
893: x_return_status := FND_API.G_RET_STS_ERROR;
894: RAISE;
895: END SET_TEAM_LEAD_ACCOUNTS;
896:
897:

Line 905: x_return_status := FND_API.G_RET_STS_SUCCESS;

901: p_WinningTerrMember_tbl IN OUT NOCOPY JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type,
902: x_return_status OUT NOCOPY VARCHAR2) IS
903: BEGIN
904: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSACC || AS_GAR.G_START);
905: x_return_status := FND_API.G_RET_STS_SUCCESS;
906: IF p_WinningTerrMember_tbl.resource_id.COUNT > 0 THEN
907: FOR l_index IN p_WinningTerrMember_tbl.resource_id.FIRST..p_WinningTerrMember_tbl.resource_id.LAST LOOP
908: AS_GAR.LOG(G_ENTITY || G_PARTY_ID ||' : BEFORE INSERT :'|| '::' || 'RESOURCE/GROUP/RESOURCE_TYPE ' || p_WinningTerrMember_tbl.resource_id(l_index)
909: || '/' || p_WinningTerrMember_tbl.group_id(l_index) || '/' || p_WinningTerrMember_tbl.resource_type(l_index) );

Line 1044: x_return_status := FND_API.G_RET_STS_ERROR;

1040: WHEN OTHERS THEN
1041: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSACC, SQLERRM, TO_CHAR(SQLCODE));
1042: x_errbuf := SQLERRM;
1043: x_retcode := SQLCODE;
1044: x_return_status := FND_API.G_RET_STS_ERROR;
1045: END INSERT_ACCESSES_ACCOUNTS;
1046:
1047: PROCEDURE INSERT_TERR_ACCESSES_ACCOUNTS(
1048: x_errbuf OUT NOCOPY VARCHAR2,

Line 1054: x_return_status := FND_API.G_RET_STS_SUCCESS;

1050: p_WinningTerrMember_tbl IN OUT NOCOPY JTY_ASSIGN_REALTIME_PUB.bulk_winners_rec_type,
1051: x_return_status OUT NOCOPY VARCHAR2) IS
1052: BEGIN
1053: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC || AS_GAR.G_START);
1054: x_return_status := FND_API.G_RET_STS_SUCCESS;
1055: /*------------------------------------------------------------------------------+
1056: | we are deleting all rows for the entity from as_territory_accesses prior to
1057: | inserting into it because the logic for removing only certain terr_id/access_id
1058: | combinations is very complex and could be slow..

Line 1133: x_return_status := FND_API.G_RET_STS_ERROR;

1129: WHEN OTHERS THEN
1130: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC, SQLERRM, TO_CHAR(SQLCODE));
1131: x_errbuf := SQLERRM;
1132: x_retcode := SQLCODE;
1133: x_return_status := FND_API.G_RET_STS_ERROR;
1134: END INSERT_TERR_ACCESSES_ACCOUNTS;
1135:
1136: PROCEDURE PERFORM_ACCOUNT_CLEANUP(
1137: x_errbuf OUT NOCOPY VARCHAR2,

Line 1147: x_return_status := FND_API.G_RET_STS_SUCCESS;

1143: l_access_rec_id access_type;
1144:
1145: BEGIN
1146: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_START);
1147: x_return_status := FND_API.G_RET_STS_SUCCESS;
1148: DELETE FROM AS_ACCESSES_ALL ACC
1149: WHERE customer_id = G_PARTY_ID
1150: AND lead_id IS NULL
1151: AND sales_lead_id IS NULL

Line 1166: x_return_status := FND_API.G_RET_STS_ERROR;

1162: WHEN OTHERS THEN
1163: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC, SQLERRM, TO_CHAR(SQLCODE));
1164: x_errbuf := SQLERRM;
1165: x_retcode := SQLCODE;
1166: x_return_status := FND_API.G_RET_STS_ERROR;
1167: END PERFORM_ACCOUNT_CLEANUP;
1168:
1169:
1170: