52: */
53:
54: IF p_proposal_number IS NULL THEN
55:
56: Fnd_Message.Set_Name('IGW','IGW_UPLD_MISSING_PARAMETER');
57: Fnd_Message.Set_Token('PARAM_NAME','P_PROPOSAL_NUMBER');
58: Fnd_Msg_Pub.Add;
59:
60: ELSE
53:
54: IF p_proposal_number IS NULL THEN
55:
56: Fnd_Message.Set_Name('IGW','IGW_UPLD_MISSING_PARAMETER');
57: Fnd_Message.Set_Token('PARAM_NAME','P_PROPOSAL_NUMBER');
58: Fnd_Msg_Pub.Add;
59:
60: ELSE
61:
72: END IF;
73:
74: IF p_special_review_desc IS NULL THEN
75:
76: Fnd_Message.Set_Name('IGW','IGW_UPLD_MISSING_PARAMETER');
77: Fnd_Message.Set_Token('PARAM_NAME','P_SPECIAL_REVIEW_DESC');
78: Fnd_Msg_Pub.Add;
79:
80: ELSE
73:
74: IF p_special_review_desc IS NULL THEN
75:
76: Fnd_Message.Set_Name('IGW','IGW_UPLD_MISSING_PARAMETER');
77: Fnd_Message.Set_Token('PARAM_NAME','P_SPECIAL_REVIEW_DESC');
78: Fnd_Msg_Pub.Add;
79:
80: ELSE
81:
104: );
105:
106: IF p_approval_type_desc IS NULL THEN
107:
108: Fnd_Message.Set_Name('IGW','IGW_UPLD_MISSING_PARAMETER');
109: Fnd_Message.Set_Token('PARAM_NAME','P_APPROVAL_TYPE_DESC');
110: Fnd_Msg_Pub.Add;
111:
112: ELSE
105:
106: IF p_approval_type_desc IS NULL THEN
107:
108: Fnd_Message.Set_Name('IGW','IGW_UPLD_MISSING_PARAMETER');
109: Fnd_Message.Set_Token('PARAM_NAME','P_APPROVAL_TYPE_DESC');
110: Fnd_Msg_Pub.Add;
111:
112: ELSE
113: