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_CHG_REQUEST_PVT dependencies on PO_TBL_VARCHAR2000

Line 781: l_err_msg_text_tbl po_tbl_varchar2000;

777: accp_flag char(1);
778: v_buyer_id number;
779: x_accp_flag po_headers_all.acceptance_required_flag%type;
780: l_err_msg_name_tbl po_tbl_varchar30;
781: l_err_msg_text_tbl po_tbl_varchar2000;
782: l_last_upd_date po_headers_all.last_update_date%type;
783: l_count_asn NUMBER;
784: l_ret_sts varchar2(1);
785:

Line 828: l_err_msg_text_tbl := po_tbl_varchar2000();

824: EXCEPTION
825: WHEN OTHERS THEN
826: if (sqlcode = '-54') then
827: l_err_msg_name_tbl := po_tbl_varchar30();
828: l_err_msg_text_tbl := po_tbl_varchar2000();
829: x_pos_errors := POS_ERR_TYPE( l_err_msg_name_tbl,l_err_msg_text_tbl);
830: x_pos_errors.message_name.extend;
831: x_pos_errors.text_line.extend;
832: x_pos_errors.message_name(1) := null;

Line 855: l_err_msg_text_tbl := po_tbl_varchar2000();

851: EXCEPTION
852: WHEN OTHERS THEN
853: if (sqlcode = '-54') then
854: l_err_msg_name_tbl := po_tbl_varchar30();
855: l_err_msg_text_tbl := po_tbl_varchar2000();
856: x_pos_errors := POS_ERR_TYPE( l_err_msg_name_tbl,l_err_msg_text_tbl);
857: x_pos_errors.message_name.extend;
858: x_pos_errors.text_line.extend;
859: x_pos_errors.message_name(1) := null;

Line 873: l_err_msg_text_tbl := po_tbl_varchar2000();

869: -- The record that was queried is being updated
870:
871: if (p_last_upd_date <> l_last_upd_date) then
872: l_err_msg_name_tbl := po_tbl_varchar30();
873: l_err_msg_text_tbl := po_tbl_varchar2000();
874: x_pos_errors := POS_ERR_TYPE( l_err_msg_name_tbl,l_err_msg_text_tbl);
875: x_pos_errors.message_name.extend;
876: x_pos_errors.text_line.extend;
877: x_pos_errors.message_name(1) := null;

Line 919: l_err_msg_text_tbl := po_tbl_varchar2000();

915:
916:
917:
918: l_err_msg_name_tbl := po_tbl_varchar30();
919: l_err_msg_text_tbl := po_tbl_varchar2000();
920: x_pos_errors := POS_ERR_TYPE( l_err_msg_name_tbl,l_err_msg_text_tbl);
921:
922:
923:

Line 948: l_err_msg_text_tbl := po_tbl_varchar2000();

944: );
945: x_online_report_id := 0;
946: if (l_return_status <> FND_API.g_ret_sts_success) then
947: l_err_msg_name_tbl := po_tbl_varchar30();
948: l_err_msg_text_tbl := po_tbl_varchar2000();
949: x_pos_errors := POS_ERR_TYPE( l_err_msg_name_tbl,l_err_msg_text_tbl);
950:
951:
952: x_pos_errors.message_name.extend;

Line 1222: l_err_msg_text_tbl := po_tbl_varchar2000();

1218: END IF;
1219: END IF;
1220: else
1221: l_err_msg_name_tbl := po_tbl_varchar30();
1222: l_err_msg_text_tbl := po_tbl_varchar2000();
1223: x_pos_errors := POS_ERR_TYPE( l_err_msg_name_tbl,l_err_msg_text_tbl);
1224: x_pos_errors.message_name.extend;
1225: x_pos_errors.text_line.extend;
1226: x_pos_errors.message_name(1) := null;

Line 1536: l_err_msg_text_tbl po_tbl_varchar2000;

1532: x_cum_flag boolean := FALSE;
1533: x_price number := NULL;
1534: l_error_index number := 0;
1535: l_err_msg_name_tbl po_tbl_varchar30;
1536: l_err_msg_text_tbl po_tbl_varchar2000;
1537: l_total_qty number;
1538: l_ga_ship_qty number;
1539: l_ga_lineLocId number;
1540: l_ga_lineId number;

Line 1906: l_err_msg_text_tbl := po_tbl_varchar2000();

1902:
1903:
1904:
1905: l_err_msg_name_tbl := po_tbl_varchar30();
1906: l_err_msg_text_tbl := po_tbl_varchar2000();
1907: x_pos_errors := POS_ERR_TYPE( l_err_msg_name_tbl,l_err_msg_text_tbl);
1908:
1909: if ( l_return_status = FND_API.G_RET_STS_SUCCESS AND
1910: l_sub_check_status = FND_API.G_RET_STS_ERROR) THEN

Line 3547: l_err_msg_text_tbl po_tbl_varchar2000;

3543:
3544: l_po_change_requests pos_chg_rec_tbl := NULL;
3545: l_count_asn NUMBER;
3546: l_err_msg_name_tbl po_tbl_varchar30;
3547: l_err_msg_text_tbl po_tbl_varchar2000;
3548: l_err_count NUMBER;
3549:
3550: BEGIN
3551: l_err_count := 0;

Line 3554: l_err_msg_text_tbl := po_tbl_varchar2000();

3550: BEGIN
3551: l_err_count := 0;
3552: l_po_change_requests := p_po_change_requests ;
3553: l_err_msg_name_tbl := po_tbl_varchar30();
3554: l_err_msg_text_tbl := po_tbl_varchar2000();
3555: x_pos_errors := POS_ERR_TYPE( l_err_msg_name_tbl,l_err_msg_text_tbl);
3556: x_ret_sts := 'N';
3557: FOR j in 1..l_po_change_requests.count()
3558: LOOP

Line 3658: l_err_msg_text_tbl po_tbl_varchar2000;

3654:
3655: l_po_change_requests pos_chg_rec_tbl := NULL;
3656: l_count_asn NUMBER;
3657: l_err_msg_name_tbl po_tbl_varchar30;
3658: l_err_msg_text_tbl po_tbl_varchar2000;
3659: l_err_count NUMBER;
3660: l_quan_ordered NUMBER;
3661: l_quan_recd NUMBER;
3662: l_quan_billed NUMBER;

Line 3667: l_err_msg_text_tbl := po_tbl_varchar2000();

3663: BEGIN
3664: l_err_count := 0;
3665: l_po_change_requests := p_po_change_requests ;
3666: l_err_msg_name_tbl := po_tbl_varchar30();
3667: l_err_msg_text_tbl := po_tbl_varchar2000();
3668: x_pos_errors := POS_ERR_TYPE( l_err_msg_name_tbl,l_err_msg_text_tbl);
3669: FOR j in 1..l_po_change_requests.count()
3670: LOOP
3671: if ( l_po_change_requests(j).action_type in ('CANCELLATION') AND

Line 3753: l_err_msg_text_tbl PO_TBL_VARCHAR2000;

3749: IS
3750: l_po_change_requests POS_CHG_REC_TBL := NULL;
3751: l_count_asn NUMBER;
3752: l_err_msg_name_tbl PO_TBL_VARCHAR30;
3753: l_err_msg_text_tbl PO_TBL_VARCHAR2000;
3754: l_err_count NUMBER;
3755: l_api_name VARCHAR2(100) := 'IS_ASN_EXIST';
3756: CURSOR ship_cur(
3757: p_po_line_id NUMBER) IS

Line 3765: l_err_msg_text_tbl := Po_tbl_varchar2000();

3761: BEGIN
3762: l_err_count := 0;
3763: l_po_change_requests := p_po_change_requests;
3764: l_err_msg_name_tbl := Po_tbl_varchar30();
3765: l_err_msg_text_tbl := Po_tbl_varchar2000();
3766: x_pos_errors := Pos_err_type(l_err_msg_name_tbl, l_err_msg_text_tbl);
3767: x_ret_sts := 'N';
3768:
3769: IF g_fnd_debug = 'Y' THEN