[Home] [Help]
414: AND tu.team_id = t.team_id
415: AND tu.usage IN ('SALES','PRM')
416: AND tm.team_member_id = trr.role_resource_id
417: AND tm.delete_flag <> 'Y'
418: AND tm.resource_type = 'INDIVIDUAL'
419: AND trr.role_resource_type = 'RS_TEAM_MEMBER'
420: AND trr.delete_flag <> 'Y'
421: AND SYSDATE BETWEEN trr.start_date_active
422: AND NVL(trr.end_date_active,SYSDATE)
848: WHEN OTHERS THEN
849: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_STLEAD || AS_GAR.G_IND_UPD || AS_GAR.G_GENERAL_EXCEPTION);
850: AS_GAR.LOG('LEAD_ID/SALESFORCE_ID/SALESGROUP_ID/ORG_ID - ' || l_lead_id(i) || '/' || l_salesforce_id(i) || '/' || l_sales_group_id(i));
851: END;
852: END LOOP; -- for each record individually
853: COMMIT;
854: END IF;
855: END; -- end of deadlock exception
856: WHEN OTHERS THEN
1037: ,SYSDATE
1038: ,'Y'
1039: ,l_org_id(i)
1040: ,DECODE(STS.opp_open_status_flag, 'Y', 'Y', NULL)
1041: FROM DUAL, AS_LEADS_ALL L, AS_STATUSES_B STS
1042: WHERE L.lead_id = l_lead_id(i)
1043: AND L.status = STS.status_code
1044: AND NOT EXISTS ( SELECT 'X'
1045: FROM AS_ACCESSES_ALL_ALL AA
1108: ,SYSDATE
1109: ,'Y'
1110: ,l_org_id(i)
1111: ,DECODE(STS.opp_open_status_flag, 'Y', 'Y', NULL)
1112: FROM DUAL,AS_LEADS_ALL L, AS_STATUSES_B STS
1113: WHERE L.lead_id = l_lead_id(i)
1114: AND L.status = STS.status_code
1115: AND NOT EXISTS ( SELECT 'X'
1116: FROM AS_ACCESSES_ALL_ALL AA
1125: EXCEPTION
1126: WHEN OTHERS THEN
1127: NULL;
1128: END;
1129: END LOOP; /* loop for DUP_VAL_ON_INDEX individual insert */
1130: COMMIT;
1131: WHEN OTHERS THEN
1132: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSACC || AS_GAR.G_BULK_INS, SQLERRM, TO_CHAR(SQLCODE));
1133: x_errbuf := SQLERRM;