DBA Data[Home] [Help]

APPS.EGO_IMPORT_UTIL_PVT dependencies on INVPULI2

Line 499: l_template_table INVPULI2.Import_Template_Tbl_Type;

495: )
496: IS
497: l_err_msg VARCHAR2(4000);
498: l_return_status VARCHAR2(10);
499: l_template_table INVPULI2.Import_Template_Tbl_Type;
500: l_apply_multiple_template BOOLEAN;
501: l_entity_sql VARCHAR2(32000);
502: l_sql_part1 VARCHAR2(1000);
503: l_sql_part2 VARCHAR2(32000);

Line 1576: l_template_table INVPULI2.Import_Template_Tbl_Type;

1572: RETURN INTEGER
1573: IS
1574: l_err_msg VARCHAR2(4000);
1575: l_return_status INTEGER;
1576: l_template_table INVPULI2.Import_Template_Tbl_Type;
1577: l_apply_multiple_template BOOLEAN;
1578: BEGIN
1579: Debug_Conc_Log('Apply_Templates_For_Items: Starting p_batch_id='||p_batch_id);
1580: SELECT TEMPLATE_ID

Line 1595: Debug_Conc_Log('Apply_Templates_For_Items: Calling INVPULI2.apply_multiple_template');

1591: END IF;
1592:
1593: IF l_apply_multiple_template THEN
1594: Debug_Conc_Log('Apply_Templates_For_Items: APPLY_TEMPLATE option found in Copy options, so applying multiple templates');
1595: Debug_Conc_Log('Apply_Templates_For_Items: Calling INVPULI2.apply_multiple_template');
1596: l_return_status := INVPULI2.apply_multiple_template
1597: (
1598: p_template_tbl => l_template_table
1599: ,p_org_id => NULL

Line 1596: l_return_status := INVPULI2.apply_multiple_template

1592:
1593: IF l_apply_multiple_template THEN
1594: Debug_Conc_Log('Apply_Templates_For_Items: APPLY_TEMPLATE option found in Copy options, so applying multiple templates');
1595: Debug_Conc_Log('Apply_Templates_For_Items: Calling INVPULI2.apply_multiple_template');
1596: l_return_status := INVPULI2.apply_multiple_template
1597: (
1598: p_template_tbl => l_template_table
1599: ,p_org_id => NULL
1600: ,p_all_org => 1

Line 1610: Debug_Conc_Log('Apply_Templates_For_Items: Done INVPULI2.apply_multiple_template with l_return_status, l_err_msg='||l_return_status||','||l_err_msg);

1606: ,p_xset_id => p_batch_id
1607: ,x_err_text => l_err_msg
1608: );
1609:
1610: Debug_Conc_Log('Apply_Templates_For_Items: Done INVPULI2.apply_multiple_template with l_return_status, l_err_msg='||l_return_status||','||l_err_msg);
1611: IF l_return_status <> 0 THEN
1612: x_err_msg := l_err_msg;
1613: RETURN l_return_status;
1614: END IF;

Line 1620: Debug_Conc_Log('Apply_Templates_For_Items: Calling INVPULI2.copy_template_attributes');

1616: -- applying templates present in the MSII table
1617: -- template_id/name is taken from the template_id/name
1618: -- column of MSII table
1619: Debug_Conc_Log('Apply_Templates_For_Items: APPLY_TEMPLATE option NOT found in Copy options, so applying templates present in MSII');
1620: Debug_Conc_Log('Apply_Templates_For_Items: Calling INVPULI2.copy_template_attributes');
1621: l_return_status := INVPULI2.copy_template_attributes
1622: (
1623: org_id => NULL
1624: ,all_org => 1

Line 1621: l_return_status := INVPULI2.copy_template_attributes

1617: -- template_id/name is taken from the template_id/name
1618: -- column of MSII table
1619: Debug_Conc_Log('Apply_Templates_For_Items: APPLY_TEMPLATE option NOT found in Copy options, so applying templates present in MSII');
1620: Debug_Conc_Log('Apply_Templates_For_Items: Calling INVPULI2.copy_template_attributes');
1621: l_return_status := INVPULI2.copy_template_attributes
1622: (
1623: org_id => NULL
1624: ,all_org => 1
1625: ,prog_appid => p_prog_appid

Line 1634: Debug_Conc_Log('Apply_Templates_For_Items: Done INVPULI2.copy_template_attributes with l_return_status, l_err_msg='||l_return_status||','||l_err_msg);

1630: ,xset_id => p_batch_id
1631: ,err_text => l_err_msg
1632: );
1633:
1634: Debug_Conc_Log('Apply_Templates_For_Items: Done INVPULI2.copy_template_attributes with l_return_status, l_err_msg='||l_return_status||','||l_err_msg);
1635: IF l_return_status <> 0 THEN
1636: x_err_msg := l_err_msg;
1637: RETURN l_return_status;
1638: END IF;

Line 1843: Debug_Conc_Log('Process_Copy_Options_For_Items: Calling INVPULI2.copy_template_attributes');

1839: IF NVL(p_copy_options_exist, 'N') = 'N' THEN
1840: -- applying templates
1841: -- template_id/name is taken from the template_id/name
1842: -- column of MSII table
1843: Debug_Conc_Log('Process_Copy_Options_For_Items: Calling INVPULI2.copy_template_attributes');
1844: l_return_status := INVPULI2.copy_template_attributes
1845: (
1846: org_id => NULL
1847: ,all_org => 1

Line 1844: l_return_status := INVPULI2.copy_template_attributes

1840: -- applying templates
1841: -- template_id/name is taken from the template_id/name
1842: -- column of MSII table
1843: Debug_Conc_Log('Process_Copy_Options_For_Items: Calling INVPULI2.copy_template_attributes');
1844: l_return_status := INVPULI2.copy_template_attributes
1845: (
1846: org_id => NULL
1847: ,all_org => 1
1848: ,prog_appid => l_prog_appid

Line 1857: Debug_Conc_Log('Process_Copy_Options_For_Items: Done INVPULI2.copy_template_attributes with l_return_status, l_err_msg='||l_return_status||','||l_err_msg);

1853: ,xset_id => p_batch_id
1854: ,err_text => l_err_msg
1855: );
1856:
1857: Debug_Conc_Log('Process_Copy_Options_For_Items: Done INVPULI2.copy_template_attributes with l_return_status, l_err_msg='||l_return_status||','||l_err_msg);
1858: IF l_return_status <> 0 THEN
1859: RETCODE := '2';
1860: ERRBUF := 'Error Code='||l_return_status||', Msg='||l_err_msg;
1861: RETURN;