86: p_errbuf := SQLERRM;
87: IF (c_workers%ISOPEN) THEN
88: CLOSE c_workers;
89: END IF;
90: RAISE fnd_api.g_exc_unexpected_error;
91: END load_workers;
92:
93: PROCEDURE launch_workers(book IN VARCHAR2,
94: report_type IN VARCHAR2,
166: IF (h_set_of_books_id IS NOT NULL) THEN
167: IF NOT
168: fa_cache_pkg.fazcsob(x_set_of_books_id => h_set_of_books_id,
169: x_mrc_sob_type_code => h_reporting_flag) THEN
170: RAISE fnd_api.g_exc_unexpected_error;
171: END IF;
172: ELSE
173: SELECT set_of_books_id
174: INTO h_set_of_books_id
804: IF (h_set_of_books_id IS NOT NULL) THEN
805: IF NOT
806: fa_cache_pkg.fazcsob(x_set_of_books_id => h_set_of_books_id,
807: x_mrc_sob_type_code => h_reporting_flag) THEN
808: RAISE fnd_api.g_exc_unexpected_error;
809: END IF;
810: ELSE
811: SELECT set_of_books_id
812: INTO h_set_of_books_id
1117: IF (h_set_of_books_id IS NOT NULL) THEN
1118: IF NOT
1119: fa_cache_pkg.fazcsob(x_set_of_books_id => h_set_of_books_id,
1120: x_mrc_sob_type_code => h_reporting_flag) THEN
1121: RAISE fnd_api.g_exc_unexpected_error;
1122: END IF;
1123: ELSE
1124: h_reporting_flag := 'P';
1125: END IF;
1697: IF (h_set_of_books_id IS NOT NULL) THEN
1698: IF NOT
1699: fa_cache_pkg.fazcsob(x_set_of_books_id => h_set_of_books_id,
1700: x_mrc_sob_type_code => h_reporting_flag) THEN
1701: RAISE fnd_api.g_exc_unexpected_error;
1702: END IF;
1703: ELSE
1704: h_reporting_flag := 'P';
1705: END IF;
2055: IF (h_set_of_books_id IS NOT NULL) THEN
2056: IF NOT
2057: fa_cache_pkg.fazcsob(x_set_of_books_id => h_set_of_books_id,
2058: x_mrc_sob_type_code => h_reporting_flag) THEN
2059: RAISE fnd_api.g_exc_unexpected_error;
2060: END IF;
2061: ELSE
2062: h_reporting_flag := 'P';
2063: END IF;
2397: IF (h_set_of_books_id IS NOT NULL) THEN
2398: IF NOT
2399: fa_cache_pkg.fazcsob(x_set_of_books_id => h_set_of_books_id,
2400: x_mrc_sob_type_code => h_reporting_flag) THEN
2401: RAISE fnd_api.g_exc_unexpected_error;
2402: END IF;
2403: ELSE
2404: h_reporting_flag := 'P';
2405: END IF;