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

Line 49: ozf_utility_pvt.debug_message('Role: ' || l_role_name );

45: p_display_name => l_role_display_name );
46: END IF;
47:
48: IF G_DEBUG_HIGH_ON THEN
49: ozf_utility_pvt.debug_message('Role: ' || l_role_name );
50: ozf_utility_pvt.debug_message('Role Name: ' || l_role_display_name );
51: END IF;
52:
53: return l_role_name;

Line 50: ozf_utility_pvt.debug_message('Role Name: ' || l_role_display_name );

46: END IF;
47:
48: IF G_DEBUG_HIGH_ON THEN
49: ozf_utility_pvt.debug_message('Role: ' || l_role_name );
50: ozf_utility_pvt.debug_message('Role Name: ' || l_role_display_name );
51: END IF;
52:
53: return l_role_name;
54:

Line 154: OZF_UTILITY_PVT.debug_message('Private Api: ' || l_api_name || ' START');

150:
151: BEGIN
152:
153: IF G_DEBUG_HIGH_ON THEN
154: OZF_UTILITY_PVT.debug_message('Private Api: ' || l_api_name || ' START');
155: END IF;
156: IF NOT FND_API.Compatible_API_Call
157: (l_api_version_number
158: ,p_api_version_number

Line 172: OZF_UTILITY_PVT.debug_message('p_utilization_id: ' || p_utilization_id);

168: p_budget_id <> FND_API.G_MISS_NUM
169: THEN
170: --7491702
171: IF G_DEBUG_HIGH_ON THEN
172: OZF_UTILITY_PVT.debug_message('p_utilization_id: ' || p_utilization_id);
173: END IF;
174:
175: OPEN get_util_org_csr;
176: FETCH get_util_org_csr INTO l_org_id;

Line 180: OZF_UTILITY_PVT.debug_message('l_org_id: ' || l_org_id);

176: FETCH get_util_org_csr INTO l_org_id;
177: CLOSE get_util_org_csr;
178:
179: IF G_DEBUG_HIGH_ON THEN
180: OZF_UTILITY_PVT.debug_message('l_org_id: ' || l_org_id);
181: END IF;
182: -- get default accounts from system parameters
183: OPEN get_sys_param_csr(l_org_id);
184: FETCH get_sys_param_csr INTO l_expense_account,

Line 191: OZF_UTILITY_PVT.debug_message('l_expense_account: ' || l_expense_account);

187: l_rec_clearing;
188: CLOSE get_sys_param_csr;
189:
190: IF G_DEBUG_HIGH_ON THEN
191: OZF_UTILITY_PVT.debug_message('l_expense_account: ' || l_expense_account);
192: OZF_UTILITY_PVT.debug_message('l_accrual_liability: ' || l_accrual_liability);
193: OZF_UTILITY_PVT.debug_message('l_ven_clearing: ' || l_ven_clearing);
194: OZF_UTILITY_PVT.debug_message('l_rec_clearing: ' || l_rec_clearing);
195: END IF;

Line 192: OZF_UTILITY_PVT.debug_message('l_accrual_liability: ' || l_accrual_liability);

188: CLOSE get_sys_param_csr;
189:
190: IF G_DEBUG_HIGH_ON THEN
191: OZF_UTILITY_PVT.debug_message('l_expense_account: ' || l_expense_account);
192: OZF_UTILITY_PVT.debug_message('l_accrual_liability: ' || l_accrual_liability);
193: OZF_UTILITY_PVT.debug_message('l_ven_clearing: ' || l_ven_clearing);
194: OZF_UTILITY_PVT.debug_message('l_rec_clearing: ' || l_rec_clearing);
195: END IF;
196:

Line 193: OZF_UTILITY_PVT.debug_message('l_ven_clearing: ' || l_ven_clearing);

189:
190: IF G_DEBUG_HIGH_ON THEN
191: OZF_UTILITY_PVT.debug_message('l_expense_account: ' || l_expense_account);
192: OZF_UTILITY_PVT.debug_message('l_accrual_liability: ' || l_accrual_liability);
193: OZF_UTILITY_PVT.debug_message('l_ven_clearing: ' || l_ven_clearing);
194: OZF_UTILITY_PVT.debug_message('l_rec_clearing: ' || l_rec_clearing);
195: END IF;
196:
197: OPEN get_fund_accounts_csr(p_budget_id);

Line 194: OZF_UTILITY_PVT.debug_message('l_rec_clearing: ' || l_rec_clearing);

190: IF G_DEBUG_HIGH_ON THEN
191: OZF_UTILITY_PVT.debug_message('l_expense_account: ' || l_expense_account);
192: OZF_UTILITY_PVT.debug_message('l_accrual_liability: ' || l_accrual_liability);
193: OZF_UTILITY_PVT.debug_message('l_ven_clearing: ' || l_ven_clearing);
194: OZF_UTILITY_PVT.debug_message('l_rec_clearing: ' || l_rec_clearing);
195: END IF;
196:
197: OPEN get_fund_accounts_csr(p_budget_id);
198: FETCH get_fund_accounts_csr INTO l_fund_expense_account,

Line 292: OZF_UTILITY_PVT.debug_message('Private Api: ' || l_api_name || ' END');

288: (p_count => x_msg_count,
289: p_data => x_msg_data);
290:
291: IF G_DEBUG_HIGH_ON THEN
292: OZF_UTILITY_PVT.debug_message('Private Api: ' || l_api_name || ' END');
293: END IF;
294: RETURN l_post_account;
295:
296: EXCEPTION

Line 482: OZF_UTILITY_PVT.debug_message('Private Api: ' || l_full_name || ' START');

478: AND object_type = 'TP_ORDER';
479:
480: BEGIN
481: IF G_DEBUG_HIGH_ON THEN
482: OZF_UTILITY_PVT.debug_message('Private Api: ' || l_full_name || ' START');
483: END IF;
484: IF NOT FND_API.Compatible_API_Call
485: (l_api_version_number
486: ,p_api_version_number

Line 501: OZF_UTILITY_PVT.debug_message('Retreiving Chart Of Accounts Id');

497: -- Initialize API return status to sucess
498: x_return_status := FND_API.G_RET_STS_SUCCESS;
499:
500: IF G_DEBUG_HIGH_ON THEN
501: OZF_UTILITY_PVT.debug_message('Retreiving Chart Of Accounts Id');
502: END IF;
503: /* get org id */
504: IF p_budget_id <> FND_API.G_MISS_NUM OR
505: p_budget_id IS NOT NULL

Line 522: OZF_UTILITY_PVT.debug_message('l_chart_of_accounts_id '||l_chart_of_accounts_id);

518: FETCH chart_of_acct_csr INTO l_chart_of_accounts_id;
519: CLOSE chart_of_acct_csr;*/
520:
521: IF G_DEBUG_HIGH_ON THEN
522: OZF_UTILITY_PVT.debug_message('l_chart_of_accounts_id '||l_chart_of_accounts_id);
523: END IF;
524:
525: IF l_chart_of_accounts_id is null THEN
526: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 534: OZF_UTILITY_PVT.debug_message('B4 calling gl_post_account ');

530: RAISE FND_API.G_EXC_ERROR;
531: END IF;
532:
533: IF G_DEBUG_HIGH_ON THEN
534: OZF_UTILITY_PVT.debug_message('B4 calling gl_post_account ');
535: OZF_UTILITY_PVT.debug_message('p_utilization_id '||p_utilization_id);
536: OZF_UTILITY_PVT.debug_message('p_budget_id '|| p_budget_id);
537: END IF;
538:

Line 535: OZF_UTILITY_PVT.debug_message('p_utilization_id '||p_utilization_id);

531: END IF;
532:
533: IF G_DEBUG_HIGH_ON THEN
534: OZF_UTILITY_PVT.debug_message('B4 calling gl_post_account ');
535: OZF_UTILITY_PVT.debug_message('p_utilization_id '||p_utilization_id);
536: OZF_UTILITY_PVT.debug_message('p_budget_id '|| p_budget_id);
537: END IF;
538:
539: /* This will retrieve the account_id for gl_posting purposes*/

Line 536: OZF_UTILITY_PVT.debug_message('p_budget_id '|| p_budget_id);

532:
533: IF G_DEBUG_HIGH_ON THEN
534: OZF_UTILITY_PVT.debug_message('B4 calling gl_post_account ');
535: OZF_UTILITY_PVT.debug_message('p_utilization_id '||p_utilization_id);
536: OZF_UTILITY_PVT.debug_message('p_budget_id '|| p_budget_id);
537: END IF;
538:
539: /* This will retrieve the account_id for gl_posting purposes*/
540: l_account_id := gl_post_account(p_api_version_number => 1.0,

Line 549: OZF_UTILITY_PVT.debug_message('After gl_post_account ');

545: x_msg_data => x_msg_data,
546: x_return_status => x_return_status);
547:
548: IF G_DEBUG_HIGH_ON THEN
549: OZF_UTILITY_PVT.debug_message('After gl_post_account ');
550: OZF_UTILITY_PVT.debug_message('l_account_id '|| l_account_id);
551: END IF;
552:
553: IF x_return_status = FND_API.g_ret_sts_error THEN

Line 550: OZF_UTILITY_PVT.debug_message('l_account_id '|| l_account_id);

546: x_return_status => x_return_status);
547:
548: IF G_DEBUG_HIGH_ON THEN
549: OZF_UTILITY_PVT.debug_message('After gl_post_account ');
550: OZF_UTILITY_PVT.debug_message('l_account_id '|| l_account_id);
551: END IF;
552:
553: IF x_return_status = FND_API.g_ret_sts_error THEN
554: RAISE FND_API.G_EXC_ERROR;

Line 596: OZF_UTILITY_PVT.debug_message('Checking Order Category');

592: IF l_line_id <> FND_API.G_MISS_NUM OR
593: l_line_id IS NOT NULL
594: THEN
595: IF G_DEBUG_HIGH_ON THEN
596: OZF_UTILITY_PVT.debug_message('Checking Order Category');
597: END IF;
598: OPEN order_line_csr(l_line_id);
599: FETCH order_line_csr INTO l_reference_line_id, l_line_category_code;
600: CLOSE order_line_csr;

Line 610: OZF_UTILITY_PVT.debug_message('Retreiving Line Header');

606: l_line_id := l_reference_line_id;
607: END IF;
608:
609: IF G_DEBUG_HIGH_ON THEN
610: OZF_UTILITY_PVT.debug_message('Retreiving Line Header');
611: END IF;
612: /* Retreive the header and line details */
613: OPEN line_detail_csr(l_line_id);
614: FETCH line_detail_csr

Line 647: OZF_UTILITY_PVT.debug_message('Retreiving Order Category');

643: l_ship_from_org_id := l_org_id;
644: END IF;
645:
646: IF G_DEBUG_HIGH_ON THEN
647: OZF_UTILITY_PVT.debug_message('Retreiving Order Category');
648: END IF;
649: /* Retreive Order category and order type */
650: OPEN order_header_csr(l_header_id);
651: FETCH order_header_csr INTO l_order_category_code, l_order_type_id;

Line 655: OZF_UTILITY_PVT.debug_message('Retreiving Chart Of Accounts Id');

651: FETCH order_header_csr INTO l_order_category_code, l_order_type_id;
652: CLOSE order_header_csr;
653:
654: IF G_DEBUG_HIGH_ON THEN
655: OZF_UTILITY_PVT.debug_message('Retreiving Chart Of Accounts Id');
656: END IF;
657: /* Retreive the Chart of accounts Id */
658: OPEN chart_of_acct_csr(l_ship_from_org_id);
659: FETCH chart_of_acct_csr INTO l_chart_of_accounts_id;

Line 667: OZF_UTILITY_PVT.debug_message('Retreiving Header');

663: ELSIF l_header_id <> FND_API.G_MISS_NUM OR
664: l_header_id IS NOT NULL
665: THEN
666: IF G_DEBUG_HIGH_ON THEN
667: OZF_UTILITY_PVT.debug_message('Retreiving Header');
668: END IF;
669: /* Retreive the header and line details */
670: OPEN header_detail_csr(l_header_id);
671: FETCH header_detail_csr

Line 680: OZF_UTILITY_PVT.debug_message('Retreiving Order Category');

676: l_salesrep_id;
677: CLOSE header_detail_csr;
678:
679: IF G_DEBUG_HIGH_ON THEN
680: OZF_UTILITY_PVT.debug_message('Retreiving Order Category');
681: END IF;
682: /* Retreive Order category and order type */
683: OPEN order_header_csr(l_header_id);
684: FETCH order_header_csr INTO l_order_category_code, l_order_type_id;

Line 700: OZF_UTILITY_PVT.debug_message('Retreiving Chart Of Accounts Id');

696: l_ship_from_org_id := l_org_id;
697: END IF;
698:
699: IF G_DEBUG_HIGH_ON THEN
700: OZF_UTILITY_PVT.debug_message('Retreiving Chart Of Accounts Id');
701: END IF;
702: /* Retreive the Chart of accounts Id */
703: OPEN chart_of_acct_csr(l_ship_from_org_id);
704: FETCH chart_of_acct_csr INTO l_chart_of_accounts_id;

Line 740: OZF_UTILITY_PVT.debug_message('Item Key: ' || l_itemkey);

736: l_chart_of_accounts_id,
737: 'OZFACCTG');
738:
739: IF G_DEBUG_HIGH_ON THEN
740: OZF_UTILITY_PVT.debug_message('Item Key: ' || l_itemkey);
741: END IF;
742:
743: wf_engine.SetItemAttrNumber(itemtype => l_itemtype,
744: itemkey => l_itemkey,

Line 853: OZF_UTILITY_PVT.debug_message('Debug Flag: ' || l_debug_flag );

849: l_debug_flag := fnd_profile.value('ACCOUNT_GENERATOR:DEBUG_MODE');
850: l_default_gl_account := NVL(fnd_profile.value('OZF_DEFAULT_ACCOUNTS_ON_ACCTGEN_FAILURE'),'Y');
851:
852: IF G_DEBUG_HIGH_ON THEN
853: OZF_UTILITY_PVT.debug_message('Debug Flag: ' || l_debug_flag );
854: OZF_UTILITY_PVT.debug_message('Default GL Accounts profile: ' || l_default_gl_account);
855: END IF;
856:
857: IF l_debug_flag = 'Y' THEN

Line 854: OZF_UTILITY_PVT.debug_message('Default GL Accounts profile: ' || l_default_gl_account);

850: l_default_gl_account := NVL(fnd_profile.value('OZF_DEFAULT_ACCOUNTS_ON_ACCTGEN_FAILURE'),'Y');
851:
852: IF G_DEBUG_HIGH_ON THEN
853: OZF_UTILITY_PVT.debug_message('Debug Flag: ' || l_debug_flag );
854: OZF_UTILITY_PVT.debug_message('Default GL Accounts profile: ' || l_default_gl_account);
855: END IF;
856:
857: IF l_debug_flag = 'Y' THEN
858:

Line 874: OZF_UTILITY_PVT.debug_message('submitting the fnd_flex_workflow_generate process');

870: ,context_id => null
871: );
872:
873: IF G_DEBUG_HIGH_ON THEN
874: OZF_UTILITY_PVT.debug_message('submitting the fnd_flex_workflow_generate process');
875: END IF;
876: l_result := Fnd_Flex_Workflow.GENERATE('OZFACCTG',
877: l_itemkey,
878: TRUE,

Line 888: OZF_UTILITY_PVT.debug_message('Success OZFACCTG WF'||'-'||x_return_ccid);

884: l_new_comb);
885:
886: IF l_result THEN
887: IF G_DEBUG_HIGH_ON THEN
888: OZF_UTILITY_PVT.debug_message('Success OZFACCTG WF'||'-'||x_return_ccid);
889: END IF;
890: x_return_status := FND_API.G_RET_STS_SUCCESS;
891:
892: ELSE

Line 903: OZF_UTILITY_PVT.debug_message('Returning Default on Error'||'-'||l_account_id);

899: flag set to Yes, the GL posting will happen to accounts derived from Account Generator workflow.
900: */
901: IF l_default_gl_account = 'Y' THEN
902: IF G_DEBUG_HIGH_ON THEN
903: OZF_UTILITY_PVT.debug_message('Returning Default on Error'||'-'||l_account_id);
904: END IF;
905: x_return_ccid := l_account_id;
906: x_return_status := FND_API.G_RET_STS_SUCCESS;
907:

Line 911: OZF_UTILITY_PVT.debug_message('Error in OZFACCTG WF'||'-'||x_return_ccid);

907:
908: ELSE
909:
910: IF G_DEBUG_HIGH_ON THEN
911: OZF_UTILITY_PVT.debug_message('Error in OZFACCTG WF'||'-'||x_return_ccid);
912: END IF;
913: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
914: FND_MESSAGE.SET_NAME('OZF','OZF_GL_ACC_GEN_FAILED');
915: FND_MSG_PUB.ADD;

Line 924: OZF_UTILITY_PVT.debug_message('Final Account Returned'||'-'||x_return_ccid);

920:
921: END IF; --IF l_result THEN
922:
923: IF G_DEBUG_HIGH_ON THEN
924: OZF_UTILITY_PVT.debug_message('Final Account Returned'||'-'||x_return_ccid);
925: END IF;
926: --Incase of Success also it was returning the default CCID
927: --x_return_ccid := l_account_id;
928: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 931: OZF_UTILITY_PVT.debug_message('Private Api: ' || l_api_name || ' END');

927: --x_return_ccid := l_account_id;
928: x_return_status := FND_API.G_RET_STS_SUCCESS;
929: --END IF;
930: IF G_DEBUG_HIGH_ON THEN
931: OZF_UTILITY_PVT.debug_message('Private Api: ' || l_api_name || ' END');
932: END IF;
933: --Standard call to get message count and if count=1, get the message
934: FND_MSG_PUB.Count_And_Get (
935: p_encoded => FND_API.G_FALSE,

Line 1027: OZF_UTILITY_PVT.debug_message('Private Api: ' || l_api_name || ' START');

1023: AND ORGANIZATION_ID = P_ORGANIZATION_ID;
1024:
1025: BEGIN
1026: IF G_DEBUG_HIGH_ON THEN
1027: OZF_UTILITY_PVT.debug_message('Private Api: ' || l_api_name || ' START');
1028: END IF;
1029:
1030: IF (FUNCMODE = 'RUN') THEN
1031: l_line_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'LINE_ID');

Line 1041: OZF_UTILITY_PVT.debug_message('line_id = ' || l_line_id);

1037: 'INVENTORY_ITEM_ID');
1038: l_cost_sale_item_derived := NULL;
1039:
1040: IF G_DEBUG_HIGH_ON THEN
1041: OZF_UTILITY_PVT.debug_message('line_id = ' || l_line_id);
1042: OZF_UTILITY_PVT.debug_message('organization_id = ' || l_organization_id);
1043: OZF_UTILITY_PVT.debug_message('inventory_item_id = ' || l_inventory_item_id);
1044: END IF;
1045:

Line 1042: OZF_UTILITY_PVT.debug_message('organization_id = ' || l_organization_id);

1038: l_cost_sale_item_derived := NULL;
1039:
1040: IF G_DEBUG_HIGH_ON THEN
1041: OZF_UTILITY_PVT.debug_message('line_id = ' || l_line_id);
1042: OZF_UTILITY_PVT.debug_message('organization_id = ' || l_organization_id);
1043: OZF_UTILITY_PVT.debug_message('inventory_item_id = ' || l_inventory_item_id);
1044: END IF;
1045:
1046: IF l_line_id IS NOT NULL THEN

Line 1043: OZF_UTILITY_PVT.debug_message('inventory_item_id = ' || l_inventory_item_id);

1039:
1040: IF G_DEBUG_HIGH_ON THEN
1041: OZF_UTILITY_PVT.debug_message('line_id = ' || l_line_id);
1042: OZF_UTILITY_PVT.debug_message('organization_id = ' || l_organization_id);
1043: OZF_UTILITY_PVT.debug_message('inventory_item_id = ' || l_inventory_item_id);
1044: END IF;
1045:
1046: IF l_line_id IS NOT NULL THEN
1047: OPEN cost_of_sales_acct_csr(l_line_id);

Line 1135: OZF_UTILITY_PVT.debug_message('Private Api: ' || l_api_name || 'END');

1131: result := '';
1132: RETURN;
1133: END IF;
1134: IF G_DEBUG_HIGH_ON THEN
1135: OZF_UTILITY_PVT.debug_message('Private Api: ' || l_api_name || 'END');
1136: END IF;
1137:
1138: EXCEPTION
1139: WHEN OTHERS THEN