154: x_msg_count => x_msg_count,
155: x_msg_data => x_msg_data,
156: x_ent_contracts => x_ent_contracts);
157:
158: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
159: RAISE FND_API.G_EXC_ERROR ;
160: ELSIF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
162: END IF ;
155: x_msg_data => x_msg_data,
156: x_ent_contracts => x_ent_contracts);
157:
158: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
159: RAISE FND_API.G_EXC_ERROR ;
160: ELSIF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
162: END IF ;
163: x_return_status := l_return_status;
156: x_ent_contracts => x_ent_contracts);
157:
158: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
159: RAISE FND_API.G_EXC_ERROR ;
160: ELSIF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
162: END IF ;
163: x_return_status := l_return_status;
164:
157:
158: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
159: RAISE FND_API.G_EXC_ERROR ;
160: ELSIF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
162: END IF ;
163: x_return_status := l_return_status;
164:
165: EXCEPTION
163: x_return_status := l_return_status;
164:
165: EXCEPTION
166:
167: WHEN FND_API.G_EXC_ERROR THEN
168: ROLLBACK TO Get_contract_lines;
169: x_return_status := FND_API.G_RET_STS_ERROR ;
170: FND_MSG_PUB.COUNT_AND_GET ( p_count =>x_msg_count ,
171: p_data => x_msg_data ,
165: EXCEPTION
166:
167: WHEN FND_API.G_EXC_ERROR THEN
168: ROLLBACK TO Get_contract_lines;
169: x_return_status := FND_API.G_RET_STS_ERROR ;
170: FND_MSG_PUB.COUNT_AND_GET ( p_count =>x_msg_count ,
171: p_data => x_msg_data ,
172: p_encoded => fnd_api.g_false );
173:
168: ROLLBACK TO Get_contract_lines;
169: x_return_status := FND_API.G_RET_STS_ERROR ;
170: FND_MSG_PUB.COUNT_AND_GET ( p_count =>x_msg_count ,
171: p_data => x_msg_data ,
172: p_encoded => fnd_api.g_false );
173:
174: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
175: ROLLBACK TO Get_contract_lines;
176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
170: FND_MSG_PUB.COUNT_AND_GET ( p_count =>x_msg_count ,
171: p_data => x_msg_data ,
172: p_encoded => fnd_api.g_false );
173:
174: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
175: ROLLBACK TO Get_contract_lines;
176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
177: FND_MSG_PUB.COUNT_AND_GET ( p_count =>x_msg_count ,
178: p_data => x_msg_data ,
172: p_encoded => fnd_api.g_false );
173:
174: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
175: ROLLBACK TO Get_contract_lines;
176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
177: FND_MSG_PUB.COUNT_AND_GET ( p_count =>x_msg_count ,
178: p_data => x_msg_data ,
179: p_encoded => fnd_api.g_false );
180:
175: ROLLBACK TO Get_contract_lines;
176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
177: FND_MSG_PUB.COUNT_AND_GET ( p_count =>x_msg_count ,
178: p_data => x_msg_data ,
179: p_encoded => fnd_api.g_false );
180:
181: WHEN OTHERS THEN
182: ROLLBACK TO Get_contract_lines;
183: x_return_status := FND_API.G_RET_STS_unexp_error ;
179: p_encoded => fnd_api.g_false );
180:
181: WHEN OTHERS THEN
182: ROLLBACK TO Get_contract_lines;
183: x_return_status := FND_API.G_RET_STS_unexp_error ;
184: IF fnd_msg_pub.check_msg_level ( fnd_msg_pub.g_msg_lvl_unexp_error ) THEN
185: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name ) ;
186: END IF;
187: fnd_msg_pub.count_and_get ( p_count =>x_msg_count ,
185: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name ) ;
186: END IF;
187: fnd_msg_pub.count_and_get ( p_count =>x_msg_count ,
188: p_data => x_msg_data ,
189: p_encoded => fnd_api.g_false );
190:
191:
192: END;
193:
276: p_cust_site_id,--access hour project
277: p_cust_loc_id);--access hour project
278:
279:
280: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
281: RAISE FND_API.G_EXC_ERROR ;
282: ELSIF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
284: END IF ;
277: p_cust_loc_id);--access hour project
278:
279:
280: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
281: RAISE FND_API.G_EXC_ERROR ;
282: ELSIF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
284: END IF ;
285:
278:
279:
280: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
281: RAISE FND_API.G_EXC_ERROR ;
282: ELSIF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
284: END IF ;
285:
286: x_react_by_date := l_react_by_date;
279:
280: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
281: RAISE FND_API.G_EXC_ERROR ;
282: ELSIF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
284: END IF ;
285:
286: x_react_by_date := l_react_by_date;
287: x_return_status := l_return_status;
289: x_msg_data := l_msg_data;
290:
291: EXCEPTION
292:
293: WHEN FND_API.G_EXC_ERROR THEN
294: ROLLBACK TO check_reaction_times;
295: x_return_status := FND_API.G_RET_STS_ERROR ;
296: FND_MSG_PUB.COUNT_AND_GET ( p_count =>x_msg_count ,
297: p_data => x_msg_data ,
291: EXCEPTION
292:
293: WHEN FND_API.G_EXC_ERROR THEN
294: ROLLBACK TO check_reaction_times;
295: x_return_status := FND_API.G_RET_STS_ERROR ;
296: FND_MSG_PUB.COUNT_AND_GET ( p_count =>x_msg_count ,
297: p_data => x_msg_data ,
298: p_encoded => fnd_api.g_false );
299:
294: ROLLBACK TO check_reaction_times;
295: x_return_status := FND_API.G_RET_STS_ERROR ;
296: FND_MSG_PUB.COUNT_AND_GET ( p_count =>x_msg_count ,
297: p_data => x_msg_data ,
298: p_encoded => fnd_api.g_false );
299:
300: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
301: ROLLBACK TO check_reaction_times;
302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
296: FND_MSG_PUB.COUNT_AND_GET ( p_count =>x_msg_count ,
297: p_data => x_msg_data ,
298: p_encoded => fnd_api.g_false );
299:
300: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
301: ROLLBACK TO check_reaction_times;
302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
303: FND_MSG_PUB.COUNT_AND_GET ( p_count =>x_msg_count ,
304: p_data => x_msg_data ,
298: p_encoded => fnd_api.g_false );
299:
300: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
301: ROLLBACK TO check_reaction_times;
302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
303: FND_MSG_PUB.COUNT_AND_GET ( p_count =>x_msg_count ,
304: p_data => x_msg_data ,
305: p_encoded => fnd_api.g_false );
306:
301: ROLLBACK TO check_reaction_times;
302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
303: FND_MSG_PUB.COUNT_AND_GET ( p_count =>x_msg_count ,
304: p_data => x_msg_data ,
305: p_encoded => fnd_api.g_false );
306:
307: WHEN OTHERS THEN
308: ROLLBACK TO check_reaction_times;
309: x_return_status := FND_API.G_RET_STS_unexp_error ;
305: p_encoded => fnd_api.g_false );
306:
307: WHEN OTHERS THEN
308: ROLLBACK TO check_reaction_times;
309: x_return_status := FND_API.G_RET_STS_unexp_error ;
310: IF fnd_msg_pub.check_msg_level ( fnd_msg_pub.g_msg_lvl_unexp_error ) THEN
311: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name ) ;
312: END IF;
313: fnd_msg_pub.count_and_get ( p_count =>x_msg_count ,
311: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name ) ;
312: END IF;
313: fnd_msg_pub.count_and_get ( p_count =>x_msg_count ,
314: p_data => x_msg_data ,
315: p_encoded => fnd_api.g_false );
316:
317:
318: END;
319:
386: x_msg_data =>l_msg_data,
387: x_ent_contacts=>l_ent_contacts);
388:
389:
390: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
391: RAISE FND_API.G_EXC_ERROR ;
392: ELSIF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
393: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
394: END IF ;
387: x_ent_contacts=>l_ent_contacts);
388:
389:
390: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
391: RAISE FND_API.G_EXC_ERROR ;
392: ELSIF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
393: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
394: END IF ;
395:
388:
389:
390: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
391: RAISE FND_API.G_EXC_ERROR ;
392: ELSIF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
393: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
394: END IF ;
395:
396: -- If p_contact_id is one of the valid contacts then l_valid_contact
389:
390: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
391: RAISE FND_API.G_EXC_ERROR ;
392: ELSIF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
393: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
394: END IF ;
395:
396: -- If p_contact_id is one of the valid contacts then l_valid_contact
397: -- flag is set to 'Y' else 'N' is returned.
409: x_valid_contact := l_valid_contact;
410:
411: EXCEPTION
412:
413: WHEN FND_API.G_EXC_ERROR THEN
414: ROLLBACK TO validate_contact;
415: x_return_status := FND_API.G_RET_STS_ERROR ;
416: FND_MSG_PUB.COUNT_AND_GET ( p_count =>x_msg_count ,
417: p_data => x_msg_data ,
411: EXCEPTION
412:
413: WHEN FND_API.G_EXC_ERROR THEN
414: ROLLBACK TO validate_contact;
415: x_return_status := FND_API.G_RET_STS_ERROR ;
416: FND_MSG_PUB.COUNT_AND_GET ( p_count =>x_msg_count ,
417: p_data => x_msg_data ,
418: p_encoded => fnd_api.g_false );
419:
414: ROLLBACK TO validate_contact;
415: x_return_status := FND_API.G_RET_STS_ERROR ;
416: FND_MSG_PUB.COUNT_AND_GET ( p_count =>x_msg_count ,
417: p_data => x_msg_data ,
418: p_encoded => fnd_api.g_false );
419:
420: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
421: ROLLBACK TO validate_contact;
422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
416: FND_MSG_PUB.COUNT_AND_GET ( p_count =>x_msg_count ,
417: p_data => x_msg_data ,
418: p_encoded => fnd_api.g_false );
419:
420: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
421: ROLLBACK TO validate_contact;
422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
423: FND_MSG_PUB.COUNT_AND_GET ( p_count =>x_msg_count ,
424: p_data => x_msg_data ,
418: p_encoded => fnd_api.g_false );
419:
420: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
421: ROLLBACK TO validate_contact;
422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
423: FND_MSG_PUB.COUNT_AND_GET ( p_count =>x_msg_count ,
424: p_data => x_msg_data ,
425: p_encoded => fnd_api.g_false );
426:
421: ROLLBACK TO validate_contact;
422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
423: FND_MSG_PUB.COUNT_AND_GET ( p_count =>x_msg_count ,
424: p_data => x_msg_data ,
425: p_encoded => fnd_api.g_false );
426:
427: WHEN OTHERS THEN
428: ROLLBACK TO validate_contact;
429: x_return_status := FND_API.G_RET_STS_unexp_error ;
425: p_encoded => fnd_api.g_false );
426:
427: WHEN OTHERS THEN
428: ROLLBACK TO validate_contact;
429: x_return_status := FND_API.G_RET_STS_unexp_error ;
430: IF fnd_msg_pub.check_msg_level ( fnd_msg_pub.g_msg_lvl_unexp_error ) THEN
431: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name ) ;
432: END IF;
433: fnd_msg_pub.count_and_get ( p_count =>x_msg_count ,
431: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name ) ;
432: END IF;
433: fnd_msg_pub.count_and_get ( p_count =>x_msg_count ,
434: p_data => x_msg_data ,
435: p_encoded => fnd_api.g_false );
436:
437: END;
438:
439: /*********************************************************************
503: x_msg_data =>l_msg_data,
504: x_ent_contacts=>l_ent_contacts);
505:
506:
507: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
508: RAISE FND_API.G_EXC_ERROR ;
509: ELSIF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
510: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
511: END IF ;
504: x_ent_contacts=>l_ent_contacts);
505:
506:
507: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
508: RAISE FND_API.G_EXC_ERROR ;
509: ELSIF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
510: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
511: END IF ;
512:
505:
506:
507: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
508: RAISE FND_API.G_EXC_ERROR ;
509: ELSIF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
510: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
511: END IF ;
512:
513: -- If p_contact_id is one of the valid contacts then l_valid_contact
506:
507: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
508: RAISE FND_API.G_EXC_ERROR ;
509: ELSIF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
510: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
511: END IF ;
512:
513: -- If p_contact_id is one of the valid contacts then l_valid_contact
514: -- flag is set to 'Y' else 'N' is returned.
536:
537:
538: EXCEPTION
539:
540: WHEN FND_API.G_EXC_ERROR THEN
541: ROLLBACK TO validate_contact;
542: x_return_status := FND_API.G_RET_STS_ERROR ;
543: FND_MSG_PUB.COUNT_AND_GET ( p_count =>x_msg_count ,
544: p_data => x_msg_data ,
538: EXCEPTION
539:
540: WHEN FND_API.G_EXC_ERROR THEN
541: ROLLBACK TO validate_contact;
542: x_return_status := FND_API.G_RET_STS_ERROR ;
543: FND_MSG_PUB.COUNT_AND_GET ( p_count =>x_msg_count ,
544: p_data => x_msg_data ,
545: p_encoded => fnd_api.g_false );
546:
541: ROLLBACK TO validate_contact;
542: x_return_status := FND_API.G_RET_STS_ERROR ;
543: FND_MSG_PUB.COUNT_AND_GET ( p_count =>x_msg_count ,
544: p_data => x_msg_data ,
545: p_encoded => fnd_api.g_false );
546:
547: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
548: ROLLBACK TO validate_contact;
549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
543: FND_MSG_PUB.COUNT_AND_GET ( p_count =>x_msg_count ,
544: p_data => x_msg_data ,
545: p_encoded => fnd_api.g_false );
546:
547: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
548: ROLLBACK TO validate_contact;
549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
550: FND_MSG_PUB.COUNT_AND_GET ( p_count =>x_msg_count ,
551: p_data => x_msg_data ,
545: p_encoded => fnd_api.g_false );
546:
547: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
548: ROLLBACK TO validate_contact;
549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
550: FND_MSG_PUB.COUNT_AND_GET ( p_count =>x_msg_count ,
551: p_data => x_msg_data ,
552: p_encoded => fnd_api.g_false );
553:
548: ROLLBACK TO validate_contact;
549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
550: FND_MSG_PUB.COUNT_AND_GET ( p_count =>x_msg_count ,
551: p_data => x_msg_data ,
552: p_encoded => fnd_api.g_false );
553:
554: WHEN OTHERS THEN
555: ROLLBACK TO validate_contact;
556: x_return_status := FND_API.G_RET_STS_unexp_error ;
552: p_encoded => fnd_api.g_false );
553:
554: WHEN OTHERS THEN
555: ROLLBACK TO validate_contact;
556: x_return_status := FND_API.G_RET_STS_unexp_error ;
557: IF fnd_msg_pub.check_msg_level ( fnd_msg_pub.g_msg_lvl_unexp_error ) THEN
558: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name ) ;
559: END IF;
560: fnd_msg_pub.count_and_get ( p_count =>x_msg_count ,
558: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name ) ;
559: END IF;
560: fnd_msg_pub.count_and_get ( p_count =>x_msg_count ,
561: p_data => x_msg_data ,
562: p_encoded => fnd_api.g_false );
563:
564: END;
565:
566: END CS_CONT_GET_DETAILS_PVT;