DBA Data[Home] [Help]

APPS.ASO_CFG_INT dependencies on ASO_UTILITY_PVT

Line 83: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

79: x_shipment_tbl => x_shipment_tbl );
80:
81: EXCEPTION
82: WHEN FND_API.G_EXC_ERROR THEN
83: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
84: P_API_NAME => L_API_NAME
85: ,P_PKG_NAME => G_PKG_NAME
86: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
87: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

Line 87: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

83: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
84: P_API_NAME => L_API_NAME
85: ,P_PKG_NAME => G_PKG_NAME
86: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
87: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
88: ,X_MSG_COUNT => X_MSG_COUNT
89: ,X_MSG_DATA => X_MSG_DATA
90: ,X_RETURN_STATUS => X_RETURN_STATUS);
91:

Line 93: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

89: ,X_MSG_DATA => X_MSG_DATA
90: ,X_RETURN_STATUS => X_RETURN_STATUS);
91:
92: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
93: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
94: P_API_NAME => L_API_NAME
95: ,P_PKG_NAME => G_PKG_NAME
96: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
97: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

Line 97: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

93: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
94: P_API_NAME => L_API_NAME
95: ,P_PKG_NAME => G_PKG_NAME
96: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
97: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
98: ,X_MSG_COUNT => X_MSG_COUNT
99: ,X_MSG_DATA => X_MSG_DATA
100: ,X_RETURN_STATUS => X_RETURN_STATUS);
101:

Line 103: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

99: ,X_MSG_DATA => X_MSG_DATA
100: ,X_RETURN_STATUS => X_RETURN_STATUS);
101:
102: WHEN OTHERS THEN
103: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
104: P_API_NAME => L_API_NAME
105: ,P_PKG_NAME => G_PKG_NAME
106: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
107: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

Line 106: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

102: WHEN OTHERS THEN
103: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
104: P_API_NAME => L_API_NAME
105: ,P_PKG_NAME => G_PKG_NAME
106: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
107: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
108: ,X_MSG_COUNT => X_MSG_COUNT
109: ,X_MSG_DATA => X_MSG_DATA
110: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 107: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

103: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
104: P_API_NAME => L_API_NAME
105: ,P_PKG_NAME => G_PKG_NAME
106: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
107: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
108: ,X_MSG_COUNT => X_MSG_COUNT
109: ,X_MSG_DATA => X_MSG_DATA
110: ,X_RETURN_STATUS => X_RETURN_STATUS);
111:

Line 356: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS( P_API_NAME => L_API_NAME,

352: EXCEPTION
353:
354: WHEN FND_API.G_EXC_ERROR THEN
355:
356: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS( P_API_NAME => L_API_NAME,
357: P_PKG_NAME => G_PKG_NAME,
358: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
359: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,
360: X_MSG_COUNT => X_MSG_COUNT,

Line 359: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,

355:
356: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS( P_API_NAME => L_API_NAME,
357: P_PKG_NAME => G_PKG_NAME,
358: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
359: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,
360: X_MSG_COUNT => X_MSG_COUNT,
361: X_MSG_DATA => X_MSG_DATA,
362: X_RETURN_STATUS => X_RETURN_STATUS);
363:

Line 366: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS( P_API_NAME => L_API_NAME,

362: X_RETURN_STATUS => X_RETURN_STATUS);
363:
364: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
365:
366: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS( P_API_NAME => L_API_NAME,
367: P_PKG_NAME => G_PKG_NAME,
368: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
369: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,
370: X_MSG_COUNT => X_MSG_COUNT,

Line 369: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,

365:
366: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS( P_API_NAME => L_API_NAME,
367: P_PKG_NAME => G_PKG_NAME,
368: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
369: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,
370: X_MSG_COUNT => X_MSG_COUNT,
371: X_MSG_DATA => X_MSG_DATA,
372: X_RETURN_STATUS => X_RETURN_STATUS);
373:

Line 381: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS( P_API_NAME => L_API_NAME,

377: IF aso_debug_pub.g_debug_flag = 'Y' THEN
378: aso_debug_pub.add('ASO_CFG_INT: copy_configuration: Inside when others exception');
379: END IF;
380:
381: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS( P_API_NAME => L_API_NAME,
382: P_PKG_NAME => G_PKG_NAME,
383: P_SQLERRM => SQLERRM,
384: P_SQLCODE => SQLCODE,
385: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,

Line 385: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,

381: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS( P_API_NAME => L_API_NAME,
382: P_PKG_NAME => G_PKG_NAME,
383: P_SQLERRM => SQLERRM,
384: P_SQLCODE => SQLCODE,
385: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
386: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,
387: X_MSG_COUNT => X_MSG_COUNT,
388: X_MSG_DATA => X_MSG_DATA,
389: X_RETURN_STATUS => X_RETURN_STATUS);

Line 386: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,

382: P_PKG_NAME => G_PKG_NAME,
383: P_SQLERRM => SQLERRM,
384: P_SQLCODE => SQLCODE,
385: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
386: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,
387: X_MSG_COUNT => X_MSG_COUNT,
388: X_MSG_DATA => X_MSG_DATA,
389: X_RETURN_STATUS => X_RETURN_STATUS);
390:

Line 879: := ASO_UTILITY_PVT.Get_Pricing_Control_Rec;

875: l_old_config_hdr_id NUMBER;
876: l_ship_model_complete_flag VARCHAR2(1);
877:
878: l_control_rec ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE
879: := ASO_UTILITY_PVT.Get_Pricing_Control_Rec;
880: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
881: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Qte_Line_Tbl;
882: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Qte_Line_Dtl_Tbl;
883: -- l_qte_line_dtl_search ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Qte_Line_Dtl_Tbl;

Line 982: ASO_UTILITY_PVT.print_login_info;

978:
979: --Procedure added by Anoop Rajan on 30/09/2005 to print login details
980: IF aso_debug_pub.g_debug_flag = 'Y' THEN
981: aso_debug_pub.add('Before call to printing login info details', 1, 'Y');
982: ASO_UTILITY_PVT.print_login_info;
983: aso_debug_pub.add('After call to printing login info details', 1, 'Y');
984: END IF;
985:
986: -- Change Done By Girish

Line 1767: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1763: else
1764: close c_config_exist_in_cz;
1765: end if;
1766:
1767: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1768: P_API_NAME => L_API_NAME
1769: ,P_PKG_NAME => G_PKG_NAME
1770: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1771: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

Line 1771: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

1767: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1768: P_API_NAME => L_API_NAME
1769: ,P_PKG_NAME => G_PKG_NAME
1770: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1771: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
1772: ,X_MSG_COUNT => X_MSG_COUNT
1773: ,X_MSG_DATA => X_MSG_DATA
1774: ,X_RETURN_STATUS => X_RETURN_STATUS);
1775:

Line 1818: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1814: else
1815: close c_config_exist_in_cz;
1816: end if;
1817:
1818: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1819: P_API_NAME => L_API_NAME
1820: ,P_PKG_NAME => G_PKG_NAME
1821: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1822: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

Line 1822: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

1818: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1819: P_API_NAME => L_API_NAME
1820: ,P_PKG_NAME => G_PKG_NAME
1821: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1822: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
1823: ,X_MSG_COUNT => X_MSG_COUNT
1824: ,X_MSG_DATA => X_MSG_DATA
1825: ,X_RETURN_STATUS => X_RETURN_STATUS);
1826:

Line 1869: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1865: else
1866: close c_config_exist_in_cz;
1867: end if;
1868:
1869: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1870: P_API_NAME => L_API_NAME
1871: ,P_PKG_NAME => G_PKG_NAME
1872: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1873: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

Line 1872: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

1868:
1869: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1870: P_API_NAME => L_API_NAME
1871: ,P_PKG_NAME => G_PKG_NAME
1872: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1873: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
1874: ,P_SQLCODE => SQLCODE
1875: ,P_SQLERRM => SQLERRM
1876: ,X_MSG_COUNT => X_MSG_COUNT

Line 1873: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

1869: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1870: P_API_NAME => L_API_NAME
1871: ,P_PKG_NAME => G_PKG_NAME
1872: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1873: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
1874: ,P_SQLCODE => SQLCODE
1875: ,P_SQLERRM => SQLERRM
1876: ,X_MSG_COUNT => X_MSG_COUNT
1877: ,X_MSG_DATA => X_MSG_DATA

Line 2034: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row ( l_quote_header_id );

2030: END IF;
2031:
2032: IF c_quote_hdr_id%FOUND THEN
2033:
2034: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row ( l_quote_header_id );
2035:
2036: -- The following function returns all other rows of the quote which do not belong to
2037: -- this configuration plus the model line itself
2038:

Line 2719: l_model_line_rec := aso_utility_pvt.Query_Qte_Line_Row( P_Qte_Line_Id => p_model_line_id );

2715:
2716: --Initialize API return status to SUCCESS
2717: x_return_status := FND_API.G_RET_STS_SUCCESS;
2718:
2719: l_model_line_rec := aso_utility_pvt.Query_Qte_Line_Row( P_Qte_Line_Id => p_model_line_id );
2720:
2721: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2722: aso_debug_pub.add('Create_hdr_xml: After call to aso_utility_pvt.Query_Qte_Line_Row');
2723: END IF;

Line 2722: aso_debug_pub.add('Create_hdr_xml: After call to aso_utility_pvt.Query_Qte_Line_Row');

2718:
2719: l_model_line_rec := aso_utility_pvt.Query_Qte_Line_Row( P_Qte_Line_Id => p_model_line_id );
2720:
2721: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2722: aso_debug_pub.add('Create_hdr_xml: After call to aso_utility_pvt.Query_Qte_Line_Row');
2723: END IF;
2724:
2725: l_model_line_dtl_tbl := aso_utility_pvt.Query_Line_Dtl_Rows( P_Qte_Line_Id => p_model_line_id );
2726:

Line 2725: l_model_line_dtl_tbl := aso_utility_pvt.Query_Line_Dtl_Rows( P_Qte_Line_Id => p_model_line_id );

2721: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2722: aso_debug_pub.add('Create_hdr_xml: After call to aso_utility_pvt.Query_Qte_Line_Row');
2723: END IF;
2724:
2725: l_model_line_dtl_tbl := aso_utility_pvt.Query_Line_Dtl_Rows( P_Qte_Line_Id => p_model_line_id );
2726:
2727: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2728: aso_debug_pub.add('Create_hdr_xml: After call to aso_utility_pvt.Query_Line_Dtl_Rows');
2729: END IF;

Line 2728: aso_debug_pub.add('Create_hdr_xml: After call to aso_utility_pvt.Query_Line_Dtl_Rows');

2724:
2725: l_model_line_dtl_tbl := aso_utility_pvt.Query_Line_Dtl_Rows( P_Qte_Line_Id => p_model_line_id );
2726:
2727: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2728: aso_debug_pub.add('Create_hdr_xml: After call to aso_utility_pvt.Query_Line_Dtl_Rows');
2729: END IF;
2730:
2731: /* Fix for bug 3998564 */
2732: --OPEN C_org_id( l_model_line_rec.quote_header_id);

Line 3409: l_model_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row(p_model_line_id);

3405: FND_MSG_PUB.initialize;
3406: END IF;
3407:
3408: -- Get model line info
3409: l_model_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row(p_model_line_id);
3410: l_model_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(p_model_line_id);
3411:
3412: -- Call Create_hdr_xml to create the input header XML message
3413: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 3410: l_model_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(p_model_line_id);

3406: END IF;
3407:
3408: -- Get model line info
3409: l_model_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row(p_model_line_id);
3410: l_model_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(p_model_line_id);
3411:
3412: -- Call Create_hdr_xml to create the input header XML message
3413: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3414: aso_debug_pub.add('Validate_Configuration: Before call to Create_hdr_xml.');