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

APPS.AS_GAR_OPPTYS_PUB dependencies on AS_GAR

Line 1: PACKAGE BODY AS_GAR_OPPTYS_PUB AS

1: PACKAGE BODY AS_GAR_OPPTYS_PUB AS
2: /* $Header: asxgropb.pls 120.8 2006/02/02 21:29 amagupta noship $ */
3:
4: ---------------------------------------------------------------------------
5: -- Start of Comments

Line 7: -- PACKAGE NAME: AS_GAR_OPPTYS_PUB

3:
4: ---------------------------------------------------------------------------
5: -- Start of Comments
6: ---------------------------------------------------------------------------
7: -- PACKAGE NAME: AS_GAR_OPPTYS_PUB
8: -- ---------------------------------------------------------------------
9: -- PURPOSE
10: -- --------
11: -- This package contains procedures to accomplish each of the following

Line 47: l_terr_globals AS_GAR.TERR_GLOBALS;

43: p_trace_mode IN VARCHAR2,
44: p_worker_id IN VARCHAR2,
45: P_percent_analyzed IN NUMBER )
46: IS
47: l_terr_globals AS_GAR.TERR_GLOBALS;
48: l_msg_count NUMBER;
49: l_msg_data VARCHAR2(2000);
50: l_errbuf VARCHAR2(4000);
51: l_retcode VARCHAR2(255);

Line 58: AS_GAR.G_DEBUG_FLAG := p_debug_mode;

54: l_target_type VARCHAR2(15);
55: l_status BOOLEAN;
56: l_proc VARCHAR2(30):= 'GAR_WRAPPER::';
57: BEGIN
58: AS_GAR.G_DEBUG_FLAG := p_debug_mode;
59: IF p_trace_mode = 'Y' THEN AS_GAR.SETTRACE; END IF;
60: AS_GAR.LOG(G_ENTITY || l_proc || AS_GAR.G_START);
61:
62: IF p_run_mode = AS_GAR.G_TOTAL_MODE THEN

Line 59: IF p_trace_mode = 'Y' THEN AS_GAR.SETTRACE; END IF;

55: l_status BOOLEAN;
56: l_proc VARCHAR2(30):= 'GAR_WRAPPER::';
57: BEGIN
58: AS_GAR.G_DEBUG_FLAG := p_debug_mode;
59: IF p_trace_mode = 'Y' THEN AS_GAR.SETTRACE; END IF;
60: AS_GAR.LOG(G_ENTITY || l_proc || AS_GAR.G_START);
61:
62: IF p_run_mode = AS_GAR.G_TOTAL_MODE THEN
63: l_target_type := 'TOTAL';

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

56: l_proc VARCHAR2(30):= 'GAR_WRAPPER::';
57: BEGIN
58: AS_GAR.G_DEBUG_FLAG := p_debug_mode;
59: IF p_trace_mode = 'Y' THEN AS_GAR.SETTRACE; END IF;
60: AS_GAR.LOG(G_ENTITY || l_proc || AS_GAR.G_START);
61:
62: IF p_run_mode = AS_GAR.G_TOTAL_MODE THEN
63: l_target_type := 'TOTAL';
64: ELSIF p_run_mode = AS_GAR.G_NEW_MODE THEN

Line 62: IF p_run_mode = AS_GAR.G_TOTAL_MODE THEN

58: AS_GAR.G_DEBUG_FLAG := p_debug_mode;
59: IF p_trace_mode = 'Y' THEN AS_GAR.SETTRACE; END IF;
60: AS_GAR.LOG(G_ENTITY || l_proc || AS_GAR.G_START);
61:
62: IF p_run_mode = AS_GAR.G_TOTAL_MODE THEN
63: l_target_type := 'TOTAL';
64: ELSIF p_run_mode = AS_GAR.G_NEW_MODE THEN
65: l_target_type := 'INCREMENTAL';
66: END If;

Line 64: ELSIF p_run_mode = AS_GAR.G_NEW_MODE THEN

60: AS_GAR.LOG(G_ENTITY || l_proc || AS_GAR.G_START);
61:
62: IF p_run_mode = AS_GAR.G_TOTAL_MODE THEN
63: l_target_type := 'TOTAL';
64: ELSIF p_run_mode = AS_GAR.G_NEW_MODE THEN
65: l_target_type := 'INCREMENTAL';
66: END If;
67:
68: -- Set the Global variables

Line 69: AS_GAR.INIT(

65: l_target_type := 'INCREMENTAL';
66: END If;
67:
68: -- Set the Global variables
69: AS_GAR.INIT(
70: p_run_mode,
71: p_worker_id,
72: l_terr_globals);
73:

Line 75: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CW || AS_GAR.G_START);

71: p_worker_id,
72: l_terr_globals);
73:
74: /* This inserts into Oppty winners */
75: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CW || AS_GAR.G_START);
76: JTY_ASSIGN_BULK_PUB.GET_WINNERS
77: ( p_api_version_number => 1.0,
78: p_init_msg_list => FND_API.G_TRUE,
79: p_source_id => -1001,

Line 91: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CW || AS_GAR.G_END);

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

Line 92: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CW || AS_GAR.G_RETURN_STATUS || l_return_status);

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

Line 95: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CW, l_errbuf, l_retcode);

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

Line 102: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CEX_GROUPS || AS_GAR.G_START);

98:
99: COMMIT;
100:
101: -- Explode GROUPS if any inside winners
102: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CEX_GROUPS || AS_GAR.G_START);
103: AS_GAR_OPPTYS_PUB.EXPLODE_GROUPS_OPPTYS(
104: x_errbuf => l_errbuf,
105: x_retcode => l_retcode,
106: p_terr_globals => l_terr_globals,

Line 103: AS_GAR_OPPTYS_PUB.EXPLODE_GROUPS_OPPTYS(

99: COMMIT;
100:
101: -- Explode GROUPS if any inside winners
102: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CEX_GROUPS || AS_GAR.G_START);
103: AS_GAR_OPPTYS_PUB.EXPLODE_GROUPS_OPPTYS(
104: x_errbuf => l_errbuf,
105: x_retcode => l_retcode,
106: p_terr_globals => l_terr_globals,
107: x_return_status => l_return_status);

Line 109: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CEX_GROUPS || AS_GAR.G_END);

105: x_retcode => l_retcode,
106: p_terr_globals => l_terr_globals,
107: x_return_status => l_return_status);
108:
109: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CEX_GROUPS || AS_GAR.G_END);
110: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CEX_GROUPS || AS_GAR.G_RETURN_STATUS || l_return_status);
111:
112: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
113: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CEX_GROUPS, l_errbuf, l_retcode);

Line 110: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CEX_GROUPS || AS_GAR.G_RETURN_STATUS || l_return_status);

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

Line 113: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CEX_GROUPS, l_errbuf, l_retcode);

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

Line 120: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CEX_TEAMS || AS_GAR.G_START);

116:
117: COMMIT;
118:
119: -- Explode TEAMS if any inside winners
120: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CEX_TEAMS || AS_GAR.G_START);
121: AS_GAR_OPPTYS_PUB.EXPLODE_TEAMS_OPPTYS(
122: x_errbuf => l_errbuf,
123: x_retcode => l_retcode,
124: p_terr_globals => l_terr_globals,

Line 121: AS_GAR_OPPTYS_PUB.EXPLODE_TEAMS_OPPTYS(

117: COMMIT;
118:
119: -- Explode TEAMS if any inside winners
120: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CEX_TEAMS || AS_GAR.G_START);
121: AS_GAR_OPPTYS_PUB.EXPLODE_TEAMS_OPPTYS(
122: x_errbuf => l_errbuf,
123: x_retcode => l_retcode,
124: p_terr_globals => l_terr_globals,
125: x_return_status => l_return_status);

Line 127: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CEX_TEAMS || AS_GAR.G_END);

123: x_retcode => l_retcode,
124: p_terr_globals => l_terr_globals,
125: x_return_status => l_return_status);
126:
127: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CEX_TEAMS || AS_GAR.G_END);
128: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CEX_TEAMS || AS_GAR.G_RETURN_STATUS || l_return_status);
129:
130: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
131: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CEX_TEAMS, l_errbuf, l_retcode);

Line 128: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CEX_TEAMS || AS_GAR.G_RETURN_STATUS || l_return_status);

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

Line 131: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CEX_TEAMS, l_errbuf, l_retcode);

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

Line 138: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_STLEAD || AS_GAR.G_START);

134:
135: COMMIT;
136:
137: -- Set team leader for Opptys
138: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_STLEAD || AS_GAR.G_START);
139: AS_GAR_OPPTYS_PUB.SET_TEAM_LEAD_OPPTYS(
140: x_errbuf => l_errbuf,
141: x_retcode => l_retcode,
142: p_terr_globals => l_terr_globals,

Line 139: AS_GAR_OPPTYS_PUB.SET_TEAM_LEAD_OPPTYS(

135: COMMIT;
136:
137: -- Set team leader for Opptys
138: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_STLEAD || AS_GAR.G_START);
139: AS_GAR_OPPTYS_PUB.SET_TEAM_LEAD_OPPTYS(
140: x_errbuf => l_errbuf,
141: x_retcode => l_retcode,
142: p_terr_globals => l_terr_globals,
143: x_return_status => l_return_status);

Line 145: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_STLEAD || AS_GAR.G_END);

141: x_retcode => l_retcode,
142: p_terr_globals => l_terr_globals,
143: x_return_status => l_return_status);
144:
145: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_STLEAD || AS_GAR.G_END);
146: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_STLEAD || AS_GAR.G_RETURN_STATUS || l_return_status);
147:
148: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
149: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_STLEAD, l_errbuf, l_retcode);

Line 146: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_STLEAD || AS_GAR.G_RETURN_STATUS || l_return_status);

142: p_terr_globals => l_terr_globals,
143: x_return_status => l_return_status);
144:
145: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_STLEAD || AS_GAR.G_END);
146: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_STLEAD || AS_GAR.G_RETURN_STATUS || l_return_status);
147:
148: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
149: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_STLEAD, l_errbuf, l_retcode);
150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 149: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_STLEAD, l_errbuf, l_retcode);

145: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_STLEAD || AS_GAR.G_END);
146: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_STLEAD || AS_GAR.G_RETURN_STATUS || l_return_status);
147:
148: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
149: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_STLEAD, l_errbuf, l_retcode);
150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
151: End If;
152:
153: -- Insert into Oppty Accesses from Winners

Line 154: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSACC || AS_GAR.G_START);

150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
151: End If;
152:
153: -- Insert into Oppty Accesses from Winners
154: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSACC || AS_GAR.G_START);
155: AS_GAR_OPPTYS_PUB.INSERT_ACCESSES_OPPTYS(
156: x_errbuf => l_errbuf,
157: x_retcode => l_retcode,
158: p_terr_globals => l_terr_globals,

Line 155: AS_GAR_OPPTYS_PUB.INSERT_ACCESSES_OPPTYS(

151: End If;
152:
153: -- Insert into Oppty Accesses from Winners
154: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSACC || AS_GAR.G_START);
155: AS_GAR_OPPTYS_PUB.INSERT_ACCESSES_OPPTYS(
156: x_errbuf => l_errbuf,
157: x_retcode => l_retcode,
158: p_terr_globals => l_terr_globals,
159: x_return_status => l_return_status);

Line 161: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSACC || AS_GAR.G_END);

157: x_retcode => l_retcode,
158: p_terr_globals => l_terr_globals,
159: x_return_status => l_return_status);
160:
161: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSACC || AS_GAR.G_END);
162: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSACC || AS_GAR.G_RETURN_STATUS || l_return_status);
163:
164: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
165: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSACC, l_errbuf, l_retcode);

Line 162: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSACC || AS_GAR.G_RETURN_STATUS || l_return_status);

158: p_terr_globals => l_terr_globals,
159: x_return_status => l_return_status);
160:
161: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSACC || AS_GAR.G_END);
162: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSACC || AS_GAR.G_RETURN_STATUS || l_return_status);
163:
164: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
165: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSACC, l_errbuf, l_retcode);
166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 165: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSACC, l_errbuf, l_retcode);

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

Line 170: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSTERRACC || AS_GAR.G_START);

166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
167: End If;
168:
169: -- Insert into territory Accesses
170: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSTERRACC || AS_GAR.G_START);
171: AS_GAR_OPPTYS_PUB.INSERT_TERR_ACCESSES_OPPTYS(
172: x_errbuf => l_errbuf,
173: x_retcode => l_retcode,
174: p_terr_globals => l_terr_globals,

Line 171: AS_GAR_OPPTYS_PUB.INSERT_TERR_ACCESSES_OPPTYS(

167: End If;
168:
169: -- Insert into territory Accesses
170: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSTERRACC || AS_GAR.G_START);
171: AS_GAR_OPPTYS_PUB.INSERT_TERR_ACCESSES_OPPTYS(
172: x_errbuf => l_errbuf,
173: x_retcode => l_retcode,
174: p_terr_globals => l_terr_globals,
175: x_return_status => l_return_status);

Line 177: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSTERRACC || AS_GAR.G_END);

173: x_retcode => l_retcode,
174: p_terr_globals => l_terr_globals,
175: x_return_status => l_return_status);
176:
177: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSTERRACC || AS_GAR.G_END);
178: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSTERRACC || AS_GAR.G_RETURN_STATUS || l_return_status);
179:
180: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
181: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSTERRACC, l_errbuf, l_retcode);

Line 178: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSTERRACC || AS_GAR.G_RETURN_STATUS || l_return_status);

174: p_terr_globals => l_terr_globals,
175: x_return_status => l_return_status);
176:
177: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSTERRACC || AS_GAR.G_END);
178: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSTERRACC || AS_GAR.G_RETURN_STATUS || l_return_status);
179:
180: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
181: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSTERRACC, l_errbuf, l_retcode);
182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 181: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_INSTERRACC, l_errbuf, l_retcode);

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

Line 186: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CC || AS_GAR.G_START);

182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
183: End If;
184:
185: -- Remove (soft delete) records in access table that are not qualified
186: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CC || AS_GAR.G_START);
187: AS_GAR_OPPTYS_PUB.PERFORM_OPPTY_CLEANUP(
188: x_errbuf => l_errbuf,
189: x_retcode => l_retcode,
190: p_terr_globals => l_terr_globals,

Line 187: AS_GAR_OPPTYS_PUB.PERFORM_OPPTY_CLEANUP(

183: End If;
184:
185: -- Remove (soft delete) records in access table that are not qualified
186: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CC || AS_GAR.G_START);
187: AS_GAR_OPPTYS_PUB.PERFORM_OPPTY_CLEANUP(
188: x_errbuf => l_errbuf,
189: x_retcode => l_retcode,
190: p_terr_globals => l_terr_globals,
191: x_return_status => l_return_status);

Line 193: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CC || AS_GAR.G_END);

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

Line 194: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CC || AS_GAR.G_RETURN_STATUS || l_return_status);

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

Line 197: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CC, l_errbuf, l_retcode);

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

Line 202: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CO || AS_GAR.G_START);

198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
199: End If;
200:
201: -- Opportunity Owner assignment
202: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CO || AS_GAR.G_START);
203: /* ----------------------------------------------------------------------+
204: | G_TAP_FLAG is set to avoid calling the leads buid trigger .
205: +------------------------------------------------------------------------*/
206: AS_GAR.G_TAP_FLAG := 'Y';

Line 206: AS_GAR.G_TAP_FLAG := 'Y';

202: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CO || AS_GAR.G_START);
203: /* ----------------------------------------------------------------------+
204: | G_TAP_FLAG is set to avoid calling the leads buid trigger .
205: +------------------------------------------------------------------------*/
206: AS_GAR.G_TAP_FLAG := 'Y';
207: AS_GAR_OPPTYS_PUB.ASSIGN_OPPTY_OWNER(
208: x_errbuf => l_errbuf,
209: x_retcode => l_retcode,
210: p_terr_globals => l_terr_globals,

Line 207: AS_GAR_OPPTYS_PUB.ASSIGN_OPPTY_OWNER(

203: /* ----------------------------------------------------------------------+
204: | G_TAP_FLAG is set to avoid calling the leads buid trigger .
205: +------------------------------------------------------------------------*/
206: AS_GAR.G_TAP_FLAG := 'Y';
207: AS_GAR_OPPTYS_PUB.ASSIGN_OPPTY_OWNER(
208: x_errbuf => l_errbuf,
209: x_retcode => l_retcode,
210: p_terr_globals => l_terr_globals,
211: x_return_status => l_return_status);

Line 212: AS_GAR.G_TAP_FLAG := 'N';

208: x_errbuf => l_errbuf,
209: x_retcode => l_retcode,
210: p_terr_globals => l_terr_globals,
211: x_return_status => l_return_status);
212: AS_GAR.G_TAP_FLAG := 'N';
213: /* ----------------------------------------------------------------------+
214: | G_TAP_FLAG is reset.
215: +------------------------------------------------------------------------*/
216: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CO || AS_GAR.G_END);

Line 216: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CO || AS_GAR.G_END);

212: AS_GAR.G_TAP_FLAG := 'N';
213: /* ----------------------------------------------------------------------+
214: | G_TAP_FLAG is reset.
215: +------------------------------------------------------------------------*/
216: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CO || AS_GAR.G_END);
217: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CO || AS_GAR.G_RETURN_STATUS || l_return_status);
218:
219: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
220: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CO, l_errbuf, l_retcode);

Line 217: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CO || AS_GAR.G_RETURN_STATUS || l_return_status);

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

Line 220: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || AS_GAR.G_CO, l_errbuf, l_retcode);

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

Line 226: l_sub_exist := AS_GAR.exist_subscription(G_BUSINESS_EVENT);

222: End If;
223:
224: -- BES enhancement
225:
226: l_sub_exist := AS_GAR.exist_subscription(G_BUSINESS_EVENT);
227: IF l_sub_exist = 'Y' THEN
228: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CBE_EXISTS);
229: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CBE_RAISE);
230: AS_GAR.Raise_BE(l_terr_globals);

Line 228: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CBE_EXISTS);

224: -- BES enhancement
225:
226: l_sub_exist := AS_GAR.exist_subscription(G_BUSINESS_EVENT);
227: IF l_sub_exist = 'Y' THEN
228: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CBE_EXISTS);
229: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CBE_RAISE);
230: AS_GAR.Raise_BE(l_terr_globals);
231: END If;
232:

Line 229: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CBE_RAISE);

225:
226: l_sub_exist := AS_GAR.exist_subscription(G_BUSINESS_EVENT);
227: IF l_sub_exist = 'Y' THEN
228: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CBE_EXISTS);
229: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CBE_RAISE);
230: AS_GAR.Raise_BE(l_terr_globals);
231: END If;
232:
233: AS_GAR.LOG(G_ENTITY || l_proc || AS_GAR.G_END);

Line 230: AS_GAR.Raise_BE(l_terr_globals);

226: l_sub_exist := AS_GAR.exist_subscription(G_BUSINESS_EVENT);
227: IF l_sub_exist = 'Y' THEN
228: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CBE_EXISTS);
229: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CBE_RAISE);
230: AS_GAR.Raise_BE(l_terr_globals);
231: END If;
232:
233: AS_GAR.LOG(G_ENTITY || l_proc || AS_GAR.G_END);
234: EXCEPTION

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

229: AS_GAR.LOG(G_ENTITY || AS_GAR.G_CBE_RAISE);
230: AS_GAR.Raise_BE(l_terr_globals);
231: END If;
232:
233: AS_GAR.LOG(G_ENTITY || l_proc || AS_GAR.G_END);
234: EXCEPTION
235: WHEN OTHERS THEN
236: AS_GAR.LOG_EXCEPTION(G_ENTITY, SQLERRM, TO_CHAR(SQLCODE));
237: l_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', SQLERRM);

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

232:
233: AS_GAR.LOG(G_ENTITY || l_proc || AS_GAR.G_END);
234: EXCEPTION
235: WHEN OTHERS THEN
236: AS_GAR.LOG_EXCEPTION(G_ENTITY, SQLERRM, TO_CHAR(SQLCODE));
237: l_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', SQLERRM);
238: END GAR_WRAPPER;
239:
240: /************************** End GAR Wrapper *****************************/

Line 246: p_terr_globals IN AS_GAR.TERR_GLOBALS,

242: /************************** Start Explode Teams Opptys ******************/
243: PROCEDURE EXPLODE_TEAMS_OPPTYS(
244: x_errbuf OUT NOCOPY VARCHAR2,
245: x_retcode OUT NOCOPY VARCHAR2,
246: p_terr_globals IN AS_GAR.TERR_GLOBALS,
247: x_return_status OUT NOCOPY VARCHAR2)
248: IS
249:
250: /*-------------------------------------------------------------------------+

Line 294: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_TEAMS || AS_GAR.G_START);

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

Line 310: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_TEAMS || AS_GAR.G_N_ROWS_PROCESSED || l_res_type_count);

306: FETCH c_get_res_type_count INTO l_res_type_count;
307: CLOSE c_get_res_type_count;
308: END IF;
309:
310: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_TEAMS || AS_GAR.G_N_ROWS_PROCESSED || l_res_type_count);
311: IF l_res_type_count > 0 THEN
312: /* Get resources within a resource team */
313: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_TEAMS || AS_GAR.G_INS_WINNERS || AS_GAR.G_START);
314: /** Note

Line 313: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_TEAMS || AS_GAR.G_INS_WINNERS || AS_GAR.G_START);

309:
310: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_TEAMS || AS_GAR.G_N_ROWS_PROCESSED || l_res_type_count);
311: IF l_res_type_count > 0 THEN
312: /* Get resources within a resource team */
313: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_TEAMS || AS_GAR.G_INS_WINNERS || AS_GAR.G_START);
314: /** Note
315: Hard coding RS_EMPLOYEE INSTEAD OF resource_category IN following SQL
316: because JTA returns RS_EMPLOYEE AND NOT EMPLOYEE
317: **/

Line 497: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_TEAMS || AS_GAR.G_INS_WINNERS || AS_GAR.G_N_ROWS_PROCESSED || SQL%ROWCOUNT);

493: AND rt1.worker_id = t.worker_id
494: AND rt1.trans_object_id = t.trans_object_id
495: AND NVL(rt1.trans_detail_object_id,-1) = NVL(t.trans_detail_object_id,-1));
496:
497: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_TEAMS || AS_GAR.G_INS_WINNERS || AS_GAR.G_N_ROWS_PROCESSED || SQL%ROWCOUNT);
498: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_TEAMS || AS_GAR.G_INS_WINNERS || AS_GAR.G_END);
499:
500:
501: COMMIT;

Line 498: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_TEAMS || AS_GAR.G_INS_WINNERS || AS_GAR.G_END);

494: AND rt1.trans_object_id = t.trans_object_id
495: AND NVL(rt1.trans_detail_object_id,-1) = NVL(t.trans_detail_object_id,-1));
496:
497: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_TEAMS || AS_GAR.G_INS_WINNERS || AS_GAR.G_N_ROWS_PROCESSED || SQL%ROWCOUNT);
498: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_TEAMS || AS_GAR.G_INS_WINNERS || AS_GAR.G_END);
499:
500:
501: COMMIT;
502:

Line 506: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_TEAMS, SQLERRM, TO_CHAR(SQLCODE));

502:
503: END IF; /* if l_res_type_count > 0 */
504: EXCEPTION
505: WHEN others THEN
506: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_TEAMS, SQLERRM, TO_CHAR(SQLCODE));
507: x_errbuf := SQLERRM;
508: x_retcode := SQLCODE;
509: x_return_status := FND_API.G_RET_STS_ERROR;
510: RAISE;

Line 518: p_terr_globals IN AS_GAR.TERR_GLOBALS,

514: /************************** Start Explode Groups Opptys ******************/
515: PROCEDURE EXPLODE_GROUPS_OPPTYS(
516: x_errbuf OUT NOCOPY VARCHAR2,
517: x_retcode OUT NOCOPY VARCHAR2,
518: p_terr_globals IN AS_GAR.TERR_GLOBALS,
519: x_return_status OUT NOCOPY VARCHAR2)
520: IS
521: -------------RS_GROUP---------
522: /*-------------------------------------------------------------------------+

Line 574: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_GROUPS || AS_GAR.G_N_ROWS_PROCESSED || l_res_type_count);

570: FETCH c_get_res_type_count INTO l_res_type_count;
571: CLOSE c_get_res_type_count;
572: END IF;
573:
574: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_GROUPS || AS_GAR.G_N_ROWS_PROCESSED || l_res_type_count);
575: IF l_res_type_count > 0 THEN
576: /* Get resources within a resource group */
577: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_GROUPS || AS_GAR.G_INS_WINNERS || AS_GAR.G_START);
578: /** Note

Line 577: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_GROUPS || AS_GAR.G_INS_WINNERS || AS_GAR.G_START);

573:
574: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_GROUPS || AS_GAR.G_N_ROWS_PROCESSED || l_res_type_count);
575: IF l_res_type_count > 0 THEN
576: /* Get resources within a resource group */
577: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_GROUPS || AS_GAR.G_INS_WINNERS || AS_GAR.G_START);
578: /** Note
579: Hard coding RS_EMPLOYEE INSTEAD OF resource_category IN following SQL
580: because JTA returns RS_EMPLOYEE AND NOT EMPLOYEE
581: **/

Line 679: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_GROUPS || AS_GAR.G_INS_WINNERS || AS_GAR.G_N_ROWS_PROCESSED || SQL%ROWCOUNT);

675: AND rt1.worker_id = t.worker_id
676: AND rt1.trans_object_id = t.trans_object_id
677: AND NVL(rt1.trans_detail_object_id,-1) = NVL(t.trans_detail_object_id,-1));
678:
679: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_GROUPS || AS_GAR.G_INS_WINNERS || AS_GAR.G_N_ROWS_PROCESSED || SQL%ROWCOUNT);
680: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_GROUPS || AS_GAR.G_INS_WINNERS || AS_GAR.G_END);
681:
682: COMMIT;
683: END IF; /* if l_res_type_count > 0 */

Line 680: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_GROUPS || AS_GAR.G_INS_WINNERS || AS_GAR.G_END);

676: AND rt1.trans_object_id = t.trans_object_id
677: AND NVL(rt1.trans_detail_object_id,-1) = NVL(t.trans_detail_object_id,-1));
678:
679: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_GROUPS || AS_GAR.G_INS_WINNERS || AS_GAR.G_N_ROWS_PROCESSED || SQL%ROWCOUNT);
680: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_GROUPS || AS_GAR.G_INS_WINNERS || AS_GAR.G_END);
681:
682: COMMIT;
683: END IF; /* if l_res_type_count > 0 */
684:

Line 687: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_GROUPS, SQLERRM, TO_CHAR(SQLCODE));

683: END IF; /* if l_res_type_count > 0 */
684:
685: EXCEPTION
686: WHEN OTHERS THEN
687: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CEX_GROUPS, SQLERRM, TO_CHAR(SQLCODE));
688: x_errbuf := SQLERRM;
689: x_retcode := SQLCODE;
690: x_return_status := FND_API.G_RET_STS_ERROR;
691: RAISE;

Line 716: p_terr_globals IN AS_GAR.TERR_GLOBALS,

712:
713: PROCEDURE SET_TEAM_LEAD_OPPTYS(
714: x_errbuf OUT NOCOPY VARCHAR2,
715: x_retcode OUT NOCOPY VARCHAR2,
716: p_terr_globals IN AS_GAR.TERR_GLOBALS,
717: x_return_status OUT NOCOPY VARCHAR2)
718: IS
719:
720: TYPE num_list is TABLE of NUMBER INDEX BY BINARY_INTEGER;

Line 760: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_STLEAD || AS_GAR.G_START);

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

Line 773: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_STLEAD || 'LOOPCOUNT :- ' || l_loop_count);

769: l_salesforce_id.DELETE;
770: l_sales_group_id.DELETE;
771:
772: l_loop_count := l_loop_count + 1;
773: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_STLEAD || 'LOOPCOUNT :- ' || l_loop_count);
774:
775: --------------------------------
776: OPEN team_leader(l_worker_id);
777: FETCH team_leader BULK COLLECT INTO

Line 791: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_STLEAD || AS_GAR.G_BULK_UPD || AS_GAR.G_START);

787:
788: IF l_lead_id.COUNT < l_max_fetches THEN
789: l_limit_flag := TRUE;
790: END IF;
791: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_STLEAD || AS_GAR.G_BULK_UPD || AS_GAR.G_START);
792:
793: IF l_lead_id.COUNT > 0 THEN
794: l_flag := TRUE;
795: l_first := l_lead_id.FIRST;

Line 821: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS ||AS_GAR.G_STLEAD || AS_GAR.G_BULK_UPD || AS_GAR.G_N_ROWS_PROCESSED || l_first || '-'|| l_last);

817: AND ACC.salesforce_id = l_salesforce_id(i)
818: AND ACC.sales_group_id = l_sales_group_id(i);
819: COMMIT;
820: l_attempts := 3;
821: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS ||AS_GAR.G_STLEAD || AS_GAR.G_BULK_UPD || AS_GAR.G_N_ROWS_PROCESSED || l_first || '-'|| l_last);
822: EXCEPTION
823: WHEN DEADLOCK_DETECTED THEN
824: BEGIN
825: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_STLEAD || AS_GAR.G_DEADLOCK ||l_attempts);

Line 825: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_STLEAD || AS_GAR.G_DEADLOCK ||l_attempts);

821: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS ||AS_GAR.G_STLEAD || AS_GAR.G_BULK_UPD || AS_GAR.G_N_ROWS_PROCESSED || l_first || '-'|| l_last);
822: EXCEPTION
823: WHEN DEADLOCK_DETECTED THEN
824: BEGIN
825: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_STLEAD || AS_GAR.G_DEADLOCK ||l_attempts);
826: ROLLBACK;
827: l_attempts := l_attempts +1;
828: IF l_attempts = 3 THEN
829: FOR i IN l_first .. l_last

Line 849: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_STLEAD || AS_GAR.G_IND_UPD || AS_GAR.G_GENERAL_EXCEPTION);

845: AND ACC.salesforce_id = l_salesforce_id(i)
846: AND ACC.sales_group_id = l_sales_group_id(i);
847: EXCEPTION
848: WHEN OTHERS THEN
849: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_STLEAD || AS_GAR.G_IND_UPD || AS_GAR.G_GENERAL_EXCEPTION);
850: AS_GAR.LOG('LEAD_ID/SALESFORCE_ID/SALESGROUP_ID/ORG_ID - ' || l_lead_id(i) || '/' || l_salesforce_id(i) || '/' || l_sales_group_id(i));
851: END;
852: END LOOP; -- for each record individually
853: COMMIT;

Line 850: AS_GAR.LOG('LEAD_ID/SALESFORCE_ID/SALESGROUP_ID/ORG_ID - ' || l_lead_id(i) || '/' || l_salesforce_id(i) || '/' || l_sales_group_id(i));

846: AND ACC.sales_group_id = l_sales_group_id(i);
847: EXCEPTION
848: WHEN OTHERS THEN
849: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_STLEAD || AS_GAR.G_IND_UPD || AS_GAR.G_GENERAL_EXCEPTION);
850: AS_GAR.LOG('LEAD_ID/SALESFORCE_ID/SALESGROUP_ID/ORG_ID - ' || l_lead_id(i) || '/' || l_salesforce_id(i) || '/' || l_sales_group_id(i));
851: END;
852: END LOOP; -- for each record individually
853: COMMIT;
854: END IF;

Line 857: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_STLEAD || AS_GAR.G_BULK_UPD, SQLERRM, TO_CHAR(SQLCODE));

853: COMMIT;
854: END IF;
855: END; -- end of deadlock exception
856: WHEN OTHERS THEN
857: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_STLEAD || AS_GAR.G_BULK_UPD, SQLERRM, TO_CHAR(SQLCODE));
858: x_errbuf := SQLERRM;
859: x_retcode := SQLCODE;
860: x_return_status := FND_API.G_RET_STS_ERROR;
861: RAISE;

Line 872: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_STLEAD || AS_GAR.G_END);

868: l_flag := FALSE;
869: END IF;
870: END LOOP; -- loop for more records within the bulk_size
871: END IF; --l_lead_id.count > 0
872: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_STLEAD || AS_GAR.G_END);
873: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_STLEAD || AS_GAR.G_N_ROWS_PROCESSED || l_lead_id.COUNT);
874: END LOOP; -- loop for more bulk_size fetches
875: l_lead_id.DELETE;
876: l_salesforce_id.DELETE;

Line 873: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_STLEAD || AS_GAR.G_N_ROWS_PROCESSED || l_lead_id.COUNT);

869: END IF;
870: END LOOP; -- loop for more records within the bulk_size
871: END IF; --l_lead_id.count > 0
872: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_STLEAD || AS_GAR.G_END);
873: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_STLEAD || AS_GAR.G_N_ROWS_PROCESSED || l_lead_id.COUNT);
874: END LOOP; -- loop for more bulk_size fetches
875: l_lead_id.DELETE;
876: l_salesforce_id.DELETE;
877: l_sales_group_id.DELETE;

Line 880: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_STLEAD, SQLERRM, TO_CHAR(SQLCODE));

876: l_salesforce_id.DELETE;
877: l_sales_group_id.DELETE;
878: EXCEPTION
879: WHEN OTHERS THEN
880: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_STLEAD, SQLERRM, TO_CHAR(SQLCODE));
881: x_errbuf := SQLERRM;
882: x_retcode := SQLCODE;
883: x_return_status := FND_API.G_RET_STS_ERROR;
884: RAISE;

Line 894: p_terr_globals IN AS_GAR.TERR_GLOBALS,

890:
891: PROCEDURE INSERT_ACCESSES_OPPTYS(
892: x_errbuf OUT NOCOPY VARCHAR2,
893: x_retcode OUT NOCOPY VARCHAR2,
894: p_terr_globals IN AS_GAR.TERR_GLOBALS,
895: x_return_status OUT NOCOPY VARCHAR2)
896: IS
897: TYPE num_list is TABLE of NUMBER INDEX BY BINARY_INTEGER;
898: TYPE faf_list is TABLE of VARCHAR2(1) INDEX BY BINARY_INTEGER;

Line 945: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSACC || AS_GAR.G_START);

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

Line 963: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSACC || 'LOOPCOUNT :- ' || l_loop_count);

959:
960: EXIT WHEN ins_acc%NOTFOUND;
961:
962: l_loop_count := l_loop_count + 1;
963: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSACC || 'LOOPCOUNT :- ' || l_loop_count);
964:
965: FETCH ins_acc BULK COLLECT INTO
966: l_salesforce_id, l_sales_group_id, l_person_id,
967: l_lead_id,l_faf,l_org_id

Line 988: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSACC || AS_GAR.G_BULK_INS || AS_GAR.G_N_ROWS_PROCESSED ||l_first||' to '||l_last);

984: IF l_last > l_lead_id.LAST THEN
985: l_last := l_lead_id.LAST;
986: END IF;
987: BEGIN
988: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSACC || AS_GAR.G_BULK_INS || AS_GAR.G_N_ROWS_PROCESSED ||l_first||' to '||l_last);
989: FORALL i IN l_first .. l_last
990: INSERT INTO AS_ACCESSES_ALL_ALL
991: ( access_id
992: ,access_type

Line 1054: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSACC || AS_GAR.G_BULK_INS || AS_GAR.G_N_ROWS_PROCESSED || SQL%ROWCOUNT);

1050: AND AA.salesforce_id = l_salesforce_id(i)
1051: AND AA.sales_group_id = l_sales_group_id(i)
1052: )
1053: );
1054: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSACC || AS_GAR.G_BULK_INS || AS_GAR.G_N_ROWS_PROCESSED || SQL%ROWCOUNT);
1055: COMMIT;
1056: EXCEPTION
1057: WHEN DUP_VAL_ON_INDEX THEN
1058: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSACC || AS_GAR.G_IND_INS || AS_GAR.G_N_ROWS_PROCESSED ||l_first||' - '||l_last);

Line 1058: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSACC || AS_GAR.G_IND_INS || AS_GAR.G_N_ROWS_PROCESSED ||l_first||' - '||l_last);

1054: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSACC || AS_GAR.G_BULK_INS || AS_GAR.G_N_ROWS_PROCESSED || SQL%ROWCOUNT);
1055: COMMIT;
1056: EXCEPTION
1057: WHEN DUP_VAL_ON_INDEX THEN
1058: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSACC || AS_GAR.G_IND_INS || AS_GAR.G_N_ROWS_PROCESSED ||l_first||' - '||l_last);
1059: FOR i IN l_first .. l_last LOOP
1060: BEGIN
1061: INSERT INTO AS_ACCESSES_ALL_ALL
1062: ( access_id

Line 1132: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSACC || AS_GAR.G_BULK_INS, SQLERRM, TO_CHAR(SQLCODE));

1128: END;
1129: END LOOP; /* loop for DUP_VAL_ON_INDEX individual insert */
1130: COMMIT;
1131: WHEN OTHERS THEN
1132: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSACC || AS_GAR.G_BULK_INS, SQLERRM, TO_CHAR(SQLCODE));
1133: x_errbuf := SQLERRM;
1134: x_retcode := SQLCODE;
1135: x_return_status := FND_API.G_RET_STS_ERROR;
1136: RAISE;

Line 1156: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSACC, SQLERRM, TO_CHAR(SQLCODE));

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

Line 1171: p_terr_globals IN AS_GAR.TERR_GLOBALS,

1167:
1168: PROCEDURE INSERT_TERR_ACCESSES_OPPTYS(
1169: x_errbuf OUT NOCOPY VARCHAR2,
1170: x_retcode OUT NOCOPY VARCHAR2,
1171: p_terr_globals IN AS_GAR.TERR_GLOBALS,
1172: x_return_status OUT NOCOPY VARCHAR2)
1173: IS
1174: TYPE num_list IS TABLE of NUMBER INDEX BY BINARY_INTEGER;
1175:

Line 1216: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC || AS_GAR.G_START);

1212: | Almost the same as accesses, except the insertion is into as_territory_accesses
1213: | and there is no involvement of role.
1214: |
1215: +-------------------------------------------------------------------------*/
1216: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC || AS_GAR.G_START);
1217: x_return_status := FND_API.G_RET_STS_SUCCESS;
1218: l_worker_id := p_terr_globals.worker_id;
1219: l_var := p_terr_globals.bulk_size;
1220: OPEN ins_tacc(l_worker_id);

Line 1229: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC || 'LOOPCOUNT :- ' || l_loop_count);

1225: l_lead_id.DELETE;
1226: l_salesforce_id.DELETE;
1227: l_sales_group_id.DELETE;
1228: l_terr_id.DELETE;
1229: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC || 'LOOPCOUNT :- ' || l_loop_count);
1230: BEGIN
1231:
1232: FETCH ins_tacc BULK COLLECT INTO l_terr_id,
1233: l_lead_id, l_salesforce_id, l_sales_group_id

Line 1250: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC || AS_GAR.G_BULK_INS || AS_GAR.G_N_ROWS_PROCESSED ||l_first||' - '||l_last);

1246: IF l_last > l_lead_id.LAST THEN
1247: l_last := l_lead_id.LAST;
1248: END IF;
1249: BEGIN
1250: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC || AS_GAR.G_BULK_INS || AS_GAR.G_N_ROWS_PROCESSED ||l_first||' - '||l_last);
1251: FORALL i IN l_first .. l_last
1252: INSERT INTO AS_TERRITORY_ACCESSES
1253: ( access_id,
1254: territory_id,

Line 1296: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC || AS_GAR.G_BULK_INS || AS_GAR.G_N_ROWS_PROCESSED || SQL%ROWCOUNT);

1292: WHERE AST.access_id = A.access_id
1293: AND AST.territory_id = l_terr_id(i))
1294: ) V
1295: );
1296: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC || AS_GAR.G_BULK_INS || AS_GAR.G_N_ROWS_PROCESSED || SQL%ROWCOUNT);
1297: COMMIT;
1298: EXCEPTION
1299: WHEN DUP_VAL_ON_INDEX THEN
1300: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC || AS_GAR.G_IND_INS || AS_GAR.G_N_ROWS_PROCESSED ||l_first||' - '||l_last);

Line 1300: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC || AS_GAR.G_IND_INS || AS_GAR.G_N_ROWS_PROCESSED ||l_first||' - '||l_last);

1296: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC || AS_GAR.G_BULK_INS || AS_GAR.G_N_ROWS_PROCESSED || SQL%ROWCOUNT);
1297: COMMIT;
1298: EXCEPTION
1299: WHEN DUP_VAL_ON_INDEX THEN
1300: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC || AS_GAR.G_IND_INS || AS_GAR.G_N_ROWS_PROCESSED ||l_first||' - '||l_last);
1301: FOR i IN l_first .. l_last LOOP
1302: BEGIN
1303: INSERT INTO AS_TERRITORY_ACCESSES
1304: ( access_id,

Line 1352: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC || AS_GAR.G_IND_INS || AS_GAR.G_N_ROWS_PROCESSED || SQL%ROWCOUNT);

1348: WHEN Others THEN
1349: NULL;
1350: END;
1351: END LOOP;
1352: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC || AS_GAR.G_IND_INS || AS_GAR.G_N_ROWS_PROCESSED || SQL%ROWCOUNT);
1353: COMMIT;
1354: WHEN Others THEN
1355: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC || AS_GAR.G_BULK_INS, SQLERRM, TO_CHAR(SQLCODE));
1356: x_errbuf := SQLERRM;

Line 1355: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC || AS_GAR.G_BULK_INS, SQLERRM, TO_CHAR(SQLCODE));

1351: END LOOP;
1352: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC || AS_GAR.G_IND_INS || AS_GAR.G_N_ROWS_PROCESSED || SQL%ROWCOUNT);
1353: COMMIT;
1354: WHEN Others THEN
1355: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC || AS_GAR.G_BULK_INS, SQLERRM, TO_CHAR(SQLCODE));
1356: x_errbuf := SQLERRM;
1357: x_retcode := SQLCODE;
1358: x_return_status := FND_API.G_RET_STS_ERROR;
1359: IF ins_tacc%ISOPEN THEN CLOSE ins_tacc; END IF;

Line 1371: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC , SQLERRM, TO_CHAR(SQLCODE));

1367: END LOOP;
1368: END IF; --l_lead_id.COUNT > 0
1369: EXCEPTION
1370: WHEN Others THEN
1371: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC , SQLERRM, TO_CHAR(SQLCODE));
1372: IF ins_tacc%ISOPEN THEN CLOSE ins_tacc; END IF;
1373: x_errbuf := SQLERRM;
1374: x_retcode := SQLCODE;
1375: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1384: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC || AS_GAR.G_END);

1380: l_salesforce_id.DELETE;
1381: l_sales_group_id.DELETE;
1382: l_terr_id.DELETE;
1383: IF ins_tacc%ISOPEN THEN CLOSE ins_tacc; END IF;
1384: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC || AS_GAR.G_END);
1385: EXCEPTION
1386: WHEN others THEN
1387: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC, SQLERRM, TO_CHAR(SQLCODE));
1388: x_errbuf := SQLERRM;

Line 1387: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC, SQLERRM, TO_CHAR(SQLCODE));

1383: IF ins_tacc%ISOPEN THEN CLOSE ins_tacc; END IF;
1384: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC || AS_GAR.G_END);
1385: EXCEPTION
1386: WHEN others THEN
1387: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSTERRACC, SQLERRM, TO_CHAR(SQLCODE));
1388: x_errbuf := SQLERRM;
1389: x_retcode := SQLCODE;
1390: x_return_status := FND_API.G_RET_STS_ERROR;
1391: IF ins_tacc%ISOPEN THEN CLOSE ins_tacc; END IF;

Line 1403: p_terr_globals IN AS_GAR.TERR_GLOBALS,

1399:
1400: PROCEDURE Perform_Oppty_Cleanup(
1401: x_errbuf OUT NOCOPY VARCHAR2,
1402: x_retcode OUT NOCOPY VARCHAR2,
1403: p_terr_globals IN AS_GAR.TERR_GLOBALS,
1404: x_return_status OUT NOCOPY VARCHAR2)
1405: IS
1406:
1407: TYPE num_list is TABLE of NUMBER INDEX BY BINARY_INTEGER;

Line 1440: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_START);

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

Line 1446: IF p_terr_globals.run_mode = AS_GAR.G_TOTAL_MODE THEN

1442: l_worker_id := p_terr_globals.worker_id;
1443: l_var := p_terr_globals.bulk_size;
1444: l_max_fetches := p_terr_globals.cursor_limit;
1445:
1446: IF p_terr_globals.run_mode = AS_GAR.G_TOTAL_MODE THEN
1447: OPEN del_oppty_totalmode(l_worker_id);
1448: ELSE
1449: OPEN del_oppty_newmode(l_worker_id);
1450: END IF;

Line 1455: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || 'LOOPCOUNT :- ' ||l_loop_count);

1451: LOOP --{L1
1452: IF (l_limit_flag) THEN EXIT; END IF;
1453:
1454: l_loop_count := l_loop_count + 1;
1455: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || 'LOOPCOUNT :- ' ||l_loop_count);
1456: BEGIN
1457: IF p_terr_globals.run_mode = AS_GAR.G_TOTAL_MODE THEN
1458: EXIT WHEN del_oppty_totalmode%NOTFOUND;
1459: FETCH del_oppty_totalmode BULK COLLECT INTO l_lead_id

Line 1457: IF p_terr_globals.run_mode = AS_GAR.G_TOTAL_MODE THEN

1453:
1454: l_loop_count := l_loop_count + 1;
1455: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || 'LOOPCOUNT :- ' ||l_loop_count);
1456: BEGIN
1457: IF p_terr_globals.run_mode = AS_GAR.G_TOTAL_MODE THEN
1458: EXIT WHEN del_oppty_totalmode%NOTFOUND;
1459: FETCH del_oppty_totalmode BULK COLLECT INTO l_lead_id
1460: LIMIT l_max_fetches;
1461: ELSE

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

1472: IF l_lead_id.COUNT < l_max_fetches THEN
1473: l_limit_flag := TRUE;
1474: END IF;
1475:
1476: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_UPD_ACCESSES || AS_GAR.G_START);
1477: IF l_lead_id.count > 0 THEN --{I1
1478: l_flag := TRUE;
1479: l_first := l_lead_id.FIRST;
1480: l_last := l_first + l_var;

Line 1481: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_UPD_ACCESSES || AS_GAR.G_N_ROWS_PROCESSED ||

1477: IF l_lead_id.count > 0 THEN --{I1
1478: l_flag := TRUE;
1479: l_first := l_lead_id.FIRST;
1480: l_last := l_first + l_var;
1481: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_UPD_ACCESSES || AS_GAR.G_N_ROWS_PROCESSED ||
1482: l_lead_id.FIRST || '-' ||
1483: l_lead_id.LAST);
1484: WHILE l_flag LOOP --{L2 10K cust loop
1485: IF l_last > l_lead_id.LAST THEN

Line 1495: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_UPD_ACCESSES || AS_GAR.G_BULK_UPD || AS_GAR.G_START);

1491: IF (l_del_flag) THEN EXIT; END IF;
1492: l_del_flag := FALSE;
1493: WHILE l_attempts < 3 LOOP --{L4
1494: BEGIN
1495: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_UPD_ACCESSES || AS_GAR.G_BULK_UPD || AS_GAR.G_START);
1496: FORALL i in l_first..l_last
1497: UPDATE AS_ACCESSES_ALL_ALL ACC
1498: SET object_version_number = NVL(object_version_number,0) + 1, ACC.DELETE_FLAG='Y'
1499: WHERE ACC.lead_id=l_lead_id(i)

Line 1521: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_UPD_ACCESSES || AS_GAR.G_BULK_DEL || AS_GAR.G_START);

1517: IF l_access_id.COUNT < G_NUM_REC THEN l_del_flag := TRUE; END IF;
1518: EXCEPTION
1519: WHEN DUP_VAL_ON_INDEX THEN
1520: BEGIN
1521: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_UPD_ACCESSES || AS_GAR.G_BULK_DEL || AS_GAR.G_START);
1522: FORALL i in l_first..l_last
1523: DELETE FROM AS_ACCESSES_ALL_ALL ACC
1524: WHERE ACC.lead_id=l_lead_id(i)
1525: AND ACC.freeze_flag = 'N'

Line 1544: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_UPD_ACCESSES || AS_GAR.G_BULK_DEL, SQLERRM, TO_CHAR(SQLCODE));

1540: l_attempts := 3;
1541: IF l_access_id.COUNT < G_NUM_REC THEN l_del_flag := TRUE; END IF;
1542: EXCEPTION
1543: WHEN OTHERS THEN
1544: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_UPD_ACCESSES || AS_GAR.G_BULK_DEL, SQLERRM, TO_CHAR(SQLCODE));
1545: END;
1546: WHEN deadlock_detected THEN
1547: BEGIN --{I2
1548: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_UPD_ACCESSES || AS_GAR.G_BULK_UPD || AS_GAR.G_DEADLOCK || l_attempts);

Line 1548: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_UPD_ACCESSES || AS_GAR.G_BULK_UPD || AS_GAR.G_DEADLOCK || l_attempts);

1544: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_UPD_ACCESSES || AS_GAR.G_BULK_DEL, SQLERRM, TO_CHAR(SQLCODE));
1545: END;
1546: WHEN deadlock_detected THEN
1547: BEGIN --{I2
1548: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_UPD_ACCESSES || AS_GAR.G_BULK_UPD || AS_GAR.G_DEADLOCK || l_attempts);
1549: ROLLBACK;
1550: l_attempts := l_attempts +1;
1551: IF l_attempts = 3 THEN
1552: FOR i IN l_first .. l_last LOOP --{L5

Line 1554: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_UPD_ACCESSES || AS_GAR.G_IND_UPD || AS_GAR.G_START);

1550: l_attempts := l_attempts +1;
1551: IF l_attempts = 3 THEN
1552: FOR i IN l_first .. l_last LOOP --{L5
1553: BEGIN
1554: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_UPD_ACCESSES || AS_GAR.G_IND_UPD || AS_GAR.G_START);
1555: UPDATE AS_ACCESSES_ALL_ALL ACC
1556: SET object_version_number = nvl(object_version_number,0) + 1, ACC.DELETE_FLAG='Y'
1557: WHERE ACC.lead_id = l_lead_id(i)
1558: AND ACC.freeze_flag = 'N'

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

1572: COMMIT;
1573: EXCEPTION
1574: WHEN DUP_VAL_ON_INDEX THEN
1575: BEGIN
1576: 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);
1577: DELETE FROM AS_ACCESSES_ALL_ALL ACC
1578: WHERE ACC.lead_id=l_lead_id(i)
1579: AND ACC.freeze_flag = 'N'
1580: AND ACC.lead_id IS NOT NULL

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

1590: AND SCR.SALESFORCE_ID = ACC.SALESFORCE_ID
1591: AND SCR.SALESGROUP_ID = ACC.SALES_GROUP_ID );
1592: EXCEPTION
1593: WHEN OTHERS THEN
1594: 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_GENERAL_EXCEPTION);
1595: AS_GAR.LOG('OPPTY_ID - ' || l_lead_id(i));
1596: END;
1597: END;
1598: END LOOP; --}L5

Line 1595: AS_GAR.LOG('OPPTY_ID - ' || l_lead_id(i));

1591: AND SCR.SALESGROUP_ID = ACC.SALES_GROUP_ID );
1592: EXCEPTION
1593: WHEN OTHERS THEN
1594: 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_GENERAL_EXCEPTION);
1595: AS_GAR.LOG('OPPTY_ID - ' || l_lead_id(i));
1596: END;
1597: END;
1598: END LOOP; --}L5
1599: COMMIT;

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

1600: l_del_flag := TRUE;
1601: END IF;
1602: END; --}I2 end of deadlock exception
1603: WHEN OTHERS THEN
1604: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_GENERAL_EXCEPTION, SQLERRM, TO_CHAR(SQLCODE));
1605: IF del_oppty_totalmode%ISOPEN THEN CLOSE del_oppty_totalmode; END IF;
1606: IF del_oppty_newmode%ISOPEN THEN CLOSE del_oppty_newmode; END IF;
1607: x_errbuf := SQLERRM;
1608: x_retcode := SQLCODE;

Line 1613: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_UPD_ACCESSES || AS_GAR.G_N_ROWS_PROCESSED || l_first || '-' || l_last);

1609: x_return_status := FND_API.G_RET_STS_ERROR;
1610: RAISE;
1611: END;
1612: END LOOP; --}L4 l_attempts loop 3 trys
1613: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_UPD_ACCESSES || AS_GAR.G_N_ROWS_PROCESSED || l_first || '-' || l_last);
1614: END LOOP; --}L3 -- to update only 10k record at a time on accesses
1615: l_first := l_last + 1;
1616: l_last := l_first + l_var;
1617: IF l_first > l_lead_id.LAST THEN

Line 1622: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_END);

1618: l_flag := FALSE;
1619: END IF;
1620: END LOOP; --}L2 while l_flag loop (10K cust loop)
1621: END IF;--}I1
1622: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_END);
1623: COMMIT;
1624: EXCEPTION
1625: WHEN Others THEN
1626: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_GENERAL_EXCEPTION, SQLERRM, TO_CHAR(SQLCODE));

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

1622: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_END);
1623: COMMIT;
1624: EXCEPTION
1625: WHEN Others THEN
1626: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_GENERAL_EXCEPTION, SQLERRM, TO_CHAR(SQLCODE));
1627: IF del_oppty_totalmode%ISOPEN THEN CLOSE del_oppty_totalmode; END IF;
1628: IF del_oppty_newmode%ISOPEN THEN CLOSE del_oppty_newmode; END IF;
1629: x_errbuf := SQLERRM;
1630: x_retcode := SQLCODE;

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

1635: IF del_oppty_totalmode%ISOPEN THEN CLOSE del_oppty_totalmode; END IF;
1636: IF del_oppty_newmode%ISOPEN THEN CLOSE del_oppty_newmode; END IF;
1637: EXCEPTION
1638: WHEN OTHERS THEN
1639: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_GENERAL_EXCEPTION, SQLERRM, TO_CHAR(SQLCODE));
1640: x_errbuf := SQLERRM;
1641: x_retcode := SQLCODE;
1642: x_return_status := FND_API.G_RET_STS_ERROR;
1643: RAISE;

Line 1651: p_terr_globals IN AS_GAR.TERR_GLOBALS,

1647: /**************************** Start Assign Oppty Owner ********************/
1648: PROCEDURE ASSIGN_OPPTY_OWNER(
1649: x_errbuf OUT NOCOPY VARCHAR2,
1650: x_retcode OUT NOCOPY VARCHAR2,
1651: p_terr_globals IN AS_GAR.TERR_GLOBALS,
1652: x_return_status OUT NOCOPY VARCHAR2)
1653: IS
1654: l_return_status VARCHAR2(1);
1655: l_msg_count NUMBER;

Line 1735: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || AS_GAR.G_START);

1731:
1732:
1733:
1734: BEGIN
1735: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || AS_GAR.G_START);
1736:
1737: x_return_status := FND_API.G_RET_STS_SUCCESS;
1738: l_worker_id:=p_terr_globals.worker_id;
1739: l_var :=p_terr_globals.bulk_size;

Line 1744: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'CUSTOM AS PER PROFILE---AS_LEAD_ASSIGNMENT_UHK:- Y---');

1740: l_max_fetches := p_terr_globals.cursor_limit;
1741: l_call_pre_uhk := JTF_USR_HKS.Ok_to_execute('AS_TERR_OPPTY_ASSIGNMENT','Assign_Oppty_Owner','B','C');
1742: IF l_call_pre_uhk
1743: THEN
1744: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'CUSTOM AS PER PROFILE---AS_LEAD_ASSIGNMENT_UHK:- Y---');
1745: AS_CUSTOM_HOOKS_UHK.Oppty_TOTTAP_Owner_Assignment(
1746: p_api_version_number => 2.0,
1747: p_init_msg_list => FND_API.G_FALSE,
1748: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 1760: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'LOOPCOUNT:- '|| l_loop_count);

1756: ELSE
1757: LOOP
1758: IF (l_limit_flag) THEN EXIT; END IF;
1759: l_loop_count := l_loop_count + 1;
1760: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'LOOPCOUNT:- '|| l_loop_count);
1761: IF p_terr_globals.run_mode = AS_GAR.G_TOTAL_MODE THEN
1762: OPEN oppty_owner_totalmode(l_worker_id);
1763: FETCH oppty_owner_totalmode BULK COLLECT INTO l_lead_id,l_access_id LIMIT l_max_fetches;
1764: CLOSE oppty_owner_totalmode;

Line 1761: IF p_terr_globals.run_mode = AS_GAR.G_TOTAL_MODE THEN

1757: LOOP
1758: IF (l_limit_flag) THEN EXIT; END IF;
1759: l_loop_count := l_loop_count + 1;
1760: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'LOOPCOUNT:- '|| l_loop_count);
1761: IF p_terr_globals.run_mode = AS_GAR.G_TOTAL_MODE THEN
1762: OPEN oppty_owner_totalmode(l_worker_id);
1763: FETCH oppty_owner_totalmode BULK COLLECT INTO l_lead_id,l_access_id LIMIT l_max_fetches;
1764: CLOSE oppty_owner_totalmode;
1765: ELSE

Line 1788: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'UPDATE AS_LEADS_ALL');

1784: IF l_last > l_lead_id.LAST THEN
1785: l_last := l_lead_id.LAST;
1786: END IF;
1787: WHILE l_attempts < 3 LOOP
1788: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'UPDATE AS_LEADS_ALL');
1789: BEGIN
1790: FORALL i in l_first .. l_last
1791: UPDATE AS_LEADS_ALL sl
1792: SET sl.object_version_number = nvl(sl.object_version_number,0) + 1,

Line 1810: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || AS_GAR.G_N_ROWS_PROCESSED || l_first || ' - '|| l_last);

1806: )
1807: WHERE sl.lead_id = l_lead_id(i) ;
1808: COMMIT;
1809: l_attempts := 3;
1810: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || AS_GAR.G_N_ROWS_PROCESSED || l_first || ' - '|| l_last);
1811: EXCEPTION
1812: WHEN deadlock_detected THEN
1813: BEGIN
1814: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || AS_GAR.G_DEADLOCK ||l_attempts);

Line 1814: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || AS_GAR.G_DEADLOCK ||l_attempts);

1810: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || AS_GAR.G_N_ROWS_PROCESSED || l_first || ' - '|| l_last);
1811: EXCEPTION
1812: WHEN deadlock_detected THEN
1813: BEGIN
1814: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || AS_GAR.G_DEADLOCK ||l_attempts);
1815: ROLLBACK;
1816: l_attempts := l_attempts +1;
1817: IF l_attempts = 3 THEN
1818: FOR i IN l_first .. l_last LOOP

Line 1839: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'ROW-BY-ROW UPDATE OF OPPTYS', SQLERRM, TO_CHAR(SQLCODE));

1835: )
1836: WHERE sl.lead_id = l_lead_id(i) ;
1837: EXCEPTION
1838: WHEN OTHERS THEN
1839: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'ROW-BY-ROW UPDATE OF OPPTYS', SQLERRM, TO_CHAR(SQLCODE));
1840: END;
1841: END LOOP;
1842: COMMIT;
1843: END IF;

Line 1846: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'UPDATE AS_LEADS', SQLERRM, TO_CHAR(SQLCODE));

1842: COMMIT;
1843: END IF;
1844: END; -- end of deadlock exception
1845: WHEN OTHERS THEN
1846: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'UPDATE AS_LEADS', SQLERRM, TO_CHAR(SQLCODE));
1847: x_errbuf := SQLERRM;
1848: x_retcode := SQLCODE;
1849: x_return_status := FND_API.G_RET_STS_ERROR;
1850: RAISE;

Line 1853: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'UPDATE AS_SALES_CREDITS_DENORM');

1849: x_return_status := FND_API.G_RET_STS_ERROR;
1850: RAISE;
1851: END;
1852: END LOOP;
1853: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'UPDATE AS_SALES_CREDITS_DENORM');
1854: WHILE l_attempts < 3 LOOP
1855: BEGIN
1856: FORALL i in l_first .. l_last
1857: UPDATE AS_SALES_CREDITS_DENORM scd

Line 1876: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || AS_GAR.G_N_ROWS_PROCESSED || l_first || ' - '|| l_last);

1872: )
1873: WHERE scd.lead_id = l_lead_id(i) ;
1874: COMMIT;
1875: l_attempts := 3;
1876: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || AS_GAR.G_N_ROWS_PROCESSED || l_first || ' - '|| l_last);
1877: EXCEPTION
1878: WHEN deadlock_detected THEN
1879: BEGIN
1880: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || AS_GAR.G_DEADLOCK ||l_attempts);

Line 1880: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || AS_GAR.G_DEADLOCK ||l_attempts);

1876: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || AS_GAR.G_N_ROWS_PROCESSED || l_first || ' - '|| l_last);
1877: EXCEPTION
1878: WHEN deadlock_detected THEN
1879: BEGIN
1880: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || AS_GAR.G_DEADLOCK ||l_attempts);
1881: ROLLBACK;
1882: l_attempts := l_attempts +1;
1883: IF l_attempts = 3 THEN
1884: FOR i IN l_first .. l_last LOOP

Line 1905: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'ROW-BY-ROW UPDATE OF SALES CREDITS DENORM', SQLERRM, TO_CHAR(SQLCODE));

1901: )
1902: WHERE scd.lead_id = l_lead_id(i) ;
1903: EXCEPTION
1904: WHEN OTHERS THEN
1905: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'ROW-BY-ROW UPDATE OF SALES CREDITS DENORM', SQLERRM, TO_CHAR(SQLCODE));
1906: END;
1907: END LOOP;
1908: COMMIT;
1909: END IF;

Line 1912: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'UPDATE AS_SALES_CREDITS_DENORM', SQLERRM, TO_CHAR(SQLCODE));

1908: COMMIT;
1909: END IF;
1910: END; -- end of deadlock exception
1911: WHEN OTHERS THEN
1912: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'UPDATE AS_SALES_CREDITS_DENORM', SQLERRM, TO_CHAR(SQLCODE));
1913: x_errbuf := SQLERRM;
1914: x_retcode := SQLCODE;
1915: x_return_status := FND_API.G_RET_STS_ERROR;
1916: RAISE;

Line 1919: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'UPDATE AS_ACCESSES');

1915: x_return_status := FND_API.G_RET_STS_ERROR;
1916: RAISE;
1917: END;
1918: END LOOP;
1919: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'UPDATE AS_ACCESSES');
1920: l_attempts := 1;
1921: WHILE l_attempts < 3 LOOP
1922: BEGIN
1923: FORALL i in l_first .. l_last

Line 1936: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'UPDATE AS_ACCESSES::' || AS_GAR.G_N_ROWS_PROCESSED || l_first || ' - '|| l_last);

1932: ACC.owner_flag = 'Y'
1933: WHERE ACC.access_id = l_access_id(i);
1934: COMMIT;
1935: l_attempts := 3;
1936: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'UPDATE AS_ACCESSES::' || AS_GAR.G_N_ROWS_PROCESSED || l_first || ' - '|| l_last);
1937: EXCEPTION
1938: WHEN deadlock_detected THEN
1939: BEGIN
1940: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'UPDATE AS_ACCESSES::' || AS_GAR.G_DEADLOCK ||l_attempts );

Line 1940: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'UPDATE AS_ACCESSES::' || AS_GAR.G_DEADLOCK ||l_attempts );

1936: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'UPDATE AS_ACCESSES::' || AS_GAR.G_N_ROWS_PROCESSED || l_first || ' - '|| l_last);
1937: EXCEPTION
1938: WHEN deadlock_detected THEN
1939: BEGIN
1940: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'UPDATE AS_ACCESSES::' || AS_GAR.G_DEADLOCK ||l_attempts );
1941: l_attempts := l_attempts +1;
1942: ROLLBACK;
1943: IF l_attempts = 3 THEN
1944: FOR i IN l_first .. l_last LOOP

Line 1958: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'ROW-BY-ROW UPDATE OF SALES LEADS ACCESSES', SQLERRM, TO_CHAR(SQLCODE));

1954: ACC.owner_flag = 'Y'
1955: WHERE ACC.access_id = l_access_id(i);
1956: EXCEPTION
1957: WHEN OTHERS THEN
1958: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'ROW-BY-ROW UPDATE OF SALES LEADS ACCESSES', SQLERRM, TO_CHAR(SQLCODE));
1959: END;
1960: END LOOP;
1961: COMMIT;
1962: END IF;

Line 1965: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'UPDATE SALES_LEADS ACCESSES', SQLERRM, TO_CHAR(SQLCODE));

1961: COMMIT;
1962: END IF;
1963: END; -- end of deadlock exception
1964: WHEN OTHERS THEN
1965: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || 'UPDATE SALES_LEADS ACCESSES', SQLERRM, TO_CHAR(SQLCODE));
1966: x_errbuf := SQLERRM;
1967: x_retcode := SQLCODE;
1968: x_return_status := FND_API.G_RET_STS_ERROR;
1969: RAISE;

Line 1979: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || AS_GAR.G_N_ROWS_PROCESSED || l_lead_id.COUNT);

1975: l_flag := FALSE;
1976: END IF;
1977: END LOOP;
1978: END IF; --l_lead_id.count > 0
1979: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || AS_GAR.G_N_ROWS_PROCESSED || l_lead_id.COUNT);
1980: END LOOP;
1981: l_limit_flag := FALSE;
1982: l_loop_count := 0;
1983: l_access_id.delete;

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

1986: END IF; -- (Custom or Non Custom)
1987:
1988: EXCEPTION
1989: WHEN OTHERS THEN
1990: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CO || AS_GAR.G_GENERAL_EXCEPTION, SQLERRM, TO_CHAR(SQLCODE));
1991: x_errbuf := SQLERRM;
1992: x_retcode := SQLCODE;
1993: x_return_status := FND_API.G_RET_STS_ERROR;
1994: RAISE;

Line 2001: END AS_GAR_OPPTYS_PUB;

1997: /**************************** End Assign Lead Owner ********************/
1998:
1999:
2000:
2001: END AS_GAR_OPPTYS_PUB;
2002: