APPS.ASO_QUOTE_TMPL_INT dependencies on FND_API

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

12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'asoiqtmb.pls';
13:
14: PROCEDURE Add_Template_To_Quote(
15: P_API_VERSION_NUMBER IN NUMBER,
16: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
17: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
18: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
19: P_TEMPLATE_ID_TBL IN LIST_TEMPLATE_TBL_TYPE,
20: P_QUOTE_HEADER_ID IN NUMBER,

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

13:
14: PROCEDURE Add_Template_To_Quote(
15: P_API_VERSION_NUMBER IN NUMBER,
16: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
17: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
18: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
19: P_TEMPLATE_ID_TBL IN LIST_TEMPLATE_TBL_TYPE,
20: P_QUOTE_HEADER_ID IN NUMBER,
21: P_CONTROL_REC IN ASO_QUOTE_PUB.CONTROL_REC_TYPE := ASO_QUOTE_PUB.G_MISS_control_REC,

Line 18: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

14: PROCEDURE Add_Template_To_Quote(
15: P_API_VERSION_NUMBER IN NUMBER,
16: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
17: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
18: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
19: P_TEMPLATE_ID_TBL IN LIST_TEMPLATE_TBL_TYPE,
20: P_QUOTE_HEADER_ID IN NUMBER,
21: P_CONTROL_REC IN ASO_QUOTE_PUB.CONTROL_REC_TYPE := ASO_QUOTE_PUB.G_MISS_control_REC,
22: P_LAST_UPDATE_DATE IN DATE,

Line 37: P_INIT_MSG_LIST => FND_API.G_FALSE,

33: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row(p_quote_header_id);
34:
35: Add_Template_To_Quote(
36: P_API_VERSION_NUMBER => 1.0,
37: P_INIT_MSG_LIST => FND_API.G_FALSE,
38: P_COMMIT => FND_API.G_FALSE,
39: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
40: P_TEMPLATE_ID_TBL => p_template_id_tbl,
41: P_qte_header_rec => l_QTE_HEADER_REC,

Line 38: P_COMMIT => FND_API.G_FALSE,

34:
35: Add_Template_To_Quote(
36: P_API_VERSION_NUMBER => 1.0,
37: P_INIT_MSG_LIST => FND_API.G_FALSE,
38: P_COMMIT => FND_API.G_FALSE,
39: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
40: P_TEMPLATE_ID_TBL => p_template_id_tbl,
41: P_qte_header_rec => l_QTE_HEADER_REC,
42: P_CONTROL_REC => p_control_rec,

Line 39: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,

35: Add_Template_To_Quote(
36: P_API_VERSION_NUMBER => 1.0,
37: P_INIT_MSG_LIST => FND_API.G_FALSE,
38: P_COMMIT => FND_API.G_FALSE,
39: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
40: P_TEMPLATE_ID_TBL => p_template_id_tbl,
41: P_qte_header_rec => l_QTE_HEADER_REC,
42: P_CONTROL_REC => p_control_rec,
43: X_RETURN_STATUS => x_return_status,

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

49:
50:
51: PROCEDURE Add_Template_To_Quote(
52: P_API_VERSION_NUMBER IN NUMBER,
53: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
54: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
55: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
56: P_TEMPLATE_ID_TBL IN LIST_TEMPLATE_TBL_TYPE,
57: P_QTE_HEADER_REC IN ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,

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

50:
51: PROCEDURE Add_Template_To_Quote(
52: P_API_VERSION_NUMBER IN NUMBER,
53: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
54: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
55: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
56: P_TEMPLATE_ID_TBL IN LIST_TEMPLATE_TBL_TYPE,
57: P_QTE_HEADER_REC IN ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
58: P_CONTROL_REC IN ASO_QUOTE_PUB.CONTROL_REC_TYPE := ASO_QUOTE_PUB.G_MISS_control_REC,

Line 55: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

51: PROCEDURE Add_Template_To_Quote(
52: P_API_VERSION_NUMBER IN NUMBER,
53: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
54: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
55: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
56: P_TEMPLATE_ID_TBL IN LIST_TEMPLATE_TBL_TYPE,
57: P_QTE_HEADER_REC IN ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
58: P_CONTROL_REC IN ASO_QUOTE_PUB.CONTROL_REC_TYPE := ASO_QUOTE_PUB.G_MISS_control_REC,
59: X_RETURN_STATUS OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 85: IF NOT FND_API.Compatible_API_Call(

81: aso_debug_pub.add('****** Start of Add_Template_To_Quote API ******', 1, 'Y');
82: END IF;
83:
84: -- Standard call to check for call compatibility.
85: IF NOT FND_API.Compatible_API_Call(
86: L_API_VERSION ,
87: P_API_VERSION_NUMBER,
88: L_API_NAME ,
89: G_PKG_NAME

Line 91: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

87: P_API_VERSION_NUMBER,
88: L_API_NAME ,
89: G_PKG_NAME
90: ) THEN
91: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
92: END IF;
93:
94: -- Initialize message list if p_init_msg_list is set to TRUE.
95: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 95: IF FND_API.To_Boolean(p_init_msg_list) THEN

91: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
92: END IF;
93:
94: -- Initialize message list if p_init_msg_list is set to TRUE.
95: IF FND_API.To_Boolean(p_init_msg_list) THEN
96: FND_Msg_Pub.initialize;
97: END IF;
98:
99: -- Initialize API return status to success

Line 100: x_return_status := FND_API.G_RET_STS_SUCCESS;

96: FND_Msg_Pub.initialize;
97: END IF;
98:
99: -- Initialize API return status to success
100: x_return_status := FND_API.G_RET_STS_SUCCESS;
101:
102: ASO_QUOTE_TMPL_PVT.Add_Template_To_Quote(
103: P_API_VERSION_NUMBER => 1.0,
104: P_INIT_MSG_LIST => FND_API.G_FALSE,

Line 104: P_INIT_MSG_LIST => FND_API.G_FALSE,

100: x_return_status := FND_API.G_RET_STS_SUCCESS;
101:
102: ASO_QUOTE_TMPL_PVT.Add_Template_To_Quote(
103: P_API_VERSION_NUMBER => 1.0,
104: P_INIT_MSG_LIST => FND_API.G_FALSE,
105: P_COMMIT => FND_API.G_FALSE,
106: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
107: P_UPDATE_FLAG => 'Y',
108: P_TEMPLATE_ID_TBL => P_TEMPLATE_ID_TBL,

Line 105: P_COMMIT => FND_API.G_FALSE,

101:
102: ASO_QUOTE_TMPL_PVT.Add_Template_To_Quote(
103: P_API_VERSION_NUMBER => 1.0,
104: P_INIT_MSG_LIST => FND_API.G_FALSE,
105: P_COMMIT => FND_API.G_FALSE,
106: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
107: P_UPDATE_FLAG => 'Y',
108: P_TEMPLATE_ID_TBL => P_TEMPLATE_ID_TBL,
109: P_QTE_HEADER_REC => P_QTE_HEADER_REC,

Line 106: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,

102: ASO_QUOTE_TMPL_PVT.Add_Template_To_Quote(
103: P_API_VERSION_NUMBER => 1.0,
104: P_INIT_MSG_LIST => FND_API.G_FALSE,
105: P_COMMIT => FND_API.G_FALSE,
106: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
107: P_UPDATE_FLAG => 'Y',
108: P_TEMPLATE_ID_TBL => P_TEMPLATE_ID_TBL,
109: P_QTE_HEADER_REC => P_QTE_HEADER_REC,
110: P_CONTROL_REC => P_CONTROL_REC,

Line 124: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

120: IF aso_debug_pub.g_debug_flag = 'Y' THEN
121: aso_debug_pub.add('****** End of Add_Template_To_Quote API ******', 1, 'Y');
122: END IF;
123:
124: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
125: RAISE FND_API.G_EXC_ERROR;
126: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
128: END IF;

Line 125: RAISE FND_API.G_EXC_ERROR;

121: aso_debug_pub.add('****** End of Add_Template_To_Quote API ******', 1, 'Y');
122: END IF;
123:
124: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
125: RAISE FND_API.G_EXC_ERROR;
126: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
128: END IF;
129:

Line 126: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

122: END IF;
123:
124: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
125: RAISE FND_API.G_EXC_ERROR;
126: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
128: END IF;
129:
130: EXCEPTION

Line 127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

123:
124: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
125: RAISE FND_API.G_EXC_ERROR;
126: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
128: END IF;
129:
130: EXCEPTION
131: WHEN FND_API.G_EXC_ERROR THEN

Line 131: WHEN FND_API.G_EXC_ERROR THEN

127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
128: END IF;
129:
130: EXCEPTION
131: WHEN FND_API.G_EXC_ERROR THEN
132: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
133: P_API_NAME => L_API_NAME,
134: P_PKG_NAME => G_PKG_NAME,
135: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 144: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

140: X_MSG_DATA => X_MSG_DATA,
141: X_RETURN_STATUS => X_RETURN_STATUS
142: );
143:
144: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
145: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
146: P_API_NAME => L_API_NAME,
147: P_PKG_NAME => G_PKG_NAME,
148: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,