20: x_progress VARCHAR2(3) := NULL;
21:
22: BEGIN
23: x_progress := '010';
24: x_inv_status := po_core_s.get_product_install_status('INV');
25:
26: x_progress := '020';
27: x_po_status := po_core_s.get_product_install_status('PO');
28:
23: x_progress := '010';
24: x_inv_status := po_core_s.get_product_install_status('INV');
25:
26: x_progress := '020';
27: x_po_status := po_core_s.get_product_install_status('PO');
28:
29: x_progress := '030';
30: x_qa_status := po_core_s.get_product_install_status('QA');
31:
26: x_progress := '020';
27: x_po_status := po_core_s.get_product_install_status('PO');
28:
29: x_progress := '030';
30: x_qa_status := po_core_s.get_product_install_status('QA');
31:
32: x_progress := '040';
33: x_wip_status := po_core_s.get_product_install_status('WIP');
34:
29: x_progress := '030';
30: x_qa_status := po_core_s.get_product_install_status('QA');
31:
32: x_progress := '040';
33: x_wip_status := po_core_s.get_product_install_status('WIP');
34:
35: x_progress := '050';
36: x_oe_status := po_core_s.get_product_install_status('OE');
37:
32: x_progress := '040';
33: x_wip_status := po_core_s.get_product_install_status('WIP');
34:
35: x_progress := '050';
36: x_oe_status := po_core_s.get_product_install_status('OE');
37:
38: x_progress := '060';
39: x_pa_status := po_core_s.get_product_install_status('PA');
40:
35: x_progress := '050';
36: x_oe_status := po_core_s.get_product_install_status('OE');
37:
38: x_progress := '060';
39: x_pa_status := po_core_s.get_product_install_status('PA');
40:
41:
42: EXCEPTION
43: WHEN OTHERS THEN
88:
89: x_progress VARCHAR2(3) := NULL;
90: BEGIN
91: x_progress := '010';
92: x_eam_install_status := po_core_s.get_product_install_status('EAM');
93:
94: x_progress := '020';
95: fnd_profile.get('PO_DIRECT_DELIVERY_TO_SHOPFLOOR',x_eam_profile);
96:
116:
117: x_progress VARCHAR2(3) := NULL;
118: BEGIN
119: x_progress := '010';
120: x_oke_install_status := po_core_s.get_product_install_status('OKE');
121:
122: EXCEPTION
123: WHEN OTHERS THEN
124: po_message_s.sql_error('po_setup_s1.get_oke_status', x_progress, sqlcode);
141:
142: x_progress VARCHAR2(3) := NULL;
143: BEGIN
144: x_progress := '010';
145: x_gms_install_status := po_core_s.get_product_install_status('GMS');
146:
147: EXCEPTION
148: WHEN OTHERS THEN
149: po_message_s.sql_error('po_setup_s1.get_gms_status', x_progress, sqlcode);
172: /* return the sourcing install status only if the Use Sourcing profile is set to yes
173: Otherwise return the install status as N irrespective of the fnd install status */
174:
175: IF nvl(x_pon_use_profile,'N') = 'Y' THEN
176: x_pon_install_status := po_core_s.get_product_install_status('PON');
177: ELSE
178: x_pon_install_status := 'N';
179: END IF;
180: