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 451: l_orig_system_reference HZ_CUST_ACCOUNTS.orig_system_reference%TYPE;

447: -- Bug 3456489
448: -- l_profile AR_SYSTEM_PARAMETERS.generate_customer_number%TYPE;
449: l_profile VARCHAR2(1);
450:
451: l_orig_system_reference HZ_CUST_ACCOUNTS.orig_system_reference%TYPE;
452: l_orig_system_reference1 HZ_CUST_ACCOUNTS.orig_system_reference%TYPE;
453: l_account_established_date HZ_CUST_ACCOUNTS.account_established_date%TYPE;
454: -- l_account_termination_date HZ_CUST_ACCOUNTS.account_termination_date%TYPE;
455: -- l_account_activation_date HZ_CUST_ACCOUNTS.account_activation_date%TYPE;

Line 452: l_orig_system_reference1 HZ_CUST_ACCOUNTS.orig_system_reference%TYPE;

448: -- l_profile AR_SYSTEM_PARAMETERS.generate_customer_number%TYPE;
449: l_profile VARCHAR2(1);
450:
451: l_orig_system_reference HZ_CUST_ACCOUNTS.orig_system_reference%TYPE;
452: l_orig_system_reference1 HZ_CUST_ACCOUNTS.orig_system_reference%TYPE;
453: l_account_established_date HZ_CUST_ACCOUNTS.account_established_date%TYPE;
454: -- l_account_termination_date HZ_CUST_ACCOUNTS.account_termination_date%TYPE;
455: -- l_account_activation_date HZ_CUST_ACCOUNTS.account_activation_date%TYPE;
456: l_created_by_module HZ_CUST_ACCOUNTS.created_by_module%TYPE;

Line 453: l_account_established_date HZ_CUST_ACCOUNTS.account_established_date%TYPE;

449: l_profile VARCHAR2(1);
450:
451: l_orig_system_reference HZ_CUST_ACCOUNTS.orig_system_reference%TYPE;
452: l_orig_system_reference1 HZ_CUST_ACCOUNTS.orig_system_reference%TYPE;
453: l_account_established_date HZ_CUST_ACCOUNTS.account_established_date%TYPE;
454: -- l_account_termination_date HZ_CUST_ACCOUNTS.account_termination_date%TYPE;
455: -- l_account_activation_date HZ_CUST_ACCOUNTS.account_activation_date%TYPE;
456: l_created_by_module HZ_CUST_ACCOUNTS.created_by_module%TYPE;
457: l_application_id NUMBER;

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

450:
451: l_orig_system_reference HZ_CUST_ACCOUNTS.orig_system_reference%TYPE;
452: l_orig_system_reference1 HZ_CUST_ACCOUNTS.orig_system_reference%TYPE;
453: l_account_established_date HZ_CUST_ACCOUNTS.account_established_date%TYPE;
454: -- l_account_termination_date HZ_CUST_ACCOUNTS.account_termination_date%TYPE;
455: -- l_account_activation_date HZ_CUST_ACCOUNTS.account_activation_date%TYPE;
456: l_created_by_module HZ_CUST_ACCOUNTS.created_by_module%TYPE;
457: l_application_id NUMBER;
458: l_status HZ_CUST_ACCOUNTS.status%TYPE;

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

451: l_orig_system_reference HZ_CUST_ACCOUNTS.orig_system_reference%TYPE;
452: l_orig_system_reference1 HZ_CUST_ACCOUNTS.orig_system_reference%TYPE;
453: l_account_established_date HZ_CUST_ACCOUNTS.account_established_date%TYPE;
454: -- l_account_termination_date HZ_CUST_ACCOUNTS.account_termination_date%TYPE;
455: -- l_account_activation_date HZ_CUST_ACCOUNTS.account_activation_date%TYPE;
456: l_created_by_module HZ_CUST_ACCOUNTS.created_by_module%TYPE;
457: l_application_id NUMBER;
458: l_status HZ_CUST_ACCOUNTS.status%TYPE;
459: l_customer_type HZ_CUST_ACCOUNTS.customer_type%TYPE;

Line 456: l_created_by_module HZ_CUST_ACCOUNTS.created_by_module%TYPE;

452: l_orig_system_reference1 HZ_CUST_ACCOUNTS.orig_system_reference%TYPE;
453: l_account_established_date HZ_CUST_ACCOUNTS.account_established_date%TYPE;
454: -- l_account_termination_date HZ_CUST_ACCOUNTS.account_termination_date%TYPE;
455: -- l_account_activation_date HZ_CUST_ACCOUNTS.account_activation_date%TYPE;
456: l_created_by_module HZ_CUST_ACCOUNTS.created_by_module%TYPE;
457: l_application_id NUMBER;
458: l_status HZ_CUST_ACCOUNTS.status%TYPE;
459: l_customer_type HZ_CUST_ACCOUNTS.customer_type%TYPE;
460: l_sales_channel_code HZ_CUST_ACCOUNTS.sales_channel_code%TYPE;

Line 458: l_status HZ_CUST_ACCOUNTS.status%TYPE;

454: -- l_account_termination_date HZ_CUST_ACCOUNTS.account_termination_date%TYPE;
455: -- l_account_activation_date HZ_CUST_ACCOUNTS.account_activation_date%TYPE;
456: l_created_by_module HZ_CUST_ACCOUNTS.created_by_module%TYPE;
457: l_application_id NUMBER;
458: l_status HZ_CUST_ACCOUNTS.status%TYPE;
459: l_customer_type HZ_CUST_ACCOUNTS.customer_type%TYPE;
460: l_sales_channel_code HZ_CUST_ACCOUNTS.sales_channel_code%TYPE;
461: l_freight_term HZ_CUST_ACCOUNTS.freight_term%TYPE;
462: l_ship_via HZ_CUST_ACCOUNTS.ship_via%TYPE;

Line 459: l_customer_type HZ_CUST_ACCOUNTS.customer_type%TYPE;

455: -- l_account_activation_date HZ_CUST_ACCOUNTS.account_activation_date%TYPE;
456: l_created_by_module HZ_CUST_ACCOUNTS.created_by_module%TYPE;
457: l_application_id NUMBER;
458: l_status HZ_CUST_ACCOUNTS.status%TYPE;
459: l_customer_type HZ_CUST_ACCOUNTS.customer_type%TYPE;
460: l_sales_channel_code HZ_CUST_ACCOUNTS.sales_channel_code%TYPE;
461: l_freight_term HZ_CUST_ACCOUNTS.freight_term%TYPE;
462: l_ship_via HZ_CUST_ACCOUNTS.ship_via%TYPE;
463: l_ship_sets_inc_lines_f HZ_CUST_ACCOUNTS.ship_sets_include_lines_flag%TYPE;

Line 460: l_sales_channel_code HZ_CUST_ACCOUNTS.sales_channel_code%TYPE;

456: l_created_by_module HZ_CUST_ACCOUNTS.created_by_module%TYPE;
457: l_application_id NUMBER;
458: l_status HZ_CUST_ACCOUNTS.status%TYPE;
459: l_customer_type HZ_CUST_ACCOUNTS.customer_type%TYPE;
460: l_sales_channel_code HZ_CUST_ACCOUNTS.sales_channel_code%TYPE;
461: l_freight_term HZ_CUST_ACCOUNTS.freight_term%TYPE;
462: l_ship_via HZ_CUST_ACCOUNTS.ship_via%TYPE;
463: l_ship_sets_inc_lines_f HZ_CUST_ACCOUNTS.ship_sets_include_lines_flag%TYPE;
464: l_arrivalsets_inc_lines_f HZ_CUST_ACCOUNTS.arrivalsets_include_lines_flag%TYPE;

Line 461: l_freight_term HZ_CUST_ACCOUNTS.freight_term%TYPE;

457: l_application_id NUMBER;
458: l_status HZ_CUST_ACCOUNTS.status%TYPE;
459: l_customer_type HZ_CUST_ACCOUNTS.customer_type%TYPE;
460: l_sales_channel_code HZ_CUST_ACCOUNTS.sales_channel_code%TYPE;
461: l_freight_term HZ_CUST_ACCOUNTS.freight_term%TYPE;
462: l_ship_via HZ_CUST_ACCOUNTS.ship_via%TYPE;
463: l_ship_sets_inc_lines_f HZ_CUST_ACCOUNTS.ship_sets_include_lines_flag%TYPE;
464: l_arrivalsets_inc_lines_f HZ_CUST_ACCOUNTS.arrivalsets_include_lines_flag%TYPE;
465: l_tax_code HZ_CUST_ACCOUNTS.TAX_CODE%TYPE;

Line 462: l_ship_via HZ_CUST_ACCOUNTS.ship_via%TYPE;

458: l_status HZ_CUST_ACCOUNTS.status%TYPE;
459: l_customer_type HZ_CUST_ACCOUNTS.customer_type%TYPE;
460: l_sales_channel_code HZ_CUST_ACCOUNTS.sales_channel_code%TYPE;
461: l_freight_term HZ_CUST_ACCOUNTS.freight_term%TYPE;
462: l_ship_via HZ_CUST_ACCOUNTS.ship_via%TYPE;
463: l_ship_sets_inc_lines_f HZ_CUST_ACCOUNTS.ship_sets_include_lines_flag%TYPE;
464: l_arrivalsets_inc_lines_f HZ_CUST_ACCOUNTS.arrivalsets_include_lines_flag%TYPE;
465: l_tax_code HZ_CUST_ACCOUNTS.TAX_CODE%TYPE;
466: l_invoice_quantity_rule HZ_CUST_ACCOUNTS.INVOICE_QUANTITY_RULE%TYPE;

Line 463: l_ship_sets_inc_lines_f HZ_CUST_ACCOUNTS.ship_sets_include_lines_flag%TYPE;

459: l_customer_type HZ_CUST_ACCOUNTS.customer_type%TYPE;
460: l_sales_channel_code HZ_CUST_ACCOUNTS.sales_channel_code%TYPE;
461: l_freight_term HZ_CUST_ACCOUNTS.freight_term%TYPE;
462: l_ship_via HZ_CUST_ACCOUNTS.ship_via%TYPE;
463: l_ship_sets_inc_lines_f HZ_CUST_ACCOUNTS.ship_sets_include_lines_flag%TYPE;
464: l_arrivalsets_inc_lines_f HZ_CUST_ACCOUNTS.arrivalsets_include_lines_flag%TYPE;
465: l_tax_code HZ_CUST_ACCOUNTS.TAX_CODE%TYPE;
466: l_invoice_quantity_rule HZ_CUST_ACCOUNTS.INVOICE_QUANTITY_RULE%TYPE;
467: -- l_primary_salesrep_id HZ_CUST_ACCOUNTS.PRIMARY_SALESREP_ID%TYPE;

Line 464: l_arrivalsets_inc_lines_f HZ_CUST_ACCOUNTS.arrivalsets_include_lines_flag%TYPE;

460: l_sales_channel_code HZ_CUST_ACCOUNTS.sales_channel_code%TYPE;
461: l_freight_term HZ_CUST_ACCOUNTS.freight_term%TYPE;
462: l_ship_via HZ_CUST_ACCOUNTS.ship_via%TYPE;
463: l_ship_sets_inc_lines_f HZ_CUST_ACCOUNTS.ship_sets_include_lines_flag%TYPE;
464: l_arrivalsets_inc_lines_f HZ_CUST_ACCOUNTS.arrivalsets_include_lines_flag%TYPE;
465: l_tax_code HZ_CUST_ACCOUNTS.TAX_CODE%TYPE;
466: l_invoice_quantity_rule HZ_CUST_ACCOUNTS.INVOICE_QUANTITY_RULE%TYPE;
467: -- l_primary_salesrep_id HZ_CUST_ACCOUNTS.PRIMARY_SALESREP_ID%TYPE;
468: l_order_type_id HZ_CUST_ACCOUNTS.ORDER_TYPE_ID%TYPE;

Line 465: l_tax_code HZ_CUST_ACCOUNTS.TAX_CODE%TYPE;

461: l_freight_term HZ_CUST_ACCOUNTS.freight_term%TYPE;
462: l_ship_via HZ_CUST_ACCOUNTS.ship_via%TYPE;
463: l_ship_sets_inc_lines_f HZ_CUST_ACCOUNTS.ship_sets_include_lines_flag%TYPE;
464: l_arrivalsets_inc_lines_f HZ_CUST_ACCOUNTS.arrivalsets_include_lines_flag%TYPE;
465: l_tax_code HZ_CUST_ACCOUNTS.TAX_CODE%TYPE;
466: l_invoice_quantity_rule HZ_CUST_ACCOUNTS.INVOICE_QUANTITY_RULE%TYPE;
467: -- l_primary_salesrep_id HZ_CUST_ACCOUNTS.PRIMARY_SALESREP_ID%TYPE;
468: l_order_type_id HZ_CUST_ACCOUNTS.ORDER_TYPE_ID%TYPE;
469: l_price_list_id HZ_CUST_ACCOUNTS.PRICE_LIST_ID%TYPE;

Line 466: l_invoice_quantity_rule HZ_CUST_ACCOUNTS.INVOICE_QUANTITY_RULE%TYPE;

462: l_ship_via HZ_CUST_ACCOUNTS.ship_via%TYPE;
463: l_ship_sets_inc_lines_f HZ_CUST_ACCOUNTS.ship_sets_include_lines_flag%TYPE;
464: l_arrivalsets_inc_lines_f HZ_CUST_ACCOUNTS.arrivalsets_include_lines_flag%TYPE;
465: l_tax_code HZ_CUST_ACCOUNTS.TAX_CODE%TYPE;
466: l_invoice_quantity_rule HZ_CUST_ACCOUNTS.INVOICE_QUANTITY_RULE%TYPE;
467: -- l_primary_salesrep_id HZ_CUST_ACCOUNTS.PRIMARY_SALESREP_ID%TYPE;
468: l_order_type_id HZ_CUST_ACCOUNTS.ORDER_TYPE_ID%TYPE;
469: l_price_list_id HZ_CUST_ACCOUNTS.PRICE_LIST_ID%TYPE;
470: -- l_ship_partial HZ_CUST_ACCOUNTS.SHIP_PARTIAL%TYPE;

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

463: l_ship_sets_inc_lines_f HZ_CUST_ACCOUNTS.ship_sets_include_lines_flag%TYPE;
464: l_arrivalsets_inc_lines_f HZ_CUST_ACCOUNTS.arrivalsets_include_lines_flag%TYPE;
465: l_tax_code HZ_CUST_ACCOUNTS.TAX_CODE%TYPE;
466: l_invoice_quantity_rule HZ_CUST_ACCOUNTS.INVOICE_QUANTITY_RULE%TYPE;
467: -- l_primary_salesrep_id HZ_CUST_ACCOUNTS.PRIMARY_SALESREP_ID%TYPE;
468: l_order_type_id HZ_CUST_ACCOUNTS.ORDER_TYPE_ID%TYPE;
469: l_price_list_id HZ_CUST_ACCOUNTS.PRICE_LIST_ID%TYPE;
470: -- l_ship_partial HZ_CUST_ACCOUNTS.SHIP_PARTIAL%TYPE;
471: l_fob_point HZ_CUST_ACCOUNTS.FOB_POINT%TYPE;

Line 468: l_order_type_id HZ_CUST_ACCOUNTS.ORDER_TYPE_ID%TYPE;

464: l_arrivalsets_inc_lines_f HZ_CUST_ACCOUNTS.arrivalsets_include_lines_flag%TYPE;
465: l_tax_code HZ_CUST_ACCOUNTS.TAX_CODE%TYPE;
466: l_invoice_quantity_rule HZ_CUST_ACCOUNTS.INVOICE_QUANTITY_RULE%TYPE;
467: -- l_primary_salesrep_id HZ_CUST_ACCOUNTS.PRIMARY_SALESREP_ID%TYPE;
468: l_order_type_id HZ_CUST_ACCOUNTS.ORDER_TYPE_ID%TYPE;
469: l_price_list_id HZ_CUST_ACCOUNTS.PRICE_LIST_ID%TYPE;
470: -- l_ship_partial HZ_CUST_ACCOUNTS.SHIP_PARTIAL%TYPE;
471: l_fob_point HZ_CUST_ACCOUNTS.FOB_POINT%TYPE;
472: l_item_cross_ref_pref HZ_CUST_ACCOUNTS.ITEM_CROSS_REF_PREF%TYPE;

Line 469: l_price_list_id HZ_CUST_ACCOUNTS.PRICE_LIST_ID%TYPE;

465: l_tax_code HZ_CUST_ACCOUNTS.TAX_CODE%TYPE;
466: l_invoice_quantity_rule HZ_CUST_ACCOUNTS.INVOICE_QUANTITY_RULE%TYPE;
467: -- l_primary_salesrep_id HZ_CUST_ACCOUNTS.PRIMARY_SALESREP_ID%TYPE;
468: l_order_type_id HZ_CUST_ACCOUNTS.ORDER_TYPE_ID%TYPE;
469: l_price_list_id HZ_CUST_ACCOUNTS.PRICE_LIST_ID%TYPE;
470: -- l_ship_partial HZ_CUST_ACCOUNTS.SHIP_PARTIAL%TYPE;
471: l_fob_point HZ_CUST_ACCOUNTS.FOB_POINT%TYPE;
472: l_item_cross_ref_pref HZ_CUST_ACCOUNTS.ITEM_CROSS_REF_PREF%TYPE;
473: l_warehouse_id HZ_CUST_ACCOUNTS.WAREHOUSE_ID%TYPE;

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

466: l_invoice_quantity_rule HZ_CUST_ACCOUNTS.INVOICE_QUANTITY_RULE%TYPE;
467: -- l_primary_salesrep_id HZ_CUST_ACCOUNTS.PRIMARY_SALESREP_ID%TYPE;
468: l_order_type_id HZ_CUST_ACCOUNTS.ORDER_TYPE_ID%TYPE;
469: l_price_list_id HZ_CUST_ACCOUNTS.PRICE_LIST_ID%TYPE;
470: -- l_ship_partial HZ_CUST_ACCOUNTS.SHIP_PARTIAL%TYPE;
471: l_fob_point HZ_CUST_ACCOUNTS.FOB_POINT%TYPE;
472: l_item_cross_ref_pref HZ_CUST_ACCOUNTS.ITEM_CROSS_REF_PREF%TYPE;
473: l_warehouse_id HZ_CUST_ACCOUNTS.WAREHOUSE_ID%TYPE;
474: l_date_type_preference HZ_CUST_ACCOUNTS.DATE_TYPE_PREFERENCE%TYPE;

Line 471: l_fob_point HZ_CUST_ACCOUNTS.FOB_POINT%TYPE;

467: -- l_primary_salesrep_id HZ_CUST_ACCOUNTS.PRIMARY_SALESREP_ID%TYPE;
468: l_order_type_id HZ_CUST_ACCOUNTS.ORDER_TYPE_ID%TYPE;
469: l_price_list_id HZ_CUST_ACCOUNTS.PRICE_LIST_ID%TYPE;
470: -- l_ship_partial HZ_CUST_ACCOUNTS.SHIP_PARTIAL%TYPE;
471: l_fob_point HZ_CUST_ACCOUNTS.FOB_POINT%TYPE;
472: l_item_cross_ref_pref HZ_CUST_ACCOUNTS.ITEM_CROSS_REF_PREF%TYPE;
473: l_warehouse_id HZ_CUST_ACCOUNTS.WAREHOUSE_ID%TYPE;
474: l_date_type_preference HZ_CUST_ACCOUNTS.DATE_TYPE_PREFERENCE%TYPE;
475: l_customer_class_code HZ_CUST_ACCOUNTS.CUSTOMER_CLASS_CODE%TYPE;

Line 472: l_item_cross_ref_pref HZ_CUST_ACCOUNTS.ITEM_CROSS_REF_PREF%TYPE;

468: l_order_type_id HZ_CUST_ACCOUNTS.ORDER_TYPE_ID%TYPE;
469: l_price_list_id HZ_CUST_ACCOUNTS.PRICE_LIST_ID%TYPE;
470: -- l_ship_partial HZ_CUST_ACCOUNTS.SHIP_PARTIAL%TYPE;
471: l_fob_point HZ_CUST_ACCOUNTS.FOB_POINT%TYPE;
472: l_item_cross_ref_pref HZ_CUST_ACCOUNTS.ITEM_CROSS_REF_PREF%TYPE;
473: l_warehouse_id HZ_CUST_ACCOUNTS.WAREHOUSE_ID%TYPE;
474: l_date_type_preference HZ_CUST_ACCOUNTS.DATE_TYPE_PREFERENCE%TYPE;
475: l_customer_class_code HZ_CUST_ACCOUNTS.CUSTOMER_CLASS_CODE%TYPE;
476: l_tax_rounding_rule HZ_CUST_ACCOUNTS.TAX_ROUNDING_RULE%TYPE;

Line 473: l_warehouse_id HZ_CUST_ACCOUNTS.WAREHOUSE_ID%TYPE;

469: l_price_list_id HZ_CUST_ACCOUNTS.PRICE_LIST_ID%TYPE;
470: -- l_ship_partial HZ_CUST_ACCOUNTS.SHIP_PARTIAL%TYPE;
471: l_fob_point HZ_CUST_ACCOUNTS.FOB_POINT%TYPE;
472: l_item_cross_ref_pref HZ_CUST_ACCOUNTS.ITEM_CROSS_REF_PREF%TYPE;
473: l_warehouse_id HZ_CUST_ACCOUNTS.WAREHOUSE_ID%TYPE;
474: l_date_type_preference HZ_CUST_ACCOUNTS.DATE_TYPE_PREFERENCE%TYPE;
475: l_customer_class_code HZ_CUST_ACCOUNTS.CUSTOMER_CLASS_CODE%TYPE;
476: l_tax_rounding_rule HZ_CUST_ACCOUNTS.TAX_ROUNDING_RULE%TYPE;
477: l_account_number HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE;

Line 474: l_date_type_preference HZ_CUST_ACCOUNTS.DATE_TYPE_PREFERENCE%TYPE;

470: -- l_ship_partial HZ_CUST_ACCOUNTS.SHIP_PARTIAL%TYPE;
471: l_fob_point HZ_CUST_ACCOUNTS.FOB_POINT%TYPE;
472: l_item_cross_ref_pref HZ_CUST_ACCOUNTS.ITEM_CROSS_REF_PREF%TYPE;
473: l_warehouse_id HZ_CUST_ACCOUNTS.WAREHOUSE_ID%TYPE;
474: l_date_type_preference HZ_CUST_ACCOUNTS.DATE_TYPE_PREFERENCE%TYPE;
475: l_customer_class_code HZ_CUST_ACCOUNTS.CUSTOMER_CLASS_CODE%TYPE;
476: l_tax_rounding_rule HZ_CUST_ACCOUNTS.TAX_ROUNDING_RULE%TYPE;
477: l_account_number HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE;
478: l_instr_length number := 0;

Line 475: l_customer_class_code HZ_CUST_ACCOUNTS.CUSTOMER_CLASS_CODE%TYPE;

471: l_fob_point HZ_CUST_ACCOUNTS.FOB_POINT%TYPE;
472: l_item_cross_ref_pref HZ_CUST_ACCOUNTS.ITEM_CROSS_REF_PREF%TYPE;
473: l_warehouse_id HZ_CUST_ACCOUNTS.WAREHOUSE_ID%TYPE;
474: l_date_type_preference HZ_CUST_ACCOUNTS.DATE_TYPE_PREFERENCE%TYPE;
475: l_customer_class_code HZ_CUST_ACCOUNTS.CUSTOMER_CLASS_CODE%TYPE;
476: l_tax_rounding_rule HZ_CUST_ACCOUNTS.TAX_ROUNDING_RULE%TYPE;
477: l_account_number HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE;
478: l_instr_length number := 0;
479: l_validate_flag varchar2(1) := 'Y';

Line 476: l_tax_rounding_rule HZ_CUST_ACCOUNTS.TAX_ROUNDING_RULE%TYPE;

472: l_item_cross_ref_pref HZ_CUST_ACCOUNTS.ITEM_CROSS_REF_PREF%TYPE;
473: l_warehouse_id HZ_CUST_ACCOUNTS.WAREHOUSE_ID%TYPE;
474: l_date_type_preference HZ_CUST_ACCOUNTS.DATE_TYPE_PREFERENCE%TYPE;
475: l_customer_class_code HZ_CUST_ACCOUNTS.CUSTOMER_CLASS_CODE%TYPE;
476: l_tax_rounding_rule HZ_CUST_ACCOUNTS.TAX_ROUNDING_RULE%TYPE;
477: l_account_number HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE;
478: l_instr_length number := 0;
479: l_validate_flag varchar2(1) := 'Y';
480: l_mosr_owner_table_id number;

Line 477: l_account_number HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE;

473: l_warehouse_id HZ_CUST_ACCOUNTS.WAREHOUSE_ID%TYPE;
474: l_date_type_preference HZ_CUST_ACCOUNTS.DATE_TYPE_PREFERENCE%TYPE;
475: l_customer_class_code HZ_CUST_ACCOUNTS.CUSTOMER_CLASS_CODE%TYPE;
476: l_tax_rounding_rule HZ_CUST_ACCOUNTS.TAX_ROUNDING_RULE%TYPE;
477: l_account_number HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE;
478: l_instr_length number := 0;
479: l_validate_flag varchar2(1) := 'Y';
480: l_mosr_owner_table_id number;
481:

Line 517: FROM HZ_CUST_ACCOUNTS

513: l_tax_code,l_invoice_quantity_rule,--l_primary_salesrep_id,
514: l_order_type_id,l_price_list_id,l_fob_point,
515: l_item_cross_ref_pref,l_warehouse_id,l_date_type_preference,
516: l_customer_class_code,l_tax_rounding_rule
517: FROM HZ_CUST_ACCOUNTS
518: WHERE ROWID = p_rowid;
519: END IF;
520:
521: --------------------------------------

Line 537: FROM HZ_CUST_ACCOUNTS

533: p_cust_account_rec.cust_account_id <> FND_API.G_MISS_NUM
534: THEN
535: BEGIN
536: SELECT 'Y' INTO l_dummy
537: FROM HZ_CUST_ACCOUNTS
538: WHERE CUST_ACCOUNT_ID = p_cust_account_rec.cust_account_id;
539:
540: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_DUPLICATE_COLUMN' );
541: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'cust_account_id' );

Line 725: FROM HZ_CUST_ACCOUNTS

721: p_cust_account_rec.account_number <> FND_API.G_MISS_CHAR
722: THEN
723: BEGIN
724: SELECT ROWID INTO l_rowid
725: FROM HZ_CUST_ACCOUNTS
726: WHERE ACCOUNT_NUMBER = p_cust_account_rec.account_number;
727:
728: IF p_create_update_flag = 'C' OR
729: ( p_create_update_flag = 'U' AND l_rowid <> p_rowid )

Line 789: FROM HZ_CUST_ACCOUNTS

785: p_cust_account_rec.orig_system_reference <> FND_API.G_MISS_CHAR
786: THEN
787: BEGIN
788: SELECT 'Y' INTO l_dummy
789: FROM HZ_CUST_ACCOUNTS
790: WHERE ORIG_SYSTEM_REFERENCE = p_cust_account_rec.orig_system_reference;
791:
792: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_DUPLICATE_COLUMN' );
793: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'orig_system_reference' );

Line 834: p_owner_table_name => 'HZ_CUST_ACCOUNTS',

830: then
831: hz_orig_system_ref_pub.get_owner_table_id
832: (p_orig_system => p_cust_account_rec.orig_system,
833: p_orig_system_reference => p_cust_account_rec.orig_system_reference,
834: p_owner_table_name => 'HZ_CUST_ACCOUNTS',
835: x_owner_table_id => l_mosr_owner_table_id,
836: x_return_status => l_temp_return_status);
837:
838: IF (l_temp_return_status = fnd_api.g_ret_sts_success AND

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

1152: p_cust_account_rec.tax_code <> FND_API.G_MISS_CHAR
1153: THEN
1154: FND_MESSAGE.SET_NAME('AR','HZ_API_COLUMN_SHOULD_BE_NULL');
1155: FND_MESSAGE.SET_TOKEN('COLUMN','TAX_CODE');
1156: FND_MESSAGE.SET_TOKEN('TABLE','HZ_CUST_ACCOUNTS');
1157: FND_MSG_PUB.ADD;
1158: x_return_status := FND_API.G_RET_STS_ERROR;
1159: END IF;
1160: */

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

1194: p_cust_account_rec.order_type_id <> FND_API.G_MISS_NUM
1195: THEN
1196: FND_MESSAGE.SET_NAME('AR','HZ_API_COLUMN_SHOULD_BE_NULL');
1197: FND_MESSAGE.SET_TOKEN('COLUMN','ORDER_TYPE_ID');
1198: FND_MESSAGE.SET_TOKEN('TABLE','HZ_CUST_ACCOUNTS');
1199: FND_MSG_PUB.ADD;
1200: x_return_status := FND_API.G_RET_STS_ERROR;
1201: END IF;
1202:

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

1250: p_cust_account_rec.primary_salesrep_id <> FND_API.G_MISS_NUM
1251: THEN
1252: FND_MESSAGE.SET_NAME('AR','HZ_API_COLUMN_SHOULD_BE_NULL');
1253: FND_MESSAGE.SET_TOKEN('COLUMN','PRIMARY_SALESREP_ID');
1254: FND_MESSAGE.SET_TOKEN('TABLE','HZ_CUST_ACCOUNTS');
1255: FND_MSG_PUB.ADD;
1256: x_return_status := FND_API.G_RET_STS_ERROR;
1257: END IF;
1258:

Line 2438: -- cust_account_id is foreign key of hz_cust_accounts

2434:
2435: -- since cust account id is part of primary key, we do not need to
2436: -- check non-updateable.
2437:
2438: -- cust_account_id is foreign key of hz_cust_accounts
2439: IF p_create_update_flag = 'C' AND
2440: p_cust_acct_relate_rec.cust_account_id IS NOT NULL AND
2441: p_cust_acct_relate_rec.cust_account_id <> FND_API.G_MISS_NUM
2442: THEN

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

2445: p_column_value => p_cust_acct_relate_rec.cust_account_id,
2446: x_return_status => x_return_status );
2447:
2448: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2449: hz_utility_v2pub.debug(p_message=>'cust_account_id is foreign key of hz_cust_accounts. ' ||
2450: 'x_return_status = ' || x_return_status,
2451: p_prefix=>l_debug_prefix,
2452: p_msg_level=>fnd_log.level_statement);
2453: END IF;

Line 2489: -- related_cust_account_id is foreign key of hz_cust_accounts

2485:
2486: -- since related_cust account id is part of primary key, we do not need to
2487: -- check non-updateable.
2488:
2489: -- related_cust_account_id is foreign key of hz_cust_accounts
2490: IF p_create_update_flag = 'C' AND
2491: p_cust_acct_relate_rec.related_cust_account_id IS NOT NULL AND
2492: p_cust_acct_relate_rec.related_cust_account_id <> FND_API.G_MISS_NUM
2493: THEN

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

2496: p_column_value => p_cust_acct_relate_rec.related_cust_account_id,
2497: x_return_status => x_return_status );
2498:
2499: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2500: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'related_cust_account_id is foreign key of hz_cust_accounts. ' ||
2501: 'x_return_status = ' || x_return_status,
2502: p_msg_level=>fnd_log.level_statement);
2503: END IF;
2504:

Line 3035: -- cust_account_id is foreign key to hz_cust_accounts

3031:
3032: END IF;
3033:
3034:
3035: -- cust_account_id is foreign key to hz_cust_accounts
3036: -- Since cust_acocunt_id is non-updateable, we only need to
3037: -- check FK during creation.
3038:
3039: IF p_create_update_flag = 'C' AND

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

3046: x_return_status => x_return_status );
3047:
3048:
3049: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3050: hz_utility_v2pub.debug(p_message=>'cust_account_id is foreign key to hz_cust_accounts. ' ||
3051: 'x_return_status = ' || x_return_status,
3052: p_prefix =>l_debug_prefix,
3053: p_msg_level=>fnd_log.level_statement);
3054: END IF;

Line 5856: -- cust_account_id is foreign key to hz_cust_accounts

5852: p_msg_level=>fnd_log.level_statement);
5853: END IF;
5854: END IF;
5855:
5856: -- cust_account_id is foreign key to hz_cust_accounts
5857: -- Since cust_account_id is mandatory and non-updateable,
5858: -- we only need to check FK during creation.
5859:
5860: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

5874: p_column_value => p_cust_profile_amt_rec.cust_account_id,
5875: x_return_status => x_return_status );
5876:
5877: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5878: hz_utility_v2pub.debug(p_message=>'cust_account_id is foreign key to hz_cust_accounts. ' ||
5879: 'x_return_status = ' || x_return_status,
5880: p_prefix =>l_debug_prefix,
5881: p_msg_level=>fnd_log.level_statement);
5882: END IF;

Line 6766: l_account_party_id hz_cust_accounts.party_id%TYPE;

6762: p_cust_acct_site_rec IN HZ_CUST_ACCOUNT_SITE_V2PUB.CUST_ACCT_SITE_REC_TYPE,
6763: x_return_status IN OUT NOCOPY VARCHAR2
6764: ) IS
6765: l_site_party_id hz_party_sites.party_id%TYPE;
6766: l_account_party_id hz_cust_accounts.party_id%TYPE;
6767: l_account_number hz_cust_accounts.account_number%TYPE;
6768: l_party_type hz_parties.party_type%TYPE;
6769: l_site_party_name hz_parties.party_name%TYPE;
6770: l_account_party_name hz_parties.party_name%TYPE;

Line 6767: l_account_number hz_cust_accounts.account_number%TYPE;

6763: x_return_status IN OUT NOCOPY VARCHAR2
6764: ) IS
6765: l_site_party_id hz_party_sites.party_id%TYPE;
6766: l_account_party_id hz_cust_accounts.party_id%TYPE;
6767: l_account_number hz_cust_accounts.account_number%TYPE;
6768: l_party_type hz_parties.party_type%TYPE;
6769: l_site_party_name hz_parties.party_name%TYPE;
6770: l_account_party_name hz_parties.party_name%TYPE;
6771:

Line 6784: FROM hz_cust_accounts

6780: END IF;
6781:
6782: SELECT party_id,account_number
6783: INTO l_account_party_id,l_account_number
6784: FROM hz_cust_accounts
6785: WHERE cust_account_id = p_cust_acct_site_rec.cust_account_id ;
6786:
6787: -- Debug info.
6788: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 6979: l_orig_system_reference1 HZ_CUST_ACCOUNTS.orig_system_reference%TYPE;

6975:
6976: l_cust_account_id NUMBER;
6977: l_party_site_id NUMBER;
6978: l_orig_system_reference HZ_CUST_ACCT_SITES.orig_system_reference%TYPE;
6979: l_orig_system_reference1 HZ_CUST_ACCOUNTS.orig_system_reference%TYPE;
6980: l_created_by_module HZ_CUST_ACCT_SITES.created_by_module%TYPE;
6981: l_application_id NUMBER;
6982: l_status HZ_CUST_ACCT_SITES.status%TYPE;
6983: l_customer_category_code HZ_CUST_ACCT_SITES.customer_category_code%TYPE;

Line 7109: -- cust_account_id is foreign key of hz_cust_accounts

7105: p_msg_level=>fnd_log.level_statement);
7106: END IF;
7107: END IF;
7108:
7109: -- cust_account_id is foreign key of hz_cust_accounts
7110: -- Do not need to check during update because cust_account_id is
7111: -- non-updateable.
7112: IF p_create_update_flag = 'C' THEN
7113: IF p_cust_acct_site_rec.cust_account_id <> -1 AND

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

7121:
7122: -- Debug info.
7123:
7124: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
7125: hz_utility_v2pub.debug(p_message=>'cust_account_id is foreign key of hz_cust_accounts. ' ||
7126: 'x_return_status = ' || x_return_status,
7127: p_prefix =>l_debug_prefix,
7128: p_msg_level=>fnd_log.level_statement);
7129: END IF;

Line 9968: -- cust_account_id is foreign key to hz_cust_accounts

9964: END IF;
9965:
9966: END IF;
9967:
9968: -- cust_account_id is foreign key to hz_cust_accounts
9969: -- Since cust_account_id is mandatory and non-updateable,
9970: -- we only need to check FK during creation.
9971:
9972: IF p_create_update_flag = 'C' AND

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

9978: p_column_value => p_cust_account_role_rec.cust_account_id,
9979: x_return_status => x_return_status );
9980:
9981: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
9982: hz_utility_v2pub.debug(p_message=>'cust_account_id is foreign key to hz_cust_accounts. ' ||
9983: 'x_return_status = ' || x_return_status,
9984: p_prefix =>l_debug_prefix,
9985: p_msg_level=>fnd_log.level_statement);
9986: END IF;

Line 10962: FROM HZ_CUST_ACCOUNTS

10958:
10959: IF p_column_value <> -1 THEN
10960:
10961: SELECT 'Y' INTO l_dummy
10962: FROM HZ_CUST_ACCOUNTS
10963: WHERE CUST_ACCOUNT_ID = p_column_value;
10964:
10965: END IF;
10966:

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

10968: WHEN NO_DATA_FOUND THEN
10969: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
10970: FND_MESSAGE.SET_TOKEN( 'FK', 'cust_account_id' );
10971: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
10972: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_accounts' );
10973: FND_MSG_PUB.ADD;
10974: x_return_status := FND_API.G_RET_STS_ERROR;
10975:
10976: END check_cust_account_fk;

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

11251:
11252: IF l_org_id IS NOT NULL THEN
11253: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_COLUMN_SHOULD_BE_NULL' );
11254: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
11255: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_accounts' );
11256: FND_MSG_PUB.ADD;
11257: x_return_status := FND_API.G_RET_STS_ERROR;
11258:
11259: RETURN;

Line 12981: l_federal_entity_type HZ_CUST_ACCOUNTS.federal_entity_type%TYPE;

12977: p_cust_account_rec IN HZ_CUST_ACCOUNT_V2PUB.CUST_ACCOUNT_REC_TYPE,
12978: p_rowid IN ROWID,
12979: x_return_status IN OUT NOCOPY VARCHAR2
12980: ) IS
12981: l_federal_entity_type HZ_CUST_ACCOUNTS.federal_entity_type%TYPE;
12982: l_trading_partner_agency_id HZ_CUST_ACCOUNTS.trading_partner_agency_id%TYPE;
12983: l_duns_extension HZ_CUST_ACCOUNTS.duns_extension%TYPE;
12984: l_advance_payment_indicator HZ_CUST_ACCOUNTS.advance_payment_indicator%TYPE;
12985: l_tpai_validate VARCHAR2(2);

Line 12982: l_trading_partner_agency_id HZ_CUST_ACCOUNTS.trading_partner_agency_id%TYPE;

12978: p_rowid IN ROWID,
12979: x_return_status IN OUT NOCOPY VARCHAR2
12980: ) IS
12981: l_federal_entity_type HZ_CUST_ACCOUNTS.federal_entity_type%TYPE;
12982: l_trading_partner_agency_id HZ_CUST_ACCOUNTS.trading_partner_agency_id%TYPE;
12983: l_duns_extension HZ_CUST_ACCOUNTS.duns_extension%TYPE;
12984: l_advance_payment_indicator HZ_CUST_ACCOUNTS.advance_payment_indicator%TYPE;
12985: l_tpai_validate VARCHAR2(2);
12986: l_debug_prefix VARCHAR2(30) := '';

Line 12983: l_duns_extension HZ_CUST_ACCOUNTS.duns_extension%TYPE;

12979: x_return_status IN OUT NOCOPY VARCHAR2
12980: ) IS
12981: l_federal_entity_type HZ_CUST_ACCOUNTS.federal_entity_type%TYPE;
12982: l_trading_partner_agency_id HZ_CUST_ACCOUNTS.trading_partner_agency_id%TYPE;
12983: l_duns_extension HZ_CUST_ACCOUNTS.duns_extension%TYPE;
12984: l_advance_payment_indicator HZ_CUST_ACCOUNTS.advance_payment_indicator%TYPE;
12985: l_tpai_validate VARCHAR2(2);
12986: l_debug_prefix VARCHAR2(30) := '';
12987: l_temp VARCHAR2(1);

Line 12984: l_advance_payment_indicator HZ_CUST_ACCOUNTS.advance_payment_indicator%TYPE;

12980: ) IS
12981: l_federal_entity_type HZ_CUST_ACCOUNTS.federal_entity_type%TYPE;
12982: l_trading_partner_agency_id HZ_CUST_ACCOUNTS.trading_partner_agency_id%TYPE;
12983: l_duns_extension HZ_CUST_ACCOUNTS.duns_extension%TYPE;
12984: l_advance_payment_indicator HZ_CUST_ACCOUNTS.advance_payment_indicator%TYPE;
12985: l_tpai_validate VARCHAR2(2);
12986: l_debug_prefix VARCHAR2(30) := '';
12987: l_temp VARCHAR2(1);
12988: BEGIN

Line 13009: FROM HZ_CUST_ACCOUNTS

13005: l_federal_entity_type,
13006: l_trading_partner_agency_id,
13007: l_duns_extension,
13008: l_advance_payment_indicator
13009: FROM HZ_CUST_ACCOUNTS
13010: WHERE ROWID = p_rowid;
13011:
13012: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
13013: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'FV Attributes Database values : '