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_CUSTOMER_PROFILES

Line 2759: l_created_by_module HZ_CUSTOMER_PROFILES.created_by_module%TYPE;

2755: l_site_use_id NUMBER;
2756: l_cust_acct_site_id NUMBER;
2757: l_class_status HZ_CUST_PROFILE_CLASSES.status%TYPE;
2758: l_profile_class_name HZ_CUST_PROFILE_CLASSES.name%TYPE;
2759: l_created_by_module HZ_CUSTOMER_PROFILES.created_by_module%TYPE;
2760: l_application_id NUMBER;
2761: l_credit_rating HZ_CUSTOMER_PROFILES.credit_rating%TYPE;
2762: l_risk_code HZ_CUSTOMER_PROFILES.risk_code%TYPE;
2763: l_status HZ_CUSTOMER_PROFILES.status%TYPE;

Line 2761: l_credit_rating HZ_CUSTOMER_PROFILES.credit_rating%TYPE;

2757: l_class_status HZ_CUST_PROFILE_CLASSES.status%TYPE;
2758: l_profile_class_name HZ_CUST_PROFILE_CLASSES.name%TYPE;
2759: l_created_by_module HZ_CUSTOMER_PROFILES.created_by_module%TYPE;
2760: l_application_id NUMBER;
2761: l_credit_rating HZ_CUSTOMER_PROFILES.credit_rating%TYPE;
2762: l_risk_code HZ_CUSTOMER_PROFILES.risk_code%TYPE;
2763: l_status HZ_CUSTOMER_PROFILES.status%TYPE;
2764: l_profile_class_rec HZ_CUST_PROFILE_CLASSES%ROWTYPE;
2765: v_customer_profile_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE

Line 2762: l_risk_code HZ_CUSTOMER_PROFILES.risk_code%TYPE;

2758: l_profile_class_name HZ_CUST_PROFILE_CLASSES.name%TYPE;
2759: l_created_by_module HZ_CUSTOMER_PROFILES.created_by_module%TYPE;
2760: l_application_id NUMBER;
2761: l_credit_rating HZ_CUSTOMER_PROFILES.credit_rating%TYPE;
2762: l_risk_code HZ_CUSTOMER_PROFILES.risk_code%TYPE;
2763: l_status HZ_CUSTOMER_PROFILES.status%TYPE;
2764: l_profile_class_rec HZ_CUST_PROFILE_CLASSES%ROWTYPE;
2765: v_customer_profile_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE
2766: := p_customer_profile_rec;

Line 2763: l_status HZ_CUSTOMER_PROFILES.status%TYPE;

2759: l_created_by_module HZ_CUSTOMER_PROFILES.created_by_module%TYPE;
2760: l_application_id NUMBER;
2761: l_credit_rating HZ_CUSTOMER_PROFILES.credit_rating%TYPE;
2762: l_risk_code HZ_CUSTOMER_PROFILES.risk_code%TYPE;
2763: l_status HZ_CUSTOMER_PROFILES.status%TYPE;
2764: l_profile_class_rec HZ_CUST_PROFILE_CLASSES%ROWTYPE;
2765: v_customer_profile_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE
2766: := p_customer_profile_rec;
2767: l_discount_terms HZ_CUSTOMER_PROFILES.discount_terms%TYPE;

Line 2767: l_discount_terms HZ_CUSTOMER_PROFILES.discount_terms%TYPE;

2763: l_status HZ_CUSTOMER_PROFILES.status%TYPE;
2764: l_profile_class_rec HZ_CUST_PROFILE_CLASSES%ROWTYPE;
2765: v_customer_profile_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE
2766: := p_customer_profile_rec;
2767: l_discount_terms HZ_CUSTOMER_PROFILES.discount_terms%TYPE;
2768: l_discount_grace_days HZ_CUSTOMER_PROFILES.discount_grace_days%TYPE;
2769: l_dunning_letters HZ_CUSTOMER_PROFILES.dunning_letters%TYPE;
2770: l_dunning_letter_set_id HZ_CUSTOMER_PROFILES.dunning_letter_set_id%TYPE;
2771: l_send_statements HZ_CUSTOMER_PROFILES.send_statements%TYPE;

Line 2768: l_discount_grace_days HZ_CUSTOMER_PROFILES.discount_grace_days%TYPE;

2764: l_profile_class_rec HZ_CUST_PROFILE_CLASSES%ROWTYPE;
2765: v_customer_profile_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE
2766: := p_customer_profile_rec;
2767: l_discount_terms HZ_CUSTOMER_PROFILES.discount_terms%TYPE;
2768: l_discount_grace_days HZ_CUSTOMER_PROFILES.discount_grace_days%TYPE;
2769: l_dunning_letters HZ_CUSTOMER_PROFILES.dunning_letters%TYPE;
2770: l_dunning_letter_set_id HZ_CUSTOMER_PROFILES.dunning_letter_set_id%TYPE;
2771: l_send_statements HZ_CUSTOMER_PROFILES.send_statements%TYPE;
2772: l_statement_cycle_id HZ_CUSTOMER_PROFILES.statement_cycle_id%TYPE;

Line 2769: l_dunning_letters HZ_CUSTOMER_PROFILES.dunning_letters%TYPE;

2765: v_customer_profile_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE
2766: := p_customer_profile_rec;
2767: l_discount_terms HZ_CUSTOMER_PROFILES.discount_terms%TYPE;
2768: l_discount_grace_days HZ_CUSTOMER_PROFILES.discount_grace_days%TYPE;
2769: l_dunning_letters HZ_CUSTOMER_PROFILES.dunning_letters%TYPE;
2770: l_dunning_letter_set_id HZ_CUSTOMER_PROFILES.dunning_letter_set_id%TYPE;
2771: l_send_statements HZ_CUSTOMER_PROFILES.send_statements%TYPE;
2772: l_statement_cycle_id HZ_CUSTOMER_PROFILES.statement_cycle_id%TYPE;
2773: l_credit_balance_statements HZ_CUSTOMER_PROFILES.credit_balance_statements%TYPE;

Line 2770: l_dunning_letter_set_id HZ_CUSTOMER_PROFILES.dunning_letter_set_id%TYPE;

2766: := p_customer_profile_rec;
2767: l_discount_terms HZ_CUSTOMER_PROFILES.discount_terms%TYPE;
2768: l_discount_grace_days HZ_CUSTOMER_PROFILES.discount_grace_days%TYPE;
2769: l_dunning_letters HZ_CUSTOMER_PROFILES.dunning_letters%TYPE;
2770: l_dunning_letter_set_id HZ_CUSTOMER_PROFILES.dunning_letter_set_id%TYPE;
2771: l_send_statements HZ_CUSTOMER_PROFILES.send_statements%TYPE;
2772: l_statement_cycle_id HZ_CUSTOMER_PROFILES.statement_cycle_id%TYPE;
2773: l_credit_balance_statements HZ_CUSTOMER_PROFILES.credit_balance_statements%TYPE;
2774: l_interest_charges HZ_CUSTOMER_PROFILES.interest_charges%TYPE;

Line 2771: l_send_statements HZ_CUSTOMER_PROFILES.send_statements%TYPE;

2767: l_discount_terms HZ_CUSTOMER_PROFILES.discount_terms%TYPE;
2768: l_discount_grace_days HZ_CUSTOMER_PROFILES.discount_grace_days%TYPE;
2769: l_dunning_letters HZ_CUSTOMER_PROFILES.dunning_letters%TYPE;
2770: l_dunning_letter_set_id HZ_CUSTOMER_PROFILES.dunning_letter_set_id%TYPE;
2771: l_send_statements HZ_CUSTOMER_PROFILES.send_statements%TYPE;
2772: l_statement_cycle_id HZ_CUSTOMER_PROFILES.statement_cycle_id%TYPE;
2773: l_credit_balance_statements HZ_CUSTOMER_PROFILES.credit_balance_statements%TYPE;
2774: l_interest_charges HZ_CUSTOMER_PROFILES.interest_charges%TYPE;
2775: l_finance_charge_flag HZ_CUSTOMER_PROFILES.charge_on_finance_charge_flag%TYPE;

Line 2772: l_statement_cycle_id HZ_CUSTOMER_PROFILES.statement_cycle_id%TYPE;

2768: l_discount_grace_days HZ_CUSTOMER_PROFILES.discount_grace_days%TYPE;
2769: l_dunning_letters HZ_CUSTOMER_PROFILES.dunning_letters%TYPE;
2770: l_dunning_letter_set_id HZ_CUSTOMER_PROFILES.dunning_letter_set_id%TYPE;
2771: l_send_statements HZ_CUSTOMER_PROFILES.send_statements%TYPE;
2772: l_statement_cycle_id HZ_CUSTOMER_PROFILES.statement_cycle_id%TYPE;
2773: l_credit_balance_statements HZ_CUSTOMER_PROFILES.credit_balance_statements%TYPE;
2774: l_interest_charges HZ_CUSTOMER_PROFILES.interest_charges%TYPE;
2775: l_finance_charge_flag HZ_CUSTOMER_PROFILES.charge_on_finance_charge_flag%TYPE;
2776: l_interest_period_days HZ_CUSTOMER_PROFILES.interest_period_days%TYPE;

Line 2773: l_credit_balance_statements HZ_CUSTOMER_PROFILES.credit_balance_statements%TYPE;

2769: l_dunning_letters HZ_CUSTOMER_PROFILES.dunning_letters%TYPE;
2770: l_dunning_letter_set_id HZ_CUSTOMER_PROFILES.dunning_letter_set_id%TYPE;
2771: l_send_statements HZ_CUSTOMER_PROFILES.send_statements%TYPE;
2772: l_statement_cycle_id HZ_CUSTOMER_PROFILES.statement_cycle_id%TYPE;
2773: l_credit_balance_statements HZ_CUSTOMER_PROFILES.credit_balance_statements%TYPE;
2774: l_interest_charges HZ_CUSTOMER_PROFILES.interest_charges%TYPE;
2775: l_finance_charge_flag HZ_CUSTOMER_PROFILES.charge_on_finance_charge_flag%TYPE;
2776: l_interest_period_days HZ_CUSTOMER_PROFILES.interest_period_days%TYPE;
2777:

Line 2774: l_interest_charges HZ_CUSTOMER_PROFILES.interest_charges%TYPE;

2770: l_dunning_letter_set_id HZ_CUSTOMER_PROFILES.dunning_letter_set_id%TYPE;
2771: l_send_statements HZ_CUSTOMER_PROFILES.send_statements%TYPE;
2772: l_statement_cycle_id HZ_CUSTOMER_PROFILES.statement_cycle_id%TYPE;
2773: l_credit_balance_statements HZ_CUSTOMER_PROFILES.credit_balance_statements%TYPE;
2774: l_interest_charges HZ_CUSTOMER_PROFILES.interest_charges%TYPE;
2775: l_finance_charge_flag HZ_CUSTOMER_PROFILES.charge_on_finance_charge_flag%TYPE;
2776: l_interest_period_days HZ_CUSTOMER_PROFILES.interest_period_days%TYPE;
2777:
2778: l_account_status HZ_CUSTOMER_PROFILES.ACCOUNT_STATUS%TYPE;

Line 2775: l_finance_charge_flag HZ_CUSTOMER_PROFILES.charge_on_finance_charge_flag%TYPE;

2771: l_send_statements HZ_CUSTOMER_PROFILES.send_statements%TYPE;
2772: l_statement_cycle_id HZ_CUSTOMER_PROFILES.statement_cycle_id%TYPE;
2773: l_credit_balance_statements HZ_CUSTOMER_PROFILES.credit_balance_statements%TYPE;
2774: l_interest_charges HZ_CUSTOMER_PROFILES.interest_charges%TYPE;
2775: l_finance_charge_flag HZ_CUSTOMER_PROFILES.charge_on_finance_charge_flag%TYPE;
2776: l_interest_period_days HZ_CUSTOMER_PROFILES.interest_period_days%TYPE;
2777:
2778: l_account_status HZ_CUSTOMER_PROFILES.ACCOUNT_STATUS%TYPE;
2779: l_tolerance HZ_CUSTOMER_PROFILES.TOLERANCE%TYPE;

Line 2776: l_interest_period_days HZ_CUSTOMER_PROFILES.interest_period_days%TYPE;

2772: l_statement_cycle_id HZ_CUSTOMER_PROFILES.statement_cycle_id%TYPE;
2773: l_credit_balance_statements HZ_CUSTOMER_PROFILES.credit_balance_statements%TYPE;
2774: l_interest_charges HZ_CUSTOMER_PROFILES.interest_charges%TYPE;
2775: l_finance_charge_flag HZ_CUSTOMER_PROFILES.charge_on_finance_charge_flag%TYPE;
2776: l_interest_period_days HZ_CUSTOMER_PROFILES.interest_period_days%TYPE;
2777:
2778: l_account_status HZ_CUSTOMER_PROFILES.ACCOUNT_STATUS%TYPE;
2779: l_tolerance HZ_CUSTOMER_PROFILES.TOLERANCE%TYPE;
2780: l_percent_collectable HZ_CUSTOMER_PROFILES.PERCENT_COLLECTABLE%TYPE;

Line 2778: l_account_status HZ_CUSTOMER_PROFILES.ACCOUNT_STATUS%TYPE;

2774: l_interest_charges HZ_CUSTOMER_PROFILES.interest_charges%TYPE;
2775: l_finance_charge_flag HZ_CUSTOMER_PROFILES.charge_on_finance_charge_flag%TYPE;
2776: l_interest_period_days HZ_CUSTOMER_PROFILES.interest_period_days%TYPE;
2777:
2778: l_account_status HZ_CUSTOMER_PROFILES.ACCOUNT_STATUS%TYPE;
2779: l_tolerance HZ_CUSTOMER_PROFILES.TOLERANCE%TYPE;
2780: l_percent_collectable HZ_CUSTOMER_PROFILES.PERCENT_COLLECTABLE%TYPE;
2781: l_standard_terms HZ_CUSTOMER_PROFILES.STANDARD_TERMS%TYPE;
2782: l_override_terms HZ_CUSTOMER_PROFILES.OVERRIDE_TERMS%TYPE;

Line 2779: l_tolerance HZ_CUSTOMER_PROFILES.TOLERANCE%TYPE;

2775: l_finance_charge_flag HZ_CUSTOMER_PROFILES.charge_on_finance_charge_flag%TYPE;
2776: l_interest_period_days HZ_CUSTOMER_PROFILES.interest_period_days%TYPE;
2777:
2778: l_account_status HZ_CUSTOMER_PROFILES.ACCOUNT_STATUS%TYPE;
2779: l_tolerance HZ_CUSTOMER_PROFILES.TOLERANCE%TYPE;
2780: l_percent_collectable HZ_CUSTOMER_PROFILES.PERCENT_COLLECTABLE%TYPE;
2781: l_standard_terms HZ_CUSTOMER_PROFILES.STANDARD_TERMS%TYPE;
2782: l_override_terms HZ_CUSTOMER_PROFILES.OVERRIDE_TERMS%TYPE;
2783: l_lockbox_matching_option HZ_CUSTOMER_PROFILES.LOCKBOX_MATCHING_OPTION%TYPE;

Line 2780: l_percent_collectable HZ_CUSTOMER_PROFILES.PERCENT_COLLECTABLE%TYPE;

2776: l_interest_period_days HZ_CUSTOMER_PROFILES.interest_period_days%TYPE;
2777:
2778: l_account_status HZ_CUSTOMER_PROFILES.ACCOUNT_STATUS%TYPE;
2779: l_tolerance HZ_CUSTOMER_PROFILES.TOLERANCE%TYPE;
2780: l_percent_collectable HZ_CUSTOMER_PROFILES.PERCENT_COLLECTABLE%TYPE;
2781: l_standard_terms HZ_CUSTOMER_PROFILES.STANDARD_TERMS%TYPE;
2782: l_override_terms HZ_CUSTOMER_PROFILES.OVERRIDE_TERMS%TYPE;
2783: l_lockbox_matching_option HZ_CUSTOMER_PROFILES.LOCKBOX_MATCHING_OPTION%TYPE;
2784: l_autocash_hierarchy_id HZ_CUSTOMER_PROFILES.AUTOCASH_HIERARCHY_ID%TYPE;

Line 2781: l_standard_terms HZ_CUSTOMER_PROFILES.STANDARD_TERMS%TYPE;

2777:
2778: l_account_status HZ_CUSTOMER_PROFILES.ACCOUNT_STATUS%TYPE;
2779: l_tolerance HZ_CUSTOMER_PROFILES.TOLERANCE%TYPE;
2780: l_percent_collectable HZ_CUSTOMER_PROFILES.PERCENT_COLLECTABLE%TYPE;
2781: l_standard_terms HZ_CUSTOMER_PROFILES.STANDARD_TERMS%TYPE;
2782: l_override_terms HZ_CUSTOMER_PROFILES.OVERRIDE_TERMS%TYPE;
2783: l_lockbox_matching_option HZ_CUSTOMER_PROFILES.LOCKBOX_MATCHING_OPTION%TYPE;
2784: l_autocash_hierarchy_id HZ_CUSTOMER_PROFILES.AUTOCASH_HIERARCHY_ID%TYPE;
2785: l_autocash_hierarchy_id_for_ad HZ_CUSTOMER_PROFILES.AUTOCASH_HIERARCHY_ID_FOR_ADR%TYPE;

Line 2782: l_override_terms HZ_CUSTOMER_PROFILES.OVERRIDE_TERMS%TYPE;

2778: l_account_status HZ_CUSTOMER_PROFILES.ACCOUNT_STATUS%TYPE;
2779: l_tolerance HZ_CUSTOMER_PROFILES.TOLERANCE%TYPE;
2780: l_percent_collectable HZ_CUSTOMER_PROFILES.PERCENT_COLLECTABLE%TYPE;
2781: l_standard_terms HZ_CUSTOMER_PROFILES.STANDARD_TERMS%TYPE;
2782: l_override_terms HZ_CUSTOMER_PROFILES.OVERRIDE_TERMS%TYPE;
2783: l_lockbox_matching_option HZ_CUSTOMER_PROFILES.LOCKBOX_MATCHING_OPTION%TYPE;
2784: l_autocash_hierarchy_id HZ_CUSTOMER_PROFILES.AUTOCASH_HIERARCHY_ID%TYPE;
2785: l_autocash_hierarchy_id_for_ad HZ_CUSTOMER_PROFILES.AUTOCASH_HIERARCHY_ID_FOR_ADR%TYPE;
2786: l_clearing_days HZ_CUSTOMER_PROFILES.CLEARING_DAYS%TYPE;

Line 2783: l_lockbox_matching_option HZ_CUSTOMER_PROFILES.LOCKBOX_MATCHING_OPTION%TYPE;

2779: l_tolerance HZ_CUSTOMER_PROFILES.TOLERANCE%TYPE;
2780: l_percent_collectable HZ_CUSTOMER_PROFILES.PERCENT_COLLECTABLE%TYPE;
2781: l_standard_terms HZ_CUSTOMER_PROFILES.STANDARD_TERMS%TYPE;
2782: l_override_terms HZ_CUSTOMER_PROFILES.OVERRIDE_TERMS%TYPE;
2783: l_lockbox_matching_option HZ_CUSTOMER_PROFILES.LOCKBOX_MATCHING_OPTION%TYPE;
2784: l_autocash_hierarchy_id HZ_CUSTOMER_PROFILES.AUTOCASH_HIERARCHY_ID%TYPE;
2785: l_autocash_hierarchy_id_for_ad HZ_CUSTOMER_PROFILES.AUTOCASH_HIERARCHY_ID_FOR_ADR%TYPE;
2786: l_clearing_days HZ_CUSTOMER_PROFILES.CLEARING_DAYS%TYPE;
2787: l_payment_grace_days HZ_CUSTOMER_PROFILES.PAYMENT_GRACE_DAYS%TYPE;

Line 2784: l_autocash_hierarchy_id HZ_CUSTOMER_PROFILES.AUTOCASH_HIERARCHY_ID%TYPE;

2780: l_percent_collectable HZ_CUSTOMER_PROFILES.PERCENT_COLLECTABLE%TYPE;
2781: l_standard_terms HZ_CUSTOMER_PROFILES.STANDARD_TERMS%TYPE;
2782: l_override_terms HZ_CUSTOMER_PROFILES.OVERRIDE_TERMS%TYPE;
2783: l_lockbox_matching_option HZ_CUSTOMER_PROFILES.LOCKBOX_MATCHING_OPTION%TYPE;
2784: l_autocash_hierarchy_id HZ_CUSTOMER_PROFILES.AUTOCASH_HIERARCHY_ID%TYPE;
2785: l_autocash_hierarchy_id_for_ad HZ_CUSTOMER_PROFILES.AUTOCASH_HIERARCHY_ID_FOR_ADR%TYPE;
2786: l_clearing_days HZ_CUSTOMER_PROFILES.CLEARING_DAYS%TYPE;
2787: l_payment_grace_days HZ_CUSTOMER_PROFILES.PAYMENT_GRACE_DAYS%TYPE;
2788: l_grouping_rule_id HZ_CUSTOMER_PROFILES.GROUPING_RULE_ID%TYPE;

Line 2785: l_autocash_hierarchy_id_for_ad HZ_CUSTOMER_PROFILES.AUTOCASH_HIERARCHY_ID_FOR_ADR%TYPE;

2781: l_standard_terms HZ_CUSTOMER_PROFILES.STANDARD_TERMS%TYPE;
2782: l_override_terms HZ_CUSTOMER_PROFILES.OVERRIDE_TERMS%TYPE;
2783: l_lockbox_matching_option HZ_CUSTOMER_PROFILES.LOCKBOX_MATCHING_OPTION%TYPE;
2784: l_autocash_hierarchy_id HZ_CUSTOMER_PROFILES.AUTOCASH_HIERARCHY_ID%TYPE;
2785: l_autocash_hierarchy_id_for_ad HZ_CUSTOMER_PROFILES.AUTOCASH_HIERARCHY_ID_FOR_ADR%TYPE;
2786: l_clearing_days HZ_CUSTOMER_PROFILES.CLEARING_DAYS%TYPE;
2787: l_payment_grace_days HZ_CUSTOMER_PROFILES.PAYMENT_GRACE_DAYS%TYPE;
2788: l_grouping_rule_id HZ_CUSTOMER_PROFILES.GROUPING_RULE_ID%TYPE;
2789: l_tax_printing_option HZ_CUSTOMER_PROFILES.TAX_PRINTING_OPTION%TYPE;

Line 2786: l_clearing_days HZ_CUSTOMER_PROFILES.CLEARING_DAYS%TYPE;

2782: l_override_terms HZ_CUSTOMER_PROFILES.OVERRIDE_TERMS%TYPE;
2783: l_lockbox_matching_option HZ_CUSTOMER_PROFILES.LOCKBOX_MATCHING_OPTION%TYPE;
2784: l_autocash_hierarchy_id HZ_CUSTOMER_PROFILES.AUTOCASH_HIERARCHY_ID%TYPE;
2785: l_autocash_hierarchy_id_for_ad HZ_CUSTOMER_PROFILES.AUTOCASH_HIERARCHY_ID_FOR_ADR%TYPE;
2786: l_clearing_days HZ_CUSTOMER_PROFILES.CLEARING_DAYS%TYPE;
2787: l_payment_grace_days HZ_CUSTOMER_PROFILES.PAYMENT_GRACE_DAYS%TYPE;
2788: l_grouping_rule_id HZ_CUSTOMER_PROFILES.GROUPING_RULE_ID%TYPE;
2789: l_tax_printing_option HZ_CUSTOMER_PROFILES.TAX_PRINTING_OPTION%TYPE;
2790: l_review_cycle HZ_CUSTOMER_PROFILES.REVIEW_CYCLE%TYPE;

Line 2787: l_payment_grace_days HZ_CUSTOMER_PROFILES.PAYMENT_GRACE_DAYS%TYPE;

2783: l_lockbox_matching_option HZ_CUSTOMER_PROFILES.LOCKBOX_MATCHING_OPTION%TYPE;
2784: l_autocash_hierarchy_id HZ_CUSTOMER_PROFILES.AUTOCASH_HIERARCHY_ID%TYPE;
2785: l_autocash_hierarchy_id_for_ad HZ_CUSTOMER_PROFILES.AUTOCASH_HIERARCHY_ID_FOR_ADR%TYPE;
2786: l_clearing_days HZ_CUSTOMER_PROFILES.CLEARING_DAYS%TYPE;
2787: l_payment_grace_days HZ_CUSTOMER_PROFILES.PAYMENT_GRACE_DAYS%TYPE;
2788: l_grouping_rule_id HZ_CUSTOMER_PROFILES.GROUPING_RULE_ID%TYPE;
2789: l_tax_printing_option HZ_CUSTOMER_PROFILES.TAX_PRINTING_OPTION%TYPE;
2790: l_review_cycle HZ_CUSTOMER_PROFILES.REVIEW_CYCLE%TYPE;
2791: l_last_credit_review_date HZ_CUSTOMER_PROFILES.LAST_CREDIT_REVIEW_DATE%TYPE;

Line 2788: l_grouping_rule_id HZ_CUSTOMER_PROFILES.GROUPING_RULE_ID%TYPE;

2784: l_autocash_hierarchy_id HZ_CUSTOMER_PROFILES.AUTOCASH_HIERARCHY_ID%TYPE;
2785: l_autocash_hierarchy_id_for_ad HZ_CUSTOMER_PROFILES.AUTOCASH_HIERARCHY_ID_FOR_ADR%TYPE;
2786: l_clearing_days HZ_CUSTOMER_PROFILES.CLEARING_DAYS%TYPE;
2787: l_payment_grace_days HZ_CUSTOMER_PROFILES.PAYMENT_GRACE_DAYS%TYPE;
2788: l_grouping_rule_id HZ_CUSTOMER_PROFILES.GROUPING_RULE_ID%TYPE;
2789: l_tax_printing_option HZ_CUSTOMER_PROFILES.TAX_PRINTING_OPTION%TYPE;
2790: l_review_cycle HZ_CUSTOMER_PROFILES.REVIEW_CYCLE%TYPE;
2791: l_last_credit_review_date HZ_CUSTOMER_PROFILES.LAST_CREDIT_REVIEW_DATE%TYPE;
2792: l_next_credit_review_date HZ_CUSTOMER_PROFILES.NEXT_CREDIT_REVIEW_DATE%TYPE;

Line 2789: l_tax_printing_option HZ_CUSTOMER_PROFILES.TAX_PRINTING_OPTION%TYPE;

2785: l_autocash_hierarchy_id_for_ad HZ_CUSTOMER_PROFILES.AUTOCASH_HIERARCHY_ID_FOR_ADR%TYPE;
2786: l_clearing_days HZ_CUSTOMER_PROFILES.CLEARING_DAYS%TYPE;
2787: l_payment_grace_days HZ_CUSTOMER_PROFILES.PAYMENT_GRACE_DAYS%TYPE;
2788: l_grouping_rule_id HZ_CUSTOMER_PROFILES.GROUPING_RULE_ID%TYPE;
2789: l_tax_printing_option HZ_CUSTOMER_PROFILES.TAX_PRINTING_OPTION%TYPE;
2790: l_review_cycle HZ_CUSTOMER_PROFILES.REVIEW_CYCLE%TYPE;
2791: l_last_credit_review_date HZ_CUSTOMER_PROFILES.LAST_CREDIT_REVIEW_DATE%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;

Line 2790: l_review_cycle HZ_CUSTOMER_PROFILES.REVIEW_CYCLE%TYPE;

2786: l_clearing_days HZ_CUSTOMER_PROFILES.CLEARING_DAYS%TYPE;
2787: l_payment_grace_days HZ_CUSTOMER_PROFILES.PAYMENT_GRACE_DAYS%TYPE;
2788: l_grouping_rule_id HZ_CUSTOMER_PROFILES.GROUPING_RULE_ID%TYPE;
2789: l_tax_printing_option HZ_CUSTOMER_PROFILES.TAX_PRINTING_OPTION%TYPE;
2790: l_review_cycle HZ_CUSTOMER_PROFILES.REVIEW_CYCLE%TYPE;
2791: l_last_credit_review_date HZ_CUSTOMER_PROFILES.LAST_CREDIT_REVIEW_DATE%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;

Line 2791: l_last_credit_review_date HZ_CUSTOMER_PROFILES.LAST_CREDIT_REVIEW_DATE%TYPE;

2787: l_payment_grace_days HZ_CUSTOMER_PROFILES.PAYMENT_GRACE_DAYS%TYPE;
2788: l_grouping_rule_id HZ_CUSTOMER_PROFILES.GROUPING_RULE_ID%TYPE;
2789: l_tax_printing_option HZ_CUSTOMER_PROFILES.TAX_PRINTING_OPTION%TYPE;
2790: l_review_cycle HZ_CUSTOMER_PROFILES.REVIEW_CYCLE%TYPE;
2791: l_last_credit_review_date HZ_CUSTOMER_PROFILES.LAST_CREDIT_REVIEW_DATE%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:

Line 2792: l_next_credit_review_date HZ_CUSTOMER_PROFILES.NEXT_CREDIT_REVIEW_DATE%TYPE;

2788: l_grouping_rule_id HZ_CUSTOMER_PROFILES.GROUPING_RULE_ID%TYPE;
2789: l_tax_printing_option HZ_CUSTOMER_PROFILES.TAX_PRINTING_OPTION%TYPE;
2790: l_review_cycle HZ_CUSTOMER_PROFILES.REVIEW_CYCLE%TYPE;
2791: l_last_credit_review_date HZ_CUSTOMER_PROFILES.LAST_CREDIT_REVIEW_DATE%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;

Line 2793: l_party_id HZ_CUSTOMER_PROFILES.PARTY_ID%TYPE;

2789: l_tax_printing_option HZ_CUSTOMER_PROFILES.TAX_PRINTING_OPTION%TYPE;
2790: l_review_cycle HZ_CUSTOMER_PROFILES.REVIEW_CYCLE%TYPE;
2791: l_last_credit_review_date HZ_CUSTOMER_PROFILES.LAST_CREDIT_REVIEW_DATE%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);

Line 2794: l_credit_classification HZ_CUSTOMER_PROFILES.CREDIT_CLASSIFICATION%TYPE;

2790: l_review_cycle HZ_CUSTOMER_PROFILES.REVIEW_CYCLE%TYPE;
2791: l_last_credit_review_date HZ_CUSTOMER_PROFILES.LAST_CREDIT_REVIEW_DATE%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;

Line 2804: l_late_charge_calculation_trx HZ_CUSTOMER_PROFILES.LATE_CHARGE_CALCULATION_TRX%TYPE;

2800: l_ckeck_acc_bfb_enabled VARCHAR2(1);
2801: ll_cons_inv_flag VARCHAR2(1);
2802:
2803: -- Added following variables for late charge policy project.
2804: l_late_charge_calculation_trx HZ_CUSTOMER_PROFILES.LATE_CHARGE_CALCULATION_TRX%TYPE;
2805: l_credit_items_flag HZ_CUSTOMER_PROFILES.CREDIT_ITEMS_FLAG%TYPE;
2806: l_disputed_transactions_flag HZ_CUSTOMER_PROFILES.DISPUTED_TRANSACTIONS_FLAG%TYPE;
2807: l_late_charge_type HZ_CUSTOMER_PROFILES.LATE_CHARGE_TYPE%TYPE;
2808: l_late_charge_term_id HZ_CUSTOMER_PROFILES.LATE_CHARGE_TERM_ID%TYPE;

Line 2805: l_credit_items_flag HZ_CUSTOMER_PROFILES.CREDIT_ITEMS_FLAG%TYPE;

2801: ll_cons_inv_flag VARCHAR2(1);
2802:
2803: -- Added following variables for late charge policy project.
2804: l_late_charge_calculation_trx HZ_CUSTOMER_PROFILES.LATE_CHARGE_CALCULATION_TRX%TYPE;
2805: l_credit_items_flag HZ_CUSTOMER_PROFILES.CREDIT_ITEMS_FLAG%TYPE;
2806: l_disputed_transactions_flag HZ_CUSTOMER_PROFILES.DISPUTED_TRANSACTIONS_FLAG%TYPE;
2807: l_late_charge_type HZ_CUSTOMER_PROFILES.LATE_CHARGE_TYPE%TYPE;
2808: l_late_charge_term_id HZ_CUSTOMER_PROFILES.LATE_CHARGE_TERM_ID%TYPE;
2809: l_interest_calculation_period HZ_CUSTOMER_PROFILES.INTEREST_CALCULATION_PERIOD%TYPE;

Line 2806: l_disputed_transactions_flag HZ_CUSTOMER_PROFILES.DISPUTED_TRANSACTIONS_FLAG%TYPE;

2802:
2803: -- Added following variables for late charge policy project.
2804: l_late_charge_calculation_trx HZ_CUSTOMER_PROFILES.LATE_CHARGE_CALCULATION_TRX%TYPE;
2805: l_credit_items_flag HZ_CUSTOMER_PROFILES.CREDIT_ITEMS_FLAG%TYPE;
2806: l_disputed_transactions_flag HZ_CUSTOMER_PROFILES.DISPUTED_TRANSACTIONS_FLAG%TYPE;
2807: l_late_charge_type HZ_CUSTOMER_PROFILES.LATE_CHARGE_TYPE%TYPE;
2808: l_late_charge_term_id HZ_CUSTOMER_PROFILES.LATE_CHARGE_TERM_ID%TYPE;
2809: l_interest_calculation_period HZ_CUSTOMER_PROFILES.INTEREST_CALCULATION_PERIOD%TYPE;
2810: l_hold_charged_invoices_flag HZ_CUSTOMER_PROFILES.HOLD_CHARGED_INVOICES_FLAG%TYPE;

Line 2807: l_late_charge_type HZ_CUSTOMER_PROFILES.LATE_CHARGE_TYPE%TYPE;

2803: -- Added following variables for late charge policy project.
2804: l_late_charge_calculation_trx HZ_CUSTOMER_PROFILES.LATE_CHARGE_CALCULATION_TRX%TYPE;
2805: l_credit_items_flag HZ_CUSTOMER_PROFILES.CREDIT_ITEMS_FLAG%TYPE;
2806: l_disputed_transactions_flag HZ_CUSTOMER_PROFILES.DISPUTED_TRANSACTIONS_FLAG%TYPE;
2807: l_late_charge_type HZ_CUSTOMER_PROFILES.LATE_CHARGE_TYPE%TYPE;
2808: l_late_charge_term_id HZ_CUSTOMER_PROFILES.LATE_CHARGE_TERM_ID%TYPE;
2809: l_interest_calculation_period HZ_CUSTOMER_PROFILES.INTEREST_CALCULATION_PERIOD%TYPE;
2810: l_hold_charged_invoices_flag HZ_CUSTOMER_PROFILES.HOLD_CHARGED_INVOICES_FLAG%TYPE;
2811: l_message_Text_id HZ_CUSTOMER_PROFILES.MESSAGE_TEXT_ID%TYPE;

Line 2808: l_late_charge_term_id HZ_CUSTOMER_PROFILES.LATE_CHARGE_TERM_ID%TYPE;

2804: l_late_charge_calculation_trx HZ_CUSTOMER_PROFILES.LATE_CHARGE_CALCULATION_TRX%TYPE;
2805: l_credit_items_flag HZ_CUSTOMER_PROFILES.CREDIT_ITEMS_FLAG%TYPE;
2806: l_disputed_transactions_flag HZ_CUSTOMER_PROFILES.DISPUTED_TRANSACTIONS_FLAG%TYPE;
2807: l_late_charge_type HZ_CUSTOMER_PROFILES.LATE_CHARGE_TYPE%TYPE;
2808: l_late_charge_term_id HZ_CUSTOMER_PROFILES.LATE_CHARGE_TERM_ID%TYPE;
2809: l_interest_calculation_period HZ_CUSTOMER_PROFILES.INTEREST_CALCULATION_PERIOD%TYPE;
2810: l_hold_charged_invoices_flag HZ_CUSTOMER_PROFILES.HOLD_CHARGED_INVOICES_FLAG%TYPE;
2811: l_message_Text_id HZ_CUSTOMER_PROFILES.MESSAGE_TEXT_ID%TYPE;
2812: l_multiple_Interest_Rates_flag HZ_CUSTOMER_PROFILES.MULTIPLE_INTEREST_RATES_FLAG%TYPE;

Line 2809: l_interest_calculation_period HZ_CUSTOMER_PROFILES.INTEREST_CALCULATION_PERIOD%TYPE;

2805: l_credit_items_flag HZ_CUSTOMER_PROFILES.CREDIT_ITEMS_FLAG%TYPE;
2806: l_disputed_transactions_flag HZ_CUSTOMER_PROFILES.DISPUTED_TRANSACTIONS_FLAG%TYPE;
2807: l_late_charge_type HZ_CUSTOMER_PROFILES.LATE_CHARGE_TYPE%TYPE;
2808: l_late_charge_term_id HZ_CUSTOMER_PROFILES.LATE_CHARGE_TERM_ID%TYPE;
2809: l_interest_calculation_period HZ_CUSTOMER_PROFILES.INTEREST_CALCULATION_PERIOD%TYPE;
2810: l_hold_charged_invoices_flag HZ_CUSTOMER_PROFILES.HOLD_CHARGED_INVOICES_FLAG%TYPE;
2811: l_message_Text_id HZ_CUSTOMER_PROFILES.MESSAGE_TEXT_ID%TYPE;
2812: l_multiple_Interest_Rates_flag HZ_CUSTOMER_PROFILES.MULTIPLE_INTEREST_RATES_FLAG%TYPE;
2813: l_charge_begin_date HZ_CUSTOMER_PROFILES.CHARGE_BEGIN_DATE%TYPE;

Line 2810: l_hold_charged_invoices_flag HZ_CUSTOMER_PROFILES.HOLD_CHARGED_INVOICES_FLAG%TYPE;

2806: l_disputed_transactions_flag HZ_CUSTOMER_PROFILES.DISPUTED_TRANSACTIONS_FLAG%TYPE;
2807: l_late_charge_type HZ_CUSTOMER_PROFILES.LATE_CHARGE_TYPE%TYPE;
2808: l_late_charge_term_id HZ_CUSTOMER_PROFILES.LATE_CHARGE_TERM_ID%TYPE;
2809: l_interest_calculation_period HZ_CUSTOMER_PROFILES.INTEREST_CALCULATION_PERIOD%TYPE;
2810: l_hold_charged_invoices_flag HZ_CUSTOMER_PROFILES.HOLD_CHARGED_INVOICES_FLAG%TYPE;
2811: l_message_Text_id HZ_CUSTOMER_PROFILES.MESSAGE_TEXT_ID%TYPE;
2812: l_multiple_Interest_Rates_flag HZ_CUSTOMER_PROFILES.MULTIPLE_INTEREST_RATES_FLAG%TYPE;
2813: l_charge_begin_date HZ_CUSTOMER_PROFILES.CHARGE_BEGIN_DATE%TYPE;
2814:

Line 2811: l_message_Text_id HZ_CUSTOMER_PROFILES.MESSAGE_TEXT_ID%TYPE;

2807: l_late_charge_type HZ_CUSTOMER_PROFILES.LATE_CHARGE_TYPE%TYPE;
2808: l_late_charge_term_id HZ_CUSTOMER_PROFILES.LATE_CHARGE_TERM_ID%TYPE;
2809: l_interest_calculation_period HZ_CUSTOMER_PROFILES.INTEREST_CALCULATION_PERIOD%TYPE;
2810: l_hold_charged_invoices_flag HZ_CUSTOMER_PROFILES.HOLD_CHARGED_INVOICES_FLAG%TYPE;
2811: l_message_Text_id HZ_CUSTOMER_PROFILES.MESSAGE_TEXT_ID%TYPE;
2812: l_multiple_Interest_Rates_flag HZ_CUSTOMER_PROFILES.MULTIPLE_INTEREST_RATES_FLAG%TYPE;
2813: l_charge_begin_date HZ_CUSTOMER_PROFILES.CHARGE_BEGIN_DATE%TYPE;
2814:
2815: BEGIN

Line 2812: l_multiple_Interest_Rates_flag HZ_CUSTOMER_PROFILES.MULTIPLE_INTEREST_RATES_FLAG%TYPE;

2808: l_late_charge_term_id HZ_CUSTOMER_PROFILES.LATE_CHARGE_TERM_ID%TYPE;
2809: l_interest_calculation_period HZ_CUSTOMER_PROFILES.INTEREST_CALCULATION_PERIOD%TYPE;
2810: l_hold_charged_invoices_flag HZ_CUSTOMER_PROFILES.HOLD_CHARGED_INVOICES_FLAG%TYPE;
2811: l_message_Text_id HZ_CUSTOMER_PROFILES.MESSAGE_TEXT_ID%TYPE;
2812: l_multiple_Interest_Rates_flag HZ_CUSTOMER_PROFILES.MULTIPLE_INTEREST_RATES_FLAG%TYPE;
2813: l_charge_begin_date HZ_CUSTOMER_PROFILES.CHARGE_BEGIN_DATE%TYPE;
2814:
2815: BEGIN
2816:

Line 2813: l_charge_begin_date HZ_CUSTOMER_PROFILES.CHARGE_BEGIN_DATE%TYPE;

2809: l_interest_calculation_period HZ_CUSTOMER_PROFILES.INTEREST_CALCULATION_PERIOD%TYPE;
2810: l_hold_charged_invoices_flag HZ_CUSTOMER_PROFILES.HOLD_CHARGED_INVOICES_FLAG%TYPE;
2811: l_message_Text_id HZ_CUSTOMER_PROFILES.MESSAGE_TEXT_ID%TYPE;
2812: l_multiple_Interest_Rates_flag HZ_CUSTOMER_PROFILES.MULTIPLE_INTEREST_RATES_FLAG%TYPE;
2813: l_charge_begin_date HZ_CUSTOMER_PROFILES.CHARGE_BEGIN_DATE%TYPE;
2814:
2815: BEGIN
2816:
2817: -- Check if API is called in debug mode. If yes, enable debug.

Line 2861: FROM HZ_CUSTOMER_PROFILES

2857: l_credit_classification, l_late_charge_calculation_trx, l_credit_items_flag,
2858: l_disputed_transactions_flag, l_late_charge_type, l_late_charge_term_id,
2859: l_interest_calculation_period, l_hold_charged_invoices_flag, l_message_text_id,
2860: l_multiple_interest_rates_flag, l_charge_begin_date
2861: FROM HZ_CUSTOMER_PROFILES
2862: WHERE ROWID = p_rowid;
2863: END IF;
2864:
2865: --------------------------------------

Line 2881: FROM HZ_CUSTOMER_PROFILES

2877: p_customer_profile_rec.cust_account_profile_id <> FND_API.G_MISS_NUM
2878: THEN
2879: BEGIN
2880: SELECT 'Y' INTO l_dummy
2881: FROM HZ_CUSTOMER_PROFILES
2882: WHERE CUST_ACCOUNT_PROFILE_ID = p_customer_profile_rec.cust_account_profile_id;
2883:
2884: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_DUPLICATE_COLUMN' );
2885: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'cust_account_profile_id' );

Line 3047: FROM HZ_CUSTOMER_PROFILES

3043: p_customer_profile_rec.cust_account_id <> -1
3044: THEN
3045: BEGIN
3046: SELECT 'Y' INTO l_dummy
3047: FROM HZ_CUSTOMER_PROFILES
3048: WHERE CUST_ACCOUNT_ID = p_customer_profile_rec.cust_account_id
3049: AND SITE_USE_ID IS NULL
3050: AND ROWNUM = 1;
3051:

Line 3080: FROM HZ_CUSTOMER_PROFILES

3076: -- One party can only have 1 and only 1 profile directly attachment to the party
3077: -- At party level
3078: BEGIN
3079: SELECT 'Y' INTO l_dummy
3080: FROM HZ_CUSTOMER_PROFILES
3081: WHERE PARTY_ID = p_customer_profile_rec.party_id
3082: AND CUST_ACCOUNT_ID = -1;
3083:
3084: FND_MESSAGE.SET_NAME( 'AR', 'HZ_ONLY_ONE_PROF_AT_PARTY_LEV' );

Line 3494: FROM HZ_CUSTOMER_PROFILES

3490:
3491:
3492: BEGIN
3493: SELECT 'Y' INTO l_dummy
3494: FROM HZ_CUSTOMER_PROFILES
3495: WHERE CUST_ACCOUNT_ID = p_customer_profile_rec.cust_account_id
3496: AND SITE_USE_ID = p_customer_profile_rec.site_use_id
3497: AND ROWNUM = 1;
3498:

Line 4580: from hz_customer_profiles

4576: ll_cons_inv_flag := 'N';
4577: begin
4578: select cons_inv_flag
4579: into ll_cons_inv_flag
4580: from hz_customer_profiles
4581: where cust_account_id = p_customer_profile_rec.cust_account_id
4582: and site_use_id is NULL;
4583: exception when others then
4584: ll_cons_inv_flag := 'N';

Line 4602: from hz_customer_profiles

4598: ll_cons_inv_flag := 'N';
4599: begin
4600: select cons_inv_flag
4601: into ll_cons_inv_flag
4602: from hz_customer_profiles
4603: where cust_account_id = p_customer_profile_rec.cust_account_id
4604: and site_use_id is NULL;
4605: exception when others then
4606: ll_cons_inv_flag := 'N';

Line 5704: -- cust_account_profile_id is foreign key to hz_customer_profiles

5700: p_msg_level=>fnd_log.level_statement);
5701: END IF;
5702: END IF;
5703:
5704: -- cust_account_profile_id is foreign key to hz_customer_profiles
5705: -- Since cust_account_profile_id is mandatory and non-updateable,
5706: -- we only need to check FK during creation.
5707:
5708:

Line 5727: FROM HZ_CUSTOMER_PROFILES

5723: -- Bug 4770111 : select created_by_module also
5724:
5725: SELECT CUST_ACCOUNT_ID, SITE_USE_ID, CREATED_BY_MODULE
5726: INTO l_cust_account_id, l_site_use_id, l_prof_cbm
5727: FROM HZ_CUSTOMER_PROFILES
5728: WHERE CUST_ACCOUNT_PROFILE_ID = p_cust_profile_amt_rec.cust_account_profile_id;
5729:
5730: EXCEPTION
5731: WHEN NO_DATA_FOUND THEN

Line 5735: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_customer_profiles' );

5731: WHEN NO_DATA_FOUND THEN
5732: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
5733: FND_MESSAGE.SET_TOKEN( 'FK', 'cust_account_profile_id' );
5734: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'cust_account_profile_id' );
5735: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_customer_profiles' );
5736: FND_MSG_PUB.ADD;
5737: x_return_status := FND_API.G_RET_STS_ERROR;
5738: END;
5739:

Line 5741: hz_utility_v2pub.debug(p_message=>'cust_account_profile_id is foreign key to hz_customer_profiles. ' ||

5737: x_return_status := FND_API.G_RET_STS_ERROR;
5738: END;
5739:
5740: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5741: hz_utility_v2pub.debug(p_message=>'cust_account_profile_id is foreign key to hz_customer_profiles. ' ||
5742: 'x_return_status = ' || x_return_status,
5743: p_prefix =>l_debug_prefix,
5744: p_msg_level=>fnd_log.level_statement);
5745: END IF;