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

Line 7205: x_return_status := FND_API.G_RET_STS_SUCCESS;

7201:
7202: END LOOP;
7203: x_space_assign_emp_tbl := l_space_assign_emp_tbl;
7204:
7205: x_return_status := FND_API.G_RET_STS_SUCCESS;
7206: PNP_DEBUG_PKG.DEBUG('pnp_util_func.get_space_assignments (-)');
7207:
7208: EXCEPTION
7209: WHEN OTHERS THEN

Line 7212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7208: EXCEPTION
7209: WHEN OTHERS THEN
7210: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
7211: fnd_message.set_token('ERR_MSG',l_api_name||'='|| sqlerrm);
7212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7213: PNP_DEBUG_PKG.DEBUG('OTHERS EXCEPTION');
7214:
7215:
7216: END get_space_assignments;

Line 7315: x_return_status := FND_API.G_RET_STS_SUCCESS;

7311: AND NVL(cust_assign_end_date,to_date('12/31/4712','mm/dd/yyyy')) > p_end_date AND
7312: cust_assign_start_date <= p_end_date_old);
7313:
7314: BEGIN
7315: x_return_status := FND_API.G_RET_STS_SUCCESS;
7316:
7317: PNP_DEBUG_PKG.log('----------------------------------');
7318: PNP_DEBUG_PKG.log('pnp_util_func.validate_assignment_for_date (+)');
7319: PNP_DEBUG_PKG.log('Validate Assignment for date:INPUT');

Line 7329: x_return_status := FND_API.G_RET_STS_ERROR;

7325:
7326: IF p_start_date > p_start_date_old THEN
7327:
7328: FOR validate_start_date_rec in validate_start_date_cursor LOOP
7329: x_return_status := FND_API.G_RET_STS_ERROR;
7330: Raise USER_DEF_ERROR;
7331: EXIT;
7332: END LOOP;
7333:

Line 7339: x_return_status := FND_API.G_RET_STS_ERROR;

7335:
7336: IF p_end_date < p_end_date_old THEN
7337:
7338: FOR validate_end_date_rec in validate_end_date_cursor LOOP
7339: x_return_status := FND_API.G_RET_STS_ERROR;
7340: Raise USER_DEF_ERROR;
7341: EXIT;
7342: END LOOP;
7343:

Line 7351: x_return_status := FND_API.G_RET_STS_ERROR;

7347:
7348: EXCEPTION
7349:
7350: WHEN USER_DEF_ERROR THEN
7351: x_return_status := FND_API.G_RET_STS_ERROR;
7352: fnd_message.set_name('PN','PN_INVALID_DATE_EFFECTIVITY');
7353: PNP_DEBUG_PKG.log('Assignment found for dates');
7354:
7355: WHEN OTHERS THEN

Line 7358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7354:
7355: WHEN OTHERS THEN
7356: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
7357: fnd_message.set_token('ERR_MSG',l_api_name||'='|| sqlerrm);
7358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7359: PNP_DEBUG_PKG.log('OTHERS ERROR');
7360:
7361: END validate_assignment_for_date;
7362:

Line 7418: x_return_status := FND_API.G_RET_STS_SUCCESS;

7414: PNP_DEBUG_PKG.log('Assignable Area : ' || p_assignable_area);
7415: PNP_DEBUG_PKG.log('----------------------------------');
7416: PNP_DEBUG_PKG.log('Calling get space assignments');
7417:
7418: x_return_status := FND_API.G_RET_STS_SUCCESS;
7419: Get_space_assignments (
7420: p_location_id => p_location_id,
7421: p_start_date => p_start_date,
7422: p_end_date => p_end_date,

Line 7429: IF not(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

7425: x_return_status => x_return_status,
7426: x_return_message => x_return_message
7427: );
7428:
7429: IF not(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
7430: PNP_DEBUG_PKG.log('Error in get space_assignments');
7431: Raise unexpected_error;
7432: END IF;
7433:

Line 7517: x_return_status := FND_API.G_RET_STS_ERROR;

7513: EXCEPTION
7514:
7515:
7516: WHEN UNEXPECTED_ERROR THEN
7517: x_return_status := FND_API.G_RET_STS_ERROR;
7518: PNP_DEBUG_PKG.log('UNEXPECTED ERROR');
7519:
7520: WHEN OTHERS THEN
7521: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');

Line 7523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7519:
7520: WHEN OTHERS THEN
7521: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
7522: fnd_message.set_token('ERR_MSG',l_api_name||'='|| sqlerrm);
7523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7524: PNP_DEBUG_PKG.log('OTHERS ERROR');
7525:
7526: END validate_assignable_area;
7527:

Line 7594: x_return_status := FND_API.G_RET_STS_SUCCESS;

7590: AND active_end_date = p_active_end_date_old;
7591:
7592: BEGIN
7593: -- Remove after debug
7594: x_return_status := FND_API.G_RET_STS_SUCCESS;
7595:
7596: PNP_DEBUG_PKG.log('---------------------------------------');
7597: PNP_DEBUG_PKG.log('pnp_util_func.validate_date_assignable_area (+)');
7598: PNP_DEBUG_PKG.log('Validate date assignable_area : INPUT PARAMS');

Line 7641: IF not(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

7637: p_end_date_old => p_active_end_date_old,
7638: x_return_status => x_return_status,
7639: x_return_message => x_return_message);
7640:
7641: IF not(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
7642: PNP_DEBUG_PKG.log('Error in validate_assignment_for_date');
7643: Raise unexpected_error;
7644: END IF;
7645: END IF;

Line 7657: x_return_status := FND_API.G_RET_STS_ERROR;

7653:
7654: EXCEPTION
7655:
7656: WHEN UNEXPECTED_ERROR THEN
7657: x_return_status := FND_API.G_RET_STS_ERROR;
7658: PNP_DEBUG_PKG.disable_file_debug;
7659:
7660: WHEN OTHERS THEN
7661: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');

Line 7663: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7659:
7660: WHEN OTHERS THEN
7661: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
7662: fnd_message.set_token('ERR_MSG',l_api_name||'='|| sqlerrm);
7663: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7664: PNP_DEBUG_PKG.disable_file_debug;
7665:
7666: END validate_date_assignable_area;
7667:

Line 7682: p_as_of_date = FND_API.G_MISS_DATE THEN

7678: IS
7679: BEGIN
7680:
7681: IF p_as_of_date is NULL OR
7682: p_as_of_date = FND_API.G_MISS_DATE THEN
7683: RETURN SYSDATE;
7684: ELSE
7685: RETURN p_as_of_date;
7686:

Line 7726: x_return_status := FND_API.G_RET_STS_ERROR;

7722: nvl( p_end_date, TO_DATE('12/31/4712','MM/DD/YYYY')));
7723:
7724: BEGIN
7725:
7726: x_return_status := FND_API.G_RET_STS_ERROR;
7727:
7728: FOR locations_rec in locations_cursor LOOP
7729: x_return_status := FND_API.G_RET_STS_SUCCESS;
7730: EXIT;

Line 7729: x_return_status := FND_API.G_RET_STS_SUCCESS;

7725:
7726: x_return_status := FND_API.G_RET_STS_ERROR;
7727:
7728: FOR locations_rec in locations_cursor LOOP
7729: x_return_status := FND_API.G_RET_STS_SUCCESS;
7730: EXIT;
7731: END LOOP;
7732:
7733: IF NOT ( x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

Line 7733: IF NOT ( x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

7729: x_return_status := FND_API.G_RET_STS_SUCCESS;
7730: EXIT;
7731: END LOOP;
7732:
7733: IF NOT ( x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
7734: fnd_message.set_name('PN','PN_INVALID_SPACE_ASSIGN_DATE');
7735: END IF;
7736: END Validate_date_for_Assignments;
7737: