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.JL_INTERFACE_VAL dependencies on AP_INVOICES_INTERFACE

Line 401: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

397: END IF;
398: End;
399: -- Validate Mul BS by distribution lines.
400: IF (validate_error = 'Error') THEN
401: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
402: invo_id,
403: 'MULTIPLE BAL SEG FOUND',
404: p_default_last_updated_by,
405: p_default_last_update_login,

Line 526: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

522: AND nvl(end_date_active,sysdate) >= sysdate
523: AND enabled_flag = 'Y';
524: EXCEPTION
525: WHEN OTHERS THEN
526: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
527: p_parent_id,
528: 'INVALID_GLOBAL_ATTR11',
529: p_default_last_updated_by,
530: p_default_last_update_login,

Line 536: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

532: p_current_invoice_status := 'N';
533:
534: END;
535: ELSE -- The Global Attribute11 is Required
536: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
537: p_parent_id,
538: 'INVALID_GLOBAL_ATTR11',
539: p_default_last_updated_by,
540: p_default_last_update_login,

Line 560: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

556: AND nvl(end_date_active,sysdate) >= sysdate
557: AND enabled_flag = 'Y' ;
558: EXCEPTION
559: WHEN OTHERS THEN
560: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
561: p_parent_id,
562: 'INVALID_GLOBAL_ATTR12',
563: p_default_last_updated_by,
564: p_default_last_update_login,

Line 570: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

566: p_current_invoice_status := 'N';
567:
568: END;
569: ELSE -- The Global Attribute12 is Required
570: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
571: p_parent_id,
572: 'INVALID_GLOBAL_ATTR12',
573: p_default_last_updated_by,
574: p_default_last_update_login,

Line 590: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

586: WHERE trx_category = p_global_attribute11
587: and trx_letter = p_global_attribute12;
588: EXCEPTION
589: WHEN OTHERS THEN
590: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
591: p_parent_id,
592: 'INVALID_GLOBAL_ATTR13',
593: p_default_last_updated_by,
594: p_default_last_update_login,

Line 600: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

596:
597: p_current_invoice_status := 'N';
598: END;
599: ELSE -- The Global Attribute13 is Required
600: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
601: p_parent_id,
602: 'INVALID_GLOBAL_ATTR13',
603: p_default_last_updated_by,
604: p_default_last_update_login,

Line 626: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

622:
623: IF (Length_Date = 9) THEN
624: IF NOT (jg_globe_flex_val_shared.Check_Format (l_global_attribute15,'D',9,'','','','','','')) THEN
625:
626: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
627: p_parent_id,
628: 'INVALID_GLOBAL_ATTR15',
629: p_default_last_updated_by,
630: p_default_last_update_login,

Line 640: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

636: ELSIF (Length_Date = 11) THEN
637:
638: IF NOT(jg_globe_flex_val_shared.Check_Format (l_global_attribute15,'D', 11,'','','' ,'','','')) THEN
639:
640: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
641: p_parent_id,
642: 'INVALID_GLOBAL_ATTR15',
643: p_default_last_updated_by,
644: p_default_last_update_login,

Line 651: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

647: p_current_invoice_status := 'N';
648:
649: END IF; -- Check_Format 11
650: ELSE -- No Date Format.
651: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
652: p_parent_id,
653: 'INVALID_GLOBAL_ATTR15',
654: p_default_last_updated_by,
655: p_default_last_update_login,

Line 670: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

666: -- Changed the 3rd paramter of check_format from '0' to '15'
667:
668: IF NOT(jg_globe_flex_val_shared.Check_Format (p_global_attribute16,'C',15,'','', '','','','')) THEN
669:
670: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
671: p_parent_id,
672: 'INVALID_GLOBAL_ATTR16',
673: p_default_last_updated_by,
674: p_default_last_update_login,

Line 696: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

692: AND enabled_flag = 'Y' ;
693: EXCEPTION
694: WHEN OTHERS THEN
695:
696: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
697: p_parent_id,
698: 'INVALID_GLOBAL_ATTR17',
699: p_default_last_updated_by,
700: p_default_last_update_login,

Line 706: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

702: p_current_invoice_status := 'N';
703:
704: END;
705: ELSE -- The Global Attribute17 is Required
706: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
707: p_parent_id,
708: 'INVALID_GLOBAL_ATTR17',
709: p_default_last_updated_by,
710: p_default_last_update_login,

Line 732: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

728: (p_global_attribute18 IS NOT NULL) --OR
729: --(p_global_attribute19 IS NOT NULL) OR
730: --(p_global_attribute20 IS NOT NULL)
731: ) THEN
732: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
733: p_parent_id,
734: 'GLOBAL_ATTR_VALUE_FOUND',
735: p_default_last_updated_by,
736: p_default_last_update_login,

Line 793: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

789: END IF;
790: End;
791: -- Validate Mul BS by distribution lines.
792: IF (validate_error = 'Error') THEN
793: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
794: p_parent_id,
795: 'MULTIPLE BAL SEG FOUND',
796: p_default_last_updated_by,
797: p_default_last_update_login,

Line 986: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

982: AND sysdate < nvl(inactive_date, sysdate+1); -- Bug 3463869
983: EXCEPTION
984:
985: WHEN OTHERS THEN
986: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
987: p_parent_id,
988: 'INVALID_GLOBAL_ATTR18',
989: p_default_last_updated_by,
990: p_default_last_update_login,

Line 1018: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

1014: (p_global_attribute17 IS NOT NULL) OR
1015: (p_global_attribute19 IS NOT NULL) OR
1016: (p_global_attribute20 IS NOT NULL))
1017: THEN
1018: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
1019: p_parent_id,
1020: 'GLOBAL_ATTR_VALUE_FOUND',
1021: p_default_last_updated_by,
1022: p_default_last_update_login,

Line 2395: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

2391: AND enabled_flag = 'Y';
2392: EXCEPTION
2393:
2394: WHEN OTHERS THEN
2395: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
2396: p_parent_id,
2397: 'INVALID_GLOBAL_ATTR1',
2398: p_default_last_updated_by,
2399: p_default_last_update_login,

Line 2405: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

2401: p_current_invoice_status := 'N';
2402:
2403: END;
2404: ELSE -- The Global Attribute1 is Required
2405: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
2406: p_parent_id,
2407: 'INVALID_GLOBAL_ATTR1',
2408: p_default_last_updated_by,
2409: p_default_last_update_login,

Line 2425: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

2421: FROM jl_br_ap_operations
2422: WHERE cfo_code = p_global_attribute2;
2423: EXCEPTION
2424: WHEN OTHERS THEN
2425: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
2426: p_parent_id,
2427: 'INVALID_GLOBAL_ATTR2',
2428: p_default_last_updated_by,
2429: p_default_last_update_login,

Line 2450: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

2446: AND enabled_flag = 'Y';
2447: EXCEPTION
2448:
2449: WHEN OTHERS THEN
2450: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
2451: p_parent_id,
2452: 'INVALID_GLOBAL_ATTR3',
2453: p_default_last_updated_by,
2454: p_default_last_update_login,

Line 2476: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

2472: AND enabled_flag = 'Y';
2473: EXCEPTION
2474:
2475: WHEN OTHERS THEN
2476: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
2477: p_parent_id,
2478: 'INVALID_GLOBAL_ATTR4',
2479: p_default_last_updated_by,
2480: p_default_last_update_login,

Line 2491: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

2487: -- Format for ICMS Base Amount
2488:
2489: /* NUMBER(15,2),Numbers Only (0-9)*/
2490: IF (NOT jg_globe_flex_val_shared.check_format(p_global_attribute5,'N',15,2,'N','N','N','','')) THEN
2491: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
2492: p_parent_id,
2493: 'INVALID_GLOBAL_ATTR5',
2494: p_default_last_updated_by,
2495: p_default_last_update_login,

Line 2510: FROM ap_invoices_interface

2506:
2507: BEGIN
2508: SELECT invoice_date
2509: INTO p_val_date
2510: FROM ap_invoices_interface
2511: WHERE invoice_id = p_parent_id;
2512: EXCEPTION
2513: WHEN NO_DATA_FOUND THEN
2514: Null;

Line 2529: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

2525: AND nvl(enabled_flag,'Y') = 'Y';
2526: EXCEPTION
2527:
2528: WHEN OTHERS THEN
2529: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
2530: p_parent_id,
2531: 'INVALID_GLOBAL_ATTR6',
2532: p_default_last_updated_by,
2533: p_default_last_update_login,

Line 2544: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

2540: -- Format for ICMS Amount
2541:
2542: /* NUMBER(15,2),Numbers Only (0-9)*/
2543: IF (NOT jg_globe_flex_val_shared.check_format(p_global_attribute7,'N',15,2,'N','N','N','','')) THEN
2544: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
2545: p_parent_id,
2546: 'INVALID_GLOBAL_ATTR7',
2547: p_default_last_updated_by,
2548: p_default_last_update_login,

Line 2557: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

2553: -- Format for IPI Amount
2554:
2555: /* NUMBER(15,2),Numbers Only (0-9)*/
2556: IF (NOT jg_globe_flex_val_shared.check_format(p_global_attribute8,'N',15,2,'N','N','N','','')) THEN
2557: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
2558: p_parent_id,
2559: 'INVALID_GLOBAL_ATTR8',
2560: p_default_last_updated_by,
2561: p_default_last_update_login,

Line 2570: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

2566: -- Format for Withholding Base Amount
2567:
2568: /* NUMBER(15,2)*/
2569: IF (NOT jg_globe_flex_val_shared.check_format(p_global_attribute9,'N',15,2,'Y','N','N','','')) THEN
2570: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
2571: p_parent_id,
2572: 'INVALID_GLOBAL_ATTR9',
2573: p_default_last_updated_by,
2574: p_default_last_update_login,

Line 2582: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

2578:
2579: -- Validation for Consolidated Invoice Number (Should be NULL at this point)
2580:
2581: IF (p_global_attribute10 IS NOT NULL) THEN
2582: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
2583: p_parent_id,
2584: 'INVALID_GLOBAL_ATTR10',
2585: p_default_last_updated_by,
2586: p_default_last_update_login,

Line 2606: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

2602: (p_global_attribute18 IS NOT NULL) OR
2603: (p_global_attribute19 IS NOT NULL) OR
2604: (p_global_attribute20 IS NOT NULL))
2605: THEN
2606: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
2607: p_parent_id,
2608: 'GLOBAL_ATTR_VALUE_FOUND',
2609: p_default_last_updated_by,
2610: p_default_last_update_login,

Line 2742: FROM ap_invoices_interface

2738: IF l_po_number is null THEN --then it is a nomatch case
2739: BEGIN
2740: SELECT global_attribute2,global_attribute6,global_attribute7
2741: INTO l_cfo_code,l_icms_tax_name,l_icms_tax_amount
2742: FROM ap_invoices_interface
2743: WHERE invoice_id = l_invoice_id;
2744: EXCEPTION
2745: WHEN OTHERS THEN
2746: null;

Line 2755: AND parent_table = 'AP_INVOICES_INTERFACE'

2751: SELECT DISTINCT 1
2752: INTO l_exists
2753: FROM ap_interface_rejections
2754: WHERE parent_id=l_invoice_id
2755: AND parent_table = 'AP_INVOICES_INTERFACE'
2756: AND REJECT_LOOKUP_CODE = 'INVALID_GLOBAL_ATTR2';
2757: EXCEPTION
2758: WHEN NO_DATA_FOUND THEN
2759: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

Line 2759: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

2755: AND parent_table = 'AP_INVOICES_INTERFACE'
2756: AND REJECT_LOOKUP_CODE = 'INVALID_GLOBAL_ATTR2';
2757: EXCEPTION
2758: WHEN NO_DATA_FOUND THEN
2759: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
2760: l_invoice_id,
2761: 'INVALID_GLOBAL_ATTR2',
2762: p_default_last_updated_by,
2763: p_default_last_update_login,

Line 3113: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

3109: AND enabled_flag = 'Y';
3110: EXCEPTION
3111:
3112: WHEN OTHERS THEN
3113: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
3114: p_parent_id,
3115: 'INVALID_GLOBAL_ATTR19',
3116: p_default_last_updated_by,
3117: p_default_last_update_login,

Line 3147: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',

3143: (p_global_attribute17 IS NOT NULL) OR
3144: (p_global_attribute18 IS NOT NULL) OR
3145: (p_global_attribute20 IS NOT NULL))
3146: THEN
3147: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
3148: p_parent_id,
3149: 'GLOBAL_ATTR_VALUE_FOUND',
3150: p_default_last_updated_by,
3151: p_default_last_update_login,