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.

APPS.AR_CHARGE_SCHEDULE_PKG dependencies on FND_API

Line 61: DECODE(P_SCHEDULE_DESCRIPTION,FND_API.G_MISS_CHAR,NULL,P_SCHEDULE_DESCRIPTION),

57: LAST_UPDATE_LOGIN)
58: VALUES
59: (P_SCHEDULE_ID ,
60: P_SCHEDULE_NAME ,
61: DECODE(P_SCHEDULE_DESCRIPTION,FND_API.G_MISS_CHAR,NULL,P_SCHEDULE_DESCRIPTION),
62: DECODE(P_ATTRIBUTE_CATEGORY,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE_CATEGORY),
63: DECODE(P_ATTRIBUTE1 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE1),
64: DECODE(P_ATTRIBUTE2 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE2),
65: DECODE(P_ATTRIBUTE3 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE3),

Line 62: DECODE(P_ATTRIBUTE_CATEGORY,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE_CATEGORY),

58: VALUES
59: (P_SCHEDULE_ID ,
60: P_SCHEDULE_NAME ,
61: DECODE(P_SCHEDULE_DESCRIPTION,FND_API.G_MISS_CHAR,NULL,P_SCHEDULE_DESCRIPTION),
62: DECODE(P_ATTRIBUTE_CATEGORY,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE_CATEGORY),
63: DECODE(P_ATTRIBUTE1 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE1),
64: DECODE(P_ATTRIBUTE2 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE2),
65: DECODE(P_ATTRIBUTE3 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE3),
66: DECODE(P_ATTRIBUTE4 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE4),

Line 63: DECODE(P_ATTRIBUTE1 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE1),

59: (P_SCHEDULE_ID ,
60: P_SCHEDULE_NAME ,
61: DECODE(P_SCHEDULE_DESCRIPTION,FND_API.G_MISS_CHAR,NULL,P_SCHEDULE_DESCRIPTION),
62: DECODE(P_ATTRIBUTE_CATEGORY,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE_CATEGORY),
63: DECODE(P_ATTRIBUTE1 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE1),
64: DECODE(P_ATTRIBUTE2 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE2),
65: DECODE(P_ATTRIBUTE3 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE3),
66: DECODE(P_ATTRIBUTE4 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE4),
67: DECODE(P_ATTRIBUTE5 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE5),

Line 64: DECODE(P_ATTRIBUTE2 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE2),

60: P_SCHEDULE_NAME ,
61: DECODE(P_SCHEDULE_DESCRIPTION,FND_API.G_MISS_CHAR,NULL,P_SCHEDULE_DESCRIPTION),
62: DECODE(P_ATTRIBUTE_CATEGORY,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE_CATEGORY),
63: DECODE(P_ATTRIBUTE1 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE1),
64: DECODE(P_ATTRIBUTE2 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE2),
65: DECODE(P_ATTRIBUTE3 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE3),
66: DECODE(P_ATTRIBUTE4 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE4),
67: DECODE(P_ATTRIBUTE5 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE5),
68: DECODE(P_ATTRIBUTE6 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE6),

Line 65: DECODE(P_ATTRIBUTE3 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE3),

61: DECODE(P_SCHEDULE_DESCRIPTION,FND_API.G_MISS_CHAR,NULL,P_SCHEDULE_DESCRIPTION),
62: DECODE(P_ATTRIBUTE_CATEGORY,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE_CATEGORY),
63: DECODE(P_ATTRIBUTE1 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE1),
64: DECODE(P_ATTRIBUTE2 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE2),
65: DECODE(P_ATTRIBUTE3 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE3),
66: DECODE(P_ATTRIBUTE4 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE4),
67: DECODE(P_ATTRIBUTE5 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE5),
68: DECODE(P_ATTRIBUTE6 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE6),
69: DECODE(P_ATTRIBUTE7 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE7),

Line 66: DECODE(P_ATTRIBUTE4 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE4),

62: DECODE(P_ATTRIBUTE_CATEGORY,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE_CATEGORY),
63: DECODE(P_ATTRIBUTE1 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE1),
64: DECODE(P_ATTRIBUTE2 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE2),
65: DECODE(P_ATTRIBUTE3 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE3),
66: DECODE(P_ATTRIBUTE4 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE4),
67: DECODE(P_ATTRIBUTE5 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE5),
68: DECODE(P_ATTRIBUTE6 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE6),
69: DECODE(P_ATTRIBUTE7 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE7),
70: DECODE(P_ATTRIBUTE8 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE8),

Line 67: DECODE(P_ATTRIBUTE5 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE5),

63: DECODE(P_ATTRIBUTE1 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE1),
64: DECODE(P_ATTRIBUTE2 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE2),
65: DECODE(P_ATTRIBUTE3 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE3),
66: DECODE(P_ATTRIBUTE4 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE4),
67: DECODE(P_ATTRIBUTE5 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE5),
68: DECODE(P_ATTRIBUTE6 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE6),
69: DECODE(P_ATTRIBUTE7 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE7),
70: DECODE(P_ATTRIBUTE8 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE8),
71: DECODE(P_ATTRIBUTE9 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE9),

Line 68: DECODE(P_ATTRIBUTE6 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE6),

64: DECODE(P_ATTRIBUTE2 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE2),
65: DECODE(P_ATTRIBUTE3 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE3),
66: DECODE(P_ATTRIBUTE4 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE4),
67: DECODE(P_ATTRIBUTE5 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE5),
68: DECODE(P_ATTRIBUTE6 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE6),
69: DECODE(P_ATTRIBUTE7 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE7),
70: DECODE(P_ATTRIBUTE8 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE8),
71: DECODE(P_ATTRIBUTE9 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE9),
72: DECODE(P_ATTRIBUTE10 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE10),

Line 69: DECODE(P_ATTRIBUTE7 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE7),

65: DECODE(P_ATTRIBUTE3 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE3),
66: DECODE(P_ATTRIBUTE4 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE4),
67: DECODE(P_ATTRIBUTE5 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE5),
68: DECODE(P_ATTRIBUTE6 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE6),
69: DECODE(P_ATTRIBUTE7 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE7),
70: DECODE(P_ATTRIBUTE8 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE8),
71: DECODE(P_ATTRIBUTE9 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE9),
72: DECODE(P_ATTRIBUTE10 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE10),
73: DECODE(P_ATTRIBUTE11 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE11),

Line 70: DECODE(P_ATTRIBUTE8 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE8),

66: DECODE(P_ATTRIBUTE4 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE4),
67: DECODE(P_ATTRIBUTE5 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE5),
68: DECODE(P_ATTRIBUTE6 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE6),
69: DECODE(P_ATTRIBUTE7 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE7),
70: DECODE(P_ATTRIBUTE8 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE8),
71: DECODE(P_ATTRIBUTE9 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE9),
72: DECODE(P_ATTRIBUTE10 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE10),
73: DECODE(P_ATTRIBUTE11 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE11),
74: DECODE(P_ATTRIBUTE12 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE12),

Line 71: DECODE(P_ATTRIBUTE9 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE9),

67: DECODE(P_ATTRIBUTE5 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE5),
68: DECODE(P_ATTRIBUTE6 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE6),
69: DECODE(P_ATTRIBUTE7 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE7),
70: DECODE(P_ATTRIBUTE8 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE8),
71: DECODE(P_ATTRIBUTE9 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE9),
72: DECODE(P_ATTRIBUTE10 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE10),
73: DECODE(P_ATTRIBUTE11 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE11),
74: DECODE(P_ATTRIBUTE12 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE12),
75: DECODE(P_ATTRIBUTE13 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE13),

Line 72: DECODE(P_ATTRIBUTE10 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE10),

68: DECODE(P_ATTRIBUTE6 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE6),
69: DECODE(P_ATTRIBUTE7 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE7),
70: DECODE(P_ATTRIBUTE8 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE8),
71: DECODE(P_ATTRIBUTE9 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE9),
72: DECODE(P_ATTRIBUTE10 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE10),
73: DECODE(P_ATTRIBUTE11 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE11),
74: DECODE(P_ATTRIBUTE12 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE12),
75: DECODE(P_ATTRIBUTE13 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE13),
76: DECODE(P_ATTRIBUTE14 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE14),

Line 73: DECODE(P_ATTRIBUTE11 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE11),

69: DECODE(P_ATTRIBUTE7 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE7),
70: DECODE(P_ATTRIBUTE8 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE8),
71: DECODE(P_ATTRIBUTE9 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE9),
72: DECODE(P_ATTRIBUTE10 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE10),
73: DECODE(P_ATTRIBUTE11 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE11),
74: DECODE(P_ATTRIBUTE12 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE12),
75: DECODE(P_ATTRIBUTE13 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE13),
76: DECODE(P_ATTRIBUTE14 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE14),
77: DECODE(P_ATTRIBUTE15 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE15),

Line 74: DECODE(P_ATTRIBUTE12 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE12),

70: DECODE(P_ATTRIBUTE8 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE8),
71: DECODE(P_ATTRIBUTE9 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE9),
72: DECODE(P_ATTRIBUTE10 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE10),
73: DECODE(P_ATTRIBUTE11 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE11),
74: DECODE(P_ATTRIBUTE12 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE12),
75: DECODE(P_ATTRIBUTE13 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE13),
76: DECODE(P_ATTRIBUTE14 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE14),
77: DECODE(P_ATTRIBUTE15 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE15),
78: p_object_version_number,

Line 75: DECODE(P_ATTRIBUTE13 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE13),

71: DECODE(P_ATTRIBUTE9 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE9),
72: DECODE(P_ATTRIBUTE10 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE10),
73: DECODE(P_ATTRIBUTE11 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE11),
74: DECODE(P_ATTRIBUTE12 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE12),
75: DECODE(P_ATTRIBUTE13 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE13),
76: DECODE(P_ATTRIBUTE14 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE14),
77: DECODE(P_ATTRIBUTE15 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE15),
78: p_object_version_number,
79: NVL(FND_GLOBAL.user_id,-1),

Line 76: DECODE(P_ATTRIBUTE14 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE14),

72: DECODE(P_ATTRIBUTE10 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE10),
73: DECODE(P_ATTRIBUTE11 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE11),
74: DECODE(P_ATTRIBUTE12 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE12),
75: DECODE(P_ATTRIBUTE13 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE13),
76: DECODE(P_ATTRIBUTE14 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE14),
77: DECODE(P_ATTRIBUTE15 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE15),
78: p_object_version_number,
79: NVL(FND_GLOBAL.user_id,-1),
80: TRUNC(SYSDATE),

Line 77: DECODE(P_ATTRIBUTE15 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE15),

73: DECODE(P_ATTRIBUTE11 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE11),
74: DECODE(P_ATTRIBUTE12 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE12),
75: DECODE(P_ATTRIBUTE13 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE13),
76: DECODE(P_ATTRIBUTE14 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE14),
77: DECODE(P_ATTRIBUTE15 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE15),
78: p_object_version_number,
79: NVL(FND_GLOBAL.user_id,-1),
80: TRUNC(SYSDATE),
81: NVL(FND_GLOBAL.user_id,-1),

Line 88: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

84:
85: arp_standard.debug('Insert_schedule_Row -');
86: EXCEPTION
87: WHEN OTHERS THEN
88: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
89: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
90: FND_MESSAGE.SET_TOKEN('ERROR' ,'Insert_schedule_Row:'||SQLERRM);
91: FND_MSG_PUB.ADD;
92: END Insert_schedule_Row;

Line 122: FND_API.G_MISS_CHAR, NULL,

118: BEGIN
119: arp_standard.debug('Insert_schedule_Row +');
120: UPDATE AR_CHARGE_SCHEDULES SET
121: SCHEDULE_DESCRIPTION = DECODE(P_SCHEDULE_DESCRIPTION,
122: FND_API.G_MISS_CHAR, NULL,
123: NULL , SCHEDULE_DESCRIPTION, P_SCHEDULE_DESCRIPTION ),
124: ATTRIBUTE_CATEGORY = DECODE(P_ATTRIBUTE_CATEGORY,
125: FND_API.G_MISS_CHAR, NULL,
126: NULL , ATTRIBUTE_CATEGORY, P_ATTRIBUTE_CATEGORY),

Line 125: FND_API.G_MISS_CHAR, NULL,

121: SCHEDULE_DESCRIPTION = DECODE(P_SCHEDULE_DESCRIPTION,
122: FND_API.G_MISS_CHAR, NULL,
123: NULL , SCHEDULE_DESCRIPTION, P_SCHEDULE_DESCRIPTION ),
124: ATTRIBUTE_CATEGORY = DECODE(P_ATTRIBUTE_CATEGORY,
125: FND_API.G_MISS_CHAR, NULL,
126: NULL , ATTRIBUTE_CATEGORY, P_ATTRIBUTE_CATEGORY),
127: ATTRIBUTE1 = DECODE(P_ATTRIBUTE1,
128: FND_API.G_MISS_CHAR, NULL,
129: NULL , ATTRIBUTE1, P_ATTRIBUTE1),

Line 128: FND_API.G_MISS_CHAR, NULL,

124: ATTRIBUTE_CATEGORY = DECODE(P_ATTRIBUTE_CATEGORY,
125: FND_API.G_MISS_CHAR, NULL,
126: NULL , ATTRIBUTE_CATEGORY, P_ATTRIBUTE_CATEGORY),
127: ATTRIBUTE1 = DECODE(P_ATTRIBUTE1,
128: FND_API.G_MISS_CHAR, NULL,
129: NULL , ATTRIBUTE1, P_ATTRIBUTE1),
130: ATTRIBUTE2 = DECODE(P_ATTRIBUTE2,
131: FND_API.G_MISS_CHAR, NULL,
132: NULL , ATTRIBUTE2, P_ATTRIBUTE2),

Line 131: FND_API.G_MISS_CHAR, NULL,

127: ATTRIBUTE1 = DECODE(P_ATTRIBUTE1,
128: FND_API.G_MISS_CHAR, NULL,
129: NULL , ATTRIBUTE1, P_ATTRIBUTE1),
130: ATTRIBUTE2 = DECODE(P_ATTRIBUTE2,
131: FND_API.G_MISS_CHAR, NULL,
132: NULL , ATTRIBUTE2, P_ATTRIBUTE2),
133: ATTRIBUTE3 = DECODE(P_ATTRIBUTE3,
134: FND_API.G_MISS_CHAR, NULL,
135: NULL , ATTRIBUTE3, P_ATTRIBUTE3),

Line 134: FND_API.G_MISS_CHAR, NULL,

130: ATTRIBUTE2 = DECODE(P_ATTRIBUTE2,
131: FND_API.G_MISS_CHAR, NULL,
132: NULL , ATTRIBUTE2, P_ATTRIBUTE2),
133: ATTRIBUTE3 = DECODE(P_ATTRIBUTE3,
134: FND_API.G_MISS_CHAR, NULL,
135: NULL , ATTRIBUTE3, P_ATTRIBUTE3),
136: ATTRIBUTE4 = DECODE(P_ATTRIBUTE4,
137: FND_API.G_MISS_CHAR, NULL,
138: NULL , ATTRIBUTE4, P_ATTRIBUTE4),

Line 137: FND_API.G_MISS_CHAR, NULL,

133: ATTRIBUTE3 = DECODE(P_ATTRIBUTE3,
134: FND_API.G_MISS_CHAR, NULL,
135: NULL , ATTRIBUTE3, P_ATTRIBUTE3),
136: ATTRIBUTE4 = DECODE(P_ATTRIBUTE4,
137: FND_API.G_MISS_CHAR, NULL,
138: NULL , ATTRIBUTE4, P_ATTRIBUTE4),
139: ATTRIBUTE5 = DECODE(P_ATTRIBUTE5,
140: FND_API.G_MISS_CHAR, NULL,
141: NULL , ATTRIBUTE5, P_ATTRIBUTE5),

Line 140: FND_API.G_MISS_CHAR, NULL,

136: ATTRIBUTE4 = DECODE(P_ATTRIBUTE4,
137: FND_API.G_MISS_CHAR, NULL,
138: NULL , ATTRIBUTE4, P_ATTRIBUTE4),
139: ATTRIBUTE5 = DECODE(P_ATTRIBUTE5,
140: FND_API.G_MISS_CHAR, NULL,
141: NULL , ATTRIBUTE5, P_ATTRIBUTE5),
142: ATTRIBUTE6 = DECODE(P_ATTRIBUTE6,
143: FND_API.G_MISS_CHAR, NULL,
144: NULL , ATTRIBUTE6, P_ATTRIBUTE6),

Line 143: FND_API.G_MISS_CHAR, NULL,

139: ATTRIBUTE5 = DECODE(P_ATTRIBUTE5,
140: FND_API.G_MISS_CHAR, NULL,
141: NULL , ATTRIBUTE5, P_ATTRIBUTE5),
142: ATTRIBUTE6 = DECODE(P_ATTRIBUTE6,
143: FND_API.G_MISS_CHAR, NULL,
144: NULL , ATTRIBUTE6, P_ATTRIBUTE6),
145: ATTRIBUTE7 = DECODE(P_ATTRIBUTE7,
146: FND_API.G_MISS_CHAR, NULL,
147: NULL , ATTRIBUTE7, P_ATTRIBUTE7),

Line 146: FND_API.G_MISS_CHAR, NULL,

142: ATTRIBUTE6 = DECODE(P_ATTRIBUTE6,
143: FND_API.G_MISS_CHAR, NULL,
144: NULL , ATTRIBUTE6, P_ATTRIBUTE6),
145: ATTRIBUTE7 = DECODE(P_ATTRIBUTE7,
146: FND_API.G_MISS_CHAR, NULL,
147: NULL , ATTRIBUTE7, P_ATTRIBUTE7),
148: ATTRIBUTE8 = DECODE(P_ATTRIBUTE8,
149: FND_API.G_MISS_CHAR, NULL,
150: NULL , ATTRIBUTE8, P_ATTRIBUTE8),

Line 149: FND_API.G_MISS_CHAR, NULL,

145: ATTRIBUTE7 = DECODE(P_ATTRIBUTE7,
146: FND_API.G_MISS_CHAR, NULL,
147: NULL , ATTRIBUTE7, P_ATTRIBUTE7),
148: ATTRIBUTE8 = DECODE(P_ATTRIBUTE8,
149: FND_API.G_MISS_CHAR, NULL,
150: NULL , ATTRIBUTE8, P_ATTRIBUTE8),
151: ATTRIBUTE9 = DECODE(P_ATTRIBUTE9,
152: FND_API.G_MISS_CHAR, NULL,
153: NULL , ATTRIBUTE9, P_ATTRIBUTE9),

Line 152: FND_API.G_MISS_CHAR, NULL,

148: ATTRIBUTE8 = DECODE(P_ATTRIBUTE8,
149: FND_API.G_MISS_CHAR, NULL,
150: NULL , ATTRIBUTE8, P_ATTRIBUTE8),
151: ATTRIBUTE9 = DECODE(P_ATTRIBUTE9,
152: FND_API.G_MISS_CHAR, NULL,
153: NULL , ATTRIBUTE9, P_ATTRIBUTE9),
154: ATTRIBUTE10 = DECODE(P_ATTRIBUTE10,
155: FND_API.G_MISS_CHAR, NULL,
156: NULL , ATTRIBUTE10, P_ATTRIBUTE10),

Line 155: FND_API.G_MISS_CHAR, NULL,

151: ATTRIBUTE9 = DECODE(P_ATTRIBUTE9,
152: FND_API.G_MISS_CHAR, NULL,
153: NULL , ATTRIBUTE9, P_ATTRIBUTE9),
154: ATTRIBUTE10 = DECODE(P_ATTRIBUTE10,
155: FND_API.G_MISS_CHAR, NULL,
156: NULL , ATTRIBUTE10, P_ATTRIBUTE10),
157: ATTRIBUTE11 = DECODE(P_ATTRIBUTE11,
158: FND_API.G_MISS_CHAR, NULL,
159: NULL , ATTRIBUTE11, P_ATTRIBUTE11),

Line 158: FND_API.G_MISS_CHAR, NULL,

154: ATTRIBUTE10 = DECODE(P_ATTRIBUTE10,
155: FND_API.G_MISS_CHAR, NULL,
156: NULL , ATTRIBUTE10, P_ATTRIBUTE10),
157: ATTRIBUTE11 = DECODE(P_ATTRIBUTE11,
158: FND_API.G_MISS_CHAR, NULL,
159: NULL , ATTRIBUTE11, P_ATTRIBUTE11),
160: ATTRIBUTE12 = DECODE(P_ATTRIBUTE12,
161: FND_API.G_MISS_CHAR, NULL,
162: NULL , ATTRIBUTE12, P_ATTRIBUTE12),

Line 161: FND_API.G_MISS_CHAR, NULL,

157: ATTRIBUTE11 = DECODE(P_ATTRIBUTE11,
158: FND_API.G_MISS_CHAR, NULL,
159: NULL , ATTRIBUTE11, P_ATTRIBUTE11),
160: ATTRIBUTE12 = DECODE(P_ATTRIBUTE12,
161: FND_API.G_MISS_CHAR, NULL,
162: NULL , ATTRIBUTE12, P_ATTRIBUTE12),
163: ATTRIBUTE13 = DECODE(P_ATTRIBUTE13,
164: FND_API.G_MISS_CHAR, NULL,
165: NULL , ATTRIBUTE13, P_ATTRIBUTE13),

Line 164: FND_API.G_MISS_CHAR, NULL,

160: ATTRIBUTE12 = DECODE(P_ATTRIBUTE12,
161: FND_API.G_MISS_CHAR, NULL,
162: NULL , ATTRIBUTE12, P_ATTRIBUTE12),
163: ATTRIBUTE13 = DECODE(P_ATTRIBUTE13,
164: FND_API.G_MISS_CHAR, NULL,
165: NULL , ATTRIBUTE13, P_ATTRIBUTE13),
166: ATTRIBUTE14 = DECODE(P_ATTRIBUTE14,
167: FND_API.G_MISS_CHAR, NULL,
168: NULL , ATTRIBUTE14, P_ATTRIBUTE14),

Line 167: FND_API.G_MISS_CHAR, NULL,

163: ATTRIBUTE13 = DECODE(P_ATTRIBUTE13,
164: FND_API.G_MISS_CHAR, NULL,
165: NULL , ATTRIBUTE13, P_ATTRIBUTE13),
166: ATTRIBUTE14 = DECODE(P_ATTRIBUTE14,
167: FND_API.G_MISS_CHAR, NULL,
168: NULL , ATTRIBUTE14, P_ATTRIBUTE14),
169: ATTRIBUTE15 = DECODE(P_ATTRIBUTE15,
170: FND_API.G_MISS_CHAR, NULL,
171: NULL , ATTRIBUTE15, P_ATTRIBUTE15),

Line 170: FND_API.G_MISS_CHAR, NULL,

166: ATTRIBUTE14 = DECODE(P_ATTRIBUTE14,
167: FND_API.G_MISS_CHAR, NULL,
168: NULL , ATTRIBUTE14, P_ATTRIBUTE14),
169: ATTRIBUTE15 = DECODE(P_ATTRIBUTE15,
170: FND_API.G_MISS_CHAR, NULL,
171: NULL , ATTRIBUTE15, P_ATTRIBUTE15),
172: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
173: LAST_UPDATE_DATE = TRUNC(SYSDATE),
174: LAST_UPDATED_BY = NVL(FND_GLOBAL.user_id,-1),

Line 181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

177: RETURNING OBJECT_VERSION_NUMBER INTO x_OBJECT_VERSION_NUMBER;
178: arp_standard.debug('Insert_schedule_Row -');
179: EXCEPTION
180: WHEN OTHERS THEN
181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
182: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
183: FND_MESSAGE.SET_TOKEN('ERROR' ,'Insert_schedule_Row:'||SQLERRM);
184: FND_MSG_PUB.ADD;
185: END Update_schedule_Row;

Line 257: DECODE(P_END_DATE ,FND_API.G_MISS_DATE,NULL,P_END_DATE),

253: P_SCHEDULE_ID ,
254: P_SCHEDULE_HEADER_TYPE,
255: P_AGING_BUCKET_ID ,
256: P_START_DATE ,
257: DECODE(P_END_DATE ,FND_API.G_MISS_DATE,NULL,P_END_DATE),
258: P_STATUS ,
259: DECODE(P_ATTRIBUTE_CATEGORY,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE_CATEGORY),
260: DECODE(P_ATTRIBUTE1 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE1),
261: DECODE(P_ATTRIBUTE2 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE2),

Line 259: DECODE(P_ATTRIBUTE_CATEGORY,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE_CATEGORY),

255: P_AGING_BUCKET_ID ,
256: P_START_DATE ,
257: DECODE(P_END_DATE ,FND_API.G_MISS_DATE,NULL,P_END_DATE),
258: P_STATUS ,
259: DECODE(P_ATTRIBUTE_CATEGORY,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE_CATEGORY),
260: DECODE(P_ATTRIBUTE1 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE1),
261: DECODE(P_ATTRIBUTE2 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE2),
262: DECODE(P_ATTRIBUTE3 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE3),
263: DECODE(P_ATTRIBUTE4 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE4),

Line 260: DECODE(P_ATTRIBUTE1 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE1),

256: P_START_DATE ,
257: DECODE(P_END_DATE ,FND_API.G_MISS_DATE,NULL,P_END_DATE),
258: P_STATUS ,
259: DECODE(P_ATTRIBUTE_CATEGORY,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE_CATEGORY),
260: DECODE(P_ATTRIBUTE1 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE1),
261: DECODE(P_ATTRIBUTE2 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE2),
262: DECODE(P_ATTRIBUTE3 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE3),
263: DECODE(P_ATTRIBUTE4 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE4),
264: DECODE(P_ATTRIBUTE5 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE5),

Line 261: DECODE(P_ATTRIBUTE2 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE2),

257: DECODE(P_END_DATE ,FND_API.G_MISS_DATE,NULL,P_END_DATE),
258: P_STATUS ,
259: DECODE(P_ATTRIBUTE_CATEGORY,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE_CATEGORY),
260: DECODE(P_ATTRIBUTE1 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE1),
261: DECODE(P_ATTRIBUTE2 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE2),
262: DECODE(P_ATTRIBUTE3 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE3),
263: DECODE(P_ATTRIBUTE4 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE4),
264: DECODE(P_ATTRIBUTE5 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE5),
265: DECODE(P_ATTRIBUTE6 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE6),

Line 262: DECODE(P_ATTRIBUTE3 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE3),

258: P_STATUS ,
259: DECODE(P_ATTRIBUTE_CATEGORY,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE_CATEGORY),
260: DECODE(P_ATTRIBUTE1 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE1),
261: DECODE(P_ATTRIBUTE2 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE2),
262: DECODE(P_ATTRIBUTE3 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE3),
263: DECODE(P_ATTRIBUTE4 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE4),
264: DECODE(P_ATTRIBUTE5 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE5),
265: DECODE(P_ATTRIBUTE6 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE6),
266: DECODE(P_ATTRIBUTE7 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE7),

Line 263: DECODE(P_ATTRIBUTE4 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE4),

259: DECODE(P_ATTRIBUTE_CATEGORY,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE_CATEGORY),
260: DECODE(P_ATTRIBUTE1 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE1),
261: DECODE(P_ATTRIBUTE2 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE2),
262: DECODE(P_ATTRIBUTE3 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE3),
263: DECODE(P_ATTRIBUTE4 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE4),
264: DECODE(P_ATTRIBUTE5 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE5),
265: DECODE(P_ATTRIBUTE6 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE6),
266: DECODE(P_ATTRIBUTE7 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE7),
267: DECODE(P_ATTRIBUTE8 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE8),

Line 264: DECODE(P_ATTRIBUTE5 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE5),

260: DECODE(P_ATTRIBUTE1 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE1),
261: DECODE(P_ATTRIBUTE2 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE2),
262: DECODE(P_ATTRIBUTE3 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE3),
263: DECODE(P_ATTRIBUTE4 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE4),
264: DECODE(P_ATTRIBUTE5 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE5),
265: DECODE(P_ATTRIBUTE6 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE6),
266: DECODE(P_ATTRIBUTE7 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE7),
267: DECODE(P_ATTRIBUTE8 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE8),
268: DECODE(P_ATTRIBUTE9 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE9),

Line 265: DECODE(P_ATTRIBUTE6 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE6),

261: DECODE(P_ATTRIBUTE2 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE2),
262: DECODE(P_ATTRIBUTE3 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE3),
263: DECODE(P_ATTRIBUTE4 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE4),
264: DECODE(P_ATTRIBUTE5 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE5),
265: DECODE(P_ATTRIBUTE6 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE6),
266: DECODE(P_ATTRIBUTE7 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE7),
267: DECODE(P_ATTRIBUTE8 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE8),
268: DECODE(P_ATTRIBUTE9 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE9),
269: DECODE(P_ATTRIBUTE10 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE10),

Line 266: DECODE(P_ATTRIBUTE7 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE7),

262: DECODE(P_ATTRIBUTE3 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE3),
263: DECODE(P_ATTRIBUTE4 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE4),
264: DECODE(P_ATTRIBUTE5 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE5),
265: DECODE(P_ATTRIBUTE6 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE6),
266: DECODE(P_ATTRIBUTE7 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE7),
267: DECODE(P_ATTRIBUTE8 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE8),
268: DECODE(P_ATTRIBUTE9 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE9),
269: DECODE(P_ATTRIBUTE10 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE10),
270: DECODE(P_ATTRIBUTE11 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE11),

Line 267: DECODE(P_ATTRIBUTE8 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE8),

263: DECODE(P_ATTRIBUTE4 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE4),
264: DECODE(P_ATTRIBUTE5 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE5),
265: DECODE(P_ATTRIBUTE6 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE6),
266: DECODE(P_ATTRIBUTE7 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE7),
267: DECODE(P_ATTRIBUTE8 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE8),
268: DECODE(P_ATTRIBUTE9 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE9),
269: DECODE(P_ATTRIBUTE10 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE10),
270: DECODE(P_ATTRIBUTE11 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE11),
271: DECODE(P_ATTRIBUTE12 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE12),

Line 268: DECODE(P_ATTRIBUTE9 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE9),

264: DECODE(P_ATTRIBUTE5 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE5),
265: DECODE(P_ATTRIBUTE6 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE6),
266: DECODE(P_ATTRIBUTE7 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE7),
267: DECODE(P_ATTRIBUTE8 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE8),
268: DECODE(P_ATTRIBUTE9 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE9),
269: DECODE(P_ATTRIBUTE10 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE10),
270: DECODE(P_ATTRIBUTE11 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE11),
271: DECODE(P_ATTRIBUTE12 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE12),
272: DECODE(P_ATTRIBUTE13 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE13),

Line 269: DECODE(P_ATTRIBUTE10 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE10),

265: DECODE(P_ATTRIBUTE6 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE6),
266: DECODE(P_ATTRIBUTE7 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE7),
267: DECODE(P_ATTRIBUTE8 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE8),
268: DECODE(P_ATTRIBUTE9 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE9),
269: DECODE(P_ATTRIBUTE10 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE10),
270: DECODE(P_ATTRIBUTE11 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE11),
271: DECODE(P_ATTRIBUTE12 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE12),
272: DECODE(P_ATTRIBUTE13 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE13),
273: DECODE(P_ATTRIBUTE14 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE14),

Line 270: DECODE(P_ATTRIBUTE11 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE11),

266: DECODE(P_ATTRIBUTE7 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE7),
267: DECODE(P_ATTRIBUTE8 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE8),
268: DECODE(P_ATTRIBUTE9 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE9),
269: DECODE(P_ATTRIBUTE10 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE10),
270: DECODE(P_ATTRIBUTE11 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE11),
271: DECODE(P_ATTRIBUTE12 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE12),
272: DECODE(P_ATTRIBUTE13 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE13),
273: DECODE(P_ATTRIBUTE14 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE14),
274: DECODE(P_ATTRIBUTE15 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE15),

Line 271: DECODE(P_ATTRIBUTE12 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE12),

267: DECODE(P_ATTRIBUTE8 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE8),
268: DECODE(P_ATTRIBUTE9 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE9),
269: DECODE(P_ATTRIBUTE10 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE10),
270: DECODE(P_ATTRIBUTE11 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE11),
271: DECODE(P_ATTRIBUTE12 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE12),
272: DECODE(P_ATTRIBUTE13 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE13),
273: DECODE(P_ATTRIBUTE14 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE14),
274: DECODE(P_ATTRIBUTE15 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE15),
275: P_OBJECT_VERSION_NUMBER,

Line 272: DECODE(P_ATTRIBUTE13 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE13),

268: DECODE(P_ATTRIBUTE9 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE9),
269: DECODE(P_ATTRIBUTE10 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE10),
270: DECODE(P_ATTRIBUTE11 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE11),
271: DECODE(P_ATTRIBUTE12 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE12),
272: DECODE(P_ATTRIBUTE13 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE13),
273: DECODE(P_ATTRIBUTE14 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE14),
274: DECODE(P_ATTRIBUTE15 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE15),
275: P_OBJECT_VERSION_NUMBER,
276: NVL(FND_GLOBAL.user_id,-1),

Line 273: DECODE(P_ATTRIBUTE14 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE14),

269: DECODE(P_ATTRIBUTE10 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE10),
270: DECODE(P_ATTRIBUTE11 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE11),
271: DECODE(P_ATTRIBUTE12 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE12),
272: DECODE(P_ATTRIBUTE13 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE13),
273: DECODE(P_ATTRIBUTE14 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE14),
274: DECODE(P_ATTRIBUTE15 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE15),
275: P_OBJECT_VERSION_NUMBER,
276: NVL(FND_GLOBAL.user_id,-1),
277: TRUNC(SYSDATE),

Line 274: DECODE(P_ATTRIBUTE15 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE15),

270: DECODE(P_ATTRIBUTE11 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE11),
271: DECODE(P_ATTRIBUTE12 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE12),
272: DECODE(P_ATTRIBUTE13 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE13),
273: DECODE(P_ATTRIBUTE14 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE14),
274: DECODE(P_ATTRIBUTE15 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE15),
275: P_OBJECT_VERSION_NUMBER,
276: NVL(FND_GLOBAL.user_id,-1),
277: TRUNC(SYSDATE),
278: NVL(FND_GLOBAL.user_id,-1),

Line 285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

281:
282: arp_standard.debug('Insert_Head_Row -');
283: EXCEPTION
284: WHEN OTHERS THEN
285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
286: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
287: FND_MESSAGE.SET_TOKEN('ERROR' ,'Insert_Head_Row:'||SQLERRM);
288: FND_MSG_PUB.ADD;
289: END Insert_Head_Row;

Line 328: FND_API.G_MISS_DATE, NULL,

324: arp_standard.debug('Update_Head_Row +');
325:
326: UPDATE ar_charge_schedule_hdrs SET
327: END_DATE = DECODE(P_END_DATE,
328: FND_API.G_MISS_DATE, NULL,
329: NULL , END_DATE, P_END_DATE ),
330: STATUS = DECODE(P_STATUS,
331: FND_API.G_MISS_CHAR, NULL,
332: NULL , STATUS, P_STATUS ),

Line 331: FND_API.G_MISS_CHAR, NULL,

327: END_DATE = DECODE(P_END_DATE,
328: FND_API.G_MISS_DATE, NULL,
329: NULL , END_DATE, P_END_DATE ),
330: STATUS = DECODE(P_STATUS,
331: FND_API.G_MISS_CHAR, NULL,
332: NULL , STATUS, P_STATUS ),
333: ATTRIBUTE_CATEGORY = DECODE(P_ATTRIBUTE_CATEGORY,
334: FND_API.G_MISS_CHAR, NULL,
335: NULL , ATTRIBUTE_CATEGORY, P_ATTRIBUTE_CATEGORY),

Line 334: FND_API.G_MISS_CHAR, NULL,

330: STATUS = DECODE(P_STATUS,
331: FND_API.G_MISS_CHAR, NULL,
332: NULL , STATUS, P_STATUS ),
333: ATTRIBUTE_CATEGORY = DECODE(P_ATTRIBUTE_CATEGORY,
334: FND_API.G_MISS_CHAR, NULL,
335: NULL , ATTRIBUTE_CATEGORY, P_ATTRIBUTE_CATEGORY),
336: ATTRIBUTE1 = DECODE(P_ATTRIBUTE1,
337: FND_API.G_MISS_CHAR, NULL,
338: NULL , ATTRIBUTE1, P_ATTRIBUTE1),

Line 337: FND_API.G_MISS_CHAR, NULL,

333: ATTRIBUTE_CATEGORY = DECODE(P_ATTRIBUTE_CATEGORY,
334: FND_API.G_MISS_CHAR, NULL,
335: NULL , ATTRIBUTE_CATEGORY, P_ATTRIBUTE_CATEGORY),
336: ATTRIBUTE1 = DECODE(P_ATTRIBUTE1,
337: FND_API.G_MISS_CHAR, NULL,
338: NULL , ATTRIBUTE1, P_ATTRIBUTE1),
339: ATTRIBUTE2 = DECODE(P_ATTRIBUTE2,
340: FND_API.G_MISS_CHAR, NULL,
341: NULL , ATTRIBUTE2, P_ATTRIBUTE2),

Line 340: FND_API.G_MISS_CHAR, NULL,

336: ATTRIBUTE1 = DECODE(P_ATTRIBUTE1,
337: FND_API.G_MISS_CHAR, NULL,
338: NULL , ATTRIBUTE1, P_ATTRIBUTE1),
339: ATTRIBUTE2 = DECODE(P_ATTRIBUTE2,
340: FND_API.G_MISS_CHAR, NULL,
341: NULL , ATTRIBUTE2, P_ATTRIBUTE2),
342: ATTRIBUTE3 = DECODE(P_ATTRIBUTE3,
343: FND_API.G_MISS_CHAR, NULL,
344: NULL , ATTRIBUTE3, P_ATTRIBUTE3),

Line 343: FND_API.G_MISS_CHAR, NULL,

339: ATTRIBUTE2 = DECODE(P_ATTRIBUTE2,
340: FND_API.G_MISS_CHAR, NULL,
341: NULL , ATTRIBUTE2, P_ATTRIBUTE2),
342: ATTRIBUTE3 = DECODE(P_ATTRIBUTE3,
343: FND_API.G_MISS_CHAR, NULL,
344: NULL , ATTRIBUTE3, P_ATTRIBUTE3),
345: ATTRIBUTE4 = DECODE(P_ATTRIBUTE4,
346: FND_API.G_MISS_CHAR, NULL,
347: NULL , ATTRIBUTE4, P_ATTRIBUTE4),

Line 346: FND_API.G_MISS_CHAR, NULL,

342: ATTRIBUTE3 = DECODE(P_ATTRIBUTE3,
343: FND_API.G_MISS_CHAR, NULL,
344: NULL , ATTRIBUTE3, P_ATTRIBUTE3),
345: ATTRIBUTE4 = DECODE(P_ATTRIBUTE4,
346: FND_API.G_MISS_CHAR, NULL,
347: NULL , ATTRIBUTE4, P_ATTRIBUTE4),
348: ATTRIBUTE5 = DECODE(P_ATTRIBUTE5,
349: FND_API.G_MISS_CHAR, NULL,
350: NULL , ATTRIBUTE5, P_ATTRIBUTE5),

Line 349: FND_API.G_MISS_CHAR, NULL,

345: ATTRIBUTE4 = DECODE(P_ATTRIBUTE4,
346: FND_API.G_MISS_CHAR, NULL,
347: NULL , ATTRIBUTE4, P_ATTRIBUTE4),
348: ATTRIBUTE5 = DECODE(P_ATTRIBUTE5,
349: FND_API.G_MISS_CHAR, NULL,
350: NULL , ATTRIBUTE5, P_ATTRIBUTE5),
351: ATTRIBUTE6 = DECODE(P_ATTRIBUTE6,
352: FND_API.G_MISS_CHAR, NULL,
353: NULL , ATTRIBUTE6, P_ATTRIBUTE6),

Line 352: FND_API.G_MISS_CHAR, NULL,

348: ATTRIBUTE5 = DECODE(P_ATTRIBUTE5,
349: FND_API.G_MISS_CHAR, NULL,
350: NULL , ATTRIBUTE5, P_ATTRIBUTE5),
351: ATTRIBUTE6 = DECODE(P_ATTRIBUTE6,
352: FND_API.G_MISS_CHAR, NULL,
353: NULL , ATTRIBUTE6, P_ATTRIBUTE6),
354: ATTRIBUTE7 = DECODE(P_ATTRIBUTE7,
355: FND_API.G_MISS_CHAR, NULL,
356: NULL , ATTRIBUTE7, P_ATTRIBUTE7),

Line 355: FND_API.G_MISS_CHAR, NULL,

351: ATTRIBUTE6 = DECODE(P_ATTRIBUTE6,
352: FND_API.G_MISS_CHAR, NULL,
353: NULL , ATTRIBUTE6, P_ATTRIBUTE6),
354: ATTRIBUTE7 = DECODE(P_ATTRIBUTE7,
355: FND_API.G_MISS_CHAR, NULL,
356: NULL , ATTRIBUTE7, P_ATTRIBUTE7),
357: ATTRIBUTE8 = DECODE(P_ATTRIBUTE8,
358: FND_API.G_MISS_CHAR, NULL,
359: NULL , ATTRIBUTE8, P_ATTRIBUTE8),

Line 358: FND_API.G_MISS_CHAR, NULL,

354: ATTRIBUTE7 = DECODE(P_ATTRIBUTE7,
355: FND_API.G_MISS_CHAR, NULL,
356: NULL , ATTRIBUTE7, P_ATTRIBUTE7),
357: ATTRIBUTE8 = DECODE(P_ATTRIBUTE8,
358: FND_API.G_MISS_CHAR, NULL,
359: NULL , ATTRIBUTE8, P_ATTRIBUTE8),
360: ATTRIBUTE9 = DECODE(P_ATTRIBUTE9,
361: FND_API.G_MISS_CHAR, NULL,
362: NULL , ATTRIBUTE9, P_ATTRIBUTE9),

Line 361: FND_API.G_MISS_CHAR, NULL,

357: ATTRIBUTE8 = DECODE(P_ATTRIBUTE8,
358: FND_API.G_MISS_CHAR, NULL,
359: NULL , ATTRIBUTE8, P_ATTRIBUTE8),
360: ATTRIBUTE9 = DECODE(P_ATTRIBUTE9,
361: FND_API.G_MISS_CHAR, NULL,
362: NULL , ATTRIBUTE9, P_ATTRIBUTE9),
363: ATTRIBUTE10 = DECODE(P_ATTRIBUTE10,
364: FND_API.G_MISS_CHAR, NULL,
365: NULL , ATTRIBUTE10, P_ATTRIBUTE10),

Line 364: FND_API.G_MISS_CHAR, NULL,

360: ATTRIBUTE9 = DECODE(P_ATTRIBUTE9,
361: FND_API.G_MISS_CHAR, NULL,
362: NULL , ATTRIBUTE9, P_ATTRIBUTE9),
363: ATTRIBUTE10 = DECODE(P_ATTRIBUTE10,
364: FND_API.G_MISS_CHAR, NULL,
365: NULL , ATTRIBUTE10, P_ATTRIBUTE10),
366: ATTRIBUTE11 = DECODE(P_ATTRIBUTE11,
367: FND_API.G_MISS_CHAR, NULL,
368: NULL , ATTRIBUTE11, P_ATTRIBUTE11),

Line 367: FND_API.G_MISS_CHAR, NULL,

363: ATTRIBUTE10 = DECODE(P_ATTRIBUTE10,
364: FND_API.G_MISS_CHAR, NULL,
365: NULL , ATTRIBUTE10, P_ATTRIBUTE10),
366: ATTRIBUTE11 = DECODE(P_ATTRIBUTE11,
367: FND_API.G_MISS_CHAR, NULL,
368: NULL , ATTRIBUTE11, P_ATTRIBUTE11),
369: ATTRIBUTE12 = DECODE(P_ATTRIBUTE12,
370: FND_API.G_MISS_CHAR, NULL,
371: NULL , ATTRIBUTE12, P_ATTRIBUTE12),

Line 370: FND_API.G_MISS_CHAR, NULL,

366: ATTRIBUTE11 = DECODE(P_ATTRIBUTE11,
367: FND_API.G_MISS_CHAR, NULL,
368: NULL , ATTRIBUTE11, P_ATTRIBUTE11),
369: ATTRIBUTE12 = DECODE(P_ATTRIBUTE12,
370: FND_API.G_MISS_CHAR, NULL,
371: NULL , ATTRIBUTE12, P_ATTRIBUTE12),
372: ATTRIBUTE13 = DECODE(P_ATTRIBUTE13,
373: FND_API.G_MISS_CHAR, NULL,
374: NULL , ATTRIBUTE13, P_ATTRIBUTE13),

Line 373: FND_API.G_MISS_CHAR, NULL,

369: ATTRIBUTE12 = DECODE(P_ATTRIBUTE12,
370: FND_API.G_MISS_CHAR, NULL,
371: NULL , ATTRIBUTE12, P_ATTRIBUTE12),
372: ATTRIBUTE13 = DECODE(P_ATTRIBUTE13,
373: FND_API.G_MISS_CHAR, NULL,
374: NULL , ATTRIBUTE13, P_ATTRIBUTE13),
375: ATTRIBUTE14 = DECODE(P_ATTRIBUTE14,
376: FND_API.G_MISS_CHAR, NULL,
377: NULL , ATTRIBUTE14, P_ATTRIBUTE14),

Line 376: FND_API.G_MISS_CHAR, NULL,

372: ATTRIBUTE13 = DECODE(P_ATTRIBUTE13,
373: FND_API.G_MISS_CHAR, NULL,
374: NULL , ATTRIBUTE13, P_ATTRIBUTE13),
375: ATTRIBUTE14 = DECODE(P_ATTRIBUTE14,
376: FND_API.G_MISS_CHAR, NULL,
377: NULL , ATTRIBUTE14, P_ATTRIBUTE14),
378: ATTRIBUTE15 = DECODE(P_ATTRIBUTE15,
379: FND_API.G_MISS_CHAR, NULL,
380: NULL , ATTRIBUTE15, P_ATTRIBUTE15),

Line 379: FND_API.G_MISS_CHAR, NULL,

375: ATTRIBUTE14 = DECODE(P_ATTRIBUTE14,
376: FND_API.G_MISS_CHAR, NULL,
377: NULL , ATTRIBUTE14, P_ATTRIBUTE14),
378: ATTRIBUTE15 = DECODE(P_ATTRIBUTE15,
379: FND_API.G_MISS_CHAR, NULL,
380: NULL , ATTRIBUTE15, P_ATTRIBUTE15),
381: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
382: LAST_UPDATE_DATE = TRUNC(SYSDATE),
383: LAST_UPDATED_BY = NVL(FND_GLOBAL.user_id,-1),

Line 391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

387:
388: arp_standard.debug('Update_Head_Row -');
389: EXCEPTION
390: WHEN OTHERS THEN
391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
392: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
393: FND_MESSAGE.SET_TOKEN('ERROR' ,'Update_Head_Row:'||SQLERRM);
394: FND_MSG_PUB.ADD;
395: END Update_Head_Row;

Line 467: DECODE(P_AMOUNT, FND_API.G_MISS_NUM, NULL, P_AMOUNT),

463: P_SCHEDULE_HEADER_ID ,
464: P_SCHEDULE_ID ,
465: P_AGING_BUCKET_ID ,
466: P_AGING_BUCKET_LINE_ID,
467: DECODE(P_AMOUNT, FND_API.G_MISS_NUM, NULL, P_AMOUNT),
468: DECODE(P_RATE , FND_API.G_MISS_NUM, NULL, P_RATE ),
469: DECODE(P_ATTRIBUTE_CATEGORY,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE_CATEGORY),
470: DECODE(P_ATTRIBUTE1 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE1),
471: DECODE(P_ATTRIBUTE2 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE2),

Line 468: DECODE(P_RATE , FND_API.G_MISS_NUM, NULL, P_RATE ),

464: P_SCHEDULE_ID ,
465: P_AGING_BUCKET_ID ,
466: P_AGING_BUCKET_LINE_ID,
467: DECODE(P_AMOUNT, FND_API.G_MISS_NUM, NULL, P_AMOUNT),
468: DECODE(P_RATE , FND_API.G_MISS_NUM, NULL, P_RATE ),
469: DECODE(P_ATTRIBUTE_CATEGORY,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE_CATEGORY),
470: DECODE(P_ATTRIBUTE1 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE1),
471: DECODE(P_ATTRIBUTE2 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE2),
472: DECODE(P_ATTRIBUTE3 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE3),

Line 469: DECODE(P_ATTRIBUTE_CATEGORY,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE_CATEGORY),

465: P_AGING_BUCKET_ID ,
466: P_AGING_BUCKET_LINE_ID,
467: DECODE(P_AMOUNT, FND_API.G_MISS_NUM, NULL, P_AMOUNT),
468: DECODE(P_RATE , FND_API.G_MISS_NUM, NULL, P_RATE ),
469: DECODE(P_ATTRIBUTE_CATEGORY,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE_CATEGORY),
470: DECODE(P_ATTRIBUTE1 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE1),
471: DECODE(P_ATTRIBUTE2 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE2),
472: DECODE(P_ATTRIBUTE3 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE3),
473: DECODE(P_ATTRIBUTE4 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE4),

Line 470: DECODE(P_ATTRIBUTE1 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE1),

466: P_AGING_BUCKET_LINE_ID,
467: DECODE(P_AMOUNT, FND_API.G_MISS_NUM, NULL, P_AMOUNT),
468: DECODE(P_RATE , FND_API.G_MISS_NUM, NULL, P_RATE ),
469: DECODE(P_ATTRIBUTE_CATEGORY,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE_CATEGORY),
470: DECODE(P_ATTRIBUTE1 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE1),
471: DECODE(P_ATTRIBUTE2 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE2),
472: DECODE(P_ATTRIBUTE3 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE3),
473: DECODE(P_ATTRIBUTE4 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE4),
474: DECODE(P_ATTRIBUTE5 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE5),

Line 471: DECODE(P_ATTRIBUTE2 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE2),

467: DECODE(P_AMOUNT, FND_API.G_MISS_NUM, NULL, P_AMOUNT),
468: DECODE(P_RATE , FND_API.G_MISS_NUM, NULL, P_RATE ),
469: DECODE(P_ATTRIBUTE_CATEGORY,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE_CATEGORY),
470: DECODE(P_ATTRIBUTE1 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE1),
471: DECODE(P_ATTRIBUTE2 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE2),
472: DECODE(P_ATTRIBUTE3 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE3),
473: DECODE(P_ATTRIBUTE4 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE4),
474: DECODE(P_ATTRIBUTE5 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE5),
475: DECODE(P_ATTRIBUTE6 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE6),

Line 472: DECODE(P_ATTRIBUTE3 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE3),

468: DECODE(P_RATE , FND_API.G_MISS_NUM, NULL, P_RATE ),
469: DECODE(P_ATTRIBUTE_CATEGORY,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE_CATEGORY),
470: DECODE(P_ATTRIBUTE1 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE1),
471: DECODE(P_ATTRIBUTE2 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE2),
472: DECODE(P_ATTRIBUTE3 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE3),
473: DECODE(P_ATTRIBUTE4 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE4),
474: DECODE(P_ATTRIBUTE5 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE5),
475: DECODE(P_ATTRIBUTE6 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE6),
476: DECODE(P_ATTRIBUTE7 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE7),

Line 473: DECODE(P_ATTRIBUTE4 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE4),

469: DECODE(P_ATTRIBUTE_CATEGORY,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE_CATEGORY),
470: DECODE(P_ATTRIBUTE1 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE1),
471: DECODE(P_ATTRIBUTE2 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE2),
472: DECODE(P_ATTRIBUTE3 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE3),
473: DECODE(P_ATTRIBUTE4 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE4),
474: DECODE(P_ATTRIBUTE5 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE5),
475: DECODE(P_ATTRIBUTE6 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE6),
476: DECODE(P_ATTRIBUTE7 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE7),
477: DECODE(P_ATTRIBUTE8 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE8),

Line 474: DECODE(P_ATTRIBUTE5 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE5),

470: DECODE(P_ATTRIBUTE1 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE1),
471: DECODE(P_ATTRIBUTE2 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE2),
472: DECODE(P_ATTRIBUTE3 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE3),
473: DECODE(P_ATTRIBUTE4 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE4),
474: DECODE(P_ATTRIBUTE5 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE5),
475: DECODE(P_ATTRIBUTE6 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE6),
476: DECODE(P_ATTRIBUTE7 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE7),
477: DECODE(P_ATTRIBUTE8 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE8),
478: DECODE(P_ATTRIBUTE9 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE9),

Line 475: DECODE(P_ATTRIBUTE6 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE6),

471: DECODE(P_ATTRIBUTE2 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE2),
472: DECODE(P_ATTRIBUTE3 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE3),
473: DECODE(P_ATTRIBUTE4 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE4),
474: DECODE(P_ATTRIBUTE5 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE5),
475: DECODE(P_ATTRIBUTE6 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE6),
476: DECODE(P_ATTRIBUTE7 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE7),
477: DECODE(P_ATTRIBUTE8 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE8),
478: DECODE(P_ATTRIBUTE9 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE9),
479: DECODE(P_ATTRIBUTE10 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE10),

Line 476: DECODE(P_ATTRIBUTE7 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE7),

472: DECODE(P_ATTRIBUTE3 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE3),
473: DECODE(P_ATTRIBUTE4 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE4),
474: DECODE(P_ATTRIBUTE5 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE5),
475: DECODE(P_ATTRIBUTE6 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE6),
476: DECODE(P_ATTRIBUTE7 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE7),
477: DECODE(P_ATTRIBUTE8 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE8),
478: DECODE(P_ATTRIBUTE9 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE9),
479: DECODE(P_ATTRIBUTE10 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE10),
480: DECODE(P_ATTRIBUTE11 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE11),

Line 477: DECODE(P_ATTRIBUTE8 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE8),

473: DECODE(P_ATTRIBUTE4 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE4),
474: DECODE(P_ATTRIBUTE5 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE5),
475: DECODE(P_ATTRIBUTE6 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE6),
476: DECODE(P_ATTRIBUTE7 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE7),
477: DECODE(P_ATTRIBUTE8 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE8),
478: DECODE(P_ATTRIBUTE9 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE9),
479: DECODE(P_ATTRIBUTE10 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE10),
480: DECODE(P_ATTRIBUTE11 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE11),
481: DECODE(P_ATTRIBUTE12 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE12),

Line 478: DECODE(P_ATTRIBUTE9 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE9),

474: DECODE(P_ATTRIBUTE5 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE5),
475: DECODE(P_ATTRIBUTE6 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE6),
476: DECODE(P_ATTRIBUTE7 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE7),
477: DECODE(P_ATTRIBUTE8 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE8),
478: DECODE(P_ATTRIBUTE9 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE9),
479: DECODE(P_ATTRIBUTE10 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE10),
480: DECODE(P_ATTRIBUTE11 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE11),
481: DECODE(P_ATTRIBUTE12 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE12),
482: DECODE(P_ATTRIBUTE13 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE13),

Line 479: DECODE(P_ATTRIBUTE10 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE10),

475: DECODE(P_ATTRIBUTE6 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE6),
476: DECODE(P_ATTRIBUTE7 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE7),
477: DECODE(P_ATTRIBUTE8 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE8),
478: DECODE(P_ATTRIBUTE9 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE9),
479: DECODE(P_ATTRIBUTE10 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE10),
480: DECODE(P_ATTRIBUTE11 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE11),
481: DECODE(P_ATTRIBUTE12 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE12),
482: DECODE(P_ATTRIBUTE13 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE13),
483: DECODE(P_ATTRIBUTE14 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE14),

Line 480: DECODE(P_ATTRIBUTE11 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE11),

476: DECODE(P_ATTRIBUTE7 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE7),
477: DECODE(P_ATTRIBUTE8 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE8),
478: DECODE(P_ATTRIBUTE9 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE9),
479: DECODE(P_ATTRIBUTE10 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE10),
480: DECODE(P_ATTRIBUTE11 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE11),
481: DECODE(P_ATTRIBUTE12 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE12),
482: DECODE(P_ATTRIBUTE13 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE13),
483: DECODE(P_ATTRIBUTE14 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE14),
484: DECODE(P_ATTRIBUTE15 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE15),

Line 481: DECODE(P_ATTRIBUTE12 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE12),

477: DECODE(P_ATTRIBUTE8 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE8),
478: DECODE(P_ATTRIBUTE9 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE9),
479: DECODE(P_ATTRIBUTE10 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE10),
480: DECODE(P_ATTRIBUTE11 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE11),
481: DECODE(P_ATTRIBUTE12 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE12),
482: DECODE(P_ATTRIBUTE13 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE13),
483: DECODE(P_ATTRIBUTE14 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE14),
484: DECODE(P_ATTRIBUTE15 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE15),
485: P_OBJECT_VERSION_NUMBER,

Line 482: DECODE(P_ATTRIBUTE13 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE13),

478: DECODE(P_ATTRIBUTE9 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE9),
479: DECODE(P_ATTRIBUTE10 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE10),
480: DECODE(P_ATTRIBUTE11 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE11),
481: DECODE(P_ATTRIBUTE12 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE12),
482: DECODE(P_ATTRIBUTE13 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE13),
483: DECODE(P_ATTRIBUTE14 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE14),
484: DECODE(P_ATTRIBUTE15 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE15),
485: P_OBJECT_VERSION_NUMBER,
486: NVL(FND_GLOBAL.user_id,-1),

Line 483: DECODE(P_ATTRIBUTE14 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE14),

479: DECODE(P_ATTRIBUTE10 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE10),
480: DECODE(P_ATTRIBUTE11 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE11),
481: DECODE(P_ATTRIBUTE12 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE12),
482: DECODE(P_ATTRIBUTE13 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE13),
483: DECODE(P_ATTRIBUTE14 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE14),
484: DECODE(P_ATTRIBUTE15 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE15),
485: P_OBJECT_VERSION_NUMBER,
486: NVL(FND_GLOBAL.user_id,-1),
487: TRUNC(SYSDATE),

Line 484: DECODE(P_ATTRIBUTE15 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE15),

480: DECODE(P_ATTRIBUTE11 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE11),
481: DECODE(P_ATTRIBUTE12 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE12),
482: DECODE(P_ATTRIBUTE13 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE13),
483: DECODE(P_ATTRIBUTE14 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE14),
484: DECODE(P_ATTRIBUTE15 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE15),
485: P_OBJECT_VERSION_NUMBER,
486: NVL(FND_GLOBAL.user_id,-1),
487: TRUNC(SYSDATE),
488: NVL(FND_GLOBAL.user_id,-1),

Line 495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

491:
492: arp_standard.debug('Insert_Line_Row -');
493: EXCEPTION
494: WHEN OTHERS THEN
495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
496: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
497: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
498: FND_MSG_PUB.ADD;
499: END Insert_Line_Row;

Line 530: fnd_api.g_miss_num, NULL,

526: arp_standard.debug('Update_Line_Row +');
527: X_OBJECT_VERSION_NUMBER := X_OBJECT_VERSION_NUMBER + 1;
528: UPDATE AR_charge_SCHEDULE_LINES SET
529: AMOUNT = DECODE(p_amount,
530: fnd_api.g_miss_num, NULL,
531: NULL ,AMOUNT,p_amount),
532: RATE = DECODE(p_rate,
533: fnd_api.g_miss_num, NULL,
534: NULL ,RATE,p_rate),

Line 533: fnd_api.g_miss_num, NULL,

529: AMOUNT = DECODE(p_amount,
530: fnd_api.g_miss_num, NULL,
531: NULL ,AMOUNT,p_amount),
532: RATE = DECODE(p_rate,
533: fnd_api.g_miss_num, NULL,
534: NULL ,RATE,p_rate),
535: ATTRIBUTE_CATEGORY = DECODE(P_ATTRIBUTE_CATEGORY,
536: FND_API.G_MISS_CHAR, NULL,
537: NULL , ATTRIBUTE_CATEGORY, P_ATTRIBUTE_CATEGORY),

Line 536: FND_API.G_MISS_CHAR, NULL,

532: RATE = DECODE(p_rate,
533: fnd_api.g_miss_num, NULL,
534: NULL ,RATE,p_rate),
535: ATTRIBUTE_CATEGORY = DECODE(P_ATTRIBUTE_CATEGORY,
536: FND_API.G_MISS_CHAR, NULL,
537: NULL , ATTRIBUTE_CATEGORY, P_ATTRIBUTE_CATEGORY),
538: ATTRIBUTE1 = DECODE(P_ATTRIBUTE1,
539: FND_API.G_MISS_CHAR, NULL,
540: NULL , ATTRIBUTE1, P_ATTRIBUTE1),

Line 539: FND_API.G_MISS_CHAR, NULL,

535: ATTRIBUTE_CATEGORY = DECODE(P_ATTRIBUTE_CATEGORY,
536: FND_API.G_MISS_CHAR, NULL,
537: NULL , ATTRIBUTE_CATEGORY, P_ATTRIBUTE_CATEGORY),
538: ATTRIBUTE1 = DECODE(P_ATTRIBUTE1,
539: FND_API.G_MISS_CHAR, NULL,
540: NULL , ATTRIBUTE1, P_ATTRIBUTE1),
541: ATTRIBUTE2 = DECODE(P_ATTRIBUTE2,
542: FND_API.G_MISS_CHAR, NULL,
543: NULL , ATTRIBUTE2, P_ATTRIBUTE2),

Line 542: FND_API.G_MISS_CHAR, NULL,

538: ATTRIBUTE1 = DECODE(P_ATTRIBUTE1,
539: FND_API.G_MISS_CHAR, NULL,
540: NULL , ATTRIBUTE1, P_ATTRIBUTE1),
541: ATTRIBUTE2 = DECODE(P_ATTRIBUTE2,
542: FND_API.G_MISS_CHAR, NULL,
543: NULL , ATTRIBUTE2, P_ATTRIBUTE2),
544: ATTRIBUTE3 = DECODE(P_ATTRIBUTE3,
545: FND_API.G_MISS_CHAR, NULL,
546: NULL , ATTRIBUTE3, P_ATTRIBUTE3),

Line 545: FND_API.G_MISS_CHAR, NULL,

541: ATTRIBUTE2 = DECODE(P_ATTRIBUTE2,
542: FND_API.G_MISS_CHAR, NULL,
543: NULL , ATTRIBUTE2, P_ATTRIBUTE2),
544: ATTRIBUTE3 = DECODE(P_ATTRIBUTE3,
545: FND_API.G_MISS_CHAR, NULL,
546: NULL , ATTRIBUTE3, P_ATTRIBUTE3),
547: ATTRIBUTE4 = DECODE(P_ATTRIBUTE4,
548: FND_API.G_MISS_CHAR, NULL,
549: NULL , ATTRIBUTE4, P_ATTRIBUTE4),

Line 548: FND_API.G_MISS_CHAR, NULL,

544: ATTRIBUTE3 = DECODE(P_ATTRIBUTE3,
545: FND_API.G_MISS_CHAR, NULL,
546: NULL , ATTRIBUTE3, P_ATTRIBUTE3),
547: ATTRIBUTE4 = DECODE(P_ATTRIBUTE4,
548: FND_API.G_MISS_CHAR, NULL,
549: NULL , ATTRIBUTE4, P_ATTRIBUTE4),
550: ATTRIBUTE5 = DECODE(P_ATTRIBUTE5,
551: FND_API.G_MISS_CHAR, NULL,
552: NULL , ATTRIBUTE5, P_ATTRIBUTE5),

Line 551: FND_API.G_MISS_CHAR, NULL,

547: ATTRIBUTE4 = DECODE(P_ATTRIBUTE4,
548: FND_API.G_MISS_CHAR, NULL,
549: NULL , ATTRIBUTE4, P_ATTRIBUTE4),
550: ATTRIBUTE5 = DECODE(P_ATTRIBUTE5,
551: FND_API.G_MISS_CHAR, NULL,
552: NULL , ATTRIBUTE5, P_ATTRIBUTE5),
553: ATTRIBUTE6 = DECODE(P_ATTRIBUTE6,
554: FND_API.G_MISS_CHAR, NULL,
555: NULL , ATTRIBUTE6, P_ATTRIBUTE6),

Line 554: FND_API.G_MISS_CHAR, NULL,

550: ATTRIBUTE5 = DECODE(P_ATTRIBUTE5,
551: FND_API.G_MISS_CHAR, NULL,
552: NULL , ATTRIBUTE5, P_ATTRIBUTE5),
553: ATTRIBUTE6 = DECODE(P_ATTRIBUTE6,
554: FND_API.G_MISS_CHAR, NULL,
555: NULL , ATTRIBUTE6, P_ATTRIBUTE6),
556: ATTRIBUTE7 = DECODE(P_ATTRIBUTE7,
557: FND_API.G_MISS_CHAR, NULL,
558: NULL , ATTRIBUTE7, P_ATTRIBUTE7),

Line 557: FND_API.G_MISS_CHAR, NULL,

553: ATTRIBUTE6 = DECODE(P_ATTRIBUTE6,
554: FND_API.G_MISS_CHAR, NULL,
555: NULL , ATTRIBUTE6, P_ATTRIBUTE6),
556: ATTRIBUTE7 = DECODE(P_ATTRIBUTE7,
557: FND_API.G_MISS_CHAR, NULL,
558: NULL , ATTRIBUTE7, P_ATTRIBUTE7),
559: ATTRIBUTE8 = DECODE(P_ATTRIBUTE8,
560: FND_API.G_MISS_CHAR, NULL,
561: NULL , ATTRIBUTE8, P_ATTRIBUTE8),

Line 560: FND_API.G_MISS_CHAR, NULL,

556: ATTRIBUTE7 = DECODE(P_ATTRIBUTE7,
557: FND_API.G_MISS_CHAR, NULL,
558: NULL , ATTRIBUTE7, P_ATTRIBUTE7),
559: ATTRIBUTE8 = DECODE(P_ATTRIBUTE8,
560: FND_API.G_MISS_CHAR, NULL,
561: NULL , ATTRIBUTE8, P_ATTRIBUTE8),
562: ATTRIBUTE9 = DECODE(P_ATTRIBUTE9,
563: FND_API.G_MISS_CHAR, NULL,
564: NULL , ATTRIBUTE9, P_ATTRIBUTE9),

Line 563: FND_API.G_MISS_CHAR, NULL,

559: ATTRIBUTE8 = DECODE(P_ATTRIBUTE8,
560: FND_API.G_MISS_CHAR, NULL,
561: NULL , ATTRIBUTE8, P_ATTRIBUTE8),
562: ATTRIBUTE9 = DECODE(P_ATTRIBUTE9,
563: FND_API.G_MISS_CHAR, NULL,
564: NULL , ATTRIBUTE9, P_ATTRIBUTE9),
565: ATTRIBUTE10 = DECODE(P_ATTRIBUTE10,
566: FND_API.G_MISS_CHAR, NULL,
567: NULL , ATTRIBUTE10, P_ATTRIBUTE10),

Line 566: FND_API.G_MISS_CHAR, NULL,

562: ATTRIBUTE9 = DECODE(P_ATTRIBUTE9,
563: FND_API.G_MISS_CHAR, NULL,
564: NULL , ATTRIBUTE9, P_ATTRIBUTE9),
565: ATTRIBUTE10 = DECODE(P_ATTRIBUTE10,
566: FND_API.G_MISS_CHAR, NULL,
567: NULL , ATTRIBUTE10, P_ATTRIBUTE10),
568: ATTRIBUTE11 = DECODE(P_ATTRIBUTE11,
569: FND_API.G_MISS_CHAR, NULL,
570: NULL , ATTRIBUTE11, P_ATTRIBUTE11),

Line 569: FND_API.G_MISS_CHAR, NULL,

565: ATTRIBUTE10 = DECODE(P_ATTRIBUTE10,
566: FND_API.G_MISS_CHAR, NULL,
567: NULL , ATTRIBUTE10, P_ATTRIBUTE10),
568: ATTRIBUTE11 = DECODE(P_ATTRIBUTE11,
569: FND_API.G_MISS_CHAR, NULL,
570: NULL , ATTRIBUTE11, P_ATTRIBUTE11),
571: ATTRIBUTE12 = DECODE(P_ATTRIBUTE12,
572: FND_API.G_MISS_CHAR, NULL,
573: NULL , ATTRIBUTE12, P_ATTRIBUTE12),

Line 572: FND_API.G_MISS_CHAR, NULL,

568: ATTRIBUTE11 = DECODE(P_ATTRIBUTE11,
569: FND_API.G_MISS_CHAR, NULL,
570: NULL , ATTRIBUTE11, P_ATTRIBUTE11),
571: ATTRIBUTE12 = DECODE(P_ATTRIBUTE12,
572: FND_API.G_MISS_CHAR, NULL,
573: NULL , ATTRIBUTE12, P_ATTRIBUTE12),
574: ATTRIBUTE13 = DECODE(P_ATTRIBUTE13,
575: FND_API.G_MISS_CHAR, NULL,
576: NULL , ATTRIBUTE13, P_ATTRIBUTE13),

Line 575: FND_API.G_MISS_CHAR, NULL,

571: ATTRIBUTE12 = DECODE(P_ATTRIBUTE12,
572: FND_API.G_MISS_CHAR, NULL,
573: NULL , ATTRIBUTE12, P_ATTRIBUTE12),
574: ATTRIBUTE13 = DECODE(P_ATTRIBUTE13,
575: FND_API.G_MISS_CHAR, NULL,
576: NULL , ATTRIBUTE13, P_ATTRIBUTE13),
577: ATTRIBUTE14 = DECODE(P_ATTRIBUTE14,
578: FND_API.G_MISS_CHAR, NULL,
579: NULL , ATTRIBUTE14, P_ATTRIBUTE14),

Line 578: FND_API.G_MISS_CHAR, NULL,

574: ATTRIBUTE13 = DECODE(P_ATTRIBUTE13,
575: FND_API.G_MISS_CHAR, NULL,
576: NULL , ATTRIBUTE13, P_ATTRIBUTE13),
577: ATTRIBUTE14 = DECODE(P_ATTRIBUTE14,
578: FND_API.G_MISS_CHAR, NULL,
579: NULL , ATTRIBUTE14, P_ATTRIBUTE14),
580: ATTRIBUTE15 = DECODE(P_ATTRIBUTE15,
581: FND_API.G_MISS_CHAR, NULL,
582: NULL , ATTRIBUTE15, P_ATTRIBUTE15),

Line 581: FND_API.G_MISS_CHAR, NULL,

577: ATTRIBUTE14 = DECODE(P_ATTRIBUTE14,
578: FND_API.G_MISS_CHAR, NULL,
579: NULL , ATTRIBUTE14, P_ATTRIBUTE14),
580: ATTRIBUTE15 = DECODE(P_ATTRIBUTE15,
581: FND_API.G_MISS_CHAR, NULL,
582: NULL , ATTRIBUTE15, P_ATTRIBUTE15),
583: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
584: LAST_UPDATE_DATE = TRUNC(SYSDATE),
585: LAST_UPDATED_BY = NVL(FND_GLOBAL.user_id,-1),

Line 593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

589:
590: arp_standard.debug('Update_Line_Row -');
591: EXCEPTION
592: WHEN OTHERS THEN
593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
594: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
595: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
596: FND_MSG_PUB.ADD;
597: END Update_Line_Row;

Line 643: IF ((ldate1 IS NULL OR ldate1 = FND_API.G_MISS_DATE) AND (ldate2 IS NULL OR ldate2 = FND_API.G_MISS_DATE)) THEN

639: ldate2 date;
640: BEGIN
641: ldate1 := date1;
642: ldate2 := date2;
643: IF ((ldate1 IS NULL OR ldate1 = FND_API.G_MISS_DATE) AND (ldate2 IS NULL OR ldate2 = FND_API.G_MISS_DATE)) THEN
644: RETURN 0;
645: ELSIF (ldate2 IS NULL OR ldate2 = FND_API.G_MISS_DATE) THEN
646: RETURN -1;
647: ELSIF (ldate1 IS NULL OR ldate1 = FND_API.G_MISS_DATE) THEN

Line 645: ELSIF (ldate2 IS NULL OR ldate2 = FND_API.G_MISS_DATE) THEN

641: ldate1 := date1;
642: ldate2 := date2;
643: IF ((ldate1 IS NULL OR ldate1 = FND_API.G_MISS_DATE) AND (ldate2 IS NULL OR ldate2 = FND_API.G_MISS_DATE)) THEN
644: RETURN 0;
645: ELSIF (ldate2 IS NULL OR ldate2 = FND_API.G_MISS_DATE) THEN
646: RETURN -1;
647: ELSIF (ldate1 IS NULL OR ldate1 = FND_API.G_MISS_DATE) THEN
648: RETURN 1;
649: ELSIF ( ldate1 = ldate2 ) THEN

Line 647: ELSIF (ldate1 IS NULL OR ldate1 = FND_API.G_MISS_DATE) THEN

643: IF ((ldate1 IS NULL OR ldate1 = FND_API.G_MISS_DATE) AND (ldate2 IS NULL OR ldate2 = FND_API.G_MISS_DATE)) THEN
644: RETURN 0;
645: ELSIF (ldate2 IS NULL OR ldate2 = FND_API.G_MISS_DATE) THEN
646: RETURN -1;
647: ELSIF (ldate1 IS NULL OR ldate1 = FND_API.G_MISS_DATE) THEN
648: RETURN 1;
649: ELSIF ( ldate1 = ldate2 ) THEN
650: RETURN 0;
651: ELSIF ( ldate1 > ldate2 ) THEN

Line 672: IF p_schedule_name IS NULL OR p_schedule_name = FND_API.G_MISS_CHAR THEN

668: -- Validate schedule_name
669: -------------------------
670: arp_standard.debug(' Validate schedule_name +');
671: IF p_mode = 'INSERT' THEN
672: IF p_schedule_name IS NULL OR p_schedule_name = FND_API.G_MISS_CHAR THEN
673: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
674: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'schedule_name' );
675: FND_MSG_PUB.ADD;
676: x_return_status := FND_API.G_RET_STS_ERROR;

Line 676: x_return_status := FND_API.G_RET_STS_ERROR;

672: IF p_schedule_name IS NULL OR p_schedule_name = FND_API.G_MISS_CHAR THEN
673: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
674: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'schedule_name' );
675: FND_MSG_PUB.ADD;
676: x_return_status := FND_API.G_RET_STS_ERROR;
677: END IF;
678: END IF;
679: arp_standard.debug(' Validate schedule_name -');
680: END;

Line 736: IF P_SCHEDULE_ID IS NULL OR P_SCHEDULE_ID = fnd_api.g_miss_num THEN

732: -------------------------------------
733: -- Validate schedule_id
734: -------------------------------------
735: arp_standard.debug(' Validate schedule_id +');
736: IF P_SCHEDULE_ID IS NULL OR P_SCHEDULE_ID = fnd_api.g_miss_num THEN
737: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
738: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'SCHEDULE_ID' );
739: FND_MSG_PUB.ADD;
740: x_return_status := FND_API.G_RET_STS_ERROR;

Line 740: x_return_status := FND_API.G_RET_STS_ERROR;

736: IF P_SCHEDULE_ID IS NULL OR P_SCHEDULE_ID = fnd_api.g_miss_num THEN
737: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
738: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'SCHEDULE_ID' );
739: FND_MSG_PUB.ADD;
740: x_return_status := FND_API.G_RET_STS_ERROR;
741: END IF;
742: OPEN c_schedule_id;
743: FETCH c_schedule_id INTO l_c;
744: IF c_schedule_id%NOTFOUND THEN

Line 750: x_return_status := FND_API.G_RET_STS_ERROR;

746: FND_MESSAGE.SET_TOKEN('FK', 'ar charge schedules');
747: FND_MESSAGE.SET_TOKEN('COLUMN', 'schedule_id');
748: FND_MESSAGE.SET_TOKEN('TABLE', 'ar_charge_schedules');
749: FND_MSG_PUB.ADD;
750: x_return_status := FND_API.G_RET_STS_ERROR;
751: END IF;
752: CLOSE c_schedule_id;
753: arp_standard.debug(' Validate schedule_id -');
754:

Line 759: IF p_schedule_header_type IS NULL OR p_schedule_header_type = fnd_api.g_miss_char THEN

755: --------------------------------------------------------------------------
756: -- Validate SCHEDULE_HEADER_TYPE lookup code in lookup type SCHEDULE_HEADER_TYPE
757: --------------------------------------------------------------------------
758: arp_standard.debug(' Validate schedule_header_type +');
759: IF p_schedule_header_type IS NULL OR p_schedule_header_type = fnd_api.g_miss_char THEN
760: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
761: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'schedule_header_type' );
762: FND_MSG_PUB.ADD;
763: x_return_status := FND_API.G_RET_STS_ERROR;

Line 763: x_return_status := FND_API.G_RET_STS_ERROR;

759: IF p_schedule_header_type IS NULL OR p_schedule_header_type = fnd_api.g_miss_char THEN
760: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
761: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'schedule_header_type' );
762: FND_MSG_PUB.ADD;
763: x_return_status := FND_API.G_RET_STS_ERROR;
764: END IF;
765:
766: IF validate_lookup('SCHEDULE_HEADER_TYPE',p_schedule_header_type) = FALSE THEN
767: arp_standard.debug(' schedule type should be lookup code for the lookup type SCHEDULE_HEADER_TYPE');

Line 772: x_return_status := FND_API.G_RET_STS_ERROR;

768: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_LOOKUP' );
769: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'schedule header type' );
770: FND_MESSAGE.SET_TOKEN( 'LOOKUP_TYPE', 'SCHEDULE_HEADER_TYPE' );
771: FND_MSG_PUB.ADD;
772: x_return_status := FND_API.G_RET_STS_ERROR;
773: END IF;
774: arp_standard.debug(' Validate schedule_header_type -');
775:
776:

Line 781: IF p_status IS NULL OR p_status = fnd_api.g_miss_char THEN

777: -------------------------------------------------------------
778: -- Validate STATUS lookup code in lookup type REGISTRY_STATUS
779: -------------------------------------------------------------
780: arp_standard.debug(' Validate status +');
781: IF p_status IS NULL OR p_status = fnd_api.g_miss_char THEN
782: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
783: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'status' );
784: FND_MSG_PUB.ADD;
785: x_return_status := FND_API.G_RET_STS_ERROR;

Line 785: x_return_status := FND_API.G_RET_STS_ERROR;

781: IF p_status IS NULL OR p_status = fnd_api.g_miss_char THEN
782: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
783: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'status' );
784: FND_MSG_PUB.ADD;
785: x_return_status := FND_API.G_RET_STS_ERROR;
786: END IF;
787:
788: IF validate_lookup('REGISTRY_STATUS',p_status) = FALSE THEN
789: arp_standard.debug(' status should be lookup code for the lookup type REGISTRY_STATUS');

Line 794: x_return_status := FND_API.G_RET_STS_ERROR;

790: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_LOOKUP' );
791: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'status' );
792: FND_MESSAGE.SET_TOKEN( 'LOOKUP_TYPE', 'REGISTRY_STATUS' );
793: FND_MSG_PUB.ADD;
794: x_return_status := FND_API.G_RET_STS_ERROR;
795: END IF;
796: arp_standard.debug(' Validate status -');
797:
798:

Line 803: IF P_AGING_BUCKET_ID IS NULL OR P_AGING_BUCKET_ID = FND_API.G_MISS_NUM THEN

799: -----------------------------
800: -- Validate P_AGING_BUCKET_ID
801: -----------------------------
802: arp_standard.debug(' validate aging_bucket +');
803: IF P_AGING_BUCKET_ID IS NULL OR P_AGING_BUCKET_ID = FND_API.G_MISS_NUM THEN
804: NULL;
805: ELSE
806: OPEN c_aging_bucket;
807: FETCH c_aging_bucket INTO l_c;

Line 814: x_return_status := FND_API.G_RET_STS_ERROR;

810: FND_MESSAGE.SET_TOKEN('FK', 'ar aging bucket id');
811: FND_MESSAGE.SET_TOKEN('COLUMN', 'aging_bucket_id');
812: FND_MESSAGE.SET_TOKEN('TABLE', 'ar_aging_bucket');
813: FND_MSG_PUB.ADD;
814: x_return_status := FND_API.G_RET_STS_ERROR;
815: END IF;
816: CLOSE c_aging_bucket;
817: END IF;
818: arp_standard.debug(' validate aging_bucket -');

Line 826: IF p_start_date IS NULL OR p_start_date = fnd_api.g_miss_date THEN

822: -- Validate start_date and end_date
823: ----------------------------------------------------
824: arp_standard.debug(' validate start and end dates +');
825:
826: IF p_start_date IS NULL OR p_start_date = fnd_api.g_miss_date THEN
827: arp_standard.debug(' validate start date is mandatory');
828: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
829: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'p_start_date' );
830: FND_MSG_PUB.ADD;

Line 831: x_return_status := FND_API.G_RET_STS_ERROR;

827: arp_standard.debug(' validate start date is mandatory');
828: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
829: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'p_start_date' );
830: FND_MSG_PUB.ADD;
831: x_return_status := FND_API.G_RET_STS_ERROR;
832: END IF;
833:
834: l_val := compare(date1 => p_start_date,
835: date2 => p_end_date );

Line 843: x_return_status := fnd_api.g_ret_sts_error;

839: fnd_message.set_name('AR', 'HZ_API_DATE_GREATER');
840: fnd_message.set_token('DATE2', 'end_date');
841: fnd_message.set_token('DATE1', 'start_date');
842: fnd_msg_pub.add;
843: x_return_status := fnd_api.g_ret_sts_error;
844: END IF;
845:
846:
847: IF x_return_status = fnd_api.g_ret_sts_success THEN

Line 847: IF x_return_status = fnd_api.g_ret_sts_success THEN

843: x_return_status := fnd_api.g_ret_sts_error;
844: END IF;
845:
846:
847: IF x_return_status = fnd_api.g_ret_sts_success THEN
848: arp_standard.debug(' Check overlappings of periods');
849: OPEN c_overlapp;
850: LOOP
851: FETCH c_overlapp INTO l_start_date, l_end_date;

Line 871: x_return_status := fnd_api.g_ret_sts_error;

867: fnd_message.set_token('END_DATE_PER_1' , l_end_date);
868: fnd_message.set_token('START_DATE_PER_2', p_start_date);
869: fnd_message.set_token('END_DATE_PER_2' , p_end_date);
870: fnd_msg_pub.add;
871: x_return_status := fnd_api.g_ret_sts_error;
872: END IF;
873: END IF;
874: IF x_return_status <> fnd_api.g_ret_sts_success THEN
875: EXIT;

Line 874: IF x_return_status <> fnd_api.g_ret_sts_success THEN

870: fnd_msg_pub.add;
871: x_return_status := fnd_api.g_ret_sts_error;
872: END IF;
873: END IF;
874: IF x_return_status <> fnd_api.g_ret_sts_success THEN
875: EXIT;
876: END IF;
877: END LOOP;
878: CLOSE c_overlapp;

Line 890: IF p_status = fnd_api.g_miss_char THEN

886: -------------------------------------------------------------
887: -- Validate STATUS lookup code in lookup type REGISTRY_STATUS
888: -------------------------------------------------------------
889: arp_standard.debug(' Validate status +');
890: IF p_status = fnd_api.g_miss_char THEN
891: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
892: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'status' );
893: FND_MSG_PUB.ADD;
894: x_return_status := FND_API.G_RET_STS_ERROR;

Line 894: x_return_status := FND_API.G_RET_STS_ERROR;

890: IF p_status = fnd_api.g_miss_char THEN
891: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
892: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'status' );
893: FND_MSG_PUB.ADD;
894: x_return_status := FND_API.G_RET_STS_ERROR;
895: END IF;
896:
897: IF p_status IS NOT NULL THEN
898: IF validate_lookup('REGISTRY_STATUS',p_status) = FALSE THEN

Line 904: x_return_status := FND_API.G_RET_STS_ERROR;

900: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_LOOKUP' );
901: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'status' );
902: FND_MESSAGE.SET_TOKEN( 'LOOKUP_TYPE', 'REGISTRY_STATUS' );
903: FND_MSG_PUB.ADD;
904: x_return_status := FND_API.G_RET_STS_ERROR;
905: END IF;
906: END IF;
907:
908: IF p_old_status = 'I' AND p_status = 'A' THEN

Line 912: x_return_status := FND_API.G_RET_STS_ERROR;

908: IF p_old_status = 'I' AND p_status = 'A' THEN
909: arp_standard.debug(' Schedule Header can not be reactivated');
910: FND_MESSAGE.SET_NAME( 'AR', 'AR_NO_REACTIVATE_ALLOW' );
911: FND_MSG_PUB.ADD;
912: x_return_status := FND_API.G_RET_STS_ERROR;
913: END IF;
914:
915: arp_standard.debug(' Validate status -');
916:

Line 921: IF p_end_date IS NOT NULL AND p_end_date <> FND_API.G_MISS_DATE THEN

917: -----------------------------------
918: -- Validate start_date and end_date
919: -----------------------------------
920: arp_standard.debug(' validate start and end dates +');
921: IF p_end_date IS NOT NULL AND p_end_date <> FND_API.G_MISS_DATE THEN
922: l_val := compare(date1 => p_start_date,
923: date2 => p_end_date );
924: IF l_val = 1 THEN
925: arp_standard.debug(' end date should be greater than the start date');

Line 930: x_return_status := fnd_api.g_ret_sts_error;

926: fnd_message.set_name('AR', 'HZ_API_DATE_GREATER');
927: fnd_message.set_token('DATE2', 'end_date');
928: fnd_message.set_token('DATE1', 'start_date');
929: fnd_msg_pub.add;
930: x_return_status := fnd_api.g_ret_sts_error;
931: END IF;
932: IF x_return_status = fnd_api.g_ret_sts_success THEN
933: arp_standard.debug(' Check overlappings of periods');
934: OPEN c_overlapp_upd;

Line 932: IF x_return_status = fnd_api.g_ret_sts_success THEN

928: fnd_message.set_token('DATE1', 'start_date');
929: fnd_msg_pub.add;
930: x_return_status := fnd_api.g_ret_sts_error;
931: END IF;
932: IF x_return_status = fnd_api.g_ret_sts_success THEN
933: arp_standard.debug(' Check overlappings of periods');
934: OPEN c_overlapp_upd;
935: LOOP
936: FETCH c_overlapp_upd INTO l_start_date, l_end_date;

Line 956: x_return_status := fnd_api.g_ret_sts_error;

952: fnd_message.set_token('END_DATE_PER_1' , l_end_date);
953: fnd_message.set_token('START_DATE_PER_2', p_start_date);
954: fnd_message.set_token('END_DATE_PER_2' , p_end_date);
955: fnd_msg_pub.add;
956: x_return_status := fnd_api.g_ret_sts_error;
957: END IF;
958: END IF;
959: IF x_return_status <> fnd_api.g_ret_sts_success THEN
960: EXIT;

Line 959: IF x_return_status <> fnd_api.g_ret_sts_success THEN

955: fnd_msg_pub.add;
956: x_return_status := fnd_api.g_ret_sts_error;
957: END IF;
958: END IF;
959: IF x_return_status <> fnd_api.g_ret_sts_success THEN
960: EXIT;
961: END IF;
962: END LOOP;
963: CLOSE c_overlapp_upd;

Line 1028: IF p_schedule_header_id IS NULL OR p_schedule_header_id = fnd_api.g_miss_num THEN

1024: -- Validate schedule_header_id
1025: -------------------------------------
1026: arp_standard.debug(' Validate schedule_header_id +');
1027:
1028: IF p_schedule_header_id IS NULL OR p_schedule_header_id = fnd_api.g_miss_num THEN
1029: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
1030: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'schedule_header_id' );
1031: FND_MSG_PUB.ADD;
1032: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1032: x_return_status := FND_API.G_RET_STS_ERROR;

1028: IF p_schedule_header_id IS NULL OR p_schedule_header_id = fnd_api.g_miss_num THEN
1029: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
1030: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'schedule_header_id' );
1031: FND_MSG_PUB.ADD;
1032: x_return_status := FND_API.G_RET_STS_ERROR;
1033: END IF;
1034:
1035: OPEN c_header;
1036: FETCH c_header INTO l_rec;

Line 1043: x_return_status := FND_API.G_RET_STS_ERROR;

1039: FND_MESSAGE.SET_TOKEN('FK', 'schedule header');
1040: FND_MESSAGE.SET_TOKEN('COLUMN', 'schedule_header_id');
1041: FND_MESSAGE.SET_TOKEN('TABLE', 'ar_charge_schedule_hdrs');
1042: FND_MSG_PUB.ADD;
1043: x_return_status := FND_API.G_RET_STS_ERROR;
1044: END IF;
1045: CLOSE c_header;
1046: arp_standard.debug(' Validate schedule_header_id -');
1047:

Line 1053: IF p_schedule_id IS NULL OR p_schedule_id = fnd_api.g_miss_num THEN

1049: ------------------------
1050: -- Validate schedule_id
1051: ------------------------
1052: arp_standard.debug(' Validate schedule_id +');
1053: IF p_schedule_id IS NULL OR p_schedule_id = fnd_api.g_miss_num THEN
1054: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
1055: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'schedule_id' );
1056: FND_MSG_PUB.ADD;
1057: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1057: x_return_status := FND_API.G_RET_STS_ERROR;

1053: IF p_schedule_id IS NULL OR p_schedule_id = fnd_api.g_miss_num THEN
1054: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
1055: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'schedule_id' );
1056: FND_MSG_PUB.ADD;
1057: x_return_status := FND_API.G_RET_STS_ERROR;
1058: ELSE
1059: IF p_schedule_id <> l_rec.schedule_id THEN
1060: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
1061: FND_MESSAGE.SET_TOKEN('FK', 'schedule header');

Line 1065: x_return_status := FND_API.G_RET_STS_ERROR;

1061: FND_MESSAGE.SET_TOKEN('FK', 'schedule header');
1062: FND_MESSAGE.SET_TOKEN('COLUMN', 'schedule_id');
1063: FND_MESSAGE.SET_TOKEN('TABLE', 'ar_charge_schedule_hdrs');
1064: FND_MSG_PUB.ADD;
1065: x_return_status := FND_API.G_RET_STS_ERROR;
1066: END IF;
1067: END IF;
1068: arp_standard.debug(' Validate schedule_id -');
1069:

Line 1075: IF P_AGING_BUCKET_ID IS NULL OR P_AGING_BUCKET_ID = fnd_api.g_miss_num THEN

1071: ---------------------------
1072: -- Validate aging_bucket_id
1073: ---------------------------
1074: arp_standard.debug(' Validate aging_bucket_id +');
1075: IF P_AGING_BUCKET_ID IS NULL OR P_AGING_BUCKET_ID = fnd_api.g_miss_num THEN
1076: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
1077: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'P_AGING_BUCKET_ID' );
1078: FND_MSG_PUB.ADD;
1079: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1079: x_return_status := FND_API.G_RET_STS_ERROR;

1075: IF P_AGING_BUCKET_ID IS NULL OR P_AGING_BUCKET_ID = fnd_api.g_miss_num THEN
1076: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
1077: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'P_AGING_BUCKET_ID' );
1078: FND_MSG_PUB.ADD;
1079: x_return_status := FND_API.G_RET_STS_ERROR;
1080: ELSE
1081: IF P_AGING_BUCKET_ID <> l_rec.aging_bucket_id THEN
1082: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
1083: FND_MESSAGE.SET_TOKEN('FK', 'schedule header');

Line 1087: x_return_status := FND_API.G_RET_STS_ERROR;

1083: FND_MESSAGE.SET_TOKEN('FK', 'schedule header');
1084: FND_MESSAGE.SET_TOKEN('COLUMN', 'aging_bucket_id');
1085: FND_MESSAGE.SET_TOKEN('TABLE', 'ar_charge_schedule_hdrs');
1086: FND_MSG_PUB.ADD;
1087: x_return_status := FND_API.G_RET_STS_ERROR;
1088: END IF;
1089: END IF;
1090: arp_standard.debug(' Validate aging_bucket_id -');
1091:

Line 1110: x_return_status := fnd_api.g_ret_sts_error;

1106: fnd_message.set_token('COLUMN1', 'schedule_header_id');
1107: fnd_message.set_token('COLUMN2', 'aging_bucket_id');
1108: fnd_message.set_token('COLUMN3', 'aging_bucket_line_id');
1109: fnd_msg_pub.add;
1110: x_return_status := fnd_api.g_ret_sts_error;
1111: END IF;
1112: CLOSE ar_schedule_line_u2;
1113: arp_standard.debug(' unidicity of ar_schedule_line_u2 -');
1114:

Line 1120: IF p_aging_bucket_line_id IS NULL OR p_aging_bucket_line_id = fnd_api.g_miss_num

1116: ---------------------------------
1117: -- Validate aging_bucket_line_id
1118: ---------------------------------
1119: arp_standard.debug(' Validate aging_bucket_id and aging_bucket_line_id +');
1120: IF p_aging_bucket_line_id IS NULL OR p_aging_bucket_line_id = fnd_api.g_miss_num
1121: THEN
1122: IF p_aging_bucket_line_id IS NULL or p_aging_bucket_line_id = fnd_api.g_miss_num THEN
1123: arp_standard.debug(' AGING_BUCKET_LINE_ID missing');
1124: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

Line 1122: IF p_aging_bucket_line_id IS NULL or p_aging_bucket_line_id = fnd_api.g_miss_num THEN

1118: ---------------------------------
1119: arp_standard.debug(' Validate aging_bucket_id and aging_bucket_line_id +');
1120: IF p_aging_bucket_line_id IS NULL OR p_aging_bucket_line_id = fnd_api.g_miss_num
1121: THEN
1122: IF p_aging_bucket_line_id IS NULL or p_aging_bucket_line_id = fnd_api.g_miss_num THEN
1123: arp_standard.debug(' AGING_BUCKET_LINE_ID missing');
1124: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
1125: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'AGING_BUCKET_LINE_ID' );
1126: FND_MSG_PUB.ADD;

Line 1127: x_return_status := FND_API.G_RET_STS_ERROR;

1123: arp_standard.debug(' AGING_BUCKET_LINE_ID missing');
1124: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
1125: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'AGING_BUCKET_LINE_ID' );
1126: FND_MSG_PUB.ADD;
1127: x_return_status := FND_API.G_RET_STS_ERROR;
1128: END IF;
1129: ELSE
1130: IF p_aging_bucket_id IS NOT NULL AND p_aging_bucket_id <> FND_API.G_MISS_NUM THEN
1131: OPEN c_aging_bucket_id(p_aging_bucket_id, p_aging_bucket_line_id);

Line 1130: IF p_aging_bucket_id IS NOT NULL AND p_aging_bucket_id <> FND_API.G_MISS_NUM THEN

1126: FND_MSG_PUB.ADD;
1127: x_return_status := FND_API.G_RET_STS_ERROR;
1128: END IF;
1129: ELSE
1130: IF p_aging_bucket_id IS NOT NULL AND p_aging_bucket_id <> FND_API.G_MISS_NUM THEN
1131: OPEN c_aging_bucket_id(p_aging_bucket_id, p_aging_bucket_line_id);
1132: FETCH c_aging_bucket_id INTO l_c;
1133: IF c_aging_bucket_id%NOTFOUND THEN
1134: arp_standard.debug(' AGING_BUCKET_ID/AGING_BUCKET_LINE_ID are not valid');

Line 1145: x_return_status := FND_API.G_RET_STS_ERROR;

1141: FND_MESSAGE.SET_TOKEN( 'FK', 'aging_bucket_line_id' );
1142: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'aging_bucket_line_id' );
1143: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_aging_bucket_lines_b');
1144: FND_MSG_PUB.ADD;
1145: x_return_status := FND_API.G_RET_STS_ERROR;
1146: END IF;
1147: CLOSE c_aging_bucket_id;
1148: END IF;
1149: END IF;

Line 1163: IF (p_amount IS NULL OR p_amount = FND_API.G_MISS_NUM) AND

1159: OPEN cl;
1160: FETCH cl INTO l_c;
1161: CLOSE cl;
1162:
1163: IF (p_amount IS NULL OR p_amount = FND_API.G_MISS_NUM) AND
1164: (l_c = 'AMOUNT')
1165: THEN
1166: arp_standard.debug(' The amount column is mandatory for SCHEDULE_HEADER_TYPE :'||l_c);
1167: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');

Line 1170: x_return_status := FND_API.G_RET_STS_ERROR;

1166: arp_standard.debug(' The amount column is mandatory for SCHEDULE_HEADER_TYPE :'||l_c);
1167: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
1168: fnd_message.set_token('COLUMN', 'AMOUNT');
1169: FND_MSG_PUB.ADD;
1170: x_return_status := FND_API.G_RET_STS_ERROR;
1171: END IF;
1172:
1173: IF (p_rate IS NULL OR p_rate = FND_API.G_MISS_NUM) AND
1174: (l_c = 'PERCENTAGE')

Line 1173: IF (p_rate IS NULL OR p_rate = FND_API.G_MISS_NUM) AND

1169: FND_MSG_PUB.ADD;
1170: x_return_status := FND_API.G_RET_STS_ERROR;
1171: END IF;
1172:
1173: IF (p_rate IS NULL OR p_rate = FND_API.G_MISS_NUM) AND
1174: (l_c = 'PERCENTAGE')
1175: THEN
1176: arp_standard.debug(' The rate column is mandatory for SCHEDULE_HEADER_TYPE:'||l_c);
1177: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');

Line 1181: x_return_status := FND_API.G_RET_STS_ERROR;

1177: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
1178: fnd_message.set_token('COLUMN', 'RATE');
1179: fnd_msg_pub.add;
1180: FND_MSG_PUB.ADD;
1181: x_return_status := FND_API.G_RET_STS_ERROR;
1182: END IF;
1183: arp_standard.debug(' validate amount or rate -');
1184: END;
1185:

Line 1191: (p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

1187:
1188:
1189:
1190: PROCEDURE create_schedule
1191: (p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1192: P_SCHEDULE_NAME IN VARCHAR2,
1193: P_SCHEDULE_DESCRIPTION IN VARCHAR2,
1194: P_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,
1195: P_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL,

Line 1229: x_return_status := fnd_api.G_RET_STS_SUCCESS;

1225: arp_standard.debug(' P_SCHEDULE_DESCRIPTION :'||P_SCHEDULE_DESCRIPTION);
1226:
1227: SAVEPOINT create_schedule;
1228:
1229: x_return_status := fnd_api.G_RET_STS_SUCCESS;
1230:
1231: IF fnd_api.to_boolean(p_init_msg_list) THEN
1232: fnd_msg_pub.initialize;
1233: END IF;

Line 1231: IF fnd_api.to_boolean(p_init_msg_list) THEN

1227: SAVEPOINT create_schedule;
1228:
1229: x_return_status := fnd_api.G_RET_STS_SUCCESS;
1230:
1231: IF fnd_api.to_boolean(p_init_msg_list) THEN
1232: fnd_msg_pub.initialize;
1233: END IF;
1234:
1235: l_n := 1;

Line 1244: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN

1240: p_mode => 'INSERT',
1241: x_return_status => x_return_status);
1242:
1243:
1244: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
1245: RAISE fnd_api.G_EXC_ERROR;
1246: END IF;
1247:
1248: l_n := 2;

Line 1245: RAISE fnd_api.G_EXC_ERROR;

1241: x_return_status => x_return_status);
1242:
1243:
1244: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
1245: RAISE fnd_api.G_EXC_ERROR;
1246: END IF;
1247:
1248: l_n := 2;
1249: OPEN cu_schedule_id;

Line 1278: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN

1274: P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER,
1275: x_return_status => x_return_status);
1276:
1277: l_n := 4;
1278: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
1279: RAISE fnd_api.G_EXC_ERROR;
1280: END IF;
1281:
1282: x_schedule_id := l_schedule_id;

Line 1279: RAISE fnd_api.G_EXC_ERROR;

1275: x_return_status => x_return_status);
1276:
1277: l_n := 4;
1278: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
1279: RAISE fnd_api.G_EXC_ERROR;
1280: END IF;
1281:
1282: x_schedule_id := l_schedule_id;
1283:

Line 1287: WHEN FND_API.G_EXC_ERROR THEN

1283:
1284: arp_standard.debug('create_schedule -');
1285:
1286: EXCEPTION
1287: WHEN FND_API.G_EXC_ERROR THEN
1288: ROLLBACK TO create_schedule;
1289: FND_MSG_PUB.Count_And_Get(
1290: p_encoded => FND_API.G_FALSE,
1291: p_count => x_msg_count,

Line 1290: p_encoded => FND_API.G_FALSE,

1286: EXCEPTION
1287: WHEN FND_API.G_EXC_ERROR THEN
1288: ROLLBACK TO create_schedule;
1289: FND_MSG_PUB.Count_And_Get(
1290: p_encoded => FND_API.G_FALSE,
1291: p_count => x_msg_count,
1292: p_data => x_msg_data);
1293: arp_standard.debug('EXCEPTION create_schedule:'||x_msg_data);
1294:

Line 1297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1293: arp_standard.debug('EXCEPTION create_schedule:'||x_msg_data);
1294:
1295: WHEN OTHERS THEN
1296: ROLLBACK TO create_schedule;
1297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1298: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1299: FND_MESSAGE.SET_TOKEN('ERROR' ,l_n||' '||SQLERRM);
1300: FND_MSG_PUB.ADD;
1301: FND_MSG_PUB.Count_And_Get(

Line 1302: p_encoded => FND_API.G_FALSE,

1298: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1299: FND_MESSAGE.SET_TOKEN('ERROR' ,l_n||' '||SQLERRM);
1300: FND_MSG_PUB.ADD;
1301: FND_MSG_PUB.Count_And_Get(
1302: p_encoded => FND_API.G_FALSE,
1303: p_count => x_msg_count,
1304: p_data => x_msg_data);
1305: arp_standard.debug('EXCEPTION create_schedule:'||x_msg_data);
1306: END;

Line 1310: (p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

1306: END;
1307:
1308:
1309: PROCEDURE update_schedule
1310: (p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1311: P_SCHEDULE_ID IN NUMBER,
1312: P_SCHEDULE_DESCRIPTION IN VARCHAR2,
1313: P_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,
1314: P_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL,

Line 1366: IF fnd_api.to_boolean(p_init_msg_list) THEN

1362: arp_standard.debug(' P_SCHEDULE_DESCRIPTION :'||P_SCHEDULE_DESCRIPTION);
1363:
1364: SAVEPOINT update_schedule;
1365:
1366: IF fnd_api.to_boolean(p_init_msg_list) THEN
1367: fnd_msg_pub.initialize;
1368: END IF;
1369:
1370: x_return_status := fnd_api.G_RET_STS_SUCCESS;

Line 1370: x_return_status := fnd_api.G_RET_STS_SUCCESS;

1366: IF fnd_api.to_boolean(p_init_msg_list) THEN
1367: fnd_msg_pub.initialize;
1368: END IF;
1369:
1370: x_return_status := fnd_api.G_RET_STS_SUCCESS;
1371:
1372: OPEN c;
1373: FETCH c INTO
1374: l_rec.SCHEDULE_ID ,

Line 1402: RAISE fnd_api.g_exc_error;

1398: fnd_message.set_token('RECORD', 'ar_charge_schedules');
1399: fnd_message.set_token('VALUE',
1400: NVL(TO_CHAR(P_SCHEDULE_ID), 'null'));
1401: fnd_msg_pub.add;
1402: RAISE fnd_api.g_exc_error;
1403: END IF;
1404:
1405:
1406: IF NOT ((x_object_version_number IS NULL AND

Line 1415: RAISE fnd_api.g_exc_error;

1411: THEN
1412: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
1413: fnd_message.set_token('TABLE', 'ar_charge_schedules');
1414: fnd_msg_pub.add;
1415: RAISE fnd_api.g_exc_error;
1416: END IF;
1417:
1418:
1419: validate_schedule

Line 1425: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN

1421: p_schedule_description => P_SCHEDULE_DESCRIPTION,
1422: p_mode => 'UPDATE',
1423: x_return_status => x_return_status);
1424:
1425: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
1426: RAISE fnd_api.G_EXC_ERROR;
1427: END IF;
1428:
1429: Update_schedule_row

Line 1426: RAISE fnd_api.G_EXC_ERROR;

1422: p_mode => 'UPDATE',
1423: x_return_status => x_return_status);
1424:
1425: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
1426: RAISE fnd_api.G_EXC_ERROR;
1427: END IF;
1428:
1429: Update_schedule_row
1430: (P_SCHEDULE_ID => P_SCHEDULE_ID,

Line 1451: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN

1447: P_ATTRIBUTE15 => p_attribute15,
1448: X_OBJECT_VERSION_NUMBER=> X_OBJECT_VERSION_NUMBER,
1449: x_return_status => x_return_status);
1450:
1451: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
1452: RAISE fnd_api.g_exc_error;
1453: END IF;
1454:
1455: arp_standard.debug('Update_schedule -');

Line 1452: RAISE fnd_api.g_exc_error;

1448: X_OBJECT_VERSION_NUMBER=> X_OBJECT_VERSION_NUMBER,
1449: x_return_status => x_return_status);
1450:
1451: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
1452: RAISE fnd_api.g_exc_error;
1453: END IF;
1454:
1455: arp_standard.debug('Update_schedule -');
1456:

Line 1458: WHEN FND_API.G_EXC_ERROR THEN

1454:
1455: arp_standard.debug('Update_schedule -');
1456:
1457: EXCEPTION
1458: WHEN FND_API.G_EXC_ERROR THEN
1459: ROLLBACK TO Update_schedule;
1460: FND_MSG_PUB.Count_And_Get(
1461: p_encoded => FND_API.G_FALSE,
1462: p_count => x_msg_count,

Line 1461: p_encoded => FND_API.G_FALSE,

1457: EXCEPTION
1458: WHEN FND_API.G_EXC_ERROR THEN
1459: ROLLBACK TO Update_schedule;
1460: FND_MSG_PUB.Count_And_Get(
1461: p_encoded => FND_API.G_FALSE,
1462: p_count => x_msg_count,
1463: p_data => x_msg_data);
1464: arp_standard.debug('EXCEPTION Update_schedule:'||x_msg_data);
1465:

Line 1468: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1464: arp_standard.debug('EXCEPTION Update_schedule:'||x_msg_data);
1465:
1466: WHEN OTHERS THEN
1467: ROLLBACK TO Update_schedule;
1468: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1469: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1470: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1471: FND_MSG_PUB.ADD;
1472: FND_MSG_PUB.Count_And_Get(

Line 1473: p_encoded => FND_API.G_FALSE,

1469: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1470: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1471: FND_MSG_PUB.ADD;
1472: FND_MSG_PUB.Count_And_Get(
1473: p_encoded => FND_API.G_FALSE,
1474: p_count => x_msg_count,
1475: p_data => x_msg_data);
1476: arp_standard.debug('EXCEPTION Update_schedule:'||x_msg_data);
1477: END;

Line 1484: (p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

1480:
1481:
1482:
1483: PROCEDURE create_schedule_header
1484: (p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1485: P_SCHEDULE_ID IN NUMBER,
1486: P_SCHEDULE_HEADER_TYPE IN VARCHAR2,
1487: P_AGING_BUCKET_ID IN NUMBER,
1488: P_START_DATE IN DATE,

Line 1526: x_return_status := fnd_api.G_RET_STS_SUCCESS;

1522: arp_standard.debug(' p_end_date :'||p_end_date);
1523:
1524: savepoint create_schedule_header;
1525:
1526: x_return_status := fnd_api.G_RET_STS_SUCCESS;
1527:
1528: IF fnd_api.to_boolean(p_init_msg_list) THEN
1529: fnd_msg_pub.initialize;
1530: END IF;

Line 1528: IF fnd_api.to_boolean(p_init_msg_list) THEN

1524: savepoint create_schedule_header;
1525:
1526: x_return_status := fnd_api.G_RET_STS_SUCCESS;
1527:
1528: IF fnd_api.to_boolean(p_init_msg_list) THEN
1529: fnd_msg_pub.initialize;
1530: END IF;
1531:
1532:

Line 1546: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN

1542: p_mode => 'INSERT',
1543: x_return_status => x_return_status);
1544:
1545:
1546: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
1547: RAISE fnd_api.G_EXC_ERROR;
1548: END IF;
1549:
1550: OPEN cu_header_id;

Line 1547: RAISE fnd_api.G_EXC_ERROR;

1543: x_return_status => x_return_status);
1544:
1545:
1546: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
1547: RAISE fnd_api.G_EXC_ERROR;
1548: END IF;
1549:
1550: OPEN cu_header_id;
1551: FETCH cu_header_id INTO l_header_id;

Line 1582: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN

1578: P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER,
1579: x_return_status => x_return_status);
1580:
1581:
1582: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
1583: RAISE fnd_api.G_EXC_ERROR;
1584: END IF;
1585:
1586: x_SCHEDULE_HEADER_ID := l_header_id;

Line 1583: RAISE fnd_api.G_EXC_ERROR;

1579: x_return_status => x_return_status);
1580:
1581:
1582: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
1583: RAISE fnd_api.G_EXC_ERROR;
1584: END IF;
1585:
1586: x_SCHEDULE_HEADER_ID := l_header_id;
1587:

Line 1591: WHEN FND_API.G_EXC_ERROR THEN

1587:
1588: arp_standard.debug('create_schedule_header -');
1589:
1590: EXCEPTION
1591: WHEN FND_API.G_EXC_ERROR THEN
1592: ROLLBACK TO create_schedule_header;
1593: FND_MSG_PUB.Count_And_Get(
1594: p_encoded => FND_API.G_FALSE,
1595: p_count => x_msg_count,

Line 1594: p_encoded => FND_API.G_FALSE,

1590: EXCEPTION
1591: WHEN FND_API.G_EXC_ERROR THEN
1592: ROLLBACK TO create_schedule_header;
1593: FND_MSG_PUB.Count_And_Get(
1594: p_encoded => FND_API.G_FALSE,
1595: p_count => x_msg_count,
1596: p_data => x_msg_data);
1597: arp_standard.debug('EXCEPTION create_schedule_header:'||x_msg_data);
1598:

Line 1601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1597: arp_standard.debug('EXCEPTION create_schedule_header:'||x_msg_data);
1598:
1599: WHEN OTHERS THEN
1600: ROLLBACK TO create_schedule_header;
1601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1602: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1603: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1604: FND_MSG_PUB.ADD;
1605: FND_MSG_PUB.Count_And_Get(

Line 1606: p_encoded => FND_API.G_FALSE,

1602: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1603: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1604: FND_MSG_PUB.ADD;
1605: FND_MSG_PUB.Count_And_Get(
1606: p_encoded => FND_API.G_FALSE,
1607: p_count => x_msg_count,
1608: p_data => x_msg_data);
1609: arp_standard.debug('EXCEPTION create_schedule_header:'||x_msg_data);
1610: END;

Line 1614: (p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

1610: END;
1611:
1612:
1613: PROCEDURE Update_schedule_header
1614: (p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1615: P_SCHEDULE_HEADER_ID IN NUMBER,
1616: P_END_DATE IN DATE,
1617: P_STATUS IN VARCHAR2,
1618: P_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,

Line 1677: IF fnd_api.to_boolean(p_init_msg_list) THEN

1673: arp_standard.debug(' X_OBJECT_VERSION_NUMBER :'||X_OBJECT_VERSION_NUMBER);
1674:
1675: savepoint Update_schedule_header;
1676:
1677: IF fnd_api.to_boolean(p_init_msg_list) THEN
1678: fnd_msg_pub.initialize;
1679: END IF;
1680:
1681: x_return_status := fnd_api.G_RET_STS_SUCCESS;

Line 1681: x_return_status := fnd_api.G_RET_STS_SUCCESS;

1677: IF fnd_api.to_boolean(p_init_msg_list) THEN
1678: fnd_msg_pub.initialize;
1679: END IF;
1680:
1681: x_return_status := fnd_api.G_RET_STS_SUCCESS;
1682:
1683: OPEN c;
1684: FETCH c INTO
1685: l_rec.SCHEDULE_ID ,

Line 1717: RAISE fnd_api.g_exc_error;

1713: fnd_message.set_token('RECORD', 'ar_charge_schedule_hdrs');
1714: fnd_message.set_token('VALUE',
1715: NVL(TO_CHAR(P_SCHEDULE_HEADER_ID), 'null'));
1716: fnd_msg_pub.add;
1717: RAISE fnd_api.g_exc_error;
1718: END IF;
1719:
1720:
1721: IF NOT ((x_object_version_number IS NULL AND

Line 1730: RAISE fnd_api.g_exc_error;

1726: THEN
1727: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
1728: fnd_message.set_token('TABLE', 'ar_charge_schedule_hdrs');
1729: fnd_msg_pub.add;
1730: RAISE fnd_api.g_exc_error;
1731: END IF;
1732:
1733:
1734: validate_schedule_header

Line 1747: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN

1743: p_mode => 'UPDATE',
1744: x_return_status => x_return_status);
1745:
1746:
1747: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
1748: RAISE fnd_api.g_exc_error;
1749: END IF;
1750:
1751: Update_Head_Row

Line 1748: RAISE fnd_api.g_exc_error;

1744: x_return_status => x_return_status);
1745:
1746:
1747: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
1748: RAISE fnd_api.g_exc_error;
1749: END IF;
1750:
1751: Update_Head_Row
1752: (P_SCHEDULE_HEADER_ID => l_rec.SCHEDULE_HEADER_ID,

Line 1774: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN

1770: P_ATTRIBUTE15 => p_attribute15,
1771: X_OBJECT_VERSION_NUMBER=> X_OBJECT_VERSION_NUMBER,
1772: x_return_status => x_return_status);
1773:
1774: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
1775: RAISE fnd_api.g_exc_error;
1776: END IF;
1777:
1778: arp_standard.debug('Update_schedule_header -');

Line 1775: RAISE fnd_api.g_exc_error;

1771: X_OBJECT_VERSION_NUMBER=> X_OBJECT_VERSION_NUMBER,
1772: x_return_status => x_return_status);
1773:
1774: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
1775: RAISE fnd_api.g_exc_error;
1776: END IF;
1777:
1778: arp_standard.debug('Update_schedule_header -');
1779:

Line 1781: WHEN FND_API.G_EXC_ERROR THEN

1777:
1778: arp_standard.debug('Update_schedule_header -');
1779:
1780: EXCEPTION
1781: WHEN FND_API.G_EXC_ERROR THEN
1782: ROLLBACK TO Update_schedule_header;
1783: FND_MSG_PUB.Count_And_Get(
1784: p_encoded => FND_API.G_FALSE,
1785: p_count => x_msg_count,

Line 1784: p_encoded => FND_API.G_FALSE,

1780: EXCEPTION
1781: WHEN FND_API.G_EXC_ERROR THEN
1782: ROLLBACK TO Update_schedule_header;
1783: FND_MSG_PUB.Count_And_Get(
1784: p_encoded => FND_API.G_FALSE,
1785: p_count => x_msg_count,
1786: p_data => x_msg_data);
1787: arp_standard.debug('EXCEPTION Update_schedule_header:'||x_msg_data);
1788:

Line 1791: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1787: arp_standard.debug('EXCEPTION Update_schedule_header:'||x_msg_data);
1788:
1789: WHEN OTHERS THEN
1790: ROLLBACK TO Update_schedule_header;
1791: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1792: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1793: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1794: FND_MSG_PUB.ADD;
1795: FND_MSG_PUB.Count_And_Get(

Line 1796: p_encoded => FND_API.G_FALSE,

1792: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1793: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1794: FND_MSG_PUB.ADD;
1795: FND_MSG_PUB.Count_And_Get(
1796: p_encoded => FND_API.G_FALSE,
1797: p_count => x_msg_count,
1798: p_data => x_msg_data);
1799: arp_standard.debug('EXCEPTION Update_schedule_header:'||x_msg_data);
1800: END;

Line 1805: (p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

1801:
1802:
1803:
1804: PROCEDURE create_schedule_line
1805: (p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1806: P_SCHEDULE_HEADER_ID IN NUMBER,
1807: P_SCHEDULE_ID IN NUMBER,
1808: P_AGING_BUCKET_ID IN NUMBER,
1809: P_AGING_BUCKET_LINE_ID IN NUMBER,

Line 1849: x_return_status := fnd_api.G_RET_STS_SUCCESS;

1845: arp_standard.debug(' P_RATE :'||P_RATE);
1846:
1847: SAVEPOINT create_schedule_line;
1848:
1849: x_return_status := fnd_api.G_RET_STS_SUCCESS;
1850:
1851: IF fnd_api.to_boolean(p_init_msg_list) THEN
1852: fnd_msg_pub.initialize;
1853: END IF;

Line 1851: IF fnd_api.to_boolean(p_init_msg_list) THEN

1847: SAVEPOINT create_schedule_line;
1848:
1849: x_return_status := fnd_api.G_RET_STS_SUCCESS;
1850:
1851: IF fnd_api.to_boolean(p_init_msg_list) THEN
1852: fnd_msg_pub.initialize;
1853: END IF;
1854:
1855: validate_schedule_line

Line 1867: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN

1863: P_MODE => 'INSERT',
1864: x_return_status => x_return_status);
1865:
1866:
1867: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
1868: RAISE fnd_api.G_EXC_ERROR;
1869: END IF;
1870:
1871: OPEN cu_line_id;

Line 1868: RAISE fnd_api.G_EXC_ERROR;

1864: x_return_status => x_return_status);
1865:
1866:
1867: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
1868: RAISE fnd_api.G_EXC_ERROR;
1869: END IF;
1870:
1871: OPEN cu_line_id;
1872: FETCH cu_line_id INTO l_line_id;

Line 1903: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN

1899: P_ATTRIBUTE15 => P_ATTRIBUTE15,
1900: P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER,
1901: x_return_status => x_return_status);
1902:
1903: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
1904: RAISE fnd_api.g_exc_error;
1905: END IF;
1906:
1907: X_SCHEDULE_LINE_ID := l_line_id;

Line 1904: RAISE fnd_api.g_exc_error;

1900: P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER,
1901: x_return_status => x_return_status);
1902:
1903: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
1904: RAISE fnd_api.g_exc_error;
1905: END IF;
1906:
1907: X_SCHEDULE_LINE_ID := l_line_id;
1908:

Line 1912: WHEN FND_API.G_EXC_ERROR THEN

1908:
1909: arp_standard.debug('create_schedule_line -');
1910:
1911: EXCEPTION
1912: WHEN FND_API.G_EXC_ERROR THEN
1913: ROLLBACK TO create_schedule_line;
1914: FND_MSG_PUB.Count_And_Get(
1915: p_encoded => FND_API.G_FALSE,
1916: p_count => x_msg_count,

Line 1915: p_encoded => FND_API.G_FALSE,

1911: EXCEPTION
1912: WHEN FND_API.G_EXC_ERROR THEN
1913: ROLLBACK TO create_schedule_line;
1914: FND_MSG_PUB.Count_And_Get(
1915: p_encoded => FND_API.G_FALSE,
1916: p_count => x_msg_count,
1917: p_data => x_msg_data);
1918: arp_standard.debug('EXCEPTION create_schedule_line :'||x_msg_data);
1919:

Line 1922: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1918: arp_standard.debug('EXCEPTION create_schedule_line :'||x_msg_data);
1919:
1920: WHEN OTHERS THEN
1921: ROLLBACK TO create_schedule_line;
1922: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1923: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1924: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1925: FND_MSG_PUB.ADD;
1926: FND_MSG_PUB.Count_And_Get(

Line 1927: p_encoded => FND_API.G_FALSE,

1923: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1924: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1925: FND_MSG_PUB.ADD;
1926: FND_MSG_PUB.Count_And_Get(
1927: p_encoded => FND_API.G_FALSE,
1928: p_count => x_msg_count,
1929: p_data => x_msg_data);
1930: arp_standard.debug('EXCEPTION create_schedule_line :'||x_msg_data);
1931: END;

Line 1934: (p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

1930: arp_standard.debug('EXCEPTION create_schedule_line :'||x_msg_data);
1931: END;
1932:
1933: PROCEDURE Update_schedule_line
1934: (p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1935: P_SCHEDULE_line_ID IN NUMBER,
1936: P_amount IN NUMBER,
1937: P_rate IN NUMBER,
1938: P_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,

Line 1996: IF fnd_api.to_boolean(p_init_msg_list) THEN

1992: arp_standard.debug(' X_OBJECT_VERSION_NUMBER :'||X_OBJECT_VERSION_NUMBER);
1993:
1994: savepoint Update_schedule_line;
1995:
1996: IF fnd_api.to_boolean(p_init_msg_list) THEN
1997: fnd_msg_pub.initialize;
1998: END IF;
1999:
2000: x_return_status := fnd_api.G_RET_STS_SUCCESS;

Line 2000: x_return_status := fnd_api.G_RET_STS_SUCCESS;

1996: IF fnd_api.to_boolean(p_init_msg_list) THEN
1997: fnd_msg_pub.initialize;
1998: END IF;
1999:
2000: x_return_status := fnd_api.G_RET_STS_SUCCESS;
2001:
2002: OPEN c;
2003: FETCH c INTO
2004: l_rec.SCHEDULE_ID ,

Line 2034: RAISE fnd_api.g_exc_error;

2030: fnd_message.set_token('RECORD', 'ar_charge_schedule_lines');
2031: fnd_message.set_token('VALUE',
2032: NVL(TO_CHAR(P_SCHEDULE_line_ID), 'null'));
2033: fnd_msg_pub.add;
2034: RAISE fnd_api.g_exc_error;
2035: END IF;
2036:
2037:
2038: IF NOT ((x_object_version_number IS NULL AND

Line 2047: RAISE fnd_api.g_exc_error;

2043: THEN
2044: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
2045: fnd_message.set_token('TABLE', 'ar_charge_schedule_lines');
2046: fnd_msg_pub.add;
2047: RAISE fnd_api.g_exc_error;
2048: END IF;
2049:
2050: /* This would be the place to call validate_line
2051: validate_schedule_line

Line 2062: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN

2058: P_RATE => p_rate,
2059: P_MODE => 'UPDATE',
2060: x_return_status => x_return_status);
2061:
2062: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
2063: RAISE fnd_api.g_exc_error;
2064: END IF;
2065: */
2066:

Line 2063: RAISE fnd_api.g_exc_error;

2059: P_MODE => 'UPDATE',
2060: x_return_status => x_return_status);
2061:
2062: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
2063: RAISE fnd_api.g_exc_error;
2064: END IF;
2065: */
2066:
2067: Update_line_Row

Line 2090: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN

2086: P_ATTRIBUTE15 => p_attribute15,
2087: X_OBJECT_VERSION_NUMBER=> X_OBJECT_VERSION_NUMBER,
2088: x_return_status => x_return_status);
2089:
2090: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
2091: RAISE fnd_api.g_exc_error;
2092: END IF;
2093:
2094: arp_standard.debug('Update_schedule_line -');

Line 2091: RAISE fnd_api.g_exc_error;

2087: X_OBJECT_VERSION_NUMBER=> X_OBJECT_VERSION_NUMBER,
2088: x_return_status => x_return_status);
2089:
2090: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
2091: RAISE fnd_api.g_exc_error;
2092: END IF;
2093:
2094: arp_standard.debug('Update_schedule_line -');
2095:

Line 2097: WHEN FND_API.G_EXC_ERROR THEN

2093:
2094: arp_standard.debug('Update_schedule_line -');
2095:
2096: EXCEPTION
2097: WHEN FND_API.G_EXC_ERROR THEN
2098: ROLLBACK TO Update_schedule_line;
2099: FND_MSG_PUB.Count_And_Get(
2100: p_encoded => FND_API.G_FALSE,
2101: p_count => x_msg_count,

Line 2100: p_encoded => FND_API.G_FALSE,

2096: EXCEPTION
2097: WHEN FND_API.G_EXC_ERROR THEN
2098: ROLLBACK TO Update_schedule_line;
2099: FND_MSG_PUB.Count_And_Get(
2100: p_encoded => FND_API.G_FALSE,
2101: p_count => x_msg_count,
2102: p_data => x_msg_data);
2103: arp_standard.debug('EXCEPTION Update_schedule_line:'||x_msg_data);
2104:

Line 2107: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2103: arp_standard.debug('EXCEPTION Update_schedule_line:'||x_msg_data);
2104:
2105: WHEN OTHERS THEN
2106: ROLLBACK TO Update_schedule_header;
2107: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2108: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2109: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2110: FND_MSG_PUB.ADD;
2111: FND_MSG_PUB.Count_And_Get(

Line 2112: p_encoded => FND_API.G_FALSE,

2108: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2109: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2110: FND_MSG_PUB.ADD;
2111: FND_MSG_PUB.Count_And_Get(
2112: p_encoded => FND_API.G_FALSE,
2113: p_count => x_msg_count,
2114: p_data => x_msg_data);
2115: arp_standard.debug('EXCEPTION Update_schedule_line:'||x_msg_data);
2116: END;