eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CLN_NP_PROCESSOR_PKG dependencies on FND_API

Line 258: x_ret_code := FND_API.G_RET_STS_SUCCESS;

254: ecx_cln_debug_pub.Add('Collaboration ID:' || p_coll_id, 1);
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:

Line 296: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

292: l_tp_id := p_tp_id;
293:
294: IF p_tp_id is NULL THEN
295: GET_TRADING_PARTNER_DETAILS( l_return_status, l_ret_msg, p_int_con_no, l_tp_id);
296: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
297: -- x_ret_desc := l_ret_msg;
298: -- RAISE FND_API.G_EXC_ERROR;
299: l_tp_id := NULL;
300: END IF;

Line 298: -- RAISE FND_API.G_EXC_ERROR;

294: IF p_tp_id is NULL THEN
295: GET_TRADING_PARTNER_DETAILS( l_return_status, l_ret_msg, p_int_con_no, l_tp_id);
296: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
297: -- x_ret_desc := l_ret_msg;
298: -- RAISE FND_API.G_EXC_ERROR;
299: l_tp_id := NULL;
300: END IF;
301: END IF;
302:

Line 328: --RAISE FND_API.G_EXC_ERROR;

324: END IF;
325:
326: -- removed 28June 2004.Now, we intend to support the case
327: -- when no collaboration is there
328: --RAISE FND_API.G_EXC_ERROR;
329: END;
330:
331: -- Obtain the value of CLN_DELIVERY_CONFIRMATION_CODE profile option - Default B2B_02
332: l_delivery_confirmation_code := FND_PROFILE.VALUE('CLN_DELIVERY_CONFIRMATION_CODE');

Line 339: RAISE FND_API.G_EXC_ERROR;

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:
343: IF (l_Debug_Level <= 1) THEN

Line 386: RAISE FND_API.G_EXC_ERROR;

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:
390: -- Call Delivery Confirmation API

Line 397: RAISE FND_API.G_EXC_ERROR;

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);
401: END IF;

Line 475: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

471: x_dtl_coll_id => x_dtl_coll_id,
472: p_collaboration_standard => p_collaboration_standard);
473: END IF;
474:
475: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
476: x_ret_desc := l_msg_data;
477: RAISE FND_API.G_EXC_ERROR;
478: END IF;
479:

Line 477: RAISE FND_API.G_EXC_ERROR;

473: END IF;
474:
475: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
476: x_ret_desc := l_msg_data;
477: RAISE FND_API.G_EXC_ERROR;
478: END IF;
479:
480: IF (l_Debug_Level <= 2) THEN
481: ecx_cln_debug_pub.Add('COMPLETED CLN_CH_COLLABORATION_PKG.UPDATE_COLLABORATION', 2);

Line 495: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

491: p_dtl_coll_id => x_dtl_coll_id,
492: p_ref1 => p_notification_code,
493: p_dtl_msg => p_notification_desc);
494:
495: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
496: x_ret_desc := l_msg_data;
497: RAISE FND_API.G_EXC_ERROR;
498: END IF;
499:

Line 497: RAISE FND_API.G_EXC_ERROR;

493: p_dtl_msg => p_notification_desc);
494:
495: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
496: x_ret_desc := l_msg_data;
497: RAISE FND_API.G_EXC_ERROR;
498: END IF;
499:
500: IF (l_Debug_Level <= 2) THEN
501: ecx_cln_debug_pub.Add('COMPLETED CLN_CH_COLLABORATION_PKG.ADD_COLLABORATION_MESSAGES', 2);

Line 521: RAISE FND_API.G_EXC_ERROR;

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:
525: IF (l_Debug_Level <= 1) THEN

Line 805: -- RAISE FND_API.G_EXC_ERROR;

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();
809: WF_EVENT.AddParameterToList('ApplicationId', l_application_id, l_cln_not_parameters);

Line 916: RAISE FND_API.G_EXC_ERROR;

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
920: ROLLBACK TO ACTION;

Line 919: WHEN FND_API.G_EXC_ERROR THEN

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
920: ROLLBACK TO ACTION;
921: IF (l_Debug_Level <= 5) THEN
922: ecx_cln_debug_pub.Add('Rolledback transaction', 6);
923: ecx_cln_debug_pub.Add(x_ret_desc, 6);

Line 965: WHEN FND_API.G_EXC_ERROR THEN

961: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.TAKE_ACTIONS_INTERNAL', 2);
962: END IF;
963:
964: EXCEPTION
965: WHEN FND_API.G_EXC_ERROR THEN
966: x_ret_code := FND_API.G_RET_STS_ERROR;
967: IF (l_Debug_Level <= 5) THEN
968: ecx_cln_debug_pub.Add(x_ret_desc, 6);
969: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.TAKE_ACTIONS_INTERNAL', 2);

Line 966: x_ret_code := FND_API.G_RET_STS_ERROR;

962: END IF;
963:
964: EXCEPTION
965: WHEN FND_API.G_EXC_ERROR THEN
966: x_ret_code := FND_API.G_RET_STS_ERROR;
967: IF (l_Debug_Level <= 5) THEN
968: ecx_cln_debug_pub.Add(x_ret_desc, 6);
969: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.TAKE_ACTIONS_INTERNAL', 2);
970: END IF;

Line 975: x_ret_code := FND_API.G_RET_STS_UNEXP_ERROR ;

971:
972: WHEN OTHERS THEN
973: l_error_code := SQLCODE;
974: l_error_msg := SQLERRM;
975: x_ret_code := FND_API.G_RET_STS_UNEXP_ERROR ;
976: x_ret_desc := l_error_code || ':' || l_error_msg;
977: IF (l_Debug_Level <= 5) THEN
978: ecx_cln_debug_pub.Add(x_ret_desc,6);
979: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.TAKE_ACTIONS_INTERNAL', 2);

Line 1062: x_ret_code := FND_API.G_RET_STS_SUCCESS;

1058: ecx_cln_debug_pub.Add('p_collaboration_standard:' || p_collaboration_standard, 1);
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

Line 1074: IF l_return_code <> FND_API.G_RET_STS_SUCCESS THEN

1070: p_tp_id, p_reference, p_statuslvl, p_header_desc,
1071: l_update_collaboration_flag, true, p_reason_code,
1072: p_int_con_no, p_coll_point, p_doc_dir,
1073: p_coll_id, l_dtl_coll_id,p_collaboration_standard, null,null);
1074: IF l_return_code <> FND_API.G_RET_STS_SUCCESS THEN
1075: x_ret_desc := l_return_desc;
1076: RAISE FND_API.G_EXC_ERROR;
1077: END IF;
1078:

Line 1076: RAISE FND_API.G_EXC_ERROR;

1072: p_int_con_no, p_coll_point, p_doc_dir,
1073: p_coll_id, l_dtl_coll_id,p_collaboration_standard, null,null);
1074: IF l_return_code <> FND_API.G_RET_STS_SUCCESS THEN
1075: x_ret_desc := l_return_desc;
1076: RAISE FND_API.G_EXC_ERROR;
1077: END IF;
1078:
1079: l_update_collaboration_flag := FALSE; -- no need to update second or third time
1080: ELSE

Line 1095: IF l_return_code <> FND_API.G_RET_STS_SUCCESS THEN

1091: p_tp_id, p_reference, p_statuslvl, p_header_desc,
1092: l_update_collaboration_flag, true, p_reason_code,
1093: p_int_con_no, p_coll_point, p_doc_dir,
1094: p_coll_id, l_dtl_coll_id,p_collaboration_standard,null,null);
1095: IF l_return_code <> FND_API.G_RET_STS_SUCCESS THEN
1096: x_ret_desc := l_return_desc;
1097: RAISE FND_API.G_EXC_ERROR;
1098: END IF;
1099: l_update_collaboration_flag := FALSE; -- no need to update second or third time

Line 1097: RAISE FND_API.G_EXC_ERROR;

1093: p_int_con_no, p_coll_point, p_doc_dir,
1094: p_coll_id, l_dtl_coll_id,p_collaboration_standard,null,null);
1095: IF l_return_code <> FND_API.G_RET_STS_SUCCESS THEN
1096: x_ret_desc := l_return_desc;
1097: RAISE FND_API.G_EXC_ERROR;
1098: END IF;
1099: l_update_collaboration_flag := FALSE; -- no need to update second or third time
1100: END LOOP;
1101: IF (l_Debug_Level <= 2) THEN

Line 1106: WHEN FND_API.G_EXC_ERROR THEN

1102: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.PROCESS_NOTIFICATION', 2);
1103: END IF;
1104:
1105: EXCEPTION
1106: WHEN FND_API.G_EXC_ERROR THEN
1107: ROLLBACK TO PROCESS_NOTIFICATION;
1108: IF (l_Debug_Level <= 5) THEN
1109: ecx_cln_debug_pub.Add('Rolledback transaction',5);
1110: END IF;

Line 1112: x_ret_code := FND_API.G_RET_STS_ERROR;

1108: IF (l_Debug_Level <= 5) THEN
1109: ecx_cln_debug_pub.Add('Rolledback transaction',5);
1110: END IF;
1111:
1112: x_ret_code := FND_API.G_RET_STS_ERROR;
1113: IF (l_Debug_Level <= 5) THEN
1114: ecx_cln_debug_pub.Add(x_ret_desc, 6);
1115: END IF;
1116:

Line 1134: x_ret_code := FND_API.G_RET_STS_UNEXP_ERROR;

1130: END IF;
1131:
1132: l_error_code := SQLCODE;
1133: l_error_msg := SQLERRM;
1134: x_ret_code := FND_API.G_RET_STS_UNEXP_ERROR;
1135: NOTIFY_ADMINISTRATOR('Notification processing for inbound confirmbod '
1136: || 'for the collaboration ID#'
1137: || p_coll_id
1138: || ', encountered the following error:'

Line 1194: x_ret_code := FND_API.G_RET_STS_SUCCESS;

1190: ecx_cln_debug_pub.Add('ENTERING CLN_NP_PROCESSOR_PKG.TAKE_ACTIONS', 2);
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

Line 1221: IF l_return_code <> FND_API.G_RET_STS_SUCCESS THEN

1217: null,
1218: null,
1219: l_dtl_coll_id,
1220: null, null, null);
1221: IF l_return_code <> FND_API.G_RET_STS_SUCCESS THEN
1222: x_ret_desc := l_return_msg;
1223: RAISE FND_API.G_EXC_ERROR;
1224: END IF;
1225: IF (l_Debug_Level <= 2) THEN

Line 1223: RAISE FND_API.G_EXC_ERROR;

1219: l_dtl_coll_id,
1220: null, null, null);
1221: IF l_return_code <> FND_API.G_RET_STS_SUCCESS THEN
1222: x_ret_desc := l_return_msg;
1223: RAISE FND_API.G_EXC_ERROR;
1224: END IF;
1225: IF (l_Debug_Level <= 2) THEN
1226: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.TAKE_ACTIONS', 2);
1227: END IF;

Line 1230: WHEN FND_API.G_EXC_ERROR THEN

1226: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.TAKE_ACTIONS', 2);
1227: END IF;
1228:
1229: EXCEPTION
1230: WHEN FND_API.G_EXC_ERROR THEN
1231: ROLLBACK TO TAKE_ACTIONS;
1232: IF (l_Debug_Level <= 5) THEN
1233: ecx_cln_debug_pub.Add('Rolledback transaction');
1234: END IF;

Line 1236: x_ret_code := FND_API.G_RET_STS_ERROR;

1232: IF (l_Debug_Level <= 5) THEN
1233: ecx_cln_debug_pub.Add('Rolledback transaction');
1234: END IF;
1235:
1236: x_ret_code := FND_API.G_RET_STS_ERROR;
1237: IF (l_Debug_Level <= 5) THEN
1238: ecx_cln_debug_pub.Add(x_ret_desc, 6);
1239: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.TAKE_ACTIONS', 2);
1240: END IF;

Line 1250: x_ret_code := FND_API.G_RET_STS_UNEXP_ERROR;

1246: END IF;
1247:
1248: l_return_code := SQLCODE;
1249: l_return_msg := SQLERRM;
1250: x_ret_code := FND_API.G_RET_STS_UNEXP_ERROR;
1251: x_ret_desc := l_return_code||' : '||l_return_msg;
1252: IF (l_Debug_Level <= 5) THEN
1253: ecx_cln_debug_pub.Add(x_ret_desc, 6);
1254: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.TAKE_ACTIONS', 2);

Line 1307: x_return_status := FND_API.G_RET_STS_SUCCESS;

1303: ecx_cln_debug_pub.Add('ENTERING CLN_NP_PROCESSOR_PKG.GET_TRADING_PARTNER_DETAILS', 2);
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

Line 1328: RAISE FND_API.G_EXC_ERROR;

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;
1332: RAISE FND_API.G_EXC_ERROR;

Line 1332: RAISE FND_API.G_EXC_ERROR;

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);
1336: END IF;

Line 1343: WHEN FND_API.G_EXC_ERROR THEN

1339: ecx_cln_debug_pub.Add('EXITING GET_TRADING_PARTNER_DETAILS', 2);
1340: END IF;
1341:
1342: EXCEPTION
1343: WHEN FND_API.G_EXC_ERROR THEN
1344: x_return_status := FND_API.G_RET_STS_ERROR;
1345: IF (l_Debug_Level <= 5) THEN
1346: ecx_cln_debug_pub.Add(x_msg_data, 4);
1347: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.GET_TRADING_PARTNER_DETAILS', 2);

Line 1344: x_return_status := FND_API.G_RET_STS_ERROR;

1340: END IF;
1341:
1342: EXCEPTION
1343: WHEN FND_API.G_EXC_ERROR THEN
1344: x_return_status := FND_API.G_RET_STS_ERROR;
1345: IF (l_Debug_Level <= 5) THEN
1346: ecx_cln_debug_pub.Add(x_msg_data, 4);
1347: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.GET_TRADING_PARTNER_DETAILS', 2);
1348: END IF;

Line 1354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1350: WHEN OTHERS THEN
1351: l_error_code := SQLCODE;
1352: l_error_msg := SQLERRM;
1353: x_msg_data := l_error_code || ':' || l_error_msg;
1354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1355: IF (l_Debug_Level <= 5) THEN
1356: ecx_cln_debug_pub.Add(x_msg_data, 6);
1357: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.GET_TRADING_PARTNER_DETAILS', 2);
1358: END IF;

Line 1556: x_return_status := FND_API.G_RET_STS_SUCCESS;

1552: ecx_cln_debug_pub.Add('ENTERING CLN_NP_PROCESSOR_PKG.PROCESS_NOTIF_ACTIONS_EVT', 2);
1553: END IF;
1554:
1555: -- Initialize API return status to success
1556: x_return_status := FND_API.G_RET_STS_SUCCESS;
1557: l_msg_data := 'Notifications Processing Successfully completed';
1558:
1559: -- get the paramaters passed
1560: IF (l_Debug_Level <= 1) THEN

Line 1652: RAISE FND_API.G_EXC_ERROR;

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:
1654: WHEN TOO_MANY_ROWS THEN
1655: FND_MESSAGE.SET_NAME('CLN', 'CLN_CH_EXCESS_TXN_FOUND');
1656: x_msg_data := FND_MESSAGE.GET;

Line 1658: RAISE FND_API.G_EXC_ERROR;

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;
1661: END IF;
1662:

Line 1701: -- RAISE FND_API.G_EXC_ERROR;

1697:
1698: IF ( x_return_status <> 'S') THEN
1699: l_msg_data := 'Error in FIND_COLLABORATION_ID - ' || x_msg_data;
1700: -- l_msg_data is set to appropriate value by FIND_COLLABORATION_ID
1701: -- RAISE FND_API.G_EXC_ERROR;
1702:
1703: -- we are not throwing any error here so as to make this module
1704: -- work even when no collaboration exists
1705: END IF;

Line 1734: RAISE FND_API.G_EXC_ERROR;

1730:
1731: IF ( x_return_status <> 'S') THEN
1732: l_msg_data := 'Error in GET_TRADING_PARTNER_DETAILS ';
1733: -- x_msg_data is set to appropriate value by GET_TRADING_PARTNER_DETAILS
1734: RAISE FND_API.G_EXC_ERROR;
1735: END IF;
1736:
1737: IF (l_Debug_Level <= 1) THEN
1738: -- call the API to get the default parameters through XMLG settings

Line 1755: -- RAISE FND_API.G_EXC_ERROR;

1751:
1752: IF ( x_return_status <> 'S') THEN
1753: l_msg_data := 'Error in DEFAULT_XMLGTXN_MAPPING';
1754: -- x_msg_data is set to appropriate value by DEFAULT_XMLGTXN_MAPPING
1755: -- RAISE FND_API.G_EXC_ERROR;
1756: -- No need to set up defaulting data when no collaboration exists
1757: END IF;
1758:
1759:

Line 1761: x_return_status := FND_API.G_RET_STS_SUCCESS ;

1757: END IF;
1758:
1759:
1760: IF(l_notification_code IS NULL) THEN
1761: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1762: RETURN;
1763: END IF;
1764:
1765: IF l_notification_status = 'SUCCESS' THEN

Line 1796: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1792: p_notification_event => p_notification_event,
1793: p_application_id => l_application_id );
1794:
1795:
1796: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1797: l_msg_data := 'Error in TAKE_ACTIONS_INTERNAL API ';
1798: RAISE FND_API.G_EXC_ERROR;
1799: END IF;
1800:

Line 1798: RAISE FND_API.G_EXC_ERROR;

1794:
1795:
1796: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1797: l_msg_data := 'Error in TAKE_ACTIONS_INTERNAL API ';
1798: RAISE FND_API.G_EXC_ERROR;
1799: END IF;
1800:
1801: IF (l_Debug_Level <= 2) THEN
1802: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.PROCESS_NOTIF_ACTIONS_EVT', 2);

Line 1806: WHEN FND_API.G_EXC_ERROR THEN

1802: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.PROCESS_NOTIF_ACTIONS_EVT', 2);
1803: END IF;
1804:
1805: EXCEPTION
1806: WHEN FND_API.G_EXC_ERROR THEN
1807: x_return_status := FND_API.G_RET_STS_ERROR;
1808: IF (l_Debug_Level <= 5) THEN
1809: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.PROCESS_NOTIF_ACTIONS_EVT', 2);
1810: END IF;

Line 1807: x_return_status := FND_API.G_RET_STS_ERROR;

1803: END IF;
1804:
1805: EXCEPTION
1806: WHEN FND_API.G_EXC_ERROR THEN
1807: x_return_status := FND_API.G_RET_STS_ERROR;
1808: IF (l_Debug_Level <= 5) THEN
1809: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.PROCESS_NOTIF_ACTIONS_EVT', 2);
1810: END IF;
1811:

Line 1815: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1811:
1812: WHEN OTHERS THEN
1813: l_return_code := SQLCODE;
1814: l_return_msg := SQLERRM;
1815: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1816: x_msg_data := l_return_code||' : '||x_msg_data;
1817:
1818: IF (l_Debug_Level <= 5) THEN
1819: ecx_cln_debug_pub.Add(x_msg_data, 6);

Line 1891: x_return_status := FND_API.G_RET_STS_SUCCESS;

1887: ecx_cln_debug_pub.Add('ENTERING CLN_NP_PROCESSOR_PKG.PROCESS_NOTIF_BATCH_EVT', 2);
1888: END IF;
1889:
1890: -- Initialize API return status to success
1891: x_return_status := FND_API.G_RET_STS_SUCCESS;
1892: l_msg_data := 'Batch Notification Processing Successfully completed';
1893:
1894: -- get the paramaters passed
1895: IF (l_Debug_Level <= 1) THEN

Line 1939: RAISE FND_API.G_EXC_ERROR;

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
1943: FND_MESSAGE.SET_NAME('CLN','CLN_CH_BATCH_PARAM_NULL');

Line 1945: RAISE FND_API.G_EXC_ERROR;

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
1949: ecx_cln_debug_pub.Add('Queried the display setup using application id/collaboration standard/attribute name as :'|| l_application_id||'/'||l_collaboration_std||'/'||l_attribute_name, 1);

Line 1982: RAISE FND_API.G_EXC_ERROR;

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
1986: ecx_cln_debug_pub.Add('Getting the Notification desc for Code ----- >>>'||p_notification_code, 1);

Line 2104: WHEN FND_API.G_EXC_ERROR THEN

2100: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.PROCESS_NOTIF_BATCH_EVT', 2);
2101: END IF;
2102:
2103: EXCEPTION
2104: WHEN FND_API.G_EXC_ERROR THEN
2105: x_return_status := FND_API.G_RET_STS_ERROR;
2106: IF (l_Debug_Level <= 5) THEN
2107: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.PROCESS_NOTIF_BATCH_EVT', 2);
2108: END IF;

Line 2105: x_return_status := FND_API.G_RET_STS_ERROR;

2101: END IF;
2102:
2103: EXCEPTION
2104: WHEN FND_API.G_EXC_ERROR THEN
2105: x_return_status := FND_API.G_RET_STS_ERROR;
2106: IF (l_Debug_Level <= 5) THEN
2107: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.PROCESS_NOTIF_BATCH_EVT', 2);
2108: END IF;
2109:

Line 2113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2109:
2110: WHEN OTHERS THEN
2111: l_return_code := SQLCODE;
2112: l_return_msg := SQLERRM;
2113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2114: x_msg_data := l_return_code||' : '||x_msg_data;
2115:
2116: IF (l_Debug_Level <= 5) THEN
2117: ecx_cln_debug_pub.Add(x_msg_data, 6);