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.IEX_STRY_API_PUB dependencies on IEX_DEBUG_PUB

Line 136: IEX_DEBUG_PUB.logmessage('REASSIGN_STRATEGY: ' || 'AFTER SEND SIGNAL');

132: status => p_status ) ;
133:
134: -- IF PG_DEBUG < 10 THEN
135: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
136: IEX_DEBUG_PUB.logmessage('REASSIGN_STRATEGY: ' || 'AFTER SEND SIGNAL');
137: END IF;
138:
139: OPEN c_status(p_strategy_id);
140: FETCH c_status INTO l_status;

Line 146: IEX_DEBUG_PUB.logmessage('REASSIGN_STRATEGY: ' || 'After Send Signal and it successfull ');

142:
143: if ( l_status = 'CANCELLED' ) then
144: -- IF PG_DEBUG < 10 THEN
145: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
146: IEX_DEBUG_PUB.logmessage('REASSIGN_STRATEGY: ' || 'After Send Signal and it successfull ');
147: END IF;
148: OPEN c_object(p_strategy_id);
149: FETCH c_object INTO l_delinquency_id,l_object_id,l_object_type;
150: CLOSE c_object;

Line 154: IEX_DEBUG_PUB.logmessage('REASSIGN_STRATEGY: ' || 'IEXSTTAB-Delinquency id'||

150: CLOSE c_object;
151:
152: -- IF PG_DEBUG < 10 THEN
153: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
154: IEX_DEBUG_PUB.logmessage('REASSIGN_STRATEGY: ' || 'IEXSTTAB-Delinquency id'||
155: 'before calling create strategy is '
156: ||l_delinquency_id||
157: ' object_id is '||l_object_id ||
158: ' object_type is' || l_object_type );

Line 163: IEX_DEBUG_PUB.logmessage('REASSIGN_STRATEGY: ' || 'BEFORE CALLING CREATE_STRATEGY ');

159: END IF;
160:
161: -- IF PG_DEBUG < 10 THEN
162: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
163: IEX_DEBUG_PUB.logmessage('REASSIGN_STRATEGY: ' || 'BEFORE CALLING CREATE_STRATEGY ');
164: END IF;
165:
166: IEX_STRATEGY_PUB.CREATE_STRATEGY
167: (p_api_version_number => 2.0,

Line 181: iex_debug_pub.logmessage('REASSIGN_STRATEGY: ' || 'status of create strategy ' ||l_return_status);

177: p_strategy_temp_id => p_strategy_temp_id) ;
178:
179: -- IF PG_DEBUG < 10 THEN
180: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
181: iex_debug_pub.logmessage('REASSIGN_STRATEGY: ' || 'status of create strategy ' ||l_return_status);
182: END IF;
183:
184: x_msg_count :=l_msg_count;
185: x_msg_data :=l_msg_data;

Line 204: IEX_DEBUG_PUB.logmessage('REASSIGN_STRATEGY: ' || 'inexception of reassign strategy '||sqlerrm);

200: WHEN OTHERS THEN
201: ROLLBACK TO REASSIGN_STRATEGY_PUB;
202: -- IF PG_DEBUG < 10 THEN
203: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
204: IEX_DEBUG_PUB.logmessage('REASSIGN_STRATEGY: ' || 'inexception of reassign strategy '||sqlerrm);
205: END IF;
206: END REASSIGN_STRATEGY;
207:
208: --Start bug 6794510 gnramasa 5th Feb 08

Line 236: IEX_DEBUG_PUB.logmessage('ASSIGN_STRATEGY: ' || 'IEXSTTAB-Delinquency id'||

232:
233: x_return_status := FND_API.G_RET_STS_ERROR;
234:
235: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
236: IEX_DEBUG_PUB.logmessage('ASSIGN_STRATEGY: ' || 'IEXSTTAB-Delinquency id'||
237: 'before calling create strategy is '
238: ||l_delinquency_id||
239: ' object_id is '||p_objectid ||
240: ' object_type is' || p_objecttype );

Line 245: IEX_DEBUG_PUB.logmessage('ASSIGN_STRATEGY: ' || 'BEFORE CALLING CREATE_STRATEGY ');

241: END IF;
242:
243: -- IF PG_DEBUG < 10 THEN
244: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
245: IEX_DEBUG_PUB.logmessage('ASSIGN_STRATEGY: ' || 'BEFORE CALLING CREATE_STRATEGY ');
246: END IF;
247:
248: IEX_STRATEGY_PUB.CREATE_STRATEGY
249: (p_api_version_number => 2.0,

Line 263: iex_debug_pub.logmessage('ASSIGN_STRATEGY: ' || 'status of create strategy ' ||l_return_status);

259: p_strategy_temp_id => p_strategy_temp_id) ;
260:
261: -- IF PG_DEBUG < 10 THEN
262: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
263: iex_debug_pub.logmessage('ASSIGN_STRATEGY: ' || 'status of create strategy ' ||l_return_status);
264: END IF;
265:
266: x_msg_count :=l_msg_count;
267: x_msg_data :=l_msg_data;

Line 286: IEX_DEBUG_PUB.logmessage('ASSIGN_STRATEGY: ' || 'inexception of reassign strategy '||sqlerrm);

282: WHEN OTHERS THEN
283: ROLLBACK TO ASSIGN_STRATEGY_PUB;
284: -- IF PG_DEBUG < 10 THEN
285: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
286: IEX_DEBUG_PUB.logmessage('ASSIGN_STRATEGY: ' || 'inexception of reassign strategy '||sqlerrm);
287: END IF;
288: END ASSIGN_STRATEGY;
289: --End bug 6794510 gnramasa 5th Feb 08
290:

Line 323: IEX_DEBUG_PUB.logmessage('UPDATE_AND_SENDSIGNAL: ' || 'work item not in status OPEN or ONHOLD');

319:
320: if (l_status_code not in ('OPEN', 'ONHOLD','PRE-WAIT')) then --Added PRE-WAIT for bug#5474793 by schekuri on 21-Aug-2006
321: x_return_status := FND_API.G_RET_STS_ERROR;
322: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
323: IEX_DEBUG_PUB.logmessage('UPDATE_AND_SENDSIGNAL: ' || 'work item not in status OPEN or ONHOLD');
324: end if;
325: return;
326: end if;
327:

Line 332: IEX_DEBUG_PUB.logmessage('UPDATE_AND_SENDSIGNAL: ' || 'work item not found');

328: EXCEPTION
329: WHEN OTHERS THEN
330: x_return_status := FND_API.G_RET_STS_ERROR;
331: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
332: IEX_DEBUG_PUB.logmessage('UPDATE_AND_SENDSIGNAL: ' || 'work item not found');
333: end if;
334: return;
335: end;
336:

Line 363: IEX_DEBUG_PUB.logmessage('UPDATE_AND_SENDSIGNAL: ' || 'AFTER SEND SIGNAL');

359: work_item_id => p_strategy_work_item_rec.work_item_id);
360:
361: -- IF PG_DEBUG < 10 THEN
362: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
363: IEX_DEBUG_PUB.logmessage('UPDATE_AND_SENDSIGNAL: ' || 'AFTER SEND SIGNAL');
364: END IF;
365: --check if it the strategy is open
366: -- and next work item is not the same as the updated work item
367: -- then the send signal has been successful and it has created

Line 379: IEX_DEBUG_PUB.logmessage('UPDATE_AND_SENDSIGNAL: ' || 'send signal has failed ');

375:
376: if v_result >0 THEN
377: -- IF PG_DEBUG < 10 THEN
378: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
379: IEX_DEBUG_PUB.logmessage('UPDATE_AND_SENDSIGNAL: ' || 'send signal has failed ');
380: END IF;
381: rollback to UPDATE_AND_SENDSIGNAL;
382: x_return_status := FND_API.G_RET_STS_ERROR;
383: return;

Line 387: IEX_DEBUG_PUB.logmessage('UPDATE_AND_SENDSIGNAL: ' || 'send signal is successful ');

383: return;
384: else
385: -- IF PG_DEBUG < 10 THEN
386: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
387: IEX_DEBUG_PUB.logmessage('UPDATE_AND_SENDSIGNAL: ' || 'send signal is successful ');
388: END IF;
389: end if;
390: */
391: END IF; --if status is successful

Line 403: IEX_DEBUG_PUB.logmessage('inexception of UPDATE_AND_SENDSIGNAL '||sqlerrm);

399: WHEN OTHERS THEN
400: ROLLBACK TO UPDATE_AND_SENDSIGNAL;
401: -- IF PG_DEBUG < 10 THEN
402: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
403: IEX_DEBUG_PUB.logmessage('inexception of UPDATE_AND_SENDSIGNAL '||sqlerrm);
404: END IF;
405:
406: END UPDATE_AND_SENDSIGNAL;
407:

Line 446: IEX_DEBUG_PUB.logmessage('UPDATE_AND_SENDSIGNAL: ' || 'START UPDATE AND SEND SIGNAL');

442:
443: BEGIN
444: -- IF PG_DEBUG < 10 THEN
445: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
446: IEX_DEBUG_PUB.logmessage('UPDATE_AND_SENDSIGNAL: ' || 'START UPDATE AND SEND SIGNAL');
447: END IF;
448: SAVEPOINT UPDATE_AND_SENDSIGNAL;
449: x_return_status := FND_API.G_RET_STS_SUCCESS;
450:

Line 465: IEX_DEBUG_PUB.logmessage('UPDATE_AND_SENDSIGNAL: ' || 'BEFORE CALLING UPDATE WORK ITEM PVT');

461: l_strategy_work_item_rec.strategy_id :=l_strategy_id;
462:
463: -- IF PG_DEBUG < 10 THEN
464: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
465: IEX_DEBUG_PUB.logmessage('UPDATE_AND_SENDSIGNAL: ' || 'BEFORE CALLING UPDATE WORK ITEM PVT');
466: END IF;
467: iex_strategy_work_items_pvt.update_strategy_work_items(
468: p_api_version_number => 2.0,
469: p_init_msg_list => FND_API.G_TRUE,

Line 479: IEX_DEBUG_PUB.logmessage('UPDATE_AND_SENDSIGNAL: ' || 'Status of work item update ' ||l_return_status);

475: p_strategy_work_item_rec => l_strategy_work_item_rec,
476: xo_object_version_number => l_version_number);
477: -- IF PG_DEBUG < 10 THEN
478: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
479: IEX_DEBUG_PUB.logmessage('UPDATE_AND_SENDSIGNAL: ' || 'Status of work item update ' ||l_return_status);
480: END IF;
481:
482: If l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
483: x_msg_count :=l_msg_count;

Line 499: IEX_DEBUG_PUB.logmessage('UPDATE_AND_SENDSIGNAL: ' || 'AFTER SEND SIGNAL');

495: work_item_id =>l_strategy_work_item_rec.work_item_id);
496:
497: -- IF PG_DEBUG < 10 THEN
498: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
499: IEX_DEBUG_PUB.logmessage('UPDATE_AND_SENDSIGNAL: ' || 'AFTER SEND SIGNAL');
500: END IF;
501: --check if it the strategy is open
502: -- and next work item is not the same as the updated work item
503: -- then the send signal has been successful and it has created

Line 515: IEX_DEBUG_PUB.logmessage('UPDATE_AND_SENDSIGNAL: ' || 'send signal has failed ');

511:
512: if v_result >0 THEN
513: -- IF PG_DEBUG < 10 THEN
514: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
515: IEX_DEBUG_PUB.logmessage('UPDATE_AND_SENDSIGNAL: ' || 'send signal has failed ');
516: END IF;
517: rollback to UPDATE_AND_SENDSIGNAL;
518: x_return_status := FND_API.G_RET_STS_ERROR;
519: return;

Line 523: IEX_DEBUG_PUB.logmessage('UPDATE_AND_SENDSIGNAL: ' || 'send signal is successful ');

519: return;
520: else
521: -- IF PG_DEBUG < 10 THEN
522: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
523: IEX_DEBUG_PUB.logmessage('UPDATE_AND_SENDSIGNAL: ' || 'send signal is successful ');
524: END IF;
525: end if;
526: */
527: END IF ; -- p_status in 'closed' or cancelled'

Line 540: IEX_DEBUG_PUB.logmessage('inexception of UPDATE_AND_SENDSIGNAL '||sqlerrm);

536: WHEN OTHERS THEN
537: ROLLBACK TO UPDATE_AND_SENDSIGNAL;
538: -- IF PG_DEBUG < 10 THEN
539: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
540: IEX_DEBUG_PUB.logmessage('inexception of UPDATE_AND_SENDSIGNAL '||sqlerrm);
541: END IF;
542:
543:
544: END UPDATE_AND_SENDSIGNAL;

Line 581: IEX_DEBUG_PUB.logmessage('Begin IEX_STRY_API_PUB.CHECK_STRATEGY_WORKFLOW' );

577:
578: BEGIN
579: -- IF PG_DEBUG < 10 THEN
580: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
581: IEX_DEBUG_PUB.logmessage('Begin IEX_STRY_API_PUB.CHECK_STRATEGY_WORKFLOW' );
582: END IF;
583: --check status of the workflow
584: wf_engine.ItemStatus( itemtype => 'IEXSTRY',
585: itemkey => p_strategy,

Line 597: IEX_DEBUG_PUB.logmessage('CHECK_STRATEGY_WORKFLOW: ' || 'wf error is ' ||l_wf_error);

593: FETCH c_get_Wf_error INTO l_wf_error;
594: CLOSE c_get_wf_error;
595: -- IF PG_DEBUG < 10 THEN
596: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
597: IEX_DEBUG_PUB.logmessage('CHECK_STRATEGY_WORKFLOW: ' || 'wf error is ' ||l_wf_error);
598: END IF;
599:
600: if l_return_status = wf_engine.eng_error THEN
601: -- work flow is in error

Line 611: IEX_DEBUG_PUB.logmessage('CHECK_STRATEGY_WORKFLOW: ' || 'Work flow is in error for strategy Id'

607:
608: x_return_message := x_return_message || l_wf_error;
609: -- IF PG_DEBUG < 10 THEN
610: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
611: IEX_DEBUG_PUB.logmessage('CHECK_STRATEGY_WORKFLOW: ' || 'Work flow is in error for strategy Id'
612: ||p_strategy || 'error is ' ||x_return_message);
613: END IF;
614:
615: elsif l_return_status =wf_engine.eng_active THEN

Line 631: IEX_DEBUG_PUB.logmessage('CHECK_STRATEGY_WORKFLOW: ' || 'l_activity_name is null ' );

627: aname => 'ACTIVITY_NAME');
628: If l_activity_name is null then
629: -- IF PG_DEBUG < 10 THEN
630: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
631: IEX_DEBUG_PUB.logmessage('CHECK_STRATEGY_WORKFLOW: ' || 'l_activity_name is null ' );
632: END IF;
633: x_return_message :=wf_engine.GetItemAttrText(itemtype => 'IEXSTRY',
634: itemkey => p_strategy,
635: aname => 'ERROR_MESSAGE');

Line 641: IEX_DEBUG_PUB.logmessage('CHECK_STRATEGY_WORKFLOW: ' || 'Work flow is in error for strategy Id'

637: x_return_message := x_return_message || l_wf_error;
638: x_return_status := 'E';
639: -- IF PG_DEBUG < 10 THEN
640: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
641: IEX_DEBUG_PUB.logmessage('CHECK_STRATEGY_WORKFLOW: ' || 'Work flow is in error for strategy Id'
642: ||p_strategy || 'error is ' ||x_return_message);
643: END IF;
644: -- set status to success
645: -- cancel or complete optional or escalate work item

Line 660: IEX_DEBUG_PUB.logmessage('End IEX_STRY_API_PUB.CHECK_STRATEGY_WORKFLOW' );

656: end if;
657:
658: -- IF PG_DEBUG < 10 THEN
659: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
660: IEX_DEBUG_PUB.logmessage('End IEX_STRY_API_PUB.CHECK_STRATEGY_WORKFLOW' );
661: END IF;
662:
663: EXCEPTION
664: WHEN OTHERS THEN

Line 667: IEX_DEBUG_PUB.logmessage('CHECK_STRATEGY_WORKFLOW: ' || 'inexception of UPDATE_AND_SENDSIGNAL '||sqlerrm);

663: EXCEPTION
664: WHEN OTHERS THEN
665: -- IF PG_DEBUG < 10 THEN
666: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
667: IEX_DEBUG_PUB.logmessage('CHECK_STRATEGY_WORKFLOW: ' || 'inexception of UPDATE_AND_SENDSIGNAL '||sqlerrm);
668: END IF;
669: x_return_status := 'E';
670: x_return_message := sqlerrm;
671: x_wf_Status :=NULL;

Line 703: IEX_DEBUG_PUB.logmessage('START UPDATE_WORKITEM');

699:
700: BEGIN
701: -- IF PG_DEBUG < 10 THEN
702: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
703: IEX_DEBUG_PUB.logmessage('START UPDATE_WORKITEM');
704: END IF;
705: SAVEPOINT UPDATE_WORKITEM;
706: x_return_status := FND_API.G_RET_STS_SUCCESS;
707:

Line 722: IEX_DEBUG_PUB.logmessage('UPDATE_WORKITEM: ' || 'BEFORE CALLING UPDATE WORK ITEM PVT');

718: l_strategy_work_item_rec.strategy_id :=l_strategy_id;
719:
720: -- IF PG_DEBUG < 10 THEN
721: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
722: IEX_DEBUG_PUB.logmessage('UPDATE_WORKITEM: ' || 'BEFORE CALLING UPDATE WORK ITEM PVT');
723: END IF;
724: iex_strategy_work_items_pvt.update_strategy_work_items(
725: p_api_version_number => 2.0,
726: p_init_msg_list => FND_API.G_TRUE,

Line 736: IEX_DEBUG_PUB.logmessage('UPDATE_WORKITEM: ' || 'Status of work item update ' ||l_return_status);

732: p_strategy_work_item_rec => l_strategy_work_item_rec,
733: xo_object_version_number => l_version_number);
734: -- IF PG_DEBUG < 10 THEN
735: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
736: IEX_DEBUG_PUB.logmessage('UPDATE_WORKITEM: ' || 'Status of work item update ' ||l_return_status);
737: END IF;
738:
739: -- Standard check of p_commit
740: IF FND_API.To_Boolean(p_commit) THEN

Line 749: IEX_DEBUG_PUB.logmessage('inexception of UPDATE_WORKITEM '||sqlerrm);

745: WHEN OTHERS THEN
746: ROLLBACK TO UPDATE_WORKITEM;
747: -- IF PG_DEBUG < 10 THEN
748: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
749: IEX_DEBUG_PUB.logmessage('inexception of UPDATE_WORKITEM '||sqlerrm);
750: END IF;
751:
752: END UPDATE_WORKITEM;
753:

Line 792: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': start');

788: l_uwq_complete_date date;
789:
790: begin
791: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
792: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': start');
793: END IF;
794:
795: -- Standard start of API savepoint
796: SAVEPOINT SHOW_IN_UWQ_PVT;

Line 816: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': new uwq status: ' || P_UWQ_STATUS);

812:
813: -- validating uwq status
814: l_validation_item := 'P_UWQ_STATUS';
815: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
816: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': new uwq status: ' || P_UWQ_STATUS);
817: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Validating ' || l_validation_item);
818: END IF;
819: if P_UWQ_STATUS is null then
820: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 817: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Validating ' || l_validation_item);

813: -- validating uwq status
814: l_validation_item := 'P_UWQ_STATUS';
815: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
816: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': new uwq status: ' || P_UWQ_STATUS);
817: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Validating ' || l_validation_item);
818: END IF;
819: if P_UWQ_STATUS is null then
820: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
821: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');

Line 821: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');

817: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Validating ' || l_validation_item);
818: END IF;
819: if P_UWQ_STATUS is null then
820: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
821: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
822: END IF;
823: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
824: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
825: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);

Line 833: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': count of P_WORK_ITEM_ID_TBL: ' || P_WORK_ITEM_ID_TBL.count);

829:
830: -- validating table of promises
831: l_validation_item := 'P_WORK_ITEM_ID_TBL';
832: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
833: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': count of P_WORK_ITEM_ID_TBL: ' || P_WORK_ITEM_ID_TBL.count);
834: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Validating ' || l_validation_item);
835: END IF;
836: if P_WORK_ITEM_ID_TBL.count = 0 then
837: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 834: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Validating ' || l_validation_item);

830: -- validating table of promises
831: l_validation_item := 'P_WORK_ITEM_ID_TBL';
832: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
833: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': count of P_WORK_ITEM_ID_TBL: ' || P_WORK_ITEM_ID_TBL.count);
834: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Validating ' || l_validation_item);
835: END IF;
836: if P_WORK_ITEM_ID_TBL.count = 0 then
837: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
838: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');

Line 838: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');

834: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Validating ' || l_validation_item);
835: END IF;
836: if P_WORK_ITEM_ID_TBL.count = 0 then
837: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
838: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
839: END IF;
840: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
841: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
842: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);

Line 850: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': P_NO_DAYS: ' || P_NO_DAYS);

846:
847: -- validating p_days
848: l_validation_item := 'P_NO_DAYS';
849: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
850: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': P_NO_DAYS: ' || P_NO_DAYS);
851: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Validating ' || l_validation_item);
852: END IF;
853: if P_NO_DAYS is not null and P_NO_DAYS < 0 then
854: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 851: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Validating ' || l_validation_item);

847: -- validating p_days
848: l_validation_item := 'P_NO_DAYS';
849: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
850: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': P_NO_DAYS: ' || P_NO_DAYS);
851: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Validating ' || l_validation_item);
852: END IF;
853: if P_NO_DAYS is not null and P_NO_DAYS < 0 then
854: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
855: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');

Line 855: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');

851: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Validating ' || l_validation_item);
852: END IF;
853: if P_NO_DAYS is not null and P_NO_DAYS < 0 then
854: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
855: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
856: END IF;
857: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
858: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
859: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);

Line 871: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': number of days: ' || l_days);

867: else
868: l_days := P_NO_DAYS;
869: end if;
870: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
871: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': number of days: ' || l_days);
872: END IF;
873: l_set_status_date := sysdate + l_days;
874: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
875: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': set status date: ' || l_set_status_date);

Line 875: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': set status date: ' || l_set_status_date);

871: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': number of days: ' || l_days);
872: END IF;
873: l_set_status_date := sysdate + l_days;
874: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
875: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': set status date: ' || l_set_status_date);
876: END IF;
877:
878: -- check for status
879: if P_UWQ_STATUS = 'ACTIVE' then

Line 893: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': l_uwq_active_date: ' || l_uwq_active_date);

889:
890: nCount := p_work_item_id_tbl.count;
891: if nCount > 0 then
892: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
893: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': l_uwq_active_date: ' || l_uwq_active_date);
894: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': l_uwq_complete_date: ' || l_uwq_complete_date);
895: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': updating promise details...');
896: END IF;
897: FORALL i in 1..nCount

Line 894: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': l_uwq_complete_date: ' || l_uwq_complete_date);

890: nCount := p_work_item_id_tbl.count;
891: if nCount > 0 then
892: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
893: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': l_uwq_active_date: ' || l_uwq_active_date);
894: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': l_uwq_complete_date: ' || l_uwq_complete_date);
895: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': updating promise details...');
896: END IF;
897: FORALL i in 1..nCount
898: UPDATE iex_strategy_work_items

Line 895: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': updating promise details...');

891: if nCount > 0 then
892: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
893: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': l_uwq_active_date: ' || l_uwq_active_date);
894: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': l_uwq_complete_date: ' || l_uwq_complete_date);
895: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': updating promise details...');
896: END IF;
897: FORALL i in 1..nCount
898: UPDATE iex_strategy_work_items
899: SET uwq_status = p_uwq_status,

Line 908: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': nothing to update');

904: where
905: work_item_id = p_work_item_id_tbl(i);
906: else
907: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
908: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': nothing to update');
909: END IF;
910: end if;
911:
912: -- END OF BODY OF API

Line 953: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || 'begin.' );

949: l_api_name CONSTANT VARCHAR2(30) := 'COPY_WORK_ITEM_TEMPLATE';
950: -- l_work_item_seq number;
951: begin
952: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
953: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || 'begin.' );
954: END IF;
955:
956: SAVEPOINT COPY_WORK_ITEM;
957:

Line 995: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || 'end.' );

991: from iex_strategy_work_skills a
992: where a.work_item_temp_id = p_work_item_temp_id;
993:
994: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
995: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || 'end.' );
996: END IF;
997:
998: EXCEPTION
999: WHEN FND_API.G_EXC_ERROR THEN

Line 1002: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || 'g_exc_error.' || sqlerrm );

998: EXCEPTION
999: WHEN FND_API.G_EXC_ERROR THEN
1000: ROLLBACK TO COPY_WORK_ITEM;
1001: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1002: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || 'g_exc_error.' || sqlerrm );
1003: END IF;
1004: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1005: ROLLBACK TO COPY_WORK_ITEM;
1006: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 1007: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || 'g_exc_unexpected_error.' || sqlerrm );

1003: END IF;
1004: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1005: ROLLBACK TO COPY_WORK_ITEM;
1006: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1007: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || 'g_exc_unexpected_error.' || sqlerrm );
1008: END IF;
1009: WHEN OTHERS THEN
1010: ROLLBACK TO COPY_WORK_ITEM;
1011: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 1012: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || 'others error.' || sqlerrm);

1008: END IF;
1009: WHEN OTHERS THEN
1010: ROLLBACK TO COPY_WORK_ITEM;
1011: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1012: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || 'others error.' || sqlerrm);
1013: END IF;
1014: end;
1015:
1016:

Line 1043: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || 'SKIP_WAIT' || ' Forcing to complete Wait Activity ' || l_activity_label);

1039: IF (l_activity_label = 'STRATEGY_SUBPROCESS:PRE_WAIT_PROCESS' and p_wkitem_status = 'PRE-WAIT') OR
1040: (l_activity_label = 'STRATEGY_WORKFLOW:WAIT_AFTER_PROCESS' and p_wkitem_status = 'COMPLETE' and p_workitem_id = l_work_item_id) THEN
1041:
1042: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1043: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || 'SKIP_WAIT' || ' Forcing to complete Wait Activity ' || l_activity_label);
1044: END IF;
1045:
1046: wf_engine.CompleteActivity(itemtype => 'IEXSTRY',
1047: itemkey => p_strategy_id,

Line 1052: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || 'SKIP_WAIT' || ' Forcefully completed Wait Activity ' || l_activity_label);

1048: activity =>l_activity_label,
1049: result =>'#TIMEOUT');
1050: COMMIT WORK;
1051: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1052: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || 'SKIP_WAIT' || ' Forcefully completed Wait Activity ' || l_activity_label);
1053: END IF;
1054: x_return_status := l_return_status;
1055: END IF;
1056: EXCEPTION WHEN OTHERS THEN