17: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
18: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
19:
20:
21: G_TRUE CONSTANT VARCHAR2(1) := 'T'; -- FND_API.G_TRUE;
22: G_FALSE CONSTANT VARCHAR2(1) := 'F'; -- FND_API.G_FALSE;
23:
24: --===========================================================
25: -- Declaration of Private Procedures and functions
18: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
19:
20:
21: G_TRUE CONSTANT VARCHAR2(1) := 'T'; -- FND_API.G_TRUE;
22: G_FALSE CONSTANT VARCHAR2(1) := 'F'; -- FND_API.G_FALSE;
23:
24: --===========================================================
25: -- Declaration of Private Procedures and functions
26: --===========================================================
159:
160:
161: BEGIN
162:
163: x_return_status := FND_API.G_RET_STS_SUCCESS;
164:
165: OPEN c_check_ext_row;
166: FETCH c_check_ext_row into l_count;
167: CLOSE c_check_ext_row;
178:
179: WHEN OTHERS THEN
180:
181:
182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
183: RETURN l_exists_flag;
184:
185: END IS_ROW_VALID;
186:
207:
208:
209: BEGIN
210:
211: x_return_status := FND_API.G_RET_STS_SUCCESS;
212:
213: OPEN c_is_multi_row;
214: FETCH c_is_multi_row INTO l_multi_row_code;
215: CLOSE c_is_multi_row;
219:
220: EXCEPTION
221:
222: WHEN OTHERS THEN
223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
224: RETURN l_multi_row_code;
225:
226: END IS_ATTR_GROUP_MULTI_ROW;
227:
255: -- -----------------------------------------------------------------------------
256:
257: PROCEDURE Process_SR_Ext_Attrs(
258: p_api_version IN NUMBER
259: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
260: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
261: ,p_incident_id IN NUMBER
262: ,p_ext_attr_grp_tbl IN CS_ServiceRequest_PUB.EXT_ATTR_GRP_TBL_TYPE
263: ,p_ext_attr_tbl IN CS_ServiceRequest_PUB.EXT_ATTR_TBL_TYPE
256:
257: PROCEDURE Process_SR_Ext_Attrs(
258: p_api_version IN NUMBER
259: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
260: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
261: ,p_incident_id IN NUMBER
262: ,p_ext_attr_grp_tbl IN CS_ServiceRequest_PUB.EXT_ATTR_GRP_TBL_TYPE
263: ,p_ext_attr_tbl IN CS_ServiceRequest_PUB.EXT_ATTR_TBL_TYPE
264: ,p_modified_by IN NUMBER := FND_GLOBAL.USER_ID
361: --Standard start of API savepoint
362: SAVEPOINT CS_EXTENSIBILITY_PVT;
363:
364: -- Standard call to check for call compatibility.
365: IF NOT FND_API.Compatible_API_Call (l_api_version,
366: p_api_version,
367: l_api_name,
368: G_PKG_NAME) THEN
369: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
365: IF NOT FND_API.Compatible_API_Call (l_api_version,
366: p_api_version,
367: l_api_name,
368: G_PKG_NAME) THEN
369: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
370: END IF;
371:
372: -- Initialize message list if p_init_msg_list is set to TRUE.
373: IF FND_API.to_Boolean(p_init_msg_list) THEN
369: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
370: END IF;
371:
372: -- Initialize message list if p_init_msg_list is set to TRUE.
373: IF FND_API.to_Boolean(p_init_msg_list) THEN
374: FND_MSG_PUB.initialize;
375: END IF;
376:
377: -- Initialize API return status to SUCCESS
374: FND_MSG_PUB.initialize;
375: END IF;
376:
377: -- Initialize API return status to SUCCESS
378: x_return_status := FND_API.G_RET_STS_SUCCESS;
379:
380: --DBMS_OUTPUT.PUT_LINE('In Process_User_Ext_Attrs');
381: --DBMS_OUTPUT.PUT_LINE('p_ext_attr_grp_tbl.COUNT'||p_ext_attr_grp_tbl.COUNT);
382:
465: , x_errorcode => x_errorcode
466: , x_msg_count => x_msg_count
467: , x_msg_data => x_msg_data
468: );
469: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
470: FND_MESSAGE.Set_Name('CS', 'CS_API_PROC_SR_EXT_ATTR_WARN');
471: FND_MSG_PUB.Add;
472: RAISE FND_API.G_EXC_ERROR;
473: END IF;
468: );
469: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
470: FND_MESSAGE.Set_Name('CS', 'CS_API_PROC_SR_EXT_ATTR_WARN');
471: FND_MSG_PUB.Add;
472: RAISE FND_API.G_EXC_ERROR;
473: END IF;
474:
475: -- Added FND_LOG
476: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
504: ,p_entity_id => NULL
505: ,p_entity_index => NULL
506: ,p_entity_code => NULL
507: ,p_debug_level => 0
508: ,p_init_error_handler => FND_API.G_TRUE
509: ,p_write_to_concurrent_log => FND_API.G_TRUE
510: ,p_init_fnd_msg_list => FND_API.G_FALSE
511: ,p_log_errors => FND_API.G_TRUE
512: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE
505: ,p_entity_index => NULL
506: ,p_entity_code => NULL
507: ,p_debug_level => 0
508: ,p_init_error_handler => FND_API.G_TRUE
509: ,p_write_to_concurrent_log => FND_API.G_TRUE
510: ,p_init_fnd_msg_list => FND_API.G_FALSE
511: ,p_log_errors => FND_API.G_TRUE
512: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE
513: ,p_commit => FND_API.G_FALSE
506: ,p_entity_code => NULL
507: ,p_debug_level => 0
508: ,p_init_error_handler => FND_API.G_TRUE
509: ,p_write_to_concurrent_log => FND_API.G_TRUE
510: ,p_init_fnd_msg_list => FND_API.G_FALSE
511: ,p_log_errors => FND_API.G_TRUE
512: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE
513: ,p_commit => FND_API.G_FALSE
514: ,x_failed_row_id_list => x_failed_row_id_list
507: ,p_debug_level => 0
508: ,p_init_error_handler => FND_API.G_TRUE
509: ,p_write_to_concurrent_log => FND_API.G_TRUE
510: ,p_init_fnd_msg_list => FND_API.G_FALSE
511: ,p_log_errors => FND_API.G_TRUE
512: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE
513: ,p_commit => FND_API.G_FALSE
514: ,x_failed_row_id_list => x_failed_row_id_list
515: ,x_return_status => x_return_status
508: ,p_init_error_handler => FND_API.G_TRUE
509: ,p_write_to_concurrent_log => FND_API.G_TRUE
510: ,p_init_fnd_msg_list => FND_API.G_FALSE
511: ,p_log_errors => FND_API.G_TRUE
512: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE
513: ,p_commit => FND_API.G_FALSE
514: ,x_failed_row_id_list => x_failed_row_id_list
515: ,x_return_status => x_return_status
516: ,x_errorcode => x_errorcode
509: ,p_write_to_concurrent_log => FND_API.G_TRUE
510: ,p_init_fnd_msg_list => FND_API.G_FALSE
511: ,p_log_errors => FND_API.G_TRUE
512: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE
513: ,p_commit => FND_API.G_FALSE
514: ,x_failed_row_id_list => x_failed_row_id_list
515: ,x_return_status => x_return_status
516: ,x_errorcode => x_errorcode
517: ,x_msg_count => x_msg_count
518: ,x_msg_data => x_msg_data );
519:
520:
521:
522: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
523: FND_MESSAGE.Set_Name('CS', 'CS_API_PROC_SR_EXT_ATTR_WARN');
524: FND_MSG_PUB.Add;
525: RAISE FND_API.G_EXC_ERROR;
526: END IF;
521:
522: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
523: FND_MESSAGE.Set_Name('CS', 'CS_API_PROC_SR_EXT_ATTR_WARN');
524: FND_MSG_PUB.Add;
525: RAISE FND_API.G_EXC_ERROR;
526: END IF;
527:
528: --Added FND_LOG
529: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
549: IF l_rec_found = 'N' THEN
550: --raise error
551: FND_MESSAGE.Set_Name('CS', 'CS_API_POP_SR_EXT_ATTR_WARN');
552: FND_MSG_PUB.Add;
553: RAISE FND_API.G_EXC_ERROR;
554: END IF;
555: END LOOP;
556:
557: --Added FND_LOG
572: ,x_return_status => x_return_status
573: ,x_msg_count => x_msg_count
574: ,x_msg_data => x_msg_data);
575:
576: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
577: --raise error
578: FND_MESSAGE.Set_Name('CS', 'CS_API_POP_SR_EXT_ATTR_WARN');
579: FND_MSG_PUB.Add;
580: RAISE FND_API.G_EXC_ERROR;
576: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
577: --raise error
578: FND_MESSAGE.Set_Name('CS', 'CS_API_POP_SR_EXT_ATTR_WARN');
579: FND_MSG_PUB.Add;
580: RAISE FND_API.G_EXC_ERROR;
581: END IF;
582:
583: --Added FND_LOG
584: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level THEN
614: --raise error
615: CS_ServiceRequest_UTIL.Add_Missing_Param_Msg(
616: p_token_an => l_api_name_full
617: ,p_token_mp => 'PK_COLUMN_1');
618: RAISE FND_API.G_EXC_ERROR;
619:
620: ELSE
621: --pk_col_1 passed
622: --Validate the pk_column_1 that is coming in
628: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg(
629: p_token_an => l_api_name_full
630: ,p_token_v => p_ext_attr_grp_tbl(i).pk_column_1
631: ,p_token_p => 'PK_COLUMN_1');
632: RAISE FND_API.G_EXC_ERROR;
633: END IF;
634:
635: IF l_context IS NULL THEN
636: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg(
636: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg(
637: p_token_an => l_api_name_full
638: ,p_token_v => p_ext_attr_grp_tbl(i).context
639: ,p_token_p => 'CONTEXT');
640: RAISE FND_API.G_EXC_ERROR;
641:
642: END IF;
643:
644: --DBMS_OUTPUT.PUT_LINE ('Pass pk1 validation');
675: --raise error
676: CS_ServiceRequest_UTIL.Add_Missing_Param_Msg(
677: p_token_an => l_api_name_full
678: ,p_token_mp => 'CONTEXT');
679: RAISE FND_API.G_EXC_ERROR;
680:
681: ELSE
682: --context is passed
683: --Check the context for the validated incident.
689: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg(
690: p_token_an => l_api_name_full
691: ,p_token_v => p_ext_attr_grp_tbl(i).context
692: ,p_token_p => 'CONTEXT');
693: RAISE FND_API.G_EXC_ERROR;
694:
695: ELSE
696: --DBMS_OUTPUT.PUT_LINE('In else of context validation');
697: --context matches
784: -- Raise Error
785: CS_ServiceRequest_UTIL.Add_Missing_Param_Msg(
786: p_token_an => l_api_name_full
787: ,p_token_mp => 'ATTR_GROUP_ID');
788: RAISE FND_API.G_EXC_ERROR;
789:
790: END IF;
791:
792: -- populate the new audit record for attr_group_id.
1032: -- Raise Error
1033: CS_ServiceRequest_UTIL.Add_Missing_Param_Msg(
1034: p_token_an => l_api_name_full
1035: ,p_token_mp => 'ATTR_GROUP_ID');
1036: RAISE FND_API.G_EXC_ERROR;
1037:
1038: END IF;
1039:
1040: ELSIF p_ext_attr_grp_tbl(i).operation = 'DELETE' THEN
1043: IF p_ext_attr_grp_tbl(i).attr_group_id IS NULL THEN
1044: CS_ServiceRequest_UTIL.Add_Missing_Param_Msg(
1045: p_token_an => l_api_name_full
1046: ,p_token_mp => 'ATTR_GROUP_ID');
1047: RAISE FND_API.G_EXC_ERROR;
1048:
1049: END IF;
1050: -- 5230517_eof
1051:
1057: ,x_msg_count => l_msg_count
1058: ,x_return_status => l_return_status);
1059:
1060: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1061: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1062: ELSIF l_return_status = G_RET_STS_ERROR THEN
1063: RAISE FND_API.G_EXC_ERROR;
1064: END IF;
1065:
1059:
1060: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1061: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1062: ELSIF l_return_status = G_RET_STS_ERROR THEN
1063: RAISE FND_API.G_EXC_ERROR;
1064: END IF;
1065:
1066: IF l_valid_check = 'Y' THEN
1067: -- l_user_attr_row_table(l_user_attr_row_table.LAST) := EGO_USER_ATTR_ROW_OBJ(p_ext_attr_grp_tbl(i).row_identifier,p_ext_attr_grp_tbl(i).attr_group_id,
1072: -- 5230517: do not think UI needs this. Should let PLM throw exceptions.
1073: /*
1074: ELSE
1075: --This has been added for the UI
1076: x_return_status := FND_API.G_RET_STS_SUCCESS;
1077: RETURN;
1078: */
1079: END IF;
1080: END IF;
1172: , x_errorcode => x_errorcode
1173: , x_msg_count => x_msg_count
1174: , x_msg_data => x_msg_data
1175: );
1176: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1177: FND_MESSAGE.Set_Name('CS', 'CS_API_PROC_SR_EXT_ATTR_WARN');
1178: FND_MSG_PUB.Add;
1179: RAISE FND_API.G_EXC_ERROR;
1180: END IF;
1175: );
1176: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1177: FND_MESSAGE.Set_Name('CS', 'CS_API_PROC_SR_EXT_ATTR_WARN');
1178: FND_MSG_PUB.Add;
1179: RAISE FND_API.G_EXC_ERROR;
1180: END IF;
1181: END IF; -- l_cont_chg_on_update = 'Y'
1182: --on last record
1183: --DBMS_OUTPUT.PUT_LINE('count of l_user_attr_row_table'||l_user_attr_row_table.COUNT);
1196: ,p_entity_id => NULL
1197: ,p_entity_index => NULL
1198: ,p_entity_code => NULL
1199: ,p_debug_level => 0
1200: ,p_init_error_handler => FND_API.G_TRUE
1201: ,p_write_to_concurrent_log => FND_API.G_TRUE
1202: ,p_init_fnd_msg_list => FND_API.G_FALSE
1203: ,p_log_errors => FND_API.G_TRUE
1204: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE
1197: ,p_entity_index => NULL
1198: ,p_entity_code => NULL
1199: ,p_debug_level => 0
1200: ,p_init_error_handler => FND_API.G_TRUE
1201: ,p_write_to_concurrent_log => FND_API.G_TRUE
1202: ,p_init_fnd_msg_list => FND_API.G_FALSE
1203: ,p_log_errors => FND_API.G_TRUE
1204: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE
1205: ,p_commit => FND_API.G_FALSE
1198: ,p_entity_code => NULL
1199: ,p_debug_level => 0
1200: ,p_init_error_handler => FND_API.G_TRUE
1201: ,p_write_to_concurrent_log => FND_API.G_TRUE
1202: ,p_init_fnd_msg_list => FND_API.G_FALSE
1203: ,p_log_errors => FND_API.G_TRUE
1204: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE
1205: ,p_commit => FND_API.G_FALSE
1206: ,x_failed_row_id_list => x_failed_row_id_list
1199: ,p_debug_level => 0
1200: ,p_init_error_handler => FND_API.G_TRUE
1201: ,p_write_to_concurrent_log => FND_API.G_TRUE
1202: ,p_init_fnd_msg_list => FND_API.G_FALSE
1203: ,p_log_errors => FND_API.G_TRUE
1204: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE
1205: ,p_commit => FND_API.G_FALSE
1206: ,x_failed_row_id_list => x_failed_row_id_list
1207: ,x_return_status => x_return_status
1200: ,p_init_error_handler => FND_API.G_TRUE
1201: ,p_write_to_concurrent_log => FND_API.G_TRUE
1202: ,p_init_fnd_msg_list => FND_API.G_FALSE
1203: ,p_log_errors => FND_API.G_TRUE
1204: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE
1205: ,p_commit => FND_API.G_FALSE
1206: ,x_failed_row_id_list => x_failed_row_id_list
1207: ,x_return_status => x_return_status
1208: ,x_errorcode => x_errorcode
1201: ,p_write_to_concurrent_log => FND_API.G_TRUE
1202: ,p_init_fnd_msg_list => FND_API.G_FALSE
1203: ,p_log_errors => FND_API.G_TRUE
1204: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE
1205: ,p_commit => FND_API.G_FALSE
1206: ,x_failed_row_id_list => x_failed_row_id_list
1207: ,x_return_status => x_return_status
1208: ,x_errorcode => x_errorcode
1209: ,x_msg_count => x_msg_count
1212: --DBMS_OUTPUT.PUT_LINE('x_return_status'||x_return_status);
1213: --DBMS_OUTPUT.PUT_LINE('x_failed_row_id_list'||x_failed_row_id_list);
1214: --DBMS_OUTPUT.PUT_LINE('x_msg_data'||x_msg_data);
1215:
1216: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1217: FND_MESSAGE.Set_Name('CS', 'CS_API_PROC_SR_EXT_ATTR_WARN');
1218: FND_MSG_PUB.Add;
1219: RAISE FND_API.G_EXC_ERROR;
1220: END IF;
1215:
1216: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1217: FND_MESSAGE.Set_Name('CS', 'CS_API_PROC_SR_EXT_ATTR_WARN');
1218: FND_MSG_PUB.Add;
1219: RAISE FND_API.G_EXC_ERROR;
1220: END IF;
1221:
1222: --DBMS_OUTPUT.PUT_LINE('Calling populate_sr_ext_attr_audit_rec'); --executed
1223:
1252: IF l_rec_found = 'N' THEN
1253: --raise error
1254: FND_MESSAGE.Set_Name('CS', 'CS_API_POP_SR_EXT_ATTR_WARN');
1255: FND_MSG_PUB.Add;
1256: RAISE FND_API.G_EXC_ERROR;
1257: END IF;
1258: END LOOP;
1259:
1260: --DBMS_OUTPUT.PUT_LINE('l_new_Ext_Attr_Audit_table'||l_new_Ext_Attr_Audit_table.COUNT);
1331: ,p_entity_id => NULL
1332: ,p_entity_index => NULL
1333: ,p_entity_code => NULL
1334: ,p_debug_level => 0
1335: ,p_init_error_handler => FND_API.G_TRUE
1336: ,p_write_to_concurrent_log => FND_API.G_TRUE
1337: ,p_init_fnd_msg_list => FND_API.G_FALSE
1338: ,p_log_errors => FND_API.G_TRUE
1339: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE
1332: ,p_entity_index => NULL
1333: ,p_entity_code => NULL
1334: ,p_debug_level => 0
1335: ,p_init_error_handler => FND_API.G_TRUE
1336: ,p_write_to_concurrent_log => FND_API.G_TRUE
1337: ,p_init_fnd_msg_list => FND_API.G_FALSE
1338: ,p_log_errors => FND_API.G_TRUE
1339: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE
1340: ,p_commit => FND_API.G_FALSE
1333: ,p_entity_code => NULL
1334: ,p_debug_level => 0
1335: ,p_init_error_handler => FND_API.G_TRUE
1336: ,p_write_to_concurrent_log => FND_API.G_TRUE
1337: ,p_init_fnd_msg_list => FND_API.G_FALSE
1338: ,p_log_errors => FND_API.G_TRUE
1339: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE
1340: ,p_commit => FND_API.G_FALSE
1341: ,x_failed_row_id_list => x_failed_row_id_list
1334: ,p_debug_level => 0
1335: ,p_init_error_handler => FND_API.G_TRUE
1336: ,p_write_to_concurrent_log => FND_API.G_TRUE
1337: ,p_init_fnd_msg_list => FND_API.G_FALSE
1338: ,p_log_errors => FND_API.G_TRUE
1339: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE
1340: ,p_commit => FND_API.G_FALSE
1341: ,x_failed_row_id_list => x_failed_row_id_list
1342: ,x_return_status => x_return_status
1335: ,p_init_error_handler => FND_API.G_TRUE
1336: ,p_write_to_concurrent_log => FND_API.G_TRUE
1337: ,p_init_fnd_msg_list => FND_API.G_FALSE
1338: ,p_log_errors => FND_API.G_TRUE
1339: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE
1340: ,p_commit => FND_API.G_FALSE
1341: ,x_failed_row_id_list => x_failed_row_id_list
1342: ,x_return_status => x_return_status
1343: ,x_errorcode => x_errorcode
1336: ,p_write_to_concurrent_log => FND_API.G_TRUE
1337: ,p_init_fnd_msg_list => FND_API.G_FALSE
1338: ,p_log_errors => FND_API.G_TRUE
1339: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE
1340: ,p_commit => FND_API.G_FALSE
1341: ,x_failed_row_id_list => x_failed_row_id_list
1342: ,x_return_status => x_return_status
1343: ,x_errorcode => x_errorcode
1344: ,x_msg_count => x_msg_count
1344: ,x_msg_count => x_msg_count
1345: ,x_msg_data => x_msg_data );
1346:
1347: *****************************************************/
1348: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1349: FND_MESSAGE.Set_Name('CS', 'CS_API_PROC_SR_EXT_ATTR_WARN');
1350: FND_MSG_PUB.Add;
1351: RAISE FND_API.G_EXC_ERROR;
1352: END IF;
1347: *****************************************************/
1348: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1349: FND_MESSAGE.Set_Name('CS', 'CS_API_PROC_SR_EXT_ATTR_WARN');
1350: FND_MSG_PUB.Add;
1351: RAISE FND_API.G_EXC_ERROR;
1352: END IF;
1353:
1354:
1355: --Clear the old audit record structure for the new context
1381: ,p_entity_id => NULL
1382: ,p_entity_index => NULL
1383: ,p_entity_code => NULL
1384: ,p_debug_level => 0
1385: ,p_init_error_handler => FND_API.G_TRUE
1386: ,p_write_to_concurrent_log => FND_API.G_TRUE
1387: ,p_init_fnd_msg_list => FND_API.G_FALSE
1388: ,p_log_errors => FND_API.G_TRUE
1389: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE
1382: ,p_entity_index => NULL
1383: ,p_entity_code => NULL
1384: ,p_debug_level => 0
1385: ,p_init_error_handler => FND_API.G_TRUE
1386: ,p_write_to_concurrent_log => FND_API.G_TRUE
1387: ,p_init_fnd_msg_list => FND_API.G_FALSE
1388: ,p_log_errors => FND_API.G_TRUE
1389: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE
1390: ,p_commit => FND_API.G_FALSE
1383: ,p_entity_code => NULL
1384: ,p_debug_level => 0
1385: ,p_init_error_handler => FND_API.G_TRUE
1386: ,p_write_to_concurrent_log => FND_API.G_TRUE
1387: ,p_init_fnd_msg_list => FND_API.G_FALSE
1388: ,p_log_errors => FND_API.G_TRUE
1389: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE
1390: ,p_commit => FND_API.G_FALSE
1391: ,x_failed_row_id_list => x_failed_row_id_list
1384: ,p_debug_level => 0
1385: ,p_init_error_handler => FND_API.G_TRUE
1386: ,p_write_to_concurrent_log => FND_API.G_TRUE
1387: ,p_init_fnd_msg_list => FND_API.G_FALSE
1388: ,p_log_errors => FND_API.G_TRUE
1389: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE
1390: ,p_commit => FND_API.G_FALSE
1391: ,x_failed_row_id_list => x_failed_row_id_list
1392: ,x_return_status => x_return_status
1385: ,p_init_error_handler => FND_API.G_TRUE
1386: ,p_write_to_concurrent_log => FND_API.G_TRUE
1387: ,p_init_fnd_msg_list => FND_API.G_FALSE
1388: ,p_log_errors => FND_API.G_TRUE
1389: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE
1390: ,p_commit => FND_API.G_FALSE
1391: ,x_failed_row_id_list => x_failed_row_id_list
1392: ,x_return_status => x_return_status
1393: ,x_errorcode => x_errorcode
1386: ,p_write_to_concurrent_log => FND_API.G_TRUE
1387: ,p_init_fnd_msg_list => FND_API.G_FALSE
1388: ,p_log_errors => FND_API.G_TRUE
1389: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE
1390: ,p_commit => FND_API.G_FALSE
1391: ,x_failed_row_id_list => x_failed_row_id_list
1392: ,x_return_status => x_return_status
1393: ,x_errorcode => x_errorcode
1394: ,x_msg_count => x_msg_count
1393: ,x_errorcode => x_errorcode
1394: ,x_msg_count => x_msg_count
1395: ,x_msg_data => x_msg_data );
1396:
1397: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1398: FND_MESSAGE.Set_Name('CS', 'CS_API_PROC_SR_EXT_ATTR_WARN');
1399: FND_MSG_PUB.Add;
1400: RAISE FND_API.G_EXC_ERROR;
1401: END IF;
1396:
1397: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1398: FND_MESSAGE.Set_Name('CS', 'CS_API_PROC_SR_EXT_ATTR_WARN');
1399: FND_MSG_PUB.Add;
1400: RAISE FND_API.G_EXC_ERROR;
1401: END IF;
1402:
1403: --reset the old_context to null;
1404: --NOT SURE IF THIS IS NEEDED
1423: IF l_rec_found = 'N' THEN
1424: --raise error
1425: FND_MESSAGE.Set_Name('CS', 'CS_API_POP_PR_EXT_ATTR_WARN');
1426: FND_MSG_PUB.Add;
1427: RAISE FND_API.G_EXC_ERROR;
1428: END IF;
1429: END LOOP;
1430:
1431: --call the create audit procedure
1467: --raise error
1468: CS_ServiceRequest_UTIL.Add_Missing_Param_Msg(
1469: p_token_an => l_api_name_full
1470: ,p_token_mp => 'PARTY_ROLE_COMPOSITE_KEY');
1471: RAISE FND_API.G_EXC_ERROR;
1472: ELSE
1473: --DBMS_OUTPUT.PUT_LINE('validating the primary key');
1474: --composite key passed
1475: --Validate the composite key that is coming in
1493: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg(
1494: p_token_an => l_api_name_full
1495: ,p_token_v => l_composite_key
1496: ,p_token_p => 'COMPOSITE_KEY');
1497: RAISE FND_API.G_EXC_ERROR;
1498:
1499: END IF;
1500:
1501: -- If no error then
1528: --raise error
1529: CS_ServiceRequest_UTIL.Add_Missing_Param_Msg(
1530: p_token_an => l_api_name_full
1531: ,p_token_mp => 'PARTY CONTEXT');
1532: RAISE FND_API.G_EXC_ERROR;
1533: ELSE
1534: --DBMS_OUTPUT.PUT_LINE('context passed');
1535: --context is passed
1536: --Check the context for the validated incident.
1539: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg(
1540: p_token_an => l_api_name_full
1541: ,p_token_v => p_ext_attr_grp_tbl(i).context
1542: ,p_token_p => 'PARTY CONTEXT');
1543: RAISE FND_API.G_EXC_ERROR;
1544: ELSE
1545:
1546: --DBMS_OUTPUT.PUT_LINE('context matches');
1547: --context matches
1617: --Attr Group Information is null
1618: CS_ServiceRequest_UTIL.Add_Missing_Param_Msg(
1619: p_token_an => l_api_name_full
1620: ,p_token_mp => 'ATTR_GROUP_ID');
1621: RAISE FND_API.G_EXC_ERROR;
1622: END IF;
1623:
1624: -- populate the new audit record for attr_group_id.
1625: l_new_Ext_Attr_Audit_table(l_new_audit_count).attr_group_id := l_attr_group_id;
1667: -- operation
1668: -- Raise error
1669: FND_MESSAGE.Set_Name('CS', 'CS_API_POP_PR_EXT_ATTR_WARN');
1670: FND_MSG_PUB.Add;
1671: RAISE FND_API.G_EXC_ERROR;
1672:
1673: ELSE
1674: --treat this record as a 'UPDATE'
1675: -- l_user_attr_row_table(l_user_attr_row_table.LAST) := EGO_USER_ATTR_ROW_OBJ(p_ext_attr_grp_tbl(i).row_identifier,p_ext_attr_grp_tbl(i).attr_group_id,
1718: -- operation
1719: -- Raise error
1720: FND_MESSAGE.Set_Name('CS', 'CS_API_POP_PR_EXT_ATTR_WARN');
1721: FND_MSG_PUB.Add;
1722: RAISE FND_API.G_EXC_ERROR;
1723:
1724: ELSE
1725: --treat this record as a 'UPDATE'
1726: -- l_user_attr_row_table(l_user_attr_row_table.LAST) := EGO_USER_ATTR_ROW_OBJ(p_ext_attr_grp_tbl(i).row_identifier,NULL,
1737: --Attr Group Information is null
1738: CS_ServiceRequest_UTIL.Add_Missing_Param_Msg(
1739: p_token_an => l_api_name_full
1740: ,p_token_mp => 'ATTR_GROUP_ID');
1741: RAISE FND_API.G_EXC_ERROR;
1742: END IF;
1743:
1744: -- populate the new audit record for attr_group_id.
1745: l_new_Ext_Attr_Audit_table(l_new_audit_count).attr_group_id := l_attr_group_id;
1753: IF p_ext_attr_grp_tbl(i).attr_group_id IS NULL THEN
1754: CS_ServiceRequest_UTIL.Add_Missing_Param_Msg(
1755: p_token_an => l_api_name_full
1756: ,p_token_mp => 'ATTR_GROUP_ID');
1757: RAISE FND_API.G_EXC_ERROR;
1758:
1759: END IF;
1760: -- 5230517_eof
1761:
1767: ,x_msg_count => l_msg_count
1768: ,x_return_status => l_return_status);
1769:
1770: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1771: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1772: ELSIF l_return_status = G_RET_STS_ERROR THEN
1773: RAISE FND_API.G_EXC_ERROR;
1774: END IF;
1775:
1769:
1770: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1771: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1772: ELSIF l_return_status = G_RET_STS_ERROR THEN
1773: RAISE FND_API.G_EXC_ERROR;
1774: END IF;
1775:
1776: IF l_valid_check = 'Y' THEN
1777: -- l_user_attr_row_table(l_user_attr_row_table.LAST) := EGO_USER_ATTR_ROW_OBJ(p_ext_attr_grp_tbl(i).row_identifier,p_ext_attr_grp_tbl(i).attr_group_id,
1781:
1782: -- 5230517 => should not eat the exception. Do nothing and let PLM throw exception.
1783: /*
1784: ELSE
1785: x_return_status := FND_API.G_RET_STS_SUCCESS;
1786: RETURN;
1787: */
1788:
1789: END IF;
1873: ,p_entity_id => NULL
1874: ,p_entity_index => NULL
1875: ,p_entity_code => NULL
1876: ,p_debug_level => 0
1877: ,p_init_error_handler => FND_API.G_TRUE
1878: ,p_write_to_concurrent_log => FND_API.G_TRUE
1879: ,p_init_fnd_msg_list => FND_API.G_FALSE
1880: ,p_log_errors => FND_API.G_TRUE
1881: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE
1874: ,p_entity_index => NULL
1875: ,p_entity_code => NULL
1876: ,p_debug_level => 0
1877: ,p_init_error_handler => FND_API.G_TRUE
1878: ,p_write_to_concurrent_log => FND_API.G_TRUE
1879: ,p_init_fnd_msg_list => FND_API.G_FALSE
1880: ,p_log_errors => FND_API.G_TRUE
1881: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE
1882: ,p_commit => FND_API.G_FALSE
1875: ,p_entity_code => NULL
1876: ,p_debug_level => 0
1877: ,p_init_error_handler => FND_API.G_TRUE
1878: ,p_write_to_concurrent_log => FND_API.G_TRUE
1879: ,p_init_fnd_msg_list => FND_API.G_FALSE
1880: ,p_log_errors => FND_API.G_TRUE
1881: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE
1882: ,p_commit => FND_API.G_FALSE
1883: ,x_failed_row_id_list => x_failed_row_id_list
1876: ,p_debug_level => 0
1877: ,p_init_error_handler => FND_API.G_TRUE
1878: ,p_write_to_concurrent_log => FND_API.G_TRUE
1879: ,p_init_fnd_msg_list => FND_API.G_FALSE
1880: ,p_log_errors => FND_API.G_TRUE
1881: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE
1882: ,p_commit => FND_API.G_FALSE
1883: ,x_failed_row_id_list => x_failed_row_id_list
1884: ,x_return_status => x_return_status
1877: ,p_init_error_handler => FND_API.G_TRUE
1878: ,p_write_to_concurrent_log => FND_API.G_TRUE
1879: ,p_init_fnd_msg_list => FND_API.G_FALSE
1880: ,p_log_errors => FND_API.G_TRUE
1881: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE
1882: ,p_commit => FND_API.G_FALSE
1883: ,x_failed_row_id_list => x_failed_row_id_list
1884: ,x_return_status => x_return_status
1885: ,x_errorcode => x_errorcode
1878: ,p_write_to_concurrent_log => FND_API.G_TRUE
1879: ,p_init_fnd_msg_list => FND_API.G_FALSE
1880: ,p_log_errors => FND_API.G_TRUE
1881: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE
1882: ,p_commit => FND_API.G_FALSE
1883: ,x_failed_row_id_list => x_failed_row_id_list
1884: ,x_return_status => x_return_status
1885: ,x_errorcode => x_errorcode
1886: ,x_msg_count => x_msg_count
1885: ,x_errorcode => x_errorcode
1886: ,x_msg_count => x_msg_count
1887: ,x_msg_data => x_msg_data );
1888:
1889: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1890: FND_MESSAGE.Set_Name('CS', 'CS_API_PROC_SR_EXT_ATTR_WARN');
1891: FND_MSG_PUB.Add;
1892: RAISE FND_API.G_EXC_ERROR;
1893: END IF;
1888:
1889: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1890: FND_MESSAGE.Set_Name('CS', 'CS_API_PROC_SR_EXT_ATTR_WARN');
1891: FND_MSG_PUB.Add;
1892: RAISE FND_API.G_EXC_ERROR;
1893: END IF;
1894:
1895:
1896: -- Fix bug 5230517
1912: IF l_rec_found = 'N' THEN
1913: --raise error
1914: FND_MESSAGE.Set_Name('CS', 'CS_API_POP_PR_EXT_ATTR_WARN');
1915: FND_MSG_PUB.Add;
1916: RAISE FND_API.G_EXC_ERROR;
1917: END IF;
1918: END LOOP;
1919:
1920: --DBMS_OUTPUT.PUT_LINE('populated PR');
1940: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg(
1941: p_token_an => l_api_name_full
1942: ,p_token_v => p_ext_attr_grp_tbl(i).object_name
1943: ,p_token_p => 'OBJECT_NAME');
1944: RAISE FND_API.G_EXC_ERROR;
1945: END IF; -- object name check eof
1946: END LOOP;
1947:
1948: ELSE
1950: --DBMS_OUTPUT.PUT_LINE('returning');
1951: RETURN;
1952:
1953: END IF;
1954: IF FND_API.To_Boolean(p_commit)
1955: THEN
1956: COMMIT WORK;
1957: END IF;
1958:
1957: END IF;
1958:
1959: EXCEPTION
1960:
1961: WHEN FND_API.G_EXC_ERROR THEN
1962: ROLLBACK TO CS_EXTENSIBILITY_PVT;
1963: x_return_status := FND_API.G_RET_STS_ERROR;
1964: FND_MSG_PUB.Count_And_Get
1965: ( p_count => x_msg_count,
1959: EXCEPTION
1960:
1961: WHEN FND_API.G_EXC_ERROR THEN
1962: ROLLBACK TO CS_EXTENSIBILITY_PVT;
1963: x_return_status := FND_API.G_RET_STS_ERROR;
1964: FND_MSG_PUB.Count_And_Get
1965: ( p_count => x_msg_count,
1966: p_data => x_msg_data
1967: );
1964: FND_MSG_PUB.Count_And_Get
1965: ( p_count => x_msg_count,
1966: p_data => x_msg_data
1967: );
1968: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1969: ROLLBACK TO CS_EXTENSIBILITY_PVT;
1970: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1971: FND_MSG_PUB.Count_And_Get
1972: ( p_count => x_msg_count,
1966: p_data => x_msg_data
1967: );
1968: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1969: ROLLBACK TO CS_EXTENSIBILITY_PVT;
1970: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1971: FND_MSG_PUB.Count_And_Get
1972: ( p_count => x_msg_count,
1973: p_data => x_msg_data
1974: );
1973: p_data => x_msg_data
1974: );
1975: WHEN OTHERS THEN
1976: ROLLBACK TO CS_EXTENSIBILITY_PVT;
1977: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1978: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1979: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1980: END IF;
1981: FND_MSG_PUB.Count_And_Get
3903:
3904:
3905: PROCEDURE Get_SR_Ext_Attrs
3906: (p_api_version IN NUMBER
3907: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3908: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3909: ,p_incident_id IN NUMBER
3910: ,p_object_name IN VARCHAR2
3911: ,x_ext_attr_grp_tbl OUT NOCOPY CS_ServiceRequest_PUB.EXT_ATTR_GRP_TBL_TYPE
3904:
3905: PROCEDURE Get_SR_Ext_Attrs
3906: (p_api_version IN NUMBER
3907: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3908: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3909: ,p_incident_id IN NUMBER
3910: ,p_object_name IN VARCHAR2
3911: ,x_ext_attr_grp_tbl OUT NOCOPY CS_ServiceRequest_PUB.EXT_ATTR_GRP_TBL_TYPE
3912: ,x_ext_attr_tbl OUT NOCOPY CS_ServiceRequest_PUB.EXT_ATTR_TBL_TYPE
4022:
4023: --DBMS_OUTPUT.PUT_LINE('In Get_SR API');
4024:
4025: -- Standard call to check for call compatibility.
4026: IF NOT FND_API.Compatible_API_Call (l_api_version,
4027: p_api_version,
4028: l_api_name,
4029: G_PKG_NAME) THEN
4030: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4026: IF NOT FND_API.Compatible_API_Call (l_api_version,
4027: p_api_version,
4028: l_api_name,
4029: G_PKG_NAME) THEN
4030: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4031: END IF;
4032:
4033: -- Initialize message list if p_init_msg_list is set to TRUE.
4034: IF FND_API.to_Boolean(p_init_msg_list) THEN
4030: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4031: END IF;
4032:
4033: -- Initialize message list if p_init_msg_list is set to TRUE.
4034: IF FND_API.to_Boolean(p_init_msg_list) THEN
4035: FND_MSG_PUB.initialize;
4036: END IF;
4037:
4038: -- Initialize API return status to SUCCESS
4035: FND_MSG_PUB.initialize;
4036: END IF;
4037:
4038: -- Initialize API return status to SUCCESS
4039: x_return_status := FND_API.G_RET_STS_SUCCESS;
4040:
4041: ---------------------- FND Logging -----------------------------------
4042: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
4043: THEN
4089: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg(
4090: p_token_an => l_api_name_full
4091: ,p_token_v => p_incident_id
4092: ,p_token_p => 'P_INCIDENT_ID');
4093: RAISE FND_API.G_EXC_ERROR;
4094: END IF;
4095:
4096: --DBMS_OUTPUT.PUT_LINE ('Pass pk1 validation');
4097:
4099: --raise error
4100: CS_ServiceRequest_UTIL.Add_Missing_Param_Msg(
4101: p_token_an => l_api_name_full
4102: ,p_token_mp => 'P_INCIDENT_ID');
4103: RAISE FND_API.G_EXC_ERROR;
4104:
4105: END IF;
4106:
4107: -- Added FND_LOG
4233: --composite key missing
4234: FND_MESSAGE.SET_NAME('CS', 'CS_API_SR_EXTATTR_COMP_KEY_REQ');
4235: FND_MESSAGE.SET_TOKEN('API_NAME', l_api_name);
4236: FND_MSG_PUB.ADD;
4237: RAISE FND_API.G_EXC_ERROR;
4238: END IF; -- composite key end if
4239:
4240:
4241: --populate the attribute group request table to pass to PLM
4259: --raise error
4260: FND_MESSAGE.SET_NAME('CS', 'CS_API_SR_EXT_ATTR_GROUP_REQ');
4261: FND_MESSAGE.SET_TOKEN('API_NAME', l_api_name);
4262: FND_MSG_PUB.ADD;
4263: RAISE FND_API.G_EXC_ERROR;
4264: END IF; --v_get_sr_ext_attr.attr_group_id IS NOT NULL
4265:
4266: END LOOP;
4267:
4336: );
4337: END IF;
4338:
4339:
4340: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4341: FND_MESSAGE.Set_Name('CS', 'CS_API_GET_SR_EXT_ATTR_WARNING');
4342: FND_MSG_PUB.Add;
4343: RAISE FND_API.G_EXC_ERROR;
4344: END IF;
4339:
4340: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4341: FND_MESSAGE.Set_Name('CS', 'CS_API_GET_SR_EXT_ATTR_WARNING');
4342: FND_MSG_PUB.Add;
4343: RAISE FND_API.G_EXC_ERROR;
4344: END IF;
4345:
4346: --populate the out parameters with the value returned from PLM
4347: --initialize counter := 0
4565: -- MAYA need to add
4566: FND_MESSAGE.SET_NAME('CS', 'CS_API_SR_EXTATTR_COMP_KEY_REQ');
4567: FND_MESSAGE.SET_TOKEN('API_NAME', l_api_name);
4568: FND_MSG_PUB.ADD;
4569: RAISE FND_API.G_EXC_ERROR;
4570: END IF; -- composite key end if
4571:
4572:
4573: --populate the attribute group request table to pass to PLM
4589: --raise error
4590: FND_MESSAGE.SET_NAME('CS', 'CS_API_SR_EXT_ATTR_GROUP_REQ');
4591: FND_MESSAGE.SET_TOKEN('API_NAME', l_api_name);
4592: FND_MSG_PUB.ADD;
4593: RAISE FND_API.G_EXC_ERROR;
4594:
4595: END IF; --v_get_pr_ext_attr.attr_group_id IS NOT NULL
4596:
4597: END LOOP;
4656: || x_msg_data
4657: );
4658: END IF;
4659:
4660: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4661: FND_MESSAGE.Set_Name('CS', 'CS_API_GET_SR_EXT_ATTR_WARNING');
4662: FND_MSG_PUB.Add;
4663: RAISE FND_API.G_EXC_ERROR;
4664: END IF;
4659:
4660: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4661: FND_MESSAGE.Set_Name('CS', 'CS_API_GET_SR_EXT_ATTR_WARNING');
4662: FND_MSG_PUB.Add;
4663: RAISE FND_API.G_EXC_ERROR;
4664: END IF;
4665:
4666: --populate the out parameters with the value returned from PLM
4667: --initialize counter := 0
4787:
4788: END IF;
4789:
4790: EXCEPTION
4791: WHEN FND_API.G_EXC_ERROR THEN
4792: x_return_status := FND_API.G_RET_STS_ERROR;
4793: FND_MSG_PUB.Count_And_Get
4794: ( p_count => x_msg_count,
4795: p_data => x_msg_data
4788: END IF;
4789:
4790: EXCEPTION
4791: WHEN FND_API.G_EXC_ERROR THEN
4792: x_return_status := FND_API.G_RET_STS_ERROR;
4793: FND_MSG_PUB.Count_And_Get
4794: ( p_count => x_msg_count,
4795: p_data => x_msg_data
4796: );
4793: FND_MSG_PUB.Count_And_Get
4794: ( p_count => x_msg_count,
4795: p_data => x_msg_data
4796: );
4797: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4799: FND_MSG_PUB.Count_And_Get
4800: ( p_count => x_msg_count,
4801: p_data => x_msg_data
4794: ( p_count => x_msg_count,
4795: p_data => x_msg_data
4796: );
4797: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4799: FND_MSG_PUB.Count_And_Get
4800: ( p_count => x_msg_count,
4801: p_data => x_msg_data
4802: );
4801: p_data => x_msg_data
4802: );
4803:
4804: WHEN OTHERS THEN
4805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4806: FND_MESSAGE.Set_Name('CS', 'CS_GET_SR_EXT_ATTR_FAIL');
4807: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
4808: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
4809: FND_MSG_PUB.ADD;
5130: END LOOP;
5131: END LOOP;
5132: EXCEPTION
5133: WHEN OTHERS THEN
5134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5135: FND_MSG_PUB.Count_And_Get
5136: (p_count => x_msg_count,
5137: p_data => x_msg_data);
5138:
5183: l_api_name CONSTANT VARCHAR2(30) := 'insert_sr_row';
5184: l_api_name_full CONSTANT VARCHAR2(61) := 'CS_SR_EXTATTRIBUTES_PVT'||'.'||l_api_name;
5185: l_incident_id number;
5186: BEGIN
5187: x_return_status := FND_API.G_RET_STS_SUCCESS;
5188: l_last_updated_by := FND_GLOBAL.USER_ID;
5189: l_last_update_date := SYSDATE;
5190: l_last_update_login := FND_GLOBAL.LOGIN_ID;
5191:
5770: --DBMS_OUTPUT.PUT_LINE(substr(SQLERRM,1,200));
5771: FND_MESSAGE.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
5772: FND_MESSAGE.set_token('P_TEXT','cs_sr_ext_attr_data_pvt.insert_sr_row'||'-'||substr(SQLERRM,1,200));
5773: FND_MSG_PUB.ADD;
5774: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5775:
5776: END insert_sr_row;
5777:
5778:
5818: l_api_name CONSTANT VARCHAR2(30) := 'insert_pr_row';
5819: l_api_name_full CONSTANT VARCHAR2(61) := 'CS_SR_EXTATTRIBUTES_PVT'||'.'||l_api_name;
5820: l_incident_id number;
5821: BEGIN
5822: x_return_status := FND_API.G_RET_STS_SUCCESS;
5823:
5824:
5825: l_last_updated_by := FND_GLOBAL.USER_ID;
5826: l_last_update_login := FND_GLOBAL.LOGIN_ID;
6402:
6403:
6404: EXCEPTION
6405: WHEN OTHERS THEN
6406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6407: FND_MESSAGE.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
6408: FND_MESSAGE.set_token('P_TEXT','cs_sr_ext_attr_data_pvt.insert_sr_row'||'-'||substr(SQLERRM,1,200));
6409: FND_MSG_PUB.ADD;
6410: FND_MSG_PUB.Count_And_Get
6883: , p_entity_id => NULL
6884: , p_entity_index => NULL
6885: , p_entity_code => NULL
6886: , p_debug_level => 3
6887: , p_init_error_handler => FND_API.G_TRUE
6888: , p_write_to_concurrent_log => FND_API.G_TRUE
6889: , p_init_fnd_msg_list => FND_API.G_FALSE
6890: , p_log_errors => FND_API.G_TRUE
6891: , p_add_errors_to_fnd_stack => FND_API.G_TRUE
6884: , p_entity_index => NULL
6885: , p_entity_code => NULL
6886: , p_debug_level => 3
6887: , p_init_error_handler => FND_API.G_TRUE
6888: , p_write_to_concurrent_log => FND_API.G_TRUE
6889: , p_init_fnd_msg_list => FND_API.G_FALSE
6890: , p_log_errors => FND_API.G_TRUE
6891: , p_add_errors_to_fnd_stack => FND_API.G_TRUE
6892: , p_commit => FND_API.G_FALSE
6885: , p_entity_code => NULL
6886: , p_debug_level => 3
6887: , p_init_error_handler => FND_API.G_TRUE
6888: , p_write_to_concurrent_log => FND_API.G_TRUE
6889: , p_init_fnd_msg_list => FND_API.G_FALSE
6890: , p_log_errors => FND_API.G_TRUE
6891: , p_add_errors_to_fnd_stack => FND_API.G_TRUE
6892: , p_commit => FND_API.G_FALSE
6893: , x_failed_row_id_list => x_failed_row_id_list
6886: , p_debug_level => 3
6887: , p_init_error_handler => FND_API.G_TRUE
6888: , p_write_to_concurrent_log => FND_API.G_TRUE
6889: , p_init_fnd_msg_list => FND_API.G_FALSE
6890: , p_log_errors => FND_API.G_TRUE
6891: , p_add_errors_to_fnd_stack => FND_API.G_TRUE
6892: , p_commit => FND_API.G_FALSE
6893: , x_failed_row_id_list => x_failed_row_id_list
6894: , x_return_status => x_return_status
6887: , p_init_error_handler => FND_API.G_TRUE
6888: , p_write_to_concurrent_log => FND_API.G_TRUE
6889: , p_init_fnd_msg_list => FND_API.G_FALSE
6890: , p_log_errors => FND_API.G_TRUE
6891: , p_add_errors_to_fnd_stack => FND_API.G_TRUE
6892: , p_commit => FND_API.G_FALSE
6893: , x_failed_row_id_list => x_failed_row_id_list
6894: , x_return_status => x_return_status
6895: , x_errorcode => x_errorcode
6888: , p_write_to_concurrent_log => FND_API.G_TRUE
6889: , p_init_fnd_msg_list => FND_API.G_FALSE
6890: , p_log_errors => FND_API.G_TRUE
6891: , p_add_errors_to_fnd_stack => FND_API.G_TRUE
6892: , p_commit => FND_API.G_FALSE
6893: , x_failed_row_id_list => x_failed_row_id_list
6894: , x_return_status => x_return_status
6895: , x_errorcode => x_errorcode
6896: , x_msg_count => x_msg_count
6899:
6900: --
6901: EXCEPTION
6902: WHEN OTHERS THEN
6903: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6904: END;
6905:
6906:
6907:
6935:
6936: i NUMBER := 0 ;
6937:
6938: BEGIN
6939: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
6940:
6941: -- Get all the ext attrs records for passed extension_id
6942:
6943: FOR c_get_ext_attrs_rec IN c_get_ext_attrs
7089: p_token_p => 'P_EXTENSION_ID' ,
7090: p_table_name => 'CS_SR_CONTACTX_EXT',
7091: p_column_name => 'EXTENSION_ID');
7092:
7093: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7094:
7095: WHEN OTHERS THEN
7096: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7097:
7092:
7093: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7094:
7095: WHEN OTHERS THEN
7096: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7097:
7098: END Populate_Ext_Attr_Audit_Tbl;
7099:
7100: END CS_SR_EXTATTRIBUTES_PVT;