88: wf_engine.setItemAttrText(itemtype, itemkey, 'TO_USER' , rec_c_get_lead_instructor.user_name );
89: END IF;
90:
91: CLOSE c_get_lead_instructor;
92: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
93: raise FND_API.G_EXC_ERROR;
94: END IF;
95: resultout := 'COMPLETE:SUCCESS';
96: RETURN;
89: END IF;
90:
91: CLOSE c_get_lead_instructor;
92: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
93: raise FND_API.G_EXC_ERROR;
94: END IF;
95: resultout := 'COMPLETE:SUCCESS';
96: RETURN;
97:
115: END IF;
116:
117: EXCEPTION
118:
119: WHEN FND_API.G_EXC_ERROR THEN
120: --If execution error, rollback all database changes, generate message text
121: --and return failure status to the WF
122: ROLLBACK TO Select_Approver;
123: resultout := 'COMPLETE:FAILURE';
160: l_TEACH_CI_SEQUENCE_NUMBER
161: );
162:
163: /***************** End : Repeat Process / Translation / Finalization Process *************/
164: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
165: raise FND_API.G_EXC_ERROR;
166: END IF;
167: resultout := 'Y';
168: return;
161: );
162:
163: /***************** End : Repeat Process / Translation / Finalization Process *************/
164: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
165: raise FND_API.G_EXC_ERROR;
166: END IF;
167: resultout := 'Y';
168: return;
169: IF ( funcmode = 'CANCEL' ) THEN
176: return;
177: END IF;
178: END IF;
179: EXCEPTION
180: WHEN FND_API.G_EXC_ERROR THEN
181: --If execution error, rollback all database changes, generate message text
182: --and return failure status to the WF
183: ROLLBACK TO Repeat_Process;
184: