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.CSI_T_TXN_RLTNSHPS_PVT dependencies on FND_MSG_PUB

Line 44: FND_MSG_PUB.initialize;

40:
41:
42: -- Initialize message list if p_init_msg_list is set to TRUE.
43: IF FND_API.to_Boolean( p_init_msg_list ) THEN
44: FND_MSG_PUB.initialize;
45: END IF;
46:
47: -- Initialize API return status to success
48: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 82: FND_MSG_PUB.add;

78: AND p_txn_ii_rltns_rec.api_caller_identity <> 'CONFIG'
79: THEN
80: FND_MESSAGE.set_name('CSI','CSI_TXN_NOT_CZ_CALLER');
81: FND_MESSAGE.set_token('API_CALLER',p_txn_ii_rltns_rec.api_caller_identity) ;
82: FND_MSG_PUB.add;
83: RAISE FND_API.g_exc_error;
84: END IF ;
85:
86: IF (NVL(p_txn_ii_rltns_rec.sub_config_inst_hdr_id , fnd_api.g_miss_num) <> fnd_api.g_miss_num

Line 208: FND_MSG_PUB.add;

204:
205: IF p_txn_ii_rltns_rec.subject_type not in ('T', 'I') THEN
206: FND_MESSAGE.set_name('CSI','CSI_TXN_II_INVALID_RLTNS_TYPE');
207: FND_MESSAGE.set_token('RLTNS_TYPE',p_txn_ii_rltns_rec.subject_type);
208: FND_MSG_PUB.add;
209: RAISE fnd_api.g_exc_error;
210: ELSIF p_txn_ii_rltns_rec.object_type not in ('T', 'I') THEN
211: FND_MESSAGE.set_name('CSI','CSI_TXN_II_INVALID_RLTNS_TYPE');
212: FND_MESSAGE.set_token('RLTNS_TYPE',p_txn_ii_rltns_rec.object_type);

Line 213: FND_MSG_PUB.add;

209: RAISE fnd_api.g_exc_error;
210: ELSIF p_txn_ii_rltns_rec.object_type not in ('T', 'I') THEN
211: FND_MESSAGE.set_name('CSI','CSI_TXN_II_INVALID_RLTNS_TYPE');
212: FND_MESSAGE.set_token('RLTNS_TYPE',p_txn_ii_rltns_rec.object_type);
213: FND_MSG_PUB.add;
214: RAISE fnd_api.g_exc_error;
215: ELSIF (p_txn_ii_rltns_rec.subject_type = 'I'
216: AND p_txn_ii_rltns_rec.object_type = 'I' ) THEN
217: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_SUB_OBJ_TYPES');

Line 219: FND_MSG_PUB.add;

215: ELSIF (p_txn_ii_rltns_rec.subject_type = 'I'
216: AND p_txn_ii_rltns_rec.object_type = 'I' ) THEN
217: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_SUB_OBJ_TYPES');
218: FND_MESSAGE.set_token('TXN_DTL_ID',p_txn_ii_rltns_rec.object_id);
219: FND_MSG_PUB.add;
220: x_return_status := fnd_api.g_ret_sts_error;
221: RAISE fnd_api.g_exc_error;
222: ELSIF NOT(p_txn_ii_rltns_rec.subject_type = 'T'
223: AND p_txn_ii_rltns_rec.object_type = 'T' ) THEN

Line 247: FND_MSG_PUB.add;

243: IF l_return_status <> fnd_api.g_ret_sts_success THEN
244:
245: FND_MESSAGE.set_name('CSI','CSI_TXN_SUBJECT_ID_INVALID');
246: FND_MESSAGE.set_token('SUBJECT_ID',p_txn_ii_rltns_rec.subject_id);
247: FND_MSG_PUB.add;
248: RAISE fnd_api.g_exc_error;
249:
250: END IF;
251: -- END IF;

Line 269: FND_MSG_PUB.add;

265: IF l_return_status <> fnd_api.g_ret_sts_success THEN
266:
267: FND_MESSAGE.set_name('CSI','CSI_TXN_OBJECT_ID_INVALID');
268: FND_MESSAGE.set_token('OBJECT_ID',p_txn_ii_rltns_rec.object_id);
269: FND_MSG_PUB.add;
270: RAISE fnd_api.g_exc_error;
271:
272: END IF;
273: -- END IF;

Line 287: FND_MSG_PUB.add;

283: IF l_return_status = fnd_api.g_ret_sts_error THEN
284: FND_MESSAGE.set_name('CSI','CSI_TXN_II_RLTNS_CODE_INVALID');
285: FND_MESSAGE.set_token('RLTNS_CODE',
286: p_txn_ii_rltns_rec.relationship_type_code);
287: FND_MSG_PUB.add;
288: RAISE fnd_api.g_exc_error;
289: END IF;
290:
291: -- validate instance reference

Line 316: FND_MSG_PUB.add;

312: FND_MESSAGE.set_token('PARAM','transfer_components_flag');
313: FND_MESSAGE.set_token('VALUE',p_txn_ii_rltns_rec.transfer_components_flag);
314: FND_MESSAGE.set_token('REASON','This attribute is applicable to
315: REPLACED-BY, REPLACEMENT-FOR,UPGRADED-FROM relationship types only');
316: FND_MSG_PUB.add;
317: p_txn_ii_rltns_rec.transfer_components_flag := fnd_api.g_miss_char;
318: END IF;
319: END IF;
320:

Line 412: fnd_msg_pub.add;

408: when others then
409: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
410: fnd_message.set_token('MESSAGE',
411: 'csi_t_ii_relationships_pkg.insert_row Failed. '||substr(sqlerrm,1,200));
412: fnd_msg_pub.add;
413: raise fnd_api.g_exc_error;
414: end;
415:
416: p_txn_ii_rltns_rec.txn_relationship_id := l_txn_relationship_id;

Line 428: FND_MSG_PUB.Count_And_Get(

424: csi_t_gen_utility_pvt.set_debug_off;
425: END IF;
426:
427: -- Standard call to get message count and if count is get message info.
428: FND_MSG_PUB.Count_And_Get(
429: p_count => x_msg_count,
430: p_data => x_msg_data);
431:
432: EXCEPTION

Line 438: FND_MSG_PUB.Count_And_Get (

434:
435: ROLLBACK TO create_txn_ii_rltns_dtls;
436:
437: x_return_status := FND_API.G_RET_STS_ERROR ;
438: FND_MSG_PUB.Count_And_Get (
439: p_count => x_msg_count,
440: p_data => x_msg_data);
441:
442: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 447: FND_MSG_PUB.Count_And_Get(

443:
444: ROLLBACK TO create_txn_ii_rltns_dtls;
445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
446:
447: FND_MSG_PUB.Count_And_Get(
448: p_count => x_msg_count,
449: p_data => x_msg_data);
450:
451: WHEN OTHERS THEN

Line 456: IF FND_MSG_PUB.Check_Msg_Level(

452:
453: ROLLBACK TO create_txn_ii_rltns_dtls;
454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
455:
456: IF FND_MSG_PUB.Check_Msg_Level(
457: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
458:
459: FND_MSG_PUB.Add_Exc_Msg(
460: p_pkg_name => G_PKG_NAME,

Line 457: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

453: ROLLBACK TO create_txn_ii_rltns_dtls;
454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
455:
456: IF FND_MSG_PUB.Check_Msg_Level(
457: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
458:
459: FND_MSG_PUB.Add_Exc_Msg(
460: p_pkg_name => G_PKG_NAME,
461: p_procedure_name => l_api_name);

Line 459: FND_MSG_PUB.Add_Exc_Msg(

455:
456: IF FND_MSG_PUB.Check_Msg_Level(
457: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
458:
459: FND_MSG_PUB.Add_Exc_Msg(
460: p_pkg_name => G_PKG_NAME,
461: p_procedure_name => l_api_name);
462:
463: END IF;

Line 465: FND_MSG_PUB.Count_And_Get(

461: p_procedure_name => l_api_name);
462:
463: END IF;
464:
465: FND_MSG_PUB.Count_And_Get(
466: p_count => x_msg_count,
467: p_data => x_msg_data);
468:
469: END create_txn_ii_rltns_dtls;

Line 510: FND_MSG_PUB.initialize;

506: SAVEPOINT update_txn_ii_rltns_dtls;
507:
508: -- Initialize message list if p_init_msg_list is set to TRUE.
509: IF FND_API.to_Boolean( p_init_msg_list ) THEN
510: FND_MSG_PUB.initialize;
511: END IF;
512:
513: -- Initialize API return status to success
514: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 565: FND_MSG_PUB.add;

561: IF l_return_status <> fnd_api.g_ret_sts_success THEN
562:
563: FND_MESSAGE.set_name('CSI','CSI_TXN_RLTNS_ID_INVALID');
564: FND_MESSAGE.set_token('RLTNS_ID',l_iir_rec.txn_relationship_id);
565: FND_MSG_PUB.add;
566: RAISE fnd_api.g_exc_error;
567:
568: END IF;
569:

Line 590: FND_MSG_PUB.add;

586: AND p_txn_ii_rltns_tbl(l_ind).api_caller_identity <> 'CONFIG'
587: THEN
588: FND_MESSAGE.set_name('CSI','CSI_TXN_NOT_CZ_CALLER');
589: FND_MESSAGE.set_token('API_CALLER',p_txn_ii_rltns_tbl(l_ind).api_caller_identity) ;
590: FND_MSG_PUB.add;
591: RAISE FND_API.g_exc_error;
592: END IF ;
593:
594: IF (NVL(p_txn_ii_rltns_tbl(l_ind).sub_config_inst_hdr_id , fnd_api.g_miss_num) <> fnd_api.g_miss_num

Line 682: FND_MSG_PUB.add;

678:
679: IF l_iir_rec.subject_type not in ('T', 'I') THEN
680: FND_MESSAGE.set_name('CSI','CSI_TXN_II_INVALID_RLTNS_TYPE');
681: FND_MESSAGE.set_token('RLTNS_TYPE',l_iir_rec.subject_type);
682: FND_MSG_PUB.add;
683: RAISE fnd_api.g_exc_error;
684: ELSIF l_iir_rec.object_type not in ('T', 'I') THEN
685: FND_MESSAGE.set_name('CSI','CSI_TXN_II_INVALID_RLTNS_TYPE');
686: FND_MESSAGE.set_token('RLTNS_TYPE',l_iir_rec.object_type);

Line 687: FND_MSG_PUB.add;

683: RAISE fnd_api.g_exc_error;
684: ELSIF l_iir_rec.object_type not in ('T', 'I') THEN
685: FND_MESSAGE.set_name('CSI','CSI_TXN_II_INVALID_RLTNS_TYPE');
686: FND_MESSAGE.set_token('RLTNS_TYPE',l_iir_rec.object_type);
687: FND_MSG_PUB.add;
688: RAISE fnd_api.g_exc_error;
689: ELSIF (l_iir_rec.subject_type = 'I'
690: AND l_iir_rec.object_type = 'I' ) THEN
691: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_SUB_OBJ_TYPES');

Line 693: FND_MSG_PUB.add;

689: ELSIF (l_iir_rec.subject_type = 'I'
690: AND l_iir_rec.object_type = 'I' ) THEN
691: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_SUB_OBJ_TYPES');
692: FND_MESSAGE.set_token('TXN_DTL_ID',l_iir_rec.object_id);
693: FND_MSG_PUB.add;
694: x_return_status := fnd_api.g_ret_sts_error;
695: RAISE fnd_api.g_exc_error;
696: ELSIF NOT(l_iir_rec.subject_type = 'T'
697: AND l_iir_rec.object_type = 'T' ) THEN

Line 717: FND_MSG_PUB.add;

713: IF l_return_status <> fnd_api.g_ret_sts_success THEN
714:
715: FND_MESSAGE.set_name('CSI','CSI_TXN_SUBJECT_ID_INVALID');
716: FND_MESSAGE.set_token('SUBJECT_ID',l_iir_rec.subject_id);
717: FND_MSG_PUB.add;
718: RAISE fnd_api.g_exc_error;
719:
720: END IF;
721: END IF;

Line 736: FND_MSG_PUB.add;

732: IF l_return_status <> fnd_api.g_ret_sts_success THEN
733:
734: FND_MESSAGE.set_name('CSI','CSI_TXN_OBJECT_ID_INVALID');
735: FND_MESSAGE.set_token('OBJECT_ID',l_iir_rec.object_id);
736: FND_MSG_PUB.add;
737: RAISE fnd_api.g_exc_error;
738:
739: END IF;
740: END IF;

Line 756: FND_MSG_PUB.add;

752:
753: FND_MESSAGE.set_name('CSI','CSI_TXN_UPD_DEL_NOT_ALLOWED');
754: FND_MESSAGE.set_token('LVL_ID', l_iir_rec.transaction_line_id);
755: FND_MESSAGE.set_token('STATUS',l_processing_status);
756: FND_MSG_PUB.add;
757: RAISE FND_API.g_exc_error;
758:
759: ELSIF l_iir_rec.object_type = 'T' THEN
760: SELECT tl.processing_status

Line 772: FND_MSG_PUB.add;

768:
769: FND_MESSAGE.set_name('CSI','CSI_TXN_UPD_DEL_NOT_ALLOWED');
770: FND_MESSAGE.set_token('LVL_ID', l_iir_rec.transaction_line_id);
771: FND_MESSAGE.set_token('STATUS',l_processing_status);
772: FND_MSG_PUB.add;
773: RAISE FND_API.g_exc_error;
774: END IF;
775: END IF;
776: ELSIF l_iir_rec.object_type = 'T' THEN

Line 789: FND_MSG_PUB.add;

785:
786: FND_MESSAGE.set_name('CSI','CSI_TXN_UPD_DEL_NOT_ALLOWED');
787: FND_MESSAGE.set_token('LVL_ID', l_iir_rec.transaction_line_id);
788: FND_MESSAGE.set_token('STATUS',l_processing_status);
789: FND_MSG_PUB.add;
790: RAISE FND_API.g_exc_error;
791: END IF;
792:
793: END IF;

Line 798: fnd_msg_pub.add;

794: Exception when others then
795: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
796: fnd_message.set_token('MESSAGE',
797: 'Unhandled exception in Update Txn reltns'||substr(sqlerrm,1,200));
798: fnd_msg_pub.add;
799: raise fnd_api.g_exc_error;
800: END;
801:
802: l_iir_rec.relationship_type_code :=

Line 815: FND_MSG_PUB.add;

811: IF l_return_status <> fnd_api.g_ret_sts_success THEN
812:
813: FND_MESSAGE.set_name('CSI','CSI_TXN_II_RLTNS_CODE_INVALID');
814: FND_MESSAGE.set_token('RLTNS_CODE',l_iir_rec.relationship_type_code);
815: FND_MSG_PUB.add;
816: RAISE fnd_api.g_exc_error;
817:
818: END IF;
819:

Line 835: FND_MSG_PUB.add;

831: FND_MESSAGE.set_token('PARAM','transfer_components_flag');
832: FND_MESSAGE.set_token('VALUE',l_iir_rec.transfer_components_flag);
833: FND_MESSAGE.set_token('REASON','This attribute is applicable to
834: REPLACED-BY, REPLACEMENT-FOR,UPGRADED-FROM relationship types only');
835: FND_MSG_PUB.add;
836: l_iir_rec.transfer_components_flag := fnd_api.g_miss_char;
837: END IF;
838: END IF;
839:

Line 963: fnd_msg_pub.add;

959: when others then
960: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
961: fnd_message.set_token('MESSAGE',
962: 'csi_t_ii_relationships_pkg.update_row Failed. '||substr(sqlerrm,1,200));
963: fnd_msg_pub.add;
964: raise fnd_api.g_exc_error;
965: end;
966:
967: END LOOP;

Line 977: FND_MSG_PUB.Count_And_Get(

973: COMMIT WORK;
974: END IF;
975:
976: -- Standard call to get message count and if count is get message info.
977: FND_MSG_PUB.Count_And_Get(
978: p_count => x_msg_count,
979: p_data => x_msg_data);
980:
981: EXCEPTION

Line 986: FND_MSG_PUB.Count_And_Get (

982: WHEN FND_API.G_EXC_ERROR THEN
983:
984: ROLLBACK TO update_txn_ii_rltns_dtls;
985: x_return_status := FND_API.G_RET_STS_ERROR ;
986: FND_MSG_PUB.Count_And_Get (
987: p_count => x_msg_count,
988: p_data => x_msg_data);
989:
990: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 995: FND_MSG_PUB.Count_And_Get(

991:
992: ROLLBACK TO update_txn_ii_rltns_dtls;
993: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
994:
995: FND_MSG_PUB.Count_And_Get(
996: p_count => x_msg_count,
997: p_data => x_msg_data);
998:
999: WHEN OTHERS THEN

Line 1004: IF FND_MSG_PUB.Check_Msg_Level(

1000:
1001: ROLLBACK TO update_txn_ii_rltns_dtls;
1002: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1003:
1004: IF FND_MSG_PUB.Check_Msg_Level(
1005: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1006:
1007: FND_MSG_PUB.Add_Exc_Msg(
1008: p_pkg_name => G_PKG_NAME,

Line 1005: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1001: ROLLBACK TO update_txn_ii_rltns_dtls;
1002: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1003:
1004: IF FND_MSG_PUB.Check_Msg_Level(
1005: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1006:
1007: FND_MSG_PUB.Add_Exc_Msg(
1008: p_pkg_name => G_PKG_NAME,
1009: p_procedure_name => l_api_name);

Line 1007: FND_MSG_PUB.Add_Exc_Msg(

1003:
1004: IF FND_MSG_PUB.Check_Msg_Level(
1005: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1006:
1007: FND_MSG_PUB.Add_Exc_Msg(
1008: p_pkg_name => G_PKG_NAME,
1009: p_procedure_name => l_api_name);
1010:
1011: END IF;

Line 1013: FND_MSG_PUB.Count_And_Get(

1009: p_procedure_name => l_api_name);
1010:
1011: END IF;
1012:
1013: FND_MSG_PUB.Count_And_Get(
1014: p_count => x_msg_count,
1015: p_data => x_msg_data);
1016:
1017: END update_txn_ii_rltns_dtls;

Line 1051: FND_MSG_PUB.initialize;

1047: SAVEPOINT delete_txn_ii_rltns_dtls;
1048:
1049: -- Initialize message list if p_init_msg_list is set to TRUE.
1050: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1051: FND_MSG_PUB.initialize;
1052: END IF;
1053:
1054: -- Initialize API return status to success
1055: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1102: FND_MSG_PUB.add;

1098: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1099:
1100: FND_MESSAGE.set_name('CSI','CSI_TXN_RLTNS_ID_INVALID');
1101: FND_MESSAGE.set_token('RLTNS_ID',l_rltns_id);
1102: FND_MSG_PUB.add;
1103: RAISE fnd_api.g_exc_error;
1104:
1105: END IF;
1106:

Line 1152: FND_MSG_PUB.Count_And_Get(

1148: COMMIT WORK;
1149: END IF;
1150:
1151: -- Standard call to get message count and if count is get message info.
1152: FND_MSG_PUB.Count_And_Get(
1153: p_count => x_msg_count,
1154: p_data => x_msg_data);
1155:
1156: EXCEPTION

Line 1161: FND_MSG_PUB.Count_And_Get (

1157: WHEN FND_API.G_EXC_ERROR THEN
1158:
1159: ROLLBACK TO delete_txn_ii_rltns_dtls;
1160: x_return_status := FND_API.G_RET_STS_ERROR ;
1161: FND_MSG_PUB.Count_And_Get (
1162: p_count => x_msg_count,
1163: p_data => x_msg_data);
1164:
1165: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1170: FND_MSG_PUB.Count_And_Get(

1166:
1167: ROLLBACK TO delete_txn_ii_rltns_dtls;
1168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1169:
1170: FND_MSG_PUB.Count_And_Get(
1171: p_count => x_msg_count,
1172: p_data => x_msg_data);
1173:
1174: WHEN OTHERS THEN

Line 1179: IF FND_MSG_PUB.Check_Msg_Level(

1175:
1176: ROLLBACK TO delete_txn_ii_rltns_dtls;
1177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1178:
1179: IF FND_MSG_PUB.Check_Msg_Level(
1180: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1181:
1182: FND_MSG_PUB.Add_Exc_Msg(
1183: p_pkg_name => G_PKG_NAME,

Line 1180: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1176: ROLLBACK TO delete_txn_ii_rltns_dtls;
1177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1178:
1179: IF FND_MSG_PUB.Check_Msg_Level(
1180: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1181:
1182: FND_MSG_PUB.Add_Exc_Msg(
1183: p_pkg_name => G_PKG_NAME,
1184: p_procedure_name => l_api_name);

Line 1182: FND_MSG_PUB.Add_Exc_Msg(

1178:
1179: IF FND_MSG_PUB.Check_Msg_Level(
1180: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1181:
1182: FND_MSG_PUB.Add_Exc_Msg(
1183: p_pkg_name => G_PKG_NAME,
1184: p_procedure_name => l_api_name);
1185:
1186: END IF;

Line 1188: FND_MSG_PUB.Count_And_Get(

1184: p_procedure_name => l_api_name);
1185:
1186: END IF;
1187:
1188: FND_MSG_PUB.Count_And_Get(
1189: p_count => x_msg_count,
1190: p_data => x_msg_data);
1191:
1192: END delete_txn_ii_rltns_dtls;