APPS.IEX_PROFILE dependencies on FND_LOG

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

762:
763: END IF ;
764: EXCEPTION
765: WHEN OTHERS THEN
766: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
767: IEX_DEBUG_PUB.LogMessage('Unexpected Error:C_CUSTOMER_PROFILE_CUR - ' || SQLCODE || ' Mesg - ' || SQLERRM) ;
768: END IF;
769: ROLLBACK TO Get_Profile_Info_PVT;
770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

774: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
775: END ;
776:
777: BEGIN
778: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
779: 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) );
780: IEX_DEBUG_PUB.LogMessage(' delinquency_id = ' || to_char(p_delinquency_id) || ' customer_site_use_id= ' || to_char(p_customer_site_use_id)) ;
781: END IF;
782:

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

833: l_profile_rec.Last_Result;
834: CLOSE CUST_INT_CUR ;
835: exception
836: when others then
837: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
838: IEX_DEBUG_PUB.LogMessage('Unexpected Error:CUST_INT_CUR - ' || SQLCODE || ' Mesg - ' || SQLERRM) ;
839: END IF;
840: end;
841:

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

890:
891:
892: EXCEPTION
893: WHEN OTHERS THEN
894: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
895: IEX_DEBUG_PUB.LogMessage('Unexpected Error:C_CUSTOMER_PROFILE_CUR - ' || SQLCODE || ' Mesg - ' || SQLERRM) ;
896: END IF;
897: ROLLBACK TO Get_Profile_Info_PVT;
898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

987:
988: EXCEPTION
989: WHEN OTHERS THEN
990:
991: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
992: IEX_DEBUG_PUB.LogMessage('Unexpected Error:C_CREDIT - ' || SQLCODE || ' Mesg - ' || SQLERRM) ;
993:
994: END IF;
995: ROLLBACK TO Get_Profile_Info_PVT;

Line 1033: PG_DEBUG := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1029: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1030: END GET_PROFILE_INFO;
1031:
1032: BEGIN
1033: PG_DEBUG := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1034: g_line := '-----------------------------------------' ;
1035: --Bug4562698. Moved the Constructor to GET_PROFILE_INFO. Begin
1036: /* SELECT sob.currency_code
1037: INTO g_curr_rec.base_currency