[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: );
1489: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1490: --
1491: BEGIN
1492:
1493: IF p_x_Header_Payment_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1494: p_x_Header_Payment_rec.attribute1 := p_old_Header_Payment_rec.attribute1;
1495: END IF;
1496:
1497: IF p_x_Header_Payment_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1493: IF p_x_Header_Payment_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1494: p_x_Header_Payment_rec.attribute1 := p_old_Header_Payment_rec.attribute1;
1495: END IF;
1496:
1497: IF p_x_Header_Payment_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1498: p_x_Header_Payment_rec.attribute2 := p_old_Header_Payment_rec.attribute2;
1499: END IF;
1500:
1501: IF p_x_Header_Payment_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1497: IF p_x_Header_Payment_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1498: p_x_Header_Payment_rec.attribute2 := p_old_Header_Payment_rec.attribute2;
1499: END IF;
1500:
1501: IF p_x_Header_Payment_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1502: p_x_Header_Payment_rec.attribute3 := p_old_Header_Payment_rec.attribute3;
1503: END IF;
1504:
1505: IF p_x_Header_Payment_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1501: IF p_x_Header_Payment_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1502: p_x_Header_Payment_rec.attribute3 := p_old_Header_Payment_rec.attribute3;
1503: END IF;
1504:
1505: IF p_x_Header_Payment_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1506: p_x_Header_Payment_rec.attribute4 := p_old_Header_Payment_rec.attribute4;
1507: END IF;
1508:
1509: IF p_x_Header_Payment_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1505: IF p_x_Header_Payment_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1506: p_x_Header_Payment_rec.attribute4 := p_old_Header_Payment_rec.attribute4;
1507: END IF;
1508:
1509: IF p_x_Header_Payment_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1510: p_x_Header_Payment_rec.attribute5 := p_old_Header_Payment_rec.attribute5;
1511: END IF;
1512:
1513: IF p_x_Header_Payment_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1509: IF p_x_Header_Payment_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1510: p_x_Header_Payment_rec.attribute5 := p_old_Header_Payment_rec.attribute5;
1511: END IF;
1512:
1513: IF p_x_Header_Payment_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1514: p_x_Header_Payment_rec.attribute6 := p_old_Header_Payment_rec.attribute6;
1515: END IF;
1516:
1517: IF p_x_Header_Payment_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1513: IF p_x_Header_Payment_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1514: p_x_Header_Payment_rec.attribute6 := p_old_Header_Payment_rec.attribute6;
1515: END IF;
1516:
1517: IF p_x_Header_Payment_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1518: p_x_Header_Payment_rec.attribute7 := p_old_Header_Payment_rec.attribute7;
1519: END IF;
1520:
1521: IF p_x_Header_Payment_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1517: IF p_x_Header_Payment_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1518: p_x_Header_Payment_rec.attribute7 := p_old_Header_Payment_rec.attribute7;
1519: END IF;
1520:
1521: IF p_x_Header_Payment_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1522: p_x_Header_Payment_rec.attribute8 := p_old_Header_Payment_rec.attribute8;
1523: END IF;
1524:
1525: IF p_x_Header_Payment_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1521: IF p_x_Header_Payment_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1522: p_x_Header_Payment_rec.attribute8 := p_old_Header_Payment_rec.attribute8;
1523: END IF;
1524:
1525: IF p_x_Header_Payment_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1526: p_x_Header_Payment_rec.attribute9 := p_old_Header_Payment_rec.attribute9;
1527: END IF;
1528:
1529: IF p_x_Header_Payment_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1525: IF p_x_Header_Payment_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1526: p_x_Header_Payment_rec.attribute9 := p_old_Header_Payment_rec.attribute9;
1527: END IF;
1528:
1529: IF p_x_Header_Payment_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1530: p_x_Header_Payment_rec.attribute10 := p_old_Header_Payment_rec.attribute10;
1531: END IF;
1532:
1533: IF p_x_Header_Payment_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1529: IF p_x_Header_Payment_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1530: p_x_Header_Payment_rec.attribute10 := p_old_Header_Payment_rec.attribute10;
1531: END IF;
1532:
1533: IF p_x_Header_Payment_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1534: p_x_Header_Payment_rec.attribute11 := p_old_Header_Payment_rec.attribute11;
1535: END IF;
1536:
1537: IF p_x_Header_Payment_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1533: IF p_x_Header_Payment_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1534: p_x_Header_Payment_rec.attribute11 := p_old_Header_Payment_rec.attribute11;
1535: END IF;
1536:
1537: IF p_x_Header_Payment_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1538: p_x_Header_Payment_rec.attribute12 := p_old_Header_Payment_rec.attribute12;
1539: END IF;
1540:
1541: IF p_x_Header_Payment_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1537: IF p_x_Header_Payment_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1538: p_x_Header_Payment_rec.attribute12 := p_old_Header_Payment_rec.attribute12;
1539: END IF;
1540:
1541: IF p_x_Header_Payment_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1542: p_x_Header_Payment_rec.attribute13 := p_old_Header_Payment_rec.attribute13;
1543: END IF;
1544:
1545: IF p_x_Header_Payment_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1541: IF p_x_Header_Payment_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1542: p_x_Header_Payment_rec.attribute13 := p_old_Header_Payment_rec.attribute13;
1543: END IF;
1544:
1545: IF p_x_Header_Payment_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1546: p_x_Header_Payment_rec.attribute14 := p_old_Header_Payment_rec.attribute14;
1547: END IF;
1548:
1549: IF p_x_Header_Payment_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1545: IF p_x_Header_Payment_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1546: p_x_Header_Payment_rec.attribute14 := p_old_Header_Payment_rec.attribute14;
1547: END IF;
1548:
1549: IF p_x_Header_Payment_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1550: p_x_Header_Payment_rec.attribute15 := p_old_Header_Payment_rec.attribute15;
1551: END IF;
1552:
1553: IF p_x_Header_Payment_rec.context = FND_API.G_MISS_CHAR THEN
1549: IF p_x_Header_Payment_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1550: p_x_Header_Payment_rec.attribute15 := p_old_Header_Payment_rec.attribute15;
1551: END IF;
1552:
1553: IF p_x_Header_Payment_rec.context = FND_API.G_MISS_CHAR THEN
1554: p_x_Header_Payment_rec.context := p_old_Header_Payment_rec.context;
1555: END IF;
1556:
1557: IF p_x_Header_Payment_rec.created_by = FND_API.G_MISS_NUM THEN
1553: IF p_x_Header_Payment_rec.context = FND_API.G_MISS_CHAR THEN
1554: p_x_Header_Payment_rec.context := p_old_Header_Payment_rec.context;
1555: END IF;
1556:
1557: IF p_x_Header_Payment_rec.created_by = FND_API.G_MISS_NUM THEN
1558: p_x_Header_Payment_rec.created_by := p_old_Header_Payment_rec.created_by;
1559: END IF;
1560:
1561: IF p_x_Header_Payment_rec.creation_date = FND_API.G_MISS_DATE THEN
1557: IF p_x_Header_Payment_rec.created_by = FND_API.G_MISS_NUM THEN
1558: p_x_Header_Payment_rec.created_by := p_old_Header_Payment_rec.created_by;
1559: END IF;
1560:
1561: IF p_x_Header_Payment_rec.creation_date = FND_API.G_MISS_DATE THEN
1562: p_x_Header_Payment_rec.creation_date := p_old_Header_Payment_rec.creation_date;
1563: END IF;
1564:
1565: IF p_x_Header_Payment_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1561: IF p_x_Header_Payment_rec.creation_date = FND_API.G_MISS_DATE THEN
1562: p_x_Header_Payment_rec.creation_date := p_old_Header_Payment_rec.creation_date;
1563: END IF;
1564:
1565: IF p_x_Header_Payment_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1566: p_x_Header_Payment_rec.last_updated_by := p_old_Header_Payment_rec.last_updated_by;
1567: END IF;
1568:
1569: IF p_x_Header_Payment_rec.last_update_date = FND_API.G_MISS_DATE THEN
1565: IF p_x_Header_Payment_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1566: p_x_Header_Payment_rec.last_updated_by := p_old_Header_Payment_rec.last_updated_by;
1567: END IF;
1568:
1569: IF p_x_Header_Payment_rec.last_update_date = FND_API.G_MISS_DATE THEN
1570: p_x_Header_Payment_rec.last_update_date := p_old_Header_Payment_rec.last_update_date;
1571: END IF;
1572:
1573: IF p_x_Header_Payment_rec.last_update_login = FND_API.G_MISS_NUM THEN
1569: IF p_x_Header_Payment_rec.last_update_date = FND_API.G_MISS_DATE THEN
1570: p_x_Header_Payment_rec.last_update_date := p_old_Header_Payment_rec.last_update_date;
1571: END IF;
1572:
1573: IF p_x_Header_Payment_rec.last_update_login = FND_API.G_MISS_NUM THEN
1574: p_x_Header_Payment_rec.last_update_login := p_old_Header_Payment_rec.last_update_login;
1575: END IF;
1576:
1577: IF p_x_Header_Payment_rec.check_number = FND_API.G_MISS_CHAR THEN
1573: IF p_x_Header_Payment_rec.last_update_login = FND_API.G_MISS_NUM THEN
1574: p_x_Header_Payment_rec.last_update_login := p_old_Header_Payment_rec.last_update_login;
1575: END IF;
1576:
1577: IF p_x_Header_Payment_rec.check_number = FND_API.G_MISS_CHAR THEN
1578: p_x_Header_Payment_rec.check_number := p_old_Header_Payment_rec.check_number;
1579: END IF;
1580:
1581: IF p_x_Header_Payment_rec.credit_card_approval_code = FND_API.G_MISS_CHAR THEN
1577: IF p_x_Header_Payment_rec.check_number = FND_API.G_MISS_CHAR THEN
1578: p_x_Header_Payment_rec.check_number := p_old_Header_Payment_rec.check_number;
1579: END IF;
1580:
1581: IF p_x_Header_Payment_rec.credit_card_approval_code = FND_API.G_MISS_CHAR THEN
1582: p_x_Header_Payment_rec.credit_card_approval_code := p_old_Header_Payment_rec.credit_card_approval_code;
1583: END IF;
1584:
1585: IF p_x_Header_Payment_rec.credit_card_approval_date = FND_API.G_MISS_DATE THEN
1581: IF p_x_Header_Payment_rec.credit_card_approval_code = FND_API.G_MISS_CHAR THEN
1582: p_x_Header_Payment_rec.credit_card_approval_code := p_old_Header_Payment_rec.credit_card_approval_code;
1583: END IF;
1584:
1585: IF p_x_Header_Payment_rec.credit_card_approval_date = FND_API.G_MISS_DATE THEN
1586: p_x_Header_Payment_rec.credit_card_approval_date := p_old_Header_Payment_rec.credit_card_approval_date;
1587: END IF;
1588:
1589: IF p_x_Header_Payment_rec.credit_card_code = FND_API.G_MISS_CHAR THEN
1585: IF p_x_Header_Payment_rec.credit_card_approval_date = FND_API.G_MISS_DATE THEN
1586: p_x_Header_Payment_rec.credit_card_approval_date := p_old_Header_Payment_rec.credit_card_approval_date;
1587: END IF;
1588:
1589: IF p_x_Header_Payment_rec.credit_card_code = FND_API.G_MISS_CHAR THEN
1590: p_x_Header_Payment_rec.credit_card_code := p_old_Header_Payment_rec.credit_card_code;
1591: END IF;
1592:
1593: IF p_x_Header_Payment_rec.credit_card_expiration_date = FND_API.G_MISS_DATE THEN
1589: IF p_x_Header_Payment_rec.credit_card_code = FND_API.G_MISS_CHAR THEN
1590: p_x_Header_Payment_rec.credit_card_code := p_old_Header_Payment_rec.credit_card_code;
1591: END IF;
1592:
1593: IF p_x_Header_Payment_rec.credit_card_expiration_date = FND_API.G_MISS_DATE THEN
1594: p_x_Header_Payment_rec.credit_card_expiration_date := p_old_Header_Payment_rec.credit_card_expiration_date;
1595: END IF;
1596:
1597: IF p_x_Header_Payment_rec.credit_card_holder_name = FND_API.G_MISS_CHAR THEN
1593: IF p_x_Header_Payment_rec.credit_card_expiration_date = FND_API.G_MISS_DATE THEN
1594: p_x_Header_Payment_rec.credit_card_expiration_date := p_old_Header_Payment_rec.credit_card_expiration_date;
1595: END IF;
1596:
1597: IF p_x_Header_Payment_rec.credit_card_holder_name = FND_API.G_MISS_CHAR THEN
1598: p_x_Header_Payment_rec.credit_card_holder_name := p_old_Header_Payment_rec.credit_card_holder_name;
1599: END IF;
1600:
1601: IF p_x_Header_Payment_rec.credit_card_number = FND_API.G_MISS_CHAR THEN
1597: IF p_x_Header_Payment_rec.credit_card_holder_name = FND_API.G_MISS_CHAR THEN
1598: p_x_Header_Payment_rec.credit_card_holder_name := p_old_Header_Payment_rec.credit_card_holder_name;
1599: END IF;
1600:
1601: IF p_x_Header_Payment_rec.credit_card_number = FND_API.G_MISS_CHAR THEN
1602: p_x_Header_Payment_rec.credit_card_number := p_old_Header_Payment_rec.credit_card_number;
1603: END IF;
1604:
1605: IF p_x_Header_Payment_rec.payment_level_code = FND_API.G_MISS_CHAR THEN
1601: IF p_x_Header_Payment_rec.credit_card_number = FND_API.G_MISS_CHAR THEN
1602: p_x_Header_Payment_rec.credit_card_number := p_old_Header_Payment_rec.credit_card_number;
1603: END IF;
1604:
1605: IF p_x_Header_Payment_rec.payment_level_code = FND_API.G_MISS_CHAR THEN
1606: p_x_Header_Payment_rec.payment_level_code := p_old_Header_Payment_rec.payment_level_code;
1607: END IF;
1608:
1609: IF p_x_Header_Payment_rec.commitment_applied_amount = FND_API.G_MISS_NUM THEN
1605: IF p_x_Header_Payment_rec.payment_level_code = FND_API.G_MISS_CHAR THEN
1606: p_x_Header_Payment_rec.payment_level_code := p_old_Header_Payment_rec.payment_level_code;
1607: END IF;
1608:
1609: IF p_x_Header_Payment_rec.commitment_applied_amount = FND_API.G_MISS_NUM THEN
1610: p_x_Header_Payment_rec.commitment_applied_amount := p_old_Header_Payment_rec.commitment_applied_amount;
1611: END IF;
1612:
1613: IF p_x_Header_Payment_rec.commitment_interfaced_amount = FND_API.G_MISS_NUM THEN
1609: IF p_x_Header_Payment_rec.commitment_applied_amount = FND_API.G_MISS_NUM THEN
1610: p_x_Header_Payment_rec.commitment_applied_amount := p_old_Header_Payment_rec.commitment_applied_amount;
1611: END IF;
1612:
1613: IF p_x_Header_Payment_rec.commitment_interfaced_amount = FND_API.G_MISS_NUM THEN
1614: p_x_Header_Payment_rec.commitment_interfaced_amount := p_old_Header_Payment_rec.commitment_interfaced_amount;
1615: END IF;
1616:
1617: IF p_x_Header_Payment_rec.payment_number = FND_API.G_MISS_NUM THEN
1613: IF p_x_Header_Payment_rec.commitment_interfaced_amount = FND_API.G_MISS_NUM THEN
1614: p_x_Header_Payment_rec.commitment_interfaced_amount := p_old_Header_Payment_rec.commitment_interfaced_amount;
1615: END IF;
1616:
1617: IF p_x_Header_Payment_rec.payment_number = FND_API.G_MISS_NUM THEN
1618: p_x_Header_Payment_rec.payment_number := p_old_Header_Payment_rec.payment_number;
1619: END IF;
1620:
1621: IF p_x_Header_Payment_rec.header_id = FND_API.G_MISS_NUM THEN
1617: IF p_x_Header_Payment_rec.payment_number = FND_API.G_MISS_NUM THEN
1618: p_x_Header_Payment_rec.payment_number := p_old_Header_Payment_rec.payment_number;
1619: END IF;
1620:
1621: IF p_x_Header_Payment_rec.header_id = FND_API.G_MISS_NUM THEN
1622: p_x_Header_Payment_rec.header_id := p_old_Header_Payment_rec.header_id;
1623: END IF;
1624:
1625: IF p_x_Header_Payment_rec.line_id = FND_API.G_MISS_NUM THEN
1621: IF p_x_Header_Payment_rec.header_id = FND_API.G_MISS_NUM THEN
1622: p_x_Header_Payment_rec.header_id := p_old_Header_Payment_rec.header_id;
1623: END IF;
1624:
1625: IF p_x_Header_Payment_rec.line_id = FND_API.G_MISS_NUM THEN
1626: p_x_Header_Payment_rec.line_id := p_old_Header_Payment_rec.line_id;
1627: END IF;
1628:
1629: IF p_x_Header_Payment_rec.payment_amount = FND_API.G_MISS_NUM THEN
1625: IF p_x_Header_Payment_rec.line_id = FND_API.G_MISS_NUM THEN
1626: p_x_Header_Payment_rec.line_id := p_old_Header_Payment_rec.line_id;
1627: END IF;
1628:
1629: IF p_x_Header_Payment_rec.payment_amount = FND_API.G_MISS_NUM THEN
1630: p_x_Header_Payment_rec.payment_amount := p_old_Header_Payment_rec.payment_amount;
1631: END IF;
1632:
1633: IF p_x_Header_Payment_rec.payment_collection_event = FND_API.G_MISS_CHAR THEN
1629: IF p_x_Header_Payment_rec.payment_amount = FND_API.G_MISS_NUM THEN
1630: p_x_Header_Payment_rec.payment_amount := p_old_Header_Payment_rec.payment_amount;
1631: END IF;
1632:
1633: IF p_x_Header_Payment_rec.payment_collection_event = FND_API.G_MISS_CHAR THEN
1634: p_x_Header_Payment_rec.payment_collection_event := p_old_Header_Payment_rec.payment_collection_event;
1635: END IF;
1636:
1637: IF p_x_Header_Payment_rec.defer_payment_processing_flag = FND_API.G_MISS_CHAR THEN
1633: IF p_x_Header_Payment_rec.payment_collection_event = FND_API.G_MISS_CHAR THEN
1634: p_x_Header_Payment_rec.payment_collection_event := p_old_Header_Payment_rec.payment_collection_event;
1635: END IF;
1636:
1637: IF p_x_Header_Payment_rec.defer_payment_processing_flag = FND_API.G_MISS_CHAR THEN
1638: p_x_Header_Payment_rec.defer_payment_processing_flag := p_old_Header_Payment_rec.defer_payment_processing_flag;
1639: END IF;
1640:
1641: IF p_x_Header_Payment_rec.payment_trx_id = FND_API.G_MISS_NUM THEN
1637: IF p_x_Header_Payment_rec.defer_payment_processing_flag = FND_API.G_MISS_CHAR THEN
1638: p_x_Header_Payment_rec.defer_payment_processing_flag := p_old_Header_Payment_rec.defer_payment_processing_flag;
1639: END IF;
1640:
1641: IF p_x_Header_Payment_rec.payment_trx_id = FND_API.G_MISS_NUM THEN
1642: p_x_Header_Payment_rec.payment_trx_id := p_old_Header_Payment_rec.payment_trx_id;
1643: END IF;
1644:
1645: IF p_x_Header_Payment_rec.payment_type_code = FND_API.G_MISS_CHAR THEN
1641: IF p_x_Header_Payment_rec.payment_trx_id = FND_API.G_MISS_NUM THEN
1642: p_x_Header_Payment_rec.payment_trx_id := p_old_Header_Payment_rec.payment_trx_id;
1643: END IF;
1644:
1645: IF p_x_Header_Payment_rec.payment_type_code = FND_API.G_MISS_CHAR THEN
1646: p_x_Header_Payment_rec.payment_type_code := p_old_Header_Payment_rec.payment_type_code;
1647: END IF;
1648:
1649: IF p_x_Header_Payment_rec.payment_set_id = FND_API.G_MISS_NUM THEN
1645: IF p_x_Header_Payment_rec.payment_type_code = FND_API.G_MISS_CHAR THEN
1646: p_x_Header_Payment_rec.payment_type_code := p_old_Header_Payment_rec.payment_type_code;
1647: END IF;
1648:
1649: IF p_x_Header_Payment_rec.payment_set_id = FND_API.G_MISS_NUM THEN
1650: p_x_Header_Payment_rec.payment_set_id := p_old_Header_Payment_rec.payment_set_id;
1651: END IF;
1652:
1653: IF p_x_Header_Payment_rec.prepaid_amount = FND_API.G_MISS_NUM THEN
1649: IF p_x_Header_Payment_rec.payment_set_id = FND_API.G_MISS_NUM THEN
1650: p_x_Header_Payment_rec.payment_set_id := p_old_Header_Payment_rec.payment_set_id;
1651: END IF;
1652:
1653: IF p_x_Header_Payment_rec.prepaid_amount = FND_API.G_MISS_NUM THEN
1654: p_x_Header_Payment_rec.prepaid_amount := p_old_Header_Payment_rec.prepaid_amount;
1655: END IF;
1656:
1657: IF p_x_Header_Payment_rec.program_application_id = FND_API.G_MISS_NUM THEN
1653: IF p_x_Header_Payment_rec.prepaid_amount = FND_API.G_MISS_NUM THEN
1654: p_x_Header_Payment_rec.prepaid_amount := p_old_Header_Payment_rec.prepaid_amount;
1655: END IF;
1656:
1657: IF p_x_Header_Payment_rec.program_application_id = FND_API.G_MISS_NUM THEN
1658: p_x_Header_Payment_rec.program_application_id := p_old_Header_Payment_rec.program_application_id;
1659: END IF;
1660:
1661: IF p_x_Header_Payment_rec.program_id = FND_API.G_MISS_NUM THEN
1657: IF p_x_Header_Payment_rec.program_application_id = FND_API.G_MISS_NUM THEN
1658: p_x_Header_Payment_rec.program_application_id := p_old_Header_Payment_rec.program_application_id;
1659: END IF;
1660:
1661: IF p_x_Header_Payment_rec.program_id = FND_API.G_MISS_NUM THEN
1662: p_x_Header_Payment_rec.program_id := p_old_Header_Payment_rec.program_id;
1663: END IF;
1664:
1665: IF p_x_Header_Payment_rec.program_update_date = FND_API.G_MISS_DATE THEN
1661: IF p_x_Header_Payment_rec.program_id = FND_API.G_MISS_NUM THEN
1662: p_x_Header_Payment_rec.program_id := p_old_Header_Payment_rec.program_id;
1663: END IF;
1664:
1665: IF p_x_Header_Payment_rec.program_update_date = FND_API.G_MISS_DATE THEN
1666: p_x_Header_Payment_rec.program_update_date := p_old_Header_Payment_rec.program_update_date;
1667: END IF;
1668:
1669: IF p_x_Header_Payment_rec.receipt_method_id = FND_API.G_MISS_NUM THEN
1665: IF p_x_Header_Payment_rec.program_update_date = FND_API.G_MISS_DATE THEN
1666: p_x_Header_Payment_rec.program_update_date := p_old_Header_Payment_rec.program_update_date;
1667: END IF;
1668:
1669: IF p_x_Header_Payment_rec.receipt_method_id = FND_API.G_MISS_NUM THEN
1670: p_x_Header_Payment_rec.receipt_method_id := p_old_Header_Payment_rec.receipt_method_id;
1671: END IF;
1672:
1673: IF p_x_Header_Payment_rec.request_id = FND_API.G_MISS_NUM THEN
1669: IF p_x_Header_Payment_rec.receipt_method_id = FND_API.G_MISS_NUM THEN
1670: p_x_Header_Payment_rec.receipt_method_id := p_old_Header_Payment_rec.receipt_method_id;
1671: END IF;
1672:
1673: IF p_x_Header_Payment_rec.request_id = FND_API.G_MISS_NUM THEN
1674: p_x_Header_Payment_rec.request_id := p_old_Header_Payment_rec.request_id;
1675: END IF;
1676:
1677: IF p_x_Header_Payment_rec.tangible_id = FND_API.G_MISS_CHAR THEN
1673: IF p_x_Header_Payment_rec.request_id = FND_API.G_MISS_NUM THEN
1674: p_x_Header_Payment_rec.request_id := p_old_Header_Payment_rec.request_id;
1675: END IF;
1676:
1677: IF p_x_Header_Payment_rec.tangible_id = FND_API.G_MISS_CHAR THEN
1678: p_x_Header_Payment_rec.tangible_id := p_old_Header_Payment_rec.tangible_id;
1679: END IF;
1680:
1681: IF p_x_Header_Payment_rec.trxn_extension_id = FND_API.G_MISS_NUM THEN
1677: IF p_x_Header_Payment_rec.tangible_id = FND_API.G_MISS_CHAR THEN
1678: p_x_Header_Payment_rec.tangible_id := p_old_Header_Payment_rec.tangible_id;
1679: END IF;
1680:
1681: IF p_x_Header_Payment_rec.trxn_extension_id = FND_API.G_MISS_NUM THEN
1682: p_x_Header_Payment_rec.trxn_extension_id := p_old_Header_Payment_rec.trxn_extension_id;
1683: END IF;
1684:
1685: --R12 CC Encryption
1682: p_x_Header_Payment_rec.trxn_extension_id := p_old_Header_Payment_rec.trxn_extension_id;
1683: END IF;
1684:
1685: --R12 CC Encryption
1686: IF p_x_Header_Payment_rec.trxn_extension_id = FND_API.G_MISS_NUM THEN
1687: p_x_Header_Payment_rec.trxn_extension_id := p_old_Header_Payment_rec.trxn_extension_id;
1688: END IF;
1689:
1690: IF p_x_Header_Payment_rec.instrument_security_code = FND_API.G_MISS_CHAR THEN
1686: IF p_x_Header_Payment_rec.trxn_extension_id = FND_API.G_MISS_NUM THEN
1687: p_x_Header_Payment_rec.trxn_extension_id := p_old_Header_Payment_rec.trxn_extension_id;
1688: END IF;
1689:
1690: IF p_x_Header_Payment_rec.instrument_security_code = FND_API.G_MISS_CHAR THEN
1691: p_x_Header_Payment_rec.instrument_security_code := p_old_Header_Payment_rec.instrument_security_code;
1692: END IF;
1693: --R12 CC Encryption
1694:
1705: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1706: --
1707: BEGIN
1708:
1709: IF p_x_Header_Payment_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1710: p_x_Header_Payment_rec.attribute1 := NULL;
1711: END IF;
1712:
1713: IF p_x_Header_Payment_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1709: IF p_x_Header_Payment_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1710: p_x_Header_Payment_rec.attribute1 := NULL;
1711: END IF;
1712:
1713: IF p_x_Header_Payment_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1714: p_x_Header_Payment_rec.attribute2 := NULL;
1715: END IF;
1716:
1717: IF p_x_Header_Payment_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1713: IF p_x_Header_Payment_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1714: p_x_Header_Payment_rec.attribute2 := NULL;
1715: END IF;
1716:
1717: IF p_x_Header_Payment_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1718: p_x_Header_Payment_rec.attribute3 := NULL;
1719: END IF;
1720:
1721: IF p_x_Header_Payment_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1717: IF p_x_Header_Payment_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1718: p_x_Header_Payment_rec.attribute3 := NULL;
1719: END IF;
1720:
1721: IF p_x_Header_Payment_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1722: p_x_Header_Payment_rec.attribute4 := NULL;
1723: END IF;
1724:
1725: IF p_x_Header_Payment_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1721: IF p_x_Header_Payment_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1722: p_x_Header_Payment_rec.attribute4 := NULL;
1723: END IF;
1724:
1725: IF p_x_Header_Payment_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1726: p_x_Header_Payment_rec.attribute5 := NULL;
1727: END IF;
1728:
1729: IF p_x_Header_Payment_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1725: IF p_x_Header_Payment_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1726: p_x_Header_Payment_rec.attribute5 := NULL;
1727: END IF;
1728:
1729: IF p_x_Header_Payment_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1730: p_x_Header_Payment_rec.attribute6 := NULL;
1731: END IF;
1732:
1733: IF p_x_Header_Payment_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1729: IF p_x_Header_Payment_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1730: p_x_Header_Payment_rec.attribute6 := NULL;
1731: END IF;
1732:
1733: IF p_x_Header_Payment_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1734: p_x_Header_Payment_rec.attribute7 := NULL;
1735: END IF;
1736:
1737: IF p_x_Header_Payment_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1733: IF p_x_Header_Payment_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1734: p_x_Header_Payment_rec.attribute7 := NULL;
1735: END IF;
1736:
1737: IF p_x_Header_Payment_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1738: p_x_Header_Payment_rec.attribute8 := NULL;
1739: END IF;
1740:
1741: IF p_x_Header_Payment_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1737: IF p_x_Header_Payment_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1738: p_x_Header_Payment_rec.attribute8 := NULL;
1739: END IF;
1740:
1741: IF p_x_Header_Payment_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1742: p_x_Header_Payment_rec.attribute9 := NULL;
1743: END IF;
1744:
1745: IF p_x_Header_Payment_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1741: IF p_x_Header_Payment_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1742: p_x_Header_Payment_rec.attribute9 := NULL;
1743: END IF;
1744:
1745: IF p_x_Header_Payment_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1746: p_x_Header_Payment_rec.attribute10 := NULL;
1747: END IF;
1748:
1749: IF p_x_Header_Payment_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1745: IF p_x_Header_Payment_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1746: p_x_Header_Payment_rec.attribute10 := NULL;
1747: END IF;
1748:
1749: IF p_x_Header_Payment_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1750: p_x_Header_Payment_rec.attribute11 := NULL;
1751: END IF;
1752:
1753: IF p_x_Header_Payment_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1749: IF p_x_Header_Payment_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1750: p_x_Header_Payment_rec.attribute11 := NULL;
1751: END IF;
1752:
1753: IF p_x_Header_Payment_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1754: p_x_Header_Payment_rec.attribute12 := NULL;
1755: END IF;
1756:
1757: IF p_x_Header_Payment_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1753: IF p_x_Header_Payment_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1754: p_x_Header_Payment_rec.attribute12 := NULL;
1755: END IF;
1756:
1757: IF p_x_Header_Payment_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1758: p_x_Header_Payment_rec.attribute13 := NULL;
1759: END IF;
1760:
1761: IF p_x_Header_Payment_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1757: IF p_x_Header_Payment_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1758: p_x_Header_Payment_rec.attribute13 := NULL;
1759: END IF;
1760:
1761: IF p_x_Header_Payment_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1762: p_x_Header_Payment_rec.attribute14 := NULL;
1763: END IF;
1764:
1765: IF p_x_Header_Payment_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1761: IF p_x_Header_Payment_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1762: p_x_Header_Payment_rec.attribute14 := NULL;
1763: END IF;
1764:
1765: IF p_x_Header_Payment_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1766: p_x_Header_Payment_rec.attribute15 := NULL;
1767: END IF;
1768:
1769: IF p_x_Header_Payment_rec.context = FND_API.G_MISS_CHAR THEN
1765: IF p_x_Header_Payment_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1766: p_x_Header_Payment_rec.attribute15 := NULL;
1767: END IF;
1768:
1769: IF p_x_Header_Payment_rec.context = FND_API.G_MISS_CHAR THEN
1770: p_x_Header_Payment_rec.context := NULL;
1771: END IF;
1772:
1773: IF p_x_Header_Payment_rec.created_by = FND_API.G_MISS_NUM THEN
1769: IF p_x_Header_Payment_rec.context = FND_API.G_MISS_CHAR THEN
1770: p_x_Header_Payment_rec.context := NULL;
1771: END IF;
1772:
1773: IF p_x_Header_Payment_rec.created_by = FND_API.G_MISS_NUM THEN
1774: p_x_Header_Payment_rec.created_by := NULL;
1775: END IF;
1776:
1777: IF p_x_Header_Payment_rec.creation_date = FND_API.G_MISS_DATE THEN
1773: IF p_x_Header_Payment_rec.created_by = FND_API.G_MISS_NUM THEN
1774: p_x_Header_Payment_rec.created_by := NULL;
1775: END IF;
1776:
1777: IF p_x_Header_Payment_rec.creation_date = FND_API.G_MISS_DATE THEN
1778: p_x_Header_Payment_rec.creation_date := NULL;
1779: END IF;
1780:
1781: IF p_x_Header_Payment_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1777: IF p_x_Header_Payment_rec.creation_date = FND_API.G_MISS_DATE THEN
1778: p_x_Header_Payment_rec.creation_date := NULL;
1779: END IF;
1780:
1781: IF p_x_Header_Payment_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1782: p_x_Header_Payment_rec.last_updated_by := NULL;
1783: END IF;
1784:
1785: IF p_x_Header_Payment_rec.last_update_date = FND_API.G_MISS_DATE THEN
1781: IF p_x_Header_Payment_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1782: p_x_Header_Payment_rec.last_updated_by := NULL;
1783: END IF;
1784:
1785: IF p_x_Header_Payment_rec.last_update_date = FND_API.G_MISS_DATE THEN
1786: p_x_Header_Payment_rec.last_update_date := NULL;
1787: END IF;
1788:
1789: IF p_x_Header_Payment_rec.last_update_login = FND_API.G_MISS_NUM THEN
1785: IF p_x_Header_Payment_rec.last_update_date = FND_API.G_MISS_DATE THEN
1786: p_x_Header_Payment_rec.last_update_date := NULL;
1787: END IF;
1788:
1789: IF p_x_Header_Payment_rec.last_update_login = FND_API.G_MISS_NUM THEN
1790: p_x_Header_Payment_rec.last_update_login := NULL;
1791: END IF;
1792:
1793: IF p_x_Header_Payment_rec.check_number = FND_API.G_MISS_CHAR THEN
1789: IF p_x_Header_Payment_rec.last_update_login = FND_API.G_MISS_NUM THEN
1790: p_x_Header_Payment_rec.last_update_login := NULL;
1791: END IF;
1792:
1793: IF p_x_Header_Payment_rec.check_number = FND_API.G_MISS_CHAR THEN
1794: p_x_Header_Payment_rec.check_number := NULL;
1795: END IF;
1796:
1797: IF p_x_Header_Payment_rec.credit_card_approval_code = FND_API.G_MISS_CHAR THEN
1793: IF p_x_Header_Payment_rec.check_number = FND_API.G_MISS_CHAR THEN
1794: p_x_Header_Payment_rec.check_number := NULL;
1795: END IF;
1796:
1797: IF p_x_Header_Payment_rec.credit_card_approval_code = FND_API.G_MISS_CHAR THEN
1798: p_x_Header_Payment_rec.credit_card_approval_code := NULL;
1799: END IF;
1800:
1801: IF p_x_Header_Payment_rec.credit_card_approval_date = FND_API.G_MISS_DATE THEN
1797: IF p_x_Header_Payment_rec.credit_card_approval_code = FND_API.G_MISS_CHAR THEN
1798: p_x_Header_Payment_rec.credit_card_approval_code := NULL;
1799: END IF;
1800:
1801: IF p_x_Header_Payment_rec.credit_card_approval_date = FND_API.G_MISS_DATE THEN
1802: p_x_Header_Payment_rec.credit_card_approval_date := NULL;
1803: END IF;
1804:
1805: IF p_x_Header_Payment_rec.credit_card_code = FND_API.G_MISS_CHAR THEN
1801: IF p_x_Header_Payment_rec.credit_card_approval_date = FND_API.G_MISS_DATE THEN
1802: p_x_Header_Payment_rec.credit_card_approval_date := NULL;
1803: END IF;
1804:
1805: IF p_x_Header_Payment_rec.credit_card_code = FND_API.G_MISS_CHAR THEN
1806: p_x_Header_Payment_rec.credit_card_code := NULL;
1807: END IF;
1808:
1809: IF p_x_Header_Payment_rec.credit_card_expiration_date = FND_API.G_MISS_DATE THEN
1805: IF p_x_Header_Payment_rec.credit_card_code = FND_API.G_MISS_CHAR THEN
1806: p_x_Header_Payment_rec.credit_card_code := NULL;
1807: END IF;
1808:
1809: IF p_x_Header_Payment_rec.credit_card_expiration_date = FND_API.G_MISS_DATE THEN
1810: p_x_Header_Payment_rec.credit_card_expiration_date := NULL;
1811: END IF;
1812:
1813: IF p_x_Header_Payment_rec.credit_card_holder_name = FND_API.G_MISS_CHAR THEN
1809: IF p_x_Header_Payment_rec.credit_card_expiration_date = FND_API.G_MISS_DATE THEN
1810: p_x_Header_Payment_rec.credit_card_expiration_date := NULL;
1811: END IF;
1812:
1813: IF p_x_Header_Payment_rec.credit_card_holder_name = FND_API.G_MISS_CHAR THEN
1814: p_x_Header_Payment_rec.credit_card_holder_name := NULL;
1815: END IF;
1816:
1817: IF p_x_Header_Payment_rec.credit_card_number = FND_API.G_MISS_CHAR THEN
1813: IF p_x_Header_Payment_rec.credit_card_holder_name = FND_API.G_MISS_CHAR THEN
1814: p_x_Header_Payment_rec.credit_card_holder_name := NULL;
1815: END IF;
1816:
1817: IF p_x_Header_Payment_rec.credit_card_number = FND_API.G_MISS_CHAR THEN
1818: p_x_Header_Payment_rec.credit_card_number := NULL;
1819: END IF;
1820:
1821: IF p_x_Header_Payment_rec.payment_level_code = FND_API.G_MISS_CHAR THEN
1817: IF p_x_Header_Payment_rec.credit_card_number = FND_API.G_MISS_CHAR THEN
1818: p_x_Header_Payment_rec.credit_card_number := NULL;
1819: END IF;
1820:
1821: IF p_x_Header_Payment_rec.payment_level_code = FND_API.G_MISS_CHAR THEN
1822: p_x_Header_Payment_rec.payment_level_code := NULL;
1823: END IF;
1824:
1825: IF p_x_Header_Payment_rec.commitment_applied_amount = FND_API.G_MISS_NUM THEN
1821: IF p_x_Header_Payment_rec.payment_level_code = FND_API.G_MISS_CHAR THEN
1822: p_x_Header_Payment_rec.payment_level_code := NULL;
1823: END IF;
1824:
1825: IF p_x_Header_Payment_rec.commitment_applied_amount = FND_API.G_MISS_NUM THEN
1826: p_x_Header_Payment_rec.commitment_applied_amount := NULL;
1827: END IF;
1828:
1829: IF p_x_Header_Payment_rec.commitment_interfaced_amount = FND_API.G_MISS_NUM THEN
1825: IF p_x_Header_Payment_rec.commitment_applied_amount = FND_API.G_MISS_NUM THEN
1826: p_x_Header_Payment_rec.commitment_applied_amount := NULL;
1827: END IF;
1828:
1829: IF p_x_Header_Payment_rec.commitment_interfaced_amount = FND_API.G_MISS_NUM THEN
1830: p_x_Header_Payment_rec.commitment_interfaced_amount := NULL;
1831: END IF;
1832:
1833: IF p_x_Header_Payment_rec.payment_number = FND_API.G_MISS_NUM THEN
1829: IF p_x_Header_Payment_rec.commitment_interfaced_amount = FND_API.G_MISS_NUM THEN
1830: p_x_Header_Payment_rec.commitment_interfaced_amount := NULL;
1831: END IF;
1832:
1833: IF p_x_Header_Payment_rec.payment_number = FND_API.G_MISS_NUM THEN
1834: p_x_Header_Payment_rec.payment_number := NULL;
1835: END IF;
1836:
1837: IF p_x_Header_Payment_rec.header_id = FND_API.G_MISS_NUM THEN
1833: IF p_x_Header_Payment_rec.payment_number = FND_API.G_MISS_NUM THEN
1834: p_x_Header_Payment_rec.payment_number := NULL;
1835: END IF;
1836:
1837: IF p_x_Header_Payment_rec.header_id = FND_API.G_MISS_NUM THEN
1838: p_x_Header_Payment_rec.header_id := NULL;
1839: END IF;
1840:
1841: IF p_x_Header_Payment_rec.line_id = FND_API.G_MISS_NUM THEN
1837: IF p_x_Header_Payment_rec.header_id = FND_API.G_MISS_NUM THEN
1838: p_x_Header_Payment_rec.header_id := NULL;
1839: END IF;
1840:
1841: IF p_x_Header_Payment_rec.line_id = FND_API.G_MISS_NUM THEN
1842: p_x_Header_Payment_rec.line_id := NULL;
1843: END IF;
1844:
1845: IF p_x_Header_Payment_rec.payment_amount = FND_API.G_MISS_NUM THEN
1841: IF p_x_Header_Payment_rec.line_id = FND_API.G_MISS_NUM THEN
1842: p_x_Header_Payment_rec.line_id := NULL;
1843: END IF;
1844:
1845: IF p_x_Header_Payment_rec.payment_amount = FND_API.G_MISS_NUM THEN
1846: p_x_Header_Payment_rec.payment_amount := NULL;
1847: END IF;
1848:
1849: IF p_x_Header_Payment_rec.payment_collection_event = FND_API.G_MISS_CHAR THEN
1845: IF p_x_Header_Payment_rec.payment_amount = FND_API.G_MISS_NUM THEN
1846: p_x_Header_Payment_rec.payment_amount := NULL;
1847: END IF;
1848:
1849: IF p_x_Header_Payment_rec.payment_collection_event = FND_API.G_MISS_CHAR THEN
1850: p_x_Header_Payment_rec.payment_collection_event := NULL;
1851: END IF;
1852:
1853: IF p_x_Header_Payment_rec.defer_payment_processing_flag = FND_API.G_MISS_CHAR THEN
1849: IF p_x_Header_Payment_rec.payment_collection_event = FND_API.G_MISS_CHAR THEN
1850: p_x_Header_Payment_rec.payment_collection_event := NULL;
1851: END IF;
1852:
1853: IF p_x_Header_Payment_rec.defer_payment_processing_flag = FND_API.G_MISS_CHAR THEN
1854: p_x_Header_Payment_rec.defer_payment_processing_flag := NULL;
1855: END IF;
1856:
1857: IF p_x_Header_Payment_rec.payment_trx_id = FND_API.G_MISS_NUM THEN
1853: IF p_x_Header_Payment_rec.defer_payment_processing_flag = FND_API.G_MISS_CHAR THEN
1854: p_x_Header_Payment_rec.defer_payment_processing_flag := NULL;
1855: END IF;
1856:
1857: IF p_x_Header_Payment_rec.payment_trx_id = FND_API.G_MISS_NUM THEN
1858: p_x_Header_Payment_rec.payment_trx_id := NULL;
1859: END IF;
1860:
1861: IF p_x_Header_Payment_rec.payment_type_code = FND_API.G_MISS_CHAR THEN
1857: IF p_x_Header_Payment_rec.payment_trx_id = FND_API.G_MISS_NUM THEN
1858: p_x_Header_Payment_rec.payment_trx_id := NULL;
1859: END IF;
1860:
1861: IF p_x_Header_Payment_rec.payment_type_code = FND_API.G_MISS_CHAR THEN
1862: p_x_Header_Payment_rec.payment_type_code := NULL;
1863: END IF;
1864:
1865: IF p_x_Header_Payment_rec.payment_set_id = FND_API.G_MISS_NUM THEN
1861: IF p_x_Header_Payment_rec.payment_type_code = FND_API.G_MISS_CHAR THEN
1862: p_x_Header_Payment_rec.payment_type_code := NULL;
1863: END IF;
1864:
1865: IF p_x_Header_Payment_rec.payment_set_id = FND_API.G_MISS_NUM THEN
1866: p_x_Header_Payment_rec.payment_set_id := NULL;
1867: END IF;
1868:
1869: IF p_x_Header_Payment_rec.prepaid_amount = FND_API.G_MISS_NUM THEN
1865: IF p_x_Header_Payment_rec.payment_set_id = FND_API.G_MISS_NUM THEN
1866: p_x_Header_Payment_rec.payment_set_id := NULL;
1867: END IF;
1868:
1869: IF p_x_Header_Payment_rec.prepaid_amount = FND_API.G_MISS_NUM THEN
1870: p_x_Header_Payment_rec.prepaid_amount := NULL;
1871: END IF;
1872:
1873: IF p_x_Header_Payment_rec.program_application_id = FND_API.G_MISS_NUM THEN
1869: IF p_x_Header_Payment_rec.prepaid_amount = FND_API.G_MISS_NUM THEN
1870: p_x_Header_Payment_rec.prepaid_amount := NULL;
1871: END IF;
1872:
1873: IF p_x_Header_Payment_rec.program_application_id = FND_API.G_MISS_NUM THEN
1874: p_x_Header_Payment_rec.program_application_id := NULL;
1875: END IF;
1876:
1877: IF p_x_Header_Payment_rec.program_id = FND_API.G_MISS_NUM THEN
1873: IF p_x_Header_Payment_rec.program_application_id = FND_API.G_MISS_NUM THEN
1874: p_x_Header_Payment_rec.program_application_id := NULL;
1875: END IF;
1876:
1877: IF p_x_Header_Payment_rec.program_id = FND_API.G_MISS_NUM THEN
1878: p_x_Header_Payment_rec.program_id := NULL;
1879: END IF;
1880:
1881: IF p_x_Header_Payment_rec.program_update_date = FND_API.G_MISS_DATE THEN
1877: IF p_x_Header_Payment_rec.program_id = FND_API.G_MISS_NUM THEN
1878: p_x_Header_Payment_rec.program_id := NULL;
1879: END IF;
1880:
1881: IF p_x_Header_Payment_rec.program_update_date = FND_API.G_MISS_DATE THEN
1882: p_x_Header_Payment_rec.program_update_date := NULL;
1883: END IF;
1884:
1885: IF p_x_Header_Payment_rec.receipt_method_id = FND_API.G_MISS_NUM THEN
1881: IF p_x_Header_Payment_rec.program_update_date = FND_API.G_MISS_DATE THEN
1882: p_x_Header_Payment_rec.program_update_date := NULL;
1883: END IF;
1884:
1885: IF p_x_Header_Payment_rec.receipt_method_id = FND_API.G_MISS_NUM THEN
1886: p_x_Header_Payment_rec.receipt_method_id := NULL;
1887: END IF;
1888:
1889: IF p_x_Header_Payment_rec.request_id = FND_API.G_MISS_NUM THEN
1885: IF p_x_Header_Payment_rec.receipt_method_id = FND_API.G_MISS_NUM THEN
1886: p_x_Header_Payment_rec.receipt_method_id := NULL;
1887: END IF;
1888:
1889: IF p_x_Header_Payment_rec.request_id = FND_API.G_MISS_NUM THEN
1890: p_x_Header_Payment_rec.request_id := NULL;
1891: END IF;
1892:
1893: IF p_x_Header_Payment_rec.tangible_id = FND_API.G_MISS_CHAR THEN
1889: IF p_x_Header_Payment_rec.request_id = FND_API.G_MISS_NUM THEN
1890: p_x_Header_Payment_rec.request_id := NULL;
1891: END IF;
1892:
1893: IF p_x_Header_Payment_rec.tangible_id = FND_API.G_MISS_CHAR THEN
1894: p_x_Header_Payment_rec.tangible_id := NULL;
1895: END IF;
1896:
1897: -- R12 CC Encryption
1894: p_x_Header_Payment_rec.tangible_id := NULL;
1895: END IF;
1896:
1897: -- R12 CC Encryption
1898: IF p_x_Header_Payment_rec.trxn_extension_id = FND_API.G_MISS_NUM THEN
1899: p_x_Header_Payment_rec.trxn_extension_id := NULL;
1900: END IF;
1901:
1902: IF p_x_Header_Payment_rec.instrument_security_code = FND_API.G_MISS_CHAR THEN
1898: IF p_x_Header_Payment_rec.trxn_extension_id = FND_API.G_MISS_NUM THEN
1899: p_x_Header_Payment_rec.trxn_extension_id := NULL;
1900: END IF;
1901:
1902: IF p_x_Header_Payment_rec.instrument_security_code = FND_API.G_MISS_CHAR THEN
1903: p_x_Header_Payment_rec.instrument_security_code := NULL;
1904: END IF;
1905: -- R12 CC Encryption
1906:
1946: x_return_status => l_return_status);*/
1947: IF l_debug_level > 0 THEN
1948: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_HEADER_Payment_UTIL.UPDATE_ROW IS: ' || L_RETURN_STATUS ) ;
1949: END IF;
1950: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1951: IF l_debug_level > 0 THEN
1952: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
1953: END IF;
1954: IF l_debug_level > 0 THEN
1953: END IF;
1954: IF l_debug_level > 0 THEN
1955: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.UPDATE_ROW' , 1 ) ;
1956: END IF;
1957: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1958: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1959: IF l_debug_level > 0 THEN
1960: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_Payment_UTIL.UPDATE_ROW' ) ;
1961: END IF;
1954: IF l_debug_level > 0 THEN
1955: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.UPDATE_ROW' , 1 ) ;
1956: END IF;
1957: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1958: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1959: IF l_debug_level > 0 THEN
1960: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_Payment_UTIL.UPDATE_ROW' ) ;
1961: END IF;
1962: IF l_debug_level > 0 THEN
1961: END IF;
1962: IF l_debug_level > 0 THEN
1963: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.UPDATE_ROW' , 1 ) ;
1964: END IF;
1965: RAISE FND_API.G_EXC_ERROR;
1966: END IF;
1967: END IF; /*code_release_level*/
1968: -- notification framework end
1969:
2035: , 'Update_Row'
2036: );
2037: END IF;
2038:
2039: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2040:
2041: END Update_Row;
2042:
2043: -- Procedure Insert_Row
2178: IF l_debug_level > 0 THEN
2179: oe_debug_pub.add( 'RETURNED INDEX IS: ' || L_INDEX , 1 ) ;
2180: END IF;
2181:
2182: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2183: IF l_debug_level > 0 THEN
2184: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
2185: END IF;
2186: IF l_debug_level > 0 THEN
2185: END IF;
2186: IF l_debug_level > 0 THEN
2187: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.INSERT_ROW' , 1 ) ;
2188: END IF;
2189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2190: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2191: IF l_debug_level > 0 THEN
2192: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_Payment_UTIL.INSERT_ROW' ) ;
2193: END IF;
2186: IF l_debug_level > 0 THEN
2187: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.INSERT_ROW' , 1 ) ;
2188: END IF;
2189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2190: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2191: IF l_debug_level > 0 THEN
2192: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_Payment_UTIL.INSERT_ROW' ) ;
2193: END IF;
2194: IF l_debug_level > 0 THEN
2193: END IF;
2194: IF l_debug_level > 0 THEN
2195: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.INSERT_ROW' , 1 ) ;
2196: END IF;
2197: RAISE FND_API.G_EXC_ERROR;
2198: END IF;
2199: END IF; /*code_release_level*/
2200: -- notification framework end
2201:
2214: , 'Insert_Row'
2215: );
2216: END IF;
2217:
2218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2219:
2220: END Insert_Row;
2221:
2222: -- Procedure Delete_Row
2222: -- Procedure Delete_Row
2223:
2224: PROCEDURE Delete_Row
2225: ( p_payment_number IN NUMBER :=
2226: FND_API.G_MISS_NUM
2227: , p_header_id IN NUMBER :=
2228: FND_API.G_MISS_NUM
2229: )
2230: IS
2224: PROCEDURE Delete_Row
2225: ( p_payment_number IN NUMBER :=
2226: FND_API.G_MISS_NUM
2227: , p_header_id IN NUMBER :=
2228: FND_API.G_MISS_NUM
2229: )
2230: IS
2231: l_return_status VARCHAR2(30);
2232: l_msg_count number := 0;
2254: IF l_debug_level > 0 THEN
2255: oe_debug_pub.add( 'ENTERING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;
2256: END IF;
2257:
2258: IF p_header_id <> FND_API.G_MISS_NUM AND
2259: nvl(p_payment_number, FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM
2260: THEN
2261:
2262: FOR l_pmt IN payment LOOP
2255: oe_debug_pub.add( 'ENTERING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;
2256: END IF;
2257:
2258: IF p_header_id <> FND_API.G_MISS_NUM AND
2259: nvl(p_payment_number, FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM
2260: THEN
2261:
2262: FOR l_pmt IN payment LOOP
2263:
2280:
2281: IF l_debug_level > 0 THEN
2282: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_HEADER_Payment_UTIL.DELETE_ROW IS: ' || L_RETURN_STATUS ) ;
2283: END IF;
2284: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2285: IF l_debug_level > 0 THEN
2286: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
2287: END IF;
2288: IF l_debug_level > 0 THEN
2287: END IF;
2288: IF l_debug_level > 0 THEN
2289: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;
2290: END IF;
2291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2292: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2293: IF l_debug_level > 0 THEN
2294: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_Payment_UTIL.DELETE_ROW' ) ;
2295: END IF;
2288: IF l_debug_level > 0 THEN
2289: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;
2290: END IF;
2291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2292: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2293: IF l_debug_level > 0 THEN
2294: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_Payment_UTIL.DELETE_ROW' ) ;
2295: END IF;
2296: IF l_debug_level > 0 THEN
2295: END IF;
2296: IF l_debug_level > 0 THEN
2297: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;
2298: END IF;
2299: RAISE FND_API.G_EXC_ERROR;
2300: END IF;
2301: END IF; /*code_release_level*/
2302: -- notification framework end
2303: --R12 CC Encryption
2325: x_return_status =>l_return_status,
2326: x_msg_count => l_msg_count,
2327: x_msg_data => l_msg_data);
2328:
2329: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2330: IF l_debug_level > 0 THEN
2331: oe_debug_pub.add( 'Delete Payment at Header - UNEXPECTED ERROR' ) ;
2332: oe_debug_pub.add('Error message'||sqlerrm);
2333: oe_debug_pub.add('Msg data'||l_msg_data);
2334: END IF;
2335: IF l_debug_level > 0 THEN
2336: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;
2337: END IF;
2338: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2339: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2340: IF l_debug_level > 0 THEN
2341: oe_debug_pub.add( 'Delete Payment at Header - OE_HEADER_Payment_UTIL.DELETE_ROW' ) ;
2342: oe_debug_pub.add('Error message'||sqlerrm);
2335: IF l_debug_level > 0 THEN
2336: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;
2337: END IF;
2338: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2339: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2340: IF l_debug_level > 0 THEN
2341: oe_debug_pub.add( 'Delete Payment at Header - OE_HEADER_Payment_UTIL.DELETE_ROW' ) ;
2342: oe_debug_pub.add('Error message'||sqlerrm);
2343: oe_debug_pub.add('Msg data'||l_msg_data);
2344: END IF;
2345: IF l_debug_level > 0 THEN
2346: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;
2347: END IF;
2348: RAISE FND_API.G_EXC_ERROR;
2349: END IF;
2350: END IF;
2351: --R12 CC Encryption
2352: END LOOP;
2381: , p_msg_data => l_msg_data
2382: , p_return_status => l_return_status
2383: );
2384:
2385: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2386: RAISE FND_API.G_EXC_ERROR;
2387: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2388: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2389: END IF;
2382: , p_return_status => l_return_status
2383: );
2384:
2385: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2386: RAISE FND_API.G_EXC_ERROR;
2387: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2388: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2389: END IF;
2390:
2383: );
2384:
2385: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2386: RAISE FND_API.G_EXC_ERROR;
2387: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2388: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2389: END IF;
2390:
2391: -- release any authorization related holds.
2384:
2385: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2386: RAISE FND_API.G_EXC_ERROR;
2387: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2388: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2389: END IF;
2390:
2391: -- release any authorization related holds.
2392: OE_Verify_Payment_PUB.Release_Verify_Hold
2395: , p_msg_count => l_msg_count
2396: , p_msg_data => l_msg_data
2397: , p_return_status => l_return_status
2398: );
2399: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2400: RAISE FND_API.G_EXC_ERROR;
2401: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2402: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2403: END IF;
2396: , p_msg_data => l_msg_data
2397: , p_return_status => l_return_status
2398: );
2399: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2400: RAISE FND_API.G_EXC_ERROR;
2401: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2402: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2403: END IF;
2404:
2397: , p_return_status => l_return_status
2398: );
2399: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2400: RAISE FND_API.G_EXC_ERROR;
2401: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2402: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2403: END IF;
2404:
2405:
2398: );
2399: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2400: RAISE FND_API.G_EXC_ERROR;
2401: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2402: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2403: END IF;
2404:
2405:
2406: ELSIF p_header_id <> FND_API.G_MISS_NUM AND
2402: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2403: END IF;
2404:
2405:
2406: ELSIF p_header_id <> FND_API.G_MISS_NUM AND
2407: p_payment_number <> FND_API.G_MISS_NUM THEN
2408: --added notification framework
2409: --check code release level first. Notification framework is at Pack H level
2410: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
2403: END IF;
2404:
2405:
2406: ELSIF p_header_id <> FND_API.G_MISS_NUM AND
2407: p_payment_number <> FND_API.G_MISS_NUM THEN
2408: --added notification framework
2409: --check code release level first. Notification framework is at Pack H level
2410: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
2411: /* Set the operation on the record so that globals are updated as well */
2426: , x_msg_count => l_msg_count
2427: , x_msg_data => l_msg_data
2428: , x_return_status => l_return_status
2429: );
2430: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2431: RAISE FND_API.G_EXC_ERROR;
2432: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2433: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2434: END IF;
2427: , x_msg_data => l_msg_data
2428: , x_return_status => l_return_status
2429: );
2430: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2431: RAISE FND_API.G_EXC_ERROR;
2432: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2433: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2434: END IF;
2435: --ER#7479609 end
2428: , x_return_status => l_return_status
2429: );
2430: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2431: RAISE FND_API.G_EXC_ERROR;
2432: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2433: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2434: END IF;
2435: --ER#7479609 end
2436:
2429: );
2430: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2431: RAISE FND_API.G_EXC_ERROR;
2432: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2433: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2434: END IF;
2435: --ER#7479609 end
2436:
2437:
2438: IF l_debug_level > 0 THEN
2439: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_HEADER_Payment_UTIL.DELETE_ROW IS: ' || L_RETURN_STATUS ) ;
2440: END IF;
2441:
2442: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2443: IF l_debug_level > 0 THEN
2444: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
2445: END IF;
2446: IF l_debug_level > 0 THEN
2445: END IF;
2446: IF l_debug_level > 0 THEN
2447: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;
2448: END IF;
2449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2450: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2451: IF l_debug_level > 0 THEN
2452: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_Payment_UTIL.DELETE_ROW' ) ;
2453: END IF;
2446: IF l_debug_level > 0 THEN
2447: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;
2448: END IF;
2449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2450: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2451: IF l_debug_level > 0 THEN
2452: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_HEADER_Payment_UTIL.DELETE_ROW' ) ;
2453: END IF;
2454: IF l_debug_level > 0 THEN
2453: END IF;
2454: IF l_debug_level > 0 THEN
2455: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;
2456: END IF;
2457: RAISE FND_API.G_EXC_ERROR;
2458: END IF;
2459: END IF; /*code_release_level*/
2460: -- notification framework end
2461:
2500: x_msg_count => l_msg_count,
2501: x_msg_data => l_msg_data);
2502:
2503:
2504: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2505: IF l_debug_level > 0 THEN
2506: oe_debug_pub.add( '2:Delete Payment at Header - UNEXPECTED ERROR' ) ;
2507: END IF;
2508: IF l_debug_level > 0 THEN
2507: END IF;
2508: IF l_debug_level > 0 THEN
2509: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;
2510: END IF;
2511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2512: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2513: IF l_debug_level > 0 THEN
2514: oe_debug_pub.add( '2:Delete Payment at Header - OE_HEADER_Payment_UTIL.DELETE_ROW' ) ;
2515: END IF;
2508: IF l_debug_level > 0 THEN
2509: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;
2510: END IF;
2511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2512: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2513: IF l_debug_level > 0 THEN
2514: oe_debug_pub.add( '2:Delete Payment at Header - OE_HEADER_Payment_UTIL.DELETE_ROW' ) ;
2515: END IF;
2516: IF l_debug_level > 0 THEN
2515: END IF;
2516: IF l_debug_level > 0 THEN
2517: oe_debug_pub.add( 'EXITING OE_HEADER_Payment_UTIL.DELETE_ROW' , 1 ) ;
2518: END IF;
2519: RAISE FND_API.G_EXC_ERROR;
2520: END IF;
2521: END IF;
2522: --R12 CC Encryption
2523: DELETE FROM OE_PAYMENTS
2548: , p_msg_count => l_msg_count
2549: , p_msg_data => l_msg_data
2550: , p_return_status => l_return_status
2551: );
2552: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2553: RAISE FND_API.G_EXC_ERROR;
2554: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2555: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2556: END IF;
2549: , p_msg_data => l_msg_data
2550: , p_return_status => l_return_status
2551: );
2552: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2553: RAISE FND_API.G_EXC_ERROR;
2554: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2555: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2556: END IF;
2557:
2550: , p_return_status => l_return_status
2551: );
2552: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2553: RAISE FND_API.G_EXC_ERROR;
2554: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2555: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2556: END IF;
2557:
2558: ELSE
2551: );
2552: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2553: RAISE FND_API.G_EXC_ERROR;
2554: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2555: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2556: END IF;
2557:
2558: ELSE
2559: -- the payment being deleted is a prepayment.
2580: , p_msg_data => l_msg_data
2581: , p_return_status => l_return_status
2582: );
2583:
2584: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2585: RAISE FND_API.G_EXC_ERROR;
2586: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2587: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2588: END IF;
2581: , p_return_status => l_return_status
2582: );
2583:
2584: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2585: RAISE FND_API.G_EXC_ERROR;
2586: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2587: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2588: END IF;
2589: END IF;
2582: );
2583:
2584: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2585: RAISE FND_API.G_EXC_ERROR;
2586: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2587: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2588: END IF;
2589: END IF;
2590:
2583:
2584: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2585: RAISE FND_API.G_EXC_ERROR;
2586: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2587: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2588: END IF;
2589: END IF;
2590:
2591: END IF;
2605: , 'Delete_Row'
2606: );
2607: END IF;
2608:
2609: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2610:
2611: END Delete_Row;
2612:
2613: -- Procedure Query_Row
2772:
2773: IF
2774: (p_payment_number IS NOT NULL
2775: AND
2776: p_payment_number <> FND_API.G_MISS_NUM)
2777: AND
2778: (p_header_id IS NOT NULL
2779: AND
2780: p_header_id <> FND_API.G_MISS_NUM)
2776: p_payment_number <> FND_API.G_MISS_NUM)
2777: AND
2778: (p_header_id IS NOT NULL
2779: AND
2780: p_header_id <> FND_API.G_MISS_NUM)
2781: AND
2782: (x_Header_Payment_tbl.COUNT = 0)
2783: THEN
2784: RAISE NO_DATA_FOUND;
2786:
2787:
2788: EXCEPTION
2789:
2790: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2791:
2792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2793:
2794: WHEN OTHERS THEN
2788: EXCEPTION
2789:
2790: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2791:
2792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2793:
2794: WHEN OTHERS THEN
2795:
2796: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2800: , 'Query_Row'
2801: );
2802: END IF;
2803:
2804: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2805:
2806: END Query_Row;
2807:
2808:
2812: --
2813:
2814: Procedure Query_Rows
2815: ( p_payment_number IN NUMBER :=
2816: FND_API.G_MISS_NUM
2817: , p_header_id IN NUMBER :=
2818: FND_API.G_MISS_NUM
2819: , x_header_Payment_tbl IN OUT NOCOPY OE_Order_PUB.Header_Payment_Tbl_Type
2820: )
2814: Procedure Query_Rows
2815: ( p_payment_number IN NUMBER :=
2816: FND_API.G_MISS_NUM
2817: , p_header_id IN NUMBER :=
2818: FND_API.G_MISS_NUM
2819: , x_header_Payment_tbl IN OUT NOCOPY OE_Order_PUB.Header_Payment_Tbl_Type
2820: )
2821: IS
2822: l_Header_Payment_rec OE_Order_PUB.Header_Payment_Rec_Type;
2976:
2977:
2978: EXCEPTION
2979:
2980: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2981:
2982: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2983:
2984: WHEN OTHERS THEN
2978: EXCEPTION
2979:
2980: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2981:
2982: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2983:
2984: WHEN OTHERS THEN
2985:
2986: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2990: , 'Query_Rows'
2991: );
2992: END IF;
2993:
2994: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2995:
2996: END Query_Rows;
2997:
2998: -- Procedure lock_Row
3022:
3023: l_lock_control := NULL;
3024:
3025: -- Retrieve the primary key.
3026: IF p_payment_number <> FND_API.G_MISS_NUM AND
3027: p_header_id <> FND_API.G_MISS_NUM THEN
3028: l_payment_number := p_payment_number;
3029: l_header_id := p_header_id;
3030: ELSE
3023: l_lock_control := NULL;
3024:
3025: -- Retrieve the primary key.
3026: IF p_payment_number <> FND_API.G_MISS_NUM AND
3027: p_header_id <> FND_API.G_MISS_NUM THEN
3028: l_payment_number := p_payment_number;
3029: l_header_id := p_header_id;
3030: ELSE
3031: l_payment_number := p_x_header_Payment_rec.payment_number;
3053:
3054: -- If lock_control is null / missing, then return the locked record.
3055:
3056: IF l_lock_control is null OR
3057: l_lock_control <> FND_API.G_MISS_NUM THEN
3058:
3059: -- Set return status
3060: x_return_status := FND_API.G_RET_STS_SUCCESS;
3061: p_x_header_Payment_rec.return_status := FND_API.G_RET_STS_SUCCESS;
3056: IF l_lock_control is null OR
3057: l_lock_control <> FND_API.G_MISS_NUM THEN
3058:
3059: -- Set return status
3060: x_return_status := FND_API.G_RET_STS_SUCCESS;
3061: p_x_header_Payment_rec.return_status := FND_API.G_RET_STS_SUCCESS;
3062:
3063: RETURN;
3064:
3057: l_lock_control <> FND_API.G_MISS_NUM THEN
3058:
3059: -- Set return status
3060: x_return_status := FND_API.G_RET_STS_SUCCESS;
3061: p_x_header_Payment_rec.return_status := FND_API.G_RET_STS_SUCCESS;
3062:
3063: RETURN;
3064:
3065: END IF;
3076: p_x_Header_Payment_rec := l_Header_Payment_rec;
3077:
3078: -- Set return status
3079:
3080: x_return_status := FND_API.G_RET_STS_SUCCESS;
3081: p_x_Header_Payment_rec.return_status := FND_API.G_RET_STS_SUCCESS;
3082:
3083: ELSE
3084:
3077:
3078: -- Set return status
3079:
3080: x_return_status := FND_API.G_RET_STS_SUCCESS;
3081: p_x_Header_Payment_rec.return_status := FND_API.G_RET_STS_SUCCESS;
3082:
3083: ELSE
3084:
3085: -- Row has changed by another user.
3083: ELSE
3084:
3085: -- Row has changed by another user.
3086:
3087: x_return_status := FND_API.G_RET_STS_ERROR;
3088: p_x_Header_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
3089:
3090: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3091: THEN
3084:
3085: -- Row has changed by another user.
3086:
3087: x_return_status := FND_API.G_RET_STS_ERROR;
3088: p_x_Header_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
3089:
3090: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3091: THEN
3092:
3103: EXCEPTION
3104:
3105: WHEN NO_DATA_FOUND THEN
3106:
3107: x_return_status := FND_API.G_RET_STS_ERROR;
3108: p_x_Header_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
3109:
3110: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3111: THEN
3104:
3105: WHEN NO_DATA_FOUND THEN
3106:
3107: x_return_status := FND_API.G_RET_STS_ERROR;
3108: p_x_Header_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
3109:
3110: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3111: THEN
3112:
3115:
3116: END IF;
3117: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
3118:
3119: x_return_status := FND_API.G_RET_STS_ERROR;
3120: p_x_Header_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
3121:
3122: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3123: THEN
3116: END IF;
3117: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
3118:
3119: x_return_status := FND_API.G_RET_STS_ERROR;
3120: p_x_Header_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
3121:
3122: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3123: THEN
3124:
3127:
3128: END IF;
3129: WHEN OTHERS THEN
3130:
3131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3132: p_x_Header_Payment_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3133:
3134: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3135: THEN
3128: END IF;
3129: WHEN OTHERS THEN
3130:
3131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3132: p_x_Header_Payment_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3133:
3134: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3135: THEN
3136: oe_msg_pub.Add_Exc_Msg
3142: END Lock_Row;
3143:
3144: PROCEDURE Lock_Rows
3145: ( p_payment_number IN NUMBER :=
3146: FND_API.G_MISS_NUM
3147: , p_header_id IN NUMBER :=
3148: FND_API.G_MISS_NUM
3149: , x_header_Payment_tbl OUT NOCOPY OE_Order_PUB.header_Payment_Tbl_Type
3150: , x_return_status OUT NOCOPY VARCHAR2
3144: PROCEDURE Lock_Rows
3145: ( p_payment_number IN NUMBER :=
3146: FND_API.G_MISS_NUM
3147: , p_header_id IN NUMBER :=
3148: FND_API.G_MISS_NUM
3149: , x_header_Payment_tbl OUT NOCOPY OE_Order_PUB.header_Payment_Tbl_Type
3150: , x_return_status OUT NOCOPY VARCHAR2
3151: )
3152: IS
3167: oe_debug_pub.add( 'ENTERING OE_HEADER_PaymentS_UTIL.LOCK_ROWS' , 1 ) ;
3168: END IF;
3169: /*
3170: IF (p_payment_number IS NOT NULL AND
3171: p_payment_number <> FND_API.G_MISS_NUM) AND
3172: (p_header_id IS NOT NULL AND
3173: p_header_id <> FND_API.G_MISS_NUM)
3174: THEN
3175: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3169: /*
3170: IF (p_payment_number IS NOT NULL AND
3171: p_payment_number <> FND_API.G_MISS_NUM) AND
3172: (p_header_id IS NOT NULL AND
3173: p_header_id <> FND_API.G_MISS_NUM)
3174: THEN
3175: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3176: THEN
3177: OE_MSG_PUB.Add_Exc_Msg
3180: , 'Keys are mutually exclusive: payment_number = '||
3181: p_payment_number || ', header_id = '|| p_header_id );
3182: END IF;
3183:
3184: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3185:
3186: END IF;
3187: */
3188: IF p_payment_number <> FND_API.G_MISS_NUM AND
3184: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3185:
3186: END IF;
3187: */
3188: IF p_payment_number <> FND_API.G_MISS_NUM AND
3189: p_header_id <> FND_API.G_MISS_NUM THEN
3190:
3191: SELECT payment_number
3192: INTO l_payment_number
3185:
3186: END IF;
3187: */
3188: IF p_payment_number <> FND_API.G_MISS_NUM AND
3189: p_header_id <> FND_API.G_MISS_NUM THEN
3190:
3191: SELECT payment_number
3192: INTO l_payment_number
3193: FROM OE_PAYMENTS
3199: ELSE
3200:
3201: BEGIN
3202:
3203: IF p_header_id <> FND_API.G_MISS_NUM THEN
3204:
3205: SAVEPOINT LOCK_ROWS;
3206: OPEN lock_hdr_Payments(p_header_id);
3207:
3234: ,p_header_id => p_header_id
3235: ,x_header_Payment_tbl => x_header_Payment_tbl
3236: );
3237:
3238: x_return_status := FND_API.G_RET_STS_SUCCESS;
3239:
3240: IF l_debug_level > 0 THEN
3241: oe_debug_pub.add( 'EXITING OE_HEADER_PaymentS_UTIL.LOCK_ROWS' , 1 ) ;
3242: END IF;
3243:
3244: EXCEPTION
3245: WHEN NO_DATA_FOUND THEN
3246:
3247: x_return_status := FND_API.G_RET_STS_ERROR;
3248:
3249: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3250: THEN
3251: fnd_message.set_name('ONT','OE_LOCK_ROW_DELETED');
3253: END IF;
3254:
3255: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
3256:
3257: x_return_status := FND_API.G_RET_STS_ERROR;
3258: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3259: THEN
3260: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
3261: OE_MSG_PUB.Add;
3262: END IF;
3263:
3264: WHEN OTHERS THEN
3265:
3266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3267:
3268: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3269: THEN
3270: OE_MSG_PUB.Add_Exc_Msg
3290: --
3291: BEGIN
3292:
3293: IF (p_Header_Payment_rec.payment_collection_event IS NULL OR
3294: p_Header_Payment_rec.payment_collection_event <> FND_API.G_MISS_CHAR) AND
3295: NOT OE_GLOBALS.Equal(p_Header_Payment_rec.payment_collection_event,
3296: p_old_Header_Payment_rec.payment_collection_event)
3297: THEN
3298: l_Header_Payment_val_rec.payment_collection_event_name := OE_Id_To_Value.payment_collection_event_name
3300: );
3301: END IF;
3302:
3303: IF (p_Header_Payment_rec.receipt_method_id IS NULL OR
3304: p_Header_Payment_rec.receipt_method_id <> FND_API.G_MISS_NUM) AND
3305: NOT OE_GLOBALS.Equal(p_Header_Payment_rec.receipt_method_id,
3306: p_old_Header_Payment_rec.receipt_method_id)
3307: THEN
3308: l_Header_Payment_val_rec.receipt_method := OE_Id_To_Value.Receipt_Method
3310: );
3311: END IF;
3312:
3313: IF (p_Header_Payment_rec.payment_type_code IS NULL OR
3314: p_Header_Payment_rec.payment_type_code <> FND_API.G_MISS_CHAR) AND
3315: NOT OE_GLOBALS.Equal(p_Header_Payment_rec.payment_type_code,
3316: p_old_Header_Payment_rec.payment_type_code)
3317: THEN
3318: l_Header_Payment_val_rec.payment_type := OE_Id_To_Value.payment_type
3338: BEGIN
3339:
3340: -- initialize return_status.
3341:
3342: p_x_Header_Payment_rec.return_status := FND_API.G_RET_STS_SUCCESS;
3343:
3344: -- initialize l_Header_Payment_rec.
3345:
3346:
3344: -- initialize l_Header_Payment_rec.
3345:
3346:
3347:
3348: IF p_Header_Payment_val_rec.payment_collection_event_name <> FND_API.G_MISS_CHAR
3349: THEN
3350:
3351: IF p_x_Header_Payment_rec.payment_collection_event <> FND_API.G_MISS_CHAR THEN
3352:
3347:
3348: IF p_Header_Payment_val_rec.payment_collection_event_name <> FND_API.G_MISS_CHAR
3349: THEN
3350:
3351: IF p_x_Header_Payment_rec.payment_collection_event <> FND_API.G_MISS_CHAR THEN
3352:
3353: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
3354: THEN
3355:
3364: p_x_Header_Payment_rec.payment_collection_event := OE_Value_To_Id.payment_collection_event_name
3365: ( p_payment_collection_event => p_Header_Payment_val_rec.payment_collection_event_name
3366: );
3367:
3368: IF p_x_Header_Payment_rec.payment_collection_event = FND_API.G_MISS_CHAR THEN
3369: p_x_Header_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
3370: END IF;
3371:
3372: END IF;
3365: ( p_payment_collection_event => p_Header_Payment_val_rec.payment_collection_event_name
3366: );
3367:
3368: IF p_x_Header_Payment_rec.payment_collection_event = FND_API.G_MISS_CHAR THEN
3369: p_x_Header_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
3370: END IF;
3371:
3372: END IF;
3373:
3372: END IF;
3373:
3374: END IF;
3375:
3376: IF p_Header_Payment_val_rec.payment_type <> FND_API.G_MISS_CHAR
3377: THEN
3378:
3379: IF p_x_Header_Payment_rec.payment_type_code <> FND_API.G_MISS_CHAR THEN
3380:
3375:
3376: IF p_Header_Payment_val_rec.payment_type <> FND_API.G_MISS_CHAR
3377: THEN
3378:
3379: IF p_x_Header_Payment_rec.payment_type_code <> FND_API.G_MISS_CHAR THEN
3380:
3381:
3382: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
3383: THEN
3393: p_x_Header_Payment_rec.payment_type_code := OE_Value_To_Id.payment_type
3394: ( p_payment_type => p_Header_Payment_val_rec.payment_type
3395: );
3396:
3397: IF p_x_Header_Payment_rec.payment_type_code = FND_API.G_MISS_CHAR THEN
3398: p_x_Header_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
3399: END IF;
3400:
3401: END IF;
3394: ( p_payment_type => p_Header_Payment_val_rec.payment_type
3395: );
3396:
3397: IF p_x_Header_Payment_rec.payment_type_code = FND_API.G_MISS_CHAR THEN
3398: p_x_Header_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
3399: END IF;
3400:
3401: END IF;
3402:
3402:
3403: END IF;
3404:
3405:
3406: IF p_Header_Payment_val_rec.receipt_method <> FND_API.G_MISS_CHAR
3407: THEN
3408:
3409: IF p_x_Header_Payment_rec.receipt_method_id <> FND_API.G_MISS_NUM THEN
3410:
3405:
3406: IF p_Header_Payment_val_rec.receipt_method <> FND_API.G_MISS_CHAR
3407: THEN
3408:
3409: IF p_x_Header_Payment_rec.receipt_method_id <> FND_API.G_MISS_NUM THEN
3410:
3411:
3412: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
3413: THEN
3423: p_x_Header_Payment_rec.receipt_method_id := OE_Value_To_Id.Receipt_Method
3424: ( p_receipt_method => p_Header_Payment_val_rec.receipt_method
3425: );
3426:
3427: IF p_x_Header_Payment_rec.receipt_method_id = FND_API.G_MISS_NUM THEN
3428: p_x_Header_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
3429: END IF;
3430:
3431: END IF;
3424: ( p_receipt_method => p_Header_Payment_val_rec.receipt_method
3425: );
3426:
3427: IF p_x_Header_Payment_rec.receipt_method_id = FND_API.G_MISS_NUM THEN
3428: p_x_Header_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
3429: END IF;
3430:
3431: END IF;
3432:
3516: oe_debug_pub.add('Old Approval Date'||p_old_header_Payment_rec.credit_card_approval_date);
3517: END IF;
3518:
3519: IF p_x_header_Payment_rec.trxn_extension_id IS NOT NULL AND
3520: p_x_header_Payment_rec.trxn_extension_id <> FND_API.G_MISS_NUM
3521: AND p_x_header_Payment_rec.operation = OE_GLOBALS.G_OPR_CREATE AND
3522: nvl(oe_order_cache.g_header_rec.source_document_type_id, -99) <> 2 -- not a copy order Verify
3523: THEN
3524: --R12 CC Encryption
3538: IF l_debug_level>0 THEN
3539: oe_debug_pub.add('New trxn extension id after calling Copy_Payment_TRXN:'||l_trxn_extension_id);
3540: END IF;
3541: EXCEPTION
3542: WHEN FND_API.G_EXC_ERROR THEN
3543: l_return_status := FND_API.G_RET_STS_ERROR;
3544: RAISE FND_API.G_EXC_ERROR;
3545: WHEN OTHERS THEN
3546: IF l_debug_level>0 THEN
3539: oe_debug_pub.add('New trxn extension id after calling Copy_Payment_TRXN:'||l_trxn_extension_id);
3540: END IF;
3541: EXCEPTION
3542: WHEN FND_API.G_EXC_ERROR THEN
3543: l_return_status := FND_API.G_RET_STS_ERROR;
3544: RAISE FND_API.G_EXC_ERROR;
3545: WHEN OTHERS THEN
3546: IF l_debug_level>0 THEN
3547: oe_debug_pub.add('After call to copy payment trxn - exception');
3540: END IF;
3541: EXCEPTION
3542: WHEN FND_API.G_EXC_ERROR THEN
3543: l_return_status := FND_API.G_RET_STS_ERROR;
3544: RAISE FND_API.G_EXC_ERROR;
3545: WHEN OTHERS THEN
3546: IF l_debug_level>0 THEN
3547: oe_debug_pub.add('After call to copy payment trxn - exception');
3548: END IF;
3545: WHEN OTHERS THEN
3546: IF l_debug_level>0 THEN
3547: oe_debug_pub.add('After call to copy payment trxn - exception');
3548: END IF;
3549: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3550: END;
3551:
3552: p_x_header_payment_rec.trxn_extension_id := l_trxn_extension_id;
3553:
3596: oe_debug_pub.add('Diff approval code');
3597: END IF;
3598: END IF;
3599: IF p_x_header_payment_rec.trxn_extension_id IS NOT NULL
3600: AND p_x_header_payment_rec.trxn_extension_id <> FND_API.G_MISS_NUM
3601: AND ((p_x_header_Payment_rec.payment_type_code = 'CREDIT_CARD'
3602: AND OE_GLOBALS.Is_Same_Credit_Card(p_old_Header_Payment_rec.credit_card_number,
3603: p_x_Header_Payment_rec.credit_card_number,
3604: p_old_Header_Payment_rec.cc_instrument_id,
3625: --While changing the payment type from cash, check etc to
3626: --credit card payment type, the operation would be update but the
3627: --transaction extension id would be null.
3628: ELSIF p_x_header_payment_rec.trxn_extension_id is null or
3629: p_x_header_payment_rec.trxn_extension_id =FND_API.G_MISS_NUM THEN
3630: IF l_debug_level > 0 THEN
3631: oe_debug_pub.add( 'getting payment_trx_id as cc details changed');
3632: oe_debug_pub.add('Operation is Update and trxn extension id is null');
3633: oe_debug_pub.add('Payment type has changed from check or cash to one which requires trxn extension id...');
3642: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use = 'REQUIRED' AND
3643: p_x_Header_Payment_rec.instrument_security_code IS NULL THEN
3644: FND_MESSAGE.SET_NAME('ONT','OE_CC_SECURITY_CODE_REQD');
3645: OE_Msg_Pub.Add;
3646: RAISE FND_API.G_EXC_ERROR;
3647: END IF;
3648: END IF;
3649:
3650: --R12 CC Encryption
3699: IF l_debug_level > 0 THEN
3700: oe_debug_pub.add('New trxn extension id after calling Create_Payment_TRXN:'||p_x_header_payment_rec.trxn_extension_id);
3701: END IF;
3702: Exception
3703: WHEN FND_API.G_EXC_ERROR THEN
3704: OE_MSG_PUB.Count_And_Get
3705: ( p_count => l_msg_count,
3706: p_data => l_msg_data
3707: );
3704: OE_MSG_PUB.Count_And_Get
3705: ( p_count => l_msg_count,
3706: p_data => l_msg_data
3707: );
3708: l_return_status := FND_API.G_RET_STS_ERROR;
3709: RAISE FND_API.G_EXC_ERROR;
3710:
3711: WHEN OTHERS THEN
3712: OE_MSG_PUB.Count_And_Get
3705: ( p_count => l_msg_count,
3706: p_data => l_msg_data
3707: );
3708: l_return_status := FND_API.G_RET_STS_ERROR;
3709: RAISE FND_API.G_EXC_ERROR;
3710:
3711: WHEN OTHERS THEN
3712: OE_MSG_PUB.Count_And_Get
3713: ( p_count => l_msg_count,
3718: IF l_debug_level > 0 THEN
3719: oe_debug_pub.add( 'OEXUHPMB: ERROR IN ARP_BANK_PKG.PROCESS_CUST_BANK_ACCOUNT'||l_msg_data ) ;
3720: oe_debug_pub.add('Error messsge ksurendr'||l_return_status);
3721: END IF;
3722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3723: end;
3724:
3725: IF l_debug_level > 0 THEN
3726: oe_debug_pub.add( 'Return status...'||l_return_status );
3739: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use = 'REQUIRED'
3740: AND p_x_Header_Payment_rec.instrument_security_code IS NULL THEN
3741: FND_MESSAGE.SET_NAME('ONT','OE_CC_SECURITY_CODE_REQD');
3742: OE_Msg_Pub.Add;
3743: RAISE FND_API.G_EXC_ERROR;
3744: END IF;
3745: END IF;*/
3746:
3747: --R12 CC Encryption
3798: IF l_debug_level > 0 THEN
3799: oe_debug_pub.add('trxn extension id after calling Update_Payment_TRXN:'||p_x_header_payment_rec.trxn_extension_id);
3800: END IF;
3801: EXCEPTION
3802: WHEN FND_API.G_EXC_ERROR THEN
3803:
3804: IF l_debug_level > 0 THEN
3805: oe_debug_pub.add('Update_Payment_TRXN error....exc');
3806: oe_debug_pub.add('After call to Update_Payment_TRXN'||l_return_status);
3805: oe_debug_pub.add('Update_Payment_TRXN error....exc');
3806: oe_debug_pub.add('After call to Update_Payment_TRXN'||l_return_status);
3807: oe_debug_pub.add('Error'||sqlerrm);
3808: END IF;
3809: l_return_status := FND_API.G_RET_STS_ERROR;
3810: OE_MSG_PUB.Count_And_Get
3811: ( p_count => l_msg_count,
3812: p_data => l_msg_data
3813: );
3810: OE_MSG_PUB.Count_And_Get
3811: ( p_count => l_msg_count,
3812: p_data => l_msg_data
3813: );
3814: RAISE FND_API.G_EXC_ERROR;
3815:
3816: WHEN OTHERS THEN
3817: OE_MSG_PUB.Count_And_Get
3818: ( p_count => l_msg_count,
3821: IF l_debug_level > 0 THEN
3822: oe_debug_pub.add('After call to Update_Payment_TRXN --> Unexpected error');
3823: oe_debug_pub.add('Error message '||sqlerrm);
3824: END IF;
3825: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3826: END;
3827:
3828: END IF;
3829:
3848: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use = 'REQUIRED' AND
3849: p_x_Header_Payment_rec.instrument_security_code IS NULL THEN
3850: FND_MESSAGE.SET_NAME('ONT','OE_CC_SECURITY_CODE_REQD');
3851: OE_Msg_Pub.Add;
3852: RAISE FND_API.G_EXC_ERROR;
3853: END IF;
3854: END IF;
3855:
3856: --R12 CC Encryption
3925:
3926: oe_debug_pub.add('New trxn extension id after calling Create_Payment_TRXN:'||p_x_header_payment_rec.trxn_extension_id);
3927:
3928: Exception
3929: WHEN FND_API.G_EXC_ERROR THEN
3930: OE_MSG_PUB.Count_And_Get
3931: ( p_count => l_msg_count,
3932: p_data => l_msg_data
3933: );
3930: OE_MSG_PUB.Count_And_Get
3931: ( p_count => l_msg_count,
3932: p_data => l_msg_data
3933: );
3934: l_return_status := FND_API.G_RET_STS_ERROR;
3935:
3936: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET');
3937: OE_MSG_PUB.ADD;
3938:
3935:
3936: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET');
3937: OE_MSG_PUB.ADD;
3938:
3939: RAISE FND_API.G_EXC_ERROR;
3940:
3941: WHEN OTHERS THEN
3942: OE_MSG_PUB.Count_And_Get
3943: ( p_count => l_msg_count,
3948: IF l_debug_level > 0 THEN
3949: oe_debug_pub.add( 'OEXUHPMB: ERROR IN ARP_BANK_PKG.PROCESS_CUST_BANK_ACCOUNT'||l_msg_data ) ;
3950: oe_debug_pub.add('Error messsge ksurendr'||l_return_status);
3951: END IF;
3952: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3953: end;
3954:
3955: IF l_debug_level > 0 THEN
3956: oe_debug_pub.add( 'after calling process_cust_bank_account. l_bank_acct_id:'||l_bank_acct_id);
3982: p_trxn_extension_id => p_old_header_Payment_rec.trxn_extension_id,
3983: P_site_use_id => null
3984: );
3985:
3986: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3987: RAISE FND_API.G_EXC_ERROR;
3988: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3989: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3990: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
3983: P_site_use_id => null
3984: );
3985:
3986: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3987: RAISE FND_API.G_EXC_ERROR;
3988: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3989: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3990: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
3991: IF l_debug_level > 0 THEN
3984: );
3985:
3986: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3987: RAISE FND_API.G_EXC_ERROR;
3988: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3989: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3990: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
3991: IF l_debug_level > 0 THEN
3992: oe_debug_pub.add('Before setting the trxn extension id to null...');
3985:
3986: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3987: RAISE FND_API.G_EXC_ERROR;
3988: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3989: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3990: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
3991: IF l_debug_level > 0 THEN
3992: oe_debug_pub.add('Before setting the trxn extension id to null...');
3993: oe_debug_pub.add('Id that was deleted from iby tables...'||p_old_header_Payment_rec.trxn_extension_id);
3986: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3987: RAISE FND_API.G_EXC_ERROR;
3988: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3989: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3990: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
3991: IF l_debug_level > 0 THEN
3992: oe_debug_pub.add('Before setting the trxn extension id to null...');
3993: oe_debug_pub.add('Id that was deleted from iby tables...'||p_old_header_Payment_rec.trxn_extension_id);
3994: END IF;
4021: oe_debug_pub.add('EXITING OE_HEADER_PAYMENT_UTIL.PRE_WRITE_PROCESS');
4022: END IF;
4023:
4024: EXCEPTION
4025: WHEN FND_API.G_EXC_ERROR THEN
4026: IF L_DEBUG_LEVEL > 0 THEN
4027: Oe_debug_pub.add('OEXUHPMB.pls - pre_write_process error ');
4028: END if;
4029: p_x_header_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
4025: WHEN FND_API.G_EXC_ERROR THEN
4026: IF L_DEBUG_LEVEL > 0 THEN
4027: Oe_debug_pub.add('OEXUHPMB.pls - pre_write_process error ');
4028: END if;
4029: p_x_header_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
4030: RAISE FND_API.G_EXC_ERROR;
4031: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4032: IF L_DEBUG_LEVEL > 0 THEN
4033: Oe_debug_pub.add('OEXUHPMB.pls - pre_write_process unexpected error ');
4026: IF L_DEBUG_LEVEL > 0 THEN
4027: Oe_debug_pub.add('OEXUHPMB.pls - pre_write_process error ');
4028: END if;
4029: p_x_header_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
4030: RAISE FND_API.G_EXC_ERROR;
4031: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4032: IF L_DEBUG_LEVEL > 0 THEN
4033: Oe_debug_pub.add('OEXUHPMB.pls - pre_write_process unexpected error ');
4034: END if;
4027: Oe_debug_pub.add('OEXUHPMB.pls - pre_write_process error ');
4028: END if;
4029: p_x_header_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
4030: RAISE FND_API.G_EXC_ERROR;
4031: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4032: IF L_DEBUG_LEVEL > 0 THEN
4033: Oe_debug_pub.add('OEXUHPMB.pls - pre_write_process unexpected error ');
4034: END if;
4035: p_x_header_payment_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4031: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4032: IF L_DEBUG_LEVEL > 0 THEN
4033: Oe_debug_pub.add('OEXUHPMB.pls - pre_write_process unexpected error ');
4034: END if;
4035: p_x_header_payment_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4036: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4037:
4038: WHEN OTHERS THEN
4039: IF L_DEBUG_LEVEL > 0 THEN
4032: IF L_DEBUG_LEVEL > 0 THEN
4033: Oe_debug_pub.add('OEXUHPMB.pls - pre_write_process unexpected error ');
4034: END if;
4035: p_x_header_payment_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4036: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4037:
4038: WHEN OTHERS THEN
4039: IF L_DEBUG_LEVEL > 0 THEN
4040: Oe_debug_pub.add('OEXUHPMB.pls - pre_write_process unexpected error ');
4038: WHEN OTHERS THEN
4039: IF L_DEBUG_LEVEL > 0 THEN
4040: Oe_debug_pub.add('OEXUHPMB.pls - pre_write_process unexpected error ');
4041: END if;
4042: raise fnD_API.G_EXC_UNEXPECTED_ERROR;
4043:
4044: END Pre_Write_Process;
4045:
4046: --3382262
4080: (p_header_id => p_header_id
4081: ,p_x_header_rec => l_old_header_rec
4082: ,x_return_status => l_return_status
4083: );
4084: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4085: RAISE FND_API.G_EXC_ERROR;
4086: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4087: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4088: END IF;
4081: ,p_x_header_rec => l_old_header_rec
4082: ,x_return_status => l_return_status
4083: );
4084: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4085: RAISE FND_API.G_EXC_ERROR;
4086: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4087: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4088: END IF;
4089:
4082: ,x_return_status => l_return_status
4083: );
4084: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4085: RAISE FND_API.G_EXC_ERROR;
4086: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4087: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4088: END IF;
4089:
4090: l_header_rec := l_old_header_rec;
4083: );
4084: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4085: RAISE FND_API.G_EXC_ERROR;
4086: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4087: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4088: END IF;
4089:
4090: l_header_rec := l_old_header_rec;
4091:
4104: end if;
4105:
4106: Exception
4107:
4108: WHEN FND_API.G_EXC_ERROR THEN
4109: x_return_status := FND_API.G_RET_STS_ERROR;
4110: OE_MSG_PUB.Count_And_Get
4111: ( p_count => x_msg_count,
4112: p_data => x_msg_data
4105:
4106: Exception
4107:
4108: WHEN FND_API.G_EXC_ERROR THEN
4109: x_return_status := FND_API.G_RET_STS_ERROR;
4110: OE_MSG_PUB.Count_And_Get
4111: ( p_count => x_msg_count,
4112: p_data => x_msg_data
4113: );
4111: ( p_count => x_msg_count,
4112: p_data => x_msg_data
4113: );
4114:
4115: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4116: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4117: OE_MSG_PUB.Count_And_Get
4118: ( p_count => x_msg_count,
4119: p_data => x_msg_data
4112: p_data => x_msg_data
4113: );
4114:
4115: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4116: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4117: OE_MSG_PUB.Count_And_Get
4118: ( p_count => x_msg_count,
4119: p_data => x_msg_data
4120: );
4119: p_data => x_msg_data
4120: );
4121:
4122: WHEN OTHERS THEN
4123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4124: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4125: THEN
4126: OE_MSG_PUB.Add_Exc_Msg
4127: ( G_PKG_NAME