DBA Data[Home] [Help]

APPS.ASO_CONTRACT_TERMS_INT dependencies on FND_API

Line 36: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

32:
33:
34: PROCEDURE Get_Article_Variable_Values (
35: p_api_version IN NUMBER,
36: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
37: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
38: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
39: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
40: p_doc_id IN NUMBER,

Line 89: IF NOT fnd_api.compatible_api_call (

85:
86: BEGIN
87:
88: -- Standard call to check for call compatibility.
89: IF NOT fnd_api.compatible_api_call (
90: l_api_version,
91: p_api_version,
92: l_api_name,
93: g_pkg_name

Line 96: RAISE fnd_api.g_exc_unexpected_error;

92: l_api_name,
93: g_pkg_name
94: )
95: THEN
96: RAISE fnd_api.g_exc_unexpected_error;
97: END IF;
98:
99: -- Initialize message list if p_init_msg_list is set to TRUE.
100: IF fnd_api.to_boolean (

Line 100: IF fnd_api.to_boolean (

96: RAISE fnd_api.g_exc_unexpected_error;
97: END IF;
98:
99: -- Initialize message list if p_init_msg_list is set to TRUE.
100: IF fnd_api.to_boolean (
101: p_init_msg_list
102: )
103: THEN
104: fnd_msg_pub.initialize;

Line 108: x_return_status := fnd_api.g_ret_sts_success;

104: fnd_msg_pub.initialize;
105: END IF;
106:
107: -- Initialize API return status to SUCCESS
108: x_return_status := fnd_api.g_ret_sts_success;
109:
110: --
111: -- API body
112: --

Line 384: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

380: END Get_Article_Variable_Values;
381:
382: PROCEDURE Get_Line_Variable_Values (
383: p_api_version IN NUMBER,
384: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
385: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
386: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
387: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
388: p_doc_id IN NUMBER,

Line 402: IF NOT fnd_api.compatible_api_call (

398:
399: BEGIN
400:
401: -- Standard call to check for call compatibility.
402: IF NOT fnd_api.compatible_api_call (
403: l_api_version,
404: p_api_version,
405: l_api_name,
406: g_pkg_name

Line 409: RAISE fnd_api.g_exc_unexpected_error;

405: l_api_name,
406: g_pkg_name
407: )
408: THEN
409: RAISE fnd_api.g_exc_unexpected_error;
410: END IF;
411:
412: -- Initialize message list if p_init_msg_list is set to TRUE.
413: IF fnd_api.to_boolean (

Line 413: IF fnd_api.to_boolean (

409: RAISE fnd_api.g_exc_unexpected_error;
410: END IF;
411:
412: -- Initialize message list if p_init_msg_list is set to TRUE.
413: IF fnd_api.to_boolean (
414: p_init_msg_list
415: )
416: THEN
417: fnd_msg_pub.initialize;

Line 421: x_return_status := fnd_api.g_ret_sts_success;

417: fnd_msg_pub.initialize;
418: END IF;
419:
420: -- Initialize API return status to SUCCESS
421: x_return_status := fnd_api.g_ret_sts_success;
422:
423: --
424: -- API body
425: --

Line 523: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

519: END Get_Line_Variable_Values;
520:
521: FUNCTION OK_To_Commit (
522: p_api_version IN NUMBER,
523: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
524: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
525: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
526: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
527: p_doc_id IN NUMBER,

Line 539: l_return VARCHAR2 (1) := FND_API.G_TRUE;

535: l_update_allowed VARCHAR2 (1);
536: l_quote_version NUMBER;
537: l_quote_expiration_date DATE;
538: l_price_request_id NUMBER;
539: l_return VARCHAR2 (1) := FND_API.G_TRUE;
540:
541: CURSOR c_quote_header
542: IS
543: SELECT status.update_allowed_flag, quote.quote_expiration_date,

Line 552: IF NOT fnd_api.compatible_api_call (

548:
549: BEGIN
550:
551: -- Standard call to check for call compatibility.
552: IF NOT fnd_api.compatible_api_call (
553: l_api_version,
554: p_api_version,
555: l_api_name,
556: g_pkg_name

Line 559: RAISE fnd_api.g_exc_unexpected_error;

555: l_api_name,
556: g_pkg_name
557: )
558: THEN
559: RAISE fnd_api.g_exc_unexpected_error;
560: END IF;
561:
562: -- Initialize message list if p_init_msg_list is set to TRUE.
563: IF fnd_api.to_boolean (

Line 563: IF fnd_api.to_boolean (

559: RAISE fnd_api.g_exc_unexpected_error;
560: END IF;
561:
562: -- Initialize message list if p_init_msg_list is set to TRUE.
563: IF fnd_api.to_boolean (
564: p_init_msg_list
565: )
566: THEN
567: fnd_msg_pub.initialize;

Line 571: x_return_status := fnd_api.g_ret_sts_success;

567: fnd_msg_pub.initialize;
568: END IF;
569:
570: -- Initialize API return status to SUCCESS
571: x_return_status := fnd_api.g_ret_sts_success;
572:
573: --
574: -- API body
575: --

Line 611: l_return := FND_API.G_FALSE;

607: END IF;
608:
609: IF p_doc_type <> 'QUOTE'
610: THEN
611: l_return := FND_API.G_FALSE;
612: ELSE
613:
614: OPEN c_quote_header ;
615: FETCH c_quote_header INTO l_update_allowed, l_quote_expiration_date,

Line 619: l_return := FND_API.G_FALSE;

615: FETCH c_quote_header INTO l_update_allowed, l_quote_expiration_date,
616: l_max_version_flag, l_price_request_id;
617: IF (c_quote_header%NOTFOUND)
618: THEN
619: l_return := FND_API.G_FALSE;
620: END IF;
621: CLOSE c_quote_header;
622:
623: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 652: l_return := FND_API.G_FALSE;

648: OR l_update_allowed = 'N'
649: OR l_max_version_flag = 'N'
650: OR l_price_request_id IS NOT NULL
651: THEN
652: l_return := FND_API.G_FALSE;
653: END IF;
654:
655: END IF;
656: --