46:
47:
48: -- encumbrance actions
49: g_action_RESERVE CONSTANT VARCHAR2(30)
50: := PO_DOCUMENT_FUNDS_PVT.g_action_RESERVE;
51:
52: g_action_UNRESERVE CONSTANT VARCHAR2(30)
53: := PO_DOCUMENT_FUNDS_PVT.g_action_UNRESERVE;
54:
49: g_action_RESERVE CONSTANT VARCHAR2(30)
50: := PO_DOCUMENT_FUNDS_PVT.g_action_RESERVE;
51:
52: g_action_UNRESERVE CONSTANT VARCHAR2(30)
53: := PO_DOCUMENT_FUNDS_PVT.g_action_UNRESERVE;
54:
55: g_action_ADJUST CONSTANT VARCHAR2(30)
56: := PO_DOCUMENT_FUNDS_PVT.g_action_ADJUST;
57:
52: g_action_UNRESERVE CONSTANT VARCHAR2(30)
53: := PO_DOCUMENT_FUNDS_PVT.g_action_UNRESERVE;
54:
55: g_action_ADJUST CONSTANT VARCHAR2(30)
56: := PO_DOCUMENT_FUNDS_PVT.g_action_ADJUST;
57:
58: g_action_REQ_SPLIT CONSTANT
59: VARCHAR2(30)
60: := PO_DOCUMENT_FUNDS_PVT.g_action_REQ_SPLIT
56: := PO_DOCUMENT_FUNDS_PVT.g_action_ADJUST;
57:
58: g_action_REQ_SPLIT CONSTANT
59: VARCHAR2(30)
60: := PO_DOCUMENT_FUNDS_PVT.g_action_REQ_SPLIT
61: ;
62: g_action_CANCEL CONSTANT VARCHAR2(30)
63: := PO_DOCUMENT_FUNDS_PVT.g_action_CANCEL;
64:
59: VARCHAR2(30)
60: := PO_DOCUMENT_FUNDS_PVT.g_action_REQ_SPLIT
61: ;
62: g_action_CANCEL CONSTANT VARCHAR2(30)
63: := PO_DOCUMENT_FUNDS_PVT.g_action_CANCEL;
64:
65: g_action_FINAL_CLOSE CONSTANT VARCHAR2(30)
66: := PO_DOCUMENT_FUNDS_PVT.g_action_FINAL_CLOSE;
67:
62: g_action_CANCEL CONSTANT VARCHAR2(30)
63: := PO_DOCUMENT_FUNDS_PVT.g_action_CANCEL;
64:
65: g_action_FINAL_CLOSE CONSTANT VARCHAR2(30)
66: := PO_DOCUMENT_FUNDS_PVT.g_action_FINAL_CLOSE;
67:
68: g_action_UNDO_FINAL_CLOSE CONSTANT VARCHAR2(30)
69: := PO_DOCUMENT_FUNDS_PVT.g_action_UNDO_FINAL_CLOSE;
70:
65: g_action_FINAL_CLOSE CONSTANT VARCHAR2(30)
66: := PO_DOCUMENT_FUNDS_PVT.g_action_FINAL_CLOSE;
67:
68: g_action_UNDO_FINAL_CLOSE CONSTANT VARCHAR2(30)
69: := PO_DOCUMENT_FUNDS_PVT.g_action_UNDO_FINAL_CLOSE;
70:
71: g_action_REJECT CONSTANT VARCHAR2(30)
72: := PO_DOCUMENT_FUNDS_PVT.g_action_REJECT;
73:
68: g_action_UNDO_FINAL_CLOSE CONSTANT VARCHAR2(30)
69: := PO_DOCUMENT_FUNDS_PVT.g_action_UNDO_FINAL_CLOSE;
70:
71: g_action_REJECT CONSTANT VARCHAR2(30)
72: := PO_DOCUMENT_FUNDS_PVT.g_action_REJECT;
73:
74: g_action_RETURN CONSTANT VARCHAR2(30)
75: := PO_DOCUMENT_FUNDS_PVT.g_action_RETURN;
76:
71: g_action_REJECT CONSTANT VARCHAR2(30)
72: := PO_DOCUMENT_FUNDS_PVT.g_action_REJECT;
73:
74: g_action_RETURN CONSTANT VARCHAR2(30)
75: := PO_DOCUMENT_FUNDS_PVT.g_action_RETURN;
76:
77: g_action_CBC_RESERVE CONSTANT VARCHAR2(30)
78: := PO_DOCUMENT_FUNDS_PVT.g_action_CBC_RESERVE;
79:
74: g_action_RETURN CONSTANT VARCHAR2(30)
75: := PO_DOCUMENT_FUNDS_PVT.g_action_RETURN;
76:
77: g_action_CBC_RESERVE CONSTANT VARCHAR2(30)
78: := PO_DOCUMENT_FUNDS_PVT.g_action_CBC_RESERVE;
79:
80: g_action_CBC_UNRESERVE CONSTANT VARCHAR2(30)
81: := PO_DOCUMENT_FUNDS_PVT.g_action_CBC_UNRESERVE;
82:
77: g_action_CBC_RESERVE CONSTANT VARCHAR2(30)
78: := PO_DOCUMENT_FUNDS_PVT.g_action_CBC_RESERVE;
79:
80: g_action_CBC_UNRESERVE CONSTANT VARCHAR2(30)
81: := PO_DOCUMENT_FUNDS_PVT.g_action_CBC_UNRESERVE;
82:
83: g_action_INVOICE_CANCEL CONSTANT VARCHAR2(30)
84: := PO_DOCUMENT_FUNDS_PVT.g_action_INVOICE_CANCEL;
85:
80: g_action_CBC_UNRESERVE CONSTANT VARCHAR2(30)
81: := PO_DOCUMENT_FUNDS_PVT.g_action_CBC_UNRESERVE;
82:
83: g_action_INVOICE_CANCEL CONSTANT VARCHAR2(30)
84: := PO_DOCUMENT_FUNDS_PVT.g_action_INVOICE_CANCEL;
85:
86: g_action_CR_MEMO_CANCEL CONSTANT VARCHAR2(30)
87: := PO_DOCUMENT_FUNDS_PVT.g_action_CR_MEMO_CANCEL;
88:
83: g_action_INVOICE_CANCEL CONSTANT VARCHAR2(30)
84: := PO_DOCUMENT_FUNDS_PVT.g_action_INVOICE_CANCEL;
85:
86: g_action_CR_MEMO_CANCEL CONSTANT VARCHAR2(30)
87: := PO_DOCUMENT_FUNDS_PVT.g_action_CR_MEMO_CANCEL;
88:
89:
90: -- doc types
91: g_doc_type_REQUISITION CONSTANT
89:
90: -- doc types
91: g_doc_type_REQUISITION CONSTANT
92: PO_DOCUMENT_TYPES.document_type_code%TYPE
93: := PO_DOCUMENT_FUNDS_PVT.g_doc_type_REQUISITION
94: ;
95: g_doc_type_PO CONSTANT
96: PO_DOCUMENT_TYPES.document_type_code%TYPE
97: := PO_DOCUMENT_FUNDS_PVT.g_doc_type_PO
93: := PO_DOCUMENT_FUNDS_PVT.g_doc_type_REQUISITION
94: ;
95: g_doc_type_PO CONSTANT
96: PO_DOCUMENT_TYPES.document_type_code%TYPE
97: := PO_DOCUMENT_FUNDS_PVT.g_doc_type_PO
98: ;
99: g_doc_type_PA CONSTANT
100: PO_DOCUMENT_TYPES.document_type_code%TYPE
101: := PO_DOCUMENT_FUNDS_PVT.g_doc_type_PA
97: := PO_DOCUMENT_FUNDS_PVT.g_doc_type_PO
98: ;
99: g_doc_type_PA CONSTANT
100: PO_DOCUMENT_TYPES.document_type_code%TYPE
101: := PO_DOCUMENT_FUNDS_PVT.g_doc_type_PA
102: ;
103: g_doc_type_RELEASE CONSTANT
104: PO_DOCUMENT_TYPES.document_type_code%TYPE
105: := PO_DOCUMENT_FUNDS_PVT.g_doc_type_RELEASE
101: := PO_DOCUMENT_FUNDS_PVT.g_doc_type_PA
102: ;
103: g_doc_type_RELEASE CONSTANT
104: PO_DOCUMENT_TYPES.document_type_code%TYPE
105: := PO_DOCUMENT_FUNDS_PVT.g_doc_type_RELEASE
106: ;
107: g_doc_type_MIXED_PO_RELEASE CONSTANT
108: PO_DOCUMENT_TYPES.document_type_code%TYPE
109: := PO_DOCUMENT_FUNDS_PVT.g_doc_type_MIXED_PO_RELEASE
105: := PO_DOCUMENT_FUNDS_PVT.g_doc_type_RELEASE
106: ;
107: g_doc_type_MIXED_PO_RELEASE CONSTANT
108: PO_DOCUMENT_TYPES.document_type_code%TYPE
109: := PO_DOCUMENT_FUNDS_PVT.g_doc_type_MIXED_PO_RELEASE
110: ;
111:
112:
113: -- doc subtypes
112:
113: -- doc subtypes
114: g_doc_subtype_STANDARD CONSTANT
115: PO_HEADERS_ALL.type_lookup_code%TYPE
116: := PO_DOCUMENT_FUNDS_PVT.g_doc_subtype_STANDARD
117: ;
118: g_doc_subtype_PLANNED CONSTANT
119: PO_HEADERS_ALL.type_lookup_code%TYPE
120: := PO_DOCUMENT_FUNDS_PVT.g_doc_subtype_PLANNED
116: := PO_DOCUMENT_FUNDS_PVT.g_doc_subtype_STANDARD
117: ;
118: g_doc_subtype_PLANNED CONSTANT
119: PO_HEADERS_ALL.type_lookup_code%TYPE
120: := PO_DOCUMENT_FUNDS_PVT.g_doc_subtype_PLANNED
121: ;
122: g_doc_subtype_BLANKET CONSTANT
123: PO_RELEASES_ALL.release_type%TYPE
124: := PO_DOCUMENT_FUNDS_PVT.g_doc_subtype_BLANKET
120: := PO_DOCUMENT_FUNDS_PVT.g_doc_subtype_PLANNED
121: ;
122: g_doc_subtype_BLANKET CONSTANT
123: PO_RELEASES_ALL.release_type%TYPE
124: := PO_DOCUMENT_FUNDS_PVT.g_doc_subtype_BLANKET
125: ;
126: g_doc_subtype_SCHEDULED CONSTANT
127: PO_RELEASES_ALL.release_type%TYPE
128: := PO_DOCUMENT_FUNDS_PVT.g_doc_subtype_SCHEDULED
124: := PO_DOCUMENT_FUNDS_PVT.g_doc_subtype_BLANKET
125: ;
126: g_doc_subtype_SCHEDULED CONSTANT
127: PO_RELEASES_ALL.release_type%TYPE
128: := PO_DOCUMENT_FUNDS_PVT.g_doc_subtype_SCHEDULED
129: ;
130: g_doc_subtype_MIXED_PO_RELEASE CONSTANT
131: PO_HEADERS_ALL.type_lookup_code%TYPE
132: := PO_DOCUMENT_FUNDS_PVT.g_doc_subtype_MIXED_PO_RELEASE
128: := PO_DOCUMENT_FUNDS_PVT.g_doc_subtype_SCHEDULED
129: ;
130: g_doc_subtype_MIXED_PO_RELEASE CONSTANT
131: PO_HEADERS_ALL.type_lookup_code%TYPE
132: := PO_DOCUMENT_FUNDS_PVT.g_doc_subtype_MIXED_PO_RELEASE
133: ;
134:
135:
136: -- doc levels
135:
136: -- doc levels
137: g_doc_level_HEADER CONSTANT
138: VARCHAR2(25)
139: := PO_DOCUMENT_FUNDS_PVT.g_doc_level_HEADER
140: ;
141: g_doc_level_LINE CONSTANT
142: VARCHAR2(25)
143: := PO_DOCUMENT_FUNDS_PVT.g_doc_level_LINE
139: := PO_DOCUMENT_FUNDS_PVT.g_doc_level_HEADER
140: ;
141: g_doc_level_LINE CONSTANT
142: VARCHAR2(25)
143: := PO_DOCUMENT_FUNDS_PVT.g_doc_level_LINE
144: ;
145: g_doc_level_SHIPMENT CONSTANT
146: VARCHAR2(25)
147: := PO_DOCUMENT_FUNDS_PVT.g_doc_level_SHIPMENT
143: := PO_DOCUMENT_FUNDS_PVT.g_doc_level_LINE
144: ;
145: g_doc_level_SHIPMENT CONSTANT
146: VARCHAR2(25)
147: := PO_DOCUMENT_FUNDS_PVT.g_doc_level_SHIPMENT
148: ;
149: g_doc_level_DISTRIBUTION CONSTANT
150: VARCHAR2(25)
151: := PO_DOCUMENT_FUNDS_PVT.g_doc_level_DISTRIBUTION
147: := PO_DOCUMENT_FUNDS_PVT.g_doc_level_SHIPMENT
148: ;
149: g_doc_level_DISTRIBUTION CONSTANT
150: VARCHAR2(25)
151: := PO_DOCUMENT_FUNDS_PVT.g_doc_level_DISTRIBUTION
152: ;
153:
154:
155: -- distribution types
154:
155: -- distribution types
156: g_dist_type_STANDARD CONSTANT
157: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
158: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_STANDARD
159: ;
160: g_dist_type_PLANNED CONSTANT
161: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
162: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_PLANNED
158: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_STANDARD
159: ;
160: g_dist_type_PLANNED CONSTANT
161: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
162: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_PLANNED
163: ;
164: g_dist_type_SCHEDULED CONSTANT
165: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
166: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_SCHEDULED
162: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_PLANNED
163: ;
164: g_dist_type_SCHEDULED CONSTANT
165: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
166: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_SCHEDULED
167: ;
168: g_dist_type_BLANKET CONSTANT
169: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
170: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_BLANKET
166: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_SCHEDULED
167: ;
168: g_dist_type_BLANKET CONSTANT
169: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
170: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_BLANKET
171: ;
172: g_dist_type_AGREEMENT CONSTANT
173: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
174: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_AGREEMENT
170: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_BLANKET
171: ;
172: g_dist_type_AGREEMENT CONSTANT
173: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
174: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_AGREEMENT
175: ;
176: g_dist_type_REQUISITION CONSTANT
177: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
178: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_REQUISITION
174: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_AGREEMENT
175: ;
176: g_dist_type_REQUISITION CONSTANT
177: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
178: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_REQUISITION
179: ;
180: g_dist_type_MIXED_PO_RELEASE CONSTANT
181: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
182: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_MIXED_PO_RELEASE
178: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_REQUISITION
179: ;
180: g_dist_type_MIXED_PO_RELEASE CONSTANT
181: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
182: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_MIXED_PO_RELEASE
183: ;
184: g_dist_type_PREPAYMENT CONSTANT
185: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
186: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_PREPAYMENT
182: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_MIXED_PO_RELEASE
183: ;
184: g_dist_type_PREPAYMENT CONSTANT
185: PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
186: := PO_DOCUMENT_FUNDS_PVT.g_dist_type_PREPAYMENT
187: ;
188:
189: -- parameter values
190: g_parameter_YES CONSTANT
188:
189: -- parameter values
190: g_parameter_YES CONSTANT
191: VARCHAR2(1)
192: := PO_DOCUMENT_FUNDS_PVT.g_parameter_YES
193: ;
194: g_parameter_NO CONSTANT
195: VARCHAR2(1)
196: := PO_DOCUMENT_FUNDS_PVT.g_parameter_NO
192: := PO_DOCUMENT_FUNDS_PVT.g_parameter_YES
193: ;
194: g_parameter_NO CONSTANT
195: VARCHAR2(1)
196: := PO_DOCUMENT_FUNDS_PVT.g_parameter_NO
197: ;
198: g_parameter_USE_PROFILE CONSTANT
199: VARCHAR2(1)
200: := PO_DOCUMENT_FUNDS_PVT.g_parameter_USE_PROFILE
196: := PO_DOCUMENT_FUNDS_PVT.g_parameter_NO
197: ;
198: g_parameter_USE_PROFILE CONSTANT
199: VARCHAR2(1)
200: := PO_DOCUMENT_FUNDS_PVT.g_parameter_USE_PROFILE
201: ;
202:
203:
204: -- closed codes
269: g_date_format CONSTANT varchar2(25) := 'YYYY/MM/DD';
270:
271: -- result classifications
272: g_result_SUCCESS CONSTANT PO_ENCUMBRANCE_GT.result_type%TYPE
273: := PO_DOCUMENT_FUNDS_PVT.g_result_SUCCESS;
274:
275: g_result_WARNING CONSTANT PO_ENCUMBRANCE_GT.result_type%TYPE
276: := PO_DOCUMENT_FUNDS_PVT.g_result_WARNING;
277:
272: g_result_SUCCESS CONSTANT PO_ENCUMBRANCE_GT.result_type%TYPE
273: := PO_DOCUMENT_FUNDS_PVT.g_result_SUCCESS;
274:
275: g_result_WARNING CONSTANT PO_ENCUMBRANCE_GT.result_type%TYPE
276: := PO_DOCUMENT_FUNDS_PVT.g_result_WARNING;
277:
278: g_result_ERROR CONSTANT PO_ENCUMBRANCE_GT.result_type%TYPE
279: := PO_DOCUMENT_FUNDS_PVT.g_result_ERROR;
280:
275: g_result_WARNING CONSTANT PO_ENCUMBRANCE_GT.result_type%TYPE
276: := PO_DOCUMENT_FUNDS_PVT.g_result_WARNING;
277:
278: g_result_ERROR CONSTANT PO_ENCUMBRANCE_GT.result_type%TYPE
279: := PO_DOCUMENT_FUNDS_PVT.g_result_ERROR;
280:
281: --note: this classification currently maps to Warning, but is
282: --given a seperate label so as to easily identify this condition
283: g_result_NOT_PROCESSED CONSTANT PO_ENCUMBRANCE_GT.result_type%TYPE
280:
281: --note: this classification currently maps to Warning, but is
282: --given a seperate label so as to easily identify this condition
283: g_result_NOT_PROCESSED CONSTANT PO_ENCUMBRANCE_GT.result_type%TYPE
284: := PO_DOCUMENT_FUNDS_PVT.g_result_WARNING;
285:
286:
287: -- doc state check results
288: g_doc_state_valid_YES CONSTANT
740:
741: l_progress := '140';
742: IF g_debug_stmt THEN
743: PO_DEBUG.debug_var(l_log_head,l_progress,'req encumbrance'
744: , PO_DOCUMENT_FUNDS_PVT.g_req_encumbrance_on);
745: END IF;
746:
747: IF ((p_doc_type IN (g_doc_type_PO , g_doc_type_MIXED_PO_RELEASE)
748: --
747: IF ((p_doc_type IN (g_doc_type_PO , g_doc_type_MIXED_PO_RELEASE)
748: --
749: OR (p_doc_type = g_doc_type_RELEASE and p_doc_subtype = g_doc_subtype_BLANKET)
750: --
751: )AND PO_DOCUMENT_FUNDS_PVT.g_req_encumbrance_on)
752: THEN
753:
754: -- POs, PPOs, and Blanket Releases can have backing Reqs
755:
782:
783: l_progress := '200';
784: IF g_debug_stmt THEN
785: PO_DEBUG.debug_var(l_log_head,l_progress,'pa encumbrance'
786: , PO_DOCUMENT_FUNDS_PVT.g_pa_encumbrance_on);
787: END IF;
788:
789: IF ( p_doc_subtype IN ( g_doc_subtype_STANDARD,g_doc_subtype_BLANKET
790: , g_doc_subtype_MIXED_PO_RELEASE)
787: END IF;
788:
789: IF ( p_doc_subtype IN ( g_doc_subtype_STANDARD,g_doc_subtype_BLANKET
790: , g_doc_subtype_MIXED_PO_RELEASE)
791: AND PO_DOCUMENT_FUNDS_PVT.g_pa_encumbrance_on
792: )
793: THEN
794:
795: -- POs and Blanket Releases can have backing GAs/BPAs
1204: l_progress := '200';
1205:
1206: -- Fill the GTT with the data from the doc tables.
1207:
1208: PO_DOCUMENT_FUNDS_PVT.populate_encumbrance_gt(
1209: x_return_status => l_return_status
1210: , p_doc_type => l_doc_type
1211: , p_doc_level => l_doc_level
1212: , p_doc_level_id_tbl => l_doc_level_id_tbl
2704:
2705: -- Set up the global variables
2706: -- for the rest of the encumbrance flow.
2707:
2708: PO_DOCUMENT_FUNDS_PVT.g_req_encumbrance_on
2709: := PO_CORE_S.is_encumbrance_on(
2710: p_doc_type => g_doc_type_REQUISITION
2711: , p_org_id => NULL
2712: );
2712: );
2713:
2714: l_progress := '020';
2715:
2716: PO_DOCUMENT_FUNDS_PVT.g_po_encumbrance_on
2717: := PO_CORE_S.is_encumbrance_on(
2718: p_doc_type => g_doc_type_PO
2719: , p_org_id => NULL
2720: );
2720: );
2721:
2722: l_progress := '030';
2723:
2724: PO_DOCUMENT_FUNDS_PVT.g_pa_encumbrance_on
2725: := PO_CORE_S.is_encumbrance_on(
2726: p_doc_type => g_doc_type_PA
2727: , p_org_id => NULL
2728: );
2730: l_progress := '040';
2731:
2732: IF g_debug_stmt THEN
2733: PO_DEBUG.debug_var(l_log_head,l_progress,'req encumbrance'
2734: , PO_DOCUMENT_FUNDS_PVT.g_req_encumbrance_on);
2735: PO_DEBUG.debug_var(l_log_head,l_progress,'po encumbrance'
2736: , PO_DOCUMENT_FUNDS_PVT.g_po_encumbrance_on);
2737: PO_DEBUG.debug_var(l_log_head,l_progress,'pa encumbrance'
2738: , PO_DOCUMENT_FUNDS_PVT.g_pa_encumbrance_on);
2732: IF g_debug_stmt THEN
2733: PO_DEBUG.debug_var(l_log_head,l_progress,'req encumbrance'
2734: , PO_DOCUMENT_FUNDS_PVT.g_req_encumbrance_on);
2735: PO_DEBUG.debug_var(l_log_head,l_progress,'po encumbrance'
2736: , PO_DOCUMENT_FUNDS_PVT.g_po_encumbrance_on);
2737: PO_DEBUG.debug_var(l_log_head,l_progress,'pa encumbrance'
2738: , PO_DOCUMENT_FUNDS_PVT.g_pa_encumbrance_on);
2739: END IF;
2740:
2734: , PO_DOCUMENT_FUNDS_PVT.g_req_encumbrance_on);
2735: PO_DEBUG.debug_var(l_log_head,l_progress,'po encumbrance'
2736: , PO_DOCUMENT_FUNDS_PVT.g_po_encumbrance_on);
2737: PO_DEBUG.debug_var(l_log_head,l_progress,'pa encumbrance'
2738: , PO_DOCUMENT_FUNDS_PVT.g_pa_encumbrance_on);
2739: END IF;
2740:
2741: IF (p_doc_type = g_doc_type_REQUISITION) THEN
2742:
2741: IF (p_doc_type = g_doc_type_REQUISITION) THEN
2742:
2743: l_progress := '050';
2744:
2745: l_enc_on := PO_DOCUMENT_FUNDS_PVT.g_req_encumbrance_on;
2746:
2747: ELSIF (p_doc_type = g_doc_type_PA) THEN
2748:
2749: l_progress := '060';
2747: ELSIF (p_doc_type = g_doc_type_PA) THEN
2748:
2749: l_progress := '060';
2750:
2751: l_enc_on := PO_DOCUMENT_FUNDS_PVT.g_pa_encumbrance_on;
2752:
2753: ELSE
2754:
2755: l_progress := '070';
2753: ELSE
2754:
2755: l_progress := '070';
2756:
2757: l_enc_on := PO_DOCUMENT_FUNDS_PVT.g_po_encumbrance_on;
2758:
2759: END IF;
2760:
2761: IF g_debug_stmt THEN
2885: );
2886:
2887: l_progress := 'a80';
2888:
2889: PO_DOCUMENT_FUNDS_PVT.populate_encumbrance_gt(
2890: x_return_status => l_return_status
2891: , p_doc_type => l_doc_type
2892: , p_doc_level => l_doc_level
2893: , p_doc_level_id_tbl => l_doc_level_id_tbl
3943:
3944: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3945: RAISE;
3946:
3947: WHEN PO_DOCUMENT_FUNDS_PVT.G_NO_VALID_PERIOD_EXC THEN
3948: RAISE;
3949: WHEN PO_DOCUMENT_FUNDS_PVT.g_UOM_CONVERSION_EXC THEN
3950:
3951: --
3945: RAISE;
3946:
3947: WHEN PO_DOCUMENT_FUNDS_PVT.G_NO_VALID_PERIOD_EXC THEN
3948: RAISE;
3949: WHEN PO_DOCUMENT_FUNDS_PVT.g_UOM_CONVERSION_EXC THEN
3950:
3951: --
3952: -- Code to handle the UOM conversion Exception
3953: -- The result text and result type are updates as not processed distributions
4268: , DISTS.result_type = g_result_NOT_PROCESSED
4269: WHERE DISTS.period_name IS NOT NULL;
4270:
4271: --force x_return_status to E and stop processing
4272: RAISE PO_DOCUMENT_FUNDS_PVT.G_NO_VALID_PERIOD_EXC;
4273:
4274: END IF;
4275:
4276: END IF;
4294:
4295: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4296: RAISE;
4297:
4298: WHEN PO_DOCUMENT_FUNDS_PVT.G_NO_VALID_PERIOD_EXC THEN
4299: RAISE;
4300:
4301: WHEN OTHERS THEN
4302: --add message to the stack and log a debug msg if necessary
5078:
5079: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5080: RAISE;
5081:
5082: WHEN PO_DOCUMENT_FUNDS_PVT.g_UOM_CONVERSION_EXC THEN --
5084:
5085: WHEN OTHERS THEN
5086: --add message to the stack and log a debug msg if necessary
5803: AND REQ_DISTS.distribution_type = g_dist_type_REQUISITION
5804: AND REQ_DISTS.uom_conversion_rate = -999
5805: );
5806:
5807: RAISE PO_DOCUMENT_FUNDS_PVT.g_UOM_CONVERSION_EXC; --FND_API.G_EXC_ERROR
5808: END IF;
5809: --
5810:
5811: l_progress := '050';
6065:
6066: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6067: RAISE;
6068:
6069: WHEN PO_DOCUMENT_FUNDS_PVT.g_UOM_CONVERSION_EXC THEN --
6071:
6072: WHEN OTHERS THEN
6073: --add message to the stack and log a debug msg if necessary