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 74: Bom_Globals.Set_Debug ('Y');

70: l_out_dir := G_UTL_FILE_DIR;
71: END IF; -- G_HAS_UTL_FILE_DIR
72: Error_Handler.Initialize;
73: Error_Handler.Set_Debug ('Y');
74: Bom_Globals.Set_Debug ('Y');
75:
76: Error_Handler.Open_Debug_Session
77: ( p_debug_filename => l_debug_file
78: , p_output_dir => l_out_dir

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

403: IS
404: BEGIN
405: --Update Structure Name:Start
406: IF (pg_batch_options.structure_name IS NOT NULL
407: AND pg_batch_options.structure_name <> bom_globals.get_primary_ui)
408: THEN
409: UPDATE bom_bill_of_mtls_interface
410: SET alternate_bom_designator = pg_batch_options.structure_name
411: WHERE batch_id = p_batch_id

Line 1925: Bom_Globals.Set_Debug(l_debug_flag);

1921: , p_Token_Tbl => l_token_tbl
1922: );
1923: l_debug_flag := 'N';
1924: END IF;
1925: Bom_Globals.Set_Debug(l_debug_flag);
1926:
1927: IF Bom_Globals.Get_Debug = 'Y'
1928: THEN
1929: Error_Handler.Open_Debug_Session

Line 1927: IF Bom_Globals.Get_Debug = 'Y'

1923: l_debug_flag := 'N';
1924: END IF;
1925: Bom_Globals.Set_Debug(l_debug_flag);
1926:
1927: IF Bom_Globals.Get_Debug = 'Y'
1928: THEN
1929: Error_Handler.Open_Debug_Session
1930: ( p_debug_filename => p_debug_filename
1931: , p_output_dir => p_output_dir

Line 1944: Bom_Globals.Set_Debug(l_debug_flag);

1940: END IF;
1941: END IF;
1942: END IF;
1943:
1944: Bom_Globals.Set_Debug(l_debug_flag);
1945:
1946: IF Error_Handler.get_debug <> 'Y' THEN
1947: l_debug := Init_Debug;
1948: ELSE

Line 2263: IF Bom_Globals.Get_Debug = 'Y'

2259: x_return_status := Error_Handler.G_STATUS_UNEXPECTED;
2260: Error_Handler.Get_Message_List( x_message_list => l_message_list);
2261: x_Error_Mesg := l_message_list(1).Message_Text;
2262:
2263: IF Bom_Globals.Get_Debug = 'Y'
2264: THEN
2265: Error_Handler.Write_Debug('After getting exception for invalid batch id ');
2266: Error_Handler.Write_To_DebugFile;
2267: Error_Handler.Dump_Message_List;

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

2362:
2363: l_eff_sql := ' SELECT ' ;
2364:
2365: IF l_from_rev_intf IS NOT NULL THEN
2366: l_eff_sql := l_eff_sql || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_REVISION_EFF'||'''), '
2367: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_FROM_END_ITEM_REV_LABEL'||'''), '
2368: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_FROM_END_ITEM_REV_LABEL'||'''), '
2369: || p_batch_id || ', '
2370: || '''' || l_from_rev_intf || ''', ' ;

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

2363: l_eff_sql := ' SELECT ' ;
2364:
2365: IF l_from_rev_intf IS NOT NULL THEN
2366: l_eff_sql := l_eff_sql || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_REVISION_EFF'||'''), '
2367: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_FROM_END_ITEM_REV_LABEL'||'''), '
2368: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_FROM_END_ITEM_REV_LABEL'||'''), '
2369: || p_batch_id || ', '
2370: || '''' || l_from_rev_intf || ''', ' ;
2371: IF l_from_rev_pdh IS NOT NULL THEN

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

2364:
2365: IF l_from_rev_intf IS NOT NULL THEN
2366: l_eff_sql := l_eff_sql || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_REVISION_EFF'||'''), '
2367: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_FROM_END_ITEM_REV_LABEL'||'''), '
2368: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_FROM_END_ITEM_REV_LABEL'||'''), '
2369: || p_batch_id || ', '
2370: || '''' || l_from_rev_intf || ''', ' ;
2371: IF l_from_rev_pdh IS NOT NULL THEN
2372: l_eff_sql := l_eff_sql || '''' || l_from_rev_pdh || '''';

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

2374: l_eff_sql := l_eff_sql || ' null ' ;
2375: END IF;
2376: l_eff_sql := l_eff_sql || ' FROM DUAL '
2377: || ' UNION ALL SELECT '
2378: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_REVISION_EFF'||'''), '
2379: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_TO_END_ITEM_REV_LABEL'||'''), '
2380: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_TO_END_ITEM_REV_LABEL'||'''), '
2381: || p_batch_id || ', ' ;
2382: IF l_to_item_rev_intf IS NOT NULL THEN

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

2375: END IF;
2376: l_eff_sql := l_eff_sql || ' FROM DUAL '
2377: || ' UNION ALL SELECT '
2378: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_REVISION_EFF'||'''), '
2379: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_TO_END_ITEM_REV_LABEL'||'''), '
2380: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_TO_END_ITEM_REV_LABEL'||'''), '
2381: || p_batch_id || ', ' ;
2382: IF l_to_item_rev_intf IS NOT NULL THEN
2383: l_eff_sql := l_eff_sql || '''' || l_to_item_rev_intf || ''' , ';

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

2376: l_eff_sql := l_eff_sql || ' FROM DUAL '
2377: || ' UNION ALL SELECT '
2378: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_REVISION_EFF'||'''), '
2379: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_TO_END_ITEM_REV_LABEL'||'''), '
2380: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_TO_END_ITEM_REV_LABEL'||'''), '
2381: || p_batch_id || ', ' ;
2382: IF l_to_item_rev_intf IS NOT NULL THEN
2383: l_eff_sql := l_eff_sql || '''' || l_to_item_rev_intf || ''' , ';
2384: ELSE

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

2391: l_eff_sql := l_eff_sql || ' null ' ;
2392: END IF;
2393: l_eff_sql := l_eff_sql || ' FROM DUAL ';
2394: ELSIF (l_new_from_num_intf IS NOT NULL OR l_from_num_intf IS NOT NULL) THEN
2395: l_eff_sql := l_eff_sql || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_UNIT_EFF'||'''), '
2396: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_EFF_FROM_NUMBER'||'''), '
2397: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_EFF_FROM_NUMBER'||'''), '
2398: || p_batch_id || ', ';
2399: IF l_new_from_num_intf IS NOT NULL THEN

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

2392: END IF;
2393: l_eff_sql := l_eff_sql || ' FROM DUAL ';
2394: ELSIF (l_new_from_num_intf IS NOT NULL OR l_from_num_intf IS NOT NULL) THEN
2395: l_eff_sql := l_eff_sql || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_UNIT_EFF'||'''), '
2396: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_EFF_FROM_NUMBER'||'''), '
2397: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_EFF_FROM_NUMBER'||'''), '
2398: || p_batch_id || ', ';
2399: IF l_new_from_num_intf IS NOT NULL THEN
2400: l_eff_sql := l_eff_sql || '''' || l_new_from_num_intf || ''' , ' ;

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

2393: l_eff_sql := l_eff_sql || ' FROM DUAL ';
2394: ELSIF (l_new_from_num_intf IS NOT NULL OR l_from_num_intf IS NOT NULL) THEN
2395: l_eff_sql := l_eff_sql || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_UNIT_EFF'||'''), '
2396: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_EFF_FROM_NUMBER'||'''), '
2397: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_EFF_FROM_NUMBER'||'''), '
2398: || p_batch_id || ', ';
2399: IF l_new_from_num_intf IS NOT NULL THEN
2400: l_eff_sql := l_eff_sql || '''' || l_new_from_num_intf || ''' , ' ;
2401: ELSIF l_from_num_intf IS NOT NULL THEN

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

2409: l_eff_sql := l_eff_sql || ' null ' ;
2410: END IF;
2411: l_eff_sql := l_eff_sql || ' FROM DUAL '
2412: || ' UNION ALL SELECT '
2413: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_UNIT_EFF'||'''), '
2414: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_EFF_TO_NUMBER'||'''), '
2415: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_EFF_TO_NUMBER'||'''), '
2416: || p_batch_id || ', ';
2417: IF l_to_unit_num_intf IS NOT NULL THEN

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

2410: END IF;
2411: l_eff_sql := l_eff_sql || ' FROM DUAL '
2412: || ' UNION ALL SELECT '
2413: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_UNIT_EFF'||'''), '
2414: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_EFF_TO_NUMBER'||'''), '
2415: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_EFF_TO_NUMBER'||'''), '
2416: || p_batch_id || ', ';
2417: IF l_to_unit_num_intf IS NOT NULL THEN
2418: l_eff_sql := l_eff_sql || '''' || l_to_unit_num_intf || ''' , ';

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

2411: l_eff_sql := l_eff_sql || ' FROM DUAL '
2412: || ' UNION ALL SELECT '
2413: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_UNIT_EFF'||'''), '
2414: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_EFF_TO_NUMBER'||'''), '
2415: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_EFF_TO_NUMBER'||'''), '
2416: || p_batch_id || ', ';
2417: IF l_to_unit_num_intf IS NOT NULL THEN
2418: l_eff_sql := l_eff_sql || '''' || l_to_unit_num_intf || ''' , ';
2419: ELSE

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

2425: l_eff_sql := l_eff_sql || ' NULL ';
2426: END IF;
2427: l_eff_sql := l_eff_sql || ' FROM DUAL ';
2428: ELSE
2429: l_eff_sql := l_eff_sql || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_EFF_DATE_CHOICE'||'''), '
2430: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_EFFECTIVITY_DATE'||'''), '
2431: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_EFFECTIVITY_DATE'||'''), '
2432: || p_batch_id || ', ';
2433: IF l_eff_date_intf IS NOT NULL THEN

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

2426: END IF;
2427: l_eff_sql := l_eff_sql || ' FROM DUAL ';
2428: ELSE
2429: l_eff_sql := l_eff_sql || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_EFF_DATE_CHOICE'||'''), '
2430: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_EFFECTIVITY_DATE'||'''), '
2431: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_EFFECTIVITY_DATE'||'''), '
2432: || p_batch_id || ', ';
2433: IF l_eff_date_intf IS NOT NULL THEN
2434: --five lines below changed for calendar internationalization project

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

2427: l_eff_sql := l_eff_sql || ' FROM DUAL ';
2428: ELSE
2429: l_eff_sql := l_eff_sql || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_EFF_DATE_CHOICE'||'''), '
2430: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_EFFECTIVITY_DATE'||'''), '
2431: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_EFFECTIVITY_DATE'||'''), '
2432: || p_batch_id || ', ';
2433: IF l_eff_date_intf IS NOT NULL THEN
2434: --five lines below changed for calendar internationalization project
2435: --value 2 for calendar_aware parameter means FND_DATE.calendar_aware_alt

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

2446: l_eff_sql := l_eff_sql || ' NULL ' ;
2447: END IF;
2448: l_eff_sql := l_eff_sql || ' FROM DUAL '
2449: || ' UNION ALL SELECT '
2450: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_EFF_DATE_CHOICE'||'''), '
2451: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_DISABLE_DATE'||'''), '
2452: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_DISABLE_DATE'||'''), '
2453: || p_batch_id || ', ' ;
2454: IF l_dis_date_intf IS NOT NULL THEN

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

2447: END IF;
2448: l_eff_sql := l_eff_sql || ' FROM DUAL '
2449: || ' UNION ALL SELECT '
2450: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_EFF_DATE_CHOICE'||'''), '
2451: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_DISABLE_DATE'||'''), '
2452: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_DISABLE_DATE'||'''), '
2453: || p_batch_id || ', ' ;
2454: IF l_dis_date_intf IS NOT NULL THEN
2455: l_eff_sql := l_eff_sql || '''' || FND_DATE.DATE_TO_DISPLAYDT(l_dis_date_intf, 2) || ''', ' ;

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

2448: l_eff_sql := l_eff_sql || ' FROM DUAL '
2449: || ' UNION ALL SELECT '
2450: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_EFF_DATE_CHOICE'||'''), '
2451: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_DISABLE_DATE'||'''), '
2452: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_DISABLE_DATE'||'''), '
2453: || p_batch_id || ', ' ;
2454: IF l_dis_date_intf IS NOT NULL THEN
2455: l_eff_sql := l_eff_sql || '''' || FND_DATE.DATE_TO_DISPLAYDT(l_dis_date_intf, 2) || ''', ' ;
2456: ELSE

Line 2673: 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 '

2669: --dinu_log_message(' FROM bom_attrs_v attr,');
2670: --dinu_log_message(l_src_query );
2671: --dinu_log_message(l_pdh_query );
2672: --dinu_log_message( ' WHERE attr.attr_group_type = '|| '''' || 'BOM_COMPONENT_BASE'||'''' );
2673: 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 '
2674: ||',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' ;
2675:
2676: /*dinu_log_message(' UNION ALL SELECT Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_IMPORT_REF_DESGS'||'''),null,' || p_batch_id || ' batch_identifier ,';
2677: ||'bom_import_pub.get_ref_desgs(:1,:2,:3,1,:5,:6,:7,:8),');*/

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

2672: --dinu_log_message( ' WHERE attr.attr_group_type = '|| '''' || 'BOM_COMPONENT_BASE'||'''' );
2673: 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 '
2674: ||',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' ;
2675:
2676: /*dinu_log_message(' UNION ALL SELECT Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_IMPORT_REF_DESGS'||'''),null,' || p_batch_id || ' batch_identifier ,';
2677: ||'bom_import_pub.get_ref_desgs(:1,:2,:3,1,:5,:6,:7,:8),');*/
2678: --dinu_log_message(' bom_import_pub.get_ref_desgs(:1,:2,:3,null,:5,:6,:7,:8) from dual' );
2679:
2680:

Line 2827: BOM_Globals.Set_Debug(l_debug_flag);

2823: , p_Token_Tbl => l_token_tbl
2824: );
2825: l_debug_flag := 'N';
2826: END IF;
2827: BOM_Globals.Set_Debug(l_debug_flag);
2828:
2829: IF BOM_Globals.Get_Debug = 'Y'
2830: THEN
2831: Error_Handler.Open_Debug_Session

Line 2829: IF BOM_Globals.Get_Debug = 'Y'

2825: l_debug_flag := 'N';
2826: END IF;
2827: BOM_Globals.Set_Debug(l_debug_flag);
2828:
2829: IF BOM_Globals.Get_Debug = 'Y'
2830: THEN
2831: Error_Handler.Open_Debug_Session
2832: ( p_debug_filename => p_debug_filename
2833: , p_output_dir => p_output_dir

Line 2846: Bom_Globals.Set_Debug(l_debug_flag);

2842: END IF;
2843: END IF;
2844: END IF;
2845:
2846: Bom_Globals.Set_Debug(l_debug_flag);
2847:
2848: /*IF NOT Does_Batch_Exist(p_batch_id)
2849: THEN
2850: l_other_message := 'BOM_BATCH_NOT_VALID';

Line 2946: IF Bom_Globals.Get_Debug = 'Y'

2942: );
2943: x_return_status := Error_Handler.G_STATUS_UNEXPECTED;
2944: x_Error_Mesg := l_other_message;
2945:
2946: IF Bom_Globals.Get_Debug = 'Y'
2947: THEN
2948: Error_Handler.Write_Debug('After getting exception for invalid batch id');
2949: Error_Handler.Write_To_DebugFile;
2950: Error_Handler.Dump_Message_List;

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

4377: END Update_Confirmed_Items;
4378:
4379: /*
4380: * Function will check the internal value is PRIMARY_UI
4381: * value from BOM_GLOBALS and return the display name for
4382: * primary structure Name
4383: */
4384: FUNCTION Get_Primary_StructureName
4385: (p_struct_Internal_Name IN VARCHAR2)

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

4384: FUNCTION Get_Primary_StructureName
4385: (p_struct_Internal_Name IN VARCHAR2)
4386: RETURN VARCHAR2
4387: IS
4388: l_primary_internal VARCHAR2(50) := BOM_GLOBALS.GET_PRIMARY_UI;
4389: l_primary_display VARCHAR2(50) := bom_globals.RETRIEVE_MESSAGE('BOM','BOM_PRIMARY');
4390: BEGIN
4391: IF ((p_struct_Internal_Name IS NULL) OR (p_struct_Internal_Name = l_primary_internal)) THEN
4392: RETURN l_primary_display;

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

4385: (p_struct_Internal_Name IN VARCHAR2)
4386: RETURN VARCHAR2
4387: IS
4388: l_primary_internal VARCHAR2(50) := BOM_GLOBALS.GET_PRIMARY_UI;
4389: l_primary_display VARCHAR2(50) := bom_globals.RETRIEVE_MESSAGE('BOM','BOM_PRIMARY');
4390: BEGIN
4391: IF ((p_struct_Internal_Name IS NULL) OR (p_struct_Internal_Name = l_primary_internal)) THEN
4392: RETURN l_primary_display;
4393: ELSE

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

4433:
4434: FOR i IN 1..l_bill_seq_table.COUNT LOOP
4435:
4436: IF l_change_flag = 'N' OR l_change_flag IS NULL THEN
4437: l_change_policy := Bom_Globals.Get_Change_Policy_Val(l_bill_seq_table(i),NULL);
4438: IF l_change_policy = 'NOT_ALLOWED' THEN
4439: -- Thorw error
4440: Error_Handler.Add_Error_Token
4441: (

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

5816: AND mrb.revision = l_header_table(i).revision;
5817: END IF;
5818:
5819: IF l_rev_id IS NOT NULL THEN
5820: l_str_chng_policy := BOM_GLOBALS.Get_Change_Policy_Val (l_header_table(i).assembly_item_id,
5821: l_header_table(i).organization_id,
5822: l_rev_id,
5823: null,
5824: l_header_table(i).structure_type_id);

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

5822: l_rev_id,
5823: null,
5824: l_header_table(i).structure_type_id);
5825: ELSE
5826: l_str_chng_policy := BOM_GLOBALS.Get_Change_Policy_Val (l_header_table(i).assembly_item_id,
5827: l_header_table(i).organization_id,
5828: NULL,
5829: SYSDATE,
5830: l_header_table(i).structure_type_id);