DBA Data[Home] [Help]

APPS.PO_DOCUMENT_CHECKS_PVT dependencies on PO_DOCUMENT_CHECKS_PVT

Line 1: PACKAGE BODY PO_DOCUMENT_CHECKS_PVT AS

1: PACKAGE BODY PO_DOCUMENT_CHECKS_PVT AS
2: /* $Header: POXVDCKB.pls 120.64.12010000.11 2009/02/10 06:07:31 rakchakr ship $*/
3:
4:
5:

Line 36: G_PKG_NAME CONSTANT varchar2(30) := 'PO_DOCUMENT_CHECKS_PVT';

32:
33: --Contains message 'Distribution Quantity'
34: g_distqtymsg CONSTANT VARCHAR2(40) := substrb(FND_MESSAGE.GET_STRING('PO', 'PO_SUB_TOKEN_DIST_QUANTITY'),1,40);
35:
36: G_PKG_NAME CONSTANT varchar2(30) := 'PO_DOCUMENT_CHECKS_PVT';
37:
38: g_log_head CONSTANT VARCHAR2(50) := 'po.plsql.'|| G_PKG_NAME || '.';
39:
40:

Line 15318: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_CHECKS_PVT.check_final_close';

15314: , x_return_status OUT NOCOPY VARCHAR2
15315: )
15316: IS
15317:
15318: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_CHECKS_PVT.check_final_close';
15319: d_progress NUMBER;
15320: d_msg VARCHAR2(200);
15321:
15322: l_ret_sts VARCHAR2(1);

Line 15609: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_CHECKS_PVT.check_rcv_trans_interface';

15605: l_ret_sts VARCHAR2(1);
15606: l_is_complex_po boolean;
15607: l_token_value VARCHAR2(256);
15608:
15609: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_CHECKS_PVT.check_rcv_trans_interface';
15610: d_progress NUMBER;
15611: d_msg VARCHAR2(60);
15612:
15613:

Line 15920: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_CHECKS_PVT.check_asn_not_fully_received';

15916:
15917: l_text_normal_po PO_ONLINE_REPORT_TEXT_GT.text_line%TYPE;
15918: l_text_complex_po PO_ONLINE_REPORT_TEXT_GT.text_line%TYPE;
15919:
15920: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_CHECKS_PVT.check_asn_not_fully_received';
15921: d_progress NUMBER;
15922:
15923:
15924: BEGIN

Line 16029: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_CHECKS_PVT.check_qty_rcv_but_not_deliv';

16025: IS
16026:
16027: l_textline PO_ONLINE_REPORT_TEXT_GT.text_line%TYPE;
16028:
16029: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_CHECKS_PVT.check_qty_rcv_but_not_deliv';
16030: d_progress NUMBER;
16031:
16032:
16033: BEGIN

Line 16148: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_CHECKS_PVT.check_amt_rcv_but_not_deliv';

16144: IS
16145:
16146: l_textline PO_ONLINE_REPORT_TEXT_GT.text_line%TYPE;
16147:
16148: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_CHECKS_PVT.check_amt_rcv_but_not_deliv';
16149: d_progress NUMBER;
16150:
16151:
16152: BEGIN

Line 16276: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_CHECKS_PVT.check_invalid_acct_flex';

16272: l_textline PO_ONLINE_REPORT_TEXT_GT.text_line%TYPE;
16273: l_is_complex_po boolean;
16274: l_token_value VARCHAR2(256);
16275:
16276: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_CHECKS_PVT.check_invalid_acct_flex';
16277: d_progress NUMBER;
16278:
16279:
16280: BEGIN

Line 16398: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_CHECKS_PVT.check_bpa_has_open_release';

16394: IS
16395:
16396: l_textline PO_ONLINE_REPORT_TEXT_GT.text_line%TYPE;
16397:
16398: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_CHECKS_PVT.check_bpa_has_open_release';
16399: d_progress NUMBER;
16400:
16401:
16402: BEGIN

Line 16495: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_CHECKS_PVT.check_bpa_has_open_stdref';

16491: IS
16492:
16493: l_textline PO_ONLINE_REPORT_TEXT_GT.text_line%TYPE;
16494:
16495: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_CHECKS_PVT.check_bpa_has_open_stdref';
16496: d_progress NUMBER;
16497:
16498:
16499: BEGIN

Line 16591: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_CHECKS_PVT.check_cpa_has_open_stdref';

16587: IS
16588:
16589: l_textline PO_ONLINE_REPORT_TEXT_GT.text_line%TYPE;
16590:
16591: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_CHECKS_PVT.check_cpa_has_open_stdref';
16592: d_progress NUMBER;
16593:
16594:
16595: BEGIN

Line 16687: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_CHECKS_PVT.check_ppo_has_open_release';

16683: IS
16684:
16685: l_textline PO_ONLINE_REPORT_TEXT_GT.text_line%TYPE;
16686:
16687: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_CHECKS_PVT.check_ppo_has_open_release';
16688: d_progress NUMBER;
16689:
16690:
16691: BEGIN

Line 17238: 'po.plsql.PO_DOCUMENT_CHECKS_PVT.is_pay_item_price_updateable';

17234: RETURN BOOLEAN
17235: IS
17236:
17237: d_module VARCHAR(70) :=
17238: 'po.plsql.PO_DOCUMENT_CHECKS_PVT.is_pay_item_price_updateable';
17239: d_progress NUMBER;
17240: l_is_price_updateable BOOLEAN;
17241: l_quantity_received NUMBER;
17242: l_quantity_billed NUMBER;

Line 17375: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_CHECKS_PVT.check_unvalidated_invoices';

17371: l_invoice_type VARCHAR2(100) := 'BOTH';
17372: l_is_complex_po boolean;
17373: l_token_value VARCHAR2(256);
17374: l_return_status VARCHAR2(1);
17375: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_CHECKS_PVT.check_unvalidated_invoices';
17376: d_progress NUMBER;
17377:
17378: BEGIN
17379:

Line 17636: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_CHECKS_PVT.get_message_text';

17632: l_calling_sequence VARCHAR2(100);
17633: l_invoice_type VARCHAR2(100) := 'BOTH';
17634: l_is_complex_po boolean := false;
17635: l_document_id NUMBER;
17636: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_CHECKS_PVT.get_message_text';
17637: d_progress NUMBER;
17638: BEGIN
17639: d_progress := 0;
17640: IF (PO_LOG.d_proc) THEN

Line 17752: l_log_head VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_CHECKS_PVT.Set_LCM_Flag';

17748: l_inventory_item_id NUMBER;
17749: l_ship_to_organization_id NUMBER;
17750: l_consigned_flag VARCHAR2(20);
17751: l_outsourced_assembly VARCHAR2(20);
17752: l_log_head VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_CHECKS_PVT.Set_LCM_Flag';
17753: l_progress VARCHAR2(3) := '000';
17754:
17755:
17756: BEGIN

Line 17873: END PO_DOCUMENT_CHECKS_PVT;

17869: END IF;
17870:
17871: END set_lcm_flag;
17872:
17873: END PO_DOCUMENT_CHECKS_PVT;