DBA Data[Home] [Help]

APPS.CE_CEPURGE_XMLP_PKG dependencies on FND_MESSAGE

Line 182: FND_MESSAGE.SET_NAME('CE', 'CE_PURGE_NO_SOB');

178: EXCEPTION
179: WHEN NO_DATA_FOUND THEN
180: SET_NAME('CE'
181: ,'CE_PURGE_NO_SOB');
182: FND_MESSAGE.SET_NAME('CE', 'CE_PURGE_NO_SOB');
183: ERROR_FOUND := TRUE;
184: END;
185: IF (P_BANK_ACCOUNT IS NOT NULL AND P_BANK_BRANCH IS NOT NULL) THEN
186: SELECT

Line 196: FND_MESSAGE.SET_NAME('CE', 'CE_PURGE_BRANCH_ACCOUNT');

192: WHERE BANK_ACCOUNT_ID = P_BANK_ACCOUNT;
193: IF (L_BANK_BRANCH_ID <> P_BANK_BRANCH) THEN
194: SET_NAME('CE'
195: ,'CE_PURGE_BRANCH_ACCOUNT');
196: FND_MESSAGE.SET_NAME('CE', 'CE_PURGE_BRANCH_ACCOUNT');
197: ERROR_FOUND := TRUE;
198: END IF;
199: END IF;
200: IF (P_DEBUG_MODE = 'Y') THEN

Line 2136: /* STPROC.INIT('begin FND_MESSAGE.SET_NAME(:APPLICATION, :NAME); end;');

2132:
2133: PROCEDURE SET_NAME(APPLICATION IN VARCHAR2
2134: ,NAME IN VARCHAR2) IS
2135: BEGIN
2136: /* STPROC.INIT('begin FND_MESSAGE.SET_NAME(:APPLICATION, :NAME); end;');
2137: STPROC.BIND_I(APPLICATION);
2138: STPROC.BIND_I(NAME);
2139: STPROC.EXECUTE;*/
2140: FND_MESSAGE.SET_NAME(APPLICATION, NAME);

Line 2140: FND_MESSAGE.SET_NAME(APPLICATION, NAME);

2136: /* STPROC.INIT('begin FND_MESSAGE.SET_NAME(:APPLICATION, :NAME); end;');
2137: STPROC.BIND_I(APPLICATION);
2138: STPROC.BIND_I(NAME);
2139: STPROC.EXECUTE;*/
2140: FND_MESSAGE.SET_NAME(APPLICATION, NAME);
2141: END SET_NAME;
2142:
2143: PROCEDURE SET_TOKEN(TOKEN IN VARCHAR2
2144: ,VALUE IN VARCHAR2

Line 2149: /* STPROC.INIT('declare TRANSLATE BOOLEAN; begin TRANSLATE := sys.diutil.int_to_bool(:TRANSLATE); FND_MESSAGE.SET_TOKEN(:TOKEN, :VALUE, TRANSLATE); end;');

2145: ,TRANSLATE IN number) IS
2146: BEGIN
2147: declare
2148: TRANSLATE_1 BOOLEAN;
2149: /* STPROC.INIT('declare TRANSLATE BOOLEAN; begin TRANSLATE := sys.diutil.int_to_bool(:TRANSLATE); FND_MESSAGE.SET_TOKEN(:TOKEN, :VALUE, TRANSLATE); end;');
2150: STPROC.BIND_I(TRANSLATE);
2151: STPROC.BIND_I(TOKEN);
2152: STPROC.BIND_I(VALUE);
2153: STPROC.EXECUTE;*/

Line 2161: /*STPROC.INIT('begin FND_MESSAGE.RETRIEVE(:MSGOUT); end;');

2157: END SET_TOKEN;
2158:
2159: PROCEDURE RETRIEVE(MSGOUT OUT NOCOPY VARCHAR2) IS
2160: BEGIN
2161: /*STPROC.INIT('begin FND_MESSAGE.RETRIEVE(:MSGOUT); end;');
2162: STPROC.BIND_O(MSGOUT);
2163: STPROC.EXECUTE;
2164: STPROC.RETRIEVE(1
2165: ,MSGOUT);*/

Line 2166: FND_MESSAGE.RETRIEVE(MSGOUT);

2162: STPROC.BIND_O(MSGOUT);
2163: STPROC.EXECUTE;
2164: STPROC.RETRIEVE(1
2165: ,MSGOUT);*/
2166: FND_MESSAGE.RETRIEVE(MSGOUT);
2167: END RETRIEVE;
2168:
2169: PROCEDURE CLEAR IS
2170: BEGIN

Line 2171: /* STPROC.INIT('begin FND_MESSAGE.CLEAR; end;');

2167: END RETRIEVE;
2168:
2169: PROCEDURE CLEAR IS
2170: BEGIN
2171: /* STPROC.INIT('begin FND_MESSAGE.CLEAR; end;');
2172: STPROC.EXECUTE;*/
2173: FND_MESSAGE.CLEAR;
2174: END CLEAR;
2175:

Line 2173: FND_MESSAGE.CLEAR;

2169: PROCEDURE CLEAR IS
2170: BEGIN
2171: /* STPROC.INIT('begin FND_MESSAGE.CLEAR; end;');
2172: STPROC.EXECUTE;*/
2173: FND_MESSAGE.CLEAR;
2174: END CLEAR;
2175:
2176: FUNCTION GET_STRING(APPIN IN VARCHAR2
2177: ,NAMEIN IN VARCHAR2) RETURN VARCHAR2 IS

Line 2180: /* STPROC.INIT('begin :X0 := FND_MESSAGE.GET_STRING(:APPIN, :NAMEIN); end;');

2176: FUNCTION GET_STRING(APPIN IN VARCHAR2
2177: ,NAMEIN IN VARCHAR2) RETURN VARCHAR2 IS
2178: X0 VARCHAR2(2000);
2179: BEGIN
2180: /* STPROC.INIT('begin :X0 := FND_MESSAGE.GET_STRING(:APPIN, :NAMEIN); end;');
2181: STPROC.BIND_O(X0);
2182: STPROC.BIND_I(APPIN);
2183: STPROC.BIND_I(NAMEIN);
2184: STPROC.EXECUTE;

Line 2187: X0 := FND_MESSAGE.GET_STRING(APPIN, NAMEIN);

2183: STPROC.BIND_I(NAMEIN);
2184: STPROC.EXECUTE;
2185: STPROC.RETRIEVE(1
2186: ,X0);*/
2187: X0 := FND_MESSAGE.GET_STRING(APPIN, NAMEIN);
2188: RETURN X0;
2189: END GET_STRING;
2190:
2191: FUNCTION GET_NUMBER(APPIN IN VARCHAR2

Line 2195: /*STPROC.INIT('begin :X0 := FND_MESSAGE.GET_NUMBER(:APPIN, :NAMEIN); end;');

2191: FUNCTION GET_NUMBER(APPIN IN VARCHAR2
2192: ,NAMEIN IN VARCHAR2) RETURN NUMBER IS
2193: X0 NUMBER;
2194: BEGIN
2195: /*STPROC.INIT('begin :X0 := FND_MESSAGE.GET_NUMBER(:APPIN, :NAMEIN); end;');
2196: STPROC.BIND_O(X0);
2197: STPROC.BIND_I(APPIN);
2198: STPROC.BIND_I(NAMEIN);
2199: STPROC.EXECUTE;

Line 2202: X0 := FND_MESSAGE.GET_NUMBER(APPIN, NAMEIN);

2198: STPROC.BIND_I(NAMEIN);
2199: STPROC.EXECUTE;
2200: STPROC.RETRIEVE(1
2201: ,X0);*/
2202: X0 := FND_MESSAGE.GET_NUMBER(APPIN, NAMEIN);
2203: RETURN X0;
2204: END GET_NUMBER;
2205:
2206: FUNCTION GET RETURN VARCHAR2 IS

Line 2209: /* STPROC.INIT('begin :X0 := FND_MESSAGE.GET; end;');

2205:
2206: FUNCTION GET RETURN VARCHAR2 IS
2207: X0 VARCHAR2(2000);
2208: BEGIN
2209: /* STPROC.INIT('begin :X0 := FND_MESSAGE.GET; end;');
2210: STPROC.BIND_O(X0);
2211: STPROC.EXECUTE;
2212: STPROC.RETRIEVE(1
2213: ,X0);*/

Line 2214: X0 := FND_MESSAGE.GET;

2210: STPROC.BIND_O(X0);
2211: STPROC.EXECUTE;
2212: STPROC.RETRIEVE(1
2213: ,X0);*/
2214: X0 := FND_MESSAGE.GET;
2215: RETURN X0;
2216: END GET;
2217:
2218: FUNCTION GET_ENCODED RETURN VARCHAR2 IS

Line 2221: /*STPROC.INIT('begin :X0 := FND_MESSAGE.GET_ENCODED; end;');

2217:
2218: FUNCTION GET_ENCODED RETURN VARCHAR2 IS
2219: X0 VARCHAR2(2000);
2220: BEGIN
2221: /*STPROC.INIT('begin :X0 := FND_MESSAGE.GET_ENCODED; end;');
2222: STPROC.BIND_O(X0);
2223: STPROC.EXECUTE;
2224: STPROC.RETRIEVE(1
2225: ,X0);*/

Line 2226: X0 := FND_MESSAGE.GET_ENCODED;

2222: STPROC.BIND_O(X0);
2223: STPROC.EXECUTE;
2224: STPROC.RETRIEVE(1
2225: ,X0);*/
2226: X0 := FND_MESSAGE.GET_ENCODED;
2227: RETURN X0;
2228: END GET_ENCODED;
2229:
2230: PROCEDURE PARSE_ENCODED(ENCODED_MESSAGE IN VARCHAR2

Line 2234: /* STPROC.INIT('begin FND_MESSAGE.PARSE_ENCODED(:ENCODED_MESSAGE, :APP_SHORT_NAME, :MESSAGE_NAME); end;');

2230: PROCEDURE PARSE_ENCODED(ENCODED_MESSAGE IN VARCHAR2
2231: ,APP_SHORT_NAME OUT NOCOPY VARCHAR2
2232: ,MESSAGE_NAME OUT NOCOPY VARCHAR2) IS
2233: BEGIN
2234: /* STPROC.INIT('begin FND_MESSAGE.PARSE_ENCODED(:ENCODED_MESSAGE, :APP_SHORT_NAME, :MESSAGE_NAME); end;');
2235: STPROC.BIND_I(ENCODED_MESSAGE);
2236: STPROC.BIND_O(APP_SHORT_NAME);
2237: STPROC.BIND_O(MESSAGE_NAME);
2238: STPROC.EXECUTE;

Line 2243: FND_MESSAGE.PARSE_ENCODED(ENCODED_MESSAGE, APP_SHORT_NAME, MESSAGE_NAME);

2239: STPROC.RETRIEVE(2
2240: ,APP_SHORT_NAME);
2241: STPROC.RETRIEVE(3
2242: ,MESSAGE_NAME);*/
2243: FND_MESSAGE.PARSE_ENCODED(ENCODED_MESSAGE, APP_SHORT_NAME, MESSAGE_NAME);
2244: END PARSE_ENCODED;
2245:
2246: PROCEDURE SET_ENCODED(ENCODED_MESSAGE IN VARCHAR2) IS
2247: BEGIN

Line 2248: /* STPROC.INIT('begin FND_MESSAGE.SET_ENCODED(:ENCODED_MESSAGE); end;');

2244: END PARSE_ENCODED;
2245:
2246: PROCEDURE SET_ENCODED(ENCODED_MESSAGE IN VARCHAR2) IS
2247: BEGIN
2248: /* STPROC.INIT('begin FND_MESSAGE.SET_ENCODED(:ENCODED_MESSAGE); end;');
2249: STPROC.BIND_I(ENCODED_MESSAGE);
2250: STPROC.EXECUTE;*/
2251: FND_MESSAGE.SET_ENCODED(ENCODED_MESSAGE);
2252: END SET_ENCODED;

Line 2251: FND_MESSAGE.SET_ENCODED(ENCODED_MESSAGE);

2247: BEGIN
2248: /* STPROC.INIT('begin FND_MESSAGE.SET_ENCODED(:ENCODED_MESSAGE); end;');
2249: STPROC.BIND_I(ENCODED_MESSAGE);
2250: STPROC.EXECUTE;*/
2251: FND_MESSAGE.SET_ENCODED(ENCODED_MESSAGE);
2252: END SET_ENCODED;
2253:
2254: PROCEDURE RAISE_ERROR IS
2255: BEGIN

Line 2256: /* STPROC.INIT('begin FND_MESSAGE.RAISE_ERROR; end;');

2252: END SET_ENCODED;
2253:
2254: PROCEDURE RAISE_ERROR IS
2255: BEGIN
2256: /* STPROC.INIT('begin FND_MESSAGE.RAISE_ERROR; end;');
2257: STPROC.EXECUTE;*/
2258: FND_MESSAGE.RAISE_ERROR;
2259: END RAISE_ERROR;
2260:

Line 2258: FND_MESSAGE.RAISE_ERROR;

2254: PROCEDURE RAISE_ERROR IS
2255: BEGIN
2256: /* STPROC.INIT('begin FND_MESSAGE.RAISE_ERROR; end;');
2257: STPROC.EXECUTE;*/
2258: FND_MESSAGE.RAISE_ERROR;
2259: END RAISE_ERROR;
2260:
2261: PROCEDURE DEBUG(LINE IN VARCHAR2) IS
2262: BEGIN