[Home] [Help]
13: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
14: --
15: BEGIN
16:
17: l_rowtype_rec.ATTRIBUTE1 := FND_API.G_MISS_CHAR;
18: l_rowtype_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
19: l_rowtype_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
20: l_rowtype_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
21: l_rowtype_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
14: --
15: BEGIN
16:
17: l_rowtype_rec.ATTRIBUTE1 := FND_API.G_MISS_CHAR;
18: l_rowtype_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
19: l_rowtype_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
20: l_rowtype_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
21: l_rowtype_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
22: l_rowtype_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
15: BEGIN
16:
17: l_rowtype_rec.ATTRIBUTE1 := FND_API.G_MISS_CHAR;
18: l_rowtype_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
19: l_rowtype_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
20: l_rowtype_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
21: l_rowtype_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
22: l_rowtype_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
23: l_rowtype_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
16:
17: l_rowtype_rec.ATTRIBUTE1 := FND_API.G_MISS_CHAR;
18: l_rowtype_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
19: l_rowtype_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
20: l_rowtype_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
21: l_rowtype_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
22: l_rowtype_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
23: l_rowtype_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
24: l_rowtype_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
17: l_rowtype_rec.ATTRIBUTE1 := FND_API.G_MISS_CHAR;
18: l_rowtype_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
19: l_rowtype_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
20: l_rowtype_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
21: l_rowtype_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
22: l_rowtype_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
23: l_rowtype_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
24: l_rowtype_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
25: l_rowtype_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
18: l_rowtype_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
19: l_rowtype_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
20: l_rowtype_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
21: l_rowtype_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
22: l_rowtype_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
23: l_rowtype_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
24: l_rowtype_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
25: l_rowtype_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
26: l_rowtype_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
19: l_rowtype_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
20: l_rowtype_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
21: l_rowtype_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
22: l_rowtype_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
23: l_rowtype_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
24: l_rowtype_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
25: l_rowtype_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
26: l_rowtype_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
27: l_rowtype_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
20: l_rowtype_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
21: l_rowtype_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
22: l_rowtype_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
23: l_rowtype_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
24: l_rowtype_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
25: l_rowtype_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
26: l_rowtype_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
27: l_rowtype_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
28: l_rowtype_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
21: l_rowtype_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
22: l_rowtype_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
23: l_rowtype_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
24: l_rowtype_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
25: l_rowtype_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
26: l_rowtype_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
27: l_rowtype_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
28: l_rowtype_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
29: l_rowtype_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
22: l_rowtype_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
23: l_rowtype_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
24: l_rowtype_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
25: l_rowtype_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
26: l_rowtype_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
27: l_rowtype_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
28: l_rowtype_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
29: l_rowtype_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
30: l_rowtype_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
23: l_rowtype_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
24: l_rowtype_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
25: l_rowtype_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
26: l_rowtype_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
27: l_rowtype_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
28: l_rowtype_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
29: l_rowtype_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
30: l_rowtype_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
31: l_rowtype_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
24: l_rowtype_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
25: l_rowtype_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
26: l_rowtype_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
27: l_rowtype_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
28: l_rowtype_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
29: l_rowtype_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
30: l_rowtype_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
31: l_rowtype_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
32: l_rowtype_rec.CONTEXT := FND_API.G_MISS_CHAR;
25: l_rowtype_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
26: l_rowtype_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
27: l_rowtype_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
28: l_rowtype_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
29: l_rowtype_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
30: l_rowtype_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
31: l_rowtype_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
32: l_rowtype_rec.CONTEXT := FND_API.G_MISS_CHAR;
33: l_rowtype_rec.CREATED_BY := FND_API.G_MISS_NUM;
26: l_rowtype_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
27: l_rowtype_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
28: l_rowtype_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
29: l_rowtype_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
30: l_rowtype_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
31: l_rowtype_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
32: l_rowtype_rec.CONTEXT := FND_API.G_MISS_CHAR;
33: l_rowtype_rec.CREATED_BY := FND_API.G_MISS_NUM;
34: l_rowtype_rec.CREATION_DATE := FND_API.G_MISS_DATE;
27: l_rowtype_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
28: l_rowtype_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
29: l_rowtype_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
30: l_rowtype_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
31: l_rowtype_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
32: l_rowtype_rec.CONTEXT := FND_API.G_MISS_CHAR;
33: l_rowtype_rec.CREATED_BY := FND_API.G_MISS_NUM;
34: l_rowtype_rec.CREATION_DATE := FND_API.G_MISS_DATE;
35: l_rowtype_rec.DB_FLAG := FND_API.G_MISS_CHAR;
28: l_rowtype_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
29: l_rowtype_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
30: l_rowtype_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
31: l_rowtype_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
32: l_rowtype_rec.CONTEXT := FND_API.G_MISS_CHAR;
33: l_rowtype_rec.CREATED_BY := FND_API.G_MISS_NUM;
34: l_rowtype_rec.CREATION_DATE := FND_API.G_MISS_DATE;
35: l_rowtype_rec.DB_FLAG := FND_API.G_MISS_CHAR;
36: l_rowtype_rec.DW_UPDATE_ADVICE_FLAG := FND_API.G_MISS_CHAR;
29: l_rowtype_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
30: l_rowtype_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
31: l_rowtype_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
32: l_rowtype_rec.CONTEXT := FND_API.G_MISS_CHAR;
33: l_rowtype_rec.CREATED_BY := FND_API.G_MISS_NUM;
34: l_rowtype_rec.CREATION_DATE := FND_API.G_MISS_DATE;
35: l_rowtype_rec.DB_FLAG := FND_API.G_MISS_CHAR;
36: l_rowtype_rec.DW_UPDATE_ADVICE_FLAG := FND_API.G_MISS_CHAR;
37: l_rowtype_rec.HEADER_ID := FND_API.G_MISS_NUM;
30: l_rowtype_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
31: l_rowtype_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
32: l_rowtype_rec.CONTEXT := FND_API.G_MISS_CHAR;
33: l_rowtype_rec.CREATED_BY := FND_API.G_MISS_NUM;
34: l_rowtype_rec.CREATION_DATE := FND_API.G_MISS_DATE;
35: l_rowtype_rec.DB_FLAG := FND_API.G_MISS_CHAR;
36: l_rowtype_rec.DW_UPDATE_ADVICE_FLAG := FND_API.G_MISS_CHAR;
37: l_rowtype_rec.HEADER_ID := FND_API.G_MISS_NUM;
38: l_rowtype_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
31: l_rowtype_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
32: l_rowtype_rec.CONTEXT := FND_API.G_MISS_CHAR;
33: l_rowtype_rec.CREATED_BY := FND_API.G_MISS_NUM;
34: l_rowtype_rec.CREATION_DATE := FND_API.G_MISS_DATE;
35: l_rowtype_rec.DB_FLAG := FND_API.G_MISS_CHAR;
36: l_rowtype_rec.DW_UPDATE_ADVICE_FLAG := FND_API.G_MISS_CHAR;
37: l_rowtype_rec.HEADER_ID := FND_API.G_MISS_NUM;
38: l_rowtype_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
39: l_rowtype_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
32: l_rowtype_rec.CONTEXT := FND_API.G_MISS_CHAR;
33: l_rowtype_rec.CREATED_BY := FND_API.G_MISS_NUM;
34: l_rowtype_rec.CREATION_DATE := FND_API.G_MISS_DATE;
35: l_rowtype_rec.DB_FLAG := FND_API.G_MISS_CHAR;
36: l_rowtype_rec.DW_UPDATE_ADVICE_FLAG := FND_API.G_MISS_CHAR;
37: l_rowtype_rec.HEADER_ID := FND_API.G_MISS_NUM;
38: l_rowtype_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
39: l_rowtype_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
40: l_rowtype_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
33: l_rowtype_rec.CREATED_BY := FND_API.G_MISS_NUM;
34: l_rowtype_rec.CREATION_DATE := FND_API.G_MISS_DATE;
35: l_rowtype_rec.DB_FLAG := FND_API.G_MISS_CHAR;
36: l_rowtype_rec.DW_UPDATE_ADVICE_FLAG := FND_API.G_MISS_CHAR;
37: l_rowtype_rec.HEADER_ID := FND_API.G_MISS_NUM;
38: l_rowtype_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
39: l_rowtype_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
40: l_rowtype_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
41: l_rowtype_rec.LINE_ID := FND_API.G_MISS_NUM;
34: l_rowtype_rec.CREATION_DATE := FND_API.G_MISS_DATE;
35: l_rowtype_rec.DB_FLAG := FND_API.G_MISS_CHAR;
36: l_rowtype_rec.DW_UPDATE_ADVICE_FLAG := FND_API.G_MISS_CHAR;
37: l_rowtype_rec.HEADER_ID := FND_API.G_MISS_NUM;
38: l_rowtype_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
39: l_rowtype_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
40: l_rowtype_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
41: l_rowtype_rec.LINE_ID := FND_API.G_MISS_NUM;
42: l_rowtype_rec.OPERATION := FND_API.G_MISS_CHAR;
35: l_rowtype_rec.DB_FLAG := FND_API.G_MISS_CHAR;
36: l_rowtype_rec.DW_UPDATE_ADVICE_FLAG := FND_API.G_MISS_CHAR;
37: l_rowtype_rec.HEADER_ID := FND_API.G_MISS_NUM;
38: l_rowtype_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
39: l_rowtype_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
40: l_rowtype_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
41: l_rowtype_rec.LINE_ID := FND_API.G_MISS_NUM;
42: l_rowtype_rec.OPERATION := FND_API.G_MISS_CHAR;
43: l_rowtype_rec.PERCENT := FND_API.G_MISS_NUM;
36: l_rowtype_rec.DW_UPDATE_ADVICE_FLAG := FND_API.G_MISS_CHAR;
37: l_rowtype_rec.HEADER_ID := FND_API.G_MISS_NUM;
38: l_rowtype_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
39: l_rowtype_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
40: l_rowtype_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
41: l_rowtype_rec.LINE_ID := FND_API.G_MISS_NUM;
42: l_rowtype_rec.OPERATION := FND_API.G_MISS_CHAR;
43: l_rowtype_rec.PERCENT := FND_API.G_MISS_NUM;
44: l_rowtype_rec.RETURN_STATUS := FND_API.G_MISS_CHAR;
37: l_rowtype_rec.HEADER_ID := FND_API.G_MISS_NUM;
38: l_rowtype_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
39: l_rowtype_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
40: l_rowtype_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
41: l_rowtype_rec.LINE_ID := FND_API.G_MISS_NUM;
42: l_rowtype_rec.OPERATION := FND_API.G_MISS_CHAR;
43: l_rowtype_rec.PERCENT := FND_API.G_MISS_NUM;
44: l_rowtype_rec.RETURN_STATUS := FND_API.G_MISS_CHAR;
45: l_rowtype_rec.SALESREP_ID := FND_API.G_MISS_NUM;
38: l_rowtype_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
39: l_rowtype_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
40: l_rowtype_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
41: l_rowtype_rec.LINE_ID := FND_API.G_MISS_NUM;
42: l_rowtype_rec.OPERATION := FND_API.G_MISS_CHAR;
43: l_rowtype_rec.PERCENT := FND_API.G_MISS_NUM;
44: l_rowtype_rec.RETURN_STATUS := FND_API.G_MISS_CHAR;
45: l_rowtype_rec.SALESREP_ID := FND_API.G_MISS_NUM;
46: l_rowtype_rec.sales_credit_type_id := FND_API.G_MISS_NUM;
39: l_rowtype_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
40: l_rowtype_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
41: l_rowtype_rec.LINE_ID := FND_API.G_MISS_NUM;
42: l_rowtype_rec.OPERATION := FND_API.G_MISS_CHAR;
43: l_rowtype_rec.PERCENT := FND_API.G_MISS_NUM;
44: l_rowtype_rec.RETURN_STATUS := FND_API.G_MISS_CHAR;
45: l_rowtype_rec.SALESREP_ID := FND_API.G_MISS_NUM;
46: l_rowtype_rec.sales_credit_type_id := FND_API.G_MISS_NUM;
47: l_rowtype_rec.SALES_CREDIT_ID := FND_API.G_MISS_NUM;
40: l_rowtype_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
41: l_rowtype_rec.LINE_ID := FND_API.G_MISS_NUM;
42: l_rowtype_rec.OPERATION := FND_API.G_MISS_CHAR;
43: l_rowtype_rec.PERCENT := FND_API.G_MISS_NUM;
44: l_rowtype_rec.RETURN_STATUS := FND_API.G_MISS_CHAR;
45: l_rowtype_rec.SALESREP_ID := FND_API.G_MISS_NUM;
46: l_rowtype_rec.sales_credit_type_id := FND_API.G_MISS_NUM;
47: l_rowtype_rec.SALES_CREDIT_ID := FND_API.G_MISS_NUM;
48: l_rowtype_rec.WH_UPDATE_DATE := FND_API.G_MISS_DATE;
41: l_rowtype_rec.LINE_ID := FND_API.G_MISS_NUM;
42: l_rowtype_rec.OPERATION := FND_API.G_MISS_CHAR;
43: l_rowtype_rec.PERCENT := FND_API.G_MISS_NUM;
44: l_rowtype_rec.RETURN_STATUS := FND_API.G_MISS_CHAR;
45: l_rowtype_rec.SALESREP_ID := FND_API.G_MISS_NUM;
46: l_rowtype_rec.sales_credit_type_id := FND_API.G_MISS_NUM;
47: l_rowtype_rec.SALES_CREDIT_ID := FND_API.G_MISS_NUM;
48: l_rowtype_rec.WH_UPDATE_DATE := FND_API.G_MISS_DATE;
49:
42: l_rowtype_rec.OPERATION := FND_API.G_MISS_CHAR;
43: l_rowtype_rec.PERCENT := FND_API.G_MISS_NUM;
44: l_rowtype_rec.RETURN_STATUS := FND_API.G_MISS_CHAR;
45: l_rowtype_rec.SALESREP_ID := FND_API.G_MISS_NUM;
46: l_rowtype_rec.sales_credit_type_id := FND_API.G_MISS_NUM;
47: l_rowtype_rec.SALES_CREDIT_ID := FND_API.G_MISS_NUM;
48: l_rowtype_rec.WH_UPDATE_DATE := FND_API.G_MISS_DATE;
49:
50: RETURN l_rowtype_rec;
43: l_rowtype_rec.PERCENT := FND_API.G_MISS_NUM;
44: l_rowtype_rec.RETURN_STATUS := FND_API.G_MISS_CHAR;
45: l_rowtype_rec.SALESREP_ID := FND_API.G_MISS_NUM;
46: l_rowtype_rec.sales_credit_type_id := FND_API.G_MISS_NUM;
47: l_rowtype_rec.SALES_CREDIT_ID := FND_API.G_MISS_NUM;
48: l_rowtype_rec.WH_UPDATE_DATE := FND_API.G_MISS_DATE;
49:
50: RETURN l_rowtype_rec;
51:
44: l_rowtype_rec.RETURN_STATUS := FND_API.G_MISS_CHAR;
45: l_rowtype_rec.SALESREP_ID := FND_API.G_MISS_NUM;
46: l_rowtype_rec.sales_credit_type_id := FND_API.G_MISS_NUM;
47: l_rowtype_rec.SALES_CREDIT_ID := FND_API.G_MISS_NUM;
48: l_rowtype_rec.WH_UPDATE_DATE := FND_API.G_MISS_DATE;
49:
50: RETURN l_rowtype_rec;
51:
52: END G_MISS_OE_AK_HSCREDIT_REC;
142:
143: -- Procedure Clear_Dependent_Attr
144:
145: PROCEDURE Clear_Dependent_Attr
146: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
147: , p_x_Header_Scredit_rec IN OUT NOCOPY OE_AK_HEADER_SCREDITS_V%ROWTYPE
148: , p_old_Header_Scredit_rec IN OE_AK_HEADER_SCREDITS_V%ROWTYPE :=
149: G_MISS_OE_AK_HSCREDIT_REC
150: )
163:
164: -- If attr_id is missing compare old and new records and for
165: -- every changed attribute clear its dependent fields.
166:
167: IF p_attr_id = FND_API.G_MISS_NUM THEN
168:
169: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.attribute1,p_old_Header_Scredit_rec.attribute1)
170: THEN
171: 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_HEADER_SCREDIT_UTIL.G_ATTRIBUTE1 THEN
441: p_x_Header_Scredit_rec.ATTRIBUTE1 := FND_API.G_MISS_NUM;
442: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE10 THEN
443: p_x_Header_Scredit_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
444: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE11 THEN
445: p_x_Header_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_HEADER_SCREDIT_UTIL.G_ATTRIBUTE1 THEN
441: p_x_Header_Scredit_rec.ATTRIBUTE1 := FND_API.G_MISS_NUM;
442: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE10 THEN
443: p_x_Header_Scredit_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
444: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE11 THEN
445: p_x_Header_Scredit_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
446: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE12 THEN
447: p_x_Header_Scredit_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
441: p_x_Header_Scredit_rec.ATTRIBUTE1 := FND_API.G_MISS_NUM;
442: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE10 THEN
443: p_x_Header_Scredit_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
444: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE11 THEN
445: p_x_Header_Scredit_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
446: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE12 THEN
447: p_x_Header_Scredit_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
448: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE13 THEN
449: p_x_Header_Scredit_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
443: p_x_Header_Scredit_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
444: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE11 THEN
445: p_x_Header_Scredit_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
446: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE12 THEN
447: p_x_Header_Scredit_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
448: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE13 THEN
449: p_x_Header_Scredit_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
450: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE14 THEN
451: p_x_Header_Scredit_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
445: p_x_Header_Scredit_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
446: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE12 THEN
447: p_x_Header_Scredit_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
448: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE13 THEN
449: p_x_Header_Scredit_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
450: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE14 THEN
451: p_x_Header_Scredit_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
452: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE15 THEN
453: p_x_Header_Scredit_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
447: p_x_Header_Scredit_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
448: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE13 THEN
449: p_x_Header_Scredit_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
450: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE14 THEN
451: p_x_Header_Scredit_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
452: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE15 THEN
453: p_x_Header_Scredit_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
454: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE2 THEN
455: p_x_Header_Scredit_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
449: p_x_Header_Scredit_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
450: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE14 THEN
451: p_x_Header_Scredit_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
452: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE15 THEN
453: p_x_Header_Scredit_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
454: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE2 THEN
455: p_x_Header_Scredit_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
456: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE3 THEN
457: p_x_Header_Scredit_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
451: p_x_Header_Scredit_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
452: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE15 THEN
453: p_x_Header_Scredit_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
454: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE2 THEN
455: p_x_Header_Scredit_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
456: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE3 THEN
457: p_x_Header_Scredit_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
458: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE4 THEN
459: p_x_Header_Scredit_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
453: p_x_Header_Scredit_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
454: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE2 THEN
455: p_x_Header_Scredit_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
456: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE3 THEN
457: p_x_Header_Scredit_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
458: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE4 THEN
459: p_x_Header_Scredit_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
460: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE5 THEN
461: p_x_Header_Scredit_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
455: p_x_Header_Scredit_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
456: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE3 THEN
457: p_x_Header_Scredit_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
458: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE4 THEN
459: p_x_Header_Scredit_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
460: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE5 THEN
461: p_x_Header_Scredit_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
462: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE6 THEN
463: p_x_Header_Scredit_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
457: p_x_Header_Scredit_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
458: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE4 THEN
459: p_x_Header_Scredit_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
460: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE5 THEN
461: p_x_Header_Scredit_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
462: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE6 THEN
463: p_x_Header_Scredit_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
464: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE7 THEN
465: p_x_Header_Scredit_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
459: p_x_Header_Scredit_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
460: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE5 THEN
461: p_x_Header_Scredit_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
462: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE6 THEN
463: p_x_Header_Scredit_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
464: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE7 THEN
465: p_x_Header_Scredit_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
466: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE8 THEN
467: p_x_Header_Scredit_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
461: p_x_Header_Scredit_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
462: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE6 THEN
463: p_x_Header_Scredit_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
464: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE7 THEN
465: p_x_Header_Scredit_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
466: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE8 THEN
467: p_x_Header_Scredit_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
468: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE9 THEN
469: p_x_Header_Scredit_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
463: p_x_Header_Scredit_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
464: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE7 THEN
465: p_x_Header_Scredit_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
466: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE8 THEN
467: p_x_Header_Scredit_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
468: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE9 THEN
469: p_x_Header_Scredit_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
470: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_CONTEXT THEN
471: p_x_Header_Scredit_rec.CONTEXT := FND_API.G_MISS_CHAR;
465: p_x_Header_Scredit_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
466: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE8 THEN
467: p_x_Header_Scredit_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
468: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE9 THEN
469: p_x_Header_Scredit_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
470: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_CONTEXT THEN
471: p_x_Header_Scredit_rec.CONTEXT := FND_API.G_MISS_CHAR;
472: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_CREATED_BY THEN
473: p_x_Header_Scredit_rec.CREATED_BY := FND_API.G_MISS_NUM;
467: p_x_Header_Scredit_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
468: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_ATTRIBUTE9 THEN
469: p_x_Header_Scredit_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
470: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_CONTEXT THEN
471: p_x_Header_Scredit_rec.CONTEXT := FND_API.G_MISS_CHAR;
472: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_CREATED_BY THEN
473: p_x_Header_Scredit_rec.CREATED_BY := FND_API.G_MISS_NUM;
474: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_CREATION_DATE THEN
475: p_x_Header_Scredit_rec.CREATION_DATE := FND_API.G_MISS_DATE;
469: p_x_Header_Scredit_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
470: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_CONTEXT THEN
471: p_x_Header_Scredit_rec.CONTEXT := FND_API.G_MISS_CHAR;
472: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_CREATED_BY THEN
473: p_x_Header_Scredit_rec.CREATED_BY := FND_API.G_MISS_NUM;
474: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_CREATION_DATE THEN
475: p_x_Header_Scredit_rec.CREATION_DATE := FND_API.G_MISS_DATE;
476: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_DW_UPDATE_ADVICE THEN
477: p_x_Header_Scredit_rec.DW_UPDATE_ADVICE_FLAG := FND_API.G_MISS_CHAR;
471: p_x_Header_Scredit_rec.CONTEXT := FND_API.G_MISS_CHAR;
472: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_CREATED_BY THEN
473: p_x_Header_Scredit_rec.CREATED_BY := FND_API.G_MISS_NUM;
474: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_CREATION_DATE THEN
475: p_x_Header_Scredit_rec.CREATION_DATE := FND_API.G_MISS_DATE;
476: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_DW_UPDATE_ADVICE THEN
477: p_x_Header_Scredit_rec.DW_UPDATE_ADVICE_FLAG := FND_API.G_MISS_CHAR;
478: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_HEADER THEN
479: p_x_Header_Scredit_rec.HEADER_ID := FND_API.G_MISS_NUM;
473: p_x_Header_Scredit_rec.CREATED_BY := FND_API.G_MISS_NUM;
474: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_CREATION_DATE THEN
475: p_x_Header_Scredit_rec.CREATION_DATE := FND_API.G_MISS_DATE;
476: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_DW_UPDATE_ADVICE THEN
477: p_x_Header_Scredit_rec.DW_UPDATE_ADVICE_FLAG := FND_API.G_MISS_CHAR;
478: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_HEADER THEN
479: p_x_Header_Scredit_rec.HEADER_ID := FND_API.G_MISS_NUM;
480: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_LAST_UPDATED_BY THEN
481: p_x_Header_Scredit_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
475: p_x_Header_Scredit_rec.CREATION_DATE := FND_API.G_MISS_DATE;
476: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_DW_UPDATE_ADVICE THEN
477: p_x_Header_Scredit_rec.DW_UPDATE_ADVICE_FLAG := FND_API.G_MISS_CHAR;
478: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_HEADER THEN
479: p_x_Header_Scredit_rec.HEADER_ID := FND_API.G_MISS_NUM;
480: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_LAST_UPDATED_BY THEN
481: p_x_Header_Scredit_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
482: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_LAST_UPDATE_DATE THEN
483: p_x_Header_Scredit_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
477: p_x_Header_Scredit_rec.DW_UPDATE_ADVICE_FLAG := FND_API.G_MISS_CHAR;
478: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_HEADER THEN
479: p_x_Header_Scredit_rec.HEADER_ID := FND_API.G_MISS_NUM;
480: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_LAST_UPDATED_BY THEN
481: p_x_Header_Scredit_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
482: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_LAST_UPDATE_DATE THEN
483: p_x_Header_Scredit_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
484: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_LAST_UPDATE_LOGIN THEN
485: p_x_Header_Scredit_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
479: p_x_Header_Scredit_rec.HEADER_ID := FND_API.G_MISS_NUM;
480: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_LAST_UPDATED_BY THEN
481: p_x_Header_Scredit_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
482: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_LAST_UPDATE_DATE THEN
483: p_x_Header_Scredit_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
484: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_LAST_UPDATE_LOGIN THEN
485: p_x_Header_Scredit_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
486: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_LINE THEN
487: p_x_Header_Scredit_rec.LINE_ID := FND_API.G_MISS_NUM;
481: p_x_Header_Scredit_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
482: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_LAST_UPDATE_DATE THEN
483: p_x_Header_Scredit_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
484: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_LAST_UPDATE_LOGIN THEN
485: p_x_Header_Scredit_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
486: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_LINE THEN
487: p_x_Header_Scredit_rec.LINE_ID := FND_API.G_MISS_NUM;
488: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_PERCENT THEN
489: p_x_Header_Scredit_rec.PERCENT := FND_API.G_MISS_NUM;
483: p_x_Header_Scredit_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
484: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_LAST_UPDATE_LOGIN THEN
485: p_x_Header_Scredit_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
486: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_LINE THEN
487: p_x_Header_Scredit_rec.LINE_ID := FND_API.G_MISS_NUM;
488: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_PERCENT THEN
489: p_x_Header_Scredit_rec.PERCENT := FND_API.G_MISS_NUM;
490: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_SALESREP THEN
491: p_x_Header_Scredit_rec.SALESREP_ID := FND_API.G_MISS_NUM;
485: p_x_Header_Scredit_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
486: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_LINE THEN
487: p_x_Header_Scredit_rec.LINE_ID := FND_API.G_MISS_NUM;
488: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_PERCENT THEN
489: p_x_Header_Scredit_rec.PERCENT := FND_API.G_MISS_NUM;
490: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_SALESREP THEN
491: p_x_Header_Scredit_rec.SALESREP_ID := FND_API.G_MISS_NUM;
492: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_sales_credit_type THEN
493: p_x_Header_Scredit_rec.sales_credit_type_id := FND_API.G_MISS_NUM;
487: p_x_Header_Scredit_rec.LINE_ID := FND_API.G_MISS_NUM;
488: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_PERCENT THEN
489: p_x_Header_Scredit_rec.PERCENT := FND_API.G_MISS_NUM;
490: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_SALESREP THEN
491: p_x_Header_Scredit_rec.SALESREP_ID := FND_API.G_MISS_NUM;
492: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_sales_credit_type THEN
493: p_x_Header_Scredit_rec.sales_credit_type_id := FND_API.G_MISS_NUM;
494: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_SALES_CREDIT THEN
495: p_x_Header_Scredit_rec.SALES_CREDIT_ID := FND_API.G_MISS_NUM;
489: p_x_Header_Scredit_rec.PERCENT := FND_API.G_MISS_NUM;
490: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_SALESREP THEN
491: p_x_Header_Scredit_rec.SALESREP_ID := FND_API.G_MISS_NUM;
492: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_sales_credit_type THEN
493: p_x_Header_Scredit_rec.sales_credit_type_id := FND_API.G_MISS_NUM;
494: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_SALES_CREDIT THEN
495: p_x_Header_Scredit_rec.SALES_CREDIT_ID := FND_API.G_MISS_NUM;
496: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_WH_UPDATE_DATE THEN
497: p_x_Header_Scredit_rec.WH_UPDATE_DATE := FND_API.G_MISS_DATE;
491: p_x_Header_Scredit_rec.SALESREP_ID := FND_API.G_MISS_NUM;
492: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_sales_credit_type THEN
493: p_x_Header_Scredit_rec.sales_credit_type_id := FND_API.G_MISS_NUM;
494: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_SALES_CREDIT THEN
495: p_x_Header_Scredit_rec.SALES_CREDIT_ID := FND_API.G_MISS_NUM;
496: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_WH_UPDATE_DATE THEN
497: p_x_Header_Scredit_rec.WH_UPDATE_DATE := FND_API.G_MISS_DATE;
498: END IF;
499: END LOOP;
493: p_x_Header_Scredit_rec.sales_credit_type_id := FND_API.G_MISS_NUM;
494: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_SALES_CREDIT THEN
495: p_x_Header_Scredit_rec.SALES_CREDIT_ID := FND_API.G_MISS_NUM;
496: ELSIF l_dep_attr_tbl(I) = OE_HEADER_SCREDIT_UTIL.G_WH_UPDATE_DATE THEN
497: p_x_Header_Scredit_rec.WH_UPDATE_DATE := FND_API.G_MISS_DATE;
498: END IF;
499: END LOOP;
500: END IF;
501: END Clear_Dependent_Attr;
500: END IF;
501: END Clear_Dependent_Attr;
502:
503: PROCEDURE Clear_Dependent_Attr
504: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
505: , p_x_Header_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type
506: , p_old_Header_Scredit_rec IN OE_Order_PUB.Header_Scredit_Rec_Type :=
507: OE_Order_PUB.G_MISS_HEADER_SCREDIT_REC
508: )
679: ,p_requesting_entity_id=>p_x_Header_Scredit_rec.sales_credit_id
680: ,p_request_type=>OE_GLOBALS.G_CHECK_HSC_QUOTA_TOTAL
681: ,p_param1 => to_char(p_x_Header_Scredit_rec.header_id)
682: ,x_return_status =>l_return_status);
683: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
685: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
686: RAISE FND_API.G_EXC_ERROR;
687: END IF;
680: ,p_request_type=>OE_GLOBALS.G_CHECK_HSC_QUOTA_TOTAL
681: ,p_param1 => to_char(p_x_Header_Scredit_rec.header_id)
682: ,x_return_status =>l_return_status);
683: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
685: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
686: RAISE FND_API.G_EXC_ERROR;
687: END IF;
688: END IF;
681: ,p_param1 => to_char(p_x_Header_Scredit_rec.header_id)
682: ,x_return_status =>l_return_status);
683: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
685: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
686: RAISE FND_API.G_EXC_ERROR;
687: END IF;
688: END IF;
689:
682: ,x_return_status =>l_return_status);
683: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
685: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
686: RAISE FND_API.G_EXC_ERROR;
687: END IF;
688: END IF;
689:
690: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.sales_credit_type_id,p_old_Header_Scredit_rec.sales_credit_type_id)
697: ,p_requesting_entity_id=>p_x_Header_Scredit_rec.sales_credit_id
698: ,p_request_type=>OE_GLOBALS.G_CHECK_HSC_QUOTA_TOTAL
699: ,p_param1 => to_char(p_x_Header_Scredit_rec.header_id)
700: ,x_return_status =>l_return_status);
701: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
702: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
703: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
704: RAISE FND_API.G_EXC_ERROR;
705: END IF;
698: ,p_request_type=>OE_GLOBALS.G_CHECK_HSC_QUOTA_TOTAL
699: ,p_param1 => to_char(p_x_Header_Scredit_rec.header_id)
700: ,x_return_status =>l_return_status);
701: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
702: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
703: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
704: RAISE FND_API.G_EXC_ERROR;
705: END IF;
706: END IF;
699: ,p_param1 => to_char(p_x_Header_Scredit_rec.header_id)
700: ,x_return_status =>l_return_status);
701: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
702: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
703: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
704: RAISE FND_API.G_EXC_ERROR;
705: END IF;
706: END IF;
707:
700: ,x_return_status =>l_return_status);
701: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
702: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
703: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
704: RAISE FND_API.G_EXC_ERROR;
705: END IF;
706: END IF;
707:
708: IF NOT OE_GLOBALS.Equal(p_x_Header_Scredit_rec.salesrep_id,p_old_Header_Scredit_rec.salesrep_id)
741: END IF;
742:
743: --SG{
744: IF nvl(p_x_Header_Scredit_rec.sales_group_updated_flag,'N') <> 'Y'
745: AND nvl(p_x_Header_Scredit_rec.salesrep_id,FND_API.G_MISS_NUM)<>FND_API.G_MISS_NUM
746: THEN
747:
748: IF OE_ORDER_CACHE.G_HEADER_REC.header_id IS NULL THEN
749: --header not available in cache, load info to cache
797: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
798: --
799: BEGIN
800:
801: IF p_x_Header_Scredit_rec.attribute1 = FND_API.G_MISS_CHAR THEN
802: p_x_Header_Scredit_rec.attribute1 := p_old_Header_Scredit_rec.attribute1;
803: END IF;
804:
805: IF p_x_Header_Scredit_rec.attribute10 = FND_API.G_MISS_CHAR THEN
801: IF p_x_Header_Scredit_rec.attribute1 = FND_API.G_MISS_CHAR THEN
802: p_x_Header_Scredit_rec.attribute1 := p_old_Header_Scredit_rec.attribute1;
803: END IF;
804:
805: IF p_x_Header_Scredit_rec.attribute10 = FND_API.G_MISS_CHAR THEN
806: p_x_Header_Scredit_rec.attribute10 := p_old_Header_Scredit_rec.attribute10;
807: END IF;
808:
809: IF p_x_Header_Scredit_rec.attribute11 = FND_API.G_MISS_CHAR THEN
805: IF p_x_Header_Scredit_rec.attribute10 = FND_API.G_MISS_CHAR THEN
806: p_x_Header_Scredit_rec.attribute10 := p_old_Header_Scredit_rec.attribute10;
807: END IF;
808:
809: IF p_x_Header_Scredit_rec.attribute11 = FND_API.G_MISS_CHAR THEN
810: p_x_Header_Scredit_rec.attribute11 := p_old_Header_Scredit_rec.attribute11;
811: END IF;
812:
813: IF p_x_Header_Scredit_rec.attribute12 = FND_API.G_MISS_CHAR THEN
809: IF p_x_Header_Scredit_rec.attribute11 = FND_API.G_MISS_CHAR THEN
810: p_x_Header_Scredit_rec.attribute11 := p_old_Header_Scredit_rec.attribute11;
811: END IF;
812:
813: IF p_x_Header_Scredit_rec.attribute12 = FND_API.G_MISS_CHAR THEN
814: p_x_Header_Scredit_rec.attribute12 := p_old_Header_Scredit_rec.attribute12;
815: END IF;
816:
817: IF p_x_Header_Scredit_rec.attribute13 = FND_API.G_MISS_CHAR THEN
813: IF p_x_Header_Scredit_rec.attribute12 = FND_API.G_MISS_CHAR THEN
814: p_x_Header_Scredit_rec.attribute12 := p_old_Header_Scredit_rec.attribute12;
815: END IF;
816:
817: IF p_x_Header_Scredit_rec.attribute13 = FND_API.G_MISS_CHAR THEN
818: p_x_Header_Scredit_rec.attribute13 := p_old_Header_Scredit_rec.attribute13;
819: END IF;
820:
821: IF p_x_Header_Scredit_rec.attribute14 = FND_API.G_MISS_CHAR THEN
817: IF p_x_Header_Scredit_rec.attribute13 = FND_API.G_MISS_CHAR THEN
818: p_x_Header_Scredit_rec.attribute13 := p_old_Header_Scredit_rec.attribute13;
819: END IF;
820:
821: IF p_x_Header_Scredit_rec.attribute14 = FND_API.G_MISS_CHAR THEN
822: p_x_Header_Scredit_rec.attribute14 := p_old_Header_Scredit_rec.attribute14;
823: END IF;
824:
825: IF p_x_Header_Scredit_rec.attribute15 = FND_API.G_MISS_CHAR THEN
821: IF p_x_Header_Scredit_rec.attribute14 = FND_API.G_MISS_CHAR THEN
822: p_x_Header_Scredit_rec.attribute14 := p_old_Header_Scredit_rec.attribute14;
823: END IF;
824:
825: IF p_x_Header_Scredit_rec.attribute15 = FND_API.G_MISS_CHAR THEN
826: p_x_Header_Scredit_rec.attribute15 := p_old_Header_Scredit_rec.attribute15;
827: END IF;
828:
829: IF p_x_Header_Scredit_rec.attribute2 = FND_API.G_MISS_CHAR THEN
825: IF p_x_Header_Scredit_rec.attribute15 = FND_API.G_MISS_CHAR THEN
826: p_x_Header_Scredit_rec.attribute15 := p_old_Header_Scredit_rec.attribute15;
827: END IF;
828:
829: IF p_x_Header_Scredit_rec.attribute2 = FND_API.G_MISS_CHAR THEN
830: p_x_Header_Scredit_rec.attribute2 := p_old_Header_Scredit_rec.attribute2;
831: END IF;
832:
833: IF p_x_Header_Scredit_rec.attribute3 = FND_API.G_MISS_CHAR THEN
829: IF p_x_Header_Scredit_rec.attribute2 = FND_API.G_MISS_CHAR THEN
830: p_x_Header_Scredit_rec.attribute2 := p_old_Header_Scredit_rec.attribute2;
831: END IF;
832:
833: IF p_x_Header_Scredit_rec.attribute3 = FND_API.G_MISS_CHAR THEN
834: p_x_Header_Scredit_rec.attribute3 := p_old_Header_Scredit_rec.attribute3;
835: END IF;
836:
837: IF p_x_Header_Scredit_rec.attribute4 = FND_API.G_MISS_CHAR THEN
833: IF p_x_Header_Scredit_rec.attribute3 = FND_API.G_MISS_CHAR THEN
834: p_x_Header_Scredit_rec.attribute3 := p_old_Header_Scredit_rec.attribute3;
835: END IF;
836:
837: IF p_x_Header_Scredit_rec.attribute4 = FND_API.G_MISS_CHAR THEN
838: p_x_Header_Scredit_rec.attribute4 := p_old_Header_Scredit_rec.attribute4;
839: END IF;
840:
841: IF p_x_Header_Scredit_rec.attribute5 = FND_API.G_MISS_CHAR THEN
837: IF p_x_Header_Scredit_rec.attribute4 = FND_API.G_MISS_CHAR THEN
838: p_x_Header_Scredit_rec.attribute4 := p_old_Header_Scredit_rec.attribute4;
839: END IF;
840:
841: IF p_x_Header_Scredit_rec.attribute5 = FND_API.G_MISS_CHAR THEN
842: p_x_Header_Scredit_rec.attribute5 := p_old_Header_Scredit_rec.attribute5;
843: END IF;
844:
845: IF p_x_Header_Scredit_rec.attribute6 = FND_API.G_MISS_CHAR THEN
841: IF p_x_Header_Scredit_rec.attribute5 = FND_API.G_MISS_CHAR THEN
842: p_x_Header_Scredit_rec.attribute5 := p_old_Header_Scredit_rec.attribute5;
843: END IF;
844:
845: IF p_x_Header_Scredit_rec.attribute6 = FND_API.G_MISS_CHAR THEN
846: p_x_Header_Scredit_rec.attribute6 := p_old_Header_Scredit_rec.attribute6;
847: END IF;
848:
849: IF p_x_Header_Scredit_rec.attribute7 = FND_API.G_MISS_CHAR THEN
845: IF p_x_Header_Scredit_rec.attribute6 = FND_API.G_MISS_CHAR THEN
846: p_x_Header_Scredit_rec.attribute6 := p_old_Header_Scredit_rec.attribute6;
847: END IF;
848:
849: IF p_x_Header_Scredit_rec.attribute7 = FND_API.G_MISS_CHAR THEN
850: p_x_Header_Scredit_rec.attribute7 := p_old_Header_Scredit_rec.attribute7;
851: END IF;
852:
853: IF p_x_Header_Scredit_rec.attribute8 = FND_API.G_MISS_CHAR THEN
849: IF p_x_Header_Scredit_rec.attribute7 = FND_API.G_MISS_CHAR THEN
850: p_x_Header_Scredit_rec.attribute7 := p_old_Header_Scredit_rec.attribute7;
851: END IF;
852:
853: IF p_x_Header_Scredit_rec.attribute8 = FND_API.G_MISS_CHAR THEN
854: p_x_Header_Scredit_rec.attribute8 := p_old_Header_Scredit_rec.attribute8;
855: END IF;
856:
857: IF p_x_Header_Scredit_rec.attribute9 = FND_API.G_MISS_CHAR THEN
853: IF p_x_Header_Scredit_rec.attribute8 = FND_API.G_MISS_CHAR THEN
854: p_x_Header_Scredit_rec.attribute8 := p_old_Header_Scredit_rec.attribute8;
855: END IF;
856:
857: IF p_x_Header_Scredit_rec.attribute9 = FND_API.G_MISS_CHAR THEN
858: p_x_Header_Scredit_rec.attribute9 := p_old_Header_Scredit_rec.attribute9;
859: END IF;
860:
861: IF p_x_Header_Scredit_rec.context = FND_API.G_MISS_CHAR THEN
857: IF p_x_Header_Scredit_rec.attribute9 = FND_API.G_MISS_CHAR THEN
858: p_x_Header_Scredit_rec.attribute9 := p_old_Header_Scredit_rec.attribute9;
859: END IF;
860:
861: IF p_x_Header_Scredit_rec.context = FND_API.G_MISS_CHAR THEN
862: p_x_Header_Scredit_rec.context := p_old_Header_Scredit_rec.context;
863: END IF;
864:
865: IF p_x_Header_Scredit_rec.created_by = FND_API.G_MISS_NUM THEN
861: IF p_x_Header_Scredit_rec.context = FND_API.G_MISS_CHAR THEN
862: p_x_Header_Scredit_rec.context := p_old_Header_Scredit_rec.context;
863: END IF;
864:
865: IF p_x_Header_Scredit_rec.created_by = FND_API.G_MISS_NUM THEN
866: p_x_Header_Scredit_rec.created_by := p_old_Header_Scredit_rec.created_by;
867: END IF;
868:
869: IF p_x_Header_Scredit_rec.creation_date = FND_API.G_MISS_DATE THEN
865: IF p_x_Header_Scredit_rec.created_by = FND_API.G_MISS_NUM THEN
866: p_x_Header_Scredit_rec.created_by := p_old_Header_Scredit_rec.created_by;
867: END IF;
868:
869: IF p_x_Header_Scredit_rec.creation_date = FND_API.G_MISS_DATE THEN
870: p_x_Header_Scredit_rec.creation_date := p_old_Header_Scredit_rec.creation_date;
871: END IF;
872:
873: IF p_x_Header_Scredit_rec.dw_update_advice_flag = FND_API.G_MISS_CHAR THEN
869: IF p_x_Header_Scredit_rec.creation_date = FND_API.G_MISS_DATE THEN
870: p_x_Header_Scredit_rec.creation_date := p_old_Header_Scredit_rec.creation_date;
871: END IF;
872:
873: IF p_x_Header_Scredit_rec.dw_update_advice_flag = FND_API.G_MISS_CHAR THEN
874: p_x_Header_Scredit_rec.dw_update_advice_flag := p_old_Header_Scredit_rec.dw_update_advice_flag;
875: END IF;
876:
877: IF p_x_Header_Scredit_rec.header_id = FND_API.G_MISS_NUM THEN
873: IF p_x_Header_Scredit_rec.dw_update_advice_flag = FND_API.G_MISS_CHAR THEN
874: p_x_Header_Scredit_rec.dw_update_advice_flag := p_old_Header_Scredit_rec.dw_update_advice_flag;
875: END IF;
876:
877: IF p_x_Header_Scredit_rec.header_id = FND_API.G_MISS_NUM THEN
878: p_x_Header_Scredit_rec.header_id := p_old_Header_Scredit_rec.header_id;
879: END IF;
880:
881: IF p_x_Header_Scredit_rec.last_updated_by = FND_API.G_MISS_NUM THEN
877: IF p_x_Header_Scredit_rec.header_id = FND_API.G_MISS_NUM THEN
878: p_x_Header_Scredit_rec.header_id := p_old_Header_Scredit_rec.header_id;
879: END IF;
880:
881: IF p_x_Header_Scredit_rec.last_updated_by = FND_API.G_MISS_NUM THEN
882: p_x_Header_Scredit_rec.last_updated_by := p_old_Header_Scredit_rec.last_updated_by;
883: END IF;
884:
885: IF p_x_Header_Scredit_rec.last_update_date = FND_API.G_MISS_DATE THEN
881: IF p_x_Header_Scredit_rec.last_updated_by = FND_API.G_MISS_NUM THEN
882: p_x_Header_Scredit_rec.last_updated_by := p_old_Header_Scredit_rec.last_updated_by;
883: END IF;
884:
885: IF p_x_Header_Scredit_rec.last_update_date = FND_API.G_MISS_DATE THEN
886: p_x_Header_Scredit_rec.last_update_date := p_old_Header_Scredit_rec.last_update_date;
887: END IF;
888:
889: IF p_x_Header_Scredit_rec.last_update_login = FND_API.G_MISS_NUM THEN
885: IF p_x_Header_Scredit_rec.last_update_date = FND_API.G_MISS_DATE THEN
886: p_x_Header_Scredit_rec.last_update_date := p_old_Header_Scredit_rec.last_update_date;
887: END IF;
888:
889: IF p_x_Header_Scredit_rec.last_update_login = FND_API.G_MISS_NUM THEN
890: p_x_Header_Scredit_rec.last_update_login := p_old_Header_Scredit_rec.last_update_login;
891: END IF;
892:
893: IF p_x_Header_Scredit_rec.line_id = FND_API.G_MISS_NUM THEN
889: IF p_x_Header_Scredit_rec.last_update_login = FND_API.G_MISS_NUM THEN
890: p_x_Header_Scredit_rec.last_update_login := p_old_Header_Scredit_rec.last_update_login;
891: END IF;
892:
893: IF p_x_Header_Scredit_rec.line_id = FND_API.G_MISS_NUM THEN
894: p_x_Header_Scredit_rec.line_id := p_old_Header_Scredit_rec.line_id;
895: END IF;
896:
897: IF p_x_Header_Scredit_rec.percent = FND_API.G_MISS_NUM THEN
893: IF p_x_Header_Scredit_rec.line_id = FND_API.G_MISS_NUM THEN
894: p_x_Header_Scredit_rec.line_id := p_old_Header_Scredit_rec.line_id;
895: END IF;
896:
897: IF p_x_Header_Scredit_rec.percent = FND_API.G_MISS_NUM THEN
898: p_x_Header_Scredit_rec.percent := p_old_Header_Scredit_rec.percent;
899: END IF;
900:
901:
898: p_x_Header_Scredit_rec.percent := p_old_Header_Scredit_rec.percent;
899: END IF;
900:
901:
902: IF p_x_Header_Scredit_rec.salesrep_id = FND_API.G_MISS_NUM THEN
903: p_x_Header_Scredit_rec.salesrep_id := p_old_Header_Scredit_rec.salesrep_id;
904: END IF;
905: IF p_x_Header_Scredit_rec.sales_credit_type_id = FND_API.G_MISS_NUM THEN
906: p_x_Header_Scredit_rec.sales_credit_type_id := p_old_Header_Scredit_rec.sales_credit_type_id;
901:
902: IF p_x_Header_Scredit_rec.salesrep_id = FND_API.G_MISS_NUM THEN
903: p_x_Header_Scredit_rec.salesrep_id := p_old_Header_Scredit_rec.salesrep_id;
904: END IF;
905: IF p_x_Header_Scredit_rec.sales_credit_type_id = FND_API.G_MISS_NUM THEN
906: p_x_Header_Scredit_rec.sales_credit_type_id := p_old_Header_Scredit_rec.sales_credit_type_id;
907: END IF;
908:
909: IF p_x_Header_Scredit_rec.sales_credit_id = FND_API.G_MISS_NUM THEN
905: IF p_x_Header_Scredit_rec.sales_credit_type_id = FND_API.G_MISS_NUM THEN
906: p_x_Header_Scredit_rec.sales_credit_type_id := p_old_Header_Scredit_rec.sales_credit_type_id;
907: END IF;
908:
909: IF p_x_Header_Scredit_rec.sales_credit_id = FND_API.G_MISS_NUM THEN
910: p_x_Header_Scredit_rec.sales_credit_id := p_old_Header_Scredit_rec.sales_credit_id;
911: END IF;
912:
913: IF p_x_Header_Scredit_rec.wh_update_date = FND_API.G_MISS_DATE THEN
909: IF p_x_Header_Scredit_rec.sales_credit_id = FND_API.G_MISS_NUM THEN
910: p_x_Header_Scredit_rec.sales_credit_id := p_old_Header_Scredit_rec.sales_credit_id;
911: END IF;
912:
913: IF p_x_Header_Scredit_rec.wh_update_date = FND_API.G_MISS_DATE THEN
914: p_x_Header_Scredit_rec.wh_update_date := p_old_Header_Scredit_rec.wh_update_date;
915: END IF;
916:
917:
929: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
930: --
931: BEGIN
932:
933: IF p_x_Header_Scredit_rec.attribute1 = FND_API.G_MISS_CHAR THEN
934: p_x_Header_Scredit_rec.attribute1 := NULL;
935: END IF;
936:
937: IF p_x_Header_Scredit_rec.attribute10 = FND_API.G_MISS_CHAR THEN
933: IF p_x_Header_Scredit_rec.attribute1 = FND_API.G_MISS_CHAR THEN
934: p_x_Header_Scredit_rec.attribute1 := NULL;
935: END IF;
936:
937: IF p_x_Header_Scredit_rec.attribute10 = FND_API.G_MISS_CHAR THEN
938: p_x_Header_Scredit_rec.attribute10 := NULL;
939: END IF;
940:
941: IF p_x_Header_Scredit_rec.attribute11 = FND_API.G_MISS_CHAR THEN
937: IF p_x_Header_Scredit_rec.attribute10 = FND_API.G_MISS_CHAR THEN
938: p_x_Header_Scredit_rec.attribute10 := NULL;
939: END IF;
940:
941: IF p_x_Header_Scredit_rec.attribute11 = FND_API.G_MISS_CHAR THEN
942: p_x_Header_Scredit_rec.attribute11 := NULL;
943: END IF;
944:
945: IF p_x_Header_Scredit_rec.attribute12 = FND_API.G_MISS_CHAR THEN
941: IF p_x_Header_Scredit_rec.attribute11 = FND_API.G_MISS_CHAR THEN
942: p_x_Header_Scredit_rec.attribute11 := NULL;
943: END IF;
944:
945: IF p_x_Header_Scredit_rec.attribute12 = FND_API.G_MISS_CHAR THEN
946: p_x_Header_Scredit_rec.attribute12 := NULL;
947: END IF;
948:
949: IF p_x_Header_Scredit_rec.attribute13 = FND_API.G_MISS_CHAR THEN
945: IF p_x_Header_Scredit_rec.attribute12 = FND_API.G_MISS_CHAR THEN
946: p_x_Header_Scredit_rec.attribute12 := NULL;
947: END IF;
948:
949: IF p_x_Header_Scredit_rec.attribute13 = FND_API.G_MISS_CHAR THEN
950: p_x_Header_Scredit_rec.attribute13 := NULL;
951: END IF;
952:
953: IF p_x_Header_Scredit_rec.attribute14 = FND_API.G_MISS_CHAR THEN
949: IF p_x_Header_Scredit_rec.attribute13 = FND_API.G_MISS_CHAR THEN
950: p_x_Header_Scredit_rec.attribute13 := NULL;
951: END IF;
952:
953: IF p_x_Header_Scredit_rec.attribute14 = FND_API.G_MISS_CHAR THEN
954: p_x_Header_Scredit_rec.attribute14 := NULL;
955: END IF;
956:
957: IF p_x_Header_Scredit_rec.attribute15 = FND_API.G_MISS_CHAR THEN
953: IF p_x_Header_Scredit_rec.attribute14 = FND_API.G_MISS_CHAR THEN
954: p_x_Header_Scredit_rec.attribute14 := NULL;
955: END IF;
956:
957: IF p_x_Header_Scredit_rec.attribute15 = FND_API.G_MISS_CHAR THEN
958: p_x_Header_Scredit_rec.attribute15 := NULL;
959: END IF;
960:
961: IF p_x_Header_Scredit_rec.attribute2 = FND_API.G_MISS_CHAR THEN
957: IF p_x_Header_Scredit_rec.attribute15 = FND_API.G_MISS_CHAR THEN
958: p_x_Header_Scredit_rec.attribute15 := NULL;
959: END IF;
960:
961: IF p_x_Header_Scredit_rec.attribute2 = FND_API.G_MISS_CHAR THEN
962: p_x_Header_Scredit_rec.attribute2 := NULL;
963: END IF;
964:
965: IF p_x_Header_Scredit_rec.attribute3 = FND_API.G_MISS_CHAR THEN
961: IF p_x_Header_Scredit_rec.attribute2 = FND_API.G_MISS_CHAR THEN
962: p_x_Header_Scredit_rec.attribute2 := NULL;
963: END IF;
964:
965: IF p_x_Header_Scredit_rec.attribute3 = FND_API.G_MISS_CHAR THEN
966: p_x_Header_Scredit_rec.attribute3 := NULL;
967: END IF;
968:
969: IF p_x_Header_Scredit_rec.attribute4 = FND_API.G_MISS_CHAR THEN
965: IF p_x_Header_Scredit_rec.attribute3 = FND_API.G_MISS_CHAR THEN
966: p_x_Header_Scredit_rec.attribute3 := NULL;
967: END IF;
968:
969: IF p_x_Header_Scredit_rec.attribute4 = FND_API.G_MISS_CHAR THEN
970: p_x_Header_Scredit_rec.attribute4 := NULL;
971: END IF;
972:
973: IF p_x_Header_Scredit_rec.attribute5 = FND_API.G_MISS_CHAR THEN
969: IF p_x_Header_Scredit_rec.attribute4 = FND_API.G_MISS_CHAR THEN
970: p_x_Header_Scredit_rec.attribute4 := NULL;
971: END IF;
972:
973: IF p_x_Header_Scredit_rec.attribute5 = FND_API.G_MISS_CHAR THEN
974: p_x_Header_Scredit_rec.attribute5 := NULL;
975: END IF;
976:
977: IF p_x_Header_Scredit_rec.attribute6 = FND_API.G_MISS_CHAR THEN
973: IF p_x_Header_Scredit_rec.attribute5 = FND_API.G_MISS_CHAR THEN
974: p_x_Header_Scredit_rec.attribute5 := NULL;
975: END IF;
976:
977: IF p_x_Header_Scredit_rec.attribute6 = FND_API.G_MISS_CHAR THEN
978: p_x_Header_Scredit_rec.attribute6 := NULL;
979: END IF;
980:
981: IF p_x_Header_Scredit_rec.attribute7 = FND_API.G_MISS_CHAR THEN
977: IF p_x_Header_Scredit_rec.attribute6 = FND_API.G_MISS_CHAR THEN
978: p_x_Header_Scredit_rec.attribute6 := NULL;
979: END IF;
980:
981: IF p_x_Header_Scredit_rec.attribute7 = FND_API.G_MISS_CHAR THEN
982: p_x_Header_Scredit_rec.attribute7 := NULL;
983: END IF;
984:
985: IF p_x_Header_Scredit_rec.attribute8 = FND_API.G_MISS_CHAR THEN
981: IF p_x_Header_Scredit_rec.attribute7 = FND_API.G_MISS_CHAR THEN
982: p_x_Header_Scredit_rec.attribute7 := NULL;
983: END IF;
984:
985: IF p_x_Header_Scredit_rec.attribute8 = FND_API.G_MISS_CHAR THEN
986: p_x_Header_Scredit_rec.attribute8 := NULL;
987: END IF;
988:
989: IF p_x_Header_Scredit_rec.attribute9 = FND_API.G_MISS_CHAR THEN
985: IF p_x_Header_Scredit_rec.attribute8 = FND_API.G_MISS_CHAR THEN
986: p_x_Header_Scredit_rec.attribute8 := NULL;
987: END IF;
988:
989: IF p_x_Header_Scredit_rec.attribute9 = FND_API.G_MISS_CHAR THEN
990: p_x_Header_Scredit_rec.attribute9 := NULL;
991: END IF;
992:
993: IF p_x_Header_Scredit_rec.context = FND_API.G_MISS_CHAR THEN
989: IF p_x_Header_Scredit_rec.attribute9 = FND_API.G_MISS_CHAR THEN
990: p_x_Header_Scredit_rec.attribute9 := NULL;
991: END IF;
992:
993: IF p_x_Header_Scredit_rec.context = FND_API.G_MISS_CHAR THEN
994: p_x_Header_Scredit_rec.context := NULL;
995: END IF;
996:
997: IF p_x_Header_Scredit_rec.created_by = FND_API.G_MISS_NUM THEN
993: IF p_x_Header_Scredit_rec.context = FND_API.G_MISS_CHAR THEN
994: p_x_Header_Scredit_rec.context := NULL;
995: END IF;
996:
997: IF p_x_Header_Scredit_rec.created_by = FND_API.G_MISS_NUM THEN
998: p_x_Header_Scredit_rec.created_by := NULL;
999: END IF;
1000:
1001: IF p_x_Header_Scredit_rec.creation_date = FND_API.G_MISS_DATE THEN
997: IF p_x_Header_Scredit_rec.created_by = FND_API.G_MISS_NUM THEN
998: p_x_Header_Scredit_rec.created_by := NULL;
999: END IF;
1000:
1001: IF p_x_Header_Scredit_rec.creation_date = FND_API.G_MISS_DATE THEN
1002: p_x_Header_Scredit_rec.creation_date := NULL;
1003: END IF;
1004:
1005: IF p_x_Header_Scredit_rec.dw_update_advice_flag = FND_API.G_MISS_CHAR THEN
1001: IF p_x_Header_Scredit_rec.creation_date = FND_API.G_MISS_DATE THEN
1002: p_x_Header_Scredit_rec.creation_date := NULL;
1003: END IF;
1004:
1005: IF p_x_Header_Scredit_rec.dw_update_advice_flag = FND_API.G_MISS_CHAR THEN
1006: p_x_Header_Scredit_rec.dw_update_advice_flag := NULL;
1007: END IF;
1008:
1009: IF p_x_Header_Scredit_rec.header_id = FND_API.G_MISS_NUM THEN
1005: IF p_x_Header_Scredit_rec.dw_update_advice_flag = FND_API.G_MISS_CHAR THEN
1006: p_x_Header_Scredit_rec.dw_update_advice_flag := NULL;
1007: END IF;
1008:
1009: IF p_x_Header_Scredit_rec.header_id = FND_API.G_MISS_NUM THEN
1010: p_x_Header_Scredit_rec.header_id := NULL;
1011: END IF;
1012:
1013: IF p_x_Header_Scredit_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1009: IF p_x_Header_Scredit_rec.header_id = FND_API.G_MISS_NUM THEN
1010: p_x_Header_Scredit_rec.header_id := NULL;
1011: END IF;
1012:
1013: IF p_x_Header_Scredit_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1014: p_x_Header_Scredit_rec.last_updated_by := NULL;
1015: END IF;
1016:
1017: IF p_x_Header_Scredit_rec.last_update_date = FND_API.G_MISS_DATE THEN
1013: IF p_x_Header_Scredit_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1014: p_x_Header_Scredit_rec.last_updated_by := NULL;
1015: END IF;
1016:
1017: IF p_x_Header_Scredit_rec.last_update_date = FND_API.G_MISS_DATE THEN
1018: p_x_Header_Scredit_rec.last_update_date := NULL;
1019: END IF;
1020:
1021: IF p_x_Header_Scredit_rec.last_update_login = FND_API.G_MISS_NUM THEN
1017: IF p_x_Header_Scredit_rec.last_update_date = FND_API.G_MISS_DATE THEN
1018: p_x_Header_Scredit_rec.last_update_date := NULL;
1019: END IF;
1020:
1021: IF p_x_Header_Scredit_rec.last_update_login = FND_API.G_MISS_NUM THEN
1022: p_x_Header_Scredit_rec.last_update_login := NULL;
1023: END IF;
1024:
1025: IF p_x_Header_Scredit_rec.line_id = FND_API.G_MISS_NUM THEN
1021: IF p_x_Header_Scredit_rec.last_update_login = FND_API.G_MISS_NUM THEN
1022: p_x_Header_Scredit_rec.last_update_login := NULL;
1023: END IF;
1024:
1025: IF p_x_Header_Scredit_rec.line_id = FND_API.G_MISS_NUM THEN
1026: p_x_Header_Scredit_rec.line_id := NULL;
1027: END IF;
1028:
1029: IF p_x_Header_Scredit_rec.percent = FND_API.G_MISS_NUM THEN
1025: IF p_x_Header_Scredit_rec.line_id = FND_API.G_MISS_NUM THEN
1026: p_x_Header_Scredit_rec.line_id := NULL;
1027: END IF;
1028:
1029: IF p_x_Header_Scredit_rec.percent = FND_API.G_MISS_NUM THEN
1030: p_x_Header_Scredit_rec.percent := NULL;
1031: END IF;
1032:
1033:
1030: p_x_Header_Scredit_rec.percent := NULL;
1031: END IF;
1032:
1033:
1034: IF p_x_Header_Scredit_rec.salesrep_id = FND_API.G_MISS_NUM THEN
1035: p_x_Header_Scredit_rec.salesrep_id := NULL;
1036: END IF;
1037: IF p_x_Header_Scredit_rec.sales_credit_type_id = FND_API.G_MISS_NUM THEN
1038: p_x_Header_Scredit_rec.sales_credit_type_id := NULL;
1033:
1034: IF p_x_Header_Scredit_rec.salesrep_id = FND_API.G_MISS_NUM THEN
1035: p_x_Header_Scredit_rec.salesrep_id := NULL;
1036: END IF;
1037: IF p_x_Header_Scredit_rec.sales_credit_type_id = FND_API.G_MISS_NUM THEN
1038: p_x_Header_Scredit_rec.sales_credit_type_id := NULL;
1039: END IF;
1040:
1041: IF p_x_Header_Scredit_rec.sales_credit_id = FND_API.G_MISS_NUM THEN
1037: IF p_x_Header_Scredit_rec.sales_credit_type_id = FND_API.G_MISS_NUM THEN
1038: p_x_Header_Scredit_rec.sales_credit_type_id := NULL;
1039: END IF;
1040:
1041: IF p_x_Header_Scredit_rec.sales_credit_id = FND_API.G_MISS_NUM THEN
1042: p_x_Header_Scredit_rec.sales_credit_id := NULL;
1043: END IF;
1044:
1045: IF p_x_Header_Scredit_rec.wh_update_date = FND_API.G_MISS_DATE THEN
1041: IF p_x_Header_Scredit_rec.sales_credit_id = FND_API.G_MISS_NUM THEN
1042: p_x_Header_Scredit_rec.sales_credit_id := NULL;
1043: END IF;
1044:
1045: IF p_x_Header_Scredit_rec.wh_update_date = FND_API.G_MISS_DATE THEN
1046: p_x_Header_Scredit_rec.wh_update_date := NULL;
1047: END IF;
1048:
1049:
1087: x_return_status => l_return_status);
1088: IF l_debug_level > 0 THEN
1089: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_HEADER_SCREDIT_UTIL.UPDATE_ROW IS: ' || L_RETURN_STATUS ) ;
1090: END IF;
1091: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1092: IF l_debug_level > 0 THEN
1093: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
1094: END IF;
1095: IF l_debug_level > 0 THEN
1094: END IF;
1095: IF l_debug_level > 0 THEN
1096: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDIT_UTIL.UPDATE_ROW' , 1 ) ;
1097: END IF;
1098: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1099: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1100: IF l_debug_level > 0 THEN
1101: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_SCREDIT_UTIL.UPDATE_ROW' ) ;
1102: END IF;
1095: IF l_debug_level > 0 THEN
1096: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDIT_UTIL.UPDATE_ROW' , 1 ) ;
1097: END IF;
1098: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1099: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1100: IF l_debug_level > 0 THEN
1101: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_SCREDIT_UTIL.UPDATE_ROW' ) ;
1102: END IF;
1103: IF l_debug_level > 0 THEN
1102: END IF;
1103: IF l_debug_level > 0 THEN
1104: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDIT_UTIL.UPDATE_ROW' , 1 ) ;
1105: END IF;
1106: RAISE FND_API.G_EXC_ERROR;
1107: END IF;
1108: END IF; /*code_release_level*/
1109: -- notification framework end
1110:
1159: , 'Update_Row'
1160: );
1161: END IF;
1162:
1163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1164:
1165: END Update_Row;
1166:
1167: -- Procedure Insert_Row
1273: IF l_debug_level > 0 THEN
1274: oe_debug_pub.add( 'RETURNED INDEX IS: ' || L_INDEX , 1 ) ;
1275: END IF;
1276:
1277: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1278: IF l_debug_level > 0 THEN
1279: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
1280: END IF;
1281: IF l_debug_level > 0 THEN
1280: END IF;
1281: IF l_debug_level > 0 THEN
1282: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDIT_UTIL.INSERT_ROW' , 1 ) ;
1283: END IF;
1284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1285: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1286: IF l_debug_level > 0 THEN
1287: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_SCREDIT_UTIL.INSERT_ROW' ) ;
1288: END IF;
1281: IF l_debug_level > 0 THEN
1282: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDIT_UTIL.INSERT_ROW' , 1 ) ;
1283: END IF;
1284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1285: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1286: IF l_debug_level > 0 THEN
1287: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_SCREDIT_UTIL.INSERT_ROW' ) ;
1288: END IF;
1289: IF l_debug_level > 0 THEN
1288: END IF;
1289: IF l_debug_level > 0 THEN
1290: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDIT_UTIL.INSERT_ROW' , 1 ) ;
1291: END IF;
1292: RAISE FND_API.G_EXC_ERROR;
1293: END IF;
1294: END IF; /*code_release_level*/
1295: -- notification framework end
1296:
1309: , 'Insert_Row'
1310: );
1311: END IF;
1312:
1313: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1314:
1315: END Insert_Row;
1316:
1317: -- Procedure Delete_Row
1317: -- Procedure Delete_Row
1318:
1319: PROCEDURE Delete_Row
1320: ( p_sales_credit_id IN NUMBER :=
1321: FND_API.G_MISS_NUM
1322: , p_header_id IN NUMBER :=
1323: FND_API.G_MISS_NUM
1324: )
1325: IS
1319: PROCEDURE Delete_Row
1320: ( p_sales_credit_id IN NUMBER :=
1321: FND_API.G_MISS_NUM
1322: , p_header_id IN NUMBER :=
1323: FND_API.G_MISS_NUM
1324: )
1325: IS
1326: l_return_status VARCHAR2(30);
1327: CURSOR sales_credit IS
1338: IF l_debug_level > 0 THEN
1339: oe_debug_pub.add( 'ENTERING OE_HEADER_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;
1340: END IF;
1341:
1342: IF p_header_id <> FND_API.G_MISS_NUM
1343: THEN
1344: FOR l_scr IN sales_credit LOOP
1345:
1346: --added notification framework
1357: x_return_status => l_return_status);
1358: IF l_debug_level > 0 THEN
1359: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_HEADER_SCREDIT_UTIL.DELETE_ROW IS: ' || L_RETURN_STATUS ) ;
1360: END IF;
1361: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1362: IF l_debug_level > 0 THEN
1363: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
1364: END IF;
1365: IF l_debug_level > 0 THEN
1364: END IF;
1365: IF l_debug_level > 0 THEN
1366: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;
1367: END IF;
1368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1369: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1370: IF l_debug_level > 0 THEN
1371: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_SCREDIT_UTIL.DELETE_ROW' ) ;
1372: END IF;
1365: IF l_debug_level > 0 THEN
1366: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;
1367: END IF;
1368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1369: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1370: IF l_debug_level > 0 THEN
1371: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_SCREDIT_UTIL.DELETE_ROW' ) ;
1372: END IF;
1373: IF l_debug_level > 0 THEN
1372: END IF;
1373: IF l_debug_level > 0 THEN
1374: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;
1375: END IF;
1376: RAISE FND_API.G_EXC_ERROR;
1377: END IF;
1378: END IF; /*code_release_level*/
1379: -- notification framework end
1380:
1407: IF l_debug_level > 0 THEN
1408: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_HEADER_SCREDIT_UTIL.DELETE_ROW IS: ' || L_RETURN_STATUS ) ;
1409: END IF;
1410:
1411: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1412: IF l_debug_level > 0 THEN
1413: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
1414: END IF;
1415: IF l_debug_level > 0 THEN
1414: END IF;
1415: IF l_debug_level > 0 THEN
1416: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;
1417: END IF;
1418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1419: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1420: IF l_debug_level > 0 THEN
1421: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_SCREDIT_UTIL.DELETE_ROW' ) ;
1422: END IF;
1415: IF l_debug_level > 0 THEN
1416: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;
1417: END IF;
1418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1419: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1420: IF l_debug_level > 0 THEN
1421: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_SCREDIT_UTIL.DELETE_ROW' ) ;
1422: END IF;
1423: IF l_debug_level > 0 THEN
1422: END IF;
1423: IF l_debug_level > 0 THEN
1424: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;
1425: END IF;
1426: RAISE FND_API.G_EXC_ERROR;
1427: END IF;
1428: END IF; /*code_release_level*/
1429: -- notification framework end
1430:
1465: , 'Delete_Row'
1466: );
1467: END IF;
1468:
1469: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1470:
1471: END Delete_Row;
1472:
1473: -- Procedure Query_Row
1497: --
1498:
1499: Procedure Query_Rows
1500: ( p_sales_credit_id IN NUMBER :=
1501: FND_API.G_MISS_NUM
1502: , p_header_id IN NUMBER :=
1503: FND_API.G_MISS_NUM
1504: , x_header_scredit_tbl IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Tbl_Type
1505: )
1499: Procedure Query_Rows
1500: ( p_sales_credit_id IN NUMBER :=
1501: FND_API.G_MISS_NUM
1502: , p_header_id IN NUMBER :=
1503: FND_API.G_MISS_NUM
1504: , x_header_scredit_tbl IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Tbl_Type
1505: )
1506: IS
1507: l_count NUMBER;
1593:
1594: IF
1595: (p_sales_credit_id IS NOT NULL
1596: AND
1597: p_sales_credit_id <> FND_API.G_MISS_NUM)
1598: AND
1599: (p_header_id IS NOT NULL
1600: AND
1601: p_header_id <> FND_API.G_MISS_NUM)
1597: p_sales_credit_id <> FND_API.G_MISS_NUM)
1598: AND
1599: (p_header_id IS NOT NULL
1600: AND
1601: p_header_id <> FND_API.G_MISS_NUM)
1602: THEN
1603: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1604: THEN
1605: oe_msg_pub.Add_Exc_Msg
1608: , 'Keys are mutually exclusive: sales_credit_id = '|| p_sales_credit_id || ', header_id = '|| p_header_id
1609: );
1610: END IF;
1611:
1612: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1613:
1614: END IF;
1615:
1616: IF nvl(p_sales_credit_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1612: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1613:
1614: END IF;
1615:
1616: IF nvl(p_sales_credit_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1617: l_entity := 1;
1618: OPEN l_header_scredit_csr_s;
1619: ELSIF nvl(p_header_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1620: l_entity := 2;
1615:
1616: IF nvl(p_sales_credit_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1617: l_entity := 1;
1618: OPEN l_header_scredit_csr_s;
1619: ELSIF nvl(p_header_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1620: l_entity := 2;
1621: OPEN l_header_scredit_csr_h;
1622: END IF;
1623:
1682:
1683: IF
1684: (p_sales_credit_id IS NOT NULL
1685: AND
1686: p_sales_credit_id <> FND_API.G_MISS_NUM)
1687: AND
1688: (x_Header_Scredit_tbl.COUNT = 0)
1689: THEN
1690: RAISE NO_DATA_FOUND;
1695:
1696:
1697: EXCEPTION
1698:
1699: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1700:
1701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1702:
1703: WHEN OTHERS THEN
1697: EXCEPTION
1698:
1699: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1700:
1701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1702:
1703: WHEN OTHERS THEN
1704:
1705: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1709: , 'Query_Rows'
1710: );
1711: END IF;
1712:
1713: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1714:
1715: END Query_Rows;
1716:
1717: -- Procedure lock_Row
1720: PROCEDURE Lock_Row
1721: ( x_return_status OUT NOCOPY VARCHAR2
1722: , p_x_Header_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type
1723: , p_sales_credit_id IN NUMBER
1724: := FND_API.G_MISS_NUM
1725: )
1726: IS
1727: l_sales_credit_id NUMBER;
1728: l_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1740:
1741: l_lock_control := NULL;
1742:
1743: -- Retrieve the primary key.
1744: IF p_sales_credit_id <> FND_API.G_MISS_NUM THEN
1745: l_sales_credit_id := p_sales_credit_id;
1746: ELSE
1747: l_sales_credit_id := p_x_header_scredit_rec.sales_credit_id;
1748: l_lock_control := p_x_header_scredit_rec.lock_control;
1765:
1766: -- If lock_control is null / missing, then return the locked record.
1767:
1768: IF l_lock_control is null OR
1769: l_lock_control <> FND_API.G_MISS_NUM THEN
1770:
1771: -- Set return status
1772: x_return_status := FND_API.G_RET_STS_SUCCESS;
1773: p_x_header_scredit_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1768: IF l_lock_control is null OR
1769: l_lock_control <> FND_API.G_MISS_NUM THEN
1770:
1771: -- Set return status
1772: x_return_status := FND_API.G_RET_STS_SUCCESS;
1773: p_x_header_scredit_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1774:
1775: RETURN;
1776:
1769: l_lock_control <> FND_API.G_MISS_NUM THEN
1770:
1771: -- Set return status
1772: x_return_status := FND_API.G_RET_STS_SUCCESS;
1773: p_x_header_scredit_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1774:
1775: RETURN;
1776:
1777: END IF;
1788: p_x_Header_Scredit_rec := l_Header_Scredit_rec;
1789:
1790: -- Set return status
1791:
1792: x_return_status := FND_API.G_RET_STS_SUCCESS;
1793: p_x_Header_Scredit_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1794:
1795: ELSE
1796:
1789:
1790: -- Set return status
1791:
1792: x_return_status := FND_API.G_RET_STS_SUCCESS;
1793: p_x_Header_Scredit_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1794:
1795: ELSE
1796:
1797: -- Row has changed by another user.
1795: ELSE
1796:
1797: -- Row has changed by another user.
1798:
1799: x_return_status := FND_API.G_RET_STS_ERROR;
1800: p_x_Header_Scredit_rec.return_status := FND_API.G_RET_STS_ERROR;
1801:
1802: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1803: THEN
1796:
1797: -- Row has changed by another user.
1798:
1799: x_return_status := FND_API.G_RET_STS_ERROR;
1800: p_x_Header_Scredit_rec.return_status := FND_API.G_RET_STS_ERROR;
1801:
1802: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1803: THEN
1804:
1815: EXCEPTION
1816:
1817: WHEN NO_DATA_FOUND THEN
1818:
1819: x_return_status := FND_API.G_RET_STS_ERROR;
1820: p_x_Header_Scredit_rec.return_status := FND_API.G_RET_STS_ERROR;
1821:
1822: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1823: THEN
1816:
1817: WHEN NO_DATA_FOUND THEN
1818:
1819: x_return_status := FND_API.G_RET_STS_ERROR;
1820: p_x_Header_Scredit_rec.return_status := FND_API.G_RET_STS_ERROR;
1821:
1822: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1823: THEN
1824:
1827:
1828: END IF;
1829: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1830:
1831: x_return_status := FND_API.G_RET_STS_ERROR;
1832: p_x_Header_Scredit_rec.return_status := FND_API.G_RET_STS_ERROR;
1833:
1834: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1835: THEN
1828: END IF;
1829: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1830:
1831: x_return_status := FND_API.G_RET_STS_ERROR;
1832: p_x_Header_Scredit_rec.return_status := FND_API.G_RET_STS_ERROR;
1833:
1834: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1835: THEN
1836:
1839:
1840: END IF;
1841: WHEN OTHERS THEN
1842:
1843: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1844: p_x_Header_Scredit_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1845:
1846: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1847: THEN
1840: END IF;
1841: WHEN OTHERS THEN
1842:
1843: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1844: p_x_Header_Scredit_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1845:
1846: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1847: THEN
1848: oe_msg_pub.Add_Exc_Msg
1854: END Lock_Row;
1855:
1856: PROCEDURE Lock_Rows
1857: ( p_sales_credit_id IN NUMBER :=
1858: FND_API.G_MISS_NUM
1859: , p_header_id IN NUMBER :=
1860: FND_API.G_MISS_NUM
1861: , x_header_scredit_tbl OUT NOCOPY OE_Order_PUB.header_scredit_Tbl_Type
1862: , x_return_status OUT NOCOPY VARCHAR2
1856: PROCEDURE Lock_Rows
1857: ( p_sales_credit_id IN NUMBER :=
1858: FND_API.G_MISS_NUM
1859: , p_header_id IN NUMBER :=
1860: FND_API.G_MISS_NUM
1861: , x_header_scredit_tbl OUT NOCOPY OE_Order_PUB.header_scredit_Tbl_Type
1862: , x_return_status OUT NOCOPY VARCHAR2
1863: )
1864: IS
1878: oe_debug_pub.add( 'ENTERING OE_HEADER_SCREDITS_UTIL.LOCK_ROWS' , 1 ) ;
1879: END IF;
1880:
1881: IF (p_sales_credit_id IS NOT NULL AND
1882: p_sales_credit_id <> FND_API.G_MISS_NUM) AND
1883: (p_header_id IS NOT NULL AND
1884: p_header_id <> FND_API.G_MISS_NUM)
1885: THEN
1886: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1880:
1881: IF (p_sales_credit_id IS NOT NULL AND
1882: p_sales_credit_id <> FND_API.G_MISS_NUM) AND
1883: (p_header_id IS NOT NULL AND
1884: p_header_id <> FND_API.G_MISS_NUM)
1885: THEN
1886: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1887: THEN
1888: OE_MSG_PUB.Add_Exc_Msg
1891: , 'Keys are mutually exclusive: sales_credit_id = '||
1892: p_sales_credit_id || ', header_id = '|| p_header_id );
1893: END IF;
1894:
1895: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1896:
1897: END IF;
1898:
1899: IF p_sales_credit_id <> FND_API.G_MISS_NUM THEN
1895: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1896:
1897: END IF;
1898:
1899: IF p_sales_credit_id <> FND_API.G_MISS_NUM THEN
1900:
1901: SELECT sales_credit_id
1902: INTO l_sales_credit_id
1903: FROM OE_SALES_CREDITS
1910: -- if they already passed in line_id.
1911:
1912: BEGIN
1913:
1914: IF p_header_id <> FND_API.G_MISS_NUM THEN
1915:
1916: SAVEPOINT LOCK_ROWS;
1917: OPEN lock_hdr_scredits(p_header_id);
1918:
1943: ,p_header_id => p_header_id
1944: ,x_header_scredit_tbl => x_header_scredit_tbl
1945: );
1946:
1947: x_return_status := FND_API.G_RET_STS_SUCCESS;
1948:
1949: IF l_debug_level > 0 THEN
1950: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDITS_UTIL.LOCK_ROWS' , 1 ) ;
1951: END IF;
1952:
1953: EXCEPTION
1954: WHEN NO_DATA_FOUND THEN
1955:
1956: x_return_status := FND_API.G_RET_STS_ERROR;
1957:
1958: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1959: THEN
1960: fnd_message.set_name('ONT','OE_LOCK_ROW_DELETED');
1962: END IF;
1963:
1964: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1965:
1966: x_return_status := FND_API.G_RET_STS_ERROR;
1967: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1968: THEN
1969: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
1970: OE_MSG_PUB.Add;
1971: END IF;
1972:
1973: WHEN OTHERS THEN
1974:
1975: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1976:
1977: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1978: THEN
1979: OE_MSG_PUB.Add_Exc_Msg
2002: --sg}
2003: BEGIN
2004:
2005: IF (p_Header_Scredit_rec.salesrep_id IS NULL OR
2006: p_Header_Scredit_rec.salesrep_id <> FND_API.G_MISS_NUM) AND
2007: NOT OE_GLOBALS.Equal(p_Header_Scredit_rec.salesrep_id,
2008: p_old_Header_Scredit_rec.salesrep_id)
2009: THEN
2010: l_Header_Scredit_val_rec.salesrep := OE_Id_To_Value.Salesrep
2012: );
2013: END IF;
2014:
2015: IF (p_Header_Scredit_rec.sales_credit_type_id IS NULL OR
2016: p_Header_Scredit_rec.sales_credit_type_id <> FND_API.G_MISS_NUM) AND
2017: NOT OE_GLOBALS.Equal(p_Header_Scredit_rec.sales_credit_type_id,
2018: p_old_Header_Scredit_rec.sales_credit_type_id)
2019: THEN
2020: l_Header_Scredit_val_rec.sales_credit_type := OE_Id_To_Value.sales_credit_type
2058: BEGIN
2059:
2060: -- initialize return_status.
2061:
2062: p_x_Header_Scredit_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2063:
2064: -- initialize l_Header_Scredit_rec.
2065:
2066:
2064: -- initialize l_Header_Scredit_rec.
2065:
2066:
2067:
2068: IF p_Header_Scredit_val_rec.salesrep <> FND_API.G_MISS_CHAR
2069: THEN
2070:
2071: IF p_x_Header_Scredit_rec.salesrep_id <> FND_API.G_MISS_NUM THEN
2072:
2067:
2068: IF p_Header_Scredit_val_rec.salesrep <> FND_API.G_MISS_CHAR
2069: THEN
2070:
2071: IF p_x_Header_Scredit_rec.salesrep_id <> FND_API.G_MISS_NUM THEN
2072:
2073:
2074:
2075: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2086: p_x_Header_Scredit_rec.salesrep_id := OE_Value_To_Id.salesrep
2087: ( p_salesrep => p_Header_Scredit_val_rec.salesrep
2088: );
2089:
2090: IF p_x_Header_Scredit_rec.salesrep_id = FND_API.G_MISS_NUM THEN
2091: p_x_Header_Scredit_rec.return_status := FND_API.G_RET_STS_ERROR;
2092: END IF;
2093:
2094: END IF;
2087: ( p_salesrep => p_Header_Scredit_val_rec.salesrep
2088: );
2089:
2090: IF p_x_Header_Scredit_rec.salesrep_id = FND_API.G_MISS_NUM THEN
2091: p_x_Header_Scredit_rec.return_status := FND_API.G_RET_STS_ERROR;
2092: END IF;
2093:
2094: END IF;
2095:
2094: END IF;
2095:
2096: END IF;
2097:
2098: IF p_Header_Scredit_val_rec.sales_credit_type <> FND_API.G_MISS_CHAR
2099: THEN
2100:
2101: IF p_x_Header_Scredit_rec.sales_credit_type_id <> FND_API.G_MISS_NUM THEN
2102:
2097:
2098: IF p_Header_Scredit_val_rec.sales_credit_type <> FND_API.G_MISS_CHAR
2099: THEN
2100:
2101: IF p_x_Header_Scredit_rec.sales_credit_type_id <> FND_API.G_MISS_NUM THEN
2102:
2103:
2104: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2105: THEN
2115: p_x_Header_Scredit_rec.sales_credit_type_id := OE_Value_To_Id.sales_credit_type
2116: ( p_sales_credit_type => p_Header_Scredit_val_rec.sales_credit_type
2117: );
2118:
2119: IF p_x_Header_Scredit_rec.sales_credit_type_id = FND_API.G_MISS_NUM THEN
2120: p_x_Header_Scredit_rec.return_status := FND_API.G_RET_STS_ERROR;
2121: END IF;
2122:
2123: END IF;
2116: ( p_sales_credit_type => p_Header_Scredit_val_rec.sales_credit_type
2117: );
2118:
2119: IF p_x_Header_Scredit_rec.sales_credit_type_id = FND_API.G_MISS_NUM THEN
2120: p_x_Header_Scredit_rec.return_status := FND_API.G_RET_STS_ERROR;
2121: END IF;
2122:
2123: END IF;
2124:
2144: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' AND
2145: OE_GLOBALS.G_ROLL_VERSION <> 'N' THEN
2146: IF OE_GLOBALS.G_REASON_CODE IS NULL AND
2147: OE_GLOBALS.G_CAPTURED_REASON IN ('V','A') THEN
2148: IF p_x_header_scredit_rec.change_reason <> FND_API.G_MISS_CHAR THEN
2149: OE_GLOBALS.G_REASON_CODE := p_x_header_scredit_rec.change_reason;
2150: OE_GLOBALS.G_REASON_COMMENTS := p_x_header_scredit_rec.change_comments;
2151: OE_GLOBALS.G_CAPTURED_REASON := 'Y';
2152: ELSE
2153: IF l_debug_level > 0 THEN
2154: OE_DEBUG_PUB.add('Reason code missing for versioning', 1);
2155: END IF;
2156: IF OE_GLOBALS.G_UI_FLAG THEN
2157: raise FND_API.G_EXC_ERROR;
2158: END IF;
2159: END IF;
2160: END IF;
2161:
2177: IF l_debug_level > 0 THEN
2178: oe_debug_pub.add( 'AUDIT TRAIL , CHANGE ATTRIBUTE REQUIRES REASON' , 1 ) ;
2179: END IF;
2180: IF (p_x_header_scredit_rec.change_reason IS NULL OR
2181: p_x_header_scredit_rec.change_reason = FND_API.G_MISS_CHAR OR
2182: NOT OE_Validate.Change_Reason_Code(p_x_header_scredit_rec.change_reason)) THEN
2183: -- bug 3636884, defaulting reason from group API
2184: IF OE_GLOBALS.G_DEFAULT_REASON THEN
2185: if l_debug_level > 0 then
2192: END IF;
2193: fnd_message.set_name('ONT','OE_AUDIT_REASON_RQD');
2194: fnd_message.set_token('OBJECT','ORDER SALES CREDIT');
2195: oe_msg_pub.add;
2196: raise FND_API.G_EXC_ERROR;
2197: END IF;
2198: END IF;
2199: END IF;
2200: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG = 'Y' OR
2226: p_wf_activity_code => null,
2227: p_wf_result_code => null,
2228: x_return_status => l_return_status);
2229: END IF;
2230: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2231: IF l_debug_level > 0 THEN
2232: oe_debug_pub.add( 'INSERTING HEADER SCREDIT HISTORY CAUSED ERROR' , 1 ) ;
2233: END IF;
2234: if l_return_status = FND_API.G_RET_STS_ERROR then
2230: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2231: IF l_debug_level > 0 THEN
2232: oe_debug_pub.add( 'INSERTING HEADER SCREDIT HISTORY CAUSED ERROR' , 1 ) ;
2233: END IF;
2234: if l_return_status = FND_API.G_RET_STS_ERROR then
2235: raise FND_API.G_EXC_ERROR;
2236: else
2237: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2238: end if;
2231: IF l_debug_level > 0 THEN
2232: oe_debug_pub.add( 'INSERTING HEADER SCREDIT HISTORY CAUSED ERROR' , 1 ) ;
2233: END IF;
2234: if l_return_status = FND_API.G_RET_STS_ERROR then
2235: raise FND_API.G_EXC_ERROR;
2236: else
2237: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2238: end if;
2239: end if;
2233: END IF;
2234: if l_return_status = FND_API.G_RET_STS_ERROR then
2235: raise FND_API.G_EXC_ERROR;
2236: else
2237: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2238: end if;
2239: end if;
2240:
2241: END IF;
2256: --
2257: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2258: --
2259: Begin
2260: x_return_status := FND_API.G_RET_STS_SUCCESS;
2261:
2262: --sample on how to populate the out. Values are hardcoded for testing purpose
2263: /* i:= p_salesrep_id_tbl.First;
2264: While i Is Not Null Loop
2356: /* IF l_sales_credits_count > 1 THEN
2357:
2358: fnd_message.set_name('ONT','OE_TOO_MANY_HSCREDIT');
2359: OE_MSG_PUB.Add;
2360: RAISE FND_API.G_EXC_ERROR;
2361:
2362: ELSIF l_sales_credits_count = 1 THEN */
2363: -- update with new salesrep
2364: -- Commented to fix bug 1589196 End
2368: , p_x_Header_Scredit_rec => l_Header_Scredit_rec
2369: , x_return_status => l_return_status
2370: );
2371:
2372: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2374: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2375: RAISE FND_API.G_EXC_ERROR;
2376: END IF;
2369: , x_return_status => l_return_status
2370: );
2371:
2372: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2374: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2375: RAISE FND_API.G_EXC_ERROR;
2376: END IF;
2377:
2370: );
2371:
2372: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2374: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2375: RAISE FND_API.G_EXC_ERROR;
2376: END IF;
2377:
2378: -- Populate Header_Scredit table
2371:
2372: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2374: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2375: RAISE FND_API.G_EXC_ERROR;
2376: END IF;
2377:
2378: -- Populate Header_Scredit table
2379:
2452: -- Set recursion mode.
2453: -- OE_GLOBALS.G_RECURSION_MODE := 'Y';
2454:
2455: OE_ORDER_PVT.Header_Scredits
2456: (p_validation_level => FND_API.G_VALID_LEVEL_FULL
2457: ,p_control_rec => l_control_rec
2458: ,p_x_Header_Scredit_tbl => l_Header_Scredit_tbl
2459: ,p_x_old_Header_Scredit_tbl => l_old_Header_Scredit_tbl
2460: ,x_return_status => l_return_status);
2461:
2462: -- Reset recursion mode.
2463: -- OE_GLOBALS.G_RECURSION_MODE := 'N';
2464:
2465: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2466: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2467: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2468: RAISE FND_API.G_EXC_ERROR;
2469: END IF;
2462: -- Reset recursion mode.
2463: -- OE_GLOBALS.G_RECURSION_MODE := 'N';
2464:
2465: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2466: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2467: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2468: RAISE FND_API.G_EXC_ERROR;
2469: END IF;
2470:
2463: -- OE_GLOBALS.G_RECURSION_MODE := 'N';
2464:
2465: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2466: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2467: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2468: RAISE FND_API.G_EXC_ERROR;
2469: END IF;
2470:
2471: /*comment out for notification framework*/
2464:
2465: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2466: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2467: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2468: RAISE FND_API.G_EXC_ERROR;
2469: END IF;
2470:
2471: /*comment out for notification framework*/
2472: /*
2476: ,x_return_status => l_return_status
2477: ,p_Header_Scredit_tbl => l_Header_Scredit_tbl
2478: ,p_old_Header_scredit_tbl => l_old_Header_Scredit_tbl);
2479:
2480: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2482: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2483: RAISE FND_API.G_EXC_ERROR;
2484: END IF;
2477: ,p_Header_Scredit_tbl => l_Header_Scredit_tbl
2478: ,p_old_Header_scredit_tbl => l_old_Header_Scredit_tbl);
2479:
2480: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2482: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2483: RAISE FND_API.G_EXC_ERROR;
2484: END IF;
2485: */
2478: ,p_old_Header_scredit_tbl => l_old_Header_Scredit_tbl);
2479:
2480: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2482: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2483: RAISE FND_API.G_EXC_ERROR;
2484: END IF;
2485: */
2486:
2479:
2480: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2482: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2483: RAISE FND_API.G_EXC_ERROR;
2484: END IF;
2485: */
2486:
2487: IF l_sales_credits_count = 1 THEN -- issue message update with new salesrep
2494: END IF;
2495:
2496: EXCEPTION
2497:
2498: WHEN FND_API.G_EXC_ERROR THEN
2499:
2500: x_return_status := FND_API.G_RET_STS_ERROR;
2501:
2502: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2496: EXCEPTION
2497:
2498: WHEN FND_API.G_EXC_ERROR THEN
2499:
2500: x_return_status := FND_API.G_RET_STS_ERROR;
2501:
2502: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2503:
2504: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2498: WHEN FND_API.G_EXC_ERROR THEN
2499:
2500: x_return_status := FND_API.G_RET_STS_ERROR;
2501:
2502: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2503:
2504: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2505:
2506: WHEN OTHERS THEN
2500: x_return_status := FND_API.G_RET_STS_ERROR;
2501:
2502: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2503:
2504: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2505:
2506: WHEN OTHERS THEN
2507:
2508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2504: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2505:
2506: WHEN OTHERS THEN
2507:
2508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2509:
2510: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2511: THEN
2512: OE_MSG_PUB.Add_Exc_Msg
2522: x_sales_group_id OUT NOCOPY NUMBER,
2523: --x_sales_group OUT NOCOPY VARCHAR2,
2524: x_return_status OUT NOCOPY VARCHAR2) AS
2525: Begin
2526: x_return_status:=FND_API.G_RET_STS_SUCCESS;
2527:
2528:
2529: G_ORG_ID := OE_GLOBALS.G_ORG_ID;
2530:
2541: End;
2542:
2543: Exception
2544: When Others Then
2545: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2546: End;
2547:
2548: /*************************************
2549: Redefault sales group as of input date
2583: oe_debug_pub.add(' date passed:'||p_date);
2584: oe_debug_pub.add(' return status from get_sales_group:'||l_status);
2585: end if;
2586:
2587: If l_status = FND_API.G_RET_STS_SUCCESS
2588: and nvl(l_sales_group_id,-101) <> nvl(i.sales_group_id,-101) Then
2589: if l_debug_level > 0 then
2590: oe_debug_pub.add(' l_sales_group_id_tbl index j:'||j);
2591: oe_debug_pub.add(' old sales group id:'||i.sales_credit_id);