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.ARP_ARXCOBL_MLS_PACKAGE dependencies on STANDARD

Line 51: arp_standard.debug('ARP_ARXCOBL_MLS_FUNCTION');

47: select substr(userenv('LANG'),1,4)
48: into p_userenv_lang
49: from dual;
50:
51: arp_standard.debug('ARP_ARXCOBL_MLS_FUNCTION');
52:
53: arp_standard.debug('P_USERENV_LANG = ' || p_userenv_lang);
54:
55: /* Read in Parameter Values supplied by user */

Line 53: arp_standard.debug('P_USERENV_LANG = ' || p_userenv_lang);

49: from dual;
50:
51: arp_standard.debug('ARP_ARXCOBL_MLS_FUNCTION');
52:
53: arp_standard.debug('P_USERENV_LANG = ' || p_userenv_lang);
54:
55: /* Read in Parameter Values supplied by user */
56:
57: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Customer Name From',parm_number);

Line 64: arp_standard.debug('P_CUSTOMER_NAME_FROM ='||P_CUSTOMER_NAME_FROM);

60: else
61: P_CUSTOMER_NAME_FROM := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
62:
63: end if;
64: arp_standard.debug('P_CUSTOMER_NAME_FROM ='||P_CUSTOMER_NAME_FROM);
65:
66: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Customer Name To',parm_number);
67: if retval = -1 then
68: P_CUSTOMER_NAME_TO := NULL;

Line 72: arp_standard.debug('P_CUSTOMER_NAME_TO ='|| P_CUSTOMER_NAME_TO);

68: P_CUSTOMER_NAME_TO := NULL;
69: else
70: P_CUSTOMER_NAME_TO := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
71: end if;
72: arp_standard.debug('P_CUSTOMER_NAME_TO ='|| P_CUSTOMER_NAME_TO);
73:
74: arp_standard.debug('Will call BUILD_WHERE_CLAUSE');
75: p_table1:='hz_cust_accounts cust_acct,';
76: p_table1:=p_table1||'hz_cust_acct_sites acct_site,';

Line 74: arp_standard.debug('Will call BUILD_WHERE_CLAUSE');

70: P_CUSTOMER_NAME_TO := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
71: end if;
72: arp_standard.debug('P_CUSTOMER_NAME_TO ='|| P_CUSTOMER_NAME_TO);
73:
74: arp_standard.debug('Will call BUILD_WHERE_CLAUSE');
75: p_table1:='hz_cust_accounts cust_acct,';
76: p_table1:=p_table1||'hz_cust_acct_sites acct_site,';
77: p_table1:=p_table1||'hz_cust_site_uses site_uses,';
78: p_table1:=p_table1||'hz_locations loc,';

Line 109: arp_standard.debug('done with BUILD_WHERE_CLAUSE');

105: end if;
106:
107: end if;
108:
109: arp_standard.debug('done with BUILD_WHERE_CLAUSE');
110:
111: /* bug1946875: This cursor is not used. customer condition has already been included in select_sql1. */
112: ---Customer Loop . For every customer the loop finds out the languages for corresponding Bill To addresses.
113:

Line 123: arp_standard.debug('raxinv.select_sql1 = ' || cr ||

119: 'from ' || p_table1 || cr ||
120: 'where ' || cr || p_where2;
121: --dbms_output.put_line('select is'||select_sql1);
122:
123: arp_standard.debug('raxinv.select_sql1 = ' || cr ||
124: select_sql1 || cr );
125:
126:
127: ------------------------------------------------

Line 132: arp_standard.debug( ' Parsing select_sql1 stmt');

128: -- Parse sql stmts
129: ------------------------------------------------
130:
131: BEGIN
132: arp_standard.debug( ' Parsing select_sql1 stmt');
133: select_sql1_c := dbms_sql.open_cursor;
134: dbms_sql.parse( select_sql1_c, select_sql1, dbms_sql.v7 );
135: -- DBMS_SQL.BIND_VARIABLE(select_sql1_c,':l_customer_id',Customer.customer_id);
136: EXCEPTION

Line 138: arp_standard.debug( 'EXCEPTION: Error parsing select_sql1 stmt' );

134: dbms_sql.parse( select_sql1_c, select_sql1, dbms_sql.v7 );
135: -- DBMS_SQL.BIND_VARIABLE(select_sql1_c,':l_customer_id',Customer.customer_id);
136: EXCEPTION
137: WHEN OTHERS THEN
138: arp_standard.debug( 'EXCEPTION: Error parsing select_sql1 stmt' );
139: RAISE;
140: END;
141:
142:

Line 143: arp_standard.debug( 'Completed parsing select stmts' );

139: RAISE;
140: END;
141:
142:
143: arp_standard.debug( 'Completed parsing select stmts' );
144:
145: arp_standard.debug( 'define_columns for select_sql1_c');
146: dbms_sql.define_column( select_sql1_c, 1, select_rec1.language, 4);
147: -- Bug 5173488: use bind variable instead of hard code literal in where clause.

Line 145: arp_standard.debug( 'define_columns for select_sql1_c');

141:
142:
143: arp_standard.debug( 'Completed parsing select stmts' );
144:
145: arp_standard.debug( 'define_columns for select_sql1_c');
146: dbms_sql.define_column( select_sql1_c, 1, select_rec1.language, 4);
147: -- Bug 5173488: use bind variable instead of hard code literal in where clause.
148: if p_customer_name_from is not null then
149: dbms_sql.bind_variable(select_sql1_c, ':p_customer_name_from', p_customer_name_from);

Line 156: arp_standard.debug( ' Executing select_sql1' );

152: dbms_sql.bind_variable(select_sql1_c, ':p_customer_name_to', p_customer_name_to);
153: end if;
154:
155:
156: arp_standard.debug( ' Executing select_sql1' );
157: BEGIN
158: l_ignore := dbms_sql.execute( select_sql1_c );
159:
160: EXCEPTION

Line 162: arp_standard.debug( 'EXCEPTION: Error executing select_sql1' );

158: l_ignore := dbms_sql.execute( select_sql1_c );
159:
160: EXCEPTION
161: WHEN OTHERS THEN
162: arp_standard.debug( 'EXCEPTION: Error executing select_sql1' );
163: RAISE;
164: END;
165:
166:

Line 170: arp_standard.debug( ' Fetching select_sql1 stmt');

166:
167: --------------------------------------------------------------
168: -- Fetch rows
169: --------------------------------------------------------------
170: arp_standard.debug( ' Fetching select_sql1 stmt');
171:
172: begin
173: loop
174: if (dbms_sql.fetch_rows( select_sql1_c ) > 0)

Line 177: arp_standard.debug(' fetched a row' );

173: loop
174: if (dbms_sql.fetch_rows( select_sql1_c ) > 0)
175: then
176:
177: arp_standard.debug(' fetched a row' );
178: select_rec1 := null_rec;
179: ------------------------------------------------------
180: -- Get column values
181: ------------------------------------------------------

Line 183: arp_standard.debug( 'Language code: ' || select_rec1.language );

179: ------------------------------------------------------
180: -- Get column values
181: ------------------------------------------------------
182: dbms_sql.column_value( select_sql1_c, 1, select_rec1.language );
183: arp_standard.debug( 'Language code: ' || select_rec1.language );
184:
185: if (lang_str is null) then
186: lang_str := select_rec1.language;
187: else

Line 192: arp_standard.debug('Done fetching select_sql1');

188: lang_str := lang_str || ',' || select_rec1.language;
189: end if;
190:
191: else
192: arp_standard.debug('Done fetching select_sql1');
193: EXIT;
194: end if;
195: end loop;
196: end;