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 10725: fnd_file.put_line(fnd_file.log,'Profile CSI_PROCESS_FULFILL_LINES is not set');

10721: --
10722: l_process_profile := fnd_profile.value('CSI_PROCESS_FULFILL_LINES');
10723: --
10724: if l_process_profile is null then
10725: fnd_file.put_line(fnd_file.log,'Profile CSI_PROCESS_FULFILL_LINES is not set');
10726: retcode := 2;
10727: RETURN;
10728: end if;
10729: --

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

10727: RETURN;
10728: end if;
10729: --
10730: if l_process_profile = 'N' then
10731: fnd_file.put_line(fnd_file.log,'No more lines to be processed...');
10732: RETURN;
10733: end if;
10734: --
10735: -- Get the Date from CSI_INSTALL_PARAMETERS

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

10750: Exception
10751: when others then
10752: null;
10753: End;
10754: fnd_file.put_line(fnd_file.log, 'Multi Org Flag is '||l_multi_org_flag);
10755: --
10756: fnd_file.put_line(fnd_file.log,'Processing Regular Queue..');
10757: WHILE(TRUE)
10758: LOOP

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

10752: null;
10753: End;
10754: fnd_file.put_line(fnd_file.log, 'Multi Org Flag is '||l_multi_org_flag);
10755: --
10756: fnd_file.put_line(fnd_file.log,'Processing Regular Queue..');
10757: WHILE(TRUE)
10758: LOOP
10759: BEGIN
10760: l_line_count := 0;

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

10797: x_action_request_tbl => l_action_request_tbl);
10798: --
10799: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
10800: retcode := 2;
10801: fnd_file.put_line(fnd_file.log, 'Finished execution in failing to get queue message.');
10802: fnd_file.put_line(fnd_file.output, 'Process Old Order Lines Program finished with error. ');
10803: l_msg_index := 1;
10804: WHILE l_msg_count > 0
10805: LOOP

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

10798: --
10799: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
10800: retcode := 2;
10801: fnd_file.put_line(fnd_file.log, 'Finished execution in failing to get queue message.');
10802: fnd_file.put_line(fnd_file.output, 'Process Old Order Lines Program finished with error. ');
10803: l_msg_index := 1;
10804: WHILE l_msg_count > 0
10805: LOOP
10806: l_msg_data := FND_MSG_PUB.GET( l_msg_index, FND_API.G_FALSE);

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

10803: l_msg_index := 1;
10804: WHILE l_msg_count > 0
10805: LOOP
10806: l_msg_data := FND_MSG_PUB.GET( l_msg_index, FND_API.G_FALSE);
10807: fnd_file.PUT_LINE(fnd_file.log, 'message data = '||l_msg_data);
10808: l_msg_index := l_msg_index + 1;
10809: l_msg_count := l_msg_count - 1;
10810: END LOOP;
10811: ROLLBACK TO PROCESS_OLD_ORDER_LINES;

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

10816: --
10817: l_line_count := l_line_tbl.count;
10818:
10819: IF l_line_count <= 0 THEN
10820: fnd_file.put_line(fnd_file.log, 'No line info found for this message.');
10821: ELSE
10822: l_exp_count := 0;
10823: l_exp_flag := 'N';
10824: l_exp_line_tbl.delete;

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

10827: FOR l_count IN 1..l_line_count
10828: Loop
10829: Begin
10830: l_order_line_id := to_char(l_line_tbl(l_count).line_id);
10831: fnd_file.put_line(fnd_file.log, 'Processing order line with id = '||l_order_line_id);
10832: -- We need to process the order lines which are fulfillable only.
10833: IF ( (WF_ENGINE.ACTIVITY_EXIST_IN_PROCESS(
10834: 'OEOL' -- ITEM_TYPE
10835: ,to_char(l_line_tbl(l_count).line_id) -- ITEM_KEY

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

10836: ,'OEOL' -- ACTIVITY_ITEM_TYPE
10837: ,'SHIP_LINE' -- ACTIVITY
10838: )) OR -- fix for Bug 2818157
10839: NVL(l_line_tbl(l_count).shippable_flag,'N') = 'Y') THEN
10840: fnd_file.put_line(fnd_file.log,'This Line has Shipping Node. Ignoring this line...');
10841: Raise Process_Next;
10842: END IF;
10843: -- Check Fulfillment Event
10844: IF ((l_line_tbl(l_count).fulfilled_quantity > 0) AND

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

10847: --
10848: -- Check whether the line creation date is <= CSI Install Parameters Freeze date
10849: IF l_line_tbl(l_count).creation_date > l_freeze_date OR
10850: l_line_tbl(l_count).fulfillment_date < l_freeze_date THEN
10851: fnd_file.put_line(fnd_file.log,'Line creation date is after moving to 11.5.6. Ignoring this Line...');
10852: Raise Process_Next;
10853: END IF;
10854: --
10855: -- Get the Master Organization corresponding to the Order Line ORG ID.

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

10868: where mp.organization_id = l_organization_id;
10869:
10870: Exception
10871: when others then
10872: fnd_file.put_line(fnd_file.log,'Unable to get Master Organization for ORG ID '
10873: ||to_char(l_line_tbl(l_count).org_id));
10874: l_exp_count := l_exp_count + 1;
10875: l_exp_flag := 'Y';
10876: l_exp_line_tbl(l_exp_count) := l_line_tbl(l_count);

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

10889: from MTL_PARAMETERS mp
10890: where mp.organization_id = l_organization_id;
10891: Exception
10892: when others then
10893: fnd_file.put_line(fnd_file.log,'Unable to get Master Organization for ORG ID ');
10894: l_exp_count := l_exp_count + 1;
10895: l_exp_flag := 'Y';
10896: l_exp_line_tbl(l_exp_count) := l_line_tbl(l_count);
10897: l_exp_old_line_tbl(l_exp_count) := l_old_line_tbl(l_count);

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

10899: End;
10900: END IF;
10901: -- If Master Organization ID is NULL add the line to the Exception queue.
10902: IF l_organization_id is null THEN
10903: fnd_file.put_line(fnd_file.log,'Master organization is NULL for this Order Line');
10904: l_exp_count := l_exp_count + 1;
10905: l_exp_flag := 'Y';
10906: l_exp_line_tbl(l_exp_count) := l_line_tbl(l_count);
10907: l_exp_old_line_tbl(l_exp_count) := l_old_line_tbl(l_count);

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

10911: IF NOT (csi_item_instance_vld_pvt.is_trackable(
10912: p_inv_item_id => l_line_tbl(l_count).inventory_item_id,
10913: p_org_id => l_organization_id))
10914: THEN
10915: fnd_file.put_line(fnd_file.log,'This Item is not NL Trackable. Ignoring this Line.');
10916: Raise Process_Next;
10917: END IF;
10918: --
10919: -- All the above conditions are met and the line is eligible for processing.

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

10916: Raise Process_Next;
10917: END IF;
10918: --
10919: -- All the above conditions are met and the line is eligible for processing.
10920: fnd_file.put_line(fnd_file.log, 'This line has been fulfilled. Processing this line...');
10921: fulfill_old_line(
10922: p_order_line_id => l_line_tbl(l_count).line_id,
10923: x_return_status => l_return_status,
10924: x_error_message => l_error_message);

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

10922: p_order_line_id => l_line_tbl(l_count).line_id,
10923: x_return_status => l_return_status,
10924: x_error_message => l_error_message);
10925: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
10926: fnd_file.put_line(fnd_file.log,'Error while creating the Instance '
10927: ||'----'||l_error_message);
10928: fnd_file.put_line(fnd_file.log,'Please Use the Transaction Re-processing FORM to re-process this line..');
10929: Raise Process_Next;
10930: ELSE

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

10924: x_error_message => l_error_message);
10925: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
10926: fnd_file.put_line(fnd_file.log,'Error while creating the Instance '
10927: ||'----'||l_error_message);
10928: fnd_file.put_line(fnd_file.log,'Please Use the Transaction Re-processing FORM to re-process this line..');
10929: Raise Process_Next;
10930: ELSE
10931: fnd_file.put_line(fnd_file.log,'Fulfillment API returned Success...');
10932: END IF;

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

10927: ||'----'||l_error_message);
10928: fnd_file.put_line(fnd_file.log,'Please Use the Transaction Re-processing FORM to re-process this line..');
10929: Raise Process_Next;
10930: ELSE
10931: fnd_file.put_line(fnd_file.log,'Fulfillment API returned Success...');
10932: END IF;
10933: ELSE
10934: fnd_file.put_line(fnd_file.log, 'This line has not yet been fulfilled. Ignoring this line');
10935: END IF;

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

10930: ELSE
10931: fnd_file.put_line(fnd_file.log,'Fulfillment API returned Success...');
10932: END IF;
10933: ELSE
10934: fnd_file.put_line(fnd_file.log, 'This line has not yet been fulfilled. Ignoring this line');
10935: END IF;
10936: Exception
10937: When Process_Next then
10938: null;

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

10944: END IF;
10945: END IF;
10946: EXCEPTION
10947: When ASO_HANDLE_NORMAL then
10948: fnd_file.put_line(fnd_file.log, 'adding message to exception queue...');
10949: ASO_ORDER_FEEDBACk_PUB.HANDLE_EXCEPTION(
10950: p_api_version => 1.0,
10951: p_init_msg_list => FND_API.G_FALSE,
10952: p_commit => FND_API.G_FALSE,

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

10982: p_old_Lot_Serial_tbl => l_old_Lot_Serial_tbl,
10983: p_action_request_tbl => l_action_request_tbl);
10984: END;
10985: COMMIT;
10986: fnd_file.put_line(fnd_file.log, 'Finished processing one message in the Order Queue');
10987: FND_MSG_PUB.initialize; -- reinit the error messages
10988: END LOOP;
10989: -- End of Processing Regular Queue
10990: fnd_file.put_line(fnd_file.log,'End of Regular Queue Processing ...');

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

10986: fnd_file.put_line(fnd_file.log, 'Finished processing one message in the Order Queue');
10987: FND_MSG_PUB.initialize; -- reinit the error messages
10988: END LOOP;
10989: -- End of Processing Regular Queue
10990: fnd_file.put_line(fnd_file.log,'End of Regular Queue Processing ...');
10991: fnd_file.put_line(fnd_file.log,'Processing Exception Queue..');
10992: WHILE(TRUE)
10993: LOOP
10994: BEGIN

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

10987: FND_MSG_PUB.initialize; -- reinit the error messages
10988: END LOOP;
10989: -- End of Processing Regular Queue
10990: fnd_file.put_line(fnd_file.log,'End of Regular Queue Processing ...');
10991: fnd_file.put_line(fnd_file.log,'Processing Exception Queue..');
10992: WHILE(TRUE)
10993: LOOP
10994: BEGIN
10995: l_line_count := 0;

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

11034: x_action_request_tbl => l_action_request_tbl);
11035: --
11036: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
11037: retcode := 2;
11038: fnd_file.put_line(fnd_file.log, 'Finished execution in failing to get Exception queue message.');
11039: fnd_file.put_line(fnd_file.output, 'Process Old Order Lines Program finished with error. ');
11040: l_msg_index := 1;
11041: WHILE l_msg_count > 0
11042: LOOP

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

11035: --
11036: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
11037: retcode := 2;
11038: fnd_file.put_line(fnd_file.log, 'Finished execution in failing to get Exception queue message.');
11039: fnd_file.put_line(fnd_file.output, 'Process Old Order Lines Program finished with error. ');
11040: l_msg_index := 1;
11041: WHILE l_msg_count > 0
11042: LOOP
11043: l_msg_data := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);

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

11040: l_msg_index := 1;
11041: WHILE l_msg_count > 0
11042: LOOP
11043: l_msg_data := FND_MSG_PUB.GET(l_msg_index, FND_API.G_FALSE);
11044: fnd_file.PUT_LINE(fnd_file.log, 'message data = '||l_msg_data);
11045: l_msg_index := l_msg_index + 1;
11046: l_msg_count := l_msg_count - 1;
11047: END LOOP;
11048: ROLLBACK TO PROCESS_OLD_ORDER_LINES;

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

11053: --
11054: l_line_count := l_line_tbl.count;
11055:
11056: IF l_line_count <= 0 THEN
11057: fnd_file.put_line(fnd_file.log, 'No line info found for this message.');
11058: ELSE
11059: l_exp_count := 0;
11060: l_exp_flag := 'N';
11061: l_exp_line_tbl.delete;

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

11064: FOR l_count IN 1..l_line_count
11065: Loop
11066: Begin
11067: l_order_line_id := to_char(l_line_tbl(l_count).line_id);
11068: fnd_file.put_line(fnd_file.log, 'Processing order line with id = '||l_order_line_id);
11069: -- We need to process the order lines which are fulfillable only.
11070: IF ( (WF_ENGINE.ACTIVITY_EXIST_IN_PROCESS(
11071: 'OEOL' -- ITEM_TYPE
11072: ,to_char(l_line_tbl(l_count).line_id) -- ITEM_KEY

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

11073: ,'OEOL' -- ACTIVITY_ITEM_TYPE
11074: ,'SHIP_LINE' -- ACTIVITY
11075: )) AND
11076: NVL(l_line_tbl(l_count).shippable_flag,'N') = 'Y') THEN
11077: fnd_file.put_line(fnd_file.log,'This Line has Shipping Node. Ignoring this line...');
11078: Raise Process_Next;
11079: END IF;
11080: -- Check Fulfillment Event
11081: IF ((l_line_tbl(l_count).fulfilled_quantity > 0) AND

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

11083: NVL(l_old_line_tbl(l_count).fulfilled_quantity ,-1))) THEN
11084: --
11085: -- Check whether the line creation date is <= CSI Install Parameters Freeze date
11086: IF l_line_tbl(l_count).creation_date > l_freeze_date THEN
11087: fnd_file.put_line(fnd_file.log,'Line creation date is after moving to 11.5.6. Ignoring this Line..');
11088: Raise Process_Next;
11089: END IF;
11090: --
11091: -- Get the Master Organization corresponding to the Order Line ORG ID.

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

11102: from MTL_PARAMETERS mp
11103: where mp.organization_id = l_organization_id;
11104: Exception
11105: when others then
11106: fnd_file.put_line(fnd_file.log,'Unable to get Master Organization for ORG ID '
11107: ||to_char(l_line_tbl(l_count).org_id));
11108: l_exp_count := l_exp_count + 1;
11109: l_exp_flag := 'Y';
11110: l_exp_line_tbl(l_exp_count) := l_line_tbl(l_count);

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

11123: from MTL_PARAMETERS mp
11124: where mp.organization_id = l_organization_id;
11125: Exception
11126: when others then
11127: fnd_file.put_line(fnd_file.log,'Unable to get Master Organization for ORG ID ');
11128: l_exp_count := l_exp_count + 1;
11129: l_exp_flag := 'Y';
11130: l_exp_line_tbl(l_exp_count) := l_line_tbl(l_count);
11131: l_exp_old_line_tbl(l_exp_count) := l_old_line_tbl(l_count);

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

11133: End;
11134: END IF;
11135: -- If Master Organization ID is NULL add the line to the Exception queue.
11136: IF l_organization_id is null THEN
11137: fnd_file.put_line(fnd_file.log,'Master organization is NULL for this Order Line');
11138: l_exp_count := l_exp_count + 1;
11139: l_exp_flag := 'Y';
11140: l_exp_line_tbl(l_exp_count) := l_line_tbl(l_count);
11141: l_exp_old_line_tbl(l_exp_count) := l_old_line_tbl(l_count);

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

11144: -- Check if the item is NL Trackable or not
11145: IF NOT (csi_item_instance_vld_pvt.is_trackable(
11146: p_inv_item_id => l_line_tbl(l_count).inventory_item_id,
11147: p_org_id => l_organization_id)) THEN
11148: fnd_file.put_line(fnd_file.log,'This Line is not NL Trackable. Ignoring this Line.');
11149: Raise Process_Next;
11150: END IF;
11151: --
11152: -- All the above conditions are met and the line is eligible for processing.

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

11149: Raise Process_Next;
11150: END IF;
11151: --
11152: -- All the above conditions are met and the line is eligible for processing.
11153: fnd_file.put_line(fnd_file.log,'This line has been fulfilled. Processing this line..');
11154: fulfill_old_line(
11155: p_order_line_id => l_line_tbl(l_count).line_id,
11156: x_return_status => l_return_status,
11157: x_error_message => l_error_message);

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

11155: p_order_line_id => l_line_tbl(l_count).line_id,
11156: x_return_status => l_return_status,
11157: x_error_message => l_error_message);
11158: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
11159: fnd_file.put_line(fnd_file.log,'Error while creating the Instance '
11160: ||'----'||l_error_message);
11161: fnd_file.put_line(fnd_file.log,'Please Use the Transaction Re-processing FORM to re-process this line..');
11162: Raise Process_Next;
11163: ELSE

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

11157: x_error_message => l_error_message);
11158: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
11159: fnd_file.put_line(fnd_file.log,'Error while creating the Instance '
11160: ||'----'||l_error_message);
11161: fnd_file.put_line(fnd_file.log,'Please Use the Transaction Re-processing FORM to re-process this line..');
11162: Raise Process_Next;
11163: ELSE
11164: fnd_file.put_line(fnd_file.log,'Fulfillment API returned Success...');
11165: END IF;

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

11160: ||'----'||l_error_message);
11161: fnd_file.put_line(fnd_file.log,'Please Use the Transaction Re-processing FORM to re-process this line..');
11162: Raise Process_Next;
11163: ELSE
11164: fnd_file.put_line(fnd_file.log,'Fulfillment API returned Success...');
11165: END IF;
11166: ELSE
11167: fnd_file.put_line(fnd_file.log, 'This line has not yet been fulfilled. Ignoring this line');
11168: END IF;

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

11163: ELSE
11164: fnd_file.put_line(fnd_file.log,'Fulfillment API returned Success...');
11165: END IF;
11166: ELSE
11167: fnd_file.put_line(fnd_file.log, 'This line has not yet been fulfilled. Ignoring this line');
11168: END IF;
11169: Exception
11170: When Process_Next then
11171: null;

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

11177: END IF;
11178: END IF;
11179: EXCEPTION
11180: When ASO_HANDLE_EXCEPTION then
11181: fnd_file.put_line(fnd_file.log, 'Adding message to exception queue again ...');
11182: ASO_ORDER_FEEDBACk_PUB.HANDLE_EXCEPTION (
11183: p_api_version => 1.0,
11184: p_init_msg_list => FND_API.G_FALSE,
11185: p_commit => FND_API.G_FALSE,

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

11215: p_old_Lot_Serial_tbl => l_old_Lot_Serial_tbl,
11216: p_action_request_tbl => l_action_request_tbl);
11217: END;
11218: COMMIT;
11219: fnd_file.put_line(fnd_file.log, 'Finished processing one message in the Order Exception Queue');
11220: FND_MSG_PUB.initialize; -- reinit the error messages
11221: END LOOP;
11222: fnd_file.put_line(fnd_file.log,'End of Exception Queue Processing ...');
11223: END Process_old_order_Lines;

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

11218: COMMIT;
11219: fnd_file.put_line(fnd_file.log, 'Finished processing one message in the Order Exception Queue');
11220: FND_MSG_PUB.initialize; -- reinit the error messages
11221: END LOOP;
11222: fnd_file.put_line(fnd_file.log,'End of Exception Queue Processing ...');
11223: END Process_old_order_Lines;
11224:
11225: --
11226: /************************************************************************************

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

11261: from FND_PROFILE_OPTIONS
11262: where upper(profile_option_name) = 'CSI_PROCESS_FULFILL_LINES';
11263: Exception
11264: when no_data_found then
11265: fnd_file.put_line(fnd_file.log,'Unable to find the Profile Option CSI_PROCESS_FULFILL_LINES');
11266: retcode := 2;
11267: RETURN;
11268: End;
11269:

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

11284: when others then
11285: null;
11286: End;
11287: --
11288: fnd_file.put_line(fnd_file.log, 'Multi Org Flag is '||l_multi_org_flag);
11289: --
11290: For v_rec in OE_LINE_CUR(l_freeze_date)
11291: Loop
11292: Begin

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

11314: from MTL_PARAMETERS mp
11315: where mp.organization_id = l_organization_id;
11316: Exception
11317: when others then
11318: fnd_file.put_line(fnd_file.log,'Unable to get Master Organization for ORG ID '
11319: ||to_char(v_rec.org_id));
11320: Raise Process_Next;
11321: End;
11322: ELSE -- Non Multi-Org

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

11331: from MTL_PARAMETERS mp
11332: where mp.organization_id = l_organization_id;
11333: Exception
11334: when others then
11335: fnd_file.put_line(fnd_file.log,'Unable to get Master Organization for ORG ID ');
11336: Raise Process_Next;
11337: End;
11338: END IF;
11339: -- Check if the item is NL Trackable or not

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

11342: p_org_id => l_organization_id)) THEN
11343: Raise Process_Next;
11344: END IF;
11345: v_ret_counter := 1;
11346: fnd_file.put_line(fnd_file.log,'There are still open fulfillable lines...');
11347: exit;
11348: Exception
11349: when Process_Next then
11350: null;

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

11350: null;
11351: End;
11352: End Loop;
11353: if v_ret_counter = 0 then
11354: fnd_file.put_line(fnd_file.log,'All Old Fulfillable lines have been Processed. Updating the Profile');
11355: -- update the profile
11356: UPDATE fnd_profile_option_values
11357: SET profile_option_value = 'N'
11358: WHERE profile_option_id = l_profile_option_id