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.IEM_OUTBOX_PROC_PUB dependencies on IEM_MSG_PARTS

Line 918: select count(REF_KEY) into l_sequence from IEM_MSG_PARTS where REF_KEY = p_outbox_item_id and PART_TYPE = 'HTMLTEXT';

914: end if;
915:
916: x_return_status := fnd_api.g_ret_sts_success;
917:
918: select count(REF_KEY) into l_sequence from IEM_MSG_PARTS where REF_KEY = p_outbox_item_id and PART_TYPE = 'HTMLTEXT';
919: l_sequence := l_sequence + 1;
920:
921: insert into IEM_MSG_PARTS
922: (

Line 921: insert into IEM_MSG_PARTS

917:
918: select count(REF_KEY) into l_sequence from IEM_MSG_PARTS where REF_KEY = p_outbox_item_id and PART_TYPE = 'HTMLTEXT';
919: l_sequence := l_sequence + 1;
920:
921: insert into IEM_MSG_PARTS
922: (
923: REF_KEY,
924: PART_TYPE,
925: PART_NAME,

Line 940: update IEM_MSG_PARTS set PART_DATA = p_text where REF_KEY = p_outbox_item_id and PART_TYPE = 'HTMLTEXT' and PART_NAME = l_sequence;

936: 'N',
937: SYSDATE
938: );
939:
940: update IEM_MSG_PARTS set PART_DATA = p_text where REF_KEY = p_outbox_item_id and PART_TYPE = 'HTMLTEXT' and PART_NAME = l_sequence;
941:
942: -- Standard check of p_commit
943: IF FND_API.To_Boolean(p_commit) THEN
944: COMMIT WORK;

Line 955: ROLLBACK TO IEM_MSG_PARTS;

951: );
952:
953: EXCEPTION
954: WHEN FND_API.G_EXC_ERROR THEN
955: ROLLBACK TO IEM_MSG_PARTS;
956:
957: x_return_status := FND_API.G_RET_STS_ERROR;
958: FND_MSG_PUB.Count_And_Get(
959: p_count => x_msg_count,

Line 970: ROLLBACK TO IEM_MSG_PARTS;

966: x_msg_data := x_msg_data || ',' || l_msg_data;
967: END LOOP;
968:
969: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
970: ROLLBACK TO IEM_MSG_PARTS;
971: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
972: FND_MSG_PUB.Count_And_Get
973: (
974: p_count => x_msg_count,

Line 984: ROLLBACK TO IEM_MSG_PARTS;

980: x_msg_data := x_msg_data || ',' || l_msg_data;
981: END LOOP;
982:
983: WHEN OTHERS THEN
984: ROLLBACK TO IEM_MSG_PARTS;
985: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
986:
987: FND_MSG_PUB.Count_And_Get (
988: p_count => x_msg_count,

Line 1039: select count(REF_KEY) into l_sequence from IEM_MSG_PARTS where REF_KEY = p_outbox_item_id and PART_TYPE = 'HTMLTEXT';

1035: x_return_status := fnd_api.g_ret_sts_success;
1036:
1037: l_part_info := '__DOC__:'||p_document_id||'@'||p_document_source;
1038:
1039: select count(REF_KEY) into l_sequence from IEM_MSG_PARTS where REF_KEY = p_outbox_item_id and PART_TYPE = 'HTMLTEXT';
1040: l_sequence := l_sequence + 1;
1041:
1042: insert into IEM_MSG_PARTS
1043: (

Line 1042: insert into IEM_MSG_PARTS

1038:
1039: select count(REF_KEY) into l_sequence from IEM_MSG_PARTS where REF_KEY = p_outbox_item_id and PART_TYPE = 'HTMLTEXT';
1040: l_sequence := l_sequence + 1;
1041:
1042: insert into IEM_MSG_PARTS
1043: (
1044: REF_KEY,
1045: PART_TYPE,
1046: PART_NAME,

Line 1076: ROLLBACK TO IEM_MSG_PARTS;

1072: );
1073:
1074: EXCEPTION
1075: WHEN FND_API.G_EXC_ERROR THEN
1076: ROLLBACK TO IEM_MSG_PARTS;
1077:
1078: x_return_status := FND_API.G_RET_STS_ERROR;
1079: FND_MSG_PUB.Count_And_Get(
1080: p_count => x_msg_count,

Line 1091: ROLLBACK TO IEM_MSG_PARTS;

1087: x_msg_data := x_msg_data || ',' || l_msg_data;
1088: END LOOP;
1089:
1090: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1091: ROLLBACK TO IEM_MSG_PARTS;
1092: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1093: FND_MSG_PUB.Count_And_Get
1094: (
1095: p_count => x_msg_count,

Line 1106: ROLLBACK TO IEM_MSG_PARTS;

1102: END LOOP;
1103:
1104:
1105: WHEN OTHERS THEN
1106: ROLLBACK TO IEM_MSG_PARTS;
1107: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1108:
1109: FND_MSG_PUB.Count_And_Get (
1110: p_count => x_msg_count,

Line 1162: insert into IEM_MSG_PARTS

1158: x_return_status := fnd_api.g_ret_sts_success;
1159:
1160: IF (p_document_source = 'BINARY')
1161: THEN
1162: insert into IEM_MSG_PARTS
1163: (
1164: REF_KEY,
1165: PART_TYPE,
1166: PART_NAME,

Line 1183: update IEM_MSG_PARTS set PART_DATA = p_binary_source where REF_KEY = p_outbox_item_id and PART_TYPE = 'ATTACHMENT' and PART_NAME = p_attachment_name;

1179: 'N',
1180: SYSDATE
1181: );
1182:
1183: update IEM_MSG_PARTS set PART_DATA = p_binary_source where REF_KEY = p_outbox_item_id and PART_TYPE = 'ATTACHMENT' and PART_NAME = p_attachment_name;
1184:
1185: ELSE
1186: l_part_info := '__DOC__:'||p_document_id||'@'||p_document_source;
1187:

Line 1188: insert into IEM_MSG_PARTS

1184:
1185: ELSE
1186: l_part_info := '__DOC__:'||p_document_id||'@'||p_document_source;
1187:
1188: insert into IEM_MSG_PARTS
1189: (
1190: REF_KEY,
1191: PART_TYPE,
1192: PART_NAME,

Line 1223: ROLLBACK TO IEM_MSG_PARTS;

1219: );
1220:
1221: EXCEPTION
1222: WHEN FND_API.G_EXC_ERROR THEN
1223: ROLLBACK TO IEM_MSG_PARTS;
1224:
1225: x_return_status := FND_API.G_RET_STS_ERROR;
1226: FND_MSG_PUB.Count_And_Get(
1227: p_count => x_msg_count,

Line 1238: ROLLBACK TO IEM_MSG_PARTS;

1234: x_msg_data := x_msg_data || ',' || l_msg_data;
1235: END LOOP;
1236:
1237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1238: ROLLBACK TO IEM_MSG_PARTS;
1239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1240: FND_MSG_PUB.Count_And_Get
1241: (
1242: p_count => x_msg_count,

Line 1252: ROLLBACK TO IEM_MSG_PARTS;

1248: x_msg_data := x_msg_data || ',' || l_msg_data;
1249: END LOOP;
1250:
1251: WHEN OTHERS THEN
1252: ROLLBACK TO IEM_MSG_PARTS;
1253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1254:
1255: FND_MSG_PUB.Count_And_Get (
1256: p_count => x_msg_count,