DBA Data[Home] [Help]

APPS.OZF_ACCT_GENERATOR dependencies on OZF_UTILITY_PVT

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

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

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

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

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

117:
118: BEGIN
119:
120: IF G_DEBUG_HIGH_ON THEN
121: OZF_UTILITY_PVT.debug_message('Private Api: ' || l_api_name || ' START');
122: END IF;
123: IF NOT FND_API.Compatible_API_Call
124: (l_api_version_number
125: ,p_api_version_number

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

222: (p_count => x_msg_count,
223: p_data => x_msg_data);
224:
225: IF G_DEBUG_HIGH_ON THEN
226: OZF_UTILITY_PVT.debug_message('Private Api: ' || l_api_name || ' END');
227: END IF;
228: RETURN l_post_account;
229:
230: EXCEPTION

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

402: AND object_type = 'TP_ORDER';
403:
404: BEGIN
405: IF G_DEBUG_HIGH_ON THEN
406: OZF_UTILITY_PVT.debug_message('Private Api: ' || l_full_name || ' START');
407: END IF;
408: IF NOT FND_API.Compatible_API_Call
409: (l_api_version_number
410: ,p_api_version_number

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

421: -- Initialize API return status to sucess
422: x_return_status := FND_API.G_RET_STS_SUCCESS;
423:
424: IF G_DEBUG_HIGH_ON THEN
425: OZF_UTILITY_PVT.debug_message('Retreiving Chart Of Accounts Id');
426: END IF;
427: /* get org id */
428: IF p_budget_id <> FND_API.G_MISS_NUM OR
429: p_budget_id IS NOT NULL

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

495: IF l_line_id <> FND_API.G_MISS_NUM OR
496: l_line_id IS NOT NULL
497: THEN
498: IF G_DEBUG_HIGH_ON THEN
499: OZF_UTILITY_PVT.debug_message('Checking Order Category');
500: END IF;
501: OPEN order_line_csr(l_line_id);
502: FETCH order_line_csr INTO l_reference_line_id, l_line_category_code;
503: CLOSE order_line_csr;

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

509: l_line_id := l_reference_line_id;
510: END IF;
511:
512: IF G_DEBUG_HIGH_ON THEN
513: OZF_UTILITY_PVT.debug_message('Retreiving Line Header');
514: END IF;
515: /* Retreive the header and line details */
516: OPEN line_detail_csr(l_line_id);
517: FETCH line_detail_csr

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

546: l_ship_from_org_id := l_org_id;
547: END IF;
548:
549: IF G_DEBUG_HIGH_ON THEN
550: OZF_UTILITY_PVT.debug_message('Retreiving Order Category');
551: END IF;
552: /* Retreive Order category and order type */
553: OPEN order_header_csr(l_header_id);
554: FETCH order_header_csr INTO l_order_category_code, l_order_type_id;

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

554: FETCH order_header_csr INTO l_order_category_code, l_order_type_id;
555: CLOSE order_header_csr;
556:
557: IF G_DEBUG_HIGH_ON THEN
558: OZF_UTILITY_PVT.debug_message('Retreiving Chart Of Accounts Id');
559: END IF;
560: /* Retreive the Chart of accounts Id */
561: OPEN chart_of_acct_csr(l_ship_from_org_id);
562: FETCH chart_of_acct_csr INTO l_chart_of_accounts_id;

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

566: ELSIF l_header_id <> FND_API.G_MISS_NUM OR
567: l_header_id IS NOT NULL
568: THEN
569: IF G_DEBUG_HIGH_ON THEN
570: OZF_UTILITY_PVT.debug_message('Retreiving Header');
571: END IF;
572: /* Retreive the header and line details */
573: OPEN header_detail_csr(l_header_id);
574: FETCH header_detail_csr

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

579: l_salesrep_id;
580: CLOSE header_detail_csr;
581:
582: IF G_DEBUG_HIGH_ON THEN
583: OZF_UTILITY_PVT.debug_message('Retreiving Order Category');
584: END IF;
585: /* Retreive Order category and order type */
586: OPEN order_header_csr(l_header_id);
587: FETCH order_header_csr INTO l_order_category_code, l_order_type_id;

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

599: l_ship_from_org_id := l_org_id;
600: END IF;
601:
602: IF G_DEBUG_HIGH_ON THEN
603: OZF_UTILITY_PVT.debug_message('Retreiving Chart Of Accounts Id');
604: END IF;
605: /* Retreive the Chart of accounts Id */
606: OPEN chart_of_acct_csr(l_ship_from_org_id);
607: FETCH chart_of_acct_csr INTO l_chart_of_accounts_id;

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

639: l_chart_of_accounts_id,
640: 'OZFACCTG');
641:
642: IF G_DEBUG_HIGH_ON THEN
643: OZF_UTILITY_PVT.debug_message('Item Key: ' || l_itemkey);
644: END IF;
645:
646: wf_engine.SetItemAttrNumber(itemtype => l_itemtype,
647: itemkey => l_itemkey,

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

751:
752: l_debug_flag := fnd_profile.value('ACCOUNT_GENERATOR:DEBUG_MODE');
753:
754: IF G_DEBUG_HIGH_ON THEN
755: OZF_UTILITY_PVT.debug_message('Debug Flag: ' || l_debug_flag );
756: END IF;
757:
758: IF l_debug_flag = 'Y' THEN
759:

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

764: owner => l_role_name);
765: END IF;
766:
767: IF G_DEBUG_HIGH_ON THEN
768: OZF_UTILITY_PVT.debug_message('submitting the fnd_flex_workflow_generate process');
769: END IF;
770: l_result := Fnd_Flex_Workflow.GENERATE('OZFACCTG',
771: l_itemkey,
772: TRUE,

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

778: l_new_comb);
779:
780: IF l_result THEN
781: IF G_DEBUG_HIGH_ON THEN
782: OZF_UTILITY_PVT.debug_message('Success OZFACCTG WF'||'-'||x_return_ccid);
783: END IF;
784: x_return_status := FND_API.G_RET_STS_SUCCESS;
785: ELSE
786: IF l_debug_flag = 'Y' THEN

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

784: x_return_status := FND_API.G_RET_STS_SUCCESS;
785: ELSE
786: IF l_debug_flag = 'Y' THEN
787: IF G_DEBUG_HIGH_ON THEN
788: OZF_UTILITY_PVT.debug_message('Returning Default on Error'||'-'||l_account_id);
789: END IF;
790: x_return_ccid := l_account_id;
791: x_return_status := FND_API.G_RET_STS_SUCCESS;
792: ELSE

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

790: x_return_ccid := l_account_id;
791: x_return_status := FND_API.G_RET_STS_SUCCESS;
792: ELSE
793: IF G_DEBUG_HIGH_ON THEN
794: OZF_UTILITY_PVT.debug_message('Error in OZFACCTG WF'||'-'||x_return_ccid);
795: END IF;
796: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
797: FND_MESSAGE.SET_NAME('OZF','OZF_GL_ACC_GEN_FAILED');
798: FND_MSG_PUB.ADD;

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

801: END IF;
802: END IF;
803:
804: IF G_DEBUG_HIGH_ON THEN
805: OZF_UTILITY_PVT.debug_message('Private Api: ' || l_api_name || ' END');
806: END IF;
807: --Standard call to get message count and if count=1, get the message
808: FND_MSG_PUB.Count_And_Get (
809: p_encoded => FND_API.G_FALSE,

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

897: AND ORGANIZATION_ID = P_ORGANIZATION_ID;
898:
899: BEGIN
900: IF G_DEBUG_HIGH_ON THEN
901: OZF_UTILITY_PVT.debug_message('Private Api: ' || l_api_name || ' START');
902: END IF;
903:
904: IF (FUNCMODE = 'RUN') THEN
905: l_line_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'LINE_ID');

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

911: 'INVENTORY_ITEM_ID');
912: l_cost_sale_item_derived := NULL;
913:
914: IF G_DEBUG_HIGH_ON THEN
915: OZF_UTILITY_PVT.debug_message('line_id = ' || l_line_id);
916: OZF_UTILITY_PVT.debug_message('organization_id = ' || l_organization_id);
917: OZF_UTILITY_PVT.debug_message('inventory_item_id = ' || l_inventory_item_id);
918: END IF;
919:

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

912: l_cost_sale_item_derived := NULL;
913:
914: IF G_DEBUG_HIGH_ON THEN
915: OZF_UTILITY_PVT.debug_message('line_id = ' || l_line_id);
916: OZF_UTILITY_PVT.debug_message('organization_id = ' || l_organization_id);
917: OZF_UTILITY_PVT.debug_message('inventory_item_id = ' || l_inventory_item_id);
918: END IF;
919:
920: IF l_line_id IS NOT NULL THEN

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

913:
914: IF G_DEBUG_HIGH_ON THEN
915: OZF_UTILITY_PVT.debug_message('line_id = ' || l_line_id);
916: OZF_UTILITY_PVT.debug_message('organization_id = ' || l_organization_id);
917: OZF_UTILITY_PVT.debug_message('inventory_item_id = ' || l_inventory_item_id);
918: END IF;
919:
920: IF l_line_id IS NOT NULL THEN
921: OPEN cost_of_sales_acct_csr(l_line_id);

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

1005: result := '';
1006: RETURN;
1007: END IF;
1008: IF G_DEBUG_HIGH_ON THEN
1009: OZF_UTILITY_PVT.debug_message('Private Api: ' || l_api_name || 'END');
1010: END IF;
1011:
1012: EXCEPTION
1013: WHEN OTHERS THEN