261:
262: -- Taxable Amount
263: IF p_global_attribute1 is not null then
264: -- Bug 3510068. Changed the maximum size from 1 to 30.
265: IF (NOT jg_globe_flex_val_shared.check_format(p_global_attribute1,'N',30,'','N','N','N','','')) then
266: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
267: p_parent_id,
268: 'INVALID_GLOBAL_ATTR1',
269: p_default_last_updated_by,
262: -- Taxable Amount
263: IF p_global_attribute1 is not null then
264: -- Bug 3510068. Changed the maximum size from 1 to 30.
265: IF (NOT jg_globe_flex_val_shared.check_format(p_global_attribute1,'N',30,'','N','N','N','','')) then
266: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
267: p_parent_id,
268: 'INVALID_GLOBAL_ATTR1',
269: p_default_last_updated_by,
270: p_default_last_update_login,
288: (p_global_attribute18 is not null) or
289: (p_global_attribute19 is not null) or
290: (p_global_attribute20 is not null) THEN
291:
292: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
293: p_parent_id,
294: 'GLOBAL_ATTR_VALUE_FOUND',
295: p_default_last_updated_by,
296: p_default_last_update_login,
360: (p_global_attribute19 IS NOT NULL) OR
361: (p_global_attribute20 IS NOT NULL))
362: THEN
363:
364: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
365: p_parent_id,
366: 'GLOBAL_ATTR_VALUE_FOUND',
367: p_default_last_updated_by,
368: p_default_last_update_login,
414: IF (p_global_attribute2 IS NOT NULL AND
415: p_global_attribute2 NOT IN ('Y','N')) OR
416: (p_global_attribute2 IS NULL) THEN
417:
418: jg_globe_flex_val_shared.insert_rejections(
419: 'AP_INVOICES_INTERFACE',
420: p_parent_id,
421: 'INVALID_GLOBAL_ATTR2',
422: p_default_last_updated_by,
447: (p_global_attribute18 IS NOT NULL) OR
448: (p_global_attribute19 IS NOT NULL) OR
449: (p_global_attribute20 IS NOT NULL))
450: THEN
451: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
452: p_parent_id,
453: 'GLOBAL_ATTR_VALUE_FOUND',
454: p_default_last_updated_by,
455: p_default_last_update_login,
492: BEGIN
493: IF p_global_attribute2 IS NOT NULL THEN
494: if p_global_attribute3 is NULL THEN
495:
496: jg_globe_flex_val_shared.insert_rejections('AP_INVOICE_LINES_INTERFACE',
497: p_parent_id,
498: 'INVALID_GLOBAL_ATTR3',
499: p_default_last_updated_by,
500: p_default_last_update_login,
505: end if;
506:
507: EXCEPTION
508: WHEN OTHERS THEN
509: jg_globe_flex_val_shared.insert_rejections('AP_INVOICE_LINES_INTERFACE',
510: p_parent_id,
511: 'GLOBAL_ATTR_VALUE_FOUND',
512: p_default_last_updated_by,
513: p_default_last_update_login,
530: (p_global_attribute18 IS NOT NULL) or
531: (p_global_attribute19 IS NOT NULL) or
532: (p_global_attribute20 IS NOT NULL)
533: THEN
534: jg_globe_flex_val_shared.insert_rejections('AP_INVOICE_LINES_INTERFACE',
535: p_parent_id,
536: 'GLOBAL_ATTR_VALUE_FOUND',
537: p_default_last_updated_by,
538: p_default_last_update_login,
546: -- Modification to the passing of parameters to ar_business_rules for TCA model
547:
548: PROCEDURE ar_business_rules
549: (p_int_table_name IN VARCHAR2,
550: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
551: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
552: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
553: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,
554: p_current_record_status OUT NOCOPY VARCHAR2) IS
547:
548: PROCEDURE ar_business_rules
549: (p_int_table_name IN VARCHAR2,
550: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
551: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
552: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
553: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,
554: p_current_record_status OUT NOCOPY VARCHAR2) IS
555:
548: PROCEDURE ar_business_rules
549: (p_int_table_name IN VARCHAR2,
550: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
551: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
552: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
553: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,
554: p_current_record_status OUT NOCOPY VARCHAR2) IS
555:
556: l_current_record_status VARCHAR2(1) := 'S';
549: (p_int_table_name IN VARCHAR2,
550: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
551: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
552: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
553: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,
554: p_current_record_status OUT NOCOPY VARCHAR2) IS
555:
556: l_current_record_status VARCHAR2(1) := 'S';
557: l_ou_id NUMBER;
604:
605:
606:
607: PROCEDURE je_gr_arxcudci_cust_txid
608: ( p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
609: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
610: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
611: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,
612: p_record_status OUT NOCOPY VARCHAR2)
605:
606:
607: PROCEDURE je_gr_arxcudci_cust_txid
608: ( p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
609: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
610: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
611: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,
612: p_record_status OUT NOCOPY VARCHAR2)
613: IS
606:
607: PROCEDURE je_gr_arxcudci_cust_txid
608: ( p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
609: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
610: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
611: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,
612: p_record_status OUT NOCOPY VARCHAR2)
613: IS
614:
607: PROCEDURE je_gr_arxcudci_cust_txid
608: ( p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
609: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
610: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
611: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,
612: p_record_status OUT NOCOPY VARCHAR2)
613: IS
614:
615: dummy_code NUMBER;
638: IF l_error_code IS NULL THEN
639: p_record_status := 'S';
640: ELSE
641: p_record_status := 'E';
642: jg_globe_flex_val_shared.update_interface_status
643: (l_row_id,
644: 'RA_CUSTOMERS_INTERFACE',
645: l_error_code,
646: p_record_status);
650:
651:
652:
653: PROCEDURE je_zz_arxcudci_site_uses
654: ( p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
655: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
656: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
657: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,
658: p_record_status OUT NOCOPY VARCHAR2)
651:
652:
653: PROCEDURE je_zz_arxcudci_site_uses
654: ( p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
655: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
656: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
657: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,
658: p_record_status OUT NOCOPY VARCHAR2)
659: IS
652:
653: PROCEDURE je_zz_arxcudci_site_uses
654: ( p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
655: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
656: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
657: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,
658: p_record_status OUT NOCOPY VARCHAR2)
659: IS
660:
653: PROCEDURE je_zz_arxcudci_site_uses
654: ( p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
655: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
656: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
657: p_misc_prod_arg IN jg_globe_flex_val_shared.GenRec,
658: p_record_status OUT NOCOPY VARCHAR2)
659: IS
660:
661: dummy_code NUMBER;
684: IF l_error_code IS NULL THEN
685: p_record_status := 'S';
686: ELSE
687: p_record_status := 'E';
688: jg_globe_flex_val_shared.update_interface_status
689: (l_row_id,
690: 'RA_CUSTOMERS_INTERFACE',
691: l_error_code,
692: p_record_status);