DBA Data[Home] [Help]

APPS.IEX_STRY_CHECKLIST_PUB dependencies on IEX_DEBUG_PUB

Line 79: IEX_DEBUG_PUB.LogMessage('PUB:' || G_PKG_NAME || '.' || l_api_name || ' Start');

75: FND_MSG_PUB.initialize;
76: END IF;
77:
78: -- Debug Message
79: IEX_DEBUG_PUB.LogMessage('PUB:' || G_PKG_NAME || '.' || l_api_name || ' Start');
80:
81: -- Debug Message
82: IEX_DEBUG_PUB.LogMessage('1. S.ID= ' || p_StrategyID || ' CLT.ID= ' );
83:

Line 82: IEX_DEBUG_PUB.LogMessage('1. S.ID= ' || p_StrategyID || ' CLT.ID= ' );

78: -- Debug Message
79: IEX_DEBUG_PUB.LogMessage('PUB:' || G_PKG_NAME || '.' || l_api_name || ' Start');
80:
81: -- Debug Message
82: IEX_DEBUG_PUB.LogMessage('1. S.ID= ' || p_StrategyID || ' CLT.ID= ' );
83:
84: -- Debug Message
85: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
86: IEX_DEBUG_PUB.LogMessage(

Line 86: IEX_DEBUG_PUB.LogMessage(

82: IEX_DEBUG_PUB.LogMessage('1. S.ID= ' || p_StrategyID || ' CLT.ID= ' );
83:
84: -- Debug Message
85: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
86: IEX_DEBUG_PUB.LogMessage(
87: debug_msg => 'PUB:' || G_PKG_NAME || '.' || l_api_name || ' Start',
88: print_date => 'Y');
89: END IF;
90:

Line 92: IEX_DEBUG_PUB.LogMessage(

88: print_date => 'Y');
89: END IF;
90:
91: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
92: IEX_DEBUG_PUB.LogMessage(
93: debug_msg => '1. S.ID= ' || p_StrategyID || ' CLT.ID= ',
94: print_date => 'Y');
95: END IF;
96:

Line 102: iex_debug_pub.logmessage( debug_msg => '15. S.ID= ' || p_StrategyID, print_date => 'Y');

98: x_return_status := FND_API.G_RET_STS_SUCCESS;
99:
100: BEGIN
101: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
102: iex_debug_pub.logmessage( debug_msg => '15. S.ID= ' || p_StrategyID, print_date => 'Y');
103: IEX_DEBUG_PUB.LogMessage( debug_msg => c_StrategySelect || ' Start', print_date => 'Y');
104: END IF;
105:
106: Execute Immediate c_StrategySelect into

Line 103: IEX_DEBUG_PUB.LogMessage( debug_msg => c_StrategySelect || ' Start', print_date => 'Y');

99:
100: BEGIN
101: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
102: iex_debug_pub.logmessage( debug_msg => '15. S.ID= ' || p_StrategyID, print_date => 'Y');
103: IEX_DEBUG_PUB.LogMessage( debug_msg => c_StrategySelect || ' Start', print_date => 'Y');
104: END IF;
105:
106: Execute Immediate c_StrategySelect into
107: fDelinquencyID, fObjectID,

Line 121: iex_debug_pub.logmessage( debug_msg => '17. IEX_STRATEGY_NOT_EXISTS', print_date => 'Y');

117: p_token1 => 'STRATEGY_ID ',
118: p_token1_value => to_char(p_StrategyID));
119:
120: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
121: iex_debug_pub.logmessage( debug_msg => '17. IEX_STRATEGY_NOT_EXISTS', print_date => 'Y');
122: END IF;
123: RAISE FND_API.G_EXC_ERROR;
124: return;
125: When OTHERS then

Line 133: iex_debug_pub.logmessage( debug_msg => '18. ERROR: IEX_OTHERS_SQL ', print_date => 'Y');

129: p_msg_name => 'IEX_OTHERS_SQL',
130: p_token1 => 'STRATEGY_ID ',
131: p_token1_value => to_char(p_StrategyID));
132: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
133: iex_debug_pub.logmessage( debug_msg => '18. ERROR: IEX_OTHERS_SQL ', print_date => 'Y');
134: END IF;
135: RAISE FND_API.G_EXC_ERROR;
136: return;
137:

Line 141: IEX_DEBUG_PUB.LogMessage(

137:
138: END;
139:
140: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
141: IEX_DEBUG_PUB.LogMessage(
142: debug_msg => '1. S.ID= ' || p_StrategyID || ' DB. CLT.ID= ' || fCheckListTemplateID,
143: print_date => 'Y');
144: END IF;
145:

Line 154: iex_debug_pub.logmessage( debug_msg => '20. CheckListTemplate Not exists ', print_date => 'Y');

150: p_msg_name => 'IEX_CHECKLIST_NOT_EXIST',
151: p_token1 => 'STRATEGY_ID ',
152: p_token1_value => to_char(p_StrategyID));
153: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
154: iex_debug_pub.logmessage( debug_msg => '20. CheckListTemplate Not exists ', print_date => 'Y');
155: END IF;
156: RAISE FND_API.G_EXC_ERROR;
157: return;
158: end if;

Line 180: iex_debug_pub.logmessage( debug_msg => '2. Create Checklist strategy ', print_date => 'Y');

176: l_strategy_rec.org_id := null;
177: end if;
178:
179: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
180: iex_debug_pub.logmessage( debug_msg => '2. Create Checklist strategy ', print_date => 'Y');
181: END IF;
182:
183: IEX_DEBUG_PUB.LogMessage('2. Create Checklist strategy ');
184:

Line 183: IEX_DEBUG_PUB.LogMessage('2. Create Checklist strategy ');

179: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
180: iex_debug_pub.logmessage( debug_msg => '2. Create Checklist strategy ', print_date => 'Y');
181: END IF;
182:
183: IEX_DEBUG_PUB.LogMessage('2. Create Checklist strategy ');
184:
185: iex_strategy_pvt.create_strategy(
186: P_Api_Version_Number=>2.0,
187: p_commit => FND_API.G_FALSE,

Line 197: iex_debug_pub.logmessage( debug_msg => 'Return status = ' || l_return_status, print_date => 'Y');

193: x_strategy_id => l_strategy_id
194: );
195:
196: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
197: iex_debug_pub.logmessage( debug_msg => 'Return status = ' || l_return_status, print_date => 'Y');
198: END IF;
199: IEX_DEBUG_PUB.LogMessage('Return status = ' || l_return_status);
200: if (x_return_status <> 'S') then
201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 199: IEX_DEBUG_PUB.LogMessage('Return status = ' || l_return_status);

195:
196: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
197: iex_debug_pub.logmessage( debug_msg => 'Return status = ' || l_return_status, print_date => 'Y');
198: END IF;
199: IEX_DEBUG_PUB.LogMessage('Return status = ' || l_return_status);
200: if (x_return_status <> 'S') then
201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
202: end if;
203:

Line 207: iex_debug_pub.logmessage( debug_msg => 'Strategy created. id = ' || l_strategy_id, print_date => 'Y');

203:
204: l_strategy_rec.strategy_id := l_strategy_id;
205:
206: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
207: iex_debug_pub.logmessage( debug_msg => 'Strategy created. id = ' || l_strategy_id, print_date => 'Y');
208: END IF;
209: IEX_DEBUG_PUB.LogMessage('Strategy created. id = ' || l_strategy_id);
210:
211: EXCEPTION

Line 209: IEX_DEBUG_PUB.LogMessage('Strategy created. id = ' || l_strategy_id);

205:
206: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
207: iex_debug_pub.logmessage( debug_msg => 'Strategy created. id = ' || l_strategy_id, print_date => 'Y');
208: END IF;
209: IEX_DEBUG_PUB.LogMessage('Strategy created. id = ' || l_strategy_id);
210:
211: EXCEPTION
212: WHEN OTHERS THEN
213: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 214: iex_debug_pub.logmessage( debug_msg => 'IEX_STRATEGY_CREATE_FAILED', print_date => 'Y');

210:
211: EXCEPTION
212: WHEN OTHERS THEN
213: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
214: iex_debug_pub.logmessage( debug_msg => 'IEX_STRATEGY_CREATE_FAILED', print_date => 'Y');
215: END IF;
216: AS_UTILITY_PVT.Set_Message(
217: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
218: p_msg_name => 'IEX_STRATEGY_CREATE_FAILED',

Line 226: iex_debug_pub.logmessage( debug_msg => '3. Create WorkItems '

222: END;
223:
224:
225: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
226: iex_debug_pub.logmessage( debug_msg => '3. Create WorkItems '
227: || l_strategy_rec.strategy_id, print_date => 'Y');
228: END IF;
229: IEX_DEBUG_PUB.LogMessage('3. Create WorkItems '
230: || l_strategy_rec.strategy_id);

Line 229: IEX_DEBUG_PUB.LogMessage('3. Create WorkItems '

225: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
226: iex_debug_pub.logmessage( debug_msg => '3. Create WorkItems '
227: || l_strategy_rec.strategy_id, print_date => 'Y');
228: END IF;
229: IEX_DEBUG_PUB.LogMessage('3. Create WorkItems '
230: || l_strategy_rec.strategy_id);
231:
232: FOR c_get_witem_rec in c_witems(fCheckListTemplateID ) LOOP
233:

Line 236: iex_debug_pub.logMessage ('create_checklist_strategy: ' || 'work_item_template_id'|| c_get_witem_rec.work_item_template_id);

232: FOR c_get_witem_rec in c_witems(fCheckListTemplateID ) LOOP
233:
234: -- IF PG_DEBUG < 10 THEN
235: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
236: iex_debug_pub.logMessage ('create_checklist_strategy: ' || 'work_item_template_id'|| c_get_witem_rec.work_item_template_id);
237: END IF;
238:
239: l_strategy_work_item_rec.resource_id := 0;
240: l_strategy_work_item_rec.work_item_template_id

Line 252: iex_debug_pub.logmessage ('create_checklist_strategy: ' || 'before calling create_work_pvt.create');

248: l_strategy_work_item_rec.execute_start :=SYSDATE;
249:
250: -- IF PG_DEBUG < 10 THEN
251: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
252: iex_debug_pub.logmessage ('create_checklist_strategy: ' || 'before calling create_work_pvt.create');
253: END IF;
254:
255: iex_strategy_work_items_pvt.create_strategy_work_items
256: (P_Api_Version_Number =>2.0,

Line 268: iex_debug_pub.logmessage ('create_checklist_strategy: ' || 'after calling create_work_pvt.create');

264: x_msg_data =>l_msg_data);
265:
266: -- IF PG_DEBUG < 10 THEN
267: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
268: iex_debug_pub.logmessage ('create_checklist_strategy: ' || 'after calling create_work_pvt.create');
269: END IF;
270: -- IF PG_DEBUG < 10 THEN
271: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
272: iex_debug_pub.logmessage ('create_checklist_strategy: ' || 'and l_return_status from the pvt ='||l_return_status);

Line 272: iex_debug_pub.logmessage ('create_checklist_strategy: ' || 'and l_return_status from the pvt ='||l_return_status);

268: iex_debug_pub.logmessage ('create_checklist_strategy: ' || 'after calling create_work_pvt.create');
269: END IF;
270: -- IF PG_DEBUG < 10 THEN
271: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
272: iex_debug_pub.logmessage ('create_checklist_strategy: ' || 'and l_return_status from the pvt ='||l_return_status);
273: END IF;
274: if (x_return_status <> 'S') then
275: RAISE FND_API.G_EXC_ERROR;
276: end if;

Line 280: IEX_DEBUG_PUB.LogMessage('Return status = ' || l_return_status);

276: end if;
277:
278: END LOOP;
279:
280: IEX_DEBUG_PUB.LogMessage('Return status = ' || l_return_status);
281:
282:
283: l_strategy2_rec.strategy_id := p_StrategyID;
284: l_strategy2_rec.object_version_number := fStrategyVersionNumber;

Line 288: iex_debug_pub.logmessage( debug_msg => '2. Update Main Strategy ', print_date => 'Y');

284: l_strategy2_rec.object_version_number := fStrategyVersionNumber;
285: l_strategy2_rec.checklist_strategy_id := l_strategy_rec.strategy_id;
286:
287: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
288: iex_debug_pub.logmessage( debug_msg => '2. Update Main Strategy ', print_date => 'Y');
289: END IF;
290:
291: IEX_DEBUG_PUB.LogMessage('2. Update Main Strategy ');
292:

Line 291: IEX_DEBUG_PUB.LogMessage('2. Update Main Strategy ');

287: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
288: iex_debug_pub.logmessage( debug_msg => '2. Update Main Strategy ', print_date => 'Y');
289: END IF;
290:
291: IEX_DEBUG_PUB.LogMessage('2. Update Main Strategy ');
292:
293: iex_strategy_pvt.update_strategy(
294: P_Api_Version_Number=>2.0,
295: p_commit => FND_API.G_FALSE,

Line 304: iex_debug_pub.logmessage( debug_msg => 'Return status = ' || l_return_status, print_date => 'Y');

300: x_msg_data=>l_msg_data,
301: xo_object_version_number => l_object_version_number
302: );
303: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
304: iex_debug_pub.logmessage( debug_msg => 'Return status = ' || l_return_status, print_date => 'Y');
305: END IF;
306: IEX_DEBUG_PUB.LogMessage('Return status = ' || l_return_status);
307: if (x_return_status <> 'S') then
308: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 306: IEX_DEBUG_PUB.LogMessage('Return status = ' || l_return_status);

302: );
303: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
304: iex_debug_pub.logmessage( debug_msg => 'Return status = ' || l_return_status, print_date => 'Y');
305: END IF;
306: IEX_DEBUG_PUB.LogMessage('Return status = ' || l_return_status);
307: if (x_return_status <> 'S') then
308: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
309: end if;
310:

Line 322: IEX_DEBUG_PUB.LogMessage('Delinquency cursor ends' );

318: ( p_count => x_msg_count,
319: p_data => x_msg_data
320: );
321:
322: IEX_DEBUG_PUB.LogMessage('Delinquency cursor ends' );
323:
324:
325: EXCEPTION
326: