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

Line 78: p_init_msg_list => FND_API.G_TRUE,

74: /* This inserts into Lead winners */
75: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CW || AS_GAR.G_START);
76: JTY_ASSIGN_BULK_PUB.GET_WINNERS
77: ( p_api_version_number => 1.0,
78: p_init_msg_list => FND_API.G_TRUE,
79: p_source_id => -1001,
80: p_trans_id => -1003,
81: P_PROGRAM_NAME => 'SALES/LEAD PROGRAM',
82: P_mode => l_target_type,

Line 95: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

91:
92: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CW || AS_GAR.G_END);
93: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CW || AS_GAR.G_RETURN_STATUS || l_return_status);
94:
95: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
96: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CW, l_errbuf, l_retcode);
97: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
98: End If;
99:

Line 97: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

93: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CW || AS_GAR.G_RETURN_STATUS || l_return_status);
94:
95: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
96: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CW, l_errbuf, l_retcode);
97: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
98: End If;
99:
100: COMMIT;
101:

Line 113: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

109:
110: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CEX_GROUPS || AS_GAR.G_END);
111: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CEX_GROUPS || AS_GAR.G_RETURN_STATUS || l_return_status);
112:
113: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
114: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CEX_GROUPS, l_errbuf, l_retcode);
115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
116: End If;
117:

Line 115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

111: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CEX_GROUPS || AS_GAR.G_RETURN_STATUS || l_return_status);
112:
113: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
114: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CEX_GROUPS, l_errbuf, l_retcode);
115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
116: End If;
117:
118: COMMIT;
119:

Line 131: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

127:
128: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CEX_TEAMS || AS_GAR.G_END);
129: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CEX_TEAMS || AS_GAR.G_RETURN_STATUS || l_return_status);
130:
131: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
132: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CEX_TEAMS, l_errbuf, l_retcode);
133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
134: End If;
135:

Line 133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

129: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CEX_TEAMS || AS_GAR.G_RETURN_STATUS || l_return_status);
130:
131: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
132: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CEX_TEAMS, l_errbuf, l_retcode);
133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
134: End If;
135:
136: COMMIT;
137:

Line 149: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

145:
146: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_STLEAD || AS_GAR.G_END);
147: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_STLEAD || AS_GAR.G_RETURN_STATUS || l_return_status);
148:
149: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
150: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_STLEAD, l_errbuf, l_retcode);
151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
152: End If;
153:

Line 151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

147: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_STLEAD || AS_GAR.G_RETURN_STATUS || l_return_status);
148:
149: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
150: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_STLEAD, l_errbuf, l_retcode);
151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
152: End If;
153:
154: -- Insert into Lead Accesses from Winners
155: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSACC || AS_GAR.G_START);

Line 165: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

161:
162: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSACC || AS_GAR.G_END);
163: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSACC || AS_GAR.G_RETURN_STATUS || l_return_status);
164:
165: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
166: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSACC, l_errbuf, l_retcode);
167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
168: End If;
169:

Line 167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

163: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSACC || AS_GAR.G_RETURN_STATUS || l_return_status);
164:
165: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
166: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSACC, l_errbuf, l_retcode);
167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
168: End If;
169:
170: -- Insert into territory Accesses
171: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSTERRACC || AS_GAR.G_START);

Line 181: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

177:
178: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSTERRACC || AS_GAR.G_END);
179: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSTERRACC || AS_GAR.G_RETURN_STATUS || l_return_status);
180:
181: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
182: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSTERRACC, l_errbuf, l_retcode);
183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
184: End If;
185:

Line 183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

179: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSTERRACC || AS_GAR.G_RETURN_STATUS || l_return_status);
180:
181: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
182: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSTERRACC, l_errbuf, l_retcode);
183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
184: End If;
185:
186: -- Remove (soft delete) records in access table that are not qualified
187: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CC || AS_GAR.G_START);

Line 197: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

193:
194: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CC || AS_GAR.G_END);
195: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CC || AS_GAR.G_RETURN_STATUS || l_return_status);
196:
197: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
198: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CC, l_errbuf, l_retcode);
199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
200: End If;
201:

Line 199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

195: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CC || AS_GAR.G_RETURN_STATUS || l_return_status);
196:
197: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
198: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CC, l_errbuf, l_retcode);
199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
200: End If;
201:
202: -- LEAD Owner assignment
203: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CO || AS_GAR.G_START);

Line 213: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

209:
210: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CO || AS_GAR.G_END);
211: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CO || AS_GAR.G_RETURN_STATUS || l_return_status);
212:
213: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
214: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CO, l_errbuf, l_retcode);
215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
216: End If;
217:

Line 215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

211: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CO || AS_GAR.G_RETURN_STATUS || l_return_status);
212:
213: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
214: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CO, l_errbuf, l_retcode);
215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
216: End If;
217:
218: -- BES enhancement
219:

Line 289: x_return_status := FND_API.G_RET_STS_SUCCESS;

285: AND rsc.terr_rsc_id = acc.terr_rsc_id;
286:
287: BEGIN
288: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_TEAMS || AS_GAR.G_START);
289: x_return_status := FND_API.G_RET_STS_SUCCESS;
290: l_request_id := p_terr_globals.request_id;
291: l_worker_id := p_terr_globals.worker_id;
292: l_resource_type := 'RS_TEAM';
293:

Line 504: x_return_status := FND_API.G_RET_STS_ERROR;

500: WHEN others THEN
501: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_TEAMS, SQLERRM, TO_CHAR(SQLCODE));
502: x_errbuf := SQLERRM;
503: x_retcode := SQLCODE;
504: x_return_status := FND_API.G_RET_STS_ERROR;
505: RAISE;
506: END EXPLODE_TEAMS_LEADS;
507: /************************** End Explode Teams Leads ******************/
508:

Line 555: x_return_status := FND_API.G_RET_STS_SUCCESS;

551: AND rsc.terr_rsc_id = acc.terr_rsc_id ;
552:
553: BEGIN
554: l_resource_type := 'RS_GROUP';
555: x_return_status := FND_API.G_RET_STS_SUCCESS;
556: l_request_id := p_terr_globals.request_id;
557: l_worker_id := p_terr_globals.worker_id;
558:
559: OPEN count_res_lead;

Line 685: x_return_status := FND_API.G_RET_STS_ERROR;

681: WHEN OTHERS THEN
682: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_GROUPS, SQLERRM, TO_CHAR(SQLCODE));
683: x_errbuf := SQLERRM;
684: x_retcode := SQLCODE;
685: x_return_status := FND_API.G_RET_STS_ERROR;
686: RAISE;
687: END EXPLODE_GROUPS_LEADS;
688: /************************** End Explode Groups Leads ******************/
689:

Line 757: x_return_status := FND_API.G_RET_STS_SUCCESS;

753:
754:
755: BEGIN
756: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_STLEAD || AS_GAR.G_START);
757: x_return_status := FND_API.G_RET_STS_SUCCESS;
758: l_worker_id:=p_terr_globals.worker_id;
759: l_var :=p_terr_globals.bulk_size;
760: l_max_fetches := p_terr_globals.cursor_limit;
761: LOOP -- For l_limit_flag

Line 856: x_return_status := FND_API.G_RET_STS_ERROR;

852: WHEN OTHERS THEN
853: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_STLEAD || AS_GAR.G_BULK_UPD, SQLERRM, TO_CHAR(SQLCODE));
854: x_errbuf := SQLERRM;
855: x_retcode := SQLCODE;
856: x_return_status := FND_API.G_RET_STS_ERROR;
857: RAISE;
858: END;
859: END LOOP; -- loop for 3 attempts
860: /* For the next batch of records by bulk_size */

Line 880: x_return_status := FND_API.G_RET_STS_ERROR;

876: WHEN OTHERS THEN
877: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_STLEAD, SQLERRM, TO_CHAR(SQLCODE));
878: x_errbuf := SQLERRM;
879: x_retcode := SQLCODE;
880: x_return_status := FND_API.G_RET_STS_ERROR;
881: RAISE;
882: END SET_TEAM_LEAD_LEADS;
883:
884: /************************** End Set Leads Team Leader *****************/

Line 944: x_return_status := FND_API.G_RET_STS_SUCCESS;

940: | Try bulk inserting into accesses. If this fails, insert records one by one.
941: |
942: +-------------------------------------------------------------------------*/
943: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSACC || AS_GAR.G_START);
944: x_return_status := FND_API.G_RET_STS_SUCCESS;
945: l_worker_id:=p_terr_globals.worker_id;
946: l_var :=p_terr_globals.bulk_size;
947: OPEN ins_acc(l_worker_id);
948: LOOP

Line 1141: x_return_status := FND_API.G_RET_STS_ERROR;

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;
1140: x_retcode := SQLCODE;
1141: x_return_status := FND_API.G_RET_STS_ERROR;
1142: RAISE;
1143: END;
1144: l_first := l_last + 1;
1145: l_last := l_first + l_var;

Line 1165: x_return_status := FND_API.G_RET_STS_ERROR;

1161: WHEN others THEN
1162: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSACC, SQLERRM, TO_CHAR(SQLCODE));
1163: x_errbuf := SQLERRM;
1164: x_retcode := SQLCODE;
1165: x_return_status := FND_API.G_RET_STS_ERROR;
1166: IF ins_acc%ISOPEN THEN CLOSE ins_acc; END IF;
1167: RAISE;
1168: END INSERT_ACCESSES_LEADS;
1169:

Line 1222: x_return_status := FND_API.G_RET_STS_SUCCESS;

1218: | and there is no involvement of role.
1219: |
1220: +-------------------------------------------------------------------------*/
1221: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC || AS_GAR.G_START);
1222: x_return_status := FND_API.G_RET_STS_SUCCESS;
1223: l_worker_id := p_terr_globals.worker_id;
1224: l_var := p_terr_globals.bulk_size;
1225: OPEN ins_tacc(l_worker_id);
1226: LOOP

Line 1363: x_return_status := FND_API.G_RET_STS_ERROR;

1359: WHEN Others THEN
1360: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC || AS_GAR.G_BULK_INS, SQLERRM, TO_CHAR(SQLCODE));
1361: x_errbuf := SQLERRM;
1362: x_retcode := SQLCODE;
1363: x_return_status := FND_API.G_RET_STS_ERROR;
1364: IF ins_tacc%ISOPEN THEN CLOSE ins_tacc; END IF;
1365: RAISE;
1366: END;
1367: l_first := l_last + 1;

Line 1380: x_return_status := FND_API.G_RET_STS_ERROR;

1376: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC , SQLERRM, TO_CHAR(SQLCODE));
1377: IF ins_tacc%ISOPEN THEN CLOSE ins_tacc; END IF;
1378: x_errbuf := SQLERRM;
1379: x_retcode := SQLCODE;
1380: x_return_status := FND_API.G_RET_STS_ERROR;
1381: RAISE;
1382: END;
1383: END LOOP; -- end loop for insert into territory accesses
1384: l_sales_lead_id.DELETE;

Line 1395: x_return_status := FND_API.G_RET_STS_ERROR;

1391: WHEN others THEN
1392: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC, SQLERRM, TO_CHAR(SQLCODE));
1393: x_errbuf := SQLERRM;
1394: x_retcode := SQLCODE;
1395: x_return_status := FND_API.G_RET_STS_ERROR;
1396: IF ins_tacc%ISOPEN THEN CLOSE ins_tacc; END IF;
1397: RAISE;
1398: END INSERT_TERR_ACCESSES_LEADS;
1399:

Line 1446: x_return_status := FND_API.G_RET_STS_SUCCESS;

1442: WHERE worker_id=c_worker_id;
1443:
1444: BEGIN
1445: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_START);
1446: x_return_status := FND_API.G_RET_STS_SUCCESS;
1447: l_worker_id := p_terr_globals.worker_id;
1448: l_var := p_terr_globals.bulk_size;
1449: l_max_fetches := p_terr_globals.cursor_limit;
1450:

Line 1598: x_return_status := FND_API.G_RET_STS_ERROR;

1594: IF del_lead_totalmode%ISOPEN THEN CLOSE del_lead_totalmode; END IF;
1595: IF del_lead_newmode%ISOPEN THEN CLOSE del_lead_newmode; END IF;
1596: x_errbuf := SQLERRM;
1597: x_retcode := SQLCODE;
1598: x_return_status := FND_API.G_RET_STS_ERROR;
1599: RAISE;
1600: END;
1601: END LOOP; --}L4 l_attempts loop 3 trys
1602: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_UPD_ACCESSES || AS_GAR.G_N_ROWS_PROCESSED || l_first || '-' || l_last);

Line 1620: x_return_status := FND_API.G_RET_STS_ERROR;

1616: IF del_lead_totalmode%ISOPEN THEN CLOSE del_lead_totalmode; END IF;
1617: IF del_lead_newmode%ISOPEN THEN CLOSE del_lead_newmode; END IF;
1618: x_errbuf := SQLERRM;
1619: x_retcode := SQLCODE;
1620: x_return_status := FND_API.G_RET_STS_ERROR;
1621: RAISE;
1622: END;
1623: END LOOP;--}L1
1624: IF del_lead_totalmode%ISOPEN THEN CLOSE del_lead_totalmode; END IF;

Line 1631: x_return_status := FND_API.G_RET_STS_ERROR;

1627: WHEN OTHERS THEN
1628: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_GENERAL_EXCEPTION, SQLERRM, TO_CHAR(SQLCODE));
1629: x_errbuf := SQLERRM;
1630: x_retcode := SQLCODE;
1631: x_return_status := FND_API.G_RET_STS_ERROR;
1632: RAISE;
1633: END PERFORM_LEAD_CLEANUP;
1634:
1635: /************************** End Lead Cleanup ***********************/

Line 1724: x_return_status := FND_API.G_RET_STS_SUCCESS;

1720:
1721: BEGIN
1722: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || AS_GAR.G_START);
1723:
1724: x_return_status := FND_API.G_RET_STS_SUCCESS;
1725: l_worker_id:=p_terr_globals.worker_id;
1726: l_var :=p_terr_globals.bulk_size;
1727: l_max_fetches := p_terr_globals.cursor_limit;
1728: IF fnd_profile.value('AS_LEAD_ASSIGNMENT_UHK') = 'Y'

Line 1830: x_return_status := FND_API.G_RET_STS_ERROR;

1826: WHEN OTHERS THEN
1827: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'UPDATE AS_SALES_LEADS', SQLERRM, TO_CHAR(SQLCODE));
1828: x_errbuf := SQLERRM;
1829: x_retcode := SQLCODE;
1830: x_return_status := FND_API.G_RET_STS_ERROR;
1831: RAISE;
1832: END;
1833: END LOOP;
1834:

Line 1884: x_return_status := FND_API.G_RET_STS_ERROR;

1880: WHEN OTHERS THEN
1881: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'UPDATE SALES_LEADS ACCESSES', SQLERRM, TO_CHAR(SQLCODE));
1882: x_errbuf := SQLERRM;
1883: x_retcode := SQLCODE;
1884: x_return_status := FND_API.G_RET_STS_ERROR;
1885: RAISE;
1886: END;
1887: END LOOP;
1888: l_first := l_last + 1;

Line 1909: x_return_status := FND_API.G_RET_STS_ERROR;

1905: WHEN OTHERS THEN
1906: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || AS_GAR.G_GENERAL_EXCEPTION, SQLERRM, TO_CHAR(SQLCODE));
1907: x_errbuf := SQLERRM;
1908: x_retcode := SQLCODE;
1909: x_return_status := FND_API.G_RET_STS_ERROR;
1910: RAISE;
1911: END ASSIGN_LEAD_OWNER;
1912:
1913: /**************************** End Assign Lead Owner ********************/