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.BSC_APPS dependencies on BSC_MESSAGE

Line 172: BSC_MESSAGE.Add(x_message => SQLERRM,

168: COMMIT;
169:
170: EXCEPTION
171: WHEN OTHERS THEN
172: BSC_MESSAGE.Add(x_message => SQLERRM,
173: x_source => 'BSC_APPS.Apps_Initialize_VB',
174: x_mode => 'I');
175: COMMIT;
176:

Line 193: FROM bsc_message_logs

189: BEGIN
190:
191: SELECT count(*)
192: INTO h_count
193: FROM bsc_message_logs
194: WHERE type = 0
195: AND UPPER(source) = UPPER(x_calling_function)
196: AND last_update_login = USERENV('SESSIONID');
197:

Line 267: BSC_MESSAGE.Add(x_message => SQLERRM,

263: Do_DDL(x_statement, x_statement_type, x_object_name);
264:
265: EXCEPTION
266: WHEN OTHERS THEN
267: BSC_MESSAGE.Add(x_message => SQLERRM,
268: x_source => 'BSC_APPS.Do_DDL_VB',
269: x_mode => 'I');
270: COMMIT;
271:

Line 334: bsc_messages

330: CURSOR c_message IS
331: SELECT
332: message_text
333: FROM
334: bsc_messages
335: WHERE
336: message_name = x_message_name;
337:
338: h_message VARCHAR2(4000);

Line 546: -- Insert the information in BSC_MESSAGE_LOGS table

542: h_status,
543: h_dev_phase,
544: h_dev_status,
545: h_message) THEN
546: -- Insert the information in BSC_MESSAGE_LOGS table
547: -- type 30 h_phase, type 31 h_status
548: -- type 32 h_dev_phase, type 33 h_dev_status, type 34 h_message
549: IF h_phase IS NOT NULL THEN
550: BSC_MESSAGE.Add(x_message => h_phase,

Line 550: BSC_MESSAGE.Add(x_message => h_phase,

546: -- Insert the information in BSC_MESSAGE_LOGS table
547: -- type 30 h_phase, type 31 h_status
548: -- type 32 h_dev_phase, type 33 h_dev_status, type 34 h_message
549: IF h_phase IS NOT NULL THEN
550: BSC_MESSAGE.Add(x_message => h_phase,
551: x_source => 'BSC_APPS.Get_Request_Status_VB',
552: x_type => 30,
553: x_mode => 'I');
554: END IF;

Line 557: BSC_MESSAGE.Add(x_message => h_status,

553: x_mode => 'I');
554: END IF;
555:
556: IF h_status IS NOT NULL THEN
557: BSC_MESSAGE.Add(x_message => h_status,
558: x_source => 'BSC_APPS.Get_Request_Status_VB',
559: x_type => 31,
560: x_mode => 'I');
561: END IF;

Line 564: BSC_MESSAGE.Add(x_message => h_dev_phase,

560: x_mode => 'I');
561: END IF;
562:
563: IF h_dev_phase IS NOT NULL THEN
564: BSC_MESSAGE.Add(x_message => h_dev_phase,
565: x_source => 'BSC_APPS.Get_Request_Status_VB',
566: x_type => 32,
567: x_mode => 'I');
568: END IF;

Line 571: BSC_MESSAGE.Add(x_message => h_dev_status,

567: x_mode => 'I');
568: END IF;
569:
570: IF h_dev_status IS NOT NULL THEN
571: BSC_MESSAGE.Add(x_message => h_dev_status,
572: x_source => 'BSC_APPS.Get_Request_Status_VB',
573: x_type => 33,
574: x_mode => 'I');
575: END IF;

Line 578: BSC_MESSAGE.Add(x_message => h_message,

574: x_mode => 'I');
575: END IF;
576:
577: IF h_message IS NOT NULL THEN
578: BSC_MESSAGE.Add(x_message => h_message,
579: x_source => 'BSC_APPS.Get_Request_Status_VB',
580: x_type => 34,
581: x_mode => 'I');
582: END IF;

Line 590: BSC_MESSAGE.Add(x_message => SQLERRM,

586: END IF;
587:
588: EXCEPTION
589: WHEN OTHERS THEN
590: BSC_MESSAGE.Add(x_message => SQLERRM,
591: x_source => 'BSC_APPS.Get_Request_Status_VB',
592: x_mode => 'I');
593: COMMIT;
594: END Get_Request_Status_VB;

Line 1267: -- Insert the request_id in BSC_MESSAGE_LOGS table (type = 3, information) to VB program

1263: IF h_request_id = 0 THEN
1264: RAISE e_request_error;
1265: END IF;
1266:
1267: -- Insert the request_id in BSC_MESSAGE_LOGS table (type = 3, information) to VB program
1268: -- be able to get it.
1269:
1270: BSC_MESSAGE.Add(x_message => h_request_id,
1271: x_source => 'BSC_APPS.Submit_Request_VB',

Line 1270: BSC_MESSAGE.Add(x_message => h_request_id,

1266:
1267: -- Insert the request_id in BSC_MESSAGE_LOGS table (type = 3, information) to VB program
1268: -- be able to get it.
1269:
1270: BSC_MESSAGE.Add(x_message => h_request_id,
1271: x_source => 'BSC_APPS.Submit_Request_VB',
1272: x_type => 3,
1273: x_mode => 'I');
1274: COMMIT;

Line 1278: BSC_MESSAGE.Add(x_message => Get_Message('BSC_SUBMMITREQ_FAILED'),

1274: COMMIT;
1275:
1276: EXCEPTION
1277: WHEN e_request_error THEN
1278: BSC_MESSAGE.Add(x_message => Get_Message('BSC_SUBMMITREQ_FAILED'),
1279: x_source => 'BSC_APPS.Submit_Request_VB',
1280: x_mode => 'I');
1281: COMMIT;
1282:

Line 1284: BSC_MESSAGE.Add(x_message => SQLERRM,

1280: x_mode => 'I');
1281: COMMIT;
1282:
1283: WHEN OTHERS THEN
1284: BSC_MESSAGE.Add(x_message => SQLERRM,
1285: x_source => 'BSC_APPS.Submit_Request_VB',
1286: x_mode => 'I');
1287: COMMIT;
1288:

Line 1440: BSC_MESSAGE.Add(x_message => Get_Message('BSC_WAITREQ_FAILED'),

1436: COMMIT;
1437:
1438: EXCEPTION
1439: WHEN e_wait_error THEN
1440: BSC_MESSAGE.Add(x_message => Get_Message('BSC_WAITREQ_FAILED'),
1441: x_source => 'BSC_APPS.Wait_For_Request_VB',
1442: x_mode => 'I');
1443: COMMIT;
1444:

Line 1446: BSC_MESSAGE.Add(x_message => SQLERRM,

1442: x_mode => 'I');
1443: COMMIT;
1444:
1445: WHEN OTHERS THEN
1446: BSC_MESSAGE.Add(x_message => SQLERRM,
1447: x_source => 'BSC_APPS.Wait_For_Request_VB',
1448: x_mode => 'I');
1449: COMMIT;
1450: END Wait_For_Request_VB;

Line 1462: bsc_message_logs

1458: CURSOR c_messages IS
1459: SELECT
1460: message
1461: FROM
1462: bsc_message_logs
1463: WHERE
1464: last_update_login = USERENV('SESSIONID')
1465: ORDER BY
1466: last_update_date;

Line 1468: h_message bsc_message_logs.message%TYPE;

1464: last_update_login = USERENV('SESSIONID')
1465: ORDER BY
1466: last_update_date;
1467:
1468: h_message bsc_message_logs.message%TYPE;
1469:
1470: BEGIN
1471: OPEN c_messages;
1472: FETCH c_messages INTO h_message;

Line 1776: | FUNCTION Get_Bsc_Message

1772: END LOOP;
1773: END Do_DDL_AT;
1774:
1775: /*===========================================================================+
1776: | FUNCTION Get_Bsc_Message
1777: +============================================================================*/
1778: FUNCTION Get_Bsc_Message
1779: ( p_Message_Name IN VARCHAR2,
1780: p_Token_Names IN VARCHAR2,

Line 1778: FUNCTION Get_Bsc_Message

1774:
1775: /*===========================================================================+
1776: | FUNCTION Get_Bsc_Message
1777: +============================================================================*/
1778: FUNCTION Get_Bsc_Message
1779: ( p_Message_Name IN VARCHAR2,
1780: p_Token_Names IN VARCHAR2,
1781: p_Lookup_Codes IN VARCHAR2,
1782: p_Lookup_Types IN VARCHAR2

Line 1826: END Get_Bsc_Message;

1822: , p_count => l_msg_count
1823: , p_data => l_msg_data
1824: );
1825: RETURN l_msg_data;
1826: END Get_Bsc_Message;
1827:
1828: END BSC_APPS;