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_DEL_SUB_PVT dependencies on IEX_DEBUG_PUB

Line 104: IEX_DEBUG_PUB.LOGMESSAGE

100: WHEN Others then
101: -- Error Handling for Others
102: -- IF PG_DEBUG < 10 THEN
103: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
104: IEX_DEBUG_PUB.LOGMESSAGE
105: ('Add_rec: ' || '[ ' || p_source_module ||' ] - ADD Records Exception - INSERT >>
106: ' || SQLCODE || ' >> ' || SQLERRM);
107: END IF;
108: x_return_status := FND_API.G_RET_STS_ERROR;

Line 118: IEX_DEBUG_PUB.LOGMESSAGE

114: WHEN OTHERS then
115: -- Error Handling for Others
116: -- IF PG_DEBUG < 10 THEN
117: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
118: IEX_DEBUG_PUB.LOGMESSAGE
119: ('Add_rec: ' || '[ ' || p_source_module ||' ] - ADD Records Exception - UPDATE >>
120: ' || SQLCODE || ' >> ' || SQLERRM);
121: END IF;
122: x_return_status := FND_API.G_RET_STS_ERROR;

Line 172: IEX_DEBUG_PUB.LOGMESSAGE

168: WHEN Others then
169: -- Error Handling for Others
170: -- IF PG_DEBUG < 10 THEN
171: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
172: IEX_DEBUG_PUB.LOGMESSAGE
173: ('Add_rec: ' || '[ ' || p_source_module ||' ] - ADD Records Exception - INSERT >>
174: ' || SQLCODE || ' >> ' || SQLERRM);
175: END IF;
176: x_return_status := FND_API.G_RET_STS_ERROR;

Line 185: IEX_DEBUG_PUB.LOGMESSAGE

181: WHEN OTHERS then
182: -- Error Handling for Others
183: -- IF PG_DEBUG < 10 THEN
184: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
185: IEX_DEBUG_PUB.LOGMESSAGE
186: ('Add_rec: ' || '[ ' || p_source_module ||' ] - ADD Records Exception - UPDATE >>
187: ' || SQLCODE || ' >> ' || SQLERRM);
188: END IF;
189: x_return_status := FND_API.G_RET_STS_ERROR;

Line 240: IEX_DEBUG_PUB.LOGMESSAGE

236: WHEN Others then
237: -- Error Handling for Others
238: -- IF PG_DEBUG < 10 THEN
239: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
240: IEX_DEBUG_PUB.LOGMESSAGE
241: ('Add_rec: ' || '[ ' || p_source_module ||' ] - ADD Records Exception - INSERT >>
242: ' || SQLCODE || ' >> ' || SQLERRM);
243: END IF;
244: x_return_status := FND_API.G_RET_STS_ERROR;

Line 254: IEX_DEBUG_PUB.LOGMESSAGE

250: WHEN OTHERS then
251: -- Error Handling for Others
252: -- IF PG_DEBUG < 10 THEN
253: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
254: IEX_DEBUG_PUB.LOGMESSAGE
255: ('Add_rec: ' || '[ ' || p_source_module ||' ] - ADD Records Exception - INSERT >>
256: ' || SQLCODE || ' >> ' || SQLERRM);
257: END IF;
258: x_return_status := FND_API.G_RET_STS_ERROR;

Line 274: IEX_DEBUG_PUB.LogMessage('PUB: ' || l_api_name || ' end');

270: ROLLBACK TO ADD_REC ;
271: END IF;
272:
273: -- Debug Message
274: IEX_DEBUG_PUB.LogMessage('PUB: ' || l_api_name || ' end');
275: IEX_DEBUG_PUB.LogMessage('End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
276: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
277:
278: EXCEPTION

Line 275: IEX_DEBUG_PUB.LogMessage('End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

271: END IF;
272:
273: -- Debug Message
274: IEX_DEBUG_PUB.LogMessage('PUB: ' || l_api_name || ' end');
275: IEX_DEBUG_PUB.LogMessage('End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
276: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
277:
278: EXCEPTION
279: WHEN FND_API.G_EXC_ERROR THEN

Line 383: IEX_DEBUG_PUB.LogMessage('PUB: ' || l_api_name || ' end');

379: ROLLBACK TO REMOVE_REC ;
380: END IF;
381:
382: -- Debug Message
383: IEX_DEBUG_PUB.LogMessage('PUB: ' || l_api_name || ' end');
384: IEX_DEBUG_PUB.LogMessage('End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
385: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
386:
387: EXCEPTION

Line 384: IEX_DEBUG_PUB.LogMessage('End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

380: END IF;
381:
382: -- Debug Message
383: IEX_DEBUG_PUB.LogMessage('PUB: ' || l_api_name || ' end');
384: IEX_DEBUG_PUB.LogMessage('End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
385: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
386:
387: EXCEPTION
388: WHEN FND_API.G_EXC_ERROR THEN

Line 411: IEX_DEBUG_PUB.LOGMESSAGE

407:
408: WHEN OTHERS THEN
409: -- IF PG_DEBUG < 10 THEN
410: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
411: IEX_DEBUG_PUB.LOGMESSAGE
412: ('Remove_rec: ' || '[ ' || p_source_module ||' ] - REMOVE Records Exception >> '
413: || SQLCODE || ' >> ' || SQLERRM);
414: END IF;
415: rollback to remove_rec ;

Line 507: IEX_DEBUG_PUB.LogMessage('PUB: ' || l_api_name || ' end');

503: p_object_code ,
504: p_object_id );
505:
506: -- Debug Message
507: IEX_DEBUG_PUB.LogMessage('PUB: ' || l_api_name || ' end');
508: IEX_DEBUG_PUB.LogMessage('End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
509: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
510:
511: EXCEPTION

Line 508: IEX_DEBUG_PUB.LogMessage('End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

504: p_object_id );
505:
506: -- Debug Message
507: IEX_DEBUG_PUB.LogMessage('PUB: ' || l_api_name || ' end');
508: IEX_DEBUG_PUB.LogMessage('End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
509: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
510:
511: EXCEPTION
512: WHEN FND_API.G_EXC_ERROR THEN

Line 535: IEX_DEBUG_PUB.LOGMESSAGE

531:
532: WHEN OTHERS THEN
533: -- IF PG_DEBUG < 10 THEN
534: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
535: IEX_DEBUG_PUB.LOGMESSAGE
536: ('Add_All_rec: ' || '[ ' || p_source_module ||' ] - ADD ALL Records Exception >> '
537: || SQLCODE || ' >> ' || SQLERRM);
538: END IF;
539: rollback to remove_rec ;

Line 616: IEX_DEBUG_PUB.LogMessage('PUB: ' || l_api_name || ' end');

612: ROLLBACK TO REMOVE_ALL_REC ;
613: END IF;
614:
615: -- Debug Message
616: IEX_DEBUG_PUB.LogMessage('PUB: ' || l_api_name || ' end');
617: IEX_DEBUG_PUB.LogMessage('End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
618: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
619:
620: EXCEPTION

Line 617: IEX_DEBUG_PUB.LogMessage('End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

613: END IF;
614:
615: -- Debug Message
616: IEX_DEBUG_PUB.LogMessage('PUB: ' || l_api_name || ' end');
617: IEX_DEBUG_PUB.LogMessage('End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
618: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
619:
620: EXCEPTION
621: WHEN FND_API.G_EXC_ERROR THEN

Line 644: IEX_DEBUG_PUB.LOGMESSAGE

640:
641: WHEN OTHERS THEN
642: -- IF PG_DEBUG < 10 THEN
643: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
644: IEX_DEBUG_PUB.LOGMESSAGE
645: ('Remove_All_rec: ' || '[ ' || p_source_module ||' ] - REMOVE ALL Records Exception >> '
646: || SQLCODE || ' >> ' || SQLERRM);
647: END IF;
648: rollback to remove_rec ;

Line 708: IEX_DEBUG_PUB.LOGMESSAGE('Start_Workflow: ' || ' ');

704:
705: BEGIN
706: -- IF PG_DEBUG < 10 THEN
707: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
708: IEX_DEBUG_PUB.LOGMESSAGE('Start_Workflow: ' || ' ');
709: END IF;
710: -- IF PG_DEBUG < 10 THEN
711: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
712: IEX_DEBUG_PUB.LOGMESSAGE('Start_Workflow: ' || '************ Start Workflow Message Log Start **********');

Line 712: IEX_DEBUG_PUB.LOGMESSAGE('Start_Workflow: ' || '** Start Workflow Message Log Start ');

708: IEX_DEBUG_PUB.LOGMESSAGE('Start_Workflow: ' || ' ');
709: END IF;
710: -- IF PG_DEBUG < 10 THEN
711: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
712: IEX_DEBUG_PUB.LOGMESSAGE('Start_Workflow: ' || '************ Start Workflow Message Log Start **********');
713: END IF;
714:
715: -- IF PG_DEBUG < 10 THEN
716: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 717: IEX_DEBUG_PUB.LOGMESSAGE('Start_Workflow: ' || 'Addl Notification Info >> ' || p_asset_addl_info);

713: END IF;
714:
715: -- IF PG_DEBUG < 10 THEN
716: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
717: IEX_DEBUG_PUB.LOGMESSAGE('Start_Workflow: ' || 'Addl Notification Info >> ' || p_asset_addl_info);
718: END IF;
719: -- IF PG_DEBUG < 10 THEN
720: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
721: IEX_DEBUG_PUB.LOGMESSAGE('Start_Workflow: ' || 'Passed User Id >> ' || Nvl(to_char(p_user_id), 'NULL'));

Line 721: IEX_DEBUG_PUB.LOGMESSAGE('Start_Workflow: ' || 'Passed User Id >> ' || Nvl(to_char(p_user_id), 'NULL'));

717: IEX_DEBUG_PUB.LOGMESSAGE('Start_Workflow: ' || 'Addl Notification Info >> ' || p_asset_addl_info);
718: END IF;
719: -- IF PG_DEBUG < 10 THEN
720: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
721: IEX_DEBUG_PUB.LOGMESSAGE('Start_Workflow: ' || 'Passed User Id >> ' || Nvl(to_char(p_user_id), 'NULL'));
722: END IF;
723:
724: -- Standard Start of API savepoint
725: SAVEPOINT DEL_ASSET;

Line 738: IEX_DEBUG_PUB.LOGMESSAGE('Start_Workflow: ' || 'Stage 1');

734: END IF;
735:
736: -- IF PG_DEBUG < 10 THEN
737: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
738: IEX_DEBUG_PUB.LOGMESSAGE('Start_Workflow: ' || 'Stage 1');
739: END IF;
740:
741: -- Initialize message list if p_init_msg_list is set to TRUE.
742: IF FND_API.to_Boolean( p_init_msg_list )

Line 748: IEX_DEBUG_PUB.LogMessage('Public API: ' || l_api_name || ' start');

744: FND_MSG_PUB.initialize;
745: END IF;
746:
747: -- Debug Message
748: IEX_DEBUG_PUB.LogMessage('Public API: ' || l_api_name || ' start');
749:
750: IEX_DEBUG_PUB.LogMessage('Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
751: -- IF PG_DEBUG < 10 THEN
752: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 750: IEX_DEBUG_PUB.LogMessage('Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

746:
747: -- Debug Message
748: IEX_DEBUG_PUB.LogMessage('Public API: ' || l_api_name || ' start');
749:
750: IEX_DEBUG_PUB.LogMessage('Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
751: -- IF PG_DEBUG < 10 THEN
752: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
753: IEX_DEBUG_PUB.LOGMESSAGE('Start_Workflow: ' || 'Stage 2');
754: END IF;

Line 753: IEX_DEBUG_PUB.LOGMESSAGE('Start_Workflow: ' || 'Stage 2');

749:
750: IEX_DEBUG_PUB.LogMessage('Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
751: -- IF PG_DEBUG < 10 THEN
752: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
753: IEX_DEBUG_PUB.LOGMESSAGE('Start_Workflow: ' || 'Stage 2');
754: END IF;
755: -- Initialize API return status to SUCCESS
756: x_return_status := FND_API.G_RET_STS_SUCCESS;
757:

Line 784: IEX_DEBUG_PUB.LOGMESSAGE('Start_Workflow: ' || 'Setting Manager Id With Owner Id');

780:
781: if l_manager_id is NULL then
782: -- IF PG_DEBUG < 10 THEN
783: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
784: IEX_DEBUG_PUB.LOGMESSAGE('Start_Workflow: ' || 'Setting Manager Id With Owner Id');
785: END IF;
786: l_manager_id := p_user_id ;
787: l_manager_name := l_user_name ;
788: else

Line 791: IEX_DEBUG_PUB.LOGMESSAGE('Start_Workflow: ' || 'Manager Id Not Null >> ' || NVL(l_manager_id, 'NULL'));

787: l_manager_name := l_user_name ;
788: else
789: -- IF PG_DEBUG < 10 THEN
790: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
791: IEX_DEBUG_PUB.LOGMESSAGE('Start_Workflow: ' || 'Manager Id Not Null >> ' || NVL(l_manager_id, 'NULL'));
792: END IF;
793: End IF ;
794: -- IF PG_DEBUG < 10 THEN
795: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 796: IEX_DEBUG_PUB.LOGMESSAGE('Start_Workflow: ' || 'Owner Id ' || to_char(p_user_id) || ' Owner Name ' || l_user_name);

792: END IF;
793: End IF ;
794: -- IF PG_DEBUG < 10 THEN
795: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
796: IEX_DEBUG_PUB.LOGMESSAGE('Start_Workflow: ' || 'Owner Id ' || to_char(p_user_id) || ' Owner Name ' || l_user_name);
797: END IF;
798: -- IF PG_DEBUG < 10 THEN
799: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
800: IEX_DEBUG_PUB.LOGMESSAGE('Start_Workflow: ' || 'Manager Id ' || to_char(l_manager_id) || ' Manager Name ' || l_manager_name);

Line 800: IEX_DEBUG_PUB.LOGMESSAGE('Start_Workflow: ' || 'Manager Id ' || to_char(l_manager_id) || ' Manager Name ' || l_manager_name);

796: IEX_DEBUG_PUB.LOGMESSAGE('Start_Workflow: ' || 'Owner Id ' || to_char(p_user_id) || ' Owner Name ' || l_user_name);
797: END IF;
798: -- IF PG_DEBUG < 10 THEN
799: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
800: IEX_DEBUG_PUB.LOGMESSAGE('Start_Workflow: ' || 'Manager Id ' || to_char(l_manager_id) || ' Manager Name ' || l_manager_name);
801: END IF;
802: Exception
803: WHEN OTHERS THEN
804: -- IF PG_DEBUG < 10 THEN

Line 806: IEX_DEBUG_PUB.LOGMESSAGE

802: Exception
803: WHEN OTHERS THEN
804: -- IF PG_DEBUG < 10 THEN
805: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
806: IEX_DEBUG_PUB.LOGMESSAGE
807: ('Start_Workflow: ' || 'Getting Manager Information - '
808: || SQLCODE || ' >> ' || SQLERRM);
809: END IF;
810: rollback to DEL_ASSET ;

Line 818: IEX_DEBUG_PUB.LOGMESSAGE('Start_Workflow: ' || 'Before Create Process');

814: End ;
815:
816: -- IF PG_DEBUG < 10 THEN
817: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
818: IEX_DEBUG_PUB.LOGMESSAGE('Start_Workflow: ' || 'Before Create Process');
819: END IF;
820: -- IF PG_DEBUG < 10 THEN
821: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
822: IEX_DEBUG_PUB.LOGMESSAGE('Start_Workflow: ' || 'Item Type ' || itemtype || ' Item Key ' || itemkey || ' process ' || workflowprocess);

Line 822: IEX_DEBUG_PUB.LOGMESSAGE('Start_Workflow: ' || 'Item Type ' || itemtype || ' Item Key ' || itemkey || ' process ' || workflowprocess);

818: IEX_DEBUG_PUB.LOGMESSAGE('Start_Workflow: ' || 'Before Create Process');
819: END IF;
820: -- IF PG_DEBUG < 10 THEN
821: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
822: IEX_DEBUG_PUB.LOGMESSAGE('Start_Workflow: ' || 'Item Type ' || itemtype || ' Item Key ' || itemkey || ' process ' || workflowprocess);
823: END IF;
824:
825: wf_engine.createprocess (
826: itemtype => itemtype,

Line 859: IEX_DEBUG_PUB.LOGMESSAGE('Start_Workflow: ' || 'Stage 6');

855: aname => 'MANAGER_NAME',
856: avalue => l_manager_name);
857: -- IF PG_DEBUG < 10 THEN
858: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
859: IEX_DEBUG_PUB.LOGMESSAGE('Start_Workflow: ' || 'Stage 6');
860: END IF;
861:
862: -- Passed asset Information from Form
863: wf_engine.setitemattrtext(

Line 889: IEX_DEBUG_PUB.LOGMESSAGE('Start_Workflow: ' || 'Return Status >> ' || l_return_status);

885: result => l_result);
886:
887: -- IF PG_DEBUG < 10 THEN
888: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
889: IEX_DEBUG_PUB.LOGMESSAGE('Start_Workflow: ' || 'Return Status >> ' || l_return_status);
890: END IF;
891:
892: if l_return_status = 'COMPLETE' OR l_return_status = 'ACTIVE' THEN
893: x_return_status := 'S';

Line 902: IEX_DEBUG_PUB.LogMessage('PUB: ' || l_api_name || ' end');

898: --DBMS_OUTPUT.PUT_LINE('GET ITEM STATUS = ' || l_return_status);
899: --DBMS_OUTPUT.PUT_LINE('GET ITEM result = ' || l_result);
900:
901: -- Debug Message
902: IEX_DEBUG_PUB.LogMessage('PUB: ' || l_api_name || ' end');
903: IEX_DEBUG_PUB.LogMessage('End time:'
904: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
905:
906: -- Standard call to get message count and if count is 1, get message info.

Line 903: IEX_DEBUG_PUB.LogMessage('End time:'

899: --DBMS_OUTPUT.PUT_LINE('GET ITEM result = ' || l_result);
900:
901: -- Debug Message
902: IEX_DEBUG_PUB.LogMessage('PUB: ' || l_api_name || ' end');
903: IEX_DEBUG_PUB.LogMessage('End time:'
904: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
905:
906: -- Standard call to get message count and if count is 1, get message info.
907: FND_MSG_PUB.Count_And_Get

Line 914: IEX_DEBUG_PUB.LOGMESSAGE('Start_Workflow: ' || '** Start Workflow Message Log End ');

910: );
911:
912: -- IF PG_DEBUG < 10 THEN
913: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
914: IEX_DEBUG_PUB.LOGMESSAGE('Start_Workflow: ' || '************ Start Workflow Message Log End **********');
915: END IF;
916:
917: EXCEPTION
918: WHEN FND_API.G_EXC_ERROR THEN