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_PVT dependencies on FND_FILE

Line 4433: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Missing Score');

4429:
4430: If ( C_GET_SCORE%NOTFOUND) Then
4431: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_SCORE');
4432: FND_MSG_PUB.Add;
4433: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Missing Score');
4434: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Missing Score');
4435: Close C_Get_SCORE;
4436: RAISE FND_API.G_EXC_ERROR;
4437: END IF;

Line 4468: FND_FILE.PUT_LINE(FND_FILE.LOG, 'AgingBucketLineId NotFound');

4464: If ( x_return_status <> FND_API.G_RET_STS_SUCCESS) Then
4465: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_AGINGBUCKETLINE');
4466: FND_MSG_PUB.Add;
4467: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - AgingBucketLineId notfound');
4468: FND_FILE.PUT_LINE(FND_FILE.LOG, 'AgingBucketLineId NotFound');
4469: RAISE FND_API.G_EXC_ERROR;
4470: END IF;
4471: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - lineid='||l_bucket_line_id);
4472:

Line 4496: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Missing corresponding template : SEND_LEVEL_DUNNING');

4492: --FND_MESSAGE.Set_Token ('INFO', 'Template_ID', FALSE);
4493: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_TEMPLATE');
4494: FND_MSG_PUB.Add;
4495: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Missing corresponding template');
4496: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Missing corresponding template : SEND_LEVEL_DUNNING');
4497: RAISE FND_API.G_EXC_ERROR;
4498: END IF;
4499:
4500: --WriteLog('iexvdunb:SendLevelDunn:close C_GET_TEMPLATE');

Line 4523: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Template: ''' || l_template_name || ''' is inactive');

4519:
4520: FND_MESSAGE.Set_Name('IEX', 'IEX_TEMPLATE_INACTIVE');
4521: FND_MSG_PUB.Add;
4522: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Template: ''' || l_template_name || ''' is inactive');
4523: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Template: ''' || l_template_name || ''' is inactive');
4524: RAISE FND_API.G_EXC_ERROR;
4525: END IF;
4526: Close C_TEMPLATE_STATUS;
4527: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - template status= '||l_template_status);

Line 4545: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Missing corresponding template');

4541: (l_curr_dmethod = 'XML' and l_xdo_template_id is null ) ) then
4542: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_TEMPLATE');
4543: FND_MSG_PUB.Add;
4544: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Missing corresponding template');
4545: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Missing corresponding template');
4546: RAISE FND_API.G_EXC_ERROR;
4547:
4548: end if;
4549: l_validation_level := FND_API.G_VALID_LEVEL_FULL;

Line 4586: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_party_cust_id = ' || l_party_cust_id);

4582: *===========================================*/
4583: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - begin check customer profile');
4584:
4585: -- ctlee - check the hz_customer_profiles.dunning_letter
4586: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_party_cust_id = ' || l_party_cust_id);
4587: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_account_id = ' || l_account_id);
4588: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_customer_site_use_id = ' || l_customer_site_use_id);
4589: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_delinquency_id = ' || l_delinquency_id);
4590: -- ctlee - check the hz_customer_profiles.dunning_letter

Line 4587: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_account_id = ' || l_account_id);

4583: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - begin check customer profile');
4584:
4585: -- ctlee - check the hz_customer_profiles.dunning_letter
4586: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_party_cust_id = ' || l_party_cust_id);
4587: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_account_id = ' || l_account_id);
4588: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_customer_site_use_id = ' || l_customer_site_use_id);
4589: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_delinquency_id = ' || l_delinquency_id);
4590: -- ctlee - check the hz_customer_profiles.dunning_letter
4591: l_party_cust_id_check := l_party_cust_id;

Line 4588: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_customer_site_use_id = ' || l_customer_site_use_id);

4584:
4585: -- ctlee - check the hz_customer_profiles.dunning_letter
4586: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_party_cust_id = ' || l_party_cust_id);
4587: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_account_id = ' || l_account_id);
4588: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_customer_site_use_id = ' || l_customer_site_use_id);
4589: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_delinquency_id = ' || l_delinquency_id);
4590: -- ctlee - check the hz_customer_profiles.dunning_letter
4591: l_party_cust_id_check := l_party_cust_id;
4592: l_account_id_check := l_account_id;

Line 4589: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_delinquency_id = ' || l_delinquency_id);

4585: -- ctlee - check the hz_customer_profiles.dunning_letter
4586: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_party_cust_id = ' || l_party_cust_id);
4587: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_account_id = ' || l_account_id);
4588: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_customer_site_use_id = ' || l_customer_site_use_id);
4589: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_delinquency_id = ' || l_delinquency_id);
4590: -- ctlee - check the hz_customer_profiles.dunning_letter
4591: l_party_cust_id_check := l_party_cust_id;
4592: l_account_id_check := l_account_id;
4593: l_customer_site_use_id_check := l_customer_site_use_id;

Line 4616: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Send dunning in customer profile set to no ');

4612: ) then
4613: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_DUNNING_PROFILE_NO');
4614: FND_MSG_PUB.Add;
4615: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Send dunning in customer profile set to no ');
4616: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Send dunning in customer profile set to no ');
4617: x_return_status := FND_API.G_RET_STS_ERROR;
4618: GOTO end_api;
4619: end if;
4620: /* if (p_running_level <> 'CUSTOMER') then

Line 4674: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Amount due remaining is less than 0 ');

4670: if l_total_amount_due_remaining <= 0 then
4671: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_DUNNING_AMOUNT_MIN');
4672: FND_MSG_PUB.Add;
4673: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Amount due remaining is less than 0 ');
4674: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Amount due remaining is less than 0 ');
4675: x_return_status := FND_API.G_RET_STS_ERROR;
4676: GOTO end_api;
4677: end if;
4678:

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

4832: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - CloseDunning status='|| x_return_status);
4833:
4834: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4835: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Cannot Close Dunning');
4836: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cannot Close Dunning');
4837: x_return_status := FND_API.G_RET_STS_ERROR;
4838: GOTO end_api;
4839: END IF;
4840: --WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - EndCloseDunn');

Line 4871: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cannot find callback date');

4867: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4868: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_CALLBACKDATE');
4869: FND_MSG_PUB.Add;
4870: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Cannot find callback date');
4871: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cannot find callback date');
4872: x_return_status := FND_API.G_RET_STS_ERROR;
4873: GOTO end_api;
4874: END IF;
4875:

Line 4939: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cannot Create Dunning');

4935: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - CreateDunning status='|| x_return_status);
4936:
4937: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4938: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Cannot Create Dunning');
4939: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cannot Create Dunning');
4940: x_return_status := FND_API.G_RET_STS_ERROR;
4941: GOTO end_api;
4942: END IF;
4943:

Line 4945: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Create Dunning Id='|| l_dunning_id);

4941: GOTO end_api;
4942: END IF;
4943:
4944: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - DunningId='||l_dunning_id);
4945: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Create Dunning Id='|| l_dunning_id);
4946:
4947: INSERT_DUNNING_TRANSACTION(
4948: p_api_version => p_api_version
4949: , p_init_msg_list => p_init_msg_list

Line 5126: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Sending process failed ');

5122: --End adding for bug 8489610 by gnramasa 14-May-09
5123:
5124: IF x_return_status <> FND_API.G_RET_STS_SUCCESS and x_return_status <> 'W' THEN
5125: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Sending process failed');
5126: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Sending process failed ');
5127: x_return_status := FND_API.G_RET_STS_ERROR;
5128: GOTO end_api;
5129: elsif x_return_status = 'W' then
5130: l_warning_flag := 'W';

Line 5134: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Request Id = ' || l_request_id);

5130: l_warning_flag := 'W';
5131: END IF;
5132:
5133: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - request_id = ' ||l_request_id);
5134: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Request Id = ' || l_request_id);
5135: l_ffm_cnt := l_ffm_cnt + 1;
5136:
5137: l_dunning_rec_upd.dunning_id := l_dunning_id;
5138: if (l_curr_dmethod = 'FFM') then

Line 5168: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error:'||errmsg);

5164: p_data => x_msg_data );
5165: for i in 1..x_msg_count loop
5166: errmsg := FND_MSG_PUB.Get(p_msg_index => i,
5167: p_encoded => 'F');
5168: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error:'||errmsg);
5169: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - errmsg=' || errmsg);
5170: end loop;
5171: end if;
5172: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - end_api');

Line 5178: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Profile IEX: Turn Off Collections Activity for Bankruptcy is Yes and bankruptcy record is exist, so will skip send dunning' );

5174: ELSE -- l_noskip = 0
5175: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - all del disputed');
5176: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - skip this party/accnt/site');
5177: if (l_turnoff_coll_on_bankru = 'Y' and l_no_of_bankruptcy >0 ) then
5178: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Profile IEX: Turn Off Collections Activity for Bankruptcy is Yes and bankruptcy record is exist, so will skip send dunning' );
5179: else
5180: FND_FILE.PUT_LINE(FND_FILE.LOG, 'all delinquencies disputed' );
5181: end if;
5182: FND_FILE.PUT_LINE(FND_FILE.LOG, 'skip this party/account/site' );

Line 5180: FND_FILE.PUT_LINE(FND_FILE.LOG, 'all delinquencies disputed' );

5176: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - skip this party/accnt/site');
5177: if (l_turnoff_coll_on_bankru = 'Y' and l_no_of_bankruptcy >0 ) then
5178: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Profile IEX: Turn Off Collections Activity for Bankruptcy is Yes and bankruptcy record is exist, so will skip send dunning' );
5179: else
5180: FND_FILE.PUT_LINE(FND_FILE.LOG, 'all delinquencies disputed' );
5181: end if;
5182: FND_FILE.PUT_LINE(FND_FILE.LOG, 'skip this party/account/site' );
5183: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
5184: p_data => x_msg_data );

Line 5182: FND_FILE.PUT_LINE(FND_FILE.LOG, 'skip this party/account/site' );

5178: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Profile IEX: Turn Off Collections Activity for Bankruptcy is Yes and bankruptcy record is exist, so will skip send dunning' );
5179: else
5180: FND_FILE.PUT_LINE(FND_FILE.LOG, 'all delinquencies disputed' );
5181: end if;
5182: FND_FILE.PUT_LINE(FND_FILE.LOG, 'skip this party/account/site' );
5183: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
5184: p_data => x_msg_data );
5185: x_return_status := 'SKIP'; --FND_API.G_EXC_ERROR;
5186:

Line 5213: FND_FILE.PUT_LINE(FND_FILE.LOG, 'expect exception' );

5209: FND_MSG_PUB.Count_And_Get
5210: ( p_count => x_msg_count,
5211: p_data => x_msg_data );
5212: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Exc Exception');
5213: FND_FILE.PUT_LINE(FND_FILE.LOG, 'expect exception' );
5214: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - error='||SQLERRM);
5215:
5216: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5217: COMMIT WORK;

Line 5223: FND_FILE.PUT_LINE(FND_FILE.LOG, 'unexpect exception' );

5219: FND_MSG_PUB.Count_And_Get
5220: ( p_count => x_msg_count,
5221: p_data => x_msg_data );
5222: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - UnExc Exception');
5223: FND_FILE.PUT_LINE(FND_FILE.LOG, 'unexpect exception' );
5224: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - error='||SQLERRM);
5225:
5226: WHEN OTHERS THEN
5227: COMMIT WORK;

Line 5233: FND_FILE.PUT_LINE(FND_FILE.LOG, 'unexpect exception' );

5229: FND_MSG_PUB.Count_And_Get
5230: ( p_count => x_msg_count,
5231: p_data => x_msg_data );
5232: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Other Exception');
5233: FND_FILE.PUT_LINE(FND_FILE.LOG, 'unexpect exception' );
5234: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - error='||SQLERRM);
5235:
5236: END Send_Level_Dunning;
5237:

Line 5616: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Missing Score');

5612:
5613: If ( C_GET_SCORE%NOTFOUND) Then
5614: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_SCORE');
5615: FND_MSG_PUB.Add;
5616: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Missing Score');
5617: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Missing Score');
5618: Close C_Get_SCORE;
5619: RAISE FND_API.G_EXC_ERROR;
5620: END IF;

Line 5853: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Required min Dunning amount in customer profile ');

5849: if l_dunn_letters = 'N' then
5850: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_DUNNING_AMOUNT_MIN');
5851: FND_MSG_PUB.Add;
5852: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Required min Dunning amount in customer profile ');
5853: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Required min Dunning amount in customer profile ');
5854: x_return_status := FND_API.G_RET_STS_ERROR;
5855: GOTO end_api;
5856: end if;
5857:

Line 5925: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Template: ''' || l_template_name || ''' is inactive');

5921:
5922: FND_MESSAGE.Set_Name('IEX', 'IEX_TEMPLATE_INACTIVE');
5923: FND_MSG_PUB.Add;
5924: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Template: ''' || l_template_name || ''' is inactive');
5925: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Template: ''' || l_template_name || ''' is inactive');
5926: RAISE FND_API.G_EXC_ERROR;
5927: END IF;
5928: Close C_TEMPLATE_STATUS;
5929: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - template status= '||l_template_status);

Line 5947: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Missing corresponding template');

5943: (l_curr_dmethod = 'XML' and l_xdo_template_id is null ) ) then
5944: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_TEMPLATE');
5945: FND_MSG_PUB.Add;
5946: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Missing corresponding template');
5947: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Missing corresponding template');
5948: RAISE FND_API.G_EXC_ERROR;
5949:
5950: end if;
5951:

Line 5958: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_party_cust_id = ' || l_party_cust_id);

5954: *===========================================*/
5955: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - begin check customer profile');
5956:
5957: -- ctlee - check the hz_customer_profiles.dunning_letter
5958: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_party_cust_id = ' || l_party_cust_id);
5959: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_account_id = ' || l_account_id);
5960: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_customer_site_use_id = ' || l_customer_site_use_id);
5961: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_delinquency_id = ' || l_delinquency_id);
5962: -- ctlee - check the hz_customer_profiles.dunning_letter

Line 5959: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_account_id = ' || l_account_id);

5955: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - begin check customer profile');
5956:
5957: -- ctlee - check the hz_customer_profiles.dunning_letter
5958: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_party_cust_id = ' || l_party_cust_id);
5959: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_account_id = ' || l_account_id);
5960: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_customer_site_use_id = ' || l_customer_site_use_id);
5961: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_delinquency_id = ' || l_delinquency_id);
5962: -- ctlee - check the hz_customer_profiles.dunning_letter
5963: l_party_cust_id_check := l_party_cust_id;

Line 5960: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_customer_site_use_id = ' || l_customer_site_use_id);

5956:
5957: -- ctlee - check the hz_customer_profiles.dunning_letter
5958: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_party_cust_id = ' || l_party_cust_id);
5959: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_account_id = ' || l_account_id);
5960: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_customer_site_use_id = ' || l_customer_site_use_id);
5961: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_delinquency_id = ' || l_delinquency_id);
5962: -- ctlee - check the hz_customer_profiles.dunning_letter
5963: l_party_cust_id_check := l_party_cust_id;
5964: l_account_id_check := l_account_id;

Line 5961: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_delinquency_id = ' || l_delinquency_id);

5957: -- ctlee - check the hz_customer_profiles.dunning_letter
5958: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_party_cust_id = ' || l_party_cust_id);
5959: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_account_id = ' || l_account_id);
5960: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_customer_site_use_id = ' || l_customer_site_use_id);
5961: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_delinquency_id = ' || l_delinquency_id);
5962: -- ctlee - check the hz_customer_profiles.dunning_letter
5963: l_party_cust_id_check := l_party_cust_id;
5964: l_account_id_check := l_account_id;
5965: l_customer_site_use_id_check := l_customer_site_use_id;

Line 5986: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Send dunning in customer profile set to no ');

5982: ) then
5983: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_DUNNING_PROFILE_NO');
5984: FND_MSG_PUB.Add;
5985: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Send dunning in customer profile set to no ');
5986: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Send dunning in customer profile set to no ');
5987: x_return_status := FND_API.G_RET_STS_ERROR;
5988: GOTO end_api;
5989: end if;
5990:

Line 6256: FND_FILE.PUT_LINE(FND_FILE.LOG,'inside if condn');

6252: goto c_dunning_plan_lines;
6253: end if;
6254:
6255: if ((upper(p_single_staged_letter) = 'N') OR (upper(p_single_staged_letter) = 'Y' and (l_first_satified_dunnplanid = 1)) ) then
6256: FND_FILE.PUT_LINE(FND_FILE.LOG,'inside if condn');
6257: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - p_single_staged_letter is N or p_single_staged_letter is Y and dunning_id NULL');
6258: --Start adding for bug 8489610 by gnramasa 14-May-09
6259: if p_dunning_mode <> 'DRAFT' then
6260: /*===========================================

Line 6284: FND_FILE.PUT_LINE(FND_FILE.LOG,'After close dunning');

6280: , x_msg_count => x_msg_count
6281: , x_msg_data => x_msg_data);
6282:
6283: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - CloseDunning status='|| x_return_status);
6284: FND_FILE.PUT_LINE(FND_FILE.LOG,'After close dunning');
6285:
6286: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6287: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Cannot Close Dunning');
6288: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cannot Close Dunning');

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

6284: FND_FILE.PUT_LINE(FND_FILE.LOG,'After close dunning');
6285:
6286: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6287: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Cannot Close Dunning');
6288: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cannot Close Dunning');
6289: x_return_status := FND_API.G_RET_STS_ERROR;
6290: GOTO end_api;
6291: END IF;
6292: --WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - EndCloseDunn');

Line 6324: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cannot find callback date');

6320: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6321: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_CALLBACKDATE');
6322: FND_MSG_PUB.Add;
6323: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Cannot find callback date');
6324: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cannot find callback date');
6325: x_return_status := FND_API.G_RET_STS_ERROR;
6326: GOTO end_api;
6327: END IF;
6328:

Line 6356: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Template: ''' || l_template_name || ''' is inactive');

6352:
6353: FND_MESSAGE.Set_Name('IEX', 'IEX_TEMPLATE_INACTIVE');
6354: FND_MSG_PUB.Add;
6355: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Template: ''' || l_template_name || ''' is inactive');
6356: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Template: ''' || l_template_name || ''' is inactive');
6357: RAISE FND_API.G_EXC_ERROR;
6358: END IF;
6359: Close C_TEMPLATE_STATUS;
6360: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - template status= '||l_template_status);

Line 6412: FND_FILE.PUT_LINE(FND_FILE.LOG,'call to create dunning');

6408: l_dunning_rec.org_id := l_org_id;
6409: l_dunning_rec.as_of_date := p_correspondence_date;
6410:
6411: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' before create dunning org_id ' || l_org_id);
6412: FND_FILE.PUT_LINE(FND_FILE.LOG,'call to create dunning');
6413:
6414: CREATE_DUNNING(
6415: p_api_version => p_api_version
6416: , p_init_msg_list => p_init_msg_list

Line 6428: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cannot Create Dunning');

6424: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - CreateDunning status='|| x_return_status);
6425:
6426: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6427: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Cannot Create Dunning');
6428: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cannot Create Dunning');
6429: x_return_status := FND_API.G_RET_STS_ERROR;
6430: GOTO end_api;
6431: END IF;
6432:

Line 6434: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Create Dunning Id='|| l_dunning_id);

6430: GOTO end_api;
6431: END IF;
6432:
6433: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - DunningId='||l_dunning_id);
6434: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Create Dunning Id='|| l_dunning_id);
6435: l_dunn_cnt := l_dunn_cnt + 1;
6436: end if; --if ((upper(p_single_staged_letter) = 'N') OR (upper(p_single_staged_letter) = 'Y' and (l_first_satified_dunnplanid = 1)) ) then
6437:
6438: FND_FILE.PUT_LINE(FND_FILE.LOG,'calling create staged dunning');

Line 6438: FND_FILE.PUT_LINE(FND_FILE.LOG,'calling create staged dunning');

6434: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Create Dunning Id='|| l_dunning_id);
6435: l_dunn_cnt := l_dunn_cnt + 1;
6436: end if; --if ((upper(p_single_staged_letter) = 'N') OR (upper(p_single_staged_letter) = 'Y' and (l_first_satified_dunnplanid = 1)) ) then
6437:
6438: FND_FILE.PUT_LINE(FND_FILE.LOG,'calling create staged dunning');
6439: Create_Staged_Dunning(
6440: p_api_version => p_api_version
6441: , p_init_msg_list => p_init_msg_list
6442: , p_commit => p_commit

Line 6457: FND_FILE.PUT_LINE(FND_FILE.LOG,'create staged dunning-->'||x_return_status);

6453: , x_msg_count => x_msg_count
6454: , x_msg_data => x_msg_data);
6455:
6456: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Create Stage Dunning transactions status='|| x_return_status);
6457: FND_FILE.PUT_LINE(FND_FILE.LOG,'create staged dunning-->'||x_return_status);
6458:
6459: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6460: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Cannot Create Stage Dunning transactions');
6461: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cannot Create Stage Dunning transactions');

Line 6461: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cannot Create Stage Dunning transactions');

6457: FND_FILE.PUT_LINE(FND_FILE.LOG,'create staged dunning-->'||x_return_status);
6458:
6459: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6460: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Cannot Create Stage Dunning transactions');
6461: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cannot Create Stage Dunning transactions');
6462: x_return_status := FND_API.G_RET_STS_ERROR;
6463: GOTO end_api;
6464: END IF;
6465:

Line 6518: FND_FILE.PUT_LINE(FND_FILE.LOG,'send fulfillment');

6514: ,x_contact_destination => l_contact_destination
6515: ,x_contact_party_id => l_contact_party_id);
6516: else
6517:
6518: FND_FILE.PUT_LINE(FND_FILE.LOG,'send fulfillment');
6519:
6520: Send_XML(p_api_version => p_api_version
6521: ,p_init_msg_list => FND_API.G_FALSE
6522: ,p_commit => FND_API.G_TRUE

Line 6551: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Sending process failed ');

6547: --End adding for bug 8489610 by gnramasa 14-May-09
6548:
6549: IF x_return_status <> FND_API.G_RET_STS_SUCCESS and x_return_status <> 'W' THEN
6550: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Sending process failed');
6551: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Sending process failed ');
6552: x_return_status := FND_API.G_RET_STS_ERROR;
6553: GOTO end_api;
6554: elsif x_return_status = 'W' then
6555: l_warning_flag := 'W';

Line 6559: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Request Id = ' || l_request_id);

6555: l_warning_flag := 'W';
6556: END IF;
6557:
6558: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - request_id = ' ||l_request_id);
6559: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Request Id = ' || l_request_id);
6560: l_ffm_cnt := l_ffm_cnt + 1;
6561:
6562: l_dunning_rec_upd.dunning_id := l_dunning_id;
6563: if (l_curr_dmethod = 'FFM') then

Line 6694: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Sending process failed ');

6690: --End adding for bug 8489610 by gnramasa 14-May-09
6691:
6692: IF x_return_status <> FND_API.G_RET_STS_SUCCESS and x_return_status <> 'W' THEN
6693: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Sending process failed');
6694: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Sending process failed ');
6695: x_return_status := FND_API.G_RET_STS_ERROR;
6696: GOTO end_api;
6697: elsif x_return_status = 'W' then
6698: l_warning_flag := 'W';

Line 6702: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Request Id = ' || l_request_id);

6698: l_warning_flag := 'W';
6699: END IF;
6700:
6701: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - request_id = ' ||l_request_id);
6702: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Request Id = ' || l_request_id);
6703: l_ffm_cnt := l_ffm_cnt + 1;
6704:
6705: l_dunning_rec_upd.dunning_id := l_dunning_id;
6706: if (l_curr_dmethod = 'FFM') then

Line 6806: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error:'||errmsg);

6802: p_data => x_msg_data );
6803: for i in 1..x_msg_count loop
6804: errmsg := FND_MSG_PUB.Get(p_msg_index => i,
6805: p_encoded => 'F');
6806: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error:'||errmsg);
6807: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - errmsg=' || errmsg);
6808: end loop;
6809: end if;
6810: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - end_api');

Line 6816: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Profile IEX: Turn Off Collections Activity for Bankruptcy is Yes and bankruptcy record is exist, so will skip send dunning' );

6812: ELSE -- l_noskip = 0
6813: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - all del disputed');
6814: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - skip this party/accnt/site');
6815: if (l_turnoff_coll_on_bankru = 'Y' and l_no_of_bankruptcy >0 ) then
6816: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Profile IEX: Turn Off Collections Activity for Bankruptcy is Yes and bankruptcy record is exist, so will skip send dunning' );
6817: else
6818: FND_FILE.PUT_LINE(FND_FILE.LOG, 'all delinquencies disputed' );
6819: end if;
6820: FND_FILE.PUT_LINE(FND_FILE.LOG, 'skip this party/account/site' );

Line 6818: FND_FILE.PUT_LINE(FND_FILE.LOG, 'all delinquencies disputed' );

6814: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - skip this party/accnt/site');
6815: if (l_turnoff_coll_on_bankru = 'Y' and l_no_of_bankruptcy >0 ) then
6816: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Profile IEX: Turn Off Collections Activity for Bankruptcy is Yes and bankruptcy record is exist, so will skip send dunning' );
6817: else
6818: FND_FILE.PUT_LINE(FND_FILE.LOG, 'all delinquencies disputed' );
6819: end if;
6820: FND_FILE.PUT_LINE(FND_FILE.LOG, 'skip this party/account/site' );
6821: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
6822: p_data => x_msg_data );

Line 6820: FND_FILE.PUT_LINE(FND_FILE.LOG, 'skip this party/account/site' );

6816: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Profile IEX: Turn Off Collections Activity for Bankruptcy is Yes and bankruptcy record is exist, so will skip send dunning' );
6817: else
6818: FND_FILE.PUT_LINE(FND_FILE.LOG, 'all delinquencies disputed' );
6819: end if;
6820: FND_FILE.PUT_LINE(FND_FILE.LOG, 'skip this party/account/site' );
6821: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
6822: p_data => x_msg_data );
6823: x_return_status := 'SKIP'; --FND_API.G_EXC_ERROR;
6824:

Line 6851: FND_FILE.PUT_LINE(FND_FILE.LOG, 'expect exception' );

6847: FND_MSG_PUB.Count_And_Get
6848: ( p_count => x_msg_count,
6849: p_data => x_msg_data );
6850: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Exc Exception');
6851: FND_FILE.PUT_LINE(FND_FILE.LOG, 'expect exception' );
6852: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - error='||SQLERRM);
6853:
6854: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6855: COMMIT WORK;

Line 6861: FND_FILE.PUT_LINE(FND_FILE.LOG, 'unexpect exception' );

6857: FND_MSG_PUB.Count_And_Get
6858: ( p_count => x_msg_count,
6859: p_data => x_msg_data );
6860: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - UnExc Exception');
6861: FND_FILE.PUT_LINE(FND_FILE.LOG, 'unexpect exception' );
6862: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - error='||SQLERRM);
6863:
6864: WHEN OTHERS THEN
6865: COMMIT WORK;

Line 6871: FND_FILE.PUT_LINE(FND_FILE.LOG, 'unexpect exception' );

6867: FND_MSG_PUB.Count_And_Get
6868: ( p_count => x_msg_count,
6869: p_data => x_msg_data );
6870: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Other Exception');
6871: FND_FILE.PUT_LINE(FND_FILE.LOG, 'unexpect exception' );
6872: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - error='||SQLERRM);
6873:
6874: END Send_Level_Staged_Dunning;
6875:

Line 7125: FND_FILE.PUT_LINE(FND_FILE.LOG, 'delinquency_id='||l_delinquency_id );

7121: LOOP
7122: l_delinquency_id := p_delinquencies_tbl(i).delinquency_id;
7123: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - ==================');
7124: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - ' || l_delinquency_Id);
7125: FND_FILE.PUT_LINE(FND_FILE.LOG, 'delinquency_id='||l_delinquency_id );
7126:
7127: -- Validate Data
7128:
7129: /*=============================================================

Line 7142: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Delinquency scoring engine donot have level');

7138: Open c_del_object_type (p_dunning_plan_id);
7139: Fetch c_del_object_type into l_del_object_type;
7140: If ( c_del_object_type%NOTFOUND ) Then
7141: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Delinquency scoring engine donot have level');
7142: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Delinquency scoring engine donot have level');
7143: x_return_status := FND_API.G_RET_STS_ERROR;
7144: CLOSE c_del_object_type;
7145: RAISE FND_API.G_EXC_ERROR;
7146: end if;

Line 7150: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_del_object_type: '|| l_del_object_type);

7146: end if;
7147: CLOSE c_del_object_type;
7148:
7149: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_del_object_type: '|| l_del_object_type);
7150: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_del_object_type: '|| l_del_object_type);
7151:
7152: if l_del_object_type = 'IEX_INVOICES' then
7153: select payment_schedule_id into l_del_object_id
7154: from iex_delinquencies_all

Line 7160: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_del_object_id: '|| l_del_object_id);

7156: elsif l_del_object_type = 'IEX_DELINQUENCY' then
7157: l_del_object_id := l_delinquency_id;
7158: end if;
7159: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_del_object_id: '|| l_del_object_id);
7160: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_del_object_id: '|| l_del_object_id);
7161:
7162: open c_get_score_del (l_del_object_id, l_del_object_type);
7163: fetch c_get_score_del into l_score;
7164:

Line 7257: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Dispute exists and is pending' );

7253: , x_msg_data => x_msg_data);
7254:
7255: IF x_return_status = 'T' THEN
7256: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Dispute exists and is pending');
7257: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Dispute exists and is pending' );
7258: GOTO end_loop;
7259: elsif x_return_status = 'F' THEN
7260: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - No Dispute or status is COMPLETE');
7261: END IF;*/

Line 7294: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cannot AgingBucketLineId' );

7290: --FND_MESSAGE.Set_Token ('INFO', 'iex:AginBucketLineId', FALSE);
7291: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_AGINGBUCKETLINE');
7292: FND_MSG_PUB.Add;
7293: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Cannot Get AgingBucketLineId');
7294: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cannot AgingBucketLineId' );
7295: --msg
7296: FND_MSG_PUB.Count_And_Get
7297: ( p_count => x_msg_count,
7298: p_data => x_msg_data );

Line 7302: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error:'||errmsg);

7298: p_data => x_msg_data );
7299: for i in 1..x_msg_count loop
7300: errmsg := FND_MSG_PUB.Get(p_msg_index => i,
7301: p_encoded => 'F');
7302: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error:'||errmsg);
7303: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - errmsg=' || errmsg);
7304: end loop;
7305:
7306: GOTO end_loop;

Line 7332: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Missing corresponding template' );

7328: If ( C_GET_TEMPLATE%NOTFOUND) Then
7329: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_TEMPLATE');
7330: FND_MSG_PUB.Add;
7331: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Missing corresponding template');
7332: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Missing corresponding template' );
7333: Close C_Get_TEMPLATE;
7334: GOTO end_loop;
7335: END IF;
7336:

Line 7361: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Template: ''' || l_template_name || ''' is inactive');

7357:
7358: FND_MESSAGE.Set_Name('IEX', 'IEX_TEMPLATE_INACTIVE');
7359: FND_MSG_PUB.Add;
7360: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Template: ''' || l_template_name || ''' is inactive');
7361: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Template: ''' || l_template_name || ''' is inactive');
7362: RAISE FND_API.G_EXC_ERROR;
7363: END IF;
7364: Close C_TEMPLATE_STATUS;
7365: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - template status= '||l_template_status);

Line 7385: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Missing corresponding template' );

7381: --FND_MESSAGE.Set_Token ('INFO', 'Template_ID', FALSE);
7382: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_TEMPLATE');
7383: FND_MSG_PUB.Add;
7384: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Missing corresponding template');
7385: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Missing corresponding template' );
7386: x_return_status := FND_API.G_RET_STS_ERROR;
7387: GOTO end_loop;
7388: end if;
7389:

Line 7425: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Send dunning in customer profile set to no ');

7421: ) then
7422: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_DUNNING_PROFILE_NO');
7423: FND_MSG_PUB.Add;
7424: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Send dunning in customer profile set to no ');
7425: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Send dunning in customer profile set to no ');
7426: GOTO end_loop;
7427: end if;
7428: /* -- ctlee - check the hz_customer_profiles_amt min_dunning_invoice_amount and min_dunning_amount
7429: if ( iex_utilities.DunningMinAmountCheck (

Line 7469: FND_FILE.PUT_LINE(FND_FILE.LOG,'error in currency conversion..pl check whether exchange rates are defined');

7465: ,x_amount => l_amount);
7466: -- l_amount := nvl(l_amount,0) + nvl(l_convert_amount,0);
7467: exception
7468: when others then
7469: FND_FILE.PUT_LINE(FND_FILE.LOG,'error in currency conversion..pl check whether exchange rates are defined');
7470: FND_FILE.PUT_LINE(FND_FILE.LOG,sqlerrm);
7471: GOTO end_loop;
7472: end;
7473: l_amount := nvl(l_convert_amount,0);

Line 7470: FND_FILE.PUT_LINE(FND_FILE.LOG,sqlerrm);

7466: -- l_amount := nvl(l_amount,0) + nvl(l_convert_amount,0);
7467: exception
7468: when others then
7469: FND_FILE.PUT_LINE(FND_FILE.LOG,'error in currency conversion..pl check whether exchange rates are defined');
7470: FND_FILE.PUT_LINE(FND_FILE.LOG,sqlerrm);
7471: GOTO end_loop;
7472: end;
7473: l_amount := nvl(l_convert_amount,0);
7474: end if;

Line 7493: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_party_cust_id = ' || l_party_cust_id);

7489: if ((l_amount < l_profile_dunn_amt ) or (l_amount < l_profile_dunn_inv_amt )) then -- bug 14797201
7490: -- if l_amount < l_min_dunning_invoice_amount then -- bug 14797201
7491: */ -- end comment for bug 15933013
7492: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - begin check customer profile');
7493: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_party_cust_id = ' || l_party_cust_id);
7494: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_account_id = ' || l_account_id);
7495: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_customer_site_use_id = ' || l_customer_site_use_id);
7496: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_delinquency_id = ' || l_delinquency_id);
7497:

Line 7494: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_account_id = ' || l_account_id);

7490: -- if l_amount < l_min_dunning_invoice_amount then -- bug 14797201
7491: */ -- end comment for bug 15933013
7492: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - begin check customer profile');
7493: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_party_cust_id = ' || l_party_cust_id);
7494: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_account_id = ' || l_account_id);
7495: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_customer_site_use_id = ' || l_customer_site_use_id);
7496: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_delinquency_id = ' || l_delinquency_id);
7497:
7498: /* l_party_cust_id_check := l_party_cust_id;

Line 7495: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_customer_site_use_id = ' || l_customer_site_use_id);

7491: */ -- end comment for bug 15933013
7492: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - begin check customer profile');
7493: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_party_cust_id = ' || l_party_cust_id);
7494: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_account_id = ' || l_account_id);
7495: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_customer_site_use_id = ' || l_customer_site_use_id);
7496: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_delinquency_id = ' || l_delinquency_id);
7497:
7498: /* l_party_cust_id_check := l_party_cust_id;
7499: l_account_id_check := l_account_id;

Line 7496: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_delinquency_id = ' || l_delinquency_id);

7492: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - begin check customer profile');
7493: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_party_cust_id = ' || l_party_cust_id);
7494: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_account_id = ' || l_account_id);
7495: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_customer_site_use_id = ' || l_customer_site_use_id);
7496: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_delinquency_id = ' || l_delinquency_id);
7497:
7498: /* l_party_cust_id_check := l_party_cust_id;
7499: l_account_id_check := l_account_id;
7500: l_customer_site_use_id_check := l_customer_site_use_id;

Line 7713: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'Create Dunning Id=' ||l_dunning_id);

7709:
7710: END IF;
7711:
7712: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - DunningId='||l_dunning_id);
7713: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'Create Dunning Id=' ||l_dunning_id);
7714: l_dunn_cnt := l_dunn_cnt + 1;
7715:
7716: /*===========================================
7717: * Send Letter through Fulfillment

Line 7831: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error:'||errmsg);

7827: p_data => x_msg_data );
7828: for i in 1..x_msg_count loop
7829: errmsg := FND_MSG_PUB.Get(p_msg_index => i,
7830: p_encoded => 'F');
7831: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error:'||errmsg);
7832: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - errmsg=' || errmsg);
7833: end loop;
7834: GOTO end_loop;
7835: elsif x_return_status = 'W' then

Line 8335: FND_FILE.PUT_LINE(FND_FILE.LOG, 'delinquency_id='||l_delinquency_id );

8331: LOOP
8332: l_delinquency_id := p_delinquencies_tbl(i).delinquency_id;
8333: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - ==================');
8334: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - ' || l_delinquency_Id);
8335: FND_FILE.PUT_LINE(FND_FILE.LOG, 'delinquency_id='||l_delinquency_id );
8336:
8337: -- Validate Data
8338:
8339: /*=============================================================

Line 8352: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Delinquency scoring engine donot have level');

8348: Open c_del_object_type (p_dunning_plan_id);
8349: Fetch c_del_object_type into l_del_object_type;
8350: If ( c_del_object_type%NOTFOUND ) Then
8351: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Delinquency scoring engine donot have level');
8352: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Delinquency scoring engine donot have level');
8353: close c_del_object_type;
8354: x_return_status := FND_API.G_RET_STS_ERROR;
8355: RAISE FND_API.G_EXC_ERROR;
8356: end if;

Line 8360: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_del_object_type: '|| l_del_object_type);

8356: end if;
8357: CLOSE c_del_object_type;
8358:
8359: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_del_object_type: '|| l_del_object_type);
8360: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_del_object_type: '|| l_del_object_type);
8361:
8362: if l_del_object_type = 'IEX_INVOICES' then
8363: select payment_schedule_id into l_del_object_id
8364: from iex_delinquencies_all

Line 8370: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_del_object_id: '|| l_del_object_id);

8366: elsif l_del_object_type = 'IEX_DELINQUENCY' then
8367: l_del_object_id := l_delinquency_id;
8368: end if;
8369: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_del_object_id: '|| l_del_object_id);
8370: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_del_object_id: '|| l_del_object_id);
8371:
8372: open c_get_score_del (l_del_object_id, l_del_object_type);
8373: fetch c_get_score_del into l_score;
8374:

Line 8496: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Required min Dunning amount in customer profile ');

8492: if l_dunn_letters = 'N' then
8493: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_DUNNING_AMOUNT_MIN');
8494: FND_MSG_PUB.Add;
8495: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Required min Dunning amount in customer profile ');
8496: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Required min Dunning amount in customer profile ');
8497: x_return_status := FND_API.G_RET_STS_ERROR;
8498: GOTO end_loop; -- GOTO end_api; -- bug 14797201
8499: end if;
8500:

Line 8546: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Template: ''' || l_template_name || ''' is inactive');

8542:
8543: FND_MESSAGE.Set_Name('IEX', 'IEX_TEMPLATE_INACTIVE');
8544: FND_MSG_PUB.Add;
8545: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Template: ''' || l_template_name || ''' is inactive');
8546: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Template: ''' || l_template_name || ''' is inactive');
8547: RAISE FND_API.G_EXC_ERROR;
8548: END IF;
8549: Close C_TEMPLATE_STATUS;
8550: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - template status= '||l_template_status);

Line 8623: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Missing corresponding template' );

8619: --FND_MESSAGE.Set_Token ('INFO', 'Template_ID', FALSE);
8620: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_TEMPLATE');
8621: FND_MSG_PUB.Add;
8622: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Missing corresponding template');
8623: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Missing corresponding template' );
8624: x_return_status := FND_API.G_RET_STS_ERROR;
8625: goto c_dunning_plan_lines; -- GOTO end_loop; -- bug 14797201
8626: end if;
8627:

Line 8643: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Send dunning in customer profile set to no ');

8639: ) then
8640: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_DUNNING_PROFILE_NO');
8641: FND_MSG_PUB.Add;
8642: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Send dunning in customer profile set to no ');
8643: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Send dunning in customer profile set to no ');
8644: goto c_dunning_plan_lines; -- GOTO end_loop; -- bug 14797201
8645: GOTO end_loop;
8646: end if;
8647:

Line 8760: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Template: ''' || l_template_name || ''' is inactive');

8756:
8757: FND_MESSAGE.Set_Name('IEX', 'IEX_TEMPLATE_INACTIVE');
8758: FND_MSG_PUB.Add;
8759: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Template: ''' || l_template_name || ''' is inactive');
8760: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Template: ''' || l_template_name || ''' is inactive');
8761: RAISE FND_API.G_EXC_ERROR;
8762: END IF;
8763: Close C_TEMPLATE_STATUS;
8764: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - template status= '||l_template_status);

Line 8828: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'Create Dunning Id=' ||l_dunning_id);

8824: goto c_dunning_plan_lines; -- GOTO end_loop; -- bug 14797201
8825: END IF;
8826:
8827: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - DunningId='||l_dunning_id);
8828: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'Create Dunning Id=' ||l_dunning_id);
8829: l_dunn_cnt := l_dunn_cnt + 1;
8830:
8831: begin
8832: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - InsertRow');

Line 8989: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error:'||errmsg);

8985: p_data => x_msg_data );
8986: for i in 1..x_msg_count loop
8987: errmsg := FND_MSG_PUB.Get(p_msg_index => i,
8988: p_encoded => 'F');
8989: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error:'||errmsg);
8990: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - errmsg=' || errmsg);
8991: end loop;
8992: goto c_dunning_plan_lines; -- GOTO end_loop; -- bug 14797201
8993: elsif x_return_status = 'W' then

Line 9547: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Template: ''' || l_template_name || ''' is inactive');

9543:
9544: FND_MESSAGE.Set_Name('IEX', 'IEX_TEMPLATE_INACTIVE');
9545: FND_MSG_PUB.Add;
9546: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Template: ''' || l_template_name || ''' is inactive');
9547: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Template: ''' || l_template_name || ''' is inactive');
9548: RAISE FND_API.G_EXC_ERROR;
9549: END IF;
9550: Close C_TEMPLATE_STATUS;
9551: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - template status= '||l_template_status);

Line 9607: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_party_cust_id = ' || l_party_cust_id);

9603: *===========================================*/
9604:
9605: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - begin check customer profile');
9606: -- ctlee - check the hz_customer_profiles.dunning_letter
9607: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_party_cust_id = ' || l_party_cust_id);
9608: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_account_id = ' || l_account_id);
9609: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_customer_site_use_id = ' || l_customer_site_use_id);
9610: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_delinquency_id = ' || l_delinquency_id);
9611: -- ctlee - check the hz_customer_profiles.dunning_letter

Line 9608: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_account_id = ' || l_account_id);

9604:
9605: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - begin check customer profile');
9606: -- ctlee - check the hz_customer_profiles.dunning_letter
9607: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_party_cust_id = ' || l_party_cust_id);
9608: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_account_id = ' || l_account_id);
9609: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_customer_site_use_id = ' || l_customer_site_use_id);
9610: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_delinquency_id = ' || l_delinquency_id);
9611: -- ctlee - check the hz_customer_profiles.dunning_letter
9612: l_party_cust_id_check := l_party_cust_id;

Line 9609: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_customer_site_use_id = ' || l_customer_site_use_id);

9605: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - begin check customer profile');
9606: -- ctlee - check the hz_customer_profiles.dunning_letter
9607: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_party_cust_id = ' || l_party_cust_id);
9608: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_account_id = ' || l_account_id);
9609: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_customer_site_use_id = ' || l_customer_site_use_id);
9610: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_delinquency_id = ' || l_delinquency_id);
9611: -- ctlee - check the hz_customer_profiles.dunning_letter
9612: l_party_cust_id_check := l_party_cust_id;
9613: l_account_id_check := l_account_id;

Line 9610: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_delinquency_id = ' || l_delinquency_id);

9606: -- ctlee - check the hz_customer_profiles.dunning_letter
9607: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_party_cust_id = ' || l_party_cust_id);
9608: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_account_id = ' || l_account_id);
9609: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_customer_site_use_id = ' || l_customer_site_use_id);
9610: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_delinquency_id = ' || l_delinquency_id);
9611: -- ctlee - check the hz_customer_profiles.dunning_letter
9612: l_party_cust_id_check := l_party_cust_id;
9613: l_account_id_check := l_account_id;
9614: l_customer_site_use_id_check := l_customer_site_use_id;

Line 9691: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Amount due remaining is less than 0 ');

9687: if l_total_amount_due_remaining <= 0 then
9688: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_DUNNING_AMOUNT_MIN');
9689: FND_MSG_PUB.Add;
9690: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Amount due remaining is less than 0 ');
9691: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Amount due remaining is less than 0 ');
9692: x_return_status := FND_API.G_RET_STS_ERROR;
9693: GOTO end_api;
9694: end if;
9695:

Line 10475: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Template: ''' || l_template_name || ''' is inactive');

10471:
10472: FND_MESSAGE.Set_Name('IEX', 'IEX_TEMPLATE_INACTIVE');
10473: FND_MSG_PUB.Add;
10474: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Template: ''' || l_template_name || ''' is inactive');
10475: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Template: ''' || l_template_name || ''' is inactive');
10476: RAISE FND_API.G_EXC_ERROR;
10477: END IF;
10478: Close C_TEMPLATE_STATUS;
10479: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - template status= '||l_template_status);

Line 10495: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Addt Template: ''' || l_template_name || ''' is inactive');

10491:
10492: FND_MESSAGE.Set_Name('IEX', 'IEX_TEMPLATE_INACTIVE');
10493: FND_MSG_PUB.Add;
10494: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Addt Template: ''' || l_template_name || ''' is inactive');
10495: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Addt Template: ''' || l_template_name || ''' is inactive');
10496: RAISE FND_API.G_EXC_ERROR;
10497: END IF;
10498: Close C_TEMPLATE_STATUS;
10499: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - addt template status= '||l_template_status);

Line 10694: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_party_cust_id = ' || l_party_cust_id);

10690: *===========================================*/
10691:
10692: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - begin check customer profile');
10693: -- ctlee - check the hz_customer_profiles.dunning_letter
10694: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_party_cust_id = ' || l_party_cust_id);
10695: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_account_id = ' || l_account_id);
10696: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_customer_site_use_id = ' || l_customer_site_use_id);
10697: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_delinquency_id = ' || l_delinquency_id);
10698: -- ctlee - check the hz_customer_profiles.dunning_letter

Line 10695: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_account_id = ' || l_account_id);

10691:
10692: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - begin check customer profile');
10693: -- ctlee - check the hz_customer_profiles.dunning_letter
10694: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_party_cust_id = ' || l_party_cust_id);
10695: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_account_id = ' || l_account_id);
10696: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_customer_site_use_id = ' || l_customer_site_use_id);
10697: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_delinquency_id = ' || l_delinquency_id);
10698: -- ctlee - check the hz_customer_profiles.dunning_letter
10699: l_party_cust_id_check := l_party_cust_id;

Line 10696: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_customer_site_use_id = ' || l_customer_site_use_id);

10692: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - begin check customer profile');
10693: -- ctlee - check the hz_customer_profiles.dunning_letter
10694: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_party_cust_id = ' || l_party_cust_id);
10695: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_account_id = ' || l_account_id);
10696: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_customer_site_use_id = ' || l_customer_site_use_id);
10697: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_delinquency_id = ' || l_delinquency_id);
10698: -- ctlee - check the hz_customer_profiles.dunning_letter
10699: l_party_cust_id_check := l_party_cust_id;
10700: l_account_id_check := l_account_id;

Line 10697: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_delinquency_id = ' || l_delinquency_id);

10693: -- ctlee - check the hz_customer_profiles.dunning_letter
10694: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_party_cust_id = ' || l_party_cust_id);
10695: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_account_id = ' || l_account_id);
10696: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_customer_site_use_id = ' || l_customer_site_use_id);
10697: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_delinquency_id = ' || l_delinquency_id);
10698: -- ctlee - check the hz_customer_profiles.dunning_letter
10699: l_party_cust_id_check := l_party_cust_id;
10700: l_account_id_check := l_account_id;
10701: l_customer_site_use_id_check := l_customer_site_use_id;

Line 11331: --dont write into FND_FILE

11327:
11328: -- Initialize API return status to SUCCESS
11329: x_return_status := FND_API.G_RET_STS_SUCCESS;
11330:
11331: --dont write into FND_FILE
11332: --l_write := 0;
11333:
11334: --
11335: -- Api body

Line 11479: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Template: ''' || l_template_name || ''' is inactive');

11475:
11476: FND_MESSAGE.Set_Name('IEX', 'IEX_TEMPLATE_INACTIVE');
11477: FND_MSG_PUB.Add;
11478: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Template: ''' || l_template_name || ''' is inactive');
11479: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Template: ''' || l_template_name || ''' is inactive');
11480: RAISE FND_API.G_EXC_ERROR;
11481: END IF;
11482: Close C_TEMPLATE_STATUS;
11483: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - template status= '||l_template_status);

Line 12142: --dont write into FND_FILE

12138:
12139: -- Initialize API return status to SUCCESS
12140: x_return_status := FND_API.G_RET_STS_SUCCESS;
12141:
12142: --dont write into FND_FILE
12143: --l_write := 0;
12144:
12145: --
12146: -- Api body

Line 12318: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Template: ''' || l_template_name || ''' is inactive');

12314:
12315: FND_MESSAGE.Set_Name('IEX', 'IEX_TEMPLATE_INACTIVE');
12316: FND_MSG_PUB.Add;
12317: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Template: ''' || l_template_name || ''' is inactive');
12318: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Template: ''' || l_template_name || ''' is inactive');
12319: RAISE FND_API.G_EXC_ERROR;
12320: END IF;
12321: Close C_TEMPLATE_STATUS;
12322: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - template status= '||l_template_status);

Line 12338: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Template: ''' || l_template_name || ''' is inactive');

12334:
12335: FND_MESSAGE.Set_Name('IEX', 'IEX_TEMPLATE_INACTIVE');
12336: FND_MSG_PUB.Add;
12337: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Template: ''' || l_template_name || ''' is inactive');
12338: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Template: ''' || l_template_name || ''' is inactive');
12339: RAISE FND_API.G_EXC_ERROR;
12340: END IF;
12341: Close C_TEMPLATE_STATUS;
12342: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - template status= '||l_template_status);

Line 12928: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_days = ' || l_days);

12924: --
12925: END IF;
12926: --
12927: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - days='||l_days);
12928: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_days = ' || l_days);
12929:
12930: Open C_Get_BUCKET_LINE(l_days, p_dunning_plan_id);
12931: Fetch C_Get_BUCKET_LINE into l_bucket_line_id;
12932: If ( C_GET_BUCKET_LINE%NOTFOUND) Then

Line 14249: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Template: ''' || l_template_name || ''' is inactive');

14245:
14246: FND_MESSAGE.Set_Name('IEX', 'IEX_TEMPLATE_INACTIVE');
14247: FND_MSG_PUB.Add;
14248: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Template: ''' || l_template_name || ''' is inactive');
14249: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Template: ''' || l_template_name || ''' is inactive');
14250: l_return_status := FND_API.G_RET_STS_ERROR;
14251: GOTO end_call_ffm;
14252: END IF;
14253: Close C_TEMPLATE_STATUS;

Line 16360: FND_FILE.PUT_LINE(FND_FILE.LOG, 'current date=' || l_curr_date);

16356: x_return_status := FND_API.G_RET_STS_SUCCESS;
16357:
16358: l_curr_date := to_char(sysdate, 'YYYYMMDD');
16359: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - CurrDate='||l_curr_date) ;
16360: FND_FILE.PUT_LINE(FND_FILE.LOG, 'current date=' || l_curr_date);
16361: --
16362: -- Api body
16363: --
16364:

Line 16381: FND_FILE.PUT_LINE(FND_FILE.LOG, 'NoOpenDunning with callback_yn=Y');

16377:
16378: If ( C_GET_DUNNING%NOTFOUND ) Then
16379: if (nIdx = 0) then
16380: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - NoOpenDunning with callback_yn=Y');
16381: FND_FILE.PUT_LINE(FND_FILE.LOG, 'NoOpenDunning with callback_yn=Y');
16382:
16383: end if;
16384: exit;
16385: ELSE

Line 16392: FND_FILE.PUT_LINE(FND_FILE.LOG, 'dunning_id='||l_dunning_id||'');

16388: x_return_status := FND_API.G_RET_STS_SUCCESS;
16389: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - DunningID='||l_dunning_id) ;
16390: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - DunningObjectID='||l_dunning_object_id) ;
16391: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Callback_Date='||l_callback_date) ;
16392: FND_FILE.PUT_LINE(FND_FILE.LOG, '*****dunning_id='||l_dunning_id||'*****');
16393:
16394: /*=========================================
16395: * bug 2816550 - clchan updatd 02/21/2003
16396: * for this current dunning,

Line 16406: FND_FILE.PUT_LINE(FND_FILE.LOG, 'All Delinquencies Closed for this customer');

16402: Fetch C_CHK_CUSTOMER into l_chk;
16403:
16404: If ( C_CHK_CUSTOMER%NOTFOUND) Then
16405: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - All Del Closed for this customer');
16406: FND_FILE.PUT_LINE(FND_FILE.LOG, 'All Delinquencies Closed for this customer');
16407: Close C_CHK_CUSTOMER;
16408: l_skip := 1;
16409: else
16410: l_skip := 0;

Line 16422: FND_FILE.PUT_LINE(FND_FILE.LOG, 'All Delinquencies Closed for this account');

16418: Fetch C_CHK_Account into l_chk;
16419:
16420: If ( C_CHK_Account%NOTFOUND) Then
16421: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - All Del Closed for this Account');
16422: FND_FILE.PUT_LINE(FND_FILE.LOG, 'All Delinquencies Closed for this account');
16423: Close C_CHK_Account;
16424: --GOTO end_dunning_if;
16425: l_skip := 1;
16426: else

Line 16439: FND_FILE.PUT_LINE(FND_FILE.LOG, 'All Delinquencies Closed for this site');

16435: Fetch C_CHK_Site into l_chk;
16436:
16437: If ( C_CHK_Site%NOTFOUND) Then
16438: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - All Del Closed for this site');
16439: FND_FILE.PUT_LINE(FND_FILE.LOG, 'All Delinquencies Closed for this site');
16440: Close C_CHK_Site;
16441: --GOTO end_dunning_if;
16442: l_skip := 1;
16443: else

Line 16456: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Delinquency Closed');

16452: Fetch C_CHK_DEL into l_chk;
16453:
16454: If ( C_CHK_DEL%NOTFOUND) Then
16455: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Del Closed for this del');
16456: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Delinquency Closed');
16457: Close C_CHK_DEL;
16458: --GOTO end_dunning_if;
16459: l_skip := 1;
16460: else

Line 16490: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cannot create new task');

16486: );
16487:
16488: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
16489: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Cannot create new Task');
16490: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cannot create new task');
16491: FND_MSG_PUB.Count_And_Get
16492: ( p_count => x_msg_count,
16493: p_data => x_msg_data );
16494: for i in 1..x_msg_count loop

Line 16497: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error:'||errmsg);

16493: p_data => x_msg_data );
16494: for i in 1..x_msg_count loop
16495: errmsg := FND_MSG_PUB.Get(p_msg_index => i,
16496: p_encoded => 'F');
16497: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error:'||errmsg);
16498: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - errmsg=' || errmsg);
16499: end loop;
16500: l_skip := 1;
16501: else

Line 16504: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'task_id='||l_task_id);

16500: l_skip := 1;
16501: else
16502: l_skip := 0;
16503: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - taskid='||l_task_id);
16504: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'task_id='||l_task_id);
16505: l_task_cnt := l_task_cnt + 1;
16506: END IF; -- end of create_task
16507:
16508: /*======================

Line 16979: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No collector has been assigned to this customer '||l_party_name);

16975: l_resource_id := l_default_rs_id;
16976: else
16977: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
16978: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Cannot get resource from customer profile and there is no default resource set');
16979: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No collector has been assigned to this customer '||l_party_name);
16980: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No default collector available to assign to callback. Please update default collector.');
16981: GOTO end_new_task;
16982: end if;
16983: end if;

Line 16980: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No default collector available to assign to callback. Please update default collector.');

16976: else
16977: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
16978: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Cannot get resource from customer profile and there is no default resource set');
16979: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No collector has been assigned to this customer '||l_party_name);
16980: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No default collector available to assign to callback. Please update default collector.');
16981: GOTO end_new_task;
16982: end if;
16983: end if;
16984: --End Bug#5229763 schekuri 27-Jul-2006

Line 17773: --FND_FILE.put_line( FND_FILE.LOG,'l_end-->'||l_end);

17769: BEGIN
17770: -- LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
17771: LOOP
17772: l_end := DBMS_LOB.INSTR (lob_loc => lob_loc, pattern => c_endline, offset => l_start, nth => 1 );
17773: --FND_FILE.put_line( FND_FILE.LOG,'l_end-->'||l_end);
17774: IF (NVL (l_end, 0) < 1) THEN
17775: EXIT;
17776: END IF;
17777: l_one_line := DBMS_LOB.SUBSTR (lob_loc => lob_loc, amount => l_end - l_start, offset => l_start );

Line 17778: --FND_FILE.put_line( FND_FILE.LOG,'l_one_line-->'||l_one_line);

17774: IF (NVL (l_end, 0) < 1) THEN
17775: EXIT;
17776: END IF;
17777: l_one_line := DBMS_LOB.SUBSTR (lob_loc => lob_loc, amount => l_end - l_start, offset => l_start );
17778: --FND_FILE.put_line( FND_FILE.LOG,'l_one_line-->'||l_one_line);
17779: --FND_FILE.put_line( FND_FILE.LOG,'c_endline_len-->'||c_endline_len);
17780: l_start := l_end + c_endline_len;
17781: --FND_FILE.put_line( FND_FILE.LOG,'l_start-->'||l_start);
17782: --FND_FILE.put_line( FND_FILE.LOG,'32');

Line 17779: --FND_FILE.put_line( FND_FILE.LOG,'c_endline_len-->'||c_endline_len);

17775: EXIT;
17776: END IF;
17777: l_one_line := DBMS_LOB.SUBSTR (lob_loc => lob_loc, amount => l_end - l_start, offset => l_start );
17778: --FND_FILE.put_line( FND_FILE.LOG,'l_one_line-->'||l_one_line);
17779: --FND_FILE.put_line( FND_FILE.LOG,'c_endline_len-->'||c_endline_len);
17780: l_start := l_end + c_endline_len;
17781: --FND_FILE.put_line( FND_FILE.LOG,'l_start-->'||l_start);
17782: --FND_FILE.put_line( FND_FILE.LOG,'32');
17783: Fnd_File.PUT_line(Fnd_File.OUTPUT,l_one_line);

Line 17781: --FND_FILE.put_line( FND_FILE.LOG,'l_start-->'||l_start);

17777: l_one_line := DBMS_LOB.SUBSTR (lob_loc => lob_loc, amount => l_end - l_start, offset => l_start );
17778: --FND_FILE.put_line( FND_FILE.LOG,'l_one_line-->'||l_one_line);
17779: --FND_FILE.put_line( FND_FILE.LOG,'c_endline_len-->'||c_endline_len);
17780: l_start := l_end + c_endline_len;
17781: --FND_FILE.put_line( FND_FILE.LOG,'l_start-->'||l_start);
17782: --FND_FILE.put_line( FND_FILE.LOG,'32');
17783: Fnd_File.PUT_line(Fnd_File.OUTPUT,l_one_line);
17784: END LOOP;
17785: END PRINT_CLOB;

Line 17782: --FND_FILE.put_line( FND_FILE.LOG,'32');

17778: --FND_FILE.put_line( FND_FILE.LOG,'l_one_line-->'||l_one_line);
17779: --FND_FILE.put_line( FND_FILE.LOG,'c_endline_len-->'||c_endline_len);
17780: l_start := l_end + c_endline_len;
17781: --FND_FILE.put_line( FND_FILE.LOG,'l_start-->'||l_start);
17782: --FND_FILE.put_line( FND_FILE.LOG,'32');
17783: Fnd_File.PUT_line(Fnd_File.OUTPUT,l_one_line);
17784: END LOOP;
17785: END PRINT_CLOB;
17786:

Line 17783: Fnd_File.PUT_line(Fnd_File.OUTPUT,l_one_line);

17779: --FND_FILE.put_line( FND_FILE.LOG,'c_endline_len-->'||c_endline_len);
17780: l_start := l_end + c_endline_len;
17781: --FND_FILE.put_line( FND_FILE.LOG,'l_start-->'||l_start);
17782: --FND_FILE.put_line( FND_FILE.LOG,'32');
17783: Fnd_File.PUT_line(Fnd_File.OUTPUT,l_one_line);
17784: END LOOP;
17785: END PRINT_CLOB;
17786:
17787: /*========================================================================+

Line 18006: FND_FILE.put_line( FND_FILE.LOG,'XML generation starts');

18002: l_req_id number;
18003: l_encoding VARCHAR2(100); --Added for bug 10141904 gnramasa 24th Sep 10
18004:
18005: begin
18006: FND_FILE.put_line( FND_FILE.LOG,'XML generation starts');
18007: l_req_id := p_request_id;
18008:
18009: select to_char(sysdate, 'YYYY-MM-DD')
18010: into l_report_date

Line 18024: FND_FILE.put_line( FND_FILE.LOG,'l_query_party ==> ' || l_query_party);

18020: close c_calculate_no_rec;
18021:
18022: if p_running_level = 'PARTY' then
18023: ctx := DBMS_XMLQUERY.newContext(l_query_party);
18024: FND_FILE.put_line( FND_FILE.LOG,'l_query_party ==> ' || l_query_party);
18025: elsif p_running_level = 'ACCOUNT' then
18026: ctx := DBMS_XMLQUERY.newContext(l_query_account);
18027: FND_FILE.put_line( FND_FILE.LOG,'l_query_party ==> ' || l_query_account);
18028: elsif p_running_level = 'BILL_TO' then

Line 18027: FND_FILE.put_line( FND_FILE.LOG,'l_query_party ==> ' || l_query_account);

18023: ctx := DBMS_XMLQUERY.newContext(l_query_party);
18024: FND_FILE.put_line( FND_FILE.LOG,'l_query_party ==> ' || l_query_party);
18025: elsif p_running_level = 'ACCOUNT' then
18026: ctx := DBMS_XMLQUERY.newContext(l_query_account);
18027: FND_FILE.put_line( FND_FILE.LOG,'l_query_party ==> ' || l_query_account);
18028: elsif p_running_level = 'BILL_TO' then
18029: ctx := DBMS_XMLQUERY.newContext(l_query_bill_to);
18030: FND_FILE.put_line( FND_FILE.LOG,'l_query_party ==> ' || l_query_bill_to);
18031: elsif p_running_level = 'DELINQUENCY' then

Line 18030: FND_FILE.put_line( FND_FILE.LOG,'l_query_party ==> ' || l_query_bill_to);

18026: ctx := DBMS_XMLQUERY.newContext(l_query_account);
18027: FND_FILE.put_line( FND_FILE.LOG,'l_query_party ==> ' || l_query_account);
18028: elsif p_running_level = 'BILL_TO' then
18029: ctx := DBMS_XMLQUERY.newContext(l_query_bill_to);
18030: FND_FILE.put_line( FND_FILE.LOG,'l_query_party ==> ' || l_query_bill_to);
18031: elsif p_running_level = 'DELINQUENCY' then
18032: ctx := DBMS_XMLQUERY.newContext(l_query_delinquency);
18033: FND_FILE.put_line( FND_FILE.LOG,'l_query_party ==> ' || l_query_delinquency);
18034: else

Line 18033: FND_FILE.put_line( FND_FILE.LOG,'l_query_party ==> ' || l_query_delinquency);

18029: ctx := DBMS_XMLQUERY.newContext(l_query_bill_to);
18030: FND_FILE.put_line( FND_FILE.LOG,'l_query_party ==> ' || l_query_bill_to);
18031: elsif p_running_level = 'DELINQUENCY' then
18032: ctx := DBMS_XMLQUERY.newContext(l_query_delinquency);
18033: FND_FILE.put_line( FND_FILE.LOG,'l_query_party ==> ' || l_query_delinquency);
18034: else
18035: ctx := DBMS_XMLQUERY.newContext(l_query_party);
18036: FND_FILE.put_line( FND_FILE.LOG,'l_query_party ==> ' || l_query_party);
18037: end if;

Line 18036: FND_FILE.put_line( FND_FILE.LOG,'l_query_party ==> ' || l_query_party);

18032: ctx := DBMS_XMLQUERY.newContext(l_query_delinquency);
18033: FND_FILE.put_line( FND_FILE.LOG,'l_query_party ==> ' || l_query_delinquency);
18034: else
18035: ctx := DBMS_XMLQUERY.newContext(l_query_party);
18036: FND_FILE.put_line( FND_FILE.LOG,'l_query_party ==> ' || l_query_party);
18037: end if;
18038:
18039: DBMS_XMLQuery.setRaiseNoRowsException(ctx,TRUE);
18040: -- Bind Mandatory Variables

Line 18051: FND_FILE.put_line( FND_FILE.LOG,'In excepition, Error is: '||sqlerrm);

18047: DBMS_XMLQuery.closeContext(ctx);
18048: l_rows_processed := 1;
18049: EXCEPTION
18050: WHEN OTHERS THEN
18051: FND_FILE.put_line( FND_FILE.LOG,'In excepition, Error is: '||sqlerrm);
18052: DBMS_XMLQuery.getExceptionContent(ctx,l_errNo,l_errMsg);
18053: IF l_errNo = 1403 THEN
18054: FND_FILE.put_line( FND_FILE.LOG,'Query not returned any rows');
18055: l_rows_processed := 0;

Line 18054: FND_FILE.put_line( FND_FILE.LOG,'Query not returned any rows');

18050: WHEN OTHERS THEN
18051: FND_FILE.put_line( FND_FILE.LOG,'In excepition, Error is: '||sqlerrm);
18052: DBMS_XMLQuery.getExceptionContent(ctx,l_errNo,l_errMsg);
18053: IF l_errNo = 1403 THEN
18054: FND_FILE.put_line( FND_FILE.LOG,'Query not returned any rows');
18055: l_rows_processed := 0;
18056: END IF;
18057: DBMS_XMLQuery.closeContext(ctx);
18058: END;

Line 18066: FND_FILE.put_line( FND_FILE.LOG,'Start constructing the XML Header');

18062: ELSE
18063: l_resultOffset := 0;
18064: END IF;
18065:
18066: FND_FILE.put_line( FND_FILE.LOG,'Start constructing the XML Header');
18067: l_new_line := '
18068: ';
18069: /*Get the special characters replaced */
18070: l_report_date := format_string(l_report_date);

Line 18097: FND_FILE.put_line( FND_FILE.LOG,'Constructing the XML Header is success');

18093: l_xml_header := l_xml_header ||l_new_line||' ' || p_org_id_coll_method ||''; -- Added by snuthala for bug 10221334 21/10/2010
18094: l_close_tag := l_new_line||''||l_new_line;
18095: l_xml_header_length := length(l_xml_header);
18096: tempResult := l_xml_header;
18097: FND_FILE.put_line( FND_FILE.LOG,'Constructing the XML Header is success');
18098:
18099: IF l_rows_processed <> 0 THEN
18100: FND_FILE.put_line( FND_FILE.LOG,'Start constructing the XML body');
18101: dbms_lob.copy(tempResult,l_result

Line 18100: FND_FILE.put_line( FND_FILE.LOG,'Start constructing the XML body');

18096: tempResult := l_xml_header;
18097: FND_FILE.put_line( FND_FILE.LOG,'Constructing the XML Header is success');
18098:
18099: IF l_rows_processed <> 0 THEN
18100: FND_FILE.put_line( FND_FILE.LOG,'Start constructing the XML body');
18101: dbms_lob.copy(tempResult,l_result
18102: ,dbms_lob.getlength(l_result)-l_resultOffset
18103: ,l_xml_header_length,l_resultOffset);
18104: ELSE

Line 18110: FND_FILE.put_line( FND_FILE.LOG,'Constructing the XML Body is success');

18106: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
18107: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
18108: END IF;
18109:
18110: FND_FILE.put_line( FND_FILE.LOG,'Constructing the XML Body is success');
18111: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);
18112: FND_FILE.put_line( FND_FILE.LOG,'Appended close tag to XML data');
18113: -- Fnd_File.PUT_line(Fnd_File.OUTPUT,tempResult);
18114: print_clob(lob_loc => tempResult);

Line 18112: FND_FILE.put_line( FND_FILE.LOG,'Appended close tag to XML data');

18108: END IF;
18109:
18110: FND_FILE.put_line( FND_FILE.LOG,'Constructing the XML Body is success');
18111: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);
18112: FND_FILE.put_line( FND_FILE.LOG,'Appended close tag to XML data');
18113: -- Fnd_File.PUT_line(Fnd_File.OUTPUT,tempResult);
18114: print_clob(lob_loc => tempResult);
18115: FND_FILE.put_line( FND_FILE.LOG,'XML generation is success');
18116:

Line 18113: -- Fnd_File.PUT_line(Fnd_File.OUTPUT,tempResult);

18109:
18110: FND_FILE.put_line( FND_FILE.LOG,'Constructing the XML Body is success');
18111: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);
18112: FND_FILE.put_line( FND_FILE.LOG,'Appended close tag to XML data');
18113: -- Fnd_File.PUT_line(Fnd_File.OUTPUT,tempResult);
18114: print_clob(lob_loc => tempResult);
18115: FND_FILE.put_line( FND_FILE.LOG,'XML generation is success');
18116:
18117: x_no_of_rec_prc := l_no_of_rec_prc;

Line 18115: FND_FILE.put_line( FND_FILE.LOG,'XML generation is success');

18111: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);
18112: FND_FILE.put_line( FND_FILE.LOG,'Appended close tag to XML data');
18113: -- Fnd_File.PUT_line(Fnd_File.OUTPUT,tempResult);
18114: print_clob(lob_loc => tempResult);
18115: FND_FILE.put_line( FND_FILE.LOG,'XML generation is success');
18116:
18117: x_no_of_rec_prc := l_no_of_rec_prc;
18118: x_no_of_succ_rec := l_no_of_succ_rec;
18119: x_no_of_fail_rec := l_no_of_fail_rec;

Line 18123: FND_FILE.put_line( FND_FILE.LOG,'err'||sqlerrm);

18119: x_no_of_fail_rec := l_no_of_fail_rec;
18120:
18121: EXCEPTION
18122: WHEN OTHERS THEN
18123: FND_FILE.put_line( FND_FILE.LOG,'err'||sqlerrm);
18124: RAISE;
18125: END gen_xml_data_dunning;
18126: --End adding for bug 8489610 by gnramasa 14-May-09
18127:

Line 18354: FND_FILE.PUT_LINE(FND_FILE.LOG, 'expect exception' );

18350: FND_MSG_PUB.Count_And_Get
18351: ( p_count => x_msg_count,
18352: p_data => x_msg_data );
18353: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Exc Exception');
18354: FND_FILE.PUT_LINE(FND_FILE.LOG, 'expect exception' );
18355: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - error='||SQLERRM);
18356:
18357: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
18358: COMMIT WORK;

Line 18364: FND_FILE.PUT_LINE(FND_FILE.LOG, 'unexpect exception' );

18360: FND_MSG_PUB.Count_And_Get
18361: ( p_count => x_msg_count,
18362: p_data => x_msg_data );
18363: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - UnExc Exception');
18364: FND_FILE.PUT_LINE(FND_FILE.LOG, 'unexpect exception' );
18365: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - error='||SQLERRM);
18366:
18367: WHEN OTHERS THEN
18368: COMMIT WORK;

Line 18374: FND_FILE.PUT_LINE(FND_FILE.LOG, 'unexpect exception' );

18370: FND_MSG_PUB.Count_And_Get
18371: ( p_count => x_msg_count,
18372: p_data => x_msg_data );
18373: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Other Exception');
18374: FND_FILE.PUT_LINE(FND_FILE.LOG, 'unexpect exception' );
18375: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - error='||SQLERRM);
18376:
18377: END stage_dunning_inv_copy;
18378: