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.OKL_SETUPTQUALITYS_PVT dependencies on OKL_PTQ_PVT

Line 256: Okl_Api.SET_MESSAGE(p_app_name => Okl_Ptq_Pvt.g_app_name

252:
253: -- check for data before processing
254: IF (p_ptqv_rec.name IS NULL) OR
255: (p_ptqv_rec.name = Okl_Api.G_MISS_CHAR) THEN
256: Okl_Api.SET_MESSAGE(p_app_name => Okl_Ptq_Pvt.g_app_name
257: ,p_msg_name => Okl_Ptq_Pvt.g_required_value
258: ,p_token1 => Okl_Ptq_Pvt.g_col_name_token
259: ,p_token1_value => l_token_1);
260: x_return_status := Okl_Api.G_RET_STS_ERROR;

Line 257: ,p_msg_name => Okl_Ptq_Pvt.g_required_value

253: -- check for data before processing
254: IF (p_ptqv_rec.name IS NULL) OR
255: (p_ptqv_rec.name = Okl_Api.G_MISS_CHAR) THEN
256: Okl_Api.SET_MESSAGE(p_app_name => Okl_Ptq_Pvt.g_app_name
257: ,p_msg_name => Okl_Ptq_Pvt.g_required_value
258: ,p_token1 => Okl_Ptq_Pvt.g_col_name_token
259: ,p_token1_value => l_token_1);
260: x_return_status := Okl_Api.G_RET_STS_ERROR;
261: RAISE G_EXCEPTION_HALT_PROCESSING;

Line 258: ,p_token1 => Okl_Ptq_Pvt.g_col_name_token

254: IF (p_ptqv_rec.name IS NULL) OR
255: (p_ptqv_rec.name = Okl_Api.G_MISS_CHAR) THEN
256: Okl_Api.SET_MESSAGE(p_app_name => Okl_Ptq_Pvt.g_app_name
257: ,p_msg_name => Okl_Ptq_Pvt.g_required_value
258: ,p_token1 => Okl_Ptq_Pvt.g_col_name_token
259: ,p_token1_value => l_token_1);
260: x_return_status := Okl_Api.G_RET_STS_ERROR;
261: RAISE G_EXCEPTION_HALT_PROCESSING;
262: END IF;

Line 272: Okl_Api.SET_MESSAGE(p_app_name => Okl_Ptq_Pvt.g_app_name,

268: NULL;
269:
270: WHEN OTHERS THEN
271: -- store SQL error message on message stack for caller
272: Okl_Api.SET_MESSAGE(p_app_name => Okl_Ptq_Pvt.g_app_name,
273: p_msg_name => Okl_Ptq_Pvt.g_unexpected_error,
274: p_token1 => Okl_Ptq_Pvt.g_sqlcode_token,
275: p_token1_value => SQLCODE,
276: p_token2 => Okl_Ptq_Pvt.g_sqlerrm_token,

Line 273: p_msg_name => Okl_Ptq_Pvt.g_unexpected_error,

269:
270: WHEN OTHERS THEN
271: -- store SQL error message on message stack for caller
272: Okl_Api.SET_MESSAGE(p_app_name => Okl_Ptq_Pvt.g_app_name,
273: p_msg_name => Okl_Ptq_Pvt.g_unexpected_error,
274: p_token1 => Okl_Ptq_Pvt.g_sqlcode_token,
275: p_token1_value => SQLCODE,
276: p_token2 => Okl_Ptq_Pvt.g_sqlerrm_token,
277: p_token2_value => SQLERRM);

Line 274: p_token1 => Okl_Ptq_Pvt.g_sqlcode_token,

270: WHEN OTHERS THEN
271: -- store SQL error message on message stack for caller
272: Okl_Api.SET_MESSAGE(p_app_name => Okl_Ptq_Pvt.g_app_name,
273: p_msg_name => Okl_Ptq_Pvt.g_unexpected_error,
274: p_token1 => Okl_Ptq_Pvt.g_sqlcode_token,
275: p_token1_value => SQLCODE,
276: p_token2 => Okl_Ptq_Pvt.g_sqlerrm_token,
277: p_token2_value => SQLERRM);
278:

Line 276: p_token2 => Okl_Ptq_Pvt.g_sqlerrm_token,

272: Okl_Api.SET_MESSAGE(p_app_name => Okl_Ptq_Pvt.g_app_name,
273: p_msg_name => Okl_Ptq_Pvt.g_unexpected_error,
274: p_token1 => Okl_Ptq_Pvt.g_sqlcode_token,
275: p_token1_value => SQLCODE,
276: p_token2 => Okl_Ptq_Pvt.g_sqlerrm_token,
277: p_token2_value => SQLERRM);
278:
279: -- notify caller of an UNEXPECTED error
280: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

Line 312: Okl_Api.SET_MESSAGE(p_app_name => Okl_Ptq_Pvt.g_app_name

308:
309: -- check for data before processing
310: IF (p_ptqv_rec.from_date IS NULL) OR
311: (p_ptqv_rec.from_date = Okl_Api.G_MISS_DATE) THEN
312: Okl_Api.SET_MESSAGE(p_app_name => Okl_Ptq_Pvt.g_app_name
313: ,p_msg_name => Okl_Ptq_Pvt.g_required_value
314: ,p_token1 => Okl_Ptq_Pvt.g_col_name_token
315: ,p_token1_value => l_token_1);
316: x_return_status := Okl_Api.G_RET_STS_ERROR;

Line 313: ,p_msg_name => Okl_Ptq_Pvt.g_required_value

309: -- check for data before processing
310: IF (p_ptqv_rec.from_date IS NULL) OR
311: (p_ptqv_rec.from_date = Okl_Api.G_MISS_DATE) THEN
312: Okl_Api.SET_MESSAGE(p_app_name => Okl_Ptq_Pvt.g_app_name
313: ,p_msg_name => Okl_Ptq_Pvt.g_required_value
314: ,p_token1 => Okl_Ptq_Pvt.g_col_name_token
315: ,p_token1_value => l_token_1);
316: x_return_status := Okl_Api.G_RET_STS_ERROR;
317: RAISE G_EXCEPTION_HALT_PROCESSING;

Line 314: ,p_token1 => Okl_Ptq_Pvt.g_col_name_token

310: IF (p_ptqv_rec.from_date IS NULL) OR
311: (p_ptqv_rec.from_date = Okl_Api.G_MISS_DATE) THEN
312: Okl_Api.SET_MESSAGE(p_app_name => Okl_Ptq_Pvt.g_app_name
313: ,p_msg_name => Okl_Ptq_Pvt.g_required_value
314: ,p_token1 => Okl_Ptq_Pvt.g_col_name_token
315: ,p_token1_value => l_token_1);
316: x_return_status := Okl_Api.G_RET_STS_ERROR;
317: RAISE G_EXCEPTION_HALT_PROCESSING;
318: END IF;

Line 328: Okl_Api.SET_MESSAGE(p_app_name => Okl_Ptq_Pvt.g_app_name,

324: NULL;
325:
326: WHEN OTHERS THEN
327: -- store SQL error message on message stack for caller
328: Okl_Api.SET_MESSAGE(p_app_name => Okl_Ptq_Pvt.g_app_name,
329: p_msg_name => Okl_Ptq_Pvt.g_unexpected_error,
330: p_token1 => Okl_Ptq_Pvt.g_sqlcode_token,
331: p_token1_value => SQLCODE,
332: p_token2 => Okl_Ptq_Pvt.g_sqlerrm_token,

Line 329: p_msg_name => Okl_Ptq_Pvt.g_unexpected_error,

325:
326: WHEN OTHERS THEN
327: -- store SQL error message on message stack for caller
328: Okl_Api.SET_MESSAGE(p_app_name => Okl_Ptq_Pvt.g_app_name,
329: p_msg_name => Okl_Ptq_Pvt.g_unexpected_error,
330: p_token1 => Okl_Ptq_Pvt.g_sqlcode_token,
331: p_token1_value => SQLCODE,
332: p_token2 => Okl_Ptq_Pvt.g_sqlerrm_token,
333: p_token2_value => SQLERRM);

Line 330: p_token1 => Okl_Ptq_Pvt.g_sqlcode_token,

326: WHEN OTHERS THEN
327: -- store SQL error message on message stack for caller
328: Okl_Api.SET_MESSAGE(p_app_name => Okl_Ptq_Pvt.g_app_name,
329: p_msg_name => Okl_Ptq_Pvt.g_unexpected_error,
330: p_token1 => Okl_Ptq_Pvt.g_sqlcode_token,
331: p_token1_value => SQLCODE,
332: p_token2 => Okl_Ptq_Pvt.g_sqlerrm_token,
333: p_token2_value => SQLERRM);
334:

Line 332: p_token2 => Okl_Ptq_Pvt.g_sqlerrm_token,

328: Okl_Api.SET_MESSAGE(p_app_name => Okl_Ptq_Pvt.g_app_name,
329: p_msg_name => Okl_Ptq_Pvt.g_unexpected_error,
330: p_token1 => Okl_Ptq_Pvt.g_sqlcode_token,
331: p_token1_value => SQLCODE,
332: p_token2 => Okl_Ptq_Pvt.g_sqlerrm_token,
333: p_token2_value => SQLERRM);
334:
335: -- notify caller of an UNEXPECTED error
336: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

Line 882: ,p_msg_name => Okl_Ptq_Pvt.g_to_date_error

878: end if;
879:
880: IF (l_upd_ptqv_rec.TO_DATE IS NOT NULL) AND (l_upd_ptqv_rec.TO_DATE < l_upd_ptqv_rec.from_date) THEN
881: Okl_Api.SET_MESSAGE(p_app_name => g_app_name
882: ,p_msg_name => Okl_Ptq_Pvt.g_to_date_error
883: ,p_token1 => Okl_Ptq_Pvt.g_col_name_token
884: ,p_token1_value => 'to_date');
885: x_return_status := Okl_Api.G_RET_STS_ERROR;
886: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 883: ,p_token1 => Okl_Ptq_Pvt.g_col_name_token

879:
880: IF (l_upd_ptqv_rec.TO_DATE IS NOT NULL) AND (l_upd_ptqv_rec.TO_DATE < l_upd_ptqv_rec.from_date) THEN
881: Okl_Api.SET_MESSAGE(p_app_name => g_app_name
882: ,p_msg_name => Okl_Ptq_Pvt.g_to_date_error
883: ,p_token1 => Okl_Ptq_Pvt.g_col_name_token
884: ,p_token1_value => 'to_date');
885: x_return_status := Okl_Api.G_RET_STS_ERROR;
886: RAISE Okl_Api.G_EXCEPTION_ERROR;
887: END IF;