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_FM_MD_MIGRATION_PVT dependencies on FND_API

Line 46: x_status := FND_API.G_RET_STS_SUCCESS;

42: OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE,
43: LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,STATUS)
44: VALUES(p_code,0, FND_GLOBAL.user_id, SYSDATE,
45: FND_GLOBAL.user_id, SYSDATE, FND_GLOBAL.user_id, p_status);
46: x_status := FND_API.G_RET_STS_SUCCESS;
47: EXCEPTION
48: WHEN OTHERS THEN
49: x_status := FND_API.G_RET_STS_ERROR;
50: END create_log;

Line 49: x_status := FND_API.G_RET_STS_ERROR;

45: FND_GLOBAL.user_id, SYSDATE, FND_GLOBAL.user_id, p_status);
46: x_status := FND_API.G_RET_STS_SUCCESS;
47: EXCEPTION
48: WHEN OTHERS THEN
49: x_status := FND_API.G_RET_STS_ERROR;
50: END create_log;
51:
52: PROCEDURE update_log(p_code IN VARCHAR2,
53: p_old_status IN VARCHAR2,

Line 100: x_status := FND_API.G_RET_STS_SUCCESS;

96: END LOOP;
97:
98:
99:
100: x_status := FND_API.G_RET_STS_SUCCESS;
101: EXCEPTION
102: WHEN OTHERS THEN
103: x_status := FND_API.G_RET_STS_ERROR;
104: END update_log;

Line 103: x_status := FND_API.G_RET_STS_ERROR;

99:
100: x_status := FND_API.G_RET_STS_SUCCESS;
101: EXCEPTION
102: WHEN OTHERS THEN
103: x_status := FND_API.G_RET_STS_ERROR;
104: END update_log;
105:
106:
107:

Line 348: p_trans_required => FND_API.G_FALSE,

344: p_citem_name => px_masterdoc_qry_rec.FILE_NAME,
345: p_citem_description => px_masterdoc_qry_rec.DESCRIPTION,
346: p_dir_node_id => l_directory, -- TEMPLATE -4 , Query -11 directory node
347: p_reference_code => NULL,
348: p_trans_required => FND_API.G_FALSE,
349: p_wd_restricted => FND_API.G_FALSE,
350: p_start_date => NULL,
351: p_end_date => NULL,
352: p_attribute_type_codes => l_attribute_type_codes,

Line 349: p_wd_restricted => FND_API.G_FALSE,

345: p_citem_description => px_masterdoc_qry_rec.DESCRIPTION,
346: p_dir_node_id => l_directory, -- TEMPLATE -4 , Query -11 directory node
347: p_reference_code => NULL,
348: p_trans_required => FND_API.G_FALSE,
349: p_wd_restricted => FND_API.G_FALSE,
350: p_start_date => NULL,
351: p_end_date => NULL,
352: p_attribute_type_codes => l_attribute_type_codes,
353: p_attributes => l_attributes,

Line 359: p_commit => FND_API.G_FALSE,

355: p_component_citems => l_compound_content_items,
356: p_component_atypes => l_compound_attribute_types,
357: p_status => l_status,
358: p_language => USERENV('LANG'),
359: p_commit => FND_API.G_FALSE,
360: px_content_item_id => px_masterdoc_qry_rec.content_item_id,
361: px_citem_ver_id => px_masterdoc_qry_rec.citem_version_id,
362: px_object_version_number => l_object_version_number,
363: x_return_status => l_return_status,

Line 366: IF l_return_status <> FND_API.g_ret_sts_success THEN

362: px_object_version_number => l_object_version_number,
363: x_return_status => l_return_status,
364: x_msg_count => l_msg_count,
365: x_msg_data => l_msg_data);
366: IF l_return_status <> FND_API.g_ret_sts_success THEN
367: printDebugLog(' Error in base content item creation:'||l_msg_data);
368: RAISE FND_API.g_exc_error;
369: END IF;
370:

Line 368: RAISE FND_API.g_exc_error;

364: x_msg_count => l_msg_count,
365: x_msg_data => l_msg_data);
366: IF l_return_status <> FND_API.g_ret_sts_success THEN
367: printDebugLog(' Error in base content item creation:'||l_msg_data);
368: RAISE FND_API.g_exc_error;
369: END IF;
370:
371: printDebugLog(' After Upsert content Item ID and CITEM_VERID is: ' ||px_masterdoc_qry_rec.content_item_id || ':' ||px_masterdoc_qry_rec.citem_version_id);
372:

Line 374: x_return_status := FND_API.g_ret_sts_success;

370:
371: printDebugLog(' After Upsert content Item ID and CITEM_VERID is: ' ||px_masterdoc_qry_rec.content_item_id || ':' ||px_masterdoc_qry_rec.citem_version_id);
372:
373: END IF;
374: x_return_status := FND_API.g_ret_sts_success;
375: EXCEPTION
376: WHEN OTHERS THEN
377: ROLLBACK TO process_content_item;
378: x_return_status := FND_API.g_ret_sts_error;

Line 378: x_return_status := FND_API.g_ret_sts_error;

374: x_return_status := FND_API.g_ret_sts_success;
375: EXCEPTION
376: WHEN OTHERS THEN
377: ROLLBACK TO process_content_item;
378: x_return_status := FND_API.g_ret_sts_error;
379: END process_content_item;
380:
381: PROCEDURE process_content_items(
382: px_masterdoc_qry_tbl IN OUT NOCOPY MASTERDOC_QRY_TBL_TYPE,

Line 396: x_return_status := FND_API.g_ret_sts_success;

392: l_msg_data VARCHAR2(2000);
393:
394: BEGIN
395: SAVEPOINT process_content_items;
396: x_return_status := FND_API.g_ret_sts_success;
397: printDebugLog(' process_content_items begin');
398: IF px_masterdoc_qry_tbl.count > 0 THEN
399: printDebugLog(' content item number='||px_masterdoc_qry_tbl.count);
400: FOR l_i IN 1..px_masterdoc_qry_tbl.count LOOP

Line 407: l_return_status := FND_API.g_ret_sts_success;

403: ||' file id:'||px_masterdoc_qry_tbl(l_i).file_id
404: ||' file name:'||px_masterdoc_qry_tbl(l_i).file_name);
405:
406:
407: l_return_status := FND_API.g_ret_sts_success;
408:
409: process_content_item(
410: px_masterdoc_qry_rec => px_masterdoc_qry_tbl(l_i),
411: x_return_status => l_return_status,

Line 416: IF (l_return_status = FND_API.g_ret_sts_success)

412: x_msg_count => l_msg_count,
413: x_msg_data => l_msg_data);
414: printDebugLog(' process_content_item return:'||l_return_status);
415:
416: IF (l_return_status = FND_API.g_ret_sts_success)
417: THEN
418:
419: g_idx_created := g_idx_created + 1;
420:

Line 451: x_return_status := FND_API.g_ret_sts_error;

447: printDebuglog(' process_content_items end');
448: EXCEPTION
449: WHEN OTHERS THEN
450: ROLLBACK TO process_content_items;
451: x_return_status := FND_API.g_ret_sts_error;
452: END process_content_items;
453:
454:
455:

Line 512: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

508: x_return_status => l_return_status,
509: x_msg_count => l_msg_count,
510: x_msg_data => l_msg_data);
511: printDebuglog(' process_content_items return:'||l_return_status);
512: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
513: raise Fnd_Api.G_EXC_UNEXPECTED_ERROR;
514: END IF;
515: EXCEPTION
516:

Line 513: raise Fnd_Api.G_EXC_UNEXPECTED_ERROR;

509: x_msg_count => l_msg_count,
510: x_msg_data => l_msg_data);
511: printDebuglog(' process_content_items return:'||l_return_status);
512: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
513: raise Fnd_Api.G_EXC_UNEXPECTED_ERROR;
514: END IF;
515: EXCEPTION
516:
517: WHEN OTHERS THEN

Line 519: p_encoded => FND_API.g_false,

515: EXCEPTION
516:
517: WHEN OTHERS THEN
518: FND_MSG_PUB.Count_And_Get (
519: p_encoded => FND_API.g_false,
520: p_count => l_msg_count,
521: p_data => l_msg_data
522: );
523: printDebugLog('x_message: '||l_msg_data);

Line 672: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

668: x_return_status => l_return_status,
669: x_msg_count => l_msg_count,
670: x_msg_data => l_msg_data);
671: printDebuglog(' process_content_items return:'||l_return_status);
672: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
673: raise Fnd_Api.G_EXC_UNEXPECTED_ERROR;
674: END IF;
675: printDebuglog('Content repository migration End');
676: x_status := FND_API.g_ret_sts_success;

Line 673: raise Fnd_Api.G_EXC_UNEXPECTED_ERROR;

669: x_msg_count => l_msg_count,
670: x_msg_data => l_msg_data);
671: printDebuglog(' process_content_items return:'||l_return_status);
672: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
673: raise Fnd_Api.G_EXC_UNEXPECTED_ERROR;
674: END IF;
675: printDebuglog('Content repository migration End');
676: x_status := FND_API.g_ret_sts_success;
677: EXCEPTION

Line 676: x_status := FND_API.g_ret_sts_success;

672: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
673: raise Fnd_Api.G_EXC_UNEXPECTED_ERROR;
674: END IF;
675: printDebuglog('Content repository migration End');
676: x_status := FND_API.g_ret_sts_success;
677: EXCEPTION
678: WHEN OTHERS THEN
679: x_status := FND_API.g_ret_sts_error;
680: END master_document_mig;

Line 679: x_status := FND_API.g_ret_sts_error;

675: printDebuglog('Content repository migration End');
676: x_status := FND_API.g_ret_sts_success;
677: EXCEPTION
678: WHEN OTHERS THEN
679: x_status := FND_API.g_ret_sts_error;
680: END master_document_mig;
681:
682: PROCEDURE ocmMigration(errbuf OUT NOCOPY VARCHAR2,
683: retcode OUT NOCOPY VARCHAR2,

Line 715: IF (l_status <> FND_API.G_RET_STS_SUCCESS) THEN

711:
712:
713: query_mig(
714: x_status => l_status);
715: IF (l_status <> FND_API.G_RET_STS_SUCCESS) THEN
716: raise Fnd_Api.G_EXC_UNEXPECTED_ERROR;
717: END IF;
718:
719: update_log(p_code => 'JTF_FM_QUERY_MIG',

Line 716: raise Fnd_Api.G_EXC_UNEXPECTED_ERROR;

712:
713: query_mig(
714: x_status => l_status);
715: IF (l_status <> FND_API.G_RET_STS_SUCCESS) THEN
716: raise Fnd_Api.G_EXC_UNEXPECTED_ERROR;
717: END IF;
718:
719: update_log(p_code => 'JTF_FM_QUERY_MIG',
720: p_old_status => 'START',

Line 740: IF (l_status <> FND_API.G_RET_STS_SUCCESS) THEN

736: -- Migrate the attachments to OCM content item
737: -- based on the logical items
738: master_document_mig(
739: x_status => l_status);
740: IF (l_status <> FND_API.G_RET_STS_SUCCESS) THEN
741: raise Fnd_Api.G_EXC_UNEXPECTED_ERROR;
742: END IF;
743:
744: --g_end_time := SYSDATE;

Line 741: raise Fnd_Api.G_EXC_UNEXPECTED_ERROR;

737: -- based on the logical items
738: master_document_mig(
739: x_status => l_status);
740: IF (l_status <> FND_API.G_RET_STS_SUCCESS) THEN
741: raise Fnd_Api.G_EXC_UNEXPECTED_ERROR;
742: END IF;
743:
744: --g_end_time := SYSDATE;
745: --printReport;