APPS.PO_FBO_PKG dependencies on PO_FBO_PKG

Line 1: PACKAGE BODY PO_FBO_PKG AS

1: PACKAGE BODY PO_FBO_PKG AS
2: -- $Header: PO_FBO_PKG.plb 120.6 2012/02/10 11:40:23 inagdeo noship $
3:
4: ---------------------------------------------------------------------------
5: -- Modules for debugging.

Line 2: -- $Header: PO_FBO_PKG.plb 120.6 2012/02/10 11:40:23 inagdeo noship $

1: PACKAGE BODY PO_FBO_PKG AS
2: -- $Header: PO_FBO_PKG.plb 120.6 2012/02/10 11:40:23 inagdeo noship $
3:
4: ---------------------------------------------------------------------------
5: -- Modules for debugging.
6: ---------------------------------------------------------------------------

Line 7: g_log_head CONSTANT VARCHAR2(30) := 'po.plsql.PO_FBO_PKG.';

3:
4: ---------------------------------------------------------------------------
5: -- Modules for debugging.
6: ---------------------------------------------------------------------------
7: g_log_head CONSTANT VARCHAR2(30) := 'po.plsql.PO_FBO_PKG.';
8:
9:
10: ---------------------------------------------------------------------------
11: -- Private functions to get NAICS node and classification code.

Line 63: x_progress := 'PO_FBO_PKG.IS_SOURCING_INSTALLED : ' || l_is_sourcing_installed;

59: l_is_sourcing_installed := 'N';
60:
61: END;
62:
63: x_progress := 'PO_FBO_PKG.IS_SOURCING_INSTALLED : ' || l_is_sourcing_installed;
64: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
65:
66: resultout := wf_engine.eng_completed || ':' || l_is_sourcing_installed;
67:

Line 109: x_progress := 'PO_FBO_PKG.HAS_ASSOCIATED_SOLICITATION Solicitation No : ' || l_solicitation_no;

105:
106: PON_FBO_PKG.backing_solicitation_info(l_document_id,l_solicitation_no,
107: l_solicitation_title);
108:
109: x_progress := 'PO_FBO_PKG.HAS_ASSOCIATED_SOLICITATION Solicitation No : ' || l_solicitation_no;
110: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
111:
112:
113: IF l_solicitation_no IS NOT NULL THEN

Line 157: x_progress := 'PO_FBO_PKG.SUBMIT_AWARD_NOTICE';

153: submission_error exception;
154:
155: BEGIN
156:
157: x_progress := 'PO_FBO_PKG.SUBMIT_AWARD_NOTICE';
158: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
159:
160:
161: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

Line 182: x_progress := 'PO_FBO_PKG.SUBMIT_AWARD_NOTICE : Request id : ' || l_request_id;

178: raise submission_error;
179: END IF;
180:
181:
182: x_progress := 'PO_FBO_PKG.SUBMIT_AWARD_NOTICE : Request id : ' || l_request_id;
183: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, x_progress);
184:
185:
186: INSERT_IN_PON_FBO_POSTS(l_document_id,'FED_AWARD',l_request_id);

Line 196: x_progress := 'PO_FBO_PKG.SUBMIT_AWARD_NOTICE: Exception submitting concurrent request: ' || fnd_message.get;

192: EXCEPTION
193:
194: WHEN submission_error THEN
195:
196: x_progress := 'PO_FBO_PKG.SUBMIT_AWARD_NOTICE: Exception submitting concurrent request: ' || fnd_message.get;
197: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, x_progress);
198:
199: wf_core.context('PO_FBO_PKG', 'SUBMIT_AWARD_NOTICE', x_progress);
200: RAISE;

Line 199: wf_core.context('PO_FBO_PKG', 'SUBMIT_AWARD_NOTICE', x_progress);

195:
196: x_progress := 'PO_FBO_PKG.SUBMIT_AWARD_NOTICE: Exception submitting concurrent request: ' || fnd_message.get;
197: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, x_progress);
198:
199: wf_core.context('PO_FBO_PKG', 'SUBMIT_AWARD_NOTICE', x_progress);
200: RAISE;
201:
202: WHEN OTHERS THEN
203:

Line 204: x_progress := 'PO_FBO_PKG.SUBMIT_AWARD_NOTICE : In Exception handler';

200: RAISE;
201:
202: WHEN OTHERS THEN
203:
204: x_progress := 'PO_FBO_PKG.SUBMIT_AWARD_NOTICE : In Exception handler';
205: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, x_progress);
206:
207: wf_core.context('PO_FBO_PKG', 'SUBMIT_AWARD_NOTICE', x_progress);
208: RAISE;

Line 207: wf_core.context('PO_FBO_PKG', 'SUBMIT_AWARD_NOTICE', x_progress);

203:
204: x_progress := 'PO_FBO_PKG.SUBMIT_AWARD_NOTICE : In Exception handler';
205: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, x_progress);
206:
207: wf_core.context('PO_FBO_PKG', 'SUBMIT_AWARD_NOTICE', x_progress);
208: RAISE;
209:
210:
211: END SUBMIT_AWARD_NOTICE;

Line 397: PO_FBO_PKG.ENCODE_BLOB

393:
394: l_attach_query := '(SELECT xmlelement("files",
395: xmlagg(xmlelement("file",
396: xmlforest(fl.file_name "filename",
397: PO_FBO_PKG.ENCODE_BLOB
398: (fl.file_data) "filedata",
399: d.description "desc"))))
400: FROM fnd_documents_vl d,
401: fnd_attached_documents ad,

Line 783: END PO_FBO_PKG;

779: x_result := 'S';
780:
781: END VALIDATE_FBO_POSTING;
782:
783: END PO_FBO_PKG;