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.POS_BATCH_IMPORT_PKG dependencies on POS_PRODUCT_SERVICE_UTL_PKG

Line 4361: pos_product_service_utl_pkg.initialize(x_status => l_status,

4357: ' Parameters: ' || ' batch_id: ' || p_batch_id ||
4358: ' party_id: ' || p_party_id);
4359:
4360: -- Below API would give the delimiter and the segment definition to be inserted
4361: pos_product_service_utl_pkg.initialize(x_status => l_status,
4362: x_error_message => l_error_message);
4363:
4364: pos_product_service_utl_pkg.get_product_meta_data(x_product_segment_definition => l_product_segment_definition,
4365: x_product_segment_count => l_product_segment_count,

Line 4364: pos_product_service_utl_pkg.get_product_meta_data(x_product_segment_definition => l_product_segment_definition,

4360: -- Below API would give the delimiter and the segment definition to be inserted
4361: pos_product_service_utl_pkg.initialize(x_status => l_status,
4362: x_error_message => l_error_message);
4363:
4364: pos_product_service_utl_pkg.get_product_meta_data(x_product_segment_definition => l_product_segment_definition,
4365: x_product_segment_count => l_product_segment_count,
4366: x_default_po_category_set_id => l_default_po_category_set_id,
4367: x_delimiter => l_delimiter);
4368:

Line 4370: ' Output from pos_product_service_utl_pkg.get_product_meta_data: ' ||

4366: x_default_po_category_set_id => l_default_po_category_set_id,
4367: x_delimiter => l_delimiter);
4368:
4369: fnd_file.put_line(fnd_file.log,
4370: ' Output from pos_product_service_utl_pkg.get_product_meta_data: ' ||
4371: ' product_segment_definition: ' ||
4372: l_product_segment_definition ||
4373: ' product_segment_count: ' || l_product_segment_count);
4374:

Line 4665: pos_product_service_utl_pkg.add_new_ps_req(p_vendor_id => p_vendor_prodsrv_rec.vendor_id,

4661: x_segment_code => l_segment_code);
4662:
4663: IF (l_prod_valid = 'Y') THEN
4664: -- Insert the data into the pos_product_service_requests table using the follwing API
4665: pos_product_service_utl_pkg.add_new_ps_req(p_vendor_id => p_vendor_prodsrv_rec.vendor_id,
4666: p_segment1 => p_vendor_prodsrv_rec.segment1,
4667: p_segment2 => p_vendor_prodsrv_rec.segment2,
4668: p_segment3 => p_vendor_prodsrv_rec.segment3,
4669: p_segment4 => p_vendor_prodsrv_rec.segment4,

Line 4714: pos_product_service_utl_pkg.initialize(x_status => l_status,

4710: p_vendor_prodsrv_rec.request_status ||
4711: ' mapping_id: ' || l_mapping_id ||
4712: ' segment_code: ' || l_segment_code);
4713:
4714: pos_product_service_utl_pkg.initialize(x_status => l_status,
4715: x_error_message => l_error_message);
4716:
4717: -- Using the mapping_id make a call to the following API
4718: l_req_id := pos_product_service_utl_pkg.get_requestid(x_segment_code => l_segment_code,

Line 4718: l_req_id := pos_product_service_utl_pkg.get_requestid(x_segment_code => l_segment_code,

4714: pos_product_service_utl_pkg.initialize(x_status => l_status,
4715: x_error_message => l_error_message);
4716:
4717: -- Using the mapping_id make a call to the following API
4718: l_req_id := pos_product_service_utl_pkg.get_requestid(x_segment_code => l_segment_code,
4719: x_mapp_id => l_mapping_id);
4720:
4721: -- Using the request_id make a call to the following Api to approve the data and insert it into the
4722: -- pos_sup_products_services table

Line 4994: pos_product_service_utl_pkg.initialize(x_status => l_status,

4990:
4991: --Bug 13399285 - ora-00923 error, need to replace the '.' to global flexfield setup l_delimiter
4992: fnd_file.put_line(fnd_file.log, 'l_mapping_id: ' || l_mapping_id);
4993: --Bug 13704624 - update status for products and services not working, need to get l_delimiter value first
4994: pos_product_service_utl_pkg.initialize(x_status => l_status,
4995: x_error_message => l_error_message);
4996:
4997: pos_product_service_utl_pkg.get_product_meta_data(x_product_segment_definition => l_product_segment_definition,
4998: x_product_segment_count => l_product_segment_count,

Line 4997: pos_product_service_utl_pkg.get_product_meta_data(x_product_segment_definition => l_product_segment_definition,

4993: --Bug 13704624 - update status for products and services not working, need to get l_delimiter value first
4994: pos_product_service_utl_pkg.initialize(x_status => l_status,
4995: x_error_message => l_error_message);
4996:
4997: pos_product_service_utl_pkg.get_product_meta_data(x_product_segment_definition => l_product_segment_definition,
4998: x_product_segment_count => l_product_segment_count,
4999: x_default_po_category_set_id => l_default_po_category_set_id,
5000: x_delimiter => l_delimiter);
5001:

Line 5071: l_req_id := pos_product_service_utl_pkg.get_requestid(x_segment_code => l_segment_concat,

5067: 'l_segment_concat: ' || l_segment_concat);
5068: fnd_file.put_line(fnd_file.log,
5069: 'l_delimiter: ' || l_delimiter);
5070:
5071: l_req_id := pos_product_service_utl_pkg.get_requestid(x_segment_code => l_segment_concat,
5072: x_mapp_id => l_mapping_id);
5073: fnd_file.put_line(fnd_file.log,
5074: 'l_req_id: ' || l_req_id);
5075:

Line 5082: l_class_id := pos_product_service_utl_pkg.get_classid(x_segment_code => l_segment_concat,

5078: l_req_id := 0;
5079: END;
5080:
5081: BEGIN
5082: l_class_id := pos_product_service_utl_pkg.get_classid(x_segment_code => l_segment_concat,
5083: x_vendor_id => vendor_prod_srv_rec.vendor_id);
5084: fnd_file.put_line(fnd_file.log,
5085: 'l_class_id: ' || l_class_id);
5086: EXCEPTION

Line 5170: pos_product_service_utl_pkg.update_main_ps_req(p_req_id_tbl => l_req_id_tab,

5166: x_msg_data => l_msg_data);
5167: IF (l_class_id <>0) THEN
5168: l_req_id_tab.extend;
5169: l_req_id_tab(1) := l_class_id;
5170: pos_product_service_utl_pkg.update_main_ps_req(p_req_id_tbl => l_req_id_tab,
5171: p_status => 'R',
5172: x_return_status => l_ret_status,
5173: x_msg_count => l_msg_count,
5174: x_msg_data => l_msg_data);

Line 5180: pos_product_service_utl_pkg.update_main_ps_req(p_req_id_tbl => l_req_id_tab,

5176: ELSE
5177: IF (l_class_id <>0) THEN
5178: l_req_id_tab.extend;
5179: l_req_id_tab(1) := l_class_id;
5180: pos_product_service_utl_pkg.update_main_ps_req(p_req_id_tbl => l_req_id_tab,
5181: p_status => 'R',
5182: x_return_status => l_ret_status,
5183: x_msg_count => l_msg_count,
5184: x_msg_data => l_msg_data);

Line 5197: pos_product_service_utl_pkg.update_main_ps_req(p_req_id_tbl => l_req_id_tab,

5193: x_msg_data => l_msg_data);
5194: IF (l_class_id <>0) THEN
5195: l_req_id_tab.extend;
5196: l_req_id_tab(1) := l_class_id;
5197: pos_product_service_utl_pkg.update_main_ps_req(p_req_id_tbl => l_req_id_tab,
5198: p_status => 'A',
5199: x_return_status => l_ret_status,
5200: x_msg_count => l_msg_count,
5201: x_msg_data => l_msg_data);

Line 5207: pos_product_service_utl_pkg.update_main_ps_req(p_req_id_tbl => l_req_id_tab,

5203: ELSE
5204: IF (l_class_id <>0) THEN
5205: l_req_id_tab.extend;
5206: l_req_id_tab(1) := l_class_id;
5207: pos_product_service_utl_pkg.update_main_ps_req(p_req_id_tbl => l_req_id_tab,
5208: p_status => 'A',
5209: x_return_status => l_ret_status,
5210: x_msg_count => l_msg_count,
5211: x_msg_data => l_msg_data);

Line 5224: pos_product_service_utl_pkg.remove_mult_ps_reqs(p_req_id_tbl => l_req_id_tab,

5220: IF (l_req_id <> 0) THEN
5221: l_req_id_tab.extend;
5222: l_req_id_tab(1) := l_req_id;
5223:
5224: pos_product_service_utl_pkg.remove_mult_ps_reqs(p_req_id_tbl => l_req_id_tab,
5225: x_return_status => l_ret_status,
5226: x_msg_count => l_msg_count,
5227: x_msg_data => l_msg_data);
5228: IF (l_class_id <>0) THEN

Line 5231: pos_product_service_utl_pkg.update_main_ps_req(p_req_id_tbl => l_req_id_tab,

5227: x_msg_data => l_msg_data);
5228: IF (l_class_id <>0) THEN
5229: l_req_id_tab.extend;
5230: l_req_id_tab(1) := l_class_id;
5231: pos_product_service_utl_pkg.update_main_ps_req(p_req_id_tbl => l_req_id_tab,
5232: p_status => 'X',
5233: x_return_status => l_ret_status,
5234: x_msg_count => l_msg_count,
5235: x_msg_data => l_msg_data);

Line 5243: pos_product_service_utl_pkg.update_main_ps_req(p_req_id_tbl => l_req_id_tab,

5239: fnd_file.put_line(fnd_file.log, 'l_class_id for removed(l_req_id =0 flow): ' || l_class_id);
5240: IF (l_class_id <>0) THEN
5241: l_req_id_tab.extend;
5242: l_req_id_tab(1) := l_class_id;
5243: pos_product_service_utl_pkg.update_main_ps_req(p_req_id_tbl => l_req_id_tab,
5244: p_status => 'X',
5245: x_return_status => l_ret_status,
5246: x_msg_count => l_msg_count,
5247: x_msg_data => l_msg_data);