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 193: l_qte_line_tbl := ASO_UTILITY_PVT.Query_Qte_Line_Rows_sort(p_template_id_tbl(i));

189: select org_id into l_tmpl_org_id from aso_quote_headers_all
190: where quote_header_id=p_template_id_tbl(i);
191: mo_global.set_policy_context('S', l_tmpl_org_id);
192: end if;
193: l_qte_line_tbl := ASO_UTILITY_PVT.Query_Qte_Line_Rows_sort(p_template_id_tbl(i));
194: -- ER 9433340
195: if l_tmpl_org_id=l_qte_header_rec.org_id then -- same org id
196: l_prof_temp_filter:='Q';
197: end if;

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

333:
334: FOR i IN 1..l_qte_line_tbl.count LOOP
335: IF l_qte_line_tbl(i).item_type_code IN ('MDL','CFG') THEN
336: l_temp_line_dtl_tbl := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl;
337: l_temp_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(l_qte_line_tbl(i).quote_line_id);
338:
339: IF l_temp_line_dtl_tbl.count > 0 THEN
340: l_template_line_count := l_template_line_count + 1;
341: l_qte_line_dtl_tbl(l_template_line_count) := l_temp_line_dtl_tbl(1);

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

368: END LOOP;
369:
370: IF l_service_flag = 'Y' THEN
371: l_temp_line_dtl_tbl := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl;
372: l_temp_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(l_qte_line_tbl(i).quote_line_id);
373:
374: IF l_temp_line_dtl_tbl.count > 0 THEN
375: l_template_line_count := l_template_line_count + 1;
376: l_qte_line_dtl_tbl(l_template_line_count) := l_temp_line_dtl_tbl(1);

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

544: END IF;
545:
546: -- Commented for bug no 6731701 so that only the record for newly inserted line go into relationship table
547: /* x_qte_line_tbl := ASO_QUOTE_PUB.G_Miss_Qte_Line_Tbl;
548: x_qte_line_tbl := ASO_UTILITY_PVT.Query_Qte_Line_Rows_sort(p_qte_header_rec.quote_header_id);
549: */
550: IF aso_debug_pub.g_debug_flag = 'Y' THEN
551: For l in x_qte_line_tbl.FIRST..x_qte_line_tbl.LAST LOOP
552: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT:quote line id :'||x_qte_line_tbl(l).quote_line_id,1,'Y');

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

559:
560: FOR i in 1..x_qte_line_tbl.count LOOP
561: l_line_rltship_rec := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Rec;
562: x_qte_line_dtl_tbl := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl;
563: x_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(x_qte_line_tbl(i).quote_line_id);
564:
565: IF x_qte_line_dtl_tbl.count > 0 THEN
566:
567: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 636: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

632: );
633:
634: EXCEPTION
635: WHEN FND_API.G_EXC_ERROR THEN
636: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
637: P_API_NAME => L_API_NAME,
638: P_PKG_NAME => G_PKG_NAME,
639: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
640: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

Line 640: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

636: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
637: P_API_NAME => L_API_NAME,
638: P_PKG_NAME => G_PKG_NAME,
639: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
640: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
641: P_SQLCODE => SQLCODE,
642: P_SQLERRM => SQLERRM,
643: X_MSG_COUNT => X_MSG_COUNT,
644: X_MSG_DATA => X_MSG_DATA,

Line 649: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

645: X_RETURN_STATUS => X_RETURN_STATUS
646: );
647:
648: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
649: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
650: P_API_NAME => L_API_NAME,
651: P_PKG_NAME => G_PKG_NAME,
652: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
653: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

Line 653: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

649: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
650: P_API_NAME => L_API_NAME,
651: P_PKG_NAME => G_PKG_NAME,
652: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
653: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
654: P_SQLCODE => SQLCODE,
655: P_SQLERRM => SQLERRM,
656: X_MSG_COUNT => X_MSG_COUNT,
657: X_MSG_DATA => X_MSG_DATA,

Line 662: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

658: X_RETURN_STATUS => X_RETURN_STATUS
659: );
660:
661: WHEN OTHERS THEN
662: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
663: P_API_NAME => L_API_NAME,
664: P_PKG_NAME => G_PKG_NAME,
665: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
666: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

Line 665: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,

661: WHEN OTHERS THEN
662: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
663: P_API_NAME => L_API_NAME,
664: P_PKG_NAME => G_PKG_NAME,
665: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
666: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
667: P_SQLCODE => SQLCODE,
668: P_SQLERRM => SQLERRM,
669: X_MSG_COUNT => X_MSG_COUNT,

Line 666: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

662: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
663: P_API_NAME => L_API_NAME,
664: P_PKG_NAME => G_PKG_NAME,
665: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
666: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
667: P_SQLCODE => SQLCODE,
668: P_SQLERRM => SQLERRM,
669: X_MSG_COUNT => X_MSG_COUNT,
670: X_MSG_DATA => X_MSG_DATA,