DBA Data[Home] [Help]

APPS.CSE_AP_PA_PKG dependencies on FND_GLOBAL

Line 68: IF nvl(fnd_global.conc_request_id, -1) <> -1 THEN

64: IS
65: BEGIN
66: IF l_debug = 'Y' THEN
67: cse_debug_pub.add(p_message);
68: IF nvl(fnd_global.conc_request_id, -1) <> -1 THEN
69: fnd_file.put_line(fnd_file.log,p_message);
70: END IF;
71: END IF;
72: EXCEPTION

Line 354: l_nl_pa_tbl(l_ind).last_updated_by := fnd_global.user_id;

350: l_nl_pa_tbl(l_ind).document_type := p_ap_pa_tbl(ind).invoice_type;
351: l_nl_pa_tbl(l_ind).document_distribution_type := p_ap_pa_tbl(ind).invoice_distribution_type;
352: l_nl_pa_tbl(l_ind).user_transaction_source := 'ENTERPRISE INSTALL BASE';
353: l_nl_pa_tbl(l_ind).last_update_date := sysdate;
354: l_nl_pa_tbl(l_ind).last_updated_by := fnd_global.user_id;
355: l_nl_pa_tbl(l_ind).creation_date := sysdate;
356: l_nl_pa_tbl(l_ind).created_by := fnd_global.user_Id;
357: l_nl_pa_tbl(l_ind).vendor_number := p_ap_pa_tbl(ind).vendor_num;
358: l_nl_pa_tbl(l_ind).vendor_id := p_ap_pa_tbl(ind).vendor_id;

Line 356: l_nl_pa_tbl(l_ind).created_by := fnd_global.user_Id;

352: l_nl_pa_tbl(l_ind).user_transaction_source := 'ENTERPRISE INSTALL BASE';
353: l_nl_pa_tbl(l_ind).last_update_date := sysdate;
354: l_nl_pa_tbl(l_ind).last_updated_by := fnd_global.user_id;
355: l_nl_pa_tbl(l_ind).creation_date := sysdate;
356: l_nl_pa_tbl(l_ind).created_by := fnd_global.user_Id;
357: l_nl_pa_tbl(l_ind).vendor_number := p_ap_pa_tbl(ind).vendor_num;
358: l_nl_pa_tbl(l_ind).vendor_id := p_ap_pa_tbl(ind).vendor_id;
359: l_nl_pa_tbl(l_ind).inventory_item_id := p_ap_pa_tbl(ind).inventory_item_id;
360: l_nl_pa_tbl(l_ind).project_id := p_ap_pa_tbl(ind).project_id;

Line 706: last_updated_by = fnd_global.user_id,

702:
703: UPDATE ap_invoice_distributions_all
704: SET pa_addition_flag = 'Y',
705: last_update_date = sysdate,
706: last_updated_by = fnd_global.user_id,
707: last_update_login = fnd_global.login_id,
708: request_id = fnd_global.conc_request_id
709: WHERE invoice_distribution_id = ap_inv_rec.invoice_distribution_id;
710:

Line 707: last_update_login = fnd_global.login_id,

703: UPDATE ap_invoice_distributions_all
704: SET pa_addition_flag = 'Y',
705: last_update_date = sysdate,
706: last_updated_by = fnd_global.user_id,
707: last_update_login = fnd_global.login_id,
708: request_id = fnd_global.conc_request_id
709: WHERE invoice_distribution_id = ap_inv_rec.invoice_distribution_id;
710:
711: IF l_ap_ft_tbl.COUNT > 0 THEN

Line 708: request_id = fnd_global.conc_request_id

704: SET pa_addition_flag = 'Y',
705: last_update_date = sysdate,
706: last_updated_by = fnd_global.user_id,
707: last_update_login = fnd_global.login_id,
708: request_id = fnd_global.conc_request_id
709: WHERE invoice_distribution_id = ap_inv_rec.invoice_distribution_id;
710:
711: IF l_ap_ft_tbl.COUNT > 0 THEN
712: FOR l_ind IN l_ap_ft_tbl.FIRST .. l_ap_ft_tbl.LAST

Line 727: l_txn_error_rec.source_group_ref_id := fnd_global.conc_request_id;

723: WHEN fnd_api.g_exc_error THEN
724:
725: l_txn_error_rec := CSE_UTIL_PKG.init_txn_error_Rec;
726: l_txn_error_rec.error_text := nvl(l_error_message,cse_util_pkg.dump_error_stack);
727: l_txn_error_rec.source_group_ref_id := fnd_global.conc_request_id;
728: l_txn_error_rec.source_type := 'CSEIPVP';
729: l_txn_error_rec.source_id := l_inv_dist_id;
730: l_txn_error_rec.processed_flag := 'N';
731: