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.HZ_ACCOUNT_VALIDATE_V2PUB dependencies on HZ_CUST_SITE_USES

Line 2796: l_cust_acct_site_use_code HZ_CUST_SITE_USES.SITE_USE_CODE%TYPE;

2792: l_next_credit_review_date HZ_CUSTOMER_PROFILES.NEXT_CREDIT_REVIEW_DATE%TYPE;
2793: l_party_id HZ_CUSTOMER_PROFILES.PARTY_ID%TYPE;
2794: l_credit_classification HZ_CUSTOMER_PROFILES.CREDIT_CLASSIFICATION%TYPE;
2795:
2796: l_cust_acct_site_use_code HZ_CUST_SITE_USES.SITE_USE_CODE%TYPE;
2797: l_return_status VARCHAR2(1);
2798: l_org_id HZ_CUST_ACCT_SITES_ALL.org_id%TYPE;
2799:
2800: l_ckeck_acc_bfb_enabled VARCHAR2(1);

Line 3424: -- site_use_id is foreign key to hz_cust_site_uses.

3420:
3421: END IF;
3422:
3423: ------------------
3424: -- site_use_id is foreign key to hz_cust_site_uses.
3425: -- one site use can only have one profile.
3426: -- Since site_use_id is non-updateable, we only need to check
3427: -- FK during creation.
3428: ------------------

Line 3444: FROM HZ_CUST_SITE_USES_ALL

3440: BEGIN
3441:
3442: SELECT CUST_ACCT_SITE_ID,SITE_USE_CODE,ORG_ID
3443: INTO l_cust_acct_site_id,l_cust_acct_site_use_code,l_org_id
3444: FROM HZ_CUST_SITE_USES_ALL
3445: WHERE SITE_USE_ID = p_customer_profile_rec.site_use_id;
3446:
3447: -- Bug 4650473. Check if org is accessible.
3448: BEGIN

Line 3479: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_site_uses' );

3475: WHEN NO_DATA_FOUND THEN
3476: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
3477: FND_MESSAGE.SET_TOKEN( 'FK', 'site_use_id' );
3478: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'site_use_id' );
3479: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_site_uses' );
3480: FND_MSG_PUB.ADD;
3481: x_return_status := FND_API.G_RET_STS_ERROR;
3482: END;
3483:

Line 3485: hz_utility_v2pub.debug(p_message=>'site_use_id is foreign key to hz_cust_site_uses. ' ||

3481: x_return_status := FND_API.G_RET_STS_ERROR;
3482: END;
3483:
3484: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3485: hz_utility_v2pub.debug(p_message=>'site_use_id is foreign key to hz_cust_site_uses. ' ||
3486: 'x_return_status = ' || x_return_status,
3487: p_prefix =>l_debug_prefix,
3488: p_msg_level=>fnd_log.level_statement);
3489: END IF;

Line 5976: -- site_use_id is foreign key to hz_cust_site_uses

5972: p_msg_level=>fnd_log.level_statement);
5973: END IF;
5974: END IF;
5975:
5976: -- site_use_id is foreign key to hz_cust_site_uses
5977: -- Since site_use_id is non-updateable, we only need to
5978: -- check FK during creation.
5979:
5980: IF p_create_update_flag = 'C' AND

Line 5992: hz_utility_v2pub.debug(p_message=>'site_use_id is foreign key to hz_cust_site_uses. ' ||

5988: p_column_value => p_cust_profile_amt_rec.site_use_id,
5989: x_return_status => x_return_status );
5990:
5991: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5992: hz_utility_v2pub.debug(p_message=>'site_use_id is foreign key to hz_cust_site_uses. ' ||
5993: 'x_return_status = ' || x_return_status,
5994: p_prefix =>l_debug_prefix,
5995: p_msg_level=>fnd_log.level_statement);
5996: END IF;

Line 7498: * against hz_cust_site_uses_all table instead of the

7494: * 06-13-2002 P.Suresh Bug No : 2403263. Added validation that the contact_id
7495: * should be a foreign key to hz_cust_account_roles.
7496: * cust_account_role_id.
7497: * 06-19-2002 Rajeshwari P Bug 2399491.Validating site_use_id for duplicates
7498: * against hz_cust_site_uses_all table instead of the
7499: * org stripped view, hz_cust_site_uses.
7500: * 03-May-3004 Venkata Sowjanya S Bug No : 3609601. Commented the statements which sets tokens Column1,Column2
7501: * for message HZ_API_INACTIVE_CANNOT_PRIM
7502: * 12-MAY-2005 Rajib Ranjan Borah o TCA SSA Uptake (Bug 3456489)

Line 7499: * org stripped view, hz_cust_site_uses.

7495: * should be a foreign key to hz_cust_account_roles.
7496: * cust_account_role_id.
7497: * 06-19-2002 Rajeshwari P Bug 2399491.Validating site_use_id for duplicates
7498: * against hz_cust_site_uses_all table instead of the
7499: * org stripped view, hz_cust_site_uses.
7500: * 03-May-3004 Venkata Sowjanya S Bug No : 3609601. Commented the statements which sets tokens Column1,Column2
7501: * for message HZ_API_INACTIVE_CANNOT_PRIM
7502: * 12-MAY-2005 Rajib Ranjan Borah o TCA SSA Uptake (Bug 3456489)
7503: */

Line 7518: l_site_use_code HZ_CUST_SITE_USES.site_use_code%TYPE;

7514: l_dummy VARCHAR2(1);
7515: l_profile AR_SYSTEM_PARAMETERS.auto_site_numbering%TYPE;
7516:
7517: l_cust_acct_site_id NUMBER;
7518: l_site_use_code HZ_CUST_SITE_USES.site_use_code%TYPE;
7519: l_cust_account_id NUMBER;
7520: l_orig_system_reference HZ_CUST_SITE_USES.orig_system_reference%TYPE;
7521: l_created_by_module HZ_CUST_SITE_USES.created_by_module%TYPE;
7522: l_application_id NUMBER;

Line 7520: l_orig_system_reference HZ_CUST_SITE_USES.orig_system_reference%TYPE;

7516:
7517: l_cust_acct_site_id NUMBER;
7518: l_site_use_code HZ_CUST_SITE_USES.site_use_code%TYPE;
7519: l_cust_account_id NUMBER;
7520: l_orig_system_reference HZ_CUST_SITE_USES.orig_system_reference%TYPE;
7521: l_created_by_module HZ_CUST_SITE_USES.created_by_module%TYPE;
7522: l_application_id NUMBER;
7523: l_status HZ_CUST_SITE_USES.status%TYPE;
7524: l_ship_via HZ_CUST_SITE_USES.ship_via%TYPE;

Line 7521: l_created_by_module HZ_CUST_SITE_USES.created_by_module%TYPE;

7517: l_cust_acct_site_id NUMBER;
7518: l_site_use_code HZ_CUST_SITE_USES.site_use_code%TYPE;
7519: l_cust_account_id NUMBER;
7520: l_orig_system_reference HZ_CUST_SITE_USES.orig_system_reference%TYPE;
7521: l_created_by_module HZ_CUST_SITE_USES.created_by_module%TYPE;
7522: l_application_id NUMBER;
7523: l_status HZ_CUST_SITE_USES.status%TYPE;
7524: l_ship_via HZ_CUST_SITE_USES.ship_via%TYPE;
7525: l_freight_term HZ_CUST_SITE_USES.freight_term%TYPE;

Line 7523: l_status HZ_CUST_SITE_USES.status%TYPE;

7519: l_cust_account_id NUMBER;
7520: l_orig_system_reference HZ_CUST_SITE_USES.orig_system_reference%TYPE;
7521: l_created_by_module HZ_CUST_SITE_USES.created_by_module%TYPE;
7522: l_application_id NUMBER;
7523: l_status HZ_CUST_SITE_USES.status%TYPE;
7524: l_ship_via HZ_CUST_SITE_USES.ship_via%TYPE;
7525: l_freight_term HZ_CUST_SITE_USES.freight_term%TYPE;
7526: l_ship_sets_inc_lines_f HZ_CUST_SITE_USES.ship_sets_include_lines_flag%TYPE;
7527: l_arrivalsets_inc_lines_f HZ_CUST_SITE_USES.arrivalsets_include_lines_flag%TYPE;

Line 7524: l_ship_via HZ_CUST_SITE_USES.ship_via%TYPE;

7520: l_orig_system_reference HZ_CUST_SITE_USES.orig_system_reference%TYPE;
7521: l_created_by_module HZ_CUST_SITE_USES.created_by_module%TYPE;
7522: l_application_id NUMBER;
7523: l_status HZ_CUST_SITE_USES.status%TYPE;
7524: l_ship_via HZ_CUST_SITE_USES.ship_via%TYPE;
7525: l_freight_term HZ_CUST_SITE_USES.freight_term%TYPE;
7526: l_ship_sets_inc_lines_f HZ_CUST_SITE_USES.ship_sets_include_lines_flag%TYPE;
7527: l_arrivalsets_inc_lines_f HZ_CUST_SITE_USES.arrivalsets_include_lines_flag%TYPE;
7528: l_tax_code HZ_CUST_SITE_USES.tax_code%TYPE;

Line 7525: l_freight_term HZ_CUST_SITE_USES.freight_term%TYPE;

7521: l_created_by_module HZ_CUST_SITE_USES.created_by_module%TYPE;
7522: l_application_id NUMBER;
7523: l_status HZ_CUST_SITE_USES.status%TYPE;
7524: l_ship_via HZ_CUST_SITE_USES.ship_via%TYPE;
7525: l_freight_term HZ_CUST_SITE_USES.freight_term%TYPE;
7526: l_ship_sets_inc_lines_f HZ_CUST_SITE_USES.ship_sets_include_lines_flag%TYPE;
7527: l_arrivalsets_inc_lines_f HZ_CUST_SITE_USES.arrivalsets_include_lines_flag%TYPE;
7528: l_tax_code HZ_CUST_SITE_USES.tax_code%TYPE;
7529: l_payment_term_id HZ_CUST_SITE_USES.payment_term_id%TYPE;

Line 7526: l_ship_sets_inc_lines_f HZ_CUST_SITE_USES.ship_sets_include_lines_flag%TYPE;

7522: l_application_id NUMBER;
7523: l_status HZ_CUST_SITE_USES.status%TYPE;
7524: l_ship_via HZ_CUST_SITE_USES.ship_via%TYPE;
7525: l_freight_term HZ_CUST_SITE_USES.freight_term%TYPE;
7526: l_ship_sets_inc_lines_f HZ_CUST_SITE_USES.ship_sets_include_lines_flag%TYPE;
7527: l_arrivalsets_inc_lines_f HZ_CUST_SITE_USES.arrivalsets_include_lines_flag%TYPE;
7528: l_tax_code HZ_CUST_SITE_USES.tax_code%TYPE;
7529: l_payment_term_id HZ_CUST_SITE_USES.payment_term_id%TYPE;
7530: l_demand_class_code HZ_CUST_SITE_USES.demand_class_code%TYPE;

Line 7527: l_arrivalsets_inc_lines_f HZ_CUST_SITE_USES.arrivalsets_include_lines_flag%TYPE;

7523: l_status HZ_CUST_SITE_USES.status%TYPE;
7524: l_ship_via HZ_CUST_SITE_USES.ship_via%TYPE;
7525: l_freight_term HZ_CUST_SITE_USES.freight_term%TYPE;
7526: l_ship_sets_inc_lines_f HZ_CUST_SITE_USES.ship_sets_include_lines_flag%TYPE;
7527: l_arrivalsets_inc_lines_f HZ_CUST_SITE_USES.arrivalsets_include_lines_flag%TYPE;
7528: l_tax_code HZ_CUST_SITE_USES.tax_code%TYPE;
7529: l_payment_term_id HZ_CUST_SITE_USES.payment_term_id%TYPE;
7530: l_demand_class_code HZ_CUST_SITE_USES.demand_class_code%TYPE;
7531: l_primary_salesrep_id HZ_CUST_SITE_USES.primary_salesrep_id%TYPE;

Line 7528: l_tax_code HZ_CUST_SITE_USES.tax_code%TYPE;

7524: l_ship_via HZ_CUST_SITE_USES.ship_via%TYPE;
7525: l_freight_term HZ_CUST_SITE_USES.freight_term%TYPE;
7526: l_ship_sets_inc_lines_f HZ_CUST_SITE_USES.ship_sets_include_lines_flag%TYPE;
7527: l_arrivalsets_inc_lines_f HZ_CUST_SITE_USES.arrivalsets_include_lines_flag%TYPE;
7528: l_tax_code HZ_CUST_SITE_USES.tax_code%TYPE;
7529: l_payment_term_id HZ_CUST_SITE_USES.payment_term_id%TYPE;
7530: l_demand_class_code HZ_CUST_SITE_USES.demand_class_code%TYPE;
7531: l_primary_salesrep_id HZ_CUST_SITE_USES.primary_salesrep_id%TYPE;
7532: l_finchrg_receivables_trx_id HZ_CUST_SITE_USES.FINCHRG_RECEIVABLES_TRX_ID%TYPE;

Line 7529: l_payment_term_id HZ_CUST_SITE_USES.payment_term_id%TYPE;

7525: l_freight_term HZ_CUST_SITE_USES.freight_term%TYPE;
7526: l_ship_sets_inc_lines_f HZ_CUST_SITE_USES.ship_sets_include_lines_flag%TYPE;
7527: l_arrivalsets_inc_lines_f HZ_CUST_SITE_USES.arrivalsets_include_lines_flag%TYPE;
7528: l_tax_code HZ_CUST_SITE_USES.tax_code%TYPE;
7529: l_payment_term_id HZ_CUST_SITE_USES.payment_term_id%TYPE;
7530: l_demand_class_code HZ_CUST_SITE_USES.demand_class_code%TYPE;
7531: l_primary_salesrep_id HZ_CUST_SITE_USES.primary_salesrep_id%TYPE;
7532: l_finchrg_receivables_trx_id HZ_CUST_SITE_USES.FINCHRG_RECEIVABLES_TRX_ID%TYPE;
7533: l_order_type_id HZ_CUST_SITE_USES.ORDER_TYPE_ID%TYPE;

Line 7530: l_demand_class_code HZ_CUST_SITE_USES.demand_class_code%TYPE;

7526: l_ship_sets_inc_lines_f HZ_CUST_SITE_USES.ship_sets_include_lines_flag%TYPE;
7527: l_arrivalsets_inc_lines_f HZ_CUST_SITE_USES.arrivalsets_include_lines_flag%TYPE;
7528: l_tax_code HZ_CUST_SITE_USES.tax_code%TYPE;
7529: l_payment_term_id HZ_CUST_SITE_USES.payment_term_id%TYPE;
7530: l_demand_class_code HZ_CUST_SITE_USES.demand_class_code%TYPE;
7531: l_primary_salesrep_id HZ_CUST_SITE_USES.primary_salesrep_id%TYPE;
7532: l_finchrg_receivables_trx_id HZ_CUST_SITE_USES.FINCHRG_RECEIVABLES_TRX_ID%TYPE;
7533: l_order_type_id HZ_CUST_SITE_USES.ORDER_TYPE_ID%TYPE;
7534: l_price_list_id HZ_CUST_SITE_USES.PRICE_LIST_ID%TYPE;

Line 7531: l_primary_salesrep_id HZ_CUST_SITE_USES.primary_salesrep_id%TYPE;

7527: l_arrivalsets_inc_lines_f HZ_CUST_SITE_USES.arrivalsets_include_lines_flag%TYPE;
7528: l_tax_code HZ_CUST_SITE_USES.tax_code%TYPE;
7529: l_payment_term_id HZ_CUST_SITE_USES.payment_term_id%TYPE;
7530: l_demand_class_code HZ_CUST_SITE_USES.demand_class_code%TYPE;
7531: l_primary_salesrep_id HZ_CUST_SITE_USES.primary_salesrep_id%TYPE;
7532: l_finchrg_receivables_trx_id HZ_CUST_SITE_USES.FINCHRG_RECEIVABLES_TRX_ID%TYPE;
7533: l_order_type_id HZ_CUST_SITE_USES.ORDER_TYPE_ID%TYPE;
7534: l_price_list_id HZ_CUST_SITE_USES.PRICE_LIST_ID%TYPE;
7535: -- l_ship_partial HZ_CUST_SITE_USES.SHIP_PARTIAL%TYPE;

Line 7532: l_finchrg_receivables_trx_id HZ_CUST_SITE_USES.FINCHRG_RECEIVABLES_TRX_ID%TYPE;

7528: l_tax_code HZ_CUST_SITE_USES.tax_code%TYPE;
7529: l_payment_term_id HZ_CUST_SITE_USES.payment_term_id%TYPE;
7530: l_demand_class_code HZ_CUST_SITE_USES.demand_class_code%TYPE;
7531: l_primary_salesrep_id HZ_CUST_SITE_USES.primary_salesrep_id%TYPE;
7532: l_finchrg_receivables_trx_id HZ_CUST_SITE_USES.FINCHRG_RECEIVABLES_TRX_ID%TYPE;
7533: l_order_type_id HZ_CUST_SITE_USES.ORDER_TYPE_ID%TYPE;
7534: l_price_list_id HZ_CUST_SITE_USES.PRICE_LIST_ID%TYPE;
7535: -- l_ship_partial HZ_CUST_SITE_USES.SHIP_PARTIAL%TYPE;
7536: l_fob_point HZ_CUST_SITE_USES.FOB_POINT%TYPE;

Line 7533: l_order_type_id HZ_CUST_SITE_USES.ORDER_TYPE_ID%TYPE;

7529: l_payment_term_id HZ_CUST_SITE_USES.payment_term_id%TYPE;
7530: l_demand_class_code HZ_CUST_SITE_USES.demand_class_code%TYPE;
7531: l_primary_salesrep_id HZ_CUST_SITE_USES.primary_salesrep_id%TYPE;
7532: l_finchrg_receivables_trx_id HZ_CUST_SITE_USES.FINCHRG_RECEIVABLES_TRX_ID%TYPE;
7533: l_order_type_id HZ_CUST_SITE_USES.ORDER_TYPE_ID%TYPE;
7534: l_price_list_id HZ_CUST_SITE_USES.PRICE_LIST_ID%TYPE;
7535: -- l_ship_partial HZ_CUST_SITE_USES.SHIP_PARTIAL%TYPE;
7536: l_fob_point HZ_CUST_SITE_USES.FOB_POINT%TYPE;
7537: l_item_cross_ref_pref HZ_CUST_SITE_USES.ITEM_CROSS_REF_PREF%TYPE;

Line 7534: l_price_list_id HZ_CUST_SITE_USES.PRICE_LIST_ID%TYPE;

7530: l_demand_class_code HZ_CUST_SITE_USES.demand_class_code%TYPE;
7531: l_primary_salesrep_id HZ_CUST_SITE_USES.primary_salesrep_id%TYPE;
7532: l_finchrg_receivables_trx_id HZ_CUST_SITE_USES.FINCHRG_RECEIVABLES_TRX_ID%TYPE;
7533: l_order_type_id HZ_CUST_SITE_USES.ORDER_TYPE_ID%TYPE;
7534: l_price_list_id HZ_CUST_SITE_USES.PRICE_LIST_ID%TYPE;
7535: -- l_ship_partial HZ_CUST_SITE_USES.SHIP_PARTIAL%TYPE;
7536: l_fob_point HZ_CUST_SITE_USES.FOB_POINT%TYPE;
7537: l_item_cross_ref_pref HZ_CUST_SITE_USES.ITEM_CROSS_REF_PREF%TYPE;
7538: l_warehouse_id HZ_CUST_SITE_USES.WAREHOUSE_ID%TYPE;

Line 7535: -- l_ship_partial HZ_CUST_SITE_USES.SHIP_PARTIAL%TYPE;

7531: l_primary_salesrep_id HZ_CUST_SITE_USES.primary_salesrep_id%TYPE;
7532: l_finchrg_receivables_trx_id HZ_CUST_SITE_USES.FINCHRG_RECEIVABLES_TRX_ID%TYPE;
7533: l_order_type_id HZ_CUST_SITE_USES.ORDER_TYPE_ID%TYPE;
7534: l_price_list_id HZ_CUST_SITE_USES.PRICE_LIST_ID%TYPE;
7535: -- l_ship_partial HZ_CUST_SITE_USES.SHIP_PARTIAL%TYPE;
7536: l_fob_point HZ_CUST_SITE_USES.FOB_POINT%TYPE;
7537: l_item_cross_ref_pref HZ_CUST_SITE_USES.ITEM_CROSS_REF_PREF%TYPE;
7538: l_warehouse_id HZ_CUST_SITE_USES.WAREHOUSE_ID%TYPE;
7539: l_date_type_preference HZ_CUST_SITE_USES.DATE_TYPE_PREFERENCE%TYPE;

Line 7536: l_fob_point HZ_CUST_SITE_USES.FOB_POINT%TYPE;

7532: l_finchrg_receivables_trx_id HZ_CUST_SITE_USES.FINCHRG_RECEIVABLES_TRX_ID%TYPE;
7533: l_order_type_id HZ_CUST_SITE_USES.ORDER_TYPE_ID%TYPE;
7534: l_price_list_id HZ_CUST_SITE_USES.PRICE_LIST_ID%TYPE;
7535: -- l_ship_partial HZ_CUST_SITE_USES.SHIP_PARTIAL%TYPE;
7536: l_fob_point HZ_CUST_SITE_USES.FOB_POINT%TYPE;
7537: l_item_cross_ref_pref HZ_CUST_SITE_USES.ITEM_CROSS_REF_PREF%TYPE;
7538: l_warehouse_id HZ_CUST_SITE_USES.WAREHOUSE_ID%TYPE;
7539: l_date_type_preference HZ_CUST_SITE_USES.DATE_TYPE_PREFERENCE%TYPE;
7540: -- l_ship_sets_include_lines_flag HZ_CUST_SITE_USES.SHIP_SETS_INCLUDE_LINES_FLAG%TYPE;

Line 7537: l_item_cross_ref_pref HZ_CUST_SITE_USES.ITEM_CROSS_REF_PREF%TYPE;

7533: l_order_type_id HZ_CUST_SITE_USES.ORDER_TYPE_ID%TYPE;
7534: l_price_list_id HZ_CUST_SITE_USES.PRICE_LIST_ID%TYPE;
7535: -- l_ship_partial HZ_CUST_SITE_USES.SHIP_PARTIAL%TYPE;
7536: l_fob_point HZ_CUST_SITE_USES.FOB_POINT%TYPE;
7537: l_item_cross_ref_pref HZ_CUST_SITE_USES.ITEM_CROSS_REF_PREF%TYPE;
7538: l_warehouse_id HZ_CUST_SITE_USES.WAREHOUSE_ID%TYPE;
7539: l_date_type_preference HZ_CUST_SITE_USES.DATE_TYPE_PREFERENCE%TYPE;
7540: -- l_ship_sets_include_lines_flag HZ_CUST_SITE_USES.SHIP_SETS_INCLUDE_LINES_FLAG%TYPE;
7541: l_primary_flag HZ_CUST_SITE_USES.PRIMARY_FLAG%TYPE;

Line 7538: l_warehouse_id HZ_CUST_SITE_USES.WAREHOUSE_ID%TYPE;

7534: l_price_list_id HZ_CUST_SITE_USES.PRICE_LIST_ID%TYPE;
7535: -- l_ship_partial HZ_CUST_SITE_USES.SHIP_PARTIAL%TYPE;
7536: l_fob_point HZ_CUST_SITE_USES.FOB_POINT%TYPE;
7537: l_item_cross_ref_pref HZ_CUST_SITE_USES.ITEM_CROSS_REF_PREF%TYPE;
7538: l_warehouse_id HZ_CUST_SITE_USES.WAREHOUSE_ID%TYPE;
7539: l_date_type_preference HZ_CUST_SITE_USES.DATE_TYPE_PREFERENCE%TYPE;
7540: -- l_ship_sets_include_lines_flag HZ_CUST_SITE_USES.SHIP_SETS_INCLUDE_LINES_FLAG%TYPE;
7541: l_primary_flag HZ_CUST_SITE_USES.PRIMARY_FLAG%TYPE;
7542: l_error BOOLEAN := FALSE;

Line 7539: l_date_type_preference HZ_CUST_SITE_USES.DATE_TYPE_PREFERENCE%TYPE;

7535: -- l_ship_partial HZ_CUST_SITE_USES.SHIP_PARTIAL%TYPE;
7536: l_fob_point HZ_CUST_SITE_USES.FOB_POINT%TYPE;
7537: l_item_cross_ref_pref HZ_CUST_SITE_USES.ITEM_CROSS_REF_PREF%TYPE;
7538: l_warehouse_id HZ_CUST_SITE_USES.WAREHOUSE_ID%TYPE;
7539: l_date_type_preference HZ_CUST_SITE_USES.DATE_TYPE_PREFERENCE%TYPE;
7540: -- l_ship_sets_include_lines_flag HZ_CUST_SITE_USES.SHIP_SETS_INCLUDE_LINES_FLAG%TYPE;
7541: l_primary_flag HZ_CUST_SITE_USES.PRIMARY_FLAG%TYPE;
7542: l_error BOOLEAN := FALSE;
7543: l_validate_flag varchar2(1) := 'Y';

Line 7540: -- l_ship_sets_include_lines_flag HZ_CUST_SITE_USES.SHIP_SETS_INCLUDE_LINES_FLAG%TYPE;

7536: l_fob_point HZ_CUST_SITE_USES.FOB_POINT%TYPE;
7537: l_item_cross_ref_pref HZ_CUST_SITE_USES.ITEM_CROSS_REF_PREF%TYPE;
7538: l_warehouse_id HZ_CUST_SITE_USES.WAREHOUSE_ID%TYPE;
7539: l_date_type_preference HZ_CUST_SITE_USES.DATE_TYPE_PREFERENCE%TYPE;
7540: -- l_ship_sets_include_lines_flag HZ_CUST_SITE_USES.SHIP_SETS_INCLUDE_LINES_FLAG%TYPE;
7541: l_primary_flag HZ_CUST_SITE_USES.PRIMARY_FLAG%TYPE;
7542: l_error BOOLEAN := FALSE;
7543: l_validate_flag varchar2(1) := 'Y';
7544: l_mosr_owner_table_id number;

Line 7541: l_primary_flag HZ_CUST_SITE_USES.PRIMARY_FLAG%TYPE;

7537: l_item_cross_ref_pref HZ_CUST_SITE_USES.ITEM_CROSS_REF_PREF%TYPE;
7538: l_warehouse_id HZ_CUST_SITE_USES.WAREHOUSE_ID%TYPE;
7539: l_date_type_preference HZ_CUST_SITE_USES.DATE_TYPE_PREFERENCE%TYPE;
7540: -- l_ship_sets_include_lines_flag HZ_CUST_SITE_USES.SHIP_SETS_INCLUDE_LINES_FLAG%TYPE;
7541: l_primary_flag HZ_CUST_SITE_USES.PRIMARY_FLAG%TYPE;
7542: l_error BOOLEAN := FALSE;
7543: l_validate_flag varchar2(1) := 'Y';
7544: l_mosr_owner_table_id number;
7545: l_coa_id NUMBER;

Line 7578: FROM HZ_CUST_SITE_USES_ALL -- Bug 3456489

7574: l_created_by_module, l_application_id, l_status, l_ship_via, l_freight_term,
7575: l_ship_sets_inc_lines_f,l_arrivalsets_inc_lines_f,l_tax_code,l_demand_class_code,
7576: l_primary_salesrep_id,l_finchrg_receivables_trx_id,l_order_type_id,l_price_list_id,
7577: l_fob_point,l_item_cross_ref_pref,l_warehouse_id,l_date_type_preference
7578: FROM HZ_CUST_SITE_USES_ALL -- Bug 3456489
7579: WHERE ROWID = p_rowid;
7580: END IF;
7581:
7582: --------------------------------------

Line 7600: FROM HZ_CUST_SITE_USES_ALL

7596: p_cust_site_use_rec.site_use_id <> FND_API.G_MISS_NUM
7597: THEN
7598: BEGIN
7599: SELECT 'Y' INTO l_dummy
7600: FROM HZ_CUST_SITE_USES_ALL
7601: WHERE SITE_USE_ID = p_cust_site_use_rec.site_use_id;
7602:
7603: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_DUPLICATE_COLUMN' );
7604: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'cust_site_use_id' );

Line 7849: HZ_CUST_SITE_USES_ALL su

7845: IF l_site_use_code IN ( 'DUN', 'STMTS', 'LEGAL' ) THEN
7846: BEGIN
7847: SELECT 'Y' INTO l_dummy
7848: FROM HZ_CUST_ACCT_SITES_ALL site,
7849: HZ_CUST_SITE_USES_ALL su
7850: WHERE site.CUST_ACCOUNT_ID = l_cust_account_id
7851: AND site.CUST_ACCT_SITE_ID = su.CUST_ACCT_SITE_ID
7852: AND su.SITE_USE_CODE = l_site_use_code
7853: AND su.STATUS = 'A'

Line 7890: FROM HZ_CUST_SITE_USES_ALL -- Bug 3456489

7886:
7887: -- Bug 3988537.
7888: BEGIN
7889: SELECT 'Y' INTO l_dummy
7890: FROM HZ_CUST_SITE_USES_ALL -- Bug 3456489
7891: WHERE CUST_ACCT_SITE_ID = nvl(p_cust_site_use_rec.cust_acct_site_id,l_cust_acct_site_id)
7892: AND SITE_USE_CODE = nvl(p_cust_site_use_rec.site_use_code,l_site_use_code)
7893: AND SITE_USE_ID <> nvl(p_cust_site_use_rec.site_use_id,fnd_api.g_miss_num)
7894: AND STATUS = 'A'

Line 7992: HZ_CUST_SITE_USES_ALL su

7988: --Bug No : 2998504. Status check added to the where clause.
7989:
7990: SELECT 'Y' INTO l_dummy
7991: FROM HZ_CUST_ACCT_SITES_ALL site,
7992: HZ_CUST_SITE_USES_ALL su
7993: WHERE site.CUST_ACCOUNT_ID = l_cust_account_id
7994: AND site.CUST_ACCT_SITE_ID = su.CUST_ACCT_SITE_ID
7995: AND su.SITE_USE_CODE = l_site_use_code
7996: AND su.LOCATION = p_cust_site_use_rec.location

Line 8065: HZ_CUST_SITE_USES_ALL su

8061: IF l_site_use_code = 'SHIP_TO' THEN
8062: BEGIN
8063: SELECT 'Y' INTO l_dummy
8064: FROM HZ_CUST_ACCT_SITES_ALL site,
8065: HZ_CUST_SITE_USES_ALL su
8066: WHERE su.SITE_USE_ID = p_cust_site_use_rec.bill_to_site_use_id
8067: AND su.SITE_USE_CODE = 'BILL_TO'
8068: AND su.STATUS = 'A'
8069: AND site.CUST_ACCT_SITE_ID = su.CUST_ACCT_SITE_ID

Line 8116: FROM hz_cust_site_uses_all hsu

8112: THEN
8113: BEGIN
8114: SELECT 'Y'
8115: INTO l_exist_flag
8116: FROM hz_cust_site_uses_all hsu
8117: WHERE hsu.site_use_code = 'SHIP_TO'
8118: AND hsu.status = 'A'
8119: AND hsu.bill_to_site_use_id = p_cust_site_use_rec.site_use_id
8120: AND rownum = 1;

Line 8161: p_owner_table_name =>'HZ_CUST_SITE_USES_ALL',

8157:
8158: hz_orig_system_ref_pub.get_owner_table_id
8159: (p_orig_system => p_cust_site_use_rec.orig_system,
8160: p_orig_system_reference => p_cust_site_use_rec.orig_system_reference,
8161: p_owner_table_name =>'HZ_CUST_SITE_USES_ALL',
8162: x_owner_table_id => l_mosr_owner_table_id,
8163: x_return_status => l_temp_return_status);
8164:
8165: IF (l_temp_return_status = fnd_api.g_ret_sts_success AND

Line 8295: HZ_CUST_SITE_USES su

8291: THEN
8292: BEGIN
8293: SELECT 'Y' INTO l_dummy
8294: FROM HZ_CUST_ACCT_SITES site,
8295: HZ_CUST_SITE_USES su
8296: WHERE site.CUST_ACCOUNT_ID = l_cust_account_id
8297: AND su.CUST_ACCT_SITE_ID = site.CUST_ACCT_SITE_ID
8298: AND su.SITE_USE_CODE = l_site_use_code
8299: AND su.PRIMARY_FLAG = 'Y'

Line 10733: FROM HZ_CUST_SITE_USES_ALL

10729: l_org_id HZ_CUST_ACCT_SITES_ALL.org_id%TYPE;
10730: BEGIN
10731:
10732: SELECT org_id INTO l_org_id
10733: FROM HZ_CUST_SITE_USES_ALL
10734: WHERE SITE_USE_ID = p_column_value;
10735:
10736: -- Bug 4650473. Check if org is accessible.
10737: BEGIN

Line 10750: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_site_uses' );

10746: WHEN NO_DATA_FOUND THEN
10747: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
10748: FND_MESSAGE.SET_TOKEN( 'FK', 'site_use_id' );
10749: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
10750: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_site_uses' );
10751: FND_MSG_PUB.ADD;
10752: x_return_status := FND_API.G_RET_STS_ERROR;
10753:
10754: END check_cust_site_use_fk;