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 3283: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Missing Score');

3279:
3280: If ( C_GET_SCORE%NOTFOUND) Then
3281: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_SCORE');
3282: FND_MSG_PUB.Add;
3283: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Missing Score');
3284: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Missing Score');
3285: Close C_Get_SCORE;
3286: RAISE FND_API.G_EXC_ERROR;
3287: END IF;

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

3314: If ( x_return_status <> FND_API.G_RET_STS_SUCCESS) Then
3315: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_AGINGBUCKETLINE');
3316: FND_MSG_PUB.Add;
3317: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - AgingBucketLineId notfound');
3318: FND_FILE.PUT_LINE(FND_FILE.LOG, 'AgingBucketLineId NotFound');
3319: RAISE FND_API.G_EXC_ERROR;
3320: END IF;
3321: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - lineid='||l_bucket_line_id);
3322:

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

3338: --FND_MESSAGE.Set_Token ('INFO', 'Template_ID', FALSE);
3339: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_TEMPLATE');
3340: FND_MSG_PUB.Add;
3341: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Missing corresponding template');
3342: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Missing corresponding template');
3343: RAISE FND_API.G_EXC_ERROR;
3344: END IF;
3345:
3346: --WriteLog('iexvdunb:SendLevelDunn:close C_GET_TEMPLATE');

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

3365: (l_curr_dmethod = 'XML' and l_xdo_template_id is null ) ) then
3366: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_TEMPLATE');
3367: FND_MSG_PUB.Add;
3368: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Missing corresponding template');
3369: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Missing corresponding template');
3370: RAISE FND_API.G_EXC_ERROR;
3371:
3372: end if;
3373:

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

3376: *===========================================*/
3377: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - begin check customer profile');
3378:
3379: -- ctlee - check the hz_customer_profiles.dunning_letter
3380: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_party_cust_id = ' || l_party_cust_id);
3381: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_account_id = ' || l_account_id);
3382: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_customer_site_use_id = ' || l_customer_site_use_id);
3383: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_delinquency_id = ' || l_delinquency_id);
3384: -- ctlee - check the hz_customer_profiles.dunning_letter

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

3377: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - begin check customer profile');
3378:
3379: -- ctlee - check the hz_customer_profiles.dunning_letter
3380: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_party_cust_id = ' || l_party_cust_id);
3381: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_account_id = ' || l_account_id);
3382: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_customer_site_use_id = ' || l_customer_site_use_id);
3383: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_delinquency_id = ' || l_delinquency_id);
3384: -- ctlee - check the hz_customer_profiles.dunning_letter
3385: l_party_cust_id_check := l_party_cust_id;

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

3378:
3379: -- ctlee - check the hz_customer_profiles.dunning_letter
3380: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_party_cust_id = ' || l_party_cust_id);
3381: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_account_id = ' || l_account_id);
3382: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_customer_site_use_id = ' || l_customer_site_use_id);
3383: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_delinquency_id = ' || l_delinquency_id);
3384: -- ctlee - check the hz_customer_profiles.dunning_letter
3385: l_party_cust_id_check := l_party_cust_id;
3386: l_account_id_check := l_account_id;

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

3379: -- ctlee - check the hz_customer_profiles.dunning_letter
3380: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_party_cust_id = ' || l_party_cust_id);
3381: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_account_id = ' || l_account_id);
3382: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_customer_site_use_id = ' || l_customer_site_use_id);
3383: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_delinquency_id = ' || l_delinquency_id);
3384: -- ctlee - check the hz_customer_profiles.dunning_letter
3385: l_party_cust_id_check := l_party_cust_id;
3386: l_account_id_check := l_account_id;
3387: l_customer_site_use_id_check := l_customer_site_use_id;

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

3404: ) then
3405: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_DUNNING_PROFILE_NO');
3406: FND_MSG_PUB.Add;
3407: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Send dunning in customer profile set to no ');
3408: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Send dunning in customer profile set to no ');
3409: x_return_status := FND_API.G_RET_STS_ERROR;
3410: GOTO end_api;
3411: end if;
3412:

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

3418: ) then
3419: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_DUNNING_AMOUNT_MIN');
3420: FND_MSG_PUB.Add;
3421: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Required min Dunning amount in customer profile ');
3422: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Required min Dunning amount in customer profile ');
3423: x_return_status := FND_API.G_RET_STS_ERROR;
3424: GOTO end_api;
3425: end if;
3426:

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

3444: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - CloseDunning status='|| x_return_status);
3445:
3446: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3447: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Cannot Close Dunning');
3448: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cannot Close Dunning');
3449: x_return_status := FND_API.G_RET_STS_ERROR;
3450: GOTO end_api;
3451: END IF;
3452: --WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - EndCloseDunn');

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

3480: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3481: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_CALLBACKDATE');
3482: FND_MSG_PUB.Add;
3483: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Cannot find callback date');
3484: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cannot find callback date');
3485: x_return_status := FND_API.G_RET_STS_ERROR;
3486: GOTO end_api;
3487: END IF;
3488:

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

3530: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - CreateDunning status='|| x_return_status);
3531:
3532: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3533: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Cannot Create Dunning');
3534: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cannot Create Dunning');
3535: x_return_status := FND_API.G_RET_STS_ERROR;
3536: GOTO end_api;
3537: END IF;
3538:

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

3536: GOTO end_api;
3537: END IF;
3538:
3539: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - DunningId='||l_dunning_id);
3540: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Create Dunning Id='|| l_dunning_id);
3541: l_dunn_cnt := l_dunn_cnt + 1;
3542:
3543: /*===========================================
3544: * Send letter thru fulfillment

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

3611: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - SEND status='|| x_return_status);
3612:
3613: IF x_return_status <> FND_API.G_RET_STS_SUCCESS and x_return_status <> 'W' THEN
3614: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Sending process failed');
3615: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Sending process failed ');
3616: x_return_status := FND_API.G_RET_STS_ERROR;
3617: GOTO end_api;
3618: elsif x_return_status = 'W' then
3619: l_warning_flag := 'W';

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

3619: l_warning_flag := 'W';
3620: END IF;
3621:
3622: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - request_id = ' ||l_request_id);
3623: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Request Id = ' || l_request_id);
3624: l_ffm_cnt := l_ffm_cnt + 1;
3625:
3626: l_dunning_rec_upd.dunning_id := l_dunning_id;
3627: if (l_curr_dmethod = 'FFM') then

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

3648: p_data => x_msg_data );
3649: for i in 1..x_msg_count loop
3650: errmsg := FND_MSG_PUB.Get(p_msg_index => i,
3651: p_encoded => 'F');
3652: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error:'||errmsg);
3653: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - errmsg=' || errmsg);
3654: end loop;
3655: end if;
3656: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - end_api');

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

3657:
3658: ELSE -- l_noskip = 0
3659: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - all del disputed');
3660: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - skip this party/accnt/site');
3661: FND_FILE.PUT_LINE(FND_FILE.LOG, 'all delinquencies disputed' );
3662: FND_FILE.PUT_LINE(FND_FILE.LOG, 'skip this party/account/site' );
3663: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
3664: p_data => x_msg_data );
3665: x_return_status := 'SKIP'; --FND_API.G_EXC_ERROR;

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

3658: ELSE -- l_noskip = 0
3659: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - all del disputed');
3660: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - skip this party/accnt/site');
3661: FND_FILE.PUT_LINE(FND_FILE.LOG, 'all delinquencies disputed' );
3662: FND_FILE.PUT_LINE(FND_FILE.LOG, 'skip this party/account/site' );
3663: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
3664: p_data => x_msg_data );
3665: x_return_status := 'SKIP'; --FND_API.G_EXC_ERROR;
3666:

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

3689: FND_MSG_PUB.Count_And_Get
3690: ( p_count => x_msg_count,
3691: p_data => x_msg_data );
3692: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Exc Exception');
3693: FND_FILE.PUT_LINE(FND_FILE.LOG, 'expect exception' );
3694: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - error='||SQLERRM);
3695:
3696:
3697: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

3700: FND_MSG_PUB.Count_And_Get
3701: ( p_count => x_msg_count,
3702: p_data => x_msg_data );
3703: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - UnExc Exception');
3704: FND_FILE.PUT_LINE(FND_FILE.LOG, 'unexpect exception' );
3705: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - error='||SQLERRM);
3706:
3707:
3708: WHEN OTHERS THEN

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

3711: FND_MSG_PUB.Count_And_Get
3712: ( p_count => x_msg_count,
3713: p_data => x_msg_data );
3714: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Other Exception');
3715: FND_FILE.PUT_LINE(FND_FILE.LOG, 'unexpect exception' );
3716: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - error='||SQLERRM);
3717:
3718: END Send_Level_Dunning;
3719:

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

3875: LOOP
3876: l_delinquency_id := p_delinquencies_tbl(i).delinquency_id;
3877: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - ==================');
3878: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - ' || l_delinquency_Id);
3879: FND_FILE.PUT_LINE(FND_FILE.LOG, 'delinquency_id='||l_delinquency_id );
3880:
3881: -- Validate Data
3882:
3883: /*=============================================================

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

3918: , x_msg_data => x_msg_data);
3919:
3920: IF x_return_status = 'T' THEN
3921: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Dispute exists and is pending');
3922: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Dispute exists and is pending' );
3923: GOTO end_loop;
3924: elsif x_return_status = 'F' THEN
3925: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - No Dispute or status is COMPLETE');
3926: END IF;

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

3955: --FND_MESSAGE.Set_Token ('INFO', 'iex:AginBucketLineId', FALSE);
3956: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_AGINGBUCKETLINE');
3957: FND_MSG_PUB.Add;
3958: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Cannot Get AgingBucketLineId');
3959: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cannot AgingBucketLineId' );
3960: --msg
3961: FND_MSG_PUB.Count_And_Get
3962: ( p_count => x_msg_count,
3963: p_data => x_msg_data );

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

3963: p_data => x_msg_data );
3964: for i in 1..x_msg_count loop
3965: errmsg := FND_MSG_PUB.Get(p_msg_index => i,
3966: p_encoded => 'F');
3967: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error:'||errmsg);
3968: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - errmsg=' || errmsg);
3969: end loop;
3970:
3971: GOTO end_loop;

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

3993: If ( C_GET_TEMPLATE%NOTFOUND) Then
3994: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_TEMPLATE');
3995: FND_MSG_PUB.Add;
3996: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Missing corresponding template');
3997: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Missing corresponding template' );
3998: Close C_Get_TEMPLATE;
3999: GOTO end_loop;
4000: END IF;
4001:

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

4023: --FND_MESSAGE.Set_Token ('INFO', 'Template_ID', FALSE);
4024: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_TEMPLATE');
4025: FND_MSG_PUB.Add;
4026: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Missing corresponding template');
4027: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Missing corresponding template' );
4028: x_return_status := FND_API.G_RET_STS_ERROR;
4029: GOTO end_loop;
4030: end if;
4031:

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

4043: ) then
4044: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_DUNNING_PROFILE_NO');
4045: FND_MSG_PUB.Add;
4046: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Send dunning in customer profile set to no ');
4047: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Send dunning in customer profile set to no ');
4048: GOTO end_loop;
4049: end if;
4050:
4051:

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

4056: ) then
4057: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_DUNNING_AMOUNT_MIN');
4058: FND_MSG_PUB.Add;
4059: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Required min Dunning amount in customer profile ');
4060: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Required min Dunning amount in customer profile ');
4061: GOTO end_loop;
4062: end if;
4063:
4064: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - end check customer profile');

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

4186: GOTO end_loop;
4187: END IF;
4188:
4189: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - DunningId='||l_dunning_id);
4190: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'Create Dunning Id=' ||l_dunning_id);
4191: l_dunn_cnt := l_dunn_cnt + 1;
4192:
4193: /*===========================================
4194: * Send Letter through Fulfillment

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

4273: p_data => x_msg_data );
4274: for i in 1..x_msg_count loop
4275: errmsg := FND_MSG_PUB.Get(p_msg_index => i,
4276: p_encoded => 'F');
4277: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error:'||errmsg);
4278: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - errmsg=' || errmsg);
4279: end loop;
4280: GOTO end_loop;
4281: elsif x_return_status = 'W' then

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

4726: *===========================================*/
4727:
4728: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - begin check customer profile');
4729: -- ctlee - check the hz_customer_profiles.dunning_letter
4730: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_party_cust_id = ' || l_party_cust_id);
4731: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_account_id = ' || l_account_id);
4732: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_customer_site_use_id = ' || l_customer_site_use_id);
4733: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_delinquency_id = ' || l_delinquency_id);
4734: -- ctlee - check the hz_customer_profiles.dunning_letter

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

4727:
4728: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - begin check customer profile');
4729: -- ctlee - check the hz_customer_profiles.dunning_letter
4730: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_party_cust_id = ' || l_party_cust_id);
4731: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_account_id = ' || l_account_id);
4732: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_customer_site_use_id = ' || l_customer_site_use_id);
4733: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_delinquency_id = ' || l_delinquency_id);
4734: -- ctlee - check the hz_customer_profiles.dunning_letter
4735: l_party_cust_id_check := l_party_cust_id;

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

4728: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - begin check customer profile');
4729: -- ctlee - check the hz_customer_profiles.dunning_letter
4730: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_party_cust_id = ' || l_party_cust_id);
4731: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_account_id = ' || l_account_id);
4732: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_customer_site_use_id = ' || l_customer_site_use_id);
4733: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_delinquency_id = ' || l_delinquency_id);
4734: -- ctlee - check the hz_customer_profiles.dunning_letter
4735: l_party_cust_id_check := l_party_cust_id;
4736: l_account_id_check := l_account_id;

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

4729: -- ctlee - check the hz_customer_profiles.dunning_letter
4730: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_party_cust_id = ' || l_party_cust_id);
4731: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_account_id = ' || l_account_id);
4732: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_customer_site_use_id = ' || l_customer_site_use_id);
4733: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_delinquency_id = ' || l_delinquency_id);
4734: -- ctlee - check the hz_customer_profiles.dunning_letter
4735: l_party_cust_id_check := l_party_cust_id;
4736: l_account_id_check := l_account_id;
4737: l_customer_site_use_id_check := l_customer_site_use_id;

Line 5208: --dont write into FND_FILE

5204:
5205: -- Initialize API return status to SUCCESS
5206: x_return_status := FND_API.G_RET_STS_SUCCESS;
5207:
5208: --dont write into FND_FILE
5209: --l_write := 0;
5210:
5211: --
5212: -- Api body

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

5871: --
5872: END IF;
5873: --
5874: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - days='||l_days);
5875: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_days = ' || l_days);
5876:
5877: Open C_Get_BUCKET_LINE(l_days, p_dunning_plan_id);
5878: Fetch C_Get_BUCKET_LINE into l_bucket_line_id;
5879: If ( C_GET_BUCKET_LINE%NOTFOUND) Then

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

8665: x_return_status := FND_API.G_RET_STS_SUCCESS;
8666:
8667: l_curr_date := to_char(sysdate, 'YYYYMMDD');
8668: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - CurrDate='||l_curr_date) ;
8669: FND_FILE.PUT_LINE(FND_FILE.LOG, 'current date=' || l_curr_date);
8670: --
8671: -- Api body
8672: --
8673:

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

8686:
8687: If ( C_GET_DUNNING%NOTFOUND ) Then
8688: if (nIdx = 0) then
8689: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - NoOpenDunning with callback_yn=Y');
8690: FND_FILE.PUT_LINE(FND_FILE.LOG, 'NoOpenDunning with callback_yn=Y');
8691:
8692: end if;
8693: exit;
8694: ELSE

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

8697: x_return_status := FND_API.G_RET_STS_SUCCESS;
8698: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - DunningID='||l_dunning_id) ;
8699: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - DunningObjectID='||l_dunning_object_id) ;
8700: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Callback_Date='||l_callback_date) ;
8701: FND_FILE.PUT_LINE(FND_FILE.LOG, '*****dunning_id='||l_dunning_id||'*****');
8702:
8703: /*=========================================
8704: * bug 2816550 - clchan updatd 02/21/2003
8705: * for this current dunning,

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

8711: Fetch C_CHK_CUSTOMER into l_chk;
8712:
8713: If ( C_CHK_CUSTOMER%NOTFOUND) Then
8714: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - All Del Closed for this customer');
8715: FND_FILE.PUT_LINE(FND_FILE.LOG, 'All Delinquencies Closed for this customer');
8716: Close C_CHK_CUSTOMER;
8717: l_skip := 1;
8718: else
8719: l_skip := 0;

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

8727: Fetch C_CHK_Account into l_chk;
8728:
8729: If ( C_CHK_Account%NOTFOUND) Then
8730: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - All Del Closed for this Account');
8731: FND_FILE.PUT_LINE(FND_FILE.LOG, 'All Delinquencies Closed for this account');
8732: Close C_CHK_Account;
8733: --GOTO end_dunning_if;
8734: l_skip := 1;
8735: else

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

8744: Fetch C_CHK_Site into l_chk;
8745:
8746: If ( C_CHK_Site%NOTFOUND) Then
8747: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - All Del Closed for this site');
8748: FND_FILE.PUT_LINE(FND_FILE.LOG, 'All Delinquencies Closed for this site');
8749: Close C_CHK_Site;
8750: --GOTO end_dunning_if;
8751: l_skip := 1;
8752: else

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

8761: Fetch C_CHK_DEL into l_chk;
8762:
8763: If ( C_CHK_DEL%NOTFOUND) Then
8764: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Del Closed for this del');
8765: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Delinquency Closed');
8766: Close C_CHK_DEL;
8767: --GOTO end_dunning_if;
8768: l_skip := 1;
8769: else

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

8797:
8798:
8799: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
8800: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Cannot create new Task');
8801: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cannot create new task');
8802: FND_MSG_PUB.Count_And_Get
8803: ( p_count => x_msg_count,
8804: p_data => x_msg_data );
8805: for i in 1..x_msg_count loop

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

8804: p_data => x_msg_data );
8805: for i in 1..x_msg_count loop
8806: errmsg := FND_MSG_PUB.Get(p_msg_index => i,
8807: p_encoded => 'F');
8808: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error:'||errmsg);
8809: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - errmsg=' || errmsg);
8810: end loop;
8811: l_skip := 1;
8812: else

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

8811: l_skip := 1;
8812: else
8813: l_skip := 0;
8814: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - taskid='||l_task_id);
8815: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'task_id='||l_task_id);
8816: l_task_cnt := l_task_cnt + 1;
8817: END IF; -- end of create_task
8818:
8819: /*======================

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

9283: l_resource_id := l_default_rs_id;
9284: else
9285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9286: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Cannot get resource from customer profile and there is no default resource set');
9287: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No collector has been assigned to this customer '||l_party_name);
9288: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No default collector available to assign to callback. Please update default collector.');
9289: GOTO end_new_task;
9290: end if;
9291: end if;

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

9284: else
9285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9286: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Cannot get resource from customer profile and there is no default resource set');
9287: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No collector has been assigned to this customer '||l_party_name);
9288: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No default collector available to assign to callback. Please update default collector.');
9289: GOTO end_new_task;
9290: end if;
9291: end if;
9292: --End Bug#5229763 schekuri 27-Jul-2006