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 2744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2740: x_transaction_flow_exists => x_transaction_flow_exists);
2741:
2742: EXCEPTION
2743: WHEN OTHERS THEN
2744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2745: RAISE_APPLICATION_ERROR(-20000,
2746: 'Exception at POR_UTIL_PKG.check_transaction_flow ' || l_progress ||
2747: 'SQLERRM:' || SQLERRM);
2748:

Line 2893: p_commit IN VARCHAR2 default FND_API.G_FALSE,

2889: -- API to check if the funds can be reserved on the requisition
2890: -- called during preparer checkout
2891: PROCEDURE check_reserve(
2892: p_api_version IN VARCHAR2,
2893: p_commit IN VARCHAR2 default FND_API.G_FALSE,
2894: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
2895: p_validation_level IN number default FND_API.G_VALID_LEVEL_FULL,
2896: x_return_status OUT NOCOPY VARCHAR2,
2897: p_doc_type IN VARCHAR2,

Line 2894: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,

2890: -- called during preparer checkout
2891: PROCEDURE check_reserve(
2892: p_api_version IN VARCHAR2,
2893: p_commit IN VARCHAR2 default FND_API.G_FALSE,
2894: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
2895: p_validation_level IN number default FND_API.G_VALID_LEVEL_FULL,
2896: x_return_status OUT NOCOPY VARCHAR2,
2897: p_doc_type IN VARCHAR2,
2898: p_doc_subtype IN VARCHAR2,

Line 2895: p_validation_level IN number default FND_API.G_VALID_LEVEL_FULL,

2891: PROCEDURE check_reserve(
2892: p_api_version IN VARCHAR2,
2893: p_commit IN VARCHAR2 default FND_API.G_FALSE,
2894: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
2895: p_validation_level IN number default FND_API.G_VALID_LEVEL_FULL,
2896: x_return_status OUT NOCOPY VARCHAR2,
2897: p_doc_type IN VARCHAR2,
2898: p_doc_subtype IN VARCHAR2,
2899: p_dist_data IN ICX_ENC_IN_TYPE,

Line 2942: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2938: x_detailed_results => x_detailed_results);
2939:
2940: EXCEPTION
2941: WHEN OTHERS THEN
2942: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2943: RAISE_APPLICATION_ERROR(-20000,
2944: 'Exception at POR_UTIL_PKG.check_reserve ' || l_progress ||
2945: 'SQLERRM:' || SQLERRM);
2946:

Line 2955: p_commit IN VARCHAR2 default FND_API.G_FALSE,

2951: -- also called for just the labor and expense lines from assign contractor
2952: -- during approver checkout
2953: PROCEDURE check_adjust(
2954: p_api_version IN VARCHAR2,
2955: p_commit IN VARCHAR2 default FND_API.G_FALSE,
2956: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
2957: p_validation_level IN number default FND_API.G_VALID_LEVEL_FULL,
2958: x_return_status OUT NOCOPY VARCHAR2,
2959: p_doc_type IN VARCHAR2,

Line 2956: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,

2952: -- during approver checkout
2953: PROCEDURE check_adjust(
2954: p_api_version IN VARCHAR2,
2955: p_commit IN VARCHAR2 default FND_API.G_FALSE,
2956: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
2957: p_validation_level IN number default FND_API.G_VALID_LEVEL_FULL,
2958: x_return_status OUT NOCOPY VARCHAR2,
2959: p_doc_type IN VARCHAR2,
2960: p_doc_subtype IN VARCHAR2,

Line 2957: p_validation_level IN number default FND_API.G_VALID_LEVEL_FULL,

2953: PROCEDURE check_adjust(
2954: p_api_version IN VARCHAR2,
2955: p_commit IN VARCHAR2 default FND_API.G_FALSE,
2956: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
2957: p_validation_level IN number default FND_API.G_VALID_LEVEL_FULL,
2958: x_return_status OUT NOCOPY VARCHAR2,
2959: p_doc_type IN VARCHAR2,
2960: p_doc_subtype IN VARCHAR2,
2961: p_dist_data IN ICX_ENC_IN_TYPE,

Line 3021: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3017:
3018:
3019: EXCEPTION
3020: WHEN OTHERS THEN
3021: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3022: RAISE_APPLICATION_ERROR(-20000,
3023: 'Exception at POR_UTIL_PKG.check_adjust ' || l_progress ||
3024: 'SQLERRM:' || SQLERRM);
3025:

Line 3033: p_commit IN VARCHAR2 default FND_API.G_FALSE,

3029: -- this can have just a labor line or both a labor and expense line
3030: -- called from assign contractor
3031: PROCEDURE do_reserve_contractor(
3032: p_api_version IN VARCHAR2,
3033: p_commit IN VARCHAR2 default FND_API.G_FALSE,
3034: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
3035: p_validation_level IN number default FND_API.G_VALID_LEVEL_FULL,
3036: x_return_status OUT NOCOPY VARCHAR2,
3037: p_doc_type IN VARCHAR2,

Line 3034: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,

3030: -- called from assign contractor
3031: PROCEDURE do_reserve_contractor(
3032: p_api_version IN VARCHAR2,
3033: p_commit IN VARCHAR2 default FND_API.G_FALSE,
3034: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
3035: p_validation_level IN number default FND_API.G_VALID_LEVEL_FULL,
3036: x_return_status OUT NOCOPY VARCHAR2,
3037: p_doc_type IN VARCHAR2,
3038: p_doc_subtype IN VARCHAR2,

Line 3035: p_validation_level IN number default FND_API.G_VALID_LEVEL_FULL,

3031: PROCEDURE do_reserve_contractor(
3032: p_api_version IN VARCHAR2,
3033: p_commit IN VARCHAR2 default FND_API.G_FALSE,
3034: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
3035: p_validation_level IN number default FND_API.G_VALID_LEVEL_FULL,
3036: x_return_status OUT NOCOPY VARCHAR2,
3037: p_doc_type IN VARCHAR2,
3038: p_doc_subtype IN VARCHAR2,
3039: p_doc_level IN VARCHAR2,

Line 3079: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND

3075: -- only if it is PRE-APPROVED
3076: -- this is because now we have already reserved funds so
3077: -- it can go to APPROVED (except if it was made REQUIRES_REAPPROVAL
3078: -- previously)
3079: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND
3080: (x_po_return_code = PO_DOCUMENT_FUNDS_GRP.g_return_SUCCESS OR
3081: x_po_return_code = PO_DOCUMENT_FUNDS_GRP.g_return_WARNING))
3082: THEN
3083:

Line 3110: IF (p_commit = FND_API.G_TRUE)

3106: AND authorization_status = 'PRE-APPROVED';
3107:
3108: l_progress := '040';
3109:
3110: IF (p_commit = FND_API.G_TRUE)
3111: THEN
3112: COMMIT;
3113: END IF;
3114:

Line 3119: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3115: END IF;
3116:
3117: EXCEPTION
3118: WHEN OTHERS THEN
3119: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3120: RAISE_APPLICATION_ERROR(-20000,
3121: 'Exception at POR_UTIL_PKG.do_reserve_contractor ' || l_progress ||
3122: 'SQLERRM:' || SQLERRM);
3123:

Line 3132: p_commit IN VARCHAR2 default FND_API.G_FALSE,

3128: -- this can have just a labor line or both a labor and expense line
3129: -- called from assign contractor
3130: PROCEDURE do_unreserve_contractor(
3131: p_api_version IN VARCHAR2,
3132: p_commit IN VARCHAR2 default FND_API.G_FALSE,
3133: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
3134: p_validation_level IN number default FND_API.G_VALID_LEVEL_FULL,
3135: x_return_status OUT NOCOPY VARCHAR2,
3136: p_doc_type IN VARCHAR2,

Line 3133: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,

3129: -- called from assign contractor
3130: PROCEDURE do_unreserve_contractor(
3131: p_api_version IN VARCHAR2,
3132: p_commit IN VARCHAR2 default FND_API.G_FALSE,
3133: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
3134: p_validation_level IN number default FND_API.G_VALID_LEVEL_FULL,
3135: x_return_status OUT NOCOPY VARCHAR2,
3136: p_doc_type IN VARCHAR2,
3137: p_doc_subtype IN VARCHAR2,

Line 3134: p_validation_level IN number default FND_API.G_VALID_LEVEL_FULL,

3130: PROCEDURE do_unreserve_contractor(
3131: p_api_version IN VARCHAR2,
3132: p_commit IN VARCHAR2 default FND_API.G_FALSE,
3133: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
3134: p_validation_level IN number default FND_API.G_VALID_LEVEL_FULL,
3135: x_return_status OUT NOCOPY VARCHAR2,
3136: p_doc_type IN VARCHAR2,
3137: p_doc_subtype IN VARCHAR2,
3138: p_doc_level IN VARCHAR2,

Line 3177: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND

3173: -- update the status of the requisition to PRE-APPROVED
3174: -- only if it is APRROVED (should be always APPROVED)
3175: -- this is because now we have now unreserved funds so
3176: -- it can no longer remain APPROVED
3177: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND
3178: (x_po_return_code = PO_DOCUMENT_FUNDS_GRP.g_return_SUCCESS OR
3179: x_po_return_code = PO_DOCUMENT_FUNDS_GRP.g_return_WARNING))
3180: THEN
3181:

Line 3208: IF (p_commit = FND_API.G_TRUE)

3204: AND authorization_status = 'APPROVED';
3205:
3206: l_progress := '040';
3207:
3208: IF (p_commit = FND_API.G_TRUE)
3209: THEN
3210: COMMIT;
3211: END IF;
3212:

Line 3217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3213: END IF;
3214:
3215: EXCEPTION
3216: WHEN OTHERS THEN
3217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3218: RAISE_APPLICATION_ERROR(-20000,
3219: 'Exception at POR_UTIL_PKG.do_unreserve_contractor ' || l_progress ||
3220: 'SQLERRM:' || SQLERRM);
3221:

Line 3310: p_commit IN VARCHAR2 default FND_API.G_FALSE,

3306:
3307: PROCEDURE create_info_template
3308: (p_api_version IN NUMBER,
3309: x_return_status OUT NOCOPY VARCHAR2,
3310: p_commit IN VARCHAR2 default FND_API.G_FALSE,
3311: p_old_reqline_id IN NUMBER,
3312: p_new_reqline_id IN NUMBER,
3313: p_item_id IN NUMBER,
3314: p_category_id IN NUMBER) IS

Line 3361: x_return_status := FND_API.G_RET_STS_SUCCESS;

3357: BEGIN
3358:
3359: l_progress := '010';
3360: -- Initialize API return status to success
3361: x_return_status := FND_API.G_RET_STS_SUCCESS;
3362:
3363: --Check API Call Compatibility
3364:
3365: IF NOT FND_API.Compatible_API_Call(

Line 3365: IF NOT FND_API.Compatible_API_Call(

3361: x_return_status := FND_API.G_RET_STS_SUCCESS;
3362:
3363: --Check API Call Compatibility
3364:
3365: IF NOT FND_API.Compatible_API_Call(
3366: p_current_version_number => l_api_version,
3367: p_caller_version_number => p_api_version,
3368: p_api_name => l_api_name,
3369: p_pkg_name => 'POR_UTIL_PKG')

Line 3376: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3372: FND_LOG.string(log_level => FND_LOG.LEVEL_STATEMENT,
3373: module => l_api_name || '.begin',
3374: message => l_progress||' - Checking API Compatibility - Failed');
3375: END IF;
3376: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3377: END IF;
3378:
3379: OPEN c_parent_info_template;
3380:

Line 3547: IF FND_API.To_Boolean( p_commit ) THEN

3543:
3544:
3545: --Commit the transaction
3546: -- Standard check of p_commit.
3547: IF FND_API.To_Boolean( p_commit ) THEN
3548: l_progress := '070';
3549: COMMIT;
3550: END IF;
3551:

Line 3560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3556: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3557: l_log_msg := 'Error in create_info_template : Progress= ' || l_progress;
3558: FND_LOG.STRING(G_LEVEL_STATEMENT,l_api_name, l_log_msg);
3559: END IF;
3560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3561: --Close the cursor
3562: IF (c_parent_info_template%ISOPEN) THEN
3563: CLOSE c_parent_info_template;
3564: END IF;

Line 3891: x_return_status := FND_API.G_RET_STS_SUCCESS;

3887:
3888: l_progress := '060';
3889: l_log_msg := 'After AutoCreate_User_Attrs';
3890:
3891: x_return_status := FND_API.G_RET_STS_SUCCESS;
3892:
3893: EXCEPTION
3894: WHEN OTHERS THEN
3895: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN