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.FND_GSM_UTIL dependencies on FND_MESSAGE

Line 17: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

13: procedure GENERIC_ERROR(routine in varchar2,
14: errcode in number,
15: errmsg in varchar2) is
16: begin
17: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
18: fnd_message.set_token('ROUTINE', routine);
19: fnd_message.set_token('ERRNO', errcode);
20: fnd_message.set_token('REASON', errmsg);
21: end;

Line 18: fnd_message.set_token('ROUTINE', routine);

14: errcode in number,
15: errmsg in varchar2) is
16: begin
17: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
18: fnd_message.set_token('ROUTINE', routine);
19: fnd_message.set_token('ERRNO', errcode);
20: fnd_message.set_token('REASON', errmsg);
21: end;
22:

Line 19: fnd_message.set_token('ERRNO', errcode);

15: errmsg in varchar2) is
16: begin
17: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
18: fnd_message.set_token('ROUTINE', routine);
19: fnd_message.set_token('ERRNO', errcode);
20: fnd_message.set_token('REASON', errmsg);
21: end;
22:
23: /* returns TRUE if FND_DATABASES table exists else FALSE */

Line 20: fnd_message.set_token('REASON', errmsg);

16: begin
17: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
18: fnd_message.set_token('ROUTINE', routine);
19: fnd_message.set_token('ERRNO', errcode);
20: fnd_message.set_token('REASON', errmsg);
21: end;
22:
23: /* returns TRUE if FND_DATABASES table exists else FALSE */
24: function db_model_exists return boolean is

Line 86: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

82: end if;
83:
84: exception
85: when others then
86: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
87: fnd_message.set_token('ROUTINE', 'FND_GSM_UTIL.APPEND_CTX_FRAGMENT');
88: fnd_message.set_token('ERRNO', SQLCODE);
89: fnd_message.set_token('REASON', SQLERRM);
90: message := fnd_message.get;

Line 87: fnd_message.set_token('ROUTINE', 'FND_GSM_UTIL.APPEND_CTX_FRAGMENT');

83:
84: exception
85: when others then
86: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
87: fnd_message.set_token('ROUTINE', 'FND_GSM_UTIL.APPEND_CTX_FRAGMENT');
88: fnd_message.set_token('ERRNO', SQLCODE);
89: fnd_message.set_token('REASON', SQLERRM);
90: message := fnd_message.get;
91: retcode := 1;

Line 88: fnd_message.set_token('ERRNO', SQLCODE);

84: exception
85: when others then
86: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
87: fnd_message.set_token('ROUTINE', 'FND_GSM_UTIL.APPEND_CTX_FRAGMENT');
88: fnd_message.set_token('ERRNO', SQLCODE);
89: fnd_message.set_token('REASON', SQLERRM);
90: message := fnd_message.get;
91: retcode := 1;
92:

Line 89: fnd_message.set_token('REASON', SQLERRM);

85: when others then
86: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
87: fnd_message.set_token('ROUTINE', 'FND_GSM_UTIL.APPEND_CTX_FRAGMENT');
88: fnd_message.set_token('ERRNO', SQLCODE);
89: fnd_message.set_token('REASON', SQLERRM);
90: message := fnd_message.get;
91: retcode := 1;
92:
93: end append_ctx_fragment;

Line 90: message := fnd_message.get;

86: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
87: fnd_message.set_token('ROUTINE', 'FND_GSM_UTIL.APPEND_CTX_FRAGMENT');
88: fnd_message.set_token('ERRNO', SQLCODE);
89: fnd_message.set_token('REASON', SQLERRM);
90: message := fnd_message.get;
91: retcode := 1;
92:
93: end append_ctx_fragment;
94:

Line 1043: fnd_message.set_name('FND', message_name);

1039:
1040: when no_data_found then
1041: /* The service is not registered with GSM */
1042: /* Do the registration now. */
1043: fnd_message.set_name('FND', message_name);
1044: fnd_message.set_token('NODE', primary_node);
1045: fnd_message.set_token('PORT', port);
1046: service_name := substrb(fnd_message.get, 1, 240);
1047:

Line 1044: fnd_message.set_token('NODE', primary_node);

1040: when no_data_found then
1041: /* The service is not registered with GSM */
1042: /* Do the registration now. */
1043: fnd_message.set_name('FND', message_name);
1044: fnd_message.set_token('NODE', primary_node);
1045: fnd_message.set_token('PORT', port);
1046: service_name := substrb(fnd_message.get, 1, 240);
1047:
1048: begin

Line 1045: fnd_message.set_token('PORT', port);

1041: /* The service is not registered with GSM */
1042: /* Do the registration now. */
1043: fnd_message.set_name('FND', message_name);
1044: fnd_message.set_token('NODE', primary_node);
1045: fnd_message.set_token('PORT', port);
1046: service_name := substrb(fnd_message.get, 1, 240);
1047:
1048: begin
1049: fnd_manager.register_si(manager => service_name,

Line 1046: service_name := substrb(fnd_message.get, 1, 240);

1042: /* Do the registration now. */
1043: fnd_message.set_name('FND', message_name);
1044: fnd_message.set_token('NODE', primary_node);
1045: fnd_message.set_token('PORT', port);
1046: service_name := substrb(fnd_message.get, 1, 240);
1047:
1048: begin
1049: fnd_manager.register_si(manager => service_name,
1050: application => 'FND',

Line 1090: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

1086: retcode := 1;
1087: return;
1088:
1089: when others then
1090: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1091: fnd_message.set_token('ROUTINE',
1092: 'FND_GSM_UTIL.upload_context_file');
1093: fnd_message.set_token('ERRNO', SQLCODE);
1094: fnd_message.set_token('REASON', SQLERRM);

Line 1091: fnd_message.set_token('ROUTINE',

1087: return;
1088:
1089: when others then
1090: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1091: fnd_message.set_token('ROUTINE',
1092: 'FND_GSM_UTIL.upload_context_file');
1093: fnd_message.set_token('ERRNO', SQLCODE);
1094: fnd_message.set_token('REASON', SQLERRM);
1095: message := fnd_message.get;

Line 1093: fnd_message.set_token('ERRNO', SQLCODE);

1089: when others then
1090: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1091: fnd_message.set_token('ROUTINE',
1092: 'FND_GSM_UTIL.upload_context_file');
1093: fnd_message.set_token('ERRNO', SQLCODE);
1094: fnd_message.set_token('REASON', SQLERRM);
1095: message := fnd_message.get;
1096:
1097: if (not xmldom.isNull(my_doc)) then

Line 1094: fnd_message.set_token('REASON', SQLERRM);

1090: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1091: fnd_message.set_token('ROUTINE',
1092: 'FND_GSM_UTIL.upload_context_file');
1093: fnd_message.set_token('ERRNO', SQLCODE);
1094: fnd_message.set_token('REASON', SQLERRM);
1095: message := fnd_message.get;
1096:
1097: if (not xmldom.isNull(my_doc)) then
1098: xmldom.freeDocument (my_doc);

Line 1095: message := fnd_message.get;

1091: fnd_message.set_token('ROUTINE',
1092: 'FND_GSM_UTIL.upload_context_file');
1093: fnd_message.set_token('ERRNO', SQLCODE);
1094: fnd_message.set_token('REASON', SQLERRM);
1095: message := fnd_message.get;
1096:
1097: if (not xmldom.isNull(my_doc)) then
1098: xmldom.freeDocument (my_doc);
1099: end if;

Line 1139: fnd_message.set_name('FND', 'GSM-CTX NULL CONTEXT');

1135:
1136: retcode := 0;
1137:
1138: when null_context_name then
1139: fnd_message.set_name('FND', 'GSM-CTX NULL CONTEXT');
1140: fnd_message.set_token('FILE', filepath);
1141: message := fnd_message.get;
1142:
1143: if (not xmldom.isNull(my_doc)) then

Line 1140: fnd_message.set_token('FILE', filepath);

1136: retcode := 0;
1137:
1138: when null_context_name then
1139: fnd_message.set_name('FND', 'GSM-CTX NULL CONTEXT');
1140: fnd_message.set_token('FILE', filepath);
1141: message := fnd_message.get;
1142:
1143: if (not xmldom.isNull(my_doc)) then
1144: xmldom.freeDocument (my_doc);

Line 1141: message := fnd_message.get;

1137:
1138: when null_context_name then
1139: fnd_message.set_name('FND', 'GSM-CTX NULL CONTEXT');
1140: fnd_message.set_token('FILE', filepath);
1141: message := fnd_message.get;
1142:
1143: if (not xmldom.isNull(my_doc)) then
1144: xmldom.freeDocument (my_doc);
1145: end if;

Line 1151: fnd_message.set_name('FND', 'GSM-CTX FILE SYS COPY LOW');

1147:
1148: retcode := 1;
1149:
1150: when filesys_low_ver then
1151: fnd_message.set_name('FND', 'GSM-CTX FILE SYS COPY LOW');
1152: fnd_message.set_token('FILE', filepath);
1153: message := fnd_message.get;
1154:
1155: if (not xmldom.isNull(my_doc)) then

Line 1152: fnd_message.set_token('FILE', filepath);

1148: retcode := 1;
1149:
1150: when filesys_low_ver then
1151: fnd_message.set_name('FND', 'GSM-CTX FILE SYS COPY LOW');
1152: fnd_message.set_token('FILE', filepath);
1153: message := fnd_message.get;
1154:
1155: if (not xmldom.isNull(my_doc)) then
1156: xmldom.freeDocument (my_doc);

Line 1153: message := fnd_message.get;

1149:
1150: when filesys_low_ver then
1151: fnd_message.set_name('FND', 'GSM-CTX FILE SYS COPY LOW');
1152: fnd_message.set_token('FILE', filepath);
1153: message := fnd_message.get;
1154:
1155: if (not xmldom.isNull(my_doc)) then
1156: xmldom.freeDocument (my_doc);
1157: end if;

Line 1163: fnd_message.set_name('FND', 'GSM-CTX ELEMENT MISSING');

1159:
1160: retcode := 1;
1161:
1162: when missing_elem then
1163: fnd_message.set_name('FND', 'GSM-CTX ELEMENT MISSING');
1164: fnd_message.set_token('ELEMENT', element_name);
1165: fnd_message.set_token('FILE', filepath);
1166: message := fnd_message.get;
1167:

Line 1164: fnd_message.set_token('ELEMENT', element_name);

1160: retcode := 1;
1161:
1162: when missing_elem then
1163: fnd_message.set_name('FND', 'GSM-CTX ELEMENT MISSING');
1164: fnd_message.set_token('ELEMENT', element_name);
1165: fnd_message.set_token('FILE', filepath);
1166: message := fnd_message.get;
1167:
1168: if (not xmldom.isNull(my_doc)) then

Line 1165: fnd_message.set_token('FILE', filepath);

1161:
1162: when missing_elem then
1163: fnd_message.set_name('FND', 'GSM-CTX ELEMENT MISSING');
1164: fnd_message.set_token('ELEMENT', element_name);
1165: fnd_message.set_token('FILE', filepath);
1166: message := fnd_message.get;
1167:
1168: if (not xmldom.isNull(my_doc)) then
1169: xmldom.freeDocument (my_doc);

Line 1166: message := fnd_message.get;

1162: when missing_elem then
1163: fnd_message.set_name('FND', 'GSM-CTX ELEMENT MISSING');
1164: fnd_message.set_token('ELEMENT', element_name);
1165: fnd_message.set_token('FILE', filepath);
1166: message := fnd_message.get;
1167:
1168: if (not xmldom.isNull(my_doc)) then
1169: xmldom.freeDocument (my_doc);
1170: end if;

Line 1176: fnd_message.set_name('FND', 'GSM-CTX NODE NAME TOO LONG');

1172:
1173: retcode := 1;
1174:
1175: when exceeded_length then
1176: fnd_message.set_name('FND', 'GSM-CTX NODE NAME TOO LONG');
1177: fnd_message.set_token('NODE_NAME', tmp_node_name);
1178: message := fnd_message.get;
1179:
1180: if (not xmldom.isNull(my_doc)) then

Line 1177: fnd_message.set_token('NODE_NAME', tmp_node_name);

1173: retcode := 1;
1174:
1175: when exceeded_length then
1176: fnd_message.set_name('FND', 'GSM-CTX NODE NAME TOO LONG');
1177: fnd_message.set_token('NODE_NAME', tmp_node_name);
1178: message := fnd_message.get;
1179:
1180: if (not xmldom.isNull(my_doc)) then
1181: xmldom.freeDocument (my_doc);

Line 1178: message := fnd_message.get;

1174:
1175: when exceeded_length then
1176: fnd_message.set_name('FND', 'GSM-CTX NODE NAME TOO LONG');
1177: fnd_message.set_token('NODE_NAME', tmp_node_name);
1178: message := fnd_message.get;
1179:
1180: if (not xmldom.isNull(my_doc)) then
1181: xmldom.freeDocument (my_doc);
1182: end if;

Line 1188: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

1184:
1185: retcode := 1;
1186:
1187: when others then
1188: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1189: fnd_message.set_token('ROUTINE', 'FND_GSM_UTIL.upload_context_file');
1190: fnd_message.set_token('ERRNO', SQLCODE);
1191: fnd_message.set_token('REASON', SQLERRM);
1192: message := fnd_message.get;

Line 1189: fnd_message.set_token('ROUTINE', 'FND_GSM_UTIL.upload_context_file');

1185: retcode := 1;
1186:
1187: when others then
1188: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1189: fnd_message.set_token('ROUTINE', 'FND_GSM_UTIL.upload_context_file');
1190: fnd_message.set_token('ERRNO', SQLCODE);
1191: fnd_message.set_token('REASON', SQLERRM);
1192: message := fnd_message.get;
1193:

Line 1190: fnd_message.set_token('ERRNO', SQLCODE);

1186:
1187: when others then
1188: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1189: fnd_message.set_token('ROUTINE', 'FND_GSM_UTIL.upload_context_file');
1190: fnd_message.set_token('ERRNO', SQLCODE);
1191: fnd_message.set_token('REASON', SQLERRM);
1192: message := fnd_message.get;
1193:
1194: if (not xmldom.isNull(my_doc)) then

Line 1191: fnd_message.set_token('REASON', SQLERRM);

1187: when others then
1188: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1189: fnd_message.set_token('ROUTINE', 'FND_GSM_UTIL.upload_context_file');
1190: fnd_message.set_token('ERRNO', SQLCODE);
1191: fnd_message.set_token('REASON', SQLERRM);
1192: message := fnd_message.get;
1193:
1194: if (not xmldom.isNull(my_doc)) then
1195: xmldom.freeDocument (my_doc);

Line 1192: message := fnd_message.get;

1188: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1189: fnd_message.set_token('ROUTINE', 'FND_GSM_UTIL.upload_context_file');
1190: fnd_message.set_token('ERRNO', SQLCODE);
1191: fnd_message.set_token('REASON', SQLERRM);
1192: message := fnd_message.get;
1193:
1194: if (not xmldom.isNull(my_doc)) then
1195: xmldom.freeDocument (my_doc);
1196: end if;