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 2822: l_cust_acct_site_use_code HZ_CUST_SITE_USES.SITE_USE_CODE%TYPE;

2818: l_next_credit_review_date HZ_CUSTOMER_PROFILES.NEXT_CREDIT_REVIEW_DATE%TYPE;
2819: l_party_id HZ_CUSTOMER_PROFILES.PARTY_ID%TYPE;
2820: l_credit_classification HZ_CUSTOMER_PROFILES.CREDIT_CLASSIFICATION%TYPE;
2821:
2822: l_cust_acct_site_use_code HZ_CUST_SITE_USES.SITE_USE_CODE%TYPE;
2823: l_return_status VARCHAR2(1);
2824: l_org_id HZ_CUST_ACCT_SITES_ALL.org_id%TYPE;
2825:
2826: l_ckeck_acc_bfb_enabled VARCHAR2(1);

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

3447:
3448: END IF;
3449:
3450: ------------------
3451: -- site_use_id is foreign key to hz_cust_site_uses.
3452: -- one site use can only have one profile.
3453: -- Since site_use_id is non-updateable, we only need to check
3454: -- FK during creation.
3455: ------------------

Line 3471: FROM HZ_CUST_SITE_USES_ALL

3467: BEGIN
3468:
3469: SELECT CUST_ACCT_SITE_ID,SITE_USE_CODE,ORG_ID
3470: INTO l_cust_acct_site_id,l_cust_acct_site_use_code,l_org_id
3471: FROM HZ_CUST_SITE_USES_ALL
3472: WHERE SITE_USE_ID = p_customer_profile_rec.site_use_id;
3473:
3474: -- Bug 4650473. Check if org is accessible.
3475: BEGIN

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

3502: WHEN NO_DATA_FOUND THEN
3503: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
3504: FND_MESSAGE.SET_TOKEN( 'FK', 'site_use_id' );
3505: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'site_use_id' );
3506: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_site_uses' );
3507: FND_MSG_PUB.ADD;
3508: x_return_status := FND_API.G_RET_STS_ERROR;
3509: END;
3510:

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

3508: x_return_status := FND_API.G_RET_STS_ERROR;
3509: END;
3510:
3511: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3512: hz_utility_v2pub.debug(p_message=>'site_use_id is foreign key to hz_cust_site_uses. ' ||
3513: 'x_return_status = ' || x_return_status,
3514: p_prefix =>l_debug_prefix,
3515: p_msg_level=>fnd_log.level_statement);
3516: END IF;

Line 6033: -- site_use_id is foreign key to hz_cust_site_uses

6029: p_msg_level=>fnd_log.level_statement);
6030: END IF;
6031: END IF;
6032:
6033: -- site_use_id is foreign key to hz_cust_site_uses
6034: -- Since site_use_id is non-updateable, we only need to
6035: -- check FK during creation.
6036:
6037: IF p_create_update_flag = 'C' AND

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

6045: p_column_value => p_cust_profile_amt_rec.site_use_id,
6046: x_return_status => x_return_status );
6047:
6048: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6049: hz_utility_v2pub.debug(p_message=>'site_use_id is foreign key to hz_cust_site_uses. ' ||
6050: 'x_return_status = ' || x_return_status,
6051: p_prefix =>l_debug_prefix,
6052: p_msg_level=>fnd_log.level_statement);
6053: END IF;

Line 7773: * against hz_cust_site_uses_all table instead of the

7769: * 06-13-2002 P.Suresh Bug No : 2403263. Added validation that the contact_id
7770: * should be a foreign key to hz_cust_account_roles.
7771: * cust_account_role_id.
7772: * 06-19-2002 Rajeshwari P Bug 2399491.Validating site_use_id for duplicates
7773: * against hz_cust_site_uses_all table instead of the
7774: * org stripped view, hz_cust_site_uses.
7775: * 03-May-3004 Venkata Sowjanya S Bug No : 3609601. Commented the statements which sets tokens Column1,Column2
7776: * for message HZ_API_INACTIVE_CANNOT_PRIM
7777: * 12-MAY-2005 Rajib Ranjan Borah o TCA SSA Uptake (Bug 3456489)

Line 7774: * org stripped view, hz_cust_site_uses.

7770: * should be a foreign key to hz_cust_account_roles.
7771: * cust_account_role_id.
7772: * 06-19-2002 Rajeshwari P Bug 2399491.Validating site_use_id for duplicates
7773: * against hz_cust_site_uses_all table instead of the
7774: * org stripped view, hz_cust_site_uses.
7775: * 03-May-3004 Venkata Sowjanya S Bug No : 3609601. Commented the statements which sets tokens Column1,Column2
7776: * for message HZ_API_INACTIVE_CANNOT_PRIM
7777: * 12-MAY-2005 Rajib Ranjan Borah o TCA SSA Uptake (Bug 3456489)
7778: */

Line 7793: l_site_use_code HZ_CUST_SITE_USES.site_use_code%TYPE;

7789: l_dummy VARCHAR2(1);
7790: l_profile AR_SYSTEM_PARAMETERS.auto_site_numbering%TYPE;
7791:
7792: l_cust_acct_site_id NUMBER;
7793: l_site_use_code HZ_CUST_SITE_USES.site_use_code%TYPE;
7794: l_cust_account_id NUMBER;
7795: l_orig_system_reference HZ_CUST_SITE_USES.orig_system_reference%TYPE;
7796: l_created_by_module HZ_CUST_SITE_USES.created_by_module%TYPE;
7797: l_application_id NUMBER;

Line 7795: l_orig_system_reference HZ_CUST_SITE_USES.orig_system_reference%TYPE;

7791:
7792: l_cust_acct_site_id NUMBER;
7793: l_site_use_code HZ_CUST_SITE_USES.site_use_code%TYPE;
7794: l_cust_account_id NUMBER;
7795: l_orig_system_reference HZ_CUST_SITE_USES.orig_system_reference%TYPE;
7796: l_created_by_module HZ_CUST_SITE_USES.created_by_module%TYPE;
7797: l_application_id NUMBER;
7798: l_status HZ_CUST_SITE_USES.status%TYPE;
7799: l_ship_via HZ_CUST_SITE_USES.ship_via%TYPE;

Line 7796: l_created_by_module HZ_CUST_SITE_USES.created_by_module%TYPE;

7792: l_cust_acct_site_id NUMBER;
7793: l_site_use_code HZ_CUST_SITE_USES.site_use_code%TYPE;
7794: l_cust_account_id NUMBER;
7795: l_orig_system_reference HZ_CUST_SITE_USES.orig_system_reference%TYPE;
7796: l_created_by_module HZ_CUST_SITE_USES.created_by_module%TYPE;
7797: l_application_id NUMBER;
7798: l_status HZ_CUST_SITE_USES.status%TYPE;
7799: l_ship_via HZ_CUST_SITE_USES.ship_via%TYPE;
7800: l_freight_term HZ_CUST_SITE_USES.freight_term%TYPE;

Line 7798: l_status HZ_CUST_SITE_USES.status%TYPE;

7794: l_cust_account_id NUMBER;
7795: l_orig_system_reference HZ_CUST_SITE_USES.orig_system_reference%TYPE;
7796: l_created_by_module HZ_CUST_SITE_USES.created_by_module%TYPE;
7797: l_application_id NUMBER;
7798: l_status HZ_CUST_SITE_USES.status%TYPE;
7799: l_ship_via HZ_CUST_SITE_USES.ship_via%TYPE;
7800: l_freight_term HZ_CUST_SITE_USES.freight_term%TYPE;
7801: l_ship_sets_inc_lines_f HZ_CUST_SITE_USES.ship_sets_include_lines_flag%TYPE;
7802: l_arrivalsets_inc_lines_f HZ_CUST_SITE_USES.arrivalsets_include_lines_flag%TYPE;

Line 7799: l_ship_via HZ_CUST_SITE_USES.ship_via%TYPE;

7795: l_orig_system_reference HZ_CUST_SITE_USES.orig_system_reference%TYPE;
7796: l_created_by_module HZ_CUST_SITE_USES.created_by_module%TYPE;
7797: l_application_id NUMBER;
7798: l_status HZ_CUST_SITE_USES.status%TYPE;
7799: l_ship_via HZ_CUST_SITE_USES.ship_via%TYPE;
7800: l_freight_term HZ_CUST_SITE_USES.freight_term%TYPE;
7801: l_ship_sets_inc_lines_f HZ_CUST_SITE_USES.ship_sets_include_lines_flag%TYPE;
7802: l_arrivalsets_inc_lines_f HZ_CUST_SITE_USES.arrivalsets_include_lines_flag%TYPE;
7803: l_tax_code HZ_CUST_SITE_USES.tax_code%TYPE;

Line 7800: l_freight_term HZ_CUST_SITE_USES.freight_term%TYPE;

7796: l_created_by_module HZ_CUST_SITE_USES.created_by_module%TYPE;
7797: l_application_id NUMBER;
7798: l_status HZ_CUST_SITE_USES.status%TYPE;
7799: l_ship_via HZ_CUST_SITE_USES.ship_via%TYPE;
7800: l_freight_term HZ_CUST_SITE_USES.freight_term%TYPE;
7801: l_ship_sets_inc_lines_f HZ_CUST_SITE_USES.ship_sets_include_lines_flag%TYPE;
7802: l_arrivalsets_inc_lines_f HZ_CUST_SITE_USES.arrivalsets_include_lines_flag%TYPE;
7803: l_tax_code HZ_CUST_SITE_USES.tax_code%TYPE;
7804: l_payment_term_id HZ_CUST_SITE_USES.payment_term_id%TYPE;

Line 7801: l_ship_sets_inc_lines_f HZ_CUST_SITE_USES.ship_sets_include_lines_flag%TYPE;

7797: l_application_id NUMBER;
7798: l_status HZ_CUST_SITE_USES.status%TYPE;
7799: l_ship_via HZ_CUST_SITE_USES.ship_via%TYPE;
7800: l_freight_term HZ_CUST_SITE_USES.freight_term%TYPE;
7801: l_ship_sets_inc_lines_f HZ_CUST_SITE_USES.ship_sets_include_lines_flag%TYPE;
7802: l_arrivalsets_inc_lines_f HZ_CUST_SITE_USES.arrivalsets_include_lines_flag%TYPE;
7803: l_tax_code HZ_CUST_SITE_USES.tax_code%TYPE;
7804: l_payment_term_id HZ_CUST_SITE_USES.payment_term_id%TYPE;
7805: l_demand_class_code HZ_CUST_SITE_USES.demand_class_code%TYPE;

Line 7802: l_arrivalsets_inc_lines_f HZ_CUST_SITE_USES.arrivalsets_include_lines_flag%TYPE;

7798: l_status HZ_CUST_SITE_USES.status%TYPE;
7799: l_ship_via HZ_CUST_SITE_USES.ship_via%TYPE;
7800: l_freight_term HZ_CUST_SITE_USES.freight_term%TYPE;
7801: l_ship_sets_inc_lines_f HZ_CUST_SITE_USES.ship_sets_include_lines_flag%TYPE;
7802: l_arrivalsets_inc_lines_f HZ_CUST_SITE_USES.arrivalsets_include_lines_flag%TYPE;
7803: l_tax_code HZ_CUST_SITE_USES.tax_code%TYPE;
7804: l_payment_term_id HZ_CUST_SITE_USES.payment_term_id%TYPE;
7805: l_demand_class_code HZ_CUST_SITE_USES.demand_class_code%TYPE;
7806: l_primary_salesrep_id HZ_CUST_SITE_USES.primary_salesrep_id%TYPE;

Line 7803: l_tax_code HZ_CUST_SITE_USES.tax_code%TYPE;

7799: l_ship_via HZ_CUST_SITE_USES.ship_via%TYPE;
7800: l_freight_term HZ_CUST_SITE_USES.freight_term%TYPE;
7801: l_ship_sets_inc_lines_f HZ_CUST_SITE_USES.ship_sets_include_lines_flag%TYPE;
7802: l_arrivalsets_inc_lines_f HZ_CUST_SITE_USES.arrivalsets_include_lines_flag%TYPE;
7803: l_tax_code HZ_CUST_SITE_USES.tax_code%TYPE;
7804: l_payment_term_id HZ_CUST_SITE_USES.payment_term_id%TYPE;
7805: l_demand_class_code HZ_CUST_SITE_USES.demand_class_code%TYPE;
7806: l_primary_salesrep_id HZ_CUST_SITE_USES.primary_salesrep_id%TYPE;
7807: l_finchrg_receivables_trx_id HZ_CUST_SITE_USES.FINCHRG_RECEIVABLES_TRX_ID%TYPE;

Line 7804: l_payment_term_id HZ_CUST_SITE_USES.payment_term_id%TYPE;

7800: l_freight_term HZ_CUST_SITE_USES.freight_term%TYPE;
7801: l_ship_sets_inc_lines_f HZ_CUST_SITE_USES.ship_sets_include_lines_flag%TYPE;
7802: l_arrivalsets_inc_lines_f HZ_CUST_SITE_USES.arrivalsets_include_lines_flag%TYPE;
7803: l_tax_code HZ_CUST_SITE_USES.tax_code%TYPE;
7804: l_payment_term_id HZ_CUST_SITE_USES.payment_term_id%TYPE;
7805: l_demand_class_code HZ_CUST_SITE_USES.demand_class_code%TYPE;
7806: l_primary_salesrep_id HZ_CUST_SITE_USES.primary_salesrep_id%TYPE;
7807: l_finchrg_receivables_trx_id HZ_CUST_SITE_USES.FINCHRG_RECEIVABLES_TRX_ID%TYPE;
7808: l_order_type_id HZ_CUST_SITE_USES.ORDER_TYPE_ID%TYPE;

Line 7805: l_demand_class_code HZ_CUST_SITE_USES.demand_class_code%TYPE;

7801: l_ship_sets_inc_lines_f HZ_CUST_SITE_USES.ship_sets_include_lines_flag%TYPE;
7802: l_arrivalsets_inc_lines_f HZ_CUST_SITE_USES.arrivalsets_include_lines_flag%TYPE;
7803: l_tax_code HZ_CUST_SITE_USES.tax_code%TYPE;
7804: l_payment_term_id HZ_CUST_SITE_USES.payment_term_id%TYPE;
7805: l_demand_class_code HZ_CUST_SITE_USES.demand_class_code%TYPE;
7806: l_primary_salesrep_id HZ_CUST_SITE_USES.primary_salesrep_id%TYPE;
7807: l_finchrg_receivables_trx_id HZ_CUST_SITE_USES.FINCHRG_RECEIVABLES_TRX_ID%TYPE;
7808: l_order_type_id HZ_CUST_SITE_USES.ORDER_TYPE_ID%TYPE;
7809: l_price_list_id HZ_CUST_SITE_USES.PRICE_LIST_ID%TYPE;

Line 7806: l_primary_salesrep_id HZ_CUST_SITE_USES.primary_salesrep_id%TYPE;

7802: l_arrivalsets_inc_lines_f HZ_CUST_SITE_USES.arrivalsets_include_lines_flag%TYPE;
7803: l_tax_code HZ_CUST_SITE_USES.tax_code%TYPE;
7804: l_payment_term_id HZ_CUST_SITE_USES.payment_term_id%TYPE;
7805: l_demand_class_code HZ_CUST_SITE_USES.demand_class_code%TYPE;
7806: l_primary_salesrep_id HZ_CUST_SITE_USES.primary_salesrep_id%TYPE;
7807: l_finchrg_receivables_trx_id HZ_CUST_SITE_USES.FINCHRG_RECEIVABLES_TRX_ID%TYPE;
7808: l_order_type_id HZ_CUST_SITE_USES.ORDER_TYPE_ID%TYPE;
7809: l_price_list_id HZ_CUST_SITE_USES.PRICE_LIST_ID%TYPE;
7810: -- l_ship_partial HZ_CUST_SITE_USES.SHIP_PARTIAL%TYPE;

Line 7807: l_finchrg_receivables_trx_id HZ_CUST_SITE_USES.FINCHRG_RECEIVABLES_TRX_ID%TYPE;

7803: l_tax_code HZ_CUST_SITE_USES.tax_code%TYPE;
7804: l_payment_term_id HZ_CUST_SITE_USES.payment_term_id%TYPE;
7805: l_demand_class_code HZ_CUST_SITE_USES.demand_class_code%TYPE;
7806: l_primary_salesrep_id HZ_CUST_SITE_USES.primary_salesrep_id%TYPE;
7807: l_finchrg_receivables_trx_id HZ_CUST_SITE_USES.FINCHRG_RECEIVABLES_TRX_ID%TYPE;
7808: l_order_type_id HZ_CUST_SITE_USES.ORDER_TYPE_ID%TYPE;
7809: l_price_list_id HZ_CUST_SITE_USES.PRICE_LIST_ID%TYPE;
7810: -- l_ship_partial HZ_CUST_SITE_USES.SHIP_PARTIAL%TYPE;
7811: l_fob_point HZ_CUST_SITE_USES.FOB_POINT%TYPE;

Line 7808: l_order_type_id HZ_CUST_SITE_USES.ORDER_TYPE_ID%TYPE;

7804: l_payment_term_id HZ_CUST_SITE_USES.payment_term_id%TYPE;
7805: l_demand_class_code HZ_CUST_SITE_USES.demand_class_code%TYPE;
7806: l_primary_salesrep_id HZ_CUST_SITE_USES.primary_salesrep_id%TYPE;
7807: l_finchrg_receivables_trx_id HZ_CUST_SITE_USES.FINCHRG_RECEIVABLES_TRX_ID%TYPE;
7808: l_order_type_id HZ_CUST_SITE_USES.ORDER_TYPE_ID%TYPE;
7809: l_price_list_id HZ_CUST_SITE_USES.PRICE_LIST_ID%TYPE;
7810: -- l_ship_partial HZ_CUST_SITE_USES.SHIP_PARTIAL%TYPE;
7811: l_fob_point HZ_CUST_SITE_USES.FOB_POINT%TYPE;
7812: l_item_cross_ref_pref HZ_CUST_SITE_USES.ITEM_CROSS_REF_PREF%TYPE;

Line 7809: l_price_list_id HZ_CUST_SITE_USES.PRICE_LIST_ID%TYPE;

7805: l_demand_class_code HZ_CUST_SITE_USES.demand_class_code%TYPE;
7806: l_primary_salesrep_id HZ_CUST_SITE_USES.primary_salesrep_id%TYPE;
7807: l_finchrg_receivables_trx_id HZ_CUST_SITE_USES.FINCHRG_RECEIVABLES_TRX_ID%TYPE;
7808: l_order_type_id HZ_CUST_SITE_USES.ORDER_TYPE_ID%TYPE;
7809: l_price_list_id HZ_CUST_SITE_USES.PRICE_LIST_ID%TYPE;
7810: -- l_ship_partial HZ_CUST_SITE_USES.SHIP_PARTIAL%TYPE;
7811: l_fob_point HZ_CUST_SITE_USES.FOB_POINT%TYPE;
7812: l_item_cross_ref_pref HZ_CUST_SITE_USES.ITEM_CROSS_REF_PREF%TYPE;
7813: l_warehouse_id HZ_CUST_SITE_USES.WAREHOUSE_ID%TYPE;

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

7806: l_primary_salesrep_id HZ_CUST_SITE_USES.primary_salesrep_id%TYPE;
7807: l_finchrg_receivables_trx_id HZ_CUST_SITE_USES.FINCHRG_RECEIVABLES_TRX_ID%TYPE;
7808: l_order_type_id HZ_CUST_SITE_USES.ORDER_TYPE_ID%TYPE;
7809: l_price_list_id HZ_CUST_SITE_USES.PRICE_LIST_ID%TYPE;
7810: -- l_ship_partial HZ_CUST_SITE_USES.SHIP_PARTIAL%TYPE;
7811: l_fob_point HZ_CUST_SITE_USES.FOB_POINT%TYPE;
7812: l_item_cross_ref_pref HZ_CUST_SITE_USES.ITEM_CROSS_REF_PREF%TYPE;
7813: l_warehouse_id HZ_CUST_SITE_USES.WAREHOUSE_ID%TYPE;
7814: l_date_type_preference HZ_CUST_SITE_USES.DATE_TYPE_PREFERENCE%TYPE;

Line 7811: l_fob_point HZ_CUST_SITE_USES.FOB_POINT%TYPE;

7807: l_finchrg_receivables_trx_id HZ_CUST_SITE_USES.FINCHRG_RECEIVABLES_TRX_ID%TYPE;
7808: l_order_type_id HZ_CUST_SITE_USES.ORDER_TYPE_ID%TYPE;
7809: l_price_list_id HZ_CUST_SITE_USES.PRICE_LIST_ID%TYPE;
7810: -- l_ship_partial HZ_CUST_SITE_USES.SHIP_PARTIAL%TYPE;
7811: l_fob_point HZ_CUST_SITE_USES.FOB_POINT%TYPE;
7812: l_item_cross_ref_pref HZ_CUST_SITE_USES.ITEM_CROSS_REF_PREF%TYPE;
7813: l_warehouse_id HZ_CUST_SITE_USES.WAREHOUSE_ID%TYPE;
7814: l_date_type_preference HZ_CUST_SITE_USES.DATE_TYPE_PREFERENCE%TYPE;
7815: -- l_ship_sets_include_lines_flag HZ_CUST_SITE_USES.SHIP_SETS_INCLUDE_LINES_FLAG%TYPE;

Line 7812: l_item_cross_ref_pref HZ_CUST_SITE_USES.ITEM_CROSS_REF_PREF%TYPE;

7808: l_order_type_id HZ_CUST_SITE_USES.ORDER_TYPE_ID%TYPE;
7809: l_price_list_id HZ_CUST_SITE_USES.PRICE_LIST_ID%TYPE;
7810: -- l_ship_partial HZ_CUST_SITE_USES.SHIP_PARTIAL%TYPE;
7811: l_fob_point HZ_CUST_SITE_USES.FOB_POINT%TYPE;
7812: l_item_cross_ref_pref HZ_CUST_SITE_USES.ITEM_CROSS_REF_PREF%TYPE;
7813: l_warehouse_id HZ_CUST_SITE_USES.WAREHOUSE_ID%TYPE;
7814: l_date_type_preference HZ_CUST_SITE_USES.DATE_TYPE_PREFERENCE%TYPE;
7815: -- l_ship_sets_include_lines_flag HZ_CUST_SITE_USES.SHIP_SETS_INCLUDE_LINES_FLAG%TYPE;
7816: l_primary_flag HZ_CUST_SITE_USES.PRIMARY_FLAG%TYPE;

Line 7813: l_warehouse_id HZ_CUST_SITE_USES.WAREHOUSE_ID%TYPE;

7809: l_price_list_id HZ_CUST_SITE_USES.PRICE_LIST_ID%TYPE;
7810: -- l_ship_partial HZ_CUST_SITE_USES.SHIP_PARTIAL%TYPE;
7811: l_fob_point HZ_CUST_SITE_USES.FOB_POINT%TYPE;
7812: l_item_cross_ref_pref HZ_CUST_SITE_USES.ITEM_CROSS_REF_PREF%TYPE;
7813: l_warehouse_id HZ_CUST_SITE_USES.WAREHOUSE_ID%TYPE;
7814: l_date_type_preference HZ_CUST_SITE_USES.DATE_TYPE_PREFERENCE%TYPE;
7815: -- l_ship_sets_include_lines_flag HZ_CUST_SITE_USES.SHIP_SETS_INCLUDE_LINES_FLAG%TYPE;
7816: l_primary_flag HZ_CUST_SITE_USES.PRIMARY_FLAG%TYPE;
7817: l_error BOOLEAN := FALSE;

Line 7814: l_date_type_preference HZ_CUST_SITE_USES.DATE_TYPE_PREFERENCE%TYPE;

7810: -- l_ship_partial HZ_CUST_SITE_USES.SHIP_PARTIAL%TYPE;
7811: l_fob_point HZ_CUST_SITE_USES.FOB_POINT%TYPE;
7812: l_item_cross_ref_pref HZ_CUST_SITE_USES.ITEM_CROSS_REF_PREF%TYPE;
7813: l_warehouse_id HZ_CUST_SITE_USES.WAREHOUSE_ID%TYPE;
7814: l_date_type_preference HZ_CUST_SITE_USES.DATE_TYPE_PREFERENCE%TYPE;
7815: -- l_ship_sets_include_lines_flag HZ_CUST_SITE_USES.SHIP_SETS_INCLUDE_LINES_FLAG%TYPE;
7816: l_primary_flag HZ_CUST_SITE_USES.PRIMARY_FLAG%TYPE;
7817: l_error BOOLEAN := FALSE;
7818: l_validate_flag varchar2(1) := 'Y';

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

7811: l_fob_point HZ_CUST_SITE_USES.FOB_POINT%TYPE;
7812: l_item_cross_ref_pref HZ_CUST_SITE_USES.ITEM_CROSS_REF_PREF%TYPE;
7813: l_warehouse_id HZ_CUST_SITE_USES.WAREHOUSE_ID%TYPE;
7814: l_date_type_preference HZ_CUST_SITE_USES.DATE_TYPE_PREFERENCE%TYPE;
7815: -- l_ship_sets_include_lines_flag HZ_CUST_SITE_USES.SHIP_SETS_INCLUDE_LINES_FLAG%TYPE;
7816: l_primary_flag HZ_CUST_SITE_USES.PRIMARY_FLAG%TYPE;
7817: l_error BOOLEAN := FALSE;
7818: l_validate_flag varchar2(1) := 'Y';
7819: l_mosr_owner_table_id number;

Line 7816: l_primary_flag HZ_CUST_SITE_USES.PRIMARY_FLAG%TYPE;

7812: l_item_cross_ref_pref HZ_CUST_SITE_USES.ITEM_CROSS_REF_PREF%TYPE;
7813: l_warehouse_id HZ_CUST_SITE_USES.WAREHOUSE_ID%TYPE;
7814: l_date_type_preference HZ_CUST_SITE_USES.DATE_TYPE_PREFERENCE%TYPE;
7815: -- l_ship_sets_include_lines_flag HZ_CUST_SITE_USES.SHIP_SETS_INCLUDE_LINES_FLAG%TYPE;
7816: l_primary_flag HZ_CUST_SITE_USES.PRIMARY_FLAG%TYPE;
7817: l_error BOOLEAN := FALSE;
7818: l_validate_flag varchar2(1) := 'Y';
7819: l_mosr_owner_table_id number;
7820: l_coa_id NUMBER;

Line 7853: FROM HZ_CUST_SITE_USES_ALL -- Bug 3456489

7849: l_created_by_module, l_application_id, l_status, l_ship_via, l_freight_term,
7850: l_ship_sets_inc_lines_f,l_arrivalsets_inc_lines_f,l_tax_code,l_demand_class_code,
7851: l_primary_salesrep_id,l_finchrg_receivables_trx_id,l_order_type_id,l_price_list_id,
7852: l_fob_point,l_item_cross_ref_pref,l_warehouse_id,l_date_type_preference
7853: FROM HZ_CUST_SITE_USES_ALL -- Bug 3456489
7854: WHERE ROWID = p_rowid;
7855: END IF;
7856:
7857: --------------------------------------

Line 7875: FROM HZ_CUST_SITE_USES_ALL

7871: p_cust_site_use_rec.site_use_id <> FND_API.G_MISS_NUM
7872: THEN
7873: BEGIN
7874: SELECT 'Y' INTO l_dummy
7875: FROM HZ_CUST_SITE_USES_ALL
7876: WHERE SITE_USE_ID = p_cust_site_use_rec.site_use_id;
7877:
7878: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_DUPLICATE_COLUMN' );
7879: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'cust_site_use_id' );

Line 8128: HZ_CUST_SITE_USES_ALL su

8124: IF l_site_use_code IN ( 'DUN', 'STMTS', 'LEGAL' ) THEN
8125: BEGIN
8126: SELECT 'Y' INTO l_dummy
8127: FROM HZ_CUST_ACCT_SITES_ALL site,
8128: HZ_CUST_SITE_USES_ALL su
8129: WHERE site.CUST_ACCOUNT_ID = l_cust_account_id
8130: AND site.CUST_ACCT_SITE_ID = su.CUST_ACCT_SITE_ID
8131: AND su.SITE_USE_CODE = l_site_use_code
8132: AND su.STATUS = 'A'

Line 8172: FROM HZ_CUST_SITE_USES_ALL -- Bug 3456489

8168: then
8169: -- Bug 3988537.
8170: BEGIN
8171: SELECT 'Y' INTO l_dummy
8172: FROM HZ_CUST_SITE_USES_ALL -- Bug 3456489
8173: WHERE CUST_ACCT_SITE_ID = nvl(p_cust_site_use_rec.cust_acct_site_id,l_cust_acct_site_id)
8174: AND SITE_USE_CODE = nvl(p_cust_site_use_rec.site_use_code,l_site_use_code)
8175: AND SITE_USE_ID <> nvl(p_cust_site_use_rec.site_use_id,fnd_api.g_miss_num)
8176: AND STATUS = 'A'

Line 8275: HZ_CUST_SITE_USES_ALL su

8271: --Bug No : 2998504. Status check added to the where clause.
8272:
8273: SELECT 'Y' INTO l_dummy
8274: FROM HZ_CUST_ACCT_SITES_ALL site,
8275: HZ_CUST_SITE_USES_ALL su
8276: WHERE site.CUST_ACCOUNT_ID = l_cust_account_id
8277: AND site.CUST_ACCT_SITE_ID = su.CUST_ACCT_SITE_ID
8278: AND su.SITE_USE_CODE = l_site_use_code
8279: AND su.LOCATION = p_cust_site_use_rec.location

Line 8348: HZ_CUST_SITE_USES_ALL su

8344: IF l_site_use_code = 'SHIP_TO' THEN
8345: BEGIN
8346: SELECT 'Y' INTO l_dummy
8347: FROM HZ_CUST_ACCT_SITES_ALL site,
8348: HZ_CUST_SITE_USES_ALL su
8349: WHERE su.SITE_USE_ID = p_cust_site_use_rec.bill_to_site_use_id
8350: AND su.SITE_USE_CODE = 'BILL_TO'
8351: AND su.STATUS = 'A'
8352: AND site.CUST_ACCT_SITE_ID = su.CUST_ACCT_SITE_ID

Line 8399: FROM hz_cust_site_uses_all hsu

8395: THEN
8396: BEGIN
8397: SELECT 'Y'
8398: INTO l_exist_flag
8399: FROM hz_cust_site_uses_all hsu
8400: WHERE hsu.site_use_code = 'SHIP_TO'
8401: AND hsu.status = 'A'
8402: AND hsu.bill_to_site_use_id = p_cust_site_use_rec.site_use_id
8403: AND rownum = 1;

Line 8444: p_owner_table_name =>'HZ_CUST_SITE_USES_ALL',

8440:
8441: hz_orig_system_ref_pub.get_owner_table_id
8442: (p_orig_system => p_cust_site_use_rec.orig_system,
8443: p_orig_system_reference => p_cust_site_use_rec.orig_system_reference,
8444: p_owner_table_name =>'HZ_CUST_SITE_USES_ALL',
8445: x_owner_table_id => l_mosr_owner_table_id,
8446: x_return_status => l_temp_return_status);
8447:
8448: IF (l_temp_return_status = fnd_api.g_ret_sts_success AND

Line 8578: HZ_CUST_SITE_USES su

8574: THEN
8575: BEGIN
8576: SELECT 'Y' INTO l_dummy
8577: FROM HZ_CUST_ACCT_SITES site,
8578: HZ_CUST_SITE_USES su
8579: WHERE site.CUST_ACCOUNT_ID = l_cust_account_id
8580: AND su.CUST_ACCT_SITE_ID = site.CUST_ACCT_SITE_ID
8581: AND su.SITE_USE_CODE = l_site_use_code
8582: AND su.PRIMARY_FLAG = 'Y'

Line 11024: FROM HZ_CUST_SITE_USES_ALL

11020: l_org_id HZ_CUST_ACCT_SITES_ALL.org_id%TYPE;
11021: BEGIN
11022:
11023: SELECT org_id INTO l_org_id
11024: FROM HZ_CUST_SITE_USES_ALL
11025: WHERE SITE_USE_ID = p_column_value;
11026:
11027: -- Bug 4650473. Check if org is accessible.
11028: BEGIN

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

11037: WHEN NO_DATA_FOUND THEN
11038: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
11039: FND_MESSAGE.SET_TOKEN( 'FK', 'site_use_id' );
11040: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
11041: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_site_uses' );
11042: FND_MSG_PUB.ADD;
11043: x_return_status := FND_API.G_RET_STS_ERROR;
11044:
11045: END check_cust_site_use_fk;