DBA Data[Home] [Help]

APPS.OE_CNCL_ORDER_IMPORT_PVT dependencies on OE_CNCL_UTIL

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

1642:
1643: BEGIN
1644: --call value to id
1645: --
1646: OE_CNCL_UTIL.get_header_ids(l_header_rec,l_header_val_rec);
1647: --
1648: IF l_header_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1649: --
1650: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1659: OE_CNCL_Util.Convert_Miss_To_Null(l_header_rec);

1655: --
1656: END IF;
1657: --
1658: --
1659: OE_CNCL_Util.Convert_Miss_To_Null(l_header_rec);
1660: --
1661:
1662: OE_CNCL_validate_header.attributes(x_return_status =>l_return_status
1663: , p_x_header_rec =>l_header_rec);

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

1821:
1822:
1823: BEGIN
1824: --
1825: OE_CNCL_UTIL.get_header_adj_ids(l_header_adj_rec,l_header_adj_val_rec);
1826: --
1827: IF l_header_adj_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1828: --
1829: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1838: OE_CNCL_Util.Convert_Miss_To_Null(l_header_adj_rec);

1834: --
1835: END IF;
1836: --
1837: --
1838: OE_CNCL_Util.Convert_Miss_To_Null(l_header_adj_rec);
1839: --
1840:
1841: OE_CNCL_Validate_Header_Adj.Attributes( x_return_status =>l_return_status
1842: , p_Header_Adj_rec =>l_header_adj_rec);

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

1959: END IF;
1960:
1961: BEGIN
1962: --
1963: OE_CNCL_UTIL.get_header_scredit_ids(l_header_scredit_rec,l_header_scredit_val_rec);
1964: --
1965: IF l_header_scredit_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1966: --
1967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1977: OE_CNCL_Util.Convert_Miss_To_Null(l_header_scredit_rec);

1973: END IF;
1974: --
1975:
1976: --
1977: OE_CNCL_Util.Convert_Miss_To_Null(l_header_scredit_rec);
1978: --
1979:
1980: OE_CNCL_Val_Header_Scredit.Attributes (x_return_status => l_return_status
1981: , p_Header_Scredit_rec => l_header_scredit_rec);

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

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

Line 2611: OE_CNCL_Util.Convert_Miss_To_Null(l_line_rec);

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

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

2779:
2780:
2781: BEGIN
2782: --
2783: OE_CNCL_UTIL.get_line_adj_ids(l_line_adj_rec,l_line_adj_val_rec);
2784: --
2785: IF l_line_adj_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2786: --
2787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2797: OE_CNCL_Util.Convert_Miss_To_Null(l_line_adj_rec);

2793: END IF;
2794: --
2795:
2796: --
2797: OE_CNCL_Util.Convert_Miss_To_Null(l_line_adj_rec);
2798: --
2799:
2800: OE_CNCL_Validate_Line_Adj.Attributes( x_return_status => l_return_status
2801: , p_Line_Adj_rec => l_line_adj_rec);

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

2919:
2920:
2921: BEGIN
2922: --
2923: OE_CNCL_UTIL.get_line_scredit_ids(l_line_scredit_rec,l_line_scredit_val_rec);
2924: --
2925: IF l_line_scredit_rec.return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2926: --
2927: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2937: OE_CNCL_Util.Convert_Miss_To_Null(l_line_scredit_rec);

2933: END IF;
2934: --
2935:
2936: --
2937: OE_CNCL_Util.Convert_Miss_To_Null(l_line_scredit_rec);
2938: --
2939:
2940:
2941: OE_CNCL_Validate_Line_Scredit.Attributes( x_return_status => l_return_status

Line 3030: OE_CNCL_Util.Convert_Miss_To_Null(l_header_rec);

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

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

3112: FROM DUAL;
3113: --
3114: l_header_scredit_tbl(I).header_id := l_header_rec.header_id;
3115: --
3116: OE_CNCL_Util.Convert_Miss_To_Null(l_header_scredit_tbl(I));
3117: --
3118: l_header_scredit_tbl(I).creation_date := SYSDATE;
3119: l_header_scredit_tbl(I).created_by := FND_GLOBAL.USER_ID;
3120: l_header_scredit_tbl(I).last_updated_by := FND_GLOBAL.USER_ID;

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

3178: FROM DUAL;
3179: --
3180: l_header_adj_tbl(I).header_id := l_header_rec.header_id;
3181: --
3182: OE_CNCL_Util.Convert_Miss_To_Null(l_header_adj_tbl(I));
3183: --
3184: l_header_adj_tbl(I).creation_date := SYSDATE;
3185: l_header_adj_tbl(I).created_by := FND_GLOBAL.USER_ID;
3186: l_header_adj_tbl(I).last_updated_by := FND_GLOBAL.USER_ID;

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

3275: --
3276:
3277: l_line_tbl(I).header_id := l_header_rec.header_id;
3278: --
3279: OE_CNCL_Util.Convert_Miss_To_Null(l_line_tbl(I));
3280: --
3281:
3282: l_line_tbl(I).flow_status_code := 'CLOSED';
3283:

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

3369: l_line_scredit_tbl(J).header_id := l_header_rec.header_id;
3370: --
3371: l_line_scredit_tbl(J).line_id := l_line_tbl(I).line_id;
3372: --
3373: OE_CNCL_Util.Convert_Miss_To_Null(l_line_scredit_tbl(J));
3374: --
3375: l_line_scredit_tbl(J).creation_date := SYSDATE;
3376: l_line_scredit_tbl(J).created_by := FND_GLOBAL.USER_ID;
3377: l_line_scredit_tbl(J).last_updated_by := FND_GLOBAL.USER_ID;

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

3397: --
3398: l_line_adj_tbl(K).header_id := l_header_rec.header_id;
3399: l_line_adj_tbl(K).line_id := l_line_tbl(I).line_id;
3400: --
3401: OE_CNCL_Util.Convert_Miss_To_Null(l_line_adj_tbl(K));
3402: --
3403: l_line_adj_tbl(K).creation_date := SYSDATE;
3404: l_line_adj_tbl(K).created_by := FND_GLOBAL.USER_ID;
3405: l_line_adj_tbl(K).last_updated_by := FND_GLOBAL.USER_ID;

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

3495: l_line_scredit_tbl(J).header_id := l_header_rec.header_id;
3496: --
3497: l_line_scredit_tbl(J).line_id := l_line_tbl(L).line_id;
3498: --
3499: OE_CNCL_Util.Convert_Miss_To_Null(l_line_scredit_tbl(J));
3500: --
3501: l_line_scredit_tbl(J).creation_date := SYSDATE;
3502: l_line_scredit_tbl(J).created_by := FND_GLOBAL.USER_ID;
3503: l_line_scredit_tbl(J).last_updated_by := FND_GLOBAL.USER_ID;

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

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