DBA Data[Home] [Help]

APPS.JA_INTERFACE_VAL dependencies on JG_GLOBE_FLEX_VAL_SHARED

Line 393: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

389: INTO l_tax_inv_date
390: FROM dual;
391: EXCEPTION
392: WHEN OTHERS THEN
393: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
394: p_parent_id,
395: 'INVALID_GLOBAL_ATTR2',
396: p_default_last_updated_by,
397: p_default_last_update_login,

Line 406: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

402: -- Supplier Tax Invoice Number and Tax Accounting Period fields are required
403: -- if Tax Invoice Date is entered
404:
405: IF (p_global_attribute3 IS NULL) THEN
406: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
407: p_parent_id,
408: 'INVALID_GLOBAL_ATTR3',
409: p_default_last_updated_by,
410: p_default_last_update_login,

Line 416: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

412: p_current_invoice_status := 'N';
413: END IF;
414:
415: IF (p_global_attribute4 IS NULL) THEN
416: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
417: p_parent_id,
418: 'INVALID_GLOBAL_ATTR4',
419: p_default_last_updated_by,
420: p_default_last_update_login,

Line 446: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

442: and adjustment_period_flag = 'N'
443: and end_date >= fnd_date.canonical_to_date(p_global_attribute2));
444: EXCEPTION
445: WHEN OTHERS THEN
446: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
447: p_parent_id,
448: 'INVALID_GLOBAL_ATTR4',
449: p_default_last_updated_by,
450: p_default_last_update_login,

Line 477: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

473: (p_global_attribute18 IS NOT NULL) OR
474: (p_global_attribute19 IS NOT NULL) OR
475: (p_global_attribute20 IS NOT NULL))
476: THEN
477: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
478: p_parent_id,
479: 'GLOBAL_ATTR_VALUE_FOUND',
480: p_default_last_updated_by,
481: p_default_last_update_login,

Line 527: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

523: p_calling_sequence IN VARCHAR2) IS
524:
525: BEGIN
526: IF (p_global_attribute1 NOT IN ('21','22','23','24','25','26','27','28')) THEN
527: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
528: p_parent_id,
529: 'INVALID_GLOBAL_ATTR1',
530: p_default_last_updated_by,
531: p_default_last_update_login,

Line 537: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

533: p_current_invoice_status := 'N';
534: END IF;
535:
536: IF (p_global_attribute2 NOT IN ('Y','N')) THEN
537: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
538: p_parent_id,
539: 'INVALID_GLOBAL_ATTR2',
540: p_default_last_updated_by,
541: p_default_last_update_login,

Line 547: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

543: p_current_invoice_status := 'N';
544: END IF;
545:
546: IF (p_global_attribute3 NOT IN ('1','2')) THEN
547: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
548: p_parent_id,
549: 'INVALID_GLOBAL_ATTR3',
550: p_default_last_updated_by,
551: p_default_last_update_login,

Line 563: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

559: BEGIN
560: X_temp := fnd_date.canonical_to_date(p_global_attribute4);
561: EXCEPTION
562: WHEN OTHERS THEN
563: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
564: p_parent_id,
565: 'INVALID_GLOBAL_ATTR4',
566: p_default_last_updated_by,
567: p_default_last_update_login,

Line 589: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

585: (p_global_attribute18 IS NOT NULL) OR
586: (p_global_attribute19 IS NOT NULL) OR
587: (p_global_attribute20 IS NOT NULL))
588: THEN
589: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
590: p_parent_id,
591: 'GLOBAL_ATTR_VALUE_FOUND',
592: p_default_last_updated_by,
593: p_default_last_update_login,

Line 637: IF (NOT jg_globe_flex_val_shared.check_format(p_global_attribute1,'N',15,'','N','N','N','','')) THEN

633: p_calling_sequence IN VARCHAR2) IS
634:
635: BEGIN
636: /* NONE - NUMBER(15),Numbers Only(0-9) */
637: IF (NOT jg_globe_flex_val_shared.check_format(p_global_attribute1,'N',15,'','N','N','N','','')) THEN
638: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
639: p_parent_id,
640: 'INVALID_GLOBAL_ATTR1',
641: p_default_last_updated_by,

Line 638: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

634:
635: BEGIN
636: /* NONE - NUMBER(15),Numbers Only(0-9) */
637: IF (NOT jg_globe_flex_val_shared.check_format(p_global_attribute1,'N',15,'','N','N','N','','')) THEN
638: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
639: p_parent_id,
640: 'INVALID_GLOBAL_ATTR1',
641: p_default_last_updated_by,
642: p_default_last_update_login,

Line 667: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

663: (p_global_attribute18 IS NOT NULL) OR
664: (p_global_attribute19 IS NOT NULL) OR
665: (p_global_attribute20 IS NOT NULL))
666: THEN
667: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
668: p_parent_id,
669: 'GLOBAL_ATTR_VALUE_FOUND',
670: p_default_last_updated_by,
671: p_default_last_update_login,

Line 790: p_glob_attr_set1 IN JG_GLOBE_FLEX_VAL_SHARED.GdfRec,

786: END ar_business_rules;
787:
788: PROCEDURE ar_business_rules(
789: p_int_table_name IN VARCHAR2,
790: p_glob_attr_set1 IN JG_GLOBE_FLEX_VAL_SHARED.GdfRec,
791: p_glob_attr_set2 IN JG_GLOBE_FLEX_VAL_SHARED.GdfRec,
792: p_glob_attr_set3 IN JG_GLOBE_FLEX_VAL_SHARED.GdfRec,
793: p_misc_prod_arg IN JG_GLOBE_FLEX_VAL_SHARED.GenRec,
794: p_current_record_status OUT NOCOPY VARCHAR2) IS

Line 791: p_glob_attr_set2 IN JG_GLOBE_FLEX_VAL_SHARED.GdfRec,

787:
788: PROCEDURE ar_business_rules(
789: p_int_table_name IN VARCHAR2,
790: p_glob_attr_set1 IN JG_GLOBE_FLEX_VAL_SHARED.GdfRec,
791: p_glob_attr_set2 IN JG_GLOBE_FLEX_VAL_SHARED.GdfRec,
792: p_glob_attr_set3 IN JG_GLOBE_FLEX_VAL_SHARED.GdfRec,
793: p_misc_prod_arg IN JG_GLOBE_FLEX_VAL_SHARED.GenRec,
794: p_current_record_status OUT NOCOPY VARCHAR2) IS
795:

Line 792: p_glob_attr_set3 IN JG_GLOBE_FLEX_VAL_SHARED.GdfRec,

788: PROCEDURE ar_business_rules(
789: p_int_table_name IN VARCHAR2,
790: p_glob_attr_set1 IN JG_GLOBE_FLEX_VAL_SHARED.GdfRec,
791: p_glob_attr_set2 IN JG_GLOBE_FLEX_VAL_SHARED.GdfRec,
792: p_glob_attr_set3 IN JG_GLOBE_FLEX_VAL_SHARED.GdfRec,
793: p_misc_prod_arg IN JG_GLOBE_FLEX_VAL_SHARED.GenRec,
794: p_current_record_status OUT NOCOPY VARCHAR2) IS
795:
796: l_current_record_status VARCHAR2(1);

Line 793: p_misc_prod_arg IN JG_GLOBE_FLEX_VAL_SHARED.GenRec,

789: p_int_table_name IN VARCHAR2,
790: p_glob_attr_set1 IN JG_GLOBE_FLEX_VAL_SHARED.GdfRec,
791: p_glob_attr_set2 IN JG_GLOBE_FLEX_VAL_SHARED.GdfRec,
792: p_glob_attr_set3 IN JG_GLOBE_FLEX_VAL_SHARED.GdfRec,
793: p_misc_prod_arg IN JG_GLOBE_FLEX_VAL_SHARED.GenRec,
794: p_current_record_status OUT NOCOPY VARCHAR2) IS
795:
796: l_current_record_status VARCHAR2(1);
797:

Line 819: p_glob_attr_set1 IN JG_GLOBE_FLEX_VAL_SHARED.GdfRec,

815:
816: END ar_business_rules;
817:
818: PROCEDURE ja_tw_arxcudci_customers(
819: p_glob_attr_set1 IN JG_GLOBE_FLEX_VAL_SHARED.GdfRec,
820: p_glob_attr_set2 IN JG_GLOBE_FLEX_VAL_SHARED.GdfRec,
821: p_glob_attr_set3 IN JG_GLOBE_FLEX_VAL_SHARED.GdfRec,
822: p_misc_prod_arg IN JG_GLOBE_FLEX_VAL_SHARED.GenRec,
823: p_current_record_status OUT NOCOPY VARCHAR2) IS

Line 820: p_glob_attr_set2 IN JG_GLOBE_FLEX_VAL_SHARED.GdfRec,

816: END ar_business_rules;
817:
818: PROCEDURE ja_tw_arxcudci_customers(
819: p_glob_attr_set1 IN JG_GLOBE_FLEX_VAL_SHARED.GdfRec,
820: p_glob_attr_set2 IN JG_GLOBE_FLEX_VAL_SHARED.GdfRec,
821: p_glob_attr_set3 IN JG_GLOBE_FLEX_VAL_SHARED.GdfRec,
822: p_misc_prod_arg IN JG_GLOBE_FLEX_VAL_SHARED.GenRec,
823: p_current_record_status OUT NOCOPY VARCHAR2) IS
824:

Line 821: p_glob_attr_set3 IN JG_GLOBE_FLEX_VAL_SHARED.GdfRec,

817:
818: PROCEDURE ja_tw_arxcudci_customers(
819: p_glob_attr_set1 IN JG_GLOBE_FLEX_VAL_SHARED.GdfRec,
820: p_glob_attr_set2 IN JG_GLOBE_FLEX_VAL_SHARED.GdfRec,
821: p_glob_attr_set3 IN JG_GLOBE_FLEX_VAL_SHARED.GdfRec,
822: p_misc_prod_arg IN JG_GLOBE_FLEX_VAL_SHARED.GenRec,
823: p_current_record_status OUT NOCOPY VARCHAR2) IS
824:
825: l_record_status VARCHAR2(1);

Line 822: p_misc_prod_arg IN JG_GLOBE_FLEX_VAL_SHARED.GenRec,

818: PROCEDURE ja_tw_arxcudci_customers(
819: p_glob_attr_set1 IN JG_GLOBE_FLEX_VAL_SHARED.GdfRec,
820: p_glob_attr_set2 IN JG_GLOBE_FLEX_VAL_SHARED.GdfRec,
821: p_glob_attr_set3 IN JG_GLOBE_FLEX_VAL_SHARED.GdfRec,
822: p_misc_prod_arg IN JG_GLOBE_FLEX_VAL_SHARED.GenRec,
823: p_current_record_status OUT NOCOPY VARCHAR2) IS
824:
825: l_record_status VARCHAR2(1);
826: l_rowid ROWID;

Line 1001: jg_globe_flex_val_shared.update_interface_status(

997: -- Update Interface_Status of ra_customers_interface.
998: --
999:
1000: IF l_record_status = 'E' THEN
1001: jg_globe_flex_val_shared.update_interface_status(
1002: l_rowid,
1003: l_table_name,
1004: l_mesg_code,
1005: 'E');