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.FV_IPAC_DISBURSEMENT_PKG dependencies on FV_IPAC_IMPORT

Line 12: g_status_preprocessed fv_ipac_import.record_status%TYPE;

8: g_user_id NUMBER;
9: g_login_id NUMBER;
10: g_org_id NUMBER;
11: g_set_of_books_id NUMBER;
12: g_status_preprocessed fv_ipac_import.record_status%TYPE;
13: g_status_imported fv_ipac_import.record_status%TYPE;
14: g_status_no_process fv_ipac_import.record_status%TYPE;
15: g_status_processed fv_ipac_import.record_status%TYPE;
16: g_status_error fv_ipac_import.record_status%TYPE;

Line 13: g_status_imported fv_ipac_import.record_status%TYPE;

9: g_login_id NUMBER;
10: g_org_id NUMBER;
11: g_set_of_books_id NUMBER;
12: g_status_preprocessed fv_ipac_import.record_status%TYPE;
13: g_status_imported fv_ipac_import.record_status%TYPE;
14: g_status_no_process fv_ipac_import.record_status%TYPE;
15: g_status_processed fv_ipac_import.record_status%TYPE;
16: g_status_error fv_ipac_import.record_status%TYPE;
17: g_status_other_error fv_ipac_import.record_status%TYPE;

Line 14: g_status_no_process fv_ipac_import.record_status%TYPE;

10: g_org_id NUMBER;
11: g_set_of_books_id NUMBER;
12: g_status_preprocessed fv_ipac_import.record_status%TYPE;
13: g_status_imported fv_ipac_import.record_status%TYPE;
14: g_status_no_process fv_ipac_import.record_status%TYPE;
15: g_status_processed fv_ipac_import.record_status%TYPE;
16: g_status_error fv_ipac_import.record_status%TYPE;
17: g_status_other_error fv_ipac_import.record_status%TYPE;
18: g_status_ap_imported fv_ipac_import.record_status%TYPE;

Line 15: g_status_processed fv_ipac_import.record_status%TYPE;

11: g_set_of_books_id NUMBER;
12: g_status_preprocessed fv_ipac_import.record_status%TYPE;
13: g_status_imported fv_ipac_import.record_status%TYPE;
14: g_status_no_process fv_ipac_import.record_status%TYPE;
15: g_status_processed fv_ipac_import.record_status%TYPE;
16: g_status_error fv_ipac_import.record_status%TYPE;
17: g_status_other_error fv_ipac_import.record_status%TYPE;
18: g_status_ap_imported fv_ipac_import.record_status%TYPE;
19: g_ia_paygroup fv_operating_units.payables_ia_paygroup%TYPE;

Line 16: g_status_error fv_ipac_import.record_status%TYPE;

12: g_status_preprocessed fv_ipac_import.record_status%TYPE;
13: g_status_imported fv_ipac_import.record_status%TYPE;
14: g_status_no_process fv_ipac_import.record_status%TYPE;
15: g_status_processed fv_ipac_import.record_status%TYPE;
16: g_status_error fv_ipac_import.record_status%TYPE;
17: g_status_other_error fv_ipac_import.record_status%TYPE;
18: g_status_ap_imported fv_ipac_import.record_status%TYPE;
19: g_ia_paygroup fv_operating_units.payables_ia_paygroup%TYPE;
20: g_enter VARCHAR2(10);

Line 17: g_status_other_error fv_ipac_import.record_status%TYPE;

13: g_status_imported fv_ipac_import.record_status%TYPE;
14: g_status_no_process fv_ipac_import.record_status%TYPE;
15: g_status_processed fv_ipac_import.record_status%TYPE;
16: g_status_error fv_ipac_import.record_status%TYPE;
17: g_status_other_error fv_ipac_import.record_status%TYPE;
18: g_status_ap_imported fv_ipac_import.record_status%TYPE;
19: g_ia_paygroup fv_operating_units.payables_ia_paygroup%TYPE;
20: g_enter VARCHAR2(10);
21: g_exit VARCHAR2(10);

Line 18: g_status_ap_imported fv_ipac_import.record_status%TYPE;

14: g_status_no_process fv_ipac_import.record_status%TYPE;
15: g_status_processed fv_ipac_import.record_status%TYPE;
16: g_status_error fv_ipac_import.record_status%TYPE;
17: g_status_other_error fv_ipac_import.record_status%TYPE;
18: g_status_ap_imported fv_ipac_import.record_status%TYPE;
19: g_ia_paygroup fv_operating_units.payables_ia_paygroup%TYPE;
20: g_enter VARCHAR2(10);
21: g_exit VARCHAR2(10);
22:

Line 251: --* : fv_ipac_import_errors table *--

247: --****************************************************************************************--
248: --* Name : insert_error *--
249: --* Type : Procedure *--
250: --* Purpose : This procedure inserts the import errors into the table *--
251: --* : fv_ipac_import_errors table *--
252: --* Parameters : p_ipac_import_id IN The import id *--
253: --* : p_validation_code IN The validation Code *--
254: --* : p_validation_err IN The Validation Error *--
255: --* : p_errbuf OUT Error returned to the calling process *--

Line 272: --* Tables Used : fv_ipac_import_errors INSERT *--

268: --* : validate_duns *--
269: --* : validate_po *--
270: --* Calls : fv_utility.debug_mesg *--
271: --* : fv_utility.log_mesg *--
272: --* Tables Used : fv_ipac_import_errors INSERT *--
273: --* Logic : Inserts the record into table fv_ipac_import_errors *--
274: --* : using the input variables *--
275: --****************************************************************************************--
276: PROCEDURE insert_error

Line 273: --* Logic : Inserts the record into table fv_ipac_import_errors *--

269: --* : validate_po *--
270: --* Calls : fv_utility.debug_mesg *--
271: --* : fv_utility.log_mesg *--
272: --* Tables Used : fv_ipac_import_errors INSERT *--
273: --* Logic : Inserts the record into table fv_ipac_import_errors *--
274: --* : using the input variables *--
275: --****************************************************************************************--
276: PROCEDURE insert_error
277: (

Line 278: p_ipac_import_id IN fv_ipac_import_errors.ipac_import_id%TYPE,

274: --* : using the input variables *--
275: --****************************************************************************************--
276: PROCEDURE insert_error
277: (
278: p_ipac_import_id IN fv_ipac_import_errors.ipac_import_id%TYPE,
279: p_validation_code IN fv_ipac_import_errors.error_code%TYPE,
280: p_validation_err IN fv_ipac_import_errors.error_desc%TYPE,
281: p_error_code OUT NOCOPY NUMBER,
282: p_error_desc OUT NOCOPY VARCHAR2

Line 279: p_validation_code IN fv_ipac_import_errors.error_code%TYPE,

275: --****************************************************************************************--
276: PROCEDURE insert_error
277: (
278: p_ipac_import_id IN fv_ipac_import_errors.ipac_import_id%TYPE,
279: p_validation_code IN fv_ipac_import_errors.error_code%TYPE,
280: p_validation_err IN fv_ipac_import_errors.error_desc%TYPE,
281: p_error_code OUT NOCOPY NUMBER,
282: p_error_desc OUT NOCOPY VARCHAR2
283: )

Line 280: p_validation_err IN fv_ipac_import_errors.error_desc%TYPE,

276: PROCEDURE insert_error
277: (
278: p_ipac_import_id IN fv_ipac_import_errors.ipac_import_id%TYPE,
279: p_validation_code IN fv_ipac_import_errors.error_code%TYPE,
280: p_validation_err IN fv_ipac_import_errors.error_desc%TYPE,
281: p_error_code OUT NOCOPY NUMBER,
282: p_error_desc OUT NOCOPY VARCHAR2
283: )
284: IS

Line 300: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Inserting into fv_ipac_import_errors');

296: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'p_validation_err = '||p_validation_err);
297: END IF;
298:
299: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
300: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Inserting into fv_ipac_import_errors');
301: END IF;
302: INSERT INTO fv_ipac_import_errors
303: (
304: ipac_import_id,

Line 302: INSERT INTO fv_ipac_import_errors

298:
299: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
300: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Inserting into fv_ipac_import_errors');
301: END IF;
302: INSERT INTO fv_ipac_import_errors
303: (
304: ipac_import_id,
305: error_code,
306: error_desc

Line 900: --* : fv_ipac_import SELECT, UPDATE *--

896: --* : fv_utility.log_mesg *--
897: --* Tables Used : ap_invoices_interface SELECT *--
898: --* : ap_invoice_lines_interface SELECT *--
899: --* : ap_interface_rejections SELECT *--
900: --* : fv_ipac_import SELECT, UPDATE *--
901: --* : ap_lookup_codes SELECT *--
902: --* Logic : Go through ap_interface_rejections for the group id and see *--
903: --* : if there are any header errors. If so insert the errors into *--
904: --* : fv_ipac_import_errors and update the table fv_ipac_import with *--

Line 904: --* : fv_ipac_import_errors and update the table fv_ipac_import with *--

900: --* : fv_ipac_import SELECT, UPDATE *--
901: --* : ap_lookup_codes SELECT *--
902: --* Logic : Go through ap_interface_rejections for the group id and see *--
903: --* : if there are any header errors. If so insert the errors into *--
904: --* : fv_ipac_import_errors and update the table fv_ipac_import with *--
905: --* : error status. *--
906: --* : Go through ap_interface_rejections for the group id and see *--
907: --* : if there are any line errors. If so insert the errors into *--
908: --* : fv_ipac_import_errors and update the table fv_ipac_import with *--

Line 908: --* : fv_ipac_import_errors and update the table fv_ipac_import with *--

904: --* : fv_ipac_import_errors and update the table fv_ipac_import with *--
905: --* : error status. *--
906: --* : Go through ap_interface_rejections for the group id and see *--
907: --* : if there are any line errors. If so insert the errors into *--
908: --* : fv_ipac_import_errors and update the table fv_ipac_import with *--
909: --* : error status. *--
910: --****************************************************************************************--
911: PROCEDURE check_for_ap_import_errors
912: (

Line 940: fv_ipac_import fii,

936: fii.ipac_import_id,
937: alc.description
938: FROM ap_invoices_interface aii,
939: ap_interface_rejections air,
940: fv_ipac_import fii,
941: ap_lookup_codes alc
942: WHERE aii.group_id = p_group_id
943: AND aii.status = 'REJECTED'
944: AND aii.invoice_id = air.parent_id

Line 975: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'UPDATE fv_ipac_import1');

971:
972: IF (p_error_code = g_SUCCESS) THEN
973: BEGIN
974: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
975: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'UPDATE fv_ipac_import1');
976: END IF;
977: UPDATE fv_ipac_import
978: SET record_status = g_status_error
979: WHERE ipac_import_id = invoices_rec.ipac_import_id;

Line 977: UPDATE fv_ipac_import

973: BEGIN
974: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
975: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'UPDATE fv_ipac_import1');
976: END IF;
977: UPDATE fv_ipac_import
978: SET record_status = g_status_error
979: WHERE ipac_import_id = invoices_rec.ipac_import_id;
980: l_rowcount := SQL%ROWCOUNT;
981: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 989: l_location := l_module_name||'.update_fv_ipac_import1';

985: EXCEPTION
986: WHEN OTHERS THEN
987: p_error_code := g_FAILURE;
988: p_error_desc := SQLERRM;
989: l_location := l_module_name||'.update_fv_ipac_import1';
990: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
991: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
992: END;
993: END IF;

Line 1013: fv_ipac_import fii,

1009: alc.description
1010: FROM ap_invoices_interface aii,
1011: ap_invoice_lines_interface aili,
1012: ap_interface_rejections air,
1013: fv_ipac_import fii,
1014: ap_lookup_codes alc
1015: WHERE aii.group_id = p_group_id
1016: AND aii.status = 'REJECTED'
1017: AND aili.invoice_line_id = air.parent_id

Line 1047: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'UPDATE fv_ipac_import2');

1043:
1044: IF (p_error_code = g_SUCCESS) THEN
1045: BEGIN
1046: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1047: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'UPDATE fv_ipac_import2');
1048: END IF;
1049: UPDATE fv_ipac_import
1050: SET record_status = g_status_error
1051: WHERE ipac_import_id = invoice_lines_rec.ipac_import_id;

Line 1049: UPDATE fv_ipac_import

1045: BEGIN
1046: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1047: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'UPDATE fv_ipac_import2');
1048: END IF;
1049: UPDATE fv_ipac_import
1050: SET record_status = g_status_error
1051: WHERE ipac_import_id = invoice_lines_rec.ipac_import_id;
1052: l_rowcount := SQL%ROWCOUNT;
1053: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 1060: l_location := l_module_name||'.update_fv_ipac_import2';

1056: EXCEPTION
1057: WHEN OTHERS THEN
1058: p_error_code := g_FAILURE;
1059: p_error_desc := SQLERRM;
1060: l_location := l_module_name||'.update_fv_ipac_import2';
1061: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
1062: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
1063: END;
1064: END IF;

Line 1550: --* Tables Used : fv_ipac_import DELETE, UPDATE *--

1546: --* Calls : fv_utility.debug_mesg *--
1547: --* : fv_utility.log_mesg *--
1548: --* Sequence Used : ap_interface_groups_s *--
1549: --* : fv_ipac_batch_s *--
1550: --* Tables Used : fv_ipac_import DELETE, UPDATE *--
1551: --* Logic : 1. Get sequence number from fv_ipac_batch_s *--
1552: --* : 2. Get sequence number from ap_interface_groups_s *--
1553: --* : 3. Delete records from fv_ipac_import which does not belong to the *--
1554: --* : parameter alc code. *--

Line 1553: --* : 3. Delete records from fv_ipac_import which does not belong to the *--

1549: --* : fv_ipac_batch_s *--
1550: --* Tables Used : fv_ipac_import DELETE, UPDATE *--
1551: --* Logic : 1. Get sequence number from fv_ipac_batch_s *--
1552: --* : 2. Get sequence number from ap_interface_groups_s *--
1553: --* : 3. Delete records from fv_ipac_import which does not belong to the *--
1554: --* : parameter alc code. *--
1555: --* : 4. Delete records from fv_ipac_import where transction type is in *--
1556: --* : A or P. *--
1557: --* : 5. Update the who coulumns and other columns with relevant *--

Line 1555: --* : 4. Delete records from fv_ipac_import where transction type is in *--

1551: --* Logic : 1. Get sequence number from fv_ipac_batch_s *--
1552: --* : 2. Get sequence number from ap_interface_groups_s *--
1553: --* : 3. Delete records from fv_ipac_import which does not belong to the *--
1554: --* : parameter alc code. *--
1555: --* : 4. Delete records from fv_ipac_import where transction type is in *--
1556: --* : A or P. *--
1557: --* : 5. Update the who coulumns and other columns with relevant *--
1558: --* : information *--
1559: --****************************************************************************************--

Line 1613: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Updating fv_ipac_import');

1609:
1610: IF (p_error_code = g_SUCCESS) THEN
1611: BEGIN
1612: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1613: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Updating fv_ipac_import');
1614: END IF;
1615: UPDATE fv_ipac_import
1616: SET request_id = g_request_id,
1617: record_status = g_status_preprocessed,

Line 1615: UPDATE fv_ipac_import

1611: BEGIN
1612: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1613: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Updating fv_ipac_import');
1614: END IF;
1615: UPDATE fv_ipac_import
1616: SET request_id = g_request_id,
1617: record_status = g_status_preprocessed,
1618: created_by = g_user_id,
1619: last_updated_by = g_user_id,

Line 1636: l_location := l_module_name||'.update_fv_ipac_import';

1632: EXCEPTION
1633: WHEN OTHERS THEN
1634: p_error_code := g_FAILURE;
1635: p_error_desc := SQLERRM;
1636: l_location := l_module_name||'.update_fv_ipac_import';
1637: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
1638: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
1639: END;
1640: END IF;

Line 1647: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Deleting fv_ipac_import');

1643: IF (p_error_code = g_SUCCESS) THEN
1644: BEGIN
1645: -- Delete all 'A' and 'P' records and keep only valid disbursement records
1646: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1647: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Deleting fv_ipac_import');
1648: END IF;
1649: DELETE fv_ipac_import
1650: WHERE group_id = p_group_id
1651: AND record_status = g_status_preprocessed

Line 1649: DELETE fv_ipac_import

1645: -- Delete all 'A' and 'P' records and keep only valid disbursement records
1646: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1647: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Deleting fv_ipac_import');
1648: END IF;
1649: DELETE fv_ipac_import
1650: WHERE group_id = p_group_id
1651: AND record_status = g_status_preprocessed
1652: AND (transaction_type IN ('A', 'P')
1653: OR customer_alc <> p_Agency_Location_Code);

Line 1662: fv_utility.log_mesg(fnd_log.level_unexpected, l_module_name||'.update_fv_ipac_import',p_error_desc) ;

1658: EXCEPTION
1659: WHEN OTHERS THEN
1660: p_error_code := g_FAILURE;
1661: p_error_desc := SQLERRM;
1662: fv_utility.log_mesg(fnd_log.level_unexpected, l_module_name||'.update_fv_ipac_import',p_error_desc) ;
1663: END;
1664: END IF;
1665: */
1666:

Line 1670: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Rejecting fv_ipac_import for A and P records');

1666:
1667: IF (p_error_code = g_SUCCESS) THEN
1668: -- Reject all 'A' and 'P' records and keep only valid disbursement records
1669: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1670: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Rejecting fv_ipac_import for A and P records');
1671: END IF;
1672: FOR del_rec IN (SELECT ipac_import_id
1673: FROM fv_ipac_import
1674: WHERE group_id = p_group_id

Line 1673: FROM fv_ipac_import

1669: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1670: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Rejecting fv_ipac_import for A and P records');
1671: END IF;
1672: FOR del_rec IN (SELECT ipac_import_id
1673: FROM fv_ipac_import
1674: WHERE group_id = p_group_id
1675: AND record_status = g_status_preprocessed
1676: AND transaction_type IN ('A', 'P')) LOOP
1677: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 1690: UPDATE fv_ipac_import

1686: p_error_desc => p_error_desc
1687: );
1688:
1689: BEGIN
1690: UPDATE fv_ipac_import
1691: SET record_status = g_status_error
1692: WHERE ipac_import_id = del_rec.ipac_import_id;
1693: EXCEPTION
1694: WHEN OTHERS THEN

Line 1697: l_location := l_module_name||'.update_fv_ipac_import1';

1693: EXCEPTION
1694: WHEN OTHERS THEN
1695: p_error_code := g_FAILURE;
1696: p_error_desc := SQLERRM;
1697: l_location := l_module_name||'.update_fv_ipac_import1';
1698: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
1699: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
1700: END;
1701: END LOOP;

Line 1710: FROM fv_ipac_import

1706: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1707: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Rejecting not selected ALC records');
1708: END IF;
1709: FOR del_rec IN (SELECT ipac_import_id
1710: FROM fv_ipac_import
1711: WHERE group_id = p_group_id
1712: AND record_status = g_status_preprocessed
1713: AND customer_alc <> p_Agency_Location_Code) LOOP
1714: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 1727: UPDATE fv_ipac_import

1723: p_error_desc => p_error_desc
1724: );
1725:
1726: BEGIN
1727: UPDATE fv_ipac_import
1728: SET record_status = g_status_error
1729: WHERE ipac_import_id = del_rec.ipac_import_id;
1730: EXCEPTION
1731: WHEN OTHERS THEN

Line 1734: l_location := l_module_name||'.update_fv_ipac_import1';

1730: EXCEPTION
1731: WHEN OTHERS THEN
1732: p_error_code := g_FAILURE;
1733: p_error_desc := SQLERRM;
1734: l_location := l_module_name||'.update_fv_ipac_import1';
1735: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
1736: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
1737: END;
1738: END LOOP;

Line 2021: p_ipac_import_id IN fv_ipac_import.ipac_import_id%TYPE,

2017: --* : 5. If the UOM could not be resolved insert an error *--
2018: --****************************************************************************************--
2019: PROCEDURE resolve_uom
2020: (
2021: p_ipac_import_id IN fv_ipac_import.ipac_import_id%TYPE,
2022: p_uom_code IN mtl_units_of_measure_vl.uom_code%TYPE,
2023: p_unit_of_measure IN OUT NOCOPY mtl_units_of_measure_vl.unit_of_measure%TYPE,
2024: p_record_status OUT NOCOPY fv_ipac_import.record_status%TYPE,
2025: p_error_code OUT NOCOPY NUMBER,

Line 2024: p_record_status OUT NOCOPY fv_ipac_import.record_status%TYPE,

2020: (
2021: p_ipac_import_id IN fv_ipac_import.ipac_import_id%TYPE,
2022: p_uom_code IN mtl_units_of_measure_vl.uom_code%TYPE,
2023: p_unit_of_measure IN OUT NOCOPY mtl_units_of_measure_vl.unit_of_measure%TYPE,
2024: p_record_status OUT NOCOPY fv_ipac_import.record_status%TYPE,
2025: p_error_code OUT NOCOPY NUMBER,
2026: p_error_desc OUT NOCOPY VARCHAR2
2027: )
2028: IS

Line 2172: p_ipac_import_rec IN OUT NOCOPY fv_ipac_import%ROWTYPE,

2168: --* : an error PO_SITE_MISMATCH and insert the error and return *--
2169: --****************************************************************************************--
2170: PROCEDURE validate_duns
2171: (
2172: p_ipac_import_rec IN OUT NOCOPY fv_ipac_import%ROWTYPE,
2173: p_error_code OUT NOCOPY NUMBER,
2174: p_error_desc OUT NOCOPY VARCHAR2
2175: )
2176: IS

Line 2180: l_validation_code fv_ipac_import_errors.error_code%TYPE;

2176: IS
2177: l_module_name VARCHAR2(200);
2178: l_location VARCHAR2(200);
2179: l_dummy VARCHAR2(1);
2180: l_validation_code fv_ipac_import_errors.error_code%TYPE;
2181: l_validation_err fv_ipac_import_errors.error_desc%TYPE;
2182: l_vendor_site_id po_vendor_sites.vendor_site_id%TYPE;
2183: BEGIN
2184: l_module_name := g_module_name || 'validate_duns';

Line 2181: l_validation_err fv_ipac_import_errors.error_desc%TYPE;

2177: l_module_name VARCHAR2(200);
2178: l_location VARCHAR2(200);
2179: l_dummy VARCHAR2(1);
2180: l_validation_code fv_ipac_import_errors.error_code%TYPE;
2181: l_validation_err fv_ipac_import_errors.error_desc%TYPE;
2182: l_vendor_site_id po_vendor_sites.vendor_site_id%TYPE;
2183: BEGIN
2184: l_module_name := g_module_name || 'validate_duns';
2185: p_error_code := g_SUCCESS;

Line 2332: p_ipac_import_rec IN OUT NOCOPY fv_ipac_import%ROWTYPE,

2328: --* Logic : *--
2329: --****************************************************************************************--
2330: PROCEDURE validate_po
2331: (
2332: p_ipac_import_rec IN OUT NOCOPY fv_ipac_import%ROWTYPE,
2333: p_ap_inv_lines_rec IN OUT NOCOPY ap_invoice_lines_interface%ROWTYPE,
2334: p_error_code OUT NOCOPY NUMBER,
2335: p_error_desc OUT NOCOPY VARCHAR2
2336: )

Line 2345: l_validation_code fv_ipac_import_errors.error_code%TYPE;

2341: l_line_closed_code po_lines.closed_code%TYPE;
2342: l_count_po_disb_lines NUMBER;
2343: l_count_matched_disb_lines NUMBER;
2344: l_exists NUMBER;
2345: l_validation_code fv_ipac_import_errors.error_code%TYPE;
2346: l_validation_err fv_ipac_import_errors.error_desc%TYPE;
2347: l_invoice_found VARCHAR2(1);
2348: l_amount NUMBER;
2349: l_recurr_invoice_id NUMBER;

Line 2346: l_validation_err fv_ipac_import_errors.error_desc%TYPE;

2342: l_count_po_disb_lines NUMBER;
2343: l_count_matched_disb_lines NUMBER;
2344: l_exists NUMBER;
2345: l_validation_code fv_ipac_import_errors.error_code%TYPE;
2346: l_validation_err fv_ipac_import_errors.error_desc%TYPE;
2347: l_invoice_found VARCHAR2(1);
2348: l_amount NUMBER;
2349: l_recurr_invoice_id NUMBER;
2350: BEGIN

Line 2904: --* Tables Used : fv_ipac_import SELECT, UPDATE *--

2900: --* : insert_invoice_line *--
2901: --* : fv_utility.debug_mesg *--
2902: --* : fv_utility.log_mesg *--
2903: --* Sequence Used : ap_invoices_interface_s *--
2904: --* Tables Used : fv_ipac_import SELECT, UPDATE *--
2905: --* Logic : 1. Pre process the data to get the group_id handle *--
2906: --* : 2. Process every record from fv_ipac_import table *--
2907: --* : 3. Validate the PO. *--
2908: --* : 4. Validate the DUNS *--

Line 2906: --* : 2. Process every record from fv_ipac_import table *--

2902: --* : fv_utility.log_mesg *--
2903: --* Sequence Used : ap_invoices_interface_s *--
2904: --* Tables Used : fv_ipac_import SELECT, UPDATE *--
2905: --* Logic : 1. Pre process the data to get the group_id handle *--
2906: --* : 2. Process every record from fv_ipac_import table *--
2907: --* : 3. Validate the PO. *--
2908: --* : 4. Validate the DUNS *--
2909: --* : 5. Resolve the UOM *--
2910: --* : 6. If all is well insert data into ap interface tables. *--

Line 2925: l_ipac_import_record fv_ipac_import%ROWTYPE;

2921: )
2922: IS
2923: l_module_name VARCHAR2(200);
2924: l_location VARCHAR2(200);
2925: l_ipac_import_record fv_ipac_import%ROWTYPE;
2926: l_inv_hdrs_interface_rec ap_invoices_interface%ROWTYPE;
2927: l_inv_lines_interface_rec ap_invoice_lines_interface%ROWTYPE;
2928: l_inv_hdrs_interface_rec_null ap_invoices_interface%ROWTYPE;
2929: l_inv_lines_interface_rec_null ap_invoice_lines_interface%ROWTYPE;

Line 2930: l_save_invoice_number fv_ipac_import.invoice_number%TYPE;

2926: l_inv_hdrs_interface_rec ap_invoices_interface%ROWTYPE;
2927: l_inv_lines_interface_rec ap_invoice_lines_interface%ROWTYPE;
2928: l_inv_hdrs_interface_rec_null ap_invoices_interface%ROWTYPE;
2929: l_inv_lines_interface_rec_null ap_invoice_lines_interface%ROWTYPE;
2930: l_save_invoice_number fv_ipac_import.invoice_number%TYPE;
2931: l_ok_to_insert_inv VARCHAR2(1);
2932: l_current_inv_lines NUMBER;
2933: l_no_of_invoices_inserted NUMBER;
2934: l_rowcount NUMBER;

Line 2941: FROM fv_ipac_import fii

2937: (
2938: c_group_id NUMBER
2939: )IS
2940: SELECT *
2941: FROM fv_ipac_import fii
2942: WHERE fii.group_id = c_group_id
2943: AND fii.record_status = g_status_preprocessed
2944: ORDER BY fii.invoice_number;
2945: BEGIN

Line 3283: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Updating fv_ipac_import');

3279: <>
3280: IF (p_error_code = g_SUCCESS) THEN
3281: BEGIN
3282: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3283: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Updating fv_ipac_import');
3284: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'record_status='||l_ipac_import_record.record_status);
3285: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'invoice_id='||l_ipac_import_record.invoice_id);
3286: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'invoice_line_id='||l_ipac_import_record.invoice_line_id);
3287: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'actual_po_number='||l_ipac_import_record.actual_po_number);

Line 3293: UPDATE fv_ipac_import fii

3289: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'vendor_id='||l_ipac_import_record.vendor_id);
3290: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'vendor_site_id='||l_ipac_import_record.vendor_site_id);
3291: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'ipac_import_id='||l_ipac_import_record.ipac_import_id);
3292: END IF;
3293: UPDATE fv_ipac_import fii
3294: SET record_status = l_ipac_import_record.record_status,
3295: invoice_id = l_ipac_import_record.invoice_id,
3296: int_invoice_id = l_inv_lines_interface_rec.invoice_id,
3297: int_invoice_line_id = l_inv_lines_interface_rec.invoice_line_id,

Line 3305: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,'Updated '||l_rowcount||' rows in fv_ipac_import.');

3301: vendor_site_id = l_inv_hdrs_interface_rec.vendor_site_id
3302: WHERE fii.ipac_import_id = l_ipac_import_record.ipac_import_id;
3303: l_rowcount := SQL%ROWCOUNT;
3304: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3305: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,'Updated '||l_rowcount||' rows in fv_ipac_import.');
3306: END IF;
3307: EXCEPTION
3308: WHEN OTHERS THEN
3309: p_error_code := g_FAILURE;

Line 3311: l_location := l_module_name||'update_fv_ipac_import';

3307: EXCEPTION
3308: WHEN OTHERS THEN
3309: p_error_code := g_FAILURE;
3310: p_error_desc := SQLERRM;
3311: l_location := l_module_name||'update_fv_ipac_import';
3312: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
3313: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
3314: END;
3315: END IF;

Line 3394: --* Tables Used : fv_ipac_import DELETE *--

3390: --* : g_exit READ *--
3391: --* Called from : load_data_file *--
3392: --* Calls : fv_utility.debug_mesg *--
3393: --* : fv_utility.log_mesg *--
3394: --* Tables Used : fv_ipac_import DELETE *--
3395: --* Logic : Delete all records from fv_ipac_import table with status IMPORTED *--
3396: --****************************************************************************************--
3397: PROCEDURE cleanup_previous_failed_run
3398: (

Line 3395: --* Logic : Delete all records from fv_ipac_import table with status IMPORTED *--

3391: --* Called from : load_data_file *--
3392: --* Calls : fv_utility.debug_mesg *--
3393: --* : fv_utility.log_mesg *--
3394: --* Tables Used : fv_ipac_import DELETE *--
3395: --* Logic : Delete all records from fv_ipac_import table with status IMPORTED *--
3396: --****************************************************************************************--
3397: PROCEDURE cleanup_previous_failed_run
3398: (
3399: p_error_code OUT NOCOPY NUMBER,

Line 3415: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Deleting fv_ipac_import');

3411: END IF;
3412:
3413: BEGIN
3414: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3415: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Deleting fv_ipac_import');
3416: END IF;
3417: DELETE fv_ipac_import
3418: WHERE record_status = 'IMPORTED';
3419: l_rowcount := SQL%ROWCOUNT;

Line 3417: DELETE fv_ipac_import

3413: BEGIN
3414: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3415: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Deleting fv_ipac_import');
3416: END IF;
3417: DELETE fv_ipac_import
3418: WHERE record_status = 'IMPORTED';
3419: l_rowcount := SQL%ROWCOUNT;
3420: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3421: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,'Deleted '||l_rowcount||' rows from fv_ipac_import.');

Line 3421: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,'Deleted '||l_rowcount||' rows from fv_ipac_import.');

3417: DELETE fv_ipac_import
3418: WHERE record_status = 'IMPORTED';
3419: l_rowcount := SQL%ROWCOUNT;
3420: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3421: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,'Deleted '||l_rowcount||' rows from fv_ipac_import.');
3422: END IF;
3423: EXCEPTION
3424: WHEN OTHERS THEN
3425: p_error_code := g_FAILURE;

Line 3427: l_location := l_module_name||'.delete_fv_ipac_import';

3423: EXCEPTION
3424: WHEN OTHERS THEN
3425: p_error_code := g_FAILURE;
3426: p_error_desc := SQLERRM;
3427: l_location := l_module_name||'.delete_fv_ipac_import';
3428: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
3429: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
3430: END;
3431: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

Line 3468: --* Tables Used : fv_ipac_import SELECT, UPDATE *--

3464: --* : g_exit READ *--
3465: --* Called from : main *--
3466: --* Calls : fv_utility.debug_mesg *--
3467: --* : fv_utility.log_mesg *--
3468: --* Tables Used : fv_ipac_import SELECT, UPDATE *--
3469: --* : ap_interface_rejections DELETE *--
3470: --* : ap_invoice_lines_interface DELETE *--
3471: --* : ap_invoices_interface DELETE *--
3472: --* Logic : For each invoice number with status of ERROR in fv_ipac_import table *--

Line 3472: --* Logic : For each invoice number with status of ERROR in fv_ipac_import table *--

3468: --* Tables Used : fv_ipac_import SELECT, UPDATE *--
3469: --* : ap_interface_rejections DELETE *--
3470: --* : ap_invoice_lines_interface DELETE *--
3471: --* : ap_invoices_interface DELETE *--
3472: --* Logic : For each invoice number with status of ERROR in fv_ipac_import table *--
3473: --* : do the following *--
3474: --* : 1. Delete all data from ap_interface_rejections for lines *--
3475: --* : 2. Delete all data from ap_interface_rejections for header *--
3476: --* : 3. Delete all data from ap_invoice_lines_interface *--

Line 3478: --* : 5. Update all other records of fv_ipac_import table with same *--

3474: --* : 1. Delete all data from ap_interface_rejections for lines *--
3475: --* : 2. Delete all data from ap_interface_rejections for header *--
3476: --* : 3. Delete all data from ap_invoice_lines_interface *--
3477: --* : 4. Delete all data from ap_invoices_interface *--
3478: --* : 5. Update all other records of fv_ipac_import table with same *--
3479: --* : invoice and status of not ERROR to ERROR IN OTHER LINES *--
3480: --****************************************************************************************--
3481: PROCEDURE cleanup_current_failed_run
3482: (

Line 3507: FROM fv_ipac_import

3503: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Getting into cursor import_rec');
3504: END IF;
3505:
3506: FOR import_rec IN (SELECT invoice_number
3507: FROM fv_ipac_import
3508: WHERE group_id = p_group_id
3509: AND record_status = g_status_error) LOOP
3510:
3511: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 3617: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Updating fv_ipac_import');

3613:
3614: IF (p_error_code = g_SUCCESS) THEN
3615: BEGIN
3616: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3617: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Updating fv_ipac_import');
3618: END IF;
3619: UPDATE fv_ipac_import
3620: SET record_status = g_status_other_error
3621: WHERE group_id = p_group_id

Line 3619: UPDATE fv_ipac_import

3615: BEGIN
3616: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3617: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Updating fv_ipac_import');
3618: END IF;
3619: UPDATE fv_ipac_import
3620: SET record_status = g_status_other_error
3621: WHERE group_id = p_group_id
3622: AND invoice_number = import_rec.invoice_number
3623: AND record_status <> g_status_error;

Line 3626: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,'Updated '||l_rowcount||' rows in fv_ipac_import.');

3622: AND invoice_number = import_rec.invoice_number
3623: AND record_status <> g_status_error;
3624: l_rowcount := SQL%ROWCOUNT;
3625: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3626: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,'Updated '||l_rowcount||' rows in fv_ipac_import.');
3627: END IF;
3628: EXCEPTION
3629: WHEN OTHERS THEN
3630: p_error_code := g_FAILURE;

Line 3632: l_location := l_module_name||'.update_fv_ipac_import';

3628: EXCEPTION
3629: WHEN OTHERS THEN
3630: p_error_code := g_FAILURE;
3631: p_error_desc := SQLERRM;
3632: l_location := l_module_name||'.update_fv_ipac_import';
3633: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
3634: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
3635: END;
3636: END IF;

Line 3665: --* Purpose : This procedure moves all the processsed records from fv_ipac_import *--

3661: END;
3662: --****************************************************************************************--
3663: --* Name : move_data_to_history *--
3664: --* Type : Procedure *--
3665: --* Purpose : This procedure moves all the processsed records from fv_ipac_import *--
3666: --* : table into fv_ipac_import_history table *--
3667: --* Parameters : p_group_id IN The group id for which the data is processed *--
3668: --* : p_errbuf OUT Error returned to the concurrent process *--
3669: --* : p_retcode OUT Return Code to concurrent process *--

Line 3666: --* : table into fv_ipac_import_history table *--

3662: --****************************************************************************************--
3663: --* Name : move_data_to_history *--
3664: --* Type : Procedure *--
3665: --* Purpose : This procedure moves all the processsed records from fv_ipac_import *--
3666: --* : table into fv_ipac_import_history table *--
3667: --* Parameters : p_group_id IN The group id for which the data is processed *--
3668: --* : p_errbuf OUT Error returned to the concurrent process *--
3669: --* : p_retcode OUT Return Code to concurrent process *--
3670: --* Global Vars : g_module_name READ *--

Line 3682: --* Tables Used : fv_ipac_import_history INSERT *--

3678: --* : g_exit READ *--
3679: --* Called from : main *--
3680: --* Calls : fv_utility.debug_mesg *--
3681: --* : fv_utility.log_mesg *--
3682: --* Tables Used : fv_ipac_import_history INSERT *--
3683: --* : fv_ipac_import SELECT, DELETE *--
3684: --* Logic : 1. Insert into fv_ipac_import_history by selecting all processed *--
3685: --* : records from fv_ipac_import *--
3686: --* : 2. Delete all processed records from fv_ipac_import *--

Line 3683: --* : fv_ipac_import SELECT, DELETE *--

3679: --* Called from : main *--
3680: --* Calls : fv_utility.debug_mesg *--
3681: --* : fv_utility.log_mesg *--
3682: --* Tables Used : fv_ipac_import_history INSERT *--
3683: --* : fv_ipac_import SELECT, DELETE *--
3684: --* Logic : 1. Insert into fv_ipac_import_history by selecting all processed *--
3685: --* : records from fv_ipac_import *--
3686: --* : 2. Delete all processed records from fv_ipac_import *--
3687: --****************************************************************************************--

Line 3684: --* Logic : 1. Insert into fv_ipac_import_history by selecting all processed *--

3680: --* Calls : fv_utility.debug_mesg *--
3681: --* : fv_utility.log_mesg *--
3682: --* Tables Used : fv_ipac_import_history INSERT *--
3683: --* : fv_ipac_import SELECT, DELETE *--
3684: --* Logic : 1. Insert into fv_ipac_import_history by selecting all processed *--
3685: --* : records from fv_ipac_import *--
3686: --* : 2. Delete all processed records from fv_ipac_import *--
3687: --****************************************************************************************--
3688: PROCEDURE move_data_to_history

Line 3685: --* : records from fv_ipac_import *--

3681: --* : fv_utility.log_mesg *--
3682: --* Tables Used : fv_ipac_import_history INSERT *--
3683: --* : fv_ipac_import SELECT, DELETE *--
3684: --* Logic : 1. Insert into fv_ipac_import_history by selecting all processed *--
3685: --* : records from fv_ipac_import *--
3686: --* : 2. Delete all processed records from fv_ipac_import *--
3687: --****************************************************************************************--
3688: PROCEDURE move_data_to_history
3689: (

Line 3686: --* : 2. Delete all processed records from fv_ipac_import *--

3682: --* Tables Used : fv_ipac_import_history INSERT *--
3683: --* : fv_ipac_import SELECT, DELETE *--
3684: --* Logic : 1. Insert into fv_ipac_import_history by selecting all processed *--
3685: --* : records from fv_ipac_import *--
3686: --* : 2. Delete all processed records from fv_ipac_import *--
3687: --****************************************************************************************--
3688: PROCEDURE move_data_to_history
3689: (
3690: p_group_id IN NUMBER,

Line 3709: INSERT INTO fv_ipac_import_history

3705: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'p_group_id = '||p_group_id);
3706: END IF;
3707:
3708: BEGIN
3709: INSERT INTO fv_ipac_import_history
3710: (
3711: ipac_import_id,
3712: batch_name,
3713: transaction_id,

Line 4022: FROM fv_ipac_import

4018: group_id,
4019: data_file,
4020: int_invoice_id,
4021: int_invoice_line_id
4022: FROM fv_ipac_import
4023: WHERE group_id = p_group_id
4024: AND record_status = g_status_processed;
4025: l_rowcount := SQL%ROWCOUNT;
4026: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

Line 4027: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,'Inserted '||l_rowcount||' rows into fv_ipac_import_history.');

4023: WHERE group_id = p_group_id
4024: AND record_status = g_status_processed;
4025: l_rowcount := SQL%ROWCOUNT;
4026: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4027: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,'Inserted '||l_rowcount||' rows into fv_ipac_import_history.');
4028: END IF;
4029: EXCEPTION
4030: WHEN OTHERS THEN
4031: p_error_code := g_FAILURE;

Line 4033: l_location := l_module_name||'.insert_fv_ipac_import_history';

4029: EXCEPTION
4030: WHEN OTHERS THEN
4031: p_error_code := g_FAILURE;
4032: p_error_desc := SQLERRM;
4033: l_location := l_module_name||'.insert_fv_ipac_import_history';
4034: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
4035: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
4036: END;
4037:

Line 4039: DELETE FROM fv_ipac_import

4035: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
4036: END;
4037:
4038: BEGIN
4039: DELETE FROM fv_ipac_import
4040: WHERE group_id = p_group_id
4041: AND record_status = g_status_processed;
4042: l_rowcount := SQL%ROWCOUNT;
4043: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

Line 4044: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,'Deleted '||l_rowcount||' rows from fv_ipac_import.');

4040: WHERE group_id = p_group_id
4041: AND record_status = g_status_processed;
4042: l_rowcount := SQL%ROWCOUNT;
4043: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4044: fv_utility.debug_mesg(fnd_log.level_procedure, l_module_name,'Deleted '||l_rowcount||' rows from fv_ipac_import.');
4045: END IF;
4046: EXCEPTION
4047: WHEN OTHERS THEN
4048: p_error_code := g_FAILURE;

Line 4050: l_location := l_module_name||'.delete_fv_ipac_import';

4046: EXCEPTION
4047: WHEN OTHERS THEN
4048: p_error_code := g_FAILURE;
4049: p_error_desc := SQLERRM;
4050: l_location := l_module_name||'.delete_fv_ipac_import';
4051: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
4052: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
4053: END;
4054:

Line 4073: --* Purpose : Uploads the file into the table fv_ipac_import table *--

4069:
4070: --****************************************************************************************--
4071: --* Name : load_data_file *--
4072: --* Type : Procedure *--
4073: --* Purpose : Uploads the file into the table fv_ipac_import table *--
4074: --* Parameters : p_data_file_name IN The data file that is to be imported *--
4075: --* : p_errbuf OUT Error returned to the concurrent process *--
4076: --* : p_retcode OUT Return Code to concurrent process *--
4077: --* Global Vars : g_org_id READ *--

Line 4315: l_batch_name fv_ipac_import.batch_name%TYPE;

4311: IS
4312: l_module_name VARCHAR2(200);
4313: l_location VARCHAR2(200);
4314: l_batch_control VARCHAR2(1);
4315: l_batch_name fv_ipac_import.batch_name%TYPE;
4316: l_ok_to_import VARCHAR2(1);
4317: l_group_id NUMBER;
4318: BEGIN
4319: l_module_name := g_module_name || 'main';

Line 4386: * Load the data file into table fv_ipac_import *

4382: END IF;
4383:
4384: /*
4385: *****************************************************************************
4386: * Load the data file into table fv_ipac_import *
4387: *****************************************************************************
4388: */
4389: IF (p_retcode = g_SUCCESS) THEN
4390: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN