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_IMPORT_PVT dependencies on FND_MSG_PUB

Line 101: FND_MSG_PUB.initialize;

97: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
98: END IF;
99: -- Initialize message list if p_init_msg_list is set to TRUE.
100: IF FND_API.to_Boolean( p_init_msg_list ) THEN
101: FND_MSG_PUB.initialize;
102: END IF;
103: -- Initialize API return status to success
104: x_return_status := FND_API.G_RET_STS_SUCCESS;
105: -- API body

Line 223: FND_MSG_PUB.count_and_get

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

Line 234: FND_MSG_PUB.Count_And_Get(

230: WHEN FND_API.G_EXC_ERROR THEN
231: ROLLBACK TO Import_Data ;
232: x_return_status := FND_API.G_RET_STS_ERROR ;
233: cn_message_pkg.end_batch(l_process_audit_id);
234: FND_MSG_PUB.Count_And_Get(
235: p_count => x_msg_count ,
236: p_data => x_msg_data ,
237: p_encoded => FND_API.G_FALSE
238: );

Line 244: FND_MSG_PUB.Count_And_Get(

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

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

251: ROLLBACK TO Import_Data ;
252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
253: cn_message_pkg.set_error(l_api_name,'Unexpected error');
254: cn_message_pkg.end_batch(l_process_audit_id);
255: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
256: THEN
257: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
258: END IF;
259: FND_MSG_PUB.Count_And_Get

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

253: cn_message_pkg.set_error(l_api_name,'Unexpected error');
254: cn_message_pkg.end_batch(l_process_audit_id);
255: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
256: THEN
257: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
258: END IF;
259: FND_MSG_PUB.Count_And_Get
260: (
261: p_count => x_msg_count ,

Line 259: FND_MSG_PUB.Count_And_Get

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

Line 311: FND_MSG_PUB.initialize;

307: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
308: END IF;
309: -- Initialize message list if p_init_msg_list is set to TRUE.
310: IF FND_API.to_Boolean( p_init_msg_list ) THEN
311: FND_MSG_PUB.initialize;
312: END IF;
313: -- Initialize API return status to success
314: x_return_status := FND_API.G_RET_STS_SUCCESS;
315: -- API body

Line 401: FND_MSG_PUB.count_and_get

397: IF FND_API.To_Boolean( p_commit ) THEN
398: COMMIT WORK;
399: END IF;
400: -- Standard call to get message count and if count is 1, get message info.
401: FND_MSG_PUB.count_and_get
402: (p_count => x_msg_count ,
403: p_data => x_msg_data ,
404: p_encoded => FND_API.G_FALSE
405: );

Line 412: FND_MSG_PUB.Count_And_Get(

408: WHEN FND_API.G_EXC_ERROR THEN
409: ROLLBACK TO Export_Data ;
410: x_return_status := FND_API.G_RET_STS_ERROR ;
411: cn_message_pkg.end_batch(l_process_audit_id);
412: FND_MSG_PUB.Count_And_Get(
413: p_count => x_msg_count ,
414: p_data => x_msg_data ,
415: p_encoded => FND_API.G_FALSE
416: );

Line 422: FND_MSG_PUB.Count_And_Get(

418: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
419: ROLLBACK TO Export_Data ;
420: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
421: cn_message_pkg.end_batch(l_process_audit_id);
422: FND_MSG_PUB.Count_And_Get(
423: p_count => x_msg_count ,
424: p_data => x_msg_data ,
425: p_encoded => FND_API.G_FALSE
426: );

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

429: ROLLBACK TO Export_Data ;
430: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
431: cn_message_pkg.set_error(l_api_name,'Unexpected error');
432: cn_message_pkg.end_batch(l_process_audit_id);
433: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
434: THEN
435: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
436: END IF;
437: FND_MSG_PUB.Count_And_Get

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

431: cn_message_pkg.set_error(l_api_name,'Unexpected error');
432: cn_message_pkg.end_batch(l_process_audit_id);
433: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
434: THEN
435: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
436: END IF;
437: FND_MSG_PUB.Count_And_Get
438: (
439: p_count => x_msg_count ,

Line 437: FND_MSG_PUB.Count_And_Get

433: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
434: THEN
435: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
436: END IF;
437: FND_MSG_PUB.Count_And_Get
438: (
439: p_count => x_msg_count ,
440: p_data => x_msg_data ,
441: p_encoded => FND_API.G_FALSE

Line 689: FND_MSG_PUB.Count_And_Get(

685: update_imp_headers
686: (p_imp_header_id => p_imp_header_id,
687: p_status_code => 'STAGE_FAIL');
688: cn_message_pkg.end_batch(l_process_audit_id);
689: FND_MSG_PUB.Count_And_Get(
690: p_count => l_msg_count ,
691: p_data => errbuf ,
692: p_encoded => FND_API.G_FALSE
693: );

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

701: retcode := 2 ;
702: errbuf := fnd_program.message;
703: ELSE
704: retcode := 2 ;
705: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
706: THEN
707: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
708: END IF;
709: FND_MSG_PUB.count_and_get

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

703: ELSE
704: retcode := 2 ;
705: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
706: THEN
707: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
708: END IF;
709: FND_MSG_PUB.count_and_get
710: (p_count => l_msg_count ,
711: p_data => errbuf ,

Line 709: FND_MSG_PUB.count_and_get

705: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
706: THEN
707: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
708: END IF;
709: FND_MSG_PUB.count_and_get
710: (p_count => l_msg_count ,
711: p_data => errbuf ,
712: p_encoded => FND_API.G_FALSE
713: );

Line 880: FND_MSG_PUB.Count_And_Get(

876: update_imp_headers
877: (p_imp_header_id => p_imp_header_id,
878: p_status_code => 'IMPORT_FAIL');
879: cn_message_pkg.end_batch(l_process_audit_id);
880: FND_MSG_PUB.Count_And_Get(
881: p_count => l_msg_count ,
882: p_data => errbuf ,
883: p_encoded => FND_API.G_FALSE
884: );

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

892: retcode := 2 ;
893: errbuf := fnd_program.message;
894: ELSE
895: retcode := 2 ;
896: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
897: THEN
898: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
899: END IF;
900: FND_MSG_PUB.count_and_get

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

894: ELSE
895: retcode := 2 ;
896: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
897: THEN
898: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
899: END IF;
900: FND_MSG_PUB.count_and_get
901: (p_count => l_msg_count ,
902: p_data => errbuf ,

Line 900: FND_MSG_PUB.count_and_get

896: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
897: THEN
898: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
899: END IF;
900: FND_MSG_PUB.count_and_get
901: (p_count => l_msg_count ,
902: p_data => errbuf ,
903: p_encoded => FND_API.G_FALSE
904: );

Line 993: FND_MSG_PUB.initialize;

989: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
990: END IF;
991: -- Initialize message list if p_init_msg_list is set to TRUE.
992: IF FND_API.to_Boolean( p_init_msg_list ) THEN
993: FND_MSG_PUB.initialize;
994: END IF;
995: -- Initialize API return status to success
996: x_return_status := FND_API.G_RET_STS_SUCCESS;
997: -- API body

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

1037: -- for each mapped column
1038: FOR c_tar_col IN c_tar_col_cv(l_imp_header.imp_map_id) LOOP
1039: -- check if mapping is updated by other user
1040: IF c_tar_col.map_obj_ver <> p_map_obj_ver THEN
1041: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1042: THEN
1043: FND_MESSAGE.SET_NAME ('CN' , 'CN_IMP_MAPPED_CHANGED');
1044: FND_MSG_PUB.Add;
1045: END IF;

Line 1044: FND_MSG_PUB.Add;

1040: IF c_tar_col.map_obj_ver <> p_map_obj_ver THEN
1041: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1042: THEN
1043: FND_MESSAGE.SET_NAME ('CN' , 'CN_IMP_MAPPED_CHANGED');
1044: FND_MSG_PUB.Add;
1045: END IF;
1046: cn_message_pkg.write
1047: (p_message_text => fnd_message.get_string('CN','CN_IMP_MAPPED_CHANGED'),
1048: p_message_type => 'ERROR');

Line 1113: FND_MSG_PUB.count_and_get

1109: IF FND_API.To_Boolean( p_commit ) THEN
1110: COMMIT WORK;
1111: END IF;
1112: -- Standard call to get message count and if count is 1, get message info.
1113: FND_MSG_PUB.count_and_get
1114: (p_count => x_msg_count ,
1115: p_data => x_msg_data ,
1116: p_encoded => FND_API.G_FALSE
1117: );

Line 1127: FND_MSG_PUB.Count_And_Get(

1123: (p_imp_header_id => p_imp_header_id,
1124: p_status_code => 'STAGE_FAIL');
1125: x_return_status := FND_API.G_RET_STS_ERROR ;
1126: cn_message_pkg.end_batch(l_process_audit_id);
1127: FND_MSG_PUB.Count_And_Get(
1128: p_count => x_msg_count ,
1129: p_data => x_msg_data ,
1130: p_encoded => FND_API.G_FALSE
1131: );

Line 1140: FND_MSG_PUB.Count_And_Get(

1136: (p_imp_header_id => p_imp_header_id,
1137: p_status_code => 'STAGE_FAIL');
1138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1139: cn_message_pkg.end_batch(l_process_audit_id);
1140: FND_MSG_PUB.Count_And_Get(
1141: p_count => x_msg_count ,
1142: p_data => x_msg_data ,
1143: p_encoded => FND_API.G_FALSE
1144: );

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

1150: p_status_code => 'STAGE_FAIL');
1151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1152: cn_message_pkg.set_error(l_api_name,'Unexpected Error');
1153: cn_message_pkg.end_batch(l_process_audit_id);
1154: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1155: THEN
1156: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1157: END IF;
1158: FND_MSG_PUB.Count_And_Get

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

1152: cn_message_pkg.set_error(l_api_name,'Unexpected Error');
1153: cn_message_pkg.end_batch(l_process_audit_id);
1154: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1155: THEN
1156: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1157: END IF;
1158: FND_MSG_PUB.Count_And_Get
1159: (
1160: p_count => x_msg_count ,

Line 1158: FND_MSG_PUB.Count_And_Get

1154: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1155: THEN
1156: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1157: END IF;
1158: FND_MSG_PUB.Count_And_Get
1159: (
1160: p_count => x_msg_count ,
1161: p_data => x_msg_data ,
1162: p_encoded => FND_API.G_FALSE