DBA Data[Home] [Help]

APPS.M4U_GLOBAL_REGQRY dependencies on FND_API

Line 42: x_return_status := FND_API.G_RET_STS_SUCCESS;

38: END IF;
39:
40:
41: -- Initialize API return status to success
42: x_return_status := FND_API.G_RET_STS_SUCCESS;
43: l_msg_data := 'Event for querying Global Registry raised';
44:
45:
46: -- Parameters received

Line 70: RAISE FND_API.G_EXC_ERROR;

66: p_attr_type => 'GLN',
67: p_attr_value => p_qr_ipgln
68: )THEN
69: l_msg_data := 'GLN validation failed';
70: RAISE FND_API.G_EXC_ERROR;
71: END IF;
72:
73: -- 2. Validation of the GTIN
74: IF NOT m4u_ucc_utils.validate_uccnet_attr(

Line 81: RAISE FND_API.G_EXC_ERROR;

77: p_attr_type => 'GTIN',
78: p_attr_value => p_qr_gtin
79: )THEN
80: l_msg_data := 'GTIN validation failed';
81: RAISE FND_API.G_EXC_ERROR;
82: END IF;
83:
84: -- 3. Validation of the Target Market
85: IF NOT m4u_ucc_utils.validate_uccnet_attr(

Line 92: RAISE FND_API.G_EXC_ERROR;

88: p_attr_type => 'TRGMKT',
89: p_attr_value => p_qr_targtMarkt
90: )THEN
91: l_msg_data := 'Target Market validation failed';
92: RAISE FND_API.G_EXC_ERROR;
93: END IF;
94:
95:
96:

Line 256: WHEN FND_API.G_EXC_ERROR THEN

252:
253:
254: -- Exception Handling
255: EXCEPTION
256: WHEN FND_API.G_EXC_ERROR THEN
257: x_retcode := 2 ;
258: x_errbuf := x_msg_data;
259:
260: IF (l_Debug_Level <= 5) THEN

Line 452: RAISE FND_API.G_EXC_ERROR;

448: p_rosettanet_check_required => false,
449: x_dtl_coll_id => l_collab_detail_id );
450:
451: IF(x_return_status <> 'S') THEN
452: RAISE FND_API.G_EXC_ERROR;
453: END IF;
454:
455:
456: IF (l_Debug_Level <= 1) THEN

Line 536: RAISE FND_API.G_EXC_ERROR;

532: p_dtl_msg => l_item_measurmnts
533: );
534:
535: IF(x_return_status <> 'S') THEN
536: RAISE FND_API.G_EXC_ERROR;
537: END IF;
538:
539: IF (l_Debug_Level <= 2) THEN
540: cln_debug_pub.Add('Exiting - m4u_global_regqry.process_gtin_resp Normal',2);

Line 544: WHEN FND_API.G_EXC_ERROR THEN

540: cln_debug_pub.Add('Exiting - m4u_global_regqry.process_gtin_resp Normal',2);
541: END IF;
542:
543: EXCEPTION
544: WHEN FND_API.G_EXC_ERROR THEN
545: x_return_status := FND_API.G_RET_STS_ERROR ;
546: IF (l_Debug_Level <= 4) THEN
547: cln_debug_pub.Add(x_msg_data,4);
548: cln_debug_pub.Add('------- Exiting m4u_global_regqry.process_gtin_resp - exception --------- ',2);

Line 545: x_return_status := FND_API.G_RET_STS_ERROR ;

541: END IF;
542:
543: EXCEPTION
544: WHEN FND_API.G_EXC_ERROR THEN
545: x_return_status := FND_API.G_RET_STS_ERROR ;
546: IF (l_Debug_Level <= 4) THEN
547: cln_debug_pub.Add(x_msg_data,4);
548: cln_debug_pub.Add('------- Exiting m4u_global_regqry.process_gtin_resp - exception --------- ',2);
549: END IF;

Line 554: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

550:
551: WHEN OTHERS THEN
552: l_error_code := SQLCODE;
553: l_error_msg := SQLERRM;
554: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
555:
556: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
557: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
558: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);