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_ACCOUNTS

Line 438: l_orig_system_reference HZ_CUST_ACCOUNTS.orig_system_reference%TYPE;

434: -- Bug 3456489
435: -- l_profile AR_SYSTEM_PARAMETERS.generate_customer_number%TYPE;
436: l_profile VARCHAR2(1);
437:
438: l_orig_system_reference HZ_CUST_ACCOUNTS.orig_system_reference%TYPE;
439: l_orig_system_reference1 HZ_CUST_ACCOUNTS.orig_system_reference%TYPE;
440: l_account_established_date HZ_CUST_ACCOUNTS.account_established_date%TYPE;
441: -- l_account_termination_date HZ_CUST_ACCOUNTS.account_termination_date%TYPE;
442: -- l_account_activation_date HZ_CUST_ACCOUNTS.account_activation_date%TYPE;

Line 439: l_orig_system_reference1 HZ_CUST_ACCOUNTS.orig_system_reference%TYPE;

435: -- l_profile AR_SYSTEM_PARAMETERS.generate_customer_number%TYPE;
436: l_profile VARCHAR2(1);
437:
438: l_orig_system_reference HZ_CUST_ACCOUNTS.orig_system_reference%TYPE;
439: l_orig_system_reference1 HZ_CUST_ACCOUNTS.orig_system_reference%TYPE;
440: l_account_established_date HZ_CUST_ACCOUNTS.account_established_date%TYPE;
441: -- l_account_termination_date HZ_CUST_ACCOUNTS.account_termination_date%TYPE;
442: -- l_account_activation_date HZ_CUST_ACCOUNTS.account_activation_date%TYPE;
443: l_created_by_module HZ_CUST_ACCOUNTS.created_by_module%TYPE;

Line 440: l_account_established_date HZ_CUST_ACCOUNTS.account_established_date%TYPE;

436: l_profile VARCHAR2(1);
437:
438: l_orig_system_reference HZ_CUST_ACCOUNTS.orig_system_reference%TYPE;
439: l_orig_system_reference1 HZ_CUST_ACCOUNTS.orig_system_reference%TYPE;
440: l_account_established_date HZ_CUST_ACCOUNTS.account_established_date%TYPE;
441: -- l_account_termination_date HZ_CUST_ACCOUNTS.account_termination_date%TYPE;
442: -- l_account_activation_date HZ_CUST_ACCOUNTS.account_activation_date%TYPE;
443: l_created_by_module HZ_CUST_ACCOUNTS.created_by_module%TYPE;
444: l_application_id NUMBER;

Line 441: -- l_account_termination_date HZ_CUST_ACCOUNTS.account_termination_date%TYPE;

437:
438: l_orig_system_reference HZ_CUST_ACCOUNTS.orig_system_reference%TYPE;
439: l_orig_system_reference1 HZ_CUST_ACCOUNTS.orig_system_reference%TYPE;
440: l_account_established_date HZ_CUST_ACCOUNTS.account_established_date%TYPE;
441: -- l_account_termination_date HZ_CUST_ACCOUNTS.account_termination_date%TYPE;
442: -- l_account_activation_date HZ_CUST_ACCOUNTS.account_activation_date%TYPE;
443: l_created_by_module HZ_CUST_ACCOUNTS.created_by_module%TYPE;
444: l_application_id NUMBER;
445: l_status HZ_CUST_ACCOUNTS.status%TYPE;

Line 442: -- l_account_activation_date HZ_CUST_ACCOUNTS.account_activation_date%TYPE;

438: l_orig_system_reference HZ_CUST_ACCOUNTS.orig_system_reference%TYPE;
439: l_orig_system_reference1 HZ_CUST_ACCOUNTS.orig_system_reference%TYPE;
440: l_account_established_date HZ_CUST_ACCOUNTS.account_established_date%TYPE;
441: -- l_account_termination_date HZ_CUST_ACCOUNTS.account_termination_date%TYPE;
442: -- l_account_activation_date HZ_CUST_ACCOUNTS.account_activation_date%TYPE;
443: l_created_by_module HZ_CUST_ACCOUNTS.created_by_module%TYPE;
444: l_application_id NUMBER;
445: l_status HZ_CUST_ACCOUNTS.status%TYPE;
446: l_customer_type HZ_CUST_ACCOUNTS.customer_type%TYPE;

Line 443: l_created_by_module HZ_CUST_ACCOUNTS.created_by_module%TYPE;

439: l_orig_system_reference1 HZ_CUST_ACCOUNTS.orig_system_reference%TYPE;
440: l_account_established_date HZ_CUST_ACCOUNTS.account_established_date%TYPE;
441: -- l_account_termination_date HZ_CUST_ACCOUNTS.account_termination_date%TYPE;
442: -- l_account_activation_date HZ_CUST_ACCOUNTS.account_activation_date%TYPE;
443: l_created_by_module HZ_CUST_ACCOUNTS.created_by_module%TYPE;
444: l_application_id NUMBER;
445: l_status HZ_CUST_ACCOUNTS.status%TYPE;
446: l_customer_type HZ_CUST_ACCOUNTS.customer_type%TYPE;
447: l_sales_channel_code HZ_CUST_ACCOUNTS.sales_channel_code%TYPE;

Line 445: l_status HZ_CUST_ACCOUNTS.status%TYPE;

441: -- l_account_termination_date HZ_CUST_ACCOUNTS.account_termination_date%TYPE;
442: -- l_account_activation_date HZ_CUST_ACCOUNTS.account_activation_date%TYPE;
443: l_created_by_module HZ_CUST_ACCOUNTS.created_by_module%TYPE;
444: l_application_id NUMBER;
445: l_status HZ_CUST_ACCOUNTS.status%TYPE;
446: l_customer_type HZ_CUST_ACCOUNTS.customer_type%TYPE;
447: l_sales_channel_code HZ_CUST_ACCOUNTS.sales_channel_code%TYPE;
448: l_freight_term HZ_CUST_ACCOUNTS.freight_term%TYPE;
449: l_ship_via HZ_CUST_ACCOUNTS.ship_via%TYPE;

Line 446: l_customer_type HZ_CUST_ACCOUNTS.customer_type%TYPE;

442: -- l_account_activation_date HZ_CUST_ACCOUNTS.account_activation_date%TYPE;
443: l_created_by_module HZ_CUST_ACCOUNTS.created_by_module%TYPE;
444: l_application_id NUMBER;
445: l_status HZ_CUST_ACCOUNTS.status%TYPE;
446: l_customer_type HZ_CUST_ACCOUNTS.customer_type%TYPE;
447: l_sales_channel_code HZ_CUST_ACCOUNTS.sales_channel_code%TYPE;
448: l_freight_term HZ_CUST_ACCOUNTS.freight_term%TYPE;
449: l_ship_via HZ_CUST_ACCOUNTS.ship_via%TYPE;
450: l_ship_sets_inc_lines_f HZ_CUST_ACCOUNTS.ship_sets_include_lines_flag%TYPE;

Line 447: l_sales_channel_code HZ_CUST_ACCOUNTS.sales_channel_code%TYPE;

443: l_created_by_module HZ_CUST_ACCOUNTS.created_by_module%TYPE;
444: l_application_id NUMBER;
445: l_status HZ_CUST_ACCOUNTS.status%TYPE;
446: l_customer_type HZ_CUST_ACCOUNTS.customer_type%TYPE;
447: l_sales_channel_code HZ_CUST_ACCOUNTS.sales_channel_code%TYPE;
448: l_freight_term HZ_CUST_ACCOUNTS.freight_term%TYPE;
449: l_ship_via HZ_CUST_ACCOUNTS.ship_via%TYPE;
450: l_ship_sets_inc_lines_f HZ_CUST_ACCOUNTS.ship_sets_include_lines_flag%TYPE;
451: l_arrivalsets_inc_lines_f HZ_CUST_ACCOUNTS.arrivalsets_include_lines_flag%TYPE;

Line 448: l_freight_term HZ_CUST_ACCOUNTS.freight_term%TYPE;

444: l_application_id NUMBER;
445: l_status HZ_CUST_ACCOUNTS.status%TYPE;
446: l_customer_type HZ_CUST_ACCOUNTS.customer_type%TYPE;
447: l_sales_channel_code HZ_CUST_ACCOUNTS.sales_channel_code%TYPE;
448: l_freight_term HZ_CUST_ACCOUNTS.freight_term%TYPE;
449: l_ship_via HZ_CUST_ACCOUNTS.ship_via%TYPE;
450: l_ship_sets_inc_lines_f HZ_CUST_ACCOUNTS.ship_sets_include_lines_flag%TYPE;
451: l_arrivalsets_inc_lines_f HZ_CUST_ACCOUNTS.arrivalsets_include_lines_flag%TYPE;
452: l_tax_code HZ_CUST_ACCOUNTS.TAX_CODE%TYPE;

Line 449: l_ship_via HZ_CUST_ACCOUNTS.ship_via%TYPE;

445: l_status HZ_CUST_ACCOUNTS.status%TYPE;
446: l_customer_type HZ_CUST_ACCOUNTS.customer_type%TYPE;
447: l_sales_channel_code HZ_CUST_ACCOUNTS.sales_channel_code%TYPE;
448: l_freight_term HZ_CUST_ACCOUNTS.freight_term%TYPE;
449: l_ship_via HZ_CUST_ACCOUNTS.ship_via%TYPE;
450: l_ship_sets_inc_lines_f HZ_CUST_ACCOUNTS.ship_sets_include_lines_flag%TYPE;
451: l_arrivalsets_inc_lines_f HZ_CUST_ACCOUNTS.arrivalsets_include_lines_flag%TYPE;
452: l_tax_code HZ_CUST_ACCOUNTS.TAX_CODE%TYPE;
453: l_invoice_quantity_rule HZ_CUST_ACCOUNTS.INVOICE_QUANTITY_RULE%TYPE;

Line 450: l_ship_sets_inc_lines_f HZ_CUST_ACCOUNTS.ship_sets_include_lines_flag%TYPE;

446: l_customer_type HZ_CUST_ACCOUNTS.customer_type%TYPE;
447: l_sales_channel_code HZ_CUST_ACCOUNTS.sales_channel_code%TYPE;
448: l_freight_term HZ_CUST_ACCOUNTS.freight_term%TYPE;
449: l_ship_via HZ_CUST_ACCOUNTS.ship_via%TYPE;
450: l_ship_sets_inc_lines_f HZ_CUST_ACCOUNTS.ship_sets_include_lines_flag%TYPE;
451: l_arrivalsets_inc_lines_f HZ_CUST_ACCOUNTS.arrivalsets_include_lines_flag%TYPE;
452: l_tax_code HZ_CUST_ACCOUNTS.TAX_CODE%TYPE;
453: l_invoice_quantity_rule HZ_CUST_ACCOUNTS.INVOICE_QUANTITY_RULE%TYPE;
454: -- l_primary_salesrep_id HZ_CUST_ACCOUNTS.PRIMARY_SALESREP_ID%TYPE;

Line 451: l_arrivalsets_inc_lines_f HZ_CUST_ACCOUNTS.arrivalsets_include_lines_flag%TYPE;

447: l_sales_channel_code HZ_CUST_ACCOUNTS.sales_channel_code%TYPE;
448: l_freight_term HZ_CUST_ACCOUNTS.freight_term%TYPE;
449: l_ship_via HZ_CUST_ACCOUNTS.ship_via%TYPE;
450: l_ship_sets_inc_lines_f HZ_CUST_ACCOUNTS.ship_sets_include_lines_flag%TYPE;
451: l_arrivalsets_inc_lines_f HZ_CUST_ACCOUNTS.arrivalsets_include_lines_flag%TYPE;
452: l_tax_code HZ_CUST_ACCOUNTS.TAX_CODE%TYPE;
453: l_invoice_quantity_rule HZ_CUST_ACCOUNTS.INVOICE_QUANTITY_RULE%TYPE;
454: -- l_primary_salesrep_id HZ_CUST_ACCOUNTS.PRIMARY_SALESREP_ID%TYPE;
455: l_order_type_id HZ_CUST_ACCOUNTS.ORDER_TYPE_ID%TYPE;

Line 452: l_tax_code HZ_CUST_ACCOUNTS.TAX_CODE%TYPE;

448: l_freight_term HZ_CUST_ACCOUNTS.freight_term%TYPE;
449: l_ship_via HZ_CUST_ACCOUNTS.ship_via%TYPE;
450: l_ship_sets_inc_lines_f HZ_CUST_ACCOUNTS.ship_sets_include_lines_flag%TYPE;
451: l_arrivalsets_inc_lines_f HZ_CUST_ACCOUNTS.arrivalsets_include_lines_flag%TYPE;
452: l_tax_code HZ_CUST_ACCOUNTS.TAX_CODE%TYPE;
453: l_invoice_quantity_rule HZ_CUST_ACCOUNTS.INVOICE_QUANTITY_RULE%TYPE;
454: -- l_primary_salesrep_id HZ_CUST_ACCOUNTS.PRIMARY_SALESREP_ID%TYPE;
455: l_order_type_id HZ_CUST_ACCOUNTS.ORDER_TYPE_ID%TYPE;
456: l_price_list_id HZ_CUST_ACCOUNTS.PRICE_LIST_ID%TYPE;

Line 453: l_invoice_quantity_rule HZ_CUST_ACCOUNTS.INVOICE_QUANTITY_RULE%TYPE;

449: l_ship_via HZ_CUST_ACCOUNTS.ship_via%TYPE;
450: l_ship_sets_inc_lines_f HZ_CUST_ACCOUNTS.ship_sets_include_lines_flag%TYPE;
451: l_arrivalsets_inc_lines_f HZ_CUST_ACCOUNTS.arrivalsets_include_lines_flag%TYPE;
452: l_tax_code HZ_CUST_ACCOUNTS.TAX_CODE%TYPE;
453: l_invoice_quantity_rule HZ_CUST_ACCOUNTS.INVOICE_QUANTITY_RULE%TYPE;
454: -- l_primary_salesrep_id HZ_CUST_ACCOUNTS.PRIMARY_SALESREP_ID%TYPE;
455: l_order_type_id HZ_CUST_ACCOUNTS.ORDER_TYPE_ID%TYPE;
456: l_price_list_id HZ_CUST_ACCOUNTS.PRICE_LIST_ID%TYPE;
457: -- l_ship_partial HZ_CUST_ACCOUNTS.SHIP_PARTIAL%TYPE;

Line 454: -- l_primary_salesrep_id HZ_CUST_ACCOUNTS.PRIMARY_SALESREP_ID%TYPE;

450: l_ship_sets_inc_lines_f HZ_CUST_ACCOUNTS.ship_sets_include_lines_flag%TYPE;
451: l_arrivalsets_inc_lines_f HZ_CUST_ACCOUNTS.arrivalsets_include_lines_flag%TYPE;
452: l_tax_code HZ_CUST_ACCOUNTS.TAX_CODE%TYPE;
453: l_invoice_quantity_rule HZ_CUST_ACCOUNTS.INVOICE_QUANTITY_RULE%TYPE;
454: -- l_primary_salesrep_id HZ_CUST_ACCOUNTS.PRIMARY_SALESREP_ID%TYPE;
455: l_order_type_id HZ_CUST_ACCOUNTS.ORDER_TYPE_ID%TYPE;
456: l_price_list_id HZ_CUST_ACCOUNTS.PRICE_LIST_ID%TYPE;
457: -- l_ship_partial HZ_CUST_ACCOUNTS.SHIP_PARTIAL%TYPE;
458: l_fob_point HZ_CUST_ACCOUNTS.FOB_POINT%TYPE;

Line 455: l_order_type_id HZ_CUST_ACCOUNTS.ORDER_TYPE_ID%TYPE;

451: l_arrivalsets_inc_lines_f HZ_CUST_ACCOUNTS.arrivalsets_include_lines_flag%TYPE;
452: l_tax_code HZ_CUST_ACCOUNTS.TAX_CODE%TYPE;
453: l_invoice_quantity_rule HZ_CUST_ACCOUNTS.INVOICE_QUANTITY_RULE%TYPE;
454: -- l_primary_salesrep_id HZ_CUST_ACCOUNTS.PRIMARY_SALESREP_ID%TYPE;
455: l_order_type_id HZ_CUST_ACCOUNTS.ORDER_TYPE_ID%TYPE;
456: l_price_list_id HZ_CUST_ACCOUNTS.PRICE_LIST_ID%TYPE;
457: -- l_ship_partial HZ_CUST_ACCOUNTS.SHIP_PARTIAL%TYPE;
458: l_fob_point HZ_CUST_ACCOUNTS.FOB_POINT%TYPE;
459: l_item_cross_ref_pref HZ_CUST_ACCOUNTS.ITEM_CROSS_REF_PREF%TYPE;

Line 456: l_price_list_id HZ_CUST_ACCOUNTS.PRICE_LIST_ID%TYPE;

452: l_tax_code HZ_CUST_ACCOUNTS.TAX_CODE%TYPE;
453: l_invoice_quantity_rule HZ_CUST_ACCOUNTS.INVOICE_QUANTITY_RULE%TYPE;
454: -- l_primary_salesrep_id HZ_CUST_ACCOUNTS.PRIMARY_SALESREP_ID%TYPE;
455: l_order_type_id HZ_CUST_ACCOUNTS.ORDER_TYPE_ID%TYPE;
456: l_price_list_id HZ_CUST_ACCOUNTS.PRICE_LIST_ID%TYPE;
457: -- l_ship_partial HZ_CUST_ACCOUNTS.SHIP_PARTIAL%TYPE;
458: l_fob_point HZ_CUST_ACCOUNTS.FOB_POINT%TYPE;
459: l_item_cross_ref_pref HZ_CUST_ACCOUNTS.ITEM_CROSS_REF_PREF%TYPE;
460: l_warehouse_id HZ_CUST_ACCOUNTS.WAREHOUSE_ID%TYPE;

Line 457: -- l_ship_partial HZ_CUST_ACCOUNTS.SHIP_PARTIAL%TYPE;

453: l_invoice_quantity_rule HZ_CUST_ACCOUNTS.INVOICE_QUANTITY_RULE%TYPE;
454: -- l_primary_salesrep_id HZ_CUST_ACCOUNTS.PRIMARY_SALESREP_ID%TYPE;
455: l_order_type_id HZ_CUST_ACCOUNTS.ORDER_TYPE_ID%TYPE;
456: l_price_list_id HZ_CUST_ACCOUNTS.PRICE_LIST_ID%TYPE;
457: -- l_ship_partial HZ_CUST_ACCOUNTS.SHIP_PARTIAL%TYPE;
458: l_fob_point HZ_CUST_ACCOUNTS.FOB_POINT%TYPE;
459: l_item_cross_ref_pref HZ_CUST_ACCOUNTS.ITEM_CROSS_REF_PREF%TYPE;
460: l_warehouse_id HZ_CUST_ACCOUNTS.WAREHOUSE_ID%TYPE;
461: l_date_type_preference HZ_CUST_ACCOUNTS.DATE_TYPE_PREFERENCE%TYPE;

Line 458: l_fob_point HZ_CUST_ACCOUNTS.FOB_POINT%TYPE;

454: -- l_primary_salesrep_id HZ_CUST_ACCOUNTS.PRIMARY_SALESREP_ID%TYPE;
455: l_order_type_id HZ_CUST_ACCOUNTS.ORDER_TYPE_ID%TYPE;
456: l_price_list_id HZ_CUST_ACCOUNTS.PRICE_LIST_ID%TYPE;
457: -- l_ship_partial HZ_CUST_ACCOUNTS.SHIP_PARTIAL%TYPE;
458: l_fob_point HZ_CUST_ACCOUNTS.FOB_POINT%TYPE;
459: l_item_cross_ref_pref HZ_CUST_ACCOUNTS.ITEM_CROSS_REF_PREF%TYPE;
460: l_warehouse_id HZ_CUST_ACCOUNTS.WAREHOUSE_ID%TYPE;
461: l_date_type_preference HZ_CUST_ACCOUNTS.DATE_TYPE_PREFERENCE%TYPE;
462: l_customer_class_code HZ_CUST_ACCOUNTS.CUSTOMER_CLASS_CODE%TYPE;

Line 459: l_item_cross_ref_pref HZ_CUST_ACCOUNTS.ITEM_CROSS_REF_PREF%TYPE;

455: l_order_type_id HZ_CUST_ACCOUNTS.ORDER_TYPE_ID%TYPE;
456: l_price_list_id HZ_CUST_ACCOUNTS.PRICE_LIST_ID%TYPE;
457: -- l_ship_partial HZ_CUST_ACCOUNTS.SHIP_PARTIAL%TYPE;
458: l_fob_point HZ_CUST_ACCOUNTS.FOB_POINT%TYPE;
459: l_item_cross_ref_pref HZ_CUST_ACCOUNTS.ITEM_CROSS_REF_PREF%TYPE;
460: l_warehouse_id HZ_CUST_ACCOUNTS.WAREHOUSE_ID%TYPE;
461: l_date_type_preference HZ_CUST_ACCOUNTS.DATE_TYPE_PREFERENCE%TYPE;
462: l_customer_class_code HZ_CUST_ACCOUNTS.CUSTOMER_CLASS_CODE%TYPE;
463: l_tax_rounding_rule HZ_CUST_ACCOUNTS.TAX_ROUNDING_RULE%TYPE;

Line 460: l_warehouse_id HZ_CUST_ACCOUNTS.WAREHOUSE_ID%TYPE;

456: l_price_list_id HZ_CUST_ACCOUNTS.PRICE_LIST_ID%TYPE;
457: -- l_ship_partial HZ_CUST_ACCOUNTS.SHIP_PARTIAL%TYPE;
458: l_fob_point HZ_CUST_ACCOUNTS.FOB_POINT%TYPE;
459: l_item_cross_ref_pref HZ_CUST_ACCOUNTS.ITEM_CROSS_REF_PREF%TYPE;
460: l_warehouse_id HZ_CUST_ACCOUNTS.WAREHOUSE_ID%TYPE;
461: l_date_type_preference HZ_CUST_ACCOUNTS.DATE_TYPE_PREFERENCE%TYPE;
462: l_customer_class_code HZ_CUST_ACCOUNTS.CUSTOMER_CLASS_CODE%TYPE;
463: l_tax_rounding_rule HZ_CUST_ACCOUNTS.TAX_ROUNDING_RULE%TYPE;
464: l_account_number HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE;

Line 461: l_date_type_preference HZ_CUST_ACCOUNTS.DATE_TYPE_PREFERENCE%TYPE;

457: -- l_ship_partial HZ_CUST_ACCOUNTS.SHIP_PARTIAL%TYPE;
458: l_fob_point HZ_CUST_ACCOUNTS.FOB_POINT%TYPE;
459: l_item_cross_ref_pref HZ_CUST_ACCOUNTS.ITEM_CROSS_REF_PREF%TYPE;
460: l_warehouse_id HZ_CUST_ACCOUNTS.WAREHOUSE_ID%TYPE;
461: l_date_type_preference HZ_CUST_ACCOUNTS.DATE_TYPE_PREFERENCE%TYPE;
462: l_customer_class_code HZ_CUST_ACCOUNTS.CUSTOMER_CLASS_CODE%TYPE;
463: l_tax_rounding_rule HZ_CUST_ACCOUNTS.TAX_ROUNDING_RULE%TYPE;
464: l_account_number HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE;
465: l_instr_length number := 0;

Line 462: l_customer_class_code HZ_CUST_ACCOUNTS.CUSTOMER_CLASS_CODE%TYPE;

458: l_fob_point HZ_CUST_ACCOUNTS.FOB_POINT%TYPE;
459: l_item_cross_ref_pref HZ_CUST_ACCOUNTS.ITEM_CROSS_REF_PREF%TYPE;
460: l_warehouse_id HZ_CUST_ACCOUNTS.WAREHOUSE_ID%TYPE;
461: l_date_type_preference HZ_CUST_ACCOUNTS.DATE_TYPE_PREFERENCE%TYPE;
462: l_customer_class_code HZ_CUST_ACCOUNTS.CUSTOMER_CLASS_CODE%TYPE;
463: l_tax_rounding_rule HZ_CUST_ACCOUNTS.TAX_ROUNDING_RULE%TYPE;
464: l_account_number HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE;
465: l_instr_length number := 0;
466: l_validate_flag varchar2(1) := 'Y';

Line 463: l_tax_rounding_rule HZ_CUST_ACCOUNTS.TAX_ROUNDING_RULE%TYPE;

459: l_item_cross_ref_pref HZ_CUST_ACCOUNTS.ITEM_CROSS_REF_PREF%TYPE;
460: l_warehouse_id HZ_CUST_ACCOUNTS.WAREHOUSE_ID%TYPE;
461: l_date_type_preference HZ_CUST_ACCOUNTS.DATE_TYPE_PREFERENCE%TYPE;
462: l_customer_class_code HZ_CUST_ACCOUNTS.CUSTOMER_CLASS_CODE%TYPE;
463: l_tax_rounding_rule HZ_CUST_ACCOUNTS.TAX_ROUNDING_RULE%TYPE;
464: l_account_number HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE;
465: l_instr_length number := 0;
466: l_validate_flag varchar2(1) := 'Y';
467: l_mosr_owner_table_id number;

Line 464: l_account_number HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE;

460: l_warehouse_id HZ_CUST_ACCOUNTS.WAREHOUSE_ID%TYPE;
461: l_date_type_preference HZ_CUST_ACCOUNTS.DATE_TYPE_PREFERENCE%TYPE;
462: l_customer_class_code HZ_CUST_ACCOUNTS.CUSTOMER_CLASS_CODE%TYPE;
463: l_tax_rounding_rule HZ_CUST_ACCOUNTS.TAX_ROUNDING_RULE%TYPE;
464: l_account_number HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE;
465: l_instr_length number := 0;
466: l_validate_flag varchar2(1) := 'Y';
467: l_mosr_owner_table_id number;
468:

Line 504: FROM HZ_CUST_ACCOUNTS

500: l_tax_code,l_invoice_quantity_rule,--l_primary_salesrep_id,
501: l_order_type_id,l_price_list_id,l_fob_point,
502: l_item_cross_ref_pref,l_warehouse_id,l_date_type_preference,
503: l_customer_class_code,l_tax_rounding_rule
504: FROM HZ_CUST_ACCOUNTS
505: WHERE ROWID = p_rowid;
506: END IF;
507:
508: --------------------------------------

Line 524: FROM HZ_CUST_ACCOUNTS

520: p_cust_account_rec.cust_account_id <> FND_API.G_MISS_NUM
521: THEN
522: BEGIN
523: SELECT 'Y' INTO l_dummy
524: FROM HZ_CUST_ACCOUNTS
525: WHERE CUST_ACCOUNT_ID = p_cust_account_rec.cust_account_id;
526:
527: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_DUPLICATE_COLUMN' );
528: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'cust_account_id' );

Line 712: FROM HZ_CUST_ACCOUNTS

708: p_cust_account_rec.account_number <> FND_API.G_MISS_CHAR
709: THEN
710: BEGIN
711: SELECT ROWID INTO l_rowid
712: FROM HZ_CUST_ACCOUNTS
713: WHERE ACCOUNT_NUMBER = p_cust_account_rec.account_number;
714:
715: IF p_create_update_flag = 'C' OR
716: ( p_create_update_flag = 'U' AND l_rowid <> p_rowid )

Line 776: FROM HZ_CUST_ACCOUNTS

772: p_cust_account_rec.orig_system_reference <> FND_API.G_MISS_CHAR
773: THEN
774: BEGIN
775: SELECT 'Y' INTO l_dummy
776: FROM HZ_CUST_ACCOUNTS
777: WHERE ORIG_SYSTEM_REFERENCE = p_cust_account_rec.orig_system_reference;
778:
779: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_DUPLICATE_COLUMN' );
780: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'orig_system_reference' );

Line 821: p_owner_table_name => 'HZ_CUST_ACCOUNTS',

817: then
818: hz_orig_system_ref_pub.get_owner_table_id
819: (p_orig_system => p_cust_account_rec.orig_system,
820: p_orig_system_reference => p_cust_account_rec.orig_system_reference,
821: p_owner_table_name => 'HZ_CUST_ACCOUNTS',
822: x_owner_table_id => l_mosr_owner_table_id,
823: x_return_status => l_temp_return_status);
824:
825: IF (l_temp_return_status = fnd_api.g_ret_sts_success AND

Line 1143: FND_MESSAGE.SET_TOKEN('TABLE','HZ_CUST_ACCOUNTS');

1139: p_cust_account_rec.tax_code <> FND_API.G_MISS_CHAR
1140: THEN
1141: FND_MESSAGE.SET_NAME('AR','HZ_API_COLUMN_SHOULD_BE_NULL');
1142: FND_MESSAGE.SET_TOKEN('COLUMN','TAX_CODE');
1143: FND_MESSAGE.SET_TOKEN('TABLE','HZ_CUST_ACCOUNTS');
1144: FND_MSG_PUB.ADD;
1145: x_return_status := FND_API.G_RET_STS_ERROR;
1146: END IF;
1147: */

Line 1185: FND_MESSAGE.SET_TOKEN('TABLE','HZ_CUST_ACCOUNTS');

1181: p_cust_account_rec.order_type_id <> FND_API.G_MISS_NUM
1182: THEN
1183: FND_MESSAGE.SET_NAME('AR','HZ_API_COLUMN_SHOULD_BE_NULL');
1184: FND_MESSAGE.SET_TOKEN('COLUMN','ORDER_TYPE_ID');
1185: FND_MESSAGE.SET_TOKEN('TABLE','HZ_CUST_ACCOUNTS');
1186: FND_MSG_PUB.ADD;
1187: x_return_status := FND_API.G_RET_STS_ERROR;
1188: END IF;
1189:

Line 1241: FND_MESSAGE.SET_TOKEN('TABLE','HZ_CUST_ACCOUNTS');

1237: p_cust_account_rec.primary_salesrep_id <> FND_API.G_MISS_NUM
1238: THEN
1239: FND_MESSAGE.SET_NAME('AR','HZ_API_COLUMN_SHOULD_BE_NULL');
1240: FND_MESSAGE.SET_TOKEN('COLUMN','PRIMARY_SALESREP_ID');
1241: FND_MESSAGE.SET_TOKEN('TABLE','HZ_CUST_ACCOUNTS');
1242: FND_MSG_PUB.ADD;
1243: x_return_status := FND_API.G_RET_STS_ERROR;
1244: END IF;
1245:

Line 2412: -- cust_account_id is foreign key of hz_cust_accounts

2408:
2409: -- since cust account id is part of primary key, we do not need to
2410: -- check non-updateable.
2411:
2412: -- cust_account_id is foreign key of hz_cust_accounts
2413: IF p_create_update_flag = 'C' AND
2414: p_cust_acct_relate_rec.cust_account_id IS NOT NULL AND
2415: p_cust_acct_relate_rec.cust_account_id <> FND_API.G_MISS_NUM
2416: THEN

Line 2423: hz_utility_v2pub.debug(p_message=>'cust_account_id is foreign key of hz_cust_accounts. ' ||

2419: p_column_value => p_cust_acct_relate_rec.cust_account_id,
2420: x_return_status => x_return_status );
2421:
2422: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2423: hz_utility_v2pub.debug(p_message=>'cust_account_id is foreign key of hz_cust_accounts. ' ||
2424: 'x_return_status = ' || x_return_status,
2425: p_prefix=>l_debug_prefix,
2426: p_msg_level=>fnd_log.level_statement);
2427: END IF;

Line 2463: -- related_cust_account_id is foreign key of hz_cust_accounts

2459:
2460: -- since related_cust account id is part of primary key, we do not need to
2461: -- check non-updateable.
2462:
2463: -- related_cust_account_id is foreign key of hz_cust_accounts
2464: IF p_create_update_flag = 'C' AND
2465: p_cust_acct_relate_rec.related_cust_account_id IS NOT NULL AND
2466: p_cust_acct_relate_rec.related_cust_account_id <> FND_API.G_MISS_NUM
2467: THEN

Line 2474: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'related_cust_account_id is foreign key of hz_cust_accounts. ' ||

2470: p_column_value => p_cust_acct_relate_rec.related_cust_account_id,
2471: x_return_status => x_return_status );
2472:
2473: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2474: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'related_cust_account_id is foreign key of hz_cust_accounts. ' ||
2475: 'x_return_status = ' || x_return_status,
2476: p_msg_level=>fnd_log.level_statement);
2477: END IF;
2478:

Line 3008: -- cust_account_id is foreign key to hz_cust_accounts

3004:
3005: END IF;
3006:
3007:
3008: -- cust_account_id is foreign key to hz_cust_accounts
3009: -- Since cust_acocunt_id is non-updateable, we only need to
3010: -- check FK during creation.
3011:
3012: IF p_create_update_flag = 'C' AND

Line 3023: hz_utility_v2pub.debug(p_message=>'cust_account_id is foreign key to hz_cust_accounts. ' ||

3019: x_return_status => x_return_status );
3020:
3021:
3022: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3023: hz_utility_v2pub.debug(p_message=>'cust_account_id is foreign key to hz_cust_accounts. ' ||
3024: 'x_return_status = ' || x_return_status,
3025: p_prefix =>l_debug_prefix,
3026: p_msg_level=>fnd_log.level_statement);
3027: END IF;

Line 5799: -- cust_account_id is foreign key to hz_cust_accounts

5795: p_msg_level=>fnd_log.level_statement);
5796: END IF;
5797: END IF;
5798:
5799: -- cust_account_id is foreign key to hz_cust_accounts
5800: -- Since cust_account_id is mandatory and non-updateable,
5801: -- we only need to check FK during creation.
5802:
5803: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 5821: hz_utility_v2pub.debug(p_message=>'cust_account_id is foreign key to hz_cust_accounts. ' ||

5817: p_column_value => p_cust_profile_amt_rec.cust_account_id,
5818: x_return_status => x_return_status );
5819:
5820: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5821: hz_utility_v2pub.debug(p_message=>'cust_account_id is foreign key to hz_cust_accounts. ' ||
5822: 'x_return_status = ' || x_return_status,
5823: p_prefix =>l_debug_prefix,
5824: p_msg_level=>fnd_log.level_statement);
5825: END IF;

Line 6722: l_orig_system_reference1 HZ_CUST_ACCOUNTS.orig_system_reference%TYPE;

6718:
6719: l_cust_account_id NUMBER;
6720: l_party_site_id NUMBER;
6721: l_orig_system_reference HZ_CUST_ACCT_SITES.orig_system_reference%TYPE;
6722: l_orig_system_reference1 HZ_CUST_ACCOUNTS.orig_system_reference%TYPE;
6723: l_created_by_module HZ_CUST_ACCT_SITES.created_by_module%TYPE;
6724: l_application_id NUMBER;
6725: l_status HZ_CUST_ACCT_SITES.status%TYPE;
6726: l_customer_category_code HZ_CUST_ACCT_SITES.customer_category_code%TYPE;

Line 6852: -- cust_account_id is foreign key of hz_cust_accounts

6848: p_msg_level=>fnd_log.level_statement);
6849: END IF;
6850: END IF;
6851:
6852: -- cust_account_id is foreign key of hz_cust_accounts
6853: -- Do not need to check during update because cust_account_id is
6854: -- non-updateable.
6855: IF p_create_update_flag = 'C' THEN
6856: IF p_cust_acct_site_rec.cust_account_id <> -1 AND

Line 6868: hz_utility_v2pub.debug(p_message=>'cust_account_id is foreign key of hz_cust_accounts. ' ||

6864:
6865: -- Debug info.
6866:
6867: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6868: hz_utility_v2pub.debug(p_message=>'cust_account_id is foreign key of hz_cust_accounts. ' ||
6869: 'x_return_status = ' || x_return_status,
6870: p_prefix =>l_debug_prefix,
6871: p_msg_level=>fnd_log.level_statement);
6872: END IF;

Line 9685: -- cust_account_id is foreign key to hz_cust_accounts

9681: END IF;
9682:
9683: END IF;
9684:
9685: -- cust_account_id is foreign key to hz_cust_accounts
9686: -- Since cust_account_id is mandatory and non-updateable,
9687: -- we only need to check FK during creation.
9688:
9689: IF p_create_update_flag = 'C' AND

Line 9699: hz_utility_v2pub.debug(p_message=>'cust_account_id is foreign key to hz_cust_accounts. ' ||

9695: p_column_value => p_cust_account_role_rec.cust_account_id,
9696: x_return_status => x_return_status );
9697:
9698: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
9699: hz_utility_v2pub.debug(p_message=>'cust_account_id is foreign key to hz_cust_accounts. ' ||
9700: 'x_return_status = ' || x_return_status,
9701: p_prefix =>l_debug_prefix,
9702: p_msg_level=>fnd_log.level_statement);
9703: END IF;

Line 10679: FROM HZ_CUST_ACCOUNTS

10675:
10676: IF p_column_value <> -1 THEN
10677:
10678: SELECT 'Y' INTO l_dummy
10679: FROM HZ_CUST_ACCOUNTS
10680: WHERE CUST_ACCOUNT_ID = p_column_value;
10681:
10682: END IF;
10683:

Line 10689: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_accounts' );

10685: WHEN NO_DATA_FOUND THEN
10686: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
10687: FND_MESSAGE.SET_TOKEN( 'FK', 'cust_account_id' );
10688: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
10689: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_accounts' );
10690: FND_MSG_PUB.ADD;
10691: x_return_status := FND_API.G_RET_STS_ERROR;
10692:
10693: END check_cust_account_fk;

Line 10964: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_accounts' );

10960:
10961: IF l_org_id IS NOT NULL THEN
10962: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_COLUMN_SHOULD_BE_NULL' );
10963: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
10964: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_accounts' );
10965: FND_MSG_PUB.ADD;
10966: x_return_status := FND_API.G_RET_STS_ERROR;
10967:
10968: RETURN;