[Home] [Help]
409: AND tu.team_id = t.team_id
410: AND tu.usage IN ('SALES','PRM')
411: AND tm.team_member_id = trr.role_resource_id
412: AND tm.delete_flag <> 'Y'
413: AND tm.resource_type = 'INDIVIDUAL'
414: AND trr.role_resource_type = 'RS_TEAM_MEMBER'
415: AND trr.delete_flag <> 'Y'
416: AND SYSDATE BETWEEN trr.start_date_active
417: AND NVL(trr.end_date_active,SYSDATE)
844: WHEN OTHERS THEN
845: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_STLEAD || AS_GAR.G_IND_UPD || AS_GAR.G_GENERAL_EXCEPTION);
846: AS_GAR.LOG('SALES_LEAD_ID/SALESFORCE_ID/SALESGROUP_ID/ORG_ID - ' || l_sales_lead_id(i) || '/' || l_salesforce_id(i) || '/' || l_sales_group_id(i) );
847: END;
848: END LOOP; -- for each record individually
849: COMMIT;
850: END IF;
851: END; -- end of deadlock exception
852: WHEN OTHERS THEN
1039: ,l_org_id(i)
1040: ,DECODE(STS.opp_open_status_flag, 'Y', 'Y', NULL)
1041: ,L.lead_rank_score
1042: ,L.creation_date
1043: FROM DUAL, AS_SALES_LEADS L, AS_STATUSES_B STS
1044: WHERE L.sales_lead_id = l_sales_lead_id(i)
1045: AND L.status_code = STS.status_code
1046: AND NOT EXISTS ( SELECT 'X'
1047: FROM AS_ACCESSES_ALL_ALL AA
1114: ,l_org_id(i)
1115: ,DECODE(STS.opp_open_status_flag, 'Y', 'Y', NULL)
1116: ,L.lead_rank_score
1117: ,L.creation_date
1118: FROM DUAL,AS_SALES_LEADS L, AS_STATUSES_B STS
1119: WHERE L.sales_lead_id = l_sales_lead_id(i)
1120: AND L.status_code = STS.status_code
1121: AND NOT EXISTS ( SELECT 'X'
1122: FROM AS_ACCESSES_ALL_ALL AA
1131: EXCEPTION
1132: WHEN OTHERS THEN
1133: NULL;
1134: END;
1135: END LOOP; /* loop for DUP_VAL_ON_INDEX individual insert */
1136: COMMIT;
1137: WHEN OTHERS THEN
1138: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSACC || AS_GAR.G_BULK_INS, SQLERRM, TO_CHAR(SQLCODE));
1139: x_errbuf := SQLERRM;