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

Line 66: RAISE FND_API.G_EXC_ERROR;

62: FETCH cur_old_ref_values INTO old_references;
63: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
64: CLOSE cur_old_ref_values;
65: FND_MSG_PUB.ADD;
66: RAISE FND_API.G_EXC_ERROR;
67: RETURN;
68: END IF;
69: CLOSE cur_old_ref_values;
70: -- Populate New Values.

Line 130: RAISE FND_API.G_EXC_ERROR;

126: new_references.invoice_id
127: ) THEN
128: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
129: FND_MSG_PUB.ADD;
130: RAISE FND_API.G_EXC_ERROR;
131: END IF;
132: IF (((old_references.person_id = new_references.person_id)) OR
133: ((new_references.person_id IS NULL))) THEN
134: NULL;

Line 140: RAISE FND_API.G_EXC_ERROR;

136: new_references.person_id
137: ) THEN
138: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
139: FND_MSG_PUB.ADD;
140: RAISE FND_API.G_EXC_ERROR;
141: END IF;
142: IF (((old_references.ORDER_PLACED_BY = new_references.ORDER_PLACED_BY)) OR
143: ((new_references.ORDER_PLACED_BY IS NULL))) THEN
144: NULL;

Line 150: RAISE FND_API.G_EXC_ERROR;

146: new_references.ORDER_PLACED_BY
147: ) THEN
148: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
149: FND_MSG_PUB.ADD;
150: RAISE FND_API.G_EXC_ERROR;
151: END IF;
152:
153: END check_parent_existance;
154:

Line 225: RAISE FND_API.G_EXC_ERROR;

221: IF (cur_rowid%FOUND) THEN
222: CLOSE cur_rowid;
223: fnd_message.set_name ('IGS', 'IGS_AS_TORD_INVI_FK');
224: FND_MSG_PUB.ADD;
225: RAISE FND_API.G_EXC_ERROR;
226: RETURN;
227: END IF;
228: CLOSE cur_rowid;
229: END get_fk_igs_fi_inv_int;

Line 325: RAISE FND_API.G_EXC_ERROR;

321: )
322: ) THEN
323: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
324: FND_MSG_PUB.ADD;
325: RAISE FND_API.G_EXC_ERROR;
326: END IF;
327: check_parent_existance;
328: ELSIF (p_action = 'UPDATE') THEN
329: -- Call all the procedures related to Before Update.

Line 342: RAISE FND_API.G_EXC_ERROR;

338: )
339: ) THEN
340: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
341: FND_MSG_PUB.ADD;
342: RAISE FND_API.G_EXC_ERROR;
343: END IF;
344: ELSIF (p_action = 'VALIDATE_DELETE') THEN
345: check_child_existance;
346: END IF;

Line 437: RAISE FND_API.G_EXC_ERROR;

433: END IF;
434: ELSE
435: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
436: FND_MSG_PUB.ADD;
437: RAISE FND_API.G_EXC_ERROR;
438:
439: END IF;
440: -- adding this if codition to avoid Lock row problem from self service pages
441: IF x_order_number IS NULL THEN

Line 574: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

570: END IF;
571: CLOSE c;
572:
573: -- Initialize API return status to success.
574: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
575: -- Standard call to get message count and if count is 1, get message
576: -- info.
577: FND_MSG_PUB.Count_And_Get(
578: p_encoded => FND_API.G_FALSE,

Line 578: p_encoded => FND_API.G_FALSE,

574: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
575: -- Standard call to get message count and if count is 1, get message
576: -- info.
577: FND_MSG_PUB.Count_And_Get(
578: p_encoded => FND_API.G_FALSE,
579: p_count => x_MSG_COUNT,
580: p_data => X_MSG_DATA);
581:
582: EXCEPTION

Line 583: WHEN FND_API.G_EXC_ERROR THEN

579: p_count => x_MSG_COUNT,
580: p_data => X_MSG_DATA);
581:
582: EXCEPTION
583: WHEN FND_API.G_EXC_ERROR THEN
584: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
585: FND_MSG_PUB.Count_And_Get(
586: p_encoded => FND_API.G_FALSE,
587: p_count => x_MSG_COUNT,

Line 584: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

580: p_data => X_MSG_DATA);
581:
582: EXCEPTION
583: WHEN FND_API.G_EXC_ERROR THEN
584: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
585: FND_MSG_PUB.Count_And_Get(
586: p_encoded => FND_API.G_FALSE,
587: p_count => x_MSG_COUNT,
588: p_data => X_MSG_DATA);

Line 586: p_encoded => FND_API.G_FALSE,

582: EXCEPTION
583: WHEN FND_API.G_EXC_ERROR THEN
584: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
585: FND_MSG_PUB.Count_And_Get(
586: p_encoded => FND_API.G_FALSE,
587: p_count => x_MSG_COUNT,
588: p_data => X_MSG_DATA);
589: RETURN;
590: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 590: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

586: p_encoded => FND_API.G_FALSE,
587: p_count => x_MSG_COUNT,
588: p_data => X_MSG_DATA);
589: RETURN;
590: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
591: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
592: FND_MSG_PUB.Count_And_Get(
593: p_encoded => FND_API.G_FALSE,
594: p_count => x_MSG_COUNT,

Line 591: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

587: p_count => x_MSG_COUNT,
588: p_data => X_MSG_DATA);
589: RETURN;
590: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
591: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
592: FND_MSG_PUB.Count_And_Get(
593: p_encoded => FND_API.G_FALSE,
594: p_count => x_MSG_COUNT,
595: p_data => X_MSG_DATA);

Line 593: p_encoded => FND_API.G_FALSE,

589: RETURN;
590: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
591: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
592: FND_MSG_PUB.Count_And_Get(
593: p_encoded => FND_API.G_FALSE,
594: p_count => x_MSG_COUNT,
595: p_data => X_MSG_DATA);
596: RETURN;
597: WHEN OTHERS THEN

Line 598: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

594: p_count => x_MSG_COUNT,
595: p_data => X_MSG_DATA);
596: RETURN;
597: WHEN OTHERS THEN
598: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
599: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
600: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
601: FND_MSG_PUB.ADD;
602: FND_MSG_PUB.Count_And_Get(

Line 603: p_encoded => FND_API.G_FALSE,

599: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
600: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
601: FND_MSG_PUB.ADD;
602: FND_MSG_PUB.Count_And_Get(
603: p_encoded => FND_API.G_FALSE,
604: p_count => x_MSG_COUNT,
605: p_data => X_MSG_DATA);
606: RETURN;
607:

Line 702: RAISE FND_API.G_EXC_ERROR;

698: IF (c1%NOTFOUND) THEN
699: CLOSE c1;
700: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
701: FND_MSG_PUB.ADD;
702: RAISE FND_API.G_EXC_ERROR;
703:
704: END IF;
705: CLOSE c1;
706: IF (

Line 740: RAISE FND_API.G_EXC_ERROR;

736: NULL;
737: ELSE
738: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
739: FND_MSG_PUB.ADD;
740: RAISE FND_API.G_EXC_ERROR;
741: END IF;
742: RETURN;
743: -- Initialize API return status to success.
744: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

Line 744: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

740: RAISE FND_API.G_EXC_ERROR;
741: END IF;
742: RETURN;
743: -- Initialize API return status to success.
744: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
745: -- Standard call to get message count and if count is 1, get message
746: -- info.
747: FND_MSG_PUB.Count_And_Get(
748: p_encoded => FND_API.G_FALSE,

Line 748: p_encoded => FND_API.G_FALSE,

744: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
745: -- Standard call to get message count and if count is 1, get message
746: -- info.
747: FND_MSG_PUB.Count_And_Get(
748: p_encoded => FND_API.G_FALSE,
749: p_count => x_MSG_COUNT,
750: p_data => X_MSG_DATA);
751:
752: EXCEPTION

Line 753: WHEN FND_API.G_EXC_ERROR THEN

749: p_count => x_MSG_COUNT,
750: p_data => X_MSG_DATA);
751:
752: EXCEPTION
753: WHEN FND_API.G_EXC_ERROR THEN
754: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
755: FND_MSG_PUB.Count_And_Get(
756: p_encoded => FND_API.G_FALSE,
757: p_count => x_MSG_COUNT,

Line 754: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

750: p_data => X_MSG_DATA);
751:
752: EXCEPTION
753: WHEN FND_API.G_EXC_ERROR THEN
754: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
755: FND_MSG_PUB.Count_And_Get(
756: p_encoded => FND_API.G_FALSE,
757: p_count => x_MSG_COUNT,
758: p_data => X_MSG_DATA);

Line 756: p_encoded => FND_API.G_FALSE,

752: EXCEPTION
753: WHEN FND_API.G_EXC_ERROR THEN
754: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
755: FND_MSG_PUB.Count_And_Get(
756: p_encoded => FND_API.G_FALSE,
757: p_count => x_MSG_COUNT,
758: p_data => X_MSG_DATA);
759: RETURN;
760: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 760: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

756: p_encoded => FND_API.G_FALSE,
757: p_count => x_MSG_COUNT,
758: p_data => X_MSG_DATA);
759: RETURN;
760: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
761: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
762: FND_MSG_PUB.Count_And_Get(
763: p_encoded => FND_API.G_FALSE,
764: p_count => x_MSG_COUNT,

Line 761: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

757: p_count => x_MSG_COUNT,
758: p_data => X_MSG_DATA);
759: RETURN;
760: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
761: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
762: FND_MSG_PUB.Count_And_Get(
763: p_encoded => FND_API.G_FALSE,
764: p_count => x_MSG_COUNT,
765: p_data => X_MSG_DATA);

Line 763: p_encoded => FND_API.G_FALSE,

759: RETURN;
760: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
761: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
762: FND_MSG_PUB.Count_And_Get(
763: p_encoded => FND_API.G_FALSE,
764: p_count => x_MSG_COUNT,
765: p_data => X_MSG_DATA);
766: RETURN;
767: WHEN OTHERS THEN

Line 768: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

764: p_count => x_MSG_COUNT,
765: p_data => X_MSG_DATA);
766: RETURN;
767: WHEN OTHERS THEN
768: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
769: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
770: FND_MESSAGE.SET_TOKEN('NAME','Lock_Row : '||SQLERRM);
771: FND_MSG_PUB.ADD;
772: FND_MSG_PUB.Count_And_Get(

Line 773: p_encoded => FND_API.G_FALSE,

769: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
770: FND_MESSAGE.SET_TOKEN('NAME','Lock_Row : '||SQLERRM);
771: FND_MSG_PUB.ADD;
772: FND_MSG_PUB.Count_And_Get(
773: p_encoded => FND_API.G_FALSE,
774: p_count => x_MSG_COUNT,
775: p_data => X_MSG_DATA);
776: RETURN;
777:

Line 835: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN

831: x_program_application_id NUMBER;
832: x_program_update_date DATE;
833: BEGIN
834: -- Initailize the error count, error data etc.
835: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
836: FND_MSG_PUB.INITIALIZE;
837: END IF;
838: x_last_update_date := SYSDATE;
839: IF (X_MODE = 'I') THEN

Line 854: RAISE FND_API.G_EXC_ERROR;

850: END IF;
851: ELSE
852: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
853: FND_MSG_PUB.ADD;
854: RAISE FND_API.G_EXC_ERROR;
855: END IF;
856: before_dml(
857: p_action => 'UPDATE',
858: x_rowid => x_rowid,

Line 952: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

948: RAISE NO_DATA_FOUND;
949: END IF;
950:
951: -- Initialize API return status to success.
952: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
953: -- Standard call to get message count and if count is 1, get message
954: -- info.
955: FND_MSG_PUB.Count_And_Get(
956: p_encoded => FND_API.G_FALSE,

Line 956: p_encoded => FND_API.G_FALSE,

952: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
953: -- Standard call to get message count and if count is 1, get message
954: -- info.
955: FND_MSG_PUB.Count_And_Get(
956: p_encoded => FND_API.G_FALSE,
957: p_count => x_MSG_COUNT,
958: p_data => X_MSG_DATA);
959:
960: EXCEPTION

Line 961: WHEN FND_API.G_EXC_ERROR THEN

957: p_count => x_MSG_COUNT,
958: p_data => X_MSG_DATA);
959:
960: EXCEPTION
961: WHEN FND_API.G_EXC_ERROR THEN
962: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
963: FND_MSG_PUB.Count_And_Get(
964: p_encoded => FND_API.G_FALSE,
965: p_count => x_MSG_COUNT,

Line 962: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

958: p_data => X_MSG_DATA);
959:
960: EXCEPTION
961: WHEN FND_API.G_EXC_ERROR THEN
962: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
963: FND_MSG_PUB.Count_And_Get(
964: p_encoded => FND_API.G_FALSE,
965: p_count => x_MSG_COUNT,
966: p_data => X_MSG_DATA);

Line 964: p_encoded => FND_API.G_FALSE,

960: EXCEPTION
961: WHEN FND_API.G_EXC_ERROR THEN
962: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
963: FND_MSG_PUB.Count_And_Get(
964: p_encoded => FND_API.G_FALSE,
965: p_count => x_MSG_COUNT,
966: p_data => X_MSG_DATA);
967: RETURN;
968: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 968: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

964: p_encoded => FND_API.G_FALSE,
965: p_count => x_MSG_COUNT,
966: p_data => X_MSG_DATA);
967: RETURN;
968: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
969: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
970: FND_MSG_PUB.Count_And_Get(
971: p_encoded => FND_API.G_FALSE,
972: p_count => x_MSG_COUNT,

Line 969: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

965: p_count => x_MSG_COUNT,
966: p_data => X_MSG_DATA);
967: RETURN;
968: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
969: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
970: FND_MSG_PUB.Count_And_Get(
971: p_encoded => FND_API.G_FALSE,
972: p_count => x_MSG_COUNT,
973: p_data => X_MSG_DATA);

Line 971: p_encoded => FND_API.G_FALSE,

967: RETURN;
968: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
969: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
970: FND_MSG_PUB.Count_And_Get(
971: p_encoded => FND_API.G_FALSE,
972: p_count => x_MSG_COUNT,
973: p_data => X_MSG_DATA);
974: RETURN;
975: WHEN OTHERS THEN

Line 976: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

972: p_count => x_MSG_COUNT,
973: p_data => X_MSG_DATA);
974: RETURN;
975: WHEN OTHERS THEN
976: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
977: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
978: FND_MESSAGE.SET_TOKEN('NAME','Update_Row : '||SQLERRM);
979: FND_MSG_PUB.ADD;
980: FND_MSG_PUB.Count_And_Get(

Line 981: p_encoded => FND_API.G_FALSE,

977: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
978: FND_MESSAGE.SET_TOKEN('NAME','Update_Row : '||SQLERRM);
979: FND_MSG_PUB.ADD;
980: FND_MSG_PUB.Count_And_Get(
981: p_encoded => FND_API.G_FALSE,
982: p_count => x_MSG_COUNT,
983: p_data => X_MSG_DATA);
984: RETURN;
985:

Line 1124: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

1120:
1121: );
1122:
1123: -- Initialize API return status to success.
1124: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1125: -- Standard call to get message count and if count is 1, get message
1126: -- info.
1127: FND_MSG_PUB.Count_And_Get(
1128: p_encoded => FND_API.G_FALSE,

Line 1128: p_encoded => FND_API.G_FALSE,

1124: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1125: -- Standard call to get message count and if count is 1, get message
1126: -- info.
1127: FND_MSG_PUB.Count_And_Get(
1128: p_encoded => FND_API.G_FALSE,
1129: p_count => x_MSG_COUNT,
1130: p_data => X_MSG_DATA);
1131:
1132: EXCEPTION

Line 1133: WHEN FND_API.G_EXC_ERROR THEN

1129: p_count => x_MSG_COUNT,
1130: p_data => X_MSG_DATA);
1131:
1132: EXCEPTION
1133: WHEN FND_API.G_EXC_ERROR THEN
1134: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1135: FND_MSG_PUB.Count_And_Get(
1136: p_encoded => FND_API.G_FALSE,
1137: p_count => x_MSG_COUNT,

Line 1134: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

1130: p_data => X_MSG_DATA);
1131:
1132: EXCEPTION
1133: WHEN FND_API.G_EXC_ERROR THEN
1134: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1135: FND_MSG_PUB.Count_And_Get(
1136: p_encoded => FND_API.G_FALSE,
1137: p_count => x_MSG_COUNT,
1138: p_data => X_MSG_DATA);

Line 1136: p_encoded => FND_API.G_FALSE,

1132: EXCEPTION
1133: WHEN FND_API.G_EXC_ERROR THEN
1134: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1135: FND_MSG_PUB.Count_And_Get(
1136: p_encoded => FND_API.G_FALSE,
1137: p_count => x_MSG_COUNT,
1138: p_data => X_MSG_DATA);
1139: RETURN;
1140: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1140: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1136: p_encoded => FND_API.G_FALSE,
1137: p_count => x_MSG_COUNT,
1138: p_data => X_MSG_DATA);
1139: RETURN;
1140: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1141: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1142: FND_MSG_PUB.Count_And_Get(
1143: p_encoded => FND_API.G_FALSE,
1144: p_count => x_MSG_COUNT,

Line 1141: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

1137: p_count => x_MSG_COUNT,
1138: p_data => X_MSG_DATA);
1139: RETURN;
1140: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1141: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1142: FND_MSG_PUB.Count_And_Get(
1143: p_encoded => FND_API.G_FALSE,
1144: p_count => x_MSG_COUNT,
1145: p_data => X_MSG_DATA);

Line 1143: p_encoded => FND_API.G_FALSE,

1139: RETURN;
1140: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1141: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1142: FND_MSG_PUB.Count_And_Get(
1143: p_encoded => FND_API.G_FALSE,
1144: p_count => x_MSG_COUNT,
1145: p_data => X_MSG_DATA);
1146: RETURN;
1147: WHEN OTHERS THEN

Line 1148: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

1144: p_count => x_MSG_COUNT,
1145: p_data => X_MSG_DATA);
1146: RETURN;
1147: WHEN OTHERS THEN
1148: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1149: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
1150: FND_MESSAGE.SET_TOKEN('NAME','Add_Row : '||SQLERRM);
1151: FND_MSG_PUB.ADD;
1152: FND_MSG_PUB.Count_And_Get(

Line 1153: p_encoded => FND_API.G_FALSE,

1149: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
1150: FND_MESSAGE.SET_TOKEN('NAME','Add_Row : '||SQLERRM);
1151: FND_MSG_PUB.ADD;
1152: FND_MSG_PUB.Count_And_Get(
1153: p_encoded => FND_API.G_FALSE,
1154: p_count => x_MSG_COUNT,
1155: p_data => X_MSG_DATA);
1156: RETURN;
1157: END add_row;

Line 1226: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN

1222: x_msg_count => x_msg_count,
1223: x_msg_data => x_msg_data,
1224: x_waiver_amount => l_waiver_amount
1225: ) ;
1226: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN
1227: RAISE FND_API.G_EXC_ERROR;
1228: END IF;
1229: END IF;
1230: DELETE FROM igs_as_order_hdr

Line 1227: RAISE FND_API.G_EXC_ERROR;

1223: x_msg_data => x_msg_data,
1224: x_waiver_amount => l_waiver_amount
1225: ) ;
1226: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN
1227: RAISE FND_API.G_EXC_ERROR;
1228: END IF;
1229: END IF;
1230: DELETE FROM igs_as_order_hdr
1231: WHERE ROWID = x_rowid;

Line 1237: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

1233: RAISE NO_DATA_FOUND;
1234: END IF;
1235:
1236: -- Initialize API return status to success.
1237: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1238: -- Standard call to get message count and if count is 1, get message
1239: -- info.
1240: FND_MSG_PUB.Count_And_Get(
1241: p_encoded => FND_API.G_FALSE,

Line 1241: p_encoded => FND_API.G_FALSE,

1237: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1238: -- Standard call to get message count and if count is 1, get message
1239: -- info.
1240: FND_MSG_PUB.Count_And_Get(
1241: p_encoded => FND_API.G_FALSE,
1242: p_count => x_MSG_COUNT,
1243: p_data => X_MSG_DATA);
1244:
1245: EXCEPTION

Line 1246: WHEN FND_API.G_EXC_ERROR THEN

1242: p_count => x_MSG_COUNT,
1243: p_data => X_MSG_DATA);
1244:
1245: EXCEPTION
1246: WHEN FND_API.G_EXC_ERROR THEN
1247: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1248: FND_MSG_PUB.Count_And_Get(
1249: p_encoded => FND_API.G_FALSE,
1250: p_count => x_MSG_COUNT,

Line 1247: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

1243: p_data => X_MSG_DATA);
1244:
1245: EXCEPTION
1246: WHEN FND_API.G_EXC_ERROR THEN
1247: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1248: FND_MSG_PUB.Count_And_Get(
1249: p_encoded => FND_API.G_FALSE,
1250: p_count => x_MSG_COUNT,
1251: p_data => X_MSG_DATA);

Line 1249: p_encoded => FND_API.G_FALSE,

1245: EXCEPTION
1246: WHEN FND_API.G_EXC_ERROR THEN
1247: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1248: FND_MSG_PUB.Count_And_Get(
1249: p_encoded => FND_API.G_FALSE,
1250: p_count => x_MSG_COUNT,
1251: p_data => X_MSG_DATA);
1252: RETURN;
1253: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1253: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1249: p_encoded => FND_API.G_FALSE,
1250: p_count => x_MSG_COUNT,
1251: p_data => X_MSG_DATA);
1252: RETURN;
1253: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1254: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1255: FND_MSG_PUB.Count_And_Get(
1256: p_encoded => FND_API.G_FALSE,
1257: p_count => x_MSG_COUNT,

Line 1254: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

1250: p_count => x_MSG_COUNT,
1251: p_data => X_MSG_DATA);
1252: RETURN;
1253: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1254: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1255: FND_MSG_PUB.Count_And_Get(
1256: p_encoded => FND_API.G_FALSE,
1257: p_count => x_MSG_COUNT,
1258: p_data => X_MSG_DATA);

Line 1256: p_encoded => FND_API.G_FALSE,

1252: RETURN;
1253: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1254: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1255: FND_MSG_PUB.Count_And_Get(
1256: p_encoded => FND_API.G_FALSE,
1257: p_count => x_MSG_COUNT,
1258: p_data => X_MSG_DATA);
1259: RETURN;
1260: WHEN OTHERS THEN

Line 1261: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

1257: p_count => x_MSG_COUNT,
1258: p_data => X_MSG_DATA);
1259: RETURN;
1260: WHEN OTHERS THEN
1261: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1262: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
1263: FND_MESSAGE.SET_TOKEN('NAME','Delete_Row : '||SQLERRM);
1264: FND_MSG_PUB.ADD;
1265: FND_MSG_PUB.Count_And_Get(

Line 1266: p_encoded => FND_API.G_FALSE,

1262: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
1263: FND_MESSAGE.SET_TOKEN('NAME','Delete_Row : '||SQLERRM);
1264: FND_MSG_PUB.ADD;
1265: FND_MSG_PUB.Count_And_Get(
1266: p_encoded => FND_API.G_FALSE,
1267: p_count => x_MSG_COUNT,
1268: p_data => X_MSG_DATA);
1269: RETURN;
1270: END delete_row;