APPS.HZ_IMP_LOAD_FINNUMBERS_PKG dependencies on FND_API

Line 76: x_return_status := FND_API.G_RET_STS_SUCCESS;

72: l_debug_prefix VARCHAR2(30) := '';
73: BEGIN
74: savepoint load_finnumbers_pvt;
75: FND_MSG_PUB.initialize;
76: x_return_status := FND_API.G_RET_STS_SUCCESS;
77:
78: --enable_debug;
79: -- Debug info.
80: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 89: IF x_return_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN

85:
86: process_insert_finnumbers(P_DML_RECORD,
87: x_return_status, x_msg_count, x_msg_data );
88:
89: IF x_return_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
90: process_update_finnumbers(P_DML_RECORD,
91: x_return_status, x_msg_count, x_msg_data );
92: END IF;
93:

Line 102: WHEN FND_API.G_EXC_ERROR THEN

98: END IF;
99: --disable_debug;
100:
101: EXCEPTION
102: WHEN FND_API.G_EXC_ERROR THEN
103: ----dbms_output.put_line('G_EXC_ERROR');
104:
105: ROLLBACK TO load_finnumbers_pvt;
106: FND_FILE.put_line(fnd_file.log,'Execution error occurs while loading financial numbers');

Line 108: x_return_status := FND_API.G_RET_STS_ERROR;

104:
105: ROLLBACK TO load_finnumbers_pvt;
106: FND_FILE.put_line(fnd_file.log,'Execution error occurs while loading financial numbers');
107: FND_FILE.put_line(fnd_file.log, SQLERRM);
108: x_return_status := FND_API.G_RET_STS_ERROR;
109: FND_MSG_PUB.Count_And_Get(
110: p_encoded => FND_API.G_FALSE,
111: p_count => x_msg_count,
112: p_data => x_msg_data);

Line 110: p_encoded => FND_API.G_FALSE,

106: FND_FILE.put_line(fnd_file.log,'Execution error occurs while loading financial numbers');
107: FND_FILE.put_line(fnd_file.log, SQLERRM);
108: x_return_status := FND_API.G_RET_STS_ERROR;
109: FND_MSG_PUB.Count_And_Get(
110: p_encoded => FND_API.G_FALSE,
111: p_count => x_msg_count,
112: p_data => x_msg_data);
113:
114: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 114: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

110: p_encoded => FND_API.G_FALSE,
111: p_count => x_msg_count,
112: p_data => x_msg_data);
113:
114: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
115: ----dbms_output.put_line('Unexpected error occurs while loading financial numbers');
116:
117: ROLLBACK TO load_finnumbers_pvt;
118: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading financial numbers');

Line 120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

116:
117: ROLLBACK TO load_finnumbers_pvt;
118: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading financial numbers');
119: FND_FILE.put_line(fnd_file.log, SQLERRM);
120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
121: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
122: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
123: FND_MSG_PUB.ADD;
124: FND_MSG_PUB.Count_And_Get(

Line 125: p_encoded => FND_API.G_FALSE,

121: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
122: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
123: FND_MSG_PUB.ADD;
124: FND_MSG_PUB.Count_And_Get(
125: p_encoded => FND_API.G_FALSE,
126: p_count => x_msg_count,
127: p_data => x_msg_data);
128:
129: WHEN OTHERS THEN

Line 143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

139:
140: ROLLBACK TO load_finnumbers_pvt;
141: FND_FILE.put_line(fnd_file.log,'Unexpected other errors occurs while loading financial numbers');
142: FND_FILE.put_line(fnd_file.log, SQLERRM);
143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
144: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
145: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
146: FND_MSG_PUB.ADD;
147: FND_MSG_PUB.Count_And_Get(

Line 148: p_encoded => FND_API.G_FALSE,

144: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
145: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
146: FND_MSG_PUB.ADD;
147: FND_MSG_PUB.Count_And_Get(
148: p_encoded => FND_API.G_FALSE,
149: p_count => x_msg_count,
150: p_data => x_msg_data);
151:
152: END load_finnumbers;

Line 392: x_return_status := FND_API.G_RET_STS_SUCCESS;

388: p_prefix=>l_debug_prefix,
389: p_msg_level=>fnd_log.level_procedure);
390: END IF;
391: savepoint process_insert_finnumbers_pvt;
392: x_return_status := FND_API.G_RET_STS_SUCCESS;
393:
394: if(P_DML_RECORD.RERUN='N') then
395: l_final_qry := l_sql_query || l_first_run_clause;
396: else

Line 436: x_return_status := FND_API.G_RET_STS_ERROR;

432: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Insert finnumbers dup val exception: ' || SQLERRM);
433: ROLLBACK to process_insert_finnumbers_pvt;
434:
435: populate_error_table(P_DML_RECORD, 'Y');
436: x_return_status := FND_API.G_RET_STS_ERROR;
437:
438: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
439: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
440: FND_MSG_PUB.ADD;

Line 447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

443: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Insert finnumbers other exception: ' || SQLERRM);
444: ROLLBACK to process_insert_finnumbers_pvt;
445:
446: populate_error_table(P_DML_RECORD, 'N');
447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
448:
449: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
450: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
451: FND_MSG_PUB.ADD;

Line 548: x_return_status := FND_API.G_RET_STS_SUCCESS;

544: END IF;
545: savepoint process_update_finnumbers_pvt;
546: FND_MSG_PUB.initialize;
547: --Initialize API return status to success.
548: x_return_status := FND_API.G_RET_STS_SUCCESS;
549:
550: open_update_cursor(c_update_cursor, P_DML_RECORD);
551: fetch c_update_cursor bulk collect into
552: l_row_id,

Line 604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

600: ----dbms_output.put_line('Update finnumbers other exception: ' || SQLERRM);
601: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Update finnumbers other exception: ' || SQLERRM);
602:
603: ROLLBACK to process_update_finnumbers_pvt;
604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
605:
606: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
607: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
608: FND_MSG_PUB.ADD;