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.CSM_NOTES_PKG dependencies on FND_API

Line 50: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

46: || ' for PK ' || p_record.jtf_note_id ,
47: 'CSM_NOTES_PKG.APPLY_INSERT',FND_LOG.LEVEL_EVENT);
48: jtf_notes_pub.Create_note
49: ( p_api_version => 1.0
50: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
51: , p_init_msg_list => FND_API.G_TRUE
52: , p_commit => FND_API.G_FALSE
53: , x_return_status => x_return_status
54: , x_msg_count => l_msg_count

Line 51: , p_init_msg_list => FND_API.G_TRUE

47: 'CSM_NOTES_PKG.APPLY_INSERT',FND_LOG.LEVEL_EVENT);
48: jtf_notes_pub.Create_note
49: ( p_api_version => 1.0
50: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
51: , p_init_msg_list => FND_API.G_TRUE
52: , p_commit => FND_API.G_FALSE
53: , x_return_status => x_return_status
54: , x_msg_count => l_msg_count
55: , x_msg_data => l_msg_data

Line 52: , p_commit => FND_API.G_FALSE

48: jtf_notes_pub.Create_note
49: ( p_api_version => 1.0
50: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
51: , p_init_msg_list => FND_API.G_TRUE
52: , p_commit => FND_API.G_FALSE
53: , x_return_status => x_return_status
54: , x_msg_count => l_msg_count
55: , x_msg_data => l_msg_data
56: , p_jtf_note_id => p_record.jtf_note_id

Line 73: if x_return_status <> FND_API.G_RET_STS_SUCCESS

69: , p_last_update_login => FND_GLOBAL.LOGIN_ID
70: , x_jtf_note_id => l_jtf_note_id
71: );
72:
73: if x_return_status <> FND_API.G_RET_STS_SUCCESS
74: then
75: /*** exception occurred in API -> return errmsg ***/
76: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
77: (

Line 84: x_return_status := FND_API.G_RET_STS_ERROR;

80: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'
81: || ' ROOT ERROR: jtf_notes_pub.create_note'
82: || ' for PK ' || p_record.JTF_NOTE_ID ,'CSM_NOTES_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR );
83:
84: x_return_status := FND_API.G_RET_STS_ERROR;
85: else
86: x_return_status := FND_API.G_RET_STS_SUCCESS;
87: end if;
88:

Line 86: x_return_status := FND_API.G_RET_STS_SUCCESS;

82: || ' for PK ' || p_record.JTF_NOTE_ID ,'CSM_NOTES_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR );
83:
84: x_return_status := FND_API.G_RET_STS_ERROR;
85: else
86: x_return_status := FND_API.G_RET_STS_SUCCESS;
87: end if;
88:
89: exception
90: when others then

Line 98: x_return_status := FND_API.G_RET_STS_ERROR;

94: p_api_error => TRUE
95: );
96: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_INSERT:'
97: || ' for PK ' || p_record.jtf_note_id , 'CSM_NOTES_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR);
98: x_return_status := FND_API.G_RET_STS_ERROR;
99:
100: END APPLY_INSERT;
101:
102:

Line 142: x_return_status := FND_API.G_RET_STS_ERROR;

138: -- SERVER_WINS profile value
139: if(fnd_profile.value(csm_profile_pkg.g_JTM_APPL_CONFLICT_RULE)
140: = csm_profile_pkg.g_SERVER_WINS) then
141: if(l_server_last_update_date <> p_record.server_last_update_date) then
142: x_return_status := FND_API.G_RET_STS_ERROR;
143: p_error_msg := 'UPWARD SYNC CONFLICT: CLIENT LOST: CSM_NOTES_PKG.APPLY_UPDATE: P_KEY = '
144: || p_record.jtf_note_id;
145: csm_util_pkg.log(p_error_msg,'CSM_NOTES_PKG.APPLY_UPDATE',FND_LOG.LEVEL_EVENT );
146: return;

Line 155: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

151:
152: --update the note
153: jtf_notes_pub.Update_note
154: ( p_api_version => 1.0
155: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
156: , p_init_msg_list => FND_API.G_TRUE
157: , p_commit => FND_API.G_FALSE
158: , x_return_status => x_return_status
159: , x_msg_count => l_msg_count

Line 156: , p_init_msg_list => FND_API.G_TRUE

152: --update the note
153: jtf_notes_pub.Update_note
154: ( p_api_version => 1.0
155: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
156: , p_init_msg_list => FND_API.G_TRUE
157: , p_commit => FND_API.G_FALSE
158: , x_return_status => x_return_status
159: , x_msg_count => l_msg_count
160: , x_msg_data => l_msg_data

Line 157: , p_commit => FND_API.G_FALSE

153: jtf_notes_pub.Update_note
154: ( p_api_version => 1.0
155: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
156: , p_init_msg_list => FND_API.G_TRUE
157: , p_commit => FND_API.G_FALSE
158: , x_return_status => x_return_status
159: , x_msg_count => l_msg_count
160: , x_msg_data => l_msg_data
161: , p_jtf_note_id => p_record.jtf_note_id

Line 172: if x_return_status <> FND_API.G_RET_STS_SUCCESS

168: , p_last_update_date => SYSDATE
169: , p_last_update_login => FND_GLOBAL.LOGIN_ID
170: );
171:
172: if x_return_status <> FND_API.G_RET_STS_SUCCESS
173: then
174: /*** exception occurred in API -> return errmsg ***/
175: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
176: (

Line 183: x_return_status := FND_API.G_RET_STS_ERROR;

179: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_UPDATE:'
180: || ' ROOT ERROR: jtf_notes_pub.update_note'
181: || ' for PK ' || p_record.JTF_NOTE_ID ,'CSM_NOTES_PKG.APPLY_UPDATE',FND_LOG.LEVEL_ERROR );
182:
183: x_return_status := FND_API.G_RET_STS_ERROR;
184: else
185: x_return_status := FND_API.G_RET_STS_SUCCESS;
186: end if;
187:

Line 185: x_return_status := FND_API.G_RET_STS_SUCCESS;

181: || ' for PK ' || p_record.JTF_NOTE_ID ,'CSM_NOTES_PKG.APPLY_UPDATE',FND_LOG.LEVEL_ERROR );
182:
183: x_return_status := FND_API.G_RET_STS_ERROR;
184: else
185: x_return_status := FND_API.G_RET_STS_SUCCESS;
186: end if;
187:
188: CSM_UTIL_PKG.log( 'Exiting ' || g_object_name || '.APPLY_UPDATE:'
189: || ' for PK ' || p_record.jtf_note_id,

Line 205: x_return_status := FND_API.G_RET_STS_ERROR;

201: || ' for PK ' || p_record.jtf_note_id,
202: 'CSM_NOTES_PKG.APPLY_UPDATE',
203: FND_LOG.LEVEL_ERROR );
204:
205: x_return_status := FND_API.G_RET_STS_ERROR;
206: END APPLY_UPDATE;
207:
208: /***
209: This procedure is called by APPLY_CLIENT_CHANGES for every record in in-queue that needs to be processed.

Line 219: x_return_status := FND_API.G_RET_STS_SUCCESS;

215: x_return_status IN OUT NOCOPY VARCHAR2
216: ) IS
217: BEGIN
218: /*** initialize return status and message list ***/
219: x_return_status := FND_API.G_RET_STS_SUCCESS;
220: FND_MSG_PUB.INITIALIZE;
221:
222: IF p_record.dmltype$$='I' THEN
223: -- Process insert

Line 253: x_return_status := FND_API.G_RET_STS_ERROR;

249: , p_token_name1 => 'DML'
250: , p_token_value1 => p_record.dmltype$$
251: );
252:
253: x_return_status := FND_API.G_RET_STS_ERROR;
254: END IF;
255:
256: EXCEPTION WHEN OTHERS THEN
257: /*** defer record when any process exception occurs ***/

Line 270: x_return_status := FND_API.G_RET_STS_ERROR;

266: (
267: p_api_error => TRUE
268: );
269:
270: x_return_status := FND_API.G_RET_STS_ERROR;
271: END APPLY_RECORD;
272:
273: /***
274: This procedure is called by CSM_UTIL_PKG when publication item

Line 291: x_return_status := FND_API.G_RET_STS_SUCCESS;

287: l_process_status VARCHAR2(1);
288: l_error_msg VARCHAR2(4000);
289: BEGIN
290: g_debug_level := p_debug_level;
291: x_return_status := FND_API.G_RET_STS_SUCCESS;
292:
293:
294:
295: /*** loop through debrief labor records in inqueue ***/

Line 309: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN

305: , l_process_status
306: );
307:
308: /*** was record processed successfully? ***/
309: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
310: /*** Yes -> delete record from inqueue ***/
311:
312: CSM_UTIL_PKG.DELETE_RECORD
313: (

Line 325: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

321: l_process_status
322: );
323:
324: /*** was delete successful? ***/
325: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
326: /*** no -> rollback ***/
327: CSM_UTIL_PKG.LOG
328: ( 'Deleting from inqueue failed, rolling back to savepoint'
329: || ' for PK ' || r_notes.jtf_note_id,

Line 333: x_return_status := FND_API.G_RET_STS_ERROR;

329: || ' for PK ' || r_notes.jtf_note_id,
330: 'CSM_NOTES_PKG.APPLY_CLIENT_CHANGES',
331: FND_LOG.LEVEL_EVENT ); -- put PK column here
332: ROLLBACK TO save_rec;
333: x_return_status := FND_API.G_RET_STS_ERROR;
334: END IF;
335: END IF;
336:
337: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN

Line 337: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN

333: x_return_status := FND_API.G_RET_STS_ERROR;
334: END IF;
335: END IF;
336:
337: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
338: /*** Record was not processed successfully or delete failed -> defer and reject record ***/
339: CSM_UTIL_PKG.LOG
340: ( 'Record not processed successfully, deferring and rejecting record'
341: || ' for PK ' || r_notes.jtf_note_id,

Line 359: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

355: , r_notes.dmltype$$
356: );
357:
358: /*** Was defer successful? ***/
359: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
360: /*** no -> rollback ***/
361: CSM_UTIL_PKG.LOG
362: ( 'Defer record failed, rolling back to savepoint'
363: || ' for PK ' || r_notes.jtf_note_id,

Line 367: x_return_status := FND_API.G_RET_STS_ERROR;

363: || ' for PK ' || r_notes.jtf_note_id,
364: 'CSM_NOTES_PKG.APPLY_CLIENT_CHANGES',
365: FND_LOG.LEVEL_EVENT ); -- put PK column here
366: ROLLBACK TO save_rec;
367: x_return_status := FND_API.G_RET_STS_ERROR;
368: END IF;
369: END IF;
370:
371: END LOOP;

Line 380: x_return_status := FND_API.G_RET_STS_ERROR;

376: ( 'Exception occurred in APPLY_CLIENT_CHANGES:' || ' ' || sqlerrm ,
377: 'CSM_NOTES_PKG.APPLY_CLIENT_CHANGES',
378: FND_LOG.LEVEL_ERROR
379: );
380: x_return_status := FND_API.G_RET_STS_ERROR;
381: END APPLY_CLIENT_CHANGES;
382:
383: END CSM_NOTES_PKG;
384: