APPS.BOMPMCFG dependencies on BOMPMCFG

Line 1: package body BOMPMCFG as

1: package body BOMPMCFG as
2: /* $Header: BOMMCFGB.pls 115.5 99/07/26 17:43:30 porting ship $ */
3: function atodupl_check (
4: model_line_id number,
5: sch_sesion_id number,

Line 93: status := BOMPMCFG.insert_mtl_dem_interface(configuration_item_id,org_id,

89: update bom_ato_configurations
90: set last_referenced_date = SYSDATE
91: where config_item_id = configuration_item_id;
92:
93: status := BOMPMCFG.insert_mtl_dem_interface(configuration_item_id,org_id,
94: sch_sesion_id,sch_grp_id,model_line_id,model_detail_id,
95: uom_code,line_qty,order_number,order_type,
96: error_message,message_name
97: );

Line 112: error_message := 'BOMPMCFG:' || to_char(stmt_num) || ':' ||

108: return (1);
109: exception
110: when NO_MODEL_FOUND THEN
111: configuration_item_id := NULL;
112: error_message := 'BOMPMCFG:' || to_char(stmt_num) || ':' ||
113: substrb(sqlerrm,1,150);
114: message_name := 'BOM_ATO_PROCESS_ERROR';
115: return (100);
116:

Line 118: error_message := 'BOMPMCFG:insert_mtl_demand_interface';

114: message_name := 'BOM_ATO_PROCESS_ERROR';
115: return (100);
116:
117: when INSERT_ERROR THEN
118: error_message := 'BOMPMCFG:insert_mtl_demand_interface';
119: return (200);
120:
121: when NO_DATA_FOUND THEN
122: configuration_item_id := NULL;

Line 126: error_message := 'BOMPMCFG' || to_char(stmt_num) || ':' ||

122: configuration_item_id := NULL;
123: return(1);
124: when OTHERS THEN
125:
126: error_message := 'BOMPMCFG' || to_char(stmt_num) || ':' ||
127: substrb(sqlerrm,1,150);
128: message_name := 'BOM_ATO_PROCESS_ERROR';
129: return(300);
130: end;

Line 215: error_message := 'BOMPMCFG' || to_char(stmt_num) || ':' ||

211:
212: return(1);
213: exception
214: when OTHERS THEN
215: error_message := 'BOMPMCFG' || to_char(stmt_num) || ':' ||
216: substrb(sqlerrm,1,150);
217: message_name := 'BOM_ATO_PROCESS_ERROR';
218: return(400);
219: end;

Line 295: error_message := 'BOMPMCFG' || to_char(stmt_num) || ':' ||

291:
292: return(1);
293: exception
294: when OTHERS THEN
295: error_message := 'BOMPMCFG' || to_char(stmt_num) || ':' ||
296: substrb(sqlerrm,1,150);
297: message_name := 'BOM_ATO_PROCESS_ERROR';
298: table_name := 'SO_LINES_ALL';
299: return(0);

Line 384: error_message := 'BOMPMCFG:' || to_char(stmt_num) || ':' ||

380:
381: return (1);
382: exception
383: when NO_MODEL_FOUND THEN
384: error_message := 'BOMPMCFG:' || to_char(stmt_num) || ':' ||
385: substrb(sqlerrm,1,150);
386: message_name := 'BOM_ATO_PROCESS_ERROR';
387: table_name := 'MTL_DEMAND';
388: return (0);

Line 394: error_message := 'BOMPMCFG' || to_char(stmt_num) || ':' ||

390: when NO_DATA_FOUND THEN
391: return(1);
392: when OTHERS THEN
393:
394: error_message := 'BOMPMCFG' || to_char(stmt_num) || ':' ||
395: substrb(sqlerrm,1,150);
396: message_name := 'BOM_ATO_PROCESS_ERROR';
397: table_name := 'SO_LINES_ALL';
398: return(0);

Line 401: end BOMPMCFG;

397: table_name := 'SO_LINES_ALL';
398: return(0);
399: end;
400:
401: end BOMPMCFG;