DBA Data[Home] [Help]

APPS.PO_COPYDOC_S1 dependencies on PO_COPYDOC_S1

Line 1: PACKAGE BODY po_copydoc_s1 AS

1: PACKAGE BODY po_copydoc_s1 AS
2: /* $Header: POXCPO1B.pls 120.63.12020000.4 2013/02/25 09:23:49 mabaig ship $*/
3:
4: --< Shared Proc FPJ Start >
5: -- Debugging booleans used to bypass logging when turned off

Line 9: g_pkg_name CONSTANT VARCHAR2(20) := 'PO_COPYDOC_S1';

5: -- Debugging booleans used to bypass logging when turned off
6: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;
7: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;
8:
9: g_pkg_name CONSTANT VARCHAR2(20) := 'PO_COPYDOC_S1';
10: g_module_prefix CONSTANT VARCHAR2(30) := 'po.plsql.' || g_pkg_name || '.';
11: --< Shared Proc FPJ End >
12:
13: --

Line 328: d_module VARCHAR2(70) := 'po.plsql.PO_COPYDOC_S1.RET_AND_DEL_ONLINE_REPORT_REC';

324: ,x_message OUT NOCOPY VARCHAR2)
325: IS
326: pragma AUTONOMOUS_TRANSACTION;
327: d_pos NUMBER;
328: d_module VARCHAR2(70) := 'po.plsql.PO_COPYDOC_S1.RET_AND_DEL_ONLINE_REPORT_REC';
329: d_log_msg VARCHAR2(200);
330: /*Bug:13077836 start */
331: TYPE MsgTextLineTab IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
332: TYPE MsgTypeTab IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER;

Line 3574: d_module VARCHAR2(70) := 'po.plsql.PO_COPYDOC_S1.copy_document';

3570: l_clm_src_doc_id NUMBER;
3571: l_doc_number VARCHAR2(50);
3572: l_is_complex_finance_po VARCHAR2(10);
3573: l_is_clm_doc VARCHAR2(1) := 'N'; --
3574: d_module VARCHAR2(70) := 'po.plsql.PO_COPYDOC_S1.copy_document';
3575:
3576: BEGIN
3577: IF g_debug_stmt THEN --< Shared Proc FPJ > Add correct debugging
3578: PO_DEBUG.debug_stmt

Line 3598: po_copydoc_s1.COPYDOC_sql_error('copy_documents', x_progress, sqlcode,

3594: FROM SYS.DUAL;
3595: EXCEPTION
3596: WHEN OTHERS THEN
3597: x_online_report_id := NULL;
3598: po_copydoc_s1.COPYDOC_sql_error('copy_documents', x_progress, sqlcode,
3599: x_online_report_id,
3600: x_sequence,
3601: 0, 0, 0);
3602: END;

Line 3759: po_copydoc_s1.COPYDOC_sql_error('copy_documents', x_progress, sqlcode,

3755: AND POD.distribution_type = 'AGREEMENT';
3756:
3757: EXCEPTION
3758: WHEN TOO_MANY_ROWS THEN
3759: po_copydoc_s1.COPYDOC_sql_error('copy_documents', x_progress, sqlcode,
3760: x_online_report_id,
3761: x_sequence,
3762: 0, 0, 1);
3763: x_internal_return_code := -1;

Line 4441: d_module VARCHAR2(70) := 'po.plsql.PO_COPYDOC_S1.VAL_PARAMS_AND_DUPLICATE_DOC';

4437: l_sob_id FINANCIALS_SYSTEM_PARAMS_ALL.set_of_books_id%type;
4438: l_return_code NUMBER;
4439: l_online_report_id PO_ONLINE_REPORT_TEXT.online_report_id%type;
4440: d_pos NUMBER;
4441: d_module VARCHAR2(70) := 'po.plsql.PO_COPYDOC_S1.VAL_PARAMS_AND_DUPLICATE_DOC';
4442: d_log_msg VARCHAR2(200);
4443: BEGIN
4444: --Initialise the variables
4445: d_pos := 0;

Line 4497: IF(PO_COPYDOC_S1.po_is_dropship(p_po_header_id)) THEN

4493: END IF;
4494: END IF;
4495: d_pos := 30;
4496: --Check if the PO is a drop ship PO
4497: IF(PO_COPYDOC_S1.po_is_dropship(p_po_header_id)) THEN
4498: d_pos := 35;
4499: x_errmsg_code := 'PO_NOT_SUPPORT_COPY_DROPSHIPPO';
4500: IF PO_LOG.d_exc THEN
4501: PO_LOG.exc(d_module,d_pos,'Duplicate Document not supported for DropShip PO');

Line 4507: IF(PO_COPYDOC_S1.po_has_config_id(p_po_header_id)) THEN

4503: RAISE FND_API.g_exc_error;
4504: END IF;
4505: d_pos := 40;
4506: --Check if the PO has a config id associated with it
4507: IF(PO_COPYDOC_S1.po_has_config_id(p_po_header_id)) THEN
4508: d_pos := 45;
4509: x_errmsg_code := 'PO_CANNOT_COPY_CONFIG_ID_DOC';
4510: IF PO_LOG.d_exc THEN
4511: PO_LOG.exc(d_module,d_pos,'Duplicate Document not supported for PO with Config ID');

Line 4518: PO_LOG.event(d_module,d_pos,'Invoking PO_COPYDOC_S1.Copy Document Procedure');

4514: END IF;
4515: d_pos := 50;
4516: --If validations go thru fine invoke the copy_document procedure
4517: IF PO_LOG.d_event THEN
4518: PO_LOG.event(d_module,d_pos,'Invoking PO_COPYDOC_S1.Copy Document Procedure');
4519: END IF;
4520:
4521: copy_document (
4522: x_action_code => 'PO',

Line 4540: PO_LOG.event(d_module,d_pos,'PO_COPYDOC_S1.Copy Document Procedure call completed');

4536: x_copy_terms => p_copy_terms,
4537: p_api_commit => FALSE); --Do not Commit
4538:
4539: IF PO_LOG.d_event THEN
4540: PO_LOG.event(d_module,d_pos,'PO_COPYDOC_S1.Copy Document Procedure call completed');
4541: END IF;
4542: d_pos := 60;
4543: --If online_report_id is not null get the message
4544: IF (l_online_report_id is NOT NULL) THEN

Line 4546: PO_COPYDOC_S1.ret_and_del_online_report_rec( l_online_report_id

4542: d_pos := 60;
4543: --If online_report_id is not null get the message
4544: IF (l_online_report_id is NOT NULL) THEN
4545: d_pos := 65;
4546: PO_COPYDOC_S1.ret_and_del_online_report_rec( l_online_report_id
4547: ,x_message_type
4548: ,x_text_line);
4549: IF PO_LOG.d_stmt THEN
4550: PO_LOG.stmt(d_module,d_pos,'l_online_report_id',l_online_report_id);

Line 4588: PO_COPYDOC_S1.ret_and_del_online_report_rec( l_online_report_id

4584: END IF;
4585: WHEN OTHERS THEN
4586: x_return_status := FND_API.g_ret_sts_unexp_error;
4587: IF (l_online_report_id is NOT NULL) THEN
4588: PO_COPYDOC_S1.ret_and_del_online_report_rec( l_online_report_id
4589: ,x_message_type
4590: ,x_text_line);
4591: END IF;
4592: IF(x_text_line is not null) THEN

Line 4660: l_log_head CONSTANT VARCHAR2(100) := 'po_copydoc_s1';

4656: l_ags_table PO_TBL_VARCHAR30;
4657: --l_doc_num_ag_name VARCHAR2(30); --Bug 13482355
4658:
4659: l_api_name CONSTANT varchar2(30) := 'COPY_UDA_ATTRS';
4660: l_log_head CONSTANT VARCHAR2(100) := 'po_copydoc_s1';
4661: l_pk_col_name VARCHAR2(200);
4662:
4663: l_clm_delivery_event_code po_lines_all.clm_delivery_event_code%type;
4664:

Line 4958: p_pkg_name => 'po_copydoc_s1',

4954: EXCEPTION
4955: WHEN OTHERS THEN
4956: PO_MESSAGE_S.add_exc_msg
4957: (
4958: p_pkg_name => 'po_copydoc_s1',
4959: p_procedure_name => 'COPY_UDA_ATTRS' || '.' || l_progress
4960: );
4961: PO_DEBUG.debug_stmt(l_log_head || l_api_name, l_progress, SQLERRM);
4962: PO_DEBUG.debug_stmt(l_log_head || l_api_name, l_progress, 'Exception in COPY_UDA_ATTRS');

Line 4969: END po_copydoc_s1;

4965:
4966:
4967:
4968:
4969: END po_copydoc_s1;