[Home] [Help]
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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,
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),
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),
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),
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;
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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;
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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,
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),
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),
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),
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;
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 ),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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;
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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,
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),
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),
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),
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;
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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),
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;
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
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
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
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;
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;
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;
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
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:
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;
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');
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:
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;
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');
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:
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;
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 -');
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;
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 );
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
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;
868: fnd_message.set_token('END_DATE_PER_1' , fnd_date.date_to_chardate(l_end_date, calendar_aware=> FND_DATE.calendar_aware_alt));
869: fnd_message.set_token('START_DATE_PER_2', fnd_date.date_to_chardate(p_start_date, calendar_aware=> FND_DATE.calendar_aware_alt));
870: fnd_message.set_token('END_DATE_PER_2' , fnd_date.date_to_chardate(p_end_date, calendar_aware=> FND_DATE.calendar_aware_alt));
871: fnd_msg_pub.add;
872: x_return_status := fnd_api.g_ret_sts_error;
873: END IF;
874: END IF;
875: IF x_return_status <> fnd_api.g_ret_sts_success THEN
876: EXIT;
871: fnd_msg_pub.add;
872: x_return_status := fnd_api.g_ret_sts_error;
873: END IF;
874: END IF;
875: IF x_return_status <> fnd_api.g_ret_sts_success THEN
876: EXIT;
877: END IF;
878: END LOOP;
879: CLOSE c_overlapp;
887: -------------------------------------------------------------
888: -- Validate STATUS lookup code in lookup type REGISTRY_STATUS
889: -------------------------------------------------------------
890: arp_standard.debug(' Validate status +');
891: IF p_status = fnd_api.g_miss_char THEN
892: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
893: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'status' );
894: FND_MSG_PUB.ADD;
895: x_return_status := FND_API.G_RET_STS_ERROR;
891: IF p_status = fnd_api.g_miss_char THEN
892: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
893: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'status' );
894: FND_MSG_PUB.ADD;
895: x_return_status := FND_API.G_RET_STS_ERROR;
896: END IF;
897:
898: IF p_status IS NOT NULL THEN
899: IF validate_lookup('REGISTRY_STATUS',p_status) = FALSE THEN
901: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_LOOKUP' );
902: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'status' );
903: FND_MESSAGE.SET_TOKEN( 'LOOKUP_TYPE', 'REGISTRY_STATUS' );
904: FND_MSG_PUB.ADD;
905: x_return_status := FND_API.G_RET_STS_ERROR;
906: END IF;
907: END IF;
908:
909: IF p_old_status = 'I' AND p_status = 'A' THEN
909: IF p_old_status = 'I' AND p_status = 'A' THEN
910: arp_standard.debug(' Schedule Header can not be reactivated');
911: FND_MESSAGE.SET_NAME( 'AR', 'AR_NO_REACTIVATE_ALLOW' );
912: FND_MSG_PUB.ADD;
913: x_return_status := FND_API.G_RET_STS_ERROR;
914: END IF;
915:
916: arp_standard.debug(' Validate status -');
917:
918: -----------------------------------
919: -- Validate start_date and end_date
920: -----------------------------------
921: arp_standard.debug(' validate start and end dates +');
922: IF p_end_date IS NOT NULL AND p_end_date <> FND_API.G_MISS_DATE THEN
923: l_val := compare(date1 => p_start_date,
924: date2 => p_end_date );
925: IF l_val = 1 THEN
926: arp_standard.debug(' end date should be greater than the start date');
927: fnd_message.set_name('AR', 'HZ_API_DATE_GREATER');
928: fnd_message.set_token('DATE2', 'end_date');
929: fnd_message.set_token('DATE1', 'start_date');
930: fnd_msg_pub.add;
931: x_return_status := fnd_api.g_ret_sts_error;
932: END IF;
933: IF x_return_status = fnd_api.g_ret_sts_success THEN
934: arp_standard.debug(' Check overlappings of periods');
935: OPEN c_overlapp_upd;
929: fnd_message.set_token('DATE1', 'start_date');
930: fnd_msg_pub.add;
931: x_return_status := fnd_api.g_ret_sts_error;
932: END IF;
933: IF x_return_status = fnd_api.g_ret_sts_success THEN
934: arp_standard.debug(' Check overlappings of periods');
935: OPEN c_overlapp_upd;
936: LOOP
937: FETCH c_overlapp_upd INTO l_start_date, l_end_date;
954: fnd_message.set_token('END_DATE_PER_1' , fnd_date.date_to_chardate(l_end_date, calendar_aware=> FND_DATE.calendar_aware_alt));
955: fnd_message.set_token('START_DATE_PER_2', fnd_date.date_to_chardate(p_start_date, calendar_aware=> FND_DATE.calendar_aware_alt));
956: fnd_message.set_token('END_DATE_PER_2' , fnd_date.date_to_chardate(p_end_date, calendar_aware=> FND_DATE.calendar_aware_alt));
957: fnd_msg_pub.add;
958: x_return_status := fnd_api.g_ret_sts_error;
959: END IF;
960: END IF;
961: IF x_return_status <> fnd_api.g_ret_sts_success THEN
962: EXIT;
957: fnd_msg_pub.add;
958: x_return_status := fnd_api.g_ret_sts_error;
959: END IF;
960: END IF;
961: IF x_return_status <> fnd_api.g_ret_sts_success THEN
962: EXIT;
963: END IF;
964: END LOOP;
965: CLOSE c_overlapp_upd;
1026: -- Validate schedule_header_id
1027: -------------------------------------
1028: arp_standard.debug(' Validate schedule_header_id +');
1029:
1030: IF p_schedule_header_id IS NULL OR p_schedule_header_id = fnd_api.g_miss_num THEN
1031: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
1032: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'schedule_header_id' );
1033: FND_MSG_PUB.ADD;
1034: x_return_status := FND_API.G_RET_STS_ERROR;
1030: IF p_schedule_header_id IS NULL OR p_schedule_header_id = fnd_api.g_miss_num THEN
1031: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
1032: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'schedule_header_id' );
1033: FND_MSG_PUB.ADD;
1034: x_return_status := FND_API.G_RET_STS_ERROR;
1035: END IF;
1036:
1037: OPEN c_header;
1038: FETCH c_header INTO l_rec;
1041: FND_MESSAGE.SET_TOKEN('FK', 'schedule header');
1042: FND_MESSAGE.SET_TOKEN('COLUMN', 'schedule_header_id');
1043: FND_MESSAGE.SET_TOKEN('TABLE', 'ar_charge_schedule_hdrs');
1044: FND_MSG_PUB.ADD;
1045: x_return_status := FND_API.G_RET_STS_ERROR;
1046: END IF;
1047: CLOSE c_header;
1048: arp_standard.debug(' Validate schedule_header_id -');
1049:
1051: ------------------------
1052: -- Validate schedule_id
1053: ------------------------
1054: arp_standard.debug(' Validate schedule_id +');
1055: IF p_schedule_id IS NULL OR p_schedule_id = fnd_api.g_miss_num THEN
1056: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
1057: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'schedule_id' );
1058: FND_MSG_PUB.ADD;
1059: x_return_status := FND_API.G_RET_STS_ERROR;
1055: IF p_schedule_id IS NULL OR p_schedule_id = fnd_api.g_miss_num THEN
1056: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
1057: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'schedule_id' );
1058: FND_MSG_PUB.ADD;
1059: x_return_status := FND_API.G_RET_STS_ERROR;
1060: ELSE
1061: IF p_schedule_id <> l_rec.schedule_id THEN
1062: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
1063: FND_MESSAGE.SET_TOKEN('FK', 'schedule header');
1063: FND_MESSAGE.SET_TOKEN('FK', 'schedule header');
1064: FND_MESSAGE.SET_TOKEN('COLUMN', 'schedule_id');
1065: FND_MESSAGE.SET_TOKEN('TABLE', 'ar_charge_schedule_hdrs');
1066: FND_MSG_PUB.ADD;
1067: x_return_status := FND_API.G_RET_STS_ERROR;
1068: END IF;
1069: END IF;
1070: arp_standard.debug(' Validate schedule_id -');
1071:
1073: ---------------------------
1074: -- Validate aging_bucket_id
1075: ---------------------------
1076: arp_standard.debug(' Validate aging_bucket_id +');
1077: IF P_AGING_BUCKET_ID IS NULL OR P_AGING_BUCKET_ID = fnd_api.g_miss_num THEN
1078: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
1079: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'P_AGING_BUCKET_ID' );
1080: FND_MSG_PUB.ADD;
1081: x_return_status := FND_API.G_RET_STS_ERROR;
1077: IF P_AGING_BUCKET_ID IS NULL OR P_AGING_BUCKET_ID = fnd_api.g_miss_num THEN
1078: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
1079: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'P_AGING_BUCKET_ID' );
1080: FND_MSG_PUB.ADD;
1081: x_return_status := FND_API.G_RET_STS_ERROR;
1082: ELSE
1083: IF P_AGING_BUCKET_ID <> l_rec.aging_bucket_id THEN
1084: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
1085: FND_MESSAGE.SET_TOKEN('FK', 'schedule header');
1085: FND_MESSAGE.SET_TOKEN('FK', 'schedule header');
1086: FND_MESSAGE.SET_TOKEN('COLUMN', 'aging_bucket_id');
1087: FND_MESSAGE.SET_TOKEN('TABLE', 'ar_charge_schedule_hdrs');
1088: FND_MSG_PUB.ADD;
1089: x_return_status := FND_API.G_RET_STS_ERROR;
1090: END IF;
1091: END IF;
1092: arp_standard.debug(' Validate aging_bucket_id -');
1093:
1108: fnd_message.set_token('COLUMN1', 'schedule_header_id');
1109: fnd_message.set_token('COLUMN2', 'aging_bucket_id');
1110: fnd_message.set_token('COLUMN3', 'aging_bucket_line_id');
1111: fnd_msg_pub.add;
1112: x_return_status := fnd_api.g_ret_sts_error;
1113: END IF;
1114: CLOSE ar_schedule_line_u2;
1115: arp_standard.debug(' unidicity of ar_schedule_line_u2 -');
1116:
1118: ---------------------------------
1119: -- Validate aging_bucket_line_id
1120: ---------------------------------
1121: arp_standard.debug(' Validate aging_bucket_id and aging_bucket_line_id +');
1122: IF p_aging_bucket_line_id IS NULL OR p_aging_bucket_line_id = fnd_api.g_miss_num
1123: THEN
1124: IF p_aging_bucket_line_id IS NULL or p_aging_bucket_line_id = fnd_api.g_miss_num THEN
1125: arp_standard.debug(' AGING_BUCKET_LINE_ID missing');
1126: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
1120: ---------------------------------
1121: arp_standard.debug(' Validate aging_bucket_id and aging_bucket_line_id +');
1122: IF p_aging_bucket_line_id IS NULL OR p_aging_bucket_line_id = fnd_api.g_miss_num
1123: THEN
1124: IF p_aging_bucket_line_id IS NULL or p_aging_bucket_line_id = fnd_api.g_miss_num THEN
1125: arp_standard.debug(' AGING_BUCKET_LINE_ID missing');
1126: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
1127: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'AGING_BUCKET_LINE_ID' );
1128: FND_MSG_PUB.ADD;
1125: arp_standard.debug(' AGING_BUCKET_LINE_ID missing');
1126: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
1127: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'AGING_BUCKET_LINE_ID' );
1128: FND_MSG_PUB.ADD;
1129: x_return_status := FND_API.G_RET_STS_ERROR;
1130: END IF;
1131: ELSE
1132: IF p_aging_bucket_id IS NOT NULL AND p_aging_bucket_id <> FND_API.G_MISS_NUM THEN
1133: OPEN c_aging_bucket_id(p_aging_bucket_id, p_aging_bucket_line_id);
1128: FND_MSG_PUB.ADD;
1129: x_return_status := FND_API.G_RET_STS_ERROR;
1130: END IF;
1131: ELSE
1132: IF p_aging_bucket_id IS NOT NULL AND p_aging_bucket_id <> FND_API.G_MISS_NUM THEN
1133: OPEN c_aging_bucket_id(p_aging_bucket_id, p_aging_bucket_line_id);
1134: FETCH c_aging_bucket_id INTO l_c;
1135: IF c_aging_bucket_id%NOTFOUND THEN
1136: arp_standard.debug(' AGING_BUCKET_ID/AGING_BUCKET_LINE_ID are not valid');
1143: FND_MESSAGE.SET_TOKEN( 'FK', 'aging_bucket_line_id' );
1144: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'aging_bucket_line_id' );
1145: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_aging_bucket_lines_b');
1146: FND_MSG_PUB.ADD;
1147: x_return_status := FND_API.G_RET_STS_ERROR;
1148: END IF;
1149: CLOSE c_aging_bucket_id;
1150: END IF;
1151: END IF;
1161: OPEN cl;
1162: FETCH cl INTO l_c;
1163: CLOSE cl;
1164:
1165: IF (p_amount IS NULL OR p_amount = FND_API.G_MISS_NUM) AND
1166: (l_c = 'AMOUNT')
1167: THEN
1168: arp_standard.debug(' The amount column is mandatory for SCHEDULE_HEADER_TYPE :'||l_c);
1169: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
1168: arp_standard.debug(' The amount column is mandatory for SCHEDULE_HEADER_TYPE :'||l_c);
1169: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
1170: fnd_message.set_token('COLUMN', 'AMOUNT');
1171: FND_MSG_PUB.ADD;
1172: x_return_status := FND_API.G_RET_STS_ERROR;
1173: END IF;
1174:
1175: IF (p_rate IS NULL OR p_rate = FND_API.G_MISS_NUM) AND
1176: (l_c = 'PERCENTAGE')
1171: FND_MSG_PUB.ADD;
1172: x_return_status := FND_API.G_RET_STS_ERROR;
1173: END IF;
1174:
1175: IF (p_rate IS NULL OR p_rate = FND_API.G_MISS_NUM) AND
1176: (l_c = 'PERCENTAGE')
1177: THEN
1178: arp_standard.debug(' The rate column is mandatory for SCHEDULE_HEADER_TYPE:'||l_c);
1179: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
1179: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
1180: fnd_message.set_token('COLUMN', 'RATE');
1181: fnd_msg_pub.add;
1182: FND_MSG_PUB.ADD;
1183: x_return_status := FND_API.G_RET_STS_ERROR;
1184: END IF;
1185: arp_standard.debug(' validate amount or rate -');
1186: END;
1187:
1189:
1190:
1191:
1192: PROCEDURE create_schedule
1193: (p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1194: P_SCHEDULE_NAME IN VARCHAR2,
1195: P_SCHEDULE_DESCRIPTION IN VARCHAR2,
1196: P_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,
1197: P_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL,
1227: arp_standard.debug(' P_SCHEDULE_DESCRIPTION :'||P_SCHEDULE_DESCRIPTION);
1228:
1229: SAVEPOINT create_schedule;
1230:
1231: x_return_status := fnd_api.G_RET_STS_SUCCESS;
1232:
1233: IF fnd_api.to_boolean(p_init_msg_list) THEN
1234: fnd_msg_pub.initialize;
1235: END IF;
1229: SAVEPOINT create_schedule;
1230:
1231: x_return_status := fnd_api.G_RET_STS_SUCCESS;
1232:
1233: IF fnd_api.to_boolean(p_init_msg_list) THEN
1234: fnd_msg_pub.initialize;
1235: END IF;
1236:
1237: l_n := 1;
1242: p_mode => 'INSERT',
1243: x_return_status => x_return_status);
1244:
1245:
1246: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
1247: RAISE fnd_api.G_EXC_ERROR;
1248: END IF;
1249:
1250: l_n := 2;
1243: x_return_status => x_return_status);
1244:
1245:
1246: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
1247: RAISE fnd_api.G_EXC_ERROR;
1248: END IF;
1249:
1250: l_n := 2;
1251: OPEN cu_schedule_id;
1276: P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER,
1277: x_return_status => x_return_status);
1278:
1279: l_n := 4;
1280: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
1281: RAISE fnd_api.G_EXC_ERROR;
1282: END IF;
1283:
1284: x_schedule_id := l_schedule_id;
1277: x_return_status => x_return_status);
1278:
1279: l_n := 4;
1280: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
1281: RAISE fnd_api.G_EXC_ERROR;
1282: END IF;
1283:
1284: x_schedule_id := l_schedule_id;
1285:
1285:
1286: arp_standard.debug('create_schedule -');
1287:
1288: EXCEPTION
1289: WHEN FND_API.G_EXC_ERROR THEN
1290: ROLLBACK TO create_schedule;
1291: FND_MSG_PUB.Count_And_Get(
1292: p_encoded => FND_API.G_FALSE,
1293: p_count => x_msg_count,
1288: EXCEPTION
1289: WHEN FND_API.G_EXC_ERROR THEN
1290: ROLLBACK TO create_schedule;
1291: FND_MSG_PUB.Count_And_Get(
1292: p_encoded => FND_API.G_FALSE,
1293: p_count => x_msg_count,
1294: p_data => x_msg_data);
1295: arp_standard.debug('EXCEPTION create_schedule:'||x_msg_data);
1296:
1295: arp_standard.debug('EXCEPTION create_schedule:'||x_msg_data);
1296:
1297: WHEN OTHERS THEN
1298: ROLLBACK TO create_schedule;
1299: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1300: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1301: FND_MESSAGE.SET_TOKEN('ERROR' ,l_n||' '||SQLERRM);
1302: FND_MSG_PUB.ADD;
1303: FND_MSG_PUB.Count_And_Get(
1300: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1301: FND_MESSAGE.SET_TOKEN('ERROR' ,l_n||' '||SQLERRM);
1302: FND_MSG_PUB.ADD;
1303: FND_MSG_PUB.Count_And_Get(
1304: p_encoded => FND_API.G_FALSE,
1305: p_count => x_msg_count,
1306: p_data => x_msg_data);
1307: arp_standard.debug('EXCEPTION create_schedule:'||x_msg_data);
1308: END;
1308: END;
1309:
1310:
1311: PROCEDURE update_schedule
1312: (p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1313: P_SCHEDULE_ID IN NUMBER,
1314: P_SCHEDULE_DESCRIPTION IN VARCHAR2,
1315: P_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,
1316: P_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL,
1364: arp_standard.debug(' P_SCHEDULE_DESCRIPTION :'||P_SCHEDULE_DESCRIPTION);
1365:
1366: SAVEPOINT update_schedule;
1367:
1368: IF fnd_api.to_boolean(p_init_msg_list) THEN
1369: fnd_msg_pub.initialize;
1370: END IF;
1371:
1372: x_return_status := fnd_api.G_RET_STS_SUCCESS;
1368: IF fnd_api.to_boolean(p_init_msg_list) THEN
1369: fnd_msg_pub.initialize;
1370: END IF;
1371:
1372: x_return_status := fnd_api.G_RET_STS_SUCCESS;
1373:
1374: OPEN c;
1375: FETCH c INTO
1376: l_rec.SCHEDULE_ID ,
1400: fnd_message.set_token('RECORD', 'ar_charge_schedules');
1401: fnd_message.set_token('VALUE',
1402: NVL(TO_CHAR(P_SCHEDULE_ID), 'null'));
1403: fnd_msg_pub.add;
1404: RAISE fnd_api.g_exc_error;
1405: END IF;
1406:
1407:
1408: IF NOT ((x_object_version_number IS NULL AND
1413: THEN
1414: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
1415: fnd_message.set_token('TABLE', 'ar_charge_schedules');
1416: fnd_msg_pub.add;
1417: RAISE fnd_api.g_exc_error;
1418: END IF;
1419:
1420:
1421: validate_schedule
1423: p_schedule_description => P_SCHEDULE_DESCRIPTION,
1424: p_mode => 'UPDATE',
1425: x_return_status => x_return_status);
1426:
1427: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
1428: RAISE fnd_api.G_EXC_ERROR;
1429: END IF;
1430:
1431: Update_schedule_row
1424: p_mode => 'UPDATE',
1425: x_return_status => x_return_status);
1426:
1427: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
1428: RAISE fnd_api.G_EXC_ERROR;
1429: END IF;
1430:
1431: Update_schedule_row
1432: (P_SCHEDULE_ID => P_SCHEDULE_ID,
1449: P_ATTRIBUTE15 => p_attribute15,
1450: X_OBJECT_VERSION_NUMBER=> X_OBJECT_VERSION_NUMBER,
1451: x_return_status => x_return_status);
1452:
1453: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
1454: RAISE fnd_api.g_exc_error;
1455: END IF;
1456:
1457: arp_standard.debug('Update_schedule -');
1450: X_OBJECT_VERSION_NUMBER=> X_OBJECT_VERSION_NUMBER,
1451: x_return_status => x_return_status);
1452:
1453: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
1454: RAISE fnd_api.g_exc_error;
1455: END IF;
1456:
1457: arp_standard.debug('Update_schedule -');
1458:
1456:
1457: arp_standard.debug('Update_schedule -');
1458:
1459: EXCEPTION
1460: WHEN FND_API.G_EXC_ERROR THEN
1461: ROLLBACK TO Update_schedule;
1462: FND_MSG_PUB.Count_And_Get(
1463: p_encoded => FND_API.G_FALSE,
1464: p_count => x_msg_count,
1459: EXCEPTION
1460: WHEN FND_API.G_EXC_ERROR THEN
1461: ROLLBACK TO Update_schedule;
1462: FND_MSG_PUB.Count_And_Get(
1463: p_encoded => FND_API.G_FALSE,
1464: p_count => x_msg_count,
1465: p_data => x_msg_data);
1466: arp_standard.debug('EXCEPTION Update_schedule:'||x_msg_data);
1467:
1466: arp_standard.debug('EXCEPTION Update_schedule:'||x_msg_data);
1467:
1468: WHEN OTHERS THEN
1469: ROLLBACK TO Update_schedule;
1470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1471: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1472: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1473: FND_MSG_PUB.ADD;
1474: FND_MSG_PUB.Count_And_Get(
1471: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1472: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1473: FND_MSG_PUB.ADD;
1474: FND_MSG_PUB.Count_And_Get(
1475: p_encoded => FND_API.G_FALSE,
1476: p_count => x_msg_count,
1477: p_data => x_msg_data);
1478: arp_standard.debug('EXCEPTION Update_schedule:'||x_msg_data);
1479: END;
1482:
1483:
1484:
1485: PROCEDURE create_schedule_header
1486: (p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1487: P_SCHEDULE_ID IN NUMBER,
1488: P_SCHEDULE_HEADER_TYPE IN VARCHAR2,
1489: P_AGING_BUCKET_ID IN NUMBER,
1490: P_START_DATE IN DATE,
1524: arp_standard.debug(' p_end_date :'||p_end_date);
1525:
1526: savepoint create_schedule_header;
1527:
1528: x_return_status := fnd_api.G_RET_STS_SUCCESS;
1529:
1530: IF fnd_api.to_boolean(p_init_msg_list) THEN
1531: fnd_msg_pub.initialize;
1532: END IF;
1526: savepoint create_schedule_header;
1527:
1528: x_return_status := fnd_api.G_RET_STS_SUCCESS;
1529:
1530: IF fnd_api.to_boolean(p_init_msg_list) THEN
1531: fnd_msg_pub.initialize;
1532: END IF;
1533:
1534:
1544: p_mode => 'INSERT',
1545: x_return_status => x_return_status);
1546:
1547:
1548: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
1549: RAISE fnd_api.G_EXC_ERROR;
1550: END IF;
1551:
1552: OPEN cu_header_id;
1545: x_return_status => x_return_status);
1546:
1547:
1548: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
1549: RAISE fnd_api.G_EXC_ERROR;
1550: END IF;
1551:
1552: OPEN cu_header_id;
1553: FETCH cu_header_id INTO l_header_id;
1580: P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER,
1581: x_return_status => x_return_status);
1582:
1583:
1584: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
1585: RAISE fnd_api.G_EXC_ERROR;
1586: END IF;
1587:
1588: x_SCHEDULE_HEADER_ID := l_header_id;
1581: x_return_status => x_return_status);
1582:
1583:
1584: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
1585: RAISE fnd_api.G_EXC_ERROR;
1586: END IF;
1587:
1588: x_SCHEDULE_HEADER_ID := l_header_id;
1589:
1589:
1590: arp_standard.debug('create_schedule_header -');
1591:
1592: EXCEPTION
1593: WHEN FND_API.G_EXC_ERROR THEN
1594: ROLLBACK TO create_schedule_header;
1595: FND_MSG_PUB.Count_And_Get(
1596: p_encoded => FND_API.G_FALSE,
1597: p_count => x_msg_count,
1592: EXCEPTION
1593: WHEN FND_API.G_EXC_ERROR THEN
1594: ROLLBACK TO create_schedule_header;
1595: FND_MSG_PUB.Count_And_Get(
1596: p_encoded => FND_API.G_FALSE,
1597: p_count => x_msg_count,
1598: p_data => x_msg_data);
1599: arp_standard.debug('EXCEPTION create_schedule_header:'||x_msg_data);
1600:
1599: arp_standard.debug('EXCEPTION create_schedule_header:'||x_msg_data);
1600:
1601: WHEN OTHERS THEN
1602: ROLLBACK TO create_schedule_header;
1603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1604: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1605: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1606: FND_MSG_PUB.ADD;
1607: FND_MSG_PUB.Count_And_Get(
1604: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1605: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1606: FND_MSG_PUB.ADD;
1607: FND_MSG_PUB.Count_And_Get(
1608: p_encoded => FND_API.G_FALSE,
1609: p_count => x_msg_count,
1610: p_data => x_msg_data);
1611: arp_standard.debug('EXCEPTION create_schedule_header:'||x_msg_data);
1612: END;
1612: END;
1613:
1614:
1615: PROCEDURE Update_schedule_header
1616: (p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1617: P_SCHEDULE_HEADER_ID IN NUMBER,
1618: P_END_DATE IN DATE,
1619: P_STATUS IN VARCHAR2,
1620: P_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,
1675: arp_standard.debug(' X_OBJECT_VERSION_NUMBER :'||X_OBJECT_VERSION_NUMBER);
1676:
1677: savepoint Update_schedule_header;
1678:
1679: IF fnd_api.to_boolean(p_init_msg_list) THEN
1680: fnd_msg_pub.initialize;
1681: END IF;
1682:
1683: x_return_status := fnd_api.G_RET_STS_SUCCESS;
1679: IF fnd_api.to_boolean(p_init_msg_list) THEN
1680: fnd_msg_pub.initialize;
1681: END IF;
1682:
1683: x_return_status := fnd_api.G_RET_STS_SUCCESS;
1684:
1685: OPEN c;
1686: FETCH c INTO
1687: l_rec.SCHEDULE_ID ,
1715: fnd_message.set_token('RECORD', 'ar_charge_schedule_hdrs');
1716: fnd_message.set_token('VALUE',
1717: NVL(TO_CHAR(P_SCHEDULE_HEADER_ID), 'null'));
1718: fnd_msg_pub.add;
1719: RAISE fnd_api.g_exc_error;
1720: END IF;
1721:
1722:
1723: IF NOT ((x_object_version_number IS NULL AND
1728: THEN
1729: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
1730: fnd_message.set_token('TABLE', 'ar_charge_schedule_hdrs');
1731: fnd_msg_pub.add;
1732: RAISE fnd_api.g_exc_error;
1733: END IF;
1734:
1735:
1736: validate_schedule_header
1745: p_mode => 'UPDATE',
1746: x_return_status => x_return_status);
1747:
1748:
1749: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
1750: RAISE fnd_api.g_exc_error;
1751: END IF;
1752:
1753: Update_Head_Row
1746: x_return_status => x_return_status);
1747:
1748:
1749: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
1750: RAISE fnd_api.g_exc_error;
1751: END IF;
1752:
1753: Update_Head_Row
1754: (P_SCHEDULE_HEADER_ID => l_rec.SCHEDULE_HEADER_ID,
1772: P_ATTRIBUTE15 => p_attribute15,
1773: X_OBJECT_VERSION_NUMBER=> X_OBJECT_VERSION_NUMBER,
1774: x_return_status => x_return_status);
1775:
1776: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
1777: RAISE fnd_api.g_exc_error;
1778: END IF;
1779:
1780: arp_standard.debug('Update_schedule_header -');
1773: X_OBJECT_VERSION_NUMBER=> X_OBJECT_VERSION_NUMBER,
1774: x_return_status => x_return_status);
1775:
1776: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
1777: RAISE fnd_api.g_exc_error;
1778: END IF;
1779:
1780: arp_standard.debug('Update_schedule_header -');
1781:
1779:
1780: arp_standard.debug('Update_schedule_header -');
1781:
1782: EXCEPTION
1783: WHEN FND_API.G_EXC_ERROR THEN
1784: ROLLBACK TO Update_schedule_header;
1785: FND_MSG_PUB.Count_And_Get(
1786: p_encoded => FND_API.G_FALSE,
1787: p_count => x_msg_count,
1782: EXCEPTION
1783: WHEN FND_API.G_EXC_ERROR THEN
1784: ROLLBACK TO Update_schedule_header;
1785: FND_MSG_PUB.Count_And_Get(
1786: p_encoded => FND_API.G_FALSE,
1787: p_count => x_msg_count,
1788: p_data => x_msg_data);
1789: arp_standard.debug('EXCEPTION Update_schedule_header:'||x_msg_data);
1790:
1789: arp_standard.debug('EXCEPTION Update_schedule_header:'||x_msg_data);
1790:
1791: WHEN OTHERS THEN
1792: ROLLBACK TO Update_schedule_header;
1793: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1794: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1795: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1796: FND_MSG_PUB.ADD;
1797: FND_MSG_PUB.Count_And_Get(
1794: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1795: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1796: FND_MSG_PUB.ADD;
1797: FND_MSG_PUB.Count_And_Get(
1798: p_encoded => FND_API.G_FALSE,
1799: p_count => x_msg_count,
1800: p_data => x_msg_data);
1801: arp_standard.debug('EXCEPTION Update_schedule_header:'||x_msg_data);
1802: END;
1803:
1804:
1805:
1806: PROCEDURE create_schedule_line
1807: (p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1808: P_SCHEDULE_HEADER_ID IN NUMBER,
1809: P_SCHEDULE_ID IN NUMBER,
1810: P_AGING_BUCKET_ID IN NUMBER,
1811: P_AGING_BUCKET_LINE_ID IN NUMBER,
1847: arp_standard.debug(' P_RATE :'||P_RATE);
1848:
1849: SAVEPOINT create_schedule_line;
1850:
1851: x_return_status := fnd_api.G_RET_STS_SUCCESS;
1852:
1853: IF fnd_api.to_boolean(p_init_msg_list) THEN
1854: fnd_msg_pub.initialize;
1855: END IF;
1849: SAVEPOINT create_schedule_line;
1850:
1851: x_return_status := fnd_api.G_RET_STS_SUCCESS;
1852:
1853: IF fnd_api.to_boolean(p_init_msg_list) THEN
1854: fnd_msg_pub.initialize;
1855: END IF;
1856:
1857: validate_schedule_line
1865: P_MODE => 'INSERT',
1866: x_return_status => x_return_status);
1867:
1868:
1869: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
1870: RAISE fnd_api.G_EXC_ERROR;
1871: END IF;
1872:
1873: OPEN cu_line_id;
1866: x_return_status => x_return_status);
1867:
1868:
1869: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
1870: RAISE fnd_api.G_EXC_ERROR;
1871: END IF;
1872:
1873: OPEN cu_line_id;
1874: FETCH cu_line_id INTO l_line_id;
1901: P_ATTRIBUTE15 => P_ATTRIBUTE15,
1902: P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER,
1903: x_return_status => x_return_status);
1904:
1905: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
1906: RAISE fnd_api.g_exc_error;
1907: END IF;
1908:
1909: X_SCHEDULE_LINE_ID := l_line_id;
1902: P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER,
1903: x_return_status => x_return_status);
1904:
1905: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
1906: RAISE fnd_api.g_exc_error;
1907: END IF;
1908:
1909: X_SCHEDULE_LINE_ID := l_line_id;
1910:
1910:
1911: arp_standard.debug('create_schedule_line -');
1912:
1913: EXCEPTION
1914: WHEN FND_API.G_EXC_ERROR THEN
1915: ROLLBACK TO create_schedule_line;
1916: FND_MSG_PUB.Count_And_Get(
1917: p_encoded => FND_API.G_FALSE,
1918: p_count => x_msg_count,
1913: EXCEPTION
1914: WHEN FND_API.G_EXC_ERROR THEN
1915: ROLLBACK TO create_schedule_line;
1916: FND_MSG_PUB.Count_And_Get(
1917: p_encoded => FND_API.G_FALSE,
1918: p_count => x_msg_count,
1919: p_data => x_msg_data);
1920: arp_standard.debug('EXCEPTION create_schedule_line :'||x_msg_data);
1921:
1920: arp_standard.debug('EXCEPTION create_schedule_line :'||x_msg_data);
1921:
1922: WHEN OTHERS THEN
1923: ROLLBACK TO create_schedule_line;
1924: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1925: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1926: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1927: FND_MSG_PUB.ADD;
1928: FND_MSG_PUB.Count_And_Get(
1925: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1926: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1927: FND_MSG_PUB.ADD;
1928: FND_MSG_PUB.Count_And_Get(
1929: p_encoded => FND_API.G_FALSE,
1930: p_count => x_msg_count,
1931: p_data => x_msg_data);
1932: arp_standard.debug('EXCEPTION create_schedule_line :'||x_msg_data);
1933: END;
1932: arp_standard.debug('EXCEPTION create_schedule_line :'||x_msg_data);
1933: END;
1934:
1935: PROCEDURE Update_schedule_line
1936: (p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1937: P_SCHEDULE_line_ID IN NUMBER,
1938: P_amount IN NUMBER,
1939: P_rate IN NUMBER,
1940: P_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,
1994: arp_standard.debug(' X_OBJECT_VERSION_NUMBER :'||X_OBJECT_VERSION_NUMBER);
1995:
1996: savepoint Update_schedule_line;
1997:
1998: IF fnd_api.to_boolean(p_init_msg_list) THEN
1999: fnd_msg_pub.initialize;
2000: END IF;
2001:
2002: x_return_status := fnd_api.G_RET_STS_SUCCESS;
1998: IF fnd_api.to_boolean(p_init_msg_list) THEN
1999: fnd_msg_pub.initialize;
2000: END IF;
2001:
2002: x_return_status := fnd_api.G_RET_STS_SUCCESS;
2003:
2004: OPEN c;
2005: FETCH c INTO
2006: l_rec.SCHEDULE_ID ,
2032: fnd_message.set_token('RECORD', 'ar_charge_schedule_lines');
2033: fnd_message.set_token('VALUE',
2034: NVL(TO_CHAR(P_SCHEDULE_line_ID), 'null'));
2035: fnd_msg_pub.add;
2036: RAISE fnd_api.g_exc_error;
2037: END IF;
2038:
2039:
2040: IF NOT ((x_object_version_number IS NULL AND
2045: THEN
2046: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
2047: fnd_message.set_token('TABLE', 'ar_charge_schedule_lines');
2048: fnd_msg_pub.add;
2049: RAISE fnd_api.g_exc_error;
2050: END IF;
2051:
2052: /* This would be the place to call validate_line
2053: validate_schedule_line
2060: P_RATE => p_rate,
2061: P_MODE => 'UPDATE',
2062: x_return_status => x_return_status);
2063:
2064: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
2065: RAISE fnd_api.g_exc_error;
2066: END IF;
2067: */
2068:
2061: P_MODE => 'UPDATE',
2062: x_return_status => x_return_status);
2063:
2064: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
2065: RAISE fnd_api.g_exc_error;
2066: END IF;
2067: */
2068:
2069: Update_line_Row
2088: P_ATTRIBUTE15 => p_attribute15,
2089: X_OBJECT_VERSION_NUMBER=> X_OBJECT_VERSION_NUMBER,
2090: x_return_status => x_return_status);
2091:
2092: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
2093: RAISE fnd_api.g_exc_error;
2094: END IF;
2095:
2096: arp_standard.debug('Update_schedule_line -');
2089: X_OBJECT_VERSION_NUMBER=> X_OBJECT_VERSION_NUMBER,
2090: x_return_status => x_return_status);
2091:
2092: IF x_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
2093: RAISE fnd_api.g_exc_error;
2094: END IF;
2095:
2096: arp_standard.debug('Update_schedule_line -');
2097:
2095:
2096: arp_standard.debug('Update_schedule_line -');
2097:
2098: EXCEPTION
2099: WHEN FND_API.G_EXC_ERROR THEN
2100: ROLLBACK TO Update_schedule_line;
2101: FND_MSG_PUB.Count_And_Get(
2102: p_encoded => FND_API.G_FALSE,
2103: p_count => x_msg_count,
2098: EXCEPTION
2099: WHEN FND_API.G_EXC_ERROR THEN
2100: ROLLBACK TO Update_schedule_line;
2101: FND_MSG_PUB.Count_And_Get(
2102: p_encoded => FND_API.G_FALSE,
2103: p_count => x_msg_count,
2104: p_data => x_msg_data);
2105: arp_standard.debug('EXCEPTION Update_schedule_line:'||x_msg_data);
2106:
2105: arp_standard.debug('EXCEPTION Update_schedule_line:'||x_msg_data);
2106:
2107: WHEN OTHERS THEN
2108: ROLLBACK TO Update_schedule_header;
2109: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2110: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2111: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2112: FND_MSG_PUB.ADD;
2113: FND_MSG_PUB.Count_And_Get(
2110: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2111: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2112: FND_MSG_PUB.ADD;
2113: FND_MSG_PUB.Count_And_Get(
2114: p_encoded => FND_API.G_FALSE,
2115: p_count => x_msg_count,
2116: p_data => x_msg_data);
2117: arp_standard.debug('EXCEPTION Update_schedule_line:'||x_msg_data);
2118: END;