DBA Data[Home] [Help]

APPS.CLN_NP_PROCESSOR_PKG dependencies on FND_MESSAGE

Line 259: FND_MESSAGE.SET_NAME('CLN', 'CLN_SUCCESS'); -- 'Success'

255: END IF;
256:
257:
258: x_ret_code := FND_API.G_RET_STS_SUCCESS;
259: FND_MESSAGE.SET_NAME('CLN', 'CLN_SUCCESS'); -- 'Success'
260: x_ret_desc := FND_MESSAGE.GET;
261:
262:
263: BEGIN

Line 260: x_ret_desc := FND_MESSAGE.GET;

256:
257:
258: x_ret_code := FND_API.G_RET_STS_SUCCESS;
259: FND_MESSAGE.SET_NAME('CLN', 'CLN_SUCCESS'); -- 'Success'
260: x_ret_desc := FND_MESSAGE.GET;
261:
262:
263: BEGIN
264: IF (l_Debug_Level <= 1) THEN

Line 319: FND_MESSAGE.SET_NAME('CLN', 'CLN_INVALID_REFERENCE'); -- 'Invalid reference'

315:
316: EXCEPTION
317: WHEN NO_DATA_FOUND THEN
318: -- INVALID REFERENCE
319: FND_MESSAGE.SET_NAME('CLN', 'CLN_INVALID_REFERENCE'); -- 'Invalid reference'
320: x_ret_desc := FND_MESSAGE.GET;
321:
322: IF (l_Debug_Level <= 1) THEN
323: ecx_cln_debug_pub.Add('Collaboration does not exist or Invalid Collaboration', 1);

Line 320: x_ret_desc := FND_MESSAGE.GET;

316: EXCEPTION
317: WHEN NO_DATA_FOUND THEN
318: -- INVALID REFERENCE
319: FND_MESSAGE.SET_NAME('CLN', 'CLN_INVALID_REFERENCE'); -- 'Invalid reference'
320: x_ret_desc := FND_MESSAGE.GET;
321:
322: IF (l_Debug_Level <= 1) THEN
323: ecx_cln_debug_pub.Add('Collaboration does not exist or Invalid Collaboration', 1);
324: END IF;

Line 336: FND_MESSAGE.SET_NAME('CLN', 'CLN_PO_DEL_CONFIRM_NOT_FOUND');

332: l_delivery_confirmation_code := FND_PROFILE.VALUE('CLN_DELIVERY_CONFIRMATION_CODE');
333:
334: IF l_delivery_confirmation_code IS NULL THEN
335:
336: FND_MESSAGE.SET_NAME('CLN', 'CLN_PO_DEL_CONFIRM_NOT_FOUND');
337: -- 'Profile option - CLN_DELIVERY_CONFIRMATION_CODE - Not found'
338: x_ret_desc := FND_MESSAGE.GET;
339: RAISE FND_API.G_EXC_ERROR;
340:

Line 338: x_ret_desc := FND_MESSAGE.GET;

334: IF l_delivery_confirmation_code IS NULL THEN
335:
336: FND_MESSAGE.SET_NAME('CLN', 'CLN_PO_DEL_CONFIRM_NOT_FOUND');
337: -- 'Profile option - CLN_DELIVERY_CONFIRMATION_CODE - Not found'
338: x_ret_desc := FND_MESSAGE.GET;
339: RAISE FND_API.G_EXC_ERROR;
340:
341: END IF;
342:

Line 383: FND_MESSAGE.SET_NAME('CLN', 'CLN_INVALID_TRAN_DATA');

379:
380: EXCEPTION
381: WHEN NO_DATA_FOUND THEN
382: -- INVALID TRANSACTION TYPE,TRANSACTION SUBTYPE AND DOCUMENT ID
383: FND_MESSAGE.SET_NAME('CLN', 'CLN_INVALID_TRAN_DATA');
384: -- 'Unable to call delivery confirmation: Invalid transaction type, transaction subtype and document id'
385: x_ret_desc := FND_MESSAGE.GET;
386: RAISE FND_API.G_EXC_ERROR;
387: END;

Line 385: x_ret_desc := FND_MESSAGE.GET;

381: WHEN NO_DATA_FOUND THEN
382: -- INVALID TRANSACTION TYPE,TRANSACTION SUBTYPE AND DOCUMENT ID
383: FND_MESSAGE.SET_NAME('CLN', 'CLN_INVALID_TRAN_DATA');
384: -- 'Unable to call delivery confirmation: Invalid transaction type, transaction subtype and document id'
385: x_ret_desc := FND_MESSAGE.GET;
386: RAISE FND_API.G_EXC_ERROR;
387: END;
388: END IF;
389:

Line 393: FND_MESSAGE.SET_NAME('CLN', 'CLN_ERROR_DELIVERY_CONFIRM_API');

389:
390: -- Call Delivery Confirmation API
391: ECX_ERRORLOG.external_system(l_msg_id, 0, 'Success', sysdate, l_ret_code, l_ret_msg);
392: IF l_ret_code <> 0 THEN
393: FND_MESSAGE.SET_NAME('CLN', 'CLN_ERROR_DELIVERY_CONFIRM_API');
394: -- 'Error while calling delivery confirmation API:' || l_ret_msg;
395: FND_MESSAGE.SET_TOKEN('ERRMESSAGE', l_ret_msg);
396: x_ret_desc := FND_MESSAGE.GET;
397: RAISE FND_API.G_EXC_ERROR;

Line 395: FND_MESSAGE.SET_TOKEN('ERRMESSAGE', l_ret_msg);

391: ECX_ERRORLOG.external_system(l_msg_id, 0, 'Success', sysdate, l_ret_code, l_ret_msg);
392: IF l_ret_code <> 0 THEN
393: FND_MESSAGE.SET_NAME('CLN', 'CLN_ERROR_DELIVERY_CONFIRM_API');
394: -- 'Error while calling delivery confirmation API:' || l_ret_msg;
395: FND_MESSAGE.SET_TOKEN('ERRMESSAGE', l_ret_msg);
396: x_ret_desc := FND_MESSAGE.GET;
397: RAISE FND_API.G_EXC_ERROR;
398: END IF;
399: IF (l_Debug_Level <= 1) THEN

Line 396: x_ret_desc := FND_MESSAGE.GET;

392: IF l_ret_code <> 0 THEN
393: FND_MESSAGE.SET_NAME('CLN', 'CLN_ERROR_DELIVERY_CONFIRM_API');
394: -- 'Error while calling delivery confirmation API:' || l_ret_msg;
395: FND_MESSAGE.SET_TOKEN('ERRMESSAGE', l_ret_msg);
396: x_ret_desc := FND_MESSAGE.GET;
397: RAISE FND_API.G_EXC_ERROR;
398: END IF;
399: IF (l_Debug_Level <= 1) THEN
400: ecx_cln_debug_pub.Add('Executed delivery confirmation API:' || l_ret_code || ':' || l_ret_msg, 1);

Line 519: FND_MESSAGE.SET_NAME('CLN', 'CLN_INVALID_APPL_ID'); -- 'Invalid application id'

515:
516: EXCEPTION
517: WHEN NO_DATA_FOUND THEN
518: -- INVALID APPLICATION ID
519: FND_MESSAGE.SET_NAME('CLN', 'CLN_INVALID_APPL_ID'); -- 'Invalid application id'
520: x_ret_desc := FND_MESSAGE.GET;
521: RAISE FND_API.G_EXC_ERROR;
522: END;
523:

Line 520: x_ret_desc := FND_MESSAGE.GET;

516: EXCEPTION
517: WHEN NO_DATA_FOUND THEN
518: -- INVALID APPLICATION ID
519: FND_MESSAGE.SET_NAME('CLN', 'CLN_INVALID_APPL_ID'); -- 'Invalid application id'
520: x_ret_desc := FND_MESSAGE.GET;
521: RAISE FND_API.G_EXC_ERROR;
522: END;
523:
524:

Line 803: -- FND_MESSAGE.SET_NAME('CLN', 'CLN_INVALID_TRADING_PARTNER'); -- 'Invalid trading partner'

799: IF (l_Debug_Level <= 4) THEN
800: ecx_cln_debug_pub.Add('Invalid trading partner: Unable to notify trading partner:' || l_tp_id, 3);
801: END IF;
802:
803: -- FND_MESSAGE.SET_NAME('CLN', 'CLN_INVALID_TRADING_PARTNER'); -- 'Invalid trading partner'
804: -- x_ret_desc := FND_MESSAGE.GET;
805: -- RAISE FND_API.G_EXC_ERROR;
806: END;
807: ELSIF c_actions.action_code = 'RAISE_EVENT' THEN

Line 804: -- x_ret_desc := FND_MESSAGE.GET;

800: ecx_cln_debug_pub.Add('Invalid trading partner: Unable to notify trading partner:' || l_tp_id, 3);
801: END IF;
802:
803: -- FND_MESSAGE.SET_NAME('CLN', 'CLN_INVALID_TRADING_PARTNER'); -- 'Invalid trading partner'
804: -- x_ret_desc := FND_MESSAGE.GET;
805: -- RAISE FND_API.G_EXC_ERROR;
806: END;
807: ELSIF c_actions.action_code = 'RAISE_EVENT' THEN
808: l_cln_not_parameters := wf_parameter_list_t();

Line 914: FND_MESSAGE.SET_NAME('CLN', 'CLN_INVALID_ACTION_DEFINED'); -- 'Invalid action defined'

910: l_procedure_call_statement := 'begin ' || c_actions.attribute1 || '(:l_cln_not_parameters); end;';
911: execute immediate l_procedure_call_statement using l_cln_not_parameters;
912: END IF;
913: ELSE
914: FND_MESSAGE.SET_NAME('CLN', 'CLN_INVALID_ACTION_DEFINED'); -- 'Invalid action defined'
915: x_ret_desc := FND_MESSAGE.GET;
916: RAISE FND_API.G_EXC_ERROR;
917: END IF;
918: EXCEPTION

Line 915: x_ret_desc := FND_MESSAGE.GET;

911: execute immediate l_procedure_call_statement using l_cln_not_parameters;
912: END IF;
913: ELSE
914: FND_MESSAGE.SET_NAME('CLN', 'CLN_INVALID_ACTION_DEFINED'); -- 'Invalid action defined'
915: x_ret_desc := FND_MESSAGE.GET;
916: RAISE FND_API.G_EXC_ERROR;
917: END IF;
918: EXCEPTION
919: WHEN FND_API.G_EXC_ERROR THEN

Line 1063: FND_MESSAGE.SET_NAME('CLN', 'CLN_SUCCESS'); -- 'Success'

1059: END IF;
1060:
1061:
1062: x_ret_code := FND_API.G_RET_STS_SUCCESS;
1063: FND_MESSAGE.SET_NAME('CLN', 'CLN_SUCCESS'); -- 'Success'
1064: x_ret_desc := FND_MESSAGE.GET;
1065:
1066: l_update_collaboration_flag := TRUE; -- IF TRUE collaboration is updated
1067: IF p_reason_code = ':' or p_reason_code IS NULL THEN

Line 1064: x_ret_desc := FND_MESSAGE.GET;

1060:
1061:
1062: x_ret_code := FND_API.G_RET_STS_SUCCESS;
1063: FND_MESSAGE.SET_NAME('CLN', 'CLN_SUCCESS'); -- 'Success'
1064: x_ret_desc := FND_MESSAGE.GET;
1065:
1066: l_update_collaboration_flag := TRUE; -- IF TRUE collaboration is updated
1067: IF p_reason_code = ':' or p_reason_code IS NULL THEN
1068: l_all_reason_codes := NULL;

Line 1195: FND_MESSAGE.SET_NAME('CLN', 'CLN_SUCCESS'); -- 'Success'

1191: END IF;
1192:
1193:
1194: x_ret_code := FND_API.G_RET_STS_SUCCESS;
1195: FND_MESSAGE.SET_NAME('CLN', 'CLN_SUCCESS'); -- 'Success'
1196: x_ret_desc := FND_MESSAGE.GET;
1197:
1198: IF p_status = 'SUCCESS' THEN
1199: l_statuslvl := '00';

Line 1196: x_ret_desc := FND_MESSAGE.GET;

1192:
1193:
1194: x_ret_code := FND_API.G_RET_STS_SUCCESS;
1195: FND_MESSAGE.SET_NAME('CLN', 'CLN_SUCCESS'); -- 'Success'
1196: x_ret_desc := FND_MESSAGE.GET;
1197:
1198: IF p_status = 'SUCCESS' THEN
1199: l_statuslvl := '00';
1200: ELSE

Line 1308: FND_MESSAGE.SET_NAME('CLN', 'CLN_SUCCESS'); -- 'Success'

1304: END IF;
1305:
1306:
1307: x_return_status := FND_API.G_RET_STS_SUCCESS;
1308: FND_MESSAGE.SET_NAME('CLN', 'CLN_SUCCESS'); -- 'Success'
1309: x_msg_data := FND_MESSAGE.GET;
1310:
1311: BEGIN
1312: SELECT to_char(eth.tp_header_id)

Line 1309: x_msg_data := FND_MESSAGE.GET;

1305:
1306:
1307: x_return_status := FND_API.G_RET_STS_SUCCESS;
1308: FND_MESSAGE.SET_NAME('CLN', 'CLN_SUCCESS'); -- 'Success'
1309: x_msg_data := FND_MESSAGE.GET;
1310:
1311: BEGIN
1312: SELECT to_char(eth.tp_header_id)
1313: INTO p_tr_partner_id

Line 1326: FND_MESSAGE.SET_NAME('CLN','CLN_CH_TP_DETAILS_NOT_FOUND');

1322: AND eep.direction = 'IN'
1323: AND eth.party_type = NVL(doclogs.party_type,eth.party_type);
1324: EXCEPTION
1325: WHEN NO_DATA_FOUND THEN
1326: FND_MESSAGE.SET_NAME('CLN','CLN_CH_TP_DETAILS_NOT_FOUND');
1327: x_msg_data := FND_MESSAGE.GET;
1328: RAISE FND_API.G_EXC_ERROR;
1329: WHEN TOO_MANY_ROWS THEN
1330: FND_MESSAGE.SET_NAME('CLN','CLN_CH_TP_DETAILS_NOT_FOUND');

Line 1327: x_msg_data := FND_MESSAGE.GET;

1323: AND eth.party_type = NVL(doclogs.party_type,eth.party_type);
1324: EXCEPTION
1325: WHEN NO_DATA_FOUND THEN
1326: FND_MESSAGE.SET_NAME('CLN','CLN_CH_TP_DETAILS_NOT_FOUND');
1327: x_msg_data := FND_MESSAGE.GET;
1328: RAISE FND_API.G_EXC_ERROR;
1329: WHEN TOO_MANY_ROWS THEN
1330: FND_MESSAGE.SET_NAME('CLN','CLN_CH_TP_DETAILS_NOT_FOUND');
1331: x_msg_data := FND_MESSAGE.GET;

Line 1330: FND_MESSAGE.SET_NAME('CLN','CLN_CH_TP_DETAILS_NOT_FOUND');

1326: FND_MESSAGE.SET_NAME('CLN','CLN_CH_TP_DETAILS_NOT_FOUND');
1327: x_msg_data := FND_MESSAGE.GET;
1328: RAISE FND_API.G_EXC_ERROR;
1329: WHEN TOO_MANY_ROWS THEN
1330: FND_MESSAGE.SET_NAME('CLN','CLN_CH_TP_DETAILS_NOT_FOUND');
1331: x_msg_data := FND_MESSAGE.GET;
1332: RAISE FND_API.G_EXC_ERROR;
1333: END;
1334: IF (l_Debug_Level <= 1) THEN

Line 1331: x_msg_data := FND_MESSAGE.GET;

1327: x_msg_data := FND_MESSAGE.GET;
1328: RAISE FND_API.G_EXC_ERROR;
1329: WHEN TOO_MANY_ROWS THEN
1330: FND_MESSAGE.SET_NAME('CLN','CLN_CH_TP_DETAILS_NOT_FOUND');
1331: x_msg_data := FND_MESSAGE.GET;
1332: RAISE FND_API.G_EXC_ERROR;
1333: END;
1334: IF (l_Debug_Level <= 1) THEN
1335: ecx_cln_debug_pub.Add('p_tr_partner_id:' || p_tr_partner_id, 1);

Line 1648: FND_MESSAGE.SET_NAME('CLN', 'CLN_CH_TRANSACTION_NOT_FOUND');

1644: END IF;
1645:
1646: EXCEPTION
1647: WHEN NO_DATA_FOUND THEN
1648: FND_MESSAGE.SET_NAME('CLN', 'CLN_CH_TRANSACTION_NOT_FOUND');
1649: x_msg_data := FND_MESSAGE.GET;
1650: l_msg_data := 'Unable to find External Transaction Type/ Subtype';
1651:
1652: RAISE FND_API.G_EXC_ERROR;

Line 1649: x_msg_data := FND_MESSAGE.GET;

1645:
1646: EXCEPTION
1647: WHEN NO_DATA_FOUND THEN
1648: FND_MESSAGE.SET_NAME('CLN', 'CLN_CH_TRANSACTION_NOT_FOUND');
1649: x_msg_data := FND_MESSAGE.GET;
1650: l_msg_data := 'Unable to find External Transaction Type/ Subtype';
1651:
1652: RAISE FND_API.G_EXC_ERROR;
1653:

Line 1655: FND_MESSAGE.SET_NAME('CLN', 'CLN_CH_EXCESS_TXN_FOUND');

1651:
1652: RAISE FND_API.G_EXC_ERROR;
1653:
1654: WHEN TOO_MANY_ROWS THEN
1655: FND_MESSAGE.SET_NAME('CLN', 'CLN_CH_EXCESS_TXN_FOUND');
1656: x_msg_data := FND_MESSAGE.GET;
1657: l_msg_data := 'More then one row found for the same transaction detail';
1658: RAISE FND_API.G_EXC_ERROR;
1659: END;

Line 1656: x_msg_data := FND_MESSAGE.GET;

1652: RAISE FND_API.G_EXC_ERROR;
1653:
1654: WHEN TOO_MANY_ROWS THEN
1655: FND_MESSAGE.SET_NAME('CLN', 'CLN_CH_EXCESS_TXN_FOUND');
1656: x_msg_data := FND_MESSAGE.GET;
1657: l_msg_data := 'More then one row found for the same transaction detail';
1658: RAISE FND_API.G_EXC_ERROR;
1659: END;
1660: END IF;

Line 1937: FND_MESSAGE.SET_NAME('CLN', 'CLN_INVALID_APPL_ID'); -- 'Invalid application id'

1933:
1934: EXCEPTION
1935: WHEN NO_DATA_FOUND THEN
1936: -- INVALID APPLICATION ID
1937: FND_MESSAGE.SET_NAME('CLN', 'CLN_INVALID_APPL_ID'); -- 'Invalid application id'
1938: x_msg_data := FND_MESSAGE.GET;
1939: RAISE FND_API.G_EXC_ERROR;
1940: END;
1941:

Line 1938: x_msg_data := FND_MESSAGE.GET;

1934: EXCEPTION
1935: WHEN NO_DATA_FOUND THEN
1936: -- INVALID APPLICATION ID
1937: FND_MESSAGE.SET_NAME('CLN', 'CLN_INVALID_APPL_ID'); -- 'Invalid application id'
1938: x_msg_data := FND_MESSAGE.GET;
1939: RAISE FND_API.G_EXC_ERROR;
1940: END;
1941:
1942: IF(l_attribute_name IS NULL) OR (l_attribute_value IS NULL) THEN

Line 1943: FND_MESSAGE.SET_NAME('CLN','CLN_CH_BATCH_PARAM_NULL');

1939: RAISE FND_API.G_EXC_ERROR;
1940: END;
1941:
1942: IF(l_attribute_name IS NULL) OR (l_attribute_value IS NULL) THEN
1943: FND_MESSAGE.SET_NAME('CLN','CLN_CH_BATCH_PARAM_NULL');
1944: x_msg_data := FND_MESSAGE.GET;
1945: RAISE FND_API.G_EXC_ERROR;
1946: END IF;
1947:

Line 1944: x_msg_data := FND_MESSAGE.GET;

1940: END;
1941:
1942: IF(l_attribute_name IS NULL) OR (l_attribute_value IS NULL) THEN
1943: FND_MESSAGE.SET_NAME('CLN','CLN_CH_BATCH_PARAM_NULL');
1944: x_msg_data := FND_MESSAGE.GET;
1945: RAISE FND_API.G_EXC_ERROR;
1946: END IF;
1947:
1948: IF (l_Debug_Level <= 4) THEN

Line 1973: FND_MESSAGE.SET_NAME('CLN', 'CLN_DISPLAY_SETUP_ERROR');

1969:
1970: EXCEPTION
1971: WHEN NO_DATA_FOUND THEN
1972: -- DISPLAY SETUP NOT DONE
1973: FND_MESSAGE.SET_NAME('CLN', 'CLN_DISPLAY_SETUP_ERROR');
1974: FND_MESSAGE.SET_TOKEN('APPLID',l_application_id);
1975: FND_MESSAGE.SET_TOKEN('COLLSTD',l_collaboration_std);
1976:
1977: IF (l_Debug_Level <= 4) THEN

Line 1974: FND_MESSAGE.SET_TOKEN('APPLID',l_application_id);

1970: EXCEPTION
1971: WHEN NO_DATA_FOUND THEN
1972: -- DISPLAY SETUP NOT DONE
1973: FND_MESSAGE.SET_NAME('CLN', 'CLN_DISPLAY_SETUP_ERROR');
1974: FND_MESSAGE.SET_TOKEN('APPLID',l_application_id);
1975: FND_MESSAGE.SET_TOKEN('COLLSTD',l_collaboration_std);
1976:
1977: IF (l_Debug_Level <= 4) THEN
1978: ecx_cln_debug_pub.Add('Display SetUp Not Found forapplication id/collaboration standard/attribute name as :'|| l_application_id||'/'||l_collaboration_std||'/'||l_attribute_name, 4);

Line 1975: FND_MESSAGE.SET_TOKEN('COLLSTD',l_collaboration_std);

1971: WHEN NO_DATA_FOUND THEN
1972: -- DISPLAY SETUP NOT DONE
1973: FND_MESSAGE.SET_NAME('CLN', 'CLN_DISPLAY_SETUP_ERROR');
1974: FND_MESSAGE.SET_TOKEN('APPLID',l_application_id);
1975: FND_MESSAGE.SET_TOKEN('COLLSTD',l_collaboration_std);
1976:
1977: IF (l_Debug_Level <= 4) THEN
1978: ecx_cln_debug_pub.Add('Display SetUp Not Found forapplication id/collaboration standard/attribute name as :'|| l_application_id||'/'||l_collaboration_std||'/'||l_attribute_name, 4);
1979: END IF;

Line 1981: x_msg_data := FND_MESSAGE.GET;

1977: IF (l_Debug_Level <= 4) THEN
1978: ecx_cln_debug_pub.Add('Display SetUp Not Found forapplication id/collaboration standard/attribute name as :'|| l_application_id||'/'||l_collaboration_std||'/'||l_attribute_name, 4);
1979: END IF;
1980:
1981: x_msg_data := FND_MESSAGE.GET;
1982: RAISE FND_API.G_EXC_ERROR;
1983: END;
1984:
1985: IF (l_Debug_Level <= 4) THEN

Line 2064: FND_MESSAGE.SET_NAME('CLN', 'CLN_NOTIF_DTLS');

2060: SELECT cln_np_notification_workflow_s.nextval INTO l_notification_flow_key FROM dual;
2061:
2062:
2063: ------------ get the notification details -----------
2064: FND_MESSAGE.SET_NAME('CLN', 'CLN_NOTIF_DTLS');
2065: FND_MESSAGE.SET_TOKEN('ATTRNAME',l_attribute_col_value);
2066: FND_MESSAGE.SET_TOKEN('ATTRVALUE',p_attribute_value);
2067: l_notification_dtls := FND_MESSAGE.GET;
2068:

Line 2065: FND_MESSAGE.SET_TOKEN('ATTRNAME',l_attribute_col_value);

2061:
2062:
2063: ------------ get the notification details -----------
2064: FND_MESSAGE.SET_NAME('CLN', 'CLN_NOTIF_DTLS');
2065: FND_MESSAGE.SET_TOKEN('ATTRNAME',l_attribute_col_value);
2066: FND_MESSAGE.SET_TOKEN('ATTRVALUE',p_attribute_value);
2067: l_notification_dtls := FND_MESSAGE.GET;
2068:
2069: IF (l_Debug_Level <= 4) THEN

Line 2066: FND_MESSAGE.SET_TOKEN('ATTRVALUE',p_attribute_value);

2062:
2063: ------------ get the notification details -----------
2064: FND_MESSAGE.SET_NAME('CLN', 'CLN_NOTIF_DTLS');
2065: FND_MESSAGE.SET_TOKEN('ATTRNAME',l_attribute_col_value);
2066: FND_MESSAGE.SET_TOKEN('ATTRVALUE',p_attribute_value);
2067: l_notification_dtls := FND_MESSAGE.GET;
2068:
2069: IF (l_Debug_Level <= 4) THEN
2070: ecx_cln_debug_pub.Add('l_notification_dtls : '||l_notification_dtls , 4);

Line 2067: l_notification_dtls := FND_MESSAGE.GET;

2063: ------------ get the notification details -----------
2064: FND_MESSAGE.SET_NAME('CLN', 'CLN_NOTIF_DTLS');
2065: FND_MESSAGE.SET_TOKEN('ATTRNAME',l_attribute_col_value);
2066: FND_MESSAGE.SET_TOKEN('ATTRVALUE',p_attribute_value);
2067: l_notification_dtls := FND_MESSAGE.GET;
2068:
2069: IF (l_Debug_Level <= 4) THEN
2070: ecx_cln_debug_pub.Add('l_notification_dtls : '||l_notification_dtls , 4);
2071: END IF;