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

Line 747: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No Bucket');

743: Fetch C_Get_Bucket into l_bucket;
744: If ( C_GET_Bucket%NOTFOUND ) Then
745: -- Changed by gnramasa for bug 5661324 14-Mar-07
746: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - NO Bucket');
747: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No Bucket');
748: x_return_status := FND_API.G_RET_STS_ERROR;
749: RAISE FND_API.G_EXC_ERROR;
750: end if;
751: CLOSE C_GET_Bucket;

Line 754: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Current Bucket='||l_bucket);

750: end if;
751: CLOSE C_GET_Bucket;
752: -- Changed by gnramasa for bug 5661324 14-Mar-07
753: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Bucket='||l_bucket);
754: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Current Bucket='||l_bucket);
755: end if;
756:
757: --
758: -- added by gnramasa for bug 5661324 14-Mar-07

Line 764: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No filter object');

760: Open c_filter_object (p_dunning_plan_id);
761: Fetch c_filter_object into l_select_column,l_entity_name;
762: If ( c_filter_object%NOTFOUND ) Then
763: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - NO filter object');
764: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No filter object');
765: x_return_status := FND_API.G_RET_STS_ERROR;
766: RAISE FND_API.G_EXC_ERROR;
767: end if;
768: CLOSE c_filter_object;

Line 771: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_select_column: '|| l_select_column);

767: end if;
768: CLOSE c_filter_object;
769: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_select_column: '|| l_select_column);
770: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_entity_name: '||l_entity_name);
771: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_select_column: '|| l_select_column);
772: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_entity_name: '||l_entity_name);
773:
774: if (p_customer_name_low IS NOT NULL OR p_customer_name_high IS NOT NULL OR p_account_number_low IS NOT NULL OR
775: p_account_number_high IS NOT NULL OR p_billto_location_low IS NOT NULL OR p_billto_location_high IS NOT NULL) then

Line 772: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_entity_name: '||l_entity_name);

768: CLOSE c_filter_object;
769: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_select_column: '|| l_select_column);
770: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_entity_name: '||l_entity_name);
771: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_select_column: '|| l_select_column);
772: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_entity_name: '||l_entity_name);
773:
774: if (p_customer_name_low IS NOT NULL OR p_customer_name_high IS NOT NULL OR p_account_number_low IS NOT NULL OR
775: p_account_number_high IS NOT NULL OR p_billto_location_low IS NOT NULL OR p_billto_location_high IS NOT NULL) then
776: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' Calling custom_where_clause ');

Line 851: FND_FILE.PUT_LINE(FND_FILE.LOG, 'acct_query--> '||vPLSQL2);

847: end if;
848: --End Bug 11656175 01-Mar-2011 barathsr
849: vPLSQL2 := vPLSQL2 || ' order by Display_Order ';
850:
851: FND_FILE.PUT_LINE(FND_FILE.LOG, 'acct_query--> '||vPLSQL2);
852:
853: elsif p_running_level = 'BILL_TO' then
854: vSelectColumn := 'customer_site_use_id';
855: vPLSQL2 := ' select ' ||

Line 886: FND_FILE.PUT_LINE(FND_FILE.LOG, 'acct_query--> '||vPLSQL2);

882: end if;
883: --End Bug 11656175 01-Mar-2011 barathsr
884: vPLSQL2 := vPLSQL2 || ' order by Display_Order ';
885:
886: FND_FILE.PUT_LINE(FND_FILE.LOG, 'acct_query--> '||vPLSQL2);
887:
888: else -- we are running at delinquency level
889: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Delinquency Level - after fix 14797202..');
890: vSelectColumn := 'delinquency_id';

Line 927: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Delinquency level acct_query--> : vPLSQL2 = '||vPLSQL2); -- bug 14797201

923: ' and prof.site_use_id = del.customer_site_use_id and prof.dunning_letter_set_id = '||l_dunning_letter_set_id||')';
924: end if;
925: --End Bug 11656175 01-Mar-2011 barathsr
926: --'ORDER BY ' || vSelectColumn || ' ,delinquency_id';
927: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Delinquency level acct_query--> : vPLSQL2 = '||vPLSQL2); -- bug 14797201
928: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Delinquency level acct_query : vPLSQL2 = ' || vPLSQL2); -- bug 14797201
929: end if;
930:
931: -- Begin Bills Receivables

Line 986: FND_FILE.PUT_LINE(FND_FILE.LOG, 'acct_query--> '||vPLSQL);

982: ' and d.object_type <> ''IEX_INVOICES'' )';
983: end if;
984:
985: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - vPLSQL ' || vPLSQL);
986: FND_FILE.PUT_LINE(FND_FILE.LOG, 'acct_query--> '||vPLSQL);
987: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - vPLSQL2 ' || vPLSQL2);
988: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - open Cursor');
989:
990: if p_parent_request_id is null then

Line 1131: FND_FILE.PUT_LINE(FND_FILE.LOG,'Validate correct scoring engine was run for this dunning plan.');

1127: WriteLog('get scoring engine');
1128: open c_scoring_engine(p_dunning_plan_id);
1129: fetch c_scoring_engine into l_score_engine_id, l_score_engine_name;
1130: close c_scoring_engine;
1131: FND_FILE.PUT_LINE(FND_FILE.LOG,'Validate correct scoring engine was run for this dunning plan.');
1132: FND_FILE.PUT_LINE(FND_FILE.LOG,'Scoring Engine Name: ' || l_score_engine_name);
1133: FND_FILE.PUT_LINE(FND_FILE.LOG,'Scoring Engine ID: ' || l_score_engine_id);
1134: l_repeat := false;
1135: else

Line 1132: FND_FILE.PUT_LINE(FND_FILE.LOG,'Scoring Engine Name: ' || l_score_engine_name);

1128: open c_scoring_engine(p_dunning_plan_id);
1129: fetch c_scoring_engine into l_score_engine_id, l_score_engine_name;
1130: close c_scoring_engine;
1131: FND_FILE.PUT_LINE(FND_FILE.LOG,'Validate correct scoring engine was run for this dunning plan.');
1132: FND_FILE.PUT_LINE(FND_FILE.LOG,'Scoring Engine Name: ' || l_score_engine_name);
1133: FND_FILE.PUT_LINE(FND_FILE.LOG,'Scoring Engine ID: ' || l_score_engine_id);
1134: l_repeat := false;
1135: else
1136: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1133: FND_FILE.PUT_LINE(FND_FILE.LOG,'Scoring Engine ID: ' || l_score_engine_id);

1129: fetch c_scoring_engine into l_score_engine_id, l_score_engine_name;
1130: close c_scoring_engine;
1131: FND_FILE.PUT_LINE(FND_FILE.LOG,'Validate correct scoring engine was run for this dunning plan.');
1132: FND_FILE.PUT_LINE(FND_FILE.LOG,'Scoring Engine Name: ' || l_score_engine_name);
1133: FND_FILE.PUT_LINE(FND_FILE.LOG,'Scoring Engine ID: ' || l_score_engine_id);
1134: l_repeat := false;
1135: else
1136: l_return_status := FND_API.G_RET_STS_SUCCESS;
1137: end if;

Line 1148: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_object_id: '||l_object_id || ' does not exist in filter object :' ||l_entity_name || ' so skipping');

1144:
1145: --end if; --if l_confirmation_mode is NULL then
1146: else
1147: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_object_id: '||l_object_id || ' does not exist in filter object :' ||l_entity_name || ' so skipping');
1148: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_object_id: '||l_object_id || ' does not exist in filter object :' ||l_entity_name || ' so skipping');
1149: end if;
1150: close sql_cur2 ;
1151: end loop; -- sql_cur
1152: close sql_cur;

Line 1164: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'No Delinquency');

1160: LOOP
1161: Fetch C_Get_DEL into l_del_id, l_party_id, l_account_id, l_customer_site_use_id, l_score;
1162:
1163: --If ( C_GET_DEL%NOTFOUND ) Then
1164: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'No Delinquency');
1165: -- x_return_status := FND_API.G_RET_STS_ERROR;
1166: --end if;
1167:
1168: exit when C_GET_DEL%NOTFOUND;

Line 1310: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cannot Close Dunning');

1306: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - CloseDunning status='|| l_return_status);
1307:
1308: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1309: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Cannot Close Dunning');
1310: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cannot Close Dunning');
1311: l_return_status := FND_API.G_RET_STS_ERROR;
1312: END IF;
1313:
1314: --elsif l_confirmation_mode = 'REJECT' then

Line 1462: FND_FILE.put_line( FND_FILE.LOG,'Atleast one dunning record processed successfully. So spawning the IEX: XML bulk manager for delivery');

1458:
1459: if ( l_diff_bw_init_fi_su_rec > 0) then
1460:
1461: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Atleast one dunning record processed successfully. So spawning the IEX: XML bulk manager for delivery');
1462: FND_FILE.put_line( FND_FILE.LOG,'Atleast one dunning record processed successfully. So spawning the IEX: XML bulk manager for delivery');
1463:
1464: open c_object_type (l_req_id);
1465: fetch c_object_type into l_object_type;
1466: close c_object_type;

Line 1490: FND_FILE.put_line( FND_FILE.LOG,'');

1486:
1487: WriteLog(G_PKG_NAME || ' ' || l_api_name || 'Submitted the Bulk XML delivery, l_submit_request_id='||l_submit_request_id);
1488: else
1489: WriteLog(G_PKG_NAME || ' ' || l_api_name || 'Not even one dunning record processed successfully. So no need to spawn the IEX: XML bulk manager for delivery');
1490: FND_FILE.put_line( FND_FILE.LOG,'');
1491: FND_FILE.put_line( FND_FILE.LOG,'*******************************************************************************************************************************');
1492: FND_FILE.put_line( FND_FILE.LOG,'* WARNING: Not even one dunning record processed successfully. So no need to spawn the IEX: XML bulk manager for delivery *');
1493: FND_FILE.put_line( FND_FILE.LOG,'*******************************************************************************************************************************');
1494: FND_FILE.put_line( FND_FILE.LOG,'');

Line 1491: FND_FILE.put_line( FND_FILE.LOG,'*******************************************************************************************************************************');

1487: WriteLog(G_PKG_NAME || ' ' || l_api_name || 'Submitted the Bulk XML delivery, l_submit_request_id='||l_submit_request_id);
1488: else
1489: WriteLog(G_PKG_NAME || ' ' || l_api_name || 'Not even one dunning record processed successfully. So no need to spawn the IEX: XML bulk manager for delivery');
1490: FND_FILE.put_line( FND_FILE.LOG,'');
1491: FND_FILE.put_line( FND_FILE.LOG,'*******************************************************************************************************************************');
1492: FND_FILE.put_line( FND_FILE.LOG,'* WARNING: Not even one dunning record processed successfully. So no need to spawn the IEX: XML bulk manager for delivery *');
1493: FND_FILE.put_line( FND_FILE.LOG,'*******************************************************************************************************************************');
1494: FND_FILE.put_line( FND_FILE.LOG,'');
1495: end if;

Line 1492: FND_FILE.put_line( FND_FILE.LOG,'* WARNING: Not even one dunning record processed successfully. So no need to spawn the IEX: XML bulk manager for delivery *');

1488: else
1489: WriteLog(G_PKG_NAME || ' ' || l_api_name || 'Not even one dunning record processed successfully. So no need to spawn the IEX: XML bulk manager for delivery');
1490: FND_FILE.put_line( FND_FILE.LOG,'');
1491: FND_FILE.put_line( FND_FILE.LOG,'*******************************************************************************************************************************');
1492: FND_FILE.put_line( FND_FILE.LOG,'* WARNING: Not even one dunning record processed successfully. So no need to spawn the IEX: XML bulk manager for delivery *');
1493: FND_FILE.put_line( FND_FILE.LOG,'*******************************************************************************************************************************');
1494: FND_FILE.put_line( FND_FILE.LOG,'');
1495: end if;
1496:

Line 1493: FND_FILE.put_line( FND_FILE.LOG,'*******************************************************************************************************************************');

1489: WriteLog(G_PKG_NAME || ' ' || l_api_name || 'Not even one dunning record processed successfully. So no need to spawn the IEX: XML bulk manager for delivery');
1490: FND_FILE.put_line( FND_FILE.LOG,'');
1491: FND_FILE.put_line( FND_FILE.LOG,'*******************************************************************************************************************************');
1492: FND_FILE.put_line( FND_FILE.LOG,'* WARNING: Not even one dunning record processed successfully. So no need to spawn the IEX: XML bulk manager for delivery *');
1493: FND_FILE.put_line( FND_FILE.LOG,'*******************************************************************************************************************************');
1494: FND_FILE.put_line( FND_FILE.LOG,'');
1495: end if;
1496:
1497: --end if;

Line 1494: FND_FILE.put_line( FND_FILE.LOG,'');

1490: FND_FILE.put_line( FND_FILE.LOG,'');
1491: FND_FILE.put_line( FND_FILE.LOG,'*******************************************************************************************************************************');
1492: FND_FILE.put_line( FND_FILE.LOG,'* WARNING: Not even one dunning record processed successfully. So no need to spawn the IEX: XML bulk manager for delivery *');
1493: FND_FILE.put_line( FND_FILE.LOG,'*******************************************************************************************************************************');
1494: FND_FILE.put_line( FND_FILE.LOG,'');
1495: end if;
1496:
1497: --end if;
1498: --end if;

Line 1520: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No stage dunning invoice');

1516: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Dunning invoices count = '||l_dunn_invoice_ct);
1517:
1518: IF (l_dunn_invoice_ct is null or l_dunn_invoice_ct = 0) then
1519: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - No stage dunning invoice');
1520: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No stage dunning invoice');
1521: goto end_loop;
1522: ELSE
1523: -- Now, COLLECTIONS STAGE DUNNING INVOICE is not null;
1524:

Line 1525: FND_FILE.PUT_LINE(FND_FILE.LOG, 'COLLECTIONS STAGE DUNNING INVOICE='||l_dunn_invoice_ct);

1521: goto end_loop;
1522: ELSE
1523: -- Now, COLLECTIONS STAGE DUNNING INVOICE is not null;
1524:
1525: FND_FILE.PUT_LINE(FND_FILE.LOG, 'COLLECTIONS STAGE DUNNING INVOICE='||l_dunn_invoice_ct);
1526: IF (p_parent_request_id is NULL OR p_process_err_rec_only = 'Y') THEN
1527: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Start calling IEX_DUNNING_PVT.stage_dunning_inv_copy');
1528: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Start stage_dunning_inv_copy');
1529:

Line 1527: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Start calling IEX_DUNNING_PVT.stage_dunning_inv_copy');

1523: -- Now, COLLECTIONS STAGE DUNNING INVOICE is not null;
1524:
1525: FND_FILE.PUT_LINE(FND_FILE.LOG, 'COLLECTIONS STAGE DUNNING INVOICE='||l_dunn_invoice_ct);
1526: IF (p_parent_request_id is NULL OR p_process_err_rec_only = 'Y') THEN
1527: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Start calling IEX_DUNNING_PVT.stage_dunning_inv_copy');
1528: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Start stage_dunning_inv_copy');
1529:
1530: IEX_DUNNING_PVT.stage_dunning_inv_copy(
1531: p_api_version => 1.0

Line 1547: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Return status of IEX_DUNNING_PVT.stage_dunning_inv_copy='||l_return_status);

1543: , x_msg_count => l_msg_count
1544: , x_msg_data => l_msg_data
1545: );
1546:
1547: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Return status of IEX_DUNNING_PVT.stage_dunning_inv_copy='||l_return_status);
1548: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Return status of IEX_DUNNING_PVT.stage_dunning_inv_copy='||l_return_status);
1549:
1550: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1551: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Cannot create invoice copy');

Line 1552: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cannot create invoice copy');

1548: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Return status of IEX_DUNNING_PVT.stage_dunning_inv_copy='||l_return_status);
1549:
1550: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1551: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Cannot create invoice copy');
1552: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cannot create invoice copy');
1553: l_return_status := FND_API.G_RET_STS_ERROR;
1554: END IF;
1555: END IF;
1556: END IF; --IF (l_dunn_invoice_ct is null or l_dunn_invoice_ct = 0) then

Line 1573: FND_FILE.put_line( FND_FILE.LOG,'Atleast one invoice is satisfied to send invoice copy. So spawning the IEX: XML bulk manager for delivery');

1569: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' l_diff_bw_init_fi_su_inv_rec : '|| l_diff_bw_init_fi_su_inv_rec);
1570:
1571: if ( l_diff_bw_init_fi_su_inv_rec > 0) then
1572: WriteLog(G_PKG_NAME || ' ' || l_api_name || 'Atleast one invoice is satisfied to send invoice copy. So spawning the IEX: XML bulk manager for delivery');
1573: FND_FILE.put_line( FND_FILE.LOG,'Atleast one invoice is satisfied to send invoice copy. So spawning the IEX: XML bulk manager for delivery');
1574:
1575: l_no_of_workers := nvl(p_no_of_workers,1);
1576: --span bulk xml delivery
1577: l_submit_request_id := FND_REQUEST.SUBMIT_REQUEST(

Line 1665: FND_FILE.put_line( FND_FILE.LOG,'');

1661: if l_update_cp_as_err then
1662: if l_con_proc_mode = 'FINALDRAFT' then
1663: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - You can''t run this request id: ' || p_parent_request_id || ' in PREVIEW mode, because request has been created in direct FINAL mode.');
1664: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' Run this in FINAL mode with process errors Y to process the errored records.');
1665: FND_FILE.put_line( FND_FILE.LOG,'');
1666: FND_FILE.put_line( FND_FILE.LOG,'***************************************************************************************************************************');
1667: FND_FILE.PUT_LINE( FND_FILE.LOG,'* ERROR: You can''t run this request id: ' || p_parent_request_id || ' in PREVIEW mode, because request has been created in direct FINAL mode. *');
1668: FND_FILE.PUT_LINE( FND_FILE.LOG,'* Run this in FINAL mode with process errors Y to process the errored records. *');
1669: FND_FILE.put_line( FND_FILE.LOG,'***************************************************************************************************************************');

Line 1666: FND_FILE.put_line( FND_FILE.LOG,'***************************************************************************************************************************');

1662: if l_con_proc_mode = 'FINALDRAFT' then
1663: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - You can''t run this request id: ' || p_parent_request_id || ' in PREVIEW mode, because request has been created in direct FINAL mode.');
1664: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' Run this in FINAL mode with process errors Y to process the errored records.');
1665: FND_FILE.put_line( FND_FILE.LOG,'');
1666: FND_FILE.put_line( FND_FILE.LOG,'***************************************************************************************************************************');
1667: FND_FILE.PUT_LINE( FND_FILE.LOG,'* ERROR: You can''t run this request id: ' || p_parent_request_id || ' in PREVIEW mode, because request has been created in direct FINAL mode. *');
1668: FND_FILE.PUT_LINE( FND_FILE.LOG,'* Run this in FINAL mode with process errors Y to process the errored records. *');
1669: FND_FILE.put_line( FND_FILE.LOG,'***************************************************************************************************************************');
1670: FND_FILE.put_line( FND_FILE.LOG,'');

Line 1667: FND_FILE.PUT_LINE( FND_FILE.LOG,'* ERROR: You can''t run this request id: ' || p_parent_request_id || ' in PREVIEW mode, because request has been created in direct FINAL mode. *');

1663: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - You can''t run this request id: ' || p_parent_request_id || ' in PREVIEW mode, because request has been created in direct FINAL mode.');
1664: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' Run this in FINAL mode with process errors Y to process the errored records.');
1665: FND_FILE.put_line( FND_FILE.LOG,'');
1666: FND_FILE.put_line( FND_FILE.LOG,'***************************************************************************************************************************');
1667: FND_FILE.PUT_LINE( FND_FILE.LOG,'* ERROR: You can''t run this request id: ' || p_parent_request_id || ' in PREVIEW mode, because request has been created in direct FINAL mode. *');
1668: FND_FILE.PUT_LINE( FND_FILE.LOG,'* Run this in FINAL mode with process errors Y to process the errored records. *');
1669: FND_FILE.put_line( FND_FILE.LOG,'***************************************************************************************************************************');
1670: FND_FILE.put_line( FND_FILE.LOG,'');
1671: l_err_message := 'ERROR: You can''t run this request id: ' || p_parent_request_id || ' in PREVIEW mode, because request has been created in direct FINAL mode. Run this in FINAL mode with process errors Y to process the errored records.';

Line 1668: FND_FILE.PUT_LINE( FND_FILE.LOG,'* Run this in FINAL mode with process errors Y to process the errored records. *');

1664: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' Run this in FINAL mode with process errors Y to process the errored records.');
1665: FND_FILE.put_line( FND_FILE.LOG,'');
1666: FND_FILE.put_line( FND_FILE.LOG,'***************************************************************************************************************************');
1667: FND_FILE.PUT_LINE( FND_FILE.LOG,'* ERROR: You can''t run this request id: ' || p_parent_request_id || ' in PREVIEW mode, because request has been created in direct FINAL mode. *');
1668: FND_FILE.PUT_LINE( FND_FILE.LOG,'* Run this in FINAL mode with process errors Y to process the errored records. *');
1669: FND_FILE.put_line( FND_FILE.LOG,'***************************************************************************************************************************');
1670: FND_FILE.put_line( FND_FILE.LOG,'');
1671: l_err_message := 'ERROR: You can''t run this request id: ' || p_parent_request_id || ' in PREVIEW mode, because request has been created in direct FINAL mode. Run this in FINAL mode with process errors Y to process the errored records.';
1672: elsif l_con_proc_mode = 'DRAFTDRAFT' then

Line 1669: FND_FILE.put_line( FND_FILE.LOG,'***************************************************************************************************************************');

1665: FND_FILE.put_line( FND_FILE.LOG,'');
1666: FND_FILE.put_line( FND_FILE.LOG,'***************************************************************************************************************************');
1667: FND_FILE.PUT_LINE( FND_FILE.LOG,'* ERROR: You can''t run this request id: ' || p_parent_request_id || ' in PREVIEW mode, because request has been created in direct FINAL mode. *');
1668: FND_FILE.PUT_LINE( FND_FILE.LOG,'* Run this in FINAL mode with process errors Y to process the errored records. *');
1669: FND_FILE.put_line( FND_FILE.LOG,'***************************************************************************************************************************');
1670: FND_FILE.put_line( FND_FILE.LOG,'');
1671: l_err_message := 'ERROR: You can''t run this request id: ' || p_parent_request_id || ' in PREVIEW mode, because request has been created in direct FINAL mode. Run this in FINAL mode with process errors Y to process the errored records.';
1672: elsif l_con_proc_mode = 'DRAFTDRAFT' then
1673: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - You can''t run this request id: ' || p_parent_request_id || ' in PREVIEW mode, as this request has been already submitted in FINAL mode.');

Line 1670: FND_FILE.put_line( FND_FILE.LOG,'');

1666: FND_FILE.put_line( FND_FILE.LOG,'***************************************************************************************************************************');
1667: FND_FILE.PUT_LINE( FND_FILE.LOG,'* ERROR: You can''t run this request id: ' || p_parent_request_id || ' in PREVIEW mode, because request has been created in direct FINAL mode. *');
1668: FND_FILE.PUT_LINE( FND_FILE.LOG,'* Run this in FINAL mode with process errors Y to process the errored records. *');
1669: FND_FILE.put_line( FND_FILE.LOG,'***************************************************************************************************************************');
1670: FND_FILE.put_line( FND_FILE.LOG,'');
1671: l_err_message := 'ERROR: You can''t run this request id: ' || p_parent_request_id || ' in PREVIEW mode, because request has been created in direct FINAL mode. Run this in FINAL mode with process errors Y to process the errored records.';
1672: elsif l_con_proc_mode = 'DRAFTDRAFT' then
1673: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - You can''t run this request id: ' || p_parent_request_id || ' in PREVIEW mode, as this request has been already submitted in FINAL mode.');
1674: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' Run this in FINAL mode with process errors Y to process the errored records.');

Line 1675: FND_FILE.put_line( FND_FILE.LOG,'');

1671: l_err_message := 'ERROR: You can''t run this request id: ' || p_parent_request_id || ' in PREVIEW mode, because request has been created in direct FINAL mode. Run this in FINAL mode with process errors Y to process the errored records.';
1672: elsif l_con_proc_mode = 'DRAFTDRAFT' then
1673: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - You can''t run this request id: ' || p_parent_request_id || ' in PREVIEW mode, as this request has been already submitted in FINAL mode.');
1674: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' Run this in FINAL mode with process errors Y to process the errored records.');
1675: FND_FILE.put_line( FND_FILE.LOG,'');
1676: FND_FILE.put_line( FND_FILE.LOG,'*******************************************************************************************************************************');
1677: FND_FILE.PUT_LINE( FND_FILE.LOG,'* ERROR: You can''t run this request id: ' || p_parent_request_id || ' in PREVIEW mode, as this request has been already submitted in FINAL mode. *');
1678: FND_FILE.PUT_LINE( FND_FILE.LOG,'* Run this in FINAL mode with process errors Y to process the errored records. *');
1679: FND_FILE.put_line( FND_FILE.LOG,'*******************************************************************************************************************************');

Line 1676: FND_FILE.put_line( FND_FILE.LOG,'*******************************************************************************************************************************');

1672: elsif l_con_proc_mode = 'DRAFTDRAFT' then
1673: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - You can''t run this request id: ' || p_parent_request_id || ' in PREVIEW mode, as this request has been already submitted in FINAL mode.');
1674: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' Run this in FINAL mode with process errors Y to process the errored records.');
1675: FND_FILE.put_line( FND_FILE.LOG,'');
1676: FND_FILE.put_line( FND_FILE.LOG,'*******************************************************************************************************************************');
1677: FND_FILE.PUT_LINE( FND_FILE.LOG,'* ERROR: You can''t run this request id: ' || p_parent_request_id || ' in PREVIEW mode, as this request has been already submitted in FINAL mode. *');
1678: FND_FILE.PUT_LINE( FND_FILE.LOG,'* Run this in FINAL mode with process errors Y to process the errored records. *');
1679: FND_FILE.put_line( FND_FILE.LOG,'*******************************************************************************************************************************');
1680: FND_FILE.put_line( FND_FILE.LOG,'');

Line 1677: FND_FILE.PUT_LINE( FND_FILE.LOG,'* ERROR: You can''t run this request id: ' || p_parent_request_id || ' in PREVIEW mode, as this request has been already submitted in FINAL mode. *');

1673: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - You can''t run this request id: ' || p_parent_request_id || ' in PREVIEW mode, as this request has been already submitted in FINAL mode.');
1674: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' Run this in FINAL mode with process errors Y to process the errored records.');
1675: FND_FILE.put_line( FND_FILE.LOG,'');
1676: FND_FILE.put_line( FND_FILE.LOG,'*******************************************************************************************************************************');
1677: FND_FILE.PUT_LINE( FND_FILE.LOG,'* ERROR: You can''t run this request id: ' || p_parent_request_id || ' in PREVIEW mode, as this request has been already submitted in FINAL mode. *');
1678: FND_FILE.PUT_LINE( FND_FILE.LOG,'* Run this in FINAL mode with process errors Y to process the errored records. *');
1679: FND_FILE.put_line( FND_FILE.LOG,'*******************************************************************************************************************************');
1680: FND_FILE.put_line( FND_FILE.LOG,'');
1681: l_err_message := 'ERROR: You can''t run this request id: ' || p_parent_request_id || ' in PREVIEW mode, as this request has been already submitted in FINAL mode. Run this in FINAL mode with process errors Y to process the errored records.';

Line 1678: FND_FILE.PUT_LINE( FND_FILE.LOG,'* Run this in FINAL mode with process errors Y to process the errored records. *');

1674: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' Run this in FINAL mode with process errors Y to process the errored records.');
1675: FND_FILE.put_line( FND_FILE.LOG,'');
1676: FND_FILE.put_line( FND_FILE.LOG,'*******************************************************************************************************************************');
1677: FND_FILE.PUT_LINE( FND_FILE.LOG,'* ERROR: You can''t run this request id: ' || p_parent_request_id || ' in PREVIEW mode, as this request has been already submitted in FINAL mode. *');
1678: FND_FILE.PUT_LINE( FND_FILE.LOG,'* Run this in FINAL mode with process errors Y to process the errored records. *');
1679: FND_FILE.put_line( FND_FILE.LOG,'*******************************************************************************************************************************');
1680: FND_FILE.put_line( FND_FILE.LOG,'');
1681: l_err_message := 'ERROR: You can''t run this request id: ' || p_parent_request_id || ' in PREVIEW mode, as this request has been already submitted in FINAL mode. Run this in FINAL mode with process errors Y to process the errored records.';
1682: end if;

Line 1679: FND_FILE.put_line( FND_FILE.LOG,'*******************************************************************************************************************************');

1675: FND_FILE.put_line( FND_FILE.LOG,'');
1676: FND_FILE.put_line( FND_FILE.LOG,'*******************************************************************************************************************************');
1677: FND_FILE.PUT_LINE( FND_FILE.LOG,'* ERROR: You can''t run this request id: ' || p_parent_request_id || ' in PREVIEW mode, as this request has been already submitted in FINAL mode. *');
1678: FND_FILE.PUT_LINE( FND_FILE.LOG,'* Run this in FINAL mode with process errors Y to process the errored records. *');
1679: FND_FILE.put_line( FND_FILE.LOG,'*******************************************************************************************************************************');
1680: FND_FILE.put_line( FND_FILE.LOG,'');
1681: l_err_message := 'ERROR: You can''t run this request id: ' || p_parent_request_id || ' in PREVIEW mode, as this request has been already submitted in FINAL mode. Run this in FINAL mode with process errors Y to process the errored records.';
1682: end if;
1683: l_con_update_re_st := fnd_concurrent.set_completion_status (status => 'ERROR',

Line 1680: FND_FILE.put_line( FND_FILE.LOG,'');

1676: FND_FILE.put_line( FND_FILE.LOG,'*******************************************************************************************************************************');
1677: FND_FILE.PUT_LINE( FND_FILE.LOG,'* ERROR: You can''t run this request id: ' || p_parent_request_id || ' in PREVIEW mode, as this request has been already submitted in FINAL mode. *');
1678: FND_FILE.PUT_LINE( FND_FILE.LOG,'* Run this in FINAL mode with process errors Y to process the errored records. *');
1679: FND_FILE.put_line( FND_FILE.LOG,'*******************************************************************************************************************************');
1680: FND_FILE.put_line( FND_FILE.LOG,'');
1681: l_err_message := 'ERROR: You can''t run this request id: ' || p_parent_request_id || ' in PREVIEW mode, as this request has been already submitted in FINAL mode. Run this in FINAL mode with process errors Y to process the errored records.';
1682: end if;
1683: l_con_update_re_st := fnd_concurrent.set_completion_status (status => 'ERROR',
1684: message => l_err_message);

Line 1688: FND_FILE.put_line( FND_FILE.LOG,'');

1684: message => l_err_message);
1685: goto proc_end;
1686: elsif l_no_err_dunn_rec > 0 then
1687: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Set the iex: send dunning cp to WARNING status as at least one dunning record is failed to process');
1688: FND_FILE.put_line( FND_FILE.LOG,'');
1689: FND_FILE.put_line( FND_FILE.LOG, '**********************************************************************************************************');
1690: FND_FILE.put_line( FND_FILE.LOG, '* WARNING: Concurrent program ended in WARNING, as at least one dunning record is failed to process *');
1691: FND_FILE.put_line( FND_FILE.LOG, '**********************************************************************************************************');
1692: FND_FILE.put_line( FND_FILE.LOG,'');

Line 1689: FND_FILE.put_line( FND_FILE.LOG, '**********************************************************************************************************');

1685: goto proc_end;
1686: elsif l_no_err_dunn_rec > 0 then
1687: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Set the iex: send dunning cp to WARNING status as at least one dunning record is failed to process');
1688: FND_FILE.put_line( FND_FILE.LOG,'');
1689: FND_FILE.put_line( FND_FILE.LOG, '**********************************************************************************************************');
1690: FND_FILE.put_line( FND_FILE.LOG, '* WARNING: Concurrent program ended in WARNING, as at least one dunning record is failed to process *');
1691: FND_FILE.put_line( FND_FILE.LOG, '**********************************************************************************************************');
1692: FND_FILE.put_line( FND_FILE.LOG,'');
1693: l_con_update_re_st := fnd_concurrent.set_completion_status (status => 'WARNING',

Line 1690: FND_FILE.put_line( FND_FILE.LOG, '* WARNING: Concurrent program ended in WARNING, as at least one dunning record is failed to process *');

1686: elsif l_no_err_dunn_rec > 0 then
1687: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Set the iex: send dunning cp to WARNING status as at least one dunning record is failed to process');
1688: FND_FILE.put_line( FND_FILE.LOG,'');
1689: FND_FILE.put_line( FND_FILE.LOG, '**********************************************************************************************************');
1690: FND_FILE.put_line( FND_FILE.LOG, '* WARNING: Concurrent program ended in WARNING, as at least one dunning record is failed to process *');
1691: FND_FILE.put_line( FND_FILE.LOG, '**********************************************************************************************************');
1692: FND_FILE.put_line( FND_FILE.LOG,'');
1693: l_con_update_re_st := fnd_concurrent.set_completion_status (status => 'WARNING',
1694: message => 'At least one dunning record is failed to process');

Line 1691: FND_FILE.put_line( FND_FILE.LOG, '**********************************************************************************************************');

1687: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Set the iex: send dunning cp to WARNING status as at least one dunning record is failed to process');
1688: FND_FILE.put_line( FND_FILE.LOG,'');
1689: FND_FILE.put_line( FND_FILE.LOG, '**********************************************************************************************************');
1690: FND_FILE.put_line( FND_FILE.LOG, '* WARNING: Concurrent program ended in WARNING, as at least one dunning record is failed to process *');
1691: FND_FILE.put_line( FND_FILE.LOG, '**********************************************************************************************************');
1692: FND_FILE.put_line( FND_FILE.LOG,'');
1693: l_con_update_re_st := fnd_concurrent.set_completion_status (status => 'WARNING',
1694: message => 'At least one dunning record is failed to process');
1695: end if;

Line 1692: FND_FILE.put_line( FND_FILE.LOG,'');

1688: FND_FILE.put_line( FND_FILE.LOG,'');
1689: FND_FILE.put_line( FND_FILE.LOG, '**********************************************************************************************************');
1690: FND_FILE.put_line( FND_FILE.LOG, '* WARNING: Concurrent program ended in WARNING, as at least one dunning record is failed to process *');
1691: FND_FILE.put_line( FND_FILE.LOG, '**********************************************************************************************************');
1692: FND_FILE.put_line( FND_FILE.LOG,'');
1693: l_con_update_re_st := fnd_concurrent.set_completion_status (status => 'WARNING',
1694: message => 'At least one dunning record is failed to process');
1695: end if;
1696:

Line 1697: FND_FILE.put_line( FND_FILE.LOG,'');

1693: l_con_update_re_st := fnd_concurrent.set_completion_status (status => 'WARNING',
1694: message => 'At least one dunning record is failed to process');
1695: end if;
1696:
1697: FND_FILE.put_line( FND_FILE.LOG,'');
1698: FND_FILE.put_line( FND_FILE.LOG, '*************************************************************************');
1699: FND_FILE.put_line( FND_FILE.LOG, '* Number of record(s) processed : ' || l_no_of_rec_prc || ' *');
1700: FND_FILE.put_line( FND_FILE.LOG, '* Number of successful record(s) : ' || l_no_of_succ_rec || ' *');
1701: FND_FILE.put_line( FND_FILE.LOG, '* Number of failed record(s) : ' || l_no_of_fail_rec || ' *');

Line 1698: FND_FILE.put_line( FND_FILE.LOG, '*************************************************************************');

1694: message => 'At least one dunning record is failed to process');
1695: end if;
1696:
1697: FND_FILE.put_line( FND_FILE.LOG,'');
1698: FND_FILE.put_line( FND_FILE.LOG, '*************************************************************************');
1699: FND_FILE.put_line( FND_FILE.LOG, '* Number of record(s) processed : ' || l_no_of_rec_prc || ' *');
1700: FND_FILE.put_line( FND_FILE.LOG, '* Number of successful record(s) : ' || l_no_of_succ_rec || ' *');
1701: FND_FILE.put_line( FND_FILE.LOG, '* Number of failed record(s) : ' || l_no_of_fail_rec || ' *');
1702: FND_FILE.put_line( FND_FILE.LOG, '*************************************************************************');

Line 1699: FND_FILE.put_line( FND_FILE.LOG, '* Number of record(s) processed : ' || l_no_of_rec_prc || ' *');

1695: end if;
1696:
1697: FND_FILE.put_line( FND_FILE.LOG,'');
1698: FND_FILE.put_line( FND_FILE.LOG, '*************************************************************************');
1699: FND_FILE.put_line( FND_FILE.LOG, '* Number of record(s) processed : ' || l_no_of_rec_prc || ' *');
1700: FND_FILE.put_line( FND_FILE.LOG, '* Number of successful record(s) : ' || l_no_of_succ_rec || ' *');
1701: FND_FILE.put_line( FND_FILE.LOG, '* Number of failed record(s) : ' || l_no_of_fail_rec || ' *');
1702: FND_FILE.put_line( FND_FILE.LOG, '*************************************************************************');
1703: FND_FILE.put_line( FND_FILE.LOG,'');

Line 1700: FND_FILE.put_line( FND_FILE.LOG, '* Number of successful record(s) : ' || l_no_of_succ_rec || ' *');

1696:
1697: FND_FILE.put_line( FND_FILE.LOG,'');
1698: FND_FILE.put_line( FND_FILE.LOG, '*************************************************************************');
1699: FND_FILE.put_line( FND_FILE.LOG, '* Number of record(s) processed : ' || l_no_of_rec_prc || ' *');
1700: FND_FILE.put_line( FND_FILE.LOG, '* Number of successful record(s) : ' || l_no_of_succ_rec || ' *');
1701: FND_FILE.put_line( FND_FILE.LOG, '* Number of failed record(s) : ' || l_no_of_fail_rec || ' *');
1702: FND_FILE.put_line( FND_FILE.LOG, '*************************************************************************');
1703: FND_FILE.put_line( FND_FILE.LOG,'');
1704:

Line 1701: FND_FILE.put_line( FND_FILE.LOG, '* Number of failed record(s) : ' || l_no_of_fail_rec || ' *');

1697: FND_FILE.put_line( FND_FILE.LOG,'');
1698: FND_FILE.put_line( FND_FILE.LOG, '*************************************************************************');
1699: FND_FILE.put_line( FND_FILE.LOG, '* Number of record(s) processed : ' || l_no_of_rec_prc || ' *');
1700: FND_FILE.put_line( FND_FILE.LOG, '* Number of successful record(s) : ' || l_no_of_succ_rec || ' *');
1701: FND_FILE.put_line( FND_FILE.LOG, '* Number of failed record(s) : ' || l_no_of_fail_rec || ' *');
1702: FND_FILE.put_line( FND_FILE.LOG, '*************************************************************************');
1703: FND_FILE.put_line( FND_FILE.LOG,'');
1704:
1705: if p_process_err_rec_only = 'Y' then

Line 1702: FND_FILE.put_line( FND_FILE.LOG, '*************************************************************************');

1698: FND_FILE.put_line( FND_FILE.LOG, '*************************************************************************');
1699: FND_FILE.put_line( FND_FILE.LOG, '* Number of record(s) processed : ' || l_no_of_rec_prc || ' *');
1700: FND_FILE.put_line( FND_FILE.LOG, '* Number of successful record(s) : ' || l_no_of_succ_rec || ' *');
1701: FND_FILE.put_line( FND_FILE.LOG, '* Number of failed record(s) : ' || l_no_of_fail_rec || ' *');
1702: FND_FILE.put_line( FND_FILE.LOG, '*************************************************************************');
1703: FND_FILE.put_line( FND_FILE.LOG,'');
1704:
1705: if p_process_err_rec_only = 'Y' then
1706: FND_FILE.put_line( FND_FILE.LOG,'');

Line 1703: FND_FILE.put_line( FND_FILE.LOG,'');

1699: FND_FILE.put_line( FND_FILE.LOG, '* Number of record(s) processed : ' || l_no_of_rec_prc || ' *');
1700: FND_FILE.put_line( FND_FILE.LOG, '* Number of successful record(s) : ' || l_no_of_succ_rec || ' *');
1701: FND_FILE.put_line( FND_FILE.LOG, '* Number of failed record(s) : ' || l_no_of_fail_rec || ' *');
1702: FND_FILE.put_line( FND_FILE.LOG, '*************************************************************************');
1703: FND_FILE.put_line( FND_FILE.LOG,'');
1704:
1705: if p_process_err_rec_only = 'Y' then
1706: FND_FILE.put_line( FND_FILE.LOG,'');
1707: FND_FILE.put_line( FND_FILE.LOG, '*************************************************************************');

Line 1706: FND_FILE.put_line( FND_FILE.LOG,'');

1702: FND_FILE.put_line( FND_FILE.LOG, '*************************************************************************');
1703: FND_FILE.put_line( FND_FILE.LOG,'');
1704:
1705: if p_process_err_rec_only = 'Y' then
1706: FND_FILE.put_line( FND_FILE.LOG,'');
1707: FND_FILE.put_line( FND_FILE.LOG, '*************************************************************************');
1708: FND_FILE.put_line( FND_FILE.LOG, '* In Error mode: *');
1709: FND_FILE.put_line( FND_FILE.LOG, '* -------------- *');
1710: FND_FILE.put_line( FND_FILE.LOG, '* Number of errored record(s) processed by this run : ' || l_no_of_rec_prc_bylastrun || ' *');

Line 1707: FND_FILE.put_line( FND_FILE.LOG, '*************************************************************************');

1703: FND_FILE.put_line( FND_FILE.LOG,'');
1704:
1705: if p_process_err_rec_only = 'Y' then
1706: FND_FILE.put_line( FND_FILE.LOG,'');
1707: FND_FILE.put_line( FND_FILE.LOG, '*************************************************************************');
1708: FND_FILE.put_line( FND_FILE.LOG, '* In Error mode: *');
1709: FND_FILE.put_line( FND_FILE.LOG, '* -------------- *');
1710: FND_FILE.put_line( FND_FILE.LOG, '* Number of errored record(s) processed by this run : ' || l_no_of_rec_prc_bylastrun || ' *');
1711: FND_FILE.put_line( FND_FILE.LOG, '* Number of successful record(s) by this run : ' || l_no_of_succ_rec_bylastrun || ' *');

Line 1708: FND_FILE.put_line( FND_FILE.LOG, '* In Error mode: *');

1704:
1705: if p_process_err_rec_only = 'Y' then
1706: FND_FILE.put_line( FND_FILE.LOG,'');
1707: FND_FILE.put_line( FND_FILE.LOG, '*************************************************************************');
1708: FND_FILE.put_line( FND_FILE.LOG, '* In Error mode: *');
1709: FND_FILE.put_line( FND_FILE.LOG, '* -------------- *');
1710: FND_FILE.put_line( FND_FILE.LOG, '* Number of errored record(s) processed by this run : ' || l_no_of_rec_prc_bylastrun || ' *');
1711: FND_FILE.put_line( FND_FILE.LOG, '* Number of successful record(s) by this run : ' || l_no_of_succ_rec_bylastrun || ' *');
1712: FND_FILE.put_line( FND_FILE.LOG, '* Number of failed record(s) by this run : ' || l_no_of_fail_rec_bylastrun || ' *');

Line 1709: FND_FILE.put_line( FND_FILE.LOG, '* -------------- *');

1705: if p_process_err_rec_only = 'Y' then
1706: FND_FILE.put_line( FND_FILE.LOG,'');
1707: FND_FILE.put_line( FND_FILE.LOG, '*************************************************************************');
1708: FND_FILE.put_line( FND_FILE.LOG, '* In Error mode: *');
1709: FND_FILE.put_line( FND_FILE.LOG, '* -------------- *');
1710: FND_FILE.put_line( FND_FILE.LOG, '* Number of errored record(s) processed by this run : ' || l_no_of_rec_prc_bylastrun || ' *');
1711: FND_FILE.put_line( FND_FILE.LOG, '* Number of successful record(s) by this run : ' || l_no_of_succ_rec_bylastrun || ' *');
1712: FND_FILE.put_line( FND_FILE.LOG, '* Number of failed record(s) by this run : ' || l_no_of_fail_rec_bylastrun || ' *');
1713: FND_FILE.put_line( FND_FILE.LOG, '*************************************************************************');

Line 1710: FND_FILE.put_line( FND_FILE.LOG, '* Number of errored record(s) processed by this run : ' || l_no_of_rec_prc_bylastrun || ' *');

1706: FND_FILE.put_line( FND_FILE.LOG,'');
1707: FND_FILE.put_line( FND_FILE.LOG, '*************************************************************************');
1708: FND_FILE.put_line( FND_FILE.LOG, '* In Error mode: *');
1709: FND_FILE.put_line( FND_FILE.LOG, '* -------------- *');
1710: FND_FILE.put_line( FND_FILE.LOG, '* Number of errored record(s) processed by this run : ' || l_no_of_rec_prc_bylastrun || ' *');
1711: FND_FILE.put_line( FND_FILE.LOG, '* Number of successful record(s) by this run : ' || l_no_of_succ_rec_bylastrun || ' *');
1712: FND_FILE.put_line( FND_FILE.LOG, '* Number of failed record(s) by this run : ' || l_no_of_fail_rec_bylastrun || ' *');
1713: FND_FILE.put_line( FND_FILE.LOG, '*************************************************************************');
1714: FND_FILE.put_line( FND_FILE.LOG,'');

Line 1711: FND_FILE.put_line( FND_FILE.LOG, '* Number of successful record(s) by this run : ' || l_no_of_succ_rec_bylastrun || ' *');

1707: FND_FILE.put_line( FND_FILE.LOG, '*************************************************************************');
1708: FND_FILE.put_line( FND_FILE.LOG, '* In Error mode: *');
1709: FND_FILE.put_line( FND_FILE.LOG, '* -------------- *');
1710: FND_FILE.put_line( FND_FILE.LOG, '* Number of errored record(s) processed by this run : ' || l_no_of_rec_prc_bylastrun || ' *');
1711: FND_FILE.put_line( FND_FILE.LOG, '* Number of successful record(s) by this run : ' || l_no_of_succ_rec_bylastrun || ' *');
1712: FND_FILE.put_line( FND_FILE.LOG, '* Number of failed record(s) by this run : ' || l_no_of_fail_rec_bylastrun || ' *');
1713: FND_FILE.put_line( FND_FILE.LOG, '*************************************************************************');
1714: FND_FILE.put_line( FND_FILE.LOG,'');
1715: end if;

Line 1712: FND_FILE.put_line( FND_FILE.LOG, '* Number of failed record(s) by this run : ' || l_no_of_fail_rec_bylastrun || ' *');

1708: FND_FILE.put_line( FND_FILE.LOG, '* In Error mode: *');
1709: FND_FILE.put_line( FND_FILE.LOG, '* -------------- *');
1710: FND_FILE.put_line( FND_FILE.LOG, '* Number of errored record(s) processed by this run : ' || l_no_of_rec_prc_bylastrun || ' *');
1711: FND_FILE.put_line( FND_FILE.LOG, '* Number of successful record(s) by this run : ' || l_no_of_succ_rec_bylastrun || ' *');
1712: FND_FILE.put_line( FND_FILE.LOG, '* Number of failed record(s) by this run : ' || l_no_of_fail_rec_bylastrun || ' *');
1713: FND_FILE.put_line( FND_FILE.LOG, '*************************************************************************');
1714: FND_FILE.put_line( FND_FILE.LOG,'');
1715: end if;
1716:

Line 1713: FND_FILE.put_line( FND_FILE.LOG, '*************************************************************************');

1709: FND_FILE.put_line( FND_FILE.LOG, '* -------------- *');
1710: FND_FILE.put_line( FND_FILE.LOG, '* Number of errored record(s) processed by this run : ' || l_no_of_rec_prc_bylastrun || ' *');
1711: FND_FILE.put_line( FND_FILE.LOG, '* Number of successful record(s) by this run : ' || l_no_of_succ_rec_bylastrun || ' *');
1712: FND_FILE.put_line( FND_FILE.LOG, '* Number of failed record(s) by this run : ' || l_no_of_fail_rec_bylastrun || ' *');
1713: FND_FILE.put_line( FND_FILE.LOG, '*************************************************************************');
1714: FND_FILE.put_line( FND_FILE.LOG,'');
1715: end if;
1716:
1717: <>

Line 1714: FND_FILE.put_line( FND_FILE.LOG,'');

1710: FND_FILE.put_line( FND_FILE.LOG, '* Number of errored record(s) processed by this run : ' || l_no_of_rec_prc_bylastrun || ' *');
1711: FND_FILE.put_line( FND_FILE.LOG, '* Number of successful record(s) by this run : ' || l_no_of_succ_rec_bylastrun || ' *');
1712: FND_FILE.put_line( FND_FILE.LOG, '* Number of failed record(s) by this run : ' || l_no_of_fail_rec_bylastrun || ' *');
1713: FND_FILE.put_line( FND_FILE.LOG, '*************************************************************************');
1714: FND_FILE.put_line( FND_FILE.LOG,'');
1715: end if;
1716:
1717: <>
1718: -- Debug Message

Line 1882: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Callback_Concur');

1878:
1879: BEGIN
1880:
1881: l_api_name := 'callback_concur';
1882: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Callback_Concur');
1883: WriteLog('Send_Dunning: ' || G_PKG_NAME || ' ' || l_api_name || ' - starting CALLBACK_CONCUR');
1884:
1885: --Start MOAC
1886: mo_global.init('IEX');

Line 1892: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Operating Unit: '|| nvl(mo_global.get_ou_name(mo_global.get_current_org_id), 'All'));

1888: mo_global.set_policy_context('M',NULL);
1889: ELSE
1890: mo_global.set_policy_context('S',p_org_id);
1891: END IF;
1892: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Operating Unit: '|| nvl(mo_global.get_ou_name(mo_global.get_current_org_id), 'All'));
1893: --End MOAC
1894:
1895: l_default_rs_id := fnd_profile.value('IEX_STRY_DEFAULT_RESOURCE');
1896: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Default Resource Id = '||l_default_rs_id);

Line 1896: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Default Resource Id = '||l_default_rs_id);

1892: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Operating Unit: '|| nvl(mo_global.get_ou_name(mo_global.get_current_org_id), 'All'));
1893: --End MOAC
1894:
1895: l_default_rs_id := fnd_profile.value('IEX_STRY_DEFAULT_RESOURCE');
1896: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Default Resource Id = '||l_default_rs_id);
1897: WriteLog('Send_Dunning: ' || G_PKG_NAME || ' ' || l_api_name || ' - default_rs_id='||l_default_rs_id);
1898:
1899: if (l_default_rs_id = 0 or l_default_rs_id is null) then
1900: WriteLog('Send_Dunning: ' || G_PKG_NAME || ' ' || l_api_name || ' - CALLBACK_CONCUR:no rs_id');

Line 1910: FND_FILE.PUT_LINE(FND_FILE.LOG, 'no default resource_id');

1906: ( p_count => l_msg_count,
1907: p_data => l_msg_data
1908: );
1909:
1910: FND_FILE.PUT_LINE(FND_FILE.LOG, 'no default resource_id');
1911: errbuf := l_msg_data;
1912: retcode := '2'; --FND_API.G_RET_STS_ERROR;
1913: --retcode := FND_API.G_RET_STS_ERROR;
1914: WriteLog('Send_Dunning: ' || G_PKG_NAME || ' ' || l_api_name || ' - errbuf='||errbuf);

Line 1919: FND_FILE.PUT_LINE(FND_FILE.LOG, errmsg);

1915:
1916: for i in 1..l_msg_count loop
1917: errmsg := FND_MSG_PUB.Get(p_msg_index => i,
1918: p_encoded => 'F');
1919: FND_FILE.PUT_LINE(FND_FILE.LOG, errmsg);
1920: WriteLog('Send_Dunning: ' || G_PKG_NAME || ' ' || l_api_name || ' - errmsg='||errmsg);
1921: end loop;
1922:
1923: --

Line 1938: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Dunning Running Level = '||l_running_level);

1934: END IF;
1935: CLOSE C_GET_LEVEL;
1936:
1937: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - running level='||l_running_level);
1938: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Dunning Running Level = '||l_running_level);
1939: IF (l_running_level is null or l_error = 1) then
1940: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - no running level');
1941: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No Dunning Running Level');
1942: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_VALUE');

Line 1941: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No Dunning Running Level');

1937: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - running level='||l_running_level);
1938: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Dunning Running Level = '||l_running_level);
1939: IF (l_running_level is null or l_error = 1) then
1940: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - no running level');
1941: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No Dunning Running Level');
1942: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_VALUE');
1943: FND_MESSAGE.Set_Token('COLUMN', 'COLLECTIONS DUNNING LEVEL', FALSE);
1944: FND_MSG_PUB.Add;
1945:

Line 1959: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Calback_Concur errmsg =' ||errmsg);

1955: for i in 1..l_msg_count loop
1956: errmsg := FND_MSG_PUB.Get(p_msg_index => i,
1957: p_encoded => 'F');
1958: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - errmsg='||errmsg);
1959: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Calback_Concur errmsg =' ||errmsg);
1960: end loop;
1961: --
1962: else
1963: FND_FILE.PUT_LINE(FND_FILE.LOG, '>>>>>Process Dunning Callbacks');

Line 1963: FND_FILE.PUT_LINE(FND_FILE.LOG, '>>>>>Process Dunning Callbacks');

1959: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Calback_Concur errmsg =' ||errmsg);
1960: end loop;
1961: --
1962: else
1963: FND_FILE.PUT_LINE(FND_FILE.LOG, '>>>>>Process Dunning Callbacks');
1964: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - starting Daily_Dunning');
1965: IEX_DUNNING_PUB.Daily_Dunning(
1966: p_api_version => l_api_version
1967: , p_init_msg_list => FND_API.G_TRUE

Line 1976: FND_FILE.PUT_LINE(FND_FILE.LOG, '>>>>>End of Process Dunning Callbacks');

1972: , x_msg_data => ERRBUF
1973: );
1974:
1975: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Daily_Dunning status='||retcode);
1976: FND_FILE.PUT_LINE(FND_FILE.LOG, '>>>>>End of Process Dunning Callbacks');
1977: end if;
1978: --
1979: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - ProcessPromiseCallbacks');
1980: FND_FILE.PUT_LINE(FND_FILE.LOG, '>>>>>Process Promise Callbacks');

Line 1980: FND_FILE.PUT_LINE(FND_FILE.LOG, '>>>>>Process Promise Callbacks');

1976: FND_FILE.PUT_LINE(FND_FILE.LOG, '>>>>>End of Process Dunning Callbacks');
1977: end if;
1978: --
1979: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - ProcessPromiseCallbacks');
1980: FND_FILE.PUT_LINE(FND_FILE.LOG, '>>>>>Process Promise Callbacks');
1981:
1982: IEX_PROMISES_BATCH_PUB.PROCESS_PROMISE_CALLBACKS(
1983: p_api_version => l_api_version
1984: , p_init_msg_list => FND_API.G_TRUE

Line 1992: FND_FILE.PUT_LINE(FND_FILE.LOG, '>>>>>End of Process Promise Callbacks');

1988: , x_msg_data => l_msg_data);
1989:
1990: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - ProcessPromiseCallbacks status='||retcode);
1991: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - End ProcessPromiseCallbacks');
1992: FND_FILE.PUT_LINE(FND_FILE.LOG, '>>>>>End of Process Promise Callbacks');
1993:
1994: end if;
1995:
1996: EXCEPTION

Line 1999: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Callback_Concur Exception');

1995:
1996: EXCEPTION
1997: WHEN OTHERS THEN
1998: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Exception');
1999: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Callback_Concur Exception');
2000: errbuf := SQLERRM;
2001: retcode := '2';
2002: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - errbuf='||errbuf);
2003: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Callback_Concur errbuf:'||errbuf);

Line 2003: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Callback_Concur errbuf:'||errbuf);

1999: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Callback_Concur Exception');
2000: errbuf := SQLERRM;
2001: retcode := '2';
2002: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - errbuf='||errbuf);
2003: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Callback_Concur errbuf:'||errbuf);
2004:
2005: END CALLBACK_CONCUR;
2006:
2007:

Line 2109: FND_FILE.PUT_LINE(FND_FILE.LOG, 'SEND_DUNNING_CONCUR dunning_plan_id = ' || dunning_plan_id);

2105: BEGIN
2106:
2107: l_api_name := 'SEND_DUNNING_CONCUR';
2108:
2109: FND_FILE.PUT_LINE(FND_FILE.LOG, 'SEND_DUNNING_CONCUR dunning_plan_id = ' || dunning_plan_id);
2110: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CORRESPONDENCE DATE : ' || p_correspondence_date);
2111: FND_FILE.PUT_LINE(FND_FILE.LOG, 'PARENT REQUEST ID : ' || p_parent_request_id);
2112: --Start adding for bug 8489610 by gnramasa 14-May-09
2113: FND_FILE.PUT_LINE(FND_FILE.LOG, 'DUNNING MODE : ' || p_dunning_mode);

Line 2110: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CORRESPONDENCE DATE : ' || p_correspondence_date);

2106:
2107: l_api_name := 'SEND_DUNNING_CONCUR';
2108:
2109: FND_FILE.PUT_LINE(FND_FILE.LOG, 'SEND_DUNNING_CONCUR dunning_plan_id = ' || dunning_plan_id);
2110: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CORRESPONDENCE DATE : ' || p_correspondence_date);
2111: FND_FILE.PUT_LINE(FND_FILE.LOG, 'PARENT REQUEST ID : ' || p_parent_request_id);
2112: --Start adding for bug 8489610 by gnramasa 14-May-09
2113: FND_FILE.PUT_LINE(FND_FILE.LOG, 'DUNNING MODE : ' || p_dunning_mode);
2114: FND_FILE.PUT_LINE(FND_FILE.LOG, 'SINGLE STAGED LETTER : ' || p_single_staged_letter);

Line 2111: FND_FILE.PUT_LINE(FND_FILE.LOG, 'PARENT REQUEST ID : ' || p_parent_request_id);

2107: l_api_name := 'SEND_DUNNING_CONCUR';
2108:
2109: FND_FILE.PUT_LINE(FND_FILE.LOG, 'SEND_DUNNING_CONCUR dunning_plan_id = ' || dunning_plan_id);
2110: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CORRESPONDENCE DATE : ' || p_correspondence_date);
2111: FND_FILE.PUT_LINE(FND_FILE.LOG, 'PARENT REQUEST ID : ' || p_parent_request_id);
2112: --Start adding for bug 8489610 by gnramasa 14-May-09
2113: FND_FILE.PUT_LINE(FND_FILE.LOG, 'DUNNING MODE : ' || p_dunning_mode);
2114: FND_FILE.PUT_LINE(FND_FILE.LOG, 'SINGLE STAGED LETTER : ' || p_single_staged_letter);
2115: FND_FILE.PUT_LINE(FND_FILE.LOG, 'PROCESS ERRORED RECORD ONLY : ' || p_process_err_rec_only);

Line 2113: FND_FILE.PUT_LINE(FND_FILE.LOG, 'DUNNING MODE : ' || p_dunning_mode);

2109: FND_FILE.PUT_LINE(FND_FILE.LOG, 'SEND_DUNNING_CONCUR dunning_plan_id = ' || dunning_plan_id);
2110: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CORRESPONDENCE DATE : ' || p_correspondence_date);
2111: FND_FILE.PUT_LINE(FND_FILE.LOG, 'PARENT REQUEST ID : ' || p_parent_request_id);
2112: --Start adding for bug 8489610 by gnramasa 14-May-09
2113: FND_FILE.PUT_LINE(FND_FILE.LOG, 'DUNNING MODE : ' || p_dunning_mode);
2114: FND_FILE.PUT_LINE(FND_FILE.LOG, 'SINGLE STAGED LETTER : ' || p_single_staged_letter);
2115: FND_FILE.PUT_LINE(FND_FILE.LOG, 'PROCESS ERRORED RECORD ONLY : ' || p_process_err_rec_only);
2116: FND_FILE.PUT_LINE(FND_FILE.LOG, 'NUMBER OF WORKERS : ' || p_no_of_workers);
2117: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CUSTOMER NAME LOW : ' || p_customer_name_low);

Line 2114: FND_FILE.PUT_LINE(FND_FILE.LOG, 'SINGLE STAGED LETTER : ' || p_single_staged_letter);

2110: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CORRESPONDENCE DATE : ' || p_correspondence_date);
2111: FND_FILE.PUT_LINE(FND_FILE.LOG, 'PARENT REQUEST ID : ' || p_parent_request_id);
2112: --Start adding for bug 8489610 by gnramasa 14-May-09
2113: FND_FILE.PUT_LINE(FND_FILE.LOG, 'DUNNING MODE : ' || p_dunning_mode);
2114: FND_FILE.PUT_LINE(FND_FILE.LOG, 'SINGLE STAGED LETTER : ' || p_single_staged_letter);
2115: FND_FILE.PUT_LINE(FND_FILE.LOG, 'PROCESS ERRORED RECORD ONLY : ' || p_process_err_rec_only);
2116: FND_FILE.PUT_LINE(FND_FILE.LOG, 'NUMBER OF WORKERS : ' || p_no_of_workers);
2117: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CUSTOMER NAME LOW : ' || p_customer_name_low);
2118: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CUSTOMER NAME HIGH : ' || p_customer_name_high);

Line 2115: FND_FILE.PUT_LINE(FND_FILE.LOG, 'PROCESS ERRORED RECORD ONLY : ' || p_process_err_rec_only);

2111: FND_FILE.PUT_LINE(FND_FILE.LOG, 'PARENT REQUEST ID : ' || p_parent_request_id);
2112: --Start adding for bug 8489610 by gnramasa 14-May-09
2113: FND_FILE.PUT_LINE(FND_FILE.LOG, 'DUNNING MODE : ' || p_dunning_mode);
2114: FND_FILE.PUT_LINE(FND_FILE.LOG, 'SINGLE STAGED LETTER : ' || p_single_staged_letter);
2115: FND_FILE.PUT_LINE(FND_FILE.LOG, 'PROCESS ERRORED RECORD ONLY : ' || p_process_err_rec_only);
2116: FND_FILE.PUT_LINE(FND_FILE.LOG, 'NUMBER OF WORKERS : ' || p_no_of_workers);
2117: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CUSTOMER NAME LOW : ' || p_customer_name_low);
2118: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CUSTOMER NAME HIGH : ' || p_customer_name_high);
2119: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ACCOUNT NUMBER LOW : ' || p_account_number_low);

Line 2116: FND_FILE.PUT_LINE(FND_FILE.LOG, 'NUMBER OF WORKERS : ' || p_no_of_workers);

2112: --Start adding for bug 8489610 by gnramasa 14-May-09
2113: FND_FILE.PUT_LINE(FND_FILE.LOG, 'DUNNING MODE : ' || p_dunning_mode);
2114: FND_FILE.PUT_LINE(FND_FILE.LOG, 'SINGLE STAGED LETTER : ' || p_single_staged_letter);
2115: FND_FILE.PUT_LINE(FND_FILE.LOG, 'PROCESS ERRORED RECORD ONLY : ' || p_process_err_rec_only);
2116: FND_FILE.PUT_LINE(FND_FILE.LOG, 'NUMBER OF WORKERS : ' || p_no_of_workers);
2117: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CUSTOMER NAME LOW : ' || p_customer_name_low);
2118: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CUSTOMER NAME HIGH : ' || p_customer_name_high);
2119: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ACCOUNT NUMBER LOW : ' || p_account_number_low);
2120: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ACCOUNT NUMBER HIGH : ' || p_account_number_high);

Line 2117: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CUSTOMER NAME LOW : ' || p_customer_name_low);

2113: FND_FILE.PUT_LINE(FND_FILE.LOG, 'DUNNING MODE : ' || p_dunning_mode);
2114: FND_FILE.PUT_LINE(FND_FILE.LOG, 'SINGLE STAGED LETTER : ' || p_single_staged_letter);
2115: FND_FILE.PUT_LINE(FND_FILE.LOG, 'PROCESS ERRORED RECORD ONLY : ' || p_process_err_rec_only);
2116: FND_FILE.PUT_LINE(FND_FILE.LOG, 'NUMBER OF WORKERS : ' || p_no_of_workers);
2117: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CUSTOMER NAME LOW : ' || p_customer_name_low);
2118: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CUSTOMER NAME HIGH : ' || p_customer_name_high);
2119: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ACCOUNT NUMBER LOW : ' || p_account_number_low);
2120: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ACCOUNT NUMBER HIGH : ' || p_account_number_high);
2121: FND_FILE.PUT_LINE(FND_FILE.LOG, 'BILLTO LOCATION LOW : ' || p_billto_location_low);

Line 2118: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CUSTOMER NAME HIGH : ' || p_customer_name_high);

2114: FND_FILE.PUT_LINE(FND_FILE.LOG, 'SINGLE STAGED LETTER : ' || p_single_staged_letter);
2115: FND_FILE.PUT_LINE(FND_FILE.LOG, 'PROCESS ERRORED RECORD ONLY : ' || p_process_err_rec_only);
2116: FND_FILE.PUT_LINE(FND_FILE.LOG, 'NUMBER OF WORKERS : ' || p_no_of_workers);
2117: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CUSTOMER NAME LOW : ' || p_customer_name_low);
2118: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CUSTOMER NAME HIGH : ' || p_customer_name_high);
2119: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ACCOUNT NUMBER LOW : ' || p_account_number_low);
2120: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ACCOUNT NUMBER HIGH : ' || p_account_number_high);
2121: FND_FILE.PUT_LINE(FND_FILE.LOG, 'BILLTO LOCATION LOW : ' || p_billto_location_low);
2122: FND_FILE.PUT_LINE(FND_FILE.LOG, 'BILLTO LOCATION HIGH : ' || p_billto_location_high);

Line 2119: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ACCOUNT NUMBER LOW : ' || p_account_number_low);

2115: FND_FILE.PUT_LINE(FND_FILE.LOG, 'PROCESS ERRORED RECORD ONLY : ' || p_process_err_rec_only);
2116: FND_FILE.PUT_LINE(FND_FILE.LOG, 'NUMBER OF WORKERS : ' || p_no_of_workers);
2117: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CUSTOMER NAME LOW : ' || p_customer_name_low);
2118: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CUSTOMER NAME HIGH : ' || p_customer_name_high);
2119: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ACCOUNT NUMBER LOW : ' || p_account_number_low);
2120: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ACCOUNT NUMBER HIGH : ' || p_account_number_high);
2121: FND_FILE.PUT_LINE(FND_FILE.LOG, 'BILLTO LOCATION LOW : ' || p_billto_location_low);
2122: FND_FILE.PUT_LINE(FND_FILE.LOG, 'BILLTO LOCATION HIGH : ' || p_billto_location_high);
2123: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Order Output Letters By : ' || p_order_output_by);

Line 2120: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ACCOUNT NUMBER HIGH : ' || p_account_number_high);

2116: FND_FILE.PUT_LINE(FND_FILE.LOG, 'NUMBER OF WORKERS : ' || p_no_of_workers);
2117: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CUSTOMER NAME LOW : ' || p_customer_name_low);
2118: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CUSTOMER NAME HIGH : ' || p_customer_name_high);
2119: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ACCOUNT NUMBER LOW : ' || p_account_number_low);
2120: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ACCOUNT NUMBER HIGH : ' || p_account_number_high);
2121: FND_FILE.PUT_LINE(FND_FILE.LOG, 'BILLTO LOCATION LOW : ' || p_billto_location_low);
2122: FND_FILE.PUT_LINE(FND_FILE.LOG, 'BILLTO LOCATION HIGH : ' || p_billto_location_high);
2123: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Order Output Letters By : ' || p_order_output_by);
2124: WriteLog('iexpdunb:starting SEND_DUNNING_CONCUR; dunning_plan_id : ' || dunning_plan_id);

Line 2121: FND_FILE.PUT_LINE(FND_FILE.LOG, 'BILLTO LOCATION LOW : ' || p_billto_location_low);

2117: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CUSTOMER NAME LOW : ' || p_customer_name_low);
2118: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CUSTOMER NAME HIGH : ' || p_customer_name_high);
2119: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ACCOUNT NUMBER LOW : ' || p_account_number_low);
2120: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ACCOUNT NUMBER HIGH : ' || p_account_number_high);
2121: FND_FILE.PUT_LINE(FND_FILE.LOG, 'BILLTO LOCATION LOW : ' || p_billto_location_low);
2122: FND_FILE.PUT_LINE(FND_FILE.LOG, 'BILLTO LOCATION HIGH : ' || p_billto_location_high);
2123: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Order Output Letters By : ' || p_order_output_by);
2124: WriteLog('iexpdunb:starting SEND_DUNNING_CONCUR; dunning_plan_id : ' || dunning_plan_id);
2125: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - start');

Line 2122: FND_FILE.PUT_LINE(FND_FILE.LOG, 'BILLTO LOCATION HIGH : ' || p_billto_location_high);

2118: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CUSTOMER NAME HIGH : ' || p_customer_name_high);
2119: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ACCOUNT NUMBER LOW : ' || p_account_number_low);
2120: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ACCOUNT NUMBER HIGH : ' || p_account_number_high);
2121: FND_FILE.PUT_LINE(FND_FILE.LOG, 'BILLTO LOCATION LOW : ' || p_billto_location_low);
2122: FND_FILE.PUT_LINE(FND_FILE.LOG, 'BILLTO LOCATION HIGH : ' || p_billto_location_high);
2123: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Order Output Letters By : ' || p_order_output_by);
2124: WriteLog('iexpdunb:starting SEND_DUNNING_CONCUR; dunning_plan_id : ' || dunning_plan_id);
2125: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - start');
2126: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - correspondence date :' || p_correspondence_date);

Line 2123: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Order Output Letters By : ' || p_order_output_by);

2119: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ACCOUNT NUMBER LOW : ' || p_account_number_low);
2120: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ACCOUNT NUMBER HIGH : ' || p_account_number_high);
2121: FND_FILE.PUT_LINE(FND_FILE.LOG, 'BILLTO LOCATION LOW : ' || p_billto_location_low);
2122: FND_FILE.PUT_LINE(FND_FILE.LOG, 'BILLTO LOCATION HIGH : ' || p_billto_location_high);
2123: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Order Output Letters By : ' || p_order_output_by);
2124: WriteLog('iexpdunb:starting SEND_DUNNING_CONCUR; dunning_plan_id : ' || dunning_plan_id);
2125: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - start');
2126: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - correspondence date :' || p_correspondence_date);
2127: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - parent request id :' || p_parent_request_id);

Line 2142: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Org Id:'|| mo_global.get_current_org_id);

2138: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Order Output Letters By :' || p_order_output_by);
2139: --End adding for bug 8489610 by gnramasa 14-May-09
2140:
2141: --Start MOAC
2142: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Org Id:'|| mo_global.get_current_org_id);
2143: --End MOAC
2144: -- start added by snuthala for bug 10221334 21/10/2010
2145: OPEN C_Get_Level (dunning_plan_id);
2146: FETCH C_Get_Level INTO l_running_level;

Line 2148: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_running_level : '|| l_running_level);

2144: -- start added by snuthala for bug 10221334 21/10/2010
2145: OPEN C_Get_Level (dunning_plan_id);
2146: FETCH C_Get_Level INTO l_running_level;
2147: close C_Get_Level;
2148: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_running_level : '|| l_running_level);
2149:
2150: OPEN c_business_level ;
2151: FETCH c_business_level INTO l_business_level;
2152: close c_business_level;

Line 2153: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_business_level : '|| l_business_level);

2149:
2150: OPEN c_business_level ;
2151: FETCH c_business_level INTO l_business_level;
2152: close c_business_level;
2153: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_business_level : '|| l_business_level);
2154:
2155: OPEN c_ou_running_level;
2156: FETCH c_ou_running_level INTO l_define_ou_running_level;
2157: close c_ou_running_level;

Line 2159: FND_FILE.PUT_LINE(FND_FILE.LOG, 'define_ou_running_level : '|| l_define_ou_running_level);

2155: OPEN c_ou_running_level;
2156: FETCH c_ou_running_level INTO l_define_ou_running_level;
2157: close c_ou_running_level;
2158:
2159: FND_FILE.PUT_LINE(FND_FILE.LOG, 'define_ou_running_level : '|| l_define_ou_running_level);
2160:
2161: if l_running_level <> l_business_level then
2162: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Dunning Plan level is '||l_running_level ||' does not match the current business level '||l_business_level);
2163: l_org_id_coll_method := 'MISMATCH'; -- This is to end send dunning cp from running if Dunning Plan level does not match the current business level

Line 2162: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Dunning Plan level is '||l_running_level ||' does not match the current business level '||l_business_level);

2158:
2159: FND_FILE.PUT_LINE(FND_FILE.LOG, 'define_ou_running_level : '|| l_define_ou_running_level);
2160:
2161: if l_running_level <> l_business_level then
2162: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Dunning Plan level is '||l_running_level ||' does not match the current business level '||l_business_level);
2163: l_org_id_coll_method := 'MISMATCH'; -- This is to end send dunning cp from running if Dunning Plan level does not match the current business level
2164: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Concurrent program failed to run as Dunning Plan level is '||l_running_level ||' does not match the current business level '||l_business_level);
2165: l_con_update_re_st := fnd_concurrent.set_completion_status (status => 'WARNING',
2166:

Line 2164: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Concurrent program failed to run as Dunning Plan level is '||l_running_level ||' does not match the current business level '||l_business_level);

2160:
2161: if l_running_level <> l_business_level then
2162: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Dunning Plan level is '||l_running_level ||' does not match the current business level '||l_business_level);
2163: l_org_id_coll_method := 'MISMATCH'; -- This is to end send dunning cp from running if Dunning Plan level does not match the current business level
2164: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Concurrent program failed to run as Dunning Plan level is '||l_running_level ||' does not match the current business level '||l_business_level);
2165: l_con_update_re_st := fnd_concurrent.set_completion_status (status => 'WARNING',
2166:
2167: message => 'Concurrent program failed to run as Dunning Plan level is '||l_running_level ||' does not match the current business level '||l_business_level);
2168: iex_dunning_pvt.gen_xml_data_dunning(p_request_id => l_req_id,

Line 2188: FND_FILE.PUT_LINE(FND_FILE.LOG, 'collections_methods : '|| l_collections_method);

2184: OPEN c_collections_method;
2185: FETCH c_collections_method INTO l_collections_method;
2186: close c_collections_method;
2187:
2188: FND_FILE.PUT_LINE(FND_FILE.LOG, 'collections_methods : '|| l_collections_method);
2189: l_org_id := mo_global.get_current_org_id;
2190:
2191: if l_collections_method = 'STRATEGIES' then
2192: l_org_id_coll_method := 'ERROR'; -- This is to end send dunning cp from running if collections method is strategies

Line 2193: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Concurrent program failed to run as collections method is set up as strategies');

2189: l_org_id := mo_global.get_current_org_id;
2190:
2191: if l_collections_method = 'STRATEGIES' then
2192: l_org_id_coll_method := 'ERROR'; -- This is to end send dunning cp from running if collections method is strategies
2193: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Concurrent program failed to run as collections method is set up as strategies');
2194: l_con_update_re_st := fnd_concurrent.set_completion_status (status => 'WARNING',
2195:
2196: message => 'Concurrent program failed to run as collections method is set up as strategies');
2197:

Line 2240: FND_FILE.PUT_LINE(FND_FILE.LOG, 'This opearting unit is not registered.Please check setup');

2236: FETCH C_org_id_coll_method INTO l_org_id_coll_method;
2237: if (C_org_id_coll_method%NOTFOUND) then
2238: WriteLog(G_PKG_NAME || ' ' || l_api_name || 'C_org_id_coll_method%NOTFOUND ');
2239: l_org_id_coll_method := 'Unregistered';
2240: FND_FILE.PUT_LINE(FND_FILE.LOG, 'This opearting unit is not registered.Please check setup');
2241: l_con_update_re_st := fnd_concurrent.set_completion_status (status => 'WARNING',
2242:
2243: message => 'This opearting unit is not registered.Please check setup');
2244: end if;

Line 2248: FND_FILE.PUT_LINE(FND_FILE.LOG, 'This opearting unit is not setup for dunning.Please check setup');

2244: end if;
2245: close C_org_id_coll_method;
2246:
2247: if l_org_id_coll_method <> 'DUNNING' then
2248: FND_FILE.PUT_LINE(FND_FILE.LOG, 'This opearting unit is not setup for dunning.Please check setup');
2249: l_con_update_re_st := fnd_concurrent.set_completion_status (status => 'WARNING',
2250:
2251: message => 'Opearting Unit is Not Setup for Dunning please check Setup');
2252:

Line 2300: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'chk bucket');

2296: fetch c_dunning_type into l_dunning_type;
2297: close c_dunning_type;
2298: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_dunning_type ' || l_dunning_type);
2299:
2300: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'chk bucket');
2301: OPEN C_Get_Level (dunning_plan_id);
2302: FETCH C_Get_Level INTO l_running_level;
2303:
2304: IF (C_Get_Level%NOTFOUND)

Line 2310: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'running level='||l_running_level);

2306: l_error := 1;
2307: END IF;
2308: CLOSE C_GET_LEVEL;
2309:
2310: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'running level='||l_running_level);
2311: WriteLog('Send_Dunning: ' || G_PKG_NAME || ' ' || l_api_name || ' - running level='||l_running_level);
2312: --start bug 15933013
2313: l_cust_prof_chk := fnd_profile.value('IEX_DUNNING_CUST_PROF_CHECK');
2314: if l_cust_prof_chk is NULL then

Line 2324: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Profile - IEX: Minimum Dunning Amount Profile Check= '||l_cust_prof_chk);

2320: end if;
2321:
2322: if (l_dunning_type= 'DAYS_OVERDUE' and l_running_level='ACCOUNT')
2323: and (l_cust_prof_chk = 'BILL_TO' or l_cust_prof_chk = 'BILLTOACCOUNT') then
2324: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Profile - IEX: Minimum Dunning Amount Profile Check= '||l_cust_prof_chk);
2325: FND_FILE.PUT_LINE(FND_FILE.LOG, ' When Dunning level is Account, value of profile "IEX: Minimum Dunning Amount Profile Check" can''t be "Bill To" or "Bill To and Account". ');
2326: l_con_update_re_st := fnd_concurrent.set_completion_status (status => 'ERROR',
2327: message => ' When Dunning level is Account, value of profile "IEX: Minimum Dunning Amount Profile Check" can''t be "Bill To" or "Bill To and Account". ');
2328: retcode := FND_API.G_RET_STS_ERROR;

Line 2325: FND_FILE.PUT_LINE(FND_FILE.LOG, ' When Dunning level is Account, value of profile "IEX: Minimum Dunning Amount Profile Check" can''t be "Bill To" or "Bill To and Account". ');

2321:
2322: if (l_dunning_type= 'DAYS_OVERDUE' and l_running_level='ACCOUNT')
2323: and (l_cust_prof_chk = 'BILL_TO' or l_cust_prof_chk = 'BILLTOACCOUNT') then
2324: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Profile - IEX: Minimum Dunning Amount Profile Check= '||l_cust_prof_chk);
2325: FND_FILE.PUT_LINE(FND_FILE.LOG, ' When Dunning level is Account, value of profile "IEX: Minimum Dunning Amount Profile Check" can''t be "Bill To" or "Bill To and Account". ');
2326: l_con_update_re_st := fnd_concurrent.set_completion_status (status => 'ERROR',
2327: message => ' When Dunning level is Account, value of profile "IEX: Minimum Dunning Amount Profile Check" can''t be "Bill To" or "Bill To and Account". ');
2328: retcode := FND_API.G_RET_STS_ERROR;
2329: Return;

Line 2346: FND_FILE.PUT_LINE(FND_FILE.LOG, 'no running level');

2342: ( p_count => l_msg_count,
2343: p_data => l_msg_data
2344: );
2345:
2346: FND_FILE.PUT_LINE(FND_FILE.LOG, 'no running level');
2347: errbuf := l_msg_data;
2348: retcode := '2';
2349: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - errbuf='||errbuf);
2350:

Line 2354: FND_FILE.PUT_LINE(FND_FILE.LOG, errmsg);

2350:
2351: for i in 1..l_msg_count loop
2352: errmsg := FND_MSG_PUB.Get(p_msg_index => i,
2353: p_encoded => 'F');
2354: FND_FILE.PUT_LINE(FND_FILE.LOG, errmsg);
2355: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - errmsg='||errmsg);
2356: end loop;
2357: --
2358: else

Line 2360: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'running level='||l_running_level);

2356: end loop;
2357: --
2358: else
2359:
2360: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'running level='||l_running_level);
2361: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'chk bucket');
2362: OPEN C_Get_Bucket (dunning_plan_id) ;
2363: FETCH C_Get_Bucket INTO l_bucket;
2364:

Line 2361: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'chk bucket');

2357: --
2358: else
2359:
2360: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'running level='||l_running_level);
2361: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'chk bucket');
2362: OPEN C_Get_Bucket (dunning_plan_id) ;
2363: FETCH C_Get_Bucket INTO l_bucket;
2364:
2365: IF (C_Get_Bucket%NOTFOUND) THEN

Line 2370: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'Aging Bucket='||l_bucket);

2366: l_error := 1;
2367: END IF;
2368: CLOSE C_GET_Bucket;
2369:
2370: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'Aging Bucket='||l_bucket);
2371: WriteLog('Send_Dunning: ' || G_PKG_NAME || ' ' || l_api_name || ' - bucket='||l_bucket);
2372:
2373: IF (l_bucket is null or l_error = 1) and (l_dunning_type <> 'STAGED_DUNNING') then
2374: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - no bucket');

Line 2385: FND_FILE.PUT_LINE(FND_FILE.LOG, 'no bucket');

2381: ( p_count => l_msg_count,
2382: p_data => l_msg_data
2383: );
2384:
2385: FND_FILE.PUT_LINE(FND_FILE.LOG, 'no bucket');
2386: errbuf := l_msg_data;
2387: retcode := '2';
2388: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - errbuf='||errbuf);
2389:

Line 2393: FND_FILE.PUT_LINE(FND_FILE.LOG, errmsg);

2389:
2390: for i in 1..l_msg_count loop
2391: errmsg := FND_MSG_PUB.Get(p_msg_index => i,
2392: p_encoded => 'F');
2393: FND_FILE.PUT_LINE(FND_FILE.LOG, errmsg);
2394: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - errmsg='||errmsg);
2395: end loop;
2396:
2397: --

Line 2401: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Dunning Running Level='||l_running_level);

2397: --
2398: ELSE
2399: -- Now, RunningLevel and Bucket are not null;
2400:
2401: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Dunning Running Level='||l_running_level);
2402: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Dunning Aging Bucket='||l_bucket);
2403: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Start Send_Dunning');
2404: -- IF PG_DEBUG < 10 THEN
2405: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 2402: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Dunning Aging Bucket='||l_bucket);

2398: ELSE
2399: -- Now, RunningLevel and Bucket are not null;
2400:
2401: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Dunning Running Level='||l_running_level);
2402: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Dunning Aging Bucket='||l_bucket);
2403: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Start Send_Dunning');
2404: -- IF PG_DEBUG < 10 THEN
2405: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2406: iex_debug_pub.LogMessage(G_PKG_NAME || ' ' || l_api_name || ' - runninglevel='||l_running_level);

Line 2403: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Start Send_Dunning');

2399: -- Now, RunningLevel and Bucket are not null;
2400:
2401: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Dunning Running Level='||l_running_level);
2402: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Dunning Aging Bucket='||l_bucket);
2403: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Start Send_Dunning');
2404: -- IF PG_DEBUG < 10 THEN
2405: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2406: iex_debug_pub.LogMessage(G_PKG_NAME || ' ' || l_api_name || ' - runninglevel='||l_running_level);
2407: iex_debug_pub.LogMessage(G_PKG_NAME || ' ' || l_api_name || ' - bucket='||l_bucket);

Line 2437: FND_FILE.PUT_LINE(FND_FILE.LOG, 'return_status='||retcode);

2433: , x_msg_count => l_msg_count
2434: , x_msg_data => ERRBUF
2435: );
2436:
2437: FND_FILE.PUT_LINE(FND_FILE.LOG, 'return_status='||retcode);
2438: -- IF PG_DEBUG < 10 THEN
2439: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2440: iex_debug_pub.LogMessage(G_PKG_NAME || ' ' || l_api_name || ' - status='||retcode);
2441: END IF;

Line 2456: FND_FILE.PUT_LINE(FND_FILE.LOG, errmsg);

2452:
2453: for i in 1..l_msg_count loop
2454: errmsg := FND_MSG_PUB.Get(p_msg_index => i,
2455: p_encoded => 'F');
2456: FND_FILE.PUT_LINE(FND_FILE.LOG, errmsg);
2457: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - errmsg='||errmsg);
2458: end loop;
2459: END IF;
2460:

Line 2469: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);

2465: EXCEPTION
2466: WHEN OTHERS THEN
2467: retcode := '2'; --FND_API.G_RET_STS_UNEXP_ERROR;
2468: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - errbuf='||SQLERRM);
2469: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);
2470:
2471: END SEND_DUNNING_CONCUR;
2472:
2473: --Start for bug 9582646 gnramasa 5th May 10

Line 2586: FND_FILE.PUT_LINE(FND_FILE.LOG, 'SEND_DUNNING_CONCUR p_migration_mode = ' || p_migration_mode);

2582: BEGIN
2583:
2584: l_api_name := 'STG_DUNNING_MIG_CONCUR';
2585: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - start');
2586: FND_FILE.PUT_LINE(FND_FILE.LOG, 'SEND_DUNNING_CONCUR p_migration_mode = ' || p_migration_mode);
2587: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' p_migration_mode : ' || p_migration_mode);
2588: l_migration_mode := nvl(p_migration_mode,'FINAL');
2589:
2590: l_migrated_data := nvl(fnd_profile.value('AR_DUNNING_TO_IEXDUNNING_MIGRATED'), 'Y');

Line 2592: FND_FILE.PUT_LINE(FND_FILE.LOG, 'SEND_DUNNING_CONCUR l_migrated_data = ' || l_migrated_data);

2588: l_migration_mode := nvl(p_migration_mode,'FINAL');
2589:
2590: l_migrated_data := nvl(fnd_profile.value('AR_DUNNING_TO_IEXDUNNING_MIGRATED'), 'Y');
2591:
2592: FND_FILE.PUT_LINE(FND_FILE.LOG, 'SEND_DUNNING_CONCUR l_migrated_data = ' || l_migrated_data);
2593:
2594: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' l_migrated_data : ' || l_migrated_data);
2595:
2596: open c_business_level;

Line 2600: FND_FILE.PUT_LINE(FND_FILE.LOG, 'SEND_DUNNING_CONCUR l_business_level = ' || l_business_level);

2596: open c_business_level;
2597: fetch c_business_level into l_business_level;
2598: close c_business_level;
2599:
2600: FND_FILE.PUT_LINE(FND_FILE.LOG, 'SEND_DUNNING_CONCUR l_business_level = ' || l_business_level);
2601:
2602: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' l_business_level : ' || l_business_level);
2603:
2604: if l_business_level = 'CUSTOMER' then

Line 2624: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

2620: if l_migration_mode = 'FINAL' then
2621: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - CP submitted in FINAL mode. So records will be migrated.');
2622: if l_migrated_data = 'N' then
2623:
2624: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2625: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2626: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Profile ''IEX: AR Dunning to IEX Dunning Migrated?'' value is No. So data will get migrated. *');
2627: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2628:

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

2621: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - CP submitted in FINAL mode. So records will be migrated.');
2622: if l_migrated_data = 'N' then
2623:
2624: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2625: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2626: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Profile ''IEX: AR Dunning to IEX Dunning Migrated?'' value is No. So data will get migrated. *');
2627: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2628:
2629: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - End dating the previously migrated dunning letter sets.');

Line 2626: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Profile ''IEX: AR Dunning to IEX Dunning Migrated?'' value is No. So data will get migrated. *');

2622: if l_migrated_data = 'N' then
2623:
2624: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2625: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2626: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Profile ''IEX: AR Dunning to IEX Dunning Migrated?'' value is No. So data will get migrated. *');
2627: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2628:
2629: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - End dating the previously migrated dunning letter sets.');
2630: UPDATE IEX_DUNNING_PLANS_B

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

2623:
2624: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2625: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2626: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Profile ''IEX: AR Dunning to IEX Dunning Migrated?'' value is No. So data will get migrated. *');
2627: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2628:
2629: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - End dating the previously migrated dunning letter sets.');
2630: UPDATE IEX_DUNNING_PLANS_B
2631: SET LAST_UPDATE_DATE = sysdate,

Line 2639: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

2635: ENABLED_FLAG = 'N'
2636: WHERE MIG_DUNNING_LETTER_SET_ID is not null
2637: AND (ENABLED_FLAG = 'Y' OR END_DATE IS NULL);
2638:
2639: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2640: FND_FILE.PUT_LINE(FND_FILE.LOG, '1. End dated the previously migrated dunning letter sets.');
2641:
2642: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2643: FND_FILE.PUT_LINE(FND_FILE.LOG, '2. Following Dunning letter sets are migrated as Dunning plans from AR to Advanced Collections');

Line 2640: FND_FILE.PUT_LINE(FND_FILE.LOG, '1. End dated the previously migrated dunning letter sets.');

2636: WHERE MIG_DUNNING_LETTER_SET_ID is not null
2637: AND (ENABLED_FLAG = 'Y' OR END_DATE IS NULL);
2638:
2639: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2640: FND_FILE.PUT_LINE(FND_FILE.LOG, '1. End dated the previously migrated dunning letter sets.');
2641:
2642: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2643: FND_FILE.PUT_LINE(FND_FILE.LOG, '2. Following Dunning letter sets are migrated as Dunning plans from AR to Advanced Collections');
2644: begin

Line 2642: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

2638:
2639: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2640: FND_FILE.PUT_LINE(FND_FILE.LOG, '1. End dated the previously migrated dunning letter sets.');
2641:
2642: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2643: FND_FILE.PUT_LINE(FND_FILE.LOG, '2. Following Dunning letter sets are migrated as Dunning plans from AR to Advanced Collections');
2644: begin
2645:
2646: for dunn_letter_set_rec in c_dunning_letter_sets

Line 2643: FND_FILE.PUT_LINE(FND_FILE.LOG, '2. Following Dunning letter sets are migrated as Dunning plans from AR to Advanced Collections');

2639: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2640: FND_FILE.PUT_LINE(FND_FILE.LOG, '1. End dated the previously migrated dunning letter sets.');
2641:
2642: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2643: FND_FILE.PUT_LINE(FND_FILE.LOG, '2. Following Dunning letter sets are migrated as Dunning plans from AR to Advanced Collections');
2644: begin
2645:
2646: for dunn_letter_set_rec in c_dunning_letter_sets
2647: loop

Line 2721: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Language code ' || fnd_languages.language_code);

2717: dunn_letter_set_rec.creation_date,
2718: dunn_letter_set_rec.last_update_date,
2719: dunn_letter_set_rec.last_updated_by,
2720: dunn_letter_set_rec.last_update_login);
2721: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Language code ' || fnd_languages.language_code);
2722: END LOOP;
2723: l_output_string := ' Dunning_plan_id : ' || rpad(l_dunning_plan_id, 20, ' ') || ' Name: ' || rpad(dunn_letter_set_rec.name, 30, ' ') || ' Description: ' || rpad(dunn_letter_set_rec.description, 50, ' ');
2724: FND_FILE.PUT_LINE(FND_FILE.LOG, l_output_string);
2725:

Line 2724: FND_FILE.PUT_LINE(FND_FILE.LOG, l_output_string);

2720: dunn_letter_set_rec.last_update_login);
2721: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Language code ' || fnd_languages.language_code);
2722: END LOOP;
2723: l_output_string := ' Dunning_plan_id : ' || rpad(l_dunning_plan_id, 20, ' ') || ' Name: ' || rpad(dunn_letter_set_rec.name, 30, ' ') || ' Description: ' || rpad(dunn_letter_set_rec.description, 50, ' ');
2724: FND_FILE.PUT_LINE(FND_FILE.LOG, l_output_string);
2725:
2726: for dunn_letter_set_lines_rec in c_dunning_letter_set_lines (l_dunning_letter_set_id)
2727: loop
2728: --Start bug 9725204 gnramasa 19th May 10

Line 2795: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);

2791:
2792: exception
2793: WHEN OTHERS THEN
2794: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - errbuf='||SQLERRM);
2795: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);
2796: end ;
2797: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2798:
2799: l_staged_dunning_level.delete;

Line 2797: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

2793: WHEN OTHERS THEN
2794: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - errbuf='||SQLERRM);
2795: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);
2796: end ;
2797: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2798:
2799: l_staged_dunning_level.delete;
2800: l_payment_schedule_id.delete;
2801: --Copy the Staged level of an Invoice from AR_PAYMENT_SCHEDULES_ALL table to IEX_DELINQUENCIES_ALL table.

Line 2814: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

2810: IF l_staged_dunning_level.count = 0 THEN
2811:
2812: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - No of rows updated in iex_delinquencies_all is: ' || l_no_updated_rows);
2813: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Exit after Updating iex_delinquencies_all staged_dunning_level...');
2814: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2815: FND_FILE.PUT_LINE(FND_FILE.LOG, '3. Copied Transaction''s stage level from AR to Advanced Collections. No of rows updated in iex_delinquencies_all table is: ' || l_no_updated_rows);
2816: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2817: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Used the following SQL to copy the Transaction''s stage level from AR to Advanced Collections.');
2818: FND_FILE.PUT_LINE(FND_FILE.LOG, ' UPDATE IEX_DELINQUENCIES_ALL IEX ');

Line 2815: FND_FILE.PUT_LINE(FND_FILE.LOG, '3. Copied Transaction''s stage level from AR to Advanced Collections. No of rows updated in iex_delinquencies_all table is: ' || l_no_updated_rows);

2811:
2812: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - No of rows updated in iex_delinquencies_all is: ' || l_no_updated_rows);
2813: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Exit after Updating iex_delinquencies_all staged_dunning_level...');
2814: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2815: FND_FILE.PUT_LINE(FND_FILE.LOG, '3. Copied Transaction''s stage level from AR to Advanced Collections. No of rows updated in iex_delinquencies_all table is: ' || l_no_updated_rows);
2816: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2817: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Used the following SQL to copy the Transaction''s stage level from AR to Advanced Collections.');
2818: FND_FILE.PUT_LINE(FND_FILE.LOG, ' UPDATE IEX_DELINQUENCIES_ALL IEX ');
2819: FND_FILE.PUT_LINE(FND_FILE.LOG, ' SET STAGED_DUNNING_LEVEL = l_staged_dunning_level (I) ');

Line 2816: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

2812: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - No of rows updated in iex_delinquencies_all is: ' || l_no_updated_rows);
2813: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Exit after Updating iex_delinquencies_all staged_dunning_level...');
2814: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2815: FND_FILE.PUT_LINE(FND_FILE.LOG, '3. Copied Transaction''s stage level from AR to Advanced Collections. No of rows updated in iex_delinquencies_all table is: ' || l_no_updated_rows);
2816: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2817: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Used the following SQL to copy the Transaction''s stage level from AR to Advanced Collections.');
2818: FND_FILE.PUT_LINE(FND_FILE.LOG, ' UPDATE IEX_DELINQUENCIES_ALL IEX ');
2819: FND_FILE.PUT_LINE(FND_FILE.LOG, ' SET STAGED_DUNNING_LEVEL = l_staged_dunning_level (I) ');
2820: FND_FILE.PUT_LINE(FND_FILE.LOG, ' WHERE PAYMENT_SCHEDULE_ID = l_payment_schedule_id(I); ');

Line 2817: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Used the following SQL to copy the Transaction''s stage level from AR to Advanced Collections.');

2813: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Exit after Updating iex_delinquencies_all staged_dunning_level...');
2814: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2815: FND_FILE.PUT_LINE(FND_FILE.LOG, '3. Copied Transaction''s stage level from AR to Advanced Collections. No of rows updated in iex_delinquencies_all table is: ' || l_no_updated_rows);
2816: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2817: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Used the following SQL to copy the Transaction''s stage level from AR to Advanced Collections.');
2818: FND_FILE.PUT_LINE(FND_FILE.LOG, ' UPDATE IEX_DELINQUENCIES_ALL IEX ');
2819: FND_FILE.PUT_LINE(FND_FILE.LOG, ' SET STAGED_DUNNING_LEVEL = l_staged_dunning_level (I) ');
2820: FND_FILE.PUT_LINE(FND_FILE.LOG, ' WHERE PAYMENT_SCHEDULE_ID = l_payment_schedule_id(I); ');
2821: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

Line 2818: FND_FILE.PUT_LINE(FND_FILE.LOG, ' UPDATE IEX_DELINQUENCIES_ALL IEX ');

2814: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2815: FND_FILE.PUT_LINE(FND_FILE.LOG, '3. Copied Transaction''s stage level from AR to Advanced Collections. No of rows updated in iex_delinquencies_all table is: ' || l_no_updated_rows);
2816: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2817: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Used the following SQL to copy the Transaction''s stage level from AR to Advanced Collections.');
2818: FND_FILE.PUT_LINE(FND_FILE.LOG, ' UPDATE IEX_DELINQUENCIES_ALL IEX ');
2819: FND_FILE.PUT_LINE(FND_FILE.LOG, ' SET STAGED_DUNNING_LEVEL = l_staged_dunning_level (I) ');
2820: FND_FILE.PUT_LINE(FND_FILE.LOG, ' WHERE PAYMENT_SCHEDULE_ID = l_payment_schedule_id(I); ');
2821: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2822:

Line 2819: FND_FILE.PUT_LINE(FND_FILE.LOG, ' SET STAGED_DUNNING_LEVEL = l_staged_dunning_level (I) ');

2815: FND_FILE.PUT_LINE(FND_FILE.LOG, '3. Copied Transaction''s stage level from AR to Advanced Collections. No of rows updated in iex_delinquencies_all table is: ' || l_no_updated_rows);
2816: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2817: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Used the following SQL to copy the Transaction''s stage level from AR to Advanced Collections.');
2818: FND_FILE.PUT_LINE(FND_FILE.LOG, ' UPDATE IEX_DELINQUENCIES_ALL IEX ');
2819: FND_FILE.PUT_LINE(FND_FILE.LOG, ' SET STAGED_DUNNING_LEVEL = l_staged_dunning_level (I) ');
2820: FND_FILE.PUT_LINE(FND_FILE.LOG, ' WHERE PAYMENT_SCHEDULE_ID = l_payment_schedule_id(I); ');
2821: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2822:
2823: CLOSE c_staged_dunning_level;

Line 2820: FND_FILE.PUT_LINE(FND_FILE.LOG, ' WHERE PAYMENT_SCHEDULE_ID = l_payment_schedule_id(I); ');

2816: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2817: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Used the following SQL to copy the Transaction''s stage level from AR to Advanced Collections.');
2818: FND_FILE.PUT_LINE(FND_FILE.LOG, ' UPDATE IEX_DELINQUENCIES_ALL IEX ');
2819: FND_FILE.PUT_LINE(FND_FILE.LOG, ' SET STAGED_DUNNING_LEVEL = l_staged_dunning_level (I) ');
2820: FND_FILE.PUT_LINE(FND_FILE.LOG, ' WHERE PAYMENT_SCHEDULE_ID = l_payment_schedule_id(I); ');
2821: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2822:
2823: CLOSE c_staged_dunning_level;
2824: EXIT;

Line 2821: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

2817: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Used the following SQL to copy the Transaction''s stage level from AR to Advanced Collections.');
2818: FND_FILE.PUT_LINE(FND_FILE.LOG, ' UPDATE IEX_DELINQUENCIES_ALL IEX ');
2819: FND_FILE.PUT_LINE(FND_FILE.LOG, ' SET STAGED_DUNNING_LEVEL = l_staged_dunning_level (I) ');
2820: FND_FILE.PUT_LINE(FND_FILE.LOG, ' WHERE PAYMENT_SCHEDULE_ID = l_payment_schedule_id(I); ');
2821: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2822:
2823: CLOSE c_staged_dunning_level;
2824: EXIT;
2825: ELSE

Line 2839: FND_FILE.PUT_LINE(FND_FILE.LOG, '3. Copied Transactions stage level from AR to Advanced Collections');

2835:
2836: commit;
2837:
2838: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' Rows updated in iex_delinquencies_all staged_dunning_level...');
2839: FND_FILE.PUT_LINE(FND_FILE.LOG, '3. Copied Transactions stage level from AR to Advanced Collections');
2840: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2841:
2842: END IF;
2843: END LOOP;

Line 2840: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

2836: commit;
2837:
2838: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' Rows updated in iex_delinquencies_all staged_dunning_level...');
2839: FND_FILE.PUT_LINE(FND_FILE.LOG, '3. Copied Transactions stage level from AR to Advanced Collections');
2840: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2841:
2842: END IF;
2843: END LOOP;
2844: EXCEPTION

Line 2847: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);

2843: END LOOP;
2844: EXCEPTION
2845: WHEN OTHERS THEN
2846: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - errbuf='||SQLERRM);
2847: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);
2848: END;
2849:
2850: --Update dunning_type as 'DAYS_OVERDUE' for existing records in IEX_DUNNING_PLANS_B table.
2851: update iex_dunning_plans_b

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

2875: x_level_value_app_id => '',
2876: x_level_value2 => null);
2877: if l_return then
2878: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Profile IEX: AR Dunning to IEX Dunning Migrated? value updated with Y ');
2879: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2880: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Dunning letter sets are migrated successfully and assigned Profile ''IEX: AR Dunning to IEX Dunning Migrated?'' with value Yes. *');
2881: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2882: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2883: else

Line 2880: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Dunning letter sets are migrated successfully and assigned Profile ''IEX: AR Dunning to IEX Dunning Migrated?'' with value Yes. *');

2876: x_level_value2 => null);
2877: if l_return then
2878: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Profile IEX: AR Dunning to IEX Dunning Migrated? value updated with Y ');
2879: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2880: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Dunning letter sets are migrated successfully and assigned Profile ''IEX: AR Dunning to IEX Dunning Migrated?'' with value Yes. *');
2881: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2882: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2883: else
2884: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Profile IEX: AR Dunning to IEX Dunning Migrated? updated failed ');

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

2877: if l_return then
2878: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Profile IEX: AR Dunning to IEX Dunning Migrated? value updated with Y ');
2879: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2880: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Dunning letter sets are migrated successfully and assigned Profile ''IEX: AR Dunning to IEX Dunning Migrated?'' with value Yes. *');
2881: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2882: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2883: else
2884: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Profile IEX: AR Dunning to IEX Dunning Migrated? updated failed ');
2885: end if;

Line 2882: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

2878: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Profile IEX: AR Dunning to IEX Dunning Migrated? value updated with Y ');
2879: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2880: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Dunning letter sets are migrated successfully and assigned Profile ''IEX: AR Dunning to IEX Dunning Migrated?'' with value Yes. *');
2881: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2882: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2883: else
2884: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Profile IEX: AR Dunning to IEX Dunning Migrated? updated failed ');
2885: end if;
2886:

Line 2888: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

2884: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Profile IEX: AR Dunning to IEX Dunning Migrated? updated failed ');
2885: end if;
2886:
2887: else
2888: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2889: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2890: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Profile ''IEX: AR Dunning to IEX Dunning Migrated?'' value is Yes. So data will not get migrated. *');
2891: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2892: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

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

2885: end if;
2886:
2887: else
2888: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2889: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2890: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Profile ''IEX: AR Dunning to IEX Dunning Migrated?'' value is Yes. So data will not get migrated. *');
2891: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2892: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2893: FND_FILE.PUT_LINE(FND_FILE.LOG, '1. Following Dunning letter sets are already migrated as Dunning plans from AR to Advanced Collections');

Line 2890: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Profile ''IEX: AR Dunning to IEX Dunning Migrated?'' value is Yes. So data will not get migrated. *');

2886:
2887: else
2888: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2889: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2890: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Profile ''IEX: AR Dunning to IEX Dunning Migrated?'' value is Yes. So data will not get migrated. *');
2891: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2892: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2893: FND_FILE.PUT_LINE(FND_FILE.LOG, '1. Following Dunning letter sets are already migrated as Dunning plans from AR to Advanced Collections');
2894:

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

2887: else
2888: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2889: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2890: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Profile ''IEX: AR Dunning to IEX Dunning Migrated?'' value is Yes. So data will not get migrated. *');
2891: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2892: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2893: FND_FILE.PUT_LINE(FND_FILE.LOG, '1. Following Dunning letter sets are already migrated as Dunning plans from AR to Advanced Collections');
2894:
2895: for v_c_migrated_dunn_letter_sets in c_migrated_dunn_letter_sets

Line 2892: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

2888: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2889: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2890: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Profile ''IEX: AR Dunning to IEX Dunning Migrated?'' value is Yes. So data will not get migrated. *');
2891: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2892: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2893: FND_FILE.PUT_LINE(FND_FILE.LOG, '1. Following Dunning letter sets are already migrated as Dunning plans from AR to Advanced Collections');
2894:
2895: for v_c_migrated_dunn_letter_sets in c_migrated_dunn_letter_sets
2896: loop

Line 2893: FND_FILE.PUT_LINE(FND_FILE.LOG, '1. Following Dunning letter sets are already migrated as Dunning plans from AR to Advanced Collections');

2889: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2890: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Profile ''IEX: AR Dunning to IEX Dunning Migrated?'' value is Yes. So data will not get migrated. *');
2891: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2892: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2893: FND_FILE.PUT_LINE(FND_FILE.LOG, '1. Following Dunning letter sets are already migrated as Dunning plans from AR to Advanced Collections');
2894:
2895: for v_c_migrated_dunn_letter_sets in c_migrated_dunn_letter_sets
2896: loop
2897: l_rec_exists := 'Y'; --at least one record exists

Line 2901: FND_FILE.PUT_LINE(FND_FILE.LOG, l_output_string);

2897: l_rec_exists := 'Y'; --at least one record exists
2898: l_output_string := ' Dunning_plan_id : ' || rpad(v_c_migrated_dunn_letter_sets.dunning_plan_id, 12, ' ')|| ' Business level: ' || rpad(v_c_migrated_dunn_letter_sets.dunning_level, 11, ' ');
2899: l_output_string := l_output_string || ' Name: ' || rpad(v_c_migrated_dunn_letter_sets.name, 30, ' ') || ' Description: ' || rpad(v_c_migrated_dunn_letter_sets.description, 50, ' ') ;
2900: l_output_string := l_output_string || ' Dunning_letter_set_id: ' || rpad(v_c_migrated_dunn_letter_sets.mig_dunning_letter_set_id, 20, ' ');
2901: FND_FILE.PUT_LINE(FND_FILE.LOG, l_output_string);
2902: end loop;
2903:
2904: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2905: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');

Line 2904: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

2900: l_output_string := l_output_string || ' Dunning_letter_set_id: ' || rpad(v_c_migrated_dunn_letter_sets.mig_dunning_letter_set_id, 20, ' ');
2901: FND_FILE.PUT_LINE(FND_FILE.LOG, l_output_string);
2902: end loop;
2903:
2904: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2905: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2906: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Profile IEX: AR Dunning to IEX Dunning Migrated? value is Yes. So data will not get migrated. *');
2907: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Set Profile value as No at Site level and run the concurrent program again to re-migrate the dunning letter sets. *');
2908: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');

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

2901: FND_FILE.PUT_LINE(FND_FILE.LOG, l_output_string);
2902: end loop;
2903:
2904: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2905: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2906: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Profile IEX: AR Dunning to IEX Dunning Migrated? value is Yes. So data will not get migrated. *');
2907: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Set Profile value as No at Site level and run the concurrent program again to re-migrate the dunning letter sets. *');
2908: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2909: end if;

Line 2906: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Profile IEX: AR Dunning to IEX Dunning Migrated? value is Yes. So data will not get migrated. *');

2902: end loop;
2903:
2904: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2905: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2906: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Profile IEX: AR Dunning to IEX Dunning Migrated? value is Yes. So data will not get migrated. *');
2907: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Set Profile value as No at Site level and run the concurrent program again to re-migrate the dunning letter sets. *');
2908: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2909: end if;
2910: else --DRAFT mode

Line 2907: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Set Profile value as No at Site level and run the concurrent program again to re-migrate the dunning letter sets. *');

2903:
2904: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2905: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2906: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Profile IEX: AR Dunning to IEX Dunning Migrated? value is Yes. So data will not get migrated. *');
2907: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Set Profile value as No at Site level and run the concurrent program again to re-migrate the dunning letter sets. *');
2908: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2909: end if;
2910: else --DRAFT mode
2911: if l_migrated_data = 'N' then

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

2904: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2905: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2906: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Profile IEX: AR Dunning to IEX Dunning Migrated? value is Yes. So data will not get migrated. *');
2907: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Set Profile value as No at Site level and run the concurrent program again to re-migrate the dunning letter sets. *');
2908: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2909: end if;
2910: else --DRAFT mode
2911: if l_migrated_data = 'N' then
2912: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

Line 2912: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

2908: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2909: end if;
2910: else --DRAFT mode
2911: if l_migrated_data = 'N' then
2912: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2913: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2914: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Profile ''IEX: AR Dunning to IEX Dunning Migrated?'' value is No. *');
2915: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2916: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

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

2909: end if;
2910: else --DRAFT mode
2911: if l_migrated_data = 'N' then
2912: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2913: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2914: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Profile ''IEX: AR Dunning to IEX Dunning Migrated?'' value is No. *');
2915: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2916: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2917: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');

Line 2914: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Profile ''IEX: AR Dunning to IEX Dunning Migrated?'' value is No. *');

2910: else --DRAFT mode
2911: if l_migrated_data = 'N' then
2912: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2913: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2914: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Profile ''IEX: AR Dunning to IEX Dunning Migrated?'' value is No. *');
2915: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2916: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2917: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2918: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Concurrent program has been submitted in DRAFT mode. So data will not get migrated. *');

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

2911: if l_migrated_data = 'N' then
2912: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2913: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2914: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Profile ''IEX: AR Dunning to IEX Dunning Migrated?'' value is No. *');
2915: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2916: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2917: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2918: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Concurrent program has been submitted in DRAFT mode. So data will not get migrated. *');
2919: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Following dunning letter sets will get migrated by running the concurrent program in FINAL mode. *');

Line 2916: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

2912: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2913: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2914: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Profile ''IEX: AR Dunning to IEX Dunning Migrated?'' value is No. *');
2915: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2916: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2917: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2918: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Concurrent program has been submitted in DRAFT mode. So data will not get migrated. *');
2919: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Following dunning letter sets will get migrated by running the concurrent program in FINAL mode. *');
2920: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');

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

2913: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2914: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Profile ''IEX: AR Dunning to IEX Dunning Migrated?'' value is No. *');
2915: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2916: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2917: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2918: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Concurrent program has been submitted in DRAFT mode. So data will not get migrated. *');
2919: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Following dunning letter sets will get migrated by running the concurrent program in FINAL mode. *');
2920: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2921:

Line 2918: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Concurrent program has been submitted in DRAFT mode. So data will not get migrated. *');

2914: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Profile ''IEX: AR Dunning to IEX Dunning Migrated?'' value is No. *');
2915: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2916: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2917: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2918: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Concurrent program has been submitted in DRAFT mode. So data will not get migrated. *');
2919: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Following dunning letter sets will get migrated by running the concurrent program in FINAL mode. *');
2920: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2921:
2922: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

Line 2919: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Following dunning letter sets will get migrated by running the concurrent program in FINAL mode. *');

2915: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2916: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2917: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2918: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Concurrent program has been submitted in DRAFT mode. So data will not get migrated. *');
2919: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Following dunning letter sets will get migrated by running the concurrent program in FINAL mode. *');
2920: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2921:
2922: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2923: --FND_FILE.PUT_LINE(FND_FILE.LOG, '1. Following Dunning letter sets will be picked for data migration.');

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

2916: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2917: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2918: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Concurrent program has been submitted in DRAFT mode. So data will not get migrated. *');
2919: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Following dunning letter sets will get migrated by running the concurrent program in FINAL mode. *');
2920: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2921:
2922: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2923: --FND_FILE.PUT_LINE(FND_FILE.LOG, '1. Following Dunning letter sets will be picked for data migration.');
2924:

Line 2922: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

2918: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Concurrent program has been submitted in DRAFT mode. So data will not get migrated. *');
2919: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Following dunning letter sets will get migrated by running the concurrent program in FINAL mode. *');
2920: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2921:
2922: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2923: --FND_FILE.PUT_LINE(FND_FILE.LOG, '1. Following Dunning letter sets will be picked for data migration.');
2924:
2925: for v_c_dunning_letter_sets in c_dunning_letter_sets
2926: loop

Line 2923: --FND_FILE.PUT_LINE(FND_FILE.LOG, '1. Following Dunning letter sets will be picked for data migration.');

2919: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Following dunning letter sets will get migrated by running the concurrent program in FINAL mode. *');
2920: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2921:
2922: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2923: --FND_FILE.PUT_LINE(FND_FILE.LOG, '1. Following Dunning letter sets will be picked for data migration.');
2924:
2925: for v_c_dunning_letter_sets in c_dunning_letter_sets
2926: loop
2927: l_rec_exists := 'Y'; --at least one record exists

Line 2930: FND_FILE.PUT_LINE(FND_FILE.LOG, l_output_string);

2926: loop
2927: l_rec_exists := 'Y'; --at least one record exists
2928: l_output_string := ' Dunning_letter_set_id: ' || rpad(v_c_dunning_letter_sets.dunning_letter_set_id, 12, ' ') || ' Name: ' || rpad(v_c_dunning_letter_sets.name, 30, ' ') ;
2929: l_output_string := l_output_string || ' Description: ' || rpad(v_c_dunning_letter_sets.description, 50, ' ');
2930: FND_FILE.PUT_LINE(FND_FILE.LOG, l_output_string);
2931: end loop;
2932: else
2933: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2934: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');

Line 2933: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

2929: l_output_string := l_output_string || ' Description: ' || rpad(v_c_dunning_letter_sets.description, 50, ' ');
2930: FND_FILE.PUT_LINE(FND_FILE.LOG, l_output_string);
2931: end loop;
2932: else
2933: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2934: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2935: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Profile ''IEX: AR Dunning to IEX Dunning Migrated?'' value is Yes. *');
2936: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2937: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

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

2930: FND_FILE.PUT_LINE(FND_FILE.LOG, l_output_string);
2931: end loop;
2932: else
2933: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2934: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2935: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Profile ''IEX: AR Dunning to IEX Dunning Migrated?'' value is Yes. *');
2936: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2937: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2938: FND_FILE.PUT_LINE(FND_FILE.LOG, '1. Following Dunning letter sets are already migrated as Dunning plans from AR to Advanced Collections');

Line 2935: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Profile ''IEX: AR Dunning to IEX Dunning Migrated?'' value is Yes. *');

2931: end loop;
2932: else
2933: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2934: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2935: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Profile ''IEX: AR Dunning to IEX Dunning Migrated?'' value is Yes. *');
2936: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2937: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2938: FND_FILE.PUT_LINE(FND_FILE.LOG, '1. Following Dunning letter sets are already migrated as Dunning plans from AR to Advanced Collections');
2939:

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

2932: else
2933: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2934: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2935: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Profile ''IEX: AR Dunning to IEX Dunning Migrated?'' value is Yes. *');
2936: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2937: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2938: FND_FILE.PUT_LINE(FND_FILE.LOG, '1. Following Dunning letter sets are already migrated as Dunning plans from AR to Advanced Collections');
2939:
2940: for v_c_migrated_dunn_letter_sets in c_migrated_dunn_letter_sets

Line 2937: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

2933: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2934: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2935: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Profile ''IEX: AR Dunning to IEX Dunning Migrated?'' value is Yes. *');
2936: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2937: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2938: FND_FILE.PUT_LINE(FND_FILE.LOG, '1. Following Dunning letter sets are already migrated as Dunning plans from AR to Advanced Collections');
2939:
2940: for v_c_migrated_dunn_letter_sets in c_migrated_dunn_letter_sets
2941: loop

Line 2938: FND_FILE.PUT_LINE(FND_FILE.LOG, '1. Following Dunning letter sets are already migrated as Dunning plans from AR to Advanced Collections');

2934: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2935: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Profile ''IEX: AR Dunning to IEX Dunning Migrated?'' value is Yes. *');
2936: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2937: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2938: FND_FILE.PUT_LINE(FND_FILE.LOG, '1. Following Dunning letter sets are already migrated as Dunning plans from AR to Advanced Collections');
2939:
2940: for v_c_migrated_dunn_letter_sets in c_migrated_dunn_letter_sets
2941: loop
2942: l_rec_exists := 'Y'; --at least one record exists

Line 2946: FND_FILE.PUT_LINE(FND_FILE.LOG, l_output_string);

2942: l_rec_exists := 'Y'; --at least one record exists
2943: l_output_string := ' Dunning_plan_id : ' || rpad(v_c_migrated_dunn_letter_sets.dunning_plan_id, 12, ' ')|| ' Business level: ' || rpad(v_c_migrated_dunn_letter_sets.dunning_level, 11, ' ') || ' Name: ';
2944: l_output_string := l_output_string || rpad(v_c_migrated_dunn_letter_sets.name, 30, ' ') || ' Description: ' || rpad(v_c_migrated_dunn_letter_sets.description, 50, ' ') || ' Dunning_letter_set_id: ' ;
2945: l_output_string := l_output_string || rpad(v_c_migrated_dunn_letter_sets.mig_dunning_letter_set_id, 20, ' ');
2946: FND_FILE.PUT_LINE(FND_FILE.LOG, l_output_string);
2947: end loop;
2948:
2949: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2950: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');

Line 2949: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

2945: l_output_string := l_output_string || rpad(v_c_migrated_dunn_letter_sets.mig_dunning_letter_set_id, 20, ' ');
2946: FND_FILE.PUT_LINE(FND_FILE.LOG, l_output_string);
2947: end loop;
2948:
2949: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2950: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2951: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Concurrent program has been submitted in DRAFT mode. *');
2952: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Profile IEX: AR Dunning to IEX Dunning Migrated? value is Yes. So data will not get migrated. *');
2953: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Set Profile value as No at Site level and run the concurrent program again in DRAFT mode to see, what are the records will get migrated. *');

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

2946: FND_FILE.PUT_LINE(FND_FILE.LOG, l_output_string);
2947: end loop;
2948:
2949: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2950: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2951: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Concurrent program has been submitted in DRAFT mode. *');
2952: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Profile IEX: AR Dunning to IEX Dunning Migrated? value is Yes. So data will not get migrated. *');
2953: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Set Profile value as No at Site level and run the concurrent program again in DRAFT mode to see, what are the records will get migrated. *');
2954: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');

Line 2951: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Concurrent program has been submitted in DRAFT mode. *');

2947: end loop;
2948:
2949: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2950: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2951: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Concurrent program has been submitted in DRAFT mode. *');
2952: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Profile IEX: AR Dunning to IEX Dunning Migrated? value is Yes. So data will not get migrated. *');
2953: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Set Profile value as No at Site level and run the concurrent program again in DRAFT mode to see, what are the records will get migrated. *');
2954: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2955: end if;

Line 2952: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Profile IEX: AR Dunning to IEX Dunning Migrated? value is Yes. So data will not get migrated. *');

2948:
2949: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2950: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2951: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Concurrent program has been submitted in DRAFT mode. *');
2952: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Profile IEX: AR Dunning to IEX Dunning Migrated? value is Yes. So data will not get migrated. *');
2953: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Set Profile value as No at Site level and run the concurrent program again in DRAFT mode to see, what are the records will get migrated. *');
2954: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2955: end if;
2956: end if; --if l_migration_mode = 'FINAL' then

Line 2953: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Set Profile value as No at Site level and run the concurrent program again in DRAFT mode to see, what are the records will get migrated. *');

2949: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2950: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2951: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Concurrent program has been submitted in DRAFT mode. *');
2952: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Profile IEX: AR Dunning to IEX Dunning Migrated? value is Yes. So data will not get migrated. *');
2953: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Set Profile value as No at Site level and run the concurrent program again in DRAFT mode to see, what are the records will get migrated. *');
2954: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2955: end if;
2956: end if; --if l_migration_mode = 'FINAL' then
2957: if l_rec_exists = 'N' then

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

2950: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2951: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Concurrent program has been submitted in DRAFT mode. *');
2952: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Profile IEX: AR Dunning to IEX Dunning Migrated? value is Yes. So data will not get migrated. *');
2953: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Set Profile value as No at Site level and run the concurrent program again in DRAFT mode to see, what are the records will get migrated. *');
2954: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2955: end if;
2956: end if; --if l_migration_mode = 'FINAL' then
2957: if l_rec_exists = 'N' then
2958: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

Line 2958: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

2954: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2955: end if;
2956: end if; --if l_migration_mode = 'FINAL' then
2957: if l_rec_exists = 'N' then
2958: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2959: FND_FILE.PUT_LINE(FND_FILE.LOG, '* NO RECORDS FOUND *');
2960: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2961: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2962: end if;

Line 2959: FND_FILE.PUT_LINE(FND_FILE.LOG, '* NO RECORDS FOUND *');

2955: end if;
2956: end if; --if l_migration_mode = 'FINAL' then
2957: if l_rec_exists = 'N' then
2958: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2959: FND_FILE.PUT_LINE(FND_FILE.LOG, '* NO RECORDS FOUND *');
2960: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2961: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2962: end if;
2963:

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

2956: end if; --if l_migration_mode = 'FINAL' then
2957: if l_rec_exists = 'N' then
2958: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2959: FND_FILE.PUT_LINE(FND_FILE.LOG, '* NO RECORDS FOUND *');
2960: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2961: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2962: end if;
2963:
2964: if l_migrated_data = 'Y' then

Line 2961: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

2957: if l_rec_exists = 'N' then
2958: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2959: FND_FILE.PUT_LINE(FND_FILE.LOG, '* NO RECORDS FOUND *');
2960: FND_FILE.PUT_LINE(FND_FILE.LOG, '*********************************************************************************************************************************************');
2961: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2962: end if;
2963:
2964: if l_migrated_data = 'Y' then
2965: l_con_update_re_st := fnd_concurrent.set_completion_status (status => 'WARNING',

Line 2973: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);

2969: EXCEPTION
2970: WHEN OTHERS THEN
2971: retcode := '2'; --FND_API.G_RET_STS_UNEXP_ERROR;
2972: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - errbuf='||SQLERRM);
2973: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);
2974:
2975: END STG_DUNNING_MIG_CONCUR;
2976: --End for bug 9582646 gnramasa 5th May 10
2977: