eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.OE_LINE_PAYMENT_UTIL dependencies on FND_API

Line 28: l_rowtype_rec.ATTRIBUTE1 := FND_API.G_MISS_CHAR;

24: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
25: --
26: BEGIN
27:
28: l_rowtype_rec.ATTRIBUTE1 := FND_API.G_MISS_CHAR;
29: l_rowtype_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
30: l_rowtype_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
31: l_rowtype_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
32: l_rowtype_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;

Line 29: l_rowtype_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;

25: --
26: BEGIN
27:
28: l_rowtype_rec.ATTRIBUTE1 := FND_API.G_MISS_CHAR;
29: l_rowtype_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
30: l_rowtype_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
31: l_rowtype_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
32: l_rowtype_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
33: l_rowtype_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;

Line 30: l_rowtype_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;

26: BEGIN
27:
28: l_rowtype_rec.ATTRIBUTE1 := FND_API.G_MISS_CHAR;
29: l_rowtype_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
30: l_rowtype_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
31: l_rowtype_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
32: l_rowtype_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
33: l_rowtype_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
34: l_rowtype_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;

Line 31: l_rowtype_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;

27:
28: l_rowtype_rec.ATTRIBUTE1 := FND_API.G_MISS_CHAR;
29: l_rowtype_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
30: l_rowtype_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
31: l_rowtype_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
32: l_rowtype_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
33: l_rowtype_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
34: l_rowtype_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
35: l_rowtype_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;

Line 32: l_rowtype_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;

28: l_rowtype_rec.ATTRIBUTE1 := FND_API.G_MISS_CHAR;
29: l_rowtype_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
30: l_rowtype_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
31: l_rowtype_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
32: l_rowtype_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
33: l_rowtype_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
34: l_rowtype_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
35: l_rowtype_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
36: l_rowtype_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;

Line 33: l_rowtype_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;

29: l_rowtype_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
30: l_rowtype_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
31: l_rowtype_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
32: l_rowtype_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
33: l_rowtype_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
34: l_rowtype_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
35: l_rowtype_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
36: l_rowtype_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
37: l_rowtype_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;

Line 34: l_rowtype_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;

30: l_rowtype_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
31: l_rowtype_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
32: l_rowtype_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
33: l_rowtype_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
34: l_rowtype_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
35: l_rowtype_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
36: l_rowtype_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
37: l_rowtype_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
38: l_rowtype_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;

Line 35: l_rowtype_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;

31: l_rowtype_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
32: l_rowtype_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
33: l_rowtype_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
34: l_rowtype_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
35: l_rowtype_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
36: l_rowtype_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
37: l_rowtype_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
38: l_rowtype_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
39: l_rowtype_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;

Line 36: l_rowtype_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;

32: l_rowtype_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
33: l_rowtype_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
34: l_rowtype_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
35: l_rowtype_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
36: l_rowtype_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
37: l_rowtype_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
38: l_rowtype_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
39: l_rowtype_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
40: l_rowtype_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;

Line 37: l_rowtype_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;

33: l_rowtype_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
34: l_rowtype_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
35: l_rowtype_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
36: l_rowtype_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
37: l_rowtype_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
38: l_rowtype_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
39: l_rowtype_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
40: l_rowtype_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
41: l_rowtype_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;

Line 38: l_rowtype_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;

34: l_rowtype_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
35: l_rowtype_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
36: l_rowtype_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
37: l_rowtype_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
38: l_rowtype_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
39: l_rowtype_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
40: l_rowtype_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
41: l_rowtype_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
42: l_rowtype_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;

Line 39: l_rowtype_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;

35: l_rowtype_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
36: l_rowtype_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
37: l_rowtype_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
38: l_rowtype_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
39: l_rowtype_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
40: l_rowtype_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
41: l_rowtype_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
42: l_rowtype_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
43: l_rowtype_rec.CONTEXT := FND_API.G_MISS_CHAR;

Line 40: l_rowtype_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;

36: l_rowtype_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
37: l_rowtype_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
38: l_rowtype_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
39: l_rowtype_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
40: l_rowtype_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
41: l_rowtype_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
42: l_rowtype_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
43: l_rowtype_rec.CONTEXT := FND_API.G_MISS_CHAR;
44: l_rowtype_rec.CREATED_BY := FND_API.G_MISS_NUM;

Line 41: l_rowtype_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;

37: l_rowtype_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
38: l_rowtype_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
39: l_rowtype_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
40: l_rowtype_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
41: l_rowtype_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
42: l_rowtype_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
43: l_rowtype_rec.CONTEXT := FND_API.G_MISS_CHAR;
44: l_rowtype_rec.CREATED_BY := FND_API.G_MISS_NUM;
45: l_rowtype_rec.CREATION_DATE := FND_API.G_MISS_DATE;

Line 42: l_rowtype_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;

38: l_rowtype_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
39: l_rowtype_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
40: l_rowtype_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
41: l_rowtype_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
42: l_rowtype_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
43: l_rowtype_rec.CONTEXT := FND_API.G_MISS_CHAR;
44: l_rowtype_rec.CREATED_BY := FND_API.G_MISS_NUM;
45: l_rowtype_rec.CREATION_DATE := FND_API.G_MISS_DATE;
46: l_rowtype_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;

Line 43: l_rowtype_rec.CONTEXT := FND_API.G_MISS_CHAR;

39: l_rowtype_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
40: l_rowtype_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
41: l_rowtype_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
42: l_rowtype_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
43: l_rowtype_rec.CONTEXT := FND_API.G_MISS_CHAR;
44: l_rowtype_rec.CREATED_BY := FND_API.G_MISS_NUM;
45: l_rowtype_rec.CREATION_DATE := FND_API.G_MISS_DATE;
46: l_rowtype_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
47: l_rowtype_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;

Line 44: l_rowtype_rec.CREATED_BY := FND_API.G_MISS_NUM;

40: l_rowtype_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
41: l_rowtype_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
42: l_rowtype_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
43: l_rowtype_rec.CONTEXT := FND_API.G_MISS_CHAR;
44: l_rowtype_rec.CREATED_BY := FND_API.G_MISS_NUM;
45: l_rowtype_rec.CREATION_DATE := FND_API.G_MISS_DATE;
46: l_rowtype_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
47: l_rowtype_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
48: l_rowtype_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;

Line 45: l_rowtype_rec.CREATION_DATE := FND_API.G_MISS_DATE;

41: l_rowtype_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
42: l_rowtype_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
43: l_rowtype_rec.CONTEXT := FND_API.G_MISS_CHAR;
44: l_rowtype_rec.CREATED_BY := FND_API.G_MISS_NUM;
45: l_rowtype_rec.CREATION_DATE := FND_API.G_MISS_DATE;
46: l_rowtype_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
47: l_rowtype_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
48: l_rowtype_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
49: l_rowtype_rec.CHECK_NUMBER := FND_API.G_MISS_CHAR;

Line 46: l_rowtype_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;

42: l_rowtype_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
43: l_rowtype_rec.CONTEXT := FND_API.G_MISS_CHAR;
44: l_rowtype_rec.CREATED_BY := FND_API.G_MISS_NUM;
45: l_rowtype_rec.CREATION_DATE := FND_API.G_MISS_DATE;
46: l_rowtype_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
47: l_rowtype_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
48: l_rowtype_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
49: l_rowtype_rec.CHECK_NUMBER := FND_API.G_MISS_CHAR;
50: l_rowtype_rec.CREDIT_CARD_APPROVAL_CODE := FND_API.G_MISS_CHAR;

Line 47: l_rowtype_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;

43: l_rowtype_rec.CONTEXT := FND_API.G_MISS_CHAR;
44: l_rowtype_rec.CREATED_BY := FND_API.G_MISS_NUM;
45: l_rowtype_rec.CREATION_DATE := FND_API.G_MISS_DATE;
46: l_rowtype_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
47: l_rowtype_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
48: l_rowtype_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
49: l_rowtype_rec.CHECK_NUMBER := FND_API.G_MISS_CHAR;
50: l_rowtype_rec.CREDIT_CARD_APPROVAL_CODE := FND_API.G_MISS_CHAR;
51: l_rowtype_rec.CREDIT_CARD_APPROVAL_DATE := FND_API.G_MISS_DATE;

Line 48: l_rowtype_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;

44: l_rowtype_rec.CREATED_BY := FND_API.G_MISS_NUM;
45: l_rowtype_rec.CREATION_DATE := FND_API.G_MISS_DATE;
46: l_rowtype_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
47: l_rowtype_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
48: l_rowtype_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
49: l_rowtype_rec.CHECK_NUMBER := FND_API.G_MISS_CHAR;
50: l_rowtype_rec.CREDIT_CARD_APPROVAL_CODE := FND_API.G_MISS_CHAR;
51: l_rowtype_rec.CREDIT_CARD_APPROVAL_DATE := FND_API.G_MISS_DATE;
52: l_rowtype_rec.CREDIT_CARD_CODE := FND_API.G_MISS_CHAR;

Line 49: l_rowtype_rec.CHECK_NUMBER := FND_API.G_MISS_CHAR;

45: l_rowtype_rec.CREATION_DATE := FND_API.G_MISS_DATE;
46: l_rowtype_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
47: l_rowtype_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
48: l_rowtype_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
49: l_rowtype_rec.CHECK_NUMBER := FND_API.G_MISS_CHAR;
50: l_rowtype_rec.CREDIT_CARD_APPROVAL_CODE := FND_API.G_MISS_CHAR;
51: l_rowtype_rec.CREDIT_CARD_APPROVAL_DATE := FND_API.G_MISS_DATE;
52: l_rowtype_rec.CREDIT_CARD_CODE := FND_API.G_MISS_CHAR;
53: l_rowtype_rec.CREDIT_CARD_EXPIRATION_DATE := FND_API.G_MISS_DATE;

Line 50: l_rowtype_rec.CREDIT_CARD_APPROVAL_CODE := FND_API.G_MISS_CHAR;

46: l_rowtype_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
47: l_rowtype_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
48: l_rowtype_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
49: l_rowtype_rec.CHECK_NUMBER := FND_API.G_MISS_CHAR;
50: l_rowtype_rec.CREDIT_CARD_APPROVAL_CODE := FND_API.G_MISS_CHAR;
51: l_rowtype_rec.CREDIT_CARD_APPROVAL_DATE := FND_API.G_MISS_DATE;
52: l_rowtype_rec.CREDIT_CARD_CODE := FND_API.G_MISS_CHAR;
53: l_rowtype_rec.CREDIT_CARD_EXPIRATION_DATE := FND_API.G_MISS_DATE;
54: l_rowtype_rec.CREDIT_CARD_HOLDER_NAME := FND_API.G_MISS_CHAR;

Line 51: l_rowtype_rec.CREDIT_CARD_APPROVAL_DATE := FND_API.G_MISS_DATE;

47: l_rowtype_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
48: l_rowtype_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
49: l_rowtype_rec.CHECK_NUMBER := FND_API.G_MISS_CHAR;
50: l_rowtype_rec.CREDIT_CARD_APPROVAL_CODE := FND_API.G_MISS_CHAR;
51: l_rowtype_rec.CREDIT_CARD_APPROVAL_DATE := FND_API.G_MISS_DATE;
52: l_rowtype_rec.CREDIT_CARD_CODE := FND_API.G_MISS_CHAR;
53: l_rowtype_rec.CREDIT_CARD_EXPIRATION_DATE := FND_API.G_MISS_DATE;
54: l_rowtype_rec.CREDIT_CARD_HOLDER_NAME := FND_API.G_MISS_CHAR;
55: l_rowtype_rec.CREDIT_CARD_NUMBER := FND_API.G_MISS_CHAR;

Line 52: l_rowtype_rec.CREDIT_CARD_CODE := FND_API.G_MISS_CHAR;

48: l_rowtype_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
49: l_rowtype_rec.CHECK_NUMBER := FND_API.G_MISS_CHAR;
50: l_rowtype_rec.CREDIT_CARD_APPROVAL_CODE := FND_API.G_MISS_CHAR;
51: l_rowtype_rec.CREDIT_CARD_APPROVAL_DATE := FND_API.G_MISS_DATE;
52: l_rowtype_rec.CREDIT_CARD_CODE := FND_API.G_MISS_CHAR;
53: l_rowtype_rec.CREDIT_CARD_EXPIRATION_DATE := FND_API.G_MISS_DATE;
54: l_rowtype_rec.CREDIT_CARD_HOLDER_NAME := FND_API.G_MISS_CHAR;
55: l_rowtype_rec.CREDIT_CARD_NUMBER := FND_API.G_MISS_CHAR;
56: l_rowtype_rec.PAYMENT_LEVEL_CODE := FND_API.G_MISS_CHAR;

Line 53: l_rowtype_rec.CREDIT_CARD_EXPIRATION_DATE := FND_API.G_MISS_DATE;

49: l_rowtype_rec.CHECK_NUMBER := FND_API.G_MISS_CHAR;
50: l_rowtype_rec.CREDIT_CARD_APPROVAL_CODE := FND_API.G_MISS_CHAR;
51: l_rowtype_rec.CREDIT_CARD_APPROVAL_DATE := FND_API.G_MISS_DATE;
52: l_rowtype_rec.CREDIT_CARD_CODE := FND_API.G_MISS_CHAR;
53: l_rowtype_rec.CREDIT_CARD_EXPIRATION_DATE := FND_API.G_MISS_DATE;
54: l_rowtype_rec.CREDIT_CARD_HOLDER_NAME := FND_API.G_MISS_CHAR;
55: l_rowtype_rec.CREDIT_CARD_NUMBER := FND_API.G_MISS_CHAR;
56: l_rowtype_rec.PAYMENT_LEVEL_CODE := FND_API.G_MISS_CHAR;
57: l_rowtype_rec.COMMITMENT_APPLIED_AMOUNT := FND_API.G_MISS_NUM;

Line 54: l_rowtype_rec.CREDIT_CARD_HOLDER_NAME := FND_API.G_MISS_CHAR;

50: l_rowtype_rec.CREDIT_CARD_APPROVAL_CODE := FND_API.G_MISS_CHAR;
51: l_rowtype_rec.CREDIT_CARD_APPROVAL_DATE := FND_API.G_MISS_DATE;
52: l_rowtype_rec.CREDIT_CARD_CODE := FND_API.G_MISS_CHAR;
53: l_rowtype_rec.CREDIT_CARD_EXPIRATION_DATE := FND_API.G_MISS_DATE;
54: l_rowtype_rec.CREDIT_CARD_HOLDER_NAME := FND_API.G_MISS_CHAR;
55: l_rowtype_rec.CREDIT_CARD_NUMBER := FND_API.G_MISS_CHAR;
56: l_rowtype_rec.PAYMENT_LEVEL_CODE := FND_API.G_MISS_CHAR;
57: l_rowtype_rec.COMMITMENT_APPLIED_AMOUNT := FND_API.G_MISS_NUM;
58: l_rowtype_rec.COMMITMENT_INTERFACED_AMOUNT := FND_API.G_MISS_NUM;

Line 55: l_rowtype_rec.CREDIT_CARD_NUMBER := FND_API.G_MISS_CHAR;

51: l_rowtype_rec.CREDIT_CARD_APPROVAL_DATE := FND_API.G_MISS_DATE;
52: l_rowtype_rec.CREDIT_CARD_CODE := FND_API.G_MISS_CHAR;
53: l_rowtype_rec.CREDIT_CARD_EXPIRATION_DATE := FND_API.G_MISS_DATE;
54: l_rowtype_rec.CREDIT_CARD_HOLDER_NAME := FND_API.G_MISS_CHAR;
55: l_rowtype_rec.CREDIT_CARD_NUMBER := FND_API.G_MISS_CHAR;
56: l_rowtype_rec.PAYMENT_LEVEL_CODE := FND_API.G_MISS_CHAR;
57: l_rowtype_rec.COMMITMENT_APPLIED_AMOUNT := FND_API.G_MISS_NUM;
58: l_rowtype_rec.COMMITMENT_INTERFACED_AMOUNT := FND_API.G_MISS_NUM;
59: l_rowtype_rec.PAYMENT_NUMBER := FND_API.G_MISS_NUM;

Line 56: l_rowtype_rec.PAYMENT_LEVEL_CODE := FND_API.G_MISS_CHAR;

52: l_rowtype_rec.CREDIT_CARD_CODE := FND_API.G_MISS_CHAR;
53: l_rowtype_rec.CREDIT_CARD_EXPIRATION_DATE := FND_API.G_MISS_DATE;
54: l_rowtype_rec.CREDIT_CARD_HOLDER_NAME := FND_API.G_MISS_CHAR;
55: l_rowtype_rec.CREDIT_CARD_NUMBER := FND_API.G_MISS_CHAR;
56: l_rowtype_rec.PAYMENT_LEVEL_CODE := FND_API.G_MISS_CHAR;
57: l_rowtype_rec.COMMITMENT_APPLIED_AMOUNT := FND_API.G_MISS_NUM;
58: l_rowtype_rec.COMMITMENT_INTERFACED_AMOUNT := FND_API.G_MISS_NUM;
59: l_rowtype_rec.PAYMENT_NUMBER := FND_API.G_MISS_NUM;
60: l_rowtype_rec.HEADER_ID := FND_API.G_MISS_NUM;

Line 57: l_rowtype_rec.COMMITMENT_APPLIED_AMOUNT := FND_API.G_MISS_NUM;

53: l_rowtype_rec.CREDIT_CARD_EXPIRATION_DATE := FND_API.G_MISS_DATE;
54: l_rowtype_rec.CREDIT_CARD_HOLDER_NAME := FND_API.G_MISS_CHAR;
55: l_rowtype_rec.CREDIT_CARD_NUMBER := FND_API.G_MISS_CHAR;
56: l_rowtype_rec.PAYMENT_LEVEL_CODE := FND_API.G_MISS_CHAR;
57: l_rowtype_rec.COMMITMENT_APPLIED_AMOUNT := FND_API.G_MISS_NUM;
58: l_rowtype_rec.COMMITMENT_INTERFACED_AMOUNT := FND_API.G_MISS_NUM;
59: l_rowtype_rec.PAYMENT_NUMBER := FND_API.G_MISS_NUM;
60: l_rowtype_rec.HEADER_ID := FND_API.G_MISS_NUM;
61: l_rowtype_rec.LINE_ID := FND_API.G_MISS_NUM;

Line 58: l_rowtype_rec.COMMITMENT_INTERFACED_AMOUNT := FND_API.G_MISS_NUM;

54: l_rowtype_rec.CREDIT_CARD_HOLDER_NAME := FND_API.G_MISS_CHAR;
55: l_rowtype_rec.CREDIT_CARD_NUMBER := FND_API.G_MISS_CHAR;
56: l_rowtype_rec.PAYMENT_LEVEL_CODE := FND_API.G_MISS_CHAR;
57: l_rowtype_rec.COMMITMENT_APPLIED_AMOUNT := FND_API.G_MISS_NUM;
58: l_rowtype_rec.COMMITMENT_INTERFACED_AMOUNT := FND_API.G_MISS_NUM;
59: l_rowtype_rec.PAYMENT_NUMBER := FND_API.G_MISS_NUM;
60: l_rowtype_rec.HEADER_ID := FND_API.G_MISS_NUM;
61: l_rowtype_rec.LINE_ID := FND_API.G_MISS_NUM;
62: l_rowtype_rec.PAYMENT_AMOUNT := FND_API.G_MISS_NUM;

Line 59: l_rowtype_rec.PAYMENT_NUMBER := FND_API.G_MISS_NUM;

55: l_rowtype_rec.CREDIT_CARD_NUMBER := FND_API.G_MISS_CHAR;
56: l_rowtype_rec.PAYMENT_LEVEL_CODE := FND_API.G_MISS_CHAR;
57: l_rowtype_rec.COMMITMENT_APPLIED_AMOUNT := FND_API.G_MISS_NUM;
58: l_rowtype_rec.COMMITMENT_INTERFACED_AMOUNT := FND_API.G_MISS_NUM;
59: l_rowtype_rec.PAYMENT_NUMBER := FND_API.G_MISS_NUM;
60: l_rowtype_rec.HEADER_ID := FND_API.G_MISS_NUM;
61: l_rowtype_rec.LINE_ID := FND_API.G_MISS_NUM;
62: l_rowtype_rec.PAYMENT_AMOUNT := FND_API.G_MISS_NUM;
63: l_rowtype_rec.PAYMENT_COLLECTION_EVENT := FND_API.G_MISS_CHAR;

Line 60: l_rowtype_rec.HEADER_ID := FND_API.G_MISS_NUM;

56: l_rowtype_rec.PAYMENT_LEVEL_CODE := FND_API.G_MISS_CHAR;
57: l_rowtype_rec.COMMITMENT_APPLIED_AMOUNT := FND_API.G_MISS_NUM;
58: l_rowtype_rec.COMMITMENT_INTERFACED_AMOUNT := FND_API.G_MISS_NUM;
59: l_rowtype_rec.PAYMENT_NUMBER := FND_API.G_MISS_NUM;
60: l_rowtype_rec.HEADER_ID := FND_API.G_MISS_NUM;
61: l_rowtype_rec.LINE_ID := FND_API.G_MISS_NUM;
62: l_rowtype_rec.PAYMENT_AMOUNT := FND_API.G_MISS_NUM;
63: l_rowtype_rec.PAYMENT_COLLECTION_EVENT := FND_API.G_MISS_CHAR;
64: l_rowtype_rec.PAYMENT_TRX_ID := FND_API.G_MISS_NUM;

Line 61: l_rowtype_rec.LINE_ID := FND_API.G_MISS_NUM;

57: l_rowtype_rec.COMMITMENT_APPLIED_AMOUNT := FND_API.G_MISS_NUM;
58: l_rowtype_rec.COMMITMENT_INTERFACED_AMOUNT := FND_API.G_MISS_NUM;
59: l_rowtype_rec.PAYMENT_NUMBER := FND_API.G_MISS_NUM;
60: l_rowtype_rec.HEADER_ID := FND_API.G_MISS_NUM;
61: l_rowtype_rec.LINE_ID := FND_API.G_MISS_NUM;
62: l_rowtype_rec.PAYMENT_AMOUNT := FND_API.G_MISS_NUM;
63: l_rowtype_rec.PAYMENT_COLLECTION_EVENT := FND_API.G_MISS_CHAR;
64: l_rowtype_rec.PAYMENT_TRX_ID := FND_API.G_MISS_NUM;
65: l_rowtype_rec.PAYMENT_TYPE_CODE := FND_API.G_MISS_CHAR;

Line 62: l_rowtype_rec.PAYMENT_AMOUNT := FND_API.G_MISS_NUM;

58: l_rowtype_rec.COMMITMENT_INTERFACED_AMOUNT := FND_API.G_MISS_NUM;
59: l_rowtype_rec.PAYMENT_NUMBER := FND_API.G_MISS_NUM;
60: l_rowtype_rec.HEADER_ID := FND_API.G_MISS_NUM;
61: l_rowtype_rec.LINE_ID := FND_API.G_MISS_NUM;
62: l_rowtype_rec.PAYMENT_AMOUNT := FND_API.G_MISS_NUM;
63: l_rowtype_rec.PAYMENT_COLLECTION_EVENT := FND_API.G_MISS_CHAR;
64: l_rowtype_rec.PAYMENT_TRX_ID := FND_API.G_MISS_NUM;
65: l_rowtype_rec.PAYMENT_TYPE_CODE := FND_API.G_MISS_CHAR;
66: l_rowtype_rec.PAYMENT_SET_ID := FND_API.G_MISS_NUM;

Line 63: l_rowtype_rec.PAYMENT_COLLECTION_EVENT := FND_API.G_MISS_CHAR;

59: l_rowtype_rec.PAYMENT_NUMBER := FND_API.G_MISS_NUM;
60: l_rowtype_rec.HEADER_ID := FND_API.G_MISS_NUM;
61: l_rowtype_rec.LINE_ID := FND_API.G_MISS_NUM;
62: l_rowtype_rec.PAYMENT_AMOUNT := FND_API.G_MISS_NUM;
63: l_rowtype_rec.PAYMENT_COLLECTION_EVENT := FND_API.G_MISS_CHAR;
64: l_rowtype_rec.PAYMENT_TRX_ID := FND_API.G_MISS_NUM;
65: l_rowtype_rec.PAYMENT_TYPE_CODE := FND_API.G_MISS_CHAR;
66: l_rowtype_rec.PAYMENT_SET_ID := FND_API.G_MISS_NUM;
67: l_rowtype_rec.PREPAID_AMOUNT := FND_API.G_MISS_NUM;

Line 64: l_rowtype_rec.PAYMENT_TRX_ID := FND_API.G_MISS_NUM;

60: l_rowtype_rec.HEADER_ID := FND_API.G_MISS_NUM;
61: l_rowtype_rec.LINE_ID := FND_API.G_MISS_NUM;
62: l_rowtype_rec.PAYMENT_AMOUNT := FND_API.G_MISS_NUM;
63: l_rowtype_rec.PAYMENT_COLLECTION_EVENT := FND_API.G_MISS_CHAR;
64: l_rowtype_rec.PAYMENT_TRX_ID := FND_API.G_MISS_NUM;
65: l_rowtype_rec.PAYMENT_TYPE_CODE := FND_API.G_MISS_CHAR;
66: l_rowtype_rec.PAYMENT_SET_ID := FND_API.G_MISS_NUM;
67: l_rowtype_rec.PREPAID_AMOUNT := FND_API.G_MISS_NUM;
68: l_rowtype_rec.PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;

Line 65: l_rowtype_rec.PAYMENT_TYPE_CODE := FND_API.G_MISS_CHAR;

61: l_rowtype_rec.LINE_ID := FND_API.G_MISS_NUM;
62: l_rowtype_rec.PAYMENT_AMOUNT := FND_API.G_MISS_NUM;
63: l_rowtype_rec.PAYMENT_COLLECTION_EVENT := FND_API.G_MISS_CHAR;
64: l_rowtype_rec.PAYMENT_TRX_ID := FND_API.G_MISS_NUM;
65: l_rowtype_rec.PAYMENT_TYPE_CODE := FND_API.G_MISS_CHAR;
66: l_rowtype_rec.PAYMENT_SET_ID := FND_API.G_MISS_NUM;
67: l_rowtype_rec.PREPAID_AMOUNT := FND_API.G_MISS_NUM;
68: l_rowtype_rec.PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;
69: l_rowtype_rec.PROGRAM_ID := FND_API.G_MISS_NUM;

Line 66: l_rowtype_rec.PAYMENT_SET_ID := FND_API.G_MISS_NUM;

62: l_rowtype_rec.PAYMENT_AMOUNT := FND_API.G_MISS_NUM;
63: l_rowtype_rec.PAYMENT_COLLECTION_EVENT := FND_API.G_MISS_CHAR;
64: l_rowtype_rec.PAYMENT_TRX_ID := FND_API.G_MISS_NUM;
65: l_rowtype_rec.PAYMENT_TYPE_CODE := FND_API.G_MISS_CHAR;
66: l_rowtype_rec.PAYMENT_SET_ID := FND_API.G_MISS_NUM;
67: l_rowtype_rec.PREPAID_AMOUNT := FND_API.G_MISS_NUM;
68: l_rowtype_rec.PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;
69: l_rowtype_rec.PROGRAM_ID := FND_API.G_MISS_NUM;
70: l_rowtype_rec.PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;

Line 67: l_rowtype_rec.PREPAID_AMOUNT := FND_API.G_MISS_NUM;

63: l_rowtype_rec.PAYMENT_COLLECTION_EVENT := FND_API.G_MISS_CHAR;
64: l_rowtype_rec.PAYMENT_TRX_ID := FND_API.G_MISS_NUM;
65: l_rowtype_rec.PAYMENT_TYPE_CODE := FND_API.G_MISS_CHAR;
66: l_rowtype_rec.PAYMENT_SET_ID := FND_API.G_MISS_NUM;
67: l_rowtype_rec.PREPAID_AMOUNT := FND_API.G_MISS_NUM;
68: l_rowtype_rec.PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;
69: l_rowtype_rec.PROGRAM_ID := FND_API.G_MISS_NUM;
70: l_rowtype_rec.PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
71: l_rowtype_rec.RECEIPT_METHOD_ID := FND_API.G_MISS_NUM;

Line 68: l_rowtype_rec.PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;

64: l_rowtype_rec.PAYMENT_TRX_ID := FND_API.G_MISS_NUM;
65: l_rowtype_rec.PAYMENT_TYPE_CODE := FND_API.G_MISS_CHAR;
66: l_rowtype_rec.PAYMENT_SET_ID := FND_API.G_MISS_NUM;
67: l_rowtype_rec.PREPAID_AMOUNT := FND_API.G_MISS_NUM;
68: l_rowtype_rec.PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;
69: l_rowtype_rec.PROGRAM_ID := FND_API.G_MISS_NUM;
70: l_rowtype_rec.PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
71: l_rowtype_rec.RECEIPT_METHOD_ID := FND_API.G_MISS_NUM;
72: l_rowtype_rec.REQUEST_ID := FND_API.G_MISS_NUM;

Line 69: l_rowtype_rec.PROGRAM_ID := FND_API.G_MISS_NUM;

65: l_rowtype_rec.PAYMENT_TYPE_CODE := FND_API.G_MISS_CHAR;
66: l_rowtype_rec.PAYMENT_SET_ID := FND_API.G_MISS_NUM;
67: l_rowtype_rec.PREPAID_AMOUNT := FND_API.G_MISS_NUM;
68: l_rowtype_rec.PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;
69: l_rowtype_rec.PROGRAM_ID := FND_API.G_MISS_NUM;
70: l_rowtype_rec.PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
71: l_rowtype_rec.RECEIPT_METHOD_ID := FND_API.G_MISS_NUM;
72: l_rowtype_rec.REQUEST_ID := FND_API.G_MISS_NUM;
73: l_rowtype_rec.TANGIBLE_ID := FND_API.G_MISS_CHAR;

Line 70: l_rowtype_rec.PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;

66: l_rowtype_rec.PAYMENT_SET_ID := FND_API.G_MISS_NUM;
67: l_rowtype_rec.PREPAID_AMOUNT := FND_API.G_MISS_NUM;
68: l_rowtype_rec.PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;
69: l_rowtype_rec.PROGRAM_ID := FND_API.G_MISS_NUM;
70: l_rowtype_rec.PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
71: l_rowtype_rec.RECEIPT_METHOD_ID := FND_API.G_MISS_NUM;
72: l_rowtype_rec.REQUEST_ID := FND_API.G_MISS_NUM;
73: l_rowtype_rec.TANGIBLE_ID := FND_API.G_MISS_CHAR;
74: l_rowtype_rec.RETURN_STATUS := FND_API.G_MISS_CHAR;

Line 71: l_rowtype_rec.RECEIPT_METHOD_ID := FND_API.G_MISS_NUM;

67: l_rowtype_rec.PREPAID_AMOUNT := FND_API.G_MISS_NUM;
68: l_rowtype_rec.PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;
69: l_rowtype_rec.PROGRAM_ID := FND_API.G_MISS_NUM;
70: l_rowtype_rec.PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
71: l_rowtype_rec.RECEIPT_METHOD_ID := FND_API.G_MISS_NUM;
72: l_rowtype_rec.REQUEST_ID := FND_API.G_MISS_NUM;
73: l_rowtype_rec.TANGIBLE_ID := FND_API.G_MISS_CHAR;
74: l_rowtype_rec.RETURN_STATUS := FND_API.G_MISS_CHAR;
75: l_rowtype_rec.DB_FLAG := FND_API.G_MISS_CHAR;

Line 72: l_rowtype_rec.REQUEST_ID := FND_API.G_MISS_NUM;

68: l_rowtype_rec.PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;
69: l_rowtype_rec.PROGRAM_ID := FND_API.G_MISS_NUM;
70: l_rowtype_rec.PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
71: l_rowtype_rec.RECEIPT_METHOD_ID := FND_API.G_MISS_NUM;
72: l_rowtype_rec.REQUEST_ID := FND_API.G_MISS_NUM;
73: l_rowtype_rec.TANGIBLE_ID := FND_API.G_MISS_CHAR;
74: l_rowtype_rec.RETURN_STATUS := FND_API.G_MISS_CHAR;
75: l_rowtype_rec.DB_FLAG := FND_API.G_MISS_CHAR;
76: l_rowtype_rec.OPERATION := FND_API.G_MISS_CHAR;

Line 73: l_rowtype_rec.TANGIBLE_ID := FND_API.G_MISS_CHAR;

69: l_rowtype_rec.PROGRAM_ID := FND_API.G_MISS_NUM;
70: l_rowtype_rec.PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
71: l_rowtype_rec.RECEIPT_METHOD_ID := FND_API.G_MISS_NUM;
72: l_rowtype_rec.REQUEST_ID := FND_API.G_MISS_NUM;
73: l_rowtype_rec.TANGIBLE_ID := FND_API.G_MISS_CHAR;
74: l_rowtype_rec.RETURN_STATUS := FND_API.G_MISS_CHAR;
75: l_rowtype_rec.DB_FLAG := FND_API.G_MISS_CHAR;
76: l_rowtype_rec.OPERATION := FND_API.G_MISS_CHAR;
77:

Line 74: l_rowtype_rec.RETURN_STATUS := FND_API.G_MISS_CHAR;

70: l_rowtype_rec.PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
71: l_rowtype_rec.RECEIPT_METHOD_ID := FND_API.G_MISS_NUM;
72: l_rowtype_rec.REQUEST_ID := FND_API.G_MISS_NUM;
73: l_rowtype_rec.TANGIBLE_ID := FND_API.G_MISS_CHAR;
74: l_rowtype_rec.RETURN_STATUS := FND_API.G_MISS_CHAR;
75: l_rowtype_rec.DB_FLAG := FND_API.G_MISS_CHAR;
76: l_rowtype_rec.OPERATION := FND_API.G_MISS_CHAR;
77:
78: RETURN l_rowtype_rec;

Line 75: l_rowtype_rec.DB_FLAG := FND_API.G_MISS_CHAR;

71: l_rowtype_rec.RECEIPT_METHOD_ID := FND_API.G_MISS_NUM;
72: l_rowtype_rec.REQUEST_ID := FND_API.G_MISS_NUM;
73: l_rowtype_rec.TANGIBLE_ID := FND_API.G_MISS_CHAR;
74: l_rowtype_rec.RETURN_STATUS := FND_API.G_MISS_CHAR;
75: l_rowtype_rec.DB_FLAG := FND_API.G_MISS_CHAR;
76: l_rowtype_rec.OPERATION := FND_API.G_MISS_CHAR;
77:
78: RETURN l_rowtype_rec;
79:

Line 76: l_rowtype_rec.OPERATION := FND_API.G_MISS_CHAR;

72: l_rowtype_rec.REQUEST_ID := FND_API.G_MISS_NUM;
73: l_rowtype_rec.TANGIBLE_ID := FND_API.G_MISS_CHAR;
74: l_rowtype_rec.RETURN_STATUS := FND_API.G_MISS_CHAR;
75: l_rowtype_rec.DB_FLAG := FND_API.G_MISS_CHAR;
76: l_rowtype_rec.OPERATION := FND_API.G_MISS_CHAR;
77:
78: RETURN l_rowtype_rec;
79:
80: END G_MISS_OE_AK_LPAYMENT_REC;

Line 207: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM

203:
204: -- Procedure Clear_Dependent_Attr
205:
206: PROCEDURE Clear_Dependent_Attr
207: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
208: , p_x_Line_Payment_rec IN OUT NOCOPY OE_AK_LINE_PAYMENTS_V%ROWTYPE
209: , p_old_Line_Payment_rec IN OE_AK_LINE_PAYMENTS_V%ROWTYPE :=
210: G_MISS_OE_AK_LPayment_REC
211: , p_x_instrument_id IN NUMBER DEFAULT NULL --R12 CC Encryption

Line 230: IF p_attr_id = FND_API.G_MISS_NUM THEN

226:
227: -- If attr_id is missing compare old and new records and for
228: -- every changed attribute clear its dependent fields.
229:
230: IF p_attr_id = FND_API.G_MISS_NUM THEN
231:
232: IF NOT OE_GLOBALS.Equal(p_x_Line_Payment_rec.attribute1,p_old_Line_Payment_rec.attribute1)
233: THEN
234: l_index := l_index + 1;

Line 664: p_x_Line_PAYMENT_rec.ATTRIBUTE1 := FND_API.G_MISS_NUM;

660: p_dep_attr_tbl => l_dep_attr_tbl);
661:
662: FOR I IN 1..l_dep_attr_tbl.COUNT LOOP
663: IF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE1 THEN
664: p_x_Line_PAYMENT_rec.ATTRIBUTE1 := FND_API.G_MISS_NUM;
665: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE2 THEN
666: p_x_Line_PAYMENT_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
667: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE3 THEN
668: p_x_Line_PAYMENT_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;

Line 666: p_x_Line_PAYMENT_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;

662: FOR I IN 1..l_dep_attr_tbl.COUNT LOOP
663: IF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE1 THEN
664: p_x_Line_PAYMENT_rec.ATTRIBUTE1 := FND_API.G_MISS_NUM;
665: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE2 THEN
666: p_x_Line_PAYMENT_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
667: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE3 THEN
668: p_x_Line_PAYMENT_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
669: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE4 THEN
670: p_x_Line_PAYMENT_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;

Line 668: p_x_Line_PAYMENT_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;

664: p_x_Line_PAYMENT_rec.ATTRIBUTE1 := FND_API.G_MISS_NUM;
665: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE2 THEN
666: p_x_Line_PAYMENT_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
667: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE3 THEN
668: p_x_Line_PAYMENT_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
669: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE4 THEN
670: p_x_Line_PAYMENT_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
671: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE5 THEN
672: p_x_Line_PAYMENT_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;

Line 670: p_x_Line_PAYMENT_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;

666: p_x_Line_PAYMENT_rec.ATTRIBUTE2 := FND_API.G_MISS_CHAR;
667: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE3 THEN
668: p_x_Line_PAYMENT_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
669: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE4 THEN
670: p_x_Line_PAYMENT_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
671: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE5 THEN
672: p_x_Line_PAYMENT_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
673: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE6 THEN
674: p_x_Line_PAYMENT_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;

Line 672: p_x_Line_PAYMENT_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;

668: p_x_Line_PAYMENT_rec.ATTRIBUTE3 := FND_API.G_MISS_CHAR;
669: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE4 THEN
670: p_x_Line_PAYMENT_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
671: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE5 THEN
672: p_x_Line_PAYMENT_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
673: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE6 THEN
674: p_x_Line_PAYMENT_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
675: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE7 THEN
676: p_x_Line_PAYMENT_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;

Line 674: p_x_Line_PAYMENT_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;

670: p_x_Line_PAYMENT_rec.ATTRIBUTE4 := FND_API.G_MISS_CHAR;
671: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE5 THEN
672: p_x_Line_PAYMENT_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
673: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE6 THEN
674: p_x_Line_PAYMENT_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
675: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE7 THEN
676: p_x_Line_PAYMENT_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
677: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE8 THEN
678: p_x_Line_PAYMENT_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;

Line 676: p_x_Line_PAYMENT_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;

672: p_x_Line_PAYMENT_rec.ATTRIBUTE5 := FND_API.G_MISS_CHAR;
673: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE6 THEN
674: p_x_Line_PAYMENT_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
675: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE7 THEN
676: p_x_Line_PAYMENT_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
677: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE8 THEN
678: p_x_Line_PAYMENT_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
679: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE9 THEN
680: p_x_Line_PAYMENT_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;

Line 678: p_x_Line_PAYMENT_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;

674: p_x_Line_PAYMENT_rec.ATTRIBUTE6 := FND_API.G_MISS_CHAR;
675: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE7 THEN
676: p_x_Line_PAYMENT_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
677: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE8 THEN
678: p_x_Line_PAYMENT_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
679: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE9 THEN
680: p_x_Line_PAYMENT_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
681: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE10 THEN
682: p_x_Line_PAYMENT_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;

Line 680: p_x_Line_PAYMENT_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;

676: p_x_Line_PAYMENT_rec.ATTRIBUTE7 := FND_API.G_MISS_CHAR;
677: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE8 THEN
678: p_x_Line_PAYMENT_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
679: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE9 THEN
680: p_x_Line_PAYMENT_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
681: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE10 THEN
682: p_x_Line_PAYMENT_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
683: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE11 THEN
684: p_x_Line_PAYMENT_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;

Line 682: p_x_Line_PAYMENT_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;

678: p_x_Line_PAYMENT_rec.ATTRIBUTE8 := FND_API.G_MISS_CHAR;
679: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE9 THEN
680: p_x_Line_PAYMENT_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
681: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE10 THEN
682: p_x_Line_PAYMENT_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
683: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE11 THEN
684: p_x_Line_PAYMENT_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
685: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE12 THEN
686: p_x_Line_PAYMENT_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;

Line 684: p_x_Line_PAYMENT_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;

680: p_x_Line_PAYMENT_rec.ATTRIBUTE9 := FND_API.G_MISS_CHAR;
681: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE10 THEN
682: p_x_Line_PAYMENT_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
683: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE11 THEN
684: p_x_Line_PAYMENT_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
685: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE12 THEN
686: p_x_Line_PAYMENT_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
687: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE13 THEN
688: p_x_Line_PAYMENT_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;

Line 686: p_x_Line_PAYMENT_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;

682: p_x_Line_PAYMENT_rec.ATTRIBUTE10 := FND_API.G_MISS_CHAR;
683: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE11 THEN
684: p_x_Line_PAYMENT_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
685: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE12 THEN
686: p_x_Line_PAYMENT_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
687: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE13 THEN
688: p_x_Line_PAYMENT_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
689: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE14 THEN
690: p_x_Line_PAYMENT_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;

Line 688: p_x_Line_PAYMENT_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;

684: p_x_Line_PAYMENT_rec.ATTRIBUTE11 := FND_API.G_MISS_CHAR;
685: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE12 THEN
686: p_x_Line_PAYMENT_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
687: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE13 THEN
688: p_x_Line_PAYMENT_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
689: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE14 THEN
690: p_x_Line_PAYMENT_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
691: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE15 THEN
692: p_x_Line_PAYMENT_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;

Line 690: p_x_Line_PAYMENT_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;

686: p_x_Line_PAYMENT_rec.ATTRIBUTE12 := FND_API.G_MISS_CHAR;
687: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE13 THEN
688: p_x_Line_PAYMENT_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
689: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE14 THEN
690: p_x_Line_PAYMENT_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
691: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE15 THEN
692: p_x_Line_PAYMENT_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
693: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_CONTEXT THEN
694: p_x_Line_PAYMENT_rec.CONTEXT := FND_API.G_MISS_CHAR;

Line 692: p_x_Line_PAYMENT_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;

688: p_x_Line_PAYMENT_rec.ATTRIBUTE13 := FND_API.G_MISS_CHAR;
689: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE14 THEN
690: p_x_Line_PAYMENT_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
691: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE15 THEN
692: p_x_Line_PAYMENT_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
693: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_CONTEXT THEN
694: p_x_Line_PAYMENT_rec.CONTEXT := FND_API.G_MISS_CHAR;
695: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_CREATED_BY THEN
696: p_x_Line_PAYMENT_rec.CREATED_BY := FND_API.G_MISS_NUM;

Line 694: p_x_Line_PAYMENT_rec.CONTEXT := FND_API.G_MISS_CHAR;

690: p_x_Line_PAYMENT_rec.ATTRIBUTE14 := FND_API.G_MISS_CHAR;
691: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_ATTRIBUTE15 THEN
692: p_x_Line_PAYMENT_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
693: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_CONTEXT THEN
694: p_x_Line_PAYMENT_rec.CONTEXT := FND_API.G_MISS_CHAR;
695: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_CREATED_BY THEN
696: p_x_Line_PAYMENT_rec.CREATED_BY := FND_API.G_MISS_NUM;
697: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_CREATION_DATE THEN
698: p_x_Line_PAYMENT_rec.CREATION_DATE := FND_API.G_MISS_DATE;

Line 696: p_x_Line_PAYMENT_rec.CREATED_BY := FND_API.G_MISS_NUM;

692: p_x_Line_PAYMENT_rec.ATTRIBUTE15 := FND_API.G_MISS_CHAR;
693: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_CONTEXT THEN
694: p_x_Line_PAYMENT_rec.CONTEXT := FND_API.G_MISS_CHAR;
695: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_CREATED_BY THEN
696: p_x_Line_PAYMENT_rec.CREATED_BY := FND_API.G_MISS_NUM;
697: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_CREATION_DATE THEN
698: p_x_Line_PAYMENT_rec.CREATION_DATE := FND_API.G_MISS_DATE;
699: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_LAST_UPDATED_BY THEN
700: p_x_Line_PAYMENT_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;

Line 698: p_x_Line_PAYMENT_rec.CREATION_DATE := FND_API.G_MISS_DATE;

694: p_x_Line_PAYMENT_rec.CONTEXT := FND_API.G_MISS_CHAR;
695: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_CREATED_BY THEN
696: p_x_Line_PAYMENT_rec.CREATED_BY := FND_API.G_MISS_NUM;
697: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_CREATION_DATE THEN
698: p_x_Line_PAYMENT_rec.CREATION_DATE := FND_API.G_MISS_DATE;
699: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_LAST_UPDATED_BY THEN
700: p_x_Line_PAYMENT_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
701: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_LAST_UPDATE_DATE THEN
702: p_x_Line_PAYMENT_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;

Line 700: p_x_Line_PAYMENT_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;

696: p_x_Line_PAYMENT_rec.CREATED_BY := FND_API.G_MISS_NUM;
697: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_CREATION_DATE THEN
698: p_x_Line_PAYMENT_rec.CREATION_DATE := FND_API.G_MISS_DATE;
699: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_LAST_UPDATED_BY THEN
700: p_x_Line_PAYMENT_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
701: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_LAST_UPDATE_DATE THEN
702: p_x_Line_PAYMENT_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
703: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_LAST_UPDATE_LOGIN THEN
704: p_x_Line_PAYMENT_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;

Line 702: p_x_Line_PAYMENT_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;

698: p_x_Line_PAYMENT_rec.CREATION_DATE := FND_API.G_MISS_DATE;
699: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_LAST_UPDATED_BY THEN
700: p_x_Line_PAYMENT_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
701: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_LAST_UPDATE_DATE THEN
702: p_x_Line_PAYMENT_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
703: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_LAST_UPDATE_LOGIN THEN
704: p_x_Line_PAYMENT_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
705: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_CHECK_NUMBER THEN
706: p_x_Line_PAYMENT_rec.CHECK_NUMBER := FND_API.G_MISS_CHAR;

Line 704: p_x_Line_PAYMENT_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;

700: p_x_Line_PAYMENT_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
701: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_LAST_UPDATE_DATE THEN
702: p_x_Line_PAYMENT_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
703: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_LAST_UPDATE_LOGIN THEN
704: p_x_Line_PAYMENT_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
705: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_CHECK_NUMBER THEN
706: p_x_Line_PAYMENT_rec.CHECK_NUMBER := FND_API.G_MISS_CHAR;
707: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_CREDIT_CARD_APPROVAL_CODE THEN
708: --R12 CC Encryption

Line 706: p_x_Line_PAYMENT_rec.CHECK_NUMBER := FND_API.G_MISS_CHAR;

702: p_x_Line_PAYMENT_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
703: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_LAST_UPDATE_LOGIN THEN
704: p_x_Line_PAYMENT_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
705: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_CHECK_NUMBER THEN
706: p_x_Line_PAYMENT_rec.CHECK_NUMBER := FND_API.G_MISS_CHAR;
707: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_CREDIT_CARD_APPROVAL_CODE THEN
708: --R12 CC Encryption
709: --Added the additional conditional before clearing credit
710: --card attributes as the dependent attributes were cleared out

Line 718: p_x_Line_PAYMENT_rec.CREDIT_CARD_APPROVAL_CODE := FND_API.G_MISS_CHAR;

714: AND (p_old_Line_Payment_rec.header_id IS NOT NULL OR
715: p_x_Line_PAYMENT_rec.CREDIT_CARD_APPROVAL_CODE IS NOT NULL)
716: ) -- AND condition added to fix 3098878
717: THEN
718: p_x_Line_PAYMENT_rec.CREDIT_CARD_APPROVAL_CODE := FND_API.G_MISS_CHAR;
719: END IF;
720: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_CREDIT_CARD_APPROVAL_DATE THEN
721: IF (OE_GLOBALS.Equal(p_x_Line_PAYMENT_rec.CREDIT_CARD_APPROVAL_DATE, p_old_Line_Payment_rec.CREDIT_CARD_APPROVAL_DATE)
722: AND (p_old_Line_Payment_rec.header_id IS NOT NULL OR

Line 726: p_x_Line_PAYMENT_rec.CREDIT_CARD_APPROVAL_DATE := FND_API.G_MISS_DATE;

722: AND (p_old_Line_Payment_rec.header_id IS NOT NULL OR
723: p_x_Line_PAYMENT_rec.CREDIT_CARD_APPROVAL_DATE IS NOT NULL)
724: ) -- AND condition added to fix 3098878
725: THEN
726: p_x_Line_PAYMENT_rec.CREDIT_CARD_APPROVAL_DATE := FND_API.G_MISS_DATE;
727: END IF;
728: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_CREDIT_CARD_CODE THEN
729: IF (OE_GLOBALS.Equal(p_x_Line_PAYMENT_rec.CREDIT_CARD_CODE, p_old_Line_Payment_rec.CREDIT_CARD_CODE)
730: AND (p_old_Line_Payment_rec.header_id IS NOT NULL OR

Line 734: p_x_Line_PAYMENT_rec.CREDIT_CARD_CODE := FND_API.G_MISS_CHAR;

730: AND (p_old_Line_Payment_rec.header_id IS NOT NULL OR
731: p_x_Line_PAYMENT_rec.CREDIT_CARD_CODE IS NOT NULL)
732: ) -- AND condition added to fix 3098878
733: THEN
734: p_x_Line_PAYMENT_rec.CREDIT_CARD_CODE := FND_API.G_MISS_CHAR;
735: END IF;
736: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_CREDIT_CARD_EXPIRATION_DATE THEN
737: IF l_debug_level > 0 THEN
738: oe_debug_pub.add('Old exp date'||p_old_Line_Payment_rec.credit_card_expiration_date);

Line 746: p_x_Line_PAYMENT_rec.CREDIT_CARD_EXPIRATION_DATE := FND_API.G_MISS_DATE;

742: AND (p_old_Line_Payment_rec.header_id IS NOT NULL OR
743: p_x_Line_PAYMENT_rec.CREDIT_CARD_EXPIRATION_DATE IS NOT NULL)
744: ) -- AND condition added to fix 3098878
745: THEN
746: p_x_Line_PAYMENT_rec.CREDIT_CARD_EXPIRATION_DATE := FND_API.G_MISS_DATE;
747: END IF;
748: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_CREDIT_CARD_HOLDER_NAME THEN
749: IF l_debug_level > 0 THEN
750: oe_debug_pub.add('Old holder name'||p_old_Line_Payment_rec.CREDIT_CARD_HOLDER_NAME);

Line 758: p_x_Line_PAYMENT_rec.CREDIT_CARD_HOLDER_NAME := FND_API.G_MISS_CHAR;

754: AND (p_old_Line_Payment_rec.header_id IS NOT NULL OR
755: p_x_Line_PAYMENT_rec.CREDIT_CARD_HOLDER_NAME IS NOT NULL)
756: ) -- AND condition added to fix 3098878
757: THEN
758: p_x_Line_PAYMENT_rec.CREDIT_CARD_HOLDER_NAME := FND_API.G_MISS_CHAR;
759: END IF;
760: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_CREDIT_CARD_NUMBER THEN
761: IF (OE_GLOBALS.Is_Same_Credit_Card(p_old_Line_Payment_rec.CREDIT_CARD_NUMBER,
762: p_x_Line_PAYMENT_rec.CREDIT_CARD_NUMBER,p_old_instrument_id,

Line 768: p_x_Line_PAYMENT_rec.CREDIT_CARD_NUMBER := FND_API.G_MISS_CHAR;

764: AND (p_old_Line_Payment_rec.header_id IS NOT NULL OR
765: p_x_Line_PAYMENT_rec.CREDIT_CARD_NUMBER IS NOT NULL)
766: ) -- AND condition added to fix 3098878
767: THEN
768: p_x_Line_PAYMENT_rec.CREDIT_CARD_NUMBER := FND_API.G_MISS_CHAR;
769: END IF;
770: --R12 CC Encryption
771: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PAYMENT_LEVEL_CODE THEN
772: p_x_Line_PAYMENT_rec.PAYMENT_LEVEL_CODE := FND_API.G_MISS_CHAR;

Line 772: p_x_Line_PAYMENT_rec.PAYMENT_LEVEL_CODE := FND_API.G_MISS_CHAR;

768: p_x_Line_PAYMENT_rec.CREDIT_CARD_NUMBER := FND_API.G_MISS_CHAR;
769: END IF;
770: --R12 CC Encryption
771: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PAYMENT_LEVEL_CODE THEN
772: p_x_Line_PAYMENT_rec.PAYMENT_LEVEL_CODE := FND_API.G_MISS_CHAR;
773: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_COMMITMENT_APPLIED_AMOUNT THEN
774: p_x_Line_PAYMENT_rec.COMMITMENT_APPLIED_AMOUNT := FND_API.G_MISS_NUM;
775: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_COMMITMENT_INTERFACED_AMOUNT THEN
776: p_x_Line_PAYMENT_rec.COMMITMENT_INTERFACED_AMOUNT := FND_API.G_MISS_NUM;

Line 774: p_x_Line_PAYMENT_rec.COMMITMENT_APPLIED_AMOUNT := FND_API.G_MISS_NUM;

770: --R12 CC Encryption
771: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PAYMENT_LEVEL_CODE THEN
772: p_x_Line_PAYMENT_rec.PAYMENT_LEVEL_CODE := FND_API.G_MISS_CHAR;
773: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_COMMITMENT_APPLIED_AMOUNT THEN
774: p_x_Line_PAYMENT_rec.COMMITMENT_APPLIED_AMOUNT := FND_API.G_MISS_NUM;
775: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_COMMITMENT_INTERFACED_AMOUNT THEN
776: p_x_Line_PAYMENT_rec.COMMITMENT_INTERFACED_AMOUNT := FND_API.G_MISS_NUM;
777: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PAYMENT_NUMBER THEN
778: p_x_Line_PAYMENT_rec.PAYMENT_NUMBER := FND_API.G_MISS_NUM;

Line 776: p_x_Line_PAYMENT_rec.COMMITMENT_INTERFACED_AMOUNT := FND_API.G_MISS_NUM;

772: p_x_Line_PAYMENT_rec.PAYMENT_LEVEL_CODE := FND_API.G_MISS_CHAR;
773: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_COMMITMENT_APPLIED_AMOUNT THEN
774: p_x_Line_PAYMENT_rec.COMMITMENT_APPLIED_AMOUNT := FND_API.G_MISS_NUM;
775: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_COMMITMENT_INTERFACED_AMOUNT THEN
776: p_x_Line_PAYMENT_rec.COMMITMENT_INTERFACED_AMOUNT := FND_API.G_MISS_NUM;
777: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PAYMENT_NUMBER THEN
778: p_x_Line_PAYMENT_rec.PAYMENT_NUMBER := FND_API.G_MISS_NUM;
779: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_HEADER THEN
780: p_x_Line_PAYMENT_rec.HEADER_ID := FND_API.G_MISS_NUM;

Line 778: p_x_Line_PAYMENT_rec.PAYMENT_NUMBER := FND_API.G_MISS_NUM;

774: p_x_Line_PAYMENT_rec.COMMITMENT_APPLIED_AMOUNT := FND_API.G_MISS_NUM;
775: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_COMMITMENT_INTERFACED_AMOUNT THEN
776: p_x_Line_PAYMENT_rec.COMMITMENT_INTERFACED_AMOUNT := FND_API.G_MISS_NUM;
777: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PAYMENT_NUMBER THEN
778: p_x_Line_PAYMENT_rec.PAYMENT_NUMBER := FND_API.G_MISS_NUM;
779: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_HEADER THEN
780: p_x_Line_PAYMENT_rec.HEADER_ID := FND_API.G_MISS_NUM;
781: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_LINE THEN
782: p_x_Line_PAYMENT_rec.LINE_ID := FND_API.G_MISS_NUM;

Line 780: p_x_Line_PAYMENT_rec.HEADER_ID := FND_API.G_MISS_NUM;

776: p_x_Line_PAYMENT_rec.COMMITMENT_INTERFACED_AMOUNT := FND_API.G_MISS_NUM;
777: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PAYMENT_NUMBER THEN
778: p_x_Line_PAYMENT_rec.PAYMENT_NUMBER := FND_API.G_MISS_NUM;
779: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_HEADER THEN
780: p_x_Line_PAYMENT_rec.HEADER_ID := FND_API.G_MISS_NUM;
781: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_LINE THEN
782: p_x_Line_PAYMENT_rec.LINE_ID := FND_API.G_MISS_NUM;
783: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PAYMENT_AMOUNT THEN
784: p_x_Line_PAYMENT_rec.PAYMENT_AMOUNT := FND_API.G_MISS_NUM;

Line 782: p_x_Line_PAYMENT_rec.LINE_ID := FND_API.G_MISS_NUM;

778: p_x_Line_PAYMENT_rec.PAYMENT_NUMBER := FND_API.G_MISS_NUM;
779: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_HEADER THEN
780: p_x_Line_PAYMENT_rec.HEADER_ID := FND_API.G_MISS_NUM;
781: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_LINE THEN
782: p_x_Line_PAYMENT_rec.LINE_ID := FND_API.G_MISS_NUM;
783: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PAYMENT_AMOUNT THEN
784: p_x_Line_PAYMENT_rec.PAYMENT_AMOUNT := FND_API.G_MISS_NUM;
785: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PAYMENT_COLLECTION_EVENT THEN
786: p_x_Line_PAYMENT_rec.PAYMENT_COLLECTION_EVENT := FND_API.G_MISS_CHAR;

Line 784: p_x_Line_PAYMENT_rec.PAYMENT_AMOUNT := FND_API.G_MISS_NUM;

780: p_x_Line_PAYMENT_rec.HEADER_ID := FND_API.G_MISS_NUM;
781: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_LINE THEN
782: p_x_Line_PAYMENT_rec.LINE_ID := FND_API.G_MISS_NUM;
783: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PAYMENT_AMOUNT THEN
784: p_x_Line_PAYMENT_rec.PAYMENT_AMOUNT := FND_API.G_MISS_NUM;
785: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PAYMENT_COLLECTION_EVENT THEN
786: p_x_Line_PAYMENT_rec.PAYMENT_COLLECTION_EVENT := FND_API.G_MISS_CHAR;
787: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PAYMENT_TRX_ID THEN
788: p_x_Line_PAYMENT_rec.PAYMENT_TRX_ID := FND_API.G_MISS_NUM;

Line 786: p_x_Line_PAYMENT_rec.PAYMENT_COLLECTION_EVENT := FND_API.G_MISS_CHAR;

782: p_x_Line_PAYMENT_rec.LINE_ID := FND_API.G_MISS_NUM;
783: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PAYMENT_AMOUNT THEN
784: p_x_Line_PAYMENT_rec.PAYMENT_AMOUNT := FND_API.G_MISS_NUM;
785: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PAYMENT_COLLECTION_EVENT THEN
786: p_x_Line_PAYMENT_rec.PAYMENT_COLLECTION_EVENT := FND_API.G_MISS_CHAR;
787: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PAYMENT_TRX_ID THEN
788: p_x_Line_PAYMENT_rec.PAYMENT_TRX_ID := FND_API.G_MISS_NUM;
789: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PAYMENT_TYPE_CODE THEN
790: p_x_Line_PAYMENT_rec.PAYMENT_TYPE_CODE := FND_API.G_MISS_CHAR;

Line 788: p_x_Line_PAYMENT_rec.PAYMENT_TRX_ID := FND_API.G_MISS_NUM;

784: p_x_Line_PAYMENT_rec.PAYMENT_AMOUNT := FND_API.G_MISS_NUM;
785: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PAYMENT_COLLECTION_EVENT THEN
786: p_x_Line_PAYMENT_rec.PAYMENT_COLLECTION_EVENT := FND_API.G_MISS_CHAR;
787: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PAYMENT_TRX_ID THEN
788: p_x_Line_PAYMENT_rec.PAYMENT_TRX_ID := FND_API.G_MISS_NUM;
789: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PAYMENT_TYPE_CODE THEN
790: p_x_Line_PAYMENT_rec.PAYMENT_TYPE_CODE := FND_API.G_MISS_CHAR;
791: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PAYMENT_SET_ID THEN
792: p_x_Line_PAYMENT_rec.PAYMENT_SET_ID := FND_API.G_MISS_NUM;

Line 790: p_x_Line_PAYMENT_rec.PAYMENT_TYPE_CODE := FND_API.G_MISS_CHAR;

786: p_x_Line_PAYMENT_rec.PAYMENT_COLLECTION_EVENT := FND_API.G_MISS_CHAR;
787: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PAYMENT_TRX_ID THEN
788: p_x_Line_PAYMENT_rec.PAYMENT_TRX_ID := FND_API.G_MISS_NUM;
789: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PAYMENT_TYPE_CODE THEN
790: p_x_Line_PAYMENT_rec.PAYMENT_TYPE_CODE := FND_API.G_MISS_CHAR;
791: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PAYMENT_SET_ID THEN
792: p_x_Line_PAYMENT_rec.PAYMENT_SET_ID := FND_API.G_MISS_NUM;
793: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PREPAID_AMOUNT THEN
794: p_x_Line_PAYMENT_rec.PREPAID_AMOUNT := FND_API.G_MISS_NUM;

Line 792: p_x_Line_PAYMENT_rec.PAYMENT_SET_ID := FND_API.G_MISS_NUM;

788: p_x_Line_PAYMENT_rec.PAYMENT_TRX_ID := FND_API.G_MISS_NUM;
789: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PAYMENT_TYPE_CODE THEN
790: p_x_Line_PAYMENT_rec.PAYMENT_TYPE_CODE := FND_API.G_MISS_CHAR;
791: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PAYMENT_SET_ID THEN
792: p_x_Line_PAYMENT_rec.PAYMENT_SET_ID := FND_API.G_MISS_NUM;
793: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PREPAID_AMOUNT THEN
794: p_x_Line_PAYMENT_rec.PREPAID_AMOUNT := FND_API.G_MISS_NUM;
795: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PROGRAM_APPLICATION_ID THEN
796: p_x_Line_PAYMENT_rec.PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;

Line 794: p_x_Line_PAYMENT_rec.PREPAID_AMOUNT := FND_API.G_MISS_NUM;

790: p_x_Line_PAYMENT_rec.PAYMENT_TYPE_CODE := FND_API.G_MISS_CHAR;
791: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PAYMENT_SET_ID THEN
792: p_x_Line_PAYMENT_rec.PAYMENT_SET_ID := FND_API.G_MISS_NUM;
793: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PREPAID_AMOUNT THEN
794: p_x_Line_PAYMENT_rec.PREPAID_AMOUNT := FND_API.G_MISS_NUM;
795: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PROGRAM_APPLICATION_ID THEN
796: p_x_Line_PAYMENT_rec.PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;
797: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PROGRAM_ID THEN
798: p_x_Line_PAYMENT_rec.PROGRAM_ID := FND_API.G_MISS_NUM;

Line 796: p_x_Line_PAYMENT_rec.PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;

792: p_x_Line_PAYMENT_rec.PAYMENT_SET_ID := FND_API.G_MISS_NUM;
793: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PREPAID_AMOUNT THEN
794: p_x_Line_PAYMENT_rec.PREPAID_AMOUNT := FND_API.G_MISS_NUM;
795: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PROGRAM_APPLICATION_ID THEN
796: p_x_Line_PAYMENT_rec.PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;
797: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PROGRAM_ID THEN
798: p_x_Line_PAYMENT_rec.PROGRAM_ID := FND_API.G_MISS_NUM;
799: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PROGRAM_UPDATE_DATE THEN
800: p_x_Line_PAYMENT_rec.PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;

Line 798: p_x_Line_PAYMENT_rec.PROGRAM_ID := FND_API.G_MISS_NUM;

794: p_x_Line_PAYMENT_rec.PREPAID_AMOUNT := FND_API.G_MISS_NUM;
795: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PROGRAM_APPLICATION_ID THEN
796: p_x_Line_PAYMENT_rec.PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;
797: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PROGRAM_ID THEN
798: p_x_Line_PAYMENT_rec.PROGRAM_ID := FND_API.G_MISS_NUM;
799: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PROGRAM_UPDATE_DATE THEN
800: p_x_Line_PAYMENT_rec.PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
801: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_RECEIPT_METHOD_ID THEN
802: p_x_Line_PAYMENT_rec.RECEIPT_METHOD_ID := FND_API.G_MISS_NUM;

Line 800: p_x_Line_PAYMENT_rec.PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;

796: p_x_Line_PAYMENT_rec.PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;
797: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PROGRAM_ID THEN
798: p_x_Line_PAYMENT_rec.PROGRAM_ID := FND_API.G_MISS_NUM;
799: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PROGRAM_UPDATE_DATE THEN
800: p_x_Line_PAYMENT_rec.PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
801: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_RECEIPT_METHOD_ID THEN
802: p_x_Line_PAYMENT_rec.RECEIPT_METHOD_ID := FND_API.G_MISS_NUM;
803: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_REQUEST_ID THEN
804: p_x_Line_PAYMENT_rec.REQUEST_ID := FND_API.G_MISS_NUM;

Line 802: p_x_Line_PAYMENT_rec.RECEIPT_METHOD_ID := FND_API.G_MISS_NUM;

798: p_x_Line_PAYMENT_rec.PROGRAM_ID := FND_API.G_MISS_NUM;
799: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_PROGRAM_UPDATE_DATE THEN
800: p_x_Line_PAYMENT_rec.PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
801: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_RECEIPT_METHOD_ID THEN
802: p_x_Line_PAYMENT_rec.RECEIPT_METHOD_ID := FND_API.G_MISS_NUM;
803: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_REQUEST_ID THEN
804: p_x_Line_PAYMENT_rec.REQUEST_ID := FND_API.G_MISS_NUM;
805: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_TANGIBLE_ID THEN
806: p_x_Line_PAYMENT_rec.TANGIBLE_ID := FND_API.G_MISS_CHAR;

Line 804: p_x_Line_PAYMENT_rec.REQUEST_ID := FND_API.G_MISS_NUM;

800: p_x_Line_PAYMENT_rec.PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
801: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_RECEIPT_METHOD_ID THEN
802: p_x_Line_PAYMENT_rec.RECEIPT_METHOD_ID := FND_API.G_MISS_NUM;
803: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_REQUEST_ID THEN
804: p_x_Line_PAYMENT_rec.REQUEST_ID := FND_API.G_MISS_NUM;
805: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_TANGIBLE_ID THEN
806: p_x_Line_PAYMENT_rec.TANGIBLE_ID := FND_API.G_MISS_CHAR;
807: END IF;
808: END LOOP;

Line 806: p_x_Line_PAYMENT_rec.TANGIBLE_ID := FND_API.G_MISS_CHAR;

802: p_x_Line_PAYMENT_rec.RECEIPT_METHOD_ID := FND_API.G_MISS_NUM;
803: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_REQUEST_ID THEN
804: p_x_Line_PAYMENT_rec.REQUEST_ID := FND_API.G_MISS_NUM;
805: ELSIF l_dep_attr_tbl(I) = OE_LINE_PAYMENT_UTIL.G_TANGIBLE_ID THEN
806: p_x_Line_PAYMENT_rec.TANGIBLE_ID := FND_API.G_MISS_CHAR;
807: END IF;
808: END LOOP;
809: END IF;
810: END Clear_Dependent_Attr;

Line 813: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM

809: END IF;
810: END Clear_Dependent_Attr;
811:
812: PROCEDURE Clear_Dependent_Attr
813: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
814: , p_x_Line_Payment_rec IN OUT NOCOPY OE_Order_PUB.Line_Payment_Rec_Type
815: , p_old_Line_Payment_rec IN OE_Order_PUB.Line_Payment_Rec_Type :=
816: OE_Order_PUB.G_MISS_LINE_PAYMENT_REC
817: )

Line 872: x_return_status := FND_API.G_RET_STS_SUCCESS;

868: l_hold_release_id OE_ORDER_HOLDS.HOLD_RELEASE_ID%TYPE;
869: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
870:
871: BEGIN
872: x_return_status := FND_API.G_RET_STS_SUCCESS;
873:
874: IF l_debug_level > 0 THEN
875: oe_debug_pub.add( 'Entering Delete_Line_PaymentType_Hold' , 3 ) ;
876: END IF;

Line 905: WHEN FND_API.G_EXC_ERROR THEN

901: oe_debug_pub.add( 'Exiting Delete_Line_PaymentType_Hold' , 3 ) ;
902: END IF;
903:
904: EXCEPTION
905: WHEN FND_API.G_EXC_ERROR THEN
906: IF (line_paytype_hold%isopen) THEN
907: CLOSE line_paytype_hold;
908: END IF;
909:

Line 910: x_return_status := FND_API.G_RET_STS_ERROR;

906: IF (line_paytype_hold%isopen) THEN
907: CLOSE line_paytype_hold;
908: END IF;
909:
910: x_return_status := FND_API.G_RET_STS_ERROR;
911: FND_MSG_PUB.Count_And_Get
912: ( p_count => x_msg_count
913: , p_data => x_msg_data
914: );

Line 919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

915: WHEN OTHERS THEN
916: IF (line_paytype_hold%isopen) THEN
917: CLOSE line_paytype_hold;
918: END IF;
919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
920: FND_MSG_PUB.Count_And_Get
921: ( p_count => x_msg_count
922: , p_data => x_msg_data
923: );

Line 1193: if ( OE_Order_Cache.g_header_rec.header_id <> FND_API.G_MISS_NUM

1189:
1190: --bug3625027 start
1191: BEGIN
1192: -- use order_header cache instead of sql : bug 4200055
1193: if ( OE_Order_Cache.g_header_rec.header_id <> FND_API.G_MISS_NUM
1194: and OE_Order_Cache.g_header_rec.header_id IS NOT NULL
1195: and OE_Order_Cache.g_header_rec.header_id = p_x_Line_Payment_rec.header_id ) then
1196: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
1197: else

Line 1389: IF p_x_Line_Payment_rec.attribute1 = FND_API.G_MISS_CHAR THEN

1385: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1386: --
1387: BEGIN
1388:
1389: IF p_x_Line_Payment_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1390: p_x_Line_Payment_rec.attribute1 := p_old_Line_Payment_rec.attribute1;
1391: END IF;
1392:
1393: IF p_x_Line_Payment_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 1393: IF p_x_Line_Payment_rec.attribute2 = FND_API.G_MISS_CHAR THEN

1389: IF p_x_Line_Payment_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1390: p_x_Line_Payment_rec.attribute1 := p_old_Line_Payment_rec.attribute1;
1391: END IF;
1392:
1393: IF p_x_Line_Payment_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1394: p_x_Line_Payment_rec.attribute2 := p_old_Line_Payment_rec.attribute2;
1395: END IF;
1396:
1397: IF p_x_Line_Payment_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 1397: IF p_x_Line_Payment_rec.attribute3 = FND_API.G_MISS_CHAR THEN

1393: IF p_x_Line_Payment_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1394: p_x_Line_Payment_rec.attribute2 := p_old_Line_Payment_rec.attribute2;
1395: END IF;
1396:
1397: IF p_x_Line_Payment_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1398: p_x_Line_Payment_rec.attribute3 := p_old_Line_Payment_rec.attribute3;
1399: END IF;
1400:
1401: IF p_x_Line_Payment_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 1401: IF p_x_Line_Payment_rec.attribute4 = FND_API.G_MISS_CHAR THEN

1397: IF p_x_Line_Payment_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1398: p_x_Line_Payment_rec.attribute3 := p_old_Line_Payment_rec.attribute3;
1399: END IF;
1400:
1401: IF p_x_Line_Payment_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1402: p_x_Line_Payment_rec.attribute4 := p_old_Line_Payment_rec.attribute4;
1403: END IF;
1404:
1405: IF p_x_Line_Payment_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 1405: IF p_x_Line_Payment_rec.attribute5 = FND_API.G_MISS_CHAR THEN

1401: IF p_x_Line_Payment_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1402: p_x_Line_Payment_rec.attribute4 := p_old_Line_Payment_rec.attribute4;
1403: END IF;
1404:
1405: IF p_x_Line_Payment_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1406: p_x_Line_Payment_rec.attribute5 := p_old_Line_Payment_rec.attribute5;
1407: END IF;
1408:
1409: IF p_x_Line_Payment_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 1409: IF p_x_Line_Payment_rec.attribute6 = FND_API.G_MISS_CHAR THEN

1405: IF p_x_Line_Payment_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1406: p_x_Line_Payment_rec.attribute5 := p_old_Line_Payment_rec.attribute5;
1407: END IF;
1408:
1409: IF p_x_Line_Payment_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1410: p_x_Line_Payment_rec.attribute6 := p_old_Line_Payment_rec.attribute6;
1411: END IF;
1412:
1413: IF p_x_Line_Payment_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 1413: IF p_x_Line_Payment_rec.attribute7 = FND_API.G_MISS_CHAR THEN

1409: IF p_x_Line_Payment_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1410: p_x_Line_Payment_rec.attribute6 := p_old_Line_Payment_rec.attribute6;
1411: END IF;
1412:
1413: IF p_x_Line_Payment_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1414: p_x_Line_Payment_rec.attribute7 := p_old_Line_Payment_rec.attribute7;
1415: END IF;
1416:
1417: IF p_x_Line_Payment_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 1417: IF p_x_Line_Payment_rec.attribute8 = FND_API.G_MISS_CHAR THEN

1413: IF p_x_Line_Payment_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1414: p_x_Line_Payment_rec.attribute7 := p_old_Line_Payment_rec.attribute7;
1415: END IF;
1416:
1417: IF p_x_Line_Payment_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1418: p_x_Line_Payment_rec.attribute8 := p_old_Line_Payment_rec.attribute8;
1419: END IF;
1420:
1421: IF p_x_Line_Payment_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 1421: IF p_x_Line_Payment_rec.attribute9 = FND_API.G_MISS_CHAR THEN

1417: IF p_x_Line_Payment_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1418: p_x_Line_Payment_rec.attribute8 := p_old_Line_Payment_rec.attribute8;
1419: END IF;
1420:
1421: IF p_x_Line_Payment_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1422: p_x_Line_Payment_rec.attribute9 := p_old_Line_Payment_rec.attribute9;
1423: END IF;
1424:
1425: IF p_x_Line_Payment_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 1425: IF p_x_Line_Payment_rec.attribute10 = FND_API.G_MISS_CHAR THEN

1421: IF p_x_Line_Payment_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1422: p_x_Line_Payment_rec.attribute9 := p_old_Line_Payment_rec.attribute9;
1423: END IF;
1424:
1425: IF p_x_Line_Payment_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1426: p_x_Line_Payment_rec.attribute10 := p_old_Line_Payment_rec.attribute10;
1427: END IF;
1428:
1429: IF p_x_Line_Payment_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 1429: IF p_x_Line_Payment_rec.attribute11 = FND_API.G_MISS_CHAR THEN

1425: IF p_x_Line_Payment_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1426: p_x_Line_Payment_rec.attribute10 := p_old_Line_Payment_rec.attribute10;
1427: END IF;
1428:
1429: IF p_x_Line_Payment_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1430: p_x_Line_Payment_rec.attribute11 := p_old_Line_Payment_rec.attribute11;
1431: END IF;
1432:
1433: IF p_x_Line_Payment_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 1433: IF p_x_Line_Payment_rec.attribute12 = FND_API.G_MISS_CHAR THEN

1429: IF p_x_Line_Payment_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1430: p_x_Line_Payment_rec.attribute11 := p_old_Line_Payment_rec.attribute11;
1431: END IF;
1432:
1433: IF p_x_Line_Payment_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1434: p_x_Line_Payment_rec.attribute12 := p_old_Line_Payment_rec.attribute12;
1435: END IF;
1436:
1437: IF p_x_Line_Payment_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 1437: IF p_x_Line_Payment_rec.attribute13 = FND_API.G_MISS_CHAR THEN

1433: IF p_x_Line_Payment_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1434: p_x_Line_Payment_rec.attribute12 := p_old_Line_Payment_rec.attribute12;
1435: END IF;
1436:
1437: IF p_x_Line_Payment_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1438: p_x_Line_Payment_rec.attribute13 := p_old_Line_Payment_rec.attribute13;
1439: END IF;
1440:
1441: IF p_x_Line_Payment_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 1441: IF p_x_Line_Payment_rec.attribute14 = FND_API.G_MISS_CHAR THEN

1437: IF p_x_Line_Payment_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1438: p_x_Line_Payment_rec.attribute13 := p_old_Line_Payment_rec.attribute13;
1439: END IF;
1440:
1441: IF p_x_Line_Payment_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1442: p_x_Line_Payment_rec.attribute14 := p_old_Line_Payment_rec.attribute14;
1443: END IF;
1444:
1445: IF p_x_Line_Payment_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 1445: IF p_x_Line_Payment_rec.attribute15 = FND_API.G_MISS_CHAR THEN

1441: IF p_x_Line_Payment_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1442: p_x_Line_Payment_rec.attribute14 := p_old_Line_Payment_rec.attribute14;
1443: END IF;
1444:
1445: IF p_x_Line_Payment_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1446: p_x_Line_Payment_rec.attribute15 := p_old_Line_Payment_rec.attribute15;
1447: END IF;
1448:
1449: IF p_x_Line_Payment_rec.context = FND_API.G_MISS_CHAR THEN

Line 1449: IF p_x_Line_Payment_rec.context = FND_API.G_MISS_CHAR THEN

1445: IF p_x_Line_Payment_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1446: p_x_Line_Payment_rec.attribute15 := p_old_Line_Payment_rec.attribute15;
1447: END IF;
1448:
1449: IF p_x_Line_Payment_rec.context = FND_API.G_MISS_CHAR THEN
1450: p_x_Line_Payment_rec.context := p_old_Line_Payment_rec.context;
1451: END IF;
1452:
1453: IF p_x_Line_Payment_rec.created_by = FND_API.G_MISS_NUM THEN

Line 1453: IF p_x_Line_Payment_rec.created_by = FND_API.G_MISS_NUM THEN

1449: IF p_x_Line_Payment_rec.context = FND_API.G_MISS_CHAR THEN
1450: p_x_Line_Payment_rec.context := p_old_Line_Payment_rec.context;
1451: END IF;
1452:
1453: IF p_x_Line_Payment_rec.created_by = FND_API.G_MISS_NUM THEN
1454: p_x_Line_Payment_rec.created_by := p_old_Line_Payment_rec.created_by;
1455: END IF;
1456:
1457: IF p_x_Line_Payment_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 1457: IF p_x_Line_Payment_rec.creation_date = FND_API.G_MISS_DATE THEN

1453: IF p_x_Line_Payment_rec.created_by = FND_API.G_MISS_NUM THEN
1454: p_x_Line_Payment_rec.created_by := p_old_Line_Payment_rec.created_by;
1455: END IF;
1456:
1457: IF p_x_Line_Payment_rec.creation_date = FND_API.G_MISS_DATE THEN
1458: p_x_Line_Payment_rec.creation_date := p_old_Line_Payment_rec.creation_date;
1459: END IF;
1460:
1461: IF p_x_Line_Payment_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 1461: IF p_x_Line_Payment_rec.last_updated_by = FND_API.G_MISS_NUM THEN

1457: IF p_x_Line_Payment_rec.creation_date = FND_API.G_MISS_DATE THEN
1458: p_x_Line_Payment_rec.creation_date := p_old_Line_Payment_rec.creation_date;
1459: END IF;
1460:
1461: IF p_x_Line_Payment_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1462: p_x_Line_Payment_rec.last_updated_by := p_old_Line_Payment_rec.last_updated_by;
1463: END IF;
1464:
1465: IF p_x_Line_Payment_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 1465: IF p_x_Line_Payment_rec.last_update_date = FND_API.G_MISS_DATE THEN

1461: IF p_x_Line_Payment_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1462: p_x_Line_Payment_rec.last_updated_by := p_old_Line_Payment_rec.last_updated_by;
1463: END IF;
1464:
1465: IF p_x_Line_Payment_rec.last_update_date = FND_API.G_MISS_DATE THEN
1466: p_x_Line_Payment_rec.last_update_date := p_old_Line_Payment_rec.last_update_date;
1467: END IF;
1468:
1469: IF p_x_Line_Payment_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 1469: IF p_x_Line_Payment_rec.last_update_login = FND_API.G_MISS_NUM THEN

1465: IF p_x_Line_Payment_rec.last_update_date = FND_API.G_MISS_DATE THEN
1466: p_x_Line_Payment_rec.last_update_date := p_old_Line_Payment_rec.last_update_date;
1467: END IF;
1468:
1469: IF p_x_Line_Payment_rec.last_update_login = FND_API.G_MISS_NUM THEN
1470: p_x_Line_Payment_rec.last_update_login := p_old_Line_Payment_rec.last_update_login;
1471: END IF;
1472:
1473: IF p_x_Line_Payment_rec.check_number = FND_API.G_MISS_CHAR THEN

Line 1473: IF p_x_Line_Payment_rec.check_number = FND_API.G_MISS_CHAR THEN

1469: IF p_x_Line_Payment_rec.last_update_login = FND_API.G_MISS_NUM THEN
1470: p_x_Line_Payment_rec.last_update_login := p_old_Line_Payment_rec.last_update_login;
1471: END IF;
1472:
1473: IF p_x_Line_Payment_rec.check_number = FND_API.G_MISS_CHAR THEN
1474: p_x_Line_Payment_rec.check_number := p_old_Line_Payment_rec.check_number;
1475: END IF;
1476:
1477: IF p_x_Line_Payment_rec.credit_card_approval_code = FND_API.G_MISS_CHAR THEN

Line 1477: IF p_x_Line_Payment_rec.credit_card_approval_code = FND_API.G_MISS_CHAR THEN

1473: IF p_x_Line_Payment_rec.check_number = FND_API.G_MISS_CHAR THEN
1474: p_x_Line_Payment_rec.check_number := p_old_Line_Payment_rec.check_number;
1475: END IF;
1476:
1477: IF p_x_Line_Payment_rec.credit_card_approval_code = FND_API.G_MISS_CHAR THEN
1478: p_x_Line_Payment_rec.credit_card_approval_code := p_old_Line_Payment_rec.credit_card_approval_code;
1479: END IF;
1480:
1481: IF p_x_Line_Payment_rec.credit_card_approval_date = FND_API.G_MISS_DATE THEN

Line 1481: IF p_x_Line_Payment_rec.credit_card_approval_date = FND_API.G_MISS_DATE THEN

1477: IF p_x_Line_Payment_rec.credit_card_approval_code = FND_API.G_MISS_CHAR THEN
1478: p_x_Line_Payment_rec.credit_card_approval_code := p_old_Line_Payment_rec.credit_card_approval_code;
1479: END IF;
1480:
1481: IF p_x_Line_Payment_rec.credit_card_approval_date = FND_API.G_MISS_DATE THEN
1482: p_x_Line_Payment_rec.credit_card_approval_date := p_old_Line_Payment_rec.credit_card_approval_date;
1483: END IF;
1484:
1485: IF p_x_Line_Payment_rec.credit_card_code = FND_API.G_MISS_CHAR THEN

Line 1485: IF p_x_Line_Payment_rec.credit_card_code = FND_API.G_MISS_CHAR THEN

1481: IF p_x_Line_Payment_rec.credit_card_approval_date = FND_API.G_MISS_DATE THEN
1482: p_x_Line_Payment_rec.credit_card_approval_date := p_old_Line_Payment_rec.credit_card_approval_date;
1483: END IF;
1484:
1485: IF p_x_Line_Payment_rec.credit_card_code = FND_API.G_MISS_CHAR THEN
1486: p_x_Line_Payment_rec.credit_card_code := p_old_Line_Payment_rec.credit_card_code;
1487: END IF;
1488:
1489: IF p_x_Line_Payment_rec.credit_card_expiration_date = FND_API.G_MISS_DATE THEN

Line 1489: IF p_x_Line_Payment_rec.credit_card_expiration_date = FND_API.G_MISS_DATE THEN

1485: IF p_x_Line_Payment_rec.credit_card_code = FND_API.G_MISS_CHAR THEN
1486: p_x_Line_Payment_rec.credit_card_code := p_old_Line_Payment_rec.credit_card_code;
1487: END IF;
1488:
1489: IF p_x_Line_Payment_rec.credit_card_expiration_date = FND_API.G_MISS_DATE THEN
1490: p_x_Line_Payment_rec.credit_card_expiration_date := p_old_Line_Payment_rec.credit_card_expiration_date;
1491: END IF;
1492:
1493: IF p_x_Line_Payment_rec.credit_card_holder_name = FND_API.G_MISS_CHAR THEN

Line 1493: IF p_x_Line_Payment_rec.credit_card_holder_name = FND_API.G_MISS_CHAR THEN

1489: IF p_x_Line_Payment_rec.credit_card_expiration_date = FND_API.G_MISS_DATE THEN
1490: p_x_Line_Payment_rec.credit_card_expiration_date := p_old_Line_Payment_rec.credit_card_expiration_date;
1491: END IF;
1492:
1493: IF p_x_Line_Payment_rec.credit_card_holder_name = FND_API.G_MISS_CHAR THEN
1494: p_x_Line_Payment_rec.credit_card_holder_name := p_old_Line_Payment_rec.credit_card_holder_name;
1495: END IF;
1496:
1497: IF p_x_Line_Payment_rec.credit_card_number = FND_API.G_MISS_CHAR THEN

Line 1497: IF p_x_Line_Payment_rec.credit_card_number = FND_API.G_MISS_CHAR THEN

1493: IF p_x_Line_Payment_rec.credit_card_holder_name = FND_API.G_MISS_CHAR THEN
1494: p_x_Line_Payment_rec.credit_card_holder_name := p_old_Line_Payment_rec.credit_card_holder_name;
1495: END IF;
1496:
1497: IF p_x_Line_Payment_rec.credit_card_number = FND_API.G_MISS_CHAR THEN
1498: p_x_Line_Payment_rec.credit_card_number := p_old_Line_Payment_rec.credit_card_number;
1499: END IF;
1500:
1501: IF p_x_Line_Payment_rec.payment_level_code = FND_API.G_MISS_CHAR THEN

Line 1501: IF p_x_Line_Payment_rec.payment_level_code = FND_API.G_MISS_CHAR THEN

1497: IF p_x_Line_Payment_rec.credit_card_number = FND_API.G_MISS_CHAR THEN
1498: p_x_Line_Payment_rec.credit_card_number := p_old_Line_Payment_rec.credit_card_number;
1499: END IF;
1500:
1501: IF p_x_Line_Payment_rec.payment_level_code = FND_API.G_MISS_CHAR THEN
1502: p_x_Line_Payment_rec.payment_level_code := p_old_Line_Payment_rec.payment_level_code;
1503: END IF;
1504:
1505: IF p_x_Line_Payment_rec.commitment_applied_amount = FND_API.G_MISS_NUM THEN

Line 1505: IF p_x_Line_Payment_rec.commitment_applied_amount = FND_API.G_MISS_NUM THEN

1501: IF p_x_Line_Payment_rec.payment_level_code = FND_API.G_MISS_CHAR THEN
1502: p_x_Line_Payment_rec.payment_level_code := p_old_Line_Payment_rec.payment_level_code;
1503: END IF;
1504:
1505: IF p_x_Line_Payment_rec.commitment_applied_amount = FND_API.G_MISS_NUM THEN
1506: p_x_Line_Payment_rec.commitment_applied_amount := p_old_Line_Payment_rec.commitment_applied_amount;
1507: END IF;
1508:
1509: IF p_x_Line_Payment_rec.commitment_interfaced_amount = FND_API.G_MISS_NUM THEN

Line 1509: IF p_x_Line_Payment_rec.commitment_interfaced_amount = FND_API.G_MISS_NUM THEN

1505: IF p_x_Line_Payment_rec.commitment_applied_amount = FND_API.G_MISS_NUM THEN
1506: p_x_Line_Payment_rec.commitment_applied_amount := p_old_Line_Payment_rec.commitment_applied_amount;
1507: END IF;
1508:
1509: IF p_x_Line_Payment_rec.commitment_interfaced_amount = FND_API.G_MISS_NUM THEN
1510: p_x_Line_Payment_rec.commitment_interfaced_amount := p_old_Line_Payment_rec.commitment_interfaced_amount;
1511: END IF;
1512:
1513: IF p_x_Line_Payment_rec.payment_number = FND_API.G_MISS_NUM THEN

Line 1513: IF p_x_Line_Payment_rec.payment_number = FND_API.G_MISS_NUM THEN

1509: IF p_x_Line_Payment_rec.commitment_interfaced_amount = FND_API.G_MISS_NUM THEN
1510: p_x_Line_Payment_rec.commitment_interfaced_amount := p_old_Line_Payment_rec.commitment_interfaced_amount;
1511: END IF;
1512:
1513: IF p_x_Line_Payment_rec.payment_number = FND_API.G_MISS_NUM THEN
1514: p_x_Line_Payment_rec.payment_number := p_old_Line_Payment_rec.payment_number;
1515: END IF;
1516:
1517: IF p_x_Line_Payment_rec.header_id = FND_API.G_MISS_NUM THEN

Line 1517: IF p_x_Line_Payment_rec.header_id = FND_API.G_MISS_NUM THEN

1513: IF p_x_Line_Payment_rec.payment_number = FND_API.G_MISS_NUM THEN
1514: p_x_Line_Payment_rec.payment_number := p_old_Line_Payment_rec.payment_number;
1515: END IF;
1516:
1517: IF p_x_Line_Payment_rec.header_id = FND_API.G_MISS_NUM THEN
1518: p_x_Line_Payment_rec.header_id := p_old_Line_Payment_rec.header_id;
1519: END IF;
1520:
1521: IF p_x_Line_Payment_rec.line_id = FND_API.G_MISS_NUM THEN

Line 1521: IF p_x_Line_Payment_rec.line_id = FND_API.G_MISS_NUM THEN

1517: IF p_x_Line_Payment_rec.header_id = FND_API.G_MISS_NUM THEN
1518: p_x_Line_Payment_rec.header_id := p_old_Line_Payment_rec.header_id;
1519: END IF;
1520:
1521: IF p_x_Line_Payment_rec.line_id = FND_API.G_MISS_NUM THEN
1522: p_x_Line_Payment_rec.line_id := p_old_Line_Payment_rec.line_id;
1523: END IF;
1524:
1525: IF p_x_Line_Payment_rec.payment_amount = FND_API.G_MISS_NUM THEN

Line 1525: IF p_x_Line_Payment_rec.payment_amount = FND_API.G_MISS_NUM THEN

1521: IF p_x_Line_Payment_rec.line_id = FND_API.G_MISS_NUM THEN
1522: p_x_Line_Payment_rec.line_id := p_old_Line_Payment_rec.line_id;
1523: END IF;
1524:
1525: IF p_x_Line_Payment_rec.payment_amount = FND_API.G_MISS_NUM THEN
1526: p_x_Line_Payment_rec.payment_amount := p_old_Line_Payment_rec.payment_amount;
1527: END IF;
1528:
1529: IF p_x_Line_Payment_rec.payment_collection_event = FND_API.G_MISS_CHAR THEN

Line 1529: IF p_x_Line_Payment_rec.payment_collection_event = FND_API.G_MISS_CHAR THEN

1525: IF p_x_Line_Payment_rec.payment_amount = FND_API.G_MISS_NUM THEN
1526: p_x_Line_Payment_rec.payment_amount := p_old_Line_Payment_rec.payment_amount;
1527: END IF;
1528:
1529: IF p_x_Line_Payment_rec.payment_collection_event = FND_API.G_MISS_CHAR THEN
1530: p_x_Line_Payment_rec.payment_collection_event := p_old_Line_Payment_rec.payment_collection_event;
1531: END IF;
1532:
1533: IF p_x_Line_Payment_rec.defer_payment_processing_flag = FND_API.G_MISS_CHAR THEN

Line 1533: IF p_x_Line_Payment_rec.defer_payment_processing_flag = FND_API.G_MISS_CHAR THEN

1529: IF p_x_Line_Payment_rec.payment_collection_event = FND_API.G_MISS_CHAR THEN
1530: p_x_Line_Payment_rec.payment_collection_event := p_old_Line_Payment_rec.payment_collection_event;
1531: END IF;
1532:
1533: IF p_x_Line_Payment_rec.defer_payment_processing_flag = FND_API.G_MISS_CHAR THEN
1534: p_x_Line_Payment_rec.defer_payment_processing_flag := p_old_Line_Payment_rec.defer_payment_processing_flag;
1535: END IF;
1536:
1537: IF p_x_Line_Payment_rec.payment_trx_id = FND_API.G_MISS_NUM THEN

Line 1537: IF p_x_Line_Payment_rec.payment_trx_id = FND_API.G_MISS_NUM THEN

1533: IF p_x_Line_Payment_rec.defer_payment_processing_flag = FND_API.G_MISS_CHAR THEN
1534: p_x_Line_Payment_rec.defer_payment_processing_flag := p_old_Line_Payment_rec.defer_payment_processing_flag;
1535: END IF;
1536:
1537: IF p_x_Line_Payment_rec.payment_trx_id = FND_API.G_MISS_NUM THEN
1538: p_x_Line_Payment_rec.payment_trx_id := p_old_Line_Payment_rec.payment_trx_id;
1539: END IF;
1540:
1541: IF p_x_Line_Payment_rec.payment_type_code = FND_API.G_MISS_CHAR THEN

Line 1541: IF p_x_Line_Payment_rec.payment_type_code = FND_API.G_MISS_CHAR THEN

1537: IF p_x_Line_Payment_rec.payment_trx_id = FND_API.G_MISS_NUM THEN
1538: p_x_Line_Payment_rec.payment_trx_id := p_old_Line_Payment_rec.payment_trx_id;
1539: END IF;
1540:
1541: IF p_x_Line_Payment_rec.payment_type_code = FND_API.G_MISS_CHAR THEN
1542: p_x_Line_Payment_rec.payment_type_code := p_old_Line_Payment_rec.payment_type_code;
1543: END IF;
1544:
1545: IF p_x_Line_Payment_rec.payment_set_id = FND_API.G_MISS_NUM THEN

Line 1545: IF p_x_Line_Payment_rec.payment_set_id = FND_API.G_MISS_NUM THEN

1541: IF p_x_Line_Payment_rec.payment_type_code = FND_API.G_MISS_CHAR THEN
1542: p_x_Line_Payment_rec.payment_type_code := p_old_Line_Payment_rec.payment_type_code;
1543: END IF;
1544:
1545: IF p_x_Line_Payment_rec.payment_set_id = FND_API.G_MISS_NUM THEN
1546: p_x_Line_Payment_rec.payment_set_id := p_old_Line_Payment_rec.payment_set_id;
1547: END IF;
1548:
1549: IF p_x_Line_Payment_rec.prepaid_amount = FND_API.G_MISS_NUM THEN

Line 1549: IF p_x_Line_Payment_rec.prepaid_amount = FND_API.G_MISS_NUM THEN

1545: IF p_x_Line_Payment_rec.payment_set_id = FND_API.G_MISS_NUM THEN
1546: p_x_Line_Payment_rec.payment_set_id := p_old_Line_Payment_rec.payment_set_id;
1547: END IF;
1548:
1549: IF p_x_Line_Payment_rec.prepaid_amount = FND_API.G_MISS_NUM THEN
1550: p_x_Line_Payment_rec.prepaid_amount := p_old_Line_Payment_rec.prepaid_amount;
1551: END IF;
1552:
1553: IF p_x_Line_Payment_rec.program_application_id = FND_API.G_MISS_NUM THEN

Line 1553: IF p_x_Line_Payment_rec.program_application_id = FND_API.G_MISS_NUM THEN

1549: IF p_x_Line_Payment_rec.prepaid_amount = FND_API.G_MISS_NUM THEN
1550: p_x_Line_Payment_rec.prepaid_amount := p_old_Line_Payment_rec.prepaid_amount;
1551: END IF;
1552:
1553: IF p_x_Line_Payment_rec.program_application_id = FND_API.G_MISS_NUM THEN
1554: p_x_Line_Payment_rec.program_application_id := p_old_Line_Payment_rec.program_application_id;
1555: END IF;
1556:
1557: IF p_x_Line_Payment_rec.program_id = FND_API.G_MISS_NUM THEN

Line 1557: IF p_x_Line_Payment_rec.program_id = FND_API.G_MISS_NUM THEN

1553: IF p_x_Line_Payment_rec.program_application_id = FND_API.G_MISS_NUM THEN
1554: p_x_Line_Payment_rec.program_application_id := p_old_Line_Payment_rec.program_application_id;
1555: END IF;
1556:
1557: IF p_x_Line_Payment_rec.program_id = FND_API.G_MISS_NUM THEN
1558: p_x_Line_Payment_rec.program_id := p_old_Line_Payment_rec.program_id;
1559: END IF;
1560:
1561: IF p_x_Line_Payment_rec.program_update_date = FND_API.G_MISS_DATE THEN

Line 1561: IF p_x_Line_Payment_rec.program_update_date = FND_API.G_MISS_DATE THEN

1557: IF p_x_Line_Payment_rec.program_id = FND_API.G_MISS_NUM THEN
1558: p_x_Line_Payment_rec.program_id := p_old_Line_Payment_rec.program_id;
1559: END IF;
1560:
1561: IF p_x_Line_Payment_rec.program_update_date = FND_API.G_MISS_DATE THEN
1562: p_x_Line_Payment_rec.program_update_date := p_old_Line_Payment_rec.program_update_date;
1563: END IF;
1564:
1565: IF p_x_Line_Payment_rec.receipt_method_id = FND_API.G_MISS_NUM THEN

Line 1565: IF p_x_Line_Payment_rec.receipt_method_id = FND_API.G_MISS_NUM THEN

1561: IF p_x_Line_Payment_rec.program_update_date = FND_API.G_MISS_DATE THEN
1562: p_x_Line_Payment_rec.program_update_date := p_old_Line_Payment_rec.program_update_date;
1563: END IF;
1564:
1565: IF p_x_Line_Payment_rec.receipt_method_id = FND_API.G_MISS_NUM THEN
1566: p_x_Line_Payment_rec.receipt_method_id := p_old_Line_Payment_rec.receipt_method_id;
1567: END IF;
1568:
1569: IF p_x_Line_Payment_rec.request_id = FND_API.G_MISS_NUM THEN

Line 1569: IF p_x_Line_Payment_rec.request_id = FND_API.G_MISS_NUM THEN

1565: IF p_x_Line_Payment_rec.receipt_method_id = FND_API.G_MISS_NUM THEN
1566: p_x_Line_Payment_rec.receipt_method_id := p_old_Line_Payment_rec.receipt_method_id;
1567: END IF;
1568:
1569: IF p_x_Line_Payment_rec.request_id = FND_API.G_MISS_NUM THEN
1570: p_x_Line_Payment_rec.request_id := p_old_Line_Payment_rec.request_id;
1571: END IF;
1572:
1573: IF p_x_Line_Payment_rec.tangible_id = FND_API.G_MISS_CHAR THEN

Line 1573: IF p_x_Line_Payment_rec.tangible_id = FND_API.G_MISS_CHAR THEN

1569: IF p_x_Line_Payment_rec.request_id = FND_API.G_MISS_NUM THEN
1570: p_x_Line_Payment_rec.request_id := p_old_Line_Payment_rec.request_id;
1571: END IF;
1572:
1573: IF p_x_Line_Payment_rec.tangible_id = FND_API.G_MISS_CHAR THEN
1574: p_x_Line_Payment_rec.tangible_id := p_old_Line_Payment_rec.tangible_id;
1575: END IF;
1576:
1577: IF p_x_Line_Payment_rec.trxn_extension_id = FND_API.G_MISS_NUM THEN

Line 1577: IF p_x_Line_Payment_rec.trxn_extension_id = FND_API.G_MISS_NUM THEN

1573: IF p_x_Line_Payment_rec.tangible_id = FND_API.G_MISS_CHAR THEN
1574: p_x_Line_Payment_rec.tangible_id := p_old_Line_Payment_rec.tangible_id;
1575: END IF;
1576:
1577: IF p_x_Line_Payment_rec.trxn_extension_id = FND_API.G_MISS_NUM THEN
1578: p_x_Line_Payment_rec.trxn_extension_id := p_old_Line_Payment_rec.trxn_extension_id;
1579: END IF;
1580:
1581: -- R12 CC Encryption

Line 1582: IF p_x_Line_Payment_rec.trxn_extension_id = FND_API.G_MISS_NUM THEN

1578: p_x_Line_Payment_rec.trxn_extension_id := p_old_Line_Payment_rec.trxn_extension_id;
1579: END IF;
1580:
1581: -- R12 CC Encryption
1582: IF p_x_Line_Payment_rec.trxn_extension_id = FND_API.G_MISS_NUM THEN
1583: p_x_Line_Payment_rec.trxn_extension_id := p_old_Line_Payment_rec.trxn_extension_id;
1584: END IF;
1585:
1586: IF p_x_Line_Payment_rec.instrument_security_code = FND_API.G_MISS_CHAR THEN

Line 1586: IF p_x_Line_Payment_rec.instrument_security_code = FND_API.G_MISS_CHAR THEN

1582: IF p_x_Line_Payment_rec.trxn_extension_id = FND_API.G_MISS_NUM THEN
1583: p_x_Line_Payment_rec.trxn_extension_id := p_old_Line_Payment_rec.trxn_extension_id;
1584: END IF;
1585:
1586: IF p_x_Line_Payment_rec.instrument_security_code = FND_API.G_MISS_CHAR THEN
1587: p_x_Line_Payment_rec.instrument_security_code := p_old_Line_Payment_rec.instrument_security_code;
1588: END IF;
1589:
1590: -- R12 CC Encryption

Line 1606: IF p_x_Line_Payment_rec.attribute1 = FND_API.G_MISS_CHAR THEN

1602: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1603: --
1604: BEGIN
1605:
1606: IF p_x_Line_Payment_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1607: p_x_Line_Payment_rec.attribute1 := NULL;
1608: END IF;
1609:
1610: IF p_x_Line_Payment_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 1610: IF p_x_Line_Payment_rec.attribute2 = FND_API.G_MISS_CHAR THEN

1606: IF p_x_Line_Payment_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1607: p_x_Line_Payment_rec.attribute1 := NULL;
1608: END IF;
1609:
1610: IF p_x_Line_Payment_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1611: p_x_Line_Payment_rec.attribute2 := NULL;
1612: END IF;
1613:
1614: IF p_x_Line_Payment_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 1614: IF p_x_Line_Payment_rec.attribute3 = FND_API.G_MISS_CHAR THEN

1610: IF p_x_Line_Payment_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1611: p_x_Line_Payment_rec.attribute2 := NULL;
1612: END IF;
1613:
1614: IF p_x_Line_Payment_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1615: p_x_Line_Payment_rec.attribute3 := NULL;
1616: END IF;
1617:
1618: IF p_x_Line_Payment_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 1618: IF p_x_Line_Payment_rec.attribute4 = FND_API.G_MISS_CHAR THEN

1614: IF p_x_Line_Payment_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1615: p_x_Line_Payment_rec.attribute3 := NULL;
1616: END IF;
1617:
1618: IF p_x_Line_Payment_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1619: p_x_Line_Payment_rec.attribute4 := NULL;
1620: END IF;
1621:
1622: IF p_x_Line_Payment_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 1622: IF p_x_Line_Payment_rec.attribute5 = FND_API.G_MISS_CHAR THEN

1618: IF p_x_Line_Payment_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1619: p_x_Line_Payment_rec.attribute4 := NULL;
1620: END IF;
1621:
1622: IF p_x_Line_Payment_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1623: p_x_Line_Payment_rec.attribute5 := NULL;
1624: END IF;
1625:
1626: IF p_x_Line_Payment_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 1626: IF p_x_Line_Payment_rec.attribute6 = FND_API.G_MISS_CHAR THEN

1622: IF p_x_Line_Payment_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1623: p_x_Line_Payment_rec.attribute5 := NULL;
1624: END IF;
1625:
1626: IF p_x_Line_Payment_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1627: p_x_Line_Payment_rec.attribute6 := NULL;
1628: END IF;
1629:
1630: IF p_x_Line_Payment_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 1630: IF p_x_Line_Payment_rec.attribute7 = FND_API.G_MISS_CHAR THEN

1626: IF p_x_Line_Payment_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1627: p_x_Line_Payment_rec.attribute6 := NULL;
1628: END IF;
1629:
1630: IF p_x_Line_Payment_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1631: p_x_Line_Payment_rec.attribute7 := NULL;
1632: END IF;
1633:
1634: IF p_x_Line_Payment_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 1634: IF p_x_Line_Payment_rec.attribute8 = FND_API.G_MISS_CHAR THEN

1630: IF p_x_Line_Payment_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1631: p_x_Line_Payment_rec.attribute7 := NULL;
1632: END IF;
1633:
1634: IF p_x_Line_Payment_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1635: p_x_Line_Payment_rec.attribute8 := NULL;
1636: END IF;
1637:
1638: IF p_x_Line_Payment_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 1638: IF p_x_Line_Payment_rec.attribute9 = FND_API.G_MISS_CHAR THEN

1634: IF p_x_Line_Payment_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1635: p_x_Line_Payment_rec.attribute8 := NULL;
1636: END IF;
1637:
1638: IF p_x_Line_Payment_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1639: p_x_Line_Payment_rec.attribute9 := NULL;
1640: END IF;
1641:
1642: IF p_x_Line_Payment_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 1642: IF p_x_Line_Payment_rec.attribute10 = FND_API.G_MISS_CHAR THEN

1638: IF p_x_Line_Payment_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1639: p_x_Line_Payment_rec.attribute9 := NULL;
1640: END IF;
1641:
1642: IF p_x_Line_Payment_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1643: p_x_Line_Payment_rec.attribute10 := NULL;
1644: END IF;
1645:
1646: IF p_x_Line_Payment_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 1646: IF p_x_Line_Payment_rec.attribute11 = FND_API.G_MISS_CHAR THEN

1642: IF p_x_Line_Payment_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1643: p_x_Line_Payment_rec.attribute10 := NULL;
1644: END IF;
1645:
1646: IF p_x_Line_Payment_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1647: p_x_Line_Payment_rec.attribute11 := NULL;
1648: END IF;
1649:
1650: IF p_x_Line_Payment_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 1650: IF p_x_Line_Payment_rec.attribute12 = FND_API.G_MISS_CHAR THEN

1646: IF p_x_Line_Payment_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1647: p_x_Line_Payment_rec.attribute11 := NULL;
1648: END IF;
1649:
1650: IF p_x_Line_Payment_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1651: p_x_Line_Payment_rec.attribute12 := NULL;
1652: END IF;
1653:
1654: IF p_x_Line_Payment_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 1654: IF p_x_Line_Payment_rec.attribute13 = FND_API.G_MISS_CHAR THEN

1650: IF p_x_Line_Payment_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1651: p_x_Line_Payment_rec.attribute12 := NULL;
1652: END IF;
1653:
1654: IF p_x_Line_Payment_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1655: p_x_Line_Payment_rec.attribute13 := NULL;
1656: END IF;
1657:
1658: IF p_x_Line_Payment_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 1658: IF p_x_Line_Payment_rec.attribute14 = FND_API.G_MISS_CHAR THEN

1654: IF p_x_Line_Payment_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1655: p_x_Line_Payment_rec.attribute13 := NULL;
1656: END IF;
1657:
1658: IF p_x_Line_Payment_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1659: p_x_Line_Payment_rec.attribute14 := NULL;
1660: END IF;
1661:
1662: IF p_x_Line_Payment_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 1662: IF p_x_Line_Payment_rec.attribute15 = FND_API.G_MISS_CHAR THEN

1658: IF p_x_Line_Payment_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1659: p_x_Line_Payment_rec.attribute14 := NULL;
1660: END IF;
1661:
1662: IF p_x_Line_Payment_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1663: p_x_Line_Payment_rec.attribute15 := NULL;
1664: END IF;
1665:
1666: IF p_x_Line_Payment_rec.context = FND_API.G_MISS_CHAR THEN

Line 1666: IF p_x_Line_Payment_rec.context = FND_API.G_MISS_CHAR THEN

1662: IF p_x_Line_Payment_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1663: p_x_Line_Payment_rec.attribute15 := NULL;
1664: END IF;
1665:
1666: IF p_x_Line_Payment_rec.context = FND_API.G_MISS_CHAR THEN
1667: p_x_Line_Payment_rec.context := NULL;
1668: END IF;
1669:
1670: IF p_x_Line_Payment_rec.created_by = FND_API.G_MISS_NUM THEN

Line 1670: IF p_x_Line_Payment_rec.created_by = FND_API.G_MISS_NUM THEN

1666: IF p_x_Line_Payment_rec.context = FND_API.G_MISS_CHAR THEN
1667: p_x_Line_Payment_rec.context := NULL;
1668: END IF;
1669:
1670: IF p_x_Line_Payment_rec.created_by = FND_API.G_MISS_NUM THEN
1671: p_x_Line_Payment_rec.created_by := NULL;
1672: END IF;
1673:
1674: IF p_x_Line_Payment_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 1674: IF p_x_Line_Payment_rec.creation_date = FND_API.G_MISS_DATE THEN

1670: IF p_x_Line_Payment_rec.created_by = FND_API.G_MISS_NUM THEN
1671: p_x_Line_Payment_rec.created_by := NULL;
1672: END IF;
1673:
1674: IF p_x_Line_Payment_rec.creation_date = FND_API.G_MISS_DATE THEN
1675: p_x_Line_Payment_rec.creation_date := NULL;
1676: END IF;
1677:
1678: IF p_x_Line_Payment_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 1678: IF p_x_Line_Payment_rec.last_updated_by = FND_API.G_MISS_NUM THEN

1674: IF p_x_Line_Payment_rec.creation_date = FND_API.G_MISS_DATE THEN
1675: p_x_Line_Payment_rec.creation_date := NULL;
1676: END IF;
1677:
1678: IF p_x_Line_Payment_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1679: p_x_Line_Payment_rec.last_updated_by := NULL;
1680: END IF;
1681:
1682: IF p_x_Line_Payment_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 1682: IF p_x_Line_Payment_rec.last_update_date = FND_API.G_MISS_DATE THEN

1678: IF p_x_Line_Payment_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1679: p_x_Line_Payment_rec.last_updated_by := NULL;
1680: END IF;
1681:
1682: IF p_x_Line_Payment_rec.last_update_date = FND_API.G_MISS_DATE THEN
1683: p_x_Line_Payment_rec.last_update_date := NULL;
1684: END IF;
1685:
1686: IF p_x_Line_Payment_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 1686: IF p_x_Line_Payment_rec.last_update_login = FND_API.G_MISS_NUM THEN

1682: IF p_x_Line_Payment_rec.last_update_date = FND_API.G_MISS_DATE THEN
1683: p_x_Line_Payment_rec.last_update_date := NULL;
1684: END IF;
1685:
1686: IF p_x_Line_Payment_rec.last_update_login = FND_API.G_MISS_NUM THEN
1687: p_x_Line_Payment_rec.last_update_login := NULL;
1688: END IF;
1689:
1690: IF p_x_Line_Payment_rec.check_number = FND_API.G_MISS_CHAR THEN

Line 1690: IF p_x_Line_Payment_rec.check_number = FND_API.G_MISS_CHAR THEN

1686: IF p_x_Line_Payment_rec.last_update_login = FND_API.G_MISS_NUM THEN
1687: p_x_Line_Payment_rec.last_update_login := NULL;
1688: END IF;
1689:
1690: IF p_x_Line_Payment_rec.check_number = FND_API.G_MISS_CHAR THEN
1691: p_x_Line_Payment_rec.check_number := NULL;
1692: END IF;
1693:
1694: IF p_x_Line_Payment_rec.credit_card_approval_code = FND_API.G_MISS_CHAR THEN

Line 1694: IF p_x_Line_Payment_rec.credit_card_approval_code = FND_API.G_MISS_CHAR THEN

1690: IF p_x_Line_Payment_rec.check_number = FND_API.G_MISS_CHAR THEN
1691: p_x_Line_Payment_rec.check_number := NULL;
1692: END IF;
1693:
1694: IF p_x_Line_Payment_rec.credit_card_approval_code = FND_API.G_MISS_CHAR THEN
1695: p_x_Line_Payment_rec.credit_card_approval_code := NULL;
1696: END IF;
1697:
1698: IF p_x_Line_Payment_rec.credit_card_approval_date = FND_API.G_MISS_DATE THEN

Line 1698: IF p_x_Line_Payment_rec.credit_card_approval_date = FND_API.G_MISS_DATE THEN

1694: IF p_x_Line_Payment_rec.credit_card_approval_code = FND_API.G_MISS_CHAR THEN
1695: p_x_Line_Payment_rec.credit_card_approval_code := NULL;
1696: END IF;
1697:
1698: IF p_x_Line_Payment_rec.credit_card_approval_date = FND_API.G_MISS_DATE THEN
1699: p_x_Line_Payment_rec.credit_card_approval_date := NULL;
1700: END IF;
1701:
1702: IF p_x_Line_Payment_rec.credit_card_code = FND_API.G_MISS_CHAR THEN

Line 1702: IF p_x_Line_Payment_rec.credit_card_code = FND_API.G_MISS_CHAR THEN

1698: IF p_x_Line_Payment_rec.credit_card_approval_date = FND_API.G_MISS_DATE THEN
1699: p_x_Line_Payment_rec.credit_card_approval_date := NULL;
1700: END IF;
1701:
1702: IF p_x_Line_Payment_rec.credit_card_code = FND_API.G_MISS_CHAR THEN
1703: p_x_Line_Payment_rec.credit_card_code := NULL;
1704: END IF;
1705:
1706: IF p_x_Line_Payment_rec.credit_card_expiration_date = FND_API.G_MISS_DATE THEN

Line 1706: IF p_x_Line_Payment_rec.credit_card_expiration_date = FND_API.G_MISS_DATE THEN

1702: IF p_x_Line_Payment_rec.credit_card_code = FND_API.G_MISS_CHAR THEN
1703: p_x_Line_Payment_rec.credit_card_code := NULL;
1704: END IF;
1705:
1706: IF p_x_Line_Payment_rec.credit_card_expiration_date = FND_API.G_MISS_DATE THEN
1707: p_x_Line_Payment_rec.credit_card_expiration_date := NULL;
1708: END IF;
1709:
1710: IF p_x_Line_Payment_rec.credit_card_holder_name = FND_API.G_MISS_CHAR THEN

Line 1710: IF p_x_Line_Payment_rec.credit_card_holder_name = FND_API.G_MISS_CHAR THEN

1706: IF p_x_Line_Payment_rec.credit_card_expiration_date = FND_API.G_MISS_DATE THEN
1707: p_x_Line_Payment_rec.credit_card_expiration_date := NULL;
1708: END IF;
1709:
1710: IF p_x_Line_Payment_rec.credit_card_holder_name = FND_API.G_MISS_CHAR THEN
1711: p_x_Line_Payment_rec.credit_card_holder_name := NULL;
1712: END IF;
1713:
1714: IF p_x_Line_Payment_rec.credit_card_number = FND_API.G_MISS_CHAR THEN

Line 1714: IF p_x_Line_Payment_rec.credit_card_number = FND_API.G_MISS_CHAR THEN

1710: IF p_x_Line_Payment_rec.credit_card_holder_name = FND_API.G_MISS_CHAR THEN
1711: p_x_Line_Payment_rec.credit_card_holder_name := NULL;
1712: END IF;
1713:
1714: IF p_x_Line_Payment_rec.credit_card_number = FND_API.G_MISS_CHAR THEN
1715: p_x_Line_Payment_rec.credit_card_number := NULL;
1716: END IF;
1717:
1718: IF p_x_Line_Payment_rec.payment_level_code = FND_API.G_MISS_CHAR THEN

Line 1718: IF p_x_Line_Payment_rec.payment_level_code = FND_API.G_MISS_CHAR THEN

1714: IF p_x_Line_Payment_rec.credit_card_number = FND_API.G_MISS_CHAR THEN
1715: p_x_Line_Payment_rec.credit_card_number := NULL;
1716: END IF;
1717:
1718: IF p_x_Line_Payment_rec.payment_level_code = FND_API.G_MISS_CHAR THEN
1719: p_x_Line_Payment_rec.payment_level_code := NULL;
1720: END IF;
1721:
1722: IF p_x_Line_Payment_rec.commitment_applied_amount = FND_API.G_MISS_NUM THEN

Line 1722: IF p_x_Line_Payment_rec.commitment_applied_amount = FND_API.G_MISS_NUM THEN

1718: IF p_x_Line_Payment_rec.payment_level_code = FND_API.G_MISS_CHAR THEN
1719: p_x_Line_Payment_rec.payment_level_code := NULL;
1720: END IF;
1721:
1722: IF p_x_Line_Payment_rec.commitment_applied_amount = FND_API.G_MISS_NUM THEN
1723: p_x_Line_Payment_rec.commitment_applied_amount := NULL;
1724: END IF;
1725:
1726: IF p_x_Line_Payment_rec.commitment_interfaced_amount = FND_API.G_MISS_NUM THEN

Line 1726: IF p_x_Line_Payment_rec.commitment_interfaced_amount = FND_API.G_MISS_NUM THEN

1722: IF p_x_Line_Payment_rec.commitment_applied_amount = FND_API.G_MISS_NUM THEN
1723: p_x_Line_Payment_rec.commitment_applied_amount := NULL;
1724: END IF;
1725:
1726: IF p_x_Line_Payment_rec.commitment_interfaced_amount = FND_API.G_MISS_NUM THEN
1727: p_x_Line_Payment_rec.commitment_interfaced_amount := NULL;
1728: END IF;
1729:
1730: IF p_x_Line_Payment_rec.payment_number = FND_API.G_MISS_NUM THEN

Line 1730: IF p_x_Line_Payment_rec.payment_number = FND_API.G_MISS_NUM THEN

1726: IF p_x_Line_Payment_rec.commitment_interfaced_amount = FND_API.G_MISS_NUM THEN
1727: p_x_Line_Payment_rec.commitment_interfaced_amount := NULL;
1728: END IF;
1729:
1730: IF p_x_Line_Payment_rec.payment_number = FND_API.G_MISS_NUM THEN
1731: p_x_Line_Payment_rec.payment_number := NULL;
1732: END IF;
1733:
1734: IF p_x_Line_Payment_rec.header_id = FND_API.G_MISS_NUM THEN

Line 1734: IF p_x_Line_Payment_rec.header_id = FND_API.G_MISS_NUM THEN

1730: IF p_x_Line_Payment_rec.payment_number = FND_API.G_MISS_NUM THEN
1731: p_x_Line_Payment_rec.payment_number := NULL;
1732: END IF;
1733:
1734: IF p_x_Line_Payment_rec.header_id = FND_API.G_MISS_NUM THEN
1735: p_x_Line_Payment_rec.header_id := NULL;
1736: END IF;
1737:
1738: IF p_x_Line_Payment_rec.line_id = FND_API.G_MISS_NUM THEN

Line 1738: IF p_x_Line_Payment_rec.line_id = FND_API.G_MISS_NUM THEN

1734: IF p_x_Line_Payment_rec.header_id = FND_API.G_MISS_NUM THEN
1735: p_x_Line_Payment_rec.header_id := NULL;
1736: END IF;
1737:
1738: IF p_x_Line_Payment_rec.line_id = FND_API.G_MISS_NUM THEN
1739: p_x_Line_Payment_rec.line_id := NULL;
1740: END IF;
1741:
1742: IF p_x_Line_Payment_rec.payment_amount = FND_API.G_MISS_NUM THEN

Line 1742: IF p_x_Line_Payment_rec.payment_amount = FND_API.G_MISS_NUM THEN

1738: IF p_x_Line_Payment_rec.line_id = FND_API.G_MISS_NUM THEN
1739: p_x_Line_Payment_rec.line_id := NULL;
1740: END IF;
1741:
1742: IF p_x_Line_Payment_rec.payment_amount = FND_API.G_MISS_NUM THEN
1743: p_x_Line_Payment_rec.payment_amount := NULL;
1744: END IF;
1745:
1746: IF p_x_Line_Payment_rec.payment_collection_event = FND_API.G_MISS_CHAR THEN

Line 1746: IF p_x_Line_Payment_rec.payment_collection_event = FND_API.G_MISS_CHAR THEN

1742: IF p_x_Line_Payment_rec.payment_amount = FND_API.G_MISS_NUM THEN
1743: p_x_Line_Payment_rec.payment_amount := NULL;
1744: END IF;
1745:
1746: IF p_x_Line_Payment_rec.payment_collection_event = FND_API.G_MISS_CHAR THEN
1747: p_x_Line_Payment_rec.payment_collection_event := NULL;
1748: END IF;
1749:
1750: IF p_x_Line_Payment_rec.defer_payment_processing_flag = FND_API.G_MISS_CHAR THEN

Line 1750: IF p_x_Line_Payment_rec.defer_payment_processing_flag = FND_API.G_MISS_CHAR THEN

1746: IF p_x_Line_Payment_rec.payment_collection_event = FND_API.G_MISS_CHAR THEN
1747: p_x_Line_Payment_rec.payment_collection_event := NULL;
1748: END IF;
1749:
1750: IF p_x_Line_Payment_rec.defer_payment_processing_flag = FND_API.G_MISS_CHAR THEN
1751: p_x_Line_Payment_rec.defer_payment_processing_flag := NULL;
1752: END IF;
1753:
1754: IF p_x_Line_Payment_rec.payment_trx_id = FND_API.G_MISS_NUM THEN

Line 1754: IF p_x_Line_Payment_rec.payment_trx_id = FND_API.G_MISS_NUM THEN

1750: IF p_x_Line_Payment_rec.defer_payment_processing_flag = FND_API.G_MISS_CHAR THEN
1751: p_x_Line_Payment_rec.defer_payment_processing_flag := NULL;
1752: END IF;
1753:
1754: IF p_x_Line_Payment_rec.payment_trx_id = FND_API.G_MISS_NUM THEN
1755: p_x_Line_Payment_rec.payment_trx_id := NULL;
1756: END IF;
1757:
1758: IF p_x_Line_Payment_rec.payment_type_code = FND_API.G_MISS_CHAR THEN

Line 1758: IF p_x_Line_Payment_rec.payment_type_code = FND_API.G_MISS_CHAR THEN

1754: IF p_x_Line_Payment_rec.payment_trx_id = FND_API.G_MISS_NUM THEN
1755: p_x_Line_Payment_rec.payment_trx_id := NULL;
1756: END IF;
1757:
1758: IF p_x_Line_Payment_rec.payment_type_code = FND_API.G_MISS_CHAR THEN
1759: p_x_Line_Payment_rec.payment_type_code := NULL;
1760: END IF;
1761:
1762: IF p_x_Line_Payment_rec.payment_set_id = FND_API.G_MISS_NUM THEN

Line 1762: IF p_x_Line_Payment_rec.payment_set_id = FND_API.G_MISS_NUM THEN

1758: IF p_x_Line_Payment_rec.payment_type_code = FND_API.G_MISS_CHAR THEN
1759: p_x_Line_Payment_rec.payment_type_code := NULL;
1760: END IF;
1761:
1762: IF p_x_Line_Payment_rec.payment_set_id = FND_API.G_MISS_NUM THEN
1763: p_x_Line_Payment_rec.payment_set_id := NULL;
1764: END IF;
1765:
1766: IF p_x_Line_Payment_rec.prepaid_amount = FND_API.G_MISS_NUM THEN

Line 1766: IF p_x_Line_Payment_rec.prepaid_amount = FND_API.G_MISS_NUM THEN

1762: IF p_x_Line_Payment_rec.payment_set_id = FND_API.G_MISS_NUM THEN
1763: p_x_Line_Payment_rec.payment_set_id := NULL;
1764: END IF;
1765:
1766: IF p_x_Line_Payment_rec.prepaid_amount = FND_API.G_MISS_NUM THEN
1767: p_x_Line_Payment_rec.prepaid_amount := NULL;
1768: END IF;
1769:
1770: IF p_x_Line_Payment_rec.program_application_id = FND_API.G_MISS_NUM THEN

Line 1770: IF p_x_Line_Payment_rec.program_application_id = FND_API.G_MISS_NUM THEN

1766: IF p_x_Line_Payment_rec.prepaid_amount = FND_API.G_MISS_NUM THEN
1767: p_x_Line_Payment_rec.prepaid_amount := NULL;
1768: END IF;
1769:
1770: IF p_x_Line_Payment_rec.program_application_id = FND_API.G_MISS_NUM THEN
1771: p_x_Line_Payment_rec.program_application_id := NULL;
1772: END IF;
1773:
1774: IF p_x_Line_Payment_rec.program_id = FND_API.G_MISS_NUM THEN

Line 1774: IF p_x_Line_Payment_rec.program_id = FND_API.G_MISS_NUM THEN

1770: IF p_x_Line_Payment_rec.program_application_id = FND_API.G_MISS_NUM THEN
1771: p_x_Line_Payment_rec.program_application_id := NULL;
1772: END IF;
1773:
1774: IF p_x_Line_Payment_rec.program_id = FND_API.G_MISS_NUM THEN
1775: p_x_Line_Payment_rec.program_id := NULL;
1776: END IF;
1777:
1778: IF p_x_Line_Payment_rec.program_update_date = FND_API.G_MISS_DATE THEN

Line 1778: IF p_x_Line_Payment_rec.program_update_date = FND_API.G_MISS_DATE THEN

1774: IF p_x_Line_Payment_rec.program_id = FND_API.G_MISS_NUM THEN
1775: p_x_Line_Payment_rec.program_id := NULL;
1776: END IF;
1777:
1778: IF p_x_Line_Payment_rec.program_update_date = FND_API.G_MISS_DATE THEN
1779: p_x_Line_Payment_rec.program_update_date := NULL;
1780: END IF;
1781:
1782: IF p_x_Line_Payment_rec.receipt_method_id = FND_API.G_MISS_NUM THEN

Line 1782: IF p_x_Line_Payment_rec.receipt_method_id = FND_API.G_MISS_NUM THEN

1778: IF p_x_Line_Payment_rec.program_update_date = FND_API.G_MISS_DATE THEN
1779: p_x_Line_Payment_rec.program_update_date := NULL;
1780: END IF;
1781:
1782: IF p_x_Line_Payment_rec.receipt_method_id = FND_API.G_MISS_NUM THEN
1783: p_x_Line_Payment_rec.receipt_method_id := NULL;
1784: END IF;
1785:
1786: IF p_x_Line_Payment_rec.request_id = FND_API.G_MISS_NUM THEN

Line 1786: IF p_x_Line_Payment_rec.request_id = FND_API.G_MISS_NUM THEN

1782: IF p_x_Line_Payment_rec.receipt_method_id = FND_API.G_MISS_NUM THEN
1783: p_x_Line_Payment_rec.receipt_method_id := NULL;
1784: END IF;
1785:
1786: IF p_x_Line_Payment_rec.request_id = FND_API.G_MISS_NUM THEN
1787: p_x_Line_Payment_rec.request_id := NULL;
1788: END IF;
1789:
1790: IF p_x_Line_Payment_rec.tangible_id = FND_API.G_MISS_CHAR THEN

Line 1790: IF p_x_Line_Payment_rec.tangible_id = FND_API.G_MISS_CHAR THEN

1786: IF p_x_Line_Payment_rec.request_id = FND_API.G_MISS_NUM THEN
1787: p_x_Line_Payment_rec.request_id := NULL;
1788: END IF;
1789:
1790: IF p_x_Line_Payment_rec.tangible_id = FND_API.G_MISS_CHAR THEN
1791: p_x_Line_Payment_rec.tangible_id := NULL;
1792: END IF;
1793: -- R12 CC Encryption
1794: IF p_x_Line_Payment_rec.trxn_extension_id = FND_API.G_MISS_NUM THEN

Line 1794: IF p_x_Line_Payment_rec.trxn_extension_id = FND_API.G_MISS_NUM THEN

1790: IF p_x_Line_Payment_rec.tangible_id = FND_API.G_MISS_CHAR THEN
1791: p_x_Line_Payment_rec.tangible_id := NULL;
1792: END IF;
1793: -- R12 CC Encryption
1794: IF p_x_Line_Payment_rec.trxn_extension_id = FND_API.G_MISS_NUM THEN
1795: p_x_Line_Payment_rec.trxn_extension_id := NULL;
1796: END IF;
1797:
1798: IF p_x_Line_Payment_rec.instrument_security_code = FND_API.G_MISS_CHAR THEN

Line 1798: IF p_x_Line_Payment_rec.instrument_security_code = FND_API.G_MISS_CHAR THEN

1794: IF p_x_Line_Payment_rec.trxn_extension_id = FND_API.G_MISS_NUM THEN
1795: p_x_Line_Payment_rec.trxn_extension_id := NULL;
1796: END IF;
1797:
1798: IF p_x_Line_Payment_rec.instrument_security_code = FND_API.G_MISS_CHAR THEN
1799: p_x_Line_Payment_rec.instrument_security_code := NULL;
1800: END IF;
1801:
1802: -- R12 CC Encryption

Line 1847: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1843: x_return_status => l_return_status); */
1844: IF l_debug_level > 0 THEN
1845: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_LINE_PAYMENT_UTIL.UPDATE_ROW IS: ' || L_RETURN_STATUS ) ;
1846: END IF;
1847: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1848: IF l_debug_level > 0 THEN
1849: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
1850: END IF;
1851: IF l_debug_level > 0 THEN

Line 1854: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1850: END IF;
1851: IF l_debug_level > 0 THEN
1852: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENT_UTIL.UPDATE_ROW' , 1 ) ;
1853: END IF;
1854: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1855: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1856: IF l_debug_level > 0 THEN
1857: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_PAYMENT_UTIL.UPDATE_ROW' ) ;
1858: END IF;

Line 1855: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1851: IF l_debug_level > 0 THEN
1852: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENT_UTIL.UPDATE_ROW' , 1 ) ;
1853: END IF;
1854: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1855: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1856: IF l_debug_level > 0 THEN
1857: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_PAYMENT_UTIL.UPDATE_ROW' ) ;
1858: END IF;
1859: IF l_debug_level > 0 THEN

Line 1862: RAISE FND_API.G_EXC_ERROR;

1858: END IF;
1859: IF l_debug_level > 0 THEN
1860: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENT_UTIL.UPDATE_ROW' , 1 ) ;
1861: END IF;
1862: RAISE FND_API.G_EXC_ERROR;
1863: END IF;
1864: END IF; /*code_release_level*/
1865: -- notification framework end
1866:

Line 1936: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1932: , 'Update_Row'
1933: );
1934: END IF;
1935:
1936: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1937:
1938: END Update_Row;
1939:
1940: -- Procedure Insert_Row

Line 2104: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2100: IF l_debug_level > 0 THEN
2101: oe_debug_pub.add( 'RETURNED INDEX IS: ' || L_INDEX , 1 ) ;
2102: END IF;
2103:
2104: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2105: IF l_debug_level > 0 THEN
2106: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
2107: END IF;
2108: IF l_debug_level > 0 THEN

Line 2111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2107: END IF;
2108: IF l_debug_level > 0 THEN
2109: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENT_UTIL.INSERT_ROW' , 1 ) ;
2110: END IF;
2111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2112: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2113: IF l_debug_level > 0 THEN
2114: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_PAYMENT_UTIL.INSERT_ROW' ) ;
2115: END IF;

Line 2112: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2108: IF l_debug_level > 0 THEN
2109: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENT_UTIL.INSERT_ROW' , 1 ) ;
2110: END IF;
2111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2112: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2113: IF l_debug_level > 0 THEN
2114: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_PAYMENT_UTIL.INSERT_ROW' ) ;
2115: END IF;
2116: IF l_debug_level > 0 THEN

Line 2119: RAISE FND_API.G_EXC_ERROR;

2115: END IF;
2116: IF l_debug_level > 0 THEN
2117: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENT_UTIL.INSERT_ROW' , 1 ) ;
2118: END IF;
2119: RAISE FND_API.G_EXC_ERROR;
2120: END IF;
2121: END IF; /*code_release_level*/
2122: -- notification framework end
2123:

Line 2140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2136: , 'Insert_Row'
2137: );
2138: END IF;
2139:
2140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2141:
2142: END Insert_Row;
2143:
2144: -- Procedure Delete_Row

Line 2148: FND_API.G_MISS_NUM

2144: -- Procedure Delete_Row
2145:
2146: PROCEDURE Delete_Row
2147: ( p_payment_number IN NUMBER :=
2148: FND_API.G_MISS_NUM
2149: , p_line_id IN NUMBER :=
2150: FND_API.G_MISS_NUM
2151: , p_header_id IN NUMBER :=
2152: FND_API.G_MISS_NUM

Line 2150: FND_API.G_MISS_NUM

2146: PROCEDURE Delete_Row
2147: ( p_payment_number IN NUMBER :=
2148: FND_API.G_MISS_NUM
2149: , p_line_id IN NUMBER :=
2150: FND_API.G_MISS_NUM
2151: , p_header_id IN NUMBER :=
2152: FND_API.G_MISS_NUM
2153: )
2154: IS

Line 2152: FND_API.G_MISS_NUM

2148: FND_API.G_MISS_NUM
2149: , p_line_id IN NUMBER :=
2150: FND_API.G_MISS_NUM
2151: , p_header_id IN NUMBER :=
2152: FND_API.G_MISS_NUM
2153: )
2154: IS
2155: l_return_status VARCHAR2(30);
2156: p_payment_type_code VARCHAR2(30) := NULL;

Line 2182: IF p_line_id <> FND_API.G_MISS_NUM AND

2178: IF l_debug_level > 0 THEN
2179: oe_debug_pub.add( 'ENTERING OE_LINE_PAYMENT_UTIL.DELETE_ROW' , 1 ) ;
2180: END IF;
2181:
2182: IF p_line_id <> FND_API.G_MISS_NUM AND
2183: nvl(p_payment_number, FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM
2184: THEN
2185: FOR l_pmt IN payment LOOP
2186:

Line 2183: nvl(p_payment_number, FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM

2179: oe_debug_pub.add( 'ENTERING OE_LINE_PAYMENT_UTIL.DELETE_ROW' , 1 ) ;
2180: END IF;
2181:
2182: IF p_line_id <> FND_API.G_MISS_NUM AND
2183: nvl(p_payment_number, FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM
2184: THEN
2185: FOR l_pmt IN payment LOOP
2186:
2187: --added notification framework

Line 2224: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2220: x_return_status =>l_return_status,
2221: x_msg_count => l_msg_count,
2222: x_msg_data => l_msg_data);
2223:
2224: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2225: IF l_debug_level > 0 THEN
2226: oe_debug_pub.add( 'Delete Payment at OE_LINE_Payment_UTIL.DELETE_ROW - UNEXPECTED ERROR' ) ;
2227: oe_debug_pub.add('Error message'||sqlerrm);
2228: oe_debug_pub.add('Msg data'||l_msg_data);

Line 2233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2229: END IF;
2230: IF l_debug_level > 0 THEN
2231: oe_debug_pub.add( 'EXITING OE_LINE_Payment_UTIL.DELETE_ROW' , 1 ) ;
2232: END IF;
2233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2234: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2235: IF l_debug_level > 0 THEN
2236: oe_debug_pub.add( 'Delete Payment at OE_LINE_Payment_UTIL.DELETE_ROW' ) ;
2237: oe_debug_pub.add('Error message'||sqlerrm);

Line 2234: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2230: IF l_debug_level > 0 THEN
2231: oe_debug_pub.add( 'EXITING OE_LINE_Payment_UTIL.DELETE_ROW' , 1 ) ;
2232: END IF;
2233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2234: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2235: IF l_debug_level > 0 THEN
2236: oe_debug_pub.add( 'Delete Payment at OE_LINE_Payment_UTIL.DELETE_ROW' ) ;
2237: oe_debug_pub.add('Error message'||sqlerrm);
2238: oe_debug_pub.add('Msg data'||l_msg_data);

Line 2243: RAISE FND_API.G_EXC_ERROR;

2239: END IF;
2240: IF l_debug_level > 0 THEN
2241: oe_debug_pub.add( 'EXITING OE_LINE_Payment_UTIL.DELETE_ROW' , 1 ) ;
2242: END IF;
2243: RAISE FND_API.G_EXC_ERROR;
2244: END IF;
2245: END IF;
2246: --R12 CC Encryption
2247:

Line 2257: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2253: x_return_status => l_return_status);
2254: IF l_debug_level > 0 THEN
2255: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_LINE_PAYMENT_UTIL.DELETE_ROW IS: ' || L_RETURN_STATUS ) ;
2256: END IF;
2257: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2258: IF l_debug_level > 0 THEN
2259: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
2260: END IF;
2261: IF l_debug_level > 0 THEN

Line 2264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2260: END IF;
2261: IF l_debug_level > 0 THEN
2262: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENT_UTIL.DELETE_ROW' , 1 ) ;
2263: END IF;
2264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2265: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2266: IF l_debug_level > 0 THEN
2267: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_PAYMENT_UTIL.DELETE_ROW' ) ;
2268: END IF;

Line 2265: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2261: IF l_debug_level > 0 THEN
2262: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENT_UTIL.DELETE_ROW' , 1 ) ;
2263: END IF;
2264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2265: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2266: IF l_debug_level > 0 THEN
2267: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_PAYMENT_UTIL.DELETE_ROW' ) ;
2268: END IF;
2269: IF l_debug_level > 0 THEN

Line 2272: RAISE FND_API.G_EXC_ERROR;

2268: END IF;
2269: IF l_debug_level > 0 THEN
2270: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENT_UTIL.DELETE_ROW' , 1 ) ;
2271: END IF;
2272: RAISE FND_API.G_EXC_ERROR;
2273: END IF;*/
2274: END IF; /*code_release_level*/
2275: -- notification framework end
2276:

Line 2301: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2297: x_return_status => l_return_status,
2298: x_msg_count => l_msg_count,
2299: x_msg_data => l_msg_data);
2300:
2301: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2302: IF l_debug_level > 0 THEN
2303: oe_debug_pub.add( 'Delete Payment at Line - UNEXPECTED ERROR' ) ;
2304: END IF;
2305: IF l_debug_level > 0 THEN

Line 2308: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2304: END IF;
2305: IF l_debug_level > 0 THEN
2306: oe_debug_pub.add( 'EXITING OE_LINE_Payment_UTIL.DELETE_ROW' , 1 ) ;
2307: END IF;
2308: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2309: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2310: IF l_debug_level > 0 THEN
2311: oe_debug_pub.add( 'Delete Payment at Line - OE_LINE_Payment_UTIL.DELETE_ROW' ) ;
2312: END IF;

Line 2309: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2305: IF l_debug_level > 0 THEN
2306: oe_debug_pub.add( 'EXITING OE_LINE_Payment_UTIL.DELETE_ROW' , 1 ) ;
2307: END IF;
2308: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2309: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2310: IF l_debug_level > 0 THEN
2311: oe_debug_pub.add( 'Delete Payment at Line - OE_LINE_Payment_UTIL.DELETE_ROW' ) ;
2312: END IF;
2313: IF l_debug_level > 0 THEN

Line 2316: RAISE FND_API.G_EXC_ERROR;

2312: END IF;
2313: IF l_debug_level > 0 THEN
2314: oe_debug_pub.add( 'EXITING OE_LINE_Payment_UTIL.DELETE_ROW' , 1 ) ;
2315: END IF;
2316: RAISE FND_API.G_EXC_ERROR;
2317: END IF;
2318: --3382262
2319:
2320: IF l_debug_level > 0 THEN

Line 2332: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2328: , p_msg_data => l_msg_data
2329: , p_return_status => l_return_status
2330: );
2331:
2332: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2333: RAISE FND_API.G_EXC_ERROR;
2334: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2336: END IF;

Line 2333: RAISE FND_API.G_EXC_ERROR;

2329: , p_return_status => l_return_status
2330: );
2331:
2332: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2333: RAISE FND_API.G_EXC_ERROR;
2334: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2336: END IF;
2337:

Line 2334: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2330: );
2331:
2332: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2333: RAISE FND_API.G_EXC_ERROR;
2334: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2336: END IF;
2337:
2338: ELSIF p_line_id <> FND_API.G_MISS_NUM AND

Line 2335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2331:
2332: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2333: RAISE FND_API.G_EXC_ERROR;
2334: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2336: END IF;
2337:
2338: ELSIF p_line_id <> FND_API.G_MISS_NUM AND
2339: p_payment_number <> FND_API.G_MISS_NUM THEN

Line 2338: ELSIF p_line_id <> FND_API.G_MISS_NUM AND

2334: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2336: END IF;
2337:
2338: ELSIF p_line_id <> FND_API.G_MISS_NUM AND
2339: p_payment_number <> FND_API.G_MISS_NUM THEN
2340: --added notification framework
2341: --check code release level first. Notification framework is at Pack H level
2342: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN

Line 2339: p_payment_number <> FND_API.G_MISS_NUM THEN

2335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2336: END IF;
2337:
2338: ELSIF p_line_id <> FND_API.G_MISS_NUM AND
2339: p_payment_number <> FND_API.G_MISS_NUM THEN
2340: --added notification framework
2341: --check code release level first. Notification framework is at Pack H level
2342: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
2343: /* Set the operation on the record so that globals are updated as well */

Line 2362: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2358: , x_msg_count => l_msg_count
2359: , x_msg_data => l_msg_data
2360: , x_return_status => l_return_status
2361: );
2362: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2363: RAISE FND_API.G_EXC_ERROR;
2364: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2365: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2366: END IF;

Line 2363: RAISE FND_API.G_EXC_ERROR;

2359: , x_msg_data => l_msg_data
2360: , x_return_status => l_return_status
2361: );
2362: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2363: RAISE FND_API.G_EXC_ERROR;
2364: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2365: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2366: END IF;
2367: --ER#7479609 end

Line 2364: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2360: , x_return_status => l_return_status
2361: );
2362: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2363: RAISE FND_API.G_EXC_ERROR;
2364: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2365: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2366: END IF;
2367: --ER#7479609 end
2368:

Line 2365: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2361: );
2362: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2363: RAISE FND_API.G_EXC_ERROR;
2364: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2365: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2366: END IF;
2367: --ER#7479609 end
2368:
2369: IF l_debug_level > 0 THEN

Line 2373: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2369: IF l_debug_level > 0 THEN
2370: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_LINE_PAYMENT_UTIL.DELETE_ROW IS: ' || L_RETURN_STATUS ) ;
2371: END IF;
2372:
2373: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2374: IF l_debug_level > 0 THEN
2375: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
2376: END IF;
2377: IF l_debug_level > 0 THEN

Line 2380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2376: END IF;
2377: IF l_debug_level > 0 THEN
2378: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENT_UTIL.DELETE_ROW' , 1 ) ;
2379: END IF;
2380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2381: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2382: IF l_debug_level > 0 THEN
2383: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_PAYMENT_UTIL.DELETE_ROW' ) ;
2384: END IF;

Line 2381: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2377: IF l_debug_level > 0 THEN
2378: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENT_UTIL.DELETE_ROW' , 1 ) ;
2379: END IF;
2380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2381: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2382: IF l_debug_level > 0 THEN
2383: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_PAYMENT_UTIL.DELETE_ROW' ) ;
2384: END IF;
2385: IF l_debug_level > 0 THEN

Line 2388: RAISE FND_API.G_EXC_ERROR;

2384: END IF;
2385: IF l_debug_level > 0 THEN
2386: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENT_UTIL.DELETE_ROW' , 1 ) ;
2387: END IF;
2388: RAISE FND_API.G_EXC_ERROR;
2389: END IF;
2390: END IF; /*code_release_level*/
2391: -- notification framework end
2392:

Line 2454: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2450: x_msg_count => l_msg_count,
2451: x_msg_data => l_msg_data);
2452:
2453:
2454: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2455: IF l_debug_level > 0 THEN
2456: oe_debug_pub.add( '2:Delete Payment OE_LINE_Payment_UTIL.DELETE_ROW - UNEXPECTED ERROR' ) ;
2457: END IF;
2458: IF l_debug_level > 0 THEN

Line 2461: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2457: END IF;
2458: IF l_debug_level > 0 THEN
2459: oe_debug_pub.add( 'EXITING OE_LINE_Payment_UTIL.DELETE_ROW' , 1 ) ;
2460: END IF;
2461: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2462: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2463: IF l_debug_level > 0 THEN
2464: oe_debug_pub.add( '2:Delete Payment OE_LINE_Payment_UTIL.DELETE_ROW' ) ;
2465: END IF;

Line 2462: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2458: IF l_debug_level > 0 THEN
2459: oe_debug_pub.add( 'EXITING OE_LINE_Payment_UTIL.DELETE_ROW' , 1 ) ;
2460: END IF;
2461: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2462: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2463: IF l_debug_level > 0 THEN
2464: oe_debug_pub.add( '2:Delete Payment OE_LINE_Payment_UTIL.DELETE_ROW' ) ;
2465: END IF;
2466: IF l_debug_level > 0 THEN

Line 2469: RAISE FND_API.G_EXC_ERROR;

2465: END IF;
2466: IF l_debug_level > 0 THEN
2467: oe_debug_pub.add( 'EXITING OE_LINE_Payment_UTIL.DELETE_ROW' , 1 ) ;
2468: END IF;
2469: RAISE FND_API.G_EXC_ERROR;
2470: END IF;
2471: END IF;
2472: --R12 CC Encryption
2473:

Line 2494: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2490: x_return_status => l_return_status,
2491: x_msg_count => l_msg_count,
2492: x_msg_data => l_msg_data);
2493:
2494: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2495: IF l_debug_level > 0 THEN
2496: oe_debug_pub.add( 'Delete Payment at Line - UNEXPECTED ERROR' ) ;
2497: END IF;
2498: IF l_debug_level > 0 THEN

Line 2501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2497: END IF;
2498: IF l_debug_level > 0 THEN
2499: oe_debug_pub.add( 'EXITING OE_LINE_Payment_UTIL.DELETE_ROW' , 1 ) ;
2500: END IF;
2501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2502: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2503: IF l_debug_level > 0 THEN
2504: oe_debug_pub.add( 'Delete Payment at Line - OE_LINE_Payment_UTIL.DELETE_ROW' ) ;
2505: END IF;

Line 2502: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2498: IF l_debug_level > 0 THEN
2499: oe_debug_pub.add( 'EXITING OE_LINE_Payment_UTIL.DELETE_ROW' , 1 ) ;
2500: END IF;
2501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2502: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2503: IF l_debug_level > 0 THEN
2504: oe_debug_pub.add( 'Delete Payment at Line - OE_LINE_Payment_UTIL.DELETE_ROW' ) ;
2505: END IF;
2506: IF l_debug_level > 0 THEN

Line 2509: RAISE FND_API.G_EXC_ERROR;

2505: END IF;
2506: IF l_debug_level > 0 THEN
2507: oe_debug_pub.add( 'EXITING OE_LINE_Payment_UTIL.DELETE_ROW' , 1 ) ;
2508: END IF;
2509: RAISE FND_API.G_EXC_ERROR;
2510: END IF;
2511: --3382262
2512:
2513: IF p_payment_type_code = 'CREDIT_CARD' THEN

Line 2526: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2522: , p_msg_data => l_msg_data
2523: , p_return_status => l_return_status
2524: );
2525:
2526: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2527: RAISE FND_API.G_EXC_ERROR;
2528: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2530: END IF;

Line 2527: RAISE FND_API.G_EXC_ERROR;

2523: , p_return_status => l_return_status
2524: );
2525:
2526: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2527: RAISE FND_API.G_EXC_ERROR;
2528: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2530: END IF;
2531: END IF;

Line 2528: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2524: );
2525:
2526: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2527: RAISE FND_API.G_EXC_ERROR;
2528: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2530: END IF;
2531: END IF;
2532:

Line 2529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2525:
2526: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2527: RAISE FND_API.G_EXC_ERROR;
2528: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2530: END IF;
2531: END IF;
2532:
2533: END IF;

Line 2547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2543: , 'Delete_Row'
2544: );
2545: END IF;
2546:
2547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2548:
2549: END Delete_Row;
2550:
2551: -- Procedure Query_Row

Line 2556: FND_API.G_MISS_NUM,

2552: PROCEDURE Query_Row
2553: ( p_payment_number IN NUMBER,
2554: p_line_id IN NUMBER,
2555: p_header_id IN NUMBER :=
2556: FND_API.G_MISS_NUM,
2557: x_Line_Payment_rec IN OUT NOCOPY OE_Order_PUB.Line_Payment_Rec_Type
2558: )
2559: IS
2560: x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

Line 2721: p_payment_number <> FND_API.G_MISS_NUM)

2717:
2718: IF
2719: (p_payment_number IS NOT NULL
2720: AND
2721: p_payment_number <> FND_API.G_MISS_NUM)
2722: AND
2723: (p_line_id IS NOT NULL
2724: AND
2725: p_line_id <> FND_API.G_MISS_NUM)

Line 2725: p_line_id <> FND_API.G_MISS_NUM)

2721: p_payment_number <> FND_API.G_MISS_NUM)
2722: AND
2723: (p_line_id IS NOT NULL
2724: AND
2725: p_line_id <> FND_API.G_MISS_NUM)
2726: AND
2727: (x_Line_Payment_tbl.COUNT = 0)
2728: THEN
2729: RAISE NO_DATA_FOUND;

Line 2734: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2730: END IF;
2731:
2732: EXCEPTION
2733:
2734: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2735:
2736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2737:
2738: WHEN OTHERS THEN

Line 2736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2732: EXCEPTION
2733:
2734: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2735:
2736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2737:
2738: WHEN OTHERS THEN
2739:
2740: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 2748: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2744: , 'Query_Row'
2745: );
2746: END IF;
2747:
2748: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2749:
2750: END Query_Row;
2751:
2752:

Line 2760: FND_API.G_MISS_NUM

2756: --
2757:
2758: Procedure Query_Rows
2759: ( p_payment_number IN NUMBER :=
2760: FND_API.G_MISS_NUM
2761: , p_line_id IN NUMBER :=
2762: FND_API.G_MISS_NUM
2763: , p_header_id IN NUMBER :=
2764: FND_API.G_MISS_NUM

Line 2762: FND_API.G_MISS_NUM

2758: Procedure Query_Rows
2759: ( p_payment_number IN NUMBER :=
2760: FND_API.G_MISS_NUM
2761: , p_line_id IN NUMBER :=
2762: FND_API.G_MISS_NUM
2763: , p_header_id IN NUMBER :=
2764: FND_API.G_MISS_NUM
2765: , x_line_Payment_tbl IN OUT NOCOPY OE_Order_PUB.Line_Payment_Tbl_Type
2766: )

Line 2764: FND_API.G_MISS_NUM

2760: FND_API.G_MISS_NUM
2761: , p_line_id IN NUMBER :=
2762: FND_API.G_MISS_NUM
2763: , p_header_id IN NUMBER :=
2764: FND_API.G_MISS_NUM
2765: , x_line_Payment_tbl IN OUT NOCOPY OE_Order_PUB.Line_Payment_Tbl_Type
2766: )
2767: IS
2768: l_Line_Payment_rec OE_Order_PUB.Line_Payment_Rec_Type;

Line 2924: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2920:
2921:
2922: EXCEPTION
2923:
2924: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2925:
2926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2927:
2928: WHEN OTHERS THEN

Line 2926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2922: EXCEPTION
2923:
2924: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2925:
2926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2927:
2928: WHEN OTHERS THEN
2929:
2930: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 2938: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2934: , 'Query_Rows'
2935: );
2936: END IF;
2937:
2938: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2939:
2940: END Query_Rows;
2941:
2942: -- Procedure lock_Row

Line 2949: := FND_API.G_MISS_NUM

2945: PROCEDURE Lock_Row
2946: ( x_return_status OUT NOCOPY VARCHAR2
2947: , p_x_Line_Payment_rec IN OUT NOCOPY OE_Order_PUB.Line_Payment_Rec_Type
2948: , p_payment_number IN NUMBER
2949: := FND_API.G_MISS_NUM
2950: , p_line_id IN NUMBER
2951: := FND_API.G_MISS_NUM
2952: )
2953: IS

Line 2951: := FND_API.G_MISS_NUM

2947: , p_x_Line_Payment_rec IN OUT NOCOPY OE_Order_PUB.Line_Payment_Rec_Type
2948: , p_payment_number IN NUMBER
2949: := FND_API.G_MISS_NUM
2950: , p_line_id IN NUMBER
2951: := FND_API.G_MISS_NUM
2952: )
2953: IS
2954: l_payment_number NUMBER;
2955: l_line_id NUMBER;

Line 2974: IF p_payment_number <> FND_API.G_MISS_NUM AND

2970: l_lock_control := NULL;
2971:
2972: l_header_id := p_x_line_Payment_rec.header_id;
2973: -- Retrieve the primary key.
2974: IF p_payment_number <> FND_API.G_MISS_NUM AND
2975: p_line_id <> FND_API.G_MISS_NUM THEN
2976: l_payment_number := p_payment_number;
2977: l_line_id := p_line_id;
2978: ELSE

Line 2975: p_line_id <> FND_API.G_MISS_NUM THEN

2971:
2972: l_header_id := p_x_line_Payment_rec.header_id;
2973: -- Retrieve the primary key.
2974: IF p_payment_number <> FND_API.G_MISS_NUM AND
2975: p_line_id <> FND_API.G_MISS_NUM THEN
2976: l_payment_number := p_payment_number;
2977: l_line_id := p_line_id;
2978: ELSE
2979: l_payment_number := p_x_line_Payment_rec.payment_number;

Line 3006: l_lock_control <> FND_API.G_MISS_NUM THEN

3002:
3003: -- If lock_control is null / missing, then return the locked record.
3004:
3005: IF l_lock_control is null OR
3006: l_lock_control <> FND_API.G_MISS_NUM THEN
3007:
3008: -- Set return status
3009: x_return_status := FND_API.G_RET_STS_SUCCESS;
3010: p_x_line_Payment_rec.return_status := FND_API.G_RET_STS_SUCCESS;

Line 3009: x_return_status := FND_API.G_RET_STS_SUCCESS;

3005: IF l_lock_control is null OR
3006: l_lock_control <> FND_API.G_MISS_NUM THEN
3007:
3008: -- Set return status
3009: x_return_status := FND_API.G_RET_STS_SUCCESS;
3010: p_x_line_Payment_rec.return_status := FND_API.G_RET_STS_SUCCESS;
3011:
3012: RETURN;
3013:

Line 3010: p_x_line_Payment_rec.return_status := FND_API.G_RET_STS_SUCCESS;

3006: l_lock_control <> FND_API.G_MISS_NUM THEN
3007:
3008: -- Set return status
3009: x_return_status := FND_API.G_RET_STS_SUCCESS;
3010: p_x_line_Payment_rec.return_status := FND_API.G_RET_STS_SUCCESS;
3011:
3012: RETURN;
3013:
3014: END IF;

Line 3029: x_return_status := FND_API.G_RET_STS_SUCCESS;

3025: p_x_Line_Payment_rec := l_Line_Payment_rec;
3026:
3027: -- Set return status
3028:
3029: x_return_status := FND_API.G_RET_STS_SUCCESS;
3030: p_x_Line_Payment_rec.return_status := FND_API.G_RET_STS_SUCCESS;
3031:
3032: ELSE
3033:

Line 3030: p_x_Line_Payment_rec.return_status := FND_API.G_RET_STS_SUCCESS;

3026:
3027: -- Set return status
3028:
3029: x_return_status := FND_API.G_RET_STS_SUCCESS;
3030: p_x_Line_Payment_rec.return_status := FND_API.G_RET_STS_SUCCESS;
3031:
3032: ELSE
3033:
3034: -- Row has changed by another user.

Line 3036: x_return_status := FND_API.G_RET_STS_ERROR;

3032: ELSE
3033:
3034: -- Row has changed by another user.
3035:
3036: x_return_status := FND_API.G_RET_STS_ERROR;
3037: p_x_Line_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
3038:
3039: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3040: THEN

Line 3037: p_x_Line_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;

3033:
3034: -- Row has changed by another user.
3035:
3036: x_return_status := FND_API.G_RET_STS_ERROR;
3037: p_x_Line_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
3038:
3039: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3040: THEN
3041:

Line 3056: x_return_status := FND_API.G_RET_STS_ERROR;

3052: EXCEPTION
3053:
3054: WHEN NO_DATA_FOUND THEN
3055:
3056: x_return_status := FND_API.G_RET_STS_ERROR;
3057: p_x_Line_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
3058:
3059: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3060: THEN

Line 3057: p_x_Line_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;

3053:
3054: WHEN NO_DATA_FOUND THEN
3055:
3056: x_return_status := FND_API.G_RET_STS_ERROR;
3057: p_x_Line_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
3058:
3059: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3060: THEN
3061:

Line 3068: x_return_status := FND_API.G_RET_STS_ERROR;

3064:
3065: END IF;
3066: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
3067:
3068: x_return_status := FND_API.G_RET_STS_ERROR;
3069: p_x_Line_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
3070:
3071: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3072: THEN

Line 3069: p_x_Line_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;

3065: END IF;
3066: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
3067:
3068: x_return_status := FND_API.G_RET_STS_ERROR;
3069: p_x_Line_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
3070:
3071: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3072: THEN
3073:

Line 3080: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3076:
3077: END IF;
3078: WHEN OTHERS THEN
3079:
3080: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3081: p_x_Line_Payment_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3082:
3083: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3084: THEN

Line 3081: p_x_Line_Payment_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3077: END IF;
3078: WHEN OTHERS THEN
3079:
3080: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3081: p_x_Line_Payment_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3082:
3083: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3084: THEN
3085: oe_msg_pub.Add_Exc_Msg

Line 3095: FND_API.G_MISS_NUM

3091: END Lock_Row;
3092:
3093: PROCEDURE Lock_Rows
3094: ( p_payment_number IN NUMBER :=
3095: FND_API.G_MISS_NUM
3096: , p_line_id IN NUMBER :=
3097: FND_API.G_MISS_NUM
3098: , p_header_id IN NUMBER :=
3099: FND_API.G_MISS_NUM

Line 3097: FND_API.G_MISS_NUM

3093: PROCEDURE Lock_Rows
3094: ( p_payment_number IN NUMBER :=
3095: FND_API.G_MISS_NUM
3096: , p_line_id IN NUMBER :=
3097: FND_API.G_MISS_NUM
3098: , p_header_id IN NUMBER :=
3099: FND_API.G_MISS_NUM
3100: , x_line_Payment_tbl OUT NOCOPY OE_Order_PUB.line_Payment_Tbl_Type
3101: , x_return_status OUT NOCOPY VARCHAR2

Line 3099: FND_API.G_MISS_NUM

3095: FND_API.G_MISS_NUM
3096: , p_line_id IN NUMBER :=
3097: FND_API.G_MISS_NUM
3098: , p_header_id IN NUMBER :=
3099: FND_API.G_MISS_NUM
3100: , x_line_Payment_tbl OUT NOCOPY OE_Order_PUB.line_Payment_Tbl_Type
3101: , x_return_status OUT NOCOPY VARCHAR2
3102: )
3103: IS

Line 3122: p_payment_number <> FND_API.G_MISS_NUM) AND

3118: oe_debug_pub.add( 'ENTERING OE_HEADER_PaymentS_UTIL.LOCK_ROWS' , 1 ) ;
3119: END IF;
3120: /*
3121: IF (p_payment_number IS NOT NULL AND
3122: p_payment_number <> FND_API.G_MISS_NUM) AND
3123: (p_line_id IS NOT NULL AND
3124: p_line_id <> FND_API.G_MISS_NUM)
3125: THEN
3126: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 3124: p_line_id <> FND_API.G_MISS_NUM)

3120: /*
3121: IF (p_payment_number IS NOT NULL AND
3122: p_payment_number <> FND_API.G_MISS_NUM) AND
3123: (p_line_id IS NOT NULL AND
3124: p_line_id <> FND_API.G_MISS_NUM)
3125: THEN
3126: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3127: THEN
3128: OE_MSG_PUB.Add_Exc_Msg

Line 3135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3131: , 'Keys are mutually exclusive: payment_number = '||
3132: p_payment_number || ', line_id = '|| p_line_id );
3133: END IF;
3134:
3135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3136:
3137: END IF;
3138: */
3139: IF p_payment_number <> FND_API.G_MISS_NUM AND

Line 3139: IF p_payment_number <> FND_API.G_MISS_NUM AND

3135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3136:
3137: END IF;
3138: */
3139: IF p_payment_number <> FND_API.G_MISS_NUM AND
3140: p_line_id <> FND_API.G_MISS_NUM THEN
3141:
3142: SELECT payment_number
3143: INTO l_payment_number

Line 3140: p_line_id <> FND_API.G_MISS_NUM THEN

3136:
3137: END IF;
3138: */
3139: IF p_payment_number <> FND_API.G_MISS_NUM AND
3140: p_line_id <> FND_API.G_MISS_NUM THEN
3141:
3142: SELECT payment_number
3143: INTO l_payment_number
3144: FROM OE_PAYMENTS

Line 3154: IF p_line_id <> FND_API.G_MISS_NUM THEN

3150: ELSE
3151:
3152: BEGIN
3153:
3154: IF p_line_id <> FND_API.G_MISS_NUM THEN
3155:
3156: SAVEPOINT LOCK_ROWS;
3157: OPEN lock_lin_Payments(p_line_id);
3158:

Line 3189: x_return_status := FND_API.G_RET_STS_SUCCESS;

3185: ,p_header_id => p_header_id
3186: ,x_line_Payment_tbl => x_line_Payment_tbl
3187: );
3188:
3189: x_return_status := FND_API.G_RET_STS_SUCCESS;
3190:
3191: IF l_debug_level > 0 THEN
3192: oe_debug_pub.add( 'EXITING OE_LINE_PAYMENTS_UTIL.LOCK_ROWS' , 1 ) ;
3193: END IF;

Line 3198: x_return_status := FND_API.G_RET_STS_ERROR;

3194:
3195: EXCEPTION
3196: WHEN NO_DATA_FOUND THEN
3197:
3198: x_return_status := FND_API.G_RET_STS_ERROR;
3199:
3200: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3201: THEN
3202: fnd_message.set_name('ONT','OE_LOCK_ROW_DELETED');

Line 3208: x_return_status := FND_API.G_RET_STS_ERROR;

3204: END IF;
3205:
3206: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
3207:
3208: x_return_status := FND_API.G_RET_STS_ERROR;
3209: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3210: THEN
3211: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
3212: OE_MSG_PUB.Add;

Line 3217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3213: END IF;
3214:
3215: WHEN OTHERS THEN
3216:
3217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3218:
3219: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3220: THEN
3221: OE_MSG_PUB.Add_Exc_Msg

Line 3245: p_Line_Payment_rec.payment_collection_event <> FND_API.G_MISS_CHAR) AND

3241: --
3242: BEGIN
3243:
3244: IF (p_Line_Payment_rec.payment_collection_event IS NULL OR
3245: p_Line_Payment_rec.payment_collection_event <> FND_API.G_MISS_CHAR) AND
3246: NOT OE_GLOBALS.Equal(p_Line_Payment_rec.payment_collection_event,
3247: p_old_Line_Payment_rec.payment_collection_event)
3248: THEN
3249: l_Line_Payment_val_rec.payment_collection_event_name := OE_Id_To_Value.payment_collection_event_name

Line 3255: p_Line_Payment_rec.receipt_method_id <> FND_API.G_MISS_NUM) AND

3251: );
3252: END IF;
3253:
3254: IF (p_Line_Payment_rec.receipt_method_id IS NULL OR
3255: p_Line_Payment_rec.receipt_method_id <> FND_API.G_MISS_NUM) AND
3256: NOT OE_GLOBALS.Equal(p_Line_Payment_rec.receipt_method_id,
3257: p_old_Line_Payment_rec.receipt_method_id)
3258: THEN
3259: l_Line_Payment_val_rec.receipt_method := OE_Id_To_Value.Receipt_Method

Line 3265: p_Line_Payment_rec.payment_type_code <> FND_API.G_MISS_CHAR) AND

3261: );
3262: END IF;
3263:
3264: IF (p_Line_Payment_rec.payment_type_code IS NULL OR
3265: p_Line_Payment_rec.payment_type_code <> FND_API.G_MISS_CHAR) AND
3266: NOT OE_GLOBALS.Equal(p_Line_Payment_rec.payment_type_code,
3267: p_old_Line_Payment_rec.payment_type_code)
3268: THEN
3269: l_Line_Payment_val_rec.payment_type := OE_Id_To_Value.payment_type

Line 3293: p_x_Line_Payment_rec.return_status := FND_API.G_RET_STS_SUCCESS;

3289: BEGIN
3290:
3291: -- initialize return_status.
3292:
3293: p_x_Line_Payment_rec.return_status := FND_API.G_RET_STS_SUCCESS;
3294:
3295: -- initialize l_Line_Payment_rec.
3296:
3297:

Line 3299: IF p_Line_Payment_val_rec.payment_collection_event_name <> FND_API.G_MISS_CHAR

3295: -- initialize l_Line_Payment_rec.
3296:
3297:
3298:
3299: IF p_Line_Payment_val_rec.payment_collection_event_name <> FND_API.G_MISS_CHAR
3300: THEN
3301:
3302: IF p_x_Line_Payment_rec.payment_collection_event <> FND_API.G_MISS_CHAR THEN
3303:

Line 3302: IF p_x_Line_Payment_rec.payment_collection_event <> FND_API.G_MISS_CHAR THEN

3298:
3299: IF p_Line_Payment_val_rec.payment_collection_event_name <> FND_API.G_MISS_CHAR
3300: THEN
3301:
3302: IF p_x_Line_Payment_rec.payment_collection_event <> FND_API.G_MISS_CHAR THEN
3303:
3304: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
3305: THEN
3306:

Line 3319: IF p_x_Line_Payment_rec.payment_collection_event = FND_API.G_MISS_CHAR THEN

3315: p_x_Line_Payment_rec.payment_collection_event := OE_Value_To_Id.payment_collection_event_name
3316: ( p_payment_collection_event => p_Line_Payment_val_rec.payment_collection_event_name
3317: );
3318:
3319: IF p_x_Line_Payment_rec.payment_collection_event = FND_API.G_MISS_CHAR THEN
3320: p_x_Line_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
3321: END IF;
3322:
3323: END IF;

Line 3320: p_x_Line_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;

3316: ( p_payment_collection_event => p_Line_Payment_val_rec.payment_collection_event_name
3317: );
3318:
3319: IF p_x_Line_Payment_rec.payment_collection_event = FND_API.G_MISS_CHAR THEN
3320: p_x_Line_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
3321: END IF;
3322:
3323: END IF;
3324:

Line 3327: IF p_Line_Payment_val_rec.payment_type <> FND_API.G_MISS_CHAR

3323: END IF;
3324:
3325: END IF;
3326:
3327: IF p_Line_Payment_val_rec.payment_type <> FND_API.G_MISS_CHAR
3328: THEN
3329:
3330: IF p_x_Line_Payment_rec.payment_type_code <> FND_API.G_MISS_CHAR THEN
3331:

Line 3330: IF p_x_Line_Payment_rec.payment_type_code <> FND_API.G_MISS_CHAR THEN

3326:
3327: IF p_Line_Payment_val_rec.payment_type <> FND_API.G_MISS_CHAR
3328: THEN
3329:
3330: IF p_x_Line_Payment_rec.payment_type_code <> FND_API.G_MISS_CHAR THEN
3331:
3332:
3333: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
3334: THEN

Line 3348: IF p_x_Line_Payment_rec.payment_type_code = FND_API.G_MISS_CHAR THEN

3344: p_x_Line_Payment_rec.payment_type_code := OE_Value_To_Id.payment_type
3345: ( p_payment_type => p_Line_Payment_val_rec.payment_type
3346: );
3347:
3348: IF p_x_Line_Payment_rec.payment_type_code = FND_API.G_MISS_CHAR THEN
3349: p_x_Line_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
3350: END IF;
3351:
3352: END IF;

Line 3349: p_x_Line_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;

3345: ( p_payment_type => p_Line_Payment_val_rec.payment_type
3346: );
3347:
3348: IF p_x_Line_Payment_rec.payment_type_code = FND_API.G_MISS_CHAR THEN
3349: p_x_Line_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
3350: END IF;
3351:
3352: END IF;
3353:

Line 3357: IF p_Line_Payment_val_rec.receipt_method <> FND_API.G_MISS_CHAR

3353:
3354: END IF;
3355:
3356:
3357: IF p_Line_Payment_val_rec.receipt_method <> FND_API.G_MISS_CHAR
3358: THEN
3359:
3360: IF p_x_Line_Payment_rec.receipt_method_id <> FND_API.G_MISS_NUM THEN
3361:

Line 3360: IF p_x_Line_Payment_rec.receipt_method_id <> FND_API.G_MISS_NUM THEN

3356:
3357: IF p_Line_Payment_val_rec.receipt_method <> FND_API.G_MISS_CHAR
3358: THEN
3359:
3360: IF p_x_Line_Payment_rec.receipt_method_id <> FND_API.G_MISS_NUM THEN
3361:
3362:
3363: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
3364: THEN

Line 3378: IF p_x_Line_Payment_rec.receipt_method_id = FND_API.G_MISS_NUM THEN

3374: p_x_Line_Payment_rec.receipt_method_id := OE_Value_To_Id.Receipt_Method
3375: ( p_receipt_method => p_Line_Payment_val_rec.receipt_method
3376: );
3377:
3378: IF p_x_Line_Payment_rec.receipt_method_id = FND_API.G_MISS_NUM THEN
3379: p_x_Line_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
3380: END IF;
3381:
3382: END IF;

Line 3379: p_x_Line_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;

3375: ( p_receipt_method => p_Line_Payment_val_rec.receipt_method
3376: );
3377:
3378: IF p_x_Line_Payment_rec.receipt_method_id = FND_API.G_MISS_NUM THEN
3379: p_x_Line_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
3380: END IF;
3381:
3382: END IF;
3383:

Line 3617: WHEN FND_API.G_EXC_ERROR THEN

3613: X_msg_data => l_msg_data);
3614:
3615: p_x_line_payment_rec.trxn_extension_id := l_trxn_extension_id;
3616: EXCEPTION
3617: WHEN FND_API.G_EXC_ERROR THEN
3618: l_return_status := FND_API.G_RET_STS_ERROR;
3619: RAISE FND_API.G_EXC_ERROR;
3620:
3621: WHEN OTHERS THEN

Line 3618: l_return_status := FND_API.G_RET_STS_ERROR;

3614:
3615: p_x_line_payment_rec.trxn_extension_id := l_trxn_extension_id;
3616: EXCEPTION
3617: WHEN FND_API.G_EXC_ERROR THEN
3618: l_return_status := FND_API.G_RET_STS_ERROR;
3619: RAISE FND_API.G_EXC_ERROR;
3620:
3621: WHEN OTHERS THEN
3622: IF l_debug_level>0 THEN

Line 3619: RAISE FND_API.G_EXC_ERROR;

3615: p_x_line_payment_rec.trxn_extension_id := l_trxn_extension_id;
3616: EXCEPTION
3617: WHEN FND_API.G_EXC_ERROR THEN
3618: l_return_status := FND_API.G_RET_STS_ERROR;
3619: RAISE FND_API.G_EXC_ERROR;
3620:
3621: WHEN OTHERS THEN
3622: IF l_debug_level>0 THEN
3623: oe_debug_pub.add('After call to copy payment trxn - exception'||sqlerrm);

Line 3625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3621: WHEN OTHERS THEN
3622: IF l_debug_level>0 THEN
3623: oe_debug_pub.add('After call to copy payment trxn - exception'||sqlerrm);
3624: END IF;
3625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3626: END;
3627: ELSIF p_x_line_payment_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
3628: IF p_x_line_payment_rec.trxn_extension_id IS NOT NULL
3629: AND p_x_line_payment_rec.trxn_extension_id <> FND_API.G_MISS_NUM

Line 3629: AND p_x_line_payment_rec.trxn_extension_id <> FND_API.G_MISS_NUM

3625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3626: END;
3627: ELSIF p_x_line_payment_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
3628: IF p_x_line_payment_rec.trxn_extension_id IS NOT NULL
3629: AND p_x_line_payment_rec.trxn_extension_id <> FND_API.G_MISS_NUM
3630: AND ((p_x_line_Payment_rec.payment_type_code = 'CREDIT_CARD'
3631: AND OE_GLOBALS.Is_Same_Credit_Card(p_old_line_Payment_rec.credit_card_number,
3632: p_x_line_Payment_rec.credit_card_number,
3633: p_old_line_Payment_rec.cc_instrument_id,

Line 3651: p_x_line_payment_rec.trxn_extension_id = FND_API.G_MISS_NUM THEN

3647: --While changing the payment type from cash, check etc to
3648: --credit card payment type, the operation would be update but the
3649: --transaction extension id would be null.
3650: ELSIF p_x_line_payment_rec.trxn_extension_id IS NULL OR
3651: p_x_line_payment_rec.trxn_extension_id = FND_API.G_MISS_NUM THEN
3652:
3653: IF l_debug_level > 0 THEN
3654: oe_debug_pub.add( 'Inside trxn extension id creation part....');
3655: oe_debug_pub.add(' Operation is UPDATE and Trxn extension id is null...');

Line 3675: RAISE FND_API.G_EXC_ERROR;

3671: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use = 'REQUIRED' AND
3672: p_x_line_Payment_rec.instrument_security_code IS NULL THEN
3673: FND_MESSAGE.SET_NAME('ONT','OE_CC_SECURITY_CODE_REQD');
3674: OE_Msg_Pub.Add;
3675: RAISE FND_API.G_EXC_ERROR;
3676: END IF;
3677: END IF;
3678:
3679: IF NOT OE_GLOBALS.Is_Same_Credit_Card(p_old_line_Payment_rec.credit_card_number,

Line 3733: WHEN FND_API.G_EXC_ERROR THEN

3729: IF l_debug_level>0 THEN
3730: oe_debug_pub.add('New trxn extension id after calling Create_Payment_TRXN:'||l_trxn_extension_id);
3731: END IF;
3732: EXCEPTION
3733: WHEN FND_API.G_EXC_ERROR THEN
3734: OE_MSG_PUB.Count_And_Get
3735: ( p_count => l_msg_count,
3736: p_data => l_msg_data
3737: );

Line 3738: l_return_status := FND_API.G_RET_STS_ERROR;

3734: OE_MSG_PUB.Count_And_Get
3735: ( p_count => l_msg_count,
3736: p_data => l_msg_data
3737: );
3738: l_return_status := FND_API.G_RET_STS_ERROR;
3739: RAISE FND_API.G_EXC_ERROR;
3740:
3741: WHEN OTHERS THEN
3742: OE_MSG_PUB.Count_And_Get

Line 3739: RAISE FND_API.G_EXC_ERROR;

3735: ( p_count => l_msg_count,
3736: p_data => l_msg_data
3737: );
3738: l_return_status := FND_API.G_RET_STS_ERROR;
3739: RAISE FND_API.G_EXC_ERROR;
3740:
3741: WHEN OTHERS THEN
3742: OE_MSG_PUB.Count_And_Get
3743: ( p_count => l_msg_count,

Line 3752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3748: IF l_debug_level > 0 THEN
3749: oe_debug_pub.add( 'OEXUHPMB: ERROR IN CREATE PAYMENT trxn...'||sqlerrm) ;
3750: oe_debug_pub.add('Error messsge ksurendr'||l_return_status);
3751: END IF;
3752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3753: END;
3754: --Trxn extension id exists and an update to some of the
3755: --attributes of the payment transaction has occured. So
3756: --need to call Update_Payment_Trxn API.

Line 3769: RAISE FND_API.G_EXC_ERROR;

3765: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use = 'REQUIRED'
3766: AND p_x_line_Payment_rec.instrument_security_code IS NULL THEN
3767: FND_MESSAGE.SET_NAME('ONT','OE_CC_SECURITY_CODE_REQD');
3768: OE_Msg_Pub.Add;
3769: RAISE FND_API.G_EXC_ERROR;
3770: END IF;
3771: END IF;*/
3772: IF l_debug_level > 0 THEN
3773: oe_debug_pub.add('Verifying whether to call update card API...');

Line 3835: WHEN FND_API.G_EXC_ERROR THEN

3831: oe_debug_pub.add('trxn extension id after calling Update_Payment_TRXN:'||p_x_line_payment_rec.trxn_extension_id);
3832: oe_debug_pub.add( 'id already derived for this credit card');
3833: END IF;
3834: EXCEPTION
3835: WHEN FND_API.G_EXC_ERROR THEN
3836: IF l_debug_level > 0 THEN
3837: oe_debug_pub.add('Update_Payment_TRXN error....exc');
3838: oe_debug_pub.add('After call to Update_Payment_TRXN'||l_return_status);
3839: oe_debug_pub.add('Error'||sqlerrm);

Line 3841: l_return_status := FND_API.G_RET_STS_ERROR;

3837: oe_debug_pub.add('Update_Payment_TRXN error....exc');
3838: oe_debug_pub.add('After call to Update_Payment_TRXN'||l_return_status);
3839: oe_debug_pub.add('Error'||sqlerrm);
3840: END IF;
3841: l_return_status := FND_API.G_RET_STS_ERROR;
3842: OE_MSG_PUB.Count_And_Get
3843: ( p_count => l_msg_count,
3844: p_data => l_msg_data
3845: );

Line 3846: RAISE FND_API.G_EXC_ERROR;

3842: OE_MSG_PUB.Count_And_Get
3843: ( p_count => l_msg_count,
3844: p_data => l_msg_data
3845: );
3846: RAISE FND_API.G_EXC_ERROR;
3847:
3848: WHEN OTHERS THEN
3849: IF l_debug_level > 0 THEN
3850: oe_debug_pub.add('After call to Update_Payment_TRXN --> Unexpected error');

Line 3853: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3849: IF l_debug_level > 0 THEN
3850: oe_debug_pub.add('After call to Update_Payment_TRXN --> Unexpected error');
3851: oe_debug_pub.add('Error message '||sqlerrm);
3852: END IF;
3853: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3854: END;
3855: END IF;
3856: --Operation is Create. Hence need to create a new Trxn extension id
3857: --by calling the Create_trxn_extension API.

Line 3876: RAISE FND_API.G_EXC_ERROR;

3872: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use = 'REQUIRED' AND
3873: p_x_line_Payment_rec.instrument_security_code IS NULL THEN
3874: FND_MESSAGE.SET_NAME('ONT','OE_CC_SECURITY_CODE_REQD');
3875: OE_Msg_Pub.Add;
3876: RAISE FND_API.G_EXC_ERROR;
3877: END IF;
3878: END IF;
3879:
3880: IF NOT OE_GLOBALS.Is_Same_Credit_Card(p_old_line_Payment_rec.credit_card_number,

Line 3937: WHEN FND_API.G_EXC_ERROR THEN

3933: IF l_debug_level>0 THEN
3934: oe_debug_pub.add('New trxn extension id after calling Create_Payment_TRXN:'||l_trxn_extension_id);
3935: END IF;
3936: Exception
3937: WHEN FND_API.G_EXC_ERROR THEN
3938: OE_MSG_PUB.Count_And_Get
3939: ( p_count => l_msg_count,
3940: p_data => l_msg_data
3941: );

Line 3942: l_return_status := FND_API.G_RET_STS_ERROR;

3938: OE_MSG_PUB.Count_And_Get
3939: ( p_count => l_msg_count,
3940: p_data => l_msg_data
3941: );
3942: l_return_status := FND_API.G_RET_STS_ERROR;
3943: RAISE FND_API.G_EXC_ERROR;
3944:
3945: WHEN OTHERS THEN
3946: OE_MSG_PUB.Count_And_Get

Line 3943: RAISE FND_API.G_EXC_ERROR;

3939: ( p_count => l_msg_count,
3940: p_data => l_msg_data
3941: );
3942: l_return_status := FND_API.G_RET_STS_ERROR;
3943: RAISE FND_API.G_EXC_ERROR;
3944:
3945: WHEN OTHERS THEN
3946: OE_MSG_PUB.Count_And_Get
3947: ( p_count => l_msg_count,

Line 3956: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3952: IF l_debug_level > 0 THEN
3953: oe_debug_pub.add( 'OEXUHPMB: ERROR IN CREATE PAYMENT trxn...'||sqlerrm) ;
3954: oe_debug_pub.add('Error messsge ksurendr'||l_return_status);
3955: END IF;
3956: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3957: end;
3958: END IF; --Operation
3959: ELSIF p_x_line_payment_rec.payment_type_code IN ('CHECK','CASH') AND
3960: p_x_line_payment_rec.operation = OE_GLOBALS.G_OPR_UPDATE

Line 3983: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

3979: p_trxn_extension_id => p_old_line_Payment_rec.trxn_extension_id,
3980: P_site_use_id => l_invoice_to_org_id
3981: );
3982:
3983: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3984: RAISE FND_API.G_EXC_ERROR;
3985: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3986: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3987: END IF;

Line 3984: RAISE FND_API.G_EXC_ERROR;

3980: P_site_use_id => l_invoice_to_org_id
3981: );
3982:
3983: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3984: RAISE FND_API.G_EXC_ERROR;
3985: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3986: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3987: END IF;
3988:

Line 3985: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3981: );
3982:
3983: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3984: RAISE FND_API.G_EXC_ERROR;
3985: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3986: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3987: END IF;
3988:
3989: IF l_debug_level > 0 THEN

Line 3986: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3982:
3983: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3984: RAISE FND_API.G_EXC_ERROR;
3985: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3986: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3987: END IF;
3988:
3989: IF l_debug_level > 0 THEN
3990: oe_debug_pub.add('Successful deletion of trxn extension');

Line 4002: WHEN FND_API.G_EXC_ERROR THEN

3998: p_x_line_payment_rec.trxn_extension_id := null;
3999: END IF; --Payment type condtion
4000: --R12 CC Encryption
4001: EXCEPTION
4002: WHEN FND_API.G_EXC_ERROR THEN
4003: IF L_DEBUG_LEVEL > 0 THEN
4004: Oe_debug_pub.add('OEXULPMB.pls - pre_write_process error ');
4005: END if;
4006: p_x_line_payment_rec.return_status := FND_API.G_RET_STS_ERROR;

Line 4006: p_x_line_payment_rec.return_status := FND_API.G_RET_STS_ERROR;

4002: WHEN FND_API.G_EXC_ERROR THEN
4003: IF L_DEBUG_LEVEL > 0 THEN
4004: Oe_debug_pub.add('OEXULPMB.pls - pre_write_process error ');
4005: END if;
4006: p_x_line_payment_rec.return_status := FND_API.G_RET_STS_ERROR;
4007: RAISE FND_API.G_EXC_ERROR;
4008: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4009: IF L_DEBUG_LEVEL > 0 THEN
4010: Oe_debug_pub.add('OEXULPMB.pls - pre_write_process unexpected error ');

Line 4007: RAISE FND_API.G_EXC_ERROR;

4003: IF L_DEBUG_LEVEL > 0 THEN
4004: Oe_debug_pub.add('OEXULPMB.pls - pre_write_process error ');
4005: END if;
4006: p_x_line_payment_rec.return_status := FND_API.G_RET_STS_ERROR;
4007: RAISE FND_API.G_EXC_ERROR;
4008: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4009: IF L_DEBUG_LEVEL > 0 THEN
4010: Oe_debug_pub.add('OEXULPMB.pls - pre_write_process unexpected error ');
4011: END if;

Line 4008: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4004: Oe_debug_pub.add('OEXULPMB.pls - pre_write_process error ');
4005: END if;
4006: p_x_line_payment_rec.return_status := FND_API.G_RET_STS_ERROR;
4007: RAISE FND_API.G_EXC_ERROR;
4008: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4009: IF L_DEBUG_LEVEL > 0 THEN
4010: Oe_debug_pub.add('OEXULPMB.pls - pre_write_process unexpected error ');
4011: END if;
4012: p_x_line_payment_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4012: p_x_line_payment_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4008: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4009: IF L_DEBUG_LEVEL > 0 THEN
4010: Oe_debug_pub.add('OEXULPMB.pls - pre_write_process unexpected error ');
4011: END if;
4012: p_x_line_payment_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4013: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4014: WHEN OTHERS THEN
4015: if l_debug_level > 0 then
4016: oe_debug_pub.add('OEXULPMB.pls - pre_write_process unexpected error ');

Line 4013: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4009: IF L_DEBUG_LEVEL > 0 THEN
4010: Oe_debug_pub.add('OEXULPMB.pls - pre_write_process unexpected error ');
4011: END if;
4012: p_x_line_payment_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4013: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4014: WHEN OTHERS THEN
4015: if l_debug_level > 0 then
4016: oe_debug_pub.add('OEXULPMB.pls - pre_write_process unexpected error ');
4017: end if;

Line 4018: p_x_line_payment_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4014: WHEN OTHERS THEN
4015: if l_debug_level > 0 then
4016: oe_debug_pub.add('OEXULPMB.pls - pre_write_process unexpected error ');
4017: end if;
4018: p_x_line_payment_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4019: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4020:
4021: END Pre_Write_Process;
4022:

Line 4019: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4015: if l_debug_level > 0 then
4016: oe_debug_pub.add('OEXULPMB.pls - pre_write_process unexpected error ');
4017: end if;
4018: p_x_line_payment_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4019: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4020:
4021: END Pre_Write_Process;
4022:
4023: --3382262

Line 4069: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

4065: (p_line_id => p_line_id
4066: ,p_x_line_rec => l_old_line_rec
4067: ,x_return_status => l_return_status
4068: );
4069: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4070: RAISE FND_API.G_EXC_ERROR;
4071: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4072: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4073: END IF;

Line 4070: RAISE FND_API.G_EXC_ERROR;

4066: ,p_x_line_rec => l_old_line_rec
4067: ,x_return_status => l_return_status
4068: );
4069: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4070: RAISE FND_API.G_EXC_ERROR;
4071: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4072: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4073: END IF;
4074:

Line 4071: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4067: ,x_return_status => l_return_status
4068: );
4069: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4070: RAISE FND_API.G_EXC_ERROR;
4071: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4072: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4073: END IF;
4074:
4075: l_line_rec := l_old_line_rec;

Line 4072: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4068: );
4069: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4070: RAISE FND_API.G_EXC_ERROR;
4071: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4072: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4073: END IF;
4074:
4075: l_line_rec := l_old_line_rec;
4076:

Line 4115: WHEN FND_API.G_EXC_ERROR THEN

4111: end if;
4112:
4113: Exception
4114:
4115: WHEN FND_API.G_EXC_ERROR THEN
4116: x_return_status := FND_API.G_RET_STS_ERROR;
4117: OE_MSG_PUB.Count_And_Get
4118: ( p_count => x_msg_count,
4119: p_data => x_msg_data

Line 4116: x_return_status := FND_API.G_RET_STS_ERROR;

4112:
4113: Exception
4114:
4115: WHEN FND_API.G_EXC_ERROR THEN
4116: x_return_status := FND_API.G_RET_STS_ERROR;
4117: OE_MSG_PUB.Count_And_Get
4118: ( p_count => x_msg_count,
4119: p_data => x_msg_data
4120: );

Line 4122: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4118: ( p_count => x_msg_count,
4119: p_data => x_msg_data
4120: );
4121:
4122: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4124: OE_MSG_PUB.Count_And_Get
4125: ( p_count => x_msg_count,
4126: p_data => x_msg_data

Line 4123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4119: p_data => x_msg_data
4120: );
4121:
4122: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4124: OE_MSG_PUB.Count_And_Get
4125: ( p_count => x_msg_count,
4126: p_data => x_msg_data
4127: );

Line 4130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4126: p_data => x_msg_data
4127: );
4128:
4129: WHEN OTHERS THEN
4130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4131: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4132: THEN
4133: OE_MSG_PUB.Add_Exc_Msg
4134: ( G_PKG_NAME