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: ------------------------------------------------------
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;
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
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:
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:
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;
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;
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);
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('
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:
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:
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;
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'
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:
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:
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:
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:
1278: -- Show more lines button
1279: htp.p('
1290: -- Apply to all lines
1291: htp.p('
1303: -- Cancel button
1304: htp.p('
1316: -- Apply button
1317: htp.p('
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:
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: ------------------------------------------------------
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:
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:
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:
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:
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
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'
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:
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: ------------------------------------------------------
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:
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;