[Home] [Help]
14: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
15: --
16: BEGIN
17:
18: l_rowtype_rec.ATTRIBUTE1 := FND_API.G_MISS_CHAR;
19: l_rowtype_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
20: l_rowtype_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
21: l_rowtype_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
22: l_rowtype_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
15: --
16: BEGIN
17:
18: l_rowtype_rec.ATTRIBUTE1 := FND_API.G_MISS_CHAR;
19: l_rowtype_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
20: l_rowtype_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
21: l_rowtype_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
22: l_rowtype_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
23: l_rowtype_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
16: BEGIN
17:
18: l_rowtype_rec.ATTRIBUTE1 := FND_API.G_MISS_CHAR;
19: l_rowtype_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
20: l_rowtype_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
21: l_rowtype_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
22: l_rowtype_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
23: l_rowtype_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
24: l_rowtype_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
17:
18: l_rowtype_rec.ATTRIBUTE1 := FND_API.G_MISS_CHAR;
19: l_rowtype_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
20: l_rowtype_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
21: l_rowtype_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
22: l_rowtype_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
23: l_rowtype_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
24: l_rowtype_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
25: l_rowtype_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
18: l_rowtype_rec.ATTRIBUTE1 := FND_API.G_MISS_CHAR;
19: l_rowtype_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
20: l_rowtype_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
21: l_rowtype_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
22: l_rowtype_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
23: l_rowtype_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
24: l_rowtype_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
25: l_rowtype_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
26: l_rowtype_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
19: l_rowtype_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
20: l_rowtype_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
21: l_rowtype_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
22: l_rowtype_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
23: l_rowtype_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
24: l_rowtype_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
25: l_rowtype_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
26: l_rowtype_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
27: l_rowtype_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
20: l_rowtype_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
21: l_rowtype_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
22: l_rowtype_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
23: l_rowtype_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
24: l_rowtype_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
25: l_rowtype_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
26: l_rowtype_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
27: l_rowtype_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
28: l_rowtype_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
21: l_rowtype_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
22: l_rowtype_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
23: l_rowtype_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
24: l_rowtype_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
25: l_rowtype_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
26: l_rowtype_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
27: l_rowtype_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
28: l_rowtype_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
29: l_rowtype_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
22: l_rowtype_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
23: l_rowtype_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
24: l_rowtype_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
25: l_rowtype_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
26: l_rowtype_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
27: l_rowtype_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
28: l_rowtype_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
29: l_rowtype_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
30: l_rowtype_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
23: l_rowtype_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
24: l_rowtype_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
25: l_rowtype_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
26: l_rowtype_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
27: l_rowtype_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
28: l_rowtype_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
29: l_rowtype_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
30: l_rowtype_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
31: l_rowtype_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
24: l_rowtype_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
25: l_rowtype_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
26: l_rowtype_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
27: l_rowtype_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
28: l_rowtype_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
29: l_rowtype_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
30: l_rowtype_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
31: l_rowtype_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
32: l_rowtype_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
25: l_rowtype_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
26: l_rowtype_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
27: l_rowtype_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
28: l_rowtype_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
29: l_rowtype_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
30: l_rowtype_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
31: l_rowtype_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
32: l_rowtype_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
33: l_rowtype_rec.CONTEXT := FND_API.G_MISS_CHAR;
26: l_rowtype_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
27: l_rowtype_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
28: l_rowtype_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
29: l_rowtype_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
30: l_rowtype_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
31: l_rowtype_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
32: l_rowtype_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
33: l_rowtype_rec.CONTEXT := FND_API.G_MISS_CHAR;
34: l_rowtype_rec.CREATED_BY := FND_API.G_MISS_NUM;
27: l_rowtype_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
28: l_rowtype_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
29: l_rowtype_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
30: l_rowtype_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
31: l_rowtype_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
32: l_rowtype_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
33: l_rowtype_rec.CONTEXT := FND_API.G_MISS_CHAR;
34: l_rowtype_rec.CREATED_BY := FND_API.G_MISS_NUM;
35: l_rowtype_rec.CREATION_DATE := FND_API.G_MISS_DATE;
28: l_rowtype_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
29: l_rowtype_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
30: l_rowtype_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
31: l_rowtype_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
32: l_rowtype_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
33: l_rowtype_rec.CONTEXT := FND_API.G_MISS_CHAR;
34: l_rowtype_rec.CREATED_BY := FND_API.G_MISS_NUM;
35: l_rowtype_rec.CREATION_DATE := FND_API.G_MISS_DATE;
36: l_rowtype_rec.DB_FLAG := FND_API.G_MISS_CHAR;
29: l_rowtype_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
30: l_rowtype_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
31: l_rowtype_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
32: l_rowtype_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
33: l_rowtype_rec.CONTEXT := FND_API.G_MISS_CHAR;
34: l_rowtype_rec.CREATED_BY := FND_API.G_MISS_NUM;
35: l_rowtype_rec.CREATION_DATE := FND_API.G_MISS_DATE;
36: l_rowtype_rec.DB_FLAG := FND_API.G_MISS_CHAR;
37: l_rowtype_rec.DW_UPDATE_ADVICE_FLAG := FND_API.G_MISS_CHAR;
30: l_rowtype_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
31: l_rowtype_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
32: l_rowtype_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
33: l_rowtype_rec.CONTEXT := FND_API.G_MISS_CHAR;
34: l_rowtype_rec.CREATED_BY := FND_API.G_MISS_NUM;
35: l_rowtype_rec.CREATION_DATE := FND_API.G_MISS_DATE;
36: l_rowtype_rec.DB_FLAG := FND_API.G_MISS_CHAR;
37: l_rowtype_rec.DW_UPDATE_ADVICE_FLAG := FND_API.G_MISS_CHAR;
38: l_rowtype_rec.HEADER_ID := FND_API.G_MISS_NUM;
31: l_rowtype_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
32: l_rowtype_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
33: l_rowtype_rec.CONTEXT := FND_API.G_MISS_CHAR;
34: l_rowtype_rec.CREATED_BY := FND_API.G_MISS_NUM;
35: l_rowtype_rec.CREATION_DATE := FND_API.G_MISS_DATE;
36: l_rowtype_rec.DB_FLAG := FND_API.G_MISS_CHAR;
37: l_rowtype_rec.DW_UPDATE_ADVICE_FLAG := FND_API.G_MISS_CHAR;
38: l_rowtype_rec.HEADER_ID := FND_API.G_MISS_NUM;
39: l_rowtype_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
32: l_rowtype_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
33: l_rowtype_rec.CONTEXT := FND_API.G_MISS_CHAR;
34: l_rowtype_rec.CREATED_BY := FND_API.G_MISS_NUM;
35: l_rowtype_rec.CREATION_DATE := FND_API.G_MISS_DATE;
36: l_rowtype_rec.DB_FLAG := FND_API.G_MISS_CHAR;
37: l_rowtype_rec.DW_UPDATE_ADVICE_FLAG := FND_API.G_MISS_CHAR;
38: l_rowtype_rec.HEADER_ID := FND_API.G_MISS_NUM;
39: l_rowtype_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
40: l_rowtype_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
33: l_rowtype_rec.CONTEXT := FND_API.G_MISS_CHAR;
34: l_rowtype_rec.CREATED_BY := FND_API.G_MISS_NUM;
35: l_rowtype_rec.CREATION_DATE := FND_API.G_MISS_DATE;
36: l_rowtype_rec.DB_FLAG := FND_API.G_MISS_CHAR;
37: l_rowtype_rec.DW_UPDATE_ADVICE_FLAG := FND_API.G_MISS_CHAR;
38: l_rowtype_rec.HEADER_ID := FND_API.G_MISS_NUM;
39: l_rowtype_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
40: l_rowtype_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
41: l_rowtype_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
34: l_rowtype_rec.CREATED_BY := FND_API.G_MISS_NUM;
35: l_rowtype_rec.CREATION_DATE := FND_API.G_MISS_DATE;
36: l_rowtype_rec.DB_FLAG := FND_API.G_MISS_CHAR;
37: l_rowtype_rec.DW_UPDATE_ADVICE_FLAG := FND_API.G_MISS_CHAR;
38: l_rowtype_rec.HEADER_ID := FND_API.G_MISS_NUM;
39: l_rowtype_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
40: l_rowtype_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
41: l_rowtype_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
42: l_rowtype_rec.LINE_ID := FND_API.G_MISS_NUM;
35: l_rowtype_rec.CREATION_DATE := FND_API.G_MISS_DATE;
36: l_rowtype_rec.DB_FLAG := FND_API.G_MISS_CHAR;
37: l_rowtype_rec.DW_UPDATE_ADVICE_FLAG := FND_API.G_MISS_CHAR;
38: l_rowtype_rec.HEADER_ID := FND_API.G_MISS_NUM;
39: l_rowtype_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
40: l_rowtype_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
41: l_rowtype_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
42: l_rowtype_rec.LINE_ID := FND_API.G_MISS_NUM;
43: l_rowtype_rec.OPERATION := FND_API.G_MISS_CHAR;
36: l_rowtype_rec.DB_FLAG := FND_API.G_MISS_CHAR;
37: l_rowtype_rec.DW_UPDATE_ADVICE_FLAG := FND_API.G_MISS_CHAR;
38: l_rowtype_rec.HEADER_ID := FND_API.G_MISS_NUM;
39: l_rowtype_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
40: l_rowtype_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
41: l_rowtype_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
42: l_rowtype_rec.LINE_ID := FND_API.G_MISS_NUM;
43: l_rowtype_rec.OPERATION := FND_API.G_MISS_CHAR;
44: l_rowtype_rec.PERCENT := FND_API.G_MISS_NUM;
37: l_rowtype_rec.DW_UPDATE_ADVICE_FLAG := FND_API.G_MISS_CHAR;
38: l_rowtype_rec.HEADER_ID := FND_API.G_MISS_NUM;
39: l_rowtype_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
40: l_rowtype_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
41: l_rowtype_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
42: l_rowtype_rec.LINE_ID := FND_API.G_MISS_NUM;
43: l_rowtype_rec.OPERATION := FND_API.G_MISS_CHAR;
44: l_rowtype_rec.PERCENT := FND_API.G_MISS_NUM;
45: l_rowtype_rec.RETURN_STATUS := FND_API.G_MISS_CHAR;
38: l_rowtype_rec.HEADER_ID := FND_API.G_MISS_NUM;
39: l_rowtype_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
40: l_rowtype_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
41: l_rowtype_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
42: l_rowtype_rec.LINE_ID := FND_API.G_MISS_NUM;
43: l_rowtype_rec.OPERATION := FND_API.G_MISS_CHAR;
44: l_rowtype_rec.PERCENT := FND_API.G_MISS_NUM;
45: l_rowtype_rec.RETURN_STATUS := FND_API.G_MISS_CHAR;
46: l_rowtype_rec.SALESREP_ID := FND_API.G_MISS_NUM;
39: l_rowtype_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
40: l_rowtype_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
41: l_rowtype_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
42: l_rowtype_rec.LINE_ID := FND_API.G_MISS_NUM;
43: l_rowtype_rec.OPERATION := FND_API.G_MISS_CHAR;
44: l_rowtype_rec.PERCENT := FND_API.G_MISS_NUM;
45: l_rowtype_rec.RETURN_STATUS := FND_API.G_MISS_CHAR;
46: l_rowtype_rec.SALESREP_ID := FND_API.G_MISS_NUM;
47: l_rowtype_rec.sales_credit_type_id:= FND_API.G_MISS_NUM;
40: l_rowtype_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
41: l_rowtype_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
42: l_rowtype_rec.LINE_ID := FND_API.G_MISS_NUM;
43: l_rowtype_rec.OPERATION := FND_API.G_MISS_CHAR;
44: l_rowtype_rec.PERCENT := FND_API.G_MISS_NUM;
45: l_rowtype_rec.RETURN_STATUS := FND_API.G_MISS_CHAR;
46: l_rowtype_rec.SALESREP_ID := FND_API.G_MISS_NUM;
47: l_rowtype_rec.sales_credit_type_id:= FND_API.G_MISS_NUM;
48: l_rowtype_rec.SALES_CREDIT_ID := FND_API.G_MISS_NUM;
41: l_rowtype_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
42: l_rowtype_rec.LINE_ID := FND_API.G_MISS_NUM;
43: l_rowtype_rec.OPERATION := FND_API.G_MISS_CHAR;
44: l_rowtype_rec.PERCENT := FND_API.G_MISS_NUM;
45: l_rowtype_rec.RETURN_STATUS := FND_API.G_MISS_CHAR;
46: l_rowtype_rec.SALESREP_ID := FND_API.G_MISS_NUM;
47: l_rowtype_rec.sales_credit_type_id:= FND_API.G_MISS_NUM;
48: l_rowtype_rec.SALES_CREDIT_ID := FND_API.G_MISS_NUM;
49: l_rowtype_rec.WH_UPDATE_DATE := FND_API.G_MISS_DATE;
42: l_rowtype_rec.LINE_ID := FND_API.G_MISS_NUM;
43: l_rowtype_rec.OPERATION := FND_API.G_MISS_CHAR;
44: l_rowtype_rec.PERCENT := FND_API.G_MISS_NUM;
45: l_rowtype_rec.RETURN_STATUS := FND_API.G_MISS_CHAR;
46: l_rowtype_rec.SALESREP_ID := FND_API.G_MISS_NUM;
47: l_rowtype_rec.sales_credit_type_id:= FND_API.G_MISS_NUM;
48: l_rowtype_rec.SALES_CREDIT_ID := FND_API.G_MISS_NUM;
49: l_rowtype_rec.WH_UPDATE_DATE := FND_API.G_MISS_DATE;
50:
43: l_rowtype_rec.OPERATION := FND_API.G_MISS_CHAR;
44: l_rowtype_rec.PERCENT := FND_API.G_MISS_NUM;
45: l_rowtype_rec.RETURN_STATUS := FND_API.G_MISS_CHAR;
46: l_rowtype_rec.SALESREP_ID := FND_API.G_MISS_NUM;
47: l_rowtype_rec.sales_credit_type_id:= FND_API.G_MISS_NUM;
48: l_rowtype_rec.SALES_CREDIT_ID := FND_API.G_MISS_NUM;
49: l_rowtype_rec.WH_UPDATE_DATE := FND_API.G_MISS_DATE;
50:
51: RETURN l_rowtype_rec;
44: l_rowtype_rec.PERCENT := FND_API.G_MISS_NUM;
45: l_rowtype_rec.RETURN_STATUS := FND_API.G_MISS_CHAR;
46: l_rowtype_rec.SALESREP_ID := FND_API.G_MISS_NUM;
47: l_rowtype_rec.sales_credit_type_id:= FND_API.G_MISS_NUM;
48: l_rowtype_rec.SALES_CREDIT_ID := FND_API.G_MISS_NUM;
49: l_rowtype_rec.WH_UPDATE_DATE := FND_API.G_MISS_DATE;
50:
51: RETURN l_rowtype_rec;
52:
45: l_rowtype_rec.RETURN_STATUS := FND_API.G_MISS_CHAR;
46: l_rowtype_rec.SALESREP_ID := FND_API.G_MISS_NUM;
47: l_rowtype_rec.sales_credit_type_id:= FND_API.G_MISS_NUM;
48: l_rowtype_rec.SALES_CREDIT_ID := FND_API.G_MISS_NUM;
49: l_rowtype_rec.WH_UPDATE_DATE := FND_API.G_MISS_DATE;
50:
51: RETURN l_rowtype_rec;
52:
53: END G_MISS_OE_AK_LINE_SCREDIT_REC;
141:
142: END Rowtype_Rec_To_API_Rec;
143:
144: PROCEDURE Clear_Dependent_Attr
145: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
146: , p_x_Line_Scredit_rec IN OUT NOCOPY OE_AK_LINE_SCREDITS_V%ROWTYPE
147: , p_old_Line_Scredit_rec IN OE_AK_LINE_SCREDITS_V%ROWTYPE :=
148: G_MISS_OE_AK_LINE_SCREDIT_REC
149: )
162:
163: -- If attr_id is missing compare old and new records and for
164: -- every changed attribute clear its dependent fields.
165:
166: IF p_attr_id = FND_API.G_MISS_NUM THEN
167:
168: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.attribute1,p_old_Line_Scredit_rec.attribute1)
169: THEN
170: l_index := l_index + 1;
437: p_dep_attr_tbl => l_dep_attr_tbl);
438:
439: FOR I IN 1..l_dep_attr_tbl.COUNT LOOP
440: IF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE1 THEN
441: p_x_Line_Scredit_rec.ATTRIBUTE1 := FND_API.G_MISS_NUM;
442: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE10 THEN
443: p_x_Line_Scredit_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
444: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE11 THEN
445: p_x_Line_Scredit_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
439: FOR I IN 1..l_dep_attr_tbl.COUNT LOOP
440: IF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE1 THEN
441: p_x_Line_Scredit_rec.ATTRIBUTE1 := FND_API.G_MISS_NUM;
442: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE10 THEN
443: p_x_Line_Scredit_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
444: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE11 THEN
445: p_x_Line_Scredit_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
446: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE12 THEN
447: p_x_Line_Scredit_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
441: p_x_Line_Scredit_rec.ATTRIBUTE1 := FND_API.G_MISS_NUM;
442: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE10 THEN
443: p_x_Line_Scredit_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
444: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE11 THEN
445: p_x_Line_Scredit_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
446: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE12 THEN
447: p_x_Line_Scredit_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
448: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE13 THEN
449: p_x_Line_Scredit_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
443: p_x_Line_Scredit_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
444: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE11 THEN
445: p_x_Line_Scredit_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
446: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE12 THEN
447: p_x_Line_Scredit_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
448: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE13 THEN
449: p_x_Line_Scredit_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
450: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE14 THEN
451: p_x_Line_Scredit_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
445: p_x_Line_Scredit_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
446: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE12 THEN
447: p_x_Line_Scredit_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
448: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE13 THEN
449: p_x_Line_Scredit_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
450: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE14 THEN
451: p_x_Line_Scredit_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
452: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE15 THEN
453: p_x_Line_Scredit_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
447: p_x_Line_Scredit_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
448: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE13 THEN
449: p_x_Line_Scredit_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
450: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE14 THEN
451: p_x_Line_Scredit_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
452: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE15 THEN
453: p_x_Line_Scredit_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
454: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE2 THEN
455: p_x_Line_Scredit_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
449: p_x_Line_Scredit_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
450: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE14 THEN
451: p_x_Line_Scredit_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
452: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE15 THEN
453: p_x_Line_Scredit_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
454: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE2 THEN
455: p_x_Line_Scredit_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
456: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE3 THEN
457: p_x_Line_Scredit_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
451: p_x_Line_Scredit_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
452: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE15 THEN
453: p_x_Line_Scredit_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
454: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE2 THEN
455: p_x_Line_Scredit_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
456: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE3 THEN
457: p_x_Line_Scredit_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
458: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE4 THEN
459: p_x_Line_Scredit_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
453: p_x_Line_Scredit_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
454: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE2 THEN
455: p_x_Line_Scredit_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
456: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE3 THEN
457: p_x_Line_Scredit_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
458: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE4 THEN
459: p_x_Line_Scredit_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
460: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE5 THEN
461: p_x_Line_Scredit_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
455: p_x_Line_Scredit_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
456: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE3 THEN
457: p_x_Line_Scredit_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
458: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE4 THEN
459: p_x_Line_Scredit_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
460: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE5 THEN
461: p_x_Line_Scredit_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
462: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE6 THEN
463: p_x_Line_Scredit_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
457: p_x_Line_Scredit_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
458: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE4 THEN
459: p_x_Line_Scredit_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
460: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE5 THEN
461: p_x_Line_Scredit_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
462: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE6 THEN
463: p_x_Line_Scredit_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
464: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE7 THEN
465: p_x_Line_Scredit_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
459: p_x_Line_Scredit_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
460: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE5 THEN
461: p_x_Line_Scredit_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
462: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE6 THEN
463: p_x_Line_Scredit_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
464: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE7 THEN
465: p_x_Line_Scredit_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
466: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE8 THEN
467: p_x_Line_Scredit_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
461: p_x_Line_Scredit_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
462: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE6 THEN
463: p_x_Line_Scredit_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
464: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE7 THEN
465: p_x_Line_Scredit_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
466: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE8 THEN
467: p_x_Line_Scredit_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
468: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE9 THEN
469: p_x_Line_Scredit_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
463: p_x_Line_Scredit_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
464: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE7 THEN
465: p_x_Line_Scredit_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
466: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE8 THEN
467: p_x_Line_Scredit_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
468: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE9 THEN
469: p_x_Line_Scredit_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
470: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_CONTEXT THEN
471: p_x_Line_Scredit_rec.CONTEXT := FND_API.G_MISS_CHAR;
465: p_x_Line_Scredit_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
466: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE8 THEN
467: p_x_Line_Scredit_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
468: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE9 THEN
469: p_x_Line_Scredit_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
470: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_CONTEXT THEN
471: p_x_Line_Scredit_rec.CONTEXT := FND_API.G_MISS_CHAR;
472: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_CREATED_BY THEN
473: p_x_Line_Scredit_rec.CREATED_BY := FND_API.G_MISS_NUM;
467: p_x_Line_Scredit_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
468: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_ATTRIBUTE9 THEN
469: p_x_Line_Scredit_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
470: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_CONTEXT THEN
471: p_x_Line_Scredit_rec.CONTEXT := FND_API.G_MISS_CHAR;
472: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_CREATED_BY THEN
473: p_x_Line_Scredit_rec.CREATED_BY := FND_API.G_MISS_NUM;
474: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_CREATION_DATE THEN
475: p_x_Line_Scredit_rec.CREATION_DATE := FND_API.G_MISS_DATE;
469: p_x_Line_Scredit_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
470: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_CONTEXT THEN
471: p_x_Line_Scredit_rec.CONTEXT := FND_API.G_MISS_CHAR;
472: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_CREATED_BY THEN
473: p_x_Line_Scredit_rec.CREATED_BY := FND_API.G_MISS_NUM;
474: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_CREATION_DATE THEN
475: p_x_Line_Scredit_rec.CREATION_DATE := FND_API.G_MISS_DATE;
476: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_DW_UPDATE_ADVICE THEN
477: p_x_Line_Scredit_rec.DW_UPDATE_ADVICE_FLAG := FND_API.G_MISS_CHAR;
471: p_x_Line_Scredit_rec.CONTEXT := FND_API.G_MISS_CHAR;
472: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_CREATED_BY THEN
473: p_x_Line_Scredit_rec.CREATED_BY := FND_API.G_MISS_NUM;
474: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_CREATION_DATE THEN
475: p_x_Line_Scredit_rec.CREATION_DATE := FND_API.G_MISS_DATE;
476: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_DW_UPDATE_ADVICE THEN
477: p_x_Line_Scredit_rec.DW_UPDATE_ADVICE_FLAG := FND_API.G_MISS_CHAR;
478: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_HEADER THEN
479: p_x_Line_Scredit_rec.HEADER_ID := FND_API.G_MISS_NUM;
473: p_x_Line_Scredit_rec.CREATED_BY := FND_API.G_MISS_NUM;
474: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_CREATION_DATE THEN
475: p_x_Line_Scredit_rec.CREATION_DATE := FND_API.G_MISS_DATE;
476: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_DW_UPDATE_ADVICE THEN
477: p_x_Line_Scredit_rec.DW_UPDATE_ADVICE_FLAG := FND_API.G_MISS_CHAR;
478: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_HEADER THEN
479: p_x_Line_Scredit_rec.HEADER_ID := FND_API.G_MISS_NUM;
480: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_LAST_UPDATED_BY THEN
481: p_x_Line_Scredit_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
475: p_x_Line_Scredit_rec.CREATION_DATE := FND_API.G_MISS_DATE;
476: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_DW_UPDATE_ADVICE THEN
477: p_x_Line_Scredit_rec.DW_UPDATE_ADVICE_FLAG := FND_API.G_MISS_CHAR;
478: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_HEADER THEN
479: p_x_Line_Scredit_rec.HEADER_ID := FND_API.G_MISS_NUM;
480: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_LAST_UPDATED_BY THEN
481: p_x_Line_Scredit_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
482: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_LAST_UPDATE_DATE THEN
483: p_x_Line_Scredit_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
477: p_x_Line_Scredit_rec.DW_UPDATE_ADVICE_FLAG := FND_API.G_MISS_CHAR;
478: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_HEADER THEN
479: p_x_Line_Scredit_rec.HEADER_ID := FND_API.G_MISS_NUM;
480: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_LAST_UPDATED_BY THEN
481: p_x_Line_Scredit_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
482: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_LAST_UPDATE_DATE THEN
483: p_x_Line_Scredit_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
484: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_LAST_UPDATE_LOGIN THEN
485: p_x_Line_Scredit_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
479: p_x_Line_Scredit_rec.HEADER_ID := FND_API.G_MISS_NUM;
480: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_LAST_UPDATED_BY THEN
481: p_x_Line_Scredit_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
482: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_LAST_UPDATE_DATE THEN
483: p_x_Line_Scredit_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
484: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_LAST_UPDATE_LOGIN THEN
485: p_x_Line_Scredit_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
486: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_LINE THEN
487: p_x_Line_Scredit_rec.LINE_ID := FND_API.G_MISS_NUM;
481: p_x_Line_Scredit_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
482: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_LAST_UPDATE_DATE THEN
483: p_x_Line_Scredit_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
484: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_LAST_UPDATE_LOGIN THEN
485: p_x_Line_Scredit_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
486: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_LINE THEN
487: p_x_Line_Scredit_rec.LINE_ID := FND_API.G_MISS_NUM;
488: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_PERCENT THEN
489: p_x_Line_Scredit_rec.PERCENT := FND_API.G_MISS_NUM;
483: p_x_Line_Scredit_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
484: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_LAST_UPDATE_LOGIN THEN
485: p_x_Line_Scredit_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
486: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_LINE THEN
487: p_x_Line_Scredit_rec.LINE_ID := FND_API.G_MISS_NUM;
488: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_PERCENT THEN
489: p_x_Line_Scredit_rec.PERCENT := FND_API.G_MISS_NUM;
490: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_SALESREP THEN
491: p_x_Line_Scredit_rec.SALESREP_ID := FND_API.G_MISS_NUM;
485: p_x_Line_Scredit_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
486: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_LINE THEN
487: p_x_Line_Scredit_rec.LINE_ID := FND_API.G_MISS_NUM;
488: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_PERCENT THEN
489: p_x_Line_Scredit_rec.PERCENT := FND_API.G_MISS_NUM;
490: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_SALESREP THEN
491: p_x_Line_Scredit_rec.SALESREP_ID := FND_API.G_MISS_NUM;
492: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_sales_credit_type THEN
493: p_x_Line_Scredit_rec.sales_credit_type_id := FND_API.G_MISS_NUM;
487: p_x_Line_Scredit_rec.LINE_ID := FND_API.G_MISS_NUM;
488: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_PERCENT THEN
489: p_x_Line_Scredit_rec.PERCENT := FND_API.G_MISS_NUM;
490: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_SALESREP THEN
491: p_x_Line_Scredit_rec.SALESREP_ID := FND_API.G_MISS_NUM;
492: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_sales_credit_type THEN
493: p_x_Line_Scredit_rec.sales_credit_type_id := FND_API.G_MISS_NUM;
494: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_SALES_CREDIT THEN
495: p_x_Line_Scredit_rec.SALES_CREDIT_ID := FND_API.G_MISS_NUM;
489: p_x_Line_Scredit_rec.PERCENT := FND_API.G_MISS_NUM;
490: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_SALESREP THEN
491: p_x_Line_Scredit_rec.SALESREP_ID := FND_API.G_MISS_NUM;
492: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_sales_credit_type THEN
493: p_x_Line_Scredit_rec.sales_credit_type_id := FND_API.G_MISS_NUM;
494: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_SALES_CREDIT THEN
495: p_x_Line_Scredit_rec.SALES_CREDIT_ID := FND_API.G_MISS_NUM;
496: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_WH_UPDATE_DATE THEN
497: p_x_Line_Scredit_rec.WH_UPDATE_DATE := FND_API.G_MISS_DATE;
491: p_x_Line_Scredit_rec.SALESREP_ID := FND_API.G_MISS_NUM;
492: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_sales_credit_type THEN
493: p_x_Line_Scredit_rec.sales_credit_type_id := FND_API.G_MISS_NUM;
494: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_SALES_CREDIT THEN
495: p_x_Line_Scredit_rec.SALES_CREDIT_ID := FND_API.G_MISS_NUM;
496: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_WH_UPDATE_DATE THEN
497: p_x_Line_Scredit_rec.WH_UPDATE_DATE := FND_API.G_MISS_DATE;
498: END IF;
499: END LOOP;
493: p_x_Line_Scredit_rec.sales_credit_type_id := FND_API.G_MISS_NUM;
494: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_SALES_CREDIT THEN
495: p_x_Line_Scredit_rec.SALES_CREDIT_ID := FND_API.G_MISS_NUM;
496: ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_WH_UPDATE_DATE THEN
497: p_x_Line_Scredit_rec.WH_UPDATE_DATE := FND_API.G_MISS_DATE;
498: END IF;
499: END LOOP;
500: END IF;
501:
508:
509: -- Procedure Clear_Dependent_Attr
510:
511: PROCEDURE Clear_Dependent_Attr
512: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
513: , p_x_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type
514: , p_old_Line_Scredit_rec IN OE_Order_PUB.Line_Scredit_Rec_Type :=
515: OE_Order_PUB.G_MISS_LINE_SCREDIT_REC
516: )
689: ,p_requesting_entity_id=>p_x_Line_Scredit_rec.sales_credit_id
690: ,p_request_type=>OE_GLOBALS.G_CHECK_LSC_QUOTA_TOTAL
691: ,p_param1 => to_char(p_x_Line_Scredit_rec.Line_id)
692: ,x_return_status =>l_return_status);
693: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
694: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
695: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
696: RAISE FND_API.G_EXC_ERROR;
697: END IF;
690: ,p_request_type=>OE_GLOBALS.G_CHECK_LSC_QUOTA_TOTAL
691: ,p_param1 => to_char(p_x_Line_Scredit_rec.Line_id)
692: ,x_return_status =>l_return_status);
693: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
694: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
695: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
696: RAISE FND_API.G_EXC_ERROR;
697: END IF;
698:
691: ,p_param1 => to_char(p_x_Line_Scredit_rec.Line_id)
692: ,x_return_status =>l_return_status);
693: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
694: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
695: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
696: RAISE FND_API.G_EXC_ERROR;
697: END IF;
698:
699: -- Add delayed request to cascade changes to service lines.
692: ,x_return_status =>l_return_status);
693: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
694: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
695: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
696: RAISE FND_API.G_EXC_ERROR;
697: END IF;
698:
699: -- Add delayed request to cascade changes to service lines.
700: OE_Delayed_Requests_Pvt.Log_Request
712: ,p_param6 => to_char(p_old_Line_Scredit_rec.percent)
713: ,p_param7 => p_x_Line_Scredit_rec.operation
714: ,x_return_status =>l_return_status);
715:
716: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
717: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
718: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
719: RAISE FND_API.G_EXC_ERROR;
720: END IF;
713: ,p_param7 => p_x_Line_Scredit_rec.operation
714: ,x_return_status =>l_return_status);
715:
716: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
717: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
718: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
719: RAISE FND_API.G_EXC_ERROR;
720: END IF;
721:
714: ,x_return_status =>l_return_status);
715:
716: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
717: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
718: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
719: RAISE FND_API.G_EXC_ERROR;
720: END IF;
721:
722: END IF;
715:
716: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
717: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
718: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
719: RAISE FND_API.G_EXC_ERROR;
720: END IF;
721:
722: END IF;
723:
731: ,p_requesting_entity_id=>p_x_Line_Scredit_rec.sales_credit_id
732: ,p_request_type=>OE_GLOBALS.G_CHECK_LSC_QUOTA_TOTAL
733: ,p_param1 => to_char(p_x_Line_Scredit_rec.Line_id)
734: ,x_return_status =>l_return_status);
735: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
737: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
738: RAISE FND_API.G_EXC_ERROR;
739: END IF;
732: ,p_request_type=>OE_GLOBALS.G_CHECK_LSC_QUOTA_TOTAL
733: ,p_param1 => to_char(p_x_Line_Scredit_rec.Line_id)
734: ,x_return_status =>l_return_status);
735: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
737: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
738: RAISE FND_API.G_EXC_ERROR;
739: END IF;
740: --END IF; Commented of this end if as part of fix for bug#2174201
733: ,p_param1 => to_char(p_x_Line_Scredit_rec.Line_id)
734: ,x_return_status =>l_return_status);
735: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
737: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
738: RAISE FND_API.G_EXC_ERROR;
739: END IF;
740: --END IF; Commented of this end if as part of fix for bug#2174201
741:
734: ,x_return_status =>l_return_status);
735: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
737: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
738: RAISE FND_API.G_EXC_ERROR;
739: END IF;
740: --END IF; Commented of this end if as part of fix for bug#2174201
741:
742: -- Add delayed request to cascade changes to service lines.
755: ,p_param6 => to_char(p_old_Line_Scredit_rec.percent)
756: ,p_param7 => p_x_Line_Scredit_rec.operation
757: ,x_return_status =>l_return_status);
758:
759: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
760: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
761: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
762: RAISE FND_API.G_EXC_ERROR;
763: END IF;
756: ,p_param7 => p_x_Line_Scredit_rec.operation
757: ,x_return_status =>l_return_status);
758:
759: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
760: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
761: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
762: RAISE FND_API.G_EXC_ERROR;
763: END IF;
764: END IF; --Commented end if moved here as part of fix for bug#2174201
757: ,x_return_status =>l_return_status);
758:
759: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
760: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
761: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
762: RAISE FND_API.G_EXC_ERROR;
763: END IF;
764: END IF; --Commented end if moved here as part of fix for bug#2174201
765:
758:
759: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
760: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
761: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
762: RAISE FND_API.G_EXC_ERROR;
763: END IF;
764: END IF; --Commented end if moved here as part of fix for bug#2174201
765:
766: IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.salesrep_id,p_old_Line_Scredit_rec.salesrep_id)
781: ,p_param6 => to_char(p_old_Line_Scredit_rec.percent)
782: ,p_param7 => p_x_Line_Scredit_rec.operation
783: ,x_return_status =>l_return_status);
784:
785: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
787: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
788: RAISE FND_API.G_EXC_ERROR;
789: END IF;
782: ,p_param7 => p_x_Line_Scredit_rec.operation
783: ,x_return_status =>l_return_status);
784:
785: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
787: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
788: RAISE FND_API.G_EXC_ERROR;
789: END IF;
790:
783: ,x_return_status =>l_return_status);
784:
785: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
787: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
788: RAISE FND_API.G_EXC_ERROR;
789: END IF;
790:
791: --SG{
784:
785: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
787: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
788: RAISE FND_API.G_EXC_ERROR;
789: END IF;
790:
791: --SG{
792: IF OE_ORDER_CACHE.G_HEADER_REC.header_id IS NULL THEN
822:
823:
824: --SG{
825: IF nvl(p_x_line_Scredit_rec.sales_group_updated_flag,'N') <> 'Y'
826: AND nvl(p_x_line_Scredit_rec.salesrep_id,FND_API.G_MISS_NUM)<>FND_API.G_MISS_NUM
827: THEN
828:
829: IF OE_ORDER_CACHE.G_HEADER_REC.header_id IS NULL THEN
830: --header not available in cache, load info to cache
885: IF l_debug_level > 0 THEN
886: oe_debug_pub.add( 'ENTERING OE_LINE_SCREDIT_UTIL.COMPLETE_RECORD' , 1 ) ;
887: END IF;
888:
889: IF p_x_Line_Scredit_rec.attribute1 = FND_API.G_MISS_CHAR THEN
890: p_x_Line_Scredit_rec.attribute1 := p_old_Line_Scredit_rec.attribute1;
891: END IF;
892:
893: IF p_x_Line_Scredit_rec.attribute10 = FND_API.G_MISS_CHAR THEN
889: IF p_x_Line_Scredit_rec.attribute1 = FND_API.G_MISS_CHAR THEN
890: p_x_Line_Scredit_rec.attribute1 := p_old_Line_Scredit_rec.attribute1;
891: END IF;
892:
893: IF p_x_Line_Scredit_rec.attribute10 = FND_API.G_MISS_CHAR THEN
894: p_x_Line_Scredit_rec.attribute10 := p_old_Line_Scredit_rec.attribute10;
895: END IF;
896:
897: IF p_x_Line_Scredit_rec.attribute11 = FND_API.G_MISS_CHAR THEN
893: IF p_x_Line_Scredit_rec.attribute10 = FND_API.G_MISS_CHAR THEN
894: p_x_Line_Scredit_rec.attribute10 := p_old_Line_Scredit_rec.attribute10;
895: END IF;
896:
897: IF p_x_Line_Scredit_rec.attribute11 = FND_API.G_MISS_CHAR THEN
898: p_x_Line_Scredit_rec.attribute11 := p_old_Line_Scredit_rec.attribute11;
899: END IF;
900:
901: IF p_x_Line_Scredit_rec.attribute12 = FND_API.G_MISS_CHAR THEN
897: IF p_x_Line_Scredit_rec.attribute11 = FND_API.G_MISS_CHAR THEN
898: p_x_Line_Scredit_rec.attribute11 := p_old_Line_Scredit_rec.attribute11;
899: END IF;
900:
901: IF p_x_Line_Scredit_rec.attribute12 = FND_API.G_MISS_CHAR THEN
902: p_x_Line_Scredit_rec.attribute12 := p_old_Line_Scredit_rec.attribute12;
903: END IF;
904:
905: IF p_x_Line_Scredit_rec.attribute13 = FND_API.G_MISS_CHAR THEN
901: IF p_x_Line_Scredit_rec.attribute12 = FND_API.G_MISS_CHAR THEN
902: p_x_Line_Scredit_rec.attribute12 := p_old_Line_Scredit_rec.attribute12;
903: END IF;
904:
905: IF p_x_Line_Scredit_rec.attribute13 = FND_API.G_MISS_CHAR THEN
906: p_x_Line_Scredit_rec.attribute13 := p_old_Line_Scredit_rec.attribute13;
907: END IF;
908:
909: IF p_x_Line_Scredit_rec.attribute14 = FND_API.G_MISS_CHAR THEN
905: IF p_x_Line_Scredit_rec.attribute13 = FND_API.G_MISS_CHAR THEN
906: p_x_Line_Scredit_rec.attribute13 := p_old_Line_Scredit_rec.attribute13;
907: END IF;
908:
909: IF p_x_Line_Scredit_rec.attribute14 = FND_API.G_MISS_CHAR THEN
910: p_x_Line_Scredit_rec.attribute14 := p_old_Line_Scredit_rec.attribute14;
911: END IF;
912:
913: IF p_x_Line_Scredit_rec.attribute15 = FND_API.G_MISS_CHAR THEN
909: IF p_x_Line_Scredit_rec.attribute14 = FND_API.G_MISS_CHAR THEN
910: p_x_Line_Scredit_rec.attribute14 := p_old_Line_Scredit_rec.attribute14;
911: END IF;
912:
913: IF p_x_Line_Scredit_rec.attribute15 = FND_API.G_MISS_CHAR THEN
914: p_x_Line_Scredit_rec.attribute15 := p_old_Line_Scredit_rec.attribute15;
915: END IF;
916:
917: IF p_x_Line_Scredit_rec.attribute2 = FND_API.G_MISS_CHAR THEN
913: IF p_x_Line_Scredit_rec.attribute15 = FND_API.G_MISS_CHAR THEN
914: p_x_Line_Scredit_rec.attribute15 := p_old_Line_Scredit_rec.attribute15;
915: END IF;
916:
917: IF p_x_Line_Scredit_rec.attribute2 = FND_API.G_MISS_CHAR THEN
918: p_x_Line_Scredit_rec.attribute2 := p_old_Line_Scredit_rec.attribute2;
919: END IF;
920:
921: IF p_x_Line_Scredit_rec.attribute3 = FND_API.G_MISS_CHAR THEN
917: IF p_x_Line_Scredit_rec.attribute2 = FND_API.G_MISS_CHAR THEN
918: p_x_Line_Scredit_rec.attribute2 := p_old_Line_Scredit_rec.attribute2;
919: END IF;
920:
921: IF p_x_Line_Scredit_rec.attribute3 = FND_API.G_MISS_CHAR THEN
922: p_x_Line_Scredit_rec.attribute3 := p_old_Line_Scredit_rec.attribute3;
923: END IF;
924:
925: IF p_x_Line_Scredit_rec.attribute4 = FND_API.G_MISS_CHAR THEN
921: IF p_x_Line_Scredit_rec.attribute3 = FND_API.G_MISS_CHAR THEN
922: p_x_Line_Scredit_rec.attribute3 := p_old_Line_Scredit_rec.attribute3;
923: END IF;
924:
925: IF p_x_Line_Scredit_rec.attribute4 = FND_API.G_MISS_CHAR THEN
926: p_x_Line_Scredit_rec.attribute4 := p_old_Line_Scredit_rec.attribute4;
927: END IF;
928:
929: IF p_x_Line_Scredit_rec.attribute5 = FND_API.G_MISS_CHAR THEN
925: IF p_x_Line_Scredit_rec.attribute4 = FND_API.G_MISS_CHAR THEN
926: p_x_Line_Scredit_rec.attribute4 := p_old_Line_Scredit_rec.attribute4;
927: END IF;
928:
929: IF p_x_Line_Scredit_rec.attribute5 = FND_API.G_MISS_CHAR THEN
930: p_x_Line_Scredit_rec.attribute5 := p_old_Line_Scredit_rec.attribute5;
931: END IF;
932:
933: IF p_x_Line_Scredit_rec.attribute6 = FND_API.G_MISS_CHAR THEN
929: IF p_x_Line_Scredit_rec.attribute5 = FND_API.G_MISS_CHAR THEN
930: p_x_Line_Scredit_rec.attribute5 := p_old_Line_Scredit_rec.attribute5;
931: END IF;
932:
933: IF p_x_Line_Scredit_rec.attribute6 = FND_API.G_MISS_CHAR THEN
934: p_x_Line_Scredit_rec.attribute6 := p_old_Line_Scredit_rec.attribute6;
935: END IF;
936:
937: IF p_x_Line_Scredit_rec.attribute7 = FND_API.G_MISS_CHAR THEN
933: IF p_x_Line_Scredit_rec.attribute6 = FND_API.G_MISS_CHAR THEN
934: p_x_Line_Scredit_rec.attribute6 := p_old_Line_Scredit_rec.attribute6;
935: END IF;
936:
937: IF p_x_Line_Scredit_rec.attribute7 = FND_API.G_MISS_CHAR THEN
938: p_x_Line_Scredit_rec.attribute7 := p_old_Line_Scredit_rec.attribute7;
939: END IF;
940:
941: IF p_x_Line_Scredit_rec.attribute8 = FND_API.G_MISS_CHAR THEN
937: IF p_x_Line_Scredit_rec.attribute7 = FND_API.G_MISS_CHAR THEN
938: p_x_Line_Scredit_rec.attribute7 := p_old_Line_Scredit_rec.attribute7;
939: END IF;
940:
941: IF p_x_Line_Scredit_rec.attribute8 = FND_API.G_MISS_CHAR THEN
942: p_x_Line_Scredit_rec.attribute8 := p_old_Line_Scredit_rec.attribute8;
943: END IF;
944:
945: IF p_x_Line_Scredit_rec.attribute9 = FND_API.G_MISS_CHAR THEN
941: IF p_x_Line_Scredit_rec.attribute8 = FND_API.G_MISS_CHAR THEN
942: p_x_Line_Scredit_rec.attribute8 := p_old_Line_Scredit_rec.attribute8;
943: END IF;
944:
945: IF p_x_Line_Scredit_rec.attribute9 = FND_API.G_MISS_CHAR THEN
946: p_x_Line_Scredit_rec.attribute9 := p_old_Line_Scredit_rec.attribute9;
947: END IF;
948:
949: IF p_x_Line_Scredit_rec.context = FND_API.G_MISS_CHAR THEN
945: IF p_x_Line_Scredit_rec.attribute9 = FND_API.G_MISS_CHAR THEN
946: p_x_Line_Scredit_rec.attribute9 := p_old_Line_Scredit_rec.attribute9;
947: END IF;
948:
949: IF p_x_Line_Scredit_rec.context = FND_API.G_MISS_CHAR THEN
950: p_x_Line_Scredit_rec.context := p_old_Line_Scredit_rec.context;
951: END IF;
952:
953: IF p_x_Line_Scredit_rec.created_by = FND_API.G_MISS_NUM THEN
949: IF p_x_Line_Scredit_rec.context = FND_API.G_MISS_CHAR THEN
950: p_x_Line_Scredit_rec.context := p_old_Line_Scredit_rec.context;
951: END IF;
952:
953: IF p_x_Line_Scredit_rec.created_by = FND_API.G_MISS_NUM THEN
954: p_x_Line_Scredit_rec.created_by := p_old_Line_Scredit_rec.created_by;
955: END IF;
956:
957: IF p_x_Line_Scredit_rec.creation_date = FND_API.G_MISS_DATE THEN
953: IF p_x_Line_Scredit_rec.created_by = FND_API.G_MISS_NUM THEN
954: p_x_Line_Scredit_rec.created_by := p_old_Line_Scredit_rec.created_by;
955: END IF;
956:
957: IF p_x_Line_Scredit_rec.creation_date = FND_API.G_MISS_DATE THEN
958: p_x_Line_Scredit_rec.creation_date := p_old_Line_Scredit_rec.creation_date;
959: END IF;
960:
961: IF p_x_Line_Scredit_rec.dw_update_advice_flag = FND_API.G_MISS_CHAR THEN
957: IF p_x_Line_Scredit_rec.creation_date = FND_API.G_MISS_DATE THEN
958: p_x_Line_Scredit_rec.creation_date := p_old_Line_Scredit_rec.creation_date;
959: END IF;
960:
961: IF p_x_Line_Scredit_rec.dw_update_advice_flag = FND_API.G_MISS_CHAR THEN
962: p_x_Line_Scredit_rec.dw_update_advice_flag := p_old_Line_Scredit_rec.dw_update_advice_flag;
963: END IF;
964:
965: IF p_x_Line_Scredit_rec.header_id = FND_API.G_MISS_NUM THEN
961: IF p_x_Line_Scredit_rec.dw_update_advice_flag = FND_API.G_MISS_CHAR THEN
962: p_x_Line_Scredit_rec.dw_update_advice_flag := p_old_Line_Scredit_rec.dw_update_advice_flag;
963: END IF;
964:
965: IF p_x_Line_Scredit_rec.header_id = FND_API.G_MISS_NUM THEN
966: p_x_Line_Scredit_rec.header_id := p_old_Line_Scredit_rec.header_id;
967: END IF;
968:
969: IF p_x_Line_Scredit_rec.last_updated_by = FND_API.G_MISS_NUM THEN
965: IF p_x_Line_Scredit_rec.header_id = FND_API.G_MISS_NUM THEN
966: p_x_Line_Scredit_rec.header_id := p_old_Line_Scredit_rec.header_id;
967: END IF;
968:
969: IF p_x_Line_Scredit_rec.last_updated_by = FND_API.G_MISS_NUM THEN
970: p_x_Line_Scredit_rec.last_updated_by := p_old_Line_Scredit_rec.last_updated_by;
971: END IF;
972:
973: IF p_x_Line_Scredit_rec.last_update_date = FND_API.G_MISS_DATE THEN
969: IF p_x_Line_Scredit_rec.last_updated_by = FND_API.G_MISS_NUM THEN
970: p_x_Line_Scredit_rec.last_updated_by := p_old_Line_Scredit_rec.last_updated_by;
971: END IF;
972:
973: IF p_x_Line_Scredit_rec.last_update_date = FND_API.G_MISS_DATE THEN
974: p_x_Line_Scredit_rec.last_update_date := p_old_Line_Scredit_rec.last_update_date;
975: END IF;
976:
977: IF p_x_Line_Scredit_rec.last_update_login = FND_API.G_MISS_NUM THEN
973: IF p_x_Line_Scredit_rec.last_update_date = FND_API.G_MISS_DATE THEN
974: p_x_Line_Scredit_rec.last_update_date := p_old_Line_Scredit_rec.last_update_date;
975: END IF;
976:
977: IF p_x_Line_Scredit_rec.last_update_login = FND_API.G_MISS_NUM THEN
978: p_x_Line_Scredit_rec.last_update_login := p_old_Line_Scredit_rec.last_update_login;
979: END IF;
980:
981: IF p_x_Line_Scredit_rec.line_id = FND_API.G_MISS_NUM THEN
977: IF p_x_Line_Scredit_rec.last_update_login = FND_API.G_MISS_NUM THEN
978: p_x_Line_Scredit_rec.last_update_login := p_old_Line_Scredit_rec.last_update_login;
979: END IF;
980:
981: IF p_x_Line_Scredit_rec.line_id = FND_API.G_MISS_NUM THEN
982: p_x_Line_Scredit_rec.line_id := p_old_Line_Scredit_rec.line_id;
983: END IF;
984:
985: IF p_x_Line_Scredit_rec.percent = FND_API.G_MISS_NUM THEN
981: IF p_x_Line_Scredit_rec.line_id = FND_API.G_MISS_NUM THEN
982: p_x_Line_Scredit_rec.line_id := p_old_Line_Scredit_rec.line_id;
983: END IF;
984:
985: IF p_x_Line_Scredit_rec.percent = FND_API.G_MISS_NUM THEN
986: p_x_Line_Scredit_rec.percent := p_old_Line_Scredit_rec.percent;
987: END IF;
988:
989:
986: p_x_Line_Scredit_rec.percent := p_old_Line_Scredit_rec.percent;
987: END IF;
988:
989:
990: IF p_x_Line_Scredit_rec.salesrep_id = FND_API.G_MISS_NUM THEN
991: p_x_Line_Scredit_rec.salesrep_id := p_old_Line_Scredit_rec.salesrep_id;
992: END IF;
993: IF p_x_Line_Scredit_rec.sales_credit_type_id = FND_API.G_MISS_NUM THEN
994: p_x_Line_Scredit_rec.sales_credit_type_id := p_old_Line_Scredit_rec.sales_credit_type_id;
989:
990: IF p_x_Line_Scredit_rec.salesrep_id = FND_API.G_MISS_NUM THEN
991: p_x_Line_Scredit_rec.salesrep_id := p_old_Line_Scredit_rec.salesrep_id;
992: END IF;
993: IF p_x_Line_Scredit_rec.sales_credit_type_id = FND_API.G_MISS_NUM THEN
994: p_x_Line_Scredit_rec.sales_credit_type_id := p_old_Line_Scredit_rec.sales_credit_type_id;
995: END IF;
996:
997: IF p_x_Line_Scredit_rec.sales_credit_id = FND_API.G_MISS_NUM THEN
993: IF p_x_Line_Scredit_rec.sales_credit_type_id = FND_API.G_MISS_NUM THEN
994: p_x_Line_Scredit_rec.sales_credit_type_id := p_old_Line_Scredit_rec.sales_credit_type_id;
995: END IF;
996:
997: IF p_x_Line_Scredit_rec.sales_credit_id = FND_API.G_MISS_NUM THEN
998: p_x_Line_Scredit_rec.sales_credit_id := p_old_Line_Scredit_rec.sales_credit_id;
999: END IF;
1000:
1001: IF p_x_Line_Scredit_rec.wh_update_date = FND_API.G_MISS_DATE THEN
997: IF p_x_Line_Scredit_rec.sales_credit_id = FND_API.G_MISS_NUM THEN
998: p_x_Line_Scredit_rec.sales_credit_id := p_old_Line_Scredit_rec.sales_credit_id;
999: END IF;
1000:
1001: IF p_x_Line_Scredit_rec.wh_update_date = FND_API.G_MISS_DATE THEN
1002: p_x_Line_Scredit_rec.wh_update_date := p_old_Line_Scredit_rec.wh_update_date;
1003: END IF;
1004:
1005: IF l_debug_level > 0 THEN
1022: IF l_debug_level > 0 THEN
1023: oe_debug_pub.add( 'ENTERING OE_LINE_SCREDIT_UTIL.CONVERT_MISS_TO_NULL' , 1 ) ;
1024: END IF;
1025:
1026: IF p_x_Line_Scredit_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1027: p_x_Line_Scredit_rec.attribute1 := NULL;
1028: END IF;
1029:
1030: IF p_x_Line_Scredit_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1026: IF p_x_Line_Scredit_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1027: p_x_Line_Scredit_rec.attribute1 := NULL;
1028: END IF;
1029:
1030: IF p_x_Line_Scredit_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1031: p_x_Line_Scredit_rec.attribute10 := NULL;
1032: END IF;
1033:
1034: IF p_x_Line_Scredit_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1030: IF p_x_Line_Scredit_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1031: p_x_Line_Scredit_rec.attribute10 := NULL;
1032: END IF;
1033:
1034: IF p_x_Line_Scredit_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1035: p_x_Line_Scredit_rec.attribute11 := NULL;
1036: END IF;
1037:
1038: IF p_x_Line_Scredit_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1034: IF p_x_Line_Scredit_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1035: p_x_Line_Scredit_rec.attribute11 := NULL;
1036: END IF;
1037:
1038: IF p_x_Line_Scredit_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1039: p_x_Line_Scredit_rec.attribute12 := NULL;
1040: END IF;
1041:
1042: IF p_x_Line_Scredit_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1038: IF p_x_Line_Scredit_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1039: p_x_Line_Scredit_rec.attribute12 := NULL;
1040: END IF;
1041:
1042: IF p_x_Line_Scredit_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1043: p_x_Line_Scredit_rec.attribute13 := NULL;
1044: END IF;
1045:
1046: IF p_x_Line_Scredit_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1042: IF p_x_Line_Scredit_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1043: p_x_Line_Scredit_rec.attribute13 := NULL;
1044: END IF;
1045:
1046: IF p_x_Line_Scredit_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1047: p_x_Line_Scredit_rec.attribute14 := NULL;
1048: END IF;
1049:
1050: IF p_x_Line_Scredit_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1046: IF p_x_Line_Scredit_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1047: p_x_Line_Scredit_rec.attribute14 := NULL;
1048: END IF;
1049:
1050: IF p_x_Line_Scredit_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1051: p_x_Line_Scredit_rec.attribute15 := NULL;
1052: END IF;
1053:
1054: IF p_x_Line_Scredit_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1050: IF p_x_Line_Scredit_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1051: p_x_Line_Scredit_rec.attribute15 := NULL;
1052: END IF;
1053:
1054: IF p_x_Line_Scredit_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1055: p_x_Line_Scredit_rec.attribute2 := NULL;
1056: END IF;
1057:
1058: IF p_x_Line_Scredit_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1054: IF p_x_Line_Scredit_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1055: p_x_Line_Scredit_rec.attribute2 := NULL;
1056: END IF;
1057:
1058: IF p_x_Line_Scredit_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1059: p_x_Line_Scredit_rec.attribute3 := NULL;
1060: END IF;
1061:
1062: IF p_x_Line_Scredit_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1058: IF p_x_Line_Scredit_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1059: p_x_Line_Scredit_rec.attribute3 := NULL;
1060: END IF;
1061:
1062: IF p_x_Line_Scredit_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1063: p_x_Line_Scredit_rec.attribute4 := NULL;
1064: END IF;
1065:
1066: IF p_x_Line_Scredit_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1062: IF p_x_Line_Scredit_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1063: p_x_Line_Scredit_rec.attribute4 := NULL;
1064: END IF;
1065:
1066: IF p_x_Line_Scredit_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1067: p_x_Line_Scredit_rec.attribute5 := NULL;
1068: END IF;
1069:
1070: IF p_x_Line_Scredit_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1066: IF p_x_Line_Scredit_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1067: p_x_Line_Scredit_rec.attribute5 := NULL;
1068: END IF;
1069:
1070: IF p_x_Line_Scredit_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1071: p_x_Line_Scredit_rec.attribute6 := NULL;
1072: END IF;
1073:
1074: IF p_x_Line_Scredit_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1070: IF p_x_Line_Scredit_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1071: p_x_Line_Scredit_rec.attribute6 := NULL;
1072: END IF;
1073:
1074: IF p_x_Line_Scredit_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1075: p_x_Line_Scredit_rec.attribute7 := NULL;
1076: END IF;
1077:
1078: IF p_x_Line_Scredit_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1074: IF p_x_Line_Scredit_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1075: p_x_Line_Scredit_rec.attribute7 := NULL;
1076: END IF;
1077:
1078: IF p_x_Line_Scredit_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1079: p_x_Line_Scredit_rec.attribute8 := NULL;
1080: END IF;
1081:
1082: IF p_x_Line_Scredit_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1078: IF p_x_Line_Scredit_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1079: p_x_Line_Scredit_rec.attribute8 := NULL;
1080: END IF;
1081:
1082: IF p_x_Line_Scredit_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1083: p_x_Line_Scredit_rec.attribute9 := NULL;
1084: END IF;
1085:
1086: IF p_x_Line_Scredit_rec.context = FND_API.G_MISS_CHAR THEN
1082: IF p_x_Line_Scredit_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1083: p_x_Line_Scredit_rec.attribute9 := NULL;
1084: END IF;
1085:
1086: IF p_x_Line_Scredit_rec.context = FND_API.G_MISS_CHAR THEN
1087: p_x_Line_Scredit_rec.context := NULL;
1088: END IF;
1089:
1090: IF p_x_Line_Scredit_rec.created_by = FND_API.G_MISS_NUM THEN
1086: IF p_x_Line_Scredit_rec.context = FND_API.G_MISS_CHAR THEN
1087: p_x_Line_Scredit_rec.context := NULL;
1088: END IF;
1089:
1090: IF p_x_Line_Scredit_rec.created_by = FND_API.G_MISS_NUM THEN
1091: p_x_Line_Scredit_rec.created_by := NULL;
1092: END IF;
1093:
1094: IF p_x_Line_Scredit_rec.creation_date = FND_API.G_MISS_DATE THEN
1090: IF p_x_Line_Scredit_rec.created_by = FND_API.G_MISS_NUM THEN
1091: p_x_Line_Scredit_rec.created_by := NULL;
1092: END IF;
1093:
1094: IF p_x_Line_Scredit_rec.creation_date = FND_API.G_MISS_DATE THEN
1095: p_x_Line_Scredit_rec.creation_date := NULL;
1096: END IF;
1097:
1098: IF p_x_Line_Scredit_rec.dw_update_advice_flag = FND_API.G_MISS_CHAR THEN
1094: IF p_x_Line_Scredit_rec.creation_date = FND_API.G_MISS_DATE THEN
1095: p_x_Line_Scredit_rec.creation_date := NULL;
1096: END IF;
1097:
1098: IF p_x_Line_Scredit_rec.dw_update_advice_flag = FND_API.G_MISS_CHAR THEN
1099: p_x_Line_Scredit_rec.dw_update_advice_flag := NULL;
1100: END IF;
1101:
1102: IF p_x_Line_Scredit_rec.header_id = FND_API.G_MISS_NUM THEN
1098: IF p_x_Line_Scredit_rec.dw_update_advice_flag = FND_API.G_MISS_CHAR THEN
1099: p_x_Line_Scredit_rec.dw_update_advice_flag := NULL;
1100: END IF;
1101:
1102: IF p_x_Line_Scredit_rec.header_id = FND_API.G_MISS_NUM THEN
1103: p_x_Line_Scredit_rec.header_id := NULL;
1104: END IF;
1105:
1106: IF p_x_Line_Scredit_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1102: IF p_x_Line_Scredit_rec.header_id = FND_API.G_MISS_NUM THEN
1103: p_x_Line_Scredit_rec.header_id := NULL;
1104: END IF;
1105:
1106: IF p_x_Line_Scredit_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1107: p_x_Line_Scredit_rec.last_updated_by := NULL;
1108: END IF;
1109:
1110: IF p_x_Line_Scredit_rec.last_update_date = FND_API.G_MISS_DATE THEN
1106: IF p_x_Line_Scredit_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1107: p_x_Line_Scredit_rec.last_updated_by := NULL;
1108: END IF;
1109:
1110: IF p_x_Line_Scredit_rec.last_update_date = FND_API.G_MISS_DATE THEN
1111: p_x_Line_Scredit_rec.last_update_date := NULL;
1112: END IF;
1113:
1114: IF p_x_Line_Scredit_rec.last_update_login = FND_API.G_MISS_NUM THEN
1110: IF p_x_Line_Scredit_rec.last_update_date = FND_API.G_MISS_DATE THEN
1111: p_x_Line_Scredit_rec.last_update_date := NULL;
1112: END IF;
1113:
1114: IF p_x_Line_Scredit_rec.last_update_login = FND_API.G_MISS_NUM THEN
1115: p_x_Line_Scredit_rec.last_update_login := NULL;
1116: END IF;
1117:
1118: IF p_x_Line_Scredit_rec.line_id = FND_API.G_MISS_NUM THEN
1114: IF p_x_Line_Scredit_rec.last_update_login = FND_API.G_MISS_NUM THEN
1115: p_x_Line_Scredit_rec.last_update_login := NULL;
1116: END IF;
1117:
1118: IF p_x_Line_Scredit_rec.line_id = FND_API.G_MISS_NUM THEN
1119: p_x_Line_Scredit_rec.line_id := NULL;
1120: END IF;
1121:
1122: IF p_x_Line_Scredit_rec.percent = FND_API.G_MISS_NUM THEN
1118: IF p_x_Line_Scredit_rec.line_id = FND_API.G_MISS_NUM THEN
1119: p_x_Line_Scredit_rec.line_id := NULL;
1120: END IF;
1121:
1122: IF p_x_Line_Scredit_rec.percent = FND_API.G_MISS_NUM THEN
1123: p_x_Line_Scredit_rec.percent := NULL;
1124: END IF;
1125:
1126:
1123: p_x_Line_Scredit_rec.percent := NULL;
1124: END IF;
1125:
1126:
1127: IF p_x_Line_Scredit_rec.salesrep_id = FND_API.G_MISS_NUM THEN
1128: p_x_Line_Scredit_rec.salesrep_id := NULL;
1129: END IF;
1130: IF p_x_Line_Scredit_rec.sales_credit_type_id = FND_API.G_MISS_NUM THEN
1131: p_x_Line_Scredit_rec.sales_credit_type_id := NULL;
1126:
1127: IF p_x_Line_Scredit_rec.salesrep_id = FND_API.G_MISS_NUM THEN
1128: p_x_Line_Scredit_rec.salesrep_id := NULL;
1129: END IF;
1130: IF p_x_Line_Scredit_rec.sales_credit_type_id = FND_API.G_MISS_NUM THEN
1131: p_x_Line_Scredit_rec.sales_credit_type_id := NULL;
1132: END IF;
1133:
1134: IF p_x_Line_Scredit_rec.sales_credit_id = FND_API.G_MISS_NUM THEN
1130: IF p_x_Line_Scredit_rec.sales_credit_type_id = FND_API.G_MISS_NUM THEN
1131: p_x_Line_Scredit_rec.sales_credit_type_id := NULL;
1132: END IF;
1133:
1134: IF p_x_Line_Scredit_rec.sales_credit_id = FND_API.G_MISS_NUM THEN
1135: p_x_Line_Scredit_rec.sales_credit_id := NULL;
1136: END IF;
1137:
1138: IF p_x_Line_Scredit_rec.wh_update_date = FND_API.G_MISS_DATE THEN
1134: IF p_x_Line_Scredit_rec.sales_credit_id = FND_API.G_MISS_NUM THEN
1135: p_x_Line_Scredit_rec.sales_credit_id := NULL;
1136: END IF;
1137:
1138: IF p_x_Line_Scredit_rec.wh_update_date = FND_API.G_MISS_DATE THEN
1139: p_x_Line_Scredit_rec.wh_update_date := NULL;
1140: END IF;
1141:
1142: IF l_debug_level > 0 THEN
1250: IF l_debug_level > 0 THEN
1251: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_LINE_SCREDIT_UTIL.UPDATE_ROW IS: ' || L_RETURN_STATUS ) ;
1252: END IF;
1253:
1254: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1255: IF l_debug_level > 0 THEN
1256: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
1257: END IF;
1258: IF l_debug_level > 0 THEN
1257: END IF;
1258: IF l_debug_level > 0 THEN
1259: oe_debug_pub.add( 'EXITING OE_LINE_SCREDIT_UTIL.UPDATE_ROW' , 1 ) ;
1260: END IF;
1261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1262: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1263: IF l_debug_level > 0 THEN
1264: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_SCREDIT_UTIL.UPDATE_ROW' ) ;
1265: END IF;
1258: IF l_debug_level > 0 THEN
1259: oe_debug_pub.add( 'EXITING OE_LINE_SCREDIT_UTIL.UPDATE_ROW' , 1 ) ;
1260: END IF;
1261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1262: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1263: IF l_debug_level > 0 THEN
1264: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_SCREDIT_UTIL.UPDATE_ROW' ) ;
1265: END IF;
1266: IF l_debug_level > 0 THEN
1265: END IF;
1266: IF l_debug_level > 0 THEN
1267: oe_debug_pub.add( 'EXITING OE_LINE_SCREDIT_UTIL.UPDATE_ROW' , 1 ) ;
1268: END IF;
1269: RAISE FND_API.G_EXC_ERROR;
1270: END IF;
1271: -- notification framework end
1272: END IF; /* code set is pack H or higher */
1273: /* jolin end*/
1287: , 'Update_Row'
1288: );
1289: END IF;
1290:
1291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1292:
1293: END Update_Row;
1294:
1295: -- Procedure Insert_Row
1409: IF l_debug_level > 0 THEN
1410: oe_debug_pub.add( 'RETURNED INDEX IS: ' || L_INDEX , 1 ) ;
1411: END IF;
1412:
1413: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1414: IF l_debug_level > 0 THEN
1415: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
1416: END IF;
1417: IF l_debug_level > 0 THEN
1416: END IF;
1417: IF l_debug_level > 0 THEN
1418: oe_debug_pub.add( 'EXITING OE_LINE_SCREDIT_UTIL.INSERT_ROW' , 1 ) ;
1419: END IF;
1420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1421: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1422: IF l_debug_level > 0 THEN
1423: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_SCREDIT_UTIL.INSERT_ROW' ) ;
1424: END IF;
1417: IF l_debug_level > 0 THEN
1418: oe_debug_pub.add( 'EXITING OE_LINE_SCREDIT_UTIL.INSERT_ROW' , 1 ) ;
1419: END IF;
1420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1421: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1422: IF l_debug_level > 0 THEN
1423: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_SCREDIT_UTIL.INSERT_ROW' ) ;
1424: END IF;
1425: IF l_debug_level > 0 THEN
1424: END IF;
1425: IF l_debug_level > 0 THEN
1426: oe_debug_pub.add( 'EXITING OE_LINE_SCREDIT_UTIL.INSERT_ROW' , 1 ) ;
1427: END IF;
1428: RAISE FND_API.G_EXC_ERROR;
1429: END IF;
1430: -- notification framework end
1431: END IF; /* code set is pack H or higher */
1432: /* jolin end*/
1446: , 'Insert_Row'
1447: );
1448: END IF;
1449:
1450: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1451:
1452: END Insert_Row;
1453:
1454: -- Procedure Delete_Row
1454: -- Procedure Delete_Row
1455:
1456: PROCEDURE Delete_Row
1457: ( p_sales_credit_id IN NUMBER :=
1458: FND_API.G_MISS_NUM
1459: , p_line_id IN NUMBER :=
1460: FND_API.G_MISS_NUM
1461: )
1462: IS
1456: PROCEDURE Delete_Row
1457: ( p_sales_credit_id IN NUMBER :=
1458: FND_API.G_MISS_NUM
1459: , p_line_id IN NUMBER :=
1460: FND_API.G_MISS_NUM
1461: )
1462: IS
1463: l_return_status VARCHAR2(30);
1464: /* jolin start*/
1480: IF l_debug_level > 0 THEN
1481: oe_debug_pub.add( 'ENTERING OE_LINE_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;
1482: END IF;
1483:
1484: IF p_line_id <> FND_API.G_MISS_NUM
1485: THEN
1486: FOR l_scr IN sales_credit LOOP
1487:
1488: /* jolin start*/
1511: IF l_debug_level > 0 THEN
1512: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_LINE_SCREDIT_UTIL.DELETE_ROW IS: ' || L_RETURN_STATUS ) ;
1513: END IF;
1514:
1515: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1516: IF l_debug_level > 0 THEN
1517: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
1518: END IF;
1519: IF l_debug_level > 0 THEN
1518: END IF;
1519: IF l_debug_level > 0 THEN
1520: oe_debug_pub.add( 'EXITING OE_LINE_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;
1521: END IF;
1522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1523: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1524: IF l_debug_level > 0 THEN
1525: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_SCREDIT_UTIL.DELETE_ROW' ) ;
1526: END IF;
1519: IF l_debug_level > 0 THEN
1520: oe_debug_pub.add( 'EXITING OE_LINE_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;
1521: END IF;
1522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1523: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1524: IF l_debug_level > 0 THEN
1525: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_SCREDIT_UTIL.DELETE_ROW' ) ;
1526: END IF;
1527: IF l_debug_level > 0 THEN
1526: END IF;
1527: IF l_debug_level > 0 THEN
1528: oe_debug_pub.add( 'EXITING OE_LINE_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;
1529: END IF;
1530: RAISE FND_API.G_EXC_ERROR;
1531: END IF;
1532:
1533: -- notification framework end
1534: END IF; /* code set is pack H or higher */
1588: IF l_debug_level > 0 THEN
1589: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_LINE_SCREDIT_UTIL.DELETE_ROW IS: ' || L_RETURN_STATUS ) ;
1590: END IF;
1591:
1592: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1593: IF l_debug_level > 0 THEN
1594: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
1595: END IF;
1596: IF l_debug_level > 0 THEN
1595: END IF;
1596: IF l_debug_level > 0 THEN
1597: oe_debug_pub.add( 'EXITING OE_LINE_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;
1598: END IF;
1599: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1600: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1601: IF l_debug_level > 0 THEN
1602: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_SCREDIT_UTIL.DELETE_ROW' ) ;
1603: END IF;
1596: IF l_debug_level > 0 THEN
1597: oe_debug_pub.add( 'EXITING OE_LINE_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;
1598: END IF;
1599: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1600: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1601: IF l_debug_level > 0 THEN
1602: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_SCREDIT_UTIL.DELETE_ROW' ) ;
1603: END IF;
1604: IF l_debug_level > 0 THEN
1603: END IF;
1604: IF l_debug_level > 0 THEN
1605: oe_debug_pub.add( 'EXITING OE_LINE_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;
1606: END IF;
1607: RAISE FND_API.G_EXC_ERROR;
1608: END IF;
1609:
1610: -- notification framework end
1611: END IF; /* code set is pack H or higher */
1652: , 'Delete_Row'
1653: );
1654: END IF;
1655:
1656: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1657:
1658: END Delete_Row;
1659:
1660: -- PROCEDURE Query_Row
1687: --
1688:
1689: PROCEDURE Query_Rows
1690: ( p_sales_credit_id IN NUMBER :=
1691: FND_API.G_MISS_NUM
1692: , p_line_id IN NUMBER :=
1693: FND_API.G_MISS_NUM
1694: , p_header_id IN NUMBER :=
1695: FND_API.G_MISS_NUM
1689: PROCEDURE Query_Rows
1690: ( p_sales_credit_id IN NUMBER :=
1691: FND_API.G_MISS_NUM
1692: , p_line_id IN NUMBER :=
1693: FND_API.G_MISS_NUM
1694: , p_header_id IN NUMBER :=
1695: FND_API.G_MISS_NUM
1696: , x_Line_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Tbl_Type
1697: )
1691: FND_API.G_MISS_NUM
1692: , p_line_id IN NUMBER :=
1693: FND_API.G_MISS_NUM
1694: , p_header_id IN NUMBER :=
1695: FND_API.G_MISS_NUM
1696: , x_Line_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Tbl_Type
1697: )
1698: IS
1699:
1822:
1823: IF
1824: (p_sales_credit_id IS NOT NULL
1825: AND
1826: p_sales_credit_id <> FND_API.G_MISS_NUM)
1827: AND
1828: (p_line_id IS NOT NULL
1829: AND
1830: p_line_id <> FND_API.G_MISS_NUM)
1826: p_sales_credit_id <> FND_API.G_MISS_NUM)
1827: AND
1828: (p_line_id IS NOT NULL
1829: AND
1830: p_line_id <> FND_API.G_MISS_NUM)
1831: THEN
1832: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1833: THEN
1834: oe_msg_pub.Add_Exc_Msg
1837: , 'Keys are mutually exclusive: sales_credit_id = '|| p_sales_credit_id || ', line_id = '|| p_line_id
1838: );
1839: END IF;
1840:
1841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1842:
1843: END IF;
1844:
1845: IF nvl(p_sales_credit_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1842:
1843: END IF;
1844:
1845: IF nvl(p_sales_credit_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1846: l_entity := 1;
1847: OPEN l_line_scredit_csr_s;
1848: ELSIF nvl(p_line_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1849: l_entity := 2;
1844:
1845: IF nvl(p_sales_credit_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1846: l_entity := 1;
1847: OPEN l_line_scredit_csr_s;
1848: ELSIF nvl(p_line_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1849: l_entity := 2;
1850: OPEN l_line_scredit_csr_l;
1851: ELSIF nvl(p_header_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1852: l_entity := 3;
1847: OPEN l_line_scredit_csr_s;
1848: ELSIF nvl(p_line_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1849: l_entity := 2;
1850: OPEN l_line_scredit_csr_l;
1851: ELSIF nvl(p_header_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1852: l_entity := 3;
1853: OPEN l_line_scredit_csr_h;
1854: END IF;
1855:
1921:
1922: IF
1923: (p_sales_credit_id IS NOT NULL
1924: AND
1925: p_sales_credit_id <> FND_API.G_MISS_NUM)
1926: AND
1927: (x_Line_Scredit_tbl.COUNT = 0)
1928: THEN
1929: RAISE NO_DATA_FOUND;
1938:
1939:
1940: EXCEPTION
1941:
1942: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1943:
1944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1945:
1946: WHEN OTHERS THEN
1940: EXCEPTION
1941:
1942: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1943:
1944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1945:
1946: WHEN OTHERS THEN
1947:
1948: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1952: , 'Query_Rows'
1953: );
1954: END IF;
1955:
1956: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1957:
1958: END Query_Rows;
1959:
1960: -- Procedure lock_Row
1964: ( x_return_status OUT NOCOPY VARCHAR2
1965:
1966: , p_x_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type
1967: , p_sales_credit_id IN NUMBER
1968: := FND_API.G_MISS_NUM
1969: )
1970: IS
1971: l_sales_credit_id NUMBER;
1972: l_lock_control NUMBER;
1983:
1984: l_lock_control := NULL;
1985:
1986: -- Retrieve the primary key.
1987: IF p_sales_credit_id <> FND_API.G_MISS_NUM THEN
1988: l_sales_credit_id := p_sales_credit_id;
1989: ELSE
1990: l_sales_credit_id := p_x_line_scredit_rec.sales_credit_id;
1991: l_lock_control := p_x_line_scredit_rec.lock_control;
2007:
2008:
2009: -- If lock_control is passed, then return the locked record.
2010: IF l_lock_control is NULL OR
2011: l_lock_control <> FND_API.G_MISS_NUM THEN
2012:
2013: -- Set return status
2014: x_return_status := FND_API.G_RET_STS_SUCCESS;
2015: p_x_line_scredit_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2010: IF l_lock_control is NULL OR
2011: l_lock_control <> FND_API.G_MISS_NUM THEN
2012:
2013: -- Set return status
2014: x_return_status := FND_API.G_RET_STS_SUCCESS;
2015: p_x_line_scredit_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2016:
2017: RETURN;
2018:
2011: l_lock_control <> FND_API.G_MISS_NUM THEN
2012:
2013: -- Set return status
2014: x_return_status := FND_API.G_RET_STS_SUCCESS;
2015: p_x_line_scredit_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2016:
2017: RETURN;
2018:
2019: END IF;
2026: THEN
2027:
2028: -- Set return status
2029:
2030: x_return_status := FND_API.G_RET_STS_SUCCESS;
2031: p_x_Line_Scredit_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2032:
2033: ELSE
2034:
2027:
2028: -- Set return status
2029:
2030: x_return_status := FND_API.G_RET_STS_SUCCESS;
2031: p_x_Line_Scredit_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2032:
2033: ELSE
2034:
2035: -- Row has changed by another user.
2033: ELSE
2034:
2035: -- Row has changed by another user.
2036:
2037: x_return_status := FND_API.G_RET_STS_ERROR;
2038: p_x_Line_Scredit_rec.return_status := FND_API.G_RET_STS_ERROR;
2039:
2040: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2041: THEN
2034:
2035: -- Row has changed by another user.
2036:
2037: x_return_status := FND_API.G_RET_STS_ERROR;
2038: p_x_Line_Scredit_rec.return_status := FND_API.G_RET_STS_ERROR;
2039:
2040: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2041: THEN
2042:
2057: EXCEPTION
2058:
2059: WHEN NO_DATA_FOUND THEN
2060:
2061: x_return_status := FND_API.G_RET_STS_ERROR;
2062: p_x_Line_Scredit_rec.return_status := FND_API.G_RET_STS_ERROR;
2063:
2064: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2065: THEN
2058:
2059: WHEN NO_DATA_FOUND THEN
2060:
2061: x_return_status := FND_API.G_RET_STS_ERROR;
2062: p_x_Line_Scredit_rec.return_status := FND_API.G_RET_STS_ERROR;
2063:
2064: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2065: THEN
2066:
2069:
2070: END IF;
2071: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
2072:
2073: x_return_status := FND_API.G_RET_STS_ERROR;
2074: p_x_Line_Scredit_rec.return_status := FND_API.G_RET_STS_ERROR;
2075:
2076: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2077: THEN
2070: END IF;
2071: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
2072:
2073: x_return_status := FND_API.G_RET_STS_ERROR;
2074: p_x_Line_Scredit_rec.return_status := FND_API.G_RET_STS_ERROR;
2075:
2076: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2077: THEN
2078:
2081:
2082: END IF;
2083: WHEN OTHERS THEN
2084:
2085: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2086: p_x_Line_Scredit_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2087:
2088: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2089: THEN
2082: END IF;
2083: WHEN OTHERS THEN
2084:
2085: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2086: p_x_Line_Scredit_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2087:
2088: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2089: THEN
2090: oe_msg_pub.Add_Exc_Msg
2096: END Lock_Row;
2097:
2098: PROCEDURE Lock_Rows
2099: ( p_sales_credit_id IN NUMBER :=
2100: FND_API.G_MISS_NUM
2101: , p_line_id IN NUMBER :=
2102: FND_API.G_MISS_NUM
2103: , x_line_scredit_tbl OUT NOCOPY OE_Order_PUB.Line_scredit_Tbl_Type
2104: , x_return_status OUT NOCOPY VARCHAR2
2098: PROCEDURE Lock_Rows
2099: ( p_sales_credit_id IN NUMBER :=
2100: FND_API.G_MISS_NUM
2101: , p_line_id IN NUMBER :=
2102: FND_API.G_MISS_NUM
2103: , x_line_scredit_tbl OUT NOCOPY OE_Order_PUB.Line_scredit_Tbl_Type
2104: , x_return_status OUT NOCOPY VARCHAR2
2105:
2106: )
2121: oe_debug_pub.add( 'ENTERING OE_LINE_SCREDITS_UTIL.LOCK_ROWS' , 1 ) ;
2122: END IF;
2123:
2124: IF (p_sales_credit_id IS NOT NULL AND
2125: p_sales_credit_id <> FND_API.G_MISS_NUM) AND
2126: (p_line_id IS NOT NULL AND
2127: p_line_id <> FND_API.G_MISS_NUM)
2128: THEN
2129: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2123:
2124: IF (p_sales_credit_id IS NOT NULL AND
2125: p_sales_credit_id <> FND_API.G_MISS_NUM) AND
2126: (p_line_id IS NOT NULL AND
2127: p_line_id <> FND_API.G_MISS_NUM)
2128: THEN
2129: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2130: THEN
2131: OE_MSG_PUB.Add_Exc_Msg
2134: , 'Keys are mutually exclusive: sales_credit_id = '||
2135: p_sales_credit_id || ', line_id = '|| p_line_id );
2136: END IF;
2137:
2138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2139:
2140: END IF;
2141:
2142: IF p_sales_credit_id <> FND_API.G_MISS_NUM THEN
2138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2139:
2140: END IF;
2141:
2142: IF p_sales_credit_id <> FND_API.G_MISS_NUM THEN
2143:
2144: SELECT sales_credit_id
2145: INTO l_sales_credit_id
2146: FROM OE_SALES_CREDITS
2153: -- if they already passed in sales_credit_id.
2154:
2155: BEGIN
2156:
2157: IF p_line_id <> FND_API.G_MISS_NUM THEN
2158:
2159: SAVEPOINT LOCK_ROWS;
2160: OPEN lock_line_scredits(p_line_id);
2161:
2186: ,p_line_id => p_line_id
2187: ,x_line_scredit_tbl => x_line_scredit_tbl
2188: );
2189:
2190: x_return_status := FND_API.G_RET_STS_SUCCESS;
2191:
2192: IF l_debug_level > 0 THEN
2193: oe_debug_pub.add( 'EXITING OE_LINE_SCREDITS_UTIL.LOCK_ROWS' , 1 ) ;
2194: END IF;
2195:
2196: EXCEPTION
2197: WHEN NO_DATA_FOUND THEN
2198:
2199: x_return_status := FND_API.G_RET_STS_ERROR;
2200:
2201: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2202: THEN
2203: fnd_message.set_name('ONT','OE_LOCK_ROW_DELETED');
2205: END IF;
2206:
2207: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
2208:
2209: x_return_status := FND_API.G_RET_STS_ERROR;
2210: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2211: THEN
2212: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
2213: OE_MSG_PUB.Add;
2214: END IF;
2215:
2216: WHEN OTHERS THEN
2217:
2218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2219:
2220: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2221: THEN
2222: OE_MSG_PUB.Add_Exc_Msg
2241: --
2242: BEGIN
2243:
2244: IF (p_Line_Scredit_rec.salesrep_id IS NULL OR
2245: p_Line_Scredit_rec.salesrep_id <> FND_API.G_MISS_NUM) AND
2246: NOT OE_GLOBALS.Equal(p_Line_Scredit_rec.salesrep_id,
2247: p_old_Line_Scredit_rec.salesrep_id)
2248: THEN
2249: l_Line_Scredit_val_rec.salesrep := OE_Id_To_Value.Salesrep
2250: ( p_salesrep_id => p_Line_Scredit_rec.salesrep_id
2251: );
2252: END IF;
2253: IF (p_Line_Scredit_rec.sales_credit_type_id IS NULL OR
2254: p_Line_Scredit_rec.sales_credit_type_id <> FND_API.G_MISS_NUM) AND
2255: NOT OE_GLOBALS.Equal(p_Line_Scredit_rec.sales_credit_type_id,
2256: p_old_Line_Scredit_rec.sales_credit_type_id)
2257: THEN
2258: l_Line_Scredit_val_rec.sales_credit_type := OE_Id_To_Value.sales_credit_type
2291: BEGIN
2292:
2293: -- initialize return_status.
2294:
2295: p_x_Line_Scredit_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2296:
2297: IF p_Line_Scredit_val_rec.salesrep <> FND_API.G_MISS_CHAR
2298: THEN
2299:
2293: -- initialize return_status.
2294:
2295: p_x_Line_Scredit_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2296:
2297: IF p_Line_Scredit_val_rec.salesrep <> FND_API.G_MISS_CHAR
2298: THEN
2299:
2300: IF p_x_Line_Scredit_rec.salesrep_id <> FND_API.G_MISS_NUM THEN
2301:
2296:
2297: IF p_Line_Scredit_val_rec.salesrep <> FND_API.G_MISS_CHAR
2298: THEN
2299:
2300: IF p_x_Line_Scredit_rec.salesrep_id <> FND_API.G_MISS_NUM THEN
2301:
2302: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2303: THEN
2304:
2313: p_x_Line_Scredit_rec.salesrep_id := OE_Value_To_Id.salesrep
2314: ( p_salesrep => p_Line_Scredit_val_rec.salesrep
2315: );
2316:
2317: IF p_x_Line_Scredit_rec.salesrep_id = FND_API.G_MISS_NUM THEN
2318: p_x_Line_Scredit_rec.return_status := FND_API.G_RET_STS_ERROR;
2319: END IF;
2320:
2321: END IF;
2314: ( p_salesrep => p_Line_Scredit_val_rec.salesrep
2315: );
2316:
2317: IF p_x_Line_Scredit_rec.salesrep_id = FND_API.G_MISS_NUM THEN
2318: p_x_Line_Scredit_rec.return_status := FND_API.G_RET_STS_ERROR;
2319: END IF;
2320:
2321: END IF;
2322:
2321: END IF;
2322:
2323: END IF;
2324:
2325: IF p_Line_Scredit_val_rec.sales_credit_type <> FND_API.G_MISS_CHAR
2326: THEN
2327:
2328: IF p_x_Line_Scredit_rec.sales_credit_type_id <> FND_API.G_MISS_NUM THEN
2329:
2324:
2325: IF p_Line_Scredit_val_rec.sales_credit_type <> FND_API.G_MISS_CHAR
2326: THEN
2327:
2328: IF p_x_Line_Scredit_rec.sales_credit_type_id <> FND_API.G_MISS_NUM THEN
2329:
2330: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2331: THEN
2332:
2341: p_x_Line_Scredit_rec.sales_credit_type_id := OE_Value_To_Id.sales_credit_type
2342: ( p_sales_credit_type => p_Line_Scredit_val_rec.sales_credit_type
2343: );
2344:
2345: IF p_x_Line_Scredit_rec.sales_credit_type_id = FND_API.G_MISS_NUM THEN
2346: p_x_Line_Scredit_rec.return_status := FND_API.G_RET_STS_ERROR;
2347: END IF;
2348:
2349: END IF;
2342: ( p_sales_credit_type => p_Line_Scredit_val_rec.sales_credit_type
2343: );
2344:
2345: IF p_x_Line_Scredit_rec.sales_credit_type_id = FND_API.G_MISS_NUM THEN
2346: p_x_Line_Scredit_rec.return_status := FND_API.G_RET_STS_ERROR;
2347: END IF;
2348:
2349: END IF;
2350: END IF;
2404: G_SALESREP_ID IS NULL Then
2405: --added for bug 4200055
2406: if ((Oe_Order_Cache.g_header_rec.header_id = p_line_rec.header_id)
2407: AND (Oe_Order_Cache.g_header_rec.header_id <> NULL)
2408: AND (Oe_Order_Cache.g_header_rec.header_id <> FND_API.G_MISS_NUM)) Then
2409: G_SALESREP_ID := Oe_Order_Cache.g_header_rec.salesrep_id ;
2410: else
2411: Oe_Order_Cache.Load_Order_Header(p_line_rec.header_id) ;
2412: G_SALESREP_ID := Oe_Order_Cache.g_header_rec.salesrep_id ;
2427:
2428:
2429: IF (p_line_rec.operation = oe_globals.g_opr_create AND
2430: p_line_rec.salesrep_id IS NOT NULL AND
2431: p_line_rec.salesrep_id <> FND_API.G_MISS_NUM) THEN
2432:
2433: l_create_flag := TRUE;
2434:
2435: IF l_debug_level > 0 THEN
2442: oe_debug_pub.add( 'IN OPERATION UPDATE ' ) ;
2443: END IF;
2444:
2445: IF (p_old_line_rec.salesrep_id IS NULL OR
2446: p_old_line_rec.salesrep_id = FND_API.G_MISS_NUM)
2447: THEN
2448: IF l_debug_level > 0 THEN
2449: oe_debug_pub.add( 'IN CREATE FOR UPDATE OPERATION' ) ;
2450: END IF;
2476: if l_sales_credits_count > 1 then
2477:
2478: fnd_message.set_name('ONT','OE_TOO_MANY_LSCREDIT');
2479: OE_MSG_PUB.Add;
2480: RAISE FND_API.G_EXC_ERROR;
2481:
2482: elsif l_sales_credits_count = 1 then -- update with new salesrep
2483:
2484: OE_Line_Scredit_Util.Lock_Rows
2486: x_line_scredit_tbl => l_old_line_scredit_tbl,
2487: x_return_status => l_return_status
2488: );
2489:
2490: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2492: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2493: RAISE FND_API.G_EXC_ERROR;
2494: END IF;
2487: x_return_status => l_return_status
2488: );
2489:
2490: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2492: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2493: RAISE FND_API.G_EXC_ERROR;
2494: END IF;
2495:
2488: );
2489:
2490: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2492: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2493: RAISE FND_API.G_EXC_ERROR;
2494: END IF;
2495:
2496: /* Added the following 3 lines to fix the bug 1822931 */
2489:
2490: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2492: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2493: RAISE FND_API.G_EXC_ERROR;
2494: END IF;
2495:
2496: /* Added the following 3 lines to fix the bug 1822931 */
2497: open C_SCRTYPE;
2579: l_control_rec.default_attributes := TRUE;
2580: l_control_rec.write_to_db := TRUE;
2581:
2582: OE_Order_PVT.Line_Scredits
2583: ( p_init_msg_list => FND_API.G_FALSE
2584: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
2585: , p_control_rec => l_control_rec
2586: , p_x_Line_Scredit_tbl => l_line_scredit_tbl
2587: , p_x_old_Line_Scredit_tbl => l_old_line_scredit_tbl
2580: l_control_rec.write_to_db := TRUE;
2581:
2582: OE_Order_PVT.Line_Scredits
2583: ( p_init_msg_list => FND_API.G_FALSE
2584: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
2585: , p_control_rec => l_control_rec
2586: , p_x_Line_Scredit_tbl => l_line_scredit_tbl
2587: , p_x_old_Line_Scredit_tbl => l_old_line_scredit_tbl
2588: , x_return_status => l_return_status
2587: , p_x_old_Line_Scredit_tbl => l_old_line_scredit_tbl
2588: , x_return_status => l_return_status
2589: );
2590:
2591: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2592: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2593: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2594: RAISE FND_API.G_EXC_ERROR;
2595: END IF;
2588: , x_return_status => l_return_status
2589: );
2590:
2591: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2592: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2593: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2594: RAISE FND_API.G_EXC_ERROR;
2595: END IF;
2596:
2589: );
2590:
2591: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2592: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2593: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2594: RAISE FND_API.G_EXC_ERROR;
2595: END IF;
2596:
2597: --jolin start
2590:
2591: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2592: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2593: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2594: RAISE FND_API.G_EXC_ERROR;
2595: END IF;
2596:
2597: --jolin start
2598: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
2611: IF l_debug_level > 0 THEN
2612: oe_debug_pub.add( 'UPDATE_GLOBAL INDEX FOR LINE_ID '||L_LINE_SCREDIT_TBL ( 1 ) .LINE_ID ||' IS: ' || L_NOTIFY_INDEX , 1 ) ;
2613: END IF;
2614:
2615: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2616: RAISE FND_API.G_EXC_ERROR;
2617: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2618: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2619: END IF;
2612: oe_debug_pub.add( 'UPDATE_GLOBAL INDEX FOR LINE_ID '||L_LINE_SCREDIT_TBL ( 1 ) .LINE_ID ||' IS: ' || L_NOTIFY_INDEX , 1 ) ;
2613: END IF;
2614:
2615: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2616: RAISE FND_API.G_EXC_ERROR;
2617: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2618: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2619: END IF;
2620:
2613: END IF;
2614:
2615: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2616: RAISE FND_API.G_EXC_ERROR;
2617: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2618: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2619: END IF;
2620:
2621: ELSE
2614:
2615: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2616: RAISE FND_API.G_EXC_ERROR;
2617: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2618: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2619: END IF;
2620:
2621: ELSE
2622:
2627: , p_line_scredit_tbl => l_line_scredit_tbl
2628: , p_old_line_scredit_tbl => l_old_line_scredit_tbl
2629: );
2630:
2631: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2632: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2633: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2634: RAISE FND_API.G_EXC_ERROR;
2635: END IF;
2628: , p_old_line_scredit_tbl => l_old_line_scredit_tbl
2629: );
2630:
2631: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2632: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2633: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2634: RAISE FND_API.G_EXC_ERROR;
2635: END IF;
2636:
2629: );
2630:
2631: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2632: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2633: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2634: RAISE FND_API.G_EXC_ERROR;
2635: END IF;
2636:
2637: END IF; /* code set is pack H or higher */
2630:
2631: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2632: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2633: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2634: RAISE FND_API.G_EXC_ERROR;
2635: END IF;
2636:
2637: END IF; /* code set is pack H or higher */
2638: -- jolin end
2658: ( G_PKG_NAME ,
2659: 'Create_Credits'
2660: );
2661: END IF;
2662: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2663:
2664: End Create_credit;
2665:
2666: /* Start AuditTrail */
2680: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' AND
2681: OE_GLOBALS.G_ROLL_VERSION <> 'N' THEN
2682: IF OE_GLOBALS.G_REASON_CODE IS NULL AND
2683: OE_GLOBALS.G_CAPTURED_REASON IN ('V','A') THEN
2684: IF p_x_line_scredit_rec.change_reason <> FND_API.G_MISS_CHAR THEN
2685: OE_GLOBALS.G_REASON_CODE := p_x_line_scredit_rec.change_reason;
2686: OE_GLOBALS.G_REASON_COMMENTS := p_x_line_scredit_rec.change_comments;
2687: OE_GLOBALS.G_CAPTURED_REASON := 'Y';
2688: ELSE
2689: IF l_debug_level > 0 THEN
2690: OE_DEBUG_PUB.add('Reason code for versioning missing', 1);
2691: END IF;
2692: IF OE_GLOBALS.G_UI_FLAG THEN
2693: raise FND_API.G_EXC_ERROR;
2694: END IF;
2695: END IF;
2696: END IF;
2697:
2713: IF l_debug_level > 0 THEN
2714: oe_debug_pub.add( 'OEXULSCB: AUDIT TRAIL - CHANGE REQUIRES REASON' , 2 ) ;
2715: END IF;
2716: IF (p_x_line_scredit_rec.change_reason IS NULL OR
2717: p_x_line_scredit_rec.change_reason = FND_API.G_MISS_CHAR OR
2718: NOT OE_VALIDATE.Change_Reason_Code(p_x_line_Scredit_rec.Change_Reason)) THEN
2719: IF OE_GLOBALS.G_DEFAULT_REASON THEN
2720: if l_debug_level > 0 then
2721: oe_debug_pub.add('Defaulting Audit Reason for Line Sales Credit', 1);
2727: END IF;
2728: fnd_message.set_name('ONT','OE_AUDIT_REASON_RQD');
2729: fnd_message.set_token('OBJECT','LINE SALES CREDIT');
2730: oe_msg_pub.add;
2731: raise FND_API.G_EXC_ERROR;
2732: END IF;
2733: END IF;
2734: END IF;
2735: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG = 'Y' OR
2763: x_return_status => l_return_status
2764: );
2765: END IF;
2766: END IF;
2767: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2768: IF l_debug_level > 0 THEN
2769: oe_debug_pub.add( 'INSERTING LINE SALES CREDIT HISTORY CAUSED ERROR ' , 1 ) ;
2770: END IF;
2771: if l_return_status = FND_API.G_RET_STS_ERROR then
2767: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2768: IF l_debug_level > 0 THEN
2769: oe_debug_pub.add( 'INSERTING LINE SALES CREDIT HISTORY CAUSED ERROR ' , 1 ) ;
2770: END IF;
2771: if l_return_status = FND_API.G_RET_STS_ERROR then
2772: raise FND_API.G_EXC_ERROR;
2773: else
2774: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2775: end if;
2768: IF l_debug_level > 0 THEN
2769: oe_debug_pub.add( 'INSERTING LINE SALES CREDIT HISTORY CAUSED ERROR ' , 1 ) ;
2770: END IF;
2771: if l_return_status = FND_API.G_RET_STS_ERROR then
2772: raise FND_API.G_EXC_ERROR;
2773: else
2774: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2775: end if;
2776: END IF;
2770: END IF;
2771: if l_return_status = FND_API.G_RET_STS_ERROR then
2772: raise FND_API.G_EXC_ERROR;
2773: else
2774: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2775: end if;
2776: END IF;
2777: END IF;
2778: