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.OKC_XPRT_QUESTION_PVT dependencies on FND_MSG_PUB

Line 738: FOR i IN 1 .. fnd_msg_pub.count_msg

734:
735:
736:
737:
738: FOR i IN 1 .. fnd_msg_pub.count_msg
739: LOOP
740: l_message := fnd_msg_pub.get (i, p_encoded => fnd_api.g_false);
741:
742:

Line 740: l_message := fnd_msg_pub.get (i, p_encoded => fnd_api.g_false);

736:
737:
738: FOR i IN 1 .. fnd_msg_pub.count_msg
739: LOOP
740: l_message := fnd_msg_pub.get (i, p_encoded => fnd_api.g_false);
741:
742:
743: IF LENGTH (l_message) + LENGTH (Nvl(x_message,' ')) <= 2500
744: THEN

Line 761: fnd_msg_pub.initialize;

757: ELSE
758: l_entity := 'CONSTANT';
759: END IF;
760:
761: fnd_msg_pub.initialize;
762:
763: IF p_action = 'CREATE' THEN
764: okc_api.set_message(p_app_name => g_app_name,
765: p_msg_name => 'OKC_I_CREATION_ENTITY_FAIL',

Line 783: l_message := fnd_msg_pub.get (1, p_encoded => fnd_api.g_false);

779: p_token1 => 'PROCEDURE',
780: p_token1_value => p_process
781: );
782:
783: l_message := fnd_msg_pub.get (1, p_encoded => fnd_api.g_false);
784: l_message := l_message || fnd_msg_pub.get (2, p_encoded => fnd_api.g_false);
785:
786: x_message := x_message ||' '||l_message;
787:

Line 784: l_message := l_message || fnd_msg_pub.get (2, p_encoded => fnd_api.g_false);

780: p_token1_value => p_process
781: );
782:
783: l_message := fnd_msg_pub.get (1, p_encoded => fnd_api.g_false);
784: l_message := l_message || fnd_msg_pub.get (2, p_encoded => fnd_api.g_false);
785:
786: x_message := x_message ||' '||l_message;
787:
788:

Line 818: fnd_msg_pub.initialize;

814:
815:
816:
817:
818: fnd_msg_pub.initialize;
819: default_row (p_xprt_question_rec => p_xprt_question_rec,
820: x_returns_status => l_return_status
821: );
822:

Line 828: -- x_msg_count := FND_MSG_PUB.Count_Msg;

824: IF l_return_status <> g_ret_sts_success
825: THEN
826:
827: x_return_status := l_return_status;
828: -- x_msg_count := FND_MSG_PUB.Count_Msg;
829: read_message( p_xprt_question_rec.qn_const_type
830: ,'DEFAULT_ROW'
831: , 'CREATE'
832: , x_msg_data);

Line 834: fnd_msg_pub.initialize;

830: ,'DEFAULT_ROW'
831: , 'CREATE'
832: , x_msg_data);
833:
834: fnd_msg_pub.initialize;
835: ROLLBACK TO create_question_sp;
836: RETURN;
837: END IF;
838:

Line 841: fnd_msg_pub.initialize;

837: END IF;
838:
839:
840: l_return_status := NULL;
841: fnd_msg_pub.initialize;
842: validate_row (p_xprt_question_rec => p_xprt_question_rec,
843: x_return_status => l_return_status
844: );
845:

Line 852: -- x_msg_count := FND_MSG_PUB.Count_Msg;

848: IF l_return_status <> g_ret_sts_success
849: THEN
850:
851: x_return_status := l_return_status;
852: -- x_msg_count := FND_MSG_PUB.Count_Msg;
853: read_message (p_xprt_question_rec.qn_const_type
854: ,'VALIDATE_ROW', 'CREATE',x_msg_data);
855: fnd_msg_pub.initialize;
856: ROLLBACK TO create_question_sp;

Line 855: fnd_msg_pub.initialize;

851: x_return_status := l_return_status;
852: -- x_msg_count := FND_MSG_PUB.Count_Msg;
853: read_message (p_xprt_question_rec.qn_const_type
854: ,'VALIDATE_ROW', 'CREATE',x_msg_data);
855: fnd_msg_pub.initialize;
856: ROLLBACK TO create_question_sp;
857: RETURN;
858: END IF;
859:

Line 861: fnd_msg_pub.initialize;

857: RETURN;
858: END IF;
859:
860: l_return_status := '';
861: fnd_msg_pub.initialize;
862:
863: insert_row
864: (p_question_id => p_xprt_question_rec.QN_CONST_id,
865: p_question_type => p_xprt_question_rec.QN_CONST_type,

Line 897: fnd_msg_pub.initialize;

893: THEN
894:
895: x_return_status := l_return_status;
896: read_message (p_xprt_question_rec.qn_const_type, 'INSERT_ROW', 'CREATE', x_msg_data);
897: fnd_msg_pub.initialize;
898: ROLLBACK TO create_question_sp;
899: RETURN;
900: END IF;
901:

Line 963: FND_MSG_PUB.initialize;

959: -- Update Last Update Login
960:
961: -- Assuming question id is passed for the update rec
962: -- If it is not passed need to derive it from the
963: FND_MSG_PUB.initialize;
964: BEGIN
965: SELECT question_type,
966: question_intent,
967: disabled_flag,

Line 1007: x_msg_data := fnd_msg_pub.get (1, p_encoded => fnd_api.g_false);

1003: p_msg_name => l_okc_i_invalid_value,
1004: p_token1 => l_field,
1005: p_token1_value => 'QUESTION_ID'
1006: );
1007: x_msg_data := fnd_msg_pub.get (1, p_encoded => fnd_api.g_false);
1008: FND_MSG_PUB.initialize;
1009: RETURN;
1010:
1011: WHEN OTHERS THEN

Line 1008: FND_MSG_PUB.initialize;

1004: p_token1 => l_field,
1005: p_token1_value => 'QUESTION_ID'
1006: );
1007: x_msg_data := fnd_msg_pub.get (1, p_encoded => fnd_api.g_false);
1008: FND_MSG_PUB.initialize;
1009: RETURN;
1010:
1011: WHEN OTHERS THEN
1012: x_return_status := g_ret_sts_unexp_error;

Line 1020: x_msg_data := fnd_msg_pub.get (1, p_encoded => fnd_api.g_false);

1016: p_token1 => G_SQLCODE_TOKEN,
1017: p_token1_value => sqlcode,
1018: p_token2 => G_SQLERRM_TOKEN,
1019: p_token2_value => sqlerrm);
1020: x_msg_data := fnd_msg_pub.get (1, p_encoded => fnd_api.g_false);
1021: FND_MSG_PUB.initialize;
1022: RETURN;
1023: END;
1024:

Line 1021: FND_MSG_PUB.initialize;

1017: p_token1_value => sqlcode,
1018: p_token2 => G_SQLERRM_TOKEN,
1019: p_token2_value => sqlerrm);
1020: x_msg_data := fnd_msg_pub.get (1, p_encoded => fnd_api.g_false);
1021: FND_MSG_PUB.initialize;
1022: RETURN;
1023: END;
1024:
1025: IF

Line 1035: x_msg_data := fnd_msg_pub.get (1, p_encoded => fnd_api.g_false);

1031: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1032: p_msg_name => 'OKC_I_NO_CHANGE',
1033: p_token1 => 'FIELD',
1034: p_token1_value => 'QUESTION_TYPE' );
1035: x_msg_data := fnd_msg_pub.get (1, p_encoded => fnd_api.g_false);
1036: FND_MSG_PUB.initialize;
1037: RETURN;
1038: END IF;
1039:

Line 1036: FND_MSG_PUB.initialize;

1032: p_msg_name => 'OKC_I_NO_CHANGE',
1033: p_token1 => 'FIELD',
1034: p_token1_value => 'QUESTION_TYPE' );
1035: x_msg_data := fnd_msg_pub.get (1, p_encoded => fnd_api.g_false);
1036: FND_MSG_PUB.initialize;
1037: RETURN;
1038: END IF;
1039:
1040:

Line 1045: FND_MSG_PUB.initialize;

1041:
1042: SAVEPOINT update_question_sp;
1043: -- Validate the attributes
1044: l_return_status := '';
1045: FND_MSG_PUB.initialize;
1046:
1047: l_return_status := G_RET_STS_SUCCESS;
1048: l_update_flag := okc_xprt_util_pvt.Ok_To_Delete_Question(p_question_id => p_xprt_update_question_rec.qn_const_id);
1049:

Line 1128: FND_MSG_PUB.initialize;

1124:
1125: IF l_return_status <> G_RET_STS_SUCCESS THEN
1126: x_return_status := G_RET_STS_ERROR;
1127: read_message(p_xprt_update_question_rec.qn_const_type,'UPDATE_QUESTION', 'UPDATE', x_msg_data);
1128: FND_MSG_PUB.initialize;
1129: ROLLBACK TO update_question_sp;
1130: return;
1131: END IF;
1132:

Line 1224: FND_MSG_PUB.initialize;

1220: IF l_ret_status <> G_RET_STS_SUCCESS
1221: THEN
1222: x_return_status := G_RET_STS_ERROR;
1223: read_message(p_xprt_update_question_rec.qn_const_type,'VALIDATE_ROW','UPDATE', x_msg_data);
1224: FND_MSG_PUB.initialize;
1225: ROLLBACK TO update_question_sp;
1226: RETURN;
1227: END IF;
1228:

Line 1273: x_msg_data := fnd_msg_pub.get (1, p_encoded => fnd_api.g_false);

1269: p_token1_value => sqlcode,
1270: p_token2 => G_SQLERRM_TOKEN,
1271: p_token2_value => sqlerrm);
1272:
1273: x_msg_data := fnd_msg_pub.get (1, p_encoded => fnd_api.g_false);
1274: ROLLBACK TO update_question_sp;
1275: END update_question;
1276: END okc_xprt_question_pvt;