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

Line 389: IF (x_record_already_exist_tbl(i) = FND_API.G_FALSE) THEN

385: -- Created an associative array to store what id has appeared.
386: l_duplicate_flag_tbl.EXTEND(p_po_exhibit_details_id_tbl.COUNT);
387:
388: FOR i IN 1..p_po_exhibit_details_id_tbl.COUNT LOOP
389: IF (x_record_already_exist_tbl(i) = FND_API.G_FALSE) THEN
390:
391: IF (l_distinct_id_list.EXISTS(p_po_exhibit_details_id_tbl(i))) THEN
392:
393: l_duplicate_flag_tbl(i) := FND_API.G_TRUE;

Line 393: l_duplicate_flag_tbl(i) := FND_API.G_TRUE;

389: IF (x_record_already_exist_tbl(i) = FND_API.G_FALSE) THEN
390:
391: IF (l_distinct_id_list.EXISTS(p_po_exhibit_details_id_tbl(i))) THEN
392:
393: l_duplicate_flag_tbl(i) := FND_API.G_TRUE;
394: ELSE
395: l_duplicate_flag_tbl(i) := FND_API.G_FALSE;
396:
397: l_distinct_id_list(p_po_exhibit_details_id_tbl(i)) := 1;

Line 395: l_duplicate_flag_tbl(i) := FND_API.G_FALSE;

391: IF (l_distinct_id_list.EXISTS(p_po_exhibit_details_id_tbl(i))) THEN
392:
393: l_duplicate_flag_tbl(i) := FND_API.G_TRUE;
394: ELSE
395: l_duplicate_flag_tbl(i) := FND_API.G_FALSE;
396:
397: l_distinct_id_list(p_po_exhibit_details_id_tbl(i)) := 1;
398: END IF;
399:

Line 450: AND x_record_already_exist_tbl(i) = FND_API.G_FALSE

446: CREATED_BY,
447: LAST_UPDATE_LOGIN
448: FROM po_exhibit_details
449: WHERE po_exhibit_details_id = p_po_exhibit_details_id_tbl(i)
450: AND x_record_already_exist_tbl(i) = FND_API.G_FALSE
451: AND l_duplicate_flag_tbl(i) = FND_API.G_FALSE;
452:
453: d_position := 20;
454: IF (PO_LOG.d_stmt) THEN

Line 451: AND l_duplicate_flag_tbl(i) = FND_API.G_FALSE;

447: LAST_UPDATE_LOGIN
448: FROM po_exhibit_details
449: WHERE po_exhibit_details_id = p_po_exhibit_details_id_tbl(i)
450: AND x_record_already_exist_tbl(i) = FND_API.G_FALSE
451: AND l_duplicate_flag_tbl(i) = FND_API.G_FALSE;
452:
453: d_position := 20;
454: IF (PO_LOG.d_stmt) THEN
455: PO_LOG.stmt(d_module, d_position, 'transfer count = ' || SQL%ROWCOUNT);

Line 464: AND x_record_already_exist_tbl(i) = FND_API.G_TRUE;

460: SET delete_flag = p_delete_flag_tbl(i)
461: WHERE po_exhibit_details_id = p_po_exhibit_details_id_tbl(i)
462: AND draft_id = p_draft_id_tbl(i)
463: AND NVL(delete_flag, 'N') <> 'Y' -- bug5570989
464: AND x_record_already_exist_tbl(i) = FND_API.G_TRUE;
465:
466: d_position := 30;
467:
468: IF (PO_LOG.d_stmt) THEN

Line 485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

481: PO_MESSAGE_S.add_exc_msg
482: ( p_pkg_name => d_pkg_name,
483: p_procedure_name => d_api_name || '.' || d_position
484: );
485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
486: END sync_draft_from_txn;
487:
488: -----------------------------------------------------------------------
489: --Start of Comments

Line 556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

552: PO_MESSAGE_S.add_exc_msg
553: ( p_pkg_name => d_pkg_name,
554: p_procedure_name => d_api_name || '.' || d_position
555: );
556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
557: END sync_draft_from_txn;
558:
559:
560: --Start of Comments

Line 569: -- If only draft_id is provided, this program returns FND_API.G_TRUE for

565: -- None
566: --Function:
567: -- Checks whether there is any draft changes in the draft table
568: -- given the draft_id or draft_id + po_exhibit_details_id
569: -- If only draft_id is provided, this program returns FND_API.G_TRUE for
570: -- any draft changes in this table for the draft
571: -- If the whole primary key is provided (draft_id + exhibit id), then
572: -- it return true if there is draft for this particular record in
573: -- the draft table

Line 585: -- FND_API.G_TRUE if there are draft changes

581: --OUT:
582: --Returns:
583: -- Array of flags indicating whether draft changes exist for the corresponding
584: -- entry in the input parameter. For each entry in the returning array:
585: -- FND_API.G_TRUE if there are draft changes
586: -- FND_API.G_FALSE if there aren't draft changes
587: --Notes:
588: --Testing:
589: --End of Comments

Line 586: -- FND_API.G_FALSE if there aren't draft changes

582: --Returns:
583: -- Array of flags indicating whether draft changes exist for the corresponding
584: -- entry in the input parameter. For each entry in the returning array:
585: -- FND_API.G_TRUE if there are draft changes
586: -- FND_API.G_FALSE if there aren't draft changes
587: --Notes:
588: --Testing:
589: --End of Comments
590: ------------------------------------------------------------------------

Line 616: l_dft_exists_tbl(i) := FND_API.G_FALSE;

612: l_dft_exists_tbl.extend(p_draft_id_tbl.COUNT);
613:
614: FOR i IN 1..l_index_tbl.COUNT LOOP
615: l_index_tbl(i) := i;
616: l_dft_exists_tbl(i) := FND_API.G_FALSE;
617: END LOOP;
618:
619: d_position := 10;
620:

Line 654: l_dft_exists_tbl(l_dft_exists_index_tbl(i)) := FND_API.G_TRUE;

650:
651: d_position := 40;
652:
653: FOR i IN 1..l_dft_exists_index_tbl.COUNT LOOP
654: l_dft_exists_tbl(l_dft_exists_index_tbl(i)) := FND_API.G_TRUE;
655: END LOOP;
656:
657: IF (PO_LOG.d_stmt) THEN
658: PO_LOG.stmt(d_module, d_position, '# of records that have dft changes',

Line 670: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

666: PO_MESSAGE_S.add_exc_msg
667: ( p_pkg_name => d_pkg_name,
668: p_procedure_name => d_api_name || '.' || d_position
669: );
670: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
671: END draft_changes_exist;
672:
673: -----------------------------------------------------------------------
674: --Start of Comments

Line 691: -- FND_API.G_TRUE if there are draft changes

687: -- exhibit unique identifier
688: --IN OUT:
689: --OUT:
690: --Returns:
691: -- FND_API.G_TRUE if there are draft changes
692: -- FND_API.G_FALSE if there aren't draft changes
693: --Notes:
694: --Testing:
695: --End of Comments

Line 692: -- FND_API.G_FALSE if there aren't draft changes

688: --IN OUT:
689: --OUT:
690: --Returns:
691: -- FND_API.G_TRUE if there are draft changes
692: -- FND_API.G_FALSE if there aren't draft changes
693: --Notes:
694: --Testing:
695: --End of Comments
696: ------------------------------------------------------------------------

Line 731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

727: PO_MESSAGE_S.add_exc_msg
728: ( p_pkg_name => d_pkg_name,
729: p_procedure_name => d_api_name || '.' || d_position
730: );
731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
732: END draft_changes_exist;
733:
734:
735:

Line 865: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

861: PO_MESSAGE_S.add_exc_msg
862: ( p_pkg_name => d_pkg_name,
863: p_procedure_name => d_api_name || '.' || d_position
864: );
865: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
866: END merge_changes;
867:
868:
869: -----------------------------------------------------------------------

Line 904: IF (p_draft_info.exhibits_changed = FND_API.G_FALSE) THEN

900: IF (PO_LOG.d_proc) THEN
901: PO_LOG.proc_begin(d_module);
902: END IF;
903:
904: IF (p_draft_info.exhibits_changed = FND_API.G_FALSE) THEN
905: IF (PO_LOG.d_stmt) THEN
906: PO_LOG.stmt(d_module, d_position, 'no change-no need to apply');
907: END IF;
908:

Line 925: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

921: PO_MESSAGE_S.add_exc_msg
922: ( p_pkg_name => d_pkg_name,
923: p_procedure_name => d_api_name || '.' || d_position
924: );
925: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
926: END apply_changes;
927:
928:
929:

Line 983: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

979: PO_MESSAGE_S.add_exc_msg
980: ( p_pkg_name => d_pkg_name,
981: p_procedure_name => d_api_name || '.' || d_position
982: );
983: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
984: END delete_rows;
985:
986: -----------------------------------------------------------------------
987: --Start of Comments

Line 1090: x_return_status := FND_API.G_RET_STS_ERROR;

1086:
1087: -- Records exists- Given exhibit is already been used by the Exhibit
1088: ELSIF( l_is_valid_exhibit = 'N') THEN
1089:
1090: x_return_status := FND_API.G_RET_STS_ERROR;
1091: x_return_msg := 'EXHIBIT_NUM_USED_BY_ELIN';
1092: RETURN;
1093: END IF;
1094:

Line 1150: x_return_status := FND_API.G_RET_STS_ERROR;

1146:
1147: -- Records exists- Given exhibit is already been used by the Exhibit
1148: ELSIF( l_is_valid_exhibit = 'N') THEN
1149:
1150: x_return_status := FND_API.G_RET_STS_ERROR;
1151: x_return_msg := 'EXHIBIT_NUM_USED_BY_ELIN';
1152: RETURN;
1153:
1154: END IF;

Line 1164: x_return_status := FND_API.G_RET_STS_SUCCESS;

1160: IF (PO_LOG.d_proc) THEN
1161: PO_LOG.proc_end(d_module);
1162: END IF;
1163:
1164: x_return_status := FND_API.G_RET_STS_SUCCESS;
1165:
1166:
1167: EXCEPTION
1168: WHEN OTHERS THEN

Line 1169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1165:
1166:
1167: EXCEPTION
1168: WHEN OTHERS THEN
1169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1170: IF (PO_LOG.d_exc) THEN
1171: PO_LOG.exc(d_module,SQLCODE || SQLERRM);
1172: END IF;
1173: RAISE;

Line 1252: x_return_status := FND_API.G_RET_STS_SUCCESS;

1248: IF (PO_LOG.d_proc) THEN
1249: PO_LOG.proc_end(d_module);
1250: END IF;
1251:
1252: x_return_status := FND_API.G_RET_STS_SUCCESS;
1253:
1254:
1255: EXCEPTION
1256: WHEN OTHERS THEN

Line 1257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1253:
1254:
1255: EXCEPTION
1256: WHEN OTHERS THEN
1257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1258: IF (PO_LOG.d_exc) THEN
1259: PO_LOG.exc(d_module,SQLCODE || SQLERRM);
1260: END IF;
1261: RAISE;

Line 1429: p_init_msg_list => FND_API.G_TRUE,

1425: END IF;
1426:
1427: okc_cdrl_pvt.copy_cdrl_for_exhibit (
1428: p_api_version => 1.0,
1429: p_init_msg_list => FND_API.G_TRUE,
1430: p_commit => FND_API.G_FALSE,
1431: p_doc_type => l_document_type,
1432: p_doc_id => l_docid,
1433: p_doc_version => NULL,

Line 1430: p_commit => FND_API.G_FALSE,

1426:
1427: okc_cdrl_pvt.copy_cdrl_for_exhibit (
1428: p_api_version => 1.0,
1429: p_init_msg_list => FND_API.G_TRUE,
1430: p_commit => FND_API.G_FALSE,
1431: p_doc_type => l_document_type,
1432: p_doc_id => l_docid,
1433: p_doc_version => NULL,
1434: p_mode => NULL,

Line 1454: x_return_status := l_return_status;--FND_API.G_RET_STS_SUCCESS;

1450: IF (PO_LOG.d_proc) THEN
1451: PO_LOG.proc_end(d_module);
1452: END IF;
1453:
1454: x_return_status := l_return_status;--FND_API.G_RET_STS_SUCCESS;
1455: x_return_msg := l_msg_data;
1456:
1457: EXCEPTION
1458: WHEN OTHERS THEN

Line 1459: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1455: x_return_msg := l_msg_data;
1456:
1457: EXCEPTION
1458: WHEN OTHERS THEN
1459: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1460: IF (PO_LOG.d_exc) THEN
1461: PO_LOG.exc(d_module,SQLCODE || SQLERRM);
1462: END IF;
1463: RAISE;

Line 1559: p_init_msg_list => FND_API.G_TRUE,

1555: l_exhibit_tbl(1) := p_exhibit_name;
1556:
1557: okc_cdrl_pvt.delete_cdrl_for_exhibits (
1558: p_api_version => 1.0,
1559: p_init_msg_list => FND_API.G_TRUE,
1560: p_commit => FND_API.G_FALSE,
1561: p_doc_type => l_document_type,
1562: p_doc_id => l_docid,
1563: p_doc_version => NULL,

Line 1560: p_commit => FND_API.G_FALSE,

1556:
1557: okc_cdrl_pvt.delete_cdrl_for_exhibits (
1558: p_api_version => 1.0,
1559: p_init_msg_list => FND_API.G_TRUE,
1560: p_commit => FND_API.G_FALSE,
1561: p_doc_type => l_document_type,
1562: p_doc_id => l_docid,
1563: p_doc_version => NULL,
1564: p_mode => NULL,

Line 1583: x_return_status := l_return_status;--FND_API.G_RET_STS_SUCCESS;

1579: IF (PO_LOG.d_proc) THEN
1580: PO_LOG.proc_end(d_module);
1581: END IF;
1582:
1583: x_return_status := l_return_status;--FND_API.G_RET_STS_SUCCESS;
1584: x_return_msg := l_msg_data;
1585:
1586: EXCEPTION
1587: WHEN OTHERS THEN

Line 1588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1584: x_return_msg := l_msg_data;
1585:
1586: EXCEPTION
1587: WHEN OTHERS THEN
1588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1589: IF (PO_LOG.d_exc) THEN
1590: PO_LOG.exc(d_module,SQLCODE || SQLERRM);
1591: END IF;
1592: RAISE;