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 81: p_init_msg_list => FND_API.G_TRUE,

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

Line 98: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

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

Line 100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 116: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

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

Line 118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 134: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

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

Line 136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 152: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

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

Line 154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 168: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

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

Line 170: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 184: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

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

Line 186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 200: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

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

Line 202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

198: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CC || AS_GAR.G_RETURN_STATUS || l_return_status);
199:
200: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
201: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CC, l_errbuf, l_retcode);
202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
203: End If;
204:
205: -- LEAD Owner assignment
206: -- Lead Owner logic is re-written to sync with real time TAP for bug 8615468

Line 254: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

250: END IF;
251: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CO || AS_GAR.G_END);
252: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CO || AS_GAR.G_RETURN_STATUS || l_return_status);
253:
254: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
255: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CO, l_errbuf, l_retcode);
256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
257: End If;
258:

Line 256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

252: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CO || AS_GAR.G_RETURN_STATUS || l_return_status);
253:
254: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
255: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CO, l_errbuf, l_retcode);
256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
257: End If;
258:
259: -- BES enhancement
260:

Line 330: x_return_status := FND_API.G_RET_STS_SUCCESS;

326: AND rsc.terr_rsc_id = acc.terr_rsc_id;
327:
328: BEGIN
329: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_TEAMS || AS_GAR.G_START);
330: x_return_status := FND_API.G_RET_STS_SUCCESS;
331: l_request_id := p_terr_globals.request_id;
332: l_worker_id := p_terr_globals.worker_id;
333: l_resource_type := 'RS_TEAM';
334:

Line 545: x_return_status := FND_API.G_RET_STS_ERROR;

541: WHEN others THEN
542: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_TEAMS, SQLERRM, TO_CHAR(SQLCODE));
543: x_errbuf := SQLERRM;
544: x_retcode := SQLCODE;
545: x_return_status := FND_API.G_RET_STS_ERROR;
546: RAISE;
547: END EXPLODE_TEAMS_LEADS;
548: /************************** End Explode Teams Leads ******************/
549:

Line 596: x_return_status := FND_API.G_RET_STS_SUCCESS;

592: AND rsc.terr_rsc_id = acc.terr_rsc_id ;
593:
594: BEGIN
595: l_resource_type := 'RS_GROUP';
596: x_return_status := FND_API.G_RET_STS_SUCCESS;
597: l_request_id := p_terr_globals.request_id;
598: l_worker_id := p_terr_globals.worker_id;
599:
600: OPEN count_res_lead;

Line 726: x_return_status := FND_API.G_RET_STS_ERROR;

722: WHEN OTHERS THEN
723: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_GROUPS, SQLERRM, TO_CHAR(SQLCODE));
724: x_errbuf := SQLERRM;
725: x_retcode := SQLCODE;
726: x_return_status := FND_API.G_RET_STS_ERROR;
727: RAISE;
728: END EXPLODE_GROUPS_LEADS;
729: /************************** End Explode Groups Leads ******************/
730:

Line 798: x_return_status := FND_API.G_RET_STS_SUCCESS;

794:
795:
796: BEGIN
797: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_STLEAD || AS_GAR.G_START);
798: x_return_status := FND_API.G_RET_STS_SUCCESS;
799: l_worker_id:=p_terr_globals.worker_id;
800: l_var :=p_terr_globals.bulk_size;
801: l_max_fetches := p_terr_globals.cursor_limit;
802: LOOP -- For l_limit_flag

Line 897: x_return_status := FND_API.G_RET_STS_ERROR;

893: WHEN OTHERS THEN
894: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_STLEAD || AS_GAR.G_BULK_UPD, SQLERRM, TO_CHAR(SQLCODE));
895: x_errbuf := SQLERRM;
896: x_retcode := SQLCODE;
897: x_return_status := FND_API.G_RET_STS_ERROR;
898: RAISE;
899: END;
900: END LOOP; -- loop for 3 attempts
901: /* For the next batch of records by bulk_size */

Line 921: x_return_status := FND_API.G_RET_STS_ERROR;

917: WHEN OTHERS THEN
918: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_STLEAD, SQLERRM, TO_CHAR(SQLCODE));
919: x_errbuf := SQLERRM;
920: x_retcode := SQLCODE;
921: x_return_status := FND_API.G_RET_STS_ERROR;
922: RAISE;
923: END SET_TEAM_LEAD_LEADS;
924:
925: /************************** End Set Leads Team Leader *****************/

Line 985: x_return_status := FND_API.G_RET_STS_SUCCESS;

981: | Try bulk inserting into accesses. If this fails, insert records one by one.
982: |
983: +-------------------------------------------------------------------------*/
984: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSACC || AS_GAR.G_START);
985: x_return_status := FND_API.G_RET_STS_SUCCESS;
986: l_worker_id:=p_terr_globals.worker_id;
987: l_var :=p_terr_globals.bulk_size;
988: OPEN ins_acc(l_worker_id);
989: LOOP

Line 1182: x_return_status := FND_API.G_RET_STS_ERROR;

1178: WHEN OTHERS THEN
1179: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSACC || AS_GAR.G_BULK_INS, SQLERRM, TO_CHAR(SQLCODE));
1180: x_errbuf := SQLERRM;
1181: x_retcode := SQLCODE;
1182: x_return_status := FND_API.G_RET_STS_ERROR;
1183: RAISE;
1184: END;
1185: l_first := l_last + 1;
1186: l_last := l_first + l_var;

Line 1206: x_return_status := FND_API.G_RET_STS_ERROR;

1202: WHEN others THEN
1203: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSACC, SQLERRM, TO_CHAR(SQLCODE));
1204: x_errbuf := SQLERRM;
1205: x_retcode := SQLCODE;
1206: x_return_status := FND_API.G_RET_STS_ERROR;
1207: IF ins_acc%ISOPEN THEN CLOSE ins_acc; END IF;
1208: RAISE;
1209: END INSERT_ACCESSES_LEADS;
1210:

Line 1263: x_return_status := FND_API.G_RET_STS_SUCCESS;

1259: | and there is no involvement of role.
1260: |
1261: +-------------------------------------------------------------------------*/
1262: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC || AS_GAR.G_START);
1263: x_return_status := FND_API.G_RET_STS_SUCCESS;
1264: l_worker_id := p_terr_globals.worker_id;
1265: l_var := p_terr_globals.bulk_size;
1266: OPEN ins_tacc(l_worker_id);
1267: LOOP

Line 1404: x_return_status := FND_API.G_RET_STS_ERROR;

1400: WHEN Others THEN
1401: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC || AS_GAR.G_BULK_INS, SQLERRM, TO_CHAR(SQLCODE));
1402: x_errbuf := SQLERRM;
1403: x_retcode := SQLCODE;
1404: x_return_status := FND_API.G_RET_STS_ERROR;
1405: IF ins_tacc%ISOPEN THEN CLOSE ins_tacc; END IF;
1406: RAISE;
1407: END;
1408: l_first := l_last + 1;

Line 1421: x_return_status := FND_API.G_RET_STS_ERROR;

1417: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC , SQLERRM, TO_CHAR(SQLCODE));
1418: IF ins_tacc%ISOPEN THEN CLOSE ins_tacc; END IF;
1419: x_errbuf := SQLERRM;
1420: x_retcode := SQLCODE;
1421: x_return_status := FND_API.G_RET_STS_ERROR;
1422: RAISE;
1423: END;
1424: END LOOP; -- end loop for insert into territory accesses
1425: l_sales_lead_id.DELETE;

Line 1436: x_return_status := FND_API.G_RET_STS_ERROR;

1432: WHEN others THEN
1433: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC, SQLERRM, TO_CHAR(SQLCODE));
1434: x_errbuf := SQLERRM;
1435: x_retcode := SQLCODE;
1436: x_return_status := FND_API.G_RET_STS_ERROR;
1437: IF ins_tacc%ISOPEN THEN CLOSE ins_tacc; END IF;
1438: RAISE;
1439: END INSERT_TERR_ACCESSES_LEADS;
1440:

Line 1487: x_return_status := FND_API.G_RET_STS_SUCCESS;

1483: WHERE worker_id=c_worker_id;
1484:
1485: BEGIN
1486: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_START);
1487: x_return_status := FND_API.G_RET_STS_SUCCESS;
1488: l_worker_id := p_terr_globals.worker_id;
1489: l_var := p_terr_globals.bulk_size;
1490: l_max_fetches := p_terr_globals.cursor_limit;
1491:

Line 1639: x_return_status := FND_API.G_RET_STS_ERROR;

1635: IF del_lead_totalmode%ISOPEN THEN CLOSE del_lead_totalmode; END IF;
1636: IF del_lead_newmode%ISOPEN THEN CLOSE del_lead_newmode; END IF;
1637: x_errbuf := SQLERRM;
1638: x_retcode := SQLCODE;
1639: x_return_status := FND_API.G_RET_STS_ERROR;
1640: RAISE;
1641: END;
1642: END LOOP; --}L4 l_attempts loop 3 trys
1643: 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 1661: x_return_status := FND_API.G_RET_STS_ERROR;

1657: IF del_lead_totalmode%ISOPEN THEN CLOSE del_lead_totalmode; END IF;
1658: IF del_lead_newmode%ISOPEN THEN CLOSE del_lead_newmode; END IF;
1659: x_errbuf := SQLERRM;
1660: x_retcode := SQLCODE;
1661: x_return_status := FND_API.G_RET_STS_ERROR;
1662: RAISE;
1663: END;
1664: END LOOP;--}L1
1665: IF del_lead_totalmode%ISOPEN THEN CLOSE del_lead_totalmode; END IF;

Line 1672: x_return_status := FND_API.G_RET_STS_ERROR;

1668: WHEN OTHERS THEN
1669: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_GENERAL_EXCEPTION, SQLERRM, TO_CHAR(SQLCODE));
1670: x_errbuf := SQLERRM;
1671: x_retcode := SQLCODE;
1672: x_return_status := FND_API.G_RET_STS_ERROR;
1673: RAISE;
1674: END PERFORM_LEAD_CLEANUP;
1675:
1676: /************************** End Lead Cleanup ***********************/

Line 1765: x_return_status := FND_API.G_RET_STS_SUCCESS;

1761:
1762: BEGIN
1763: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || AS_GAR.G_START);
1764:
1765: x_return_status := FND_API.G_RET_STS_SUCCESS;
1766: l_worker_id:=p_terr_globals.worker_id;
1767: l_var :=p_terr_globals.bulk_size;
1768: l_max_fetches := p_terr_globals.cursor_limit;
1769: IF fnd_profile.value('AS_LEAD_ASSIGNMENT_UHK') = 'Y'

Line 1871: x_return_status := FND_API.G_RET_STS_ERROR;

1867: WHEN OTHERS THEN
1868: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'UPDATE AS_SALES_LEADS', SQLERRM, TO_CHAR(SQLCODE));
1869: x_errbuf := SQLERRM;
1870: x_retcode := SQLCODE;
1871: x_return_status := FND_API.G_RET_STS_ERROR;
1872: RAISE;
1873: END;
1874: END LOOP;
1875:

Line 1925: x_return_status := FND_API.G_RET_STS_ERROR;

1921: WHEN OTHERS THEN
1922: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'UPDATE SALES_LEADS ACCESSES', SQLERRM, TO_CHAR(SQLCODE));
1923: x_errbuf := SQLERRM;
1924: x_retcode := SQLCODE;
1925: x_return_status := FND_API.G_RET_STS_ERROR;
1926: RAISE;
1927: END;
1928: END LOOP;
1929: l_first := l_last + 1;

Line 1950: x_return_status := FND_API.G_RET_STS_ERROR;

1946: WHEN OTHERS THEN
1947: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || AS_GAR.G_GENERAL_EXCEPTION, SQLERRM, TO_CHAR(SQLCODE));
1948: x_errbuf := SQLERRM;
1949: x_retcode := SQLCODE;
1950: x_return_status := FND_API.G_RET_STS_ERROR;
1951: RAISE;
1952: END ASSIGN_LEAD_OWNER;
1953:
1954: /**************************** End Assign Lead Owner ********************/

Line 2071: x_return_status := FND_API.G_RET_STS_SUCCESS;

2067:
2068: BEGIN
2069: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || AS_GAR.G_START);
2070:
2071: x_return_status := FND_API.G_RET_STS_SUCCESS;
2072: l_worker_id:=p_terr_globals.worker_id;
2073: l_var :=p_terr_globals.bulk_size;
2074: l_max_fetches := p_terr_globals.cursor_limit;
2075:

Line 2297: x_return_status := FND_API.G_RET_STS_ERROR;

2293: WHEN OTHERS THEN
2294: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'INSERT INTO AS_ACCESSES_ALL_ALL', SQLERRM, TO_CHAR(SQLCODE));
2295: x_errbuf := SQLERRM;
2296: x_retcode := SQLCODE;
2297: x_return_status := FND_API.G_RET_STS_ERROR;
2298: RAISE;
2299: END;
2300: END LOOP;
2301:

Line 2360: x_return_status := FND_API.G_RET_STS_ERROR;

2356: WHEN OTHERS THEN
2357: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'UPDATE AS_ACCESSES_ALL_ALL', SQLERRM, TO_CHAR(SQLCODE));
2358: x_errbuf := SQLERRM;
2359: x_retcode := SQLCODE;
2360: x_return_status := FND_API.G_RET_STS_ERROR;
2361: RAISE;
2362: END;
2363: END LOOP;
2364:

Line 2418: x_return_status := FND_API.G_RET_STS_ERROR;

2414: WHEN OTHERS THEN
2415: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'UPDATE AS_SALES_LEADS', SQLERRM, TO_CHAR(SQLCODE));
2416: x_errbuf := SQLERRM;
2417: x_retcode := SQLCODE;
2418: x_return_status := FND_API.G_RET_STS_ERROR;
2419: RAISE;
2420: END;
2421: END LOOP;
2422: l_first := l_last + 1;

Line 2443: x_return_status := FND_API.G_RET_STS_ERROR;

2439: WHEN OTHERS THEN
2440: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || AS_GAR.G_GENERAL_EXCEPTION, SQLERRM, TO_CHAR(SQLCODE));
2441: x_errbuf := SQLERRM;
2442: x_retcode := SQLCODE;
2443: x_return_status := FND_API.G_RET_STS_ERROR;
2444: RAISE;
2445: END ASSIGN_DEFAULT_LEAD_OWNER;
2446:
2447: /**************************** End Assign_Default_Lead_Owner ********************/

Line 2506: x_return_status := FND_API.G_RET_STS_SUCCESS;

2502:
2503: BEGIN
2504: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || AS_GAR.G_START);
2505:
2506: x_return_status := FND_API.G_RET_STS_SUCCESS;
2507: l_worker_id:=p_terr_globals.worker_id;
2508: l_var :=p_terr_globals.bulk_size;
2509: l_max_fetches := p_terr_globals.cursor_limit;
2510: IF fnd_profile.value('AS_LEAD_ASSIGNMENT_UHK') = 'Y'

Line 2602: x_return_status := FND_API.G_RET_STS_ERROR;

2598: WHEN OTHERS THEN
2599: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'UPDATE AS_ACCESSES_ALL_ALL', SQLERRM, TO_CHAR(SQLCODE));
2600: x_errbuf := SQLERRM;
2601: x_retcode := SQLCODE;
2602: x_return_status := FND_API.G_RET_STS_ERROR;
2603: RAISE;
2604: END;
2605: END LOOP;
2606:

Line 2628: x_return_status := FND_API.G_RET_STS_ERROR;

2624: WHEN OTHERS THEN
2625: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || AS_GAR.G_GENERAL_EXCEPTION, SQLERRM, TO_CHAR(SQLCODE));
2626: x_errbuf := SQLERRM;
2627: x_retcode := SQLCODE;
2628: x_return_status := FND_API.G_RET_STS_ERROR;
2629: RAISE;
2630: END UNCHECK_LEAD_OWNER;
2631:
2632: /**************************** End Uncheck_Lead_Owner ********************/

Line 2702: x_return_status := FND_API.G_RET_STS_SUCCESS;

2698:
2699: BEGIN
2700: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || AS_GAR.G_START);
2701:
2702: x_return_status := FND_API.G_RET_STS_SUCCESS;
2703: l_worker_id:=p_terr_globals.worker_id;
2704: l_var :=p_terr_globals.bulk_size;
2705: l_max_fetches := p_terr_globals.cursor_limit;
2706: IF fnd_profile.value('AS_LEAD_ASSIGNMENT_UHK') = 'Y'

Line 2808: x_return_status := FND_API.G_RET_STS_ERROR;

2804: WHEN OTHERS THEN
2805: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'UPDATE AS_SALES_LEADS', SQLERRM, TO_CHAR(SQLCODE));
2806: x_errbuf := SQLERRM;
2807: x_retcode := SQLCODE;
2808: x_return_status := FND_API.G_RET_STS_ERROR;
2809: RAISE;
2810: END;
2811: END LOOP;
2812:

Line 2834: x_return_status := FND_API.G_RET_STS_ERROR;

2830: WHEN OTHERS THEN
2831: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || AS_GAR.G_GENERAL_EXCEPTION, SQLERRM, TO_CHAR(SQLCODE));
2832: x_errbuf := SQLERRM;
2833: x_retcode := SQLCODE;
2834: x_return_status := FND_API.G_RET_STS_ERROR;
2835: RAISE;
2836: END UNCHECK_ASSIGN_SALESFORCE;
2837:
2838: /**************************** End Uncheck_Assign_Salesforce ********************/