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_MSG_PUB

Line 65: FND_MSG_PUB.ADD;

61: OPEN cur_old_ref_values;
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;

Line 129: FND_MSG_PUB.ADD;

125: ELSIF NOT igs_fi_inv_int_pkg.get_pk_for_validation (
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

Line 139: FND_MSG_PUB.ADD;

135: ELSIF NOT igs_pe_person_pkg.get_pk_for_validation (
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

Line 149: FND_MSG_PUB.ADD;

145: ELSIF NOT igs_pe_person_pkg.get_pk_for_validation (
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;

Line 224: FND_MSG_PUB.ADD;

220: FETCH cur_rowid INTO lv_rowid;
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;

Line 324: FND_MSG_PUB.ADD;

320: new_references.order_number
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

Line 341: FND_MSG_PUB.ADD;

337: new_references.order_number
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;

Line 408: FND_MSG_PUB.initialize;

404: x_program_update_date DATE;
405: BEGIN
406:
407: -- Initailize the error count, error data etc.
408: FND_MSG_PUB.initialize;
409:
410: x_last_update_date := SYSDATE;
411: IF (x_mode = 'I') THEN
412: x_last_updated_by := 1;

Line 436: FND_MSG_PUB.ADD;

432: x_program_update_date := SYSDATE;
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

Line 577: FND_MSG_PUB.Count_And_Get(

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,
579: p_count => x_MSG_COUNT,
580: p_data => X_MSG_DATA);
581:

Line 585: FND_MSG_PUB.Count_And_Get(

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);
589: RETURN;

Line 592: FND_MSG_PUB.Count_And_Get(

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);
596: RETURN;

Line 601: FND_MSG_PUB.ADD;

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(
603: p_encoded => FND_API.G_FALSE,
604: p_count => x_MSG_COUNT,
605: p_data => X_MSG_DATA);

Line 602: FND_MSG_PUB.Count_And_Get(

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(
603: p_encoded => FND_API.G_FALSE,
604: p_count => x_MSG_COUNT,
605: p_data => X_MSG_DATA);
606: RETURN;

Line 694: FND_MSG_PUB.initialize;

690: tlinfo c1%ROWTYPE;
691: BEGIN
692:
693: -- Initailize the error count, error data etc.
694: FND_MSG_PUB.initialize;
695:
696: OPEN c1;
697: FETCH c1 INTO tlinfo;
698: IF (c1%NOTFOUND) THEN

Line 701: FND_MSG_PUB.ADD;

697: FETCH c1 INTO tlinfo;
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;

Line 739: FND_MSG_PUB.ADD;

735: ) THEN
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.

Line 747: FND_MSG_PUB.Count_And_Get(

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,
749: p_count => x_MSG_COUNT,
750: p_data => X_MSG_DATA);
751:

Line 755: FND_MSG_PUB.Count_And_Get(

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);
759: RETURN;

Line 762: FND_MSG_PUB.Count_And_Get(

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);
766: RETURN;

Line 771: FND_MSG_PUB.ADD;

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(
773: p_encoded => FND_API.G_FALSE,
774: p_count => x_MSG_COUNT,
775: p_data => X_MSG_DATA);

Line 772: FND_MSG_PUB.Count_And_Get(

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(
773: p_encoded => FND_API.G_FALSE,
774: p_count => x_MSG_COUNT,
775: p_data => X_MSG_DATA);
776: RETURN;

Line 836: FND_MSG_PUB.INITIALIZE;

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
840: x_last_updated_by := 1;

Line 853: FND_MSG_PUB.ADD;

849: x_last_update_login := -1;
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',

Line 955: FND_MSG_PUB.Count_And_Get(

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,
957: p_count => x_MSG_COUNT,
958: p_data => X_MSG_DATA);
959:

Line 963: FND_MSG_PUB.Count_And_Get(

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);
967: RETURN;

Line 970: FND_MSG_PUB.Count_And_Get(

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);
974: RETURN;

Line 979: FND_MSG_PUB.ADD;

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(
981: p_encoded => FND_API.G_FALSE,
982: p_count => x_MSG_COUNT,
983: p_data => X_MSG_DATA);

Line 980: FND_MSG_PUB.Count_And_Get(

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(
981: p_encoded => FND_API.G_FALSE,
982: p_count => x_MSG_COUNT,
983: p_data => X_MSG_DATA);
984: RETURN;

Line 1040: FND_MSG_PUB.initialize;

1036: WHERE order_number = x_order_number;
1037: BEGIN
1038:
1039: -- Initailize the error count, error data etc.
1040: FND_MSG_PUB.initialize;
1041:
1042: OPEN c1;
1043: FETCH c1 INTO x_rowid;
1044: IF (c1%NOTFOUND) THEN

Line 1127: FND_MSG_PUB.Count_And_Get(

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,
1129: p_count => x_MSG_COUNT,
1130: p_data => X_MSG_DATA);
1131:

Line 1135: FND_MSG_PUB.Count_And_Get(

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);
1139: RETURN;

Line 1142: FND_MSG_PUB.Count_And_Get(

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);
1146: RETURN;

Line 1151: FND_MSG_PUB.ADD;

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(
1153: p_encoded => FND_API.G_FALSE,
1154: p_count => x_MSG_COUNT,
1155: p_data => X_MSG_DATA);

Line 1152: FND_MSG_PUB.Count_And_Get(

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(
1153: p_encoded => FND_API.G_FALSE,
1154: p_count => x_MSG_COUNT,
1155: p_data => X_MSG_DATA);
1156: RETURN;

Line 1188: FND_MSG_PUB.initialize;

1184: rec_c_inv c_inv%ROWTYPE;
1185: BEGIN
1186:
1187: -- Initailize the error count, error data etc.
1188: FND_MSG_PUB.initialize;
1189:
1190: before_dml (
1191: p_action => 'DELETE',
1192: x_rowid => x_rowid

Line 1240: FND_MSG_PUB.Count_And_Get(

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,
1242: p_count => x_MSG_COUNT,
1243: p_data => X_MSG_DATA);
1244:

Line 1248: FND_MSG_PUB.Count_And_Get(

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);
1252: RETURN;

Line 1255: FND_MSG_PUB.Count_And_Get(

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);
1259: RETURN;

Line 1264: FND_MSG_PUB.ADD;

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(
1266: p_encoded => FND_API.G_FALSE,
1267: p_count => x_MSG_COUNT,
1268: p_data => X_MSG_DATA);

Line 1265: FND_MSG_PUB.Count_And_Get(

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(
1266: p_encoded => FND_API.G_FALSE,
1267: p_count => x_MSG_COUNT,
1268: p_data => X_MSG_DATA);
1269: RETURN;