DBA Data[Home] [Help]

APPS.CS_SR_DELETE_UTIL dependencies on FND_MSG_PUB

Line 201: FND_MSG_PUB.Count_And_Get

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: );

Line 211: FND_MSG_PUB.initialize;

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:

Line 234: FND_MSG_PUB.ADD;

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:

Line 257: FND_MSG_PUB.ADD;

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:

Line 289: FND_MSG_PUB.ADD;

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:

Line 466: x_msg_count := FND_MSG_PUB.Count_Msg;

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

Line 473: FND_MSG_PUB.Get

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

Line 496: FND_MSG_PUB.ADD;

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

Line 677: FND_MSG_PUB.Count_And_Get

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: );

Line 688: FND_MSG_PUB.initialize;

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:

Line 712: FND_MSG_PUB.ADD;

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:

Line 735: FND_MSG_PUB.ADD;

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:

Line 758: FND_MSG_PUB.ADD;

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:

Line 2031: x_msg_count := FND_MSG_PUB.Count_Msg;

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

Line 2038: FND_MSG_PUB.Get

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

Line 2061: FND_MSG_PUB.ADD;

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

Line 2189: FND_MSG_PUB.Count_And_Get

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: );

Line 2200: FND_MSG_PUB.initialize;

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:

Line 2451: FND_MSG_PUB.ADD;

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

Line 2576: FND_MSG_PUB.Count_And_Get

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: );

Line 2587: FND_MSG_PUB.initialize;

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:

Line 2707: FND_MSG_PUB.ADD;

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

Line 2833: FND_MSG_PUB.Count_And_Get

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: );

Line 2844: FND_MSG_PUB.initialize;

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:

Line 3094: FND_MSG_PUB.ADD;

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

Line 3295: FND_MSG_PUB.Count_And_Get

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: );

Line 3305: FND_MSG_PUB.initialize;

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:

Line 3494: FND_MSG_PUB.ADD;

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

Line 3595: FND_MSG_PUB.ADD;

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