226: , 'p_object_type has to be SR.'
227: );
228: END IF ;
229:
230: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
231: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
232: FND_MESSAGE.Set_Token('PARAM', 'p_object_type');
233: FND_MESSAGE.Set_Token('CURRVAL', p_object_type);
234: FND_MSG_PUB.ADD;
227: );
228: END IF ;
229:
230: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
231: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
232: FND_MESSAGE.Set_Token('PARAM', 'p_object_type');
233: FND_MESSAGE.Set_Token('CURRVAL', p_object_type);
234: FND_MSG_PUB.ADD;
235:
228: END IF ;
229:
230: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
231: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
232: FND_MESSAGE.Set_Token('PARAM', 'p_object_type');
233: FND_MESSAGE.Set_Token('CURRVAL', p_object_type);
234: FND_MSG_PUB.ADD;
235:
236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
229:
230: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
231: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
232: FND_MESSAGE.Set_Token('PARAM', 'p_object_type');
233: FND_MESSAGE.Set_Token('CURRVAL', p_object_type);
234: FND_MSG_PUB.ADD;
235:
236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
237: END IF;
249: , 'p_processing_set_id should not be NULL.'
250: );
251: END IF ;
252:
253: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
254: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
255: FND_MESSAGE.Set_Token('PARAM', 'p_processing_set_id');
256: FND_MESSAGE.Set_Token('CURRVAL', NVL(to_char(p_processing_set_id),'NULL'));
257: FND_MSG_PUB.ADD;
250: );
251: END IF ;
252:
253: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
254: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
255: FND_MESSAGE.Set_Token('PARAM', 'p_processing_set_id');
256: FND_MESSAGE.Set_Token('CURRVAL', NVL(to_char(p_processing_set_id),'NULL'));
257: FND_MSG_PUB.ADD;
258:
251: END IF ;
252:
253: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
254: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
255: FND_MESSAGE.Set_Token('PARAM', 'p_processing_set_id');
256: FND_MESSAGE.Set_Token('CURRVAL', NVL(to_char(p_processing_set_id),'NULL'));
257: FND_MSG_PUB.ADD;
258:
259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
252:
253: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
254: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
255: FND_MESSAGE.Set_Token('PARAM', 'p_processing_set_id');
256: FND_MESSAGE.Set_Token('CURRVAL', NVL(to_char(p_processing_set_id),'NULL'));
257: FND_MSG_PUB.ADD;
258:
259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
260: END IF;
273: , 'p_purge_source_with_open_task value is invalid.'
274: );
275: END IF ;
276:
277: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
278: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
279: FND_MESSAGE.Set_Token('PARAM', 'p_purge_source_with_open_task');
280: FND_MESSAGE.Set_Token
281: (
274: );
275: END IF ;
276:
277: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
278: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
279: FND_MESSAGE.Set_Token('PARAM', 'p_purge_source_with_open_task');
280: FND_MESSAGE.Set_Token
281: (
282: 'CURRVAL'
275: END IF ;
276:
277: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
278: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
279: FND_MESSAGE.Set_Token('PARAM', 'p_purge_source_with_open_task');
280: FND_MESSAGE.Set_Token
281: (
282: 'CURRVAL'
283: , NVL
276:
277: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
278: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
279: FND_MESSAGE.Set_Token('PARAM', 'p_purge_source_with_open_task');
280: FND_MESSAGE.Set_Token
281: (
282: 'CURRVAL'
283: , NVL
284: (
489: END IF ;
490:
491: WHEN OTHERS THEN
492: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
493: FND_MESSAGE.Set_Name('CS', 'CS_SR_DEL_VAL_FAIL');
494: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
495: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
496: FND_MSG_PUB.ADD;
497:
490:
491: WHEN OTHERS THEN
492: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
493: FND_MESSAGE.Set_Name('CS', 'CS_SR_DEL_VAL_FAIL');
494: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
495: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
496: FND_MSG_PUB.ADD;
497:
498: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
491: WHEN OTHERS THEN
492: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
493: FND_MESSAGE.Set_Name('CS', 'CS_SR_DEL_VAL_FAIL');
494: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
495: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
496: FND_MSG_PUB.ADD;
497:
498: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
499: THEN
704: , 'p_audit_required has to be Y/N.'
705: );
706: END IF ;
707:
708: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
709: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
710: FND_MESSAGE.Set_Token('PARAM', 'p_audit_required');
711: FND_MESSAGE.Set_Token('CURRVAL', p_audit_required);
712: FND_MSG_PUB.ADD;
705: );
706: END IF ;
707:
708: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
709: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
710: FND_MESSAGE.Set_Token('PARAM', 'p_audit_required');
711: FND_MESSAGE.Set_Token('CURRVAL', p_audit_required);
712: FND_MSG_PUB.ADD;
713:
706: END IF ;
707:
708: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
709: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
710: FND_MESSAGE.Set_Token('PARAM', 'p_audit_required');
711: FND_MESSAGE.Set_Token('CURRVAL', p_audit_required);
712: FND_MSG_PUB.ADD;
713:
714: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
707:
708: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
709: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
710: FND_MESSAGE.Set_Token('PARAM', 'p_audit_required');
711: FND_MESSAGE.Set_Token('CURRVAL', p_audit_required);
712: FND_MSG_PUB.ADD;
713:
714: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
715: END IF;
727: , 'p_object_type has to be SR.'
728: );
729: END IF ;
730:
731: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
732: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
733: FND_MESSAGE.Set_Token('PARAM', 'p_object_type');
734: FND_MESSAGE.Set_Token('CURRVAL', p_object_type);
735: FND_MSG_PUB.ADD;
728: );
729: END IF ;
730:
731: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
732: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
733: FND_MESSAGE.Set_Token('PARAM', 'p_object_type');
734: FND_MESSAGE.Set_Token('CURRVAL', p_object_type);
735: FND_MSG_PUB.ADD;
736:
729: END IF ;
730:
731: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
732: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
733: FND_MESSAGE.Set_Token('PARAM', 'p_object_type');
734: FND_MESSAGE.Set_Token('CURRVAL', p_object_type);
735: FND_MSG_PUB.ADD;
736:
737: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
730:
731: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
732: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
733: FND_MESSAGE.Set_Token('PARAM', 'p_object_type');
734: FND_MESSAGE.Set_Token('CURRVAL', p_object_type);
735: FND_MSG_PUB.ADD;
736:
737: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
738: END IF;
750: , 'Processing Set Id should not be NULL.'
751: );
752: END IF ;
753:
754: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
755: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
756: FND_MESSAGE.Set_Token('PARAM', 'p_processing_set_id');
757: FND_MESSAGE.Set_Token('CURRVAL', NVL(to_char(p_processing_set_id),'NULL'));
758: FND_MSG_PUB.ADD;
751: );
752: END IF ;
753:
754: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
755: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
756: FND_MESSAGE.Set_Token('PARAM', 'p_processing_set_id');
757: FND_MESSAGE.Set_Token('CURRVAL', NVL(to_char(p_processing_set_id),'NULL'));
758: FND_MSG_PUB.ADD;
759:
752: END IF ;
753:
754: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
755: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
756: FND_MESSAGE.Set_Token('PARAM', 'p_processing_set_id');
757: FND_MESSAGE.Set_Token('CURRVAL', NVL(to_char(p_processing_set_id),'NULL'));
758: FND_MSG_PUB.ADD;
759:
760: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
753:
754: FND_MESSAGE.Set_Name('CS', 'CS_SR_PARAM_VALUE_ERROR');
755: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
756: FND_MESSAGE.Set_Token('PARAM', 'p_processing_set_id');
757: FND_MESSAGE.Set_Token('CURRVAL', NVL(to_char(p_processing_set_id),'NULL'));
758: FND_MSG_PUB.ADD;
759:
760: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
761: END IF;
2054: END IF ;
2055:
2056: WHEN OTHERS THEN
2057: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2058: FND_MESSAGE.Set_Name('CS', 'CS_SR_DEL_FAIL');
2059: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
2060: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
2061: FND_MSG_PUB.ADD;
2062:
2055:
2056: WHEN OTHERS THEN
2057: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2058: FND_MESSAGE.Set_Name('CS', 'CS_SR_DEL_FAIL');
2059: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
2060: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
2061: FND_MSG_PUB.ADD;
2062:
2063: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2056: WHEN OTHERS THEN
2057: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2058: FND_MESSAGE.Set_Name('CS', 'CS_SR_DEL_FAIL');
2059: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
2060: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
2061: FND_MSG_PUB.ADD;
2062:
2063: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2064: THEN
2444: END IF ;
2445:
2446: WHEN OTHERS THEN
2447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2448: FND_MESSAGE.Set_Name('CS', 'CS_SR_CONT_DEL_FAIL');
2449: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
2450: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
2451: FND_MSG_PUB.ADD;
2452:
2445:
2446: WHEN OTHERS THEN
2447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2448: FND_MESSAGE.Set_Name('CS', 'CS_SR_CONT_DEL_FAIL');
2449: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
2450: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
2451: FND_MSG_PUB.ADD;
2452:
2453: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2446: WHEN OTHERS THEN
2447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2448: FND_MESSAGE.Set_Name('CS', 'CS_SR_CONT_DEL_FAIL');
2449: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
2450: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
2451: FND_MSG_PUB.ADD;
2452:
2453: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2454: THEN
2700: END IF ;
2701:
2702: WHEN OTHERS THEN
2703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2704: FND_MESSAGE.Set_Name('CS', 'CS_SR_AUDIT_DEL_FAIL');
2705: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
2706: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
2707: FND_MSG_PUB.ADD;
2708:
2701:
2702: WHEN OTHERS THEN
2703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2704: FND_MESSAGE.Set_Name('CS', 'CS_SR_AUDIT_DEL_FAIL');
2705: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
2706: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
2707: FND_MSG_PUB.ADD;
2708:
2709: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2702: WHEN OTHERS THEN
2703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2704: FND_MESSAGE.Set_Name('CS', 'CS_SR_AUDIT_DEL_FAIL');
2705: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
2706: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
2707: FND_MSG_PUB.ADD;
2708:
2709: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2710: THEN
3087: END IF ;
3088:
3089: WHEN OTHERS THEN
3090: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3091: FND_MESSAGE.Set_Name('CS', 'CS_SR_ATTR_VAL_DEL_FAIL');
3092: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
3093: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
3094: FND_MSG_PUB.ADD;
3095:
3088:
3089: WHEN OTHERS THEN
3090: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3091: FND_MESSAGE.Set_Name('CS', 'CS_SR_ATTR_VAL_DEL_FAIL');
3092: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
3093: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
3094: FND_MSG_PUB.ADD;
3095:
3096: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
3089: WHEN OTHERS THEN
3090: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3091: FND_MESSAGE.Set_Name('CS', 'CS_SR_ATTR_VAL_DEL_FAIL');
3092: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
3093: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
3094: FND_MSG_PUB.ADD;
3095:
3096: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
3097: THEN
3487: END IF ;
3488:
3489: WHEN OTHERS THEN
3490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3491: FND_MESSAGE.Set_Name('CS', 'CS_SR_PRG_CRT_FAIL');
3492: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
3493: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
3494: FND_MSG_PUB.ADD;
3495:
3488:
3489: WHEN OTHERS THEN
3490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3491: FND_MESSAGE.Set_Name('CS', 'CS_SR_PRG_CRT_FAIL');
3492: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
3493: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
3494: FND_MSG_PUB.ADD;
3495:
3496: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
3489: WHEN OTHERS THEN
3490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3491: FND_MESSAGE.Set_Name('CS', 'CS_SR_PRG_CRT_FAIL');
3492: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
3493: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
3494: FND_MSG_PUB.ADD;
3495:
3496: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
3497: THEN
3590: || ' and phase ' || l_dev_phase
3591: );
3592: END IF ;
3593:
3594: FND_MESSAGE.Set_Name('CS', 'CS_SR_USER_STOPPED');
3595: FND_MSG_PUB.ADD;
3596:
3597: -- Setting the request_data to 'T'
3598: -- indicating that the request has