DBA Data[Home] [Help]

APPS.IEX_DUNNING_PVT dependencies on IEX_UTILITIES

Line 3399: if ( iex_utilities.DunningProfileCheck (

3395: l_delinquency_id_check := null;
3396: elsif (p_running_level = 'BILL_TO') then
3397: l_delinquency_id_check := null;
3398: end if;
3399: if ( iex_utilities.DunningProfileCheck (
3400: p_party_id => l_party_cust_id_check
3401: , p_cust_account_id => l_account_id_check
3402: , p_site_use_id => l_customer_site_use_id_check
3403: , p_delinquency_id => l_delinquency_id_check ) = 'N'

Line 3415: if ( iex_utilities.DunningMinAmountCheck (

3411: end if;
3412:
3413:
3414: -- ctlee - check the hz_customer_profiles_amt min_dunning_invoice_amount and min_dunning_amount
3415: if ( iex_utilities.DunningMinAmountCheck (
3416: p_cust_account_id => l_account_id_check
3417: , p_site_use_id => l_customer_site_use_id_check) = 'N'
3418: ) then
3419: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_DUNNING_AMOUNT_MIN');

Line 4038: if ( iex_utilities.DunningProfileCheck (

4034: *===========================================*/
4035:
4036: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - begin check customer profile');
4037: -- ctlee - check the hz_customer_profiles.dunning_letter
4038: if ( iex_utilities.DunningProfileCheck (
4039: p_party_id => l_party_cust_id
4040: , p_cust_account_id => l_account_id
4041: , p_site_use_id => l_customer_site_use_id
4042: , p_delinquency_id => l_delinquency_id ) = 'N'

Line 4053: if ( iex_utilities.DunningMinAmountCheck (

4049: end if;
4050:
4051:
4052: -- ctlee - check the hz_customer_profiles_amt min_dunning_invoice_amount and min_dunning_amount
4053: if ( iex_utilities.DunningMinAmountCheck (
4054: p_cust_account_id => l_account_id
4055: , p_site_use_id => l_customer_site_use_id) = 'N'
4056: ) then
4057: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_DUNNING_AMOUNT_MIN');

Line 4750: if ( iex_utilities.DunningProfileCheck (

4746: elsif (p_running_level = 'BILL_TO') then
4747: l_delinquency_id_check := null;
4748: end if;
4749:
4750: if ( iex_utilities.DunningProfileCheck (
4751: p_party_id => l_party_cust_id_check
4752: , p_cust_account_id => l_account_id_check
4753: , p_site_use_id => l_customer_site_use_id_check
4754: , p_delinquency_id => l_delinquency_id_check ) = 'N'

Line 4765: if ( iex_utilities.DunningMinAmountCheck (

4761: end if;
4762:
4763:
4764: -- ctlee - check the hz_customer_profiles_amt min_dunning_invoice_amount and min_dunning_amount
4765: if ( iex_utilities.DunningMinAmountCheck (
4766: p_cust_account_id => l_account_id_check
4767: , p_site_use_id => l_customer_site_use_id_check) = 'N'
4768: ) then
4769: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_DUNNING_AMOUNT_MIN');

Line 5365: if ( iex_utilities.DunningProfileCheck (

5361: *===========================================*/
5362:
5363: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - begin check customer profile');
5364: -- ctlee - check the hz_customer_profiles.dunning_letter
5365: if ( iex_utilities.DunningProfileCheck (
5366: p_party_id => l_party_cust_id
5367: , p_cust_account_id => l_account_id
5368: , p_site_use_id => l_customer_site_use_id
5369: , p_delinquency_id => l_delinquency_id ) = 'N'

Line 5379: if ( iex_utilities.DunningMinAmountCheck (

5375: end if;
5376:
5377:
5378: -- ctlee - check the hz_customer_profiles_amt min_dunning_invoice_amount and min_dunning_amount
5379: if ( iex_utilities.DunningMinAmountCheck (
5380: p_cust_account_id => l_account_id
5381: , p_site_use_id => l_customer_site_use_id) = 'N'
5382: ) then
5383: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_DUNNING_AMOUNT_MIN');

Line 9092: l_resource_tab iex_utilities.resource_tab_type;

9088: --
9089: errmsg varchar2(30000);
9090:
9091: --Added for bug#5229763 schekuri 27-Jul-2006
9092: l_resource_tab iex_utilities.resource_tab_type;
9093: l_return_status VARCHAR2(1);
9094: l_msg_count NUMBER;
9095: l_msg_data VARCHAR2(32767);
9096: l_validation_level NUMBER ;

Line 9205: --Called iex_utilities.get_assigned_collector to get the resource from hz_customer_profiles table

9201: -- clchang updated 09/20/2002 for bug 2242346
9202: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Call GET_RESOURCE');
9203: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - partyid='||l_party_cust_id);
9204: --Begin Bug#5229763 schekuri 27-Jul-2006
9205: --Called iex_utilities.get_assigned_collector to get the resource from hz_customer_profiles table
9206: --instead of as_accesses. Removed the call to "get_resource".
9207: if l_customer_site_use_id is not null then
9208: iex_utilities.get_assigned_collector(p_api_version => l_api_version,
9209: p_init_msg_list => FND_API.G_TRUE,

Line 9208: iex_utilities.get_assigned_collector(p_api_version => l_api_version,

9204: --Begin Bug#5229763 schekuri 27-Jul-2006
9205: --Called iex_utilities.get_assigned_collector to get the resource from hz_customer_profiles table
9206: --instead of as_accesses. Removed the call to "get_resource".
9207: if l_customer_site_use_id is not null then
9208: iex_utilities.get_assigned_collector(p_api_version => l_api_version,
9209: p_init_msg_list => FND_API.G_TRUE,
9210: p_commit => FND_API.G_FALSE,
9211: p_validation_level => l_validation_level,
9212: p_level => 'DUNNING_BILLTO',

Line 9226: iex_utilities.get_assigned_collector(p_api_version => l_api_version,

9222: END IF;
9223: end if;
9224:
9225: if l_resource_tab.count<1 and l_account_id is not null then
9226: iex_utilities.get_assigned_collector(p_api_version => l_api_version,
9227: p_init_msg_list => FND_API.G_TRUE,
9228: p_commit => FND_API.G_FALSE,
9229: p_validation_level => l_validation_level,
9230: p_level => 'DUNNING_ACCOUNT',

Line 9244: iex_utilities.get_assigned_collector(p_api_version => l_api_version,

9240: END IF;
9241: end if;
9242:
9243: if l_resource_tab.count<1 and l_party_cust_id is not null then
9244: iex_utilities.get_assigned_collector(p_api_version => l_api_version,
9245: p_init_msg_list => FND_API.G_TRUE,
9246: p_commit => FND_API.G_FALSE,
9247: p_validation_level => l_validation_level,
9248: p_level => 'DUNNING_PARTY',

Line 9261: iex_utilities.get_assigned_collector(p_api_version => l_api_version,

9257: GOTO end_new_task;
9258: END IF;
9259:
9260: if l_resource_tab.count<1 and p_dunning_level = 'CUSTOMER' then
9261: iex_utilities.get_assigned_collector(p_api_version => l_api_version,
9262: p_init_msg_list => FND_API.G_TRUE,
9263: p_commit => FND_API.G_FALSE,
9264: p_validation_level => l_validation_level,
9265: p_level => 'DUNNING_PARTY_ACCOUNT',

Line 9489: --Removed all the code to replace the usage of this procedure with iex_utilities.get_assigned_collector

9485: * 4. if taskcount > 0,
9486: * get the resource_id which has the least tasks;
9487: *
9488: *========================================================================*/
9489: --Removed all the code to replace the usage of this procedure with iex_utilities.get_assigned_collector
9490: --for bug#5229763 schekuri 27-Jul-2006
9491: --iex_utilities.get_assigned_collector uses hz_customer_profiles to get resource instead of as_accesses
9492: PROCEDURE Get_Resource(p_api_version IN NUMBER,
9493: p_commit IN VARCHAR2,

Line 9491: --iex_utilities.get_assigned_collector uses hz_customer_profiles to get resource instead of as_accesses

9487: *
9488: *========================================================================*/
9489: --Removed all the code to replace the usage of this procedure with iex_utilities.get_assigned_collector
9490: --for bug#5229763 schekuri 27-Jul-2006
9491: --iex_utilities.get_assigned_collector uses hz_customer_profiles to get resource instead of as_accesses
9492: PROCEDURE Get_Resource(p_api_version IN NUMBER,
9493: p_commit IN VARCHAR2,
9494: p_init_msg_list IN VARCHAR2 ,
9495: p_party_id IN NUMBER,