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_OPPTYS_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 => -1004,
81: P_PROGRAM_NAME => 'SALES/OPPORTUNITY PROGRAM',
82: P_mode => l_target_type,

Line 94: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

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

Line 96: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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: -- Insert into Oppty Accesses from Winners
154: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSACC || AS_GAR.G_START);

Line 164: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

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

Line 166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 180: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

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

Line 182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 196: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

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

Line 198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

194: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CC || AS_GAR.G_RETURN_STATUS || l_return_status);
195:
196: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
197: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CC, l_errbuf, l_retcode);
198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
199: End If;
200:
201: -- Opportunity Owner assignment
202: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CO || AS_GAR.G_START);

Line 219: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then

215: +------------------------------------------------------------------------*/
216: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CO || AS_GAR.G_END);
217: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CO || AS_GAR.G_RETURN_STATUS || l_return_status);
218:
219: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
220: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CO, l_errbuf, l_retcode);
221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
222: End If;
223:

Line 221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

217: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CO || AS_GAR.G_RETURN_STATUS || l_return_status);
218:
219: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
220: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CO, l_errbuf, l_retcode);
221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
222: End If;
223:
224: -- BES enhancement
225:

Line 295: x_return_status := FND_API.G_RET_STS_SUCCESS;

291:
292:
293: BEGIN
294: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_TEAMS || AS_GAR.G_START);
295: x_return_status := FND_API.G_RET_STS_SUCCESS;
296: l_request_id := p_terr_globals.request_id;
297: l_worker_id := p_terr_globals.worker_id;
298: l_resource_type := 'RS_TEAM';
299:

Line 509: x_return_status := FND_API.G_RET_STS_ERROR;

505: WHEN others THEN
506: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_TEAMS, SQLERRM, TO_CHAR(SQLCODE));
507: x_errbuf := SQLERRM;
508: x_retcode := SQLCODE;
509: x_return_status := FND_API.G_RET_STS_ERROR;
510: RAISE;
511: END EXPLODE_TEAMS_OPPTYS;
512: /************************** End Explode Teams Opptys ******************/
513:

Line 560: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

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_OPPTYS;
693: /************************** End Explode Groups Opptys ******************/
694:

Line 761: x_return_status := FND_API.G_RET_STS_SUCCESS;

757:
758:
759: BEGIN
760: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_STLEAD || AS_GAR.G_START);
761: x_return_status := FND_API.G_RET_STS_SUCCESS;
762: l_worker_id:=p_terr_globals.worker_id;
763: l_var :=p_terr_globals.bulk_size;
764: l_max_fetches := p_terr_globals.cursor_limit;
765: LOOP -- For l_limit_flag

Line 860: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 883: x_return_status := FND_API.G_RET_STS_ERROR;

879: WHEN OTHERS THEN
880: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_STLEAD, SQLERRM, TO_CHAR(SQLCODE));
881: x_errbuf := SQLERRM;
882: x_retcode := SQLCODE;
883: x_return_status := FND_API.G_RET_STS_ERROR;
884: RAISE;
885: END SET_TEAM_LEAD_OPPTYS;
886:
887: /************************** End Set Oppty Team Leader *****************/

Line 946: x_return_status := FND_API.G_RET_STS_SUCCESS;

942: | Try bulk inserting into accesses. If this fails, insert records one by one.
943: |
944: +-------------------------------------------------------------------------*/
945: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSACC || AS_GAR.G_START);
946: x_return_status := FND_API.G_RET_STS_SUCCESS;
947: l_worker_id:=p_terr_globals.worker_id;
948: l_var :=p_terr_globals.bulk_size;
949: OPEN ins_acc(l_worker_id);
950: LOOP

Line 1135: x_return_status := FND_API.G_RET_STS_ERROR;

1131: WHEN OTHERS THEN
1132: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSACC || AS_GAR.G_BULK_INS, SQLERRM, TO_CHAR(SQLCODE));
1133: x_errbuf := SQLERRM;
1134: x_retcode := SQLCODE;
1135: x_return_status := FND_API.G_RET_STS_ERROR;
1136: RAISE;
1137: END;
1138: l_first := l_last + 1;
1139: l_last := l_first + l_var;

Line 1159: x_return_status := FND_API.G_RET_STS_ERROR;

1155: WHEN others THEN
1156: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSACC, SQLERRM, TO_CHAR(SQLCODE));
1157: x_errbuf := SQLERRM;
1158: x_retcode := SQLCODE;
1159: x_return_status := FND_API.G_RET_STS_ERROR;
1160: IF ins_acc%ISOPEN THEN CLOSE ins_acc; END IF;
1161: RAISE;
1162: END INSERT_ACCESSES_OPPTYS;
1163:

Line 1217: x_return_status := FND_API.G_RET_STS_SUCCESS;

1213: | and there is no involvement of role.
1214: |
1215: +-------------------------------------------------------------------------*/
1216: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC || AS_GAR.G_START);
1217: x_return_status := FND_API.G_RET_STS_SUCCESS;
1218: l_worker_id := p_terr_globals.worker_id;
1219: l_var := p_terr_globals.bulk_size;
1220: OPEN ins_tacc(l_worker_id);
1221: LOOP

Line 1358: x_return_status := FND_API.G_RET_STS_ERROR;

1354: WHEN Others THEN
1355: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC || AS_GAR.G_BULK_INS, SQLERRM, TO_CHAR(SQLCODE));
1356: x_errbuf := SQLERRM;
1357: x_retcode := SQLCODE;
1358: x_return_status := FND_API.G_RET_STS_ERROR;
1359: IF ins_tacc%ISOPEN THEN CLOSE ins_tacc; END IF;
1360: RAISE;
1361: END;
1362: l_first := l_last + 1;

Line 1375: x_return_status := FND_API.G_RET_STS_ERROR;

1371: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC , SQLERRM, TO_CHAR(SQLCODE));
1372: IF ins_tacc%ISOPEN THEN CLOSE ins_tacc; END IF;
1373: x_errbuf := SQLERRM;
1374: x_retcode := SQLCODE;
1375: x_return_status := FND_API.G_RET_STS_ERROR;
1376: RAISE;
1377: END;
1378: END LOOP; -- end loop for insert into territory accesses
1379: l_lead_id.DELETE;

Line 1390: x_return_status := FND_API.G_RET_STS_ERROR;

1386: WHEN others THEN
1387: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC, SQLERRM, TO_CHAR(SQLCODE));
1388: x_errbuf := SQLERRM;
1389: x_retcode := SQLCODE;
1390: x_return_status := FND_API.G_RET_STS_ERROR;
1391: IF ins_tacc%ISOPEN THEN CLOSE ins_tacc; END IF;
1392: RAISE;
1393: END INSERT_TERR_ACCESSES_OPPTYS;
1394:

Line 1441: x_return_status := FND_API.G_RET_STS_SUCCESS;

1437: WHERE worker_id=c_worker_id;
1438:
1439: BEGIN
1440: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_START);
1441: x_return_status := FND_API.G_RET_STS_SUCCESS;
1442: l_worker_id := p_terr_globals.worker_id;
1443: l_var := p_terr_globals.bulk_size;
1444: l_max_fetches := p_terr_globals.cursor_limit;
1445:

Line 1609: x_return_status := FND_API.G_RET_STS_ERROR;

1605: IF del_oppty_totalmode%ISOPEN THEN CLOSE del_oppty_totalmode; END IF;
1606: IF del_oppty_newmode%ISOPEN THEN CLOSE del_oppty_newmode; END IF;
1607: x_errbuf := SQLERRM;
1608: x_retcode := SQLCODE;
1609: x_return_status := FND_API.G_RET_STS_ERROR;
1610: RAISE;
1611: END;
1612: END LOOP; --}L4 l_attempts loop 3 trys
1613: 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 1631: x_return_status := FND_API.G_RET_STS_ERROR;

1627: IF del_oppty_totalmode%ISOPEN THEN CLOSE del_oppty_totalmode; END IF;
1628: IF del_oppty_newmode%ISOPEN THEN CLOSE del_oppty_newmode; END IF;
1629: x_errbuf := SQLERRM;
1630: x_retcode := SQLCODE;
1631: x_return_status := FND_API.G_RET_STS_ERROR;
1632: RAISE;
1633: END;
1634: END LOOP;--}L1
1635: IF del_oppty_totalmode%ISOPEN THEN CLOSE del_oppty_totalmode; END IF;

Line 1642: x_return_status := FND_API.G_RET_STS_ERROR;

1638: WHEN OTHERS THEN
1639: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_GENERAL_EXCEPTION, SQLERRM, TO_CHAR(SQLCODE));
1640: x_errbuf := SQLERRM;
1641: x_retcode := SQLCODE;
1642: x_return_status := FND_API.G_RET_STS_ERROR;
1643: RAISE;
1644: END PERFORM_OPPTY_CLEANUP;
1645:
1646: /************************** End Oppty Cleanup ***********************/

Line 1737: x_return_status := FND_API.G_RET_STS_SUCCESS;

1733:
1734: BEGIN
1735: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || AS_GAR.G_START);
1736:
1737: x_return_status := FND_API.G_RET_STS_SUCCESS;
1738: l_worker_id:=p_terr_globals.worker_id;
1739: l_var :=p_terr_globals.bulk_size;
1740: l_max_fetches := p_terr_globals.cursor_limit;
1741: l_call_pre_uhk := JTF_USR_HKS.Ok_to_execute('AS_TERR_OPPTY_ASSIGNMENT','Assign_Oppty_Owner','B','C');

Line 1747: p_init_msg_list => FND_API.G_FALSE,

1743: THEN
1744: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'CUSTOM AS PER PROFILE---AS_LEAD_ASSIGNMENT_UHK:- Y---');
1745: AS_CUSTOM_HOOKS_UHK.Oppty_TOTTAP_Owner_Assignment(
1746: p_api_version_number => 2.0,
1747: p_init_msg_list => FND_API.G_FALSE,
1748: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1749: p_commit => FND_API.G_TRUE,
1750: p_request_id => p_terr_globals.request_id,
1751: p_worker_id => p_terr_globals.worker_id,

Line 1748: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1744: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'CUSTOM AS PER PROFILE---AS_LEAD_ASSIGNMENT_UHK:- Y---');
1745: AS_CUSTOM_HOOKS_UHK.Oppty_TOTTAP_Owner_Assignment(
1746: p_api_version_number => 2.0,
1747: p_init_msg_list => FND_API.G_FALSE,
1748: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1749: p_commit => FND_API.G_TRUE,
1750: p_request_id => p_terr_globals.request_id,
1751: p_worker_id => p_terr_globals.worker_id,
1752: x_return_status => l_return_status,

Line 1749: p_commit => FND_API.G_TRUE,

1745: AS_CUSTOM_HOOKS_UHK.Oppty_TOTTAP_Owner_Assignment(
1746: p_api_version_number => 2.0,
1747: p_init_msg_list => FND_API.G_FALSE,
1748: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1749: p_commit => FND_API.G_TRUE,
1750: p_request_id => p_terr_globals.request_id,
1751: p_worker_id => p_terr_globals.worker_id,
1752: x_return_status => l_return_status,
1753: x_msg_count => l_msg_count,

Line 1849: x_return_status := FND_API.G_RET_STS_ERROR;

1845: WHEN OTHERS THEN
1846: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'UPDATE AS_LEADS', SQLERRM, TO_CHAR(SQLCODE));
1847: x_errbuf := SQLERRM;
1848: x_retcode := SQLCODE;
1849: x_return_status := FND_API.G_RET_STS_ERROR;
1850: RAISE;
1851: END;
1852: END LOOP;
1853: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'UPDATE AS_SALES_CREDITS_DENORM');

Line 1915: x_return_status := FND_API.G_RET_STS_ERROR;

1911: WHEN OTHERS THEN
1912: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'UPDATE AS_SALES_CREDITS_DENORM', SQLERRM, TO_CHAR(SQLCODE));
1913: x_errbuf := SQLERRM;
1914: x_retcode := SQLCODE;
1915: x_return_status := FND_API.G_RET_STS_ERROR;
1916: RAISE;
1917: END;
1918: END LOOP;
1919: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'UPDATE AS_ACCESSES');

Line 1968: x_return_status := FND_API.G_RET_STS_ERROR;

1964: WHEN OTHERS THEN
1965: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'UPDATE SALES_LEADS ACCESSES', SQLERRM, TO_CHAR(SQLCODE));
1966: x_errbuf := SQLERRM;
1967: x_retcode := SQLCODE;
1968: x_return_status := FND_API.G_RET_STS_ERROR;
1969: RAISE;
1970: END;
1971: END LOOP;
1972: l_first := l_last + 1;

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_CO || AS_GAR.G_GENERAL_EXCEPTION, SQLERRM, TO_CHAR(SQLCODE));
1991: x_errbuf := SQLERRM;
1992: x_retcode := SQLCODE;
1993: x_return_status := FND_API.G_RET_STS_ERROR;
1994: RAISE;
1995: END ASSIGN_OPPTY_OWNER;
1996:
1997: /**************************** End Assign Lead Owner ********************/