3084: x_result || ', x_error_message = ' ||
3085: x_error_message || ', x_err_code = ' ||
3086: x_error_code);
3087:
3088: if(x_result = fnd_api.g_ret_sts_success) then
3089: p_result := 0;
3090: else
3091: p_result := 1;
3092: p_error := x_error_message;
3227: x_error_code,
3228: x_error_message
3229: );
3230:
3231: if(x_result = fnd_api.g_ret_sts_success) then
3232: p_result := 0;
3233: else
3234: p_result := 1;
3235: p_error := x_error_message;
3329: end if;
3330:
3331:
3332:
3333: x_result := fnd_api.g_ret_sts_success;
3334: print_debug_log(l_api_name, 'END');
3335:
3336: EXCEPTION
3337: WHEN OTHERS THEN
3337: WHEN OTHERS THEN
3338: x_error_code := SQLCODE;
3339: x_error_message := SUBSTR(SQLERRM, 1, 100);
3340: print_error_log(l_api_name, 'EXCEPTION x_error_code = '||x_error_code||' x_error_message = '||x_error_message);
3341: x_result := fnd_api.g_ret_sts_error;
3342: END publishAbstract;
3343:
3344: /*======================================================================
3345: PROCEDURE: performPostSaveChanges PUBLIC
3422: null;
3423: end;
3424: end if;
3425:
3426: x_result := fnd_api.g_ret_sts_success;
3427:
3428: print_debug_log(l_api_name, 'END');
3429:
3430: EXCEPTION
3428: print_debug_log(l_api_name, 'END');
3429:
3430: EXCEPTION
3431: WHEN OTHERS THEN
3432: x_result := fnd_api.g_ret_sts_error;
3433: x_error_code := SQLCODE;
3434: x_error_message := SUBSTR(SQLERRM, 1, 100);
3435: print_error_log(l_api_name, 'EXCEPTION x_error_code = '||x_error_code||' x_error_message = '||x_error_message);
3436:
3470: and parent_field_values_fk = p_parent_fk
3471: and nvl(section_id, -1) <> -1;
3472:
3473:
3474: x_result := fnd_api.g_ret_sts_success;
3475:
3476: print_debug_log(l_api_name, 'END');
3477:
3478: EXCEPTION
3479: WHEN OTHERS THEN
3480: x_error_code := SQLCODE;
3481: x_error_message := SUBSTR(SQLERRM, 1, 100);
3482: print_error_log(l_api_name, 'EXCEPTION x_error_code = '||x_error_code||' x_error_message = '||x_error_message);
3483: x_result := fnd_api.g_ret_sts_error;
3484:
3485: END deleteFormFieldValues;
3486:
3487: /*======================================================================
3544: print_debug_log(l_api_name, 'BEGIN- p_form_id = '||p_form_id||'
3545: p_entity_pk1 = '||p_entity_pk1||'
3546: p_entity_code = '||p_entity_code);
3547:
3548: x_result := fnd_api.g_ret_sts_error;
3549:
3550: delete from pon_form_field_values
3551: where form_id = p_form_id
3552: and entity_pk1 = p_entity_pk1
3551: where form_id = p_form_id
3552: and entity_pk1 = p_entity_pk1
3553: and owning_entity_code = p_entity_code;
3554:
3555: x_result := fnd_api.g_ret_sts_success;
3556:
3557: print_debug_log(l_api_name, 'END');
3558:
3559: EXCEPTION
3560: WHEN OTHERS THEN
3561: x_error_code := SQLCODE;
3562: x_error_message := SUBSTR(SQLERRM, 1, 100);
3563: print_error_log(l_api_name, 'EXCEPTION x_error_code = '||x_error_code||' x_error_message = '||x_error_message);
3564: x_result := fnd_api.g_ret_sts_error;
3565: END deleteValues;
3566:
3567:
3568: