APPS.PJI_CM_UTIL dependencies on FND_API

Line 16: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

12: l_char VARCHAR2(1);
13: BEGIN
14:
15: IF x_return_status IS NULL THEN
16: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
17: x_msg_count :=0;
18: END IF;
19:
20: l_stat := ' CREATE OR REPLACE PACKAGE PJI_CALC_ENGINE AS '

Line 60: x_return_status := Fnd_Api.G_RET_STS_ERROR;

56: */ EXECUTE IMMEDIATE l_stat;
57:
58: EXCEPTION
59: WHEN OTHERS THEN
60: x_return_status := Fnd_Api.G_RET_STS_ERROR;
61: x_msg_count := x_msg_count + 1;
62: -- DBMS_OUTPUT.put_line(SQLERRM);
63: RAISE;
64: END;

Line 115: || ' x_return_status := Fnd_Api.G_RET_STS_SUCCESS; ' ;

111: l_stat := l_stat || ' BEGIN '
112: || ' x_custom_measures := SYSTEM.PA_Num_Tbl_Type(); '
113: || ' x_custom_measures.extend(15); '
114: || ' x_msg_count := 0; '
115: || ' x_return_status := Fnd_Api.G_RET_STS_SUCCESS; ' ;
116:
117: l_counter := 1;
118: OPEN c_custom_measure;
119: LOOP

Line 162: l_return_status VARCHAR2(1) :=Fnd_Api.G_RET_STS_SUCCESS;

158: ,X_return_status OUT NOCOPY VARCHAR2
159: ,X_msg_data OUT NOCOPY VARCHAR2
160: ,X_msg_count OUT NOCOPY NUMBER
161: ) AS
162: l_return_status VARCHAR2(1) :=Fnd_Api.G_RET_STS_SUCCESS;
163: l_msg_count NUMBER :=0;
164: l_msg_data VARCHAR2(200);
165: l_itd_measure_id NUMBER;
166: l_ptd_measure_id NUMBER ;

Line 174: X_return_status :=Fnd_Api.G_RET_STS_SUCCESS;

170: l_msg_index_out NUMBER;
171: l_data VARCHAR2(200);
172: l_rowid ROWID;
173: BEGIN
174: X_return_status :=Fnd_Api.G_RET_STS_SUCCESS;
175: IF p_itd_measure_id IS NOT NULL THEN
176: IF p_itd_name IS NOT NULL THEN
177: UPDATE Pji_Mt_Measures_Tl
178: SET Name = p_itd_name,

Line 383: x_return_status := Fnd_Api.G_RET_STS_ERROR;

379:
380: EXCEPTION
381: WHEN NO_DATA_FOUND THEN
382:
383: x_return_status := Fnd_Api.G_RET_STS_ERROR;
384: l_msg_count := Fnd_Msg_Pub.count_msg;
385:
386: IF l_msg_count = 1 AND x_msg_data IS NULL THEN
387: Pa_Interface_Utils_Pub.get_messages

Line 388: (p_encoded => Fnd_Api.G_TRUE

384: l_msg_count := Fnd_Msg_Pub.count_msg;
385:
386: IF l_msg_count = 1 AND x_msg_data IS NULL THEN
387: Pa_Interface_Utils_Pub.get_messages
388: (p_encoded => Fnd_Api.G_TRUE
389: ,p_msg_index => 1
390: ,p_msg_count => l_msg_count
391: ,p_msg_data => l_msg_data
392: ,p_data => l_data

Line 408: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

404: RAISE NO_DATA_FOUND;
405:
406: WHEN OTHERS THEN
407:
408: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
409: x_msg_count := 1;
410: x_msg_data := SQLERRM;
411:
412: Fnd_Msg_Pub.add_exc_msg