DBA Data[Home] [Help]

APPS.OZF_BUDGETAPPROVAL_PVT dependencies on FND_GLOBAL

Line 458: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);

454: fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);
455: l_strSubject := Substr(fnd_message.get,1,200);
456:
457: fnd_message.set_name('OZF', 'OZF_NOTIFY_HEADERLINE');
458: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
459: fnd_message.set_name ('OZF', 'OZF_VENDOR_MESSAGE');
460: fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);
461: fnd_message.set_token ('CAMP_NUMBER', l_source_code, FALSE);
462: fnd_message.set_token ('CAMP_NAME', l_campaign_name, FALSE);

Line 471: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;

467: fnd_message.set_token ('APPROVED_AMT', l_approved_amt, FALSE);
468: l_strBody := l_strBody || Substr(fnd_message.get,1,1000);
469:
470: fnd_message.set_name('OZF', 'OZF_NOTIFY_FOOTER');
471: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;
472:
473: ozf_utility_pvt.send_wf_standalone_message(
474: p_subject => l_strSubject
475: ,p_body => l_strBody

Line 2873: --l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);

2869: --fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);
2870: l_strSubject := Substr(fnd_message.get,1,200);
2871:
2872: fnd_message.set_name('OZF', 'OZF_NOTIFY_HEADERLINE');
2873: --l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
2874: fnd_message.set_name ('OZF', 'OZF_VENDOR_MESSAGE');
2875: --fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);
2876: l_strBody := l_strBody || Substr(fnd_message.get,1,1000);
2877:

Line 2879: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;

2875: --fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);
2876: l_strBody := l_strBody || Substr(fnd_message.get,1,1000);
2877:
2878: fnd_message.set_name('OZF', 'OZF_NOTIFY_FOOTER');
2879: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;
2880:
2881: ozf_utility_pvt.send_wf_standalone_message(
2882: p_subject => l_strSubject
2883: ,p_body => l_strBody

Line 3047: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);

3043: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
3044: l_strSubject := Substr(fnd_message.get,1,200);
3045:
3046: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');
3047: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
3048: fnd_message.set_name ('OZF', 'OZF_OFFER_VALIDATION_MESSAGE');
3049: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
3050: fnd_message.set_token ('FUND_NAME', l_budget_name, FALSE);
3051: fnd_message.set_token ('REQUEST_ID', p_actbudget_id, FALSE);

Line 3063: l_final_data := Substr((l_final_data || l_msg_index || ': ' || l_msg_data || Fnd_Global.local_chr(10)),1,1500);

3059: p_data => l_msg_data,
3060: p_msg_index_out => l_msg_index );
3061:
3062: --kdass fix for bug 4621638
3063: l_final_data := Substr((l_final_data || l_msg_index || ': ' || l_msg_data || Fnd_Global.local_chr(10)),1,1500);
3064: /*
3065: l_final_data := l_final_data ||l_msg_index||': '
3066: ||l_msg_data||Fnd_Global.local_chr(10) ;
3067: l_final_data := Substr(l_final_data,1,1500); -- fix bug 4032040

Line 3066: ||l_msg_data||Fnd_Global.local_chr(10) ;

3062: --kdass fix for bug 4621638
3063: l_final_data := Substr((l_final_data || l_msg_index || ': ' || l_msg_data || Fnd_Global.local_chr(10)),1,1500);
3064: /*
3065: l_final_data := l_final_data ||l_msg_index||': '
3066: ||l_msg_data||Fnd_Global.local_chr(10) ;
3067: l_final_data := Substr(l_final_data,1,1500); -- fix bug 4032040
3068: */
3069: l_cnt := l_cnt + 1 ;
3070: END LOOP ;

Line 3072: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;

3068: */
3069: l_cnt := l_cnt + 1 ;
3070: END LOOP ;
3071:
3072: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;
3073: l_strBody := l_strBody || Substr(l_final_data,1,1500) ;
3074:
3075: fnd_message.set_name('OZF', 'OZF_NOTIFY_FOOTER');
3076: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;

Line 3076: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;

3072: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;
3073: l_strBody := l_strBody || Substr(l_final_data,1,1500) ;
3074:
3075: fnd_message.set_name('OZF', 'OZF_NOTIFY_FOOTER');
3076: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;
3077:
3078: ozf_utility_pvt.send_wf_standalone_message( p_subject => l_strSubject
3079: ,p_body => l_strBody
3080: ,p_send_to_res_id => l_owner_id

Line 3156: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);

3152: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
3153: l_strSubject := Substr(fnd_message.get,1,200);
3154:
3155: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');
3156: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
3157: fnd_message.set_name ('OZF', 'OZF_OFFER_VALIDATION_MESSAGE');
3158: fnd_message.set_token ('OFFER_NAME', l_offer_name, FALSE);
3159: fnd_message.set_token ('FUND_NAME', l_budget_name, FALSE);
3160: fnd_message.set_token ('REQUEST_ID', request_rec.activity_budget_id, FALSE);

Line 3172: l_final_data := Substr((l_final_data || l_msg_index || ': ' || l_msg_data || Fnd_Global.local_chr(10)),1,1500);

3168: p_data => l_msg_data,
3169: p_msg_index_out => l_msg_index );
3170:
3171: --kdass fix for bug 4621638
3172: l_final_data := Substr((l_final_data || l_msg_index || ': ' || l_msg_data || Fnd_Global.local_chr(10)),1,1500);
3173: /*
3174: l_final_data := l_final_data ||l_msg_index||': '
3175: ||l_msg_data||Fnd_Global.local_chr(10) ;
3176: l_final_data := Substr(l_final_data,1,1500); -- fix bug 4032040

Line 3175: ||l_msg_data||Fnd_Global.local_chr(10) ;

3171: --kdass fix for bug 4621638
3172: l_final_data := Substr((l_final_data || l_msg_index || ': ' || l_msg_data || Fnd_Global.local_chr(10)),1,1500);
3173: /*
3174: l_final_data := l_final_data ||l_msg_index||': '
3175: ||l_msg_data||Fnd_Global.local_chr(10) ;
3176: l_final_data := Substr(l_final_data,1,1500); -- fix bug 4032040
3177: */
3178: l_cnt := l_cnt + 1 ;
3179: END LOOP ;

Line 3181: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;

3177: */
3178: l_cnt := l_cnt + 1 ;
3179: END LOOP ;
3180:
3181: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;
3182: l_strBody := l_strBody || Substr(l_final_data,1,1500) ;
3183:
3184: fnd_message.set_name('OZF', 'OZF_NOTIFY_FOOTER');
3185: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;

Line 3185: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;

3181: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;
3182: l_strBody := l_strBody || Substr(l_final_data,1,1500) ;
3183:
3184: fnd_message.set_name('OZF', 'OZF_NOTIFY_FOOTER');
3185: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;
3186:
3187: ozf_utility_pvt.send_wf_standalone_message( p_subject => l_strSubject
3188: ,p_body => l_strBody
3189: ,p_send_to_res_id => request_rec.requester_id

Line 3344: l_final_data := Substr((l_final_data || l_msg_index || ': ' || l_msg_data || Fnd_Global.local_chr(10)),1,1500);

3340: p_data => l_msg_data,
3341: p_msg_index_out => l_msg_index );
3342:
3343: --kdass fix for bug 4621638
3344: l_final_data := Substr((l_final_data || l_msg_index || ': ' || l_msg_data || Fnd_Global.local_chr(10)),1,1500);
3345: /*
3346: l_final_data := l_final_data ||l_msg_index||': '
3347: ||l_msg_data||Fnd_Global.local_chr(10) ;
3348: */

Line 3347: ||l_msg_data||Fnd_Global.local_chr(10) ;

3343: --kdass fix for bug 4621638
3344: l_final_data := Substr((l_final_data || l_msg_index || ': ' || l_msg_data || Fnd_Global.local_chr(10)),1,1500);
3345: /*
3346: l_final_data := l_final_data ||l_msg_index||': '
3347: ||l_msg_data||Fnd_Global.local_chr(10) ;
3348: */
3349: l_cnt := l_cnt + 1 ;
3350: END LOOP ;
3351:

Line 3357: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);

3353: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
3354: l_strSubject := Substr(fnd_message.get,1,200);
3355:
3356: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');
3357: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
3358: fnd_message.set_name ('OZF', 'OZF_TM_CONCURR_MESSAGE');
3359: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
3360: l_strBody := l_strBody || Substr(fnd_message.get,1,200);
3361:

Line 3371: l_final_data := Substr((l_final_data || l_msg_index || ': ' || l_msg_data || Fnd_Global.local_chr(10)),1,1500);

3367: p_data => l_msg_data,
3368: p_msg_index_out => l_msg_index );
3369:
3370: --kdass fix for bug 4621638
3371: l_final_data := Substr((l_final_data || l_msg_index || ': ' || l_msg_data || Fnd_Global.local_chr(10)),1,1500);
3372: /*
3373: l_final_data := l_final_data ||l_msg_index||': '
3374: ||l_msg_data||Fnd_Global.local_chr(10) ;
3375: */

Line 3374: ||l_msg_data||Fnd_Global.local_chr(10) ;

3370: --kdass fix for bug 4621638
3371: l_final_data := Substr((l_final_data || l_msg_index || ': ' || l_msg_data || Fnd_Global.local_chr(10)),1,1500);
3372: /*
3373: l_final_data := l_final_data ||l_msg_index||': '
3374: ||l_msg_data||Fnd_Global.local_chr(10) ;
3375: */
3376: l_cnt := l_cnt + 1 ;
3377: END LOOP ;
3378: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;

Line 3378: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;

3374: ||l_msg_data||Fnd_Global.local_chr(10) ;
3375: */
3376: l_cnt := l_cnt + 1 ;
3377: END LOOP ;
3378: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;
3379: l_strBody := l_strBody || Substr(l_final_data,1,1500) ;
3380:
3381: fnd_message.set_name('OZF', 'OZF_NOTIFY_FOOTER');
3382: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;

Line 3382: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;

3378: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;
3379: l_strBody := l_strBody || Substr(l_final_data,1,1500) ;
3380:
3381: fnd_message.set_name('OZF', 'OZF_NOTIFY_FOOTER');
3382: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;
3383:
3384: ozf_utility_pvt.send_wf_standalone_message( p_subject => l_strSubject
3385: ,p_body => l_strBody
3386: ,p_send_to_res_id => l_owner_id

Line 3569: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);

3565: fnd_message.set_token ('OFFER_CODE', l_offer_code, FALSE);
3566: l_strSubject := Substr(fnd_message.get,1,200);
3567:
3568: fnd_message.set_name('OZF', 'OZF_TM_NOTIFY_HEADERLINE');
3569: l_strBody := fnd_message.get ||fnd_global.local_chr(10)||fnd_global.local_chr(10);
3570: fnd_message.set_name ('OZF', 'OZF_OFF_REQ_NOT_ENOUGH');
3571: l_strBody := l_strBody || Substr(fnd_message.get,1,200);
3572:
3573: fnd_message.set_name('OZF', 'OZF_NOTIFY_FOOTER');

Line 3574: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;

3570: fnd_message.set_name ('OZF', 'OZF_OFF_REQ_NOT_ENOUGH');
3571: l_strBody := l_strBody || Substr(fnd_message.get,1,200);
3572:
3573: fnd_message.set_name('OZF', 'OZF_NOTIFY_FOOTER');
3574: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;
3575:
3576: ozf_utility_pvt.send_wf_standalone_message(
3577: p_subject => l_strSubject
3578: ,p_body => l_strBody