DBA Data[Home] [Help]

APPS.FV_FACTS1_GL_PKG dependencies on AP_SUPPLIERS

Line 1820: FROM ap_suppliers

1816: p_party_info_tab(i).vendor_type ,
1817: P_party_info_tab(i).elim_dept ,
1818: p_party_info_tab(i).recipient_name,
1819: P_party_info_tab(i).party_line_amount
1820: FROM ap_suppliers
1821: WHERE vendor_id = other_source_rec.party_id;
1822:
1823: p_party_info_tab(i).cust_vend_type := 'V';
1824: EXCEPTION

Line 1826: FV_UTILITY.LOG_MESG('No data found in ap_suppliers for vendor_id: '|| other_source_rec.party_id);

1822:
1823: p_party_info_tab(i).cust_vend_type := 'V';
1824: EXCEPTION
1825: WHEN NO_DATA_FOUND THEN
1826: FV_UTILITY.LOG_MESG('No data found in ap_suppliers for vendor_id: '|| other_source_rec.party_id);
1827: p_party_info_tab(i).party_id := other_source_rec.party_id;
1828: p_party_info_tab(i).cust_vend_type := 'V';
1829: P_party_info_tab(i).party_line_amount := other_source_rec.amount;
1830: p_party_info_tab(i).recipient_name := 'Other';

Line 1944: FROM ap_suppliers

1940: p_party_info_tab(i).vendor_type ,
1941: P_party_info_tab(i).elim_dept ,
1942: p_party_info_tab(i).recipient_name,
1943: P_party_info_tab(i).party_line_amount
1944: FROM ap_suppliers
1945: WHERE vendor_id = project_source_rec.party_id;
1946:
1947: p_party_info_tab(i).cust_vend_type := 'V';
1948: EXCEPTION

Line 1950: FV_UTILITY.LOG_MESG('No data found in ap_suppliers for vendor_id: '|| project_source_rec.party_id);

1946:
1947: p_party_info_tab(i).cust_vend_type := 'V';
1948: EXCEPTION
1949: WHEN NO_DATA_FOUND THEN
1950: FV_UTILITY.LOG_MESG('No data found in ap_suppliers for vendor_id: '|| project_source_rec.party_id);
1951: p_party_info_tab(i).party_id := project_source_rec.party_id;
1952: p_party_info_tab(i).cust_vend_type := 'V';
1953: P_party_info_tab(i).party_line_amount := project_source_rec.amount;
1954: p_party_info_tab(i).recipient_name := 'Other';