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

Line 75: FND_MSG_PUB.initialize;

71: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
72: END IF;
73: -- Initialize message list if p_init_msg_list is set to TRUE.
74: IF FND_API.to_Boolean( p_init_msg_list ) THEN
75: FND_MSG_PUB.initialize;
76: END IF;
77: -- Initialize API return status to success
78: x_return_status := FND_API.G_RET_STS_SUCCESS;
79: -- API body

Line 108: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

104: WHERE imp_map_id = p_imp_map.imp_map_id
105: ;
106: EXCEPTION
107: WHEN no_data_found THEN
108: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
109: THEN
110: FND_MESSAGE.SET_NAME ('CN','CN_REC_NOT_EXISTS');
111: FND_MSG_PUB.Add;
112: END IF;

Line 111: FND_MSG_PUB.Add;

107: WHEN no_data_found THEN
108: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
109: THEN
110: FND_MESSAGE.SET_NAME ('CN','CN_REC_NOT_EXISTS');
111: FND_MSG_PUB.Add;
112: END IF;
113: RAISE FND_API.G_EXC_ERROR ;
114: END;
115: IF l_imp_map.object_version_number >

Line 117: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

113: RAISE FND_API.G_EXC_ERROR ;
114: END;
115: IF l_imp_map.object_version_number >
116: p_imp_map.object_version_number THEN
117: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
118: THEN
119: FND_MESSAGE.SET_NAME ('CN' , 'CN_RECORD_CHANGED');
120: FND_MSG_PUB.Add;
121: END IF;

Line 120: FND_MSG_PUB.Add;

116: p_imp_map.object_version_number THEN
117: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
118: THEN
119: FND_MESSAGE.SET_NAME ('CN' , 'CN_RECORD_CHANGED');
120: FND_MSG_PUB.Add;
121: END IF;
122: RAISE FND_API.G_EXC_ERROR ;
123: END IF;
124: -- update cn_imp_maps object_version_number for new mapping

Line 166: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

162: -- get source_column_name
163: l_imp_map_field.source_column := p_source_fields(i).value;
164: -- BUG 2399467
165: IF Length(p_source_fields(i).text) > 30 THEN
166: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
167: FND_MESSAGE.SET_NAME ('CN' , 'CN_IMP_MAP_HEADER_TOO_LARGE');
168: FND_MESSAGE.SET_TOKEN('COLUMN_HEADER',p_source_fields(i).text);
169: FND_MSG_PUB.Add;
170: END IF;

Line 169: FND_MSG_PUB.Add;

165: IF Length(p_source_fields(i).text) > 30 THEN
166: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
167: FND_MESSAGE.SET_NAME ('CN' , 'CN_IMP_MAP_HEADER_TOO_LARGE');
168: FND_MESSAGE.SET_TOKEN('COLUMN_HEADER',p_source_fields(i).text);
169: FND_MSG_PUB.Add;
170: END IF;
171: RAISE FND_API.G_EXC_ERROR ;
172: END IF;
173:

Line 200: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

196: )
197: AND o.ORG_ID = p_org_id
198: ;
199: IF l_temp > 0 THEN
200: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
201: THEN
202: FND_MESSAGE.SET_NAME ('CN','CN_IMP_REQFLD_NOT_MAP');
203: FND_MSG_PUB.Add;
204: END IF;

Line 203: FND_MSG_PUB.Add;

199: IF l_temp > 0 THEN
200: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
201: THEN
202: FND_MESSAGE.SET_NAME ('CN','CN_IMP_REQFLD_NOT_MAP');
203: FND_MSG_PUB.Add;
204: END IF;
205: RAISE FND_API.G_EXC_ERROR ;
206: END IF;
207: EXCEPTION

Line 226: FND_MSG_PUB.Count_And_Get(

222: IF FND_API.To_Boolean( p_commit ) THEN
223: COMMIT WORK;
224: END IF;
225: -- Standard call to get message count and if count is 1, get message info.
226: FND_MSG_PUB.Count_And_Get(
227: p_count => x_msg_count ,
228: p_data => x_msg_data ,
229: p_encoded => FND_API.G_FALSE
230: );

Line 236: FND_MSG_PUB.Count_And_Get(

232: EXCEPTION
233: WHEN FND_API.G_EXC_ERROR THEN
234: ROLLBACK TO Create_Mapping ;
235: x_return_status := FND_API.G_RET_STS_ERROR ;
236: FND_MSG_PUB.Count_And_Get(
237: p_count => x_msg_count ,
238: p_data => x_msg_data ,
239: p_encoded => FND_API.G_FALSE
240: );

Line 245: FND_MSG_PUB.Count_And_Get(

241:
242: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
243: ROLLBACK TO Create_Mapping ;
244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
245: FND_MSG_PUB.Count_And_Get(
246: p_count => x_msg_count ,
247: p_data => x_msg_data ,
248: p_encoded => FND_API.G_FALSE
249: );

Line 254: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

250:
251: WHEN OTHERS THEN
252: ROLLBACK TO Create_Mapping ;
253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
254: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
255: THEN
256: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
257: END IF;
258: FND_MSG_PUB.Count_And_Get

Line 256: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

252: ROLLBACK TO Create_Mapping ;
253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
254: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
255: THEN
256: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
257: END IF;
258: FND_MSG_PUB.Count_And_Get
259: (
260: p_count => x_msg_count ,

Line 258: FND_MSG_PUB.Count_And_Get

254: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
255: THEN
256: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
257: END IF;
258: FND_MSG_PUB.Count_And_Get
259: (
260: p_count => x_msg_count ,
261: p_data => x_msg_data ,
262: p_encoded => FND_API.G_FALSE

Line 371: FND_MSG_PUB.initialize;

367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
368: END IF;
369: -- Initialize message list if p_init_msg_list is set to TRUE.
370: IF FND_API.to_Boolean( p_init_msg_list ) THEN
371: FND_MSG_PUB.initialize;
372: END IF;
373: -- Initialize API return status to success
374: x_return_status := FND_API.G_RET_STS_SUCCESS;
375: -- API body

Line 462: FND_MSG_PUB.Count_And_Get(

458: IF FND_API.To_Boolean( p_commit ) THEN
459: COMMIT WORK;
460: END IF;
461: -- Standard call to get message count and if count is 1, get message info.
462: FND_MSG_PUB.Count_And_Get(
463: p_count => x_msg_count ,
464: p_data => x_msg_data ,
465: p_encoded => FND_API.G_FALSE
466: );

Line 472: FND_MSG_PUB.Count_And_Get(

468: EXCEPTION
469: WHEN FND_API.G_EXC_ERROR THEN
470: ROLLBACK TO retrieve_Fields ;
471: x_return_status := FND_API.G_RET_STS_ERROR ;
472: FND_MSG_PUB.Count_And_Get(
473: p_count => x_msg_count ,
474: p_data => x_msg_data ,
475: p_encoded => FND_API.G_FALSE
476: );

Line 481: FND_MSG_PUB.Count_And_Get(

477:
478: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
479: ROLLBACK TO retrieve_Fields ;
480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
481: FND_MSG_PUB.Count_And_Get(
482: p_count => x_msg_count ,
483: p_data => x_msg_data ,
484: p_encoded => FND_API.G_FALSE
485: );

Line 490: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

486:
487: WHEN OTHERS THEN
488: ROLLBACK TO retrieve_Fields ;
489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
490: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
491: THEN
492: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
493: END IF;
494: FND_MSG_PUB.Count_And_Get

Line 492: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

488: ROLLBACK TO retrieve_Fields ;
489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
490: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
491: THEN
492: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
493: END IF;
494: FND_MSG_PUB.Count_And_Get
495: (
496: p_count => x_msg_count ,

Line 494: FND_MSG_PUB.Count_And_Get

490: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
491: THEN
492: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
493: END IF;
494: FND_MSG_PUB.Count_And_Get
495: (
496: p_count => x_msg_count ,
497: p_data => x_msg_data ,
498: p_encoded => FND_API.G_FALSE

Line 557: FND_MSG_PUB.initialize;

553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
554: END IF;
555: -- Initialize message list if p_init_msg_list is set to TRUE.
556: IF FND_API.to_Boolean( p_init_msg_list ) THEN
557: FND_MSG_PUB.initialize;
558: END IF;
559: -- Initialize API return status to success
560: x_return_status := FND_API.G_RET_STS_SUCCESS;
561: -- API body

Line 574: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

570: WHEN no_data_found THEN
571: NULL;
572: END;
573: IF l_temp = 1 THEN
574: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
575: THEN
576: FND_MESSAGE.SET_NAME ('CN','CN_ALREADY_EXISTS');
577: FND_MSG_PUB.Add;
578: END IF;

Line 577: FND_MSG_PUB.Add;

573: IF l_temp = 1 THEN
574: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
575: THEN
576: FND_MESSAGE.SET_NAME ('CN','CN_ALREADY_EXISTS');
577: FND_MSG_PUB.Add;
578: END IF;
579: RAISE FND_API.G_EXC_ERROR ;
580: END IF;
581:

Line 600: FND_MSG_PUB.Count_And_Get(

596: IF FND_API.To_Boolean( p_commit ) THEN
597: COMMIT WORK;
598: END IF;
599: -- Standard call to get message count and if count is 1, get message info.
600: FND_MSG_PUB.Count_And_Get(
601: p_count => x_msg_count ,
602: p_data => x_msg_data ,
603: p_encoded => FND_API.G_FALSE
604: );

Line 610: FND_MSG_PUB.Count_And_Get(

606: EXCEPTION
607: WHEN FND_API.G_EXC_ERROR THEN
608: ROLLBACK TO Create_Imp_map ;
609: x_return_status := FND_API.G_RET_STS_ERROR ;
610: FND_MSG_PUB.Count_And_Get(
611: p_count => x_msg_count ,
612: p_data => x_msg_data ,
613: p_encoded => FND_API.G_FALSE
614: );

Line 619: FND_MSG_PUB.Count_And_Get(

615:
616: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
617: ROLLBACK TO Create_Imp_map ;
618: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
619: FND_MSG_PUB.Count_And_Get(
620: p_count => x_msg_count ,
621: p_data => x_msg_data ,
622: p_encoded => FND_API.G_FALSE
623: );

Line 628: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

624:
625: WHEN OTHERS THEN
626: ROLLBACK TO Create_Imp_map ;
627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
628: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
629: THEN
630: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
631: END IF;
632: FND_MSG_PUB.Count_And_Get

Line 630: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

626: ROLLBACK TO Create_Imp_map ;
627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
628: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
629: THEN
630: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
631: END IF;
632: FND_MSG_PUB.Count_And_Get
633: (
634: p_count => x_msg_count ,

Line 632: FND_MSG_PUB.Count_And_Get

628: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
629: THEN
630: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
631: END IF;
632: FND_MSG_PUB.Count_And_Get
633: (
634: p_count => x_msg_count ,
635: p_data => x_msg_data ,
636: p_encoded => FND_API.G_FALSE

Line 694: FND_MSG_PUB.initialize;

690: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
691: END IF;
692: -- Initialize message list if p_init_msg_list is set to TRUE.
693: IF FND_API.to_Boolean( p_init_msg_list ) THEN
694: FND_MSG_PUB.initialize;
695: END IF;
696: -- Initialize API return status to success
697: x_return_status := FND_API.G_RET_STS_SUCCESS;
698: -- API body

Line 710: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

706: WHERE imp_map_id = p_imp_map.imp_map_id
707: ;
708: EXCEPTION
709: WHEN no_data_found THEN
710: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
711: THEN
712: FND_MESSAGE.SET_NAME ('CN','CN_REC_NOT_EXISTS');
713: FND_MSG_PUB.Add;
714: END IF;

Line 713: FND_MSG_PUB.Add;

709: WHEN no_data_found THEN
710: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
711: THEN
712: FND_MESSAGE.SET_NAME ('CN','CN_REC_NOT_EXISTS');
713: FND_MSG_PUB.Add;
714: END IF;
715: RAISE FND_API.G_EXC_ERROR ;
716: END;
717: -- check locking mechanism

Line 720: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

716: END;
717: -- check locking mechanism
718: IF l_imp_map.object_version_number >
719: p_imp_map.object_version_number THEN
720: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
721: THEN
722: FND_MESSAGE.SET_NAME ('CN' , 'CN_RECORD_CHANGED');
723: FND_MSG_PUB.Add;
724: END IF;

Line 723: FND_MSG_PUB.Add;

719: p_imp_map.object_version_number THEN
720: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
721: THEN
722: FND_MESSAGE.SET_NAME ('CN' , 'CN_RECORD_CHANGED');
723: FND_MSG_PUB.Add;
724: END IF;
725: RAISE FND_API.G_EXC_ERROR ;
726: END IF;
727:

Line 746: FND_MSG_PUB.Count_And_Get(

742: IF FND_API.To_Boolean( p_commit ) THEN
743: COMMIT WORK;
744: END IF;
745: -- Standard call to get message count and if count is 1, get message info.
746: FND_MSG_PUB.Count_And_Get(
747: p_count => x_msg_count ,
748: p_data => x_msg_data ,
749: p_encoded => FND_API.G_FALSE
750: );

Line 756: FND_MSG_PUB.Count_And_Get(

752: EXCEPTION
753: WHEN FND_API.G_EXC_ERROR THEN
754: ROLLBACK TO Delete_Imp_map ;
755: x_return_status := FND_API.G_RET_STS_ERROR ;
756: FND_MSG_PUB.Count_And_Get(
757: p_count => x_msg_count ,
758: p_data => x_msg_data ,
759: p_encoded => FND_API.G_FALSE
760: );

Line 765: FND_MSG_PUB.Count_And_Get(

761:
762: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
763: ROLLBACK TO Delete_Imp_map ;
764: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
765: FND_MSG_PUB.Count_And_Get(
766: p_count => x_msg_count ,
767: p_data => x_msg_data ,
768: p_encoded => FND_API.G_FALSE
769: );

Line 774: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

770:
771: WHEN OTHERS THEN
772: ROLLBACK TO Delete_Imp_map ;
773: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
774: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
775: THEN
776: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
777: END IF;
778: FND_MSG_PUB.Count_And_Get

Line 776: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

772: ROLLBACK TO Delete_Imp_map ;
773: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
774: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
775: THEN
776: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
777: END IF;
778: FND_MSG_PUB.Count_And_Get
779: (
780: p_count => x_msg_count ,

Line 778: FND_MSG_PUB.Count_And_Get

774: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
775: THEN
776: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
777: END IF;
778: FND_MSG_PUB.Count_And_Get
779: (
780: p_count => x_msg_count ,
781: p_data => x_msg_data ,
782: p_encoded => FND_API.G_FALSE