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_SHARED dependencies on RA_CUSTOMERS_INTERFACE

Line 76: -- UPDATE_RA_CUSTOMERS_INTERFACE():

72:
73: END Insert_rejections;
74:
75: ---------------------------------------------------------------------------
76: -- UPDATE_RA_CUSTOMERS_INTERFACE():
77: --
78: -- Update Interface_status column with error or warning code
79: -- in RA_CUSTOMERS_INTERFACE View.
80: ---------------------------------------------------------------------------

Line 79: -- in RA_CUSTOMERS_INTERFACE View.

75: ---------------------------------------------------------------------------
76: -- UPDATE_RA_CUSTOMERS_INTERFACE():
77: --
78: -- Update Interface_status column with error or warning code
79: -- in RA_CUSTOMERS_INTERFACE View.
80: ---------------------------------------------------------------------------
81: PROCEDURE update_ra_customers_interface(
82: p_code IN VARCHAR2,
83: p_row_id IN VARCHAR2,

Line 81: PROCEDURE update_ra_customers_interface(

77: --
78: -- Update Interface_status column with error or warning code
79: -- in RA_CUSTOMERS_INTERFACE View.
80: ---------------------------------------------------------------------------
81: PROCEDURE update_ra_customers_interface(
82: p_code IN VARCHAR2,
83: p_row_id IN VARCHAR2,
84: p_current_status IN VARCHAR2) IS
85:

Line 88: UPDATE ra_customers_interface

84: p_current_status IN VARCHAR2) IS
85:
86: BEGIN
87: IF p_current_status = 'E' THEN
88: UPDATE ra_customers_interface
89: SET interface_status = interface_status||p_code
90: WHERE ROWID = p_row_id;
91: ELSIF p_current_status = 'W' THEN
92: UPDATE ra_customers_interface

Line 92: UPDATE ra_customers_interface

88: UPDATE ra_customers_interface
89: SET interface_status = interface_status||p_code
90: WHERE ROWID = p_row_id;
91: ELSIF p_current_status = 'W' THEN
92: UPDATE ra_customers_interface
93: SET warning_text = warning_text||p_code
94: WHERE rowid = p_row_id;
95: END IF;
96: EXCEPTION

Line 98: arp_standard.debug('No data found in RA_CUSTOMERS_INTERFACE View');

94: WHERE rowid = p_row_id;
95: END IF;
96: EXCEPTION
97: WHEN NO_DATA_FOUND THEN
98: arp_standard.debug('No data found in RA_CUSTOMERS_INTERFACE View');
99: WHEN OTHERS THEN
100: arp_standard.debug('Exception in JG_GLOBE_FLEX_VAL1.UPDATE_RA_CUSTOMERS_INTERFACE()');
101: arp_standard.debug(SQLERRM);
102: END update_ra_customers_interface;

Line 100: arp_standard.debug('Exception in JG_GLOBE_FLEX_VAL1.UPDATE_RA_CUSTOMERS_INTERFACE()');

96: EXCEPTION
97: WHEN NO_DATA_FOUND THEN
98: arp_standard.debug('No data found in RA_CUSTOMERS_INTERFACE View');
99: WHEN OTHERS THEN
100: arp_standard.debug('Exception in JG_GLOBE_FLEX_VAL1.UPDATE_RA_CUSTOMERS_INTERFACE()');
101: arp_standard.debug(SQLERRM);
102: END update_ra_customers_interface;
103:
104: ---------------------------------------------------------------------------

Line 102: END update_ra_customers_interface;

98: arp_standard.debug('No data found in RA_CUSTOMERS_INTERFACE View');
99: WHEN OTHERS THEN
100: arp_standard.debug('Exception in JG_GLOBE_FLEX_VAL1.UPDATE_RA_CUSTOMERS_INTERFACE()');
101: arp_standard.debug(SQLERRM);
102: END update_ra_customers_interface;
103:
104: ---------------------------------------------------------------------------
105: -- UPDATE_INTERFACE_STATUS():
106: --

Line 110: -- instead of update_ra_customers_interface.

106: --
107: -- PURPOSE
108: -- Update Interface Status with a Given Message Code.
109: -- Use this procedure for new validation in 11.5.1 or later
110: -- instead of update_ra_customers_interface.
111: --
112: -- PARAMETERS
113: -- ** Valid Parameter Values for p_table_name **
114: -- 1. ra_customers_interface

Line 114: -- 1. ra_customers_interface

110: -- instead of update_ra_customers_interface.
111: --
112: -- PARAMETERS
113: -- ** Valid Parameter Values for p_table_name **
114: -- 1. ra_customers_interface
115: -- 2. ra_customer_profiles_interface
116: -- 3. ra_contact_phones_interface
117: -- 4. ra_customer_banks_interface
118: -- 5. ra_cust_pay_method_interface

Line 157: l_table_tab(1) := 'RA_CUSTOMERS_INTERFACE';

153: -- Validate Table Name
154: --
155: -- Add "l_table_tab(i) := ;" for new interface tables.
156: --
157: l_table_tab(1) := 'RA_CUSTOMERS_INTERFACE';
158: l_table_tab(2) := 'RA_CUSTOMER_PROFILES_INTERFACE';
159: l_table_tab(3) := 'RA_CONTACT_PHONES_INTERFACE';
160: l_table_tab(4) := 'RA_CUSTOMER_BANKS_INTERFACE';
161: l_table_tab(5) := 'RA_CUST_PAY_METHOD_INTERFACE';
Line 197: IF UPPER(l_table_name) = 'RA_CUSTOMERS_INTERFACE' THEN

193: --
194: -- Build Update Statement for Warnings
195: --
196: ELSIF l_current_status = 'W' THEN
197: IF UPPER(l_table_name) = 'RA_CUSTOMERS_INTERFACE' THEN
198: l_sql_stmt_set := ' SET warning_text = warning_text || :v_code';
199: ELSE
200: RAISE Invalid_Table;
201: END IF;