24: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
25: --
26: BEGIN
27:
28: l_rowtype_rec.ATTRIBUTE1 := FND_API.G_MISS_CHAR;
29: l_rowtype_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
30: l_rowtype_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
31: l_rowtype_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
32: l_rowtype_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
25: --
26: BEGIN
27:
28: l_rowtype_rec.ATTRIBUTE1 := FND_API.G_MISS_CHAR;
29: l_rowtype_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
30: l_rowtype_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
31: l_rowtype_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
32: l_rowtype_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
33: l_rowtype_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
26: BEGIN
27:
28: l_rowtype_rec.ATTRIBUTE1 := FND_API.G_MISS_CHAR;
29: l_rowtype_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
30: l_rowtype_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
31: l_rowtype_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
32: l_rowtype_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
33: l_rowtype_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
34: l_rowtype_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
27:
28: l_rowtype_rec.ATTRIBUTE1 := FND_API.G_MISS_CHAR;
29: l_rowtype_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
30: l_rowtype_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
31: l_rowtype_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
32: l_rowtype_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
33: l_rowtype_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
34: l_rowtype_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
35: l_rowtype_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
28: l_rowtype_rec.ATTRIBUTE1 := FND_API.G_MISS_CHAR;
29: l_rowtype_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
30: l_rowtype_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
31: l_rowtype_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
32: l_rowtype_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
33: l_rowtype_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
34: l_rowtype_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
35: l_rowtype_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
36: l_rowtype_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
29: l_rowtype_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
30: l_rowtype_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
31: l_rowtype_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
32: l_rowtype_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
33: l_rowtype_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
34: l_rowtype_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
35: l_rowtype_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
36: l_rowtype_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
37: l_rowtype_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
30: l_rowtype_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
31: l_rowtype_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
32: l_rowtype_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
33: l_rowtype_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
34: l_rowtype_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
35: l_rowtype_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
36: l_rowtype_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
37: l_rowtype_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
38: l_rowtype_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
31: l_rowtype_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
32: l_rowtype_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
33: l_rowtype_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
34: l_rowtype_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
35: l_rowtype_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
36: l_rowtype_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
37: l_rowtype_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
38: l_rowtype_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
39: l_rowtype_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
32: l_rowtype_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
33: l_rowtype_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
34: l_rowtype_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
35: l_rowtype_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
36: l_rowtype_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
37: l_rowtype_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
38: l_rowtype_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
39: l_rowtype_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
40: l_rowtype_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
33: l_rowtype_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
34: l_rowtype_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
35: l_rowtype_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
36: l_rowtype_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
37: l_rowtype_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
38: l_rowtype_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
39: l_rowtype_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
40: l_rowtype_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
41: l_rowtype_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
34: l_rowtype_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
35: l_rowtype_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
36: l_rowtype_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
37: l_rowtype_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
38: l_rowtype_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
39: l_rowtype_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
40: l_rowtype_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
41: l_rowtype_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
42: l_rowtype_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
35: l_rowtype_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
36: l_rowtype_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
37: l_rowtype_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
38: l_rowtype_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
39: l_rowtype_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
40: l_rowtype_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
41: l_rowtype_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
42: l_rowtype_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
43: l_rowtype_rec.CONTEXT := FND_API.G_MISS_CHAR;
36: l_rowtype_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
37: l_rowtype_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
38: l_rowtype_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
39: l_rowtype_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
40: l_rowtype_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
41: l_rowtype_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
42: l_rowtype_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
43: l_rowtype_rec.CONTEXT := FND_API.G_MISS_CHAR;
44: l_rowtype_rec.CREATED_BY := FND_API.G_MISS_NUM;
37: l_rowtype_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
38: l_rowtype_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
39: l_rowtype_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
40: l_rowtype_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
41: l_rowtype_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
42: l_rowtype_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
43: l_rowtype_rec.CONTEXT := FND_API.G_MISS_CHAR;
44: l_rowtype_rec.CREATED_BY := FND_API.G_MISS_NUM;
45: l_rowtype_rec.CREATION_DATE := FND_API.G_MISS_DATE;
38: l_rowtype_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
39: l_rowtype_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
40: l_rowtype_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
41: l_rowtype_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
42: l_rowtype_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
43: l_rowtype_rec.CONTEXT := FND_API.G_MISS_CHAR;
44: l_rowtype_rec.CREATED_BY := FND_API.G_MISS_NUM;
45: l_rowtype_rec.CREATION_DATE := FND_API.G_MISS_DATE;
46: l_rowtype_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
39: l_rowtype_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
40: l_rowtype_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
41: l_rowtype_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
42: l_rowtype_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
43: l_rowtype_rec.CONTEXT := FND_API.G_MISS_CHAR;
44: l_rowtype_rec.CREATED_BY := FND_API.G_MISS_NUM;
45: l_rowtype_rec.CREATION_DATE := FND_API.G_MISS_DATE;
46: l_rowtype_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
47: l_rowtype_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
40: l_rowtype_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
41: l_rowtype_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
42: l_rowtype_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
43: l_rowtype_rec.CONTEXT := FND_API.G_MISS_CHAR;
44: l_rowtype_rec.CREATED_BY := FND_API.G_MISS_NUM;
45: l_rowtype_rec.CREATION_DATE := FND_API.G_MISS_DATE;
46: l_rowtype_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
47: l_rowtype_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
48: l_rowtype_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
41: l_rowtype_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
42: l_rowtype_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
43: l_rowtype_rec.CONTEXT := FND_API.G_MISS_CHAR;
44: l_rowtype_rec.CREATED_BY := FND_API.G_MISS_NUM;
45: l_rowtype_rec.CREATION_DATE := FND_API.G_MISS_DATE;
46: l_rowtype_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
47: l_rowtype_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
48: l_rowtype_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
49: l_rowtype_rec.CHECK_NUMBER := FND_API.G_MISS_CHAR;
42: l_rowtype_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
43: l_rowtype_rec.CONTEXT := FND_API.G_MISS_CHAR;
44: l_rowtype_rec.CREATED_BY := FND_API.G_MISS_NUM;
45: l_rowtype_rec.CREATION_DATE := FND_API.G_MISS_DATE;
46: l_rowtype_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
47: l_rowtype_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
48: l_rowtype_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
49: l_rowtype_rec.CHECK_NUMBER := FND_API.G_MISS_CHAR;
50: l_rowtype_rec.CREDIT_CARD_APPROVAL_CODE := FND_API.G_MISS_CHAR;
43: l_rowtype_rec.CONTEXT := FND_API.G_MISS_CHAR;
44: l_rowtype_rec.CREATED_BY := FND_API.G_MISS_NUM;
45: l_rowtype_rec.CREATION_DATE := FND_API.G_MISS_DATE;
46: l_rowtype_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
47: l_rowtype_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
48: l_rowtype_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
49: l_rowtype_rec.CHECK_NUMBER := FND_API.G_MISS_CHAR;
50: l_rowtype_rec.CREDIT_CARD_APPROVAL_CODE := FND_API.G_MISS_CHAR;
51: l_rowtype_rec.CREDIT_CARD_APPROVAL_DATE := FND_API.G_MISS_DATE;
44: l_rowtype_rec.CREATED_BY := FND_API.G_MISS_NUM;
45: l_rowtype_rec.CREATION_DATE := FND_API.G_MISS_DATE;
46: l_rowtype_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
47: l_rowtype_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
48: l_rowtype_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
49: l_rowtype_rec.CHECK_NUMBER := FND_API.G_MISS_CHAR;
50: l_rowtype_rec.CREDIT_CARD_APPROVAL_CODE := FND_API.G_MISS_CHAR;
51: l_rowtype_rec.CREDIT_CARD_APPROVAL_DATE := FND_API.G_MISS_DATE;
52: l_rowtype_rec.CREDIT_CARD_CODE := FND_API.G_MISS_CHAR;
45: l_rowtype_rec.CREATION_DATE := FND_API.G_MISS_DATE;
46: l_rowtype_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
47: l_rowtype_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
48: l_rowtype_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
49: l_rowtype_rec.CHECK_NUMBER := FND_API.G_MISS_CHAR;
50: l_rowtype_rec.CREDIT_CARD_APPROVAL_CODE := FND_API.G_MISS_CHAR;
51: l_rowtype_rec.CREDIT_CARD_APPROVAL_DATE := FND_API.G_MISS_DATE;
52: l_rowtype_rec.CREDIT_CARD_CODE := FND_API.G_MISS_CHAR;
53: l_rowtype_rec.CREDIT_CARD_EXPIRATION_DATE := FND_API.G_MISS_DATE;
46: l_rowtype_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
47: l_rowtype_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
48: l_rowtype_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
49: l_rowtype_rec.CHECK_NUMBER := FND_API.G_MISS_CHAR;
50: l_rowtype_rec.CREDIT_CARD_APPROVAL_CODE := FND_API.G_MISS_CHAR;
51: l_rowtype_rec.CREDIT_CARD_APPROVAL_DATE := FND_API.G_MISS_DATE;
52: l_rowtype_rec.CREDIT_CARD_CODE := FND_API.G_MISS_CHAR;
53: l_rowtype_rec.CREDIT_CARD_EXPIRATION_DATE := FND_API.G_MISS_DATE;
54: l_rowtype_rec.CREDIT_CARD_HOLDER_NAME := FND_API.G_MISS_CHAR;
47: l_rowtype_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
48: l_rowtype_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
49: l_rowtype_rec.CHECK_NUMBER := FND_API.G_MISS_CHAR;
50: l_rowtype_rec.CREDIT_CARD_APPROVAL_CODE := FND_API.G_MISS_CHAR;
51: l_rowtype_rec.CREDIT_CARD_APPROVAL_DATE := FND_API.G_MISS_DATE;
52: l_rowtype_rec.CREDIT_CARD_CODE := FND_API.G_MISS_CHAR;
53: l_rowtype_rec.CREDIT_CARD_EXPIRATION_DATE := FND_API.G_MISS_DATE;
54: l_rowtype_rec.CREDIT_CARD_HOLDER_NAME := FND_API.G_MISS_CHAR;
55: l_rowtype_rec.CREDIT_CARD_NUMBER := FND_API.G_MISS_CHAR;
48: l_rowtype_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
49: l_rowtype_rec.CHECK_NUMBER := FND_API.G_MISS_CHAR;
50: l_rowtype_rec.CREDIT_CARD_APPROVAL_CODE := FND_API.G_MISS_CHAR;
51: l_rowtype_rec.CREDIT_CARD_APPROVAL_DATE := FND_API.G_MISS_DATE;
52: l_rowtype_rec.CREDIT_CARD_CODE := FND_API.G_MISS_CHAR;
53: l_rowtype_rec.CREDIT_CARD_EXPIRATION_DATE := FND_API.G_MISS_DATE;
54: l_rowtype_rec.CREDIT_CARD_HOLDER_NAME := FND_API.G_MISS_CHAR;
55: l_rowtype_rec.CREDIT_CARD_NUMBER := FND_API.G_MISS_CHAR;
56: l_rowtype_rec.PAYMENT_LEVEL_CODE := FND_API.G_MISS_CHAR;
49: l_rowtype_rec.CHECK_NUMBER := FND_API.G_MISS_CHAR;
50: l_rowtype_rec.CREDIT_CARD_APPROVAL_CODE := FND_API.G_MISS_CHAR;
51: l_rowtype_rec.CREDIT_CARD_APPROVAL_DATE := FND_API.G_MISS_DATE;
52: l_rowtype_rec.CREDIT_CARD_CODE := FND_API.G_MISS_CHAR;
53: l_rowtype_rec.CREDIT_CARD_EXPIRATION_DATE := FND_API.G_MISS_DATE;
54: l_rowtype_rec.CREDIT_CARD_HOLDER_NAME := FND_API.G_MISS_CHAR;
55: l_rowtype_rec.CREDIT_CARD_NUMBER := FND_API.G_MISS_CHAR;
56: l_rowtype_rec.PAYMENT_LEVEL_CODE := FND_API.G_MISS_CHAR;
57: l_rowtype_rec.COMMITMENT_APPLIED_AMOUNT := FND_API.G_MISS_NUM;
50: l_rowtype_rec.CREDIT_CARD_APPROVAL_CODE := FND_API.G_MISS_CHAR;
51: l_rowtype_rec.CREDIT_CARD_APPROVAL_DATE := FND_API.G_MISS_DATE;
52: l_rowtype_rec.CREDIT_CARD_CODE := FND_API.G_MISS_CHAR;
53: l_rowtype_rec.CREDIT_CARD_EXPIRATION_DATE := FND_API.G_MISS_DATE;
54: l_rowtype_rec.CREDIT_CARD_HOLDER_NAME := FND_API.G_MISS_CHAR;
55: l_rowtype_rec.CREDIT_CARD_NUMBER := FND_API.G_MISS_CHAR;
56: l_rowtype_rec.PAYMENT_LEVEL_CODE := FND_API.G_MISS_CHAR;
57: l_rowtype_rec.COMMITMENT_APPLIED_AMOUNT := FND_API.G_MISS_NUM;
58: l_rowtype_rec.COMMITMENT_INTERFACED_AMOUNT := FND_API.G_MISS_NUM;
51: l_rowtype_rec.CREDIT_CARD_APPROVAL_DATE := FND_API.G_MISS_DATE;
52: l_rowtype_rec.CREDIT_CARD_CODE := FND_API.G_MISS_CHAR;
53: l_rowtype_rec.CREDIT_CARD_EXPIRATION_DATE := FND_API.G_MISS_DATE;
54: l_rowtype_rec.CREDIT_CARD_HOLDER_NAME := FND_API.G_MISS_CHAR;
55: l_rowtype_rec.CREDIT_CARD_NUMBER := FND_API.G_MISS_CHAR;
56: l_rowtype_rec.PAYMENT_LEVEL_CODE := FND_API.G_MISS_CHAR;
57: l_rowtype_rec.COMMITMENT_APPLIED_AMOUNT := FND_API.G_MISS_NUM;
58: l_rowtype_rec.COMMITMENT_INTERFACED_AMOUNT := FND_API.G_MISS_NUM;
59: l_rowtype_rec.PAYMENT_NUMBER := FND_API.G_MISS_NUM;
52: l_rowtype_rec.CREDIT_CARD_CODE := FND_API.G_MISS_CHAR;
53: l_rowtype_rec.CREDIT_CARD_EXPIRATION_DATE := FND_API.G_MISS_DATE;
54: l_rowtype_rec.CREDIT_CARD_HOLDER_NAME := FND_API.G_MISS_CHAR;
55: l_rowtype_rec.CREDIT_CARD_NUMBER := FND_API.G_MISS_CHAR;
56: l_rowtype_rec.PAYMENT_LEVEL_CODE := FND_API.G_MISS_CHAR;
57: l_rowtype_rec.COMMITMENT_APPLIED_AMOUNT := FND_API.G_MISS_NUM;
58: l_rowtype_rec.COMMITMENT_INTERFACED_AMOUNT := FND_API.G_MISS_NUM;
59: l_rowtype_rec.PAYMENT_NUMBER := FND_API.G_MISS_NUM;
60: l_rowtype_rec.HEADER_ID := FND_API.G_MISS_NUM;
53: l_rowtype_rec.CREDIT_CARD_EXPIRATION_DATE := FND_API.G_MISS_DATE;
54: l_rowtype_rec.CREDIT_CARD_HOLDER_NAME := FND_API.G_MISS_CHAR;
55: l_rowtype_rec.CREDIT_CARD_NUMBER := FND_API.G_MISS_CHAR;
56: l_rowtype_rec.PAYMENT_LEVEL_CODE := FND_API.G_MISS_CHAR;
57: l_rowtype_rec.COMMITMENT_APPLIED_AMOUNT := FND_API.G_MISS_NUM;
58: l_rowtype_rec.COMMITMENT_INTERFACED_AMOUNT := FND_API.G_MISS_NUM;
59: l_rowtype_rec.PAYMENT_NUMBER := FND_API.G_MISS_NUM;
60: l_rowtype_rec.HEADER_ID := FND_API.G_MISS_NUM;
61: l_rowtype_rec.LINE_ID := FND_API.G_MISS_NUM;
54: l_rowtype_rec.CREDIT_CARD_HOLDER_NAME := FND_API.G_MISS_CHAR;
55: l_rowtype_rec.CREDIT_CARD_NUMBER := FND_API.G_MISS_CHAR;
56: l_rowtype_rec.PAYMENT_LEVEL_CODE := FND_API.G_MISS_CHAR;
57: l_rowtype_rec.COMMITMENT_APPLIED_AMOUNT := FND_API.G_MISS_NUM;
58: l_rowtype_rec.COMMITMENT_INTERFACED_AMOUNT := FND_API.G_MISS_NUM;
59: l_rowtype_rec.PAYMENT_NUMBER := FND_API.G_MISS_NUM;
60: l_rowtype_rec.HEADER_ID := FND_API.G_MISS_NUM;
61: l_rowtype_rec.LINE_ID := FND_API.G_MISS_NUM;
62: l_rowtype_rec.PAYMENT_AMOUNT := FND_API.G_MISS_NUM;
55: l_rowtype_rec.CREDIT_CARD_NUMBER := FND_API.G_MISS_CHAR;
56: l_rowtype_rec.PAYMENT_LEVEL_CODE := FND_API.G_MISS_CHAR;
57: l_rowtype_rec.COMMITMENT_APPLIED_AMOUNT := FND_API.G_MISS_NUM;
58: l_rowtype_rec.COMMITMENT_INTERFACED_AMOUNT := FND_API.G_MISS_NUM;
59: l_rowtype_rec.PAYMENT_NUMBER := FND_API.G_MISS_NUM;
60: l_rowtype_rec.HEADER_ID := FND_API.G_MISS_NUM;
61: l_rowtype_rec.LINE_ID := FND_API.G_MISS_NUM;
62: l_rowtype_rec.PAYMENT_AMOUNT := FND_API.G_MISS_NUM;
63: l_rowtype_rec.PAYMENT_COLLECTION_EVENT := FND_API.G_MISS_CHAR;
56: l_rowtype_rec.PAYMENT_LEVEL_CODE := FND_API.G_MISS_CHAR;
57: l_rowtype_rec.COMMITMENT_APPLIED_AMOUNT := FND_API.G_MISS_NUM;
58: l_rowtype_rec.COMMITMENT_INTERFACED_AMOUNT := FND_API.G_MISS_NUM;
59: l_rowtype_rec.PAYMENT_NUMBER := FND_API.G_MISS_NUM;
60: l_rowtype_rec.HEADER_ID := FND_API.G_MISS_NUM;
61: l_rowtype_rec.LINE_ID := FND_API.G_MISS_NUM;
62: l_rowtype_rec.PAYMENT_AMOUNT := FND_API.G_MISS_NUM;
63: l_rowtype_rec.PAYMENT_COLLECTION_EVENT := FND_API.G_MISS_CHAR;
64: l_rowtype_rec.PAYMENT_TRX_ID := FND_API.G_MISS_NUM;
57: l_rowtype_rec.COMMITMENT_APPLIED_AMOUNT := FND_API.G_MISS_NUM;
58: l_rowtype_rec.COMMITMENT_INTERFACED_AMOUNT := FND_API.G_MISS_NUM;
59: l_rowtype_rec.PAYMENT_NUMBER := FND_API.G_MISS_NUM;
60: l_rowtype_rec.HEADER_ID := FND_API.G_MISS_NUM;
61: l_rowtype_rec.LINE_ID := FND_API.G_MISS_NUM;
62: l_rowtype_rec.PAYMENT_AMOUNT := FND_API.G_MISS_NUM;
63: l_rowtype_rec.PAYMENT_COLLECTION_EVENT := FND_API.G_MISS_CHAR;
64: l_rowtype_rec.PAYMENT_TRX_ID := FND_API.G_MISS_NUM;
65: l_rowtype_rec.PAYMENT_TYPE_CODE := FND_API.G_MISS_CHAR;
58: l_rowtype_rec.COMMITMENT_INTERFACED_AMOUNT := FND_API.G_MISS_NUM;
59: l_rowtype_rec.PAYMENT_NUMBER := FND_API.G_MISS_NUM;
60: l_rowtype_rec.HEADER_ID := FND_API.G_MISS_NUM;
61: l_rowtype_rec.LINE_ID := FND_API.G_MISS_NUM;
62: l_rowtype_rec.PAYMENT_AMOUNT := FND_API.G_MISS_NUM;
63: l_rowtype_rec.PAYMENT_COLLECTION_EVENT := FND_API.G_MISS_CHAR;
64: l_rowtype_rec.PAYMENT_TRX_ID := FND_API.G_MISS_NUM;
65: l_rowtype_rec.PAYMENT_TYPE_CODE := FND_API.G_MISS_CHAR;
66: l_rowtype_rec.PAYMENT_SET_ID := FND_API.G_MISS_NUM;
59: l_rowtype_rec.PAYMENT_NUMBER := FND_API.G_MISS_NUM;
60: l_rowtype_rec.HEADER_ID := FND_API.G_MISS_NUM;
61: l_rowtype_rec.LINE_ID := FND_API.G_MISS_NUM;
62: l_rowtype_rec.PAYMENT_AMOUNT := FND_API.G_MISS_NUM;
63: l_rowtype_rec.PAYMENT_COLLECTION_EVENT := FND_API.G_MISS_CHAR;
64: l_rowtype_rec.PAYMENT_TRX_ID := FND_API.G_MISS_NUM;
65: l_rowtype_rec.PAYMENT_TYPE_CODE := FND_API.G_MISS_CHAR;
66: l_rowtype_rec.PAYMENT_SET_ID := FND_API.G_MISS_NUM;
67: l_rowtype_rec.PREPAID_AMOUNT := FND_API.G_MISS_NUM;
60: l_rowtype_rec.HEADER_ID := FND_API.G_MISS_NUM;
61: l_rowtype_rec.LINE_ID := FND_API.G_MISS_NUM;
62: l_rowtype_rec.PAYMENT_AMOUNT := FND_API.G_MISS_NUM;
63: l_rowtype_rec.PAYMENT_COLLECTION_EVENT := FND_API.G_MISS_CHAR;
64: l_rowtype_rec.PAYMENT_TRX_ID := FND_API.G_MISS_NUM;
65: l_rowtype_rec.PAYMENT_TYPE_CODE := FND_API.G_MISS_CHAR;
66: l_rowtype_rec.PAYMENT_SET_ID := FND_API.G_MISS_NUM;
67: l_rowtype_rec.PREPAID_AMOUNT := FND_API.G_MISS_NUM;
68: l_rowtype_rec.PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;
61: l_rowtype_rec.LINE_ID := FND_API.G_MISS_NUM;
62: l_rowtype_rec.PAYMENT_AMOUNT := FND_API.G_MISS_NUM;
63: l_rowtype_rec.PAYMENT_COLLECTION_EVENT := FND_API.G_MISS_CHAR;
64: l_rowtype_rec.PAYMENT_TRX_ID := FND_API.G_MISS_NUM;
65: l_rowtype_rec.PAYMENT_TYPE_CODE := FND_API.G_MISS_CHAR;
66: l_rowtype_rec.PAYMENT_SET_ID := FND_API.G_MISS_NUM;
67: l_rowtype_rec.PREPAID_AMOUNT := FND_API.G_MISS_NUM;
68: l_rowtype_rec.PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;
69: l_rowtype_rec.PROGRAM_ID := FND_API.G_MISS_NUM;
62: l_rowtype_rec.PAYMENT_AMOUNT := FND_API.G_MISS_NUM;
63: l_rowtype_rec.PAYMENT_COLLECTION_EVENT := FND_API.G_MISS_CHAR;
64: l_rowtype_rec.PAYMENT_TRX_ID := FND_API.G_MISS_NUM;
65: l_rowtype_rec.PAYMENT_TYPE_CODE := FND_API.G_MISS_CHAR;
66: l_rowtype_rec.PAYMENT_SET_ID := FND_API.G_MISS_NUM;
67: l_rowtype_rec.PREPAID_AMOUNT := FND_API.G_MISS_NUM;
68: l_rowtype_rec.PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;
69: l_rowtype_rec.PROGRAM_ID := FND_API.G_MISS_NUM;
70: l_rowtype_rec.PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
63: l_rowtype_rec.PAYMENT_COLLECTION_EVENT := FND_API.G_MISS_CHAR;
64: l_rowtype_rec.PAYMENT_TRX_ID := FND_API.G_MISS_NUM;
65: l_rowtype_rec.PAYMENT_TYPE_CODE := FND_API.G_MISS_CHAR;
66: l_rowtype_rec.PAYMENT_SET_ID := FND_API.G_MISS_NUM;
67: l_rowtype_rec.PREPAID_AMOUNT := FND_API.G_MISS_NUM;
68: l_rowtype_rec.PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;
69: l_rowtype_rec.PROGRAM_ID := FND_API.G_MISS_NUM;
70: l_rowtype_rec.PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
71: l_rowtype_rec.RECEIPT_METHOD_ID := FND_API.G_MISS_NUM;
64: l_rowtype_rec.PAYMENT_TRX_ID := FND_API.G_MISS_NUM;
65: l_rowtype_rec.PAYMENT_TYPE_CODE := FND_API.G_MISS_CHAR;
66: l_rowtype_rec.PAYMENT_SET_ID := FND_API.G_MISS_NUM;
67: l_rowtype_rec.PREPAID_AMOUNT := FND_API.G_MISS_NUM;
68: l_rowtype_rec.PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;
69: l_rowtype_rec.PROGRAM_ID := FND_API.G_MISS_NUM;
70: l_rowtype_rec.PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
71: l_rowtype_rec.RECEIPT_METHOD_ID := FND_API.G_MISS_NUM;
72: l_rowtype_rec.REQUEST_ID := FND_API.G_MISS_NUM;
65: l_rowtype_rec.PAYMENT_TYPE_CODE := FND_API.G_MISS_CHAR;
66: l_rowtype_rec.PAYMENT_SET_ID := FND_API.G_MISS_NUM;
67: l_rowtype_rec.PREPAID_AMOUNT := FND_API.G_MISS_NUM;
68: l_rowtype_rec.PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;
69: l_rowtype_rec.PROGRAM_ID := FND_API.G_MISS_NUM;
70: l_rowtype_rec.PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
71: l_rowtype_rec.RECEIPT_METHOD_ID := FND_API.G_MISS_NUM;
72: l_rowtype_rec.REQUEST_ID := FND_API.G_MISS_NUM;
73: l_rowtype_rec.TANGIBLE_ID := FND_API.G_MISS_CHAR;
66: l_rowtype_rec.PAYMENT_SET_ID := FND_API.G_MISS_NUM;
67: l_rowtype_rec.PREPAID_AMOUNT := FND_API.G_MISS_NUM;
68: l_rowtype_rec.PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;
69: l_rowtype_rec.PROGRAM_ID := FND_API.G_MISS_NUM;
70: l_rowtype_rec.PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
71: l_rowtype_rec.RECEIPT_METHOD_ID := FND_API.G_MISS_NUM;
72: l_rowtype_rec.REQUEST_ID := FND_API.G_MISS_NUM;
73: l_rowtype_rec.TANGIBLE_ID := FND_API.G_MISS_CHAR;
74: l_rowtype_rec.RETURN_STATUS := FND_API.G_MISS_CHAR;
67: l_rowtype_rec.PREPAID_AMOUNT := FND_API.G_MISS_NUM;
68: l_rowtype_rec.PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;
69: l_rowtype_rec.PROGRAM_ID := FND_API.G_MISS_NUM;
70: l_rowtype_rec.PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
71: l_rowtype_rec.RECEIPT_METHOD_ID := FND_API.G_MISS_NUM;
72: l_rowtype_rec.REQUEST_ID := FND_API.G_MISS_NUM;
73: l_rowtype_rec.TANGIBLE_ID := FND_API.G_MISS_CHAR;
74: l_rowtype_rec.RETURN_STATUS := FND_API.G_MISS_CHAR;
75: l_rowtype_rec.DB_FLAG := FND_API.G_MISS_CHAR;
68: l_rowtype_rec.PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;
69: l_rowtype_rec.PROGRAM_ID := FND_API.G_MISS_NUM;
70: l_rowtype_rec.PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
71: l_rowtype_rec.RECEIPT_METHOD_ID := FND_API.G_MISS_NUM;
72: l_rowtype_rec.REQUEST_ID := FND_API.G_MISS_NUM;
73: l_rowtype_rec.TANGIBLE_ID := FND_API.G_MISS_CHAR;
74: l_rowtype_rec.RETURN_STATUS := FND_API.G_MISS_CHAR;
75: l_rowtype_rec.DB_FLAG := FND_API.G_MISS_CHAR;
76: l_rowtype_rec.OPERATION := FND_API.G_MISS_CHAR;
69: l_rowtype_rec.PROGRAM_ID := FND_API.G_MISS_NUM;
70: l_rowtype_rec.PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
71: l_rowtype_rec.RECEIPT_METHOD_ID := FND_API.G_MISS_NUM;
72: l_rowtype_rec.REQUEST_ID := FND_API.G_MISS_NUM;
73: l_rowtype_rec.TANGIBLE_ID := FND_API.G_MISS_CHAR;
74: l_rowtype_rec.RETURN_STATUS := FND_API.G_MISS_CHAR;
75: l_rowtype_rec.DB_FLAG := FND_API.G_MISS_CHAR;
76: l_rowtype_rec.OPERATION := FND_API.G_MISS_CHAR;
77:
70: l_rowtype_rec.PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
71: l_rowtype_rec.RECEIPT_METHOD_ID := FND_API.G_MISS_NUM;
72: l_rowtype_rec.REQUEST_ID := FND_API.G_MISS_NUM;
73: l_rowtype_rec.TANGIBLE_ID := FND_API.G_MISS_CHAR;
74: l_rowtype_rec.RETURN_STATUS := FND_API.G_MISS_CHAR;
75: l_rowtype_rec.DB_FLAG := FND_API.G_MISS_CHAR;
76: l_rowtype_rec.OPERATION := FND_API.G_MISS_CHAR;
77:
78: RETURN l_rowtype_rec;
71: l_rowtype_rec.RECEIPT_METHOD_ID := FND_API.G_MISS_NUM;
72: l_rowtype_rec.REQUEST_ID := FND_API.G_MISS_NUM;
73: l_rowtype_rec.TANGIBLE_ID := FND_API.G_MISS_CHAR;
74: l_rowtype_rec.RETURN_STATUS := FND_API.G_MISS_CHAR;
75: l_rowtype_rec.DB_FLAG := FND_API.G_MISS_CHAR;
76: l_rowtype_rec.OPERATION := FND_API.G_MISS_CHAR;
77:
78: RETURN l_rowtype_rec;
79:
72: l_rowtype_rec.REQUEST_ID := FND_API.G_MISS_NUM;
73: l_rowtype_rec.TANGIBLE_ID := FND_API.G_MISS_CHAR;
74: l_rowtype_rec.RETURN_STATUS := FND_API.G_MISS_CHAR;
75: l_rowtype_rec.DB_FLAG := FND_API.G_MISS_CHAR;
76: l_rowtype_rec.OPERATION := FND_API.G_MISS_CHAR;
77:
78: RETURN l_rowtype_rec;
79:
80: END G_MISS_OE_AK_LPAYMENT_REC;
203:
204: -- Procedure Clear_Dependent_Attr
205:
206: PROCEDURE Clear_Dependent_Attr
207: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
208: , p_x_Line_Payment_rec IN OUT NOCOPY OE_AK_LINE_PAYMENTS_V%ROWTYPE
209: , p_old_Line_Payment_rec IN OE_AK_LINE_PAYMENTS_V%ROWTYPE :=
210: G_MISS_OE_AK_LPayment_REC
211: , p_x_instrument_id IN NUMBER DEFAULT NULL --R12 CC Encryption
226:
227: -- If attr_id is missing compare old and new records and for
228: -- every changed attribute clear its dependent fields.
229:
230: IF p_attr_id = FND_API.G_MISS_NUM THEN
231:
232: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.attribute1,p_old_Line_Payment_rec.attribute1)
233: THEN
234: l_index := l_index + 1;
660: p_dep_attr_tbl => l_dep_attr_tbl);
661:
662: FOR I IN 1..l_dep_attr_tbl.COUNT LOOP
663: IF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE1 THEN
664: p_x_Line_PAYMENT_rec.ATTRIBUTE1 := FND_API.G_MISS_NUM;
665: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE2 THEN
666: p_x_Line_PAYMENT_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
667: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE3 THEN
668: p_x_Line_PAYMENT_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
662: FOR I IN 1..l_dep_attr_tbl.COUNT LOOP
663: IF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE1 THEN
664: p_x_Line_PAYMENT_rec.ATTRIBUTE1 := FND_API.G_MISS_NUM;
665: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE2 THEN
666: p_x_Line_PAYMENT_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
667: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE3 THEN
668: p_x_Line_PAYMENT_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
669: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE4 THEN
670: p_x_Line_PAYMENT_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
664: p_x_Line_PAYMENT_rec.ATTRIBUTE1 := FND_API.G_MISS_NUM;
665: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE2 THEN
666: p_x_Line_PAYMENT_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
667: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE3 THEN
668: p_x_Line_PAYMENT_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
669: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE4 THEN
670: p_x_Line_PAYMENT_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
671: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE5 THEN
672: p_x_Line_PAYMENT_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
666: p_x_Line_PAYMENT_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
667: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE3 THEN
668: p_x_Line_PAYMENT_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
669: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE4 THEN
670: p_x_Line_PAYMENT_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
671: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE5 THEN
672: p_x_Line_PAYMENT_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
673: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE6 THEN
674: p_x_Line_PAYMENT_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
668: p_x_Line_PAYMENT_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
669: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE4 THEN
670: p_x_Line_PAYMENT_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
671: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE5 THEN
672: p_x_Line_PAYMENT_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
673: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE6 THEN
674: p_x_Line_PAYMENT_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
675: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE7 THEN
676: p_x_Line_PAYMENT_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
670: p_x_Line_PAYMENT_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
671: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE5 THEN
672: p_x_Line_PAYMENT_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
673: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE6 THEN
674: p_x_Line_PAYMENT_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
675: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE7 THEN
676: p_x_Line_PAYMENT_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
677: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE8 THEN
678: p_x_Line_PAYMENT_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
672: p_x_Line_PAYMENT_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
673: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE6 THEN
674: p_x_Line_PAYMENT_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
675: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE7 THEN
676: p_x_Line_PAYMENT_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
677: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE8 THEN
678: p_x_Line_PAYMENT_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
679: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE9 THEN
680: p_x_Line_PAYMENT_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
674: p_x_Line_PAYMENT_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
675: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE7 THEN
676: p_x_Line_PAYMENT_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
677: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE8 THEN
678: p_x_Line_PAYMENT_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
679: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE9 THEN
680: p_x_Line_PAYMENT_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
681: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE10 THEN
682: p_x_Line_PAYMENT_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
676: p_x_Line_PAYMENT_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
677: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE8 THEN
678: p_x_Line_PAYMENT_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
679: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE9 THEN
680: p_x_Line_PAYMENT_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
681: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE10 THEN
682: p_x_Line_PAYMENT_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
683: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE11 THEN
684: p_x_Line_PAYMENT_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
678: p_x_Line_PAYMENT_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
679: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE9 THEN
680: p_x_Line_PAYMENT_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
681: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE10 THEN
682: p_x_Line_PAYMENT_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
683: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE11 THEN
684: p_x_Line_PAYMENT_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
685: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE12 THEN
686: p_x_Line_PAYMENT_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
680: p_x_Line_PAYMENT_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
681: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE10 THEN
682: p_x_Line_PAYMENT_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
683: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE11 THEN
684: p_x_Line_PAYMENT_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
685: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE12 THEN
686: p_x_Line_PAYMENT_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
687: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE13 THEN
688: p_x_Line_PAYMENT_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
682: p_x_Line_PAYMENT_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
683: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE11 THEN
684: p_x_Line_PAYMENT_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
685: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE12 THEN
686: p_x_Line_PAYMENT_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
687: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE13 THEN
688: p_x_Line_PAYMENT_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
689: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE14 THEN
690: p_x_Line_PAYMENT_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
684: p_x_Line_PAYMENT_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
685: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE12 THEN
686: p_x_Line_PAYMENT_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
687: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE13 THEN
688: p_x_Line_PAYMENT_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
689: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE14 THEN
690: p_x_Line_PAYMENT_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
691: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE15 THEN
692: p_x_Line_PAYMENT_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
686: p_x_Line_PAYMENT_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
687: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE13 THEN
688: p_x_Line_PAYMENT_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
689: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE14 THEN
690: p_x_Line_PAYMENT_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
691: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE15 THEN
692: p_x_Line_PAYMENT_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
693: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_CONTEXT THEN
694: p_x_Line_PAYMENT_rec.CONTEXT := FND_API.G_MISS_CHAR;
688: p_x_Line_PAYMENT_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
689: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE14 THEN
690: p_x_Line_PAYMENT_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
691: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE15 THEN
692: p_x_Line_PAYMENT_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
693: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_CONTEXT THEN
694: p_x_Line_PAYMENT_rec.CONTEXT := FND_API.G_MISS_CHAR;
695: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_CREATED_BY THEN
696: p_x_Line_PAYMENT_rec.CREATED_BY := FND_API.G_MISS_NUM;
690: p_x_Line_PAYMENT_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
691: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE15 THEN
692: p_x_Line_PAYMENT_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
693: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_CONTEXT THEN
694: p_x_Line_PAYMENT_rec.CONTEXT := FND_API.G_MISS_CHAR;
695: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_CREATED_BY THEN
696: p_x_Line_PAYMENT_rec.CREATED_BY := FND_API.G_MISS_NUM;
697: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_CREATION_DATE THEN
698: p_x_Line_PAYMENT_rec.CREATION_DATE := FND_API.G_MISS_DATE;
692: p_x_Line_PAYMENT_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
693: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_CONTEXT THEN
694: p_x_Line_PAYMENT_rec.CONTEXT := FND_API.G_MISS_CHAR;
695: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_CREATED_BY THEN
696: p_x_Line_PAYMENT_rec.CREATED_BY := FND_API.G_MISS_NUM;
697: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_CREATION_DATE THEN
698: p_x_Line_PAYMENT_rec.CREATION_DATE := FND_API.G_MISS_DATE;
699: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_LAST_UPDATED_BY THEN
700: p_x_Line_PAYMENT_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
694: p_x_Line_PAYMENT_rec.CONTEXT := FND_API.G_MISS_CHAR;
695: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_CREATED_BY THEN
696: p_x_Line_PAYMENT_rec.CREATED_BY := FND_API.G_MISS_NUM;
697: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_CREATION_DATE THEN
698: p_x_Line_PAYMENT_rec.CREATION_DATE := FND_API.G_MISS_DATE;
699: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_LAST_UPDATED_BY THEN
700: p_x_Line_PAYMENT_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
701: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_LAST_UPDATE_DATE THEN
702: p_x_Line_PAYMENT_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
696: p_x_Line_PAYMENT_rec.CREATED_BY := FND_API.G_MISS_NUM;
697: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_CREATION_DATE THEN
698: p_x_Line_PAYMENT_rec.CREATION_DATE := FND_API.G_MISS_DATE;
699: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_LAST_UPDATED_BY THEN
700: p_x_Line_PAYMENT_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
701: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_LAST_UPDATE_DATE THEN
702: p_x_Line_PAYMENT_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
703: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_LAST_UPDATE_LOGIN THEN
704: p_x_Line_PAYMENT_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
698: p_x_Line_PAYMENT_rec.CREATION_DATE := FND_API.G_MISS_DATE;
699: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_LAST_UPDATED_BY THEN
700: p_x_Line_PAYMENT_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
701: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_LAST_UPDATE_DATE THEN
702: p_x_Line_PAYMENT_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
703: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_LAST_UPDATE_LOGIN THEN
704: p_x_Line_PAYMENT_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
705: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_CHECK_NUMBER THEN
706: p_x_Line_PAYMENT_rec.CHECK_NUMBER := FND_API.G_MISS_CHAR;
700: p_x_Line_PAYMENT_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
701: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_LAST_UPDATE_DATE THEN
702: p_x_Line_PAYMENT_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
703: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_LAST_UPDATE_LOGIN THEN
704: p_x_Line_PAYMENT_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
705: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_CHECK_NUMBER THEN
706: p_x_Line_PAYMENT_rec.CHECK_NUMBER := FND_API.G_MISS_CHAR;
707: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_CREDIT_CARD_APPROVAL_CODE THEN
708: --R12 CC Encryption
702: p_x_Line_PAYMENT_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
703: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_LAST_UPDATE_LOGIN THEN
704: p_x_Line_PAYMENT_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
705: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_CHECK_NUMBER THEN
706: p_x_Line_PAYMENT_rec.CHECK_NUMBER := FND_API.G_MISS_CHAR;
707: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_CREDIT_CARD_APPROVAL_CODE THEN
708: --R12 CC Encryption
709: --Added the additional conditional before clearing credit
710: --card attributes as the dependent attributes were cleared out
714: AND (p_old_Line_Payment_rec.header_id IS NOT NULL OR
715: p_x_Line_PAYMENT_rec.CREDIT_CARD_APPROVAL_CODE IS NOT NULL)
716: ) -- AND condition added to fix 3098878
717: THEN
718: p_x_Line_PAYMENT_rec.CREDIT_CARD_APPROVAL_CODE := FND_API.G_MISS_CHAR;
719: END IF;
720: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_CREDIT_CARD_APPROVAL_DATE THEN
721: IF (OE_GLOBALS.Equal(p_x_Line_PAYMENT_rec.CREDIT_CARD_APPROVAL_DATE, p_old_Line_Payment_rec.CREDIT_CARD_APPROVAL_DATE)
722: AND (p_old_Line_Payment_rec.header_id IS NOT NULL OR
722: AND (p_old_Line_Payment_rec.header_id IS NOT NULL OR
723: p_x_Line_PAYMENT_rec.CREDIT_CARD_APPROVAL_DATE IS NOT NULL)
724: ) -- AND condition added to fix 3098878
725: THEN
726: p_x_Line_PAYMENT_rec.CREDIT_CARD_APPROVAL_DATE := FND_API.G_MISS_DATE;
727: END IF;
728: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_CREDIT_CARD_CODE THEN
729: IF (OE_GLOBALS.Equal(p_x_Line_PAYMENT_rec.CREDIT_CARD_CODE, p_old_Line_Payment_rec.CREDIT_CARD_CODE)
730: AND (p_old_Line_Payment_rec.header_id IS NOT NULL OR
730: AND (p_old_Line_Payment_rec.header_id IS NOT NULL OR
731: p_x_Line_PAYMENT_rec.CREDIT_CARD_CODE IS NOT NULL)
732: ) -- AND condition added to fix 3098878
733: THEN
734: p_x_Line_PAYMENT_rec.CREDIT_CARD_CODE := FND_API.G_MISS_CHAR;
735: END IF;
736: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_CREDIT_CARD_EXPIRATION_DATE THEN
737: --IF l_debug_level > 0 THEN
738: --oe_debug_pub.add('Old exp date'||p_old_Line_Payment_rec.credit_card_expiration_date);
742: AND (p_old_Line_Payment_rec.header_id IS NOT NULL OR
743: p_x_Line_PAYMENT_rec.CREDIT_CARD_EXPIRATION_DATE IS NOT NULL)
744: ) -- AND condition added to fix 3098878
745: THEN
746: p_x_Line_PAYMENT_rec.CREDIT_CARD_EXPIRATION_DATE := FND_API.G_MISS_DATE;
747: END IF;
748: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_CREDIT_CARD_HOLDER_NAME THEN
749: --IF l_debug_level > 0 THEN
750: --oe_debug_pub.add('Old holder name'||p_old_Line_Payment_rec.CREDIT_CARD_HOLDER_NAME);
754: AND (p_old_Line_Payment_rec.header_id IS NOT NULL OR
755: p_x_Line_PAYMENT_rec.CREDIT_CARD_HOLDER_NAME IS NOT NULL)
756: ) -- AND condition added to fix 3098878
757: THEN
758: p_x_Line_PAYMENT_rec.CREDIT_CARD_HOLDER_NAME := FND_API.G_MISS_CHAR;
759: END IF;
760: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_CREDIT_CARD_NUMBER THEN
761: IF (OE_GLOBALS.Is_Same_Credit_Card(p_old_Line_Payment_rec.CREDIT_CARD_NUMBER,
762: p_x_Line_PAYMENT_rec.CREDIT_CARD_NUMBER,p_old_instrument_id,
764: AND (p_old_Line_Payment_rec.header_id IS NOT NULL OR
765: p_x_Line_PAYMENT_rec.CREDIT_CARD_NUMBER IS NOT NULL)
766: ) -- AND condition added to fix 3098878
767: THEN
768: p_x_Line_PAYMENT_rec.CREDIT_CARD_NUMBER := FND_API.G_MISS_CHAR;
769: END IF;
770: --R12 CC Encryption
771: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PAYMENT_LEVEL_CODE THEN
772: p_x_Line_PAYMENT_rec.PAYMENT_LEVEL_CODE := FND_API.G_MISS_CHAR;
768: p_x_Line_PAYMENT_rec.CREDIT_CARD_NUMBER := FND_API.G_MISS_CHAR;
769: END IF;
770: --R12 CC Encryption
771: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PAYMENT_LEVEL_CODE THEN
772: p_x_Line_PAYMENT_rec.PAYMENT_LEVEL_CODE := FND_API.G_MISS_CHAR;
773: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_COMMITMENT_APPLIED_AMOUNT THEN
774: p_x_Line_PAYMENT_rec.COMMITMENT_APPLIED_AMOUNT := FND_API.G_MISS_NUM;
775: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_COMMITMENT_INTERFACED_AMOUNT THEN
776: p_x_Line_PAYMENT_rec.COMMITMENT_INTERFACED_AMOUNT := FND_API.G_MISS_NUM;
770: --R12 CC Encryption
771: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PAYMENT_LEVEL_CODE THEN
772: p_x_Line_PAYMENT_rec.PAYMENT_LEVEL_CODE := FND_API.G_MISS_CHAR;
773: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_COMMITMENT_APPLIED_AMOUNT THEN
774: p_x_Line_PAYMENT_rec.COMMITMENT_APPLIED_AMOUNT := FND_API.G_MISS_NUM;
775: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_COMMITMENT_INTERFACED_AMOUNT THEN
776: p_x_Line_PAYMENT_rec.COMMITMENT_INTERFACED_AMOUNT := FND_API.G_MISS_NUM;
777: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PAYMENT_NUMBER THEN
778: p_x_Line_PAYMENT_rec.PAYMENT_NUMBER := FND_API.G_MISS_NUM;
772: p_x_Line_PAYMENT_rec.PAYMENT_LEVEL_CODE := FND_API.G_MISS_CHAR;
773: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_COMMITMENT_APPLIED_AMOUNT THEN
774: p_x_Line_PAYMENT_rec.COMMITMENT_APPLIED_AMOUNT := FND_API.G_MISS_NUM;
775: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_COMMITMENT_INTERFACED_AMOUNT THEN
776: p_x_Line_PAYMENT_rec.COMMITMENT_INTERFACED_AMOUNT := FND_API.G_MISS_NUM;
777: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PAYMENT_NUMBER THEN
778: p_x_Line_PAYMENT_rec.PAYMENT_NUMBER := FND_API.G_MISS_NUM;
779: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_HEADER THEN
780: p_x_Line_PAYMENT_rec.HEADER_ID := FND_API.G_MISS_NUM;
774: p_x_Line_PAYMENT_rec.COMMITMENT_APPLIED_AMOUNT := FND_API.G_MISS_NUM;
775: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_COMMITMENT_INTERFACED_AMOUNT THEN
776: p_x_Line_PAYMENT_rec.COMMITMENT_INTERFACED_AMOUNT := FND_API.G_MISS_NUM;
777: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PAYMENT_NUMBER THEN
778: p_x_Line_PAYMENT_rec.PAYMENT_NUMBER := FND_API.G_MISS_NUM;
779: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_HEADER THEN
780: p_x_Line_PAYMENT_rec.HEADER_ID := FND_API.G_MISS_NUM;
781: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_LINE THEN
782: p_x_Line_PAYMENT_rec.LINE_ID := FND_API.G_MISS_NUM;
776: p_x_Line_PAYMENT_rec.COMMITMENT_INTERFACED_AMOUNT := FND_API.G_MISS_NUM;
777: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PAYMENT_NUMBER THEN
778: p_x_Line_PAYMENT_rec.PAYMENT_NUMBER := FND_API.G_MISS_NUM;
779: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_HEADER THEN
780: p_x_Line_PAYMENT_rec.HEADER_ID := FND_API.G_MISS_NUM;
781: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_LINE THEN
782: p_x_Line_PAYMENT_rec.LINE_ID := FND_API.G_MISS_NUM;
783: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PAYMENT_AMOUNT THEN
784: p_x_Line_PAYMENT_rec.PAYMENT_AMOUNT := FND_API.G_MISS_NUM;
778: p_x_Line_PAYMENT_rec.PAYMENT_NUMBER := FND_API.G_MISS_NUM;
779: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_HEADER THEN
780: p_x_Line_PAYMENT_rec.HEADER_ID := FND_API.G_MISS_NUM;
781: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_LINE THEN
782: p_x_Line_PAYMENT_rec.LINE_ID := FND_API.G_MISS_NUM;
783: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PAYMENT_AMOUNT THEN
784: p_x_Line_PAYMENT_rec.PAYMENT_AMOUNT := FND_API.G_MISS_NUM;
785: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PAYMENT_COLLECTION_EVENT THEN
786: p_x_Line_PAYMENT_rec.PAYMENT_COLLECTION_EVENT := FND_API.G_MISS_CHAR;
780: p_x_Line_PAYMENT_rec.HEADER_ID := FND_API.G_MISS_NUM;
781: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_LINE THEN
782: p_x_Line_PAYMENT_rec.LINE_ID := FND_API.G_MISS_NUM;
783: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PAYMENT_AMOUNT THEN
784: p_x_Line_PAYMENT_rec.PAYMENT_AMOUNT := FND_API.G_MISS_NUM;
785: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PAYMENT_COLLECTION_EVENT THEN
786: p_x_Line_PAYMENT_rec.PAYMENT_COLLECTION_EVENT := FND_API.G_MISS_CHAR;
787: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PAYMENT_TRX_ID THEN
788: p_x_Line_PAYMENT_rec.PAYMENT_TRX_ID := FND_API.G_MISS_NUM;
782: p_x_Line_PAYMENT_rec.LINE_ID := FND_API.G_MISS_NUM;
783: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PAYMENT_AMOUNT THEN
784: p_x_Line_PAYMENT_rec.PAYMENT_AMOUNT := FND_API.G_MISS_NUM;
785: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PAYMENT_COLLECTION_EVENT THEN
786: p_x_Line_PAYMENT_rec.PAYMENT_COLLECTION_EVENT := FND_API.G_MISS_CHAR;
787: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PAYMENT_TRX_ID THEN
788: p_x_Line_PAYMENT_rec.PAYMENT_TRX_ID := FND_API.G_MISS_NUM;
789: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PAYMENT_TYPE_CODE THEN
790: p_x_Line_PAYMENT_rec.PAYMENT_TYPE_CODE := FND_API.G_MISS_CHAR;
784: p_x_Line_PAYMENT_rec.PAYMENT_AMOUNT := FND_API.G_MISS_NUM;
785: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PAYMENT_COLLECTION_EVENT THEN
786: p_x_Line_PAYMENT_rec.PAYMENT_COLLECTION_EVENT := FND_API.G_MISS_CHAR;
787: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PAYMENT_TRX_ID THEN
788: p_x_Line_PAYMENT_rec.PAYMENT_TRX_ID := FND_API.G_MISS_NUM;
789: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PAYMENT_TYPE_CODE THEN
790: p_x_Line_PAYMENT_rec.PAYMENT_TYPE_CODE := FND_API.G_MISS_CHAR;
791: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PAYMENT_SET_ID THEN
792: p_x_Line_PAYMENT_rec.PAYMENT_SET_ID := FND_API.G_MISS_NUM;
786: p_x_Line_PAYMENT_rec.PAYMENT_COLLECTION_EVENT := FND_API.G_MISS_CHAR;
787: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PAYMENT_TRX_ID THEN
788: p_x_Line_PAYMENT_rec.PAYMENT_TRX_ID := FND_API.G_MISS_NUM;
789: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PAYMENT_TYPE_CODE THEN
790: p_x_Line_PAYMENT_rec.PAYMENT_TYPE_CODE := FND_API.G_MISS_CHAR;
791: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PAYMENT_SET_ID THEN
792: p_x_Line_PAYMENT_rec.PAYMENT_SET_ID := FND_API.G_MISS_NUM;
793: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PREPAID_AMOUNT THEN
794: p_x_Line_PAYMENT_rec.PREPAID_AMOUNT := FND_API.G_MISS_NUM;
788: p_x_Line_PAYMENT_rec.PAYMENT_TRX_ID := FND_API.G_MISS_NUM;
789: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PAYMENT_TYPE_CODE THEN
790: p_x_Line_PAYMENT_rec.PAYMENT_TYPE_CODE := FND_API.G_MISS_CHAR;
791: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PAYMENT_SET_ID THEN
792: p_x_Line_PAYMENT_rec.PAYMENT_SET_ID := FND_API.G_MISS_NUM;
793: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PREPAID_AMOUNT THEN
794: p_x_Line_PAYMENT_rec.PREPAID_AMOUNT := FND_API.G_MISS_NUM;
795: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PROGRAM_APPLICATION_ID THEN
796: p_x_Line_PAYMENT_rec.PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;
790: p_x_Line_PAYMENT_rec.PAYMENT_TYPE_CODE := FND_API.G_MISS_CHAR;
791: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PAYMENT_SET_ID THEN
792: p_x_Line_PAYMENT_rec.PAYMENT_SET_ID := FND_API.G_MISS_NUM;
793: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PREPAID_AMOUNT THEN
794: p_x_Line_PAYMENT_rec.PREPAID_AMOUNT := FND_API.G_MISS_NUM;
795: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PROGRAM_APPLICATION_ID THEN
796: p_x_Line_PAYMENT_rec.PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;
797: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PROGRAM_ID THEN
798: p_x_Line_PAYMENT_rec.PROGRAM_ID := FND_API.G_MISS_NUM;
792: p_x_Line_PAYMENT_rec.PAYMENT_SET_ID := FND_API.G_MISS_NUM;
793: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PREPAID_AMOUNT THEN
794: p_x_Line_PAYMENT_rec.PREPAID_AMOUNT := FND_API.G_MISS_NUM;
795: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PROGRAM_APPLICATION_ID THEN
796: p_x_Line_PAYMENT_rec.PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;
797: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PROGRAM_ID THEN
798: p_x_Line_PAYMENT_rec.PROGRAM_ID := FND_API.G_MISS_NUM;
799: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PROGRAM_UPDATE_DATE THEN
800: p_x_Line_PAYMENT_rec.PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
794: p_x_Line_PAYMENT_rec.PREPAID_AMOUNT := FND_API.G_MISS_NUM;
795: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PROGRAM_APPLICATION_ID THEN
796: p_x_Line_PAYMENT_rec.PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;
797: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PROGRAM_ID THEN
798: p_x_Line_PAYMENT_rec.PROGRAM_ID := FND_API.G_MISS_NUM;
799: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PROGRAM_UPDATE_DATE THEN
800: p_x_Line_PAYMENT_rec.PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
801: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_RECEIPT_METHOD_ID THEN
802: p_x_Line_PAYMENT_rec.RECEIPT_METHOD_ID := FND_API.G_MISS_NUM;
796: p_x_Line_PAYMENT_rec.PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;
797: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PROGRAM_ID THEN
798: p_x_Line_PAYMENT_rec.PROGRAM_ID := FND_API.G_MISS_NUM;
799: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PROGRAM_UPDATE_DATE THEN
800: p_x_Line_PAYMENT_rec.PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
801: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_RECEIPT_METHOD_ID THEN
802: p_x_Line_PAYMENT_rec.RECEIPT_METHOD_ID := FND_API.G_MISS_NUM;
803: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_REQUEST_ID THEN
804: p_x_Line_PAYMENT_rec.REQUEST_ID := FND_API.G_MISS_NUM;
798: p_x_Line_PAYMENT_rec.PROGRAM_ID := FND_API.G_MISS_NUM;
799: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PROGRAM_UPDATE_DATE THEN
800: p_x_Line_PAYMENT_rec.PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
801: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_RECEIPT_METHOD_ID THEN
802: p_x_Line_PAYMENT_rec.RECEIPT_METHOD_ID := FND_API.G_MISS_NUM;
803: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_REQUEST_ID THEN
804: p_x_Line_PAYMENT_rec.REQUEST_ID := FND_API.G_MISS_NUM;
805: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_TANGIBLE_ID THEN
806: p_x_Line_PAYMENT_rec.TANGIBLE_ID := FND_API.G_MISS_CHAR;
800: p_x_Line_PAYMENT_rec.PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
801: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_RECEIPT_METHOD_ID THEN
802: p_x_Line_PAYMENT_rec.RECEIPT_METHOD_ID := FND_API.G_MISS_NUM;
803: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_REQUEST_ID THEN
804: p_x_Line_PAYMENT_rec.REQUEST_ID := FND_API.G_MISS_NUM;
805: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_TANGIBLE_ID THEN
806: p_x_Line_PAYMENT_rec.TANGIBLE_ID := FND_API.G_MISS_CHAR;
807: END IF;
808: END LOOP;
802: p_x_Line_PAYMENT_rec.RECEIPT_METHOD_ID := FND_API.G_MISS_NUM;
803: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_REQUEST_ID THEN
804: p_x_Line_PAYMENT_rec.REQUEST_ID := FND_API.G_MISS_NUM;
805: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_TANGIBLE_ID THEN
806: p_x_Line_PAYMENT_rec.TANGIBLE_ID := FND_API.G_MISS_CHAR;
807: END IF;
808: END LOOP;
809: END IF;
810: END Clear_Dependent_Attr;
809: END IF;
810: END Clear_Dependent_Attr;
811:
812: PROCEDURE Clear_Dependent_Attr
813: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
814: , p_x_Line_Payment_rec IN OUT NOCOPY OE_Order_PUB.Line_Payment_Rec_Type
815: , p_old_Line_Payment_rec IN OE_Order_PUB.Line_Payment_Rec_Type :=
816: OE_Order_PUB.G_MISS_LINE_PAYMENT_REC
817: )
868: l_hold_release_id OE_ORDER_HOLDS.HOLD_RELEASE_ID%TYPE;
869: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
870:
871: BEGIN
872: x_return_status := FND_API.G_RET_STS_SUCCESS;
873:
874: IF l_debug_level > 0 THEN
875: oe_debug_pub.add( 'Entering Delete_Line_PaymentType_Hold' , 3 ) ;
876: END IF;
901: oe_debug_pub.add( 'Exiting Delete_Line_PaymentType_Hold' , 3 ) ;
902: END IF;
903:
904: EXCEPTION
905: WHEN FND_API.G_EXC_ERROR THEN
906: IF (line_paytype_hold%isopen) THEN
907: CLOSE line_paytype_hold;
908: END IF;
909:
906: IF (line_paytype_hold%isopen) THEN
907: CLOSE line_paytype_hold;
908: END IF;
909:
910: x_return_status := FND_API.G_RET_STS_ERROR;
911: FND_MSG_PUB.Count_And_Get
912: ( p_count => x_msg_count
913: , p_data => x_msg_data
914: );
915: WHEN OTHERS THEN
916: IF (line_paytype_hold%isopen) THEN
917: CLOSE line_paytype_hold;
918: END IF;
919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
920: FND_MSG_PUB.Count_And_Get
921: ( p_count => x_msg_count
922: , p_data => x_msg_data
923: );
1251:
1252: --bug3625027 start
1253: BEGIN
1254: -- use order_header cache instead of sql : bug 4200055
1255: if ( OE_Order_Cache.g_header_rec.header_id <> FND_API.G_MISS_NUM
1256: and OE_Order_Cache.g_header_rec.header_id IS NOT NULL
1257: and OE_Order_Cache.g_header_rec.header_id = p_x_Line_Payment_rec.header_id ) then
1258: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
1259: else
1463: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1464: --
1465: BEGIN
1466:
1467: IF p_x_Line_Payment_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1468: p_x_Line_Payment_rec.attribute1 := p_old_Line_Payment_rec.attribute1;
1469: END IF;
1470:
1471: IF p_x_Line_Payment_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1467: IF p_x_Line_Payment_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1468: p_x_Line_Payment_rec.attribute1 := p_old_Line_Payment_rec.attribute1;
1469: END IF;
1470:
1471: IF p_x_Line_Payment_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1472: p_x_Line_Payment_rec.attribute2 := p_old_Line_Payment_rec.attribute2;
1473: END IF;
1474:
1475: IF p_x_Line_Payment_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1471: IF p_x_Line_Payment_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1472: p_x_Line_Payment_rec.attribute2 := p_old_Line_Payment_rec.attribute2;
1473: END IF;
1474:
1475: IF p_x_Line_Payment_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1476: p_x_Line_Payment_rec.attribute3 := p_old_Line_Payment_rec.attribute3;
1477: END IF;
1478:
1479: IF p_x_Line_Payment_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1475: IF p_x_Line_Payment_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1476: p_x_Line_Payment_rec.attribute3 := p_old_Line_Payment_rec.attribute3;
1477: END IF;
1478:
1479: IF p_x_Line_Payment_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1480: p_x_Line_Payment_rec.attribute4 := p_old_Line_Payment_rec.attribute4;
1481: END IF;
1482:
1483: IF p_x_Line_Payment_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1479: IF p_x_Line_Payment_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1480: p_x_Line_Payment_rec.attribute4 := p_old_Line_Payment_rec.attribute4;
1481: END IF;
1482:
1483: IF p_x_Line_Payment_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1484: p_x_Line_Payment_rec.attribute5 := p_old_Line_Payment_rec.attribute5;
1485: END IF;
1486:
1487: IF p_x_Line_Payment_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1483: IF p_x_Line_Payment_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1484: p_x_Line_Payment_rec.attribute5 := p_old_Line_Payment_rec.attribute5;
1485: END IF;
1486:
1487: IF p_x_Line_Payment_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1488: p_x_Line_Payment_rec.attribute6 := p_old_Line_Payment_rec.attribute6;
1489: END IF;
1490:
1491: IF p_x_Line_Payment_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1487: IF p_x_Line_Payment_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1488: p_x_Line_Payment_rec.attribute6 := p_old_Line_Payment_rec.attribute6;
1489: END IF;
1490:
1491: IF p_x_Line_Payment_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1492: p_x_Line_Payment_rec.attribute7 := p_old_Line_Payment_rec.attribute7;
1493: END IF;
1494:
1495: IF p_x_Line_Payment_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1491: IF p_x_Line_Payment_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1492: p_x_Line_Payment_rec.attribute7 := p_old_Line_Payment_rec.attribute7;
1493: END IF;
1494:
1495: IF p_x_Line_Payment_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1496: p_x_Line_Payment_rec.attribute8 := p_old_Line_Payment_rec.attribute8;
1497: END IF;
1498:
1499: IF p_x_Line_Payment_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1495: IF p_x_Line_Payment_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1496: p_x_Line_Payment_rec.attribute8 := p_old_Line_Payment_rec.attribute8;
1497: END IF;
1498:
1499: IF p_x_Line_Payment_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1500: p_x_Line_Payment_rec.attribute9 := p_old_Line_Payment_rec.attribute9;
1501: END IF;
1502:
1503: IF p_x_Line_Payment_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1499: IF p_x_Line_Payment_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1500: p_x_Line_Payment_rec.attribute9 := p_old_Line_Payment_rec.attribute9;
1501: END IF;
1502:
1503: IF p_x_Line_Payment_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1504: p_x_Line_Payment_rec.attribute10 := p_old_Line_Payment_rec.attribute10;
1505: END IF;
1506:
1507: IF p_x_Line_Payment_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1503: IF p_x_Line_Payment_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1504: p_x_Line_Payment_rec.attribute10 := p_old_Line_Payment_rec.attribute10;
1505: END IF;
1506:
1507: IF p_x_Line_Payment_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1508: p_x_Line_Payment_rec.attribute11 := p_old_Line_Payment_rec.attribute11;
1509: END IF;
1510:
1511: IF p_x_Line_Payment_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1507: IF p_x_Line_Payment_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1508: p_x_Line_Payment_rec.attribute11 := p_old_Line_Payment_rec.attribute11;
1509: END IF;
1510:
1511: IF p_x_Line_Payment_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1512: p_x_Line_Payment_rec.attribute12 := p_old_Line_Payment_rec.attribute12;
1513: END IF;
1514:
1515: IF p_x_Line_Payment_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1511: IF p_x_Line_Payment_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1512: p_x_Line_Payment_rec.attribute12 := p_old_Line_Payment_rec.attribute12;
1513: END IF;
1514:
1515: IF p_x_Line_Payment_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1516: p_x_Line_Payment_rec.attribute13 := p_old_Line_Payment_rec.attribute13;
1517: END IF;
1518:
1519: IF p_x_Line_Payment_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1515: IF p_x_Line_Payment_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1516: p_x_Line_Payment_rec.attribute13 := p_old_Line_Payment_rec.attribute13;
1517: END IF;
1518:
1519: IF p_x_Line_Payment_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1520: p_x_Line_Payment_rec.attribute14 := p_old_Line_Payment_rec.attribute14;
1521: END IF;
1522:
1523: IF p_x_Line_Payment_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1519: IF p_x_Line_Payment_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1520: p_x_Line_Payment_rec.attribute14 := p_old_Line_Payment_rec.attribute14;
1521: END IF;
1522:
1523: IF p_x_Line_Payment_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1524: p_x_Line_Payment_rec.attribute15 := p_old_Line_Payment_rec.attribute15;
1525: END IF;
1526:
1527: IF p_x_Line_Payment_rec.context = FND_API.G_MISS_CHAR THEN
1523: IF p_x_Line_Payment_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1524: p_x_Line_Payment_rec.attribute15 := p_old_Line_Payment_rec.attribute15;
1525: END IF;
1526:
1527: IF p_x_Line_Payment_rec.context = FND_API.G_MISS_CHAR THEN
1528: p_x_Line_Payment_rec.context := p_old_Line_Payment_rec.context;
1529: END IF;
1530:
1531: IF p_x_Line_Payment_rec.created_by = FND_API.G_MISS_NUM THEN
1527: IF p_x_Line_Payment_rec.context = FND_API.G_MISS_CHAR THEN
1528: p_x_Line_Payment_rec.context := p_old_Line_Payment_rec.context;
1529: END IF;
1530:
1531: IF p_x_Line_Payment_rec.created_by = FND_API.G_MISS_NUM THEN
1532: p_x_Line_Payment_rec.created_by := p_old_Line_Payment_rec.created_by;
1533: END IF;
1534:
1535: IF p_x_Line_Payment_rec.creation_date = FND_API.G_MISS_DATE THEN
1531: IF p_x_Line_Payment_rec.created_by = FND_API.G_MISS_NUM THEN
1532: p_x_Line_Payment_rec.created_by := p_old_Line_Payment_rec.created_by;
1533: END IF;
1534:
1535: IF p_x_Line_Payment_rec.creation_date = FND_API.G_MISS_DATE THEN
1536: p_x_Line_Payment_rec.creation_date := p_old_Line_Payment_rec.creation_date;
1537: END IF;
1538:
1539: IF p_x_Line_Payment_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1535: IF p_x_Line_Payment_rec.creation_date = FND_API.G_MISS_DATE THEN
1536: p_x_Line_Payment_rec.creation_date := p_old_Line_Payment_rec.creation_date;
1537: END IF;
1538:
1539: IF p_x_Line_Payment_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1540: p_x_Line_Payment_rec.last_updated_by := p_old_Line_Payment_rec.last_updated_by;
1541: END IF;
1542:
1543: IF p_x_Line_Payment_rec.last_update_date = FND_API.G_MISS_DATE THEN
1539: IF p_x_Line_Payment_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1540: p_x_Line_Payment_rec.last_updated_by := p_old_Line_Payment_rec.last_updated_by;
1541: END IF;
1542:
1543: IF p_x_Line_Payment_rec.last_update_date = FND_API.G_MISS_DATE THEN
1544: p_x_Line_Payment_rec.last_update_date := p_old_Line_Payment_rec.last_update_date;
1545: END IF;
1546:
1547: IF p_x_Line_Payment_rec.last_update_login = FND_API.G_MISS_NUM THEN
1543: IF p_x_Line_Payment_rec.last_update_date = FND_API.G_MISS_DATE THEN
1544: p_x_Line_Payment_rec.last_update_date := p_old_Line_Payment_rec.last_update_date;
1545: END IF;
1546:
1547: IF p_x_Line_Payment_rec.last_update_login = FND_API.G_MISS_NUM THEN
1548: p_x_Line_Payment_rec.last_update_login := p_old_Line_Payment_rec.last_update_login;
1549: END IF;
1550:
1551: IF p_x_Line_Payment_rec.check_number = FND_API.G_MISS_CHAR THEN
1547: IF p_x_Line_Payment_rec.last_update_login = FND_API.G_MISS_NUM THEN
1548: p_x_Line_Payment_rec.last_update_login := p_old_Line_Payment_rec.last_update_login;
1549: END IF;
1550:
1551: IF p_x_Line_Payment_rec.check_number = FND_API.G_MISS_CHAR THEN
1552: p_x_Line_Payment_rec.check_number := p_old_Line_Payment_rec.check_number;
1553: END IF;
1554:
1555: IF p_x_Line_Payment_rec.credit_card_approval_code = FND_API.G_MISS_CHAR THEN
1551: IF p_x_Line_Payment_rec.check_number = FND_API.G_MISS_CHAR THEN
1552: p_x_Line_Payment_rec.check_number := p_old_Line_Payment_rec.check_number;
1553: END IF;
1554:
1555: IF p_x_Line_Payment_rec.credit_card_approval_code = FND_API.G_MISS_CHAR THEN
1556: p_x_Line_Payment_rec.credit_card_approval_code := p_old_Line_Payment_rec.credit_card_approval_code;
1557: END IF;
1558:
1559: IF p_x_Line_Payment_rec.credit_card_approval_date = FND_API.G_MISS_DATE THEN
1555: IF p_x_Line_Payment_rec.credit_card_approval_code = FND_API.G_MISS_CHAR THEN
1556: p_x_Line_Payment_rec.credit_card_approval_code := p_old_Line_Payment_rec.credit_card_approval_code;
1557: END IF;
1558:
1559: IF p_x_Line_Payment_rec.credit_card_approval_date = FND_API.G_MISS_DATE THEN
1560: p_x_Line_Payment_rec.credit_card_approval_date := p_old_Line_Payment_rec.credit_card_approval_date;
1561: END IF;
1562:
1563: IF p_x_Line_Payment_rec.credit_card_code = FND_API.G_MISS_CHAR THEN
1559: IF p_x_Line_Payment_rec.credit_card_approval_date = FND_API.G_MISS_DATE THEN
1560: p_x_Line_Payment_rec.credit_card_approval_date := p_old_Line_Payment_rec.credit_card_approval_date;
1561: END IF;
1562:
1563: IF p_x_Line_Payment_rec.credit_card_code = FND_API.G_MISS_CHAR THEN
1564: p_x_Line_Payment_rec.credit_card_code := p_old_Line_Payment_rec.credit_card_code;
1565: END IF;
1566:
1567: IF p_x_Line_Payment_rec.credit_card_expiration_date = FND_API.G_MISS_DATE THEN
1563: IF p_x_Line_Payment_rec.credit_card_code = FND_API.G_MISS_CHAR THEN
1564: p_x_Line_Payment_rec.credit_card_code := p_old_Line_Payment_rec.credit_card_code;
1565: END IF;
1566:
1567: IF p_x_Line_Payment_rec.credit_card_expiration_date = FND_API.G_MISS_DATE THEN
1568: p_x_Line_Payment_rec.credit_card_expiration_date := p_old_Line_Payment_rec.credit_card_expiration_date;
1569: END IF;
1570:
1571: IF p_x_Line_Payment_rec.credit_card_holder_name = FND_API.G_MISS_CHAR THEN
1567: IF p_x_Line_Payment_rec.credit_card_expiration_date = FND_API.G_MISS_DATE THEN
1568: p_x_Line_Payment_rec.credit_card_expiration_date := p_old_Line_Payment_rec.credit_card_expiration_date;
1569: END IF;
1570:
1571: IF p_x_Line_Payment_rec.credit_card_holder_name = FND_API.G_MISS_CHAR THEN
1572: p_x_Line_Payment_rec.credit_card_holder_name := p_old_Line_Payment_rec.credit_card_holder_name;
1573: END IF;
1574:
1575: IF p_x_Line_Payment_rec.credit_card_number = FND_API.G_MISS_CHAR THEN
1571: IF p_x_Line_Payment_rec.credit_card_holder_name = FND_API.G_MISS_CHAR THEN
1572: p_x_Line_Payment_rec.credit_card_holder_name := p_old_Line_Payment_rec.credit_card_holder_name;
1573: END IF;
1574:
1575: IF p_x_Line_Payment_rec.credit_card_number = FND_API.G_MISS_CHAR THEN
1576: p_x_Line_Payment_rec.credit_card_number := p_old_Line_Payment_rec.credit_card_number;
1577: END IF;
1578:
1579: IF p_x_Line_Payment_rec.payment_level_code = FND_API.G_MISS_CHAR THEN
1575: IF p_x_Line_Payment_rec.credit_card_number = FND_API.G_MISS_CHAR THEN
1576: p_x_Line_Payment_rec.credit_card_number := p_old_Line_Payment_rec.credit_card_number;
1577: END IF;
1578:
1579: IF p_x_Line_Payment_rec.payment_level_code = FND_API.G_MISS_CHAR THEN
1580: p_x_Line_Payment_rec.payment_level_code := p_old_Line_Payment_rec.payment_level_code;
1581: END IF;
1582:
1583: IF p_x_Line_Payment_rec.commitment_applied_amount = FND_API.G_MISS_NUM THEN
1579: IF p_x_Line_Payment_rec.payment_level_code = FND_API.G_MISS_CHAR THEN
1580: p_x_Line_Payment_rec.payment_level_code := p_old_Line_Payment_rec.payment_level_code;
1581: END IF;
1582:
1583: IF p_x_Line_Payment_rec.commitment_applied_amount = FND_API.G_MISS_NUM THEN
1584: p_x_Line_Payment_rec.commitment_applied_amount := p_old_Line_Payment_rec.commitment_applied_amount;
1585: END IF;
1586:
1587: IF p_x_Line_Payment_rec.commitment_interfaced_amount = FND_API.G_MISS_NUM THEN
1583: IF p_x_Line_Payment_rec.commitment_applied_amount = FND_API.G_MISS_NUM THEN
1584: p_x_Line_Payment_rec.commitment_applied_amount := p_old_Line_Payment_rec.commitment_applied_amount;
1585: END IF;
1586:
1587: IF p_x_Line_Payment_rec.commitment_interfaced_amount = FND_API.G_MISS_NUM THEN
1588: p_x_Line_Payment_rec.commitment_interfaced_amount := p_old_Line_Payment_rec.commitment_interfaced_amount;
1589: END IF;
1590:
1591: IF p_x_Line_Payment_rec.payment_number = FND_API.G_MISS_NUM THEN
1587: IF p_x_Line_Payment_rec.commitment_interfaced_amount = FND_API.G_MISS_NUM THEN
1588: p_x_Line_Payment_rec.commitment_interfaced_amount := p_old_Line_Payment_rec.commitment_interfaced_amount;
1589: END IF;
1590:
1591: IF p_x_Line_Payment_rec.payment_number = FND_API.G_MISS_NUM THEN
1592: p_x_Line_Payment_rec.payment_number := p_old_Line_Payment_rec.payment_number;
1593: END IF;
1594:
1595: IF p_x_Line_Payment_rec.header_id = FND_API.G_MISS_NUM THEN
1591: IF p_x_Line_Payment_rec.payment_number = FND_API.G_MISS_NUM THEN
1592: p_x_Line_Payment_rec.payment_number := p_old_Line_Payment_rec.payment_number;
1593: END IF;
1594:
1595: IF p_x_Line_Payment_rec.header_id = FND_API.G_MISS_NUM THEN
1596: p_x_Line_Payment_rec.header_id := p_old_Line_Payment_rec.header_id;
1597: END IF;
1598:
1599: IF p_x_Line_Payment_rec.line_id = FND_API.G_MISS_NUM THEN
1595: IF p_x_Line_Payment_rec.header_id = FND_API.G_MISS_NUM THEN
1596: p_x_Line_Payment_rec.header_id := p_old_Line_Payment_rec.header_id;
1597: END IF;
1598:
1599: IF p_x_Line_Payment_rec.line_id = FND_API.G_MISS_NUM THEN
1600: p_x_Line_Payment_rec.line_id := p_old_Line_Payment_rec.line_id;
1601: END IF;
1602:
1603: IF p_x_Line_Payment_rec.payment_amount = FND_API.G_MISS_NUM THEN
1599: IF p_x_Line_Payment_rec.line_id = FND_API.G_MISS_NUM THEN
1600: p_x_Line_Payment_rec.line_id := p_old_Line_Payment_rec.line_id;
1601: END IF;
1602:
1603: IF p_x_Line_Payment_rec.payment_amount = FND_API.G_MISS_NUM THEN
1604: p_x_Line_Payment_rec.payment_amount := p_old_Line_Payment_rec.payment_amount;
1605: END IF;
1606:
1607: IF p_x_Line_Payment_rec.payment_collection_event = FND_API.G_MISS_CHAR THEN
1603: IF p_x_Line_Payment_rec.payment_amount = FND_API.G_MISS_NUM THEN
1604: p_x_Line_Payment_rec.payment_amount := p_old_Line_Payment_rec.payment_amount;
1605: END IF;
1606:
1607: IF p_x_Line_Payment_rec.payment_collection_event = FND_API.G_MISS_CHAR THEN
1608: p_x_Line_Payment_rec.payment_collection_event := p_old_Line_Payment_rec.payment_collection_event;
1609: END IF;
1610:
1611: IF p_x_Line_Payment_rec.defer_payment_processing_flag = FND_API.G_MISS_CHAR THEN
1607: IF p_x_Line_Payment_rec.payment_collection_event = FND_API.G_MISS_CHAR THEN
1608: p_x_Line_Payment_rec.payment_collection_event := p_old_Line_Payment_rec.payment_collection_event;
1609: END IF;
1610:
1611: IF p_x_Line_Payment_rec.defer_payment_processing_flag = FND_API.G_MISS_CHAR THEN
1612: p_x_Line_Payment_rec.defer_payment_processing_flag := p_old_Line_Payment_rec.defer_payment_processing_flag;
1613: END IF;
1614:
1615: IF p_x_Line_Payment_rec.payment_trx_id = FND_API.G_MISS_NUM THEN
1611: IF p_x_Line_Payment_rec.defer_payment_processing_flag = FND_API.G_MISS_CHAR THEN
1612: p_x_Line_Payment_rec.defer_payment_processing_flag := p_old_Line_Payment_rec.defer_payment_processing_flag;
1613: END IF;
1614:
1615: IF p_x_Line_Payment_rec.payment_trx_id = FND_API.G_MISS_NUM THEN
1616: p_x_Line_Payment_rec.payment_trx_id := p_old_Line_Payment_rec.payment_trx_id;
1617: END IF;
1618:
1619: IF p_x_Line_Payment_rec.payment_type_code = FND_API.G_MISS_CHAR THEN
1615: IF p_x_Line_Payment_rec.payment_trx_id = FND_API.G_MISS_NUM THEN
1616: p_x_Line_Payment_rec.payment_trx_id := p_old_Line_Payment_rec.payment_trx_id;
1617: END IF;
1618:
1619: IF p_x_Line_Payment_rec.payment_type_code = FND_API.G_MISS_CHAR THEN
1620: p_x_Line_Payment_rec.payment_type_code := p_old_Line_Payment_rec.payment_type_code;
1621: END IF;
1622:
1623: IF p_x_Line_Payment_rec.payment_set_id = FND_API.G_MISS_NUM THEN
1619: IF p_x_Line_Payment_rec.payment_type_code = FND_API.G_MISS_CHAR THEN
1620: p_x_Line_Payment_rec.payment_type_code := p_old_Line_Payment_rec.payment_type_code;
1621: END IF;
1622:
1623: IF p_x_Line_Payment_rec.payment_set_id = FND_API.G_MISS_NUM THEN
1624: p_x_Line_Payment_rec.payment_set_id := p_old_Line_Payment_rec.payment_set_id;
1625: END IF;
1626:
1627: IF p_x_Line_Payment_rec.prepaid_amount = FND_API.G_MISS_NUM THEN
1623: IF p_x_Line_Payment_rec.payment_set_id = FND_API.G_MISS_NUM THEN
1624: p_x_Line_Payment_rec.payment_set_id := p_old_Line_Payment_rec.payment_set_id;
1625: END IF;
1626:
1627: IF p_x_Line_Payment_rec.prepaid_amount = FND_API.G_MISS_NUM THEN
1628: p_x_Line_Payment_rec.prepaid_amount := p_old_Line_Payment_rec.prepaid_amount;
1629: END IF;
1630:
1631: IF p_x_Line_Payment_rec.program_application_id = FND_API.G_MISS_NUM THEN
1627: IF p_x_Line_Payment_rec.prepaid_amount = FND_API.G_MISS_NUM THEN
1628: p_x_Line_Payment_rec.prepaid_amount := p_old_Line_Payment_rec.prepaid_amount;
1629: END IF;
1630:
1631: IF p_x_Line_Payment_rec.program_application_id = FND_API.G_MISS_NUM THEN
1632: p_x_Line_Payment_rec.program_application_id := p_old_Line_Payment_rec.program_application_id;
1633: END IF;
1634:
1635: IF p_x_Line_Payment_rec.program_id = FND_API.G_MISS_NUM THEN
1631: IF p_x_Line_Payment_rec.program_application_id = FND_API.G_MISS_NUM THEN
1632: p_x_Line_Payment_rec.program_application_id := p_old_Line_Payment_rec.program_application_id;
1633: END IF;
1634:
1635: IF p_x_Line_Payment_rec.program_id = FND_API.G_MISS_NUM THEN
1636: p_x_Line_Payment_rec.program_id := p_old_Line_Payment_rec.program_id;
1637: END IF;
1638:
1639: IF p_x_Line_Payment_rec.program_update_date = FND_API.G_MISS_DATE THEN
1635: IF p_x_Line_Payment_rec.program_id = FND_API.G_MISS_NUM THEN
1636: p_x_Line_Payment_rec.program_id := p_old_Line_Payment_rec.program_id;
1637: END IF;
1638:
1639: IF p_x_Line_Payment_rec.program_update_date = FND_API.G_MISS_DATE THEN
1640: p_x_Line_Payment_rec.program_update_date := p_old_Line_Payment_rec.program_update_date;
1641: END IF;
1642:
1643: IF p_x_Line_Payment_rec.receipt_method_id = FND_API.G_MISS_NUM THEN
1639: IF p_x_Line_Payment_rec.program_update_date = FND_API.G_MISS_DATE THEN
1640: p_x_Line_Payment_rec.program_update_date := p_old_Line_Payment_rec.program_update_date;
1641: END IF;
1642:
1643: IF p_x_Line_Payment_rec.receipt_method_id = FND_API.G_MISS_NUM THEN
1644: p_x_Line_Payment_rec.receipt_method_id := p_old_Line_Payment_rec.receipt_method_id;
1645: END IF;
1646:
1647: IF p_x_Line_Payment_rec.request_id = FND_API.G_MISS_NUM THEN
1643: IF p_x_Line_Payment_rec.receipt_method_id = FND_API.G_MISS_NUM THEN
1644: p_x_Line_Payment_rec.receipt_method_id := p_old_Line_Payment_rec.receipt_method_id;
1645: END IF;
1646:
1647: IF p_x_Line_Payment_rec.request_id = FND_API.G_MISS_NUM THEN
1648: p_x_Line_Payment_rec.request_id := p_old_Line_Payment_rec.request_id;
1649: END IF;
1650:
1651: IF p_x_Line_Payment_rec.tangible_id = FND_API.G_MISS_CHAR THEN
1647: IF p_x_Line_Payment_rec.request_id = FND_API.G_MISS_NUM THEN
1648: p_x_Line_Payment_rec.request_id := p_old_Line_Payment_rec.request_id;
1649: END IF;
1650:
1651: IF p_x_Line_Payment_rec.tangible_id = FND_API.G_MISS_CHAR THEN
1652: p_x_Line_Payment_rec.tangible_id := p_old_Line_Payment_rec.tangible_id;
1653: END IF;
1654:
1655: IF p_x_Line_Payment_rec.trxn_extension_id = FND_API.G_MISS_NUM THEN
1651: IF p_x_Line_Payment_rec.tangible_id = FND_API.G_MISS_CHAR THEN
1652: p_x_Line_Payment_rec.tangible_id := p_old_Line_Payment_rec.tangible_id;
1653: END IF;
1654:
1655: IF p_x_Line_Payment_rec.trxn_extension_id = FND_API.G_MISS_NUM THEN
1656: p_x_Line_Payment_rec.trxn_extension_id := p_old_Line_Payment_rec.trxn_extension_id;
1657: END IF;
1658:
1659: -- R12 CC Encryption
1656: p_x_Line_Payment_rec.trxn_extension_id := p_old_Line_Payment_rec.trxn_extension_id;
1657: END IF;
1658:
1659: -- R12 CC Encryption
1660: IF p_x_Line_Payment_rec.trxn_extension_id = FND_API.G_MISS_NUM THEN
1661: p_x_Line_Payment_rec.trxn_extension_id := p_old_Line_Payment_rec.trxn_extension_id;
1662: END IF;
1663:
1664: IF p_x_Line_Payment_rec.instrument_security_code = FND_API.G_MISS_CHAR THEN
1660: IF p_x_Line_Payment_rec.trxn_extension_id = FND_API.G_MISS_NUM THEN
1661: p_x_Line_Payment_rec.trxn_extension_id := p_old_Line_Payment_rec.trxn_extension_id;
1662: END IF;
1663:
1664: IF p_x_Line_Payment_rec.instrument_security_code = FND_API.G_MISS_CHAR THEN
1665: p_x_Line_Payment_rec.instrument_security_code := p_old_Line_Payment_rec.instrument_security_code;
1666: END IF;
1667:
1668: -- R12 CC Encryption
1680: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1681: --
1682: BEGIN
1683:
1684: IF p_x_Line_Payment_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1685: p_x_Line_Payment_rec.attribute1 := NULL;
1686: END IF;
1687:
1688: IF p_x_Line_Payment_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1684: IF p_x_Line_Payment_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1685: p_x_Line_Payment_rec.attribute1 := NULL;
1686: END IF;
1687:
1688: IF p_x_Line_Payment_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1689: p_x_Line_Payment_rec.attribute2 := NULL;
1690: END IF;
1691:
1692: IF p_x_Line_Payment_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1688: IF p_x_Line_Payment_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1689: p_x_Line_Payment_rec.attribute2 := NULL;
1690: END IF;
1691:
1692: IF p_x_Line_Payment_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1693: p_x_Line_Payment_rec.attribute3 := NULL;
1694: END IF;
1695:
1696: IF p_x_Line_Payment_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1692: IF p_x_Line_Payment_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1693: p_x_Line_Payment_rec.attribute3 := NULL;
1694: END IF;
1695:
1696: IF p_x_Line_Payment_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1697: p_x_Line_Payment_rec.attribute4 := NULL;
1698: END IF;
1699:
1700: IF p_x_Line_Payment_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1696: IF p_x_Line_Payment_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1697: p_x_Line_Payment_rec.attribute4 := NULL;
1698: END IF;
1699:
1700: IF p_x_Line_Payment_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1701: p_x_Line_Payment_rec.attribute5 := NULL;
1702: END IF;
1703:
1704: IF p_x_Line_Payment_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1700: IF p_x_Line_Payment_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1701: p_x_Line_Payment_rec.attribute5 := NULL;
1702: END IF;
1703:
1704: IF p_x_Line_Payment_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1705: p_x_Line_Payment_rec.attribute6 := NULL;
1706: END IF;
1707:
1708: IF p_x_Line_Payment_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1704: IF p_x_Line_Payment_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1705: p_x_Line_Payment_rec.attribute6 := NULL;
1706: END IF;
1707:
1708: IF p_x_Line_Payment_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1709: p_x_Line_Payment_rec.attribute7 := NULL;
1710: END IF;
1711:
1712: IF p_x_Line_Payment_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1708: IF p_x_Line_Payment_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1709: p_x_Line_Payment_rec.attribute7 := NULL;
1710: END IF;
1711:
1712: IF p_x_Line_Payment_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1713: p_x_Line_Payment_rec.attribute8 := NULL;
1714: END IF;
1715:
1716: IF p_x_Line_Payment_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1712: IF p_x_Line_Payment_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1713: p_x_Line_Payment_rec.attribute8 := NULL;
1714: END IF;
1715:
1716: IF p_x_Line_Payment_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1717: p_x_Line_Payment_rec.attribute9 := NULL;
1718: END IF;
1719:
1720: IF p_x_Line_Payment_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1716: IF p_x_Line_Payment_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1717: p_x_Line_Payment_rec.attribute9 := NULL;
1718: END IF;
1719:
1720: IF p_x_Line_Payment_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1721: p_x_Line_Payment_rec.attribute10 := NULL;
1722: END IF;
1723:
1724: IF p_x_Line_Payment_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1720: IF p_x_Line_Payment_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1721: p_x_Line_Payment_rec.attribute10 := NULL;
1722: END IF;
1723:
1724: IF p_x_Line_Payment_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1725: p_x_Line_Payment_rec.attribute11 := NULL;
1726: END IF;
1727:
1728: IF p_x_Line_Payment_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1724: IF p_x_Line_Payment_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1725: p_x_Line_Payment_rec.attribute11 := NULL;
1726: END IF;
1727:
1728: IF p_x_Line_Payment_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1729: p_x_Line_Payment_rec.attribute12 := NULL;
1730: END IF;
1731:
1732: IF p_x_Line_Payment_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1728: IF p_x_Line_Payment_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1729: p_x_Line_Payment_rec.attribute12 := NULL;
1730: END IF;
1731:
1732: IF p_x_Line_Payment_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1733: p_x_Line_Payment_rec.attribute13 := NULL;
1734: END IF;
1735:
1736: IF p_x_Line_Payment_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1732: IF p_x_Line_Payment_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1733: p_x_Line_Payment_rec.attribute13 := NULL;
1734: END IF;
1735:
1736: IF p_x_Line_Payment_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1737: p_x_Line_Payment_rec.attribute14 := NULL;
1738: END IF;
1739:
1740: IF p_x_Line_Payment_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1736: IF p_x_Line_Payment_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1737: p_x_Line_Payment_rec.attribute14 := NULL;
1738: END IF;
1739:
1740: IF p_x_Line_Payment_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1741: p_x_Line_Payment_rec.attribute15 := NULL;
1742: END IF;
1743:
1744: IF p_x_Line_Payment_rec.context = FND_API.G_MISS_CHAR THEN
1740: IF p_x_Line_Payment_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1741: p_x_Line_Payment_rec.attribute15 := NULL;
1742: END IF;
1743:
1744: IF p_x_Line_Payment_rec.context = FND_API.G_MISS_CHAR THEN
1745: p_x_Line_Payment_rec.context := NULL;
1746: END IF;
1747:
1748: IF p_x_Line_Payment_rec.created_by = FND_API.G_MISS_NUM THEN
1744: IF p_x_Line_Payment_rec.context = FND_API.G_MISS_CHAR THEN
1745: p_x_Line_Payment_rec.context := NULL;
1746: END IF;
1747:
1748: IF p_x_Line_Payment_rec.created_by = FND_API.G_MISS_NUM THEN
1749: p_x_Line_Payment_rec.created_by := NULL;
1750: END IF;
1751:
1752: IF p_x_Line_Payment_rec.creation_date = FND_API.G_MISS_DATE THEN
1748: IF p_x_Line_Payment_rec.created_by = FND_API.G_MISS_NUM THEN
1749: p_x_Line_Payment_rec.created_by := NULL;
1750: END IF;
1751:
1752: IF p_x_Line_Payment_rec.creation_date = FND_API.G_MISS_DATE THEN
1753: p_x_Line_Payment_rec.creation_date := NULL;
1754: END IF;
1755:
1756: IF p_x_Line_Payment_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1752: IF p_x_Line_Payment_rec.creation_date = FND_API.G_MISS_DATE THEN
1753: p_x_Line_Payment_rec.creation_date := NULL;
1754: END IF;
1755:
1756: IF p_x_Line_Payment_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1757: p_x_Line_Payment_rec.last_updated_by := NULL;
1758: END IF;
1759:
1760: IF p_x_Line_Payment_rec.last_update_date = FND_API.G_MISS_DATE THEN
1756: IF p_x_Line_Payment_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1757: p_x_Line_Payment_rec.last_updated_by := NULL;
1758: END IF;
1759:
1760: IF p_x_Line_Payment_rec.last_update_date = FND_API.G_MISS_DATE THEN
1761: p_x_Line_Payment_rec.last_update_date := NULL;
1762: END IF;
1763:
1764: IF p_x_Line_Payment_rec.last_update_login = FND_API.G_MISS_NUM THEN
1760: IF p_x_Line_Payment_rec.last_update_date = FND_API.G_MISS_DATE THEN
1761: p_x_Line_Payment_rec.last_update_date := NULL;
1762: END IF;
1763:
1764: IF p_x_Line_Payment_rec.last_update_login = FND_API.G_MISS_NUM THEN
1765: p_x_Line_Payment_rec.last_update_login := NULL;
1766: END IF;
1767:
1768: IF p_x_Line_Payment_rec.check_number = FND_API.G_MISS_CHAR THEN
1764: IF p_x_Line_Payment_rec.last_update_login = FND_API.G_MISS_NUM THEN
1765: p_x_Line_Payment_rec.last_update_login := NULL;
1766: END IF;
1767:
1768: IF p_x_Line_Payment_rec.check_number = FND_API.G_MISS_CHAR THEN
1769: p_x_Line_Payment_rec.check_number := NULL;
1770: END IF;
1771:
1772: IF p_x_Line_Payment_rec.credit_card_approval_code = FND_API.G_MISS_CHAR THEN
1768: IF p_x_Line_Payment_rec.check_number = FND_API.G_MISS_CHAR THEN
1769: p_x_Line_Payment_rec.check_number := NULL;
1770: END IF;
1771:
1772: IF p_x_Line_Payment_rec.credit_card_approval_code = FND_API.G_MISS_CHAR THEN
1773: p_x_Line_Payment_rec.credit_card_approval_code := NULL;
1774: END IF;
1775:
1776: IF p_x_Line_Payment_rec.credit_card_approval_date = FND_API.G_MISS_DATE THEN
1772: IF p_x_Line_Payment_rec.credit_card_approval_code = FND_API.G_MISS_CHAR THEN
1773: p_x_Line_Payment_rec.credit_card_approval_code := NULL;
1774: END IF;
1775:
1776: IF p_x_Line_Payment_rec.credit_card_approval_date = FND_API.G_MISS_DATE THEN
1777: p_x_Line_Payment_rec.credit_card_approval_date := NULL;
1778: END IF;
1779:
1780: IF p_x_Line_Payment_rec.credit_card_code = FND_API.G_MISS_CHAR THEN
1776: IF p_x_Line_Payment_rec.credit_card_approval_date = FND_API.G_MISS_DATE THEN
1777: p_x_Line_Payment_rec.credit_card_approval_date := NULL;
1778: END IF;
1779:
1780: IF p_x_Line_Payment_rec.credit_card_code = FND_API.G_MISS_CHAR THEN
1781: p_x_Line_Payment_rec.credit_card_code := NULL;
1782: END IF;
1783:
1784: IF p_x_Line_Payment_rec.credit_card_expiration_date = FND_API.G_MISS_DATE THEN
1780: IF p_x_Line_Payment_rec.credit_card_code = FND_API.G_MISS_CHAR THEN
1781: p_x_Line_Payment_rec.credit_card_code := NULL;
1782: END IF;
1783:
1784: IF p_x_Line_Payment_rec.credit_card_expiration_date = FND_API.G_MISS_DATE THEN
1785: p_x_Line_Payment_rec.credit_card_expiration_date := NULL;
1786: END IF;
1787:
1788: IF p_x_Line_Payment_rec.credit_card_holder_name = FND_API.G_MISS_CHAR THEN
1784: IF p_x_Line_Payment_rec.credit_card_expiration_date = FND_API.G_MISS_DATE THEN
1785: p_x_Line_Payment_rec.credit_card_expiration_date := NULL;
1786: END IF;
1787:
1788: IF p_x_Line_Payment_rec.credit_card_holder_name = FND_API.G_MISS_CHAR THEN
1789: p_x_Line_Payment_rec.credit_card_holder_name := NULL;
1790: END IF;
1791:
1792: IF p_x_Line_Payment_rec.credit_card_number = FND_API.G_MISS_CHAR THEN
1788: IF p_x_Line_Payment_rec.credit_card_holder_name = FND_API.G_MISS_CHAR THEN
1789: p_x_Line_Payment_rec.credit_card_holder_name := NULL;
1790: END IF;
1791:
1792: IF p_x_Line_Payment_rec.credit_card_number = FND_API.G_MISS_CHAR THEN
1793: p_x_Line_Payment_rec.credit_card_number := NULL;
1794: END IF;
1795:
1796: IF p_x_Line_Payment_rec.payment_level_code = FND_API.G_MISS_CHAR THEN
1792: IF p_x_Line_Payment_rec.credit_card_number = FND_API.G_MISS_CHAR THEN
1793: p_x_Line_Payment_rec.credit_card_number := NULL;
1794: END IF;
1795:
1796: IF p_x_Line_Payment_rec.payment_level_code = FND_API.G_MISS_CHAR THEN
1797: p_x_Line_Payment_rec.payment_level_code := NULL;
1798: END IF;
1799:
1800: IF p_x_Line_Payment_rec.commitment_applied_amount = FND_API.G_MISS_NUM THEN
1796: IF p_x_Line_Payment_rec.payment_level_code = FND_API.G_MISS_CHAR THEN
1797: p_x_Line_Payment_rec.payment_level_code := NULL;
1798: END IF;
1799:
1800: IF p_x_Line_Payment_rec.commitment_applied_amount = FND_API.G_MISS_NUM THEN
1801: p_x_Line_Payment_rec.commitment_applied_amount := NULL;
1802: END IF;
1803:
1804: IF p_x_Line_Payment_rec.commitment_interfaced_amount = FND_API.G_MISS_NUM THEN
1800: IF p_x_Line_Payment_rec.commitment_applied_amount = FND_API.G_MISS_NUM THEN
1801: p_x_Line_Payment_rec.commitment_applied_amount := NULL;
1802: END IF;
1803:
1804: IF p_x_Line_Payment_rec.commitment_interfaced_amount = FND_API.G_MISS_NUM THEN
1805: p_x_Line_Payment_rec.commitment_interfaced_amount := NULL;
1806: END IF;
1807:
1808: IF p_x_Line_Payment_rec.payment_number = FND_API.G_MISS_NUM THEN
1804: IF p_x_Line_Payment_rec.commitment_interfaced_amount = FND_API.G_MISS_NUM THEN
1805: p_x_Line_Payment_rec.commitment_interfaced_amount := NULL;
1806: END IF;
1807:
1808: IF p_x_Line_Payment_rec.payment_number = FND_API.G_MISS_NUM THEN
1809: p_x_Line_Payment_rec.payment_number := NULL;
1810: END IF;
1811:
1812: IF p_x_Line_Payment_rec.header_id = FND_API.G_MISS_NUM THEN
1808: IF p_x_Line_Payment_rec.payment_number = FND_API.G_MISS_NUM THEN
1809: p_x_Line_Payment_rec.payment_number := NULL;
1810: END IF;
1811:
1812: IF p_x_Line_Payment_rec.header_id = FND_API.G_MISS_NUM THEN
1813: p_x_Line_Payment_rec.header_id := NULL;
1814: END IF;
1815:
1816: IF p_x_Line_Payment_rec.line_id = FND_API.G_MISS_NUM THEN
1812: IF p_x_Line_Payment_rec.header_id = FND_API.G_MISS_NUM THEN
1813: p_x_Line_Payment_rec.header_id := NULL;
1814: END IF;
1815:
1816: IF p_x_Line_Payment_rec.line_id = FND_API.G_MISS_NUM THEN
1817: p_x_Line_Payment_rec.line_id := NULL;
1818: END IF;
1819:
1820: IF p_x_Line_Payment_rec.payment_amount = FND_API.G_MISS_NUM THEN
1816: IF p_x_Line_Payment_rec.line_id = FND_API.G_MISS_NUM THEN
1817: p_x_Line_Payment_rec.line_id := NULL;
1818: END IF;
1819:
1820: IF p_x_Line_Payment_rec.payment_amount = FND_API.G_MISS_NUM THEN
1821: p_x_Line_Payment_rec.payment_amount := NULL;
1822: END IF;
1823:
1824: IF p_x_Line_Payment_rec.payment_collection_event = FND_API.G_MISS_CHAR THEN
1820: IF p_x_Line_Payment_rec.payment_amount = FND_API.G_MISS_NUM THEN
1821: p_x_Line_Payment_rec.payment_amount := NULL;
1822: END IF;
1823:
1824: IF p_x_Line_Payment_rec.payment_collection_event = FND_API.G_MISS_CHAR THEN
1825: p_x_Line_Payment_rec.payment_collection_event := NULL;
1826: END IF;
1827:
1828: IF p_x_Line_Payment_rec.defer_payment_processing_flag = FND_API.G_MISS_CHAR THEN
1824: IF p_x_Line_Payment_rec.payment_collection_event = FND_API.G_MISS_CHAR THEN
1825: p_x_Line_Payment_rec.payment_collection_event := NULL;
1826: END IF;
1827:
1828: IF p_x_Line_Payment_rec.defer_payment_processing_flag = FND_API.G_MISS_CHAR THEN
1829: p_x_Line_Payment_rec.defer_payment_processing_flag := NULL;
1830: END IF;
1831:
1832: IF p_x_Line_Payment_rec.payment_trx_id = FND_API.G_MISS_NUM THEN
1828: IF p_x_Line_Payment_rec.defer_payment_processing_flag = FND_API.G_MISS_CHAR THEN
1829: p_x_Line_Payment_rec.defer_payment_processing_flag := NULL;
1830: END IF;
1831:
1832: IF p_x_Line_Payment_rec.payment_trx_id = FND_API.G_MISS_NUM THEN
1833: p_x_Line_Payment_rec.payment_trx_id := NULL;
1834: END IF;
1835:
1836: IF p_x_Line_Payment_rec.payment_type_code = FND_API.G_MISS_CHAR THEN
1832: IF p_x_Line_Payment_rec.payment_trx_id = FND_API.G_MISS_NUM THEN
1833: p_x_Line_Payment_rec.payment_trx_id := NULL;
1834: END IF;
1835:
1836: IF p_x_Line_Payment_rec.payment_type_code = FND_API.G_MISS_CHAR THEN
1837: p_x_Line_Payment_rec.payment_type_code := NULL;
1838: END IF;
1839:
1840: IF p_x_Line_Payment_rec.payment_set_id = FND_API.G_MISS_NUM THEN
1836: IF p_x_Line_Payment_rec.payment_type_code = FND_API.G_MISS_CHAR THEN
1837: p_x_Line_Payment_rec.payment_type_code := NULL;
1838: END IF;
1839:
1840: IF p_x_Line_Payment_rec.payment_set_id = FND_API.G_MISS_NUM THEN
1841: p_x_Line_Payment_rec.payment_set_id := NULL;
1842: END IF;
1843:
1844: IF p_x_Line_Payment_rec.prepaid_amount = FND_API.G_MISS_NUM THEN
1840: IF p_x_Line_Payment_rec.payment_set_id = FND_API.G_MISS_NUM THEN
1841: p_x_Line_Payment_rec.payment_set_id := NULL;
1842: END IF;
1843:
1844: IF p_x_Line_Payment_rec.prepaid_amount = FND_API.G_MISS_NUM THEN
1845: p_x_Line_Payment_rec.prepaid_amount := NULL;
1846: END IF;
1847:
1848: IF p_x_Line_Payment_rec.program_application_id = FND_API.G_MISS_NUM THEN
1844: IF p_x_Line_Payment_rec.prepaid_amount = FND_API.G_MISS_NUM THEN
1845: p_x_Line_Payment_rec.prepaid_amount := NULL;
1846: END IF;
1847:
1848: IF p_x_Line_Payment_rec.program_application_id = FND_API.G_MISS_NUM THEN
1849: p_x_Line_Payment_rec.program_application_id := NULL;
1850: END IF;
1851:
1852: IF p_x_Line_Payment_rec.program_id = FND_API.G_MISS_NUM THEN
1848: IF p_x_Line_Payment_rec.program_application_id = FND_API.G_MISS_NUM THEN
1849: p_x_Line_Payment_rec.program_application_id := NULL;
1850: END IF;
1851:
1852: IF p_x_Line_Payment_rec.program_id = FND_API.G_MISS_NUM THEN
1853: p_x_Line_Payment_rec.program_id := NULL;
1854: END IF;
1855:
1856: IF p_x_Line_Payment_rec.program_update_date = FND_API.G_MISS_DATE THEN
1852: IF p_x_Line_Payment_rec.program_id = FND_API.G_MISS_NUM THEN
1853: p_x_Line_Payment_rec.program_id := NULL;
1854: END IF;
1855:
1856: IF p_x_Line_Payment_rec.program_update_date = FND_API.G_MISS_DATE THEN
1857: p_x_Line_Payment_rec.program_update_date := NULL;
1858: END IF;
1859:
1860: IF p_x_Line_Payment_rec.receipt_method_id = FND_API.G_MISS_NUM THEN
1856: IF p_x_Line_Payment_rec.program_update_date = FND_API.G_MISS_DATE THEN
1857: p_x_Line_Payment_rec.program_update_date := NULL;
1858: END IF;
1859:
1860: IF p_x_Line_Payment_rec.receipt_method_id = FND_API.G_MISS_NUM THEN
1861: p_x_Line_Payment_rec.receipt_method_id := NULL;
1862: END IF;
1863:
1864: IF p_x_Line_Payment_rec.request_id = FND_API.G_MISS_NUM THEN
1860: IF p_x_Line_Payment_rec.receipt_method_id = FND_API.G_MISS_NUM THEN
1861: p_x_Line_Payment_rec.receipt_method_id := NULL;
1862: END IF;
1863:
1864: IF p_x_Line_Payment_rec.request_id = FND_API.G_MISS_NUM THEN
1865: p_x_Line_Payment_rec.request_id := NULL;
1866: END IF;
1867:
1868: IF p_x_Line_Payment_rec.tangible_id = FND_API.G_MISS_CHAR THEN
1864: IF p_x_Line_Payment_rec.request_id = FND_API.G_MISS_NUM THEN
1865: p_x_Line_Payment_rec.request_id := NULL;
1866: END IF;
1867:
1868: IF p_x_Line_Payment_rec.tangible_id = FND_API.G_MISS_CHAR THEN
1869: p_x_Line_Payment_rec.tangible_id := NULL;
1870: END IF;
1871: -- R12 CC Encryption
1872: IF p_x_Line_Payment_rec.trxn_extension_id = FND_API.G_MISS_NUM THEN
1868: IF p_x_Line_Payment_rec.tangible_id = FND_API.G_MISS_CHAR THEN
1869: p_x_Line_Payment_rec.tangible_id := NULL;
1870: END IF;
1871: -- R12 CC Encryption
1872: IF p_x_Line_Payment_rec.trxn_extension_id = FND_API.G_MISS_NUM THEN
1873: p_x_Line_Payment_rec.trxn_extension_id := NULL;
1874: END IF;
1875:
1876: IF p_x_Line_Payment_rec.instrument_security_code = FND_API.G_MISS_CHAR THEN
1872: IF p_x_Line_Payment_rec.trxn_extension_id = FND_API.G_MISS_NUM THEN
1873: p_x_Line_Payment_rec.trxn_extension_id := NULL;
1874: END IF;
1875:
1876: IF p_x_Line_Payment_rec.instrument_security_code = FND_API.G_MISS_CHAR THEN
1877: p_x_Line_Payment_rec.instrument_security_code := NULL;
1878: END IF;
1879:
1880: -- R12 CC Encryption
1921: x_return_status => l_return_status); */
1922: IF l_debug_level > 0 THEN
1923: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_LINE_PAYMENT_UTIL.UPDATE_ROW IS: ' || L_RETURN_STATUS ) ;
1924: END IF;
1925: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1926: IF l_debug_level > 0 THEN
1927: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
1928: END IF;
1929: IF l_debug_level > 0 THEN
1928: END IF;
1929: IF l_debug_level > 0 THEN
1930: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENT_UTIL.UPDATE_ROW' , 1 ) ;
1931: END IF;
1932: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1933: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1934: IF l_debug_level > 0 THEN
1935: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_PAYMENT_UTIL.UPDATE_ROW' ) ;
1936: END IF;
1929: IF l_debug_level > 0 THEN
1930: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENT_UTIL.UPDATE_ROW' , 1 ) ;
1931: END IF;
1932: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1933: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1934: IF l_debug_level > 0 THEN
1935: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_PAYMENT_UTIL.UPDATE_ROW' ) ;
1936: END IF;
1937: IF l_debug_level > 0 THEN
1936: END IF;
1937: IF l_debug_level > 0 THEN
1938: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENT_UTIL.UPDATE_ROW' , 1 ) ;
1939: END IF;
1940: RAISE FND_API.G_EXC_ERROR;
1941: END IF;
1942: END IF; /*code_release_level*/
1943: -- notification framework end
1944:
2010: , 'Update_Row'
2011: );
2012: END IF;
2013:
2014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2015:
2016: END Update_Row;
2017:
2018: -- Procedure Insert_Row
2178: IF l_debug_level > 0 THEN
2179: oe_debug_pub.add( 'RETURNED INDEX IS: ' || L_INDEX , 1 ) ;
2180: END IF;
2181:
2182: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2183: IF l_debug_level > 0 THEN
2184: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
2185: END IF;
2186: IF l_debug_level > 0 THEN
2185: END IF;
2186: IF l_debug_level > 0 THEN
2187: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENT_UTIL.INSERT_ROW' , 1 ) ;
2188: END IF;
2189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2190: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2191: IF l_debug_level > 0 THEN
2192: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_PAYMENT_UTIL.INSERT_ROW' ) ;
2193: END IF;
2186: IF l_debug_level > 0 THEN
2187: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENT_UTIL.INSERT_ROW' , 1 ) ;
2188: END IF;
2189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2190: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2191: IF l_debug_level > 0 THEN
2192: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_PAYMENT_UTIL.INSERT_ROW' ) ;
2193: END IF;
2194: IF l_debug_level > 0 THEN
2193: END IF;
2194: IF l_debug_level > 0 THEN
2195: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENT_UTIL.INSERT_ROW' , 1 ) ;
2196: END IF;
2197: RAISE FND_API.G_EXC_ERROR;
2198: END IF;
2199: END IF; /*code_release_level*/
2200: -- notification framework end
2201:
2214: , 'Insert_Row'
2215: );
2216: END IF;
2217:
2218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2219:
2220: END Insert_Row;
2221:
2222: -- Procedure Delete_Row
2222: -- Procedure Delete_Row
2223:
2224: PROCEDURE Delete_Row
2225: ( p_payment_number IN NUMBER :=
2226: FND_API.G_MISS_NUM
2227: , p_line_id IN NUMBER :=
2228: FND_API.G_MISS_NUM
2229: , p_header_id IN NUMBER :=
2230: FND_API.G_MISS_NUM
2224: PROCEDURE Delete_Row
2225: ( p_payment_number IN NUMBER :=
2226: FND_API.G_MISS_NUM
2227: , p_line_id IN NUMBER :=
2228: FND_API.G_MISS_NUM
2229: , p_header_id IN NUMBER :=
2230: FND_API.G_MISS_NUM
2231: )
2232: IS
2226: FND_API.G_MISS_NUM
2227: , p_line_id IN NUMBER :=
2228: FND_API.G_MISS_NUM
2229: , p_header_id IN NUMBER :=
2230: FND_API.G_MISS_NUM
2231: )
2232: IS
2233: l_return_status VARCHAR2(30);
2234: p_payment_type_code VARCHAR2(30) := NULL;
2256: IF l_debug_level > 0 THEN
2257: oe_debug_pub.add( 'ENTERING OE_LINE_PAYMENT_UTIL.DELETE_ROW' , 1 ) ;
2258: END IF;
2259:
2260: IF p_line_id <> FND_API.G_MISS_NUM AND
2261: nvl(p_payment_number, FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM
2262: THEN
2263: FOR l_pmt IN payment LOOP
2264:
2257: oe_debug_pub.add( 'ENTERING OE_LINE_PAYMENT_UTIL.DELETE_ROW' , 1 ) ;
2258: END IF;
2259:
2260: IF p_line_id <> FND_API.G_MISS_NUM AND
2261: nvl(p_payment_number, FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM
2262: THEN
2263: FOR l_pmt IN payment LOOP
2264:
2265: --added notification framework
2298: x_return_status =>l_return_status,
2299: x_msg_count => l_msg_count,
2300: x_msg_data => l_msg_data);
2301:
2302: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2303: IF l_debug_level > 0 THEN
2304: oe_debug_pub.add( 'Delete Payment at OE_LINE_Payment_UTIL.DELETE_ROW - UNEXPECTED ERROR' ) ;
2305: oe_debug_pub.add('Error message'||sqlerrm);
2306: oe_debug_pub.add('Msg data'||l_msg_data);
2307: END IF;
2308: IF l_debug_level > 0 THEN
2309: oe_debug_pub.add( 'EXITING OE_LINE_Payment_UTIL.DELETE_ROW' , 1 ) ;
2310: END IF;
2311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2312: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2313: IF l_debug_level > 0 THEN
2314: oe_debug_pub.add( 'Delete Payment at OE_LINE_Payment_UTIL.DELETE_ROW' ) ;
2315: oe_debug_pub.add('Error message'||sqlerrm);
2308: IF l_debug_level > 0 THEN
2309: oe_debug_pub.add( 'EXITING OE_LINE_Payment_UTIL.DELETE_ROW' , 1 ) ;
2310: END IF;
2311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2312: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2313: IF l_debug_level > 0 THEN
2314: oe_debug_pub.add( 'Delete Payment at OE_LINE_Payment_UTIL.DELETE_ROW' ) ;
2315: oe_debug_pub.add('Error message'||sqlerrm);
2316: oe_debug_pub.add('Msg data'||l_msg_data);
2317: END IF;
2318: IF l_debug_level > 0 THEN
2319: oe_debug_pub.add( 'EXITING OE_LINE_Payment_UTIL.DELETE_ROW' , 1 ) ;
2320: END IF;
2321: RAISE FND_API.G_EXC_ERROR;
2322: END IF;
2323: END IF;
2324: --R12 CC Encryption
2325:
2331: x_return_status => l_return_status);
2332: IF l_debug_level > 0 THEN
2333: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_LINE_PAYMENT_UTIL.DELETE_ROW IS: ' || L_RETURN_STATUS ) ;
2334: END IF;
2335: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2336: IF l_debug_level > 0 THEN
2337: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
2338: END IF;
2339: IF l_debug_level > 0 THEN
2338: END IF;
2339: IF l_debug_level > 0 THEN
2340: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENT_UTIL.DELETE_ROW' , 1 ) ;
2341: END IF;
2342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2343: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2344: IF l_debug_level > 0 THEN
2345: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_PAYMENT_UTIL.DELETE_ROW' ) ;
2346: END IF;
2339: IF l_debug_level > 0 THEN
2340: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENT_UTIL.DELETE_ROW' , 1 ) ;
2341: END IF;
2342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2343: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2344: IF l_debug_level > 0 THEN
2345: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_PAYMENT_UTIL.DELETE_ROW' ) ;
2346: END IF;
2347: IF l_debug_level > 0 THEN
2346: END IF;
2347: IF l_debug_level > 0 THEN
2348: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENT_UTIL.DELETE_ROW' , 1 ) ;
2349: END IF;
2350: RAISE FND_API.G_EXC_ERROR;
2351: END IF;*/
2352: END IF; /*code_release_level*/
2353: -- notification framework end
2354:
2375: x_return_status => l_return_status,
2376: x_msg_count => l_msg_count,
2377: x_msg_data => l_msg_data);
2378:
2379: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2380: IF l_debug_level > 0 THEN
2381: oe_debug_pub.add( 'Delete Payment at Line - UNEXPECTED ERROR' ) ;
2382: END IF;
2383: IF l_debug_level > 0 THEN
2382: END IF;
2383: IF l_debug_level > 0 THEN
2384: oe_debug_pub.add( 'EXITING OE_LINE_Payment_UTIL.DELETE_ROW' , 1 ) ;
2385: END IF;
2386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2387: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2388: IF l_debug_level > 0 THEN
2389: oe_debug_pub.add( 'Delete Payment at Line - OE_LINE_Payment_UTIL.DELETE_ROW' ) ;
2390: END IF;
2383: IF l_debug_level > 0 THEN
2384: oe_debug_pub.add( 'EXITING OE_LINE_Payment_UTIL.DELETE_ROW' , 1 ) ;
2385: END IF;
2386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2387: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2388: IF l_debug_level > 0 THEN
2389: oe_debug_pub.add( 'Delete Payment at Line - OE_LINE_Payment_UTIL.DELETE_ROW' ) ;
2390: END IF;
2391: IF l_debug_level > 0 THEN
2390: END IF;
2391: IF l_debug_level > 0 THEN
2392: oe_debug_pub.add( 'EXITING OE_LINE_Payment_UTIL.DELETE_ROW' , 1 ) ;
2393: END IF;
2394: RAISE FND_API.G_EXC_ERROR;
2395: END IF;
2396: --3382262
2397:
2398: IF l_debug_level > 0 THEN
2406: , p_msg_data => l_msg_data
2407: , p_return_status => l_return_status
2408: );
2409:
2410: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2411: RAISE FND_API.G_EXC_ERROR;
2412: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2414: END IF;
2407: , p_return_status => l_return_status
2408: );
2409:
2410: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2411: RAISE FND_API.G_EXC_ERROR;
2412: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2414: END IF;
2415:
2408: );
2409:
2410: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2411: RAISE FND_API.G_EXC_ERROR;
2412: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2414: END IF;
2415:
2416: ELSIF p_line_id <> FND_API.G_MISS_NUM AND
2409:
2410: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2411: RAISE FND_API.G_EXC_ERROR;
2412: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2414: END IF;
2415:
2416: ELSIF p_line_id <> FND_API.G_MISS_NUM AND
2417: p_payment_number <> FND_API.G_MISS_NUM THEN
2412: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2414: END IF;
2415:
2416: ELSIF p_line_id <> FND_API.G_MISS_NUM AND
2417: p_payment_number <> FND_API.G_MISS_NUM THEN
2418: --added notification framework
2419: --check code release level first. Notification framework is at Pack H level
2420: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
2413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2414: END IF;
2415:
2416: ELSIF p_line_id <> FND_API.G_MISS_NUM AND
2417: p_payment_number <> FND_API.G_MISS_NUM THEN
2418: --added notification framework
2419: --check code release level first. Notification framework is at Pack H level
2420: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
2421: /* Set the operation on the record so that globals are updated as well */
2436: , x_msg_count => l_msg_count
2437: , x_msg_data => l_msg_data
2438: , x_return_status => l_return_status
2439: );
2440: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2441: RAISE FND_API.G_EXC_ERROR;
2442: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2444: END IF;
2437: , x_msg_data => l_msg_data
2438: , x_return_status => l_return_status
2439: );
2440: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2441: RAISE FND_API.G_EXC_ERROR;
2442: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2444: END IF;
2445: --ER#7479609 end
2438: , x_return_status => l_return_status
2439: );
2440: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2441: RAISE FND_API.G_EXC_ERROR;
2442: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2444: END IF;
2445: --ER#7479609 end
2446:
2439: );
2440: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2441: RAISE FND_API.G_EXC_ERROR;
2442: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2444: END IF;
2445: --ER#7479609 end
2446:
2447: IF l_debug_level > 0 THEN
2447: IF l_debug_level > 0 THEN
2448: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_LINE_PAYMENT_UTIL.DELETE_ROW IS: ' || L_RETURN_STATUS ) ;
2449: END IF;
2450:
2451: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2452: IF l_debug_level > 0 THEN
2453: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
2454: END IF;
2455: IF l_debug_level > 0 THEN
2454: END IF;
2455: IF l_debug_level > 0 THEN
2456: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENT_UTIL.DELETE_ROW' , 1 ) ;
2457: END IF;
2458: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2459: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2460: IF l_debug_level > 0 THEN
2461: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_PAYMENT_UTIL.DELETE_ROW' ) ;
2462: END IF;
2455: IF l_debug_level > 0 THEN
2456: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENT_UTIL.DELETE_ROW' , 1 ) ;
2457: END IF;
2458: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2459: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2460: IF l_debug_level > 0 THEN
2461: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_PAYMENT_UTIL.DELETE_ROW' ) ;
2462: END IF;
2463: IF l_debug_level > 0 THEN
2462: END IF;
2463: IF l_debug_level > 0 THEN
2464: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENT_UTIL.DELETE_ROW' , 1 ) ;
2465: END IF;
2466: RAISE FND_API.G_EXC_ERROR;
2467: END IF;
2468: END IF; /*code_release_level*/
2469: -- notification framework end
2470:
2528: x_msg_count => l_msg_count,
2529: x_msg_data => l_msg_data);
2530:
2531:
2532: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2533: IF l_debug_level > 0 THEN
2534: oe_debug_pub.add( '2:Delete Payment OE_LINE_Payment_UTIL.DELETE_ROW - UNEXPECTED ERROR' ) ;
2535: END IF;
2536: IF l_debug_level > 0 THEN
2535: END IF;
2536: IF l_debug_level > 0 THEN
2537: oe_debug_pub.add( 'EXITING OE_LINE_Payment_UTIL.DELETE_ROW' , 1 ) ;
2538: END IF;
2539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2540: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2541: IF l_debug_level > 0 THEN
2542: oe_debug_pub.add( '2:Delete Payment OE_LINE_Payment_UTIL.DELETE_ROW' ) ;
2543: END IF;
2536: IF l_debug_level > 0 THEN
2537: oe_debug_pub.add( 'EXITING OE_LINE_Payment_UTIL.DELETE_ROW' , 1 ) ;
2538: END IF;
2539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2540: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2541: IF l_debug_level > 0 THEN
2542: oe_debug_pub.add( '2:Delete Payment OE_LINE_Payment_UTIL.DELETE_ROW' ) ;
2543: END IF;
2544: IF l_debug_level > 0 THEN
2543: END IF;
2544: IF l_debug_level > 0 THEN
2545: oe_debug_pub.add( 'EXITING OE_LINE_Payment_UTIL.DELETE_ROW' , 1 ) ;
2546: END IF;
2547: RAISE FND_API.G_EXC_ERROR;
2548: END IF;
2549: END IF;
2550: --R12 CC Encryption
2551:
2568: x_return_status => l_return_status,
2569: x_msg_count => l_msg_count,
2570: x_msg_data => l_msg_data);
2571:
2572: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2573: IF l_debug_level > 0 THEN
2574: oe_debug_pub.add( 'Delete Payment at Line - UNEXPECTED ERROR' ) ;
2575: END IF;
2576: IF l_debug_level > 0 THEN
2575: END IF;
2576: IF l_debug_level > 0 THEN
2577: oe_debug_pub.add( 'EXITING OE_LINE_Payment_UTIL.DELETE_ROW' , 1 ) ;
2578: END IF;
2579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2580: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2581: IF l_debug_level > 0 THEN
2582: oe_debug_pub.add( 'Delete Payment at Line - OE_LINE_Payment_UTIL.DELETE_ROW' ) ;
2583: END IF;
2576: IF l_debug_level > 0 THEN
2577: oe_debug_pub.add( 'EXITING OE_LINE_Payment_UTIL.DELETE_ROW' , 1 ) ;
2578: END IF;
2579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2580: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2581: IF l_debug_level > 0 THEN
2582: oe_debug_pub.add( 'Delete Payment at Line - OE_LINE_Payment_UTIL.DELETE_ROW' ) ;
2583: END IF;
2584: IF l_debug_level > 0 THEN
2583: END IF;
2584: IF l_debug_level > 0 THEN
2585: oe_debug_pub.add( 'EXITING OE_LINE_Payment_UTIL.DELETE_ROW' , 1 ) ;
2586: END IF;
2587: RAISE FND_API.G_EXC_ERROR;
2588: END IF;
2589: --3382262
2590:
2591: IF p_payment_type_code = 'CREDIT_CARD' THEN
2600: , p_msg_data => l_msg_data
2601: , p_return_status => l_return_status
2602: );
2603:
2604: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2605: RAISE FND_API.G_EXC_ERROR;
2606: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2608: END IF;
2601: , p_return_status => l_return_status
2602: );
2603:
2604: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2605: RAISE FND_API.G_EXC_ERROR;
2606: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2608: END IF;
2609: END IF;
2602: );
2603:
2604: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2605: RAISE FND_API.G_EXC_ERROR;
2606: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2608: END IF;
2609: END IF;
2610:
2603:
2604: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2605: RAISE FND_API.G_EXC_ERROR;
2606: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2608: END IF;
2609: END IF;
2610:
2611: END IF;
2621: , 'Delete_Row'
2622: );
2623: END IF;
2624:
2625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2626:
2627: END Delete_Row;
2628:
2629: -- Procedure Query_Row
2630: PROCEDURE Query_Row
2631: ( p_payment_number IN NUMBER,
2632: p_line_id IN NUMBER,
2633: p_header_id IN NUMBER :=
2634: FND_API.G_MISS_NUM,
2635: x_Line_Payment_rec IN OUT NOCOPY OE_Order_PUB.Line_Payment_Rec_Type
2636: )
2637: IS
2638: x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2795:
2796: IF
2797: (p_payment_number IS NOT NULL
2798: AND
2799: p_payment_number <> FND_API.G_MISS_NUM)
2800: AND
2801: (p_line_id IS NOT NULL
2802: AND
2803: p_line_id <> FND_API.G_MISS_NUM)
2799: p_payment_number <> FND_API.G_MISS_NUM)
2800: AND
2801: (p_line_id IS NOT NULL
2802: AND
2803: p_line_id <> FND_API.G_MISS_NUM)
2804: AND
2805: (x_Line_Payment_tbl.COUNT = 0)
2806: THEN
2807: RAISE NO_DATA_FOUND;
2808: END IF;
2809:
2810: EXCEPTION
2811:
2812: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2813:
2814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2815:
2816: WHEN OTHERS THEN
2810: EXCEPTION
2811:
2812: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2813:
2814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2815:
2816: WHEN OTHERS THEN
2817:
2818: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2822: , 'Query_Row'
2823: );
2824: END IF;
2825:
2826: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2827:
2828: END Query_Row;
2829:
2830:
2834: --
2835:
2836: Procedure Query_Rows
2837: ( p_payment_number IN NUMBER :=
2838: FND_API.G_MISS_NUM
2839: , p_line_id IN NUMBER :=
2840: FND_API.G_MISS_NUM
2841: , p_header_id IN NUMBER :=
2842: FND_API.G_MISS_NUM
2836: Procedure Query_Rows
2837: ( p_payment_number IN NUMBER :=
2838: FND_API.G_MISS_NUM
2839: , p_line_id IN NUMBER :=
2840: FND_API.G_MISS_NUM
2841: , p_header_id IN NUMBER :=
2842: FND_API.G_MISS_NUM
2843: , x_line_Payment_tbl IN OUT NOCOPY OE_Order_PUB.Line_Payment_Tbl_Type
2844: )
2838: FND_API.G_MISS_NUM
2839: , p_line_id IN NUMBER :=
2840: FND_API.G_MISS_NUM
2841: , p_header_id IN NUMBER :=
2842: FND_API.G_MISS_NUM
2843: , x_line_Payment_tbl IN OUT NOCOPY OE_Order_PUB.Line_Payment_Tbl_Type
2844: )
2845: IS
2846: l_Line_Payment_rec OE_Order_PUB.Line_Payment_Rec_Type;
2998:
2999:
3000: EXCEPTION
3001:
3002: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3003:
3004: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3005:
3006: WHEN OTHERS THEN
3000: EXCEPTION
3001:
3002: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3003:
3004: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3005:
3006: WHEN OTHERS THEN
3007:
3008: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3012: , 'Query_Rows'
3013: );
3014: END IF;
3015:
3016: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3017:
3018: END Query_Rows;
3019:
3020: -- Procedure lock_Row
3023: PROCEDURE Lock_Row
3024: ( x_return_status OUT NOCOPY VARCHAR2
3025: , p_x_Line_Payment_rec IN OUT NOCOPY OE_Order_PUB.Line_Payment_Rec_Type
3026: , p_payment_number IN NUMBER
3027: := FND_API.G_MISS_NUM
3028: , p_line_id IN NUMBER
3029: := FND_API.G_MISS_NUM
3030: )
3031: IS
3025: , p_x_Line_Payment_rec IN OUT NOCOPY OE_Order_PUB.Line_Payment_Rec_Type
3026: , p_payment_number IN NUMBER
3027: := FND_API.G_MISS_NUM
3028: , p_line_id IN NUMBER
3029: := FND_API.G_MISS_NUM
3030: )
3031: IS
3032: l_payment_number NUMBER;
3033: l_line_id NUMBER;
3048: l_lock_control := NULL;
3049:
3050: l_header_id := p_x_line_Payment_rec.header_id;
3051: -- Retrieve the primary key.
3052: IF p_payment_number <> FND_API.G_MISS_NUM AND
3053: p_line_id <> FND_API.G_MISS_NUM THEN
3054: l_payment_number := p_payment_number;
3055: l_line_id := p_line_id;
3056: ELSE
3049:
3050: l_header_id := p_x_line_Payment_rec.header_id;
3051: -- Retrieve the primary key.
3052: IF p_payment_number <> FND_API.G_MISS_NUM AND
3053: p_line_id <> FND_API.G_MISS_NUM THEN
3054: l_payment_number := p_payment_number;
3055: l_line_id := p_line_id;
3056: ELSE
3057: l_payment_number := p_x_line_Payment_rec.payment_number;
3080:
3081: -- If lock_control is null / missing, then return the locked record.
3082:
3083: IF l_lock_control is null OR
3084: l_lock_control <> FND_API.G_MISS_NUM THEN
3085:
3086: -- Set return status
3087: x_return_status := FND_API.G_RET_STS_SUCCESS;
3088: p_x_line_Payment_rec.return_status := FND_API.G_RET_STS_SUCCESS;
3083: IF l_lock_control is null OR
3084: l_lock_control <> FND_API.G_MISS_NUM THEN
3085:
3086: -- Set return status
3087: x_return_status := FND_API.G_RET_STS_SUCCESS;
3088: p_x_line_Payment_rec.return_status := FND_API.G_RET_STS_SUCCESS;
3089:
3090: RETURN;
3091:
3084: l_lock_control <> FND_API.G_MISS_NUM THEN
3085:
3086: -- Set return status
3087: x_return_status := FND_API.G_RET_STS_SUCCESS;
3088: p_x_line_Payment_rec.return_status := FND_API.G_RET_STS_SUCCESS;
3089:
3090: RETURN;
3091:
3092: END IF;
3103: p_x_Line_Payment_rec := l_Line_Payment_rec;
3104:
3105: -- Set return status
3106:
3107: x_return_status := FND_API.G_RET_STS_SUCCESS;
3108: p_x_Line_Payment_rec.return_status := FND_API.G_RET_STS_SUCCESS;
3109:
3110: ELSE
3111:
3104:
3105: -- Set return status
3106:
3107: x_return_status := FND_API.G_RET_STS_SUCCESS;
3108: p_x_Line_Payment_rec.return_status := FND_API.G_RET_STS_SUCCESS;
3109:
3110: ELSE
3111:
3112: -- Row has changed by another user.
3110: ELSE
3111:
3112: -- Row has changed by another user.
3113:
3114: x_return_status := FND_API.G_RET_STS_ERROR;
3115: p_x_Line_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
3116:
3117: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3118: THEN
3111:
3112: -- Row has changed by another user.
3113:
3114: x_return_status := FND_API.G_RET_STS_ERROR;
3115: p_x_Line_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
3116:
3117: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3118: THEN
3119:
3130: EXCEPTION
3131:
3132: WHEN NO_DATA_FOUND THEN
3133:
3134: x_return_status := FND_API.G_RET_STS_ERROR;
3135: p_x_Line_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
3136:
3137: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3138: THEN
3131:
3132: WHEN NO_DATA_FOUND THEN
3133:
3134: x_return_status := FND_API.G_RET_STS_ERROR;
3135: p_x_Line_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
3136:
3137: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3138: THEN
3139:
3142:
3143: END IF;
3144: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
3145:
3146: x_return_status := FND_API.G_RET_STS_ERROR;
3147: p_x_Line_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
3148:
3149: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3150: THEN
3143: END IF;
3144: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
3145:
3146: x_return_status := FND_API.G_RET_STS_ERROR;
3147: p_x_Line_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
3148:
3149: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3150: THEN
3151:
3154:
3155: END IF;
3156: WHEN OTHERS THEN
3157:
3158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3159: p_x_Line_Payment_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3160:
3161: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3162: THEN
3155: END IF;
3156: WHEN OTHERS THEN
3157:
3158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3159: p_x_Line_Payment_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3160:
3161: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3162: THEN
3163: oe_msg_pub.Add_Exc_Msg
3169: END Lock_Row;
3170:
3171: PROCEDURE Lock_Rows
3172: ( p_payment_number IN NUMBER :=
3173: FND_API.G_MISS_NUM
3174: , p_line_id IN NUMBER :=
3175: FND_API.G_MISS_NUM
3176: , p_header_id IN NUMBER :=
3177: FND_API.G_MISS_NUM
3171: PROCEDURE Lock_Rows
3172: ( p_payment_number IN NUMBER :=
3173: FND_API.G_MISS_NUM
3174: , p_line_id IN NUMBER :=
3175: FND_API.G_MISS_NUM
3176: , p_header_id IN NUMBER :=
3177: FND_API.G_MISS_NUM
3178: , x_line_Payment_tbl OUT NOCOPY OE_Order_PUB.line_Payment_Tbl_Type
3179: , x_return_status OUT NOCOPY VARCHAR2
3173: FND_API.G_MISS_NUM
3174: , p_line_id IN NUMBER :=
3175: FND_API.G_MISS_NUM
3176: , p_header_id IN NUMBER :=
3177: FND_API.G_MISS_NUM
3178: , x_line_Payment_tbl OUT NOCOPY OE_Order_PUB.line_Payment_Tbl_Type
3179: , x_return_status OUT NOCOPY VARCHAR2
3180: )
3181: IS
3196: oe_debug_pub.add( 'ENTERING OE_HEADER_PaymentS_UTIL.LOCK_ROWS' , 1 ) ;
3197: END IF;
3198: /*
3199: IF (p_payment_number IS NOT NULL AND
3200: p_payment_number <> FND_API.G_MISS_NUM) AND
3201: (p_line_id IS NOT NULL AND
3202: p_line_id <> FND_API.G_MISS_NUM)
3203: THEN
3204: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3198: /*
3199: IF (p_payment_number IS NOT NULL AND
3200: p_payment_number <> FND_API.G_MISS_NUM) AND
3201: (p_line_id IS NOT NULL AND
3202: p_line_id <> FND_API.G_MISS_NUM)
3203: THEN
3204: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3205: THEN
3206: OE_MSG_PUB.Add_Exc_Msg
3209: , 'Keys are mutually exclusive: payment_number = '||
3210: p_payment_number || ', line_id = '|| p_line_id );
3211: END IF;
3212:
3213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3214:
3215: END IF;
3216: */
3217: IF p_payment_number <> FND_API.G_MISS_NUM AND
3213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3214:
3215: END IF;
3216: */
3217: IF p_payment_number <> FND_API.G_MISS_NUM AND
3218: p_line_id <> FND_API.G_MISS_NUM THEN
3219:
3220: SELECT payment_number
3221: INTO l_payment_number
3214:
3215: END IF;
3216: */
3217: IF p_payment_number <> FND_API.G_MISS_NUM AND
3218: p_line_id <> FND_API.G_MISS_NUM THEN
3219:
3220: SELECT payment_number
3221: INTO l_payment_number
3222: FROM OE_PAYMENTS
3228: ELSE
3229:
3230: BEGIN
3231:
3232: IF p_line_id <> FND_API.G_MISS_NUM THEN
3233:
3234: SAVEPOINT LOCK_ROWS;
3235: OPEN lock_lin_Payments(p_line_id);
3236:
3263: ,p_header_id => p_header_id
3264: ,x_line_Payment_tbl => x_line_Payment_tbl
3265: );
3266:
3267: x_return_status := FND_API.G_RET_STS_SUCCESS;
3268:
3269: IF l_debug_level > 0 THEN
3270: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENTS_UTIL.LOCK_ROWS' , 1 ) ;
3271: END IF;
3272:
3273: EXCEPTION
3274: WHEN NO_DATA_FOUND THEN
3275:
3276: x_return_status := FND_API.G_RET_STS_ERROR;
3277:
3278: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3279: THEN
3280: fnd_message.set_name('ONT','OE_LOCK_ROW_DELETED');
3282: END IF;
3283:
3284: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
3285:
3286: x_return_status := FND_API.G_RET_STS_ERROR;
3287: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3288: THEN
3289: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
3290: OE_MSG_PUB.Add;
3291: END IF;
3292:
3293: WHEN OTHERS THEN
3294:
3295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3296:
3297: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3298: THEN
3299: OE_MSG_PUB.Add_Exc_Msg
3319: --
3320: BEGIN
3321:
3322: IF (p_Line_Payment_rec.payment_collection_event IS NULL OR
3323: p_Line_Payment_rec.payment_collection_event <> FND_API.G_MISS_CHAR) AND
3324: NOT OE_GLOBALS.Equal(p_Line_Payment_rec.payment_collection_event,
3325: p_old_Line_Payment_rec.payment_collection_event)
3326: THEN
3327: l_Line_Payment_val_rec.payment_collection_event_name := OE_Id_To_Value.payment_collection_event_name
3329: );
3330: END IF;
3331:
3332: IF (p_Line_Payment_rec.receipt_method_id IS NULL OR
3333: p_Line_Payment_rec.receipt_method_id <> FND_API.G_MISS_NUM) AND
3334: NOT OE_GLOBALS.Equal(p_Line_Payment_rec.receipt_method_id,
3335: p_old_Line_Payment_rec.receipt_method_id)
3336: THEN
3337: l_Line_Payment_val_rec.receipt_method := OE_Id_To_Value.Receipt_Method
3339: );
3340: END IF;
3341:
3342: IF (p_Line_Payment_rec.payment_type_code IS NULL OR
3343: p_Line_Payment_rec.payment_type_code <> FND_API.G_MISS_CHAR) AND
3344: NOT OE_GLOBALS.Equal(p_Line_Payment_rec.payment_type_code,
3345: p_old_Line_Payment_rec.payment_type_code)
3346: THEN
3347: l_Line_Payment_val_rec.payment_type := OE_Id_To_Value.payment_type
3367: BEGIN
3368:
3369: -- initialize return_status.
3370:
3371: p_x_Line_Payment_rec.return_status := FND_API.G_RET_STS_SUCCESS;
3372:
3373: -- initialize l_Line_Payment_rec.
3374:
3375:
3373: -- initialize l_Line_Payment_rec.
3374:
3375:
3376:
3377: IF p_Line_Payment_val_rec.payment_collection_event_name <> FND_API.G_MISS_CHAR
3378: THEN
3379:
3380: IF p_x_Line_Payment_rec.payment_collection_event <> FND_API.G_MISS_CHAR THEN
3381:
3376:
3377: IF p_Line_Payment_val_rec.payment_collection_event_name <> FND_API.G_MISS_CHAR
3378: THEN
3379:
3380: IF p_x_Line_Payment_rec.payment_collection_event <> FND_API.G_MISS_CHAR THEN
3381:
3382: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
3383: THEN
3384:
3393: p_x_Line_Payment_rec.payment_collection_event := OE_Value_To_Id.payment_collection_event_name
3394: ( p_payment_collection_event => p_Line_Payment_val_rec.payment_collection_event_name
3395: );
3396:
3397: IF p_x_Line_Payment_rec.payment_collection_event = FND_API.G_MISS_CHAR THEN
3398: p_x_Line_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
3399: END IF;
3400:
3401: END IF;
3394: ( p_payment_collection_event => p_Line_Payment_val_rec.payment_collection_event_name
3395: );
3396:
3397: IF p_x_Line_Payment_rec.payment_collection_event = FND_API.G_MISS_CHAR THEN
3398: p_x_Line_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
3399: END IF;
3400:
3401: END IF;
3402:
3401: END IF;
3402:
3403: END IF;
3404:
3405: IF p_Line_Payment_val_rec.payment_type <> FND_API.G_MISS_CHAR
3406: THEN
3407:
3408: IF p_x_Line_Payment_rec.payment_type_code <> FND_API.G_MISS_CHAR THEN
3409:
3404:
3405: IF p_Line_Payment_val_rec.payment_type <> FND_API.G_MISS_CHAR
3406: THEN
3407:
3408: IF p_x_Line_Payment_rec.payment_type_code <> FND_API.G_MISS_CHAR THEN
3409:
3410:
3411: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
3412: THEN
3422: p_x_Line_Payment_rec.payment_type_code := OE_Value_To_Id.payment_type
3423: ( p_payment_type => p_Line_Payment_val_rec.payment_type
3424: );
3425:
3426: IF p_x_Line_Payment_rec.payment_type_code = FND_API.G_MISS_CHAR THEN
3427: p_x_Line_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
3428: END IF;
3429:
3430: END IF;
3423: ( p_payment_type => p_Line_Payment_val_rec.payment_type
3424: );
3425:
3426: IF p_x_Line_Payment_rec.payment_type_code = FND_API.G_MISS_CHAR THEN
3427: p_x_Line_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
3428: END IF;
3429:
3430: END IF;
3431:
3431:
3432: END IF;
3433:
3434:
3435: IF p_Line_Payment_val_rec.receipt_method <> FND_API.G_MISS_CHAR
3436: THEN
3437:
3438: IF p_x_Line_Payment_rec.receipt_method_id <> FND_API.G_MISS_NUM THEN
3439:
3434:
3435: IF p_Line_Payment_val_rec.receipt_method <> FND_API.G_MISS_CHAR
3436: THEN
3437:
3438: IF p_x_Line_Payment_rec.receipt_method_id <> FND_API.G_MISS_NUM THEN
3439:
3440:
3441: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
3442: THEN
3452: p_x_Line_Payment_rec.receipt_method_id := OE_Value_To_Id.Receipt_Method
3453: ( p_receipt_method => p_Line_Payment_val_rec.receipt_method
3454: );
3455:
3456: IF p_x_Line_Payment_rec.receipt_method_id = FND_API.G_MISS_NUM THEN
3457: p_x_Line_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
3458: END IF;
3459:
3460: END IF;
3453: ( p_receipt_method => p_Line_Payment_val_rec.receipt_method
3454: );
3455:
3456: IF p_x_Line_Payment_rec.receipt_method_id = FND_API.G_MISS_NUM THEN
3457: p_x_Line_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
3458: END IF;
3459:
3460: END IF;
3461:
3691: X_msg_data => l_msg_data);
3692:
3693: p_x_line_payment_rec.trxn_extension_id := l_trxn_extension_id;
3694: EXCEPTION
3695: WHEN FND_API.G_EXC_ERROR THEN
3696: l_return_status := FND_API.G_RET_STS_ERROR;
3697: RAISE FND_API.G_EXC_ERROR;
3698:
3699: WHEN OTHERS THEN
3692:
3693: p_x_line_payment_rec.trxn_extension_id := l_trxn_extension_id;
3694: EXCEPTION
3695: WHEN FND_API.G_EXC_ERROR THEN
3696: l_return_status := FND_API.G_RET_STS_ERROR;
3697: RAISE FND_API.G_EXC_ERROR;
3698:
3699: WHEN OTHERS THEN
3700: IF l_debug_level>0 THEN
3693: p_x_line_payment_rec.trxn_extension_id := l_trxn_extension_id;
3694: EXCEPTION
3695: WHEN FND_API.G_EXC_ERROR THEN
3696: l_return_status := FND_API.G_RET_STS_ERROR;
3697: RAISE FND_API.G_EXC_ERROR;
3698:
3699: WHEN OTHERS THEN
3700: IF l_debug_level>0 THEN
3701: oe_debug_pub.add('After call to copy payment trxn - exception'||sqlerrm);
3699: WHEN OTHERS THEN
3700: IF l_debug_level>0 THEN
3701: oe_debug_pub.add('After call to copy payment trxn - exception'||sqlerrm);
3702: END IF;
3703: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3704: END;
3705: ELSIF p_x_line_payment_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
3706: IF p_x_line_payment_rec.trxn_extension_id IS NOT NULL
3707: AND p_x_line_payment_rec.trxn_extension_id <> FND_API.G_MISS_NUM
3703: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3704: END;
3705: ELSIF p_x_line_payment_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
3706: IF p_x_line_payment_rec.trxn_extension_id IS NOT NULL
3707: AND p_x_line_payment_rec.trxn_extension_id <> FND_API.G_MISS_NUM
3708: AND ((p_x_line_Payment_rec.payment_type_code = 'CREDIT_CARD'
3709: AND OE_GLOBALS.Is_Same_Credit_Card(p_old_line_Payment_rec.credit_card_number,
3710: p_x_line_Payment_rec.credit_card_number,
3711: p_old_line_Payment_rec.cc_instrument_id,
3725: --While changing the payment type from cash, check etc to
3726: --credit card payment type, the operation would be update but the
3727: --transaction extension id would be null.
3728: ELSIF p_x_line_payment_rec.trxn_extension_id IS NULL OR
3729: p_x_line_payment_rec.trxn_extension_id = FND_API.G_MISS_NUM THEN
3730:
3731: IF l_debug_level > 0 THEN
3732: oe_debug_pub.add( 'Inside trxn extension id creation part....');
3733: oe_debug_pub.add(' Operation is UPDATE and Trxn extension id is null...');
3749: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use = 'REQUIRED' AND
3750: p_x_line_Payment_rec.instrument_security_code IS NULL THEN
3751: FND_MESSAGE.SET_NAME('ONT','OE_CC_SECURITY_CODE_REQD');
3752: OE_Msg_Pub.Add;
3753: RAISE FND_API.G_EXC_ERROR;
3754: END IF;
3755: END IF;
3756:
3757: IF NOT OE_GLOBALS.Is_Same_Credit_Card(p_old_line_Payment_rec.credit_card_number,
3807: IF l_debug_level>0 THEN
3808: oe_debug_pub.add('New trxn extension id after calling Create_Payment_TRXN:'||l_trxn_extension_id);
3809: END IF;
3810: EXCEPTION
3811: WHEN FND_API.G_EXC_ERROR THEN
3812: OE_MSG_PUB.Count_And_Get
3813: ( p_count => l_msg_count,
3814: p_data => l_msg_data
3815: );
3812: OE_MSG_PUB.Count_And_Get
3813: ( p_count => l_msg_count,
3814: p_data => l_msg_data
3815: );
3816: l_return_status := FND_API.G_RET_STS_ERROR;
3817: RAISE FND_API.G_EXC_ERROR;
3818:
3819: WHEN OTHERS THEN
3820: OE_MSG_PUB.Count_And_Get
3813: ( p_count => l_msg_count,
3814: p_data => l_msg_data
3815: );
3816: l_return_status := FND_API.G_RET_STS_ERROR;
3817: RAISE FND_API.G_EXC_ERROR;
3818:
3819: WHEN OTHERS THEN
3820: OE_MSG_PUB.Count_And_Get
3821: ( p_count => l_msg_count,
3826: IF l_debug_level > 0 THEN
3827: oe_debug_pub.add( 'OEXUHPMB: ERROR IN CREATE PAYMENT trxn...'||sqlerrm) ;
3828: oe_debug_pub.add('Error messsge ksurendr'||l_return_status);
3829: END IF;
3830: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3831: END;
3832: --Trxn extension id exists and an update to some of the
3833: --attributes of the payment transaction has occured. So
3834: --need to call Update_Payment_Trxn API.
3843: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use = 'REQUIRED'
3844: AND p_x_line_Payment_rec.instrument_security_code IS NULL THEN
3845: FND_MESSAGE.SET_NAME('ONT','OE_CC_SECURITY_CODE_REQD');
3846: OE_Msg_Pub.Add;
3847: RAISE FND_API.G_EXC_ERROR;
3848: END IF;
3849: END IF;*/
3850: IF l_debug_level > 0 THEN
3851: oe_debug_pub.add('Verifying whether to call update card API...');
3909: oe_debug_pub.add('trxn extension id after calling Update_Payment_TRXN:'||p_x_line_payment_rec.trxn_extension_id);
3910: oe_debug_pub.add( 'id already derived for this credit card');
3911: END IF;
3912: EXCEPTION
3913: WHEN FND_API.G_EXC_ERROR THEN
3914: IF l_debug_level > 0 THEN
3915: oe_debug_pub.add('Update_Payment_TRXN error....exc');
3916: oe_debug_pub.add('After call to Update_Payment_TRXN'||l_return_status);
3917: oe_debug_pub.add('Error'||sqlerrm);
3915: oe_debug_pub.add('Update_Payment_TRXN error....exc');
3916: oe_debug_pub.add('After call to Update_Payment_TRXN'||l_return_status);
3917: oe_debug_pub.add('Error'||sqlerrm);
3918: END IF;
3919: l_return_status := FND_API.G_RET_STS_ERROR;
3920: OE_MSG_PUB.Count_And_Get
3921: ( p_count => l_msg_count,
3922: p_data => l_msg_data
3923: );
3920: OE_MSG_PUB.Count_And_Get
3921: ( p_count => l_msg_count,
3922: p_data => l_msg_data
3923: );
3924: RAISE FND_API.G_EXC_ERROR;
3925:
3926: WHEN OTHERS THEN
3927: IF l_debug_level > 0 THEN
3928: oe_debug_pub.add('After call to Update_Payment_TRXN --> Unexpected error');
3927: IF l_debug_level > 0 THEN
3928: oe_debug_pub.add('After call to Update_Payment_TRXN --> Unexpected error');
3929: oe_debug_pub.add('Error message '||sqlerrm);
3930: END IF;
3931: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3932: END;
3933: END IF;
3934: --Operation is Create. Hence need to create a new Trxn extension id
3935: --by calling the Create_trxn_extension API.
3950: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use = 'REQUIRED' AND
3951: p_x_line_Payment_rec.instrument_security_code IS NULL THEN
3952: FND_MESSAGE.SET_NAME('ONT','OE_CC_SECURITY_CODE_REQD');
3953: OE_Msg_Pub.Add;
3954: RAISE FND_API.G_EXC_ERROR;
3955: END IF;
3956: END IF;
3957:
3958: IF NOT OE_GLOBALS.Is_Same_Credit_Card(p_old_line_Payment_rec.credit_card_number,
4011: IF l_debug_level>0 THEN
4012: oe_debug_pub.add('New trxn extension id after calling Create_Payment_TRXN:'||l_trxn_extension_id);
4013: END IF;
4014: Exception
4015: WHEN FND_API.G_EXC_ERROR THEN
4016: OE_MSG_PUB.Count_And_Get
4017: ( p_count => l_msg_count,
4018: p_data => l_msg_data
4019: );
4016: OE_MSG_PUB.Count_And_Get
4017: ( p_count => l_msg_count,
4018: p_data => l_msg_data
4019: );
4020: l_return_status := FND_API.G_RET_STS_ERROR;
4021: RAISE FND_API.G_EXC_ERROR;
4022:
4023: WHEN OTHERS THEN
4024: OE_MSG_PUB.Count_And_Get
4017: ( p_count => l_msg_count,
4018: p_data => l_msg_data
4019: );
4020: l_return_status := FND_API.G_RET_STS_ERROR;
4021: RAISE FND_API.G_EXC_ERROR;
4022:
4023: WHEN OTHERS THEN
4024: OE_MSG_PUB.Count_And_Get
4025: ( p_count => l_msg_count,
4030: IF l_debug_level > 0 THEN
4031: oe_debug_pub.add( 'OEXUHPMB: ERROR IN CREATE PAYMENT trxn...'||sqlerrm) ;
4032: oe_debug_pub.add('Error messsge ksurendr'||l_return_status);
4033: END IF;
4034: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4035: end;
4036: END IF; --Operation
4037: ELSIF p_x_line_payment_rec.payment_type_code IN ('CHECK','CASH') AND
4038: p_x_line_payment_rec.operation = OE_GLOBALS.G_OPR_UPDATE
4057: p_trxn_extension_id => p_old_line_Payment_rec.trxn_extension_id,
4058: P_site_use_id => l_invoice_to_org_id
4059: );
4060:
4061: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4062: RAISE FND_API.G_EXC_ERROR;
4063: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4064: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4065: END IF;
4058: P_site_use_id => l_invoice_to_org_id
4059: );
4060:
4061: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4062: RAISE FND_API.G_EXC_ERROR;
4063: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4064: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4065: END IF;
4066:
4059: );
4060:
4061: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4062: RAISE FND_API.G_EXC_ERROR;
4063: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4064: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4065: END IF;
4066:
4067: IF l_debug_level > 0 THEN
4060:
4061: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4062: RAISE FND_API.G_EXC_ERROR;
4063: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4064: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4065: END IF;
4066:
4067: IF l_debug_level > 0 THEN
4068: oe_debug_pub.add('Successful deletion of trxn extension');
4076: p_x_line_payment_rec.trxn_extension_id := null;
4077: END IF; --Payment type condtion
4078: --R12 CC Encryption
4079: EXCEPTION
4080: WHEN FND_API.G_EXC_ERROR THEN
4081: IF L_DEBUG_LEVEL > 0 THEN
4082: Oe_debug_pub.add('OEXULPMB.pls - pre_write_process error ');
4083: END if;
4084: p_x_line_payment_rec.return_status := FND_API.G_RET_STS_ERROR;
4080: WHEN FND_API.G_EXC_ERROR THEN
4081: IF L_DEBUG_LEVEL > 0 THEN
4082: Oe_debug_pub.add('OEXULPMB.pls - pre_write_process error ');
4083: END if;
4084: p_x_line_payment_rec.return_status := FND_API.G_RET_STS_ERROR;
4085: RAISE FND_API.G_EXC_ERROR;
4086: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4087: IF L_DEBUG_LEVEL > 0 THEN
4088: Oe_debug_pub.add('OEXULPMB.pls - pre_write_process unexpected error ');
4081: IF L_DEBUG_LEVEL > 0 THEN
4082: Oe_debug_pub.add('OEXULPMB.pls - pre_write_process error ');
4083: END if;
4084: p_x_line_payment_rec.return_status := FND_API.G_RET_STS_ERROR;
4085: RAISE FND_API.G_EXC_ERROR;
4086: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4087: IF L_DEBUG_LEVEL > 0 THEN
4088: Oe_debug_pub.add('OEXULPMB.pls - pre_write_process unexpected error ');
4089: END if;
4082: Oe_debug_pub.add('OEXULPMB.pls - pre_write_process error ');
4083: END if;
4084: p_x_line_payment_rec.return_status := FND_API.G_RET_STS_ERROR;
4085: RAISE FND_API.G_EXC_ERROR;
4086: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4087: IF L_DEBUG_LEVEL > 0 THEN
4088: Oe_debug_pub.add('OEXULPMB.pls - pre_write_process unexpected error ');
4089: END if;
4090: p_x_line_payment_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4086: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4087: IF L_DEBUG_LEVEL > 0 THEN
4088: Oe_debug_pub.add('OEXULPMB.pls - pre_write_process unexpected error ');
4089: END if;
4090: p_x_line_payment_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4091: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4092: WHEN OTHERS THEN
4093: if l_debug_level > 0 then
4094: oe_debug_pub.add('OEXULPMB.pls - pre_write_process unexpected error ');
4087: IF L_DEBUG_LEVEL > 0 THEN
4088: Oe_debug_pub.add('OEXULPMB.pls - pre_write_process unexpected error ');
4089: END if;
4090: p_x_line_payment_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4091: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4092: WHEN OTHERS THEN
4093: if l_debug_level > 0 then
4094: oe_debug_pub.add('OEXULPMB.pls - pre_write_process unexpected error ');
4095: end if;
4092: WHEN OTHERS THEN
4093: if l_debug_level > 0 then
4094: oe_debug_pub.add('OEXULPMB.pls - pre_write_process unexpected error ');
4095: end if;
4096: p_x_line_payment_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4097: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4098:
4099: END Pre_Write_Process;
4100:
4093: if l_debug_level > 0 then
4094: oe_debug_pub.add('OEXULPMB.pls - pre_write_process unexpected error ');
4095: end if;
4096: p_x_line_payment_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4097: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4098:
4099: END Pre_Write_Process;
4100:
4101: --3382262
4143: (p_line_id => p_line_id
4144: ,p_x_line_rec => l_old_line_rec
4145: ,x_return_status => l_return_status
4146: );
4147: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4148: RAISE FND_API.G_EXC_ERROR;
4149: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4151: END IF;
4144: ,p_x_line_rec => l_old_line_rec
4145: ,x_return_status => l_return_status
4146: );
4147: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4148: RAISE FND_API.G_EXC_ERROR;
4149: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4151: END IF;
4152:
4145: ,x_return_status => l_return_status
4146: );
4147: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4148: RAISE FND_API.G_EXC_ERROR;
4149: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4151: END IF;
4152:
4153: l_line_rec := l_old_line_rec;
4146: );
4147: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4148: RAISE FND_API.G_EXC_ERROR;
4149: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4151: END IF;
4152:
4153: l_line_rec := l_old_line_rec;
4154:
4189: end if;
4190:
4191: Exception
4192:
4193: WHEN FND_API.G_EXC_ERROR THEN
4194: x_return_status := FND_API.G_RET_STS_ERROR;
4195: OE_MSG_PUB.Count_And_Get
4196: ( p_count => x_msg_count,
4197: p_data => x_msg_data
4190:
4191: Exception
4192:
4193: WHEN FND_API.G_EXC_ERROR THEN
4194: x_return_status := FND_API.G_RET_STS_ERROR;
4195: OE_MSG_PUB.Count_And_Get
4196: ( p_count => x_msg_count,
4197: p_data => x_msg_data
4198: );
4196: ( p_count => x_msg_count,
4197: p_data => x_msg_data
4198: );
4199:
4200: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4202: OE_MSG_PUB.Count_And_Get
4203: ( p_count => x_msg_count,
4204: p_data => x_msg_data
4197: p_data => x_msg_data
4198: );
4199:
4200: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4202: OE_MSG_PUB.Count_And_Get
4203: ( p_count => x_msg_count,
4204: p_data => x_msg_data
4205: );
4204: p_data => x_msg_data
4205: );
4206:
4207: WHEN OTHERS THEN
4208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4209: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4210: THEN
4211: OE_MSG_PUB.Add_Exc_Msg
4212: ( G_PKG_NAME