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

Line 65: FND_MSG_PUB.Initialize; -- Initializes the message list that stores the errors

61:
62: BEGIN
63:
64: x_msg_count := NULL;
65: FND_MSG_PUB.Initialize; -- Initializes the message list that stores the errors
66:
67: x_return_status := FND_API.G_RET_STS_SUCCESS;
68: --
69: -- Verifies if the party_code in xtr_party_info is not same as the bank_code in xtr_bank_accounts

Line 116: FND_MSG_PUB.Count_And_Get -- Returns the error message if there is only 1 error

112: xtr_risk_debug_pkg.dpop('xtr_replicate_bank_accounts_P: '||'Replicate_Bank_Accounts');
113: END IF;
114: --
115:
116: FND_MSG_PUB.Count_And_Get -- Returns the error message if there is only 1 error
117: ( p_count => x_msg_count ,
118: p_data => x_msg_data
119: );
120: --

Line 125: FND_MSG_PUB.Count_And_Get -- Returns the error message if there is only 1 error

121: EXCEPTION
122: WHEN others THEN
123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
124: LOG_ERR_MSG('XTR_UNEXP_ERROR',SQLERRM(SQLCODE));
125: FND_MSG_PUB.Count_And_Get -- Returns the error message if there is only 1 error
126: ( p_count => x_msg_count ,
127: p_data => x_msg_data
128: );
129: END REPLICATE_BANK_ACCOUNTS;

Line 231: FND_MSG_PUB.Count_And_Get -- Returns the error message if there is only 1 error

227: EXCEPTION
228: WHEN others THEN
229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
230: LOG_ERR_MSG('XTR_UNEXP_ERROR',SQLERRM(SQLCODE));
231: FND_MSG_PUB.Count_And_Get -- Returns the error message if there is only 1 error
232: ( p_count => x_msg_count ,
233: p_data => x_msg_data
234: );
235: END REPLICATE_BANK_ACCOUNTS;

Line 839: FND_MSG_PUB.Add; -- Adds the error messages to the list.

835: FETCH c_field_name INTO l_field_name;
836: CLOSE c_field_name;
837: FND_MESSAGE.Set_Name('XTR','XTR_MANDATORY_FIELD');
838: FND_MESSAGE.Set_Token('FIELD', l_field_name);
839: FND_MSG_PUB.Add; -- Adds the error messages to the list.
840:
841: ELSIF p_error_code = 'XTR_INV_TRS_PRICING_MODEL' THEN
842:
843: FND_MESSAGE.Set_Name('XTR','XTR_INV_TRS_PRICING_MODEL');

Line 844: FND_MSG_PUB.Add; -- Adds the error messages to the list.

840:
841: ELSIF p_error_code = 'XTR_INV_TRS_PRICING_MODEL' THEN
842:
843: FND_MESSAGE.Set_Name('XTR','XTR_INV_TRS_PRICING_MODEL');
844: FND_MSG_PUB.Add; -- Adds the error messages to the list.
845:
846: ELSIF p_error_code = 'XTR_INV_CC_ID' THEN
847:
848: FND_MESSAGE.Set_Name('XTR','XTR_INV_CC_ID');

Line 849: FND_MSG_PUB.Add; -- Adds the error messages to the list.

845:
846: ELSIF p_error_code = 'XTR_INV_CC_ID' THEN
847:
848: FND_MESSAGE.Set_Name('XTR','XTR_INV_CC_ID');
849: FND_MSG_PUB.Add; -- Adds the error messages to the list.
850:
851: ELSIF p_error_code = 'XTR_UNIQUE_ACCOUNT' THEN -- bug 4870353
852:
853: FND_MESSAGE.Set_Name('XTR','XTR_UNIQUE_ACCOUNT');

Line 854: FND_MSG_PUB.Add;

850:
851: ELSIF p_error_code = 'XTR_UNIQUE_ACCOUNT' THEN -- bug 4870353
852:
853: FND_MESSAGE.Set_Name('XTR','XTR_UNIQUE_ACCOUNT');
854: FND_MSG_PUB.Add;
855:
856: ELSIF p_error_code = 'XTR_UNEXP_ERROR' THEN
857:
858: FND_MESSAGE.Set_Name('XTR','XTR_UNEXP_ERROR');

Line 861: FND_MSG_PUB.Add; -- Adds the error messages to the list.

857:
858: FND_MESSAGE.Set_Name('XTR','XTR_UNEXP_ERROR');
859: FND_MESSAGE.Set_Token('SQLCODE', p_field_name);
860: --FND_MESSAGE.Set_Token('SQLSTATE', p_field_name2);
861: FND_MSG_PUB.Add; -- Adds the error messages to the list.
862:
863: ELSIF p_error_code = 'XTR_INV_LE_COMP_CODE' THEN
864:
865: FND_MESSAGE.Set_Name('XTR','XTR_INV_LE_COMP_CODE');

Line 867: FND_MSG_PUB.Add; -- Adds the error messages to the list.

863: ELSIF p_error_code = 'XTR_INV_LE_COMP_CODE' THEN
864:
865: FND_MESSAGE.Set_Name('XTR','XTR_INV_LE_COMP_CODE');
866: FND_MESSAGE.Set_Token('LEGAL_ENTITY', p_field_name);
867: FND_MSG_PUB.Add; -- Adds the error messages to the list.
868:
869: ELSIF p_error_code = 'CHK_LOCK' THEN
870:
871: FND_MESSAGE.Set_Name('XTR','XTR_1999');

Line 872: FND_MSG_PUB.Add; -- Adds the error messages to the list.

868:
869: ELSIF p_error_code = 'CHK_LOCK' THEN
870:
871: FND_MESSAGE.Set_Name('XTR','XTR_1999');
872: FND_MSG_PUB.Add; -- Adds the error messages to the list.
873:
874: ELSIF p_error_code = 'XTR_INV_PARAM' THEN
875:
876: FND_MESSAGE.Set_Name('XTR','XTR_INV_PARAMETER');

Line 878: FND_MSG_PUB.Add; -- Adds the error messages to the list.

874: ELSIF p_error_code = 'XTR_INV_PARAM' THEN
875:
876: FND_MESSAGE.Set_Name('XTR','XTR_INV_PARAMETER');
877: FND_MESSAGE.Set_Token('FIELD', p_field_name);
878: FND_MSG_PUB.Add; -- Adds the error messages to the list.
879:
880: ELSIF p_error_code = 'XTR_DEFAULT_ACCT' THEN
881:
882: FND_MESSAGE.Set_Name('XTR','XTR_1676');

Line 883: FND_MSG_PUB.Add; -- Adds the error messages to the list.

879:
880: ELSIF p_error_code = 'XTR_DEFAULT_ACCT' THEN
881:
882: FND_MESSAGE.Set_Name('XTR','XTR_1676');
883: FND_MSG_PUB.Add; -- Adds the error messages to the list.
884:
885: ELSIF p_error_code = 'XTR_CHK_30_BOTH' THEN
886:
887: FND_MESSAGE.Set_Name('XTR','XTR_CHK_30_BOTH');

Line 888: FND_MSG_PUB.Add; -- Adds the error messages to the list.

884:
885: ELSIF p_error_code = 'XTR_CHK_30_BOTH' THEN
886:
887: FND_MESSAGE.Set_Name('XTR','XTR_CHK_30_BOTH');
888: FND_MSG_PUB.Add; -- Adds the error messages to the list.
889:
890: ELSIF p_error_code = 'XTR_INV_BANK_BRANCH' THEN
891:
892: FND_MESSAGE.Set_Name('XTR','XTR_INV_BANK_BRANCH');

Line 894: FND_MSG_PUB.Add; -- Adds the error messages to the list.

890: ELSIF p_error_code = 'XTR_INV_BANK_BRANCH' THEN
891:
892: FND_MESSAGE.Set_Name('XTR','XTR_INV_BANK_BRANCH');
893: FND_MESSAGE.Set_Token('TCA_BANK_BRANCH_NAME', p_field_name);
894: FND_MSG_PUB.Add; -- Adds the error messages to the list.
895:
896: ELSIF p_error_code = 'XTR_ACCT_NAME_MANDATORY' THEN
897:
898: FND_MESSAGE.Set_Name('XTR','XTR_ACCT_NAME_MANDATORY');

Line 899: FND_MSG_PUB.Add; -- Adds the error messages to the list.

895:
896: ELSIF p_error_code = 'XTR_ACCT_NAME_MANDATORY' THEN
897:
898: FND_MESSAGE.Set_Name('XTR','XTR_ACCT_NAME_MANDATORY');
899: FND_MSG_PUB.Add; -- Adds the error messages to the list.
900:
901: ELSIF p_error_code = 'XTR_CURRENCY_MANDATORY' THEN
902:
903: FND_MESSAGE.Set_Name('XTR','XTR_CURRENCY_MANDATORY');

Line 904: FND_MSG_PUB.Add; -- Adds the error messages to the list.

900:
901: ELSIF p_error_code = 'XTR_CURRENCY_MANDATORY' THEN
902:
903: FND_MESSAGE.Set_Name('XTR','XTR_CURRENCY_MANDATORY');
904: FND_MSG_PUB.Add; -- Adds the error messages to the list.
905:
906: ELSIF p_error_code = 'XTR_LOCATION_MANDATORY' THEN
907:
908: FND_MESSAGE.Set_Name('XTR','XTR_LOCATION_MANDATORY');

Line 909: FND_MSG_PUB.Add; -- Adds the error messages to the list.

905:
906: ELSIF p_error_code = 'XTR_LOCATION_MANDATORY' THEN
907:
908: FND_MESSAGE.Set_Name('XTR','XTR_LOCATION_MANDATORY');
909: FND_MSG_PUB.Add; -- Adds the error messages to the list.
910:
911: ELSIF p_error_code = 'XTR_STREET_MANDATORY' THEN
912:
913: FND_MESSAGE.Set_Name('XTR','XTR_STREET_MANDATORY');

Line 914: FND_MSG_PUB.Add; -- Adds the error messages to the list.

910:
911: ELSIF p_error_code = 'XTR_STREET_MANDATORY' THEN
912:
913: FND_MESSAGE.Set_Name('XTR','XTR_STREET_MANDATORY');
914: FND_MSG_PUB.Add; -- Adds the error messages to the list.
915:
916: ELSIF p_error_code = 'XTR_ACCT_OWNER_MANDATORY' THEN
917:
918: FND_MESSAGE.Set_Name('XTR','XTR_ACCT_OWNER_MANDATORY');

Line 919: FND_MSG_PUB.Add; -- Adds the error messages to the list.

915:
916: ELSIF p_error_code = 'XTR_ACCT_OWNER_MANDATORY' THEN
917:
918: FND_MESSAGE.Set_Name('XTR','XTR_ACCT_OWNER_MANDATORY');
919: FND_MSG_PUB.Add; -- Adds the error messages to the list.
920:
921: ELSIF p_error_code = 'XTR_ACCOUNT_MANDATORY_FIELD' THEN
922:
923: FND_MESSAGE.Set_Name('XTR','XTR_ACCOUNT_MANDATORY_FIELD');

Line 924: FND_MSG_PUB.Add; -- Adds the error messages to the list.

920:
921: ELSIF p_error_code = 'XTR_ACCOUNT_MANDATORY_FIELD' THEN
922:
923: FND_MESSAGE.Set_Name('XTR','XTR_ACCOUNT_MANDATORY_FIELD');
924: FND_MSG_PUB.Add; -- Adds the error messages to the list.
925:
926:
927:
928:

Line 1007: FND_MSG_PUB.Initialize; -- Initializes the message list that stores the errors

1003: l_ce_bank_account_id XTR_BANK_ACCOUNTS.ce_bank_account_id%TYPE;--change this
1004:
1005: BEGIN
1006: x_msg_count := NULL;
1007: FND_MSG_PUB.Initialize; -- Initializes the message list that stores the errors
1008:
1009: x_return_status := FND_API.G_RET_STS_SUCCESS;
1010: -- Verifies if the ce_bank_account_id in XTR_BANK_ACCOUNTS is passed as null
1011: IF(p_ce_bank_account_id is null) THEN

Line 1047: FND_MSG_PUB.Count_And_Get -- Returns the error message if there is only 1 error

1043:
1044: END IF;
1045:
1046: END IF;
1047: FND_MSG_PUB.Count_And_Get -- Returns the error message if there is only 1 error
1048: ( p_count => x_msg_count ,
1049: p_data => x_msg_data
1050: );
1051: EXCEPTION

Line 1058: FND_MSG_PUB.Count_And_Get -- Returns the error message if there is only 1 error

1054: close c_CHK_LOCK_INTEREST;
1055: end if;
1056: LOG_ERR_MSG('CHK_LOCK');
1057: x_return_status := FND_API.G_RET_STS_ERROR;
1058: FND_MSG_PUB.Count_And_Get -- Returns the error message if there is only 1 error
1059: ( p_count => x_msg_count ,
1060: p_data => x_msg_data
1061: );
1062: --app_exceptions.RECORD_LOCK_EXCEPTION;

Line 1066: FND_MSG_PUB.Count_And_Get -- Returns the error message if there is only 1 error

1062: --app_exceptions.RECORD_LOCK_EXCEPTION;
1063: WHEN others THEN
1064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1065: LOG_ERR_MSG('XTR_UNEXP_ERROR',SQLERRM(SQLCODE));
1066: FND_MSG_PUB.Count_And_Get -- Returns the error message if there is only 1 error
1067: ( p_count => x_msg_count ,
1068: p_data => x_msg_data
1069: );
1070: