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

Line 59: OZF_UTILITY_PVT.debug_message(l_api_name||': Start');

55: l_org_id NUMBER;
56: BEGIN
57: x_return_status := FND_API.G_RET_STS_SUCCESS;
58: IF OZF_DEBUG_HIGH_ON THEN
59: OZF_UTILITY_PVT.debug_message(l_api_name||': Start');
60: END IF;
61: IF OZF_DEBUG_LOW_ON THEN
62: OZF_UTILITY_PVT.debug_message('id_value:'||p_id_value );
63: OZF_UTILITY_PVT.debug_message('id_type:'||p_id_type );

Line 62: OZF_UTILITY_PVT.debug_message('id_value:'||p_id_value );

58: IF OZF_DEBUG_HIGH_ON THEN
59: OZF_UTILITY_PVT.debug_message(l_api_name||': Start');
60: END IF;
61: IF OZF_DEBUG_LOW_ON THEN
62: OZF_UTILITY_PVT.debug_message('id_value:'||p_id_value );
63: OZF_UTILITY_PVT.debug_message('id_type:'||p_id_type );
64: OZF_UTILITY_PVT.debug_message('error_code:'||p_error_code);
65: IF p_error_message is NOT NULL THEN
66: OZF_UTILITY_PVT.debug_message('error_message:'||p_error_message);

Line 63: OZF_UTILITY_PVT.debug_message('id_type:'||p_id_type );

59: OZF_UTILITY_PVT.debug_message(l_api_name||': Start');
60: END IF;
61: IF OZF_DEBUG_LOW_ON THEN
62: OZF_UTILITY_PVT.debug_message('id_value:'||p_id_value );
63: OZF_UTILITY_PVT.debug_message('id_type:'||p_id_type );
64: OZF_UTILITY_PVT.debug_message('error_code:'||p_error_code);
65: IF p_error_message is NOT NULL THEN
66: OZF_UTILITY_PVT.debug_message('error_message:'||p_error_message);
67: ELSE

Line 64: OZF_UTILITY_PVT.debug_message('error_code:'||p_error_code);

60: END IF;
61: IF OZF_DEBUG_LOW_ON THEN
62: OZF_UTILITY_PVT.debug_message('id_value:'||p_id_value );
63: OZF_UTILITY_PVT.debug_message('id_type:'||p_id_type );
64: OZF_UTILITY_PVT.debug_message('error_code:'||p_error_code);
65: IF p_error_message is NOT NULL THEN
66: OZF_UTILITY_PVT.debug_message('error_message:'||p_error_message);
67: ELSE
68: OZF_UTILITY_PVT.debug_message('error_message:'||fnd_message.get_string('OZF',p_error_code));

Line 66: OZF_UTILITY_PVT.debug_message('error_message:'||p_error_message);

62: OZF_UTILITY_PVT.debug_message('id_value:'||p_id_value );
63: OZF_UTILITY_PVT.debug_message('id_type:'||p_id_type );
64: OZF_UTILITY_PVT.debug_message('error_code:'||p_error_code);
65: IF p_error_message is NOT NULL THEN
66: OZF_UTILITY_PVT.debug_message('error_message:'||p_error_message);
67: ELSE
68: OZF_UTILITY_PVT.debug_message('error_message:'||fnd_message.get_string('OZF',p_error_code));
69: END IF;
70: OZF_UTILITY_PVT.debug_message('column_name'||p_column_name);

Line 68: OZF_UTILITY_PVT.debug_message('error_message:'||fnd_message.get_string('OZF',p_error_code));

64: OZF_UTILITY_PVT.debug_message('error_code:'||p_error_code);
65: IF p_error_message is NOT NULL THEN
66: OZF_UTILITY_PVT.debug_message('error_message:'||p_error_message);
67: ELSE
68: OZF_UTILITY_PVT.debug_message('error_message:'||fnd_message.get_string('OZF',p_error_code));
69: END IF;
70: OZF_UTILITY_PVT.debug_message('column_name'||p_column_name);
71: OZF_UTILITY_PVT.debug_message('column_value:'||p_column_value);
72: END IF;

Line 70: OZF_UTILITY_PVT.debug_message('column_name'||p_column_name);

66: OZF_UTILITY_PVT.debug_message('error_message:'||p_error_message);
67: ELSE
68: OZF_UTILITY_PVT.debug_message('error_message:'||fnd_message.get_string('OZF',p_error_code));
69: END IF;
70: OZF_UTILITY_PVT.debug_message('column_name'||p_column_name);
71: OZF_UTILITY_PVT.debug_message('column_value:'||p_column_value);
72: END IF;
73: --
74:

Line 71: OZF_UTILITY_PVT.debug_message('column_value:'||p_column_value);

67: ELSE
68: OZF_UTILITY_PVT.debug_message('error_message:'||fnd_message.get_string('OZF',p_error_code));
69: END IF;
70: OZF_UTILITY_PVT.debug_message('column_name'||p_column_name);
71: OZF_UTILITY_PVT.debug_message('column_value:'||p_column_value);
72: END IF;
73: --
74:
75: IF p_error_code IS NOT NULL THEN

Line 109: OZF_UTILITY_PVT.error_message('OZF_INS_RESALE_LOG_WRG');

105: px_org_id => l_org_id
106: );
107: EXCEPTION
108: WHEN OTHERS THEN
109: OZF_UTILITY_PVT.error_message('OZF_INS_RESALE_LOG_WRG');
110: RAISE FND_API.g_exc_unexpected_error;
111: END;
112: END IF;
113: --

Line 115: OZF_UTILITY_PVT.debug_message(l_api_name||': End');

111: END;
112: END IF;
113: --
114: IF OZF_DEBUG_HIGH_ON THEN
115: OZF_UTILITY_PVT.debug_message(l_api_name||': End');
116: END IF;
117: EXCEPTION
118: WHEN FND_API.G_EXC_ERROR THEN
119: x_return_status := FND_API.G_RET_STS_ERROR;

Line 159: OZF_UTILITY_PVT.debug_message(l_api_name||': Start');

155: -- End: bug # 5997978 fixed
156: BEGIN
157: x_return_status := FND_API.G_RET_STS_SUCCESS;
158: IF OZF_DEBUG_HIGH_ON THEN
159: OZF_UTILITY_PVT.debug_message(l_api_name||': Start');
160: END IF;
161: -- Start: bug # 5997978 fixed
162: OPEN g_resale_batch_org_id_csr(p_batch_id);
163: FETCH g_resale_batch_org_id_csr INTO l_batch_org_id;

Line 167: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_ORG_ID_NOTFOUND');

163: FETCH g_resale_batch_org_id_csr INTO l_batch_org_id;
164: CLOSE g_resale_batch_org_id_csr;
165: l_org_id := MO_GLOBAL.get_valid_org(l_batch_org_id);
166: IF (l_batch_org_id IS NULL OR l_org_id IS NULL) THEN
167: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_ORG_ID_NOTFOUND');
168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
169: END IF;
170: -- End: bug # 5997978 fixed
171:

Line 198: OZF_UTILITY_PVT.debug_message(l_api_name||': End');

194: -- End: bug # 5997978 fixed
195: );
196:
197: IF OZF_DEBUG_HIGH_ON THEN
198: OZF_UTILITY_PVT.debug_message(l_api_name||': End');
199: END IF;
200: EXCEPTION
201: WHEN FND_API.G_EXC_ERROR THEN
202: x_return_status := FND_API.G_RET_STS_ERROR;

Line 315: OZF_UTILITY_PVT.debug_message(l_api_name||': Start');

311: BEGIN
312: x_return_status := FND_API.G_RET_STS_SUCCESS;
313: --
314: IF OZF_DEBUG_HIGH_ON THEN
315: OZF_UTILITY_PVT.debug_message(l_api_name||': Start');
316: END IF;
317:
318: -- get batch start and end date
319: OPEN batch_info_csr (p_batch_id);

Line 332: OZF_UTILITY_PVT.debug_message('Number of errors: ' || l_id_tbl.LAST);

328:
329: IF l_id_tbl.exists(1) THEN
330: -- log disputed lines
331: IF OZF_DEBUG_LOW_ON THEN
332: OZF_UTILITY_PVT.debug_message('Number of errors: ' || l_id_tbl.LAST);
333: END IF;
334: Bulk_Insert_Resale_Log (
335: p_id_value => l_id_tbl,
336: p_id_type => G_ID_TYPE_IFACE,

Line 351: OZF_UTILITY_PVT.debug_message(l_api_name||': End');

347: END IF;
348: END IF;
349: --
350: IF OZF_DEBUG_HIGH_ON THEN
351: OZF_UTILITY_PVT.debug_message(l_api_name||': End');
352: END IF;
353: EXCEPTION
354: WHEN FND_API.G_EXC_ERROR THEN
355: x_return_status := FND_API.G_RET_STS_ERROR;

Line 477: OZF_UTILITY_PVT.debug_message(l_api_name||': Start');

473: BEGIN
474: x_return_status := FND_API.G_RET_STS_SUCCESS;
475: -- Debug Message
476: IF OZF_DEBUG_HIGH_ON THEN
477: OZF_UTILITY_PVT.debug_message(l_api_name||': Start');
478: END IF;
479: -- bulk select all lines with missing order numbers
480: OPEN invalid_columns_csr (p_batch_id);
481: FETCH invalid_columns_csr BULK COLLECT INTO l_id_tbl, l_err_tbl, l_col_tbl, l_val_tbl;

Line 488: OZF_UTILITY_PVT.debug_message('Number of errors: ' || l_id_tbl.LAST);

484:
485: IF l_id_tbl.exists(1) THEN
486: -- log disputed lines
487: IF OZF_DEBUG_LOW_ON THEN
488: OZF_UTILITY_PVT.debug_message('Number of errors: ' || l_id_tbl.LAST);
489: END IF;
490: -- log disputed lines
491: Bulk_Insert_Resale_Log (
492: p_id_value => l_id_tbl,

Line 509: OZF_UTILITY_PVT.debug_message(l_api_name||': End');

505: --
506: END IF;
507:
508: IF OZF_DEBUG_HIGH_ON THEN
509: OZF_UTILITY_PVT.debug_message(l_api_name||': End');
510: END IF;
511: EXCEPTION
512: WHEN FND_API.G_EXC_ERROR THEN
513: x_return_status := FND_API.G_RET_STS_ERROR;

Line 549: OZF_UTILITY_PVT.debug_message(l_api_name||': Start');

545: --
546: BEGIN
547: x_return_status := FND_API.G_RET_STS_SUCCESS;
548: IF OZF_DEBUG_HIGH_ON THEN
549: OZF_UTILITY_PVT.debug_message(l_api_name||': Start');
550: END IF;
551: --
552: BEGIN
553: UPDATE ozf_resale_lines_int_all orli

Line 578: OZF_UTILITY_PVT.debug_message(l_api_name||': End');

574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
575: END;
576: --
577: IF OZF_DEBUG_HIGH_ON THEN
578: OZF_UTILITY_PVT.debug_message(l_api_name||': End');
579: END IF;
580: EXCEPTION
581: WHEN FND_API.G_EXC_ERROR THEN
582: x_return_status := FND_API.G_RET_STS_ERROR;

Line 686: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': Start');

682: END IF;
683:
684: -- Debug Message
685: IF OZF_DEBUG_HIGH_ON THEN
686: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': Start');
687: END IF;
688: -- Initialize API return status to sucess
689: x_return_status := FND_API.G_RET_STS_SUCCESS;
690:

Line 725: OZF_UTILITY_PVT.debug_message('diputed line:' || l_lines_disputed || ' tolerance line' || l_lines_w_tolerance);

721: CLOSE csr_duplicated_dispute_amount;
722: --bug # 6134121 fixed by ateotia(-)
723:
724: IF OZF_DEBUG_LOW_ON THEN
725: OZF_UTILITY_PVT.debug_message('diputed line:' || l_lines_disputed || ' tolerance line' || l_lines_w_tolerance);
726: END IF;
727: --bug # 6134121 fixed by ateotia(+)
728: --IF l_lines_disputed = 0 THEN
729: IF (l_lines_disputed = 0 AND l_lines_duplicated = 0)THEN

Line 806: OZF_UTILITY_PVT.error_message('OZF_UPD_RESALE_BATCH_WRG');

802: lines_invalid = l_lines_invalid
803: WHERE resale_batch_id = p_resale_batch_id;
804: EXCEPTION
805: WHEN OTHERS THEN
806: OZF_UTILITY_PVT.error_message('OZF_UPD_RESALE_BATCH_WRG');
807: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
808: END;
809:
810: -- Debug Message

Line 812: OZF_UTILITY_PVT.debug_message(l_full_name||': End');

808: END;
809:
810: -- Debug Message
811: IF OZF_DEBUG_HIGH_ON THEN
812: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
813: END IF;
814:
815: --Standard call to get message count AND if count=1, get the message
816: FND_MSG_PUB.Count_and_Get (

Line 923: OZF_UTILITY_PVT.debug_message(l_full_name||': Start');

919: SAVEPOINT Update_Line_Calculations;
920:
921: -- Debug Message
922: IF OZF_DEBUG_HIGH_ON THEN
923: OZF_UTILITY_PVT.debug_message(l_full_name||': Start');
924: END IF;
925: IF OZF_DEBUG_LOW_ON THEN
926: OZF_UTILITY_PVT.debug_message('unit_price:'||p_unit_price);
927: OZF_UTILITY_PVT.debug_message('line_quantity:'||p_line_quantity);

Line 926: OZF_UTILITY_PVT.debug_message('unit_price:'||p_unit_price);

922: IF OZF_DEBUG_HIGH_ON THEN
923: OZF_UTILITY_PVT.debug_message(l_full_name||': Start');
924: END IF;
925: IF OZF_DEBUG_LOW_ON THEN
926: OZF_UTILITY_PVT.debug_message('unit_price:'||p_unit_price);
927: OZF_UTILITY_PVT.debug_message('line_quantity:'||p_line_quantity);
928: OZF_UTILITY_PVT.debug_message('Allowed_amount:'|| p_allowed_amount);
929: END IF;
930:

Line 927: OZF_UTILITY_PVT.debug_message('line_quantity:'||p_line_quantity);

923: OZF_UTILITY_PVT.debug_message(l_full_name||': Start');
924: END IF;
925: IF OZF_DEBUG_LOW_ON THEN
926: OZF_UTILITY_PVT.debug_message('unit_price:'||p_unit_price);
927: OZF_UTILITY_PVT.debug_message('line_quantity:'||p_line_quantity);
928: OZF_UTILITY_PVT.debug_message('Allowed_amount:'|| p_allowed_amount);
929: END IF;
930:
931: -- Initialize API return status to sucess

Line 928: OZF_UTILITY_PVT.debug_message('Allowed_amount:'|| p_allowed_amount);

924: END IF;
925: IF OZF_DEBUG_LOW_ON THEN
926: OZF_UTILITY_PVT.debug_message('unit_price:'||p_unit_price);
927: OZF_UTILITY_PVT.debug_message('line_quantity:'||p_line_quantity);
928: OZF_UTILITY_PVT.debug_message('Allowed_amount:'|| p_allowed_amount);
929: END IF;
930:
931: -- Initialize API return status to sucess
932: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1071: OZF_UTILITY_PVT.debug_message(l_full_name||': End');

1067: END;
1068:
1069: -- Debug Message
1070: IF OZF_DEBUG_HIGH_ON THEN
1071: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
1072: END IF;
1073: EXCEPTION
1074: WHEN FND_API.G_EXC_ERROR THEN
1075: ROLLBACK TO Update_Line_Calculations;

Line 1452: OZF_UTILITY_PVT.debug_message(l_full_name||': Start');

1448: END IF;
1449:
1450: -- Debug Message
1451: IF OZF_DEBUG_HIGH_ON THEN
1452: OZF_UTILITY_PVT.debug_message(l_full_name||': Start');
1453: END IF;
1454:
1455: -- Initialize API return status to sucess
1456: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1458: OZF_UTILITY_PVT.debug_message('resale_line_int_id'||p_resale_line_int_id);

1454:
1455: -- Initialize API return status to sucess
1456: x_return_status := FND_API.G_RET_STS_SUCCESS;
1457: IF OZF_DEBUG_LOW_ON THEN
1458: OZF_UTILITY_PVT.debug_message('resale_line_int_id'||p_resale_line_int_id);
1459: OZF_UTILITY_PVT.debug_message('direct_customer_flag'||p_direct_customer_flag);
1460: OZF_UTILITY_PVT.debug_message('claimed_amount'||p_claimed_amount);
1461: END IF;
1462:

Line 1459: OZF_UTILITY_PVT.debug_message('direct_customer_flag'||p_direct_customer_flag);

1455: -- Initialize API return status to sucess
1456: x_return_status := FND_API.G_RET_STS_SUCCESS;
1457: IF OZF_DEBUG_LOW_ON THEN
1458: OZF_UTILITY_PVT.debug_message('resale_line_int_id'||p_resale_line_int_id);
1459: OZF_UTILITY_PVT.debug_message('direct_customer_flag'||p_direct_customer_flag);
1460: OZF_UTILITY_PVT.debug_message('claimed_amount'||p_claimed_amount);
1461: END IF;
1462:
1463: -- Check with resale data first

Line 1460: OZF_UTILITY_PVT.debug_message('claimed_amount'||p_claimed_amount);

1456: x_return_status := FND_API.G_RET_STS_SUCCESS;
1457: IF OZF_DEBUG_LOW_ON THEN
1458: OZF_UTILITY_PVT.debug_message('resale_line_int_id'||p_resale_line_int_id);
1459: OZF_UTILITY_PVT.debug_message('direct_customer_flag'||p_direct_customer_flag);
1460: OZF_UTILITY_PVT.debug_message('claimed_amount'||p_claimed_amount);
1461: END IF;
1462:
1463: -- Check with resale data first
1464: IF p_direct_customer_flag IS NULL THEN

Line 1492: OZF_UTILITY_PVT.debug_message('l_adjustment_id = '||l_adjustment_id);

1488: x_reprocessing := l_adjustment_id IS NOT NULL AND
1489: p_claimed_amount = l_claimed_amount;
1490:
1491: IF OZF_DEBUG_LOW_ON THEN
1492: OZF_UTILITY_PVT.debug_message('l_adjustment_id = '||l_adjustment_id);
1493: OZF_UTILITY_PVT.debug_message('x_dup_adjustment_id = '||x_dup_adjustment_id);
1494: IF x_reprocessing THEN
1495: OZF_UTILITY_PVT.debug_message('x_reprocessing >> Yes');
1496: ELSE

Line 1493: OZF_UTILITY_PVT.debug_message('x_dup_adjustment_id = '||x_dup_adjustment_id);

1489: p_claimed_amount = l_claimed_amount;
1490:
1491: IF OZF_DEBUG_LOW_ON THEN
1492: OZF_UTILITY_PVT.debug_message('l_adjustment_id = '||l_adjustment_id);
1493: OZF_UTILITY_PVT.debug_message('x_dup_adjustment_id = '||x_dup_adjustment_id);
1494: IF x_reprocessing THEN
1495: OZF_UTILITY_PVT.debug_message('x_reprocessing >> Yes');
1496: ELSE
1497: OZF_UTILITY_PVT.debug_message('x_reprocessing >> No');

Line 1495: OZF_UTILITY_PVT.debug_message('x_reprocessing >> Yes');

1491: IF OZF_DEBUG_LOW_ON THEN
1492: OZF_UTILITY_PVT.debug_message('l_adjustment_id = '||l_adjustment_id);
1493: OZF_UTILITY_PVT.debug_message('x_dup_adjustment_id = '||x_dup_adjustment_id);
1494: IF x_reprocessing THEN
1495: OZF_UTILITY_PVT.debug_message('x_reprocessing >> Yes');
1496: ELSE
1497: OZF_UTILITY_PVT.debug_message('x_reprocessing >> No');
1498: END IF;
1499: END IF;

Line 1497: OZF_UTILITY_PVT.debug_message('x_reprocessing >> No');

1493: OZF_UTILITY_PVT.debug_message('x_dup_adjustment_id = '||x_dup_adjustment_id);
1494: IF x_reprocessing THEN
1495: OZF_UTILITY_PVT.debug_message('x_reprocessing >> Yes');
1496: ELSE
1497: OZF_UTILITY_PVT.debug_message('x_reprocessing >> No');
1498: END IF;
1499: END IF;
1500:
1501: ELSE

Line 1552: OZF_UTILITY_PVT.debug_message('dup adj id' || l_adjustment_id);

1548: END IF;
1549:
1550:
1551: IF OZF_DEBUG_LOW_ON THEN
1552: OZF_UTILITY_PVT.debug_message('dup adj id' || l_adjustment_id);
1553: OZF_UTILITY_PVT.debug_message('dup line id' || l_line_id);
1554: END IF;
1555:
1556: x_dup_adjustment_id := l_adjustment_id;

Line 1553: OZF_UTILITY_PVT.debug_message('dup line id' || l_line_id);

1549:
1550:
1551: IF OZF_DEBUG_LOW_ON THEN
1552: OZF_UTILITY_PVT.debug_message('dup adj id' || l_adjustment_id);
1553: OZF_UTILITY_PVT.debug_message('dup line id' || l_line_id);
1554: END IF;
1555:
1556: x_dup_adjustment_id := l_adjustment_id;
1557: x_dup_line_id := l_line_id;

Line 1562: OZF_UTILITY_PVT.debug_message(l_full_name||': End');

1558:
1559:
1560: -- Debug Message
1561: IF OZF_DEBUG_HIGH_ON THEN
1562: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
1563: END IF;
1564:
1565: --Standard call to get message count AND IF count=1, get the message
1566: FND_MSG_PUB.Count_And_Get (

Line 1684: OZF_UTILITY_PVT.debug_message(l_full_name||': Start');

1680: END IF;
1681:
1682: -- Debug Message
1683: IF OZF_DEBUG_HIGH_ON THEN
1684: OZF_UTILITY_PVT.debug_message(l_full_name||': Start');
1685: END IF;
1686:
1687: -- Initialize API return status to sucess
1688: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1722: OZF_UTILITY_PVT.error_message('OZF_RESALE_CHK_DUP_ERR');

1718: ,x_reprocessing => l_reprocessing
1719: );
1720:
1721: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1722: OZF_UTILITY_PVT.error_message('OZF_RESALE_CHK_DUP_ERR');
1723: ELSE
1724: IF l_dup_adjustment_id IS NOT NULL AND l_reprocessing THEN
1725: -- Set the line and adjustment as duplicates
1726: UPDATE ozf_resale_lines_int

Line 1814: OZF_UTILITY_PVT.debug_message(l_full_name||': End');

1810: END IF;
1811:
1812: -- Debug Message
1813: IF OZF_DEBUG_HIGH_ON THEN
1814: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
1815: END IF;
1816:
1817: --Standard call to get message count AND IF count=1, get the message
1818: FND_MSG_PUB.Count_And_Get (

Line 1943: OZF_UTILITY_PVT.debug_message(l_full_name||': Start');

1939: END IF;
1940:
1941: -- Debug Message
1942: IF OZF_DEBUG_HIGH_ON THEN
1943: OZF_UTILITY_PVT.debug_message(l_full_name||': Start');
1944: END IF;
1945:
1946: -- Initialize API return status to sucess
1947: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1960: OZF_UTILITY_PVT.debug_message('Report date:' || l_report_date);

1956: l_partner_cust_account_id;
1957: CLOSE batch_info_csr;
1958:
1959: IF OZF_DEBUG_LOW_ON THEN
1960: OZF_UTILITY_PVT.debug_message('Report date:' || l_report_date);
1961: OZF_UTILITY_PVT.debug_message('Report Start date:' || l_report_start_date);
1962: OZF_UTILITY_PVT.debug_message('Report End date:' || l_report_end_date);
1963: END IF;
1964:

Line 1961: OZF_UTILITY_PVT.debug_message('Report Start date:' || l_report_start_date);

1957: CLOSE batch_info_csr;
1958:
1959: IF OZF_DEBUG_LOW_ON THEN
1960: OZF_UTILITY_PVT.debug_message('Report date:' || l_report_date);
1961: OZF_UTILITY_PVT.debug_message('Report Start date:' || l_report_start_date);
1962: OZF_UTILITY_PVT.debug_message('Report End date:' || l_report_end_date);
1963: END IF;
1964:
1965: -- Check status

Line 1962: OZF_UTILITY_PVT.debug_message('Report End date:' || l_report_end_date);

1958:
1959: IF OZF_DEBUG_LOW_ON THEN
1960: OZF_UTILITY_PVT.debug_message('Report date:' || l_report_date);
1961: OZF_UTILITY_PVT.debug_message('Report Start date:' || l_report_start_date);
1962: OZF_UTILITY_PVT.debug_message('Report End date:' || l_report_end_date);
1963: END IF;
1964:
1965: -- Check status
1966: IF l_status_code <> G_BATCH_PROCESSING THEN

Line 2228: OZF_UTILITY_PVT.debug_message(l_full_name||': END');

2224: END IF;
2225:
2226: -- Debug Message
2227: IF OZF_DEBUG_HIGH_ON THEN
2228: OZF_UTILITY_PVT.debug_message(l_full_name||': END');
2229: END IF;
2230:
2231: --Standard call to get message count AND IF count=1, get the message
2232: FND_MSG_PUB.Count_And_Get (

Line 2314: OZF_UTILITY_PVT.debug_message(l_full_name||': Start');

2310: END IF;
2311:
2312: -- Debug Message
2313: IF OZF_DEBUG_HIGH_ON THEN
2314: OZF_UTILITY_PVT.debug_message(l_full_name||': Start');
2315: END IF;
2316:
2317: -- Initialize API return status to sucess
2318: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2359: OZF_UTILITY_PVT.debug_message(l_full_name||': End');

2355: --
2356:
2357: -- Debug Message
2358: IF OZF_DEBUG_HIGH_ON THEN
2359: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
2360: END IF;
2361:
2362: --Standard call to get message count AND IF count=1, get the message
2363: FND_MSG_PUB.Count_And_Get (

Line 2449: OZF_UTILITY_PVT.debug_message(l_full_name||': Start');

2445: x_return_status := FND_API.G_RET_STS_SUCCESS;
2446:
2447: --
2448: IF OZF_DEBUG_HIGH_ON THEN
2449: OZF_UTILITY_PVT.debug_message(l_full_name||': Start');
2450: END IF;
2451:
2452: -- Create act Utilization Record.
2453: l_pric_act_util_rec.object_type := 'TP_ORDER';

Line 2486: OZF_UTILITY_PVT.debug_message('request currency'|| l_pric_act_budgets_rec.request_currency);

2482: l_pric_act_budgets_rec.request_currency := p_line_int_rec.currency_code;
2483: l_pric_act_budgets_rec.request_amount := p_line_int_rec.total_accepted_amount;
2484:
2485: IF OZF_DEBUG_LOW_ON THEN
2486: OZF_UTILITY_PVT.debug_message('request currency'|| l_pric_act_budgets_rec.request_currency);
2487: OZF_UTILITY_PVT.debug_message('request amount: '||l_pric_act_budgets_rec.request_amount);
2488: END IF;
2489:
2490: IF p_batch_type <> G_SPECIAL_PRICING THEN

Line 2487: OZF_UTILITY_PVT.debug_message('request amount: '||l_pric_act_budgets_rec.request_amount);

2483: l_pric_act_budgets_rec.request_amount := p_line_int_rec.total_accepted_amount;
2484:
2485: IF OZF_DEBUG_LOW_ON THEN
2486: OZF_UTILITY_PVT.debug_message('request currency'|| l_pric_act_budgets_rec.request_currency);
2487: OZF_UTILITY_PVT.debug_message('request amount: '||l_pric_act_budgets_rec.request_amount);
2488: END IF;
2489:
2490: IF p_batch_type <> G_SPECIAL_PRICING THEN
2491: l_pric_act_budgets_rec.parent_src_curr :=

Line 2507: OZF_UTILITY_PVT.debug_message('in exchange');

2503: l_pric_act_budgets_rec.parent_src_apprvd_amt := p_line_int_rec.total_accepted_amount;
2504:
2505: IF p_line_int_rec.currency_code <> l_pric_act_budgets_rec.parent_src_curr THEN
2506: IF OZF_DEBUG_LOW_ON THEN
2507: OZF_UTILITY_PVT.debug_message('in exchange');
2508: END IF;
2509: -- get convertion type
2510: OPEN OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
2511: FETCH OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr INTO l_exchange_type;

Line 2514: OZF_UTILITY_PVT.Convert_Currency (

2510: OPEN OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
2511: FETCH OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr INTO l_exchange_type;
2512: CLOSE OZF_RESALE_COMMON_PVT.g_exchange_rate_type_csr;
2513:
2514: OZF_UTILITY_PVT.Convert_Currency (
2515: p_from_currency => p_line_int_rec.currency_code
2516: ,p_to_currency => l_pric_act_budgets_rec.parent_src_curr
2517: ,p_conv_type => l_exchange_type
2518: ,p_conv_rate => FND_API.G_MISS_NUM

Line 2536: OZF_UTILITY_PVT.debug_message('act currency: '||p_line_int_rec.currency_code);

2532:
2533: END IF;
2534:
2535: IF OZF_DEBUG_LOW_ON THEN
2536: OZF_UTILITY_PVT.debug_message('act currency: '||p_line_int_rec.currency_code);
2537: OZF_UTILITY_PVT.debug_message('par src: '||l_pric_act_budgets_rec.parent_src_curr);
2538: OZF_UTILITY_PVT.debug_message('approve amount: '||l_pric_act_budgets_rec.parent_src_apprvd_amt);
2539: END IF;
2540:

Line 2537: OZF_UTILITY_PVT.debug_message('par src: '||l_pric_act_budgets_rec.parent_src_curr);

2533: END IF;
2534:
2535: IF OZF_DEBUG_LOW_ON THEN
2536: OZF_UTILITY_PVT.debug_message('act currency: '||p_line_int_rec.currency_code);
2537: OZF_UTILITY_PVT.debug_message('par src: '||l_pric_act_budgets_rec.parent_src_curr);
2538: OZF_UTILITY_PVT.debug_message('approve amount: '||l_pric_act_budgets_rec.parent_src_apprvd_amt);
2539: END IF;
2540:
2541: l_pric_act_budgets_rec.transfer_type := 'UTILIZED';

Line 2538: OZF_UTILITY_PVT.debug_message('approve amount: '||l_pric_act_budgets_rec.parent_src_apprvd_amt);

2534:
2535: IF OZF_DEBUG_LOW_ON THEN
2536: OZF_UTILITY_PVT.debug_message('act currency: '||p_line_int_rec.currency_code);
2537: OZF_UTILITY_PVT.debug_message('par src: '||l_pric_act_budgets_rec.parent_src_curr);
2538: OZF_UTILITY_PVT.debug_message('approve amount: '||l_pric_act_budgets_rec.parent_src_apprvd_amt);
2539: END IF;
2540:
2541: l_pric_act_budgets_rec.transfer_type := 'UTILIZED';
2542: l_pric_act_budgets_rec.justification := p_justification;

Line 2545: l_pric_act_budgets_rec.approver_id := OZF_UTILITY_PVT.get_resource_id (p_approver_id);

2541: l_pric_act_budgets_rec.transfer_type := 'UTILIZED';
2542: l_pric_act_budgets_rec.justification := p_justification;
2543:
2544: -- Add approver_id AND requester_id
2545: l_pric_act_budgets_rec.approver_id := OZF_UTILITY_PVT.get_resource_id (p_approver_id);
2546: l_pric_act_budgets_rec.requester_id := OZF_UTILITY_PVT.get_resource_id (p_approver_id);
2547:
2548: -- Insert INTO ozf_adjustment TABLE.
2549: OPEN OZF_RESALE_COMMON_PVT.g_adjustment_id_csr;

Line 2546: l_pric_act_budgets_rec.requester_id := OZF_UTILITY_PVT.get_resource_id (p_approver_id);

2542: l_pric_act_budgets_rec.justification := p_justification;
2543:
2544: -- Add approver_id AND requester_id
2545: l_pric_act_budgets_rec.approver_id := OZF_UTILITY_PVT.get_resource_id (p_approver_id);
2546: l_pric_act_budgets_rec.requester_id := OZF_UTILITY_PVT.get_resource_id (p_approver_id);
2547:
2548: -- Insert INTO ozf_adjustment TABLE.
2549: OPEN OZF_RESALE_COMMON_PVT.g_adjustment_id_csr;
2550: FETCH OZF_RESALE_COMMON_PVT.g_adjustment_id_csr INTO l_adjustment_id;

Line 2620: OZF_UTILITY_PVT.debug_message(l_full_name||': End');

2616: WHERE duplicated_line_id = p_line_int_rec.resale_line_int_id
2617: AND duplicated_adjustment_id = -1;
2618:
2619: IF OZF_DEBUG_HIGH_ON THEN
2620: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
2621: END IF;
2622:
2623: EXCEPTION
2624: WHEN FND_API.g_exc_error THEN

Line 2703: OZF_UTILITY_PVT.debug_message(l_full_name||': Start');

2699: END IF;
2700:
2701: -- Debug Message
2702: IF OZF_DEBUG_HIGH_ON THEN
2703: OZF_UTILITY_PVT.debug_message(l_full_name||': Start');
2704: END IF;
2705:
2706: -- Initialize API return status to sucess
2707: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2710: OZF_UTILITY_PVT.debug_message('adj_id:' || p_price_adj_rec.resale_adjustment_id ||'line_id:' || p_price_adj_rec.resale_line_id);

2706: -- Initialize API return status to sucess
2707: x_return_status := FND_API.G_RET_STS_SUCCESS;
2708:
2709: IF OZF_DEBUG_LOW_ON THEN
2710: OZF_UTILITY_PVT.debug_message('adj_id:' || p_price_adj_rec.resale_adjustment_id ||'line_id:' || p_price_adj_rec.resale_line_id);
2711: IF p_to_create_utilization THEN
2712: OZF_UTILITY_PVT.debug_message('create utilization:T');
2713: ELSE
2714: OZF_UTILITY_PVT.debug_message('create utilization:F');

Line 2712: OZF_UTILITY_PVT.debug_message('create utilization:T');

2708:
2709: IF OZF_DEBUG_LOW_ON THEN
2710: OZF_UTILITY_PVT.debug_message('adj_id:' || p_price_adj_rec.resale_adjustment_id ||'line_id:' || p_price_adj_rec.resale_line_id);
2711: IF p_to_create_utilization THEN
2712: OZF_UTILITY_PVT.debug_message('create utilization:T');
2713: ELSE
2714: OZF_UTILITY_PVT.debug_message('create utilization:F');
2715: END IF;
2716: END IF;

Line 2714: OZF_UTILITY_PVT.debug_message('create utilization:F');

2710: OZF_UTILITY_PVT.debug_message('adj_id:' || p_price_adj_rec.resale_adjustment_id ||'line_id:' || p_price_adj_rec.resale_line_id);
2711: IF p_to_create_utilization THEN
2712: OZF_UTILITY_PVT.debug_message('create utilization:T');
2713: ELSE
2714: OZF_UTILITY_PVT.debug_message('create utilization:F');
2715: END IF;
2716: END IF;
2717:
2718: -- get price_adj_id

Line 2798: ozf_utility_pvt.debug_message('p_act_util_rec.object_type = '|| p_act_util_rec.object_type);

2794:
2795: -- Create accrual only when its required
2796: IF p_to_create_utilization THEN
2797: IF OZF_DEBUG_LOW_ON THEN
2798: ozf_utility_pvt.debug_message('p_act_util_rec.object_type = '|| p_act_util_rec.object_type);
2799: ozf_utility_pvt.debug_message('p_act_util_rec.object_id = '|| p_act_util_rec.object_id);
2800: ozf_utility_pvt.debug_message('p_act_util_rec.product_level_type = '|| p_act_util_rec.product_level_type);
2801: ozf_utility_pvt.debug_message('p_act_util_rec.product_id = '|| p_act_util_rec.product_id);
2802: ozf_utility_pvt.debug_message('p_act_util_rec.billto_cust_account_id = '|| p_act_util_rec.billto_cust_account_id);

Line 2799: ozf_utility_pvt.debug_message('p_act_util_rec.object_id = '|| p_act_util_rec.object_id);

2795: -- Create accrual only when its required
2796: IF p_to_create_utilization THEN
2797: IF OZF_DEBUG_LOW_ON THEN
2798: ozf_utility_pvt.debug_message('p_act_util_rec.object_type = '|| p_act_util_rec.object_type);
2799: ozf_utility_pvt.debug_message('p_act_util_rec.object_id = '|| p_act_util_rec.object_id);
2800: ozf_utility_pvt.debug_message('p_act_util_rec.product_level_type = '|| p_act_util_rec.product_level_type);
2801: ozf_utility_pvt.debug_message('p_act_util_rec.product_id = '|| p_act_util_rec.product_id);
2802: ozf_utility_pvt.debug_message('p_act_util_rec.billto_cust_account_id = '|| p_act_util_rec.billto_cust_account_id);
2803: ozf_utility_pvt.debug_message('p_act_util_rec.gl_date = '|| p_act_util_rec.gl_date);

Line 2800: ozf_utility_pvt.debug_message('p_act_util_rec.product_level_type = '|| p_act_util_rec.product_level_type);

2796: IF p_to_create_utilization THEN
2797: IF OZF_DEBUG_LOW_ON THEN
2798: ozf_utility_pvt.debug_message('p_act_util_rec.object_type = '|| p_act_util_rec.object_type);
2799: ozf_utility_pvt.debug_message('p_act_util_rec.object_id = '|| p_act_util_rec.object_id);
2800: ozf_utility_pvt.debug_message('p_act_util_rec.product_level_type = '|| p_act_util_rec.product_level_type);
2801: ozf_utility_pvt.debug_message('p_act_util_rec.product_id = '|| p_act_util_rec.product_id);
2802: ozf_utility_pvt.debug_message('p_act_util_rec.billto_cust_account_id = '|| p_act_util_rec.billto_cust_account_id);
2803: ozf_utility_pvt.debug_message('p_act_util_rec.gl_date = '|| p_act_util_rec.gl_date);
2804: ozf_utility_pvt.debug_message('p_act_util_rec.reference_type = '|| p_act_util_rec.reference_type);

Line 2801: ozf_utility_pvt.debug_message('p_act_util_rec.product_id = '|| p_act_util_rec.product_id);

2797: IF OZF_DEBUG_LOW_ON THEN
2798: ozf_utility_pvt.debug_message('p_act_util_rec.object_type = '|| p_act_util_rec.object_type);
2799: ozf_utility_pvt.debug_message('p_act_util_rec.object_id = '|| p_act_util_rec.object_id);
2800: ozf_utility_pvt.debug_message('p_act_util_rec.product_level_type = '|| p_act_util_rec.product_level_type);
2801: ozf_utility_pvt.debug_message('p_act_util_rec.product_id = '|| p_act_util_rec.product_id);
2802: ozf_utility_pvt.debug_message('p_act_util_rec.billto_cust_account_id = '|| p_act_util_rec.billto_cust_account_id);
2803: ozf_utility_pvt.debug_message('p_act_util_rec.gl_date = '|| p_act_util_rec.gl_date);
2804: ozf_utility_pvt.debug_message('p_act_util_rec.reference_type = '|| p_act_util_rec.reference_type);
2805: ozf_utility_pvt.debug_message('p_act_util_rec.reference_id = '|| p_act_util_rec.reference_id);

Line 2802: ozf_utility_pvt.debug_message('p_act_util_rec.billto_cust_account_id = '|| p_act_util_rec.billto_cust_account_id);

2798: ozf_utility_pvt.debug_message('p_act_util_rec.object_type = '|| p_act_util_rec.object_type);
2799: ozf_utility_pvt.debug_message('p_act_util_rec.object_id = '|| p_act_util_rec.object_id);
2800: ozf_utility_pvt.debug_message('p_act_util_rec.product_level_type = '|| p_act_util_rec.product_level_type);
2801: ozf_utility_pvt.debug_message('p_act_util_rec.product_id = '|| p_act_util_rec.product_id);
2802: ozf_utility_pvt.debug_message('p_act_util_rec.billto_cust_account_id = '|| p_act_util_rec.billto_cust_account_id);
2803: ozf_utility_pvt.debug_message('p_act_util_rec.gl_date = '|| p_act_util_rec.gl_date);
2804: ozf_utility_pvt.debug_message('p_act_util_rec.reference_type = '|| p_act_util_rec.reference_type);
2805: ozf_utility_pvt.debug_message('p_act_util_rec.reference_id = '|| p_act_util_rec.reference_id);
2806: ozf_utility_pvt.debug_message('p_act_util_rec.price_adjustment_id = '|| p_act_util_rec.price_adjustment_id);

Line 2803: ozf_utility_pvt.debug_message('p_act_util_rec.gl_date = '|| p_act_util_rec.gl_date);

2799: ozf_utility_pvt.debug_message('p_act_util_rec.object_id = '|| p_act_util_rec.object_id);
2800: ozf_utility_pvt.debug_message('p_act_util_rec.product_level_type = '|| p_act_util_rec.product_level_type);
2801: ozf_utility_pvt.debug_message('p_act_util_rec.product_id = '|| p_act_util_rec.product_id);
2802: ozf_utility_pvt.debug_message('p_act_util_rec.billto_cust_account_id = '|| p_act_util_rec.billto_cust_account_id);
2803: ozf_utility_pvt.debug_message('p_act_util_rec.gl_date = '|| p_act_util_rec.gl_date);
2804: ozf_utility_pvt.debug_message('p_act_util_rec.reference_type = '|| p_act_util_rec.reference_type);
2805: ozf_utility_pvt.debug_message('p_act_util_rec.reference_id = '|| p_act_util_rec.reference_id);
2806: ozf_utility_pvt.debug_message('p_act_util_rec.price_adjustment_id = '|| p_act_util_rec.price_adjustment_id);
2807: ozf_utility_pvt.debug_message('p_act_util_rec.utilization_type = '|| p_act_util_rec.utilization_type);

Line 2804: ozf_utility_pvt.debug_message('p_act_util_rec.reference_type = '|| p_act_util_rec.reference_type);

2800: ozf_utility_pvt.debug_message('p_act_util_rec.product_level_type = '|| p_act_util_rec.product_level_type);
2801: ozf_utility_pvt.debug_message('p_act_util_rec.product_id = '|| p_act_util_rec.product_id);
2802: ozf_utility_pvt.debug_message('p_act_util_rec.billto_cust_account_id = '|| p_act_util_rec.billto_cust_account_id);
2803: ozf_utility_pvt.debug_message('p_act_util_rec.gl_date = '|| p_act_util_rec.gl_date);
2804: ozf_utility_pvt.debug_message('p_act_util_rec.reference_type = '|| p_act_util_rec.reference_type);
2805: ozf_utility_pvt.debug_message('p_act_util_rec.reference_id = '|| p_act_util_rec.reference_id);
2806: ozf_utility_pvt.debug_message('p_act_util_rec.price_adjustment_id = '|| p_act_util_rec.price_adjustment_id);
2807: ozf_utility_pvt.debug_message('p_act_util_rec.utilization_type = '|| p_act_util_rec.utilization_type);
2808: ozf_utility_pvt.debug_message('p_act_util_rec.adjustment_type_id = '|| p_act_util_rec.adjustment_type_id);

Line 2805: ozf_utility_pvt.debug_message('p_act_util_rec.reference_id = '|| p_act_util_rec.reference_id);

2801: ozf_utility_pvt.debug_message('p_act_util_rec.product_id = '|| p_act_util_rec.product_id);
2802: ozf_utility_pvt.debug_message('p_act_util_rec.billto_cust_account_id = '|| p_act_util_rec.billto_cust_account_id);
2803: ozf_utility_pvt.debug_message('p_act_util_rec.gl_date = '|| p_act_util_rec.gl_date);
2804: ozf_utility_pvt.debug_message('p_act_util_rec.reference_type = '|| p_act_util_rec.reference_type);
2805: ozf_utility_pvt.debug_message('p_act_util_rec.reference_id = '|| p_act_util_rec.reference_id);
2806: ozf_utility_pvt.debug_message('p_act_util_rec.price_adjustment_id = '|| p_act_util_rec.price_adjustment_id);
2807: ozf_utility_pvt.debug_message('p_act_util_rec.utilization_type = '|| p_act_util_rec.utilization_type);
2808: ozf_utility_pvt.debug_message('p_act_util_rec.adjustment_type_id = '|| p_act_util_rec.adjustment_type_id);
2809: ozf_utility_pvt.debug_message('p_act_util_rec.org_id = '|| p_act_util_rec.org_id);

Line 2806: ozf_utility_pvt.debug_message('p_act_util_rec.price_adjustment_id = '|| p_act_util_rec.price_adjustment_id);

2802: ozf_utility_pvt.debug_message('p_act_util_rec.billto_cust_account_id = '|| p_act_util_rec.billto_cust_account_id);
2803: ozf_utility_pvt.debug_message('p_act_util_rec.gl_date = '|| p_act_util_rec.gl_date);
2804: ozf_utility_pvt.debug_message('p_act_util_rec.reference_type = '|| p_act_util_rec.reference_type);
2805: ozf_utility_pvt.debug_message('p_act_util_rec.reference_id = '|| p_act_util_rec.reference_id);
2806: ozf_utility_pvt.debug_message('p_act_util_rec.price_adjustment_id = '|| p_act_util_rec.price_adjustment_id);
2807: ozf_utility_pvt.debug_message('p_act_util_rec.utilization_type = '|| p_act_util_rec.utilization_type);
2808: ozf_utility_pvt.debug_message('p_act_util_rec.adjustment_type_id = '|| p_act_util_rec.adjustment_type_id);
2809: ozf_utility_pvt.debug_message('p_act_util_rec.org_id = '|| p_act_util_rec.org_id);
2810:

Line 2807: ozf_utility_pvt.debug_message('p_act_util_rec.utilization_type = '|| p_act_util_rec.utilization_type);

2803: ozf_utility_pvt.debug_message('p_act_util_rec.gl_date = '|| p_act_util_rec.gl_date);
2804: ozf_utility_pvt.debug_message('p_act_util_rec.reference_type = '|| p_act_util_rec.reference_type);
2805: ozf_utility_pvt.debug_message('p_act_util_rec.reference_id = '|| p_act_util_rec.reference_id);
2806: ozf_utility_pvt.debug_message('p_act_util_rec.price_adjustment_id = '|| p_act_util_rec.price_adjustment_id);
2807: ozf_utility_pvt.debug_message('p_act_util_rec.utilization_type = '|| p_act_util_rec.utilization_type);
2808: ozf_utility_pvt.debug_message('p_act_util_rec.adjustment_type_id = '|| p_act_util_rec.adjustment_type_id);
2809: ozf_utility_pvt.debug_message('p_act_util_rec.org_id = '|| p_act_util_rec.org_id);
2810:
2811: ozf_utility_pvt.debug_message('p_act_budgets_rec.act_budget_used_by_id = '|| p_act_budgets_rec.act_budget_used_by_id);

Line 2808: ozf_utility_pvt.debug_message('p_act_util_rec.adjustment_type_id = '|| p_act_util_rec.adjustment_type_id);

2804: ozf_utility_pvt.debug_message('p_act_util_rec.reference_type = '|| p_act_util_rec.reference_type);
2805: ozf_utility_pvt.debug_message('p_act_util_rec.reference_id = '|| p_act_util_rec.reference_id);
2806: ozf_utility_pvt.debug_message('p_act_util_rec.price_adjustment_id = '|| p_act_util_rec.price_adjustment_id);
2807: ozf_utility_pvt.debug_message('p_act_util_rec.utilization_type = '|| p_act_util_rec.utilization_type);
2808: ozf_utility_pvt.debug_message('p_act_util_rec.adjustment_type_id = '|| p_act_util_rec.adjustment_type_id);
2809: ozf_utility_pvt.debug_message('p_act_util_rec.org_id = '|| p_act_util_rec.org_id);
2810:
2811: ozf_utility_pvt.debug_message('p_act_budgets_rec.act_budget_used_by_id = '|| p_act_budgets_rec.act_budget_used_by_id);
2812: ozf_utility_pvt.debug_message('p_act_budgets_rec.budget_source_id = '|| p_act_budgets_rec.budget_source_id);

Line 2809: ozf_utility_pvt.debug_message('p_act_util_rec.org_id = '|| p_act_util_rec.org_id);

2805: ozf_utility_pvt.debug_message('p_act_util_rec.reference_id = '|| p_act_util_rec.reference_id);
2806: ozf_utility_pvt.debug_message('p_act_util_rec.price_adjustment_id = '|| p_act_util_rec.price_adjustment_id);
2807: ozf_utility_pvt.debug_message('p_act_util_rec.utilization_type = '|| p_act_util_rec.utilization_type);
2808: ozf_utility_pvt.debug_message('p_act_util_rec.adjustment_type_id = '|| p_act_util_rec.adjustment_type_id);
2809: ozf_utility_pvt.debug_message('p_act_util_rec.org_id = '|| p_act_util_rec.org_id);
2810:
2811: ozf_utility_pvt.debug_message('p_act_budgets_rec.act_budget_used_by_id = '|| p_act_budgets_rec.act_budget_used_by_id);
2812: ozf_utility_pvt.debug_message('p_act_budgets_rec.budget_source_id = '|| p_act_budgets_rec.budget_source_id);
2813: ozf_utility_pvt.debug_message('p_act_budgets_rec.status_code = '|| p_act_budgets_rec.status_code);

Line 2811: ozf_utility_pvt.debug_message('p_act_budgets_rec.act_budget_used_by_id = '|| p_act_budgets_rec.act_budget_used_by_id);

2807: ozf_utility_pvt.debug_message('p_act_util_rec.utilization_type = '|| p_act_util_rec.utilization_type);
2808: ozf_utility_pvt.debug_message('p_act_util_rec.adjustment_type_id = '|| p_act_util_rec.adjustment_type_id);
2809: ozf_utility_pvt.debug_message('p_act_util_rec.org_id = '|| p_act_util_rec.org_id);
2810:
2811: ozf_utility_pvt.debug_message('p_act_budgets_rec.act_budget_used_by_id = '|| p_act_budgets_rec.act_budget_used_by_id);
2812: ozf_utility_pvt.debug_message('p_act_budgets_rec.budget_source_id = '|| p_act_budgets_rec.budget_source_id);
2813: ozf_utility_pvt.debug_message('p_act_budgets_rec.status_code = '|| p_act_budgets_rec.status_code);
2814: ozf_utility_pvt.debug_message('p_act_budgets_rec.transfer_type = '|| p_act_budgets_rec.transfer_type);
2815: ozf_utility_pvt.debug_message('p_act_budgets_rec.arc_act_budget_used_by= '|| p_act_budgets_rec.arc_act_budget_used_by);

Line 2812: ozf_utility_pvt.debug_message('p_act_budgets_rec.budget_source_id = '|| p_act_budgets_rec.budget_source_id);

2808: ozf_utility_pvt.debug_message('p_act_util_rec.adjustment_type_id = '|| p_act_util_rec.adjustment_type_id);
2809: ozf_utility_pvt.debug_message('p_act_util_rec.org_id = '|| p_act_util_rec.org_id);
2810:
2811: ozf_utility_pvt.debug_message('p_act_budgets_rec.act_budget_used_by_id = '|| p_act_budgets_rec.act_budget_used_by_id);
2812: ozf_utility_pvt.debug_message('p_act_budgets_rec.budget_source_id = '|| p_act_budgets_rec.budget_source_id);
2813: ozf_utility_pvt.debug_message('p_act_budgets_rec.status_code = '|| p_act_budgets_rec.status_code);
2814: ozf_utility_pvt.debug_message('p_act_budgets_rec.transfer_type = '|| p_act_budgets_rec.transfer_type);
2815: ozf_utility_pvt.debug_message('p_act_budgets_rec.arc_act_budget_used_by= '|| p_act_budgets_rec.arc_act_budget_used_by);
2816: ozf_utility_pvt.debug_message('p_act_budgets_rec.budget_source_type = '|| p_act_budgets_rec.budget_source_type);

Line 2813: ozf_utility_pvt.debug_message('p_act_budgets_rec.status_code = '|| p_act_budgets_rec.status_code);

2809: ozf_utility_pvt.debug_message('p_act_util_rec.org_id = '|| p_act_util_rec.org_id);
2810:
2811: ozf_utility_pvt.debug_message('p_act_budgets_rec.act_budget_used_by_id = '|| p_act_budgets_rec.act_budget_used_by_id);
2812: ozf_utility_pvt.debug_message('p_act_budgets_rec.budget_source_id = '|| p_act_budgets_rec.budget_source_id);
2813: ozf_utility_pvt.debug_message('p_act_budgets_rec.status_code = '|| p_act_budgets_rec.status_code);
2814: ozf_utility_pvt.debug_message('p_act_budgets_rec.transfer_type = '|| p_act_budgets_rec.transfer_type);
2815: ozf_utility_pvt.debug_message('p_act_budgets_rec.arc_act_budget_used_by= '|| p_act_budgets_rec.arc_act_budget_used_by);
2816: ozf_utility_pvt.debug_message('p_act_budgets_rec.budget_source_type = '|| p_act_budgets_rec.budget_source_type);
2817: ozf_utility_pvt.debug_message('p_act_budgets_rec.approver_id = '|| p_act_budgets_rec.approver_id);

Line 2814: ozf_utility_pvt.debug_message('p_act_budgets_rec.transfer_type = '|| p_act_budgets_rec.transfer_type);

2810:
2811: ozf_utility_pvt.debug_message('p_act_budgets_rec.act_budget_used_by_id = '|| p_act_budgets_rec.act_budget_used_by_id);
2812: ozf_utility_pvt.debug_message('p_act_budgets_rec.budget_source_id = '|| p_act_budgets_rec.budget_source_id);
2813: ozf_utility_pvt.debug_message('p_act_budgets_rec.status_code = '|| p_act_budgets_rec.status_code);
2814: ozf_utility_pvt.debug_message('p_act_budgets_rec.transfer_type = '|| p_act_budgets_rec.transfer_type);
2815: ozf_utility_pvt.debug_message('p_act_budgets_rec.arc_act_budget_used_by= '|| p_act_budgets_rec.arc_act_budget_used_by);
2816: ozf_utility_pvt.debug_message('p_act_budgets_rec.budget_source_type = '|| p_act_budgets_rec.budget_source_type);
2817: ozf_utility_pvt.debug_message('p_act_budgets_rec.approver_id = '|| p_act_budgets_rec.approver_id);
2818: ozf_utility_pvt.debug_message('p_act_budgets_rec.requester_id = '|| p_act_budgets_rec.requester_id);

Line 2815: ozf_utility_pvt.debug_message('p_act_budgets_rec.arc_act_budget_used_by= '|| p_act_budgets_rec.arc_act_budget_used_by);

2811: ozf_utility_pvt.debug_message('p_act_budgets_rec.act_budget_used_by_id = '|| p_act_budgets_rec.act_budget_used_by_id);
2812: ozf_utility_pvt.debug_message('p_act_budgets_rec.budget_source_id = '|| p_act_budgets_rec.budget_source_id);
2813: ozf_utility_pvt.debug_message('p_act_budgets_rec.status_code = '|| p_act_budgets_rec.status_code);
2814: ozf_utility_pvt.debug_message('p_act_budgets_rec.transfer_type = '|| p_act_budgets_rec.transfer_type);
2815: ozf_utility_pvt.debug_message('p_act_budgets_rec.arc_act_budget_used_by= '|| p_act_budgets_rec.arc_act_budget_used_by);
2816: ozf_utility_pvt.debug_message('p_act_budgets_rec.budget_source_type = '|| p_act_budgets_rec.budget_source_type);
2817: ozf_utility_pvt.debug_message('p_act_budgets_rec.approver_id = '|| p_act_budgets_rec.approver_id);
2818: ozf_utility_pvt.debug_message('p_act_budgets_rec.requester_id = '|| p_act_budgets_rec.requester_id);
2819: ozf_utility_pvt.debug_message('p_act_budgets_rec.request_currency = '|| p_act_budgets_rec.request_currency);

Line 2816: ozf_utility_pvt.debug_message('p_act_budgets_rec.budget_source_type = '|| p_act_budgets_rec.budget_source_type);

2812: ozf_utility_pvt.debug_message('p_act_budgets_rec.budget_source_id = '|| p_act_budgets_rec.budget_source_id);
2813: ozf_utility_pvt.debug_message('p_act_budgets_rec.status_code = '|| p_act_budgets_rec.status_code);
2814: ozf_utility_pvt.debug_message('p_act_budgets_rec.transfer_type = '|| p_act_budgets_rec.transfer_type);
2815: ozf_utility_pvt.debug_message('p_act_budgets_rec.arc_act_budget_used_by= '|| p_act_budgets_rec.arc_act_budget_used_by);
2816: ozf_utility_pvt.debug_message('p_act_budgets_rec.budget_source_type = '|| p_act_budgets_rec.budget_source_type);
2817: ozf_utility_pvt.debug_message('p_act_budgets_rec.approver_id = '|| p_act_budgets_rec.approver_id);
2818: ozf_utility_pvt.debug_message('p_act_budgets_rec.requester_id = '|| p_act_budgets_rec.requester_id);
2819: ozf_utility_pvt.debug_message('p_act_budgets_rec.request_currency = '|| p_act_budgets_rec.request_currency);
2820: ozf_utility_pvt.debug_message('p_act_budgets_rec.parent_source_id = '|| p_act_budgets_rec.parent_source_id);

Line 2817: ozf_utility_pvt.debug_message('p_act_budgets_rec.approver_id = '|| p_act_budgets_rec.approver_id);

2813: ozf_utility_pvt.debug_message('p_act_budgets_rec.status_code = '|| p_act_budgets_rec.status_code);
2814: ozf_utility_pvt.debug_message('p_act_budgets_rec.transfer_type = '|| p_act_budgets_rec.transfer_type);
2815: ozf_utility_pvt.debug_message('p_act_budgets_rec.arc_act_budget_used_by= '|| p_act_budgets_rec.arc_act_budget_used_by);
2816: ozf_utility_pvt.debug_message('p_act_budgets_rec.budget_source_type = '|| p_act_budgets_rec.budget_source_type);
2817: ozf_utility_pvt.debug_message('p_act_budgets_rec.approver_id = '|| p_act_budgets_rec.approver_id);
2818: ozf_utility_pvt.debug_message('p_act_budgets_rec.requester_id = '|| p_act_budgets_rec.requester_id);
2819: ozf_utility_pvt.debug_message('p_act_budgets_rec.request_currency = '|| p_act_budgets_rec.request_currency);
2820: ozf_utility_pvt.debug_message('p_act_budgets_rec.parent_source_id = '|| p_act_budgets_rec.parent_source_id);
2821: ozf_utility_pvt.debug_message('p_act_budgets_rec.parent_src_curr = '|| p_act_budgets_rec.parent_src_curr);

Line 2818: ozf_utility_pvt.debug_message('p_act_budgets_rec.requester_id = '|| p_act_budgets_rec.requester_id);

2814: ozf_utility_pvt.debug_message('p_act_budgets_rec.transfer_type = '|| p_act_budgets_rec.transfer_type);
2815: ozf_utility_pvt.debug_message('p_act_budgets_rec.arc_act_budget_used_by= '|| p_act_budgets_rec.arc_act_budget_used_by);
2816: ozf_utility_pvt.debug_message('p_act_budgets_rec.budget_source_type = '|| p_act_budgets_rec.budget_source_type);
2817: ozf_utility_pvt.debug_message('p_act_budgets_rec.approver_id = '|| p_act_budgets_rec.approver_id);
2818: ozf_utility_pvt.debug_message('p_act_budgets_rec.requester_id = '|| p_act_budgets_rec.requester_id);
2819: ozf_utility_pvt.debug_message('p_act_budgets_rec.request_currency = '|| p_act_budgets_rec.request_currency);
2820: ozf_utility_pvt.debug_message('p_act_budgets_rec.parent_source_id = '|| p_act_budgets_rec.parent_source_id);
2821: ozf_utility_pvt.debug_message('p_act_budgets_rec.parent_src_curr = '|| p_act_budgets_rec.parent_src_curr);
2822: ozf_utility_pvt.debug_message('p_act_budgets_rec.justification = '|| p_act_budgets_rec.justification);

Line 2819: ozf_utility_pvt.debug_message('p_act_budgets_rec.request_currency = '|| p_act_budgets_rec.request_currency);

2815: ozf_utility_pvt.debug_message('p_act_budgets_rec.arc_act_budget_used_by= '|| p_act_budgets_rec.arc_act_budget_used_by);
2816: ozf_utility_pvt.debug_message('p_act_budgets_rec.budget_source_type = '|| p_act_budgets_rec.budget_source_type);
2817: ozf_utility_pvt.debug_message('p_act_budgets_rec.approver_id = '|| p_act_budgets_rec.approver_id);
2818: ozf_utility_pvt.debug_message('p_act_budgets_rec.requester_id = '|| p_act_budgets_rec.requester_id);
2819: ozf_utility_pvt.debug_message('p_act_budgets_rec.request_currency = '|| p_act_budgets_rec.request_currency);
2820: ozf_utility_pvt.debug_message('p_act_budgets_rec.parent_source_id = '|| p_act_budgets_rec.parent_source_id);
2821: ozf_utility_pvt.debug_message('p_act_budgets_rec.parent_src_curr = '|| p_act_budgets_rec.parent_src_curr);
2822: ozf_utility_pvt.debug_message('p_act_budgets_rec.justification = '|| p_act_budgets_rec.justification);
2823: ozf_utility_pvt.debug_message('p_act_budgets_rec.arc_act_budget_used_by= '|| p_act_budgets_rec.arc_act_budget_used_by);

Line 2820: ozf_utility_pvt.debug_message('p_act_budgets_rec.parent_source_id = '|| p_act_budgets_rec.parent_source_id);

2816: ozf_utility_pvt.debug_message('p_act_budgets_rec.budget_source_type = '|| p_act_budgets_rec.budget_source_type);
2817: ozf_utility_pvt.debug_message('p_act_budgets_rec.approver_id = '|| p_act_budgets_rec.approver_id);
2818: ozf_utility_pvt.debug_message('p_act_budgets_rec.requester_id = '|| p_act_budgets_rec.requester_id);
2819: ozf_utility_pvt.debug_message('p_act_budgets_rec.request_currency = '|| p_act_budgets_rec.request_currency);
2820: ozf_utility_pvt.debug_message('p_act_budgets_rec.parent_source_id = '|| p_act_budgets_rec.parent_source_id);
2821: ozf_utility_pvt.debug_message('p_act_budgets_rec.parent_src_curr = '|| p_act_budgets_rec.parent_src_curr);
2822: ozf_utility_pvt.debug_message('p_act_budgets_rec.justification = '|| p_act_budgets_rec.justification);
2823: ozf_utility_pvt.debug_message('p_act_budgets_rec.arc_act_budget_used_by= '|| p_act_budgets_rec.arc_act_budget_used_by);
2824: ozf_utility_pvt.debug_message('p_act_budgets_rec.budget_source_type = '|| p_act_budgets_rec.budget_source_type);

Line 2821: ozf_utility_pvt.debug_message('p_act_budgets_rec.parent_src_curr = '|| p_act_budgets_rec.parent_src_curr);

2817: ozf_utility_pvt.debug_message('p_act_budgets_rec.approver_id = '|| p_act_budgets_rec.approver_id);
2818: ozf_utility_pvt.debug_message('p_act_budgets_rec.requester_id = '|| p_act_budgets_rec.requester_id);
2819: ozf_utility_pvt.debug_message('p_act_budgets_rec.request_currency = '|| p_act_budgets_rec.request_currency);
2820: ozf_utility_pvt.debug_message('p_act_budgets_rec.parent_source_id = '|| p_act_budgets_rec.parent_source_id);
2821: ozf_utility_pvt.debug_message('p_act_budgets_rec.parent_src_curr = '|| p_act_budgets_rec.parent_src_curr);
2822: ozf_utility_pvt.debug_message('p_act_budgets_rec.justification = '|| p_act_budgets_rec.justification);
2823: ozf_utility_pvt.debug_message('p_act_budgets_rec.arc_act_budget_used_by= '|| p_act_budgets_rec.arc_act_budget_used_by);
2824: ozf_utility_pvt.debug_message('p_act_budgets_rec.budget_source_type = '|| p_act_budgets_rec.budget_source_type);
2825: ozf_utility_pvt.debug_message('p_act_budgets_rec.request_currency = '|| p_act_budgets_rec.request_currency);

Line 2822: ozf_utility_pvt.debug_message('p_act_budgets_rec.justification = '|| p_act_budgets_rec.justification);

2818: ozf_utility_pvt.debug_message('p_act_budgets_rec.requester_id = '|| p_act_budgets_rec.requester_id);
2819: ozf_utility_pvt.debug_message('p_act_budgets_rec.request_currency = '|| p_act_budgets_rec.request_currency);
2820: ozf_utility_pvt.debug_message('p_act_budgets_rec.parent_source_id = '|| p_act_budgets_rec.parent_source_id);
2821: ozf_utility_pvt.debug_message('p_act_budgets_rec.parent_src_curr = '|| p_act_budgets_rec.parent_src_curr);
2822: ozf_utility_pvt.debug_message('p_act_budgets_rec.justification = '|| p_act_budgets_rec.justification);
2823: ozf_utility_pvt.debug_message('p_act_budgets_rec.arc_act_budget_used_by= '|| p_act_budgets_rec.arc_act_budget_used_by);
2824: ozf_utility_pvt.debug_message('p_act_budgets_rec.budget_source_type = '|| p_act_budgets_rec.budget_source_type);
2825: ozf_utility_pvt.debug_message('p_act_budgets_rec.request_currency = '|| p_act_budgets_rec.request_currency);
2826: ozf_utility_pvt.debug_message('p_act_budgets_rec.request_amount = '|| p_act_budgets_rec.request_amount);

Line 2823: ozf_utility_pvt.debug_message('p_act_budgets_rec.arc_act_budget_used_by= '|| p_act_budgets_rec.arc_act_budget_used_by);

2819: ozf_utility_pvt.debug_message('p_act_budgets_rec.request_currency = '|| p_act_budgets_rec.request_currency);
2820: ozf_utility_pvt.debug_message('p_act_budgets_rec.parent_source_id = '|| p_act_budgets_rec.parent_source_id);
2821: ozf_utility_pvt.debug_message('p_act_budgets_rec.parent_src_curr = '|| p_act_budgets_rec.parent_src_curr);
2822: ozf_utility_pvt.debug_message('p_act_budgets_rec.justification = '|| p_act_budgets_rec.justification);
2823: ozf_utility_pvt.debug_message('p_act_budgets_rec.arc_act_budget_used_by= '|| p_act_budgets_rec.arc_act_budget_used_by);
2824: ozf_utility_pvt.debug_message('p_act_budgets_rec.budget_source_type = '|| p_act_budgets_rec.budget_source_type);
2825: ozf_utility_pvt.debug_message('p_act_budgets_rec.request_currency = '|| p_act_budgets_rec.request_currency);
2826: ozf_utility_pvt.debug_message('p_act_budgets_rec.request_amount = '|| p_act_budgets_rec.request_amount);
2827: ozf_utility_pvt.debug_message('p_act_budgets_rec.parent_src_apprvd_amt = '|| p_act_budgets_rec.parent_src_apprvd_amt);

Line 2824: ozf_utility_pvt.debug_message('p_act_budgets_rec.budget_source_type = '|| p_act_budgets_rec.budget_source_type);

2820: ozf_utility_pvt.debug_message('p_act_budgets_rec.parent_source_id = '|| p_act_budgets_rec.parent_source_id);
2821: ozf_utility_pvt.debug_message('p_act_budgets_rec.parent_src_curr = '|| p_act_budgets_rec.parent_src_curr);
2822: ozf_utility_pvt.debug_message('p_act_budgets_rec.justification = '|| p_act_budgets_rec.justification);
2823: ozf_utility_pvt.debug_message('p_act_budgets_rec.arc_act_budget_used_by= '|| p_act_budgets_rec.arc_act_budget_used_by);
2824: ozf_utility_pvt.debug_message('p_act_budgets_rec.budget_source_type = '|| p_act_budgets_rec.budget_source_type);
2825: ozf_utility_pvt.debug_message('p_act_budgets_rec.request_currency = '|| p_act_budgets_rec.request_currency);
2826: ozf_utility_pvt.debug_message('p_act_budgets_rec.request_amount = '|| p_act_budgets_rec.request_amount);
2827: ozf_utility_pvt.debug_message('p_act_budgets_rec.parent_src_apprvd_amt = '|| p_act_budgets_rec.parent_src_apprvd_amt);
2828: END IF;

Line 2825: ozf_utility_pvt.debug_message('p_act_budgets_rec.request_currency = '|| p_act_budgets_rec.request_currency);

2821: ozf_utility_pvt.debug_message('p_act_budgets_rec.parent_src_curr = '|| p_act_budgets_rec.parent_src_curr);
2822: ozf_utility_pvt.debug_message('p_act_budgets_rec.justification = '|| p_act_budgets_rec.justification);
2823: ozf_utility_pvt.debug_message('p_act_budgets_rec.arc_act_budget_used_by= '|| p_act_budgets_rec.arc_act_budget_used_by);
2824: ozf_utility_pvt.debug_message('p_act_budgets_rec.budget_source_type = '|| p_act_budgets_rec.budget_source_type);
2825: ozf_utility_pvt.debug_message('p_act_budgets_rec.request_currency = '|| p_act_budgets_rec.request_currency);
2826: ozf_utility_pvt.debug_message('p_act_budgets_rec.request_amount = '|| p_act_budgets_rec.request_amount);
2827: ozf_utility_pvt.debug_message('p_act_budgets_rec.parent_src_apprvd_amt = '|| p_act_budgets_rec.parent_src_apprvd_amt);
2828: END IF;
2829:

Line 2826: ozf_utility_pvt.debug_message('p_act_budgets_rec.request_amount = '|| p_act_budgets_rec.request_amount);

2822: ozf_utility_pvt.debug_message('p_act_budgets_rec.justification = '|| p_act_budgets_rec.justification);
2823: ozf_utility_pvt.debug_message('p_act_budgets_rec.arc_act_budget_used_by= '|| p_act_budgets_rec.arc_act_budget_used_by);
2824: ozf_utility_pvt.debug_message('p_act_budgets_rec.budget_source_type = '|| p_act_budgets_rec.budget_source_type);
2825: ozf_utility_pvt.debug_message('p_act_budgets_rec.request_currency = '|| p_act_budgets_rec.request_currency);
2826: ozf_utility_pvt.debug_message('p_act_budgets_rec.request_amount = '|| p_act_budgets_rec.request_amount);
2827: ozf_utility_pvt.debug_message('p_act_budgets_rec.parent_src_apprvd_amt = '|| p_act_budgets_rec.parent_src_apprvd_amt);
2828: END IF;
2829:
2830: BEGIN

Line 2827: ozf_utility_pvt.debug_message('p_act_budgets_rec.parent_src_apprvd_amt = '|| p_act_budgets_rec.parent_src_apprvd_amt);

2823: ozf_utility_pvt.debug_message('p_act_budgets_rec.arc_act_budget_used_by= '|| p_act_budgets_rec.arc_act_budget_used_by);
2824: ozf_utility_pvt.debug_message('p_act_budgets_rec.budget_source_type = '|| p_act_budgets_rec.budget_source_type);
2825: ozf_utility_pvt.debug_message('p_act_budgets_rec.request_currency = '|| p_act_budgets_rec.request_currency);
2826: ozf_utility_pvt.debug_message('p_act_budgets_rec.request_amount = '|| p_act_budgets_rec.request_amount);
2827: ozf_utility_pvt.debug_message('p_act_budgets_rec.parent_src_apprvd_amt = '|| p_act_budgets_rec.parent_src_apprvd_amt);
2828: END IF;
2829:
2830: BEGIN
2831: --

Line 2842: OZF_UTILITY_PVT.debug_message('OZF_FUND_ADJUSTMENT_PVT.Process_Act_Budgets return result: '||l_return_status);

2838: x_act_budget_id => l_act_budget_id,
2839: x_utilized_amount => l_utilized_amount
2840: );
2841: IF OZF_DEBUG_LOW_ON THEN
2842: OZF_UTILITY_PVT.debug_message('OZF_FUND_ADJUSTMENT_PVT.Process_Act_Budgets return result: '||l_return_status);
2843: OZF_UTILITY_PVT.debug_message('post to budget: budget_source_id:' || p_act_budgets_rec.budget_source_id);
2844: OZF_UTILITY_PVT.debug_message('post to budget: amount:' || p_act_budgets_rec.request_amount);
2845: OZF_UTILITY_PVT.debug_message('x_utilized_amount: '||l_utilized_amount);
2846: END IF;

Line 2843: OZF_UTILITY_PVT.debug_message('post to budget: budget_source_id:' || p_act_budgets_rec.budget_source_id);

2839: x_utilized_amount => l_utilized_amount
2840: );
2841: IF OZF_DEBUG_LOW_ON THEN
2842: OZF_UTILITY_PVT.debug_message('OZF_FUND_ADJUSTMENT_PVT.Process_Act_Budgets return result: '||l_return_status);
2843: OZF_UTILITY_PVT.debug_message('post to budget: budget_source_id:' || p_act_budgets_rec.budget_source_id);
2844: OZF_UTILITY_PVT.debug_message('post to budget: amount:' || p_act_budgets_rec.request_amount);
2845: OZF_UTILITY_PVT.debug_message('x_utilized_amount: '||l_utilized_amount);
2846: END IF;
2847:

Line 2844: OZF_UTILITY_PVT.debug_message('post to budget: amount:' || p_act_budgets_rec.request_amount);

2840: );
2841: IF OZF_DEBUG_LOW_ON THEN
2842: OZF_UTILITY_PVT.debug_message('OZF_FUND_ADJUSTMENT_PVT.Process_Act_Budgets return result: '||l_return_status);
2843: OZF_UTILITY_PVT.debug_message('post to budget: budget_source_id:' || p_act_budgets_rec.budget_source_id);
2844: OZF_UTILITY_PVT.debug_message('post to budget: amount:' || p_act_budgets_rec.request_amount);
2845: OZF_UTILITY_PVT.debug_message('x_utilized_amount: '||l_utilized_amount);
2846: END IF;
2847:
2848: IF l_return_status = FND_API.g_ret_sts_error THEN

Line 2845: OZF_UTILITY_PVT.debug_message('x_utilized_amount: '||l_utilized_amount);

2841: IF OZF_DEBUG_LOW_ON THEN
2842: OZF_UTILITY_PVT.debug_message('OZF_FUND_ADJUSTMENT_PVT.Process_Act_Budgets return result: '||l_return_status);
2843: OZF_UTILITY_PVT.debug_message('post to budget: budget_source_id:' || p_act_budgets_rec.budget_source_id);
2844: OZF_UTILITY_PVT.debug_message('post to budget: amount:' || p_act_budgets_rec.request_amount);
2845: OZF_UTILITY_PVT.debug_message('x_utilized_amount: '||l_utilized_amount);
2846: END IF;
2847:
2848: IF l_return_status = FND_API.g_ret_sts_error THEN
2849: RAISE FND_API.g_exc_error;

Line 2855: ozf_utility_pvt.error_message ( 'OZF_COMMAMT_LESS_REQAMT');

2851: RAISE FND_API.g_exc_unexpected_error;
2852: END IF;
2853: -- bug 5391758,5216124
2854: IF l_utilized_amount = 0 AND p_act_budgets_rec.request_amount <> 0 THEN
2855: ozf_utility_pvt.error_message ( 'OZF_COMMAMT_LESS_REQAMT');
2856: RAISE fnd_api.g_exc_error;
2857: END IF;
2858:
2859: EXCEPTION

Line 2870: OZF_UTILITY_PVT.debug_message(l_full_name||': End');

2866: END IF;
2867:
2868: -- Debug Message
2869: IF OZF_DEBUG_HIGH_ON THEN
2870: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
2871: END IF;
2872:
2873: --Standard call to get message count AND IF count=1, get the message
2874: FND_MSG_PUB.Count_And_Get (

Line 3003: OZF_UTILITY_PVT.debug_message(l_full_name||': Start');

2999: END IF;
3000:
3001: -- Debug Message
3002: IF OZF_DEBUG_HIGH_ON THEN
3003: OZF_UTILITY_PVT.debug_message(l_full_name||': Start');
3004: END IF;
3005:
3006: -- Initialize API return status to sucess
3007: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3010: OZF_UTILITY_PVT.debug_message('IN create_utilization');

3006: -- Initialize API return status to sucess
3007: x_return_status := FND_API.G_RET_STS_SUCCESS;
3008:
3009: IF OZF_DEBUG_LOW_ON THEN
3010: OZF_UTILITY_PVT.debug_message('IN create_utilization');
3011: END IF;
3012:
3013: OPEN g_batch_type_csr(l_line_int_rec.resale_batch_id);
3014: FETCH g_batch_type_csr into l_batch_type;

Line 3018: OZF_UTILITY_PVT.debug_message('batch type' ||l_batch_type);

3014: FETCH g_batch_type_csr into l_batch_type;
3015: CLOSE g_batch_type_csr;
3016:
3017: IF OZF_DEBUG_LOW_ON THEN
3018: OZF_UTILITY_PVT.debug_message('batch type' ||l_batch_type);
3019: END IF;
3020:
3021: IF l_batch_type = G_CHARGEBACK THEN
3022: l_utilization_type:= G_CHBK_UTIL_TYPE;

Line 3035: OZF_UTILITY_PVT.debug_message('In batch type as spp.');

3031: END IF;
3032:
3033: ELSIF l_batch_type = G_SPECIAL_PRICING THEN
3034: IF OZF_DEBUG_LOW_ON THEN
3035: OZF_UTILITY_PVT.debug_message('In batch type as spp.');
3036: END IF;
3037: l_utilization_type:= G_SPP_UTIL_TYPE;
3038: l_budget_source_type := 'OFFR';
3039: l_justification := 'SPECIAL PRICE';

Line 3057: OZF_UTILITY_PVT.debug_message('dup line id' ||l_line_int_rec.duplicated_line_id);

3053: */
3054: END IF;
3055:
3056: IF OZF_DEBUG_LOW_ON THEN
3057: OZF_UTILITY_PVT.debug_message('dup line id' ||l_line_int_rec.duplicated_line_id);
3058: OZF_UTILITY_PVT.debug_message('dup_accepted_amount:'||l_dup_total_accepted_amount);
3059: OZF_UTILITY_PVT.debug_message('total_accepted_amount:'||l_line_int_rec.total_accepted_amount);
3060: END IF;
3061:

Line 3058: OZF_UTILITY_PVT.debug_message('dup_accepted_amount:'||l_dup_total_accepted_amount);

3054: END IF;
3055:
3056: IF OZF_DEBUG_LOW_ON THEN
3057: OZF_UTILITY_PVT.debug_message('dup line id' ||l_line_int_rec.duplicated_line_id);
3058: OZF_UTILITY_PVT.debug_message('dup_accepted_amount:'||l_dup_total_accepted_amount);
3059: OZF_UTILITY_PVT.debug_message('total_accepted_amount:'||l_line_int_rec.total_accepted_amount);
3060: END IF;
3061:
3062: IF l_line_int_rec.duplicated_line_id IS NOT NULL THEN

Line 3059: OZF_UTILITY_PVT.debug_message('total_accepted_amount:'||l_line_int_rec.total_accepted_amount);

3055:
3056: IF OZF_DEBUG_LOW_ON THEN
3057: OZF_UTILITY_PVT.debug_message('dup line id' ||l_line_int_rec.duplicated_line_id);
3058: OZF_UTILITY_PVT.debug_message('dup_accepted_amount:'||l_dup_total_accepted_amount);
3059: OZF_UTILITY_PVT.debug_message('total_accepted_amount:'||l_line_int_rec.total_accepted_amount);
3060: END IF;
3061:
3062: IF l_line_int_rec.duplicated_line_id IS NOT NULL THEN
3063: IF l_line_int_rec.duplicated_adjustment_id = -1 THEN

Line 3187: OZF_UTILITY_PVT.debug_message('In creat utilization with nothing');

3183: END IF;
3184: END IF;
3185: ELSE
3186: IF OZF_DEBUG_LOW_ON THEN
3187: OZF_UTILITY_PVT.debug_message('In creat utilization with nothing');
3188: END IF;
3189: -- Create utilization using int rec
3190: Create_Utilization_record(
3191: p_line_int_rec => l_line_int_rec

Line 3215: OZF_UTILITY_PVT.debug_message(l_full_name||': End');

3211: END IF;
3212:
3213: -- Debug Message
3214: IF OZF_DEBUG_HIGH_ON THEN
3215: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
3216: END IF;
3217:
3218: --Standard call to get message count AND IF count=1, get the message
3219: FND_MSG_PUB.Count_And_Get (

Line 3325: OZF_UTILITY_PVT.debug_message(l_full_name||': Start');

3321: END IF;
3322:
3323: -- Debug Message
3324: IF OZF_DEBUG_HIGH_ON THEN
3325: OZF_UTILITY_PVT.debug_message(l_full_name||': Start');
3326: END IF;
3327:
3328: --Initialize message LIST IF p_init_msg_LIST IS TRUE.
3329: IF FND_API.To_Boolean (p_init_msg_LIST) THEN

Line 3392: OZF_UTILITY_PVT.debug_message(l_full_name||': End');

3388: --
3389:
3390: -- Debug Message
3391: IF OZF_DEBUG_HIGH_ON THEN
3392: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
3393: END IF;
3394:
3395: --Standard call to get message count AND IF count=1, get the message
3396: FND_MSG_PUB.Count_And_Get (

Line 3487: OZF_UTILITY_PVT.debug_message(l_full_name||': Start');

3483: END IF;
3484:
3485: -- Debug Message
3486: IF OZF_DEBUG_HIGH_ON THEN
3487: OZF_UTILITY_PVT.debug_message(l_full_name||': Start');
3488: END IF;
3489:
3490: --Initialize message LIST IF p_init_msg_LIST IS TRUE.
3491: IF FND_API.To_Boolean (p_init_msg_LIST) THEN

Line 3506: OZF_UTILITY_PVT.debug_message('before INSERT: header_id' || l_header_id);

3502:
3503: x_header_id := l_header_id;
3504: l_org_id := p_line_int_rec.org_id; -- bug # 5997978 fixed
3505: IF OZF_DEBUG_LOW_ON THEN
3506: OZF_UTILITY_PVT.debug_message('before INSERT: header_id' || l_header_id);
3507: END IF;
3508:
3509: OZF_RESALE_HEADERS_PKG.Insert_Row(
3510: px_resale_header_id => l_header_id,

Line 3603: OZF_UTILITY_PVT.debug_message(l_full_name||': End');

3599: px_org_id => l_org_id);
3600:
3601: -- Debug Message
3602: IF OZF_DEBUG_HIGH_ON THEN
3603: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
3604: END IF;
3605:
3606: --Standard call to get message count AND IF count=1, get the message
3607: FND_MSG_PUB.Count_And_Get (

Line 3700: OZF_UTILITY_PVT.debug_message(l_full_name||': Start');

3696: END IF;
3697:
3698: -- Debug Message
3699: IF OZF_DEBUG_HIGH_ON THEN
3700: OZF_UTILITY_PVT.debug_message(l_full_name||': Start');
3701: END IF;
3702:
3703: --Initialize message LIST IF p_init_msg_LIST IS TRUE.
3704: IF FND_API.To_Boolean (p_init_msg_LIST) THEN

Line 3717: OZF_UTILITY_PVT.debug_message('before line INSERT: header id' || p_header_id);

3713: CLOSE g_line_id_csr;
3714: x_line_id := l_line_id;
3715: l_org_id := p_line_int_rec.org_id; -- bug # 5997978 fixed
3716: IF OZF_DEBUG_LOW_ON THEN
3717: OZF_UTILITY_PVT.debug_message('before line INSERT: header id' || p_header_id);
3718: OZF_UTILITY_PVT.debug_message('before line INSERT:' || l_line_id);
3719: END IF;
3720:
3721: OZF_RESALE_LINES_PKG.Insert_Row(

Line 3718: OZF_UTILITY_PVT.debug_message('before line INSERT:' || l_line_id);

3714: x_line_id := l_line_id;
3715: l_org_id := p_line_int_rec.org_id; -- bug # 5997978 fixed
3716: IF OZF_DEBUG_LOW_ON THEN
3717: OZF_UTILITY_PVT.debug_message('before line INSERT: header id' || p_header_id);
3718: OZF_UTILITY_PVT.debug_message('before line INSERT:' || l_line_id);
3719: END IF;
3720:
3721: OZF_RESALE_LINES_PKG.Insert_Row(
3722: p_resale_line_id => l_line_id ,

Line 3913: OZF_UTILITY_PVT.debug_message('line INSERT successful id:' || l_line_id);

3909: px_org_id => l_org_id );
3910:
3911:
3912: IF OZF_DEBUG_HIGH_ON THEN
3913: OZF_UTILITY_PVT.debug_message('line INSERT successful id:' || l_line_id);
3914: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
3915: END IF;
3916:
3917: --Standard call to get message count AND IF count=1, get the message

Line 3914: OZF_UTILITY_PVT.debug_message(l_full_name||': End');

3910:
3911:
3912: IF OZF_DEBUG_HIGH_ON THEN
3913: OZF_UTILITY_PVT.debug_message('line INSERT successful id:' || l_line_id);
3914: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
3915: END IF;
3916:
3917: --Standard call to get message count AND IF count=1, get the message
3918: FND_MSG_PUB.Count_And_Get (

Line 4010: OZF_UTILITY_PVT.debug_message(l_full_name||': Start');

4006: END IF;
4007:
4008: -- Debug Message
4009: IF OZF_DEBUG_HIGH_ON THEN
4010: OZF_UTILITY_PVT.debug_message(l_full_name||': Start');
4011: END IF;
4012:
4013: --Initialize message LIST IF p_init_msg_LIST IS TRUE.
4014: IF FND_API.To_Boolean (p_init_msg_LIST) THEN

Line 4030: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_ORG_ID_NOTFOUND');

4026: FETCH g_resale_batch_org_id_csr INTO l_batch_org_id;
4027: CLOSE g_resale_batch_org_id_csr;
4028: l_org_id := MO_GLOBAL.get_valid_org(l_batch_org_id);
4029: IF (l_batch_org_id IS NULL OR l_org_id IS NULL) THEN
4030: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_ORG_ID_NOTFOUND');
4031: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4032: END IF;
4033: -- End: bug # 5997978 fixed
4034:

Line 4071: OZF_UTILITY_PVT.debug_message(l_full_name||': End');

4067: px_org_id => l_org_id);
4068:
4069: -- Debug Message
4070: IF OZF_DEBUG_HIGH_ON THEN
4071: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
4072: END IF;
4073:
4074: --Standard call to get message count AND IF count=1, get the message
4075: FND_MSG_PUB.Count_And_Get (

Line 4160: OZF_UTILITY_PVT.debug_message(l_full_name||': Start');

4156: END IF;
4157:
4158: -- Debug Message
4159: IF OZF_DEBUG_HIGH_ON THEN
4160: OZF_UTILITY_PVT.debug_message(l_full_name||': Start');
4161: END IF;
4162:
4163: --Initialize message LIST IF p_init_msg_LIST IS TRUE.
4164: IF FND_API.To_Boolean (p_init_msg_LIST) THEN

Line 4188: OZF_UTILITY_PVT.debug_message(l_full_name||': End');

4184: );
4185:
4186: -- Debug Message
4187: IF OZF_DEBUG_HIGH_ON THEN
4188: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
4189: END IF;
4190:
4191: --Standard call to get message count AND IF count=1, get the message
4192: FND_MSG_PUB.Count_And_Get (

Line 4297: OZF_UTILITY_PVT.debug_message(l_full_name||': Start');

4293: END IF;
4294:
4295: -- Debug Message
4296: IF OZF_DEBUG_HIGH_ON THEN
4297: OZF_UTILITY_PVT.debug_message(l_full_name||': Start');
4298: END IF;
4299:
4300: x_return_status := FND_API.g_ret_sts_success;
4301:

Line 4305: OZF_UTILITY_PVT.debug_message('NAME '|| px_party_rec.name);

4301:
4302: -- Create Organization
4303: IF px_party_rec.name IS NOT NULL THEN
4304: IF OZF_DEBUG_LOW_ON THEN
4305: OZF_UTILITY_PVT.debug_message('NAME '|| px_party_rec.name);
4306: END IF;
4307: l_organization_rec.organization_name := px_party_rec.name;
4308: -- Bug 4630628 (+)
4309: --l_organization_rec.created_by_module := 'TCA_V2_API';

Line 4331: OZF_UTILITY_PVT.debug_message('Party Id '||px_party_rec.party_id);

4327: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4329: END IF;
4330: IF OZF_DEBUG_LOW_ON THEN
4331: OZF_UTILITY_PVT.debug_message('Party Id '||px_party_rec.party_id);
4332: END IF;
4333: END IF;
4334:
4335: -- Create Location

Line 4362: OZF_UTILITY_PVT.debug_message('Location ID '|| l_location_id);

4358: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4360: END IF;
4361: IF OZF_DEBUG_LOW_ON THEN
4362: OZF_UTILITY_PVT.debug_message('Location ID '|| l_location_id);
4363: END IF;
4364: END IF;
4365:
4366: -- Create Party Site

Line 4394: OZF_UTILITY_PVT.debug_message('Party Site ID '|| px_party_rec.party_site_id);

4390: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4392: END IF;
4393: IF OZF_DEBUG_LOW_ON THEN
4394: OZF_UTILITY_PVT.debug_message('Party Site ID '|| px_party_rec.party_site_id);
4395: END IF;
4396: END IF;
4397:
4398: -- Create Party Site Use

Line 4429: OZF_UTILITY_PVT.debug_message('Party Site Use ID '|| px_party_rec.party_site_use_id);

4425: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4427: END IF;
4428: IF OZF_DEBUG_LOW_ON THEN
4429: OZF_UTILITY_PVT.debug_message('Party Site Use ID '|| px_party_rec.party_site_use_id);
4430: END IF;
4431: END IF;
4432:
4433: -- Create Relationship

Line 4471: OZF_UTILITY_PVT.debug_message('Relationship ID '|| l_relationship_id);

4467: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4468: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4469: END IF;
4470: IF OZF_DEBUG_LOW_ON THEN
4471: OZF_UTILITY_PVT.debug_message('Relationship ID '|| l_relationship_id);
4472: END IF;
4473: END IF;
4474:
4475:

Line 4479: OZF_UTILITY_PVT.debug_message(l_full_name||': End');

4475:
4476:
4477: -- Debug Message
4478: IF OZF_DEBUG_HIGH_ON THEN
4479: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
4480: END IF;
4481: --Standard call to get message count AND IF count=1, get the message
4482: FND_MSG_PUB.Count_And_Get (
4483: p_encoded => FND_API.G_FALSE,

Line 4505: OZF_UTILITY_PVT.debug_message('SQLERRM '|| sqlerrm);

4501: p_count => x_msg_count,
4502: p_data => x_msg_data
4503: );
4504: WHEN OTHERS THEN
4505: OZF_UTILITY_PVT.debug_message('SQLERRM '|| sqlerrm);
4506:
4507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4508: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4509: THEN

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

4556:
4557: BEGIN
4558: -- Debug Message
4559: IF OZF_DEBUG_HIGH_ON THEN
4560: ozf_utility_pvt.debug_message(l_full_name||': start');
4561: END IF;
4562:
4563: IF NOT FND_API.Compatible_API_Call (
4564: l_api_version,

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

4725: );
4726:
4727: -- Debug Message
4728: IF OZF_DEBUG_HIGH_ON THEN
4729: ozf_utility_pvt.debug_message(l_full_name||': end');
4730: END IF;
4731: EXCEPTION
4732: WHEN FND_API.G_EXC_ERROR THEN
4733: x_return_status := FND_API.G_RET_STS_ERROR;