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.OZF_BUDGETAPPROVAL_PVT dependencies on OZF_UTILITY_PVT

Line 226: l_act_budget_rec.user_status_id := ozf_utility_pvt.get_default_user_status(g_status_type, l_act_budget_rec.status_code);

222: -- on WF to generate a notification.
223: OZF_ActBudgets_PVT.Init_Act_Budgets_Rec (l_act_budget_rec);
224: l_act_budget_rec.activity_budget_id := p_activity_budget_id;
225: l_act_budget_rec.status_code := 'NEW';
226: l_act_budget_rec.user_status_id := ozf_utility_pvt.get_default_user_status(g_status_type, l_act_budget_rec.status_code);
227: -- 11/12/2001 mpande added the following
228: l_act_budget_rec.comment := p_comment ;
229: OZF_ActBudgets_PVT.Update_Act_Budgets (
230: p_api_version => 1.0,

Line 279: l_act_budgets_rec.user_status_id := ozf_utility_pvt.get_default_user_status(g_status_type, l_act_budgets_rec.status_code);

275: OZF_ActBudgets_PVT.Init_Act_Budgets_Rec (l_act_budgets_rec);
276: l_act_budgets_rec.activity_budget_id := p_activity_budget_id;
277: l_act_budgets_rec.status_code := 'APPROVED';
278: --05/17/2001 mpande
279: l_act_budgets_rec.user_status_id := ozf_utility_pvt.get_default_user_status(g_status_type, l_act_budgets_rec.status_code);
280: l_act_budgets_rec.approver_id := p_approver_id;
281: l_act_budgets_rec.approved_in_currency := p_approved_currency;
282: l_act_budgets_rec.approved_original_amount := p_approved_amount;
283: -- 11/12/2001 mpande added the following

Line 351: l_act_budgets_rec.user_status_id := ozf_utility_pvt.get_default_user_status(g_status_type, l_act_budgets_rec.status_code);

347: l_act_budgets_rec.activity_budget_id := p_activity_budget_id;
348: l_act_budgets_rec.approver_id := p_approver_id;
349: l_act_budgets_rec.status_code := 'REJECTED';
350: --05/17/2001 mpande
351: l_act_budgets_rec.user_status_id := ozf_utility_pvt.get_default_user_status(g_status_type, l_act_budgets_rec.status_code);
352: -- 11/12/2001 mpande added the following
353: l_act_budgets_rec.comment := p_comment ;
354: OZF_ActBudgets_PVT.Update_Act_Budgets (
355: p_api_version => 1.0,

Line 477: ozf_utility_pvt.send_wf_standalone_message(

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
480: ,p_send_to_res_id => l_camp_owner_id
481: ,x_notif_id => l_notification_id

Line 1339: ozf_utility_pvt.write_conc_log('Number of products in offer: ' || l_count_offer_prod);

1335: OPEN c_count_offer_prod;
1336: FETCH c_count_offer_prod INTO l_count_offer_prod;
1337: CLOSE c_count_offer_prod;
1338:
1339: ozf_utility_pvt.write_conc_log('Number of products in offer: ' || l_count_offer_prod);
1340:
1341: IF l_count_offer_prod = 0 THEN
1342: FND_MESSAGE.Set_Name ('OZF', 'OZF_OFFER_NO_PROD');
1343: FND_MSG_PUB.Add;

Line 2301: ozf_utility_pvt.debug_message(' profile value:' || l_check_validation);

2297:
2298: l_check_validation := fnd_profile.value('OZF_CHECK_MKTG_PROD_ELIG');
2299:
2300: IF G_DEBUG THEN
2301: ozf_utility_pvt.debug_message(' profile value:' || l_check_validation);
2302: END IF;
2303:
2304: IF (NVL(l_check_validation, 'NO') = 'NO') THEN
2305: -- return success if profile value is NO

Line 2349: ozf_utility_pvt.debug_message(' validate_product_by_each_line returns ' || l_return_status || ' valid_flag=' || l_valid_flag);

2345: x_return_status => l_return_status,
2346: x_valid_flag => l_valid_flag
2347: );
2348: IF G_DEBUG THEN
2349: ozf_utility_pvt.debug_message(' validate_product_by_each_line returns ' || l_return_status || ' valid_flag=' || l_valid_flag);
2350: END IF;
2351: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
2352: x_return_status := l_return_status;
2353: RAISE fnd_api.G_EXC_ERROR;

Line 2361: ozf_utility_pvt.debug_message('FAILURE: budget product eligibility does not match that of offer');

2357: FND_MESSAGE.Set_Name ('OZF', 'OZF_PRODUCT_ELIG_MISMATCH');
2358: FND_MSG_PUB.Add;
2359: END IF;
2360: IF G_DEBUG THEN
2361: ozf_utility_pvt.debug_message('FAILURE: budget product eligibility does not match that of offer');
2362: END IF;
2363: RAISE fnd_api.G_EXC_ERROR;
2364: END IF;
2365: END IF;

Line 2376: ozf_utility_pvt.debug_message(' validate_market_by_each_line returns ' || l_return_status);

2372: x_return_status => l_return_status,
2373: x_valid_flag => l_valid_flag
2374: );
2375: IF G_DEBUG THEN
2376: ozf_utility_pvt.debug_message(' validate_market_by_each_line returns ' || l_return_status);
2377: END IF;
2378: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
2379: x_return_status := l_return_status;
2380: RAISE fnd_api.G_EXC_ERROR;

Line 2388: ozf_utility_pvt.debug_message('FAILURE: budget market eligibility does not match that of offer');

2384: FND_MESSAGE.Set_Name ('OZF', 'OZF_MARKET_ELIG_MISMATCH');
2385: FND_MSG_PUB.Add;
2386: END IF;
2387: IF G_DEBUG THEN
2388: ozf_utility_pvt.debug_message('FAILURE: budget market eligibility does not match that of offer');
2389: END IF;
2390: RAISE fnd_api.G_EXC_ERROR;
2391: END IF;
2392: IF G_DEBUG THEN

Line 2393: ozf_utility_pvt.debug_message(' SUCCESS ');

2389: END IF;
2390: RAISE fnd_api.G_EXC_ERROR;
2391: END IF;
2392: IF G_DEBUG THEN
2393: ozf_utility_pvt.debug_message(' SUCCESS ');
2394: END IF;
2395:
2396: EXCEPTION
2397: WHEN fnd_api.g_exc_error THEN

Line 2482: ozf_utility_pvt.debug_message(' validate_market_by_all_lines returns ' || l_return_status);

2478: x_return_status => l_return_status,
2479: x_valid_flag => l_valid_flag
2480: );
2481: IF G_DEBUG THEN
2482: ozf_utility_pvt.debug_message(' validate_market_by_all_lines returns ' || l_return_status);
2483: END IF;
2484: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
2485: x_return_status := l_return_status;
2486: -- revert all the approved budget lines

Line 2500: ozf_utility_pvt.debug_message('FAILURE: all budgets market eligibility does not match that of offer');

2496: FND_MESSAGE.Set_Name ('OZF', 'OZF_MARKET_ELIG_MISMATCH');
2497: FND_MSG_PUB.Add;
2498: END IF;
2499: IF G_DEBUG THEN
2500: ozf_utility_pvt.debug_message('FAILURE: all budgets market eligibility does not match that of offer');
2501: END IF;
2502: -- revert all the approved budget lines
2503: revert_approved_request ( p_offer_id => p_object_id
2504: ,x_return_status => l_return_status

Line 2522: ozf_utility_pvt.debug_message(' validate_product_by_all_lines returns ' || l_return_status || ' valid_flag=' || l_valid_flag);

2518: x_return_status => l_return_status,
2519: x_valid_flag => l_valid_flag
2520: );
2521: IF G_DEBUG THEN
2522: ozf_utility_pvt.debug_message(' validate_product_by_all_lines returns ' || l_return_status || ' valid_flag=' || l_valid_flag);
2523: END IF;
2524: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
2525: x_return_status := l_return_status;
2526: -- revert all the approved budget lines

Line 2539: ozf_utility_pvt.debug_message('FAILURE: all budgets product eligibility does not match that of offer');

2535: FND_MESSAGE.Set_Name ('OZF', 'OZF_PRODUCT_ELIG_MISMATCH');
2536: FND_MSG_PUB.Add;
2537: END IF;
2538: IF G_DEBUG THEN
2539: ozf_utility_pvt.debug_message('FAILURE: all budgets product eligibility does not match that of offer');
2540: END IF;
2541: -- revert all the approved budget lines
2542: revert_approved_request ( p_offer_id => p_object_id
2543: ,x_return_status => l_return_status

Line 2554: ozf_utility_pvt.debug_message(' SUCCESS ');

2550: END IF;
2551:
2552:
2553: IF G_DEBUG THEN
2554: ozf_utility_pvt.debug_message(' SUCCESS ');
2555: END IF;
2556:
2557: EXCEPTION
2558: WHEN fnd_api.g_exc_error THEN

Line 2885: ozf_utility_pvt.send_wf_standalone_message(

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
2888: ,p_send_to_res_id => l_owner_id
2889: ,x_notif_id => l_notification_id

Line 2994: ozf_utility_pvt.Write_Conc_log('offer_type = ' || l_modifier_list_rec.offer_type);

2990: FETCH c_offer_info INTO l_modifier_list_rec.offer_type,l_modifier_list_rec.custom_setup_id,
2991: l_modifier_list_rec.reusable,l_modifier_list_rec.offer_amount,l_offer_code,l_owner_id, l_offer_name;
2992: CLOSE c_offer_info;
2993:
2994: ozf_utility_pvt.Write_Conc_log('offer_type = ' || l_modifier_list_rec.offer_type);
2995: ozf_utility_pvt.Write_Conc_log('custom_setup_id = ' || l_modifier_list_rec.custom_setup_id);
2996: ozf_utility_pvt.Write_Conc_log('reusable = ' || l_modifier_list_rec.reusable);
2997: ozf_utility_pvt.Write_Conc_log('offer_amount = ' || l_modifier_list_rec.offer_amount);
2998:

Line 2995: ozf_utility_pvt.Write_Conc_log('custom_setup_id = ' || l_modifier_list_rec.custom_setup_id);

2991: l_modifier_list_rec.reusable,l_modifier_list_rec.offer_amount,l_offer_code,l_owner_id, l_offer_name;
2992: CLOSE c_offer_info;
2993:
2994: ozf_utility_pvt.Write_Conc_log('offer_type = ' || l_modifier_list_rec.offer_type);
2995: ozf_utility_pvt.Write_Conc_log('custom_setup_id = ' || l_modifier_list_rec.custom_setup_id);
2996: ozf_utility_pvt.Write_Conc_log('reusable = ' || l_modifier_list_rec.reusable);
2997: ozf_utility_pvt.Write_Conc_log('offer_amount = ' || l_modifier_list_rec.offer_amount);
2998:
2999: IF p_actbudget_id IS NOT NULL THEN

Line 2996: ozf_utility_pvt.Write_Conc_log('reusable = ' || l_modifier_list_rec.reusable);

2992: CLOSE c_offer_info;
2993:
2994: ozf_utility_pvt.Write_Conc_log('offer_type = ' || l_modifier_list_rec.offer_type);
2995: ozf_utility_pvt.Write_Conc_log('custom_setup_id = ' || l_modifier_list_rec.custom_setup_id);
2996: ozf_utility_pvt.Write_Conc_log('reusable = ' || l_modifier_list_rec.reusable);
2997: ozf_utility_pvt.Write_Conc_log('offer_amount = ' || l_modifier_list_rec.offer_amount);
2998:
2999: IF p_actbudget_id IS NOT NULL THEN
3000:

Line 2997: ozf_utility_pvt.Write_Conc_log('offer_amount = ' || l_modifier_list_rec.offer_amount);

2993:
2994: ozf_utility_pvt.Write_Conc_log('offer_type = ' || l_modifier_list_rec.offer_type);
2995: ozf_utility_pvt.Write_Conc_log('custom_setup_id = ' || l_modifier_list_rec.custom_setup_id);
2996: ozf_utility_pvt.Write_Conc_log('reusable = ' || l_modifier_list_rec.reusable);
2997: ozf_utility_pvt.Write_Conc_log('offer_amount = ' || l_modifier_list_rec.offer_amount);
2998:
2999: IF p_actbudget_id IS NOT NULL THEN
3000:
3001: ozf_utility_pvt.Write_Conc_log('p_actbudget_id IS NOT NULL');

Line 3001: ozf_utility_pvt.Write_Conc_log('p_actbudget_id IS NOT NULL');

2997: ozf_utility_pvt.Write_Conc_log('offer_amount = ' || l_modifier_list_rec.offer_amount);
2998:
2999: IF p_actbudget_id IS NOT NULL THEN
3000:
3001: ozf_utility_pvt.Write_Conc_log('p_actbudget_id IS NOT NULL');
3002:
3003: -- single budget request submission. called from ozf_actbudgets_pvt.
3004: validate_object_budget ( p_object_id => p_object_id,
3005: p_object_type => p_object_type,

Line 3016: ozf_utility_pvt.Write_Conc_log('validation succeeds');

3012: ozf_actbudgets_pvt.init_act_budgets_rec(l_act_budgets_rec);
3013: l_act_budgets_rec.activity_budget_id := p_actbudget_id;
3014:
3015: IF l_return_status = fnd_api.G_RET_STS_SUCCESS THEN
3016: ozf_utility_pvt.Write_Conc_log('validation succeeds');
3017: -- validation succeeds. Change budget request status to 'APPROVED'
3018: l_act_budgets_rec.status_code := 'APPROVED';
3019: l_act_budgets_rec.user_status_id :=
3020: ozf_utility_pvt.get_default_user_status ('OZF_BUDGETSOURCE_STATUS', l_act_budgets_rec.status_code);

Line 3020: ozf_utility_pvt.get_default_user_status ('OZF_BUDGETSOURCE_STATUS', l_act_budgets_rec.status_code);

3016: ozf_utility_pvt.Write_Conc_log('validation succeeds');
3017: -- validation succeeds. Change budget request status to 'APPROVED'
3018: l_act_budgets_rec.status_code := 'APPROVED';
3019: l_act_budgets_rec.user_status_id :=
3020: ozf_utility_pvt.get_default_user_status ('OZF_BUDGETSOURCE_STATUS', l_act_budgets_rec.status_code);
3021:
3022: /*bug 4662453
3023: IF l_offer_status <> 'DRAFT' THEN
3024: l_offer_status := 'ACTIVE';

Line 3025: ozf_utility_pvt.Write_Conc_log('l_offer_status1 : ' || l_offer_status);

3021:
3022: /*bug 4662453
3023: IF l_offer_status <> 'DRAFT' THEN
3024: l_offer_status := 'ACTIVE';
3025: ozf_utility_pvt.Write_Conc_log('l_offer_status1 : ' || l_offer_status);
3026: END IF;
3027: */
3028:
3029: ELSE

Line 3030: ozf_utility_pvt.Write_Conc_log('validation fails');

3026: END IF;
3027: */
3028:
3029: ELSE
3030: ozf_utility_pvt.Write_Conc_log('validation fails');
3031: -- validation fail. Change budget request status to 'NEW'
3032: l_act_budgets_rec.status_code := 'NEW';
3033: l_act_budgets_rec.user_status_id :=
3034: ozf_utility_pvt.get_default_user_status ('OZF_BUDGETSOURCE_STATUS', l_act_budgets_rec.status_code);

Line 3034: ozf_utility_pvt.get_default_user_status ('OZF_BUDGETSOURCE_STATUS', l_act_budgets_rec.status_code);

3030: ozf_utility_pvt.Write_Conc_log('validation fails');
3031: -- validation fail. Change budget request status to 'NEW'
3032: l_act_budgets_rec.status_code := 'NEW';
3033: l_act_budgets_rec.user_status_id :=
3034: ozf_utility_pvt.get_default_user_status ('OZF_BUDGETSOURCE_STATUS', l_act_budgets_rec.status_code);
3035:
3036: /*bug 4662453
3037: l_offer_status := 'DRAFT';
3038: ozf_utility_pvt.Write_Conc_log('l_offer_status2 : ' || l_offer_status);

Line 3038: ozf_utility_pvt.Write_Conc_log('l_offer_status2 : ' || l_offer_status);

3034: ozf_utility_pvt.get_default_user_status ('OZF_BUDGETSOURCE_STATUS', l_act_budgets_rec.status_code);
3035:
3036: /*bug 4662453
3037: l_offer_status := 'DRAFT';
3038: ozf_utility_pvt.Write_Conc_log('l_offer_status2 : ' || l_offer_status);
3039: */
3040:
3041: OPEN c_get_budget_name(p_actbudget_id);
3042: FETCH c_get_budget_name INTO l_budget_name;

Line 3082: ozf_utility_pvt.send_wf_standalone_message( p_subject => l_strSubject

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
3085: ,x_notif_id => l_notification_id
3086: ,x_return_status => l_return_status

Line 3090: ozf_utility_pvt.Write_Conc_log('Sent notification fails.');

3086: ,x_return_status => l_return_status
3087: );
3088:
3089: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3090: ozf_utility_pvt.Write_Conc_log('Sent notification fails.');
3091: END IF;
3092:
3093: END IF; -- end of validation fail.
3094:

Line 3107: ozf_utility_pvt.Write_Conc_log('Update_Act_Budgets fails.');

3103: p_act_budgets_rec => l_act_budgets_rec
3104: );
3105:
3106: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3107: ozf_utility_pvt.Write_Conc_log('Update_Act_Budgets fails.');
3108: END IF;
3109:
3110: ELSE -- called from offer activation. Check all budget requests of this offer
3111: ozf_utility_pvt.Write_Conc_log('p_actbudget_id IS NULL');

Line 3111: ozf_utility_pvt.Write_Conc_log('p_actbudget_id IS NULL');

3107: ozf_utility_pvt.Write_Conc_log('Update_Act_Budgets fails.');
3108: END IF;
3109:
3110: ELSE -- called from offer activation. Check all budget requests of this offer
3111: ozf_utility_pvt.Write_Conc_log('p_actbudget_id IS NULL');
3112: ozf_utility_pvt.Write_Conc_log('Validate budget requests for offer id = ' || p_object_id);
3113: FOR request_rec IN c_get_requests LOOP
3114:
3115: ozf_utility_pvt.Write_Conc_log('Valid budget request id = ' || request_rec.activity_budget_id);

Line 3112: ozf_utility_pvt.Write_Conc_log('Validate budget requests for offer id = ' || p_object_id);

3108: END IF;
3109:
3110: ELSE -- called from offer activation. Check all budget requests of this offer
3111: ozf_utility_pvt.Write_Conc_log('p_actbudget_id IS NULL');
3112: ozf_utility_pvt.Write_Conc_log('Validate budget requests for offer id = ' || p_object_id);
3113: FOR request_rec IN c_get_requests LOOP
3114:
3115: ozf_utility_pvt.Write_Conc_log('Valid budget request id = ' || request_rec.activity_budget_id);
3116:

Line 3115: ozf_utility_pvt.Write_Conc_log('Valid budget request id = ' || request_rec.activity_budget_id);

3111: ozf_utility_pvt.Write_Conc_log('p_actbudget_id IS NULL');
3112: ozf_utility_pvt.Write_Conc_log('Validate budget requests for offer id = ' || p_object_id);
3113: FOR request_rec IN c_get_requests LOOP
3114:
3115: ozf_utility_pvt.Write_Conc_log('Valid budget request id = ' || request_rec.activity_budget_id);
3116:
3117: validate_object_budget( p_object_id => request_rec.act_budget_used_by_id,
3118: p_object_type => request_rec.arc_act_budget_used_by,
3119: p_actbudget_id => request_rec.activity_budget_id,

Line 3127: ozf_utility_pvt.Write_Conc_log('Validation return status = ' || l_return_status);

3123:
3124: ozf_actbudgets_pvt.init_act_budgets_rec(l_act_budgets_rec);
3125: l_act_budgets_rec.activity_budget_id := request_rec.activity_budget_id;
3126:
3127: ozf_utility_pvt.Write_Conc_log('Validation return status = ' || l_return_status);
3128:
3129: IF l_return_status = fnd_api.G_RET_STS_SUCCESS THEN
3130: ozf_utility_pvt.Write_Conc_log('validation succeeds');
3131:

Line 3130: ozf_utility_pvt.Write_Conc_log('validation succeeds');

3126:
3127: ozf_utility_pvt.Write_Conc_log('Validation return status = ' || l_return_status);
3128:
3129: IF l_return_status = fnd_api.G_RET_STS_SUCCESS THEN
3130: ozf_utility_pvt.Write_Conc_log('validation succeeds');
3131:
3132: -- validation succeeds. Change budget request status to 'APPROVED'
3133: l_act_budgets_rec.status_code := 'APPROVED';
3134: l_act_budgets_rec.user_status_id :=

Line 3135: ozf_utility_pvt.get_default_user_status ('OZF_BUDGETSOURCE_STATUS', l_act_budgets_rec.status_code);

3131:
3132: -- validation succeeds. Change budget request status to 'APPROVED'
3133: l_act_budgets_rec.status_code := 'APPROVED';
3134: l_act_budgets_rec.user_status_id :=
3135: ozf_utility_pvt.get_default_user_status ('OZF_BUDGETSOURCE_STATUS', l_act_budgets_rec.status_code);
3136:
3137: IF l_offer_status <> 'DRAFT' THEN
3138: l_offer_status := 'ACTIVE';
3139: ozf_utility_pvt.Write_Conc_log('l_offer_status3 : ' || l_offer_status);

Line 3139: ozf_utility_pvt.Write_Conc_log('l_offer_status3 : ' || l_offer_status);

3135: ozf_utility_pvt.get_default_user_status ('OZF_BUDGETSOURCE_STATUS', l_act_budgets_rec.status_code);
3136:
3137: IF l_offer_status <> 'DRAFT' THEN
3138: l_offer_status := 'ACTIVE';
3139: ozf_utility_pvt.Write_Conc_log('l_offer_status3 : ' || l_offer_status);
3140: END IF;
3141:
3142: ELSE
3143: ozf_utility_pvt.Write_Conc_log('validation fails');

Line 3143: ozf_utility_pvt.Write_Conc_log('validation fails');

3139: ozf_utility_pvt.Write_Conc_log('l_offer_status3 : ' || l_offer_status);
3140: END IF;
3141:
3142: ELSE
3143: ozf_utility_pvt.Write_Conc_log('validation fails');
3144:
3145: l_act_budgets_rec.status_code := 'NEW';
3146: l_offer_status := 'DRAFT';
3147: ozf_utility_pvt.Write_Conc_log('l_offer_status4 : ' || l_offer_status);

Line 3147: ozf_utility_pvt.Write_Conc_log('l_offer_status4 : ' || l_offer_status);

3143: ozf_utility_pvt.Write_Conc_log('validation fails');
3144:
3145: l_act_budgets_rec.status_code := 'NEW';
3146: l_offer_status := 'DRAFT';
3147: ozf_utility_pvt.Write_Conc_log('l_offer_status4 : ' || l_offer_status);
3148: l_act_budgets_rec.user_status_id :=
3149: ozf_utility_pvt.get_default_user_status ('OZF_BUDGETSOURCE_STATUS', l_act_budgets_rec.status_code);
3150:
3151: OPEN c_get_budget_name(request_rec.activity_budget_id);

Line 3149: ozf_utility_pvt.get_default_user_status ('OZF_BUDGETSOURCE_STATUS', l_act_budgets_rec.status_code);

3145: l_act_budgets_rec.status_code := 'NEW';
3146: l_offer_status := 'DRAFT';
3147: ozf_utility_pvt.Write_Conc_log('l_offer_status4 : ' || l_offer_status);
3148: l_act_budgets_rec.user_status_id :=
3149: ozf_utility_pvt.get_default_user_status ('OZF_BUDGETSOURCE_STATUS', l_act_budgets_rec.status_code);
3150:
3151: OPEN c_get_budget_name(request_rec.activity_budget_id);
3152: FETCH c_get_budget_name INTO l_budget_name;
3153: CLOSE c_get_budget_name;

Line 3191: ozf_utility_pvt.send_wf_standalone_message( p_subject => l_strSubject

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
3194: ,x_notif_id => l_notification_id
3195: ,x_return_status => l_return_status

Line 3199: ozf_utility_pvt.Write_Conc_log('Sent notification fails.');

3195: ,x_return_status => l_return_status
3196: );
3197:
3198: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3199: ozf_utility_pvt.Write_Conc_log('Sent notification fails.');
3200: END IF;
3201:
3202:
3203: ozf_utility_pvt.Write_Conc_log('l_act_budgets_rec.activity_budget_id: ' || l_act_budgets_rec.activity_budget_id);

Line 3203: ozf_utility_pvt.Write_Conc_log('l_act_budgets_rec.activity_budget_id: ' || l_act_budgets_rec.activity_budget_id);

3199: ozf_utility_pvt.Write_Conc_log('Sent notification fails.');
3200: END IF;
3201:
3202:
3203: ozf_utility_pvt.Write_Conc_log('l_act_budgets_rec.activity_budget_id: ' || l_act_budgets_rec.activity_budget_id);
3204:
3205: /*kdass 05-DEC-2005 bug 4662453 - Update_Act_Budgets is being called twice, so removing this one
3206: ozf_actbudgets_pvt.Update_Act_Budgets ( p_api_version => 1.0,
3207: p_init_msg_list => FND_API.g_false,

Line 3216: ozf_utility_pvt.Write_Conc_log('return status from Update_Act_Budgets = ' || l_return_status);

3212: x_msg_data => l_msg_data,
3213: p_act_budgets_rec => l_act_budgets_rec
3214: );
3215:
3216: ozf_utility_pvt.Write_Conc_log('return status from Update_Act_Budgets = ' || l_return_status);
3217:
3218: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3219: ozf_utility_pvt.Write_Conc_log('Update_Act_Budgets fails');
3220: END IF;

Line 3219: ozf_utility_pvt.Write_Conc_log('Update_Act_Budgets fails');

3215:
3216: ozf_utility_pvt.Write_Conc_log('return status from Update_Act_Budgets = ' || l_return_status);
3217:
3218: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3219: ozf_utility_pvt.Write_Conc_log('Update_Act_Budgets fails');
3220: END IF;
3221: */
3222:
3223: END IF; -- end of validation fail

Line 3235: ozf_utility_pvt.Write_Conc_log('Update_Act_Budgets returns = ' || l_return_status);

3231: x_msg_data => l_msg_data,
3232: p_act_budgets_rec => l_act_budgets_rec
3233: );
3234:
3235: ozf_utility_pvt.Write_Conc_log('Update_Act_Budgets returns = ' || l_return_status);
3236:
3237: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3238: ozf_utility_pvt.Write_Conc_log('Valid budget request id = ' || p_actbudget_id);
3239: ELSE

Line 3238: ozf_utility_pvt.Write_Conc_log('Valid budget request id = ' || p_actbudget_id);

3234:
3235: ozf_utility_pvt.Write_Conc_log('Update_Act_Budgets returns = ' || l_return_status);
3236:
3237: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3238: ozf_utility_pvt.Write_Conc_log('Valid budget request id = ' || p_actbudget_id);
3239: ELSE
3240: ozf_utility_pvt.Write_Conc_log('Invalid budget request id = ' || p_actbudget_id);
3241: END IF;
3242:

Line 3240: ozf_utility_pvt.Write_Conc_log('Invalid budget request id = ' || p_actbudget_id);

3236:
3237: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3238: ozf_utility_pvt.Write_Conc_log('Valid budget request id = ' || p_actbudget_id);
3239: ELSE
3240: ozf_utility_pvt.Write_Conc_log('Invalid budget request id = ' || p_actbudget_id);
3241: END IF;
3242:
3243: END LOOP;
3244:

Line 3247: ozf_utility_pvt.Write_Conc_log('validate_object_budget_all start');

3243: END LOOP;
3244:
3245: END IF; -- end of p_actbudget_id.
3246:
3247: ozf_utility_pvt.Write_Conc_log('validate_object_budget_all start');
3248:
3249: validate_object_budget_all ( p_object_id => p_object_id,
3250: p_object_type => p_object_type,
3251: x_return_status => l_return_status,

Line 3256: ozf_utility_pvt.Write_Conc_log('return status = ' || l_return_status);

3252: x_msg_count => l_msg_count,
3253: x_msg_data => l_msg_data
3254: );
3255:
3256: ozf_utility_pvt.Write_Conc_log('return status = ' || l_return_status);
3257:
3258: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
3259: l_offer_status := 'DRAFT';
3260: ozf_utility_pvt.Write_Conc_log('Relaxed validation failed');

Line 3260: ozf_utility_pvt.Write_Conc_log('Relaxed validation failed');

3256: ozf_utility_pvt.Write_Conc_log('return status = ' || l_return_status);
3257:
3258: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
3259: l_offer_status := 'DRAFT';
3260: ozf_utility_pvt.Write_Conc_log('Relaxed validation failed');
3261: END IF;
3262:
3263: --kdass 05-DEC-2005 bug 4662453 - offer activation API should only be called from offer activation.
3264: IF p_actbudget_id IS NULL THEN

Line 3266: ozf_utility_pvt.Write_Conc_log('l_offer_status : ' || l_offer_status);

3262:
3263: --kdass 05-DEC-2005 bug 4662453 - offer activation API should only be called from offer activation.
3264: IF p_actbudget_id IS NULL THEN
3265:
3266: ozf_utility_pvt.Write_Conc_log('l_offer_status : ' || l_offer_status);
3267: l_modifier_list_rec.STATUS_CODE := l_offer_status;
3268: l_modifier_list_rec.USER_STATUS_ID :=
3269: ozf_utility_pvt.get_default_user_status ('OZF_OFFER_STATUS', l_modifier_list_rec.status_code);
3270:

Line 3269: ozf_utility_pvt.get_default_user_status ('OZF_OFFER_STATUS', l_modifier_list_rec.status_code);

3265:
3266: ozf_utility_pvt.Write_Conc_log('l_offer_status : ' || l_offer_status);
3267: l_modifier_list_rec.STATUS_CODE := l_offer_status;
3268: l_modifier_list_rec.USER_STATUS_ID :=
3269: ozf_utility_pvt.get_default_user_status ('OZF_OFFER_STATUS', l_modifier_list_rec.status_code);
3270:
3271: ozf_utility_pvt.Write_Conc_log('STATUS_CODE = ' || l_modifier_list_rec.STATUS_CODE);
3272: ozf_utility_pvt.Write_Conc_log('USER_STATUS_ID = ' || l_modifier_list_rec.USER_STATUS_ID);
3273:

Line 3271: ozf_utility_pvt.Write_Conc_log('STATUS_CODE = ' || l_modifier_list_rec.STATUS_CODE);

3267: l_modifier_list_rec.STATUS_CODE := l_offer_status;
3268: l_modifier_list_rec.USER_STATUS_ID :=
3269: ozf_utility_pvt.get_default_user_status ('OZF_OFFER_STATUS', l_modifier_list_rec.status_code);
3270:
3271: ozf_utility_pvt.Write_Conc_log('STATUS_CODE = ' || l_modifier_list_rec.STATUS_CODE);
3272: ozf_utility_pvt.Write_Conc_log('USER_STATUS_ID = ' || l_modifier_list_rec.USER_STATUS_ID);
3273:
3274: -- update offer status. if validation fail.
3275: --- otherwise to 'ACTIVE'

Line 3272: ozf_utility_pvt.Write_Conc_log('USER_STATUS_ID = ' || l_modifier_list_rec.USER_STATUS_ID);

3268: l_modifier_list_rec.USER_STATUS_ID :=
3269: ozf_utility_pvt.get_default_user_status ('OZF_OFFER_STATUS', l_modifier_list_rec.status_code);
3270:
3271: ozf_utility_pvt.Write_Conc_log('STATUS_CODE = ' || l_modifier_list_rec.STATUS_CODE);
3272: ozf_utility_pvt.Write_Conc_log('USER_STATUS_ID = ' || l_modifier_list_rec.USER_STATUS_ID);
3273:
3274: -- update offer status. if validation fail.
3275: --- otherwise to 'ACTIVE'
3276: Ozf_Offer_Pvt.Activate_Offer_Over( p_api_version => 1.0

Line 3287: ozf_utility_pvt.Write_Conc_log('Activate_Offer_Over returns = ' || l_return_status);

3283: ,p_offer_rec => l_modifier_list_rec
3284: ,x_amount_error => l_amount_error
3285: );
3286:
3287: ozf_utility_pvt.Write_Conc_log('Activate_Offer_Over returns = ' || l_return_status);
3288:
3289: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3290: ozf_utility_pvt.Write_Conc_log('exception raised');
3291: RAISE fnd_api.g_exc_error;

Line 3290: ozf_utility_pvt.Write_Conc_log('exception raised');

3286:
3287: ozf_utility_pvt.Write_Conc_log('Activate_Offer_Over returns = ' || l_return_status);
3288:
3289: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3290: ozf_utility_pvt.Write_Conc_log('exception raised');
3291: RAISE fnd_api.g_exc_error;
3292: END IF;
3293:
3294: END IF;

Line 3300: ozf_utility_pvt.Write_Conc_log(l_msg_data);

3296: COMMIT;
3297:
3298: x_retcode := 0;
3299:
3300: ozf_utility_pvt.Write_Conc_log(l_msg_data);
3301:
3302: EXCEPTION
3303: WHEN fnd_api.g_exc_error THEN
3304: ozf_utility_pvt.Write_Conc_log('fnd_api.g_exc_error');

Line 3304: ozf_utility_pvt.Write_Conc_log('fnd_api.g_exc_error');

3300: ozf_utility_pvt.Write_Conc_log(l_msg_data);
3301:
3302: EXCEPTION
3303: WHEN fnd_api.g_exc_error THEN
3304: ozf_utility_pvt.Write_Conc_log('fnd_api.g_exc_error');
3305:
3306: ROLLBACK TO conc_validate_offer_budget;
3307:
3308: -- revert to draft status

Line 3311: ,user_status_id = OZF_Utility_PVT.get_default_user_status ('OZF_OFFER_STATUS', 'DRAFT')

3307:
3308: -- revert to draft status
3309: UPDATE ozf_offers
3310: SET status_code = 'DRAFT'
3311: ,user_status_id = OZF_Utility_PVT.get_default_user_status ('OZF_OFFER_STATUS', 'DRAFT')
3312: ,status_date = SYSDATE
3313: ,object_version_number = object_version_number + 1
3314: WHERE qp_list_header_id = l_modifier_list_rec.qp_list_header_id;
3315:

Line 3320: ,user_status_id = OZF_Utility_PVT.get_default_user_status ('OZF_BUDGETSOURCE_STATUS', 'DRAFT')

3316: --kdass 05-DEC-2005 bug 4662453 - reverting budget line status from pending validation to draft
3317: IF p_actbudget_id IS NOT NULL THEN
3318: UPDATE ozf_act_budgets
3319: SET status_code = 'DRAFT'
3320: ,user_status_id = OZF_Utility_PVT.get_default_user_status ('OZF_BUDGETSOURCE_STATUS', 'DRAFT')
3321: ,object_version_number = object_version_number + 1
3322: WHERE activity_budget_id = p_actbudget_id
3323: AND status_code = 'PENDING';
3324: ELSE

Line 3329: ,user_status_id = OZF_Utility_PVT.get_default_user_status ('OZF_BUDGETSOURCE_STATUS', 'DRAFT')

3325: FOR request_rec IN c_get_requests
3326: LOOP
3327: UPDATE ozf_act_budgets
3328: SET status_code = 'DRAFT'
3329: ,user_status_id = OZF_Utility_PVT.get_default_user_status ('OZF_BUDGETSOURCE_STATUS', 'DRAFT')
3330: ,object_version_number = object_version_number + 1
3331: WHERE activity_budget_id = request_rec.activity_budget_id
3332: AND status_code = 'PENDING';
3333: END LOOP;

Line 3388: ozf_utility_pvt.send_wf_standalone_message( p_subject => l_strSubject

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
3391: ,x_notif_id => l_notification_id
3392: ,x_return_status => l_return_status

Line 3396: ozf_utility_pvt.Write_Conc_log('other exception');

3392: ,x_return_status => l_return_status
3393: );
3394:
3395: WHEN OTHERS THEN
3396: ozf_utility_pvt.Write_Conc_log('other exception');
3397: ROLLBACK TO conc_validate_offer_budget;
3398: x_retcode := 1;
3399: x_errbuf := l_msg_data;
3400: ozf_utility_pvt.write_conc_log (x_errbuf);

Line 3400: ozf_utility_pvt.write_conc_log (x_errbuf);

3396: ozf_utility_pvt.Write_Conc_log('other exception');
3397: ROLLBACK TO conc_validate_offer_budget;
3398: x_retcode := 1;
3399: x_errbuf := l_msg_data;
3400: ozf_utility_pvt.write_conc_log (x_errbuf);
3401:
3402: END conc_validate_offer_budget;
3403:
3404: -------------------------------------------------------------------

Line 3484: ozf_utility_pvt.debug_message(l_full_name || ': start');

3480: BEGIN
3481: x_return_status := fnd_api.g_ret_sts_success;
3482: -- Initialize
3483: IF G_DEBUG THEN
3484: ozf_utility_pvt.debug_message(l_full_name || ': start');
3485: END IF;
3486:
3487: IF p_object_type = 'OFFR' THEN
3488:

Line 3543: ozf_utility_pvt.get_default_user_status ('OZF_BUDGETSOURCE_STATUS', l_act_budgets_rec.status_code);

3539: l_act_budgets_rec.activity_budget_id := actbudget_rec.activity_budget_id;
3540:
3541: l_act_budgets_rec.status_code := 'APPROVED'; -- will changed to "PENDING_VALIDATION" by api.
3542: l_act_budgets_rec.user_status_id :=
3543: ozf_utility_pvt.get_default_user_status ('OZF_BUDGETSOURCE_STATUS', l_act_budgets_rec.status_code);
3544:
3545: ozf_actbudgets_pvt.update_act_budgets (
3546: p_api_version=> 1.0
3547: ,p_init_msg_list=> fnd_api.g_false

Line 3580: ozf_utility_pvt.send_wf_standalone_message(

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
3583: ,p_send_to_res_id => l_owner_id
3584: ,x_notif_id => l_notification_id

Line 3615: ozf_utility_pvt.debug_message(l_full_name || ': end');

3611: x_status_code := 'ACTIVE';
3612: END IF;
3613:
3614: IF G_DEBUG THEN
3615: ozf_utility_pvt.debug_message(l_full_name || ': end');
3616: END IF;
3617:
3618: fnd_msg_pub.count_and_get(
3619: p_encoded => fnd_api.g_false