DBA Data[Home] [Help]

APPS.ICX_REQ_ACCT_DIST dependencies on ICX_UTIL

Line 49: icx_util.add_error(substr(SQLERRM, 12, 512));

45:
46: EXCEPTION
47: WHEN OTHERS THEN
48: -- htp.p('Error in display acct distributions ' || substr(SQLERRM, 1, 512));
49: icx_util.add_error(substr(SQLERRM, 12, 512));
50:
51: END get_default_account;
52:
53: ------------------------------------------------------

Line 98: v_prompts icx_util.g_prompts_table;

94:
95: v_cart_line_id NUMBER := NULL;
96: v_cart_id NUMBER := NULL;
97: v_title VARCHAR2(80) := NULL;
98: v_prompts icx_util.g_prompts_table;
99: v_encrypted_where NUMBER := NULL;
100: v_where_clause VARCHAR2(1000) := NULL;
101: v_web_user_id NUMBER := NULL;
102: v_responsibility_id NUMBER := NULL;

Line 117: l_values icx_util.char240_table;

113: v_total_lines_entered NUMBER := 5;
114: v_display_lines NUMBER := NULL;
115: v_value varchar2(240) := NULL;
116:
117: l_values icx_util.char240_table;
118: l_pos NUMBER := 0 ;
119:
120:
121: -- the following variable hold the charge account values

Line 180: v_multirow_color := icx_util.get_color('TABLE_DATA_MULTIROW');

176: -- Initialise header and line regions
177: v_distribution_header_region := 'ICX_CART_LINE_ACCOUNT_HEADER_R';
178: v_distribution_lines_region := 'ICX_CART_LINE_DISTRIBUTIONS_R';
179:
180: v_multirow_color := icx_util.get_color('TABLE_DATA_MULTIROW');
181:
182: icx_util.getPrompts(601, v_distribution_header_region, v_title, v_prompts);
183: icx_util.error_page_setup;
184:

Line 182: icx_util.getPrompts(601, v_distribution_header_region, v_title, v_prompts);

178: v_distribution_lines_region := 'ICX_CART_LINE_DISTRIBUTIONS_R';
179:
180: v_multirow_color := icx_util.get_color('TABLE_DATA_MULTIROW');
181:
182: icx_util.getPrompts(601, v_distribution_header_region, v_title, v_prompts);
183: icx_util.error_page_setup;
184:
185: -- v_encrypted_where := p_where;
186:

Line 183: icx_util.error_page_setup;

179:
180: v_multirow_color := icx_util.get_color('TABLE_DATA_MULTIROW');
181:
182: icx_util.getPrompts(601, v_distribution_header_region, v_title, v_prompts);
183: icx_util.error_page_setup;
184:
185: -- v_encrypted_where := p_where;
186:
187: v_where_clause := 'CART_ID =' || v_cart_id || 'AND CART_LINE_ID =' || v_cart_line_id;

Line 191: icx_util.copyright;

187: v_where_clause := 'CART_ID =' || v_cart_id || 'AND CART_LINE_ID =' || v_cart_line_id;
188:
189: htp.htmlOpen;
190: htp.headOpen;
191: icx_util.copyright;
192: js.scriptOpen;
193:
194: htp.p('function submit() {
195: // document.ACCOUNT_DISTRIBUTION.cart_id.value = parent.parent.cartId;

Line 221: var msg = input.value + " '||icx_util.replace_quotes(fnd_message.get)||'";

217: }');
218:
219: fnd_message.set_name('ICX','ICX_NOT_NUMBER');
220: htp.p('function checkNumber(input) {
221: var msg = input.value + " '||icx_util.replace_quotes(fnd_message.get)||'";
222:
223: var str = input.value;
224: for (var i = 0; i < str.length; i++) {
225: var ch = str.substring(i, i + 1);

Line 821: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(r),l_values);

817:
818: IF v_rows_returned > 0 THEN
819: FOR r IN 0..ak_query_pkg.g_results_table.LAST LOOP
820:
821: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(r),l_values);
822:
823: htp.p('');
824:
825: FOR i IN 0..ak_query_pkg.g_items_table.LAST LOOP

Line 1122: icx_util.add_error(substr(SQLERRM, 12, 512));

1118:
1119: EXCEPTION
1120: WHEN OTHERS THEN
1121: -- htp.p('Error in display acct distributions ' || substr(SQLERRM, 1, 512));
1122: icx_util.add_error(substr(SQLERRM, 12, 512));
1123: icx_util.error_page_print;
1124:
1125: END display_acct_distributions;
1126:

Line 1123: icx_util.error_page_print;

1119: EXCEPTION
1120: WHEN OTHERS THEN
1121: -- htp.p('Error in display acct distributions ' || substr(SQLERRM, 1, 512));
1122: icx_util.add_error(substr(SQLERRM, 12, 512));
1123: icx_util.error_page_print;
1124:
1125: END display_acct_distributions;
1126:
1127:

Line 1131: y_table icx_util.char240_table;

1127:
1128: ------------------------------------------------------
1129: PROCEDURE display_account_header (v_extended_price OUT NUMBER) IS
1130:
1131: y_table icx_util.char240_table;
1132:
1133: v_shopper_id NUMBER := NULL;
1134: v_shopper_name VARCHAR2(250) := NULL;
1135: v_location_id NUMBER := NULL;

Line 1155: icx_util.transfer_Row_To_Column( ak_query_pkg.g_results_table(ak_query_pkg.g_results_table.FIRST),y_table);

1151: v_money_fmt_mask := fnd_currency.safe_get_format_mask(v_currency, 30);
1152:
1153: htp.tableOpen('BORDER=0');
1154:
1155: icx_util.transfer_Row_To_Column( ak_query_pkg.g_results_table(ak_query_pkg.g_results_table.FIRST),y_table);
1156:
1157: FOR i IN ak_query_pkg.g_items_table.FIRST .. ak_query_pkg.g_items_table.LAST LOOP
1158:
1159: IF ak_query_pkg.g_items_table(i).node_display_flag = 'Y'

Line 1213: icx_util.add_error(substr(SQLERRM, 12, 512));

1209:
1210: EXCEPTION
1211: WHEN OTHERS THEN
1212: -- htp.p('Error in display acct header ' || substr(SQLERRM, 1, 512));
1213: icx_util.add_error(substr(SQLERRM, 12, 512));
1214: icx_util.error_page_print;
1215:
1216: END display_account_header;
1217:

Line 1214: icx_util.error_page_print;

1210: EXCEPTION
1211: WHEN OTHERS THEN
1212: -- htp.p('Error in display acct header ' || substr(SQLERRM, 1, 512));
1213: icx_util.add_error(substr(SQLERRM, 12, 512));
1214: icx_util.error_page_print;
1215:
1216: END display_account_header;
1217:
1218:

Line 1252: icx_util.add_error(substr(SQLERRM, 12, 512));

1248:
1249: EXCEPTION
1250: WHEN OTHERS THEN
1251: -- htp.p('Error in print lines header ' || substr(SQLERRM, 1, 512));
1252: icx_util.add_error(substr(SQLERRM, 12, 512));
1253: icx_util.error_page_print;
1254:
1255: END print_lines_header;
1256:

Line 1253: icx_util.error_page_print;

1249: EXCEPTION
1250: WHEN OTHERS THEN
1251: -- htp.p('Error in print lines header ' || substr(SQLERRM, 1, 512));
1252: icx_util.add_error(substr(SQLERRM, 12, 512));
1253: icx_util.error_page_print;
1254:
1255: END print_lines_header;
1256:
1257:

Line 1282: icx_util.DynamicButton(P_ButtonText => v_order_button_text,

1278: -- Show more lines button
1279: htp.p('');
1280: FND_MESSAGE.SET_NAME('ICX','ICX_SHOW_MORE_LINES');
1281: v_order_button_text := FND_MESSAGE.GET;
1282: icx_util.DynamicButton(P_ButtonText => v_order_button_text,
1283: P_ImageFileName => 'FNDBSBMT.gif',
1284: P_OnMouseOverText => v_order_button_text,
1285: P_HyperTextCall => 'javascript:parent.frames[0].show_more_lines()',
1286: P_LanguageCode => v_language_code,

Line 1294: icx_util.DynamicButton(P_ButtonText => v_order_button_text,

1290: -- Apply to all lines
1291: htp.p('');
1292: FND_MESSAGE.SET_NAME('ICX','ICX_APPLY_TO_ALL_LINES');
1293: v_order_button_text := FND_MESSAGE.GET;
1294: icx_util.DynamicButton(P_ButtonText => v_order_button_text,
1295: P_ImageFileName => 'FNDBSBMT.gif',
1296: P_OnMouseOverText => v_order_button_text,
1297: -- P_HyperTextCall => 'javascript:submit()',
1298: P_HyperTextCall => 'javascript:parent.frames[0].apply_to_all()',

Line 1307: icx_util.DynamicButton(P_ButtonText => v_order_button_text,

1303: -- Cancel button
1304: htp.p('');
1305: FND_MESSAGE.SET_NAME('ICX','ICX_CANCEL');
1306: v_order_button_text := FND_MESSAGE.GET;
1307: icx_util.DynamicButton(P_ButtonText => v_order_button_text,
1308: P_ImageFileName => 'FNDBCNCL.gif',
1309: P_OnMouseOverText => v_order_button_text,
1310: -- P_HyperTextCall => 'javascript:cancel_account()',
1311: P_HyperTextCall => 'javascript:parent.frames[0].cancel_account()',

Line 1320: icx_util.DynamicButton(P_ButtonText => v_order_button_text,

1316: -- Apply button
1317: htp.p('');
1318: FND_MESSAGE.SET_NAME('ICX','ICX_APPLY_CHANGES');
1319: v_order_button_text := FND_MESSAGE.GET;
1320: icx_util.DynamicButton(P_ButtonText => v_order_button_text,
1321: P_ImageFileName => 'FNDBAPLY.gif',
1322: P_OnMouseOverText => v_order_button_text,
1323: P_HyperTextCall => 'javascript:parent.frames[0].submit()',
1324: P_LanguageCode => v_language_code,

Line 1340: icx_util.add_error(substr(SQLERRM, 12, 512));

1336:
1337: EXCEPTION
1338: WHEN OTHERS THEN
1339: -- htp.p('Error in print action buttons ' || substr(SQLERRM, 1, 512));
1340: icx_util.add_error(substr(SQLERRM, 12, 512));
1341: icx_util.error_page_print;
1342:
1343: END print_action_buttons;
1344:

Line 1341: icx_util.error_page_print;

1337: EXCEPTION
1338: WHEN OTHERS THEN
1339: -- htp.p('Error in print action buttons ' || substr(SQLERRM, 1, 512));
1340: icx_util.add_error(substr(SQLERRM, 12, 512));
1341: icx_util.error_page_print;
1342:
1343: END print_action_buttons;
1344:
1345: ------------------------------------------------------

Line 1663: icx_util.add_error(substr(SQLERRM, 12, 512));

1659:
1660: EXCEPTION
1661: WHEN OTHERS THEN
1662: -- htp.p('Error in submit_accounts ' || substr(SQLERRM, 1, 512));
1663: icx_util.add_error(substr(SQLERRM, 12, 512));
1664: icx_util.error_page_print;
1665:
1666: END submit_accounts;
1667:

Line 1664: icx_util.error_page_print;

1660: EXCEPTION
1661: WHEN OTHERS THEN
1662: -- htp.p('Error in submit_accounts ' || substr(SQLERRM, 1, 512));
1663: icx_util.add_error(substr(SQLERRM, 12, 512));
1664: icx_util.error_page_print;
1665:
1666: END submit_accounts;
1667:
1668:

Line 1930: icx_util.add_error(substr(SQLERRM, 12, 512));

1926:
1927: EXCEPTION
1928: WHEN OTHERS THEN
1929: -- htp.p('Error in apply_account_distributions ' || substr(SQLERRM, 1, 512));
1930: icx_util.add_error(substr(SQLERRM, 12, 512));
1931: icx_util.error_page_print;
1932:
1933: END apply_account_distributions;
1934:

Line 1931: icx_util.error_page_print;

1927: EXCEPTION
1928: WHEN OTHERS THEN
1929: -- htp.p('Error in apply_account_distributions ' || substr(SQLERRM, 1, 512));
1930: icx_util.add_error(substr(SQLERRM, 12, 512));
1931: icx_util.error_page_print;
1932:
1933: END apply_account_distributions;
1934:
1935:

Line 1955: l_values icx_util.char240_table;

1951: v_concatenated_segment VARCHAR2(2) := NULL;
1952:
1953: v_distribution_lines_region VARCHAR2(50) := NULL;
1954:
1955: l_values icx_util.char240_table;
1956: v_segment_value fnd_flex_ext.SegmentArray;
1957: v_line_segments fnd_flex_ext.SegmentArray;
1958:
1959: CURSOR get_ak_attributes IS

Line 2078: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(r),l_values);

2074: IF ak_query_pkg.g_results_table.COUNT > 0 THEN
2075: l := 1;
2076: FOR r IN 0..ak_query_pkg.g_results_table.LAST LOOP
2077:
2078: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(r),l_values);
2079:
2080: FOR i IN ak_query_pkg.g_items_table.FIRST .. ak_query_pkg.g_items_table.LAST LOOP
2081:
2082: IF ak_query_pkg.g_items_table(i).node_display_flag = 'Y'

Line 2192: icx_util.add_error(substr(SQLERRM, 12, 512));

2188:
2189: EXCEPTION
2190: WHEN OTHERS THEN
2191: -- htp.p('Error in apply_to_all' || substr(SQLERRM, 1, 512));
2192: icx_util.add_error(substr(SQLERRM, 12, 512));
2193: icx_util.error_page_print;
2194:
2195: END apply_to_all;
2196:

Line 2193: icx_util.error_page_print;

2189: EXCEPTION
2190: WHEN OTHERS THEN
2191: -- htp.p('Error in apply_to_all' || substr(SQLERRM, 1, 512));
2192: icx_util.add_error(substr(SQLERRM, 12, 512));
2193: icx_util.error_page_print;
2194:
2195: END apply_to_all;
2196:
2197: ------------------------------------------------------

Line 2228: icx_util.add_error(substr(SQLERRM, 12, 512));

2224:
2225: EXCEPTION
2226: WHEN OTHERS THEN
2227: -- htp.p('Error in display_account_errors' || substr(SQLERRM, 1, 512));
2228: icx_util.add_error(substr(SQLERRM, 12, 512));
2229: icx_util.error_page_print;
2230:
2231: END display_account_errors;
2232:

Line 2229: icx_util.error_page_print;

2225: EXCEPTION
2226: WHEN OTHERS THEN
2227: -- htp.p('Error in display_account_errors' || substr(SQLERRM, 1, 512));
2228: icx_util.add_error(substr(SQLERRM, 12, 512));
2229: icx_util.error_page_print;
2230:
2231: END display_account_errors;
2232:
2233: END icx_req_acct_dist;