80: fnd_global.apps_initialize(l_user_id, l_responsibility_id, 178);
81:
82: veera_debug('Script Name: ' || l_script_name || ' Org Id: ' || to_char(l_org_id) || 'User Id: ' || to_char(l_user_id) || 'Resp ID: ' || to_char(l_responsibility_id) || 'Session Id: ' || to_char(l_session_id));
83:
84: htp.htmlOpen;
85:
86:
87: htp.title(fnd_message.get_string('ICX','ICX_POS_ACK_ENTER_ACK'));
88:
83:
84: htp.htmlOpen;
85:
86:
87: htp.title(fnd_message.get_string('ICX','ICX_POS_ACK_ENTER_ACK'));
88:
89: l_title_message := fnd_message.get_string('ICX','ICX_POS_ACK_ENTER_ACK');
90:
91: htp.headOpen;
87: htp.title(fnd_message.get_string('ICX','ICX_POS_ACK_ENTER_ACK'));
88:
89: l_title_message := fnd_message.get_string('ICX','ICX_POS_ACK_ENTER_ACK');
90:
91: htp.headOpen;
92: icx_util.copyright;
93: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
94:
95: js.scriptOpen;
89: l_title_message := fnd_message.get_string('ICX','ICX_POS_ACK_ENTER_ACK');
90:
91: htp.headOpen;
92: icx_util.copyright;
93: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
94:
95: js.scriptOpen;
96: pos_global_vars_sv.InitializeMessageArray;
97: pos_global_vars_sv.InitializeOtherVars(l_script_name);
98: icx_util.LOVscript;
99: js.scriptClose;
100:
101: htp.p(' ');
103: htp.p(' ');
105: htp.p(' ');
100:
101: htp.p(' ');
103: htp.p(' ');
105: htp.p(' ');
107: htp.p(' ');
102: htp.p(' ');
103: htp.p(' ');
105: htp.p(' ');
107: htp.p(' ');
109: htp.p('');
105: htp.p(' ');
107: htp.p(' ');
109: htp.p('');
104: htp.p(' ');
105: htp.p(' ');
107: htp.p(' ');
109: htp.p('');
106: htp.p(' ');
107: htp.p(' ');
109: htp.p('');
113: htp.headClose;
114:
107: htp.p(' ');
109: htp.p('');
113: htp.headClose;
114:
115:
108: htp.p(' ');
109: htp.p('');
113: htp.headClose;
114:
115:
116: -- blue border frame
109: htp.p('');
113: htp.headClose;
114:
115:
116: -- blue border frame
117:
114:
115:
116: -- blue border frame
117:
118: htp.p('
119:
140:
141: ');
142: -- blue border frame
143:
144: htp.p('');
145:
146: htp.htmlClose;
147:
148: Veera_Debug('End Search_PO');
142: -- blue border frame
143:
144: htp.p('');
145:
146: htp.htmlClose;
147:
148: Veera_Debug('End Search_PO');
149:
150:
173:
174: g_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
175: l_supplier_contact := Get_Supplier_ID(l_user_id);
176:
177: htp.htmlOpen;
178: htp.title(fnd_message.get_string('ICX','ICX_POS_ACK_ENTER_ACK'));
179:
180: htp.headOpen;
181: icx_util.copyright;
174: g_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
175: l_supplier_contact := Get_Supplier_ID(l_user_id);
176:
177: htp.htmlOpen;
178: htp.title(fnd_message.get_string('ICX','ICX_POS_ACK_ENTER_ACK'));
179:
180: htp.headOpen;
181: icx_util.copyright;
182: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
176:
177: htp.htmlOpen;
178: htp.title(fnd_message.get_string('ICX','ICX_POS_ACK_ENTER_ACK'));
179:
180: htp.headOpen;
181: icx_util.copyright;
182: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
183:
184: js.scriptOpen;
178: htp.title(fnd_message.get_string('ICX','ICX_POS_ACK_ENTER_ACK'));
179:
180: htp.headOpen;
181: icx_util.copyright;
182: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
183:
184: js.scriptOpen;
185: pos_global_vars_sv.InitializeMessageArray;
186: pos_global_vars_sv.InitializeOtherVars(l_script_name);
187: icx_util.LOVscript;
188: js.scriptClose;
189:
190: htp.p(' ');
192: htp.p(' ');
194: htp.p(' ');
189:
190: htp.p(' ');
192: htp.p(' ');
194: htp.p(' ');
196: htp.p(' ');
191: htp.p(' ');
192: htp.p(' ');
194: htp.p(' ');
196: htp.p(' ');
198: htp.headClose;
199:
193: htp.p(' ');
194: htp.p(' ');
196: htp.p(' ');
198: htp.headClose;
199:
200: htp.p('
201:
303:
304: l_supplier_id := Get_Supplier_ID(l_user_id);
305: veera_debug('Supplier Id: ' || to_char(l_supplier_id));
306:
307: htp.htmlOpen;
308: htp.headOpen;
309:
310: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
311: js.scriptOpen;
304: l_supplier_id := Get_Supplier_ID(l_user_id);
305: veera_debug('Supplier Id: ' || to_char(l_supplier_id));
306:
307: htp.htmlOpen;
308: htp.headOpen;
309:
310: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
311: js.scriptOpen;
312: icx_util.LOVscript;
306:
307: htp.htmlOpen;
308: htp.headOpen;
309:
310: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
311: js.scriptOpen;
312: icx_util.LOVscript;
313: htp.p('
314: function call_LOV(c_attribute_code)
309:
310: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
311: js.scriptOpen;
312: icx_util.LOVscript;
313: htp.p('
314: function call_LOV(c_attribute_code)
315: {
316: var c_where_clause = "";
317: c_where_clause = escape(c_where_clause, 1);
334: ');
335:
336: js.scriptClose;
337:
338: htp.headClose;
339:
340: htp.p('
336: js.scriptClose;
337:
338: htp.headClose;
339:
340: htp.p('');
341: -- If the frame is basic search, the switch will be advance search. Vice Versa
342:
343: if P_advance_flag = 'Y' then
344: l_advance_flag := 'N';
355:
356: Paint_Search_Fields(p_advance_flag => p_advance_flag,
357: l_po_number => l_po_number);
358:
359: htp.p('');
360:
361: ELSE
362: htp.p('
' ||Line 362: htp.p('
366: END IF; Line 363: htp.p('
Line 410: htp.p('406: htp.p(' ' || | 407: ' 408: end if; 409: 410: htp.p(' 411: 412: htp.bodyClose; 413: htp.htmlClose; 414: END FIXED_FRAME; Line 412: htp.bodyClose; |
Line 447: htp.p('
457: ); 458: 459: end if; 460: htp.bodyClose; 461: htp.htmlClose; 462: END COUNTER_FRAME; 463: 464: PROCEDURE BLANK_FRAME ( Line 461: htp.htmlClose; |
' ||Line 678: htp.p(''); |
' || 681: ' ' || 682: ' ' || Line 679: htp.p('
675: Veera_Debug('Paint_Search: Po Number: ' || l_po_number);
681: ' ' || |
724: END IF; |
729: item_valign(l_attribute_index) || ' WIDTH=30% ' || '>' || 730: item_reqd(l_attribute_index) || '' 731: || item_name(l_attribute_index) || ' ' || '' || 732: ' | ');
732: ' | ');
737: '>' || ''|| 738: ''); 742: else 743: veera_debug('Inside else of pos_ack_sr_po_number'); 744: htp.p(' |
745: '>' || ''|| 746: '
748: nvl(get_result_value(l_result_index, l_current_col), '') || 750: end if; 751: IF (ak_query_pkg.g_items_table(l_attribute_index).lov_region_code IS NOT NULL AND ak_query_pkg.g_items_table(l_attribute_index).lov_attribute_code IS NOT NULL) THEN 752: htp.p(' 756: '); Line 761: htp.p('' || | ');
774: item_halign(l_attribute_index) || 775: item_valign(l_attribute_index) || ' WIDTH=175 ' || '>' || Line 773: htp.p('
769: '>'); 826: htp.p(' | '); 827: 828: button('javascript:clearsearchfields()', fnd_message.get_string('ICX', 'ICX_POS_CLEAR')); 829: 830: htp.p(' | ');|||||||||||||||||
775: item_valign(l_attribute_index) || ' WIDTH=175 ' || '>' ||
776: '' || item_name(l_attribute_index)
777: || '' || '
785:
786: END IF;
787: ELSIF (item_style(l_attribute_index) = 'POPLIST') THEN
788: IF item_updateable(l_attribute_index) THEN
789: htp.p('
790: item_valign(l_attribute_index) || ' WIDTH=30% ' || '>' ||
791: '' || item_name(l_attribute_index)
792: || ' ' || '' || '
796: '
801: item_halign(l_attribute_index) ||
802: item_valign(l_attribute_index) || ' WIDTH=175 ' || '>' ||
803: '' || item_name(l_attribute_index)
804: || '' || '
816:
817: if ((l_current_col mod 1) = 0) THEN
818: l_row := l_row + 1;
819: IF l_row = 1 THEN
820: htp.p('
821:
822: --button('javascript:top.SearchPOs()', fnd_message.get_string('ICX', 'ICX_POS_SEARCH'));
823: button('javascript:document.POS_ACK_SEARCH.submit(); ', fnd_message.get_string('ICX', 'ICX_POS_SEARCH'));
824:
825: htp.p('
822: --button('javascript:top.SearchPOs()', fnd_message.get_string('ICX', 'ICX_POS_SEARCH'));
823: button('javascript:document.POS_ACK_SEARCH.submit(); ', fnd_message.get_string('ICX', 'ICX_POS_SEARCH'));
824:
825: htp.p('
837:
838: END LOOP;
839:
840: htp.p('');
841: htp.p('
919: l_start_row := to_number(pos_ack_sr_row_num);
920: l_end_row := l_start_row + 25 -1;
921: end if;
922:
923: htp.htmlOpen;
924: -- Header Start
925:
926: htp.headOpen;
927: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
922:
923: htp.htmlOpen;
924: -- Header Start
925:
926: htp.headOpen;
927: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
928: js.scriptOpen;
929: icx_util.LOVscript;
930: htp.p('
923: htp.htmlOpen;
924: -- Header Start
925:
926: htp.headOpen;
927: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
928: js.scriptOpen;
929: icx_util.LOVscript;
930: htp.p('
931:
926: htp.headOpen;
927: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
928: js.scriptOpen;
929: icx_util.LOVscript;
930: htp.p('
931:
932: function LoadCounter(p_start, p_end, p_total)
933: {
934: var l_URL = parent.scriptName + "/POS_ACK_SEARCH.COUNTER_FRAME?" +
1027:
1028:
1029: ');
1030: js.scriptClose;
1031: htp.headClose;
1032:
1033: -- Header End
1034: /*
1035: select count(*) into l_count
1050: ')">');
1051:
1052:
1053: if l_count > 0 then
1054: htp.p('
1056: '' ||
1057: '' ||
1058: '
1061:
1062:
1063: veera_debug('Row num in result pos: ' || pos_ack_sr_row_num);
1064: paint_edit_pos(to_number(pos_ack_sr_row_num));
1065: htp.p('');
1066: else
1067: htp.p('');
1068: htp.p(fnd_message.get_string('ICX','ICX_POS_NO_RECORDS'));
1069: htp.p('');
1063: veera_debug('Row num in result pos: ' || pos_ack_sr_row_num);
1064: paint_edit_pos(to_number(pos_ack_sr_row_num));
1065: htp.p('');
1066: else
1067: htp.p('');
1068: htp.p(fnd_message.get_string('ICX','ICX_POS_NO_RECORDS'));
1069: htp.p('');
1070: end if;
1071:
1064: paint_edit_pos(to_number(pos_ack_sr_row_num));
1065: htp.p('');
1066: else
1067: htp.p('');
1068: htp.p(fnd_message.get_string('ICX','ICX_POS_NO_RECORDS'));
1069: htp.p('');
1070: end if;
1071:
1072: htp.p('');
1065: htp.p('');
1066: else
1067: htp.p('');
1068: htp.p(fnd_message.get_string('ICX','ICX_POS_NO_RECORDS'));
1069: htp.p('');
1070: end if;
1071:
1072: htp.p('');
1073: htp.htmlClose;
1068: htp.p(fnd_message.get_string('ICX','ICX_POS_NO_RECORDS'));
1069: htp.p('');
1070: end if;
1071:
1072: htp.p('');
1073: htp.htmlClose;
1074: END RESULT_POS;
1075:
1076: PROCEDURE SHOW_POS(
1069: htp.p('');
1070: end if;
1071:
1072: htp.p('');
1073: htp.htmlClose;
1074: END RESULT_POS;
1075:
1076: PROCEDURE SHOW_POS(
1077: pos_ack_sr_row_num IN VARCHAR2 default '0',
1083: l_msg1 VARCHAR2(240);
1084: l_msg2 VARCHAR2(240);
1085: BEGIN
1086: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
1087: htp.htmlOpen;
1088:
1089: htp.headOpen;
1090: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
1091: js.scriptOpen;
1085: BEGIN
1086: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
1087: htp.htmlOpen;
1088:
1089: htp.headOpen;
1090: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
1091: js.scriptOpen;
1092: icx_util.LOVscript;
1093: htp.p('
1086: l_script_name := owa_util.get_cgi_env('SCRIPT_NAME');
1087: htp.htmlOpen;
1088:
1089: htp.headOpen;
1090: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
1091: js.scriptOpen;
1092: icx_util.LOVscript;
1093: htp.p('
1094:
1089: htp.headOpen;
1090: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
1091: js.scriptOpen;
1092: icx_util.LOVscript;
1093: htp.p('
1094:
1095: function call_LOV1(c_attribute_code)
1096: {
1097: var c_where_clause = "";
1182: }
1183:
1184: ');
1185: js.scriptClose;
1186: htp.headClose;
1187:
1188: select count(*) into l_count
1189: from pos_ack_select;
1190:
1202:
1203:
1204: if l_count > 0 then
1205: --test
1206: htp.p('
1208: '' ||
1209: '' ||
1210: '
1214:
1215:
1216: veera_debug('Row num in result pos: ' || pos_ack_sr_row_num);
1217: paint_edit_pos(to_number(pos_ack_sr_row_num));
1218: htp.p('');
1219: else
1220: htp.p(fnd_message.get_string('ICX','ICX_POS_NO_RECORDS'));
1221: end if;
1222:
1216: veera_debug('Row num in result pos: ' || pos_ack_sr_row_num);
1217: paint_edit_pos(to_number(pos_ack_sr_row_num));
1218: htp.p('');
1219: else
1220: htp.p(fnd_message.get_string('ICX','ICX_POS_NO_RECORDS'));
1221: end if;
1222:
1223: htp.p('');
1224: htp.htmlClose;
1219: else
1220: htp.p(fnd_message.get_string('ICX','ICX_POS_NO_RECORDS'));
1221: end if;
1222:
1223: htp.p('');
1224: htp.htmlClose;
1225: END SHOW_POS;
1226:
1227: FUNCTION item_color(l_index in number) RETURN VARCHAR2 IS
1220: htp.p(fnd_message.get_string('ICX','ICX_POS_NO_RECORDS'));
1221: end if;
1222:
1223: htp.p('');
1224: htp.htmlClose;
1225: END SHOW_POS;
1226:
1227: FUNCTION item_color(l_index in number) RETURN VARCHAR2 IS
1228: BEGIN
1426: procedure button(src IN varchar2,
1427: txt IN varchar2) IS
1428: BEGIN
1429:
1430: htp.p('
1431:
'); 1554: 1555: Line 1553: htp.p(''); |
1549: veera_debug('After AK Select' || to_char(ak_query_pkg.g_items_table.count));
1746: htp.p(' |
1569: ' valign=bottom' ||
1570: '>' ||
1571: item_reqd(l_attribute_index)
1572: );
1573: --htp.p('' || item_name(l_attribute_index) || '');
1574: htp.p('' || item_name(l_attribute_index) || '');
1575: htp.p('
1713: ' value="' || to_char(l_current_row) ||
1714: '" >
2169: IS
2170: BEGIN
2171: -- delete from veera_debug;
2172: -- commit;
2173: htp.htmlOpen;
2174: htp.headOpen;
2175: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
2176: htp.p('');
2177: htp.headClose;
2170: BEGIN
2171: -- delete from veera_debug;
2172: -- commit;
2173: htp.htmlOpen;
2174: htp.headOpen;
2175: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
2176: htp.p('');
2177: htp.headClose;
2178: htp.bodyOpen;
2171: -- delete from veera_debug;
2172: -- commit;
2173: htp.htmlOpen;
2174: htp.headOpen;
2175: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
2176: htp.p('');
2177: htp.headClose;
2178: htp.bodyOpen;
2179: htp.bodyClose;
2172: -- commit;
2173: htp.htmlOpen;
2174: htp.headOpen;
2175: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
2176: htp.p('');
2177: htp.headClose;
2178: htp.bodyOpen;
2179: htp.bodyClose;
2180: htp.htmlClose;
2173: htp.htmlOpen;
2174: htp.headOpen;
2175: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
2176: htp.p('');
2177: htp.headClose;
2178: htp.bodyOpen;
2179: htp.bodyClose;
2180: htp.htmlClose;
2181: END CLEAR_LOG;
2174: htp.headOpen;
2175: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
2176: htp.p('');
2177: htp.headClose;
2178: htp.bodyOpen;
2179: htp.bodyClose;
2180: htp.htmlClose;
2181: END CLEAR_LOG;
2182:
2175: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
2176: htp.p('');
2177: htp.headClose;
2178: htp.bodyOpen;
2179: htp.bodyClose;
2180: htp.htmlClose;
2181: END CLEAR_LOG;
2182:
2183: PROCEDURE DISPLAY_LOG
2176: htp.p('');
2177: htp.headClose;
2178: htp.bodyOpen;
2179: htp.bodyClose;
2180: htp.htmlClose;
2181: END CLEAR_LOG;
2182:
2183: PROCEDURE DISPLAY_LOG
2184: IS
2186: CURSOR debug_cursor IS
2187: select sysdate from dual;
2188: BEGIN
2189: open debug_cursor;
2190: htp.htmlOpen;
2191: htp.headOpen;
2192: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
2193: htp.headClose;
2194: htp.bodyOpen;
2187: select sysdate from dual;
2188: BEGIN
2189: open debug_cursor;
2190: htp.htmlOpen;
2191: htp.headOpen;
2192: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
2193: htp.headClose;
2194: htp.bodyOpen;
2195: htp.p('
2188: BEGIN
2189: open debug_cursor;
2190: htp.htmlOpen;
2191: htp.headOpen;
2192: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
2193: htp.headClose;
2194: htp.bodyOpen;
2195: htp.p('
2189: open debug_cursor;
2190: htp.htmlOpen;
2191: htp.headOpen;
2192: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
2193: htp.headClose;
2194: htp.bodyOpen;
2195: htp.p('
2190: htp.htmlOpen;
2191: htp.headOpen;
2192: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
2193: htp.headClose;
2194: htp.bodyOpen;
2195: htp.p('
2191: htp.headOpen;
2192: htp.linkRel('STYLESHEET', '/OA_HTML/US/POSSTYLE.css');
2193: htp.headClose;
2194: htp.bodyOpen;
2195: htp.p('');
2196:
2197: LOOP
2198: FETCH debug_cursor
2199: INTO debug_string;
2196:
2197: LOOP
2198: FETCH debug_cursor
2199: INTO debug_string;
2200: htp.p(debug_string || '
');
2201: EXIT WHEN debug_cursor%NOTFOUND;
2202: END LOOP;
2203: CLOSE debug_cursor;
2204:
2201: EXIT WHEN debug_cursor%NOTFOUND;
2202: END LOOP;
2203: CLOSE debug_cursor;
2204:
2205: htp.bodyClose;
2206: htp.htmlClose;
2207: END DISPLAY_LOG;
2208:
2209: END POS_ACK_SEARCH;
2202: END LOOP;
2203: CLOSE debug_cursor;
2204:
2205: htp.bodyClose;
2206: htp.htmlClose;
2207: END DISPLAY_LOG;
2208:
2209: END POS_ACK_SEARCH;