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

Line 34: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,

30:
31: PROCEDURE Copy_Notes
32: (
33: p_api_version IN NUMBER ,
34: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
35: p_commit IN VARCHAR2 := FND_API.G_FALSE,
36: p_old_object_id IN NUMBER ,
37: p_new_object_id IN NUMBER ,
38: p_old_object_type_code IN VARCHAR2 ,

Line 35: p_commit IN VARCHAR2 := FND_API.G_FALSE,

31: PROCEDURE Copy_Notes
32: (
33: p_api_version IN NUMBER ,
34: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
35: p_commit IN VARCHAR2 := FND_API.G_FALSE,
36: p_old_object_id IN NUMBER ,
37: p_new_object_id IN NUMBER ,
38: p_old_object_type_code IN VARCHAR2 ,
39: p_new_object_type_code IN VARCHAR2 ,

Line 75: IF NOT FND_API.Compatible_API_Call(

71: -- Standard Start of API savepoint
72: SAVEPOINT Copy_Notes_int;
73:
74: -- Standard call to check for call compatibility.
75: IF NOT FND_API.Compatible_API_Call(
76: L_API_VERSION,
77: p_api_version,
78: L_API_NAME ,
79: G_PKG_NAME

Line 82: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

78: L_API_NAME ,
79: G_PKG_NAME
80: )
81: THEN
82: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
83: END IF;
84:
85: -- Initialize message list if p_init_msg_list is set to TRUE.
86: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 86: IF FND_API.To_Boolean(p_init_msg_list) THEN

82: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
83: END IF;
84:
85: -- Initialize message list if p_init_msg_list is set to TRUE.
86: IF FND_API.To_Boolean(p_init_msg_list) THEN
87: FND_Msg_Pub.initialize;
88: END IF;
89:
90: -- Initialize API return status to success

Line 91: x_return_status := FND_API.G_RET_STS_SUCCESS;

87: FND_Msg_Pub.initialize;
88: END IF;
89:
90: -- Initialize API return status to success
91: x_return_status := FND_API.G_RET_STS_SUCCESS;
92:
93: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
94: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes: Begin Copy_Notes()', 1, 'Y');
95: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes: old_object_id: ' || p_old_object_id, 1, 'N');

Line 109: p_validation_level => FND_API.G_VALID_LEVEL_NONE,

105: END IF;
106:
107:
108: JTF_NOTES_PUB.Create_Note_Context(
109: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
110: x_return_status => x_return_status ,
111: p_jtf_note_id => l_note_rec.jtf_note_id ,
112: p_last_update_date => l_sysdate ,
113: p_last_updated_by => FND_Global.USER_ID ,

Line 123: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

119: x_note_context_id => lx_jtf_note_context_id
120: );
121:
122:
123: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
124: RAISE FND_API.G_EXC_ERROR;
125: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
127: END IF;

Line 124: RAISE FND_API.G_EXC_ERROR;

120: );
121:
122:
123: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
124: RAISE FND_API.G_EXC_ERROR;
125: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
127: END IF;
128:

Line 125: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

121:
122:
123: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
124: RAISE FND_API.G_EXC_ERROR;
125: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
127: END IF;
128:
129: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

122:
123: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
124: RAISE FND_API.G_EXC_ERROR;
125: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
127: END IF;
128:
129: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
130: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes: lx_jtf_note_context_id :' || lx_jtf_note_context_id, 1, 'N');

Line 141: IF FND_API.To_Boolean(p_commit) THEN

137: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes: End Copy_Notes()', 1, 'Y');
138: END IF;
139:
140: -- Standard check of p_commit.
141: IF FND_API.To_Boolean(p_commit) THEN
142: COMMIT WORK;
143: END IF;
144:
145: -- Standard call to get message count and if count is 1, get message info.

Line 147: p_encoded => FND_API.G_FALSE,

143: END IF;
144:
145: -- Standard call to get message count and if count is 1, get message info.
146: FND_Msg_Pub.Count_And_Get(
147: p_encoded => FND_API.G_FALSE,
148: p_count => x_msg_count ,
149: p_data => x_msg_data
150: );
151:

Line 153: WHEN FND_API.G_EXC_ERROR THEN

149: p_data => x_msg_data
150: );
151:
152: EXCEPTION
153: WHEN FND_API.G_EXC_ERROR THEN
154: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
155: P_API_NAME => L_API_NAME,
156: P_PKG_NAME => G_PKG_NAME,
157: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 166: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

162: X_MSG_DATA => X_MSG_DATA,
163: X_RETURN_STATUS => X_RETURN_STATUS
164: );
165:
166: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
167: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
168: P_API_NAME => L_API_NAME,
169: P_PKG_NAME => G_PKG_NAME,
170: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,

Line 210: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,

206:
207: PROCEDURE Copy_Opp_Notes_To_Qte
208: (
209: p_api_version IN NUMBER ,
210: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
211: p_commit IN VARCHAR2 := FND_API.G_FALSE,
212: p_old_object_id IN NUMBER ,
213: p_new_object_id IN NUMBER ,
214: p_old_object_type_code IN VARCHAR2 ,

Line 211: p_commit IN VARCHAR2 := FND_API.G_FALSE,

207: PROCEDURE Copy_Opp_Notes_To_Qte
208: (
209: p_api_version IN NUMBER ,
210: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
211: p_commit IN VARCHAR2 := FND_API.G_FALSE,
212: p_old_object_id IN NUMBER ,
213: p_new_object_id IN NUMBER ,
214: p_old_object_type_code IN VARCHAR2 ,
215: p_new_object_type_code IN VARCHAR2 ,

Line 252: IF NOT FND_API.Compatible_API_Call(

248: -- Standard Start of API savepoint
249: SAVEPOINT Copy_Opp_Notes_To_Qte_int;
250:
251: -- Standard call to check for call compatibility.
252: IF NOT FND_API.Compatible_API_Call(
253: L_API_VERSION,
254: p_api_version,
255: L_API_NAME ,
256: G_PKG_NAME

Line 259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

255: L_API_NAME ,
256: G_PKG_NAME
257: )
258: THEN
259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
260: END IF;
261:
262: -- Initialize message list if p_init_msg_list is set to TRUE.
263: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 263: IF FND_API.To_Boolean(p_init_msg_list) THEN

259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
260: END IF;
261:
262: -- Initialize message list if p_init_msg_list is set to TRUE.
263: IF FND_API.To_Boolean(p_init_msg_list) THEN
264: FND_Msg_Pub.initialize;
265: END IF;
266:
267: -- Initialize API return status to success

Line 268: x_return_status := FND_API.G_RET_STS_SUCCESS;

264: FND_Msg_Pub.initialize;
265: END IF;
266:
267: -- Initialize API return status to success
268: x_return_status := FND_API.G_RET_STS_SUCCESS;
269:
270: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
271: aso_debug_pub.add('ASO_NOTES_INT: Copy_Opp_Notes_To_Qte: Begin Copy_Notes()', 1, 'Y');
272: aso_debug_pub.add('ASO_NOTES_INT: Copy_Opp_Notes_To_Qte: old_object_id: ' || p_old_object_id, 1, 'N');

Line 286: p_validation_level => FND_API.G_VALID_LEVEL_NONE,

282: END IF;
283:
284:
285: JTF_NOTES_PUB.Create_Note_Context(
286: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
287: x_return_status => x_return_status ,
288: p_jtf_note_id => l_note_rec.jtf_note_id ,
289: p_last_update_date => l_sysdate ,
290: p_last_updated_by => FND_Global.USER_ID ,

Line 300: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

296: x_note_context_id => lx_jtf_note_context_id
297: );
298:
299:
300: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
301: RAISE FND_API.G_EXC_ERROR;
302: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
304: END IF;

Line 301: RAISE FND_API.G_EXC_ERROR;

297: );
298:
299:
300: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
301: RAISE FND_API.G_EXC_ERROR;
302: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
304: END IF;
305:

Line 302: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

298:
299:
300: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
301: RAISE FND_API.G_EXC_ERROR;
302: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
304: END IF;
305:
306: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

299:
300: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
301: RAISE FND_API.G_EXC_ERROR;
302: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
304: END IF;
305:
306: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
307: aso_debug_pub.add('ASO_NOTES_INT: Copy_Opp_Notes_To_Qte: lx_jtf_note_context_id: ' || lx_jtf_note_context_id, 1, 'N');

Line 318: IF FND_API.To_Boolean(p_commit) THEN

314: aso_debug_pub.add('ASO_NOTES_INT: Copy_Opp_Notes_To_Qte: End Copy_Opp_Notes_To_Qte()', 1, 'Y');
315: END IF;
316:
317: -- Standard check of p_commit.
318: IF FND_API.To_Boolean(p_commit) THEN
319: COMMIT WORK;
320: END IF;
321:
322: -- Standard call to get message count and if count is 1, get message info.

Line 324: p_encoded => FND_API.G_FALSE,

320: END IF;
321:
322: -- Standard call to get message count and if count is 1, get message info.
323: FND_Msg_Pub.Count_And_Get(
324: p_encoded => FND_API.G_FALSE,
325: p_count => x_msg_count ,
326: p_data => x_msg_data
327: );
328:

Line 330: WHEN FND_API.G_EXC_ERROR THEN

326: p_data => x_msg_data
327: );
328:
329: EXCEPTION
330: WHEN FND_API.G_EXC_ERROR THEN
331: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
332: P_API_NAME => L_API_NAME,
333: P_PKG_NAME => G_PKG_NAME,
334: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 343: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

339: X_MSG_DATA => X_MSG_DATA,
340: X_RETURN_STATUS => X_RETURN_STATUS
341: );
342:
343: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
344: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
345: P_API_NAME => L_API_NAME,
346: P_PKG_NAME => G_PKG_NAME,
347: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,

Line 375: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,

371:
372: PROCEDURE Copy_Notes_copy_quote
373: (
374: p_api_version IN NUMBER ,
375: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
376: p_commit IN VARCHAR2 := FND_API.G_FALSE,
377: p_old_object_id IN NUMBER ,
378: p_new_object_id IN NUMBER ,
379: p_old_object_type_code IN VARCHAR2 ,

Line 376: p_commit IN VARCHAR2 := FND_API.G_FALSE,

372: PROCEDURE Copy_Notes_copy_quote
373: (
374: p_api_version IN NUMBER ,
375: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
376: p_commit IN VARCHAR2 := FND_API.G_FALSE,
377: p_old_object_id IN NUMBER ,
378: p_new_object_id IN NUMBER ,
379: p_old_object_type_code IN VARCHAR2 ,
380: p_new_object_type_code IN VARCHAR2 ,

Line 441: IF NOT FND_API.Compatible_API_Call(

437: -- Standard Start of API savepoint
438: SAVEPOINT Copy_Notes_int;
439:
440: -- Standard call to check for call compatibility.
441: IF NOT FND_API.Compatible_API_Call(
442: L_API_VERSION,
443: p_api_version,
444: L_API_NAME ,
445: G_PKG_NAME

Line 448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

444: L_API_NAME ,
445: G_PKG_NAME
446: )
447: THEN
448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
449: END IF;
450:
451: -- Initialize message list if p_init_msg_list is set to TRUE.
452: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 452: IF FND_API.To_Boolean(p_init_msg_list) THEN

448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
449: END IF;
450:
451: -- Initialize message list if p_init_msg_list is set to TRUE.
452: IF FND_API.To_Boolean(p_init_msg_list) THEN
453: FND_Msg_Pub.initialize;
454: END IF;
455:
456: -- Initialize API return status to success

Line 457: x_return_status := FND_API.G_RET_STS_SUCCESS;

453: FND_Msg_Pub.initialize;
454: END IF;
455:
456: -- Initialize API return status to success
457: x_return_status := FND_API.G_RET_STS_SUCCESS;
458:
459: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
460: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes_copy_quote: Begin Copy_Notes()', 1, 'Y');
461: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes_copy_quote: old_object_id: ' || p_old_object_id, 1, 'N');

Line 483: p_init_msg_list => FND_API.G_FALSE ,

479:
480: JTF_NOTES_PUB.Create_Note(
481: p_parent_note_id => l_note_rec.parent_note_id ,
482: p_api_version => 1.0 ,
483: p_init_msg_list => FND_API.G_FALSE ,
484: p_commit => FND_API.G_FALSE ,
485: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
486: x_return_status => x_return_status ,
487: x_msg_count => x_msg_count ,

Line 484: p_commit => FND_API.G_FALSE ,

480: JTF_NOTES_PUB.Create_Note(
481: p_parent_note_id => l_note_rec.parent_note_id ,
482: p_api_version => 1.0 ,
483: p_init_msg_list => FND_API.G_FALSE ,
484: p_commit => FND_API.G_FALSE ,
485: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
486: x_return_status => x_return_status ,
487: x_msg_count => x_msg_count ,
488: x_msg_data => x_msg_data ,

Line 485: p_validation_level => FND_API.G_VALID_LEVEL_NONE,

481: p_parent_note_id => l_note_rec.parent_note_id ,
482: p_api_version => 1.0 ,
483: p_init_msg_list => FND_API.G_FALSE ,
484: p_commit => FND_API.G_FALSE ,
485: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
486: x_return_status => x_return_status ,
487: x_msg_count => x_msg_count ,
488: x_msg_data => x_msg_data ,
489: p_source_object_id => p_new_object_id ,

Line 520: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

516: p_note_type => l_note_rec.note_type ,
517: p_jtf_note_contexts_tab => l_jtf_note_contexts_tab
518: );
519:
520: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
521: RAISE FND_API.G_EXC_ERROR;
522: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
524: END IF;

Line 521: RAISE FND_API.G_EXC_ERROR;

517: p_jtf_note_contexts_tab => l_jtf_note_contexts_tab
518: );
519:
520: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
521: RAISE FND_API.G_EXC_ERROR;
522: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
524: END IF;
525:

Line 522: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

518: );
519:
520: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
521: RAISE FND_API.G_EXC_ERROR;
522: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
524: END IF;
525:
526: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

519:
520: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
521: RAISE FND_API.G_EXC_ERROR;
522: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
524: END IF;
525:
526: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
527: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes_copy_quote: l_jtf_note_id: ' || l_jtf_note_id, 1, 'N');

Line 538: IF FND_API.To_Boolean(p_commit) THEN

534: aso_debug_pub.add('ASO_NOTES_INT: Copy_Notes_copy_quote: End Copy_Notes_copy_quote()', 1, 'Y');
535: END IF;
536:
537: -- Standard check of p_commit.
538: IF FND_API.To_Boolean(p_commit) THEN
539: COMMIT WORK;
540: END IF;
541:
542: -- Standard call to get message count and if count is 1, get message info.

Line 544: p_encoded => FND_API.G_FALSE,

540: END IF;
541:
542: -- Standard call to get message count and if count is 1, get message info.
543: FND_Msg_Pub.Count_And_Get(
544: p_encoded => FND_API.G_FALSE,
545: p_count => x_msg_count ,
546: p_data => x_msg_data
547: );
548:

Line 550: WHEN FND_API.G_EXC_ERROR THEN

546: p_data => x_msg_data
547: );
548:
549: EXCEPTION
550: WHEN FND_API.G_EXC_ERROR THEN
551: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
552: P_API_NAME => L_API_NAME,
553: P_PKG_NAME => G_PKG_NAME,
554: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 563: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

559: X_MSG_DATA => X_MSG_DATA,
560: X_RETURN_STATUS => X_RETURN_STATUS
561: );
562:
563: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
564: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
565: P_API_NAME => L_API_NAME,
566: P_PKG_NAME => G_PKG_NAME,
567: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,