APPS.IEX_PROFILE dependencies on FND_LOG

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

28: p_late_inv OUT NOCOPY Number,
29: p_error_msg OUT NOCOPY Varchar2)
30: IS
31: BEGIN
32: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
33: IEX_DEBUG_PUB.LogMessage(g_line) ;
34: IEX_DEBUG_PUB.LogMessage('GET_PAST_YEAR_INV_INFO --->> Start <<--- ') ;
35: IEX_DEBUG_PUB.LogMessage(g_line) ;
36: END IF;

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

80: WHEN OTHERS THEN
81: p_error_msg :=
82: 'Get Past Year Invoice Info >> Party >> Unpaid Installments'
83: || SQLCODE || ' << ' || SQLERRM ;
84: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
85: iex_debug_pub.logMessage(p_error_msg) ;
86: END IF;
87: End ;
88: ELSIF p_filter_mode = 'CUST' then

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

103: WHEN OTHERS THEN
104: p_error_msg :=
105: 'Get Past Year Invoice Info >> Cust >> Unpaid Installments'
106: || SQLCODE || ' << ' || SQLERRM ;
107: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
108: iex_debug_pub.logMessage(p_error_msg) ;
109: END IF;
110: End ;
111:

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

127: WHEN OTHERS THEN
128: p_error_msg :=
129: 'Get Past Year Invoice Info >> Del >> Unpaid Installments'
130: || SQLCODE || ' << ' || SQLERRM ;
131: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
132: iex_debug_pub.logMessage(p_error_msg) ;
133: END IF;
134: End ;
135: ELSIF p_filter_mode = 'BILL_TO' then -- added by jypark

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

148: WHEN OTHERS THEN
149: p_error_msg :=
150: 'Get Past Year Invoice Info >> Del >> Unpaid Installments'
151: || SQLCODE || ' << ' || SQLERRM ;
152: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
153: iex_debug_pub.logMessage(p_error_msg) ;
154: END IF;
155: End ;
156:

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

159: -- Calculating Total Transactions (Sum of Unpaid, Late and Ontime)
160: p_total_inv := p_unpaid_inv + p_late_inv + p_ontime_inv ;
161: p_error_msg := null ;
162:
163: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
164: IEX_DEBUG_PUB.LogMessage(g_line) ;
165: IEX_DEBUG_PUB.LogMessage('GET_PAST_YEAR_INV_INFO --->> End <<--- ') ;
166: IEX_DEBUG_PUB.LogMessage(g_line) ;
167: END IF;

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

168:
169: EXCEPTION
170: WHEN OTHERS THEN
171: p_error_msg := 'Get Past Year Invoice Info >> ' || SQLCODE || ' << ' || SQLERRM ;
172: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
173: iex_debug_pub.logMessage(p_error_msg) ;
174: END IF;
175: End Get_past_year_inv_info;
176:

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

644:
645: END IF ;
646: EXCEPTION
647: WHEN OTHERS THEN
648: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
649: IEX_DEBUG_PUB.LogMessage('Unexpected Error:C_CUSTOMER_PROFILE_CUR - ' || SQLCODE || ' Mesg - ' || SQLERRM) ;
650: END IF;
651: ROLLBACK TO Get_Profile_Info_PVT;
652: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

656: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
657: END ;
658:
659: BEGIN
660: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
661: IEX_DEBUG_PUB.LogMessage('Filter Mode = ' || p_Filter_mode || ' party_id = ' || to_char(p_party_id) || ' cust_account_id = ' || to_char(p_cust_account_id) );
662: IEX_DEBUG_PUB.LogMessage(' delinquency_id = ' || to_char(p_delinquency_id) || ' customer_site_use_id= ' || to_char(p_customer_site_use_id)) ;
663: END IF;
664:

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

736:
737:
738: EXCEPTION
739: WHEN OTHERS THEN
740: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
741: IEX_DEBUG_PUB.LogMessage('Unexpected Error:C_CUSTOMER_PROFILE_CUR - ' || SQLCODE || ' Mesg - ' || SQLERRM) ;
742: END IF;
743: ROLLBACK TO Get_Profile_Info_PVT;
744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

798:
799: EXCEPTION
800: WHEN OTHERS THEN
801:
802: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
803: IEX_DEBUG_PUB.LogMessage('Unexpected Error:C_CREDIT - ' || SQLCODE || ' Mesg - ' || SQLERRM) ;
804:
805: END IF;
806: ROLLBACK TO Get_Profile_Info_PVT;

Line 844: PG_DEBUG := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

840: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
841: END GET_PROFILE_INFO;
842:
843: BEGIN
844: PG_DEBUG := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
845: g_line := '-----------------------------------------' ;
846: --Bug4562698. Moved the Constructor to GET_PROFILE_INFO. Begin
847: /* SELECT sob.currency_code
848: INTO g_curr_rec.base_currency