[Home] [Help]
20: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
21: --
22: BEGIN
23:
24: l_rowtype_rec.ATTRIBUTE1 := FND_API.G_MISS_CHAR;
25: l_rowtype_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
26: l_rowtype_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
27: l_rowtype_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
28: l_rowtype_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
21: --
22: BEGIN
23:
24: l_rowtype_rec.ATTRIBUTE1 := FND_API.G_MISS_CHAR;
25: l_rowtype_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
26: l_rowtype_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
27: l_rowtype_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
28: l_rowtype_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
29: l_rowtype_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
22: BEGIN
23:
24: l_rowtype_rec.ATTRIBUTE1 := FND_API.G_MISS_CHAR;
25: l_rowtype_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
26: l_rowtype_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
27: l_rowtype_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
28: l_rowtype_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
29: l_rowtype_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
30: l_rowtype_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
23:
24: l_rowtype_rec.ATTRIBUTE1 := FND_API.G_MISS_CHAR;
25: l_rowtype_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
26: l_rowtype_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
27: l_rowtype_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
28: l_rowtype_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
29: l_rowtype_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
30: l_rowtype_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
31: l_rowtype_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
24: l_rowtype_rec.ATTRIBUTE1 := FND_API.G_MISS_CHAR;
25: l_rowtype_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
26: l_rowtype_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
27: l_rowtype_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
28: l_rowtype_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
29: l_rowtype_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
30: l_rowtype_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
31: l_rowtype_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
32: l_rowtype_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
25: l_rowtype_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
26: l_rowtype_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
27: l_rowtype_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
28: l_rowtype_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
29: l_rowtype_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
30: l_rowtype_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
31: l_rowtype_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
32: l_rowtype_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
33: l_rowtype_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
26: l_rowtype_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
27: l_rowtype_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
28: l_rowtype_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
29: l_rowtype_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
30: l_rowtype_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
31: l_rowtype_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
32: l_rowtype_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
33: l_rowtype_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
34: l_rowtype_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
27: l_rowtype_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
28: l_rowtype_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
29: l_rowtype_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
30: l_rowtype_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
31: l_rowtype_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
32: l_rowtype_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
33: l_rowtype_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
34: l_rowtype_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
35: l_rowtype_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
28: l_rowtype_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
29: l_rowtype_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
30: l_rowtype_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
31: l_rowtype_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
32: l_rowtype_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
33: l_rowtype_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
34: l_rowtype_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
35: l_rowtype_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
36: l_rowtype_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
29: l_rowtype_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
30: l_rowtype_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
31: l_rowtype_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
32: l_rowtype_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
33: l_rowtype_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
34: l_rowtype_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
35: l_rowtype_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
36: l_rowtype_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
37: l_rowtype_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
30: l_rowtype_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
31: l_rowtype_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
32: l_rowtype_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
33: l_rowtype_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
34: l_rowtype_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
35: l_rowtype_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
36: l_rowtype_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
37: l_rowtype_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
38: l_rowtype_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
31: l_rowtype_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
32: l_rowtype_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
33: l_rowtype_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
34: l_rowtype_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
35: l_rowtype_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
36: l_rowtype_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
37: l_rowtype_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
38: l_rowtype_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
39: l_rowtype_rec.CONTEXT := FND_API.G_MISS_CHAR;
32: l_rowtype_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
33: l_rowtype_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
34: l_rowtype_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
35: l_rowtype_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
36: l_rowtype_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
37: l_rowtype_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
38: l_rowtype_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
39: l_rowtype_rec.CONTEXT := FND_API.G_MISS_CHAR;
40: l_rowtype_rec.CREATED_BY := FND_API.G_MISS_NUM;
33: l_rowtype_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
34: l_rowtype_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
35: l_rowtype_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
36: l_rowtype_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
37: l_rowtype_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
38: l_rowtype_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
39: l_rowtype_rec.CONTEXT := FND_API.G_MISS_CHAR;
40: l_rowtype_rec.CREATED_BY := FND_API.G_MISS_NUM;
41: l_rowtype_rec.CREATION_DATE := FND_API.G_MISS_DATE;
34: l_rowtype_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
35: l_rowtype_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
36: l_rowtype_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
37: l_rowtype_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
38: l_rowtype_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
39: l_rowtype_rec.CONTEXT := FND_API.G_MISS_CHAR;
40: l_rowtype_rec.CREATED_BY := FND_API.G_MISS_NUM;
41: l_rowtype_rec.CREATION_DATE := FND_API.G_MISS_DATE;
42: l_rowtype_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
35: l_rowtype_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
36: l_rowtype_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
37: l_rowtype_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
38: l_rowtype_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
39: l_rowtype_rec.CONTEXT := FND_API.G_MISS_CHAR;
40: l_rowtype_rec.CREATED_BY := FND_API.G_MISS_NUM;
41: l_rowtype_rec.CREATION_DATE := FND_API.G_MISS_DATE;
42: l_rowtype_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
43: l_rowtype_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
36: l_rowtype_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
37: l_rowtype_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
38: l_rowtype_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
39: l_rowtype_rec.CONTEXT := FND_API.G_MISS_CHAR;
40: l_rowtype_rec.CREATED_BY := FND_API.G_MISS_NUM;
41: l_rowtype_rec.CREATION_DATE := FND_API.G_MISS_DATE;
42: l_rowtype_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
43: l_rowtype_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
44: l_rowtype_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
37: l_rowtype_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
38: l_rowtype_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
39: l_rowtype_rec.CONTEXT := FND_API.G_MISS_CHAR;
40: l_rowtype_rec.CREATED_BY := FND_API.G_MISS_NUM;
41: l_rowtype_rec.CREATION_DATE := FND_API.G_MISS_DATE;
42: l_rowtype_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
43: l_rowtype_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
44: l_rowtype_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
45: l_rowtype_rec.CHECK_NUMBER := FND_API.G_MISS_CHAR;
38: l_rowtype_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
39: l_rowtype_rec.CONTEXT := FND_API.G_MISS_CHAR;
40: l_rowtype_rec.CREATED_BY := FND_API.G_MISS_NUM;
41: l_rowtype_rec.CREATION_DATE := FND_API.G_MISS_DATE;
42: l_rowtype_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
43: l_rowtype_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
44: l_rowtype_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
45: l_rowtype_rec.CHECK_NUMBER := FND_API.G_MISS_CHAR;
46: l_rowtype_rec.CREDIT_CARD_APPROVAL_CODE := FND_API.G_MISS_CHAR;
39: l_rowtype_rec.CONTEXT := FND_API.G_MISS_CHAR;
40: l_rowtype_rec.CREATED_BY := FND_API.G_MISS_NUM;
41: l_rowtype_rec.CREATION_DATE := FND_API.G_MISS_DATE;
42: l_rowtype_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
43: l_rowtype_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
44: l_rowtype_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
45: l_rowtype_rec.CHECK_NUMBER := FND_API.G_MISS_CHAR;
46: l_rowtype_rec.CREDIT_CARD_APPROVAL_CODE := FND_API.G_MISS_CHAR;
47: l_rowtype_rec.CREDIT_CARD_APPROVAL_DATE := FND_API.G_MISS_DATE;
40: l_rowtype_rec.CREATED_BY := FND_API.G_MISS_NUM;
41: l_rowtype_rec.CREATION_DATE := FND_API.G_MISS_DATE;
42: l_rowtype_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
43: l_rowtype_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
44: l_rowtype_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
45: l_rowtype_rec.CHECK_NUMBER := FND_API.G_MISS_CHAR;
46: l_rowtype_rec.CREDIT_CARD_APPROVAL_CODE := FND_API.G_MISS_CHAR;
47: l_rowtype_rec.CREDIT_CARD_APPROVAL_DATE := FND_API.G_MISS_DATE;
48: l_rowtype_rec.CREDIT_CARD_CODE := FND_API.G_MISS_CHAR;
41: l_rowtype_rec.CREATION_DATE := FND_API.G_MISS_DATE;
42: l_rowtype_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
43: l_rowtype_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
44: l_rowtype_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
45: l_rowtype_rec.CHECK_NUMBER := FND_API.G_MISS_CHAR;
46: l_rowtype_rec.CREDIT_CARD_APPROVAL_CODE := FND_API.G_MISS_CHAR;
47: l_rowtype_rec.CREDIT_CARD_APPROVAL_DATE := FND_API.G_MISS_DATE;
48: l_rowtype_rec.CREDIT_CARD_CODE := FND_API.G_MISS_CHAR;
49: l_rowtype_rec.CREDIT_CARD_EXPIRATION_DATE := FND_API.G_MISS_DATE;
42: l_rowtype_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
43: l_rowtype_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
44: l_rowtype_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
45: l_rowtype_rec.CHECK_NUMBER := FND_API.G_MISS_CHAR;
46: l_rowtype_rec.CREDIT_CARD_APPROVAL_CODE := FND_API.G_MISS_CHAR;
47: l_rowtype_rec.CREDIT_CARD_APPROVAL_DATE := FND_API.G_MISS_DATE;
48: l_rowtype_rec.CREDIT_CARD_CODE := FND_API.G_MISS_CHAR;
49: l_rowtype_rec.CREDIT_CARD_EXPIRATION_DATE := FND_API.G_MISS_DATE;
50: l_rowtype_rec.CREDIT_CARD_HOLDER_NAME := FND_API.G_MISS_CHAR;
43: l_rowtype_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
44: l_rowtype_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
45: l_rowtype_rec.CHECK_NUMBER := FND_API.G_MISS_CHAR;
46: l_rowtype_rec.CREDIT_CARD_APPROVAL_CODE := FND_API.G_MISS_CHAR;
47: l_rowtype_rec.CREDIT_CARD_APPROVAL_DATE := FND_API.G_MISS_DATE;
48: l_rowtype_rec.CREDIT_CARD_CODE := FND_API.G_MISS_CHAR;
49: l_rowtype_rec.CREDIT_CARD_EXPIRATION_DATE := FND_API.G_MISS_DATE;
50: l_rowtype_rec.CREDIT_CARD_HOLDER_NAME := FND_API.G_MISS_CHAR;
51: l_rowtype_rec.CREDIT_CARD_NUMBER := FND_API.G_MISS_CHAR;
44: l_rowtype_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
45: l_rowtype_rec.CHECK_NUMBER := FND_API.G_MISS_CHAR;
46: l_rowtype_rec.CREDIT_CARD_APPROVAL_CODE := FND_API.G_MISS_CHAR;
47: l_rowtype_rec.CREDIT_CARD_APPROVAL_DATE := FND_API.G_MISS_DATE;
48: l_rowtype_rec.CREDIT_CARD_CODE := FND_API.G_MISS_CHAR;
49: l_rowtype_rec.CREDIT_CARD_EXPIRATION_DATE := FND_API.G_MISS_DATE;
50: l_rowtype_rec.CREDIT_CARD_HOLDER_NAME := FND_API.G_MISS_CHAR;
51: l_rowtype_rec.CREDIT_CARD_NUMBER := FND_API.G_MISS_CHAR;
52: l_rowtype_rec.PAYMENT_LEVEL_CODE := FND_API.G_MISS_CHAR;
45: l_rowtype_rec.CHECK_NUMBER := FND_API.G_MISS_CHAR;
46: l_rowtype_rec.CREDIT_CARD_APPROVAL_CODE := FND_API.G_MISS_CHAR;
47: l_rowtype_rec.CREDIT_CARD_APPROVAL_DATE := FND_API.G_MISS_DATE;
48: l_rowtype_rec.CREDIT_CARD_CODE := FND_API.G_MISS_CHAR;
49: l_rowtype_rec.CREDIT_CARD_EXPIRATION_DATE := FND_API.G_MISS_DATE;
50: l_rowtype_rec.CREDIT_CARD_HOLDER_NAME := FND_API.G_MISS_CHAR;
51: l_rowtype_rec.CREDIT_CARD_NUMBER := FND_API.G_MISS_CHAR;
52: l_rowtype_rec.PAYMENT_LEVEL_CODE := FND_API.G_MISS_CHAR;
53: l_rowtype_rec.COMMITMENT_APPLIED_AMOUNT := FND_API.G_MISS_NUM;
46: l_rowtype_rec.CREDIT_CARD_APPROVAL_CODE := FND_API.G_MISS_CHAR;
47: l_rowtype_rec.CREDIT_CARD_APPROVAL_DATE := FND_API.G_MISS_DATE;
48: l_rowtype_rec.CREDIT_CARD_CODE := FND_API.G_MISS_CHAR;
49: l_rowtype_rec.CREDIT_CARD_EXPIRATION_DATE := FND_API.G_MISS_DATE;
50: l_rowtype_rec.CREDIT_CARD_HOLDER_NAME := FND_API.G_MISS_CHAR;
51: l_rowtype_rec.CREDIT_CARD_NUMBER := FND_API.G_MISS_CHAR;
52: l_rowtype_rec.PAYMENT_LEVEL_CODE := FND_API.G_MISS_CHAR;
53: l_rowtype_rec.COMMITMENT_APPLIED_AMOUNT := FND_API.G_MISS_NUM;
54: l_rowtype_rec.COMMITMENT_INTERFACED_AMOUNT := FND_API.G_MISS_NUM;
47: l_rowtype_rec.CREDIT_CARD_APPROVAL_DATE := FND_API.G_MISS_DATE;
48: l_rowtype_rec.CREDIT_CARD_CODE := FND_API.G_MISS_CHAR;
49: l_rowtype_rec.CREDIT_CARD_EXPIRATION_DATE := FND_API.G_MISS_DATE;
50: l_rowtype_rec.CREDIT_CARD_HOLDER_NAME := FND_API.G_MISS_CHAR;
51: l_rowtype_rec.CREDIT_CARD_NUMBER := FND_API.G_MISS_CHAR;
52: l_rowtype_rec.PAYMENT_LEVEL_CODE := FND_API.G_MISS_CHAR;
53: l_rowtype_rec.COMMITMENT_APPLIED_AMOUNT := FND_API.G_MISS_NUM;
54: l_rowtype_rec.COMMITMENT_INTERFACED_AMOUNT := FND_API.G_MISS_NUM;
55: l_rowtype_rec.PAYMENT_NUMBER := FND_API.G_MISS_NUM;
48: l_rowtype_rec.CREDIT_CARD_CODE := FND_API.G_MISS_CHAR;
49: l_rowtype_rec.CREDIT_CARD_EXPIRATION_DATE := FND_API.G_MISS_DATE;
50: l_rowtype_rec.CREDIT_CARD_HOLDER_NAME := FND_API.G_MISS_CHAR;
51: l_rowtype_rec.CREDIT_CARD_NUMBER := FND_API.G_MISS_CHAR;
52: l_rowtype_rec.PAYMENT_LEVEL_CODE := FND_API.G_MISS_CHAR;
53: l_rowtype_rec.COMMITMENT_APPLIED_AMOUNT := FND_API.G_MISS_NUM;
54: l_rowtype_rec.COMMITMENT_INTERFACED_AMOUNT := FND_API.G_MISS_NUM;
55: l_rowtype_rec.PAYMENT_NUMBER := FND_API.G_MISS_NUM;
56: l_rowtype_rec.HEADER_ID := FND_API.G_MISS_NUM;
49: l_rowtype_rec.CREDIT_CARD_EXPIRATION_DATE := FND_API.G_MISS_DATE;
50: l_rowtype_rec.CREDIT_CARD_HOLDER_NAME := FND_API.G_MISS_CHAR;
51: l_rowtype_rec.CREDIT_CARD_NUMBER := FND_API.G_MISS_CHAR;
52: l_rowtype_rec.PAYMENT_LEVEL_CODE := FND_API.G_MISS_CHAR;
53: l_rowtype_rec.COMMITMENT_APPLIED_AMOUNT := FND_API.G_MISS_NUM;
54: l_rowtype_rec.COMMITMENT_INTERFACED_AMOUNT := FND_API.G_MISS_NUM;
55: l_rowtype_rec.PAYMENT_NUMBER := FND_API.G_MISS_NUM;
56: l_rowtype_rec.HEADER_ID := FND_API.G_MISS_NUM;
57: l_rowtype_rec.LINE_ID := FND_API.G_MISS_NUM;
50: l_rowtype_rec.CREDIT_CARD_HOLDER_NAME := FND_API.G_MISS_CHAR;
51: l_rowtype_rec.CREDIT_CARD_NUMBER := FND_API.G_MISS_CHAR;
52: l_rowtype_rec.PAYMENT_LEVEL_CODE := FND_API.G_MISS_CHAR;
53: l_rowtype_rec.COMMITMENT_APPLIED_AMOUNT := FND_API.G_MISS_NUM;
54: l_rowtype_rec.COMMITMENT_INTERFACED_AMOUNT := FND_API.G_MISS_NUM;
55: l_rowtype_rec.PAYMENT_NUMBER := FND_API.G_MISS_NUM;
56: l_rowtype_rec.HEADER_ID := FND_API.G_MISS_NUM;
57: l_rowtype_rec.LINE_ID := FND_API.G_MISS_NUM;
58: l_rowtype_rec.PAYMENT_AMOUNT := FND_API.G_MISS_NUM;
51: l_rowtype_rec.CREDIT_CARD_NUMBER := FND_API.G_MISS_CHAR;
52: l_rowtype_rec.PAYMENT_LEVEL_CODE := FND_API.G_MISS_CHAR;
53: l_rowtype_rec.COMMITMENT_APPLIED_AMOUNT := FND_API.G_MISS_NUM;
54: l_rowtype_rec.COMMITMENT_INTERFACED_AMOUNT := FND_API.G_MISS_NUM;
55: l_rowtype_rec.PAYMENT_NUMBER := FND_API.G_MISS_NUM;
56: l_rowtype_rec.HEADER_ID := FND_API.G_MISS_NUM;
57: l_rowtype_rec.LINE_ID := FND_API.G_MISS_NUM;
58: l_rowtype_rec.PAYMENT_AMOUNT := FND_API.G_MISS_NUM;
59: l_rowtype_rec.PAYMENT_COLLECTION_EVENT := FND_API.G_MISS_CHAR;
52: l_rowtype_rec.PAYMENT_LEVEL_CODE := FND_API.G_MISS_CHAR;
53: l_rowtype_rec.COMMITMENT_APPLIED_AMOUNT := FND_API.G_MISS_NUM;
54: l_rowtype_rec.COMMITMENT_INTERFACED_AMOUNT := FND_API.G_MISS_NUM;
55: l_rowtype_rec.PAYMENT_NUMBER := FND_API.G_MISS_NUM;
56: l_rowtype_rec.HEADER_ID := FND_API.G_MISS_NUM;
57: l_rowtype_rec.LINE_ID := FND_API.G_MISS_NUM;
58: l_rowtype_rec.PAYMENT_AMOUNT := FND_API.G_MISS_NUM;
59: l_rowtype_rec.PAYMENT_COLLECTION_EVENT := FND_API.G_MISS_CHAR;
60: l_rowtype_rec.PAYMENT_TRX_ID := FND_API.G_MISS_NUM;
53: l_rowtype_rec.COMMITMENT_APPLIED_AMOUNT := FND_API.G_MISS_NUM;
54: l_rowtype_rec.COMMITMENT_INTERFACED_AMOUNT := FND_API.G_MISS_NUM;
55: l_rowtype_rec.PAYMENT_NUMBER := FND_API.G_MISS_NUM;
56: l_rowtype_rec.HEADER_ID := FND_API.G_MISS_NUM;
57: l_rowtype_rec.LINE_ID := FND_API.G_MISS_NUM;
58: l_rowtype_rec.PAYMENT_AMOUNT := FND_API.G_MISS_NUM;
59: l_rowtype_rec.PAYMENT_COLLECTION_EVENT := FND_API.G_MISS_CHAR;
60: l_rowtype_rec.PAYMENT_TRX_ID := FND_API.G_MISS_NUM;
61: l_rowtype_rec.PAYMENT_TYPE_CODE := FND_API.G_MISS_CHAR;
54: l_rowtype_rec.COMMITMENT_INTERFACED_AMOUNT := FND_API.G_MISS_NUM;
55: l_rowtype_rec.PAYMENT_NUMBER := FND_API.G_MISS_NUM;
56: l_rowtype_rec.HEADER_ID := FND_API.G_MISS_NUM;
57: l_rowtype_rec.LINE_ID := FND_API.G_MISS_NUM;
58: l_rowtype_rec.PAYMENT_AMOUNT := FND_API.G_MISS_NUM;
59: l_rowtype_rec.PAYMENT_COLLECTION_EVENT := FND_API.G_MISS_CHAR;
60: l_rowtype_rec.PAYMENT_TRX_ID := FND_API.G_MISS_NUM;
61: l_rowtype_rec.PAYMENT_TYPE_CODE := FND_API.G_MISS_CHAR;
62: l_rowtype_rec.PAYMENT_SET_ID := FND_API.G_MISS_NUM;
55: l_rowtype_rec.PAYMENT_NUMBER := FND_API.G_MISS_NUM;
56: l_rowtype_rec.HEADER_ID := FND_API.G_MISS_NUM;
57: l_rowtype_rec.LINE_ID := FND_API.G_MISS_NUM;
58: l_rowtype_rec.PAYMENT_AMOUNT := FND_API.G_MISS_NUM;
59: l_rowtype_rec.PAYMENT_COLLECTION_EVENT := FND_API.G_MISS_CHAR;
60: l_rowtype_rec.PAYMENT_TRX_ID := FND_API.G_MISS_NUM;
61: l_rowtype_rec.PAYMENT_TYPE_CODE := FND_API.G_MISS_CHAR;
62: l_rowtype_rec.PAYMENT_SET_ID := FND_API.G_MISS_NUM;
63: l_rowtype_rec.PREPAID_AMOUNT := FND_API.G_MISS_NUM;
56: l_rowtype_rec.HEADER_ID := FND_API.G_MISS_NUM;
57: l_rowtype_rec.LINE_ID := FND_API.G_MISS_NUM;
58: l_rowtype_rec.PAYMENT_AMOUNT := FND_API.G_MISS_NUM;
59: l_rowtype_rec.PAYMENT_COLLECTION_EVENT := FND_API.G_MISS_CHAR;
60: l_rowtype_rec.PAYMENT_TRX_ID := FND_API.G_MISS_NUM;
61: l_rowtype_rec.PAYMENT_TYPE_CODE := FND_API.G_MISS_CHAR;
62: l_rowtype_rec.PAYMENT_SET_ID := FND_API.G_MISS_NUM;
63: l_rowtype_rec.PREPAID_AMOUNT := FND_API.G_MISS_NUM;
64: l_rowtype_rec.PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;
57: l_rowtype_rec.LINE_ID := FND_API.G_MISS_NUM;
58: l_rowtype_rec.PAYMENT_AMOUNT := FND_API.G_MISS_NUM;
59: l_rowtype_rec.PAYMENT_COLLECTION_EVENT := FND_API.G_MISS_CHAR;
60: l_rowtype_rec.PAYMENT_TRX_ID := FND_API.G_MISS_NUM;
61: l_rowtype_rec.PAYMENT_TYPE_CODE := FND_API.G_MISS_CHAR;
62: l_rowtype_rec.PAYMENT_SET_ID := FND_API.G_MISS_NUM;
63: l_rowtype_rec.PREPAID_AMOUNT := FND_API.G_MISS_NUM;
64: l_rowtype_rec.PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;
65: l_rowtype_rec.PROGRAM_ID := FND_API.G_MISS_NUM;
58: l_rowtype_rec.PAYMENT_AMOUNT := FND_API.G_MISS_NUM;
59: l_rowtype_rec.PAYMENT_COLLECTION_EVENT := FND_API.G_MISS_CHAR;
60: l_rowtype_rec.PAYMENT_TRX_ID := FND_API.G_MISS_NUM;
61: l_rowtype_rec.PAYMENT_TYPE_CODE := FND_API.G_MISS_CHAR;
62: l_rowtype_rec.PAYMENT_SET_ID := FND_API.G_MISS_NUM;
63: l_rowtype_rec.PREPAID_AMOUNT := FND_API.G_MISS_NUM;
64: l_rowtype_rec.PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;
65: l_rowtype_rec.PROGRAM_ID := FND_API.G_MISS_NUM;
66: l_rowtype_rec.PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
59: l_rowtype_rec.PAYMENT_COLLECTION_EVENT := FND_API.G_MISS_CHAR;
60: l_rowtype_rec.PAYMENT_TRX_ID := FND_API.G_MISS_NUM;
61: l_rowtype_rec.PAYMENT_TYPE_CODE := FND_API.G_MISS_CHAR;
62: l_rowtype_rec.PAYMENT_SET_ID := FND_API.G_MISS_NUM;
63: l_rowtype_rec.PREPAID_AMOUNT := FND_API.G_MISS_NUM;
64: l_rowtype_rec.PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;
65: l_rowtype_rec.PROGRAM_ID := FND_API.G_MISS_NUM;
66: l_rowtype_rec.PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
67: l_rowtype_rec.RECEIPT_METHOD_ID := FND_API.G_MISS_NUM;
60: l_rowtype_rec.PAYMENT_TRX_ID := FND_API.G_MISS_NUM;
61: l_rowtype_rec.PAYMENT_TYPE_CODE := FND_API.G_MISS_CHAR;
62: l_rowtype_rec.PAYMENT_SET_ID := FND_API.G_MISS_NUM;
63: l_rowtype_rec.PREPAID_AMOUNT := FND_API.G_MISS_NUM;
64: l_rowtype_rec.PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;
65: l_rowtype_rec.PROGRAM_ID := FND_API.G_MISS_NUM;
66: l_rowtype_rec.PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
67: l_rowtype_rec.RECEIPT_METHOD_ID := FND_API.G_MISS_NUM;
68: l_rowtype_rec.REQUEST_ID := FND_API.G_MISS_NUM;
61: l_rowtype_rec.PAYMENT_TYPE_CODE := FND_API.G_MISS_CHAR;
62: l_rowtype_rec.PAYMENT_SET_ID := FND_API.G_MISS_NUM;
63: l_rowtype_rec.PREPAID_AMOUNT := FND_API.G_MISS_NUM;
64: l_rowtype_rec.PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;
65: l_rowtype_rec.PROGRAM_ID := FND_API.G_MISS_NUM;
66: l_rowtype_rec.PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
67: l_rowtype_rec.RECEIPT_METHOD_ID := FND_API.G_MISS_NUM;
68: l_rowtype_rec.REQUEST_ID := FND_API.G_MISS_NUM;
69: l_rowtype_rec.TANGIBLE_ID := FND_API.G_MISS_CHAR;
62: l_rowtype_rec.PAYMENT_SET_ID := FND_API.G_MISS_NUM;
63: l_rowtype_rec.PREPAID_AMOUNT := FND_API.G_MISS_NUM;
64: l_rowtype_rec.PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;
65: l_rowtype_rec.PROGRAM_ID := FND_API.G_MISS_NUM;
66: l_rowtype_rec.PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
67: l_rowtype_rec.RECEIPT_METHOD_ID := FND_API.G_MISS_NUM;
68: l_rowtype_rec.REQUEST_ID := FND_API.G_MISS_NUM;
69: l_rowtype_rec.TANGIBLE_ID := FND_API.G_MISS_CHAR;
70: l_rowtype_rec.RETURN_STATUS := FND_API.G_MISS_CHAR;
63: l_rowtype_rec.PREPAID_AMOUNT := FND_API.G_MISS_NUM;
64: l_rowtype_rec.PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;
65: l_rowtype_rec.PROGRAM_ID := FND_API.G_MISS_NUM;
66: l_rowtype_rec.PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
67: l_rowtype_rec.RECEIPT_METHOD_ID := FND_API.G_MISS_NUM;
68: l_rowtype_rec.REQUEST_ID := FND_API.G_MISS_NUM;
69: l_rowtype_rec.TANGIBLE_ID := FND_API.G_MISS_CHAR;
70: l_rowtype_rec.RETURN_STATUS := FND_API.G_MISS_CHAR;
71: l_rowtype_rec.DB_FLAG := FND_API.G_MISS_CHAR;
64: l_rowtype_rec.PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;
65: l_rowtype_rec.PROGRAM_ID := FND_API.G_MISS_NUM;
66: l_rowtype_rec.PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
67: l_rowtype_rec.RECEIPT_METHOD_ID := FND_API.G_MISS_NUM;
68: l_rowtype_rec.REQUEST_ID := FND_API.G_MISS_NUM;
69: l_rowtype_rec.TANGIBLE_ID := FND_API.G_MISS_CHAR;
70: l_rowtype_rec.RETURN_STATUS := FND_API.G_MISS_CHAR;
71: l_rowtype_rec.DB_FLAG := FND_API.G_MISS_CHAR;
72: l_rowtype_rec.OPERATION := FND_API.G_MISS_CHAR;
65: l_rowtype_rec.PROGRAM_ID := FND_API.G_MISS_NUM;
66: l_rowtype_rec.PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
67: l_rowtype_rec.RECEIPT_METHOD_ID := FND_API.G_MISS_NUM;
68: l_rowtype_rec.REQUEST_ID := FND_API.G_MISS_NUM;
69: l_rowtype_rec.TANGIBLE_ID := FND_API.G_MISS_CHAR;
70: l_rowtype_rec.RETURN_STATUS := FND_API.G_MISS_CHAR;
71: l_rowtype_rec.DB_FLAG := FND_API.G_MISS_CHAR;
72: l_rowtype_rec.OPERATION := FND_API.G_MISS_CHAR;
73:
66: l_rowtype_rec.PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
67: l_rowtype_rec.RECEIPT_METHOD_ID := FND_API.G_MISS_NUM;
68: l_rowtype_rec.REQUEST_ID := FND_API.G_MISS_NUM;
69: l_rowtype_rec.TANGIBLE_ID := FND_API.G_MISS_CHAR;
70: l_rowtype_rec.RETURN_STATUS := FND_API.G_MISS_CHAR;
71: l_rowtype_rec.DB_FLAG := FND_API.G_MISS_CHAR;
72: l_rowtype_rec.OPERATION := FND_API.G_MISS_CHAR;
73:
74: RETURN l_rowtype_rec;
67: l_rowtype_rec.RECEIPT_METHOD_ID := FND_API.G_MISS_NUM;
68: l_rowtype_rec.REQUEST_ID := FND_API.G_MISS_NUM;
69: l_rowtype_rec.TANGIBLE_ID := FND_API.G_MISS_CHAR;
70: l_rowtype_rec.RETURN_STATUS := FND_API.G_MISS_CHAR;
71: l_rowtype_rec.DB_FLAG := FND_API.G_MISS_CHAR;
72: l_rowtype_rec.OPERATION := FND_API.G_MISS_CHAR;
73:
74: RETURN l_rowtype_rec;
75:
68: l_rowtype_rec.REQUEST_ID := FND_API.G_MISS_NUM;
69: l_rowtype_rec.TANGIBLE_ID := FND_API.G_MISS_CHAR;
70: l_rowtype_rec.RETURN_STATUS := FND_API.G_MISS_CHAR;
71: l_rowtype_rec.DB_FLAG := FND_API.G_MISS_CHAR;
72: l_rowtype_rec.OPERATION := FND_API.G_MISS_CHAR;
73:
74: RETURN l_rowtype_rec;
75:
76: END G_MISS_OE_AK_HPAYMENT_REC;
199:
200: -- Procedure Clear_Dependent_Attr
201:
202: PROCEDURE Clear_Dependent_Attr
203: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
204: , p_x_Header_Payment_rec IN OUT NOCOPY OE_AK_HEADER_PAYMENTS_V%ROWTYPE
205: , p_old_Header_Payment_rec IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE :=
206: G_MISS_OE_AK_HPayment_REC
207: , p_x_instrument_id IN NUMBER DEFAULT NULL --R12 CC Encryption
222:
223: -- If attr_id is missing compare old and new records and for
224: -- every changed attribute clear its dependent fields.
225:
226: IF p_attr_id = FND_API.G_MISS_NUM THEN
227:
228: IF NOT OE_GLOBALS.Equal(p_x_Header_Payment_rec.attribute1,p_old_Header_Payment_rec.attribute1)
229: THEN
230: l_index := l_index + 1;
656: p_dep_attr_tbl => l_dep_attr_tbl);
657:
658: FOR I IN 1..l_dep_attr_tbl.COUNT LOOP
659: IF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE1 THEN
660: p_x_Header_PAYMENT_rec.ATTRIBUTE1 := FND_API.G_MISS_NUM;
661: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE2 THEN
662: p_x_Header_PAYMENT_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
663: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE3 THEN
664: p_x_Header_PAYMENT_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
658: FOR I IN 1..l_dep_attr_tbl.COUNT LOOP
659: IF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE1 THEN
660: p_x_Header_PAYMENT_rec.ATTRIBUTE1 := FND_API.G_MISS_NUM;
661: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE2 THEN
662: p_x_Header_PAYMENT_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
663: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE3 THEN
664: p_x_Header_PAYMENT_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
665: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE4 THEN
666: p_x_Header_PAYMENT_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
660: p_x_Header_PAYMENT_rec.ATTRIBUTE1 := FND_API.G_MISS_NUM;
661: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE2 THEN
662: p_x_Header_PAYMENT_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
663: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE3 THEN
664: p_x_Header_PAYMENT_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
665: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE4 THEN
666: p_x_Header_PAYMENT_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
667: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE5 THEN
668: p_x_Header_PAYMENT_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
662: p_x_Header_PAYMENT_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
663: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE3 THEN
664: p_x_Header_PAYMENT_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
665: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE4 THEN
666: p_x_Header_PAYMENT_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
667: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE5 THEN
668: p_x_Header_PAYMENT_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
669: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE6 THEN
670: p_x_Header_PAYMENT_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
664: p_x_Header_PAYMENT_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
665: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE4 THEN
666: p_x_Header_PAYMENT_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
667: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE5 THEN
668: p_x_Header_PAYMENT_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
669: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE6 THEN
670: p_x_Header_PAYMENT_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
671: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE7 THEN
672: p_x_Header_PAYMENT_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
666: p_x_Header_PAYMENT_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
667: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE5 THEN
668: p_x_Header_PAYMENT_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
669: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE6 THEN
670: p_x_Header_PAYMENT_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
671: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE7 THEN
672: p_x_Header_PAYMENT_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
673: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE8 THEN
674: p_x_Header_PAYMENT_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
668: p_x_Header_PAYMENT_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
669: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE6 THEN
670: p_x_Header_PAYMENT_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
671: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE7 THEN
672: p_x_Header_PAYMENT_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
673: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE8 THEN
674: p_x_Header_PAYMENT_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
675: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE9 THEN
676: p_x_Header_PAYMENT_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
670: p_x_Header_PAYMENT_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
671: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE7 THEN
672: p_x_Header_PAYMENT_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
673: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE8 THEN
674: p_x_Header_PAYMENT_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
675: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE9 THEN
676: p_x_Header_PAYMENT_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
677: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE10 THEN
678: p_x_Header_PAYMENT_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
672: p_x_Header_PAYMENT_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
673: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE8 THEN
674: p_x_Header_PAYMENT_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
675: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE9 THEN
676: p_x_Header_PAYMENT_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
677: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE10 THEN
678: p_x_Header_PAYMENT_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
679: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE11 THEN
680: p_x_Header_PAYMENT_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
674: p_x_Header_PAYMENT_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
675: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE9 THEN
676: p_x_Header_PAYMENT_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
677: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE10 THEN
678: p_x_Header_PAYMENT_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
679: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE11 THEN
680: p_x_Header_PAYMENT_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
681: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE12 THEN
682: p_x_Header_PAYMENT_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
676: p_x_Header_PAYMENT_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
677: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE10 THEN
678: p_x_Header_PAYMENT_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
679: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE11 THEN
680: p_x_Header_PAYMENT_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
681: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE12 THEN
682: p_x_Header_PAYMENT_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
683: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE13 THEN
684: p_x_Header_PAYMENT_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
678: p_x_Header_PAYMENT_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
679: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE11 THEN
680: p_x_Header_PAYMENT_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
681: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE12 THEN
682: p_x_Header_PAYMENT_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
683: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE13 THEN
684: p_x_Header_PAYMENT_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
685: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE14 THEN
686: p_x_Header_PAYMENT_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
680: p_x_Header_PAYMENT_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
681: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE12 THEN
682: p_x_Header_PAYMENT_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
683: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE13 THEN
684: p_x_Header_PAYMENT_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
685: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE14 THEN
686: p_x_Header_PAYMENT_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
687: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE15 THEN
688: p_x_Header_PAYMENT_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
682: p_x_Header_PAYMENT_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
683: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE13 THEN
684: p_x_Header_PAYMENT_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
685: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE14 THEN
686: p_x_Header_PAYMENT_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
687: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE15 THEN
688: p_x_Header_PAYMENT_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
689: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_CONTEXT THEN
690: p_x_Header_PAYMENT_rec.CONTEXT := FND_API.G_MISS_CHAR;
684: p_x_Header_PAYMENT_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
685: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE14 THEN
686: p_x_Header_PAYMENT_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
687: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE15 THEN
688: p_x_Header_PAYMENT_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
689: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_CONTEXT THEN
690: p_x_Header_PAYMENT_rec.CONTEXT := FND_API.G_MISS_CHAR;
691: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_CREATED_BY THEN
692: p_x_Header_PAYMENT_rec.CREATED_BY := FND_API.G_MISS_NUM;
686: p_x_Header_PAYMENT_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
687: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_ATTRIBUTE15 THEN
688: p_x_Header_PAYMENT_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
689: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_CONTEXT THEN
690: p_x_Header_PAYMENT_rec.CONTEXT := FND_API.G_MISS_CHAR;
691: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_CREATED_BY THEN
692: p_x_Header_PAYMENT_rec.CREATED_BY := FND_API.G_MISS_NUM;
693: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_CREATION_DATE THEN
694: p_x_Header_PAYMENT_rec.CREATION_DATE := FND_API.G_MISS_DATE;
688: p_x_Header_PAYMENT_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
689: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_CONTEXT THEN
690: p_x_Header_PAYMENT_rec.CONTEXT := FND_API.G_MISS_CHAR;
691: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_CREATED_BY THEN
692: p_x_Header_PAYMENT_rec.CREATED_BY := FND_API.G_MISS_NUM;
693: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_CREATION_DATE THEN
694: p_x_Header_PAYMENT_rec.CREATION_DATE := FND_API.G_MISS_DATE;
695: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_LAST_UPDATED_BY THEN
696: p_x_Header_PAYMENT_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
690: p_x_Header_PAYMENT_rec.CONTEXT := FND_API.G_MISS_CHAR;
691: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_CREATED_BY THEN
692: p_x_Header_PAYMENT_rec.CREATED_BY := FND_API.G_MISS_NUM;
693: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_CREATION_DATE THEN
694: p_x_Header_PAYMENT_rec.CREATION_DATE := FND_API.G_MISS_DATE;
695: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_LAST_UPDATED_BY THEN
696: p_x_Header_PAYMENT_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
697: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_LAST_UPDATE_DATE THEN
698: p_x_Header_PAYMENT_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
692: p_x_Header_PAYMENT_rec.CREATED_BY := FND_API.G_MISS_NUM;
693: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_CREATION_DATE THEN
694: p_x_Header_PAYMENT_rec.CREATION_DATE := FND_API.G_MISS_DATE;
695: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_LAST_UPDATED_BY THEN
696: p_x_Header_PAYMENT_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
697: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_LAST_UPDATE_DATE THEN
698: p_x_Header_PAYMENT_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
699: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_LAST_UPDATE_LOGIN THEN
700: p_x_Header_PAYMENT_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
694: p_x_Header_PAYMENT_rec.CREATION_DATE := FND_API.G_MISS_DATE;
695: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_LAST_UPDATED_BY THEN
696: p_x_Header_PAYMENT_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
697: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_LAST_UPDATE_DATE THEN
698: p_x_Header_PAYMENT_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
699: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_LAST_UPDATE_LOGIN THEN
700: p_x_Header_PAYMENT_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
701: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_CHECK_NUMBER THEN
702: p_x_Header_PAYMENT_rec.CHECK_NUMBER := FND_API.G_MISS_CHAR;
696: p_x_Header_PAYMENT_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
697: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_LAST_UPDATE_DATE THEN
698: p_x_Header_PAYMENT_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
699: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_LAST_UPDATE_LOGIN THEN
700: p_x_Header_PAYMENT_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
701: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_CHECK_NUMBER THEN
702: p_x_Header_PAYMENT_rec.CHECK_NUMBER := FND_API.G_MISS_CHAR;
703: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_CREDIT_CARD_APPROVAL_CODE THEN
704: --R12 CC Encryption
698: p_x_Header_PAYMENT_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
699: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_LAST_UPDATE_LOGIN THEN
700: p_x_Header_PAYMENT_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
701: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_CHECK_NUMBER THEN
702: p_x_Header_PAYMENT_rec.CHECK_NUMBER := FND_API.G_MISS_CHAR;
703: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_CREDIT_CARD_APPROVAL_CODE THEN
704: --R12 CC Encryption
705: --Added the additional conditional before clearing credit
706: --card attributes as the dependent attributes were cleared out
710: AND (p_old_Header_Payment_rec.header_id IS NOT NULL OR
711: p_x_Header_PAYMENT_rec.CREDIT_CARD_APPROVAL_CODE IS NOT NULL)
712: ) -- AND condition added to fix 3098878
713: THEN
714: p_x_Header_PAYMENT_rec.CREDIT_CARD_APPROVAL_CODE := FND_API.G_MISS_CHAR;
715: END IF;
716: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_CREDIT_CARD_APPROVAL_DATE THEN
717: IF (OE_GLOBALS.Equal(p_x_Header_PAYMENT_rec.CREDIT_CARD_APPROVAL_DATE, p_old_Header_Payment_rec.CREDIT_CARD_APPROVAL_DATE)
718: AND (p_old_Header_Payment_rec.header_id IS NOT NULL OR
718: AND (p_old_Header_Payment_rec.header_id IS NOT NULL OR
719: p_x_Header_PAYMENT_rec.CREDIT_CARD_APPROVAL_DATE IS NOT NULL)
720: ) -- AND condition added to fix 3098878
721: THEN
722: p_x_Header_PAYMENT_rec.CREDIT_CARD_APPROVAL_DATE := FND_API.G_MISS_DATE;
723: END IF;
724: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_CREDIT_CARD_CODE THEN
725: IF (OE_GLOBALS.Equal(p_x_Header_PAYMENT_rec.CREDIT_CARD_CODE, p_old_Header_Payment_rec.CREDIT_CARD_CODE)
726: AND (p_old_Header_Payment_rec.header_id IS NOT NULL OR
726: AND (p_old_Header_Payment_rec.header_id IS NOT NULL OR
727: p_x_Header_PAYMENT_rec.CREDIT_CARD_CODE IS NOT NULL)
728: ) -- AND condition added to fix 3098878
729: THEN
730: p_x_Header_PAYMENT_rec.CREDIT_CARD_CODE := FND_API.G_MISS_CHAR;
731: END IF;
732: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_CREDIT_CARD_EXPIRATION_DATE THEN
733: IF (OE_GLOBALS.Equal(p_x_Header_PAYMENT_rec.CREDIT_CARD_EXPIRATION_DATE, p_old_Header_Payment_rec.CREDIT_CARD_EXPIRATION_DATE)
734: AND (p_old_Header_Payment_rec.header_id IS NOT NULL OR
734: AND (p_old_Header_Payment_rec.header_id IS NOT NULL OR
735: p_x_Header_PAYMENT_rec.CREDIT_CARD_EXPIRATION_DATE IS NOT NULL)
736: ) -- AND condition added to fix 3098878
737: THEN
738: p_x_Header_PAYMENT_rec.CREDIT_CARD_EXPIRATION_DATE := FND_API.G_MISS_DATE;
739: END IF;
740: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_CREDIT_CARD_HOLDER_NAME THEN
741: IF (OE_GLOBALS.Equal(p_x_Header_PAYMENT_rec.credit_card_holder_name, p_old_Header_Payment_rec.credit_card_holder_name)
742: AND (p_old_Header_Payment_rec.header_id IS NOT NULL OR
742: AND (p_old_Header_Payment_rec.header_id IS NOT NULL OR
743: p_x_Header_PAYMENT_rec.credit_card_holder_name IS NOT NULL)
744: ) -- AND condition added to fix 3098878
745: THEN
746: p_x_Header_PAYMENT_rec.CREDIT_CARD_HOLDER_NAME := FND_API.G_MISS_CHAR;
747: END IF;
748: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_CREDIT_CARD_NUMBER THEN
749: IF (OE_GLOBALS.Is_Same_Credit_Card(p_old_Header_Payment_rec.CREDIT_CARD_NUMBER,
750: p_x_Header_PAYMENT_rec.CREDIT_CARD_NUMBER,p_old_instrument_id,p_x_instrument_id)
751: AND (p_old_Header_Payment_rec.header_id IS NOT NULL OR
752: p_x_Header_PAYMENT_rec.CREDIT_CARD_NUMBER IS NOT NULL)
753: ) -- AND condition added to fix 3098878
754: THEN
755: p_x_Header_PAYMENT_rec.CREDIT_CARD_NUMBER := FND_API.G_MISS_CHAR;
756: END IF;
757: --R12 CC Encryption
758: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PAYMENT_LEVEL_CODE THEN
759: p_x_Header_PAYMENT_rec.PAYMENT_LEVEL_CODE := FND_API.G_MISS_CHAR;
755: p_x_Header_PAYMENT_rec.CREDIT_CARD_NUMBER := FND_API.G_MISS_CHAR;
756: END IF;
757: --R12 CC Encryption
758: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PAYMENT_LEVEL_CODE THEN
759: p_x_Header_PAYMENT_rec.PAYMENT_LEVEL_CODE := FND_API.G_MISS_CHAR;
760: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_COMMITMENT_APPLIED_AMOUNT THEN
761: p_x_Header_PAYMENT_rec.COMMITMENT_APPLIED_AMOUNT := FND_API.G_MISS_NUM;
762: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_COMMITMENT_INTERFACED_AMOUNT THEN
763: p_x_Header_PAYMENT_rec.COMMITMENT_INTERFACED_AMOUNT := FND_API.G_MISS_NUM;
757: --R12 CC Encryption
758: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PAYMENT_LEVEL_CODE THEN
759: p_x_Header_PAYMENT_rec.PAYMENT_LEVEL_CODE := FND_API.G_MISS_CHAR;
760: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_COMMITMENT_APPLIED_AMOUNT THEN
761: p_x_Header_PAYMENT_rec.COMMITMENT_APPLIED_AMOUNT := FND_API.G_MISS_NUM;
762: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_COMMITMENT_INTERFACED_AMOUNT THEN
763: p_x_Header_PAYMENT_rec.COMMITMENT_INTERFACED_AMOUNT := FND_API.G_MISS_NUM;
764: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PAYMENT_NUMBER THEN
765: p_x_Header_PAYMENT_rec.PAYMENT_NUMBER := FND_API.G_MISS_NUM;
759: p_x_Header_PAYMENT_rec.PAYMENT_LEVEL_CODE := FND_API.G_MISS_CHAR;
760: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_COMMITMENT_APPLIED_AMOUNT THEN
761: p_x_Header_PAYMENT_rec.COMMITMENT_APPLIED_AMOUNT := FND_API.G_MISS_NUM;
762: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_COMMITMENT_INTERFACED_AMOUNT THEN
763: p_x_Header_PAYMENT_rec.COMMITMENT_INTERFACED_AMOUNT := FND_API.G_MISS_NUM;
764: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PAYMENT_NUMBER THEN
765: p_x_Header_PAYMENT_rec.PAYMENT_NUMBER := FND_API.G_MISS_NUM;
766: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_HEADER THEN
767: p_x_Header_PAYMENT_rec.HEADER_ID := FND_API.G_MISS_NUM;
761: p_x_Header_PAYMENT_rec.COMMITMENT_APPLIED_AMOUNT := FND_API.G_MISS_NUM;
762: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_COMMITMENT_INTERFACED_AMOUNT THEN
763: p_x_Header_PAYMENT_rec.COMMITMENT_INTERFACED_AMOUNT := FND_API.G_MISS_NUM;
764: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PAYMENT_NUMBER THEN
765: p_x_Header_PAYMENT_rec.PAYMENT_NUMBER := FND_API.G_MISS_NUM;
766: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_HEADER THEN
767: p_x_Header_PAYMENT_rec.HEADER_ID := FND_API.G_MISS_NUM;
768: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_LINE THEN
769: p_x_Header_PAYMENT_rec.LINE_ID := FND_API.G_MISS_NUM;
763: p_x_Header_PAYMENT_rec.COMMITMENT_INTERFACED_AMOUNT := FND_API.G_MISS_NUM;
764: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PAYMENT_NUMBER THEN
765: p_x_Header_PAYMENT_rec.PAYMENT_NUMBER := FND_API.G_MISS_NUM;
766: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_HEADER THEN
767: p_x_Header_PAYMENT_rec.HEADER_ID := FND_API.G_MISS_NUM;
768: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_LINE THEN
769: p_x_Header_PAYMENT_rec.LINE_ID := FND_API.G_MISS_NUM;
770: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PAYMENT_AMOUNT THEN
771: p_x_Header_PAYMENT_rec.PAYMENT_AMOUNT := FND_API.G_MISS_NUM;
765: p_x_Header_PAYMENT_rec.PAYMENT_NUMBER := FND_API.G_MISS_NUM;
766: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_HEADER THEN
767: p_x_Header_PAYMENT_rec.HEADER_ID := FND_API.G_MISS_NUM;
768: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_LINE THEN
769: p_x_Header_PAYMENT_rec.LINE_ID := FND_API.G_MISS_NUM;
770: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PAYMENT_AMOUNT THEN
771: p_x_Header_PAYMENT_rec.PAYMENT_AMOUNT := FND_API.G_MISS_NUM;
772: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PAYMENT_COLLECTION_EVENT THEN
773: p_x_Header_PAYMENT_rec.PAYMENT_COLLECTION_EVENT := FND_API.G_MISS_CHAR;
767: p_x_Header_PAYMENT_rec.HEADER_ID := FND_API.G_MISS_NUM;
768: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_LINE THEN
769: p_x_Header_PAYMENT_rec.LINE_ID := FND_API.G_MISS_NUM;
770: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PAYMENT_AMOUNT THEN
771: p_x_Header_PAYMENT_rec.PAYMENT_AMOUNT := FND_API.G_MISS_NUM;
772: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PAYMENT_COLLECTION_EVENT THEN
773: p_x_Header_PAYMENT_rec.PAYMENT_COLLECTION_EVENT := FND_API.G_MISS_CHAR;
774: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PAYMENT_TRX_ID THEN
775: p_x_Header_PAYMENT_rec.PAYMENT_TRX_ID := FND_API.G_MISS_NUM;
769: p_x_Header_PAYMENT_rec.LINE_ID := FND_API.G_MISS_NUM;
770: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PAYMENT_AMOUNT THEN
771: p_x_Header_PAYMENT_rec.PAYMENT_AMOUNT := FND_API.G_MISS_NUM;
772: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PAYMENT_COLLECTION_EVENT THEN
773: p_x_Header_PAYMENT_rec.PAYMENT_COLLECTION_EVENT := FND_API.G_MISS_CHAR;
774: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PAYMENT_TRX_ID THEN
775: p_x_Header_PAYMENT_rec.PAYMENT_TRX_ID := FND_API.G_MISS_NUM;
776: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PAYMENT_TYPE_CODE THEN
777: p_x_Header_PAYMENT_rec.PAYMENT_TYPE_CODE := FND_API.G_MISS_CHAR;
771: p_x_Header_PAYMENT_rec.PAYMENT_AMOUNT := FND_API.G_MISS_NUM;
772: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PAYMENT_COLLECTION_EVENT THEN
773: p_x_Header_PAYMENT_rec.PAYMENT_COLLECTION_EVENT := FND_API.G_MISS_CHAR;
774: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PAYMENT_TRX_ID THEN
775: p_x_Header_PAYMENT_rec.PAYMENT_TRX_ID := FND_API.G_MISS_NUM;
776: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PAYMENT_TYPE_CODE THEN
777: p_x_Header_PAYMENT_rec.PAYMENT_TYPE_CODE := FND_API.G_MISS_CHAR;
778: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PAYMENT_SET_ID THEN
779: p_x_Header_PAYMENT_rec.PAYMENT_SET_ID := FND_API.G_MISS_NUM;
773: p_x_Header_PAYMENT_rec.PAYMENT_COLLECTION_EVENT := FND_API.G_MISS_CHAR;
774: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PAYMENT_TRX_ID THEN
775: p_x_Header_PAYMENT_rec.PAYMENT_TRX_ID := FND_API.G_MISS_NUM;
776: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PAYMENT_TYPE_CODE THEN
777: p_x_Header_PAYMENT_rec.PAYMENT_TYPE_CODE := FND_API.G_MISS_CHAR;
778: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PAYMENT_SET_ID THEN
779: p_x_Header_PAYMENT_rec.PAYMENT_SET_ID := FND_API.G_MISS_NUM;
780: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PREPAID_AMOUNT THEN
781: p_x_Header_PAYMENT_rec.PREPAID_AMOUNT := FND_API.G_MISS_NUM;
775: p_x_Header_PAYMENT_rec.PAYMENT_TRX_ID := FND_API.G_MISS_NUM;
776: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PAYMENT_TYPE_CODE THEN
777: p_x_Header_PAYMENT_rec.PAYMENT_TYPE_CODE := FND_API.G_MISS_CHAR;
778: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PAYMENT_SET_ID THEN
779: p_x_Header_PAYMENT_rec.PAYMENT_SET_ID := FND_API.G_MISS_NUM;
780: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PREPAID_AMOUNT THEN
781: p_x_Header_PAYMENT_rec.PREPAID_AMOUNT := FND_API.G_MISS_NUM;
782: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PROGRAM_APPLICATION_ID THEN
783: p_x_Header_PAYMENT_rec.PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;
777: p_x_Header_PAYMENT_rec.PAYMENT_TYPE_CODE := FND_API.G_MISS_CHAR;
778: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PAYMENT_SET_ID THEN
779: p_x_Header_PAYMENT_rec.PAYMENT_SET_ID := FND_API.G_MISS_NUM;
780: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PREPAID_AMOUNT THEN
781: p_x_Header_PAYMENT_rec.PREPAID_AMOUNT := FND_API.G_MISS_NUM;
782: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PROGRAM_APPLICATION_ID THEN
783: p_x_Header_PAYMENT_rec.PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;
784: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PROGRAM_ID THEN
785: p_x_Header_PAYMENT_rec.PROGRAM_ID := FND_API.G_MISS_NUM;
779: p_x_Header_PAYMENT_rec.PAYMENT_SET_ID := FND_API.G_MISS_NUM;
780: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PREPAID_AMOUNT THEN
781: p_x_Header_PAYMENT_rec.PREPAID_AMOUNT := FND_API.G_MISS_NUM;
782: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PROGRAM_APPLICATION_ID THEN
783: p_x_Header_PAYMENT_rec.PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;
784: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PROGRAM_ID THEN
785: p_x_Header_PAYMENT_rec.PROGRAM_ID := FND_API.G_MISS_NUM;
786: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PROGRAM_UPDATE_DATE THEN
787: p_x_Header_PAYMENT_rec.PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
781: p_x_Header_PAYMENT_rec.PREPAID_AMOUNT := FND_API.G_MISS_NUM;
782: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PROGRAM_APPLICATION_ID THEN
783: p_x_Header_PAYMENT_rec.PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;
784: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PROGRAM_ID THEN
785: p_x_Header_PAYMENT_rec.PROGRAM_ID := FND_API.G_MISS_NUM;
786: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PROGRAM_UPDATE_DATE THEN
787: p_x_Header_PAYMENT_rec.PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
788: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_RECEIPT_METHOD_ID THEN
789: p_x_Header_PAYMENT_rec.RECEIPT_METHOD_ID := FND_API.G_MISS_NUM;
783: p_x_Header_PAYMENT_rec.PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;
784: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PROGRAM_ID THEN
785: p_x_Header_PAYMENT_rec.PROGRAM_ID := FND_API.G_MISS_NUM;
786: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PROGRAM_UPDATE_DATE THEN
787: p_x_Header_PAYMENT_rec.PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
788: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_RECEIPT_METHOD_ID THEN
789: p_x_Header_PAYMENT_rec.RECEIPT_METHOD_ID := FND_API.G_MISS_NUM;
790: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_REQUEST_ID THEN
791: p_x_Header_PAYMENT_rec.REQUEST_ID := FND_API.G_MISS_NUM;
785: p_x_Header_PAYMENT_rec.PROGRAM_ID := FND_API.G_MISS_NUM;
786: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_PROGRAM_UPDATE_DATE THEN
787: p_x_Header_PAYMENT_rec.PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
788: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_RECEIPT_METHOD_ID THEN
789: p_x_Header_PAYMENT_rec.RECEIPT_METHOD_ID := FND_API.G_MISS_NUM;
790: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_REQUEST_ID THEN
791: p_x_Header_PAYMENT_rec.REQUEST_ID := FND_API.G_MISS_NUM;
792: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_TANGIBLE_ID THEN
793: p_x_Header_PAYMENT_rec.TANGIBLE_ID := FND_API.G_MISS_CHAR;
787: p_x_Header_PAYMENT_rec.PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
788: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_RECEIPT_METHOD_ID THEN
789: p_x_Header_PAYMENT_rec.RECEIPT_METHOD_ID := FND_API.G_MISS_NUM;
790: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_REQUEST_ID THEN
791: p_x_Header_PAYMENT_rec.REQUEST_ID := FND_API.G_MISS_NUM;
792: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_TANGIBLE_ID THEN
793: p_x_Header_PAYMENT_rec.TANGIBLE_ID := FND_API.G_MISS_CHAR;
794: END IF;
795: END LOOP;
789: p_x_Header_PAYMENT_rec.RECEIPT_METHOD_ID := FND_API.G_MISS_NUM;
790: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_REQUEST_ID THEN
791: p_x_Header_PAYMENT_rec.REQUEST_ID := FND_API.G_MISS_NUM;
792: ELSIF l_dep_attr_tbl(I) = OE_HEADER_PAYMENT_UTIL.G_TANGIBLE_ID THEN
793: p_x_Header_PAYMENT_rec.TANGIBLE_ID := FND_API.G_MISS_CHAR;
794: END IF;
795: END LOOP;
796: END IF;
797: END Clear_Dependent_Attr;
796: END IF;
797: END Clear_Dependent_Attr;
798:
799: PROCEDURE Clear_Dependent_Attr
800: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
801: , p_x_Header_Payment_rec IN OUT NOCOPY OE_Order_PUB.Header_Payment_Rec_Type
802: , p_old_Header_Payment_rec IN OE_Order_PUB.Header_Payment_Rec_Type :=
803: OE_Order_PUB.G_MISS_HEADER_Payment_REC
804: )
853: l_hold_release_id OE_ORDER_HOLDS.HOLD_RELEASE_ID%TYPE;
854: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
855:
856: BEGIN
857: x_return_status := FND_API.G_RET_STS_SUCCESS;
858:
859: IF l_debug_level > 0 THEN
860: oe_debug_pub.add( 'Entering Delete_PaymentType_Hold' , 3 ) ;
861: END IF;
886: oe_debug_pub.add( 'Exiting Delete_PaymentType_Hold' , 3 ) ;
887: END IF;
888:
889: EXCEPTION
890: WHEN FND_API.G_EXC_ERROR THEN
891: IF (order_paytype_hold%isopen) THEN
892: CLOSE order_paytype_hold;
893: END IF;
894:
891: IF (order_paytype_hold%isopen) THEN
892: CLOSE order_paytype_hold;
893: END IF;
894:
895: x_return_status := FND_API.G_RET_STS_ERROR;
896: FND_MSG_PUB.Count_And_Get
897: ( p_count => x_msg_count
898: , p_data => x_msg_data
899: );
900: WHEN OTHERS THEN
901: IF (order_paytype_hold%isopen) THEN
902: CLOSE order_paytype_hold;
903: END IF;
904: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
905: FND_MSG_PUB.Count_And_Get
906: ( p_count => x_msg_count
907: , p_data => x_msg_data
908: );
1530: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1531: --
1532: BEGIN
1533:
1534: IF p_x_Header_Payment_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1535: p_x_Header_Payment_rec.attribute1 := p_old_Header_Payment_rec.attribute1;
1536: END IF;
1537:
1538: IF p_x_Header_Payment_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1534: IF p_x_Header_Payment_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1535: p_x_Header_Payment_rec.attribute1 := p_old_Header_Payment_rec.attribute1;
1536: END IF;
1537:
1538: IF p_x_Header_Payment_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1539: p_x_Header_Payment_rec.attribute2 := p_old_Header_Payment_rec.attribute2;
1540: END IF;
1541:
1542: IF p_x_Header_Payment_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1538: IF p_x_Header_Payment_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1539: p_x_Header_Payment_rec.attribute2 := p_old_Header_Payment_rec.attribute2;
1540: END IF;
1541:
1542: IF p_x_Header_Payment_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1543: p_x_Header_Payment_rec.attribute3 := p_old_Header_Payment_rec.attribute3;
1544: END IF;
1545:
1546: IF p_x_Header_Payment_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1542: IF p_x_Header_Payment_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1543: p_x_Header_Payment_rec.attribute3 := p_old_Header_Payment_rec.attribute3;
1544: END IF;
1545:
1546: IF p_x_Header_Payment_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1547: p_x_Header_Payment_rec.attribute4 := p_old_Header_Payment_rec.attribute4;
1548: END IF;
1549:
1550: IF p_x_Header_Payment_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1546: IF p_x_Header_Payment_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1547: p_x_Header_Payment_rec.attribute4 := p_old_Header_Payment_rec.attribute4;
1548: END IF;
1549:
1550: IF p_x_Header_Payment_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1551: p_x_Header_Payment_rec.attribute5 := p_old_Header_Payment_rec.attribute5;
1552: END IF;
1553:
1554: IF p_x_Header_Payment_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1550: IF p_x_Header_Payment_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1551: p_x_Header_Payment_rec.attribute5 := p_old_Header_Payment_rec.attribute5;
1552: END IF;
1553:
1554: IF p_x_Header_Payment_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1555: p_x_Header_Payment_rec.attribute6 := p_old_Header_Payment_rec.attribute6;
1556: END IF;
1557:
1558: IF p_x_Header_Payment_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1554: IF p_x_Header_Payment_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1555: p_x_Header_Payment_rec.attribute6 := p_old_Header_Payment_rec.attribute6;
1556: END IF;
1557:
1558: IF p_x_Header_Payment_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1559: p_x_Header_Payment_rec.attribute7 := p_old_Header_Payment_rec.attribute7;
1560: END IF;
1561:
1562: IF p_x_Header_Payment_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1558: IF p_x_Header_Payment_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1559: p_x_Header_Payment_rec.attribute7 := p_old_Header_Payment_rec.attribute7;
1560: END IF;
1561:
1562: IF p_x_Header_Payment_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1563: p_x_Header_Payment_rec.attribute8 := p_old_Header_Payment_rec.attribute8;
1564: END IF;
1565:
1566: IF p_x_Header_Payment_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1562: IF p_x_Header_Payment_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1563: p_x_Header_Payment_rec.attribute8 := p_old_Header_Payment_rec.attribute8;
1564: END IF;
1565:
1566: IF p_x_Header_Payment_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1567: p_x_Header_Payment_rec.attribute9 := p_old_Header_Payment_rec.attribute9;
1568: END IF;
1569:
1570: IF p_x_Header_Payment_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1566: IF p_x_Header_Payment_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1567: p_x_Header_Payment_rec.attribute9 := p_old_Header_Payment_rec.attribute9;
1568: END IF;
1569:
1570: IF p_x_Header_Payment_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1571: p_x_Header_Payment_rec.attribute10 := p_old_Header_Payment_rec.attribute10;
1572: END IF;
1573:
1574: IF p_x_Header_Payment_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1570: IF p_x_Header_Payment_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1571: p_x_Header_Payment_rec.attribute10 := p_old_Header_Payment_rec.attribute10;
1572: END IF;
1573:
1574: IF p_x_Header_Payment_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1575: p_x_Header_Payment_rec.attribute11 := p_old_Header_Payment_rec.attribute11;
1576: END IF;
1577:
1578: IF p_x_Header_Payment_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1574: IF p_x_Header_Payment_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1575: p_x_Header_Payment_rec.attribute11 := p_old_Header_Payment_rec.attribute11;
1576: END IF;
1577:
1578: IF p_x_Header_Payment_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1579: p_x_Header_Payment_rec.attribute12 := p_old_Header_Payment_rec.attribute12;
1580: END IF;
1581:
1582: IF p_x_Header_Payment_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1578: IF p_x_Header_Payment_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1579: p_x_Header_Payment_rec.attribute12 := p_old_Header_Payment_rec.attribute12;
1580: END IF;
1581:
1582: IF p_x_Header_Payment_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1583: p_x_Header_Payment_rec.attribute13 := p_old_Header_Payment_rec.attribute13;
1584: END IF;
1585:
1586: IF p_x_Header_Payment_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1582: IF p_x_Header_Payment_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1583: p_x_Header_Payment_rec.attribute13 := p_old_Header_Payment_rec.attribute13;
1584: END IF;
1585:
1586: IF p_x_Header_Payment_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1587: p_x_Header_Payment_rec.attribute14 := p_old_Header_Payment_rec.attribute14;
1588: END IF;
1589:
1590: IF p_x_Header_Payment_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1586: IF p_x_Header_Payment_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1587: p_x_Header_Payment_rec.attribute14 := p_old_Header_Payment_rec.attribute14;
1588: END IF;
1589:
1590: IF p_x_Header_Payment_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1591: p_x_Header_Payment_rec.attribute15 := p_old_Header_Payment_rec.attribute15;
1592: END IF;
1593:
1594: IF p_x_Header_Payment_rec.context = FND_API.G_MISS_CHAR THEN
1590: IF p_x_Header_Payment_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1591: p_x_Header_Payment_rec.attribute15 := p_old_Header_Payment_rec.attribute15;
1592: END IF;
1593:
1594: IF p_x_Header_Payment_rec.context = FND_API.G_MISS_CHAR THEN
1595: p_x_Header_Payment_rec.context := p_old_Header_Payment_rec.context;
1596: END IF;
1597:
1598: IF p_x_Header_Payment_rec.created_by = FND_API.G_MISS_NUM THEN
1594: IF p_x_Header_Payment_rec.context = FND_API.G_MISS_CHAR THEN
1595: p_x_Header_Payment_rec.context := p_old_Header_Payment_rec.context;
1596: END IF;
1597:
1598: IF p_x_Header_Payment_rec.created_by = FND_API.G_MISS_NUM THEN
1599: p_x_Header_Payment_rec.created_by := p_old_Header_Payment_rec.created_by;
1600: END IF;
1601:
1602: IF p_x_Header_Payment_rec.creation_date = FND_API.G_MISS_DATE THEN
1598: IF p_x_Header_Payment_rec.created_by = FND_API.G_MISS_NUM THEN
1599: p_x_Header_Payment_rec.created_by := p_old_Header_Payment_rec.created_by;
1600: END IF;
1601:
1602: IF p_x_Header_Payment_rec.creation_date = FND_API.G_MISS_DATE THEN
1603: p_x_Header_Payment_rec.creation_date := p_old_Header_Payment_rec.creation_date;
1604: END IF;
1605:
1606: IF p_x_Header_Payment_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1602: IF p_x_Header_Payment_rec.creation_date = FND_API.G_MISS_DATE THEN
1603: p_x_Header_Payment_rec.creation_date := p_old_Header_Payment_rec.creation_date;
1604: END IF;
1605:
1606: IF p_x_Header_Payment_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1607: p_x_Header_Payment_rec.last_updated_by := p_old_Header_Payment_rec.last_updated_by;
1608: END IF;
1609:
1610: IF p_x_Header_Payment_rec.last_update_date = FND_API.G_MISS_DATE THEN
1606: IF p_x_Header_Payment_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1607: p_x_Header_Payment_rec.last_updated_by := p_old_Header_Payment_rec.last_updated_by;
1608: END IF;
1609:
1610: IF p_x_Header_Payment_rec.last_update_date = FND_API.G_MISS_DATE THEN
1611: p_x_Header_Payment_rec.last_update_date := p_old_Header_Payment_rec.last_update_date;
1612: END IF;
1613:
1614: IF p_x_Header_Payment_rec.last_update_login = FND_API.G_MISS_NUM THEN
1610: IF p_x_Header_Payment_rec.last_update_date = FND_API.G_MISS_DATE THEN
1611: p_x_Header_Payment_rec.last_update_date := p_old_Header_Payment_rec.last_update_date;
1612: END IF;
1613:
1614: IF p_x_Header_Payment_rec.last_update_login = FND_API.G_MISS_NUM THEN
1615: p_x_Header_Payment_rec.last_update_login := p_old_Header_Payment_rec.last_update_login;
1616: END IF;
1617:
1618: IF p_x_Header_Payment_rec.check_number = FND_API.G_MISS_CHAR THEN
1614: IF p_x_Header_Payment_rec.last_update_login = FND_API.G_MISS_NUM THEN
1615: p_x_Header_Payment_rec.last_update_login := p_old_Header_Payment_rec.last_update_login;
1616: END IF;
1617:
1618: IF p_x_Header_Payment_rec.check_number = FND_API.G_MISS_CHAR THEN
1619: p_x_Header_Payment_rec.check_number := p_old_Header_Payment_rec.check_number;
1620: END IF;
1621:
1622: IF p_x_Header_Payment_rec.credit_card_approval_code = FND_API.G_MISS_CHAR THEN
1618: IF p_x_Header_Payment_rec.check_number = FND_API.G_MISS_CHAR THEN
1619: p_x_Header_Payment_rec.check_number := p_old_Header_Payment_rec.check_number;
1620: END IF;
1621:
1622: IF p_x_Header_Payment_rec.credit_card_approval_code = FND_API.G_MISS_CHAR THEN
1623: p_x_Header_Payment_rec.credit_card_approval_code := p_old_Header_Payment_rec.credit_card_approval_code;
1624: END IF;
1625:
1626: IF p_x_Header_Payment_rec.credit_card_approval_date = FND_API.G_MISS_DATE THEN
1622: IF p_x_Header_Payment_rec.credit_card_approval_code = FND_API.G_MISS_CHAR THEN
1623: p_x_Header_Payment_rec.credit_card_approval_code := p_old_Header_Payment_rec.credit_card_approval_code;
1624: END IF;
1625:
1626: IF p_x_Header_Payment_rec.credit_card_approval_date = FND_API.G_MISS_DATE THEN
1627: p_x_Header_Payment_rec.credit_card_approval_date := p_old_Header_Payment_rec.credit_card_approval_date;
1628: END IF;
1629:
1630: IF p_x_Header_Payment_rec.credit_card_code = FND_API.G_MISS_CHAR THEN
1626: IF p_x_Header_Payment_rec.credit_card_approval_date = FND_API.G_MISS_DATE THEN
1627: p_x_Header_Payment_rec.credit_card_approval_date := p_old_Header_Payment_rec.credit_card_approval_date;
1628: END IF;
1629:
1630: IF p_x_Header_Payment_rec.credit_card_code = FND_API.G_MISS_CHAR THEN
1631: p_x_Header_Payment_rec.credit_card_code := p_old_Header_Payment_rec.credit_card_code;
1632: END IF;
1633:
1634: IF p_x_Header_Payment_rec.credit_card_expiration_date = FND_API.G_MISS_DATE THEN
1630: IF p_x_Header_Payment_rec.credit_card_code = FND_API.G_MISS_CHAR THEN
1631: p_x_Header_Payment_rec.credit_card_code := p_old_Header_Payment_rec.credit_card_code;
1632: END IF;
1633:
1634: IF p_x_Header_Payment_rec.credit_card_expiration_date = FND_API.G_MISS_DATE THEN
1635: p_x_Header_Payment_rec.credit_card_expiration_date := p_old_Header_Payment_rec.credit_card_expiration_date;
1636: END IF;
1637:
1638: IF p_x_Header_Payment_rec.credit_card_holder_name = FND_API.G_MISS_CHAR THEN
1634: IF p_x_Header_Payment_rec.credit_card_expiration_date = FND_API.G_MISS_DATE THEN
1635: p_x_Header_Payment_rec.credit_card_expiration_date := p_old_Header_Payment_rec.credit_card_expiration_date;
1636: END IF;
1637:
1638: IF p_x_Header_Payment_rec.credit_card_holder_name = FND_API.G_MISS_CHAR THEN
1639: p_x_Header_Payment_rec.credit_card_holder_name := p_old_Header_Payment_rec.credit_card_holder_name;
1640: END IF;
1641:
1642: IF p_x_Header_Payment_rec.credit_card_number = FND_API.G_MISS_CHAR THEN
1638: IF p_x_Header_Payment_rec.credit_card_holder_name = FND_API.G_MISS_CHAR THEN
1639: p_x_Header_Payment_rec.credit_card_holder_name := p_old_Header_Payment_rec.credit_card_holder_name;
1640: END IF;
1641:
1642: IF p_x_Header_Payment_rec.credit_card_number = FND_API.G_MISS_CHAR THEN
1643: p_x_Header_Payment_rec.credit_card_number := p_old_Header_Payment_rec.credit_card_number;
1644: END IF;
1645:
1646: IF p_x_Header_Payment_rec.payment_level_code = FND_API.G_MISS_CHAR THEN
1642: IF p_x_Header_Payment_rec.credit_card_number = FND_API.G_MISS_CHAR THEN
1643: p_x_Header_Payment_rec.credit_card_number := p_old_Header_Payment_rec.credit_card_number;
1644: END IF;
1645:
1646: IF p_x_Header_Payment_rec.payment_level_code = FND_API.G_MISS_CHAR THEN
1647: p_x_Header_Payment_rec.payment_level_code := p_old_Header_Payment_rec.payment_level_code;
1648: END IF;
1649:
1650: IF p_x_Header_Payment_rec.commitment_applied_amount = FND_API.G_MISS_NUM THEN
1646: IF p_x_Header_Payment_rec.payment_level_code = FND_API.G_MISS_CHAR THEN
1647: p_x_Header_Payment_rec.payment_level_code := p_old_Header_Payment_rec.payment_level_code;
1648: END IF;
1649:
1650: IF p_x_Header_Payment_rec.commitment_applied_amount = FND_API.G_MISS_NUM THEN
1651: p_x_Header_Payment_rec.commitment_applied_amount := p_old_Header_Payment_rec.commitment_applied_amount;
1652: END IF;
1653:
1654: IF p_x_Header_Payment_rec.commitment_interfaced_amount = FND_API.G_MISS_NUM THEN
1650: IF p_x_Header_Payment_rec.commitment_applied_amount = FND_API.G_MISS_NUM THEN
1651: p_x_Header_Payment_rec.commitment_applied_amount := p_old_Header_Payment_rec.commitment_applied_amount;
1652: END IF;
1653:
1654: IF p_x_Header_Payment_rec.commitment_interfaced_amount = FND_API.G_MISS_NUM THEN
1655: p_x_Header_Payment_rec.commitment_interfaced_amount := p_old_Header_Payment_rec.commitment_interfaced_amount;
1656: END IF;
1657:
1658: IF p_x_Header_Payment_rec.payment_number = FND_API.G_MISS_NUM THEN
1654: IF p_x_Header_Payment_rec.commitment_interfaced_amount = FND_API.G_MISS_NUM THEN
1655: p_x_Header_Payment_rec.commitment_interfaced_amount := p_old_Header_Payment_rec.commitment_interfaced_amount;
1656: END IF;
1657:
1658: IF p_x_Header_Payment_rec.payment_number = FND_API.G_MISS_NUM THEN
1659: p_x_Header_Payment_rec.payment_number := p_old_Header_Payment_rec.payment_number;
1660: END IF;
1661:
1662: IF p_x_Header_Payment_rec.header_id = FND_API.G_MISS_NUM THEN
1658: IF p_x_Header_Payment_rec.payment_number = FND_API.G_MISS_NUM THEN
1659: p_x_Header_Payment_rec.payment_number := p_old_Header_Payment_rec.payment_number;
1660: END IF;
1661:
1662: IF p_x_Header_Payment_rec.header_id = FND_API.G_MISS_NUM THEN
1663: p_x_Header_Payment_rec.header_id := p_old_Header_Payment_rec.header_id;
1664: END IF;
1665:
1666: IF p_x_Header_Payment_rec.line_id = FND_API.G_MISS_NUM THEN
1662: IF p_x_Header_Payment_rec.header_id = FND_API.G_MISS_NUM THEN
1663: p_x_Header_Payment_rec.header_id := p_old_Header_Payment_rec.header_id;
1664: END IF;
1665:
1666: IF p_x_Header_Payment_rec.line_id = FND_API.G_MISS_NUM THEN
1667: p_x_Header_Payment_rec.line_id := p_old_Header_Payment_rec.line_id;
1668: END IF;
1669:
1670: IF p_x_Header_Payment_rec.payment_amount = FND_API.G_MISS_NUM THEN
1666: IF p_x_Header_Payment_rec.line_id = FND_API.G_MISS_NUM THEN
1667: p_x_Header_Payment_rec.line_id := p_old_Header_Payment_rec.line_id;
1668: END IF;
1669:
1670: IF p_x_Header_Payment_rec.payment_amount = FND_API.G_MISS_NUM THEN
1671: p_x_Header_Payment_rec.payment_amount := p_old_Header_Payment_rec.payment_amount;
1672: END IF;
1673:
1674: -- Added for bug 8478559
1671: p_x_Header_Payment_rec.payment_amount := p_old_Header_Payment_rec.payment_amount;
1672: END IF;
1673:
1674: -- Added for bug 8478559
1675: IF p_x_Header_Payment_rec.payment_percentage = FND_API.G_MISS_NUM THEN
1676: p_x_Header_Payment_rec.payment_percentage := p_old_Header_Payment_rec.payment_percentage;
1677: END IF;
1678: -- End of bug 8478559
1679:
1676: p_x_Header_Payment_rec.payment_percentage := p_old_Header_Payment_rec.payment_percentage;
1677: END IF;
1678: -- End of bug 8478559
1679:
1680: IF p_x_Header_Payment_rec.payment_collection_event = FND_API.G_MISS_CHAR THEN
1681: p_x_Header_Payment_rec.payment_collection_event := p_old_Header_Payment_rec.payment_collection_event;
1682: END IF;
1683:
1684: IF p_x_Header_Payment_rec.defer_payment_processing_flag = FND_API.G_MISS_CHAR THEN
1680: IF p_x_Header_Payment_rec.payment_collection_event = FND_API.G_MISS_CHAR THEN
1681: p_x_Header_Payment_rec.payment_collection_event := p_old_Header_Payment_rec.payment_collection_event;
1682: END IF;
1683:
1684: IF p_x_Header_Payment_rec.defer_payment_processing_flag = FND_API.G_MISS_CHAR THEN
1685: p_x_Header_Payment_rec.defer_payment_processing_flag := p_old_Header_Payment_rec.defer_payment_processing_flag;
1686: END IF;
1687:
1688: IF p_x_Header_Payment_rec.payment_trx_id = FND_API.G_MISS_NUM THEN
1684: IF p_x_Header_Payment_rec.defer_payment_processing_flag = FND_API.G_MISS_CHAR THEN
1685: p_x_Header_Payment_rec.defer_payment_processing_flag := p_old_Header_Payment_rec.defer_payment_processing_flag;
1686: END IF;
1687:
1688: IF p_x_Header_Payment_rec.payment_trx_id = FND_API.G_MISS_NUM THEN
1689: p_x_Header_Payment_rec.payment_trx_id := p_old_Header_Payment_rec.payment_trx_id;
1690: END IF;
1691:
1692: IF p_x_Header_Payment_rec.payment_type_code = FND_API.G_MISS_CHAR THEN
1688: IF p_x_Header_Payment_rec.payment_trx_id = FND_API.G_MISS_NUM THEN
1689: p_x_Header_Payment_rec.payment_trx_id := p_old_Header_Payment_rec.payment_trx_id;
1690: END IF;
1691:
1692: IF p_x_Header_Payment_rec.payment_type_code = FND_API.G_MISS_CHAR THEN
1693: p_x_Header_Payment_rec.payment_type_code := p_old_Header_Payment_rec.payment_type_code;
1694: END IF;
1695:
1696: IF p_x_Header_Payment_rec.payment_set_id = FND_API.G_MISS_NUM THEN
1692: IF p_x_Header_Payment_rec.payment_type_code = FND_API.G_MISS_CHAR THEN
1693: p_x_Header_Payment_rec.payment_type_code := p_old_Header_Payment_rec.payment_type_code;
1694: END IF;
1695:
1696: IF p_x_Header_Payment_rec.payment_set_id = FND_API.G_MISS_NUM THEN
1697: p_x_Header_Payment_rec.payment_set_id := p_old_Header_Payment_rec.payment_set_id;
1698: END IF;
1699:
1700: IF p_x_Header_Payment_rec.prepaid_amount = FND_API.G_MISS_NUM THEN
1696: IF p_x_Header_Payment_rec.payment_set_id = FND_API.G_MISS_NUM THEN
1697: p_x_Header_Payment_rec.payment_set_id := p_old_Header_Payment_rec.payment_set_id;
1698: END IF;
1699:
1700: IF p_x_Header_Payment_rec.prepaid_amount = FND_API.G_MISS_NUM THEN
1701: p_x_Header_Payment_rec.prepaid_amount := p_old_Header_Payment_rec.prepaid_amount;
1702: END IF;
1703:
1704: IF p_x_Header_Payment_rec.program_application_id = FND_API.G_MISS_NUM THEN
1700: IF p_x_Header_Payment_rec.prepaid_amount = FND_API.G_MISS_NUM THEN
1701: p_x_Header_Payment_rec.prepaid_amount := p_old_Header_Payment_rec.prepaid_amount;
1702: END IF;
1703:
1704: IF p_x_Header_Payment_rec.program_application_id = FND_API.G_MISS_NUM THEN
1705: p_x_Header_Payment_rec.program_application_id := p_old_Header_Payment_rec.program_application_id;
1706: END IF;
1707:
1708: IF p_x_Header_Payment_rec.program_id = FND_API.G_MISS_NUM THEN
1704: IF p_x_Header_Payment_rec.program_application_id = FND_API.G_MISS_NUM THEN
1705: p_x_Header_Payment_rec.program_application_id := p_old_Header_Payment_rec.program_application_id;
1706: END IF;
1707:
1708: IF p_x_Header_Payment_rec.program_id = FND_API.G_MISS_NUM THEN
1709: p_x_Header_Payment_rec.program_id := p_old_Header_Payment_rec.program_id;
1710: END IF;
1711:
1712: IF p_x_Header_Payment_rec.program_update_date = FND_API.G_MISS_DATE THEN
1708: IF p_x_Header_Payment_rec.program_id = FND_API.G_MISS_NUM THEN
1709: p_x_Header_Payment_rec.program_id := p_old_Header_Payment_rec.program_id;
1710: END IF;
1711:
1712: IF p_x_Header_Payment_rec.program_update_date = FND_API.G_MISS_DATE THEN
1713: p_x_Header_Payment_rec.program_update_date := p_old_Header_Payment_rec.program_update_date;
1714: END IF;
1715:
1716: IF p_x_Header_Payment_rec.receipt_method_id = FND_API.G_MISS_NUM THEN
1712: IF p_x_Header_Payment_rec.program_update_date = FND_API.G_MISS_DATE THEN
1713: p_x_Header_Payment_rec.program_update_date := p_old_Header_Payment_rec.program_update_date;
1714: END IF;
1715:
1716: IF p_x_Header_Payment_rec.receipt_method_id = FND_API.G_MISS_NUM THEN
1717: p_x_Header_Payment_rec.receipt_method_id := p_old_Header_Payment_rec.receipt_method_id;
1718: END IF;
1719:
1720: IF p_x_Header_Payment_rec.request_id = FND_API.G_MISS_NUM THEN
1716: IF p_x_Header_Payment_rec.receipt_method_id = FND_API.G_MISS_NUM THEN
1717: p_x_Header_Payment_rec.receipt_method_id := p_old_Header_Payment_rec.receipt_method_id;
1718: END IF;
1719:
1720: IF p_x_Header_Payment_rec.request_id = FND_API.G_MISS_NUM THEN
1721: p_x_Header_Payment_rec.request_id := p_old_Header_Payment_rec.request_id;
1722: END IF;
1723:
1724: IF p_x_Header_Payment_rec.tangible_id = FND_API.G_MISS_CHAR THEN
1720: IF p_x_Header_Payment_rec.request_id = FND_API.G_MISS_NUM THEN
1721: p_x_Header_Payment_rec.request_id := p_old_Header_Payment_rec.request_id;
1722: END IF;
1723:
1724: IF p_x_Header_Payment_rec.tangible_id = FND_API.G_MISS_CHAR THEN
1725: p_x_Header_Payment_rec.tangible_id := p_old_Header_Payment_rec.tangible_id;
1726: END IF;
1727:
1728: IF p_x_Header_Payment_rec.trxn_extension_id = FND_API.G_MISS_NUM THEN
1724: IF p_x_Header_Payment_rec.tangible_id = FND_API.G_MISS_CHAR THEN
1725: p_x_Header_Payment_rec.tangible_id := p_old_Header_Payment_rec.tangible_id;
1726: END IF;
1727:
1728: IF p_x_Header_Payment_rec.trxn_extension_id = FND_API.G_MISS_NUM THEN
1729: p_x_Header_Payment_rec.trxn_extension_id := p_old_Header_Payment_rec.trxn_extension_id;
1730: END IF;
1731:
1732: --R12 CC Encryption
1729: p_x_Header_Payment_rec.trxn_extension_id := p_old_Header_Payment_rec.trxn_extension_id;
1730: END IF;
1731:
1732: --R12 CC Encryption
1733: IF p_x_Header_Payment_rec.trxn_extension_id = FND_API.G_MISS_NUM THEN
1734: p_x_Header_Payment_rec.trxn_extension_id := p_old_Header_Payment_rec.trxn_extension_id;
1735: END IF;
1736:
1737: IF p_x_Header_Payment_rec.instrument_security_code = FND_API.G_MISS_CHAR THEN
1733: IF p_x_Header_Payment_rec.trxn_extension_id = FND_API.G_MISS_NUM THEN
1734: p_x_Header_Payment_rec.trxn_extension_id := p_old_Header_Payment_rec.trxn_extension_id;
1735: END IF;
1736:
1737: IF p_x_Header_Payment_rec.instrument_security_code = FND_API.G_MISS_CHAR THEN
1738: p_x_Header_Payment_rec.instrument_security_code := p_old_Header_Payment_rec.instrument_security_code;
1739: END IF;
1740: --R12 CC Encryption
1741:
1740: --R12 CC Encryption
1741:
1742: --8219019 start
1743:
1744: IF p_x_Header_Payment_rec.CC_INSTRUMENT_ID = FND_API.G_MISS_NUM THEN
1745: p_x_Header_Payment_rec.CC_INSTRUMENT_ID := p_old_Header_Payment_rec.CC_INSTRUMENT_ID;
1746: END IF;
1747:
1748: IF p_x_Header_Payment_rec.CC_INSTRUMENT_ASSIGNMENT_ID = FND_API.G_MISS_NUM THEN
1744: IF p_x_Header_Payment_rec.CC_INSTRUMENT_ID = FND_API.G_MISS_NUM THEN
1745: p_x_Header_Payment_rec.CC_INSTRUMENT_ID := p_old_Header_Payment_rec.CC_INSTRUMENT_ID;
1746: END IF;
1747:
1748: IF p_x_Header_Payment_rec.CC_INSTRUMENT_ASSIGNMENT_ID = FND_API.G_MISS_NUM THEN
1749: p_x_Header_Payment_rec.CC_INSTRUMENT_ASSIGNMENT_ID := p_old_Header_Payment_rec.CC_INSTRUMENT_ASSIGNMENT_ID;
1750: END IF;
1751:
1752: --8219019 end
1764: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1765: --
1766: BEGIN
1767:
1768: IF p_x_Header_Payment_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1769: p_x_Header_Payment_rec.attribute1 := NULL;
1770: END IF;
1771:
1772: IF p_x_Header_Payment_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1768: IF p_x_Header_Payment_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1769: p_x_Header_Payment_rec.attribute1 := NULL;
1770: END IF;
1771:
1772: IF p_x_Header_Payment_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1773: p_x_Header_Payment_rec.attribute2 := NULL;
1774: END IF;
1775:
1776: IF p_x_Header_Payment_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1772: IF p_x_Header_Payment_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1773: p_x_Header_Payment_rec.attribute2 := NULL;
1774: END IF;
1775:
1776: IF p_x_Header_Payment_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1777: p_x_Header_Payment_rec.attribute3 := NULL;
1778: END IF;
1779:
1780: IF p_x_Header_Payment_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1776: IF p_x_Header_Payment_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1777: p_x_Header_Payment_rec.attribute3 := NULL;
1778: END IF;
1779:
1780: IF p_x_Header_Payment_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1781: p_x_Header_Payment_rec.attribute4 := NULL;
1782: END IF;
1783:
1784: IF p_x_Header_Payment_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1780: IF p_x_Header_Payment_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1781: p_x_Header_Payment_rec.attribute4 := NULL;
1782: END IF;
1783:
1784: IF p_x_Header_Payment_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1785: p_x_Header_Payment_rec.attribute5 := NULL;
1786: END IF;
1787:
1788: IF p_x_Header_Payment_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1784: IF p_x_Header_Payment_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1785: p_x_Header_Payment_rec.attribute5 := NULL;
1786: END IF;
1787:
1788: IF p_x_Header_Payment_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1789: p_x_Header_Payment_rec.attribute6 := NULL;
1790: END IF;
1791:
1792: IF p_x_Header_Payment_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1788: IF p_x_Header_Payment_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1789: p_x_Header_Payment_rec.attribute6 := NULL;
1790: END IF;
1791:
1792: IF p_x_Header_Payment_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1793: p_x_Header_Payment_rec.attribute7 := NULL;
1794: END IF;
1795:
1796: IF p_x_Header_Payment_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1792: IF p_x_Header_Payment_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1793: p_x_Header_Payment_rec.attribute7 := NULL;
1794: END IF;
1795:
1796: IF p_x_Header_Payment_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1797: p_x_Header_Payment_rec.attribute8 := NULL;
1798: END IF;
1799:
1800: IF p_x_Header_Payment_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1796: IF p_x_Header_Payment_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1797: p_x_Header_Payment_rec.attribute8 := NULL;
1798: END IF;
1799:
1800: IF p_x_Header_Payment_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1801: p_x_Header_Payment_rec.attribute9 := NULL;
1802: END IF;
1803:
1804: IF p_x_Header_Payment_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1800: IF p_x_Header_Payment_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1801: p_x_Header_Payment_rec.attribute9 := NULL;
1802: END IF;
1803:
1804: IF p_x_Header_Payment_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1805: p_x_Header_Payment_rec.attribute10 := NULL;
1806: END IF;
1807:
1808: IF p_x_Header_Payment_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1804: IF p_x_Header_Payment_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1805: p_x_Header_Payment_rec.attribute10 := NULL;
1806: END IF;
1807:
1808: IF p_x_Header_Payment_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1809: p_x_Header_Payment_rec.attribute11 := NULL;
1810: END IF;
1811:
1812: IF p_x_Header_Payment_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1808: IF p_x_Header_Payment_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1809: p_x_Header_Payment_rec.attribute11 := NULL;
1810: END IF;
1811:
1812: IF p_x_Header_Payment_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1813: p_x_Header_Payment_rec.attribute12 := NULL;
1814: END IF;
1815:
1816: IF p_x_Header_Payment_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1812: IF p_x_Header_Payment_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1813: p_x_Header_Payment_rec.attribute12 := NULL;
1814: END IF;
1815:
1816: IF p_x_Header_Payment_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1817: p_x_Header_Payment_rec.attribute13 := NULL;
1818: END IF;
1819:
1820: IF p_x_Header_Payment_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1816: IF p_x_Header_Payment_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1817: p_x_Header_Payment_rec.attribute13 := NULL;
1818: END IF;
1819:
1820: IF p_x_Header_Payment_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1821: p_x_Header_Payment_rec.attribute14 := NULL;
1822: END IF;
1823:
1824: IF p_x_Header_Payment_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1820: IF p_x_Header_Payment_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1821: p_x_Header_Payment_rec.attribute14 := NULL;
1822: END IF;
1823:
1824: IF p_x_Header_Payment_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1825: p_x_Header_Payment_rec.attribute15 := NULL;
1826: END IF;
1827:
1828: IF p_x_Header_Payment_rec.context = FND_API.G_MISS_CHAR THEN
1824: IF p_x_Header_Payment_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1825: p_x_Header_Payment_rec.attribute15 := NULL;
1826: END IF;
1827:
1828: IF p_x_Header_Payment_rec.context = FND_API.G_MISS_CHAR THEN
1829: p_x_Header_Payment_rec.context := NULL;
1830: END IF;
1831:
1832: IF p_x_Header_Payment_rec.created_by = FND_API.G_MISS_NUM THEN
1828: IF p_x_Header_Payment_rec.context = FND_API.G_MISS_CHAR THEN
1829: p_x_Header_Payment_rec.context := NULL;
1830: END IF;
1831:
1832: IF p_x_Header_Payment_rec.created_by = FND_API.G_MISS_NUM THEN
1833: p_x_Header_Payment_rec.created_by := NULL;
1834: END IF;
1835:
1836: IF p_x_Header_Payment_rec.creation_date = FND_API.G_MISS_DATE THEN
1832: IF p_x_Header_Payment_rec.created_by = FND_API.G_MISS_NUM THEN
1833: p_x_Header_Payment_rec.created_by := NULL;
1834: END IF;
1835:
1836: IF p_x_Header_Payment_rec.creation_date = FND_API.G_MISS_DATE THEN
1837: p_x_Header_Payment_rec.creation_date := NULL;
1838: END IF;
1839:
1840: IF p_x_Header_Payment_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1836: IF p_x_Header_Payment_rec.creation_date = FND_API.G_MISS_DATE THEN
1837: p_x_Header_Payment_rec.creation_date := NULL;
1838: END IF;
1839:
1840: IF p_x_Header_Payment_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1841: p_x_Header_Payment_rec.last_updated_by := NULL;
1842: END IF;
1843:
1844: IF p_x_Header_Payment_rec.last_update_date = FND_API.G_MISS_DATE THEN
1840: IF p_x_Header_Payment_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1841: p_x_Header_Payment_rec.last_updated_by := NULL;
1842: END IF;
1843:
1844: IF p_x_Header_Payment_rec.last_update_date = FND_API.G_MISS_DATE THEN
1845: p_x_Header_Payment_rec.last_update_date := NULL;
1846: END IF;
1847:
1848: IF p_x_Header_Payment_rec.last_update_login = FND_API.G_MISS_NUM THEN
1844: IF p_x_Header_Payment_rec.last_update_date = FND_API.G_MISS_DATE THEN
1845: p_x_Header_Payment_rec.last_update_date := NULL;
1846: END IF;
1847:
1848: IF p_x_Header_Payment_rec.last_update_login = FND_API.G_MISS_NUM THEN
1849: p_x_Header_Payment_rec.last_update_login := NULL;
1850: END IF;
1851:
1852: IF p_x_Header_Payment_rec.check_number = FND_API.G_MISS_CHAR THEN
1848: IF p_x_Header_Payment_rec.last_update_login = FND_API.G_MISS_NUM THEN
1849: p_x_Header_Payment_rec.last_update_login := NULL;
1850: END IF;
1851:
1852: IF p_x_Header_Payment_rec.check_number = FND_API.G_MISS_CHAR THEN
1853: p_x_Header_Payment_rec.check_number := NULL;
1854: END IF;
1855:
1856: IF p_x_Header_Payment_rec.credit_card_approval_code = FND_API.G_MISS_CHAR THEN
1852: IF p_x_Header_Payment_rec.check_number = FND_API.G_MISS_CHAR THEN
1853: p_x_Header_Payment_rec.check_number := NULL;
1854: END IF;
1855:
1856: IF p_x_Header_Payment_rec.credit_card_approval_code = FND_API.G_MISS_CHAR THEN
1857: p_x_Header_Payment_rec.credit_card_approval_code := NULL;
1858: END IF;
1859:
1860: IF p_x_Header_Payment_rec.credit_card_approval_date = FND_API.G_MISS_DATE THEN
1856: IF p_x_Header_Payment_rec.credit_card_approval_code = FND_API.G_MISS_CHAR THEN
1857: p_x_Header_Payment_rec.credit_card_approval_code := NULL;
1858: END IF;
1859:
1860: IF p_x_Header_Payment_rec.credit_card_approval_date = FND_API.G_MISS_DATE THEN
1861: p_x_Header_Payment_rec.credit_card_approval_date := NULL;
1862: END IF;
1863:
1864: IF p_x_Header_Payment_rec.credit_card_code = FND_API.G_MISS_CHAR THEN
1860: IF p_x_Header_Payment_rec.credit_card_approval_date = FND_API.G_MISS_DATE THEN
1861: p_x_Header_Payment_rec.credit_card_approval_date := NULL;
1862: END IF;
1863:
1864: IF p_x_Header_Payment_rec.credit_card_code = FND_API.G_MISS_CHAR THEN
1865: p_x_Header_Payment_rec.credit_card_code := NULL;
1866: END IF;
1867:
1868: IF p_x_Header_Payment_rec.credit_card_expiration_date = FND_API.G_MISS_DATE THEN
1864: IF p_x_Header_Payment_rec.credit_card_code = FND_API.G_MISS_CHAR THEN
1865: p_x_Header_Payment_rec.credit_card_code := NULL;
1866: END IF;
1867:
1868: IF p_x_Header_Payment_rec.credit_card_expiration_date = FND_API.G_MISS_DATE THEN
1869: p_x_Header_Payment_rec.credit_card_expiration_date := NULL;
1870: END IF;
1871:
1872: IF p_x_Header_Payment_rec.credit_card_holder_name = FND_API.G_MISS_CHAR THEN
1868: IF p_x_Header_Payment_rec.credit_card_expiration_date = FND_API.G_MISS_DATE THEN
1869: p_x_Header_Payment_rec.credit_card_expiration_date := NULL;
1870: END IF;
1871:
1872: IF p_x_Header_Payment_rec.credit_card_holder_name = FND_API.G_MISS_CHAR THEN
1873: p_x_Header_Payment_rec.credit_card_holder_name := NULL;
1874: END IF;
1875:
1876: IF p_x_Header_Payment_rec.credit_card_number = FND_API.G_MISS_CHAR THEN
1872: IF p_x_Header_Payment_rec.credit_card_holder_name = FND_API.G_MISS_CHAR THEN
1873: p_x_Header_Payment_rec.credit_card_holder_name := NULL;
1874: END IF;
1875:
1876: IF p_x_Header_Payment_rec.credit_card_number = FND_API.G_MISS_CHAR THEN
1877: p_x_Header_Payment_rec.credit_card_number := NULL;
1878: END IF;
1879:
1880: IF p_x_Header_Payment_rec.payment_level_code = FND_API.G_MISS_CHAR THEN
1876: IF p_x_Header_Payment_rec.credit_card_number = FND_API.G_MISS_CHAR THEN
1877: p_x_Header_Payment_rec.credit_card_number := NULL;
1878: END IF;
1879:
1880: IF p_x_Header_Payment_rec.payment_level_code = FND_API.G_MISS_CHAR THEN
1881: p_x_Header_Payment_rec.payment_level_code := NULL;
1882: END IF;
1883:
1884: IF p_x_Header_Payment_rec.commitment_applied_amount = FND_API.G_MISS_NUM THEN
1880: IF p_x_Header_Payment_rec.payment_level_code = FND_API.G_MISS_CHAR THEN
1881: p_x_Header_Payment_rec.payment_level_code := NULL;
1882: END IF;
1883:
1884: IF p_x_Header_Payment_rec.commitment_applied_amount = FND_API.G_MISS_NUM THEN
1885: p_x_Header_Payment_rec.commitment_applied_amount := NULL;
1886: END IF;
1887:
1888: IF p_x_Header_Payment_rec.commitment_interfaced_amount = FND_API.G_MISS_NUM THEN
1884: IF p_x_Header_Payment_rec.commitment_applied_amount = FND_API.G_MISS_NUM THEN
1885: p_x_Header_Payment_rec.commitment_applied_amount := NULL;
1886: END IF;
1887:
1888: IF p_x_Header_Payment_rec.commitment_interfaced_amount = FND_API.G_MISS_NUM THEN
1889: p_x_Header_Payment_rec.commitment_interfaced_amount := NULL;
1890: END IF;
1891:
1892: IF p_x_Header_Payment_rec.payment_number = FND_API.G_MISS_NUM THEN
1888: IF p_x_Header_Payment_rec.commitment_interfaced_amount = FND_API.G_MISS_NUM THEN
1889: p_x_Header_Payment_rec.commitment_interfaced_amount := NULL;
1890: END IF;
1891:
1892: IF p_x_Header_Payment_rec.payment_number = FND_API.G_MISS_NUM THEN
1893: p_x_Header_Payment_rec.payment_number := NULL;
1894: END IF;
1895:
1896: IF p_x_Header_Payment_rec.header_id = FND_API.G_MISS_NUM THEN
1892: IF p_x_Header_Payment_rec.payment_number = FND_API.G_MISS_NUM THEN
1893: p_x_Header_Payment_rec.payment_number := NULL;
1894: END IF;
1895:
1896: IF p_x_Header_Payment_rec.header_id = FND_API.G_MISS_NUM THEN
1897: p_x_Header_Payment_rec.header_id := NULL;
1898: END IF;
1899:
1900: IF p_x_Header_Payment_rec.line_id = FND_API.G_MISS_NUM THEN
1896: IF p_x_Header_Payment_rec.header_id = FND_API.G_MISS_NUM THEN
1897: p_x_Header_Payment_rec.header_id := NULL;
1898: END IF;
1899:
1900: IF p_x_Header_Payment_rec.line_id = FND_API.G_MISS_NUM THEN
1901: p_x_Header_Payment_rec.line_id := NULL;
1902: END IF;
1903:
1904: IF p_x_Header_Payment_rec.payment_amount = FND_API.G_MISS_NUM THEN
1900: IF p_x_Header_Payment_rec.line_id = FND_API.G_MISS_NUM THEN
1901: p_x_Header_Payment_rec.line_id := NULL;
1902: END IF;
1903:
1904: IF p_x_Header_Payment_rec.payment_amount = FND_API.G_MISS_NUM THEN
1905: p_x_Header_Payment_rec.payment_amount := NULL;
1906: END IF;
1907:
1908: -- Added for bug 8478559
1905: p_x_Header_Payment_rec.payment_amount := NULL;
1906: END IF;
1907:
1908: -- Added for bug 8478559
1909: IF p_x_Header_Payment_rec.payment_percentage = FND_API.G_MISS_NUM THEN
1910: p_x_Header_Payment_rec.payment_percentage := NULL;
1911: END IF;
1912: -- End of bug 8478559
1913:
1910: p_x_Header_Payment_rec.payment_percentage := NULL;
1911: END IF;
1912: -- End of bug 8478559
1913:
1914: IF p_x_Header_Payment_rec.payment_collection_event = FND_API.G_MISS_CHAR THEN
1915: p_x_Header_Payment_rec.payment_collection_event := NULL;
1916: END IF;
1917:
1918: IF p_x_Header_Payment_rec.defer_payment_processing_flag = FND_API.G_MISS_CHAR THEN
1914: IF p_x_Header_Payment_rec.payment_collection_event = FND_API.G_MISS_CHAR THEN
1915: p_x_Header_Payment_rec.payment_collection_event := NULL;
1916: END IF;
1917:
1918: IF p_x_Header_Payment_rec.defer_payment_processing_flag = FND_API.G_MISS_CHAR THEN
1919: p_x_Header_Payment_rec.defer_payment_processing_flag := NULL;
1920: END IF;
1921:
1922: IF p_x_Header_Payment_rec.payment_trx_id = FND_API.G_MISS_NUM THEN
1918: IF p_x_Header_Payment_rec.defer_payment_processing_flag = FND_API.G_MISS_CHAR THEN
1919: p_x_Header_Payment_rec.defer_payment_processing_flag := NULL;
1920: END IF;
1921:
1922: IF p_x_Header_Payment_rec.payment_trx_id = FND_API.G_MISS_NUM THEN
1923: p_x_Header_Payment_rec.payment_trx_id := NULL;
1924: END IF;
1925:
1926: IF p_x_Header_Payment_rec.payment_type_code = FND_API.G_MISS_CHAR THEN
1922: IF p_x_Header_Payment_rec.payment_trx_id = FND_API.G_MISS_NUM THEN
1923: p_x_Header_Payment_rec.payment_trx_id := NULL;
1924: END IF;
1925:
1926: IF p_x_Header_Payment_rec.payment_type_code = FND_API.G_MISS_CHAR THEN
1927: p_x_Header_Payment_rec.payment_type_code := NULL;
1928: END IF;
1929:
1930: IF p_x_Header_Payment_rec.payment_set_id = FND_API.G_MISS_NUM THEN
1926: IF p_x_Header_Payment_rec.payment_type_code = FND_API.G_MISS_CHAR THEN
1927: p_x_Header_Payment_rec.payment_type_code := NULL;
1928: END IF;
1929:
1930: IF p_x_Header_Payment_rec.payment_set_id = FND_API.G_MISS_NUM THEN
1931: p_x_Header_Payment_rec.payment_set_id := NULL;
1932: END IF;
1933:
1934: IF p_x_Header_Payment_rec.prepaid_amount = FND_API.G_MISS_NUM THEN
1930: IF p_x_Header_Payment_rec.payment_set_id = FND_API.G_MISS_NUM THEN
1931: p_x_Header_Payment_rec.payment_set_id := NULL;
1932: END IF;
1933:
1934: IF p_x_Header_Payment_rec.prepaid_amount = FND_API.G_MISS_NUM THEN
1935: p_x_Header_Payment_rec.prepaid_amount := NULL;
1936: END IF;
1937:
1938: IF p_x_Header_Payment_rec.program_application_id = FND_API.G_MISS_NUM THEN
1934: IF p_x_Header_Payment_rec.prepaid_amount = FND_API.G_MISS_NUM THEN
1935: p_x_Header_Payment_rec.prepaid_amount := NULL;
1936: END IF;
1937:
1938: IF p_x_Header_Payment_rec.program_application_id = FND_API.G_MISS_NUM THEN
1939: p_x_Header_Payment_rec.program_application_id := NULL;
1940: END IF;
1941:
1942: IF p_x_Header_Payment_rec.program_id = FND_API.G_MISS_NUM THEN
1938: IF p_x_Header_Payment_rec.program_application_id = FND_API.G_MISS_NUM THEN
1939: p_x_Header_Payment_rec.program_application_id := NULL;
1940: END IF;
1941:
1942: IF p_x_Header_Payment_rec.program_id = FND_API.G_MISS_NUM THEN
1943: p_x_Header_Payment_rec.program_id := NULL;
1944: END IF;
1945:
1946: IF p_x_Header_Payment_rec.program_update_date = FND_API.G_MISS_DATE THEN
1942: IF p_x_Header_Payment_rec.program_id = FND_API.G_MISS_NUM THEN
1943: p_x_Header_Payment_rec.program_id := NULL;
1944: END IF;
1945:
1946: IF p_x_Header_Payment_rec.program_update_date = FND_API.G_MISS_DATE THEN
1947: p_x_Header_Payment_rec.program_update_date := NULL;
1948: END IF;
1949:
1950: IF p_x_Header_Payment_rec.receipt_method_id = FND_API.G_MISS_NUM THEN
1946: IF p_x_Header_Payment_rec.program_update_date = FND_API.G_MISS_DATE THEN
1947: p_x_Header_Payment_rec.program_update_date := NULL;
1948: END IF;
1949:
1950: IF p_x_Header_Payment_rec.receipt_method_id = FND_API.G_MISS_NUM THEN
1951: p_x_Header_Payment_rec.receipt_method_id := NULL;
1952: END IF;
1953:
1954: IF p_x_Header_Payment_rec.request_id = FND_API.G_MISS_NUM THEN
1950: IF p_x_Header_Payment_rec.receipt_method_id = FND_API.G_MISS_NUM THEN
1951: p_x_Header_Payment_rec.receipt_method_id := NULL;
1952: END IF;
1953:
1954: IF p_x_Header_Payment_rec.request_id = FND_API.G_MISS_NUM THEN
1955: p_x_Header_Payment_rec.request_id := NULL;
1956: END IF;
1957:
1958: IF p_x_Header_Payment_rec.tangible_id = FND_API.G_MISS_CHAR THEN
1954: IF p_x_Header_Payment_rec.request_id = FND_API.G_MISS_NUM THEN
1955: p_x_Header_Payment_rec.request_id := NULL;
1956: END IF;
1957:
1958: IF p_x_Header_Payment_rec.tangible_id = FND_API.G_MISS_CHAR THEN
1959: p_x_Header_Payment_rec.tangible_id := NULL;
1960: END IF;
1961:
1962: -- R12 CC Encryption
1959: p_x_Header_Payment_rec.tangible_id := NULL;
1960: END IF;
1961:
1962: -- R12 CC Encryption
1963: IF p_x_Header_Payment_rec.trxn_extension_id = FND_API.G_MISS_NUM THEN
1964: p_x_Header_Payment_rec.trxn_extension_id := NULL;
1965: END IF;
1966:
1967: IF p_x_Header_Payment_rec.instrument_security_code = FND_API.G_MISS_CHAR THEN
1963: IF p_x_Header_Payment_rec.trxn_extension_id = FND_API.G_MISS_NUM THEN
1964: p_x_Header_Payment_rec.trxn_extension_id := NULL;
1965: END IF;
1966:
1967: IF p_x_Header_Payment_rec.instrument_security_code = FND_API.G_MISS_CHAR THEN
1968: p_x_Header_Payment_rec.instrument_security_code := NULL;
1969: END IF;
1970: -- R12 CC Encryption
1971:
1970: -- R12 CC Encryption
1971:
1972: --8219019 start
1973:
1974: IF p_x_Header_Payment_rec.CC_INSTRUMENT_ID = FND_API.G_MISS_NUM THEN
1975: p_x_Header_Payment_rec.CC_INSTRUMENT_ID := NULL;
1976: END IF;
1977:
1978: IF p_x_Header_Payment_rec.CC_INSTRUMENT_ASSIGNMENT_ID = FND_API.G_MISS_NUM THEN
1974: IF p_x_Header_Payment_rec.CC_INSTRUMENT_ID = FND_API.G_MISS_NUM THEN
1975: p_x_Header_Payment_rec.CC_INSTRUMENT_ID := NULL;
1976: END IF;
1977:
1978: IF p_x_Header_Payment_rec.CC_INSTRUMENT_ASSIGNMENT_ID = FND_API.G_MISS_NUM THEN
1979: p_x_Header_Payment_rec.CC_INSTRUMENT_ASSIGNMENT_ID := NULL;
1980: END IF;
1981:
1982: --8219019 end
2023: x_return_status => l_return_status);*/
2024: IF l_debug_level > 0 THEN
2025: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_HEADER_Payment_UTIL.UPDATE_ROW IS: ' || L_RETURN_STATUS ) ;
2026: END IF;
2027: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2028: IF l_debug_level > 0 THEN
2029: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
2030: END IF;
2031: IF l_debug_level > 0 THEN
2030: END IF;
2031: IF l_debug_level > 0 THEN
2032: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.UPDATE_ROW' , 1 ) ;
2033: END IF;
2034: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2035: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2036: IF l_debug_level > 0 THEN
2037: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_Payment_UTIL.UPDATE_ROW' ) ;
2038: END IF;
2031: IF l_debug_level > 0 THEN
2032: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.UPDATE_ROW' , 1 ) ;
2033: END IF;
2034: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2035: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2036: IF l_debug_level > 0 THEN
2037: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_Payment_UTIL.UPDATE_ROW' ) ;
2038: END IF;
2039: IF l_debug_level > 0 THEN
2038: END IF;
2039: IF l_debug_level > 0 THEN
2040: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.UPDATE_ROW' , 1 ) ;
2041: END IF;
2042: RAISE FND_API.G_EXC_ERROR;
2043: END IF;
2044: END IF; /*code_release_level*/
2045: -- notification framework end
2046:
2117: , 'Update_Row'
2118: );
2119: END IF;
2120:
2121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2122:
2123: END Update_Row;
2124:
2125: -- Procedure Insert_Row
2264: IF l_debug_level > 0 THEN
2265: oe_debug_pub.add( 'RETURNED INDEX IS: ' || L_INDEX , 1 ) ;
2266: END IF;
2267:
2268: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2269: IF l_debug_level > 0 THEN
2270: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
2271: END IF;
2272: IF l_debug_level > 0 THEN
2271: END IF;
2272: IF l_debug_level > 0 THEN
2273: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.INSERT_ROW' , 1 ) ;
2274: END IF;
2275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2276: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2277: IF l_debug_level > 0 THEN
2278: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_Payment_UTIL.INSERT_ROW' ) ;
2279: END IF;
2272: IF l_debug_level > 0 THEN
2273: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.INSERT_ROW' , 1 ) ;
2274: END IF;
2275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2276: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2277: IF l_debug_level > 0 THEN
2278: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_Payment_UTIL.INSERT_ROW' ) ;
2279: END IF;
2280: IF l_debug_level > 0 THEN
2279: END IF;
2280: IF l_debug_level > 0 THEN
2281: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.INSERT_ROW' , 1 ) ;
2282: END IF;
2283: RAISE FND_API.G_EXC_ERROR;
2284: END IF;
2285: END IF; /*code_release_level*/
2286: -- notification framework end
2287:
2300: , 'Insert_Row'
2301: );
2302: END IF;
2303:
2304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2305:
2306: END Insert_Row;
2307:
2308: -- Procedure Delete_Row
2308: -- Procedure Delete_Row
2309:
2310: PROCEDURE Delete_Row
2311: ( p_payment_number IN NUMBER :=
2312: FND_API.G_MISS_NUM
2313: , p_header_id IN NUMBER :=
2314: FND_API.G_MISS_NUM
2315: )
2316: IS
2310: PROCEDURE Delete_Row
2311: ( p_payment_number IN NUMBER :=
2312: FND_API.G_MISS_NUM
2313: , p_header_id IN NUMBER :=
2314: FND_API.G_MISS_NUM
2315: )
2316: IS
2317: l_return_status VARCHAR2(30);
2318: l_msg_count number := 0;
2340: IF l_debug_level > 0 THEN
2341: oe_debug_pub.add( 'ENTERING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;
2342: END IF;
2343:
2344: IF p_header_id <> FND_API.G_MISS_NUM AND
2345: nvl(p_payment_number, FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM
2346: THEN
2347:
2348: FOR l_pmt IN payment LOOP
2341: oe_debug_pub.add( 'ENTERING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;
2342: END IF;
2343:
2344: IF p_header_id <> FND_API.G_MISS_NUM AND
2345: nvl(p_payment_number, FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM
2346: THEN
2347:
2348: FOR l_pmt IN payment LOOP
2349:
2366:
2367: IF l_debug_level > 0 THEN
2368: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_HEADER_Payment_UTIL.DELETE_ROW IS: ' || L_RETURN_STATUS ) ;
2369: END IF;
2370: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2371: IF l_debug_level > 0 THEN
2372: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
2373: END IF;
2374: IF l_debug_level > 0 THEN
2373: END IF;
2374: IF l_debug_level > 0 THEN
2375: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;
2376: END IF;
2377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2378: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2379: IF l_debug_level > 0 THEN
2380: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_Payment_UTIL.DELETE_ROW' ) ;
2381: END IF;
2374: IF l_debug_level > 0 THEN
2375: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;
2376: END IF;
2377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2378: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2379: IF l_debug_level > 0 THEN
2380: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_Payment_UTIL.DELETE_ROW' ) ;
2381: END IF;
2382: IF l_debug_level > 0 THEN
2381: END IF;
2382: IF l_debug_level > 0 THEN
2383: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;
2384: END IF;
2385: RAISE FND_API.G_EXC_ERROR;
2386: END IF;
2387: END IF; /*code_release_level*/
2388: -- notification framework end
2389: --R12 CC Encryption
2411: x_return_status =>l_return_status,
2412: x_msg_count => l_msg_count,
2413: x_msg_data => l_msg_data);
2414:
2415: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2416: IF l_debug_level > 0 THEN
2417: oe_debug_pub.add( 'Delete Payment at Header - UNEXPECTED ERROR' ) ;
2418: oe_debug_pub.add('Error message'||sqlerrm);
2419: oe_debug_pub.add('Msg data'||l_msg_data);
2420: END IF;
2421: IF l_debug_level > 0 THEN
2422: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;
2423: END IF;
2424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2425: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2426: IF l_debug_level > 0 THEN
2427: oe_debug_pub.add( 'Delete Payment at Header - OE_HEADER_Payment_UTIL.DELETE_ROW' ) ;
2428: oe_debug_pub.add('Error message'||sqlerrm);
2421: IF l_debug_level > 0 THEN
2422: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;
2423: END IF;
2424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2425: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2426: IF l_debug_level > 0 THEN
2427: oe_debug_pub.add( 'Delete Payment at Header - OE_HEADER_Payment_UTIL.DELETE_ROW' ) ;
2428: oe_debug_pub.add('Error message'||sqlerrm);
2429: oe_debug_pub.add('Msg data'||l_msg_data);
2430: END IF;
2431: IF l_debug_level > 0 THEN
2432: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;
2433: END IF;
2434: RAISE FND_API.G_EXC_ERROR;
2435: END IF;
2436: END IF;
2437: --R12 CC Encryption
2438: END LOOP;
2467: , p_msg_data => l_msg_data
2468: , p_return_status => l_return_status
2469: );
2470:
2471: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2472: RAISE FND_API.G_EXC_ERROR;
2473: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2475: END IF;
2468: , p_return_status => l_return_status
2469: );
2470:
2471: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2472: RAISE FND_API.G_EXC_ERROR;
2473: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2475: END IF;
2476:
2469: );
2470:
2471: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2472: RAISE FND_API.G_EXC_ERROR;
2473: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2475: END IF;
2476:
2477: -- release any authorization related holds.
2470:
2471: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2472: RAISE FND_API.G_EXC_ERROR;
2473: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2475: END IF;
2476:
2477: -- release any authorization related holds.
2478: OE_Verify_Payment_PUB.Release_Verify_Hold
2481: , p_msg_count => l_msg_count
2482: , p_msg_data => l_msg_data
2483: , p_return_status => l_return_status
2484: );
2485: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2486: RAISE FND_API.G_EXC_ERROR;
2487: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2489: END IF;
2482: , p_msg_data => l_msg_data
2483: , p_return_status => l_return_status
2484: );
2485: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2486: RAISE FND_API.G_EXC_ERROR;
2487: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2489: END IF;
2490:
2483: , p_return_status => l_return_status
2484: );
2485: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2486: RAISE FND_API.G_EXC_ERROR;
2487: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2489: END IF;
2490:
2491:
2484: );
2485: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2486: RAISE FND_API.G_EXC_ERROR;
2487: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2489: END IF;
2490:
2491:
2492: ELSIF p_header_id <> FND_API.G_MISS_NUM AND
2488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2489: END IF;
2490:
2491:
2492: ELSIF p_header_id <> FND_API.G_MISS_NUM AND
2493: p_payment_number <> FND_API.G_MISS_NUM THEN
2494: --added notification framework
2495: --check code release level first. Notification framework is at Pack H level
2496: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
2489: END IF;
2490:
2491:
2492: ELSIF p_header_id <> FND_API.G_MISS_NUM AND
2493: p_payment_number <> FND_API.G_MISS_NUM THEN
2494: --added notification framework
2495: --check code release level first. Notification framework is at Pack H level
2496: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
2497: /* Set the operation on the record so that globals are updated as well */
2512: , x_msg_count => l_msg_count
2513: , x_msg_data => l_msg_data
2514: , x_return_status => l_return_status
2515: );
2516: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2517: RAISE FND_API.G_EXC_ERROR;
2518: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2519: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2520: END IF;
2513: , x_msg_data => l_msg_data
2514: , x_return_status => l_return_status
2515: );
2516: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2517: RAISE FND_API.G_EXC_ERROR;
2518: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2519: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2520: END IF;
2521: --ER#7479609 end
2514: , x_return_status => l_return_status
2515: );
2516: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2517: RAISE FND_API.G_EXC_ERROR;
2518: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2519: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2520: END IF;
2521: --ER#7479609 end
2522:
2515: );
2516: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2517: RAISE FND_API.G_EXC_ERROR;
2518: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2519: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2520: END IF;
2521: --ER#7479609 end
2522:
2523:
2524: IF l_debug_level > 0 THEN
2525: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_HEADER_Payment_UTIL.DELETE_ROW IS: ' || L_RETURN_STATUS ) ;
2526: END IF;
2527:
2528: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2529: IF l_debug_level > 0 THEN
2530: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
2531: END IF;
2532: IF l_debug_level > 0 THEN
2531: END IF;
2532: IF l_debug_level > 0 THEN
2533: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;
2534: END IF;
2535: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2536: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2537: IF l_debug_level > 0 THEN
2538: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_Payment_UTIL.DELETE_ROW' ) ;
2539: END IF;
2532: IF l_debug_level > 0 THEN
2533: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;
2534: END IF;
2535: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2536: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2537: IF l_debug_level > 0 THEN
2538: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_Payment_UTIL.DELETE_ROW' ) ;
2539: END IF;
2540: IF l_debug_level > 0 THEN
2539: END IF;
2540: IF l_debug_level > 0 THEN
2541: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;
2542: END IF;
2543: RAISE FND_API.G_EXC_ERROR;
2544: END IF;
2545: END IF; /*code_release_level*/
2546: -- notification framework end
2547:
2586: x_msg_count => l_msg_count,
2587: x_msg_data => l_msg_data);
2588:
2589:
2590: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2591: IF l_debug_level > 0 THEN
2592: oe_debug_pub.add( '2:Delete Payment at Header - UNEXPECTED ERROR' ) ;
2593: END IF;
2594: IF l_debug_level > 0 THEN
2593: END IF;
2594: IF l_debug_level > 0 THEN
2595: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;
2596: END IF;
2597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2598: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2599: IF l_debug_level > 0 THEN
2600: oe_debug_pub.add( '2:Delete Payment at Header - OE_HEADER_Payment_UTIL.DELETE_ROW' ) ;
2601: END IF;
2594: IF l_debug_level > 0 THEN
2595: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;
2596: END IF;
2597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2598: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2599: IF l_debug_level > 0 THEN
2600: oe_debug_pub.add( '2:Delete Payment at Header - OE_HEADER_Payment_UTIL.DELETE_ROW' ) ;
2601: END IF;
2602: IF l_debug_level > 0 THEN
2601: END IF;
2602: IF l_debug_level > 0 THEN
2603: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;
2604: END IF;
2605: RAISE FND_API.G_EXC_ERROR;
2606: END IF;
2607: END IF;
2608: --R12 CC Encryption
2609: DELETE FROM OE_PAYMENTS
2634: , p_msg_count => l_msg_count
2635: , p_msg_data => l_msg_data
2636: , p_return_status => l_return_status
2637: );
2638: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2639: RAISE FND_API.G_EXC_ERROR;
2640: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2642: END IF;
2635: , p_msg_data => l_msg_data
2636: , p_return_status => l_return_status
2637: );
2638: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2639: RAISE FND_API.G_EXC_ERROR;
2640: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2642: END IF;
2643:
2636: , p_return_status => l_return_status
2637: );
2638: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2639: RAISE FND_API.G_EXC_ERROR;
2640: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2642: END IF;
2643:
2644: ELSE
2637: );
2638: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2639: RAISE FND_API.G_EXC_ERROR;
2640: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2642: END IF;
2643:
2644: ELSE
2645: -- the payment being deleted is a prepayment.
2666: , p_msg_data => l_msg_data
2667: , p_return_status => l_return_status
2668: );
2669:
2670: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2671: RAISE FND_API.G_EXC_ERROR;
2672: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2674: END IF;
2667: , p_return_status => l_return_status
2668: );
2669:
2670: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2671: RAISE FND_API.G_EXC_ERROR;
2672: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2674: END IF;
2675: END IF;
2668: );
2669:
2670: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2671: RAISE FND_API.G_EXC_ERROR;
2672: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2674: END IF;
2675: END IF;
2676:
2669:
2670: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2671: RAISE FND_API.G_EXC_ERROR;
2672: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2674: END IF;
2675: END IF;
2676:
2677: END IF;
2691: , 'Delete_Row'
2692: );
2693: END IF;
2694:
2695: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2696:
2697: END Delete_Row;
2698:
2699: -- Procedure Query_Row
2860:
2861: IF
2862: (p_payment_number IS NOT NULL
2863: AND
2864: p_payment_number <> FND_API.G_MISS_NUM)
2865: AND
2866: (p_header_id IS NOT NULL
2867: AND
2868: p_header_id <> FND_API.G_MISS_NUM)
2864: p_payment_number <> FND_API.G_MISS_NUM)
2865: AND
2866: (p_header_id IS NOT NULL
2867: AND
2868: p_header_id <> FND_API.G_MISS_NUM)
2869: AND
2870: (x_Header_Payment_tbl.COUNT = 0)
2871: THEN
2872: RAISE NO_DATA_FOUND;
2874:
2875:
2876: EXCEPTION
2877:
2878: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2879:
2880: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2881:
2882: WHEN OTHERS THEN
2876: EXCEPTION
2877:
2878: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2879:
2880: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2881:
2882: WHEN OTHERS THEN
2883:
2884: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2888: , 'Query_Row'
2889: );
2890: END IF;
2891:
2892: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2893:
2894: END Query_Row;
2895:
2896:
2900: --
2901:
2902: Procedure Query_Rows
2903: ( p_payment_number IN NUMBER :=
2904: FND_API.G_MISS_NUM
2905: , p_header_id IN NUMBER :=
2906: FND_API.G_MISS_NUM
2907: , x_header_Payment_tbl IN OUT NOCOPY OE_Order_PUB.Header_Payment_Tbl_Type
2908: )
2902: Procedure Query_Rows
2903: ( p_payment_number IN NUMBER :=
2904: FND_API.G_MISS_NUM
2905: , p_header_id IN NUMBER :=
2906: FND_API.G_MISS_NUM
2907: , x_header_Payment_tbl IN OUT NOCOPY OE_Order_PUB.Header_Payment_Tbl_Type
2908: )
2909: IS
2910: l_Header_Payment_rec OE_Order_PUB.Header_Payment_Rec_Type;
3066:
3067:
3068: EXCEPTION
3069:
3070: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3071:
3072: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3073:
3074: WHEN OTHERS THEN
3068: EXCEPTION
3069:
3070: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3071:
3072: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3073:
3074: WHEN OTHERS THEN
3075:
3076: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3080: , 'Query_Rows'
3081: );
3082: END IF;
3083:
3084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3085:
3086: END Query_Rows;
3087:
3088: -- Procedure lock_Row
3112:
3113: l_lock_control := NULL;
3114:
3115: -- Retrieve the primary key.
3116: IF p_payment_number <> FND_API.G_MISS_NUM AND
3117: p_header_id <> FND_API.G_MISS_NUM THEN
3118: l_payment_number := p_payment_number;
3119: l_header_id := p_header_id;
3120: ELSE
3113: l_lock_control := NULL;
3114:
3115: -- Retrieve the primary key.
3116: IF p_payment_number <> FND_API.G_MISS_NUM AND
3117: p_header_id <> FND_API.G_MISS_NUM THEN
3118: l_payment_number := p_payment_number;
3119: l_header_id := p_header_id;
3120: ELSE
3121: l_payment_number := p_x_header_Payment_rec.payment_number;
3143:
3144: -- If lock_control is null / missing, then return the locked record.
3145:
3146: IF l_lock_control is null OR
3147: l_lock_control <> FND_API.G_MISS_NUM THEN
3148:
3149: -- Set return status
3150: x_return_status := FND_API.G_RET_STS_SUCCESS;
3151: p_x_header_Payment_rec.return_status := FND_API.G_RET_STS_SUCCESS;
3146: IF l_lock_control is null OR
3147: l_lock_control <> FND_API.G_MISS_NUM THEN
3148:
3149: -- Set return status
3150: x_return_status := FND_API.G_RET_STS_SUCCESS;
3151: p_x_header_Payment_rec.return_status := FND_API.G_RET_STS_SUCCESS;
3152:
3153: RETURN;
3154:
3147: l_lock_control <> FND_API.G_MISS_NUM THEN
3148:
3149: -- Set return status
3150: x_return_status := FND_API.G_RET_STS_SUCCESS;
3151: p_x_header_Payment_rec.return_status := FND_API.G_RET_STS_SUCCESS;
3152:
3153: RETURN;
3154:
3155: END IF;
3166: p_x_Header_Payment_rec := l_Header_Payment_rec;
3167:
3168: -- Set return status
3169:
3170: x_return_status := FND_API.G_RET_STS_SUCCESS;
3171: p_x_Header_Payment_rec.return_status := FND_API.G_RET_STS_SUCCESS;
3172:
3173: ELSE
3174:
3167:
3168: -- Set return status
3169:
3170: x_return_status := FND_API.G_RET_STS_SUCCESS;
3171: p_x_Header_Payment_rec.return_status := FND_API.G_RET_STS_SUCCESS;
3172:
3173: ELSE
3174:
3175: -- Row has changed by another user.
3173: ELSE
3174:
3175: -- Row has changed by another user.
3176:
3177: x_return_status := FND_API.G_RET_STS_ERROR;
3178: p_x_Header_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
3179:
3180: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3181: THEN
3174:
3175: -- Row has changed by another user.
3176:
3177: x_return_status := FND_API.G_RET_STS_ERROR;
3178: p_x_Header_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
3179:
3180: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3181: THEN
3182:
3193: EXCEPTION
3194:
3195: WHEN NO_DATA_FOUND THEN
3196:
3197: x_return_status := FND_API.G_RET_STS_ERROR;
3198: p_x_Header_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
3199:
3200: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3201: THEN
3194:
3195: WHEN NO_DATA_FOUND THEN
3196:
3197: x_return_status := FND_API.G_RET_STS_ERROR;
3198: p_x_Header_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
3199:
3200: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3201: THEN
3202:
3205:
3206: END IF;
3207: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
3208:
3209: x_return_status := FND_API.G_RET_STS_ERROR;
3210: p_x_Header_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
3211:
3212: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3213: THEN
3206: END IF;
3207: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
3208:
3209: x_return_status := FND_API.G_RET_STS_ERROR;
3210: p_x_Header_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
3211:
3212: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3213: THEN
3214:
3217:
3218: END IF;
3219: WHEN OTHERS THEN
3220:
3221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3222: p_x_Header_Payment_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3223:
3224: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3225: THEN
3218: END IF;
3219: WHEN OTHERS THEN
3220:
3221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3222: p_x_Header_Payment_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3223:
3224: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3225: THEN
3226: oe_msg_pub.Add_Exc_Msg
3232: END Lock_Row;
3233:
3234: PROCEDURE Lock_Rows
3235: ( p_payment_number IN NUMBER :=
3236: FND_API.G_MISS_NUM
3237: , p_header_id IN NUMBER :=
3238: FND_API.G_MISS_NUM
3239: , x_header_Payment_tbl OUT NOCOPY OE_Order_PUB.header_Payment_Tbl_Type
3240: , x_return_status OUT NOCOPY VARCHAR2
3234: PROCEDURE Lock_Rows
3235: ( p_payment_number IN NUMBER :=
3236: FND_API.G_MISS_NUM
3237: , p_header_id IN NUMBER :=
3238: FND_API.G_MISS_NUM
3239: , x_header_Payment_tbl OUT NOCOPY OE_Order_PUB.header_Payment_Tbl_Type
3240: , x_return_status OUT NOCOPY VARCHAR2
3241: )
3242: IS
3257: oe_debug_pub.add( 'ENTERING OE_HEADER_PaymentS_UTIL.LOCK_ROWS' , 1 ) ;
3258: END IF;
3259: /*
3260: IF (p_payment_number IS NOT NULL AND
3261: p_payment_number <> FND_API.G_MISS_NUM) AND
3262: (p_header_id IS NOT NULL AND
3263: p_header_id <> FND_API.G_MISS_NUM)
3264: THEN
3265: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3259: /*
3260: IF (p_payment_number IS NOT NULL AND
3261: p_payment_number <> FND_API.G_MISS_NUM) AND
3262: (p_header_id IS NOT NULL AND
3263: p_header_id <> FND_API.G_MISS_NUM)
3264: THEN
3265: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3266: THEN
3267: OE_MSG_PUB.Add_Exc_Msg
3270: , 'Keys are mutually exclusive: payment_number = '||
3271: p_payment_number || ', header_id = '|| p_header_id );
3272: END IF;
3273:
3274: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3275:
3276: END IF;
3277: */
3278: IF p_payment_number <> FND_API.G_MISS_NUM AND
3274: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3275:
3276: END IF;
3277: */
3278: IF p_payment_number <> FND_API.G_MISS_NUM AND
3279: p_header_id <> FND_API.G_MISS_NUM THEN
3280:
3281: SELECT payment_number
3282: INTO l_payment_number
3275:
3276: END IF;
3277: */
3278: IF p_payment_number <> FND_API.G_MISS_NUM AND
3279: p_header_id <> FND_API.G_MISS_NUM THEN
3280:
3281: SELECT payment_number
3282: INTO l_payment_number
3283: FROM OE_PAYMENTS
3289: ELSE
3290:
3291: BEGIN
3292:
3293: IF p_header_id <> FND_API.G_MISS_NUM THEN
3294:
3295: SAVEPOINT LOCK_ROWS;
3296: OPEN lock_hdr_Payments(p_header_id);
3297:
3324: ,p_header_id => p_header_id
3325: ,x_header_Payment_tbl => x_header_Payment_tbl
3326: );
3327:
3328: x_return_status := FND_API.G_RET_STS_SUCCESS;
3329:
3330: IF l_debug_level > 0 THEN
3331: oe_debug_pub.add( 'EXITING OE_HEADER_PaymentS_UTIL.LOCK_ROWS' , 1 ) ;
3332: END IF;
3333:
3334: EXCEPTION
3335: WHEN NO_DATA_FOUND THEN
3336:
3337: x_return_status := FND_API.G_RET_STS_ERROR;
3338:
3339: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3340: THEN
3341: fnd_message.set_name('ONT','OE_LOCK_ROW_DELETED');
3343: END IF;
3344:
3345: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
3346:
3347: x_return_status := FND_API.G_RET_STS_ERROR;
3348: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3349: THEN
3350: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
3351: OE_MSG_PUB.Add;
3352: END IF;
3353:
3354: WHEN OTHERS THEN
3355:
3356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3357:
3358: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3359: THEN
3360: OE_MSG_PUB.Add_Exc_Msg
3380: --
3381: BEGIN
3382:
3383: IF (p_Header_Payment_rec.payment_collection_event IS NULL OR
3384: p_Header_Payment_rec.payment_collection_event <> FND_API.G_MISS_CHAR) AND
3385: NOT OE_GLOBALS.Equal(p_Header_Payment_rec.payment_collection_event,
3386: p_old_Header_Payment_rec.payment_collection_event)
3387: THEN
3388: l_Header_Payment_val_rec.payment_collection_event_name := OE_Id_To_Value.payment_collection_event_name
3390: );
3391: END IF;
3392:
3393: IF (p_Header_Payment_rec.receipt_method_id IS NULL OR
3394: p_Header_Payment_rec.receipt_method_id <> FND_API.G_MISS_NUM) AND
3395: NOT OE_GLOBALS.Equal(p_Header_Payment_rec.receipt_method_id,
3396: p_old_Header_Payment_rec.receipt_method_id)
3397: THEN
3398: l_Header_Payment_val_rec.receipt_method := OE_Id_To_Value.Receipt_Method
3400: );
3401: END IF;
3402:
3403: IF (p_Header_Payment_rec.payment_type_code IS NULL OR
3404: p_Header_Payment_rec.payment_type_code <> FND_API.G_MISS_CHAR) AND
3405: NOT OE_GLOBALS.Equal(p_Header_Payment_rec.payment_type_code,
3406: p_old_Header_Payment_rec.payment_type_code)
3407: THEN
3408: l_Header_Payment_val_rec.payment_type := OE_Id_To_Value.payment_type
3428: BEGIN
3429:
3430: -- initialize return_status.
3431:
3432: p_x_Header_Payment_rec.return_status := FND_API.G_RET_STS_SUCCESS;
3433:
3434: -- initialize l_Header_Payment_rec.
3435:
3436:
3434: -- initialize l_Header_Payment_rec.
3435:
3436:
3437:
3438: IF p_Header_Payment_val_rec.payment_collection_event_name <> FND_API.G_MISS_CHAR
3439: THEN
3440:
3441: IF p_x_Header_Payment_rec.payment_collection_event <> FND_API.G_MISS_CHAR THEN
3442:
3437:
3438: IF p_Header_Payment_val_rec.payment_collection_event_name <> FND_API.G_MISS_CHAR
3439: THEN
3440:
3441: IF p_x_Header_Payment_rec.payment_collection_event <> FND_API.G_MISS_CHAR THEN
3442:
3443: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
3444: THEN
3445:
3454: p_x_Header_Payment_rec.payment_collection_event := OE_Value_To_Id.payment_collection_event_name
3455: ( p_payment_collection_event => p_Header_Payment_val_rec.payment_collection_event_name
3456: );
3457:
3458: IF p_x_Header_Payment_rec.payment_collection_event = FND_API.G_MISS_CHAR THEN
3459: p_x_Header_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
3460: END IF;
3461:
3462: END IF;
3455: ( p_payment_collection_event => p_Header_Payment_val_rec.payment_collection_event_name
3456: );
3457:
3458: IF p_x_Header_Payment_rec.payment_collection_event = FND_API.G_MISS_CHAR THEN
3459: p_x_Header_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
3460: END IF;
3461:
3462: END IF;
3463:
3462: END IF;
3463:
3464: END IF;
3465:
3466: IF p_Header_Payment_val_rec.payment_type <> FND_API.G_MISS_CHAR
3467: THEN
3468:
3469: IF p_x_Header_Payment_rec.payment_type_code <> FND_API.G_MISS_CHAR THEN
3470:
3465:
3466: IF p_Header_Payment_val_rec.payment_type <> FND_API.G_MISS_CHAR
3467: THEN
3468:
3469: IF p_x_Header_Payment_rec.payment_type_code <> FND_API.G_MISS_CHAR THEN
3470:
3471:
3472: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
3473: THEN
3483: p_x_Header_Payment_rec.payment_type_code := OE_Value_To_Id.payment_type
3484: ( p_payment_type => p_Header_Payment_val_rec.payment_type
3485: );
3486:
3487: IF p_x_Header_Payment_rec.payment_type_code = FND_API.G_MISS_CHAR THEN
3488: p_x_Header_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
3489: END IF;
3490:
3491: END IF;
3484: ( p_payment_type => p_Header_Payment_val_rec.payment_type
3485: );
3486:
3487: IF p_x_Header_Payment_rec.payment_type_code = FND_API.G_MISS_CHAR THEN
3488: p_x_Header_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
3489: END IF;
3490:
3491: END IF;
3492:
3492:
3493: END IF;
3494:
3495:
3496: IF p_Header_Payment_val_rec.receipt_method <> FND_API.G_MISS_CHAR
3497: THEN
3498:
3499: IF p_x_Header_Payment_rec.receipt_method_id <> FND_API.G_MISS_NUM THEN
3500:
3495:
3496: IF p_Header_Payment_val_rec.receipt_method <> FND_API.G_MISS_CHAR
3497: THEN
3498:
3499: IF p_x_Header_Payment_rec.receipt_method_id <> FND_API.G_MISS_NUM THEN
3500:
3501:
3502: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
3503: THEN
3513: p_x_Header_Payment_rec.receipt_method_id := OE_Value_To_Id.Receipt_Method
3514: ( p_receipt_method => p_Header_Payment_val_rec.receipt_method
3515: );
3516:
3517: IF p_x_Header_Payment_rec.receipt_method_id = FND_API.G_MISS_NUM THEN
3518: p_x_Header_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
3519: END IF;
3520:
3521: END IF;
3514: ( p_receipt_method => p_Header_Payment_val_rec.receipt_method
3515: );
3516:
3517: IF p_x_Header_Payment_rec.receipt_method_id = FND_API.G_MISS_NUM THEN
3518: p_x_Header_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
3519: END IF;
3520:
3521: END IF;
3522:
3522:
3523: END IF;
3524:
3525: -- Added for bug 8478559
3526: IF p_Header_Payment_val_rec.payment_percentage <> FND_API.G_MISS_NUM THEN
3527:
3528: IF p_x_Header_Payment_rec.payment_percentage <> FND_API.G_MISS_NUM OR
3529: p_x_Header_Payment_rec.payment_amount <> FND_API.G_MISS_NUM
3530: THEN
3524:
3525: -- Added for bug 8478559
3526: IF p_Header_Payment_val_rec.payment_percentage <> FND_API.G_MISS_NUM THEN
3527:
3528: IF p_x_Header_Payment_rec.payment_percentage <> FND_API.G_MISS_NUM OR
3529: p_x_Header_Payment_rec.payment_amount <> FND_API.G_MISS_NUM
3530: THEN
3531:
3532: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
3525: -- Added for bug 8478559
3526: IF p_Header_Payment_val_rec.payment_percentage <> FND_API.G_MISS_NUM THEN
3527:
3528: IF p_x_Header_Payment_rec.payment_percentage <> FND_API.G_MISS_NUM OR
3529: p_x_Header_Payment_rec.payment_amount <> FND_API.G_MISS_NUM
3530: THEN
3531:
3532: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
3533: THEN
3541: p_x_Header_Payment_rec.payment_percentage := OE_Value_To_Id.Payment_Percentage
3542: ( p_payment_percentage => p_Header_Payment_val_rec.payment_percentage
3543: );
3544:
3545: IF p_x_Header_Payment_rec.payment_percentage = FND_API.G_MISS_NUM THEN
3546: p_x_Header_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
3547: END IF;
3548:
3549:
3542: ( p_payment_percentage => p_Header_Payment_val_rec.payment_percentage
3543: );
3544:
3545: IF p_x_Header_Payment_rec.payment_percentage = FND_API.G_MISS_NUM THEN
3546: p_x_Header_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
3547: END IF;
3548:
3549:
3550: END IF;
3635: --oe_debug_pub.add('Old Approval Date'||p_old_header_Payment_rec.credit_card_approval_date);
3636: END IF;
3637:
3638: IF p_x_header_Payment_rec.trxn_extension_id IS NOT NULL AND
3639: p_x_header_Payment_rec.trxn_extension_id <> FND_API.G_MISS_NUM
3640: AND p_x_header_Payment_rec.operation = OE_GLOBALS.G_OPR_CREATE AND
3641: nvl(oe_order_cache.g_header_rec.source_document_type_id, -99) <> 2 -- not a copy order Verify
3642: THEN
3643: --R12 CC Encryption
3657: IF l_debug_level>0 THEN
3658: oe_debug_pub.add('New trxn extension id after calling Copy_Payment_TRXN:'||l_trxn_extension_id);
3659: END IF;
3660: EXCEPTION
3661: WHEN FND_API.G_EXC_ERROR THEN
3662: l_return_status := FND_API.G_RET_STS_ERROR;
3663: RAISE FND_API.G_EXC_ERROR;
3664: WHEN OTHERS THEN
3665: IF l_debug_level>0 THEN
3658: oe_debug_pub.add('New trxn extension id after calling Copy_Payment_TRXN:'||l_trxn_extension_id);
3659: END IF;
3660: EXCEPTION
3661: WHEN FND_API.G_EXC_ERROR THEN
3662: l_return_status := FND_API.G_RET_STS_ERROR;
3663: RAISE FND_API.G_EXC_ERROR;
3664: WHEN OTHERS THEN
3665: IF l_debug_level>0 THEN
3666: oe_debug_pub.add('After call to copy payment trxn - exception');
3659: END IF;
3660: EXCEPTION
3661: WHEN FND_API.G_EXC_ERROR THEN
3662: l_return_status := FND_API.G_RET_STS_ERROR;
3663: RAISE FND_API.G_EXC_ERROR;
3664: WHEN OTHERS THEN
3665: IF l_debug_level>0 THEN
3666: oe_debug_pub.add('After call to copy payment trxn - exception');
3667: END IF;
3664: WHEN OTHERS THEN
3665: IF l_debug_level>0 THEN
3666: oe_debug_pub.add('After call to copy payment trxn - exception');
3667: END IF;
3668: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3669: END;
3670:
3671: p_x_header_payment_rec.trxn_extension_id := l_trxn_extension_id;
3672:
3715: oe_debug_pub.add('Diff approval code');
3716: END IF;
3717: END IF;
3718: IF p_x_header_payment_rec.trxn_extension_id IS NOT NULL
3719: AND p_x_header_payment_rec.trxn_extension_id <> FND_API.G_MISS_NUM
3720: AND ((p_x_header_Payment_rec.payment_type_code = 'CREDIT_CARD'
3721: AND OE_GLOBALS.Is_Same_Credit_Card(p_old_Header_Payment_rec.credit_card_number,
3722: p_x_Header_Payment_rec.credit_card_number,
3723: p_old_Header_Payment_rec.cc_instrument_id,
3746: --While changing the payment type from cash, check etc to
3747: --credit card payment type, the operation would be update but the
3748: --transaction extension id would be null.
3749: ELSIF p_x_header_payment_rec.trxn_extension_id is null or
3750: p_x_header_payment_rec.trxn_extension_id =FND_API.G_MISS_NUM THEN
3751: IF l_debug_level > 0 THEN
3752: oe_debug_pub.add( 'getting payment_trx_id as cc details changed');
3753: oe_debug_pub.add('Operation is Update and trxn extension id is null');
3754: oe_debug_pub.add('Payment type has changed from check or cash to one which requires trxn extension id...');
3763: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use = 'REQUIRED' AND
3764: p_x_Header_Payment_rec.instrument_security_code IS NULL THEN
3765: FND_MESSAGE.SET_NAME('ONT','OE_CC_SECURITY_CODE_REQD');
3766: OE_Msg_Pub.Add;
3767: RAISE FND_API.G_EXC_ERROR;
3768: END IF;
3769: END IF;
3770:
3771: --R12 CC Encryption
3820: IF l_debug_level > 0 THEN
3821: oe_debug_pub.add('New trxn extension id after calling Create_Payment_TRXN:'||p_x_header_payment_rec.trxn_extension_id);
3822: END IF;
3823: Exception
3824: WHEN FND_API.G_EXC_ERROR THEN
3825: OE_MSG_PUB.Count_And_Get
3826: ( p_count => l_msg_count,
3827: p_data => l_msg_data
3828: );
3825: OE_MSG_PUB.Count_And_Get
3826: ( p_count => l_msg_count,
3827: p_data => l_msg_data
3828: );
3829: l_return_status := FND_API.G_RET_STS_ERROR;
3830: RAISE FND_API.G_EXC_ERROR;
3831:
3832: WHEN OTHERS THEN
3833: OE_MSG_PUB.Count_And_Get
3826: ( p_count => l_msg_count,
3827: p_data => l_msg_data
3828: );
3829: l_return_status := FND_API.G_RET_STS_ERROR;
3830: RAISE FND_API.G_EXC_ERROR;
3831:
3832: WHEN OTHERS THEN
3833: OE_MSG_PUB.Count_And_Get
3834: ( p_count => l_msg_count,
3839: IF l_debug_level > 0 THEN
3840: oe_debug_pub.add( 'OEXUHPMB: ERROR IN ARP_BANK_PKG.PROCESS_CUST_BANK_ACCOUNT'||l_msg_data ) ;
3841: oe_debug_pub.add('Error messsge ksurendr'||l_return_status);
3842: END IF;
3843: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3844: end;
3845:
3846: IF l_debug_level > 0 THEN
3847: oe_debug_pub.add( 'Return status...'||l_return_status );
3860: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use = 'REQUIRED'
3861: AND p_x_Header_Payment_rec.instrument_security_code IS NULL THEN
3862: FND_MESSAGE.SET_NAME('ONT','OE_CC_SECURITY_CODE_REQD');
3863: OE_Msg_Pub.Add;
3864: RAISE FND_API.G_EXC_ERROR;
3865: END IF;
3866: END IF;*/
3867:
3868: --R12 CC Encryption
3919: IF l_debug_level > 0 THEN
3920: oe_debug_pub.add('trxn extension id after calling Update_Payment_TRXN:'||p_x_header_payment_rec.trxn_extension_id);
3921: END IF;
3922: EXCEPTION
3923: WHEN FND_API.G_EXC_ERROR THEN
3924:
3925: IF l_debug_level > 0 THEN
3926: oe_debug_pub.add('Update_Payment_TRXN error....exc');
3927: oe_debug_pub.add('After call to Update_Payment_TRXN'||l_return_status);
3926: oe_debug_pub.add('Update_Payment_TRXN error....exc');
3927: oe_debug_pub.add('After call to Update_Payment_TRXN'||l_return_status);
3928: oe_debug_pub.add('Error'||sqlerrm);
3929: END IF;
3930: l_return_status := FND_API.G_RET_STS_ERROR;
3931: OE_MSG_PUB.Count_And_Get
3932: ( p_count => l_msg_count,
3933: p_data => l_msg_data
3934: );
3931: OE_MSG_PUB.Count_And_Get
3932: ( p_count => l_msg_count,
3933: p_data => l_msg_data
3934: );
3935: RAISE FND_API.G_EXC_ERROR;
3936:
3937: WHEN OTHERS THEN
3938: OE_MSG_PUB.Count_And_Get
3939: ( p_count => l_msg_count,
3942: IF l_debug_level > 0 THEN
3943: oe_debug_pub.add('After call to Update_Payment_TRXN --> Unexpected error');
3944: oe_debug_pub.add('Error message '||sqlerrm);
3945: END IF;
3946: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3947: END;
3948:
3949: END IF;
3950:
3969: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use = 'REQUIRED' AND
3970: p_x_Header_Payment_rec.instrument_security_code IS NULL THEN
3971: FND_MESSAGE.SET_NAME('ONT','OE_CC_SECURITY_CODE_REQD');
3972: OE_Msg_Pub.Add;
3973: RAISE FND_API.G_EXC_ERROR;
3974: END IF;
3975: END IF;
3976:
3977: --R12 CC Encryption
4046:
4047: oe_debug_pub.add('New trxn extension id after calling Create_Payment_TRXN:'||p_x_header_payment_rec.trxn_extension_id);
4048:
4049: Exception
4050: WHEN FND_API.G_EXC_ERROR THEN
4051: OE_MSG_PUB.Count_And_Get
4052: ( p_count => l_msg_count,
4053: p_data => l_msg_data
4054: );
4051: OE_MSG_PUB.Count_And_Get
4052: ( p_count => l_msg_count,
4053: p_data => l_msg_data
4054: );
4055: l_return_status := FND_API.G_RET_STS_ERROR;
4056:
4057: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET');
4058: OE_MSG_PUB.ADD;
4059:
4056:
4057: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET');
4058: OE_MSG_PUB.ADD;
4059:
4060: RAISE FND_API.G_EXC_ERROR;
4061:
4062: WHEN OTHERS THEN
4063: OE_MSG_PUB.Count_And_Get
4064: ( p_count => l_msg_count,
4069: IF l_debug_level > 0 THEN
4070: oe_debug_pub.add( 'OEXUHPMB: ERROR IN ARP_BANK_PKG.PROCESS_CUST_BANK_ACCOUNT'||l_msg_data ) ;
4071: oe_debug_pub.add('Error messsge ksurendr'||l_return_status);
4072: END IF;
4073: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4074: end;
4075:
4076: IF l_debug_level > 0 THEN
4077: oe_debug_pub.add( 'after calling process_cust_bank_account. l_bank_acct_id:'||l_bank_acct_id);
4103: p_trxn_extension_id => p_old_header_Payment_rec.trxn_extension_id,
4104: P_site_use_id => null
4105: );
4106:
4107: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4108: RAISE FND_API.G_EXC_ERROR;
4109: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4111: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
4104: P_site_use_id => null
4105: );
4106:
4107: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4108: RAISE FND_API.G_EXC_ERROR;
4109: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4111: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
4112: IF l_debug_level > 0 THEN
4105: );
4106:
4107: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4108: RAISE FND_API.G_EXC_ERROR;
4109: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4111: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
4112: IF l_debug_level > 0 THEN
4113: oe_debug_pub.add('Before setting the trxn extension id to null...');
4106:
4107: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4108: RAISE FND_API.G_EXC_ERROR;
4109: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4111: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
4112: IF l_debug_level > 0 THEN
4113: oe_debug_pub.add('Before setting the trxn extension id to null...');
4114: oe_debug_pub.add('Id that was deleted from iby tables...'||p_old_header_Payment_rec.trxn_extension_id);
4107: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4108: RAISE FND_API.G_EXC_ERROR;
4109: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4111: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
4112: IF l_debug_level > 0 THEN
4113: oe_debug_pub.add('Before setting the trxn extension id to null...');
4114: oe_debug_pub.add('Id that was deleted from iby tables...'||p_old_header_Payment_rec.trxn_extension_id);
4115: END IF;
4142: oe_debug_pub.add('EXITING OE_HEADER_PAYMENT_UTIL.PRE_WRITE_PROCESS');
4143: END IF;
4144:
4145: EXCEPTION
4146: WHEN FND_API.G_EXC_ERROR THEN
4147: IF L_DEBUG_LEVEL > 0 THEN
4148: Oe_debug_pub.add('OEXUHPMB.pls - pre_write_process error ');
4149: END if;
4150: p_x_header_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
4146: WHEN FND_API.G_EXC_ERROR THEN
4147: IF L_DEBUG_LEVEL > 0 THEN
4148: Oe_debug_pub.add('OEXUHPMB.pls - pre_write_process error ');
4149: END if;
4150: p_x_header_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
4151: RAISE FND_API.G_EXC_ERROR;
4152: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4153: IF L_DEBUG_LEVEL > 0 THEN
4154: Oe_debug_pub.add('OEXUHPMB.pls - pre_write_process unexpected error ');
4147: IF L_DEBUG_LEVEL > 0 THEN
4148: Oe_debug_pub.add('OEXUHPMB.pls - pre_write_process error ');
4149: END if;
4150: p_x_header_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
4151: RAISE FND_API.G_EXC_ERROR;
4152: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4153: IF L_DEBUG_LEVEL > 0 THEN
4154: Oe_debug_pub.add('OEXUHPMB.pls - pre_write_process unexpected error ');
4155: END if;
4148: Oe_debug_pub.add('OEXUHPMB.pls - pre_write_process error ');
4149: END if;
4150: p_x_header_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
4151: RAISE FND_API.G_EXC_ERROR;
4152: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4153: IF L_DEBUG_LEVEL > 0 THEN
4154: Oe_debug_pub.add('OEXUHPMB.pls - pre_write_process unexpected error ');
4155: END if;
4156: p_x_header_payment_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4152: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4153: IF L_DEBUG_LEVEL > 0 THEN
4154: Oe_debug_pub.add('OEXUHPMB.pls - pre_write_process unexpected error ');
4155: END if;
4156: p_x_header_payment_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4158:
4159: WHEN OTHERS THEN
4160: IF L_DEBUG_LEVEL > 0 THEN
4153: IF L_DEBUG_LEVEL > 0 THEN
4154: Oe_debug_pub.add('OEXUHPMB.pls - pre_write_process unexpected error ');
4155: END if;
4156: p_x_header_payment_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4158:
4159: WHEN OTHERS THEN
4160: IF L_DEBUG_LEVEL > 0 THEN
4161: Oe_debug_pub.add('OEXUHPMB.pls - pre_write_process unexpected error ');
4159: WHEN OTHERS THEN
4160: IF L_DEBUG_LEVEL > 0 THEN
4161: Oe_debug_pub.add('OEXUHPMB.pls - pre_write_process unexpected error ');
4162: END if;
4163: raise fnD_API.G_EXC_UNEXPECTED_ERROR;
4164:
4165: END Pre_Write_Process;
4166:
4167: --3382262
4201: (p_header_id => p_header_id
4202: ,p_x_header_rec => l_old_header_rec
4203: ,x_return_status => l_return_status
4204: );
4205: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4206: RAISE FND_API.G_EXC_ERROR;
4207: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4208: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4209: END IF;
4202: ,p_x_header_rec => l_old_header_rec
4203: ,x_return_status => l_return_status
4204: );
4205: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4206: RAISE FND_API.G_EXC_ERROR;
4207: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4208: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4209: END IF;
4210:
4203: ,x_return_status => l_return_status
4204: );
4205: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4206: RAISE FND_API.G_EXC_ERROR;
4207: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4208: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4209: END IF;
4210:
4211: l_header_rec := l_old_header_rec;
4204: );
4205: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4206: RAISE FND_API.G_EXC_ERROR;
4207: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4208: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4209: END IF;
4210:
4211: l_header_rec := l_old_header_rec;
4212:
4225: end if;
4226:
4227: Exception
4228:
4229: WHEN FND_API.G_EXC_ERROR THEN
4230: x_return_status := FND_API.G_RET_STS_ERROR;
4231: OE_MSG_PUB.Count_And_Get
4232: ( p_count => x_msg_count,
4233: p_data => x_msg_data
4226:
4227: Exception
4228:
4229: WHEN FND_API.G_EXC_ERROR THEN
4230: x_return_status := FND_API.G_RET_STS_ERROR;
4231: OE_MSG_PUB.Count_And_Get
4232: ( p_count => x_msg_count,
4233: p_data => x_msg_data
4234: );
4232: ( p_count => x_msg_count,
4233: p_data => x_msg_data
4234: );
4235:
4236: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4238: OE_MSG_PUB.Count_And_Get
4239: ( p_count => x_msg_count,
4240: p_data => x_msg_data
4233: p_data => x_msg_data
4234: );
4235:
4236: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4238: OE_MSG_PUB.Count_And_Get
4239: ( p_count => x_msg_count,
4240: p_data => x_msg_data
4241: );
4240: p_data => x_msg_data
4241: );
4242:
4243: WHEN OTHERS THEN
4244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4245: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4246: THEN
4247: OE_MSG_PUB.Add_Exc_Msg
4248: ( G_PKG_NAME