DBA Data[Home] [Help]

APPS.HZ_ACCT_CREATE_PKG dependencies on FND_MSG_PUB

Line 142: FND_MSG_PUB.ADD;

138: IF x_rowid IS NULL THEN
139: FND_MESSAGE.SET_NAME('AR','HZ_API_NO_RECORD');
140: FND_MESSAGE.SET_TOKEN('RECORD',p_table_name);
141: FND_MESSAGE.SET_TOKEN('ID',p_col_id);
142: FND_MSG_PUB.ADD;
143: x_return_status := FND_API.G_RET_STS_ERROR;
144: ELSE
145: IF TO_CHAR(x_last_update_date,'DD-MON-YYYY HH:MI:SS') <>
146: TO_CHAR(l_last_update_date,'DD-MON-YYYY HH:MI:SS')

Line 150: FND_MSG_PUB.ADD;

146: TO_CHAR(l_last_update_date,'DD-MON-YYYY HH:MI:SS')
147: THEN
148: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
149: FND_MESSAGE.SET_TOKEN('TABLE', p_table_name);
150: FND_MSG_PUB.ADD;
151: x_return_status := FND_API.G_RET_STS_ERROR;
152: END IF;
153: END IF;
154: END;

Line 191: FND_MSG_PUB.ADD;

187: ELSE
188: FND_MESSAGE.SET_NAME('AR','HZ_API_NO_RECORD');
189: FND_MESSAGE.SET_TOKEN('RECORD','HZ_PARTIES');
190: FND_MESSAGE.SET_TOKEN('ID',p_party_id);
191: FND_MSG_PUB.ADD;
192: x_return_status := FND_API.G_RET_STS_ERROR;
193: END IF;
194: CLOSE cu_party_update;
195: EXCEPTION

Line 202: FND_MSG_PUB.ADD;

198: CLOSE cu_party_update;
199: END IF;
200: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
201: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
202: FND_MSG_PUB.ADD;
203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
204: END;
205:
206: PROCEDURE SetFlagRelationship

Line 1067: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

1063:
1064:
1065: IF x_msg_count > 1 THEN
1066: FOR i IN 1..x_msg_count LOOP
1067: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1068: tmp_var1 := tmp_var1 || ' '|| tmp_var;
1069: END LOOP;
1070: x_msg_data := tmp_var1;
1071: END IF;

Line 1100: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

1096: x_msg_data => x_msg_data
1097: );
1098: IF x_msg_count > 1 THEN
1099: FOR i IN 1..x_msg_count LOOP
1100: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1101: tmp_var1 := tmp_var1 || ' '|| tmp_var;
1102: END LOOP;
1103: x_msg_data := tmp_var1;
1104: END IF;

Line 1140: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

1136: );
1137:
1138: IF x_msg_count > 1 THEN
1139: FOR i IN 1..x_msg_count LOOP
1140: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1141: tmp_var1 := tmp_var1 || ' '|| tmp_var;
1142: END LOOP;
1143: x_msg_data := tmp_var1;
1144: END IF;

Line 1180: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

1176:
1177:
1178: IF x_msg_count > 1 THEN
1179: FOR i IN 1..x_msg_count LOOP
1180: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1181: tmp_var1 := tmp_var1 || ' '|| tmp_var;
1182: END LOOP;
1183: x_msg_data := tmp_var1;
1184: END IF;

Line 1730: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

1726: x_msg_data => x_msg_data );
1727:
1728: IF x_msg_count > 1 THEN
1729: FOR i IN 1..x_msg_count LOOP
1730: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1731: tmp_var1 := tmp_var1 || ' '|| tmp_var;
1732: END LOOP;
1733: x_msg_data := tmp_var1;
1734: END IF;

Line 1763: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

1759: x_msg_data => x_msg_data
1760: );
1761: IF x_msg_count > 1 THEN
1762: FOR i IN 1..x_msg_count LOOP
1763: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1764: tmp_var1 := tmp_var1 || ' '|| tmp_var;
1765: END LOOP;
1766: x_msg_data := tmp_var1;
1767: END IF;

Line 1794: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

1790: x_msg_data => x_msg_data
1791: );
1792: IF x_msg_count > 1 THEN
1793: FOR i IN 1..x_msg_count LOOP
1794: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1795: tmp_var1 := tmp_var1 || ' '|| tmp_var;
1796: END LOOP;
1797: x_msg_data := tmp_var1;
1798: END IF;

Line 1828: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

1824: x_end_date => SYSDATE);
1825:
1826: IF x_msg_count > 1 THEN
1827: FOR i IN 1..x_msg_count LOOP
1828: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1829: tmp_var1 := tmp_var1 || ' '|| tmp_var;
1830: END LOOP;
1831: x_msg_data := tmp_var1;
1832: END IF;

Line 2173: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

2169: x_msg_data => x_msg_data
2170: );
2171: IF x_msg_count > 1 THEN
2172: FOR i IN 1..x_msg_count LOOP
2173: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
2174: tmp_var1 := tmp_var1 || ' '|| tmp_var;
2175: END LOOP;
2176: x_msg_data := tmp_var1;
2177: END IF;

Line 2279: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

2275: );
2276:
2277: IF x_msg_count > 1 THEN
2278: FOR i IN 1..x_msg_count LOOP
2279: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
2280: tmp_var1 := tmp_var1 || ' '|| tmp_var;
2281: END LOOP;
2282: x_msg_data := tmp_var1;
2283: END IF;

Line 2318: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

2314: x_msg_data => x_msg_data );
2315:
2316: IF x_msg_count > 1 THEN
2317: FOR i IN 1..x_msg_count LOOP
2318: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
2319: tmp_var1 := tmp_var1 || ' '|| tmp_var;
2320: END LOOP;
2321: x_msg_data := tmp_var1;
2322: END IF;

Line 2438: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

2434: );
2435:
2436: IF x_msg_count > 1 THEN
2437: FOR i IN 1..x_msg_count LOOP
2438: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
2439: tmp_var1 := tmp_var1 || ' '|| tmp_var;
2440: END LOOP;
2441: x_msg_data := tmp_var1;
2442: END IF;

Line 2472: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

2468: x_msg_data => x_msg_data
2469: );
2470: IF x_msg_count > 1 THEN
2471: FOR i IN 1..x_msg_count LOOP
2472: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
2473: tmp_var1 := tmp_var1 || ' '|| tmp_var;
2474: END LOOP;
2475: x_msg_data := tmp_var1;
2476: END IF;

Line 2520: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

2516: );
2517:
2518: IF x_msg_count > 1 THEN
2519: FOR i IN 1..x_msg_count LOOP
2520: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
2521: tmp_var1 := tmp_var1 || ' '|| tmp_var;
2522: END LOOP;
2523: x_msg_data := tmp_var1;
2524: END IF;

Line 2570: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

2566: );
2567:
2568: IF x_msg_count > 1 THEN
2569: FOR i IN 1..x_msg_count LOOP
2570: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
2571: tmp_var1 := tmp_var1 || ' '|| tmp_var;
2572: END LOOP;
2573: x_msg_data := tmp_var1;
2574: END IF;

Line 2614: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

2610: x_end_date => x_end_date );
2611:
2612: IF x_msg_count > 1 THEN
2613: FOR i IN 1..x_msg_count LOOP
2614: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
2615: tmp_var1 := tmp_var1 || ' '|| tmp_var;
2616: END LOOP;
2617: x_msg_data := tmp_var1;
2618: END IF;