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

Line 97: FND_MSG_PUB.Initialize;

93:
94: CASE p_init_msg_list
95: WHEN c_false THEN NULL;
96: WHEN c_true THEN
97: FND_MSG_PUB.Initialize;
98: ELSE RAISE e_bad_p_init_msg_list;
99: END CASE;
100:
101: CASE p_encoded

Line 375: FND_MSG_PUB.Count_and_Get(

371: p_msg_name => 'FEM_DB_BAD_SYNONYM_ERR',
372: p_token1 => 'SYN_NAME',
373: p_value1 => p_syn_name);
374:
375: FND_MSG_PUB.Count_and_Get(
376: p_encoded => p_encoded,
377: p_count => x_msg_count,
378: p_data => x_msg_data);
379:

Line 412: -- Tells whether or not to initialize the FND_MSG_PUB message stack by

408: -- Optional OA-compliance parameter.
409: -- Default is 1.0 (and this is currently the only acceptable value).
410: -- p_init_msg_list
411: -- Optional OA-compliance flag parameter.
412: -- Tells whether or not to initialize the FND_MSG_PUB message stack by
413: -- calling FND_MSG_PUB.Initialize.
414: -- Valid values are 'T' and 'F'; default is 'F'.
415: -- p_commit:
416: -- Optional OA-compliance flag parameter. Valid values are 'T' and 'F'.

Line 413: -- calling FND_MSG_PUB.Initialize.

409: -- Default is 1.0 (and this is currently the only acceptable value).
410: -- p_init_msg_list
411: -- Optional OA-compliance flag parameter.
412: -- Tells whether or not to initialize the FND_MSG_PUB message stack by
413: -- calling FND_MSG_PUB.Initialize.
414: -- Valid values are 'T' and 'F'; default is 'F'.
415: -- p_commit:
416: -- Optional OA-compliance flag parameter. Valid values are 'T' and 'F'.
417: -- Note that this procedure is read-only, there is nothing to commit,

Line 421: -- Passed to FND_MSG_PUB.Count_and_Get to determine the format of any

417: -- Note that this procedure is read-only, there is nothing to commit,
418: -- so this parameter is not used.
419: -- p_encoded:
420: -- Optional OA-compliance flag parameter.
421: -- Passed to FND_MSG_PUB.Count_and_Get to determine the format of any
422: -- message passed back in x_msg_data.
423: -- Valid values are 'T' and 'F'; default is 'T'.
424: -- x_return_status:
425: -- OA-compliance OUT parameter. This procedure returns 'S' for

Line 430: -- on the FND_MSG_PUB message stack. If x_msg_count = 1, the message

426: -- success, 'E' for error in any of the values passed to the optional
427: -- OA parameters.
428: -- x_msg_count:
429: -- OA-compliance OUT parameter. Tells how many messages are waiting
430: -- on the FND_MSG_PUB message stack. If x_msg_count = 1, the message
431: -- has already been fetched from the stack and is found in x_msg_data.
432: -- x_msg_data:
433: -- OA-compliance OUT parameter. If x_msg_count = 1, the message
434: -- has already been fetched from the stack and is found in x_msg_data.

Line 486: FND_MSG_PUB.Count_and_Get(

482: x_return_status => x_return_status);
483:
484: IF (x_return_status <> c_success)
485: THEN
486: FND_MSG_PUB.Count_and_Get(
487: p_encoded => c_false,
488: p_count => x_msg_count,
489: p_data => x_msg_data);
490: RETURN;

Line 569: FND_MSG_PUB.Count_and_Get(

565: END IF;
566:
567: x_temp_name := v_unique_name;
568:
569: FND_MSG_PUB.Count_and_Get(
570: p_encoded => p_encoded,
571: p_count => x_msg_count,
572: p_data => x_msg_data);
573:

Line 613: -- Tells whether or not to initialize the FND_MSG_PUB message stack by

609: -- Optional OA-compliance parameter.
610: -- Default is 1.0 (and this is currently the only acceptable value).
611: -- p_init_msg_list
612: -- Optional OA-compliance flag parameter.
613: -- Tells whether or not to initialize the FND_MSG_PUB message stack by
614: -- calling FND_MSG_PUB.Initialize.
615: -- Valid values are 'T' and 'F'; default is 'F'.
616: -- p_commit:
617: -- Optional OA-compliance flag parameter. Valid values are 'T' and 'F'.

Line 614: -- calling FND_MSG_PUB.Initialize.

610: -- Default is 1.0 (and this is currently the only acceptable value).
611: -- p_init_msg_list
612: -- Optional OA-compliance flag parameter.
613: -- Tells whether or not to initialize the FND_MSG_PUB message stack by
614: -- calling FND_MSG_PUB.Initialize.
615: -- Valid values are 'T' and 'F'; default is 'F'.
616: -- p_commit:
617: -- Optional OA-compliance flag parameter. Valid values are 'T' and 'F'.
618: -- Note that since DDL operations, such as creating a table, index,

Line 623: -- Passed to FND_MSG_PUB.Count_and_Get to determine the format of any

619: -- or view, always do an implicit COMMIT, this parameter cannot be
620: -- honored by this procedure: it will always commit.
621: -- p_encoded:
622: -- Optional OA-compliance flag parameter.
623: -- Passed to FND_MSG_PUB.Count_and_Get to determine the format of any
624: -- message passed back in x_msg_data.
625: -- Valid values are 'T' and 'F'; default is 'T'.
626: -- x_return_status:
627: -- OA-compliance OUT parameter. This procedure returns 'S' for

Line 633: -- on the FND_MSG_PUB message stack. If x_msg_count = 1, the message

629: -- OA parameters, and 'U' for unexpected errors, e.g. if the DDL
630: -- statement fails.
631: -- x_msg_count:
632: -- OA-compliance OUT parameter. Tells how many messages are waiting
633: -- on the FND_MSG_PUB message stack. If x_msg_count = 1, the message
634: -- has already been fetched from the stack and is found in x_msg_data.
635: -- x_msg_data:
636: -- OA-compliance OUT parameter. If x_msg_count = 1, the message
637: -- has already been fetched from the stack and is found in x_msg_data.

Line 704: FND_MSG_PUB.Count_and_Get(

700: x_return_status => x_return_status);
701:
702: IF (x_return_status <> c_success)
703: THEN
704: FND_MSG_PUB.Count_and_Get(
705: p_encoded => c_false,
706: p_count => x_msg_count,
707: p_data => x_msg_data);
708: RETURN;

Line 847: -- Put user error message on the FND_MSG_PUB stack

843: BEGIN
844: exec(p_request_id, p_object_id, 'CREATE_TEMP_TABLE', v_sql_statement, v_ddl_logging);
845: EXCEPTION
846: WHEN OTHERS THEN
847: -- Put user error message on the FND_MSG_PUB stack
848: -- "Failed to create temporary table: TABLE_NAME"
849:
850: v_sqlerrm := SUBSTR(SQLERRM, 1, 255);
851:

Line 910: -- Put user error message on the FND_MSG_PUB stack

906: BEGIN
907: exec(p_request_id, p_object_id, 'CREATE_TEMP_TABLE', v_sql_statement, v_ddl_logging);
908: EXCEPTION
909: WHEN OTHERS THEN
910: -- Put user error message on the FND_MSG_PUB stack
911: -- "Failed to create synonym for temporary table: TABLE_NAME"
912:
913: v_sqlerrm := SUBSTR(SQLERRM, 1, 255);
914:

Line 925: FND_MSG_PUB.Count_and_Get(

921: p_value2 => p_table_name);
922: RAISE;
923: END;
924:
925: FND_MSG_PUB.Count_and_Get(
926: p_encoded => p_encoded,
927: p_count => x_msg_count,
928: p_data => x_msg_data);
929:

Line 932: FND_MSG_PUB.Count_and_Get(

928: p_data => x_msg_data);
929:
930: EXCEPTION
931: WHEN OTHERS THEN
932: FND_MSG_PUB.Count_and_Get(
933: p_encoded => p_encoded,
934: p_count => x_msg_count,
935: p_data => x_msg_data);
936: x_return_status := c_unexp;

Line 978: -- Tells whether or not to initialize the FND_MSG_PUB message stack by

974: -- Optional OA-compliance parameter.
975: -- Default is 1.0 (and this is currently the only acceptable value).
976: -- p_init_msg_list
977: -- Optional OA-compliance flag parameter.
978: -- Tells whether or not to initialize the FND_MSG_PUB message stack by
979: -- calling FND_MSG_PUB.Initialize.
980: -- Valid values are 'T' and 'F'; default is 'F'.
981: -- p_commit:
982: -- Optional OA-compliance flag parameter. Valid values are 'T' and 'F'.

Line 979: -- calling FND_MSG_PUB.Initialize.

975: -- Default is 1.0 (and this is currently the only acceptable value).
976: -- p_init_msg_list
977: -- Optional OA-compliance flag parameter.
978: -- Tells whether or not to initialize the FND_MSG_PUB message stack by
979: -- calling FND_MSG_PUB.Initialize.
980: -- Valid values are 'T' and 'F'; default is 'F'.
981: -- p_commit:
982: -- Optional OA-compliance flag parameter. Valid values are 'T' and 'F'.
983: -- Note that since DDL operations, such as creating a table, index,

Line 988: -- Passed to FND_MSG_PUB.Count_and_Get to determine the format of any

984: -- or view, always do an implicit COMMIT, this parameter cannot be
985: -- honored by this procedure: it will always commit.
986: -- p_encoded:
987: -- Optional OA-compliance flag parameter.
988: -- Passed to FND_MSG_PUB.Count_and_Get to determine the format of any
989: -- message passed back in x_msg_data.
990: -- Valid values are 'T' and 'F'; default is 'T'.
991: -- x_return_status:
992: -- OA-compliance OUT parameter. This procedure returns 'S' for

Line 998: -- on the FND_MSG_PUB message stack. If x_msg_count = 1, the message

994: -- OA parameters, and 'U' for unexpected errors, e.g. if the DDL
995: -- statement fails.
996: -- x_msg_count:
997: -- OA-compliance OUT parameter. Tells how many messages are waiting
998: -- on the FND_MSG_PUB message stack. If x_msg_count = 1, the message
999: -- has already been fetched from the stack and is found in x_msg_data.
1000: -- x_msg_data:
1001: -- OA-compliance OUT parameter. If x_msg_count = 1, the message
1002: -- has already been fetched from the stack and is found in x_msg_data.

Line 1065: FND_MSG_PUB.Count_and_Get(

1061: x_return_status => x_return_status);
1062:
1063: IF (x_return_status <> c_success)
1064: THEN
1065: FND_MSG_PUB.Count_and_Get(
1066: p_encoded => c_false,
1067: p_count => x_msg_count,
1068: p_data => x_msg_data);
1069: RETURN;

Line 1203: -- Put user error message on the FND_MSG_PUB stack

1199: BEGIN
1200: exec(p_request_id, p_object_id, 'CREATE_TEMP_INDEX', v_sql_statement, v_ddl_logging);
1201: EXCEPTION
1202: WHEN OTHERS THEN
1203: -- Put user error message on the FND_MSG_PUB stack
1204: -- "Failed to create temporary index: INDEX_NAME on table: TABLE_NAME"
1205:
1206: v_sqlerrm := SUBSTR(SQLERRM, 1, 255);
1207:

Line 1259: FND_MSG_PUB.Count_and_Get(

1255: END;
1256:
1257: COMMIT;
1258:
1259: FND_MSG_PUB.Count_and_Get(
1260: p_encoded => p_encoded,
1261: p_count => x_msg_count,
1262: p_data => x_msg_data);
1263:

Line 1266: FND_MSG_PUB.Count_and_Get(

1262: p_data => x_msg_data);
1263:
1264: EXCEPTION
1265: WHEN OTHERS THEN
1266: FND_MSG_PUB.Count_and_Get(
1267: p_encoded => p_encoded,
1268: p_count => x_msg_count,
1269: p_data => x_msg_data);
1270: x_return_status := c_unexp;

Line 1305: -- Tells whether or not to initialize the FND_MSG_PUB message stack by

1301: -- Optional OA-compliance parameter.
1302: -- Default is 1.0 (and this is currently the only acceptable value).
1303: -- p_init_msg_list
1304: -- Optional OA-compliance flag parameter.
1305: -- Tells whether or not to initialize the FND_MSG_PUB message stack by
1306: -- calling FND_MSG_PUB.Initialize.
1307: -- Valid values are 'T' and 'F'; default is 'F'.
1308: -- p_commit:
1309: -- Optional OA-compliance flag parameter. Valid values are 'T' and 'F'.

Line 1306: -- calling FND_MSG_PUB.Initialize.

1302: -- Default is 1.0 (and this is currently the only acceptable value).
1303: -- p_init_msg_list
1304: -- Optional OA-compliance flag parameter.
1305: -- Tells whether or not to initialize the FND_MSG_PUB message stack by
1306: -- calling FND_MSG_PUB.Initialize.
1307: -- Valid values are 'T' and 'F'; default is 'F'.
1308: -- p_commit:
1309: -- Optional OA-compliance flag parameter. Valid values are 'T' and 'F'.
1310: -- Note that since DDL operations, such as creating a table, index,

Line 1315: -- Passed to FND_MSG_PUB.Count_and_Get to determine the format of any

1311: -- or view, always do an implicit COMMIT, this parameter cannot be
1312: -- honored by this procedure: it will always commit.
1313: -- p_encoded:
1314: -- Optional OA-compliance flag parameter.
1315: -- Passed to FND_MSG_PUB.Count_and_Get to determine the format of any
1316: -- message passed back in x_msg_data.
1317: -- Valid values are 'T' and 'F'; default is 'T'.
1318: -- x_return_status:
1319: -- OA-compliance OUT parameter. This procedure returns 'S' for

Line 1325: -- on the FND_MSG_PUB message stack. If x_msg_count = 1, the message

1321: -- OA parameters, and 'U' for unexpected errors, e.g. if the DDL
1322: -- statement fails.
1323: -- x_msg_count:
1324: -- OA-compliance OUT parameter. Tells how many messages are waiting
1325: -- on the FND_MSG_PUB message stack. If x_msg_count = 1, the message
1326: -- has already been fetched from the stack and is found in x_msg_data.
1327: -- x_msg_data:
1328: -- OA-compliance OUT parameter. If x_msg_count = 1, the message
1329: -- has already been fetched from the stack and is found in x_msg_data.

Line 1378: FND_MSG_PUB.Count_and_Get(

1374: x_return_status => x_return_status);
1375:
1376: IF (x_return_status <> c_success)
1377: THEN
1378: FND_MSG_PUB.Count_and_Get(
1379: p_encoded => c_false,
1380: p_count => x_msg_count,
1381: p_data => x_msg_data);
1382: RETURN;

Line 1422: -- Put user error message on the FND_MSG_PUB stack

1418: BEGIN
1419: exec(p_request_id, p_object_id, 'CREATE_TEMP_VIEW', v_sql_statement, v_ddl_logging);
1420: EXCEPTION
1421: WHEN OTHERS THEN
1422: -- Put user error message on the FND_MSG_PUB stack
1423: -- "Failed to create temporary view: VIEW_NAME"
1424:
1425: v_sqlerrm := SUBSTR(SQLERRM, 1, 255);
1426:

Line 1476: FND_MSG_PUB.Count_and_Get(

1472: END;
1473:
1474: COMMIT;
1475:
1476: FND_MSG_PUB.Count_and_Get(
1477: p_encoded => p_encoded,
1478: p_count => x_msg_count,
1479: p_data => x_msg_data);
1480:

Line 1484: FND_MSG_PUB.Count_and_Get(

1480:
1481: EXCEPTION
1482: WHEN OTHERS THEN
1483:
1484: FND_MSG_PUB.Count_and_Get(
1485: p_encoded => p_encoded,
1486: p_count => x_msg_count,
1487: p_data => x_msg_data);
1488: x_return_status := c_unexp;

Line 1516: -- Tells whether or not to initialize the FND_MSG_PUB message stack by

1512: -- Optional OA-compliance parameter.
1513: -- Default is 1.0 (and this is currently the only acceptable value).
1514: -- p_init_msg_list
1515: -- Optional OA-compliance flag parameter.
1516: -- Tells whether or not to initialize the FND_MSG_PUB message stack by
1517: -- calling FND_MSG_PUB.Initialize.
1518: -- Valid values are 'T' and 'F'; default is 'F'.
1519: -- p_commit:
1520: -- Optional OA-compliance flag parameter. Valid values are 'T' and 'F'.

Line 1517: -- calling FND_MSG_PUB.Initialize.

1513: -- Default is 1.0 (and this is currently the only acceptable value).
1514: -- p_init_msg_list
1515: -- Optional OA-compliance flag parameter.
1516: -- Tells whether or not to initialize the FND_MSG_PUB message stack by
1517: -- calling FND_MSG_PUB.Initialize.
1518: -- Valid values are 'T' and 'F'; default is 'F'.
1519: -- p_commit:
1520: -- Optional OA-compliance flag parameter. Valid values are 'T' and 'F'.
1521: -- Note that since DDL operations, such as dropping a table, index,

Line 1526: -- Passed to FND_MSG_PUB.Count_and_Get to determine the format of any

1522: -- or view, always do an implicit COMMIT, this parameter cannot be
1523: -- honored by this procedure: it will always commit.
1524: -- p_encoded:
1525: -- Optional OA-compliance flag parameter.
1526: -- Passed to FND_MSG_PUB.Count_and_Get to determine the format of any
1527: -- message passed back in x_msg_data.
1528: -- Valid values are 'T' and 'F'; default is 'T'.
1529: -- x_return_status:
1530: -- OA-compliance OUT parameter.

Line 1541: -- on the FND_MSG_PUB message stack. If x_msg_count = 1, the message

1537: -- objects for the given Request ID and Object ID. 'U' is returned for
1538: -- any other type of unexpected error.
1539: -- x_msg_count:
1540: -- OA-compliance OUT parameter. Tells how many messages are waiting
1541: -- on the FND_MSG_PUB message stack. If x_msg_count = 1, the message
1542: -- has already been fetched from the stack and is found in x_msg_data.
1543: -- x_msg_data:
1544: -- OA-compliance OUT parameter. If x_msg_count = 1, the message
1545: -- has already been fetched from the stack and is found in x_msg_data.

Line 1611: FND_MSG_PUB.Count_and_Get(

1607: x_return_status => x_return_status);
1608:
1609: IF (x_return_status <> c_success)
1610: THEN
1611: FND_MSG_PUB.Count_and_Get(
1612: p_encoded => c_false,
1613: p_count => x_msg_count,
1614: p_data => x_msg_data);
1615: RETURN;

Line 1672: -- Put user error message on the FND_MSG_PUB stack

1668:
1669: WHEN table_or_view_not_exist THEN
1670: NULL;
1671: WHEN OTHERS THEN
1672: -- Put user error message on the FND_MSG_PUB stack
1673: -- "Failed to drop temporary database object. Object Type: VIEW. Object Name: DB_OBJECT_NAME"
1674:
1675: v_sqlerrm := SUBSTR(SQLERRM, 1, 255);
1676:

Line 1717: -- Put user error message on the FND_MSG_PUB stack

1713:
1714: WHEN index_not_exist THEN
1715: NULL;
1716: WHEN OTHERS THEN
1717: -- Put user error message on the FND_MSG_PUB stack
1718: -- "Failed to drop temporary database object: OBJECT_NAME. Object Type: INDEX"
1719:
1720: v_sqlerrm := SUBSTR(SQLERRM, 1, 255);
1721:

Line 1762: -- Put user error message on the FND_MSG_PUB stack

1758:
1759: WHEN synonym_not_exist THEN
1760: NULL;
1761: WHEN OTHERS THEN
1762: -- Put user error message on the FND_MSG_PUB stack
1763: -- "Failed to drop temporary database object. Object Type: SYNONYM. Object Name: OBJECT_NAME"
1764:
1765: v_sqlerrm := SUBSTR(SQLERRM, 1, 255);
1766:

Line 1790: -- Put user error message on the FND_MSG_PUB stack

1786:
1787: WHEN table_or_view_not_exist THEN
1788: NULL;
1789: WHEN OTHERS THEN
1790: -- Put user error message on the FND_MSG_PUB stack
1791: -- "Failed to drop temporary database object. Object Type: TABLE. Object Name: OBJECT_NAME"
1792:
1793: v_sqlerrm := SUBSTR(SQLERRM, 1, 255);
1794:

Line 1820: FND_MSG_PUB.Count_and_Get(

1816: WHERE table_name = tobj.object_name);
1817:
1818: COMMIT;
1819:
1820: FND_MSG_PUB.Count_and_Get(
1821: p_encoded => p_encoded,
1822: p_count => x_msg_count,
1823: p_data => x_msg_data);
1824:

Line 1832: FND_MSG_PUB.Count_and_Get(

1828: p_severity => c_log_level_6,
1829: p_module => 'fem.plsql.fem_database_util_pkg.drop_temp_db_objects',
1830: p_msg_text => SUBSTR(SQLERRM, 1, 255) );
1831:
1832: FND_MSG_PUB.Count_and_Get(
1833: p_encoded => p_encoded,
1834: p_count => x_msg_count,
1835: p_data => x_msg_data);
1836: x_return_status := c_unexp;