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

Line 78: p_init_msg_list => FND_API.G_TRUE,

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

Line 93: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

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

Line 95: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 112: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

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

Line 114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 130: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

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

Line 132: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 148: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

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

Line 150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

146: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_STLEAD || AS_GAR.G_RETURN_STATUS || l_return_status);
147:
148: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
149: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_STLEAD, l_errbuf, l_retcode);
150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
151: End If;
152:
153: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || 'UPDATE FAF::' || AS_GAR.G_START);
154: AS_GAR_QOT_PUB.SET_FAF_QOT(

Line 163: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

159:
160: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || 'UPDATE FAF::' || AS_GAR.G_END);
161: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || 'UPDATE FAF::' || AS_GAR.G_RETURN_STATUS || l_return_status);
162:
163: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
164: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || 'UPDATE FAF::', l_errbuf, l_retcode);
165: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
166: End If;
167:

Line 165: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

161: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || 'UPDATE FAF::' || AS_GAR.G_RETURN_STATUS || l_return_status);
162:
163: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
164: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || 'UPDATE FAF::', l_errbuf, l_retcode);
165: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
166: End If;
167:
168: -- Insert into Qot Accesses from Winners
169: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSACC || AS_GAR.G_START);

Line 179: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

175:
176: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSACC || AS_GAR.G_END);
177: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSACC || AS_GAR.G_RETURN_STATUS || l_return_status);
178:
179: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
180: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSACC, l_errbuf, l_retcode);
181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
182: End If;
183: -- Insert into territory Accesses

Line 181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

177: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSACC || AS_GAR.G_RETURN_STATUS || l_return_status);
178:
179: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
180: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSACC, l_errbuf, l_retcode);
181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
182: End If;
183: -- Insert into territory Accesses
184: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSTERRACC || AS_GAR.G_START);
185: AS_GAR_QOT_PUB.INSERT_TERR_ACCESSES_QOT(

Line 194: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

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

Line 196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

192: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSTERRACC || AS_GAR.G_RETURN_STATUS || l_return_status);
193:
194: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
195: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSTERRACC, l_errbuf, l_retcode);
196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
197: End If;
198:
199: -- Remove records in access table that are not qualified
200: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CC || AS_GAR.G_START);

Line 210: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

206:
207: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CC || AS_GAR.G_END);
208: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CC || AS_GAR.G_RETURN_STATUS || l_return_status);
209:
210: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
211: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CC, l_errbuf, l_retcode);
212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
213: End If;
214: -- Quote Owner assignment

Line 212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

208: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CC || AS_GAR.G_RETURN_STATUS || l_return_status);
209:
210: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
211: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CC, l_errbuf, l_retcode);
212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
213: End If;
214: -- Quote Owner assignment
215: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CO || AS_GAR.G_START);
216: AS_GAR_QOT_PUB.ASSIGN_QOT_OWNER(

Line 224: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

220: x_return_status => l_return_status);
221: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CO || AS_GAR.G_END);
222: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CO || 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_CO, 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_CO || 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_CO, l_errbuf, l_retcode);
226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
227: End If;
228:
229: AS_GAR.LOG(G_ENTITY || l_proc || AS_GAR.G_END);
230: EXCEPTION

Line 290: x_return_status := FND_API.G_RET_STS_SUCCESS;

286: AND rsc.terr_rsc_id = acc.terr_rsc_id;
287:
288: BEGIN
289: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_TEAMS || AS_GAR.G_START);
290: x_return_status := FND_API.G_RET_STS_SUCCESS;
291: l_request_id := p_terr_globals.request_id;
292: l_worker_id := p_terr_globals.worker_id;
293: l_resource_type := 'RS_TEAM';
294:

Line 506: x_return_status := FND_API.G_RET_STS_ERROR;

502: WHEN OTHERS THEN
503: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_TEAMS, SQLERRM, TO_CHAR(SQLCODE));
504: x_errbuf := SQLERRM;
505: x_retcode := SQLCODE;
506: x_return_status := FND_API.G_RET_STS_ERROR;
507: RAISE;
508: END EXPLODE_TEAMS_QOT;
509: /************************** End Explode Teams Quotes ******************/
510:

Line 558: x_return_status := FND_API.G_RET_STS_SUCCESS;

554: AND rsc.terr_rsc_id = acc.terr_rsc_id ;
555:
556: BEGIN
557: l_resource_type := 'RS_GROUP';
558: x_return_status := FND_API.G_RET_STS_SUCCESS;
559: l_request_id := p_terr_globals.request_id;
560: l_worker_id := p_terr_globals.worker_id;
561:
562: OPEN count_res_quotes;

Line 690: x_return_status := FND_API.G_RET_STS_ERROR;

686: WHEN OTHERS THEN
687: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_GROUPS, SQLERRM, TO_CHAR(SQLCODE));
688: x_errbuf := SQLERRM;
689: x_retcode := SQLCODE;
690: x_return_status := FND_API.G_RET_STS_ERROR;
691: RAISE;
692: END EXPLODE_GROUPS_QOT;
693: /************************** End Explode Groups Quotes ******************/
694:

Line 763: x_return_status := FND_API.G_RET_STS_SUCCESS;

759: ORDER BY quote_number;
760:
761: BEGIN
762: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_STLEAD || AS_GAR.G_START);
763: x_return_status := FND_API.G_RET_STS_SUCCESS;
764: l_worker_id:=p_terr_globals.worker_id;
765: l_var :=p_terr_globals.bulk_size;
766: l_MAX_fetches := p_terr_globals.cursor_limit;
767: LOOP -- For l_limit_flag

Line 856: x_return_status := FND_API.G_RET_STS_ERROR;

852: WHEN OTHERS THEN
853: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_STLEAD || AS_GAR.G_BULK_UPD, SQLERRM, TO_CHAR(SQLCODE));
854: x_errbuf := SQLERRM;
855: x_retcode := SQLCODE;
856: x_return_status := FND_API.G_RET_STS_ERROR;
857: RAISE;
858: END;
859: END LOOP; -- loop for 3 attempts
860: /* For the next batch of records by bulk_size */

Line 878: x_return_status := FND_API.G_RET_STS_ERROR;

874: WHEN OTHERS THEN
875: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_STLEAD, SQLERRM, TO_CHAR(SQLCODE));
876: x_errbuf := SQLERRM;
877: x_retcode := SQLCODE;
878: x_return_status := FND_API.G_RET_STS_ERROR;
879: RAISE;
880: END SET_TEAM_LEAD_QOT;
881:
882: /************************** End Set Quote Team Leader *****************/

Line 926: x_return_status := FND_API.G_RET_STS_SUCCESS;

922: ORDER BY access_id;
923:
924: BEGIN
925: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || 'UPDATE FAF::' || AS_GAR.G_START);
926: x_return_status := FND_API.G_RET_STS_SUCCESS;
927: l_worker_id:=p_terr_globals.worker_id;
928: l_var :=p_terr_globals.bulk_size;
929: l_MAX_fetches := p_terr_globals.cursor_limit;
930: LOOP -- For l_limit_flag

Line 1000: x_return_status := FND_API.G_RET_STS_ERROR;

996: WHEN OTHERS THEN
997: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || 'UPDATE FAF::' || AS_GAR.G_BULK_UPD, SQLERRM, TO_CHAR(SQLCODE));
998: x_errbuf := SQLERRM;
999: x_retcode := SQLCODE;
1000: x_return_status := FND_API.G_RET_STS_ERROR;
1001: RAISE;
1002: END;
1003: END LOOP; -- loop for 3 attempts
1004: /* For the next batch of records by bulk_size */

Line 1023: x_return_status := FND_API.G_RET_STS_ERROR;

1019: WHEN OTHERS THEN
1020: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || 'UPDATE FAF::', SQLERRM, TO_CHAR(SQLCODE));
1021: x_errbuf := SQLERRM;
1022: x_retcode := SQLCODE;
1023: x_return_status := FND_API.G_RET_STS_ERROR;
1024: RAISE;
1025: END SET_FAF_QOT;
1026: /************************** End Set Full Access Flag*****************/
1027: /************************** Start Insert Into Entity Accesses*************/

Line 1090: x_return_status := FND_API.G_RET_STS_SUCCESS;

1086: | Try bulk inserting into accesses. If this fails, insert records one by one.
1087: |
1088: +-------------------------------------------------------------------------*/
1089: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSACC || AS_GAR.G_START);
1090: x_return_status := FND_API.G_RET_STS_SUCCESS;
1091: l_worker_id:=p_terr_globals.worker_id;
1092: l_var :=p_terr_globals.bulk_size;
1093: OPEN ins_acc(l_worker_id);
1094: LOOP

Line 1233: x_return_status := FND_API.G_RET_STS_ERROR;

1229: WHEN OTHERS THEN
1230: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSACC || AS_GAR.G_BULK_INS, SQLERRM, TO_CHAR(SQLCODE));
1231: x_errbuf := SQLERRM;
1232: x_retcode := SQLCODE;
1233: x_return_status := FND_API.G_RET_STS_ERROR;
1234: RAISE;
1235: END;
1236: l_first := l_last + 1;
1237: l_last := l_first + l_var;

Line 1257: x_return_status := FND_API.G_RET_STS_ERROR;

1253: WHEN others THEN
1254: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSACC, SQLERRM, TO_CHAR(SQLCODE));
1255: x_errbuf := SQLERRM;
1256: x_retcode := SQLCODE;
1257: x_return_status := FND_API.G_RET_STS_ERROR;
1258: IF ins_acc%ISOPEN THEN CLOSE ins_acc; END IF;
1259: RAISE;
1260: END INSERT_ACCESSES_QOT;
1261:

Line 1307: x_return_status := FND_API.G_RET_STS_SUCCESS;

1303: | and there is no involvement of role.
1304: |
1305: +-------------------------------------------------------------------------*/
1306: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC || AS_GAR.G_START);
1307: x_return_status := FND_API.G_RET_STS_SUCCESS;
1308: l_worker_id := p_terr_globals.worker_id;
1309: l_var := p_terr_globals.bulk_size;
1310: OPEN ins_tacc(l_worker_id);
1311: LOOP

Line 1440: x_return_status := FND_API.G_RET_STS_ERROR;

1436: WHEN Others THEN
1437: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC || AS_GAR.G_BULK_INS, SQLERRM, TO_CHAR(SQLCODE));
1438: x_errbuf := SQLERRM;
1439: x_retcode := SQLCODE;
1440: x_return_status := FND_API.G_RET_STS_ERROR;
1441: IF ins_tacc%ISOPEN THEN CLOSE ins_tacc; END IF;
1442: RAISE;
1443: END;
1444: l_first := l_last + 1;

Line 1457: x_return_status := FND_API.G_RET_STS_ERROR;

1453: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC , SQLERRM, TO_CHAR(SQLCODE));
1454: IF ins_tacc%ISOPEN THEN CLOSE ins_tacc; END IF;
1455: x_errbuf := SQLERRM;
1456: x_retcode := SQLCODE;
1457: x_return_status := FND_API.G_RET_STS_ERROR;
1458: RAISE;
1459: END;
1460: END LOOP; -- end loop for insert into territory accesses
1461: l_quote_number_id.DELETE;

Line 1471: x_return_status := FND_API.G_RET_STS_ERROR;

1467: WHEN others THEN
1468: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC, SQLERRM, TO_CHAR(SQLCODE));
1469: x_errbuf := SQLERRM;
1470: x_retcode := SQLCODE;
1471: x_return_status := FND_API.G_RET_STS_ERROR;
1472: IF ins_tacc%ISOPEN THEN CLOSE ins_tacc; END IF;
1473: RAISE;
1474: END INSERT_TERR_ACCESSES_QOT;
1475:

Line 1627: x_return_status := FND_API.G_RET_STS_SUCCESS;

1623:
1624: BEGIN
1625: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || AS_GAR.G_START);
1626:
1627: x_return_status := FND_API.G_RET_STS_SUCCESS;
1628: l_worker_id:=p_terr_globals.worker_id;
1629: l_var :=p_terr_globals.bulk_size;
1630: l_MAX_fetches := p_terr_globals.cursor_limit;
1631: /*-------------------------------------------------------------------+

Line 1715: x_return_status := FND_API.G_RET_STS_ERROR;

1711: WHEN OTHERS THEN
1712: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'UPDATE ASO_QUOTE_HEADERS', SQLERRM, TO_CHAR(SQLCODE));
1713: x_errbuf := SQLERRM;
1714: x_retcode := SQLCODE;
1715: x_return_status := FND_API.G_RET_STS_ERROR;
1716: RAISE;
1717: END;
1718: END LOOP;
1719: l_first := l_last + 1;

Line 2039: x_return_status := FND_API.G_RET_STS_ERROR;

2035: WHEN OTHERS THEN
2036: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'UPDATE ASO_QUOTE_HEADERS', SQLERRM, TO_CHAR(SQLCODE));
2037: x_errbuf := SQLERRM;
2038: x_retcode := SQLCODE;
2039: x_return_status := FND_API.G_RET_STS_ERROR;
2040: RAISE;
2041: END;
2042: END LOOP; -- L_attempt
2043: l_first := l_last + 1;

Line 2065: x_return_status := FND_API.G_RET_STS_ERROR;

2061: WHEN OTHERS THEN
2062: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || AS_GAR.G_GENERAL_EXCEPTION, SQLERRM, TO_CHAR(SQLCODE));
2063: x_errbuf := SQLERRM;
2064: x_retcode := SQLCODE;
2065: x_return_status := FND_API.G_RET_STS_ERROR;
2066: RAISE;
2067: END ASSIGN_QOT_OWNER;
2068:
2069: /**************************** End Assign Qot Owner ********************/

Line 2110: x_return_status := FND_API.G_RET_STS_SUCCESS;

2106: WHERE worker_id=c_worker_id;
2107:
2108: BEGIN
2109: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_START);
2110: x_return_status := FND_API.G_RET_STS_SUCCESS;
2111: l_worker_id := p_terr_globals.worker_id;
2112: l_var := p_terr_globals.bulk_size;
2113: l_MAX_fetches := p_terr_globals.cursor_limit;
2114: OPEN del_quote_totalmode(l_worker_id);

Line 2201: x_return_status := FND_API.G_RET_STS_ERROR;

2197: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_GENERAL_EXCEPTION, SQLERRM, TO_CHAR(SQLCODE));
2198: IF del_quote_totalmode%ISOPEN THEN CLOSE del_quote_totalmode; END IF;
2199: x_errbuf := SQLERRM;
2200: x_retcode := SQLCODE;
2201: x_return_status := FND_API.G_RET_STS_ERROR;
2202: RAISE;
2203: END;
2204: END LOOP; --}L4 l_attempts loop 3 trys
2205: 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 2222: x_return_status := FND_API.G_RET_STS_ERROR;

2218: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_GENERAL_EXCEPTION, SQLERRM, TO_CHAR(SQLCODE));
2219: IF del_quote_totalmode%ISOPEN THEN CLOSE del_quote_totalmode; END IF;
2220: x_errbuf := SQLERRM;
2221: x_retcode := SQLCODE;
2222: x_return_status := FND_API.G_RET_STS_ERROR;
2223: RAISE;
2224: END;
2225: END LOOP;--}L1
2226: IF del_quote_totalmode%ISOPEN THEN CLOSE del_quote_totalmode; END IF;

Line 2232: x_return_status := FND_API.G_RET_STS_ERROR;

2228: WHEN OTHERS THEN
2229: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_GENERAL_EXCEPTION, SQLERRM, TO_CHAR(SQLCODE));
2230: x_errbuf := SQLERRM;
2231: x_retcode := SQLCODE;
2232: x_return_status := FND_API.G_RET_STS_ERROR;
2233: RAISE;
2234: END PERFORM_QOT_CLEANUP;
2235:
2236: /************************** End Quote Cleanup ***********************/