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.JG_GLOBE_FLEX_VAL dependencies on JG_GLOBE_FLEX_VAL

Line 1: PACKAGE BODY JG_GLOBE_FLEX_VAL AS

1: PACKAGE BODY JG_GLOBE_FLEX_VAL AS
2: /* $Header: jggdfvb.pls 120.15.12000000.2 2007/07/25 14:48:36 pakumare ship $ */
3:
4:
5: ------------------------------------------------------------------

Line 214: (p_glob_attr_set IN jg_globe_flex_val_shared.GdfRec) RETURN BOOLEAN IS

210: --
211: -- Modified version of check_attr_exists
212: --
213: FUNCTION check_attr_exists
214: (p_glob_attr_set IN jg_globe_flex_val_shared.GdfRec) RETURN BOOLEAN IS
215:
216: BEGIN
217: IF (p_glob_attr_set.global_attribute1 IS NOT NULL) or
218: (p_glob_attr_set.global_attribute2 IS NOT NULL) or

Line 415: p_glob_attr_set jg_globe_flex_val_shared.GdfRec,

411: END IF;
412: END check_context_code;
413:
414: FUNCTION check_each_gdf(p_flexfield_name VARCHAR2,
415: p_glob_attr_set jg_globe_flex_val_shared.GdfRec,
416: p_glob_attr_gen jg_globe_flex_val_shared.GenRec)
417: RETURN VARCHAR2 IS
418:
419: l_errcode VARCHAR2(10) DEFAULT NULL;

Line 416: p_glob_attr_gen jg_globe_flex_val_shared.GenRec)

412: END check_context_code;
413:
414: FUNCTION check_each_gdf(p_flexfield_name VARCHAR2,
415: p_glob_attr_set jg_globe_flex_val_shared.GdfRec,
416: p_glob_attr_gen jg_globe_flex_val_shared.GenRec)
417: RETURN VARCHAR2 IS
418:
419: l_errcode VARCHAR2(10) DEFAULT NULL;
420:

Line 906: l_curr_calling_sequence := 'jg_globe_flex_val.'||l_debug_loc||'<-'||p_calling_sequence;

902:
903: l_debug_loc := 'check_attr_value_ap';
904:
905: -------------------------- DEBUG INFORMATION ------------------------------
906: l_curr_calling_sequence := 'jg_globe_flex_val.'||l_debug_loc||'<-'||p_calling_sequence;
907: l_debug_info := 'Check if value exists in global attribute columns where not expected';
908: ---------------------------------------------------------------------------
909: --
910: -- Check AP Context Integrity

Line 1077: l_curr_calling_sequence := 'jg_globe_flex_val.'||l_debug_loc||'<-'||p_calling_sequence;

1073:
1074: BEGIN
1075: l_debug_loc := 'check_ap_context_integrity';
1076: -------------------------- DEBUG INFORMATION ------------------------------
1077: l_curr_calling_sequence := 'jg_globe_flex_val.'||l_debug_loc||'<-'||p_calling_sequence;
1078: l_debug_info := 'Reject invalid context code';
1079: ---------------------------------------------------------------------------
1080: --
1081: -- Reject when global attribute value found where not expected.

Line 1171: l_curr_calling_sequence := 'jg_globe_flex_val.'||l_debug_loc||'<-'||p_calling_sequence;

1167:
1168: BEGIN
1169: l_debug_loc := 'reject_value_found';
1170: -------------------------- DEBUG INFORMATION ------------------------------
1171: l_curr_calling_sequence := 'jg_globe_flex_val.'||l_debug_loc||'<-'||p_calling_sequence;
1172: l_debug_info := 'Reject invalid context code';
1173: ---------------------------------------------------------------------------
1174: IF (check_attr_exists(
1175: p_global_attribute_category,

Line 1197: jg_globe_flex_val_shared.insert_rejections(p_parent_table,

1193: p_global_attribute18,
1194: p_global_attribute19,
1195: p_global_attribute20) <> TRUE)
1196: THEN
1197: jg_globe_flex_val_shared.insert_rejections(p_parent_table,
1198: p_parent_id,
1199: 'GLOBAL_ATTR_VALUE_FOUND',
1200: p_default_last_updated_by,
1201: p_default_last_update_login,

Line 1228: l_curr_calling_sequence := 'jg_globe_flex_val.'||l_debug_loc||'<-'||p_calling_sequence;

1224:
1225: BEGIN
1226: l_debug_loc := 'reject_invalid_context_code';
1227: -------------------------- DEBUG INFORMATION ------------------------------
1228: l_curr_calling_sequence := 'jg_globe_flex_val.'||l_debug_loc||'<-'||p_calling_sequence;
1229: l_debug_info := 'Reject invalid context code';
1230: ---------------------------------------------------------------------------
1231: IF p_global_attribute_category IS NOT NULL THEN
1232: l_debug_info := 'Check if specified context value is valid';

Line 1237: jg_globe_flex_val_shared.insert_rejections(p_parent_table,

1233: IF (check_context_code(
1234: p_calling_program_name,
1235: p_global_attribute_category) <> TRUE)
1236: THEN
1237: jg_globe_flex_val_shared.insert_rejections(p_parent_table,
1238: p_parent_id,
1239: 'INVALID_GLOBAL_CONTEXT',
1240: p_default_last_updated_by,
1241: p_default_last_update_login,

Line 1301: l_curr_calling_sequence := 'jg_globe_flex_val.'||l_debug_loc||'<-'||p_calling_sequence;

1297: BEGIN
1298: l_debug_loc := 'check_ap_business_rules';
1299:
1300: -------------------------- DEBUG INFORMATION ------------------------------
1301: l_curr_calling_sequence := 'jg_globe_flex_val.'||l_debug_loc||'<-'||p_calling_sequence;
1302: l_debug_info := 'Check ap business rules';
1303: ---------------------------------------------------------------------------
1304:
1305: p_current_invoice_status := 'Y'; -- Initialize record status variable

Line 1666: gdf_rec1 jg_globe_flex_val_shared.GdfRec; /* New Record Variable */

1662: WHERE i.request_id = p_request_id
1663: AND nvl(i.validated_flag,'N') <> 'Y';
1664:
1665:
1666: gdf_rec1 jg_globe_flex_val_shared.GdfRec; /* New Record Variable */
1667: gdf_rec2 jg_globe_flex_val_shared.GdfRec; /* New Record Variable */
1668: gdf_rec3 jg_globe_flex_val_shared.GdfRec; /* New Record Variable */
1669: gdf_general_rec jg_globe_flex_val_shared.GenRec; /* New Record Variable */
1670:

Line 1667: gdf_rec2 jg_globe_flex_val_shared.GdfRec; /* New Record Variable */

1663: AND nvl(i.validated_flag,'N') <> 'Y';
1664:
1665:
1666: gdf_rec1 jg_globe_flex_val_shared.GdfRec; /* New Record Variable */
1667: gdf_rec2 jg_globe_flex_val_shared.GdfRec; /* New Record Variable */
1668: gdf_rec3 jg_globe_flex_val_shared.GdfRec; /* New Record Variable */
1669: gdf_general_rec jg_globe_flex_val_shared.GenRec; /* New Record Variable */
1670:
1671: --

Line 1668: gdf_rec3 jg_globe_flex_val_shared.GdfRec; /* New Record Variable */

1664:
1665:
1666: gdf_rec1 jg_globe_flex_val_shared.GdfRec; /* New Record Variable */
1667: gdf_rec2 jg_globe_flex_val_shared.GdfRec; /* New Record Variable */
1668: gdf_rec3 jg_globe_flex_val_shared.GdfRec; /* New Record Variable */
1669: gdf_general_rec jg_globe_flex_val_shared.GenRec; /* New Record Variable */
1670:
1671: --
1672: -- End of modification

Line 1669: gdf_general_rec jg_globe_flex_val_shared.GenRec; /* New Record Variable */

1665:
1666: gdf_rec1 jg_globe_flex_val_shared.GdfRec; /* New Record Variable */
1667: gdf_rec2 jg_globe_flex_val_shared.GdfRec; /* New Record Variable */
1668: gdf_rec3 jg_globe_flex_val_shared.GdfRec; /* New Record Variable */
1669: gdf_general_rec jg_globe_flex_val_shared.GenRec; /* New Record Variable */
1670:
1671: --
1672: -- End of modification
1673: --

Line 1897: arp_standard.debug('Not calling JG_GLOBE_FLEX_VAL_PKG.CHECK_ATTR_VALUE');

1893:
1894: EXCEPTION
1895: WHEN NO_DATA_FOUND THEN
1896: IF PG_DEBUG in ('Y', 'C') THEN
1897: arp_standard.debug('Not calling JG_GLOBE_FLEX_VAL_PKG.CHECK_ATTR_VALUE');
1898: arp_standard.debug('check_attr_value: ' || 'Global Descr Flex Field Validation end: '
1899: || to_char(sysdate, 'DD-MON-RR HH:MI:SS'));
1900: END IF;
1901: WHEN OTHERS THEN

Line 1903: arp_standard.debug('check_attr_value: ' || 'Exception calling JG_GLOBE_FLEX_VAL.ar_cust_interface');

1899: || to_char(sysdate, 'DD-MON-RR HH:MI:SS'));
1900: END IF;
1901: WHEN OTHERS THEN
1902: IF PG_DEBUG in ('Y', 'C') THEN
1903: arp_standard.debug('check_attr_value: ' || 'Exception calling JG_GLOBE_FLEX_VAL.ar_cust_interface');
1904: arp_standard.debug('check_attr_value: ' || SQLERRM);
1905: arp_standard.debug('check_attr_value: ' || 'Global Descr Flex Field Validation end: '
1906: || to_char(sysdate, 'DD-MON-RR HH:MI:SS'));
1907: END IF;

Line 1921: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,

1917: -- Modified version of check_attr_value_ar
1918: --
1919: PROCEDURE check_attr_value_ar
1920: (p_int_table_name IN VARCHAR2,
1921: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
1922: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
1923: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
1924: p_glob_attr_general IN jg_globe_flex_val_shared.GenRec,
1925: p_current_record_status OUT NOCOPY VARCHAR2

Line 1922: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,

1918: --
1919: PROCEDURE check_attr_value_ar
1920: (p_int_table_name IN VARCHAR2,
1921: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
1922: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
1923: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
1924: p_glob_attr_general IN jg_globe_flex_val_shared.GenRec,
1925: p_current_record_status OUT NOCOPY VARCHAR2
1926: ) IS

Line 1923: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,

1919: PROCEDURE check_attr_value_ar
1920: (p_int_table_name IN VARCHAR2,
1921: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
1922: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
1923: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
1924: p_glob_attr_general IN jg_globe_flex_val_shared.GenRec,
1925: p_current_record_status OUT NOCOPY VARCHAR2
1926: ) IS
1927:

Line 1924: p_glob_attr_general IN jg_globe_flex_val_shared.GenRec,

1920: (p_int_table_name IN VARCHAR2,
1921: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
1922: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
1923: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
1924: p_glob_attr_general IN jg_globe_flex_val_shared.GenRec,
1925: p_current_record_status OUT NOCOPY VARCHAR2
1926: ) IS
1927:
1928: l_current_record_status1 VARCHAR2(1);

Line 1940: arp_standard.debug('Begin check_attr_value_ar procedure in JG_GLOBE_FLEX_VAL p

1936:
1937: --arp_standard.enable_debug;
1938: -------------------------- DEBUG INFORMATION ---------------------------------
1939: IF PG_DEBUG in ('Y', 'C') THEN
1940: arp_standard.debug('Begin check_attr_value_ar procedure in JG_GLOBE_FLEX_VAL p
1941: ackage');
1942: END IF;
1943: ------------------------------------------------------------------------------
1944:

Line 2001: arp_standard.debug('Exception calling JG_GLOBE_FLEX_VAL.CHECK_ATTR_VALUE_

1997:
1998: EXCEPTION
1999: WHEN OTHERS THEN
2000: IF PG_DEBUG in ('Y', 'C') THEN
2001: arp_standard.debug('Exception calling JG_GLOBE_FLEX_VAL.CHECK_ATTR_VALUE_
2002: AR()');
2003: arp_standard.debug('check_attr_value: ' || SQLERRM);
2004: END IF;
2005: END check_attr_value_ar;

Line 2019: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,

2015: -- Modified version of ar_context_integrity
2016: --
2017: PROCEDURE check_ar_context_integrity(
2018: p_int_table_name IN VARCHAR2,
2019: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
2020: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
2021: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
2022: p_glob_attr_general IN jg_globe_flex_val_shared.GenRec,
2023: p_current_record_status OUT NOCOPY VARCHAR2) IS

Line 2020: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,

2016: --
2017: PROCEDURE check_ar_context_integrity(
2018: p_int_table_name IN VARCHAR2,
2019: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
2020: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
2021: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
2022: p_glob_attr_general IN jg_globe_flex_val_shared.GenRec,
2023: p_current_record_status OUT NOCOPY VARCHAR2) IS
2024:

Line 2021: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,

2017: PROCEDURE check_ar_context_integrity(
2018: p_int_table_name IN VARCHAR2,
2019: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
2020: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
2021: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
2022: p_glob_attr_general IN jg_globe_flex_val_shared.GenRec,
2023: p_current_record_status OUT NOCOPY VARCHAR2) IS
2024:
2025: l_errcode1 varchar2(10) DEFAULT NULL;

Line 2022: p_glob_attr_general IN jg_globe_flex_val_shared.GenRec,

2018: p_int_table_name IN VARCHAR2,
2019: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
2020: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
2021: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
2022: p_glob_attr_general IN jg_globe_flex_val_shared.GenRec,
2023: p_current_record_status OUT NOCOPY VARCHAR2) IS
2024:
2025: l_errcode1 varchar2(10) DEFAULT NULL;
2026: l_errcode varchar2(50) DEFAULT NULL;

Line 2093: JG_GLOBE_FLEX_VAL_SHARED.UPDATE_RA_CUSTOMERS_INTERFACE(

2089: IF l_errcode IS NOT NULL THEN
2090: --
2091: -- Update STATUS column of the customer interface table
2092: --
2093: JG_GLOBE_FLEX_VAL_SHARED.UPDATE_RA_CUSTOMERS_INTERFACE(
2094: l_errcode,
2095: p_glob_attr_general.core_prod_arg2,
2096: 'E');
2097: END IF;

Line 2131: JG_GLOBE_FLEX_VAL_SHARED.UPDATE_INTERFACE_STATUS(

2127:
2128: --
2129: -- Update STATUS column of the profile interface table
2130: --
2131: JG_GLOBE_FLEX_VAL_SHARED.UPDATE_INTERFACE_STATUS(
2132: p_glob_attr_general.core_prod_arg2,
2133: 'RA_CUSTOMER_PROFILES_INTERFACE',
2134: l_errcode,
2135: 'E');

Line 2151: arp_standard.debug('check_ar_context_integrity: ' || 'Exception calling JG_GLOBE_FLEX_VAL.CHECK_AR_CONTEXT

2147:
2148: EXCEPTION
2149: WHEN OTHERS THEN
2150: IF PG_DEBUG in ('Y', 'C') THEN
2151: arp_standard.debug('check_ar_context_integrity: ' || 'Exception calling JG_GLOBE_FLEX_VAL.CHECK_AR_CONTEXT
2152: _INTEGRITY()');
2153: arp_standard.debug('check_ar_context_integrity: ' || SQLERRM);
2154: END IF;
2155:

Line 2276: arp_standard.debug('Exception in JG_GLOBE_FLEX_VAL.CHECK_AR_BUSINESS_RULES()');

2272:
2273: EXCEPTION
2274: WHEN OTHERS THEN
2275: IF PG_DEBUG in ('Y', 'C') THEN
2276: arp_standard.debug('Exception in JG_GLOBE_FLEX_VAL.CHECK_AR_BUSINESS_RULES()');
2277: arp_standard.debug('check_ar_business_rules: ' || SQLERRM);
2278: END IF;
2279: END check_ar_business_rules;
2280: */

Line 2287: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,

2283: -- Modified version of check_ar_business_rules
2284: --
2285: PROCEDURE check_ar_business_rules(
2286: p_int_table_name IN VARCHAR2,
2287: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
2288: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
2289: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
2290: p_glob_attr_general IN jg_globe_flex_val_shared.GenRec,
2291: p_current_record_status OUT NOCOPY VARCHAR2,

Line 2288: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,

2284: --
2285: PROCEDURE check_ar_business_rules(
2286: p_int_table_name IN VARCHAR2,
2287: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
2288: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
2289: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
2290: p_glob_attr_general IN jg_globe_flex_val_shared.GenRec,
2291: p_current_record_status OUT NOCOPY VARCHAR2,
2292: p_org_id IN NUMBER ) IS --2354736

Line 2289: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,

2285: PROCEDURE check_ar_business_rules(
2286: p_int_table_name IN VARCHAR2,
2287: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
2288: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
2289: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
2290: p_glob_attr_general IN jg_globe_flex_val_shared.GenRec,
2291: p_current_record_status OUT NOCOPY VARCHAR2,
2292: p_org_id IN NUMBER ) IS --2354736
2293:

Line 2290: p_glob_attr_general IN jg_globe_flex_val_shared.GenRec,

2286: p_int_table_name IN VARCHAR2,
2287: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
2288: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
2289: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
2290: p_glob_attr_general IN jg_globe_flex_val_shared.GenRec,
2291: p_current_record_status OUT NOCOPY VARCHAR2,
2292: p_org_id IN NUMBER ) IS --2354736
2293:
2294:

Line 2363: arp_standard.debug('Exception in JG_GLOBE_FLEX_VAL.CHECK_AR_BUSINESS_RULES()');

2359:
2360: EXCEPTION
2361: WHEN OTHERS THEN
2362: IF PG_DEBUG in ('Y', 'C') THEN
2363: arp_standard.debug('Exception in JG_GLOBE_FLEX_VAL.CHECK_AR_BUSINESS_RULES()');
2364: arp_standard.debug('check_ar_business_rules: ' || SQLERRM);
2365: END IF;
2366: END check_ar_business_rules;
2367:

Line 2418: -- l_curr_calling_sequence := 'jg_globe_flex_val.'||l_debug_loc||'<-'||p_calling_sequence;

2414: -- PG_DEBUG := NVL(FND_PROFILE.value('AR_ENABLE_DEBUG_OUTPUT'), 'N');
2415: -- l_debug_loc := 'Insert_Jg_Zz_Invoice_Info';
2416: --
2417: -- -------------------------- DEBUG INFORMATION ------------------------------
2418: -- l_curr_calling_sequence := 'jg_globe_flex_val.'||l_debug_loc||'<-'||p_calling_sequence;
2419: -- l_debug_info := 'Insert invoices to jg_zz_invice_info';
2420: -- ---------------------------------------------------------------------------
2421: -- IF p_global_attribute_category IN ('BE.EFT Payments','CH.Swiss DTA Payment','CH.Swiss SAD Payment',
2422: -- 'DK','DK.GiroBank Domestic','DK.GiroBank Foreign',

Line 2554: arp_standard.debug('Exception calling JG_GLOBE_FLEX_VAL.insert_global_tabl

2550: NULL;
2551: END IF;
2552: EXCEPTION
2553: WHEN OTHERS THEN
2554: arp_standard.debug('Exception calling JG_GLOBE_FLEX_VAL.insert_global_tabl
2555: es');
2556: arp_standard.debug(SQLERRM);
2557: app_exception.raise_exception;
2558: END;

Line 2560: END jg_globe_flex_val;

2556: arp_standard.debug(SQLERRM);
2557: app_exception.raise_exception;
2558: END;
2559:
2560: END jg_globe_flex_val;