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_UDA_IMPORT_PKG dependencies on PO_UDA_IMPORT_PKG

Line 1: PACKAGE BODY po_uda_import_pkg AS

1: PACKAGE BODY po_uda_import_pkg AS
2: /* $Header: PO_UDA_IMPORT_PKG.plb 120.10.12020000.4 2013/02/19 10:06:50 pamandav ship $ */
3:
4: PENDING CONSTANT NUMBER := 1;
5: IN_PROGRESS CONSTANT NUMBER := 2;

Line 2: /* $Header: PO_UDA_IMPORT_PKG.plb 120.10.12020000.4 2013/02/19 10:06:50 pamandav ship $ */

1: PACKAGE BODY po_uda_import_pkg AS
2: /* $Header: PO_UDA_IMPORT_PKG.plb 120.10.12020000.4 2013/02/19 10:06:50 pamandav ship $ */
3:
4: PENDING CONSTANT NUMBER := 1;
5: IN_PROGRESS CONSTANT NUMBER := 2;
6: UDA_ERROR CONSTANT NUMBER := 3;

Line 168: WHERE PROCESS_STATUS = PO_UDA_IMPORT_PKG.IN_PROGRESS

164: ,LAST_UPDATED_BY_NAME
165: ,INTERFACE_SOURCE_CODE
166: ,INTERFACE_SOURCE_LINE_ID
167: FROM PO_UDA_INTERFACE
168: WHERE PROCESS_STATUS = PO_UDA_IMPORT_PKG.IN_PROGRESS
169: AND NVL(PK1_VALUE, -999) = NVL(p_pk1_value, -999)
170: AND NVL(PK2_VALUE, -999) = NVL(p_pk2_value, -999)
171: AND NVL(PK3_VALUE, -999) = NVL(p_pk3_value, -999)
172: AND NVL(PK4_VALUE, -999) = NVL(p_pk4_value, -999)

Line 183: PO_UDA_DEFAULTING_PKG.DEBUG('Starting PO_UDA_IMPORT_PKG.POPULATE_STRUCTURES with parameters' , d_progress);

179:
180:
181: BEGIN
182: d_progress := 10;
183: PO_UDA_DEFAULTING_PKG.DEBUG('Starting PO_UDA_IMPORT_PKG.POPULATE_STRUCTURES with parameters' , d_progress);
184: PO_UDA_DEFAULTING_PKG.DEBUG('p_attr_grp_type : ' || p_attr_grp_type, d_progress);
185: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk1_value : ' || p_pk1_value, d_progress);
186: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk2_value : ' || p_pk2_value, d_progress);
187: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk3_value : ' || p_pk2_value, d_progress);

Line 392: PO_UDA_IMPORT_PKG.HANDLE_ERROR

388: EXCEPTION
389: WHEN OTHERS THEN
390: l_err_txt := 'Exception in POPULATE_STRUCTURES with ERROR : ' || SQLERRM;
391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
392: PO_UDA_IMPORT_PKG.HANDLE_ERROR
393: (
394: p_msg => l_err_txt
395: ,p_msg_code => 'UNEXPECTED_POPULATE_STRUCTURES'
396: ,p_attr_grp_id => l_attr_group_id

Line 590: PO_UDA_IMPORT_PKG.HANDLE_ERROR

586: EXCEPTION
587: WHEN OTHERS THEN
588: l_err_txt := 'Exception in POPULATE_REMAINING_ATTRIBUTES with ERROR : ' || SQLERRM;
589: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
590: PO_UDA_IMPORT_PKG.HANDLE_ERROR
591: (
592: p_msg => l_err_txt
593: ,p_msg_code => 'UNEXPECTED_POPULATE_REMAINING_ATTRIBUTES'
594: ,p_attr_grp_id => l_attr_row_obj.ATTR_GROUP_ID

Line 1075: PO_UDA_IMPORT_PKG.HANDLE_ERROR

1071: IF DBMS_SQL.is_open(v_query_hdl) THEN
1072: DBMS_SQL.close_cursor(v_query_hdl);
1073: END IF ;
1074:
1075: PO_UDA_IMPORT_PKG.HANDLE_ERROR
1076: (
1077: p_msg => l_err_txt
1078: ,p_msg_code => 'UNEXPECTED_POPULATE_EMPTY_AGS'
1079: ,p_attr_grp_id => l_attr_row_obj.ATTR_GROUP_ID

Line 1403: PO_UDA_IMPORT_PKG.HANDLE_ERROR

1399:
1400: d_progress := 420;
1401: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1402: d_progress := 43;
1403: PO_UDA_IMPORT_PKG.HANDLE_ERROR
1404: (
1405: p_msg => 'There was an error in EXECUTE_IMPORT_UDA_FUNCTION for Action ID :' || l_action_id
1406: ,p_msg_code => 'ERROR_EXECUTE_IMPORT_UDA_FUNCTION'
1407: ,p_attr_grp_id => l_attr_row_obj.ATTR_GROUP_ID

Line 1469: PO_UDA_IMPORT_PKG.HANDLE_ERROR

1465: EXCEPTION
1466: WHEN OTHERS THEN
1467: l_err_txt := 'Exception in EXECUTE_IMPORT_UDA_FUNCTION with ERROR : ' || SQLERRM;
1468: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1469: PO_UDA_IMPORT_PKG.HANDLE_ERROR
1470: (
1471: p_msg => l_err_txt
1472: ,p_msg_code => 'UNEXPECTED_EXECUTE_IMPORT_UDA_FUNCTION'
1473: ,p_attr_grp_id => l_attr_row_obj.ATTR_GROUP_ID

Line 1554: PO_UDA_DEFAULTING_PKG.DEBUG('Before PO_UDA_IMPORT_PKG.UPDATE_STATUS to change to IN_PROGRESS from PENDING', d_progress);

1550: PO_UDA_DEFAULTING_PKG.DEBUG(x_external_attr_value_pairs, d_progress);
1551: PO_UDA_DEFAULTING_PKG.DEBUG('p_commit_flag : ' || p_commit_flag, d_progress);
1552: d_progress := 20;
1553:
1554: PO_UDA_DEFAULTING_PKG.DEBUG('Before PO_UDA_IMPORT_PKG.UPDATE_STATUS to change to IN_PROGRESS from PENDING', d_progress);
1555: PO_UDA_IMPORT_PKG.UPDATE_STATUS
1556: (
1557: p_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
1558: ,p_pre_process_status => PO_UDA_IMPORT_PKG.PENDING

Line 1555: PO_UDA_IMPORT_PKG.UPDATE_STATUS

1551: PO_UDA_DEFAULTING_PKG.DEBUG('p_commit_flag : ' || p_commit_flag, d_progress);
1552: d_progress := 20;
1553:
1554: PO_UDA_DEFAULTING_PKG.DEBUG('Before PO_UDA_IMPORT_PKG.UPDATE_STATUS to change to IN_PROGRESS from PENDING', d_progress);
1555: PO_UDA_IMPORT_PKG.UPDATE_STATUS
1556: (
1557: p_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
1558: ,p_pre_process_status => PO_UDA_IMPORT_PKG.PENDING
1559: ,p_process_phase => PO_UDA_IMPORT_PKG.PRE_DEFAULTING

Line 1557: p_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS

1553:
1554: PO_UDA_DEFAULTING_PKG.DEBUG('Before PO_UDA_IMPORT_PKG.UPDATE_STATUS to change to IN_PROGRESS from PENDING', d_progress);
1555: PO_UDA_IMPORT_PKG.UPDATE_STATUS
1556: (
1557: p_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
1558: ,p_pre_process_status => PO_UDA_IMPORT_PKG.PENDING
1559: ,p_process_phase => PO_UDA_IMPORT_PKG.PRE_DEFAULTING
1560: ,p_pk1_value => p_pk1_value
1561: ,p_pk2_value => p_pk2_value

Line 1558: ,p_pre_process_status => PO_UDA_IMPORT_PKG.PENDING

1554: PO_UDA_DEFAULTING_PKG.DEBUG('Before PO_UDA_IMPORT_PKG.UPDATE_STATUS to change to IN_PROGRESS from PENDING', d_progress);
1555: PO_UDA_IMPORT_PKG.UPDATE_STATUS
1556: (
1557: p_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
1558: ,p_pre_process_status => PO_UDA_IMPORT_PKG.PENDING
1559: ,p_process_phase => PO_UDA_IMPORT_PKG.PRE_DEFAULTING
1560: ,p_pk1_value => p_pk1_value
1561: ,p_pk2_value => p_pk2_value
1562: ,p_pk3_value => p_pk3_value

Line 1559: ,p_process_phase => PO_UDA_IMPORT_PKG.PRE_DEFAULTING

1555: PO_UDA_IMPORT_PKG.UPDATE_STATUS
1556: (
1557: p_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
1558: ,p_pre_process_status => PO_UDA_IMPORT_PKG.PENDING
1559: ,p_process_phase => PO_UDA_IMPORT_PKG.PRE_DEFAULTING
1560: ,p_pk1_value => p_pk1_value
1561: ,p_pk2_value => p_pk2_value
1562: ,p_pk3_value => p_pk3_value
1563: ,p_pk4_value => p_pk4_value

Line 1566: PO_UDA_DEFAULTING_PKG.DEBUG('After PO_UDA_IMPORT_PKG.UPDATE_STATUS to change to PENDING from IN_PROGRESS', d_progress);

1562: ,p_pk3_value => p_pk3_value
1563: ,p_pk4_value => p_pk4_value
1564: ,p_pk5_value => p_pk5_value
1565: );
1566: PO_UDA_DEFAULTING_PKG.DEBUG('After PO_UDA_IMPORT_PKG.UPDATE_STATUS to change to PENDING from IN_PROGRESS', d_progress);
1567:
1568: d_progress := 30;
1569: g_attr_grp_type := p_attr_grp_type;
1570: l_attributes_row_table := EGO_USER_ATTR_ROW_TABLE();

Line 1577: PO_UDA_IMPORT_PKG.POPULATE_STRUCTURES

1573: PO_UDA_DEFAULTING_PKG.DEBUG('Initialized teh objects l_attributes_row_table, l_attr_name_value_pairs', d_progress);
1574:
1575: d_progress := 50;
1576: PO_UDA_DEFAULTING_PKG.DEBUG('Before POPULATE_STRUCTURES ' || x_return_status, d_progress);
1577: PO_UDA_IMPORT_PKG.POPULATE_STRUCTURES
1578: (
1579: p_transaction_id => p_transaction_id
1580: ,p_attr_grp_type => p_attr_grp_type
1581: ,p_pk1_value => p_pk1_value

Line 1606: PO_UDA_IMPORT_PKG.POPULATE_REMAINING_ATTRIBUTES

1602: PO_UDA_DEFAULTING_PKG.DEBUG('Template ID is :: ' || l_class_code_name_value_pairs(l_class_code_name_value_pairs.FIRST).VALUE, d_progress);
1603: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1604: d_progress := 70;
1605: PO_UDA_DEFAULTING_PKG.DEBUG('Before POPULATE_REMAINING_ATTRIBUTES ' || x_return_status, d_progress);
1606: PO_UDA_IMPORT_PKG.POPULATE_REMAINING_ATTRIBUTES
1607: (
1608: x_attr_name_value_pairs => l_attr_name_value_pairs
1609: ,x_attributes_row_table => l_attributes_row_table
1610: ,x_return_status => x_return_status

Line 1622: PO_UDA_IMPORT_PKG.UPDATE_STATUS

1618: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_count ' || x_msg_count, d_progress);
1619: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_data ' || x_msg_data, d_progress);
1620: ELSE
1621: d_progress := 90;
1622: PO_UDA_IMPORT_PKG.UPDATE_STATUS
1623: (
1624: p_process_status => PO_UDA_IMPORT_PKG.UDA_ERROR
1625: ,p_pre_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
1626: ,p_process_phase => PO_UDA_IMPORT_PKG.PRE_DEFAULTING

Line 1624: p_process_status => PO_UDA_IMPORT_PKG.UDA_ERROR

1620: ELSE
1621: d_progress := 90;
1622: PO_UDA_IMPORT_PKG.UPDATE_STATUS
1623: (
1624: p_process_status => PO_UDA_IMPORT_PKG.UDA_ERROR
1625: ,p_pre_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
1626: ,p_process_phase => PO_UDA_IMPORT_PKG.PRE_DEFAULTING
1627: ,p_pk1_value => p_pk1_value
1628: ,p_pk2_value => p_pk2_value

Line 1625: ,p_pre_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS

1621: d_progress := 90;
1622: PO_UDA_IMPORT_PKG.UPDATE_STATUS
1623: (
1624: p_process_status => PO_UDA_IMPORT_PKG.UDA_ERROR
1625: ,p_pre_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
1626: ,p_process_phase => PO_UDA_IMPORT_PKG.PRE_DEFAULTING
1627: ,p_pk1_value => p_pk1_value
1628: ,p_pk2_value => p_pk2_value
1629: ,p_pk3_value => p_pk3_value

Line 1626: ,p_process_phase => PO_UDA_IMPORT_PKG.PRE_DEFAULTING

1622: PO_UDA_IMPORT_PKG.UPDATE_STATUS
1623: (
1624: p_process_status => PO_UDA_IMPORT_PKG.UDA_ERROR
1625: ,p_pre_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
1626: ,p_process_phase => PO_UDA_IMPORT_PKG.PRE_DEFAULTING
1627: ,p_pk1_value => p_pk1_value
1628: ,p_pk2_value => p_pk2_value
1629: ,p_pk3_value => p_pk3_value
1630: ,p_pk4_value => p_pk4_value

Line 1635: PO_UDA_IMPORT_PKG.HANDLE_ERROR

1631: ,p_pk5_value => p_pk5_value
1632: );
1633: d_progress := 100;
1634:
1635: PO_UDA_IMPORT_PKG.HANDLE_ERROR
1636: (
1637: p_msg => 'There was an error in POPULATE_STRUCTURES'
1638: ,p_msg_code => 'ERROR_POPULATE_STRUCTURES'
1639: ,p_attr_grp_id => NULL

Line 1647: PO_UDA_IMPORT_PKG.POPULATE_EMPTY_AGS

1643: d_progress := 120;
1644: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1645: d_progress := 130;
1646: PO_UDA_DEFAULTING_PKG.DEBUG('Before POPULATE_EMPTY_AGS ' || x_return_status, d_progress);
1647: PO_UDA_IMPORT_PKG.POPULATE_EMPTY_AGS
1648: (
1649: p_template_id => l_class_code_name_value_pairs(l_class_code_name_value_pairs.FIRST).VALUE
1650: ,p_pk_column_name_value_pairs => l_pk_column_name_value_pairs
1651: ,p_external_attr_value_pairs => x_external_attr_value_pairs

Line 1667: PO_UDA_IMPORT_PKG.UPDATE_STATUS

1663: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_count ' || x_msg_count, d_progress);
1664: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_data ' || x_msg_data, d_progress);
1665: ELSE
1666: d_progress := 150;
1667: PO_UDA_IMPORT_PKG.UPDATE_STATUS
1668: (
1669: p_process_status => PO_UDA_IMPORT_PKG.UDA_ERROR
1670: ,p_pre_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
1671: ,p_process_phase => PO_UDA_IMPORT_PKG.PRE_DEFAULTING

Line 1669: p_process_status => PO_UDA_IMPORT_PKG.UDA_ERROR

1665: ELSE
1666: d_progress := 150;
1667: PO_UDA_IMPORT_PKG.UPDATE_STATUS
1668: (
1669: p_process_status => PO_UDA_IMPORT_PKG.UDA_ERROR
1670: ,p_pre_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
1671: ,p_process_phase => PO_UDA_IMPORT_PKG.PRE_DEFAULTING
1672: ,p_pk1_value => p_pk1_value
1673: ,p_pk2_value => p_pk2_value

Line 1670: ,p_pre_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS

1666: d_progress := 150;
1667: PO_UDA_IMPORT_PKG.UPDATE_STATUS
1668: (
1669: p_process_status => PO_UDA_IMPORT_PKG.UDA_ERROR
1670: ,p_pre_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
1671: ,p_process_phase => PO_UDA_IMPORT_PKG.PRE_DEFAULTING
1672: ,p_pk1_value => p_pk1_value
1673: ,p_pk2_value => p_pk2_value
1674: ,p_pk3_value => p_pk3_value

Line 1671: ,p_process_phase => PO_UDA_IMPORT_PKG.PRE_DEFAULTING

1667: PO_UDA_IMPORT_PKG.UPDATE_STATUS
1668: (
1669: p_process_status => PO_UDA_IMPORT_PKG.UDA_ERROR
1670: ,p_pre_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
1671: ,p_process_phase => PO_UDA_IMPORT_PKG.PRE_DEFAULTING
1672: ,p_pk1_value => p_pk1_value
1673: ,p_pk2_value => p_pk2_value
1674: ,p_pk3_value => p_pk3_value
1675: ,p_pk4_value => p_pk4_value

Line 1679: PO_UDA_IMPORT_PKG.HANDLE_ERROR

1675: ,p_pk4_value => p_pk4_value
1676: ,p_pk5_value => p_pk5_value
1677: );
1678: d_progress := 160;
1679: PO_UDA_IMPORT_PKG.HANDLE_ERROR
1680: (
1681: p_msg => 'There was an error in POPULATE_REMAINING_ATTRIBUTES'
1682: ,p_msg_code => 'ERROR_POPULATE_REMAINING_ATTRIBUTES'
1683: ,p_attr_grp_id => NULL

Line 1690: PO_UDA_IMPORT_PKG.UPDATE_STATUS

1686: END IF;
1687:
1688: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1689: d_progress := 180;
1690: PO_UDA_IMPORT_PKG.UPDATE_STATUS
1691: (
1692: p_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
1693: ,p_pre_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
1694: ,p_process_phase => PO_UDA_IMPORT_PKG.DEFAULTING

Line 1692: p_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS

1688: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1689: d_progress := 180;
1690: PO_UDA_IMPORT_PKG.UPDATE_STATUS
1691: (
1692: p_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
1693: ,p_pre_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
1694: ,p_process_phase => PO_UDA_IMPORT_PKG.DEFAULTING
1695: ,p_pk1_value => p_pk1_value
1696: ,p_pk2_value => p_pk2_value

Line 1693: ,p_pre_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS

1689: d_progress := 180;
1690: PO_UDA_IMPORT_PKG.UPDATE_STATUS
1691: (
1692: p_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
1693: ,p_pre_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
1694: ,p_process_phase => PO_UDA_IMPORT_PKG.DEFAULTING
1695: ,p_pk1_value => p_pk1_value
1696: ,p_pk2_value => p_pk2_value
1697: ,p_pk3_value => p_pk3_value

Line 1694: ,p_process_phase => PO_UDA_IMPORT_PKG.DEFAULTING

1690: PO_UDA_IMPORT_PKG.UPDATE_STATUS
1691: (
1692: p_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
1693: ,p_pre_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
1694: ,p_process_phase => PO_UDA_IMPORT_PKG.DEFAULTING
1695: ,p_pk1_value => p_pk1_value
1696: ,p_pk2_value => p_pk2_value
1697: ,p_pk3_value => p_pk3_value
1698: ,p_pk4_value => p_pk4_value

Line 1704: PO_UDA_IMPORT_PKG.EXECUTE_IMPORT_UDA_FUNCTION

1700: );
1701: d_progress := 190;
1702:
1703: PO_UDA_DEFAULTING_PKG.DEBUG('Before EXECUTE_IMPORT_UDA_FUNCTION (XD) ' || x_return_status, d_progress);
1704: PO_UDA_IMPORT_PKG.EXECUTE_IMPORT_UDA_FUNCTION
1705: (
1706: p_template_id => l_class_code_name_value_pairs(l_class_code_name_value_pairs.FIRST).VALUE
1707: ,p_event => 'XD'
1708: ,x_external_attr_value_pairs => x_external_attr_value_pairs

Line 1724: PO_UDA_IMPORT_PKG.UPDATE_STATUS

1720: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_count ' || x_msg_count, d_progress);
1721: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_data ' || x_msg_data, d_progress);
1722: ELSE
1723: d_progress := 210;
1724: PO_UDA_IMPORT_PKG.UPDATE_STATUS
1725: (
1726: p_process_status => PO_UDA_IMPORT_PKG.UDA_ERROR
1727: ,p_pre_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
1728: ,p_process_phase => PO_UDA_IMPORT_PKG.PRE_DEFAULTING

Line 1726: p_process_status => PO_UDA_IMPORT_PKG.UDA_ERROR

1722: ELSE
1723: d_progress := 210;
1724: PO_UDA_IMPORT_PKG.UPDATE_STATUS
1725: (
1726: p_process_status => PO_UDA_IMPORT_PKG.UDA_ERROR
1727: ,p_pre_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
1728: ,p_process_phase => PO_UDA_IMPORT_PKG.PRE_DEFAULTING
1729: ,p_pk1_value => p_pk1_value
1730: ,p_pk2_value => p_pk2_value

Line 1727: ,p_pre_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS

1723: d_progress := 210;
1724: PO_UDA_IMPORT_PKG.UPDATE_STATUS
1725: (
1726: p_process_status => PO_UDA_IMPORT_PKG.UDA_ERROR
1727: ,p_pre_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
1728: ,p_process_phase => PO_UDA_IMPORT_PKG.PRE_DEFAULTING
1729: ,p_pk1_value => p_pk1_value
1730: ,p_pk2_value => p_pk2_value
1731: ,p_pk3_value => p_pk3_value

Line 1728: ,p_process_phase => PO_UDA_IMPORT_PKG.PRE_DEFAULTING

1724: PO_UDA_IMPORT_PKG.UPDATE_STATUS
1725: (
1726: p_process_status => PO_UDA_IMPORT_PKG.UDA_ERROR
1727: ,p_pre_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
1728: ,p_process_phase => PO_UDA_IMPORT_PKG.PRE_DEFAULTING
1729: ,p_pk1_value => p_pk1_value
1730: ,p_pk2_value => p_pk2_value
1731: ,p_pk3_value => p_pk3_value
1732: ,p_pk4_value => p_pk4_value

Line 1736: PO_UDA_IMPORT_PKG.HANDLE_ERROR

1732: ,p_pk4_value => p_pk4_value
1733: ,p_pk5_value => p_pk5_value
1734: );
1735: d_progress := 220;
1736: PO_UDA_IMPORT_PKG.HANDLE_ERROR
1737: (
1738: p_msg => 'There was an error in POPULATE_EMPTY_AGS'
1739: ,p_msg_code => 'ERROR_POPULATE_EMPTY_AGS'
1740: ,p_attr_grp_id => NULL

Line 1748: PO_UDA_IMPORT_PKG.EXECUTE_IMPORT_UDA_FUNCTION

1744:
1745: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1746: d_progress := 240;
1747: PO_UDA_DEFAULTING_PKG.DEBUG('Before EXECUTE_IMPORT_UDA_FUNCTION (XLE) ' || x_return_status, d_progress);
1748: PO_UDA_IMPORT_PKG.EXECUTE_IMPORT_UDA_FUNCTION
1749: (
1750: p_template_id => l_class_code_name_value_pairs(l_class_code_name_value_pairs.FIRST).VALUE
1751: ,p_event => 'XLE'
1752: ,x_external_attr_value_pairs => x_external_attr_value_pairs

Line 1768: PO_UDA_IMPORT_PKG.UPDATE_STATUS

1764: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_count ' || x_msg_count, d_progress);
1765: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_data ' || x_msg_data, d_progress);
1766: ELSE
1767: d_progress := 260;
1768: PO_UDA_IMPORT_PKG.UPDATE_STATUS
1769: (
1770: p_process_status => PO_UDA_IMPORT_PKG.UDA_ERROR
1771: ,p_pre_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
1772: ,p_process_phase => PO_UDA_IMPORT_PKG.DEFAULTING

Line 1770: p_process_status => PO_UDA_IMPORT_PKG.UDA_ERROR

1766: ELSE
1767: d_progress := 260;
1768: PO_UDA_IMPORT_PKG.UPDATE_STATUS
1769: (
1770: p_process_status => PO_UDA_IMPORT_PKG.UDA_ERROR
1771: ,p_pre_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
1772: ,p_process_phase => PO_UDA_IMPORT_PKG.DEFAULTING
1773: ,p_pk1_value => p_pk1_value
1774: ,p_pk2_value => p_pk2_value

Line 1771: ,p_pre_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS

1767: d_progress := 260;
1768: PO_UDA_IMPORT_PKG.UPDATE_STATUS
1769: (
1770: p_process_status => PO_UDA_IMPORT_PKG.UDA_ERROR
1771: ,p_pre_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
1772: ,p_process_phase => PO_UDA_IMPORT_PKG.DEFAULTING
1773: ,p_pk1_value => p_pk1_value
1774: ,p_pk2_value => p_pk2_value
1775: ,p_pk3_value => p_pk3_value

Line 1772: ,p_process_phase => PO_UDA_IMPORT_PKG.DEFAULTING

1768: PO_UDA_IMPORT_PKG.UPDATE_STATUS
1769: (
1770: p_process_status => PO_UDA_IMPORT_PKG.UDA_ERROR
1771: ,p_pre_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
1772: ,p_process_phase => PO_UDA_IMPORT_PKG.DEFAULTING
1773: ,p_pk1_value => p_pk1_value
1774: ,p_pk2_value => p_pk2_value
1775: ,p_pk3_value => p_pk3_value
1776: ,p_pk4_value => p_pk4_value

Line 1780: PO_UDA_IMPORT_PKG.HANDLE_ERROR

1776: ,p_pk4_value => p_pk4_value
1777: ,p_pk5_value => p_pk5_value
1778: );
1779: d_progress := 270;
1780: PO_UDA_IMPORT_PKG.HANDLE_ERROR
1781: (
1782: p_msg => 'There was an error in EXECUTE_IMPORT_UDA_FUNCTION (XD)'
1783: ,p_msg_code => 'ERROR_EXECUTE_IMPORT_UDA_FUNCTION_XD'
1784: ,p_attr_grp_id => NULL

Line 1794: PO_UDA_IMPORT_PKG.EXECUTE_IMPORT_UDA_FUNCTION

1790: -- Amount needs to be calculated in case of complex pricing
1791: -- Hence a call to XPC has been added
1792: IF p_attr_grp_type = 'PO_LINE_EXT_ATTRS'
1793: THEN
1794: PO_UDA_IMPORT_PKG.EXECUTE_IMPORT_UDA_FUNCTION
1795: (
1796: p_template_id => l_class_code_name_value_pairs(l_class_code_name_value_pairs.FIRST).VALUE
1797: ,p_event => 'XPC'
1798: ,x_external_attr_value_pairs => x_external_attr_value_pairs

Line 1818: PO_UDA_IMPORT_PKG.UPDATE_STATUS

1814: END IF;
1815:
1816: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1817: d_progress := 290;
1818: PO_UDA_IMPORT_PKG.UPDATE_STATUS
1819: (
1820: p_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
1821: ,p_pre_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
1822: ,p_process_phase => PO_UDA_IMPORT_PKG.EGO_VALIDATE

Line 1820: p_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS

1816: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1817: d_progress := 290;
1818: PO_UDA_IMPORT_PKG.UPDATE_STATUS
1819: (
1820: p_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
1821: ,p_pre_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
1822: ,p_process_phase => PO_UDA_IMPORT_PKG.EGO_VALIDATE
1823: ,p_pk1_value => p_pk1_value
1824: ,p_pk2_value => p_pk2_value

Line 1821: ,p_pre_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS

1817: d_progress := 290;
1818: PO_UDA_IMPORT_PKG.UPDATE_STATUS
1819: (
1820: p_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
1821: ,p_pre_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
1822: ,p_process_phase => PO_UDA_IMPORT_PKG.EGO_VALIDATE
1823: ,p_pk1_value => p_pk1_value
1824: ,p_pk2_value => p_pk2_value
1825: ,p_pk3_value => p_pk3_value

Line 1822: ,p_process_phase => PO_UDA_IMPORT_PKG.EGO_VALIDATE

1818: PO_UDA_IMPORT_PKG.UPDATE_STATUS
1819: (
1820: p_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
1821: ,p_pre_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
1822: ,p_process_phase => PO_UDA_IMPORT_PKG.EGO_VALIDATE
1823: ,p_pk1_value => p_pk1_value
1824: ,p_pk2_value => p_pk2_value
1825: ,p_pk3_value => p_pk3_value
1826: ,p_pk4_value => p_pk4_value

Line 1871: PO_UDA_IMPORT_PKG.UPDATE_STATUS

1867: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_data ' || x_msg_data, d_progress);
1868: d_progress := 330;
1869: ELSE
1870: d_progress := 340;
1871: PO_UDA_IMPORT_PKG.UPDATE_STATUS
1872: (
1873: p_process_status => PO_UDA_IMPORT_PKG.UDA_ERROR
1874: ,p_pre_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
1875: ,p_process_phase => PO_UDA_IMPORT_PKG.DEFAULTING

Line 1873: p_process_status => PO_UDA_IMPORT_PKG.UDA_ERROR

1869: ELSE
1870: d_progress := 340;
1871: PO_UDA_IMPORT_PKG.UPDATE_STATUS
1872: (
1873: p_process_status => PO_UDA_IMPORT_PKG.UDA_ERROR
1874: ,p_pre_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
1875: ,p_process_phase => PO_UDA_IMPORT_PKG.DEFAULTING
1876: ,p_pk1_value => p_pk1_value
1877: ,p_pk2_value => p_pk2_value

Line 1874: ,p_pre_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS

1870: d_progress := 340;
1871: PO_UDA_IMPORT_PKG.UPDATE_STATUS
1872: (
1873: p_process_status => PO_UDA_IMPORT_PKG.UDA_ERROR
1874: ,p_pre_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
1875: ,p_process_phase => PO_UDA_IMPORT_PKG.DEFAULTING
1876: ,p_pk1_value => p_pk1_value
1877: ,p_pk2_value => p_pk2_value
1878: ,p_pk3_value => p_pk3_value

Line 1875: ,p_process_phase => PO_UDA_IMPORT_PKG.DEFAULTING

1871: PO_UDA_IMPORT_PKG.UPDATE_STATUS
1872: (
1873: p_process_status => PO_UDA_IMPORT_PKG.UDA_ERROR
1874: ,p_pre_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
1875: ,p_process_phase => PO_UDA_IMPORT_PKG.DEFAULTING
1876: ,p_pk1_value => p_pk1_value
1877: ,p_pk2_value => p_pk2_value
1878: ,p_pk3_value => p_pk3_value
1879: ,p_pk4_value => p_pk4_value

Line 1883: PO_UDA_IMPORT_PKG.HANDLE_ERROR

1879: ,p_pk4_value => p_pk4_value
1880: ,p_pk5_value => p_pk5_value
1881: );
1882: d_progress := 350;
1883: PO_UDA_IMPORT_PKG.HANDLE_ERROR
1884: (
1885: p_msg => 'There was an error in EXECUTE_IMPORT_UDA_FUNCTION (XLE)'
1886: ,p_msg_code => 'ERROR_EXECUTE_IMPORT_UDA_FUNCTION_XLE'
1887: ,p_attr_grp_id => NULL

Line 1895: PO_UDA_IMPORT_PKG.UPDATE_STATUS

1891: d_progress := 370;
1892: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1893: d_progress := 380;
1894:
1895: PO_UDA_IMPORT_PKG.UPDATE_STATUS
1896: (
1897: p_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
1898: ,p_pre_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
1899: ,p_process_phase => PO_UDA_IMPORT_PKG.CUSTOM_VALIDATE

Line 1897: p_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS

1893: d_progress := 380;
1894:
1895: PO_UDA_IMPORT_PKG.UPDATE_STATUS
1896: (
1897: p_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
1898: ,p_pre_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
1899: ,p_process_phase => PO_UDA_IMPORT_PKG.CUSTOM_VALIDATE
1900: ,p_pk1_value => p_pk1_value
1901: ,p_pk2_value => p_pk2_value

Line 1898: ,p_pre_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS

1894:
1895: PO_UDA_IMPORT_PKG.UPDATE_STATUS
1896: (
1897: p_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
1898: ,p_pre_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
1899: ,p_process_phase => PO_UDA_IMPORT_PKG.CUSTOM_VALIDATE
1900: ,p_pk1_value => p_pk1_value
1901: ,p_pk2_value => p_pk2_value
1902: ,p_pk3_value => p_pk3_value

Line 1899: ,p_process_phase => PO_UDA_IMPORT_PKG.CUSTOM_VALIDATE

1895: PO_UDA_IMPORT_PKG.UPDATE_STATUS
1896: (
1897: p_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
1898: ,p_pre_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
1899: ,p_process_phase => PO_UDA_IMPORT_PKG.CUSTOM_VALIDATE
1900: ,p_pk1_value => p_pk1_value
1901: ,p_pk2_value => p_pk2_value
1902: ,p_pk3_value => p_pk3_value
1903: ,p_pk4_value => p_pk4_value

Line 1917: PO_UDA_IMPORT_PKG.EXECUTE_IMPORT_UDA_FUNCTION

1913:
1914: PO_UDA_DEFAULTING_PKG.DEBUG('Before EXECUTE_IMPORT_UDA_FUNCTION (XV) ' || x_return_status, d_progress);
1915: IF l_attributes_row_table.COUNT > 0 THEN
1916: d_progress := 420;
1917: PO_UDA_IMPORT_PKG.EXECUTE_IMPORT_UDA_FUNCTION
1918: (
1919: p_template_id => l_class_code_name_value_pairs(l_class_code_name_value_pairs.FIRST).VALUE
1920: ,p_event => 'XV'
1921: ,x_external_attr_value_pairs => x_external_attr_value_pairs

Line 1941: PO_UDA_IMPORT_PKG.UPDATE_STATUS

1937: d_progress := 440;
1938:
1939: ELSE
1940: d_progress := 450;
1941: PO_UDA_IMPORT_PKG.UPDATE_STATUS
1942: (
1943: p_process_status => PO_UDA_IMPORT_PKG.UDA_ERROR
1944: ,p_pre_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
1945: ,p_process_phase => PO_UDA_IMPORT_PKG.EGO_VALIDATE

Line 1943: p_process_status => PO_UDA_IMPORT_PKG.UDA_ERROR

1939: ELSE
1940: d_progress := 450;
1941: PO_UDA_IMPORT_PKG.UPDATE_STATUS
1942: (
1943: p_process_status => PO_UDA_IMPORT_PKG.UDA_ERROR
1944: ,p_pre_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
1945: ,p_process_phase => PO_UDA_IMPORT_PKG.EGO_VALIDATE
1946: ,p_pk1_value => p_pk1_value
1947: ,p_pk2_value => p_pk2_value

Line 1944: ,p_pre_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS

1940: d_progress := 450;
1941: PO_UDA_IMPORT_PKG.UPDATE_STATUS
1942: (
1943: p_process_status => PO_UDA_IMPORT_PKG.UDA_ERROR
1944: ,p_pre_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
1945: ,p_process_phase => PO_UDA_IMPORT_PKG.EGO_VALIDATE
1946: ,p_pk1_value => p_pk1_value
1947: ,p_pk2_value => p_pk2_value
1948: ,p_pk3_value => p_pk3_value

Line 1945: ,p_process_phase => PO_UDA_IMPORT_PKG.EGO_VALIDATE

1941: PO_UDA_IMPORT_PKG.UPDATE_STATUS
1942: (
1943: p_process_status => PO_UDA_IMPORT_PKG.UDA_ERROR
1944: ,p_pre_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
1945: ,p_process_phase => PO_UDA_IMPORT_PKG.EGO_VALIDATE
1946: ,p_pk1_value => p_pk1_value
1947: ,p_pk2_value => p_pk2_value
1948: ,p_pk3_value => p_pk3_value
1949: ,p_pk4_value => p_pk4_value

Line 1953: PO_UDA_IMPORT_PKG.HANDLE_ERROR

1949: ,p_pk4_value => p_pk4_value
1950: ,p_pk5_value => p_pk5_value
1951: );
1952: d_progress := 460;
1953: PO_UDA_IMPORT_PKG.HANDLE_ERROR
1954: (
1955: p_msg => 'There was an error in EGO Validate'
1956: ,p_msg_code => 'ERROR_EGO_VALIDATE_ERROR'
1957: ,p_attr_grp_id => NULL

Line 1965: PO_UDA_IMPORT_PKG.UPDATE_STATUS

1961:
1962: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1963: d_progress := 480;
1964:
1965: PO_UDA_IMPORT_PKG.UPDATE_STATUS
1966: (
1967: p_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
1968: ,p_pre_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
1969: ,p_process_phase => PO_UDA_IMPORT_PKG.LOAD

Line 1967: p_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS

1963: d_progress := 480;
1964:
1965: PO_UDA_IMPORT_PKG.UPDATE_STATUS
1966: (
1967: p_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
1968: ,p_pre_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
1969: ,p_process_phase => PO_UDA_IMPORT_PKG.LOAD
1970: ,p_pk1_value => p_pk1_value
1971: ,p_pk2_value => p_pk2_value

Line 1968: ,p_pre_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS

1964:
1965: PO_UDA_IMPORT_PKG.UPDATE_STATUS
1966: (
1967: p_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
1968: ,p_pre_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
1969: ,p_process_phase => PO_UDA_IMPORT_PKG.LOAD
1970: ,p_pk1_value => p_pk1_value
1971: ,p_pk2_value => p_pk2_value
1972: ,p_pk3_value => p_pk3_value

Line 1969: ,p_process_phase => PO_UDA_IMPORT_PKG.LOAD

1965: PO_UDA_IMPORT_PKG.UPDATE_STATUS
1966: (
1967: p_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
1968: ,p_pre_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
1969: ,p_process_phase => PO_UDA_IMPORT_PKG.LOAD
1970: ,p_pk1_value => p_pk1_value
1971: ,p_pk2_value => p_pk2_value
1972: ,p_pk3_value => p_pk3_value
1973: ,p_pk4_value => p_pk4_value

Line 2017: PO_UDA_IMPORT_PKG.UPDATE_STATUS

2013: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_data ' || x_msg_data, d_progress);
2014: d_progress := 520;
2015: ELSE
2016: d_progress := 530;
2017: PO_UDA_IMPORT_PKG.UPDATE_STATUS
2018: (
2019: p_process_status => PO_UDA_IMPORT_PKG.UDA_ERROR
2020: ,p_pre_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
2021: ,p_process_phase => PO_UDA_IMPORT_PKG.CUSTOM_VALIDATE

Line 2019: p_process_status => PO_UDA_IMPORT_PKG.UDA_ERROR

2015: ELSE
2016: d_progress := 530;
2017: PO_UDA_IMPORT_PKG.UPDATE_STATUS
2018: (
2019: p_process_status => PO_UDA_IMPORT_PKG.UDA_ERROR
2020: ,p_pre_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
2021: ,p_process_phase => PO_UDA_IMPORT_PKG.CUSTOM_VALIDATE
2022: ,p_pk1_value => p_pk1_value
2023: ,p_pk2_value => p_pk2_value

Line 2020: ,p_pre_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS

2016: d_progress := 530;
2017: PO_UDA_IMPORT_PKG.UPDATE_STATUS
2018: (
2019: p_process_status => PO_UDA_IMPORT_PKG.UDA_ERROR
2020: ,p_pre_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
2021: ,p_process_phase => PO_UDA_IMPORT_PKG.CUSTOM_VALIDATE
2022: ,p_pk1_value => p_pk1_value
2023: ,p_pk2_value => p_pk2_value
2024: ,p_pk3_value => p_pk3_value

Line 2021: ,p_process_phase => PO_UDA_IMPORT_PKG.CUSTOM_VALIDATE

2017: PO_UDA_IMPORT_PKG.UPDATE_STATUS
2018: (
2019: p_process_status => PO_UDA_IMPORT_PKG.UDA_ERROR
2020: ,p_pre_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
2021: ,p_process_phase => PO_UDA_IMPORT_PKG.CUSTOM_VALIDATE
2022: ,p_pk1_value => p_pk1_value
2023: ,p_pk2_value => p_pk2_value
2024: ,p_pk3_value => p_pk3_value
2025: ,p_pk4_value => p_pk4_value

Line 2029: PO_UDA_IMPORT_PKG.HANDLE_ERROR

2025: ,p_pk4_value => p_pk4_value
2026: ,p_pk5_value => p_pk5_value
2027: );
2028: d_progress := 540;
2029: PO_UDA_IMPORT_PKG.HANDLE_ERROR
2030: (
2031: p_msg => 'There was an error in EXECUTE_IMPORT_UDA_FUNCTION (XV)'
2032: ,p_msg_code => 'ERROR_EXECUTE_IMPORT_UDA_FUNCTION_XLE'
2033: ,p_attr_grp_id => NULL

Line 2043: PO_UDA_IMPORT_PKG.EXECUTE_IMPORT_UDA_FUNCTION

2039: d_progress := 560;
2040: PO_UDA_DEFAULTING_PKG.DEBUG('Before EXECUTE_IMPORT_UDA_FUNCTION (XPD) ' || x_return_status, d_progress);
2041: IF l_attributes_row_table.COUNT > 0 THEN
2042: d_progress := 570;
2043: PO_UDA_IMPORT_PKG.EXECUTE_IMPORT_UDA_FUNCTION
2044: (
2045: p_template_id => l_class_code_name_value_pairs(l_class_code_name_value_pairs.FIRST).VALUE
2046: ,p_event => 'XPD'
2047: ,x_external_attr_value_pairs => x_external_attr_value_pairs

Line 2066: PO_UDA_IMPORT_PKG.UPDATE_STATUS

2062: PO_UDA_DEFAULTING_PKG.DEBUG('x_msg_data ' || x_msg_data, d_progress);
2063: d_progress := 590;
2064: ELSE
2065: d_progress := 600;
2066: PO_UDA_IMPORT_PKG.UPDATE_STATUS
2067: (
2068: p_process_status => PO_UDA_IMPORT_PKG.UDA_ERROR
2069: ,p_pre_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
2070: ,p_process_phase => PO_UDA_IMPORT_PKG.LOAD

Line 2068: p_process_status => PO_UDA_IMPORT_PKG.UDA_ERROR

2064: ELSE
2065: d_progress := 600;
2066: PO_UDA_IMPORT_PKG.UPDATE_STATUS
2067: (
2068: p_process_status => PO_UDA_IMPORT_PKG.UDA_ERROR
2069: ,p_pre_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
2070: ,p_process_phase => PO_UDA_IMPORT_PKG.LOAD
2071: ,p_pk1_value => p_pk1_value
2072: ,p_pk2_value => p_pk2_value

Line 2069: ,p_pre_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS

2065: d_progress := 600;
2066: PO_UDA_IMPORT_PKG.UPDATE_STATUS
2067: (
2068: p_process_status => PO_UDA_IMPORT_PKG.UDA_ERROR
2069: ,p_pre_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
2070: ,p_process_phase => PO_UDA_IMPORT_PKG.LOAD
2071: ,p_pk1_value => p_pk1_value
2072: ,p_pk2_value => p_pk2_value
2073: ,p_pk3_value => p_pk3_value

Line 2070: ,p_process_phase => PO_UDA_IMPORT_PKG.LOAD

2066: PO_UDA_IMPORT_PKG.UPDATE_STATUS
2067: (
2068: p_process_status => PO_UDA_IMPORT_PKG.UDA_ERROR
2069: ,p_pre_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
2070: ,p_process_phase => PO_UDA_IMPORT_PKG.LOAD
2071: ,p_pk1_value => p_pk1_value
2072: ,p_pk2_value => p_pk2_value
2073: ,p_pk3_value => p_pk3_value
2074: ,p_pk4_value => p_pk4_value

Line 2078: PO_UDA_IMPORT_PKG.HANDLE_ERROR

2074: ,p_pk4_value => p_pk4_value
2075: ,p_pk5_value => p_pk5_value
2076: );
2077: d_progress := 610;
2078: PO_UDA_IMPORT_PKG.HANDLE_ERROR
2079: (
2080: p_msg => 'There was an error in loading UDA Attributes'
2081: ,p_msg_code => 'ERROR_EGO_LOAD_ERROR'
2082: ,p_attr_grp_id => NULL

Line 2089: PO_UDA_IMPORT_PKG.UPDATE_STATUS

2085: END IF;
2086: d_progress := 630;
2087: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2088: d_progress := 640;
2089: PO_UDA_IMPORT_PKG.UPDATE_STATUS
2090: (
2091: p_process_status => PO_UDA_IMPORT_PKG.COMPLETED
2092: ,p_pre_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
2093: ,p_process_phase => PO_UDA_IMPORT_PKG.LOAD

Line 2091: p_process_status => PO_UDA_IMPORT_PKG.COMPLETED

2087: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2088: d_progress := 640;
2089: PO_UDA_IMPORT_PKG.UPDATE_STATUS
2090: (
2091: p_process_status => PO_UDA_IMPORT_PKG.COMPLETED
2092: ,p_pre_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
2093: ,p_process_phase => PO_UDA_IMPORT_PKG.LOAD
2094: ,p_pk1_value => p_pk1_value
2095: ,p_pk2_value => p_pk2_value

Line 2092: ,p_pre_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS

2088: d_progress := 640;
2089: PO_UDA_IMPORT_PKG.UPDATE_STATUS
2090: (
2091: p_process_status => PO_UDA_IMPORT_PKG.COMPLETED
2092: ,p_pre_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
2093: ,p_process_phase => PO_UDA_IMPORT_PKG.LOAD
2094: ,p_pk1_value => p_pk1_value
2095: ,p_pk2_value => p_pk2_value
2096: ,p_pk3_value => p_pk3_value

Line 2093: ,p_process_phase => PO_UDA_IMPORT_PKG.LOAD

2089: PO_UDA_IMPORT_PKG.UPDATE_STATUS
2090: (
2091: p_process_status => PO_UDA_IMPORT_PKG.COMPLETED
2092: ,p_pre_process_status => PO_UDA_IMPORT_PKG.IN_PROGRESS
2093: ,p_process_phase => PO_UDA_IMPORT_PKG.LOAD
2094: ,p_pk1_value => p_pk1_value
2095: ,p_pk2_value => p_pk2_value
2096: ,p_pk3_value => p_pk3_value
2097: ,p_pk4_value => p_pk4_value

Line 2115: PO_UDA_IMPORT_PKG.HANDLE_ERROR

2111: EXCEPTION
2112: WHEN OTHERS THEN
2113: l_err_txt := 'Exception in IMPORT_UDA_ATTRS with ERROR : ' || SQLERRM;
2114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2115: PO_UDA_IMPORT_PKG.HANDLE_ERROR
2116: (
2117: p_msg => l_err_txt
2118: ,p_msg_code => 'UNEX_EXEC_IMPRT_UDA_FUNC'
2119: ,p_attr_grp_id => NULL

Line 2164: IF p_process_status IN (PO_UDA_IMPORT_PKG.PENDING, PO_UDA_IMPORT_PKG.IN_PROGRESS, PO_UDA_IMPORT_PKG.COMPLETED) THEN

2160: ,p_pk5_value IN NUMBER
2161: )
2162: IS
2163: BEGIN
2164: IF p_process_status IN (PO_UDA_IMPORT_PKG.PENDING, PO_UDA_IMPORT_PKG.IN_PROGRESS, PO_UDA_IMPORT_PKG.COMPLETED) THEN
2165: UPDATE PO_UDA_INTERFACE
2166: SET PROCESS_STATUS = p_process_status
2167: ,PROCESS_PHASE = p_process_phase
2168: WHERE NVL(PK1_VALUE, -999) = NVL(p_pk1_value, -999)

Line 2208: d_pkg_name CONSTANT VARCHAR2(30) := PO_LOG.get_package_base('PO_UDA_IMPORT_PKG');

2204: p_transaction_id IN NUMBER)
2205: IS
2206:
2207: d_api_name VARCHAR2(50) := 'TRANSFER_UDA_DATA';
2208: d_pkg_name CONSTANT VARCHAR2(30) := PO_LOG.get_package_base('PO_UDA_IMPORT_PKG');
2209: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
2210: l_uda_pk1_tbl po_tbl_number ;
2211: l_uda_pk2_tbl po_tbl_number ;
2212: l_attr_group_type_tbl po_tbl_varchar40 ;

Line 3358: d_pkg_name CONSTANT VARCHAR2(30) := PO_LOG.get_package_base('PO_UDA_IMPORT_PKG');

3354: l_attr_grp_name_tbl po_tbl_varchar100;
3355: l_attr_group_typ_tbl po_tbl_varchar30;
3356: l_pk1_value_tbl po_tbl_number;
3357: d_api_name CONSTANT VARCHAR2(30) := 'validate_uda_req_attributes';
3358: d_pkg_name CONSTANT VARCHAR2(30) := PO_LOG.get_package_base('PO_UDA_IMPORT_PKG');
3359: d_module CONSTANT VARCHAR2(100) := d_pkg_name || d_api_name || '.';
3360: d_position NUMBER;
3361:
3362: BEGIN

Line 3437: END PO_UDA_IMPORT_PKG;

3433:
3434: RETURN l_is_valid;
3435: END validate_uda_req_attributes;
3436:
3437: END PO_UDA_IMPORT_PKG;