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.ASO_QUOTE_TMPL_PVT dependencies on ASO_UTILITY_PVT

Line 173: l_qte_line_tbl := ASO_UTILITY_PVT.Query_Qte_Line_Rows_sort(p_template_id_tbl(i));

169:
170:
171:
172: FOR i IN 1..p_template_id_tbl.count LOOP
173: l_qte_line_tbl := ASO_UTILITY_PVT.Query_Qte_Line_Rows_sort(p_template_id_tbl(i));
174: FOR j IN 1..l_qte_line_tbl.count LOOP
175: l_template_line_count := l_template_line_count + 1;
176: lp_qte_line_tbl(l_template_line_count) := l_qte_line_tbl(j);
177: END LOOP;

Line 286: l_temp_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(l_qte_line_tbl(i).quote_line_id);

282:
283: FOR i IN 1..l_qte_line_tbl.count LOOP
284: IF l_qte_line_tbl(i).item_type_code IN ('MDL','CFG') THEN
285: l_temp_line_dtl_tbl := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl;
286: l_temp_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(l_qte_line_tbl(i).quote_line_id);
287:
288: IF l_temp_line_dtl_tbl.count > 0 THEN
289: l_template_line_count := l_template_line_count + 1;
290: l_qte_line_dtl_tbl(l_template_line_count) := l_temp_line_dtl_tbl(1);

Line 309: l_temp_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(l_qte_line_tbl(i).quote_line_id);

305: END LOOP;
306:
307: IF l_service_flag = 'Y' THEN
308: l_temp_line_dtl_tbl := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl;
309: l_temp_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(l_qte_line_tbl(i).quote_line_id);
310:
311: IF l_temp_line_dtl_tbl.count > 0 THEN
312: l_template_line_count := l_template_line_count + 1;
313: l_qte_line_dtl_tbl(l_template_line_count) := l_temp_line_dtl_tbl(1);

Line 481: x_qte_line_tbl := ASO_UTILITY_PVT.Query_Qte_Line_Rows_sort(p_qte_header_rec.quote_header_id);

477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
478: END IF;
479:
480: x_qte_line_tbl := ASO_QUOTE_PUB.G_Miss_Qte_Line_Tbl;
481: x_qte_line_tbl := ASO_UTILITY_PVT.Query_Qte_Line_Rows_sort(p_qte_header_rec.quote_header_id);
482:
483: IF aso_debug_pub.g_debug_flag = 'Y' THEN
484: For l in x_qte_line_tbl.FIRST..x_qte_line_tbl.LAST LOOP
485: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT:quote line id :'||x_qte_line_tbl(l).quote_line_id,1,'Y');

Line 496: x_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(x_qte_line_tbl(i).quote_line_id);

492:
493: FOR i in 1..x_qte_line_tbl.count LOOP
494: l_line_rltship_rec := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Rec;
495: x_qte_line_dtl_tbl := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl;
496: x_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(x_qte_line_tbl(i).quote_line_id);
497:
498: IF x_qte_line_dtl_tbl.count > 0 THEN
499:
500: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 569: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

565: );
566:
567: EXCEPTION
568: WHEN FND_API.G_EXC_ERROR THEN
569: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
570: P_API_NAME => L_API_NAME,
571: P_PKG_NAME => G_PKG_NAME,
572: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
573: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

Line 573: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

569: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
570: P_API_NAME => L_API_NAME,
571: P_PKG_NAME => G_PKG_NAME,
572: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
573: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
574: P_SQLCODE => SQLCODE,
575: P_SQLERRM => SQLERRM,
576: X_MSG_COUNT => X_MSG_COUNT,
577: X_MSG_DATA => X_MSG_DATA,

Line 582: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

578: X_RETURN_STATUS => X_RETURN_STATUS
579: );
580:
581: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
582: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
583: P_API_NAME => L_API_NAME,
584: P_PKG_NAME => G_PKG_NAME,
585: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
586: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

Line 586: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

582: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
583: P_API_NAME => L_API_NAME,
584: P_PKG_NAME => G_PKG_NAME,
585: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
586: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
587: P_SQLCODE => SQLCODE,
588: P_SQLERRM => SQLERRM,
589: X_MSG_COUNT => X_MSG_COUNT,
590: X_MSG_DATA => X_MSG_DATA,

Line 595: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

591: X_RETURN_STATUS => X_RETURN_STATUS
592: );
593:
594: WHEN OTHERS THEN
595: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
596: P_API_NAME => L_API_NAME,
597: P_PKG_NAME => G_PKG_NAME,
598: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
599: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

Line 598: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,

594: WHEN OTHERS THEN
595: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
596: P_API_NAME => L_API_NAME,
597: P_PKG_NAME => G_PKG_NAME,
598: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
599: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
600: P_SQLCODE => SQLCODE,
601: P_SQLERRM => SQLERRM,
602: X_MSG_COUNT => X_MSG_COUNT,

Line 599: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

595: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
596: P_API_NAME => L_API_NAME,
597: P_PKG_NAME => G_PKG_NAME,
598: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
599: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
600: P_SQLCODE => SQLCODE,
601: P_SQLERRM => SQLERRM,
602: X_MSG_COUNT => X_MSG_COUNT,
603: X_MSG_DATA => X_MSG_DATA,