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 AS_GAR

Line 24: AS_GAR.g_debug_flag := 'Y';

20: tap_return_status VARCHAR2(1);
21: BEGIN
22:
23: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
24: AS_GAR.g_debug_flag := 'Y';
25: END IF;
26:
27: AS_BUSINESS_EVENT_PUB.Before_Cust_STeam_Update(
28: p_api_version_number => 2.0,

Line 38: AS_GAR.LOG('BE FOR ACCOUNT REALTIME TAP BEFORE UPDATE FAILED');

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:
42: RTTAP_WRAPPER(p_party_Id,p_return_status);

Line 58: AS_GAR.LOG('BE FOR ACCOUNT REALTIME TAP AFTER UPDATE FAILED');

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;
62:

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

380: AND ACC.sales_lead_id IS NULL
381: AND ACC.request_id IS NULL );
382:
383: ELSE
384: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CW || AS_GAR.G_START);
385:
386:
387: l_trans_rec.trans_object_id1 := jtf_terr_number_list(G_PARTY_ID);
388: l_trans_rec.trans_object_id2 := jtf_terr_number_list(null);

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

405: x_return_status => l_return_status,
406: x_msg_count => l_msg_count,
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,

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

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

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

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

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

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) ||
423: 'Trans Detail Object ID : ' || l_WinningTerrMember_tbl.trans_detail_object_id(i) ||
424: 'Terr ID : ' || l_WinningTerrMember_tbl.terr_id(i) || ' Terr Name : ' || l_WinningTerrMember_tbl.terr_name(i) ||
425: ' Resource ID : ' || l_WinningTerrMember_tbl.resource_id(i) ||
426: ' Resource TYPE : ' || l_WinningTerrMember_tbl.resource_type(i));

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

425: ' Resource ID : ' || l_WinningTerrMember_tbl.resource_id(i) ||
426: ' Resource TYPE : ' || l_WinningTerrMember_tbl.resource_type(i));
427: END LOOP;
428: -- Explode GROUPS if any inside winners
429: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CEX_GROUPS || AS_GAR.G_START);
430: AS_RTTAP_ACCOUNT.EXPLODE_GROUPS_ACCOUNTS(
431: x_errbuf => l_errbuf,
432: x_retcode => l_retcode,
433: p_WinningTerrMember_tbl => l_WinningTerrMember_tbl,

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

432: x_retcode => l_retcode,
433: p_WinningTerrMember_tbl => l_WinningTerrMember_tbl,
434: x_return_status => l_return_status);
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);

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

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

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

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

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

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);
446: AS_RTTAP_ACCOUNT.EXPLODE_TEAMS_ACCOUNTS(
447: x_errbuf => l_errbuf,
448: x_retcode => l_retcode,
449: p_WinningTerrMember_tbl => l_WinningTerrMember_tbl,

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

448: x_retcode => l_retcode,
449: p_WinningTerrMember_tbl => l_WinningTerrMember_tbl,
450: x_return_status => l_return_status);
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);

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

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

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

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:
460: -- Set team leader for ACCOUNTs

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

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);
462: AS_RTTAP_ACCOUNT.SET_TEAM_LEAD_ACCOUNTS(
463: x_errbuf => l_errbuf,
464: x_retcode => l_retcode,
465: p_WinningTerrMember_tbl => l_WinningTerrMember_tbl,

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

464: x_retcode => l_retcode,
465: p_WinningTerrMember_tbl => l_WinningTerrMember_tbl,
466: x_return_status => l_return_status);
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);

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

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

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

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:
476: -- Insert into ACCOUNT Accesses from Winners

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

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);
478: AS_RTTAP_ACCOUNT.INSERT_ACCESSES_ACCOUNTS(
479: x_errbuf => l_errbuf,
480: x_retcode => l_retcode,
481: p_WinningTerrMember_tbl => l_WinningTerrMember_tbl,

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

480: x_retcode => l_retcode,
481: p_WinningTerrMember_tbl => l_WinningTerrMember_tbl,
482: x_return_status => l_return_status);
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);

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

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

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

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

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

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);
494: AS_RTTAP_ACCOUNT.INSERT_TERR_ACCESSES_ACCOUNTS(
495: x_errbuf => l_errbuf,
496: x_retcode => l_retcode,
497: p_WinningTerrMember_tbl => l_WinningTerrMember_tbl,

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

496: x_retcode => l_retcode,
497: p_WinningTerrMember_tbl => l_WinningTerrMember_tbl,
498: x_return_status => l_return_status);
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);

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

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

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

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;
508:

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

506: End If;
507: End If;
508:
509: -- Remove (soft delete) records in access table that are not qualified
510: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CC || AS_GAR.G_START);
511: AS_RTTAP_ACCOUNT.PERFORM_ACCOUNT_CLEANUP(
512: x_errbuf => l_errbuf,
513: x_retcode => l_retcode,
514: p_WinningTerrMember_tbl => l_WinningTerrMember_tbl,

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

513: x_retcode => l_retcode,
514: p_WinningTerrMember_tbl => l_WinningTerrMember_tbl,
515: x_return_status => l_return_status);
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);

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

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

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

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

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

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;
536:
537:

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

568: l_resource_type vchar_list;
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

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

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

Line 700: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_GROUPS || AS_GAR.G_INS_WINNERS ||

696: AND jtm.group_id = g.group_id
697: GROUP BY m.resource_id, m.person_id, jtm.team_id, res.CATEGORY) J
698:
699: WHERE j.team_id = p_WinningTerrMember_tbl.resource_id(l_index);
700: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_GROUPS || AS_GAR.G_INS_WINNERS ||
701: AS_GAR.G_N_ROWS_PROCESSED || SQL%ROWCOUNT ||' FOR TEAM '||p_WinningTerrMember_tbl.resource_id(l_index));
702:
703: IF l_resource_id.COUNT > 0 THEN
704: FOR i IN l_resource_id.FIRST .. l_resource_id.LAST LOOP

Line 701: AS_GAR.G_N_ROWS_PROCESSED || SQL%ROWCOUNT ||' FOR TEAM '||p_WinningTerrMember_tbl.resource_id(l_index));

697: GROUP BY m.resource_id, m.person_id, jtm.team_id, res.CATEGORY) J
698:
699: WHERE j.team_id = p_WinningTerrMember_tbl.resource_id(l_index);
700: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_GROUPS || AS_GAR.G_INS_WINNERS ||
701: AS_GAR.G_N_ROWS_PROCESSED || SQL%ROWCOUNT ||' FOR TEAM '||p_WinningTerrMember_tbl.resource_id(l_index));
702:
703: IF l_resource_id.COUNT > 0 THEN
704: FOR i IN l_resource_id.FIRST .. l_resource_id.LAST LOOP
705: /* No need to Check to see if it is already part of

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

728: END LOOP;
729: END IF;
730: END IF;
731: END LOOP;
732: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_TEAMS || AS_GAR.G_INS_WINNERS || AS_GAR.G_END);
733: END IF; /* if p_WinningTerrMember_tbl.resource_id.COUNT > 0 */
734: EXCEPTION
735: WHEN others THEN
736: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_TEAMS, SQLERRM, TO_CHAR(SQLCODE));

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

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

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

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

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

772: /** Note
773: Hard coding RS_EMPLOYEE INSTEAD OF resource_category IN following SQL
774: because JTA returns RS_EMPLOYEE AND NOT EMPLOYEE
775: **/
776: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_TEAMS || AS_GAR.G_INS_WINNERS || AS_GAR.G_START);
777: IF p_WinningTerrMember_tbl.resource_id.COUNT > 0 THEN
778: FOR l_index IN p_WinningTerrMember_tbl.resource_id.FIRST..p_WinningTerrMember_tbl.resource_id.LAST LOOP
779: IF p_WinningTerrMember_tbl.resource_type(l_index) = 'RS_GROUP' THEN
780:

Line 812: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_GROUPS || AS_GAR.G_INS_WINNERS ||

808: AND res.category IN ('EMPLOYEE','PARTY','PARTNER')
809: GROUP BY m.group_member_id, m.resource_id, m.person_id,
810: m.group_id, res.CATEGORY) j
811: WHERE j.group_id = p_WinningTerrMember_tbl.resource_id(l_index);
812: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_GROUPS || AS_GAR.G_INS_WINNERS ||
813: AS_GAR.G_N_ROWS_PROCESSED || SQL%ROWCOUNT ||' FOR GROUP '||p_WinningTerrMember_tbl.resource_id(l_index));
814: IF l_resource_id.COUNT > 0 THEN
815: FOR i IN l_resource_id.FIRST .. l_resource_id.LAST LOOP
816: /* No need to Check to see if it is already part of

Line 813: AS_GAR.G_N_ROWS_PROCESSED || SQL%ROWCOUNT ||' FOR GROUP '||p_WinningTerrMember_tbl.resource_id(l_index));

809: GROUP BY m.group_member_id, m.resource_id, m.person_id,
810: m.group_id, res.CATEGORY) j
811: WHERE j.group_id = p_WinningTerrMember_tbl.resource_id(l_index);
812: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_GROUPS || AS_GAR.G_INS_WINNERS ||
813: AS_GAR.G_N_ROWS_PROCESSED || SQL%ROWCOUNT ||' FOR GROUP '||p_WinningTerrMember_tbl.resource_id(l_index));
814: IF l_resource_id.COUNT > 0 THEN
815: FOR i IN l_resource_id.FIRST .. l_resource_id.LAST LOOP
816: /* No need to Check to see if it is already part of
817: p_WinningTerrMember_tbl because this will be slow,

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

839: END LOOP;
840: END IF;
841: END IF;
842: END LOOP;
843: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_GROUPS || AS_GAR.G_INS_WINNERS || AS_GAR.G_END);
844: COMMIT;
845: END IF; /* if p_WinningTerrMember_tbl.resource_id.COUNT > 0 */
846: EXCEPTION
847: WHEN OTHERS THEN

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

844: COMMIT;
845: END IF; /* if p_WinningTerrMember_tbl.resource_id.COUNT > 0 */
846: EXCEPTION
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;

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

858: x_return_status OUT NOCOPY VARCHAR2) IS
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

Line 868: AS_GAR.LOG(G_ENTITY || G_PARTY_ID ||' : BEFORE UPDATE :'|| '::' || 'RESOURCE/GROUP/RESOURCE_TYPE/SOURCE_ID::' || p_WinningTerrMember_tbl.resource_id(l_index)

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);
868: AS_GAR.LOG(G_ENTITY || G_PARTY_ID ||' : BEFORE UPDATE :'|| '::' || 'RESOURCE/GROUP/RESOURCE_TYPE/SOURCE_ID::' || p_WinningTerrMember_tbl.resource_id(l_index)
869: || '/' || p_WinningTerrMember_tbl.group_id(l_index) || '/' || p_WinningTerrMember_tbl.resource_type(l_index) || '/' || src_id);
870: ---IF p_WinningTerrMember_tbl.resource_type(l_index) = 'RS_EMPLOYEE' THEN
871: UPDATE AS_ACCESSES_ALL ACC
872: SET object_version_number = nvl(object_version_number,0) + 1,

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

883: ---END IF;
884: END IF;
885: END LOOP;
886: END IF;
887: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_STLEAD || AS_GAR.G_END);
888: EXCEPTION
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;

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

886: END IF;
887: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_STLEAD || AS_GAR.G_END);
888: EXCEPTION
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;

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

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

Line 908: AS_GAR.LOG(G_ENTITY || G_PARTY_ID ||' : BEFORE INSERT :'|| '::' || 'RESOURCE/GROUP/RESOURCE_TYPE ' || p_WinningTerrMember_tbl.resource_id(l_index)

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) );
910:
911: --added inline view in the select clause of Insert statement to fetch the salesforce role code for Employee resource --fix for bug 5869095
912:

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

1034: AND NVL(ACC.sales_group_id,-777) = NVL(p_WinningTerrMember_tbl.group_id(l_index),-777) );
1035: END IF;
1036: END LOOP;
1037: END IF;
1038: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSACC || AS_GAR.G_END);
1039: EXCEPTION
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;

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

1037: END IF;
1038: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSACC || AS_GAR.G_END);
1039: EXCEPTION
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;

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

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

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

1123: END IF;
1124: END LOOP;
1125: END IF;
1126:
1127: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC || AS_GAR.G_END);
1128: EXCEPTION
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;

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

1126:
1127: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC || AS_GAR.G_END);
1128: EXCEPTION
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;

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

1142: TYPE access_type IS TABLE OF NUMBER;
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

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

1155: (SELECT rownum ROW_NUM,A.COLUMN_VALUE RES FROM TABLE(CAST(p_WinningTerrMember_tbl.resource_id AS jtf_terr_number_list)) a) RESTAB,
1156: (SELECT rownum ROW_NUM,b.COLUMN_VALUE GRP FROM TABLE(CAST(p_WinningTerrMember_tbl.group_id AS jtf_terr_number_list)) b) GRPTAB
1157: WHERE RESTAB.ROW_NUM = GRPTAB.ROW_NUM
1158: ) ;
1159: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_N_ROWS_PROCESSED || SQL%ROWCOUNT);
1160: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_END);
1161: EXCEPTION
1162: WHEN OTHERS THEN
1163: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC, SQLERRM, TO_CHAR(SQLCODE));

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

1156: (SELECT rownum ROW_NUM,b.COLUMN_VALUE GRP FROM TABLE(CAST(p_WinningTerrMember_tbl.group_id AS jtf_terr_number_list)) b) GRPTAB
1157: WHERE RESTAB.ROW_NUM = GRPTAB.ROW_NUM
1158: ) ;
1159: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_N_ROWS_PROCESSED || SQL%ROWCOUNT);
1160: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_END);
1161: EXCEPTION
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;

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

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