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.PA_ACTION_SET_LINE_COND_PKG dependencies on FND_API

Line 30: x_return_status := FND_API.G_RET_STS_SUCCESS;

26:
27: BEGIN
28:
29: -- Initialize the return status to success
30: x_return_status := FND_API.G_RET_STS_SUCCESS;
31:
32: -- Bug 4403338
33: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
34:

Line 95: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

91: -- Set the excetption Message and the stack
92: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SET_LINE_COND_PKG.Insert_row'
93: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
94: --
95: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
96: RAISE;
97:
98: END Insert_Row;
99:

Line 103: ,p_condition_date IN pa_action_set_line_cond.condition_date%TYPE := FND_API.G_MISS_DATE

99:
100:
101: PROCEDURE update_row
102: (p_action_set_line_condition_id IN pa_action_set_line_cond.action_set_line_condition_id%TYPE
103: ,p_condition_date IN pa_action_set_line_cond.condition_date%TYPE := FND_API.G_MISS_DATE
104: ,p_description IN pa_action_set_line_cond.description%TYPE := FND_API.G_MISS_CHAR
105: ,p_record_version_number IN NUMBER := NULL
106: ,p_condition_code IN pa_action_set_line_cond.condition_code%TYPE := FND_API.G_MISS_CHAR
107: ,p_condition_attribute1 IN pa_action_set_line_cond.condition_attribute1%TYPE := FND_API.G_MISS_CHAR

Line 104: ,p_description IN pa_action_set_line_cond.description%TYPE := FND_API.G_MISS_CHAR

100:
101: PROCEDURE update_row
102: (p_action_set_line_condition_id IN pa_action_set_line_cond.action_set_line_condition_id%TYPE
103: ,p_condition_date IN pa_action_set_line_cond.condition_date%TYPE := FND_API.G_MISS_DATE
104: ,p_description IN pa_action_set_line_cond.description%TYPE := FND_API.G_MISS_CHAR
105: ,p_record_version_number IN NUMBER := NULL
106: ,p_condition_code IN pa_action_set_line_cond.condition_code%TYPE := FND_API.G_MISS_CHAR
107: ,p_condition_attribute1 IN pa_action_set_line_cond.condition_attribute1%TYPE := FND_API.G_MISS_CHAR
108: ,p_condition_attribute2 IN pa_action_set_line_cond.condition_attribute2%TYPE := FND_API.G_MISS_CHAR

Line 106: ,p_condition_code IN pa_action_set_line_cond.condition_code%TYPE := FND_API.G_MISS_CHAR

102: (p_action_set_line_condition_id IN pa_action_set_line_cond.action_set_line_condition_id%TYPE
103: ,p_condition_date IN pa_action_set_line_cond.condition_date%TYPE := FND_API.G_MISS_DATE
104: ,p_description IN pa_action_set_line_cond.description%TYPE := FND_API.G_MISS_CHAR
105: ,p_record_version_number IN NUMBER := NULL
106: ,p_condition_code IN pa_action_set_line_cond.condition_code%TYPE := FND_API.G_MISS_CHAR
107: ,p_condition_attribute1 IN pa_action_set_line_cond.condition_attribute1%TYPE := FND_API.G_MISS_CHAR
108: ,p_condition_attribute2 IN pa_action_set_line_cond.condition_attribute2%TYPE := FND_API.G_MISS_CHAR
109: ,p_condition_attribute3 IN pa_action_set_line_cond.condition_attribute3%TYPE := FND_API.G_MISS_CHAR
110: ,p_condition_attribute4 IN pa_action_set_line_cond.condition_attribute4%TYPE := FND_API.G_MISS_CHAR

Line 107: ,p_condition_attribute1 IN pa_action_set_line_cond.condition_attribute1%TYPE := FND_API.G_MISS_CHAR

103: ,p_condition_date IN pa_action_set_line_cond.condition_date%TYPE := FND_API.G_MISS_DATE
104: ,p_description IN pa_action_set_line_cond.description%TYPE := FND_API.G_MISS_CHAR
105: ,p_record_version_number IN NUMBER := NULL
106: ,p_condition_code IN pa_action_set_line_cond.condition_code%TYPE := FND_API.G_MISS_CHAR
107: ,p_condition_attribute1 IN pa_action_set_line_cond.condition_attribute1%TYPE := FND_API.G_MISS_CHAR
108: ,p_condition_attribute2 IN pa_action_set_line_cond.condition_attribute2%TYPE := FND_API.G_MISS_CHAR
109: ,p_condition_attribute3 IN pa_action_set_line_cond.condition_attribute3%TYPE := FND_API.G_MISS_CHAR
110: ,p_condition_attribute4 IN pa_action_set_line_cond.condition_attribute4%TYPE := FND_API.G_MISS_CHAR
111: ,p_condition_attribute5 IN pa_action_set_line_cond.condition_attribute5%TYPE := FND_API.G_MISS_CHAR

Line 108: ,p_condition_attribute2 IN pa_action_set_line_cond.condition_attribute2%TYPE := FND_API.G_MISS_CHAR

104: ,p_description IN pa_action_set_line_cond.description%TYPE := FND_API.G_MISS_CHAR
105: ,p_record_version_number IN NUMBER := NULL
106: ,p_condition_code IN pa_action_set_line_cond.condition_code%TYPE := FND_API.G_MISS_CHAR
107: ,p_condition_attribute1 IN pa_action_set_line_cond.condition_attribute1%TYPE := FND_API.G_MISS_CHAR
108: ,p_condition_attribute2 IN pa_action_set_line_cond.condition_attribute2%TYPE := FND_API.G_MISS_CHAR
109: ,p_condition_attribute3 IN pa_action_set_line_cond.condition_attribute3%TYPE := FND_API.G_MISS_CHAR
110: ,p_condition_attribute4 IN pa_action_set_line_cond.condition_attribute4%TYPE := FND_API.G_MISS_CHAR
111: ,p_condition_attribute5 IN pa_action_set_line_cond.condition_attribute5%TYPE := FND_API.G_MISS_CHAR
112: ,p_condition_attribute6 IN pa_action_set_line_cond.condition_attribute6%TYPE := FND_API.G_MISS_CHAR

Line 109: ,p_condition_attribute3 IN pa_action_set_line_cond.condition_attribute3%TYPE := FND_API.G_MISS_CHAR

105: ,p_record_version_number IN NUMBER := NULL
106: ,p_condition_code IN pa_action_set_line_cond.condition_code%TYPE := FND_API.G_MISS_CHAR
107: ,p_condition_attribute1 IN pa_action_set_line_cond.condition_attribute1%TYPE := FND_API.G_MISS_CHAR
108: ,p_condition_attribute2 IN pa_action_set_line_cond.condition_attribute2%TYPE := FND_API.G_MISS_CHAR
109: ,p_condition_attribute3 IN pa_action_set_line_cond.condition_attribute3%TYPE := FND_API.G_MISS_CHAR
110: ,p_condition_attribute4 IN pa_action_set_line_cond.condition_attribute4%TYPE := FND_API.G_MISS_CHAR
111: ,p_condition_attribute5 IN pa_action_set_line_cond.condition_attribute5%TYPE := FND_API.G_MISS_CHAR
112: ,p_condition_attribute6 IN pa_action_set_line_cond.condition_attribute6%TYPE := FND_API.G_MISS_CHAR
113: ,p_condition_attribute7 IN pa_action_set_line_cond.condition_attribute7%TYPE := FND_API.G_MISS_CHAR

Line 110: ,p_condition_attribute4 IN pa_action_set_line_cond.condition_attribute4%TYPE := FND_API.G_MISS_CHAR

106: ,p_condition_code IN pa_action_set_line_cond.condition_code%TYPE := FND_API.G_MISS_CHAR
107: ,p_condition_attribute1 IN pa_action_set_line_cond.condition_attribute1%TYPE := FND_API.G_MISS_CHAR
108: ,p_condition_attribute2 IN pa_action_set_line_cond.condition_attribute2%TYPE := FND_API.G_MISS_CHAR
109: ,p_condition_attribute3 IN pa_action_set_line_cond.condition_attribute3%TYPE := FND_API.G_MISS_CHAR
110: ,p_condition_attribute4 IN pa_action_set_line_cond.condition_attribute4%TYPE := FND_API.G_MISS_CHAR
111: ,p_condition_attribute5 IN pa_action_set_line_cond.condition_attribute5%TYPE := FND_API.G_MISS_CHAR
112: ,p_condition_attribute6 IN pa_action_set_line_cond.condition_attribute6%TYPE := FND_API.G_MISS_CHAR
113: ,p_condition_attribute7 IN pa_action_set_line_cond.condition_attribute7%TYPE := FND_API.G_MISS_CHAR
114: ,p_condition_attribute8 IN pa_action_set_line_cond.condition_attribute8%TYPE := FND_API.G_MISS_CHAR

Line 111: ,p_condition_attribute5 IN pa_action_set_line_cond.condition_attribute5%TYPE := FND_API.G_MISS_CHAR

107: ,p_condition_attribute1 IN pa_action_set_line_cond.condition_attribute1%TYPE := FND_API.G_MISS_CHAR
108: ,p_condition_attribute2 IN pa_action_set_line_cond.condition_attribute2%TYPE := FND_API.G_MISS_CHAR
109: ,p_condition_attribute3 IN pa_action_set_line_cond.condition_attribute3%TYPE := FND_API.G_MISS_CHAR
110: ,p_condition_attribute4 IN pa_action_set_line_cond.condition_attribute4%TYPE := FND_API.G_MISS_CHAR
111: ,p_condition_attribute5 IN pa_action_set_line_cond.condition_attribute5%TYPE := FND_API.G_MISS_CHAR
112: ,p_condition_attribute6 IN pa_action_set_line_cond.condition_attribute6%TYPE := FND_API.G_MISS_CHAR
113: ,p_condition_attribute7 IN pa_action_set_line_cond.condition_attribute7%TYPE := FND_API.G_MISS_CHAR
114: ,p_condition_attribute8 IN pa_action_set_line_cond.condition_attribute8%TYPE := FND_API.G_MISS_CHAR
115: ,p_condition_attribute9 IN pa_action_set_line_cond.condition_attribute9%TYPE := FND_API.G_MISS_CHAR

Line 112: ,p_condition_attribute6 IN pa_action_set_line_cond.condition_attribute6%TYPE := FND_API.G_MISS_CHAR

108: ,p_condition_attribute2 IN pa_action_set_line_cond.condition_attribute2%TYPE := FND_API.G_MISS_CHAR
109: ,p_condition_attribute3 IN pa_action_set_line_cond.condition_attribute3%TYPE := FND_API.G_MISS_CHAR
110: ,p_condition_attribute4 IN pa_action_set_line_cond.condition_attribute4%TYPE := FND_API.G_MISS_CHAR
111: ,p_condition_attribute5 IN pa_action_set_line_cond.condition_attribute5%TYPE := FND_API.G_MISS_CHAR
112: ,p_condition_attribute6 IN pa_action_set_line_cond.condition_attribute6%TYPE := FND_API.G_MISS_CHAR
113: ,p_condition_attribute7 IN pa_action_set_line_cond.condition_attribute7%TYPE := FND_API.G_MISS_CHAR
114: ,p_condition_attribute8 IN pa_action_set_line_cond.condition_attribute8%TYPE := FND_API.G_MISS_CHAR
115: ,p_condition_attribute9 IN pa_action_set_line_cond.condition_attribute9%TYPE := FND_API.G_MISS_CHAR
116: ,p_condition_attribute10 IN pa_action_set_line_cond.condition_attribute10%TYPE := FND_API.G_MISS_CHAR

Line 113: ,p_condition_attribute7 IN pa_action_set_line_cond.condition_attribute7%TYPE := FND_API.G_MISS_CHAR

109: ,p_condition_attribute3 IN pa_action_set_line_cond.condition_attribute3%TYPE := FND_API.G_MISS_CHAR
110: ,p_condition_attribute4 IN pa_action_set_line_cond.condition_attribute4%TYPE := FND_API.G_MISS_CHAR
111: ,p_condition_attribute5 IN pa_action_set_line_cond.condition_attribute5%TYPE := FND_API.G_MISS_CHAR
112: ,p_condition_attribute6 IN pa_action_set_line_cond.condition_attribute6%TYPE := FND_API.G_MISS_CHAR
113: ,p_condition_attribute7 IN pa_action_set_line_cond.condition_attribute7%TYPE := FND_API.G_MISS_CHAR
114: ,p_condition_attribute8 IN pa_action_set_line_cond.condition_attribute8%TYPE := FND_API.G_MISS_CHAR
115: ,p_condition_attribute9 IN pa_action_set_line_cond.condition_attribute9%TYPE := FND_API.G_MISS_CHAR
116: ,p_condition_attribute10 IN pa_action_set_line_cond.condition_attribute10%TYPE := FND_API.G_MISS_CHAR
117: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 114: ,p_condition_attribute8 IN pa_action_set_line_cond.condition_attribute8%TYPE := FND_API.G_MISS_CHAR

110: ,p_condition_attribute4 IN pa_action_set_line_cond.condition_attribute4%TYPE := FND_API.G_MISS_CHAR
111: ,p_condition_attribute5 IN pa_action_set_line_cond.condition_attribute5%TYPE := FND_API.G_MISS_CHAR
112: ,p_condition_attribute6 IN pa_action_set_line_cond.condition_attribute6%TYPE := FND_API.G_MISS_CHAR
113: ,p_condition_attribute7 IN pa_action_set_line_cond.condition_attribute7%TYPE := FND_API.G_MISS_CHAR
114: ,p_condition_attribute8 IN pa_action_set_line_cond.condition_attribute8%TYPE := FND_API.G_MISS_CHAR
115: ,p_condition_attribute9 IN pa_action_set_line_cond.condition_attribute9%TYPE := FND_API.G_MISS_CHAR
116: ,p_condition_attribute10 IN pa_action_set_line_cond.condition_attribute10%TYPE := FND_API.G_MISS_CHAR
117: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
118: )

Line 115: ,p_condition_attribute9 IN pa_action_set_line_cond.condition_attribute9%TYPE := FND_API.G_MISS_CHAR

111: ,p_condition_attribute5 IN pa_action_set_line_cond.condition_attribute5%TYPE := FND_API.G_MISS_CHAR
112: ,p_condition_attribute6 IN pa_action_set_line_cond.condition_attribute6%TYPE := FND_API.G_MISS_CHAR
113: ,p_condition_attribute7 IN pa_action_set_line_cond.condition_attribute7%TYPE := FND_API.G_MISS_CHAR
114: ,p_condition_attribute8 IN pa_action_set_line_cond.condition_attribute8%TYPE := FND_API.G_MISS_CHAR
115: ,p_condition_attribute9 IN pa_action_set_line_cond.condition_attribute9%TYPE := FND_API.G_MISS_CHAR
116: ,p_condition_attribute10 IN pa_action_set_line_cond.condition_attribute10%TYPE := FND_API.G_MISS_CHAR
117: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
118: )
119: IS

Line 116: ,p_condition_attribute10 IN pa_action_set_line_cond.condition_attribute10%TYPE := FND_API.G_MISS_CHAR

112: ,p_condition_attribute6 IN pa_action_set_line_cond.condition_attribute6%TYPE := FND_API.G_MISS_CHAR
113: ,p_condition_attribute7 IN pa_action_set_line_cond.condition_attribute7%TYPE := FND_API.G_MISS_CHAR
114: ,p_condition_attribute8 IN pa_action_set_line_cond.condition_attribute8%TYPE := FND_API.G_MISS_CHAR
115: ,p_condition_attribute9 IN pa_action_set_line_cond.condition_attribute9%TYPE := FND_API.G_MISS_CHAR
116: ,p_condition_attribute10 IN pa_action_set_line_cond.condition_attribute10%TYPE := FND_API.G_MISS_CHAR
117: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
118: )
119: IS
120: e_row_is_locked EXCEPTION;

Line 129: x_return_status := FND_API.G_RET_STS_SUCCESS;

125:
126: BEGIN
127:
128: -- Initialize the return status to success
129: x_return_status := FND_API.G_RET_STS_SUCCESS;
130:
131: -- Bug 4403338
132: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
133:

Line 147: SET condition_date = decode(p_condition_date, FND_API.G_MISS_DATE, condition_date, p_condition_date)

143: WHERE action_set_line_condition_id = p_action_set_line_condition_id
144: FOR UPDATE NOWAIT;
145:
146: UPDATE pa_action_set_line_cond
147: SET condition_date = decode(p_condition_date, FND_API.G_MISS_DATE, condition_date, p_condition_date)
148: ,description = decode(p_description, FND_API.G_MISS_CHAR, description, p_description)
149: ,condition_code = decode(p_condition_code, FND_API.G_MISS_CHAR, condition_code, p_condition_code)
150: ,condition_attribute1 = decode(p_condition_attribute1, FND_API.G_MISS_CHAR, condition_attribute1, p_condition_attribute1)
151: ,condition_attribute2 = decode(p_condition_attribute2, FND_API.G_MISS_CHAR, condition_attribute2, p_condition_attribute2)

Line 148: ,description = decode(p_description, FND_API.G_MISS_CHAR, description, p_description)

144: FOR UPDATE NOWAIT;
145:
146: UPDATE pa_action_set_line_cond
147: SET condition_date = decode(p_condition_date, FND_API.G_MISS_DATE, condition_date, p_condition_date)
148: ,description = decode(p_description, FND_API.G_MISS_CHAR, description, p_description)
149: ,condition_code = decode(p_condition_code, FND_API.G_MISS_CHAR, condition_code, p_condition_code)
150: ,condition_attribute1 = decode(p_condition_attribute1, FND_API.G_MISS_CHAR, condition_attribute1, p_condition_attribute1)
151: ,condition_attribute2 = decode(p_condition_attribute2, FND_API.G_MISS_CHAR, condition_attribute2, p_condition_attribute2)
152: ,condition_attribute3 = decode(p_condition_attribute3, FND_API.G_MISS_CHAR, condition_attribute3, p_condition_attribute3)

Line 149: ,condition_code = decode(p_condition_code, FND_API.G_MISS_CHAR, condition_code, p_condition_code)

145:
146: UPDATE pa_action_set_line_cond
147: SET condition_date = decode(p_condition_date, FND_API.G_MISS_DATE, condition_date, p_condition_date)
148: ,description = decode(p_description, FND_API.G_MISS_CHAR, description, p_description)
149: ,condition_code = decode(p_condition_code, FND_API.G_MISS_CHAR, condition_code, p_condition_code)
150: ,condition_attribute1 = decode(p_condition_attribute1, FND_API.G_MISS_CHAR, condition_attribute1, p_condition_attribute1)
151: ,condition_attribute2 = decode(p_condition_attribute2, FND_API.G_MISS_CHAR, condition_attribute2, p_condition_attribute2)
152: ,condition_attribute3 = decode(p_condition_attribute3, FND_API.G_MISS_CHAR, condition_attribute3, p_condition_attribute3)
153: ,condition_attribute4 = decode(p_condition_attribute4, FND_API.G_MISS_CHAR, condition_attribute4, p_condition_attribute4)

Line 150: ,condition_attribute1 = decode(p_condition_attribute1, FND_API.G_MISS_CHAR, condition_attribute1, p_condition_attribute1)

146: UPDATE pa_action_set_line_cond
147: SET condition_date = decode(p_condition_date, FND_API.G_MISS_DATE, condition_date, p_condition_date)
148: ,description = decode(p_description, FND_API.G_MISS_CHAR, description, p_description)
149: ,condition_code = decode(p_condition_code, FND_API.G_MISS_CHAR, condition_code, p_condition_code)
150: ,condition_attribute1 = decode(p_condition_attribute1, FND_API.G_MISS_CHAR, condition_attribute1, p_condition_attribute1)
151: ,condition_attribute2 = decode(p_condition_attribute2, FND_API.G_MISS_CHAR, condition_attribute2, p_condition_attribute2)
152: ,condition_attribute3 = decode(p_condition_attribute3, FND_API.G_MISS_CHAR, condition_attribute3, p_condition_attribute3)
153: ,condition_attribute4 = decode(p_condition_attribute4, FND_API.G_MISS_CHAR, condition_attribute4, p_condition_attribute4)
154: ,condition_attribute5 = decode(p_condition_attribute5, FND_API.G_MISS_CHAR, condition_attribute5, p_condition_attribute5)

Line 151: ,condition_attribute2 = decode(p_condition_attribute2, FND_API.G_MISS_CHAR, condition_attribute2, p_condition_attribute2)

147: SET condition_date = decode(p_condition_date, FND_API.G_MISS_DATE, condition_date, p_condition_date)
148: ,description = decode(p_description, FND_API.G_MISS_CHAR, description, p_description)
149: ,condition_code = decode(p_condition_code, FND_API.G_MISS_CHAR, condition_code, p_condition_code)
150: ,condition_attribute1 = decode(p_condition_attribute1, FND_API.G_MISS_CHAR, condition_attribute1, p_condition_attribute1)
151: ,condition_attribute2 = decode(p_condition_attribute2, FND_API.G_MISS_CHAR, condition_attribute2, p_condition_attribute2)
152: ,condition_attribute3 = decode(p_condition_attribute3, FND_API.G_MISS_CHAR, condition_attribute3, p_condition_attribute3)
153: ,condition_attribute4 = decode(p_condition_attribute4, FND_API.G_MISS_CHAR, condition_attribute4, p_condition_attribute4)
154: ,condition_attribute5 = decode(p_condition_attribute5, FND_API.G_MISS_CHAR, condition_attribute5, p_condition_attribute5)
155: ,condition_attribute6 = decode(p_condition_attribute6, FND_API.G_MISS_CHAR, condition_attribute6, p_condition_attribute6)

Line 152: ,condition_attribute3 = decode(p_condition_attribute3, FND_API.G_MISS_CHAR, condition_attribute3, p_condition_attribute3)

148: ,description = decode(p_description, FND_API.G_MISS_CHAR, description, p_description)
149: ,condition_code = decode(p_condition_code, FND_API.G_MISS_CHAR, condition_code, p_condition_code)
150: ,condition_attribute1 = decode(p_condition_attribute1, FND_API.G_MISS_CHAR, condition_attribute1, p_condition_attribute1)
151: ,condition_attribute2 = decode(p_condition_attribute2, FND_API.G_MISS_CHAR, condition_attribute2, p_condition_attribute2)
152: ,condition_attribute3 = decode(p_condition_attribute3, FND_API.G_MISS_CHAR, condition_attribute3, p_condition_attribute3)
153: ,condition_attribute4 = decode(p_condition_attribute4, FND_API.G_MISS_CHAR, condition_attribute4, p_condition_attribute4)
154: ,condition_attribute5 = decode(p_condition_attribute5, FND_API.G_MISS_CHAR, condition_attribute5, p_condition_attribute5)
155: ,condition_attribute6 = decode(p_condition_attribute6, FND_API.G_MISS_CHAR, condition_attribute6, p_condition_attribute6)
156: ,condition_attribute7 = decode(p_condition_attribute7, FND_API.G_MISS_CHAR, condition_attribute7, p_condition_attribute7)

Line 153: ,condition_attribute4 = decode(p_condition_attribute4, FND_API.G_MISS_CHAR, condition_attribute4, p_condition_attribute4)

149: ,condition_code = decode(p_condition_code, FND_API.G_MISS_CHAR, condition_code, p_condition_code)
150: ,condition_attribute1 = decode(p_condition_attribute1, FND_API.G_MISS_CHAR, condition_attribute1, p_condition_attribute1)
151: ,condition_attribute2 = decode(p_condition_attribute2, FND_API.G_MISS_CHAR, condition_attribute2, p_condition_attribute2)
152: ,condition_attribute3 = decode(p_condition_attribute3, FND_API.G_MISS_CHAR, condition_attribute3, p_condition_attribute3)
153: ,condition_attribute4 = decode(p_condition_attribute4, FND_API.G_MISS_CHAR, condition_attribute4, p_condition_attribute4)
154: ,condition_attribute5 = decode(p_condition_attribute5, FND_API.G_MISS_CHAR, condition_attribute5, p_condition_attribute5)
155: ,condition_attribute6 = decode(p_condition_attribute6, FND_API.G_MISS_CHAR, condition_attribute6, p_condition_attribute6)
156: ,condition_attribute7 = decode(p_condition_attribute7, FND_API.G_MISS_CHAR, condition_attribute7, p_condition_attribute7)
157: ,condition_attribute8 = decode(p_condition_attribute8, FND_API.G_MISS_CHAR, condition_attribute8, p_condition_attribute8)

Line 154: ,condition_attribute5 = decode(p_condition_attribute5, FND_API.G_MISS_CHAR, condition_attribute5, p_condition_attribute5)

150: ,condition_attribute1 = decode(p_condition_attribute1, FND_API.G_MISS_CHAR, condition_attribute1, p_condition_attribute1)
151: ,condition_attribute2 = decode(p_condition_attribute2, FND_API.G_MISS_CHAR, condition_attribute2, p_condition_attribute2)
152: ,condition_attribute3 = decode(p_condition_attribute3, FND_API.G_MISS_CHAR, condition_attribute3, p_condition_attribute3)
153: ,condition_attribute4 = decode(p_condition_attribute4, FND_API.G_MISS_CHAR, condition_attribute4, p_condition_attribute4)
154: ,condition_attribute5 = decode(p_condition_attribute5, FND_API.G_MISS_CHAR, condition_attribute5, p_condition_attribute5)
155: ,condition_attribute6 = decode(p_condition_attribute6, FND_API.G_MISS_CHAR, condition_attribute6, p_condition_attribute6)
156: ,condition_attribute7 = decode(p_condition_attribute7, FND_API.G_MISS_CHAR, condition_attribute7, p_condition_attribute7)
157: ,condition_attribute8 = decode(p_condition_attribute8, FND_API.G_MISS_CHAR, condition_attribute8, p_condition_attribute8)
158: ,condition_attribute9 = decode(p_condition_attribute9, FND_API.G_MISS_CHAR, condition_attribute9, p_condition_attribute9)

Line 155: ,condition_attribute6 = decode(p_condition_attribute6, FND_API.G_MISS_CHAR, condition_attribute6, p_condition_attribute6)

151: ,condition_attribute2 = decode(p_condition_attribute2, FND_API.G_MISS_CHAR, condition_attribute2, p_condition_attribute2)
152: ,condition_attribute3 = decode(p_condition_attribute3, FND_API.G_MISS_CHAR, condition_attribute3, p_condition_attribute3)
153: ,condition_attribute4 = decode(p_condition_attribute4, FND_API.G_MISS_CHAR, condition_attribute4, p_condition_attribute4)
154: ,condition_attribute5 = decode(p_condition_attribute5, FND_API.G_MISS_CHAR, condition_attribute5, p_condition_attribute5)
155: ,condition_attribute6 = decode(p_condition_attribute6, FND_API.G_MISS_CHAR, condition_attribute6, p_condition_attribute6)
156: ,condition_attribute7 = decode(p_condition_attribute7, FND_API.G_MISS_CHAR, condition_attribute7, p_condition_attribute7)
157: ,condition_attribute8 = decode(p_condition_attribute8, FND_API.G_MISS_CHAR, condition_attribute8, p_condition_attribute8)
158: ,condition_attribute9 = decode(p_condition_attribute9, FND_API.G_MISS_CHAR, condition_attribute9, p_condition_attribute9)
159: ,condition_attribute10 = decode(p_condition_attribute10, FND_API.G_MISS_CHAR, condition_attribute10, p_condition_attribute10)

Line 156: ,condition_attribute7 = decode(p_condition_attribute7, FND_API.G_MISS_CHAR, condition_attribute7, p_condition_attribute7)

152: ,condition_attribute3 = decode(p_condition_attribute3, FND_API.G_MISS_CHAR, condition_attribute3, p_condition_attribute3)
153: ,condition_attribute4 = decode(p_condition_attribute4, FND_API.G_MISS_CHAR, condition_attribute4, p_condition_attribute4)
154: ,condition_attribute5 = decode(p_condition_attribute5, FND_API.G_MISS_CHAR, condition_attribute5, p_condition_attribute5)
155: ,condition_attribute6 = decode(p_condition_attribute6, FND_API.G_MISS_CHAR, condition_attribute6, p_condition_attribute6)
156: ,condition_attribute7 = decode(p_condition_attribute7, FND_API.G_MISS_CHAR, condition_attribute7, p_condition_attribute7)
157: ,condition_attribute8 = decode(p_condition_attribute8, FND_API.G_MISS_CHAR, condition_attribute8, p_condition_attribute8)
158: ,condition_attribute9 = decode(p_condition_attribute9, FND_API.G_MISS_CHAR, condition_attribute9, p_condition_attribute9)
159: ,condition_attribute10 = decode(p_condition_attribute10, FND_API.G_MISS_CHAR, condition_attribute10, p_condition_attribute10)
160: ,last_update_date = sysdate

Line 157: ,condition_attribute8 = decode(p_condition_attribute8, FND_API.G_MISS_CHAR, condition_attribute8, p_condition_attribute8)

153: ,condition_attribute4 = decode(p_condition_attribute4, FND_API.G_MISS_CHAR, condition_attribute4, p_condition_attribute4)
154: ,condition_attribute5 = decode(p_condition_attribute5, FND_API.G_MISS_CHAR, condition_attribute5, p_condition_attribute5)
155: ,condition_attribute6 = decode(p_condition_attribute6, FND_API.G_MISS_CHAR, condition_attribute6, p_condition_attribute6)
156: ,condition_attribute7 = decode(p_condition_attribute7, FND_API.G_MISS_CHAR, condition_attribute7, p_condition_attribute7)
157: ,condition_attribute8 = decode(p_condition_attribute8, FND_API.G_MISS_CHAR, condition_attribute8, p_condition_attribute8)
158: ,condition_attribute9 = decode(p_condition_attribute9, FND_API.G_MISS_CHAR, condition_attribute9, p_condition_attribute9)
159: ,condition_attribute10 = decode(p_condition_attribute10, FND_API.G_MISS_CHAR, condition_attribute10, p_condition_attribute10)
160: ,last_update_date = sysdate
161: ,last_updated_by = fnd_global.user_id

Line 158: ,condition_attribute9 = decode(p_condition_attribute9, FND_API.G_MISS_CHAR, condition_attribute9, p_condition_attribute9)

154: ,condition_attribute5 = decode(p_condition_attribute5, FND_API.G_MISS_CHAR, condition_attribute5, p_condition_attribute5)
155: ,condition_attribute6 = decode(p_condition_attribute6, FND_API.G_MISS_CHAR, condition_attribute6, p_condition_attribute6)
156: ,condition_attribute7 = decode(p_condition_attribute7, FND_API.G_MISS_CHAR, condition_attribute7, p_condition_attribute7)
157: ,condition_attribute8 = decode(p_condition_attribute8, FND_API.G_MISS_CHAR, condition_attribute8, p_condition_attribute8)
158: ,condition_attribute9 = decode(p_condition_attribute9, FND_API.G_MISS_CHAR, condition_attribute9, p_condition_attribute9)
159: ,condition_attribute10 = decode(p_condition_attribute10, FND_API.G_MISS_CHAR, condition_attribute10, p_condition_attribute10)
160: ,last_update_date = sysdate
161: ,last_updated_by = fnd_global.user_id
162: ,last_update_login = fnd_global.login_id

Line 159: ,condition_attribute10 = decode(p_condition_attribute10, FND_API.G_MISS_CHAR, condition_attribute10, p_condition_attribute10)

155: ,condition_attribute6 = decode(p_condition_attribute6, FND_API.G_MISS_CHAR, condition_attribute6, p_condition_attribute6)
156: ,condition_attribute7 = decode(p_condition_attribute7, FND_API.G_MISS_CHAR, condition_attribute7, p_condition_attribute7)
157: ,condition_attribute8 = decode(p_condition_attribute8, FND_API.G_MISS_CHAR, condition_attribute8, p_condition_attribute8)
158: ,condition_attribute9 = decode(p_condition_attribute9, FND_API.G_MISS_CHAR, condition_attribute9, p_condition_attribute9)
159: ,condition_attribute10 = decode(p_condition_attribute10, FND_API.G_MISS_CHAR, condition_attribute10, p_condition_attribute10)
160: ,last_update_date = sysdate
161: ,last_updated_by = fnd_global.user_id
162: ,last_update_login = fnd_global.login_id
163: WHERE rowid = l_rowid;

Line 169: x_return_status := FND_API.G_RET_STS_ERROR;

165: IF (SQL%NOTFOUND) THEN
166:
167: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
168: ,p_msg_name => 'PA_XC_RECORD_CHANGED');
169: x_return_status := FND_API.G_RET_STS_ERROR;
170:
171: END IF;
172:
173: -- Put any message text from message stack into the Message ARRAY

Line 178: x_return_status := FND_API.G_RET_STS_ERROR;

174: EXCEPTION
175: WHEN e_row_is_locked THEN
176: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
177: ,p_msg_name => 'PA_ACTION_LINE_CHANGE_PENDING');
178: x_return_status := FND_API.G_RET_STS_ERROR;
179:
180: WHEN OTHERS THEN
181: -- Set the excetption Message and the stack
182: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SET_LINE_COND_PKG.update_row'

Line 185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

181: -- Set the excetption Message and the stack
182: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SET_LINE_COND_PKG.update_row'
183: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
184: --
185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
186: RAISE;
187:
188: END update_row;
189:

Line 199: x_return_status := FND_API.G_RET_STS_SUCCESS;

195: IS
196:
197: BEGIN
198:
199: x_return_status := FND_API.G_RET_STS_SUCCESS;
200:
201: DELETE FROM pa_action_set_line_cond
202: WHERE action_set_line_condition_id = p_action_set_line_condition_id;
203:

Line 209: x_return_status := FND_API.G_RET_STS_ERROR;

205: IF (SQL%NOTFOUND) THEN
206:
207: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
208: ,p_msg_name => 'PA_XC_RECORD_CHANGED');
209: x_return_status := FND_API.G_RET_STS_ERROR;
210:
211: END IF;
212: --
213: --

Line 220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

216: WHEN OTHERS THEN
217: -- Set the exception Message and the stack
218: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ACTION_SET_LINE_COND_PKG.Delete_Row'
219: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
221: RAISE;
222: END Delete_Row;
223:
224: