eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AS_ATA_TOTAL_PUB dependencies on AS_GAR

Line 62: AS_GAR.g_debug_flag := p_debug;

58: l_errbuf VARCHAR2(4000);
59: l_retcode VARCHAR2(255);
60: l_oracle_schema VARCHAR2(32) := 'OSM';
61: BEGIN
62: AS_GAR.g_debug_flag := p_debug;
63: IF P_trace = 'Y' THEN AS_GAR.SETTRACE; END IF;
64: AS_GAR.LOG(G_ENTITY || G_PR_ACCOUNT || AS_GAR.G_START);
65: IF P_submit_acc_tap='Y' THEN
66: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_SETAREASIZE || AS_GAR.G_START);

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

59: l_retcode VARCHAR2(255);
60: l_oracle_schema VARCHAR2(32) := 'OSM';
61: BEGIN
62: AS_GAR.g_debug_flag := p_debug;
63: IF P_trace = 'Y' THEN AS_GAR.SETTRACE; END IF;
64: AS_GAR.LOG(G_ENTITY || G_PR_ACCOUNT || AS_GAR.G_START);
65: IF P_submit_acc_tap='Y' THEN
66: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_SETAREASIZE || AS_GAR.G_START);
67: AS_GAR.Set_Area_Sizes;

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

60: l_oracle_schema VARCHAR2(32) := 'OSM';
61: BEGIN
62: AS_GAR.g_debug_flag := p_debug;
63: IF P_trace = 'Y' THEN AS_GAR.SETTRACE; END IF;
64: AS_GAR.LOG(G_ENTITY || G_PR_ACCOUNT || AS_GAR.G_START);
65: IF P_submit_acc_tap='Y' THEN
66: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_SETAREASIZE || AS_GAR.G_START);
67: AS_GAR.Set_Area_Sizes;
68: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_SETAREASIZE || AS_GAR.G_END);

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

62: AS_GAR.g_debug_flag := p_debug;
63: IF P_trace = 'Y' THEN AS_GAR.SETTRACE; END IF;
64: AS_GAR.LOG(G_ENTITY || G_PR_ACCOUNT || AS_GAR.G_START);
65: IF P_submit_acc_tap='Y' THEN
66: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_SETAREASIZE || AS_GAR.G_START);
67: AS_GAR.Set_Area_Sizes;
68: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_SETAREASIZE || AS_GAR.G_END);
69: IF P_account_type = 'ORGANIZATION' THEN
70: l_addl_where := ' Where party_type = ''ORGANIZATION''';

Line 67: AS_GAR.Set_Area_Sizes;

63: IF P_trace = 'Y' THEN AS_GAR.SETTRACE; END IF;
64: AS_GAR.LOG(G_ENTITY || G_PR_ACCOUNT || AS_GAR.G_START);
65: IF P_submit_acc_tap='Y' THEN
66: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_SETAREASIZE || AS_GAR.G_START);
67: AS_GAR.Set_Area_Sizes;
68: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_SETAREASIZE || AS_GAR.G_END);
69: IF P_account_type = 'ORGANIZATION' THEN
70: l_addl_where := ' Where party_type = ''ORGANIZATION''';
71: ELSIF P_account_type = 'PERSON' THEN

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

64: AS_GAR.LOG(G_ENTITY || G_PR_ACCOUNT || AS_GAR.G_START);
65: IF P_submit_acc_tap='Y' THEN
66: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_SETAREASIZE || AS_GAR.G_START);
67: AS_GAR.Set_Area_Sizes;
68: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_SETAREASIZE || AS_GAR.G_END);
69: IF P_account_type = 'ORGANIZATION' THEN
70: l_addl_where := ' Where party_type = ''ORGANIZATION''';
71: ELSIF P_account_type = 'PERSON' THEN
72: l_addl_where := ' Where party_type = ''PERSON''';

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

77: ELSE
78: l_addl_where := l_Addl_Where || ' and ' ||p_addl_Where;
79: END IF;
80: END IF;
81: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_ACCOUNT || G_WHERE || l_addl_where);
82: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_ACCOUNT || AS_GAR.G_START);
83:
84: DELETE_CHANGED_ENTITY(p_entity => 'ACCOUNT',
85: x_errbuf => l_errbuf,

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

78: l_addl_where := l_Addl_Where || ' and ' ||p_addl_Where;
79: END IF;
80: END IF;
81: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_ACCOUNT || G_WHERE || l_addl_where);
82: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_ACCOUNT || AS_GAR.G_START);
83:
84: DELETE_CHANGED_ENTITY(p_entity => 'ACCOUNT',
85: x_errbuf => l_errbuf,
86: x_retcode => l_retcode,

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

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

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

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

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

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

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

131:
132: --fix for bug(5869095) --populating as_terr_resources_tmp table
133:
134: END IF;
135: AS_GAR.LOG(G_ENTITY || G_PR_ACCOUNT || AS_GAR.G_END);
136: EXCEPTION
137: WHEN OTHERS THEN
138: AS_GAR.LOG_EXCEPTION(G_ENTITY, SQLERRM, TO_CHAR(SQLCODE));
139: l_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', SQLERRM);

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

134: END IF;
135: AS_GAR.LOG(G_ENTITY || G_PR_ACCOUNT || AS_GAR.G_END);
136: EXCEPTION
137: WHEN OTHERS THEN
138: AS_GAR.LOG_EXCEPTION(G_ENTITY, SQLERRM, TO_CHAR(SQLCODE));
139: l_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', SQLERRM);
140: END Assign_Account_Terr_Accesses;
141:
142: PROCEDURE Assign_Lead_Terr_Accesses(

Line 159: AS_GAR.g_debug_flag := p_debug;

155: l_addl_where VARCHAR2(2000);
156: l_return_status VARCHAR2(10);
157: l_status BOOLEAN;
158: BEGIN
159: AS_GAR.g_debug_flag := p_debug;
160: IF P_trace = 'Y' THEN AS_GAR.SETTRACE; END IF;
161: AS_GAR.LOG(G_ENTITY || G_PR_LEAD || AS_GAR.G_START);
162:
163: IF P_submit_lead_tap='Y' THEN

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

156: l_return_status VARCHAR2(10);
157: l_status BOOLEAN;
158: BEGIN
159: AS_GAR.g_debug_flag := p_debug;
160: IF P_trace = 'Y' THEN AS_GAR.SETTRACE; END IF;
161: AS_GAR.LOG(G_ENTITY || G_PR_LEAD || AS_GAR.G_START);
162:
163: IF P_submit_lead_tap='Y' THEN
164: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_SETAREASIZE || AS_GAR.G_START);

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

157: l_status BOOLEAN;
158: BEGIN
159: AS_GAR.g_debug_flag := p_debug;
160: IF P_trace = 'Y' THEN AS_GAR.SETTRACE; END IF;
161: AS_GAR.LOG(G_ENTITY || G_PR_LEAD || AS_GAR.G_START);
162:
163: IF P_submit_lead_tap='Y' THEN
164: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_SETAREASIZE || AS_GAR.G_START);
165: AS_GAR.Set_Area_Sizes;

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

160: IF P_trace = 'Y' THEN AS_GAR.SETTRACE; END IF;
161: AS_GAR.LOG(G_ENTITY || G_PR_LEAD || AS_GAR.G_START);
162:
163: IF P_submit_lead_tap='Y' THEN
164: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_SETAREASIZE || AS_GAR.G_START);
165: AS_GAR.Set_Area_Sizes;
166: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_SETAREASIZE || AS_GAR.G_END);
167:
168: DELETE_CHANGED_ENTITY(p_entity => 'LEAD',

Line 165: AS_GAR.Set_Area_Sizes;

161: AS_GAR.LOG(G_ENTITY || G_PR_LEAD || AS_GAR.G_START);
162:
163: IF P_submit_lead_tap='Y' THEN
164: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_SETAREASIZE || AS_GAR.G_START);
165: AS_GAR.Set_Area_Sizes;
166: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_SETAREASIZE || AS_GAR.G_END);
167:
168: DELETE_CHANGED_ENTITY(p_entity => 'LEAD',
169: x_errbuf => l_errbuf,

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

162:
163: IF P_submit_lead_tap='Y' THEN
164: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_SETAREASIZE || AS_GAR.G_START);
165: AS_GAR.Set_Area_Sizes;
166: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_SETAREASIZE || AS_GAR.G_END);
167:
168: DELETE_CHANGED_ENTITY(p_entity => 'LEAD',
169: x_errbuf => l_errbuf,
170: x_retcode => l_retcode,

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

180: ELSE
181: l_addl_where := l_Addl_Where || ' and ' ||p_addl_Where;
182: END IF;
183: END IF;
184: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_LEAD || G_WHERE || l_addl_where);
185: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_LEAD || AS_GAR.G_START);
186: Process_trans_data(
187: p_trans_id => -1003
188: ,P_addl_where => l_addl_where

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

181: l_addl_where := l_Addl_Where || ' and ' ||p_addl_Where;
182: END IF;
183: END IF;
184: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_LEAD || G_WHERE || l_addl_where);
185: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_LEAD || AS_GAR.G_START);
186: Process_trans_data(
187: p_trans_id => -1003
188: ,P_addl_where => l_addl_where
189: ,P_percent_analyzed =>P_perc_analyzed

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

188: ,P_addl_where => l_addl_where
189: ,P_percent_analyzed =>P_perc_analyzed
190: ,P_trace_mode => p_trace
191: ,x_return_status => l_return_status);
192: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_LEAD || AS_GAR.G_END ||l_return_status);
193: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_LEAD || AS_GAR.G_RETURN_STATUS || l_return_status);
194: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
195: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_LEAD, l_errbuf, l_retcode);
196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

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

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

195: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_LEAD, l_errbuf, l_retcode);
196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
197: End If;
198: END IF;
199: AS_GAR.LOG(G_ENTITY || G_PR_LEAD || AS_GAR.G_END);
200: EXCEPTION
201: WHEN OTHERS THEN
202: AS_GAR.LOG_EXCEPTION(G_ENTITY, SQLERRM, TO_CHAR(SQLCODE));
203: l_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', SQLERRM);

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

198: END IF;
199: AS_GAR.LOG(G_ENTITY || G_PR_LEAD || AS_GAR.G_END);
200: EXCEPTION
201: WHEN OTHERS THEN
202: AS_GAR.LOG_EXCEPTION(G_ENTITY, SQLERRM, TO_CHAR(SQLCODE));
203: l_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', SQLERRM);
204: END Assign_Lead_Terr_Accesses;
205:
206: PROCEDURE Assign_Oppty_Terr_Accesses(

Line 224: AS_GAR.g_debug_flag := p_debug;

220: l_return_status VARCHAR2(10);
221: l_status BOOLEAN;
222:
223: BEGIN
224: AS_GAR.g_debug_flag := p_debug;
225: IF P_trace = 'Y' THEN AS_GAR.SETTRACE; END IF;
226: AS_GAR.LOG(G_ENTITY || G_PR_OPPTY || AS_GAR.G_START);
227: IF P_submit_oppty_tap='Y' THEN
228: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_SETAREASIZE || AS_GAR.G_START);

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

221: l_status BOOLEAN;
222:
223: BEGIN
224: AS_GAR.g_debug_flag := p_debug;
225: IF P_trace = 'Y' THEN AS_GAR.SETTRACE; END IF;
226: AS_GAR.LOG(G_ENTITY || G_PR_OPPTY || AS_GAR.G_START);
227: IF P_submit_oppty_tap='Y' THEN
228: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_SETAREASIZE || AS_GAR.G_START);
229: AS_GAR.Set_Area_Sizes;

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

222:
223: BEGIN
224: AS_GAR.g_debug_flag := p_debug;
225: IF P_trace = 'Y' THEN AS_GAR.SETTRACE; END IF;
226: AS_GAR.LOG(G_ENTITY || G_PR_OPPTY || AS_GAR.G_START);
227: IF P_submit_oppty_tap='Y' THEN
228: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_SETAREASIZE || AS_GAR.G_START);
229: AS_GAR.Set_Area_Sizes;
230: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_SETAREASIZE || AS_GAR.G_END);

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

224: AS_GAR.g_debug_flag := p_debug;
225: IF P_trace = 'Y' THEN AS_GAR.SETTRACE; END IF;
226: AS_GAR.LOG(G_ENTITY || G_PR_OPPTY || AS_GAR.G_START);
227: IF P_submit_oppty_tap='Y' THEN
228: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_SETAREASIZE || AS_GAR.G_START);
229: AS_GAR.Set_Area_Sizes;
230: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_SETAREASIZE || AS_GAR.G_END);
231:
232: DELETE_CHANGED_ENTITY(p_entity => 'OPPTY',

Line 229: AS_GAR.Set_Area_Sizes;

225: IF P_trace = 'Y' THEN AS_GAR.SETTRACE; END IF;
226: AS_GAR.LOG(G_ENTITY || G_PR_OPPTY || AS_GAR.G_START);
227: IF P_submit_oppty_tap='Y' THEN
228: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_SETAREASIZE || AS_GAR.G_START);
229: AS_GAR.Set_Area_Sizes;
230: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_SETAREASIZE || AS_GAR.G_END);
231:
232: DELETE_CHANGED_ENTITY(p_entity => 'OPPTY',
233: x_errbuf => l_errbuf,

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

226: AS_GAR.LOG(G_ENTITY || G_PR_OPPTY || AS_GAR.G_START);
227: IF P_submit_oppty_tap='Y' THEN
228: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_SETAREASIZE || AS_GAR.G_START);
229: AS_GAR.Set_Area_Sizes;
230: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_SETAREASIZE || AS_GAR.G_END);
231:
232: DELETE_CHANGED_ENTITY(p_entity => 'OPPTY',
233: x_errbuf => l_errbuf,
234: x_retcode => l_retcode,

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

244: ELSE
245: l_addl_where := l_Addl_Where || ' and ' ||p_addl_Where;
246: END IF;
247: END IF;
248: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_OPPTY || G_WHERE || l_addl_where);
249: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_OPPTY || AS_GAR.G_START);
250: Process_trans_data(
251: p_trans_id => -1004
252: ,P_addl_where => l_addl_where

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

245: l_addl_where := l_Addl_Where || ' and ' ||p_addl_Where;
246: END IF;
247: END IF;
248: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_OPPTY || G_WHERE || l_addl_where);
249: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_OPPTY || AS_GAR.G_START);
250: Process_trans_data(
251: p_trans_id => -1004
252: ,P_addl_where => l_addl_where
253: ,P_percent_analyzed =>P_perc_analyzed

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

252: ,P_addl_where => l_addl_where
253: ,P_percent_analyzed =>P_perc_analyzed
254: ,P_trace_mode => p_trace
255: ,x_return_status => l_return_status);
256: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_OPPTY || AS_GAR.G_END ||l_return_status);
257: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_OPPTY || AS_GAR.G_RETURN_STATUS || l_return_status);
258: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
259: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_OPPTY, l_errbuf, l_retcode);
260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

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

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

259: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_OPPTY, l_errbuf, l_retcode);
260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
261: End If;
262: END IF;
263: AS_GAR.LOG(G_ENTITY || G_PR_OPPTY || AS_GAR.G_END);
264: EXCEPTION
265: WHEN OTHERS THEN
266: AS_GAR.LOG_EXCEPTION(G_ENTITY, SQLERRM, TO_CHAR(SQLCODE));
267: l_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', SQLERRM);

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

262: END IF;
263: AS_GAR.LOG(G_ENTITY || G_PR_OPPTY || AS_GAR.G_END);
264: EXCEPTION
265: WHEN OTHERS THEN
266: AS_GAR.LOG_EXCEPTION(G_ENTITY, SQLERRM, TO_CHAR(SQLCODE));
267: l_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', SQLERRM);
268: END Assign_Oppty_Terr_Accesses;
269:
270:

Line 289: AS_GAR.g_debug_flag := p_debug;

285: l_addl_where VARCHAR2(2000);
286: l_return_status VARCHAR2(10);
287: l_status BOOLEAN;
288: BEGIN
289: AS_GAR.g_debug_flag := p_debug;
290: IF P_trace = 'Y' THEN AS_GAR.SETTRACE; END IF;
291: AS_GAR.LOG(G_ENTITY || G_PR_QUOTE || AS_GAR.G_START);
292: IF P_submit_quote_tap='Y' THEN
293: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_SETAREASIZE || AS_GAR.G_START);

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

286: l_return_status VARCHAR2(10);
287: l_status BOOLEAN;
288: BEGIN
289: AS_GAR.g_debug_flag := p_debug;
290: IF P_trace = 'Y' THEN AS_GAR.SETTRACE; END IF;
291: AS_GAR.LOG(G_ENTITY || G_PR_QUOTE || AS_GAR.G_START);
292: IF P_submit_quote_tap='Y' THEN
293: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_SETAREASIZE || AS_GAR.G_START);
294: AS_GAR.Set_Area_Sizes;

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

287: l_status BOOLEAN;
288: BEGIN
289: AS_GAR.g_debug_flag := p_debug;
290: IF P_trace = 'Y' THEN AS_GAR.SETTRACE; END IF;
291: AS_GAR.LOG(G_ENTITY || G_PR_QUOTE || AS_GAR.G_START);
292: IF P_submit_quote_tap='Y' THEN
293: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_SETAREASIZE || AS_GAR.G_START);
294: AS_GAR.Set_Area_Sizes;
295: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_SETAREASIZE || AS_GAR.G_END);

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

289: AS_GAR.g_debug_flag := p_debug;
290: IF P_trace = 'Y' THEN AS_GAR.SETTRACE; END IF;
291: AS_GAR.LOG(G_ENTITY || G_PR_QUOTE || AS_GAR.G_START);
292: IF P_submit_quote_tap='Y' THEN
293: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_SETAREASIZE || AS_GAR.G_START);
294: AS_GAR.Set_Area_Sizes;
295: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_SETAREASIZE || AS_GAR.G_END);
296:
297: DELETE_CHANGED_ENTITY(p_entity => 'QUOTE',

Line 294: AS_GAR.Set_Area_Sizes;

290: IF P_trace = 'Y' THEN AS_GAR.SETTRACE; END IF;
291: AS_GAR.LOG(G_ENTITY || G_PR_QUOTE || AS_GAR.G_START);
292: IF P_submit_quote_tap='Y' THEN
293: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_SETAREASIZE || AS_GAR.G_START);
294: AS_GAR.Set_Area_Sizes;
295: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_SETAREASIZE || AS_GAR.G_END);
296:
297: DELETE_CHANGED_ENTITY(p_entity => 'QUOTE',
298: x_errbuf => l_errbuf,

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

291: AS_GAR.LOG(G_ENTITY || G_PR_QUOTE || AS_GAR.G_START);
292: IF P_submit_quote_tap='Y' THEN
293: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_SETAREASIZE || AS_GAR.G_START);
294: AS_GAR.Set_Area_Sizes;
295: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_SETAREASIZE || AS_GAR.G_END);
296:
297: DELETE_CHANGED_ENTITY(p_entity => 'QUOTE',
298: x_errbuf => l_errbuf,
299: x_retcode => l_retcode,

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

314: ELSE
315: l_addl_where := l_Addl_Where || ' and ' ||p_addl_Where;
316: END IF;
317: END IF;
318: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_QUOTE || G_WHERE || l_addl_where);
319: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_QUOTE || AS_GAR.G_START);
320: Process_trans_data(
321: p_trans_id => -1105
322: ,P_addl_where => l_addl_where

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

315: l_addl_where := l_Addl_Where || ' and ' ||p_addl_Where;
316: END IF;
317: END IF;
318: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_QUOTE || G_WHERE || l_addl_where);
319: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_QUOTE || AS_GAR.G_START);
320: Process_trans_data(
321: p_trans_id => -1105
322: ,P_addl_where => l_addl_where
323: ,P_percent_analyzed =>P_perc_analyzed

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

322: ,P_addl_where => l_addl_where
323: ,P_percent_analyzed =>P_perc_analyzed
324: ,P_trace_mode => p_trace
325: ,x_return_status => l_return_status);
326: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_QUOTE || AS_GAR.G_END ||l_return_status);
327: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_QUOTE || AS_GAR.G_RETURN_STATUS || l_return_status);
328: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
329: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_QUOTE, l_errbuf, l_retcode);
330: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

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

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

329: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_QUOTE, l_errbuf, l_retcode);
330: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
331: End If;
332: END IF;
333: AS_GAR.LOG(G_ENTITY || G_PR_QUOTE || AS_GAR.G_END);
334: EXCEPTION
335: WHEN OTHERS THEN
336: AS_GAR.LOG_EXCEPTION(G_ENTITY, SQLERRM, TO_CHAR(SQLCODE));
337: l_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', SQLERRM);

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

332: END IF;
333: AS_GAR.LOG(G_ENTITY || G_PR_QUOTE || AS_GAR.G_END);
334: EXCEPTION
335: WHEN OTHERS THEN
336: AS_GAR.LOG_EXCEPTION(G_ENTITY, SQLERRM, TO_CHAR(SQLCODE));
337: l_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', SQLERRM);
338: END Assign_Quote_Terr_Accesses;
339:
340: PROCEDURE Assign_Proposal_Terr_Accesses(

Line 356: AS_GAR.g_debug_flag := p_debug;

352: l_addl_where VARCHAR2(2000);
353: l_return_status VARCHAR2(10);
354: l_status BOOLEAN;
355: BEGIN
356: AS_GAR.g_debug_flag := p_debug;
357: IF P_trace = 'Y' THEN AS_GAR.SETTRACE; END IF;
358: AS_GAR.LOG(G_ENTITY || G_PR_PROPOSAL || AS_GAR.G_START);
359: IF P_submit_prp_tap = 'Y' THEN
360: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_SETAREASIZE || AS_GAR.G_START);

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

353: l_return_status VARCHAR2(10);
354: l_status BOOLEAN;
355: BEGIN
356: AS_GAR.g_debug_flag := p_debug;
357: IF P_trace = 'Y' THEN AS_GAR.SETTRACE; END IF;
358: AS_GAR.LOG(G_ENTITY || G_PR_PROPOSAL || AS_GAR.G_START);
359: IF P_submit_prp_tap = 'Y' THEN
360: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_SETAREASIZE || AS_GAR.G_START);
361: AS_GAR.Set_Area_Sizes;

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

354: l_status BOOLEAN;
355: BEGIN
356: AS_GAR.g_debug_flag := p_debug;
357: IF P_trace = 'Y' THEN AS_GAR.SETTRACE; END IF;
358: AS_GAR.LOG(G_ENTITY || G_PR_PROPOSAL || AS_GAR.G_START);
359: IF P_submit_prp_tap = 'Y' THEN
360: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_SETAREASIZE || AS_GAR.G_START);
361: AS_GAR.Set_Area_Sizes;
362: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_SETAREASIZE || AS_GAR.G_END);

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

356: AS_GAR.g_debug_flag := p_debug;
357: IF P_trace = 'Y' THEN AS_GAR.SETTRACE; END IF;
358: AS_GAR.LOG(G_ENTITY || G_PR_PROPOSAL || AS_GAR.G_START);
359: IF P_submit_prp_tap = 'Y' THEN
360: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_SETAREASIZE || AS_GAR.G_START);
361: AS_GAR.Set_Area_Sizes;
362: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_SETAREASIZE || AS_GAR.G_END);
363:
364: DELETE_CHANGED_ENTITY(p_entity => 'PROPOSAL',

Line 361: AS_GAR.Set_Area_Sizes;

357: IF P_trace = 'Y' THEN AS_GAR.SETTRACE; END IF;
358: AS_GAR.LOG(G_ENTITY || G_PR_PROPOSAL || AS_GAR.G_START);
359: IF P_submit_prp_tap = 'Y' THEN
360: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_SETAREASIZE || AS_GAR.G_START);
361: AS_GAR.Set_Area_Sizes;
362: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_SETAREASIZE || AS_GAR.G_END);
363:
364: DELETE_CHANGED_ENTITY(p_entity => 'PROPOSAL',
365: x_errbuf => l_errbuf,

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

358: AS_GAR.LOG(G_ENTITY || G_PR_PROPOSAL || AS_GAR.G_START);
359: IF P_submit_prp_tap = 'Y' THEN
360: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_SETAREASIZE || AS_GAR.G_START);
361: AS_GAR.Set_Area_Sizes;
362: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_SETAREASIZE || AS_GAR.G_END);
363:
364: DELETE_CHANGED_ENTITY(p_entity => 'PROPOSAL',
365: x_errbuf => l_errbuf,
366: x_retcode => l_retcode,

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

369:
370: IF p_addl_where IS NOT NULL THEN
371: l_addl_where := 'Where ' || p_addl_Where;
372: END IF;
373: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_PROPOSAL || G_WHERE || l_addl_where);
374: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_PROPOSAL || AS_GAR.G_START);
375: Process_trans_data(
376: p_trans_id => -1106
377: ,P_addl_where => l_addl_where

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

370: IF p_addl_where IS NOT NULL THEN
371: l_addl_where := 'Where ' || p_addl_Where;
372: END IF;
373: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_PROPOSAL || G_WHERE || l_addl_where);
374: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_PROPOSAL || AS_GAR.G_START);
375: Process_trans_data(
376: p_trans_id => -1106
377: ,P_addl_where => l_addl_where
378: ,P_percent_analyzed =>P_perc_analyzed

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

377: ,P_addl_where => l_addl_where
378: ,P_percent_analyzed =>P_perc_analyzed
379: ,P_trace_mode => p_trace
380: ,x_return_status => l_return_status);
381: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_PROPOSAL || AS_GAR.G_END ||l_return_status);
382: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_PROPOSAL || AS_GAR.G_RETURN_STATUS || l_return_status);
383: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
384: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_PROPOSAL, l_errbuf, l_retcode);
385: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

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

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

384: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_PROPOSAL, l_errbuf, l_retcode);
385: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
386: End If;
387: END IF;
388: AS_GAR.LOG(G_ENTITY || G_PR_PROPOSAL || AS_GAR.G_END);
389: EXCEPTION
390: WHEN OTHERS THEN
391: AS_GAR.LOG_EXCEPTION(G_ENTITY, SQLERRM, TO_CHAR(SQLCODE));
392: l_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', SQLERRM);

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

387: END IF;
388: AS_GAR.LOG(G_ENTITY || G_PR_PROPOSAL || AS_GAR.G_END);
389: EXCEPTION
390: WHEN OTHERS THEN
391: AS_GAR.LOG_EXCEPTION(G_ENTITY, SQLERRM, TO_CHAR(SQLCODE));
392: l_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', SQLERRM);
393: END Assign_Proposal_Terr_Accesses;
394:
395: PROCEDURE Process_trans_data

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

414: l_prof_no_of_workers NUMBER;
415: l_entity VARCHAR2(25);
416: BEGIN
417: IF p_trans_id = -1002 THEN
418: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PR_ACCOUNT || AS_GAR.G_START);
419: l_program_name := 'SALES/ACCOUNT PROGRAM';
420: l_con_req_name :='ASXGARAC';
421: l_prof_no_of_workers := fnd_profile.value('AS_TAP_NUM_CHILD_ACCOUNT_WORKERS');
422: l_entity := ': ACCOUNT :';

Line 420: l_con_req_name :='ASXGARAC';

416: BEGIN
417: IF p_trans_id = -1002 THEN
418: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PR_ACCOUNT || AS_GAR.G_START);
419: l_program_name := 'SALES/ACCOUNT PROGRAM';
420: l_con_req_name :='ASXGARAC';
421: l_prof_no_of_workers := fnd_profile.value('AS_TAP_NUM_CHILD_ACCOUNT_WORKERS');
422: l_entity := ': ACCOUNT :';
423: ELSIF p_trans_id = -1003 THEN
424: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PR_LEAD || AS_GAR.G_START);

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

420: l_con_req_name :='ASXGARAC';
421: l_prof_no_of_workers := fnd_profile.value('AS_TAP_NUM_CHILD_ACCOUNT_WORKERS');
422: l_entity := ': ACCOUNT :';
423: ELSIF p_trans_id = -1003 THEN
424: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PR_LEAD || AS_GAR.G_START);
425: l_program_name := 'SALES/LEAD PROGRAM';
426: l_con_req_name :='ASXGARLD';
427: l_prof_no_of_workers := fnd_profile.value('AS_TAP_NUM_CHILD_LEAD_WORKERS');
428: l_entity := ' : LEAD : ';

Line 426: l_con_req_name :='ASXGARLD';

422: l_entity := ': ACCOUNT :';
423: ELSIF p_trans_id = -1003 THEN
424: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PR_LEAD || AS_GAR.G_START);
425: l_program_name := 'SALES/LEAD PROGRAM';
426: l_con_req_name :='ASXGARLD';
427: l_prof_no_of_workers := fnd_profile.value('AS_TAP_NUM_CHILD_LEAD_WORKERS');
428: l_entity := ' : LEAD : ';
429: ELSIF p_trans_id = -1004 THEN
430: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PR_OPPTY || AS_GAR.G_START);

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

426: l_con_req_name :='ASXGARLD';
427: l_prof_no_of_workers := fnd_profile.value('AS_TAP_NUM_CHILD_LEAD_WORKERS');
428: l_entity := ' : LEAD : ';
429: ELSIF p_trans_id = -1004 THEN
430: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PR_OPPTY || AS_GAR.G_START);
431: l_program_name := 'SALES/OPPORTUNITY PROGRAM';
432: l_con_req_name :='ASXGAROP';
433: l_prof_no_of_workers := fnd_profile.value('AS_TAP_NUM_CHILD_OPPOR_WORKERS');
434: l_entity := ' : OPPORTUNITY : ';

Line 432: l_con_req_name :='ASXGAROP';

428: l_entity := ' : LEAD : ';
429: ELSIF p_trans_id = -1004 THEN
430: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PR_OPPTY || AS_GAR.G_START);
431: l_program_name := 'SALES/OPPORTUNITY PROGRAM';
432: l_con_req_name :='ASXGAROP';
433: l_prof_no_of_workers := fnd_profile.value('AS_TAP_NUM_CHILD_OPPOR_WORKERS');
434: l_entity := ' : OPPORTUNITY : ';
435: ELSIF p_trans_id = -1105 THEN
436: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PR_QUOTE || AS_GAR.G_START);

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

432: l_con_req_name :='ASXGAROP';
433: l_prof_no_of_workers := fnd_profile.value('AS_TAP_NUM_CHILD_OPPOR_WORKERS');
434: l_entity := ' : OPPORTUNITY : ';
435: ELSIF p_trans_id = -1105 THEN
436: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PR_QUOTE || AS_GAR.G_START);
437: l_program_name := 'SALES/QUOTE PROGRAM';
438: l_con_req_name :='ASXGARQT';
439: l_prof_no_of_workers := fnd_profile.value('AS_TAP_NUM_CHILD_QUOTE_WORKERS');
440: l_entity := ' : QUOTE : ';

Line 438: l_con_req_name :='ASXGARQT';

434: l_entity := ' : OPPORTUNITY : ';
435: ELSIF p_trans_id = -1105 THEN
436: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PR_QUOTE || AS_GAR.G_START);
437: l_program_name := 'SALES/QUOTE PROGRAM';
438: l_con_req_name :='ASXGARQT';
439: l_prof_no_of_workers := fnd_profile.value('AS_TAP_NUM_CHILD_QUOTE_WORKERS');
440: l_entity := ' : QUOTE : ';
441: ELSIF p_trans_id = -1106 THEN
442: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PR_PROPOSAL || AS_GAR.G_START);

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

438: l_con_req_name :='ASXGARQT';
439: l_prof_no_of_workers := fnd_profile.value('AS_TAP_NUM_CHILD_QUOTE_WORKERS');
440: l_entity := ' : QUOTE : ';
441: ELSIF p_trans_id = -1106 THEN
442: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PR_PROPOSAL || AS_GAR.G_START);
443: l_program_name := 'SALES/PROPOSAL PROGRAM';
444: l_con_req_name :='ASXGARPR';
445: l_prof_no_of_workers := fnd_profile.value('AS_TAP_NUM_CHILD_PROPOSAL_WORKERS');
446: l_entity := ' : PROPOSAL : ';

Line 444: l_con_req_name :='ASXGARPR';

440: l_entity := ' : QUOTE : ';
441: ELSIF p_trans_id = -1106 THEN
442: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PR_PROPOSAL || AS_GAR.G_START);
443: l_program_name := 'SALES/PROPOSAL PROGRAM';
444: l_con_req_name :='ASXGARPR';
445: l_prof_no_of_workers := fnd_profile.value('AS_TAP_NUM_CHILD_PROPOSAL_WORKERS');
446: l_entity := ' : PROPOSAL : ';
447: END IF;
448: IF l_prof_no_of_workers >10 then

Line 451: AS_GAR.LOG(G_ENTITY ||l_entity|| 'No of Workers :'|| l_prof_no_of_workers ||'% Analyzed:'|| P_percent_analyzed);

447: END IF;
448: IF l_prof_no_of_workers >10 then
449: l_prof_no_of_workers := 10;
450: END IF;
451: AS_GAR.LOG(G_ENTITY ||l_entity|| 'No of Workers :'|| l_prof_no_of_workers ||'% Analyzed:'|| P_percent_analyzed);
452: AS_GAR.LOG(G_ENTITY ||l_entity|| 'Additioal Where Clause :'|| P_addl_where);
453: AS_GAR.LOG(G_ENTITY ||l_entity|| AS_GAR.G_CALL_TO || G_PR_TRANS || AS_GAR.G_START);
454: JTY_ASSIGN_BULK_PUB.collect_trans_data (
455: P_api_version_number => 1.0,

Line 452: AS_GAR.LOG(G_ENTITY ||l_entity|| 'Additioal Where Clause :'|| P_addl_where);

448: IF l_prof_no_of_workers >10 then
449: l_prof_no_of_workers := 10;
450: END IF;
451: AS_GAR.LOG(G_ENTITY ||l_entity|| 'No of Workers :'|| l_prof_no_of_workers ||'% Analyzed:'|| P_percent_analyzed);
452: AS_GAR.LOG(G_ENTITY ||l_entity|| 'Additioal Where Clause :'|| P_addl_where);
453: AS_GAR.LOG(G_ENTITY ||l_entity|| AS_GAR.G_CALL_TO || G_PR_TRANS || AS_GAR.G_START);
454: JTY_ASSIGN_BULK_PUB.collect_trans_data (
455: P_api_version_number => 1.0,
456: P_init_msg_list => FND_API.G_FALSE,

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

449: l_prof_no_of_workers := 10;
450: END IF;
451: AS_GAR.LOG(G_ENTITY ||l_entity|| 'No of Workers :'|| l_prof_no_of_workers ||'% Analyzed:'|| P_percent_analyzed);
452: AS_GAR.LOG(G_ENTITY ||l_entity|| 'Additioal Where Clause :'|| P_addl_where);
453: AS_GAR.LOG(G_ENTITY ||l_entity|| AS_GAR.G_CALL_TO || G_PR_TRANS || AS_GAR.G_START);
454: JTY_ASSIGN_BULK_PUB.collect_trans_data (
455: P_api_version_number => 1.0,
456: P_init_msg_list => FND_API.G_FALSE,
457: P_source_id => -1001,

Line 470: AS_GAR.LOG(G_ENTITY ||l_entity || AS_GAR.G_CALL_TO || G_PR_TRANS||l_msg_count||l_msg_data|| AS_GAR.G_END);

466: X_msg_count => l_msg_count,
467: X_msg_data => l_msg_data,
468: Errbuf => l_errbuf,
469: Retcode => l_retcode);
470: AS_GAR.LOG(G_ENTITY ||l_entity || AS_GAR.G_CALL_TO || G_PR_TRANS||l_msg_count||l_msg_data|| AS_GAR.G_END);
471: AS_GAR.LOG(G_ENTITY ||l_entity || AS_GAR.G_CALL_TO || G_PR_TRANS || AS_GAR.G_RETURN_STATUS || l_return_status);
472:
473: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
474: AS_GAR.LOG_EXCEPTION(G_ENTITY ||l_entity || AS_GAR.G_CALL_TO || G_PR_TRANS||l_msg_count||l_msg_data, l_errbuf, l_retcode);

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

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

Line 474: AS_GAR.LOG_EXCEPTION(G_ENTITY ||l_entity || AS_GAR.G_CALL_TO || G_PR_TRANS||l_msg_count||l_msg_data, l_errbuf, l_retcode);

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

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

476: END IF;
477:
478: FOR i in 1..l_prof_no_of_workers
479: LOOP
480: AS_GAR.LOG(G_ENTITY ||l_entity || G_GAR_SUBMIT || AS_GAR.G_START ||' Worker ID : ' || i);
481: l_req_id := FND_REQUEST.SUBMIT_REQUEST('AS',
482: l_con_req_name,
483: '',
484: '',

Line 487: AS_GAR.g_debug_flag,

483: '',
484: '',
485: FALSE,
486: 'TOTAL',
487: AS_GAR.g_debug_flag,
488: P_trace_mode ,
489: i,
490: P_percent_analyzed,
491: CHR(0));

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

489: i,
490: P_percent_analyzed,
491: CHR(0));
492:
493: AS_GAR.LOG(G_ENTITY ||l_entity || G_GAR_SUBMIT || AS_GAR.G_END ||' Request ID : ' || l_req_id);
494: IF l_req_id = 0
495: THEN
496: l_msg_data:=FND_MESSAGE.GET;
497: AS_GAR.LOG(G_ENTITY ||l_entity || G_GAR_SUBMIT || AS_GAR.G_END ||' ERRPR :' || l_msg_data);

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

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

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

500: END LOOP;
501: EXCEPTION
502: WHEN OTHERS THEN
503: x_return_status := FND_API.G_RET_STS_ERROR;
504: AS_GAR.LOG_EXCEPTION(G_ENTITY ||l_entity||G_GAR_SUBMIT, SQLERRM, TO_CHAR(SQLCODE));
505: l_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', SQLERRM);
506: END PROCESS_TRANS_DATA;
507:
508: -------------Modified as per Bug#5027026-----------------

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

561: LOOP --{L1
562: IF (l_limit_flag) THEN EXIT; END IF;
563: l_loop_count := l_loop_count + 1;
564: BEGIN
565: AS_GAR.LOG(G_ENTITY || 'DELETE FROM CHANGED ENTITY::' || p_entity || ': LOOPCOUNT :- ' ||l_loop_count);
566: l_flag := TRUE;
567: l_first := 0;
568: l_last := 0;
569:

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

595: IF l_entity_id.count > 0 THEN --{I1
596: l_flag := TRUE;
597: l_first := l_entity_id.first;
598: l_last := l_first + l_var;
599: AS_GAR.LOG(G_ENTITY || 'DELETE FROM CHANGED ENTITY::' || p_entity || AS_GAR.G_N_ROWS_PROCESSED ||
600: l_entity_id.FIRST || '-' ||
601: l_entity_id.LAST);
602: WHILE l_flag LOOP --{L2 10K cust loop
603: IF l_last > l_entity_id.LAST THEN

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

643: WHEN DEADLOCK_DETECTED THEN
644: BEGIN --{I2
645:
646: ROLLBACK;
647: AS_GAR.LOG('processing Individual Delete');
648: FOR i IN l_first .. l_last LOOP --{L5
649: BEGIN
650: 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);
651: IF p_entity = 'ACCOUNT' THEN

Line 650: 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);

646: ROLLBACK;
647: AS_GAR.LOG('processing Individual Delete');
648: FOR i IN l_first .. l_last LOOP --{L5
649: BEGIN
650: 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);
651: IF p_entity = 'ACCOUNT' THEN
652: DELETE FROM AS_CHANGED_ACCOUNTS_ALL ACC
653: WHERE ACC.customer_id=l_entity_id(i)
654: AND ACC.lead_id IS NULL

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

672: END IF;
673: COMMIT;
674: EXCEPTION
675: WHEN OTHERS THEN
676: AS_GAR.LOG(G_ENTITY || 'DELETE FROM CHANGED ENTITY::' || p_entity || AS_GAR.G_IND_DEL || AS_GAR.G_GENERAL_EXCEPTION);
677: AS_GAR.LOG('ENTITY_ID - ' || l_entity_id(i));
678: END;
679: END LOOP; --}L5
680: COMMIT;

Line 677: AS_GAR.LOG('ENTITY_ID - ' || l_entity_id(i));

673: COMMIT;
674: EXCEPTION
675: WHEN OTHERS THEN
676: AS_GAR.LOG(G_ENTITY || 'DELETE FROM CHANGED ENTITY::' || p_entity || AS_GAR.G_IND_DEL || AS_GAR.G_GENERAL_EXCEPTION);
677: AS_GAR.LOG('ENTITY_ID - ' || l_entity_id(i));
678: END;
679: END LOOP; --}L5
680: COMMIT;
681:

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

681:
682:
683: END; --}I2 end of deadlock exception
684: WHEN OTHERS THEN
685: AS_GAR.LOG_EXCEPTION(G_ENTITY || 'DELETE FROM CHANGED ENTITY::' || p_entity || AS_GAR.G_GENERAL_EXCEPTION, SQLERRM, TO_CHAR(SQLCODE));
686: IF del_acct_changed%ISOPEN THEN CLOSE del_acct_changed; END IF;
687: IF del_lead_changed%ISOPEN THEN CLOSE del_lead_changed; END IF;
688: IF del_oppty_changed%ISOPEN THEN CLOSE del_oppty_changed; END IF;
689:

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

693: x_retcode := SQLCODE;
694: x_return_status := FND_API.G_RET_STS_ERROR;
695: END;
696:
697: AS_GAR.LOG(G_ENTITY || 'DELETE FROM CHANGED ENTITY::' || p_entity || AS_GAR.G_N_ROWS_PROCESSED || l_first || '-' || l_last);
698:
699: l_first := l_last + 1;
700: l_last := l_first + l_var;
701: IF l_first > l_entity_id.LAST THEN

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

702: l_flag := FALSE;
703: END IF;
704: END LOOP; --}L2 while l_flag loop (10K cust loop)
705: END IF;--}I1
706: AS_GAR.LOG(G_ENTITY ||'DELETE FROM CHANGED ENTITY::' || AS_GAR.G_END);
707: COMMIT;
708: EXCEPTION
709: WHEN Others THEN
710: AS_GAR.LOG_EXCEPTION(G_ENTITY || 'DELETE FROM CHANGED ENTITY::' || p_entity || AS_GAR.G_GENERAL_EXCEPTION, SQLERRM, TO_CHAR(SQLCODE));

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

706: AS_GAR.LOG(G_ENTITY ||'DELETE FROM CHANGED ENTITY::' || AS_GAR.G_END);
707: COMMIT;
708: EXCEPTION
709: WHEN Others THEN
710: AS_GAR.LOG_EXCEPTION(G_ENTITY || 'DELETE FROM CHANGED ENTITY::' || p_entity || AS_GAR.G_GENERAL_EXCEPTION, SQLERRM, TO_CHAR(SQLCODE));
711: IF del_acct_changed%ISOPEN THEN CLOSE del_acct_changed; END IF;
712: IF del_lead_changed%ISOPEN THEN CLOSE del_lead_changed; END IF;
713: IF del_oppty_changed%ISOPEN THEN CLOSE del_oppty_changed; END IF;
714: IF del_quote_changed%ISOPEN THEN CLOSE del_quote_changed; END IF;

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

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