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

Line 34: IEX_DEBUG_PUB.LogMessage(g_line) ;

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

Line 35: IEX_DEBUG_PUB.LogMessage('GET_PAST_YEAR_INV_INFO --->> Start <<--- ') ;

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;
38:
39: --------------------------------------------------------------

Line 36: IEX_DEBUG_PUB.LogMessage(g_line) ;

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;
38:
39: --------------------------------------------------------------
40: -- Past Year Unpaid Installments

Line 86: iex_debug_pub.logMessage(p_error_msg) ;

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
90: BEGIN

Line 109: iex_debug_pub.logMessage(p_error_msg) ;

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:
113: ELSIF p_filter_mode = 'DEL' then -- added by jypark

Line 133: iex_debug_pub.logMessage(p_error_msg) ;

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
137: BEGIN

Line 154: iex_debug_pub.logMessage(p_error_msg) ;

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:
158: End If ;

Line 165: IEX_DEBUG_PUB.LogMessage(g_line) ;

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

Line 166: IEX_DEBUG_PUB.LogMessage('GET_PAST_YEAR_INV_INFO --->> End <<--- ') ;

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;
169:
170: EXCEPTION

Line 167: IEX_DEBUG_PUB.LogMessage(g_line) ;

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;
169:
170: EXCEPTION
171: WHEN OTHERS THEN

Line 174: iex_debug_pub.logMessage(p_error_msg) ;

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

Line 767: IEX_DEBUG_PUB.LogMessage('Unexpected Error:C_CUSTOMER_PROFILE_CUR - ' || SQLCODE || ' Mesg - ' || SQLERRM) ;

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;
771: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 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) );

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:
783: IF p_filter_mode = 'PARTY' then

Line 780: IEX_DEBUG_PUB.LogMessage(' delinquency_id = ' || to_char(p_delinquency_id) || ' customer_site_use_id= ' || to_char(p_customer_site_use_id)) ;

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:
783: IF p_filter_mode = 'PARTY' then
784: IF NVL(p_using_paying_rel, 'N') = 'Y' THEN

Line 818: IEX_DEBUG_PUB.LogMessage('no values to fetch');

814: open cust_int_get_dt_cur(p_cust_account_id);
815: fetch cust_int_get_dt_cur into
816: start_date_time_val;
817: if (cust_int_get_dt_cur%notfound or start_date_time_val is null) then
818: IEX_DEBUG_PUB.LogMessage('no values to fetch');
819: IEX_DEBUG_PUB.LogMessage('error in fetching values in date_time_cursor');
820: end if;
821: close cust_int_get_dt_cur;
822: end if;

Line 819: IEX_DEBUG_PUB.LogMessage('error in fetching values in date_time_cursor');

815: fetch cust_int_get_dt_cur into
816: start_date_time_val;
817: if (cust_int_get_dt_cur%notfound or start_date_time_val is null) then
818: IEX_DEBUG_PUB.LogMessage('no values to fetch');
819: IEX_DEBUG_PUB.LogMessage('error in fetching values in date_time_cursor');
820: end if;
821: close cust_int_get_dt_cur;
822: end if;
823: close cust_int_get_dt365_cur;

Line 838: IEX_DEBUG_PUB.LogMessage('Unexpected Error:CUST_INT_CUR - ' || SQLCODE || ' Mesg - ' || SQLERRM) ;

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:
842: ELSIF p_filter_mode = 'DEL' then

Line 866: IEX_DEBUG_PUB.LogMessage ( ' Entered in profile check block');

862: l_profile_rec.Last_Contacted_By ,
863: l_profile_rec.Last_Result ;
864: CLOSE CUST_INT_CUR;
865: END IF ;
866: IEX_DEBUG_PUB.LogMessage ( ' Entered in profile check block');
867: IF p_filter_mode = 'PARTY' then
868: IEX_DEBUG_PUB.LogMessage ( 'Entered in PARTY_CUSTOMER_PROFILE_CUR');
869: OPEN PARTY_CUSTOMER_PROFILE_CUR(p_party_id);
870: FETCH PARTY_CUSTOMER_PROFILE_CUR INTO l_profile_rec.collector_name, l_profile_rec.credit_rating;

Line 868: IEX_DEBUG_PUB.LogMessage ( 'Entered in PARTY_CUSTOMER_PROFILE_CUR');

864: CLOSE CUST_INT_CUR;
865: END IF ;
866: IEX_DEBUG_PUB.LogMessage ( ' Entered in profile check block');
867: IF p_filter_mode = 'PARTY' then
868: IEX_DEBUG_PUB.LogMessage ( 'Entered in PARTY_CUSTOMER_PROFILE_CUR');
869: OPEN PARTY_CUSTOMER_PROFILE_CUR(p_party_id);
870: FETCH PARTY_CUSTOMER_PROFILE_CUR INTO l_profile_rec.collector_name, l_profile_rec.credit_rating;
871: CLOSE PARTY_CUSTOMER_PROFILE_CUR;
872: ELSIF p_filter_mode = 'CUST' then

Line 873: IEX_DEBUG_PUB.LogMessage ( 'Entered in CUST_CUSTOMER_PROFILE_CUR');

869: OPEN PARTY_CUSTOMER_PROFILE_CUR(p_party_id);
870: FETCH PARTY_CUSTOMER_PROFILE_CUR INTO l_profile_rec.collector_name, l_profile_rec.credit_rating;
871: CLOSE PARTY_CUSTOMER_PROFILE_CUR;
872: ELSIF p_filter_mode = 'CUST' then
873: IEX_DEBUG_PUB.LogMessage ( 'Entered in CUST_CUSTOMER_PROFILE_CUR');
874: OPEN CUST_CUSTOMER_PROFILE_CUR(p_cust_account_id);
875: FETCH CUST_CUSTOMER_PROFILE_CUR INTO l_profile_rec.collector_name, l_profile_rec.credit_rating;
876: CLOSE CUST_CUSTOMER_PROFILE_CUR;
877: ELSIF p_filter_mode = 'BILL_TO' then

Line 878: IEX_DEBUG_PUB.LogMessage ( 'Entered in SITE_CUSTOMER_PROFILE_CUR');

874: OPEN CUST_CUSTOMER_PROFILE_CUR(p_cust_account_id);
875: FETCH CUST_CUSTOMER_PROFILE_CUR INTO l_profile_rec.collector_name, l_profile_rec.credit_rating;
876: CLOSE CUST_CUSTOMER_PROFILE_CUR;
877: ELSIF p_filter_mode = 'BILL_TO' then
878: IEX_DEBUG_PUB.LogMessage ( 'Entered in SITE_CUSTOMER_PROFILE_CUR');
879: OPEN SITE_CUSTOMER_PROFILE_CUR(p_customer_site_use_id);
880: FETCH SITE_CUSTOMER_PROFILE_CUR INTO l_profile_rec.collector_name, l_profile_rec.credit_rating;
881: CLOSE SITE_CUSTOMER_PROFILE_CUR;
882: ELSIF p_filter_mode= 'DEL' then

Line 884: IEX_DEBUG_PUB.LogMessage ( 'Entered in SITE_CUSTOMER_PROFILE_CUR');

880: FETCH SITE_CUSTOMER_PROFILE_CUR INTO l_profile_rec.collector_name, l_profile_rec.credit_rating;
881: CLOSE SITE_CUSTOMER_PROFILE_CUR;
882: ELSIF p_filter_mode= 'DEL' then
883: IF l_customer_site_use_id IS NOT NULL THEN
884: IEX_DEBUG_PUB.LogMessage ( 'Entered in SITE_CUSTOMER_PROFILE_CUR');
885: OPEN SITE_CUSTOMER_PROFILE_CUR(l_customer_site_use_id);
886: FETCH SITE_CUSTOMER_PROFILE_CUR INTO l_profile_rec.collector_name, l_profile_rec.credit_rating;
887: CLOSE SITE_CUSTOMER_PROFILE_CUR;
888: END IF;

Line 895: IEX_DEBUG_PUB.LogMessage('Unexpected Error:C_CUSTOMER_PROFILE_CUR - ' || SQLCODE || ' Mesg - ' || SQLERRM) ;

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;
899: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 908: IEX_DEBUG_PUB.LogMessage ( ' Enterd in credit limit calculation block');

904:
905: BEGIN
906:
907: -- Begin -- bug#4300281 - 15/4/2005 - vaijayanthi - Calculate 'Include Dunning' value based on Filter Mode
908: IEX_DEBUG_PUB.LogMessage ( ' Enterd in credit limit calculation block');
909:
910: IF p_filter_mode='PARTY' THEN -- Party Level
911: IEX_DEBUG_PUB.LogMessage ( 'Entered in c_party_credit');
912: OPEN c_party_credit(p_party_id , l_conversion_type);

Line 911: IEX_DEBUG_PUB.LogMessage ( 'Entered in c_party_credit');

907: -- Begin -- bug#4300281 - 15/4/2005 - vaijayanthi - Calculate 'Include Dunning' value based on Filter Mode
908: IEX_DEBUG_PUB.LogMessage ( ' Enterd in credit limit calculation block');
909:
910: IF p_filter_mode='PARTY' THEN -- Party Level
911: IEX_DEBUG_PUB.LogMessage ( 'Entered in c_party_credit');
912: OPEN c_party_credit(p_party_id , l_conversion_type);
913: FETCH c_party_credit
914: INTO l_profile_rec.credit_limit_amt, l_profile_rec.credit_status, l_profile_rec.include_dunning, l_profile_rec.credit_limit_amt_curr;
915: CLOSE c_party_credit;

Line 917: IEX_DEBUG_PUB.LogMessage ( 'Entered in c_cust_credit');

913: FETCH c_party_credit
914: INTO l_profile_rec.credit_limit_amt, l_profile_rec.credit_status, l_profile_rec.include_dunning, l_profile_rec.credit_limit_amt_curr;
915: CLOSE c_party_credit;
916: ELSIF p_filter_mode='CUST' THEN -- Account Level
917: IEX_DEBUG_PUB.LogMessage ( 'Entered in c_cust_credit');
918: OPEN c_cust_credit(p_cust_account_id , l_conversion_type);
919: FETCH c_cust_credit
920: INTO l_profile_rec.credit_limit_amt, l_profile_rec.credit_status, l_profile_rec.include_dunning, l_profile_rec.credit_limit_amt_curr;
921: CLOSE c_cust_credit;

Line 930: IEX_DEBUG_PUB.LogMessage('Credit limit amount of cust_account_id = ' || to_char(p_cust_account_id) || 'is ' || l_profile_rec.credit_limit_amt);

926: CLOSE c_site_credit;
927: END IF;
928:
929:
930: IEX_DEBUG_PUB.LogMessage('Credit limit amount of cust_account_id = ' || to_char(p_cust_account_id) || 'is ' || l_profile_rec.credit_limit_amt);
931: IEX_DEBUG_PUB.LogMessage('Credit Status of cust_account_id = ' || to_char(p_cust_account_id) || 'is ' || l_profile_rec.credit_status);
932: IEX_DEBUG_PUB.LogMessage('Include dunning of cust_account_id = ' || to_char(p_cust_account_id) || 'is ' || l_profile_rec.include_dunning);
933: IEX_DEBUG_PUB.LogMessage('Credit amount currency of cust_account_id = ' || to_char(p_cust_account_id) || 'is ' || l_profile_rec.credit_limit_amt_curr);
934:

Line 931: IEX_DEBUG_PUB.LogMessage('Credit Status of cust_account_id = ' || to_char(p_cust_account_id) || 'is ' || l_profile_rec.credit_status);

927: END IF;
928:
929:
930: IEX_DEBUG_PUB.LogMessage('Credit limit amount of cust_account_id = ' || to_char(p_cust_account_id) || 'is ' || l_profile_rec.credit_limit_amt);
931: IEX_DEBUG_PUB.LogMessage('Credit Status of cust_account_id = ' || to_char(p_cust_account_id) || 'is ' || l_profile_rec.credit_status);
932: IEX_DEBUG_PUB.LogMessage('Include dunning of cust_account_id = ' || to_char(p_cust_account_id) || 'is ' || l_profile_rec.include_dunning);
933: IEX_DEBUG_PUB.LogMessage('Credit amount currency of cust_account_id = ' || to_char(p_cust_account_id) || 'is ' || l_profile_rec.credit_limit_amt_curr);
934:
935: -- End for the bug 8630157 by PNAVEENK

Line 932: IEX_DEBUG_PUB.LogMessage('Include dunning of cust_account_id = ' || to_char(p_cust_account_id) || 'is ' || l_profile_rec.include_dunning);

928:
929:
930: IEX_DEBUG_PUB.LogMessage('Credit limit amount of cust_account_id = ' || to_char(p_cust_account_id) || 'is ' || l_profile_rec.credit_limit_amt);
931: IEX_DEBUG_PUB.LogMessage('Credit Status of cust_account_id = ' || to_char(p_cust_account_id) || 'is ' || l_profile_rec.credit_status);
932: IEX_DEBUG_PUB.LogMessage('Include dunning of cust_account_id = ' || to_char(p_cust_account_id) || 'is ' || l_profile_rec.include_dunning);
933: IEX_DEBUG_PUB.LogMessage('Credit amount currency of cust_account_id = ' || to_char(p_cust_account_id) || 'is ' || l_profile_rec.credit_limit_amt_curr);
934:
935: -- End for the bug 8630157 by PNAVEENK
936: --Bug4562698. Null out the Amount if the currency code is null. Start

Line 933: IEX_DEBUG_PUB.LogMessage('Credit amount currency of cust_account_id = ' || to_char(p_cust_account_id) || 'is ' || l_profile_rec.credit_limit_amt_curr);

929:
930: IEX_DEBUG_PUB.LogMessage('Credit limit amount of cust_account_id = ' || to_char(p_cust_account_id) || 'is ' || l_profile_rec.credit_limit_amt);
931: IEX_DEBUG_PUB.LogMessage('Credit Status of cust_account_id = ' || to_char(p_cust_account_id) || 'is ' || l_profile_rec.credit_status);
932: IEX_DEBUG_PUB.LogMessage('Include dunning of cust_account_id = ' || to_char(p_cust_account_id) || 'is ' || l_profile_rec.include_dunning);
933: IEX_DEBUG_PUB.LogMessage('Credit amount currency of cust_account_id = ' || to_char(p_cust_account_id) || 'is ' || l_profile_rec.credit_limit_amt_curr);
934:
935: -- End for the bug 8630157 by PNAVEENK
936: --Bug4562698. Null out the Amount if the currency code is null. Start
937: IF g_curr_rec.base_currency IS NULL THEN

Line 962: IEX_DEBUG_PUB.LogMessage ( ' Enterd in Dunning profile and Credit hold status finding block');

958: END IF; */
959:
960: -- end -- bug#4300281 - 15/4/2005 - vaijayanthi - Calculate 'Include Dunning' value based on Filter Mode
961: -- start bug for 13583293 by sunagesh
962: IEX_DEBUG_PUB.LogMessage ( ' Enterd in Dunning profile and Credit hold status finding block');
963:
964: IF p_filter_mode='PARTY' THEN -- Party Level
965: IEX_DEBUG_PUB.LogMessage ( 'Entered in c_party_profile');
966: OPEN c_party_profile(p_party_id);

Line 965: IEX_DEBUG_PUB.LogMessage ( 'Entered in c_party_profile');

961: -- start bug for 13583293 by sunagesh
962: IEX_DEBUG_PUB.LogMessage ( ' Enterd in Dunning profile and Credit hold status finding block');
963:
964: IF p_filter_mode='PARTY' THEN -- Party Level
965: IEX_DEBUG_PUB.LogMessage ( 'Entered in c_party_profile');
966: OPEN c_party_profile(p_party_id);
967: FETCH c_party_profile
968: INTO l_profile_rec.credit_status, l_profile_rec.include_dunning;
969: CLOSE c_party_profile;

Line 971: IEX_DEBUG_PUB.LogMessage ( 'Entered in c_cust_profile');

967: FETCH c_party_profile
968: INTO l_profile_rec.credit_status, l_profile_rec.include_dunning;
969: CLOSE c_party_profile;
970: ELSIF p_filter_mode='CUST' THEN -- Account Level
971: IEX_DEBUG_PUB.LogMessage ( 'Entered in c_cust_profile');
972: OPEN c_cust_profile(p_cust_account_id );
973: FETCH c_cust_profile
974: INTO l_profile_rec.credit_status, l_profile_rec.include_dunning;
975: CLOSE c_cust_profile;

Line 983: IEX_DEBUG_PUB.LogMessage('Credit Status is ' || l_profile_rec.credit_status);

979: INTO l_profile_rec.credit_status, l_profile_rec.include_dunning;
980: CLOSE c_site_profile;
981: END IF;
982:
983: IEX_DEBUG_PUB.LogMessage('Credit Status is ' || l_profile_rec.credit_status);
984: IEX_DEBUG_PUB.LogMessage('Include dunning is ' || l_profile_rec.include_dunning);
985: -- end bug for 13583293 by sunagesh
986:
987:

Line 984: IEX_DEBUG_PUB.LogMessage('Include dunning is ' || l_profile_rec.include_dunning);

980: CLOSE c_site_profile;
981: END IF;
982:
983: IEX_DEBUG_PUB.LogMessage('Credit Status is ' || l_profile_rec.credit_status);
984: IEX_DEBUG_PUB.LogMessage('Include dunning is ' || l_profile_rec.include_dunning);
985: -- end bug for 13583293 by sunagesh
986:
987:
988: EXCEPTION

Line 992: IEX_DEBUG_PUB.LogMessage('Unexpected Error:C_CREDIT - ' || SQLCODE || ' Mesg - ' || SQLERRM) ;

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;
996: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;