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

Line 77: p_init_msg_list => FND_API.G_TRUE,

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

Line 92: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

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

Line 94: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 110: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

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

Line 112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 128: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

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

Line 130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

126: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CEX_TEAMS || AS_GAR.G_RETURN_STATUS || l_return_status);
127:
128: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
129: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CEX_TEAMS, l_errbuf, l_retcode);
130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
131: End If;
132: COMMIT;
133: -- Set team leader for Accounts
134: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_STLEAD || AS_GAR.G_START);

Line 144: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

140:
141: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_STLEAD || AS_GAR.G_END);
142: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_STLEAD || AS_GAR.G_RETURN_STATUS || l_return_status);
143:
144: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
145: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_STLEAD, l_errbuf, l_retcode);
146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
147: End If;
148:

Line 146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

142: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_STLEAD || AS_GAR.G_RETURN_STATUS || l_return_status);
143:
144: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
145: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_STLEAD, l_errbuf, l_retcode);
146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
147: End If;
148:
149: -- Insert into proposal Accesses from Winners
150: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSACC || AS_GAR.G_START);

Line 160: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

156:
157: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSACC || AS_GAR.G_END);
158: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSACC || AS_GAR.G_RETURN_STATUS || l_return_status);
159:
160: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
161: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSACC, l_errbuf, l_retcode);
162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
163: End If;
164:

Line 162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

158: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSACC || AS_GAR.G_RETURN_STATUS || l_return_status);
159:
160: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
161: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSACC, l_errbuf, l_retcode);
162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
163: End If;
164:
165: -- Insert into territory Accesses
166: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSTERRACC || AS_GAR.G_START);

Line 176: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

172:
173: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSTERRACC || AS_GAR.G_END);
174: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSTERRACC || AS_GAR.G_RETURN_STATUS || l_return_status);
175:
176: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
177: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSTERRACC, l_errbuf, l_retcode);
178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
179: End If;
180:

Line 178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

174: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSTERRACC || AS_GAR.G_RETURN_STATUS || l_return_status);
175:
176: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
177: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSTERRACC, l_errbuf, l_retcode);
178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
179: End If;
180:
181:
182: -- Remove (soft delete) records in access table that are not qualified

Line 193: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

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

Line 195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 268: x_return_status := FND_API.G_RET_STS_SUCCESS;

264: AND rsc.terr_rsc_id = acc.terr_rsc_id;
265:
266: BEGIN
267: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_TEAMS || AS_GAR.G_START);
268: x_return_status := FND_API.G_RET_STS_SUCCESS;
269: l_request_id := p_terr_globals.request_id;
270: l_worker_id := p_terr_globals.worker_id;
271: l_resource_type := 'RS_TEAM';
272:

Line 484: x_return_status := FND_API.G_RET_STS_ERROR;

480: WHEN others THEN
481: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_TEAMS, SQLERRM, TO_CHAR(SQLCODE));
482: x_errbuf := SQLERRM;
483: x_retcode := SQLCODE;
484: x_return_status := FND_API.G_RET_STS_ERROR;
485: RAISE;
486: END EXPLODE_TEAMS_PROPOSALS;
487: /************************** End Explode Teams PROPOSALS ******************/
488:

Line 665: x_return_status := FND_API.G_RET_STS_ERROR;

661: WHEN others THEN
662: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_GROUPS, SQLERRM, TO_CHAR(SQLCODE));
663: x_errbuf := SQLERRM;
664: x_retcode := SQLCODE;
665: x_return_status := FND_API.G_RET_STS_ERROR;
666: RAISE;
667: END EXPLODE_GROUPS_PROPOSALS;
668: /************************** End Explode Groups PROPOSALS ******************/
669:

Line 734: x_return_status := FND_API.G_RET_STS_SUCCESS;

730:
731:
732: BEGIN
733: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_STLEAD || AS_GAR.G_START);
734: x_return_status := FND_API.G_RET_STS_SUCCESS;
735: l_worker_id:=p_terr_globals.worker_id;
736: l_var :=p_terr_globals.bulk_size;
737: l_MAX_fetches := p_terr_globals.cursor_limit;
738: LOOP -- For l_limit_flag

Line 821: x_return_status := FND_API.G_RET_STS_ERROR;

817: WHEN OTHERS THEN
818: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_STLEAD || AS_GAR.G_BULK_UPD, SQLERRM, TO_CHAR(SQLCODE));
819: x_errbuf := SQLERRM;
820: x_retcode := SQLCODE;
821: x_return_status := FND_API.G_RET_STS_ERROR;
822: END;
823: END LOOP; -- loop for 3 attempts
824: /* For the next batch of records by bulk_size */
825: l_first := l_last + 1;

Line 844: x_return_status := FND_API.G_RET_STS_ERROR;

840: WHEN OTHERS THEN
841: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_STLEAD, SQLERRM, TO_CHAR(SQLCODE));
842: x_errbuf := SQLERRM;
843: x_retcode := SQLCODE;
844: x_return_status := FND_API.G_RET_STS_ERROR;
845: END SET_TEAM_LEAD_PROPOSALS;
846:
847: /************************** End Set PROPOSALS Team Leader *****************/
848:

Line 906: x_return_status := FND_API.G_RET_STS_SUCCESS;

902: | Try bulk inserting into accesses. If this fails, insert records one by one.
903: |
904: +-------------------------------------------------------------------------*/
905: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSACC || AS_GAR.G_START);
906: x_return_status := FND_API.G_RET_STS_SUCCESS;
907: l_worker_id:=p_terr_globals.worker_id;
908: l_var :=p_terr_globals.bulk_size;
909:
910: OPEN ins_acc2(l_worker_id); -- Open the null salesforce role code cursor

Line 1034: x_return_status := FND_API.G_RET_STS_ERROR;

1030: WHEN OTHERS THEN
1031: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSACC || AS_GAR.G_BULK_INS, SQLERRM, TO_CHAR(SQLCODE));
1032: x_errbuf := SQLERRM;
1033: x_retcode := SQLCODE;
1034: x_return_status := FND_API.G_RET_STS_ERROR;
1035: RAISE;
1036: END;
1037: l_first := l_last + 1;
1038: l_last := l_first + l_var;

Line 1055: x_return_status := FND_API.G_RET_STS_ERROR;

1051: WHEN others THEN
1052: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSACC, SQLERRM, TO_CHAR(SQLCODE));
1053: x_errbuf := SQLERRM;
1054: x_retcode := SQLCODE;
1055: x_return_status := FND_API.G_RET_STS_ERROR;
1056: IF ins_acc2%ISOPEN THEN CLOSE ins_acc2; END IF;
1057: RAISE;
1058: END INSERT_ACCESSES_PROPOSALS;
1059:

Line 1112: x_return_status := FND_API.G_RET_STS_SUCCESS;

1108: | and there is no involvement of role.
1109: |
1110: +-------------------------------------------------------------------------*/
1111: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC || AS_GAR.G_START);
1112: x_return_status := FND_API.G_RET_STS_SUCCESS;
1113: l_worker_id := p_terr_globals.worker_id;
1114: l_var := p_terr_globals.bulk_size;
1115: OPEN ins_tacc(l_worker_id);
1116: LOOP

Line 1253: x_return_status := FND_API.G_RET_STS_ERROR;

1249: WHEN Others THEN
1250: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC || AS_GAR.G_BULK_INS, SQLERRM, TO_CHAR(SQLCODE));
1251: x_errbuf := SQLERRM;
1252: x_retcode := SQLCODE;
1253: x_return_status := FND_API.G_RET_STS_ERROR;
1254: IF ins_tacc%ISOPEN THEN CLOSE ins_tacc; END IF;
1255: RAISE;
1256: END;
1257: l_first := l_last + 1;

Line 1270: x_return_status := FND_API.G_RET_STS_ERROR;

1266: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC , SQLERRM, TO_CHAR(SQLCODE));
1267: IF ins_tacc%ISOPEN THEN CLOSE ins_tacc; END IF;
1268: x_errbuf := SQLERRM;
1269: x_retcode := SQLCODE;
1270: x_return_status := FND_API.G_RET_STS_ERROR;
1271: RAISE;
1272: END;
1273: END LOOP; -- end loop for insert into territory accesses
1274: l_proposal_id.DELETE;

Line 1285: x_return_status := FND_API.G_RET_STS_ERROR;

1281: WHEN others THEN
1282: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC, SQLERRM, TO_CHAR(SQLCODE));
1283: x_errbuf := SQLERRM;
1284: x_retcode := SQLCODE;
1285: x_return_status := FND_API.G_RET_STS_ERROR;
1286: IF ins_tacc%ISOPEN THEN CLOSE ins_tacc; END IF;
1287: RAISE;
1288: END INSERT_TERR_ACCESSES_PROPOSALS;
1289:

Line 1334: x_return_status := FND_API.G_RET_STS_SUCCESS;

1330: WHERE worker_id=c_worker_id;
1331:
1332: BEGIN
1333: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_START);
1334: x_return_status := FND_API.G_RET_STS_SUCCESS;
1335: l_worker_id := p_terr_globals.worker_id;
1336: l_var := p_terr_globals.bulk_size;
1337: l_MAX_fetches := p_terr_globals.cursor_limit;
1338:

Line 1434: x_return_status := FND_API.G_RET_STS_ERROR;

1430: IF del_acct_totalmode%ISOPEN THEN CLOSE del_acct_totalmode; END IF;
1431: IF del_acct_newmode%ISOPEN THEN CLOSE del_acct_newmode; END IF;
1432: x_errbuf := SQLERRM;
1433: x_retcode := SQLCODE;
1434: x_return_status := FND_API.G_RET_STS_ERROR;
1435: RAISE;
1436: END;
1437: END LOOP; --}L4 l_attempts loop 3 trys
1438: 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 1455: x_return_status := FND_API.G_RET_STS_ERROR;

1451: IF del_acct_totalmode%ISOPEN THEN CLOSE del_acct_totalmode; END IF;
1452: IF del_acct_newmode%ISOPEN THEN CLOSE del_acct_newmode; END IF;
1453: x_errbuf := SQLERRM;
1454: x_retcode := SQLCODE;
1455: x_return_status := FND_API.G_RET_STS_ERROR;
1456: RAISE;
1457: END;
1458: END LOOP;--}L1
1459: IF del_acct_totalmode%ISOPEN THEN CLOSE del_acct_totalmode; END IF;

Line 1466: x_return_status := FND_API.G_RET_STS_ERROR;

1462: WHEN OTHERS THEN
1463: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_GENERAL_EXCEPTION, SQLERRM, TO_CHAR(SQLCODE));
1464: x_errbuf := SQLERRM;
1465: x_retcode := SQLCODE;
1466: x_return_status := FND_API.G_RET_STS_ERROR;
1467: RAISE;
1468: END Perform_Proposal_Cleanup;
1469:
1470: /************************** End proposal Cleanup ***********************/