eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PJI_MAP_ROWSET_MEASURE dependencies on FND_API

Line 28: x_return_status := FND_API.G_RET_STS_SUCCESS;

24: l_msg_data VARCHAR2(100);
25: l_msg_count NUMBER(10);
26:
27: BEGIN
28: x_return_status := FND_API.G_RET_STS_SUCCESS;
29: x_msg_count := 0;
30: l_check := 'N';
31:
32: if p_rowset_code is NULL then

Line 81: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

77: X_Msg_Count => l_msg_count);
78:
79: EXCEPTION
80: WHEN NULL_VALUE then
81: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
82: x_msg_count := x_msg_count + 1;
83: pji_rep_util.add_message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>FND_API.G_RET_STS_UNEXP_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Map_Rowset_Measure.insert_row');
84: WHEN OTHERS THEN
85: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 83: pji_rep_util.add_message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>FND_API.G_RET_STS_UNEXP_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Map_Rowset_Measure.insert_row');

79: EXCEPTION
80: WHEN NULL_VALUE then
81: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
82: x_msg_count := x_msg_count + 1;
83: pji_rep_util.add_message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>FND_API.G_RET_STS_UNEXP_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Map_Rowset_Measure.insert_row');
84: WHEN OTHERS THEN
85: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
86: x_msg_count := x_msg_count + 1;
87: pji_rep_util.add_message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>FND_API.G_RET_STS_UNEXP_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Map_Rowset_Measure.insert_row');

Line 85: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

81: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
82: x_msg_count := x_msg_count + 1;
83: pji_rep_util.add_message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>FND_API.G_RET_STS_UNEXP_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Map_Rowset_Measure.insert_row');
84: WHEN OTHERS THEN
85: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
86: x_msg_count := x_msg_count + 1;
87: pji_rep_util.add_message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>FND_API.G_RET_STS_UNEXP_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Map_Rowset_Measure.insert_row');
88: ROLLBACK;
89: --return;

Line 87: pji_rep_util.add_message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>FND_API.G_RET_STS_UNEXP_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Map_Rowset_Measure.insert_row');

83: pji_rep_util.add_message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>FND_API.G_RET_STS_UNEXP_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Map_Rowset_Measure.insert_row');
84: WHEN OTHERS THEN
85: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
86: x_msg_count := x_msg_count + 1;
87: pji_rep_util.add_message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>FND_API.G_RET_STS_UNEXP_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Map_Rowset_Measure.insert_row');
88: ROLLBACK;
89: --return;
90: END insert_row;
91:

Line 103: x_return_status := FND_API.G_RET_STS_SUCCESS;

99: x_err_msg_data OUT NOCOPY VARCHAR2)
100: IS
101: l_display_order_tbl SYSTEM.pa_num_tbl_type;
102: BEGIN
103: x_return_status := FND_API.G_RET_STS_SUCCESS;
104: x_msg_count := 0;
105: --Bug 3798976. Lock the header table before operating on the details.
106: --p_object_version_number passed in corresponds to the OVN of the rowset table.
107: PJI_MT_ROWSET_PKG.LOCK_ROW(

Line 158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

154:
155:
156: EXCEPTION
157: WHEN OTHERS THEN
158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
159: x_msg_count := x_msg_count + 1;
160: x_err_msg_data := SQLERRM;
161: ROLLBACK;
162: END create_map;

Line 180: x_return_status := FND_API.G_RET_STS_SUCCESS;

176: l_msg_data VARCHAR2(100);
177: l_msg_count NUMBER(10);
178:
179: BEGIN
180: x_return_status := FND_API.G_RET_STS_SUCCESS;
181: x_msg_count := 0;
182:
183: if(p_name is NULL) then
184: PA_UTILS.ADD_MESSAGE

Line 203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

199: X_Msg_Count => l_msg_count);
200:
201: EXCEPTION
202: WHEN NULL_VALUE THEN
203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
204: x_msg_count := x_msg_count + 1;
205: pji_rep_util.add_message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>FND_API.G_RET_STS_UNEXP_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Map_Rowset_Measure.update_row');
206: RAISE;
207: WHEN OTHERS THEN

Line 205: pji_rep_util.add_message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>FND_API.G_RET_STS_UNEXP_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Map_Rowset_Measure.update_row');

201: EXCEPTION
202: WHEN NULL_VALUE THEN
203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
204: x_msg_count := x_msg_count + 1;
205: pji_rep_util.add_message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>FND_API.G_RET_STS_UNEXP_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Map_Rowset_Measure.update_row');
206: RAISE;
207: WHEN OTHERS THEN
208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
209: x_msg_count := x_msg_count + 1;

Line 208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

204: x_msg_count := x_msg_count + 1;
205: pji_rep_util.add_message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>FND_API.G_RET_STS_UNEXP_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Map_Rowset_Measure.update_row');
206: RAISE;
207: WHEN OTHERS THEN
208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
209: x_msg_count := x_msg_count + 1;
210: pji_rep_util.add_message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>FND_API.G_RET_STS_UNEXP_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Map_Rowset_Measure.update_row');
211: ROLLBACK;
212: RAISE;

Line 210: pji_rep_util.add_message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>FND_API.G_RET_STS_UNEXP_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Map_Rowset_Measure.update_row');

206: RAISE;
207: WHEN OTHERS THEN
208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
209: x_msg_count := x_msg_count + 1;
210: pji_rep_util.add_message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>FND_API.G_RET_STS_UNEXP_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Map_Rowset_Measure.update_row');
211: ROLLBACK;
212: RAISE;
213: END update_row;
214:

Line 223: x_return_status := FND_API.G_RET_STS_SUCCESS;

219: x_err_msg_data OUT NOCOPY VARCHAR2)
220: IS
221:
222: BEGIN
223: x_return_status := FND_API.G_RET_STS_SUCCESS;
224: x_msg_count := 0;
225:
226: pji_mt_rowset_pkg.delete_row(p_rowset_code => p_rowset_code);
227:

Line 232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

228: delete from pji_mt_rowset_det where rowset_code=p_rowset_code;
229:
230: EXCEPTION
231: WHEN OTHERS THEN
232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
233: x_msg_count := x_msg_count + 1;
234: pji_rep_util.add_message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>FND_API.G_RET_STS_UNEXP_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Map_Rowset_Measure.delete_row');
235: END delete_row;
236:

Line 234: pji_rep_util.add_message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>FND_API.G_RET_STS_UNEXP_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Map_Rowset_Measure.delete_row');

230: EXCEPTION
231: WHEN OTHERS THEN
232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
233: x_msg_count := x_msg_count + 1;
234: pji_rep_util.add_message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>FND_API.G_RET_STS_UNEXP_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'Pji_Map_Rowset_Measure.delete_row');
235: END delete_row;
236:
237: end PJI_MAP_ROWSET_MEASURE;