38: */
39:
40: x_return_status := Fnd_Api.G_Ret_Sts_Success;
41:
42: Fnd_Msg_Pub.Initialize;
43:
44: /*
45: ** Verify Mandatory Inputs. Value-Id Conversions.
46: */
48: IF p_proposal_number IS NULL THEN
49:
50: Fnd_Message.Set_Name('IGW','IGW_UPLD_MISSING_PARAMETER');
51: Fnd_Message.Set_Token('PARAM_NAME','P_PROPOSAL_NUMBER');
52: Fnd_Msg_Pub.Add;
53:
54: ELSE
55:
56: Igw_Utils.Get_Proposal_Id
68: IF p_abstract_type_desc IS NULL THEN
69:
70: Fnd_Message.Set_Name('IGW','IGW_UPLD_MISSING_PARAMETER');
71: Fnd_Message.Set_Token('PARAM_NAME','P_ABSTRACT_TYPE_DESC');
72: Fnd_Msg_Pub.Add;
73:
74: ELSE
75:
76: Igw_Utils.Get_Lookup_Code
89: IF p_abstract IS NULL THEN
90:
91: Fnd_Message.Set_Name('IGW','IGW_UPLD_MISSING_PARAMETER');
92: Fnd_Message.Set_Token('PARAM_NAME','P_ABSTRACT');
93: Fnd_Msg_Pub.Add;
94:
95: END IF;
96:
97: /*
98: ** Discontinue processing if any error has been encountered during
99: ** the earlier stages
100: */
101:
102: IF Fnd_Msg_Pub.Count_Msg > 0 THEN
103:
104: RAISE Fnd_Api.G_Exc_Error;
105:
106: END IF;
155: x_msg_count => x_msg_count,
156: x_msg_data => x_msg_data
157: );
158:
159: IF Fnd_Msg_Pub.Count_Msg > 0 THEN
160:
161: RAISE Fnd_Api.G_Exc_Error;
162:
163: END IF;
179: ROLLBACK TO Create_Prop_Abstract_Pub;
180:
181: x_return_status := Fnd_Api.G_Ret_Sts_Error;
182:
183: Fnd_Msg_Pub.Count_And_Get
184: (
185: p_encoded => Fnd_Api.G_False,
186: p_count => x_msg_count,
187: p_data => x_msg_data
192: ROLLBACK TO Create_Prop_Abstract_Pub;
193:
194: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
195:
196: Fnd_Msg_Pub.Add_Exc_Msg
197: (
198: p_pkg_name => G_PKG_NAME,
199: p_procedure_name => l_api_name
200: );
198: p_pkg_name => G_PKG_NAME,
199: p_procedure_name => l_api_name
200: );
201:
202: Fnd_Msg_Pub.Count_And_Get
203: (
204: p_encoded => Fnd_Api.G_False,
205: p_count => x_msg_count,
206: p_data => x_msg_data