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 278: FND_MSG_PUB.initialize;

274: END IF;
275:
276:
277: -- Initialize message list
278: FND_MSG_PUB.initialize;
279:
280:
281: -- Initialize API return status to SUCCESS
282: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 499: fnd_msg_pub.add;

495: fnd_message.set_name('CSF','CSF_PM_SR_CREATION_ERROR');
496: fnd_message.set_token('VALUE1',l_ump_rec.unit_effectivity_id);
497: fnd_message.set_token('VALUE2',l_product_number);
498: fnd_message.set_token('VALUE3',l_serial_number);
499: fnd_msg_pub.add;
500: Add_Err_Msg;
501: ElsIf (nvl(x_individual_owner,0) <= 0 and nvl(x_group_owner,0) <= 0) Then
502: fnd_message.set_name('CSF','CSF_PM_SR_OWNER_ERROR');
503: fnd_message.set_token('VALUE1',l_ump_rec.unit_effectivity_id);

Line 508: fnd_msg_pub.add;

504: fnd_message.set_token('VALUE2',nvl(x_individual_owner,x_group_owner));
505: fnd_message.set_token('VALUE3',nvl(x_individual_type,'RS_GROUP'));
506: fnd_message.set_token('VALUE4',l_product_number);
507: fnd_message.set_token('VALUE5',l_serial_number);
508: fnd_msg_pub.add;
509: Add_Err_Msg;
510: Else
511:
512: /* rhungund: note

Line 543: fnd_msg_pub.add;

539:
540: If x_return_status <> FND_API.G_RET_STS_SUCCESS Then
541: fnd_message.set_name('CSF','CSF_PM_SR_UPDATE_ERROR');
542: fnd_message.set_token('VALUE1',x_request_id);
543: fnd_msg_pub.add;
544: Add_Err_Msg;
545: End If;
546:
547: END IF;

Line 588: fnd_msg_pub.add;

584: fnd_message.set_name('CSF','CSF_PM_SR_LINK_CREATION_ERROR');
585: fnd_message.set_token('VALUE1',l_ump_rec.unit_effectivity_id);
586: fnd_message.set_token('VALUE2',l_product_number);
587: fnd_message.set_token('VALUE3',l_serial_number);
588: fnd_msg_pub.add;
589: Add_Err_Msg;
590: End If;
591: End If;
592:

Line 647: fnd_msg_pub.add;

643: fnd_message.set_token('VALUE3',x_individual_owner);
644: fnd_message.set_token('VALUE4',x_individual_type);
645: fnd_message.set_token('VALUE5',l_product_number);
646: fnd_message.set_token('VALUE6',l_serial_number);
647: fnd_msg_pub.add;
648: Add_Err_Msg;
649: Else
650: task_created := TRUE;
651: If l_ump_rec.location_id is Null then

Line 656: fnd_msg_pub.add;

652: --If l_ump_rec.install_location_id is Null then fnd_message.set_name('CSF','CSF_PM_TASK_ADDRESS_MSG');
653: fnd_message.set_token('VALUE1',x_request_number);
654: fnd_message.set_token('VALUE2',l_product_number);
655: fnd_message.set_token('VALUE3',l_serial_number);
656: fnd_msg_pub.add;
657: Add_Err_Msg;
658: End If;
659: End If;
660: Else

Line 666: fnd_msg_pub.add;

662: fnd_message.set_token('VALUE1',l_ump_rec.unit_effectivity_id);
663: fnd_message.set_token('VALUE2',l_route_rec.route_id);
664: fnd_message.set_token('VALUE3',l_product_number);
665: fnd_message.set_token('VALUE4',l_serial_number);
666: fnd_msg_pub.add;
667: Add_Err_Msg;
668: End If;
669: End Loop;
670: Close c_route;

Line 722: fnd_msg_pub.add;

718: fnd_message.set_token('VALUE1',x_request_number);
719: fnd_message.set_token('VALUE2',conf_task_id(i));
720: fnd_message.set_token('VALUE3',l_product_number);
721: fnd_message.set_token('VALUE4',l_serial_number);
722: fnd_msg_pub.add;
723: Add_Err_Msg;
724: End If;
725:
726:

Line 848: fnd_msg_pub.add;

844: fnd_message.set_token('VALUE1',x_request_number);
845: fnd_message.set_token('VALUE2',conf_task_id(i));
846: fnd_message.set_token('VALUE3',l_product_number);
847: fnd_message.set_token('VALUE4',l_serial_number);
848: fnd_msg_pub.add;
849: Add_Err_Msg;
850: End If;
851:
852:

Line 889: FND_MSG_PUB.Count_And_Get

885: -- End of API body
886: --
887:
888: -- Standard call to get message count and if count is 1, get message info.
889: FND_MSG_PUB.Count_And_Get
890: ( p_count => x_msg_count,
891: p_data => x_msg_data
892: );
893: retcode := g_retcode;

Line 902: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

898: errbuf := X_Msg_Data;
899: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
900: P_API_NAME => L_API_NAME
901: ,P_PKG_NAME => G_PKG_NAME
902: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
903: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
904: ,X_MSG_COUNT => X_MSG_COUNT
905: ,X_MSG_DATA => X_MSG_DATA
906: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 914: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

910: errbuf := X_Msg_Data;
911: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
912: P_API_NAME => L_API_NAME
913: ,P_PKG_NAME => G_PKG_NAME
914: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
915: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
916: ,X_MSG_COUNT => X_MSG_COUNT
917: ,X_MSG_DATA => X_MSG_DATA
918: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1003: FND_MSG_PUB.initialize;

999: END IF;
1000:
1001:
1002: -- Initialize message list if p_init_msg_list is set to TRUE.
1003: FND_MSG_PUB.initialize;
1004:
1005:
1006: -- Initialize API return status to SUCCESS
1007: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1057: FND_MSG_PUB.Count_And_Get

1053: -- End of API body
1054: --
1055:
1056: -- Standard call to get message count and if count is 1, get message info.
1057: FND_MSG_PUB.Count_And_Get
1058: ( p_count => x_msg_count,
1059: p_data => x_msg_data
1060: );
1061: retcode := g_retcode;

Line 1070: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1066: errbuf := X_Msg_Data;
1067: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1068: P_API_NAME => L_API_NAME
1069: ,P_PKG_NAME => G_PKG_NAME
1070: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1071: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1072: ,X_MSG_COUNT => X_MSG_COUNT
1073: ,X_MSG_DATA => X_MSG_DATA
1074: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1081: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1077: errbuf := X_Msg_Data;
1078: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1079: P_API_NAME => L_API_NAME
1080: ,P_PKG_NAME => G_PKG_NAME
1081: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1082: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1083: ,X_MSG_COUNT => X_MSG_COUNT
1084: ,X_MSG_DATA => X_MSG_DATA
1085: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1168: FND_MSG_PUB.initialize;

1164: THEN
1165: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1166: END IF;
1167:
1168: FND_MSG_PUB.initialize;
1169:
1170: -- Initialize API return status to SUCCESS
1171: x_return_status := FND_API.G_RET_STS_SUCCESS;
1172:

Line 1207: fnd_msg_pub.add;

1203: x_interaction_id => x_interaction_id);
1204: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then
1205: fnd_message.set_name('CSF','CSF_PM_SR_UPDATE_ERROR');
1206: fnd_message.set_token('VALUE1',incident_rec.subject_id);
1207: fnd_msg_pub.add;
1208: Add_Err_Msg;
1209: ROLLBACK TO update_sr_tasks_pvt;
1210: Else
1211: cs_incidentlinks_pub.DELETE_INCIDENTLINK (

Line 1227: fnd_msg_pub.add;

1223: X_MSG_DATA => x_msg_data);
1224: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then
1225: fnd_message.set_name('CSF','CSF_PM_SR_LINK_DELETE_ERROR');
1226: fnd_message.set_token('VALUE1',incident_rec.subject_id);
1227: fnd_msg_pub.add;
1228: Add_Err_Msg;
1229: ROLLBACK TO update_sr_tasks_pvt;
1230: Else
1231: sr_update_success := TRUE;

Line 1256: fnd_msg_pub.add;

1252: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then
1253: fnd_message.set_name('CSF','CSF_PM_TASK_UPDATE_ERROR');
1254: fnd_message.set_token('VALUE1',incident_rec.subject_id);
1255: fnd_message.set_token('VALUE2',incident_rec.task_id);
1256: fnd_msg_pub.add;
1257: Add_Err_Msg;
1258: ROLLBACK TO update_sr_tasks_pvt;
1259: End If;
1260: End if;

Line 1268: FND_MSG_PUB.Count_And_Get

1264: -- End of API body
1265: --
1266:
1267: -- Standard call to get message count and if count is 1, get message info.
1268: FND_MSG_PUB.Count_And_Get
1269: ( p_count => x_msg_count,
1270: p_data => x_msg_data
1271: );
1272: retcode := g_retcode;

Line 1280: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1276: errbuf := X_Msg_Data;
1277: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1278: P_API_NAME => L_API_NAME
1279: ,P_PKG_NAME => G_PKG_NAME
1280: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1281: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1282: ,X_MSG_COUNT => X_MSG_COUNT
1283: ,X_MSG_DATA => X_MSG_DATA
1284: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1291: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1287: errbuf := X_Msg_Data;
1288: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1289: P_API_NAME => L_API_NAME
1290: ,P_PKG_NAME => G_PKG_NAME
1291: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1292: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
1293: ,X_MSG_COUNT => X_MSG_COUNT
1294: ,X_MSG_DATA => X_MSG_DATA
1295: ,X_RETURN_STATUS => X_RETURN_STATUS);