APPS.M4U_PARTY_QUERY dependencies on FND_API

Line 90: x_return_status := FND_API.G_RET_STS_SUCCESS;

86: x_city := '%';
87: END IF;
88:
89:
90: x_return_status := FND_API.G_RET_STS_SUCCESS;
91: x_msg_data := '';
92:
93: IF (l_debug_Level <= 1) THEN
94: cln_debug_pub.Add('x_org_gln - ' || x_org_gln, 1);

Line 113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

109:
110:
111: EXCEPTION
112: WHEN OTHERS THEN
113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
114: x_msg_data :=' - Unexpected error in m4u_party_query/parse_param_list -'|| SQLCODE ||' : '||SQLERRM;
115:
116: END parse_param_list;
117:

Line 190: RAISE FND_API.G_EXC_ERROR;

186: IF (l_Debug_Level <= 5) THEN
187: cln_debug_pub.Add('Trading Partner '||l_msg_data,4);
188: END IF;
189:
190: RAISE FND_API.G_EXC_ERROR;
191: END IF;
192:
193:
194: -- Org gln should either contain a Wildcard/have valid GLN as parameter

Line 207: RAISE FND_API.G_EXC_ERROR;

203: IF (l_Debug_Level <= 5) THEN
204: cln_debug_pub.Add('Organization '||l_msg_data,4);
205: END IF;
206:
207: RAISE FND_API.G_EXC_ERROR;
208: END IF;
209: END IF;
210:
211: -- Set the value for the status

Line 386: WHEN FND_API.G_EXC_ERROR THEN

382:
383:
384: -- Exception Handling
385: EXCEPTION
386: WHEN FND_API.G_EXC_ERROR THEN
387: x_retcode := 2 ;
388: x_errbuf := l_msg_data;
389:
390: IF (l_Debug_Level <= 5) THEN

Line 537: x_return_status := FND_API.G_RET_STS_SUCCESS;

533:
534: -- if the database value for status is AC and the incoming
535: -- payload carries organization details with status as IN, return
536: IF (l_org_status_db IS NOT NULL) AND (l_org_status_db <> p_org_status) THEN
537: x_return_status := FND_API.G_RET_STS_SUCCESS;
538: x_msg_data := 'SUCCESS';
539: RETURN;
540: END IF;
541:

Line 582: x_return_status := FND_API.G_RET_STS_SUCCESS;

578: IF (l_Debug_Level <= 2) THEN
579: cln_debug_pub.Add('Raised - ' || l_event_name || ', key - ' || l_event_key,2);
580: END IF;
581:
582: x_return_status := FND_API.G_RET_STS_SUCCESS;
583: x_msg_data := 'SUCCESS';
584:
585: IF (l_Debug_Level <= 2) THEN
586: cln_debug_pub.Add('Exiting m4u_party_query.process_resp_org_data - Normal' ,1);

Line 593: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

589: EXCEPTION
590: WHEN OTHERS THEN
591: l_error_code := SQLCODE;
592: l_error_msg := SQLERRM;
593: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
594:
595: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
596: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
597: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);

Line 666: x_return_status := FND_API.G_RET_STS_SUCCESS;

662:
663: /* NO PROCESSING/UPDATE DEFINED */
664: /* IN-FUTURE THIS CAN BE EXTENDED */
665:
666: x_return_status := FND_API.G_RET_STS_SUCCESS;
667: x_msg_data := 'SUCCESS';
668:
669: IF (l_Debug_Level <= 2) THEN
670: cln_debug_pub.Add('Exiting m4u_party_query.process_party_links - Normal' ,1);

Line 677: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

673: EXCEPTION
674: WHEN OTHERS THEN
675: l_error_code := SQLCODE;
676: l_error_msg := SQLERRM;
677: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
678:
679: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
680: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
681: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);

Line 819: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

815: EXCEPTION
816: WHEN OTHERS THEN
817: l_error_code := SQLCODE;
818: l_error_msg := SQLERRM;
819: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
820:
821: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
822: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
823: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);