124: num_rows := SQL%ROWCOUNT;
125: RETURN (num_rows);
126:
127: EXCEPTION
128: WHEN app_exceptions.application_exception THEN
129: RAISE;
130: WHEN OTHERS THEN
131: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
132: fnd_message.set_token('PROCEDURE',
239: num_rows := SQL%ROWCOUNT;
240: RETURN (num_rows);
241:
242: EXCEPTION
243: WHEN app_exceptions.application_exception THEN
244: RAISE;
245: WHEN OTHERS THEN
246: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
247: fnd_message.set_token('PROCEDURE',
361: num_rows := SQL%ROWCOUNT;
362: RETURN (num_rows);
363:
364: EXCEPTION
365: WHEN app_exceptions.application_exception THEN
366: RAISE;
367: WHEN OTHERS THEN
368: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
369: fnd_message.set_token('PROCEDURE',
453: EXECUTE IMMEDIATE insert_stmt USING header_id, user_id, user_id,
454: login_id, ccid, header_id;
455:
456: EXCEPTION
457: WHEN app_exceptions.application_exception THEN
458: RAISE;
459: WHEN OTHERS THEN
460: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
461: fnd_message.set_token('PROCEDURE',
477: num_rows := SQL%ROWCOUNT;
478: RETURN (num_rows);
479:
480: EXCEPTION
481: WHEN app_exceptions.application_exception THEN
482: RAISE;
483: WHEN OTHERS THEN
484: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
485: fnd_message.set_token('PROCEDURE',
503: num_rows := SQL%ROWCOUNT;
504: RETURN (num_rows);
505:
506: EXCEPTION
507: WHEN app_exceptions.application_exception THEN
508: RAISE;
509: WHEN OTHERS THEN
510: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
511: fnd_message.set_token('PROCEDURE',
572:
573: END IF;
574:
575: EXCEPTION
576: WHEN app_exceptions.application_exception THEN
577: RAISE;
578: WHEN OTHERS THEN
579: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
580: fnd_message.set_token('PROCEDURE',
690: num_rows := SQL%ROWCOUNT;
691: RETURN (num_rows);
692:
693: EXCEPTION
694: WHEN app_exceptions.application_exception THEN
695: RAISE;
696: WHEN OTHERS THEN
697: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
698: fnd_message.set_token('PROCEDURE',
845: num_rows := SQL%ROWCOUNT;
846: RETURN (num_rows);
847:
848: EXCEPTION
849: WHEN app_exceptions.application_exception THEN
850: RAISE;
851: WHEN OTHERS THEN
852: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
853: fnd_message.set_token('PROCEDURE',
965: num_rows := SQL%ROWCOUNT;
966: RETURN (num_rows);
967:
968: EXCEPTION
969: WHEN app_exceptions.application_exception THEN
970: RAISE;
971: WHEN OTHERS THEN
972: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
973: fnd_message.set_token('PROCEDURE',