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

Line 102: fnd_file.put_line(fnd_file.log,x_usr_upgrade_docs||' is not a valid parameter.');

98: -- Make sure that user provides a valid value for the input x_usr_upgrade_docs
99:
100: IF x_usr_upgrade_docs NOT IN ('NONE', 'CURRENT', 'FUTURE') THEN
101:
102: fnd_file.put_line(fnd_file.log,x_usr_upgrade_docs||' is not a valid parameter.');
103: return;
104:
105: END IF;
106:

Line 116: fnd_file.put_line(fnd_file.log, '** ERROR: Please set the following site level profile option');

112: x_progress := 'SV0-040';
113: fnd_profile.get('MRP_DEFAULT_ASSIGNMENT_SET', x_assignment_set_id);
114:
115: If x_assignment_set_id IS NULL THEN
116: fnd_file.put_line(fnd_file.log, '** ERROR: Please set the following site level profile option');
117: fnd_file.put_line(fnd_file.log, '** before proceeding with this upgrade: ');
118: fnd_file.put_line(fnd_file.log, '** MRP: Default Sourcing Assignment Set');
119: return;
120: END IF;

Line 117: fnd_file.put_line(fnd_file.log, '** before proceeding with this upgrade: ');

113: fnd_profile.get('MRP_DEFAULT_ASSIGNMENT_SET', x_assignment_set_id);
114:
115: If x_assignment_set_id IS NULL THEN
116: fnd_file.put_line(fnd_file.log, '** ERROR: Please set the following site level profile option');
117: fnd_file.put_line(fnd_file.log, '** before proceeding with this upgrade: ');
118: fnd_file.put_line(fnd_file.log, '** MRP: Default Sourcing Assignment Set');
119: return;
120: END IF;
121:

Line 118: fnd_file.put_line(fnd_file.log, '** MRP: Default Sourcing Assignment Set');

114:
115: If x_assignment_set_id IS NULL THEN
116: fnd_file.put_line(fnd_file.log, '** ERROR: Please set the following site level profile option');
117: fnd_file.put_line(fnd_file.log, '** before proceeding with this upgrade: ');
118: fnd_file.put_line(fnd_file.log, '** MRP: Default Sourcing Assignment Set');
119: return;
120: END IF;
121:
122:

Line 156: fnd_file.put_line(fnd_file.log, 'A sourcing rule has already been assigned to ITEM_ID = '||x_item_id);

152: -- Another sourcing rule has already been assigned to this item
153: -- in the default PO assignment set. Do not upgrade autosource
154: -- rules for this item.
155: null;
156: fnd_file.put_line(fnd_file.log, 'A sourcing rule has already been assigned to ITEM_ID = '||x_item_id);
157:
158: ELSE
159:
160: -- Upgrade all autosource rules for the item, regardless of

Line 167: fnd_file.put_line(fnd_file.log, 'Upgrading autosource rules for ITEM_ID = '||x_item_id);

163: -- X_first_rule is used to identify the earliest autosource rule.
164:
165: x_first_rule := 'Y';
166:
167: fnd_file.put_line(fnd_file.log, 'Upgrading autosource rules for ITEM_ID = '||x_item_id);
168:
169: -- Select all autosource rules for this item.
170:
171: OPEN C1;

Line 216: fnd_file.put_line(fnd_file.log, '** Cannot get sourcing_rule_id');

212: OPEN I1;
213: FETCH I1 into x_sourcing_rule_id;
214: IF (I1%NOTFOUND) THEN
215: close I1;
216: fnd_file.put_line(fnd_file.log, '** Cannot get sourcing_rule_id');
217: raise NO_DATA_FOUND;
218: END IF;
219: CLOSE I1;
220:

Line 224: fnd_file.put_line(fnd_file.log, 'Creating sourcing rule. SOURCING_RULE_ID = '||x_sourcing_rule_id);

220:
221: -- Insert record into mpr_sourcing_rules
222:
223: x_progress := '100';
224: fnd_file.put_line(fnd_file.log, 'Creating sourcing rule. SOURCING_RULE_ID = '||x_sourcing_rule_id);
225: fnd_file.put_line(fnd_file.log, 'SOURCING_RULE_NAME = '||x_autosource_rule_name);
226:
227: INSERT INTO MRP_SOURCING_RULES(
228: sourcing_rule_id,

Line 225: fnd_file.put_line(fnd_file.log, 'SOURCING_RULE_NAME = '||x_autosource_rule_name);

221: -- Insert record into mpr_sourcing_rules
222:
223: x_progress := '100';
224: fnd_file.put_line(fnd_file.log, 'Creating sourcing rule. SOURCING_RULE_ID = '||x_sourcing_rule_id);
225: fnd_file.put_line(fnd_file.log, 'SOURCING_RULE_NAME = '||x_autosource_rule_name);
226:
227: INSERT INTO MRP_SOURCING_RULES(
228: sourcing_rule_id,
229: sourcing_rule_name,

Line 293: fnd_file.put_line(fnd_file.log, '** Cannot get sr_receipt_id');

289: OPEN I2;
290: FETCH I2 into x_sr_receipt_id;
291: IF (I2%NOTFOUND) THEN
292: close I2;
293: fnd_file.put_line(fnd_file.log, '** Cannot get sr_receipt_id');
294: raise NO_DATA_FOUND;
295: END IF;
296: CLOSE I2;
297:

Line 299: fnd_file.put_line(fnd_file.log, 'Upgrading autosource rule. AUTOSOURCE_RULE_ID = '||x_autosource_rule_id);

295: END IF;
296: CLOSE I2;
297:
298: x_progress := '110';
299: fnd_file.put_line(fnd_file.log, 'Upgrading autosource rule. AUTOSOURCE_RULE_ID = '||x_autosource_rule_id);
300:
301: INSERT INTO MRP_SR_RECEIPT_ORG(
302: sr_receipt_id,
303: sourcing_rule_id,

Line 372: fnd_file.put_line(fnd_file.log, '** Cannot get assignment id');

368: OPEN I3;
369: FETCH I3 into x_assignment_id;
370: IF (I3%NOTFOUND) THEN
371: close I3;
372: fnd_file.put_line(fnd_file.log, '** Cannot get assignment id');
373: raise NO_DATA_FOUND;
374: END IF;
375: CLOSE I3;
376:

Line 405: fnd_file.put_line(fnd_file.log, 'In the exception');

401: from mtl_system_items msi, mtl_parameters mtl
402: where msi.inventory_item_id = x_item_id
403: and msi.organization_id = mtl.master_organization_id
404: and msi.organization_id = mtl.organization_id;
405: fnd_file.put_line(fnd_file.log, 'In the exception');
406: end;
407:
408: x_progress := '150';
409: fnd_file.put_line(fnd_file.log, 'Assigning sourcing rule to item.');

Line 409: fnd_file.put_line(fnd_file.log, 'Assigning sourcing rule to item.');

405: fnd_file.put_line(fnd_file.log, 'In the exception');
406: end;
407:
408: x_progress := '150';
409: fnd_file.put_line(fnd_file.log, 'Assigning sourcing rule to item.');
410:
411: INSERT INTO MRP_SR_ASSIGNMENTS(
412: assignment_id,
413: assignment_type,

Line 459: fnd_file.put_line(fnd_file.log, '** Exception in upgrade_autosource_rules');

455:
456: EXCEPTION
457:
458: WHEN OTHERS THEN
459: fnd_file.put_line(fnd_file.log, '** Exception in upgrade_autosource_rules');
460: fnd_file.put_line(fnd_file.log, 'x_progress = '||x_progress);
461: PO_MESSAGE_S.SQL_ERROR('UPGRADE_SOURCING_RULES', x_progress, sqlcode);
462: END;
463:

Line 460: fnd_file.put_line(fnd_file.log, 'x_progress = '||x_progress);

456: EXCEPTION
457:
458: WHEN OTHERS THEN
459: fnd_file.put_line(fnd_file.log, '** Exception in upgrade_autosource_rules');
460: fnd_file.put_line(fnd_file.log, 'x_progress = '||x_progress);
461: PO_MESSAGE_S.SQL_ERROR('UPGRADE_SOURCING_RULES', x_progress, sqlcode);
462: END;
463:
464: END PO_ASL_UPGRADE_SV;