950: EXCEPTION
951: WHEN OTHERS THEN
952: ece_error_handling_pvt.print_parse_error ( dbms_sql.last_error_position,
953: cHeader_select );
954: app_exception.raise_exception;
955: END;
956:
957: xProgress := 'SPSOB-10-1140';
958: BEGIN
962: EXCEPTION
963: WHEN OTHERS THEN
964: ece_error_handling_pvt.print_parse_error ( dbms_sql.last_error_position,
965: cItem_select );
966: app_exception.raise_exception;
967: END;
968:
969: -- *************************************************
970: -- set counter
1710: 'ECE_ERROR_MESSAGE',
1711: 'ERROR_MESSAGE',
1712: SQLERRM );
1713:
1714: app_exception.raise_exception;
1715:
1716: WHEN OTHERS THEN
1717:
1718: ec_debug.pl ( 0,
1726: 'ECE_ERROR_MESSAGE',
1727: 'ERROR_MESSAGE',
1728: SQLERRM );
1729:
1730: app_exception.raise_exception;
1731:
1732: END Populate_Supplier_Sched_API1;
1733:
1734:
2362: 'ECE_ERROR_MESSAGE',
2363: 'ERROR_MESSAGE',
2364: SQLERRM );
2365:
2366: app_exception.raise_exception;
2367:
2368: END; -- item detail block
2369:
2370:
2385: 'ECE_ERROR_MESSAGE',
2386: 'ERROR_MESSAGE',
2387: SQLERRM );
2388:
2389: app_exception.raise_exception;
2390:
2391: END; -- item block
2392:
2393: END LOOP header; -- header for loop
2408: 'ECE_ERROR_MESSAGE',
2409: 'ERROR_MESSAGE',
2410: SQLERRM );
2411:
2412: app_exception.raise_exception;
2413:
2414: END Populate_Supplier_Sched_API3; -- end of procedure
2415:
2416:
2488: 'ECE_ERROR_MESSAGE',
2489: 'ERROR_MESSAGE',
2490: SQLERRM );
2491:
2492: app_exception.raise_exception;
2493:
2494: END Update_CHV_Schedule_Headers;
2495:
2496:
3005: EXCEPTION
3006: WHEN OTHERS THEN
3007: ece_error_handling_pvt.print_parse_error ( dbms_sql.last_error_position,
3008: x_header_select );
3009: app_exception.raise_exception;
3010: END;
3011:
3012: xProgress := 'SPSOB-50-1280';
3013: BEGIN
3017: EXCEPTION
3018: WHEN OTHERS THEN
3019: ece_error_handling_pvt.print_parse_error ( dbms_sql.last_error_position,
3020: x_item_select );
3021: app_exception.raise_exception;
3022: END;
3023:
3024: xProgress := 'SPSOB-50-1290';
3025: BEGIN
3029: EXCEPTION
3030: WHEN OTHERS THEN
3031: ece_error_handling_pvt.print_parse_error ( dbms_sql.last_error_position,
3032: x_item_d_select );
3033: app_exception.raise_exception;
3034: END;
3035:
3036: xProgress := 'SPSOB-50-1295';
3037: if (p_transaction_type = 'SSSO') then
3042: EXCEPTION
3043: WHEN OTHERS THEN
3044: ece_error_handling_pvt.print_parse_error ( dbms_sql.last_error_position,
3045: x_ship_d_select );
3046: app_exception.raise_exception;
3047: END;
3048: end if;
3049: xProgress := 'SPSOB-50-1300';
3050: BEGIN
3054: EXCEPTION
3055: WHEN OTHERS THEN
3056: ece_error_handling_pvt.print_parse_error ( dbms_sql.last_error_position,
3057: x_header_delete1 );
3058: app_exception.raise_exception;
3059: END;
3060:
3061: xProgress := 'SPSOB-50-1310';
3062: BEGIN
3066: EXCEPTION
3067: WHEN OTHERS THEN
3068: ece_error_handling_pvt.print_parse_error ( dbms_sql.last_error_position,
3069: x_item_delete1 );
3070: app_exception.raise_exception;
3071: END;
3072:
3073: xProgress := 'SPSOB-50-1320';
3074: BEGIN
3078: EXCEPTION
3079: WHEN OTHERS THEN
3080: ece_error_handling_pvt.print_parse_error ( dbms_sql.last_error_position,
3081: x_item_d_delete1 );
3082: app_exception.raise_exception;
3083: END;
3084:
3085: xProgress := 'SPSOB-50-1325';
3086: if (p_transaction_type = 'SSSO') then
3091: EXCEPTION
3092: WHEN OTHERS THEN
3093: ece_error_handling_pvt.print_parse_error ( dbms_sql.last_error_position,
3094: x_ship_d_delete1 );
3095: app_exception.raise_exception;
3096: END;
3097: end if;
3098:
3099: xProgress := 'SPSOB-50-1330';
3104: EXCEPTION
3105: WHEN OTHERS THEN
3106: ece_error_handling_pvt.print_parse_error ( dbms_sql.last_error_position,
3107: x_header_delete2 );
3108: app_exception.raise_exception;
3109: END;
3110:
3111: xProgress := 'SPSOB-50-1340';
3112: BEGIN
3116: EXCEPTION
3117: WHEN OTHERS THEN
3118: ece_error_handling_pvt.print_parse_error ( dbms_sql.last_error_position,
3119: x_item_delete2 );
3120: app_exception.raise_exception;
3121: END;
3122:
3123: xProgress := 'SPSOB-50-1350';
3124: BEGIN
3128: EXCEPTION
3129: WHEN OTHERS THEN
3130: ece_error_handling_pvt.print_parse_error ( dbms_sql.last_error_position,
3131: x_item_d_delete2 );
3132: app_exception.raise_exception;
3133: END;
3134:
3135: xProgress := 'SPSOB-50-1355';
3136: if (p_transaction_type = 'SSSO') then
3141: EXCEPTION
3142: WHEN OTHERS THEN
3143: ece_error_handling_pvt.print_parse_error ( dbms_sql.last_error_position,
3144: x_ship_d_delete2 );
3145: app_exception.raise_exception;
3146: END;
3147: end if;
3148:
3149: -- *************************************************
3764: 'ECE_ERROR_MESSAGE',
3765: 'ERROR_MESSAGE',
3766: SQLERRM );
3767:
3768: app_exception.raise_exception;
3769:
3770: END Put_Data_To_Output_Table; -- end of procedure
3771:
3772: END ECE_SPSO_TRANS1;