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

Line 11741: fnd_file.put_line(fnd_file.log,'Profile CSI_PROCESS_FULFILL_LINES is not set');

11737: --
11738: l_process_profile := fnd_profile.value('CSI_PROCESS_FULFILL_LINES');
11739: --
11740: if l_process_profile is null then
11741: fnd_file.put_line(fnd_file.log,'Profile CSI_PROCESS_FULFILL_LINES is not set');
11742: retcode := 2;
11743: RETURN;
11744: end if;
11745: --

Line 11747: fnd_file.put_line(fnd_file.log,'No more lines to be processed...');

11743: RETURN;
11744: end if;
11745: --
11746: if l_process_profile = 'N' then
11747: fnd_file.put_line(fnd_file.log,'No more lines to be processed...');
11748: RETURN;
11749: end if;
11750: --
11751: -- Get the Date from CSI_INSTALL_PARAMETERS

Line 11770: fnd_file.put_line(fnd_file.log, 'Multi Org Flag is '||l_multi_org_flag);

11766: Exception
11767: when others then
11768: null;
11769: End;
11770: fnd_file.put_line(fnd_file.log, 'Multi Org Flag is '||l_multi_org_flag);
11771: --
11772: fnd_file.put_line(fnd_file.log,'Processing Regular Queue..');
11773: WHILE(TRUE)
11774: LOOP

Line 11772: fnd_file.put_line(fnd_file.log,'Processing Regular Queue..');

11768: null;
11769: End;
11770: fnd_file.put_line(fnd_file.log, 'Multi Org Flag is '||l_multi_org_flag);
11771: --
11772: fnd_file.put_line(fnd_file.log,'Processing Regular Queue..');
11773: WHILE(TRUE)
11774: LOOP
11775: BEGIN
11776: l_line_count := 0;

Line 11817: fnd_file.put_line(fnd_file.log, 'Finished execution in failing to get queue message.');

11813: x_action_request_tbl => l_action_request_tbl);
11814: --
11815: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
11816: retcode := 2;
11817: fnd_file.put_line(fnd_file.log, 'Finished execution in failing to get queue message.');
11818: fnd_file.put_line(fnd_file.output, 'Process Old Order Lines Program finished with error. ');
11819: l_msg_index := 1;
11820: WHILE l_msg_count > 0
11821: LOOP

Line 11818: fnd_file.put_line(fnd_file.output, 'Process Old Order Lines Program finished with error. ');

11814: --
11815: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
11816: retcode := 2;
11817: fnd_file.put_line(fnd_file.log, 'Finished execution in failing to get queue message.');
11818: fnd_file.put_line(fnd_file.output, 'Process Old Order Lines Program finished with error. ');
11819: l_msg_index := 1;
11820: WHILE l_msg_count > 0
11821: LOOP
11822: l_msg_data := FND_MSG_PUB.GET( l_msg_index, FND_API.G_FALSE);

Line 11823: fnd_file.PUT_LINE(fnd_file.log, 'message data = '||l_msg_data);

11819: l_msg_index := 1;
11820: WHILE l_msg_count > 0
11821: LOOP
11822: l_msg_data := FND_MSG_PUB.GET( l_msg_index, FND_API.G_FALSE);
11823: fnd_file.PUT_LINE(fnd_file.log, 'message data = '||l_msg_data);
11824: l_msg_index := l_msg_index + 1;
11825: l_msg_count := l_msg_count - 1;
11826: END LOOP;
11827: ROLLBACK TO PROCESS_OLD_ORDER_LINES;

Line 11836: fnd_file.put_line(fnd_file.log, 'No line info found for this message.');

11832: --
11833: l_line_count := l_line_tbl.count;
11834:
11835: IF l_line_count <= 0 THEN
11836: fnd_file.put_line(fnd_file.log, 'No line info found for this message.');
11837: ELSE
11838: l_exp_count := 0;
11839: l_exp_flag := 'N';
11840: l_exp_line_tbl.delete;

Line 11847: fnd_file.put_line(fnd_file.log, 'Processing order line with id = '||l_order_line_id);

11843: FOR l_count IN 1..l_line_count
11844: Loop
11845: Begin
11846: l_order_line_id := to_char(l_line_tbl(l_count).line_id);
11847: fnd_file.put_line(fnd_file.log, 'Processing order line with id = '||l_order_line_id);
11848: -- We need to process the order lines which are fulfillable only.
11849: IF ( (WF_ENGINE.ACTIVITY_EXIST_IN_PROCESS(
11850: 'OEOL' -- ITEM_TYPE
11851: ,to_char(l_line_tbl(l_count).line_id) -- ITEM_KEY

Line 11856: fnd_file.put_line(fnd_file.log,'This Line has Shipping Node. Ignoring this line...');

11852: ,'OEOL' -- ACTIVITY_ITEM_TYPE
11853: ,'SHIP_LINE' -- ACTIVITY
11854: )) OR -- fix for Bug 2818157
11855: NVL(l_line_tbl(l_count).shippable_flag,'N') = 'Y') THEN
11856: fnd_file.put_line(fnd_file.log,'This Line has Shipping Node. Ignoring this line...');
11857: Raise Process_Next;
11858: END IF;
11859: -- Check Fulfillment Event
11860: IF ((l_line_tbl(l_count).fulfilled_quantity > 0) AND

Line 11867: fnd_file.put_line(fnd_file.log,'Line creation date is after moving to 11.5.6. Ignoring this Line...');

11863: --
11864: -- Check whether the line creation date is <= CSI Install Parameters Freeze date
11865: IF l_line_tbl(l_count).creation_date > l_freeze_date OR
11866: l_line_tbl(l_count).fulfillment_date < l_freeze_date THEN
11867: fnd_file.put_line(fnd_file.log,'Line creation date is after moving to 11.5.6. Ignoring this Line...');
11868: Raise Process_Next;
11869: END IF;
11870: --
11871: -- Get the Master Organization corresponding to the Order Line ORG ID.

Line 11888: fnd_file.put_line(fnd_file.log,'Unable to get Master Organization for ORG ID '

11884: where mp.organization_id = l_organization_id;
11885:
11886: Exception
11887: when others then
11888: fnd_file.put_line(fnd_file.log,'Unable to get Master Organization for ORG ID '
11889: ||to_char(l_line_tbl(l_count).org_id));
11890: l_exp_count := l_exp_count + 1;
11891: l_exp_flag := 'Y';
11892: l_exp_line_tbl(l_exp_count) := l_line_tbl(l_count);

Line 11909: fnd_file.put_line(fnd_file.log,'Unable to get Master Organization for ORG ID ');

11905: from MTL_PARAMETERS mp
11906: where mp.organization_id = l_organization_id;
11907: Exception
11908: when others then
11909: fnd_file.put_line(fnd_file.log,'Unable to get Master Organization for ORG ID ');
11910: l_exp_count := l_exp_count + 1;
11911: l_exp_flag := 'Y';
11912: l_exp_line_tbl(l_exp_count) := l_line_tbl(l_count);
11913: l_exp_old_line_tbl(l_exp_count) := l_old_line_tbl(l_count);

Line 11919: fnd_file.put_line(fnd_file.log,'Master organization is NULL for this Order Line');

11915: End;
11916: END IF;
11917: -- If Master Organization ID is NULL add the line to the Exception queue.
11918: IF l_organization_id is null THEN
11919: fnd_file.put_line(fnd_file.log,'Master organization is NULL for this Order Line');
11920: l_exp_count := l_exp_count + 1;
11921: l_exp_flag := 'Y';
11922: l_exp_line_tbl(l_exp_count) := l_line_tbl(l_count);
11923: l_exp_old_line_tbl(l_exp_count) := l_old_line_tbl(l_count);

Line 11931: fnd_file.put_line(fnd_file.log,'This Item is not NL Trackable. Ignoring this Line.');

11927: IF NOT (csi_item_instance_vld_pvt.is_trackable(
11928: p_inv_item_id => l_line_tbl(l_count).inventory_item_id,
11929: p_org_id => l_organization_id))
11930: THEN
11931: fnd_file.put_line(fnd_file.log,'This Item is not NL Trackable. Ignoring this Line.');
11932: Raise Process_Next;
11933: END IF;
11934: --
11935: -- All the above conditions are met and the line is eligible for processing.

Line 11936: fnd_file.put_line(fnd_file.log, 'This line has been fulfilled. Processing this line...');

11932: Raise Process_Next;
11933: END IF;
11934: --
11935: -- All the above conditions are met and the line is eligible for processing.
11936: fnd_file.put_line(fnd_file.log, 'This line has been fulfilled. Processing this line...');
11937: fulfill_old_line(
11938: p_order_line_id => l_line_tbl(l_count).line_id,
11939: x_return_status => l_return_status,
11940: x_error_message => l_error_message);

Line 11942: fnd_file.put_line(fnd_file.log,'Error while creating the Instance '

11938: p_order_line_id => l_line_tbl(l_count).line_id,
11939: x_return_status => l_return_status,
11940: x_error_message => l_error_message);
11941: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
11942: fnd_file.put_line(fnd_file.log,'Error while creating the Instance '
11943: ||'----'||l_error_message);
11944: fnd_file.put_line(fnd_file.log,'Please Use the Transaction Re-processing FORM to re-process this line..');
11945: Raise Process_Next;
11946: ELSE

Line 11944: fnd_file.put_line(fnd_file.log,'Please Use the Transaction Re-processing FORM to re-process this line..');

11940: x_error_message => l_error_message);
11941: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
11942: fnd_file.put_line(fnd_file.log,'Error while creating the Instance '
11943: ||'----'||l_error_message);
11944: fnd_file.put_line(fnd_file.log,'Please Use the Transaction Re-processing FORM to re-process this line..');
11945: Raise Process_Next;
11946: ELSE
11947: fnd_file.put_line(fnd_file.log,'Fulfillment API returned Success...');
11948: END IF;

Line 11947: fnd_file.put_line(fnd_file.log,'Fulfillment API returned Success...');

11943: ||'----'||l_error_message);
11944: fnd_file.put_line(fnd_file.log,'Please Use the Transaction Re-processing FORM to re-process this line..');
11945: Raise Process_Next;
11946: ELSE
11947: fnd_file.put_line(fnd_file.log,'Fulfillment API returned Success...');
11948: END IF;
11949: ELSE
11950: fnd_file.put_line(fnd_file.log, 'This line has not yet been fulfilled. Ignoring this line');
11951: END IF;

Line 11950: fnd_file.put_line(fnd_file.log, 'This line has not yet been fulfilled. Ignoring this line');

11946: ELSE
11947: fnd_file.put_line(fnd_file.log,'Fulfillment API returned Success...');
11948: END IF;
11949: ELSE
11950: fnd_file.put_line(fnd_file.log, 'This line has not yet been fulfilled. Ignoring this line');
11951: END IF;
11952: Exception
11953: When Process_Next then
11954: null;

Line 11964: fnd_file.put_line(fnd_file.log, 'adding message to exception queue...');

11960: END IF;
11961: END IF;
11962: EXCEPTION
11963: When ASO_HANDLE_NORMAL then
11964: fnd_file.put_line(fnd_file.log, 'adding message to exception queue...');
11965: ASO_ORDER_FEEDBACk_PUB.HANDLE_EXCEPTION(
11966: p_api_version => 1.0,
11967: p_init_msg_list => FND_API.G_FALSE,
11968: p_commit => FND_API.G_FALSE,

Line 12002: fnd_file.put_line(fnd_file.log, 'Finished processing one message in the Order Queue');

11998: p_old_Lot_Serial_tbl => l_old_Lot_Serial_tbl,
11999: p_action_request_tbl => l_action_request_tbl);
12000: END;
12001: COMMIT;
12002: fnd_file.put_line(fnd_file.log, 'Finished processing one message in the Order Queue');
12003: FND_MSG_PUB.initialize; -- reinit the error messages
12004: END LOOP;
12005: -- End of Processing Regular Queue
12006: fnd_file.put_line(fnd_file.log,'End of Regular Queue Processing ...');

Line 12006: fnd_file.put_line(fnd_file.log,'End of Regular Queue Processing ...');

12002: fnd_file.put_line(fnd_file.log, 'Finished processing one message in the Order Queue');
12003: FND_MSG_PUB.initialize; -- reinit the error messages
12004: END LOOP;
12005: -- End of Processing Regular Queue
12006: fnd_file.put_line(fnd_file.log,'End of Regular Queue Processing ...');
12007: fnd_file.put_line(fnd_file.log,'Processing Exception Queue..');
12008: WHILE(TRUE)
12009: LOOP
12010: BEGIN

Line 12007: fnd_file.put_line(fnd_file.log,'Processing Exception Queue..');

12003: FND_MSG_PUB.initialize; -- reinit the error messages
12004: END LOOP;
12005: -- End of Processing Regular Queue
12006: fnd_file.put_line(fnd_file.log,'End of Regular Queue Processing ...');
12007: fnd_file.put_line(fnd_file.log,'Processing Exception Queue..');
12008: WHILE(TRUE)
12009: LOOP
12010: BEGIN
12011: l_line_count := 0;

Line 12054: fnd_file.put_line(fnd_file.log, 'Finished execution in failing to get Exception queue message.');

12050: x_action_request_tbl => l_action_request_tbl);
12051: --
12052: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
12053: retcode := 2;
12054: fnd_file.put_line(fnd_file.log, 'Finished execution in failing to get Exception queue message.');
12055: fnd_file.put_line(fnd_file.output, 'Process Old Order Lines Program finished with error. ');
12056: l_msg_index := 1;
12057: WHILE l_msg_count > 0
12058: LOOP

Line 12055: fnd_file.put_line(fnd_file.output, 'Process Old Order Lines Program finished with error. ');

12051: --
12052: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
12053: retcode := 2;
12054: fnd_file.put_line(fnd_file.log, 'Finished execution in failing to get Exception queue message.');
12055: fnd_file.put_line(fnd_file.output, 'Process Old Order Lines Program finished with error. ');
12056: l_msg_index := 1;
12057: WHILE l_msg_count > 0
12058: LOOP
12059: l_msg_data := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);

Line 12060: fnd_file.PUT_LINE(fnd_file.log, 'message data = '||l_msg_data);

12056: l_msg_index := 1;
12057: WHILE l_msg_count > 0
12058: LOOP
12059: l_msg_data := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);
12060: fnd_file.PUT_LINE(fnd_file.log, 'message data = '||l_msg_data);
12061: l_msg_index := l_msg_index + 1;
12062: l_msg_count := l_msg_count - 1;
12063: END LOOP;
12064: ROLLBACK TO PROCESS_OLD_ORDER_LINES;

Line 12073: fnd_file.put_line(fnd_file.log, 'No line info found for this message.');

12069: --
12070: l_line_count := l_line_tbl.count;
12071:
12072: IF l_line_count <= 0 THEN
12073: fnd_file.put_line(fnd_file.log, 'No line info found for this message.');
12074: ELSE
12075: l_exp_count := 0;
12076: l_exp_flag := 'N';
12077: l_exp_line_tbl.delete;

Line 12084: fnd_file.put_line(fnd_file.log, 'Processing order line with id = '||l_order_line_id);

12080: FOR l_count IN 1..l_line_count
12081: Loop
12082: Begin
12083: l_order_line_id := to_char(l_line_tbl(l_count).line_id);
12084: fnd_file.put_line(fnd_file.log, 'Processing order line with id = '||l_order_line_id);
12085: -- We need to process the order lines which are fulfillable only.
12086: IF ( (WF_ENGINE.ACTIVITY_EXIST_IN_PROCESS(
12087: 'OEOL' -- ITEM_TYPE
12088: ,to_char(l_line_tbl(l_count).line_id) -- ITEM_KEY

Line 12093: fnd_file.put_line(fnd_file.log,'This Line has Shipping Node. Ignoring this line...');

12089: ,'OEOL' -- ACTIVITY_ITEM_TYPE
12090: ,'SHIP_LINE' -- ACTIVITY
12091: )) AND
12092: NVL(l_line_tbl(l_count).shippable_flag,'N') = 'Y') THEN
12093: fnd_file.put_line(fnd_file.log,'This Line has Shipping Node. Ignoring this line...');
12094: Raise Process_Next;
12095: END IF;
12096: -- Check Fulfillment Event
12097: IF ((l_line_tbl(l_count).fulfilled_quantity > 0) AND

Line 12103: fnd_file.put_line(fnd_file.log,'Line creation date is after moving to 11.5.6. Ignoring this Line..');

12099: NVL(l_old_line_tbl(l_count).fulfilled_quantity ,-1))) THEN
12100: --
12101: -- Check whether the line creation date is <= CSI Install Parameters Freeze date
12102: IF l_line_tbl(l_count).creation_date > l_freeze_date THEN
12103: fnd_file.put_line(fnd_file.log,'Line creation date is after moving to 11.5.6. Ignoring this Line..');
12104: Raise Process_Next;
12105: END IF;
12106: --
12107: -- Get the Master Organization corresponding to the Order Line ORG ID.

Line 12122: fnd_file.put_line(fnd_file.log,'Unable to get Master Organization for ORG ID '

12118: from MTL_PARAMETERS mp
12119: where mp.organization_id = l_organization_id;
12120: Exception
12121: when others then
12122: fnd_file.put_line(fnd_file.log,'Unable to get Master Organization for ORG ID '
12123: ||to_char(l_line_tbl(l_count).org_id));
12124: l_exp_count := l_exp_count + 1;
12125: l_exp_flag := 'Y';
12126: l_exp_line_tbl(l_exp_count) := l_line_tbl(l_count);

Line 12143: fnd_file.put_line(fnd_file.log,'Unable to get Master Organization for ORG ID ');

12139: from MTL_PARAMETERS mp
12140: where mp.organization_id = l_organization_id;
12141: Exception
12142: when others then
12143: fnd_file.put_line(fnd_file.log,'Unable to get Master Organization for ORG ID ');
12144: l_exp_count := l_exp_count + 1;
12145: l_exp_flag := 'Y';
12146: l_exp_line_tbl(l_exp_count) := l_line_tbl(l_count);
12147: l_exp_old_line_tbl(l_exp_count) := l_old_line_tbl(l_count);

Line 12153: fnd_file.put_line(fnd_file.log,'Master organization is NULL for this Order Line');

12149: End;
12150: END IF;
12151: -- If Master Organization ID is NULL add the line to the Exception queue.
12152: IF l_organization_id is null THEN
12153: fnd_file.put_line(fnd_file.log,'Master organization is NULL for this Order Line');
12154: l_exp_count := l_exp_count + 1;
12155: l_exp_flag := 'Y';
12156: l_exp_line_tbl(l_exp_count) := l_line_tbl(l_count);
12157: l_exp_old_line_tbl(l_exp_count) := l_old_line_tbl(l_count);

Line 12164: fnd_file.put_line(fnd_file.log,'This Line is not NL Trackable. Ignoring this Line.');

12160: -- Check if the item is NL Trackable or not
12161: IF NOT (csi_item_instance_vld_pvt.is_trackable(
12162: p_inv_item_id => l_line_tbl(l_count).inventory_item_id,
12163: p_org_id => l_organization_id)) THEN
12164: fnd_file.put_line(fnd_file.log,'This Line is not NL Trackable. Ignoring this Line.');
12165: Raise Process_Next;
12166: END IF;
12167: --
12168: -- All the above conditions are met and the line is eligible for processing.

Line 12169: fnd_file.put_line(fnd_file.log,'This line has been fulfilled. Processing this line..');

12165: Raise Process_Next;
12166: END IF;
12167: --
12168: -- All the above conditions are met and the line is eligible for processing.
12169: fnd_file.put_line(fnd_file.log,'This line has been fulfilled. Processing this line..');
12170: fulfill_old_line(
12171: p_order_line_id => l_line_tbl(l_count).line_id,
12172: x_return_status => l_return_status,
12173: x_error_message => l_error_message);

Line 12175: fnd_file.put_line(fnd_file.log,'Error while creating the Instance '

12171: p_order_line_id => l_line_tbl(l_count).line_id,
12172: x_return_status => l_return_status,
12173: x_error_message => l_error_message);
12174: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
12175: fnd_file.put_line(fnd_file.log,'Error while creating the Instance '
12176: ||'----'||l_error_message);
12177: fnd_file.put_line(fnd_file.log,'Please Use the Transaction Re-processing FORM to re-process this line..');
12178: Raise Process_Next;
12179: ELSE

Line 12177: fnd_file.put_line(fnd_file.log,'Please Use the Transaction Re-processing FORM to re-process this line..');

12173: x_error_message => l_error_message);
12174: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
12175: fnd_file.put_line(fnd_file.log,'Error while creating the Instance '
12176: ||'----'||l_error_message);
12177: fnd_file.put_line(fnd_file.log,'Please Use the Transaction Re-processing FORM to re-process this line..');
12178: Raise Process_Next;
12179: ELSE
12180: fnd_file.put_line(fnd_file.log,'Fulfillment API returned Success...');
12181: END IF;

Line 12180: fnd_file.put_line(fnd_file.log,'Fulfillment API returned Success...');

12176: ||'----'||l_error_message);
12177: fnd_file.put_line(fnd_file.log,'Please Use the Transaction Re-processing FORM to re-process this line..');
12178: Raise Process_Next;
12179: ELSE
12180: fnd_file.put_line(fnd_file.log,'Fulfillment API returned Success...');
12181: END IF;
12182: ELSE
12183: fnd_file.put_line(fnd_file.log, 'This line has not yet been fulfilled. Ignoring this line');
12184: END IF;

Line 12183: fnd_file.put_line(fnd_file.log, 'This line has not yet been fulfilled. Ignoring this line');

12179: ELSE
12180: fnd_file.put_line(fnd_file.log,'Fulfillment API returned Success...');
12181: END IF;
12182: ELSE
12183: fnd_file.put_line(fnd_file.log, 'This line has not yet been fulfilled. Ignoring this line');
12184: END IF;
12185: Exception
12186: When Process_Next then
12187: null;

Line 12197: fnd_file.put_line(fnd_file.log, 'Adding message to exception queue again ...');

12193: END IF;
12194: END IF;
12195: EXCEPTION
12196: When ASO_HANDLE_EXCEPTION then
12197: fnd_file.put_line(fnd_file.log, 'Adding message to exception queue again ...');
12198: ASO_ORDER_FEEDBACk_PUB.HANDLE_EXCEPTION (
12199: p_api_version => 1.0,
12200: p_init_msg_list => FND_API.G_FALSE,
12201: p_commit => FND_API.G_FALSE,

Line 12235: fnd_file.put_line(fnd_file.log, 'Finished processing one message in the Order Exception Queue');

12231: p_old_Lot_Serial_tbl => l_old_Lot_Serial_tbl,
12232: p_action_request_tbl => l_action_request_tbl);
12233: END;
12234: COMMIT;
12235: fnd_file.put_line(fnd_file.log, 'Finished processing one message in the Order Exception Queue');
12236: FND_MSG_PUB.initialize; -- reinit the error messages
12237: END LOOP;
12238: fnd_file.put_line(fnd_file.log,'End of Exception Queue Processing ...');
12239: END Process_old_order_Lines;

Line 12238: fnd_file.put_line(fnd_file.log,'End of Exception Queue Processing ...');

12234: COMMIT;
12235: fnd_file.put_line(fnd_file.log, 'Finished processing one message in the Order Exception Queue');
12236: FND_MSG_PUB.initialize; -- reinit the error messages
12237: END LOOP;
12238: fnd_file.put_line(fnd_file.log,'End of Exception Queue Processing ...');
12239: END Process_old_order_Lines;
12240:
12241: --
12242: /************************************************************************************

Line 12281: fnd_file.put_line(fnd_file.log,'Unable to find the Profile Option CSI_PROCESS_FULFILL_LINES');

12277: from FND_PROFILE_OPTIONS
12278: where upper(profile_option_name) = 'CSI_PROCESS_FULFILL_LINES';
12279: Exception
12280: when no_data_found then
12281: fnd_file.put_line(fnd_file.log,'Unable to find the Profile Option CSI_PROCESS_FULFILL_LINES');
12282: retcode := 2;
12283: RETURN;
12284: End;
12285:

Line 12304: fnd_file.put_line(fnd_file.log, 'Multi Org Flag is '||l_multi_org_flag);

12300: when others then
12301: null;
12302: End;
12303: --
12304: fnd_file.put_line(fnd_file.log, 'Multi Org Flag is '||l_multi_org_flag);
12305: --
12306: For v_rec in OE_LINE_CUR(l_freeze_date)
12307: Loop
12308: Begin

Line 12334: fnd_file.put_line(fnd_file.log,'Unable to get Master Organization for ORG ID '

12330: from MTL_PARAMETERS mp
12331: where mp.organization_id = l_organization_id;
12332: Exception
12333: when others then
12334: fnd_file.put_line(fnd_file.log,'Unable to get Master Organization for ORG ID '
12335: ||to_char(v_rec.org_id));
12336: Raise Process_Next;
12337: End;
12338: ELSE -- Non Multi-Org

Line 12351: fnd_file.put_line(fnd_file.log,'Unable to get Master Organization for ORG ID ');

12347: from MTL_PARAMETERS mp
12348: where mp.organization_id = l_organization_id;
12349: Exception
12350: when others then
12351: fnd_file.put_line(fnd_file.log,'Unable to get Master Organization for ORG ID ');
12352: Raise Process_Next;
12353: End;
12354: END IF;
12355: -- Check if the item is NL Trackable or not

Line 12362: fnd_file.put_line(fnd_file.log,'There are still open fulfillable lines...');

12358: p_org_id => l_organization_id)) THEN
12359: Raise Process_Next;
12360: END IF;
12361: v_ret_counter := 1;
12362: fnd_file.put_line(fnd_file.log,'There are still open fulfillable lines...');
12363: exit;
12364: Exception
12365: when Process_Next then
12366: null;

Line 12370: fnd_file.put_line(fnd_file.log,'All Old Fulfillable lines have been Processed. Updating the Profile');

12366: null;
12367: End;
12368: End Loop;
12369: if v_ret_counter = 0 then
12370: fnd_file.put_line(fnd_file.log,'All Old Fulfillable lines have been Processed. Updating the Profile');
12371: -- update the profile
12372: UPDATE fnd_profile_option_values
12373: SET profile_option_value = 'N'
12374: WHERE profile_option_id = l_profile_option_id