eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PON_VENDORMERGE_GRP dependencies on FND_API

Line 87: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,

83: p_party_id IN NUMBER,
84: P_dup_party_id IN NUMBER,
85: p_party_site_id IN NUMBER,
86: p_dup_party_site_id IN NUMBER,
87: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
88: p_commit IN VARCHAR2 default FND_API.G_FALSE,
89: p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,
90: p_return_status OUT NOCOPY VARCHAR2,
91: p_msg_count OUT NOCOPY NUMBER,

Line 88: p_commit IN VARCHAR2 default FND_API.G_FALSE,

84: P_dup_party_id IN NUMBER,
85: p_party_site_id IN NUMBER,
86: p_dup_party_site_id IN NUMBER,
87: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
88: p_commit IN VARCHAR2 default FND_API.G_FALSE,
89: p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,
90: p_return_status OUT NOCOPY VARCHAR2,
91: p_msg_count OUT NOCOPY NUMBER,
92: p_msg_data OUT NOCOPY VARCHAR2)

Line 89: p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,

85: p_party_site_id IN NUMBER,
86: p_dup_party_site_id IN NUMBER,
87: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
88: p_commit IN VARCHAR2 default FND_API.G_FALSE,
89: p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,
90: p_return_status OUT NOCOPY VARCHAR2,
91: p_msg_count OUT NOCOPY NUMBER,
92: p_msg_data OUT NOCOPY VARCHAR2)
93: IS

Line 143: IF (NOT FND_API.Compatible_API_Call(l_api_version,p_api_version,g_api_name,g_pkg_name)) THEN

139: fnd_file.put_line (fnd_file.log, l_progress|| ' p_dup_party_site_id ' || p_dup_party_site_id );
140:
141: -- Standard call to check for call compatibility
142:
143: IF (NOT FND_API.Compatible_API_Call(l_api_version,p_api_version,g_api_name,g_pkg_name)) THEN
144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
145: END IF;
146:
147: l_progress := 101;

Line 144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

140:
141: -- Standard call to check for call compatibility
142:
143: IF (NOT FND_API.Compatible_API_Call(l_api_version,p_api_version,g_api_name,g_pkg_name)) THEN
144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
145: END IF;
146:
147: l_progress := 101;
148: fnd_file.put_line (fnd_file.log, l_progress|| 'Done compatibility Check ....');

Line 151: IF FND_API.to_Boolean(p_init_msg_list) THEN

147: l_progress := 101;
148: fnd_file.put_line (fnd_file.log, l_progress|| 'Done compatibility Check ....');
149:
150: -- Check p_init_msg_list
151: IF FND_API.to_Boolean(p_init_msg_list) THEN
152: FND_MSG_PUB.initialize;
153: END IF;
154:
155: l_progress := 102;

Line 159: p_return_status := FND_API.G_RET_STS_SUCCESS;

155: l_progress := 102;
156: fnd_file.put_line (fnd_file.log, l_progress|| 'Done FND_MSG_PUB.initialize ');
157:
158: -- Initialize API return status to success
159: p_return_status := FND_API.G_RET_STS_SUCCESS;
160:
161:
162: -- Raise an Exception if l_party_id = null or l_party_id = -1
163:

Line 165: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

161:
162: -- Raise an Exception if l_party_id = null or l_party_id = -1
163:
164: IF ( p_party_id = null OR p_party_id = -1) THEN --{
165: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
167: END IF; --}
168:
169:

Line 166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

162: -- Raise an Exception if l_party_id = null or l_party_id = -1
163:
164: IF ( p_party_id = null OR p_party_id = -1) THEN --{
165: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
167: END IF; --}
168:
169:
170: l_progress := 103;

Line 176: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

172:
173: -- Raise an Exception if l_dup_party_id = null or l_dup_party_id = -1
174:
175: IF ( p_dup_party_id = null OR p_dup_party_id = null -1) THEN --{
176: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
178: END IF; --}
179:
180: l_progress := 104;

Line 177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

173: -- Raise an Exception if l_dup_party_id = null or l_dup_party_id = -1
174:
175: IF ( p_dup_party_id = null OR p_dup_party_id = null -1) THEN --{
176: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
178: END IF; --}
179:
180: l_progress := 104;
181: fnd_file.put_line (fnd_file.log, l_progress|| 'Done dup_party_id check....');

Line 357: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

353: l_progress := 111;
354: fnd_file.put_line (fnd_file.log, l_progress|| 'After UPDATE_SUPPLIER_ACTIVITY ...');
355:
356: EXCEPTION WHEN OTHERS THEN
357: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
358: l_progress := 000;
359:
360: fnd_file.put_line (fnd_file.log, l_progress|| 'In Exception ...'||' SQLERRM = ' || SQLERRM);
361: fnd_file.put_line (fnd_file.log, l_progress|| 'In Exception ...'||' SQLCODE = '|| SQLCODE);

Line 406: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

402:
403: fnd_file.put_line (fnd_file.log, l_progress|| ' After PON_CONTERMS_UTL_PVT.updateDelivOnVendorMerge call.... ');
404: fnd_file.put_line (fnd_file.log, l_progress|| 'End of PON_VENDORMERGE_GRP.MERGE_VENDOR ');
405:
406: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
407: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
408: l_progress := 1000;
409: fnd_file.put_line (fnd_file.log, l_progress|| 'In Exception ...'||' SQLERRM = ' || SQLERRM);
410: fnd_file.put_line (fnd_file.log, l_progress|| 'In Exception ...'||' SQLCODE = '|| SQLCODE);

Line 407: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

403: fnd_file.put_line (fnd_file.log, l_progress|| ' After PON_CONTERMS_UTL_PVT.updateDelivOnVendorMerge call.... ');
404: fnd_file.put_line (fnd_file.log, l_progress|| 'End of PON_VENDORMERGE_GRP.MERGE_VENDOR ');
405:
406: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
407: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
408: l_progress := 1000;
409: fnd_file.put_line (fnd_file.log, l_progress|| 'In Exception ...'||' SQLERRM = ' || SQLERRM);
410: fnd_file.put_line (fnd_file.log, l_progress|| 'In Exception ...'||' SQLCODE = '|| SQLCODE);
411:

Line 415: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

411:
412: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
413: p_data => p_msg_data);
414: WHEN OTHERS THEN
415: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
416: IF (G_FND_DEBUG = 'Y') THEN
417: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
418: FND_LOG.STRING(log_level => FND_LOG.LEVEL_EXCEPTION,
419: module => g_pkg_name || l_procedure_name,

Line 479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

475: AND pv.vendor_id = pvs.vendor_id
476: AND pvs.vendor_site_id = p_vendor_site_id;
477:
478: EXCEPTION WHEN NO_DATA_FOUND THEN
479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
480:
481: fnd_file.put_line (fnd_file.log, 'In Exception - GET_MERGE_TO_VENDOR_INFO ...'||' SQLERRM = ' || SQLERRM);
482: fnd_file.put_line (fnd_file.log, 'In Exception - GET_MERGE_TO_VENDOR_INFO ...'||' SQLCODE = '|| SQLCODE);
483:

Line 627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

623: l_progress := 305;
624: fnd_file.put_line (fnd_file.log, l_progress|| 'Done : pon_pf_supplier_formula');
625:
626: EXCEPTION WHEN NO_DATA_FOUND THEN
627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
628:
629: fnd_file.put_line (fnd_file.log, l_progress || 'In Exception - MERGE_SAME_VENDOR_DIFF_SITES...'||' SQLERRM = ' || SQLERRM);
630: fnd_file.put_line (fnd_file.log, l_progress || 'In Exception - MERGE_SAME_VENDOR_DIFF_SITES...'||' SQLCODE = '|| SQLCODE);
631:

Line 801: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

797: l_progress := 506;
798: fnd_file.put_line (fnd_file.log, l_progress|| ' Done: pon_pf_supplier_formula');
799:
800: EXCEPTION WHEN NO_DATA_FOUND THEN
801: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
802:
803: fnd_file.put_line (fnd_file.log, l_progress || 'In Exception - MERGE_DIFF_VENDOR_AND_SITE...'||' SQLERRM = ' || SQLERRM);
804: fnd_file.put_line (fnd_file.log, l_progress || 'In Exception - MERGE_DIFF_VENDOR_AND_SITE...'||' SQLCODE = '|| SQLCODE);
805:

Line 1057: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1053: fnd_file.put_line (fnd_file.log, l_progress|| 'Done pon_te_recipients');
1054:
1055:
1056: EXCEPTION WHEN NO_DATA_FOUND THEN
1057: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1058:
1059: fnd_file.put_line (fnd_file.log, l_progress|| 'In exception - MERGE_DIFF_VENDOR_LAST_SITE SQLERRM '||SQLERRM);
1060: fnd_file.put_line (fnd_file.log, l_progress|| 'In exception - MERGE_DIFF_VENDOR_LAST_SITE SQLCODE'||SQLCODE);
1061:

Line 1154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1150: -- end supplier activities update.
1151: --
1152:
1153: EXCEPTION WHEN NO_DATA_FOUND THEN
1154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1155:
1156: fnd_file.put_line (fnd_file.log, 'In exception - UPDATE_SUPPLIER_ACTIVITY SQLERRM '||SQLERRM);
1157: fnd_file.put_line (fnd_file.log, 'In exception - UPDATE_SUPPLIER_ACTIVITY SQLCODE'||SQLCODE);
1158: