DBA Data[Home] [Help]

APPS.OZF_BUDGETAPPROVAL_PVT dependencies on FND_GLOBAL

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

3374: --kdass fix for bug 4621638
3375: l_final_data := Substr((l_final_data || l_msg_index || ': ' || l_msg_data || Fnd_Global.local_chr(10)),1,1500);
3376: /*
3377: l_final_data := l_final_data ||l_msg_index||': '
3378: ||l_msg_data||Fnd_Global.local_chr(10) ;
3379: */
3380: l_cnt := l_cnt + 1 ;
3381: END LOOP ;
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_msg_data||Fnd_Global.local_chr(10) ;
3379: */
3380: l_cnt := l_cnt + 1 ;
3381: END LOOP ;
3382: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;
3383: l_strBody := l_strBody || Substr(l_final_data,1,1500) ;
3384:
3385: fnd_message.set_name('OZF', 'OZF_NOTIFY_FOOTER');
3386: l_strBody := l_strBody || fnd_global.local_chr(10) || fnd_global.local_chr(10) ||fnd_message.get ;

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

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

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

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

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

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