176: EXCEPTION
177: -- other appropriate handlers
178: WHEN OTHERS THEN
179: -- store SQL error message on message stack
180: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
181: p_msg_name => G_UNEXPECTED_ERROR,
182: p_token1 => G_SQLCODE_TOKEN,
183: p_token1_value => sqlcode,
184: p_token2 => G_SQLERRM_TOKEN,
184: p_token2 => G_SQLERRM_TOKEN,
185: p_token2_value => sqlerrm);
186:
187: -- notify UNEXPECTED error
188: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
189:
190: END populate_quote_rec;
191:
192: -------------------------------------------------------------------------------
298: EXCEPTION
299: -- other appropriate handlers
300: WHEN OTHERS THEN
301: -- store SQL error message on message stack
302: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
303: p_msg_name => G_UNEXPECTED_ERROR,
304: p_token1 => G_SQLCODE_TOKEN,
305: p_token1_value => sqlcode,
306: p_token2 => G_SQLERRM_TOKEN,
306: p_token2 => G_SQLERRM_TOKEN,
307: p_token2_value => sqlerrm);
308:
309: -- notify UNEXPECTED error
310: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
311:
312: END populate_fee_rec;
313:
314: -------------------------------------------------------------------------------
414: EXCEPTION
415: -- other appropriate handlers
416: WHEN OTHERS THEN
417: -- store SQL error message on message stack
418: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
419: p_msg_name => G_UNEXPECTED_ERROR,
420: p_token1 => G_SQLCODE_TOKEN,
421: p_token1_value => sqlcode,
422: p_token2 => G_SQLERRM_TOKEN,
422: p_token2 => G_SQLERRM_TOKEN,
423: p_token2_value => sqlerrm);
424:
425: -- notify UNEXPECTED error
426: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
427:
428: END populate_asset_rec;
429: --Bug # 4688662 ssdeshpa start
430: --Moved this method to OKL_SALES_QUOTE_QA_PVT
506: EXCEPTION
507: -- other appropriate handlers
508: WHEN OTHERS THEN
509: -- store SQL error message on message stack
510: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
511: p_msg_name => G_UNEXPECTED_ERROR,
512: p_token1 => G_SQLCODE_TOKEN,
513: p_token1_value => sqlcode,
514: p_token2 => G_SQLERRM_TOKEN,
514: p_token2 => G_SQLERRM_TOKEN,
515: p_token2_value => sqlerrm);
516:
517: -- notify UNEXPECTED error
518: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
519:
520: END are_all_lines_overriden;*/
521: --Bug # 4688662 ssdeshpa start
522:
561: EXCEPTION
562: -- other appropriate handlers
563: WHEN OTHERS THEN
564: -- store SQL error message on message stack
565: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
566: p_msg_name => G_UNEXPECTED_ERROR,
567: p_token1 => G_SQLCODE_TOKEN,
568: p_token1_value => sqlcode,
569: p_token2 => G_SQLERRM_TOKEN,
569: p_token2 => G_SQLERRM_TOKEN,
570: p_token2_value => sqlerrm);
571:
572: -- notify UNEXPECTED error
573: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
574:
575: END are_qte_pricing_opts_entered;
576: -------------------------------------------------------------------------------
577: -- PROCEDURE validate
1054: END IF;
1055: END IF;
1056: END IF;
1057:
1058: x_return_status := okc_api.G_RET_STS_SUCCESS;
1059: OKL_API.END_ACTIVITY(
1060: x_msg_count => x_msg_count
1061: ,x_msg_data => x_msg_data);
1062: EXCEPTION
2696: EXCEPTION
2697: -- other appropriate handlers
2698: WHEN OTHERS THEN
2699: -- store SQL error message on message stack
2700: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
2701: p_msg_name => G_UNEXPECTED_ERROR,
2702: p_token1 => G_SQLCODE_TOKEN,
2703: p_token1_value => sqlcode,
2704: p_token2 => G_SQLERRM_TOKEN,
2779: EXCEPTION
2780: -- other appropriate handlers
2781: WHEN OTHERS THEN
2782: -- store SQL error message on message stack
2783: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
2784: p_msg_name => G_UNEXPECTED_ERROR,
2785: p_token1 => G_SQLCODE_TOKEN,
2786: p_token1_value => sqlcode,
2787: p_token2 => G_SQLERRM_TOKEN,