DBA Data[Home] [Help]

APPS.CSF_PREVENTIVE_MAINTENANCE_PVT dependencies on FND_MSG_PUB

Line 21: If fnd_msg_pub.count_msg > 0 Then

17: l_msg_index_out NUMBER;
18: x_msg_data_temp Varchar2(2000);
19: x_msg_data Varchar2(4000);
20: Begin
21: If fnd_msg_pub.count_msg > 0 Then
22: FOR i IN REVERSE 1..fnd_msg_pub.count_msg Loop
23: fnd_msg_pub.get(p_msg_index => i,
24: p_encoded => 'F',
25: p_data => x_msg_data_temp,

Line 22: FOR i IN REVERSE 1..fnd_msg_pub.count_msg Loop

18: x_msg_data_temp Varchar2(2000);
19: x_msg_data Varchar2(4000);
20: Begin
21: If fnd_msg_pub.count_msg > 0 Then
22: FOR i IN REVERSE 1..fnd_msg_pub.count_msg Loop
23: fnd_msg_pub.get(p_msg_index => i,
24: p_encoded => 'F',
25: p_data => x_msg_data_temp,
26: p_msg_index_out => l_msg_index_out);

Line 23: fnd_msg_pub.get(p_msg_index => i,

19: x_msg_data Varchar2(4000);
20: Begin
21: If fnd_msg_pub.count_msg > 0 Then
22: FOR i IN REVERSE 1..fnd_msg_pub.count_msg Loop
23: fnd_msg_pub.get(p_msg_index => i,
24: p_encoded => 'F',
25: p_data => x_msg_data_temp,
26: p_msg_index_out => l_msg_index_out);
27: x_msg_data := x_msg_data || x_msg_data_temp;

Line 30: fnd_msg_pub.delete_msg;

26: p_msg_index_out => l_msg_index_out);
27: x_msg_data := x_msg_data || x_msg_data_temp;
28: End Loop;
29: FND_FILE.put_line(FND_FILE.log,x_msg_data);
30: fnd_msg_pub.delete_msg;
31: g_retcode := 1;
32: End if;
33: End;
34:

Line 305: FND_MSG_PUB.initialize;

301: END IF;
302:
303:
304: -- Initialize message list
305: FND_MSG_PUB.initialize;
306:
307:
308: -- Initialize API return status to SUCCESS
309: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 535: fnd_msg_pub.add;

531: fnd_message.set_name('CSF','CSF_PM_SR_CREATION_ERROR');
532: fnd_message.set_token('VALUE1',l_ump_rec.unit_effectivity_id);
533: fnd_message.set_token('VALUE2',l_product_number);
534: fnd_message.set_token('VALUE3',l_serial_number);
535: fnd_msg_pub.add;
536: Add_Err_Msg;
537: ElsIf (nvl(x_individual_owner,0) <= 0 and nvl(x_group_owner,0) <= 0) Then
538: fnd_message.set_name('CSF','CSF_PM_SR_OWNER_ERROR');
539: fnd_message.set_token('VALUE1',l_ump_rec.unit_effectivity_id);

Line 544: fnd_msg_pub.add;

540: fnd_message.set_token('VALUE2',nvl(x_individual_owner,x_group_owner));
541: fnd_message.set_token('VALUE3',nvl(x_individual_type,'RS_GROUP'));
542: fnd_message.set_token('VALUE4',l_product_number);
543: fnd_message.set_token('VALUE5',l_serial_number);
544: fnd_msg_pub.add;
545: Add_Err_Msg;
546: Else
547:
548: /* rhungund: note

Line 579: fnd_msg_pub.add;

575:
576: If x_return_status <> FND_API.G_RET_STS_SUCCESS Then
577: fnd_message.set_name('CSF','CSF_PM_SR_UPDATE_ERROR');
578: fnd_message.set_token('VALUE1',x_request_id);
579: fnd_msg_pub.add;
580: Add_Err_Msg;
581: End If;
582:
583: END IF;

Line 625: fnd_msg_pub.add;

621: fnd_message.set_name('CSF','CSF_PM_SR_LINK_CREATION_ERROR');
622: fnd_message.set_token('VALUE1',l_ump_rec.unit_effectivity_id);
623: fnd_message.set_token('VALUE2',l_product_number);
624: fnd_message.set_token('VALUE3',l_serial_number);
625: fnd_msg_pub.add;
626: Add_Err_Msg;
627: End If;
628: End If;
629:

Line 684: fnd_msg_pub.add;

680: fnd_message.set_token('VALUE3',x_individual_owner);
681: fnd_message.set_token('VALUE4',x_individual_type);
682: fnd_message.set_token('VALUE5',l_product_number);
683: fnd_message.set_token('VALUE6',l_serial_number);
684: fnd_msg_pub.add;
685: Add_Err_Msg;
686: Else
687: task_created := TRUE;
688: If l_ump_rec.location_id is Null then

Line 693: fnd_msg_pub.add;

689: --If l_ump_rec.install_location_id is Null then fnd_message.set_name('CSF','CSF_PM_TASK_ADDRESS_MSG');
690: fnd_message.set_token('VALUE1',x_request_number);
691: fnd_message.set_token('VALUE2',l_product_number);
692: fnd_message.set_token('VALUE3',l_serial_number);
693: fnd_msg_pub.add;
694: Add_Err_Msg;
695: End If;
696: End If;
697: Else

Line 703: fnd_msg_pub.add;

699: fnd_message.set_token('VALUE1',l_ump_rec.unit_effectivity_id);
700: fnd_message.set_token('VALUE2',l_route_rec.route_id);
701: fnd_message.set_token('VALUE3',l_product_number);
702: fnd_message.set_token('VALUE4',l_serial_number);
703: fnd_msg_pub.add;
704: Add_Err_Msg;
705: End If;
706: End Loop;
707: Close c_route;

Line 762: fnd_msg_pub.add;

758: fnd_message.set_token('VALUE1',x_request_number);
759: fnd_message.set_token('VALUE2',conf_task_id(i));
760: fnd_message.set_token('VALUE3',l_product_number);
761: fnd_message.set_token('VALUE4',l_serial_number);
762: fnd_msg_pub.add;
763: Add_Err_Msg;
764: End If;
765:
766:

Line 888: fnd_msg_pub.add;

884: fnd_message.set_token('VALUE1',x_request_number);
885: fnd_message.set_token('VALUE2',conf_task_id(i));
886: fnd_message.set_token('VALUE3',l_product_number);
887: fnd_message.set_token('VALUE4',l_serial_number);
888: fnd_msg_pub.add;
889: Add_Err_Msg;
890: End If;
891:
892:

Line 929: FND_MSG_PUB.Count_And_Get

925: -- End of API body
926: --
927:
928: -- Standard call to get message count and if count is 1, get message info.
929: FND_MSG_PUB.Count_And_Get
930: ( p_count => x_msg_count,
931: p_data => x_msg_data
932: );
933: retcode := g_retcode;

Line 942: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

938: errbuf := X_Msg_Data;
939: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
940: P_API_NAME => L_API_NAME
941: ,P_PKG_NAME => G_PKG_NAME
942: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
943: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
944: ,X_MSG_COUNT => X_MSG_COUNT
945: ,X_MSG_DATA => X_MSG_DATA
946: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 954: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

950: errbuf := X_Msg_Data;
951: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
952: P_API_NAME => L_API_NAME
953: ,P_PKG_NAME => G_PKG_NAME
954: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
955: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
956: ,X_MSG_COUNT => X_MSG_COUNT
957: ,X_MSG_DATA => X_MSG_DATA
958: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1043: FND_MSG_PUB.initialize;

1039: END IF;
1040:
1041:
1042: -- Initialize message list if p_init_msg_list is set to TRUE.
1043: FND_MSG_PUB.initialize;
1044:
1045:
1046: -- Initialize API return status to SUCCESS
1047: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1092: FND_MSG_PUB.Count_and_Get(p_count => x_msg_count,p_data => x_msg_data);

1088: x_msg_data => x_msg_data);
1089: FND_FILE.put_line(FND_FILE.log, 'after calling
1090: ahl_ump_unitmaint_pub.capture_mr_updates x_return_status=' || x_return_status);
1091: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then
1092: FND_MSG_PUB.Count_and_Get(p_count => x_msg_count,p_data => x_msg_data);
1093: for i in 1..x_msg_count loop fnd_file.put_line (FND_FILE.log, SUBSTR(FND_MSG_PUB.GET(P_MSG_INDEX=> i, p_encoded => 'F'), 1, 254));
1094: end loop;
1095: End If;
1096:

Line 1093: for i in 1..x_msg_count loop fnd_file.put_line (FND_FILE.log, SUBSTR(FND_MSG_PUB.GET(P_MSG_INDEX=> i, p_encoded => 'F'), 1, 254));

1089: FND_FILE.put_line(FND_FILE.log, 'after calling
1090: ahl_ump_unitmaint_pub.capture_mr_updates x_return_status=' || x_return_status);
1091: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then
1092: FND_MSG_PUB.Count_and_Get(p_count => x_msg_count,p_data => x_msg_data);
1093: for i in 1..x_msg_count loop fnd_file.put_line (FND_FILE.log, SUBSTR(FND_MSG_PUB.GET(P_MSG_INDEX=> i, p_encoded => 'F'), 1, 254));
1094: end loop;
1095: End If;
1096:
1097: COMMIT WORK;

Line 1104: FND_MSG_PUB.Count_And_Get

1100: -- End of API body
1101: --
1102:
1103: -- Standard call to get message count and if count is 1, get message info.
1104: FND_MSG_PUB.Count_And_Get
1105: ( p_count => x_msg_count,
1106: p_data => x_msg_data
1107: );
1108: retcode := g_retcode;

Line 1117: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1113: errbuf := X_Msg_Data;
1114: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1115: P_API_NAME => L_API_NAME
1116: ,P_PKG_NAME => G_PKG_NAME
1117: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1118: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1119: ,X_MSG_COUNT => X_MSG_COUNT
1120: ,X_MSG_DATA => X_MSG_DATA
1121: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1128: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1124: errbuf := X_Msg_Data;
1125: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1126: P_API_NAME => L_API_NAME
1127: ,P_PKG_NAME => G_PKG_NAME
1128: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1129: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1130: ,X_MSG_COUNT => X_MSG_COUNT
1131: ,X_MSG_DATA => X_MSG_DATA
1132: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1215: FND_MSG_PUB.initialize;

1211: THEN
1212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1213: END IF;
1214:
1215: FND_MSG_PUB.initialize;
1216:
1217: -- Initialize API return status to SUCCESS
1218: x_return_status := FND_API.G_RET_STS_SUCCESS;
1219:

Line 1254: fnd_msg_pub.add;

1250: x_interaction_id => x_interaction_id);
1251: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then
1252: fnd_message.set_name('CSF','CSF_PM_SR_UPDATE_ERROR');
1253: fnd_message.set_token('VALUE1',incident_rec.subject_id);
1254: fnd_msg_pub.add;
1255: Add_Err_Msg;
1256: ROLLBACK TO update_sr_tasks_pvt;
1257: Else
1258: cs_incidentlinks_pub.DELETE_INCIDENTLINK (

Line 1274: fnd_msg_pub.add;

1270: X_MSG_DATA => x_msg_data);
1271: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then
1272: fnd_message.set_name('CSF','CSF_PM_SR_LINK_DELETE_ERROR');
1273: fnd_message.set_token('VALUE1',incident_rec.subject_id);
1274: fnd_msg_pub.add;
1275: Add_Err_Msg;
1276: ROLLBACK TO update_sr_tasks_pvt;
1277: Else
1278: sr_update_success := TRUE;

Line 1303: fnd_msg_pub.add;

1299: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then
1300: fnd_message.set_name('CSF','CSF_PM_TASK_UPDATE_ERROR');
1301: fnd_message.set_token('VALUE1',incident_rec.subject_id);
1302: fnd_message.set_token('VALUE2',incident_rec.task_id);
1303: fnd_msg_pub.add;
1304: Add_Err_Msg;
1305: ROLLBACK TO update_sr_tasks_pvt;
1306: End If;
1307: End if;

Line 1315: FND_MSG_PUB.Count_And_Get

1311: -- End of API body
1312: --
1313:
1314: -- Standard call to get message count and if count is 1, get message info.
1315: FND_MSG_PUB.Count_And_Get
1316: ( p_count => x_msg_count,
1317: p_data => x_msg_data
1318: );
1319: retcode := g_retcode;

Line 1327: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1323: errbuf := X_Msg_Data;
1324: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1325: P_API_NAME => L_API_NAME
1326: ,P_PKG_NAME => G_PKG_NAME
1327: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1328: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1329: ,X_MSG_COUNT => X_MSG_COUNT
1330: ,X_MSG_DATA => X_MSG_DATA
1331: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1338: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1334: errbuf := X_Msg_Data;
1335: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1336: P_API_NAME => L_API_NAME
1337: ,P_PKG_NAME => G_PKG_NAME
1338: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1339: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1340: ,X_MSG_COUNT => X_MSG_COUNT
1341: ,X_MSG_DATA => X_MSG_DATA
1342: ,X_RETURN_STATUS => X_RETURN_STATUS);