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

Line 108: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

104: CLOSE terr_changed;
105: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PREATA || AS_GAR.G_END);
106: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PREATA || AS_GAR.G_RETURN_STATUS || l_return_status);
107:
108: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
110: End If;
111: -- Setting account where clause
112: IF l_terr_changed IS NULL THEN

Line 109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

105: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PREATA || AS_GAR.G_END);
106: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PREATA || AS_GAR.G_RETURN_STATUS || l_return_status);
107:
108: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
110: End If;
111: -- Setting account where clause
112: IF l_terr_changed IS NULL THEN
113: IF P_account_type = 'ORGANIZATION' THEN

Line 171: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

167:
168: --fix for bug(5869095) --populating as_terr_resources_tmp table
169:
170:
171: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
172: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_ACCOUNT, l_errbuf, l_retcode);
173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
174: End If;
175:

Line 173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

169:
170:
171: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
172: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_ACCOUNT, l_errbuf, l_retcode);
173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
174: End If;
175:
176: -- Setting Lead where clause
177: l_addl_where := NULL;

Line 204: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

200: ,x_return_status => l_return_status);
201: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_LEAD || AS_GAR.G_END);
202: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_LEAD || AS_GAR.G_RETURN_STATUS || l_return_status);
203:
204: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
205: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_LEAD, l_errbuf, l_retcode);
206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
207: End If;
208:

Line 206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

202: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_LEAD || AS_GAR.G_RETURN_STATUS || l_return_status);
203:
204: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
205: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_LEAD, l_errbuf, l_retcode);
206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
207: End If;
208:
209: -- Setting Opportunity where clause
210: l_addl_where := NULL;

Line 236: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

232: ,x_return_status => l_return_status);
233: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_OPPTY || AS_GAR.G_END);
234: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_OPPTY || AS_GAR.G_RETURN_STATUS || l_return_status);
235:
236: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
237: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_OPPTY, l_errbuf, l_retcode);
238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
239: End If;
240:

Line 238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

234: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_OPPTY || AS_GAR.G_RETURN_STATUS || l_return_status);
235:
236: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
237: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_OPPTY, l_errbuf, l_retcode);
238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
239: End If;
240:
241: -- Setting Quotes where clause
242: l_addl_where := NULL;

Line 273: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

269: ,x_return_status => l_return_status);
270: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_QUOTE || AS_GAR.G_END);
271: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_QUOTE || AS_GAR.G_RETURN_STATUS || l_return_status);
272:
273: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
274: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_QUOTE, l_errbuf, l_retcode);
275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
276: End If;
277: -- Setting Proposal where clause

Line 275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

271: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_QUOTE || AS_GAR.G_RETURN_STATUS || l_return_status);
272:
273: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
274: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_QUOTE, l_errbuf, l_retcode);
275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
276: End If;
277: -- Setting Proposal where clause
278: l_addl_where := NULL;
279: IF l_terr_changed IS NULL THEN

Line 295: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

291: ,x_return_status => l_return_status);
292: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_PROPOSAL || AS_GAR.G_END);
293: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_PROPOSAL || AS_GAR.G_RETURN_STATUS || l_return_status);
294:
295: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
296: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_PROPOSAL, l_errbuf, l_retcode);
297: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
298: End If;
299: IF l_terr_changed IS NULL THEN

Line 297: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

293: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_PROPOSAL || AS_GAR.G_RETURN_STATUS || l_return_status);
294:
295: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
296: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_PROPOSAL, l_errbuf, l_retcode);
297: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
298: End If;
299: IF l_terr_changed IS NULL THEN
300: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_DEL_CHNG || 'ALL_SALES' || AS_GAR.G_START);
301: DELETE_CHANGED_ENTITY('ALL_SALES',

Line 308: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

304: ,x_return_status =>l_return_status);
305: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_DEL_CHNG ||'ALL_SALES' || AS_GAR.G_END);
306: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_DEL_CHNG ||'ALL_SALES' || AS_GAR.G_RETURN_STATUS || l_return_status);
307:
308: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
309: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO ||'ALL_SALES' || G_DEL_CHNG, l_errbuf, l_retcode);
310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
311: End If;
312:

Line 310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

306: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_DEL_CHNG ||'ALL_SALES' || AS_GAR.G_RETURN_STATUS || l_return_status);
307:
308: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
309: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO ||'ALL_SALES' || G_DEL_CHNG, l_errbuf, l_retcode);
310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
311: End If;
312:
313: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_DEL_CHNG || 'ALL_QUOTES' || AS_GAR.G_START);
314: DELETE_CHANGED_ENTITY('ALL_QUOTES',

Line 321: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

317: ,x_return_status =>l_return_status);
318: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_DEL_CHNG ||'ALL_QUOTES' || AS_GAR.G_END);
319: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_DEL_CHNG ||'ALL_QUOTES' || AS_GAR.G_RETURN_STATUS || l_return_status);
320:
321: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
322: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO ||'ALL_QUOTES' || G_DEL_CHNG, l_errbuf, l_retcode);
323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
324: End If;
325: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_DEL_CHNG || 'ALL_PROPOSALS' || AS_GAR.G_START);

Line 323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

319: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_DEL_CHNG ||'ALL_QUOTES' || AS_GAR.G_RETURN_STATUS || l_return_status);
320:
321: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
322: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO ||'ALL_QUOTES' || G_DEL_CHNG, l_errbuf, l_retcode);
323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
324: End If;
325: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_DEL_CHNG || 'ALL_PROPOSALS' || AS_GAR.G_START);
326: DELETE_CHANGED_ENTITY('ALL_PROPOSALS',
327: x_errbuf =>l_errbuf

Line 333: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

329: ,x_return_status =>l_return_status);
330: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_DEL_CHNG ||'ALL_PROPOSALS' || AS_GAR.G_END);
331: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_DEL_CHNG ||'ALL_PROPOSALS' || AS_GAR.G_RETURN_STATUS || l_return_status);
332:
333: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
334: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO ||'ALL_PROPOSALS' || G_DEL_CHNG, l_errbuf, l_retcode);
335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
336: End If;
337:

Line 335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

331: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_DEL_CHNG ||'ALL_PROPOSALS' || AS_GAR.G_RETURN_STATUS || l_return_status);
332:
333: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
334: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO ||'ALL_PROPOSALS' || G_DEL_CHNG, l_errbuf, l_retcode);
335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
336: End If;
337:
338: ELSE
339: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_DEL_CHNG || 'ACCOUNT' || AS_GAR.G_START);

Line 347: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

343: ,x_return_status =>l_return_status);
344: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_DEL_CHNG ||'ACCOUNT' || AS_GAR.G_END);
345: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_DEL_CHNG ||'ACCOUNT' || AS_GAR.G_RETURN_STATUS || l_return_status);
346:
347: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
348: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO ||'ACCOUNT' || G_DEL_CHNG, l_errbuf, l_retcode);
349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
350: End If;
351:

Line 349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

345: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_DEL_CHNG ||'ACCOUNT' || AS_GAR.G_RETURN_STATUS || l_return_status);
346:
347: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
348: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO ||'ACCOUNT' || G_DEL_CHNG, l_errbuf, l_retcode);
349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
350: End If;
351:
352: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_DEL_CHNG || 'LEAD' || AS_GAR.G_START);
353: DELETE_CHANGED_ENTITY('LEAD',

Line 360: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

356: ,x_return_status =>l_return_status);
357: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_DEL_CHNG ||'LEAD' || AS_GAR.G_END);
358: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_DEL_CHNG ||'LEAD' || AS_GAR.G_RETURN_STATUS || l_return_status);
359:
360: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
361: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO ||'LEAD' || G_DEL_CHNG, l_errbuf, l_retcode);
362: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
363: End If;
364:

Line 362: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

358: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_DEL_CHNG ||'LEAD' || AS_GAR.G_RETURN_STATUS || l_return_status);
359:
360: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
361: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO ||'LEAD' || G_DEL_CHNG, l_errbuf, l_retcode);
362: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
363: End If;
364:
365: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_DEL_CHNG || 'OPPTY' || AS_GAR.G_START);
366: DELETE_CHANGED_ENTITY('OPPTY',

Line 373: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

369: ,x_return_status =>l_return_status);
370: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_DEL_CHNG ||'OPPTY' || AS_GAR.G_END);
371: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_DEL_CHNG ||'OPPTY' || AS_GAR.G_RETURN_STATUS || l_return_status);
372:
373: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
374: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO ||'OPPTY' || G_DEL_CHNG, l_errbuf, l_retcode);
375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
376: End If;
377:

Line 375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

371: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_DEL_CHNG ||'OPPTY' || AS_GAR.G_RETURN_STATUS || l_return_status);
372:
373: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
374: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO ||'OPPTY' || G_DEL_CHNG, l_errbuf, l_retcode);
375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
376: End If;
377:
378: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_DEL_CHNG || 'QUOTE' || AS_GAR.G_START);
379: DELETE_CHANGED_ENTITY('QUOTE',

Line 386: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

382: ,x_return_status =>l_return_status);
383: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_DEL_CHNG ||'QUOTE' || AS_GAR.G_END);
384: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_DEL_CHNG ||'QUOTE' || AS_GAR.G_RETURN_STATUS || l_return_status);
385:
386: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
387: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO ||'QUOTE' || G_DEL_CHNG, l_errbuf, l_retcode);
388: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
389: End If;
390: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_DEL_CHNG || 'PROPOSAL' || AS_GAR.G_START);

Line 388: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

384: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_DEL_CHNG ||'QUOTE' || AS_GAR.G_RETURN_STATUS || l_return_status);
385:
386: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
387: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO ||'QUOTE' || G_DEL_CHNG, l_errbuf, l_retcode);
388: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
389: End If;
390: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_DEL_CHNG || 'PROPOSAL' || AS_GAR.G_START);
391: DELETE_CHANGED_ENTITY('PROPOSAL',
392: x_errbuf =>l_errbuf

Line 398: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

394: ,x_return_status =>l_return_status);
395: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_DEL_CHNG ||'PROPOSAL' || AS_GAR.G_END);
396: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_DEL_CHNG ||'PROPOSAL' || AS_GAR.G_RETURN_STATUS || l_return_status);
397:
398: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
399: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO ||'PROPOSAL' || G_DEL_CHNG, l_errbuf, l_retcode);
400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
401: End If;
402: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_POSTATA || AS_GAR.G_START);

Line 400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

396: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_DEL_CHNG ||'PROPOSAL' || AS_GAR.G_RETURN_STATUS || l_return_status);
397:
398: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
399: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO ||'PROPOSAL' || G_DEL_CHNG, l_errbuf, l_retcode);
400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
401: End If;
402: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_POSTATA || AS_GAR.G_START);
403: AS_ATA_NEW_PUB.POST_ATA(
404: x_return_status => l_return_status);

Line 409: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

405:
406: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_POSTATA || AS_GAR.G_END);
407: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_POSTATA || AS_GAR.G_RETURN_STATUS || l_return_status);
408:
409: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
410: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
411: End If;
412: END IF;
413: AS_GAR.LOG(G_ENTITY || l_proc || AS_GAR.G_END);

Line 410: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

406: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_POSTATA || AS_GAR.G_END);
407: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_POSTATA || AS_GAR.G_RETURN_STATUS || l_return_status);
408:
409: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
410: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
411: End If;
412: END IF;
413: AS_GAR.LOG(G_ENTITY || l_proc || AS_GAR.G_END);
414: EXCEPTION

Line 415: WHEN FND_API.G_EXC_ERROR THEN

411: End If;
412: END IF;
413: AS_GAR.LOG(G_ENTITY || l_proc || AS_GAR.G_END);
414: EXCEPTION
415: WHEN FND_API.G_EXC_ERROR THEN
416: Errbuf := l_errbuf;
417: Retcode := l_retcode;
418: WHEN OTHERS THEN
419: AS_GAR.LOG_EXCEPTION(G_ENTITY, SQLERRM, TO_CHAR(SQLCODE));

Line 484: P_init_msg_list => FND_API.G_FALSE,

480: AS_GAR.LOG(G_ENTITY ||l_entity|| 'No of Workers :'|| l_prof_no_of_workers);
481: AS_GAR.LOG(G_ENTITY ||l_entity|| AS_GAR.G_CALL_TO || G_PR_TRANS || AS_GAR.G_START);
482: JTY_ASSIGN_BULK_PUB.collect_trans_data (
483: P_api_version_number => 1.0,
484: P_init_msg_list => FND_API.G_FALSE,
485: P_source_id => -1001,
486: P_trans_id =>p_trans_id,
487: P_program_name => l_program_name,
488: P_mode => 'INCREMENTAL',

Line 501: IF l_return_status <>FND_API.G_RET_STS_SUCCESS THEN

497: Retcode => l_retcode);
498: AS_GAR.LOG(G_ENTITY ||l_entity|| AS_GAR.G_CALL_TO || G_PR_TRANS || AS_GAR.G_END);
499: AS_GAR.LOG(G_ENTITY ||l_entity|| AS_GAR.G_CALL_TO || G_PR_TRANS || AS_GAR.G_RETURN_STATUS || l_return_status);
500: X_return_status := l_return_status;
501: IF l_return_status <>FND_API.G_RET_STS_SUCCESS THEN
502: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_TRANS, l_errbuf, l_retcode);
503: RAISE FND_API.G_EXC_ERROR;
504: END IF;
505:

Line 503: RAISE FND_API.G_EXC_ERROR;

499: AS_GAR.LOG(G_ENTITY ||l_entity|| AS_GAR.G_CALL_TO || G_PR_TRANS || AS_GAR.G_RETURN_STATUS || l_return_status);
500: X_return_status := l_return_status;
501: IF l_return_status <>FND_API.G_RET_STS_SUCCESS THEN
502: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_TRANS, l_errbuf, l_retcode);
503: RAISE FND_API.G_EXC_ERROR;
504: END IF;
505:
506: FOR i in 1..l_prof_no_of_workers
507: LOOP

Line 530: x_return_status := FND_API.G_RET_STS_ERROR;

526: END IF;
527: END LOOP;
528: EXCEPTION
529: WHEN OTHERS THEN
530: x_return_status := FND_API.G_RET_STS_ERROR;
531: AS_GAR.LOG_EXCEPTION(G_ENTITY ||l_entity, SQLERRM, TO_CHAR(SQLCODE));
532: l_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', SQLERRM);
533: END PROCESS_TRANS_DATA;
534:

Line 542: x_return_status := FND_API.G_RET_STS_SUCCESS;

538:
539:
540: BEGIN
541: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PREATA || AS_GAR.G_START);
542: x_return_status := FND_API.G_RET_STS_SUCCESS;
543: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PREATA || 'UPDATE REQUEST ID INTO AS_CHANGED_ACCOUNTS TABLE');
544: UPDATE AS_CHANGED_ACCOUNTS
545: SET REQUEST_ID = FND_GLOBAL.Conc_Request_Id
546: where REQUEST_ID IS NULL;

Line 567: x_return_status := FND_API.G_RET_STS_ERROR;

563:
564: EXCEPTION
565: WHEN OTHERS THEN
566: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || G_PREATA || AS_GAR.G_GENERAL_EXCEPTION, SQLERRM, TO_CHAR(SQLCODE));
567: x_return_status := FND_API.G_RET_STS_ERROR;
568: RAISE;
569: END PRE_ATA;
570:
571: -------------Modified as per Bug#5027026-----------------

Line 818: x_return_status := FND_API.G_RET_STS_ERROR;

814: IF del_all_quotes%ISOPEN THEN CLOSE del_all_quotes; END IF;
815: IF del_all_proposal%ISOPEN THEN CLOSE del_all_proposal; END IF;
816: x_errbuf := SQLERRM;
817: x_retcode := SQLCODE;
818: x_return_status := FND_API.G_RET_STS_ERROR;
819: END;
820:
821: AS_GAR.LOG(G_ENTITY || 'DELETE FROM CHANGED ENTITY::' || p_entity || AS_GAR.G_N_ROWS_PROCESSED || l_first || '-' || l_last);
822:

Line 845: x_return_status := FND_API.G_RET_STS_ERROR;

841: IF del_all_quotes%ISOPEN THEN CLOSE del_all_quotes; END IF;
842: IF del_all_proposal%ISOPEN THEN CLOSE del_all_proposal; END IF;
843: x_errbuf := SQLERRM;
844: x_retcode := SQLCODE;
845: x_return_status := FND_API.G_RET_STS_ERROR;
846: END;
847: END LOOP;--}L1
848: IF del_acct_changed%ISOPEN THEN CLOSE del_acct_changed; END IF;
849: IF del_lead_changed%ISOPEN THEN CLOSE del_lead_changed; END IF;

Line 858: x_return_status := FND_API.G_RET_STS_ERROR;

854: IF del_all_quotes%ISOPEN THEN CLOSE del_all_quotes; END IF;
855: IF del_all_proposal%ISOPEN THEN CLOSE del_all_proposal; END IF;
856: EXCEPTION
857: WHEN OTHERS THEN
858: x_return_status := FND_API.G_RET_STS_ERROR;
859: AS_GAR.LOG_EXCEPTION(G_ENTITY || 'DELETE FROM CHANGED ENTITY::' || p_entity , SQLERRM, TO_CHAR(SQLCODE));
860: l_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', SQLERRM);
861: END DELETE_CHANGED_ENTITY;
862:

Line 870: x_return_status := FND_API.G_RET_STS_SUCCESS;

866:
867:
868: BEGIN
869: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PREATA || AS_GAR.G_START);
870: x_return_status := FND_API.G_RET_STS_SUCCESS;
871: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PREATA || 'UPDATE REQUEST ID INTO AS_CHANGED_ACCOUNTS TABLE');
872: UPDATE AS_CHANGED_ACCOUNTS
873: SET REQUEST_ID = NULL
874: WHERE REQUEST_ID = FND_GLOBAL.Conc_Request_Id;

Line 895: x_return_status := FND_API.G_RET_STS_ERROR;

891:
892: EXCEPTION
893: WHEN OTHERS THEN
894: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || G_PREATA || AS_GAR.G_GENERAL_EXCEPTION, SQLERRM, TO_CHAR(SQLCODE));
895: x_return_status := FND_API.G_RET_STS_ERROR;
896: RAISE;
897: END POST_ATA;
898:
899: END AS_ATA_NEW_PUB;