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_GLOBAL

Line 2106: , p_last_updated_by => FND_GLOBAL.USER_ID

2102: IEX_AG_DN_PKG.insert_row(
2103: px_rowid => l_rowid
2104: , px_AG_DN_XREF_id => x_AG_DN_XREF_id
2105: , p_last_update_date => sysdate
2106: , p_last_updated_by => FND_GLOBAL.USER_ID
2107: , p_creation_date => sysdate
2108: , p_created_by => FND_GLOBAL.USER_ID
2109: , p_last_update_login => FND_GLOBAL.USER_ID
2110: , p_aging_bucket_id => l_AG_DN_XREF_rec.aging_bucket_id

Line 2108: , p_created_by => FND_GLOBAL.USER_ID

2104: , px_AG_DN_XREF_id => x_AG_DN_XREF_id
2105: , p_last_update_date => sysdate
2106: , p_last_updated_by => FND_GLOBAL.USER_ID
2107: , p_creation_date => sysdate
2108: , p_created_by => FND_GLOBAL.USER_ID
2109: , p_last_update_login => FND_GLOBAL.USER_ID
2110: , p_aging_bucket_id => l_AG_DN_XREF_rec.aging_bucket_id
2111: , p_aging_bucket_line_id => l_AG_DN_XREF_rec.aging_bucket_line_id
2112: , p_callback_flag => l_AG_DN_XREF_rec.callback_flag

Line 2109: , p_last_update_login => FND_GLOBAL.USER_ID

2105: , p_last_update_date => sysdate
2106: , p_last_updated_by => FND_GLOBAL.USER_ID
2107: , p_creation_date => sysdate
2108: , p_created_by => FND_GLOBAL.USER_ID
2109: , p_last_update_login => FND_GLOBAL.USER_ID
2110: , p_aging_bucket_id => l_AG_DN_XREF_rec.aging_bucket_id
2111: , p_aging_bucket_line_id => l_AG_DN_XREF_rec.aging_bucket_line_id
2112: , p_callback_flag => l_AG_DN_XREF_rec.callback_flag
2113: , p_callback_days => l_AG_DN_XREF_rec.callback_days

Line 2335: , p_last_updated_by => FND_GLOBAL.USER_ID

2331: IEX_AG_DN_PKG.update_row(
2332: p_rowid => l_rowid
2333: , p_AG_DN_XREF_id => p_AG_DN_XREF_id
2334: , p_last_update_date => sysdate
2335: , p_last_updated_by => FND_GLOBAL.USER_ID
2336: , p_creation_date => l_AG_DN_XREF_rec.creation_date
2337: , p_created_by => l_AG_DN_XREF_rec.created_by
2338: , p_last_update_login => FND_GLOBAL.USER_ID
2339: , p_aging_bucket_id => l_AG_DN_XREF_rec.aging_bucket_id

Line 2338: , p_last_update_login => FND_GLOBAL.USER_ID

2334: , p_last_update_date => sysdate
2335: , p_last_updated_by => FND_GLOBAL.USER_ID
2336: , p_creation_date => l_AG_DN_XREF_rec.creation_date
2337: , p_created_by => l_AG_DN_XREF_rec.created_by
2338: , p_last_update_login => FND_GLOBAL.USER_ID
2339: , p_aging_bucket_id => l_AG_DN_XREF_rec.aging_bucket_id
2340: , p_aging_bucket_line_id => l_AG_DN_XREF_rec.aging_bucket_line_id
2341: , p_callback_flag => l_AG_DN_XREF_rec.callback_flag
2342: , p_callback_days => l_AG_DN_XREF_rec.callback_days

Line 2575: , p_last_updated_by => FND_GLOBAL.USER_ID

2571: IEX_Dunnings_PKG.insert_row(
2572: px_rowid => l_rowid
2573: , px_dunning_id => x_dunning_id
2574: , p_last_update_date => sysdate
2575: , p_last_updated_by => FND_GLOBAL.USER_ID
2576: , p_creation_date => sysdate
2577: , p_created_by => FND_GLOBAL.USER_ID
2578: , p_last_update_login => FND_GLOBAL.USER_ID
2579: -- , p_request_id => FND_GLOBAL.CONC_REQUEST_ID

Line 2577: , p_created_by => FND_GLOBAL.USER_ID

2573: , px_dunning_id => x_dunning_id
2574: , p_last_update_date => sysdate
2575: , p_last_updated_by => FND_GLOBAL.USER_ID
2576: , p_creation_date => sysdate
2577: , p_created_by => FND_GLOBAL.USER_ID
2578: , p_last_update_login => FND_GLOBAL.USER_ID
2579: -- , p_request_id => FND_GLOBAL.CONC_REQUEST_ID
2580: , p_request_id => l_dunning_rec.request_id
2581: , p_template_id => l_dunning_rec.template_id

Line 2578: , p_last_update_login => FND_GLOBAL.USER_ID

2574: , p_last_update_date => sysdate
2575: , p_last_updated_by => FND_GLOBAL.USER_ID
2576: , p_creation_date => sysdate
2577: , p_created_by => FND_GLOBAL.USER_ID
2578: , p_last_update_login => FND_GLOBAL.USER_ID
2579: -- , p_request_id => FND_GLOBAL.CONC_REQUEST_ID
2580: , p_request_id => l_dunning_rec.request_id
2581: , p_template_id => l_dunning_rec.template_id
2582: , p_callback_yn => l_dunning_rec.callback_yn

Line 2579: -- , p_request_id => FND_GLOBAL.CONC_REQUEST_ID

2575: , p_last_updated_by => FND_GLOBAL.USER_ID
2576: , p_creation_date => sysdate
2577: , p_created_by => FND_GLOBAL.USER_ID
2578: , p_last_update_login => FND_GLOBAL.USER_ID
2579: -- , p_request_id => FND_GLOBAL.CONC_REQUEST_ID
2580: , p_request_id => l_dunning_rec.request_id
2581: , p_template_id => l_dunning_rec.template_id
2582: , p_callback_yn => l_dunning_rec.callback_yn
2583: , p_callback_date => l_dunning_rec.callback_date

Line 2878: , p_created_by => FND_GLOBAL.USER_ID

2874: , p_cust_trx_id => l_transaction_id
2875: , p_payment_schedule_id => l_payment_schedule_id
2876: , p_ag_dn_xref_id => p_ag_dn_xref_id
2877: , p_stage_number => i
2878: , p_created_by => FND_GLOBAL.USER_ID
2879: , p_creation_date => sysdate
2880: , p_last_updated_by => FND_GLOBAL.USER_ID
2881: , p_last_update_date => sysdate
2882: , p_last_update_login => FND_GLOBAL.USER_ID

Line 2880: , p_last_updated_by => FND_GLOBAL.USER_ID

2876: , p_ag_dn_xref_id => p_ag_dn_xref_id
2877: , p_stage_number => i
2878: , p_created_by => FND_GLOBAL.USER_ID
2879: , p_creation_date => sysdate
2880: , p_last_updated_by => FND_GLOBAL.USER_ID
2881: , p_last_update_date => sysdate
2882: , p_last_update_login => FND_GLOBAL.USER_ID
2883: , p_object_version_number => 1.0
2884: );

Line 2882: , p_last_update_login => FND_GLOBAL.USER_ID

2878: , p_created_by => FND_GLOBAL.USER_ID
2879: , p_creation_date => sysdate
2880: , p_last_updated_by => FND_GLOBAL.USER_ID
2881: , p_last_update_date => sysdate
2882: , p_last_update_login => FND_GLOBAL.USER_ID
2883: , p_object_version_number => 1.0
2884: );
2885:
2886: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - x_dunning_trx_id :'|| x_dunning_trx_id);

Line 2950: , p_created_by => FND_GLOBAL.USER_ID

2946: , p_cust_trx_id => l_transaction_id
2947: , p_payment_schedule_id => l_payment_schedule_id
2948: , p_ag_dn_xref_id => p_ag_dn_xref_id
2949: , p_stage_number => i
2950: , p_created_by => FND_GLOBAL.USER_ID
2951: , p_creation_date => sysdate
2952: , p_last_updated_by => FND_GLOBAL.USER_ID
2953: , p_last_update_date => sysdate
2954: , p_last_update_login => FND_GLOBAL.USER_ID

Line 2952: , p_last_updated_by => FND_GLOBAL.USER_ID

2948: , p_ag_dn_xref_id => p_ag_dn_xref_id
2949: , p_stage_number => i
2950: , p_created_by => FND_GLOBAL.USER_ID
2951: , p_creation_date => sysdate
2952: , p_last_updated_by => FND_GLOBAL.USER_ID
2953: , p_last_update_date => sysdate
2954: , p_last_update_login => FND_GLOBAL.USER_ID
2955: , p_object_version_number => 1.0
2956: );

Line 2954: , p_last_update_login => FND_GLOBAL.USER_ID

2950: , p_created_by => FND_GLOBAL.USER_ID
2951: , p_creation_date => sysdate
2952: , p_last_updated_by => FND_GLOBAL.USER_ID
2953: , p_last_update_date => sysdate
2954: , p_last_update_login => FND_GLOBAL.USER_ID
2955: , p_object_version_number => 1.0
2956: );
2957:
2958: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - x_dunning_trx_id :'|| x_dunning_trx_id);

Line 3063: , p_created_by => FND_GLOBAL.USER_ID

3059: , p_cust_trx_id => l_transaction_id
3060: , p_payment_schedule_id => l_payment_schedule_id
3061: , p_ag_dn_xref_id => p_ag_dn_xref_id
3062: , p_stage_number => i
3063: , p_created_by => FND_GLOBAL.USER_ID
3064: , p_creation_date => sysdate
3065: , p_last_updated_by => FND_GLOBAL.USER_ID
3066: , p_last_update_date => sysdate
3067: , p_last_update_login => FND_GLOBAL.USER_ID

Line 3065: , p_last_updated_by => FND_GLOBAL.USER_ID

3061: , p_ag_dn_xref_id => p_ag_dn_xref_id
3062: , p_stage_number => i
3063: , p_created_by => FND_GLOBAL.USER_ID
3064: , p_creation_date => sysdate
3065: , p_last_updated_by => FND_GLOBAL.USER_ID
3066: , p_last_update_date => sysdate
3067: , p_last_update_login => FND_GLOBAL.USER_ID
3068: , p_object_version_number => 1.0
3069: );

Line 3067: , p_last_update_login => FND_GLOBAL.USER_ID

3063: , p_created_by => FND_GLOBAL.USER_ID
3064: , p_creation_date => sysdate
3065: , p_last_updated_by => FND_GLOBAL.USER_ID
3066: , p_last_update_date => sysdate
3067: , p_last_update_login => FND_GLOBAL.USER_ID
3068: , p_object_version_number => 1.0
3069: );
3070:
3071: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - x_dunning_trx_id :'|| x_dunning_trx_id);

Line 3150: , p_created_by => FND_GLOBAL.USER_ID

3146: , p_cust_trx_id => l_transaction_id
3147: , p_payment_schedule_id => l_payment_schedule_id
3148: , p_ag_dn_xref_id => p_ag_dn_xref_id
3149: , p_stage_number => i
3150: , p_created_by => FND_GLOBAL.USER_ID
3151: , p_creation_date => sysdate
3152: , p_last_updated_by => FND_GLOBAL.USER_ID
3153: , p_last_update_date => sysdate
3154: , p_last_update_login => FND_GLOBAL.USER_ID

Line 3152: , p_last_updated_by => FND_GLOBAL.USER_ID

3148: , p_ag_dn_xref_id => p_ag_dn_xref_id
3149: , p_stage_number => i
3150: , p_created_by => FND_GLOBAL.USER_ID
3151: , p_creation_date => sysdate
3152: , p_last_updated_by => FND_GLOBAL.USER_ID
3153: , p_last_update_date => sysdate
3154: , p_last_update_login => FND_GLOBAL.USER_ID
3155: , p_object_version_number => 1.0
3156: );

Line 3154: , p_last_update_login => FND_GLOBAL.USER_ID

3150: , p_created_by => FND_GLOBAL.USER_ID
3151: , p_creation_date => sysdate
3152: , p_last_updated_by => FND_GLOBAL.USER_ID
3153: , p_last_update_date => sysdate
3154: , p_last_update_login => FND_GLOBAL.USER_ID
3155: , p_object_version_number => 1.0
3156: );
3157:
3158: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - x_dunning_trx_id :'|| x_dunning_trx_id);

Line 3256: , p_created_by => FND_GLOBAL.USER_ID

3252: , p_cust_trx_id => l_customer_trx_id
3253: , p_payment_schedule_id => l_payment_schedule_id
3254: , p_ag_dn_xref_id => p_ag_dn_xref_id
3255: , p_stage_number => null
3256: , p_created_by => FND_GLOBAL.USER_ID
3257: , p_creation_date => sysdate
3258: , p_last_updated_by => FND_GLOBAL.USER_ID
3259: , p_last_update_date => sysdate
3260: , p_last_update_login => FND_GLOBAL.USER_ID

Line 3258: , p_last_updated_by => FND_GLOBAL.USER_ID

3254: , p_ag_dn_xref_id => p_ag_dn_xref_id
3255: , p_stage_number => null
3256: , p_created_by => FND_GLOBAL.USER_ID
3257: , p_creation_date => sysdate
3258: , p_last_updated_by => FND_GLOBAL.USER_ID
3259: , p_last_update_date => sysdate
3260: , p_last_update_login => FND_GLOBAL.USER_ID
3261: , p_object_version_number => 1.0
3262: );

Line 3260: , p_last_update_login => FND_GLOBAL.USER_ID

3256: , p_created_by => FND_GLOBAL.USER_ID
3257: , p_creation_date => sysdate
3258: , p_last_updated_by => FND_GLOBAL.USER_ID
3259: , p_last_update_date => sysdate
3260: , p_last_update_login => FND_GLOBAL.USER_ID
3261: , p_object_version_number => 1.0
3262: );
3263:
3264: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - x_dunning_trx_id :'|| x_dunning_trx_id);

Line 3356: , p_created_by => FND_GLOBAL.USER_ID

3352: , p_cust_trx_id => l_transaction_id
3353: , p_payment_schedule_id => l_payment_schedule_id
3354: , p_ag_dn_xref_id => p_ag_dn_xref_id
3355: , p_stage_number => null
3356: , p_created_by => FND_GLOBAL.USER_ID
3357: , p_creation_date => sysdate
3358: , p_last_updated_by => FND_GLOBAL.USER_ID
3359: , p_last_update_date => sysdate
3360: , p_last_update_login => FND_GLOBAL.USER_ID

Line 3358: , p_last_updated_by => FND_GLOBAL.USER_ID

3354: , p_ag_dn_xref_id => p_ag_dn_xref_id
3355: , p_stage_number => null
3356: , p_created_by => FND_GLOBAL.USER_ID
3357: , p_creation_date => sysdate
3358: , p_last_updated_by => FND_GLOBAL.USER_ID
3359: , p_last_update_date => sysdate
3360: , p_last_update_login => FND_GLOBAL.USER_ID
3361: , p_object_version_number => 1.0
3362: );

Line 3360: , p_last_update_login => FND_GLOBAL.USER_ID

3356: , p_created_by => FND_GLOBAL.USER_ID
3357: , p_creation_date => sysdate
3358: , p_last_updated_by => FND_GLOBAL.USER_ID
3359: , p_last_update_date => sysdate
3360: , p_last_update_login => FND_GLOBAL.USER_ID
3361: , p_object_version_number => 1.0
3362: );
3363:
3364: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - x_dunning_trx_id :'|| x_dunning_trx_id);

Line 3436: , p_created_by => FND_GLOBAL.USER_ID

3432: --, p_cust_trx_id => l_customer_trx_id
3433: , p_payment_schedule_id => l_payment_schedule_id
3434: , p_ag_dn_xref_id => p_ag_dn_xref_id
3435: , p_stage_number => null
3436: , p_created_by => FND_GLOBAL.USER_ID
3437: , p_creation_date => sysdate
3438: , p_last_updated_by => FND_GLOBAL.USER_ID
3439: , p_last_update_date => sysdate
3440: , p_last_update_login => FND_GLOBAL.USER_ID

Line 3438: , p_last_updated_by => FND_GLOBAL.USER_ID

3434: , p_ag_dn_xref_id => p_ag_dn_xref_id
3435: , p_stage_number => null
3436: , p_created_by => FND_GLOBAL.USER_ID
3437: , p_creation_date => sysdate
3438: , p_last_updated_by => FND_GLOBAL.USER_ID
3439: , p_last_update_date => sysdate
3440: , p_last_update_login => FND_GLOBAL.USER_ID
3441: , p_object_version_number => 1.0
3442: );

Line 3440: , p_last_update_login => FND_GLOBAL.USER_ID

3436: , p_created_by => FND_GLOBAL.USER_ID
3437: , p_creation_date => sysdate
3438: , p_last_updated_by => FND_GLOBAL.USER_ID
3439: , p_last_update_date => sysdate
3440: , p_last_update_login => FND_GLOBAL.USER_ID
3441: , p_object_version_number => 1.0
3442: );
3443:
3444: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - x_dunning_trx_id :'|| x_dunning_trx_id);

Line 3507: , p_created_by => FND_GLOBAL.USER_ID

3503: , p_cust_trx_id => l_customer_trx_id
3504: , p_payment_schedule_id => l_payment_schedule_id
3505: , p_ag_dn_xref_id => p_ag_dn_xref_id
3506: , p_stage_number => null
3507: , p_created_by => FND_GLOBAL.USER_ID
3508: , p_creation_date => sysdate
3509: , p_last_updated_by => FND_GLOBAL.USER_ID
3510: , p_last_update_date => sysdate
3511: , p_last_update_login => FND_GLOBAL.USER_ID

Line 3509: , p_last_updated_by => FND_GLOBAL.USER_ID

3505: , p_ag_dn_xref_id => p_ag_dn_xref_id
3506: , p_stage_number => null
3507: , p_created_by => FND_GLOBAL.USER_ID
3508: , p_creation_date => sysdate
3509: , p_last_updated_by => FND_GLOBAL.USER_ID
3510: , p_last_update_date => sysdate
3511: , p_last_update_login => FND_GLOBAL.USER_ID
3512: , p_object_version_number => 1.0
3513: );

Line 3511: , p_last_update_login => FND_GLOBAL.USER_ID

3507: , p_created_by => FND_GLOBAL.USER_ID
3508: , p_creation_date => sysdate
3509: , p_last_updated_by => FND_GLOBAL.USER_ID
3510: , p_last_update_date => sysdate
3511: , p_last_update_login => FND_GLOBAL.USER_ID
3512: , p_object_version_number => 1.0
3513: );
3514:
3515: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - x_dunning_trx_id :'|| x_dunning_trx_id);

Line 3880: , p_last_updated_by => FND_GLOBAL.USER_ID

3876: IEX_DUNNINGS_PKG.Update_Row(
3877: p_rowid => l_rowid
3878: , p_dunning_id => l_dunning_rec.dunning_id
3879: , p_last_update_date => sysdate
3880: , p_last_updated_by => FND_GLOBAL.USER_ID
3881: , p_creation_date => l_dunning_rec.creation_date
3882: , p_created_by => l_dunning_rec.created_by
3883: , p_last_update_login => FND_GLOBAL.USER_ID
3884: --, p_request_id => FND_GLOBAL.CONC_REQUEST_ID

Line 3883: , p_last_update_login => FND_GLOBAL.USER_ID

3879: , p_last_update_date => sysdate
3880: , p_last_updated_by => FND_GLOBAL.USER_ID
3881: , p_creation_date => l_dunning_rec.creation_date
3882: , p_created_by => l_dunning_rec.created_by
3883: , p_last_update_login => FND_GLOBAL.USER_ID
3884: --, p_request_id => FND_GLOBAL.CONC_REQUEST_ID
3885: , p_request_id => l_dunning_rec.request_id
3886: , p_template_id => l_dunning_rec.template_id
3887: , p_callback_yn => l_dunning_rec.callback_yn

Line 3884: --, p_request_id => FND_GLOBAL.CONC_REQUEST_ID

3880: , p_last_updated_by => FND_GLOBAL.USER_ID
3881: , p_creation_date => l_dunning_rec.creation_date
3882: , p_created_by => l_dunning_rec.created_by
3883: , p_last_update_login => FND_GLOBAL.USER_ID
3884: --, p_request_id => FND_GLOBAL.CONC_REQUEST_ID
3885: , p_request_id => l_dunning_rec.request_id
3886: , p_template_id => l_dunning_rec.template_id
3887: , p_callback_yn => l_dunning_rec.callback_yn
3888: , p_callback_date => l_dunning_rec.callback_date

Line 4915: l_dunning_rec.request_id := FND_GLOBAL.Conc_Request_Id;

4911:
4912: if p_parent_request_id is not null then
4913: l_dunning_rec.request_id := p_parent_request_id;
4914: else
4915: l_dunning_rec.request_id := FND_GLOBAL.Conc_Request_Id;
4916: end if;
4917:
4918: --l_dunning_rec.request_id := FND_GLOBAL.Conc_Request_Id;
4919: l_dunning_rec.dunning_mode := p_dunning_mode;

Line 4918: --l_dunning_rec.request_id := FND_GLOBAL.Conc_Request_Id;

4914: else
4915: l_dunning_rec.request_id := FND_GLOBAL.Conc_Request_Id;
4916: end if;
4917:
4918: --l_dunning_rec.request_id := FND_GLOBAL.Conc_Request_Id;
4919: l_dunning_rec.dunning_mode := p_dunning_mode;
4920: l_dunning_rec.confirmation_mode := p_confirmation_mode;
4921: l_dunning_rec.org_id := l_org_id; -- added for bug 9151851
4922: l_dunning_rec.as_of_date := p_correspondence_date;

Line 6400: l_dunning_rec.request_id := FND_GLOBAL.Conc_Request_Id;

6396:
6397: if p_parent_request_id is not null then
6398: l_dunning_rec.request_id := p_parent_request_id;
6399: else
6400: l_dunning_rec.request_id := FND_GLOBAL.Conc_Request_Id;
6401: end if;
6402:
6403: --l_dunning_rec.request_id := FND_GLOBAL.Conc_Request_Id;
6404: l_dunning_rec.dunning_mode := p_dunning_mode;

Line 6403: --l_dunning_rec.request_id := FND_GLOBAL.Conc_Request_Id;

6399: else
6400: l_dunning_rec.request_id := FND_GLOBAL.Conc_Request_Id;
6401: end if;
6402:
6403: --l_dunning_rec.request_id := FND_GLOBAL.Conc_Request_Id;
6404: l_dunning_rec.dunning_mode := p_dunning_mode;
6405: l_dunning_rec.confirmation_mode := p_confirmation_mode;
6406: l_dunning_rec.ag_dn_xref_id := l_dunningplan_lines.ag_dn_xref_id;
6407: l_dunning_rec.correspondence_date := p_correspondence_date;

Line 7673: l_dunning_rec.request_id := FND_GLOBAL.Conc_Request_Id;

7669: l_dunning_rec.as_of_date := p_correspondence_date;
7670: if p_parent_request_id is not null then
7671: l_dunning_rec.request_id := p_parent_request_id;
7672: else
7673: l_dunning_rec.request_id := FND_GLOBAL.Conc_Request_Id;
7674: end if;
7675: WriteLog(' Before creating dunning org_id '|| l_org_id);
7676: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - InsertRow');
7677:

Line 8803: l_dunning_rec.request_id := FND_GLOBAL.Conc_Request_Id;

8799:
8800: if p_parent_request_id is not null then
8801: l_dunning_rec.request_id := p_parent_request_id;
8802: else
8803: l_dunning_rec.request_id := FND_GLOBAL.Conc_Request_Id;
8804: end if;
8805:
8806: l_dunning_rec.org_id := l_org_id;
8807: WriteLog(G_PKG_NAME || ' ' || l_api_name ||' Before creating dunning org_id '|| l_org_id);

Line 8845: , p_created_by => FND_GLOBAL.USER_ID

8841: , p_cust_trx_id => l_transaction_id
8842: , p_payment_schedule_id => l_payment_schedule_id
8843: , p_ag_dn_xref_id => l_ag_dn_xref_id
8844: , p_stage_number => l_stage
8845: , p_created_by => FND_GLOBAL.USER_ID
8846: , p_creation_date => sysdate
8847: , p_last_updated_by => FND_GLOBAL.USER_ID
8848: , p_last_update_date => sysdate
8849: , p_last_update_login => FND_GLOBAL.USER_ID

Line 8847: , p_last_updated_by => FND_GLOBAL.USER_ID

8843: , p_ag_dn_xref_id => l_ag_dn_xref_id
8844: , p_stage_number => l_stage
8845: , p_created_by => FND_GLOBAL.USER_ID
8846: , p_creation_date => sysdate
8847: , p_last_updated_by => FND_GLOBAL.USER_ID
8848: , p_last_update_date => sysdate
8849: , p_last_update_login => FND_GLOBAL.USER_ID
8850: , p_object_version_number => 1.0
8851: );

Line 8849: , p_last_update_login => FND_GLOBAL.USER_ID

8845: , p_created_by => FND_GLOBAL.USER_ID
8846: , p_creation_date => sysdate
8847: , p_last_updated_by => FND_GLOBAL.USER_ID
8848: , p_last_update_date => sysdate
8849: , p_last_update_login => FND_GLOBAL.USER_ID
8850: , p_object_version_number => 1.0
8851: );
8852:
8853: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - x_dunning_trx_id :'|| x_dunning_trx_id);

Line 13250: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - CurrUser='||FND_GLOBAL.USER_ID);

13246:
13247: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Close C_GET_CONTENTS');
13248: Close C_Get_CONTENTS;
13249: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - TotalContents='||nIdx);
13250: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - CurrUser='||FND_GLOBAL.USER_ID);
13251: l_content_nm := nIdx; -- Num of Contents you want send out NOCOPY
13252: l_user_id := FND_GLOBAL.USER_ID; --1001247; -- IEXTEST
13253: l_server_id := NULL; -- Using Default Server
13254: l_subject := NVL(FND_PROFILE.value('IEX_FULFILL_SUBJECT'), '');

Line 13252: l_user_id := FND_GLOBAL.USER_ID; --1001247; -- IEXTEST

13248: Close C_Get_CONTENTS;
13249: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - TotalContents='||nIdx);
13250: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - CurrUser='||FND_GLOBAL.USER_ID);
13251: l_content_nm := nIdx; -- Num of Contents you want send out NOCOPY
13252: l_user_id := FND_GLOBAL.USER_ID; --1001247; -- IEXTEST
13253: l_server_id := NULL; -- Using Default Server
13254: l_subject := NVL(FND_PROFILE.value('IEX_FULFILL_SUBJECT'), '');
13255:
13256: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - subject=;||l_subject');

Line 13846: l_user_id := FND_GLOBAL.USER_ID; --1001247; -- IEXTEST

13842: Close C_Get_CONTENTS;
13843:
13844: l_content_nm := nIdx; -- Num of Contents you want send out NOCOPY
13845: if (p_user_id is null) then
13846: l_user_id := FND_GLOBAL.USER_ID; --1001247; -- IEXTEST
13847: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - p_user_id is null');
13848: else
13849: l_user_id := p_user_id;
13850: end if;

Line 14306: l_user_id := FND_GLOBAL.USER_ID;

14302: GOTO end_call_ffm;
14303: end if;
14304:
14305: if (p_user_id is null) then
14306: l_user_id := FND_GLOBAL.USER_ID;
14307: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - p_user_id is null');
14308: else
14309: l_user_id := p_user_id;
14310: end if;

Line 14375: l_dunning_rec.request_id := FND_GLOBAL.Conc_Request_Id;

14371:
14372: if p_parent_request_id is not null then
14373: l_dunning_rec.request_id := p_parent_request_id;
14374: else
14375: l_dunning_rec.request_id := FND_GLOBAL.Conc_Request_Id;
14376: end if;
14377:
14378: l_dunning_rec.dunning_mode := p_dunning_mode;
14379: l_dunning_rec.correspondence_date := p_correspondence_date;

Line 14424: , p_created_by => FND_GLOBAL.USER_ID

14420: , p_cust_trx_id => l_transaction_id
14421: , p_payment_schedule_id => l_payment_schedule_id
14422: , p_ag_dn_xref_id => null
14423: , p_stage_number => null
14424: , p_created_by => FND_GLOBAL.USER_ID
14425: , p_creation_date => sysdate
14426: , p_last_updated_by => FND_GLOBAL.USER_ID
14427: , p_last_update_date => sysdate
14428: , p_last_update_login => FND_GLOBAL.USER_ID

Line 14426: , p_last_updated_by => FND_GLOBAL.USER_ID

14422: , p_ag_dn_xref_id => null
14423: , p_stage_number => null
14424: , p_created_by => FND_GLOBAL.USER_ID
14425: , p_creation_date => sysdate
14426: , p_last_updated_by => FND_GLOBAL.USER_ID
14427: , p_last_update_date => sysdate
14428: , p_last_update_login => FND_GLOBAL.USER_ID
14429: , p_object_version_number => 1.0
14430: );

Line 14428: , p_last_update_login => FND_GLOBAL.USER_ID

14424: , p_created_by => FND_GLOBAL.USER_ID
14425: , p_creation_date => sysdate
14426: , p_last_updated_by => FND_GLOBAL.USER_ID
14427: , p_last_update_date => sysdate
14428: , p_last_update_login => FND_GLOBAL.USER_ID
14429: , p_object_version_number => 1.0
14430: );
14431: if x_dunning_trx_id is null then
14432: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Cannot insert record in to iex_dunning_transactions table');

Line 14755: l_dunning_rec.request_id := FND_GLOBAL.Conc_Request_Id;

14751:
14752: if p_parent_request_id is not null then
14753: l_dunning_rec.request_id := p_parent_request_id;
14754: else
14755: l_dunning_rec.request_id := FND_GLOBAL.Conc_Request_Id;
14756: end if;
14757:
14758: l_dunning_rec.dunning_mode := p_dunning_mode;
14759: l_dunning_rec.correspondence_date := p_correspondence_date;

Line 14804: , p_created_by => FND_GLOBAL.USER_ID

14800: , p_cust_trx_id => l_transaction_id
14801: , p_payment_schedule_id => l_payment_schedule_id
14802: , p_ag_dn_xref_id => null
14803: , p_stage_number => null
14804: , p_created_by => FND_GLOBAL.USER_ID
14805: , p_creation_date => sysdate
14806: , p_last_updated_by => FND_GLOBAL.USER_ID
14807: , p_last_update_date => sysdate
14808: , p_last_update_login => FND_GLOBAL.USER_ID

Line 14806: , p_last_updated_by => FND_GLOBAL.USER_ID

14802: , p_ag_dn_xref_id => null
14803: , p_stage_number => null
14804: , p_created_by => FND_GLOBAL.USER_ID
14805: , p_creation_date => sysdate
14806: , p_last_updated_by => FND_GLOBAL.USER_ID
14807: , p_last_update_date => sysdate
14808: , p_last_update_login => FND_GLOBAL.USER_ID
14809: , p_object_version_number => 1.0
14810: );

Line 14808: , p_last_update_login => FND_GLOBAL.USER_ID

14804: , p_created_by => FND_GLOBAL.USER_ID
14805: , p_creation_date => sysdate
14806: , p_last_updated_by => FND_GLOBAL.USER_ID
14807: , p_last_update_date => sysdate
14808: , p_last_update_login => FND_GLOBAL.USER_ID
14809: , p_object_version_number => 1.0
14810: );
14811: if x_dunning_trx_id is null then
14812: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Cannot insert record in to iex_dunning_transactions table');

Line 14994: l_dunning_rec.request_id := FND_GLOBAL.Conc_Request_Id;

14990:
14991: if p_parent_request_id is not null then
14992: l_dunning_rec.request_id := p_parent_request_id;
14993: else
14994: l_dunning_rec.request_id := FND_GLOBAL.Conc_Request_Id;
14995: end if;
14996:
14997: l_dunning_rec.dunning_mode := p_dunning_mode;
14998: l_dunning_rec.correspondence_date := p_correspondence_date;

Line 15046: l_dunning_rec.request_id := FND_GLOBAL.Conc_Request_Id;

15042:
15043: if p_parent_request_id is not null then
15044: l_dunning_rec.request_id := p_parent_request_id;
15045: else
15046: l_dunning_rec.request_id := FND_GLOBAL.Conc_Request_Id;
15047: end if;
15048:
15049: l_dunning_rec.dunning_mode := p_dunning_mode;
15050: l_dunning_rec.correspondence_date := p_correspondence_date;

Line 15261: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - userid= '||FND_GLOBAL.USER_ID);

15257: * if not found, get org email address;
15258: =======================================*/
15259: if instr( p_method, 'PRINT' ) > 0 then
15260: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Get Printer');
15261: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - userid= '||FND_GLOBAL.USER_ID);
15262: l_printer := NVL(fnd_profile.value('IEX_FFM_PRINTER'), '');
15263: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Printer:'||l_printer);
15264: if (l_printer = '' or l_printer is null) then
15265: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - No Printer');

Line 17392: l_login := fnd_global.login_id;

17388: BEGIN
17389:
17390: /*l_api_name := 'Get_Resource';
17391: l_default_rs_id := fnd_profile.value('IEX_STRY_DEFAULT_RESOURCE');
17392: l_login := fnd_global.login_id;
17393: l_user := FND_GLOBAL.USER_ID;
17394:
17395: -- IF PG_DEBUG < 10 THEN
17396: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 17393: l_user := FND_GLOBAL.USER_ID;

17389:
17390: /*l_api_name := 'Get_Resource';
17391: l_default_rs_id := fnd_profile.value('IEX_STRY_DEFAULT_RESOURCE');
17392: l_login := fnd_global.login_id;
17393: l_user := FND_GLOBAL.USER_ID;
17394:
17395: -- IF PG_DEBUG < 10 THEN
17396: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
17397: iex_debug_pub.LogMessage ('Get_Resource: ' || 'iexvdunb.pls:GetRS:starting');

Line 18575: , p_created_by => FND_GLOBAL.USER_ID

18571: , p_cust_trx_id => l_transaction_id
18572: , p_payment_schedule_id => l_payment_schedule_id
18573: , p_ag_dn_xref_id => p_ag_dn_xref_id
18574: , p_stage_number => -1
18575: , p_created_by => FND_GLOBAL.USER_ID
18576: , p_creation_date => sysdate
18577: , p_last_updated_by => FND_GLOBAL.USER_ID
18578: , p_last_update_date => sysdate
18579: , p_last_update_login => FND_GLOBAL.USER_ID

Line 18577: , p_last_updated_by => FND_GLOBAL.USER_ID

18573: , p_ag_dn_xref_id => p_ag_dn_xref_id
18574: , p_stage_number => -1
18575: , p_created_by => FND_GLOBAL.USER_ID
18576: , p_creation_date => sysdate
18577: , p_last_updated_by => FND_GLOBAL.USER_ID
18578: , p_last_update_date => sysdate
18579: , p_last_update_login => FND_GLOBAL.USER_ID
18580: , p_object_version_number => 1.0);
18581:

Line 18579: , p_last_update_login => FND_GLOBAL.USER_ID

18575: , p_created_by => FND_GLOBAL.USER_ID
18576: , p_creation_date => sysdate
18577: , p_last_updated_by => FND_GLOBAL.USER_ID
18578: , p_last_update_date => sysdate
18579: , p_last_update_login => FND_GLOBAL.USER_ID
18580: , p_object_version_number => 1.0);
18581:
18582: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - x_dunning_trx_id :'|| x_dunning_trx_id);
18583:

Line 18666: , p_created_by => FND_GLOBAL.USER_ID

18662: , p_cust_trx_id => l_transaction_id
18663: , p_payment_schedule_id => l_payment_schedule_id
18664: , p_ag_dn_xref_id => p_ag_dn_xref_id
18665: , p_stage_number => 0
18666: , p_created_by => FND_GLOBAL.USER_ID
18667: , p_creation_date => sysdate
18668: , p_last_updated_by => FND_GLOBAL.USER_ID
18669: , p_last_update_date => sysdate
18670: , p_last_update_login => FND_GLOBAL.USER_ID

Line 18668: , p_last_updated_by => FND_GLOBAL.USER_ID

18664: , p_ag_dn_xref_id => p_ag_dn_xref_id
18665: , p_stage_number => 0
18666: , p_created_by => FND_GLOBAL.USER_ID
18667: , p_creation_date => sysdate
18668: , p_last_updated_by => FND_GLOBAL.USER_ID
18669: , p_last_update_date => sysdate
18670: , p_last_update_login => FND_GLOBAL.USER_ID
18671: , p_object_version_number => 1.0
18672: );

Line 18670: , p_last_update_login => FND_GLOBAL.USER_ID

18666: , p_created_by => FND_GLOBAL.USER_ID
18667: , p_creation_date => sysdate
18668: , p_last_updated_by => FND_GLOBAL.USER_ID
18669: , p_last_update_date => sysdate
18670: , p_last_update_login => FND_GLOBAL.USER_ID
18671: , p_object_version_number => 1.0
18672: );
18673:
18674: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - x_dunning_trx_id :'|| x_dunning_trx_id);

Line 18740: , p_created_by => FND_GLOBAL.USER_ID

18736: , p_cust_trx_id => l_transaction_id
18737: , p_payment_schedule_id => l_payment_schedule_id
18738: , p_ag_dn_xref_id => p_ag_dn_xref_id
18739: , p_stage_number => -1 --changed by schekuri bug#15932721
18740: , p_created_by => FND_GLOBAL.USER_ID
18741: , p_creation_date => sysdate
18742: , p_last_updated_by => FND_GLOBAL.USER_ID
18743: , p_last_update_date => sysdate
18744: , p_last_update_login => FND_GLOBAL.USER_ID

Line 18742: , p_last_updated_by => FND_GLOBAL.USER_ID

18738: , p_ag_dn_xref_id => p_ag_dn_xref_id
18739: , p_stage_number => -1 --changed by schekuri bug#15932721
18740: , p_created_by => FND_GLOBAL.USER_ID
18741: , p_creation_date => sysdate
18742: , p_last_updated_by => FND_GLOBAL.USER_ID
18743: , p_last_update_date => sysdate
18744: , p_last_update_login => FND_GLOBAL.USER_ID
18745: , p_object_version_number => 1.0
18746: );

Line 18744: , p_last_update_login => FND_GLOBAL.USER_ID

18740: , p_created_by => FND_GLOBAL.USER_ID
18741: , p_creation_date => sysdate
18742: , p_last_updated_by => FND_GLOBAL.USER_ID
18743: , p_last_update_date => sysdate
18744: , p_last_update_login => FND_GLOBAL.USER_ID
18745: , p_object_version_number => 1.0
18746: );
18747:
18748: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - x_dunning_trx_id :'|| x_dunning_trx_id);

Line 18840: , p_created_by => FND_GLOBAL.USER_ID

18836: , p_cust_trx_id => l_customer_trx_id
18837: , p_payment_schedule_id => l_payment_schedule_id
18838: , p_ag_dn_xref_id => p_ag_dn_xref_id
18839: , p_stage_number => 0
18840: , p_created_by => FND_GLOBAL.USER_ID
18841: , p_creation_date => sysdate
18842: , p_last_updated_by => FND_GLOBAL.USER_ID
18843: , p_last_update_date => sysdate
18844: , p_last_update_login => FND_GLOBAL.USER_ID

Line 18842: , p_last_updated_by => FND_GLOBAL.USER_ID

18838: , p_ag_dn_xref_id => p_ag_dn_xref_id
18839: , p_stage_number => 0
18840: , p_created_by => FND_GLOBAL.USER_ID
18841: , p_creation_date => sysdate
18842: , p_last_updated_by => FND_GLOBAL.USER_ID
18843: , p_last_update_date => sysdate
18844: , p_last_update_login => FND_GLOBAL.USER_ID
18845: , p_object_version_number => 1.0
18846: );

Line 18844: , p_last_update_login => FND_GLOBAL.USER_ID

18840: , p_created_by => FND_GLOBAL.USER_ID
18841: , p_creation_date => sysdate
18842: , p_last_updated_by => FND_GLOBAL.USER_ID
18843: , p_last_update_date => sysdate
18844: , p_last_update_login => FND_GLOBAL.USER_ID
18845: , p_object_version_number => 1.0
18846: );
18847:
18848: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - x_dunning_trx_id :'|| x_dunning_trx_id);

Line 18920: , p_created_by => FND_GLOBAL.USER_ID

18916: --, p_cust_trx_id => l_customer_trx_id
18917: , p_payment_schedule_id => l_payment_schedule_id
18918: , p_ag_dn_xref_id => p_ag_dn_xref_id
18919: , p_stage_number => null
18920: , p_created_by => FND_GLOBAL.USER_ID
18921: , p_creation_date => sysdate
18922: , p_last_updated_by => FND_GLOBAL.USER_ID
18923: , p_last_update_date => sysdate
18924: , p_last_update_login => FND_GLOBAL.USER_ID

Line 18922: , p_last_updated_by => FND_GLOBAL.USER_ID

18918: , p_ag_dn_xref_id => p_ag_dn_xref_id
18919: , p_stage_number => null
18920: , p_created_by => FND_GLOBAL.USER_ID
18921: , p_creation_date => sysdate
18922: , p_last_updated_by => FND_GLOBAL.USER_ID
18923: , p_last_update_date => sysdate
18924: , p_last_update_login => FND_GLOBAL.USER_ID
18925: , p_object_version_number => 1.0
18926: );

Line 18924: , p_last_update_login => FND_GLOBAL.USER_ID

18920: , p_created_by => FND_GLOBAL.USER_ID
18921: , p_creation_date => sysdate
18922: , p_last_updated_by => FND_GLOBAL.USER_ID
18923: , p_last_update_date => sysdate
18924: , p_last_update_login => FND_GLOBAL.USER_ID
18925: , p_object_version_number => 1.0
18926: );
18927:
18928: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - x_dunning_trx_id :'|| x_dunning_trx_id);

Line 18992: , p_created_by => FND_GLOBAL.USER_ID

18988: , p_cust_trx_id => l_customer_trx_id
18989: , p_payment_schedule_id => l_payment_schedule_id
18990: , p_ag_dn_xref_id => p_ag_dn_xref_id
18991: , p_stage_number => null
18992: , p_created_by => FND_GLOBAL.USER_ID
18993: , p_creation_date => sysdate
18994: , p_last_updated_by => FND_GLOBAL.USER_ID
18995: , p_last_update_date => sysdate
18996: , p_last_update_login => FND_GLOBAL.USER_ID

Line 18994: , p_last_updated_by => FND_GLOBAL.USER_ID

18990: , p_ag_dn_xref_id => p_ag_dn_xref_id
18991: , p_stage_number => null
18992: , p_created_by => FND_GLOBAL.USER_ID
18993: , p_creation_date => sysdate
18994: , p_last_updated_by => FND_GLOBAL.USER_ID
18995: , p_last_update_date => sysdate
18996: , p_last_update_login => FND_GLOBAL.USER_ID
18997: , p_object_version_number => 1.0
18998: );

Line 18996: , p_last_update_login => FND_GLOBAL.USER_ID

18992: , p_created_by => FND_GLOBAL.USER_ID
18993: , p_creation_date => sysdate
18994: , p_last_updated_by => FND_GLOBAL.USER_ID
18995: , p_last_update_date => sysdate
18996: , p_last_update_login => FND_GLOBAL.USER_ID
18997: , p_object_version_number => 1.0
18998: );
18999:
19000: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - x_dunning_trx_id :'|| x_dunning_trx_id);