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_ATP_INT dependencies on ASO_UTILITY_PVT

Line 646: l_qte_line_tbl := aso_utility_pvt.query_qte_line_rows_atp(p_qte_header_rec.quote_header_id);

642: raise fnd_api.g_exc_error;
643:
644: else
645: /*
646: l_qte_line_tbl := aso_utility_pvt.query_qte_line_rows_atp(p_qte_header_rec.quote_header_id);
647: for i in 1..l_qte_line_tbl.count loop
648: l_shipment_rec := aso_utility_pvt.query_line_shipment_row_atp(p_qte_header_rec.quote_header_id,
649: l_qte_line_tbl(i).quote_line_id);
650: l_shipment_tbl(l_shipment_tbl.count + 1 ) := l_shipment_rec;

Line 648: l_shipment_rec := aso_utility_pvt.query_line_shipment_row_atp(p_qte_header_rec.quote_header_id,

644: else
645: /*
646: l_qte_line_tbl := aso_utility_pvt.query_qte_line_rows_atp(p_qte_header_rec.quote_header_id);
647: for i in 1..l_qte_line_tbl.count loop
648: l_shipment_rec := aso_utility_pvt.query_line_shipment_row_atp(p_qte_header_rec.quote_header_id,
649: l_qte_line_tbl(i).quote_line_id);
650: l_shipment_tbl(l_shipment_tbl.count + 1 ) := l_shipment_rec;
651: end loop; */
652: --l_shipment_tbl := aso_utility_pvt.query_line_shipment_rows_atp(p_qte_header_rec.quote_header_id);

Line 652: --l_shipment_tbl := aso_utility_pvt.query_line_shipment_rows_atp(p_qte_header_rec.quote_header_id);

648: l_shipment_rec := aso_utility_pvt.query_line_shipment_row_atp(p_qte_header_rec.quote_header_id,
649: l_qte_line_tbl(i).quote_line_id);
650: l_shipment_tbl(l_shipment_tbl.count + 1 ) := l_shipment_rec;
651: end loop; */
652: --l_shipment_tbl := aso_utility_pvt.query_line_shipment_rows_atp(p_qte_header_rec.quote_header_id);
653: l_check_atp_for_whole_quote := fnd_api.g_true;
654: end if;
655:
656: end if;

Line 679: l_qte_line_tbl := aso_utility_pvt.query_qte_line_rows_atp(p_qte_header_rec.quote_header_id);

675:
676: if aso_debug_pub.g_debug_flag = 'Y' then
677: aso_debug_pub.add('do_check_atp: Getting the quote lines and shipment from db', 1, 'Y');
678: end if;
679: l_qte_line_tbl := aso_utility_pvt.query_qte_line_rows_atp(p_qte_header_rec.quote_header_id);
680: for i in 1..l_qte_line_tbl.count loop
681: l_shipment_rec := aso_utility_pvt.query_line_shipment_row_atp(p_qte_header_rec.quote_header_id,
682: l_qte_line_tbl(i).quote_line_id);
683: l_shipment_tbl(i) := l_shipment_rec;

Line 681: l_shipment_rec := aso_utility_pvt.query_line_shipment_row_atp(p_qte_header_rec.quote_header_id,

677: aso_debug_pub.add('do_check_atp: Getting the quote lines and shipment from db', 1, 'Y');
678: end if;
679: l_qte_line_tbl := aso_utility_pvt.query_qte_line_rows_atp(p_qte_header_rec.quote_header_id);
680: for i in 1..l_qte_line_tbl.count loop
681: l_shipment_rec := aso_utility_pvt.query_line_shipment_row_atp(p_qte_header_rec.quote_header_id,
682: l_qte_line_tbl(i).quote_line_id);
683: l_shipment_tbl(i) := l_shipment_rec;
684: end loop;
685: l_check_atp_for_whole_quote := fnd_api.g_true;

Line 904: l_qte_line_rec := aso_utility_pvt.query_qte_line_row(k.quote_line_id);

900: if aso_debug_pub.g_debug_flag = 'Y' then
901: aso_debug_pub.add('Quote line id does not exist in l_qte_line_search_tbl, so add it to l_qte_line_tbl from database');
902: end if;
903:
904: l_qte_line_rec := aso_utility_pvt.query_qte_line_row(k.quote_line_id);
905: l_qte_line_tbl(l_qte_line_tbl.count + 1) := l_qte_line_rec;
906:
907: end if;
908:

Line 915: l_shipment_rec := aso_utility_pvt.query_shipment_row(k.shipment_id);

911: if aso_debug_pub.g_debug_flag = 'Y' then
912: aso_debug_pub.add('shipment id does not exist in l_shipment_search_tbl, so add it to l_shipment_tbl from database');
913: end if;
914:
915: l_shipment_rec := aso_utility_pvt.query_shipment_row(k.shipment_id);
916: l_shipment_rec.qte_line_index := l_qte_line_tbl.count;
917: l_shipment_tbl(l_shipment_tbl.count + 1) := l_shipment_rec;
918:
919: end if;

Line 946: l_qte_line_rec := aso_utility_pvt.query_qte_line_row(k.quote_line_id);

942: if aso_debug_pub.g_debug_flag = 'Y' then
943: aso_debug_pub.add('Quote line id does not exist in l_qte_line_search_tbl, so add it to l_qte_line_tbl from database');
944: end if;
945:
946: l_qte_line_rec := aso_utility_pvt.query_qte_line_row(k.quote_line_id);
947: l_qte_line_tbl(l_qte_line_tbl.count + 1) := l_qte_line_rec;
948:
949: end if;
950:

Line 957: l_shipment_rec := aso_utility_pvt.query_shipment_row(k.shipment_id);

953: if aso_debug_pub.g_debug_flag = 'Y' then
954: aso_debug_pub.add('shipment id does not exist in l_shipment_search_tbl, so add it to l_shipment_tbl from database');
955: end if;
956:
957: l_shipment_rec := aso_utility_pvt.query_shipment_row(k.shipment_id);
958: l_shipment_rec.qte_line_index := l_qte_line_tbl.count;
959: l_shipment_tbl(l_shipment_tbl.count + 1) := l_shipment_rec;
960:
961: end if;

Line 999: l_qte_line_rec := aso_utility_pvt.query_qte_line_row(k.quote_line_id);

995: if aso_debug_pub.g_debug_flag = 'Y' then
996: aso_debug_pub.add('Quote line id does not exist in l_qte_line_search_tbl, so add it to l_qte_line_tbl from database');
997: end if;
998:
999: l_qte_line_rec := aso_utility_pvt.query_qte_line_row(k.quote_line_id);
1000: l_qte_line_tbl(l_qte_line_tbl.count + 1) := l_qte_line_rec;
1001:
1002: end if;
1003:

Line 1010: l_shipment_rec := aso_utility_pvt.query_shipment_row(k.shipment_id);

1006: if aso_debug_pub.g_debug_flag = 'Y' then
1007: aso_debug_pub.add('shipment id does not exist in l_shipment_search_tbl, so add it to l_shipment_tbl from database');
1008: end if;
1009:
1010: l_shipment_rec := aso_utility_pvt.query_shipment_row(k.shipment_id);
1011: l_shipment_rec.qte_line_index := l_qte_line_tbl.count;
1012: l_shipment_tbl(l_shipment_tbl.count + 1) := l_shipment_rec;
1013:
1014: end if;

Line 1154: l_db_qte_line_rec := aso_utility_pvt.query_qte_line_row(l_qte_line_tbl(i).quote_line_id);

1150: aso_debug_pub.add('l_qte_line_tbl('||i||').quote_line_id: '|| l_qte_line_tbl(i).quote_line_id);
1151: END IF;
1152:
1153: if l_check_atp_for_whole_quote = fnd_api.g_false then
1154: l_db_qte_line_rec := aso_utility_pvt.query_qte_line_row(l_qte_line_tbl(i).quote_line_id);
1155: else
1156: l_db_qte_line_rec := l_qte_line_tbl(i);
1157: end if;
1158:

Line 1198: l_hdr_shipment_tbl := aso_utility_pvt.query_shipment_rows(p_qte_header_rec.quote_header_id,null);

1194:
1195: If l_shipment_tbl.EXISTS(i) Then
1196:
1197: -- query the hdr shipment rec
1198: l_hdr_shipment_tbl := aso_utility_pvt.query_shipment_rows(p_qte_header_rec.quote_header_id,null);
1199:
1200: if l_hdr_shipment_tbl.count > 0 then
1201: l_hdr_shipment_rec := l_hdr_shipment_tbl(1);
1202: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 1209: l_db_shipment_rec := aso_utility_pvt.query_shipment_row(l_shipment_tbl(i).shipment_id);

1205: end if;
1206:
1207:
1208: if l_check_atp_for_whole_quote = fnd_api.g_false then
1209: l_db_shipment_rec := aso_utility_pvt.query_shipment_row(l_shipment_tbl(i).shipment_id);
1210: else
1211: l_db_shipment_rec := l_shipment_tbl(i);
1212: end if;
1213:

Line 1928: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1924:
1925: EXCEPTION
1926:
1927: WHEN FND_API.G_EXC_ERROR THEN
1928: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1929: P_API_NAME => L_API_NAME
1930: ,P_PKG_NAME => G_PKG_NAME
1931: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1932: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

Line 1932: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

1928: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1929: P_API_NAME => L_API_NAME
1930: ,P_PKG_NAME => G_PKG_NAME
1931: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1932: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
1933: ,X_MSG_COUNT => X_MSG_COUNT
1934: ,X_MSG_DATA => X_MSG_DATA
1935: ,X_RETURN_STATUS => X_RETURN_STATUS);
1936:

Line 1938: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1934: ,X_MSG_DATA => X_MSG_DATA
1935: ,X_RETURN_STATUS => X_RETURN_STATUS);
1936:
1937: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1938: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1939: P_API_NAME => L_API_NAME
1940: ,P_PKG_NAME => G_PKG_NAME
1941: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1942: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

Line 1942: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

1938: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1939: P_API_NAME => L_API_NAME
1940: ,P_PKG_NAME => G_PKG_NAME
1941: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1942: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
1943: ,X_MSG_COUNT => X_MSG_COUNT
1944: ,X_MSG_DATA => X_MSG_DATA
1945: ,X_RETURN_STATUS => X_RETURN_STATUS);
1946:

Line 1948: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1944: ,X_MSG_DATA => X_MSG_DATA
1945: ,X_RETURN_STATUS => X_RETURN_STATUS);
1946:
1947: WHEN OTHERS THEN
1948: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1949: P_API_NAME => L_API_NAME
1950: ,P_PKG_NAME => G_PKG_NAME
1951: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1952: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

Line 1951: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

1947: WHEN OTHERS THEN
1948: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1949: P_API_NAME => L_API_NAME
1950: ,P_PKG_NAME => G_PKG_NAME
1951: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1952: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
1953: ,P_SQLCODE => SQLCODE
1954: ,P_SQLERRM => SQLERRM
1955: ,X_MSG_COUNT => X_MSG_COUNT

Line 1952: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

1948: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1949: P_API_NAME => L_API_NAME
1950: ,P_PKG_NAME => G_PKG_NAME
1951: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1952: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
1953: ,P_SQLCODE => SQLCODE
1954: ,P_SQLERRM => SQLERRM
1955: ,X_MSG_COUNT => X_MSG_COUNT
1956: ,X_MSG_DATA => X_MSG_DATA

Line 2326: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

2322: end if;
2323:
2324: EXCEPTION
2325: WHEN FND_API.G_EXC_ERROR THEN
2326: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2327: P_API_NAME => L_API_NAME
2328: ,P_PKG_NAME => G_PKG_NAME
2329: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2330: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

Line 2330: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

2326: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2327: P_API_NAME => L_API_NAME
2328: ,P_PKG_NAME => G_PKG_NAME
2329: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2330: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
2331: ,X_MSG_COUNT => X_MSG_COUNT
2332: ,X_MSG_DATA => X_MSG_DATA
2333: ,X_RETURN_STATUS => X_RETURN_STATUS);
2334:

Line 2336: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

2332: ,X_MSG_DATA => X_MSG_DATA
2333: ,X_RETURN_STATUS => X_RETURN_STATUS);
2334:
2335: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2336: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2337: P_API_NAME => L_API_NAME
2338: ,P_PKG_NAME => G_PKG_NAME
2339: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2340: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

Line 2340: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

2336: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2337: P_API_NAME => L_API_NAME
2338: ,P_PKG_NAME => G_PKG_NAME
2339: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2340: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
2341: ,X_MSG_COUNT => X_MSG_COUNT
2342: ,X_MSG_DATA => X_MSG_DATA
2343: ,X_RETURN_STATUS => X_RETURN_STATUS);
2344:

Line 2346: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

2342: ,X_MSG_DATA => X_MSG_DATA
2343: ,X_RETURN_STATUS => X_RETURN_STATUS);
2344:
2345: WHEN OTHERS THEN
2346: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2347: P_API_NAME => L_API_NAME
2348: ,P_PKG_NAME => G_PKG_NAME
2349: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
2350: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

Line 2349: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

2345: WHEN OTHERS THEN
2346: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2347: P_API_NAME => L_API_NAME
2348: ,P_PKG_NAME => G_PKG_NAME
2349: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
2350: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
2351: ,P_SQLCODE => SQLCODE
2352: ,P_SQLERRM => SQLERRM
2353: ,X_MSG_COUNT => X_MSG_COUNT

Line 2350: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

2346: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2347: P_API_NAME => L_API_NAME
2348: ,P_PKG_NAME => G_PKG_NAME
2349: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
2350: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
2351: ,P_SQLCODE => SQLCODE
2352: ,P_SQLERRM => SQLERRM
2353: ,X_MSG_COUNT => X_MSG_COUNT
2354: ,X_MSG_DATA => X_MSG_DATA

Line 2625: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

2621:
2622:
2623: EXCEPTION
2624: WHEN FND_API.G_EXC_ERROR THEN
2625: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2626: P_API_NAME => L_API_NAME
2627: ,P_PKG_NAME => G_PKG_NAME
2628: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2629: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

Line 2629: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

2625: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2626: P_API_NAME => L_API_NAME
2627: ,P_PKG_NAME => G_PKG_NAME
2628: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2629: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
2630: ,X_MSG_COUNT => X_MSG_COUNT
2631: ,X_MSG_DATA => X_MSG_DATA
2632: ,X_RETURN_STATUS => X_RETURN_STATUS);
2633:

Line 2635: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

2631: ,X_MSG_DATA => X_MSG_DATA
2632: ,X_RETURN_STATUS => X_RETURN_STATUS);
2633:
2634: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2635: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2636: P_API_NAME => L_API_NAME
2637: ,P_PKG_NAME => G_PKG_NAME
2638: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2639: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

Line 2639: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

2635: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2636: P_API_NAME => L_API_NAME
2637: ,P_PKG_NAME => G_PKG_NAME
2638: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2639: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
2640: ,X_MSG_COUNT => X_MSG_COUNT
2641: ,X_MSG_DATA => X_MSG_DATA
2642: ,X_RETURN_STATUS => X_RETURN_STATUS);
2643:

Line 2645: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

2641: ,X_MSG_DATA => X_MSG_DATA
2642: ,X_RETURN_STATUS => X_RETURN_STATUS);
2643:
2644: WHEN OTHERS THEN
2645: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2646: P_API_NAME => L_API_NAME
2647: ,P_PKG_NAME => G_PKG_NAME
2648: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
2649: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

Line 2648: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

2644: WHEN OTHERS THEN
2645: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2646: P_API_NAME => L_API_NAME
2647: ,P_PKG_NAME => G_PKG_NAME
2648: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
2649: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
2650: ,P_SQLCODE => SQLCODE
2651: ,P_SQLERRM => SQLERRM
2652: ,X_MSG_COUNT => X_MSG_COUNT

Line 2649: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

2645: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2646: P_API_NAME => L_API_NAME
2647: ,P_PKG_NAME => G_PKG_NAME
2648: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
2649: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
2650: ,P_SQLCODE => SQLCODE
2651: ,P_SQLERRM => SQLERRM
2652: ,X_MSG_COUNT => X_MSG_COUNT
2653: ,X_MSG_DATA => X_MSG_DATA