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

Line 96: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

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

Line 98: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

94: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_ACCOUNT || AS_GAR.G_END ||l_return_status);
95: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_ACCOUNT || AS_GAR.G_RETURN_STATUS || l_return_status);
96: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
97: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_ACCOUNT, l_errbuf, l_retcode);
98: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
99: End If;
100:
101: --fix for bug(5869095) --populating as_terr_resources_tmp table
102:

Line 194: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

190: ,P_trace_mode => p_trace
191: ,x_return_status => l_return_status);
192: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_LEAD || AS_GAR.G_END ||l_return_status);
193: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_LEAD || AS_GAR.G_RETURN_STATUS || l_return_status);
194: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
195: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_LEAD, l_errbuf, l_retcode);
196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
197: End If;
198: END IF;

Line 196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 258: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

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

Line 260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

256: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_OPPTY || AS_GAR.G_END ||l_return_status);
257: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_OPPTY || AS_GAR.G_RETURN_STATUS || l_return_status);
258: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
259: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_OPPTY, l_errbuf, l_retcode);
260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
261: End If;
262: END IF;
263: AS_GAR.LOG(G_ENTITY || G_PR_OPPTY || AS_GAR.G_END);
264: EXCEPTION

Line 328: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

324: ,P_trace_mode => p_trace
325: ,x_return_status => l_return_status);
326: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_QUOTE || AS_GAR.G_END ||l_return_status);
327: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_QUOTE || AS_GAR.G_RETURN_STATUS || l_return_status);
328: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
329: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_QUOTE, l_errbuf, l_retcode);
330: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
331: End If;
332: END IF;

Line 330: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

326: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_QUOTE || AS_GAR.G_END ||l_return_status);
327: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_QUOTE || AS_GAR.G_RETURN_STATUS || l_return_status);
328: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
329: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_QUOTE, l_errbuf, l_retcode);
330: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
331: End If;
332: END IF;
333: AS_GAR.LOG(G_ENTITY || G_PR_QUOTE || AS_GAR.G_END);
334: EXCEPTION

Line 383: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

379: ,P_trace_mode => p_trace
380: ,x_return_status => l_return_status);
381: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_PROPOSAL || AS_GAR.G_END ||l_return_status);
382: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_PROPOSAL || AS_GAR.G_RETURN_STATUS || l_return_status);
383: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
384: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_PROPOSAL, l_errbuf, l_retcode);
385: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
386: End If;
387: END IF;

Line 385: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

381: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_PROPOSAL || AS_GAR.G_END ||l_return_status);
382: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_PROPOSAL || AS_GAR.G_RETURN_STATUS || l_return_status);
383: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
384: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_PROPOSAL, l_errbuf, l_retcode);
385: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
386: End If;
387: END IF;
388: AS_GAR.LOG(G_ENTITY || G_PR_PROPOSAL || AS_GAR.G_END);
389: EXCEPTION

Line 456: P_init_msg_list => FND_API.G_FALSE,

452: AS_GAR.LOG(G_ENTITY ||l_entity|| 'Additioal Where Clause :'|| P_addl_where);
453: AS_GAR.LOG(G_ENTITY ||l_entity|| AS_GAR.G_CALL_TO || G_PR_TRANS || AS_GAR.G_START);
454: JTY_ASSIGN_BULK_PUB.collect_trans_data (
455: P_api_version_number => 1.0,
456: P_init_msg_list => FND_API.G_FALSE,
457: P_source_id => -1001,
458: P_trans_id =>p_trans_id,
459: P_program_name => l_program_name,
460: P_mode => 'TOTAL',

Line 473: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

469: Retcode => l_retcode);
470: AS_GAR.LOG(G_ENTITY ||l_entity || AS_GAR.G_CALL_TO || G_PR_TRANS||l_msg_count||l_msg_data|| AS_GAR.G_END);
471: AS_GAR.LOG(G_ENTITY ||l_entity || AS_GAR.G_CALL_TO || G_PR_TRANS || AS_GAR.G_RETURN_STATUS || l_return_status);
472:
473: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
474: AS_GAR.LOG_EXCEPTION(G_ENTITY ||l_entity || AS_GAR.G_CALL_TO || G_PR_TRANS||l_msg_count||l_msg_data, l_errbuf, l_retcode);
475: RAISE FND_API.G_EXC_ERROR;
476: END IF;
477:

Line 475: RAISE FND_API.G_EXC_ERROR;

471: AS_GAR.LOG(G_ENTITY ||l_entity || AS_GAR.G_CALL_TO || G_PR_TRANS || AS_GAR.G_RETURN_STATUS || l_return_status);
472:
473: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
474: AS_GAR.LOG_EXCEPTION(G_ENTITY ||l_entity || AS_GAR.G_CALL_TO || G_PR_TRANS||l_msg_count||l_msg_data, l_errbuf, l_retcode);
475: RAISE FND_API.G_EXC_ERROR;
476: END IF;
477:
478: FOR i in 1..l_prof_no_of_workers
479: LOOP

Line 498: RAISE FND_API.G_EXC_ERROR;

494: IF l_req_id = 0
495: THEN
496: l_msg_data:=FND_MESSAGE.GET;
497: AS_GAR.LOG(G_ENTITY ||l_entity || G_GAR_SUBMIT || AS_GAR.G_END ||' ERRPR :' || l_msg_data);
498: RAISE FND_API.G_EXC_ERROR;
499: END IF;
500: END LOOP;
501: EXCEPTION
502: WHEN OTHERS THEN

Line 503: x_return_status := FND_API.G_RET_STS_ERROR;

499: END IF;
500: END LOOP;
501: EXCEPTION
502: WHEN OTHERS THEN
503: x_return_status := FND_API.G_RET_STS_ERROR;
504: AS_GAR.LOG_EXCEPTION(G_ENTITY ||l_entity||G_GAR_SUBMIT, SQLERRM, TO_CHAR(SQLCODE));
505: l_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', SQLERRM);
506: END PROCESS_TRANS_DATA;
507:

Line 694: x_return_status := FND_API.G_RET_STS_ERROR;

690: --IF del_quote_changed%ISOPEN THEN CLOSE del_quote_changed; END IF;
691: IF del_proposal_changed%ISOPEN THEN CLOSE del_proposal_changed; END IF;
692: x_errbuf := SQLERRM;
693: x_retcode := SQLCODE;
694: x_return_status := FND_API.G_RET_STS_ERROR;
695: END;
696:
697: AS_GAR.LOG(G_ENTITY || 'DELETE FROM CHANGED ENTITY::' || p_entity || AS_GAR.G_N_ROWS_PROCESSED || l_first || '-' || l_last);
698:

Line 718: x_return_status := FND_API.G_RET_STS_ERROR;

714: IF del_quote_changed%ISOPEN THEN CLOSE del_quote_changed; END IF;
715: IF del_proposal_changed%ISOPEN THEN CLOSE del_proposal_changed; END IF;
716: x_errbuf := SQLERRM;
717: x_retcode := SQLCODE;
718: x_return_status := FND_API.G_RET_STS_ERROR;
719: END;
720: END LOOP;--}L1
721: IF del_acct_changed%ISOPEN THEN CLOSE del_acct_changed; END IF;
722: IF del_lead_changed%ISOPEN THEN CLOSE del_lead_changed; END IF;

Line 728: x_return_status := FND_API.G_RET_STS_ERROR;

724: IF del_quote_changed%ISOPEN THEN CLOSE del_quote_changed; END IF;
725: IF del_proposal_changed%ISOPEN THEN CLOSE del_proposal_changed; END IF;
726: EXCEPTION
727: WHEN OTHERS THEN
728: x_return_status := FND_API.G_RET_STS_ERROR;
729: AS_GAR.LOG_EXCEPTION(G_ENTITY || 'DELETE FROM CHANGED ENTITY::' || p_entity , SQLERRM, TO_CHAR(SQLCODE));
730: l_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', SQLERRM);
731: END;
732: