APPS.POS_ASN_CREATE_PVT dependencies on FND_LOG

Line 15: /* Taken from Package FND_LOG

11: p_msg in varchar2)
12: IS
13: l_module varchar2(2000);
14: BEGIN
15: /* Taken from Package FND_LOG
16: LEVEL_UNEXPECTED CONSTANT NUMBER := 6;
17: LEVEL_ERROR CONSTANT NUMBER := 5;
18: LEVEL_EXCEPTION CONSTANT NUMBER := 4;
19: LEVEL_EVENT CONSTANT NUMBER := 3;

Line 27: IF ( p_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

23:
24: IF(l_fnd_debug = 'Y')THEN
25: l_module := 'pos.plsql.pos_asn_create_pvt.'||p_api_name;
26:
27: IF ( p_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
28: FND_LOG.string( LOG_LEVEL => p_level,
29: MODULE => l_module,
30: MESSAGE => p_msg);
31: END IF;

Line 28: FND_LOG.string( LOG_LEVEL => p_level,

24: IF(l_fnd_debug = 'Y')THEN
25: l_module := 'pos.plsql.pos_asn_create_pvt.'||p_api_name;
26:
27: IF ( p_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
28: FND_LOG.string( LOG_LEVEL => p_level,
29: MODULE => l_module,
30: MESSAGE => p_msg);
31: END IF;
32:

Line 204: LOG(FND_LOG.LEVEL_UNEXPECTED,l_api_name,l_progress||':'||sqlerrm);

200:
201: exception when others then
202: x_return_status := 'U';
203: x_msg_data := 'Unexpected Error:'||sqlerrm;
204: LOG(FND_LOG.LEVEL_UNEXPECTED,l_api_name,l_progress||':'||sqlerrm);
205: END insert_msni;
206:
207: /**
208: * Public Procedure: insert_mtli

Line 461: LOG(FND_LOG.LEVEL_UNEXPECTED,l_api_name,l_progress||':'||sqlerrm);

457:
458: exception when others then
459: x_return_status := 'U';
460: x_msg_data := 'Unexpected Error:'||sqlerrm;
461: LOG(FND_LOG.LEVEL_UNEXPECTED,l_api_name,l_progress||':'||sqlerrm);
462: END insert_mtli;
463:
464: procedure insert_wlpni
465: (p_api_version IN NUMBER

Line 570: LOG(FND_LOG.LEVEL_UNEXPECTED,l_api_name,l_progress||':'||sqlerrm);

566:
567: end if;
568:
569: EXCEPTION WHEN OTHERS THEN
570: LOG(FND_LOG.LEVEL_UNEXPECTED,l_api_name,l_progress||':'||sqlerrm);
571: x_return_status := 'U';
572: x_msg_data := 'Unexpected Error:'||sqlerrm;
573: END insert_wlpni;
574:

Line 644: LOG(FND_LOG.LEVEL_UNEXPECTED,l_api_name,l_progress||':'||sqlerrm);

640:
641: exception when others then
642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
643: x_return_msg := 'Unexpected Error at POSVASNB.pls.ValidateSerialRange:'||sqlerrm;
644: LOG(FND_LOG.LEVEL_UNEXPECTED,l_api_name,l_progress||':'||sqlerrm);
645: END ValidateSerialRange;
646:
647: procedure ValidateLpn( p_api_version in number,
648: x_return_status out nocopy varchar2,

Line 717: LOG(FND_LOG.LEVEL_UNEXPECTED,l_api_name,l_progress||':'||sqlerrm);

713: x_return_status := FND_API.G_RET_STS_SUCCESS;
714: exception when others then
715: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
716: x_return_msg := 'Unexpected Error at POSVASNB.pls.ValidateLpn:'||sqlerrm;
717: LOG(FND_LOG.LEVEL_UNEXPECTED,l_api_name,l_progress||':'||sqlerrm);
718: END ValidateLpn;
719:
720: procedure ValidateLot(
721: p_api_version in number,

Line 888: LOG(FND_LOG.LEVEL_UNEXPECTED,l_api_name,l_progress||':'||sqlerrm);

884: x_return_status := FND_API.G_RET_STS_SUCCESS;
885: EXCEPTION WHEN OTHERS THEN
886: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
887: x_return_msg := 'Unexpected Error at POSVASNB.pls.ValidateLot:'||sqlerrm;
888: LOG(FND_LOG.LEVEL_UNEXPECTED,l_api_name,l_progress||':'||sqlerrm);
889: END ValidateLot;
890:
891: procedure findLlsCode(p_line_location_id in number, x_llsCode out nocopy varchar2)
892: IS

Line 938: LOG(FND_LOG.LEVEL_UNEXPECTED,l_api_name,l_progress||':'||sqlerrm);

934: x_llsCode := 'LPN';
935: end if;
936: end if;
937: exception when others then
938: LOG(FND_LOG.LEVEL_UNEXPECTED,l_api_name,l_progress||':'||sqlerrm);
939: x_llsCode := 'ERR:'||sqlerrm;
940:
941: END findLlsCode;
942: