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.JTF_IH_BULK dependencies on FND_API

Line 82: P_INIT_MSG_LIST => FND_API.G_FALSE,

78:
79: l_gmt_date := TO_DATE(p_gmt_date_str, G_DATE_FORMAT);
80:
81: HZ_TIMEZONE_PUB.GET_TIME(P_API_VERSION => 1.0,
82: P_INIT_MSG_LIST => FND_API.G_FALSE,
83: P_SOURCE_TZ_ID => G_GMT_TZ,
84: P_DEST_TZ_ID => G_SERVER_TZ,
85: P_SOURCE_DAY_TIME => l_gmt_date,
86: X_DEST_DAY_TIME => l_server_date,

Line 93: IF (l_ret_status <> FND_API.G_RET_STS_SUCCESS) THEN

89: X_MSG_DATA => l_msg_data);
90:
91: -- what do you do if the time cannot be coverted ?!
92: -- take the time as it is given to be server time
93: IF (l_ret_status <> FND_API.G_RET_STS_SUCCESS) THEN
94: NULL;
95: l_server_date := l_gmt_date;
96: END IF;
97:

Line 681: l_ret_status := FND_API.G_RET_STS_SUCCESS;

677: l_ret_msg := '';
678: L_BLANK := '';
679:
680: -- optimistic
681: l_ret_status := FND_API.G_RET_STS_SUCCESS;
682:
683: g_hrt_beat := 1;
684:
685: -- savepoint to roll back any work done for this bulk record

Line 723: l_ret_status := FND_API.G_RET_STS_ERROR;

719: IF( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
720: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,
721: 'jtf.plsql.JTF_IH_BULK.PROCESS_BULK_RECORD',errm);
722: END IF;
723: l_ret_status := FND_API.G_RET_STS_ERROR;
724: END;
725: END;
726:
727: --IF (g_stats_enabled) THEN

Line 882: IF (l_ret_status <> FND_API.G_RET_STS_SUCCESS) THEN

878: IF (num_med > 0) THEN
879: PROCESS_MEDIA_ITEMS(med_nl, l_bulk_interaction_id, p_bulk_writer_code,
880: p_bulk_batch_type, p_bulk_batch_id, l_user_id, med_id_tbl,
881: l_ret_status, l_ret_msg);
882: IF (l_ret_status <> FND_API.G_RET_STS_SUCCESS) THEN
883: l_error := 'JTF_IH_BULK_MEDIA_FAIL';
884: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_error || ', ' || l_ret_msg);
885: l_error_msgLOG := l_ret_msg;
886: RAISE processing_error;

Line 913: IF (l_ret_status <> FND_API.G_RET_STS_SUCCESS) THEN

909: GATHER_ACT_TBL(act_nl, l_bulk_interaction_id, p_bulk_writer_code,
910: p_bulk_batch_type, p_bulk_batch_id, med_id_tbl,
911: act_tbl, l_ret_status, l_ret_msg);
912:
913: IF (l_ret_status <> FND_API.G_RET_STS_SUCCESS) THEN
914: l_error := 'JTF_IH_BULK_ACT_FAIL';
915:
916: --Logging Detail Level
917: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 938: IF (l_ret_status <> FND_API.G_RET_STS_SUCCESS) THEN

934: GATHER_INT_ATTR(int_elem, l_bulk_interaction_id, p_bulk_writer_code,
935: p_bulk_batch_type, p_bulk_batch_id, int_rec,
936: l_ret_status, l_ret_msg);
937:
938: IF (l_ret_status <> FND_API.G_RET_STS_SUCCESS) THEN
939: l_error := 'JTF_IH_BULK_ACT_FAIL';
940: FND_MESSAGE.SET_NAME('JTF', 'JTF_IH_BULK_INT_FAIL');
941: l_ret_msg := FND_MESSAGE.GET ||' '|| l_ret_msg;
942: --FND_FILE.PUT_LINE(FND_FILE.LOG, l_ret_msg);

Line 963: p_init_msg_list => FND_API.G_TRUE,

959:
960: g_hrt_beat := 9;
961:
962: JTF_IH_PUB.Create_Interaction(p_api_version => 1.0,
963: p_init_msg_list => FND_API.G_TRUE,
964: p_commit => FND_API.G_FALSE,
965: p_user_id => l_user_id,
966: x_return_status => l_ret_status,
967: x_msg_count => l_msg_count,

Line 964: p_commit => FND_API.G_FALSE,

960: g_hrt_beat := 9;
961:
962: JTF_IH_PUB.Create_Interaction(p_api_version => 1.0,
963: p_init_msg_list => FND_API.G_TRUE,
964: p_commit => FND_API.G_FALSE,
965: p_user_id => l_user_id,
966: x_return_status => l_ret_status,
967: x_msg_count => l_msg_count,
968: x_msg_data => l_msg_data,

Line 973: IF (l_ret_status <> FND_API.G_RET_STS_SUCCESS) THEN

969: p_interaction_rec => int_rec,
970: p_activities => act_tbl);
971:
972: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Create_Interaction returned - ' || l_ret_status);
973: IF (l_ret_status <> FND_API.G_RET_STS_SUCCESS) THEN
974: l_error := 'JTF_IH_BULK_INT_FAIL';
975: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_error || ', msg_count = ' || l_msg_count);
976:
977: --Logging Detail Level

Line 1213: l_ret_status := FND_API.G_RET_STS_ERROR;

1209: l_bulk_interaction_id,
1210: p_bulk_interaction_request,
1211: FND_MESSAGE.GET_STRING('JTF','JTF_IH_BULK_REQ_FAIL'),
1212: errm);
1213: l_ret_status := FND_API.G_RET_STS_ERROR;
1214: END;
1215:
1216: -- an exception is always unexpected
1217: RETURN FND_API.G_RET_STS_UNEXP_ERROR;

Line 1217: RETURN FND_API.G_RET_STS_UNEXP_ERROR;

1213: l_ret_status := FND_API.G_RET_STS_ERROR;
1214: END;
1215:
1216: -- an exception is always unexpected
1217: RETURN FND_API.G_RET_STS_UNEXP_ERROR;
1218: END PROCESS_BULK_RECORD;
1219:
1220: --
1221: -- Utility function to handle media nodes for an interaction.

Line 1303: l_ret_status := FND_API.G_RET_STS_SUCCESS;

1299: Close_MediaItem methods
1300: f. keep track of mediaitem_identifier to media_id values
1301: */
1302:
1303: l_ret_status := FND_API.G_RET_STS_SUCCESS;
1304: num_med := dbms_xmldom.getLength(med_nl);
1305:
1306: g_hrt_beat := 13.0;
1307:

Line 1462: p_init_msg_list => FND_API.G_TRUE,

1458: --d. if MEDIA_ID value is not set for the media item,
1459: -- call JTF_IH_PUB.Create_MediaItem with the attributes and mlcs
1460: IF (l_media_id_given = FALSE) THEN
1461: JTF_IH_PUB.create_mediaitem(p_api_version => 1.0,
1462: p_init_msg_list => FND_API.G_TRUE,
1463: p_commit => FND_API.G_FALSE,
1464: p_user_id => p_user_id,
1465: x_return_status => l_ret_status,
1466: x_msg_count => l_msg_count,

Line 1463: p_commit => FND_API.G_FALSE,

1459: -- call JTF_IH_PUB.Create_MediaItem with the attributes and mlcs
1460: IF (l_media_id_given = FALSE) THEN
1461: JTF_IH_PUB.create_mediaitem(p_api_version => 1.0,
1462: p_init_msg_list => FND_API.G_TRUE,
1463: p_commit => FND_API.G_FALSE,
1464: p_user_id => p_user_id,
1465: x_return_status => l_ret_status,
1466: x_msg_count => l_msg_count,
1467: x_msg_data => l_msg_data,

Line 1474: IF (l_ret_status <> FND_API.G_RET_STS_SUCCESS) THEN

1470:
1471: -- The dbms_output will need to be replaced by proper logging for error
1472: -- messages.
1473: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Create_MediaItem returned - ' || l_ret_status);
1474: IF (l_ret_status <> FND_API.G_RET_STS_SUCCESS) THEN
1475: l_rtn_name := 'Create_MediaItem';
1476: /*FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Create_MediaItem failed' ||
1477: ', msg_count = ' || l_msg_count ||
1478: ', msg_data = ' || l_msg_data);*/

Line 1488: p_init_msg_list => FND_API.G_TRUE,

1484: g_hrt_beat := 13.5;
1485: -- loop through all mlcs records and create them
1486: FOR l IN 1..mlcs_tbl.COUNT LOOP
1487: JTF_IH_PUB.Add_MediaLifecycle( p_api_version => 1.0,
1488: p_init_msg_list => FND_API.G_TRUE,
1489: p_commit => FND_API.G_FALSE,
1490: p_user_id => p_user_id,
1491: x_return_status => l_ret_status,
1492: x_msg_count => l_msg_count,

Line 1489: p_commit => FND_API.G_FALSE,

1485: -- loop through all mlcs records and create them
1486: FOR l IN 1..mlcs_tbl.COUNT LOOP
1487: JTF_IH_PUB.Add_MediaLifecycle( p_api_version => 1.0,
1488: p_init_msg_list => FND_API.G_TRUE,
1489: p_commit => FND_API.G_FALSE,
1490: p_user_id => p_user_id,
1491: x_return_status => l_ret_status,
1492: x_msg_count => l_msg_count,
1493: x_msg_data => l_msg_data,

Line 1496: IF (l_ret_status <> FND_API.G_RET_STS_SUCCESS) THEN

1492: x_msg_count => l_msg_count,
1493: x_msg_data => l_msg_data,
1494: p_media_lc_rec => mlcs_tbl(l),
1495: x_milcs_id => l_milcs_id);
1496: IF (l_ret_status <> FND_API.G_RET_STS_SUCCESS) THEN
1497: l_rtn_name := 'Add_MediaLifecycle';
1498: /*FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Add_MediaLifecycle failed' ||
1499: ', msg_count = ' || l_msg_count ||
1500: ', msg_data = ' || l_msg_data);*/

Line 1507: p_init_msg_list => FND_API.G_TRUE,

1503: END LOOP;
1504:
1505: -- now update the media item and close it as well.
1506: JTF_IH_PUB.Close_MediaItem(p_api_version => 1.0,
1507: p_init_msg_list => FND_API.G_TRUE,
1508: p_commit => FND_API.G_FALSE,
1509: p_user_id => p_user_id,
1510: x_return_status => l_ret_status,
1511: x_msg_count => l_msg_count,

Line 1508: p_commit => FND_API.G_FALSE,

1504:
1505: -- now update the media item and close it as well.
1506: JTF_IH_PUB.Close_MediaItem(p_api_version => 1.0,
1507: p_init_msg_list => FND_API.G_TRUE,
1508: p_commit => FND_API.G_FALSE,
1509: p_user_id => p_user_id,
1510: x_return_status => l_ret_status,
1511: x_msg_count => l_msg_count,
1512: x_msg_data => l_msg_data,

Line 1515: IF (l_ret_status <> FND_API.G_RET_STS_SUCCESS) THEN

1511: x_msg_count => l_msg_count,
1512: x_msg_data => l_msg_data,
1513: p_media_rec => med_rec);
1514:
1515: IF (l_ret_status <> FND_API.G_RET_STS_SUCCESS) THEN
1516: l_rtn_name := 'Close_MediaItem';
1517: /*FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Close_MediaItem failed' ||
1518: ', msg_count = ' || l_msg_count ||
1519: ', msg_data = ' || l_msg_data);*/

Line 1577: x_ret_status := FND_API.G_RET_STS_ERROR;

1573: -- substrb(l_msg_data, 0, (2000-lengthb(', ')));
1574: END LOOP;
1575:
1576: -- return error
1577: x_ret_status := FND_API.G_RET_STS_ERROR;
1578:
1579: WHEN OTHERS THEN
1580: DECLARE
1581: error NUMBER := SQLCODE;

Line 1604: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR;

1600:
1601: x_ret_msg := errm;
1602:
1603: -- an unknown exception is always unexpected
1604: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR;
1605:
1606: END;
1607:
1608: END PROCESS_MEDIA_ITEMS;

Line 1746: x_ret_status := FND_API.G_RET_STS_SUCCESS;

1742: x_act_tbl(j).bulk_batch_id := p_bulk_batch_id;
1743: x_act_tbl(j).bulk_interaction_id := p_bulk_interaction_id;
1744: END LOOP; -- MED nodes
1745:
1746: x_ret_status := FND_API.G_RET_STS_SUCCESS;
1747:
1748: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1749: l_fnd_log_msg := 'GATHER_ACT_TBL Out parameters :'||
1750: 'x_act_tbl TYPE JTF_IH_PUB.ACTIVITY_TBL_TYPE' ||

Line 1787: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR;

1783: x_ret_msg := errm;
1784: END;
1785:
1786: -- an exception is always unexpected
1787: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR;
1788:
1789: END GATHER_ACT_TBL;
1790:
1791: --

Line 1894: x_ret_status := FND_API.G_RET_STS_SUCCESS;

1890: x_int_rec.bulk_batch_type := p_bulk_batch_type;
1891: x_int_rec.bulk_batch_id := p_bulk_batch_id;
1892: x_int_rec.bulk_interaction_id := p_bulk_interaction_id;
1893:
1894: x_ret_status := FND_API.G_RET_STS_SUCCESS;
1895:
1896: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1897: l_fnd_log_msg := 'GATHER_INT_ATTR Out parameters :'||
1898: 'x_int_rec TYPE JTF_IH_PUB.INTERACTION_REC_TYPE'||

Line 2007: 'FND_API.G_RET_STS_SUCCESS = '|| FND_API.G_RET_STS_SUCCESS;

2003: WHERE bulk_error_id = rec_id;
2004:
2005: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2006: l_fnd_log_msg := 'FUNCTION LOG_BULK_ERROR return variable :'||
2007: 'FND_API.G_RET_STS_SUCCESS = '|| FND_API.G_RET_STS_SUCCESS;
2008: --dbms_output.put_line(l_fnd_log_msg);
2009: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2010: 'jtf.plsql.JTF_IH_BULK.LOG_BULK_ERROR.end', l_fnd_log_msg);
2011: END IF;

Line 2013: RETURN FND_API.G_RET_STS_SUCCESS;

2009: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2010: 'jtf.plsql.JTF_IH_BULK.LOG_BULK_ERROR.end', l_fnd_log_msg);
2011: END IF;
2012:
2013: RETURN FND_API.G_RET_STS_SUCCESS;
2014:
2015: EXCEPTION
2016: WHEN OTHERS THEN
2017:

Line 2042: RETURN FND_API.G_RET_STS_UNEXP_ERROR;

2038: -- tbd.
2039:
2040: ROLLBACK WORK TO SAVEPOINT BULK_ERROR;
2041:
2042: RETURN FND_API.G_RET_STS_UNEXP_ERROR;
2043: END LOG_BULK_ERROR;
2044:
2045:
2046: --

Line 2122: 'FND_API.G_RET_STS_SUCCESS = '|| FND_API.G_RET_STS_SUCCESS;

2118: p_bulk_interaction_id, error_msg_2, p_bulk_interaction_request);
2119:
2120: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2121: l_fnd_log_msg := 'FUNCTION LOG_BULK_ERROR return variable :'||
2122: 'FND_API.G_RET_STS_SUCCESS = '|| FND_API.G_RET_STS_SUCCESS;
2123: --dbms_output.put_line(l_fnd_log_msg);
2124: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2125: 'jtf.plsql.JTF_IH_BULK.LOG_BULK_ERROR.end', l_fnd_log_msg);
2126: END IF;

Line 2128: RETURN FND_API.G_RET_STS_SUCCESS;

2124: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2125: 'jtf.plsql.JTF_IH_BULK.LOG_BULK_ERROR.end', l_fnd_log_msg);
2126: END IF;
2127:
2128: RETURN FND_API.G_RET_STS_SUCCESS;
2129:
2130: EXCEPTION
2131: WHEN OTHERS THEN
2132:

Line 2158: RETURN FND_API.G_RET_STS_UNEXP_ERROR;

2154: -- tbd.
2155:
2156: ROLLBACK WORK TO SAVEPOINT BULK_ERROR;
2157:
2158: RETURN FND_API.G_RET_STS_UNEXP_ERROR;
2159: END LOG_BULK_ERROR;
2160:
2161: FUNCTION FIND_ONE_CRASH_RECD
2162: (

Line 2330: IF (l_ret_status <> FND_API.G_RET_STS_SUCCESS) THEN

2326: l_rec_recd.bulk_batch_id,
2327: l_rec_recd.bulk_interaction_request,
2328: l_rec_recd.num_int_processed);
2329:
2330: IF (l_ret_status <> FND_API.G_RET_STS_SUCCESS) THEN
2331: g_hrt_beat := -61;
2332: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2333: FND_MESSAGE.SET_NAME('JTF', 'JTF_IH_BULK_RECOV_FAIL');
2334: FND_MESSAGE.SET_TOKEN('MSG_ID', l_rec_recd.msg_id);