64: stmt_num := 20;
65: /* initializing err_num */
66: err_num := 0;
67:
68: UPDATE WIP_PERIOD_BALANCES WPB
69: SET
70: (LAST_UPDATE_DATE,
71: LAST_UPDATED_BY,
72: LAST_UPDATE_LOGIN,
137: ACCT_PERIOD_ID = I_PERIOD_ID;
138:
139:
140: -- If no rows were updated then, this ,means there are no rows in
141: -- wip_period_balances and this condition needs to be an error.
142:
143: IF SQL%ROWCOUNT = 0 THEN
144:
145: RAISE NO_ROW_WPB;
158: translated_mesg := fnd_message.get ;
159: ERR_MSG := substr(translated_mesg,1,240) ;
160:
161: -- Appropriate error code needs to be flagged here to indicate no rows
162: -- in wip_period_balances.
163:
164: WHEN OTHERS THEN
165:
166: ERR_NUM := -999;
205:
206: stmt_num := 20;
207: /* initialize variable err num */ err_num := 0;
208:
209: UPDATE WIP_PERIOD_BALANCES WPB
210: SET
211: (LAST_UPDATE_DATE,
212: LAST_UPDATED_BY,
213: LAST_UPDATE_LOGIN,
280: ACCT_PERIOD_ID = I_PERIOD_ID;
281:
282:
283: -- If no rows were updated then, this ,means there are no rows in
284: -- wip_period_balances and this condition needs to be an error.
285:
286: IF SQL%ROWCOUNT = 0 THEN
287:
288: RAISE NO_ROW_WPB;
297:
298: ERR_NUM := -999;
299:
300: -- Appropriate error code needs to be flagged here to indicate no rows
301: -- in wip_period_balances.
302:
303: WHEN OTHERS THEN
304:
305: ERR_NUM := -999;