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.23.12020000.6 2013/02/22 10:37:08 abhijsar ship $ */
3:
4:
5: ------------------------------------------------------------------

Line 42: G_MODULE_NAME CONSTANT VARCHAR2(50) := 'JG.PLSQL.JG_GLOBE_FLEX_VAL';

38: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
39: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
40: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
41: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
42: G_MODULE_NAME CONSTANT VARCHAR2(50) := 'JG.PLSQL.JG_GLOBE_FLEX_VAL';
43:
44: -- Bug 8859419 End
45:
46: FUNCTION find

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

223: --
224: -- Modified version of check_attr_exists
225: --
226: FUNCTION check_attr_exists
227: (p_glob_attr_set IN jg_globe_flex_val_shared.GdfRec) RETURN BOOLEAN IS
228:
229: BEGIN
230: IF (p_glob_attr_set.global_attribute1 IS NOT NULL) or
231: (p_glob_attr_set.global_attribute2 IS NOT NULL) or

Line 462: p_glob_attr_set jg_globe_flex_val_shared.GdfRec,

458: END IF;
459: END check_context_code;
460:
461: FUNCTION check_each_gdf(p_flexfield_name VARCHAR2,
462: p_glob_attr_set jg_globe_flex_val_shared.GdfRec,
463: p_glob_attr_gen jg_globe_flex_val_shared.GenRec)
464: RETURN VARCHAR2 IS
465:
466: l_errcode VARCHAR2(10) DEFAULT NULL;

Line 463: p_glob_attr_gen jg_globe_flex_val_shared.GenRec)

459: END check_context_code;
460:
461: FUNCTION check_each_gdf(p_flexfield_name VARCHAR2,
462: p_glob_attr_set jg_globe_flex_val_shared.GdfRec,
463: p_glob_attr_gen jg_globe_flex_val_shared.GenRec)
464: RETURN VARCHAR2 IS
465:
466: l_errcode VARCHAR2(10) DEFAULT NULL;
467:

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

1009:
1010: l_debug_loc := 'check_attr_value_ap';
1011:
1012: -------------------------- DEBUG INFORMATION ------------------------------
1013: l_curr_calling_sequence := 'jg_globe_flex_val.'||l_debug_loc||'<-'||p_calling_sequence;
1014: l_debug_info := 'Check if value exists in global attribute columns where not expected';
1015: ---------------------------------------------------------------------------
1016: --
1017: -- Check AP Context Integrity

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

1180:
1181: BEGIN
1182: l_debug_loc := 'check_ap_context_integrity';
1183: -------------------------- DEBUG INFORMATION ------------------------------
1184: l_curr_calling_sequence := 'jg_globe_flex_val.'||l_debug_loc||'<-'||p_calling_sequence;
1185: l_debug_info := 'Reject invalid context code';
1186: ---------------------------------------------------------------------------
1187: --
1188: -- Reject when global attribute value found where not expected.

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

1274:
1275: BEGIN
1276: l_debug_loc := 'reject_value_found';
1277: -------------------------- DEBUG INFORMATION ------------------------------
1278: l_curr_calling_sequence := 'jg_globe_flex_val.'||l_debug_loc||'<-'||p_calling_sequence;
1279: l_debug_info := 'Reject invalid context code';
1280: ---------------------------------------------------------------------------
1281: IF (check_attr_exists(
1282: p_global_attribute_category,

Line 1304: jg_globe_flex_val_shared.insert_rejections(p_parent_table,

1300: p_global_attribute18,
1301: p_global_attribute19,
1302: p_global_attribute20) <> TRUE)
1303: THEN
1304: jg_globe_flex_val_shared.insert_rejections(p_parent_table,
1305: p_parent_id,
1306: 'GLOBAL_ATTR_VALUE_FOUND',
1307: p_default_last_updated_by,
1308: p_default_last_update_login,

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

1331:
1332: BEGIN
1333: l_debug_loc := 'reject_invalid_context_code';
1334: -------------------------- DEBUG INFORMATION ------------------------------
1335: l_curr_calling_sequence := 'jg_globe_flex_val.'||l_debug_loc||'<-'||p_calling_sequence;
1336: l_debug_info := 'Reject invalid context code';
1337: ---------------------------------------------------------------------------
1338: IF p_global_attribute_category IS NOT NULL THEN
1339: l_debug_info := 'Check if specified context value is valid';

Line 1344: jg_globe_flex_val_shared.insert_rejections(p_parent_table,

1340: IF (check_context_code(
1341: p_calling_program_name,
1342: p_global_attribute_category) <> TRUE)
1343: THEN
1344: jg_globe_flex_val_shared.insert_rejections(p_parent_table,
1345: p_parent_id,
1346: 'INVALID_GLOBAL_CONTEXT',
1347: p_default_last_updated_by,
1348: p_default_last_update_login,

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

1404: BEGIN
1405: l_debug_loc := 'check_ap_business_rules';
1406:
1407: -------------------------- DEBUG INFORMATION ------------------------------
1408: l_curr_calling_sequence := 'jg_globe_flex_val.'||l_debug_loc||'<-'||p_calling_sequence;
1409: l_debug_info := 'Check ap business rules';
1410: ---------------------------------------------------------------------------
1411:
1412: p_current_invoice_status := 'Y'; -- Initialize record status variable

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

1769: WHERE i.request_id = p_request_id
1770: AND nvl(i.validated_flag,'N') <> 'Y';
1771:
1772:
1773: gdf_rec1 jg_globe_flex_val_shared.GdfRec; /* New Record Variable */
1774: gdf_rec2 jg_globe_flex_val_shared.GdfRec; /* New Record Variable */
1775: gdf_rec3 jg_globe_flex_val_shared.GdfRec; /* New Record Variable */
1776: gdf_general_rec jg_globe_flex_val_shared.GenRec; /* New Record Variable */
1777:

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

1770: AND nvl(i.validated_flag,'N') <> 'Y';
1771:
1772:
1773: gdf_rec1 jg_globe_flex_val_shared.GdfRec; /* New Record Variable */
1774: gdf_rec2 jg_globe_flex_val_shared.GdfRec; /* New Record Variable */
1775: gdf_rec3 jg_globe_flex_val_shared.GdfRec; /* New Record Variable */
1776: gdf_general_rec jg_globe_flex_val_shared.GenRec; /* New Record Variable */
1777:
1778: --

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

1771:
1772:
1773: gdf_rec1 jg_globe_flex_val_shared.GdfRec; /* New Record Variable */
1774: gdf_rec2 jg_globe_flex_val_shared.GdfRec; /* New Record Variable */
1775: gdf_rec3 jg_globe_flex_val_shared.GdfRec; /* New Record Variable */
1776: gdf_general_rec jg_globe_flex_val_shared.GenRec; /* New Record Variable */
1777:
1778: --
1779: -- End of modification

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

1772:
1773: gdf_rec1 jg_globe_flex_val_shared.GdfRec; /* New Record Variable */
1774: gdf_rec2 jg_globe_flex_val_shared.GdfRec; /* New Record Variable */
1775: gdf_rec3 jg_globe_flex_val_shared.GdfRec; /* New Record Variable */
1776: gdf_general_rec jg_globe_flex_val_shared.GenRec; /* New Record Variable */
1777:
1778: --
1779: -- End of modification
1780: --

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

2000:
2001: EXCEPTION
2002: WHEN NO_DATA_FOUND THEN
2003: IF PG_DEBUG in ('Y', 'C') THEN
2004: arp_standard.debug('Not calling JG_GLOBE_FLEX_VAL_PKG.CHECK_ATTR_VALUE');
2005: arp_standard.debug('check_attr_value: ' || 'Global Descr Flex Field Validation end: '
2006: || to_char(sysdate, 'DD-MON-RR HH:MI:SS'));
2007: END IF;
2008: WHEN OTHERS THEN

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

2006: || to_char(sysdate, 'DD-MON-RR HH:MI:SS'));
2007: END IF;
2008: WHEN OTHERS THEN
2009: IF PG_DEBUG in ('Y', 'C') THEN
2010: arp_standard.debug('check_attr_value: ' || 'Exception calling JG_GLOBE_FLEX_VAL.ar_cust_interface');
2011: arp_standard.debug('check_attr_value: ' || SQLERRM);
2012: arp_standard.debug('check_attr_value: ' || 'Global Descr Flex Field Validation end: '
2013: || to_char(sysdate, 'DD-MON-RR HH:MI:SS'));
2014: END IF;

Line 2028: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,

2024: -- Modified version of check_attr_value_ar
2025: --
2026: PROCEDURE check_attr_value_ar
2027: (p_int_table_name IN VARCHAR2,
2028: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
2029: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
2030: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
2031: p_glob_attr_general IN jg_globe_flex_val_shared.GenRec,
2032: p_current_record_status OUT NOCOPY VARCHAR2

Line 2029: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,

2025: --
2026: PROCEDURE check_attr_value_ar
2027: (p_int_table_name IN VARCHAR2,
2028: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
2029: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
2030: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
2031: p_glob_attr_general IN jg_globe_flex_val_shared.GenRec,
2032: p_current_record_status OUT NOCOPY VARCHAR2
2033: ) IS

Line 2030: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,

2026: PROCEDURE check_attr_value_ar
2027: (p_int_table_name IN VARCHAR2,
2028: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
2029: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
2030: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
2031: p_glob_attr_general IN jg_globe_flex_val_shared.GenRec,
2032: p_current_record_status OUT NOCOPY VARCHAR2
2033: ) IS
2034:

Line 2031: p_glob_attr_general IN jg_globe_flex_val_shared.GenRec,

2027: (p_int_table_name IN VARCHAR2,
2028: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
2029: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
2030: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
2031: p_glob_attr_general IN jg_globe_flex_val_shared.GenRec,
2032: p_current_record_status OUT NOCOPY VARCHAR2
2033: ) IS
2034:
2035: l_current_record_status1 VARCHAR2(1);

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

2043:
2044: --arp_standard.enable_debug;
2045: -------------------------- DEBUG INFORMATION ---------------------------------
2046: IF PG_DEBUG in ('Y', 'C') THEN
2047: arp_standard.debug('Begin check_attr_value_ar procedure in JG_GLOBE_FLEX_VAL p
2048: ackage');
2049: END IF;
2050: ------------------------------------------------------------------------------
2051:

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

2104:
2105: EXCEPTION
2106: WHEN OTHERS THEN
2107: IF PG_DEBUG in ('Y', 'C') THEN
2108: arp_standard.debug('Exception calling JG_GLOBE_FLEX_VAL.CHECK_ATTR_VALUE_
2109: AR()');
2110: arp_standard.debug('check_attr_value: ' || SQLERRM);
2111: END IF;
2112: END check_attr_value_ar;

Line 2126: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,

2122: -- Modified version of ar_context_integrity
2123: --
2124: PROCEDURE check_ar_context_integrity(
2125: p_int_table_name IN VARCHAR2,
2126: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
2127: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
2128: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
2129: p_glob_attr_general IN jg_globe_flex_val_shared.GenRec,
2130: p_current_record_status OUT NOCOPY VARCHAR2) IS

Line 2127: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,

2123: --
2124: PROCEDURE check_ar_context_integrity(
2125: p_int_table_name IN VARCHAR2,
2126: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
2127: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
2128: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
2129: p_glob_attr_general IN jg_globe_flex_val_shared.GenRec,
2130: p_current_record_status OUT NOCOPY VARCHAR2) IS
2131:

Line 2128: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,

2124: PROCEDURE check_ar_context_integrity(
2125: p_int_table_name IN VARCHAR2,
2126: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
2127: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
2128: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
2129: p_glob_attr_general IN jg_globe_flex_val_shared.GenRec,
2130: p_current_record_status OUT NOCOPY VARCHAR2) IS
2131:
2132: l_errcode1 varchar2(10) DEFAULT NULL;

Line 2129: p_glob_attr_general IN jg_globe_flex_val_shared.GenRec,

2125: p_int_table_name IN VARCHAR2,
2126: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
2127: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
2128: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
2129: p_glob_attr_general IN jg_globe_flex_val_shared.GenRec,
2130: p_current_record_status OUT NOCOPY VARCHAR2) IS
2131:
2132: l_errcode1 varchar2(10) DEFAULT NULL;
2133: l_errcode varchar2(50) DEFAULT NULL;

Line 2200: JG_GLOBE_FLEX_VAL_SHARED.UPDATE_RA_CUSTOMERS_INTERFACE(

2196: IF l_errcode IS NOT NULL THEN
2197: --
2198: -- Update STATUS column of the customer interface table
2199: --
2200: JG_GLOBE_FLEX_VAL_SHARED.UPDATE_RA_CUSTOMERS_INTERFACE(
2201: l_errcode,
2202: p_glob_attr_general.core_prod_arg2,
2203: 'E');
2204: END IF;

Line 2238: JG_GLOBE_FLEX_VAL_SHARED.UPDATE_INTERFACE_STATUS(

2234:
2235: --
2236: -- Update STATUS column of the profile interface table
2237: --
2238: JG_GLOBE_FLEX_VAL_SHARED.UPDATE_INTERFACE_STATUS(
2239: p_glob_attr_general.core_prod_arg2,
2240: 'RA_CUSTOMER_PROFILES_INTERFACE',
2241: l_errcode,
2242: 'E');

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

2254:
2255: EXCEPTION
2256: WHEN OTHERS THEN
2257: IF PG_DEBUG in ('Y', 'C') THEN
2258: arp_standard.debug('check_ar_context_integrity: ' || 'Exception calling JG_GLOBE_FLEX_VAL.CHECK_AR_CONTEXT
2259: _INTEGRITY()');
2260: arp_standard.debug('check_ar_context_integrity: ' || SQLERRM);
2261: END IF;
2262:

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

2379:
2380: EXCEPTION
2381: WHEN OTHERS THEN
2382: IF PG_DEBUG in ('Y', 'C') THEN
2383: arp_standard.debug('Exception in JG_GLOBE_FLEX_VAL.CHECK_AR_BUSINESS_RULES()');
2384: arp_standard.debug('check_ar_business_rules: ' || SQLERRM);
2385: END IF;
2386: END check_ar_business_rules;
2387: */

Line 2394: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,

2390: -- Modified version of check_ar_business_rules
2391: --
2392: PROCEDURE check_ar_business_rules(
2393: p_int_table_name IN VARCHAR2,
2394: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
2395: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
2396: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
2397: p_glob_attr_general IN jg_globe_flex_val_shared.GenRec,
2398: p_current_record_status OUT NOCOPY VARCHAR2,

Line 2395: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,

2391: --
2392: PROCEDURE check_ar_business_rules(
2393: p_int_table_name IN VARCHAR2,
2394: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
2395: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
2396: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
2397: p_glob_attr_general IN jg_globe_flex_val_shared.GenRec,
2398: p_current_record_status OUT NOCOPY VARCHAR2,
2399: p_org_id IN NUMBER ) IS --2354736

Line 2396: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,

2392: PROCEDURE check_ar_business_rules(
2393: p_int_table_name IN VARCHAR2,
2394: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
2395: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
2396: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
2397: p_glob_attr_general IN jg_globe_flex_val_shared.GenRec,
2398: p_current_record_status OUT NOCOPY VARCHAR2,
2399: p_org_id IN NUMBER ) IS --2354736
2400:

Line 2397: p_glob_attr_general IN jg_globe_flex_val_shared.GenRec,

2393: p_int_table_name IN VARCHAR2,
2394: p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
2395: p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
2396: p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
2397: p_glob_attr_general IN jg_globe_flex_val_shared.GenRec,
2398: p_current_record_status OUT NOCOPY VARCHAR2,
2399: p_org_id IN NUMBER ) IS --2354736
2400:
2401:

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

2466:
2467: EXCEPTION
2468: WHEN OTHERS THEN
2469: IF PG_DEBUG in ('Y', 'C') THEN
2470: arp_standard.debug('Exception in JG_GLOBE_FLEX_VAL.CHECK_AR_BUSINESS_RULES()');
2471: arp_standard.debug('check_ar_business_rules: ' || SQLERRM);
2472: END IF;
2473: END check_ar_business_rules;
2474:

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

2521: -- PG_DEBUG := NVL(FND_PROFILE.value('AR_ENABLE_DEBUG_OUTPUT'), 'N');
2522: -- l_debug_loc := 'Insert_Jg_Zz_Invoice_Info';
2523: --
2524: -- -------------------------- DEBUG INFORMATION ------------------------------
2525: -- l_curr_calling_sequence := 'jg_globe_flex_val.'||l_debug_loc||'<-'||p_calling_sequence;
2526: -- l_debug_info := 'Insert invoices to jg_zz_invice_info';
2527: -- ---------------------------------------------------------------------------
2528: -- IF p_global_attribute_category IN ('BE.EFT Payments','CH.Swiss DTA Payment','CH.Swiss SAD Payment',
2529: -- 'DK','DK.GiroBank Domestic','DK.GiroBank Foreign',

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

2657: NULL;
2658: END IF;
2659: EXCEPTION
2660: WHEN OTHERS THEN
2661: arp_standard.debug('Exception calling JG_GLOBE_FLEX_VAL.insert_global_tabl
2662: es');
2663: arp_standard.debug(SQLERRM);
2664: app_exception.raise_exception;
2665: END;

Line 2759: END jg_globe_flex_val;

2755: Return FALSE;
2756: End Gdf_Context_Exists;
2757:
2758: -- Bug 8859419 End
2759: END jg_globe_flex_val;