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.BOM_IMPORT_PUB dependencies on BOM_GLOBALS

Line 67: Bom_Globals.Set_Debug ('Y');

63: END IF;
64: END IF;
65: Error_Handler.Initialize;
66: Error_Handler.Set_Debug ('Y');
67: Bom_Globals.Set_Debug ('Y');
68:
69: Error_Handler.Open_Debug_Session
70: ( p_debug_filename => l_debug_file
71: , p_output_dir => l_out_dir

Line 400: AND pg_batch_options.structure_name <> bom_globals.get_primary_ui)

396: IS
397: BEGIN
398: --Update Structure Name:Start
399: IF (pg_batch_options.structure_name IS NOT NULL
400: AND pg_batch_options.structure_name <> bom_globals.get_primary_ui)
401: THEN
402: UPDATE bom_bill_of_mtls_interface
403: SET alternate_bom_designator = pg_batch_options.structure_name
404: WHERE batch_id = p_batch_id

Line 1782: Bom_Globals.Set_Debug(l_debug_flag);

1778: , p_Token_Tbl => l_token_tbl
1779: );
1780: l_debug_flag := 'N';
1781: END IF;
1782: Bom_Globals.Set_Debug(l_debug_flag);
1783:
1784: IF Bom_Globals.Get_Debug = 'Y'
1785: THEN
1786: Error_Handler.Open_Debug_Session

Line 1784: IF Bom_Globals.Get_Debug = 'Y'

1780: l_debug_flag := 'N';
1781: END IF;
1782: Bom_Globals.Set_Debug(l_debug_flag);
1783:
1784: IF Bom_Globals.Get_Debug = 'Y'
1785: THEN
1786: Error_Handler.Open_Debug_Session
1787: ( p_debug_filename => p_debug_filename
1788: , p_output_dir => p_output_dir

Line 1801: Bom_Globals.Set_Debug(l_debug_flag);

1797: END IF;
1798: END IF;
1799: END IF;
1800:
1801: Bom_Globals.Set_Debug(l_debug_flag);
1802:
1803: IF Error_Handler.get_debug <> 'Y' THEN
1804: l_debug := Init_Debug;
1805: ELSE

Line 2120: IF Bom_Globals.Get_Debug = 'Y'

2116: x_return_status := Error_Handler.G_STATUS_UNEXPECTED;
2117: Error_Handler.Get_Message_List( x_message_list => l_message_list);
2118: x_Error_Mesg := l_message_list(1).Message_Text;
2119:
2120: IF Bom_Globals.Get_Debug = 'Y'
2121: THEN
2122: Error_Handler.Write_Debug('After getting exception for invalid batch id ');
2123: Error_Handler.Write_To_DebugFile;
2124: Error_Handler.Dump_Message_List;

Line 2223: l_eff_sql := l_eff_sql || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_REVISION_EFF'||'''), '

2219:
2220: l_eff_sql := ' SELECT ' ;
2221:
2222: IF l_from_rev_intf IS NOT NULL THEN
2223: l_eff_sql := l_eff_sql || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_REVISION_EFF'||'''), '
2224: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_FROM_END_ITEM_REV_LABEL'||'''), '
2225: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_FROM_END_ITEM_REV_LABEL'||'''), '
2226: || p_batch_id || ', '
2227: || '''' || l_from_rev_intf || ''', ' ;

Line 2224: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_FROM_END_ITEM_REV_LABEL'||'''), '

2220: l_eff_sql := ' SELECT ' ;
2221:
2222: IF l_from_rev_intf IS NOT NULL THEN
2223: l_eff_sql := l_eff_sql || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_REVISION_EFF'||'''), '
2224: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_FROM_END_ITEM_REV_LABEL'||'''), '
2225: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_FROM_END_ITEM_REV_LABEL'||'''), '
2226: || p_batch_id || ', '
2227: || '''' || l_from_rev_intf || ''', ' ;
2228: IF l_from_rev_pdh IS NOT NULL THEN

Line 2225: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_FROM_END_ITEM_REV_LABEL'||'''), '

2221:
2222: IF l_from_rev_intf IS NOT NULL THEN
2223: l_eff_sql := l_eff_sql || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_REVISION_EFF'||'''), '
2224: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_FROM_END_ITEM_REV_LABEL'||'''), '
2225: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_FROM_END_ITEM_REV_LABEL'||'''), '
2226: || p_batch_id || ', '
2227: || '''' || l_from_rev_intf || ''', ' ;
2228: IF l_from_rev_pdh IS NOT NULL THEN
2229: l_eff_sql := l_eff_sql || '''' || l_from_rev_pdh || '''';

Line 2235: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_REVISION_EFF'||'''), '

2231: l_eff_sql := l_eff_sql || ' null ' ;
2232: END IF;
2233: l_eff_sql := l_eff_sql || ' FROM DUAL '
2234: || ' UNION ALL SELECT '
2235: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_REVISION_EFF'||'''), '
2236: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_TO_END_ITEM_REV_LABEL'||'''), '
2237: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_TO_END_ITEM_REV_LABEL'||'''), '
2238: || p_batch_id || ', ' ;
2239: IF l_to_item_rev_intf IS NOT NULL THEN

Line 2236: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_TO_END_ITEM_REV_LABEL'||'''), '

2232: END IF;
2233: l_eff_sql := l_eff_sql || ' FROM DUAL '
2234: || ' UNION ALL SELECT '
2235: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_REVISION_EFF'||'''), '
2236: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_TO_END_ITEM_REV_LABEL'||'''), '
2237: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_TO_END_ITEM_REV_LABEL'||'''), '
2238: || p_batch_id || ', ' ;
2239: IF l_to_item_rev_intf IS NOT NULL THEN
2240: l_eff_sql := l_eff_sql || '''' || l_to_item_rev_intf || ''' , ';

Line 2237: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_TO_END_ITEM_REV_LABEL'||'''), '

2233: l_eff_sql := l_eff_sql || ' FROM DUAL '
2234: || ' UNION ALL SELECT '
2235: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_REVISION_EFF'||'''), '
2236: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_TO_END_ITEM_REV_LABEL'||'''), '
2237: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_TO_END_ITEM_REV_LABEL'||'''), '
2238: || p_batch_id || ', ' ;
2239: IF l_to_item_rev_intf IS NOT NULL THEN
2240: l_eff_sql := l_eff_sql || '''' || l_to_item_rev_intf || ''' , ';
2241: ELSE

Line 2252: l_eff_sql := l_eff_sql || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_UNIT_EFF'||'''), '

2248: l_eff_sql := l_eff_sql || ' null ' ;
2249: END IF;
2250: l_eff_sql := l_eff_sql || ' FROM DUAL ';
2251: ELSIF (l_new_from_num_intf IS NOT NULL OR l_from_num_intf IS NOT NULL) THEN
2252: l_eff_sql := l_eff_sql || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_UNIT_EFF'||'''), '
2253: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_EFF_FROM_NUMBER'||'''), '
2254: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_EFF_FROM_NUMBER'||'''), '
2255: || p_batch_id || ', ';
2256: IF l_new_from_num_intf IS NOT NULL THEN

Line 2253: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_EFF_FROM_NUMBER'||'''), '

2249: END IF;
2250: l_eff_sql := l_eff_sql || ' FROM DUAL ';
2251: ELSIF (l_new_from_num_intf IS NOT NULL OR l_from_num_intf IS NOT NULL) THEN
2252: l_eff_sql := l_eff_sql || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_UNIT_EFF'||'''), '
2253: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_EFF_FROM_NUMBER'||'''), '
2254: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_EFF_FROM_NUMBER'||'''), '
2255: || p_batch_id || ', ';
2256: IF l_new_from_num_intf IS NOT NULL THEN
2257: l_eff_sql := l_eff_sql || '''' || l_new_from_num_intf || ''' , ' ;

Line 2254: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_EFF_FROM_NUMBER'||'''), '

2250: l_eff_sql := l_eff_sql || ' FROM DUAL ';
2251: ELSIF (l_new_from_num_intf IS NOT NULL OR l_from_num_intf IS NOT NULL) THEN
2252: l_eff_sql := l_eff_sql || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_UNIT_EFF'||'''), '
2253: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_EFF_FROM_NUMBER'||'''), '
2254: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_EFF_FROM_NUMBER'||'''), '
2255: || p_batch_id || ', ';
2256: IF l_new_from_num_intf IS NOT NULL THEN
2257: l_eff_sql := l_eff_sql || '''' || l_new_from_num_intf || ''' , ' ;
2258: ELSIF l_from_num_intf IS NOT NULL THEN

Line 2270: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_UNIT_EFF'||'''), '

2266: l_eff_sql := l_eff_sql || ' null ' ;
2267: END IF;
2268: l_eff_sql := l_eff_sql || ' FROM DUAL '
2269: || ' UNION ALL SELECT '
2270: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_UNIT_EFF'||'''), '
2271: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_EFF_TO_NUMBER'||'''), '
2272: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_EFF_TO_NUMBER'||'''), '
2273: || p_batch_id || ', ';
2274: IF l_to_unit_num_intf IS NOT NULL THEN

Line 2271: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_EFF_TO_NUMBER'||'''), '

2267: END IF;
2268: l_eff_sql := l_eff_sql || ' FROM DUAL '
2269: || ' UNION ALL SELECT '
2270: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_UNIT_EFF'||'''), '
2271: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_EFF_TO_NUMBER'||'''), '
2272: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_EFF_TO_NUMBER'||'''), '
2273: || p_batch_id || ', ';
2274: IF l_to_unit_num_intf IS NOT NULL THEN
2275: l_eff_sql := l_eff_sql || '''' || l_to_unit_num_intf || ''' , ';

Line 2272: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_EFF_TO_NUMBER'||'''), '

2268: l_eff_sql := l_eff_sql || ' FROM DUAL '
2269: || ' UNION ALL SELECT '
2270: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_UNIT_EFF'||'''), '
2271: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_EFF_TO_NUMBER'||'''), '
2272: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_EFF_TO_NUMBER'||'''), '
2273: || p_batch_id || ', ';
2274: IF l_to_unit_num_intf IS NOT NULL THEN
2275: l_eff_sql := l_eff_sql || '''' || l_to_unit_num_intf || ''' , ';
2276: ELSE

Line 2286: l_eff_sql := l_eff_sql || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_EFF_DATE_CHOICE'||'''), '

2282: l_eff_sql := l_eff_sql || ' NULL ';
2283: END IF;
2284: l_eff_sql := l_eff_sql || ' FROM DUAL ';
2285: ELSE
2286: l_eff_sql := l_eff_sql || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_EFF_DATE_CHOICE'||'''), '
2287: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_EFFECTIVITY_DATE'||'''), '
2288: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_EFFECTIVITY_DATE'||'''), '
2289: || p_batch_id || ', ';
2290: IF l_eff_date_intf IS NOT NULL THEN

Line 2287: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_EFFECTIVITY_DATE'||'''), '

2283: END IF;
2284: l_eff_sql := l_eff_sql || ' FROM DUAL ';
2285: ELSE
2286: l_eff_sql := l_eff_sql || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_EFF_DATE_CHOICE'||'''), '
2287: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_EFFECTIVITY_DATE'||'''), '
2288: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_EFFECTIVITY_DATE'||'''), '
2289: || p_batch_id || ', ';
2290: IF l_eff_date_intf IS NOT NULL THEN
2291: l_eff_sql := l_eff_sql || '''' || FND_DATE.DATE_TO_DISPLAYDT(l_eff_date_intf) || ''' , ' ;

Line 2288: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_EFFECTIVITY_DATE'||'''), '

2284: l_eff_sql := l_eff_sql || ' FROM DUAL ';
2285: ELSE
2286: l_eff_sql := l_eff_sql || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_EFF_DATE_CHOICE'||'''), '
2287: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_EFFECTIVITY_DATE'||'''), '
2288: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_EFFECTIVITY_DATE'||'''), '
2289: || p_batch_id || ', ';
2290: IF l_eff_date_intf IS NOT NULL THEN
2291: l_eff_sql := l_eff_sql || '''' || FND_DATE.DATE_TO_DISPLAYDT(l_eff_date_intf) || ''' , ' ;
2292: ELSIF l_new_eff_date_intf IS NOT NULL THEN

Line 2305: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_EFF_DATE_CHOICE'||'''), '

2301: l_eff_sql := l_eff_sql || ' NULL ' ;
2302: END IF;
2303: l_eff_sql := l_eff_sql || ' FROM DUAL '
2304: || ' UNION ALL SELECT '
2305: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_EFF_DATE_CHOICE'||'''), '
2306: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_DISABLE_DATE'||'''), '
2307: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_DISABLE_DATE'||'''), '
2308: || p_batch_id || ', ' ;
2309: IF l_dis_date_intf IS NOT NULL THEN

Line 2306: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_DISABLE_DATE'||'''), '

2302: END IF;
2303: l_eff_sql := l_eff_sql || ' FROM DUAL '
2304: || ' UNION ALL SELECT '
2305: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_EFF_DATE_CHOICE'||'''), '
2306: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_DISABLE_DATE'||'''), '
2307: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_DISABLE_DATE'||'''), '
2308: || p_batch_id || ', ' ;
2309: IF l_dis_date_intf IS NOT NULL THEN
2310: l_eff_sql := l_eff_sql || '''' || FND_DATE.DATE_TO_DISPLAYDT(l_dis_date_intf) || ''', ' ;

Line 2307: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_DISABLE_DATE'||'''), '

2303: l_eff_sql := l_eff_sql || ' FROM DUAL '
2304: || ' UNION ALL SELECT '
2305: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_EFF_DATE_CHOICE'||'''), '
2306: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_DISABLE_DATE'||'''), '
2307: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_DISABLE_DATE'||'''), '
2308: || p_batch_id || ', ' ;
2309: IF l_dis_date_intf IS NOT NULL THEN
2310: l_eff_sql := l_eff_sql || '''' || FND_DATE.DATE_TO_DISPLAYDT(l_dis_date_intf) || ''', ' ;
2311: ELSE

Line 2528: l_attr_sql := l_attr_sql || ' UNION ALL SELECT Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_IMPORT_REF_DESGS'||'''),null,null, ' || p_batch_id || ' batch_identifier '

2524: --dinu_log_message(' FROM bom_attrs_v attr,');
2525: --dinu_log_message(l_src_query );
2526: --dinu_log_message(l_pdh_query );
2527: --dinu_log_message( ' WHERE attr.attr_group_type = '|| '''' || 'BOM_COMPONENT_BASE'||'''' );
2528: l_attr_sql := l_attr_sql || ' UNION ALL SELECT Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_IMPORT_REF_DESGS'||'''),null,null, ' || p_batch_id || ' batch_identifier '
2529: ||',bom_import_pub.get_ref_desgs(:1,:2,:3,1,:5,:6,:7,:8),bom_import_pub.get_ref_desgs(:1,:2,:3,null,:5,:6,:7,:8) from dual' ;
2530:
2531: /*dinu_log_message(' UNION ALL SELECT Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_IMPORT_REF_DESGS'||'''),null,' || p_batch_id || ' batch_identifier ,';
2532: ||'bom_import_pub.get_ref_desgs(:1,:2,:3,1,:5,:6,:7,:8),');*/

Line 2531: /*dinu_log_message(' UNION ALL SELECT Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_IMPORT_REF_DESGS'||'''),null,' || p_batch_id || ' batch_identifier ,';

2527: --dinu_log_message( ' WHERE attr.attr_group_type = '|| '''' || 'BOM_COMPONENT_BASE'||'''' );
2528: l_attr_sql := l_attr_sql || ' UNION ALL SELECT Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_IMPORT_REF_DESGS'||'''),null,null, ' || p_batch_id || ' batch_identifier '
2529: ||',bom_import_pub.get_ref_desgs(:1,:2,:3,1,:5,:6,:7,:8),bom_import_pub.get_ref_desgs(:1,:2,:3,null,:5,:6,:7,:8) from dual' ;
2530:
2531: /*dinu_log_message(' UNION ALL SELECT Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_IMPORT_REF_DESGS'||'''),null,' || p_batch_id || ' batch_identifier ,';
2532: ||'bom_import_pub.get_ref_desgs(:1,:2,:3,1,:5,:6,:7,:8),');*/
2533: --dinu_log_message(' bom_import_pub.get_ref_desgs(:1,:2,:3,null,:5,:6,:7,:8) from dual' );
2534:
2535:

Line 2674: BOM_Globals.Set_Debug(l_debug_flag);

2670: , p_Token_Tbl => l_token_tbl
2671: );
2672: l_debug_flag := 'N';
2673: END IF;
2674: BOM_Globals.Set_Debug(l_debug_flag);
2675:
2676: IF BOM_Globals.Get_Debug = 'Y'
2677: THEN
2678: Error_Handler.Open_Debug_Session

Line 2676: IF BOM_Globals.Get_Debug = 'Y'

2672: l_debug_flag := 'N';
2673: END IF;
2674: BOM_Globals.Set_Debug(l_debug_flag);
2675:
2676: IF BOM_Globals.Get_Debug = 'Y'
2677: THEN
2678: Error_Handler.Open_Debug_Session
2679: ( p_debug_filename => p_debug_filename
2680: , p_output_dir => p_output_dir

Line 2693: Bom_Globals.Set_Debug(l_debug_flag);

2689: END IF;
2690: END IF;
2691: END IF;
2692:
2693: Bom_Globals.Set_Debug(l_debug_flag);
2694:
2695: /*IF NOT Does_Batch_Exist(p_batch_id)
2696: THEN
2697: l_other_message := 'BOM_BATCH_NOT_VALID';

Line 2793: IF Bom_Globals.Get_Debug = 'Y'

2789: );
2790: x_return_status := Error_Handler.G_STATUS_UNEXPECTED;
2791: x_Error_Mesg := l_other_message;
2792:
2793: IF Bom_Globals.Get_Debug = 'Y'
2794: THEN
2795: Error_Handler.Write_Debug('After getting exception for invalid batch id');
2796: Error_Handler.Write_To_DebugFile;
2797: Error_Handler.Dump_Message_List;

Line 3989: * value from BOM_GLOBALS and return the display name for

3985: END Update_Confirmed_Items;
3986:
3987: /*
3988: * Function will check the internal value is PRIMARY_UI
3989: * value from BOM_GLOBALS and return the display name for
3990: * primary structure Name
3991: */
3992: FUNCTION Get_Primary_StructureName
3993: (p_struct_Internal_Name IN VARCHAR2)

Line 3996: l_primary_internal VARCHAR2(50) := BOM_GLOBALS.GET_PRIMARY_UI;

3992: FUNCTION Get_Primary_StructureName
3993: (p_struct_Internal_Name IN VARCHAR2)
3994: RETURN VARCHAR2
3995: IS
3996: l_primary_internal VARCHAR2(50) := BOM_GLOBALS.GET_PRIMARY_UI;
3997: l_primary_display VARCHAR2(50) := bom_globals.RETRIEVE_MESSAGE('BOM','BOM_PRIMARY');
3998: BEGIN
3999: IF ((p_struct_Internal_Name IS NULL) OR (p_struct_Internal_Name = l_primary_internal)) THEN
4000: RETURN l_primary_display;

Line 3997: l_primary_display VARCHAR2(50) := bom_globals.RETRIEVE_MESSAGE('BOM','BOM_PRIMARY');

3993: (p_struct_Internal_Name IN VARCHAR2)
3994: RETURN VARCHAR2
3995: IS
3996: l_primary_internal VARCHAR2(50) := BOM_GLOBALS.GET_PRIMARY_UI;
3997: l_primary_display VARCHAR2(50) := bom_globals.RETRIEVE_MESSAGE('BOM','BOM_PRIMARY');
3998: BEGIN
3999: IF ((p_struct_Internal_Name IS NULL) OR (p_struct_Internal_Name = l_primary_internal)) THEN
4000: RETURN l_primary_display;
4001: ELSE

Line 4045: l_change_policy := Bom_Globals.Get_Change_Policy_Val(l_bill_seq_table(i),NULL);

4041:
4042: FOR i IN 1..l_bill_seq_table.COUNT LOOP
4043:
4044: IF l_change_flag = 'N' OR l_change_flag IS NULL THEN
4045: l_change_policy := Bom_Globals.Get_Change_Policy_Val(l_bill_seq_table(i),NULL);
4046: IF l_change_policy = 'NOT_ALLOWED' THEN
4047: -- Thorw error
4048: Error_Handler.Add_Error_Token
4049: (

Line 5428: l_str_chng_policy := BOM_GLOBALS.Get_Change_Policy_Val (l_header_table(i).assembly_item_id,

5424: AND mrb.revision = l_header_table(i).revision;
5425: END IF;
5426:
5427: IF l_rev_id IS NOT NULL THEN
5428: l_str_chng_policy := BOM_GLOBALS.Get_Change_Policy_Val (l_header_table(i).assembly_item_id,
5429: l_header_table(i).organization_id,
5430: l_rev_id,
5431: null,
5432: l_header_table(i).structure_type_id);

Line 5434: l_str_chng_policy := BOM_GLOBALS.Get_Change_Policy_Val (l_header_table(i).assembly_item_id,

5430: l_rev_id,
5431: null,
5432: l_header_table(i).structure_type_id);
5433: ELSE
5434: l_str_chng_policy := BOM_GLOBALS.Get_Change_Policy_Val (l_header_table(i).assembly_item_id,
5435: l_header_table(i).organization_id,
5436: NULL,
5437: SYSDATE,
5438: l_header_table(i).structure_type_id);