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_SD_REQUEST_PUB dependencies on OZF_UTILITY_PVT

Line 40: ozf_utility_pvt.debug_message(' Request Header Id :'||p_request_header_id );

36:
37: l_event_name := 'oracle.apps.ozf.sd.request.statuschange';
38:
39: IF G_DEBUG THEN
40: ozf_utility_pvt.debug_message(' Request Header Id :'||p_request_header_id );
41: END IF;
42:
43: wf_event.AddParameterToList(p_name => 'OZF_SDR_HEADER_ID',
44: p_value => p_request_header_id,

Line 56: ozf_utility_pvt.debug_message('Item Key is :'||l_item_key);

52: p_value => p_to_status,
53: p_parameterlist => l_parameter_list);
54:
55: IF G_DEBUG THEN
56: ozf_utility_pvt.debug_message('Item Key is :'||l_item_key);
57: END IF;
58:
59: wf_event.raise( p_event_name =>l_event_name,
60: p_event_key => l_item_key,

Line 67: ozf_utility_pvt.debug_message('Exception in raising business event');

63: EXCEPTION
64: WHEN OTHERS THEN
65: RAISE Fnd_Api.g_exc_error;
66: IF G_DEBUG THEN
67: ozf_utility_pvt.debug_message('Exception in raising business event');
68: END IF;
69:
70: END;
71:

Line 97: ozf_utility_pvt.debug_message(' Request Header Id :'||p_request_header_id );

93:
94: l_event_name := 'oracle.apps.ozf.sd.request.outbound';
95:
96: IF G_DEBUG THEN
97: ozf_utility_pvt.debug_message(' Request Header Id :'||p_request_header_id );
98: END IF;
99:
100: wf_event.AddParameterToList(p_name => 'ECX_MAP_CODE',
101: p_value => 'OZF_SD_REQ_OUT',

Line 153: ozf_utility_pvt.debug_message('Item Key is :'||l_item_key);

149: p_value => 3,
150: p_parameterlist => l_parameter_list);
151:
152: IF G_DEBUG THEN
153: ozf_utility_pvt.debug_message('Item Key is :'||l_item_key);
154: END IF;
155:
156: wf_event.raise( p_event_name =>l_event_name,
157: p_event_key => l_item_key,

Line 164: ozf_utility_pvt.debug_message('Exception in raising XML Gateway business event');

160: EXCEPTION
161: WHEN OTHERS THEN
162: RAISE Fnd_Api.g_exc_error;
163: IF G_DEBUG THEN
164: ozf_utility_pvt.debug_message('Exception in raising XML Gateway business event');
165: END IF;
166: END;
167:
168: ---------------------------------------------------------------------

Line 294: OZF_UTILITY_PVT.debug_message('Checking status transitions for External Request');

290: BEGIN
291: IF p_external_flag ='Y' THEN
292:
293: IF G_DEBUG THEN
294: OZF_UTILITY_PVT.debug_message('Checking status transitions for External Request');
295: END IF;
296:
297: IF p_owner_flag ='Y' THEN
298:

Line 304: OZF_UTILITY_PVT.debug_message('l_owner_count :'||l_owner_count);

300: FETCH c_external_transition INTO l_owner_count;
301: CLOSE c_external_transition;
302:
303: IF G_DEBUG THEN
304: OZF_UTILITY_PVT.debug_message('l_owner_count :'||l_owner_count);
305: END IF;
306: END IF;
307:
308: IF p_pm_flag ='Y' THEN

Line 315: OZF_UTILITY_PVT.debug_message('l_pm_count :'||l_pm_count);

311: FETCH c_external_transition INTO l_pm_count;
312: CLOSE c_external_transition;
313:
314: IF G_DEBUG THEN
315: OZF_UTILITY_PVT.debug_message('l_pm_count :'||l_pm_count);
316: END IF;
317: END IF;
318:
319: IF p_owner_flag ='Y' AND p_pm_flag ='Y' THEN

Line 334: OZF_UTILITY_PVT.debug_message('Checking status transitions for Internal Request');

330:
331: ELSIF p_internal_flag ='Y' THEN
332:
333: IF G_DEBUG THEN
334: OZF_UTILITY_PVT.debug_message('Checking status transitions for Internal Request');
335: END IF;
336:
337: IF p_owner_flag ='Y' THEN
338:

Line 344: OZF_UTILITY_PVT.debug_message('l_owner_count :'||l_owner_count);

340: FETCH c_internal_transition INTO l_owner_count;
341: CLOSE c_internal_transition;
342:
343: IF G_DEBUG THEN
344: OZF_UTILITY_PVT.debug_message('l_owner_count :'||l_owner_count);
345: END IF;
346: END IF;
347:
348: IF p_pm_flag ='Y' THEN

Line 355: OZF_UTILITY_PVT.debug_message('l_pm_count :'||l_pm_count);

351: FETCH c_internal_transition INTO l_pm_count;
352: CLOSE c_internal_transition;
353:
354: IF G_DEBUG THEN
355: OZF_UTILITY_PVT.debug_message('l_pm_count :'||l_pm_count);
356: END IF;
357: END IF;
358:
359: IF p_owner_flag ='Y' AND p_pm_flag ='Y' THEN

Line 491: OZF_UTILITY_PVT.debug_message('UOM Code for PRODUCT :'|| l_uom_code );

487: FETCH c_item_UOM INTO l_uom_code;
488: CLOSE c_item_UOM;
489:
490: IF G_DEBUG THEN
491: OZF_UTILITY_PVT.debug_message('UOM Code for PRODUCT :'|| l_uom_code );
492: END IF;
493: ELSIF p_item_type = 'PRODUCT_CATEGORY' THEN
494: OPEN c_category_chk(p_category_id);
495: FETCH c_category_chk INTO l_category_chk;

Line 508: OZF_UTILITY_PVT.debug_message('UOM Code for PRODUCT_CATEGORY :'|| l_uom_code );

504: FETCH c_category_UOM_N INTO l_uom_code;
505: CLOSE c_category_UOM_N;
506: END IF;
507: IF G_DEBUG THEN
508: OZF_UTILITY_PVT.debug_message('UOM Code for PRODUCT_CATEGORY :'|| l_uom_code );
509: END IF;
510:
511: ELSIF p_item_type = 'ALL_ITEMS' THEN
512: OPEN c_all_items_UOM(p_item_UOM);

Line 517: OZF_UTILITY_PVT.debug_message('UOM Code for ALL_ITEMS :'|| l_uom_code );

513: FETCH c_all_items_UOM INTO l_uom_code;
514: CLOSE c_all_items_UOM;
515:
516: IF G_DEBUG THEN
517: OZF_UTILITY_PVT.debug_message('UOM Code for ALL_ITEMS :'|| l_uom_code );
518: END IF;
519: END IF;
520:
521: IF l_uom_code IS NOT NULL THEN

Line 523: OZF_UTILITY_PVT.debug_message('Check_UOM Returns TRUE');

519: END IF;
520:
521: IF l_uom_code IS NOT NULL THEN
522: IF G_DEBUG THEN
523: OZF_UTILITY_PVT.debug_message('Check_UOM Returns TRUE');
524: END IF;
525: RETURN TRUE;
526:
527: ELSE

Line 529: OZF_UTILITY_PVT.debug_message('Check_UOM Returns TRUE');

525: RETURN TRUE;
526:
527: ELSE
528: IF G_DEBUG THEN
529: OZF_UTILITY_PVT.debug_message('Check_UOM Returns TRUE');
530: END IF;
531: RETURN FALSE;
532: END IF;
533:

Line 723: OZF_UTILITY_PVT.debug_message('l_resource_id of the user :'||l_resource_id);

719: x_return_status := fnd_api.g_ret_sts_error;
720: RETURN;
721: END IF;
722: IF g_debug THEN
723: OZF_UTILITY_PVT.debug_message('l_resource_id of the user :'||l_resource_id);
724: END IF;
725: END IF;
726:
727: ELSE

Line 767: OZF_UTILITY_PVT.debug_message('Requestor NOT NULL');

763:
764: --// Requestor ID Validation (owner)
765: IF p_SDR_hdr_rec.requestor_id <> FND_API.g_miss_num AND p_SDR_hdr_rec.requestor_id IS NOT NULL THEN
766: IF G_DEBUG THEN
767: OZF_UTILITY_PVT.debug_message('Requestor NOT NULL');
768: END IF;
769: OPEN c_requestor_id(p_SDR_hdr_rec.requestor_id);
770: FETCH c_requestor_id INTO l_requestor_id;
771: CLOSE c_requestor_id;

Line 778: OZF_UTILITY_PVT.debug_message('Requestor id entered is invalid');

774: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
775: FND_MESSAGE.set_name('OZF', 'OZF_SD_INVALID_REQUESTOR_ID');
776: --//Requestor id entered is invalid
777: IF G_DEBUG THEN
778: OZF_UTILITY_PVT.debug_message('Requestor id entered is invalid');
779: END IF;
780: FND_MSG_PUB.add;
781: END IF;
782: x_return_status := fnd_api.g_ret_sts_error;

Line 788: OZF_UTILITY_PVT.debug_message('l_resource_id :'||l_resource_id);

784: END IF;
785: ELSE
786: p_SDR_hdr_rec.requestor_id := l_resource_id;
787: IF G_DEBUG THEN
788: OZF_UTILITY_PVT.debug_message('l_resource_id :'||l_resource_id);
789: END IF;
790: END IF;
791:
792: IF p_SDR_hdr_rec.accrual_type ='SUPPLIER' THEN

Line 957: OZF_UTILITY_PVT.debug_message('Validating Assignee Resource ID');

953: --//Validating Assignee Resource ID
954: l_system_status_code := get_system_status_code(p_SDR_hdr_rec.user_status_id);
955:
956: IF G_DEBUG THEN
957: OZF_UTILITY_PVT.debug_message('Validating Assignee Resource ID');
958: END IF;
959:
960: IF l_system_status_code <> 'DRAFT' THEN
961:

Line 963: OZF_UTILITY_PVT.debug_message('Assignee resource_id ID :'||p_SDR_hdr_rec.assignee_resource_id);

959:
960: IF l_system_status_code <> 'DRAFT' THEN
961:
962: IF G_DEBUG THEN
963: OZF_UTILITY_PVT.debug_message('Assignee resource_id ID :'||p_SDR_hdr_rec.assignee_resource_id);
964: END IF;
965:
966: IF p_SDR_hdr_rec.assignee_resource_id <> FND_API.g_miss_num AND p_SDR_hdr_rec.assignee_resource_id IS NOT NULL THEN
967:

Line 1135: l_lookup_stat :=OZF_UTILITY_PVT.check_lookup_exists(

1131: END IF;
1132:
1133: --Request Outcome
1134: IF p_SDR_hdr_rec.request_outcome <> FND_API.g_miss_char AND p_SDR_hdr_rec.request_outcome IS NOT NULL THEN
1135: l_lookup_stat :=OZF_UTILITY_PVT.check_lookup_exists(
1136: p_lookup_table_name =>'OZF_LOOKUPS'
1137: ,p_lookup_type =>'OZF_SD_REQUEST_OUTCOME'
1138: ,p_lookup_code => p_SDR_hdr_rec.request_outcome);
1139:

Line 1431: OZF_UTILITY_PVT.debug_message('c_master_org_id -->G_ITEM_ORG_ID: ' || G_ITEM_ORG_ID);

1427: FETCH c_master_org_id INTO G_ITEM_ORG_ID;
1428: CLOSE c_master_org_id;
1429:
1430: IF G_DEBUG THEN
1431: OZF_UTILITY_PVT.debug_message('c_master_org_id -->G_ITEM_ORG_ID: ' || G_ITEM_ORG_ID);
1432: END IF;
1433:
1434:
1435: FOR i IN p_SDR_lines_tbl.FIRST..p_SDR_lines_tbl.LAST LOOP

Line 1565: l_lookup_stat :=OZF_UTILITY_PVT.check_lookup_exists(

1561:
1562: --Product Context
1563: IF p_SDR_lines_tbl(i).product_context <> FND_API.g_miss_char AND p_SDR_lines_tbl(i).product_context IS NOT NULL THEN
1564:
1565: l_lookup_stat :=OZF_UTILITY_PVT.check_lookup_exists(
1566: p_lookup_table_name =>'OZF_LOOKUPS'
1567: ,p_lookup_type =>'OZF_SD_PRODUCT_CONTEXT'
1568: ,p_lookup_code => p_SDR_lines_tbl(i).product_context);
1569:

Line 1810: l_lookup_stat :=OZF_UTILITY_PVT.check_lookup_exists(

1806:
1807:
1808: --//Requested discount type
1809: IF p_SDR_lines_tbl(i).requested_discount_type <> FND_API.g_miss_char AND p_SDR_lines_tbl(i).requested_discount_type IS NOT NULL THEN
1810: l_lookup_stat :=OZF_UTILITY_PVT.check_lookup_exists(
1811: p_lookup_table_name =>'OZF_LOOKUPS'
1812: ,p_lookup_type =>'OZF_SD_REQUEST_DISTYPE'
1813: ,p_lookup_code => p_SDR_lines_tbl(i).requested_discount_type);
1814:

Line 2022: OZF_UTILITY_PVT.debug_message('p_SDR_lines_tbl(i).start_date ' || p_SDR_lines_tbl(i).start_date);

2018: END IF;
2019: END IF;
2020:
2021: IF G_DEBUG THEN
2022: OZF_UTILITY_PVT.debug_message('p_SDR_lines_tbl(i).start_date ' || p_SDR_lines_tbl(i).start_date);
2023: OZF_UTILITY_PVT.debug_message('p_SDR_lines_tbl(i).end_date: ' || p_SDR_lines_tbl(i).end_date);
2024: END IF;
2025:
2026:

Line 2023: OZF_UTILITY_PVT.debug_message('p_SDR_lines_tbl(i).end_date: ' || p_SDR_lines_tbl(i).end_date);

2019: END IF;
2020:
2021: IF G_DEBUG THEN
2022: OZF_UTILITY_PVT.debug_message('p_SDR_lines_tbl(i).start_date ' || p_SDR_lines_tbl(i).start_date);
2023: OZF_UTILITY_PVT.debug_message('p_SDR_lines_tbl(i).end_date: ' || p_SDR_lines_tbl(i).end_date);
2024: END IF;
2025:
2026:
2027: IF p_SDR_lines_tbl(i).end_date < p_SDR_lines_tbl(i).start_date THEN

Line 2042: l_lookup_stat :=OZF_UTILITY_PVT.check_lookup_exists(

2038: p_SDR_lines_tbl(i).end_date := TRUNC(p_SDR_lines_tbl(i).end_date);
2039:
2040: --//Price Type
2041: IF p_SDR_lines_tbl(i).end_customer_price_type <> FND_API.g_miss_char AND p_SDR_lines_tbl(i).end_customer_price_type IS NOT NULL THEN
2042: l_lookup_stat :=OZF_UTILITY_PVT.check_lookup_exists(
2043: p_lookup_table_name =>'OZF_LOOKUPS'
2044: ,p_lookup_type =>'OZF_SD_PRICE_TYPE'
2045: ,p_lookup_code => p_SDR_lines_tbl(i).end_customer_price_type);
2046:

Line 2059: l_lookup_stat :=OZF_UTILITY_PVT.check_lookup_exists(

2055: END IF;
2056:
2057: --Tolerance Type
2058: IF p_SDR_lines_tbl(i).end_customer_tolerance_type <> FND_API.g_miss_char AND p_SDR_lines_tbl(i).end_customer_tolerance_type IS NOT NULL THEN
2059: l_lookup_stat :=OZF_UTILITY_PVT.check_lookup_exists(
2060: p_lookup_table_name =>'OZF_LOOKUPS'
2061: ,p_lookup_type =>'OZF_SD_TOLERANCE_TYPE'
2062: ,p_lookup_code => p_SDR_lines_tbl(i).end_customer_tolerance_type);
2063:

Line 2076: l_lookup_stat :=OZF_UTILITY_PVT.check_lookup_exists(

2072: END IF;
2073:
2074: --//Rejection Code
2075: IF p_SDR_lines_tbl(i).rejection_code <> FND_API.g_miss_char AND p_SDR_lines_tbl(i).rejection_code IS NOT NULL THEN
2076: l_lookup_stat :=OZF_UTILITY_PVT.check_lookup_exists(
2077: p_lookup_table_name =>'OZF_LOOKUPS'
2078: ,p_lookup_type =>'OZF_SD_REQ_LINE_REJECT_CODE'
2079: ,p_lookup_code => p_SDR_lines_tbl(i).rejection_code);
2080:

Line 2092: OZF_UTILITY_PVT.debug_message('Validate Product Lines Status Code :'||l_status_code);

2088: END IF;
2089: END IF;
2090: l_status_code := get_system_status_code(p_SDR_hdr_rec.user_status_id);
2091: IF G_DEBUG THEN
2092: OZF_UTILITY_PVT.debug_message('Validate Product Lines Status Code :'||l_status_code);
2093: END IF;
2094:
2095: --//Bugfix : 8511949
2096: --//Populate Approved discount type and Value in the following statuses. If value is not passed, default it from requested_discount_type and Value

Line 2103: OZF_UTILITY_PVT.debug_message('Validate Product Lines Status Code INSIDE');

2099: ,'SALES_APPROVED'
2100: ,'PENDING_OFFER_APPROVAL'
2101: ,'ACTIVE') THEN
2102: IF G_DEBUG THEN
2103: OZF_UTILITY_PVT.debug_message('Validate Product Lines Status Code INSIDE');
2104: END IF;
2105:
2106: --//Approved discount type
2107: IF p_SDR_lines_tbl(i).approved_discount_type <> FND_API.g_miss_char AND p_SDR_lines_tbl(i).approved_discount_type IS NOT NULL THEN

Line 2108: l_lookup_stat :=OZF_UTILITY_PVT.check_lookup_exists(

2104: END IF;
2105:
2106: --//Approved discount type
2107: IF p_SDR_lines_tbl(i).approved_discount_type <> FND_API.g_miss_char AND p_SDR_lines_tbl(i).approved_discount_type IS NOT NULL THEN
2108: l_lookup_stat :=OZF_UTILITY_PVT.check_lookup_exists(
2109: p_lookup_table_name =>'OZF_LOOKUPS'
2110: ,p_lookup_type =>'OZF_SP_REQUEST_DISTYPE'
2111: ,p_lookup_code => p_SDR_lines_tbl(i).approved_discount_type);
2112:

Line 2436: l_lookup_stat :=OZF_UTILITY_PVT.check_lookup_exists(

2432:
2433: --//Customer usage code Check
2434: IF p_SDR_cust_tbl(j).cust_usage_code <> FND_API.g_miss_char AND p_SDR_cust_tbl(j).cust_usage_code IS NOT NULL THEN
2435:
2436: l_lookup_stat :=OZF_UTILITY_PVT.check_lookup_exists(
2437: p_lookup_table_name =>'OZF_LOOKUPS'
2438: ,p_lookup_type =>'OZF_SD_CUSTOMER_TYPE'
2439: ,p_lookup_code => p_SDR_cust_tbl(j).cust_usage_code);
2440:

Line 2691: OZF_UTILITY_PVT.debug_message('Inside INSERT HEADER RECORD Procedure ');

2687:
2688: x_return_status := FND_API.G_RET_STS_SUCCESS;
2689:
2690: IF G_DEBUG THEN
2691: OZF_UTILITY_PVT.debug_message('Inside INSERT HEADER RECORD Procedure ');
2692: END IF;
2693:
2694: IF l_SDR_hdr_rec.request_basis IS NULL THEN
2695: l_SDR_hdr_rec.request_basis := FND_PROFILE.value('OZF_SD_REQUEST_BASED');

Line 2711: OZF_UTILITY_PVT.debug_message('Request Number : '||l_SDR_hdr_rec.request_number);

2707: CLOSE c_code_prefix;
2708:
2709: l_SDR_hdr_rec.request_number :=l_code_prefix||TO_CHAR(l_req_hdr_seq);
2710: IF G_DEBUG THEN
2711: OZF_UTILITY_PVT.debug_message('Request Number : '||l_SDR_hdr_rec.request_number);
2712: END IF;
2713:
2714: END IF;
2715:

Line 2720: OZF_UTILITY_PVT.debug_message('Root Request Header ID :'||l_root_request_header_id);

2716: IF l_SDR_hdr_rec.request_header_id IS NOT NULL THEN
2717: --//Set the root request header id for Copy
2718: l_root_request_header_id :=l_SDR_hdr_rec.request_header_id;
2719: IF G_DEBUG THEN
2720: OZF_UTILITY_PVT.debug_message('Root Request Header ID :'||l_root_request_header_id);
2721: END IF;
2722: END IF;
2723:
2724: OZF_SD_REQUEST_HEADER_PKG.Insert_Row(

Line 2937: OZF_UTILITY_PVT.debug_message('Count :'||p_SDR_lines_tbl.count);

2933: CLOSE c_reqest_lines_seq;
2934: END IF;
2935:
2936: --IF G_DEBUG THEN
2937: OZF_UTILITY_PVT.debug_message('Count :'||p_SDR_lines_tbl.count);
2938: OZF_UTILITY_PVT.debug_message('l_req_line_seq :'|| l_req_line_seq);
2939: OZF_UTILITY_PVT.debug_message('l_req_line_seq_id :'|| l_req_line_seq_id);
2940: -- END IF;
2941:

Line 2938: OZF_UTILITY_PVT.debug_message('l_req_line_seq :'|| l_req_line_seq);

2934: END IF;
2935:
2936: --IF G_DEBUG THEN
2937: OZF_UTILITY_PVT.debug_message('Count :'||p_SDR_lines_tbl.count);
2938: OZF_UTILITY_PVT.debug_message('l_req_line_seq :'|| l_req_line_seq);
2939: OZF_UTILITY_PVT.debug_message('l_req_line_seq_id :'|| l_req_line_seq_id);
2940: -- END IF;
2941:
2942:

Line 2939: OZF_UTILITY_PVT.debug_message('l_req_line_seq_id :'|| l_req_line_seq_id);

2935:
2936: --IF G_DEBUG THEN
2937: OZF_UTILITY_PVT.debug_message('Count :'||p_SDR_lines_tbl.count);
2938: OZF_UTILITY_PVT.debug_message('l_req_line_seq :'|| l_req_line_seq);
2939: OZF_UTILITY_PVT.debug_message('l_req_line_seq_id :'|| l_req_line_seq_id);
2940: -- END IF;
2941:
2942:
2943: IF l_req_line_seq <> -1 THEN

Line 2945: OZF_UTILITY_PVT.debug_message('populate_product_lines - Create Mode');

2941:
2942:
2943: IF l_req_line_seq <> -1 THEN
2944:
2945: OZF_UTILITY_PVT.debug_message('populate_product_lines - Create Mode');
2946:
2947: OZF_SD_REQUEST_LINES_PKG.Insert_Row(
2948: p_request_line_id =>l_req_line_seq
2949: ,p_object_version_number =>1

Line 3014: OZF_UTILITY_PVT.debug_message('populate_product_lines - Update Mode');

3010: ,p_approved_discount_currency =>p_SDR_lines_tbl(p).approved_discount_currency);
3011:
3012: ELSE --UPDATE MODE
3013:
3014: OZF_UTILITY_PVT.debug_message('populate_product_lines - Update Mode');
3015:
3016: OZF_SD_REQUEST_LINES_PKG.Update_Row(
3017: p_request_line_id =>p_SDR_lines_tbl(p).request_line_id
3018: ,p_object_version_number =>p_SDR_lines_tbl(p).object_version_number + 1

Line 3137: OZF_UTILITY_PVT.debug_message('Inside populate_customer_details');

3133: -- Initialize API return status to SUCCESS
3134: x_return_status := FND_API.G_RET_STS_SUCCESS;
3135:
3136: IF G_DEBUG THEN
3137: OZF_UTILITY_PVT.debug_message('Inside populate_customer_details');
3138: END IF;
3139:
3140: FOR c IN p_SDR_cust_tbl.FIRST..p_SDR_cust_tbl.LAST LOOP
3141:

Line 3158: OZF_UTILITY_PVT.debug_message('Duplicate Customer/End Customer ');

3154:
3155: IF l_cust_count <> 0 THEN
3156:
3157: IF G_DEBUG THEN
3158: OZF_UTILITY_PVT.debug_message('Duplicate Customer/End Customer ');
3159: OZF_UTILITY_PVT.debug_message('Cust Usage Code :'||p_SDR_cust_tbl(c).cust_usage_code);
3160: OZF_UTILITY_PVT.debug_message('Party Id :'||p_SDR_cust_tbl(c).party_id);
3161: OZF_UTILITY_PVT.debug_message('Cust Account id :'||p_SDR_cust_tbl(c).cust_account_id);
3162: OZF_UTILITY_PVT.debug_message('Site use id :'||p_SDR_cust_tbl(c).site_use_id);

Line 3159: OZF_UTILITY_PVT.debug_message('Cust Usage Code :'||p_SDR_cust_tbl(c).cust_usage_code);

3155: IF l_cust_count <> 0 THEN
3156:
3157: IF G_DEBUG THEN
3158: OZF_UTILITY_PVT.debug_message('Duplicate Customer/End Customer ');
3159: OZF_UTILITY_PVT.debug_message('Cust Usage Code :'||p_SDR_cust_tbl(c).cust_usage_code);
3160: OZF_UTILITY_PVT.debug_message('Party Id :'||p_SDR_cust_tbl(c).party_id);
3161: OZF_UTILITY_PVT.debug_message('Cust Account id :'||p_SDR_cust_tbl(c).cust_account_id);
3162: OZF_UTILITY_PVT.debug_message('Site use id :'||p_SDR_cust_tbl(c).site_use_id);
3163: OZF_UTILITY_PVT.debug_message('End Customer Flag :'||p_SDR_cust_tbl(c).end_customer_flag);

Line 3160: OZF_UTILITY_PVT.debug_message('Party Id :'||p_SDR_cust_tbl(c).party_id);

3156:
3157: IF G_DEBUG THEN
3158: OZF_UTILITY_PVT.debug_message('Duplicate Customer/End Customer ');
3159: OZF_UTILITY_PVT.debug_message('Cust Usage Code :'||p_SDR_cust_tbl(c).cust_usage_code);
3160: OZF_UTILITY_PVT.debug_message('Party Id :'||p_SDR_cust_tbl(c).party_id);
3161: OZF_UTILITY_PVT.debug_message('Cust Account id :'||p_SDR_cust_tbl(c).cust_account_id);
3162: OZF_UTILITY_PVT.debug_message('Site use id :'||p_SDR_cust_tbl(c).site_use_id);
3163: OZF_UTILITY_PVT.debug_message('End Customer Flag :'||p_SDR_cust_tbl(c).end_customer_flag);
3164: OZF_UTILITY_PVT.debug_message('Cust Usage Value :'||p_SDR_cust_tbl(c).cust_usage_value);

Line 3161: OZF_UTILITY_PVT.debug_message('Cust Account id :'||p_SDR_cust_tbl(c).cust_account_id);

3157: IF G_DEBUG THEN
3158: OZF_UTILITY_PVT.debug_message('Duplicate Customer/End Customer ');
3159: OZF_UTILITY_PVT.debug_message('Cust Usage Code :'||p_SDR_cust_tbl(c).cust_usage_code);
3160: OZF_UTILITY_PVT.debug_message('Party Id :'||p_SDR_cust_tbl(c).party_id);
3161: OZF_UTILITY_PVT.debug_message('Cust Account id :'||p_SDR_cust_tbl(c).cust_account_id);
3162: OZF_UTILITY_PVT.debug_message('Site use id :'||p_SDR_cust_tbl(c).site_use_id);
3163: OZF_UTILITY_PVT.debug_message('End Customer Flag :'||p_SDR_cust_tbl(c).end_customer_flag);
3164: OZF_UTILITY_PVT.debug_message('Cust Usage Value :'||p_SDR_cust_tbl(c).cust_usage_value);
3165: END IF;

Line 3162: OZF_UTILITY_PVT.debug_message('Site use id :'||p_SDR_cust_tbl(c).site_use_id);

3158: OZF_UTILITY_PVT.debug_message('Duplicate Customer/End Customer ');
3159: OZF_UTILITY_PVT.debug_message('Cust Usage Code :'||p_SDR_cust_tbl(c).cust_usage_code);
3160: OZF_UTILITY_PVT.debug_message('Party Id :'||p_SDR_cust_tbl(c).party_id);
3161: OZF_UTILITY_PVT.debug_message('Cust Account id :'||p_SDR_cust_tbl(c).cust_account_id);
3162: OZF_UTILITY_PVT.debug_message('Site use id :'||p_SDR_cust_tbl(c).site_use_id);
3163: OZF_UTILITY_PVT.debug_message('End Customer Flag :'||p_SDR_cust_tbl(c).end_customer_flag);
3164: OZF_UTILITY_PVT.debug_message('Cust Usage Value :'||p_SDR_cust_tbl(c).cust_usage_value);
3165: END IF;
3166:

Line 3163: OZF_UTILITY_PVT.debug_message('End Customer Flag :'||p_SDR_cust_tbl(c).end_customer_flag);

3159: OZF_UTILITY_PVT.debug_message('Cust Usage Code :'||p_SDR_cust_tbl(c).cust_usage_code);
3160: OZF_UTILITY_PVT.debug_message('Party Id :'||p_SDR_cust_tbl(c).party_id);
3161: OZF_UTILITY_PVT.debug_message('Cust Account id :'||p_SDR_cust_tbl(c).cust_account_id);
3162: OZF_UTILITY_PVT.debug_message('Site use id :'||p_SDR_cust_tbl(c).site_use_id);
3163: OZF_UTILITY_PVT.debug_message('End Customer Flag :'||p_SDR_cust_tbl(c).end_customer_flag);
3164: OZF_UTILITY_PVT.debug_message('Cust Usage Value :'||p_SDR_cust_tbl(c).cust_usage_value);
3165: END IF;
3166:
3167: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

Line 3164: OZF_UTILITY_PVT.debug_message('Cust Usage Value :'||p_SDR_cust_tbl(c).cust_usage_value);

3160: OZF_UTILITY_PVT.debug_message('Party Id :'||p_SDR_cust_tbl(c).party_id);
3161: OZF_UTILITY_PVT.debug_message('Cust Account id :'||p_SDR_cust_tbl(c).cust_account_id);
3162: OZF_UTILITY_PVT.debug_message('Site use id :'||p_SDR_cust_tbl(c).site_use_id);
3163: OZF_UTILITY_PVT.debug_message('End Customer Flag :'||p_SDR_cust_tbl(c).end_customer_flag);
3164: OZF_UTILITY_PVT.debug_message('Cust Usage Value :'||p_SDR_cust_tbl(c).cust_usage_value);
3165: END IF;
3166:
3167: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3168: IF p_SDR_cust_tbl(c).end_customer_flag = 'Y' THEN

Line 3307: OZF_UTILITY_PVT.debug_message('Invokes Update Row');

3303: x_return_status := FND_API.G_RET_STS_SUCCESS;
3304:
3305: --//Update process
3306: IF G_DEBUG THEN
3307: OZF_UTILITY_PVT.debug_message('Invokes Update Row');
3308: END IF;
3309:
3310: OPEN c_qp_list_header_id(p_SDR_hdr_rec.request_header_id);
3311: FETCH c_qp_list_header_id INTO l_qp_list_header_id;

Line 3389: OZF_UTILITY_PVT.debug_message('End update_header_record');

3385: ,p_request_basis =>p_SDR_hdr_rec.request_basis
3386: ,p_supplier_contact_name =>p_SDR_hdr_rec.supplier_contact_name); --//Bugfix : 7822442
3387:
3388: IF G_DEBUG THEN
3389: OZF_UTILITY_PVT.debug_message('End update_header_record');
3390: END IF;
3391:
3392: EXCEPTION
3393: WHEN FND_API.G_EXC_ERROR THEN

Line 3397: OZF_UTILITY_PVT.debug_message(SQLERRM);

3393: WHEN FND_API.G_EXC_ERROR THEN
3394: x_return_status := FND_API.G_RET_STS_ERROR;
3395: WHEN OTHERS THEN
3396: IF G_DEBUG THEN
3397: OZF_UTILITY_PVT.debug_message(SQLERRM);
3398: END IF;
3399: x_return_status := FND_API.g_ret_sts_unexp_error;
3400: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3401: FND_MESSAGE.set_name('OZF', 'OZF_TABLE_HANDLER_ERROR');

Line 3476: OZF_UTILITY_PVT.debug_message('Public API: ' || l_api_name || ' PUB start');

3472: FND_MSG_PUB.initialize;
3473: END IF;
3474: -- Debug Message
3475: IF G_DEBUG THEN
3476: OZF_UTILITY_PVT.debug_message('Public API: ' || l_api_name || ' PUB start');
3477: END IF;
3478: -- Initialize API return status to SUCCESS
3479: x_return_status := FND_API.G_RET_STS_SUCCESS;
3480:

Line 3488: l_lookup_check :=OZF_UTILITY_PVT.check_lookup_exists(

3484:
3485: --//Accrual type Validation
3486: IF l_SDR_rec.accrual_type <> FND_API.g_miss_char AND l_SDR_rec.accrual_type IS NOT NULL THEN
3487:
3488: l_lookup_check :=OZF_UTILITY_PVT.check_lookup_exists(
3489: p_lookup_table_name =>'OZF_LOOKUPS'
3490: ,p_lookup_type =>'OZF_SDR_ACCRUAL_TYPE'
3491: ,p_lookup_code => l_SDR_rec.accrual_type);
3492:

Line 3552: OZF_UTILITY_PVT.debug_message('User Status id '||l_SDR_rec.user_status_id);

3548: END IF;
3549: END IF;
3550:
3551: IF G_DEBUG THEN
3552: OZF_UTILITY_PVT.debug_message('User Status id '||l_SDR_rec.user_status_id);
3553: OZF_UTILITY_PVT.debug_message('l_system_status_code :'||l_system_status_code);
3554: END IF;
3555:
3556: IF (l_system_status_code <> 'DRAFT') AND (p_SDR_lines_tbl.count = 0) THEN

Line 3553: OZF_UTILITY_PVT.debug_message('l_system_status_code :'||l_system_status_code);

3549: END IF;
3550:
3551: IF G_DEBUG THEN
3552: OZF_UTILITY_PVT.debug_message('User Status id '||l_SDR_rec.user_status_id);
3553: OZF_UTILITY_PVT.debug_message('l_system_status_code :'||l_system_status_code);
3554: END IF;
3555:
3556: IF (l_system_status_code <> 'DRAFT') AND (p_SDR_lines_tbl.count = 0) THEN
3557: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

Line 3619: OZF_UTILITY_PVT.debug_message('Validate Header Record');

3615: RETURN;
3616: END IF;
3617:
3618: IF G_DEBUG THEN
3619: OZF_UTILITY_PVT.debug_message('Validate Header Record');
3620: END IF;
3621: --//Validate Header Record
3622: validate_header_items(p_SDR_hdr_rec => l_SDR_rec
3623: ,p_mode =>'CREATE'

Line 3634: OZF_UTILITY_PVT.debug_message('Validate Product Lines');

3630: END IF;
3631:
3632: --//Validate Product Lines
3633: IF G_DEBUG THEN
3634: OZF_UTILITY_PVT.debug_message('Validate Product Lines');
3635: END IF;
3636: IF p_SDR_lines_tbl.count > 0 THEN
3637: validate_product_lines(p_SDR_lines_tbl => l_SDR_lines_tbl
3638: ,p_SDR_hdr_rec => l_SDR_rec

Line 3651: OZF_UTILITY_PVT.debug_message('Validate Customer Records');

3647: l_line_rec_flag :='Y';
3648: END IF;
3649:
3650: IF G_DEBUG THEN
3651: OZF_UTILITY_PVT.debug_message('Validate Customer Records');
3652: END IF;
3653: --//Validate Customer Records
3654: IF ((p_SDR_cust_tbl.count > 0) AND (l_request_type = 'BID' ))THEN
3655: validate_customer_items(p_SDR_cust_tbl => l_SDR_cust_tbl

Line 3668: OZF_UTILITY_PVT.debug_message('Inserting data into SD Request Header table');

3664: l_cust_rec_flag :='Y';
3665: END IF;
3666:
3667: IF G_DEBUG THEN
3668: OZF_UTILITY_PVT.debug_message('Inserting data into SD Request Header table');
3669: END IF;
3670: --// Insert into Header Table
3671: Insert_header_record(
3672: p_SDR_hdr_rec => l_SDR_rec

Line 3684: OZF_UTILITY_PVT.debug_message('Populating Translation table');

3680: RAISE fnd_api.g_exc_error;
3681: END IF;
3682:
3683: IF G_DEBUG THEN
3684: OZF_UTILITY_PVT.debug_message('Populating Translation table');
3685: END IF;
3686: --//Populate Transilation table
3687: populate_translation_record(
3688: p_request_header_id =>x_request_header_id

Line 3701: OZF_UTILITY_PVT.debug_message('Populate SD Access table for Requestor');

3697: RAISE fnd_api.g_exc_error;
3698: END IF;
3699:
3700: IF G_DEBUG THEN
3701: OZF_UTILITY_PVT.debug_message('Populate SD Access table for Requestor');
3702: OZF_UTILITY_PVT.debug_message('p_resource_id =>'||l_SDR_rec.requestor_id);
3703: END IF;
3704: --Populate SD Access table
3705:

Line 3702: OZF_UTILITY_PVT.debug_message('p_resource_id =>'||l_SDR_rec.requestor_id);

3698: END IF;
3699:
3700: IF G_DEBUG THEN
3701: OZF_UTILITY_PVT.debug_message('Populate SD Access table for Requestor');
3702: OZF_UTILITY_PVT.debug_message('p_resource_id =>'||l_SDR_rec.requestor_id);
3703: END IF;
3704: --Populate SD Access table
3705:
3706: OZF_APPROVAL_PVT.Add_SD_Access(

Line 3731: OZF_UTILITY_PVT.debug_message('Populate SD Access table for Assignee');

3727: END IF;
3728:
3729: IF l_SDR_rec.assignee_resource_id IS NOT NULL THEN
3730: IF G_DEBUG THEN
3731: OZF_UTILITY_PVT.debug_message('Populate SD Access table for Assignee');
3732: OZF_UTILITY_PVT.debug_message('p_resource_id =>'||l_SDR_rec.assignee_resource_id);
3733: END IF;
3734: --//Assignee Entry
3735: OZF_APPROVAL_PVT.Add_SD_Access(

Line 3732: OZF_UTILITY_PVT.debug_message('p_resource_id =>'||l_SDR_rec.assignee_resource_id);

3728:
3729: IF l_SDR_rec.assignee_resource_id IS NOT NULL THEN
3730: IF G_DEBUG THEN
3731: OZF_UTILITY_PVT.debug_message('Populate SD Access table for Assignee');
3732: OZF_UTILITY_PVT.debug_message('p_resource_id =>'||l_SDR_rec.assignee_resource_id);
3733: END IF;
3734: --//Assignee Entry
3735: OZF_APPROVAL_PVT.Add_SD_Access(
3736: p_api_version =>p_api_version_number

Line 3762: OZF_UTILITY_PVT.debug_message('Populate Product Lines table');

3758:
3759:
3760: IF l_line_rec_flag ='Y' THEN
3761: IF G_DEBUG THEN
3762: OZF_UTILITY_PVT.debug_message('Populate Product Lines table');
3763: END IF;
3764: --//Populate Product Lines table
3765: populate_product_lines(
3766: p_request_header_id => x_request_header_id

Line 3780: OZF_UTILITY_PVT.debug_message('Populate Customer Details table');

3776:
3777: IF ((l_cust_rec_flag ='Y') AND (l_request_type = 'BID' ))THEN
3778:
3779: IF G_DEBUG THEN
3780: OZF_UTILITY_PVT.debug_message('Populate Customer Details table');
3781: END IF;
3782: --//Populate Customer Details table
3783: populate_customer_details(
3784: p_request_header_id => x_request_header_id

Line 3797: OZF_UTILITY_PVT.debug_message('Request Header Id: '||x_request_header_id);

3793: END IF;
3794: --========================================================================
3795: --// Commit the process
3796: IF G_DEBUG THEN
3797: OZF_UTILITY_PVT.debug_message('Request Header Id: '||x_request_header_id);
3798: OZF_UTILITY_PVT.debug_message('Public API: '|| l_api_name||' End');
3799: END IF;
3800: IF FND_API.to_Boolean( p_commit )
3801: THEN

Line 3798: OZF_UTILITY_PVT.debug_message('Public API: '|| l_api_name||' End');

3794: --========================================================================
3795: --// Commit the process
3796: IF G_DEBUG THEN
3797: OZF_UTILITY_PVT.debug_message('Request Header Id: '||x_request_header_id);
3798: OZF_UTILITY_PVT.debug_message('Public API: '|| l_api_name||' End');
3799: END IF;
3800: IF FND_API.to_Boolean( p_commit )
3801: THEN
3802: COMMIT WORK;

Line 4028: OZF_UTILITY_PVT.debug_message('Public API: ' || l_api_name || ' PUB start');

4024: FND_MSG_PUB.initialize;
4025: END IF;
4026: -- Debug Message
4027: IF G_DEBUG THEN
4028: OZF_UTILITY_PVT.debug_message('Public API: ' || l_api_name || ' PUB start');
4029: END IF;
4030: -- Initialize API return status to SUCCESS
4031: x_return_status := FND_API.G_RET_STS_SUCCESS;
4032: --==============================================================================

Line 4059: OZF_UTILITY_PVT.debug_message('G_REQUEST_HEADER_ID: ' ||G_REQUEST_HEADER_ID);

4055: END IF;
4056: --//Set the request Header ID to Global var
4057: G_REQUEST_HEADER_ID :=l_request_header_id;
4058: IF G_DEBUG THEN
4059: OZF_UTILITY_PVT.debug_message('G_REQUEST_HEADER_ID: ' ||G_REQUEST_HEADER_ID);
4060: END IF;
4061:
4062: --//Request Number Validation
4063: IF l_new_sdr_hdr_rec.request_number <> FND_API.g_miss_char AND l_new_sdr_hdr_rec.request_number IS NOT NULL THEN

Line 4144: OZF_UTILITY_PVT.debug_message('Validating User');

4140: FETCH c_old_sdr_tl INTO l_old_sdr_hdr_rec.request_description;
4141: CLOSE c_old_sdr_tl;
4142:
4143: IF G_DEBUG THEN
4144: OZF_UTILITY_PVT.debug_message('Validating User');
4145: END IF;
4146: --//User Check
4147: IF l_new_sdr_hdr_rec.user_id <> FND_API.g_miss_num AND l_new_sdr_hdr_rec.user_id IS NOT NULL THEN
4148: OPEN c_user(l_new_sdr_hdr_rec.user_id);

Line 4195: OZF_UTILITY_PVT.debug_message('SD Access Check');

4191: l_admin_flag :='Y';
4192: END IF;
4193:
4194: IF G_DEBUG THEN
4195: OZF_UTILITY_PVT.debug_message('SD Access Check');
4196: OZF_UTILITY_PVT.debug_message('Request Header ID :'||l_new_sdr_hdr_rec.request_header_id);
4197: OZF_UTILITY_PVT.debug_message('User id :'||l_new_sdr_hdr_rec.user_id);
4198: END IF;
4199: OPEN c_sd_access(l_new_sdr_hdr_rec.request_header_id

Line 4196: OZF_UTILITY_PVT.debug_message('Request Header ID :'||l_new_sdr_hdr_rec.request_header_id);

4192: END IF;
4193:
4194: IF G_DEBUG THEN
4195: OZF_UTILITY_PVT.debug_message('SD Access Check');
4196: OZF_UTILITY_PVT.debug_message('Request Header ID :'||l_new_sdr_hdr_rec.request_header_id);
4197: OZF_UTILITY_PVT.debug_message('User id :'||l_new_sdr_hdr_rec.user_id);
4198: END IF;
4199: OPEN c_sd_access(l_new_sdr_hdr_rec.request_header_id
4200: ,l_new_sdr_hdr_rec.user_id);

Line 4197: OZF_UTILITY_PVT.debug_message('User id :'||l_new_sdr_hdr_rec.user_id);

4193:
4194: IF G_DEBUG THEN
4195: OZF_UTILITY_PVT.debug_message('SD Access Check');
4196: OZF_UTILITY_PVT.debug_message('Request Header ID :'||l_new_sdr_hdr_rec.request_header_id);
4197: OZF_UTILITY_PVT.debug_message('User id :'||l_new_sdr_hdr_rec.user_id);
4198: END IF;
4199: OPEN c_sd_access(l_new_sdr_hdr_rec.request_header_id
4200: ,l_new_sdr_hdr_rec.user_id);
4201:

Line 4210: OZF_UTILITY_PVT.debug_message('Owner Flag :'||l_owner_flag);

4206: l_approver_flag :='Y';
4207: END IF;
4208:
4209: IF G_DEBUG THEN
4210: OZF_UTILITY_PVT.debug_message('Owner Flag :'||l_owner_flag);
4211: OZF_UTILITY_PVT.debug_message('Approver Flag :'||l_approver_flag);
4212: OZF_UTILITY_PVT.debug_message('Admin Flag :'||l_admin_flag);
4213: END IF;
4214:

Line 4211: OZF_UTILITY_PVT.debug_message('Approver Flag :'||l_approver_flag);

4207: END IF;
4208:
4209: IF G_DEBUG THEN
4210: OZF_UTILITY_PVT.debug_message('Owner Flag :'||l_owner_flag);
4211: OZF_UTILITY_PVT.debug_message('Approver Flag :'||l_approver_flag);
4212: OZF_UTILITY_PVT.debug_message('Admin Flag :'||l_admin_flag);
4213: END IF;
4214:
4215: --//Access Permission check

Line 4212: OZF_UTILITY_PVT.debug_message('Admin Flag :'||l_admin_flag);

4208:
4209: IF G_DEBUG THEN
4210: OZF_UTILITY_PVT.debug_message('Owner Flag :'||l_owner_flag);
4211: OZF_UTILITY_PVT.debug_message('Approver Flag :'||l_approver_flag);
4212: OZF_UTILITY_PVT.debug_message('Admin Flag :'||l_admin_flag);
4213: END IF;
4214:
4215: --//Access Permission check
4216: IF ((l_owner_flag IS NULL)

Line 4239: OZF_UTILITY_PVT.debug_message('Internal Flag :'||l_internal_flag);

4235: l_external_flag := 'Y';
4236: END IF;
4237:
4238: IF G_DEBUG THEN
4239: OZF_UTILITY_PVT.debug_message('Internal Flag :'||l_internal_flag);
4240: OZF_UTILITY_PVT.debug_message('External Flag :'||l_external_flag);
4241:
4242: END IF;
4243:

Line 4240: OZF_UTILITY_PVT.debug_message('External Flag :'||l_external_flag);

4236: END IF;
4237:
4238: IF G_DEBUG THEN
4239: OZF_UTILITY_PVT.debug_message('Internal Flag :'||l_internal_flag);
4240: OZF_UTILITY_PVT.debug_message('External Flag :'||l_external_flag);
4241:
4242: END IF;
4243:
4244: l_old_user_status_id :=NVL(l_old_sdr_hdr_rec.user_status_id,0);

Line 4257: OZF_UTILITY_PVT.debug_message('Checking the Status transition ');

4253: l_new_status_code := l_old_status_code;
4254: END IF;
4255:
4256: IF G_DEBUG THEN
4257: OZF_UTILITY_PVT.debug_message('Checking the Status transition ');
4258: OZF_UTILITY_PVT.debug_message('Old Status Code :'||l_old_status_code);
4259: OZF_UTILITY_PVT.debug_message('New Status Code :'||l_new_status_code);
4260: OZF_UTILITY_PVT.debug_message('Old Status Id :'||l_old_user_status_id);
4261: OZF_UTILITY_PVT.debug_message('New Status Id :'||l_new_user_status_id);

Line 4258: OZF_UTILITY_PVT.debug_message('Old Status Code :'||l_old_status_code);

4254: END IF;
4255:
4256: IF G_DEBUG THEN
4257: OZF_UTILITY_PVT.debug_message('Checking the Status transition ');
4258: OZF_UTILITY_PVT.debug_message('Old Status Code :'||l_old_status_code);
4259: OZF_UTILITY_PVT.debug_message('New Status Code :'||l_new_status_code);
4260: OZF_UTILITY_PVT.debug_message('Old Status Id :'||l_old_user_status_id);
4261: OZF_UTILITY_PVT.debug_message('New Status Id :'||l_new_user_status_id);
4262: END IF;

Line 4259: OZF_UTILITY_PVT.debug_message('New Status Code :'||l_new_status_code);

4255:
4256: IF G_DEBUG THEN
4257: OZF_UTILITY_PVT.debug_message('Checking the Status transition ');
4258: OZF_UTILITY_PVT.debug_message('Old Status Code :'||l_old_status_code);
4259: OZF_UTILITY_PVT.debug_message('New Status Code :'||l_new_status_code);
4260: OZF_UTILITY_PVT.debug_message('Old Status Id :'||l_old_user_status_id);
4261: OZF_UTILITY_PVT.debug_message('New Status Id :'||l_new_user_status_id);
4262: END IF;
4263:

Line 4260: OZF_UTILITY_PVT.debug_message('Old Status Id :'||l_old_user_status_id);

4256: IF G_DEBUG THEN
4257: OZF_UTILITY_PVT.debug_message('Checking the Status transition ');
4258: OZF_UTILITY_PVT.debug_message('Old Status Code :'||l_old_status_code);
4259: OZF_UTILITY_PVT.debug_message('New Status Code :'||l_new_status_code);
4260: OZF_UTILITY_PVT.debug_message('Old Status Id :'||l_old_user_status_id);
4261: OZF_UTILITY_PVT.debug_message('New Status Id :'||l_new_user_status_id);
4262: END IF;
4263:
4264: --//Update is not allowed in the following statuses

Line 4261: OZF_UTILITY_PVT.debug_message('New Status Id :'||l_new_user_status_id);

4257: OZF_UTILITY_PVT.debug_message('Checking the Status transition ');
4258: OZF_UTILITY_PVT.debug_message('Old Status Code :'||l_old_status_code);
4259: OZF_UTILITY_PVT.debug_message('New Status Code :'||l_new_status_code);
4260: OZF_UTILITY_PVT.debug_message('Old Status Id :'||l_old_user_status_id);
4261: OZF_UTILITY_PVT.debug_message('New Status Id :'||l_new_user_status_id);
4262: END IF;
4263:
4264: --//Update is not allowed in the following statuses
4265: IF l_old_status_code IN ('CLOSED','CANCELLED') THEN

Line 4326: OZF_UTILITY_PVT.debug_message('l_old_status_code :'||l_old_status_code);

4322: (l_new_sdr_hdr_rec.supplier_contact_phone_number,l_old_sdr_hdr_rec.supplier_contact_phone_number);
4323: END IF;
4324:
4325: IF G_DEBUG THEN
4326: OZF_UTILITY_PVT.debug_message('l_old_status_code :'||l_old_status_code);
4327: END IF;
4328:
4329: --//Statuswise transitions
4330: IF l_old_status_code ='DRAFT' THEN

Line 4412: OZF_UTILITY_PVT.debug_message('l_new_sdr_hdr_rec.request_number '||l_new_sdr_hdr_rec.request_number);

4408: l_old_sdr_hdr_rec.request_description :=NVL(l_new_sdr_hdr_rec.request_description,l_old_sdr_hdr_rec.request_description);
4409: END IF;
4410:
4411: IF (l_approver_flag ='Y') OR (l_admin_flag='Y') THEN
4412: OZF_UTILITY_PVT.debug_message('l_new_sdr_hdr_rec.request_number '||l_new_sdr_hdr_rec.request_number);
4413:
4414: l_old_sdr_hdr_rec.request_number :=NVL(l_new_sdr_hdr_rec.request_number,l_old_sdr_hdr_rec.request_number);
4415: l_old_sdr_hdr_rec.org_id :=NVL(l_new_sdr_hdr_rec.org_id,l_old_sdr_hdr_rec.org_id);
4416: l_old_sdr_hdr_rec.supplier_id :=NVL(l_new_sdr_hdr_rec.supplier_id,l_old_sdr_hdr_rec.supplier_id);

Line 4554: OZF_UTILITY_PVT.debug_message('End of Statuswise Data set');

4550: END IF;
4551: END IF;
4552:
4553: IF G_DEBUG THEN
4554: OZF_UTILITY_PVT.debug_message('End of Statuswise Data set');
4555: END IF;
4556: --//Set the user Id
4557: l_old_sdr_hdr_rec.user_id := l_new_sdr_hdr_rec.user_id;
4558:

Line 4562: OZF_UTILITY_PVT.debug_message('Admin Actions ');

4558:
4559: --//Admin Actions
4560: IF l_admin_flag ='Y' THEN
4561: IF G_DEBUG THEN
4562: OZF_UTILITY_PVT.debug_message('Admin Actions ');
4563: END IF;
4564:
4565: IF (l_new_sdr_hdr_rec.requestor_id IS NOT NULL)
4566: AND (NVL(l_old_sdr_hdr_rec.requestor_id,0) <> NVL(l_new_sdr_hdr_rec.requestor_id,0)) THEN

Line 4569: OZF_UTILITY_PVT.debug_message('Admin is updating the Owner ');

4565: IF (l_new_sdr_hdr_rec.requestor_id IS NOT NULL)
4566: AND (NVL(l_old_sdr_hdr_rec.requestor_id,0) <> NVL(l_new_sdr_hdr_rec.requestor_id,0)) THEN
4567: --//Admin is updating the Owner
4568: IF G_DEBUG THEN
4569: OZF_UTILITY_PVT.debug_message('Admin is updating the Owner ');
4570: END IF;
4571:
4572: OZF_APPROVAL_PVT.Add_SD_Access(
4573: p_api_version =>p_api_version_number

Line 4601: OZF_UTILITY_PVT.debug_message('Admin is updating the Assignee ');

4597: IF ((l_new_sdr_hdr_rec.assignee_resource_id IS NOT NULL)
4598: AND NVL(l_old_sdr_hdr_rec.assignee_resource_id,0) <> NVL(l_new_sdr_hdr_rec.assignee_resource_id,0)) THEN
4599: --//Admin is updating the Assignee
4600: IF g_debug THEN
4601: OZF_UTILITY_PVT.debug_message('Admin is updating the Assignee ');
4602: END IF;
4603:
4604: OZF_APPROVAL_PVT.Add_SD_Access(
4605: p_api_version =>p_api_version_number

Line 4634: OZF_UTILITY_PVT.debug_message('Validate Header Records');

4630: l_old_sdr_hdr_rec.assignee_resource_id :=NVL(l_new_sdr_hdr_rec.assignee_resource_id,l_old_sdr_hdr_rec.assignee_resource_id);
4631: END IF;
4632:
4633: IF G_DEBUG THEN
4634: OZF_UTILITY_PVT.debug_message('Validate Header Records');
4635: END IF;
4636: --//Validate Header Record
4637: validate_header_items(p_SDR_hdr_rec => l_old_sdr_hdr_rec
4638: ,p_mode =>'UPDATE'

Line 4649: OZF_UTILITY_PVT.debug_message('Proc Lines and Customer details Validation');

4645: END IF;
4646:
4647: --//Proc Lines and Customer details Validation
4648: IF G_DEBUG THEN
4649: OZF_UTILITY_PVT.debug_message('Proc Lines and Customer details Validation');
4650: END IF;
4651:
4652: IF l_old_status_code ='DRAFT' AND (l_owner_flag ='Y' OR l_admin_flag ='Y') THEN
4653: IF G_DEBUG THEN

Line 4654: OZF_UTILITY_PVT.debug_message('Owner can update Product Lines and Customer Details');

4650: END IF;
4651:
4652: IF l_old_status_code ='DRAFT' AND (l_owner_flag ='Y' OR l_admin_flag ='Y') THEN
4653: IF G_DEBUG THEN
4654: OZF_UTILITY_PVT.debug_message('Owner can update Product Lines and Customer Details');
4655: END IF;
4656: --//Owner can update Product Lines and Customer Details
4657: l_line_update_flag := 'Y';
4658: l_cust_update_flag := 'Y';

Line 4661: OZF_UTILITY_PVT.debug_message('PM Can update Product Lines and Customer Details');

4657: l_line_update_flag := 'Y';
4658: l_cust_update_flag := 'Y';
4659: ELSIF l_old_status_code <>'DRAFT' AND (l_approver_flag ='Y' OR l_admin_flag ='Y') THEN
4660: IF G_DEBUG THEN
4661: OZF_UTILITY_PVT.debug_message('PM Can update Product Lines and Customer Details');
4662: END IF;
4663: --//PM Can update Product Lines and Customer Details
4664: l_line_update_flag := 'Y';
4665: l_cust_update_flag := 'Y';

Line 4672: OZF_UTILITY_PVT.debug_message('Validate Product Line Records');

4668: --//Validate Product Line Records
4669: IF l_line_update_flag ='Y' THEN
4670:
4671: IF G_DEBUG THEN
4672: OZF_UTILITY_PVT.debug_message('Validate Product Line Records');
4673: END IF;
4674:
4675: IF l_new_sdr_lines_tbl.count > 0 THEN
4676:

Line 4694: OZF_UTILITY_PVT.debug_message('Validate Customer Records');

4690:
4691: --//Validate Customer Records
4692: IF l_cust_update_flag = 'Y' THEN
4693: IF G_DEBUG THEN
4694: OZF_UTILITY_PVT.debug_message('Validate Customer Records');
4695: END IF;
4696:
4697: IF l_new_sdr_cust_tbl.count > 0 THEN
4698:

Line 4716: OZF_UTILITY_PVT.debug_message('update_header_record');

4712:
4713: --//UPDATE PROCESS
4714: --//Update Header Records
4715: IF G_DEBUG THEN
4716: OZF_UTILITY_PVT.debug_message('update_header_record');
4717: END IF;
4718:
4719: update_header_record(
4720: p_SDR_hdr_rec =>l_old_sdr_hdr_rec

Line 4730: OZF_UTILITY_PVT.debug_message('populate_translation_record');

4726: RAISE fnd_api.g_exc_error;
4727: END IF;
4728:
4729: IF G_DEBUG THEN
4730: OZF_UTILITY_PVT.debug_message('populate_translation_record');
4731: END IF;
4732: --//Update TL record
4733: populate_translation_record(
4734: p_request_header_id =>l_old_sdr_hdr_rec.request_header_id

Line 4778: OZF_UTILITY_PVT.debug_message('Update Lines Record');

4774: --//Update Lines Record
4775: IF l_line_rec_flag ='Y' THEN
4776:
4777: IF G_DEBUG THEN
4778: OZF_UTILITY_PVT.debug_message('Update Lines Record');
4779: END IF;
4780: populate_product_lines(
4781: p_request_header_id => l_new_sdr_hdr_rec.request_header_id
4782: ,p_SDR_lines_tbl => l_new_sdr_lines_tbl

Line 4795: OZF_UTILITY_PVT.debug_message('Populate Customer Details table');

4791:
4792: --//Update Customer Record
4793: IF l_cust_rec_flag ='Y' THEN
4794: IF G_DEBUG THEN
4795: OZF_UTILITY_PVT.debug_message('Populate Customer Details table');
4796: END IF;
4797: populate_customer_details(
4798: p_request_header_id => l_new_sdr_hdr_rec.request_header_id
4799: ,p_SDR_cust_tbl => l_new_sdr_cust_tbl

Line 4812: OZF_UTILITY_PVT.debug_message('Request Header id from update_header_record :'||p_SDR_hdr_rec.request_header_id);

4808:
4809: --//Invoking Offer API Process
4810: --//Moved the code from update_header_record Procedure - Bugfix : 7501052
4811: IF G_DEBUG THEN
4812: OZF_UTILITY_PVT.debug_message('Request Header id from update_header_record :'||p_SDR_hdr_rec.request_header_id);
4813: END IF;
4814:
4815: IF l_new_status_code IN ('PENDING_OFFER_APPROVAL','ACTIVE') OR
4816: l_old_status_code ='ACTIVE' OR

Line 4824: OZF_UTILITY_PVT.debug_message('l_qp_list_header_id:'||l_qp_list_header_id);

4820: FETCH c_qp_list_header_id INTO l_qp_list_header_id;
4821: CLOSE c_qp_list_header_id;
4822:
4823: IF G_DEBUG THEN
4824: OZF_UTILITY_PVT.debug_message('l_qp_list_header_id:'||l_qp_list_header_id);
4825: OZF_UTILITY_PVT.debug_message('l_new_status_code :'||l_new_status_code);
4826: OZF_UTILITY_PVT.debug_message('IG_OLD_STATUS_CODE:'||l_old_status_code);
4827: OZF_UTILITY_PVT.debug_message('Invoking OZF_OFFER_PVT.process_sd_modifiers :'||p_SDR_hdr_rec.request_header_id);
4828: END IF;

Line 4825: OZF_UTILITY_PVT.debug_message('l_new_status_code :'||l_new_status_code);

4821: CLOSE c_qp_list_header_id;
4822:
4823: IF G_DEBUG THEN
4824: OZF_UTILITY_PVT.debug_message('l_qp_list_header_id:'||l_qp_list_header_id);
4825: OZF_UTILITY_PVT.debug_message('l_new_status_code :'||l_new_status_code);
4826: OZF_UTILITY_PVT.debug_message('IG_OLD_STATUS_CODE:'||l_old_status_code);
4827: OZF_UTILITY_PVT.debug_message('Invoking OZF_OFFER_PVT.process_sd_modifiers :'||p_SDR_hdr_rec.request_header_id);
4828: END IF;
4829:

Line 4826: OZF_UTILITY_PVT.debug_message('IG_OLD_STATUS_CODE:'||l_old_status_code);

4822:
4823: IF G_DEBUG THEN
4824: OZF_UTILITY_PVT.debug_message('l_qp_list_header_id:'||l_qp_list_header_id);
4825: OZF_UTILITY_PVT.debug_message('l_new_status_code :'||l_new_status_code);
4826: OZF_UTILITY_PVT.debug_message('IG_OLD_STATUS_CODE:'||l_old_status_code);
4827: OZF_UTILITY_PVT.debug_message('Invoking OZF_OFFER_PVT.process_sd_modifiers :'||p_SDR_hdr_rec.request_header_id);
4828: END IF;
4829:
4830: OZF_OFFER_PVT.process_sd_modifiers(

Line 4827: OZF_UTILITY_PVT.debug_message('Invoking OZF_OFFER_PVT.process_sd_modifiers :'||p_SDR_hdr_rec.request_header_id);

4823: IF G_DEBUG THEN
4824: OZF_UTILITY_PVT.debug_message('l_qp_list_header_id:'||l_qp_list_header_id);
4825: OZF_UTILITY_PVT.debug_message('l_new_status_code :'||l_new_status_code);
4826: OZF_UTILITY_PVT.debug_message('IG_OLD_STATUS_CODE:'||l_old_status_code);
4827: OZF_UTILITY_PVT.debug_message('Invoking OZF_OFFER_PVT.process_sd_modifiers :'||p_SDR_hdr_rec.request_header_id);
4828: END IF;
4829:
4830: OZF_OFFER_PVT.process_sd_modifiers(
4831: p_sdr_header_id => p_SDR_hdr_rec.request_header_id

Line 4842: OZF_UTILITY_PVT.debug_message('l_qp_list_header_id(Offer Id) :'||l_qp_list_header_id);

4838: ,x_qp_list_header_id => l_qp_list_header_id
4839: ,x_error_location => l_error_location);
4840:
4841: IF G_DEBUG THEN
4842: OZF_UTILITY_PVT.debug_message('l_qp_list_header_id(Offer Id) :'||l_qp_list_header_id);
4843: OZF_UTILITY_PVT.debug_message('Invoking OZF_OFFER_PVT.process_sd_modifiers'||l_error_location);
4844: END IF;
4845:
4846: IF l_new_status_code ='PENDING_OFFER_APPROVAL' THEN

Line 4843: OZF_UTILITY_PVT.debug_message('Invoking OZF_OFFER_PVT.process_sd_modifiers'||l_error_location);

4839: ,x_error_location => l_error_location);
4840:
4841: IF G_DEBUG THEN
4842: OZF_UTILITY_PVT.debug_message('l_qp_list_header_id(Offer Id) :'||l_qp_list_header_id);
4843: OZF_UTILITY_PVT.debug_message('Invoking OZF_OFFER_PVT.process_sd_modifiers'||l_error_location);
4844: END IF;
4845:
4846: IF l_new_status_code ='PENDING_OFFER_APPROVAL' THEN
4847: --//Updating SD Request Header table with offer information

Line 4864: OZF_UTILITY_PVT.debug_message('Public API: ' || l_api_name || ' End');

4860:
4861:
4862: --// Commit the process
4863: IF G_DEBUG THEN
4864: OZF_UTILITY_PVT.debug_message('Public API: ' || l_api_name || ' End');
4865: END IF;
4866: IF FND_API.to_Boolean( p_commit )
4867: THEN
4868: COMMIT WORK;

Line 4876: OZF_UTILITY_PVT.debug_message('Raises business event');

4872: --//1.Status Change Business Event
4873:
4874: IF l_old_user_status_id <> l_new_user_status_id THEN
4875: IF G_DEBUG THEN
4876: OZF_UTILITY_PVT.debug_message('Raises business event');
4877: END IF;
4878: --//Get the user status names
4879: OPEN c_user_status_name(l_old_user_status_id);
4880: FETCH c_user_status_name INTO l_old_user_stat_name;

Line 4910: OZF_UTILITY_PVT.debug_message('Raises a XML Gateway business event');

4906: AND (l_new_status_code='PENDING_SUPPLIER_APPROVAL')
4907: AND (l_request_communication ='XML') THEN
4908:
4909: IF G_DEBUG THEN
4910: OZF_UTILITY_PVT.debug_message('Raises a XML Gateway business event');
4911: END IF;
4912: raise_XML_business_event(
4913: p_request_header_id => l_new_sdr_hdr_rec.request_header_id
4914: ,p_supplier_id => l_old_sdr_hdr_rec.supplier_id

Line 5192: OZF_UTILITY_PVT.debug_message('Public API: ' || l_api_name || ' pub start');

5188: FND_MSG_PUB.initialize;
5189: END IF;
5190: -- Debug Message
5191: IF G_DEBUG THEN
5192: OZF_UTILITY_PVT.debug_message('Public API: ' || l_api_name || ' pub start');
5193: END IF;
5194: -- Initialize API return status to SUCCESS
5195: x_return_status := FND_API.G_RET_STS_SUCCESS;
5196: --==============================================================================

Line 5202: OZF_UTILITY_PVT.debug_message('l_user_id: ' ||l_user_id);

5198:
5199: l_user_id := FND_GLOBAL.user_id;
5200:
5201: IF G_DEBUG THEN
5202: OZF_UTILITY_PVT.debug_message('l_user_id: ' ||l_user_id);
5203: END IF;
5204: --//Check if user is a valid resource or not
5205: OPEN c_resource_id(l_user_id);
5206: FETCH c_resource_id INTO l_resource_id;

Line 5219: OZF_UTILITY_PVT.debug_message('l_resource_id: ' ||l_resource_id);

5215: RETURN;
5216: END IF;
5217:
5218: IF G_DEBUG THEN
5219: OZF_UTILITY_PVT.debug_message('l_resource_id: ' ||l_resource_id);
5220: END IF;
5221:
5222:
5223: --//Check If Source Request Id is valid

Line 5266: l_lookup_stat :=OZF_UTILITY_PVT.check_lookup_exists(

5262: END IF;
5263: END IF;
5264: --//Accrual type Check
5265: IF p_accrual_type IS NOT NULL THEN
5266: l_lookup_stat :=OZF_UTILITY_PVT.check_lookup_exists(
5267: p_lookup_table_name =>'OZF_LOOKUPS'
5268: ,p_lookup_type =>'OZF_SDR_ACCRUAL_TYPE'
5269: ,p_lookup_code => p_accrual_type);
5270:

Line 5431: OZF_UTILITY_PVT.debug_message('Copy Option ');

5427: RETURN;
5428: END IF;
5429:
5430: IF G_DEBUG THEN
5431: OZF_UTILITY_PVT.debug_message('Copy Option ');
5432: OZF_UTILITY_PVT.debug_message('Source accrual_type :'||l_sdr_source_rec.accrual_type);
5433: OZF_UTILITY_PVT.debug_message('New accrual_type :'|| p_accrual_type);
5434: END IF;
5435:

Line 5432: OZF_UTILITY_PVT.debug_message('Source accrual_type :'||l_sdr_source_rec.accrual_type);

5428: END IF;
5429:
5430: IF G_DEBUG THEN
5431: OZF_UTILITY_PVT.debug_message('Copy Option ');
5432: OZF_UTILITY_PVT.debug_message('Source accrual_type :'||l_sdr_source_rec.accrual_type);
5433: OZF_UTILITY_PVT.debug_message('New accrual_type :'|| p_accrual_type);
5434: END IF;
5435:
5436: IF (l_sdr_source_rec.accrual_type ='INTERNAL') AND (p_accrual_type ='SUPPLIER') THEN

Line 5433: OZF_UTILITY_PVT.debug_message('New accrual_type :'|| p_accrual_type);

5429:
5430: IF G_DEBUG THEN
5431: OZF_UTILITY_PVT.debug_message('Copy Option ');
5432: OZF_UTILITY_PVT.debug_message('Source accrual_type :'||l_sdr_source_rec.accrual_type);
5433: OZF_UTILITY_PVT.debug_message('New accrual_type :'|| p_accrual_type);
5434: END IF;
5435:
5436: IF (l_sdr_source_rec.accrual_type ='INTERNAL') AND (p_accrual_type ='SUPPLIER') THEN
5437: --Invalid Copy Option

Line 5472: OZF_UTILITY_PVT.debug_message('Populate Header table');

5468: --//Get the User status ID
5469: l_sdr_source_rec.user_status_id :=get_user_status_id('DRAFT');
5470:
5471: IF G_DEBUG THEN
5472: OZF_UTILITY_PVT.debug_message('Populate Header table');
5473: END IF;
5474: --//Populate Header table
5475: Insert_header_record(
5476: p_SDR_hdr_rec => l_sdr_source_rec

Line 5493: OZF_UTILITY_PVT.debug_message('Populate Translation table');

5489: FETCH c_tl_description INTO l_sdr_source_rec.request_description;
5490: CLOSE c_tl_description;
5491:
5492: IF G_DEBUG THEN
5493: OZF_UTILITY_PVT.debug_message('Populate Translation table');
5494: END IF;
5495: populate_translation_record(
5496: p_request_header_id =>x_request_header_id
5497: ,p_description =>l_sdr_source_rec.request_description

Line 5503: OZF_UTILITY_PVT.debug_message('x_request_header_id '||x_request_header_id);

5499: ,p_mode =>'COPY'
5500: ,x_return_status => x_return_status);
5501:
5502: IF G_DEBUG THEN
5503: OZF_UTILITY_PVT.debug_message('x_request_header_id '||x_request_header_id);
5504: END IF;
5505:
5506: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
5507: RAISE fnd_api.g_exc_unexpected_error;

Line 5539: OZF_UTILITY_PVT.debug_message('Copy Product Lines');

5535: END IF;
5536:
5537:
5538: IF G_DEBUG THEN
5539: OZF_UTILITY_PVT.debug_message('Copy Product Lines');
5540: END IF;
5541: --//Copy Product Lines
5542: IF ((p_copy_product_flag ='Y') AND (l_product_exists ='Y'))THEN
5543: OPEN c_source_sd_lines(p_source_request_id);

Line 5547: OZF_UTILITY_PVT.debug_message('Inside Loop :'||l_product_count);

5543: OPEN c_source_sd_lines(p_source_request_id);
5544: LOOP
5545: l_product_count := l_product_count + 1;
5546: IF G_DEBUG THEN
5547: OZF_UTILITY_PVT.debug_message('Inside Loop :'||l_product_count);
5548: END IF;
5549:
5550: FETCH c_source_sd_lines INTO
5551: l_sdr_source_lines_tbl(l_product_count).product_context,

Line 5653: OZF_UTILITY_PVT.debug_message('populate_customer_details');

5649: END LOOP;
5650: CLOSE c_source_customer_dtl;
5651: --//Populate Customer Details table
5652: IF G_DEBUG THEN
5653: OZF_UTILITY_PVT.debug_message('populate_customer_details');
5654: END IF;
5655: populate_customer_details(
5656: p_request_header_id => x_request_header_id
5657: ,p_SDR_cust_tbl => l_sdr_source_cust_tbl

Line 5716: OZF_UTILITY_PVT.debug_message('New request_header_id :'||x_request_header_id );

5712: END IF;
5713:
5714: -- Commit the process
5715: IF G_DEBUG THEN
5716: OZF_UTILITY_PVT.debug_message('New request_header_id :'||x_request_header_id );
5717: OZF_UTILITY_PVT.debug_message('Return Status :'|| x_return_status );
5718: OZF_UTILITY_PVT.debug_message('Public API: ' || l_api_name || ' End..');
5719: END IF;
5720: IF FND_API.to_Boolean( p_commit )

Line 5717: OZF_UTILITY_PVT.debug_message('Return Status :'|| x_return_status );

5713:
5714: -- Commit the process
5715: IF G_DEBUG THEN
5716: OZF_UTILITY_PVT.debug_message('New request_header_id :'||x_request_header_id );
5717: OZF_UTILITY_PVT.debug_message('Return Status :'|| x_return_status );
5718: OZF_UTILITY_PVT.debug_message('Public API: ' || l_api_name || ' End..');
5719: END IF;
5720: IF FND_API.to_Boolean( p_commit )
5721: THEN

Line 5718: OZF_UTILITY_PVT.debug_message('Public API: ' || l_api_name || ' End..');

5714: -- Commit the process
5715: IF G_DEBUG THEN
5716: OZF_UTILITY_PVT.debug_message('New request_header_id :'||x_request_header_id );
5717: OZF_UTILITY_PVT.debug_message('Return Status :'|| x_return_status );
5718: OZF_UTILITY_PVT.debug_message('Public API: ' || l_api_name || ' End..');
5719: END IF;
5720: IF FND_API.to_Boolean( p_commit )
5721: THEN
5722: COMMIT WORK;