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.ICX_REQ_SUBMIT dependencies on ICX_SEC

Line 16: l_shopper_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);

12: l_shopper_id NUMBER;
13:
14: begin
15:
16: l_shopper_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
17:
18: select icx_req_cart_errors_s.nextval into l_error_id from dual;
19:
20: /* append new message to the error table for redisplay */

Line 144: shopper_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);

140: delete icx_req_cart_errors
141: where cart_id = v_cart_id;
142:
143: -- get shopper id
144: shopper_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
145: -- get lang
146: v_lang := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
147:
148: if p_emergency = 'YES' then

Line 146: v_lang := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);

142:
143: -- get shopper id
144: shopper_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
145: -- get lang
146: v_lang := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
147:
148: if p_emergency = 'YES' then
149: v_header_region := 'ICX_SHOPPING_CART_HEADER_EMG_R';
150: v_lines_region := 'ICX_SHOPPING_CART_LINES_EMG_R';

Line 177: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),

173: -- ^^^^^^^^^^
174: --
175: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601,
176: P_PARENT_REGION_CODE => v_header_region,
177: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
178: P_USER_ID => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
179: P_WHERE_CLAUSE => v_where_clause,
180: P_RETURN_PARENTS => 'T',
181: P_RETURN_CHILDREN => 'F',

Line 178: P_USER_ID => icx_sec.getID(icx_sec.PV_WEB_USER_ID),

174: --
175: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601,
176: P_PARENT_REGION_CODE => v_header_region,
177: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
178: P_USER_ID => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
179: P_WHERE_CLAUSE => v_where_clause,
180: P_RETURN_PARENTS => 'T',
181: P_RETURN_CHILDREN => 'F',
182: P_WHERE_BINDS => where_clause_binds);

Line 308: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),

304: -- ^^^^^^^^^^
305: --
306: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601,
307: P_PARENT_REGION_CODE => v_lines_region,
308: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
309: P_USER_ID => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
310: P_WHERE_CLAUSE => v_where_clause,
311: P_RETURN_PARENTS => 'T',
312: P_RETURN_CHILDREN => 'F',

Line 309: P_USER_ID => icx_sec.getID(icx_sec.PV_WEB_USER_ID),

305: --
306: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601,
307: P_PARENT_REGION_CODE => v_lines_region,
308: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
309: P_USER_ID => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
310: P_WHERE_CLAUSE => v_where_clause,
311: P_RETURN_PARENTS => 'T',
312: P_RETURN_CHILDREN => 'F',
313: P_WHERE_BINDS => where_clause_binds);

Line 476: if (icx_sec.validatesession()) then

472: select REQ_NUMBER_SEGMENT1
473: from icx_shopping_carts
474: where CART_ID = l_cart_id;
475: begin
476: if (icx_sec.validatesession()) then
477:
478: -- get lang
479: v_lang := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
480: v_cart_id := icx_call.decrypt2(n_cart_id);

Line 479: v_lang := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);

475: begin
476: if (icx_sec.validatesession()) then
477:
478: -- get lang
479: v_lang := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
480: v_cart_id := icx_call.decrypt2(n_cart_id);
481:
482: htp.htmlOpen;
483: htp.headOpen;

Line 1022: if (icx_sec.validatesession()) then

1018:
1019: begin
1020:
1021:
1022: if (icx_sec.validatesession()) then
1023:
1024:
1025:
1026: -- initialize the error page

Line 1030: v_lang := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);

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:
1032:
1033: -- get shopper id and lang code
1034: v_shopper_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);

Line 1034: v_shopper_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);

1030: v_lang := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
1031:
1032:
1033: -- get shopper id and lang code
1034: v_shopper_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
1035:
1036: v_cart_id := icx_call.decrypt2(icx_cart_id);
1037:
1038:

Line 1043: n_org_id := icx_sec.getId(icx_sec.PV_ORG_ID);

1039: -- clear out all possible cart errors
1040: delete icx_req_cart_errors
1041: where cart_id = v_cart_id;
1042:
1043: n_org_id := icx_sec.getId(icx_sec.PV_ORG_ID);
1044: v_date_format := icx_sec.getID(icx_sec.PV_DATE_FORMAT);
1045: n_emp_id := icx_sec.getID(icx_sec.PV_INT_CONTACT_ID);
1046: v_dcdName := owa_util.get_cgi_env('SCRIPT_NAME');
1047:

Line 1044: v_date_format := icx_sec.getID(icx_sec.PV_DATE_FORMAT);

1040: delete icx_req_cart_errors
1041: where cart_id = v_cart_id;
1042:
1043: n_org_id := icx_sec.getId(icx_sec.PV_ORG_ID);
1044: v_date_format := icx_sec.getID(icx_sec.PV_DATE_FORMAT);
1045: n_emp_id := icx_sec.getID(icx_sec.PV_INT_CONTACT_ID);
1046: v_dcdName := owa_util.get_cgi_env('SCRIPT_NAME');
1047:
1048: -- get shopper info for defaults

Line 1045: n_emp_id := icx_sec.getID(icx_sec.PV_INT_CONTACT_ID);

1041: where cart_id = v_cart_id;
1042:
1043: n_org_id := icx_sec.getId(icx_sec.PV_ORG_ID);
1044: v_date_format := icx_sec.getID(icx_sec.PV_DATE_FORMAT);
1045: n_emp_id := icx_sec.getID(icx_sec.PV_INT_CONTACT_ID);
1046: v_dcdName := owa_util.get_cgi_env('SCRIPT_NAME');
1047:
1048: -- get shopper info for defaults
1049: ICX_REQ_NAVIGATION.shopper_info(n_emp_id,

Line 1076: v_incr := icx_sec.getID(icx_sec.PV_USER_REQ_DAYS_NEEDED_BY);

1072: if (icx_need_by_date <> FND_API.G_MISS_CHAR) then
1073: begin
1074: v_need_date := to_date(icx_need_by_date, v_date_format);
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);

Line 1086: v_incr := icx_sec.getID(icx_sec.PV_USER_REQ_DAYS_NEEDED_BY);

1082: end if;
1083: exception
1084: when others then
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);

Line 1098: v_incr := icx_sec.getID(icx_sec.PV_USER_REQ_DAYS_NEEDED_BY);

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;
1101:
1102:

Line 1382: if (icx_sec.getID(icx_sec.PV_USER_REQ_OVERRIDE_REQUESTOR) = 'ORG')

1378: if (icx_deliver_to_requestor <> FND_API.G_MISS_CHAR) then
1379: -- requster must be on in the region
1380: if (icx_deliver_to_requestor_id is null) then
1381: -- user type in value for requester
1382: if (icx_sec.getID(icx_sec.PV_USER_REQ_OVERRIDE_REQUESTOR) = 'ORG')
1383: then
1384: open get_preparer_org(n_emp_id);
1385: fetch get_preparer_org into v_preparer_org_id;
1386: close get_preparer_org;

Line 1772: v_incr := icx_sec.getID(icx_sec.PV_USER_REQ_DAYS_NEEDED_BY);

1768: if (icx_need_by_datea.COUNT >0) then
1769: begin
1770: v_need_date := to_date(icx_need_by_datea(i), v_date_format);
1771: if v_need_date <= (sysdate - 1) then
1772: v_incr := icx_sec.getID(icx_sec.PV_USER_REQ_DAYS_NEEDED_BY);
1773: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_NEED_BY_DATE');
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));

Line 1785: v_incr := icx_sec.getID(icx_sec.PV_USER_REQ_DAYS_NEEDED_BY);

1781: end if;
1782: exception
1783: when others then
1784: --add error
1785: v_incr := icx_sec.getID(icx_sec.PV_USER_REQ_DAYS_NEEDED_BY);
1786: FND_MESSAGE.SET_NAME('ICX', 'ICX_INVALID_DATE');
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));