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 222: l_act_budget_rec.user_status_id := ozf_utility_pvt.get_default_user_status(g_status_type, l_act_budget_rec.status_code);

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

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

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

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

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

Line 473: ozf_utility_pvt.send_wf_standalone_message(

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
476: ,p_send_to_res_id => l_camp_owner_id
477: ,x_notif_id => l_notification_id

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

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

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

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

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

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

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

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

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

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

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

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

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

2385: END IF;
2386: RAISE fnd_api.G_EXC_ERROR;
2387: END IF;
2388: IF G_DEBUG THEN
2389: ozf_utility_pvt.debug_message(' SUCCESS ');
2390: END IF;
2391:
2392: EXCEPTION
2393: WHEN fnd_api.g_exc_error THEN

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

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

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

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

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

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

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

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

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

2546: END IF;
2547:
2548:
2549: IF G_DEBUG THEN
2550: ozf_utility_pvt.debug_message(' SUCCESS ');
2551: END IF;
2552:
2553: EXCEPTION
2554: WHEN fnd_api.g_exc_error THEN

Line 2881: ozf_utility_pvt.send_wf_standalone_message(

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
2884: ,p_send_to_res_id => l_owner_id
2885: ,x_notif_id => l_notification_id

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

2986: FETCH c_offer_info INTO l_modifier_list_rec.offer_type,l_modifier_list_rec.custom_setup_id,
2987: l_modifier_list_rec.reusable,l_modifier_list_rec.offer_amount,l_offer_code,l_owner_id, l_offer_name;
2988: CLOSE c_offer_info;
2989:
2990: ozf_utility_pvt.Write_Conc_log('offer_type = ' || l_modifier_list_rec.offer_type);
2991: ozf_utility_pvt.Write_Conc_log('custom_setup_id = ' || l_modifier_list_rec.custom_setup_id);
2992: ozf_utility_pvt.Write_Conc_log('reusable = ' || l_modifier_list_rec.reusable);
2993: ozf_utility_pvt.Write_Conc_log('offer_amount = ' || l_modifier_list_rec.offer_amount);
2994:

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

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

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

2988: CLOSE c_offer_info;
2989:
2990: ozf_utility_pvt.Write_Conc_log('offer_type = ' || l_modifier_list_rec.offer_type);
2991: ozf_utility_pvt.Write_Conc_log('custom_setup_id = ' || l_modifier_list_rec.custom_setup_id);
2992: ozf_utility_pvt.Write_Conc_log('reusable = ' || l_modifier_list_rec.reusable);
2993: ozf_utility_pvt.Write_Conc_log('offer_amount = ' || l_modifier_list_rec.offer_amount);
2994:
2995: IF p_actbudget_id IS NOT NULL THEN
2996:

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

2989:
2990: ozf_utility_pvt.Write_Conc_log('offer_type = ' || l_modifier_list_rec.offer_type);
2991: ozf_utility_pvt.Write_Conc_log('custom_setup_id = ' || l_modifier_list_rec.custom_setup_id);
2992: ozf_utility_pvt.Write_Conc_log('reusable = ' || l_modifier_list_rec.reusable);
2993: ozf_utility_pvt.Write_Conc_log('offer_amount = ' || l_modifier_list_rec.offer_amount);
2994:
2995: IF p_actbudget_id IS NOT NULL THEN
2996:
2997: ozf_utility_pvt.Write_Conc_log('p_actbudget_id IS NOT NULL');

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

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

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

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

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

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

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

3017:
3018: /*bug 4662453
3019: IF l_offer_status <> 'DRAFT' THEN
3020: l_offer_status := 'ACTIVE';
3021: ozf_utility_pvt.Write_Conc_log('l_offer_status1 : ' || l_offer_status);
3022: END IF;
3023: */
3024:
3025: ELSE

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

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

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

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

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

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

Line 3078: ozf_utility_pvt.send_wf_standalone_message( p_subject => l_strSubject

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
3081: ,x_notif_id => l_notification_id
3082: ,x_return_status => l_return_status

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

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

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

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

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

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

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

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

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

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

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

3119:
3120: ozf_actbudgets_pvt.init_act_budgets_rec(l_act_budgets_rec);
3121: l_act_budgets_rec.activity_budget_id := request_rec.activity_budget_id;
3122:
3123: ozf_utility_pvt.Write_Conc_log('Validation return status = ' || l_return_status);
3124:
3125: IF l_return_status = fnd_api.G_RET_STS_SUCCESS THEN
3126: ozf_utility_pvt.Write_Conc_log('validation succeeds');
3127:

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

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

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

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

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

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

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

3135: ozf_utility_pvt.Write_Conc_log('l_offer_status3 : ' || l_offer_status);
3136: END IF;
3137:
3138: ELSE
3139: ozf_utility_pvt.Write_Conc_log('validation fails');
3140:
3141: l_act_budgets_rec.status_code := 'NEW';
3142: l_offer_status := 'DRAFT';
3143: ozf_utility_pvt.Write_Conc_log('l_offer_status4 : ' || l_offer_status);

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

3139: ozf_utility_pvt.Write_Conc_log('validation fails');
3140:
3141: l_act_budgets_rec.status_code := 'NEW';
3142: l_offer_status := 'DRAFT';
3143: ozf_utility_pvt.Write_Conc_log('l_offer_status4 : ' || l_offer_status);
3144: l_act_budgets_rec.user_status_id :=
3145: ozf_utility_pvt.get_default_user_status ('OZF_BUDGETSOURCE_STATUS', l_act_budgets_rec.status_code);
3146:
3147: OPEN c_get_budget_name(request_rec.activity_budget_id);

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

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

Line 3187: ozf_utility_pvt.send_wf_standalone_message( p_subject => l_strSubject

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
3190: ,x_notif_id => l_notification_id
3191: ,x_return_status => l_return_status

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

3191: ,x_return_status => l_return_status
3192: );
3193:
3194: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3195: ozf_utility_pvt.Write_Conc_log('Sent notification fails.');
3196: END IF;
3197:
3198:
3199: ozf_utility_pvt.Write_Conc_log('l_act_budgets_rec.activity_budget_id: ' || l_act_budgets_rec.activity_budget_id);

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

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

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

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

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

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

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

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

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

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

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

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

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

3239: END LOOP;
3240:
3241: END IF; -- end of p_actbudget_id.
3242:
3243: ozf_utility_pvt.Write_Conc_log('validate_object_budget_all start');
3244:
3245: validate_object_budget_all ( p_object_id => p_object_id,
3246: p_object_type => p_object_type,
3247: x_return_status => l_return_status,

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

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

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

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

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

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

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

3261:
3262: ozf_utility_pvt.Write_Conc_log('l_offer_status : ' || l_offer_status);
3263: l_modifier_list_rec.STATUS_CODE := l_offer_status;
3264: l_modifier_list_rec.USER_STATUS_ID :=
3265: ozf_utility_pvt.get_default_user_status ('OZF_OFFER_STATUS', l_modifier_list_rec.status_code);
3266:
3267: ozf_utility_pvt.Write_Conc_log('STATUS_CODE = ' || l_modifier_list_rec.STATUS_CODE);
3268: ozf_utility_pvt.Write_Conc_log('USER_STATUS_ID = ' || l_modifier_list_rec.USER_STATUS_ID);
3269:

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

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

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

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

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

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

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

3282:
3283: ozf_utility_pvt.Write_Conc_log('Activate_Offer_Over returns = ' || l_return_status);
3284:
3285: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3286: ozf_utility_pvt.Write_Conc_log('exception raised');
3287: RAISE fnd_api.g_exc_error;
3288: END IF;
3289:
3290: END IF;

Line 3296: ozf_utility_pvt.Write_Conc_log(l_msg_data);

3292: COMMIT;
3293:
3294: x_retcode := 0;
3295:
3296: ozf_utility_pvt.Write_Conc_log(l_msg_data);
3297:
3298: EXCEPTION
3299: WHEN fnd_api.g_exc_error THEN
3300: ozf_utility_pvt.Write_Conc_log('fnd_api.g_exc_error');

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

3296: ozf_utility_pvt.Write_Conc_log(l_msg_data);
3297:
3298: EXCEPTION
3299: WHEN fnd_api.g_exc_error THEN
3300: ozf_utility_pvt.Write_Conc_log('fnd_api.g_exc_error');
3301:
3302: ROLLBACK TO conc_validate_offer_budget;
3303:
3304: -- revert to draft status

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

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

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

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

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

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

Line 3384: ozf_utility_pvt.send_wf_standalone_message( p_subject => l_strSubject

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
3387: ,x_notif_id => l_notification_id
3388: ,x_return_status => l_return_status

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

3388: ,x_return_status => l_return_status
3389: );
3390:
3391: WHEN OTHERS THEN
3392: ozf_utility_pvt.Write_Conc_log('other exception');
3393: ROLLBACK TO conc_validate_offer_budget;
3394: x_retcode := 1;
3395: x_errbuf := l_msg_data;
3396: ozf_utility_pvt.write_conc_log (x_errbuf);

Line 3396: ozf_utility_pvt.write_conc_log (x_errbuf);

3392: ozf_utility_pvt.Write_Conc_log('other exception');
3393: ROLLBACK TO conc_validate_offer_budget;
3394: x_retcode := 1;
3395: x_errbuf := l_msg_data;
3396: ozf_utility_pvt.write_conc_log (x_errbuf);
3397:
3398: END conc_validate_offer_budget;
3399:
3400: -------------------------------------------------------------------

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

3476: BEGIN
3477: x_return_status := fnd_api.g_ret_sts_success;
3478: -- Initialize
3479: IF G_DEBUG THEN
3480: ozf_utility_pvt.debug_message(l_full_name || ': start');
3481: END IF;
3482:
3483: IF p_object_type = 'OFFR' THEN
3484:

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

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

Line 3576: ozf_utility_pvt.send_wf_standalone_message(

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
3579: ,p_send_to_res_id => l_owner_id
3580: ,x_notif_id => l_notification_id

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

3607: x_status_code := 'ACTIVE';
3608: END IF;
3609:
3610: IF G_DEBUG THEN
3611: ozf_utility_pvt.debug_message(l_full_name || ': end');
3612: END IF;
3613:
3614: fnd_msg_pub.count_and_get(
3615: p_encoded => fnd_api.g_false