DBA Data[Home] [Help]

APPS.ICX_REQ_SUBMIT dependencies on ICX_UTIL

Line 32: icx_util.add_error(l_err_mesg);

28: l_err_num := SQLCODE;
29: l_error_message := SQLERRM;
30:
31: select substr(l_error_message,12,512) into l_err_mesg from dual;
32: icx_util.add_error(l_err_mesg);
33: end;
34:
35:
36: ------------------------------------------------------------

Line 61: y_table icx_util.char240_table;

57:
58: shopper_id number;
59:
60: v_where_clause varchar2(240);
61: y_table icx_util.char240_table;
62: l_value varchar2(240);
63: i number := 0;
64: j number := 0;
65: column_number number := 0;

Line 187: icx_util.transfer_Row_To_Column( ak_query_pkg.g_results_table(ak_query_pkg.g_results_table.first), y_table) ;

183:
184: -- Draw cart header.
185: htp.tableOpen( 'border=0' );
186:
187: icx_util.transfer_Row_To_Column( ak_query_pkg.g_results_table(ak_query_pkg.g_results_table.first), y_table) ;
188:
189: /* get org ahead of time */
190: for k in ak_query_pkg.g_items_table.first .. ak_query_pkg.g_items_table.last loop
191: if ak_query_pkg.g_items_table(k).attribute_code = 'ICX_DEST_ORG_ID' then

Line 324: htp.p('');

320:
321: htp.tableOpen('BORDER=5', cattributes=> 'bgcolor="#F8F8F8"');
322:
323: -- PrintHead
324: htp.p('');
325:
326: col_no := 0;
327: for i in 0 .. ak_query_pkg.g_items_table.LAST loop
328: if ak_query_pkg.g_items_table(i).node_display_flag = 'Y'

Line 359: icx_util.transfer_Row_To_Column( ak_query_pkg.g_results_table(j), y_table);

355: -- PrintItems
356: v_order_total := 0;
357: if ak_query_pkg.g_regions_table(0).total_result_count > 0 then
358: for j in 0 .. ak_query_pkg.g_results_table.last loop
359: icx_util.transfer_Row_To_Column( ak_query_pkg.g_results_table(j), y_table);
360:
361: htp.tableRowOpen;
362: for i in 0 .. ak_query_pkg.g_items_table.LAST loop
363: if ak_query_pkg.g_items_table(i).node_display_flag = 'Y'

Line 413: htp.p('' || FND_MESSAGE.GET || ' (' || v_currency || ') ');

409: htp.p('');
410: end loop;
411:
412: FND_MESSAGE.SET_NAME('MRP','EC_TOTAL');
413: htp.p('' || FND_MESSAGE.GET || ' (' || v_currency || ') ');
414: htp.p('' || to_char(to_number(v_order_total),v_money_fmt_mask) || '' );
415:
416: htp.p('');
417:

Line 432: icx_util.DynamicButton(P_ButtonText => FND_MESSAGE.GET,

428: htp.p('');
429: htp.p('');
430: htp.p('');
431: FND_MESSAGE.SET_NAME('FND','YES');
432: icx_util.DynamicButton(P_ButtonText => FND_MESSAGE.GET,
433: P_ImageFileName => 'FNDBNEW.gif',
434: P_OnMouseOverText => FND_MESSAGE.GET,
435: P_HyperTextCall => 'ICX_REQ_NAVIGATION.ic_parent?cart_id=' || icx_call.encrypt2('0') || '&emergency=' || icx_call.encrypt2(p_emergency),
436: P_LanguageCode => v_lang,

Line 442: icx_util.DynamicButton(P_ButtonText => FND_MESSAGE.GET,

438: htp.p('');
439:
440: htp.p('');
441: FND_MESSAGE.SET_NAME('FND','NO');
442: icx_util.DynamicButton(P_ButtonText => FND_MESSAGE.GET,
443: P_ImageFileName => 'FNDBCNCL.gif',
444: P_OnMouseOverText => FND_MESSAGE.GET,
445: P_HyperTextCall => 'OracleApps.DMM',
446: P_LanguageCode => v_lang,

Line 485: icx_util.copyright;

481:
482: htp.htmlOpen;
483: htp.headOpen;
484: icx_admin_sig.toolbar(language_code => v_lang);
485: icx_util.copyright;
486: js.scriptOpen;
487:
488: htp.p('function help_window() {
489: help_win = window.open(''/OA_DOC/' || v_lang || '/awe' || '/icxhlprq.htm'', "help_win","resizable=yes,scrollbars=yes,toolbar=yes,width=450,height=250");

Line 529: icx_util.DynamicButton(P_ButtonText => FND_MESSAGE.GET,

525: htp.p('');
526: htp.p('');
527: htp.p('');
528: FND_MESSAGE.SET_NAME('FND','YES');
529: icx_util.DynamicButton(P_ButtonText => FND_MESSAGE.GET,
530: P_ImageFileName => 'FNDBNEW.gif',
531: P_OnMouseOverText => FND_MESSAGE.GET,
532: P_HyperTextCall => 'ICX_REQ_NAVIGATION.ic_parent?cart_id=' || icx_call.encrypt2('0') || '&emergency=' || icx_call.encrypt2(v_emergency),
533: P_LanguageCode => v_lang,

Line 538: icx_util.DynamicButton(P_ButtonText => FND_MESSAGE.GET,

534: P_JavaScriptFlag => FALSE);
535: htp.p('');
536: htp.p('');
537: FND_MESSAGE.SET_NAME('FND','NO');
538: icx_util.DynamicButton(P_ButtonText => FND_MESSAGE.GET,
539: P_ImageFileName => 'FNDBCNCL.gif',
540: P_OnMouseOverText => FND_MESSAGE.GET,
541: P_HyperTextCall => 'OracleApps.DMM',
542: P_LanguageCode => v_lang,

Line 1027: icx_util.error_page_setup;

1023:
1024:
1025:
1026: -- initialize the error page
1027: icx_util.error_page_setup;
1028:
1029: --get language code
1030: v_lang := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
1031:

Line 1079: icx_util.add_error(v_error_message);

1075: if v_need_date <= (sysdate - 1) then
1076: v_incr := icx_sec.getID(icx_sec.PV_USER_REQ_DAYS_NEEDED_BY);
1077: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_NEED_BY_DATE');
1078: v_error_message := FND_MESSAGE.GET;
1079: icx_util.add_error(v_error_message);
1080: storeerror(v_cart_id, v_error_message);
1081: v_need_date := sysdate + v_incr;
1082: end if;
1083: exception

Line 1089: icx_util.add_error(v_error_message);

1085: --add error
1086: v_incr := icx_sec.getID(icx_sec.PV_USER_REQ_DAYS_NEEDED_BY);
1087: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_DATE');
1088: v_error_message := FND_MESSAGE.GET;
1089: icx_util.add_error(v_error_message);
1090: storeerror(v_cart_id, v_error_message);
1091: v_need_date := sysdate + v_incr;
1092: end;
1093: else

Line 1096: icx_util.add_error(v_error_message);

1092: end;
1093: else
1094: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_DATE');
1095: v_error_message := FND_MESSAGE.GET;
1096: icx_util.add_error(v_error_message);
1097: storeerror(v_cart_id, v_error_message);
1098: v_incr := icx_sec.getID(icx_sec.PV_USER_REQ_DAYS_NEEDED_BY);
1099: v_need_date := sysdate + v_incr;
1100: end if;

Line 1329: icx_util.getPrompt(601, 'ICX_SHOPPING_CART_HEADER_R',

1325: p_deliver_to_org_id;
1326: if get_loc_org_id%NOTFOUND then
1327: -- woops they didn't type it in correctly
1328: v_error_message :=
1329: icx_util.getPrompt(601, 'ICX_SHOPPING_CART_HEADER_R',
1330: 178, 'ICX_DELIVER_TO_LOCATION');
1331: FND_MESSAGE.SET_NAME('ICX','ICX_INVALID_ENTRY');
1332: FND_MESSAGE.SET_TOKEN('INVALID_TOKEN',v_error_message ||
1333: ' : ' || icx_deliver_to_location);

Line 1335: icx_util.add_error(v_error_message);

1331: FND_MESSAGE.SET_NAME('ICX','ICX_INVALID_ENTRY');
1332: FND_MESSAGE.SET_TOKEN('INVALID_TOKEN',v_error_message ||
1333: ' : ' || icx_deliver_to_location);
1334: v_error_message := FND_MESSAGE.GET;
1335: icx_util.add_error(v_error_message);
1336: storeerror(v_cart_id, v_error_message);
1337: p_deliver_to_location_id := d_location_id;
1338: p_deliver_to_org_id := d_org_id;
1339: p_deliver_to_location := d_location_code;

Line 1361: icx_util.getPrompt(601, 'ICX_SHOPPING_CART_HEADER_R',

1357:
1358: end if;
1359: elsif (icx_deliver_to_location is null) then
1360: v_error_message :=
1361: icx_util.getPrompt(601, 'ICX_SHOPPING_CART_HEADER_R',
1362: 178, 'ICX_DELIVER_TO_LOCATION');
1363: FND_MESSAGE.SET_NAME('ICX','ICX_INVALID_ENTRY');
1364: FND_MESSAGE.SET_TOKEN('INVALID_TOKEN',v_error_message ||
1365: ' : ' || icx_deliver_to_location);

Line 1367: icx_util.add_error(v_error_message);

1363: FND_MESSAGE.SET_NAME('ICX','ICX_INVALID_ENTRY');
1364: FND_MESSAGE.SET_TOKEN('INVALID_TOKEN',v_error_message ||
1365: ' : ' || icx_deliver_to_location);
1366: v_error_message := FND_MESSAGE.GET;
1367: icx_util.add_error(v_error_message);
1368: storeerror(v_cart_id, v_error_message);
1369: update icx_shopping_Carts
1370: set DELIVER_TO_LOCATION_ID = null,
1371: DESTINATION_ORGANIZATION_ID = d_org_id,

Line 1394: icx_util.add_error(v_error_message);

1390: fetch requester_check into requesterID;
1391: if requester_check%NOTFOUND then
1392: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_REQUESTER');
1393: v_error_message := FND_MESSAGE.GET;
1394: icx_util.add_error(v_error_message);
1395: storeerror(v_cart_id, v_error_message);
1396: requesterID := null;
1397: p_requester := null;
1398: else

Line 1410: icx_util.add_error(v_error_message);

1406: p_requester := icx_deliver_to_requestor;
1407: else
1408: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_REQUESTER');
1409: v_error_message := FND_MESSAGE.GET;
1410: icx_util.add_error(v_error_message);
1411: storeerror(v_cart_id, v_error_message);
1412: requesterID := -1;
1413: p_requester := null;
1414: end if;

Line 1425: icx_util.add_error(v_error_message);

1421: end if;
1422: elsif (icx_deliver_to_requestor is null) then
1423: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_REQUESTER');
1424: v_error_message := FND_MESSAGE.GET;
1425: icx_util.add_error(v_error_message);
1426: storeerror(v_cart_id, v_error_message);
1427: update icx_shopping_Carts
1428: set DELIVER_TO_REQUESTOR_ID = null,
1429: DELIVER_TO_REQUESTOR = null

Line 1444: icx_util.getPrompt(601, 'ICX_SHOPPING_CART_HEADER_R',

1440: fetch employee_check into requesterID;
1441: if (employee_check%NOTFOUND) then
1442: --changed by alex
1443: /* v_error_message :=
1444: icx_util.getPrompt(601, 'ICX_SHOPPING_CART_HEADER_R',
1445: 178, 'ICX_APPROVER_NAME');
1446: FND_MESSAGE.SET_NAME('ICX','ICX_INVALID_ENTRY');
1447: FND_MESSAGE.SET_TOKEN('INVALID_TOKEN',v_error_message);
1448: v_error_message := FND_MESSAGE.GET;

Line 1449: icx_util.add_error(v_error_message);

1445: 178, 'ICX_APPROVER_NAME');
1446: FND_MESSAGE.SET_NAME('ICX','ICX_INVALID_ENTRY');
1447: FND_MESSAGE.SET_TOKEN('INVALID_TOKEN',v_error_message);
1448: v_error_message := FND_MESSAGE.GET;
1449: icx_util.add_error(v_error_message);
1450: storeerror(v_cart_id,v_error_message);
1451: */
1452: p_requester := null;
1453: requesterID:= null;

Line 1466: icx_util.getPrompt(601, 'ICX_SHOPPING_CART_HEADER_R',

1462: end if;
1463: elsif (icx_approver_name is null) then
1464: --changed by alex
1465: /* v_error_message :=
1466: icx_util.getPrompt(601, 'ICX_SHOPPING_CART_HEADER_R',
1467: 178, 'ICX_APPROVER_NAME');
1468: FND_MESSAGE.SET_NAME('ICX','ICX_INVALID_ENTRY');
1469: FND_MESSAGE.SET_TOKEN('INVALID_TOKEN',v_error_message);
1470: v_error_message := FND_MESSAGE.GET;

Line 1471: icx_util.add_error(v_error_message);

1467: 178, 'ICX_APPROVER_NAME');
1468: FND_MESSAGE.SET_NAME('ICX','ICX_INVALID_ENTRY');
1469: FND_MESSAGE.SET_TOKEN('INVALID_TOKEN',v_error_message);
1470: v_error_message := FND_MESSAGE.GET;
1471: icx_util.add_error(v_error_message);
1472: storeerror(v_cart_id,v_error_message);
1473: */
1474: update icx_shopping_carts
1475: set APPROVER_ID = null,

Line 1778: icx_util.add_error(v_error_message);

1774: v_error_message := FND_MESSAGE.GET;
1775: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');
1776: FND_MESSAGE.SET_TOKEN('LINE_NUM_TOKEN',to_char(i));
1777: v_error_message := FND_MESSAGE.GET || ': ' || v_error_message;
1778: icx_util.add_error(v_error_message);
1779: storeerror(v_cart_id, v_error_message);
1780: v_need_date := sysdate + v_incr;
1781: end if;
1782: exception

Line 1791: icx_util.add_error(v_error_message);

1787: v_error_message := FND_MESSAGE.GET;
1788: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');
1789: FND_MESSAGE.SET_TOKEN('LINE_NUM_TOKEN',to_char(i));
1790: v_error_message := FND_MESSAGE.GET || ': ' || v_error_message;
1791: icx_util.add_error(v_error_message);
1792: storeerror(v_cart_id, v_error_message);
1793: v_need_date := sysdate + v_incr;
1794: end;
1795: if v_need_date is null then

Line 1801: icx_util.add_error(v_error_message);

1797: v_error_message := FND_MESSAGE.GET;
1798: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');
1799: FND_MESSAGE.SET_TOKEN('LINE_NUM_TOKEN',to_char(i));
1800: v_error_message := FND_MESSAGE.GET || ': ' || v_error_message;
1801: icx_util.add_error(v_error_message);
1802: storeerror(v_cart_id, v_error_message);
1803: open get_head_date(v_cart_id);
1804: fetch get_head_date into v_need_date;
1805: close get_head_date;

Line 1826: icx_util.add_error(v_error_message);

1822: when others then
1823: -- add error
1824: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_DATE');
1825: v_error_message := FND_MESSAGE.GET;
1826: icx_util.add_error(v_error_message);
1827: storeerror(v_cart_id, v_error_message);
1828: v_expend_date := sysdate;
1829: end;
1830: end if;

Line 2110: icx_util.add_error(v_error_message);

2106: --add error
2107: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
2108: FND_MESSAGE.SET_TOKEN('ITEM_TOKEN', a_item_description(i));
2109: v_error_message := FND_MESSAGE.GET;
2110: icx_util.add_error(v_error_message);
2111: storeerror(v_cart_id, v_error_message);
2112: else
2113: if (v_account_id is not null) then
2114: select count(*) into v_exist

Line 2126: icx_util.add_error(v_error_message);

2122: --add error
2123: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
2124: FND_MESSAGE.SET_TOKEN('ITEM_TOKEN', a_item_description(i));
2125: v_error_message := FND_MESSAGE.GET;
2126: icx_util.add_error(v_error_message);
2127: storeerror(v_cart_id, v_error_message);
2128: -- set saved_flag to 4 (error exists)
2129: end if;
2130: else

Line 2144: icx_util.add_error(v_error_message);

2140: --add error
2141: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_ACCOUNT');
2142: FND_MESSAGE.SET_TOKEN('ITEM_TOKEN', a_item_description(i));
2143: v_error_message := FND_MESSAGE.GET;
2144: icx_util.add_error(v_error_message);
2145: storeerror(v_cart_id, v_error_message);
2146: v_account_id := null;
2147: end if;
2148: end if;

Line 2196: icx_util.getPrompt(601, 'ICX_SHOPPING_CART_HEADER_R',

2192: v_errored := FALSE;
2193:
2194: for prec in invalid_locations(v_cart_id, n_org_id) loop
2195: v_error_message :=
2196: icx_util.getPrompt(601, 'ICX_SHOPPING_CART_HEADER_R',
2197: 178, 'ICX_DELIVER_TO_LOCATION');
2198:
2199: FND_MESSAGE.SET_NAME('ICX','ICX_INVALID_ENTRY');
2200: FND_MESSAGE.SET_TOKEN('INVALID_TOKEN',v_error_message || ': ' ||

Line 2207: icx_util.add_error(v_error_message);

2203:
2204: FND_MESSAGE.SET_NAME('ICX','ICX_LINE_NUMBER');
2205: FND_MESSAGE.SET_TOKEN('LINE_NUM_TOKEN',to_char(prec.cart_line_number));
2206: v_error_message := FND_MESSAGE.GET || ': ' || v_error_message;
2207: icx_util.add_error(v_error_message);
2208: storeerror(v_cart_id,v_error_message);
2209: end loop;
2210: update icx_shopping_cart_lines
2211: set (DELIVER_TO_LOCATION_ID,

Line 2230: icx_util.add_error(v_error_message);

2226:
2227: if (supp_count > 1) then
2228: FND_MESSAGE.SET_NAME('ICX','ICX_EMERGENCY_PO_VENDOR');
2229: v_error_message := FND_MESSAGE.GET;
2230: icx_util.add_error(v_error_message);
2231: storeerror(v_cart_id,v_error_message);
2232: elsif (supp_count = 0) then
2233: v_error_message := icx_util.getPrompt(601,'ICX_SHOPPING_CART_LINES_EMG_R',178,'ICX_SUGGESTED_VENDOR_NAME');
2234: FND_MESSAGE.SET_NAME('ICX','ICX_REQUIRED_FIELD');

Line 2233: v_error_message := icx_util.getPrompt(601,'ICX_SHOPPING_CART_LINES_EMG_R',178,'ICX_SUGGESTED_VENDOR_NAME');

2229: v_error_message := FND_MESSAGE.GET;
2230: icx_util.add_error(v_error_message);
2231: storeerror(v_cart_id,v_error_message);
2232: elsif (supp_count = 0) then
2233: v_error_message := icx_util.getPrompt(601,'ICX_SHOPPING_CART_LINES_EMG_R',178,'ICX_SUGGESTED_VENDOR_NAME');
2234: FND_MESSAGE.SET_NAME('ICX','ICX_REQUIRED_FIELD');
2235: FND_MESSAGE.SET_TOKEN('FIELD_NAME_TOKEN',v_error_message);
2236: v_error_message := FND_MESSAGE.GET;
2237:

Line 2241: icx_util.add_error(v_error_message);

2237:
2238: --htp.p(v_error_message);
2239: --return;
2240:
2241: icx_util.add_error(v_error_message);
2242: storeerror(v_cart_id,v_error_message);
2243: end if;
2244: end if;
2245:

Line 2255: if (icx_util.error_count = 0) then

2251:
2252: end if; /* if icx_cart_line_ida.COUNT > 0 */
2253:
2254:
2255: if (icx_util.error_count = 0) then
2256: l_err_loadinterface := 'N';
2257: if user_action = 'SAVE' then
2258: update icx_shopping_Carts
2259: set saved_flag = 1

Line 2276: icx_util.add_error(l_err_mesg);

2272: WHEN OTHERS THEN
2273: l_err_num := SQLCODE;
2274: l_error_message := SQLERRM;
2275: select substr(l_error_message,12,512) into l_err_mesg from dual;
2276: icx_util.add_error(l_err_mesg);
2277: storeerror(v_cart_id,l_err_mesg);
2278: l_err_loadinterface := 'Y';
2279:
2280: end;

Line 2326: if (icx_util.error_count = 0) and (user_action <> 'MODIFY') and

2322: end if;
2323:
2324: --changed by alex
2325:
2326: if (icx_util.error_count = 0) and (user_action <> 'MODIFY') and
2327: (user_action <> 'GET_PO_MODIFY') and (user_action <> 'ATTACHMENT') and
2328: ((v_action <> 'PO') or (supp_count > 0)) then
2329: become_top(icx_cart_id, emergency, v_action);
2330: elsif (icx_util.error_count = 0) and (user_action = 'ATTACHMENT') then

Line 2330: elsif (icx_util.error_count = 0) and (user_action = 'ATTACHMENT') then

2326: if (icx_util.error_count = 0) and (user_action <> 'MODIFY') and
2327: (user_action <> 'GET_PO_MODIFY') and (user_action <> 'ATTACHMENT') and
2328: ((v_action <> 'PO') or (supp_count > 0)) then
2329: become_top(icx_cart_id, emergency, v_action);
2330: elsif (icx_util.error_count = 0) and (user_action = 'ATTACHMENT') then
2331:
2332: --This call does not repaint the whole page under IE 3.0. alex
2333: /*
2334: fnd_webattch.Summary(function_name=>icx_call.encrypt2('ICX_REQS'),

Line 2375: icx_util.add_error(l_err_mesg);

2371: when OTHERS then
2372: l_err_num := SQLCODE;
2373: l_error_message := SQLERRM;
2374: select substr(l_error_message,12,512) into l_err_mesg from dual;
2375: icx_util.add_error(l_err_mesg);
2376: storeerror(v_cart_id,l_err_mesg);
2377: icx_util.error_page_print;
2378: return;
2379: end;

Line 2377: icx_util.error_page_print;

2373: l_error_message := SQLERRM;
2374: select substr(l_error_message,12,512) into l_err_mesg from dual;
2375: icx_util.add_error(l_err_mesg);
2376: storeerror(v_cart_id,l_err_mesg);
2377: icx_util.error_page_print;
2378: return;
2379: end;
2380:
2381: end ICX_REQ_SUBMIT;