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_SUP_CAPTURE_DATA_PKG dependencies on FND_API

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

9: p_owner_table_id IN NUMBER,
10: p_created_by IN NUMBER,
11: p_last_updated_by IN NUMBER,
12: p_last_update_login IN NUMBER,
13: p_commit IN VARCHAR2 := FND_API.G_FALSE,
14: x_template_instance_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
15: X_RETURN_STATUS OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
16: X_MSG_COUNT OUT NOCOPY /* file.sql.39 change */ NUMBER,
17: X_MSG_DATA OUT NOCOPY /* file.sql.39 change */ VARCHAR2) IS

Line 57: IF fnd_api.to_boolean (p_commit) THEN

53: --WHEN OTHERS THEN
54: --x_template_instance_id := 0;
55: --END;
56:
57: IF fnd_api.to_boolean (p_commit) THEN
58: COMMIT WORK;
59: END IF;
60:
61: EXCEPTION

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

82: p_last_update_login IN NUMBER,
83: p_response_id IN NUMBER,
84: p_response_value IN VARCHAR2,
85: p_multiple_response_flag IN VARCHAR2,
86: p_commit IN VARCHAR2 := FND_API.G_FALSE,
87: X_RETURN_STATUS OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
88: X_MSG_COUNT OUT NOCOPY /* file.sql.39 change */ NUMBER,
89: X_MSG_DATA OUT NOCOPY /* file.sql.39 change */ VARCHAR2) IS
90:

Line 141: IF fnd_api.to_boolean (p_commit) THEN

137: END;
138: END IF;
139: END IF;
140: --COMMIT;
141: IF fnd_api.to_boolean (p_commit) THEN
142: COMMIT WORK;
143: END IF;
144:
145: EXCEPTION

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

160:
161: PROCEDURE delete_data (
162: p_template_instance_id IN NUMBER,
163: p_sect_comp_map_id IN NUMBER,
164: p_commit IN VARCHAR2 := FND_API.G_FALSE,
165: X_RETURN_STATUS OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
166: X_MSG_COUNT OUT NOCOPY /* file.sql.39 change */ NUMBER,
167: X_MSG_DATA OUT NOCOPY /* file.sql.39 change */ VARCHAR2) IS
168: l_api_name varchar2(50) := 'delete_data';

Line 180: IF fnd_api.to_boolean (p_commit) THEN

176: WHERE template_instance_id = p_template_instance_id
177: AND sect_comp_map_id = p_sect_comp_map_id;
178: END;
179: --COMMIT;
180: IF fnd_api.to_boolean (p_commit) THEN
181: COMMIT WORK;
182: END IF;
183:
184: EXCEPTION

Line 202: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

198:
199:
200: Procedure create_template_instance (
201: P_VERSION_NUMBER IN NUMBER,
202: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
203: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
204: P_Template_id IN NUMBER := FND_API.G_MISS_NUM,
205: P_comp_sect_map_id IN JTF_NUMBER_TABLE,
206: P_response_value IN JTF_VARCHAR2_TABLE_2000,

Line 203: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,

199:
200: Procedure create_template_instance (
201: P_VERSION_NUMBER IN NUMBER,
202: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
203: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
204: P_Template_id IN NUMBER := FND_API.G_MISS_NUM,
205: P_comp_sect_map_id IN JTF_NUMBER_TABLE,
206: P_response_value IN JTF_VARCHAR2_TABLE_2000,
207: P_response_id IN JTF_NUMBER_TABLE,

Line 204: P_Template_id IN NUMBER := FND_API.G_MISS_NUM,

200: Procedure create_template_instance (
201: P_VERSION_NUMBER IN NUMBER,
202: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
203: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
204: P_Template_id IN NUMBER := FND_API.G_MISS_NUM,
205: P_comp_sect_map_id IN JTF_NUMBER_TABLE,
206: P_response_value IN JTF_VARCHAR2_TABLE_2000,
207: P_response_id IN JTF_NUMBER_TABLE,
208: P_mult_ans_flag IN JTF_VARCHAR2_TABLE_100,

Line 209: P_owner_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

205: P_comp_sect_map_id IN JTF_NUMBER_TABLE,
206: P_response_value IN JTF_VARCHAR2_TABLE_2000,
207: P_response_id IN JTF_NUMBER_TABLE,
208: P_mult_ans_flag IN JTF_VARCHAR2_TABLE_100,
209: P_owner_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
210: P_owner_table_id IN NUMBER := FND_API.G_MISS_NUM,
211: X_template_instance_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
212: X_RETURN_STATUS OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
213: X_MSG_COUNT OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 210: P_owner_table_id IN NUMBER := FND_API.G_MISS_NUM,

206: P_response_value IN JTF_VARCHAR2_TABLE_2000,
207: P_response_id IN JTF_NUMBER_TABLE,
208: P_mult_ans_flag IN JTF_VARCHAR2_TABLE_100,
209: P_owner_table_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
210: P_owner_table_id IN NUMBER := FND_API.G_MISS_NUM,
211: X_template_instance_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
212: X_RETURN_STATUS OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
213: X_MSG_COUNT OUT NOCOPY /* file.sql.39 change */ NUMBER,
214: X_MSG_DATA OUT NOCOPY /* file.sql.39 change */ VARCHAR2) IS

Line 261: IF NOT FND_API.Compatible_API_Call ( l_api_version,

257: -- hyang: for bug 2710767, added pkg_type suffix to the savepoint.
258: SAVEPOINT create_template_instance_int;
259:
260: -- Standard call to check for call compatibility.
261: IF NOT FND_API.Compatible_API_Call ( l_api_version,
262: p_version_number,
263: l_api_name,
264: G_PKG_NAME)
265: THEN

Line 266: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

262: p_version_number,
263: l_api_name,
264: G_PKG_NAME)
265: THEN
266: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
267: END IF;
268:
269:
270: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 271: IF FND_API.to_Boolean( p_init_msg_list ) THEN

267: END IF;
268:
269:
270: -- Initialize message list if p_init_msg_list is set to TRUE.
271: IF FND_API.to_Boolean( p_init_msg_list ) THEN
272: FND_MSG_PUB.initialize;
273: END IF;
274:
275: ASO_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 280: x_return_status := FND_API.G_RET_STS_SUCCESS;

276: G_PKG_NAME || l_api_name||'start');
277:
278:
279: -- Initialize API return status to SUCCESS
280: x_return_status := FND_API.G_RET_STS_SUCCESS;
281:
282: --
283: -- API body
284: --

Line 296: RAISE FND_API.G_EXC_ERROR;

292: 'UT_CANNOT_GET_PROFILE_VALUE');
293: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
294: FND_MSG_PUB.ADD;
295: END IF;
296: RAISE FND_API.G_EXC_ERROR;
297: END IF;
298:
299:
300: IF P_owner_table_id IS NOT NULL THEN

Line 321: IF (lx_status = FND_API.G_TRUE) THEN

317: ASO_CONC_REQ_INT.Lock_Exists(
318: p_quote_header_id => l_header_id,
319: x_status => lx_status);
320:
321: IF (lx_status = FND_API.G_TRUE) THEN
322: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
323: FND_MESSAGE.Set_Name('ASO', 'ASO_CONC_REQUEST_RUNNING');
324: FND_MSG_PUB.ADD;
325: END IF;

Line 326: RAISE FND_API.G_EXC_ERROR;

322: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
323: FND_MESSAGE.Set_Name('ASO', 'ASO_CONC_REQUEST_RUNNING');
324: FND_MSG_PUB.ADD;
325: END IF;
326: RAISE FND_API.G_EXC_ERROR;
327: END IF;
328: END IF; -- table name check
329:
330: l_ownerTableName := P_owner_table_name;

Line 347: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

343: X_RETURN_STATUS => L_RETURN_STATUS,
344: X_MSG_COUNT => X_MSG_COUNT,
345: X_MSG_DATA => X_MSG_DATA
346: );
347: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
348: x_return_status := l_return_status;
349: RAISE FND_API.G_EXC_ERROR;
350: END IF;
351:

Line 349: RAISE FND_API.G_EXC_ERROR;

345: X_MSG_DATA => X_MSG_DATA
346: );
347: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
348: x_return_status := l_return_status;
349: RAISE FND_API.G_EXC_ERROR;
350: END IF;
351:
352: X_template_instance_id := lx_templateInstanceId;
353: l_templateInstance := lx_templateInstanceId;

Line 378: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

374: X_MSG_COUNT => X_MSG_COUNT,
375: X_MSG_DATA => X_MSG_DATA
376: );
377:
378: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
379: x_return_status := l_return_status;
380: RAISE FND_API.G_EXC_ERROR;
381: END IF;
382:

Line 380: RAISE FND_API.G_EXC_ERROR;

376: );
377:
378: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
379: x_return_status := l_return_status;
380: RAISE FND_API.G_EXC_ERROR;
381: END IF;
382:
383: ELSE
384: IF (l_temp <> l_compSectMapIds(l_sectLoop)) THEN

Line 396: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

392: X_MSG_DATA => X_MSG_DATA
393: );
394:
395:
396: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
397: x_return_status := l_return_status;
398: RAISE FND_API.G_EXC_ERROR;
399: END IF;
400:

Line 398: RAISE FND_API.G_EXC_ERROR;

394:
395:
396: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
397: x_return_status := l_return_status;
398: RAISE FND_API.G_EXC_ERROR;
399: END IF;
400:
401: l_temp := l_compSectMapIds(l_sectLoop);
402:

Line 419: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

415: X_MSG_COUNT => X_MSG_COUNT,
416: X_MSG_DATA => X_MSG_DATA
417: );
418:
419: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
420: x_return_status := l_return_status;
421: RAISE FND_API.G_EXC_ERROR;
422: END IF;
423:

Line 421: RAISE FND_API.G_EXC_ERROR;

417: );
418:
419: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
420: x_return_status := l_return_status;
421: RAISE FND_API.G_EXC_ERROR;
422: END IF;
423:
424: END IF;
425:

Line 430: WHEN FND_API.G_EXC_ERROR THEN

426: END LOOP;
427: --disable the debug message
428: ASO_Quote_Util_Pvt.disable_debug_pvt;
429: EXCEPTION
430: WHEN FND_API.G_EXC_ERROR THEN
431: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
432: P_API_NAME => L_API_NAME
433: ,P_PKG_NAME => G_PKG_NAME
434: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 440: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

436: ,X_MSG_COUNT => X_MSG_COUNT
437: ,X_MSG_DATA => X_MSG_DATA
438: ,X_RETURN_STATUS => X_RETURN_STATUS);
439: ASO_Quote_Util_Pvt.disable_debug_pvt;
440: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
441: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
442: P_API_NAME => L_API_NAME
443: ,P_PKG_NAME => G_PKG_NAME
444: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 464: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

460: END create_template_instance;
461:
462: PROCEDURE update_instance_value(
463: P_VERSION_NUMBER IN NUMBER,
464: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
465: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
466: P_Template_instance_id IN NUMBER := FND_API.G_MISS_NUM,
467: P_comp_sect_map_id IN JTF_NUMBER_TABLE,
468: P_response_value IN JTF_VARCHAR2_TABLE_2000,

Line 465: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,

461:
462: PROCEDURE update_instance_value(
463: P_VERSION_NUMBER IN NUMBER,
464: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
465: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
466: P_Template_instance_id IN NUMBER := FND_API.G_MISS_NUM,
467: P_comp_sect_map_id IN JTF_NUMBER_TABLE,
468: P_response_value IN JTF_VARCHAR2_TABLE_2000,
469: P_response_id IN JTF_NUMBER_TABLE,

Line 466: P_Template_instance_id IN NUMBER := FND_API.G_MISS_NUM,

462: PROCEDURE update_instance_value(
463: P_VERSION_NUMBER IN NUMBER,
464: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
465: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
466: P_Template_instance_id IN NUMBER := FND_API.G_MISS_NUM,
467: P_comp_sect_map_id IN JTF_NUMBER_TABLE,
468: P_response_value IN JTF_VARCHAR2_TABLE_2000,
469: P_response_id IN JTF_NUMBER_TABLE,
470: P_mult_ans_flag IN JTF_VARCHAR2_TABLE_100,

Line 527: IF NOT FND_API.Compatible_API_Call ( l_api_version,

523: -- hyang: for bug 2710767, added pkg_type suffix to the savepoint.
524: SAVEPOINT update_instance_value_int;
525:
526: -- Standard call to check for call compatibility.
527: IF NOT FND_API.Compatible_API_Call ( l_api_version,
528: p_version_number,
529: l_api_name,
530: G_PKG_NAME)
531: THEN

Line 532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

528: p_version_number,
529: l_api_name,
530: G_PKG_NAME)
531: THEN
532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
533: END IF;
534:
535:
536: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 537: IF FND_API.to_Boolean( p_init_msg_list ) THEN

533: END IF;
534:
535:
536: -- Initialize message list if p_init_msg_list is set to TRUE.
537: IF FND_API.to_Boolean( p_init_msg_list ) THEN
538: FND_MSG_PUB.initialize;
539: END IF;
540:
541: -- Debug Message

Line 546: x_return_status := FND_API.G_RET_STS_SUCCESS;

542: ASO_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
543: 'Private API: ' || l_api_name || 'start');
544:
545: -- Initialize API return status to SUCCESS
546: x_return_status := FND_API.G_RET_STS_SUCCESS;
547:
548: --
549: -- API body
550: --

Line 562: RAISE FND_API.G_EXC_ERROR;

558: 'UT_CANNOT_GET_PROFILE_VALUE');
559: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
560: FND_MSG_PUB.ADD;
561: END IF;
562: RAISE FND_API.G_EXC_ERROR;
563: END IF;
564:
565: -- hyang: for bug 2710767
566: OPEN c_quote (

Line 590: IF (lx_status = FND_API.G_TRUE) THEN

586: ASO_CONC_REQ_INT.Lock_Exists(
587: p_quote_header_id => l_header_id,
588: x_status => lx_status);
589:
590: IF (lx_status = FND_API.G_TRUE) THEN
591: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
592: FND_MESSAGE.Set_Name('ASO', 'ASO_CONC_REQUEST_RUNNING');
593: FND_MSG_PUB.ADD;
594: END IF;

Line 595: RAISE FND_API.G_EXC_ERROR;

591: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
592: FND_MESSAGE.Set_Name('ASO', 'ASO_CONC_REQUEST_RUNNING');
593: FND_MSG_PUB.ADD;
594: END IF;
595: RAISE FND_API.G_EXC_ERROR;
596: END IF;
597:
598: END IF; -- Check for table name
599: FOR l_sectLoop IN 1..l_compSectMapIds.COUNT LOOP

Line 616: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

612: X_MSG_COUNT => X_MSG_COUNT,
613: X_MSG_DATA => X_MSG_DATA
614: );
615:
616: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
617: x_return_status := l_return_status;
618: RAISE FND_API.G_EXC_ERROR;
619: END IF;
620:

Line 618: RAISE FND_API.G_EXC_ERROR;

614: );
615:
616: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
617: x_return_status := l_return_status;
618: RAISE FND_API.G_EXC_ERROR;
619: END IF;
620:
621:
622: ELSE

Line 634: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

630: X_MSG_COUNT => X_MSG_COUNT,
631: X_MSG_DATA => X_MSG_DATA
632: );
633:
634: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
635: x_return_status := l_return_status;
636: RAISE FND_API.G_EXC_ERROR;
637: END IF;
638:

Line 636: RAISE FND_API.G_EXC_ERROR;

632: );
633:
634: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
635: x_return_status := l_return_status;
636: RAISE FND_API.G_EXC_ERROR;
637: END IF;
638:
639: l_temp := l_compSectMapIds(l_sectLoop);
640:

Line 658: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

654: X_MSG_DATA => X_MSG_DATA
655: );
656:
657:
658: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
659: x_return_status := l_return_status;
660: RAISE FND_API.G_EXC_ERROR;
661: END IF;
662:

Line 660: RAISE FND_API.G_EXC_ERROR;

656:
657:
658: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
659: x_return_status := l_return_status;
660: RAISE FND_API.G_EXC_ERROR;
661: END IF;
662:
663: END IF;
664: END LOOP;

Line 668: WHEN FND_API.G_EXC_ERROR THEN

664: END LOOP;
665: --disable the debug message
666: ASO_Quote_Util_Pvt.disable_debug_pvt;
667: EXCEPTION
668: WHEN FND_API.G_EXC_ERROR THEN
669: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
670: P_API_NAME => L_API_NAME
671: ,P_PKG_NAME => G_PKG_NAME
672: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

674: ,X_MSG_COUNT => X_MSG_COUNT
675: ,X_MSG_DATA => X_MSG_DATA
676: ,X_RETURN_STATUS => X_RETURN_STATUS);
677: ASO_Quote_Util_Pvt.disable_debug_pvt;
678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
679: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
680: P_API_NAME => L_API_NAME
681: ,P_PKG_NAME => G_PKG_NAME
682: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR