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.PO_DOCUMENT_ARCHIVE_PVT dependencies on PO_LOG

Line 9: D_PACKAGE_BASE CONSTANT VARCHAR2(50) := PO_LOG.get_package_base(G_PKG_NAME);

5: G_MODULE_PREFIX CONSTANT VARCHAR2(60) := 'po.plsql.' || G_PKG_NAME || '.';
6: G_FND_DEBUG VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
7: G_FND_DEBUG_LEVEL VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_LEVEL'),'0');
8:
9: D_PACKAGE_BASE CONSTANT VARCHAR2(50) := PO_LOG.get_package_base(G_PKG_NAME);
10: D_archive_attribute_values CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'archive_attribute_values');
11: D_archive_attr_values_tlp CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'archive_attr_values_tlp');
12:
13: --

Line 10: D_archive_attribute_values CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'archive_attribute_values');

6: G_FND_DEBUG VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
7: G_FND_DEBUG_LEVEL VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_LEVEL'),'0');
8:
9: D_PACKAGE_BASE CONSTANT VARCHAR2(50) := PO_LOG.get_package_base(G_PKG_NAME);
10: D_archive_attribute_values CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'archive_attribute_values');
11: D_archive_attr_values_tlp CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'archive_attr_values_tlp');
12:
13: --
14: D_archive_price_adjustments CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'archive_price_adjustments');

Line 11: D_archive_attr_values_tlp CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'archive_attr_values_tlp');

7: G_FND_DEBUG_LEVEL VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_LEVEL'),'0');
8:
9: D_PACKAGE_BASE CONSTANT VARCHAR2(50) := PO_LOG.get_package_base(G_PKG_NAME);
10: D_archive_attribute_values CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'archive_attribute_values');
11: D_archive_attr_values_tlp CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'archive_attr_values_tlp');
12:
13: --
14: D_archive_price_adjustments CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'archive_price_adjustments');
15: D_archive_price_adj_attribs CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'archive_price_adj_attribs');

Line 14: D_archive_price_adjustments CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'archive_price_adjustments');

10: D_archive_attribute_values CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'archive_attribute_values');
11: D_archive_attr_values_tlp CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'archive_attr_values_tlp');
12:
13: --
14: D_archive_price_adjustments CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'archive_price_adjustments');
15: D_archive_price_adj_attribs CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'archive_price_adj_attribs');
16: --
17:
18: PROCEDURE archive_attribute_values

Line 15: D_archive_price_adj_attribs CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'archive_price_adj_attribs');

11: D_archive_attr_values_tlp CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'archive_attr_values_tlp');
12:
13: --
14: D_archive_price_adjustments CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'archive_price_adjustments');
15: D_archive_price_adj_attribs CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'archive_price_adj_attribs');
16: --
17:
18: PROCEDURE archive_attribute_values
19: (

Line 3976: IF PO_LOG.d_proc THEN

3972:
3973: BEGIN
3974: l_progress := '000';
3975:
3976: IF PO_LOG.d_proc THEN
3977: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);
3978: PO_LOG.proc_begin(d_mod,'p_revision_num',p_revision_num);
3979: END IF;
3980:

Line 3977: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);

3973: BEGIN
3974: l_progress := '000';
3975:
3976: IF PO_LOG.d_proc THEN
3977: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);
3978: PO_LOG.proc_begin(d_mod,'p_revision_num',p_revision_num);
3979: END IF;
3980:
3981: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Calling INSERT'); END IF;

Line 3978: PO_LOG.proc_begin(d_mod,'p_revision_num',p_revision_num);

3974: l_progress := '000';
3975:
3976: IF PO_LOG.d_proc THEN
3977: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);
3978: PO_LOG.proc_begin(d_mod,'p_revision_num',p_revision_num);
3979: END IF;
3980:
3981: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Calling INSERT'); END IF;
3982:

Line 3981: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Calling INSERT'); END IF;

3977: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);
3978: PO_LOG.proc_begin(d_mod,'p_revision_num',p_revision_num);
3979: END IF;
3980:
3981: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Calling INSERT'); END IF;
3982:
3983: l_progress := '010';
3984:
3985: -- bug 10349444

Line 4678: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of rows INSERTed into ATTR archive='||SQL%rowcount); END IF;

4674: AND PAVA2.revision_num = p_revision_num);
4675: END LOOP;
4676: CLOSE c;
4677:
4678: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of rows INSERTed into ATTR archive='||SQL%rowcount); END IF;
4679:
4680: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
4681: EXCEPTION
4682: WHEN OTHERS THEN

Line 4680: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;

4676: CLOSE c;
4677:
4678: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of rows INSERTed into ATTR archive='||SQL%rowcount); END IF;
4679:
4680: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
4681: EXCEPTION
4682: WHEN OTHERS THEN
4683: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
4684: RAISE;

Line 4683: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;

4679:
4680: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
4681: EXCEPTION
4682: WHEN OTHERS THEN
4683: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
4684: RAISE;
4685: END archive_attribute_values;
4686:
4687: -------------------------------------------------------------------------------

Line 4725: IF PO_LOG.d_proc THEN

4721:
4722: BEGIN
4723: l_progress := '000';
4724:
4725: IF PO_LOG.d_proc THEN
4726: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);
4727: PO_LOG.proc_begin(d_mod,'p_revision_num',p_revision_num);
4728: END IF;
4729:

Line 4726: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);

4722: BEGIN
4723: l_progress := '000';
4724:
4725: IF PO_LOG.d_proc THEN
4726: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);
4727: PO_LOG.proc_begin(d_mod,'p_revision_num',p_revision_num);
4728: END IF;
4729:
4730: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Calling INSERT'); END IF;

Line 4727: PO_LOG.proc_begin(d_mod,'p_revision_num',p_revision_num);

4723: l_progress := '000';
4724:
4725: IF PO_LOG.d_proc THEN
4726: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);
4727: PO_LOG.proc_begin(d_mod,'p_revision_num',p_revision_num);
4728: END IF;
4729:
4730: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Calling INSERT'); END IF;
4731:

Line 4730: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Calling INSERT'); END IF;

4726: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);
4727: PO_LOG.proc_begin(d_mod,'p_revision_num',p_revision_num);
4728: END IF;
4729:
4730: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Calling INSERT'); END IF;
4731:
4732: l_progress := '010';
4733:
4734: -- bug 10349444

Line 5121: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of rows INSERTed into TLP archive='||SQL%rowcount); END IF;

5117: AND PAVTA2.revision_num = p_revision_num);
5118: END LOOP;
5119: CLOSE c;
5120:
5121: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of rows INSERTed into TLP archive='||SQL%rowcount); END IF;
5122:
5123: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
5124: EXCEPTION
5125: WHEN OTHERS THEN

Line 5123: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;

5119: CLOSE c;
5120:
5121: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of rows INSERTed into TLP archive='||SQL%rowcount); END IF;
5122:
5123: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
5124: EXCEPTION
5125: WHEN OTHERS THEN
5126: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
5127: RAISE;

Line 5126: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;

5122:
5123: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
5124: EXCEPTION
5125: WHEN OTHERS THEN
5126: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
5127: RAISE;
5128: END archive_attr_values_tlp;
5129:
5130: --

Line 5160: IF PO_LOG.d_proc THEN

5156: l_progress VARCHAR2(4) := '000';
5157: BEGIN
5158: l_progress := '000';
5159:
5160: IF PO_LOG.d_proc THEN
5161: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);
5162: PO_LOG.proc_begin(d_mod,'p_revision_num',p_revision_num);
5163: END IF;
5164:

Line 5161: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);

5157: BEGIN
5158: l_progress := '000';
5159:
5160: IF PO_LOG.d_proc THEN
5161: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);
5162: PO_LOG.proc_begin(d_mod,'p_revision_num',p_revision_num);
5163: END IF;
5164:
5165: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Calling INSERT'); END IF;

Line 5162: PO_LOG.proc_begin(d_mod,'p_revision_num',p_revision_num);

5158: l_progress := '000';
5159:
5160: IF PO_LOG.d_proc THEN
5161: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);
5162: PO_LOG.proc_begin(d_mod,'p_revision_num',p_revision_num);
5163: END IF;
5164:
5165: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Calling INSERT'); END IF;
5166:

Line 5165: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Calling INSERT'); END IF;

5161: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);
5162: PO_LOG.proc_begin(d_mod,'p_revision_num',p_revision_num);
5163: END IF;
5164:
5165: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Calling INSERT'); END IF;
5166:
5167: l_progress := '010';
5168: INSERT INTO PO_PRICE_ADJUSTMENTS_ARCHIVE
5169: (

Line 5383: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of rows INSERTed into PRICE ADJUSTMENTS archive='||SQL%rowcount); END IF;

5379: PO_LINES_ALL POL
5380: WHERE ADJ.po_line_id = POL.po_line_id
5381: AND POL.po_header_id = p_po_header_id;
5382:
5383: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of rows INSERTed into PRICE ADJUSTMENTS archive='||SQL%rowcount); END IF;
5384:
5385: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
5386: EXCEPTION
5387: WHEN OTHERS THEN

Line 5385: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;

5381: AND POL.po_header_id = p_po_header_id;
5382:
5383: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of rows INSERTed into PRICE ADJUSTMENTS archive='||SQL%rowcount); END IF;
5384:
5385: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
5386: EXCEPTION
5387: WHEN OTHERS THEN
5388: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
5389: RAISE;

Line 5388: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;

5384:
5385: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
5386: EXCEPTION
5387: WHEN OTHERS THEN
5388: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
5389: RAISE;
5390: END archive_price_adjustments;
5391:
5392: -------------------------------------------------------------------------------

Line 5422: IF PO_LOG.d_proc THEN

5418: l_progress VARCHAR2(4) := '000';
5419: BEGIN
5420: l_progress := '000';
5421:
5422: IF PO_LOG.d_proc THEN
5423: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);
5424: PO_LOG.proc_begin(d_mod,'p_revision_num',p_revision_num);
5425: END IF;
5426:

Line 5423: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);

5419: BEGIN
5420: l_progress := '000';
5421:
5422: IF PO_LOG.d_proc THEN
5423: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);
5424: PO_LOG.proc_begin(d_mod,'p_revision_num',p_revision_num);
5425: END IF;
5426:
5427: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Calling INSERT'); END IF;

Line 5424: PO_LOG.proc_begin(d_mod,'p_revision_num',p_revision_num);

5420: l_progress := '000';
5421:
5422: IF PO_LOG.d_proc THEN
5423: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);
5424: PO_LOG.proc_begin(d_mod,'p_revision_num',p_revision_num);
5425: END IF;
5426:
5427: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Calling INSERT'); END IF;
5428:

Line 5427: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Calling INSERT'); END IF;

5423: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);
5424: PO_LOG.proc_begin(d_mod,'p_revision_num',p_revision_num);
5425: END IF;
5426:
5427: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Calling INSERT'); END IF;
5428:
5429: l_progress := '010';
5430: INSERT INTO PO_PRICE_ADJ_ATTRIBS_ARCHIVE
5431: (

Line 5479: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of rows INSERTed into PRICE ADJUSTMENT ATTRIBUTES archive='||SQL%rowcount); END IF;

5475: WHERE ATTR.price_adjustment_id = ADJ.price_adjustment_id
5476: AND ADJ.po_line_id = POL.po_line_id
5477: AND POL.po_header_id = p_po_header_id;
5478:
5479: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of rows INSERTed into PRICE ADJUSTMENT ATTRIBUTES archive='||SQL%rowcount); END IF;
5480:
5481: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
5482: EXCEPTION
5483: WHEN OTHERS THEN

Line 5481: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;

5477: AND POL.po_header_id = p_po_header_id;
5478:
5479: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of rows INSERTed into PRICE ADJUSTMENT ATTRIBUTES archive='||SQL%rowcount); END IF;
5480:
5481: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
5482: EXCEPTION
5483: WHEN OTHERS THEN
5484: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
5485: RAISE;

Line 5484: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;

5480:
5481: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
5482: EXCEPTION
5483: WHEN OTHERS THEN
5484: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
5485: RAISE;
5486: END archive_price_adj_attribs;
5487: --
5488:

Line 5541: IF PO_LOG.d_proc THEN

5537:
5538: BEGIN
5539: l_progress := '000';
5540:
5541: IF PO_LOG.d_proc THEN
5542: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);
5543: PO_LOG.proc_begin(d_mod,'p_revision_num',p_revision_num);
5544: END IF;
5545:

Line 5542: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);

5538: BEGIN
5539: l_progress := '000';
5540:
5541: IF PO_LOG.d_proc THEN
5542: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);
5543: PO_LOG.proc_begin(d_mod,'p_revision_num',p_revision_num);
5544: END IF;
5545:
5546: -- Check if Document is UDA Enabled

Line 5543: PO_LOG.proc_begin(d_mod,'p_revision_num',p_revision_num);

5539: l_progress := '000';
5540:
5541: IF PO_LOG.d_proc THEN
5542: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);
5543: PO_LOG.proc_begin(d_mod,'p_revision_num',p_revision_num);
5544: END IF;
5545:
5546: -- Check if Document is UDA Enabled
5547: SELECT 'PURCHASING', TYPE_LOOKUP_CODE, STYLE_ID

Line 5553: IF PO_LOG.d_stmt THEN

5549: FROM po_headers_all
5550: WHERE PO_HEADER_ID = p_po_header_id;
5551:
5552: l_progress := '010';
5553: IF PO_LOG.d_stmt THEN
5554: PO_LOG.stmt(d_mod,l_progress,'Before Check_Uda_Enabled');
5555: END IF;
5556:
5557: PO_CLM_CLO_UTIL.Check_Uda_Enabled

Line 5554: PO_LOG.stmt(d_mod,l_progress,'Before Check_Uda_Enabled');

5550: WHERE PO_HEADER_ID = p_po_header_id;
5551:
5552: l_progress := '010';
5553: IF PO_LOG.d_stmt THEN
5554: PO_LOG.stmt(d_mod,l_progress,'Before Check_Uda_Enabled');
5555: END IF;
5556:
5557: PO_CLM_CLO_UTIL.Check_Uda_Enabled
5558: (

Line 5570: IF PO_LOG.d_stmt THEN

5566: ,x_msg_data => l_msg_data
5567: );
5568:
5569: l_progress := '020';
5570: IF PO_LOG.d_stmt THEN
5571: PO_LOG.stmt(d_mod,l_progress,'After Check_Uda_Enabled with x_return_status : ' || l_return_status);
5572: END IF;
5573:
5574: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 5571: PO_LOG.stmt(d_mod,l_progress,'After Check_Uda_Enabled with x_return_status : ' || l_return_status);

5567: );
5568:
5569: l_progress := '020';
5570: IF PO_LOG.d_stmt THEN
5571: PO_LOG.stmt(d_mod,l_progress,'After Check_Uda_Enabled with x_return_status : ' || l_return_status);
5572: END IF;
5573:
5574: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5583: IF PO_LOG.d_stmt THEN

5579: -- Archive UDA data only for UDA_enabled Docs, and only for DocTypes PO and PA
5580: IF l_enabled_flag = 'Y' AND p_document_type IN ('PO', 'PA') THEN
5581: -- Start PO_HEADERS_ALL_EXT_B_ARCHIVE
5582: l_progress := '030';
5583: IF PO_LOG.d_stmt THEN
5584: PO_LOG.stmt(d_mod,l_progress,'Archive PO_HEADERS_ALL_EXT_B');
5585: END IF;
5586:
5587: -- : Setting the latest_external_flag to N for all old records.

Line 5584: PO_LOG.stmt(d_mod,l_progress,'Archive PO_HEADERS_ALL_EXT_B');

5580: IF l_enabled_flag = 'Y' AND p_document_type IN ('PO', 'PA') THEN
5581: -- Start PO_HEADERS_ALL_EXT_B_ARCHIVE
5582: l_progress := '030';
5583: IF PO_LOG.d_stmt THEN
5584: PO_LOG.stmt(d_mod,l_progress,'Archive PO_HEADERS_ALL_EXT_B');
5585: END IF;
5586:
5587: -- : Setting the latest_external_flag to N for all old records.
5588: UPDATE PO_HEADERS_ALL_EXT_B_ARCHIVE

Line 5817: IF PO_LOG.d_stmt THEN

5813: WHERE po_header_id = p_po_header_id
5814: AND draft_id = -1;
5815:
5816: l_progress := '040';
5817: IF PO_LOG.d_stmt THEN
5818: PO_LOG.stmt(d_mod,l_progress,'Number of rows inserted: '||SQL%rowcount);
5819: END IF;
5820: -- End PO_HEADERS_ALL_EXT_B_ARCHIVE
5821:

Line 5818: PO_LOG.stmt(d_mod,l_progress,'Number of rows inserted: '||SQL%rowcount);

5814: AND draft_id = -1;
5815:
5816: l_progress := '040';
5817: IF PO_LOG.d_stmt THEN
5818: PO_LOG.stmt(d_mod,l_progress,'Number of rows inserted: '||SQL%rowcount);
5819: END IF;
5820: -- End PO_HEADERS_ALL_EXT_B_ARCHIVE
5821:
5822: -- Start PO_HEADERS_ALL_EXT_TL_ARCHIVE

Line 5824: IF PO_LOG.d_stmt THEN

5820: -- End PO_HEADERS_ALL_EXT_B_ARCHIVE
5821:
5822: -- Start PO_HEADERS_ALL_EXT_TL_ARCHIVE
5823: l_progress := '050';
5824: IF PO_LOG.d_stmt THEN
5825: PO_LOG.stmt(d_mod,l_progress,'Archive PO_HEADERS_ALL_EXT_TL');
5826: END IF;
5827:
5828: INSERT INTO PO_HEADERS_ALL_EXT_TL_ARCHIVE

Line 5825: PO_LOG.stmt(d_mod,l_progress,'Archive PO_HEADERS_ALL_EXT_TL');

5821:
5822: -- Start PO_HEADERS_ALL_EXT_TL_ARCHIVE
5823: l_progress := '050';
5824: IF PO_LOG.d_stmt THEN
5825: PO_LOG.stmt(d_mod,l_progress,'Archive PO_HEADERS_ALL_EXT_TL');
5826: END IF;
5827:
5828: INSERT INTO PO_HEADERS_ALL_EXT_TL_ARCHIVE
5829: (EXTENSION_ID

Line 5956: IF PO_LOG.d_stmt THEN

5952: WHERE po_header_id = p_po_header_id
5953: AND draft_id = -1;
5954:
5955: l_progress := '060';
5956: IF PO_LOG.d_stmt THEN
5957: PO_LOG.stmt(d_mod,l_progress,'Number of rows inserted: '||SQL%rowcount);
5958: END IF;
5959: -- End PO_HEADERS_ALL_EXT_TL_ARCHIVE
5960:

Line 5957: PO_LOG.stmt(d_mod,l_progress,'Number of rows inserted: '||SQL%rowcount);

5953: AND draft_id = -1;
5954:
5955: l_progress := '060';
5956: IF PO_LOG.d_stmt THEN
5957: PO_LOG.stmt(d_mod,l_progress,'Number of rows inserted: '||SQL%rowcount);
5958: END IF;
5959: -- End PO_HEADERS_ALL_EXT_TL_ARCHIVE
5960:
5961: -- Archive UDA Line and Line Locations data only for PO or PA BLANKETS

Line 5967: IF PO_LOG.d_stmt THEN

5963: (p_document_type = 'PA' AND p_document_subtype='BLANKET') THEN
5964:
5965: -- Start PO_LINES_ALL_EXT_B_ARCHIVE
5966: l_progress := '070';
5967: IF PO_LOG.d_stmt THEN
5968: PO_LOG.stmt(d_mod,l_progress,'Archive PO_LINES_ALL_EXT_B');
5969: END IF;
5970:
5971: INSERT INTO PO_LINES_ALL_EXT_B_ARCHIVE

Line 5968: PO_LOG.stmt(d_mod,l_progress,'Archive PO_LINES_ALL_EXT_B');

5964:
5965: -- Start PO_LINES_ALL_EXT_B_ARCHIVE
5966: l_progress := '070';
5967: IF PO_LOG.d_stmt THEN
5968: PO_LOG.stmt(d_mod,l_progress,'Archive PO_LINES_ALL_EXT_B');
5969: END IF;
5970:
5971: INSERT INTO PO_LINES_ALL_EXT_B_ARCHIVE
5972: (EXTENSION_ID

Line 6205: IF PO_LOG.d_stmt THEN

6201: --
6202: IF (SQL%ROWCOUNT > 0) THEN
6203:
6204: l_progress := '080';
6205: IF PO_LOG.d_stmt THEN
6206: PO_LOG.stmt(d_mod,l_progress,'Number of rows inserted: '||SQL%rowcount);
6207: PO_LOG.stmt(d_mod,l_progress,'Update PO_LINES_ALL_EXT_B_ARCHIVE to reset latest_external_flag');
6208: END IF;
6209:

Line 6206: PO_LOG.stmt(d_mod,l_progress,'Number of rows inserted: '||SQL%rowcount);

6202: IF (SQL%ROWCOUNT > 0) THEN
6203:
6204: l_progress := '080';
6205: IF PO_LOG.d_stmt THEN
6206: PO_LOG.stmt(d_mod,l_progress,'Number of rows inserted: '||SQL%rowcount);
6207: PO_LOG.stmt(d_mod,l_progress,'Update PO_LINES_ALL_EXT_B_ARCHIVE to reset latest_external_flag');
6208: END IF;
6209:
6210: -- If a row was inserted into PO_LINES_ARCHIVE, then set the appropriate flags

Line 6207: PO_LOG.stmt(d_mod,l_progress,'Update PO_LINES_ALL_EXT_B_ARCHIVE to reset latest_external_flag');

6203:
6204: l_progress := '080';
6205: IF PO_LOG.d_stmt THEN
6206: PO_LOG.stmt(d_mod,l_progress,'Number of rows inserted: '||SQL%rowcount);
6207: PO_LOG.stmt(d_mod,l_progress,'Update PO_LINES_ALL_EXT_B_ARCHIVE to reset latest_external_flag');
6208: END IF;
6209:
6210: -- If a row was inserted into PO_LINES_ARCHIVE, then set the appropriate flags
6211: UPDATE PO_LINES_ALL_EXT_B_ARCHIVE POL1

Line 6225: IF PO_LOG.d_stmt THEN

6221: AND POL2.latest_external_flag = 'Y'
6222: AND POL2.revision_num = p_revision_num
6223: AND POL2.attr_group_id = POL1.attr_group_id);
6224:
6225: IF PO_LOG.d_stmt THEN
6226: PO_LOG.stmt(d_mod,l_progress,'Number of rows updated: '||SQL%rowcount);
6227: END IF;
6228: END IF;
6229: --

Line 6226: PO_LOG.stmt(d_mod,l_progress,'Number of rows updated: '||SQL%rowcount);

6222: AND POL2.revision_num = p_revision_num
6223: AND POL2.attr_group_id = POL1.attr_group_id);
6224:
6225: IF PO_LOG.d_stmt THEN
6226: PO_LOG.stmt(d_mod,l_progress,'Number of rows updated: '||SQL%rowcount);
6227: END IF;
6228: END IF;
6229: --
6230: -- End PO_LINES_ALL_EXT_B_ARCHIVE

Line 6234: IF PO_LOG.d_stmt THEN

6230: -- End PO_LINES_ALL_EXT_B_ARCHIVE
6231:
6232: -- Start PO_LINES_ALL_EXT_TL_ARCHIVE
6233: l_progress := '090';
6234: IF PO_LOG.d_stmt THEN
6235: PO_LOG.stmt(d_mod,l_progress,'Archive PO_LINES_ALL_EXT_TL');
6236: END IF;
6237:
6238: INSERT INTO PO_LINES_ALL_EXT_TL_ARCHIVE

Line 6235: PO_LOG.stmt(d_mod,l_progress,'Archive PO_LINES_ALL_EXT_TL');

6231:
6232: -- Start PO_LINES_ALL_EXT_TL_ARCHIVE
6233: l_progress := '090';
6234: IF PO_LOG.d_stmt THEN
6235: PO_LOG.stmt(d_mod,l_progress,'Archive PO_LINES_ALL_EXT_TL');
6236: END IF;
6237:
6238: INSERT INTO PO_LINES_ALL_EXT_TL_ARCHIVE
6239: (EXTENSION_ID

Line 6368: IF PO_LOG.d_stmt THEN

6364: AND POL.po_line_id = POLE.po_line_id
6365: AND POLE.draft_id = -1;
6366:
6367: l_progress := '100';
6368: IF PO_LOG.d_stmt THEN
6369: PO_LOG.stmt(d_mod,l_progress,'Number of rows inserted: '||SQL%rowcount);
6370: END IF;
6371: -- End PO_LINES_ALL_EXT_TL_ARCHIVE
6372:

Line 6369: PO_LOG.stmt(d_mod,l_progress,'Number of rows inserted: '||SQL%rowcount);

6365: AND POLE.draft_id = -1;
6366:
6367: l_progress := '100';
6368: IF PO_LOG.d_stmt THEN
6369: PO_LOG.stmt(d_mod,l_progress,'Number of rows inserted: '||SQL%rowcount);
6370: END IF;
6371: -- End PO_LINES_ALL_EXT_TL_ARCHIVE
6372:
6373: -- Start PO_LINE_LOC_ALL_EXT_B_ARCHIVE

Line 6375: IF PO_LOG.d_stmt THEN

6371: -- End PO_LINES_ALL_EXT_TL_ARCHIVE
6372:
6373: -- Start PO_LINE_LOC_ALL_EXT_B_ARCHIVE
6374: l_progress := '110';
6375: IF PO_LOG.d_stmt THEN
6376: PO_LOG.stmt(d_mod,l_progress,'Archive PO_LINE_LOCATIONS_ALL_EXT_B');
6377: END IF;
6378:
6379: INSERT INTO PO_LINE_LOC_ALL_EXT_B_ARCHIVE

Line 6376: PO_LOG.stmt(d_mod,l_progress,'Archive PO_LINE_LOCATIONS_ALL_EXT_B');

6372:
6373: -- Start PO_LINE_LOC_ALL_EXT_B_ARCHIVE
6374: l_progress := '110';
6375: IF PO_LOG.d_stmt THEN
6376: PO_LOG.stmt(d_mod,l_progress,'Archive PO_LINE_LOCATIONS_ALL_EXT_B');
6377: END IF;
6378:
6379: INSERT INTO PO_LINE_LOC_ALL_EXT_B_ARCHIVE
6380: (EXTENSION_ID

Line 6612: IF PO_LOG.d_stmt THEN

6608:
6609: IF (SQL%ROWCOUNT > 0) THEN
6610:
6611: l_progress := '120';
6612: IF PO_LOG.d_stmt THEN
6613: PO_LOG.stmt(d_mod,l_progress,'Number of rows inserted: '||SQL%rowcount);
6614: PO_LOG.stmt(d_mod,l_progress,'Update PO_LINES_ALL_EXT_B_ARCHIVE to reset latest_external_flag');
6615: END IF;
6616:

Line 6613: PO_LOG.stmt(d_mod,l_progress,'Number of rows inserted: '||SQL%rowcount);

6609: IF (SQL%ROWCOUNT > 0) THEN
6610:
6611: l_progress := '120';
6612: IF PO_LOG.d_stmt THEN
6613: PO_LOG.stmt(d_mod,l_progress,'Number of rows inserted: '||SQL%rowcount);
6614: PO_LOG.stmt(d_mod,l_progress,'Update PO_LINES_ALL_EXT_B_ARCHIVE to reset latest_external_flag');
6615: END IF;
6616:
6617: -- If a row was inserted into PO_LINES_ARCHIVE, then set the appropriate flags

Line 6614: PO_LOG.stmt(d_mod,l_progress,'Update PO_LINES_ALL_EXT_B_ARCHIVE to reset latest_external_flag');

6610:
6611: l_progress := '120';
6612: IF PO_LOG.d_stmt THEN
6613: PO_LOG.stmt(d_mod,l_progress,'Number of rows inserted: '||SQL%rowcount);
6614: PO_LOG.stmt(d_mod,l_progress,'Update PO_LINES_ALL_EXT_B_ARCHIVE to reset latest_external_flag');
6615: END IF;
6616:
6617: -- If a row was inserted into PO_LINES_ARCHIVE, then set the appropriate flags
6618: UPDATE PO_LINE_LOC_ALL_EXT_B_ARCHIVE POL1

Line 6632: IF PO_LOG.d_stmt THEN

6628: AND POL2.latest_external_flag = 'Y'
6629: AND POL2.revision_num = p_revision_num
6630: AND POL2.attr_group_id = POL1.attr_group_id);
6631:
6632: IF PO_LOG.d_stmt THEN
6633: PO_LOG.stmt(d_mod,l_progress,'Number of rows updated: '||SQL%rowcount);
6634: END IF;
6635: END IF;
6636: --

Line 6633: PO_LOG.stmt(d_mod,l_progress,'Number of rows updated: '||SQL%rowcount);

6629: AND POL2.revision_num = p_revision_num
6630: AND POL2.attr_group_id = POL1.attr_group_id);
6631:
6632: IF PO_LOG.d_stmt THEN
6633: PO_LOG.stmt(d_mod,l_progress,'Number of rows updated: '||SQL%rowcount);
6634: END IF;
6635: END IF;
6636: --
6637: -- End PO_LINE_LOC_ALL_EXT_B_ARCHIVE

Line 6641: IF PO_LOG.d_stmt THEN

6637: -- End PO_LINE_LOC_ALL_EXT_B_ARCHIVE
6638:
6639: -- Start PO_LINE_LOC_ALL_EXT_TL_ARCHIVE
6640: l_progress := '130';
6641: IF PO_LOG.d_stmt THEN
6642: PO_LOG.stmt(d_mod,l_progress,'Archive PO_LINE_LOCATIONS_ALL_EXT_TL');
6643: END IF;
6644:
6645: INSERT INTO PO_LINE_LOC_ALL_EXT_TL_ARCHIVE

Line 6642: PO_LOG.stmt(d_mod,l_progress,'Archive PO_LINE_LOCATIONS_ALL_EXT_TL');

6638:
6639: -- Start PO_LINE_LOC_ALL_EXT_TL_ARCHIVE
6640: l_progress := '130';
6641: IF PO_LOG.d_stmt THEN
6642: PO_LOG.stmt(d_mod,l_progress,'Archive PO_LINE_LOCATIONS_ALL_EXT_TL');
6643: END IF;
6644:
6645: INSERT INTO PO_LINE_LOC_ALL_EXT_TL_ARCHIVE
6646: (EXTENSION_ID

Line 6775: IF PO_LOG.d_stmt THEN

6771: AND POL.line_location_id = POLE.line_location_id
6772: AND POLE.draft_id = -1;
6773:
6774: l_progress := '140';
6775: IF PO_LOG.d_stmt THEN
6776: PO_LOG.stmt(d_mod,l_progress,'Number of rows inserted: '||SQL%rowcount);
6777: END IF;
6778: -- End PO_LINE_LOC_ALL_EXT_TL_ARCHIVE
6779:

Line 6776: PO_LOG.stmt(d_mod,l_progress,'Number of rows inserted: '||SQL%rowcount);

6772: AND POLE.draft_id = -1;
6773:
6774: l_progress := '140';
6775: IF PO_LOG.d_stmt THEN
6776: PO_LOG.stmt(d_mod,l_progress,'Number of rows inserted: '||SQL%rowcount);
6777: END IF;
6778: -- End PO_LINE_LOC_ALL_EXT_TL_ARCHIVE
6779:
6780: END IF; --IF p_document_subtype='BLANKET'

Line 6784: IF PO_LOG.d_proc THEN

6780: END IF; --IF p_document_subtype='BLANKET'
6781:
6782: END IF; --IF l_enabled_flag = 'Y' AND p_document_type IN ('PO', 'PA')
6783:
6784: IF PO_LOG.d_proc THEN
6785: PO_LOG.proc_end(d_mod);
6786: END IF;
6787:
6788: EXCEPTION

Line 6785: PO_LOG.proc_end(d_mod);

6781:
6782: END IF; --IF l_enabled_flag = 'Y' AND p_document_type IN ('PO', 'PA')
6783:
6784: IF PO_LOG.d_proc THEN
6785: PO_LOG.proc_end(d_mod);
6786: END IF;
6787:
6788: EXCEPTION
6789: WHEN OTHERS THEN

Line 6790: IF PO_LOG.d_exc THEN

6786: END IF;
6787:
6788: EXCEPTION
6789: WHEN OTHERS THEN
6790: IF PO_LOG.d_exc THEN
6791: PO_LOG.exc(d_mod,l_progress,'Unhandled exception');
6792: END IF;
6793: RAISE;
6794: END archive_uda_attribs;

Line 6791: PO_LOG.exc(d_mod,l_progress,'Unhandled exception');

6787:
6788: EXCEPTION
6789: WHEN OTHERS THEN
6790: IF PO_LOG.d_exc THEN
6791: PO_LOG.exc(d_mod,l_progress,'Unhandled exception');
6792: END IF;
6793: RAISE;
6794: END archive_uda_attribs;
6795: --

Line 6871: IF PO_LOG.d_proc THEN

6867:
6868: BEGIN
6869: l_progress := '000';
6870:
6871: IF PO_LOG.d_proc THEN
6872: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);
6873: PO_LOG.proc_begin(d_mod,'p_revision_num',p_revision_num);
6874: END IF;
6875:

Line 6872: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);

6868: BEGIN
6869: l_progress := '000';
6870:
6871: IF PO_LOG.d_proc THEN
6872: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);
6873: PO_LOG.proc_begin(d_mod,'p_revision_num',p_revision_num);
6874: END IF;
6875:
6876: -- Copy Header Attachments Start

Line 6873: PO_LOG.proc_begin(d_mod,'p_revision_num',p_revision_num);

6869: l_progress := '000';
6870:
6871: IF PO_LOG.d_proc THEN
6872: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);
6873: PO_LOG.proc_begin(d_mod,'p_revision_num',p_revision_num);
6874: END IF;
6875:
6876: -- Copy Header Attachments Start
6877: l_from_po_header_id := p_po_header_id;

Line 6881: IF PO_LOG.d_stmt THEN

6877: l_from_po_header_id := p_po_header_id;
6878: l_to_po_header_id := l_from_po_header_id || '-' || p_draft_id;
6879:
6880: l_progress := '010';
6881: IF PO_LOG.d_stmt THEN
6882: PO_LOG.stmt(d_mod,l_progress,
6883: 'Copy Header Attachment from pk1_value: '|| l_from_po_header_id
6884: || ' to pk1_value: '||l_to_po_header_id);
6885: END IF;

Line 6882: PO_LOG.stmt(d_mod,l_progress,

6878: l_to_po_header_id := l_from_po_header_id || '-' || p_draft_id;
6879:
6880: l_progress := '010';
6881: IF PO_LOG.d_stmt THEN
6882: PO_LOG.stmt(d_mod,l_progress,
6883: 'Copy Header Attachment from pk1_value: '|| l_from_po_header_id
6884: || ' to pk1_value: '||l_to_po_header_id);
6885: END IF;
6886:

Line 6924: IF PO_LOG.d_stmt THEN

6920:
6921: l_to_po_line_id := l_from_po_line_id || '-' || p_draft_id;
6922:
6923: l_progress := '020';
6924: IF PO_LOG.d_stmt THEN
6925: PO_LOG.stmt(d_mod,l_progress,
6926: 'Copy Line Attachments from pk1_value: '|| l_from_po_line_id
6927: || ' to pk1_value: '||l_to_po_line_id);
6928: END IF;

Line 6925: PO_LOG.stmt(d_mod,l_progress,

6921: l_to_po_line_id := l_from_po_line_id || '-' || p_draft_id;
6922:
6923: l_progress := '020';
6924: IF PO_LOG.d_stmt THEN
6925: PO_LOG.stmt(d_mod,l_progress,
6926: 'Copy Line Attachments from pk1_value: '|| l_from_po_line_id
6927: || ' to pk1_value: '||l_to_po_line_id);
6928: END IF;
6929:

Line 6961: IF PO_LOG.d_stmt THEN

6957:
6958: l_to_line_location_id := l_from_line_location_id || '-' || p_draft_id;
6959:
6960: l_progress := '030';
6961: IF PO_LOG.d_stmt THEN
6962: PO_LOG.stmt(d_mod,l_progress,
6963: 'Copy Shipment Attachments from pk1_value: '|| l_from_line_location_id
6964: || ' to pk1_value: '||l_to_line_location_id);
6965: END IF;

Line 6962: PO_LOG.stmt(d_mod,l_progress,

6958: l_to_line_location_id := l_from_line_location_id || '-' || p_draft_id;
6959:
6960: l_progress := '030';
6961: IF PO_LOG.d_stmt THEN
6962: PO_LOG.stmt(d_mod,l_progress,
6963: 'Copy Shipment Attachments from pk1_value: '|| l_from_line_location_id
6964: || ' to pk1_value: '||l_to_line_location_id);
6965: END IF;
6966:

Line 6997: IF PO_LOG.d_stmt THEN

6993:
6994: l_to_po_distribution_id := l_from_po_distribution_id || '-' || p_draft_id;
6995:
6996: l_progress := '040';
6997: IF PO_LOG.d_stmt THEN
6998: PO_LOG.stmt(d_mod,l_progress,
6999: 'Copy Distribution Attachments from pk1_value: '|| l_from_po_distribution_id
7000: || ' to pk1_value: '||l_to_po_distribution_id);
7001: END IF;

Line 6998: PO_LOG.stmt(d_mod,l_progress,

6994: l_to_po_distribution_id := l_from_po_distribution_id || '-' || p_draft_id;
6995:
6996: l_progress := '040';
6997: IF PO_LOG.d_stmt THEN
6998: PO_LOG.stmt(d_mod,l_progress,
6999: 'Copy Distribution Attachments from pk1_value: '|| l_from_po_distribution_id
7000: || ' to pk1_value: '||l_to_po_distribution_id);
7001: END IF;
7002:

Line 7033: IF PO_LOG.d_proc THEN

7029: CLOSE po_line_cursor;
7030: -- End Copy Line, Shipments, Distributions Attachments
7031: END IF; --IF p_document_type = 'PO' || p_document_subtype='BLANKET'
7032:
7033: IF PO_LOG.d_proc THEN
7034: PO_LOG.proc_end(d_mod);
7035: END IF;
7036:
7037: EXCEPTION

Line 7034: PO_LOG.proc_end(d_mod);

7030: -- End Copy Line, Shipments, Distributions Attachments
7031: END IF; --IF p_document_type = 'PO' || p_document_subtype='BLANKET'
7032:
7033: IF PO_LOG.d_proc THEN
7034: PO_LOG.proc_end(d_mod);
7035: END IF;
7036:
7037: EXCEPTION
7038: WHEN OTHERS THEN

Line 7039: IF PO_LOG.d_exc THEN

7035: END IF;
7036:
7037: EXCEPTION
7038: WHEN OTHERS THEN
7039: IF PO_LOG.d_exc THEN
7040: PO_LOG.exc(d_mod,l_progress,'Unhandled exception');
7041: END IF;
7042:
7043: IF (po_line_cursor%ISOPEN) THEN

Line 7040: PO_LOG.exc(d_mod,l_progress,'Unhandled exception');

7036:
7037: EXCEPTION
7038: WHEN OTHERS THEN
7039: IF PO_LOG.d_exc THEN
7040: PO_LOG.exc(d_mod,l_progress,'Unhandled exception');
7041: END IF;
7042:
7043: IF (po_line_cursor%ISOPEN) THEN
7044: CLOSE po_line_cursor;

Line 7108: IF PO_LOG.d_proc THEN

7104:
7105: BEGIN
7106: l_progress := '000';
7107:
7108: IF PO_LOG.d_proc THEN
7109: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);
7110: PO_LOG.proc_begin(d_mod,'p_revision_num',p_revision_num);
7111: END IF;
7112:

Line 7109: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);

7105: BEGIN
7106: l_progress := '000';
7107:
7108: IF PO_LOG.d_proc THEN
7109: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);
7110: PO_LOG.proc_begin(d_mod,'p_revision_num',p_revision_num);
7111: END IF;
7112:
7113: l_progress := '010';

Line 7110: PO_LOG.proc_begin(d_mod,'p_revision_num',p_revision_num);

7106: l_progress := '000';
7107:
7108: IF PO_LOG.d_proc THEN
7109: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);
7110: PO_LOG.proc_begin(d_mod,'p_revision_num',p_revision_num);
7111: END IF;
7112:
7113: l_progress := '010';
7114: IF PO_LOG.d_stmt THEN

Line 7114: IF PO_LOG.d_stmt THEN

7110: PO_LOG.proc_begin(d_mod,'p_revision_num',p_revision_num);
7111: END IF;
7112:
7113: l_progress := '010';
7114: IF PO_LOG.d_stmt THEN
7115: PO_LOG.stmt(d_mod,l_progress,
7116: 'Select conterms_exist_flag - po_header_id: '||p_po_header_id);
7117: END IF;
7118: -- SQL What:Find out if contract terms exist

Line 7115: PO_LOG.stmt(d_mod,l_progress,

7111: END IF;
7112:
7113: l_progress := '010';
7114: IF PO_LOG.d_stmt THEN
7115: PO_LOG.stmt(d_mod,l_progress,
7116: 'Select conterms_exist_flag - po_header_id: '||p_po_header_id);
7117: END IF;
7118: -- SQL What:Find out if contract terms exist
7119: -- SQL Why :Sync Contract Terms if needed

Line 7127: IF PO_LOG.d_stmt THEN

7123: WHERE po_header_id = p_po_header_id;
7124:
7125: IF (l_conterms_exist_flag = 'Y') THEN
7126: l_progress := '020';
7127: IF PO_LOG.d_stmt THEN
7128: PO_LOG.stmt(d_mod,l_progress,
7129: 'ConTerms Exist. Generate and store a new Draft Id in PO_HEADERS_ARCHIVE_ALL');
7130: END IF;
7131:

Line 7128: PO_LOG.stmt(d_mod,l_progress,

7124:
7125: IF (l_conterms_exist_flag = 'Y') THEN
7126: l_progress := '020';
7127: IF PO_LOG.d_stmt THEN
7128: PO_LOG.stmt(d_mod,l_progress,
7129: 'ConTerms Exist. Generate and store a new Draft Id in PO_HEADERS_ARCHIVE_ALL');
7130: END IF;
7131:
7132: --Generate new Draft Id and store in PO_HEADERS_ARCHIVE_ALL

Line 7143: IF PO_LOG.d_stmt THEN

7139: WHERE po_header_id = p_po_header_id
7140: AND revision_num = p_revision_num;
7141:
7142: l_progress := '030';
7143: IF PO_LOG.d_stmt THEN
7144: PO_LOG.stmt(d_mod,l_progress,
7145: 'Calling PO_CONTERMS_UTL_GRP.Copy_Conterms_Mod with p_document_id = '||
7146: p_po_header_id || ' and p_draft_id = '||l_draft_id);
7147: END IF;

Line 7144: PO_LOG.stmt(d_mod,l_progress,

7140: AND revision_num = p_revision_num;
7141:
7142: l_progress := '030';
7143: IF PO_LOG.d_stmt THEN
7144: PO_LOG.stmt(d_mod,l_progress,
7145: 'Calling PO_CONTERMS_UTL_GRP.Copy_Conterms_Mod with p_document_id = '||
7146: p_po_header_id || ' and p_draft_id = '||l_draft_id);
7147: END IF;
7148:

Line 7157: IF PO_LOG.d_proc THEN

7153:
7154: END IF;--IF (l_conterms_exist_flag = 'Y') THEN
7155:
7156:
7157: IF PO_LOG.d_proc THEN
7158: PO_LOG.proc_end(d_mod);
7159: END IF;
7160:
7161: EXCEPTION

Line 7158: PO_LOG.proc_end(d_mod);

7154: END IF;--IF (l_conterms_exist_flag = 'Y') THEN
7155:
7156:
7157: IF PO_LOG.d_proc THEN
7158: PO_LOG.proc_end(d_mod);
7159: END IF;
7160:
7161: EXCEPTION
7162: WHEN OTHERS THEN

Line 7163: IF PO_LOG.d_exc THEN

7159: END IF;
7160:
7161: EXCEPTION
7162: WHEN OTHERS THEN
7163: IF PO_LOG.d_exc THEN
7164: PO_LOG.exc(d_mod,l_progress,'Unhandled exception');
7165: END IF;
7166:
7167: RAISE;

Line 7164: PO_LOG.exc(d_mod,l_progress,'Unhandled exception');

7160:
7161: EXCEPTION
7162: WHEN OTHERS THEN
7163: IF PO_LOG.d_exc THEN
7164: PO_LOG.exc(d_mod,l_progress,'Unhandled exception');
7165: END IF;
7166:
7167: RAISE;
7168: