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 FND_LOG

Line 10: PG_DEBUG NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

6: /* ------------------------------------------------------------------------------
7: PROCEDURE ADD_REC
8: ------------------------------------------------------------------------------ */
9: -- PG_DEBUG NUMBER(2) := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
10: PG_DEBUG NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
11:
12: PROCEDURE Add_rec (p_api_version IN NUMBER ,
13: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
14: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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

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

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

113: Exception
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;

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

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

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

180: Exception
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;

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

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

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

249: Exception
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;

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

406: ,X_RETURN_STATUS => X_RETURN_STATUS);
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;

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

530: ,X_RETURN_STATUS => X_RETURN_STATUS);
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;

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

639: ,X_RETURN_STATUS => X_RETURN_STATUS);
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;

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

703: WHERE user_id = p_user_id ;
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

Line 711: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) 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 **********');
713: END IF;
714:
715: -- IF PG_DEBUG < 10 THEN

Line 716: 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
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

Line 720: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) 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'));
722: END IF;
723:
724: -- Standard Start of API savepoint

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

733: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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.

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

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;
755: -- Initialize API return status to SUCCESS
756: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

779: CLOSE Manager_Cur ;
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 ;

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

786: l_manager_id := p_user_id ;
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

Line 795: 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
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

Line 799: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) 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);
801: END IF;
802: Exception
803: WHEN OTHERS THEN

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

801: END IF;
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;

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

813: commit;
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

Line 821: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) 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);
823: END IF;
824:
825: wf_engine.createprocess (

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

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

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

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

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

909: p_data => x_msg_data
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