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_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.177.12020000.38 2013/05/10 08:35:16 inagdeo 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 18928: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_CHECKS_PVT.check_final_close';

18924: , x_return_status OUT NOCOPY VARCHAR2
18925: )
18926: IS
18927:
18928: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_CHECKS_PVT.check_final_close';
18929: d_progress NUMBER;
18930: d_msg VARCHAR2(200);
18931:
18932: l_ret_sts VARCHAR2(1);

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

19216: l_ret_sts VARCHAR2(1);
19217: l_is_complex_po boolean;
19218: l_token_value VARCHAR2(256);
19219:
19220: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_CHECKS_PVT.check_rcv_trans_interface';
19221: d_progress NUMBER;
19222: d_msg VARCHAR2(60);
19223:
19224:

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

19588:
19589: l_text_normal_po PO_ONLINE_REPORT_TEXT_GT.text_line%TYPE;
19590: l_text_complex_po PO_ONLINE_REPORT_TEXT_GT.text_line%TYPE;
19591:
19592: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_CHECKS_PVT.check_asn_not_fully_received';
19593: d_progress NUMBER;
19594:
19595:
19596: BEGIN

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

19946: IS
19947:
19948: l_textline PO_ONLINE_REPORT_TEXT_GT.text_line%TYPE;
19949:
19950: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_CHECKS_PVT.check_qty_rcv_but_not_deliv';
19951: d_progress NUMBER;
19952:
19953:
19954: BEGIN

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

20065: IS
20066:
20067: l_textline PO_ONLINE_REPORT_TEXT_GT.text_line%TYPE;
20068:
20069: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_CHECKS_PVT.check_amt_rcv_but_not_deliv';
20070: d_progress NUMBER;
20071:
20072:
20073: BEGIN

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

20193: l_textline PO_ONLINE_REPORT_TEXT_GT.text_line%TYPE;
20194: l_is_complex_po boolean;
20195: l_token_value VARCHAR2(256);
20196:
20197: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_CHECKS_PVT.check_invalid_acct_flex';
20198: d_progress NUMBER;
20199:
20200:
20201: BEGIN

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

20315: IS
20316:
20317: l_textline PO_ONLINE_REPORT_TEXT_GT.text_line%TYPE;
20318:
20319: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_CHECKS_PVT.check_bpa_has_open_release';
20320: d_progress NUMBER;
20321:
20322:
20323: BEGIN

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

20412: IS
20413:
20414: l_textline PO_ONLINE_REPORT_TEXT_GT.text_line%TYPE;
20415:
20416: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_CHECKS_PVT.check_bpa_has_open_stdref';
20417: d_progress NUMBER;
20418:
20419:
20420: BEGIN

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

20508: IS
20509:
20510: l_textline PO_ONLINE_REPORT_TEXT_GT.text_line%TYPE;
20511:
20512: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_CHECKS_PVT.check_cpa_has_open_stdref';
20513: d_progress NUMBER;
20514:
20515:
20516: BEGIN

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

20604: IS
20605:
20606: l_textline PO_ONLINE_REPORT_TEXT_GT.text_line%TYPE;
20607:
20608: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_CHECKS_PVT.check_ppo_has_open_release';
20609: d_progress NUMBER;
20610:
20611:
20612: BEGIN

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

21221: RETURN BOOLEAN
21222: IS
21223:
21224: d_module VARCHAR(70) :=
21225: 'po.plsql.PO_DOCUMENT_CHECKS_PVT.is_pay_item_price_updateable';
21226: d_progress NUMBER;
21227: l_is_price_updateable BOOLEAN;
21228: l_quantity_received NUMBER;
21229: l_quantity_billed NUMBER;

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

21358: l_invoice_type VARCHAR2(100) := 'BOTH';
21359: l_is_complex_po boolean;
21360: l_token_value VARCHAR2(256);
21361: l_return_status VARCHAR2(1);
21362: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_CHECKS_PVT.check_unvalidated_invoices';
21363: d_progress NUMBER;
21364:
21365: BEGIN
21366:

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

21619: l_calling_sequence VARCHAR2(100);
21620: l_invoice_type VARCHAR2(100) := 'BOTH';
21621: l_is_complex_po boolean := false;
21622: l_document_id NUMBER;
21623: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_CHECKS_PVT.get_message_text';
21624: d_progress NUMBER;
21625: BEGIN
21626: d_progress := 0;
21627: IF (PO_LOG.d_proc) THEN

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

21739: l_inventory_item_id NUMBER;
21740: l_ship_to_organization_id NUMBER;
21741: l_consigned_flag VARCHAR2(20);
21742: l_outsourced_assembly VARCHAR2(20);
21743: l_log_head VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_CHECKS_PVT.Set_LCM_Flag';
21744: l_progress VARCHAR2(3) := '000';
21745: l_line_location_id po_line_locations_all.line_location_id%TYPE; --
21746:
21747: BEGIN

Line 21889: l_log_head VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_CHECKS_PVT.validate_supplier_debarred';

21885: , x_return_status OUT NOCOPY VARCHAR2
21886: )
21887: IS
21888:
21889: l_log_head VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_CHECKS_PVT.validate_supplier_debarred';
21890: l_progress VARCHAR2(3) := '000';
21891: l_vendor_site_id PO_VENDOR_SITES_ALL.VENDOR_SITE_ID%type;
21892: l_debar_start_date PO_VENDOR_SITES_ALL.DEBARMENT_START_DATE%type;
21893: l_debar_end_date PO_VENDOR_SITES_ALL.DEBARMENT_END_DATE%type;

Line 22016: l_log_head VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_CHECKS_PVT.validate_co_warrant';

22012: , p_sequence IN OUT NOCOPY NUMBER
22013: , x_return_status OUT NOCOPY VARCHAR2
22014: )
22015: IS
22016: l_log_head VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_CHECKS_PVT.validate_co_warrant';
22017: l_progress VARCHAR2(3) := '000';
22018: l_err_msg_txt VARCHAR2(3000);
22019: msg_name VARCHAR2(50) := NULL;
22020: msg_type VARCHAR2(50) := NULL;

Line 22466: l_log_head VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_CHECKS_PVT.validate_genchangedesc';

22462: )
22463: IS
22464:
22465: l_return_status VARCHAR2(10) := NULL;
22466: l_log_head VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_CHECKS_PVT.validate_genchangedesc';
22467: l_progress VARCHAR2(3) := '000';
22468: mod_last_update_date PO_DRAFTS.last_update_date%type;
22469: changedesc_gen_date PO_DRAFTS.cd_generated_date%type;
22470: changedesc_gen_flag PO_DRAFTS.cd_generated_flag%type;

Line 22629: l_log_head VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_CHECKS_PVT.validate_pa_header_ord_constraints';

22625: )
22626: IS
22627:
22628: l_return_status VARCHAR2(10) := NULL;
22629: l_log_head VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_CHECKS_PVT.validate_pa_header_ord_constraints';
22630: l_progress VARCHAR2(3) := '000';
22631: l_textline po_online_report_text.text_line%TYPE := NULL;
22632:
22633: BEGIN

Line 23402: l_log_head VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_CHECKS_PVT.CHECK_CLOSE_WIP_JOB';

23398: l_progress NUMBER := 0;
23399: l_document_id NUMBER := 0;
23400: l_api_name CONSTANT VARCHAR2(30) := 'CHECK_CLOSE_WIP_JOB';
23401: l_text_line PO_ONLINE_REPORT_TEXT.text_line%TYPE := NULL;
23402: l_log_head VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_CHECKS_PVT.CHECK_CLOSE_WIP_JOB';
23403: BEGIN
23404:
23405: l_text_line := FND_MESSAGE.GET_STRING('PO', 'PO_CLOSE_WIP_JOB');
23406: --Start of Process

Line 26694: END PO_DOCUMENT_CHECKS_PVT;

26690:
26691: -- SBCR Integration Changes End.
26692:
26693:
26694: END PO_DOCUMENT_CHECKS_PVT;
26695: