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.BOMCUMYD dependencies on FND_FILE

Line 53: FND_FILE.PUT_LINE(FND_FILE.LOG,'******************************************') ;

49: AND organization_id = current_org_id;
50:
51: BEGIN
52: /* Print the list of parameters */
53: FND_FILE.PUT_LINE(FND_FILE.LOG,'******************************************') ;
54: FND_FILE.PUT_LINE( FND_FILE.LOG,'SCOPE='||to_char(scope));
55: FND_FILE.PUT_LINE( FND_FILE.LOG,'CURRENT_ORG_ID='||to_char(current_org_id));
56: FND_FILE.PUT_LINE( FND_FILE.LOG,'ITEM_ID='||to_char(item_id));
57: FND_FILE.PUT_LINE( FND_FILE.LOG,'ITEM_FROM='||item_low);

Line 54: FND_FILE.PUT_LINE( FND_FILE.LOG,'SCOPE='||to_char(scope));

50:
51: BEGIN
52: /* Print the list of parameters */
53: FND_FILE.PUT_LINE(FND_FILE.LOG,'******************************************') ;
54: FND_FILE.PUT_LINE( FND_FILE.LOG,'SCOPE='||to_char(scope));
55: FND_FILE.PUT_LINE( FND_FILE.LOG,'CURRENT_ORG_ID='||to_char(current_org_id));
56: FND_FILE.PUT_LINE( FND_FILE.LOG,'ITEM_ID='||to_char(item_id));
57: FND_FILE.PUT_LINE( FND_FILE.LOG,'ITEM_FROM='||item_low);
58: FND_FILE.PUT_LINE( FND_FILE.LOG,'ITEM_TO='||item_high);

Line 55: FND_FILE.PUT_LINE( FND_FILE.LOG,'CURRENT_ORG_ID='||to_char(current_org_id));

51: BEGIN
52: /* Print the list of parameters */
53: FND_FILE.PUT_LINE(FND_FILE.LOG,'******************************************') ;
54: FND_FILE.PUT_LINE( FND_FILE.LOG,'SCOPE='||to_char(scope));
55: FND_FILE.PUT_LINE( FND_FILE.LOG,'CURRENT_ORG_ID='||to_char(current_org_id));
56: FND_FILE.PUT_LINE( FND_FILE.LOG,'ITEM_ID='||to_char(item_id));
57: FND_FILE.PUT_LINE( FND_FILE.LOG,'ITEM_FROM='||item_low);
58: FND_FILE.PUT_LINE( FND_FILE.LOG,'ITEM_TO='||item_high);
59: FND_FILE.PUT_LINE( FND_FILE.LOG,'OPERATION_TYPE='||to_char(operation_type));

Line 56: FND_FILE.PUT_LINE( FND_FILE.LOG,'ITEM_ID='||to_char(item_id));

52: /* Print the list of parameters */
53: FND_FILE.PUT_LINE(FND_FILE.LOG,'******************************************') ;
54: FND_FILE.PUT_LINE( FND_FILE.LOG,'SCOPE='||to_char(scope));
55: FND_FILE.PUT_LINE( FND_FILE.LOG,'CURRENT_ORG_ID='||to_char(current_org_id));
56: FND_FILE.PUT_LINE( FND_FILE.LOG,'ITEM_ID='||to_char(item_id));
57: FND_FILE.PUT_LINE( FND_FILE.LOG,'ITEM_FROM='||item_low);
58: FND_FILE.PUT_LINE( FND_FILE.LOG,'ITEM_TO='||item_high);
59: FND_FILE.PUT_LINE( FND_FILE.LOG,'OPERATION_TYPE='||to_char(operation_type));
60: FND_FILE.PUT_LINE( FND_FILE.LOG,'UPDATE_EVENTS='||to_char(update_events));

Line 57: FND_FILE.PUT_LINE( FND_FILE.LOG,'ITEM_FROM='||item_low);

53: FND_FILE.PUT_LINE(FND_FILE.LOG,'******************************************') ;
54: FND_FILE.PUT_LINE( FND_FILE.LOG,'SCOPE='||to_char(scope));
55: FND_FILE.PUT_LINE( FND_FILE.LOG,'CURRENT_ORG_ID='||to_char(current_org_id));
56: FND_FILE.PUT_LINE( FND_FILE.LOG,'ITEM_ID='||to_char(item_id));
57: FND_FILE.PUT_LINE( FND_FILE.LOG,'ITEM_FROM='||item_low);
58: FND_FILE.PUT_LINE( FND_FILE.LOG,'ITEM_TO='||item_high);
59: FND_FILE.PUT_LINE( FND_FILE.LOG,'OPERATION_TYPE='||to_char(operation_type));
60: FND_FILE.PUT_LINE( FND_FILE.LOG,'UPDATE_EVENTS='||to_char(update_events));
61: FND_FILE.PUT_LINE(FND_FILE.LOG,'******************************************') ;

Line 58: FND_FILE.PUT_LINE( FND_FILE.LOG,'ITEM_TO='||item_high);

54: FND_FILE.PUT_LINE( FND_FILE.LOG,'SCOPE='||to_char(scope));
55: FND_FILE.PUT_LINE( FND_FILE.LOG,'CURRENT_ORG_ID='||to_char(current_org_id));
56: FND_FILE.PUT_LINE( FND_FILE.LOG,'ITEM_ID='||to_char(item_id));
57: FND_FILE.PUT_LINE( FND_FILE.LOG,'ITEM_FROM='||item_low);
58: FND_FILE.PUT_LINE( FND_FILE.LOG,'ITEM_TO='||item_high);
59: FND_FILE.PUT_LINE( FND_FILE.LOG,'OPERATION_TYPE='||to_char(operation_type));
60: FND_FILE.PUT_LINE( FND_FILE.LOG,'UPDATE_EVENTS='||to_char(update_events));
61: FND_FILE.PUT_LINE(FND_FILE.LOG,'******************************************') ;
62: /* Make sure the right set of parameter are passed */

Line 59: FND_FILE.PUT_LINE( FND_FILE.LOG,'OPERATION_TYPE='||to_char(operation_type));

55: FND_FILE.PUT_LINE( FND_FILE.LOG,'CURRENT_ORG_ID='||to_char(current_org_id));
56: FND_FILE.PUT_LINE( FND_FILE.LOG,'ITEM_ID='||to_char(item_id));
57: FND_FILE.PUT_LINE( FND_FILE.LOG,'ITEM_FROM='||item_low);
58: FND_FILE.PUT_LINE( FND_FILE.LOG,'ITEM_TO='||item_high);
59: FND_FILE.PUT_LINE( FND_FILE.LOG,'OPERATION_TYPE='||to_char(operation_type));
60: FND_FILE.PUT_LINE( FND_FILE.LOG,'UPDATE_EVENTS='||to_char(update_events));
61: FND_FILE.PUT_LINE(FND_FILE.LOG,'******************************************') ;
62: /* Make sure the right set of parameter are passed */
63: IF (scope = 2) AND ((item_low IS NULL) and (item_high is NULL)) THEN

Line 60: FND_FILE.PUT_LINE( FND_FILE.LOG,'UPDATE_EVENTS='||to_char(update_events));

56: FND_FILE.PUT_LINE( FND_FILE.LOG,'ITEM_ID='||to_char(item_id));
57: FND_FILE.PUT_LINE( FND_FILE.LOG,'ITEM_FROM='||item_low);
58: FND_FILE.PUT_LINE( FND_FILE.LOG,'ITEM_TO='||item_high);
59: FND_FILE.PUT_LINE( FND_FILE.LOG,'OPERATION_TYPE='||to_char(operation_type));
60: FND_FILE.PUT_LINE( FND_FILE.LOG,'UPDATE_EVENTS='||to_char(update_events));
61: FND_FILE.PUT_LINE(FND_FILE.LOG,'******************************************') ;
62: /* Make sure the right set of parameter are passed */
63: IF (scope = 2) AND ((item_low IS NULL) and (item_high is NULL)) THEN
64: raise Item_Range_Not_Specified ;

Line 61: FND_FILE.PUT_LINE(FND_FILE.LOG,'******************************************') ;

57: FND_FILE.PUT_LINE( FND_FILE.LOG,'ITEM_FROM='||item_low);
58: FND_FILE.PUT_LINE( FND_FILE.LOG,'ITEM_TO='||item_high);
59: FND_FILE.PUT_LINE( FND_FILE.LOG,'OPERATION_TYPE='||to_char(operation_type));
60: FND_FILE.PUT_LINE( FND_FILE.LOG,'UPDATE_EVENTS='||to_char(update_events));
61: FND_FILE.PUT_LINE(FND_FILE.LOG,'******************************************') ;
62: /* Make sure the right set of parameter are passed */
63: IF (scope = 2) AND ((item_low IS NULL) and (item_high is NULL)) THEN
64: raise Item_Range_Not_Specified ;
65: END IF ;

Line 87: FND_FILE.PUT_LINE( FND_FILE.LOG,'Processing routing for item....' || Item_Name || ' with Alternate... ' || C1.ALTERNATE_ROUTING_DESIGNATOR);

83:
84: For C1 in Cur_Rtg(Range_Item_Id)
85: Loop
86: if (C1.ALTERNATE_ROUTING_DESIGNATOR is not NULL) then
87: FND_FILE.PUT_LINE( FND_FILE.LOG,'Processing routing for item....' || Item_Name || ' with Alternate... ' || C1.ALTERNATE_ROUTING_DESIGNATOR);
88: else
89: FND_FILE.PUT_LINE( FND_FILE.LOG,'Processing routing for item....' || Item_Name);
90: end if;
91: --changes for bug 9676295 begin

Line 89: FND_FILE.PUT_LINE( FND_FILE.LOG,'Processing routing for item....' || Item_Name);

85: Loop
86: if (C1.ALTERNATE_ROUTING_DESIGNATOR is not NULL) then
87: FND_FILE.PUT_LINE( FND_FILE.LOG,'Processing routing for item....' || Item_Name || ' with Alternate... ' || C1.ALTERNATE_ROUTING_DESIGNATOR);
88: else
89: FND_FILE.PUT_LINE( FND_FILE.LOG,'Processing routing for item....' || Item_Name);
90: end if;
91: --changes for bug 9676295 begin
92: begin
93: select common_routing_sequence_id into l_routing_sequence_id from bom_operational_routings

Line 116: FND_FILE.PUT_LINE( FND_FILE.LOG,'Processing routing for item....' || Item_Name || ' with Alternate... ' || C1.ALTERNATE_ROUTING_DESIGNATOR);

112:
113: For C1 in Cur_Rtg(Range_Item_Id)
114: Loop
115: if (C1.ALTERNATE_ROUTING_DESIGNATOR is not NULL) then
116: FND_FILE.PUT_LINE( FND_FILE.LOG,'Processing routing for item....' || Item_Name || ' with Alternate... ' || C1.ALTERNATE_ROUTING_DESIGNATOR);
117: else
118: FND_FILE.PUT_LINE( FND_FILE.LOG,'Processing routing for item....' || Item_Name);
119: end if;
120: --changes for bug 9676295 begin

Line 118: FND_FILE.PUT_LINE( FND_FILE.LOG,'Processing routing for item....' || Item_Name);

114: Loop
115: if (C1.ALTERNATE_ROUTING_DESIGNATOR is not NULL) then
116: FND_FILE.PUT_LINE( FND_FILE.LOG,'Processing routing for item....' || Item_Name || ' with Alternate... ' || C1.ALTERNATE_ROUTING_DESIGNATOR);
117: else
118: FND_FILE.PUT_LINE( FND_FILE.LOG,'Processing routing for item....' || Item_Name);
119: end if;
120: --changes for bug 9676295 begin
121: begin
122: select common_routing_sequence_id into l_routing_sequence_id from bom_operational_routings

Line 146: FND_FILE.PUT_LINE( FND_FILE.LOG,'Processing routing for item....' || Item_Name || ' with Alternate... ' || C1.ALTERNATE_ROUTING_DESIGNATOR);

142:
143: For C1 in Cur_Rtg(Range_Item_Id)
144: Loop
145: if (C1.ALTERNATE_ROUTING_DESIGNATOR is not NULL) then
146: FND_FILE.PUT_LINE( FND_FILE.LOG,'Processing routing for item....' || Item_Name || ' with Alternate... ' || C1.ALTERNATE_ROUTING_DESIGNATOR);
147: else
148: FND_FILE.PUT_LINE( FND_FILE.LOG,'Processing routing for item....' || Item_Name);
149: end if;
150: --changes for bug 9676295 begin

Line 148: FND_FILE.PUT_LINE( FND_FILE.LOG,'Processing routing for item....' || Item_Name);

144: Loop
145: if (C1.ALTERNATE_ROUTING_DESIGNATOR is not NULL) then
146: FND_FILE.PUT_LINE( FND_FILE.LOG,'Processing routing for item....' || Item_Name || ' with Alternate... ' || C1.ALTERNATE_ROUTING_DESIGNATOR);
147: else
148: FND_FILE.PUT_LINE( FND_FILE.LOG,'Processing routing for item....' || Item_Name);
149: end if;
150: --changes for bug 9676295 begin
151: begin
152: select common_routing_sequence_id into l_routing_sequence_id from bom_operational_routings

Line 174: FND_FILE.PUT_LINE( FND_FILE.LOG,'Processing routing for item....' || Item_Name || ' with Alternate... ' || C1.ALTERNATE_ROUTING_DESIGNATOR);

170:
171: For C1 in Cur_Rtg(Item_Id)
172: Loop
173: if (C1.ALTERNATE_ROUTING_DESIGNATOR is not NULL) then
174: FND_FILE.PUT_LINE( FND_FILE.LOG,'Processing routing for item....' || Item_Name || ' with Alternate... ' || C1.ALTERNATE_ROUTING_DESIGNATOR);
175: else
176: FND_FILE.PUT_LINE( FND_FILE.LOG,'Processing routing for item....' || Item_Name);
177: end if;
178: --changes for bug 9676295 begin

Line 176: FND_FILE.PUT_LINE( FND_FILE.LOG,'Processing routing for item....' || Item_Name);

172: Loop
173: if (C1.ALTERNATE_ROUTING_DESIGNATOR is not NULL) then
174: FND_FILE.PUT_LINE( FND_FILE.LOG,'Processing routing for item....' || Item_Name || ' with Alternate... ' || C1.ALTERNATE_ROUTING_DESIGNATOR);
175: else
176: FND_FILE.PUT_LINE( FND_FILE.LOG,'Processing routing for item....' || Item_Name);
177: end if;
178: --changes for bug 9676295 begin
179: begin
180: select common_routing_sequence_id into l_routing_sequence_id from bom_operational_routings

Line 182: FND_FILE.PUT_LINE( FND_FILE.LOG,'Processing common routing for item....' || Item_Name || ' with common routing sequence id ' || l_routing_sequence_id);

178: --changes for bug 9676295 begin
179: begin
180: select common_routing_sequence_id into l_routing_sequence_id from bom_operational_routings
181: where common_routing_sequence_id <> routing_sequence_id and routing_sequence_id = C1.routing_sequence_id;
182: FND_FILE.PUT_LINE( FND_FILE.LOG,'Processing common routing for item....' || Item_Name || ' with common routing sequence id ' || l_routing_sequence_id);
183: exception
184: when no_data_found then
185: l_routing_sequence_id := C1.routing_sequence_id;
186: FND_FILE.PUT_LINE( FND_FILE.LOG,'Processing (not commoned) routing for item....' || Item_Name || ' with routing sequence id ' || l_routing_sequence_id);

Line 186: FND_FILE.PUT_LINE( FND_FILE.LOG,'Processing (not commoned) routing for item....' || Item_Name || ' with routing sequence id ' || l_routing_sequence_id);

182: FND_FILE.PUT_LINE( FND_FILE.LOG,'Processing common routing for item....' || Item_Name || ' with common routing sequence id ' || l_routing_sequence_id);
183: exception
184: when no_data_found then
185: l_routing_sequence_id := C1.routing_sequence_id;
186: FND_FILE.PUT_LINE( FND_FILE.LOG,'Processing (not commoned) routing for item....' || Item_Name || ' with routing sequence id ' || l_routing_sequence_id);
187: end;
188: BOM_CALC_CYNP.calc_cynp(l_routing_sequence_id,1,1);
189: --changes for bug 9676295 end
190:

Line 193: FND_FILE.PUT_LINE( FND_FILE.LOG,'Processing ends for Cumulative Yield...');

189: --changes for bug 9676295 end
190:
191: End Loop;
192: end if;
193: FND_FILE.PUT_LINE( FND_FILE.LOG,'Processing ends for Cumulative Yield...');
194: Exception
195: WHEN Item_Range_Not_Specified THEN
196: FND_FILE.PUT_LINE( FND_FILE.LOG,'ITEM RANGE NOT SPECIFIED');
197: RETCODE := 2;

Line 196: FND_FILE.PUT_LINE( FND_FILE.LOG,'ITEM RANGE NOT SPECIFIED');

192: end if;
193: FND_FILE.PUT_LINE( FND_FILE.LOG,'Processing ends for Cumulative Yield...');
194: Exception
195: WHEN Item_Range_Not_Specified THEN
196: FND_FILE.PUT_LINE( FND_FILE.LOG,'ITEM RANGE NOT SPECIFIED');
197: RETCODE := 2;
198: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',Current_Error_Code);
199: WHEN Item_Specific_Not_Specified THEN
200: FND_FILE.PUT_LINE( FND_FILE.LOG,'Specific Item Value not Specified');

Line 200: FND_FILE.PUT_LINE( FND_FILE.LOG,'Specific Item Value not Specified');

196: FND_FILE.PUT_LINE( FND_FILE.LOG,'ITEM RANGE NOT SPECIFIED');
197: RETCODE := 2;
198: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',Current_Error_Code);
199: WHEN Item_Specific_Not_Specified THEN
200: FND_FILE.PUT_LINE( FND_FILE.LOG,'Specific Item Value not Specified');
201: RETCODE := 2;
202: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',Current_Error_Code);
203: WHEN OTHERS THEN
204: FND_FILE.PUT_LINE(FND_FILE.LOG,'Others '||SQLCODE || ':'||SQLERRM) ;

Line 204: FND_FILE.PUT_LINE(FND_FILE.LOG,'Others '||SQLCODE || ':'||SQLERRM) ;

200: FND_FILE.PUT_LINE( FND_FILE.LOG,'Specific Item Value not Specified');
201: RETCODE := 2;
202: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',Current_Error_Code);
203: WHEN OTHERS THEN
204: FND_FILE.PUT_LINE(FND_FILE.LOG,'Others '||SQLCODE || ':'||SQLERRM) ;
205: RETCODE := 2;
206: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',Current_Error_Code);
207: End Cumulative_Yield;
208:

Line 221: FND_FILE.PUT_LINE(FND_FILE.LOG,'Inside calculation');

217: v_Lead_Time_Profile_Val varchar2(50); --Variable to define profile for Lead Time Basis
218: l_line_hours NUMBER;
219: l_line_Seconds NUMBER;
220: BEGIN
221: FND_FILE.PUT_LINE(FND_FILE.LOG,'Inside calculation');
222:
223: BOM_CALC_CYNP.calc_cynp(rtg_seq_id, opr_type, 1);
224: BOM_CALC_TPCT.calculate_tpct(rtg_seq_id, to_char(opr_type));
225: BOM_CALC_OP_TIMES_PK.calculate_operation_times(org_id, rtg_seq_id);

Line 321: FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing routing for item....'

317: )
318: IS
319: BEGIN
320: if (alt is not NULL) then
321: FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing routing for item....'
322: || to_char(item_id) || ' with Alternate... '
323: || alt || 'Rtg_seq_id = '
324: || to_char(rtg_seq_id));
325: else

Line 326: FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing routing for item....'

322: || to_char(item_id) || ' with Alternate... '
323: || alt || 'Rtg_seq_id = '
324: || to_char(rtg_seq_id));
325: else
326: FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing routing for item....'
327: || to_char(item_id) || 'Rtg_seq_id '
328: || to_char(rtg_seq_id));
329: end if;
330: END print_debug;

Line 452: FND_FILE.PUT_LINE(FND_FILE.LOG,'******************************************') ;

448:
449: BEGIN
450: /* Print the list of parameters */
451:
452: FND_FILE.PUT_LINE(FND_FILE.LOG,'******************************************') ;
453: FND_FILE.PUT_LINE(FND_FILE.LOG,'SCOPE='||to_char(scope));
454: FND_FILE.PUT_LINE(FND_FILE.LOG,'CURRENT_ORG_ID='||to_char(current_org_id));
455: FND_FILE.PUT_LINE(FND_FILE.LOG,'ITEM_ID='||to_char(item_id));
456: FND_FILE.PUT_LINE(FND_FILE.LOG,'ITEM_FROM='||item_low);

Line 453: FND_FILE.PUT_LINE(FND_FILE.LOG,'SCOPE='||to_char(scope));

449: BEGIN
450: /* Print the list of parameters */
451:
452: FND_FILE.PUT_LINE(FND_FILE.LOG,'******************************************') ;
453: FND_FILE.PUT_LINE(FND_FILE.LOG,'SCOPE='||to_char(scope));
454: FND_FILE.PUT_LINE(FND_FILE.LOG,'CURRENT_ORG_ID='||to_char(current_org_id));
455: FND_FILE.PUT_LINE(FND_FILE.LOG,'ITEM_ID='||to_char(item_id));
456: FND_FILE.PUT_LINE(FND_FILE.LOG,'ITEM_FROM='||item_low);
457: FND_FILE.PUT_LINE(FND_FILE.LOG,'ITEM_TO='||item_high);

Line 454: FND_FILE.PUT_LINE(FND_FILE.LOG,'CURRENT_ORG_ID='||to_char(current_org_id));

450: /* Print the list of parameters */
451:
452: FND_FILE.PUT_LINE(FND_FILE.LOG,'******************************************') ;
453: FND_FILE.PUT_LINE(FND_FILE.LOG,'SCOPE='||to_char(scope));
454: FND_FILE.PUT_LINE(FND_FILE.LOG,'CURRENT_ORG_ID='||to_char(current_org_id));
455: FND_FILE.PUT_LINE(FND_FILE.LOG,'ITEM_ID='||to_char(item_id));
456: FND_FILE.PUT_LINE(FND_FILE.LOG,'ITEM_FROM='||item_low);
457: FND_FILE.PUT_LINE(FND_FILE.LOG,'ITEM_TO='||item_high);
458: FND_FILE.PUT_LINE(FND_FILE.LOG,'OPERATION_TYPE='||to_char(oper_type));

Line 455: FND_FILE.PUT_LINE(FND_FILE.LOG,'ITEM_ID='||to_char(item_id));

451:
452: FND_FILE.PUT_LINE(FND_FILE.LOG,'******************************************') ;
453: FND_FILE.PUT_LINE(FND_FILE.LOG,'SCOPE='||to_char(scope));
454: FND_FILE.PUT_LINE(FND_FILE.LOG,'CURRENT_ORG_ID='||to_char(current_org_id));
455: FND_FILE.PUT_LINE(FND_FILE.LOG,'ITEM_ID='||to_char(item_id));
456: FND_FILE.PUT_LINE(FND_FILE.LOG,'ITEM_FROM='||item_low);
457: FND_FILE.PUT_LINE(FND_FILE.LOG,'ITEM_TO='||item_high);
458: FND_FILE.PUT_LINE(FND_FILE.LOG,'OPERATION_TYPE='||to_char(oper_type));
459: FND_FILE.PUT_LINE(FND_FILE.LOG,'LINE_ID='||to_char(Line_Id));

Line 456: FND_FILE.PUT_LINE(FND_FILE.LOG,'ITEM_FROM='||item_low);

452: FND_FILE.PUT_LINE(FND_FILE.LOG,'******************************************') ;
453: FND_FILE.PUT_LINE(FND_FILE.LOG,'SCOPE='||to_char(scope));
454: FND_FILE.PUT_LINE(FND_FILE.LOG,'CURRENT_ORG_ID='||to_char(current_org_id));
455: FND_FILE.PUT_LINE(FND_FILE.LOG,'ITEM_ID='||to_char(item_id));
456: FND_FILE.PUT_LINE(FND_FILE.LOG,'ITEM_FROM='||item_low);
457: FND_FILE.PUT_LINE(FND_FILE.LOG,'ITEM_TO='||item_high);
458: FND_FILE.PUT_LINE(FND_FILE.LOG,'OPERATION_TYPE='||to_char(oper_type));
459: FND_FILE.PUT_LINE(FND_FILE.LOG,'LINE_ID='||to_char(Line_Id));
460: FND_FILE.PUT_LINE(FND_FILE.LOG,'OPERATION_Name='||Operation_Name);

Line 457: FND_FILE.PUT_LINE(FND_FILE.LOG,'ITEM_TO='||item_high);

453: FND_FILE.PUT_LINE(FND_FILE.LOG,'SCOPE='||to_char(scope));
454: FND_FILE.PUT_LINE(FND_FILE.LOG,'CURRENT_ORG_ID='||to_char(current_org_id));
455: FND_FILE.PUT_LINE(FND_FILE.LOG,'ITEM_ID='||to_char(item_id));
456: FND_FILE.PUT_LINE(FND_FILE.LOG,'ITEM_FROM='||item_low);
457: FND_FILE.PUT_LINE(FND_FILE.LOG,'ITEM_TO='||item_high);
458: FND_FILE.PUT_LINE(FND_FILE.LOG,'OPERATION_TYPE='||to_char(oper_type));
459: FND_FILE.PUT_LINE(FND_FILE.LOG,'LINE_ID='||to_char(Line_Id));
460: FND_FILE.PUT_LINE(FND_FILE.LOG,'OPERATION_Name='||Operation_Name);
461: FND_FILE.PUT_LINE(FND_FILE.LOG,'Event_Name='||Event_Name);

Line 458: FND_FILE.PUT_LINE(FND_FILE.LOG,'OPERATION_TYPE='||to_char(oper_type));

454: FND_FILE.PUT_LINE(FND_FILE.LOG,'CURRENT_ORG_ID='||to_char(current_org_id));
455: FND_FILE.PUT_LINE(FND_FILE.LOG,'ITEM_ID='||to_char(item_id));
456: FND_FILE.PUT_LINE(FND_FILE.LOG,'ITEM_FROM='||item_low);
457: FND_FILE.PUT_LINE(FND_FILE.LOG,'ITEM_TO='||item_high);
458: FND_FILE.PUT_LINE(FND_FILE.LOG,'OPERATION_TYPE='||to_char(oper_type));
459: FND_FILE.PUT_LINE(FND_FILE.LOG,'LINE_ID='||to_char(Line_Id));
460: FND_FILE.PUT_LINE(FND_FILE.LOG,'OPERATION_Name='||Operation_Name);
461: FND_FILE.PUT_LINE(FND_FILE.LOG,'Event_Name='||Event_Name);
462: FND_FILE.PUT_LINE(FND_FILE.LOG,'******************************************') ;

Line 459: FND_FILE.PUT_LINE(FND_FILE.LOG,'LINE_ID='||to_char(Line_Id));

455: FND_FILE.PUT_LINE(FND_FILE.LOG,'ITEM_ID='||to_char(item_id));
456: FND_FILE.PUT_LINE(FND_FILE.LOG,'ITEM_FROM='||item_low);
457: FND_FILE.PUT_LINE(FND_FILE.LOG,'ITEM_TO='||item_high);
458: FND_FILE.PUT_LINE(FND_FILE.LOG,'OPERATION_TYPE='||to_char(oper_type));
459: FND_FILE.PUT_LINE(FND_FILE.LOG,'LINE_ID='||to_char(Line_Id));
460: FND_FILE.PUT_LINE(FND_FILE.LOG,'OPERATION_Name='||Operation_Name);
461: FND_FILE.PUT_LINE(FND_FILE.LOG,'Event_Name='||Event_Name);
462: FND_FILE.PUT_LINE(FND_FILE.LOG,'******************************************') ;
463:

Line 460: FND_FILE.PUT_LINE(FND_FILE.LOG,'OPERATION_Name='||Operation_Name);

456: FND_FILE.PUT_LINE(FND_FILE.LOG,'ITEM_FROM='||item_low);
457: FND_FILE.PUT_LINE(FND_FILE.LOG,'ITEM_TO='||item_high);
458: FND_FILE.PUT_LINE(FND_FILE.LOG,'OPERATION_TYPE='||to_char(oper_type));
459: FND_FILE.PUT_LINE(FND_FILE.LOG,'LINE_ID='||to_char(Line_Id));
460: FND_FILE.PUT_LINE(FND_FILE.LOG,'OPERATION_Name='||Operation_Name);
461: FND_FILE.PUT_LINE(FND_FILE.LOG,'Event_Name='||Event_Name);
462: FND_FILE.PUT_LINE(FND_FILE.LOG,'******************************************') ;
463:
464: i := 1;

Line 461: FND_FILE.PUT_LINE(FND_FILE.LOG,'Event_Name='||Event_Name);

457: FND_FILE.PUT_LINE(FND_FILE.LOG,'ITEM_TO='||item_high);
458: FND_FILE.PUT_LINE(FND_FILE.LOG,'OPERATION_TYPE='||to_char(oper_type));
459: FND_FILE.PUT_LINE(FND_FILE.LOG,'LINE_ID='||to_char(Line_Id));
460: FND_FILE.PUT_LINE(FND_FILE.LOG,'OPERATION_Name='||Operation_Name);
461: FND_FILE.PUT_LINE(FND_FILE.LOG,'Event_Name='||Event_Name);
462: FND_FILE.PUT_LINE(FND_FILE.LOG,'******************************************') ;
463:
464: i := 1;
465: item_tab.DELETE;

Line 462: FND_FILE.PUT_LINE(FND_FILE.LOG,'******************************************') ;

458: FND_FILE.PUT_LINE(FND_FILE.LOG,'OPERATION_TYPE='||to_char(oper_type));
459: FND_FILE.PUT_LINE(FND_FILE.LOG,'LINE_ID='||to_char(Line_Id));
460: FND_FILE.PUT_LINE(FND_FILE.LOG,'OPERATION_Name='||Operation_Name);
461: FND_FILE.PUT_LINE(FND_FILE.LOG,'Event_Name='||Event_Name);
462: FND_FILE.PUT_LINE(FND_FILE.LOG,'******************************************') ;
463:
464: i := 1;
465: item_tab.DELETE;
466:

Line 511: FND_FILE.PUT_LINE(FND_FILE.LOG,'Item/Item range specified, op type='||to_char(l_op_type));

507: Operation_Code := Operation_Name;
508: END IF;
509:
510: IF l_all = 0 THEN
511: FND_FILE.PUT_LINE(FND_FILE.LOG,'Item/Item range specified, op type='||to_char(l_op_type));
512: FOR i IN 1..item_tab.COUNT
513: LOOP
514: IF Line_id is NULL THEN /*** Line is not specified ***/
515: FND_FILE.PUT_LINE(FND_FILE.LOG,'No line is specified');

Line 515: FND_FILE.PUT_LINE(FND_FILE.LOG,'No line is specified');

511: FND_FILE.PUT_LINE(FND_FILE.LOG,'Item/Item range specified, op type='||to_char(l_op_type));
512: FOR i IN 1..item_tab.COUNT
513: LOOP
514: IF Line_id is NULL THEN /*** Line is not specified ***/
515: FND_FILE.PUT_LINE(FND_FILE.LOG,'No line is specified');
516: FOR C1 in Cur_Item_Flow_Rtg(item_tab(i))
517: Loop
518: print_debug(item_tab(i), C1.Alternate_Routing_Designator, C1.routing_sequence_id);
519: flm_calc_util(current_org_id, item_tab(i), l_op_type, C1.routing_sequence_id, Line_Id);

Line 522: FND_FILE.PUT_LINE(FND_FILE.LOG,'Only line is specified');

518: print_debug(item_tab(i), C1.Alternate_Routing_Designator, C1.routing_sequence_id);
519: flm_calc_util(current_org_id, item_tab(i), l_op_type, C1.routing_sequence_id, Line_Id);
520: End Loop;
521: ELSIF Operation_code is NULL THEN /*** Only Line is specified ***/
522: FND_FILE.PUT_LINE(FND_FILE.LOG,'Only line is specified');
523: FOR C1 in Cur_Item_Line_Flow_Rtg(item_tab(i), Line_Id)
524: Loop
525: print_debug(item_tab(i), C1.Alternate_Routing_Designator, C1.routing_sequence_id);
526: flm_calc_util(current_org_id, item_tab(i), l_op_type, C1.routing_sequence_id, Line_Id);

Line 529: FND_FILE.PUT_LINE(FND_FILE.LOG,'Line and operation is specified');

525: print_debug(item_tab(i), C1.Alternate_Routing_Designator, C1.routing_sequence_id);
526: flm_calc_util(current_org_id, item_tab(i), l_op_type, C1.routing_sequence_id, Line_Id);
527: End Loop;
528: ELSIF l_op_type > 1 THEN /*** Line and operation are specified ***/
529: FND_FILE.PUT_LINE(FND_FILE.LOG,'Line and operation is specified');
530: FOR C1 in Cur_Item_Line_Op_Flow_Rtg(item_tab(i), Line_id, Operation_Code)
531: Loop
532: print_debug(item_tab(i), C1.Alternate_Routing_Designator, C1.routing_sequence_id);
533: flm_calc_util(current_org_id, item_tab(i), l_op_type, C1.routing_sequence_id, Line_Id);

Line 540: FND_FILE.PUT_LINE(FND_FILE.LOG,'Line, operation and event specified');

536: IF scope = 1 AND NOT l_found THEN
537: raise No_Op_On_Line;
538: END IF;
539: ELSE /*** Line, operation_type and Event are specified ***/
540: FND_FILE.PUT_LINE(FND_FILE.LOG,'Line, operation and event specified');
541: FOR C1 in Cur_Item_Line_Op_Flow_Rtg(item_tab(i), Line_id, Operation_Code)
542: Loop
543: l_op_flag := check_op_type(C1.routing_sequence_id, oper_type);
544: IF l_op_flag <> 1 THEN

Line 556: FND_FILE.PUT_LINE(FND_FILE.LOG,'Item/Item range NOT specified, selecting all items...');

552: END IF;
553: END IF;
554: End Loop;
555: ELSE
556: FND_FILE.PUT_LINE(FND_FILE.LOG,'Item/Item range NOT specified, selecting all items...');
557: IF Line_id is NULL THEN /*** Line is not specified ***/
558: FND_FILE.PUT_LINE(FND_FILE.LOG,'No line is specified');
559: FOR C1 in Cur_Flow_Rtg
560: Loop

Line 558: FND_FILE.PUT_LINE(FND_FILE.LOG,'No line is specified');

554: End Loop;
555: ELSE
556: FND_FILE.PUT_LINE(FND_FILE.LOG,'Item/Item range NOT specified, selecting all items...');
557: IF Line_id is NULL THEN /*** Line is not specified ***/
558: FND_FILE.PUT_LINE(FND_FILE.LOG,'No line is specified');
559: FOR C1 in Cur_Flow_Rtg
560: Loop
561: print_debug(C1.assembly_item_id, C1.Alternate_Routing_Designator, C1.routing_sequence_id);
562: flm_calc_util(current_org_id, C1.assembly_item_id, l_op_type, C1.routing_sequence_id, Line_Id);

Line 565: FND_FILE.PUT_LINE(FND_FILE.LOG,'Only line is specified');

561: print_debug(C1.assembly_item_id, C1.Alternate_Routing_Designator, C1.routing_sequence_id);
562: flm_calc_util(current_org_id, C1.assembly_item_id, l_op_type, C1.routing_sequence_id, Line_Id);
563: End Loop;
564: ELSIF Operation_code is NULL THEN /*** Only Line is specified ***/
565: FND_FILE.PUT_LINE(FND_FILE.LOG,'Only line is specified');
566: FOR C1 in Cur_Line_Flow_Rtg(Line_Id)
567: Loop
568: print_debug(C1.assembly_item_id, C1.Alternate_Routing_Designator, C1.routing_sequence_id);
569: flm_calc_util(current_org_id, C1.assembly_item_id, l_op_type, C1.routing_sequence_id, Line_Id);

Line 572: FND_FILE.PUT_LINE(FND_FILE.LOG,'Line and operation specified');

568: print_debug(C1.assembly_item_id, C1.Alternate_Routing_Designator, C1.routing_sequence_id);
569: flm_calc_util(current_org_id, C1.assembly_item_id, l_op_type, C1.routing_sequence_id, Line_Id);
570: End Loop;
571: ELSIF l_op_type > 1 THEN /*** Line and operation specified ***/
572: FND_FILE.PUT_LINE(FND_FILE.LOG,'Line and operation specified');
573: FOR C1 in Cur_Line_Op_Flow_Rtg(Line_id, Operation_Code)
574: Loop
575: print_debug(C1.assembly_item_id, C1.Alternate_Routing_Designator, C1.routing_sequence_id);
576: flm_calc_util(current_org_id, C1.assembly_item_id, l_op_type, C1.routing_sequence_id, Line_Id);

Line 579: FND_FILE.PUT_LINE(FND_FILE.LOG,'Line, operation and event specified');

575: print_debug(C1.assembly_item_id, C1.Alternate_Routing_Designator, C1.routing_sequence_id);
576: flm_calc_util(current_org_id, C1.assembly_item_id, l_op_type, C1.routing_sequence_id, Line_Id);
577: End Loop;
578: ELSE /*** Line, Operation and event specified ***/
579: FND_FILE.PUT_LINE(FND_FILE.LOG,'Line, operation and event specified');
580: FOR C1 in Cur_Line_Op_Flow_Rtg(Line_id, Operation_Code)
581: Loop
582: l_op_flag := check_op_type(C1.routing_sequence_id, oper_type);
583: IF l_op_flag <> 1 THEN

Line 594: FND_FILE.PUT_LINE(FND_FILE.LOG,'Specified operation not available for the item on the line specified');

590: END IF;
591: Exception
592:
593: WHEN No_Op_On_Line THEN
594: FND_FILE.PUT_LINE(FND_FILE.LOG,'Specified operation not available for the item on the line specified');
595: RETCODE := 2;
596: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',Current_Error_Code);
597: WHEN No_Event_On_Line THEN
598: FND_FILE.PUT_LINE(FND_FILE.LOG,'Specified event not available for the item on the line specified');

Line 598: FND_FILE.PUT_LINE(FND_FILE.LOG,'Specified event not available for the item on the line specified');

594: FND_FILE.PUT_LINE(FND_FILE.LOG,'Specified operation not available for the item on the line specified');
595: RETCODE := 2;
596: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',Current_Error_Code);
597: WHEN No_Event_On_Line THEN
598: FND_FILE.PUT_LINE(FND_FILE.LOG,'Specified event not available for the item on the line specified');
599: RETCODE := 2;
600: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',Current_Error_Code);
601:
602: WHEN OTHERS THEN

Line 603: FND_FILE.PUT_LINE(FND_FILE.LOG,'Others '||SQLCODE || ':'||SQLERRM) ;

599: RETCODE := 2;
600: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',Current_Error_Code);
601:
602: WHEN OTHERS THEN
603: FND_FILE.PUT_LINE(FND_FILE.LOG,'Others '||SQLCODE || ':'||SQLERRM) ;
604: RETCODE := 2;
605: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',Current_Error_Code);
606:
607: END Flow_Batch_Calc;