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.AS_STATUS_PUB dependencies on FND_API

Line 80: IF fnd_api.to_boolean (p_init_msg_list)

76: -- Standard start of api save point
77: SAVEPOINT create_status;
78:
79: -- Initialize Message List
80: IF fnd_api.to_boolean (p_init_msg_list)
81: THEN
82: fnd_msg_pub.initialize;
83: END IF;
84:

Line 86: IF NOT fnd_api.compatible_api_call (

82: fnd_msg_pub.initialize;
83: END IF;
84:
85: -- Standard Call to check api compatibility
86: IF NOT fnd_api.compatible_api_call (
87: l_api_version,
88: p_api_version_number,
89: l_api_name,
90: G_PKG_NAME

Line 98: x_return_status := fnd_api.g_ret_sts_success;

94: fnd_msg_pub.add;
95: END IF;
96:
97: -- Initialize api return status
98: x_return_status := fnd_api.g_ret_sts_success;
99:
100: -- Check if the version number passed is 2.0 else error out
101: IF p_api_version_number <> 2.0
102: THEN

Line 113: OR p_status_rec.enabled_flag = FND_API.G_MISS_CHAR

109: -- Begin Validation Section
110: -- Check for valid values being passed.
111:
112: IF (p_status_rec.enabled_flag NOT IN ('Y','N')
113: OR p_status_rec.enabled_flag = FND_API.G_MISS_CHAR
114: OR TRIM(p_status_rec.enabled_flag) IS NULL)
115: THEN
116: fnd_message.set_name('AS', 'AS_ENABLED_FLAG_INVALID');
117: fnd_msg_pub.add;

Line 120: OR p_status_rec.lead_flag = FND_API.G_MISS_CHAR

116: fnd_message.set_name('AS', 'AS_ENABLED_FLAG_INVALID');
117: fnd_msg_pub.add;
118: END IF;
119: IF (p_status_rec.lead_flag NOT IN ('Y','N')
120: OR p_status_rec.lead_flag = FND_API.G_MISS_CHAR
121: OR TRIM(p_status_rec.lead_flag) IS NULL)
122: THEN
123: fnd_message.set_name('AS', 'AS_LEAD_FLAG_INVALID');
124: fnd_msg_pub.add;

Line 127: OR p_status_rec.opp_flag = FND_API.G_MISS_CHAR

123: fnd_message.set_name('AS', 'AS_LEAD_FLAG_INVALID');
124: fnd_msg_pub.add;
125: END IF;
126: IF (p_status_rec.opp_flag NOT IN ('Y','N')
127: OR p_status_rec.opp_flag = FND_API.G_MISS_CHAR
128: OR TRIM(p_status_rec.opp_flag) IS NULL)
129: THEN
130: fnd_message.set_name('AS', 'AS_OPP_FLAG_INVALID');
131: fnd_msg_pub.add;

Line 134: OR TRIM(p_status_rec.opp_open_status_flag) = FND_API.G_MISS_CHAR

130: fnd_message.set_name('AS', 'AS_OPP_FLAG_INVALID');
131: fnd_msg_pub.add;
132: END IF;
133: IF (p_status_rec.opp_open_status_flag NOT IN ('Y','N')
134: OR TRIM(p_status_rec.opp_open_status_flag) = FND_API.G_MISS_CHAR
135: OR TRIM(p_status_rec.opp_open_status_flag) IS NULL)
136: THEN
137: fnd_message.set_name('AS', 'AS_OPP_OPEN_FLAG_INVALID');
138: fnd_msg_pub.add;

Line 141: OR p_status_rec.opp_decision_date_flag = FND_API.G_MISS_CHAR

137: fnd_message.set_name('AS', 'AS_OPP_OPEN_FLAG_INVALID');
138: fnd_msg_pub.add;
139: END IF;
140: IF (p_status_rec.opp_decision_date_flag NOT IN ('Y','N')
141: OR p_status_rec.opp_decision_date_flag = FND_API.G_MISS_CHAR
142: OR TRIM(p_status_rec.opp_decision_date_flag) IS NULL)
143: THEN
144: fnd_message.set_name('AS', 'AS_DECISION_FLAG_INVALID');
145: fnd_msg_pub.add;

Line 148: OR p_status_rec.forecast_rollup_flag = FND_API.G_MISS_CHAR

144: fnd_message.set_name('AS', 'AS_DECISION_FLAG_INVALID');
145: fnd_msg_pub.add;
146: END IF;
147: IF (p_status_rec.forecast_rollup_flag NOT IN ('Y','N')
148: OR p_status_rec.forecast_rollup_flag = FND_API.G_MISS_CHAR
149: OR TRIM(p_status_rec.forecast_rollup_flag) IS NULL)
150: THEN
151: fnd_message.set_name('AS', 'AS_FORECAST_FLAG_INVALID');
152: fnd_msg_pub.add;

Line 156: OR p_status_rec.win_loss_indicator= FND_API.G_MISS_CHAR

152: fnd_msg_pub.add;
153: END IF;
154:
155: IF (p_status_rec.win_loss_indicator NOT IN ('W','L')
156: OR p_status_rec.win_loss_indicator= FND_API.G_MISS_CHAR
157: OR TRIM(p_status_rec.win_loss_indicator) IS NULL)
158: THEN
159: fnd_message.set_name('AS', 'AS_WIN_IND_INVALID');
160: fnd_msg_pub.add;

Line 164: IF (p_status_rec.meaning = FND_API.G_MISS_CHAR

160: fnd_msg_pub.add;
161: END IF;
162:
163: -- Check if the required field Meaning is passed
164: IF (p_status_rec.meaning = FND_API.G_MISS_CHAR
165: OR TRIM(p_status_rec.meaning) IS NULL)
166: THEN
167: fnd_message.set_name('AS', 'AS_MEANING');
168: fnd_msg_pub.add;

Line 189: IF (p_status_rec.creation_date = FND_API.G_MISS_DATE)

185: CLOSE status_dup_cur;
186:
187: -- Check if the Who columns have any values otherwise default them.
188:
189: IF (p_status_rec.creation_date = FND_API.G_MISS_DATE)
190: OR TRIM(p_status_rec.creation_date) IS NULL
191: THEN
192: l_creation_date := sysdate;
193: ELSE

Line 196: IF (p_status_rec.created_by = FND_API.G_MISS_NUM)

192: l_creation_date := sysdate;
193: ELSE
194: l_creation_date := p_status_rec.creation_date ;
195: END IF;
196: IF (p_status_rec.created_by = FND_API.G_MISS_NUM)
197: OR TRIM(p_status_rec.created_by) IS NULL
198: THEN
199: l_created_by := fnd_global.user_id;
200: ELSE

Line 203: IF (p_status_rec.last_update_date = FND_API.G_MISS_DATE)

199: l_created_by := fnd_global.user_id;
200: ELSE
201: l_created_by := p_status_rec.created_by ;
202: END IF;
203: IF (p_status_rec.last_update_date = FND_API.G_MISS_DATE)
204: OR TRIM(p_status_rec.last_update_date) IS NULL
205: THEN
206: l_last_update_date := sysdate;
207: ELSE

Line 210: IF (p_status_rec.last_update_login = FND_API.G_MISS_NUM)

206: l_last_update_date := sysdate;
207: ELSE
208: l_last_update_date := p_status_rec.last_update_date;
209: END IF;
210: IF (p_status_rec.last_update_login = FND_API.G_MISS_NUM)
211: OR TRIM(p_status_rec.last_update_login) IS NULL
212: THEN
213: l_last_update_login := fnd_global.login_id;
214: ELSE

Line 217: IF (p_status_rec.last_updated_by = FND_API.G_MISS_NUM)

213: l_last_update_login := fnd_global.login_id;
214: ELSE
215: l_last_update_login := p_status_rec.last_update_login;
216: END IF;
217: IF (p_status_rec.last_updated_by = FND_API.G_MISS_NUM)
218: OR TRIM(p_status_rec.last_updated_by) IS NULL
219: THEN
220: l_last_updated_by := fnd_global.user_id;
221: ELSE

Line 228: IF p_status_rec.status_rank = FND_API.G_MISS_NUM

224:
225: -- Check all optional fields if they have g_miss values then
226: -- replace those with null before inserting.
227:
228: IF p_status_rec.status_rank = FND_API.G_MISS_NUM
229: THEN
230: l_status_rank := NULL;
231: ELSE
232: l_status_rank := p_status_rec.status_rank;

Line 234: IF p_status_rec.attribute_category = FND_API.G_MISS_CHAR

230: l_status_rank := NULL;
231: ELSE
232: l_status_rank := p_status_rec.status_rank;
233: END IF;
234: IF p_status_rec.attribute_category = FND_API.G_MISS_CHAR
235: THEN
236: l_attribute_category := NULL;
237: ELSE
238: l_attribute_category :=p_status_rec.attribute_category;

Line 240: IF p_status_rec.attribute1 = FND_API.G_MISS_CHAR

236: l_attribute_category := NULL;
237: ELSE
238: l_attribute_category :=p_status_rec.attribute_category;
239: END IF;
240: IF p_status_rec.attribute1 = FND_API.G_MISS_CHAR
241: THEN
242: l_attribute1 := NULL;
243: ELSE
244: l_attribute1 := p_status_rec.attribute1 ;

Line 246: IF p_status_rec.attribute2 = FND_API.G_MISS_CHAR

242: l_attribute1 := NULL;
243: ELSE
244: l_attribute1 := p_status_rec.attribute1 ;
245: END IF;
246: IF p_status_rec.attribute2 = FND_API.G_MISS_CHAR
247: THEN
248: l_attribute2 := NULL;
249: ELSE
250: l_attribute2 := p_status_rec.attribute2 ;

Line 252: IF p_status_rec.attribute3 = FND_API.G_MISS_CHAR

248: l_attribute2 := NULL;
249: ELSE
250: l_attribute2 := p_status_rec.attribute2 ;
251: END IF;
252: IF p_status_rec.attribute3 = FND_API.G_MISS_CHAR
253: THEN
254: l_attribute3 := NULL;
255: ELSE
256: l_attribute3 := p_status_rec.attribute3 ;

Line 258: IF p_status_rec.attribute4 = FND_API.G_MISS_CHAR

254: l_attribute3 := NULL;
255: ELSE
256: l_attribute3 := p_status_rec.attribute3 ;
257: END IF;
258: IF p_status_rec.attribute4 = FND_API.G_MISS_CHAR
259: THEN
260: l_attribute4 := NULL;
261: ELSE
262: l_attribute4 := p_status_rec.attribute4 ;

Line 264: IF p_status_rec.attribute5 = FND_API.G_MISS_CHAR

260: l_attribute4 := NULL;
261: ELSE
262: l_attribute4 := p_status_rec.attribute4 ;
263: END IF;
264: IF p_status_rec.attribute5 = FND_API.G_MISS_CHAR
265: THEN
266: l_attribute5 := NULL;
267: ELSE
268: l_attribute5 := p_status_rec.attribute5 ;

Line 270: IF p_status_rec.attribute6 = FND_API.G_MISS_CHAR

266: l_attribute5 := NULL;
267: ELSE
268: l_attribute5 := p_status_rec.attribute5 ;
269: END IF;
270: IF p_status_rec.attribute6 = FND_API.G_MISS_CHAR
271: THEN
272: l_attribute6 := NULL;
273: ELSE
274: l_attribute6 := p_status_rec.attribute6 ;

Line 276: IF p_status_rec.attribute7 = FND_API.G_MISS_CHAR

272: l_attribute6 := NULL;
273: ELSE
274: l_attribute6 := p_status_rec.attribute6 ;
275: END IF;
276: IF p_status_rec.attribute7 = FND_API.G_MISS_CHAR
277: THEN
278: l_attribute7 := NULL;
279: ELSE
280: l_attribute7 := p_status_rec.attribute7 ;

Line 282: IF p_status_rec.attribute8 = FND_API.G_MISS_CHAR

278: l_attribute7 := NULL;
279: ELSE
280: l_attribute7 := p_status_rec.attribute7 ;
281: END IF;
282: IF p_status_rec.attribute8 = FND_API.G_MISS_CHAR
283: THEN
284: l_attribute8 := NULL;
285: ELSE
286: l_attribute8 := p_status_rec.attribute8 ;

Line 288: IF p_status_rec.attribute9 = FND_API.G_MISS_CHAR

284: l_attribute8 := NULL;
285: ELSE
286: l_attribute8 := p_status_rec.attribute8 ;
287: END IF;
288: IF p_status_rec.attribute9 = FND_API.G_MISS_CHAR
289: THEN
290: l_attribute9 := NULL;
291: ELSE
292: l_attribute9 := p_status_rec.attribute9 ;

Line 294: IF p_status_rec.attribute10 = FND_API.G_MISS_CHAR

290: l_attribute9 := NULL;
291: ELSE
292: l_attribute9 := p_status_rec.attribute9 ;
293: END IF;
294: IF p_status_rec.attribute10 = FND_API.G_MISS_CHAR
295: THEN
296: l_attribute10 := NULL;
297: ELSE
298: l_attribute10 := p_status_rec.attribute10 ;

Line 300: IF p_status_rec.attribute11 = FND_API.G_MISS_CHAR

296: l_attribute10 := NULL;
297: ELSE
298: l_attribute10 := p_status_rec.attribute10 ;
299: END IF;
300: IF p_status_rec.attribute11 = FND_API.G_MISS_CHAR
301: THEN
302: l_attribute11 := NULL;
303: ELSE
304: l_attribute11 := p_status_rec.attribute11 ;

Line 306: IF p_status_rec.attribute12 = FND_API.G_MISS_CHAR

302: l_attribute11 := NULL;
303: ELSE
304: l_attribute11 := p_status_rec.attribute11 ;
305: END IF;
306: IF p_status_rec.attribute12 = FND_API.G_MISS_CHAR
307: THEN
308: l_attribute12 := NULL;
309: ELSE
310: l_attribute12 := p_status_rec.attribute12 ;

Line 312: IF p_status_rec.attribute13 = FND_API.G_MISS_CHAR

308: l_attribute12 := NULL;
309: ELSE
310: l_attribute12 := p_status_rec.attribute12 ;
311: END IF;
312: IF p_status_rec.attribute13 = FND_API.G_MISS_CHAR
313: THEN
314: l_attribute13 := NULL;
315: ELSE
316: l_attribute13 := p_status_rec.attribute13 ;

Line 318: IF p_status_rec.attribute14 = FND_API.G_MISS_CHAR

314: l_attribute13 := NULL;
315: ELSE
316: l_attribute13 := p_status_rec.attribute13 ;
317: END IF;
318: IF p_status_rec.attribute14 = FND_API.G_MISS_CHAR
319: THEN
320: l_attribute14 := NULL;
321: ELSE
322: l_attribute14 := p_status_rec.attribute14 ;

Line 324: IF p_status_rec.attribute15 = FND_API.G_MISS_CHAR

320: l_attribute14 := NULL;
321: ELSE
322: l_attribute14 := p_status_rec.attribute14 ;
323: END IF;
324: IF p_status_rec.attribute15 = FND_API.G_MISS_CHAR
325: THEN
326: l_attribute15 := NULL;
327: ELSE
328: l_attribute15 := p_status_rec.attribute15 ;

Line 330: IF p_status_rec.description = FND_API.G_MISS_CHAR

326: l_attribute15 := NULL;
327: ELSE
328: l_attribute15 := p_status_rec.attribute15 ;
329: END IF;
330: IF p_status_rec.description = FND_API.G_MISS_CHAR
331: THEN
332: l_description := NULL;
333: ELSE
334: l_description := p_status_rec.description;

Line 359: RAISE fnd_api.g_exc_error;

355: IF (FND_MSG_PUB.COUNT_MSG > 0)
356: THEN
357: fnd_message.set_name('AS', 'AS_STATUS_INSERT_FAILED');
358: fnd_msg_pub.add;
359: RAISE fnd_api.g_exc_error;
360: END IF;
361:
362:
363: -- Insert into as_statuses_b and as_statuses_tl using api

Line 403: IF fnd_api.to_boolean (p_commit)

399: l_last_updated_by,
400: l_last_update_login);
401:
402: -- Standard Check for p_commit
403: IF fnd_api.to_boolean (p_commit)
404: THEN
405: COMMIT WORK;
406: END IF;
407:

Line 416: WHEN fnd_api.g_exc_error THEN

412: );
413:
414: -- Handling all the exceptions
415: EXCEPTION
416: WHEN fnd_api.g_exc_error THEN
417: ROLLBACK TO create_status;
418: x_return_status := fnd_api.g_ret_sts_error;
419: fnd_msg_pub.count_and_get (
420: p_count => x_msg_count,

Line 418: x_return_status := fnd_api.g_ret_sts_error;

414: -- Handling all the exceptions
415: EXCEPTION
416: WHEN fnd_api.g_exc_error THEN
417: ROLLBACK TO create_status;
418: x_return_status := fnd_api.g_ret_sts_error;
419: fnd_msg_pub.count_and_get (
420: p_count => x_msg_count,
421: p_data => x_msg_data
422: );

Line 423: WHEN fnd_api.g_exc_unexpected_error THEN

419: fnd_msg_pub.count_and_get (
420: p_count => x_msg_count,
421: p_data => x_msg_data
422: );
423: WHEN fnd_api.g_exc_unexpected_error THEN
424: ROLLBACK TO create_status;
425: x_return_status := fnd_api.g_ret_sts_unexp_error;
426: fnd_msg_pub.count_and_get (
427: p_count => x_msg_count,

Line 425: x_return_status := fnd_api.g_ret_sts_unexp_error;

421: p_data => x_msg_data
422: );
423: WHEN fnd_api.g_exc_unexpected_error THEN
424: ROLLBACK TO create_status;
425: x_return_status := fnd_api.g_ret_sts_unexp_error;
426: fnd_msg_pub.count_and_get (
427: p_count => x_msg_count,
428: p_data => x_msg_data
429: );

Line 432: x_return_status := fnd_api.g_ret_sts_unexp_error;

428: p_data => x_msg_data
429: );
430: WHEN OTHERS THEN
431: ROLLBACK TO create_status;
432: x_return_status := fnd_api.g_ret_sts_unexp_error;
433: fnd_msg_pub.count_and_get (
434: p_count => x_msg_count,
435: p_data => x_msg_data
436: );

Line 580: IF fnd_api.to_boolean (p_init_msg_list)

576: -- Standard start of api save point
577: SAVEPOINT update_status;
578:
579: -- Initialize Message List
580: IF fnd_api.to_boolean (p_init_msg_list)
581: THEN
582: fnd_msg_pub.initialize;
583: END IF;
584:

Line 586: IF NOT fnd_api.compatible_api_call (

582: fnd_msg_pub.initialize;
583: END IF;
584:
585: -- Standard Call to check api compatibility
586: IF NOT fnd_api.compatible_api_call (
587: l_api_version,
588: p_api_version_number,
589: l_api_name,
590: G_PKG_NAME

Line 598: x_return_status := fnd_api.g_ret_sts_success;

594: fnd_msg_pub.add;
595: END IF;
596:
597: -- Initialize api return status
598: x_return_status := fnd_api.g_ret_sts_success;
599:
600: -- Check if the version number passed is 2.0 else error out
601: IF p_api_version_number <> 2.0
602: THEN

Line 647: RAISE fnd_api.g_exc_unexpected_error;

643:
644: IF get_update_row_cur%NOTFOUND
645: THEN
646: CLOSE get_update_row_cur;
647: RAISE fnd_api.g_exc_unexpected_error;
648: END IF;
649:
650: -- checking for G_MISS..and replace with original values if necessary
651: -- Validation for open_status_flag and win loss indicator needs to be done here..

Line 653: IF p_status_rec.opp_open_status_flag = FND_API.G_MISS_CHAR

649:
650: -- checking for G_MISS..and replace with original values if necessary
651: -- Validation for open_status_flag and win loss indicator needs to be done here..
652:
653: IF p_status_rec.opp_open_status_flag = FND_API.G_MISS_CHAR
654: THEN
655: v_opp_open_status_flag := l_opp_open_status_flag;
656: ELSE
657: IF p_status_rec.opp_open_status_flag = 'Y'

Line 664: IF p_status_rec.win_loss_indicator = FND_API.G_MISS_CHAR

660: v_win_loss_indicator := NULL;
661: ELSIF p_status_rec.opp_open_status_flag = 'N'
662: THEN
663: v_opp_open_status_flag := p_status_rec.opp_open_status_flag ;
664: IF p_status_rec.win_loss_indicator = FND_API.G_MISS_CHAR
665: OR TRIM(p_status_rec.win_loss_indicator) IS NULL
666: THEN
667: v_win_loss_indicator := l_win_loss_indicator;
668: ELSIF v_win_loss_indicator NOT IN ('W','L')

Line 682: IF p_status_rec.enabled_flag = FND_API.G_MISS_CHAR

678: fnd_msg_pub.add;
679: END IF;
680: END IF;
681:
682: IF p_status_rec.enabled_flag = FND_API.G_MISS_CHAR
683: THEN
684: v_enabled_flag := l_enabled_flag;
685: ELSE
686: v_enabled_flag := p_status_rec.enabled_flag ;

Line 688: IF p_status_rec.lead_flag = FND_API.G_MISS_CHAR

684: v_enabled_flag := l_enabled_flag;
685: ELSE
686: v_enabled_flag := p_status_rec.enabled_flag ;
687: END IF;
688: IF p_status_rec.lead_flag = FND_API.G_MISS_CHAR
689: THEN
690: v_lead_flag := l_lead_flag ;
691: ELSE
692: v_lead_flag := p_status_rec.lead_flag ;

Line 694: IF p_status_rec.opp_flag = FND_API.G_MISS_CHAR

690: v_lead_flag := l_lead_flag ;
691: ELSE
692: v_lead_flag := p_status_rec.lead_flag ;
693: END IF;
694: IF p_status_rec.opp_flag = FND_API.G_MISS_CHAR
695: THEN
696: v_opp_flag := l_opp_flag ;
697: ELSE
698: v_opp_flag := p_status_rec.opp_flag;

Line 700: IF p_status_rec.opp_decision_date_flag = FND_API.G_MISS_CHAR

696: v_opp_flag := l_opp_flag ;
697: ELSE
698: v_opp_flag := p_status_rec.opp_flag;
699: END IF;
700: IF p_status_rec.opp_decision_date_flag = FND_API.G_MISS_CHAR
701: THEN
702: v_opp_decision_date_flag := l_opp_decision_date_flag ;
703: ELSE
704: v_opp_decision_date_flag := p_status_rec.opp_decision_date_flag ;

Line 706: IF p_status_rec.forecast_rollup_flag = FND_API.G_MISS_CHAR

702: v_opp_decision_date_flag := l_opp_decision_date_flag ;
703: ELSE
704: v_opp_decision_date_flag := p_status_rec.opp_decision_date_flag ;
705: END IF;
706: IF p_status_rec.forecast_rollup_flag = FND_API.G_MISS_CHAR
707: THEN
708: v_forecast_rollup_flag := l_forecast_rollup_flag ;
709: ELSE
710: v_forecast_rollup_flag := p_status_rec.forecast_rollup_flag ;

Line 712: IF p_status_rec.status_rank = FND_API.G_MISS_NUM

708: v_forecast_rollup_flag := l_forecast_rollup_flag ;
709: ELSE
710: v_forecast_rollup_flag := p_status_rec.forecast_rollup_flag ;
711: END IF;
712: IF p_status_rec.status_rank = FND_API.G_MISS_NUM
713: THEN
714: v_status_rank := l_status_rank;
715: ELSE
716: v_status_rank := p_status_rec.status_rank ;

Line 718: IF p_status_rec.attribute_category = FND_API.G_MISS_CHAR

714: v_status_rank := l_status_rank;
715: ELSE
716: v_status_rank := p_status_rec.status_rank ;
717: END IF;
718: IF p_status_rec.attribute_category = FND_API.G_MISS_CHAR
719: THEN
720: v_attribute_category := l_attribute_category;
721: ELSE
722: v_attribute_category := p_status_rec.attribute_category;

Line 724: IF p_status_rec.attribute1 = FND_API.G_MISS_CHAR

720: v_attribute_category := l_attribute_category;
721: ELSE
722: v_attribute_category := p_status_rec.attribute_category;
723: END IF;
724: IF p_status_rec.attribute1 = FND_API.G_MISS_CHAR
725: THEN
726: v_attribute1 := l_attribute1 ;
727: ELSE
728: v_attribute1 := p_status_rec.attribute1;

Line 730: IF p_status_rec.attribute2 = FND_API.G_MISS_CHAR

726: v_attribute1 := l_attribute1 ;
727: ELSE
728: v_attribute1 := p_status_rec.attribute1;
729: END IF;
730: IF p_status_rec.attribute2 = FND_API.G_MISS_CHAR
731: THEN
732: v_attribute2 := l_attribute2 ;
733: ELSE
734: v_attribute2 := p_status_rec.attribute2;

Line 736: IF p_status_rec.attribute3 = FND_API.G_MISS_CHAR

732: v_attribute2 := l_attribute2 ;
733: ELSE
734: v_attribute2 := p_status_rec.attribute2;
735: END IF;
736: IF p_status_rec.attribute3 = FND_API.G_MISS_CHAR
737: THEN
738: v_attribute3 := l_attribute3 ;
739: ELSE
740: v_attribute3 := p_status_rec.attribute3 ;

Line 742: IF p_status_rec.attribute4 = FND_API.G_MISS_CHAR

738: v_attribute3 := l_attribute3 ;
739: ELSE
740: v_attribute3 := p_status_rec.attribute3 ;
741: END IF;
742: IF p_status_rec.attribute4 = FND_API.G_MISS_CHAR
743: THEN
744: v_attribute4 := l_attribute4 ;
745: ELSE
746: v_attribute4 := p_status_rec.attribute4;

Line 748: IF p_status_rec.attribute5 = FND_API.G_MISS_CHAR

744: v_attribute4 := l_attribute4 ;
745: ELSE
746: v_attribute4 := p_status_rec.attribute4;
747: END IF;
748: IF p_status_rec.attribute5 = FND_API.G_MISS_CHAR
749: THEN
750: v_attribute5 := l_attribute5 ;
751: ELSE
752: v_attribute5 := p_status_rec.attribute5;

Line 754: IF p_status_rec.attribute6 = FND_API.G_MISS_CHAR

750: v_attribute5 := l_attribute5 ;
751: ELSE
752: v_attribute5 := p_status_rec.attribute5;
753: END IF;
754: IF p_status_rec.attribute6 = FND_API.G_MISS_CHAR
755: THEN
756: v_attribute6 := l_attribute6 ;
757: ELSE
758: v_attribute6 := p_status_rec.attribute6;

Line 760: IF p_status_rec.attribute7 = FND_API.G_MISS_CHAR

756: v_attribute6 := l_attribute6 ;
757: ELSE
758: v_attribute6 := p_status_rec.attribute6;
759: END IF;
760: IF p_status_rec.attribute7 = FND_API.G_MISS_CHAR
761: THEN
762: v_attribute7 := l_attribute7 ;
763: ELSE
764: v_attribute7 := p_status_rec.attribute7;

Line 766: IF p_status_rec.attribute8 = FND_API.G_MISS_CHAR

762: v_attribute7 := l_attribute7 ;
763: ELSE
764: v_attribute7 := p_status_rec.attribute7;
765: END IF;
766: IF p_status_rec.attribute8 = FND_API.G_MISS_CHAR
767: THEN
768: v_attribute8 := l_attribute8 ;
769: ELSE
770: v_attribute8 := p_status_rec.attribute8;

Line 772: IF p_status_rec.attribute9 = FND_API.G_MISS_CHAR

768: v_attribute8 := l_attribute8 ;
769: ELSE
770: v_attribute8 := p_status_rec.attribute8;
771: END IF;
772: IF p_status_rec.attribute9 = FND_API.G_MISS_CHAR
773: THEN
774: v_attribute9 := l_attribute9 ;
775: ELSE
776: v_attribute9 := p_status_rec.attribute9;

Line 778: IF p_status_rec.attribute10 = FND_API.G_MISS_CHAR

774: v_attribute9 := l_attribute9 ;
775: ELSE
776: v_attribute9 := p_status_rec.attribute9;
777: END IF;
778: IF p_status_rec.attribute10 = FND_API.G_MISS_CHAR
779: THEN
780: v_attribute10 := l_attribute10 ;
781: ELSE
782: v_attribute10 := p_status_rec.attribute10;

Line 784: IF p_status_rec.attribute11 = FND_API.G_MISS_CHAR

780: v_attribute10 := l_attribute10 ;
781: ELSE
782: v_attribute10 := p_status_rec.attribute10;
783: END IF;
784: IF p_status_rec.attribute11 = FND_API.G_MISS_CHAR
785: THEN
786: v_attribute11 := l_attribute11 ;
787: ELSE
788: v_attribute11 := p_status_rec.attribute11;

Line 790: IF p_status_rec.attribute12 = FND_API.G_MISS_CHAR

786: v_attribute11 := l_attribute11 ;
787: ELSE
788: v_attribute11 := p_status_rec.attribute11;
789: END IF;
790: IF p_status_rec.attribute12 = FND_API.G_MISS_CHAR
791: THEN
792: v_attribute12 := l_attribute12 ;
793: ELSE
794: v_attribute12 := p_status_rec.attribute12;

Line 796: IF p_status_rec.attribute13 = FND_API.G_MISS_CHAR

792: v_attribute12 := l_attribute12 ;
793: ELSE
794: v_attribute12 := p_status_rec.attribute12;
795: END IF;
796: IF p_status_rec.attribute13 = FND_API.G_MISS_CHAR
797: THEN
798: v_attribute13 := l_attribute13 ;
799: ELSE
800: v_attribute13 := p_status_rec.attribute13;

Line 802: IF p_status_rec.attribute14 = FND_API.G_MISS_CHAR

798: v_attribute13 := l_attribute13 ;
799: ELSE
800: v_attribute13 := p_status_rec.attribute13;
801: END IF;
802: IF p_status_rec.attribute14 = FND_API.G_MISS_CHAR
803: THEN
804: v_attribute14 := l_attribute14 ;
805: ELSE
806: v_attribute14 := p_status_rec.attribute14;

Line 808: IF p_status_rec.attribute15 = FND_API.G_MISS_CHAR

804: v_attribute14 := l_attribute14 ;
805: ELSE
806: v_attribute14 := p_status_rec.attribute14;
807: END IF;
808: IF p_status_rec.attribute15 = FND_API.G_MISS_CHAR
809: THEN
810: v_attribute15 := l_attribute15 ;
811: ELSE
812: v_attribute15 := p_status_rec.attribute15;

Line 814: IF p_status_rec.meaning = FND_API.G_MISS_CHAR

810: v_attribute15 := l_attribute15 ;
811: ELSE
812: v_attribute15 := p_status_rec.attribute15;
813: END IF;
814: IF p_status_rec.meaning = FND_API.G_MISS_CHAR
815: THEN
816: v_meaning := l_meaning ;
817: ELSE
818: v_meaning := p_status_rec.meaning;

Line 820: IF p_status_rec.description = FND_API.G_MISS_CHAR

816: v_meaning := l_meaning ;
817: ELSE
818: v_meaning := p_status_rec.meaning;
819: END IF;
820: IF p_status_rec.description = FND_API.G_MISS_CHAR
821: THEN
822: v_description := l_description ;
823: ELSE
824: v_description := p_status_rec.description;

Line 829: IF p_status_rec.last_update_date = FND_API.G_MISS_DATE

825: END IF;
826:
827: -- Check to see if values were passed for the who colums
828: -- if not default them.
829: IF p_status_rec.last_update_date = FND_API.G_MISS_DATE
830: OR TRIM(p_status_rec.last_update_date) IS NULL
831: THEN
832: l_last_update_date := SYSDATE;
833: ELSE

Line 837: IF p_status_rec.last_update_login = FND_API.G_MISS_NUM

833: ELSE
834: l_last_update_date := p_status_rec.last_update_date ;
835: END IF;
836:
837: IF p_status_rec.last_update_login = FND_API.G_MISS_NUM
838: OR TRIM(p_status_rec.last_update_login) IS NULL
839: THEN
840: l_last_update_login := fnd_global.login_id;
841: ELSE

Line 845: IF p_status_rec.last_updated_by = FND_API.G_MISS_NUM

841: ELSE
842: l_last_update_login := p_status_rec.last_update_login;
843: END IF;
844:
845: IF p_status_rec.last_updated_by = FND_API.G_MISS_NUM
846: OR TRIM(p_status_rec.last_updated_by) IS NULL
847: THEN
848: l_last_updated_by := fnd_global.user_id;
849: ELSE

Line 906: RAISE fnd_api.g_exc_error;

902: IF (FND_MSG_PUB.COUNT_MSG > 0)
903: THEN
904: fnd_message.set_name('AS', 'AS_STATUS_UPDATE_FAILED');
905: fnd_msg_pub.add;
906: RAISE fnd_api.g_exc_error;
907: END IF;
908:
909: -- Lock the row for update. Check to see if the fetched value is same still.
910: -- If they are same then update the record else give a message that the row has been

Line 918: RAISE fnd_api.g_exc_unexpected_error;

914: FETCH lock_row_for_update INTO l_current_last_update_date;
915: IF lock_row_for_update%NOTFOUND
916: THEN
917: CLOSE lock_row_for_update;
918: RAISE fnd_api.g_exc_unexpected_error;
919: END IF;
920:
921: IF l_last_update_date <> l_current_last_update_date
922: THEN

Line 925: RAISE fnd_api.g_exc_error;

921: IF l_last_update_date <> l_current_last_update_date
922: THEN
923: fnd_message.set_name('AS', 'AS_RECORD_UPDATED');
924: fnd_msg_pub.add;
925: RAISE fnd_api.g_exc_error;
926: END IF;
927:
928: AS_STATUSES_PKG.UPDATE_ROW(
929: p_status_rec.status_code,

Line 963: IF fnd_api.to_boolean (p_commit)

959: l_last_update_login);
960:
961:
962: -- Standard Check for p_commit
963: IF fnd_api.to_boolean (p_commit)
964: THEN
965: COMMIT WORK;
966: END IF;
967:

Line 981: WHEN fnd_api.g_exc_error THEN

977: );
978:
979: -- Handling all Exceptions
980: EXCEPTION
981: WHEN fnd_api.g_exc_error THEN
982: ROLLBACK TO update_status;
983: x_return_status := fnd_api.g_ret_sts_error;
984: fnd_msg_pub.count_and_get (
985: p_count => x_msg_count,

Line 983: x_return_status := fnd_api.g_ret_sts_error;

979: -- Handling all Exceptions
980: EXCEPTION
981: WHEN fnd_api.g_exc_error THEN
982: ROLLBACK TO update_status;
983: x_return_status := fnd_api.g_ret_sts_error;
984: fnd_msg_pub.count_and_get (
985: p_count => x_msg_count,
986: p_data => x_msg_data
987: );

Line 988: WHEN fnd_api.g_exc_unexpected_error THEN

984: fnd_msg_pub.count_and_get (
985: p_count => x_msg_count,
986: p_data => x_msg_data
987: );
988: WHEN fnd_api.g_exc_unexpected_error THEN
989: ROLLBACK TO update_status;
990: x_return_status := fnd_api.g_ret_sts_unexp_error;
991: fnd_msg_pub.count_and_get (
992: p_count => x_msg_count,

Line 990: x_return_status := fnd_api.g_ret_sts_unexp_error;

986: p_data => x_msg_data
987: );
988: WHEN fnd_api.g_exc_unexpected_error THEN
989: ROLLBACK TO update_status;
990: x_return_status := fnd_api.g_ret_sts_unexp_error;
991: fnd_msg_pub.count_and_get (
992: p_count => x_msg_count,
993: p_data => x_msg_data
994: );

Line 997: x_return_status := fnd_api.g_ret_sts_unexp_error;

993: p_data => x_msg_data
994: );
995: WHEN OTHERS THEN
996: ROLLBACK TO update_status;
997: x_return_status := fnd_api.g_ret_sts_unexp_error;
998: fnd_msg_pub.count_and_get (
999: p_count => x_msg_count,
1000: p_data => x_msg_data
1001: );