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 8200: -- which it cannot be retrieved using FND_MESSAGE.get

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 8384: l_roll_message_header := FND_MESSAGE.get;

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

Line 8531: l_noti_msg := FND_MESSAGE.get;

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

'||l_noti_msg||'

';
8534:
8535: document := l_message;