177: x_location,
178: x_measurement_criteria);
179: --exception
180: --when others then
181: -- APP_EXCEPTION.RAISE_EXCEPTION;
182: end;
183:
184: v_debug_info := 'Open cursor c';
185: OPEN c;
215: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
216: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
217: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
218: END IF;
219: APP_EXCEPTION.RAISE_EXCEPTION;
220: END IF;
221:
222: END insert_row;
223:
350: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
351: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
352: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
353: END IF;
354: APP_EXCEPTION.RAISE_EXCEPTION;
355:
356: END update_row;
357:
358: PROCEDURE delete_row (x_emission_id NUMBER) IS
560: AND ((recinfo.last_update_login = x_last_update_login) OR (recinfo.last_update_login IS NULL AND x_last_update_login IS NULL)) ) THEN
561: NULL;
562: ELSE
563: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
564: APP_EXCEPTION.RAISE_EXCEPTION;
565: END IF;
566: */
567: NULL;
568:
576: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
577: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
578: END IF;
579: END IF;
580: APP_EXCEPTION.RAISE_EXCEPTION;
581:
582: END lock_row;
583:
584:
803: WHEN OTHERS THEN
804:
805: FND_MESSAGE.SET_NAME('GHG', SQLERRM);
806: -- FND_MESSAGE.SET_NAME('GHG', 'GHG_NO_RATE_COVERAGE');
807: APP_EXCEPTION.RAISE_EXCEPTION;
808:
809: END;
810:
811: PROCEDURE cancel_invoice (x_invoice_id NUMBER,
991: WHEN OTHERS THEN
992:
993: FND_MESSAGE.SET_NAME('GHG', '*'||vl_debug||'*-'||SQLERRM);
994:
995: APP_EXCEPTION.RAISE_EXCEPTION;
996:
997: END;
998:
999: