197: , L_API_NAME
198: , G_PKG_NAME
199: )
200: THEN
201: FND_MSG_PUB.Count_And_Get
202: (
203: p_count => x_msg_count
204: , p_data => x_msg_data
205: );
207: END IF ;
208:
209: IF FND_API.to_Boolean(p_init_msg_list)
210: THEN
211: FND_MSG_PUB.initialize;
212: END IF ;
213:
214: ------------------------------------------------------------------------------
215: -- Parameter Validations:
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;
238:
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;
261:
285: p_purge_source_with_open_task
286: , 'NULL'
287: )
288: );
289: FND_MSG_PUB.ADD;
290:
291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
292: END IF;
293:
462: , L_LOG_MODULE || 'unexpected_error'
463: , 'Inside WHEN FND_API.G_EXC_UNEXPECTED_ERROR of ' || L_API_NAME_FULL
464: );
465:
466: x_msg_count := FND_MSG_PUB.Count_Msg;
467:
468: IF x_msg_count > 0
469: THEN
470: FOR
469: THEN
470: FOR
471: i IN 1..x_msg_count
472: LOOP
473: FND_MSG_PUB.Get
474: (
475: p_msg_index => i
476: , p_encoded => 'F'
477: , p_data => x_msg_data
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
500: fnd_log.string
673: , L_API_NAME
674: , G_PKG_NAME
675: )
676: THEN
677: FND_MSG_PUB.Count_And_Get
678: (
679: p_count => x_msg_count
680: , p_data => x_msg_data
681: );
684:
685: IF
686: FND_API.to_Boolean(p_init_msg_list)
687: THEN
688: FND_MSG_PUB.initialize;
689: END IF ;
690:
691: ------------------------------------------------------------------------------
692: -- Parameter Validations:
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;
716:
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;
739:
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;
762:
2027: , L_LOG_MODULE || 'unexpected_error'
2028: , 'Inside WHEN FND_API.G_EXC_UNEXPECTED_ERROR of ' || L_API_NAME_FULL
2029: );
2030:
2031: x_msg_count := FND_MSG_PUB.Count_Msg;
2032:
2033: IF x_msg_count > 0
2034: THEN
2035: FOR
2034: THEN
2035: FOR
2036: i IN 1..x_msg_count
2037: LOOP
2038: FND_MSG_PUB.Get
2039: (
2040: p_msg_index => i
2041: , p_encoded => 'F'
2042: , p_data => x_msg_data
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
2065: fnd_log.string
2185: , L_API_NAME
2186: , G_PKG_NAME
2187: )
2188: THEN
2189: FND_MSG_PUB.Count_And_Get
2190: (
2191: p_count => x_msg_count
2192: , p_data => x_msg_data
2193: );
2196:
2197: IF
2198: FND_API.to_Boolean(p_init_msg_list)
2199: THEN
2200: FND_MSG_PUB.initialize;
2201: END IF ;
2202:
2203: ------------------------------------------------------------------------------
2204: -- Actual Logic starts below:
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
2455: fnd_log.string
2572: , L_API_NAME
2573: , G_PKG_NAME
2574: )
2575: THEN
2576: FND_MSG_PUB.Count_And_Get
2577: (
2578: p_count => x_msg_count
2579: , p_data => x_msg_data
2580: );
2583:
2584: IF
2585: FND_API.to_Boolean(p_init_msg_list)
2586: THEN
2587: FND_MSG_PUB.initialize;
2588: END IF ;
2589:
2590: ------------------------------------------------------------------------------
2591: -- Actual Logic starts below:
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
2711: fnd_log.string
2829: , L_API_NAME
2830: , G_PKG_NAME
2831: )
2832: THEN
2833: FND_MSG_PUB.Count_And_Get
2834: (
2835: p_count => x_msg_count
2836: , p_data => x_msg_data
2837: );
2840:
2841: IF
2842: FND_API.to_Boolean(p_init_msg_list)
2843: THEN
2844: FND_MSG_PUB.initialize;
2845: END IF ;
2846:
2847: ------------------------------------------------------------------------------
2848: -- Actual Logic starts below:
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
3098: fnd_log.string
3291: , L_API_NAME
3292: , G_PKG_NAME
3293: )
3294: THEN
3295: FND_MSG_PUB.Count_And_Get
3296: (
3297: p_count => x_msg_count
3298: , p_data => x_msg_data
3299: );
3301: END IF ;
3302:
3303: IF FND_API.to_Boolean(p_init_msg_list)
3304: THEN
3305: FND_MSG_PUB.initialize;
3306: END IF ;
3307:
3308: ------------------------------------------------------------------------------
3309: -- Actual Logic starts below:
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
3498: fnd_log.string
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
3599: -- been terminated by the user