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 AS_GAR

Line 93: AS_GAR.g_debug_flag := p_debug;

89: FROM jty_changed_terrs
90: WHERE source_id = -1001
91: AND tap_request_id IS NULL ;
92: BEGIN
93: AS_GAR.g_debug_flag := p_debug;
94: IF P_trace = 'Y' THEN AS_GAR.SETTRACE; END IF;
95: AS_GAR.LOG(G_ENTITY || l_proc || AS_GAR.G_START);
96: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_SETAREASIZE || AS_GAR.G_START);
97: AS_GAR.Set_Area_Sizes;

Line 94: IF P_trace = 'Y' THEN AS_GAR.SETTRACE; END IF;

90: WHERE source_id = -1001
91: AND tap_request_id IS NULL ;
92: BEGIN
93: AS_GAR.g_debug_flag := p_debug;
94: IF P_trace = 'Y' THEN AS_GAR.SETTRACE; END IF;
95: AS_GAR.LOG(G_ENTITY || l_proc || AS_GAR.G_START);
96: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_SETAREASIZE || AS_GAR.G_START);
97: AS_GAR.Set_Area_Sizes;
98: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_SETAREASIZE || AS_GAR.G_END);

Line 95: AS_GAR.LOG(G_ENTITY || l_proc || AS_GAR.G_START);

91: AND tap_request_id IS NULL ;
92: BEGIN
93: AS_GAR.g_debug_flag := p_debug;
94: IF P_trace = 'Y' THEN AS_GAR.SETTRACE; END IF;
95: AS_GAR.LOG(G_ENTITY || l_proc || AS_GAR.G_START);
96: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_SETAREASIZE || AS_GAR.G_START);
97: AS_GAR.Set_Area_Sizes;
98: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_SETAREASIZE || AS_GAR.G_END);
99: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PREATA || AS_GAR.G_START);

Line 96: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_SETAREASIZE || AS_GAR.G_START);

92: BEGIN
93: AS_GAR.g_debug_flag := p_debug;
94: IF P_trace = 'Y' THEN AS_GAR.SETTRACE; END IF;
95: AS_GAR.LOG(G_ENTITY || l_proc || AS_GAR.G_START);
96: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_SETAREASIZE || AS_GAR.G_START);
97: AS_GAR.Set_Area_Sizes;
98: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_SETAREASIZE || AS_GAR.G_END);
99: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PREATA || AS_GAR.G_START);
100: AS_ATA_NEW_PUB.Pre_ATA(

Line 97: AS_GAR.Set_Area_Sizes;

93: AS_GAR.g_debug_flag := p_debug;
94: IF P_trace = 'Y' THEN AS_GAR.SETTRACE; END IF;
95: AS_GAR.LOG(G_ENTITY || l_proc || AS_GAR.G_START);
96: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_SETAREASIZE || AS_GAR.G_START);
97: AS_GAR.Set_Area_Sizes;
98: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_SETAREASIZE || AS_GAR.G_END);
99: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PREATA || AS_GAR.G_START);
100: AS_ATA_NEW_PUB.Pre_ATA(
101: x_return_status => l_return_status);

Line 98: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_SETAREASIZE || AS_GAR.G_END);

94: IF P_trace = 'Y' THEN AS_GAR.SETTRACE; END IF;
95: AS_GAR.LOG(G_ENTITY || l_proc || AS_GAR.G_START);
96: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_SETAREASIZE || AS_GAR.G_START);
97: AS_GAR.Set_Area_Sizes;
98: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_SETAREASIZE || AS_GAR.G_END);
99: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PREATA || AS_GAR.G_START);
100: AS_ATA_NEW_PUB.Pre_ATA(
101: x_return_status => l_return_status);
102: OPEN terr_changed;

Line 99: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PREATA || AS_GAR.G_START);

95: AS_GAR.LOG(G_ENTITY || l_proc || AS_GAR.G_START);
96: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_SETAREASIZE || AS_GAR.G_START);
97: AS_GAR.Set_Area_Sizes;
98: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_SETAREASIZE || AS_GAR.G_END);
99: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PREATA || AS_GAR.G_START);
100: AS_ATA_NEW_PUB.Pre_ATA(
101: x_return_status => l_return_status);
102: OPEN terr_changed;
103: FETCH terr_changed INTO l_terr_changed;

Line 105: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PREATA || AS_GAR.G_END);

101: x_return_status => l_return_status);
102: OPEN terr_changed;
103: FETCH terr_changed INTO l_terr_changed;
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;

Line 106: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PREATA || AS_GAR.G_RETURN_STATUS || l_return_status);

102: OPEN terr_changed;
103: FETCH terr_changed INTO l_terr_changed;
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;

Line 126: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_ACCOUNT || G_WHERE || l_addl_where);

122: l_addl_where := l_Addl_Where || ' and ' ||P_acc_addl_where;
123: END IF;
124: END IF;
125: END IF;
126: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_ACCOUNT || G_WHERE || l_addl_where);
127: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_ACCOUNT || AS_GAR.G_START);
128: Process_trans_data(
129: p_trans_id => -1002
130: ,P_addl_where => l_addl_where

Line 127: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_ACCOUNT || AS_GAR.G_START);

123: END IF;
124: END IF;
125: END IF;
126: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_ACCOUNT || G_WHERE || l_addl_where);
127: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_ACCOUNT || AS_GAR.G_START);
128: Process_trans_data(
129: p_trans_id => -1002
130: ,P_addl_where => l_addl_where
131: ,P_percent_analyzed =>P_perc_analyzed

Line 134: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_ACCOUNT || AS_GAR.G_END);

130: ,P_addl_where => l_addl_where
131: ,P_percent_analyzed =>P_perc_analyzed
132: ,P_trace_mode =>p_trace
133: ,x_return_status => l_return_status);
134: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_ACCOUNT || AS_GAR.G_END);
135: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_ACCOUNT || AS_GAR.G_RETURN_STATUS || l_return_status);
136:
137: --fix for bug(5869095) --populating as_terr_resources_tmp table
138:

Line 135: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_ACCOUNT || AS_GAR.G_RETURN_STATUS || l_return_status);

131: ,P_percent_analyzed =>P_perc_analyzed
132: ,P_trace_mode =>p_trace
133: ,x_return_status => l_return_status);
134: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_ACCOUNT || AS_GAR.G_END);
135: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_ACCOUNT || AS_GAR.G_RETURN_STATUS || l_return_status);
136:
137: --fix for bug(5869095) --populating as_terr_resources_tmp table
138:
139: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_oracle_schema || '.AS_TERR_RESOURCES_TMP REUSE STORAGE';

Line 172: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_ACCOUNT, l_errbuf, l_retcode);

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:
176: -- Setting Lead where clause

Line 192: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_LEAD || G_WHERE || l_addl_where);

188: l_addl_where := l_Addl_Where || ' and ' ||P_lead_addl_where;
189: END IF;
190: END IF;
191: END IF;
192: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_LEAD || G_WHERE || l_addl_where);
193:
194: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_LEAD || AS_GAR.G_START);
195: Process_trans_data(
196: p_trans_id => -1003

Line 194: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_LEAD || AS_GAR.G_START);

190: END IF;
191: END IF;
192: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_LEAD || G_WHERE || l_addl_where);
193:
194: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_LEAD || AS_GAR.G_START);
195: Process_trans_data(
196: p_trans_id => -1003
197: ,P_addl_where => l_addl_where
198: ,P_percent_analyzed =>P_perc_analyzed

Line 201: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_LEAD || AS_GAR.G_END);

197: ,P_addl_where => l_addl_where
198: ,P_percent_analyzed =>P_perc_analyzed
199: ,P_trace_mode =>p_trace
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);

Line 202: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_LEAD || AS_GAR.G_RETURN_STATUS || l_return_status);

198: ,P_percent_analyzed =>P_perc_analyzed
199: ,P_trace_mode =>p_trace
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;

Line 205: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_LEAD, l_errbuf, l_retcode);

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:
209: -- Setting Opportunity where clause

Line 225: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_OPPTY || G_WHERE || l_addl_where);

221: l_addl_where := l_Addl_Where || ' and ' ||P_opp_addl_where;
222: END IF;
223: END IF;
224: END IF;
225: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_OPPTY || G_WHERE || l_addl_where);
226: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_OPPTY || AS_GAR.G_START);
227: Process_trans_data(
228: p_trans_id => -1004
229: ,P_addl_where => l_addl_where

Line 226: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_OPPTY || AS_GAR.G_START);

222: END IF;
223: END IF;
224: END IF;
225: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_OPPTY || G_WHERE || l_addl_where);
226: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_OPPTY || AS_GAR.G_START);
227: Process_trans_data(
228: p_trans_id => -1004
229: ,P_addl_where => l_addl_where
230: ,P_percent_analyzed =>P_perc_analyzed

Line 233: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_OPPTY || AS_GAR.G_END);

229: ,P_addl_where => l_addl_where
230: ,P_percent_analyzed =>P_perc_analyzed
231: ,P_trace_mode =>p_trace
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);

Line 234: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_OPPTY || AS_GAR.G_RETURN_STATUS || l_return_status);

230: ,P_percent_analyzed =>P_perc_analyzed
231: ,P_trace_mode =>p_trace
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;

Line 237: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_OPPTY, l_errbuf, l_retcode);

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:
241: -- Setting Quotes where clause

Line 262: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_QUOTE || G_WHERE || l_addl_where);

258: l_addl_where := l_Addl_Where || ' and ' ||P_qt_addl_where;
259: END IF;
260: END IF;
261: END IF;
262: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_QUOTE || G_WHERE || l_addl_where);
263: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_QUOTE || AS_GAR.G_START);
264: Process_trans_data(
265: p_trans_id => -1105
266: ,P_addl_where => l_addl_where

Line 263: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_QUOTE || AS_GAR.G_START);

259: END IF;
260: END IF;
261: END IF;
262: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_QUOTE || G_WHERE || l_addl_where);
263: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_QUOTE || AS_GAR.G_START);
264: Process_trans_data(
265: p_trans_id => -1105
266: ,P_addl_where => l_addl_where
267: ,P_percent_analyzed =>P_perc_analyzed

Line 270: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_QUOTE || AS_GAR.G_END);

266: ,P_addl_where => l_addl_where
267: ,P_percent_analyzed =>P_perc_analyzed
268: ,P_trace_mode =>p_trace
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);

Line 271: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_QUOTE || AS_GAR.G_RETURN_STATUS || l_return_status);

267: ,P_percent_analyzed =>P_perc_analyzed
268: ,P_trace_mode =>p_trace
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;

Line 274: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_QUOTE, l_errbuf, l_retcode);

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
278: l_addl_where := NULL;

Line 284: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_PROPOSAL || G_WHERE || l_addl_where);

280: IF P_pr_addl_where IS NOT NULL THEN
281: l_addl_where := ' Where ' || P_pr_addl_where;
282: END IF;
283: END IF;
284: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_PROPOSAL || G_WHERE || l_addl_where);
285: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_PROPOSAL || AS_GAR.G_START);
286: Process_trans_data(
287: p_trans_id => -1106
288: ,P_addl_where => l_addl_where

Line 285: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_PROPOSAL || AS_GAR.G_START);

281: l_addl_where := ' Where ' || P_pr_addl_where;
282: END IF;
283: END IF;
284: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_PROPOSAL || G_WHERE || l_addl_where);
285: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_PROPOSAL || AS_GAR.G_START);
286: Process_trans_data(
287: p_trans_id => -1106
288: ,P_addl_where => l_addl_where
289: ,P_percent_analyzed =>P_perc_analyzed

Line 292: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_PROPOSAL || AS_GAR.G_END);

288: ,P_addl_where => l_addl_where
289: ,P_percent_analyzed =>P_perc_analyzed
290: ,P_trace_mode =>p_trace
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);

Line 293: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_PROPOSAL || AS_GAR.G_RETURN_STATUS || l_return_status);

289: ,P_percent_analyzed =>P_perc_analyzed
290: ,P_trace_mode =>p_trace
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;

Line 296: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_PROPOSAL, l_errbuf, l_retcode);

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
300: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_DEL_CHNG || 'ALL_SALES' || AS_GAR.G_START);

Line 300: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_DEL_CHNG || 'ALL_SALES' || AS_GAR.G_START);

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',
302: x_errbuf =>l_errbuf
303: ,x_retcode =>l_retcode
304: ,x_return_status =>l_return_status);

Line 305: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_DEL_CHNG ||'ALL_SALES' || AS_GAR.G_END);

301: DELETE_CHANGED_ENTITY('ALL_SALES',
302: x_errbuf =>l_errbuf
303: ,x_retcode =>l_retcode
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);

Line 306: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_DEL_CHNG ||'ALL_SALES' || AS_GAR.G_RETURN_STATUS || l_return_status);

302: x_errbuf =>l_errbuf
303: ,x_retcode =>l_retcode
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;

Line 309: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO ||'ALL_SALES' || G_DEL_CHNG, l_errbuf, l_retcode);

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:
313: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_DEL_CHNG || 'ALL_QUOTES' || AS_GAR.G_START);

Line 313: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_DEL_CHNG || 'ALL_QUOTES' || AS_GAR.G_START);

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',
315: x_errbuf =>l_errbuf
316: ,x_retcode =>l_retcode
317: ,x_return_status =>l_return_status);

Line 318: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_DEL_CHNG ||'ALL_QUOTES' || AS_GAR.G_END);

314: DELETE_CHANGED_ENTITY('ALL_QUOTES',
315: x_errbuf =>l_errbuf
316: ,x_retcode =>l_retcode
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);

Line 319: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_DEL_CHNG ||'ALL_QUOTES' || AS_GAR.G_RETURN_STATUS || l_return_status);

315: x_errbuf =>l_errbuf
316: ,x_retcode =>l_retcode
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;

Line 322: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO ||'ALL_QUOTES' || G_DEL_CHNG, l_errbuf, l_retcode);

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);
326: DELETE_CHANGED_ENTITY('ALL_PROPOSALS',

Line 325: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_DEL_CHNG || 'ALL_PROPOSALS' || AS_GAR.G_START);

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
328: ,x_retcode =>l_retcode
329: ,x_return_status =>l_return_status);

Line 330: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_DEL_CHNG ||'ALL_PROPOSALS' || AS_GAR.G_END);

326: DELETE_CHANGED_ENTITY('ALL_PROPOSALS',
327: x_errbuf =>l_errbuf
328: ,x_retcode =>l_retcode
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);

Line 331: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_DEL_CHNG ||'ALL_PROPOSALS' || AS_GAR.G_RETURN_STATUS || l_return_status);

327: x_errbuf =>l_errbuf
328: ,x_retcode =>l_retcode
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;

Line 334: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO ||'ALL_PROPOSALS' || G_DEL_CHNG, l_errbuf, l_retcode);

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:
338: ELSE

Line 339: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_DEL_CHNG || 'ACCOUNT' || AS_GAR.G_START);

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);
340: DELETE_CHANGED_ENTITY('ACCOUNT',
341: x_errbuf =>l_errbuf
342: ,x_retcode =>l_retcode
343: ,x_return_status =>l_return_status);

Line 344: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_DEL_CHNG ||'ACCOUNT' || AS_GAR.G_END);

340: DELETE_CHANGED_ENTITY('ACCOUNT',
341: x_errbuf =>l_errbuf
342: ,x_retcode =>l_retcode
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);

Line 345: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_DEL_CHNG ||'ACCOUNT' || AS_GAR.G_RETURN_STATUS || l_return_status);

341: x_errbuf =>l_errbuf
342: ,x_retcode =>l_retcode
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;

Line 348: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO ||'ACCOUNT' || G_DEL_CHNG, l_errbuf, l_retcode);

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:
352: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_DEL_CHNG || 'LEAD' || AS_GAR.G_START);

Line 352: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_DEL_CHNG || 'LEAD' || AS_GAR.G_START);

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',
354: x_errbuf =>l_errbuf
355: ,x_retcode =>l_retcode
356: ,x_return_status =>l_return_status);

Line 357: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_DEL_CHNG ||'LEAD' || AS_GAR.G_END);

353: DELETE_CHANGED_ENTITY('LEAD',
354: x_errbuf =>l_errbuf
355: ,x_retcode =>l_retcode
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);

Line 358: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_DEL_CHNG ||'LEAD' || AS_GAR.G_RETURN_STATUS || l_return_status);

354: x_errbuf =>l_errbuf
355: ,x_retcode =>l_retcode
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;

Line 361: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO ||'LEAD' || G_DEL_CHNG, l_errbuf, l_retcode);

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:
365: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_DEL_CHNG || 'OPPTY' || AS_GAR.G_START);

Line 365: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_DEL_CHNG || 'OPPTY' || AS_GAR.G_START);

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',
367: x_errbuf =>l_errbuf
368: ,x_retcode =>l_retcode
369: ,x_return_status =>l_return_status);

Line 370: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_DEL_CHNG ||'OPPTY' || AS_GAR.G_END);

366: DELETE_CHANGED_ENTITY('OPPTY',
367: x_errbuf =>l_errbuf
368: ,x_retcode =>l_retcode
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);

Line 371: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_DEL_CHNG ||'OPPTY' || AS_GAR.G_RETURN_STATUS || l_return_status);

367: x_errbuf =>l_errbuf
368: ,x_retcode =>l_retcode
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;

Line 374: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO ||'OPPTY' || G_DEL_CHNG, l_errbuf, l_retcode);

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:
378: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_DEL_CHNG || 'QUOTE' || AS_GAR.G_START);

Line 378: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_DEL_CHNG || 'QUOTE' || AS_GAR.G_START);

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',
380: x_errbuf =>l_errbuf
381: ,x_retcode =>l_retcode
382: ,x_return_status =>l_return_status);

Line 383: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_DEL_CHNG ||'QUOTE' || AS_GAR.G_END);

379: DELETE_CHANGED_ENTITY('QUOTE',
380: x_errbuf =>l_errbuf
381: ,x_retcode =>l_retcode
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);

Line 384: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_DEL_CHNG ||'QUOTE' || AS_GAR.G_RETURN_STATUS || l_return_status);

380: x_errbuf =>l_errbuf
381: ,x_retcode =>l_retcode
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;

Line 387: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO ||'QUOTE' || G_DEL_CHNG, l_errbuf, l_retcode);

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);
391: DELETE_CHANGED_ENTITY('PROPOSAL',

Line 390: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_DEL_CHNG || 'PROPOSAL' || AS_GAR.G_START);

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
393: ,x_retcode =>l_retcode
394: ,x_return_status =>l_return_status);

Line 395: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_DEL_CHNG ||'PROPOSAL' || AS_GAR.G_END);

391: DELETE_CHANGED_ENTITY('PROPOSAL',
392: x_errbuf =>l_errbuf
393: ,x_retcode =>l_retcode
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);

Line 396: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_DEL_CHNG ||'PROPOSAL' || AS_GAR.G_RETURN_STATUS || l_return_status);

392: x_errbuf =>l_errbuf
393: ,x_retcode =>l_retcode
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;

Line 399: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO ||'PROPOSAL' || G_DEL_CHNG, l_errbuf, l_retcode);

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);
403: AS_ATA_NEW_PUB.POST_ATA(

Line 402: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_POSTATA || AS_GAR.G_START);

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);
405:
406: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_POSTATA || AS_GAR.G_END);

Line 406: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_POSTATA || AS_GAR.G_END);

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);
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;

Line 407: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_POSTATA || AS_GAR.G_RETURN_STATUS || l_return_status);

403: AS_ATA_NEW_PUB.POST_ATA(
404: x_return_status => l_return_status);
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;

Line 413: AS_GAR.LOG(G_ENTITY || l_proc || AS_GAR.G_END);

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
415: WHEN FND_API.G_EXC_ERROR THEN
416: Errbuf := l_errbuf;
417: Retcode := l_retcode;

Line 419: AS_GAR.LOG_EXCEPTION(G_ENTITY, SQLERRM, TO_CHAR(SQLCODE));

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));
420: l_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', SQLERRM);
421: END Assign_Territory_Accesses;
422:
423: PROCEDURE Process_trans_data

Line 446: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PR_ACCOUNT || AS_GAR.G_START);

442: l_prof_no_of_workers NUMBER;
443: l_entity VARCHAR2(20);
444: BEGIN
445: IF p_trans_id = -1002 THEN
446: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PR_ACCOUNT || AS_GAR.G_START);
447: l_program_name := 'SALES/ACCOUNT PROGRAM';
448: l_con_req_name :='ASXGARAC';
449: l_prof_no_of_workers := fnd_profile.value('AS_TAP_NUM_CHILD_ACCOUNT_WORKERS');
450: l_entity := ': ACCOUNT :';

Line 448: l_con_req_name :='ASXGARAC';

444: BEGIN
445: IF p_trans_id = -1002 THEN
446: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PR_ACCOUNT || AS_GAR.G_START);
447: l_program_name := 'SALES/ACCOUNT PROGRAM';
448: l_con_req_name :='ASXGARAC';
449: l_prof_no_of_workers := fnd_profile.value('AS_TAP_NUM_CHILD_ACCOUNT_WORKERS');
450: l_entity := ': ACCOUNT :';
451: ELSIF p_trans_id = -1003 THEN
452: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PR_LEAD || AS_GAR.G_START);

Line 452: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PR_LEAD || AS_GAR.G_START);

448: l_con_req_name :='ASXGARAC';
449: l_prof_no_of_workers := fnd_profile.value('AS_TAP_NUM_CHILD_ACCOUNT_WORKERS');
450: l_entity := ': ACCOUNT :';
451: ELSIF p_trans_id = -1003 THEN
452: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PR_LEAD || AS_GAR.G_START);
453: l_program_name := 'SALES/LEAD PROGRAM';
454: l_con_req_name :='ASXGARLD';
455: l_prof_no_of_workers := fnd_profile.value('AS_TAP_NUM_CHILD_LEAD_WORKERS');
456: l_entity := ' : LEAD : ';

Line 454: l_con_req_name :='ASXGARLD';

450: l_entity := ': ACCOUNT :';
451: ELSIF p_trans_id = -1003 THEN
452: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PR_LEAD || AS_GAR.G_START);
453: l_program_name := 'SALES/LEAD PROGRAM';
454: l_con_req_name :='ASXGARLD';
455: l_prof_no_of_workers := fnd_profile.value('AS_TAP_NUM_CHILD_LEAD_WORKERS');
456: l_entity := ' : LEAD : ';
457: ELSIF p_trans_id = -1004 THEN
458: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PR_OPPTY || AS_GAR.G_START);

Line 458: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PR_OPPTY || AS_GAR.G_START);

454: l_con_req_name :='ASXGARLD';
455: l_prof_no_of_workers := fnd_profile.value('AS_TAP_NUM_CHILD_LEAD_WORKERS');
456: l_entity := ' : LEAD : ';
457: ELSIF p_trans_id = -1004 THEN
458: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PR_OPPTY || AS_GAR.G_START);
459: l_program_name := 'SALES/OPPORTUNITY PROGRAM';
460: l_con_req_name :='ASXGAROP';
461: l_prof_no_of_workers := fnd_profile.value('AS_TAP_NUM_CHILD_OPPOR_WORKERS');
462: l_entity := ' : OPPORTUNITY : ';

Line 460: l_con_req_name :='ASXGAROP';

456: l_entity := ' : LEAD : ';
457: ELSIF p_trans_id = -1004 THEN
458: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PR_OPPTY || AS_GAR.G_START);
459: l_program_name := 'SALES/OPPORTUNITY PROGRAM';
460: l_con_req_name :='ASXGAROP';
461: l_prof_no_of_workers := fnd_profile.value('AS_TAP_NUM_CHILD_OPPOR_WORKERS');
462: l_entity := ' : OPPORTUNITY : ';
463: ELSIF p_trans_id = -1105 THEN
464: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PR_QUOTE || AS_GAR.G_START);

Line 464: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PR_QUOTE || AS_GAR.G_START);

460: l_con_req_name :='ASXGAROP';
461: l_prof_no_of_workers := fnd_profile.value('AS_TAP_NUM_CHILD_OPPOR_WORKERS');
462: l_entity := ' : OPPORTUNITY : ';
463: ELSIF p_trans_id = -1105 THEN
464: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PR_QUOTE || AS_GAR.G_START);
465: l_program_name := 'SALES/QUOTE PROGRAM';
466: l_con_req_name :='ASXGARQT';
467: l_prof_no_of_workers := fnd_profile.value('AS_TAP_NUM_CHILD_QUOTE_WORKERS');
468: l_entity := ' : QUOTE : ';

Line 466: l_con_req_name :='ASXGARQT';

462: l_entity := ' : OPPORTUNITY : ';
463: ELSIF p_trans_id = -1105 THEN
464: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PR_QUOTE || AS_GAR.G_START);
465: l_program_name := 'SALES/QUOTE PROGRAM';
466: l_con_req_name :='ASXGARQT';
467: l_prof_no_of_workers := fnd_profile.value('AS_TAP_NUM_CHILD_QUOTE_WORKERS');
468: l_entity := ' : QUOTE : ';
469: ELSIF p_trans_id = -1106 THEN
470: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PR_PROPOSAL || AS_GAR.G_START);

Line 470: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PR_PROPOSAL || AS_GAR.G_START);

466: l_con_req_name :='ASXGARQT';
467: l_prof_no_of_workers := fnd_profile.value('AS_TAP_NUM_CHILD_QUOTE_WORKERS');
468: l_entity := ' : QUOTE : ';
469: ELSIF p_trans_id = -1106 THEN
470: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PR_PROPOSAL || AS_GAR.G_START);
471: l_program_name := 'SALES/PROPOSAL PROGRAM';
472: l_con_req_name :='ASXGARPR';
473: l_prof_no_of_workers := fnd_profile.value('AS_TAP_NUM_CHILD_PROPOSAL_WORKERS');
474: l_entity := ' : PROPOSAL : ';

Line 472: l_con_req_name :='ASXGARPR';

468: l_entity := ' : QUOTE : ';
469: ELSIF p_trans_id = -1106 THEN
470: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PR_PROPOSAL || AS_GAR.G_START);
471: l_program_name := 'SALES/PROPOSAL PROGRAM';
472: l_con_req_name :='ASXGARPR';
473: l_prof_no_of_workers := fnd_profile.value('AS_TAP_NUM_CHILD_PROPOSAL_WORKERS');
474: l_entity := ' : PROPOSAL : ';
475: END IF;
476: IF l_prof_no_of_workers >10 then

Line 480: AS_GAR.LOG(G_ENTITY ||l_entity|| 'No of Workers :'|| l_prof_no_of_workers);

476: IF l_prof_no_of_workers >10 then
477: l_prof_no_of_workers := 10;
478: END IF;
479:
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,

Line 481: AS_GAR.LOG(G_ENTITY ||l_entity|| AS_GAR.G_CALL_TO || G_PR_TRANS || AS_GAR.G_START);

477: l_prof_no_of_workers := 10;
478: END IF;
479:
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,

Line 498: AS_GAR.LOG(G_ENTITY ||l_entity|| AS_GAR.G_CALL_TO || G_PR_TRANS || AS_GAR.G_END);

494: X_msg_count => l_msg_count,
495: X_msg_data => l_msg_data,
496: Errbuf => l_errbuf,
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);

Line 499: AS_GAR.LOG(G_ENTITY ||l_entity|| AS_GAR.G_CALL_TO || G_PR_TRANS || AS_GAR.G_RETURN_STATUS || l_return_status);

495: X_msg_data => l_msg_data,
496: Errbuf => l_errbuf,
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;

Line 502: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_TRANS, l_errbuf, 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:
506: FOR i in 1..l_prof_no_of_workers

Line 508: AS_GAR.LOG(G_ENTITY ||l_entity || G_GAR_SUBMIT || AS_GAR.G_START ||' Worker ID : ' || i);

504: END IF;
505:
506: FOR i in 1..l_prof_no_of_workers
507: LOOP
508: AS_GAR.LOG(G_ENTITY ||l_entity || G_GAR_SUBMIT || AS_GAR.G_START ||' Worker ID : ' || i);
509: l_req_id := FND_REQUEST.SUBMIT_REQUEST('AS',
510: l_con_req_name,
511: '',
512: '',

Line 515: AS_GAR.g_debug_flag,

511: '',
512: '',
513: FALSE,
514: 'NEW',
515: AS_GAR.g_debug_flag,
516: P_trace_mode ,
517: i,
518: P_percent_analyzed,
519: CHR(0));

Line 521: AS_GAR.LOG(G_ENTITY ||l_entity|| G_GAR_SUBMIT || AS_GAR.G_END ||' Request ID : ' || l_req_id);

517: i,
518: P_percent_analyzed,
519: CHR(0));
520:
521: AS_GAR.LOG(G_ENTITY ||l_entity|| G_GAR_SUBMIT || AS_GAR.G_END ||' Request ID : ' || l_req_id);
522: IF l_req_id = 0
523: THEN
524: l_msg_data:=FND_MESSAGE.GET;
525: AS_GAR.LOG(G_ENTITY ||l_entity|| G_GAR_SUBMIT || AS_GAR.G_END ||' ERRPR :' || l_msg_data);

Line 525: AS_GAR.LOG(G_ENTITY ||l_entity|| G_GAR_SUBMIT || AS_GAR.G_END ||' ERRPR :' || l_msg_data);

521: AS_GAR.LOG(G_ENTITY ||l_entity|| G_GAR_SUBMIT || AS_GAR.G_END ||' Request ID : ' || l_req_id);
522: IF l_req_id = 0
523: THEN
524: l_msg_data:=FND_MESSAGE.GET;
525: AS_GAR.LOG(G_ENTITY ||l_entity|| G_GAR_SUBMIT || AS_GAR.G_END ||' ERRPR :' || l_msg_data);
526: END IF;
527: END LOOP;
528: EXCEPTION
529: WHEN OTHERS THEN

Line 531: AS_GAR.LOG_EXCEPTION(G_ENTITY ||l_entity, SQLERRM, TO_CHAR(SQLCODE));

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:
535: PROCEDURE PRE_ATA(

Line 541: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PREATA || AS_GAR.G_START);

537: ) IS
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

Line 543: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PREATA || 'UPDATE REQUEST ID INTO AS_CHANGED_ACCOUNTS TABLE');

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;
547:

Line 550: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PREATA || 'UPDATE REQUEST ID INTO ASO_CHANGED_QUOTES TABLE');

546: where REQUEST_ID IS NULL;
547:
548: COMMIT;
549:
550: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PREATA || 'UPDATE REQUEST ID INTO ASO_CHANGED_QUOTES TABLE');
551: update ASO_CHANGED_QUOTES
552: set CONC_REQUEST_ID = FND_GLOBAL.Conc_Request_Id
553: where CONC_REQUEST_ID IS NULL;
554:

Line 557: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PREATA || 'UPDATE REQUEST ID INTO ASO_CHANGED_QUOTES TABLE');

553: where CONC_REQUEST_ID IS NULL;
554:
555: COMMIT;
556:
557: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PREATA || 'UPDATE REQUEST ID INTO ASO_CHANGED_QUOTES TABLE');
558: update PRP_CHANGED_PROPOSALS
559: set REQUEST_ID = FND_GLOBAL.Conc_Request_Id
560: where REQUEST_ID IS NULL;
561: COMMIT;

Line 566: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || G_PREATA || AS_GAR.G_GENERAL_EXCEPTION, SQLERRM, TO_CHAR(SQLCODE));

562:
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:

Line 652: AS_GAR.LOG(G_ENTITY || 'DELETE FROM CHANGED ENTITY::' || p_entity || ': LOOPCOUNT :- ' ||l_loop_count);

648: LOOP --{L1
649: IF (l_limit_flag) THEN EXIT; END IF;
650: l_loop_count := l_loop_count + 1;
651: BEGIN
652: AS_GAR.LOG(G_ENTITY || 'DELETE FROM CHANGED ENTITY::' || p_entity || ': LOOPCOUNT :- ' ||l_loop_count);
653: l_flag := TRUE;
654: l_first := 0;
655: l_last := 0;
656:

Line 698: AS_GAR.LOG(G_ENTITY || 'DELETE FROM CHANGED ENTITY::' || p_entity || AS_GAR.G_N_ROWS_PROCESSED ||

694: IF p_entity_id.count > 0 THEN --{I1
695: l_flag := TRUE;
696: l_first := p_entity_id.first;
697: l_last := l_first + l_var;
698: AS_GAR.LOG(G_ENTITY || 'DELETE FROM CHANGED ENTITY::' || p_entity || AS_GAR.G_N_ROWS_PROCESSED ||
699: p_entity_id.FIRST || '-' ||
700: p_entity_id.LAST);
701: WHILE l_flag LOOP --{L2 10K cust loop
702: IF l_last > p_entity_id.LAST THEN

Line 761: AS_GAR.LOG('processing Individual Delete');

757: EXCEPTION
758: WHEN DEADLOCK_DETECTED THEN
759: BEGIN --{I2
760: ROLLBACK;
761: AS_GAR.LOG('processing Individual Delete');
762:
763: FOR i IN l_first .. l_last LOOP --{L5
764: BEGIN
765: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_UPD_ACCESSES || AS_GAR.G_IND_DEL || AS_GAR.G_START);

Line 765: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_UPD_ACCESSES || AS_GAR.G_IND_DEL || AS_GAR.G_START);

761: AS_GAR.LOG('processing Individual Delete');
762:
763: FOR i IN l_first .. l_last LOOP --{L5
764: BEGIN
765: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_UPD_ACCESSES || AS_GAR.G_IND_DEL || AS_GAR.G_START);
766: IF p_entity = 'ACCOUNT' THEN
767: DELETE FROM AS_CHANGED_ACCOUNTS_ALL ACC
768: WHERE ACC.customer_id=p_entity_id(i)
769: AND ACC.lead_id IS NULL

Line 799: AS_GAR.LOG(G_ENTITY || 'DELETE FROM CHANGED ENTITY::' || p_entity || AS_GAR.G_IND_DEL || AS_GAR.G_GENERAL_EXCEPTION);

795: END IF;
796: COMMIT;
797: EXCEPTION
798: WHEN OTHERS THEN
799: AS_GAR.LOG(G_ENTITY || 'DELETE FROM CHANGED ENTITY::' || p_entity || AS_GAR.G_IND_DEL || AS_GAR.G_GENERAL_EXCEPTION);
800: AS_GAR.LOG('ENTITY_ID - ' || p_entity_id(i));
801: END;
802: END LOOP; --}L5
803: COMMIT;

Line 800: AS_GAR.LOG('ENTITY_ID - ' || p_entity_id(i));

796: COMMIT;
797: EXCEPTION
798: WHEN OTHERS THEN
799: AS_GAR.LOG(G_ENTITY || 'DELETE FROM CHANGED ENTITY::' || p_entity || AS_GAR.G_IND_DEL || AS_GAR.G_GENERAL_EXCEPTION);
800: AS_GAR.LOG('ENTITY_ID - ' || p_entity_id(i));
801: END;
802: END LOOP; --}L5
803: COMMIT;
804:

Line 807: AS_GAR.LOG_EXCEPTION(G_ENTITY || 'DELETE FROM CHANGED ENTITY::' || p_entity || AS_GAR.G_GENERAL_EXCEPTION, SQLERRM, TO_CHAR(SQLCODE));

803: COMMIT;
804:
805: END; --}I2 end of deadlock exception
806: WHEN OTHERS THEN
807: AS_GAR.LOG_EXCEPTION(G_ENTITY || 'DELETE FROM CHANGED ENTITY::' || p_entity || AS_GAR.G_GENERAL_EXCEPTION, SQLERRM, TO_CHAR(SQLCODE));
808: IF del_acct_changed%ISOPEN THEN CLOSE del_acct_changed; END IF;
809: IF del_lead_changed%ISOPEN THEN CLOSE del_lead_changed; END IF;
810: IF del_oppty_changed%ISOPEN THEN CLOSE del_oppty_changed; END IF;
811: IF del_quote_changed%ISOPEN THEN CLOSE del_quote_changed; END IF;

Line 821: AS_GAR.LOG(G_ENTITY || 'DELETE FROM CHANGED ENTITY::' || p_entity || AS_GAR.G_N_ROWS_PROCESSED || l_first || '-' || l_last);

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:
823: l_first := l_last + 1;
824: l_last := l_first + l_var;
825: IF l_first > p_entity_id.LAST THEN

Line 830: AS_GAR.LOG(G_ENTITY ||'DELETE FROM CHANGED ENTITY::' || AS_GAR.G_END);

826: l_flag := FALSE;
827: END IF;
828: END LOOP; --}L2 while l_flag loop (10K cust loop)
829: END IF;--}I1
830: AS_GAR.LOG(G_ENTITY ||'DELETE FROM CHANGED ENTITY::' || AS_GAR.G_END);
831: COMMIT;
832: EXCEPTION
833: WHEN Others THEN
834: AS_GAR.LOG_EXCEPTION(G_ENTITY || 'DELETE FROM CHANGED ENTITY::' || p_entity || AS_GAR.G_GENERAL_EXCEPTION, SQLERRM, TO_CHAR(SQLCODE));

Line 834: AS_GAR.LOG_EXCEPTION(G_ENTITY || 'DELETE FROM CHANGED ENTITY::' || p_entity || AS_GAR.G_GENERAL_EXCEPTION, SQLERRM, TO_CHAR(SQLCODE));

830: AS_GAR.LOG(G_ENTITY ||'DELETE FROM CHANGED ENTITY::' || AS_GAR.G_END);
831: COMMIT;
832: EXCEPTION
833: WHEN Others THEN
834: AS_GAR.LOG_EXCEPTION(G_ENTITY || 'DELETE FROM CHANGED ENTITY::' || p_entity || AS_GAR.G_GENERAL_EXCEPTION, SQLERRM, TO_CHAR(SQLCODE));
835: IF del_acct_changed%ISOPEN THEN CLOSE del_acct_changed; END IF;
836: IF del_lead_changed%ISOPEN THEN CLOSE del_lead_changed; END IF;
837: IF del_oppty_changed%ISOPEN THEN CLOSE del_oppty_changed; END IF;
838: IF del_quote_changed%ISOPEN THEN CLOSE del_quote_changed; END IF;

Line 859: AS_GAR.LOG_EXCEPTION(G_ENTITY || 'DELETE FROM CHANGED ENTITY::' || p_entity , SQLERRM, TO_CHAR(SQLCODE));

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:
863: PROCEDURE POST_ATA(

Line 869: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PREATA || AS_GAR.G_START);

865: ) IS
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

Line 871: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PREATA || 'UPDATE REQUEST ID INTO AS_CHANGED_ACCOUNTS TABLE');

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;
875:

Line 878: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PREATA || 'UPDATE REQUEST ID INTO ASO_CHANGED_QUOTES TABLE');

874: WHERE REQUEST_ID = FND_GLOBAL.Conc_Request_Id;
875:
876: COMMIT;
877:
878: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PREATA || 'UPDATE REQUEST ID INTO ASO_CHANGED_QUOTES TABLE');
879: update ASO_CHANGED_QUOTES
880: set CONC_REQUEST_ID = NULL
881: where CONC_REQUEST_ID =FND_GLOBAL.Conc_Request_Id;
882:

Line 885: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PREATA || 'UPDATE REQUEST ID INTO ASO_CHANGED_QUOTES TABLE');

881: where CONC_REQUEST_ID =FND_GLOBAL.Conc_Request_Id;
882:
883: COMMIT;
884:
885: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PREATA || 'UPDATE REQUEST ID INTO ASO_CHANGED_QUOTES TABLE');
886: update PRP_CHANGED_PROPOSALS
887: set REQUEST_ID = NULL
888: where REQUEST_ID = FND_GLOBAL.Conc_Request_Id;
889: COMMIT;

Line 894: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || G_PREATA || AS_GAR.G_GENERAL_EXCEPTION, SQLERRM, TO_CHAR(SQLCODE));

890:
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: