APPS.PO_CHG_REQUEST_PVT dependencies on PO_TBL_VARCHAR2000

Line 678: l_err_msg_text_tbl po_tbl_varchar2000;

674: accp_flag char(1);
675: v_buyer_id number;
676: x_accp_flag po_headers_all.acceptance_required_flag%type;
677: l_err_msg_name_tbl po_tbl_varchar30;
678: l_err_msg_text_tbl po_tbl_varchar2000;
679: l_last_upd_date po_headers_all.last_update_date%type;
680: l_count_asn NUMBER;
681: l_ret_sts varchar2(1);
682:

Line 725: l_err_msg_text_tbl := po_tbl_varchar2000();

721: EXCEPTION
722: WHEN OTHERS THEN
723: if (sqlcode = '-54') then
724: l_err_msg_name_tbl := po_tbl_varchar30();
725: l_err_msg_text_tbl := po_tbl_varchar2000();
726: x_pos_errors := POS_ERR_TYPE( l_err_msg_name_tbl,l_err_msg_text_tbl);
727: x_pos_errors.message_name.extend;
728: x_pos_errors.text_line.extend;
729: x_pos_errors.message_name(1) := null;

Line 752: l_err_msg_text_tbl := po_tbl_varchar2000();

748: EXCEPTION
749: WHEN OTHERS THEN
750: if (sqlcode = '-54') then
751: l_err_msg_name_tbl := po_tbl_varchar30();
752: l_err_msg_text_tbl := po_tbl_varchar2000();
753: x_pos_errors := POS_ERR_TYPE( l_err_msg_name_tbl,l_err_msg_text_tbl);
754: x_pos_errors.message_name.extend;
755: x_pos_errors.text_line.extend;
756: x_pos_errors.message_name(1) := null;

Line 770: l_err_msg_text_tbl := po_tbl_varchar2000();

766: -- The record that was queried is being updated
767:
768: if (p_last_upd_date <> l_last_upd_date) then
769: l_err_msg_name_tbl := po_tbl_varchar30();
770: l_err_msg_text_tbl := po_tbl_varchar2000();
771: x_pos_errors := POS_ERR_TYPE( l_err_msg_name_tbl,l_err_msg_text_tbl);
772: x_pos_errors.message_name.extend;
773: x_pos_errors.text_line.extend;
774: x_pos_errors.message_name(1) := null;

Line 815: l_err_msg_text_tbl := po_tbl_varchar2000();

811:
812:
813:
814: l_err_msg_name_tbl := po_tbl_varchar30();
815: l_err_msg_text_tbl := po_tbl_varchar2000();
816: x_pos_errors := POS_ERR_TYPE( l_err_msg_name_tbl,l_err_msg_text_tbl);
817:
818:
819:

Line 844: l_err_msg_text_tbl := po_tbl_varchar2000();

840: );
841: x_online_report_id := 0;
842: if (l_return_status <> FND_API.g_ret_sts_success) then
843: l_err_msg_name_tbl := po_tbl_varchar30();
844: l_err_msg_text_tbl := po_tbl_varchar2000();
845: x_pos_errors := POS_ERR_TYPE( l_err_msg_name_tbl,l_err_msg_text_tbl);
846:
847:
848: x_pos_errors.message_name.extend;

Line 1109: l_err_msg_text_tbl := po_tbl_varchar2000();

1105: END IF;
1106: END IF;
1107: else
1108: l_err_msg_name_tbl := po_tbl_varchar30();
1109: l_err_msg_text_tbl := po_tbl_varchar2000();
1110: x_pos_errors := POS_ERR_TYPE( l_err_msg_name_tbl,l_err_msg_text_tbl);
1111: x_pos_errors.message_name.extend;
1112: x_pos_errors.text_line.extend;
1113: x_pos_errors.message_name(1) := null;

Line 1422: l_err_msg_text_tbl po_tbl_varchar2000;

1418: x_cum_flag boolean := FALSE;
1419: x_price number := NULL;
1420: l_error_index number := 0;
1421: l_err_msg_name_tbl po_tbl_varchar30;
1422: l_err_msg_text_tbl po_tbl_varchar2000;
1423: l_total_qty number;
1424: l_ga_ship_qty number;
1425: l_ga_lineLocId number;
1426: l_ga_lineId number;

Line 1758: l_err_msg_text_tbl := po_tbl_varchar2000();

1754:
1755:
1756:
1757: l_err_msg_name_tbl := po_tbl_varchar30();
1758: l_err_msg_text_tbl := po_tbl_varchar2000();
1759: x_pos_errors := POS_ERR_TYPE( l_err_msg_name_tbl,l_err_msg_text_tbl);
1760:
1761: if ( l_return_status = FND_API.G_RET_STS_SUCCESS AND
1762: l_sub_check_status = FND_API.G_RET_STS_ERROR) THEN

Line 3172: l_err_msg_text_tbl po_tbl_varchar2000;

3168:
3169: l_po_change_requests pos_chg_rec_tbl := NULL;
3170: l_count_asn NUMBER;
3171: l_err_msg_name_tbl po_tbl_varchar30;
3172: l_err_msg_text_tbl po_tbl_varchar2000;
3173: l_err_count NUMBER;
3174:
3175: BEGIN
3176: l_err_count := 0;

Line 3179: l_err_msg_text_tbl := po_tbl_varchar2000();

3175: BEGIN
3176: l_err_count := 0;
3177: l_po_change_requests := p_po_change_requests ;
3178: l_err_msg_name_tbl := po_tbl_varchar30();
3179: l_err_msg_text_tbl := po_tbl_varchar2000();
3180: x_pos_errors := POS_ERR_TYPE( l_err_msg_name_tbl,l_err_msg_text_tbl);
3181: x_ret_sts := 'N';
3182: FOR j in 1..l_po_change_requests.count()
3183: LOOP

Line 3257: l_err_msg_text_tbl po_tbl_varchar2000;

3253:
3254: l_po_change_requests pos_chg_rec_tbl := NULL;
3255: l_count_asn NUMBER;
3256: l_err_msg_name_tbl po_tbl_varchar30;
3257: l_err_msg_text_tbl po_tbl_varchar2000;
3258: l_err_count NUMBER;
3259: l_quan_ordered NUMBER;
3260: l_quan_recd NUMBER;
3261: l_quan_billed NUMBER;

Line 3266: l_err_msg_text_tbl := po_tbl_varchar2000();

3262: BEGIN
3263: l_err_count := 0;
3264: l_po_change_requests := p_po_change_requests ;
3265: l_err_msg_name_tbl := po_tbl_varchar30();
3266: l_err_msg_text_tbl := po_tbl_varchar2000();
3267: x_pos_errors := POS_ERR_TYPE( l_err_msg_name_tbl,l_err_msg_text_tbl);
3268: FOR j in 1..l_po_change_requests.count()
3269: LOOP
3270: if ( l_po_change_requests(j).action_type in ('CANCELLATION') AND