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

Line 87: p_init_msg_list => FND_API.G_TRUE,

83: /* This inserts into account winners */
84: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CW || AS_GAR.G_START);
85: JTY_ASSIGN_BULK_PUB.GET_WINNERS
86: ( p_api_version_number => 1.0,
87: p_init_msg_list => FND_API.G_TRUE,
88: p_source_id => -1001,
89: p_trans_id => -1002,
90: P_PROGRAM_NAME => 'SALES/ACCOUNT PROGRAM',
91: P_mode => l_target_type,

Line 102: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

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

Line 104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 120: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

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

Line 122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 138: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

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

Line 140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 156: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

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

Line 158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

154: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_STLEAD || AS_GAR.G_RETURN_STATUS || l_return_status);
155:
156: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
157: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_STLEAD, l_errbuf, l_retcode);
158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
159: End If;
160:
161: -- Insert into Account Accesses from Winners
162: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSACC || AS_GAR.G_START);

Line 172: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

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

Line 174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 188: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

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

Line 190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

186: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSTERRACC || AS_GAR.G_RETURN_STATUS || l_return_status);
187:
188: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
189: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSTERRACC, l_errbuf, l_retcode);
190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
191: End If;
192:
193: -- Create External Sales Team records for Account (No partner processing for opptys and leads)
194: OPEN get_count(l_terr_globals.worker_id);

Line 208: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

204:
205: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_STLEAD || 'PRM:: ' || AS_GAR.G_END);
206: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_STLEAD || 'PRM:: ' || AS_GAR.G_RETURN_STATUS || l_return_status);
207:
208: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
209: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_STLEAD || 'PRM:: ', l_errbuf, l_retcode);
210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
211: End If;
212:

Line 210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

206: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_STLEAD || 'PRM:: ' || AS_GAR.G_RETURN_STATUS || l_return_status);
207:
208: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
209: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_STLEAD || 'PRM:: ', l_errbuf, l_retcode);
210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
211: End If;
212:
213: -- Insert into Account Accesses from Winners
214: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSACC || 'PRM:: ' || AS_GAR.G_START);

Line 224: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

220:
221: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSACC || 'PRM:: ' || AS_GAR.G_END);
222: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSACC || 'PRM:: ' || AS_GAR.G_RETURN_STATUS || l_return_status);
223:
224: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
225: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSACC || 'PRM:: ', l_errbuf, l_retcode);
226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
227: End If;
228:

Line 226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

222: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSACC || 'PRM:: ' || AS_GAR.G_RETURN_STATUS || l_return_status);
223:
224: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
225: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSACC || 'PRM:: ', l_errbuf, l_retcode);
226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
227: End If;
228:
229: -- Insert into territory Accesses
230: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSTERRACC || 'PRM:: ' || AS_GAR.G_START);

Line 240: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

236:
237: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSTERRACC || 'PRM:: ' || AS_GAR.G_END);
238: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSTERRACC || 'PRM:: ' || AS_GAR.G_RETURN_STATUS || l_return_status);
239:
240: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
241: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSTERRACC || 'PRM:: ', l_errbuf, l_retcode);
242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
243: End If;
244:

Line 242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

238: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSTERRACC || 'PRM:: ' || AS_GAR.G_RETURN_STATUS || l_return_status);
239:
240: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
241: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSTERRACC || 'PRM:: ', l_errbuf, l_retcode);
242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
243: End If;
244:
245: END IF;
246:

Line 258: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

254:
255: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CC || AS_GAR.G_END);
256: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CC || AS_GAR.G_RETURN_STATUS || l_return_status);
257:
258: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
259: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CC, l_errbuf, l_retcode);
260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
261: End If;
262:

Line 260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

256: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CC || AS_GAR.G_RETURN_STATUS || l_return_status);
257:
258: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
259: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CC, l_errbuf, l_retcode);
260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
261: End If;
262:
263: -- BES enhancement
264:

Line 334: x_return_status := FND_API.G_RET_STS_SUCCESS;

330:
331:
332: BEGIN
333: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_TEAMS || AS_GAR.G_START);
334: x_return_status := FND_API.G_RET_STS_SUCCESS;
335: l_request_id := p_terr_globals.request_id;
336: l_worker_id := p_terr_globals.worker_id;
337: l_resource_type := 'RS_TEAM';
338:

Line 550: x_return_status := FND_API.G_RET_STS_ERROR;

546: WHEN others THEN
547: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_TEAMS, SQLERRM, TO_CHAR(SQLCODE));
548: x_errbuf := SQLERRM;
549: x_retcode := SQLCODE;
550: x_return_status := FND_API.G_RET_STS_ERROR;
551: END EXPLODE_TEAMS_ACCOUNTS;
552: /************************** End Explode Teams Accounts ******************/
553:
554: /************************** Start Explode Groups Accounts ******************/

Line 600: x_return_status := FND_API.G_RET_STS_SUCCESS;

596: AND rules.source_id = -1001
597: AND rsc.terr_rsc_id = acc.terr_rsc_id;
598:
599: BEGIN
600: x_return_status := FND_API.G_RET_STS_SUCCESS;
601: l_resource_type := 'RS_GROUP';
602: l_request_id := p_terr_globals.request_id;
603: l_worker_id := p_terr_globals.worker_id;
604:

Line 731: x_return_status := FND_API.G_RET_STS_ERROR;

727: WHEN others THEN
728: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_GROUPS, SQLERRM, TO_CHAR(SQLCODE));
729: x_errbuf := SQLERRM;
730: x_retcode := SQLCODE;
731: x_return_status := FND_API.G_RET_STS_ERROR;
732: END EXPLODE_GROUPS_ACCOUNTS;
733: /************************** End Explode Groups Accounts ******************/
734:
735: /************************** Start Set Accounts Team Leader *****************/

Line 802: x_return_status := FND_API.G_RET_STS_SUCCESS;

798:
799:
800: BEGIN
801: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_STLEAD || AS_GAR.G_START);
802: x_return_status := FND_API.G_RET_STS_SUCCESS;
803: l_worker_id:=p_terr_globals.worker_id;
804: l_var :=p_terr_globals.bulk_size;
805: l_MAX_fetches := p_terr_globals.cursor_limit;
806: LOOP -- For l_limit_flag

Line 903: x_return_status := FND_API.G_RET_STS_ERROR;

899: WHEN OTHERS THEN
900: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_STLEAD || AS_GAR.G_BULK_UPD, SQLERRM, TO_CHAR(SQLCODE));
901: x_errbuf := SQLERRM;
902: x_retcode := SQLCODE;
903: x_return_status := FND_API.G_RET_STS_ERROR;
904: END;
905: END LOOP; -- loop for 3 attempts
906: /* For the next batch of records by bulk_size */
907: l_first := l_last + 1;

Line 926: x_return_status := FND_API.G_RET_STS_ERROR;

922: WHEN OTHERS THEN
923: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_STLEAD, SQLERRM, TO_CHAR(SQLCODE));
924: x_errbuf := SQLERRM;
925: x_retcode := SQLCODE;
926: x_return_status := FND_API.G_RET_STS_ERROR;
927: END SET_TEAM_LEAD_ACCOUNTS;
928:
929: /************************** End Set Accounts Team Leader *****************/
930:

Line 1039: x_return_status := FND_API.G_RET_STS_SUCCESS;

1035: | Try bulk inserting into accesses. If this fails, insert records one by one.
1036: |
1037: +-------------------------------------------------------------------------*/
1038: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSACC || AS_GAR.G_START);
1039: x_return_status := FND_API.G_RET_STS_SUCCESS;
1040: l_worker_id:=p_terr_globals.worker_id;
1041: l_var :=p_terr_globals.bulk_size;
1042:
1043: -- BEGIN salesforce role code check

Line 1252: x_return_status := FND_API.G_RET_STS_ERROR;

1248: WHEN OTHERS THEN
1249: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSACC || AS_GAR.G_BULK_INS, SQLERRM, TO_CHAR(SQLCODE));
1250: x_errbuf := SQLERRM;
1251: x_retcode := SQLCODE;
1252: x_return_status := FND_API.G_RET_STS_ERROR;
1253: END;
1254: l_first := l_last + 1;
1255: l_last := l_first + l_var;
1256: IF l_first > l_customer_id.last THEN

Line 1279: x_return_status := FND_API.G_RET_STS_ERROR;

1275: WHEN others THEN
1276: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSACC, SQLERRM, TO_CHAR(SQLCODE));
1277: x_errbuf := SQLERRM;
1278: x_retcode := SQLCODE;
1279: x_return_status := FND_API.G_RET_STS_ERROR;
1280: IF ins_acc%ISOPEN THEN CLOSE ins_acc; END IF;
1281: IF ins_acc2%ISOPEN THEN CLOSE ins_acc2; END IF;
1282: END INSERT_ACCESSES_ACCOUNTS;
1283:

Line 1336: x_return_status := FND_API.G_RET_STS_SUCCESS;

1332: | and there is no involvement of role.
1333: |
1334: +-------------------------------------------------------------------------*/
1335: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC || AS_GAR.G_START);
1336: x_return_status := FND_API.G_RET_STS_SUCCESS;
1337: l_worker_id := p_terr_globals.worker_id;
1338: l_var := p_terr_globals.bulk_size;
1339: OPEN ins_tacc(l_worker_id);
1340: LOOP

Line 1477: x_return_status := FND_API.G_RET_STS_ERROR;

1473: WHEN Others THEN
1474: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC || AS_GAR.G_BULK_INS, SQLERRM, TO_CHAR(SQLCODE));
1475: x_errbuf := SQLERRM;
1476: x_retcode := SQLCODE;
1477: x_return_status := FND_API.G_RET_STS_ERROR;
1478: IF ins_tacc%ISOPEN THEN CLOSE ins_tacc; END IF;
1479: END;
1480: l_first := l_last + 1;
1481: l_last := l_first + l_var;

Line 1493: x_return_status := FND_API.G_RET_STS_ERROR;

1489: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC , SQLERRM, TO_CHAR(SQLCODE));
1490: IF ins_tacc%ISOPEN THEN CLOSE ins_tacc; END IF;
1491: x_errbuf := SQLERRM;
1492: x_retcode := SQLCODE;
1493: x_return_status := FND_API.G_RET_STS_ERROR;
1494: END;
1495: END LOOP; -- end loop for insert into territory accesses
1496: l_customer_id.DELETE;
1497: l_salesforce_id.DELETE;

Line 1507: x_return_status := FND_API.G_RET_STS_ERROR;

1503: WHEN others THEN
1504: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC, SQLERRM, TO_CHAR(SQLCODE));
1505: x_errbuf := SQLERRM;
1506: x_retcode := SQLCODE;
1507: x_return_status := FND_API.G_RET_STS_ERROR;
1508: IF ins_tacc%ISOPEN THEN CLOSE ins_tacc; END IF;
1509: END INSERT_TERR_ACCESSES_ACCOUNTS;
1510:
1511: /************************** End Insert Into Terr Accesses*************/

Line 1600: x_return_status := FND_API.G_RET_STS_SUCCESS;

1596:
1597:
1598: BEGIN
1599: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_STLEAD || 'PRM::' || AS_GAR.G_START);
1600: x_return_status := FND_API.G_RET_STS_SUCCESS;
1601: l_worker_id:=p_terr_globals.worker_id;
1602: l_var :=p_terr_globals.bulk_size;
1603: l_MAX_fetches := p_terr_globals.cursor_limit;
1604: LOOP -- For l_limit_flag

Line 1708: x_return_status := FND_API.G_RET_STS_ERROR;

1704: WHEN OTHERS THEN
1705: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_STLEAD || 'PRM::' || AS_GAR.G_BULK_UPD, SQLERRM, TO_CHAR(SQLCODE));
1706: x_errbuf := SQLERRM;
1707: x_retcode := SQLCODE;
1708: x_return_status := FND_API.G_RET_STS_ERROR;
1709: END;
1710: END LOOP; -- loop for 3 attempts
1711: /* For the next batch of records by bulk_size */
1712: l_first := l_last + 1;

Line 1733: x_return_status := FND_API.G_RET_STS_ERROR;

1729: WHEN OTHERS THEN
1730: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_STLEAD || 'PRM::', SQLERRM, TO_CHAR(SQLCODE));
1731: x_errbuf := SQLERRM;
1732: x_retcode := SQLCODE;
1733: x_return_status := FND_API.G_RET_STS_ERROR;
1734: END SET_TEAM_LEAD_PRM_ACCOUNTS;
1735:
1736: /************************** End Set Accounts Team Leader PRM*****************/
1737:

Line 1828: x_return_status := FND_API.G_RET_STS_SUCCESS;

1824: | Try bulk inserting into accesses. If this fails, insert records one by one.
1825: |
1826: +-------------------------------------------------------------------------*/
1827: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSACC || 'PRM::' || AS_GAR.G_START);
1828: x_return_status := FND_API.G_RET_STS_SUCCESS;
1829: l_worker_id:=p_terr_globals.worker_id;
1830: l_var :=p_terr_globals.bulk_size;
1831: OPEN ins_rs_partner(l_worker_id);
1832: LOOP

Line 1993: x_return_status := FND_API.G_RET_STS_ERROR;

1989: WHEN OTHERS THEN
1990: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSACC || 'PRM::' || AS_GAR.G_BULK_INS, SQLERRM, TO_CHAR(SQLCODE));
1991: x_errbuf := SQLERRM;
1992: x_retcode := SQLCODE;
1993: x_return_status := FND_API.G_RET_STS_ERROR;
1994: END;
1995: l_first := l_last + 1;
1996: l_last := l_first + l_var;
1997: IF l_first > l_customer_id.last THEN

Line 2019: x_return_status := FND_API.G_RET_STS_ERROR;

2015: WHEN others THEN
2016: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSACC || 'PRM::', SQLERRM, TO_CHAR(SQLCODE));
2017: x_errbuf := SQLERRM;
2018: x_retcode := SQLCODE;
2019: x_return_status := FND_API.G_RET_STS_ERROR;
2020: IF ins_rs_partner%ISOPEN THEN CLOSE ins_rs_partner; END IF;
2021: END INSERT_ACCESSES_PRM_ACCOUNTS;
2022:
2023: /************************** End Insert Into Entity Accesses PRM ********/

Line 2082: x_return_status := FND_API.G_RET_STS_SUCCESS;

2078: | and there is no involvement of role.
2079: |
2080: +-------------------------------------------------------------------------*/
2081: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC || 'PRM::' || AS_GAR.G_START);
2082: x_return_status := FND_API.G_RET_STS_SUCCESS;
2083: l_worker_id := p_terr_globals.worker_id;
2084: l_var := p_terr_globals.bulk_size;
2085: OPEN ins_tacc_rs_partner(l_worker_id);
2086: LOOP

Line 2225: x_return_status := FND_API.G_RET_STS_ERROR;

2221: WHEN Others THEN
2222: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC || 'PRM::' || AS_GAR.G_BULK_INS, SQLERRM, TO_CHAR(SQLCODE));
2223: x_errbuf := SQLERRM;
2224: x_retcode := SQLCODE;
2225: x_return_status := FND_API.G_RET_STS_ERROR;
2226: IF ins_tacc_rs_partner%ISOPEN THEN CLOSE ins_tacc_rs_partner; END IF;
2227: END;
2228: l_first := l_last + 1;
2229: l_last := l_first + l_var;

Line 2241: x_return_status := FND_API.G_RET_STS_ERROR;

2237: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC || 'PRM::' , SQLERRM, TO_CHAR(SQLCODE));
2238: IF ins_tacc_rs_partner%ISOPEN THEN CLOSE ins_tacc_rs_partner; END IF;
2239: x_errbuf := SQLERRM;
2240: x_retcode := SQLCODE;
2241: x_return_status := FND_API.G_RET_STS_ERROR;
2242:
2243: END;
2244: END LOOP; -- end loop for insert into territory accesses
2245: l_terr_id.DELETE;

Line 2256: x_return_status := FND_API.G_RET_STS_ERROR;

2252: WHEN others THEN
2253: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC || 'PRM::', SQLERRM, TO_CHAR(SQLCODE));
2254: x_errbuf := SQLERRM;
2255: x_retcode := SQLCODE;
2256: x_return_status := FND_API.G_RET_STS_ERROR;
2257: IF ins_tacc_rs_partner%ISOPEN THEN CLOSE ins_tacc_rs_partner; END IF;
2258: END INSERT_TERR_ACCESSES_PRM_ACCS;
2259:
2260: /************************** End Insert Into Terr Accesses PRM ********/

Line 2307: x_return_status := FND_API.G_RET_STS_SUCCESS;

2303:
2304: BEGIN
2305: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_START);
2306:
2307: x_return_status := FND_API.G_RET_STS_SUCCESS;
2308: l_worker_id := p_terr_globals.worker_id;
2309: l_var := p_terr_globals.bulk_size;
2310: l_MAX_fetches := p_terr_globals.cursor_limit;
2311: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || 'Bulk Size'|| l_var || 'Cursor Limit' || l_MAX_fetches);

Line 2467: x_return_status := FND_API.G_RET_STS_ERROR;

2463: IF del_acct_totalmode%ISOPEN THEN CLOSE del_acct_totalmode; END IF;
2464: IF del_acct_newmode%ISOPEN THEN CLOSE del_acct_newmode; END IF;
2465: x_errbuf := SQLERRM;
2466: x_retcode := SQLCODE;
2467: x_return_status := FND_API.G_RET_STS_ERROR;
2468: END;
2469: END LOOP; --}L4 l_attempts loop 3 trys
2470: 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);
2471: l_first := l_last + 1;

Line 2487: x_return_status := FND_API.G_RET_STS_ERROR;

2483: IF del_acct_totalmode%ISOPEN THEN CLOSE del_acct_totalmode; END IF;
2484: IF del_acct_newmode%ISOPEN THEN CLOSE del_acct_newmode; END IF;
2485: x_errbuf := SQLERRM;
2486: x_retcode := SQLCODE;
2487: x_return_status := FND_API.G_RET_STS_ERROR;
2488: END;
2489: END LOOP;--}L1
2490: IF del_acct_totalmode%ISOPEN THEN CLOSE del_acct_totalmode; END IF;
2491: IF del_acct_newmode%ISOPEN THEN CLOSE del_acct_newmode; END IF;

Line 2497: x_return_status := FND_API.G_RET_STS_ERROR;

2493: WHEN OTHERS THEN
2494: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_GENERAL_EXCEPTION, SQLERRM, TO_CHAR(SQLCODE));
2495: x_errbuf := SQLERRM;
2496: x_retcode := SQLCODE;
2497: x_return_status := FND_API.G_RET_STS_ERROR;
2498: END Perform_Account_Cleanup;
2499:
2500: /************************** End Account Cleanup ***********************/
2501: