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 FND_LOG

Line 135: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

131: strategy_id => p_strategy_id,
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);

Line 145: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

141: CLOSE c_status;
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;

Line 153: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

149: FETCH c_object INTO l_delinquency_id,l_object_id,l_object_type;
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 ||

Line 162: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

158: ' object_type is' || l_object_type );
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

Line 180: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

176: x_msg_data => l_msg_data,
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;

Line 203: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

199: EXCEPTION
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:

Line 235: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

231: SAVEPOINT ASSIGN_STRATEGY_PUB;
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 ||

Line 244: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

240: ' object_type is' || p_objecttype );
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

Line 262: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

258: x_msg_data => l_msg_data,
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;

Line 285: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

281: EXCEPTION
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

Line 322: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

318: and work_item_id = p_strategy_work_item_rec.work_item_id;
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;

Line 331: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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

Line 362: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

358: status => p_strategy_work_item_rec.status_code,
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

Line 378: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

374: and status_code ='OPEN';
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;

Line 386: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

382: x_return_status := FND_API.G_RET_STS_ERROR;
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: */

Line 402: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

398: EXCEPTION
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;

Line 445: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

441: where work_item_id = p_work_item_id ;
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;

Line 464: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

460: l_strategy_work_item_rec.resource_id :=p_resource_id;
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,

Line 478: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

474: x_msg_data => l_msg_data,
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

Line 498: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

494: status => l_strategy_work_item_rec.status_code,
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

Line 514: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

510: and status_code ='OPEN';
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;

Line 522: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

518: x_return_status := FND_API.G_RET_STS_ERROR;
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: */

Line 539: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

535: EXCEPTION
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:

Line 580: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

576: and ias.activity_status = 'ERROR';
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',

Line 596: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

592: OPEN c_get_Wf_error (p_strategy);
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

Line 610: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

606: x_return_status := 'E';
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:

Line 630: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

626: itemkey => p_strategy,
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,

Line 640: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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

Line 659: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

655: x_return_message := NULL;
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

Line 666: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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

Line 702: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

698: where work_item_id = p_work_item_id ;
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;

Line 721: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

717: l_strategy_work_item_rec.resource_id :=p_resource_id;
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,

Line 735: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

731: x_msg_data => l_msg_data,
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

Line 748: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

744: EXCEPTION
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;

Line 791: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

787: l_uwq_active_date date;
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

Line 815: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

811: -- START OF BODY OF API
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

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

Line 832: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

828: end if;
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

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

Line 849: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

845: end if;
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

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

Line 870: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

866: l_days := to_number(nvl(fnd_profile.value('IEX_UWQ_DEFAULT_PENDING_DAYS'), '0'));
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

Line 874: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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);
876: END IF;
877:
878: -- check for status

Line 892: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

888: end if;
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;

Line 907: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

903: last_updated_by = g_user_id
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:

Line 952: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

948: is
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;

Line 994: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

990: sysdate,fnd_global.user_id,sysdate,fnd_global.user_id,fnd_global.user_id, a.object_version_number
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

Line 1001: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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

Line 1042: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

1038:
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',

Line 1051: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

1047: itemkey => p_strategy_id,
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;

Line 1066: PG_DEBUG := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1062:
1063:
1064: begin
1065: G_USER_ID := FND_GLOBAL.User_Id;
1066: PG_DEBUG := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1067: END IEX_STRY_API_PUB ;
1068:
1069:
1070: