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.CTO_DEACTIVATE_CONFIG_PK dependencies on BOM_PARAMETERS

Line 336: l_del_status BOM_PARAMETERS.bom_delete_status_code%type;

332: l_prev_item_id NUMBER;
333: l_prev_org_id NUMBER;
334: l_prev_item_name MTL_SYSTEM_ITEMS_KFV.concatenated_segments%type;
335: l_index NUMBER;
336: l_del_status BOM_PARAMETERS.bom_delete_status_code%type;
337: l_selected_inv_item_id MTL_SYSTEM_ITEMS_KFV.inventory_item_id%type;
338:
339: --bugfix#2162892
340: l_selected_inv_item_name MTL_SYSTEM_ITEMS_KFV.concatenated_segments%type;

Line 464: fnd_file.put_line(fnd_file.log, 'Action: 1. Set the BOM parameters for the organization.');

460: -- If it returns FALSE, then, you have not setup your parameters correctly.
461: --
462:
463: if l_return_status = FND_API.G_FALSE then
464: fnd_file.put_line(fnd_file.log, 'Action: 1. Set the BOM parameters for the organization.');
465: fnd_file.put_line(fnd_file.log, ' 2. Set the Inactive Status code in the BOM parameters.');
466: errbuf := 'completed with warning';
467: retcode := 1; --exits with warning
468: return;

Line 465: fnd_file.put_line(fnd_file.log, ' 2. Set the Inactive Status code in the BOM parameters.');

461: --
462:
463: if l_return_status = FND_API.G_FALSE then
464: fnd_file.put_line(fnd_file.log, 'Action: 1. Set the BOM parameters for the organization.');
465: fnd_file.put_line(fnd_file.log, ' 2. Set the Inactive Status code in the BOM parameters.');
466: errbuf := 'completed with warning';
467: retcode := 1; --exits with warning
468: return;
469: end if;

Line 1662: p_status_code : bom_delete_status_code from bom_parameters for given org

1658: argumnents:
1659:
1660: p_table : items meeting criteria for deactivation
1661: p_org_id : organization where deactivation is run
1662: p_status_code : bom_delete_status_code from bom_parameters for given org
1663: p_user_id : default value
1664:
1665: ***************************************************************************/
1666: PROCEDURE DEACTIVATE_ITEMS(

Line 1923: p_delete_status_cod : bom_parameters.bom_delete_status_code

1919: arguments:
1920: input:
1921: p_inventory_item_id : config item being checked for deactivation
1922: p_org_id : given org id
1923: p_delete_status_cod : bom_parameters.bom_delete_status_code
1924: x_return_status : return variable
1925: ************************************************************************/
1926:
1927: PROCEDURE CHECK_DELETE_STATUS(

Line 1935: l_status_code bom_parameters.bom_delete_status_code%type;

1931: x_return_status OUT NOCOPY VARCHAR2
1932: )
1933: IS
1934:
1935: l_status_code bom_parameters.bom_delete_status_code%type;
1936: l_org_id number; --Bugfix 7011607
1937:
1938: BEGIN
1939:

Line 2141: p_delete_status_code : bom_parameters.bom_delete_status_code for given org_id

2137:
2138: arguments
2139: p_inventory_item_id : config_item_id
2140: p_org_id : given org_id
2141: p_delete_status_code : bom_parameters.bom_delete_status_code for given org_id
2142: ******************************************************************************/
2143:
2144: PROCEDURE CHECK_COMMON_ROUTING(
2145: p_inventory_item_id IN NUMBER,

Line 2235: p_delete_status_code : bom_parameters.bom_delete_status_code for given org_id

2231:
2232: arguments
2233: p_inventory_item_id : config_item_id
2234: p_org_id : given org_id
2235: p_delete_status_code : bom_parameters.bom_delete_status_code for given org_id
2236: ****************************************************************************************/
2237: PROCEDURE CHECK_COMMON_BOM(
2238: p_inventory_item_id IN NUMBER,
2239: p_org_id IN NUMBER,

Line 2285: FROM bom_parameters

2281:
2282: IF l_com_org_id <> p_org_id THEN
2283: BEGIN
2284: SELECT bom_delete_status_code INTO l_del_status
2285: FROM bom_parameters
2286: WHERE organization_id = l_com_org_id;
2287: EXCEPTION
2288: WHEN no_data_found THEN
2289: WriteToLog('Org where BOM is commoned doesnot have bom_del_status', 3);

Line 2719: l_del_status bom_parameters.bom_delete_status_code%type;

2715: x_return_status OUT NOCOPY VARCHAR2
2716: )
2717: IS
2718:
2719: l_del_status bom_parameters.bom_delete_status_code%type;
2720: l_return_status VARCHAR2(1);
2721:
2722: cursor parent_ato is
2723: select assembly_item_id

Line 2742: FROM bom_parameters

2738: x_return_status := FND_API.G_FALSE;
2739:
2740: SELECT bom_delete_status_code
2741: INTO l_del_status
2742: FROM bom_parameters
2743: WHERE organization_id = p_org_id;
2744:
2745: WriteToLog('BOM delete status code: '||l_del_status, 5 );
2746:

Line 2797: l_del_status bom_parameters.bom_delete_status_code%type;

2793:
2794: )
2795: IS
2796:
2797: l_del_status bom_parameters.bom_delete_status_code%type;
2798:
2799: BEGIN
2800: x_return_status := FND_API.G_FALSE;--default return value ,bom_delete_status_code is not set
2801:

Line 2807: FROM bom_parameters

2803:
2804: BEGIN
2805: SELECT bom_delete_status_code
2806: INTO l_del_status
2807: FROM bom_parameters
2808: WHERE organization_id = p_org_id;
2809: EXCEPTION
2810: WHEN no_data_found THEN
2811: WriteToLog('BOM Parameters is not set for organization '||p_org_id);

Line 2811: WriteToLog('BOM Parameters is not set for organization '||p_org_id);

2807: FROM bom_parameters
2808: WHERE organization_id = p_org_id;
2809: EXCEPTION
2810: WHEN no_data_found THEN
2811: WriteToLog('BOM Parameters is not set for organization '||p_org_id);
2812: RETURN;
2813: END;
2814:
2815:

Line 2821: WriteToLog('Inactive Status Code is not populated in bom_parameters');

2817: -- if there is a row present but no bom_delete_status for given org
2818: --
2819:
2820: IF l_del_status IS NULL THEN
2821: WriteToLog('Inactive Status Code is not populated in bom_parameters');
2822: RETURN;
2823: END IF;
2824:
2825: p_delete_status_code := l_del_status;