114: CLOSE cost_factor_cur;
115: END IF;
116: IF fnd_msg_pub.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
117: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name,SQLERRM);
118: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
119: fnd_log.string(log_level => fnd_log.level_unexpected
120: ,module => g_pkg_name ||'.'||l_api_name
121: ,message => l_stage || ': ' || SQLERRM);
122: fnd_log.string(log_level=>fnd_log.level_unexpected
115: END IF;
116: IF fnd_msg_pub.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
117: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name,SQLERRM);
118: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
119: fnd_log.string(log_level => fnd_log.level_unexpected
120: ,module => g_pkg_name ||'.'||l_api_name
121: ,message => l_stage || ': ' || SQLERRM);
122: fnd_log.string(log_level=>fnd_log.level_unexpected
123: ,module =>g_pkg_name ||'.'||l_api_name
118: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
119: fnd_log.string(log_level => fnd_log.level_unexpected
120: ,module => g_pkg_name ||'.'||l_api_name
121: ,message => l_stage || ': ' || SQLERRM);
122: fnd_log.string(log_level=>fnd_log.level_unexpected
123: ,module =>g_pkg_name ||'.'||l_api_name
124: ,message => 'Input parameter list: ' );
125: fnd_log.string(log_level=>fnd_log.level_unexpected
126: ,module =>g_pkg_name ||'.'||l_api_name
121: ,message => l_stage || ': ' || SQLERRM);
122: fnd_log.string(log_level=>fnd_log.level_unexpected
123: ,module =>g_pkg_name ||'.'||l_api_name
124: ,message => 'Input parameter list: ' );
125: fnd_log.string(log_level=>fnd_log.level_unexpected
126: ,module =>g_pkg_name ||'.'||l_api_name
127: ,message => 'Price element type id: '||p_price_element_id);
128: fnd_log.string(log_level=>fnd_log.level_unexpected
129: ,module =>g_pkg_name ||'.'||l_api_name
124: ,message => 'Input parameter list: ' );
125: fnd_log.string(log_level=>fnd_log.level_unexpected
126: ,module =>g_pkg_name ||'.'||l_api_name
127: ,message => 'Price element type id: '||p_price_element_id);
128: fnd_log.string(log_level=>fnd_log.level_unexpected
129: ,module =>g_pkg_name ||'.'||l_api_name
130: ,message => 'Price element code: '|| p_price_element_code );
131: fnd_log.string(log_level=>fnd_log.level_unexpected
132: ,module =>g_pkg_name ||'.'||l_api_name
127: ,message => 'Price element type id: '||p_price_element_id);
128: fnd_log.string(log_level=>fnd_log.level_unexpected
129: ,module =>g_pkg_name ||'.'||l_api_name
130: ,message => 'Price element code: '|| p_price_element_code );
131: fnd_log.string(log_level=>fnd_log.level_unexpected
132: ,module =>g_pkg_name ||'.'||l_api_name
133: ,message => 'Price element type name: '||p_name );
134: fnd_log.string(log_level=>fnd_log.level_unexpected
135: ,module =>g_pkg_name ||'.'||l_api_name
130: ,message => 'Price element code: '|| p_price_element_code );
131: fnd_log.string(log_level=>fnd_log.level_unexpected
132: ,module =>g_pkg_name ||'.'||l_api_name
133: ,message => 'Price element type name: '||p_name );
134: fnd_log.string(log_level=>fnd_log.level_unexpected
135: ,module =>g_pkg_name ||'.'||l_api_name
136: ,message => 'p_api_version: '||p_api_version );
137: END IF;
138: END IF;
394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
395: IF fnd_msg_pub.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
396: THEN
397: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name,SQLERRM);
398: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
399: THEN
400: fnd_log.string(log_level => fnd_log.level_unexpected
401: ,module => g_pkg_name ||'.'||l_api_name
402: ,message => l_stage || ': ' || SQLERRM);
396: THEN
397: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name,SQLERRM);
398: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
399: THEN
400: fnd_log.string(log_level => fnd_log.level_unexpected
401: ,module => g_pkg_name ||'.'||l_api_name
402: ,message => l_stage || ': ' || SQLERRM);
403: fnd_log.string(log_level=>fnd_log.level_unexpected,
404: module =>g_pkg_name ||'.'||l_api_name,
399: THEN
400: fnd_log.string(log_level => fnd_log.level_unexpected
401: ,module => g_pkg_name ||'.'||l_api_name
402: ,message => l_stage || ': ' || SQLERRM);
403: fnd_log.string(log_level=>fnd_log.level_unexpected,
404: module =>g_pkg_name ||'.'||l_api_name,
405: message => 'Input parameter list: ' );
406: fnd_log.string(log_level=>fnd_log.level_unexpected,
407: module =>g_pkg_name ||'.'||l_api_name,
402: ,message => l_stage || ': ' || SQLERRM);
403: fnd_log.string(log_level=>fnd_log.level_unexpected,
404: module =>g_pkg_name ||'.'||l_api_name,
405: message => 'Input parameter list: ' );
406: fnd_log.string(log_level=>fnd_log.level_unexpected,
407: module =>g_pkg_name ||'.'||l_api_name,
408: message => 'p_api_version = ' || p_api_version);
409: fnd_log.string(log_level=>fnd_log.level_unexpected,
410: module =>g_pkg_name ||'.'||l_api_name,
405: message => 'Input parameter list: ' );
406: fnd_log.string(log_level=>fnd_log.level_unexpected,
407: module =>g_pkg_name ||'.'||l_api_name,
408: message => 'p_api_version = ' || p_api_version);
409: fnd_log.string(log_level=>fnd_log.level_unexpected,
410: module =>g_pkg_name ||'.'||l_api_name,
411: message => 'p_price_element_code = ' || p_price_element_code);
412: fnd_log.string(log_level=>fnd_log.level_unexpected,
413: module =>g_pkg_name ||'.'||l_api_name,
408: message => 'p_api_version = ' || p_api_version);
409: fnd_log.string(log_level=>fnd_log.level_unexpected,
410: module =>g_pkg_name ||'.'||l_api_name,
411: message => 'p_price_element_code = ' || p_price_element_code);
412: fnd_log.string(log_level=>fnd_log.level_unexpected,
413: module =>g_pkg_name ||'.'||l_api_name,
414: message => 'p_pricing_basis = ' || p_pricing_basis);
415: fnd_log.string(log_level=>fnd_log.level_unexpected,
416: module =>g_pkg_name ||'.'||l_api_name,
411: message => 'p_price_element_code = ' || p_price_element_code);
412: fnd_log.string(log_level=>fnd_log.level_unexpected,
413: module =>g_pkg_name ||'.'||l_api_name,
414: message => 'p_pricing_basis = ' || p_pricing_basis);
415: fnd_log.string(log_level=>fnd_log.level_unexpected,
416: module =>g_pkg_name ||'.'||l_api_name,
417: message => 'p_cost_component_class_id = ' || p_cost_component_class_id);
418: fnd_log.string(log_level=>fnd_log.level_unexpected,
419: module =>g_pkg_name ||'.'||l_api_name,
414: message => 'p_pricing_basis = ' || p_pricing_basis);
415: fnd_log.string(log_level=>fnd_log.level_unexpected,
416: module =>g_pkg_name ||'.'||l_api_name,
417: message => 'p_cost_component_class_id = ' || p_cost_component_class_id);
418: fnd_log.string(log_level=>fnd_log.level_unexpected,
419: module =>g_pkg_name ||'.'||l_api_name,
420: message => 'p_cost_analysis_code = ' || p_cost_analysis_code);
421: fnd_log.string(log_level=>fnd_log.level_unexpected,
422: module =>g_pkg_name ||'.'||l_api_name,
417: message => 'p_cost_component_class_id = ' || p_cost_component_class_id);
418: fnd_log.string(log_level=>fnd_log.level_unexpected,
419: module =>g_pkg_name ||'.'||l_api_name,
420: message => 'p_cost_analysis_code = ' || p_cost_analysis_code);
421: fnd_log.string(log_level=>fnd_log.level_unexpected,
422: module =>g_pkg_name ||'.'||l_api_name,
423: message => 'p_cost_acquisition_code = ' || p_cost_acquisition_code);
424: fnd_log.string(log_level=>fnd_log.level_unexpected,
425: module =>g_pkg_name ||'.'||l_api_name,
420: message => 'p_cost_analysis_code = ' || p_cost_analysis_code);
421: fnd_log.string(log_level=>fnd_log.level_unexpected,
422: module =>g_pkg_name ||'.'||l_api_name,
423: message => 'p_cost_acquisition_code = ' || p_cost_acquisition_code);
424: fnd_log.string(log_level=>fnd_log.level_unexpected,
425: module =>g_pkg_name ||'.'||l_api_name,
426: message => 'p_name = ' || p_name);
427: fnd_log.string(log_level=>fnd_log.level_unexpected,
428: module =>g_pkg_name ||'.'||l_api_name,
423: message => 'p_cost_acquisition_code = ' || p_cost_acquisition_code);
424: fnd_log.string(log_level=>fnd_log.level_unexpected,
425: module =>g_pkg_name ||'.'||l_api_name,
426: message => 'p_name = ' || p_name);
427: fnd_log.string(log_level=>fnd_log.level_unexpected,
428: module =>g_pkg_name ||'.'||l_api_name,
429: message => 'p_description = ' || p_description);
430: END IF ;
431: END IF;
472: CLOSE cost_factor_cur;
473: END IF;
474: IF fnd_msg_pub.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
475: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name,SQLERRM);
476: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
477: fnd_log.string(log_level => fnd_log.level_unexpected
478: ,module => g_pkg_name ||'.'||l_api_name
479: ,message => l_stage || ': ' || SQLERRM);
480: fnd_log.string(log_level=>fnd_log.level_unexpected
473: END IF;
474: IF fnd_msg_pub.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
475: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name,SQLERRM);
476: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
477: fnd_log.string(log_level => fnd_log.level_unexpected
478: ,module => g_pkg_name ||'.'||l_api_name
479: ,message => l_stage || ': ' || SQLERRM);
480: fnd_log.string(log_level=>fnd_log.level_unexpected
481: ,module =>g_pkg_name ||'.'||l_api_name
476: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
477: fnd_log.string(log_level => fnd_log.level_unexpected
478: ,module => g_pkg_name ||'.'||l_api_name
479: ,message => l_stage || ': ' || SQLERRM);
480: fnd_log.string(log_level=>fnd_log.level_unexpected
481: ,module =>g_pkg_name ||'.'||l_api_name
482: ,message => 'Input parameter: ' );
483: fnd_log.string(log_level=>fnd_log.level_unexpected
484: ,module =>g_pkg_name ||'.'||l_api_name
479: ,message => l_stage || ': ' || SQLERRM);
480: fnd_log.string(log_level=>fnd_log.level_unexpected
481: ,module =>g_pkg_name ||'.'||l_api_name
482: ,message => 'Input parameter: ' );
483: fnd_log.string(log_level=>fnd_log.level_unexpected
484: ,module =>g_pkg_name ||'.'||l_api_name
485: ,message => 'Price element type id: '||p_price_element_id);
486: END IF;
487: END IF;
524: CLOSE cost_factor_cur;
525: END IF;
526: IF fnd_msg_pub.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
527: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name,SQLERRM);
528: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
529: fnd_log.string(log_level => fnd_log.level_unexpected
530: ,module => g_pkg_name ||'.'||l_api_name
531: ,message => l_stage || ': ' || SQLERRM);
532: fnd_log.string(log_level=>fnd_log.level_unexpected
525: END IF;
526: IF fnd_msg_pub.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
527: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name,SQLERRM);
528: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
529: fnd_log.string(log_level => fnd_log.level_unexpected
530: ,module => g_pkg_name ||'.'||l_api_name
531: ,message => l_stage || ': ' || SQLERRM);
532: fnd_log.string(log_level=>fnd_log.level_unexpected
533: ,module =>g_pkg_name ||'.'||l_api_name
528: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
529: fnd_log.string(log_level => fnd_log.level_unexpected
530: ,module => g_pkg_name ||'.'||l_api_name
531: ,message => l_stage || ': ' || SQLERRM);
532: fnd_log.string(log_level=>fnd_log.level_unexpected
533: ,module =>g_pkg_name ||'.'||l_api_name
534: ,message => 'Input parameter: ' );
535: fnd_log.string(log_level=>fnd_log.level_unexpected
536: ,module =>g_pkg_name ||'.'||l_api_name
531: ,message => l_stage || ': ' || SQLERRM);
532: fnd_log.string(log_level=>fnd_log.level_unexpected
533: ,module =>g_pkg_name ||'.'||l_api_name
534: ,message => 'Input parameter: ' );
535: fnd_log.string(log_level=>fnd_log.level_unexpected
536: ,module =>g_pkg_name ||'.'||l_api_name
537: ,message => 'Price element code: '||p_price_element_code);
538: END IF;
539: END IF;