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

Line 2394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2390: x_transaction_flow_exists => x_transaction_flow_exists);
2391:
2392: EXCEPTION
2393: WHEN OTHERS THEN
2394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2395: RAISE_APPLICATION_ERROR(-20000,
2396: 'Exception at POR_UTIL_PKG.check_transaction_flow ' || l_progress ||
2397: 'SQLERRM:' || SQLERRM);
2398:

Line 2524: p_commit IN VARCHAR2 default FND_API.G_FALSE,

2520: -- API to check if the funds can be reserved on the requisition
2521: -- called during preparer checkout
2522: PROCEDURE check_reserve(
2523: p_api_version IN VARCHAR2,
2524: p_commit IN VARCHAR2 default FND_API.G_FALSE,
2525: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
2526: p_validation_level IN number default FND_API.G_VALID_LEVEL_FULL,
2527: x_return_status OUT NOCOPY VARCHAR2,
2528: p_doc_type IN VARCHAR2,

Line 2525: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,

2521: -- called during preparer checkout
2522: PROCEDURE check_reserve(
2523: p_api_version IN VARCHAR2,
2524: p_commit IN VARCHAR2 default FND_API.G_FALSE,
2525: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
2526: p_validation_level IN number default FND_API.G_VALID_LEVEL_FULL,
2527: x_return_status OUT NOCOPY VARCHAR2,
2528: p_doc_type IN VARCHAR2,
2529: p_doc_subtype IN VARCHAR2,

Line 2526: p_validation_level IN number default FND_API.G_VALID_LEVEL_FULL,

2522: PROCEDURE check_reserve(
2523: p_api_version IN VARCHAR2,
2524: p_commit IN VARCHAR2 default FND_API.G_FALSE,
2525: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
2526: p_validation_level IN number default FND_API.G_VALID_LEVEL_FULL,
2527: x_return_status OUT NOCOPY VARCHAR2,
2528: p_doc_type IN VARCHAR2,
2529: p_doc_subtype IN VARCHAR2,
2530: p_dist_data IN ICX_ENC_IN_TYPE,

Line 2573: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2569: x_detailed_results => x_detailed_results);
2570:
2571: EXCEPTION
2572: WHEN OTHERS THEN
2573: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2574: RAISE_APPLICATION_ERROR(-20000,
2575: 'Exception at POR_UTIL_PKG.check_reserve ' || l_progress ||
2576: 'SQLERRM:' || SQLERRM);
2577:

Line 2586: p_commit IN VARCHAR2 default FND_API.G_FALSE,

2582: -- also called for just the labor and expense lines from assign contractor
2583: -- during approver checkout
2584: PROCEDURE check_adjust(
2585: p_api_version IN VARCHAR2,
2586: p_commit IN VARCHAR2 default FND_API.G_FALSE,
2587: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
2588: p_validation_level IN number default FND_API.G_VALID_LEVEL_FULL,
2589: x_return_status OUT NOCOPY VARCHAR2,
2590: p_doc_type IN VARCHAR2,

Line 2587: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,

2583: -- during approver checkout
2584: PROCEDURE check_adjust(
2585: p_api_version IN VARCHAR2,
2586: p_commit IN VARCHAR2 default FND_API.G_FALSE,
2587: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
2588: p_validation_level IN number default FND_API.G_VALID_LEVEL_FULL,
2589: x_return_status OUT NOCOPY VARCHAR2,
2590: p_doc_type IN VARCHAR2,
2591: p_doc_subtype IN VARCHAR2,

Line 2588: p_validation_level IN number default FND_API.G_VALID_LEVEL_FULL,

2584: PROCEDURE check_adjust(
2585: p_api_version IN VARCHAR2,
2586: p_commit IN VARCHAR2 default FND_API.G_FALSE,
2587: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
2588: p_validation_level IN number default FND_API.G_VALID_LEVEL_FULL,
2589: x_return_status OUT NOCOPY VARCHAR2,
2590: p_doc_type IN VARCHAR2,
2591: p_doc_subtype IN VARCHAR2,
2592: p_dist_data IN ICX_ENC_IN_TYPE,

Line 2652: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2648:
2649:
2650: EXCEPTION
2651: WHEN OTHERS THEN
2652: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2653: RAISE_APPLICATION_ERROR(-20000,
2654: 'Exception at POR_UTIL_PKG.check_adjust ' || l_progress ||
2655: 'SQLERRM:' || SQLERRM);
2656:

Line 2664: p_commit IN VARCHAR2 default FND_API.G_FALSE,

2660: -- this can have just a labor line or both a labor and expense line
2661: -- called from assign contractor
2662: PROCEDURE do_reserve_contractor(
2663: p_api_version IN VARCHAR2,
2664: p_commit IN VARCHAR2 default FND_API.G_FALSE,
2665: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
2666: p_validation_level IN number default FND_API.G_VALID_LEVEL_FULL,
2667: x_return_status OUT NOCOPY VARCHAR2,
2668: p_doc_type IN VARCHAR2,

Line 2665: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,

2661: -- called from assign contractor
2662: PROCEDURE do_reserve_contractor(
2663: p_api_version IN VARCHAR2,
2664: p_commit IN VARCHAR2 default FND_API.G_FALSE,
2665: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
2666: p_validation_level IN number default FND_API.G_VALID_LEVEL_FULL,
2667: x_return_status OUT NOCOPY VARCHAR2,
2668: p_doc_type IN VARCHAR2,
2669: p_doc_subtype IN VARCHAR2,

Line 2666: p_validation_level IN number default FND_API.G_VALID_LEVEL_FULL,

2662: PROCEDURE do_reserve_contractor(
2663: p_api_version IN VARCHAR2,
2664: p_commit IN VARCHAR2 default FND_API.G_FALSE,
2665: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
2666: p_validation_level IN number default FND_API.G_VALID_LEVEL_FULL,
2667: x_return_status OUT NOCOPY VARCHAR2,
2668: p_doc_type IN VARCHAR2,
2669: p_doc_subtype IN VARCHAR2,
2670: p_doc_level IN VARCHAR2,

Line 2710: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND

2706: -- only if it is PRE-APPROVED
2707: -- this is because now we have already reserved funds so
2708: -- it can go to APPROVED (except if it was made REQUIRES_REAPPROVAL
2709: -- previously)
2710: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND
2711: (x_po_return_code = PO_DOCUMENT_FUNDS_GRP.g_return_SUCCESS OR
2712: x_po_return_code = PO_DOCUMENT_FUNDS_GRP.g_return_WARNING))
2713: THEN
2714:

Line 2741: IF (p_commit = FND_API.G_TRUE)

2737: AND authorization_status = 'PRE-APPROVED';
2738:
2739: l_progress := '040';
2740:
2741: IF (p_commit = FND_API.G_TRUE)
2742: THEN
2743: COMMIT;
2744: END IF;
2745:

Line 2750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2746: END IF;
2747:
2748: EXCEPTION
2749: WHEN OTHERS THEN
2750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2751: RAISE_APPLICATION_ERROR(-20000,
2752: 'Exception at POR_UTIL_PKG.do_reserve_contractor ' || l_progress ||
2753: 'SQLERRM:' || SQLERRM);
2754:

Line 2763: p_commit IN VARCHAR2 default FND_API.G_FALSE,

2759: -- this can have just a labor line or both a labor and expense line
2760: -- called from assign contractor
2761: PROCEDURE do_unreserve_contractor(
2762: p_api_version IN VARCHAR2,
2763: p_commit IN VARCHAR2 default FND_API.G_FALSE,
2764: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
2765: p_validation_level IN number default FND_API.G_VALID_LEVEL_FULL,
2766: x_return_status OUT NOCOPY VARCHAR2,
2767: p_doc_type IN VARCHAR2,

Line 2764: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,

2760: -- called from assign contractor
2761: PROCEDURE do_unreserve_contractor(
2762: p_api_version IN VARCHAR2,
2763: p_commit IN VARCHAR2 default FND_API.G_FALSE,
2764: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
2765: p_validation_level IN number default FND_API.G_VALID_LEVEL_FULL,
2766: x_return_status OUT NOCOPY VARCHAR2,
2767: p_doc_type IN VARCHAR2,
2768: p_doc_subtype IN VARCHAR2,

Line 2765: p_validation_level IN number default FND_API.G_VALID_LEVEL_FULL,

2761: PROCEDURE do_unreserve_contractor(
2762: p_api_version IN VARCHAR2,
2763: p_commit IN VARCHAR2 default FND_API.G_FALSE,
2764: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
2765: p_validation_level IN number default FND_API.G_VALID_LEVEL_FULL,
2766: x_return_status OUT NOCOPY VARCHAR2,
2767: p_doc_type IN VARCHAR2,
2768: p_doc_subtype IN VARCHAR2,
2769: p_doc_level IN VARCHAR2,

Line 2808: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND

2804: -- update the status of the requisition to PRE-APPROVED
2805: -- only if it is APRROVED (should be always APPROVED)
2806: -- this is because now we have now unreserved funds so
2807: -- it can no longer remain APPROVED
2808: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND
2809: (x_po_return_code = PO_DOCUMENT_FUNDS_GRP.g_return_SUCCESS OR
2810: x_po_return_code = PO_DOCUMENT_FUNDS_GRP.g_return_WARNING))
2811: THEN
2812:

Line 2839: IF (p_commit = FND_API.G_TRUE)

2835: AND authorization_status = 'APPROVED';
2836:
2837: l_progress := '040';
2838:
2839: IF (p_commit = FND_API.G_TRUE)
2840: THEN
2841: COMMIT;
2842: END IF;
2843:

Line 2848: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2844: END IF;
2845:
2846: EXCEPTION
2847: WHEN OTHERS THEN
2848: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2849: RAISE_APPLICATION_ERROR(-20000,
2850: 'Exception at POR_UTIL_PKG.do_unreserve_contractor ' || l_progress ||
2851: 'SQLERRM:' || SQLERRM);
2852:

Line 2941: p_commit IN VARCHAR2 default FND_API.G_FALSE,

2937:
2938: PROCEDURE create_info_template
2939: (p_api_version IN NUMBER,
2940: x_return_status OUT NOCOPY VARCHAR2,
2941: p_commit IN VARCHAR2 default FND_API.G_FALSE,
2942: p_old_reqline_id IN NUMBER,
2943: p_new_reqline_id IN NUMBER,
2944: p_item_id IN NUMBER,
2945: p_category_id IN NUMBER) IS

Line 2992: x_return_status := FND_API.G_RET_STS_SUCCESS;

2988: BEGIN
2989:
2990: l_progress := '010';
2991: -- Initialize API return status to success
2992: x_return_status := FND_API.G_RET_STS_SUCCESS;
2993:
2994: --Check API Call Compatibility
2995:
2996: IF NOT FND_API.Compatible_API_Call(

Line 2996: IF NOT FND_API.Compatible_API_Call(

2992: x_return_status := FND_API.G_RET_STS_SUCCESS;
2993:
2994: --Check API Call Compatibility
2995:
2996: IF NOT FND_API.Compatible_API_Call(
2997: p_current_version_number => l_api_version,
2998: p_caller_version_number => p_api_version,
2999: p_api_name => l_api_name,
3000: p_pkg_name => 'POR_UTIL_PKG')

Line 3007: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3003: FND_LOG.string(log_level => FND_LOG.LEVEL_STATEMENT,
3004: module => l_api_name || '.begin',
3005: message => l_progress||' - Checking API Compatibility - Failed');
3006: END IF;
3007: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3008: END IF;
3009:
3010: OPEN c_parent_info_template;
3011:

Line 3178: IF FND_API.To_Boolean( p_commit ) THEN

3174:
3175:
3176: --Commit the transaction
3177: -- Standard check of p_commit.
3178: IF FND_API.To_Boolean( p_commit ) THEN
3179: l_progress := '070';
3180: COMMIT;
3181: END IF;
3182:

Line 3191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3187: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3188: l_log_msg := 'Error in create_info_template : Progress= ' || l_progress;
3189: FND_LOG.STRING(G_LEVEL_STATEMENT,l_api_name, l_log_msg);
3190: END IF;
3191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3192: --Close the cursor
3193: IF (c_parent_info_template%ISOPEN) THEN
3194: CLOSE c_parent_info_template;
3195: END IF;