19: , errmsg IN VARCHAR2
20: )
21: IS
22: BEGIN
23: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
24: fnd_message.set_token('ROUTINE', routine);
25: fnd_message.set_token('ERRNO', errcode);
26: fnd_message.set_token('REASON', errmsg);
27: app_exception.raise_exception;
20: )
21: IS
22: BEGIN
23: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
24: fnd_message.set_token('ROUTINE', routine);
25: fnd_message.set_token('ERRNO', errcode);
26: fnd_message.set_token('REASON', errmsg);
27: app_exception.raise_exception;
28:
21: IS
22: BEGIN
23: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
24: fnd_message.set_token('ROUTINE', routine);
25: fnd_message.set_token('ERRNO', errcode);
26: fnd_message.set_token('REASON', errmsg);
27: app_exception.raise_exception;
28:
29: EXCEPTION
22: BEGIN
23: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
24: fnd_message.set_token('ROUTINE', routine);
25: fnd_message.set_token('ERRNO', errcode);
26: fnd_message.set_token('REASON', errmsg);
27: app_exception.raise_exception;
28:
29: EXCEPTION
30: WHEN OTHERS THEN RAISE;
48: , value4 IN VARCHAR2 DEFAULT NULL
49: )
50: IS
51: BEGIN
52: fnd_message.set_name('FND',error_name);
53:
54: IF (token1 IS NOT NULL AND value1 IS NOT NULL)
55: THEN
56: fnd_message.set_token(token1,value1);
52: fnd_message.set_name('FND',error_name);
53:
54: IF (token1 IS NOT NULL AND value1 IS NOT NULL)
55: THEN
56: fnd_message.set_token(token1,value1);
57: END IF;
58:
59: IF (token2 IS NOT NULL AND value2 IS NOT NULL)
60: THEN
57: END IF;
58:
59: IF (token2 IS NOT NULL AND value2 IS NOT NULL)
60: THEN
61: fnd_message.set_token(token2,value2);
62: END IF;
63:
64: IF (token3 IS NOT NULL AND value3 IS NOT NULL)
65: THEN
62: END IF;
63:
64: IF (token3 IS NOT NULL AND value3 IS NOT NULL)
65: THEN
66: fnd_message.set_token(token3,value3);
67: END IF;
68:
69: IF (token4 IS NOT NULL AND value4 IS NOT NULL)
70: THEN
67: END IF;
68:
69: IF (token4 IS NOT NULL AND value4 IS NOT NULL)
70: THEN
71: fnd_message.set_token(token4,value4);
72: END IF;
73:
74: app_exception.raise_exception;
75: