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 7044: x_return_status := FND_API.G_RET_STS_SUCCESS;

7040:
7041: END LOOP;
7042: x_space_assign_emp_tbl := l_space_assign_emp_tbl;
7043:
7044: x_return_status := FND_API.G_RET_STS_SUCCESS;
7045: PNP_DEBUG_PKG.DEBUG('pnp_util_func.get_space_assignments (-)');
7046:
7047: EXCEPTION
7048: WHEN OTHERS THEN

Line 7051: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7047: EXCEPTION
7048: WHEN OTHERS THEN
7049: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
7050: fnd_message.set_token('ERR_MSG',l_api_name||'='|| sqlerrm);
7051: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7052: PNP_DEBUG_PKG.DEBUG('OTHERS EXCEPTION');
7053:
7054:
7055: END get_space_assignments;

Line 7154: x_return_status := FND_API.G_RET_STS_SUCCESS;

7150: AND NVL(cust_assign_end_date,to_date('12/31/4712','mm/dd/yyyy')) > p_end_date AND
7151: cust_assign_start_date <= p_end_date_old);
7152:
7153: BEGIN
7154: x_return_status := FND_API.G_RET_STS_SUCCESS;
7155:
7156: PNP_DEBUG_PKG.log('----------------------------------');
7157: PNP_DEBUG_PKG.log('pnp_util_func.validate_assignment_for_date (+)');
7158: PNP_DEBUG_PKG.log('Validate Assignment for date:INPUT');

Line 7168: x_return_status := FND_API.G_RET_STS_ERROR;

7164:
7165: IF p_start_date > p_start_date_old THEN
7166:
7167: FOR validate_start_date_rec in validate_start_date_cursor LOOP
7168: x_return_status := FND_API.G_RET_STS_ERROR;
7169: Raise USER_DEF_ERROR;
7170: EXIT;
7171: END LOOP;
7172:

Line 7178: x_return_status := FND_API.G_RET_STS_ERROR;

7174:
7175: IF p_end_date < p_end_date_old THEN
7176:
7177: FOR validate_end_date_rec in validate_end_date_cursor LOOP
7178: x_return_status := FND_API.G_RET_STS_ERROR;
7179: Raise USER_DEF_ERROR;
7180: EXIT;
7181: END LOOP;
7182:

Line 7190: x_return_status := FND_API.G_RET_STS_ERROR;

7186:
7187: EXCEPTION
7188:
7189: WHEN USER_DEF_ERROR THEN
7190: x_return_status := FND_API.G_RET_STS_ERROR;
7191: fnd_message.set_name('PN','PN_INVALID_DATE_EFFECTIVITY');
7192: PNP_DEBUG_PKG.log('Assignment found for dates');
7193:
7194: WHEN OTHERS THEN

Line 7197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7193:
7194: WHEN OTHERS THEN
7195: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
7196: fnd_message.set_token('ERR_MSG',l_api_name||'='|| sqlerrm);
7197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7198: PNP_DEBUG_PKG.log('OTHERS ERROR');
7199:
7200: END validate_assignment_for_date;
7201:

Line 7257: x_return_status := FND_API.G_RET_STS_SUCCESS;

7253: PNP_DEBUG_PKG.log('Assignable Area : ' || p_assignable_area);
7254: PNP_DEBUG_PKG.log('----------------------------------');
7255: PNP_DEBUG_PKG.log('Calling get space assignments');
7256:
7257: x_return_status := FND_API.G_RET_STS_SUCCESS;
7258: Get_space_assignments (
7259: p_location_id => p_location_id,
7260: p_start_date => p_start_date,
7261: p_end_date => p_end_date,

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

7264: x_return_status => x_return_status,
7265: x_return_message => x_return_message
7266: );
7267:
7268: IF not(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
7269: PNP_DEBUG_PKG.log('Error in get space_assignments');
7270: Raise unexpected_error;
7271: END IF;
7272:

Line 7356: x_return_status := FND_API.G_RET_STS_ERROR;

7352: EXCEPTION
7353:
7354:
7355: WHEN UNEXPECTED_ERROR THEN
7356: x_return_status := FND_API.G_RET_STS_ERROR;
7357: PNP_DEBUG_PKG.log('UNEXPECTED ERROR');
7358:
7359: WHEN OTHERS THEN
7360: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');

Line 7362: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7358:
7359: WHEN OTHERS THEN
7360: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
7361: fnd_message.set_token('ERR_MSG',l_api_name||'='|| sqlerrm);
7362: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7363: PNP_DEBUG_PKG.log('OTHERS ERROR');
7364:
7365: END validate_assignable_area;
7366:

Line 7433: x_return_status := FND_API.G_RET_STS_SUCCESS;

7429: AND active_end_date = p_active_end_date_old;
7430:
7431: BEGIN
7432: -- Remove after debug
7433: x_return_status := FND_API.G_RET_STS_SUCCESS;
7434:
7435: PNP_DEBUG_PKG.log('---------------------------------------');
7436: PNP_DEBUG_PKG.log('pnp_util_func.validate_date_assignable_area (+)');
7437: PNP_DEBUG_PKG.log('Validate date assignable_area : INPUT PARAMS');

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

7476: p_end_date_old => p_active_end_date_old,
7477: x_return_status => x_return_status,
7478: x_return_message => x_return_message);
7479:
7480: IF not(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
7481: PNP_DEBUG_PKG.log('Error in validate_assignment_for_date');
7482: Raise unexpected_error;
7483: END IF;
7484: END IF;

Line 7496: x_return_status := FND_API.G_RET_STS_ERROR;

7492:
7493: EXCEPTION
7494:
7495: WHEN UNEXPECTED_ERROR THEN
7496: x_return_status := FND_API.G_RET_STS_ERROR;
7497: PNP_DEBUG_PKG.disable_file_debug;
7498:
7499: WHEN OTHERS THEN
7500: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');

Line 7502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7498:
7499: WHEN OTHERS THEN
7500: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
7501: fnd_message.set_token('ERR_MSG',l_api_name||'='|| sqlerrm);
7502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7503: PNP_DEBUG_PKG.disable_file_debug;
7504:
7505: END validate_date_assignable_area;
7506:

Line 7521: p_as_of_date = FND_API.G_MISS_DATE THEN

7517: IS
7518: BEGIN
7519:
7520: IF p_as_of_date is NULL OR
7521: p_as_of_date = FND_API.G_MISS_DATE THEN
7522: RETURN SYSDATE;
7523: ELSE
7524: RETURN p_as_of_date;
7525:

Line 7559: x_return_status := FND_API.G_RET_STS_ERROR;

7555: AND (active_start_date <= p_start_Date AND active_end_Date >= p_end_date);
7556:
7557: BEGIN
7558:
7559: x_return_status := FND_API.G_RET_STS_ERROR;
7560:
7561: FOR locations_rec in locations_cursor LOOP
7562: x_return_status := FND_API.G_RET_STS_SUCCESS;
7563: EXIT;

Line 7562: x_return_status := FND_API.G_RET_STS_SUCCESS;

7558:
7559: x_return_status := FND_API.G_RET_STS_ERROR;
7560:
7561: FOR locations_rec in locations_cursor LOOP
7562: x_return_status := FND_API.G_RET_STS_SUCCESS;
7563: EXIT;
7564: END LOOP;
7565:
7566: IF NOT ( x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

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

7562: x_return_status := FND_API.G_RET_STS_SUCCESS;
7563: EXIT;
7564: END LOOP;
7565:
7566: IF NOT ( x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
7567: fnd_message.set_name('PN','PN_INVALID_SPACE_ASSIGN_DATE');
7568: END IF;
7569: END Validate_date_for_Assignments;
7570: