DBA Data[Home] [Help]

APPS.OKL_AM_QUOTES_WF dependencies on FND_MESSAGE

Line 73: FND_MESSAGE.SET_NAME('OKL', 'OKL_API_OTHERS_EXCEP');

69: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME, 'EXCEPTION :'||'OTHERS, SQLCODE: '
70: || sqlcode || ' , SQLERRM : ' || sqlerrm);
71: END IF;
72:
73: FND_MESSAGE.SET_NAME('OKL', 'OKL_API_OTHERS_EXCEP');
74: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
75: FND_MSG_PUB.ADD;
76: IF okl_key_csr%ISOPEN THEN
77: CLOSE okl_key_csr;

Line 74: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

70: || sqlcode || ' , SQLERRM : ' || sqlerrm);
71: END IF;
72:
73: FND_MESSAGE.SET_NAME('OKL', 'OKL_API_OTHERS_EXCEP');
74: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
75: FND_MSG_PUB.ADD;
76: IF okl_key_csr%ISOPEN THEN
77: CLOSE okl_key_csr;
78: END IF;

Line 147: FND_MESSAGE.SET_NAME('OKL', 'OKL_API_OTHERS_EXCEP');

143: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME, 'EXCEPTION :'||'OTHERS, SQLCODE: '
144: || sqlcode || ' , SQLERRM : ' || sqlerrm);
145: END IF;
146:
147: FND_MESSAGE.SET_NAME('OKL', 'OKL_API_OTHERS_EXCEP');
148: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
149: FND_MSG_PUB.ADD;
150: IF okl_key_csr%ISOPEN THEN
151: CLOSE okl_key_csr;

Line 148: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

144: || sqlcode || ' , SQLERRM : ' || sqlerrm);
145: END IF;
146:
147: FND_MESSAGE.SET_NAME('OKL', 'OKL_API_OTHERS_EXCEP');
148: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
149: FND_MSG_PUB.ADD;
150: IF okl_key_csr%ISOPEN THEN
151: CLOSE okl_key_csr;
152: END IF;

Line 8202: -- which it cannot be retrieved using FND_MESSAGE.get

8198: -- Desciption : Sets the message with tokens
8199: -- Does NOT put the message on the message stack
8200: -- This set_message is used instead of the standard OKL_API.set_message
8201: -- because the OKL_API.set_message puts the message on message stack after
8202: -- which it cannot be retrieved using FND_MESSAGE.get
8203: -- Business Rules :
8204: -- Parameters :
8205: -- Version : 1.0
8206: -- History : RMUNJULU created 4131592

Line 8243: FND_MESSAGE.set_name( P_APP_NAME, P_MSG_NAME);

8239: IF (is_debug_procedure_on) THEN
8240: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');
8241: END IF;
8242:
8243: FND_MESSAGE.set_name( P_APP_NAME, P_MSG_NAME);
8244:
8245: IF (p_token1 IS NOT NULL) AND (p_token1_value IS NOT NULL) THEN
8246: FND_MESSAGE.set_token( TOKEN => p_token1,
8247: VALUE => p_token1_value);

Line 8246: FND_MESSAGE.set_token( TOKEN => p_token1,

8242:
8243: FND_MESSAGE.set_name( P_APP_NAME, P_MSG_NAME);
8244:
8245: IF (p_token1 IS NOT NULL) AND (p_token1_value IS NOT NULL) THEN
8246: FND_MESSAGE.set_token( TOKEN => p_token1,
8247: VALUE => p_token1_value);
8248: END IF;
8249:
8250: IF (p_token2 IS NOT NULL) AND (p_token2_value IS NOT NULL) THEN

Line 8251: FND_MESSAGE.set_token( TOKEN => p_token2,

8247: VALUE => p_token1_value);
8248: END IF;
8249:
8250: IF (p_token2 IS NOT NULL) AND (p_token2_value IS NOT NULL) THEN
8251: FND_MESSAGE.set_token( TOKEN => p_token2,
8252: VALUE => p_token2_value);
8253: END IF;
8254:
8255: IF (p_token3 IS NOT NULL) AND (p_token3_value IS NOT NULL) THEN

Line 8256: FND_MESSAGE.set_token( TOKEN => p_token3,

8252: VALUE => p_token2_value);
8253: END IF;
8254:
8255: IF (p_token3 IS NOT NULL) AND (p_token3_value IS NOT NULL) THEN
8256: FND_MESSAGE.set_token( TOKEN => p_token3,
8257: VALUE => p_token3_value);
8258: END IF;
8259:
8260: IF (p_token4 IS NOT NULL) AND (p_token4_value IS NOT NULL) THEN

Line 8261: FND_MESSAGE.set_token( TOKEN => p_token4,

8257: VALUE => p_token3_value);
8258: END IF;
8259:
8260: IF (p_token4 IS NOT NULL) AND (p_token4_value IS NOT NULL) THEN
8261: FND_MESSAGE.set_token( TOKEN => p_token4,
8262: VALUE => p_token4_value);
8263: END IF;
8264:
8265: IF (p_token5 IS NOT NULL) AND (p_token5_value IS NOT NULL) THEN

Line 8266: FND_MESSAGE.set_token( TOKEN => p_token5,

8262: VALUE => p_token4_value);
8263: END IF;
8264:
8265: IF (p_token5 IS NOT NULL) AND (p_token5_value IS NOT NULL) THEN
8266: FND_MESSAGE.set_token( TOKEN => p_token5,
8267: VALUE => p_token5_value);
8268: END IF;
8269:
8270: IF (p_token6 IS NOT NULL) AND (p_token6_value IS NOT NULL) THEN

Line 8271: FND_MESSAGE.set_token( TOKEN => p_token6,

8267: VALUE => p_token5_value);
8268: END IF;
8269:
8270: IF (p_token6 IS NOT NULL) AND (p_token6_value IS NOT NULL) THEN
8271: FND_MESSAGE.set_token( TOKEN => p_token6,
8272: VALUE => p_token6_value);
8273: END IF;
8274: IF (p_token7 IS NOT NULL) AND (p_token7_value IS NOT NULL) THEN
8275: FND_MESSAGE.set_token( TOKEN => p_token7,

Line 8275: FND_MESSAGE.set_token( TOKEN => p_token7,

8271: FND_MESSAGE.set_token( TOKEN => p_token6,
8272: VALUE => p_token6_value);
8273: END IF;
8274: IF (p_token7 IS NOT NULL) AND (p_token7_value IS NOT NULL) THEN
8275: FND_MESSAGE.set_token( TOKEN => p_token7,
8276: VALUE => p_token7_value);
8277: END IF;
8278:
8279: IF (p_token8 IS NOT NULL) AND (p_token8_value IS NOT NULL) THEN

Line 8280: FND_MESSAGE.set_token( TOKEN => p_token8,

8276: VALUE => p_token7_value);
8277: END IF;
8278:
8279: IF (p_token8 IS NOT NULL) AND (p_token8_value IS NOT NULL) THEN
8280: FND_MESSAGE.set_token( TOKEN => p_token8,
8281: VALUE => p_token8_value);
8282: END IF;
8283: IF (p_token9 IS NOT NULL) AND (p_token9_value IS NOT NULL) THEN
8284: FND_MESSAGE.set_token( TOKEN => p_token9,

Line 8284: FND_MESSAGE.set_token( TOKEN => p_token9,

8280: FND_MESSAGE.set_token( TOKEN => p_token8,
8281: VALUE => p_token8_value);
8282: END IF;
8283: IF (p_token9 IS NOT NULL) AND (p_token9_value IS NOT NULL) THEN
8284: FND_MESSAGE.set_token( TOKEN => p_token9,
8285: VALUE => p_token9_value);
8286: END IF;
8287:
8288: IF (p_token10 IS NOT NULL) AND (p_token10_value IS NOT NULL) THEN

Line 8289: FND_MESSAGE.set_token( TOKEN => p_token10,

8285: VALUE => p_token9_value);
8286: END IF;
8287:
8288: IF (p_token10 IS NOT NULL) AND (p_token10_value IS NOT NULL) THEN
8289: FND_MESSAGE.set_token( TOKEN => p_token10,
8290: VALUE => p_token10_value);
8291: END IF;
8292:
8293: --FND_MSG_PUB.add;

Line 8386: l_roll_message_header := FND_MESSAGE.get;

8382: set_message(
8383: p_app_name => 'OKL',
8384: p_msg_name => 'OKL_AM_ROLL_HDR_MSG');
8385:
8386: l_roll_message_header := FND_MESSAGE.get;
8387:
8388: wf_engine.SetItemAttrText (
8389: itemtype=> itemtype,
8390: itemkey => itemkey,

Line 8533: l_noti_msg := FND_MESSAGE.get;

8529: p_token3_value => l_quote_amt_rec.amount,
8530: p_token4 => 'CURRENCY',
8531: p_token4_value => l_currency_code);
8532:
8533: l_noti_msg := FND_MESSAGE.get;
8534:
8535: l_message := '

'||l_noti_msg||'

';
8536:
8537: document := l_message;