DBA Data[Home] [Help]

APPS.EGO_IMPORT_UTIL_PVT dependencies on INVPULI2

Line 449: l_template_table INVPULI2.Import_Template_Tbl_Type;

445: )
446: IS
447: l_err_msg VARCHAR2(4000);
448: l_return_status VARCHAR2(10);
449: l_template_table INVPULI2.Import_Template_Tbl_Type;
450: l_apply_multiple_template BOOLEAN;
451: l_entity_sql VARCHAR2(32000);
452: l_sql_part1 VARCHAR2(1000);
453: l_sql_part2 VARCHAR2(32000);

Line 1406: l_template_table INVPULI2.Import_Template_Tbl_Type;

1402: RETURN INTEGER
1403: IS
1404: l_err_msg VARCHAR2(4000);
1405: l_return_status INTEGER;
1406: l_template_table INVPULI2.Import_Template_Tbl_Type;
1407: l_apply_multiple_template BOOLEAN;
1408: BEGIN
1409: Debug_Conc_Log('Apply_Templates_For_Items: Starting p_batch_id='||p_batch_id);
1410: SELECT TEMPLATE_ID

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

1421: END IF;
1422:
1423: IF l_apply_multiple_template THEN
1424: Debug_Conc_Log('Apply_Templates_For_Items: APPLY_TEMPLATE option found in Copy options, so applying multiple templates');
1425: Debug_Conc_Log('Apply_Templates_For_Items: Calling INVPULI2.apply_multiple_template');
1426: l_return_status := INVPULI2.apply_multiple_template
1427: (
1428: p_template_tbl => l_template_table
1429: ,p_org_id => NULL

Line 1426: l_return_status := INVPULI2.apply_multiple_template

1422:
1423: IF l_apply_multiple_template THEN
1424: Debug_Conc_Log('Apply_Templates_For_Items: APPLY_TEMPLATE option found in Copy options, so applying multiple templates');
1425: Debug_Conc_Log('Apply_Templates_For_Items: Calling INVPULI2.apply_multiple_template');
1426: l_return_status := INVPULI2.apply_multiple_template
1427: (
1428: p_template_tbl => l_template_table
1429: ,p_org_id => NULL
1430: ,p_all_org => 1

Line 1440: 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);

1436: ,p_xset_id => p_batch_id
1437: ,x_err_text => l_err_msg
1438: );
1439:
1440: 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);
1441: IF l_return_status <> 0 THEN
1442: x_err_msg := l_err_msg;
1443: RETURN l_return_status;
1444: END IF;

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

1446: -- applying templates present in the MSII table
1447: -- template_id/name is taken from the template_id/name
1448: -- column of MSII table
1449: Debug_Conc_Log('Apply_Templates_For_Items: APPLY_TEMPLATE option NOT found in Copy options, so applying templates present in MSII');
1450: Debug_Conc_Log('Apply_Templates_For_Items: Calling INVPULI2.copy_template_attributes');
1451: l_return_status := INVPULI2.copy_template_attributes
1452: (
1453: org_id => NULL
1454: ,all_org => 1

Line 1451: l_return_status := INVPULI2.copy_template_attributes

1447: -- template_id/name is taken from the template_id/name
1448: -- column of MSII table
1449: Debug_Conc_Log('Apply_Templates_For_Items: APPLY_TEMPLATE option NOT found in Copy options, so applying templates present in MSII');
1450: Debug_Conc_Log('Apply_Templates_For_Items: Calling INVPULI2.copy_template_attributes');
1451: l_return_status := INVPULI2.copy_template_attributes
1452: (
1453: org_id => NULL
1454: ,all_org => 1
1455: ,prog_appid => p_prog_appid

Line 1464: 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);

1460: ,xset_id => p_batch_id
1461: ,err_text => l_err_msg
1462: );
1463:
1464: 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);
1465: IF l_return_status <> 0 THEN
1466: x_err_msg := l_err_msg;
1467: RETURN l_return_status;
1468: END IF;

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

1669: IF NVL(p_copy_options_exist, 'N') = 'N' THEN
1670: -- applying templates
1671: -- template_id/name is taken from the template_id/name
1672: -- column of MSII table
1673: Debug_Conc_Log('Process_Copy_Options_For_Items: Calling INVPULI2.copy_template_attributes');
1674: l_return_status := INVPULI2.copy_template_attributes
1675: (
1676: org_id => NULL
1677: ,all_org => 1

Line 1674: l_return_status := INVPULI2.copy_template_attributes

1670: -- applying templates
1671: -- template_id/name is taken from the template_id/name
1672: -- column of MSII table
1673: Debug_Conc_Log('Process_Copy_Options_For_Items: Calling INVPULI2.copy_template_attributes');
1674: l_return_status := INVPULI2.copy_template_attributes
1675: (
1676: org_id => NULL
1677: ,all_org => 1
1678: ,prog_appid => l_prog_appid

Line 1687: 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);

1683: ,xset_id => p_batch_id
1684: ,err_text => l_err_msg
1685: );
1686:
1687: 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);
1688: IF l_return_status <> 0 THEN
1689: RETCODE := '2';
1690: ERRBUF := 'Error Code='||l_return_status||', Msg='||l_err_msg;
1691: RETURN;