DBA Data[Home] [Help]

APPS.OE_CNCL_ORDER_IMPORT_PVT dependencies on OE_CNCL_UTIL

Line 1650: OE_CNCL_UTIL.get_header_ids(l_header_rec,l_header_val_rec);

1646:
1647: BEGIN
1648: --call value to id
1649: --
1650: OE_CNCL_UTIL.get_header_ids(l_header_rec,l_header_val_rec);
1651: --
1652: IF l_header_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1653: --
1654: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1663: OE_CNCL_Util.Convert_Miss_To_Null(l_header_rec);

1659: --
1660: END IF;
1661: --
1662: --
1663: OE_CNCL_Util.Convert_Miss_To_Null(l_header_rec);
1664: --
1665:
1666: OE_CNCL_validate_header.attributes(x_return_status =>l_return_status
1667: , p_x_header_rec =>l_header_rec);

Line 1829: OE_CNCL_UTIL.get_header_adj_ids(l_header_adj_rec,l_header_adj_val_rec);

1825:
1826:
1827: BEGIN
1828: --
1829: OE_CNCL_UTIL.get_header_adj_ids(l_header_adj_rec,l_header_adj_val_rec);
1830: --
1831: IF l_header_adj_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1832: --
1833: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1842: OE_CNCL_Util.Convert_Miss_To_Null(l_header_adj_rec);

1838: --
1839: END IF;
1840: --
1841: --
1842: OE_CNCL_Util.Convert_Miss_To_Null(l_header_adj_rec);
1843: --
1844:
1845: OE_CNCL_Validate_Header_Adj.Attributes( x_return_status =>l_return_status
1846: , p_Header_Adj_rec =>l_header_adj_rec);

Line 1967: OE_CNCL_UTIL.get_header_scredit_ids(l_header_scredit_rec,l_header_scredit_val_rec);

1963: END IF;
1964:
1965: BEGIN
1966: --
1967: OE_CNCL_UTIL.get_header_scredit_ids(l_header_scredit_rec,l_header_scredit_val_rec);
1968: --
1969: IF l_header_scredit_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1970: --
1971: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1981: OE_CNCL_Util.Convert_Miss_To_Null(l_header_scredit_rec);

1977: END IF;
1978: --
1979:
1980: --
1981: OE_CNCL_Util.Convert_Miss_To_Null(l_header_scredit_rec);
1982: --
1983:
1984: OE_CNCL_Val_Header_Scredit.Attributes (x_return_status => l_return_status
1985: , p_Header_Scredit_rec => l_header_scredit_rec);

Line 2601: OE_CNCL_UTIL.get_line_ids(l_line_rec,l_line_val_rec);

2597: END IF;
2598:
2599: BEGIN
2600: oe_Debug_pub.add('calling get line ids'); --bug 4240715
2601: OE_CNCL_UTIL.get_line_ids(l_line_rec,l_line_val_rec);
2602: oe_debug_pub.add('after calling get line ids'||l_line_rec.end_customer_id); --bug 4240715
2603: --
2604: IF l_line_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2605: --

Line 2615: OE_CNCL_Util.Convert_Miss_To_Null(l_line_rec);

2611: --
2612: END IF;
2613: --
2614: --
2615: OE_CNCL_Util.Convert_Miss_To_Null(l_line_rec);
2616: oe_debug_pub.add('after calling convert miss to null'||l_line_rec.end_customer_id); --bug 4240715
2617: --
2618:
2619: OE_CNCL_Validate_Line.Attributes( x_return_status => l_return_status

Line 2787: OE_CNCL_UTIL.get_line_adj_ids(l_line_adj_rec,l_line_adj_val_rec);

2783:
2784:
2785: BEGIN
2786: --
2787: OE_CNCL_UTIL.get_line_adj_ids(l_line_adj_rec,l_line_adj_val_rec);
2788: --
2789: IF l_line_adj_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2790: --
2791: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2801: OE_CNCL_Util.Convert_Miss_To_Null(l_line_adj_rec);

2797: END IF;
2798: --
2799:
2800: --
2801: OE_CNCL_Util.Convert_Miss_To_Null(l_line_adj_rec);
2802: --
2803:
2804: OE_CNCL_Validate_Line_Adj.Attributes( x_return_status => l_return_status
2805: , p_Line_Adj_rec => l_line_adj_rec);

Line 2927: OE_CNCL_UTIL.get_line_scredit_ids(l_line_scredit_rec,l_line_scredit_val_rec);

2923:
2924:
2925: BEGIN
2926: --
2927: OE_CNCL_UTIL.get_line_scredit_ids(l_line_scredit_rec,l_line_scredit_val_rec);
2928: --
2929: IF l_line_scredit_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2930: --
2931: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2941: OE_CNCL_Util.Convert_Miss_To_Null(l_line_scredit_rec);

2937: END IF;
2938: --
2939:
2940: --
2941: OE_CNCL_Util.Convert_Miss_To_Null(l_line_scredit_rec);
2942: --
2943:
2944:
2945: OE_CNCL_Validate_Line_Scredit.Attributes( x_return_status => l_return_status

Line 3034: OE_CNCL_Util.Convert_Miss_To_Null(l_header_rec);

3030: SELECT OE_ORDER_HEADERS_S.NEXTVAL
3031: INTO l_header_rec.header_id
3032: FROM DUAL;
3033: --
3034: OE_CNCL_Util.Convert_Miss_To_Null(l_header_rec);
3035: --
3036: l_header_rec.creation_date := SYSDATE;
3037: l_header_rec.created_by := FND_GLOBAL.USER_ID;
3038: -- bug 4002850, removed quotes around 1.0 below

Line 3120: OE_CNCL_Util.Convert_Miss_To_Null(l_header_scredit_tbl(I));

3116: FROM DUAL;
3117: --
3118: l_header_scredit_tbl(I).header_id := l_header_rec.header_id;
3119: --
3120: OE_CNCL_Util.Convert_Miss_To_Null(l_header_scredit_tbl(I));
3121: --
3122: l_header_scredit_tbl(I).creation_date := SYSDATE;
3123: l_header_scredit_tbl(I).created_by := FND_GLOBAL.USER_ID;
3124: l_header_scredit_tbl(I).last_updated_by := FND_GLOBAL.USER_ID;

Line 3186: OE_CNCL_Util.Convert_Miss_To_Null(l_header_adj_tbl(I));

3182: FROM DUAL;
3183: --
3184: l_header_adj_tbl(I).header_id := l_header_rec.header_id;
3185: --
3186: OE_CNCL_Util.Convert_Miss_To_Null(l_header_adj_tbl(I));
3187: --
3188: l_header_adj_tbl(I).creation_date := SYSDATE;
3189: l_header_adj_tbl(I).created_by := FND_GLOBAL.USER_ID;
3190: l_header_adj_tbl(I).last_updated_by := FND_GLOBAL.USER_ID;

Line 3333: OE_CNCL_Util.Convert_Miss_To_Null(l_line_tbl(I));

3329: --
3330:
3331: l_line_tbl(I).header_id := l_header_rec.header_id;
3332: --
3333: OE_CNCL_Util.Convert_Miss_To_Null(l_line_tbl(I));
3334: --
3335:
3336: l_line_tbl(I).flow_status_code := 'CLOSED';
3337:

Line 3427: OE_CNCL_Util.Convert_Miss_To_Null(l_line_scredit_tbl(J));

3423: l_line_scredit_tbl(J).header_id := l_header_rec.header_id;
3424: --
3425: l_line_scredit_tbl(J).line_id := l_line_tbl(I).line_id;
3426: --
3427: OE_CNCL_Util.Convert_Miss_To_Null(l_line_scredit_tbl(J));
3428: --
3429: l_line_scredit_tbl(J).creation_date := SYSDATE;
3430: l_line_scredit_tbl(J).created_by := FND_GLOBAL.USER_ID;
3431: l_line_scredit_tbl(J).last_updated_by := FND_GLOBAL.USER_ID;

Line 3455: OE_CNCL_Util.Convert_Miss_To_Null(l_line_adj_tbl(K));

3451: --
3452: l_line_adj_tbl(K).header_id := l_header_rec.header_id;
3453: l_line_adj_tbl(K).line_id := l_line_tbl(I).line_id;
3454: --
3455: OE_CNCL_Util.Convert_Miss_To_Null(l_line_adj_tbl(K));
3456: --
3457: l_line_adj_tbl(K).creation_date := SYSDATE;
3458: l_line_adj_tbl(K).created_by := FND_GLOBAL.USER_ID;
3459: l_line_adj_tbl(K).last_updated_by := FND_GLOBAL.USER_ID;

Line 3568: OE_CNCL_Util.Convert_Miss_To_Null(l_line_scredit_tbl(J));

3564: l_line_scredit_tbl(J).header_id := l_header_rec.header_id;
3565: --
3566: l_line_scredit_tbl(J).line_id := l_line_tbl(L).line_id;
3567: --
3568: OE_CNCL_Util.Convert_Miss_To_Null(l_line_scredit_tbl(J));
3569: --
3570: l_line_scredit_tbl(J).creation_date := SYSDATE;
3571: l_line_scredit_tbl(J).created_by := FND_GLOBAL.USER_ID;
3572: l_line_scredit_tbl(J).last_updated_by := FND_GLOBAL.USER_ID;

Line 3637: OE_CNCL_Util.Convert_Miss_To_Null(l_line_adj_tbl(K));

3633: --
3634: l_line_adj_tbl(K).header_id := l_header_rec.header_id;
3635: l_line_adj_tbl(K).line_id := l_line_tbl(L).line_id;
3636: --
3637: OE_CNCL_Util.Convert_Miss_To_Null(l_line_adj_tbl(K));
3638: --
3639: l_line_adj_tbl(K).creation_date := SYSDATE;
3640: l_line_adj_tbl(K).created_by := FND_GLOBAL.USER_ID;
3641: l_line_adj_tbl(K).last_updated_by := FND_GLOBAL.USER_ID;